Excel spreadsheet automationcông việc

...tenure, salary and location of our employees. Your ability to structure and organize these aspects will be key. - Creating an Excel-based system: I'm looking for a dashboard that's easy to dissect and understand. As such, I'd like the final product to be in Excel spreadsheet format. This means you should be very proficient in Excel, knowing how to integrate formulas, tables and other relevant features. - Monthly updates: The dashboard should be designed to be updated monthly. You should be dedicated to ensuring that the data is up-to-date and accurately represented. Ideal freelancer should have: - Proven experience in HR analytics and dashboards - Excellent Excel skills - Ability to present complex data in a clear and concise manner -...

I have an excel sheet with intermediate complexity data, including formulas and charts. I need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accur...

I am in need of a well-versed Python expert to assist in manag...assist in managing a Linux server. This project is task oriented and requires specific skills including: • Working with server data analysis • Implementing web scraping techniques • Establishing automation processes The role also demands a comprehensive understanding of Linux operations and the ability to print headers. A background in server security, setting up database servers and performance optimization would be ideal, but the focus is primarily on Linux server management via Python. Proficiency in Python, Linux, server data analysis and web scraping are must-haves. Experience in automation and server management will highly be appreciated. Looking forward to your knowledgeable and expert ...

I'm seeking a skilled developer to help me deploy ChatGpt model for Customer Support Automation. Key specifics include: - Application Audience: The target audience for this app is primarily businesses. It's crucial that the developer understands this specific user base and can ensure the app is tailored to their needs. - Primary Functionality: The main functionality of this app will be customer support automation. This includes features such as automated responses, ticket management, and potentially even sentiment analysis. The ideal candidate should have experience in developing and implementing such functionalities. - Deployment: The ultimate goal is to get this app up and running, so deployment knowledge is essential. Experience in deploying ChatGpt-based Model...

...looking for an Excel expert who can create a comprehensive sales target tracking spreadsheet for my customers. This spreadsheet should have several key functionalities. Features Needed: - Customer Information: It should contain a section where I can input and maintain all my customer's details. - Sales Tracking: The spreadsheet should enable me to track my sales targets daily and provide a detailed analysis of my performance. - Target Achievement: The spreadsheet should also be able to analyze the achievement or shortfall of selected items target completion by each customer. Analysis Required: - I would love to have a feature that shows how well sales targets are being achieved as per defined targets. Ideal candidate should have great atte...

I need an organized mind to help with research and data entry of a list of companies in a specific industry. Your main responsibility will be organizing this data. While basic Excel skills are a must, experience with data organization, particularly in a business context, would be highly beneficial. The data will be divided into 4 separate categories, so whoever takes on this task needs to have a keen attention to detail and an understanding of categorization. This project is perfect for an individual who thrives in organizing and systematizing data.

**Tour Costing Sheet Structure** 1. **Tour Details** - Tour Name - Tour Code - Duration - Destinations 2. **Client Information** - Client Name - Number of Adults/Children - Contact Information 3. **Accommodation** - Hotel Name - Room Type - Meal Plan - Cost per Night - Total Nights - Total Cost 4. **Transportation** - Vehicle Type - Distance - Cost per Kilometer - Total Cost 5. **Sightseeing and Activities** - Activity Name - Per Person Cost - Number of Persons - Total Cost 6. **Miscellaneous Expenses** - Guide Fees - Entrance Fees - Other Expenses 7. **Pricing** - Subtotal (Sum of all costs) - Markup Percentage - GST (Goods and Services Tax) - Final Price 8. **Payment Details** - Deposit Require...

I'm looking for a freelancer to help with a simple Excel data entry task, as well as some basic formula work. I have a spreadsheet that primarily contains numbers. Your role would be to accurately type this data into the sheet, ensuring that every entry is correct and in the right format. This task is meant for particular record-keeping purposes, so precision and attention to detail are crucial. In addition to the data typing, I need some basic Excel formulas applied. Experience with Excel and knowledge of formulas is essential to ensure the data is well-organized and easy to work with. This task is not overly complex but will require someone who is proficient with Excel's formula functions.

