Spreadsheet: 72603d1273286151-change-currency-formatting-based-on-value-of-another-cell-macro-start
Sheet: OE Profit

MC FOB Price Range(SHIKIRI) | FOB Price | Profit | New Rule from 01/05/08
1-500,000 yen | 122600 | 0.2 | 1-1,000,000 yen
 | 288000 | 0.18
Average |  | 0.19
500,000-1,000,000 | 583000 | 0.18
 | 603600 | 0.15
 | 872600 | 0.15
Average |  | 0.16 | 0.2
1,000,000-3,000,000 | 1021800 | 0.1 | 1,000,000-5,000,000
 | 1101200 | 0.15
 | 1611000 | 0.15
 | 2869200 | 0.1
Average |  | 0.125
3,000,000-5,000,000 | 3508454 | 0.15
 | 4429278 | 0.055
 | 4443660 | 0.025
 | 4494000 | 0.1
 | 4600000 | 0.05
Average |  | 0.07599999999999998 | 0.15
5,000,000-10,000,000 | 7200000 | 0.05 | 5,000,000-10,000,000
 | 9630000 | 0.091
Average |  | 0.07050000000000001 | 0.1
10,000,000-15,000,000 | 11172750 | 0.1 | 10,000,000+
 | 12252500 | 0.12
 | 13000000 | 0.03
Average |  | 0.08333333333333333
Over 15,000,000 | 55575600 | 0.1
 | 65850000 | 0.03
 | 248751667 | 0.01
Average |  | 0.04666666666666667 | 2.5%-5%
 | QTY | Unit Price | Total (MC-MAL) | Profit | MAL FOB Price | CIF Price
Partial Discharge Monitor | 1 |  | 12252500 | 0.12 | 165334.9 | 166448.19
REDUCING VALVE NS503G | 1 | 687600 | 687600 | 0.12
DW NO:S4-68656/ PCV-887
MAIN VALVE/ 98E3046-8 | 2 | 11200 | 22400
PISTON RING/ 98E3046-21 | 4 | 8300 | 33200
DIAPHRAGM/ 98E3046-22 | 2 | 14800 | 29600
GASKET/ 98E3046-36 | 2 | 12900 | 25800
GASKET/ 98E3046-37 | 2 | 12900 | 25800
GASKET/ 98E3046-38 | 2 | 12900 | 25800
GASKET/ 98E3046-39 | 2 | 11200 | 22400
TOTAL |  |  | 872600 | 0.15 | A$12,220 | A$11,806
Vane Sagment Row #1 | 5 | 1200000 | 6000000
Vane Sagment Row #1 | 1 | 1200000 | 1200000
TOTAL |  |  | 7200000 | 0.05 | A$87,906 | A$88,238
Seal(Outer) DW: 09-62053-04 | 2 | 118600 | 237200
Seal(Inner) DW: 09-59263-04 | 2 | 156700 | 313400
Seal(Outer) DW: 09-62053-01 | 2 | 118600 | 237200
Seal(Inner) DW: 09-59263-01 | 2 | 156700 | 313400
TOTAL |  |  | 1101200 | 0.15 | A$14,900 | A$15,095
Netmation Control System | 1 | 65850000 | 65850000 | 0.03 | A$737,250 | A$742,030
New Control system for TEPCO Turbine | 1 | 227856527 | 227856527
Option part | 1 | 20895140 | 20895140
TOTAL |  |  | 248751667 | 0.01 | [NAME]
OPC Server | 1 | 13000000 | 13000000 | 0.03 | A$145,543 | A$147,043
Change of Frequency
Auxiliary relay | 1 | 19600 | 19600
Cabling material | 1 | 78400 | 78400
Relay Tester | 1 | 3508454 | 3508454 | 0.15
Digital Multimeter | 1 | 105294 | 105294
Megger | 1 | 141055 | 141055
Vector Multi Meter | 1 | 141055 | 141055
DC Standard Voltage / Current power supply | 1 | 533420 | 533420
TOTAL |  |  | 4429278 | 0.055
Consumable Parts for TCA Filter Inspection | 1 | 1021800 | 1021800 | 0.1 | A$12,488 | A$12,868
Flexible Connector: 38[NAME] | 6 | 25200 | 151200
Connection Bar | 12 | 37700 | 452400
TOTAL |  |  | 603600 | 0.15 | A$8,262 | A$9,286
[NAME] (Rod) | 1 | 64600 | 64600
[NAME] ([NAME]) | 1 | 58000 | 58000
TOTAL |  |  | 122600 | 0.2 | A$1,650
[NAME] | 1 | 1611000 | 1611000 | 0.15 | A$21,992 | A$22,906
[NAME] | 1 | 4600000 | 4600000 | 0.05 | [NAME] 4,830,000 | [NAME] 4,974,100
Report Fee | 1 | 288000 | 288000 | 0.18 | A$ 3,440
Repair Fee for Standard Combuster Basket | 7 | 642000 | 4494000 | 0.1
Ocer-Speed Device Reset Cable | 1 | 583000 | 583000 | 0.18 | A$ 7,330 | A$ 7,530
Combustor　Basket　（Ignitor） and other parts | N/A | 11172750 | 11172750 | 0.1 | JPY11,628,870 | JPY11,730,070
Combustor comsumable parts unit2 | 1 | 55575600 | 55575600 | 0.1 | [NAME] | [NAME]
[NAME]) | 1 | 4443660 | 4443660 | 0.025 | JPY4,557,600 | JPY4,591,600
Ignitor Rods | 6 | 478200 | 2869200 | 0.1
Combustor Basket Repair | 15 | 642000 | 9630000 | 0.091 |  | 10892000