1---
2app_version: 0.1.0
3precision: 2
4form_title: Check your share of the utility bill
5form_description: Once a year the landlord splits the building's running costs among all flats — by floor area or by head count. Enter your flat's numbers and the advance you paid each month to see your share and whether money comes back.
6form_inputs: Your floor area|my_area{m²}, Total floor area|total_area{m²}, People in your flat|my_people, People in the building|total_people, Advance paid per month|advance{€}
7form_outputs: Your share by floor area|by_area, Your share by head count|by_people, Your total share|my_share, Advance paid this year|paid, Back-payment (+) or refund (−)|balance
8---
9# Check your share of the utility bill
10// Type the bill in line by line. The comments say where each number comes
11// from, so you can still follow it next year — or hand it to a neighbour,
12// who only has to change the first lines. This notebook also has a FORM
13// (Pro): Form → Form view for an input mask.
14
15# Your flat
16my_area = 68 m²
17total_area = 540 m²
18my_people = 2
19total_people = 14
20advance = 150 € // paid per month
21
22# Building costs for the year, split by floor area
23// One line per item, as on the bill. Heating is usually billed separately
24// by actual use — keep it out of here.
25Property tax: 1450 €
26Insurance: 2100 €
27Caretaker: 3200 €
28Cleaning: 1800 €
29Garden: 650 €
30area_costs = total // every line above counts, add one and it's in
31by_area = area_costs * my_area / total_area
32
33# Split by head count
34Water: 3900 €
35Waste: 1600 €
36people_costs = total
37by_people = people_costs * my_people / total_people
38
39# Result
40my_share = by_area + by_people
41paid = advance * 12
42balance = my_share - paid
43"Your total share": my_share
44"Advance paid this year": paid
45"Back-payment (+) or refund (−)": balance
46// Check each cost against the bill's own split key: a cost split by the
47// wrong key (water by area instead of by head count) is a common mistake.
48