Colorful House of Math logo
Log in

GeoGebra Template for Calculating Your Monthly Paycheck

You can use Spreadsheet in GeoGebra to calculate your income. In Item 2, there’s a template you can follow. At the end of the entry, there’s an example so you can see how you can use the template in practice.

Usually, it’s better to use Excel , since it has more built-in tools like charts and formatting options than there are in GeoGebra.

GeoGebra Instruction 1

Calculating Income in Spreadsheet

1.
Open Spreadsheet under GeoGebra icon View in GeoGebra icon Menu.
2.
Copy the template in the image below. The cells without formulas in them need to be filled with information you get from your exercise. Note that GeoGebra doesn’t display the equal sign before each formula, nor the multiplication symbol (*) between the cell names, but you must type them nonetheless.

Screenshot of GeoGebra showing a spreadsheet template for income calculations

Example 1

You have a fixed salary of $3900 per month. Your normal workweek is 40 hours, and you receive an additional 40% to your hourly rate when working overtime during weekdays, and 100% when working overtime on Sundays. One month you work 15 hours overtime during the week and 6 hours overtime on Sundays. 35% of your salary goes to taxes. What is your net income?

Follow Item 2 and insert the numbers from the exercise. Your spreadsheet should look like the one in the image below.

Screenshot of GeoGebra showing a spreadsheet with income data

Want to know more?Sign UpIt's free!
Next entryWhite arrow pointing to the right
Spreadsheets for Budget and Accounting in GeoGebra