See the attached File. Simple project here. If any of the words in column A, sheet 2 are in column D, Sheet 1, then delete the entire row (in Sheet 1) (Delete the entire row, not just the cell) No macros Likely conditional formatting, new rule is the best. This will be used on multiple files so it needs to be quickly applied. New words will be added to the list to filter for. The filter list can be added to each new file. No Macros Type :Sponge Bob" in your bid (to sort through the spammers) This should be a very low cost bid and delivered today.
I need an Excel expert who can craft 4 meaningful bar charts to visualize several health metrics. The foremost tasks required would include: - Visualizing perceived health data acquired from various sources namely, self-assessment questionnaires and participant interviews - Converting raw data of percentage changes in health into impactful insights using Excel It's pertinent that the freelancer has a good grasp of Excel and data visualization. A comprehensive understanding of health metrics would be appreciated, but not compulsory. Your role will aid in the better comprehension of health improvement or decline, ultimately guiding decision-making based on these observations.
I am looking for a skilled individual to create 4 bar charts in Excel for the purpose of showcasing percentage changes in perceived health over time. Key requirements: - Using perceived health data, generate 4 bar charts showing changes over time. Ideal Skills: - Proficiency in Excel - Understanding of data visualization - Ability to depict percentage changes in a clear and accessible manner. Please provide examples of your past work in your bid.
I need an Excel file created with text, numbers, and formulas. The data should be organized using rows and columns, across 6-10 tabs/sheets, and include pivot tables. Ideal skills and experience for this project include: - Advanced Excel knowledge - Experience in creating organized and visually appealing Excel files - Proficiency with pivot tables and formulas - Attention to detail and ability to follow specific instructions If you have experience with similar projects and can deliver a well-organized Excel file with the specified features, I'd like to hear from you.
...from an Excel file. The automation should be set up to run on Windows operating system using Power Automate. Requirements: - Automate creation of tasks and subtasks in Microsoft Planner from an Excel file - The automation should trigger based on a specific action, potentially a call, button, or script (vba button Prefered) - The system should be set up to run on Windows Ideal skills and experience include: - Proficiency in Power Automate - Prior experience integrating Microsoft Planner with Excel - Strong understanding of Windows OS and how to set up automation scripts to run on it - Experience creating and managing subtasks in project management software I am looking for someone who can create a reliable and efficient automation system that can seamlessly integr...
I am looking to automate email sending through Excel. I have a list of email addresses and the same message to send to all recipients. However, there are certain conditions to consider: Firstly, as shown in the screenshot below, there are checkboxes with options (OUI ou NON) YES or NO. If the checkbox is marked with a "YES", the email will be sent. Otherwise, it will not be sent. Secondly, another condition relates to the frequency of email sending: Once a week Twice a week Once every two weeks Once a month I would like to establish an automated process that takes these conditions into account to send emails according to the specified parameters. Thank you for your assistance in implementing this solution." This version of the message is clearer and more precise,...
In t...business analytics and data visualization to achieve multiple objectives: - Identifying key trends and patterns - Making data-driven decisions - Enhancing data presentation and communication The primary data sources for this project will be Excel spreadsheets, social media platforms, and analytical software, such as PowerBI and Tableau. The desired insights from this project are specifically: - Analyzing closing prices - Gaining a clear perspective of the stock market trends Ideal applicants for this job should be highly skilled in use of Excel, PowerBI, Tableau, and social media analytics. A keen understanding of revenue performance, stock market trends, and closing price analysis is also crucial. Proficiency in communicating data-based insights effectively is ...
...addresses, phone numbers, and business addresses. The targeted businesses should be choose through a defined criteria: location and industry. Your responsibility will not stop there. You will also need to compile the acquired data into a well-organised Excel spreadsheet - ensuring information is accurately represented and easy to navigate. A meticulous attention to detail is vital in this role, alongside experience in similar data scraping tasks. Skills: - Experience with data scraping - Proficiency in collating and organizing data - Excellent Excel skills - Attention to detail - Familiarity with Shopify and Zomato platforms This is not a short-term project. I'm looking for someone willing to establish a long-term business relationship, maintaining and regularly...
I'm in immediate need of a Linux expert with advanced problem-solving skills to assist with multiple tasks involving CentOS. - The right professional should excel in troubleshooting and debugging, Linux server administration, and Linux programming. - As the tasks are of an advanced nature, a strong background in Linux systems, particularly in CentOS, is essential. - Prior experience with complex issues is a must. Your challenging role will involve locating and fixing faults, managing the Linux server, and coding in the Linux environment. - If you feel you fit this profile, please apply, detailing your previous similar experience. Your commitment to a streamlined and effective Linux operation will be welcomed here.
As a business owner, I'm in dire need of a VBA Excel expert to automate key aspects of my inventory management. The primary goal of this project is to create an effective material management system. Task Description: - Automate data entry and generate regular reports - Update inventory levels regularly - Implement an efficient inventory tracking system within the operation Key Feature: The main feature that this project should hold is inventory tracking. Inventory Tracking System: - The inventory tracking should be innovative, able to adjust stock depending on the inventory levels. - Implement an automatic reordering system that triggers when stock is low. This will ensure that the operation runs smoothly without the worry of running low on inventory. Ideal candidate:...
I have a excel of Maharashtra PT it has all macros and all i am able to use it but its outcome from excel the text file am not unable to find
I need a skilled Excel data analyst to work on sales data. Requirements: - Experience: Please include your previous experience with similar data analysis projects in your application to be considered. Please submit your bids along with a summary of your experience in this field. I will share the specific data once we are in contact.
I have a black and white Excel sheet that dosent look Professional ... I need it to be Colorful and attractive
I need a data entry specialist to compile an Excel spreadsheet database of addresses and opening times relating to approximately 400 branches of the Citizens Advice Bureau. The data will be collected from URLs that I will provide. Ideal Skills and Experience: - Proficient in data entry and Excel - Experience with web research - Attention to detail - Ability to meet tight deadlines - Previous experience with similar projects is a plus This is an urgent project and I need it completed as soon as possible. Thank you.
...company who owns the Quickbook file and the software registration details. What I don't have is knowledge of the specific password that I used for the file at the time. I have a list of 35 passwords that I was using for various tech systems around 2009. One of which is likely to open it or as a professional you may know a different way to access the data. At minimum I need from you an Microsoft Excel or Libre Calc file of all of the data in its fields that I can work with. Ideal professionals for this task should: - Have proven experience with Quickbooks, especially old versions - Be familiar with potential issues of opening older Quickbooks files using newer versions - Be able to ensure that data integrity is maintained throughout the process To show you're up fo...
I have code for login trading accound and fetch token data. I need to update code to my system. you can create new code for my requirement at same cost.I need to collect live data from the web and candle stick with different time frame.I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Stock Broker account: If Buy signal find it will automaticlly place Buy order,etc., Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish...
I require both exterior and interior architectural 3D renderings for design development purposes. The renderings need to be detailed, inclusive of texturing, lighting effects, and even furniture and decor. - Freelancers that excel in photorealistic 3D modelling and architectural visualization are preferred. - Experience with a variety of 3D software and sophisticated texturing and lighting techniques is desirable. - The ability to effectively represent scale and layout, as well as a keen eye for interior design and detailing, would be beneficial in this project.
I am in need of a professional to convert a text-only PDF document into an Excel file. The converted document should not just be a direct replication, but should include some modifications to the formatting. The tasks are as follow: - Convert the text-only PDF to Excel. - Reorganize some data sections in the converted file. - Add or delete certain rows or columns as required. Proven experience in data organization, data entry and advanced knowledge of Excel is ideal for this project. Attention to detail is crucial as the final output needs to maintain content accuracy while adjusting the original format.
I'm in need of a creative graphic designer who can help me with designing materials for my product launch and portfo...portfolio showcase. Key Responsibilities: - Design a brand new website to promote my product/service - Design print materials to showcase my portfolio Ideal Skills and Experience: - Proficient in website and print design - Previous experience in promoting products/services - A portfolio showcasing previous design work - Understanding of consumer-focused design If this sounds like a project you'd excel at, please submit your bid along with relevant examples of your work. Ideally person should be able to work in illustrator understands that concepts of pixel base and vector base .. Has great knowledge of resolution adjustments. , 2 d drawings and banner ...
More details: Are you looking to hire a freelancer to clean data in both CSV and Excel formats? Yes What is the primary goal for cleaning this data? Assessment What type of assessment do you need the freelancer to perform on the data? pass assignment.
More details: Are you looking to hire a freelancer to clean data in both CSV and Excel formats? Yes What is the primary goal for cleaning this data? Assessment What type of assessment do you need the freelancer to perform on the data? pass assignment.
I am looking for an Excel expert who can set up automation for specific tasks and create custom formulas based on my requirements. Key Requirements: - Automation of specific tasks: I need to reduce manual work and save time by automating repetitive tasks. - Custom formulas: I need new formulas developed to perform calculations and analysis that are not covered by Excel's standard functionality. Autocalculation Trigger: - I want the autocalculation to be triggered every time the Row is highlighted with sold green color. I have ten different columns with hundred of rows with specific beginning text "spect". When user fills a background color assume its solid green on a cell of a particular column the function should autocalculate the complete column and report the ...
...research supervisor or principal investigator. Qualifications: • A graduate degree (MS or MPH) preferably in the field of public health, health economics, or a related discipline. • Strong academic record in research methods, statistics, and quantitative data analysis preferred with SAS or STATA • Excellent written and verbal communication skills. • Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint) and research software/tools. • Ability to work independently and collaboratively in a fast-paced environment. • Detail-oriented with strong organizational and time management skills. • Prior research experience in systematic reviews and meta-analysis and manuscript publication is a plus This is a part-time position, between 10 and 20 h...
I have a project that revolves around copying and pasting text data within a single Excel sheet, focusing on specific rows or columns. - Brief for This Job - Your primary task is to copy text from specific rows or columns and paste them responsibly where needed. This project will probably only take four hours of your time. (course number + date from + date to) copy paste beside every student name I need it for my database to be in this format video will be send to you to understand my requirement each freelancer will cover 200 course out of 1000 course so 5 freelancers will be hired maximum budget is 16$ for each freelancer do not contact me if your bid more than that submission within 24 hours from awarding the project (failure to submit will considered cancelation of the ...
I need a dedicated and thorough researcher to help me compile a comprehensive list of local builders, plumbers, electricians, and roofers. Your main task involves finding their emails and Instagram accounts as we need these for marketing purposes. Key Requirements: - The service providers must be local to a specific city which will be provided to you. - The collected information should inc...name, service type, and contact number. - The information should be appropriately organized into a Google Spreadsheet so that it's easy for me to analyze and use. Skills and Experience: - Experience in web research or data mining - Precision and attention to detail - Familiarity with Instagram and ability to find user profiles - Excellent organizational skills - Proficiency in Google Sheets ...
Have operations based math problems that I need done for a work project. 3 problems that involve aggregate planning, inventory planning, subcontracting, production levels, economic order quantities ect. Strong excel knowledge required where you can run solver.
I'm seeking a talented visual effects artist to create a stunning character transformation scene for my film. Specifically, the scene involves a character eerily morphing into a dead body. Requirements: - Proficiency in c...Proficiency in creature animation, particularly in the realm of morphing effects. - Experience with macabre or horror-themed VFX would be an asset. - Capability to create convincing and visually striking transformation effects, in this case, human to corpse. - Ability to closely collaborate and discuss progress and revisions. This project presents a unique challenge and is ideal for those who excel at creature animation and have a knack for the unsettling and uncanny. Your creativity and distinctive flair will bring an integral scene in my film spectac...
I am in need of a skilled SQL coder to help me join the tables and build a health care report in Excel. The report will focus on patient demographics and medical procedures. Key requirements: - Expertise in SQL coding - Proficiency in Excel for report building - Experience in handling health care data - Ability to merge tables effectively The report should include: - Patient demographics such as age, gender, and location - Medical procedures data The ideal candidate should be detail-oriented, able to follow instructions, and have a background in health care data management. It is important that the report is well-structured, easily understandable and can be updated efficiently.
More details: Do you want the Excel program to convert purchase orders and local stock into separate TXT files? Yes Should the program automatically detect and apply specific parameters for each conversion, or will you provide the parameters? Mix of both Which specific parameters do you need for the TXT conversion of purchase orders? Each order should be a TXT
...in Google Spreadsheets. Though I have a sound understanding of Google Apps Scripting, I find myself needing professional assistance with: - Data Entry & Organization: My project involves significant amounts of event data that require precise and systematic entry and organization. - Formula Creation: An adeptness at formula intricacies is a must-have. You should be capable of formulating complex prescriptions to perform specific functions. - Report Generation: Coupled with formula creation, you should be able to synthesize the data into concise and illuminating reports. - Scripts & General Automated Solutions: Lastly, I'm looking for someone who can write scripts and provide automated solutions to enhance overall efficienc...
I am looking for a proficient data analyst who can assist me in providing data analysis using Excel. Specific tasks include: I have two online retail catalogs that sells similar products as one another. Medline & CVS Health. Medline has 313 products listed and CVS Health has 892. I need a comparison chart in any format (Excel or Word) that addresses: 1.) how many brand name products are under Medline. List then out. 2.) how many brand name products are under CVS Health. List them out. 3.) how many Medline specific products are under Medline. List them out. 4.) how many CVS branded products are under CVS Health. List them out. 5.) Which products does CVS health have that Medline does not? (Ex: reading glasses) 6.) Which products does Medline have that CVS Healt...
I am looking for a skilled and experienced Excel expert to create a detailed and comprehensive Excel spreadsheet which will serve as a trucking business operational tracker. Key Information to Include: - Revenue: Primarily from freight charges. - Expenses: comprising of fuel, maintenance, office expenses and rent. - Profit Margins: Determine the profit margins by deducing expenses from revenue. - Mileage and Fuel Costs: Tracking to determine efficiency and cost-effectiveness. Frequency: - The ideal candidate should create a sheet easy to update on a daily basis. Ideal Skills & Experience: - Proficiency in Excel - Astute attention to detail - Experience with financial and operational data tracking - Knowledge or experience in the trucking industry would be a ...
I am in need of an expert in Excel to create a system for managing my financial and inventory operations. With your specialized skills, I require a streamlined and seamless workflow for my business that includes the following: Accounting: - Managing both income and expenses in a clear and concise manner Invoicing: - Capabilities to create invoices directly within the sheet - Functionality for generating these invoices in a PDF format - A reliable system to track invoice payments Inventory Management: - A method to effectively track stock levels - A simple way to generate purchase orders as needed - A solution for generating sales reports for analysis The freelancer best suited for this project would have an extensive background in Excel, with a special focus on financial ...
بالمرفقات أنا بحاجة إلى شخص يمكنه إجراء بعض العمليات البسيطة على ملف Excel الحالي الخاص بي. تشمل المهام ما يلي: - تنظيم البيانات وتصنيفها - إضافة الصيغ والحسابات - اجرائات اخرى
...the species observed. Sighting areas: The system allows users to record the sighting area where the different bird species have been observed. Data analysis: The system should allow users to analyze sightings data, generating graphs showing the frequency of sightings of different species in different geographic areas. Data export: The system allows exporting bird sighting data either in PDF or EXCEL files. Administration of users and permissions: The system allows the administration of users and access permissions, to ensure that only authorized users can access the information stored in the system. Bird sounds: The system has an API that displays the sounds of the birds that have been registered in the system. These requirements can be modified according to the client's n...
Necesito construir un dashboard dinámico en excel para análisis de información
Hi Kelvin Writer, I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Explore, Roll out and Implementation :- FMS - Flowchart Management System PMS - Product Management System Query Formula, Filter, Sort, Import range Google sheet Checklist Google Form Form mule Form ranger, Delegation Sheet
I require immediate assistance for a web scraping into Excel task. This project focuses on the extraction of complete tables from different websites. Requirements: - Have expertise in web scraping and excel. - Be able to deliver completed work ASAP. Ideal Skills: - Proficiency in tools or programming languages for web scraping. - Strong command of Excel and data wrangling. - Demonstrated punctuality and adherence to deadlines. This is a time-sensitive task, requiring both speed and accuracy. Please, only serious and dedicated freelancers should consider this project. Job Description: There are 2 sets of tables, Soccer and Basketball for my analysis during my free time. 1. The links are in the spreadsheet highlighted in yellow. The script must also be easy to un...
Ge...regresión tipo probit o algun modelo prospuesto por el analista con las variables datos demográficos con la productividad, la permanencia, las asistencias, la puntualidad, las horas trabajadas y el salario para obtener un perfil laboral del trabajador que mejor se ajuste a la empresa. Perfil del cargo: • Profesional con estudios de estadistica o certificación en analisis de datos • Conocimientos Excel, Power BI o Tableu , BBDD y semantica. • Experiencia en análisis de datos Funciones: • Analizar datos y confeccionar dashboard con semantica. • Establecer manejo de bases de datos y su optimización. • Regresión lineal o modelos para obtener analitica fiable. • Integración y qwerty ...
I need help developing a risk assessment in Excel for my clients. I had one developed for an Ergonomics assessment, now I need to amend this to include additional fields and scoring for Quickchangeover (QC). I need an expert to create a new worksheet, formulas, macros, etc. Review the attached Ergo assessment so you can see what was developed previously and what I need (directionally) the QC assessment to move toward. Are you interested? Read the ReadMe file and look at the docs. thank you.
I'm in need of an expert in Excel to create a spreadsheet that will automate data entry, perform calculations, and generate reports. The complexity isn't clear yet, as I'm unsure how many different tasks will need to be automated. The suitable candidate should have: - Proficiency in Excel, including advanced features - Experience with automation within Excel - A good understanding of data entry, calculations, and report generation I'm open to a dialogue to specify the details further. On the first tab in Excel, I'd like to have all the individual contributors. Then have a tab after that for each individual to show their trends over the months. Anything over 95 is considered good and below 95 would be not good. There are 15 contributo...
There is an excel file to modify according special rules
...Someone who can combine data from other files, and websites, and connect it into one spreadsheet. Key requirements: - Website image scraping - Combine data of external websites with existing spreadsheets / excel csv files. - Data scrape images from external websites, and copy url to match the google spreadsheet lines - Download mass URL of these images into a separate accessible folder for future management. Potentially around 50,000 lines of data to manage and enter. Ideal Skills: - Google Spreadsheets - Data Organization - Image uploading and management - Web form integration - Excel We will provide as much data as possible. your job is to enter it in. Most of the database is in English, some of the entry is in Japanese. some example of websites we will work wi...
...harness the power of Azure Databricks, Azure Data Lake Storage, Copilot, and Azure Data Factory. This project will also use Azure Kubernetes to ensure that the analytics processes are scalable. The main goal is to augment our standard business processes and make them more effective by leveraging these technologies. The data to be analyzed is structured and originates from various sources like Excel, CSV, SQL, etc. Ideal skills for this project include: - Proficient in AI analytics with a solid understanding of data analysis, predictive modeling, and natural language processing. - Experience with Azure Databricks, Azure Data Factory, and Azure Data Lake storage. - Knowledge and experience in working with structured data. - Familiarity with ML and the Copilot tool. - Experience...
More details: What type of data do you need to convert? Text data What is the desired output format for the converted text data? Excel spreadsheet Do you require any specific data manipulation or analysis within the Excel spreadsheet? Data sorting and filtering
I have an Excel sheet that contains text data and I need it to be parsed. I am looking for a Python expert who can use pandas to extract the text data and present it neatly in a new Excel sheet. Key requirements: - Extracting text data from an Excel sheet using Python pandas - Presenting the extracted text data in a new Excel sheet - Sorting and filtering the extracted text data as per business requirements Ideal Skills: - Excellent knowledge of Python, especially pandas - Proficiency in working with Excel sheets - Experience in sorting and filtering text data - Strong attention to detail and commitment to quality
I am seeking an experienced and creative fashion designer who specializes in men's clothing, specifically focused on trendy casual wear. Your responsibilities and qualifications would ideally inclu...Excellent verbal and visual communication skills to effectively convey design concepts and ideas. 8. Time Management: Capable of working under tight deadlines and managing multiple projects simultaneously. 9. Fashion Education: A degree or diploma in fashion design or a related field is preferred, but not mandatory. 10. Passion for Fashion: A genuine passion for fashion and a drive to innovate and excel in the industry. Please apply with your resume, portfolio, and a cover letter highlighting your relevant experience and why you would be a great fit for Verve Clothing's bot...
...budget for the upcoming year. This will encompass the following elements: Key Requirements: - Extract and organise data from a PDF P&L statement - Formulate an Excel-based budget plan for the upcoming year including Revenue, Expenditure, and Cost of Goods Sold - Base projection data on the historical records from the P&L statement - Breakdown of expenditure must be category-wise - Incorporation of a pie chart visualising the budget details Considering the urgency of this project, I require the final product within the next 12 hours. Ideal Skills: - Excellent understanding of financial document analysis - Proficiency in using Excel including complex formulas, calculations and data visualisation - Proven ability in formulating budget plans - Exceptional attent...