...designated "Yes" or "No" button on the Firefox page. - The interaction with the Firefox web page should be done at regular intervals. After the selection is made , it must return to its original focus to be ready to select one of the two keys. Ideal Skills and Experience: - Proficiency in Python and experience with PyAutoGUI. - Strong understanding of web interactions and experience with browser automation. - Ability to design and implement accurate keyboard inputs. - Experience in handling focus switching between applications. The script is not required to include error handling for instances where the Firefox browser is not open or the specified page is not loaded. The primary focus of the script is on accurately interacting with the designated elements o...

I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completi...

I'm seeking a professional who can help me leverage Azure OCR Document Intelligence in order to automate the data entry process for a set of invoices. Requirements: - Utilize Azure OCR for extracting text from invoices - Implement an automated system for data entry based on the extracted text Integration: - I require the system to be integrated with my accounting software. Ideal Skills: - Proficiency in working with Azure OCR Document Intelligence - Strong experience in automating data entry processes - Prior work in accounting software integration is a plus

I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!

I'm looking for a skilled developer who can help me integrate a chat feature into my Telegram account. The chat should be capable of receiving inquiries an...specifics: - **Manual Responses with Automated Greetings:** The chat should greet the user automatically upon initiation, and then respond to their queries manually. - **Scheduled Messages:** I need the feature to have the capacity to send scheduled messages to users at specific times. The ideal candidate for this project should be familiar with Telegram bot development, have experience with chat automation, and be able to deliver a user-friendly and efficient solution. The ability to understand and meet user needs is crucial. Please provide examples of similar projects you've worked on in the past. Looking forward ...

The attached PDF lists every musician who played for the St. Louis Symphony between 1907-1908 and 1978-1979. I would like the data copied into a spreadsheet. To illustrate the desired format, I have entered the first 11 rows into the attached spreadsheet. The PDF is 34 pages long and I estimate it lists 1500 musicians. I would estimate the job will take 15 person-hours to complete. Thanks for your consideration!

I'm currently in need of a proficient developer who can create an automated tool which can secure, efficiently execute, and dispatch BEP20 tokens to an e...execute, and dispatch BEP20 tokens to an extensive user base. Key Requirements: - Capable of dispersing BEP20 tokens to 15,000 users, each in isolated transactions. - Fitted with an automatic transaction feature. - Incorporates password-protected verification. The perfect candidate: - Proven experience creating similar tools. - In-depth knowledge of BEP20 token transactions. - Skill-set in automation and security measures. This high-volume transaction requirement necessitates a developer who can provide a robust, reliable solution. If you're a seasoned developer with the required skills for building this tool, ple...

I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO

I need an expert in data capturing to mine specific information from websites and organize it efficiently into spreadsheets. The ideal candidate should be meticulous and comfortable with the following: - Data Capturing: The primary task involves extracting and compiling data from various websites. - Web Research: Ability to navigate and find required data efficiently. - Spreadsheet Proficiency: Experience with spreadsheets and data organization. Please bid if you have a strong eye for detail and a proven track record in data entry and web research.

I require an experienced tutor who can help me both maintain and make adjustments to the Asana, Zapier, SMS and Email automations currently in use within my business. Y...the Asana, Zapier, SMS and Email automations currently in use within my business. Your responsibilities will include: Asana Adjustments: - Setting up new integrations as necessary - Advancing current workflow for better productivity - Automating tasks to streamline processes Zapier Adjustments: - Configuring new integration setups - Enhancing the existing workflow - Trouble shooting any automation issues Ideal skills: - Proficiency with both Asana and Zapier applications - Experience with SMS and Email automations - Strong problem-solving abilities - Excellent teacher with the ability to breakdown complex...

I've got around 50 image folders with less then 1000 files in jpg format, each with GPS metadata. I need an expert to convert this m...points should correctly represent the image positions. They will be broken into 3 colours depending on the date they were taken, the data is in the folder name and file name. Ideal Skills: - **GPS Data Handling:** Understanding of how to extract and work with GPS metadata from images. - **Google Earth Proficiency:** Experience in creating KML files and working with Google Earth is a must. - **Automation:** Familiarity with tools or methods that can automate the process of generating points from image metadata would be a significant advantage. If you have experience in this area and can deliver accurate and efficient results, I'd li...

...gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Selenium, etc. Solid knowledge of HTML, CSS, and JavaScript to understand the structure of web pages. Ability to work independently and meet established deadl...

