We are currently working on a project which requires a range of pricing grids to be entered into a spreadsheet in a particular format and exported as a .csv file.
Each pricing grid is a 2-dimensional grid where the price of the item is based upon the height and width. The pricing grids will be provided as a PDF document which is a scan of a physical price sheet. Each point in the grid will need to be converted into a single line in the spreadsheet file.
For instance, imagine a grid as follows:
Width 100 $10 $20
200 $20 $30
This would need to be entered into the spreadsheet as follows:
Height Width Price
100 100 $10
100 200 $20
200 100 $20
200 200 $30
In total for this stage of the project there are a maximum of 50 separate pricing grids at a maximum size of 30x30. The final number of grids may vary but will not be more than 50. The size of each grid will vary but the largest grid will be 30x30; the smallest grid will be around 10x10.