Here's my redesign of the Expedition TABLE I posted before:
https://drive.google.com/open?…cp1MkV_f8QhAZfggK30cPezB4
This time much more organized as you can see in the pic with individual tabs where you can fill your results.
As always, the blank parts highlighted in green are the ones you have to fill. Anything with a 0 or #DIV0 is filled automatically.
1. Resource TAB:
You just have to fill it like so:
For every expedition you get Resources or DarkMatter.
2. Ships TAB:
Fill it like this:
Here in my first expedition I got 2 Light Fighter, 452 Heavy Fighters, 9 Destroyers and 64 Large Cargos so I filled them all under Expo 1. You get the drill. The Ships value in Metal tab will fill automatically after you fill the number of ships you gained in said expedition.
3. Item Tab:
Pretty straightforward, for every item you get just type in the number 1 right after them. Pretty simple:
4. Losses against Pirates and Aliens TAB:
For every time you lose ships against Pirates or Aliens you have to open the combat report to see what you have lost and fill in like so (note: you barely have losses against pirates if you only send cargos):
5. Ships you destroyed against Pirates and Aliens TAB:
Same as above, open the combat report and fill in the ships you have destroyed against either Pirates or Aliens. Both tabs are important because they will calculate your ship losses and the amount of Debris Field you can potentially profit from. The TAB is pretty much the same as the one above but with the main title in GREEN instead of RED.
..::Edit by NoMoreAngel|Changed post on request|4.2.2020|20:20:02::..