{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["CASH FLOW","Income","Investments","Recurring Expenses","One-time Expenses","Savings","Bank Balances"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CASH FLOW","index":0,"n_rows":71,"n_cols":31,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[null,null,"Period:",1,{"$f":"D1+1","v":2},{"$f":"E1+1","v":3},{"$f":"F1+1","v":4},{"$f":"G1+1","v":5},{"$f":"H1+1","v":6},{"$f":"I1+1","v":7},{"$f":"J1+1","v":8},{"$f":"K1+1","v":9},{"$f":"L1+1","v":10},{"$f":"M1+1","v":11},{"$f":"N1+1","v":12},{"$f":"O1+1","v":13},{"$f":"P1+1","v":14},{"$f":"Q1+1","v":15},{"$f":"R1+1","v":16},{"$f":"S1+1","v":17},{"$f":"T1+1","v":18},{"$f":"U1+1","v":19},{"$f":"V1+1","v":20},{"$f":"W1+1","v":21},{"$f":"X1+1","v":22},{"$f":"Y1+1","v":23},{"$f":"Z1+1","v":24},{"$f":"AA1+1","v":25},{"$f":"AB1+1","v":26},{"$f":"AC1+1","v":27}]
[null,"FAMILY CASH FLOW PROJECTION"]
[]
[null,"Today's date:","2014-12-11"]
[null,"Last pay date:","2014-11-28"]
[null,"Cash balance alert minimum",2500]
[]
[null,"DATE","Current Cash",{"$f":"C5","v":"2014-11-28"},{"$f":"D8+14","v":"2014-12-12"},"2014-12-26","2015-01-09","2015-01-23","2015-02-06","2015-02-20","2015-03-06","2015-03-20","2015-04-03","2015-04-17","2015-05-01","2015-05-15","2015-05-29","2015-06-12","2015-06-26","2015-07-10","2015-07-24","2015-08-07","2015-08-21","2015-09-04","2015-09-18","2015-10-02","2015-10-16","2015-10-30","2015-11-13","2015-11-27","Total"]
[null,"Cash on hand (beginning of period)",{"$f":"'Bank Balances'!C18","v":9653},{"$f":"C9","v":9653},{"$f":"D62","v":13273.4},14087.8,12208.199999999997,13422.599999999997,13042.999999999996,16257.399999999998,15877.8,19092.2,18712.600000000002,13927.000000000004,13547.400000000003,14761.800000000003,17976.200000000004,17596.600000000006,20811.000000000007,20431.400000000009,21145.80000000001,20766.200000000012,21980.600000000013,21601.000000000015,22815.400000000016,22435.800000000017,23650.200000000019,24864.60000000002,24485.000000000022,25699.400000000023]
[null,"Cash on hand (end of period)",null,{"$f":"D62","v":13273.4},14087.8,12208.199999999997,13422.599999999997,13042.999999999996,{"$f":"I62","v":16257.399999999998},15877.8,19092.2,18712.600000000002,{"$f":"M62","v":13927.000000000004},{"$f":"N62","v":13547.400000000003},14761.800000000003,17976.200000000004,17596.600000000006,20811.000000000007,20431.400000000009,21145.80000000001,{"$f":"U62","v":20766.200000000012},21980.600000000013,{"$f":"W62","v":21601.000000000015},{"$f":"X62","v":22815.400000000016},22435.800000000017,{"$f":"Z62","v":23650.200000000019},24864.60000000002,{"$f":"AB62","v":24485.000000000022},25699.400000000023,25319.800000000025]
[]
[null,"CASH RECEIPTS","Beginning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"On Campus Job",null,{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"Income!$K$4","v":264},{"$f":"SUM(D13:AD13)","v":7128}]
[null,"Red Robin",null,{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"Income!$K$5","v":1074.4000000000001},{"$f":"SUM(D14:AD14)","v":29008.800000000014}]
[null,"Side Job Name",null,{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"Income!$K$6","v":50},{"$f":"SUM(D15:AD15)","v":1350}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D16:AD16)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D17:AD17)","v":0}]
[null,"Cash from investments/assets",null,4000,null,4000,null,null,2000,null,2000,null,2000,null,null,2000,null,2000,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D18:AD18)","v":18000}]
[null,"TOTAL CASH RECEIPTS",null,{"$f":"SUM(D13:D18)","v":5388.4},1388.4,5388.4,1388.4,1388.4,{"$f":"SUM(I13:I18)","v":3388.4},1388.4,3388.4,1388.4,{"$f":"SUM(M13:M18)","v":3388.4},{"$f":"SUM(N13:N18)","v":1388.4},1388.4,3388.4,1388.4,3388.4,1388.4,1388.4,{"$f":"SUM(U13:U18)","v":1388.4},1388.4,{"$f":"SUM(W13:W18)","v":1388.4},{"$f":"SUM(X13:X18)","v":1388.4},1388.4,{"$f":"SUM(Z13:Z18)","v":1388.4},1388.4,{"$f":"SUM(AB13:AB18)","v":1388.4},1388.4,1388.4,{"$f":"SUM(AE13:AE18)","v":55486.800000000017}]
[null,"Total cash available",null,{"$f":"(D9+D19)","v":15041.4},14661.8,19476.199999999997,13596.599999999997,14810.999999999996,{"$f":"(I9+I19)","v":16431.399999999998},17645.8,19266.2,20480.600000000002,{"$f":"(M9+M19)","v":22101.000000000004},{"$f":"(N9+N19)","v":15315.400000000003},14935.800000000003,18150.200000000004,19364.600000000006,20985.000000000007,22199.400000000009,21819.80000000001,{"$f":"(U9+U19)","v":22534.200000000012},22154.600000000013,{"$f":"(W9+W19)","v":23369.000000000015},{"$f":"(X9+X19)","v":22989.400000000016},24203.800000000017,{"$f":"(Z9+Z19)","v":23824.200000000019},25038.60000000002,{"$f":"(AB9+AB19)","v":26253.000000000022},25873.400000000023,27087.800000000025]
[]
[null,"CASH PAID OUT","Beginning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"FIXED COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D23:AD23)","v":0}]
[null,"Tithing",null,{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"'Recurring Expenses'!$D$4","v":174},{"$f":"SUM(D24:AD24)","v":4698}]
[null,"Fast offering",null,{"$f":"'Recurring Expenses'!$D$5","v":20},null,{"$f":"'Recurring Expenses'!$D$5","v":20},null,{"$f":"'Recurring Expenses'!$D$5","v":20},null,{"$f":"'Recurring Expenses'!$D$5","v":20},null,{"$f":"'Recurring Expenses'!$D$5","v":20},null,{"$f":"'Recurring Expenses'!$D$5","v":20},null,null,{"$f":"'Recurring Expenses'!$D$5","v":20},null,{"$f":"'Recurring Expenses'!$D$5","v":20},null,{"$f":"'Recurring Expenses'!$D$5","v":20},null,{"$f":"'Recurring Expenses'!$D$5","v":20},null,{"$f":"'Recurring Expenses'!$D$5","v":20},null,null,{"$f":"'Recurring Expenses'!$D$5","v":20},null,{"$f":"'Recurring Expenses'!$D$5","v":20},{"$f":"SUM(D25:AD25)","v":260}]
[null,"Rent",null,{"$f":"'Recurring Expenses'!$D$6","v":695},null,{"$f":"'Recurring Expenses'!$D$6","v":695},null,{"$f":"'Recurring Expenses'!$D$6","v":695},null,{"$f":"'Recurring Expenses'!$D$6","v":695},null,{"$f":"'Recurring Expenses'!$D$6","v":695},null,{"$f":"'Recurring Expenses'!$D$6","v":695},null,null,{"$f":"'Recurring Expenses'!$D$6","v":695},null,{"$f":"'Recurring Expenses'!$D$6","v":695},null,{"$f":"'Recurring Expenses'!$D$6","v":695},null,{"$f":"'Recurring Expenses'!$D$6","v":695},null,{"$f":"'Recurring Expenses'!$D$6","v":695},null,null,{"$f":"'Recurring Expenses'!$D$6","v":695},null,{"$f":"'Recurring Expenses'!$D$6","v":695},{"$f":"SUM(D26:AD26)","v":9035}]
[null,"Utilities",null,{"$f":"'Recurring Expenses'!$D$7","v":30},null,{"$f":"'Recurring Expenses'!$D$7","v":30},null,{"$f":"'Recurring Expenses'!$D$7","v":30},null,{"$f":"'Recurring Expenses'!$D$7","v":30},null,{"$f":"'Recurring Expenses'!$D$7","v":30},null,{"$f":"'Recurring Expenses'!$D$7","v":30},null,null,{"$f":"'Recurring Expenses'!$D$7","v":30},null,{"$f":"'Recurring Expenses'!$D$7","v":30},null,{"$f":"'Recurring Expenses'!$D$7","v":30},null,{"$f":"'Recurring Expenses'!$D$7","v":30},null,{"$f":"'Recurring Expenses'!$D$7","v":30},null,null,{"$f":"'Recurring Expenses'!$D$7","v":30},null,{"$f":"'Recurring Expenses'!$D$7","v":30},{"$f":"SUM(D27:AD27)","v":390}]
[null,"Groceries",null,{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"'Recurring Expenses'!$D$8","v":190},{"$f":"SUM(D28:AD28)","v":5130}]
[null,"Eating out",null,{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"'Recurring Expenses'!$D$9","v":100},{"$f":"SUM(D29:AD29)","v":2700}]
[null,"Personal-care (haircut, laundry, toiletries, etc.)",null,{"$f":"'Recurring Expenses'!$D$10","v":20},null,{"$f":"'Recurring Expenses'!$D$10","v":20},null,{"$f":"'Recurring Expenses'!$D$10","v":20},null,{"$f":"'Recurring Expenses'!$D$10","v":20},null,{"$f":"'Recurring Expenses'!$D$10","v":20},null,{"$f":"'Recurring Expenses'!$D$10","v":20},null,null,{"$f":"'Recurring Expenses'!$D$10","v":20},null,{"$f":"'Recurring Expenses'!$D$10","v":20},null,{"$f":"'Recurring Expenses'!$D$10","v":20},null,{"$f":"'Recurring Expenses'!$D$10","v":20},null,{"$f":"'Recurring Expenses'!$D$10","v":20},null,null,{"$f":"'Recurring Expenses'!$D$10","v":20},null,{"$f":"'Recurring Expenses'!$D$10","v":20},{"$f":"SUM(D30:AD30)","v":260}]
[null,"Gas",null,{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"'Recurring Expenses'!$D$11","v":150},{"$f":"SUM(D31:AD31)","v":4050}]
[null,"Vehicle Repairs",null,{"$f":"'Recurring Expenses'!$D$12","v":100},null,{"$f":"'Recurring Expenses'!$D$12","v":100},null,{"$f":"'Recurring Expenses'!$D$12","v":100},null,{"$f":"'Recurring Expenses'!$D$12","v":100},null,{"$f":"'Recurring Expenses'!$D$12","v":100},null,{"$f":"'Recurring Expenses'!$D$12","v":100},null,null,{"$f":"'Recurring Expenses'!$D$12","v":100},null,{"$f":"'Recurring Expenses'!$D$12","v":100},null,{"$f":"'Recurring Expenses'!$D$12","v":100},null,{"$f":"'Recurring Expenses'!$D$12","v":100},null,{"$f":"'Recurring Expenses'!$D$12","v":100},null,null,{"$f":"'Recurring Expenses'!$D$12","v":100},null,{"$f":"'Recurring Expenses'!$D$12","v":100},{"$f":"SUM(D32:AD32)","v":1300}]
[null,"Public Transportation",null,{"$f":"'Recurring Expenses'!$D$13","v":50},null,{"$f":"'Recurring Expenses'!$D$13","v":50},null,{"$f":"'Recurring Expenses'!$D$13","v":50},null,{"$f":"'Recurring Expenses'!$D$13","v":50},null,{"$f":"'Recurring Expenses'!$D$13","v":50},null,{"$f":"'Recurring Expenses'!$D$13","v":50},null,null,{"$f":"'Recurring Expenses'!$D$13","v":50},null,{"$f":"'Recurring Expenses'!$D$13","v":50},null,{"$f":"'Recurring Expenses'!$D$13","v":50},null,{"$f":"'Recurring Expenses'!$D$13","v":50},null,{"$f":"'Recurring Expenses'!$D$13","v":50},null,null,{"$f":"'Recurring Expenses'!$D$13","v":50},null,{"$f":"'Recurring Expenses'!$D$13","v":50},{"$f":"SUM(D33:AD33)","v":650}]
[null,"Dates",null,{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"'Recurring Expenses'!$D$14","v":30},{"$f":"SUM(D34:AD34)","v":810}]
[null,"Gifts",null,{"$f":"'Recurring Expenses'!$D$15","v":30},null,{"$f":"'Recurring Expenses'!$D$15","v":30},null,{"$f":"'Recurring Expenses'!$D$15","v":30},null,{"$f":"'Recurring Expenses'!$D$15","v":30},null,{"$f":"'Recurring Expenses'!$D$15","v":30},null,{"$f":"'Recurring Expenses'!$D$15","v":30},null,null,{"$f":"'Recurring Expenses'!$D$15","v":30},null,{"$f":"'Recurring Expenses'!$D$15","v":30},null,{"$f":"'Recurring Expenses'!$D$15","v":30},null,{"$f":"'Recurring Expenses'!$D$15","v":30},null,{"$f":"'Recurring Expenses'!$D$15","v":30},null,null,{"$f":"'Recurring Expenses'!$D$15","v":30},null,{"$f":"'Recurring Expenses'!$D$15","v":30},{"$f":"SUM(D35:AD35)","v":390}]
[null,"Doctor/Dental",null,{"$f":"'Recurring Expenses'!$D$16","v":50},null,{"$f":"'Recurring Expenses'!$D$16","v":50},null,{"$f":"'Recurring Expenses'!$D$16","v":50},null,{"$f":"'Recurring Expenses'!$D$16","v":50},null,{"$f":"'Recurring Expenses'!$D$16","v":50},null,{"$f":"'Recurring Expenses'!$D$16","v":50},null,null,{"$f":"'Recurring Expenses'!$D$16","v":50},null,{"$f":"'Recurring Expenses'!$D$16","v":50},null,{"$f":"'Recurring Expenses'!$D$16","v":50},null,{"$f":"'Recurring Expenses'!$D$16","v":50},null,{"$f":"'Recurring Expenses'!$D$16","v":50},null,null,{"$f":"'Recurring Expenses'!$D$16","v":50},null,{"$f":"'Recurring Expenses'!$D$16","v":50},{"$f":"SUM(D36:AD36)","v":650}]
[null,"Health Insurance",null,{"$f":"'Recurring Expenses'!$D$17","v":400},null,{"$f":"'Recurring Expenses'!$D$17","v":400},null,{"$f":"'Recurring Expenses'!$D$17","v":400},null,{"$f":"'Recurring Expenses'!$D$17","v":400},null,{"$f":"'Recurring Expenses'!$D$17","v":400},null,{"$f":"'Recurring Expenses'!$D$17","v":400},null,null,{"$f":"'Recurring Expenses'!$D$17","v":400},null,{"$f":"'Recurring Expenses'!$D$17","v":400},null,{"$f":"'Recurring Expenses'!$D$17","v":400},null,{"$f":"'Recurring Expenses'!$D$17","v":400},null,{"$f":"'Recurring Expenses'!$D$17","v":400},null,null,{"$f":"'Recurring Expenses'!$D$17","v":400},null,{"$f":"'Recurring Expenses'!$D$17","v":400},{"$f":"SUM(D37:AD37)","v":5200}]
[null,"Life Insurance",null,{"$f":"'Recurring Expenses'!$D$18","v":50},null,{"$f":"'Recurring Expenses'!$D$18","v":50},null,{"$f":"'Recurring Expenses'!$D$18","v":50},null,{"$f":"'Recurring Expenses'!$D$18","v":50},null,{"$f":"'Recurring Expenses'!$D$18","v":50},null,{"$f":"'Recurring Expenses'!$D$18","v":50},null,null,{"$f":"'Recurring Expenses'!$D$18","v":50},null,{"$f":"'Recurring Expenses'!$D$18","v":50},null,{"$f":"'Recurring Expenses'!$D$18","v":50},null,{"$f":"'Recurring Expenses'!$D$18","v":50},null,{"$f":"'Recurring Expenses'!$D$18","v":50},null,null,{"$f":"'Recurring Expenses'!$D$18","v":50},null,{"$f":"'Recurring Expenses'!$D$18","v":50},{"$f":"SUM(D38:AD38)","v":650}]
[null,"Vehicle Insurance",null,{"$f":"'Recurring Expenses'!$D$19","v":19},null,{"$f":"'Recurring Expenses'!$D$19","v":19},null,{"$f":"'Recurring Expenses'!$D$19","v":19},null,{"$f":"'Recurring Expenses'!$D$19","v":19},null,{"$f":"'Recurring Expenses'!$D$19","v":19},null,{"$f":"'Recurring Expenses'!$D$19","v":19},null,null,{"$f":"'Recurring Expenses'!$D$19","v":19},null,{"$f":"'Recurring Expenses'!$D$19","v":19},null,{"$f":"'Recurring Expenses'!$D$19","v":19},null,{"$f":"'Recurring Expenses'!$D$19","v":19},null,{"$f":"'Recurring Expenses'!$D$19","v":19},null,null,{"$f":"'Recurring Expenses'!$D$19","v":19},null,{"$f":"'Recurring Expenses'!$D$19","v":19},{"$f":"SUM(D39:AD39)","v":247}]
[null,"School Supplies",null,{"$f":"'Recurring Expenses'!$D$20","v":30},null,{"$f":"'Recurring Expenses'!$D$20","v":30},null,{"$f":"'Recurring Expenses'!$D$20","v":30},null,{"$f":"'Recurring Expenses'!$D$20","v":30},null,{"$f":"'Recurring Expenses'!$D$20","v":30},null,{"$f":"'Recurring Expenses'!$D$20","v":30},null,null,{"$f":"'Recurring Expenses'!$D$20","v":30},null,{"$f":"'Recurring Expenses'!$D$20","v":30},null,{"$f":"'Recurring Expenses'!$D$20","v":30},null,{"$f":"'Recurring Expenses'!$D$20","v":30},null,{"$f":"'Recurring Expenses'!$D$20","v":30},null,null,{"$f":"'Recurring Expenses'!$D$20","v":30},null,{"$f":"'Recurring Expenses'!$D$20","v":30},{"$f":"SUM(D40:AD40)","v":390}]
[null,"Baby Diapers and Wipes",null,{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"'Recurring Expenses'!$D$21","v":30},{"$f":"SUM(D41:AD41)","v":810}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D42:AD42)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D43:AD43)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D44:AD44)","v":0}]
[null,"VARIABLE COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D45:AD45)","v":0}]
[null,"Sporting goods",null,{"$f":"'Recurring Expenses'!$D$25","v":50},null,{"$f":"'Recurring Expenses'!$D$25","v":50},null,{"$f":"'Recurring Expenses'!$D$25","v":50},null,{"$f":"'Recurring Expenses'!$D$25","v":50},null,{"$f":"'Recurring Expenses'!$D$25","v":50},null,{"$f":"'Recurring Expenses'!$D$25","v":50},null,null,{"$f":"'Recurring Expenses'!$D$25","v":50},null,{"$f":"'Recurring Expenses'!$D$25","v":50},null,{"$f":"'Recurring Expenses'!$D$25","v":50},null,{"$f":"'Recurring Expenses'!$D$25","v":50},null,{"$f":"'Recurring Expenses'!$D$25","v":50},null,null,{"$f":"'Recurring Expenses'!$D$25","v":50},null,{"$f":"'Recurring Expenses'!$D$25","v":50},{"$f":"SUM(D46:AD46)","v":650}]
[null,"Snowboarding/Hobbies",null,{"$f":"'Recurring Expenses'!$D$26","v":100},null,{"$f":"'Recurring Expenses'!$D$26","v":100},null,{"$f":"'Recurring Expenses'!$D$26","v":100},null,{"$f":"'Recurring Expenses'!$D$26","v":100},null,{"$f":"'Recurring Expenses'!$D$26","v":100},null,{"$f":"'Recurring Expenses'!$D$26","v":100},null,null,{"$f":"'Recurring Expenses'!$D$26","v":100},null,{"$f":"'Recurring Expenses'!$D$26","v":100},null,{"$f":"'Recurring Expenses'!$D$26","v":100},null,{"$f":"'Recurring Expenses'!$D$26","v":100},null,{"$f":"'Recurring Expenses'!$D$26","v":100},null,null,{"$f":"'Recurring Expenses'!$D$26","v":100},null,{"$f":"'Recurring Expenses'!$D$26","v":100},{"$f":"SUM(D47:AD47)","v":1300}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:AD48)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:AD49)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D50:AD50)","v":0}]
[null,"ONE TIME COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:AD51)","v":0}]
[null,"Tuition/Books",null,null,null,5500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D52:AD52)","v":5500}]
[null,"Birth",null,null,null,null,null,null,null,null,null,null,8000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D53:AD53)","v":8000}]
[null,"Moving expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D54:AD54)","v":500}]
[null,"Christmas Shopping",null,null,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D55:AD55)","v":400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D56:AD56)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D57:AD57)","v":0}]
[null,"SUBTOTAL BEFORE SAVINGS",null,{"$f":"SUM(D23:D57)","v":2318},1074,7818,674,2318,{"$f":"SUM(I23:I57)","v":674},2318,674,2318,{"$f":"SUM(M23:M57)","v":8674},{"$f":"SUM(N23:N57)","v":2318},674,674,2318,674,2318,1174,{"$f":"SUM(U23:U57)","v":2318},674,{"$f":"SUM(W23:W57)","v":2318},{"$f":"SUM(X23:X57)","v":674},2318,{"$f":"SUM(Z23:Z57)","v":674},674,{"$f":"SUM(AB23:AB57)","v":2318},674,2318,{"$f":"SUM(AE23:AE57)","v":53970}]
[null,"Emergency Fund",null,{"$f":"Savings!$D$4","v":50},null,{"$f":"Savings!$D$4","v":50},null,{"$f":"Savings!$D$4","v":50},null,{"$f":"Savings!$D$4","v":50},null,{"$f":"Savings!$D$4","v":50},null,{"$f":"Savings!$D$4","v":50},null,null,{"$f":"Savings!$D$4","v":50},null,{"$f":"Savings!$D$4","v":50},null,{"$f":"Savings!$D$4","v":50},null,{"$f":"Savings!$D$4","v":50},null,{"$f":"Savings!$D$4","v":50},null,null,{"$f":"Savings!$D$4","v":50},null,{"$f":"Savings!$D$4","v":50},{"$f":"SUM(D59:AD59)","v":650}]
[null,"Save for Birth",null,{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"Savings!$D$5","v":500},{"$f":"SUM(D60:AD60)","v":13500}]
[null,"TOTAL CASH PAID OUT",null,{"$f":"D58-SUM(D59:D60)","v":1768},574,7268,174,1768,{"$f":"I58-SUM(I59:I60)","v":174},1768,174,1768,{"$f":"M58-SUM(M59:M60)","v":8174},{"$f":"N58-SUM(N59:N60)","v":1768},174,174,1768,174,1768,674,{"$f":"U58-SUM(U59:U60)","v":1768},174,{"$f":"W58-SUM(W59:W60)","v":1768},{"$f":"X58-SUM(X59:X60)","v":174},1768,{"$f":"Z58-SUM(Z59:Z60)","v":174},174,{"$f":"AB58-SUM(AB59:AB60)","v":1768},174,1768,{"$f":"SUM(AE59:AE60)","v":14150}]
[null,"Cash on hand (end of month)",null,{"$f":"D20-D61","v":13273.4},14087.8,12208.199999999997,13422.599999999997,13042.999999999996,{"$f":"I20-I61","v":16257.399999999998},15877.8,19092.2,18712.600000000002,{"$f":"M20-M61","v":13927.000000000004},{"$f":"N20-N61","v":13547.400000000003},14761.800000000003,17976.200000000004,17596.600000000006,20811.000000000007,20431.400000000009,21145.80000000001,{"$f":"U20-U61","v":20766.200000000012},21980.600000000013,{"$f":"W20-W61","v":21601.000000000015},{"$f":"X20-X61","v":22815.400000000016},22435.800000000017,{"$f":"Z20-Z61","v":23650.200000000019},24864.60000000002,{"$f":"AB20-AB61","v":24485.000000000022},25699.400000000023,25319.800000000025]
[]
[]
[]
[]
[]
[]
[]
[null,"Month Number",null,{"$f":"MONTH(D8)","v":11},12,12,1,1,2,2,3,3,4,{"$f":"MONTH(N8)","v":4},5,5,5,6,6,7,{"$f":"MONTH(U8)","v":7},8,{"$f":"MONTH(W8)","v":8},{"$f":"MONTH(X8)","v":9},9,{"$f":"MONTH(Z8)","v":10},10,{"$f":"MONTH(AB8)","v":10},11,11]
[null,"M for Monthly & Bi-weekly Expenses,\nB for Bi-weekly only",null,"M","B","M","B","M","B","M","B","M","B","M","B","B","M","B","M","B","M","B","M","B","M","B","B","M","B","M"]

{"sheet":"Income","index":1,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null,"Current Income Estimates per pay-check (2 week period)"]
[null,"Job Name","Hours/week","Hours/paycheck","$/hour","Gross Income","Tax %","Taxes","Other Withholdings","Withholdings $$","Cash Inflow"]
[null,"On Campus Job",10,{"$f":"C4*2","v":20},16.5,{"$f":"D4*E4","v":330},0.2,{"$f":"F4*-G4","v":-66},"None",0,{"$f":"SUM(F4,H4,J4)","v":264}]
[null,"Red Robin",40,{"$f":"C5*2","v":80},17,{"$f":"D5*E5","v":1360},0.21,{"$f":"F5*-G5","v":-285.59999999999997},"None",0,{"$f":"SUM(F5,H5,J5)","v":1074.4000000000001}]
[null,"Side Job Name",null,null,null,50,0,{"$f":"F6*-G6","v":0},"None",0,{"$f":"SUM(F6,H6,J6)","v":50}]

{"sheet":"Investments","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Investment Income or sale of assets"]
[null,"Investment Name","Current Value","Date of cash receipt","Income or Liquidation"]
[null,"Ameritrade",8465,"2015-01-05",4000]
[null,"Charles Schwab",4658,"2015-04-09",2000]
[null,"Motorcycle",2000,"2015-06-15",2000]

