Suoritettu

Manipulate a set of spreadsheets - Create a roll up master spreadsheet with aggregate data

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.

Taidot: tietojenkäsittely, Excel, Excel Macros, Excel VBA

Näytä lisää: merge excel worksheets into one master worksheet, copy data from multiple worksheets into one vba, combine multiple excel sheets into one sheet, how to pull data from multiple worksheets in excel, macro to pull data from multiple excel sheets, consolidate data from multiple worksheets in a single worksheet vba, how to copy data from multiple sheets to one sheet in excel, combine multiple worksheets into one using vba, create spreadsheet website data, create letter excel spreadsheet, create form excel spreadsheet, create roll online, tutorial create intranet master page sharepoint, create roll menu flash, create quality master page website aspnet, create time management spreadsheet, create web master tool script dns, create sharepoint master template, vbnet set folder create date, create css master page aspnet

Tietoa työnantajasta:
( 2 arvostelua ) Fort Lauderdale, United States

Projektin tunnus: #17013533

Myönnetty käyttäjälle:

jaylancer43

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 Lisää

$250 USD 4 päivässä
(591 Arvostelua)
0.0

42 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$155 USD 3 päivässä
(0 arvostelua)
0.0
abgdin22

i have experience in create formula for excel and matlab coding. and have free times to do this project and deliver to you on time.

$244 USD 3 päivässä
(0 arvostelua)
0.0
avidusman

Hello, I am a professional with a good experience of more than a decade in the filed of accounts and finance. I have built strong skills in excel and have created many complex worksheets using formulas, macros et Lisää

$250 USD 3 päivässä
(12 arvostelua)
0.0
KulfiSoftwares

I love excel, and have done several projects to create summary sheets, like the way you want.. ZERO ERROR GUARANTEED!! Please read my 350+ reviews. I am here to impress you with my work. https://freelancer.com/u/kul Lisää

$250 USD 5 päivässä
(254 arvostelua)
0.0
dexbay

A proposal has not yet been provided

$1111 USD 5 päivässä
(0 arvostelua)
0.0
mbouzagaoui

Projet should be with à BI software Like power query with excel. Very simple to updateand with out formula.

$155 USD 2 päivässä
(0 arvostelua)
0.0
BZGWI

Perfect projet forthe BI software as power query included with excel. With this qddon on excel, you can update pricing when you're updating thé data.

$155 USD 2 päivässä
(0 arvostelua)
0.0
P0L

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.

$200 USD 5 päivässä
(277 arvostelua)
0.0
humayoonsheikh4u

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 Lisää

$338 USD 5 päivässä
(10 arvostelua)
0.0
ponnarasiBabu

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 Lisää

$211 USD 7 päivässä
(178 arvostelua)
0.0
schoudhary1553

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 Lisää

$180 USD 3 päivässä
(264 arvostelua)
0.0
sanvels123

EXECUTIVE SUMMARY Extensive experience in data analysis, health information system, medical coding, and statistics CORE COMPETENCIES ‎●Data Analyst ‎●Statistician‎ ‎●Medical Coder (ICD-10)‎ ‎ ●Techni Lisää

$155 USD 3 päivässä
(0 arvostelua)
0.0
alxalexfs

Hello, to carry out this project you need someone with analytical qualities who at the same time is an expert in Excel and VBA programming. I am that person. Let's talk about the details. Do not look any further. Lisää

$50 USD 7 päivässä
(1 arvostelu)
0.0
katilinas

Greetings, I'm ready to work on roll up master spreadsheet with aggregate data project. Relevant Skills Excel, VBA Milestones 106 USD - project requirements done and delivered 106 USD - last milestone after full ch Lisää

$213 USD 4 päivässä
(118 arvostelua)
0.0
wjjwxy

I have about 20 years experiences on Excel and VBA, I will design this project to be beautiful, robust, and user friendly. Thank you!

$111 USD 3 päivässä
(0 arvostelua)
0.0
shanecatts13

A proposal has not yet been provided

$166 USD 5 päivässä
(0 arvostelua)
0.0
dpune

A proposal has not yet been provided

$150 USD 5 päivässä
(124 arvostelua)
0.0
elqueabandona

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

$200 USD 5 päivässä
(205 arvostelua)
0.0
adrianaangaritam

I have 5 years of experience doing excel jobs in spreadsheets with the databases of a company that handle more than 200,000 different products. There are two ways to do the work: 1. Create an excel sheet and connec Lisää

$105 USD 3 päivässä
(1 arvostelu)
0.0
aminw

HI, I went through your requirement, and understood that you are basically trying to consolidate your data, to a unified excel sheet, which you can slice n dice based on time-frames/location/master ID etc, besi Lisää

$500 USD 5 päivässä
(6 arvostelua)
0.0