# 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

1.
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.

Example 1

You have a fixed salary of \$$\text{}3900\text{}$ per month. Your normal workweek is 40 hours, and you receive an additional $\text{}40\text{}\phantom{\rule{0.17em}{0ex}}\text{%}$ to your hourly rate when working overtime during weekdays, and $\text{}100\text{}\phantom{\rule{0.17em}{0ex}}\text{%}$ when working overtime on Sundays. One month you work 15 hours overtime during the week and 6 hours overtime on Sundays. $\text{}35\text{}\phantom{\rule{0.17em}{0ex}}\text{%}$ 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.