Add formulas and lookup functions to this costing spreadsheet
$30-250 AUD
货到付款
I would like a number of formulas adding to the attached spreadsheet to allow me to track costs of a product, the packaging and the combined costs.
The sheet includes some examples of the INPUT data and should function as follows:
Sheet 1 = PARTS LIST
The user enters the information in columns A to E and column J
The spreadsheet must look for that Part number in the COSTS sheet to calculate the Lowest, Highest, Average and most Recent cost for that line.
The spreadsheet must look in the COSTS sheet for the Box Type to calculate the Lowest, Highest, Average and most Recent cost for that box
The spreadsheet must then add the Part costs, the Other Costs and Box Costs to determine the Packaged cost
Sheet 2 = BOX LIST
The user will enter the details of each box in column A to D
The spreadsheet must look for that box number in the COSTS sheet and determine the lowest, highest, average and most recent cost for that box
Sheet 3 = COSTS
The user will enter the item number (which could be a Part number or box number) and the cost from each invoice. Each time they enter new data it will be to the right of the previous data. So on August 2nd the cost for Box 1 is entered on cell G5 then on September 15th the cost for box 1 is entered in Cell H5
项目ID: #31588404
关于项目
授予:
有42名威客正在参与此工作的竞标,均价$103/小时
Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power 更多
Hi, I am an Excel expert. I would love to create formulas for the attached spreadsheet to track costs of a product, the packaging and the combined costs. You can check my reviews and repeat hire rate for quality of wor 更多
Hello, I'm CA Finalist from Institute of Chartered Accountants of India ( Top recognised body in accounting and finance department ) apart from that I have undergone 3 years of extenisve training in one of the best man 更多
Hey! I've carefully checked your requirements and really interested in this project Add formulas and lookup functions to this costing spreadsheet. I'm a full-time data and statistical analyst. I have worked with many 更多
Hello, I can help you to Add formulas and lookup functions to this costing spreadsheet I have more than 5 years of experience in excel. I have gone through your job posting and become very much interested to work wi 更多
Hi, I have excellent experience in Excel, data preprocessing, Pivot Table and Charts. I have made many projects in excel including data analysis using functions and pivot table and charts And I'm looking forward to wor 更多
Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. All clients call me "Prince of Excel". I promise I wil 更多
Hi, How are you today? Thank you for posting this project, and I'm very happy to bid your project. I've read carefully your project details. I have a tons of experience in Excel, Excel VBA, Visual Basic, Data Processi 更多
Hi, Hope you are keeping well. I have read your requirements. They seem very clear to me. The task should be completed in 2-3 days however I have kept a testing buffer. I am an expert in Bespoke Excel modelling and r 更多
Dear Client, I am an excel expert with more than 5 years daily hands-on experience and I would like like to express my interest to help you with this project. I will provide you with the best results that will give yo 更多
I am a professional data entry expert with knowledge of MS Word and MS Excel. I can do research on the web of any kind. I promise, Quality, Typing, Scrapping Data Entry work. I can assure you of High-Quality Assignment 更多
Dear Employer! I have a plenty of experiences in programming of C++, C#, VB, VBA, EXCEL, ACCESS, x86/x64 Assembler, etc. I read carefully the demands of your project. Please send details of project, I will start the 更多
I'm expert in Microsoft office which means excel included . i can do it easily even though I'm a student . my excel skills are good for this job . looking forward to this.
*** Expertise in Excel | VBA | Power BI | R *** Hi, I have 10 years of experience in Business Intelligence and have expertise in wide array of application like Excel, VBA, Power BI, Spotfire, SQL, R, Python, HTML, Js. 更多
I can do your work with accuracy and given time.. I'm expert in Excel... I hope if you give this project to me you will be happy with my work and it would be grateful for me to do this work for you.. Thankyou
Hello Dear Sir! Presently i read your order request completly and opened the attached Excel 3-Sheets Data. I completely caught what is your requirement and desire. I have an experience of 12 years of working on MS Exc 更多
Hi, sir/maam, I am Ankit chauhan from india, I am here to provide you the best service on the standard price. so you can get an idea about my work. Regards, Ankit Chauhan
I am a Computer Science Engg. and have expertise with the typing. I have gone through your requirement and I have the typing speed of 79wpm with great amount of accuracy. I can deliver quality work to you in tight dead 更多