Excel automation sql jobs
The project entails accurate entry of numerical data into an MS Excel spreadsheet, with a focus on report generation. The ideal freelancer should be well-versed with basic Excel functionalities, such as simulations and formulas, to ensure efficient data processing. Key responsibilities would include: - Accurate and efficient numerical data entry - Setting up Excel to run basic simulations and formulas - Generating effective and accurate reports from entered data The freelancer should have strong attention to detail to maintain data accuracy and proficiency in MS Excel, specifically in creating basic simulations and formulas. Previous experience in data entry and report generation is highly preferred.
I've devised a dummy website primary for understanding log analysis which is a major concern in today's advanced technology world. To test its vulnerabilities, I require a well-rounded professional equipped with proficiency in PHP and Node.js. - Focus Area: Your tasks will encompass SQL injection techniques over my website's user login systems, data retrieving systems, and contact forms. - Skill Set: An experience with SQL injection tests is crucial. Knowledge of web technologies such as PHP and Node.js is essential. Understanding of website log analysis will also be advantageous. Your comprehensive reports on the performed tests and findings will enhance the robustness of my website and will aid in my understanding of the log analysis for future developmen...
I'm looking for an experienced SQL Developer with a strong background in MS SQL and data warehousing. You'll be responsible for designing and optimizing a new database system. The project involves working with Microsoft SQL Server Analysis Services in an Azure SQL environment. Key Responsibilities: - Designing a new database system - Optimizing queries for better performance - Utilizing Microsoft SQL Server Analysis Services - Ideal Candidate: - Strong experience in database design and optimization - Proficiency in SQL, specifically with Microsoft SQL Server - Familiarity with data warehousing concepts - Experience with Microsoft SQL Server Analysis Services - Experience working in an Azure SQL environment - Exper...
I'm seeking a Python expert to assist with developing network automation scripts. The ideal candidate will have significant experience in networking and automation. Key Responsibilities: - Developing automation scripts for networking tasks - Ensuring the scripts are efficient and reliable Skills and Experience: - Proven track record in Python development - In-depth understanding of networking concepts - Experience in developing automation scripts - Strong problem-solving skills - Ability to work independently and efficiently The successful completion of this project will require a freelancer who is able to think critically and has a strong understanding of both Python and networking. I have a networking error I need fixed in my python code, I can pm yo...
I'm in need of an expert in automation testing to build a suite in Cypress specifically for page having HTML. The page to be tested will be rendered on a browser, requiring expertise in browser-based testing. Key Elements: - Develop a Cypress automation suite for testing purposes. - NodeJS expertise Skills and Experience required: - Proficient in Cypress and JavaScript. - Experience in browser-based automation testing. - Knowledge in specific client-based functional testing. Additional details: Values from the HTML page have to be validated after selecting them using selectors. Once validated these values read from the page need to be appended to a file. The selections used need to be easily configurable.
I require a professional with a keen understanding of both Excel and iOS Numbers to convert a single-sheet Excel spreadsheet into an iOS Numbers document. The converted document will need to retain multiple functionalities including: - Basic calculations - Data visualization - Conditional formatting No data interdependency or connectivity with other aspects is required in this case. The ideal candidate should have significant experience with data conversion between these two platforms and a solid grasp of maintaining functionalities in iOS Numbers. Familiarity with creating visually engaging spreadsheets will be highly regarded. I would like to have conversation with someone to make sure I am asking for something reasonable and to clarify exactly whats needed. TY
...to work with me to achieve great rankings. If I say something needs tweaked a bit, I expect the team to listen to my desires as long as those desires will reach the end goal. While working on the main keywords, I expect additional keyword phrases to be used in Chat GDP blog and wiki articles that would benefit the website. That way not all backlinks will be from the list of 20. We can use our excel sheet from previous projects for this. I should see a drastic increase in DA and PA of the website. Post the phrase #seoGuru so I know you read and understand and agree to these terms. Post the sentence in your bid: "I understand and agree to the terms and conditions set forth in the project description. I agree that not following instructions will be grounds for termination a...
I have a baseline construction schedule built already; it has around 1000 activities, the schedule is cost & resource loaded. I will provide the update in excel (actual start, actual finish, actual cost), the monthly activities that needed to be updated (actual date & Cost) around 100 activities every month. Please note sometimes I need to provide you comments on the schedule update, so you need to fix the comments. I need you to update the start/finish date and insert the actual cost monthly (once every month). Plus, prepare small narrative report including some P6 PdF. I have the P6 layouts I will share with you. I have the report and layout built in already and I will share it with you. Finally, send me XER file, and Narrative report every month. It is very important y...
I a...with sales automation on Pipe Drive. - You will primarily be responsible for improving our sales conversion rate. This involves optimizing the various processes involved in sales, from the initial lead generation to closing the deal. - Your expertise in Pipe Drive will be crucial in setting up a system that effectively automates these sales processes without sacrificing the quality of our customer interactions. - The ideal candidate is someone who has experience working with Pipe Drive, particularly in the area of sales automation. - Familiarity with social media and website lead generation will be a big plus, as these are the primary channels we are focusing on. Ultimately, the goal of this project is to increase our sales efficiency and effectiveness through the pow...
I am in need of an Excel relational database. The database should have the functionality to enter values automatically from an attached worksheet. The entry of these values will be based on specific criteria, more specifically, column values. Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, management, and optimization - Understanding of data entry and data analysis - Proven experience in creating reporting capabilities within Excel. Using the "Reference data" tab, when the value in Column B is entered in the "Example worksheet" the corresponding values should automatically populate - Tariff code, Duty rate, CPF.
LOOK AT THE FIL...arguing that information and understanding can be a powerful tool against discrimination. Your proposal will demonstrate: - Deep understanding of the problem: the struggles parolees face when trying to secure housing - Clear plan of action: how community awareness programs can alleviate this issue - Benefits: how reducing discrimination could lead to a more inclusive and supportive society To excel in this project, you should have: - Exceptional skills in persuasive writing - Knowledge of recent legislature related to housing and parolees - An understanding of discrimination in housing applications - Experience in generating community-based solutions or policies Let's build a case to uplift this marginalized group, charting a path to fair and inclusive hou...
I'm in need of an Excel expert who can help me create a sophisticated formula for data analysis. The data I'm working with is moderately complex, involving multiple variables. It's all housed in Excel spreadsheets. Ideal Skills and Experience: - Proficiency in Excel, with a focus on complex data analysis - Experience in creating advanced formulas for data manipulation - Strong understanding of data structures in Excel and how to work with multiple variables - Previous projects involving statistical analysis would be an advantage I'm looking for someone who can not only create this formula, but also explain its function and how to adjust it for future data sets. Please provide examples of similar projects you've worked on in the past...
Looking for a talented Full-Stack Dev Team, ready to take College Recruit Pro to the next level. Our needs are vast, as such, expertise in AWS, SQL, React, Django, Flutter and other relevant technologies is strongly desired. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Introduction: Join us at College Recruit Pro as we aim to revolutionize the collegiate athlete recruitment process. We seek an experienced Full-Stack Development Team to finalize critical functionalities and prepare for future mobile app development. This remote contract opportunity may lead to a full-time hire based on performance. Project Overview: College Recruit Pro is in a soft deployme...
I'm in need of a Java developer to create a standalone application for a small school. The application will be used to manage student records, various school resources, and facilitate communication with parents. Key Features: - Student Records: The application should be able to manage and track student progress through interactive line charts. - School Resources: The app should also help ...development, previous experience in creating similar applications, and are confident in managing school resources and building a parent communication portal, feel free to bid on this project. I would need a preliminary discussion to assess the possible architecture/technologies. The initial bid if for the first module (main page, students list, DB, add/edit/delete students, load student data fr...
I need an intricate Excel model to calculate a cumulative threshold commission scheme, tailored to three varying levels of seniority: Junior, Mid-level, and Senior. The model needs to be exceptionally flexible and versatile to allow for easy manipulation and scenario planning. Key Requirements: - Create a multi-level commission scheme: The model should have different commission percentages for each level of seniority. - Cumulative Threshold Calculation: Incorporate a mechanism to calculate cumulative thresholds. - Revenue Generation Calculation: Develop an accurate formula that calculates the revenue generated. - Flexibility in Threshold Percentage: Ensure that the threshold percentage can be flexed. - Cash Retained in the Business: The final model should account for cash retained...
I am in need of an interactive Python dashboard to help me track the performance of multiple departments. The dashboard will be focused on week-over-week performance data, sourced from a data file to build it out then linked to BQ via SQL Code. I'm primarily interested in tracking the following metrics: - Case Per Hour week over week for various departments, and types of CPH. - Volumes and hours used per job process The ideal freelancer for this project should be proficient in Python and have experience in creating engaging and informative dashboards. Experience in data visualization and the ability to source and manipulate data will be important to ensure the dashboard is intuitive and accurate. Please note that the data is to be pulled from a data file, and I would like t...
I need an expert in Excel spreadsheet and dashboard creation to help me with a project related to the management of properties. The project involves the following tasks: - Data analysis - Formulas and calculations - Data visualization The data to be used in this project will mainly revolve around a situation room containing property under management status and updates. Specifically, the dashboard should track and monitor the following key metrics: - Rent collection and payout status - Tenant and business complaints - Contacts details - Contracts status - Property profits - Property location - Owner notes - Comments If possible to have it as geolocation kml as a copy I'm looking for someone with strong experience in creating dashboards and spreadsheets, particularly in...
...developer with expertise in using Python for backend development, JavaScript and HTML for frontend. Key Components: - Backend programming using Python - Frontend programming implemented with JavaScript and HTML Key Functionalities: - Database Integration: The software developer should be able to create a seamless link to an existing database and enable secure data exchanges. there is already excel .xlsx file in the folder - API Integration: The project includes integration of specific APIs to provide essential functionality for the Web Application. Purpose of the Project: - The main goal for this project is to develop a functional web application and host it either on a server or GitHub. The application isn’t static and employs IT-technical features. Ideal candidates ...
I have the attached images , I need it to be in excel form.
Looking for a CPA from Philippines with strong English skills, multi-years work experience in Xero, QBO, MYOB, Sage for US/Australia/NZ companies. Tax filing experience would be an added skill. Overall engagement would start small but can grow into a full time eng...skill. Overall engagement would start small but can grow into a full time engagement depending on the quality of work delivered. The role would entail shift working and the work hours will be a function of client requirements. (PH night shift/early morning shift). Only looking at Individual Freelancers, team bids will be rejected. If this description excites you, happy to chat. Experience in automation in accounting and comfort with writing accounting / finance content preferred. The price range quoted is monthly pr...
We have a large internal-use-only business automation site, that our staff uses 24/7. We have some 70 pages. The design of them is very simple and we want to improve it. We need to unify the design of the pages and make them more visually appealing and also easier to use and clearer for our staff. This job is NOT to design the entire site, it's just to review what we have and send us a sample of how you could help us redesign. We will pay for 2 or 3 hours of work here, from several selected vendors, and then choose the one that we like to finish the job.
I am in need of a proficient data entry operator, for a smaller task of less than 100 entries. The data will be provided to you in the form of scanned documents and you will be required to interpret and enter this data accurately into an Excel worksheet. - You should have experience with data entry from scanned documents into Excel and attention to detail is of utmost importance here. - Understanding of Excel basics is also required for successful execution of the task. - The format of data delivery will be an Excel worksheet. Proficiency in English and a strong attention to detail would be ideal attributes for this task.
I'm in need of a skilled Excel professional to assist with data analysis tasks. The primary focus will be on trend analysis and results should be presented in the form of detailed reports. Key requirements include: - Proficient in data analysis using Excel - Experience with creating reports - Attention to detail - Ability to communicate complex data in a clear and concise manner Please only apply if you have experience in trend analysis and report generation using Excel.
I am in immediate need of an Excel specialist who is well-versed in formula troubleshooting and fixing. There are 4 formulas that require attention; unfortunately, I am unable to enumerate them as I skipped that information. However, here's what I can provide: - Detailed description of how each formula should function - Expectations for the fixes I'm looking for individuals who are confident they can rectify the issues and can offer neoteric solutions. This project requires more than just experience, a resourceful approach to problem-solving is necessary. The application must include: - Detailed project proposal The proposal should provide clear insight into your troubleshooting steps, planned adjustments, and method of testing the new formulas. Time efficiency, ...
I am looking for a freelancer to assist me with a typing project. The project involves typing more than 100 pages of PDF documents. Requirements: - Proficient in typing and attention to detail - Ability to follow instructions and work independently - Experience with typing PDF documents is preferred but not required Specifics: - The documents do not require any specific formatting and can be typed in any standard format. - The freelancer has the freedom to choose the most suitable formatting for the documents. Skills and Experience: - Excellent typing speed and accuracy - Strong attention to detail - Ability to work independently and meet deadlines Please provide a sample of your previous typing work. Thank you for your interest in this project!
I'm looking for an experienced Python developer with knowledge in SAN switch health checks to write a script for automating my Cisco switch health checkup. The script will need to automate several tasks including: - Gathering output of overall switch health - Checking the conditions of each hardware status - send an automatic email via outlook I would like to see applicants demonstrate their experience in writing similar scripts, and especially in performing SAN switch health checks. Your familiarity with Python scripting and Cisco products will be vital for this project. Your application should reflect your past experience in the area. I am eager to see your detailed project proposals to assist in making an informed decision. Is this a task you can confidently deliver? Take your sh...
I am seeking a developer to create an Excel-based order placement tool for TradeStation, utilizing EasyLanguage. This tool will be designed to execute trades based on alerts from a specific indicator and strategy. Key functionalities should include support for OCO (One Cancels the Other), OSO (One Sends Other), and Basket orders. This is a fixed-price project. Payments will be released upon successful completion of predefined milestones. Please contact me if you're interested in this opportunity.
I'm looking for a skilled developer who can create a web application that can read data from multiple sources like Excel files, XML files, and APIs, and then match, aggregate, and save this data to a database. Requirements: - The web app should be able to read data from Excel files, XML files, and APIs. - The application should have the capability to match and aggregate data from these different sources based on specific fields, data types, and unique identifiers. - The end goal of the data matching and aggregation is to save the data into a database. Ideal candidate should: - Have experience in developing web applications that work with various data sources - Be proficient in database management and data aggregation techniques - Be able to write clean and maintainable...
I need a reliable Python expert who can create a script that automates text extraction from specific PDF files and insert results into a PostgreSQL database. This tool is essential for a new automation process and accuracy is vital. The successful candidate will develop a script that: - Accepts a list of PDF objects (standardized format, example files will be provided) - Performs text recognition and extracts text from the listed PDFs - Inserts the extracted results into a PostgreSQL database In terms of output format, the extracted text needs to be integrated into a PostgreSQL Database. I'm open to suggestions on the specific table structure for this database. Should there be file reading errors or instances of unsuccessful text extraction, the script should be designed to...
I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.
I need a backend api (or program) that running on java or .net that can send messages via facebook messenger (do not use Facebook APIs) using Selenium or other automation frameworks you are familiar with (if you use other automation frameworks, you must notify me for confirmation). Key features: 1. Log in with the provided the user/password. 2. Send messages to specific Facebook users with provided information. 3. Send Messages from more than 2 senders to specified receiver in a short time. 4. Receive messages from Facebook users in real time (can get username information, message content). 5. Facebook will not block messages for spam reasons (the limitation is defined by you). Must-have skills: Java (familiar with Spring Boot) or C# programming skills (familiar with .Net cor...
I'm searching for a proficient developer to create a trading bot that operates on the Dhan platform. This bot must be integrated with Excel. Key Features: - It should have the functionality to automate trades based on calculations of quantities on a predefined Stop Loss (SL). - Its operation will involve using fixed quantities for all trades, regardless of SL level. Ideal Skills: - Experience in bot creation. - Knowledgeable about the Dhan trading platform and Microsoft Excel. - Strong understanding of trading algorithms and risk management. Your bid will be more competitive if you have previously done similar projects and can show a portfolio or examples of your work.
I am seeking an experienced data entry specialist to assist me with both digital and manual input into Microsoft Excel. The ideal freelancer will provide assistance with data extraction, cleaning, and verification to ensure accuracy and consistency of the data. Skills and experience required: - Proficient in digital and manual data entry - Expert in Microsoft Excel - Experience in data extraction, cleaning, and verification - Strong attention to detail - Ability to handle large amounts of data. The primary objective of this project is to manage and organize data efficiently. I'm expecting a high level of precision on the data entered. The candidate should be able to demonstrate experience in handling both digital and manual data entry jobs.
I am an focal point of technology with an oil & gas upstream company seeking a skilled developer to create a comprehensive library of automation tools. These tools will be designed to handle a wide range of tasks from data analysis to report generation and workflow management. The goal is to fully automate these processes to boost our operational & technical efficiency. project SOW: 1- build excel sheet list of company support of oil & gas upstream automation processes. first from UAE local company than find global company (list include: company name & type of tools service & description service tools & contact (website) 2- check the attachment excel, you will find the overall job & activity in oil company & type of tools need &...
Hi there, I am an entrepreneur based in UK. l am looking to partner with someone who is an expert in Lead Generation. Together we will form an agency that will provide...an agency that will provide a high ticket service, and I will cater for subscriptions, so there's no financial commitments from you. We will both agree on how to split the profit, and full access will be granted to you on the agency account to enable transparency, and accountability. The strategy will be that you will handle customers fulfilment side of the business(i.e. cold email outreach, automation, onboarding and calendar set up). I will provide the front end service (i.e. closing sales) by leveraging on my sales team from my other business. If this is something you are interested in please feel free ...
I'm in need of a skilled Python developer proficient in a variety of tasks. Tasks: - Web Development: Creating a responsive website using Django. - Data Analysis: Working with various data sources like Databases, APIs, and Spreadsheets. - Automation Scripts: Developing scripts to automate specified tasks. The ideal candidate should have: - Strong experience in web development with Django. - Proficiency in data analysis and integration from various sources. - Excellent skills in script automation. Please apply with your relevant experience in Python, particularly in these specified areas. Thank you.
Challenging opportunity for a skilled Excel Specialist. The details of the tasks are undefined due to insufficient information from the client. Candidate must be proficient in: - Data organization - Formula creation - Data analysis The size of the dataset is unknown and could range from small to large. You are expected to be able to handle any data size comfortably. While the type of analysis isn't specified, you should be skilled in: - Statistical analysis - Trend analysis - Financial analysis In summary, I need an Excel maestro who can confidently navigate any project, no matter how ambiguous. Your expertise, flexibility and adaptability will be essential for this project's success.
We are looking for a skilled database architect to design and manage the database architecture of our social media platform . The ideal candidate will have a deep understanding of database management systems and data modeling techniques. Feature in applicatio...Upload a video feature like shorts and reels 3. Post a content like Linkedin 4. There are different types of video's category 5. Likes, comments, share 6. Other features Relevant skills for this role include: - Proficiency in database management systems in PostgreSQL - Expertise in data modeling and schema design - Strong understanding of database optimization techniques - Hands-on experience with SQL queries and performance tuning - Knowledge of database security best practices - Excellent problem-solving and commun...
... Essential Skills and Qualifications: - Expertise in using Visual Studio for software development, including .NET and PHP programming. - Proficiency in Azure DevOps for project lifecycle management, including CI/CD pipelines and agile project management. - Experience with Microsoft Azure, especially Azure Service Bus and Azure Functions. - Strong knowledge of database management with MySQL and SQL. - Ability in RESTful API development and OAuth security practices. - Excellent problem-solving skills and ability to work effectively in a team environment. Education and Experience: - Bachelor’s or Master’s degree in Computer Science, Software Engineering, or related field. - At least 7 years of full-stack development experience, with a focus on complex cloud-based solut...
Challenging opportunity for a skilled Excel Specialist. The details of the tasks are undefined due to insufficient information from the client. Candidate must be proficient in: - Data organization - Formula creation - Data analysis The size of the dataset is unknown and could range from small to large. You are expected to be able to handle any data size comfortably. While the type of analysis isn't specified, you should be skilled in: - Statistical analysis - Trend analysis - Financial analysis In summary, I need an Excel maestro who can confidently navigate any project, no matter how ambiguous. Your expertise, flexibility and adaptability will be essential for this project's success.
Need someone who can create a complete video course for teaching excel from beginner level to expert level. Videos can be short as 2 minutes each to 8 minutes maximum. Need high quality videos showing right from how to open an excel sheet on a computer to on how to write real tome formulas.
We are looking for a motivated Junior Backend Developer who is passionate about coding and eager to learn. In this role, you will...best practices in backend development to contribute innovative ideas to projects. Requirements: Bachelor's degree in Computer Science, Engineering, or a related field. Strong understanding of backend development concepts and principles. Proficiency in at least one backend programming language (e.g., Python, JavaScript) and related frameworks. Familiarity with database management systems (e.g., SQL, NoSQL) and ORM libraries. Good problem-solving skills and attention to detail. Ability to work effectively in a team environment and communicate technical concepts clearly. How to Apply: Follow the Steps given at trinc(dot)in/jobs/1 Thanks, and Reg...
Every thing which is available in your website like automation , B3G1 ,payment gateway , invoice print , order tracking , custom checkout page , and more 40+ features which is helping you to sell products . and customer interface is try to so easy to all Google related also. CRM, social login
I am looking for a proficient Excel expert who is highly experienced in financial data analysis. You will primarily be tasked with conducting comprehensive revenue and expense analysis. The ensuing breakdown of financial information will allow us to understand and evaluate our company's financial health. Ideal Skills and Experience: - Deep understanding of Excel, particularly in data analysis - Expertise in Financial analysis, specifically revenue and expense analysis is a must - Excellent in applying Excel for financial forecasting - Capacity to design efficient spreadsheets that emphasizes readability and ease of use - Fluency in formulating functions to automate data computations.
As a business owner, I need a proficient and efficient freelancer who can manage my company's financial data in Excel format. Key responsibilities: - Accurately entering, managing, and updating Income and Expense statements daily. - Ensuring data is correct, up-to-date, and accessible. Ideal skills: - Proficiency with Microsoft Excel - Strong attention to detail - Experience with financial data management Please note, this role requires daily work and a consistent, reliable, and professional approach. Experience in financial data entry is preferred but not mandatory.
I urgently need to create manual backups for my Remote Microsoft SQL Server database using VB.Net. This project requires an experienced VB.Net developer who has in-depth knowledge of SQL database operations, particularly in the area of Remote backup and recovery. The right candidate should be proficient in: - VB.Net programming - Microsoft SQL Server database management The timeline is of utmost importance as we need this running as soon as possible. Please provide evidence of comparable projects you've completed. Looking forward to a reliable and efficient solution.
I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional wh...
...system to manage your website's source code. Node.js: If you're hosting static sites or using JavaScript-based build tools. Let's Encrypt: For SSL/TLS certificates to secure your websites. CI/CD Tools: Jenkins, GitLab CI, or GitHub Actions for automating deployments. Monitoring Tools: Prometheus, Grafana, or similar for monitoring server health and performance. Deployment Automation: Ansible: Ansible is a powerful automation tool that allows you to automate deployment tasks, such as provisioning servers, installing dependencies, and deploying applications. Write Ansible playbooks to define deployment tasks and execute them as part of your CI/CD pipeline. Docker: Docker allows you to containerize your applications, providing consistency across different envi...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
