Encerrado

Analyze and Summarize CSV data files into reports

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: [url removed, login to view] 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

Habilidades: PHP

Ver mais: work home philadelphia, work home denver, state coins value, software ag, min range, min coin, max morgan, city denver, max p, vg, vf, vba e, summarize, philadelphia, morgan, grading, field reporting, ef, denver, data min, data collecting, d silver, d coin, csv data, cc program

Acerca do Empregador:
( 26 comentários ) United States

ID do Projeto: #2962152

44 freelancers estão ofertando em média $60 para este trabalho

PSSPL2000

See private message.

$297.5 USD in 30 dias
(50 Comentários)
7.6
finecodervw

See private message.

$63.75 USD in 30 dias
(171 Comentários)
6.4
vw252751vw

See private message.

$85 USD in 30 dias
(22 Comentários)
5.8
ekam

See private message.

$51 USD in 30 dias
(110 Comentários)
5.7
themasta

See private message.

$127.5 USD in 30 dias
(155 Comentários)
5.4
maticot

See private message.

$85 USD in 30 dias
(18 Comentários)
5.2
DeanMan

See private message.

$59.5 USD in 30 dias
(68 Comentários)
5.2
alcarom

See private message.

$80.75 USD in 30 dias
(22 Comentários)
5.1
edifus

See private message.

$68 USD in 30 dias
(28 Comentários)
5.0
timk98

See private message.

$21.25 USD in 30 dias
(54 Comentários)
4.7
thornmastr

See private message.

$50.15 USD in 30 dias
(5 Comentários)
4.1
AlexThunder

See private message.

$63.75 USD in 30 dias
(3 Comentários)
3.7
remmieazavedo

See private message.

$17 USD in 30 dias
(21 Comentários)
3.6
arcan08

See private message.

$21.25 USD in 30 dias
(28 Comentários)
3.4
captainjoe

See private message.

$85 USD in 30 dias
(13 Comentários)
3.4
stanislavza

See private message.

$34 USD in 30 dias
(19 Comentários)
3.3
Successcodes

See private message.

$34 USD in 30 dias
(12 Comentários)
3.2
vw905182vw

See private message.

$25.5 USD in 30 dias
(9 Comentários)
3.2
rolandanderson

See private message.

$85 USD in 30 dias
(5 Comentários)
3.2
sixi

See private message.

$33.99 USD in 30 dias
(11 Comentários)
2.7