Spreadsheet: 51105d1250678180-vlookup-returning-incorrect-result-carls
Sheet: Amarr Component Production

AntiMatter Reactor |  | Per Run @ perfect ME | Cost @ Perfect ME | ME Costs You | Mineral usage @ ME | Cost @ ME |  |  | Total Requirements: | Total Cost
 | Crystalline Carbonide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Fermionic Condesates | 1 | 94972.71 | 0.1 | 1 | 94972.71 |  |  | 1000 | 94972710
BP ME Level | Fernite Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
0 | Ferrogel | 1 | 66898.07 | 0.1 | 1 | 66898.07 |  |  | 1000 | 66898070.00000001
Number to Build | Fullerides | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
1000 | Hypersynaptic Fibres | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Wastage Factor | Nanotransistors | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
10 | Phenolic Composites | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Tungsten Carbide | 8 | 318.72 | 0.8 | 9 | 358.5600000000001 |  |  | 9000 | 358560.0000000001 | Saving
 |  | Total Cost/Unit | 162189.5 |  | Total Cost/Unit | 162229.34 |  |  | Total Cost/All Units | 162229340 | 9269.649999999965
EMP Pulse Gen |  | Per Run @ perfect ME | Cost @ Perfect ME | ME Costs You | Mineral usage @ ME | Cost @ ME |  |  | Total Requirements: | Total Cost
 | Crystalline Carbonide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Fermionic Condesates | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
BP ME Level | Fernite Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
0 | Ferrogel | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Number to Build | Fullerides | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
1000 | Hypersynaptic Fibres | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Wastage Factor | Nanotransistors | 2 | 1259.04 | 0.2 | 2 | 1259.04 |  |  | 2000 | 1259040
10 | Phenolic Composites | 6 | 3184.26 | 0.6 | 7 | 3714.97 |  |  | 7000 | 3714970
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Tungsten Carbide | 20 | 796.8000000000001 | 2 | 22 | 876.48 |  |  | 22000 | 876480 | Saving
 |  | Total Cost/Unit | 5240.1 |  | Total Cost/Unit | 5850.49 |  |  | Total Cost/All Units | 5850490 | 133.5100000000002
Fusion Thruster |  | Per Run @ perfect ME | Cost @ Perfect ME | ME Costs You | Mineral usage @ ME | Cost @ ME |  |  | Total Requirements: | Total Cost
 | Crystalline Carbonide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Fermionic Condesates | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
BP ME Level | Fernite Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
0 | Ferrogel | 1 | 66898.07 | 0.1 | 1 | 66898.07 |  |  | 1000 | 66898070.00000001
Number to Build | Fullerides | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
1000 | Hypersynaptic Fibres | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Wastage Factor | Nanotransistors | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
10 | Phenolic Composites | 3 | 1592.13 | 0.3 | 3 | 1592.13 |  |  | 3000 | 1592130
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Tungsten Carbide | 12 | 478.08 | 1.2 | 13 | 517.9200000000001 |  |  | 13000 | 517920.0000000001 | Saving
 |  | Total Cost/Unit | 68968.28000000001 |  | Total Cost/Unit | 69008.12000000001 |  |  | Total Cost/All Units | 69008120 | 1491.37999999999
Laser Focusing |  | Per Run @ perfect ME | Cost @ Perfect ME | ME Costs You | Mineral usage @ ME | Cost @ ME |  |  | Total Requirements: | Total Cost
 | Crystalline Carbonide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Fermionic Condesates | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
BP ME Level | Fernite Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
0 | Ferrogel | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Number to Build | Fullerides | 10 | 2077.4 | 1 | 11 | 2285.14 |  |  | 11000 | 2285140
1000 | Hypersynaptic Fibres | 1 | 13393.19 | 0.1 | 1 | 13393.19 |  |  | 1000 | 13393190
Wastage Factor | Nanotransistors | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
10 | Phenolic Composites | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Tungsten Carbide | 28 | 1115.52 | 2.8 | 31 | 1235.04 |  |  | 31000 | 1235040 | Saving
 |  | Total Cost/Unit | 16586.11 |  | Total Cost/Unit | 16913.37 |  |  | Total Cost/All Units | 16913370 | 4778.379999999997
Linear Shield |  | Per Run @ perfect ME | Cost @ Perfect ME | ME Costs You | Mineral usage @ ME | Cost @ ME |  |  | Total Requirements: | Total Cost
 | Crystalline Carbonide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Fermionic Condesates | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