{"sheet":"Recurring Expenses","index":3,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Fixed Expenses"]
[null,"Fixed Expenses","Monthly or Biweekly?","Amount"]
[null,"Tithing","Biweekly",{"$f":"0.1*SUM(Income!F4:F7)","v":174}]
[null,"Fast offering","Monthly",20]
[null,"Rent","Monthly",695]
[null,"Utilities","Monthly",30]
[null,"Groceries","Biweekly",190]
[null,"Eating out","Biweekly",100]
[null,"Personal-care (haircut, laundry, toiletries, etc.)","Monthly",20]
[null,"Gas","Biweekly",150]
[null,"Vehicle Repairs","Monthly",100]
[null,"Public Transportation","Monthly",50]
[null,"Dates","Biweekly",30]
[null,"Gifts","Monthly",30]
[null,"Doctor/Dental","Monthly",50]
[null,"Health Insurance","Monthly",400]
[null,"Life Insurance","Monthly",50]
[null,"Vehicle Insurance","Monthly",19]
[null,"School Supplies","Monthly",30]
[null,"Baby Diapers and Wipes","Biweekly",30]
[]
[]
[null,"Variable Expenses","Monthly or Biweekly?","Amount"]
[null,"Sporting goods","Monthly",50]
[null,"Snowboarding/Hobbies","Monthly",100]

{"sheet":"One-time Expenses","index":4,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"One-time expenses"]
[null,"Expense","Details","Date of payment","Amount"]
[null,"Tuition/Books","Includes books","2015-01-05",5500]
[null,"Birth","Includes Hospital","2015-04-09",8000]
[null,"Moving expenses",null,"2015-07-15",500]
[null,"Christmas Shopping",null,"2014-12-20",400]

{"sheet":"Savings","index":5,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Savings"]
[null,"Savings Type","Monthly or Biweekly?","Amount"]
[null,"Emergency Fund","Monthly",50]
[null,"Save for Birth","Biweekly",500]

{"sheet":"Bank Balances","index":6,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Current Bank Balances"]
[null,"Checking/Savings Accounts","Net Cash"]
[null,"Chase",5000]
[null,"Wells Fargo",256]
[null,"Bank of America",6874]
[]
[]
[]
[null,"Subtotal",{"$f":"SUM(C4:C9)","v":12130}]
[null,"Credit Cards"]
[null,"Chase",1987]
[null,"Capital One",365]
[null,"Bank of America",125]
[]
[]
[null,"Subtotal",{"$f":"SUM(C11:C16)","v":2477}]
[null,"Total Cash On Hand",{"$f":"C10-C17","v":9653}]