Science & Industry

Hello, industrial people.
As the backbone of the EVE economy, you guys move a lot of stuff around the universe.
I've set up enough courier contracts myself to know that it is a pain in the a$$ calculating collateral amounts and rewards.
So here is a google spreadsheet to help you.

https://docs.google.com/spreadsheets/d/1Mey8ki-rEduZ_5bYa_q7AyrS-wJsG_QydmBplEq5kLs/edit?pli=1#gid=1616592238

Just type in the typeName, quantity, starting and destination systems, and finally the hub you will base your cargo worth.
The sheet will consider the collateral amount, number of jumps and volume, and will suggest a suitable reward.

Current reward formula works for my inter-regional trading purpose, but feel free to make a copy to unlock the rest of the fields and modify the reward calculation formula as you wish.