💾 Archived View for gemini.circumlunar.space › users › laur%C3%AB › finance › annual_budget.sc captured on 2023-03-20 at 19:19:33.

View Raw

More Information

⬅️ Previous capture (2021-12-03)

🚧 View Differences

-=-=-=-=-=-=-

# 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