I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I require a professional with a high level of expertise in web scraping and API integration to assist with a critical project. Here are the specifics of the project: - I need you to scrape data from , a website where we dropship our designer clothing products. - Specifically, I need the following details scraped: Product names, Product Colour, Product Sizes In Stock & Not in Stock, Product Prices (Only Black & Grey Pricing, not red sale price), and Search Key. - The scraped data should be automatically updated on a daily basis. - The scrapped data should be integrated into our Shopify store through an API bot. The ideal candidate should have a proven track record of working with similar projects and should be able to tailor the solution to our specific needs. Please include in...

I require an experienced data analyst conversant with Excel to create a detailed spreadsheet and comprehendible report about compression pay between LPN & RN nurses, as well as nurse supervisors. Key data points to include: - Hourly pay rates of each role - Years of experience in each position - Total number of employees in each role - Comparison of compression pay between the nurse employees and nurse supervisors The compression pay should be calculated using a ratio comparison method, highlighting the variation in detail. I am also looking for a detailed analysis in the report explaining the compression shown. Required skills: - Proficient in Microsoft excel - Experience in generating analytical reports - Strong attention to detail - Understanding of th...

I am looking for an experienced developer to build a program to provide a program that increases the number of live views for both TikTok and Bigo Live. The program should be open source and have option that i can create a password for it and give it to others for specific time. Your application should include: - Detailed account of your experience in this field - Examples of any similar projects Once hired, I would want daily updates on the progress of the project, to ensure all milestones and deliverables are being met within the designated timeline.

Hello, I'm looking for someone to create a Google Sheets spreadsheet filled with YouTube URLs that meet the following criteria: * License: Must be Creative Commons licensed. * Visuals: - Full face visible, speaking directly to the camera; the rest of the body can be included. - Only one person in the shot and speaking throughout the entire video (no cuts to other people). * Quality: High definition (HD or better), not grainy. * Editing: Minimal editing; should be a single take (intro and fade out are acceptable). * Audio: Clear speech; background noise or music is okay if it does not overpower the speech. * Occlusions: No obstructions, such as hands or microphones, in front of the face. * Emotion: Videos displaying significant emotional expression are preferred...

I am in need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - I need you to know more about KDP marketing than I do. I only know the basics. I need an advanced skilled...listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to optimize listings. Through these efforts, the ultimate goal is to increase the visibility of my coloring books on Amazon, targeting a better ranking in search results, and thereby improving sales. If you have the skills and experience to excel in this role, I would be thrill...

... - **File Format**: The directory should be in Excel (.xlsx) and easily editable. - **Data Required**: The spreadsheet should include Business Name, Address, Phone Number, Email (if available), and any other relevant contact details. - **Usage**: I'll be using this directory for sales lead generation, so it's crucial that all the information is up-to-date and well-organized. - **Categorization**: The businesses should be categorized by specific industry (e.g., Hospitality, Retail) to help with targeted marketing efforts. I would like this done for the retail/hospitality e.g. butchers, newsagents, cafes, and convenience stores. We are not targeting large chains or franchisees. **Ideal Freelancer**: - **Excel Expert**: Proficiency in Excel is a mu...

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

Seeking a skilled professional who can help finish up the set-up of Zoho CRM for my organization. We are using Zoho CRM to manage the patients who want to seek second med...their portal 9. Patient is requested to provide next of kin details and visa details 10. Patient is notified of the travel arrangements and given an option to book a call to discuss if they want to 11. Patient is sent an invoice for the consultation (Zoho books) 12. Patient is requested to set up a post-treatment feedback 13. End Some of this process has already been done. The templates, some automation and even the logic behind the treatment progress have been done. I don't know if the previous developer did a good thing but I am open to any suggestions. Kindly reach out if you can implement this flow as s...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any relevant...

I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project req...

One excel file with macro as per requirement

...expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modellin...

...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...

To help manage my work efficiently, I am in need of a proficient virtual assistant. Using Google Sheets, your initial task entails creating a spreadsheet listing festivals held in Louisiana and Mississippi. This sheet should include: - Festival names - Festival locations - Festival dates Apart from spreadsheet creation, I'll also require assistance with customer service tasks. This role best fits someone that is skilled in utilizing Google Sheets and who possesses excellent customer service skills. Prior experience in a similar role is a bonus, but not a must.

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'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

Posting by python on facebook grps.

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...