Steel and File:DSP Build Tracker and Item List.xlsx: Difference between pages

From the Dyson Sphere Program Wiki
(Difference between pages)
imported>76561198052446940
 
imported>76561198121518784
 
Line 1: Line 1:
<div style="float: right; clear: right;">
== Summary: ==
{{:{{PAGENAME}}/ItemInfo}}
A workbook that will allow you to keep easy tracking of your production.  It has auto formatting and does all the hard work for you - you just need to tell it your progress by entering a "Y" in the "master" sheet and all sub-sheets will auto update.
</div>
==Summary==
Under strict and controllable temperature conditions, using iron ingots as raw material for further smelting, the crystal form of the material is improved so that has better mechanical properties.


==Production Chain==
== How to use this Workbook: ==
{{ProductionChainTable/head}}
As you produce each item mark it in Column B with a "Y" on the "Master" sheet.
{{ProductionChain
|Building=Smelter
|Replicator=No
|Technology=
|Recipe=
  {{ItemRecipe
    |Out1=Steel
    |Out1Qty=1
    |CraftTime=3 s
    |In1=Iron Ingot
    |In1Qty=3
  }}
}}
|}


===Production Progression Chart===
Once the item is in the intra-planetary storage network mark it in Column C with a "Y" on the "Master" sheet.
{| class="wikitable" style="text-align:center; background-color:#0b161c
! Stage 1
! Stage 2
! Stage 3
|-
| {{riq|Iron Ore|60}}
| {{riq|Smelter|1}} {{to}} {{riq|Iron Ingot|60}}
| {{riq|Smelter|1}} {{to}} {{riq|Steel|20}}
|}


==Used In==
Once the item is in the inter-planetary storage network mark it in Column D with a "Y on the "Master" sheet.
===Components===
{{ProductionChainTable/head}}
{{ProductionChain
|Building=Smelter
|Replicator=No
|Technology=High-Strength Titanium Alloy
|Recipe=     
  {{ItemRecipe
    |Out1=Titanium Alloy
    |Out1Qty=4
    |CraftTime=12 s
    |In1=Titanium Ingot
    |In1Qty=4
    |In2=Steel
    |In2Qty=4
    |In3=Sulfuric Acid
    |In3Qty=8
  }}
}}
|-
{{ProductionChain
|Building=Assembling Machine
|Replicator=Yes
|Technology=Thruster
|Recipe=
  {{ItemRecipe
    |Out1=Thruster
    |Out1Qty=1
    |CraftTime=4 s
    |In1=Steel
    |In1Qty=2
    |In2=Copper Ingot
    |In2Qty=3
  }}
}}
|-
{{ProductionChain
|Building=Assembling Machine
|Replicator=Yes
|Technology=Environment Modification
|Recipe=         
  {{ItemRecipe
    |Out1=Foundation
    |Out1Qty=1
    |CraftTime=1 s
    |In1=Stone Brick
    |In1Qty=3
    |In2=Steel
    |In2Qty=1
  }}
}}
|}


===Buildings===
{{ProductionChainTable/head}}
{{ProductionChain
|Building=Assembler
|Replicator=Yes
|Technology=High-Efficiency Logistics System
|Recipe=         
  {{ItemRecipe
    |Out1=Storage Mk.II
    |Out1Qty=1
    |CraftTime=4 s
    |In1=Steel
    |In1Qty=8
    |In2=Stone Brick
    |In2Qty=8
  }}
}}
|-
{{ProductionChain
|Building=Assembler
|Replicator=Yes
|Technology=Plasma Extract Refining
|Recipe=         
  {{ItemRecipe
    |Out1=Oil Extractor
    |Out1Qty=1
    |CraftTime=8 s
    |In1=Steel
    |In1Qty=12
    |In2=Stone Brick
    |In2Qty=12
    |In3=Circuit Board
    |In3Qty=6
    |In4=Plasma Exciter
    |In4Qty=4
  }}
}}
|-
{{ProductionChain
|Building=Assembler
|Replicator=Yes
|Technology=Plasma Extract Refining
|Recipe=         
  {{ItemRecipe
    |Out1=Oil Refinery
    |Out1Qty=1
    |CraftTime=6 s
    |In1=Steel
    |In1Qty=10
    |In2=Stone Brick
    |In2Qty=10
    |In3=Circuit Board
    |In3Qty=6
    |In4=Plasma Exciter
    |In4Qty=6
  }}
}}
|-
{{ProductionChain
|Building=Assembler
|Replicator=Yes
|Technology=Basic Chemical Engineering
|Recipe=         
  {{ItemRecipe
    |Out1=Chemical Plant
    |Out1Qty=1
    |CraftTime=5 s
    |In1=Steel
    |In1Qty=8
    |In2=Stone Brick
    |In2Qty=8
    |In3=Glass
    |In3Qty=8
    |In4=Circuit Board
    |In4Qty=2
  }}
}}
|-
{{ProductionChain
|Building=Assembler
|Replicator=Yes
|Technology=Deuterium Fractionation
|Recipe=         
  {{ItemRecipe
    |Out1=Fractionator
    |Out1Qty=1
    |CraftTime=3 s
    |In1=Steel
    |In1Qty=8
    |In2=Stone Brick
    |In2Qty=4
    |In3=Glass
    |In3Qty=4
    |In4=Processor
    |In4Qty=1
  }}
}}
|-
{{ProductionChain
|Building=Assembler
|Replicator=Yes
|Technology=Planetary Logistics System
|Recipe=         
  {{ItemRecipe
    |Out1=Planetary Logistics Station
    |Out1Qty=1
    |CraftTime=20 s
    |In1=Steel
    |In1Qty=40
    |In2=Titanium Ingot
    |In2Qty=40
    |In3=Processor
    |In3Qty=40
    |In4=Particle Container
    |In4Qty=20
  }}
}}
|-
{{ProductionChain
|Building=Assembler
|Replicator=Yes
|Technology=Interstellar Power Transmission
|Recipe=         
  {{ItemRecipe
    |Out1=Energy Exchanger
    |Out1Qty=1
    |CraftTime=15 s
    |In1=Titanium Alloy
    |In1Qty=40
    |In2=Steel
    |In2Qty=40
    |In3=Processor
    |In3Qty=40
    |In4=Particle Container
    |In4Qty=8
  }}
}}
|-
{{ProductionChain
|Building=Assembler
|Replicator=Yes
|Technology=Solar Sail Orbit System
|Recipe=         
  {{ItemRecipe
    |Out1=EM-Rail Ejector
    |Out1Qty=1
    |CraftTime=6 s
    |In1=Steel
    |In1Qty=20
    |In2=Gear
    |In2Qty=20
    |In3=Processor
    |In3Qty=5
    |In4=Super-Magnetic Ring
    |In4Qty=10
  }}
}}
|-
{{ProductionChain
|Building=Assembler
|Replicator=Yes
|Technology=Ray Receiver
|Recipe=         
  {{ItemRecipe
    |Out1=Ray Receiver
    |Out1Qty=1
    |CraftTime=8 s
    |In1=Steel
    |In1Qty=40
    |In2=High-Purity Silicon
    |In2Qty=20
    |In3=Photon Combiner
    |In3Qty=10
    |In4=Processor
    |In4Qty=5
    |In5=Super-Magnetic Ring
    |In5Qty=20
  }}
}}
|}


