Housekeeping book in Calc
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Foreword
The video "Housekeeping Book in Calc - LibreOffice" links to this page here, which contains further information and details.
This video shows how a simple Housekeeping book can be designed in Calc.
Link to the video
Link to the Video (in German [DE]):
Haushaltsbuch in Calc - LibreOffice
Calc create Housekeeping book
Open work file
Open Calc and the existing work file "Housekeeping book - Haushaltsbuch - in Calc".
The Housekeeping book is initially created for one year and contains monthly, half-yearly and yearly expenditure.
Value Highlighting
You can switch on highlighting values.
Choose
▸ from the menu. ( Ctrl+F8 ).The display is then a colored highlighting:
- Numbers = blue
- Formulas = green
- Text = black
Labelling the months
Complete the labels for the months.
To do this, click on the cell "C1"="January" and drag the lower right corner to the right until column "N".
Create total earnings January
Now click in cell "C6", here the sum of the earning for January is to be calculated.
Click on the small arrow down next to the totals symbol in the formula bar and click on the "Sum" symbol and press ↵ Enter.
Create total earnings February to December
Click again in cell "C6" and you will see the calculation at the top of the input line.
We drag right at the bottom right corner of the cell to column "N".
You have now made the calculations, the totals January to December for the revenue [1].
Create total expenditures January
Now click in the cell "C17", here the sum of the expenditures for January should be calculated.
In the formula bar, click on the small down arrow next to the sum icon and click on the "Sum" icon and press ↵ Enter.
Create total expenditures February to December
Again, click in the cell "C17" and you will see the formula at the top of the formula bar.
Drag the bottom right corner of the cell to the right until column "N".
You have now created the calculations of the totals, January to December, for the expenditures [2].
Create totals for half-yearly and yearly
Click on the table tab "Regular costs EN".
Listed here are the expenditures that do not occur on a monthly basis.
Here you calculate the sums for half-yearly [3] and yearly [4].
Click on the table tab "Housekeeping book EN".
In cell "C15" take the sum "half-yearly" [5] from the tab "Regular costs EN" and divide it by six.
In cell "C16" you take the sum " yearly" [6], from the tab "Regular costs EN" and divide it by twelve.
Copy monthly earnings and expenditures from January to the remaining months
Copy earnings item
Select cells ″C3″ through ″C5″.
Press Ctrl + C and paste the copied into rows ″C3″ to ″C5″ of the columns "D" to "N".
Copy expenditure item ″C9″ to ″C14″
Select the cells ″C9″ to ″C14″.
Press Ctrl + C and paste the copy into the lines ″C9″ to ″C14″ of the columns ″D″ to ″N″.
Copy expenditure items ″C15″ and ″C16″
Copy the formula contents of the cell ″C15″ from the formula bar.
Insert ″D15″ to ″N15″ in each cell.
Copy the formula contents of the cell ″C16″ from the formula bar.
Insert ″D16″ to ″N16″ in each cell.
Further informations
Working files
Working file: Housekeeping book - Haushaltsbuch - in Calc
Working file: Housekeeping book - Haushaltsbuch - in Calc final
References
[1] Table: "Housekeeping book EN"; Entry in "C6"="=SUM(C3:C5)"; in the columns February to December corresponding to "D" to "N".
[2] Table: "Housekeeping book EN"; Entry in "C17"="=SUM(C9:C16)"; in the columns February to December corresponding to '"D" to "N".
[3] Table: "Regular costs EN"; Entry in "E5"="=SUM(E3: E4)".
[4] Table: "Regular costs EN"; Entry in "E13"="=SUM E7: E12)".
[5] Table: "Housekeeping book EN"; Entry in "C15"="=regularly.E5/6". The entry is repeated in the columns "D" to "N".
[6] Table: "Housekeeping book EN"; Entry in "C16"="=regularly.E13/12". The entry is repeated in the columns "D" to "N".
Documentation / Manuals
Here you will find the Documentation / Manuals:
Any questions?
For questions on this topic go to:
Get Involved
Join us today and help us to make it even better!
Donate
LibreOffice is Free Software and is made available free of charge.
Your donation, which is purely optional, supports our worldwide community.
If you like the software, please consider a Donation.