I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is ...
I need an online store data extraction specialist to pull key information (product name, price, and barcode number) from a particular online store. - The extracted data should be delivered in an Excel spreadsheet. - This is a one-time task; there is no need for continuous extraction. It's essential that you're proficient in web scraping techniques, able to navigate through the store's pages, and extract the right data accurately. Experience with online store data extraction is preferable. Please indicate any relevant past projects in your bid. Looking forward to working with a pro who can deliver quality results efficiently.
I'm looking for a talented freelancer to build a custom table that can accurately determine partners' collection and payout within our dental practice. This table should be flexible enough to allow for the substitution of various numbers, which in turn reconfigures the other numbers in the table. Key Components: - The table will need to calculate individual doctors' collections and revenue based on specified variables - Additionally, the table will need to factor in: - The predetermined variables for calculating individual doctors' collections and revenue - Management fees - The table will also need to consider the partner's percentage ownership for each partner in the practi...
I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.
I need an Excel expert to perform a specific data analysis task for me. - The job involves conducting an analysis where two cells are fed values from 1-100. - The task is to find the highest value in a third cell, based on the values of the first two cells. - The values in the two initial cells should be generated using a combination of user input and random generation. Ideal skills and experience for this job include: - Proficiency in advanced Excel functions, particularly those related to data analysis and cell value calculations. - Experience with probability, permutation, and combination would be a plus. - A strong understanding of statistical analysis and data interpretation. This project would be perfect for someone who is d...
Please see .pdf file for full explanation. I am seeking a skilled developer to create a sophisticated online booking form. This form will require the unique capability to calculate distances between both residential and business addresses. Key Features: - The form should consider distances with traffic considerations, hence requiring a level of accuracy beyond simple point-to-point measurements. - It should also be intelligent enough to accommodate multiple non-consecutive destination inputs. Ideal Skills: - Strong understanding of geolocation APIs for accurate distance calculation. - Prior experience in designing intelligent online booking forms. - Proficiency in UX design to ensure user-friendly interactions. - Understanding of...
I'm looking for a proficient individual with an established user base to test my productivity app on Android. Your role will be to download the app, have your 20 ready users test its performance and usability, and then leave a review on the app store. Key Responsibilities: - Immediate availability of 20 users for testing - Performance testing of the productivity app - Writing a good review on the app store Your feedback should focus mainly on the app's performance, functionality, and overall usability. I need 20 users to test it before its public release as per android. the review should be good for the company.
I'm looking for an Executive Assistant to handle a minimum of 10 to a maximum of 20 hours per week. The main tasks will include: - Email and Correspondence Management: Be responsible in managing my emails, filtering important ones and responding to them accordingly. - Personal organization: This requires you to assist me with daily tasks that optimize my time and productivity. - Customer Care: You'll have to occasionally interact with our coaching clients ensuring their experience is satisfactory. An ideal candidate must possess excellent communication skills, have experience in admin roles, and be well organized. A background in customer service would be an advantage as you'll be dealing with our coachin...
As discussed, bird netting calculator editable pdf & xls conversion with formulas from excel, next button and submit.
...on poles of varying height. These are difficult to measure accurately so we need a measurement verification program where we can input the perimeter measurements of the shape, the pole heights and the diagonals. The program needs to mathematically check the entered measurements and indicate the % of error and which measurement(S) are most likely incorrect. There are two parts to the project: 1. A JavaScript or similar program created to run in an ecommerce website which has a product configurator interface which will be used to input the measurements. The interface will be built by another supplier. 2. A stand-alone app able to run on Android, iOS and Windows PC. ADDITIONAL INFO The minimum measurements that are needed to...
**** IMPORTANT **** - Do Not Autobid - I am ready to hire somebody within 48 hours - You should not bid less than 180 days of work for this project - Projects that bid less than 180 days will be ignored - Read the entire project description. There is certain text I am looking for in order for your bid to be considered. If your bid does not have this text, the bid will be ignored - I am not looking to redefine the project terms written in this description. If you are looking to rewrite the project description, do not bid on this one. - The bid on this project should be $2,500 USD. Twenty-one milestones are to be created. Read below for more details. I want to rank in the top three google results on average for the following key...
I'm seeking a Python expert with a focus on code generation. Key Skills and Experience: - Extensive experience in Python - Automation and code generation expertise - Demonstrable background in improving code quality - Ability to streamline repetitive tasks - Strong understanding of enhancing productivity through coding Please provide examples of your past work and demonstrate your experience in code generation.
I'm looking for an expert in creating comprehensive trading spreadsheets. This task requires not only solid experience in spreadsheet creation but also a deep understanding of cryptocurrency trading. Key Requirements: - Real-time data updates: The spreadsheet should allow for live updates of cryptocurrency trading data. - Performance tracking: It should have features to track trading performance over specified time periods. - Profit/loss calculation: It should be equipped with formulas to calculate profits or losses accurately. - Automatic multi-spreadsheet referencing: It needs to be able to link data across multiple spreadsheets automatically. The created spreadsheet should support all available cryptocurrencies, therefore a broad...
...for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating...
I am looking for an expert to guide me through my upcoming SHL Numerical Reasoning Assessment. The current level of my understanding falls under the 'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experience for this task would be: - Strong knowledge and experience in SHL assessments, especially Numerical Reasoning - Excellent in teaching Problem Solving strategies - Proven track record of coaching intermediate level candidates Your guiding hand will help me excel in this assessment. Please submit your bid if these requirements align with your skills.
I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior ...
... I require assistance in streamlining these reporting processes to optimize the use of my data, improve efficiency, and determine profitability. Specifically, my current reports draw from spreadsheet files that need to be effectively manipulated and interpreted to gain actionable insights. I'm looking for a freelancer who can provide solutions to automate: - Data Extraction: Extract data from spreadsheet files and ensure it is prepared for analysis. - Data Analysis: Analyse the extracted data to determine information of relevance and note patterns, trends or anomalies. Freelancers bidding on this project should have the following: - Strong data analysis skills with a keen eye for detail - Proficiency with Excel and similar sprea...
I'm in need of an experienced expert who can help set up my Office 365 software to perform the key functions of my business. With this tool, I aim to better my business operations and increase productivity. The selected freelancer will need to: - Implement Office 365 software for a team size of 1-10. - Ensure smooth functionality for email and communication service. - Arrange document storage and sharing capabilities. - Effectively set up collaboration and project management tools. - Enable Teams calling setup for seamless communication. Ideal skills and experience for this job include deep understanding of Office 365, its setup and functionalities, and proven experience in integrating such a tool for businesses. An understanding of small ...
I need assistance with formatting an MS Word document that has been converted from PDF. The document contains some unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames from the document - Amend specific sections of the main body text - Optionally, transfer the figures in the document into Excel Ideal skills for this project include: - Proficiency in MS Word and Excel - Experience in document formatting and editing - Attention to detail for accurate text amendments - Optional: Experience in data transfer to Excel
...seeking an experienced environmental analyst to calculate the carbon footprint of our facility located in Pensacola, Florida. This is a client's requirement to secure new business. Key tasks will include: - Gathering comprehensive data on our facility, as we haven't done so yet. Areas to cover are energy consumption, waste generation, and water usage. - Using the data to quantify the overall carbon footprint. - Preparing an easy-to-understand report on the findings. The ideal freelancer should have a strong background in environmental science or a related field, Green House Gasses (GHG) and have experience with sustainability assessment, particularly in quantifying carbon footprints. Knowledge in environme...
I want to rank in the top three google results on average for the following keyword phrases Target Country is USA 1 - Accident Lawyers 2 - Truck Accident Lawyers 3 - Car Accident Lawyers 4 - Boat Accident Lawyers 5 - Construction Accident Lawyers 6 - Lyft Accident Lawyers 7 - Uber Accident Lawyers 8 - Pool Accident Lawyers 9 - Personal Injury Lawyers 10 - Motor Vehicle Accident Lawyers 11 - Personal Injury Lawyer Near Me 12 - Lawyer For Car Accident 13 - Personal Accident Lawyer 14 - Car Lawyer Accident 15 - Attorney Personal Injury Near Me 16 - Accident Lawyers Car 17 - Personal Injury Lawyer Attorney 18 - Car Accident Attorney Lawyer 19 - Accident Lawyer Near Me 20 - Lawyer For Auto Accident This is for the website The ranking must hold for 3 months before
Project Deliverables: 1. Complete research paper manuscript in accordance with JAN guidelines. 2. Data sheet such as MS Excel or SPSS etc. Payment schedule: Complete payment transfer after the manuscript is received and checked by the client. P.S. The revisions proposed by JAN will be incorporated even after the payment release or project completion.
I'm seeking a professional who can make an Excel page from a word document and then make it auto organize for our department. This job requires an ability to create a code to organize and automatically count values in certain columns. The code should be designed to recognize and count based on column values. Unfortunately, I'm uncertain about which specific columns should be counted; clarification will be needed later. Key skills would be proficiency in Excel, programming, and an eye for design. Experience in data organization and tracking is a must.
...an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time repor...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
...knowledgeable employee management trainer to assist in improving the performance of a group of less than 50 employees. Key Requirements: - Proven Experience: I need someone who has a solid background in training and coaching. Previous experience in HR would be advantageous. - Understanding of HR Practices: A good grasp of human resources practices is essential to design and deliver effective training sessions. - Effective Communication: Strong communication skills are key to ensure the training message is delivered effectively to the employees. Your main task will be to work with me to design and execute a training program aimed at enhancing the performance of my team. This is a great opportunity to make a tangible...
As the project owner, I am looking for a talented individual who can handle two crucial tasks in Excel: 1. Adding advanced functionality with IF, VLOOKUP, and INDEX MATCH formulas. 2. Implementing conditional formatting. To be successful in this project, you should have: • Proficiency in Excel's advanced functions and calculations • Experience with customizing Excel using conditional formatting • Attention to detail and the ability to execute tasks accurately. Your primary task will be to help me improve Excel's current functionality by implementing the advanced functions mentioned and customizing my Excel using conditional formatting. Your deep understanding of Excel will be...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting ...
...what I needed. Please do not respond with an auto-reply as those bids will be ignored. Here is specifically what I need help with: I currently have a database setup in Airtable. It has all the data that I need for my dashboard inside. But special formulas will be needed to calculate certain aspects of the dashboard. Example: I receive a total of 4 individual payments from a vendor. I initially receive 3 of the 4 payments a week after the sale, but I don't receive the 4th payment until ~a month later. Each payment is a separate row in Airtable, but the grouped payments all use the same SAN#. Therefore, I need Airtable to think, "Okay, I've received the $120, $70, and $35/$45 payment for SAN# 12345, but I haven't received the...
Looking for a savvy surveyor who can get to the crux of the ready mix concrete market in Varanasi, India immediately. I need an in-depth study on: - Current market size & its growth trends - Rival firms & their market share Key requirements include: - Compile a detailed report, covering your analysis & proposing actionable strategies. - Provide raw data in Excel or CSV format in addition to the report. Prior experience in market surveying and a knowledge of the construction industry are big pluses. Your ability to work fast while maintaining accuracy is paramount. Let's revolutionize the Varanasi concrete market, one data point at a time!
I need help with simple copying and pasting tasks from online directories. The data needs to be organized by category. The primary task includes: - Copying data from various online directories - Pasting the data into an Excel/CSV file - Organizing the data by categories Ideal skills: - Excellent attention to detail - Proficiency in data entry and Excel/CSV - Understanding of data categorization The task is straightforward and doesn't require any complex skills. I am looking for someone who can deliver accurate results in a timely fashion.
Preciso transportar dados de uma pesquisa do google formulário para gráficos gerados em Excel, para serem adicionados em trabalho acadêmico.
I have excel table with project tasks by dates start and end and duration. I want to change it to project table. Preferred microsoft format.
I urgently need a professional who can input textual data onto an Excel sheet in a visually appealing and easy-to-understand way. Key Responsibilities: - Representing textual data in a clean and organized manner within an Excel sheet. Ideal Candidates Should Have: - Proficiency in Excel, particularly in handling and presenting textual data. - Strong attention to detail, ensuring that all data is correctly input. - Ability to work quickly and efficiently, as the project has a tight deadline. If you have experience with data representation and can work fast, please apply.
...seeking an expert in Excel who can help me with three key areas. Tasks include: - Data entry: I have an Excel spreadsheet with around 100-1000 rows and columns that require data input. - Data analysis: Extracting meaningful insights and patterns from the data provided. - Spreadsheet formatting: Ensuring the data is presented in a clear, professional manner which is easy to interpret. Specific functions and formulas required include: - Basic operations like Sum, Average, and Count. - Conditional formatting, to highlight key data points. - Pivot Tables, to present the data in a clear and organized manner. The ideal candidate should have a strong track record in data handling, analysis, and visualization using Excel...
I need an expert in web scraping, either in Python or by utilizing Google Chrome extension, to extract text data from a particular website. Should be delivered within 3 hours. The scraping is a one-time task, not requiring routine updates, and the extracted data needs to be saved in an Excel file (or CSV). This will be hidden behind a login wall - so I suggest that the Python script will go to the website and then wait one minute, where I will manually log in. Ideal Skills and Experiences: - Proficiency in Python for web scraping - Experience with scraping text specifically - Ability to deliver the required output in a CSV format
I require the expertise of a skilled data scraper who can quickly retrieve text data from a specified website. The site in question is I need the following specific information delivered in Microsoft Excel Format: - Country Name - Grand Lodge Name - Website address - Email address - Phone - Address - Grand Master name (if available) The ideal freelancer for this project would have significant experience in data scraping, particularly text data, and an understanding of the website's structure to retrieve the desired information effectively. Speed and efficiency are of the essence. Your ability to deliver this project promptly without compromising accuracy will win you this bid.
To give you a brief idea the data you are dealing with is for recipe ingredients and I need nutrition info for all those ingredients from USDA. I'm seeking a Python expert who can give me 100% accurate "mapped" data without duplicates or missing information. YOU WILL BE REQUIRED TO WRITE/SEARCH NEW script to modify my data in Excel sheets - I have 3 Excel files having a total of 50000 rows, These are ingredients from recipes, I need you to do the following tasks - (A) - Assign a new ingredient ID number to all non-duplicate Ingredients. (B) - Replace "Name of ingredients" with the newly assigned number in the whole file (C) - For all ingredients - search, get the FDC ID from USDA Food Central and sav...
I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel r...
...Document search and retrieval system. - System for managing user access and permissions. - Upload feature should support PDF and DOC files as well as PNG and JPEG image files. - Security will be based on JWT Ideal candidates would be experienced in JavaScript, NodeJS, and knowledgeable in file handling and user permissions. Experience in developing similar document management systems would be a big plus. Your work will contribute to enhancing productivity and organization within our team. Please ensure your bid includes relevant experiences and how you would approach this project....
...Applied Financial Economics, 4(3), 241 247, if you wish to learn about the formula’s motivation. The Rogers-Satchell range based volatility formula is given by � �??(?)=(1 ?) 1 2(∑{ln(?? ?? )ln(?? ?? )−ln(?? ?? )ln(?? ?? )} ? ?=1 ) 1 2 2. (30 marks) The p-th percentile of a set of n observations of a given variable is defined as the observation located in the p(n+1)/100-th ordered position (e.g. the 10th percentile of a variable for which we have 50 observations is located in the 10 (50+1)/100 = 5.1 or the 5-th ordered position). Program a function to calculate the percentiles. 3. (25 marks) The ? coefficient of an asset measures the sensitivity of its rate of return to var...
I'm in need of an experienced freelancer who can effectively perform data entry tasks involving financial data. While the specific type of data has not been specified -- it could range from invoices and expense reports to bank statements -- the chosen professional should exhibit versatility and aptitude in working with various forms of financial data. Key Requirements: - Proficiency in Excel: You'll need to be well-versed in using Excel for data entry tasks. - Background in Finance Data Entry: Experience or relevant knowledge in finance data entry is crucial. This ensures you can deliver accurate results. To apply, offer a detailed approach on how you would tackle this project. Also, provide evi...
...highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you ...
Create a form in Excel following the pre-determined options. The results of the answers must be recorded in a second tab
...resident for tax purposes during the year ended 30 June 2024. In answering this question, if you believe Rebecca is an Australian resident according to the ordinary concepts test, it is not necessary for you to also explain and apply any of the other 3 tests for individual residency (ie domicile test, 183-day rule and superannuation test). 2. Explain whether each of the income items in the table above should be included in Rebecca’s assessable income for the year ended 30 June 2024. 3. Explain whether each of the expense items incurred by Rebecca in the table above are tax deductible for the year ended 30 June 2024. 4. Briefly explain the process required for calculating an individual taxpayer’s net income tax liability or refund....
...tailored to meet the needs of a small sales team, numbering between 1 to 10 users. It includes manufacturing , POS, Payrol, Purchases and Sales etc. A brief about our company. 1. We buy Yarn. 2. We use the yarn to manufacture Fabric. 3. Then the fabrics come to stores. 4. From stores they go to multiple small garments. 5. From the Garments they come back to stores. 6. At stores, we check QC, Ironing, Packing, labeling, etc. 7. From stores they come to Retail shops. 8. From the shop we sell to customers. 9. POS system needed chich includes Discounts and Loyalty point for customers. 10. The POS should be able to input customer details and create accounts for them during purchases. So we can track the sales of each customer...
I intend to streamline the process of document submission and verification in relation to EDPMS entry and BRC, with a focus on customs or trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validation purpose. Key Responsibilities: - Submission and verification of customs or trade-related documents - Verification and correction of any errors found in the documents Experience & Skills: - Experience in the customs or trade sector is essential - Proficient in Excel/CSV - Strong attention to detail and high accuracy in document handling - Previous exposure to EDPMS and BRC is advantageous.
I've already done most of the work in analysing my share trading portfolio, but I need a professional to review and validate my findings, and carry out a few remaining tasks. Key Tasks: - Review Calculation of Total Investments: I've already calculated my total investments, but I need an expert to double-check these calculations. - Capital Gains/Losses Determination: I require assistance in determining the capital gains/losses for each stock in my portfolio including the cost base determination given stock splits. This is the key piece of work. - Comprehensive Review: It's important that you review my analysis comprehensively and suggest corrections or improvements where necessary. - Final Financial Year Analysis: The analysis should cover...
As your assistant for this project, my job will be to type data into an Excel spreadsheet. However, I currently don't have specific information on what type of data (text, numbers, dates) you require. Additionally, I need clarification on whether you have any specific formatting needs for the data and if any calculations or formulas will need to be applied. Ideal Skills: - Proficient in Microsoft Excel - Precise and quick typing ability - Understanding of Excel formulas (just in case) Your prompt response to these questions will help ensure successful completion of your project. Looking forward to working with you!
