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

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)

@@ 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==
-Generates [[Hydrogen]] and [[Deuterium]] when placed on the equator of a [[Gas Giant]], or Hydrogen and [[Fire Ice]] on the equator of an [[Gas Giant#Ice Giant|Ice Giant]].
-The resource collection rate depends on the yield of the giant and the gathering speed of the [[Orbital Collector]]. The default gathering speed is 8. The gathering speed can be increased with the [[Veins_Utilization_(Upgrade)| Veins Utilization]] upgrade. The collection rate is calulated as yield * gathering speed.
+== How to use this Workbook: ==
+As you produce each item mark it in Column B with a "Y" on the "Master" sheet.
-However, some of the collected resources will be used to power the [[Orbital Collector]], which drastically lowers how much resources are actually usable.
+Once the item is in the intra-planetary storage network mark it in Column C with a "Y" on the "Master" sheet.
-Both resources will be used to fuel the [[Orbital Collector]], regardless of how much is stored of each resource.
-The resources are used proportionally to how much is collected per second, and how much energy is generated by burning the resource.
-For example: A giant has a yield of 0.5 fireice/s and 0.25 hydrogen/s. The actual resource yield can be calculated like this:
+Once the item is in the inter-planetary storage network mark it in Column D with a "Y on the "Master" sheet.
-{| class="wikitable"
-! Collection rate !! Power value !! % of total power collected !! Power diverted to Orbital Collector !! Resources remaining
-|-
-| 0.5 fireice/s * 8 = '''4.5 fireice/s'''
-| 4.8 MJ/fireice * 4 fireice/s = '''19.2 MW'''
-| style="text-align:center"| '''52%'''
-| 0.52 * 30MW = '''15.4 MW'''
-| (19.2 MW - 15.4 MW) / 4.8 MJ/fireice = '''0.77 fireice/s'''
-|-
-| 0.25 hydrogen/s * 8 = '''2 hydrogen/s '''
-| 9 MJ/hydrogen * 2 hydrogen/s = '''18 MW'''
-| style="text-align:center"| '''48%'''
-| 0.48 * 30MW = '''14.5 MW'''
-| (18 MW - 14.5 MW) / 9 MJ/hydrogen = '''0.39 hydrogen/s'''
-|}
-With the default gathering speed, most of the resources are lost to power the [[Orbital Collector]]. Researching higher levels of the [[Veins_Utilization_(Upgrade)| Veins Utilization]] is important to get good yields, as this increases the gathering speed of the [[Orbital Collector]] while keeping the power consumption the same.
-==Production Chain==
+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.
-{{ProductionChainTable/head}}
-{{ProductionChain
-|Building=Assembler
-|Replicator=Yes
-|Technology=Gas Giants Exploitation
-|Recipe=
-  {{ItemRecipe
-    |Out1=Orbital Collector
-    |Out1Qty=1
-    |CraftTime=30 s
-    |In1=Interstellar Logistics Station
-    |In1Qty=1
-    |In2=Super-Magnetic Ring
-    |In2Qty=50
-    |In3=Reinforced Thruster
-    |In3Qty=20
-    |In4=Full Accumulator
-    |In4Qty=20
-    }}
-  }}
-|}
-==Player Tips & Tricks==
+When an item is marked as being produced and both storage types it will be marked green.
-It is possible to place more than one collector on a [[Gas Giant]], although there is a minimum distance between collectors required. Placing them at the minimal possible distance will let you place a maximum of 40 collectors.
-In order to export products from an orbital collector, set to the collector to "remote supply." Then on the planet where you wish to receive the collected products, set up an [[Interstellar Logistics Station]] with fire ice, hydrogen, and/or deuterium set to "remote demand."
-{{Item Navbox}}
+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.
-[[Category:Item]]
-[[Category:Building]]
+Formulas and formatting are currently applied down to row 200 to allow for some expansion as the game grows.
-[[Category:Mining Facility]]
+Products are all sorted aplhabetically and any furure ones can be inserted as needed.
+== Changelog: ==
+/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 ======