Excel automatic data entry formula punët

Merge excel spreadsheet for the 3rd project

I'm seeking an experienced Virtual Assistant to generate high-quality tutoring leads for AstraX Education, primarily targeting high school students in need of Math and Science tutoring. Responsibilities: - Proactively search Facebook groups, Reddit, Gumtree, and other re...- Provide daily or weekly reports on progress and lead quality. Requirements: - Proficient understanding of social media platforms, particularly Facebook Groups, Reddit, and Gumtree. - Fluent in English with strong communication skills. - Basic to intermediate knowledge of Google Sheets or Excel. - Prior experience in lead generation or virtual assistance is preferred. This role is crucial for our growth at AstraX Education. Your skills and experience will directly contribute to helping students excel...

As a hiring manager, I need a diligent and efficient assistant to help with reviewing job applications, entering candidate data into our company system, and managing data processing. This role can be part-time or full-time, with a competitive salary. Ideal Candidate Skills: - Strong data entry skills - Proficient in Excel and Word - Experience with data processing Key Responsibilities: - Reviewing and approving job applications - Entering candidate information into the company system - Data processing Proficiency in Excel and Word is a must. Experience with HR software and previous hiring manager experience are not required but will be an advantage.

I have a number of PDF files that require manual data entry into an Excel spreadsheet. Attention to detail and accuracy is paramount for this task. Ideal Skills and Experience: - Proficient in manual data entry - Experienced with handling PDF files - Highly skilled in Microsoft Excel - Detail-oriented and accurate

...WebSocket connection to receive real-time OHLC (Open, High, Low, Close) data for multiple stock symbols at 5-minute intervals. Responsibilities: Establish a WebSocket connection to receive OHLC data for specified stock symbols. Collect and process OHLC data at 5-minute intervals. Save the latest OHLC data into a new CSV file every 5 minutes, including the timestamp, open, high, low, and close prices. Handle automatic reconnections if the WebSocket connection is lost or closed. Ensure that the CSV file is named with a timestamp based on when the file is created. Skills Required: Experience with WebSocket API integration. Proficiency in Python (or another relevant language for WebSocket and file handling). Experience with real-time data collectio...

As an accountant, I work a lot with Excel. I am looking for a freelancer with strong Excel and automation skills to help me streamline certain tasks. Key tasks include: - Automate data analysis and reporting processes - Identify specific quantities in my data sets The main focus will be to automate the analysis of trends with a specific emphasis on my spending amounts. The ideal skills for this job include: - Competence in Excel, particularly in the use of advanced features and functions either formulas, macros etc. (preferably macros) - Experience with task automation in Excel - Strong data analysis skills - Understanding of accounting principles and terminology

I need you to fill in a spreadsheet with data. The data written on paper I need it to be in excel

I need to set up a connection between QuickBooks Online and Microsoft Excel using cdata. The purpose of this connection is to transfer financial reports from QuickBooks to Excel on a daily basis. The level of detail in the reports needs to be customizable. Ideal skills for this job include: - Experience with cdata and its applications - Proficiency in Microsoft Excel - Familiarity with QuickBooks Online - Data analysis and report generation expertise - Ability to set up automated processes for daily updates. The successful freelancer will help me create a seamless connection between the two platforms, allowing for efficient and effective financial report tracking and analysis.

I'm seeking a diligent Team of Classified Traffic Count Enumerator to analyze vehicle traffic from video footage. Responsibilities: - Count various vehicle types every 15 minutes. - Accurately log data into a specified Excel format. Vehicle Types to be Classified: - Cars, Trucks, Motorcycles - Auto Rickshaws, Cycle Rickshaws, Bicycles - LCVs under 4 Tons, 4-6 Tons, and 6 Tons - Tractors with and without Trailers - Construction Equipment Vehicle Types to be Counted: - All of the above vehicles Ideal Candidates: - Experience in data entry and traffic analysis preferred. - Proficiency in Excel essential. - Attention to detail and ability to work meticulously under time constraints. Prior to awarding the job, you will be given 15 minute video to co...

