| Line 159... |
Line 159... |
| 159 |
sheet.write(0, 4, "Brand", heading_xf)
|
159 |
sheet.write(0, 4, "Brand", heading_xf)
|
| 160 |
sheet.write(0, 5, "Model Name", heading_xf)
|
160 |
sheet.write(0, 5, "Model Name", heading_xf)
|
| 161 |
sheet.write(0, 6, "Model Number", heading_xf)
|
161 |
sheet.write(0, 6, "Model Number", heading_xf)
|
| 162 |
sheet.write(0, 7, "Color", heading_xf)
|
162 |
sheet.write(0, 7, "Color", heading_xf)
|
| 163 |
sheet.write(0, 8, "Weight", heading_xf)
|
163 |
sheet.write(0, 8, "Weight", heading_xf)
|
| 164 |
sheet.write(0, 9, "Courier Cost")
|
164 |
sheet.write(0, 9, "Courier Cost", heading_xf)
|
| 165 |
sheet.write(0, 10, "Risky", heading_xf)
|
165 |
sheet.write(0, 10, "Risky", heading_xf)
|
| 166 |
sheet.write(0, 11, "Our SP", heading_xf)
|
166 |
sheet.write(0, 11, "Our SP", heading_xf)
|
| 167 |
sheet.write(0, 12, "Our TP", heading_xf)
|
167 |
sheet.write(0, 12, "Our TP", heading_xf)
|
| 168 |
sheet.write(0, 13, "Our Offer Price", heading_xf)
|
168 |
sheet.write(0, 13, "Our Offer Price", heading_xf)
|
| 169 |
sheet.write(0, 14, "Our Rank", heading_xf)
|
169 |
sheet.write(0, 14, "Our Rank", heading_xf)
|
| Line 235... |
Line 235... |
| 235 |
sheet.write(sheet_iterator, 4, one_line.brand)
|
235 |
sheet.write(sheet_iterator, 4, one_line.brand)
|
| 236 |
sheet.write(sheet_iterator, 5, one_line.model_name)
|
236 |
sheet.write(sheet_iterator, 5, one_line.model_name)
|
| 237 |
sheet.write(sheet_iterator, 6, one_line.model_number)
|
237 |
sheet.write(sheet_iterator, 6, one_line.model_number)
|
| 238 |
sheet.write(sheet_iterator, 7, one_line.color)
|
238 |
sheet.write(sheet_iterator, 7, one_line.color)
|
| 239 |
sheet.write(sheet_iterator, 8, one_line.weight)
|
239 |
sheet.write(sheet_iterator, 8, one_line.weight)
|
| 240 |
sheet.write(sheet_iterator, 9, courierCost)
|
240 |
sheet.write(sheet_iterator, 9, round(courierCost))
|
| 241 |
sheet.write(sheet_iterator, 10, one_line.risky)
|
241 |
sheet.write(sheet_iterator, 10, one_line.risky)
|
| 242 |
sheet.write(sheet_iterator, 11, supc_data.ourSp)
|
242 |
sheet.write(sheet_iterator, 11, supc_data.ourSp)
|
| 243 |
sheet.write(sheet_iterator, 12, round(supc_data.ourSp*0.9597-courierCost))
|
243 |
sheet.write(sheet_iterator, 12, round(supc_data.ourSp*0.9597-courierCost))
|
| 244 |
sheet.write(sheet_iterator, 13, supc_data.ourOfferPrice)
|
244 |
sheet.write(sheet_iterator, 13, supc_data.ourOfferPrice)
|
| 245 |
sheet.write(sheet_iterator, 14, supc_data.rank)
|
245 |
sheet.write(sheet_iterator, 14, supc_data.rank)
|
| Line 364... |
Line 364... |
| 364 |
sheet.write(i, 4, one_line.brand)
|
364 |
sheet.write(i, 4, one_line.brand)
|
| 365 |
sheet.write(i, 5, one_line.model_name)
|
365 |
sheet.write(i, 5, one_line.model_name)
|
| 366 |
sheet.write(i, 6, one_line.model_number)
|
366 |
sheet.write(i, 6, one_line.model_number)
|
| 367 |
sheet.write(i, 7, one_line.color)
|
367 |
sheet.write(i, 7, one_line.color)
|
| 368 |
sheet.write(i, 8, one_line.weight)
|
368 |
sheet.write(i, 8, one_line.weight)
|
| 369 |
sheet.write(i, 9, courierCost)
|
369 |
sheet.write(i, 9, round(courierCost))
|
| 370 |
sheet.write(i, 10, one_line.risky)
|
370 |
sheet.write(i, 10, one_line.risky)
|
| 371 |
sheet.write(i, 11, supc_data.ourSp)
|
371 |
sheet.write(i, 11, supc_data.ourSp)
|
| 372 |
sheet.write(i, 12, round(supc_data.ourSp*0.9597-courierCost))
|
372 |
sheet.write(i, 12, round(supc_data.ourSp*0.9597-courierCost))
|
| 373 |
sheet.write(i, 13, supc_data.ourOfferPrice)
|
373 |
sheet.write(i, 13, supc_data.ourOfferPrice)
|
| 374 |
sheet.write(i, 14, supc_data.rank)
|
374 |
sheet.write(i, 14, supc_data.rank)
|
| Line 471... |
Line 471... |
| 471 |
sheet.write(sheet_iterator, 4, one_line.brand)
|
471 |
sheet.write(sheet_iterator, 4, one_line.brand)
|
| 472 |
sheet.write(sheet_iterator, 5, one_line.model_name)
|
472 |
sheet.write(sheet_iterator, 5, one_line.model_name)
|
| 473 |
sheet.write(sheet_iterator, 6, one_line.model_number)
|
473 |
sheet.write(sheet_iterator, 6, one_line.model_number)
|
| 474 |
sheet.write(sheet_iterator, 7, one_line.color)
|
474 |
sheet.write(sheet_iterator, 7, one_line.color)
|
| 475 |
sheet.write(sheet_iterator, 8, one_line.weight)
|
475 |
sheet.write(sheet_iterator, 8, one_line.weight)
|
| 476 |
sheet.write(sheet_iterator, 9, courierCost)
|
476 |
sheet.write(sheet_iterator, 9, round(courierCost))
|
| 477 |
sheet.write(sheet_iterator, 10, one_line.risky)
|
477 |
sheet.write(sheet_iterator, 10, one_line.risky)
|
| 478 |
sheet.write(sheet_iterator, 11, supc_data.ourSp)
|
478 |
sheet.write(sheet_iterator, 11, supc_data.ourSp)
|
| 479 |
sheet.write(sheet_iterator, 12, round(supc_data.ourSp*0.9597-courierCost))
|
479 |
sheet.write(sheet_iterator, 12, round(supc_data.ourSp*0.9597-courierCost))
|
| 480 |
sheet.write(sheet_iterator, 13, supc_data.ourOfferPrice)
|
480 |
sheet.write(sheet_iterator, 13, supc_data.ourOfferPrice)
|
| 481 |
sheet.write(sheet_iterator, 14, supc_data.rank)
|
481 |
sheet.write(sheet_iterator, 14, supc_data.rank)
|
| Line 590... |
Line 590... |
| 590 |
sheet.write(sheet_iterator, 4, one_line.brand)
|
590 |
sheet.write(sheet_iterator, 4, one_line.brand)
|
| 591 |
sheet.write(sheet_iterator, 5, one_line.model_name)
|
591 |
sheet.write(sheet_iterator, 5, one_line.model_name)
|
| 592 |
sheet.write(sheet_iterator, 6, one_line.model_number)
|
592 |
sheet.write(sheet_iterator, 6, one_line.model_number)
|
| 593 |
sheet.write(sheet_iterator, 7, one_line.color)
|
593 |
sheet.write(sheet_iterator, 7, one_line.color)
|
| 594 |
sheet.write(sheet_iterator, 8, one_line.weight)
|
594 |
sheet.write(sheet_iterator, 8, one_line.weight)
|
| 595 |
sheet.write(sheet_iterator, 9, courierCost)
|
595 |
sheet.write(sheet_iterator, 9, round(courierCost))
|
| 596 |
sheet.write(sheet_iterator, 10, one_line.risky)
|
596 |
sheet.write(sheet_iterator, 10, one_line.risky)
|
| 597 |
sheet.write(sheet_iterator, 11, supc_data.ourSp)
|
597 |
sheet.write(sheet_iterator, 11, supc_data.ourSp)
|
| 598 |
sheet.write(sheet_iterator, 12, '-')
|
598 |
sheet.write(sheet_iterator, 12, '-')
|
| 599 |
sheet.write(sheet_iterator, 13, supc_data.ourOfferPrice)
|
599 |
sheet.write(sheet_iterator, 13, supc_data.ourOfferPrice)
|
| 600 |
sheet.write(sheet_iterator, 14, supc_data.rank)
|
600 |
sheet.write(sheet_iterator, 14, supc_data.rank)
|