Multi-Crew Haul Sharing Profit Calculator

	A	B	C	E	G	H
1					Make sure you save a copy to your own drive!
2					Check bottom tags for an example run
3					Get the latest version from here
4					https://docs.google.com/spreadsheets/d/1vMR3GHKdxOhWV1Vx0kKphr1tr88GhXA0zk2_hfDZRMc/edit#gid=0
5						Current Version: v2.1 (04/13/20)
6					04/11/20	v1: Sheet created
7					04/12/20	v2: Major Rework
8					04/13/20	v2.1: Minor tweaks
9					04/14/20	v2.2:
10				Discord Link		a. Added more Buy Amounts, Split Fuel and added other types of buy amounts.
11	Corp Link: https://robertsspaceindustries.com/orgs/RRR			Created by AngryOwl/Taffs		b. Added Percentage Cut
12	Multi-Crew Haul Profit Sharing Calculator
13
14	Crew Count	3		Put full amount of crew including Pilot
15				Put full amount of crew including Pilot
16	Run #1
17
18	Buy Amount #1	0.00		Put total amount paid for cargo
19	Buy Amount #2	0.00
20	Buy Amount #3	0.00
21	Ammo	0.00		Put down fuel, ammo, food and whatever else
22	Food	0.00		Put down fuel, ammo, food and whatever else
23	Misc.	0.00		misc can be anything else
24		Quantum	Hydrogen
25	Fuel	0.00	0.00
26
27	Total Expenses	0.00
28
29	Contributions
30		Name	Amount
31		Pilot	0.00	Amount of Money contributed to cargo per crew member. Pilot is auto calculated since they are the purchaser
32	Crew #2	Chris	0.00
33	Crew #3	Robert	0.00
34	Crew #4		0.00
35	Crew #5		0.00
36
37	Sell Amount #1	0.00		Put total amount sold. Use others if multiple trips were needed
38	Sell Amount #2	0.00
39	Sell Amount #3	0.00
40	Sell Amount Total	0.00
41
42		Run Profit Amount	Even Split Amount
43		0.00	0.00
44
45	Percentage Cut	0.00%	0.00	Use this for corp cut or for paying people by percentage. Use on your final run.
46
47		Profit After Cut	Even Split After Cut
48		0.00	0.00
49
50	Crew Split
51
52		Pilot	0.00	Amount of money to be sent to each crew member if you are ending runs. Pilot just there for clarity.
53	Crew #2	Chris	0.00
54	Crew #3	Robert	0.00
55	Crew #4
56	Crew #5
57
58
59	Run #2
60
61	Buy Amount #1	0.00		If you are just transferring over profits from previous run, just fill in any additional contributions. If payments splits were made, start over from run #1
62	Buy Amount #2	0.00
63	Buy Amount #3	0.00
64	Ammo	0.00
65	Food	0.00
66	Misc.	0.00
67		Quantum	Hydrogen
68	Fuel	0.00	0.00
69
70	Total Expenses	0.00
71
72	Contributions
73		Name	Amount	Additional Contributions
74		Pilot	0.00
75	Crew #2	Chris	0.00	0.00
76	Crew #3	Robert	0.00	0.00
77	Crew #4		0.00	0.00
78	Crew #5		0.00	0.00
79
80	Sell Amount #1	0.00
81	Sell Amount #2	0.00
82	Sell Amount #3	0.00
83	Sell Amount Total	0.00
84				Total Profits carried over from Run #1
85		Run Profit Amount	Even Split Amount	Total Profits carried over from Run #1
86		0.00	0.00	0.00
87
88	Percentage Cut	0.00%	0.00
89
90		Profit After Cut	Even Split After Cut
91		0.00	0.00
92
93	Crew Split
94
95		Pilot	0.00	Pilot numbers don't carry over for multiple runs and their contributions are implied. Since the pilot still has all the money their split may look smaller but it's still even and contributions are paid back
96	Crew #2	Chris	0.00
97	Crew #3	Robert	0.00
98	Crew #4
99	Crew #5
100