Create excel table, inflate sold prices with UK inflation rate
- or -
Post a project like this1291
£40(approx. $50)
- Posted:
- Proposals: 10
- Remote
- #3017791
- Awarded
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
MS Excel, SPSS, AMOS, R, STATA, Power BI, Tableau - Data Analyst, research and insights and Creative Writing
Islamabad
PPH TOP Website & App Developer✮LOGO & Graphic Designer✮Content Writer✮Translator
Dubai
Experienced Graphics designer |Experienced WordPress Full Stack|SharePoint Expert|Data Entry Team |flyer/business card/Brochure||2DAnimation||Photoshop work|
Islamabad
Data Mining |Data Collection| Web Researcher| WordPress Posting| Data Scraping |PDF Convert
Thakurgaon
1788290111412814488011497060171196422748042359825279924530411674807719
Description
Experience Level: Entry
I have a spreadsheet with 200,000 rows of data.
They contain auction sale prices from 1999 to 2020.
The data has been scrapped and placed in a single column seperated by semi colons.
The cell contains the auction item;; the price achieved;; the date of the auction;; the date the data was retrieved.
I need this data to be moved into 4 seperate cells and then a formula added to the sheet to allow each of these prices to be inflated to todays value based on inflationary rate on each year up to todays date.
The sale prices are from 1999 to 2018.
The inflation rates must be accurate and your source for the percentage used clearly explained.
This should be a relatively simple task for someone with relatively good understanding of excel and economic data. Please only apply if you are familiar.
They contain auction sale prices from 1999 to 2020.
The data has been scrapped and placed in a single column seperated by semi colons.
The cell contains the auction item;; the price achieved;; the date of the auction;; the date the data was retrieved.
I need this data to be moved into 4 seperate cells and then a formula added to the sheet to allow each of these prices to be inflated to todays value based on inflationary rate on each year up to todays date.
The sale prices are from 1999 to 2018.
The inflation rates must be accurate and your source for the percentage used clearly explained.
This should be a relatively simple task for someone with relatively good understanding of excel and economic data. Please only apply if you are familiar.
Hugh S.
100% (23)Projects Completed
23
Freelancers worked with
18
Projects awarded
15%
Last project
10 Feb 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
can you send me the excel file please?
948743
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies