Excel data automation jobs
I need an automation program that can handle my textual data entry and processing tasks.
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
I am looking for an expert in Doorbird system to help maximize the efficiency of my home unit, focusing specifically on:...Access control: - Enable the system to control multiple doors and garage openers - Allow to lock/unlock remotely - Add a keypad entry system for a streamlined user experience. Automation: - Automize processes where possible for ease of use Ideal Skills: - Extensive knowledge in Doorbird systems - Experience in automating security systems - Expertise in integrating varying access control systems, particularly with keypad entry systems and magnetic locks Your will help me document the current setup, explore technologies and products to purchase, make a plan incl. wire diagrams. Proven experience with home automation (doorbird a1018, doorbird D2101)...
I'm seeking an adept developer for designing an automation focused Telegram bot. The main purpose of this bot is task automation, and primarily, it should be equipped with the functionality of responding to user inquiries. Key requirements and tasks include: - Construction of bot with the ability to automate responses to user inquiries. - Integration of a reliable system for the bot to search through a database for pertinent answers. The ideal freelancer would possess the following skills and experience: - Strong expertise in creating task automation bots for Telegram. - A sound understanding of databases and utilising them effectively to deliver appropriate responses to inquiries. - Ability to deliver an efficient, responsive and accurate bot. Your practical ...
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
...for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules ...
I need to connect ElevenLabs' text-to-speech API to another tool through Zapier. So far, Elevenlabs' response has been a binary. Instead, I need the audio URL so that the second app I want to connect with Elevenlabs can use the URL in an automation. To participate in this project, you'll need to create your own free accounts for both services. The participant will need to deliver a complete solution that, if possible, doesn't involve hosting the content in a third-party service. To participate, please start your message with "Bonjour". This way, I'll know you've read this instructions. If you need clarification, pleaset let me know.
Looking for an expert in Oracle Integration Cloud to assist with my tasks in application integration and process automation. The integration should compare two files on the FTP, and send an email to the recipients. - In-depth understanding of Oracle Integration Cloud - Strong knowledge in Application integration - Process automation skill set - Ability to advise on best integration strategies
I need a professional freelancer to design an HTML form for my website. This form must have: - Text fields for basic information collection - Dropdown menus for selection options - Capture creation The form should be designed with user-friendly, visually appealing elements. Your role will al...ensure that the user completes all the required fields in the correct format. - Integrating an email script that will automatically send a reply to the submitter. This is an essential feature for my project. Ideal Skills and Experience: - Proficiency in HTML and CSS for form design - Experience in creating and implementing form validation - Knowledge of backend scripting languages for email automation - Understanding of user experience best practices - Experience with automatic email rep...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
I'm looking to automate a process in my manufacturing setup. This involves controlling a servo and timer to carry out specific tasks. Key Responsibilities: - Develop a system...servo and timer to carry out specific tasks. Key Responsibilities: - Develop a system that uses a combination of a servo and timer to automate a particular process in my manufacturing facility. - Ensure the system is able to operate efficiently and with high precision. Ideal Skills: - Proven experience in automation projects, particularly in a manufacturing setting. - Proficiency in programming and working with servos and timers. - Strong problem-solving skills to optimize the automation process. Note: I'm unsure about which platform would be the best for this project. I'm open to ...
I'm seeking a skilled HubSpot professional to provide me with training. Although I'm a beginner, I'm eager to get up to speed on Marketing and Sales Hubs. My primary goals for using HubSpot are to enhance our lead generation, customer relationship management, and sales pipeline management. Key Requirements: - Strong experience with HubSpot, specifically Mark...Marketing and Sales Hubs. - Prior training experience, especially with beginners. - Ability to tailor the training to my goals. Your responsibility will be to provide clear, engaging, and actionable instruction to help me utilize Hubspot effectively. You should be patient, good at explaining complex concepts simply, and able to adapt to my pace and learning style. A background in marketing automation and CRM...
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancemen...
...eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simulta...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
I'm uncertain whether my Windows system already has Python installed. I require assistance to get it up on my system, if it isn't already there. Primarily, I am looking for someone to help configure a Python script that will carry out automatic reservations on a specific website. This role will ideally suite someone with: - Proficiency in Python scripting - Strong understanding of automation using Python - Experience in setting up Python on the Windows platform - Knowledge of web interaction through code, in particular, reservation processes. here is the link to the script and its dependencies. I will need to work with you on zoom live to do this. I have node.js on windows
I'm seeking a Laravel developer w...user inquiries. Hence, you should be well-versed in both Laravel and Dialogflow to achieve this automation efficiently. - You'll need to set up a Dialogflow account and project from scratch as I haven't done this yet. Your experience in Dialogflow will be instrumental in ensuring that the setup is seamless and optimized for my application's needs. Ideal Skills: - Proficiency in Laravel 7 or 8 - Extensive experience in Dialogflow, including setting up accounts and projects - Strong understanding of automation and how DialogFlow can be leveraged to optimize user inquiries I'm looking for a proactive and skilled developer who can efficiently handle this integration and ensure that the automation of responses ...
...personal use. Key Requirements: - This is a personal project, not for a business, and the primary goal is to automate the task of securing a visa appointment. The Bot: - The bot should be able to navigate a visa appointment booking system, select the appropriate options, and secure an appointment on my behalf. Skills and Experience: - Proficiency in bot programming and automation is crucial. - Experience with task automation and appointment booking is a plus. - Understanding of web scraping and navigation is a requirement. - Attention to detail is important to ensure the bot selects the correct options during the appointment booking process. Please get in touch if you have prior experience with building similar bots or automations, particularly in the context of...
...facilitate automation on Facebook Marketplace. The bot that I'm envisioning would need to perform the following tasks: - Can use multiple accounts, log into several accounts to enter automatic Facebook marketplace listings or Facebook group posts, logged in accounts are saved and can be opened without re-entering the password - Autopost Facebook Marketplace Create Product Title, product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace wit...
...from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. ...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tab...
I need a Python expert with an ability to cover various functionalities as per the need. The project might involve data analysis, web scraping, automation, or could be anything else as per the project requirements. The ideal candidate should have: - Expertise in Python programming and its different libraries. - Experience with data analysis, web scraping, automation. - Strong problem-solving skills. While applying, please share: - Your past work related to Python programming. - Your Python programming experience level. - Detailed proposal of how you can assist in this project.
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
...seeking a skilled freelancer to automate the process of sending student data to school coordinators via WhatsApp. The task involves parsing a large Excel sheet containing student data, splitting it into smaller sheets based on schools, and sending each school's data to the corresponding coordinator's WhatsApp number. The main tasks include: Data Parsing: The freelancer will need to parse the provided Excel sheet containing student data. The data includes student names, grades, schools, coordinator names, coordinator WhatsApp numbers, and student codes. Data Splitting: The freelancer will develop a Python script to split the large Excel sheet into smaller sheets based on schools. Each smaller sheet should c...
...Description: We are seeking a skilled Freelance Full Stack Developer with experience in AI technologies, web development, and data processing to build an automated pipeline for creating AI images. The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external AP...
I need a Notion API expert to customize my Notion pages for a smoother workflow and integration with other apps. Key requirements: - Integration with other apps: I'm looking to connect my Notion pages with an email client, specifically Microsoft Outlook. The goal is to automatically create draft emails in Outlook whenever new orders are created in Notion. - Automation of tasks: The freelancer will need to create a system that automates the email creation process. This should be seamless and require minimal manual intervention. - Email drafts customization: The only specific requirement for the email drafts will be the Email body. Ideal skills and experience: - Strong knowledge of the Notion API - Experience with integrating Notion with external apps, particularly email clie...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particul...
I need a system that automates some feature on my website, focusing on identifying specific numbers and responding accordingly. Main Features for Automation: - Identify 1-digit numbers from the website - Track 10 consecutive numbers less than 2 - Upon detection, the system should: - Fill amount and apply for bet. Ideal Skills and Experience: - Proficient in web automation - Experience with identifying and tracking specific data on websites - Ability to integrate a betting mechanism in the automation process Please note that this project is not for developing a betting site. It's focused on automating a few select features on an existing website.
...matching of products with the specific types of cars. The types of cars are actually the combination of the following data: CarTypeId - Maker - Model - Year - RoofType Their relationship should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the produ...
I need a reliable person to help me with a project that involves voting on a website. I'm looking for someone who can use automation tools to do the voting. Key requirements include: - Expertise in using automation tools for website voting - Ability to work consistently until the project deadline - Proficient in setting up and using a real-time dashboard to track the voting progress I'm not exactly sure about the security measures involved. If you have experience in bypassing common security measures like CAPTCHAs or IP rate limits to automate voting, it would definitely be a plus. Please reach out if you have the required skills and are available to help me until Sunday 11:59pm.
I am seeking automation specialist with experience on (similar to Zapier) to setup triggers and workflows for a speaker/agenda management system we use. You will need to build scenarios and use Custom Field data. To be considered, please comment "SSM". Thanks!
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
...designed to integrate data from various advertising platforms, website activity, CRM, and Marketing Automation Platforms (MAP) to provide a unified view of marketing performance. We require a highly skilled and efficient Data Engineer or Architect who can handle data export processes, model and create tables and entity relationships, and develop an efficient and scalable database within a tight one-month deadline. ### Responsibilities: - Data Integration: connect and streamline data from multiple sources including ad platforms (like Google Ads, Facebook), website analytics tools (e.g., Google Analytics), CRM systems (e.g., Salesforce), and MAPs (e.g., HubSpot). - **Accelerated Database Design:** Design and implement a robust and scalable databa...
I'm looking for an experienced QA Automation Engineer for solving some issues we have in a complex Jmeter script which we are using in our performance/load tests. This is a 1 week job at most and payment will be fixed at $500. Our JMeter script is not a simple one, so if you are not a real expert in JMeter please do not apply. You will fail to do the project. If you are an expert using JMeter for really complex projects, please apply by simply answering the below questions: 1- Tell us why you consider yourself a JMeter expert. 2- What were the most complex 2 projects that you did JMeter tests for and what made them complex. Please type "I can do it" at top of your reply so that I know you actually read the description.
...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
...of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a ...
...efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Ideal Skills and Experience: - Strong experience in data analysis and visualization - Proficiency in integrati...
Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.
Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
Do you want to convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, You are on the right gig. MY SERVICES: ✅ Data Entry ✅ Web research ✅ Data Conversion ✅ Copy Paste Work ✅ Excel Data Entry ✅ JPEG to Excel or Word ✅ PDF to Excel or Word ✅ Real Estate Data Entry ✅ Language Translator ✅ Microsoft Excel ✅ Microsoft Word ✅ Lead Generation If you still have any questions or want to discuss prices for a custom project, don't hesitate to contact me. WHY ORDER FROM ME?? Fast Delivery, Never Late ✔ Message me if you're unsure or have project-specific questions Thank you
I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.
...Seller Data: The main purpose of this project is to gather information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention to Detail: Since the project involves gathering a wide range of data points, having a keen eye for detail is crucial to ensur...
I am in need of a skilled Linux and Bash Script expert to help me with my current project. Although I haven't specified exact tasks or goals, I am seeking assistance in the following areas: - Linux installation and configuration - Bash scripting and automation - Troubleshooting and debugging I expect the successful freelancer to have a deep understanding of Linux systems and be proficient in Bash scripting. Your past work and experience in similar projects will be valuable. Please detail how you can assist and your approach in your application. Thank you.
I need an experienced graphic designer who can help me enhance the design of basic ID cards for my organization's 44 employees. Key Requirements: - I will provide an Excel file with detailed employee information. This should be included in the design. - Each ID card should include the employee's Name, Employee ID Number, Date of Birth, Emergency Contact Number, and the Company Address. - The design should be professional and visually appealing. I'm looking for someone who can take on this task urgently and provide high-quality work within a short timeframe. Your past experience in designing functional and aesthetically pleasing ID cards will be a huge advantage.
