Excel automatic data entry formula jobs
I have a set of handwritten notes that require data entry in to digital format. The primary task will be transcribing these notes into text. Ideal Skills and Experience: - Proficient in typing with high accuracy - Experience in data entry - Attention to detail - Able to meet deadlines
I'm seeking assistance with manual data entry tasks from text files. The project encompasses handling approximately 50-200 text files. Ideal Skills and Experience: - Proficiency in data entry - Attention to detail - Experience with text file processing - Ability to maintain confidentiality and handle data responsibly.
I'm looking for a Python/Java/ any other developer to create a simple trading bot for Binance Futures. The bot should allow for manual order placement and track client profits. Key features to be implemented: - Manual entry of API keys for connecting user accounts. - Capability to manually place market orders via the bot. - Daily, weekly, and monthly profit tracking per client. - Three distinct screens: 1. Client addition with API keys. 2. Open positions management with TP/SL. 3. Client-specific profit reports. The ideal candidate for this project would have: - Strong expertise in Python. - Previous experience with Binance Futures API. - Ability to design user-friendly interfaces. This trading bot is intended for manual trading, so experience in manual trading inter...
...We need to improve the admin system - and develop a fully operating high quality admin dashboard - we need to assign roles - for super admin, admin and user profiles, upload content to our blog and news pages - and collect visitor analytics and data. The dashboard needs to manage all our systems - and user accounts - as well as content and blogs and articles - easily and quickly. It will be the main control centre for the whole website and all its functions and visitors. 4. Option to write a monthly newsletter - and automate this as an automatic send out to members and registered news readers - we would like to work with someone who has extensive knowledge of Ai systems - and who can help us to maximise the use of Ai technology. 5. I’d like to be able to check ...
I'm in need of a virtual assistant who can assist with data entry tasks. The primary focus will be working with customer information. Key responsibilities: - Data Entry: Accurately inputting customer information into our CRM software. Ideal candidate: - Prior experience with data entry and handling customer information. - Proficient with CRM software. - Detail-oriented and able to maintain high levels of accuracy. This role is crucial for maintaining our customer database and ensuring smooth operations.
...accounts and is designed for both admin and evaluators. Key Features: - Admins can upload answer sheets in PDF format along with the corresponding mark scheme. - Evaluators assess the answer sheets using provided annotation tools: text comments, highlighting, and drawing. - Each student is able to view their individual scores and receive feedback on their answers. - All scores are exportable to an Excel sheet with detailed question-wise marks. - Feedback for students is sent via email notifications. Ideal Skills and Experience: - Proven experience in web-based application development. - Familiarity with creating systems for educational purposes is a plus. - Proficiency in implementing secure, user-friendly interfaces. - Experience in integrating with Google and Outlook services...
I'm seeking a professional who can set up a system that fully automates the updating of my investment portfolio Excel sheet with the daily NAV values from a specific website. Currently, I access the NAV values through manual browsing. This project requires: - Creating an automation system that fetches the daily NAV values from the website without any manual intervention on my part. - Updating my Excel sheet with the fetched data. The ideal freelancer for this project should have extensive experience with web scraping, Excel automation and ideally has worked with investment portfolio data before. The aim is to have a seamless process where my Excel sheet is always up-to-date with the latest NAV values. Please note that the specific format of...
I'm seeking someone from Australia to assist me with data entry tasks, specifically form filling.
I'm looking for a Python programmer who can pull live NSE options data into an Excel sheet using the Zerodha kite API. The data should encompass: - Price data - Volume data - Open interest data - Implied volatility - Last traded price - Change of open interest The ideal candidate would have a deep understanding of financial data, experience working with APIs, and the ability to create a seamless integration with Excel. Please include in your proposal examples of similar projects you've completed. ATM + 3 strike prices always. If nifty current price is changing then ATM + 3 should change automatically From all the API data we need to have data points like Change of open interest, volume, last traded price, i...
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. NEED TO CALL AND DISCUSS SOME DETAILS BEFORE STARTING WORK
...have an Excel file with a scatterplot chart located on the "Graph" sheet. This chart is powered by the worksheet "Calculation" and contains VBA code and ActiveX form controls. I need this functionality replicated online with the following requirements: 1. **Interactive Scatterplot Chart:** - The scatterplot chart should display on a publicly accessible webpage. - Users can interact with dropdowns and selection boxes to customize axes and data shown dynamically. 2. **Multi-User Support:** - Multiple users should be able to access the "Graph" sheet simultaneously. - Each user should have their own settings defined by the dropdowns and selection boxes, without interference with other users' sessions. 3. **Backend ...
I'm looking for a Python programmer who can pull live NSE options data into an Excel sheet using the Zerodha kite API. The data should encompass: - Price data - Volume data - Open interest data - Implied volatility - Last traded price - Change of open interest The ideal candidate would have a deep understanding of financial data, experience working with APIs, and the ability to create a seamless integration with Excel. Please include in your proposal examples of similar projects you've completed. ATM + 3 strike prices always. If nifty current price is changing then ATM + 3 should change automatically From all the API data we need to have data points like Change of open interest, volume, last traded price, i...
As a medium-sized enterprise...Key Responsibilities: - Bookkeeping and Data Entry: Accurate recording of financial transactions to maintain our financial integrity. - Financial Reporting and Analysis: Generation and interpretation of financial reports to assist in strategic planning and decision making. - GST and Tax Filing: Handling all GST and tax obligations to ensure our compliance with tax regulations. The primary goal of this position is to ensure complete adherence to tax regulations. The ideal freelancer for this role will have an extensive background in accounting, proficient skills in Tally, and a proven track record of handling financial tasks for medium-sized enterprises. Your expertise will be pivotal in maintaining our financial accuracy and streamlining our ...
...various platforms. • Optimize SEO and improve search engine visibility. • Create engaging content and manage social media accounts effectively. 4. Web Design and Landing Pages: • Design professional and user-friendly interfaces. • Develop landing pages that are visually appealing and conversion-optimized. 5. Data Management: • Input and organize large datasets accurately. • Sort and update CRM (Customer Relationship Management) data efficiently. • Manage files and ensure data consistency across systems. Requirements: • Proven experience in the listed fields. • Ability to work as part of a large team and coordinate effectively. • Commitment to deadlines and delivering high-quality work. • Flexibilit...
I'm seeking a finance expert who can create a clear financial model with valuation in excel, focusing on our business, Flyer Eats and Swiss Cafe. This valuation is primarily for investment purposes, using the Discounted Cash Flow (DCF) method. I have historical financial data available for the past 3 years. Ideal skills and experience for the job: - Proficiency in financial modeling and valuation - Expertise in Excel - Familiarity with DCF method - Background in assessing businesses for investment purposes - Ability to present financial data clearly and succinctly
...needs additions and also, it’ll have some current features needing to be fixed. Project Overview for Rideshare App Development Objective: To enhance the functionality, user experience, and operational efficiency of the Boon Rideshare app through various improvements in payment systems, UI/UX, pricing, territory management, server performance, and new features. 1. Payment System Overhaul Tasks: Automatic Payment Processing: When a driver completes a ride by pressing the "Complete Ride" button, the payment should be automatically processed without requiring user confirmation. The fare should be released from a hold placed on the user's card when the ride was initially requested. Ensure secure, seamless integration with existing payment gateways. 2. UI Enhan...
I'm looking for an expert who can help streamline the patient management process in our hospital. The primary focus will be on enhancing our appointment scheduling system. The ideal freelancer should have: - Extensive experience with implementing and customizing Hospital Management Systems (HMS). - Proven skills in data entry, migration and technical support. - Ability to provide training and generate insightful reports and analytics. - Proficiency with tools like MS Excel, Word, PowerPoint and HMS platforms such as Meditech, Cerner, Epic. If you have a track record of enhancing healthcare efficiency and can provide tailored solutions to fit our facility's needs, I'd love to hear from you. Let's work together to improve our patient management syst...
I need someone to assist in migrating user data from my online portal account to a CSV/Excel file. Ideal Skills: - Data Migration - Proficient in handling CSV/Excel files - Familiarity with online portals Experience: - Prior experience in similar data migration projects preferred.
...productivity. • Ensure sensitive data security. 2. Recommended Technical Specifications 2.1 Language/Framework • Backend: Node.js with Express. • Frontend: React.js. • Database: MongoDB. • Hosting: On-premises. • Accessibility: Responsive design. 3. Proposed Architecture 3.1 Model-View-Controller (MVC) Architecture • Backend: RESTful API server. • Frontend: Single Page Application (SPA) for the user interface. • Database: Relational model structured to match business entities (clients, items, reservations, payments). • Architecture Diagram (Simplified): User ↔ Interface (Frontend) ↔ API Backend ↔ Database ↔ External Services (storage, notifications). 4. Security Requirements • Role-based ac...
... You must be ready to start work and get it done though. 1: Make sure these system are recording the proper number on my trading system in the proper areas balance equity margin 2: Make sure the following executions are working 1: Stop Loss 2: take profit 3: Buy Stop/Limits 4: Sell Stop/Limits 3: Add these formulas to the backend so when I create a symbol it will tell the system what formula to use. Formulas: Here is a conversation about formulas 1: Any pair/ USD 2: USD/ any pair 3: USD/PY 4: JPY/Any pair converted to USD 4: Any/Any converted to USD 5: Indices 6: Crypto/usd 7 crypto/crypto converted to usd 8: Metals to USD Note: The system already has 95% of these functions inside of it, they just need to be duplicated for more on the drop down and or edited to wo...
...liage I make digital products, your job will be to create cover images and product images for my products. Like the one seen in the example. Mockups are allowed for you to use, but must be royalty free. ___________________________________ Mark: To win this contest, and to get hired long term, you WILL need to create 10 images of an example product, and showcase them here. Please only post 1 entry with all 10 images. Unless you know that you can make the same standard and level of quality, I encourage you not to waste your time on this. If you can make the same esthetic quality, then please, go ahead. ___________________________________ PS: You do not need to make similar images as the ones in the example case. They should be your own art, style and composition. The example ...
...of blue, grey, and white for a clean and contemporary look. ### **Guidelines for Submission:** 1. Designers must submit **two distinct designs**, one for each logo: **Full Funnel** and **Genext Cloud**. 2. Variations of a logo (e.g., different layouts, color schemes, or typography) are welcome but should be clearly labeled. 3. Designers are encouraged to submit multiple entries, but each entry must include two designs—one for each logo. 4. Ensure both logos are versatile and adaptable for digital and print formats. 5. Maintain clean, professional, and industry-specific aesthetics for each logo. We are excited to see your unique designs for these two logos! **Important:** Submissions should align with the brand themes and identities described above. Good lu...
Please note that the Budget is fixed - Need beginner skills users only - budget is as de...improvement suggestions 2) Answer on your own for about 80 questions 3) Compile your answers in Excel worksheet and format as required. -this is a simple task and will require up to 5 sessions of 2 hours each via chat -Project budget is fixed and it is not by hour -Need users with beginner skills only -Please note no place holder bid - what you bid will be your final price for this task I'm looking for beginner users of social media apps to provide feedback on a new app. The primary focus is on user experience. You will need to compile your observations and feedback in an Excel spreadsheet. Ideal Skills and Experience: - Familiarity with a variety of social media apps - Basic u...
...bench by the window, incorporating textures like wood or cushioned seating for added comfort. Appliances: Full-sized oven (built into a cabinet), stovetop, microwave, hood, farmhouse sink, and a full-sized fridge. Cabinetry: Varied cabinetry in different shapes, sizes, and finishes (some with glass panels). Cabinets should extend to the ceiling for a refined look. Glass Wall: A glass wall for the entry door area to maximize natural light. Fermentation Corner: A dedicated space with shelves or a countertop featuring a unique finish for storing fermentation tools and jars. Corner Pantry: Corner cabinets designed for a functional and stylish pantry space. Style and Aesthetic: A mix of complementary colors and textures: think painted cabinets in soothing tones, natural wood finishes...
I'm looking for a Google Sheets expert to help me automate data entry using checkboxes on a mobile device. Specifically, I need assistance with: - Using checkboxes as buttons for data manipulation (add, delete, edit) on a sheet - Implementing the onEdit function to trigger these actions when checkboxes are edited This project requires a deep understanding of Google Sheets scripting and experience with data entry automation. If you're proficient in creating scripts that can streamline this process for me, I'd love to hear from you!
I'm seeking a Quickbooks professional to assist with bookkeeping and report creation. Your responsibilities will include: - Data entry and reconciliation - Managing accounts payable and receivable - Balance Sheet - Profit Loss - Setting up the chart of accounts Ideal candidates should have extensive experience with Quickbooks, a strong background in bookkeeping, and the ability to create insightful reports. Please include your relevant experience in your bid.
I have made some progress on a workout logging app using Expo, but I need some help to get through the first phase of the project. What I've Completed: - A functioning login system. - Basic structure for workout/exercise entry but I'm struggling with the API integration. - Videos for exercises are set up with Azure Blob Storage but I'm having trouble getting them to load. - A registration page that needs basic functionality implemented. What I'm Looking For: - Assistance in troubleshooting the workout entry feature's API integration. - Help getting the exercise videos to load properly from Azure Blob Storage. - Implementation of basic functions for the registration page: user input validation, email verification and password encryption. But also be...
I'm seeking an entry-level virtual assistant located in Illinois. The tasks include: - Email management: Sorting, responding, and prioritizing my emails. - Scheduling appointments: Coordinating my calendar and setting up meetings. - Data entry: Inputting information into various systems. All applicants must have a proficient understanding of Microsoft Office and be comfortable using it for various tasks. Ideal skills and experience for the job: - Basic understanding of office administration. - Good communication skills. - Ability to manage time effectively and meet deadlines. - Willingness to learn and adapt.
I'm in need of a professional to assist me in preparing financial reports, analyzing expense data, and ultimately improving our financial performance. The reports should be in Excel spreadsheets.
...Top 1% of CRO Specialists! Do you excel at turning landing pages into lead-generating machines? Join our high-performing team! Position Overview We seek a results-driven CRO Specialist to optimize landing pages and digital funnels. Use your analytical and creative skills to drive campaign success and collaborate with clients for measurable results. Key Responsibilities Conduct data analysis and A/B testing for CRO strategies Design and implement conversion-focused strategies Collaborate with clients and internal teams for top-tier results Stay updated on the latest CRO trends Qualifications 2+ years in CRO with proven landing page success Strong portfolio showcasing conversion improvements Expertise with CRO tools (Google Optimize, VWO, Optimizely) Data-driven ...
I have a PDF file containing text and numbers that needs to be converted into Excel. Ideal skills and experience for this job include: - Proficiency in Excel - Experience in data extraction from PDFs - Exceptional attention to detail - Ability to work efficiently under pressure.
I'm seeking an entry-level virtual assistant located in Illinois. The tasks include: - Email management: Sorting, responding, and prioritizing my emails. - Scheduling appointments: Coordinating my calendar and setting up meetings. - Data entry: Inputting information into various systems. All applicants must have a proficient understanding of Microsoft Office and be comfortable using it for various tasks. Ideal skills and experience for the job: - Basic understanding of office administration. - Good communication skills. - Ability to manage time effectively and meet deadlines. - Willingness to learn and adapt.
I'm looking for a skilled developer to create a cross-platform Flutter-based attendance app for both Android and iOS. The app should encompass the following primary features: - QR Code Scanning: Users should be able to check in by scanning a QR code. - GPS-Based Check-In: The app should incorporate a GPS feature that allows for location-based attendance. - Manual Entry: In instances where the above methods are not feasible, users should have the option for manual check-in. - Face Embedding: The app should also incorporate a face embedding feature for attendance verification. The app will need to integrate with a third-party API for its backend services. Therefore, experience with API integration is essential. Ideal Skills: - Proficient in Flutter - Extensive knowledge of cr...
Rahul, Hello! A few months ago, you helped me to convert a Google Docs based spreadsheet ito an Excel format. I now need to use it for another client & want to change the values in the drop-down menu for the strengths/development areas. I was able to unhide the settings tab and update the dropdown menu source but now it causes a run error for our "start" setup function. What is the cost to fix this & also set it up so i can easily make these changes for other clients? Mary
I'm seeking an experienced professional to produce 10 exam papers for me, each containing 35 non-verbal reasoning questions. The questions should be of high difficulty and in line with the GATE exam's Abstract Reasoning component for Year 7 entry in Australia. Specific Requirements: - Format: The papers need to be delivered in PDF format, in black and white. - Question Sourcing: A mixture of original questions and those from specified sources. - Answer Key: Each exam paper should include an answer key. Ideal Skills and Experience: - Strong understanding of non-verbal reasoning questions - Experience in creating or sourcing exam content - Ability to maintain consistent difficulty levels across papers. Please refer to the attached document for an example of the forma...
Web scrape Automation: I can scrape multiple pages using Selenium and Python, extract all the data, and seamlessly convert it into an Excel file.
I'm seeking an Excel expert to assist with semi-monthly payroll calculations. Tasks will mainly involve tracking hours, vacation pay and holiday pay. The project has the following components: - Gross pay calculation: Accurately determining pre-tax earnings based on hours worked and other factors. - Tax deductions: Applying the correct tax rates and ensuring compliance with relevant regulations. - Net pay summary: Summarizing post-deduction amounts in a clear, concise manner. Skills and experience in data analysis and financial modelling are a plus, as is familiarity with macros and automation. The ideal candidate will be detail-oriented, reliable, and able to validate data to minimize errors.
I'm in need of a customizable Excel template specifically designed for project management. This template should allow a user to input a project name and its go-live date, and in response, automatically populate all related deadlines, legal references, and resources. Please note, I will populate the actual document with the data, but require a fully functional template with adjustable formulas. Key Requirements: - The template must include deadline formulas that populate fields based on the proximity of the go-live date, taking into account: - The year (i.e., the year prior, odd years, etc.) - The number of days (i.e., 45 days prior to go-live, 60 days prior to go-live, etc.) - The month and/or day of the week (i.e., first Friday in August prior to go-live, second ...
Project Description 1. Read data from Nse Bhav copy excel file 2. Do calculation as an output I need 9-10 columns after calculation 3. I need a code/ Software which I can use in my laptop 4. This code will ready the input file which I will put in a folder 5. Also calculate OI change activity if it getting in creased or decrease. 6. Oi change calculation input data will be in the same file 7. Calculate OI Interpretation
I am looking for a proficient Excel expert to design an Audit Tracker for me. This tracker will manage and monitor up to 50 separate audits. The tool should be capable of tracking both corrective and preventative actions as statistics. It should also present a live stats dashboard that displays the progress of all audits, current outstanding audits, and their respective progress. Key requirements: - The tracker should be able to identify and reflect audit trends for the year as audits are added. - The dashboard should include visuals primarily in the form of bar charts. - Additional information to be displayed on the dashboard includes: audit completion rate, monthly audit trends, and audit compliance scores. Ideal skills for this project: - Advanced Excel skills, including...
The indicator includes TP levels, dynamic Buy Orders, entry shifts, and SL, coded in Pine Script for TradingView.
...all tender information from both platforms in Namibia on a daily basis. The scraped data should be neatly organized in an Excel spreadsheet. Key Requirements: - The scraper should pull data from all relevant sources, including government websites and social media. - Information to be collected includes: the name of the entity or organization, tender advertising date, due date, a clickable link for document download, and contact details. - One of the primary websites to scrape from is: , which mainly hosts government tenders. - The scraper must ensure no tender is overlooked. Ideal Skills and Experience: - Expertise in web scraping and data collection. - Familiarity with Excel and data organization. - Experience in developing scrapers that gat...
I need an Excel expert to create monthly reports for my crockery and cutlery inventory. Sales Report: - Should include total revenue. Inventory Report: - Should include sold items and quantities. Sold Items Breakdown: - By category (e.g., crockery, cutlery). The ideal freelancer for this project would have extensive experience in Excel and data analysis, with the ability to create clear, concise reports. Familiarity with inventory management and sales reporting would be a plus.
...login and dashboard functionality. ### Key Responsibilities: 1. Dashboard for Union Members: - Implement features for managing "Exclusive for Union" accommodations (viewing, adding, or excluding units) using the existing dashboard UI. - Develop back-end APIs to list and toggle accommodations as "Exclusive for Union." 2. Discount Management: - Create functionality to configure automatic discounts for union members (global or category-specific). - Ensure real-time price calculations based on configured discounts are accurately displayed. 3. Vacation Fund Management: - Use the existing dashboard UI to display union members’ vacation fund balances and expiration notifications. - Create APIs to fetch fund balances and gen...
I'm looking for a freelancer who can assist with data entry. Key Responsibilities: - Entering text data from text files into databases. - Handling numerical data sourced from databases. Ideal Skills and Experience: - Proficiency in data entry tasks. - Experience working with databases. - Good command of handling and processing text documents.
...elements in data visualization and effective communication. Here are some tips for creating good graphics and designs: Chart 1. Choose the right graph type (bar, line, circle, etc.). 2. Use contrasting and harmonious colors. 3. Give clear labels and titles. 4. Ensure the scale and axis are accurate. 5. Avoid data overload. 6. Use animation wisely. Design 1. Choose a font that is clear and consistent. 2. Use colors that match the theme. 3. Arrange the composition and free space. 4. Create a simple and intuitive design. 5. Ensure alignment of visual elements. 6. Use relevant images and icons. Graphic Creation and Design Tools 1. Adobe Illustrator 2. Canva 3. Tableau 4. Power BI 5. Google Data Studio 6. Microsoft Excel Additional Tips 1. Know your audience a...
...detect specific objects. Implement a data transmission system configurable based on the installation environment (Wi-Fi, LoRaWAN, or 4G/LTE). Optimize energy management to ensure continuous operation, even with limited sunlight. Device Operations Flow: Idle State: Only PIR sensors remain active to detect motion. All other system components (cameras, Coral, communication modules) remain off or in low-power mode. Motion Detection: A PIR sensor detects motion and sends a signal to the management microcontroller. The microcontroller activates the corresponding camera and wakes up the Coral Dev Board Micro. Image Capture and Processing: The camera captures an image or sequence of images and sends it to the microcontroller. The microcontroller transmits the data to the Coral ...
I'm in need of an Building Designer to help create my home project. step 1 = insert new survey step 2 = shower sewer and junction using old survey Step 3 = create floor plans using DH Markup as a guide Step 4 = Propose Levels for each floor based off existing survey Step 5 = introduce stairs with correct levels from basement to rear GF and entry example project have been provided
