Vba excel automate toolpak jobs

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...

I'm looking for a skilled freelancer who can help me automate personal communication using WhatsApp Cloud API. The main goal of this project is to streamline my personal communication processes and make it more efficient. Key Responsibilities: - Integrating WhatsApp Cloud API: The first phase of this project would involve setting up the WhatsApp Cloud API, including the integration of a websocket webhook for real-time communication. - Developing Automation Scripts: I will need you to create Python scripts that can automate various communication tasks on my behalf. This might involve sending messages, responding to specific triggers, or even managing contacts. Skills and Experience: - Proficiency in Python: You should be an expert in Python programming, as this will be...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

...for CI/CD implementation. I need a clear step-by-step explanation, with code snippets, of how to set up this pipeline. - Code Snippet for Retraining: The most critical part of the project is to provide a Python code snippet that will retrain the model when new data is introduced. - No model training: It's important to note that I am not asking for the training of a new model. The aim here is to automate the retraining process when new data is available. Ideal skills and experience for this job include: - Proficiency in Python: The code snippet should be in Python. Experience with machine learning libraries like TensorFlow, Keras, or Scikit-learn would be advantageous. - CI/CD Tool Knowledge: Familiarity with Docker and HuggingFace space or relevant experience with Jenkins,...

I have an excel file, need add product categorie on a column - budget 100€

I'm looking for a skilled professional who can help me fetch specific data metrics from to Google Sheets. The data metrics I'm interested in are Taker Buy Volume and Taker Sell Volume. Key deliverables for this project are: - Setting up an automated data fetching system from to Google Sheets every hour - Creating a simple e... to Google Sheets every hour - Creating a simple equation using the imported data - Producing a line chart based on the data Ideal candidate for this project should have experience in: - Web scraping - Google Sheets scripting - Data manipulation and analysis - Data visualization, particularly with line chart You'll need to have a good understanding of how to handle API data and automate the process through Google Sheets.

I need an Excel professional to help me clean up my data. Specifically, I'm looking for someone who can assist with text and number formatting. Key tasks include, but are not limited to: - Data cleanup, focusing on text and number formatting - Ensuring the data is well-structured for its intended use - Delivering the formatted data in a different file format than the original Excel file Ideal candidates should have: - Proficiency in Excel and its various functions - Prior experience in data cleanup and formatting - Attention to detail and commitment to quality - Strong communication skills, as you may need to clarify certain aspects of the data. Please deliver the formatted data in a different file format, which will be provided by me.

...analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be an...

I'm in need of a professional who has extensive experience with SharePoint, Power Apps, Power Automate, and secondary Power BI . I need support for my consultant indian time 8:30 pm to 11:30 pm Monday to Friday. 12$/hourly.. payment every saturday vai peayplea. I already have other indian guys who are working with me since 2019 to present. This support will be on zoom meeting. Which we will provide u and u will connect with my consultant for support.

As a Python Developer, I'm intent on automating specific repetitive tasks related to file management and organization. Key Responsibilities: - Develop scripts in Python to automate repetitive file management tasks. These tasks are slowing down our productivity and we need a solution to streamline them. - Implement an effective, reliable and user-friendly automated system that requires minimal manual intervention. - Ensure the system is highly secure and can handle large volumes of data effectively. The ideal candidate will have: - Proficiency in Python programming language and experience in automation.

Hello, I need complet the Amazon categories catalogue excel in french

...the bot to generate an editable presentation plan based on user input. - Provide options for users to review and edit the generated plan before proceeding. Slide Description Generation: - Create a feature where the bot generates detailed descriptions for each slide according to the approved plan. - Allow users to review and edit each slide description. Slide Creation with Images: - Automate the generation of slides including related images based on the descriptions. - Ensure each slide is editable by the user for final adjustments. File Generation: - Implement the final step where users can generate and download the completed PowerPoint (.ppt) file after reviewing all slides. Requirements: Proven experience in developing Telegram bots. Proficiency in p...

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

Please Sign Up or Login to see details.

I require an efficient programmer equipped with the crucial skills in Pine Editor coding. The project involves designing a script based on the 'Trading View' platform to automate my stock market trading strategy. The strategy revolves around Multiple EMA (Exponential Moving Average) crossing. For this specific task, a system with three different EMA lines is preferred. Ideal Skills & Experience: - In-depth knowledge of Pine Editor; - Familiarity with Trading View platform; - A fine understanding of EMA and its implementation in trading strategies; - Previous track record demonstrating similar tasks completed. I emphasize clarity and efficiency in the script to enhance my trading decisions. Please, get in touch if you can confidently handle these specifications.

I need an expert in Power Automate who can automate my data entry and reporting processes, notably form and workflow management. Among the tasks will be: - Creating automated workflows that take the data from Microsoft Forms responses primarily for accounting use and emailing the responses and notifications. - Setting up automatic email notifications as a response after the forms are filled out. The perfect candidate for this project should have strong proficiency in Power Automate as well as a good knowledge of accounting processes. They should demonstrate experience with data automation, report generation and workflow management. Understanding the sensitive nature of the data being collected, a strong sense of data privacy is certainly desired.

