{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Introduction","Budget M1","Budget M2","Budget M3","Budget M4","Budget M5","Budget M6","Budget M7","Budget M8","Budget M9","Budget M10","Budget M11","Budget M12","1 Year Budget","IS M1","IS M3","BS 1","BS 2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"Introduction","index":0,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,3,8]]}
[]
[null,"Teaching Tool 4 - Budget, Balance Sheet, and Income Statements"]
[null,null,null,null,"2019-01-18"]
[null,"Personal Finance: Another Perspective"]
[]
[null,"Purpose:"]
[null,"The purpose of this spreadsheet is to give an Excel template for calculating"]
[null,"budgets, balance sheets, and income statements.  These worksheets are meant to help"]
[null,"you as you develop and live on a budget.  They are not meant to replace good money"]
[null,"management software such as Quicken or Money, but may be helpful as you begin."]
[]
[null,"Budgets:"]
[null,"To begin, go to the Budget M1 worksheet.  In the cell H3, type the month that you will"]
[null,"be beginning the budget in numeric form, i.e., 1 = January, 12 = December.  In "]
[null,"the cell I4, type the year.  Then, each successive budget worksheet will be the sheet"]
[null,"for the next month.  Insert budget amounts in the green cells, insert actual spending in"]
[null,"the white cells under the day the money was spent and in the correct column.  The"]
[null,"blue cells are where the calculations are automatic."]
[]
[null,"Income Statements:"]
[null,"The income statement is the actual column of your budget spreadsheet, so once you have"]
[null,"completed a budget (from Budget M1 and Budget M3), go to tab IS 1 or IS 3 and you "]
[null,"can print off the Income Statement without having to do a thing."]
[]
[null,"Balance Sheets:"]
[null,"The balance sheets are divided into assets and liabilities, with the different types of"]
[null,"assets and liabilities separated out.  Fill out each of the green cells, but do put"]
[null,"any data into the blue cells--they are calculations."]
[]
[null,"Disclosure:"]
[null,"The purpose of this spreadsheet and this class is to help you get your financial house in"]
[null,"order and to help you on your road to financial self-reliance.  If there are mistakes in this "]
[null,"spreadsheet, please bring them to our attention and we will correct them in upcoming "]
[null,"versions.  The teacher, and BYU, specifically disclaim any liability, or responsibility for "]
[null,"claims, loss, or risk incurred, directly or indirectly, from using this material."]