...you are responsible for supporting the Logistics and Operations department. This includes but is not limited to, being responsible for all daily operations in the warehouse including all inventory handling, stock allocation support, warehouse organization, managing and handling shipping, loading and unloading of products and picking and packing. You will be required to handle phone inquiries, data entry and reporting transactions while ensuring that records are maintained and inventories up to date. You will ensure you are familiar in operating the necessary tools in maintaining and managing a warehouse. Your responsibilities will also include special projects as assigned. Strong attention to detail and the ability to work in a fast-paced environment are essential. If y...

I'm seeking a detail-oriented individual for a copy-paste data entry task. Your primary responsibility will be copying data from my emails into online forms. Ideal Skills: - Exceptional attention to detail - Quick typing skills - Experience with data entry - Proficient in handling online forms - Excellent understanding of following instructions accurately Your role will be key to ensuring my data is organized and submitted correctly. I am looking for someone who can deliver quality work consistently, without errors, and meet deadlines. Your ability to manage this task efficiently will make you a reliable asset for this project.

I'm in need of a technical expert who can help me set up and configure a system to automatically send all my limit order signals from TradingView to Tradovate via webhooks. This project includes: - Setting up the technical configuration needed for this system - Ensuring all limit order signals are sent smoothly and automatically The ideal freelancer for this project should have: - Extensive experience with TradingView and Tradovate - Proficiency in technical setup and configuration - Understanding of webhooks and their integration

I need assistance in extracting a dataset from a scanned PDF document and formatting it into a CSV file. The last 24 pages of the document...formatting it into a CSV file. The last 24 pages of the document () contain the dataset that needs to be copied. This can be done by hand, by OCR, or by a mix. Key requirements include: - Cleaning and formatting the data as seen in the PDF - Leaving incomplete or missing data points blank - Using the column names given in the PDF for the CSV file Ideal skills for this project: - Proficiency in OCR or hand data entry. - Every person and program makes mistakes, so you need to understand what data values make sense, and have a system for catching, verifying, and correcting outliers, anomalies, and errors.

I'm working on a homework assignment involving 4 problems that need to be solved using Excel Solver and regression analysis. All solutions must be shown in an Excel file, complete with the solver box in its entirety. The data sets I'll be working with pertain to sales. The primary goal of the assignment is to utilize Excel Solver to maximize profit. Ideal Skills: - Proficient in Excel, specifically with Excel Solver and regression analysis. - Strong understanding of sales data. - Capable of creating comprehensive Excel files. Experience: - Prior experience with similar assignments or projects preferred.

...month-end and year-end closing processes. Assist in budgeting, forecasting, and other financial tasks as required. Qualifications: Proven experience as a Bookkeeper in the US or working with US-based businesses. Strong understanding of US GAAP (Generally Accepted Accounting Principles) and tax laws. Proficiency in QuickBooks Online, Xero, or similar accounting software. Excellent skills in Microsoft Excel/Google Sheets and other productivity tools. Knowledge of payroll systems and processes. Requirements: Degree in Accounting, Finance, or related field (preferred but not required). Minimum of 2-3 years of bookkeeping experience in a similar role. Ability to work independently, prioritize tasks, and meet deadlines. Strong analytical and problem-solving skills. Excellent verbal a...

I need a skilled Python programmer to help me automate the order placement on Interactive Brokers. Ke...platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give Budget:1050 if you can provide result with my budget, Not your Expectation, I will give good review, if you complete my budget, Dont expect more money If you have experiece in trade a...

...a variety of administrative tasks across both my business and personal activities. This is a long term, ongoing role for the right candidate, so I'm looking for someone who is not only skilled but also adaptable. Key Responsibilities: - Manage my calendar -Work on projects with me - Book travel -Gather information - Utilize G Suite and MS Office for various tasks including document creation, data entry, and email management. - Collaborate with my team using Trello and other collaborative tools. - Communicate effectively in written English for correspondence and updates. -Work with the marketing team and in the backend of our various software used for marketing and training Ideal Skills and Experience: - Proven experience as a Virtual PA or in a similar administrativ...

