Alteration to the excel as shown below : (see attached file first 6 are done) - all the alterations need to be done in column aw:
note the change to formula; in that there is no (- ) any more its converted to a (+) , also you have to mirror the previous figure..
see below the first 7 are done correct.
[login to view URL] $12.50|+|12.50|$|||;PBS $12.50|+|12.50|$|||;Concession $5.80|+|5.80|$|||;Safety Net $0.00|+|0.00|$|||
[login to view URL] $69.90|+|69.90|$|||
[login to view URL] $11.00|+|11.00|$|||
[login to view URL] $49.90|+|49.90|$|||;PBS $35.40|+|35.40|$|||;Concession $5.80|+|5.80|$|||;Safety Net $0.00|+|0.00|$|||
[login to view URL] $23.10|+|23.10|$|||;PBS $23.10|+|23.10|$|||;Concession $5.80|+|5.80|$|||;Safety Net $0.00|+|0.00|$|||
[login to view URL] $19.90|+|19.90|$|||;PBS $19.90|+|19.90|$|||;Concession $5.80|+|5.80|$|||;Safety Net $0.00|+|0.00|$|||
[login to view URL] $6.70|+|6.70|$|||;PBS $6.70|+|6.70|$|||;Concession $5.80|+|5.80|$|||;Safety Net $0.00|+|0.00|$|||
[login to view URL] $5.80|+|0.00|$|||;PBS $5.80|+|0.00|$|||;Concession $5.80|-|0.00|$|||;Safety Net $0.00|-|5.80|$|||
[login to view URL] $7.50|+|0.00|$|||;PBS $7.50|+|0.00|$|||;Concession $5.80|-|1.70|$|||;Safety Net $0.00|-|7.50|$|||
[login to view URL] $17.90|+|0.00|$|||
[login to view URL] $184.90|+|0.00|$|||
[login to view URL] $19.80|+|0.00|$|||
[login to view URL] $64.90|+|0.00|$|||
[login to view URL] $21.90|+|0.00|$|||;PBS $21.90|+|0.00|$|||;Concession $5.80|-|16.10|$|||;Safety Net $0.00|-|21.90|$|||
[login to view URL] $9.90|+|0.00|$|||;PBS $9.90|+|0.00|$|||;Concession $5.80|-|4.10|$|||;Safety Net $0.00|-|9.90|$|||
This has to be exact otherwise i cannot up load to product page
thanks