Analyze and Summarize CSV data files into reports
$30-100 USD
Paid on delivery
We receive many comma delimited files containing sales prices of rare coins. The records include the date, mint, coin condition, sales price, etc. of the sales. We would like software code (preferably Excel, with or without VBA) to parse the data into categories (year/mint/etc) and then summarize according to those categories. The individual records will need some parsing to eliminate extraneous characters. Summary to include min/max/avg price/etc with quantities sold. We are looking for a nice report presentation. sample file is attached>>> The desired characterisics to sort by noted in parantheses: (coin type) (date) (mint) (grade) (sold status) (selling price for sold coins) (asking price for unsold coins) This file only contains data for 1889 (date) Morgan Dollar Silver dollars (coin type). The date & coin type will be part of the CSV file (i.e. 1889 Morgan Silver) The other info is found in the description field. Note the extraneous characters in the description field. (grade) here is a link to the various coin grades: [login to view URL] ABOUT GOOD (AG) GOOD (G) VERY GOOD (VG) FINE (F) VERY FINE (VF) EXTREMELY FINE (EF OR XF) ABOUT UNCIRCULATED (AU) MINT STATE (UNCIRCULATED OR MS) MS grade can range from 60 - 70 so, MS60, MS61....MS70 the extra characters (e.g. VF++, VF* should be discarded, in this case VF is all that matters) (mint) Three mints are used: Philadelphia (P), Carson City (CC) and Denver (D) (sold status) sold or unsold (selling price) $ value if coin sold Then for the reporting side: A comparison report for each Year & Coin type with sold (min price/avg price/max price), % sold, unsold (asking price) So, the entire set of data files would include a file for 1888 Morgan Dollars, 1887 Morgan.... 1871 Morgans, etc. What we would like is an analysis report for each of the data files. Thanks
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows based PC running XP home version
Project ID: #2962152