Please check the attached file, 'STAFF TRAINING LIST'. Input the date and course completed into the Excel file. Also, please list in a Word file which staff members have not completed specific training. I can pay 10 CAD, and I need it done within 1 day

Looking for Arduino FastLed library expert to complete board code for 120 Leds stripe (ws2812B) clock Board is NodeMCU ESP8266 , getting ntp local time. Mandatory : smooth led transitions (fading chase sequantial for seconds) Hour shift between minutes aurora / breathing effects on 12 and 24 clock time Day/night automatic (based on hour time) brighness dimmer level any other improvment will be evaluate.

I need an Excel macro expert who can help automate the report generation process in Excel.

I need an Excel macro expert who can help automate the report generation process in Excel.

...experience with Zapier integrations - Proficiency in working with fuel management systems - Strong analytical skills for interpreting fuel purchase data - Familiarity with CRM software, Email marketing tools and E-commerce platforms will be an advantage. Project Outline We utilise a Fluid Management System form a company call FMT, there is an existing API and documentation available and we have used this API with a previous system, but there is no existing integration in Zapier currently. Probably need to use webhooks etc. We need to: 1] Updated from a MS excel CSV file Vehicle data using the API 2] Updated from a MS excel CSV file Plant data using the API These files will be generated by an internal system and loaded to a specific location either on...

...create a complex Excel formula for me. I currently have a formula that takes several variables to calculate rates and taxes from a net value to derive a gross value. What I need now is a reverse formula that will take a gross value and return to net value using the same rates and taxes. Key Requirements: - The formula must be able to handle multiple tax rates and deductions, as I have several different rates and deductions to factor in. - The types of taxes and rates that will be part of the formula are mainly Brazilian taxes, so familiarity with these rates would be an advantage. Ideal Skills: - Advanced Excel skills, with experience in creating complex formulas. - Understanding of various tax rates and deductions, particularly Brazil...

I'm seeking a skilled developer capable of creating a unique Fibonacci TradingView indicator tailored for cryptocurrencies. Key Features: - Automatic Fibonacci retracement and extension levels: The tool should automatically identify and display these critical levels, saving me time and enhancing my trading accuracy. - Customizable Fibonacci levels: It should allow me to modify the Fibonacci levels according to my personal trading strategy. - Visualization: The Fibonacci levels must be represented as colored regions/ lines on the chart. This project should be well-versed in TradingView's Pine Script language and have a deep understanding of Fibonacci levels and their application in cryptocurrency trading. Experience with developing TradingView indicators is a significan...

...as the founder. About You I’m not looking for beginners, mid-level engineers, or agencies. I need an experienced solo developer who can confidently manage a fast-growing and technically complex platform without external support. If you don’t meet the qualifications listed below, please don’t apply, as I will only be considering candidates with the required expertise. What You’ll Work With To excel in this role, you need strong experience with the following technologies: Flutter Node.js/Express Azure (App Service, CDN, Front Door) Firebase Backblaze MongoDB Postman Nodemailer Handlebars Resend Intercom Slack Non-Negotiables To succeed in this role, you must meet the following criteria: Availability: Be online and available from 1:00 PM Australian East...

Employee Uniform Ordering System Objective: Create a system for employees to order uniforms and an admin dashboard for managing orders. Deliverables: 1. Order Form (Google Forms/Excel) with dropdowns for uniforms and sizes. 2. Admin Dashboard (Google Sheets/Excel) with order summaries and charts. 3. Aushang Design with QR code Skills Required: • Google Forms/Sheets or Excel with VBA • Data Visualization • UI/UX Design • Graphic Design

