This project is based on a REAL-WORLD scenario. A customer gets an updated price sheet from their vendor, Gardner Denver (Links to an external site.). This updated price sheet comes in the form of an Excel spreadsheet with three (3) columns Material (aka part number), Description, Price.

The current software they use for managing their inventory, pricing, quotes, invoices, and other such fun things in business requires that their price update is in the form of a CSV file. But, not just any old CSV file, and not in the current format the pricing sheet comes in. And there are going to be three (3) files. One for the Main warehouse, one for warehouse 00, and one for warehouse 01. The CSV files must meet the following criteria:

1. The three columns that are needed are:
   1. Part number
   2. Cost
   3. Price
2. The file must be comma-delimited
3. The file must NOT contain any quotation marks
4. The numeric fields (Cost and Price) must have two decimal places (with trailing zeros)
5. The cost field is calculated
   • Cost = Price * 0.6
6. Each warehouse file must be separate
   • For the main warehouse, the part number does not change
   • For warehouse 00, you must append -00 to the part number
   • For warehouse 01, you must append -01 to the part number

Here is a sample of the result from each warehouse file.

Main Warehouse

00001143 SP,136.41,227.35 00001223 SP,48.66,81.10 00001236 SP,149.72,249.53 0001-0003-00,100.95,168.25 00015172 W,85.32,142.20

Warehouse-00

00001143 SP-00,136.41,227.35 00001223 SP-00,48.66,81.10 00001236 SP-00,149.72,249.53 0001-0003-00-00,100.95,168.25 00015172 W-00,85.32,142.20

Warehouse-01

00001143 SP-01,136.41,227.35 00001223 SP-01,48.66,81.10 00001236 SP-01,149.72,249.53 0001-0003-00-01,100.95,168.25 00015172 W-01,85.32,142.20