User:Bora vyvorant/NSC Hangar Procedures: Difference between revisions

← Older edit Newer edit →

VisualWikitext

@@ Line 39: / Line 39: @@
 Try and do this at the more rapid end of the scale (every couple of days) if possible, to avoid things running out.
+The corporate hangars are restocked from a container called "AA - Reserve Stocks" in the Alpha hangar. You'll need the general password for this container to even see what's in it.
+Restocking the hangars requires telling the spreadsheet about what's in the Reserve Stocks container and in the individual containers to be restocked.
+Importing the reserves:
+* Open the "hangar-import" sheet in the "nsc-hangar-sheet-core" spreadsheet
+* TODO: consider whether the function of hangar-import would be clearer if we renamed it to something like "reserves-import".
+* Delete all data in the "hangar-import" sheet.
+* In the Eve client, select all items in the "AA - Reserve Stocks" container and copy to the clipboard. NOTE: you should do this with no inventory filter active, and in List layout.
+* Paste the reserve stock data into the "hangar-import" sheet starting at cell A1.
+Importing the public containers:
+* Open the "container-import" sheet
+* If you do not have Psi hangar access, scroll down until you reach the end of the Psi container data in column D. This will be around the location of a marker in column C that says "continue paste here or hereabouts for ALPHA and THETA". You can tell the exact location because the alphabetic sequence in column D will end, usually with "Warden II".
+* TODO: image of the above
+* Delete all data for the containers you're restocking, from D52 or thereabouts to something like I385.
+* Paste in do D52 onwards the inventory contents for the following containers. Wait for the data for each to show up before moving on to the next one, to avoid overwriting.
+** Alpha hangar: "1 - Ammo & T1 Items"
+** Alpha hangar: "2 - Prop. Mods/Jams/EWAR"
+** Theta hangar: "11 - Ammo, T2/Faction"
+** Theta hangar: "11 - Bombs and Bubbles"
+** Theta hangar: "12 - Drones"
+** Theta hangar: "21 - High Slots, Meta"
+** Theta hangar: "39 - Medium Slots"
+** Theta hangar: "49 - Low Slots"
+Actual restocking:
+* Open the "hangar-restocking" sheet
+* Transfer the indicated number of items of the given kinds from the Reserve Stocks container to the indicated container. If not container is indicated, figure out which container is most likely and update the "stocks-report" sheet accordingly.
+* Relock stacks in the "AA - Reserve Stocks" container after drawing from them.
+* It's fine to overstock a little from reserves to save time, for example if 4 items are to be transferred but there's a stack of 5 in reserves.
 == Tidy "to Jita" ==