I've created a pretty neat little spreadsheet and form with Google Docs for Gateway which I'll share once I've gotten a good "template" down.
If anyone is really good with Excel or spreadsheets in general please feel free to skype me as I'm stuck on a particular aspect. Mainly using multiple criteria for calculations on an array.
Otherwise, trading factions; what do you guys think about this sort of thing and what would be useful information as a faction for you to know?
Posts: 6,892
Threads: 413
Joined: Aug 2007
Staff roles: Story Dev Economy Dev
Bowex has been using this sort of thing for a few years now - its used to track routes, contracts, bonuses, rosters, etc. We incorporated a semi-autonomous PoB supply tracker, as well. Definitely worth the effort once it's set up.
Posts: 6,892
Threads: 413
Joined: Aug 2007
Staff roles: Story Dev Economy Dev
Well, I'm no pro when it comes to the supply sheets - you'd have to ask one of our formula wizards about that. I can give you a rough idea of what the rest looks like though.
![[Image: gcproject%20final_export.png]](http://lh5.ggpht.com/_P6yHtBMIT_M/TDt2O-P2KHI/AAAAAAAACSM/oZTc5fptJN4/s800/gcproject%20final_export.png)
![[Image: redon.gif]](http://sig.grumpybumpers.com/host/redon.gif)
![[Image: f0D5b.png]](http://i.imgur.com/f0D5b.png)
![[Image: O2Zu5.png]](http://i.imgur.com/O2Zu5.png)
![[Image: IlS2I.png]](http://i.imgur.com/IlS2I.png)
![[Image: yNeaK.png]](http://i.imgur.com/yNeaK.png)
![[Image: 9zbjr.png]](http://i.imgur.com/9zbjr.png)
![[Image: D7RGg.png]](http://i.imgur.com/D7RGg.png)