... Currently, we're using Google Sheets and Excel for our daily ledger, credit-debit journal, and voucher entries, but it's not meeting our needs. Key Requirements: - User Interface: The interface should be customizable with themes. It should allow us to switch between different looks and feels based on our preference or requirement. - User Authentication: The system should support a simple username and password authentication. - Features: The platform should have the following features: - Automated Reports: The system should be capable of generating reports automatically based on the data inputted. - Multi-User Access: It should allow several users to access and input data concurrently. - Data Export Options: We should be able to export dat...

...accounts for seamless access. 2. Payment Integration: Automatic Deposit: Crypto (USDT) Manual Withdrawal: A manual withdrawal option. 3. Referral program. 4. Investment Feature: - Users can invest in an offer that lasts for 24 hours. - After the 24-hour period, users will receive their invested amount back with a profit. 5. Game: - Connect the Casino table game, so that users can play the game using their main balance on this platform. Admin Dashboard: - A simple admin dashboard with options to manage users, monitor transactions, handle withdrawals, and few others. Requirements: - Experience in Casino game development. - Proven experience in web development with payment integration. - Familiarity with security protocols to handle user data and financial transactions. -...

I need an MS Office expert who can help me craft a detailed research report. The report will be prepared using Microsoft Word, Excel, and PowerPoint. Key Responsibilities: - Collect and organize information I provide. - Gather and analyse additional relevant data. - Create a comprehensive research report. - Design and incorporate engaging PowerPoint slides. - Generate and include relevant charts (Bar, Pie, Line) in Excel. Ideal Skills: - Proficiency in Microsoft Word, Excel, PowerPoint. - Strong analytical skills to gather and interpret data. - Excellent report writing skills. - Ability to create visually appealing presentations. - Experience in creating research reports. Please provide samples of previous reports you have created, preferably research ...

...Power BI engineer to create interactive and insightful data visualizations and dashboards. Key Requirements: - Experience with Power BI - Proficiency in data visualization - Ability to create user-friendly dashboards Data Sources: - The data will primarily come from Excel files, Jira, and Salesforce, along with some miscellaneous sources. Therefore, experience integrating these data sources with Power BI would be beneficial. Data Updates: - The dashboards will need to reflect daily updates. Previous experience handling regular data refreshes in Power BI is preferred. Skills & Experience: - Expertise in Power BI is essential, with a strong focus on creating data visualizations and dashboards. - Prior experience in...

The project involves generating power plant which includes 8, 5kV generators, 5kV switchgear, step-up and step down transformers 2.5MVA, 4.16/25kV and transmission lines. The project also involves another distribution substation and distribution transformers and switchgear in addition to automatic voltage regulators. I'm looking for someone to provide an estimation for the above work including labor and materials. The project will be in the Canadian Northern Territories. Therefore, Canadian experience will be required. The estimates must comply with CSA and IEEE standards. Ideal candidates should have extensive experience in cost estimation for medium voltage substations and a deep understanding of these standards. Please provide examples of previous similar projects you...

I'm looking for a professional...Areas of Focus: - Enhance loading speed - Optimize database queries - Improve user interface responsiveness - Create a new, modern dashboard - Implement multilingual support based on the client's country IP - Redesign the automatic email sending system Ideal Skills: - Extensive experience with React.js, Node.js, and MongoDB - Previous work on site migration from PHP and Laravel - Strong understanding of performance improvement techniques - Skills in creating modern, user-friendly dashboards - Experience with implementing multilingual support - Proficiency in designing automatic email systems Your expertise in these areas will greatly help in revamping existing features, updating crucial functionalities, and ensuring a smooth transi...

We are looking for a dedicated freelancer to help us expand our sales on Etsy in international markets, including Italy, Germany, the UK, and Canada. This is a revenue-sharing opportunity where you can earn 30% commission per sale, with an average payout of $50 or more per sale. What We Offer: No investment required – We cover all expenses, including inventory, IP setup, and listing costs. Earn a consistent commission – You’ll earn 30% of the revenue from every sale. Work with a team experienced in selling digital software and physical products in global markets. What You’ll Do: Collaborate with us to list and manage products on Etsy. Help target specific international audiences (training will be provided if needed). Ensure the growth of sales through basic marke...

