Issue 38: Excel format problems
Project Member Reported by gzoli71, Jan 17, 2013
1. Sometimes the prices contains "on request", sometimes "onrequest". According to specification it should be "onrequest".
2. Sometimes the unit of measure column contains "ribs", sometimes "rib". According to the specification it should be "rib".
3. The "cut cost" column should contain 0 or 1 for items that belong to config3. Now the zeros are missing in many cases.

Pitch is missing from the following items:
Empty pitch, configType=4, family=V-BELT CONTRAFOR (Z, A, B, C), profile=Z, pitch=, width=, uom=m, unitPrice=32.593838401451
Empty pitch, configType=4, family=V-BELT CONTRAFOR (Z, A, B, C), profile=A, pitch=, width=, uom=m, unitPrice=38.669802873817
Empty pitch, configType=4, family=V-BELT CONTRAFOR (Z, A, B, C), profile=B, pitch=, width=, uom=m, unitPrice=52.092275114014
Empty pitch, configType=4, family=V-BELT CONTRAFOR (Z, A, B, C), profile=C, pitch=, width=, uom=m, unitPrice=74.383391149279
Empty pitch, configType=4, family=V-BELT CONTRAFOR (Z, A, B, C), profile=Z, pitch=, width=, uom=PCE, unitPrice=4.981536089145
Empty pitch, configType=4, family=V-BELT CONTRAFOR (Z, A, B, C), profile=A, pitch=, width=, uom=PCE, unitPrice=4.981536089145
Empty pitch, configType=4, family=V-BELT CONTRAFOR (Z, A, B, C), profile=B, pitch=, width=, uom=PCE, unitPrice=5.4595622795175
Empty pitch, configType=4, family=V-BELT CONTRAFOR (Z, A, B, C), profile=C, pitch=, width=, uom=PCE, unitPrice=5.9250088333012 
Jan 17, 2013
Project Member #1 gzoli71
I have uploaded the total list. The errors_20130117.txt contains everything.
errors_20130117.txt
204 KB   View   Download
Jan 22, 2013
Project Member #2 tam...@gmail.com
Excel version 130122 contains the following corrections:

- contrafor will be handled by config 1 where the data detailed above will not miss. 
- every 'on request' has been corrected to 'onrequest'
- every 'rib' has been corrected to 'ribs'
- every 'cutcost' coloumn has been filled in config 3
Status: Fixed
Labels: -ExcelVersion-20130115 ExcelVersion-20130122
Feb 12, 2013
Project Member #3 tam...@gmail.com
(No comment was entered for this change.)
Status: Verified