{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["College Student Budget","College Expense Estimator"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"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":"College Student Budget","index":0,"n_rows":78,"n_cols":8,"rows_kept":78,"cut":false,"hidden":false,"merged":[[77,1,77,6]]}
[null,"COLLEGE STUDENT BUDGET TEMPLATE"]
[]
[null,"BUDGET OVERVIEW","SEMESTER 1","SEMESTER 2","SEMESTER 3","SEMESTER 4",null,"SEMESTER 4"]
[]
[null,"TOTAL INCOME",{"$f":"C24","v":1800},{"$f":"D24","v":1700},{"$f":"E24","v":0},{"$f":"F24","v":0},null,{"$f":"SUM(C5:F5)","v":3500}]
[null,"TOTAL EXPENSES",{"$f":"C76","v":2378},{"$f":"D76","v":900},{"$f":"E76","v":0},{"$f":"F76","v":0},null,{"$f":"SUM(C6:F6)","v":3278}]
[]
[null,"INCOME LESS EXPENSES",{"$f":"C5-C6","v":-578},{"$f":"D5-D6","v":800},{"$f":"E5-E6","v":0},{"$f":"F5-F6","v":0},null,{"$f":"H5-H6","v":222}]
[]
[null,"INCOME","SEMESTER 1","SEMESTER 2","SEMESTER 3","SEMESTER 4"]
[]
[null,"SALARY/WAGES",350,350,0,0]
[null,"FROM PARENTS/GUARDIANS",100,0,0,0]
[null,"FROM STUDENT LOANS",1000,1000,0,0]
[null,"FROM SCHOLARSHIPS",0,0,0,0]
[null,"FROM GRANTS",0,0,0,0]
[null,"FROM FINANCIAL AID",350,350,0,0]
[null,"TRANSFER FROM SAVINGS",0,0,0,0]
[null,"OTHER",0,0,0,0]
[null,"OTHER",0,0,0,0]
[null,"OTHER",0,0,0,0]
[null,"OTHER",0,0,0,0]
[]
[null,"TOTAL",{"$f":"SUM(C12:C22)","v":1800},{"$f":"SUM(D12:D22)","v":1700},{"$f":"SUM(E12:E22)","v":0},{"$f":"SUM(F12:F22)","v":0}]
[]
[null,"EXPENSES","SEMESTER 1","SEMESTER 2","SEMESTER 3","SEMESTER 4"]
[null,"HOME & SCHOOL"]
[null,"Tuition",750,750,0,0]
[null,"Fees (Class, Parking, Labs, Clubs, Etc.)",25,0,0,0]
[null,"Housing/Rent",40,0,0,0]
[null,"Food Plan",44,0,0,0]
[null,"Dorm/Room Furnishings",20,0,0,0]
[null,"Textbooks",15,0,0,0]
[null,"School Supplies",0,0,0,0]
[null,"Internet",29,0,0,0]
[null,"Cell Phone",0,0,0,0]
[null,"Other",0,0,0,0]
[null,"Other",0,0,0,0]
[null,null,{"$f":"SUM(C28:C38)","v":923},{"$f":"SUM(D28:D38)","v":750},{"$f":"SUM(E28:E38)","v":0},{"$f":"SUM(F28:F38)","v":0}]
[null,"TRANSPORTATION"]
[null,"Car Payments",250,0,0,0]
[null,"Auto Insurance",100,0,0,0]
[null,"Fuel",100,150,0,0]
[null,"Public Transporation",0,0,0,0]
[null,"Repairs/Maintenance",0,0,0,0]
[null,"Registration/License",100,0,0,0]
[null,"Other",0,0,0,0]
[null,"Other",0,0,0,0]
[null,null,{"$f":"SUM(C41:C48)","v":550},{"$f":"SUM(D41:D48)","v":150},{"$f":"SUM(E41:E48)","v":0},{"$f":"SUM(F41:F48)","v":0}]
[null,"DAILY LIVING"]
[null,"Groceries",250,0,0,0]
[null,"Dining Out",100,0,0,0]
[null,"Clothing",0,0,0,0]
[null,"Cleaning",0,0,0,0]
[null,"Salon/Barber",20,0,0,0]
[null,"Other",0,0,0,0]
[null,"Other",0,0,0,0]
[null,null,{"$f":"SUM(C51:C57)","v":370},{"$f":"SUM(D51:D57)","v":0},{"$f":"SUM(E51:E57)","v":0},{"$f":"SUM(F51:F57)","v":0}]
[null,"ENTERTAINMENT"]
[null,"Video/DVD/Movies",250,0,0,0]
[null,"Concerts/Plays",100,0,0,0]
[null,"Sports",100,0,0,0]
[null,"Outdoor Recreation",0,0,0,0]
[null,"Other",0,0,0,0]
[null,"Other",0,0,0,0]
[null,null,{"$f":"SUM(C60:C65)","v":450},{"$f":"SUM(D60:D65)","v":0},{"$f":"SUM(E60:E65)","v":0},{"$f":"SUM(F60:F65)","v":0}]
[null,"HEALTH"]
[null,"Student Health Insurance",65,0,0,0]
[null,"Gym Membership",20,0,0,0]
[null,"Doctors/Dentist Visits",0,0,0,0]
[null,"Medicine/Prescriptions",0,0,0,0]
[null,"Other",0,0,0,0]
[null,"Other",0,0,0,0]
[null,null,{"$f":"SUM(C68:C73)","v":85},{"$f":"SUM(D68:D73)","v":0},0,0]
[]
[null,"TOTAL",{"$f":"SUM(C39,C49,C58,C66,C74)","v":2378},{"$f":"SUM(D39,D49,D58,D66,D74)","v":900},{"$f":"SUM(E39,E49,E58,E66,E74)","v":0},{"$f":"SUM(F39,F49,F58,F66,F74)","v":0}]
[]
[null,"CLICK HERE TO CREATE COLLEGE STUDENT BUDGET TEMPLATES IN SMARTSHEET"]

{"sheet":"College Expense Estimator","index":1,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
[null,"COLLEGE STUDENT BUDGET TEMPLATE"]
[]
[null,"COLLEGE EXPENSE ESTIMATOR","TOTAL NEEDED EACH MONTH",null,{"$f":"SUMIF(D6:D31,\"Yes\",C6:C31)","v":595}]
[]
[null,"DESCRIPTION","AMOUNT","ADD TO TOTAL?","NOTES",null,"ADD TO TOTAL KEY"]
[null,"Laundry",25,"NO","Take to Mom's",null,"NO"]
[null,"Food (main meals)",95,"YES",null,null,"YES"]
[null,"Food (snacks, coffee, etc.)",25,"YES"]
[null,"Heath Insurance",0,"NO","On Mom's plan"]
[null,"Medical expenses",50,"YES","Asthma prescription"]
[null,"Clubs/Organizations",10,"YES","Breakfast Club"]
[null,"Clothes",60,"NO","Get Mom to buy"]
[null,"Entertainment",50,"YES","Includes music downloads"]
[null,"Hygiene (deodorant/shampoo/etc.)",20,"YES"]
[null,"Haircut/manicure/pedicure",10,"YES","Go to beauty school"]
[null,"Parking",15,"YES"]
[null,"Car Payment",175,"YES","See if Dad will pay half"]
[null,"Car Insurance",0,"NO","Mom will cover cost"]
[null,"Gas",50,"YES","Will take bus most of the time"]
[null,"Other transportation",15,"YES","Bus pass"]
[null,"Cell phone",20,"NO","Get Mom to cover cost"]
[null,"Cable",50,"NO","Get Dad to cover cost"]
[null,"Internet service",0,"NO","Included in dorm cost"]
[null,"Utilities (electricity/natural gas)",0,"NO","Included in dorm cost"]
[null,"Gym membership",35,"NO","Can use campus facility instead"]
[null,"Computer supplies (printer ink/paper)",10,"YES"]
[null,"Emergency money",30,"YES"]
[null,"Other",0,"NO"]
[null,"Other",35,"NO"]
[null,"Other",10,"YES"]
[null,"Other",30,"YES"]