Freelance Money Calculator 1.0 (FRESH)

	B	C	D
1	Terri's Freelance Money Calculator 1.0
2	Hello! This is a modified version of the spreadsheet that I use to calculate my various freelancing jobs and other sources of income. It might be useful to you, too!
3	If you find this calculator helpful and are feeling generous, please consider sending a donation to one of the addresses listed below :)
4
5	PayPal: ycdtimc@gmail.com Bitcoin: 18rkgpepCJR3krudT3C5pMwqeLbutLfYBU
6
7	Introduction
8	This spreadsheet has one job: to make sure that you are staying on point. It will take your monthly goal, the number of hours that you have worked, and the amount of money you have made, and spit out numbers that you can use to figure out how much more work you need to accomplish within a certain amount of time.
9
10
11
12	If a cell is GREEN, then that means it is totally safe for you to edit, and I encourage you to do so if you actually want this thing to work. If a cell is RED, then you should NOT edit that cell. I repeat, DO NOT EDIT THE RED CELLS. If you do, the spreadsheet will likely stop working, and you will see errors all over the place, instead of all that beautiful progress that you've made.
13
14
15		EDIT ME!!!	DO NOT EDIT
16
17	If you do happen to edit one of the RED cells, do not worry! Just go to a fresh copy of this spreadsheet, copy the particular cell that you messed up, and paste it into your existing spreadsheet. All is forgiven!
18
19
20	The Tabs
21
22	RIGHT NOW
23
24	The first thing that you will want to edit is the END DATE cell. I generally set my goals on a month-to-month basis, though you can set it to a week from now if you need to.
25
26
27	END DATE	7/31/2014
28
29	The GOAL is how much money you would like to make by the date that you entered above. Remember to have realistic expectations!
30
31
32	GOAL!	$2,000.00
33
34	As you can see below, the left cell automatically calculates how many days are left until your END DATE arrives. The cell on the right requires YOU to calculate how many working days are left between now and the END DATE. This date can match the DAYS LEFT cell if you like, or you can just use the number of weekdays left in the month, if that's all that you plan on working.
35
36
37	REAL DAYS LEFT	WK DAYS ONLY
38	17.42	14
39
40	The block of cells below are pretty self-explanatory. You can change the names to reflect your own personal stuffs if you need to. Don't forget that this is just the introduction page, and you should not be editing THIS page :)
41
42
43	PayPal	$65.46	TOTAL
44	DEBIT CARD	$150.63	$1,220.07
45	SAVINGS	$1,000.98
46	CASH	$3.00
47
48	You will use the DAY TOOL to track your daily goals and expectations. You only need to input what you hope to make for the day, and the DAY TOOL will use this information and other data that you've provided to calculate your RATE PER HOUR and how much is LEFT TO MAKE. If your HOURS WORKED is 00:00:00 you will get an error with your RATE PER HOUR, as it is impossible to divide by zero.
49
50
51	DAY TOOL
52	HOURS WORKED	RATE PER HOUR	MADE TODAY
53	4:00:00	$10.00	$50.00
54	DAILY GOAL		LEFT TO MAKE
55	$50.00		$40.00
56
57	The START cell tells you how much money you had when you began the day. The BANKED cell tells you how much money you have now.
58
59
60	START		BANKED
61	$100.00		$140.00
62
63	MONEY IN LIMBO is money that you have earned but don't have hope of getting in time for it to make a difference. This total is calculated using data you input elsewhere. ALL MONEY is all the cash you are expecting to get, plus all of the money that you currently have. LEFT TO EARN is exactly what it says!
64
65
66	MONEY IN LIMBO	ALL MONEY	LEFT TO EARN
67	$20.98	$1,360.07	$779.93
68
69	Once all of your data is in place, this part of the sheet will tell you how long you need to work to be able to meet your goal, given the amount of days that are left and the amount of hours that you are available to work. The scratch notes on the right side have no effect on the spreadsheet.
70
71
72	EARN PER HOUR (8)	scratch notes
73	$7.50
74	EARN PER HOUR (6)
75	$10.00
76	EARN PER HOUR (4)
77	$15.00
78	EARN PER HOUR (2)
79	$30.00
80	EARN PER DAY
81	$60.00
82	EARN PER WEEK
83	$420.00
84	.
85	JOBS
86
87	The JOBS tab is where you input all of your income! I've included a list of some of the most popular Work At Home Job companies, but you can change them to whatever you like.
88
89
90	The cells in the START column shoud reflect what your balance was with this company when you began the day. If you make $10 an hour and you know that you've worked 20 hours so far in this pay period, the START cell would read $200.00.
91
92
93	START
94	$200.00
95
96	The cells in the BANKED column should be updated throughout the day as you make more money. So if you started the day with $200.00, and you've worked one hour so far, this cell would read $210.00. When you begin work the next day, you would update the START column to $210.00, granted if you only worked that one hour the previous day.
97
98
99	BANKED
100	$210.00