Excel automation sql jobs
...Data Management: The app needs a strong data management feature, allowing for efficient organization and retrieval of information. - Workflow Automation: Automatically streamline tasks and workflows to increase efficiency. - Customization Options: Enable customization to cater to various needs within our internal team. Design: The UI should have a clean and professional look, facilitating easy navigation and enhancing user friendliness. Audience: - The app is intended primarily for use by our internal staff only Ideal Skills: - Previous experience in Zoho Deluge based application development. - Proven track record in data management, workflow automation, and user customization. - Strong UI/UX design skills, preferably with a focus in clean and professional interfaces. ...
I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based research would...
The project is to create Inverter automation to start export, stop export and charge the battery automatically using a microcontroller that can subscribe to the server to get spot prices to run the automation. Objectives: 1. Modbus read and write 2. ESP32 Webserver 3. Spot price subscribe 4. Calculation / rules 5. MQTT Service (Server) 6. Price Service (Server) 7. Device Dashboard (Server) Project scope and system architecture are referred to the project brief documentation "Inverter Automation Project "
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
I'm looking for a skilled professional in Proteus and KiCad to assist with an electronic simulation and PCB design projec...component selection and placement. - I already have specific electronic components in mind for this project, so I would need your expertise in helping me integrate these into the design. - The primary purpose of the electronic device I'm designing is for control and automation. Ideal Skills and Experience: - Proficiency in Proteus for electronic simulation - Proficiency in KiCad for PCB design - Experience with circuit design, schematic capture, and component selection and placement - Previous projects focusing on control and automation systems would be a bonus. Please let me know about your background and experience in this area, and how y...
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communica...
I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invoicing processes. Requ...Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these requirements effectively...
Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience i...
I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample
Looking For An Experienced YouTube Video Editor For A Celebrity Channel This is a LONG-TERM position with GREAT benefits such as Bonuses and raises based on quality work and performance! You’re responsible for creating engaging 20-25 minute videos 1-2 times weekly. Examples: Below are links to my competitors' channels for you to refer to that will give you a better understanding of the level of quality we need from you. ://@TriniTEA_ Requirements: 1. English expert 2. Professional software 3. 48H Or less turnaround time 4. Willing to work long term and grow with the team 5. Experience with celebrity channels (10 Videos For $300) Please provide samples of previous work to be considered for the position!
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. ...help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a goo...
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
One excel file with macro as per the customer requirement
I'm looking for a skilled programmer who can help me commission an Allen Bradley PLC for hydraulic tire presses. The service engineer would be responsible for: - Compliance with the programming of the PLC and ensure control devices have proper function. - Working with other engineering disciplines (Electrical and Mechanical) to deliver a successful project. - Compliance with all health and safety, quality assurance and all other company policies and procedures. - Commissioning PLC controls, carrying out I/O checks, motion checks and support troubleshooting. - Reporting progress and accomplishments each day. The system should have: - Data Logging: Ability to record and store data for further analysis and monitoring. - Fault Detection and Diagnosis: Ability to identify issues and pro...
I'm ...generation tasks using HubSpot. This would involve setting up workflows, lead scoring, and implementing strategies to increase lead generation. - Email Marketing Automation: Additionally, I'll need help with automating email marketing campaigns. The goal is to generate more leads and improve lead nurturing through a mix of promotional emails and educational content. The ideal freelancer for this job should have: - Proven experience with HubSpot automation - A strong background in lead generation and email marketing - Creative skills for crafting engaging and effective email content - Proficient in setting up and managing automation workflows I am open to suggestions and ideas, so if you have experience in driving lead generation and email marketin...
I'm seeking a tester to evaluate our PHP Laravel website. Your responsibilities will include both manual and automated testing. Manual Testing: - Focus on Functionality, Usability &...three major browsers (Chrome, Firefox, Safari) and require you to automate this testing. Ideal Candidate: - Proficient in PHP and Laravel: You should be well-versed with these technologies to understand the intricacies of the website. - Skilled in Manual Testing: Your experience in manually testing websites, particularly in evaluating Functionality, Usability and Compatibility, is crucial. - Automation Testing Knowledge: Your ability to automate testing, especially in terms of browser compatibility, is pivotal for this project. Please share your relevant experience and how you plan to ap...
...Agent: Responsible for handling and resolving tickets. - User: Able to submit tickets and monitor their progress. Ideal skills and experience for the job would be expertise in web development, specifically in creating ticketing systems. Familiarity with user management, role assignment, and priority matrix are essential. Fluent in programming languages like PHP, JavaScript, and proficiency in SQL for a robust database system is a must. Creativity in UX/UI design for an engaging and user-friendly interface should be apparent. It is also required to handle incoming and outgoing E-Mails. I don't want to have further frameworks involved. Core PHP is required and JS like Bootstrap 5, JQuery are ok.I have my own authentication system in place. Based on the role different in...
I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forward to your proposals.
As a business owner, I need a data entry operator who is proficient and experienced with Excel formulas. This is fairly urgent, and I am looking to make a quick hire for this role. The complexity of the task at hand includes: - Data entry with calculations - interpretations are not necessary - The project needs to be completed as soon as possible The ideal candidate for this job would possess: - Speed and accuracy for data entry tasks - Strong proficiency with Excel - A deep understanding of Excel formulas - The ability to work under tight deadlines I look forward to seeing your bids and working with you. Thanks!
I need a skilled developer to create an automation bot for Telegram Channels. This bot will have the essential functions of: - Auto-joining channels - Extracting basic channel information including the description and links I want the bot to be able to extract the following specific information from the channels it joins: - Channel Name - Channel Description - Channel Links - Member Count The frequency of this extraction should be set to a weekly basis. Ideal skills and experience for this job would include proficiency in Python or a similar programming language, previous experience with Telegram's API, and prior experience creating chatbots or automation bots. Expertise in web scraping technologies is also a must.
I'm looking for a skilled developer to create an automated WhatsApp Group Adder. This tool will be helpful for managing group invitations and membership. Key Features: - Automatically add members...application, but compatibility with different platforms like desktop and mobile would be a plus User Interaction: - The ideal developer should be able to provide the tool with the flexibility in terms of user interaction, allowing for both fully automated or semi-automated options. Ideal Skills: - Proficiency in programming languages suitable for web application development - Experience in creating automation tools - Knowledge of the WhatsApp API and its limitations - Ability to create a user-friendly interface for the tool Please showcase your relevant experience when bidding f...
I need a knowledgeable and experienced pivotchart expert in Excel, who can assist in creating a line chart to visualize my customer data. This chart should effectively illustrate the purchasing behavior of my customers over time. A deep understanding of customer trending and Excel pivotchart is essential. Key Requirements: - Expertise in Excel pivotchart (specifically line charts) - Ability to analyze and visual customer data - Experience in monitoring customer purchasing trends - Quick and efficient work pace - Attention to detail and accuracy - Excellent data visualization skills This role requires strong organizational and analytical skills. Previous experience in similar tasks is highly valued. I look forward to seeing your bids.
I need to automate the process of notifying us in advance when our applications have expiring SSO certificates. - I'd like the system to monitor the certificates for me, sparing me the manual effort. - The system should send an email notification specifically detailing the certificate's name and expiration date, ideally 30 days in advance of t... - I'd like the system to monitor the certificates for me, sparing me the manual effort. - The system should send an email notification specifically detailing the certificate's name and expiration date, ideally 30 days in advance of the expiration. This way, I can ensure that we handle the renewal process in a timely and organized way. Ideal Skills: - POwerShell - Proficiency in Email Automation - Experience in ...
I am in need of a skilled PHP programmer to address an "undefined variable" error within my user authentication system. The system primarily relies on email and password authentication. Key Requirements: - The error lies within the user authentication system - The primary method of user authentication in the system is email and password Ideal Skills and Experience: - Proficiency in PHP, SQL - Experience with user authentication systems - Familiarity with handling undefined variable errors - Understanding of secure email and password authentication Your task is to identify the root cause of this error and implement a solution to rectify it. Please provide specific examples of similar work you have done in the past.
I'm in search of a project coordinator with a background in team coordination and excel. The selected individual will be primarily responsible for planning and organizing a one time project, it will be plotting out some meetings and planninh some deadlines in excel. I'd like to ask them questions while they plan it out if possible! Key Requirements: - Strong Experience in Project Management: This is the most critical requirement. Experience in managing technology-related projects is highly preferred. - Strong Organizational and Time Management Skills: Ability to organize tasks efficiently and manage deadlines effectively. - Excellent Communication and Interpersonal Skills: Ability to communicate effectively with team members, stakeholders, and clients.
I'm seeking a developer to integrate our company's workflow with Office 365, specifically focusing on automation of task assignments. This integration aims to increase our team's productivity. Key Responsibilities: - Designing and implementing a system that seamlessly integrates with Office 365. - Automating task assignments using the platform's functionalities. - Ensuring smooth and efficient workflow within our team. The Ideal Candidate Should Have: - Proven experience in Office 365 integration. - Strong understanding of task assignment automation. - Ability to design and implement a user-friendly system. - Excellent communication skills for updating and consulting with our team.
I am seeking an experienced SharePoint developer to create a new SharePoint site and list for my team. This list should encompass both team member contact information and task assignments. Organisation of the list should be by both task category and project phase, for easy navigation and maximum efficiency. The significant aspect of this project is not only creating the SharePoint list, but also implementing Power Automate flow for seamless operation. Key Responsibilities: 1. Creation of a new SharePoint site and list 2. Inclusion of team member contact information and task assignments in the SharePoint list 3. Organizing the list by task category and project phase 4. Configuring Power Automate flow for the list Ideal freelancers should demonstrate: * Proficiency in SharePoint and Shar...
You will get an application that automated extracts the data from any site web you need, cleans it, and presents it to you in an Excel folder or links it to the database, etc.1 - An application capable of extracting infiniti of data automatically without human intervention and in a short time2- You can choose any package you want according to your specific needs3 - After that, you will get rid of manual data extraction, which requires a lot of time and focus, etc. With the application, say goodbye to manual errors.
I need a proficient Excel expert to adapt my advanced financial models to reflect our current business strategies. The project involves: - Adapting advanced financial models: The existing models are highly complex, with intricate formulas and extensive use of macros. The ideal candidate should be comfortable working with such complexity. - Business strategy alignment: The primary goal is to ensure that these models accurately mirror our updated business strategies. This may involve tweaking existing formulas, adding new ones, and making the models more responsive to changing market conditions. Ideal Skills: - Advanced Excel Proficiency: A deep understanding of advanced Excel functionalities, including complex formulas, pivot tables, and macros is critical. - Financia...
Unleash the power of AI: create custom AI-powered Flask web appsDo you have a project that requires intelligent automation?I can help you develop custom AI models and seamlessly integrate them into powerful Flask web is what I propose:Tailored AI Solutions: We will work together to understand your needs and create a custom AI model that addresses your specific challenge. (e.g. image recognition, sentiment analysis, predictive modeling)Seamless Flask Integration: I will create a user-friendly Flask web application that uses your AI model, allowing you to interact with its intelligence and options: choose from a range of packages adapted to your budget and the complexity of your project. All packages include basic functionality, with options for advanced
I need a real estate development pro forma converted from a PDF to a functional excel file. One document is 18 pages and the other is 17 pages.
i want 3-5 minutes (both timeframe) candle data into excel sheet. data like date, time, open, high, close, volume of each candle. (check image for refrence) data should be updating in realtime, no delay, next candle data in new row. add instruction, so that i can edit code my self and chsnge stock symbol to get data for desired stock. easy to use and record all day data, even if i open excel at the day end or reopen thw whole day data should be recorded.
Unleash the power of AI: create custom AI-powered Flask web appsDo you have a project that requires intelligent automation?I can help you develop custom AI models and seamlessly integrate them into powerful Flask web is what I propose:Tailored AI Solutions: We will work together to understand your needs and create a custom AI model that addresses your specific challenge. (e.g. image recognition, sentiment analysis, predictive modeling)Seamless Flask Integration: I will create a user-friendly Flask web application that uses your AI model, allowing you to interact with its intelligence and options: choose from a range of packages adapted to your budget and the complexity of your project. All packages include basic functionality, with options for advanced
Looking for some simple finance-based calculations on a car-budget, some simple ratios and charts, by using MS-Excel. Also need a 650-words write up in 2 to 3 days
...comprehensive wedding website and app that will serve as a one-stop solution for all my wedding-related needs. Key Features: - RSVP Management: The app should be able to track and manage RSVPs from all invitees. - Wedding Countdown: A countdown feature to the wedding date. - Photo Gallery: A place to store and showcase the couple's photos and memories. - Guest Management: The app should have two excel sheets, one for the bride's guests and one for the groom's guests. - Dietary Preferences: A feature to collect and manage dietary preferences of guests. - Seating Charts: Ability to create and manage seating arrangements. - Communication: Integration with WhatsApp to create a community for confirmed guests. - Create an app for it so can log in via website or app. I...
I work for a security company. We needed a spreadsheet to track security units and track what they're doing. I have the code almost perfect, but it's buggy enough that it's hard to use. There's quite a bit of backend code and intermittent problems with it. I need someone who is great at project code to look at it, troubleshoot it and make it more user friendly.
... Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Write clean, maintainable, and well-documented code. Troubleshoot and optimize existing integration solutions. Desired Skills and Qualifications: Strong NodeJs skills Ability to read Python & Go code Abiltiy to write DBT transformations Strong experience with CloudQuery and its features. Proficient in SQL and database management systems. Solid understanding of API integrations and web services (REST, GraphQL, etc.). Experience with ...
...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...
...specific requirements of the vending project - Analyze conversion rates, visitor traffic, and other key metrics to predict profit margins - Utilize advanced spreadsheet techniques to organize and present data effectively - Provide recommendations and insights based on the financial analysis Requirements: - Proven experience with financial modeling, preferably in the vending industry - Proficiency in Excel, Google Sheets, or other financial modeling software - Strong analytical and problem-solving skills - Ability to work independently and meet deadlines Duration and Budget: This mini-project is expected to require approximately 15 to 20 hours. The budget for the task is 200 EUR. How to Apply: Please submit examples of previously created financial models along with your applica...
I'm looking for a skilled .NET developer with experience in JSON, MS SQL, AJAX, and HTML to help me migrate my existing website to a new template. The specific features that need to be migrated are the design layout and content pages. To give some context, the primary objective of this migration project is to enhance the functionality of the website. An ideal candidate should be well-versed in enhancing user experience and updating design aesthetics. Your role will be pivotal in ensuring that the new template not only preserves the existing features but also improves the functionality. The key difference I'm aiming for in the new site is faster loading times. This means that you should be able to optimize the site's performance and ensure that the migration process ...
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.
Hi We are building one app launcher that will have many apps in it, we are working hard to adjust all apps to fit it and we need automation to scale our manual work, what we do is: if you know a way this can be done using automation please reach me first i open each games in unity to see the libraries they are using than i delete the In-app purchase and ads libraries After deleting the libraries, we get errors in codes that uses ads and lAP, so i fix them than i modify the code to give the in app items to users for free Than i have to check for all the static variables used in games, because they needs to get reset every time user come back to home page, else, they will get error the next time we play the game Than i have to create bundle of all the images, sounds and ...
I'm in need of a master in Excel. Your task will include: - Inputting both textual and numerical data into Excel. - The data to be entered is categorized, meaning that you'll need to pay close attention to how and where the data is entered. Ideal candidates have extensive experience with Excel and a sharp eye for detail. Familiarity with categorized data entry is a plus. Please apply if you think you've got these skills.
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.
I'm looking for a talented Pine Script developer to create a strategy that will automate the use of Fibonacci extensions. The specific requirements are as follows: - Strategy De...particularly focusing on the 0.382 level for taking long trades and its opposite for short trades. Ideal skills and experience for this job include: - Proficiency in Pine Script: A strong understanding and experience in developing strategies on TradingView using Pine Script. - Fibonacci Extension: Prior experience in implementing and utilizing Fibonacci extensions within trading strategies. - Automation: Ability to develop automated trading strategies that execute trades based on predefined criteria. If you have experience in these areas and can deliver a robust and reliable strategy, I'm eag...
We are seeking a meticulous and experienced developer who has exceptional automation, database management, and web solution skills. Project description: A toolprogram that will copy information from Zoho CRM and autofill the DS-160 form after passing the Captcha. Most likely, autofill needs to have an open API and be able to fill in pre-copied information on the site. Important: This tool can be developed as a browser extension! Description of the process (presumably): The manager copies the information from the Zoho SRM system, inserts this information into the tool/service that you will develop. Next, the manager opens the website , goes through the captcha and turns on the service, which will fill out the entire form with the information taken
...rental system e) Online car rental system The final submission should include: 1) Report describing the project that includes: a. Introduction b. Web site design c. Web site development: the main files created: articles, categories, modules, and database. d. Screenshots of the website e. Conclusion f. References 2) One folder that holds all the subfolders of categories, articles, menus, modules, SQL 1 files, videos, banners, and images....
I need a seasoned LabVIEW developer who is skilled in handling data acquisition and processing as well as GUI desi...need a seasoned LabVIEW developer who is skilled in handling data acquisition and processing as well as GUI design and user-interface development. Key tasks include: - Working on the interface that controls our vision camera. - Implementing features for image processing and analysis. - Developing functionality for object detection and tracking. Extensive experience with instrument control automation, particularly with vision cameras, is highly advised for this role. I'm expecting a meticulous eye for detail, excellent problem-solving abilities, and a deep understanding of LabVIEW. If you have handled similar projects in the past, that would put you at a strat...