I'm in need of an office support staff member to help with both administrative tasks and customer service. Administrative duties include: - Data entry - Sending faxes - Uploading received faxes - Sending invoices - Managing insurance claims Customer service tasks primarily involve: - Answering phone calls - Notifying customers about outstanding invoices -Helping new patients schedule a consultation Ideal candidates should have strong data entry skills, experience in handling customer service, and be able to manage administrative tasks efficiently. Good communication skills and a customer-oriented mindset are essential.

...interactive shopping cart. Offer personalized recommendations based on user and environmental conditions. Support multiple payment methods for completing purchases. 1.2 System Objectives Deliver a fast, personalized, and innovative shopping experience with seamless voice or manual interaction. Reduce operational costs and maximize efficiency in small spaces. Ensure continuous offline operation with automatic synchronization when online. 1.3 Special Features Outdoor Operation: Built for external environments, resistant to external noise, weather, and vandalism. Hybrid Interaction: Switch between voice and touch interaction. Voice-Controlled Shopping Cart: Customers can manage their cart (add, remove, or check products) using voice commands. 2. Hardware Requirements Main Unit: Proc...

...my small engineering firm. The tasks will include: - Scheduling and Calendar Management: You will be responsible for managing my calendar, scheduling meetings and coordinating with relevant stakeholders. - Email Management and Correspondence: You will handle my inbox, filtering emails, responding to common queries and drafting correspondence. - Data Entry and Document Preparation: You will assist with the preparation of documents and data entry tasks. - Client Follow-Up: You will be responsible for following up with clients about project updates and feedback. - Meeting Minutes: You will take detailed notes during meetings and distribute the minutes to all relevant parties. - File Management: You will organize and manage digital and physical files, ensuring...

...timelines. Add KPI tracking with dashboards, target-setting, and visual progress monitoring. Create custom reporting templates with data visualization tools (e.g., charts, trends). Enable task and milestone tracking with automated notifications for deadlines and status updates. Role-based user access for admins, researchers, M&E, and project management staff with multi-level permissions. 2. System Integration: Configure bulk data imports (Excel/CSV). Set up APIs or connectors for integration with tools like KoboToolbox or Google Sheets. 3. Data Quality Checks: Automate validation rules to ensure data consistency and accuracy. Add audit trails for tracking data changes. 4. UI Enhancements: Simplify the interface for non-tech...

I'm in need of a spreadsheet that can automatically generate graphs from my inputted financial data. This is essential for my internal reporting. The spreadsheet should: - Accept various forms of financial data input - Automatically generate pie charts, line graphs, and bar charts The ideal freelancer for this job should have a strong understanding of finance, spreadsheet software (like Excel or Google Sheets), and data visualization. Please provide examples of similar projects you've completed.

...impact our success. As we scale, so will your opportunities. What We’re Looking For: - Proven experience using AI tools like GitHub Copilot, ChatGPT, or similar to streamline development. - Familiarity with modern frameworks and tech stacks. Adaptability and a willingness to learn are more important than expertise in a specific stack. - Strong communication and self-management skills to excel in a remote setting. How to Apply: Please share the following: 1. A brief overview of your background and experience. 2. Examples of how you’ve used AI tools in previous projects. 3. Your availability in terms of hours per month for the $200-$300 budget. We’re looking for someone passionate about leveraging AI to create impactful solutions. If this sounds l...

I'm in urgent need of an assistant who can help me with an accounting task, specifically with the reconciliation of a business loan. The primary focus will be on account balancing. Skills and Experience: - Proficiency in Microsoft Excel - Strong accounting skills - Experience with business loan reconciliation - Attention to detail in account balancing Please only apply if you can assist urgently. Thank you.

