Formulas farenheit celsius kelvin rankin jobs
I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable wi...rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis PEASE REFER TO THE ATTACHED EXCEL FILES WHICH WILL BE USED THE SCOPE FOR THE BID IS IN THE WORD DOCUMENT There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project. THANK YOU FOR THE TIME ...
I'm seeking a proficient Excel user for data entry and analysis. Skills and Experience: - Proficient in Excel with experience in using Pivot tables, Formulas and calculations, Charts and graphs - Attention to detail for accurate data entry - Ability to analyze data and generate reports if needed Please note that the specific type of data and primary goal for this project have not been specified. The successful freelancer will need to be flexible and adaptable to different types of data and tasks.
I'm seeking assistance in improving the organization of my Excel sheet which records staff daily work activities. The primary focus will be on refining the data layout for better clarity and accessibility. I need t...activities. The primary focus will be on refining the data layout for better clarity and accessibility. I need to separate outreach calls vs in-person assistance/community events. I started formula to total based on week and the month. Ideal Skills: - Proficiency in Excel, particularly in data sorting and filtering. - Experience with creating organized data layouts. Although I don't have specific formulas in mind, I would appreciate a professional with knowledge of various Excel functions who can suggest and implement suitable ones to enhance the functio...
...paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - Strong expertise in Excel, especially in creating custom templates. - Experience with mixed opera...
I have an excel sheet consisting of about 5000 lines and about 15 columns. The data is a bit random and requires advanced logic to organize. I have added an explanation video and sample excel data sheet to the files. Due to company restrictions, I can't share the excel sheet directly, but I can provide snapshots and detailed descriptions of the tasks and formulas required. Key Responsibilities: - Utilize advanced Excel formula logic to sort data into specific categories. - Implement conditional calculations, data aggregation, and advanced filtering as per the project needs. Ideal Skills and Experience: - Proficiency in advanced Excel is a must. - Prior experience in data sorting and organization. - Strong analytical skills to understand and apply the required logic.
...the first and last day of each calendar year Correctly calculated annual interest Available credit line at the end of each year Technical Requirements: The spreadsheet must use formulas and/or VBA automation to ensure accurate and dynamic calculations. Must be fully functional on both Windows and Mac versions of Microsoft Excel without compatibility issues. Data should be structured for easy input and updates. The layout should be clear and user-friendly. The solution must handle different loan durations, interest rates, and varying payment schedules. Ideal Candidate: Expertise in Microsoft Excel, including formulas, pivot tables, and VBA (if needed). Strong understanding of financial calculations, especially loan interest computations. Experience ensuring cross-platform c...
I'm seeking an Excel expert proficient in creating complex formulas. The task involves working with financial data. The project is a test for a Financial Planning and Analysis (FP&A) profile, consisting of three questions. The formulas need to generate accurate financial projections.
I'm looking for someone to help me create a financial model in Excel focused on budgeting. The primary task will be filling in the blanks with the appropriate formulas. Ideal Skills: - Proficient in Excel - Experience in financial modeling - Knowledgeable in budgeting processes Please ensure your proposal highlights relevant experience and skills.
...not-for-profit organisations submit an application to seek a capital grant. Within the application, the not-for-profit provides financial information in two parts. An Excel spreadsheet and audited financial statements. This information is used to assess what level of financial contribution the not-for-profit can make from its own resources to fund its capital project. The Excel spreadsheet contains formulas to produce a range of financial ratios from data contained in the spreadsheet. A staff member currently reviews the data integrity in the spreadsheet, financial ratios, and audited financial statements. This process is time-consuming. Whilst there is every attempt to ensure the review process is undertaken consistently from one application to another, there is a de...
Please Sign Up or Login to see details.
I'm seeking a Google Sheets expert to help me update an existing spreadsheet. The task involves adding new features, specifically formulas and calculations, as well as integrating the sheet with other tools. This is not just a simple data entry job, I need someone who can think critically about how to improve the functionality of the sheet. Ideal skills and experience for the job: - Proficient in Google Sheets - Experienced in creating complex formulas - Familiar with integrating Google Sheets with other tools - Able to troubleshoot and fix errors independently - Good understanding of data analysis
...looking for a skilled professional who can convert my existing Excel/Numbers order form into an online order entry system. This project will involve creating both a basic version and a database-driven version of the order form. Key Requirements: - The online order form should be integrated with a custom Order Entry System. - It would need to replicate the tabs on the excel and the basic formulas - It should have the capacity to store customer data, specifically contact information and details pertaining to my business clients and schools. Ideal Skills and Experience: - Proficiency in Excel and Numbers - Experience in developing online order systems - Knowledge of database management - Understanding of customer data storage solutions Please note that the order en...
...structured, and clean layouts ✔ Automated Formulas & Functions – Save time with calculations that work instantly ✔ Financial & Payroll Management – Salary sheets, budgeting, and billing trackers ✔ Data Visualization & Reports – Interactive charts and dashboards for better insights ✔ Custom Excel Templates – Personalized solutions for your business or projects ? My Expertise ? ? Bills & Expense Tracker – Keep track of payments, due dates, and total expenses ? ? Salary Sheet Automation – Payroll calculation with deductions & net salary breakdown ? ? Grade & Performance Sheets – Automated grading systems for schools & colleges ? ? Business Reports & Dashboards – Financial summaries & data-driven ins...
...Gantt chart updates in MS Project. • Two-way synchronization for real-time project status updates. • Task dependencies and resource allocation mapped correctly in MS Project. Additional Requirements • The solution must be professionally designed, user-friendly, and visually appealing. • All templates and dashboards should follow PMI best practices. • The freelancer must ensure error-free formulas, automation, and compatibility across Excel, Power BI, and MS Project. • Provide detailed documentation and a brief training session on how to use the system. Expected Deliverables 1. Excel File with all project management functionalities. 2. Power BI File with fully interactive dashboards. 3. Integration Setup with MS Project. 4. User Guide &...
I'm seeking a freelancer proficient in Google Sheets to design a personalized expense manager for me. Key Requirements: - The first sheet will be where I input my data and it should automatically populate the ...second sheet. - The second sheet needs to summarize my expenses by category. - The third sheet needs to provide graphical interpretations of my expenses as Pie charts, Bar graphs, and Line charts. - The expense manager needs to track specific categories: Food and groceries, Transportation, and Utilities and bills. Ideal Skills and Experience: - Proficient in Google Sheets with advanced skills in formulas and data automation. - Experienced in creating visually appealing and easy-to-understand data presentations. - Knowledgeable about personal finance management and ex...
I'm looking for a freelancer to create an Excel workbook that consolidates data from 7 source sheets into a main sheet. The solution should dynamically update in real-time as the data in the source sheets change. PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING. Key requirements: - Use either Excel formulas or Power Query. VBA and Macros are not allowed. - Summarize totals for each unique combination of columns A-D from the source sheets. Note : data both sheets could go up to 1000 + rows. Deliverables: - A fully functional Excel file where the main sheet updates in real-time. - Clear documentation or a short instructional guide explaining how the solution works. Ideal skills and experience: - Strong Excel skills and expertise in using Power Query. - Good understan...
Enhance an Excel file about real estate investment. I'll highlight entry values in green, correct and insert formulas when needed.
I have an Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dynamic Excel solutions will be highly advantageous.
I'm in search of a proficient Excel specialist to assist with various tasks related to public data and knows how to do formulas ! . Your primary responsibilities will include: - Data Entry: Accurately inputting information into Excel sheets. - Data Analysis: Utilizing Excel's powerful tools to make sense of the data, organize it and seperate it - Report Generation: Creating comprehensive reports based on the data analysis. Key skills and experience required for the job include: - Proficiency in Excel, with a particular focus on data entry, analysis and report generation. - Experience working with public data. - Expertise in generating charts and applying formulas.
I'm in need of a skilled freelance copywriter who can create engaging and reader-focused articles for me. I will provide the topics and I need you to follow my proven article creation formula. Your writing should be friendly and conversational, speaking directly to the reader. Responsibilities: - Write content that is personable and engaging - Adhere to a specific article creation formula fo...- Write content that is personable and engaging - Adhere to a specific article creation formula for consistency and quality - Use Grammarly to ensure all work is error-free and polished Ideal Skills: - Excellent command of English - Experience in copywriting - Familiarity with using Grammarly - Ability to write in a friendly and conversational tone - Ability to follow specific guidelines and ...
I'm looking for an experienced data analyst who excels in working with Excel spreadsheets. Your primary tasks will involve: - Data entry and formatting: I have a substantial amount of data that needs to be inputted and...who excels in working with Excel spreadsheets. Your primary tasks will involve: - Data entry and formatting: I have a substantial amount of data that needs to be inputted and formatted correctly in Excel. - Data analysis: Once the data is properly formatted, you'll be responsible for analyzing it in Excel. The ideal candidate will have: - Proficiency in Excel, including advanced functions and formulas - Strong skills in statistical analysis - Attention to detail to ensure data accuracy - Ability to meet deadlines If you're up for the challenge, I...
I'm in need of a detailed Excel sheet for my company, specifically for the Operations department. This sheet should include various registers and time sheets, all interlinked with formulas for seamless data flow. Key Components: - Invoice Register - Expense Register - Salary Register - Employee Time Sheet - Invoice Incoming - Invoice Outgoing - Outgoing Purchase Order - Purchase Order Incoming (Sales Order) - Apex and Opex Register - Asset List - Billing Forecast - Expense Forecast - Hire Employee List and Salary Register - Payroll Master and ESOB Calculator and Register The project also requires the creation of a single dashboard. The main purpose of this dashboard is to track the financial performance of the company. It should prominently display: - Total revenue and exp...
...formula-heavy and macro-utilizing XLSX file for use on a Mac M3 Sequoia. This project involves ensuring the formulas remain unlocked and adding filters to the spreadsheet. Key Tasks: - Convert the current XLSX file for compatibility with Mac - Ensure all complex formulas and macros are functional and unlocked - Implement filters into the file - Add Pivot tables as per the original file - Apply basic styles and colors for customized formatting Ideal Skills: - Extensive experience with Excel and XLSX files - Proficiency in creating and modifying Pivot tables - Strong understanding of basic Excel formatting - Familiar with Mac M3 Sequoia compatibility issues - Able to unlock formulas and add filters as required This project requires attention to detail and a solid u...
...inter-account transfers are accounted for without duplication. Provide a detailed ledger of categorized transactions for easy reference. Output Requirements: An Excel file with clearly labeled sheets for raw data, matched transfers, unmatched transactions, and categorized summaries. A summary report highlighting key insights and any discrepancies. Skills Required: Advanced proficiency in Excel (including formulas, pivot tables, and lookups). Experience in financial data analysis and reconciliation. Strong attention to detail and ability to work with confidential information. Deliverables: A consolidated and reconciled Excel workbook. A summary report with key findings and recommendations. Additional Information: I will provide the raw transaction data from all accounts and des...
I'm in need of an Excel expert to assist with various financial tasks. This includes: - Creating budget spreadsheets - Analyzing staffing costs - Generating financial reports I will also require some custom Excel formulas to be created. The level of automation needed is basic, primarily using standard formulas. Ideal candidates for this project should have: - Extensive experience with Excel - Proficiency in creating budget spreadsheets and analyzing financial data - Ability to create custom Excel formulas - Basic understanding of automation using Excel formulas
...$50 initial, whoever do quick turnaround I will give them full project. I'm looking for a skilled React developer to create a dashboard for visualizing user analytics in a comprehensive and engaging way. Key Requirements: - Use of React framework to build a responsive and interactive dashboard, Visualization of data through charts and graphs. - Select, upload excel in UI and work all Excel Formulas like Lookups, Aggregates, Database Tables, to display tabular and tiles, widgets - Integration of user demographic and usage pattern data into the dashboard. Requirement is in Two pages, I will share with those you have already worked on the React Dashboards with Excel Integrations. Ideal Skills: - Proven experience in React development, preferably with dashboard creation. ...
I need a 600-page pdf written in Microsoft Excel for record-keeping, specifically for inventory data. The document must include: - Item names and quantities No formulas or complex Excel functions are required. This project is ideal for freelancers with excellent attention to detail and experience in data entry and inventory management.
This looks like a very simple fix, but there will be more work later. Look here to see the device. The home page has a two minute video that will explain what we are doing. The Arduino controls four pumps using PWM by pressing any of 12 keys on a keypad. All "formulas" are timed to shut off automatically. We have added (and it works) the monitoring of BLE beacons so that the MAC address nearest the Platform is identified and the Platform sends a line similar to the following message to Serial Monitor #2502101,10991,5,ff:ff:11:4c:50:d1,99& Serial # of Platform time in seconds since Platform powered up + 10000 MAC address of nearest beacon (They all transmit address,"iTAG" there are 13 spaces behind iTAG, and signal strength That is all we need to det...
I'm looking for an expert Excel specialist who can set up a comprehensive spreadsheet for me. The data I will be inputting is a combination of financial and sales tracking information. Key Requirements: - Design and setup of an Excel spreadsheet tailored to track both financial and sales data. - Incorporation of automatic calculations and formulas to facilitate data processing. - Implementation of data visualization tools within the spreadsheet, such as charts and graphs, to illustrate trends and patterns. Ideal Skills: - Extensive experience with Excel, particularly in setting up complex spreadsheets. - Strong understanding of financial and sales data tracking. - Proficiency in creating automatic calculations and data visualizations in Excel.
I'm looking for an Excel expert to develop a program that calculates various real estate market trends. The program should specifically focus on analyzing general market tendencies. It should be a program that can be used numerous times with different data sets. Key Skills: - Advanced Excel skills: You should be proficient in Excel and able to create complex formulas and functions to analyze the data. - Real estate knowledge: A background or understanding of the real estate market would be a plus as it would help you comprehend what data is relevant and how to interpret. Please provide examples of similar projects you have completed.
I need assistance with an Excel spreadsheet. The project involves data analysis, particularly performing statistical analysis. Ideal Skills: - Proficiency in Excel, particularly with formulas and data analysis tools. - Experience with performing statistical analysis in Excel. - Ability to assist with sorting and filtering data, as well as creating pivot tables.
I'm working on a high school project involving a basic calculation app APK. I need a freelancer to extract the arithmetic operations from the source code and provide them in a plain text document as a step-by-step list of formulas. Ideal Skills: - Proficient in working with APKs and understanding app source code - Excellent written communication skills for clear, concise explanations. The app only performs basic arithmetic operations: When entered inpurts. I need the extracted formulas listed in a simple format.
Need assistance reprograming a machine with an Ecolab chemical dispenser. Just need assistance with setting the formulas for the laundry equipment using the EL6 Win configurator for bandtech sp65
I'm in need of a proficient Excel expert who can design a custom Excel template for tracking my expenses. The main purpose of this template is to help me with financial tracking. Key Requirements: - Design a user-friendly Excel template with a focus on expense tracking - Incorporate built-in calculations or formulas for totals and subtotals Ideal Skills: - Proficient in Microsoft Excel - Experience in creating financial tracking templates - Strong understanding of expense tracking and budgeting Please, submit your proposal if you can assist with this task.
I need assistance with using mathematical formulas in Excel, specifically 'Sum and Average' and 'Index and Match'. Your role will mainly involve data entry and creating charts. Ideal skills and experience for the job: - Proficiency in Microsoft Excel - Experience with data entry and chart creation - Familiarity with mathematical formulas, specifically 'Sum and Average' and 'Index and Match' - Attention to detail and ability to work accurately.
...from selecting options to generating customer-facing documents. - Provide step-by-step guidance tailored to new and experienced sales reps. - Ensure all videos are editable within Google Vids for our team to update as needed. Requirements: - Proven experience in creating instructional or training videos. - Proficiency with Google Sheets and understanding of advanced functions (e.g., formulas, dropdowns). - Familiarity with Google Vids or a willingness to learn and use it. - Ability to break down technical concepts into simple, easy-to-understand steps. Deliverables: - A series of training videos hosted on Google Vids (length and number to be determined). - Editable project files for future modifications by our team. To Apply: Please include the followin...
We need a SME consultant to help us with updating of our SW to add of an electric utility billing system with related features, reports, dash-boards, AI support & tariff, environmental and related factors compensation. The electric power quality data , fuel data from multiple meters is already available on a set frequency basis within our software. The tariff, fuels data, other factors formulas, compensation tables, curves etc. to be used are available and will be shared with short-listed candidates only for a revised fixed price bids. Please supplement your 1st response with the following links (you may need a Microsoft account in some scenarios), else it will be rejected. Thank you for your co-operation & kind
I'm looking for an Excel expert who can assist me with pivot tables and advanced formulas. If you are skilled in creating and customizing pivot tables, using advanced Excel functions like VLOOKUP, INDEX/MATCH, and combining multiple data sources, then you are the freelancer I need. Ideal Skills and Experience: - Proficiency in Excel, particularly with pivot tables and advanced formulas - Experience in creating and customizing pivot tables - Expertise in using advanced Excel functions (e.g., VLOOKUP, INDEX/MATCH) - Ability to combine multiple data sources - Strong attention to detail and organizational skills
I'm looking for an Excel expert to create a training management sheet for me. Features of the Excel sheet should include: - Tracking of employee details - Logging of training topics - Scheduling and recording of training dates The primary use of t...Tracking of employee details - Logging of training topics - Scheduling and recording of training dates The primary use of this Excel sheet will be monitoring progress of employees throughout their training. Therefore, the sheet should be designed in a way that makes it easy to track individual progress and overall training effectiveness. Ideal skills for this job include: - Advanced Excel skills (formulas, pivot tables, data validation) - Experience in creating training or attendance tracking sheets - Understanding of training ...
...the chart. DISPLAY REQUIREMENTS: The information should be displayed at the middle center of the chart. The data should update in real-time as the bar forms. INFORMATION TO DISPLAY OF CURRENTLY FORMING BAR: BID-ASK SPREAD: Display the bid-ask spread. TIME LAG: Display seconds lag. If more than 1 SECOND. ATR14: Display the ATR14 value. BAR TYPE LONG: Categorize the bar type based on provided formulas. HAMMER BAR LONG: If the bar fits the hammer criteria (condition provided), display "YES"; otherwise, display "NO". BIG BAR LONG: If (Close - Low) / ATR14 is greater than 1.8, display "YES"; otherwise, display "NO". BAR SIZE LONG: Display (Close - Low) in points. FOLLOW-UP BAR LONG: If the LOW is higher or equal to the previous bar's LOW...
...an experienced financial analyst who can help prepare a comprehensive Excel workbook that includes all necessary formulas for financial analysis across various aspects of our business. The workbook will cover the following key points: A ) Admin & General Expenses: Separate tracking of admin and general expenses for each of our business divisions, including Real Estate, Contracting, and Hospitality (e.g., hotels, lodges, etc.). B ) Construction Period of Projects: A detailed breakdown of multiple ongoing projects (e.g., City Hotel, Farm Lodge, Mount Lodge, Tourism School, etc.). This should include project timelines, monthly cash inflows and outflows, with all necessary formulas to track and forecast the financials through the construction period. C ) Operating Level...
I'm encountering issues with my MySQL ADX formula which is yielding incorrect values. This formula is being used for trend analysis on sales data. Ideal Skills & Experience: - Extensive experience with MySQL - Proficiency in crafting and troubleshooting ADX formulas - Background in data analysis, specifically sales data - Ability to deliver accurate results in a timely manner.
I'm experiencing issues with the ADX formulas in MySQL. The results I'm getting from the built-in SQL functions are incorrect. Specifically, I'm trying to calculate the directional movement, but the output doesn't align with my expectations. Skills and experience that would be ideal for this job include: - Extensive knowledge of MySQL - Proficiency with SQL's built-in functions - Experience troubleshooting formula-related issues - Understanding of directional movement calculations
I need a skilled Excel professional to clean up the formatting in my Excel document so that "amount" and "total" columns are formatted consistently (centered or justified to right) and ensure that existing formulas in "amount" columns calculate to amounts in "total" columns. Create formula for all "total" amounts to calculate and produce grand total at end of doc. The project involves adding new formulas ensuring that newly inserted data is added to "amount" colum that the numbers will automatically calculate and be added to the totals, similar to the setup at the beginning of the document. When in doubt please ask questions. This is a small project with a deadline of end of day to late evening Sunday, 01/26/25. Key...
...sector. By transitioning from manual Excel-based workflows to an automated system using Power BI and Power Query, the project seeks to improve efficiency, accuracy, and decision-making capabilities. Objectives of Dashboards in Power BI Build interactive dashboards to visualize key trends, traveler preferences, and satisfaction levels. Utilize advanced Power BI features such as DAX formulas and custom indicators to provide meaningful insights. Statistical Indicators Generate descriptive statistical measures (e.g., average, median, and standard deviation) directly within Power BI. Use these measures to establish benchmarks and identify trends. Customized Filters Integrate dynamic filters into the reports, enabling deep dives into data and customized analysis
I have raw data spread across 8 Excel tabs, primarily focused on e...primarily focused on economic analysis. The data encompasses critical economic indicators such as GDP growth, unemployment rates, and inflation rates. I urgently need someone to summarize this data and create a visually appealing, comprehensive dashboard. Key Requirements: - Summarize the data across 8 Excel tabs - Create a detailed, user-friendly dashboard - Utilize various types of charts, formulas, functions, and Pivots as necessary Ideal Skills: - Proficient in Excel, particularly with data analysis and visualization - Experience in economic data analysis - Ability to create aesthetically pleasing and clear dashboards Please note, the timeline for this project is urgent. Your promptness and efficiency will b...
...contract is designed to automate and manage the calculation of direct business incentives in a decentralized and transparent manner on a blockchain network. The contract ensures that every participant receives accurate rewards based on their contribution to the direct business activities. Key Features: Transparent Calculations: Direct business contributions are calculated based on predefined formulas stored on the blockchain. Real-time Updates: Instant computation and distribution of incentives without the need for manual intervention. Immutable Records: All transactions and incentive calculations are permanently recorded on the blockchain, ensuring trust and auditability. Customization: Configurable parameters for percentage rates, thresholds, and conditions to suit various bu...
