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

완료 등록 시간: 5년 전 착불
완료 착불

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.

데이터 처리 엑셀 Excel Macros Excel VBA

프로젝트 ID: #17013533

프로젝트 소개

38 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 5년 전

수상자:

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 기타

$250 USD (4일 이내)
(758건의 리뷰)
8.5

이 일자리에 대한 프리랜서 38 명의 평균 입찰가: $183

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 기타

$180 USD (3일 이내)
(347 리뷰)
8.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일 이내)
(370 리뷰)
7.5
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 기타

$211 USD (7일 이내)
(205 리뷰)
7.1
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일 이내)
(245 리뷰)
7.0
dvcontact

Hi, You won’t select the right candidate without knowing what your project on conducting data analysis in Excel based on your intended outcome will look like. Fortunately, I can complete a part of your job before you 기타

$150 USD (3일 이내)
(60 리뷰)
6.5
avinav606lx

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

$250 USD (3일 이내)
(167 리뷰)
6.5
periyannas

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.

$250 USD (5일 이내)
(122 리뷰)
6.5
DanielVizcaya91

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 기타

$199 USD (3일 이내)
(100 리뷰)
6.9
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 기타

$213 USD (4일 이내)
(121 리뷰)
6.5
TechnoGuruu

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 기타

$155 USD (3일 이내)
(88 리뷰)
6.1
dpune

A proposal has not yet been provided

$150 USD (5일 이내)
(124 리뷰)
6.3
gr8tech

Hello I am available to help extract the relevant statistics from your Excel files. I am proficient in VBA and scripting with Python to provide the required data analysis and charts. I will provide a single point for 기타

$166 USD (5일 이내)
(41 리뷰)
5.4
renesontiongson

Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$200 USD (3일 이내)
(73 리뷰)
5.5
abhaymshr091

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 기타

$100 USD (10일 이내)
(27 리뷰)
4.3
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 기타

$250 USD (3일 이내)
(12 리뷰)
3.8
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 기타

$338 USD (5일 이내)
(12 리뷰)
4.1
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. 기타

$50 USD (7일 이내)
(1 리뷰)
1.6
eyebiokinopeyemi

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

$155 USD (3일 이내)
(1 리뷰)
0.0
pralayjibon

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

$100 USD (1일 이내)
(0 리뷰)
0.0
ankitsharma2892

A proposal has not yet been provided

$127 USD (3일 이내)
(0 리뷰)
0.0