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

[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
4 | 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.04 | 2 | 26786.38 |  |  | 2000 | 26786380
Wastage Factor | Nanotransistors | 1 | 629.52 | 0.02 | 1 | 629.52 |  |  | 1000 | 629520
2 | Phenolic Composites | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 20 | 1439.8 | 0.4 | 20 | 1439.8 |  |  | 20000 | 1439800
 | Tungsten Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | Saving
 |  | Total Cost/Unit | 28855.7 |  | Total Cost/Unit | 28855.7 |  |  | Total Cost/All Units | 28855700 | 1034.649999999998
Graviton Pulse |  | 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
4 | 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.04 | 2 | 1259.04 |  |  | 2000 | 1259040
2 | Phenolic Composites | 6 | 3184.26 | 0.12 | 6 | 3184.26 |  |  | 6000 | 3184260
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 20 | 1439.8 | 0.4 | 20 | 1439.8 |  |  | 20000 | 1439800
 | Tungsten Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | Saving
 |  | Total Cost/Unit | 5883.1 |  | Total Cost/Unit | 5883.1 |  |  | Total Cost/All Units | 5883100 | 1008.759999999999
Graviton 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.05 | 1 | 94972.71 |  |  | 1000 | 94972710
BP ME Level | Fernite Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
1 | Ferrogel | 1 | 66898.07 | 0.05 | 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
5 | Phenolic Composites | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 8 | 575.92 | 0.4 | 8 | 575.92 |  |  | 8000 | 575920
 | Tungsten Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | Saving
 |  | Total Cost/Unit | 162446.7 |  | Total Cost/Unit | 162446.7 |  |  | Total Cost/All Units | 162446700 | 6952.28999999995
Magpulse 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
2 | Ferrogel | 1 | 66898.07 | 0.03333333333333333 | 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
3.333333333333333 | Phenolic Composites | 3 | 1592.13 | 0.1 | 3 | 1592.13 |  |  | 3000 | 1592130
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 12 | 863.8799999999999 | 0.4 | 12 | 863.8799999999999 |  |  | 12000 | 863879.9999999999
 | Tungsten Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | Saving
 |  | Total Cost/Unit | 69354.08000000002 |  | Total Cost/Unit | 69354.08000000002 |  |  | Total Cost/All Units | 69354080 | 2623.87999999999
Quantum 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
2 | 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.1666666666666667 | 5 | 3147.6 |  |  | 5000 | 3147600
3.333333333333333 | Phenolic Composites | 1 | 530.71 | 0.03333333333333333 | 1 | 530.71 |  |  | 1000 | 530710
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 12 | 863.8799999999999 | 0.4 | 12 | 863.8799999999999 |  |  | 12000 | 863879.9999999999
 | Tungsten Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | Saving
 |  | Total Cost/Unit | 4542.19 |  | Total Cost/Unit | 4542.19 |  |  | Total Cost/All Units | 4542190 | 1857.780000000001
[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
4 | Ferrogel | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Number to Build | Fullerides | 15 | 3116.1 | 0.3 | 15 | 3116.1 |  |  | 15000 | 3116100
1000 | Hypersynaptic Fibres | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Wastage Factor | Nanotransistors | 1 | 629.52 | 0.02 | 1 | 629.52 |  |  | 1000 | 629520
2 | Phenolic Composites | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 24 | 1727.76 | 0.48 | 24 | 1727.76 |  |  | 24000 | 1727760
 | Tungsten Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | Saving
 |  | Total Cost/Unit | 5473.38 |  | Total Cost/Unit | 5473.38 |  |  | Total Cost/All Units | 5473380 | 417.6199999999999
SuperConductor Rail |  | 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
5 | Ferrogel | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Number to Build | Fullerides | 10 | 2077.4 | 0.1666666666666667 | 10 | 2077.4 |  |  | 10000 | 2077400
1000 | Hypersynaptic Fibres | 1 | 13393.19 | 0.01666666666666667 | 1 | 13393.19 |  |  | 1000 | 13393190
Wastage Factor | Nanotransistors | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
1.666666666666667 | Phenolic Composites | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Sylramic Fibers | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Titanium Carbide | 28 | 2015.72 | 0.4666666666666667 | 28 | 2015.72 |  |  | 28000 | 2015720
 | Tungsten Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | Saving
 |  | Total Cost/Unit | 17486.31 |  | Total Cost/Unit | 17486.31 |  |  | Total Cost/All Units | 17486310 | 4095.609999999997
Sustained 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
4 | Ferrogel | 1 | 66898.07 | 0.02 | 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
2 | Phenolic Composites | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Sylramic Fibers | 8 | 723.2 | 0.16 | 8 | 723.2 |  |  | 8000 | 723200
 | Titanium Carbide | 20 | 1439.8 | 0.4 | 20 | 1439.8 |  |  | 20000 | 1439800
 | Tungsten Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | Saving
 |  | Total Cost/Unit | 69061.07 |  | Total Cost/Unit | 69061.07 |  |  | Total Cost/All Units | 69061070 | 6918.87999999999
Titanium Diborate |  | 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
8 | 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
1.111111111111111 | Phenolic Composites | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 | Sylramic Fibers | 30 | 2712 | 0.3333333333333333 | 30 | 2712 |  |  | 30000 | 2712000
 | Titanium Carbide | 40 | 2879.6 | 0.4444444444444445 | 40 | 2879.6 |  |  | 40000 | 2879600
 | Tungsten Carbide | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | Saving
 |  | Total Cost/Unit | 5591.6 |  | Total Cost/Unit | 5591.6 |  |  | Total Cost/All Units | 5591600 | 867.2299999999996