Excel automatic data entry formula jobs
...Analysis in AmiBroker I'm seeking an experienced AFL (AmiBroker Formula Language) programmer to develop custom code for generating explorations and charts that describe seasonal patterns in stock prices. I already have and can provide starting AFL code that generates charts and exploration for average all years and by presidential year. My timeline is flexible, and I’m open to changing the request if some features are overly complex or will require significant work/cost. Exploration Outputs The AFL code should generate the following exploration outputs: 1. Return (close/close % price change) 2. Return/Standard Deviation (using SD over last X days, set as parameter) These outputs should be calculated as average for all years of data available: • Date ran...
I need a skilled Excel VBA programmer to enhance my current Excel workbook with new macros. The primary aim of these macros is to automate data entry tasks, specifically dealing with text data. Your responsibilities will include: - Modifying existing macros or creating new ones to facilitate the automation of data entry - Ensuring the macros can handle various forms of text data effectively Ideal candidates should have: - Proficient experience in Excel and VBA programming - Previous experience in creating or modifying macros for data entry purposes - Excellent understanding of handling text data within Excel Please provide examples of similar projects you've worked on, and your approach to ...
I'm seeking a professional with REAL PowerPoint and advanced Excel skills to transfer and format content from Excel into PowerPoint slides. This task should take 2-3 hours to complete. Please note: - No need for content creation in either Excel or PPT. - Professional and timely work is a must. I'm looking for someone with experience who can guarantee quality work within the specified time frame.
...prioritize issues, along with the ability to upload an Excel file for issue storage, involves the following steps. Here’s a detailed guide: Features to Implement: 1. User Authentication (optional for personalized data). 2. Issue Management: • Create issues manually. • Track existing issues. • Assign issues to users. • Prioritize issues with drag-and-drop or priority labels (e.g., High, Medium, Low). 3. Excel File Upload: • Parse uploaded Excel sheets to populate the issue list. • Store the data in the app’s state or backend. 4. Data Storage: • Use a local state or integrate with a backend (e.g., Firebase, MongoDB, PostgreSQL). 5. Responsive UI: • A dynamic table or kanban board to...
...for a skilled WordPress developer to update and enhance our website () with the following: - Fleet Updates: Add new boats, update pictures, and refresh descriptions for the rental section. - New Boat Sales Section: Create a dedicated section for boat sales, featuring Salpa, Jeanneau, and Mercury models. - Automated Offer Integration: Implement functionality for automatic offer creation and integration with Subito.it. - User-Friendly Design: Ensure seamless navigation and an intuitive interface for the new sales section. - Responsive Updates: Ensure all changes are mobile-friendly and optimized for performance. Requirements: - Proven experience with WordPress development and customization. - Knowledge of API integration (for automation).
...project is to create a comprehensive Sales Data Visualization Dashboard using Power BI. The dashboard will provide insights into sales performance, trends, and patterns, helping stakeholders make data-driven decisions. Key Features: Sales Overview: Display total sales, revenue, and profit by month, quarter, and year. Product Performance: Visualize sales data by product category, highlighting top-performing and underperforming products. Regional Analysis: Analyze sales performance across different regions and countries. Customer Segmentation: Segment customers based on demographics, purchase history, and behavior. Sales Forecasting: Predict future sales trends using historical data and forecasting models. Interactive Filters: Allow users to filter da...
...with data entry. The task involves transferring mixed data from a TXT file to an Excel spreadsheet while cross-referencing information with a PDF source. Key Responsibilities: - Accurately transcribe mixed data from a TXT file into Excel. - Compare and validate data against a provided PDF source. - Implement basic error checking and data validation. Requirements: - Proficiency in Excel with experience in standard formatting. - Strong attention to detail for data comparison and validation. - Ability to work with mixed data types (numerical and text). The project involves processing 1000 data entries. The project must be completed within one week. High precision is required for data validation. ...
Bid $10 to be considered. 1. Open google maps - Egypt both Hurghada and Sharm El Sheikh (@27.4557067,33.4661847,9z/data=!4m10!2m9!5m7!3e4!4e9!5m4!1s2024-12-23!2i4!4m1!1i2!6e3?entry=ttu&g_ep=EgoyMDI0MTIxMS4wIKXMDSoASAFQAw%3D%3D) 2. Click Hotels 3. Filter for 5 star + >4.8 rating 4. Use dates 23-27 December 4. Complete this spreadsheet with all of the hotels Hotel name, Hotel website, Hotel email, Hotel ph0ne number, Hotel whatsp or vib$er:
...who can help me clean up my Excel file by removing disconnected phone numbers. Specifics: - I will be using Twilio as the phone validation service. - It is crucial that the disconnected numbers are completely deleted from the file, not just moved or highlighted. Ideal candidates should have: - Experience with Excel and data management. - Familiarity with Twilio or similar phone validation services. - A keen eye for detail to ensure no disconnected numbers remain in the file. - Strong communication skills to provide updates and clarify requirements. - A problem-solving attitude to identify alternative methods if issues arise. - Excellent time management to meet deadlines promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of ...
I need assistance with manual data entry from paper documents into an online database. Key Responsibilities: - Accurately inputting data from paper documents into an online database - Ensuring data integrity and consistency throughout the process The ideal freelancer for this project should have: - Proficiency in online database systems - Excellent attention to detail to ensure accurate data entry - Previous experience with manual data entry from paper documents
I'm looking for a skilled professional who can integrate AI automation into my current processes with a specific focus on process automation. Key Requirements: - Expe...AI automation into my current processes with a specific focus on process automation. Key Requirements: - Expert in AI automation tools - Highly proficient with SpyFu and Zapier - Excellent skills in process identification for automation Specific Tasks: - Automate various processes (primarily report generation and data entry) - Streamline lead management through automation The primary goal is to enhance efficiency through process automation and to gain insights from my data using SpyFu. If you have a proven track record in process automation and can seamlessly integrate with the mentioned tool...
...systems. The app will handle multiple serial ports, TCP connections, manage local/remote PostgreSQL/SQL databases, and export device data to Excel. Project Scope: Phase 1: Develop core functionality for serial port communication and TCP/IP connections. Phase 2: Integrate and manage local/remote PostgreSQL/SQL databases. Phase 3: Implement device list export to Excel. Phase 4: Cross-platform compatibility (Windows & Debian-based systems). Requirements: 3-5 years of experience in desktop application development. Proficient in C++, C#, or Qt. Experience with serial communication and TCP/IP protocols. Strong database knowledge (PostgreSQL/SQL). Excel export functionality (OpenXML, Apache POI). Cross-compilation experience for Debian-based systems...
I'm seeking a skilled data analyst to assist with creating a comprehensive dataset for my electrical parts' billing process. Key Tasks: - Construct a dataset that includes cost price, markup %, and selling price for each electrical part. - The dataset should reference a separate, filled-out data chart for pricing. - The dataset needs to assist with individual billing, including profit calculations. Ideal Skills: - Proficiency in data analysis and management. - Experience with pricing and billing datasets. - Familiarity with electrical parts is a plus. The goal of this project is to streamline my parts billing process through the use of an automated, easy-to-update dataset in Excel.
...Sunday) 2. If possible, check the provision to control Artificial Voice Over's Voice and speed, if need to modify. 2. Automation should be programmed for "Video Title, Thumbnail and Video Description", separate data will be provided if required in a separate file(s). 3. Very important : will create and Upload the Video in Multiple Indian regional languages also unique YouTube channel will be there, like Telugu, Tamil, Marathi, Gujarati ,Bengali, Odiya, Kannada, Malayalam etc. also in Hindi& English. 5. Include a backup schedule plan for all video files and project data to avoid data loss. 6. Implement different voice variations for male and female voices for the artificial voice over. 7. Support multiple video resolution outputs such as 720p, 1080...
I need a Power BI dashboard linked to an Excel file to visualize our stock on hand (SOH) data. Requirements: - The dashboard should provide an SOH report. - It should include current stock levels, stock valuation, and stock movement history. Ideal Skills: - Proficiency in Power BI and Excel. - Experience in creating comprehensive, interactive dashboards. - Understanding of stock data analysis. Your bid should reflect your expertise in these areas and include relevant examples from your portfolio.
I'm in need of a LinkedIn account holder to assist with job postings. This role involves making 10 free job posts per month and responding to all applicants. Each post takes about 10 minutes, totaling approximately 1.5 hours monthly. The posting schedule is every 3 da...closing the job and initiating a new one thereafter. The content for the postings is standardised and simply requires copying. Key Responsibilities: - Make 10 free job posts per month on LinkedIn - Respond to all applicants - Follow the posting schedule of every 3 days This job is manageable and many people currently do it for me, so you'll be integrating into a team. Performance is key; if you excel at this task, there is potential for continued work over several months. To apply, please include '...
I'm seeking a freelancer proficient in data analysis and visualization, particularly using Excel. The primary focus of this project will be analyzing and visualizing sales data. Key Responsibilities: - Conduct in-depth analysis of sales data - Utilize Excel for data visualization - Provide insightful interpretations of the data Ideal Skills & Experience: - Strong analytical skills - Proficient in using Excel for data visualization - Experience in analyzing financial data data - Good understanding of data analysis and visualization principles If you also have content creation skills, especially in writing blogs or content writing, that would be a bonus. However, the primary focus is on data...
I'm seeking a tech writer with expertise in web app development to create a comprehensive technical document for a custom web app. This web app is primarily a data entry platform with user login capabilities, and it will also handle attachments. Key Components of the Document: - An in-depth description of the app's purpose and functionalities - Detailed specifications for user account management features: user registration and login, password recovery, and user profile management. - A technical outline for the data entry components and attachment handling features. Ideal Skills: - Proficient understanding of web app development terminology - Experience in technical writing specifically for web applications - Ability to translate complex technical inf...
I need a skilled typist for a project involving typing printed text from books. Ideal skills and experience include: - Proficient typing speed and accuracy - Prior experience with data entry - Attention to detail - Ability to adhere to deadlines.
I require assistance with data entry. The data is primarily customer information currently stored in paper documents. The task also involves creating reports, specifically activity logs. Ideal Skills and Experience: - Proficient in data entry - Experienced in creating reports - Attention to detail - Ability to work with paper documents - Good understanding of customer information handling - Experience with database management systems
...Optimization in Architectural Visualization Projects Project Brief: We are seeking a skilled Unreal Engine developer to create a custom plugin that optimizes mesh actors within Unreal Engine 5 project files specifically for PCVR and Standalone VR (Quest) platforms. The plugin will be tailored for Architectural Visualization Projects, enabling automatic analysis and optimization of 3D models (mesh actors) for enhanced VR performance. The focus is on streamlining mesh data, while retaining visual fidelity, for seamless VR experiences. Key Features & Requirements Mesh Analysis Scan and analyze all mesh actors in the Unreal Engine level. Generate detailed reports for each mesh, including: Polycount and LODs. UV layouts and lightmaps. Performance metrics (memory footpri...
I need a skilled typist for a project involving typing printed text from books. Ideal skills and experience include: - Proficient typing speed and accuracy - Prior experience with data entry - Attention to detail - Ability to adhere to deadlines.
I need a skilled typist for a project involving typing printed text from books. Ideal skills and experience include: - Proficient typing speed and accuracy - Prior experience with data entry - Attention to detail - Ability to adhere to deadlines.
Entering customer and account data from source documents within time limits. Compiling, verifying the accuracy, and sorting information to prepare source data for computer entry. Reviewing data for deficiencies or errors, correcting any incompatibilities, and checking output.
I'm in need of a meticulous Data Entry Specialist who can manually input text data from printed documents. The job requires strong attention to detail and the capacity to handle large volumes of data. Ideal Skills and Experience: - Proven experience in manual data entry - Exceptional attention to detail - Ability to work with printed documents - Proficiency in typing and using data entry software - Experience with text data handling
Description: I need VBA and Excel automation expertise to integrate a new productivity KPI into an existing report. The POS vs. Opportunity report already contains automated VBA scripts and formulas, so this task requires enhancing the functionality without disrupting the existing structure. Project Overview: Integrate a Productivity KPI: Track registrations completed per team member and calculate registrations per hour. Data Source: Supervisors maintain a separate daily registrations report (Excel). Goal: Combine this KPI seamlessly into the current POS vs. Opportunity sheet. Requirements: Add columns for Registrations Completed, Hours Worked, and the calculated Productivity (Reg/hr). Maintain the current VBA automation and ensure no integrity ...
I'm looking for a comprehensive education platform that focuses primarily o...assignment submission and feedback. This should allow teachers to easily create, distribute, and assess assignments, and provide personalized feedback to students. - Automatic grading features. This should cover a range of assignment types, from quizzes to essays. The grading system should be fair, consistent, and able to handle a high volume of submissions without compromising on speed or accuracy. Ideal candidates for this project should have experience in developing educational software, particularly platforms that support live interaction between students and teachers. They should also have a strong understanding of automatic grading systems, and be able to create a system that is both ef...
I'm seeking a seasoned Pine Script developer with a solid grasp of trading concepts, specifically to create a Dollar-Cost Averaging (DCA) based Forex market indicator. This indicator will have specific entry and exit signals. Key Requirements: - Extensive experience in Pine Script and trading. - Ability to understand and implement detailed indicator specifications. - Familiarity with the Forex market. - Good communication skills for discussing Pine Script logic. The detailed document outlining the indicator's logic, conditions, inputs, and outputs is ready for review. Please confirm your ability to deliver the project, include your price quote and estimated delivery time in your response.
I'm seeking a meticulous data entry specialist to help me input product details sourced from the internet into an Excel spreadsheet. Key Responsibilities: - Researching and sourcing product details from online platforms - Accurately inputting the data into an Excel spreadsheet Ideal Skills: - Proficiency in Excel - Strong attention to detail - Experience in data entry and online research - Ability to meet deadlines The project will involve entering details for between 100 and 500 products. The freelancer can use a customized format for organizing the product details in the Excel spreadsheet. The data entry will include collecting and entering the product name and price. Please include the product descri...
...from an Excel spreadsheet. The initial task involves 2000 entries, but if the results are satisfactory, there is a larger batch of over 50,000 entries waiting. Key Responsibilities: - Use various methods (visiting websites, Google Maps, social media, etc.) to find the emails - Transfer data from 'contact us' pages with a contact form into a separate spreadsheet - Remove entries with contact forms instead of emails from the email spreadsheet Compensation: - Pay will be based on a per-email-found basis - Separate payment for entries that end up in the contact form spreadsheet Criteria for Acceptable Emails: - No generic or default or invalid emails - Personal emails are preferred, but company emails are acceptable. Ideal Skills and Experience: - Proficient in...
...specific data from the UAC Member Directory () and organise it into a structured Google Sheet for comparison purposes. The scraping must capture all the required data fields and ensure accuracy, completeness, and consistency. Scope of Work: Scrape Data from Each Business Profile: From the UAC Member Directory, extract the following information: Name of business Website ABN AFSL Number or NZ IRD Number Phone Email Address Description Contact Contact Name Contact Email Specialisations Logo (if possible) Organise Data in a Google Sheet: Each business should have its own row. Use column headers corresponding to the data fields above. Ensure the data is correctly aligned with the appropriate column. Data Quality: Verify the data accurac...
...Microsoft Office, and have the ability to maintain confidentiality. Key Responsibilities: - Manage calendars, schedule appointments, and coordinate travel arrangements - Handle email and phone correspondence, responding to routine inquiries - Perform data entry, maintain records, and ensure accurate filing systems - Prepare and edit documents, reports, and presentations as needed - Provide exceptional customer service and support to our team Requirements and Skills: - 2+ years of administrative experience - Proficient in Microsoft Office (Word, Excel, PowerPoint, Outlook) - Excellent communication, organizational, and time management skills - Ability to maintain confidentiality and handle sensitive information - High-speed internet connection and reliable comput...
I'm looking for someone for a week of non-stop data entry in my Brooklyn office. The data is mixed, so you'll be entering both text and numerical data. Key Details: - The data is mixed: You'll be dealing with both text and numerical data. - Software: You'll be using custom software for this task, so experience with a range of software is a plus. - Accuracy is key: There are no specific formatting guidelines, but the utmost accuracy is essential. Ideal Skills: - Data entry: Prior experience in data entry is preferred. - Attention to detail: As accuracy is crucial, a keen eye for detail is necessary. - Software proficiency: Familiarity with various software can be beneficial. - Location: ...
I'm looking for an experienced professional with Etsy who can help me list 7300 Hollywood photos from an Excel spreadsheet onto my Etsy account. Key tasks would involve: - Accurate data entry from Excel to Etsy - Ensuring each item is listed correctly All product descriptions are ready, and photos are prepared for upload without needing editing. Ideal skills and experience: - Proven track record in e-commerce, specifically Etsy - Exceptional attention to detail - Proficient in Excel - Able to work efficiently with large volumes of data.
I'm in need of a proficient English-speaking virtual assistant with experience in Excel spreadsheets. The assistant will primarily be responsible for data entry tasks related to product inventory, invoces, and customer templated outreach. Key Responsibilities: - Extracting Text from Photos. - Managing product inventory through Excel spreadsheets - Creating product descriptions and attributes, along with photos and prices. - Performing data entry tasks on a regular basis Ideal Skills & Experience: - Proficiency in English - Strong experience with Excel spreadsheets - Previous experience with ZOHO CRM is preferred - Good understanding of data entry tasks and product inventory management. Availability: - Must be availa...
I need an Excel spreadsheet that outlines a loan amortization schedule over a 5-year period with differing interest rates. Requirements: - The schedule must account for both fixed and variable interest rates. - The spreadsheet should not contain any visual aids - just the data itself. - Include a column that shows the remaining loan balance after each payment. - The schedule should clearly show the breakdown of principal vs. interest in each payment. Ideal Skills: - Proficiency in Excel, particularly with complex formulas and functions. - Strong understanding of loan amortization and interest rate variations. - Experience in creating clear and organized spreadsheets. Include options for extra payments in the loan amortization schedule.
I'm in urgent need of a dedicated professional for a full-time position focused on photo editing and data entry, particularly color correction. Key Responsibilities: - Photo Editing: Primarily focusing on color correction. - Data Entry: Assisting in managing and inputting data accurately. Ideal Skills: - Proficient in photo editing software, particularly in color correction. - Excellent data entry skills with attention to detail. This is a great opportunity for anyone with a passion for photo editing and data handling. Your role will be crucial in maintaining the quality and accuracy of our data and images.
I need an expert in UiPath and SAP ERP for seamless integration. The primary focus is on ERP systems, specifically SAP. Main task: 1. export data from few tables based on selection screen from excel, data from 2 SAP systems 2. create table in excel Ideal Skills: - Proficiency in UiPath - Extensive experience with SAP ERP - Understanding of ERP system functionalities - Strong problem-solving skills - Excellent communication and collaboration capabilities I am looking for a professional who can ensure efficient and effective integration of UiPath with our SAP ERP system. Please provide relevant examples of your previous work in your proposal.
I am in need of an Excel form that will track data and facilitate scheduling. This will primarily be used by our administrative staff, so ease of use and clarity are paramount. Key Requirements: - The form will need to provide a user-friendly interface for entering data. This should be intuitive and easy for administrative staff to use without any advanced knowledge of Excel. - The form should also be capable of performing calculations based on the data input. These calculations are central to the purpose of the sheet, so they must be accurate and reliable. - Data should be stored across multiple tabs for organizational purposes. This will help ensure that the data remains clear and easy to access as the form is used over time. Ideal Skill...
... Margin Percentage: the profit margin between internal cost and displayed cost. Project Notes: a space for adding any observations or specific details. Image Upload: the ability to upload and associate images with the project. Crucial Part of the Upload Process: The image upload is one of the most important features. To correctly upload images, a Shooting List must first be uploaded in CSV or Excel format, containing the following information for each product: Product Barcode Product Code Product Category Product Gender Product Color Delivery Date (if applicable) Return Date (if applicable) These details will also serve as filters for quick search at the top of the page, allowing for organized project management. Each product will have a folder where images can be uploaded. Th...
I'm in need of a robust inventory system designed in Google Sheets. This system should encompass numerous functions to manage and monitor our inventory efficiently. Key Functionalities: - **Stock Tracking**: Keep a precise record of our inventory levels. - **Sales and Orders Management**: Track incoming and outgoing stock. - **Automatic Restocking Alerts**: Notify us when stock levels reach a predefined threshold. - **Financial Tracking**: Monitor the financial aspect of our inventory. - **Employee and Job Tracking**: Manage inventory related to different employees and jobs. - **Tally Material Used**: Keep track of material consumption. - **Job Site Equipment Monitoring**: Oversee equipment distributed across various job sites. - **Forms for Technicians**: Create forms for tec...
Description: I need a freelancer to create a custom Excel template for tracking distributors of IV pump brands across multiple regions and countries. This project is for template design only—no research or data collection is required. Template Requirements: 1. Columns: • Country: Pre-filled and organized by region (see target regions and countries below). • Distributor Name: Name of the distributor (or indicate “Direct Sales” if the brand sells directly in that country). • Website: Distributor’s website. • Key Contact(s): Name, email, phone (if known). • Notes/Details: Space to input Market presence, market share, and relevant details. • Active in Market: Checkbox or dropdown to indicate whether the brand is activ...
...interface using HTML, CSS, and JavaScript for file uploads and process initiation. Use frameworks like Bootstrap for responsive design. 2. Backend Functionality Use Flask as the backend framework. Define the following endpoints: File Upload: For users to upload Excel files. Template Management: To manage and list Word or PDF templates. Contract Generation: To fill templates with Excel data and create output files. Log Viewing: To display logs and errors to users. 3. Process Flow Excel Data Processing: Read the uploaded Excel files and save the data into a database (e.g., SQLite). Template Filling: Use docxtpl for Word templates and fillpdfs for PDF forms within Flask routes to generate the necessary documents. Parallel Processing: Utilize...
I am in need of an experienced C# developer to create ...developer to create a desktop-based business application for customer relationship management (CRM). Key Features: - Customer Relationship Management: The application should primarily serve CRM purposes. - Data Management: This includes the creation of data entry forms, as well as implementing robust reporting and analytics capabilities. - Data Import/Export: The application should also support data import/export functionalities. Ideal Skills: - Proficiency in C# and desktop application development. - Experience in designing and developing CRM applications. - Strong understanding of data management systems and analytics tools. I am looking for a developer who can deliver a comprehensive, ...
Arabic Speakers Only... The tasks involve: Data Cleaning: - Reviewing and refining the current product list for accuracy and consistency. - Removing any duplicate or incorrect data. Product Classification: - Using a file containing main and sub-categories that I will provide. - Classifying each product in the list and linking it to the appropriate main and sub-categories. Work Requirements: - Previous experience with product lists and classification. - Proficient in Excel or similar programs. - High level of accuracy and attention to detail. - Ability to work quickly and efficiently. Question 1: The product list consists of more than 2000 items. Question 2: I have specific names for the main and sub-categories. Question 3: The preferred format for organizing the pr...
I have an existing Excel spreadsheet that needs a makeover. The main focus is on improving the layout and readability to make it aesthetically pleasing for presentations. Key Requirements: - Enhancements should align with a professional and clean style, devoid of unnecessary clutter or distractions. - Use of custom fonts and consistent formatting to elevate the visual quality of the spreadsheet. - Organizing sections with clear headings to guide the viewer through the data smoothly. Ideal skills for this project include: - Proficient in Excel with a keen eye for design. - Experience in creating professional-grade spreadsheets. - Ability to apply custom fonts and maintain consistent formatting throughout. Feel free to select professional color schemes at your discre...
... and a proven track record in virtual assistance or similar roles. This is a long-term opportunity for someone looking to contribute meaningfully to a growing business. Responsibilities: Administrative Support: Manage email correspondence, organize inboxes, and respond to inquiries in a timely manner. Schedule appointments, coordinate meetings, and maintain an organized calendar. Handle data entry and maintain accurate records. Customer Support: Respond to customer queries professionally through email, chat, or other communication channels. Address issues, resolve complaints, and escalate matters when necessary. Task Management and Coordination: Assist in project tracking and ensuring deadlines are met. Liaise with team members to facilitate smooth workflow an...
Please convert this provided document for PDF to editable Excel keeping source content, formatting, and visuals.
Sales Data Analysis Project Objective: Provide insights into sales performance by analyzing historical data to uncover trends, opportunities, and areas for improvement. Key Tasks: Data Collection: Gather and clean historical sales data, including sales volume, revenue, product details, customer demographics, and geographic information. Data Transformation: Process and transform raw data into a structured format using tools like Python, Excel, or Power BI to facilitate easy analysis. Trend Analysis: Identify patterns and trends in sales, such as peak seasons, customer preferences, and sales by region or product category. Customer Segmentation: Segment customers based on demographics, purchasing behavior, and sales history to provide tailore...