{"sheet":"Budget M1","index":1,"n_rows":108,"n_cols":37,"rows_kept":108,"cut":false,"hidden":false,"merged":[[4,2,4,4],[1,1,1,4]]}
[null,{"$f":"\"TT 04 - Personal Budget for the Month of \"&I3&\", \"&I4","v":"TT 04 - Personal Budget for the Month of January, 2018"},null,null,null,"Type in the information below in the correct columns and only in the green cells"]
[null,"Blue - Do not fill in the blue sections as these are calculated",null,null,null,null,null,"Type Month and Year below:"]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the ",null,null,null,null,"Month #=",1,{"$f":"VLOOKUP(H3,Month,2)","v":"January"}]
[null,"                    red or blue cells.  Print off columns A-D for  your Budget each month.",null,null,null,null,"Year =",null,2018]
[null,null,{"$f":"LEFT(I3,3)&\"-\"&RIGHT(I4,2)","v":"Jan-18"},null,null,null,"Day 1","Day 2","day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16","Day 17","Day 18","Day 19","Day 20","Day 21","Day 22","Day 23","Day 24","Day 25","Day 26","Day 27","Day 28","Day 29","Day 30","Day 31"]
[null,"  [Ctrl][Shift] T will set your titles",null,"Income"]
[null,"  [Ctrl][Shift] C will clear your titles","Budget","Statement","Difference"]
[]
[null,"Income"]
[null,"Wage Earner 1",null,{"$f":"SUM(G10:AK10)","v":0},{"$f":"D10-C10","v":0}]
[null,"Wage Earner 2",null,{"$f":"SUM(G11:AK11)","v":0},0]
[null,"= Total Wages and salaries",{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},0]
[null,"+ Other (Type in another source here)",null,{"$f":"SUM(G13:AK13)","v":0},0]
[null,"+ Other (Type in another source here)",null,{"$f":"SUM(G14:AK14)","v":0},0]
[null,"Total Income ( A )",{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0}]
[]
[null,"Deductions (Before and After Tax)"]
[null,"   -  Federal and State Taxes",null,{"$f":"SUM(G18:AK18)","v":0},{"$f":"D18-C18","v":0}]
[null,"    -  Social Security Taxes",null,{"$f":"SUM(G19:AK19)","v":0},{"$f":"D19-C19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",null,{"$f":"SUM(G20:AK20)","v":0},{"$f":"D20-C20","v":0}]
[null,"    -  Medical Plan Deductions (E)",null,{"$f":"SUM(G21:AK21)","v":0},{"$f":"D21-C21","v":0}]
[null,"    -  Other (type in another deduction here)",null,{"$f":"SUM(G22:AK22)","v":0},{"$f":"D22-C22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0},{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0}]
[null,"      Take-Home Pay (A - B - C - E)",{"$f":"C15-C23","v":0},{"$f":"D15-D23","v":0},{"$f":"E15-E23","v":0}]
[null,"(Income for Living Expenses)"]
[null,null,null,"Actual"]
[null,null,"Budget ","Spending","Difference"]
[null,"Paying the Lord"]
[null,"-  Tithing",null,{"$f":"SUM(G29:AK29)","v":0},{"$f":"C29-D29","v":0}]
[null,"-  Fast and Other Offerings",null,{"$f":"SUM(G30:AK30)","v":0},{"$f":"C30-D30","v":0}]
[null,"-  Other Contributions (type in other contributions here)",null,{"$f":"SUM(G31:AK31)","v":0},{"$f":"C31-D31","v":0}]
[null,"  Total Paying the Lord ( D )",{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0}]
[]
[null,"Paying Yourself"]
[null,"-  Retirement Savings (from (C) deductions above)",{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0}]
[null,"- Other Savings (type in other contributions here)",null,{"$f":"SUM(G36:AK36)","v":0},{"$f":"C36-D36","v":0}]
[null,"  Total Paying Yourself ( E )",{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0}]
[]
[null,"Living Expenses"]
[null,"-  Housing/Rent",null,{"$f":"SUM(G40:AK40)","v":0},{"$f":"C40-D40","v":0}]
[null,"- Utilities",null,0,{"$f":"C41-D41","v":0}]
[null,"- Other Living Expenses (type in other living here)",null,0,0]
[null,"  Total Housing Expenditures ( F )",{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0}]
[]
[null,"Food"]
[null,"-  Food and Supplies",null,{"$f":"SUM(G46:AK46)","v":0},{"$f":"C46-D46","v":0}]
[null,"-  Restaurant Expenses",null,{"$f":"SUM(G47:AK47)","v":0},{"$f":"C47-D47","v":0}]
[null,"-  Food (type in other food here)",null,{"$f":"SUM(G48:AK48)","v":0},{"$f":"C48-D48","v":0}]
[null,"  Total Food Expenditures ( G )",{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0}]
[]
[null,"Clothing and Personal Care"]
[null,"-  Clothing",null,{"$f":"SUM(G52:AK52)","v":0},{"$f":"C52-D52","v":0}]
[null,"-  Other (type in other personal here)",null,0,0]
[null,"  Total Clothing/Personal Care Expenses ( H )",{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},{"$f":"SUM(E51:E53)","v":0}]
[]
[null,"Transportation"]
[null,"-  Automobile",null,{"$f":"SUM(G57:AK57)","v":0},{"$f":"C57-D57","v":0}]
[null,"-  Gas, Tolls, Parking",null,0,0]
[null,"-  Other (type in other transportation here)",null,0,0]
[null,"  Total Transportation Expenditures ( I )",{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0},{"$f":"SUM(E56:E59)","v":0}]
[]
[null,"Recreation"]
[null,"-  Movies, Theater, Sporting Events",null,{"$f":"SUM(G63:AK63)","v":0},{"$f":"C63-D63","v":0}]
[null,"-  Other (type in other recreation here)",null,{"$f":"SUM(G64:AK64)","v":0},{"$f":"C64-D64","v":0}]
[null,"  Total Recreation Expenditures ( J )",{"$f":"SUM(C62:C64)","v":0},{"$f":"SUM(D62:D64)","v":0},{"$f":"SUM(E62:E64)","v":0}]
[]
[null,"Medical Expenditures"]
[null,"  -  Medical/Dental Expenses (from (E) deductions above)",{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0}]
[null,"-  Other Medical (type in other medical here)",null,{"$f":"SUM(G69:AK69)","v":0},{"$f":"C69-D69","v":0}]
[null,"  Total Medical Expenditures ( K )",{"$f":"SUM(C67:C69)","v":0},{"$f":"SUM(D67:D69)","v":0},{"$f":"SUM(E67:E69)","v":0}]
[]
[null,"Insurance Expenditures"]
[null,"- Health and Life",null,{"$f":"SUM(G73:AK73)","v":0},{"$f":"C73-D73","v":0}]
[null,"- Automobile",null,0,0]
[null,"- Other (type in other insurance here)",null,0,0]
[null,"  Total Insurance Expenditures ( L )",{"$f":"SUM(C72:C75)","v":0},{"$f":"SUM(D72:D75)","v":0},{"$f":"SUM(E72:E75)","v":0}]
[]
[null,"Other Expenditures"]
[null,"-  Education",null,{"$f":"SUM(G79:AK79)","v":0},{"$f":"C79-D79","v":0}]
[null,"- Child Care",null,{"$f":"SUM(G80:AK80)","v":0},0]
[null,"- Other Expenses (type in other expenses here)",null,{"$f":"SUM(G81:AK81)","v":0},0]
[null,"  Total Other Expenditures ( M )",{"$f":"SUM(C79:C81)","v":0},{"$f":"SUM(D79:D81)","v":0},0]
[]
[null,"Total Living Expenditures (add lines D - M)",{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0},{"$f":"D82+D76+D70+D65+D60+D54+D49+D43+D37+D32","v":0},{"$f":"E82+E76+E70+E65+E60+E54+E49+E43+E37+E32","v":0}]
[]
[null,"Additional Income Available for Savings and Investment",{"$f":"C24-C84","v":0},{"$f":"D24-D84","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,1,"January"]
[null,null,2,"February"]
[null,null,3,"March"]
[null,null,4,"April"]
[null,null,5,"May"]
[null,null,6,"June"]
[null,null,7,"July"]
[null,null,8,"August"]
[null,null,9,"September"]
[null,null,10,"October"]
[null,null,11,"November"]
[null,null,12,"December"]
[]
[null,null,{"$f":"DAY(TODAY())","v":17}]
[null,null,{"$f":"C106-1","v":16}]
[null,null,"Budget Month 1"]

{"sheet":"Budget M2","index":2,"n_rows":107,"n_cols":37,"rows_kept":107,"cut":false,"hidden":false,"merged":[[4,2,4,4],[1,1,1,4]]}
[null,{"$f":"\"TT 04 - Personal Budget for the Month of \"&I3&\", \"&I4","v":"TT 04 - Personal Budget for the Month of February, 2018"},null,null,null,"Type in the information below in the correct columns"]
[null,null,null,null,null,null,null,"Type Month and Year below:"]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the ",null,null,null,null,"Month #=",{"$f":"IF('Budget M1'!H3>=12,1,'Budget M1'!H3+1)","v":2},{"$f":"VLOOKUP(H3,Month,2)","v":"February"}]
[null,"                    red or blue cells.  Print off columns A-D for  your Budget each month.",null,null,null,null,"Year =",null,{"$f":"IF('Budget M1'!H3=12,'Budget M1'!I4+1,'Budget M1'!I4)","v":2018}]
[null,null,{"$f":"LEFT(I3,3)&\"-\"&RIGHT(I4,2)","v":"Feb-18"},null,null,null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16","Day 17","Day 18","Day 19","Day 20","Day 21","Day 22","Day 23","Day 24","Day 25","Day 26","Day 27","Day 28","Day 29","Day 30","Day 31"]
[null,"  [Ctrl][Shift] T will set your titles",null,"Income"]
[null,"  [Ctrl][Shift] C will clear your titles","Budget","Statement","Difference"]
[]
[null,"Income"]
[null,{"$f":"'Budget M1'!B10","v":"Wage Earner 1"},null,{"$f":"SUM(G10:AK10)","v":0},{"$f":"D10-C10","v":0}]
[null,{"$f":"'Budget M1'!B11","v":"Wage Earner 2"},null,{"$f":"SUM(G11:AK11)","v":0},0]
[null,{"$f":"'Budget M1'!B12","v":"= Total Wages and salaries"},{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},0]
[null,{"$f":"'Budget M1'!B13","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G13:AK13)","v":0},0]
[null,{"$f":"'Budget M1'!B14","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G14:AK14)","v":0},0]
[null,{"$f":"'Budget M1'!B15","v":"Total Income ( A )"},{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0}]
[]
[null,{"$f":"'Budget M1'!B17","v":"Deductions (Before and After Tax)"}]
[null,"   -  Federal and State Taxes",null,{"$f":"SUM(G18:AK18)","v":0},{"$f":"D18-C18","v":0}]
[null,"    -  Social Security Taxes",null,{"$f":"SUM(G19:AK19)","v":0},{"$f":"D19-C19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",null,{"$f":"SUM(G20:AK20)","v":0},{"$f":"D20-C20","v":0}]
[null,"    -  Medical Plan Deductions (E)",null,{"$f":"SUM(G21:AK21)","v":0},{"$f":"D21-C21","v":0}]
[null,{"$f":"'Budget M1'!B22","v":"    -  Other (type in another deduction here)"},null,{"$f":"SUM(G22:AK22)","v":0},{"$f":"D22-C22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0},{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0}]
[null,"      Take-Home Pay (A - B - C)",{"$f":"C15-C23","v":0},{"$f":"D15-D23","v":0},{"$f":"E15-E23","v":0}]
[null,{"$f":"'Budget M1'!B25","v":"(Income for Living Expenses)"}]
[null,null,"Budget ","Actual"]
[null,null,"Amount","Spending","Difference"]
[null,{"$f":"'Budget M1'!B28","v":"Paying the Lord"}]
[null,{"$f":"'Budget M1'!B29","v":"-  Tithing"},null,{"$f":"SUM(G29:AK29)","v":0},{"$f":"C29-D29","v":0}]
[null,{"$f":"'Budget M1'!B30","v":"-  Fast and Other Offerings"},null,{"$f":"SUM(G30:AK30)","v":0},{"$f":"C30-D30","v":0}]
[null,{"$f":"'Budget M1'!B31","v":"-  Other Contributions (type in other contributions here)"},null,{"$f":"SUM(G31:AK31)","v":0},{"$f":"C31-D31","v":0}]
[null,{"$f":"'Budget M1'!B32","v":"  Total Paying the Lord ( D )"},{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0}]
[]
[null,{"$f":"'Budget M1'!B34","v":"Paying Yourself"}]
[null,{"$f":"'Budget M1'!B35","v":"-  Retirement Savings (from (C) deductions above)"},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0}]
[null,{"$f":"'Budget M1'!B36","v":"- Other Savings (type in other contributions here)"},null,{"$f":"SUM(G36:AK36)","v":0},{"$f":"C36-D36","v":0}]
[null,{"$f":"'Budget M1'!B37","v":"  Total Paying Yourself ( E )"},{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0}]
[]
[null,{"$f":"'Budget M1'!B39","v":"Living Expenses"}]
[null,"-  Housing/Rent",null,{"$f":"SUM(G40:AK40)","v":0},{"$f":"C40-D40","v":0}]
[null,{"$f":"'Budget M1'!B41","v":"- Utilities"},null,0,{"$f":"C41-D41","v":0}]
[null,{"$f":"'Budget M1'!B42","v":"- Other Living Expenses (type in other living here)"},null,0,0]
[null,{"$f":"'Budget M1'!B43","v":"  Total Housing Expenditures ( F )"},{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0}]
[]
[null,{"$f":"'Budget M1'!B45","v":"Food"}]
[null,{"$f":"'Budget M1'!B46","v":"-  Food and Supplies"},null,{"$f":"SUM(G46:AK46)","v":0},{"$f":"C46-D46","v":0}]
[null,{"$f":"'Budget M1'!B47","v":"-  Restaurant Expenses"},null,{"$f":"SUM(G47:AK47)","v":0},{"$f":"C47-D47","v":0}]
[null,{"$f":"'Budget M1'!B48","v":"-  Food (type in other food here)"},null,{"$f":"SUM(G48:AK48)","v":0},{"$f":"C48-D48","v":0}]
[null,{"$f":"'Budget M1'!B49","v":"  Total Food Expenditures ( G )"},{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0}]
[]
[null,{"$f":"'Budget M1'!B51","v":"Clothing and Personal Care"}]
[null,"-  Clothing",null,{"$f":"SUM(G52:AK52)","v":0},{"$f":"C52-D52","v":0}]
[null,{"$f":"'Budget M1'!B53","v":"-  Other (type in other personal here)"},null,0,0]
[null,{"$f":"'Budget M1'!B54","v":"  Total Clothing/Personal Care Expenses ( H )"},{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},{"$f":"SUM(E51:E53)","v":0}]
[]
[null,{"$f":"'Budget M1'!B56","v":"Transportation"}]
[null,"-  Automobile",null,{"$f":"SUM(G57:AK57)","v":0},{"$f":"C57-D57","v":0}]
[null,{"$f":"'Budget M1'!B58","v":"-  Gas, Tolls, Parking"},null,0,0]
[null,{"$f":"'Budget M1'!B59","v":"-  Other (type in other transportation here)"},null,0,0]
[null,{"$f":"'Budget M1'!B60","v":"  Total Transportation Expenditures ( I )"},{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0},{"$f":"SUM(E56:E59)","v":0}]
[]
[null,{"$f":"'Budget M1'!B62","v":"Recreation"}]
[null,{"$f":"'Budget M1'!B63","v":"-  Movies, Theater, Sporting Events"},null,{"$f":"SUM(G63:AK63)","v":0},{"$f":"C63-D63","v":0}]
[null,{"$f":"'Budget M1'!B64","v":"-  Other (type in other recreation here)"},null,{"$f":"SUM(G64:AK64)","v":0},{"$f":"C64-D64","v":0}]
[null,{"$f":"'Budget M1'!B65","v":"  Total Recreation Expenditures ( J )"},{"$f":"SUM(C62:C64)","v":0},{"$f":"SUM(D62:D64)","v":0},{"$f":"SUM(E62:E64)","v":0}]
[]
[null,{"$f":"'Budget M1'!B67","v":"Medical Expenditures"}]
[null,{"$f":"'Budget M1'!B68","v":"  -  Medical/Dental Expenses (from (E) deductions above)"},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0}]
[null,{"$f":"'Budget M1'!B69","v":"-  Other Medical (type in other medical here)"},null,{"$f":"SUM(G69:AK69)","v":0},{"$f":"C69-D69","v":0}]
[null,{"$f":"'Budget M1'!B70","v":"  Total Medical Expenditures ( K )"},{"$f":"SUM(C67:C69)","v":0},{"$f":"SUM(D67:D69)","v":0},{"$f":"SUM(E67:E69)","v":0}]
[]
[null,{"$f":"'Budget M1'!B72","v":"Insurance Expenditures"}]
[null,"- Health and Life",null,{"$f":"SUM(G73:AK73)","v":0},{"$f":"C73-D73","v":0}]
[null,{"$f":"'Budget M1'!B74","v":"- Automobile"},null,0,0]
[null,{"$f":"'Budget M1'!B75","v":"- Other (type in other insurance here)"},null,0,0]
[null,{"$f":"'Budget M1'!B76","v":"  Total Insurance Expenditures ( L )"},{"$f":"SUM(C72:C75)","v":0},{"$f":"SUM(D72:D75)","v":0},{"$f":"SUM(E72:E75)","v":0}]
[]
[null,{"$f":"'Budget M1'!B78","v":"Other Expenditures"}]
[null,"-  Education",null,{"$f":"SUM(G79:AK79)","v":0},{"$f":"C79-D79","v":0}]
[null,{"$f":"'Budget M1'!B80","v":"- Child Care"},null,{"$f":"SUM(G80:AK80)","v":0},0]
[null,{"$f":"'Budget M1'!B81","v":"- Other Expenses (type in other expenses here)"},null,{"$f":"SUM(G81:AK81)","v":0},0]
[null,{"$f":"'Budget M1'!B82","v":"  Total Other Expenditures ( M )"},{"$f":"SUM(C79:C81)","v":0},{"$f":"SUM(D79:D81)","v":0},0]
[]
[null,{"$f":"'Budget M1'!B84","v":"Total Living Expenditures (add lines D - M)"},{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0},{"$f":"D82+D76+D70+D65+D60+D54+D49+D43+D37+D32","v":0},{"$f":"E82+E76+E70+E65+E60+E54+E49+E43+E37+E32","v":0}]
[]
[null,{"$f":"'Budget M1'!B86","v":"Additional Income Available for Savings and Investment"},{"$f":"C24-C84","v":0},{"$f":"D24-D84","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,1,"January"]
[null,null,2,"February"]
[null,null,3,"March"]
[null,null,4,"April"]
[null,null,5,"May"]
[null,null,6,"June"]
[null,null,7,"July"]
[null,null,8,"August"]
[null,null,9,"September"]
[null,null,10,"October"]
[null,null,11,"November"]
[null,null,12,"December"]
[]
[null,null,{"$f":"DAY(TODAY())","v":17}]
[null,null,{"$f":"C106-1","v":16}]

{"sheet":"Budget M3","index":3,"n_rows":107,"n_cols":37,"rows_kept":107,"cut":false,"hidden":false,"merged":[[4,2,4,4],[1,1,1,4]]}
[null,{"$f":"\"TT 04 - Personal Budget for the Month of \"&I3&\", \"&I4","v":"TT 04 - Personal Budget for the Month of March, 2018"},null,null,null,"Type in the information below in the correct columns"]
[null,null,null,null,null,null,null,"Type Month and Year below:"]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the ",null,null,null,null,"Month #=",{"$f":"IF('Budget M2'!H3>=12,1,'Budget M2'!H3+1)","v":3},{"$f":"VLOOKUP(H3,Month,2)","v":"March"}]
[null,"                    red or blue cells.  Print off columns A-D for  your Budget each month.",null,null,null,null,"Year =",null,{"$f":"IF('Budget M2'!H3=12,'Budget M2'!I4+1,'Budget M2'!I4)","v":2018}]
[null,null,{"$f":"LEFT(I3,3)&\"-\"&RIGHT(I4,2)","v":"Mar-18"},null,null,null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16","Day 17","Day 18","Day 19","Day 20","Day 21","Day 22","Day 23","Day 24","Day 25","Day 26","Day 27","Day 28","Day 29","Day 30","Day 31"]
[null,"  [Ctrl][Shift] T will set your titles",null,"Income"]
[null,"  [Ctrl][Shift] C will clear your titles","Budget","Statement","Difference"]
[]
[null,"Income"]
[null,{"$f":"'Budget M1'!B10","v":"Wage Earner 1"},null,{"$f":"SUM(G10:AK10)","v":0},{"$f":"D10-C10","v":0}]
[null,{"$f":"'Budget M1'!B11","v":"Wage Earner 2"},null,{"$f":"SUM(G11:AK11)","v":0},0]
[null,{"$f":"'Budget M1'!B12","v":"= Total Wages and salaries"},{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},0]
[null,{"$f":"'Budget M1'!B13","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G13:AK13)","v":0},0]
[null,{"$f":"'Budget M1'!B14","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G14:AK14)","v":0},0]
[null,{"$f":"'Budget M1'!B15","v":"Total Income ( A )"},{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0}]
[]
[null,{"$f":"'Budget M1'!B17","v":"Deductions (Before and After Tax)"}]
[null,"   -  Federal and State Taxes",null,{"$f":"SUM(G18:AK18)","v":0},{"$f":"D18-C18","v":0}]
[null,"    -  Social Security Taxes",null,{"$f":"SUM(G19:AK19)","v":0},{"$f":"D19-C19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",null,{"$f":"SUM(G20:AK20)","v":0},{"$f":"D20-C20","v":0}]
[null,"    -  Medical Plan Deductions (E)",null,{"$f":"SUM(G21:AK21)","v":0},{"$f":"D21-C21","v":0}]
[null,{"$f":"'Budget M1'!B22","v":"    -  Other (type in another deduction here)"},null,{"$f":"SUM(G22:AK22)","v":0},{"$f":"D22-C22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0},{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0}]
[null,"      Take-Home Pay (A - B - C)",{"$f":"C15-C23","v":0},{"$f":"D15-D23","v":0},{"$f":"E15-E23","v":0}]
[null,{"$f":"'Budget M1'!B25","v":"(Income for Living Expenses)"}]
[null,null,"Budget ","Actual"]
[null,null,"Amount","Spending","Difference"]
[null,{"$f":"'Budget M1'!B28","v":"Paying the Lord"}]
[null,{"$f":"'Budget M1'!B29","v":"-  Tithing"},null,{"$f":"SUM(G29:AK29)","v":0},{"$f":"C29-D29","v":0}]
[null,{"$f":"'Budget M1'!B30","v":"-  Fast and Other Offerings"},null,{"$f":"SUM(G30:AK30)","v":0},{"$f":"C30-D30","v":0}]
[null,{"$f":"'Budget M1'!B31","v":"-  Other Contributions (type in other contributions here)"},null,{"$f":"SUM(G31:AK31)","v":0},{"$f":"C31-D31","v":0}]
[null,{"$f":"'Budget M1'!B32","v":"  Total Paying the Lord ( D )"},{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0}]
[]
[null,{"$f":"'Budget M1'!B34","v":"Paying Yourself"}]
[null,{"$f":"'Budget M1'!B35","v":"-  Retirement Savings (from (C) deductions above)"},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0}]
[null,{"$f":"'Budget M1'!B36","v":"- Other Savings (type in other contributions here)"},null,{"$f":"SUM(G36:AK36)","v":0},{"$f":"C36-D36","v":0}]
[null,{"$f":"'Budget M1'!B37","v":"  Total Paying Yourself ( E )"},{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0}]
[]
[null,{"$f":"'Budget M1'!B39","v":"Living Expenses"}]
[null,"-  Housing/Rent",null,{"$f":"SUM(G40:AK40)","v":0},{"$f":"C40-D40","v":0}]
[null,{"$f":"'Budget M1'!B41","v":"- Utilities"},null,0,{"$f":"C41-D41","v":0}]
[null,{"$f":"'Budget M1'!B42","v":"- Other Living Expenses (type in other living here)"},null,0,0]
[null,{"$f":"'Budget M1'!B43","v":"  Total Housing Expenditures ( F )"},{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0}]
[]
[null,{"$f":"'Budget M1'!B45","v":"Food"}]
[null,{"$f":"'Budget M1'!B46","v":"-  Food and Supplies"},null,{"$f":"SUM(G46:AK46)","v":0},{"$f":"C46-D46","v":0}]
[null,{"$f":"'Budget M1'!B47","v":"-  Restaurant Expenses"},null,{"$f":"SUM(G47:AK47)","v":0},{"$f":"C47-D47","v":0}]
[null,{"$f":"'Budget M1'!B48","v":"-  Food (type in other food here)"},null,{"$f":"SUM(G48:AK48)","v":0},{"$f":"C48-D48","v":0}]
[null,{"$f":"'Budget M1'!B49","v":"  Total Food Expenditures ( G )"},{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0}]
[]
[null,{"$f":"'Budget M1'!B51","v":"Clothing and Personal Care"}]
[null,"-  Clothing",null,{"$f":"SUM(G52:AK52)","v":0},{"$f":"C52-D52","v":0}]
[null,{"$f":"'Budget M1'!B53","v":"-  Other (type in other personal here)"},null,0,0]
[null,{"$f":"'Budget M1'!B54","v":"  Total Clothing/Personal Care Expenses ( H )"},{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},{"$f":"SUM(E51:E53)","v":0}]
[]
[null,{"$f":"'Budget M1'!B56","v":"Transportation"}]
[null,"-  Automobile",null,{"$f":"SUM(G57:AK57)","v":0},{"$f":"C57-D57","v":0}]
[null,{"$f":"'Budget M1'!B58","v":"-  Gas, Tolls, Parking"},null,0,0]
[null,{"$f":"'Budget M1'!B59","v":"-  Other (type in other transportation here)"},null,0,0]
[null,{"$f":"'Budget M1'!B60","v":"  Total Transportation Expenditures ( I )"},{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0},{"$f":"SUM(E56:E59)","v":0}]
[]
[null,{"$f":"'Budget M1'!B62","v":"Recreation"}]
[null,{"$f":"'Budget M1'!B63","v":"-  Movies, Theater, Sporting Events"},null,{"$f":"SUM(G63:AK63)","v":0},{"$f":"C63-D63","v":0}]
[null,{"$f":"'Budget M1'!B64","v":"-  Other (type in other recreation here)"},null,{"$f":"SUM(G64:AK64)","v":0},{"$f":"C64-D64","v":0}]
[null,{"$f":"'Budget M1'!B65","v":"  Total Recreation Expenditures ( J )"},{"$f":"SUM(C62:C64)","v":0},{"$f":"SUM(D62:D64)","v":0},{"$f":"SUM(E62:E64)","v":0}]
[]
[null,{"$f":"'Budget M1'!B67","v":"Medical Expenditures"}]
[null,{"$f":"'Budget M1'!B68","v":"  -  Medical/Dental Expenses (from (E) deductions above)"},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0}]
[null,{"$f":"'Budget M1'!B69","v":"-  Other Medical (type in other medical here)"},null,{"$f":"SUM(G69:AK69)","v":0},{"$f":"C69-D69","v":0}]
[null,{"$f":"'Budget M1'!B70","v":"  Total Medical Expenditures ( K )"},{"$f":"SUM(C67:C69)","v":0},{"$f":"SUM(D67:D69)","v":0},{"$f":"SUM(E67:E69)","v":0}]
[]
[null,{"$f":"'Budget M1'!B72","v":"Insurance Expenditures"}]
[null,"- Health and Life",null,{"$f":"SUM(G73:AK73)","v":0},{"$f":"C73-D73","v":0}]
[null,{"$f":"'Budget M1'!B74","v":"- Automobile"},null,0,0]
[null,{"$f":"'Budget M1'!B75","v":"- Other (type in other insurance here)"},null,0,0]
[null,{"$f":"'Budget M1'!B76","v":"  Total Insurance Expenditures ( L )"},{"$f":"SUM(C72:C75)","v":0},{"$f":"SUM(D72:D75)","v":0},{"$f":"SUM(E72:E75)","v":0}]
[]
[null,{"$f":"'Budget M1'!B78","v":"Other Expenditures"}]
[null,"-  Education",null,{"$f":"SUM(G79:AK79)","v":0},{"$f":"C79-D79","v":0}]
[null,{"$f":"'Budget M1'!B80","v":"- Child Care"},null,{"$f":"SUM(G80:AK80)","v":0},0]
[null,{"$f":"'Budget M1'!B81","v":"- Other Expenses (type in other expenses here)"},null,{"$f":"SUM(G81:AK81)","v":0},0]
[null,{"$f":"'Budget M1'!B82","v":"  Total Other Expenditures ( M )"},{"$f":"SUM(C79:C81)","v":0},{"$f":"SUM(D79:D81)","v":0},0]
[]
[null,{"$f":"'Budget M1'!B84","v":"Total Living Expenditures (add lines D - M)"},{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0},{"$f":"D82+D76+D70+D65+D60+D54+D49+D43+D37+D32","v":0},{"$f":"E82+E76+E70+E65+E60+E54+E49+E43+E37+E32","v":0}]
[]
[null,{"$f":"'Budget M1'!B86","v":"Additional Income Available for Savings and Investment"},{"$f":"C24-C84","v":0},{"$f":"D24-D84","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,1,"January"]
[null,null,2,"February"]
[null,null,3,"March"]
[null,null,4,"April"]
[null,null,5,"May"]
[null,null,6,"June"]
[null,null,7,"July"]
[null,null,8,"August"]
[null,null,9,"September"]
[null,null,10,"October"]
[null,null,11,"November"]
[null,null,12,"December"]
[]
[null,null,{"$f":"DAY(TODAY())","v":17}]
[null,null,{"$f":"C106-1","v":16}]

{"sheet":"Budget M4","index":4,"n_rows":107,"n_cols":37,"rows_kept":107,"cut":false,"hidden":false,"merged":[[4,2,4,4],[1,1,1,4]]}
[null,{"$f":"\"TT 04 - Personal Budget for the Month of \"&I3&\", \"&I4","v":"TT 04 - Personal Budget for the Month of April, 2018"},null,null,null,"Type in the information below in the correct columns"]
[null,null,null,null,null,null,null,"Type Month and Year below:"]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the ",null,null,null,null,"Month #=",{"$f":"IF('Budget M3'!H3>=12,1,'Budget M3'!H3+1)","v":4},{"$f":"VLOOKUP(H3,Month,2)","v":"April"}]
[null,"                    red or blue cells.  Print off columns A-D for  your Budget each month.",null,null,null,null,"Year =",null,{"$f":"IF('Budget M3'!H3=12,'Budget M3'!I4+1,'Budget M3'!I4)","v":2018}]
[null,null,{"$f":"LEFT(I3,3)&\"-\"&RIGHT(I4,2)","v":"Apr-18"},null,null,null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16","Day 17","Day 18","Day 19","Day 20","Day 21","Day 22","Day 23","Day 24","Day 25","Day 26","Day 27","Day 28","Day 29","Day 30","Day 31"]
[null,"  [Ctrl][Shift] T will set your titles",null,"Income"]
[null,"  [Ctrl][Shift] C will clear your titles","Budget","Statement","Difference"]
[]
[null,"Income"]
[null,{"$f":"'Budget M1'!B10","v":"Wage Earner 1"},null,{"$f":"SUM(G10:AK10)","v":0},{"$f":"D10-C10","v":0}]
[null,{"$f":"'Budget M1'!B11","v":"Wage Earner 2"},null,{"$f":"SUM(G11:AK11)","v":0},0]
[null,{"$f":"'Budget M1'!B12","v":"= Total Wages and salaries"},{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},0]
[null,{"$f":"'Budget M1'!B13","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G13:AK13)","v":0},0]
[null,{"$f":"'Budget M1'!B14","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G14:AK14)","v":0},0]
[null,{"$f":"'Budget M1'!B15","v":"Total Income ( A )"},{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0}]
[]
[null,{"$f":"'Budget M1'!B17","v":"Deductions (Before and After Tax)"}]
[null,"   -  Federal and State Taxes",null,{"$f":"SUM(G18:AK18)","v":0},{"$f":"D18-C18","v":0}]
[null,"    -  Social Security Taxes",null,{"$f":"SUM(G19:AK19)","v":0},{"$f":"D19-C19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",null,{"$f":"SUM(G20:AK20)","v":0},{"$f":"D20-C20","v":0}]
[null,"    -  Medical Plan Deductions (E)",null,{"$f":"SUM(G21:AK21)","v":0},{"$f":"D21-C21","v":0}]
[null,{"$f":"'Budget M1'!B22","v":"    -  Other (type in another deduction here)"},null,{"$f":"SUM(G22:AK22)","v":0},{"$f":"D22-C22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0},{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0}]
[null,"      Take-Home Pay (A - B - C)",{"$f":"C15-C23","v":0},{"$f":"D15-D23","v":0},{"$f":"E15-E23","v":0}]
[null,{"$f":"'Budget M1'!B25","v":"(Income for Living Expenses)"}]
[null,null,"Budget ","Actual"]
[null,null,"Amount","Spending","Difference"]
[null,{"$f":"'Budget M1'!B28","v":"Paying the Lord"}]
[null,{"$f":"'Budget M1'!B29","v":"-  Tithing"},null,{"$f":"SUM(G29:AK29)","v":0},{"$f":"C29-D29","v":0}]
[null,{"$f":"'Budget M1'!B30","v":"-  Fast and Other Offerings"},null,{"$f":"SUM(G30:AK30)","v":0},{"$f":"C30-D30","v":0}]
[null,{"$f":"'Budget M1'!B31","v":"-  Other Contributions (type in other contributions here)"},null,{"$f":"SUM(G31:AK31)","v":0},{"$f":"C31-D31","v":0}]
[null,{"$f":"'Budget M1'!B32","v":"  Total Paying the Lord ( D )"},{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0}]
[]
[null,{"$f":"'Budget M1'!B34","v":"Paying Yourself"}]
[null,{"$f":"'Budget M1'!B35","v":"-  Retirement Savings (from (C) deductions above)"},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0}]
[null,{"$f":"'Budget M1'!B36","v":"- Other Savings (type in other contributions here)"},null,{"$f":"SUM(G36:AK36)","v":0},{"$f":"C36-D36","v":0}]
[null,{"$f":"'Budget M1'!B37","v":"  Total Paying Yourself ( E )"},{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0}]
[]
[null,{"$f":"'Budget M1'!B39","v":"Living Expenses"}]
[null,"-  Housing/Rent",null,{"$f":"SUM(G40:AK40)","v":0},{"$f":"C40-D40","v":0}]
[null,{"$f":"'Budget M1'!B41","v":"- Utilities"},null,0,{"$f":"C41-D41","v":0}]
[null,{"$f":"'Budget M1'!B42","v":"- Other Living Expenses (type in other living here)"},null,0,0]
[null,{"$f":"'Budget M1'!B43","v":"  Total Housing Expenditures ( F )"},{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0}]
[]
[null,{"$f":"'Budget M1'!B45","v":"Food"}]
[null,{"$f":"'Budget M1'!B46","v":"-  Food and Supplies"},null,{"$f":"SUM(G46:AK46)","v":0},{"$f":"C46-D46","v":0}]
[null,{"$f":"'Budget M1'!B47","v":"-  Restaurant Expenses"},null,{"$f":"SUM(G47:AK47)","v":0},{"$f":"C47-D47","v":0}]
[null,{"$f":"'Budget M1'!B48","v":"-  Food (type in other food here)"},null,{"$f":"SUM(G48:AK48)","v":0},{"$f":"C48-D48","v":0}]
[null,{"$f":"'Budget M1'!B49","v":"  Total Food Expenditures ( G )"},{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0}]
[]
[null,{"$f":"'Budget M1'!B51","v":"Clothing and Personal Care"}]
[null,"-  Clothing",null,{"$f":"SUM(G52:AK52)","v":0},{"$f":"C52-D52","v":0}]
[null,{"$f":"'Budget M1'!B53","v":"-  Other (type in other personal here)"},null,0,0]
[null,{"$f":"'Budget M1'!B54","v":"  Total Clothing/Personal Care Expenses ( H )"},{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},{"$f":"SUM(E51:E53)","v":0}]
[]
[null,{"$f":"'Budget M1'!B56","v":"Transportation"}]
[null,"-  Automobile",null,{"$f":"SUM(G57:AK57)","v":0},{"$f":"C57-D57","v":0}]
[null,{"$f":"'Budget M1'!B58","v":"-  Gas, Tolls, Parking"},null,0,0]
[null,{"$f":"'Budget M1'!B59","v":"-  Other (type in other transportation here)"},null,0,0]
[null,{"$f":"'Budget M1'!B60","v":"  Total Transportation Expenditures ( I )"},{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0},{"$f":"SUM(E56:E59)","v":0}]
[]
[null,{"$f":"'Budget M1'!B62","v":"Recreation"}]
[null,{"$f":"'Budget M1'!B63","v":"-  Movies, Theater, Sporting Events"},null,{"$f":"SUM(G63:AK63)","v":0},{"$f":"C63-D63","v":0}]
[null,{"$f":"'Budget M1'!B64","v":"-  Other (type in other recreation here)"},null,{"$f":"SUM(G64:AK64)","v":0},{"$f":"C64-D64","v":0}]
[null,{"$f":"'Budget M1'!B65","v":"  Total Recreation Expenditures ( J )"},{"$f":"SUM(C62:C64)","v":0},{"$f":"SUM(D62:D64)","v":0},{"$f":"SUM(E62:E64)","v":0}]
[]
[null,{"$f":"'Budget M1'!B67","v":"Medical Expenditures"}]
[null,{"$f":"'Budget M1'!B68","v":"  -  Medical/Dental Expenses (from (E) deductions above)"},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0}]
[null,{"$f":"'Budget M1'!B69","v":"-  Other Medical (type in other medical here)"},null,{"$f":"SUM(G69:AK69)","v":0},{"$f":"C69-D69","v":0}]
[null,{"$f":"'Budget M1'!B70","v":"  Total Medical Expenditures ( K )"},{"$f":"SUM(C67:C69)","v":0},{"$f":"SUM(D67:D69)","v":0},{"$f":"SUM(E67:E69)","v":0}]
[]
[null,{"$f":"'Budget M1'!B72","v":"Insurance Expenditures"}]
[null,"- Health and Life",null,{"$f":"SUM(G73:AK73)","v":0},{"$f":"C73-D73","v":0}]
[null,{"$f":"'Budget M1'!B74","v":"- Automobile"},null,0,0]
[null,{"$f":"'Budget M1'!B75","v":"- Other (type in other insurance here)"},null,0,0]
[null,{"$f":"'Budget M1'!B76","v":"  Total Insurance Expenditures ( L )"},{"$f":"SUM(C72:C75)","v":0},{"$f":"SUM(D72:D75)","v":0},{"$f":"SUM(E72:E75)","v":0}]
[]
[null,{"$f":"'Budget M1'!B78","v":"Other Expenditures"}]
[null,"-  Education",null,{"$f":"SUM(G79:AK79)","v":0},{"$f":"C79-D79","v":0}]
[null,{"$f":"'Budget M1'!B80","v":"- Child Care"},null,{"$f":"SUM(G80:AK80)","v":0},0]
[null,{"$f":"'Budget M1'!B81","v":"- Other Expenses (type in other expenses here)"},null,{"$f":"SUM(G81:AK81)","v":0},0]
[null,{"$f":"'Budget M1'!B82","v":"  Total Other Expenditures ( M )"},{"$f":"SUM(C79:C81)","v":0},{"$f":"SUM(D79:D81)","v":0},0]
[]
[null,{"$f":"'Budget M1'!B84","v":"Total Living Expenditures (add lines D - M)"},{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0},{"$f":"D82+D76+D70+D65+D60+D54+D49+D43+D37+D32","v":0},{"$f":"E82+E76+E70+E65+E60+E54+E49+E43+E37+E32","v":0}]
[]
[null,{"$f":"'Budget M1'!B86","v":"Additional Income Available for Savings and Investment"},{"$f":"C24-C84","v":0},{"$f":"D24-D84","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,1,"January"]
[null,null,2,"February"]
[null,null,3,"March"]
[null,null,4,"April"]
[null,null,5,"May"]
[null,null,6,"June"]
[null,null,7,"July"]
[null,null,8,"August"]
[null,null,9,"September"]
[null,null,10,"October"]
[null,null,11,"November"]
[null,null,12,"December"]
[]
[null,null,{"$f":"DAY(TODAY())","v":17}]
[null,null,{"$f":"C106-1","v":16}]

{"sheet":"Budget M5","index":5,"n_rows":107,"n_cols":37,"rows_kept":107,"cut":false,"hidden":false,"merged":[[4,2,4,4],[1,1,1,4]]}
[null,{"$f":"\"Personal Budget for the Month of \"&I3&\", \"&I4","v":"Personal Budget for the Month of May, 2018"},null,null,null,"Type in the information below in the correct columns"]
[null,null,null,null,null,null,null,"Type Month and Year below:"]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the ",null,null,null,null,"Month #=",{"$f":"IF('Budget M4'!H3>=12,1,'Budget M4'!H3+1)","v":5},{"$f":"VLOOKUP(H3,Month,2)","v":"May"}]
[null,"                    red or blue cells.  Print off columns A-D for  your Budget each month.",null,null,null,null,"Year =",null,{"$f":"IF('Budget M4'!H3=12,'Budget M4'!I4+1,'Budget M4'!I4)","v":2018}]
[null,null,{"$f":"LEFT(I3,3)&\"-\"&RIGHT(I4,2)","v":"May-18"},null,null,null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16","Day 17","Day 18","Day 19","Day 20","Day 21","Day 22","Day 23","Day 24","Day 25","Day 26","Day 27","Day 28","Day 29","Day 30","Day 31"]
[null,"  [Ctrl][Shift] T will set your titles",null,"Income"]
[null,"  [Ctrl][Shift] C will clear your titles","Budget","Statement","Difference"]
[]
[null,"Income"]
[null,{"$f":"'Budget M1'!B10","v":"Wage Earner 1"},null,{"$f":"SUM(G10:AK10)","v":0},{"$f":"D10-C10","v":0}]
[null,{"$f":"'Budget M1'!B11","v":"Wage Earner 2"},null,{"$f":"SUM(G11:AK11)","v":0},0]
[null,{"$f":"'Budget M1'!B12","v":"= Total Wages and salaries"},{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},0]
[null,{"$f":"'Budget M1'!B13","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G13:AK13)","v":0},0]
[null,{"$f":"'Budget M1'!B14","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G14:AK14)","v":0},0]
[null,{"$f":"'Budget M1'!B15","v":"Total Income ( A )"},{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0}]
[]
[null,{"$f":"'Budget M1'!B17","v":"Deductions (Before and After Tax)"}]
[null,"   -  Federal and State Taxes",null,{"$f":"SUM(G18:AK18)","v":0},{"$f":"D18-C18","v":0}]
[null,"    -  Social Security Taxes",null,{"$f":"SUM(G19:AK19)","v":0},{"$f":"D19-C19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",null,{"$f":"SUM(G20:AK20)","v":0},{"$f":"D20-C20","v":0}]
[null,"    -  Medical Plan Deductions (E)",null,{"$f":"SUM(G21:AK21)","v":0},{"$f":"D21-C21","v":0}]
[null,{"$f":"'Budget M1'!B22","v":"    -  Other (type in another deduction here)"},null,{"$f":"SUM(G22:AK22)","v":0},{"$f":"D22-C22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0},{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0}]
[null,"      Take-Home Pay (A - B - C)",{"$f":"C15-C23","v":0},{"$f":"D15-D23","v":0},{"$f":"E15-E23","v":0}]
[null,{"$f":"'Budget M1'!B25","v":"(Income for Living Expenses)"}]
[null,null,"Budget ","Actual"]
[null,null,"Amount","Spending","Difference"]
[null,{"$f":"'Budget M1'!B28","v":"Paying the Lord"}]
[null,{"$f":"'Budget M1'!B29","v":"-  Tithing"},null,{"$f":"SUM(G29:AK29)","v":0},{"$f":"C29-D29","v":0}]
[null,{"$f":"'Budget M1'!B30","v":"-  Fast and Other Offerings"},null,{"$f":"SUM(G30:AK30)","v":0},{"$f":"C30-D30","v":0}]
[null,{"$f":"'Budget M1'!B31","v":"-  Other Contributions (type in other contributions here)"},null,{"$f":"SUM(G31:AK31)","v":0},{"$f":"C31-D31","v":0}]
[null,{"$f":"'Budget M1'!B32","v":"  Total Paying the Lord ( D )"},{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0}]
[]
[null,{"$f":"'Budget M1'!B34","v":"Paying Yourself"}]
[null,{"$f":"'Budget M1'!B35","v":"-  Retirement Savings (from (C) deductions above)"},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0}]
[null,{"$f":"'Budget M1'!B36","v":"- Other Savings (type in other contributions here)"},null,{"$f":"SUM(G36:AK36)","v":0},{"$f":"C36-D36","v":0}]
[null,{"$f":"'Budget M1'!B37","v":"  Total Paying Yourself ( E )"},{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0}]
[]
[null,{"$f":"'Budget M1'!B39","v":"Living Expenses"}]
[null,"-  Housing/Rent",null,{"$f":"SUM(G40:AK40)","v":0},{"$f":"C40-D40","v":0}]
[null,{"$f":"'Budget M1'!B41","v":"- Utilities"},null,0,{"$f":"C41-D41","v":0}]
[null,{"$f":"'Budget M1'!B42","v":"- Other Living Expenses (type in other living here)"},null,0,0]
[null,{"$f":"'Budget M1'!B43","v":"  Total Housing Expenditures ( F )"},{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0}]
[]
[null,{"$f":"'Budget M1'!B45","v":"Food"}]
[null,{"$f":"'Budget M1'!B46","v":"-  Food and Supplies"},null,{"$f":"SUM(G46:AK46)","v":0},{"$f":"C46-D46","v":0}]
[null,{"$f":"'Budget M1'!B47","v":"-  Restaurant Expenses"},null,{"$f":"SUM(G47:AK47)","v":0},{"$f":"C47-D47","v":0}]
[null,{"$f":"'Budget M1'!B48","v":"-  Food (type in other food here)"},null,{"$f":"SUM(G48:AK48)","v":0},{"$f":"C48-D48","v":0}]
[null,{"$f":"'Budget M1'!B49","v":"  Total Food Expenditures ( G )"},{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0}]
[]
[null,{"$f":"'Budget M1'!B51","v":"Clothing and Personal Care"}]
[null,"-  Clothing",null,{"$f":"SUM(G52:AK52)","v":0},{"$f":"C52-D52","v":0}]
[null,{"$f":"'Budget M1'!B53","v":"-  Other (type in other personal here)"},null,0,0]
[null,{"$f":"'Budget M1'!B54","v":"  Total Clothing/Personal Care Expenses ( H )"},{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},{"$f":"SUM(E51:E53)","v":0}]
[]
[null,{"$f":"'Budget M1'!B56","v":"Transportation"}]
[null,"-  Automobile",null,{"$f":"SUM(G57:AK57)","v":0},{"$f":"C57-D57","v":0}]
[null,{"$f":"'Budget M1'!B58","v":"-  Gas, Tolls, Parking"},null,0,0]
[null,{"$f":"'Budget M1'!B59","v":"-  Other (type in other transportation here)"},null,0,0]
[null,{"$f":"'Budget M1'!B60","v":"  Total Transportation Expenditures ( I )"},{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0},{"$f":"SUM(E56:E59)","v":0}]
[]
[null,{"$f":"'Budget M1'!B62","v":"Recreation"}]
[null,{"$f":"'Budget M1'!B63","v":"-  Movies, Theater, Sporting Events"},null,{"$f":"SUM(G63:AK63)","v":0},{"$f":"C63-D63","v":0}]
[null,{"$f":"'Budget M1'!B64","v":"-  Other (type in other recreation here)"},null,{"$f":"SUM(G64:AK64)","v":0},{"$f":"C64-D64","v":0}]
[null,{"$f":"'Budget M1'!B65","v":"  Total Recreation Expenditures ( J )"},{"$f":"SUM(C62:C64)","v":0},{"$f":"SUM(D62:D64)","v":0},{"$f":"SUM(E62:E64)","v":0}]
[]
[null,{"$f":"'Budget M1'!B67","v":"Medical Expenditures"}]
[null,{"$f":"'Budget M1'!B68","v":"  -  Medical/Dental Expenses (from (E) deductions above)"},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0}]
[null,{"$f":"'Budget M1'!B69","v":"-  Other Medical (type in other medical here)"},null,{"$f":"SUM(G69:AK69)","v":0},{"$f":"C69-D69","v":0}]
[null,{"$f":"'Budget M1'!B70","v":"  Total Medical Expenditures ( K )"},{"$f":"SUM(C67:C69)","v":0},{"$f":"SUM(D67:D69)","v":0},{"$f":"SUM(E67:E69)","v":0}]
[]
[null,{"$f":"'Budget M1'!B72","v":"Insurance Expenditures"}]
[null,"- Health and Life",null,{"$f":"SUM(G73:AK73)","v":0},{"$f":"C73-D73","v":0}]
[null,{"$f":"'Budget M1'!B74","v":"- Automobile"},null,0,0]
[null,{"$f":"'Budget M1'!B75","v":"- Other (type in other insurance here)"},null,0,0]
[null,{"$f":"'Budget M1'!B76","v":"  Total Insurance Expenditures ( L )"},{"$f":"SUM(C72:C75)","v":0},{"$f":"SUM(D72:D75)","v":0},{"$f":"SUM(E72:E75)","v":0}]
[]
[null,{"$f":"'Budget M1'!B78","v":"Other Expenditures"}]
[null,"-  Education",null,{"$f":"SUM(G79:AK79)","v":0},{"$f":"C79-D79","v":0}]
[null,{"$f":"'Budget M1'!B80","v":"- Child Care"},null,{"$f":"SUM(G80:AK80)","v":0},0]
[null,{"$f":"'Budget M1'!B81","v":"- Other Expenses (type in other expenses here)"},null,{"$f":"SUM(G81:AK81)","v":0},0]
[null,{"$f":"'Budget M1'!B82","v":"  Total Other Expenditures ( M )"},{"$f":"SUM(C79:C81)","v":0},{"$f":"SUM(D79:D81)","v":0},0]
[]
[null,{"$f":"'Budget M1'!B84","v":"Total Living Expenditures (add lines D - M)"},{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0},{"$f":"D82+D76+D70+D65+D60+D54+D49+D43+D37+D32","v":0},{"$f":"E82+E76+E70+E65+E60+E54+E49+E43+E37+E32","v":0}]
[]
[null,{"$f":"'Budget M1'!B86","v":"Additional Income Available for Savings and Investment"},{"$f":"C24-C84","v":0},{"$f":"D24-D84","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,1,"January"]
[null,null,2,"February"]
[null,null,3,"March"]
[null,null,4,"April"]
[null,null,5,"May"]
[null,null,6,"June"]
[null,null,7,"July"]
[null,null,8,"August"]
[null,null,9,"September"]
[null,null,10,"October"]
[null,null,11,"November"]
[null,null,12,"December"]
[]
[null,null,{"$f":"DAY(TODAY())","v":17}]
[null,null,{"$f":"C106-1","v":16}]

{"sheet":"Budget M6","index":6,"n_rows":107,"n_cols":37,"rows_kept":107,"cut":false,"hidden":false,"merged":[[4,2,4,4],[1,1,1,4]]}
[null,{"$f":"\"Personal Budget for the Month of \"&I3&\", \"&I4","v":"Personal Budget for the Month of June, 2018"},null,null,null,"Type in the information below in the correct columns"]
[null,null,null,null,null,null,null,"Type Month and Year below:"]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the ",null,null,null,null,"Month #=",{"$f":"IF('Budget M5'!H3>=12,1,'Budget M5'!H3+1)","v":6},{"$f":"VLOOKUP(H3,Month,2)","v":"June"}]
[null,"                    red or blue cells.  Print off columns A-D for  your Budget each month.",null,null,null,null,"Year =",null,{"$f":"IF('Budget M5'!H3=12,'Budget M5'!I4+1,'Budget M5'!I4)","v":2018}]
[null,null,{"$f":"LEFT(I3,3)&\"-\"&RIGHT(I4,2)","v":"Jun-18"},null,null,null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16","Day 17","Day 18","Day 19","Day 20","Day 21","Day 22","Day 23","Day 24","Day 25","Day 26","Day 27","Day 28","Day 29","Day 30","Day 31"]
[null,"  [Ctrl][Shift] T will set your titles",null,"Income"]
[null,"  [Ctrl][Shift] C will clear your titles","Budget","Statement","Difference"]
[]
[null,"Income"]
[null,{"$f":"'Budget M1'!B10","v":"Wage Earner 1"},null,{"$f":"SUM(G10:AK10)","v":0},{"$f":"D10-C10","v":0}]
[null,{"$f":"'Budget M1'!B11","v":"Wage Earner 2"},null,{"$f":"SUM(G11:AK11)","v":0},0]
[null,{"$f":"'Budget M1'!B12","v":"= Total Wages and salaries"},{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},0]
[null,{"$f":"'Budget M1'!B13","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G13:AK13)","v":0},0]
[null,{"$f":"'Budget M1'!B14","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G14:AK14)","v":0},0]
[null,{"$f":"'Budget M1'!B15","v":"Total Income ( A )"},{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0}]
[]
[null,{"$f":"'Budget M1'!B17","v":"Deductions (Before and After Tax)"}]
[null,"   -  Federal and State Taxes",null,{"$f":"SUM(G18:AK18)","v":0},{"$f":"D18-C18","v":0}]
[null,"    -  Social Security Taxes",null,{"$f":"SUM(G19:AK19)","v":0},{"$f":"D19-C19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",null,{"$f":"SUM(G20:AK20)","v":0},{"$f":"D20-C20","v":0}]
[null,"    -  Medical Plan Deductions (E)",null,{"$f":"SUM(G21:AK21)","v":0},{"$f":"D21-C21","v":0}]
[null,{"$f":"'Budget M1'!B22","v":"    -  Other (type in another deduction here)"},null,{"$f":"SUM(G22:AK22)","v":0},{"$f":"D22-C22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0},{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0}]
[null,"      Take-Home Pay (A - B - C)",{"$f":"C15-C23","v":0},{"$f":"D15-D23","v":0},{"$f":"E15-E23","v":0}]
[null,{"$f":"'Budget M1'!B25","v":"(Income for Living Expenses)"}]
[null,null,"Budget ","Actual"]
[null,null,"Amount","Spending","Difference"]
[null,{"$f":"'Budget M1'!B28","v":"Paying the Lord"}]
[null,{"$f":"'Budget M1'!B29","v":"-  Tithing"},null,{"$f":"SUM(G29:AK29)","v":0},{"$f":"C29-D29","v":0}]
[null,{"$f":"'Budget M1'!B30","v":"-  Fast and Other Offerings"},null,{"$f":"SUM(G30:AK30)","v":0},{"$f":"C30-D30","v":0}]
[null,{"$f":"'Budget M1'!B31","v":"-  Other Contributions (type in other contributions here)"},null,{"$f":"SUM(G31:AK31)","v":0},{"$f":"C31-D31","v":0}]
[null,{"$f":"'Budget M1'!B32","v":"  Total Paying the Lord ( D )"},{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0}]
[]
[null,{"$f":"'Budget M1'!B34","v":"Paying Yourself"}]
[null,{"$f":"'Budget M1'!B35","v":"-  Retirement Savings (from (C) deductions above)"},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0}]
[null,{"$f":"'Budget M1'!B36","v":"- Other Savings (type in other contributions here)"},null,{"$f":"SUM(G36:AK36)","v":0},{"$f":"C36-D36","v":0}]
[null,{"$f":"'Budget M1'!B37","v":"  Total Paying Yourself ( E )"},{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0}]
[]
[null,{"$f":"'Budget M1'!B39","v":"Living Expenses"}]
[null,"-  Housing/Rent",null,{"$f":"SUM(G40:AK40)","v":0},{"$f":"C40-D40","v":0}]
[null,{"$f":"'Budget M1'!B41","v":"- Utilities"},null,0,{"$f":"C41-D41","v":0}]
[null,{"$f":"'Budget M1'!B42","v":"- Other Living Expenses (type in other living here)"},null,0,0]
[null,{"$f":"'Budget M1'!B43","v":"  Total Housing Expenditures ( F )"},{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0}]
[]
[null,{"$f":"'Budget M1'!B45","v":"Food"}]
[null,{"$f":"'Budget M1'!B46","v":"-  Food and Supplies"},null,{"$f":"SUM(G46:AK46)","v":0},{"$f":"C46-D46","v":0}]
[null,{"$f":"'Budget M1'!B47","v":"-  Restaurant Expenses"},null,{"$f":"SUM(G47:AK47)","v":0},{"$f":"C47-D47","v":0}]
[null,{"$f":"'Budget M1'!B48","v":"-  Food (type in other food here)"},null,{"$f":"SUM(G48:AK48)","v":0},{"$f":"C48-D48","v":0}]
[null,{"$f":"'Budget M1'!B49","v":"  Total Food Expenditures ( G )"},{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0}]
[]
[null,{"$f":"'Budget M1'!B51","v":"Clothing and Personal Care"}]
[null,"-  Clothing",null,{"$f":"SUM(G52:AK52)","v":0},{"$f":"C52-D52","v":0}]
[null,{"$f":"'Budget M1'!B53","v":"-  Other (type in other personal here)"},null,0,0]
[null,{"$f":"'Budget M1'!B54","v":"  Total Clothing/Personal Care Expenses ( H )"},{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},{"$f":"SUM(E51:E53)","v":0}]
[]
[null,{"$f":"'Budget M1'!B56","v":"Transportation"}]
[null,"-  Automobile",null,{"$f":"SUM(G57:AK57)","v":0},{"$f":"C57-D57","v":0}]
[null,{"$f":"'Budget M1'!B58","v":"-  Gas, Tolls, Parking"},null,0,0]
[null,{"$f":"'Budget M1'!B59","v":"-  Other (type in other transportation here)"},null,0,0]
[null,{"$f":"'Budget M1'!B60","v":"  Total Transportation Expenditures ( I )"},{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0},{"$f":"SUM(E56:E59)","v":0}]
[]
[null,{"$f":"'Budget M1'!B62","v":"Recreation"}]
[null,{"$f":"'Budget M1'!B63","v":"-  Movies, Theater, Sporting Events"},null,{"$f":"SUM(G63:AK63)","v":0},{"$f":"C63-D63","v":0}]
[null,{"$f":"'Budget M1'!B64","v":"-  Other (type in other recreation here)"},null,{"$f":"SUM(G64:AK64)","v":0},{"$f":"C64-D64","v":0}]
[null,{"$f":"'Budget M1'!B65","v":"  Total Recreation Expenditures ( J )"},{"$f":"SUM(C62:C64)","v":0},{"$f":"SUM(D62:D64)","v":0},{"$f":"SUM(E62:E64)","v":0}]
[]
[null,{"$f":"'Budget M1'!B67","v":"Medical Expenditures"}]
[null,{"$f":"'Budget M1'!B68","v":"  -  Medical/Dental Expenses (from (E) deductions above)"},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0}]
[null,{"$f":"'Budget M1'!B69","v":"-  Other Medical (type in other medical here)"},null,{"$f":"SUM(G69:AK69)","v":0},{"$f":"C69-D69","v":0}]
[null,{"$f":"'Budget M1'!B70","v":"  Total Medical Expenditures ( K )"},{"$f":"SUM(C67:C69)","v":0},{"$f":"SUM(D67:D69)","v":0},{"$f":"SUM(E67:E69)","v":0}]
[]
[null,{"$f":"'Budget M1'!B72","v":"Insurance Expenditures"}]
[null,"- Health and Life",null,{"$f":"SUM(G73:AK73)","v":0},{"$f":"C73-D73","v":0}]
[null,{"$f":"'Budget M1'!B74","v":"- Automobile"},null,0,0]
[null,{"$f":"'Budget M1'!B75","v":"- Other (type in other insurance here)"},null,0,0]
[null,{"$f":"'Budget M1'!B76","v":"  Total Insurance Expenditures ( L )"},{"$f":"SUM(C72:C75)","v":0},{"$f":"SUM(D72:D75)","v":0},{"$f":"SUM(E72:E75)","v":0}]
[]
[null,{"$f":"'Budget M1'!B78","v":"Other Expenditures"}]
[null,"-  Education",null,{"$f":"SUM(G79:AK79)","v":0},{"$f":"C79-D79","v":0}]
[null,{"$f":"'Budget M1'!B80","v":"- Child Care"},null,{"$f":"SUM(G80:AK80)","v":0},0]
[null,{"$f":"'Budget M1'!B81","v":"- Other Expenses (type in other expenses here)"},null,{"$f":"SUM(G81:AK81)","v":0},0]
[null,{"$f":"'Budget M1'!B82","v":"  Total Other Expenditures ( M )"},{"$f":"SUM(C79:C81)","v":0},{"$f":"SUM(D79:D81)","v":0},0]
[]
[null,{"$f":"'Budget M1'!B84","v":"Total Living Expenditures (add lines D - M)"},{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0},{"$f":"D82+D76+D70+D65+D60+D54+D49+D43+D37+D32","v":0},{"$f":"E82+E76+E70+E65+E60+E54+E49+E43+E37+E32","v":0}]
[]
[null,{"$f":"'Budget M1'!B86","v":"Additional Income Available for Savings and Investment"},{"$f":"C24-C84","v":0},{"$f":"D24-D84","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,1,"January"]
[null,null,2,"February"]
[null,null,3,"March"]
[null,null,4,"April"]
[null,null,5,"May"]
[null,null,6,"June"]
[null,null,7,"July"]
[null,null,8,"August"]
[null,null,9,"September"]
[null,null,10,"October"]
[null,null,11,"November"]
[null,null,12,"December"]
[]
[null,null,{"$f":"DAY(TODAY())","v":17}]
[null,null,{"$f":"C106-1","v":16}]

{"sheet":"Budget M7","index":7,"n_rows":107,"n_cols":37,"rows_kept":107,"cut":false,"hidden":false,"merged":[[4,2,4,4],[1,1,1,4]]}
[null,{"$f":"\"Personal Budget for the Month of \"&I3&\", \"&I4","v":"Personal Budget for the Month of July, 2018"},null,null,null,"Type in the information below in the correct columns"]
[null,null,null,null,null,null,null,"Type Month and Year below:"]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the ",null,null,null,null,"Month #=",{"$f":"IF('Budget M6'!H3>=12,1,'Budget M6'!H3+1)","v":7},{"$f":"VLOOKUP(H3,Month,2)","v":"July"}]
[null,"                    red or blue cells.  Print off columns A-D for  your Budget each month.",null,null,null,null,"Year =",null,{"$f":"IF('Budget M6'!H3=12,'Budget M6'!I4+1,'Budget M6'!I4)","v":2018}]
[null,null,{"$f":"LEFT(I3,3)&\"-\"&RIGHT(I4,2)","v":"Jul-18"},null,null,null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16","Day 17","Day 18","Day 19","Day 20","Day 21","Day 22","Day 23","Day 24","Day 25","Day 26","Day 27","Day 28","Day 29","Day 30","Day 31"]
[null,"  [Ctrl][Shift] T will set your titles",null,"Income"]
[null,"  [Ctrl][Shift] C will clear your titles","Budget","Statement","Difference"]
[]
[null,"Income"]
[null,{"$f":"'Budget M1'!B10","v":"Wage Earner 1"},null,{"$f":"SUM(G10:AK10)","v":0},{"$f":"D10-C10","v":0}]
[null,{"$f":"'Budget M1'!B11","v":"Wage Earner 2"},null,{"$f":"SUM(G11:AK11)","v":0},0]
[null,{"$f":"'Budget M1'!B12","v":"= Total Wages and salaries"},{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},0]
[null,{"$f":"'Budget M1'!B13","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G13:AK13)","v":0},0]
[null,{"$f":"'Budget M1'!B14","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G14:AK14)","v":0},0]
[null,{"$f":"'Budget M1'!B15","v":"Total Income ( A )"},{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0}]
[]
[null,{"$f":"'Budget M1'!B17","v":"Deductions (Before and After Tax)"}]
[null,"   -  Federal and State Taxes",null,{"$f":"SUM(G18:AK18)","v":0},{"$f":"D18-C18","v":0}]
[null,"    -  Social Security Taxes",null,{"$f":"SUM(G19:AK19)","v":0},{"$f":"D19-C19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",null,{"$f":"SUM(G20:AK20)","v":0},{"$f":"D20-C20","v":0}]
[null,"    -  Medical Plan Deductions (E)",null,{"$f":"SUM(G21:AK21)","v":0},{"$f":"D21-C21","v":0}]
[null,{"$f":"'Budget M1'!B22","v":"    -  Other (type in another deduction here)"},null,{"$f":"SUM(G22:AK22)","v":0},{"$f":"D22-C22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0},{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0}]
[null,"      Take-Home Pay (A - B - C)",{"$f":"C15-C23","v":0},{"$f":"D15-D23","v":0},{"$f":"E15-E23","v":0}]
[null,{"$f":"'Budget M1'!B25","v":"(Income for Living Expenses)"}]
[null,null,"Budget ","Actual"]
[null,null,"Amount","Spending","Difference"]
[null,{"$f":"'Budget M1'!B28","v":"Paying the Lord"}]
[null,{"$f":"'Budget M1'!B29","v":"-  Tithing"},null,{"$f":"SUM(G29:AK29)","v":0},{"$f":"C29-D29","v":0}]
[null,{"$f":"'Budget M1'!B30","v":"-  Fast and Other Offerings"},null,{"$f":"SUM(G30:AK30)","v":0},{"$f":"C30-D30","v":0}]
[null,{"$f":"'Budget M1'!B31","v":"-  Other Contributions (type in other contributions here)"},null,{"$f":"SUM(G31:AK31)","v":0},{"$f":"C31-D31","v":0}]
[null,{"$f":"'Budget M1'!B32","v":"  Total Paying the Lord ( D )"},{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0}]
[]
[null,{"$f":"'Budget M1'!B34","v":"Paying Yourself"}]
[null,{"$f":"'Budget M1'!B35","v":"-  Retirement Savings (from (C) deductions above)"},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0}]
[null,{"$f":"'Budget M1'!B36","v":"- Other Savings (type in other contributions here)"},null,{"$f":"SUM(G36:AK36)","v":0},{"$f":"C36-D36","v":0}]
[null,{"$f":"'Budget M1'!B37","v":"  Total Paying Yourself ( E )"},{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0}]
[]
[null,{"$f":"'Budget M1'!B39","v":"Living Expenses"}]
[null,"-  Housing/Rent",null,{"$f":"SUM(G40:AK40)","v":0},{"$f":"C40-D40","v":0}]
[null,{"$f":"'Budget M1'!B41","v":"- Utilities"},null,0,{"$f":"C41-D41","v":0}]
[null,{"$f":"'Budget M1'!B42","v":"- Other Living Expenses (type in other living here)"},null,0,0]
[null,{"$f":"'Budget M1'!B43","v":"  Total Housing Expenditures ( F )"},{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0}]
[]
[null,{"$f":"'Budget M1'!B45","v":"Food"}]
[null,{"$f":"'Budget M1'!B46","v":"-  Food and Supplies"},null,{"$f":"SUM(G46:AK46)","v":0},{"$f":"C46-D46","v":0}]
[null,{"$f":"'Budget M1'!B47","v":"-  Restaurant Expenses"},null,{"$f":"SUM(G47:AK47)","v":0},{"$f":"C47-D47","v":0}]
[null,{"$f":"'Budget M1'!B48","v":"-  Food (type in other food here)"},null,{"$f":"SUM(G48:AK48)","v":0},{"$f":"C48-D48","v":0}]
[null,{"$f":"'Budget M1'!B49","v":"  Total Food Expenditures ( G )"},{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0}]
[]
[null,{"$f":"'Budget M1'!B51","v":"Clothing and Personal Care"}]
[null,"-  Clothing",null,{"$f":"SUM(G52:AK52)","v":0},{"$f":"C52-D52","v":0}]
[null,{"$f":"'Budget M1'!B53","v":"-  Other (type in other personal here)"},null,0,0]
[null,{"$f":"'Budget M1'!B54","v":"  Total Clothing/Personal Care Expenses ( H )"},{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},{"$f":"SUM(E51:E53)","v":0}]
[]
[null,{"$f":"'Budget M1'!B56","v":"Transportation"}]
[null,"-  Automobile",null,{"$f":"SUM(G57:AK57)","v":0},{"$f":"C57-D57","v":0}]
[null,{"$f":"'Budget M1'!B58","v":"-  Gas, Tolls, Parking"},null,0,0]
[null,{"$f":"'Budget M1'!B59","v":"-  Other (type in other transportation here)"},null,0,0]
[null,{"$f":"'Budget M1'!B60","v":"  Total Transportation Expenditures ( I )"},{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0},{"$f":"SUM(E56:E59)","v":0}]
[]
[null,{"$f":"'Budget M1'!B62","v":"Recreation"}]
[null,{"$f":"'Budget M1'!B63","v":"-  Movies, Theater, Sporting Events"},null,{"$f":"SUM(G63:AK63)","v":0},{"$f":"C63-D63","v":0}]
[null,{"$f":"'Budget M1'!B64","v":"-  Other (type in other recreation here)"},null,{"$f":"SUM(G64:AK64)","v":0},{"$f":"C64-D64","v":0}]
[null,{"$f":"'Budget M1'!B65","v":"  Total Recreation Expenditures ( J )"},{"$f":"SUM(C62:C64)","v":0},{"$f":"SUM(D62:D64)","v":0},{"$f":"SUM(E62:E64)","v":0}]
[]
[null,{"$f":"'Budget M1'!B67","v":"Medical Expenditures"}]
[null,{"$f":"'Budget M1'!B68","v":"  -  Medical/Dental Expenses (from (E) deductions above)"},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0}]
[null,{"$f":"'Budget M1'!B69","v":"-  Other Medical (type in other medical here)"},null,{"$f":"SUM(G69:AK69)","v":0},{"$f":"C69-D69","v":0}]
[null,{"$f":"'Budget M1'!B70","v":"  Total Medical Expenditures ( K )"},{"$f":"SUM(C67:C69)","v":0},{"$f":"SUM(D67:D69)","v":0},{"$f":"SUM(E67:E69)","v":0}]
[]
[null,{"$f":"'Budget M1'!B72","v":"Insurance Expenditures"}]
[null,"- Health and Life",null,{"$f":"SUM(G73:AK73)","v":0},{"$f":"C73-D73","v":0}]
[null,{"$f":"'Budget M1'!B74","v":"- Automobile"},null,0,0]
[null,{"$f":"'Budget M1'!B75","v":"- Other (type in other insurance here)"},null,0,0]
[null,{"$f":"'Budget M1'!B76","v":"  Total Insurance Expenditures ( L )"},{"$f":"SUM(C72:C75)","v":0},{"$f":"SUM(D72:D75)","v":0},{"$f":"SUM(E72:E75)","v":0}]
[]
[null,{"$f":"'Budget M1'!B78","v":"Other Expenditures"}]
[null,"-  Education",null,{"$f":"SUM(G79:AK79)","v":0},{"$f":"C79-D79","v":0}]
[null,{"$f":"'Budget M1'!B80","v":"- Child Care"},null,{"$f":"SUM(G80:AK80)","v":0},0]
[null,{"$f":"'Budget M1'!B81","v":"- Other Expenses (type in other expenses here)"},null,{"$f":"SUM(G81:AK81)","v":0},0]
[null,{"$f":"'Budget M1'!B82","v":"  Total Other Expenditures ( M )"},{"$f":"SUM(C79:C81)","v":0},{"$f":"SUM(D79:D81)","v":0},0]
[]
[null,{"$f":"'Budget M1'!B84","v":"Total Living Expenditures (add lines D - M)"},{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0},{"$f":"D82+D76+D70+D65+D60+D54+D49+D43+D37+D32","v":0},{"$f":"E82+E76+E70+E65+E60+E54+E49+E43+E37+E32","v":0}]
[]
[null,{"$f":"'Budget M1'!B86","v":"Additional Income Available for Savings and Investment"},{"$f":"C24-C84","v":0},{"$f":"D24-D84","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,1,"January"]
[null,null,2,"February"]
[null,null,3,"March"]
[null,null,4,"April"]
[null,null,5,"May"]
[null,null,6,"June"]
[null,null,7,"July"]
[null,null,8,"August"]
[null,null,9,"September"]
[null,null,10,"October"]
[null,null,11,"November"]
[null,null,12,"December"]
[]
[null,null,{"$f":"DAY(TODAY())","v":17}]
[null,null,{"$f":"C106-1","v":16}]

{"sheet":"Budget M8","index":8,"n_rows":107,"n_cols":37,"rows_kept":107,"cut":false,"hidden":false,"merged":[[4,2,4,4],[1,1,1,4]]}
[null,{"$f":"\"Personal Budget for the Month of \"&I3&\", \"&I4","v":"Personal Budget for the Month of August, 2018"},null,null,null,"Type in the information below in the correct columns"]
[null,null,null,null,null,null,null,"Type Month and Year below:"]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the ",null,null,null,null,"Month #=",{"$f":"IF('Budget M7'!H3>=12,1,'Budget M7'!H3+1)","v":8},{"$f":"VLOOKUP(H3,Month,2)","v":"August"}]
[null,"                    red or blue cells.  Print off columns A-D for  your Budget each month.",null,null,null,null,"Year =",null,{"$f":"IF('Budget M7'!H3=12,'Budget M7'!I4+1,'Budget M7'!I4)","v":2018}]
[null,null,{"$f":"LEFT(I3,3)&\"-\"&RIGHT(I4,2)","v":"Aug-18"},null,null,null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16","Day 17","Day 18","Day 19","Day 20","Day 21","Day 22","Day 23","Day 24","Day 25","Day 26","Day 27","Day 28","Day 29","Day 30","Day 31"]
[null,"  [Ctrl][Shift] T will set your titles",null,"Income"]
[null,"  [Ctrl][Shift] C will clear your titles","Budget","Statement","Difference"]
[]
[null,"Income"]
[null,{"$f":"'Budget M1'!B10","v":"Wage Earner 1"},null,{"$f":"SUM(G10:AK10)","v":0},{"$f":"D10-C10","v":0}]
[null,{"$f":"'Budget M1'!B11","v":"Wage Earner 2"},null,{"$f":"SUM(G11:AK11)","v":0},0]
[null,{"$f":"'Budget M1'!B12","v":"= Total Wages and salaries"},{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},0]
[null,{"$f":"'Budget M1'!B13","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G13:AK13)","v":0},0]
[null,{"$f":"'Budget M1'!B14","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G14:AK14)","v":0},0]
[null,{"$f":"'Budget M1'!B15","v":"Total Income ( A )"},{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0}]
[]
[null,{"$f":"'Budget M1'!B17","v":"Deductions (Before and After Tax)"}]
[null,"   -  Federal and State Taxes",null,{"$f":"SUM(G18:AK18)","v":0},{"$f":"D18-C18","v":0}]
[null,"    -  Social Security Taxes",null,{"$f":"SUM(G19:AK19)","v":0},{"$f":"D19-C19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",null,{"$f":"SUM(G20:AK20)","v":0},{"$f":"D20-C20","v":0}]
[null,"    -  Medical Plan Deductions (E)",null,{"$f":"SUM(G21:AK21)","v":0},{"$f":"D21-C21","v":0}]
[null,{"$f":"'Budget M1'!B22","v":"    -  Other (type in another deduction here)"},null,{"$f":"SUM(G22:AK22)","v":0},{"$f":"D22-C22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0},{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0}]
[null,"      Take-Home Pay (A - B - C)",{"$f":"C15-C23","v":0},{"$f":"D15-D23","v":0},{"$f":"E15-E23","v":0}]
[null,{"$f":"'Budget M1'!B25","v":"(Income for Living Expenses)"}]
[null,null,"Budget ","Actual"]
[null,null,"Amount","Spending","Difference"]
[null,{"$f":"'Budget M1'!B28","v":"Paying the Lord"}]
[null,{"$f":"'Budget M1'!B29","v":"-  Tithing"},null,{"$f":"SUM(G29:AK29)","v":0},{"$f":"C29-D29","v":0}]
[null,{"$f":"'Budget M1'!B30","v":"-  Fast and Other Offerings"},null,{"$f":"SUM(G30:AK30)","v":0},{"$f":"C30-D30","v":0}]
[null,{"$f":"'Budget M1'!B31","v":"-  Other Contributions (type in other contributions here)"},null,{"$f":"SUM(G31:AK31)","v":0},{"$f":"C31-D31","v":0}]
[null,{"$f":"'Budget M1'!B32","v":"  Total Paying the Lord ( D )"},{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0}]
[]
[null,{"$f":"'Budget M1'!B34","v":"Paying Yourself"}]
[null,{"$f":"'Budget M1'!B35","v":"-  Retirement Savings (from (C) deductions above)"},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0}]
[null,{"$f":"'Budget M1'!B36","v":"- Other Savings (type in other contributions here)"},null,{"$f":"SUM(G36:AK36)","v":0},{"$f":"C36-D36","v":0}]
[null,{"$f":"'Budget M1'!B37","v":"  Total Paying Yourself ( E )"},{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0}]
[]
[null,{"$f":"'Budget M1'!B39","v":"Living Expenses"}]
[null,"-  Housing/Rent",null,{"$f":"SUM(G40:AK40)","v":0},{"$f":"C40-D40","v":0}]
[null,{"$f":"'Budget M1'!B41","v":"- Utilities"},null,0,{"$f":"C41-D41","v":0}]
[null,{"$f":"'Budget M1'!B42","v":"- Other Living Expenses (type in other living here)"},null,0,0]
[null,{"$f":"'Budget M1'!B43","v":"  Total Housing Expenditures ( F )"},{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0}]
[]
[null,{"$f":"'Budget M1'!B45","v":"Food"}]
[null,{"$f":"'Budget M1'!B46","v":"-  Food and Supplies"},null,{"$f":"SUM(G46:AK46)","v":0},{"$f":"C46-D46","v":0}]
[null,{"$f":"'Budget M1'!B47","v":"-  Restaurant Expenses"},null,{"$f":"SUM(G47:AK47)","v":0},{"$f":"C47-D47","v":0}]
[null,{"$f":"'Budget M1'!B48","v":"-  Food (type in other food here)"},null,{"$f":"SUM(G48:AK48)","v":0},{"$f":"C48-D48","v":0}]
[null,{"$f":"'Budget M1'!B49","v":"  Total Food Expenditures ( G )"},{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0}]
[]
[null,{"$f":"'Budget M1'!B51","v":"Clothing and Personal Care"}]
[null,"-  Clothing",null,{"$f":"SUM(G52:AK52)","v":0},{"$f":"C52-D52","v":0}]
[null,{"$f":"'Budget M1'!B53","v":"-  Other (type in other personal here)"},null,0,0]
[null,{"$f":"'Budget M1'!B54","v":"  Total Clothing/Personal Care Expenses ( H )"},{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},{"$f":"SUM(E51:E53)","v":0}]
[]
[null,{"$f":"'Budget M1'!B56","v":"Transportation"}]
[null,"-  Automobile",null,{"$f":"SUM(G57:AK57)","v":0},{"$f":"C57-D57","v":0}]
[null,{"$f":"'Budget M1'!B58","v":"-  Gas, Tolls, Parking"},null,0,0]
[null,{"$f":"'Budget M1'!B59","v":"-  Other (type in other transportation here)"},null,0,0]
[null,{"$f":"'Budget M1'!B60","v":"  Total Transportation Expenditures ( I )"},{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0},{"$f":"SUM(E56:E59)","v":0}]
[]
[null,{"$f":"'Budget M1'!B62","v":"Recreation"}]
[null,{"$f":"'Budget M1'!B63","v":"-  Movies, Theater, Sporting Events"},null,{"$f":"SUM(G63:AK63)","v":0},{"$f":"C63-D63","v":0}]
[null,{"$f":"'Budget M1'!B64","v":"-  Other (type in other recreation here)"},null,{"$f":"SUM(G64:AK64)","v":0},{"$f":"C64-D64","v":0}]
[null,{"$f":"'Budget M1'!B65","v":"  Total Recreation Expenditures ( J )"},{"$f":"SUM(C62:C64)","v":0},{"$f":"SUM(D62:D64)","v":0},{"$f":"SUM(E62:E64)","v":0}]
[]
[null,{"$f":"'Budget M1'!B67","v":"Medical Expenditures"}]
[null,{"$f":"'Budget M1'!B68","v":"  -  Medical/Dental Expenses (from (E) deductions above)"},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0}]
[null,{"$f":"'Budget M1'!B69","v":"-  Other Medical (type in other medical here)"},null,{"$f":"SUM(G69:AK69)","v":0},{"$f":"C69-D69","v":0}]
[null,{"$f":"'Budget M1'!B70","v":"  Total Medical Expenditures ( K )"},{"$f":"SUM(C67:C69)","v":0},{"$f":"SUM(D67:D69)","v":0},{"$f":"SUM(E67:E69)","v":0}]
[]
[null,{"$f":"'Budget M1'!B72","v":"Insurance Expenditures"}]
[null,"- Health and Life",null,{"$f":"SUM(G73:AK73)","v":0},{"$f":"C73-D73","v":0}]
[null,{"$f":"'Budget M1'!B74","v":"- Automobile"},null,0,0]
[null,{"$f":"'Budget M1'!B75","v":"- Other (type in other insurance here)"},null,0,0]
[null,{"$f":"'Budget M1'!B76","v":"  Total Insurance Expenditures ( L )"},{"$f":"SUM(C72:C75)","v":0},{"$f":"SUM(D72:D75)","v":0},{"$f":"SUM(E72:E75)","v":0}]
[]
[null,{"$f":"'Budget M1'!B78","v":"Other Expenditures"}]
[null,"-  Education",null,{"$f":"SUM(G79:AK79)","v":0},{"$f":"C79-D79","v":0}]
[null,{"$f":"'Budget M1'!B80","v":"- Child Care"},null,{"$f":"SUM(G80:AK80)","v":0},0]
[null,{"$f":"'Budget M1'!B81","v":"- Other Expenses (type in other expenses here)"},null,{"$f":"SUM(G81:AK81)","v":0},0]
[null,{"$f":"'Budget M1'!B82","v":"  Total Other Expenditures ( M )"},{"$f":"SUM(C79:C81)","v":0},{"$f":"SUM(D79:D81)","v":0},0]
[]
[null,{"$f":"'Budget M1'!B84","v":"Total Living Expenditures (add lines D - M)"},{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0},{"$f":"D82+D76+D70+D65+D60+D54+D49+D43+D37+D32","v":0},{"$f":"E82+E76+E70+E65+E60+E54+E49+E43+E37+E32","v":0}]
[]
[null,{"$f":"'Budget M1'!B86","v":"Additional Income Available for Savings and Investment"},{"$f":"C24-C84","v":0},{"$f":"D24-D84","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,1,"January"]
[null,null,2,"February"]
[null,null,3,"March"]
[null,null,4,"April"]
[null,null,5,"May"]
[null,null,6,"June"]
[null,null,7,"July"]
[null,null,8,"August"]
[null,null,9,"September"]
[null,null,10,"October"]
[null,null,11,"November"]
[null,null,12,"December"]
[]
[null,null,{"$f":"DAY(TODAY())","v":17}]
[null,null,{"$f":"C106-1","v":16}]

{"sheet":"Budget M9","index":9,"n_rows":107,"n_cols":37,"rows_kept":107,"cut":false,"hidden":false,"merged":[[4,2,4,4],[1,1,1,4]]}
[null,{"$f":"\"Personal Budget for the Month of \"&I3&\", \"&I4","v":"Personal Budget for the Month of September, 2018"},null,null,null,"Type in the information below in the correct columns"]
[null,null,null,null,null,null,null,"Type Month and Year below:"]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the ",null,null,null,null,"Month #=",{"$f":"IF('Budget M8'!H3>=12,1,'Budget M8'!H3+1)","v":9},{"$f":"VLOOKUP(H3,Month,2)","v":"September"}]
[null,"                    red or blue cells.  Print off columns A-D for  your Budget each month.",null,null,null,null,"Year =",null,{"$f":"IF('Budget M8'!H3=12,'Budget M8'!I4+1,'Budget M8'!I4)","v":2018}]
[null,null,{"$f":"LEFT(I3,3)&\"-\"&RIGHT(I4,2)","v":"Sep-18"},null,null,null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16","Day 17","Day 18","Day 19","Day 20","Day 21","Day 22","Day 23","Day 24","Day 25","Day 26","Day 27","Day 28","Day 29","Day 30","Day 31"]
[null,"  [Ctrl][Shift] T will set your titles",null,"Income"]
[null,"  [Ctrl][Shift] C will clear your titles","Budget","Statement","Difference"]
[]
[null,"Income"]
[null,{"$f":"'Budget M1'!B10","v":"Wage Earner 1"},null,{"$f":"SUM(G10:AK10)","v":0},{"$f":"D10-C10","v":0}]
[null,{"$f":"'Budget M1'!B11","v":"Wage Earner 2"},null,{"$f":"SUM(G11:AK11)","v":0},0]
[null,{"$f":"'Budget M1'!B12","v":"= Total Wages and salaries"},{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},0]
[null,{"$f":"'Budget M1'!B13","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G13:AK13)","v":0},0]
[null,{"$f":"'Budget M1'!B14","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G14:AK14)","v":0},0]
[null,{"$f":"'Budget M1'!B15","v":"Total Income ( A )"},{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0}]
[]
[null,{"$f":"'Budget M1'!B17","v":"Deductions (Before and After Tax)"}]
[null,"   -  Federal and State Taxes",null,{"$f":"SUM(G18:AK18)","v":0},{"$f":"D18-C18","v":0}]
[null,"    -  Social Security Taxes",null,{"$f":"SUM(G19:AK19)","v":0},{"$f":"D19-C19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",null,{"$f":"SUM(G20:AK20)","v":0},{"$f":"D20-C20","v":0}]
[null,"    -  Medical Plan Deductions (E)",null,{"$f":"SUM(G21:AK21)","v":0},{"$f":"D21-C21","v":0}]
[null,{"$f":"'Budget M1'!B22","v":"    -  Other (type in another deduction here)"},null,{"$f":"SUM(G22:AK22)","v":0},{"$f":"D22-C22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0},{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0}]
[null,"      Take-Home Pay (A - B - C)",{"$f":"C15-C23","v":0},{"$f":"D15-D23","v":0},{"$f":"E15-E23","v":0}]
[null,{"$f":"'Budget M1'!B25","v":"(Income for Living Expenses)"}]
[null,null,"Budget ","Actual"]
[null,null,"Amount","Spending","Difference"]
[null,{"$f":"'Budget M1'!B28","v":"Paying the Lord"}]
[null,{"$f":"'Budget M1'!B29","v":"-  Tithing"},null,{"$f":"SUM(G29:AK29)","v":0},{"$f":"C29-D29","v":0}]
[null,{"$f":"'Budget M1'!B30","v":"-  Fast and Other Offerings"},null,{"$f":"SUM(G30:AK30)","v":0},{"$f":"C30-D30","v":0}]
[null,{"$f":"'Budget M1'!B31","v":"-  Other Contributions (type in other contributions here)"},null,{"$f":"SUM(G31:AK31)","v":0},{"$f":"C31-D31","v":0}]
[null,{"$f":"'Budget M1'!B32","v":"  Total Paying the Lord ( D )"},{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0}]
[]
[null,{"$f":"'Budget M1'!B34","v":"Paying Yourself"}]
[null,{"$f":"'Budget M1'!B35","v":"-  Retirement Savings (from (C) deductions above)"},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0}]
[null,{"$f":"'Budget M1'!B36","v":"- Other Savings (type in other contributions here)"},null,{"$f":"SUM(G36:AK36)","v":0},{"$f":"C36-D36","v":0}]
[null,{"$f":"'Budget M1'!B37","v":"  Total Paying Yourself ( E )"},{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0}]
[]
[null,{"$f":"'Budget M1'!B39","v":"Living Expenses"}]
[null,"-  Housing/Rent",null,{"$f":"SUM(G40:AK40)","v":0},{"$f":"C40-D40","v":0}]
[null,{"$f":"'Budget M1'!B41","v":"- Utilities"},null,0,{"$f":"C41-D41","v":0}]
[null,{"$f":"'Budget M1'!B42","v":"- Other Living Expenses (type in other living here)"},null,0,0]
[null,{"$f":"'Budget M1'!B43","v":"  Total Housing Expenditures ( F )"},{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0}]
[]
[null,{"$f":"'Budget M1'!B45","v":"Food"}]
[null,{"$f":"'Budget M1'!B46","v":"-  Food and Supplies"},null,{"$f":"SUM(G46:AK46)","v":0},{"$f":"C46-D46","v":0}]
[null,{"$f":"'Budget M1'!B47","v":"-  Restaurant Expenses"},null,{"$f":"SUM(G47:AK47)","v":0},{"$f":"C47-D47","v":0}]
[null,{"$f":"'Budget M1'!B48","v":"-  Food (type in other food here)"},null,{"$f":"SUM(G48:AK48)","v":0},{"$f":"C48-D48","v":0}]
[null,{"$f":"'Budget M1'!B49","v":"  Total Food Expenditures ( G )"},{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0}]
[]
[null,{"$f":"'Budget M1'!B51","v":"Clothing and Personal Care"}]
[null,"-  Clothing",null,{"$f":"SUM(G52:AK52)","v":0},{"$f":"C52-D52","v":0}]
[null,{"$f":"'Budget M1'!B53","v":"-  Other (type in other personal here)"},null,0,0]
[null,{"$f":"'Budget M1'!B54","v":"  Total Clothing/Personal Care Expenses ( H )"},{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},{"$f":"SUM(E51:E53)","v":0}]
[]
[null,{"$f":"'Budget M1'!B56","v":"Transportation"}]
[null,"-  Automobile",null,{"$f":"SUM(G57:AK57)","v":0},{"$f":"C57-D57","v":0}]
[null,{"$f":"'Budget M1'!B58","v":"-  Gas, Tolls, Parking"},null,0,0]
[null,{"$f":"'Budget M1'!B59","v":"-  Other (type in other transportation here)"},null,0,0]
[null,{"$f":"'Budget M1'!B60","v":"  Total Transportation Expenditures ( I )"},{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0},{"$f":"SUM(E56:E59)","v":0}]
[]
[null,{"$f":"'Budget M1'!B62","v":"Recreation"}]
[null,{"$f":"'Budget M1'!B63","v":"-  Movies, Theater, Sporting Events"},null,{"$f":"SUM(G63:AK63)","v":0},{"$f":"C63-D63","v":0}]
[null,{"$f":"'Budget M1'!B64","v":"-  Other (type in other recreation here)"},null,{"$f":"SUM(G64:AK64)","v":0},{"$f":"C64-D64","v":0}]
[null,{"$f":"'Budget M1'!B65","v":"  Total Recreation Expenditures ( J )"},{"$f":"SUM(C62:C64)","v":0},{"$f":"SUM(D62:D64)","v":0},{"$f":"SUM(E62:E64)","v":0}]
[]
[null,{"$f":"'Budget M1'!B67","v":"Medical Expenditures"}]
[null,{"$f":"'Budget M1'!B68","v":"  -  Medical/Dental Expenses (from (E) deductions above)"},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0}]
[null,{"$f":"'Budget M1'!B69","v":"-  Other Medical (type in other medical here)"},null,{"$f":"SUM(G69:AK69)","v":0},{"$f":"C69-D69","v":0}]
[null,{"$f":"'Budget M1'!B70","v":"  Total Medical Expenditures ( K )"},{"$f":"SUM(C67:C69)","v":0},{"$f":"SUM(D67:D69)","v":0},{"$f":"SUM(E67:E69)","v":0}]
[]
[null,{"$f":"'Budget M1'!B72","v":"Insurance Expenditures"}]
[null,"- Health and Life",null,{"$f":"SUM(G73:AK73)","v":0},{"$f":"C73-D73","v":0}]
[null,{"$f":"'Budget M1'!B74","v":"- Automobile"},null,0,0]
[null,{"$f":"'Budget M1'!B75","v":"- Other (type in other insurance here)"},null,0,0]
[null,{"$f":"'Budget M1'!B76","v":"  Total Insurance Expenditures ( L )"},{"$f":"SUM(C72:C75)","v":0},{"$f":"SUM(D72:D75)","v":0},{"$f":"SUM(E72:E75)","v":0}]
[]
[null,{"$f":"'Budget M1'!B78","v":"Other Expenditures"}]
[null,"-  Education",null,{"$f":"SUM(G79:AK79)","v":0},{"$f":"C79-D79","v":0}]
[null,{"$f":"'Budget M1'!B80","v":"- Child Care"},null,{"$f":"SUM(G80:AK80)","v":0},0]
[null,{"$f":"'Budget M1'!B81","v":"- Other Expenses (type in other expenses here)"},null,{"$f":"SUM(G81:AK81)","v":0},0]
[null,{"$f":"'Budget M1'!B82","v":"  Total Other Expenditures ( M )"},{"$f":"SUM(C79:C81)","v":0},{"$f":"SUM(D79:D81)","v":0},0]
[]
[null,{"$f":"'Budget M1'!B84","v":"Total Living Expenditures (add lines D - M)"},{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0},{"$f":"D82+D76+D70+D65+D60+D54+D49+D43+D37+D32","v":0},{"$f":"E82+E76+E70+E65+E60+E54+E49+E43+E37+E32","v":0}]
[]
[null,{"$f":"'Budget M1'!B86","v":"Additional Income Available for Savings and Investment"},{"$f":"C24-C84","v":0},{"$f":"D24-D84","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,1,"January"]
[null,null,2,"February"]
[null,null,3,"March"]
[null,null,4,"April"]
[null,null,5,"May"]
[null,null,6,"June"]
[null,null,7,"July"]
[null,null,8,"August"]
[null,null,9,"September"]
[null,null,10,"October"]
[null,null,11,"November"]
[null,null,12,"December"]
[]
[null,null,{"$f":"DAY(TODAY())","v":17}]
[null,null,{"$f":"C106-1","v":16}]

{"sheet":"Budget M10","index":10,"n_rows":107,"n_cols":37,"rows_kept":107,"cut":false,"hidden":false,"merged":[[4,2,4,4],[1,1,1,4]]}
[null,{"$f":"\"Personal Budget for the Month of \"&I3&\", \"&I4","v":"Personal Budget for the Month of October, 2018"},null,null,null,"Type in the information below in the correct columns"]
[null,null,null,null,null,null,null,"Type Month and Year below:"]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the ",null,null,null,null,"Month #=",{"$f":"IF('Budget M9'!H3>=12,1,'Budget M9'!H3+1)","v":10},{"$f":"VLOOKUP(H3,Month,2)","v":"October"}]
[null,"                    red or blue cells.  Print off columns A-D for  your Budget each month.",null,null,null,null,"Year =",null,{"$f":"IF('Budget M9'!H3=12,'Budget M9'!I4+1,'Budget M9'!I4)","v":2018}]
[null,null,{"$f":"LEFT(I3,3)&\"-\"&RIGHT(I4,2)","v":"Oct-18"},null,null,null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16","Day 17","Day 18","Day 19","Day 20","Day 21","Day 22","Day 23","Day 24","Day 25","Day 26","Day 27","Day 28","Day 29","Day 30","Day 31"]
[null,"  [Ctrl][Shift] T will set your titles",null,"Income"]
[null,"  [Ctrl][Shift] C will clear your titles","Budget","Statement","Difference"]
[]
[null,"Income"]
[null,{"$f":"'Budget M1'!B10","v":"Wage Earner 1"},null,{"$f":"SUM(G10:AK10)","v":0},{"$f":"D10-C10","v":0}]
[null,{"$f":"'Budget M1'!B11","v":"Wage Earner 2"},null,{"$f":"SUM(G11:AK11)","v":0},0]
[null,{"$f":"'Budget M1'!B12","v":"= Total Wages and salaries"},{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},0]
[null,{"$f":"'Budget M1'!B13","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G13:AK13)","v":0},0]
[null,{"$f":"'Budget M1'!B14","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G14:AK14)","v":0},0]
[null,{"$f":"'Budget M1'!B15","v":"Total Income ( A )"},{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0}]
[]
[null,{"$f":"'Budget M1'!B17","v":"Deductions (Before and After Tax)"}]
[null,"   -  Federal and State Taxes",null,{"$f":"SUM(G18:AK18)","v":0},{"$f":"D18-C18","v":0}]
[null,"    -  Social Security Taxes",null,{"$f":"SUM(G19:AK19)","v":0},{"$f":"D19-C19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",null,{"$f":"SUM(G20:AK20)","v":0},{"$f":"D20-C20","v":0}]
[null,"    -  Medical Plan Deductions (E)",null,{"$f":"SUM(G21:AK21)","v":0},{"$f":"D21-C21","v":0}]
[null,{"$f":"'Budget M1'!B22","v":"    -  Other (type in another deduction here)"},null,{"$f":"SUM(G22:AK22)","v":0},{"$f":"D22-C22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0},{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0}]
[null,"      Take-Home Pay (A - B - C)",{"$f":"C15-C23","v":0},{"$f":"D15-D23","v":0},{"$f":"E15-E23","v":0}]
[null,{"$f":"'Budget M1'!B25","v":"(Income for Living Expenses)"}]
[null,null,"Budget ","Actual"]
[null,null,"Amount","Spending","Difference"]
[null,{"$f":"'Budget M1'!B28","v":"Paying the Lord"}]
[null,{"$f":"'Budget M1'!B29","v":"-  Tithing"},null,{"$f":"SUM(G29:AK29)","v":0},{"$f":"C29-D29","v":0}]
[null,{"$f":"'Budget M1'!B30","v":"-  Fast and Other Offerings"},null,{"$f":"SUM(G30:AK30)","v":0},{"$f":"C30-D30","v":0}]
[null,{"$f":"'Budget M1'!B31","v":"-  Other Contributions (type in other contributions here)"},null,{"$f":"SUM(G31:AK31)","v":0},{"$f":"C31-D31","v":0}]
[null,{"$f":"'Budget M1'!B32","v":"  Total Paying the Lord ( D )"},{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0}]
[]
[null,{"$f":"'Budget M1'!B34","v":"Paying Yourself"}]
[null,{"$f":"'Budget M1'!B35","v":"-  Retirement Savings (from (C) deductions above)"},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0}]
[null,{"$f":"'Budget M1'!B36","v":"- Other Savings (type in other contributions here)"},null,{"$f":"SUM(G36:AK36)","v":0},{"$f":"C36-D36","v":0}]
[null,{"$f":"'Budget M1'!B37","v":"  Total Paying Yourself ( E )"},{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0}]
[]
[null,{"$f":"'Budget M1'!B39","v":"Living Expenses"}]
[null,"-  Housing/Rent",null,{"$f":"SUM(G40:AK40)","v":0},{"$f":"C40-D40","v":0}]
[null,{"$f":"'Budget M1'!B41","v":"- Utilities"},null,0,{"$f":"C41-D41","v":0}]
[null,{"$f":"'Budget M1'!B42","v":"- Other Living Expenses (type in other living here)"},null,0,0]
[null,{"$f":"'Budget M1'!B43","v":"  Total Housing Expenditures ( F )"},{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0}]
[]
[null,{"$f":"'Budget M1'!B45","v":"Food"}]
[null,{"$f":"'Budget M1'!B46","v":"-  Food and Supplies"},null,{"$f":"SUM(G46:AK46)","v":0},{"$f":"C46-D46","v":0}]
[null,{"$f":"'Budget M1'!B47","v":"-  Restaurant Expenses"},null,{"$f":"SUM(G47:AK47)","v":0},{"$f":"C47-D47","v":0}]
[null,{"$f":"'Budget M1'!B48","v":"-  Food (type in other food here)"},null,{"$f":"SUM(G48:AK48)","v":0},{"$f":"C48-D48","v":0}]
[null,{"$f":"'Budget M1'!B49","v":"  Total Food Expenditures ( G )"},{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0}]
[]
[null,{"$f":"'Budget M1'!B51","v":"Clothing and Personal Care"}]
[null,"-  Clothing",null,{"$f":"SUM(G52:AK52)","v":0},{"$f":"C52-D52","v":0}]
[null,{"$f":"'Budget M1'!B53","v":"-  Other (type in other personal here)"},null,0,0]
[null,{"$f":"'Budget M1'!B54","v":"  Total Clothing/Personal Care Expenses ( H )"},{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},{"$f":"SUM(E51:E53)","v":0}]
[]
[null,{"$f":"'Budget M1'!B56","v":"Transportation"}]
[null,"-  Automobile",null,{"$f":"SUM(G57:AK57)","v":0},{"$f":"C57-D57","v":0}]
[null,{"$f":"'Budget M1'!B58","v":"-  Gas, Tolls, Parking"},null,0,0]
[null,{"$f":"'Budget M1'!B59","v":"-  Other (type in other transportation here)"},null,0,0]
[null,{"$f":"'Budget M1'!B60","v":"  Total Transportation Expenditures ( I )"},{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0},{"$f":"SUM(E56:E59)","v":0}]
[]
[null,{"$f":"'Budget M1'!B62","v":"Recreation"}]
[null,{"$f":"'Budget M1'!B63","v":"-  Movies, Theater, Sporting Events"},null,{"$f":"SUM(G63:AK63)","v":0},{"$f":"C63-D63","v":0}]
[null,{"$f":"'Budget M1'!B64","v":"-  Other (type in other recreation here)"},null,{"$f":"SUM(G64:AK64)","v":0},{"$f":"C64-D64","v":0}]
[null,{"$f":"'Budget M1'!B65","v":"  Total Recreation Expenditures ( J )"},{"$f":"SUM(C62:C64)","v":0},{"$f":"SUM(D62:D64)","v":0},{"$f":"SUM(E62:E64)","v":0}]
[]
[null,{"$f":"'Budget M1'!B67","v":"Medical Expenditures"}]
[null,{"$f":"'Budget M1'!B68","v":"  -  Medical/Dental Expenses (from (E) deductions above)"},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0}]
[null,{"$f":"'Budget M1'!B69","v":"-  Other Medical (type in other medical here)"},null,{"$f":"SUM(G69:AK69)","v":0},{"$f":"C69-D69","v":0}]
[null,{"$f":"'Budget M1'!B70","v":"  Total Medical Expenditures ( K )"},{"$f":"SUM(C67:C69)","v":0},{"$f":"SUM(D67:D69)","v":0},{"$f":"SUM(E67:E69)","v":0}]
[]
[null,{"$f":"'Budget M1'!B72","v":"Insurance Expenditures"}]
[null,"- Health and Life",null,{"$f":"SUM(G73:AK73)","v":0},{"$f":"C73-D73","v":0}]
[null,{"$f":"'Budget M1'!B74","v":"- Automobile"},null,0,0]
[null,{"$f":"'Budget M1'!B75","v":"- Other (type in other insurance here)"},null,0,0]
[null,{"$f":"'Budget M1'!B76","v":"  Total Insurance Expenditures ( L )"},{"$f":"SUM(C72:C75)","v":0},{"$f":"SUM(D72:D75)","v":0},{"$f":"SUM(E72:E75)","v":0}]
[]
[null,{"$f":"'Budget M1'!B78","v":"Other Expenditures"}]
[null,"-  Education",null,{"$f":"SUM(G79:AK79)","v":0},{"$f":"C79-D79","v":0}]
[null,{"$f":"'Budget M1'!B80","v":"- Child Care"},null,{"$f":"SUM(G80:AK80)","v":0},0]
[null,{"$f":"'Budget M1'!B81","v":"- Other Expenses (type in other expenses here)"},null,{"$f":"SUM(G81:AK81)","v":0},0]
[null,{"$f":"'Budget M1'!B82","v":"  Total Other Expenditures ( M )"},{"$f":"SUM(C79:C81)","v":0},{"$f":"SUM(D79:D81)","v":0},0]
[]
[null,{"$f":"'Budget M1'!B84","v":"Total Living Expenditures (add lines D - M)"},{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0},{"$f":"D82+D76+D70+D65+D60+D54+D49+D43+D37+D32","v":0},{"$f":"E82+E76+E70+E65+E60+E54+E49+E43+E37+E32","v":0}]
[]
[null,{"$f":"'Budget M1'!B86","v":"Additional Income Available for Savings and Investment"},{"$f":"C24-C84","v":0},{"$f":"D24-D84","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,1,"January"]
[null,null,2,"February"]
[null,null,3,"March"]
[null,null,4,"April"]
[null,null,5,"May"]
[null,null,6,"June"]
[null,null,7,"July"]
[null,null,8,"August"]
[null,null,9,"September"]
[null,null,10,"October"]
[null,null,11,"November"]
[null,null,12,"December"]
[]
[null,null,{"$f":"DAY(TODAY())","v":17}]
[null,null,{"$f":"C106-1","v":16}]

{"sheet":"Budget M11","index":11,"n_rows":107,"n_cols":37,"rows_kept":107,"cut":false,"hidden":false,"merged":[[4,2,4,4],[1,1,1,4]]}
[null,{"$f":"\"Personal Budget for the Month of \"&I3&\", \"&I4","v":"Personal Budget for the Month of November, 2018"},null,null,null,"Type in the information below in the correct columns"]
[null,null,null,null,null,null,null,"Type Month and Year below:"]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the ",null,null,null,null,"Month #=",{"$f":"IF('Budget M10'!H3>=12,1,'Budget M10'!H3+1)","v":11},{"$f":"VLOOKUP(H3,Month,2)","v":"November"}]
[null,"                    red or blue cells.  Print off columns A-D for  your Budget each month.",null,null,null,null,"Year =",null,{"$f":"IF('Budget M10'!H3=12,'Budget M10'!I4+1,'Budget M10'!I4)","v":2018}]
[null,null,{"$f":"LEFT(I3,3)&\"-\"&RIGHT(I4,2)","v":"Nov-18"},null,null,null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16","Day 17","Day 18","Day 19","Day 20","Day 21","Day 22","Day 23","Day 24","Day 25","Day 26","Day 27","Day 28","Day 29","Day 30","Day 31"]
[null,"  [Ctrl][Shift] T will set your titles",null,"Income"]
[null,"  [Ctrl][Shift] C will clear your titles","Budget","Statement","Difference"]
[]
[null,"Income"]
[null,{"$f":"'Budget M1'!B10","v":"Wage Earner 1"},null,{"$f":"SUM(G10:AK10)","v":0},{"$f":"D10-C10","v":0}]
[null,{"$f":"'Budget M1'!B11","v":"Wage Earner 2"},null,{"$f":"SUM(G11:AK11)","v":0},0]
[null,{"$f":"'Budget M1'!B12","v":"= Total Wages and salaries"},{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},0]
[null,{"$f":"'Budget M1'!B13","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G13:AK13)","v":0},0]
[null,{"$f":"'Budget M1'!B14","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G14:AK14)","v":0},0]
[null,{"$f":"'Budget M1'!B15","v":"Total Income ( A )"},{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0}]
[]
[null,{"$f":"'Budget M1'!B17","v":"Deductions (Before and After Tax)"}]
[null,"   -  Federal and State Taxes",null,{"$f":"SUM(G18:AK18)","v":0},{"$f":"D18-C18","v":0}]
[null,"    -  Social Security Taxes",null,{"$f":"SUM(G19:AK19)","v":0},{"$f":"D19-C19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",null,{"$f":"SUM(G20:AK20)","v":0},{"$f":"D20-C20","v":0}]
[null,"    -  Medical Plan Deductions (E)",null,{"$f":"SUM(G21:AK21)","v":0},{"$f":"D21-C21","v":0}]
[null,{"$f":"'Budget M1'!B22","v":"    -  Other (type in another deduction here)"},null,{"$f":"SUM(G22:AK22)","v":0},{"$f":"D22-C22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0},{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0}]
[null,"      Take-Home Pay (A - B - C)",{"$f":"C15-C23","v":0},{"$f":"D15-D23","v":0},{"$f":"E15-E23","v":0}]
[null,{"$f":"'Budget M1'!B25","v":"(Income for Living Expenses)"}]
[null,null,"Budget ","Actual"]
[null,null,"Amount","Spending","Difference"]
[null,{"$f":"'Budget M1'!B28","v":"Paying the Lord"}]
[null,{"$f":"'Budget M1'!B29","v":"-  Tithing"},null,{"$f":"SUM(G29:AK29)","v":0},{"$f":"C29-D29","v":0}]
[null,{"$f":"'Budget M1'!B30","v":"-  Fast and Other Offerings"},null,{"$f":"SUM(G30:AK30)","v":0},{"$f":"C30-D30","v":0}]
[null,{"$f":"'Budget M1'!B31","v":"-  Other Contributions (type in other contributions here)"},null,{"$f":"SUM(G31:AK31)","v":0},{"$f":"C31-D31","v":0}]
[null,{"$f":"'Budget M1'!B32","v":"  Total Paying the Lord ( D )"},{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0}]
[]
[null,{"$f":"'Budget M1'!B34","v":"Paying Yourself"}]
[null,{"$f":"'Budget M1'!B35","v":"-  Retirement Savings (from (C) deductions above)"},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0}]
[null,{"$f":"'Budget M1'!B36","v":"- Other Savings (type in other contributions here)"},null,{"$f":"SUM(G36:AK36)","v":0},{"$f":"C36-D36","v":0}]
[null,{"$f":"'Budget M1'!B37","v":"  Total Paying Yourself ( E )"},{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0}]
[]
[null,{"$f":"'Budget M1'!B39","v":"Living Expenses"}]
[null,"-  Housing/Rent",null,{"$f":"SUM(G40:AK40)","v":0},{"$f":"C40-D40","v":0}]
[null,{"$f":"'Budget M1'!B41","v":"- Utilities"},null,0,{"$f":"C41-D41","v":0}]
[null,{"$f":"'Budget M1'!B42","v":"- Other Living Expenses (type in other living here)"},null,0,0]
[null,{"$f":"'Budget M1'!B43","v":"  Total Housing Expenditures ( F )"},{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0}]
[]
[null,{"$f":"'Budget M1'!B45","v":"Food"}]
[null,{"$f":"'Budget M1'!B46","v":"-  Food and Supplies"},null,{"$f":"SUM(G46:AK46)","v":0},{"$f":"C46-D46","v":0}]
[null,{"$f":"'Budget M1'!B47","v":"-  Restaurant Expenses"},null,{"$f":"SUM(G47:AK47)","v":0},{"$f":"C47-D47","v":0}]
[null,{"$f":"'Budget M1'!B48","v":"-  Food (type in other food here)"},null,{"$f":"SUM(G48:AK48)","v":0},{"$f":"C48-D48","v":0}]
[null,{"$f":"'Budget M1'!B49","v":"  Total Food Expenditures ( G )"},{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0}]
[]
[null,{"$f":"'Budget M1'!B51","v":"Clothing and Personal Care"}]
[null,"-  Clothing",null,{"$f":"SUM(G52:AK52)","v":0},{"$f":"C52-D52","v":0}]
[null,{"$f":"'Budget M1'!B53","v":"-  Other (type in other personal here)"},null,0,0]
[null,{"$f":"'Budget M1'!B54","v":"  Total Clothing/Personal Care Expenses ( H )"},{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},{"$f":"SUM(E51:E53)","v":0}]
[]
[null,{"$f":"'Budget M1'!B56","v":"Transportation"}]
[null,"-  Automobile",null,{"$f":"SUM(G57:AK57)","v":0},{"$f":"C57-D57","v":0}]
[null,{"$f":"'Budget M1'!B58","v":"-  Gas, Tolls, Parking"},null,0,0]
[null,{"$f":"'Budget M1'!B59","v":"-  Other (type in other transportation here)"},null,0,0]
[null,{"$f":"'Budget M1'!B60","v":"  Total Transportation Expenditures ( I )"},{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0},{"$f":"SUM(E56:E59)","v":0}]
[]
[null,{"$f":"'Budget M1'!B62","v":"Recreation"}]
[null,{"$f":"'Budget M1'!B63","v":"-  Movies, Theater, Sporting Events"},null,{"$f":"SUM(G63:AK63)","v":0},{"$f":"C63-D63","v":0}]
[null,{"$f":"'Budget M1'!B64","v":"-  Other (type in other recreation here)"},null,{"$f":"SUM(G64:AK64)","v":0},{"$f":"C64-D64","v":0}]
[null,{"$f":"'Budget M1'!B65","v":"  Total Recreation Expenditures ( J )"},{"$f":"SUM(C62:C64)","v":0},{"$f":"SUM(D62:D64)","v":0},{"$f":"SUM(E62:E64)","v":0}]
[]
[null,{"$f":"'Budget M1'!B67","v":"Medical Expenditures"}]
[null,{"$f":"'Budget M1'!B68","v":"  -  Medical/Dental Expenses (from (E) deductions above)"},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0}]
[null,{"$f":"'Budget M1'!B69","v":"-  Other Medical (type in other medical here)"},null,{"$f":"SUM(G69:AK69)","v":0},{"$f":"C69-D69","v":0}]
[null,{"$f":"'Budget M1'!B70","v":"  Total Medical Expenditures ( K )"},{"$f":"SUM(C67:C69)","v":0},{"$f":"SUM(D67:D69)","v":0},{"$f":"SUM(E67:E69)","v":0}]
[]
[null,{"$f":"'Budget M1'!B72","v":"Insurance Expenditures"}]
[null,"- Health and Life",null,{"$f":"SUM(G73:AK73)","v":0},{"$f":"C73-D73","v":0}]
[null,{"$f":"'Budget M1'!B74","v":"- Automobile"},null,0,0]
[null,{"$f":"'Budget M1'!B75","v":"- Other (type in other insurance here)"},null,0,0]
[null,{"$f":"'Budget M1'!B76","v":"  Total Insurance Expenditures ( L )"},{"$f":"SUM(C72:C75)","v":0},{"$f":"SUM(D72:D75)","v":0},{"$f":"SUM(E72:E75)","v":0}]
[]
[null,{"$f":"'Budget M1'!B78","v":"Other Expenditures"}]
[null,"-  Education",null,{"$f":"SUM(G79:AK79)","v":0},{"$f":"C79-D79","v":0}]
[null,{"$f":"'Budget M1'!B80","v":"- Child Care"},null,{"$f":"SUM(G80:AK80)","v":0},0]
[null,{"$f":"'Budget M1'!B81","v":"- Other Expenses (type in other expenses here)"},null,{"$f":"SUM(G81:AK81)","v":0},0]
[null,{"$f":"'Budget M1'!B82","v":"  Total Other Expenditures ( M )"},{"$f":"SUM(C79:C81)","v":0},{"$f":"SUM(D79:D81)","v":0},0]
[]
[null,{"$f":"'Budget M1'!B84","v":"Total Living Expenditures (add lines D - M)"},{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0},{"$f":"D82+D76+D70+D65+D60+D54+D49+D43+D37+D32","v":0},{"$f":"E82+E76+E70+E65+E60+E54+E49+E43+E37+E32","v":0}]
[]
[null,{"$f":"'Budget M1'!B86","v":"Additional Income Available for Savings and Investment"},{"$f":"C24-C84","v":0},{"$f":"D24-D84","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,1,"January"]
[null,null,2,"February"]
[null,null,3,"March"]
[null,null,4,"April"]
[null,null,5,"May"]
[null,null,6,"June"]
[null,null,7,"July"]
[null,null,8,"August"]
[null,null,9,"September"]
[null,null,10,"October"]
[null,null,11,"November"]
[null,null,12,"December"]
[]
[null,null,{"$f":"DAY(TODAY())","v":17}]
[null,null,{"$f":"C106-1","v":16}]

{"sheet":"Budget M12","index":12,"n_rows":107,"n_cols":37,"rows_kept":107,"cut":false,"hidden":false,"merged":[[4,2,4,4],[1,1,1,4]]}
[null,{"$f":"\"Personal Budget for the Month of \"&I3&\", \"&I4","v":"Personal Budget for the Month of December, 2018"},null,null,null,"Type in the information below in the correct columns"]
[null,null,null,null,null,null,null,"Type Month and Year below:"]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the ",null,null,null,null,"Month #=",{"$f":"IF('Budget M11'!H3>=12,1,'Budget M11'!H3+1)","v":12},{"$f":"VLOOKUP(H3,Month,2)","v":"December"}]
[null,"                    red or blue cells.  Print off columns A-D for  your Budget each month.",null,null,null,null,"Year =",null,{"$f":"IF('Budget M11'!H3=12,'Budget M11'!I4+1,'Budget M11'!I4)","v":2018}]
[null,null,{"$f":"LEFT(I3,3)&\"-\"&RIGHT(I4,2)","v":"Dec-18"},null,null,null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16","Day 17","Day 18","Day 19","Day 20","Day 21","Day 22","Day 23","Day 24","Day 25","Day 26","Day 27","Day 28","Day 29","Day 30","Day 31"]
[null,"  [Ctrl][Shift] T will set your titles",null,"Income"]
[null,"  [Ctrl][Shift] C will clear your titles","Budget","Statement","Difference"]
[]
[null,"Income"]
[null,{"$f":"'Budget M1'!B10","v":"Wage Earner 1"},null,{"$f":"SUM(G10:AK10)","v":0},{"$f":"D10-C10","v":0}]
[null,{"$f":"'Budget M1'!B11","v":"Wage Earner 2"},null,{"$f":"SUM(G11:AK11)","v":0},0]
[null,{"$f":"'Budget M1'!B12","v":"= Total Wages and salaries"},{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},0]
[null,{"$f":"'Budget M1'!B13","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G13:AK13)","v":0},0]
[null,{"$f":"'Budget M1'!B14","v":"+ Other (Type in another source here)"},null,{"$f":"SUM(G14:AK14)","v":0},0]
[null,{"$f":"'Budget M1'!B15","v":"Total Income ( A )"},{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0}]
[]
[null,{"$f":"'Budget M1'!B17","v":"Deductions (Before and After Tax)"}]
[null,"   -  Federal and State Taxes",null,{"$f":"SUM(G18:AK18)","v":0},{"$f":"D18-C18","v":0}]
[null,"    -  Social Security Taxes",null,{"$f":"SUM(G19:AK19)","v":0},{"$f":"D19-C19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",null,{"$f":"SUM(G20:AK20)","v":0},{"$f":"D20-C20","v":0}]
[null,"    -  Medical Plan Deductions (E)",null,{"$f":"SUM(G21:AK21)","v":0},{"$f":"D21-C21","v":0}]
[null,{"$f":"'Budget M1'!B22","v":"    -  Other (type in another deduction here)"},null,{"$f":"SUM(G22:AK22)","v":0},{"$f":"D22-C22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0},{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0}]
[null,"      Take-Home Pay (A - B - C)",{"$f":"C15-C23","v":0},{"$f":"D15-D23","v":0},{"$f":"E15-E23","v":0}]
[null,{"$f":"'Budget M1'!B25","v":"(Income for Living Expenses)"}]
[null,null,"Budget ","Actual"]
[null,null,"Amount","Spending","Difference"]
[null,{"$f":"'Budget M1'!B28","v":"Paying the Lord"}]
[null,{"$f":"'Budget M1'!B29","v":"-  Tithing"},null,{"$f":"SUM(G29:AK29)","v":0},{"$f":"C29-D29","v":0}]
[null,{"$f":"'Budget M1'!B30","v":"-  Fast and Other Offerings"},null,{"$f":"SUM(G30:AK30)","v":0},{"$f":"C30-D30","v":0}]
[null,{"$f":"'Budget M1'!B31","v":"-  Other Contributions (type in other contributions here)"},null,{"$f":"SUM(G31:AK31)","v":0},{"$f":"C31-D31","v":0}]
[null,{"$f":"'Budget M1'!B32","v":"  Total Paying the Lord ( D )"},{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0}]
[]
[null,{"$f":"'Budget M1'!B34","v":"Paying Yourself"}]
[null,{"$f":"'Budget M1'!B35","v":"-  Retirement Savings (from (C) deductions above)"},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0}]
[null,{"$f":"'Budget M1'!B36","v":"- Other Savings (type in other contributions here)"},null,{"$f":"SUM(G36:AK36)","v":0},{"$f":"C36-D36","v":0}]
[null,{"$f":"'Budget M1'!B37","v":"  Total Paying Yourself ( E )"},{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0}]
[]
[null,{"$f":"'Budget M1'!B39","v":"Living Expenses"}]
[null,"-  Housing/Rent",null,{"$f":"SUM(G40:AK40)","v":0},{"$f":"C40-D40","v":0}]
[null,{"$f":"'Budget M1'!B41","v":"- Utilities"},null,0,{"$f":"C41-D41","v":0}]
[null,{"$f":"'Budget M1'!B42","v":"- Other Living Expenses (type in other living here)"},null,0,0]
[null,{"$f":"'Budget M1'!B43","v":"  Total Housing Expenditures ( F )"},{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0}]
[]
[null,{"$f":"'Budget M1'!B45","v":"Food"}]
[null,{"$f":"'Budget M1'!B46","v":"-  Food and Supplies"},null,{"$f":"SUM(G46:AK46)","v":0},{"$f":"C46-D46","v":0}]
[null,{"$f":"'Budget M1'!B47","v":"-  Restaurant Expenses"},null,{"$f":"SUM(G47:AK47)","v":0},{"$f":"C47-D47","v":0}]
[null,{"$f":"'Budget M1'!B48","v":"-  Food (type in other food here)"},null,{"$f":"SUM(G48:AK48)","v":0},{"$f":"C48-D48","v":0}]
[null,{"$f":"'Budget M1'!B49","v":"  Total Food Expenditures ( G )"},{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0}]
[]
[null,{"$f":"'Budget M1'!B51","v":"Clothing and Personal Care"}]
[null,"-  Clothing",null,{"$f":"SUM(G52:AK52)","v":0},{"$f":"C52-D52","v":0}]
[null,{"$f":"'Budget M1'!B53","v":"-  Other (type in other personal here)"},null,0,0]
[null,{"$f":"'Budget M1'!B54","v":"  Total Clothing/Personal Care Expenses ( H )"},{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},{"$f":"SUM(E51:E53)","v":0}]
[]
[null,{"$f":"'Budget M1'!B56","v":"Transportation"}]
[null,"-  Automobile",null,{"$f":"SUM(G57:AK57)","v":0},{"$f":"C57-D57","v":0}]
[null,{"$f":"'Budget M1'!B58","v":"-  Gas, Tolls, Parking"},null,0,0]
[null,{"$f":"'Budget M1'!B59","v":"-  Other (type in other transportation here)"},null,0,0]
[null,{"$f":"'Budget M1'!B60","v":"  Total Transportation Expenditures ( I )"},{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0},{"$f":"SUM(E56:E59)","v":0}]
[]
[null,{"$f":"'Budget M1'!B62","v":"Recreation"}]
[null,{"$f":"'Budget M1'!B63","v":"-  Movies, Theater, Sporting Events"},null,{"$f":"SUM(G63:AK63)","v":0},{"$f":"C63-D63","v":0}]
[null,{"$f":"'Budget M1'!B64","v":"-  Other (type in other recreation here)"},null,{"$f":"SUM(G64:AK64)","v":0},{"$f":"C64-D64","v":0}]
[null,{"$f":"'Budget M1'!B65","v":"  Total Recreation Expenditures ( J )"},{"$f":"SUM(C62:C64)","v":0},{"$f":"SUM(D62:D64)","v":0},{"$f":"SUM(E62:E64)","v":0}]
[]
[null,{"$f":"'Budget M1'!B67","v":"Medical Expenditures"}]
[null,{"$f":"'Budget M1'!B68","v":"  -  Medical/Dental Expenses (from (E) deductions above)"},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0}]
[null,{"$f":"'Budget M1'!B69","v":"-  Other Medical (type in other medical here)"},null,{"$f":"SUM(G69:AK69)","v":0},{"$f":"C69-D69","v":0}]
[null,{"$f":"'Budget M1'!B70","v":"  Total Medical Expenditures ( K )"},{"$f":"SUM(C67:C69)","v":0},{"$f":"SUM(D67:D69)","v":0},{"$f":"SUM(E67:E69)","v":0}]
[]
[null,{"$f":"'Budget M1'!B72","v":"Insurance Expenditures"}]
[null,"- Health and Life",null,{"$f":"SUM(G73:AK73)","v":0},{"$f":"C73-D73","v":0}]
[null,{"$f":"'Budget M1'!B74","v":"- Automobile"},null,0,0]
[null,{"$f":"'Budget M1'!B75","v":"- Other (type in other insurance here)"},null,0,0]
[null,{"$f":"'Budget M1'!B76","v":"  Total Insurance Expenditures ( L )"},{"$f":"SUM(C72:C75)","v":0},{"$f":"SUM(D72:D75)","v":0},{"$f":"SUM(E72:E75)","v":0}]
[]
[null,{"$f":"'Budget M1'!B78","v":"Other Expenditures"}]
[null,"-  Education",null,{"$f":"SUM(G79:AK79)","v":0},{"$f":"C79-D79","v":0}]
[null,{"$f":"'Budget M1'!B80","v":"- Child Care"},null,{"$f":"SUM(G80:AK80)","v":0},0]
[null,{"$f":"'Budget M1'!B81","v":"- Other Expenses (type in other expenses here)"},null,{"$f":"SUM(G81:AK81)","v":0},0]
[null,{"$f":"'Budget M1'!B82","v":"  Total Other Expenditures ( M )"},{"$f":"SUM(C79:C81)","v":0},{"$f":"SUM(D79:D81)","v":0},0]
[]
[null,{"$f":"'Budget M1'!B84","v":"Total Living Expenditures (add lines D - M)"},{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0},{"$f":"D82+D76+D70+D65+D60+D54+D49+D43+D37+D32","v":0},{"$f":"E82+E76+E70+E65+E60+E54+E49+E43+E37+E32","v":0}]
[]
[null,{"$f":"'Budget M1'!B86","v":"Additional Income Available for Savings and Investment"},{"$f":"C24-C84","v":0},{"$f":"D24-D84","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,1,"January"]
[null,null,2,"February"]
[null,null,3,"March"]
[null,null,4,"April"]
[null,null,5,"May"]
[null,null,6,"June"]
[null,null,7,"July"]
[null,null,8,"August"]
[null,null,9,"September"]
[null,null,10,"October"]
[null,null,11,"November"]
[null,null,12,"December"]
[]
[null,null,{"$f":"DAY(TODAY())","v":17}]
[null,null,{"$f":"C106-1","v":16}]

{"sheet":"1 Year Budget","index":13,"n_rows":107,"n_cols":14,"rows_kept":107,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,{"$f":"\"One Year Budget for the Period Beginning \"&C5&\" to \"&N5&\" By Month\"","v":"One Year Budget for the Period Beginning Jan-18 to Dec-18 By Month"}]
[]
[]
[]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the ",{"$f":"'Budget M1'!$C5","v":"Jan-18"},{"$f":"'Budget M2'!$C5","v":"Feb-18"},{"$f":"'Budget M3'!$C5","v":"Mar-18"},{"$f":"'Budget M4'!$C5","v":"Apr-18"},{"$f":"'Budget M5'!$C5","v":"May-18"},{"$f":"'Budget M6'!$C5","v":"Jun-18"},{"$f":"'Budget M7'!$C5","v":"Jul-18"},{"$f":"'Budget M8'!$C5","v":"Aug-18"},{"$f":"'Budget M9'!$C5","v":"Sep-18"},{"$f":"'Budget M10'!$C5","v":"Oct-18"},{"$f":"'Budget M11'!$C5","v":"Nov-18"},{"$f":"'Budget M12'!$C5","v":"Dec-18"}]
[null,"                    red or blue cells.  Print off columns A-D for  your Budget each month.","Budget","Budget","Budget","Budget","Budget","Budget","Budget","Budget","Budget","Budget","Budget","Budget"]
[]
[]
[null,"Income"]
[null,"Wage Earner 1",{"$f":"'Budget M1'!$C10","v":0},{"$f":"'Budget M2'!$C10","v":0},{"$f":"'Budget M3'!$C10","v":0},{"$f":"'Budget M4'!$C10","v":0},{"$f":"'Budget M5'!$C10","v":0},{"$f":"'Budget M6'!$C10","v":0},{"$f":"'Budget M7'!$C10","v":0},{"$f":"'Budget M8'!$C10","v":0},{"$f":"'Budget M9'!$C10","v":0},{"$f":"'Budget M10'!$C10","v":0},{"$f":"'Budget M11'!$C10","v":0},{"$f":"'Budget M12'!$C10","v":0}]
[null,"Wage Earner 2",{"$f":"'Budget M1'!$C11","v":0},{"$f":"'Budget M2'!$C11","v":0},{"$f":"'Budget M3'!$C11","v":0},{"$f":"'Budget M4'!$C11","v":0},{"$f":"'Budget M5'!$C11","v":0},{"$f":"'Budget M6'!$C11","v":0},{"$f":"'Budget M7'!$C11","v":0},{"$f":"'Budget M8'!$C11","v":0},{"$f":"'Budget M9'!$C11","v":0},{"$f":"'Budget M10'!$C11","v":0},{"$f":"'Budget M11'!$C11","v":0},{"$f":"'Budget M12'!$C11","v":0}]
[null,"= Total Wages and salaries",{"$f":"'Budget M1'!$C12","v":0},{"$f":"'Budget M2'!$C12","v":0},{"$f":"'Budget M3'!$C12","v":0},{"$f":"'Budget M4'!$C12","v":0},{"$f":"'Budget M5'!$C12","v":0},{"$f":"'Budget M6'!$C12","v":0},{"$f":"'Budget M7'!$C12","v":0},{"$f":"'Budget M8'!$C12","v":0},{"$f":"'Budget M9'!$C12","v":0},{"$f":"'Budget M10'!$C12","v":0},{"$f":"'Budget M11'!$C12","v":0},{"$f":"'Budget M12'!$C12","v":0}]
[null,"+ Other (Type in another source here)",{"$f":"'Budget M1'!$C13","v":0},{"$f":"'Budget M2'!$C13","v":0},{"$f":"'Budget M3'!$C13","v":0},{"$f":"'Budget M4'!$C13","v":0},{"$f":"'Budget M5'!$C13","v":0},{"$f":"'Budget M6'!$C13","v":0},{"$f":"'Budget M7'!$C13","v":0},{"$f":"'Budget M8'!$C13","v":0},{"$f":"'Budget M9'!$C13","v":0},{"$f":"'Budget M10'!$C13","v":0},{"$f":"'Budget M11'!$C13","v":0},{"$f":"'Budget M12'!$C13","v":0}]
[null,"+ Other (Type in another source here)",{"$f":"'Budget M1'!$C14","v":0},{"$f":"'Budget M2'!$C14","v":0},{"$f":"'Budget M3'!$C14","v":0},{"$f":"'Budget M4'!$C14","v":0},{"$f":"'Budget M5'!$C14","v":0},{"$f":"'Budget M6'!$C14","v":0},{"$f":"'Budget M7'!$C14","v":0},{"$f":"'Budget M8'!$C14","v":0},{"$f":"'Budget M9'!$C14","v":0},{"$f":"'Budget M10'!$C14","v":0},{"$f":"'Budget M11'!$C14","v":0},{"$f":"'Budget M12'!$C14","v":0}]
[null,"Total Income ( A )",{"$f":"'Budget M1'!$C15","v":0},{"$f":"'Budget M2'!$C15","v":0},{"$f":"'Budget M3'!$C15","v":0},{"$f":"'Budget M4'!$C15","v":0},{"$f":"'Budget M5'!$C15","v":0},{"$f":"'Budget M6'!$C15","v":0},{"$f":"'Budget M7'!$C15","v":0},{"$f":"'Budget M8'!$C15","v":0},{"$f":"'Budget M9'!$C15","v":0},{"$f":"'Budget M10'!$C15","v":0},{"$f":"'Budget M11'!$C15","v":0},{"$f":"'Budget M12'!$C15","v":0}]
[]
[null,"Deductions (Before and After Tax)"]
[null,"   -  Federal and State Taxes",{"$f":"'Budget M1'!$C18","v":0},{"$f":"'Budget M2'!$C18","v":0},{"$f":"'Budget M3'!$C18","v":0},{"$f":"'Budget M4'!$C18","v":0},{"$f":"'Budget M5'!$C18","v":0},{"$f":"'Budget M6'!$C18","v":0},{"$f":"'Budget M7'!$C18","v":0},{"$f":"'Budget M8'!$C18","v":0},{"$f":"'Budget M9'!$C18","v":0},{"$f":"'Budget M10'!$C18","v":0},{"$f":"'Budget M11'!$C18","v":0},{"$f":"'Budget M12'!$C18","v":0}]
[null,"    -  Social Security Taxes",{"$f":"'Budget M1'!$C19","v":0},{"$f":"'Budget M2'!$C19","v":0},{"$f":"'Budget M3'!$C19","v":0},{"$f":"'Budget M4'!$C19","v":0},{"$f":"'Budget M5'!$C19","v":0},{"$f":"'Budget M6'!$C19","v":0},{"$f":"'Budget M7'!$C19","v":0},{"$f":"'Budget M8'!$C19","v":0},{"$f":"'Budget M9'!$C19","v":0},{"$f":"'Budget M10'!$C19","v":0},{"$f":"'Budget M11'!$C19","v":0},{"$f":"'Budget M12'!$C19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",{"$f":"'Budget M1'!$C20","v":0},{"$f":"'Budget M2'!$C20","v":0},{"$f":"'Budget M3'!$C20","v":0},{"$f":"'Budget M4'!$C20","v":0},{"$f":"'Budget M5'!$C20","v":0},{"$f":"'Budget M6'!$C20","v":0},{"$f":"'Budget M7'!$C20","v":0},{"$f":"'Budget M8'!$C20","v":0},{"$f":"'Budget M9'!$C20","v":0},{"$f":"'Budget M10'!$C20","v":0},{"$f":"'Budget M11'!$C20","v":0},{"$f":"'Budget M12'!$C20","v":0}]
[null,"    -  Medical Plan Deductions (E)",{"$f":"'Budget M1'!$C21","v":0},{"$f":"'Budget M2'!$C21","v":0},{"$f":"'Budget M3'!$C21","v":0},{"$f":"'Budget M4'!$C21","v":0},{"$f":"'Budget M5'!$C21","v":0},{"$f":"'Budget M6'!$C21","v":0},{"$f":"'Budget M7'!$C21","v":0},{"$f":"'Budget M8'!$C21","v":0},{"$f":"'Budget M9'!$C21","v":0},{"$f":"'Budget M10'!$C21","v":0},{"$f":"'Budget M11'!$C21","v":0},{"$f":"'Budget M12'!$C21","v":0}]
[null,"    -  Other (type in another deduction here)",{"$f":"'Budget M1'!$C22","v":0},{"$f":"'Budget M2'!$C22","v":0},{"$f":"'Budget M3'!$C22","v":0},{"$f":"'Budget M4'!$C22","v":0},{"$f":"'Budget M5'!$C22","v":0},{"$f":"'Budget M6'!$C22","v":0},{"$f":"'Budget M7'!$C22","v":0},{"$f":"'Budget M8'!$C22","v":0},{"$f":"'Budget M9'!$C22","v":0},{"$f":"'Budget M10'!$C22","v":0},{"$f":"'Budget M11'!$C22","v":0},{"$f":"'Budget M12'!$C22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"'Budget M1'!$C23","v":0},{"$f":"'Budget M2'!$C23","v":0},{"$f":"'Budget M3'!$C23","v":0},{"$f":"'Budget M4'!$C23","v":0},{"$f":"'Budget M5'!$C23","v":0},{"$f":"'Budget M6'!$C23","v":0},{"$f":"'Budget M7'!$C23","v":0},{"$f":"'Budget M8'!$C23","v":0},{"$f":"'Budget M9'!$C23","v":0},{"$f":"'Budget M10'!$C23","v":0},{"$f":"'Budget M11'!$C23","v":0},{"$f":"'Budget M12'!$C23","v":0}]
[null,"      Take-Home Pay (A - B - C - E)",{"$f":"'Budget M1'!$C24","v":0},{"$f":"'Budget M2'!$C24","v":0},{"$f":"'Budget M3'!$C24","v":0},{"$f":"'Budget M4'!$C24","v":0},{"$f":"'Budget M5'!$C24","v":0},{"$f":"'Budget M6'!$C24","v":0},{"$f":"'Budget M7'!$C24","v":0},{"$f":"'Budget M8'!$C24","v":0},{"$f":"'Budget M9'!$C24","v":0},{"$f":"'Budget M10'!$C24","v":0},{"$f":"'Budget M11'!$C24","v":0},{"$f":"'Budget M12'!$C24","v":0}]
[null,"      but before Retirement and Medical Deductions",{"$f":"'Budget M1'!$C25","v":0},{"$f":"'Budget M2'!$C25","v":0},{"$f":"'Budget M3'!$C25","v":0},{"$f":"'Budget M4'!$C25","v":0},{"$f":"'Budget M5'!$C25","v":0},{"$f":"'Budget M6'!$C25","v":0},{"$f":"'Budget M7'!$C25","v":0},{"$f":"'Budget M8'!$C25","v":0},{"$f":"'Budget M9'!$C25","v":0},{"$f":"'Budget M10'!$C25","v":0},{"$f":"'Budget M11'!$C25","v":0},{"$f":"'Budget M12'!$C25","v":0}]
[]
[]
[null,"Paying the Lord"]
[null,"-  Tithing",{"$f":"'Budget M1'!$C29","v":0},{"$f":"'Budget M2'!$C29","v":0},{"$f":"'Budget M3'!$C29","v":0},{"$f":"'Budget M4'!$C29","v":0},{"$f":"'Budget M5'!$C29","v":0},{"$f":"'Budget M6'!$C29","v":0},{"$f":"'Budget M7'!$C29","v":0},{"$f":"'Budget M8'!$C29","v":0},{"$f":"'Budget M9'!$C29","v":0},{"$f":"'Budget M10'!$C29","v":0},{"$f":"'Budget M11'!$C29","v":0},{"$f":"'Budget M12'!$C29","v":0}]
[null,"-  Fast and Other Offerings",{"$f":"'Budget M1'!$C30","v":0},{"$f":"'Budget M2'!$C30","v":0},{"$f":"'Budget M3'!$C30","v":0},{"$f":"'Budget M4'!$C30","v":0},{"$f":"'Budget M5'!$C30","v":0},{"$f":"'Budget M6'!$C30","v":0},{"$f":"'Budget M7'!$C30","v":0},{"$f":"'Budget M8'!$C30","v":0},{"$f":"'Budget M9'!$C30","v":0},{"$f":"'Budget M10'!$C30","v":0},{"$f":"'Budget M11'!$C30","v":0},{"$f":"'Budget M12'!$C30","v":0}]
[null,"-  Other Contributions (type in other contributions here)",{"$f":"'Budget M1'!$C31","v":0},{"$f":"'Budget M2'!$C31","v":0},{"$f":"'Budget M3'!$C31","v":0},{"$f":"'Budget M4'!$C31","v":0},{"$f":"'Budget M5'!$C31","v":0},{"$f":"'Budget M6'!$C31","v":0},{"$f":"'Budget M7'!$C31","v":0},{"$f":"'Budget M8'!$C31","v":0},{"$f":"'Budget M9'!$C31","v":0},{"$f":"'Budget M10'!$C31","v":0},{"$f":"'Budget M11'!$C31","v":0},{"$f":"'Budget M12'!$C31","v":0}]
[null,"  Total Paying the Lord ( D )",{"$f":"'Budget M1'!$C32","v":0},{"$f":"'Budget M2'!$C32","v":0},{"$f":"'Budget M3'!$C32","v":0},{"$f":"'Budget M4'!$C32","v":0},{"$f":"'Budget M5'!$C32","v":0},{"$f":"'Budget M6'!$C32","v":0},{"$f":"'Budget M7'!$C32","v":0},{"$f":"'Budget M8'!$C32","v":0},{"$f":"'Budget M9'!$C32","v":0},{"$f":"'Budget M10'!$C32","v":0},{"$f":"'Budget M11'!$C32","v":0},{"$f":"'Budget M12'!$C32","v":0}]
[]
[null,"Paying Yourself"]
[null,"-  Retirement Savings (from (D) deductions above)",{"$f":"'Budget M1'!$C35","v":0},{"$f":"'Budget M2'!$C35","v":0},{"$f":"'Budget M3'!$C35","v":0},{"$f":"'Budget M4'!$C35","v":0},{"$f":"'Budget M5'!$C35","v":0},{"$f":"'Budget M6'!$C35","v":0},{"$f":"'Budget M7'!$C35","v":0},{"$f":"'Budget M8'!$C35","v":0},{"$f":"'Budget M9'!$C35","v":0},{"$f":"'Budget M10'!$C35","v":0},{"$f":"'Budget M11'!$C35","v":0},{"$f":"'Budget M12'!$C35","v":0}]
[null,"- Other Savings (type in other contributions here)",{"$f":"'Budget M1'!$C36","v":0},{"$f":"'Budget M2'!$C36","v":0},{"$f":"'Budget M3'!$C36","v":0},{"$f":"'Budget M4'!$C36","v":0},{"$f":"'Budget M5'!$C36","v":0},{"$f":"'Budget M6'!$C36","v":0},{"$f":"'Budget M7'!$C36","v":0},{"$f":"'Budget M8'!$C36","v":0},{"$f":"'Budget M9'!$C36","v":0},{"$f":"'Budget M10'!$C36","v":0},{"$f":"'Budget M11'!$C36","v":0},{"$f":"'Budget M12'!$C36","v":0}]
[null,"  Total Paying Yourself ( E )",{"$f":"'Budget M1'!$C37","v":0},{"$f":"'Budget M2'!$C37","v":0},{"$f":"'Budget M3'!$C37","v":0},{"$f":"'Budget M4'!$C37","v":0},{"$f":"'Budget M5'!$C37","v":0},{"$f":"'Budget M6'!$C37","v":0},{"$f":"'Budget M7'!$C37","v":0},{"$f":"'Budget M8'!$C37","v":0},{"$f":"'Budget M9'!$C37","v":0},{"$f":"'Budget M10'!$C37","v":0},{"$f":"'Budget M11'!$C37","v":0},{"$f":"'Budget M12'!$C37","v":0}]
[]
[null,"Living Expenses"]
[null,"-  Housing/Rent",{"$f":"'Budget M1'!$C40","v":0},{"$f":"'Budget M2'!$C40","v":0},{"$f":"'Budget M3'!$C40","v":0},{"$f":"'Budget M4'!$C40","v":0},{"$f":"'Budget M5'!$C40","v":0},{"$f":"'Budget M6'!$C40","v":0},{"$f":"'Budget M7'!$C40","v":0},{"$f":"'Budget M8'!$C40","v":0},{"$f":"'Budget M9'!$C40","v":0},{"$f":"'Budget M10'!$C40","v":0},{"$f":"'Budget M11'!$C40","v":0},{"$f":"'Budget M12'!$C40","v":0}]
[null,"- Utilities",{"$f":"'Budget M1'!$C41","v":0},{"$f":"'Budget M2'!$C41","v":0},{"$f":"'Budget M3'!$C41","v":0},{"$f":"'Budget M4'!$C41","v":0},{"$f":"'Budget M5'!$C41","v":0},{"$f":"'Budget M6'!$C41","v":0},{"$f":"'Budget M7'!$C41","v":0},{"$f":"'Budget M8'!$C41","v":0},{"$f":"'Budget M9'!$C41","v":0},{"$f":"'Budget M10'!$C41","v":0},{"$f":"'Budget M11'!$C41","v":0},{"$f":"'Budget M12'!$C41","v":0}]
[null,"- Other Living Expenses (type in other living here)",{"$f":"'Budget M1'!$C42","v":0},{"$f":"'Budget M2'!$C42","v":0},{"$f":"'Budget M3'!$C42","v":0},{"$f":"'Budget M4'!$C42","v":0},{"$f":"'Budget M5'!$C42","v":0},{"$f":"'Budget M6'!$C42","v":0},{"$f":"'Budget M7'!$C42","v":0},{"$f":"'Budget M8'!$C42","v":0},{"$f":"'Budget M9'!$C42","v":0},{"$f":"'Budget M10'!$C42","v":0},{"$f":"'Budget M11'!$C42","v":0},{"$f":"'Budget M12'!$C42","v":0}]
[null,"  Total Housing Expenditures ( F )",{"$f":"'Budget M1'!$C43","v":0},{"$f":"'Budget M2'!$C43","v":0},{"$f":"'Budget M3'!$C43","v":0},{"$f":"'Budget M4'!$C43","v":0},{"$f":"'Budget M5'!$C43","v":0},{"$f":"'Budget M6'!$C43","v":0},{"$f":"'Budget M7'!$C43","v":0},{"$f":"'Budget M8'!$C43","v":0},{"$f":"'Budget M9'!$C43","v":0},{"$f":"'Budget M10'!$C43","v":0},{"$f":"'Budget M11'!$C43","v":0},{"$f":"'Budget M12'!$C43","v":0}]
[]
[null,"Food"]
[null,"-  Food and Supplies",{"$f":"'Budget M1'!$C46","v":0},{"$f":"'Budget M2'!$C46","v":0},{"$f":"'Budget M3'!$C46","v":0},{"$f":"'Budget M4'!$C46","v":0},{"$f":"'Budget M5'!$C46","v":0},{"$f":"'Budget M6'!$C46","v":0},{"$f":"'Budget M7'!$C46","v":0},{"$f":"'Budget M8'!$C46","v":0},{"$f":"'Budget M9'!$C46","v":0},{"$f":"'Budget M10'!$C46","v":0},{"$f":"'Budget M11'!$C46","v":0},{"$f":"'Budget M12'!$C46","v":0}]
[null,"-  Restaurant Expenses",{"$f":"'Budget M1'!$C47","v":0},{"$f":"'Budget M2'!$C47","v":0},{"$f":"'Budget M3'!$C47","v":0},{"$f":"'Budget M4'!$C47","v":0},{"$f":"'Budget M5'!$C47","v":0},{"$f":"'Budget M6'!$C47","v":0},{"$f":"'Budget M7'!$C47","v":0},{"$f":"'Budget M8'!$C47","v":0},{"$f":"'Budget M9'!$C47","v":0},{"$f":"'Budget M10'!$C47","v":0},{"$f":"'Budget M11'!$C47","v":0},{"$f":"'Budget M12'!$C47","v":0}]
[null,"-  Food (type in other food here)",{"$f":"'Budget M1'!$C48","v":0},{"$f":"'Budget M2'!$C48","v":0},{"$f":"'Budget M3'!$C48","v":0},{"$f":"'Budget M4'!$C48","v":0},{"$f":"'Budget M5'!$C48","v":0},{"$f":"'Budget M6'!$C48","v":0},{"$f":"'Budget M7'!$C48","v":0},{"$f":"'Budget M8'!$C48","v":0},{"$f":"'Budget M9'!$C48","v":0},{"$f":"'Budget M10'!$C48","v":0},{"$f":"'Budget M11'!$C48","v":0},{"$f":"'Budget M12'!$C48","v":0}]
[null,"  Total Food Expenditures ( G )",{"$f":"'Budget M1'!$C49","v":0},{"$f":"'Budget M2'!$C49","v":0},{"$f":"'Budget M3'!$C49","v":0},{"$f":"'Budget M4'!$C49","v":0},{"$f":"'Budget M5'!$C49","v":0},{"$f":"'Budget M6'!$C49","v":0},{"$f":"'Budget M7'!$C49","v":0},{"$f":"'Budget M8'!$C49","v":0},{"$f":"'Budget M9'!$C49","v":0},{"$f":"'Budget M10'!$C49","v":0},{"$f":"'Budget M11'!$C49","v":0},{"$f":"'Budget M12'!$C49","v":0}]
[]
[null,"Clothing and Personal Care"]
[null,"-  Clothing",{"$f":"'Budget M1'!$C52","v":0},{"$f":"'Budget M2'!$C52","v":0},{"$f":"'Budget M3'!$C52","v":0},{"$f":"'Budget M4'!$C52","v":0},{"$f":"'Budget M5'!$C52","v":0},{"$f":"'Budget M6'!$C52","v":0},{"$f":"'Budget M7'!$C52","v":0},{"$f":"'Budget M8'!$C52","v":0},{"$f":"'Budget M9'!$C52","v":0},{"$f":"'Budget M10'!$C52","v":0},{"$f":"'Budget M11'!$C52","v":0},{"$f":"'Budget M12'!$C52","v":0}]
[null,"-  Other (type in other personal here)",{"$f":"'Budget M1'!$C53","v":0},{"$f":"'Budget M2'!$C53","v":0},{"$f":"'Budget M3'!$C53","v":0},{"$f":"'Budget M4'!$C53","v":0},{"$f":"'Budget M5'!$C53","v":0},{"$f":"'Budget M6'!$C53","v":0},{"$f":"'Budget M7'!$C53","v":0},{"$f":"'Budget M8'!$C53","v":0},{"$f":"'Budget M9'!$C53","v":0},{"$f":"'Budget M10'!$C53","v":0},{"$f":"'Budget M11'!$C53","v":0},{"$f":"'Budget M12'!$C53","v":0}]
[null,"  Total Clothing/Personal Care Expenses ( H )",{"$f":"'Budget M1'!$C54","v":0},{"$f":"'Budget M2'!$C54","v":0},{"$f":"'Budget M3'!$C54","v":0},{"$f":"'Budget M4'!$C54","v":0},{"$f":"'Budget M5'!$C54","v":0},{"$f":"'Budget M6'!$C54","v":0},{"$f":"'Budget M7'!$C54","v":0},{"$f":"'Budget M8'!$C54","v":0},{"$f":"'Budget M9'!$C54","v":0},{"$f":"'Budget M10'!$C54","v":0},{"$f":"'Budget M11'!$C54","v":0},{"$f":"'Budget M12'!$C54","v":0}]
[]
[null,"Transportation"]
[null,"-  Automobile",{"$f":"'Budget M1'!$C57","v":0},{"$f":"'Budget M2'!$C57","v":0},{"$f":"'Budget M3'!$C57","v":0},{"$f":"'Budget M4'!$C57","v":0},{"$f":"'Budget M5'!$C57","v":0},{"$f":"'Budget M6'!$C57","v":0},{"$f":"'Budget M7'!$C57","v":0},{"$f":"'Budget M8'!$C57","v":0},{"$f":"'Budget M9'!$C57","v":0},{"$f":"'Budget M10'!$C57","v":0},{"$f":"'Budget M11'!$C57","v":0},{"$f":"'Budget M12'!$C57","v":0}]
[null,"-  Gas, Tolls, Parking",{"$f":"'Budget M1'!$C58","v":0},{"$f":"'Budget M2'!$C58","v":0},{"$f":"'Budget M3'!$C58","v":0},{"$f":"'Budget M4'!$C58","v":0},{"$f":"'Budget M5'!$C58","v":0},{"$f":"'Budget M6'!$C58","v":0},{"$f":"'Budget M7'!$C58","v":0},{"$f":"'Budget M8'!$C58","v":0},{"$f":"'Budget M9'!$C58","v":0},{"$f":"'Budget M10'!$C58","v":0},{"$f":"'Budget M11'!$C58","v":0},{"$f":"'Budget M12'!$C58","v":0}]
[null,"-  Other (type in other transportation here)",{"$f":"'Budget M1'!$C59","v":0},{"$f":"'Budget M2'!$C59","v":0},{"$f":"'Budget M3'!$C59","v":0},{"$f":"'Budget M4'!$C59","v":0},{"$f":"'Budget M5'!$C59","v":0},{"$f":"'Budget M6'!$C59","v":0},{"$f":"'Budget M7'!$C59","v":0},{"$f":"'Budget M8'!$C59","v":0},{"$f":"'Budget M9'!$C59","v":0},{"$f":"'Budget M10'!$C59","v":0},{"$f":"'Budget M11'!$C59","v":0},{"$f":"'Budget M12'!$C59","v":0}]
[null,"  Total Transportation Expenditures ( I )",{"$f":"'Budget M1'!$C60","v":0},{"$f":"'Budget M2'!$C60","v":0},{"$f":"'Budget M3'!$C60","v":0},{"$f":"'Budget M4'!$C60","v":0},{"$f":"'Budget M5'!$C60","v":0},{"$f":"'Budget M6'!$C60","v":0},{"$f":"'Budget M7'!$C60","v":0},{"$f":"'Budget M8'!$C60","v":0},{"$f":"'Budget M9'!$C60","v":0},{"$f":"'Budget M10'!$C60","v":0},{"$f":"'Budget M11'!$C60","v":0},{"$f":"'Budget M12'!$C60","v":0}]
[]
[null,"Recreation"]
[null,"-  Movies, Theater, Sporting Events",{"$f":"'Budget M1'!$C63","v":0},{"$f":"'Budget M2'!$C63","v":0},{"$f":"'Budget M3'!$C63","v":0},{"$f":"'Budget M4'!$C63","v":0},{"$f":"'Budget M5'!$C63","v":0},{"$f":"'Budget M6'!$C63","v":0},{"$f":"'Budget M7'!$C63","v":0},{"$f":"'Budget M8'!$C63","v":0},{"$f":"'Budget M9'!$C63","v":0},{"$f":"'Budget M10'!$C63","v":0},{"$f":"'Budget M11'!$C63","v":0},{"$f":"'Budget M12'!$C63","v":0}]
[null,"-  Other (type in other recreation here)",{"$f":"'Budget M1'!$C64","v":0},{"$f":"'Budget M2'!$C64","v":0},{"$f":"'Budget M3'!$C64","v":0},{"$f":"'Budget M4'!$C64","v":0},{"$f":"'Budget M5'!$C64","v":0},{"$f":"'Budget M6'!$C64","v":0},{"$f":"'Budget M7'!$C64","v":0},{"$f":"'Budget M8'!$C64","v":0},{"$f":"'Budget M9'!$C64","v":0},{"$f":"'Budget M10'!$C64","v":0},{"$f":"'Budget M11'!$C64","v":0},{"$f":"'Budget M12'!$C64","v":0}]
[null,"  Total Recreation Expenditures ( J )",{"$f":"'Budget M1'!$C65","v":0},{"$f":"'Budget M2'!$C65","v":0},{"$f":"'Budget M3'!$C65","v":0},{"$f":"'Budget M4'!$C65","v":0},{"$f":"'Budget M5'!$C65","v":0},{"$f":"'Budget M6'!$C65","v":0},{"$f":"'Budget M7'!$C65","v":0},{"$f":"'Budget M8'!$C65","v":0},{"$f":"'Budget M9'!$C65","v":0},{"$f":"'Budget M10'!$C65","v":0},{"$f":"'Budget M11'!$C65","v":0},{"$f":"'Budget M12'!$C65","v":0}]
[]
[null,"Medical Expenditures"]
[null,"  -  Medical/Dental Expenses (from (E) deductions above)",{"$f":"'Budget M1'!$C68","v":0},{"$f":"'Budget M2'!$C68","v":0},{"$f":"'Budget M3'!$C68","v":0},{"$f":"'Budget M4'!$C68","v":0},{"$f":"'Budget M5'!$C68","v":0},{"$f":"'Budget M6'!$C68","v":0},{"$f":"'Budget M7'!$C68","v":0},{"$f":"'Budget M8'!$C68","v":0},{"$f":"'Budget M9'!$C68","v":0},{"$f":"'Budget M10'!$C68","v":0},{"$f":"'Budget M11'!$C68","v":0},{"$f":"'Budget M12'!$C68","v":0}]
[null,"-  Other Medical (type in other medical here)",{"$f":"'Budget M1'!$C69","v":0},{"$f":"'Budget M2'!$C69","v":0},{"$f":"'Budget M3'!$C69","v":0},{"$f":"'Budget M4'!$C69","v":0},{"$f":"'Budget M5'!$C69","v":0},{"$f":"'Budget M6'!$C69","v":0},{"$f":"'Budget M7'!$C69","v":0},{"$f":"'Budget M8'!$C69","v":0},{"$f":"'Budget M9'!$C69","v":0},{"$f":"'Budget M10'!$C69","v":0},{"$f":"'Budget M11'!$C69","v":0},{"$f":"'Budget M12'!$C69","v":0}]
[null,"  Total Medical Expenditures ( K )",{"$f":"'Budget M1'!$C70","v":0},{"$f":"'Budget M2'!$C70","v":0},{"$f":"'Budget M3'!$C70","v":0},{"$f":"'Budget M4'!$C70","v":0},{"$f":"'Budget M5'!$C70","v":0},{"$f":"'Budget M6'!$C70","v":0},{"$f":"'Budget M7'!$C70","v":0},{"$f":"'Budget M8'!$C70","v":0},{"$f":"'Budget M9'!$C70","v":0},{"$f":"'Budget M10'!$C70","v":0},{"$f":"'Budget M11'!$C70","v":0},{"$f":"'Budget M12'!$C70","v":0}]
[]
[null,"Insurance Expenditures"]
[null,"- Health and Life",{"$f":"'Budget M1'!$C73","v":0},{"$f":"'Budget M2'!$C73","v":0},{"$f":"'Budget M3'!$C73","v":0},{"$f":"'Budget M4'!$C73","v":0},{"$f":"'Budget M5'!$C73","v":0},{"$f":"'Budget M6'!$C73","v":0},{"$f":"'Budget M7'!$C73","v":0},{"$f":"'Budget M8'!$C73","v":0},{"$f":"'Budget M9'!$C73","v":0},{"$f":"'Budget M10'!$C73","v":0},{"$f":"'Budget M11'!$C73","v":0},{"$f":"'Budget M12'!$C73","v":0}]
[null,"- Automobile",{"$f":"'Budget M1'!$C74","v":0},{"$f":"'Budget M2'!$C74","v":0},{"$f":"'Budget M3'!$C74","v":0},{"$f":"'Budget M4'!$C74","v":0},{"$f":"'Budget M5'!$C74","v":0},{"$f":"'Budget M6'!$C74","v":0},{"$f":"'Budget M7'!$C74","v":0},{"$f":"'Budget M8'!$C74","v":0},{"$f":"'Budget M9'!$C74","v":0},{"$f":"'Budget M10'!$C74","v":0},{"$f":"'Budget M11'!$C74","v":0},{"$f":"'Budget M12'!$C74","v":0}]
[null,"- Other (type in other insurance here)",{"$f":"'Budget M1'!$C75","v":0},{"$f":"'Budget M2'!$C75","v":0},{"$f":"'Budget M3'!$C75","v":0},{"$f":"'Budget M4'!$C75","v":0},{"$f":"'Budget M5'!$C75","v":0},{"$f":"'Budget M6'!$C75","v":0},{"$f":"'Budget M7'!$C75","v":0},{"$f":"'Budget M8'!$C75","v":0},{"$f":"'Budget M9'!$C75","v":0},{"$f":"'Budget M10'!$C75","v":0},{"$f":"'Budget M11'!$C75","v":0},{"$f":"'Budget M12'!$C75","v":0}]
[null,"  Total Insurance Expenditures ( L )",{"$f":"'Budget M1'!$C76","v":0},{"$f":"'Budget M2'!$C76","v":0},{"$f":"'Budget M3'!$C76","v":0},{"$f":"'Budget M4'!$C76","v":0},{"$f":"'Budget M5'!$C76","v":0},{"$f":"'Budget M6'!$C76","v":0},{"$f":"'Budget M7'!$C76","v":0},{"$f":"'Budget M8'!$C76","v":0},{"$f":"'Budget M9'!$C76","v":0},{"$f":"'Budget M10'!$C76","v":0},{"$f":"'Budget M11'!$C76","v":0},{"$f":"'Budget M12'!$C76","v":0}]
[]
[null,"Other Expenditures"]
[null,"-  Education",{"$f":"'Budget M1'!$C79","v":0},{"$f":"'Budget M2'!$C79","v":0},{"$f":"'Budget M3'!$C79","v":0},{"$f":"'Budget M4'!$C79","v":0},{"$f":"'Budget M5'!$C79","v":0},{"$f":"'Budget M6'!$C79","v":0},{"$f":"'Budget M7'!$C79","v":0},{"$f":"'Budget M8'!$C79","v":0},{"$f":"'Budget M9'!$C79","v":0},{"$f":"'Budget M10'!$C79","v":0},{"$f":"'Budget M11'!$C79","v":0},{"$f":"'Budget M12'!$C79","v":0}]
[null,"- Child Care",{"$f":"'Budget M1'!$C80","v":0},{"$f":"'Budget M2'!$C80","v":0},{"$f":"'Budget M3'!$C80","v":0},{"$f":"'Budget M4'!$C80","v":0},{"$f":"'Budget M5'!$C80","v":0},{"$f":"'Budget M6'!$C80","v":0},{"$f":"'Budget M7'!$C80","v":0},{"$f":"'Budget M8'!$C80","v":0},{"$f":"'Budget M9'!$C80","v":0},{"$f":"'Budget M10'!$C80","v":0},{"$f":"'Budget M11'!$C80","v":0},{"$f":"'Budget M12'!$C80","v":0}]
[null,"- Other Expenses (type in other expenses here)",{"$f":"'Budget M1'!$C81","v":0},{"$f":"'Budget M2'!$C81","v":0},{"$f":"'Budget M3'!$C81","v":0},{"$f":"'Budget M4'!$C81","v":0},{"$f":"'Budget M5'!$C81","v":0},{"$f":"'Budget M6'!$C81","v":0},{"$f":"'Budget M7'!$C81","v":0},{"$f":"'Budget M8'!$C81","v":0},{"$f":"'Budget M9'!$C81","v":0},{"$f":"'Budget M10'!$C81","v":0},{"$f":"'Budget M11'!$C81","v":0},{"$f":"'Budget M12'!$C81","v":0}]
[null,"  Total Other Expenditures ( M )",{"$f":"'Budget M1'!$C82","v":0},{"$f":"'Budget M2'!$C82","v":0},{"$f":"'Budget M3'!$C82","v":0},{"$f":"'Budget M4'!$C82","v":0},{"$f":"'Budget M5'!$C82","v":0},{"$f":"'Budget M6'!$C82","v":0},{"$f":"'Budget M7'!$C82","v":0},{"$f":"'Budget M8'!$C82","v":0},{"$f":"'Budget M9'!$C82","v":0},{"$f":"'Budget M10'!$C82","v":0},{"$f":"'Budget M11'!$C82","v":0},{"$f":"'Budget M12'!$C82","v":0}]
[]
[null,"Total Living Expenditures (add lines D - M)",{"$f":"'Budget M1'!$C84","v":0},{"$f":"'Budget M2'!$C84","v":0},{"$f":"'Budget M3'!$C84","v":0},{"$f":"'Budget M4'!$C84","v":0},{"$f":"'Budget M5'!$C84","v":0},{"$f":"'Budget M6'!$C84","v":0},{"$f":"'Budget M7'!$C84","v":0},{"$f":"'Budget M8'!$C84","v":0},{"$f":"'Budget M9'!$C84","v":0},{"$f":"'Budget M10'!$C84","v":0},{"$f":"'Budget M11'!$C84","v":0},{"$f":"'Budget M12'!$C84","v":0}]
[]
[null,"Additional Income Available for Savings and Investment",{"$f":"'Budget M1'!$C86","v":0},{"$f":"'Budget M2'!$C86","v":0},{"$f":"'Budget M3'!$C86","v":0},{"$f":"'Budget M4'!$C86","v":0},{"$f":"'Budget M5'!$C86","v":0},{"$f":"'Budget M6'!$C86","v":0},{"$f":"'Budget M7'!$C86","v":0},{"$f":"'Budget M8'!$C86","v":0},{"$f":"'Budget M9'!$C86","v":0},{"$f":"'Budget M10'!$C86","v":0},{"$f":"'Budget M11'!$C86","v":0},{"$f":"'Budget M12'!$C86","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,2,2,2,2,2,2,2,2,2,2,2,2]
[null,null,3,3,3,3,3,3,3,3,3,3,3,3]
[null,null,4,4,4,4,4,4,4,4,4,4,4,4]
[null,null,5,5,5,5,5,5,5,5,5,5,5,5]
[null,null,6,6,6,6,6,6,6,6,6,6,6,6]
[null,null,7,7,7,7,7,7,7,7,7,7,7,7]
[null,null,8,8,8,8,8,8,8,8,8,8,8,8]
[null,null,9,9,9,9,9,9,9,9,9,9,9,9]
[null,null,10,10,10,10,10,10,10,10,10,10,10,10]
[null,null,11,11,11,11,11,11,11,11,11,11,11,11]
[null,null,12,12,12,12,12,12,12,12,12,12,12,12]
[]
[null,null,{"$f":"DAY(TODAY())","v":17},{"$f":"DAY(TODAY())","v":17},17,17,17,17,17,17,17,17,17,17]
[null,null,{"$f":"C106-1","v":16},{"$f":"D106-1","v":16},16,16,16,16,16,16,16,16,16,16]

{"sheet":"IS M1","index":14,"n_rows":86,"n_cols":3,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Income Statement for the Month of \"&'Budget M1'!I3&\" \"&'Budget M1'!I4","v":"Income Statement for the Month of January 2018"}]
[null,"(Note:  This is for Budget Month 1)"]
[null,"Directions:  This file takes the data from Budget Month 1.   Once you have completed the"]
[null,"             budget for Month 1, just print this page off for your Income Statement."]
[]
[null,null,"Actual"]
[null,null,"Income"]
[]
[null,"Income"]
[null,{"$f":"'Budget M1'!B10","v":"Wage Earner 1"},{"$f":"'Budget M1'!D10","v":0}]
[null,{"$f":"'Budget M1'!B11","v":"Wage Earner 2"},{"$f":"'Budget M1'!D11","v":0}]
[null,{"$f":"'Budget M1'!B12","v":"= Total Wages and salaries"},{"$f":"SUM(C10:C11)","v":0}]
[null,{"$f":"'Budget M1'!B13","v":"+ Other (Type in another source here)"},{"$f":"'Budget M1'!D13","v":0}]
[null,{"$f":"'Budget M1'!B14","v":"+ Other (Type in another source here)"},{"$f":"'Budget M1'!D14","v":0}]
[null,{"$f":"'Budget M1'!B15","v":"Total Income ( A )"},{"$f":"SUM(C12:C14)","v":0}]
[]
[null,{"$f":"'Budget M1'!B17","v":"Deductions (Before and After Tax)"}]
[null,"   -  Federal and State Taxes",{"$f":"'Budget M1'!D18","v":0}]
[null,"    -  Social Security Taxes",{"$f":"'Budget M1'!D19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",{"$f":"'Budget M1'!D20","v":0}]
[null,"    -  Medical Plan Deductions (E)",{"$f":"'Budget M1'!D21","v":0}]
[null,{"$f":"'Budget M1'!B22","v":"    -  Other (type in another deduction here)"},{"$f":"'Budget M1'!D22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0}]
[null,"      Take-Home Pay (A - B - C)",{"$f":"C15-C23","v":0}]
[null,{"$f":"'Budget M1'!B25","v":"(Income for Living Expenses)"}]
[null,null,"Actual"]
[null,null,"Spending"]
[null,{"$f":"'Budget M1'!B28","v":"Paying the Lord"}]
[null,{"$f":"'Budget M1'!B29","v":"-  Tithing"},{"$f":"'Budget M1'!D29","v":0}]
[null,{"$f":"'Budget M1'!B30","v":"-  Fast and Other Offerings"},{"$f":"'Budget M1'!D30","v":0}]
[null,{"$f":"'Budget M1'!B31","v":"-  Other Contributions (type in other contributions here)"},{"$f":"'Budget M1'!D31","v":0}]
[null,{"$f":"'Budget M1'!B32","v":"  Total Paying the Lord ( D )"},{"$f":"SUM(C29:C31)","v":0}]
[]
[null,{"$f":"'Budget M1'!B34","v":"Paying Yourself"}]
[null,{"$f":"'Budget M1'!B35","v":"-  Retirement Savings (from (C) deductions above)"},{"$f":"C20","v":0}]
[null,{"$f":"'Budget M1'!B36","v":"- Other Savings (type in other contributions here)"},{"$f":"'Budget M1'!D36","v":0}]
[null,{"$f":"'Budget M1'!B37","v":"  Total Paying Yourself ( E )"},{"$f":"SUM(C35:C36)","v":0}]
[]
[null,{"$f":"'Budget M1'!B39","v":"Living Expenses"}]
[null,"-  Housing/Rent",{"$f":"'Budget M1'!D40","v":0}]
[null,{"$f":"'Budget M1'!B41","v":"- Utilities"},{"$f":"'Budget M1'!D41","v":0}]
[null,{"$f":"'Budget M1'!B42","v":"- Other Living Expenses (type in other living here)"},{"$f":"'Budget M1'!D42","v":0}]
[null,{"$f":"'Budget M1'!B43","v":"  Total Housing Expenditures ( F )"},{"$f":"SUM(C40:C42)","v":0}]
[]
[null,{"$f":"'Budget M1'!B45","v":"Food"}]
[null,{"$f":"'Budget M1'!B46","v":"-  Food and Supplies"},{"$f":"'Budget M1'!D46","v":0}]
[null,{"$f":"'Budget M1'!B47","v":"-  Restaurant Expenses"},{"$f":"'Budget M1'!D47","v":0}]
[null,{"$f":"'Budget M1'!B48","v":"-  Food (type in other food here)"},{"$f":"'Budget M1'!D48","v":0}]
[null,{"$f":"'Budget M1'!B49","v":"  Total Food Expenditures ( G )"},{"$f":"SUM(C45:C48)","v":0}]
[]
[null,{"$f":"'Budget M1'!B51","v":"Clothing and Personal Care"}]
[null,"-  Clothing",{"$f":"'Budget M1'!D52","v":0}]
[null,{"$f":"'Budget M1'!B53","v":"-  Other (type in other personal here)"},{"$f":"'Budget M1'!D53","v":0}]
[null,{"$f":"'Budget M1'!B54","v":"  Total Clothing/Personal Care Expenses ( H )"},{"$f":"SUM(C51:C53)","v":0}]
[]
[null,{"$f":"'Budget M1'!B56","v":"Transportation"}]
[null,"-  Automobile",{"$f":"'Budget M1'!D57","v":0}]
[null,{"$f":"'Budget M1'!B58","v":"-  Gas, Tolls, Parking"},{"$f":"'Budget M1'!D58","v":0}]
[null,{"$f":"'Budget M1'!B59","v":"-  Other (type in other transportation here)"},{"$f":"'Budget M1'!D59","v":0}]
[null,{"$f":"'Budget M1'!B60","v":"  Total Transportation Expenditures ( I )"},{"$f":"SUM(C56:C59)","v":0}]
[]
[null,{"$f":"'Budget M1'!B62","v":"Recreation"}]
[null,{"$f":"'Budget M1'!B63","v":"-  Movies, Theater, Sporting Events"},{"$f":"'Budget M1'!D63","v":0}]
[null,{"$f":"'Budget M1'!B64","v":"-  Other (type in other recreation here)"},{"$f":"'Budget M1'!D64","v":0}]
[null,{"$f":"'Budget M1'!B65","v":"  Total Recreation Expenditures ( J )"},{"$f":"SUM(C62:C64)","v":0}]
[]
[null,{"$f":"'Budget M1'!B67","v":"Medical Expenditures"}]
[null,{"$f":"'Budget M1'!B68","v":"  -  Medical/Dental Expenses (from (E) deductions above)"},{"$f":"C21","v":0}]
[null,{"$f":"'Budget M1'!B69","v":"-  Other Medical (type in other medical here)"},{"$f":"'Budget M1'!D69","v":0}]
[null,{"$f":"'Budget M1'!B70","v":"  Total Medical Expenditures ( K )"},{"$f":"SUM(C67:C69)","v":0}]
[]
[null,{"$f":"'Budget M1'!B72","v":"Insurance Expenditures"}]
[null,"- Health and Life",{"$f":"'Budget M1'!D73","v":0}]
[null,{"$f":"'Budget M1'!B74","v":"- Automobile"},{"$f":"'Budget M1'!D74","v":0}]
[null,{"$f":"'Budget M1'!B75","v":"- Other (type in other insurance here)"},{"$f":"'Budget M1'!D75","v":0}]
[null,{"$f":"'Budget M1'!B76","v":"  Total Insurance Expenditures ( L )"},{"$f":"SUM(C72:C75)","v":0}]
[]
[null,{"$f":"'Budget M1'!B78","v":"Other Expenditures"}]
[null,"-  Education",{"$f":"'Budget M1'!D79","v":0}]
[null,{"$f":"'Budget M1'!B80","v":"- Child Care"},{"$f":"'Budget M1'!D80","v":0}]
[null,{"$f":"'Budget M1'!B81","v":"- Other Expenses (type in other expenses here)"},{"$f":"'Budget M1'!D81","v":0}]
[null,{"$f":"'Budget M1'!B82","v":"  Total Other Expenditures ( M )"},{"$f":"SUM(C79:C81)","v":0}]
[]
[null,{"$f":"'Budget M1'!B84","v":"Total Living Expenditures (add lines D - M)"},{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0}]
[]
[null,{"$f":"'Budget M1'!B86","v":"Additional Income Available for Savings and Investment"},{"$f":"C24-C84","v":0}]

{"sheet":"IS M3","index":15,"n_rows":86,"n_cols":3,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Income Statement for the Month of \"&'Budget M3'!I3&\" \"&'Budget M3'!I4","v":"Income Statement for the Month of March 2018"}]
[null,"(Note:  This is for Budget Month 1)"]
[null,"Directions:  This file takes the data from Budget Month 1.   Once you have completed the"]
[null,"             budget for Month 1, just print this page off for your Income Statement."]
[]
[null,null,"Actual"]
[null,null,"Income"]
[]
[null,"Income"]
[null,{"$f":"'Budget M3'!B10","v":"Wage Earner 1"},{"$f":"'Budget M3'!D10","v":0}]
[null,{"$f":"'Budget M3'!B11","v":"Wage Earner 2"},{"$f":"'Budget M3'!D11","v":0}]
[null,{"$f":"'Budget M3'!B12","v":"= Total Wages and salaries"},{"$f":"SUM(C10:C11)","v":0}]
[null,{"$f":"'Budget M3'!B13","v":"+ Other (Type in another source here)"},{"$f":"'Budget M3'!D13","v":0}]
[null,{"$f":"'Budget M3'!B14","v":"+ Other (Type in another source here)"},{"$f":"'Budget M3'!D14","v":0}]
[null,{"$f":"'Budget M3'!B15","v":"Total Income ( A )"},{"$f":"SUM(C12:C14)","v":0}]
[]
[null,{"$f":"'Budget M3'!B17","v":"Deductions (Before and After Tax)"}]
[null,"   -  Federal and State Taxes",{"$f":"'Budget M3'!D18","v":0}]
[null,"    -  Social Security Taxes",{"$f":"'Budget M3'!D19","v":0}]
[null,"    -  Retirement Planning Deductions (C)",{"$f":"'Budget M3'!D20","v":0}]
[null,"    -  Medical Plan Deductions (E)",{"$f":"'Budget M3'!D21","v":0}]
[null,{"$f":"'Budget M3'!B22","v":"    -  Other (type in another deduction here)"},{"$f":"'Budget M3'!D22","v":0}]
[null,"        Total Deductions ( B )",{"$f":"SUM(C18:C22)","v":0}]
[null,"      Take-Home Pay (A - B - C)",{"$f":"C15-C23","v":0}]
[]
[null,null,"Actual"]
[null,null,"Spending"]
[null,{"$f":"'Budget M3'!B28","v":"Paying the Lord"}]
[null,{"$f":"'Budget M3'!B29","v":"-  Tithing"},{"$f":"'Budget M3'!D29","v":0}]
[null,{"$f":"'Budget M3'!B30","v":"-  Fast and Other Offerings"},{"$f":"'Budget M3'!D30","v":0}]
[null,{"$f":"'Budget M3'!B31","v":"-  Other Contributions (type in other contributions here)"},{"$f":"'Budget M3'!D31","v":0}]
[null,{"$f":"'Budget M3'!B32","v":"  Total Paying the Lord ( D )"},{"$f":"SUM(C29:C31)","v":0}]
[]
[null,{"$f":"'Budget M3'!B34","v":"Paying Yourself"}]
[null,{"$f":"'Budget M3'!B35","v":"-  Retirement Savings (from (C) deductions above)"},{"$f":"C20","v":0}]
[null,{"$f":"'Budget M3'!B36","v":"- Other Savings (type in other contributions here)"},{"$f":"'Budget M3'!D36","v":0}]
[null,{"$f":"'Budget M3'!B37","v":"  Total Paying Yourself ( E )"},{"$f":"SUM(C35:C36)","v":0}]
[]
[null,{"$f":"'Budget M3'!B39","v":"Living Expenses"}]
[null,"-  Housing/Rent",{"$f":"'Budget M3'!D40","v":0}]
[null,{"$f":"'Budget M3'!B41","v":"- Utilities"},{"$f":"'Budget M3'!D41","v":0}]
[null,{"$f":"'Budget M3'!B42","v":"- Other Living Expenses (type in other living here)"},{"$f":"'Budget M3'!D42","v":0}]
[null,{"$f":"'Budget M3'!B43","v":"  Total Housing Expenditures ( F )"},{"$f":"SUM(C40:C42)","v":0}]
[]
[null,{"$f":"'Budget M3'!B45","v":"Food"}]
[null,{"$f":"'Budget M3'!B46","v":"-  Food and Supplies"},{"$f":"'Budget M3'!D46","v":0}]
[null,{"$f":"'Budget M3'!B47","v":"-  Restaurant Expenses"},{"$f":"'Budget M3'!D47","v":0}]
[null,{"$f":"'Budget M3'!B48","v":"-  Food (type in other food here)"},{"$f":"'Budget M3'!D48","v":0}]
[null,{"$f":"'Budget M3'!B49","v":"  Total Food Expenditures ( G )"},{"$f":"SUM(C45:C48)","v":0}]
[]
[null,{"$f":"'Budget M3'!B51","v":"Clothing and Personal Care"}]
[null,"-  Clothing",{"$f":"'Budget M3'!D52","v":0}]
[null,{"$f":"'Budget M3'!B53","v":"-  Other (type in other personal here)"},{"$f":"'Budget M3'!D53","v":0}]
[null,{"$f":"'Budget M3'!B54","v":"  Total Clothing/Personal Care Expenses ( H )"},{"$f":"SUM(C51:C53)","v":0}]
[]
[null,{"$f":"'Budget M3'!B56","v":"Transportation"}]
[null,"-  Automobile",{"$f":"'Budget M3'!D57","v":0}]
[null,{"$f":"'Budget M3'!B58","v":"-  Gas, Tolls, Parking"},{"$f":"'Budget M3'!D58","v":0}]
[null,{"$f":"'Budget M3'!B59","v":"-  Other (type in other transportation here)"},{"$f":"'Budget M3'!D59","v":0}]
[null,{"$f":"'Budget M3'!B60","v":"  Total Transportation Expenditures ( I )"},{"$f":"SUM(C56:C59)","v":0}]
[]
[null,{"$f":"'Budget M3'!B62","v":"Recreation"}]
[null,{"$f":"'Budget M3'!B63","v":"-  Movies, Theater, Sporting Events"},{"$f":"'Budget M3'!D63","v":0}]
[null,{"$f":"'Budget M3'!B64","v":"-  Other (type in other recreation here)"},{"$f":"'Budget M3'!D64","v":0}]
[null,{"$f":"'Budget M3'!B65","v":"  Total Recreation Expenditures ( J )"},{"$f":"SUM(C62:C64)","v":0}]
[]
[null,{"$f":"'Budget M3'!B67","v":"Medical Expenditures"}]
[null,{"$f":"'Budget M3'!B68","v":"  -  Medical/Dental Expenses (from (E) deductions above)"},{"$f":"C21","v":0}]
[null,{"$f":"'Budget M3'!B69","v":"-  Other Medical (type in other medical here)"},{"$f":"'Budget M3'!D69","v":0}]
[null,{"$f":"'Budget M3'!B70","v":"  Total Medical Expenditures ( K )"},{"$f":"SUM(C67:C69)","v":0}]
[]
[null,{"$f":"'Budget M3'!B72","v":"Insurance Expenditures"}]
[null,"- Health and Life",{"$f":"'Budget M3'!D73","v":0}]
[null,{"$f":"'Budget M3'!B74","v":"- Automobile"},{"$f":"'Budget M3'!D74","v":0}]
[null,{"$f":"'Budget M3'!B75","v":"- Other (type in other insurance here)"},{"$f":"'Budget M3'!D75","v":0}]
[null,{"$f":"'Budget M3'!B76","v":"  Total Insurance Expenditures ( L )"},{"$f":"SUM(C72:C75)","v":0}]
[]
[null,{"$f":"'Budget M3'!B78","v":"Other Expenditures"}]
[null,"-  Education",{"$f":"'Budget M3'!D79","v":0}]
[null,{"$f":"'Budget M3'!B80","v":"- Child Care"},{"$f":"'Budget M3'!D80","v":0}]
[null,{"$f":"'Budget M3'!B81","v":"- Other Expenses (type in other expenses here)"},{"$f":"'Budget M3'!D81","v":0}]
[null,{"$f":"'Budget M3'!B82","v":"  Total Other Expenditures ( M )"},{"$f":"SUM(C79:C81)","v":0}]
[]
[null,{"$f":"'Budget M3'!B84","v":"Total Living Expenditures (add lines D - M)"},{"$f":"C82+C76+C70+C65+C60+C54+C49+C43+C37+C32","v":0}]
[]
[null,{"$f":"'Budget M3'!B86","v":"Additional Income Available for Savings and Investment"},{"$f":"C24-C84","v":0}]

{"sheet":"BS 1","index":16,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,1,0,9],[1,1,1,9],[4,1,4,4],[4,6,4,9],[3,1,3,9]]}
[null,"Your Personal Balance Sheet"]
[null,"Bryan Sudweeks"]
[]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the  blue cells."]
[null,"Assets",null,null,null,null,"Liabilities or Debts"]
[]
[null,"Monetary Assets",null,null,null,null,"Current Bills"]
[null,null,"Cash",null,null,null,null,"I.","Total Unpaid Balances"]
[null,null,"Checking"]
[null,null,"Savings/CDs",null,null,null,"Credit Card Debt"]
[null,null,"Money Market Funds",null,null,null,null,"Visa"]
[null,null,"Other Monetary Assets",null,null,null,null,"Master Card"]
[null,null,"A.","Total Monetary Assets",{"$f":"SUM(E8:E12)","v":0},null,null,"Other Credit Cards"]
[null,"Investments",null,null,null,null,null,"J.","Total Credit Card Debt",{"$f":"SUM(J11:J13)","v":0}]
[null,null,"Mutual Funds",null,null,null,"Housing Loans"]
[null,null,"Stocks",null,null,null,null,"First Mortgage"]
[null,null,"Bonds",null,null,null,null,"2nd Home Mortgage"]
[null,null,"Life Insurance (cash-value)",null,null,null,null,"Home Equity Loan"]
[null,null,"Cash Value of Annuities",null,null,null,null,"Other Housing Debt"]
[null,null,"Investment Real Estate (REITs, partnerships)",null,null,null,null,"K.","Total Housing",{"$f":"SUM(J16:J19)","v":0}]
[null,null,"Other investments",null,null,null,"Automobile Loans"]
[null,null,"B.","Total Investments",{"$f":"SUM(E15:E21)","v":0},null,null,"Automobile 1"]
[null,"Retirement Plans",null,null,null,null,null,"Automobile 2"]
[null,null,"401 (k) and 403 (b)",null,null,null,null,"Other Automobile Loans"]
[null,null,"Company Pension",null,null,null,null,"L.","Total Automobile Loans",{"$f":"SUM(J22:J24)","v":0}]
[null,null,"IRA",null,null,null,"Other Debts"]
[null,null,"Other Retirement Plans",null,null,null,null,"College Loans"]
[null,null,"C.","Total Retirement Plans",{"$f":"SUM(E24:E27)","v":0},null,null,"Loans on Life Insurance Policies"]
[null,"Housing",null,null,null,null,null,"Bank Loans"]
[null,null,"Primary Residence",null,null,null,null,"Installment Loans"]
[null,null,"2nd Home",null,null,null,null,"Other"]
[null,null,"Time-Shares/Condominiums",null,null,null,null,"M.","Other Debts",{"$f":"SUM(J27:J31)","v":0}]
[null,null,"Other Housing",null,null,null,"N.","Total Debt/Liabilities",null,{"$f":"J32+J25+J20+J14+J8","v":0}]
[null,null,"D.","Total Housing (at  market value)",{"$f":"SUM(E30:E33)","v":0}]
[null,"Automobiles",null,null,null,null,"Net Worth"]
[null,null,"Automobile 1",null,null,null,"H.","Total Assets",null,{"$f":"E52","v":0}]
[null,null,"Automobile 2",null,null,null,"N.","Less: Total Debt",null,{"$f":"J33","v":0}]
[null,null,"Other Automobiles",null,null,null,"O.","Equals: Net Worth",null,{"$f":"J36-J37","v":0}]
[null,null,"E.","Total Automobiles",{"$f":"SUM(E36:E38)","v":0}]
[null,"Personal Property",null,null,null,null,"Key Ratios: (uses Budget M1)"]
[null,null,"Collectibles",null,null,null,"Current Ratio:",null,null,{"$f":"IF(OR(E13=0,J60=0),\"N/A\",E13/J60)","v":"N/A"},"%"]
[null,null,"Boats",null,null,null,null,"(Monetary Assets/Current Liabilities)"]
[null,null,"Furniture",null,null,null,"Month's Living Expenses"]
[null,null,"Other Personal Property",null,null,null,null,"Covered Ratio",null,{"$f":"IF(OR(E13=0,'Budget M1'!C84=0),\"N/A\",E13/'Budget M1'!C84)","v":"N/A"},"Mon."]
[null,null,"F.","Personal Property",{"$f":"SUM(E41:E44)","v":0},null,null,"(Monetary Assets/Monthly Living Expense)"]
[null,"Other Assets",null,null,null,null,"Debt Ratio",null,null,{"$f":"IF(OR(J33=0,36=0),\"N/A\",J33/J36)","v":"N/A"},"%"]
[null,null,"Money Owed You",null,null,null,null,"(Total liabilities/Total Assets)"]
[null,null,"Market Value of Your Business",null,null,null,"Long-term Debt Coverage Ratio",null,null,{"$f":"IF('Budget M1'!D24=0,\"N/A\",'Budget M1'!D24/J50)","v":"N/A"},"X","Actual income for living expenditures divided by total Long Term debt repayments below"]
[null,null,"Other",null,null,null,null,"(Income for Living Exp/LT Debt Payments)"]
[null,null,"G.","Other Assets",{"$f":"SUM(E47:E49)","v":0},null,null,"Total LT Debt Payments",null,null,null,"Note:  Add your debt payments which will take longer than 12"]
[null,null,null,null,null,null,"Net Saving's Ratio",null,null,{"$f":"(IF(OR('Budget M1'!D86=0,'Budget M1'!D37=0),\"N/A\",('Budget M1'!D86+'Budget M1'!D37)/'Budget M1'!D24))","v":"N/A"},"%",null,"months to pay off."]
[null,"H.","Total Assets",null,{"$f":"E50+E45+E39+E34+E28+E22+E13","v":0},null,null,"(Income for Savings/Income for Living)"]
[null,null,null,null,null,null,"Gross Savings Ratio",null,null,{"$f":"(IF(OR('Budget M1'!D86=0,'Budget M1'!D24=0),\"N/A\",('Budget M1'!D86+'Budget M1'!D37)/'Budget M1'!D15))","v":"N/A"}]
[null,null,null,null,null,null,null,"(Income for Savings/Gross Income)"]
[null,"Note:  While some of these items may be both current (I.e. less than 1 year) and long-term, I am generalizing"]
[null,null,"when I put them together, but I will at least be close"]
[null,"Current Assets",null,null,null,null,"Current Liabilities"]
[null,null,"A.","Total Monetary Assets",{"$f":"E13","v":0},null,null,"I.","Total Unpaid Balances",{"$f":"J8","v":0}]
[null,null,"Total Current Assets",null,{"$f":"E58","v":0},null,null,"J.","Total Credit Card Debt",{"$f":"J14","v":0},"Note:  Credit card debt can be either current or long-term.  Since we"]
[null,null,null,null,null,null,null,"Total Current Liabilities",null,{"$f":"J59+J58","v":0},"  Suggest that you only use a credit card if you are planning to pay"]
[null,"Long-term Assets",null,null,null,null,null,null,null,null,"  it off, I have put it under Current Liabilities."]
[null,null,"B.","Total Investments",{"$f":"E22","v":0},null,"Long-term Liabilities"]
[null,null,"C.","Total Retirement Plans",{"$f":"E28","v":0},null,null,"K.","Total Housing",{"$f":"J20","v":0}]
[null,null,"D.","Total Housing (at  market value)",{"$f":"E34","v":0},null,null,"L.","Total Automobile Loans",{"$f":"J25","v":0}]
[null,null,"E.","Total Automobiles",{"$f":"E39","v":0},null,null,"M.","Other Debts",{"$f":"J32","v":0}]
[null,null,"F.","Personal Property",{"$f":"E45","v":0},null,null,"Total Long-term Liabilities",null,{"$f":"SUM(J63:J65)","v":0}]
[null,null,"G.","Other Assets",{"$f":"E50","v":0}]
[null,null,"Total Long-term Assets",null,{"$f":"SUM(E62:E67)","v":0}]

{"sheet":"BS 2","index":17,"n_rows":68,"n_cols":12,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,1,0,9],[1,1,1,9],[4,1,4,4],[4,6,4,9],[3,1,3,9]]}
[null,"Your Personal Balance Sheet (II)"]
[null,"Bryan Sudweeks"]
[]
[null,"Directions:  Fill in the green cells with your data.  Be careful not to modify the  blue cells."]
[null,"Assets",null,null,null,null,"Liabilities or Debts"]
[]
[null,"Monetary Assets",null,null,null,null,"Current Bills"]
[null,null,"Cash",null,null,null,null,"I.","Total Unpaid Balances"]
[null,null,"Checking"]
[null,null,"Savings/CDs",null,null,null,"Credit Card Debt"]
[null,null,"Money Market Funds",null,null,null,null,"Visa"]
[null,null,"Other Monetary Assets",null,null,null,null,"Master Card"]
[null,null,"A.","Total Monetary Assets",{"$f":"SUM(E8:E12)","v":0},null,null,"Other Credit Cards"]
[null,"Investments",null,null,null,null,null,"J.","Total Credit Card Debt",{"$f":"SUM(J11:J13)","v":0}]
[null,null,"Mutual Funds",null,null,null,"Housing Loans"]
[null,null,"Stocks",null,null,null,null,"First Mortgage"]
[null,null,"Bonds",null,null,null,null,"2nd Home Mortgage"]
[null,null,"Life Insurance (cash-value)",null,null,null,null,"Home Equity Loan"]
[null,null,"Cash Value of Annuities",null,null,null,null,"Other Housing Debt"]
[null,null,"Investment Real Estate (REITs, partnerships)",null,null,null,null,"K.","Total Housing",{"$f":"SUM(J16:J19)","v":0}]
[null,null,"Other investments",null,null,null,"Automobile Loans"]
[null,null,"B.","Total Investments",{"$f":"SUM(E15:E21)","v":0},null,null,"Automobile 1"]
[null,"Retirement Plans",null,null,null,null,null,"Automobile 2"]
[null,null,"401 (k) and 403 (b)",null,null,null,null,"Other Automobile Loans"]
[null,null,"Company Pension",null,null,null,null,"L.","Total Automobile Loans",{"$f":"SUM(J22:J24)","v":0}]
[null,null,"IRA",null,null,null,"Other Debts"]
[null,null,"Other Retirement Plans",null,null,null,null,"College Loans"]
[null,null,"C.","Total Retirement Plans",{"$f":"SUM(E24:E27)","v":0},null,null,"Loans on Life Insurance Policies"]
[null,"Housing",null,null,null,null,null,"Bank Loans"]
[null,null,"Primary Residence",null,null,null,null,"Installment Loans"]
[null,null,"2nd Home",null,null,null,null,"Other"]
[null,null,"Time-Shares/Condominiums",null,null,null,null,"M.","Other Debts",{"$f":"SUM(J27:J31)","v":0}]
[null,null,"Other Housing",null,null,null,"N.","Total Debt/Liabilities",null,{"$f":"J32+J25+J20+J14+J8","v":0}]
[null,null,"D.","Total Housing (at  market value)",{"$f":"SUM(E30:E33)","v":0}]
[null,"Automobiles",null,null,null,null,"Net Worth"]
[null,null,"Automobile 1",null,null,null,"H.","Total Assets",null,{"$f":"E52","v":0}]
[null,null,"Automobile 2",null,null,null,"N.","Less: Total Debt",null,{"$f":"J33","v":0}]
[null,null,"Other Automobiles",null,null,null,"O.","Equals: Net Worth",null,{"$f":"J36-J37","v":0}]
[null,null,"E.","Total Automobiles",{"$f":"SUM(E36:E38)","v":0}]
[null,"Personal Property",null,null,null,null,"Key Ratios: (Uses Budget M3)"]
[null,null,"Collectibles",null,null,null,"Current Ratio:",null,null,{"$f":"IF(OR(E13=0,J60=0),\"N/A\",E13/J60)","v":"N/A"},"%"]
[null,null,"Boats",null,null,null,null,"(Monetary Assets/Current Liabilities)"]
[null,null,"Furniture",null,null,null,"Month's Living Expenses"]
[null,null,"Other Personal Property",null,null,null,null,"Covered Ratio",null,{"$f":"IF(OR(E13=0,'Budget M3'!C84=0),\"N/A\",E13/'Budget M3'!C84)","v":"N/A"},"Mon."]
[null,null,"F.","Personal Property",{"$f":"SUM(E41:E44)","v":0},null,null,"(Monetary Assets/Monthly Living Expense)"]
[null,"Other Assets",null,null,null,null,"Debt Ratio",null,null,{"$f":"IF(OR(J33=0,36=0),\"N/A\",J33/J36)","v":"N/A"},"%"]
[null,null,"Money Owed You",null,null,null,null,"(Total liabilities/Total Assets)"]
[null,null,"Market Value of Your Business",null,null,null,"Long-term Debt Coverage Ratio",null,null,{"$f":"IF('Budget M3'!D24=0,\"N/A\",'Budget M3'!D24/J50)","v":"N/A"},"X","Actual income for living expenditures divided by total Long Term debt repayments below"]
[null,null,"Other",null,null,null,null,"(Income for Living Exp/LT Debt Payments)"]
[null,null,"G.","Other Assets",{"$f":"SUM(E47:E49)","v":0},null,null,"Total LT Debt Payments",null,null,null,"Note:  Add your long-term debt payments in the green box."]
[null,null,null,null,null,null,"Net Saving's Ratio",null,null,{"$f":"(IF(OR('Budget M3'!D86=0,'Budget M3'!D37=0),\"N/A\",('Budget M3'!D86+'Budget M3'!D37)/'Budget M3'!D24))","v":"N/A"},"%","Long-term debt payments are debt with maturities longer than one year."]
[null,"H.","Total Assets",null,{"$f":"E50+E45+E39+E34+E28+E22+E13","v":0},null,null,"(Income for Savings/Income for Living)",null,null,null,"Actual savings divided by actual income for living expenses"]
[null,null,null,null,null,null,"Gross Savings Ratio",null,null,{"$f":"(IF(OR('Budget M3'!D86=0,'Budget M3'!D24=0),\"N/A\",('Budget M3'!D86+'Budget M3'!D37)/'Budget M3'!D15))","v":"N/A"}]
[null,null,null,null,null,null,null,"(Income for Savings/Gross Income)",null,null,null,"Actual savings divided by actual gross income"]
[null,"Note:  While some of these items may be both current (I.e. less than 1 year) and long-term, I am generalizing"]
[null,null,"when I put them together, but I will at least be close"]
[null,"Current Assets",null,null,null,null,"Current Liabilities"]
[null,null,"A.","Total Monetary Assets",{"$f":"E13","v":0},null,null,"I.","Total Unpaid Balances",{"$f":"J8","v":0}]
[null,null,"Total Current Assets",null,{"$f":"E58","v":0},null,null,"J.","Total Credit Card Debt",{"$f":"J14","v":0},"Note:  Credit card debt can be either current or long-term.  Since we"]
[null,null,null,null,null,null,null,"Total Current Liabilities",null,{"$f":"J59+J58","v":0},null,"suggest that you only use a credit card if you are planning to pay"]
[null,"Long-term Assets",null,null,null,null,null,null,null,null,null,"  it off, I have put it under Current Liabilities."]
[null,null,"B.","Total Investments",{"$f":"E22","v":0},null,"Long-term Liabilities"]
[null,null,"C.","Total Retirement Plans",{"$f":"E28","v":0},null,null,"K.","Total Housing",{"$f":"J20","v":0}]
[null,null,"D.","Total Housing (at  market value)",{"$f":"E34","v":0},null,null,"L.","Total Automobile Loans",{"$f":"J25","v":0}]
[null,null,"E.","Total Automobiles",{"$f":"E39","v":0},null,null,"M.","Other Debts",{"$f":"J32","v":0}]
[null,null,"F.","Personal Property",{"$f":"E45","v":0},null,null,"Total Long-term Liabilities",null,{"$f":"SUM(J63:J65)","v":0}]
[null,null,"G.","Other Assets",{"$f":"E50","v":0}]
[null,null,"Total Long-term Assets",null,{"$f":"SUM(E62:E67)","v":0}]