I have a price list for Virtual Servers components with various line items and differnet pricing for year 1 to year 5. 2019 will be in year 1 pricing, 2020 in year 2 etc..
I will need to calculate the costs for a server for the next five year based on the components I selecet. The list will be for up to 20 servers to configure and each would possibly have a different start and end date. As well I will need to define in percentage the use of the server (e.g. Sever 1 = 100%, Server 2 = 80%). By defining the usage % several of the cost components will need to be adjusted, other will keep staying at 100%.
As a result I will need a sofiticated Pivot Table where I can check the consolidated and on line items for all servers.
20 freelancer đang chào giá trung bình $383 cho công việc này
Hi I've seen the 3 images attached. Do you need spreadsheet to send quotations to clients or it's for your internal calculations only? Please send me reply via chat. Thanks Khurram
Hello, I can build the calculator you want as i have advanced excel skills and over 8 years in the field. Please check my portfolio to see my work. Thanks!
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]