# This data file was generated by the Spreadsheet Calculator. # You almost certainly shouldn't edit it. format A 25 2 0 format B 13 2 0 leftstring A0 = "Annual Budget" leftstring A1 = "Last updated:" let B1 = @dts(2021,9,9) label B3 = "January" label C3 = "February" label D3 = "March" label E3 = "April" label F3 = "May" label G3 = "June" label H3 = "July" label I3 = "August" label J3 = "September" label K3 = "October" label L3 = "November" label M3 = "December" leftstring A4 = "Income" label B4 = "---" label C4 = "---" label D4 = "---" label E4 = "---" label F4 = "---" label G4 = "---" label H4 = "---" label I4 = "---" label J4 = "---" label K4 = "---" label L4 = "---" label M4 = "---" leftstring N4 = "Total" label B5 = "---" label C5 = "---" label D5 = "---" label E5 = "---" label F5 = "---" label G5 = "---" label H5 = "---" label I5 = "---" label J5 = "---" label K5 = "---" label L5 = "---" label M5 = "---" label N5 = "---" leftstring A6 = "Salary" let N6 = @sum(B6:M6) leftstring A7 = "Bonus" let N7 = @sum(B7:M7) leftstring A8 = "Reimbursements" let N8 = @sum(B8:M8) leftstring A9 = "Other" let N9 = @sum(B9:M9) leftstring A10 = "Total income" let B10 = @sum(B6:B9) let C10 = @sum(C6:C9) let D10 = @sum(D6:D9) let E10 = @sum(E6:E9) let F10 = @sum(F6:F9) let G10 = @sum(G6:G9) let H10 = @sum(H6:H9) let I10 = @sum(I6:I9) let J10 = @sum(J6:J9) let K10 = @sum(K6:K9) let L10 = @sum(L6:L9) let M10 = @sum(M6:M9) let N10 = @sum(N6:N9) label B11 = "---" label C11 = "---" label D11 = "---" label E11 = "---" label F11 = "---" label G11 = "---" label H11 = "---" label I11 = "---" label J11 = "---" label K11 = "---" label L11 = "---" label M11 = "---" label N11 = "---" leftstring A12 = "Savings & Investing" label B12 = "---" label C12 = "---" label D12 = "---" label E12 = "---" label F12 = "---" label G12 = "---" label H12 = "---" label I12 = "---" label J12 = "---" label K12 = "---" label L12 = "---" label M12 = "---" label N12 = "---" label B13 = "---" label C13 = "---" label D13 = "---" label E13 = "---" label F13 = "---" label G13 = "---" label H13 = "---" label I13 = "---" label J13 = "---" label K13 = "---" label L13 = "---" label M13 = "---" label N13 = "---" leftstring A14 = "Emergency fund" let N14 = @sum(B14:M14) leftstring A15 = "General saving" let N15 = @sum(B15:M15) leftstring A16 = "Investment account 1" let N16 = @sum(B16:M16) leftstring A17 = "Investment account 2" let N17 = @sum(B17:M17) leftstring A18 = "Total saving & investing" let B18 = @sum(B14:B17) let C18 = @sum(C14:C17) let D18 = @sum(D14:D17) let E18 = @sum(E14:E17) let F18 = @sum(F14:F17) let G18 = @sum(G14:G17) let H18 = @sum(H14:H17) let I18 = @sum(I14:I17) let J18 = @sum(J14:J17) let K18 = @sum(K14:K17) let L18 = @sum(L14:L17) let M18 = @sum(M14:M17) let N18 = @sum(N14:N17) label B19 = "---" label C19 = "---" label D19 = "---" label E19 = "---" label F19 = "---" label G19 = "---" label H19 = "---" label I19 = "---" label J19 = "---" label K19 = "---" label L19 = "---" label M19 = "---" label N19 = "---" leftstring A20 = "Expenses" label B20 = "---" label C20 = "---" label D20 = "---" label E20 = "---" label F20 = "---" label G20 = "---" label H20 = "---" label I20 = "---" label J20 = "---" label K20 = "---" label L20 = "---" label M20 = "---" label N20 = "---" leftstring A21 = "--Household--" label B21 = "---" label C21 = "---" label D21 = "---" label E21 = "---" label F21 = "---" label G21 = "---" label H21 = "---" label I21 = "---" label J21 = "---" label K21 = "---" label L21 = "---" label M21 = "---" label N21 = "---" leftstring A22 = "rent" let N22 = @sum(B22:M22) leftstring A23 = "internet" let N23 = @sum(B23:M23) leftstring A24 = "utilities" let N24 = @sum(B24:M24) leftstring A25 = "other" let N25 = @sum(B25:M25) leftstring A26 = "--Food--" label B26 = "---" label C26 = "---" label D26 = "---" label E26 = "---" label F26 = "---" label G26 = "---" label H26 = "---" label I26 = "---" label J26 = "---" label K26 = "---" label L26 = "---" label M26 = "---" label N26 = "---" leftstring A27 = "groceries" let N27 = @sum(B27:M27) leftstring A28 = "restaurants" let N28 = @sum(B28:M28) leftstring A29 = "coffee shops" let N29 = @sum(B29:M29) leftstring A30 = "--Transportation--" label B30 = "---" label C30 = "---" label D30 = "---" label E30 = "---" label F30 = "---" label G30 = "---" label H30 = "---" label I30 = "---" label J30 = "---" label K30 = "---" label L30 = "---" label M30 = "---" label N30 = "---" leftstring A31 = "public transportation" let N31 = @sum(B31:M31) leftstring A32 = "taxi services" let N32 = @sum(B32:M32) leftstring A33 = "gas" let N33 = @sum(B33:M33) leftstring A34 = "car insurance" let N34 = @sum(B34:M34) leftstring A35 = "--Health--" label B35 = "---" label C35 = "---" label D35 = "---" label E35 = "---" label F35 = "---" label G35 = "---" label H35 = "---" label I35 = "---" label J35 = "---" label K35 = "---" label L35 = "---" label M35 = "---" label N35 = "---" leftstring A36 = "Pharmacy" let N36 = @sum(B36:M36) leftstring A37 = "Paramedical practitioners" let N37 = @sum(B37:M37) leftstring A38 = "Vision / Dental" let N38 = @sum(B38:M38) leftstring A39 = "Gym fees" let N39 = @sum(B39:M39) leftstring A40 = "--Personal--" label B40 = "---" label C40 = "---" label D40 = "---" label E40 = "---" label F40 = "---" label G40 = "---" label H40 = "---" label I40 = "---" label J40 = "---" label K40 = "---" label L40 = "---" label M40 = "---" label N40 = "---" leftstring A41 = "Phone bill" let N41 = @sum(B41:M41) leftstring A42 = "Personal care" let N42 = @sum(B42:M42) leftstring A43 = "Gifts / Donations" let N43 = @sum(B43:M43) leftstring A44 = "Clothing" let N44 = @sum(B44:M44) leftstring A45 = "Entertainment" let N45 = @sum(B45:M45) leftstring A46 = "Subscriptions" let N46 = @sum(B46:M46) leftstring A47 = "Total expenses" let B47 = @sum(B22:B46) let C47 = @sum(C22:C46) let D47 = @sum(D22:D46) let E47 = @sum(E22:E46) let F47 = @sum(F22:F46) let G47 = @sum(G22:G46) let H47 = @sum(H22:H46) let I47 = @sum(I22:I46) let J47 = @sum(J22:J46) let K47 = @sum(K22:K46) let L47 = @sum(L22:L46) let M47 = @sum(M22:M46) let N47 = @sum(N22:N46) leftstring A50 = "Total income" let B50 = B10 let C50 = C10 let D50 = D10 let E50 = E10 let F50 = F10 let G50 = G10 let H50 = H10 let I50 = I10 let J50 = J10 let K50 = K10 let L50 = L10 let M50 = M10 let N50 = N10 leftstring A51 = "Total expenses" let B51 = B47 let C51 = C47 let D51 = D47 let E51 = E47 let F51 = F47 let G51 = G47 let H51 = H47 let I51 = I47 let J51 = J47 let K51 = K47 let L51 = L47 let M51 = M47 let N51 = N47 leftstring A52 = "NET (Inc-Exp)" let B52 = B50-B51 let C52 = C50-C51 let D52 = D50-D51 let E52 = E50-E51 let F52 = F50-F51 let G52 = G50-G51 let H52 = H50-H51 let I52 = I50-I51 let J52 = J50-J51 let K52 = K50-K51 let L52 = L50-L51 let M52 = M50-M51 let N52 = N50-N51 leftstring A53 = "Total saving" let B53 = @sum(B14:B15) let C53 = @sum(C14:C15) let D53 = @sum(D14:D15) let E53 = @sum(E14:E15) let F53 = @sum(F14:F15) let G53 = @sum(G14:G15) let H53 = @sum(H14:H15) let I53 = @sum(I14:I15) let J53 = @sum(J14:J15) let K53 = @sum(K14:K15) let L53 = @sum(L14:L15) let M53 = @sum(M14:M15) let N53 = @sum(N14:N15) leftstring A54 = "Total investing" let B54 = @sum(B15:B16) let C54 = @sum(C15:C16) let D54 = @sum(D15:D16) let E54 = @sum(E15:E16) let F54 = @sum(F15:F16) let G54 = @sum(G15:G16) let H54 = @sum(H15:H16) let I54 = @sum(I15:I16) let J54 = @sum(J15:J16) let K54 = @sum(K15:K16) let L54 = @sum(L15:L16) let M54 = @sum(M15:M16) let N54 = @sum(N15:N16) leftstring A55 = "Closing balance" let B55 = B52-(B53+B54) let C55 = C52-(C53+C54) let D55 = D52-(D53+D54) let E55 = E52-(E53+E54) let F55 = F52-(F53+F54) let G55 = G52-(G53+G54) let H55 = H52-(H53+H54) let I55 = I52-(I53+I54) let J55 = J52-(J53+J54) let K55 = K52-(K53+K54) let L55 = L52-(L53+L54) let M55 = M52-(M53+M54) let N55 = N52-(N53+N54) goto A0 A0