==Player Tips & Tricks==
One smelter making iron ingots will produce exactly enough to make one steel in the same time (3s), allowing you to pair two smelters together with source of iron ore.


[[Category:Item]]
When an item is marked as being in the planetary storage it will be marked as available withing each production sheet, this will let you see if you have the base component available to create the target product.
[[Category:Components]]
 
[[Category:Material]]
When an item is marked as being produced and both storage types it will be marked green.
[[Category:Crafting Material]]
 
 
 
There is no need to update the production sheets as the master sheet will update these automatically, however you can add any specific notes for that production chain on the sub-sheet.
 
Formulas and formatting are currently applied down to row 200 to allow for some expansion as the game grows.
 
Products are all sorted aplhabetically and any furure ones can be inserted as needed.
 
== Changelog: ==
14/02/21: V1.0:  Initial layout
 
== Upcoming: ==
I would like to add the required quantities.
 
I would like to add a production calc that will work out how many you are producing and how much is required so you know
if you are meeting the production requirements or over/under producing.
 
I will look into a google sheets version - but as I'm not so familiar with this it may take a bit - especially with the formatting/formulas.
 
== Requests: ==
Please feel free to let me know any changes you would like to see in future versions as well as any bugs if you find them(hopefully there are none! :p)
 
====== THERE ARE NO MACRO's IN THIS WORKBOOK - ALL THE FORMATTING IS DONE WITH FORMULAS AND CONDITIONAL FORMATTING ======

Revision as of 20:38, 14 February 2021

Summary:

A workbook that will allow you to keep easy tracking of your production. It has auto formatting and does all the hard work for you - you just need to tell it your progress by entering a "Y" in the "master" sheet and all sub-sheets will auto update.

How to use this Workbook:

As you produce each item mark it in Column B with a "Y" on the "Master" sheet.

Once the item is in the intra-planetary storage network mark it in Column C with a "Y" on the "Master" sheet.

Once the item is in the inter-planetary storage network mark it in Column D with a "Y on the "Master" sheet.


When an item is marked as being in the planetary storage it will be marked as available withing each production sheet, this will let you see if you have the base component available to create the target product.

When an item is marked as being produced and both storage types it will be marked green.


There is no need to update the production sheets as the master sheet will update these automatically, however you can add any specific notes for that production chain on the sub-sheet.

Formulas and formatting are currently applied down to row 200 to allow for some expansion as the game grows.

Products are all sorted aplhabetically and any furure ones can be inserted as needed.

Changelog:

14/02/21: V1.0: Initial layout

Upcoming:

I would like to add the required quantities.

I would like to add a production calc that will work out how many you are producing and how much is required so you know if you are meeting the production requirements or over/under producing.

I will look into a google sheets version - but as I'm not so familiar with this it may take a bit - especially with the formatting/formulas.

Requests:

Please feel free to let me know any changes you would like to see in future versions as well as any bugs if you find them(hopefully there are none! :p)

THERE ARE NO MACRO's IN THIS WORKBOOK - ALL THE FORMATTING IS DONE WITH FORMULAS AND CONDITIONAL FORMATTING
🍪 We use cookies to keep session information to provide you a better experience.