Excel spreadsheet data collection Jobs
I have python script to copy title and keywords from excel sheet to image metadata , I need to add category to subject filed and price to comment filed so excel sheet will be title , keywords , category , price , data will be copied to image metadata
We have a quick project for a Google Sheets / Excel Expert We have a Google Sheet that we need to filter and match customer names up to a sales rep. Essentially it needs to work like this: - Master customer data will go in sheet 1. This contains a list of customer names in column 1, and the corresponding sales rep in column 2. - Each week, we create a new sheet with payment data. - The payment data contains the payment and customer name. - we need the filter to match the customer name in the new sheet with the rep and insert the sales rep name in a new column. This will probably need to be done with a scrip - we need a proficient and experienced person to do this. If you have the experience, please message and I'll give you a loom video explaining ful...
This project involves creating a comprehensive TrueNAS setup primed for file sharing and collaboration for home use. The system should provide more than 5TB of storage capacity to comfortably handle a robust collection of digital files. Key job requirements and potential skills involved: • Experience in designing and implementing TrueNAS systems, particularly for high-capacity home systems. • Ability to optimize the system for file sharing and collaboration. • Knowledge of the best practices for maintaining a secure and efficient file sharing system. • Capability to accurately gauge storage needs and procure appropriate resources. This project serves as a great opportunity for those who have vast experience in TrueNAS and are interested in applying their ...
I am urgently in need of an expert to assist me with a set of complex electrical circuit problems. Your task would be to: - Solve higher order ODE circuit problems - Assist with convolution problems - Tackle Laplace transfer issues The successful accomplishment of this project will result in: - Finding the transfer function - Analyzing the frequency response - S...Analyzing the frequency response - Solving for the circuit variables This project requires a great understanding of electrical engineering principles, particularly, higher order ODE, convolution problems, and Laplace transfer. Proficiency in complex problem-solving under limited time conditions is an added advantage. I need this job completed ASAP. If this sounds like the kind of project that you'd excel at, pleas...
I am in need of a skilled Bookkeeper with a sound understanding of quotes, POs, and invoices. I require 2 hours of these services everyday to maintain and organize my financial records. I currently manage my accounts using Excel, so ability to work with it effectively is key. Key Tasks: - Maintain financial transactions - Manage and update financial records Ideal Skills: - Proven track record in bookkeeping - Familiarity with technology sector taxes - Proficient in Excel - Great attention to detail and accuracy. Experience working in a similar role within the technology sector would be highly beneficial. If you have the necessary skills and experience, I look forward to receiving your proposal.
Se dedesa crear una pagina front + backend para asistente interno. En el front end se cargaran diferentes archivos (TXT, PDF, WORD, EXCEL en lo posible) con lo que llamaremos BASES DE CONOCIMIENTO pueden ser listas de precios, condiciones comerciales, etc con los que CHATGPT se puede conectar y consutlar via API y responder a los usuarios. Se aceptan sugerencias para este desarrollo o similar. Si tienen algo parecido para testear con gusto lo haremos. Se debe poder replicar en otras webs para armar diferentes chats con bases de conocimiento especificos.
...call-to-action buttons that engage visitors and draw them deeper into the site. Given these requirements, the ideal freelancer would have the following skills and experience: - Research and implement industry best practices for lead generation - Extensive experience with WordPress - Knowledge of user interface and user experience - Experience in form building and data collection - Understanding of GDPR and privacy standards for collecting data online - Capability to integrate call-to-action elements into a website's design. If you have the ability to build a SIMPLE ONE PAGE site that not only looks great, but effectively turns visitors into leads, I would love to hear from you. The deadline is urgent, so if you cannot make it in a day, then skip this. This...
Consolidated Sales Calendar report put in excel spread sheet.
More details: Small Business Beauty Salon excel program required Inventory management: Track products in stock, Set reorder points for products, Generate purchase orders Point of Sale (POS): Cash, Credit/Debit cards, Mobile payments for Retail products [GST&PST] and services Daily Reports: Sales report, Inventory report, Employee productivity report Client management: History records or services done with client details and specification Employee management: Information; Timesheets; Vacation Payroll: Run semi-monthly payroll with hourly rate vs commission rate [Canadian payroll information] Salon supplies: Calculate and track supplies used during services to add to POS on checkout Schedule: Appointment schedule for clients with ability to send reminders.
...professional to create an Excel workbook that provides user-specific access control. Unfortunately, I am unable to provide specifics about the type of access control, so flexibility and adaptability will be crucial for this project. Freelancers interested in this project should: - Demonstrate proven experience in Excel, particularly working with workbook-level protections and user access controls. - Have a strong background in data analysis, as this will be a key function of the workbook. Primary responsibilities will include: - Developing a user-friendly Excel workbook with user-specific access. - Incorporating data analysis functions into the workbook to streamline and enhance my workflow. Please remember to include your relevant experience in ...
... We're experiencing problems with duplicate results when using a SELECT query in the context of retrieving data from multiple tables in MySQL. I require assistance getting this resolved. The query selects data against two tables. The selection must compare Invoice Details with PO Details to return a single row of data for each Invoice Detail record that matches the LATEST po line item within the same ITEM and SHIP TO CITY. The current SQL is generating duplicate records because it is matching against multiple PO details instead of the LATEST (newest) PO detail for that Item/Ship To City match. FILES INCLUDED: SQL File For Table/Data Query File for SELECT Statement Excel spreadsheet showing duplicate entries highlighted Key Tasks: - Corr...
I'm in need of an expert in data visualization to assist me with setting up PowerBI and creating a dashboard for my business. Key Responsibilities: - Setting up PowerBI with a focus on data visualization - Integrating databases and Excel/CSV files as data sources - Creating a dashboard that presents Sales data, Website traffic and Product inventory in an easy to understand visual format Ideal Skills and Experience: - Extensive experience with PowerBI - Strong background in data visualization - Proficient in integrating databases and Excel/CSV files - Previous experience in creating comprehensive business intelligence dashboards - Ability to understand and visualize complex data sets This project is suitable for someone...
Looking for someone to start IMMEDIATELY I require a meticulous individual capable of transcribing dates, numerical figures, and a description of a charge found within scanned PDF images. The data obtained must be input into a Google Sheets spreadsheet adhering to a specific format or template I will provide. The freelancer needs to be detail-oriented, proficient in data entry, and experienced in handling scanned PDFs to ensure all the necessary information is accurately transcribed. Experience with Google Sheets is highly required. Looking for someone to start IMMEDIATELY
I need a GUI designed from scratch based on an existing Excel sheet. The GUI will primarily handle textual data. The key features the GUI must have are: - Data visualization: Show data in a user-friendly, visually appealing format. - Data filtering: Allow users to filter data based on certain criteria. The main purpose of the GUI is to present data, providing clear, easy-to-understand visuals of complex datasets. Ideal freelancers for this project should have experience in GUI design, particularly in relation to data visualization and filtering. Knowledge and experience with textual data handling is also a plus.
Need someone who can analize data from a excel and contact customer with missing data
Create a MEGA MENU as this designs: Create a SUB MENU as this design: Create a New page as this design using JETBOOST: https://www.london.edu/news#sortCriteria=%40articledateobject%20descending Create a Events page as this one and using a collection list and JETBOOST: https://www.london.edu/events/calendar#sortCriteria=%40eventstartdatetime%20ascending Create a Blog exactly the same as this one and using JETBOOST: Create a page like this: Create the breadcrumbs as this design:
I'm in need of a dynamic Excel sheet that automatically updates with real-time stock prices for the S&P 500 companies from the New York Stock Exchange (NYSE). This needs to be updated every minute. The main focus will be on delivering accurate, up-to-date, and reliable data. Key Features Required: - Real-time NYSE stock prices; - Ability to track up to 500 stocks from S&P 500; - Automatic updates every minute. Ideal Skills and Experience: - Proficient in Microsoft Excel; - Experience with real-time data tracking; - Knowledge or experience within the stock market realm; - Familiar with NYSE workings. Given the technical nature of this project, the successful freelancer should have adequate experience working with real-time data in Exc...
I'm looking for a professional with proficiency in Excel to carry out a data entry task involving text and images. The text data is currently formatted in an Excel spreadsheet and I would like to maintain that format for the entered data. Key tasks include: - Transcribing text data from Excel sheets - Efficiently importing and categorizing images Ideal candidates should have: - Previous experience in Excel-based data entry - Excellent attention to detail - Efficiency in handling images in Excel - Ability to maintain and replicate existing file structure Please note, the final output should also be in Excel spreadsheet format.
(Apply only if you can start ASAP and be able to draft the Gantt Chart in a few hours) I'm seeking a freelancer to make a Gantt chart using MS Project. The timetable for this project is stringent, so prompt delivery is paramount. I will provide all the details in Excel , you just need to put into MS Project and make a Gantt chart Key Features of the Project: - Focus on both subtasks and milestones when creating the Gantt chart. - The freelancer needs to be proficient in MS Project since it's the required software for this job. Ideal Candidate - Proven experience in creating/extensive knowledge about Gantt chart. - Prior usage of MS Project 2016. - Effective time management skills. Your prompt response will be greatly appreciated.
I am in dire need of an expert who is experienced in dealing with engines, specifically the Cummins V 903. Although no specific information is mentioned, the freelancer will be required to score and gather comprehensive data on this particular engine to aid my project. Ideal skills and experience: - Extensive experience working with engines, particularly the Cummins V 903 - Strong research and data collection ability - Ability to work independently and provide detailed reports When applying, please include your specific experience with engines in your bid. A proven record in similar projects will be highly valued. The key to success in this project lies in your knowledge and understanding of the Cummins V 903 engine.
In this project, I'm looking for an experienced engineer to assist in setting up a LORA node that will operate within a range of 1 to 10 kilometers. The LORA node will be designed to collect data on two environmental parameters: temperature and humidity. Requirements: * Expertise in LORA node set up * Experience with environmental data collection * Understanding of medium range data transmission * Familiarity with battery-powered devices The successful freelancer will provide thorough guidance on configuring a LORA node to meet these requirements. Experience in similar projects will be highly appreciated. Knowledge on battery longevity and power conservation is a plus.
...projects on the form can change. I need this sheets data to be used to determine if a project is currently occupied and to generate a weekly time report by project and employee. - Determine project occupancy: The solution should utilize the check-in/out times to determine whether a project is currently occupied or not. -Occupancy: Displayed on a Google sheet as text (OCCUPIED/CLEAR) next to the project name or change color (red/green) of project name. - Weekly time report: The time report can be in Google Sheets format. - Technology/Platform: You are free to choose the best technology or platform to automate this process. Ideal Skills: - Proficiency in data analysis and automation - Experience in project management and time tracking - Excel expertise - S...
I need an expert in data organization and geographic systems to help create a spreadsheet for our clients. We currently handle a large number of clients, and it's becoming a challenge to manage their locations efficiently. Key requirements for this project include: - Collate the city, state, and street address for each client. - Sort the listing according to proximity, with only latitude and longitude coordinates information. - Design the spreadsheet to be intuitive, easy to use, and update. The ideal freelancer for this job should have: - Proven experience in data organization - Excellent knowledge in geographic systems - At least basic understanding of latitude and longitude calculations. The end goal is to have a clear, concise, and accurate sp...
More details: We have an internal excel worksheet that has currently not been put into production, we would like this converted to an editable PDF document that only selected boxes are editable and once finished we can then fill and sign to use on an Ipad, Iphone or Desktop if amendments were needed to be made. We would need a slightly bigger signature box at the bottom to allow our engineers to the click on the box and sign with either their finger or an Apple Pencil.
I'm in need of a Python developer, experienced in SQlite databases, to build a music file deduplicator tool for my media collection. Key Functionalities: * The tool must identify duplicate music files, informing the user promptly about any match with existing items in the database. * When duplicates are encountered, the tool should not automatically delete but rather prompt me for the next action. Critical Features: * Display full details of the duplicate files detected for user analysis. * Provide a preview of the duplicate files before any proposed action is taken. Ideal candidates should have a solid grasp of Python and SQlite development, and proven experience in creating file management tools. An understanding of music file formats would also be beneficial. Efficient...
am seeking a competent data entry specialist with excellent attention to detail and proficiency in Tally. The assignment entails adding around 300 entries from an excel file to tally data (i.e. update company Tally Books ). Each entry in excel has comments that specifies the heading & vendor name for the data entry. Once the data is entered the same will be verified by us for correctness. Key Responsibilities: - Organizing extensive financial data within Tally with accuracy and precision - Ensuring the data is properly categorized and easy to understand - Verifying the accuracy of the financial data, correcting any errors, and handling any discrepancies. Ideal Skills and Experience: The ideal candidate should be precise,...
As per requirement, I will deliver the required district's School details in Excel format
I'm looking for a skilled statistician who can calculate the winning probability and the probability of a specific number appearing in a numbe...appearing in a number game I'm working on. The winning probability should be calculated under specific conditions that I will provide. I want the calculations to be presented in a clear and concise Excel sheet. The Excel sheet should be basic, focusing on essential calculations. Role Requirements: - Proficiency in statistical analysis and probability calculations - Advanced Excel skills for creating clear and concise spreadsheets - Ability to follow specific instructions for conditional probability calculations Ideal Skills: - Statistical analysis - Probability calculations - Excel - Data presentat...
More details: What type of data entry tasks do you need assistance with? Typing What is the source of the data for typing? Images How would you like the typed data to be formatted? Spreadsheet
I need a talented and experienced designer who can help me execute an extensive redesign of my Canva project. Ideally, you should have excellent skills in working with Canva and a keen eye for aesthetics. Specifically, the project will involve: - Text modifications: The font style will have to be changed while al...- Image replacements: Replace existing images with those I will provide. Skills and Experience: - Proven experience in managing Canva design projects - Excellent eye for detail - Strong graphic design skills - Good understanding of fonts, colors and layouts - Excellent communication skills to understand and translate my vision into the project design If this sounds like a project you can excel at, I invite you to place your bid. I look forward to seeing your ama...
I'm looking for a skilled professional who can create a VBA solution in Excel that can interact with a MySQL database. The system should be able to perform the following CRUD operations: Insert, Select, Update, and Delete. This will be a continuous requirement. Key requirements: - Proficiency in MySQL and Excel VBA - Strong understanding of SQL ODBC connections from Excel VBA - Ability to deliver the project within timelines. Your main task would be to create a reliable, easy-to-use, and efficient system to automate the specified database operations from Excel. In addition, the final solution should be well-documented for future reference. If you have experience in similar projects and can commit to the timeline, I'd love to hear from you.
I have less than 10 columns of text and numbers data, currently in scanned documents that need to be accurately typed into an Excel sheet. I am looking for someone highly detail-oriented with: - Proven experience in data entry or similar roles - Excellent typing speed and accuracy - Proficient in using Excel - Experience in digitizing scanned documents is a plus Responsibilities include: - Typing text and numbers data from scanned documents into Excel accurately - Ensuring no data is missed or misrepresented - Completing project within the agreed deadline. Looking forward to working with a diligent and efficient freelancer.
...gear details. ### Fan Engagement - Total points from all events that they have participated in. - Ranking that is assigned by Admin. - Event participation listing. ## Administrative Functions - Manual event and heat setup, with a user-friendly interface or spreadsheet integration. - Ability to categorize/filter events based on date and location. - Provision for real-time updates to heats and pilot listings. ## Technical Requirements - Responsive design compatible with Android and Apple mobile devices. - Secure user authentication and data encryption. - Scalable architecture to support a growing user base. ## Development Milestones **Milestone 1: Project Setup and Initial Design** - Establish project management tools and repository - Define the technology stack and dev...
...Report Card Generation: A feature is needed to automate the grading process and generate report cards based on the inputted grades. - Parent and Student Portals: The software should offer portals for parents and students to access information such as grades, attendance, schedules, assignments, and announcements. - Student Information Management: This includes features for storing and managing student data such as personal information, academic records, attendance, health records, and disciplinary history. - Teacher Management: The software should have features for managing teacher information, including their qualifications, schedules, attendance, and performance evaluations. - Curriculum and Course Management: Schools need software that allows them to create, manage, and update ...
I possess an extensive collection of state-owned enterprise data that I need to have analyzed by an expert in finance. The ideal freelancer for this job will possess a high degree of experience in financial data analysis, with a particular focus on these three key areas. They should also be familiar with the specific challenges and opportunities associated with state-owned enterprise data. This role will require a strong ability to interpret complex financial data and draw insightful conclusions that can be used to guide decision-making. Proficiency in statistical analysis software and tools will be key to success in this role. By the end of this project, my goal is to have clear insights into the financial performance of these state-owned enterpri...
In the continuity of the mission 'Finalization and uploading of a free 3D anatomy webviewer -- 3', the following functions would be added. 'Use arrows to go select within the proposition of the searchbar': -To wo...the current theme and a bright theme (black on white text and the background would be white (#F5F5DC)). The visual elements should fit to this new theme (with a dark version of the pictures in case of need). 'Add the bonus collections in the searchbar options' -Although they are not game objects, the user could see the bonus collection appear within the propositions of the searchbar, select them, and it would select the visible stucture belonging to this 'bonus collection'. See in the Unity project for the bonus collections...
I need assistance to convert an Excel file into the RES2DINV software for the purpose of visualizing and interpreting my data. The Excel file's content type isn't specified but it may contain geophysical measurements, soil resistivity, or survey data. This turnaround for this task needs to be as soon as possible. Ideal skills and experience: - Proficiency in utilizing RES2DINV software - Strong understanding of geophysical data interpretation - Experience in data conversion from Excel to RES2DINV - Ability to work on tight timelines.
I'm seeking a detailed contact list for marketing purposes, focusing on Iranians residing in Dubai. What I Require: - Age and Gender Information - Occupational Status - Residential Area - Identification of Business Owners Contact Details Needed: - Phone Numbers - Email Addresses - Social Media Profiles - Mobile Numbers Ideal freelancer would have experience in data collection and lead generation, with a keen eye for detail and confidentiality. Knowledge of the Iranian community in Dubai will be an advantage.
I am in need of an Excel expert who can create a formula that will allow for real-time updating across multiple sheets. This formula should automatically transfer all inputs from sheet one to both sheet 2 and sheet 3. Key requirements: - Expertise in Excel and formula creation - Experience with real-time data updating in Excel - Ability to automate data transfer across multiple sheets The assignments from sheet 1 should appear as the words written and not "assignment" in the weekly and monthly calendars.
I'm seeking a skilled Daz3D artist who specializes in realistic artistic representation for my private collection, focused on BDSM themes. Key responsibilities would include: - Developing and executing NSFW BDSM artwork in a realistic style - Ensuring that final art pieces reflect my specific artistic vision The ideal candidate should: - Have solid proficiency in Daz3D with examples of prior work - Be comfortable and experienced with NSFW content, particularly BDSM - Have a strong artistic capability to render realistic characters and scenes Please note that the work's purpose is solely for private collection; commercial usage rights aren't necessary.
I'm in need of an expert web scraping developer who can extract textual data from specific Wikipedia pages. This should be a one-off task as there is no requirement for handling updates or changes to these particular pages. Key specifications: - Targeted content: Textual data - Pages to scrape: Specific, to be provided Ideal skills and experience: - Proven expertise in web scraping - Previous experience with Wikipedia or similar tasks preferred - Ability to deliver accurate data in a structured format such as CSV, Excel, etc. Please avoid any unnecessary or redundant information.
I am in need of a personal assistant to professionally handle phone calls, answer emails, and meticulously track rental payments and expenses for 6-10 rental propertie...some responsibilities of a bookkeeper; hence, an understanding of and experience in basic to intermediate accounting is highly preferred. Key duties will involve: - Efficient management of rental properties - Timely tracking and recording of rental payments - Accurate accounting of expenses - Handling telephone and email communications A candidate with skills and experience in these areas will excel at this role: - Bookkeeping - Accounting (Intermediate level) - Property Management - Communication. For my peace of mind and the smooth operation of the rental properties, a meticulous, detail-oriented individual ...
I'm looking for an Excel expert who can modify the pricing formula and user interface of my existing price calculator. It is a very basic lookup, with quite rudimentary discounts that need to be applied, and we have a working example to share which you can backsolve how to build/update as needed. Here are the specifics: 1. Update the lookup to a new pricebook tab (Both current, working example, and new example with the new price book will be shared) 2. Introduce new add-ons tick list on the calculator (basic calculations (percentage of total, and fixed price) 3. Build out a visual display of a basic discount matrix (10%, 20% etc - this will be supplied) $. User Interface Improvement: - The updated calculator should still be user-friendly and intuitive. - Experience ...
I am seeking an expert in Excel to conduct comprehensive analysis on collected customer feedback, aiming to evaluate customer satisfaction. The raw data is currently stored in Excel spreadsheets and it essentially contains the comments and feedback from our customers. Key Responsibilities: - Deeply analyze the comments and feedback - Identify patterns, trends and vital points from the feedback - Importantly, provide a detailed report on these findings to aid further business decisions Ideal candidate must have: - Proficiency in Excel data analysis tools - Past experience in feedback analysis - Understanding of consumer behavior - Excellent reporting skills.
I'm looking for an expert to convert my existing Microsoft Excel Macro into a Google Sheet function with some added enhancements. The key enhancement is auto sorting on the newly created worksheets. The sort should utilize multiple columns, each with a unique order, either ascending or descending. Indispensable Skills: - Proficiency in Excel and Google Sheets - Familiarity with Macros and Google Scripts - Strong attention to detail, especially with data sorting and organization When you bid for this project, please say your opening comment as "Convert Excel Macro to Google Sheet Guru" - this way we will know who had done auto bidding and who has actually bothered to read out requirements. This job should be pretty easy and straight forward f...
I'm in need of a meticulous professional skilled in data entry, particularly with numerical data, to populate an Excel spreadsheet for me. Key Tasks: - Processing a variety of numeric data - Entering this data accurately into an Excel spreadsheet - Categorizing and sorting this data by date Ideal Skills: - Excellent attention to detail - Ability to work with numerical data effectively - Proficiency in Excel - Data organization abilities - Ability to categorize and sort data in assigned order
need a skilled freelancer to conduct data analysis on an array of mixed data (both numerical and textual) using Excel. The data will be provided in CSV file format. This project requires a sound understanding of data analysis concepts and proficiency in the use of Excel or similar spreadsheet software. Key Responsibilities: • Convert CSV files into a usable format for Excel • Analyze the given mixed data • Generate comprehensive findings from the data Ideal Skills: • Familiarity with CSV files • Proficient in Excel/Google Sheets • Experience in data analysis • Detail-oriented and accurate data entry • Good communication skills to effectively summarize findi...
I need a skilled freelancer to conduct data analysis on an array of mixed data (both numerical and textual) using Excel. The data will be provided in CSV file format. This project requires a sound understanding of data analysis concepts and proficiency in the use of Excel or similar spreadsheet software. Key Responsibilities: • Convert CSV files into a usable format for Excel • Analyze the given mixed data • Generate comprehensive findings from the data Ideal Skills: • Familiarity with CSV files • Proficient in Excel/Google Sheets • Experience in data analysis • Detail-oriented and accurate data entry • Good communication skills to effectively summarize...
I am seeking a native Welsh speaker to meticulously go through a list of over 20k words, identifying and categorizing any toxic terms. This task intends to foster a safer user environment. The ideal freelancer will have excellent attention to detail, and exp...through a list of over 20k words, identifying and categorizing any toxic terms. This task intends to foster a safer user environment. The ideal freelancer will have excellent attention to detail, and experience in content moderation would be advantageous. Key Deliverables: • Thorough scrutiny of the language list • Accurate identification and categorization of toxic terms • Output made in a spreadsheet format This meticulous work will contribute significantly to our cause of creating a user-friendly and resp...