BP ME Level | Fernite Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
0 | Ferrogel | 1 | 66898.07 | 0.1 | 1 | 66898.07 |  |  | 1000 | 66898070.00000001
Number to Build | Fullerides | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
1000 | Hypersynaptic Fibres | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Wastage Factor | Nanotransistors | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
10 | Phenolic Composites | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Sylramic Fibers | 8 | 723.2 | 0.8 | 9 | 813.6 |  |  | 9000 | 813600
 | Titanium Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Tungsten Carbide | 20 | 796.8000000000001 | 2 | 22 | 876.48 |  |  | 22000 | 876480 | Saving
 |  | Total Cost/Unit | 68418.07 |  | Total Cost/Unit | 68588.15000000001 |  |  | Total Cost/All Units | 68588150 | 5144.109999999986
Nanoelectrical Micro |  | Per Run @ perfect ME | Cost @ Perfect ME | ME Costs You | Mineral usage @ ME | Cost @ ME |  |  | Total Requirements: | Total Cost
 | Crystalline Carbonide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Fermionic Condesates | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
BP ME Level | Fernite Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
0 | Ferrogel | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Number to Build | Fullerides | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
1000 | Hypersynaptic Fibres | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Wastage Factor | Nanotransistors | 5 | 3147.6 | 0.5 | 6 | 3777.12 |  |  | 6000 | 3777120
10 | Phenolic Composites | 1 | 530.71 | 0.1 | 1 | 530.71 |  |  | 1000 | 530710
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Tungsten Carbide | 12 | 478.08 | 1.2 | 13 | 517.9200000000001 |  |  | 13000 | 517920.0000000001 | Saving
 |  | Total Cost/Unit | 4156.39 |  | Total Cost/Unit | 4825.75 |  |  | Total Cost/All Units | 4825750 | 2479.12
[NAME] |  | Per Run @ perfect ME | Cost @ Perfect ME | ME Costs You | Mineral usage @ ME | Cost @ ME |  |  | Total Requirements: | Total Cost
 | Crystalline Carbonide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Fermionic Condesates | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
BP ME Level | Fernite Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
0 | Ferrogel | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Number to Build | Fullerides | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
1000 | Hypersynaptic Fibres | 2 | 26786.38 | 0.2 | 2 | 26786.38 |  |  | 2000 | 26786380
Wastage Factor | Nanotransistors | 1 | 629.52 | 0.1 | 1 | 629.52 |  |  | 1000 | 629520
10 | Phenolic Composites | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Tungsten Carbide | 20 | 796.8000000000001 | 2 | 22 | 876.48 |  |  | 22000 | 876480 | Saving
 |  | Total Cost/Unit | 28212.7 |  | Total Cost/Unit | 28292.38 |  |  | Total Cost/All Units | 28292380 | 2706.579999999998
Tesseract Capacitor |  | Per Run @ perfect ME | Cost @ Perfect ME | ME Costs You | Mineral usage @ ME | Cost @ ME |  |  | Total Requirements: | Total Cost
 | Crystalline Carbonide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Fermionic Condesates | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
BP ME Level | Fernite Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
0 | Ferrogel | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Number to Build | Fullerides | 15 | 3116.1 | 1.5 | 17 | 3531.58 |  |  | 17000 | 3531580
1000 | Hypersynaptic Fibres | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Wastage Factor | Nanotransistors | 1 | 629.52 | 0.1 | 1 | 629.52 |  |  | 1000 | 629520
10 | Phenolic Composites | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Tungsten Carbide | 24 | 956.1600000000001 | 2.4 | 26 | 1035.84 |  |  | 26000 | 1035840 | Saving
 |  | Total Cost/Unit | 4701.780000000001 |  | Total Cost/Unit | 5196.940000000001 |  |  | Total Cost/All Units | 5196940 | 2289.32
Tungsten Carbide |  | Per Run @ perfect ME | Cost @ Perfect ME | ME Costs You | Mineral usage @ ME | Cost @ ME |  |  | Total Requirements: | Total Cost
 | Crystalline Carbonide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Fermionic Condesates | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
BP ME Level | Fernite Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
0 | Ferrogel | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Number to Build | Fullerides | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
1000 | Hypersynaptic Fibres | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Wastage Factor | Nanotransistors | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
10 | Phenolic Composites | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Sylramic Fibers | 30 | 2712 | 3 | 33 | 2983.2 |  |  | 33000 | 2983200
 | Titanium Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Tungsten Carbide | 40 | 1593.6 | 4 | 44 | 1752.96 |  |  | 44000 | 1752960 | Saving
 |  | Total Cost/Unit | 4305.6 |  | Total Cost/Unit | 4736.16 |  |  | Total Cost/All Units | 4736160 | -156.2600000000002