I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets - Understanding of conditional formatting and ot...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

...development on a VPS, and this project will be conducted in a test environment before being deployed to production. We aim to collaborate with other teams working on related projects to ensure a smooth integration What You’ll Do: Integrate BigBuy API for product synchronization. Develop automation scripts using ChatGPT for content generation. Create and upload promotional videos to YouTube. Automate blog post creation with enriched product descriptions and videos. Optimize the site for SEO and ensure easy sharing across social media. Skills Needed: WordPress development (PHP, HTML, CSS, JavaScript) API integration (BigBuy, OpenAI, YouTube) SEO best practices Python/Node.js for automation scripting Video editing and creation Why Join Us? Be part of an innovative project ...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...

I'm looking to automate podcast transcription service. 1. I need a service to follow Podcast Rss Feeds and listen for new episodes 2. I need Listen Notes to download the podcast audio file 3. I need Chatgpt to transcribe the audio file 4. I need an output of the transcribed text made into a google document 5. I need Chatgpt re-write the transcribed text into an article with a Title, meta text and the content of the article. 6. I need the re-written article to be saved in a Google document 7. I need the document to be re-written in 8. I need the re-written document by saved in google document You should know python and have api integration skill set you should know how to use and the process flow

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I will pay no more than 30 dollars for this work. Please do not send a bid if you are going to offer a higher price. I'm seeking a skilled PHP programmer proficient with Cora. The goal is to automate the sharing of articles from my website to my business Facebook page. Key requirements: - Automate sharing: I want the programmer to ensure that whenever a new article is uploaded to my website, it's automatically shared to my business Facebook page. - Cora PHP programming: The ideal candidate should have experience with Cora PHP programming, specifically related to integrating website content with Facebook. - Facebook page sharing: The articles should be shared only on my business page, ensuring they reach my target audience. Your duties will include: - Developing t...

Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pri...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

I am seeking an experienced PineScript developer to create a custom trend-following strategy. I already have they key indicators and ideas, but need someone to combine all into one indicator and strategy and then automate it to trade on a broker platform. The person must be very experienced in Pinscript because the indictors are using Renko overlay charts and the indicators will be applied to the Renko overlay to make decisions.

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tab...Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and share th...

I'm in need of a skilled and experienced developer that can assist me in automating several tasks, organizing files and data on Google Drive using Google App Script and Java programming language. Key Tasks: - Create scripts to automate Folders and files - Improve file organization and management on Google Drive - Develop custom solutions using Java Ideal Skills: - Proficient in Google App Script and Java - Strong background in automating tasks - Proven experience in organizing and managing files - Prior experience with Google Drive is a plus Your expertise and knowledge in these areas are crucial for the success of this project. Looking forward to collaborating with a proactive and skilled developer.

...will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy are highly valued. - Understanding of basic financial jargon will be beneficial. This role requires someone who is organized, reliable and able to work independently. The workload will be part-time with flex...

I need a web scraping professional to create a script to extract specific data from , a popular online marketplace for trading cards, please check attachemen...Quotes Quotes+ Bookmarks Bookmarks+ Authentication is done through twitter, I will connect my twitter account and run the script myself Deliverables: - Format: Script that I can run to export the required data in a CSV file. Ideal Candidate: - Proficient in web scraping tools and techniques. - Experience working with online marketplaces and eCommerce data. - Ability to deliver CSV files and automate the process for daily updates would be highly advantageous. - Familiarity with specifically would be a plus, but not essential. Please check the attachment, this is the exact format and data that im looking for

...relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need acc...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking for a 5-star review.

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source mate...

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

I'm looking for a Python expert who can automate the process of creating and managing multiple Android emulator instances on Windows. The automation should also include installing an app on these emulators and executing specific actions within the app without any manual intervention. Key requirements: - A program in Python that can create and handle multiple Android emulator instances - Installation of an app on these emulators - Full automation, including the execution of specific actions in the installed app without manual intervention - Compatibility with Windows operating system Please note that the app to be installed will be provided via file upload from the computer. Ideal skills for this project: - Proficiency in Python programming - Experience in working with And...

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The idea...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

...able to interact with all connected phones simultaneously. I should be able to create and assign tasks to each phone individually, or define tasks that apply to all devices. - **Task Automation**: I need the app to automate several types of tasks, which include: - Web browsing or searches: The app should be able to instruct the phones to browse certain websites or perform specific searches. - App testing or usage: The app should be capable of launching and interacting with various applications on the phones. - Content downloading or uploading: There should be an option to automate the download or upload of specific files or content on the phones. Ideal Skills: - **Strong Python Proficiency**: The freelancer should have a solid understanding of Python programming, as...

I'm searching for a skilled professional to automate key aspects of my business's accounting procedures. Here's a quick rundown of what I require: - Automation of onboarding and tracking Ideal candidates for this job should possess: - Profound experience with automating business processes - Previous working experience in accounting procedures - Knowledge about onboarding and tracking automation Understanding the requirements of the project and having proficiency in Gohighlevel will be vital. Efficiency, accuracy, and attention to detail are crucial for the successful completion of this project.