Manipulate a set of spreadsheets - Create a roll up master spreadsheet with aggregate data
$30-250 USD
Paid on delivery
Background: We have approximately 60 separate excel files that contain approximately 50 tabs each. Each tab contains the same columns but different row data. Some files contain similar row data but not identical. The data relates to retail locations and the price of a product on a given date. Each tab on the file is a different state within the USA.
The Desire/Intended Outcome:
• Have a place/tab that calculates the past trend data for each row, on each tab, to allow us to see the median and mean price that was offered for this product, at each ‘location’ over the history of our data. Have the same data calculate the median and mean pricing over the most recent 12 weeks of data, the most recent 26 weeks of data, and the most recent 52 weeks of data.
• Add data each week when new pricing comes out, and have that data ‘recalculate’ the mean and median pricing trend as listed above. Some simple method to paste or merge files to allow the new data to be imported into the master spreadsheet that contains the calculations and graphs.
• Have a line graph that shows the past 12 months of pricing data for any location, by clicking that location from a drop down to allow for the line graph to be displayed, and then printed.
• A version that allows us to print on one page the 12,26, and 52 week data trends for any one location.
All of this should be done in Excel, not in another program. We should be able to drop in/paste in the latest weeks data to allow for the data to update
A sample version of one of the 60 spreadsheet files is attached. Please see all of the tabs on the sample file.
Project ID: #17013533
About the project
Awarded to:
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Ex More
38 freelancers are bidding on average $183 for this job
Hi there..... Warm Greetings We came along with your request for Manipulate a set of spreadsheets and we reviewed your project description. We'd like to help you with confidence and satisfying results... We ha More
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
I am an excel expert and have completed many complicated excel related tasks. Can provide you sample if required of my past and current work. Read the project specs. Looks like this project is feasible. Just want to un More
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
Hello there, I can try to optimise it. I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.
Hi there. My name is Daniel and I would be glad to help you out. I appreciate the details of the project description. I can guarantee an excellent job and deliver as soon as possible. Do you need this steps to run inde More
Hi, I have checked details of your project and your requirements. So, you want a master excel file which will import data from all your 60+ files and from new files. Will do different calculations on them and will d More
Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
Dear Hiring Manager , Thank you for posting your job opening for Data Entry. I have four years of data entry experience and I have performed all of the duties listed in your job description that I assure. My data e More
Dear Sir, I have gone through the project requirements and willing to do it as per your requirements. I am an excel professional having hands on expertise in data analysis and management. I will do your project by d More
I'm ready for the project, it will be done withing the stipulated time you want it, i can also work over time to get it done, your job completion is my satisfaction
Hi, I am more interested to complete this project as soon as possible for you. as i have 10 years of experience in spreadsheet and automation and visual analytics. Happy to discuss further. Thanks, Pralay
