Excel automatic data entry formula jobs
I have a list of RERA numbers that I need data scraped from the MahaRERA website. Requirements: - Data should be scraped and organized as per the headers in the provided Excel file. - The final output should be delivered in an Excel file. Please note, this is a one-time project.
I need assistance with data entry and restructuring of files in the gravity folder. There are 35 files that require modification to match a consistent structure - using the 'birba file structure' as a reference. Requirements: - Standardize all files to have the same header, even if there is no data. - Add a 'File Name Column' to each file using the existing file name without the extension. - Ignore any extra columns in the original files. Final Deliverables: Both .xlsx and .csv versions of the restructured files. Ideal Skills and Experience: - Proficient in Excel with data entry experience. - Previous work with file restructuring is preferred. - Attention to detail and ability to follow instructions precisely.
...brand's uniqueness, such as highlighting the craftsmanship, ethical sourcing, or luxury appeal of the diamond rings. 2. Leveraging Relationship Skills: Building connections with the target audience through personalized engagement, empathy, and authentic communication. 3. MBTI-Driven Role Fit: best suit individuals with creative, empathetic, and audience-driven MBTI types (e.g., ENFJ or ENFP), who excel at connecting with and inspiring others. For success, the social media marketer should: • Understand the target demographic (e.g., couples, gift buyers). • Be skilled in visual storytelling, as platforms like Instagram and Pinterest are key for such businesses. • Build community through interactive content and consistent engagement. • Use analytics to refin...
I'm in need of assistance with data entry from various online articles. The data to be entered is exclusively text-based. I will provide a list of URLs, from which the data will need to be extracted and entered. Ideal Skills: - Proficient in data entry - Attention to detail - Familiar with online research Experience: - Previous experience in data entry from online sources preferred - Comfortable working with a large volume of data.
I have an Excel workbook with approximately 40-50 individual worksheets, each containing a dashboard. These dashboards pull data from a main worksheet. I'm looking for a professional to convert these dashboards into a web portal for my clients to view. Key Requirements: - Creation of a main HTML page with hyperlinks to each dashboard page and a return link to the main page. - Conversion of the dashboard sections to HTML for online display. - Implementation of a script to periodically update the data in the dashboards. I can provide a virtual private server and a custom URL for the portal. While the project is based on Excel, I'm open to using an alternative such as Google Sheets if it's easier. I'll supply you with the Excel file, a...
Job Title Virtual Assistant f...• Certifications (GOTS, OEKO-TEX, BSCI). • Communicate professionally via email or calls to request quotes and additional information. • Organize findings into a clear Google Sheet or Excel document for comparison. • Follow up with manufacturers to clarify details or request updates. • Assist in ordering samples and tracking their shipment. Skills and Qualifications • Strong research and data-gathering skills. • Excellent written and spoken English communication skills. • Experience in supplier sourcing or similar research-based tasks. • Ability to organize information clearly in Google Sheets/Excel. • Familiarity with sustainability certifications like GOTS, OEKO-TEX, and BSCI...
content writing base on my life’s journey which I have concocted successful models
I'm looking for someone to design a spreadsheet that can help me track daily attendance, automatically calculate absenteeism, turnover rate, retention rate etc
I'm a software developer seeking to validate a potential Shopify app. I need someone with extensive experience across various Shopify stores to conduct preliminary market research. Key Tasks: - Identify and analyze current market trends within the Shopif...trends within the Shopify ecosystem, particularly around how users import product information. - Provide insights into the frequency and patterns of these trends. Ideal Candidate: - Extensive experience with Shopify and its various stores. - Strong analytical skills for competitive and market trend analysis. - Ability to provide actionable insights from data. Please note: The specific method of product information import (manual entry, CSV file upload, API integration) has not been determined and will be assessed b...
I need a professional who can assist me with some amendments in my Vue Js Laravel project. The task involves modifying the commission formula to include conditional logic based on sales volume. Key requirements: - Update the commission formula to apply different rates for different sales volume tiers. - Create a table to effectively display these commission rates. Ideal skills and experience: - Proficient in Vue Js and Laravel. - Prior experience with designing and implementing commission structures. - Strong data visualization skills for creating effective tables.
I'm seeking a data analysis expert proficient in Excel to help interpret my mixed data set. The analysis will be primarily descriptive in nature. Key Requirements: - Proficiency in Excel is a must - Experience with descriptive analysis - Ability to work with mixed data (both numerical and categorical) Skills and Experience: - Prior experience in data analysis - Knowledge of statistical concepts and methodologies - Strong attention to detail and ability to communicate findings clearly
...etc. Key Tasks: - The SPIDER should scan the web, proprietary databases, and social media platforms for new images and text that match the saved data. - It should compile these findings into an Excel file and send them to the associated patient email. - For Phase I, run all images through Google Image and report results by newly discovered data. Ideal Candidate: - Proficient in using Google Image Search for image recognition, with experience developing SPIDER programs. - Able to refine image recognition technology over time. - Familiar with creating specifications for software development. - Capable of batch processing and analyzing large data sets. - Excellent communication skills for reporting and sending compiled findings. Future Opportunities: There ...
...all items meet our specified requirements. You will need to collect relevant product data, including but not limited to, pricing, supplier information, and key product attributes, and present this data in an organized and easy-to-use format for our team. Responsibilities: • Research and identify high-quality pet food and pet supplies from suppliers, manufacturers, and distributors. • Source top-rated products that meet specific criteria such as quality, demand, and customer satisfaction. • Collect comprehensive product details such as Product ID, SKU, UPC, MPN, Brand, Model Number, Price, Shipping Information, Supplier Information (name, contact details, website, etc.), and other relevant data. • Gather and input information related t...
I'm looking for a diligent data entry assistant for ongoing work. Your main tasks will involve handling Excel spreadsheets and emailing. Key Responsibilities: - Working primarily with Excel spreadsheets - Sending emails Requirements: - Ability to follow a specific template for data entry - Proficiency in handling Excel spreadsheets - Good communication skills for emailing tasks Please note, the work is simple and straightforward, but requires attention to detail.
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 a dedicated V...Calendar. Key Responsibilities: - Remote tasks: Downloading files and transferring to the server - Personal tasks: Ordering food through apps and reminding me of appointments ordering things, searchging for things, messaging people for me for status updates. - Business tasks: Assisting with interviews and organizing my Google Calendar Skills and Experience: - Proficiency in Microsoft Excel and Google Calendar - Familiarity with Zoom or similar video conferencing tools - Excellent English communication skills - Ability to follow directions This role requires the VA to be available from 10am to 6pm EST. The VA will frequently communicate with external parties on my behalf. Therefore, strong interpersonal skills and professionali...
I'm seeking a developer with expertise in creating Excel add-ins for both Microsoft Excel Desktop and Excel Online. The add-in needs to incorporate: - Data analysis tools: This will help in processing and interpreting complex datasets. - Custom formulas: I need unique formulas tailored to my specific data needs. - Data visualization: The ability to transform data into visual insights is crucial. Moreover, the add-in must be able to integrate with external databases. Therefore, experience in working with APIs and databases is essential. A strong background in data science and software development is highly desirable. Please provide examples of similar projects you've completed.
...amount paid and the date of payment. The school is divided into classes and departments, e.g. First grade has classes I-1, I-2, I-3... Class II has classes II-1, II-2, II-3... … Department names and class numbers are defined by the administrator User levels: The application should have 4 types of users: 1. Administrator - opens the year, forms classes, assigns a class leader, loads students from an excel file, and every day loads a pdf file containing the student's payments, which the system should recognize and assign to the student 2. The director - has insight into the payment of all students in the school and can see the total sum by departments, classes and at the level of the whole school 3. Class head - has insight into the payments of students of his class on...
...extensive WordPress experience to enhance my current website. The main goals are to boost sales conversions and improve user engagement. Key Tasks: - Rework and enhance the existing WordPress website. - Implement traffic tracking and analyze specific user behaviors such as page views, sign-up completions, and button clicks. - Improve user conversion rates and sign-ups. - Develop a feature for automatic blogging. - Set up auto email newsletters to registered users, including current promotions. - Provide suggestions and implement ideas to further improve the site. Ideal Skills: - Proficiency in WordPress. - Experience in e-commerce site enhancement. - Knowledge in user behavior tracking and analytics. - Skills in email marketing setup and management. - Familiarity with blogging...
I need an Excel file that should be able to process tables of times, ISO, and diaphragm. Key functionalities: - Automatic adjustment of exposure: The file should be able to adjust the exposure of the photos automatically based on the provided data. This project requires: - Proficiency in Excel: The freelancer should have advanced Excel skills to create a complex, yet user-friendly spreadsheet. - Understanding of photography: A basic knowledge of photography principles will help in understanding how to set up the correction tables. - Experience with data processing: The ability to handle large amounts of data efficiently is crucial for this project. Please note, this Excel file should be capable of handling batch processing, not j...
...file for use by the notification system. 2. LuxAlgo Notification Integration: Integrate LuxAlgo Premium toolkit on TradingView. Configure alerts based on user-defined settings and conditions. 3. Machine Learning Pump Prediction: Implement a machine learning model to identify potential pumps of at least a 15% price increase. Ensure the model accounts for a maximum 3% retracement from the entry price. Integrate these predictions into the alert/notification system. 4. Signal & Alert System: Set up a notification system (e.g., email, SMS, or another channel) that sends signals when conditions are met. Configure alerts for multiple timeframes, from 15 minutes to 4 hours. Integrate both LuxAlgo signals and ML predictions into a cohesive alert system. 5. Testing ...
...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...
I'm seeking an expert in lead generation, email list building and data entry. The focus is on the media industry. Ideal Skills: - Proficient in data entry - Skilled in email list building - Experienced in lead generation - Knowledgeable about the media industry Key Responsibilities: WORK OFF OF SUGGESTED RETAIL AND COMPANY ADVERTISEMENTS AND DIG INTO DIRECT CONTACTS Preferably US based as knowledge of US luxury marketIinternational and domestic) and their print advertising is essential - Identify and collect information on potential business leads within the media industry - Data to be gathered includes: Contact name and position, Company name and industry, Email address and phone number for each lead This project is perfect for a detail-orien...
...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...