I'm looking for a skilled Python developer who can help me fetch real-time stock and Option data from the Angel Broking Smart API and store them in a single Excel sheet. Key Requirements: - Proficient in Python with experience in API integration. - Familiar with Angel Broking Smart API is a plus. - Excellent skills in working with Excel through Python. - Ability to manage real-time data fetching. The goal of this project is to continuously monitor stock prices and log them in an organized manner within an Excel file. If you have the necessary skills and experience, I would love to hear from you.

...sector. I need a professional to create a new website for my company with a primary focus on lead generation. Key Requirements: - Implementing functionalities similar to GoModern's platform. - Integrating a CRM system for efficient lead management. - Including a contact form for potential clients. I have an Excel file with potential leads that I may need assistance in importing. I currently manage 2 Rent To Own projects and require help with email imports and other data integration. In terms of marketing, I need optimization for: - Facebook - Google - SEO for Google - Google Ads - Facebook Ads I aim to complete this project by the end of January. The ideal freelancer for this job should have experience in web development, CRM integration, and dig...

As part of the DISC Analysis System Project, I will develop a feature that allows users to download the final report in both PDF and Excel formats.

I'm in need of a seasoned developer who can create a cross-platform (Desktop and Web) Excel plug-in/add-in. The primary purpose of this tool will be automating report generation by pulling data from various APIs.

I'm seeking assistance with data inputting from multiple Excel workbooks. The data is related to racing and includes: - Prices Ideal candidates for this project should have experience with Excel, data inputting, and ideally some understanding or interest in racing data. Attention to detail and accuracy are paramount as the integrity of the data is crucial.

I'm in need of a freelancer to help with a data entry project. The task involves copying data and entering it into a plain text file. Ideal skills and experience for the job: - Attention to detail for accuracy in data entry - Familiarity with handling plain text files - Ability to work independently and meet deadlines

...if some websites are no longer tracking data on a website. preferably in an overview or sending alerts when a website is no longer tracking activity on the site. ( similar behaviour like uptimerobot) uptimerobot can see when google analytics code is integrated, but doesn't know when it's no longer tracking. Just checking if the google analytics code is present IS NOT ENOUGH I was working on a google looker studio overview with graphs of each site, but it's limited Looking for an easy scalable solution for example all the sites posting their current users in 1 google sheet for example Some ideas I found: Step 1: Use Google Analytics Data API for Tracking Activity The Google Analytics Data API allows you to programmatically access analytics d...

I'm seeking a skilled Excel/Google Sheets expert to assist with my trading analysis file. The sheet is pivotal for determining entry prices, evaluating trade quality, and tracking profit and loss. Key Responsibilities: - Improving and fixing complex formulas related to entry price calculations - Ensuring all calculations are accurate and reliable Ideal Qualifications: - Proficient in Excel and Google Sheets - Strong comprehension of financial calculations and trading concepts - Experience in data organization and creating visualizations Please note, while the initial focus will be on fixing and enhancing the entry price calculations, I may require additional support with data structuring and visual representation in the future. Accu...

I'm in need of a proficient freelancer who can modify an existing Excel spreadsheet I use to calculate final grades for my college classes. The sheet automatically calculates grades based on a letter grade (A-F) scale, but need to be updated in order to accommodate a new grading scale I have adopted. This involves the following key requirements: - Automatic Grade Calculation: The Excel sheet should be capable of computing the final grades based on individual scores. - Letter Grade System: The sheet should use a letter grade system (A-F) for grading. I am using a relatively new grading system to determine final grades in my college courses. It is called SPECS grading (short for “Specifications” grading). To summarize, a student will “Pass&rd...

I recently set up a new server for my website, using a different domain than my old one. I need an expert to reconfigure Let's Encrypt on this server and ensure it is set up for automatic renewals. Key Requirements: - Reconfigure Let's Encrypt for a new domain - Set up automatic renewal for Let's Encrypt certificates Skills Needed: - Extensive experience with Linux CentOS servers - Prior knowledge and hands-on experience with Let's Encrypt - Strong understanding of domain configuration Important Note: - I will set up anydesk