Analyze and Summarize CSV data files into reports

Closed Posted Aug 10, 2003 Paid on delivery
Closed 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

PHP

Project ID: #2962152

About the project

43 proposals Remote project Active Sep 23, 2003

43 freelancers are bidding on average $61 for this job

PSSPL2000

See private message.

$297.5 USD in 30 days
(50 Reviews)
7.6
ekam

See private message.

$51 USD in 30 days
(109 Reviews)
5.7
finecodervw

See private message.

$63.75 USD in 30 days
(138 Reviews)
6.1
DeanMan

See private message.

$59.5 USD in 30 days
(67 Reviews)
5.2
vw252751vw

See private message.

$85 USD in 30 days
(22 Reviews)
5.8
themasta

See private message.

$127.5 USD in 30 days
(153 Reviews)
5.4
maticot

See private message.

$85 USD in 30 days
(18 Reviews)
5.2
edifus

See private message.

$68 USD in 30 days
(28 Reviews)
5.0
alcarom

See private message.

$80.75 USD in 30 days
(20 Reviews)
5.1
timk98

See private message.

$21.25 USD in 30 days
(54 Reviews)
4.7
thornmastr

See private message.

$50.15 USD in 30 days
(5 Reviews)
4.1
AlexThunder

See private message.

$63.75 USD in 30 days
(3 Reviews)
3.7
remmieazavedo

See private message.

$17 USD in 30 days
(21 Reviews)
3.6
captainjoe

See private message.

$85 USD in 30 days
(13 Reviews)
3.4
arcan08

See private message.

$21.25 USD in 30 days
(28 Reviews)
3.4
Successcodes

See private message.

$34 USD in 30 days
(12 Reviews)
3.2
vw905182vw

See private message.

$25.5 USD in 30 days
(9 Reviews)
3.2
stanislavza

See private message.

$34 USD in 30 days
(19 Reviews)
3.3
rolandanderson

See private message.

$85 USD in 30 days
(5 Reviews)
3.2
michaelwagnervw

See private message.

$85 USD in 30 days
(8 Reviews)
2.6