How to sort data in excel using formula työt
If you know how to code a javascript or python script to get a few pieces of information from Google, then this is easy for you. Here's all we need in this small project: 1. For a particular google search ON MAPs, the program would output the web URL, and name and send that to excel (or a csv) - other fields would be provided to include as well. 2. It should let me pick 1-50 entries. 3. It should work from within the browser (NO API calls necessary). that's it! Thanks for your bid
I'm seeking an expert to create an automated dashboard, aggregating training metrics from an eLearning Management System database. It is essential that Excel functions are automated, and feeding data into this dashboard should be user-friendly. Key responsibilities: - Design a dashboard that will display updated training metrics from a database - Automate Excel functions - Allow user-friendly data import Ideal candidate: - Proficient in Excel - Knowledge of DBMS (Database Management Systems) - Familiar with eLearning Management Systems - Experience in creating user-friendly interfaces - Strong time management skills, as the project needs to be completed within a month Our understanding of the exact DBMS is currently un...
Hello there is a free publicly accessible Google spreadsheet with 185 lines and 21 columns. Copy and download is disable. I need someone who is still able to copy the data into an excel spreadsheet or otherwise manually "copy" all data into an excel spreedsheet thanks I offer the link to the website after receiving bids Generic bids are ignored. Therefore pls write "i understand its a download disables google spreadsheet."
I'm looking for a skilled data science trainer who can introduce my large team to the foundational aspects of the field. Key Responsibilities: • Deliver beginner level lectures on data science • Train over 10 team members • Cover areas inclusive of Data Analysis, Machine Learning, and Predictive Modelling Ideal Candidate: • Expertise in data science education • Ability to conduct engaging, accessible training sessions • In-depth knowledge of Data Analysis, Machine Learning, Predictive Modelling • Experience in training larger groups The objective of this training is to equip my team with basic data science capabilities. Thus, patient trainers who excel...
I need a skilled and creative freelancer to create 100 different invoices for me in Excel. Each invoice must have its own distinct company design and company logo. Here are the specifics of the project: - I am giving you complete creative freedom to design each invoice. Let your mind run wild! - The invoices should include placeholder information whilst also leaving some areas blank. This will provide a more customizable experience. Ideal skill set includes: - Proficiency in Excel - Graphic design inclination - Creative thinking - Attention to detail Looking forward to seeing your brilliant designs shine on each invoice.
I'm looking fo...for an expert PHP developer with proficiency in Codigniter to modify and enhance an existing script I bought from CodeCanyon. Task Details: • Modify existing functionality and add new features to the script. • Add three new fields to the signup window code and sync it with the mySQL database. These fields should include text fields and dropdown menus. • Create a report based on data from one table in the mySQL database. • Implement a feature to export the report data to Excel. Ideal Skills and Experience: • PHP and Codigniter expertise • Experience with SQL database manipulation • Knowledge in report generation and data exporting to ...
I'm in need of a developer to build a simple CRUD website. A few specifics about my requirements: 1. The website should interact with an Excel file; enabling data extraction and modification directly from and to the file and Display the records in a grid or tabular format. 2. Search option to look for connection details with Applicant ID. 3. Add a date picker to filter via date range via date of application. 4. Option to view/edit electricity connection application requests. a. Refer dataset for the data attributes. b. Could be on same or different page. 5. Data Validation. a. Should not be allowed to change some data and put validations on a few fields. Nothing complex. 6. Create a visualizatio...
I require a freelancer who is proficient in extracting specific data points from a PDF document and translating it into a structured Excel or CSV file. The data is presented within paragraphs. Key Tasks: 1. Extract the following elements from the PDF: Names, dates, numerical values, lead location, phone number, email, US dollar value, status, date added. 2. Organise these elements in a structured format in an Excel or CSV file. Skills Required: - Attention to detail - Proficiency in data extraction - Strong knowledge of Excel or similar data management software - Ability to interpret information from paragraphs. Freelancer should assure accuracy as the correctness of extracted data is esse...
...assistance with the Etel formula, I have run into some implementation challenges. I'm seeking an advanced expert who can guide me through the implementation process seamlessly. Key responsibilities: - Addressing and rectifying the implementation issues I'm experiencing with the Etel formula - Provide clear, simple, step-by-step instructions in overcoming these issues and successfully applying the formula Ideal Skills and Experience: - Deep understanding of the Etel formula - Proven experience in teaching or explaining complex mathematical formulas in an understandable manner - High-level problem-solving skills - Adept at troubleshooting and explaining the solutions in a simplified manner. The numbers that are i...
...with experience in SQL to develop a utility program for my company. We utilize a ZKTeco fingerprint machine for tracking attendance, but the standard reports it generates are not meeting our needs. My hope is to have this application improve the readability and functionality of these reports. The tasks you'd undertake: - Building a lightweight application that can process the .dat files generated by the machine. This application should not merely replicate the machine's output but offer new ways to view and sort the information. Key features I'd like to see: - Ability to view attendance trends, which is not possible with the machine's default output. - Enhanced sort capabilities, allowing organization by dep...
...With a perpetual commitment to enhancing our client services, we have streamlined our processes to offer comprehensive account management for hosts. As a Customer Support Specialist, you will play a pivotal role in ensuring the smooth functioning of our clients' properties. This role requires individuals with exceptional attention to detail, a collegiate background, proficiency in basic software tools, and the ability to utilize electronic devices effectively. Responsibilities: -Review and rectify any inaccuracies in client property information. -Ensure all property details are up to date and accurately represented on the platform. -Post and advertise client properties on Booking.com. -Utilize our partner marketplace or mo...
I am presently working on an extensive project involving several excel spreadsheets. These spreadsheets contain sentences for a book and I require a freelancer to help me color code the cells based on different categories. The color will represent different aspects of each category. The color coding will include: - More than 10 different categories - Existing color suggestions that need refining - Categorization that's based on multiple factors, going beyond the book chapters The ideal freelancer for this job should possess a good understanding of Excel and have a knack for good organization and attention to detail. Strong collaboration and communication skills are key, as I'll need to discuss and finalize the color scheme and the factors aff...
I'm in need of a proficient Excel expert who can proficiently apply formulas to my dataset. Here's what you'll be taking on: - Add 'Sum', 'Average' and 'Count' functions to the given data set. Your expertise in implementing these formulas will be highly valuable. - The dataset needs to be sorted based on validity. I'm not entirely certain whether ascending or descending order would work best, so I'm open to your professional advice. - Prioritization should be given to the most recent entries. They should appear at the top of the dataset after sorting. To succeed in this task, you must possess advanced understanding of Excel functionality and a keen e...
Need nay type of data entry work
Hello, I and creating a 3-year business plan. I have the first-year projection but I need to calculate the subsequent years, both 2 and 3. I need to add 15% each year which I am using year one as a basis to calculate and add 15 percent each year.
...serves to upload and validate data from an excel file to a database. This function should be equipped with the following features: 1. Data Type Validation 2. Data Format Validation This task requires proficiency in database structures, data validation methods, and experience working with Excel file manipulation. The ideal candidate, consequently, should be able to display capabilities in these areas. Their experience in similar projects would be a bonus. Here is the main flow: 1. User upload excel file 2. System will check and validate the data 3. System saves record into multiple tables in a database 2 types of excel files involved. Please check attachments. 3 types o...
...am struggling with a VBA Excel file where the Macro is not running correctly, and I need someone proficient with VBA and debugging to fix it. The file is crashing frequently, which is causing significant delays and impacting efficiency. • **Macro Issue:** The macro is not running and I am unable to debug or fix it myself. I need an expert who can look into the problem, define what's wrong, and provide a solution that works flawlessly. • **Purpose of the Macro:** I will discuss this further with the successful applicant, but rest assured that your tasks will align with typical VBA Macro functions. Since the purpose of this macro hasn't been disclosed, I am expecting you to have experience with commonly used VBA functions like automated ...
...camps in Portugal, shooting photos of around 170 persons/10.000 photos per week. Our service consists of selling a pack of photos for each person, so we have to sort all the photos into individual folders. Requirements English or Portuguese knowledge for easy communication. Fast internet for downloads and uploads. Dropbox user, for easy and fast synchronization. Good organization Time Frame This shouldn't take more than 10 to 12 hours weekly max, normally between Wednesday and Saturday early morning. We're looking for someone who can work with us consistently every week from March to October, preference for someone who works in a different timezone than us (GMT +0h00) or is available to work during the night. Please give u...
...Create VB Macro for pulling dates: This Month to Date, This Quarter to Date, This Year to Date and have dynamic calculations no matter what the date is OR allow user to have a custom Begin Date and As of Date. - Checking and savings accounts need to pull transactions between two dates (“Begin Date” to “As of Date” or to date calculations above), not just “as of date”. - Credit card account needs to pull transactions between two dates (“Begin Date” to “As of Date” or to date calculations above), not just “as of date”. - Sales Tax Payable needs to pull transactions from “Transactions” worksheet, column S, unless you can write a S...
...entry-level Machine Learning Engineer to work on a project. Though I have no specific preference for the algorithm to be used, I trust the right individual for the job would make the best selection. Skills and Experience: - As this project is suitable for a beginner level developer, prior experience solely focused on Machine Learning isn't strictly necessary. - Knowledge of basic ML algorithms such as Logistic Regression, Random Forest or Neural Networks is required. - Having a relevant degree in Computer Science or related fields would be a plus. Applicants need to: - Provide detailed information about their past work related to Machine Learning or in the broader field of Data Science. This will be essential for demonstrating cap...
I'm in search of an experienced WordPress developer to design a 3-4 page consulting website. This includes the necessary pages: a Home page, an About Us page, and a Services page. • Home Page: The Home page will strictly include our latest news or updates, ensuring visitors stay informed about our progress and achievements. • About Us Page: This page will encompass not just our team, but more so the history and mission of our company. Introduction of our individual team members is not necessary for this project. • Services Page: This page will enumerate and explain the consulting services we offer, providing potential clients with a detailed understanding of what we can offer. A Developer with a strong background in Wordpress and a good underst...
I am in need of an expert in Excel who can provide assistance in managing multiple sheets in an Excel file. The spreadsheet requires extensive data analysis, formula creation, and formatting. Key requirements include: - Ability to analyze complex data across multiple spreadsheets - Proficiency in creating advanced Excel formulas to automate processes - Expertise in formatting spreadsheets for ease of use and understanding While I have advanced proficiency in Excel, I need someone capable of handling these tasks efficiently. A background in data science or similar is desirable.
...this project. 1. The Windows version I am using is LTSC Professional Plus 2021 2. Please test it before agreeing to this job. This is how my web query look, see the most right picture, the table doesn’t show up 3. In the Worksheet "Link 1", this contains a list of basketball league tables from several countries. I have only listed 1/10 of the full list for the purpose of testing the outcome of this job. 4. The link for each of the table is listed in the RED weblink. 5. Requirement- The requirement to copy from the "R" until the last row last string, such as W1 in the example. The data will be pasted in the cell right below the link, in this example is Cell B7. 6. Requirement- When the spr...
Looking for an expert in data extraction and management, specifically from Websites, APIs, and Databases. The project involves extracting numerical data daily and integrating the information smoothly into an excel sheet. Skills & Experience Required: - Expertise in data extraction. - Proficient in API integration. - Experience with database management. - Excellent skills in Excel data manipulation. Responsibilities: - Setup extraction from multiple data sources (Websites, APIs, Databases) using Zapier. - Ensure extraction of numerical data only. - Secure daily extraction and update of the information. - Seamless integration of the data into an Excel sheet.
I am in dire need of an efficient, detail-oriented administrative assistant who can help me with a number of tasks that I am currently juggling. Your core responsibilities will include: - Data Entry: You should be familiar with Microsoft Excel, as a significant part of your job will be related to entering and managing data in a structured, orderly manner. - Email Management: Not only will you be tasked with responding to inquiries on my behalf, but you'll also be setting up automated responses to maximize efficiency and ensure no email goes unanswered. - Scheduling: You will also help in scheduling meetings. This will involve coordinating with multiple parties to find suitable times. Ideal candidates should have...
...of my project centres on lead generation. To successfully meet the project's goals, I require a specialist in email scraping to obtain addresses for real estate agents across South Africa and the UK. The target website where these emails will be extracted from is Property24. Of utmost importance and unique to this project is the regional scope. It should cover all regions, without exclusions, within the two countries mentioned. To excel in this project, having the following skills/experience would be ideal: - Strong experience in email scraping - Familiarity with the Property24 platform - Sound understanding of real estate markets in South Africa and the UK - Ability to accurately segment data by regio...
...an experienced VBA developer to create a custom add-in for Excel. This project will require: - Developing custom functions to automate the generation of multiple types of charts in Excel, specifically pie charts, bar charts, and line charts. - These charts should be formatted according to our specific design requirements, including our house style and measurements. The ideal freelancer will have exceptional skills and experience in VBA and Excel add-in development. I expect a strong understanding of data analysis and an excellent ability to perform tasks accurately and efficiently. Furthermore, I value clear and regular communication so we can ensure the end result meets our expectations. Please o...
I'm in urgent need of a web based application that transforms PDF files, largely bank statements, into Excel layouts. Key Features: - The application should have batch conversion support, allowing numerous files to be converted at the same time. - It needs to have OCR (Optical Character Recognition) capability for pinpointing and extracting info from scanned PDFs. - Its operation should be secure with user authentication and access control features to maintain data privacy. Ideal candidate skills: - Robust experience in web application development - Familiarity with OCR technology - Knowledge in building secure applications with user authentication and access controls - Ability to work under pressure to fulfill ...
...database creation and Excel data organization to produce a new, streamlined database from my current Excel one. Key Project Requirements: - Convert an Excel database with 1-10 sheets/tabs into a new database system. - Your task is to simplify and streamline the layout of the data for ease of use, without losing critical information. - While expertise in Excel is a must, experience with other database systems is also necessary, considering we might need a smoother platform than Excel. Ideal Candidate Skills: - Thorough experience working with Excel and other database systems. - Exceptional at delivering swiftly to meet today's deadline. - Excellent understanding of efficient data layouts ...
I will provide demo video of how the website should look like. Please watch it and also read the other description mentioned below. Some stuff that I have mentioned here, are not mentioned in demo video . like the features of shop, admin panel. payment. YOU SHOULD CREATE A PRIVATE GIT HUB REPOSITORY WHICH HAS ALL THE CODE AND SEND IT TO ME. I want to run the website on LOCALHOST. I wont be HOSTING it. The name of the website is RenderzHub. Have a look at as it has the features that I need in my website. But don't go to put efforts in making it exact as artstation. Languages to be used: Front-end: HTML, CSS, JavaScript using React.js framework. Back-end/Database: PHP with MySQL. The website should have followin...
I need an experienced data scraper who can extract specific information from a horse racing website. Your task will be to gather data on past horse race records, focusing on: - Horse Names - Race Dates - Horse Positions - And the complete data from the table What I need is for this information to be extracted from the website and then outputted into an Excel file. Proficiency in Data Scraping tools and Excel is mandatory for this task. Prior experience with similar sports data scraping will be highly advantageous. Efficiency and accuracy are crucial in this project.
...am aiming to construct a user-friendly stock management website. This platform will handle both physical and digital type products, echoing the examples of user interface () and admin interface (). Key Features to Implement: - Inventory Tracking: Capable of monitoring stock levels real-time. - Order Management: Streamline order processing, track shipping and returns effectively. - Product Categorization: Users should be able to sort and filter products with ease. Ideal Candidate: The ideal candidate for this role should be experienced in creating stock management systems, well-versed in order management, have a sound understanding of inventory tracking, and a knack for product categorization. Prior work related to similar projects
...offers the flexibility to work remotely from home. Responsibilities: 1. Conduct outbound calls to prospective clients in the education sector to promote our products and services. 2. Engage with leads effectively to understand their needs and recommend appropriate solutions. 3. Present product information, pricing, and benefits persuasively to potential customers. 4. Follow up on leads and inquiries promptly to ensure timely conversion and closure. 5. Achieve and exceed sales targets on a consistent basis. 6. Maintain accurate records of all sales activities and customer interactions in the CRM system. 7. Collaborate with the sales team to develop effective sales strategies and campaigns. 8. Stay updated on industry trends,...
I'm looking for an experienced professional who can help bring life to my idea. Your detailed project proposal will give me confidence that you're the right person for the job. While the specific problem this idea is meant to solve is not set, your imaginative approach, collaboration, and guidance will help shape the project's direction. ## **DSAonDECK: Data Structures and Algorithms Learning Hub** ### **Website Description:** **DSAonDECK** is an interactive platform designed to help students and beginners learn Data Structures and Algorithms (DSA) effectively. Whether you're preparing for coding interviews, improving your problem-solving skills, or simply curious about algorithms, this website provides a comprehensive learning...
I need an expert in MS Excel to finalize an advanced timeline schedule. It should consider different factors such as: - Variable work hours per day, - Weekends, - Overtime hours. It's crucial that the dynamic schedule intelligently adjusts to these factors, providing an accurate timetable for my team's workflows. Column M should focus on "Estimated Completion Time". Ideal candidate should possess: - Excellent knowledge and experience with Excel functions and dynamic formulas, - Attention to detail, - Adherence to specified conditions, - Familiarity with corporate scheduling norms will be a plus. Your insightful input to perfect this timeline tool would be highly appreciated.
...of data, I need a proficient Excel VBA expert to assist in automating my reporting and dashboarding processes. An ideal candidate for this project should possess the following: Skills and Experience: • Extensive experience developing VBA Macros • Capability to generate reports automatically • Familiarity with handling data across multiple sheets Specific Tasks: • Developing macros to automate data retrieval from sources such as Excel workbooks and CSV files • Implementing these macros to streamline the process of report generation and dashboard updates By simplifying these tasks, this project will enhance our overall productivity and data management processes. It is crucial that the ...
...proficient data analyst with the ability to tackle complex data sources and deliver clear, actionable insights. Key Skills and Experience Required: • Exceptional statistical analysis abilities; • Strong data visualization and programming skills. Expected tasks: • Handle data from different sources such as Excel spreadsheets, SQL databases, and CSV files. • Analyze the acquired data meticulously and generate concise reports on your findings. Project Outcome: • Provide profound insights and recommendations based on the data analyzed. • Create comprehensive visualizations and reports to aid in decision making. • Develop predictive models derived from the data analysis. The ...
I'm looking for a highly organized and meticulous freelancer to handle a numeric data entry task on Excel. Your task will encompass: - Entering simple numeric data into predetermined fields. - Color-coding the entries to ensure easy readability and data categorization. - Ensuring the data is entered accurately and double-checked for any potential errors. Prior experience with data entry, particularly numeric data, is highly advantageous. Proficiency in Excel, particularly with color-coding functionalities, is also a must. Attention to detail is key, as well as the ability to adhere to strict formatting guidelines. Hearing from candidates with a proven track record of delivering high-qua...
I need an expert in finance and Excel to provide oversight on my project. The Excel model you'll work with is tailored for financial forecasting. The main tasks include, but are not limited to: - Scrutinizing and validating existing formulas - Ensuring data accuracy and integrity - Identifying and promptly fixing any errors These tasks require a robust understanding of finance-related models, specifically in the realm of financial forecasting. Familiarity with investment calculations and risk assessment would also be beneficial, though not a primary requirement. The right professional for this job must have in-depth experience with Excel, its advanced features, and the finance industry. Your insights and expertise wi...
...an expert freelancer to beautify my Word document resume. I already possess the necessary content. What I need now is someone who can bring their creativity and sound formatting skills on board to make my resume not just stand out, but shine. Ideal applicants should: - Have prior experience with resume design, particularly in a corporate style and AtS compliant - Excel in the formal formatting of documents, specifically Word. Your duties would include but are not limited to: - Arranging my existing content into an elegant, eye-catching layout - Suggesting addition or removal of sections in order to increase clarity and cogency In your application, kindly elaborate on how you plan to approach this task, w...
...professional to manage my administrative and accounting tasks. Responsibilities include: - Data entry: Keeping track of all transactions and inputting them into my system accurately is the key. Mastery of Microsoft Excel is an absolute must as this is the platform used for managing this data. - Bookkeeping: I require someone who is well-versed in handling financial records. You will be responsible for keeping all the financial facts and figures in check. - Financial analysis: I expect a high level of accuracy and attention to detail in reviewing financial data for any irregularities. Your role will involve providing insights based on these analyses. Skillset: - Excellent Microsoft Excel skills: Proficiency i...
I'm looking for an Excel specialist to integrate a user-friendly Graphical User Interface (GUI) into my existing price list spreadsheet for a complex software product line. The GUI should considerably simplify the selection process for our customers, offering the choice between software packages and a la carte ordering. Key functionalities to be included: - Package selection: The GUI should contain an interface allowing users to choose from various software packages. - A la carte ordering: For added flexibility, there must also be functionality for users to select individual software options independently of packages. - Option selection: A tool for detailed and specific software choices is necessary. For displaying the available packages and optio...
I am in need of a skilled Tally developer to customise my current system, specifically to improve our ways of exporting data. I am looking for an expert who can: - Modify our Tally system so it can export TDS deduction data to an Excel template format we use. - Include deductor's detail and deduction details in the data that is exported. - Seamlessly transition data from Tally to our IT PL BS format as well as CAOffice tb format. Experience working with these specific modules and formats will be highly valued. Your expertise should include understanding the requirements of data export and manipulating Tally to suit those needs.
I need a spreadsheet created from All of this information is updated and relevant. Once into excel, I need the postal mailing address for each organization. This will need to be found and verified via google.
As an employer, I require a capable freelancer who...employer, I require a capable freelancer who can create an efficient Excel attendance sheet for me. The ultimate goal is to track my employees' attendance on a daily basis by their work shift. Scope and Deliverables: - Design and implement an attendance sheet using Excel - Categorize the data according to different work shifts - The sheet should capture daily attendance data Ideal Candidate: - Must be proficient in Excel - Should have prior experience in HR systems or work schedule development. - Understanding of data categorization and visualization methods. - Attention to detail is key to perfectly capture the attendance data. ...
...this project. 1. The Windows version I am using is LTSC Professional Plus 2021 2. Please test it before agreeing to this job. This is how my web query look, see the most right picture, the table doesn’t show up 3. In the Worksheet "Link 1", this contains a list of basketball league tables from several countries. I have only listed 1/10 of the full list for the purpose of testing the outcome of this job. 4. The link for each of the table is listed in the RED weblink. 5. Requirement- The requirement to copy from the "R" until the last row last string, such as W1 in the example. The data will be pasted in the cell right below the link, in this example is Cell B7. 6. Requirement- When the spr...
NECESITO UNA TABLA EN EXCEL, PARA MANEJAR UN EMPRENDIMIENTO EN EL CUAL SE PUEDA CALCULAR STOCK AUTOMATICAMENTE, COSTOS ,GASTOS UTILIDAD Y TOTTAL DE UTILIDAD DE TODOS LOS PRODUCTOS Y QUE AL MOMENTO DE DESCONTAR 1 ITEM DEL STOCK ME GENERE EL COSTO Y EL GASTO Y LA UTILIDAD QUE SEA SOLO INGRESAR LOS DATOS.....ES UN EMPRENDIMIENTO DE IMPORTACIONES DE CHINA , ASI QUE LOS PRODUCTOS VAN A SER VARIADOS Y DE TODO TIPO .
I am in need of a talented interior designer to add a modern twist to the midcentury styled bedroom, en suite and wardrobe in my home. The specific requirements for the job are: - Design knowledge: Having a deep understanding of midcentury design and an ability to incorporate modern elements within this design language is necessary. 2D plan is attatched. - Bedroom design: The bedroom is of medium size. The design should make optimal use of the available space and transform it into a relaxing sanctuary. Built in warderobe/closet or walk-in one. Pale wooden floor or carpet. - En suite design: a preferably micro cement bathroom in a beige/or light grey colour palette. All windows will be replaced to modern black aluminium o...
son 3 formulario que se llenan a mano, me gustaría automatizar esos proyectos quiza en excel o en google sheets. La idea es crear un solo formulario para que estos se generen automáticamente,
