Google-table will count for you, how much to pay for enumerators
A Life / / December 19, 2019
Just type in your table rates and indications of counters - and get the amount you need to pay for utilities.
Alexander Poyarkov
leads blog about marketing in a small business.
Previously, my wife and I were in the account of indications of counters notebook. Everything had to count manually. It takes time, at least a little. Plus there is the human factor - can make a mistake in the calculations.
To avoid this, we have made a table that considers itself the cost of utilities. In it you need to enter the current rates and readings of counters. Everything else she thinks of you. Keep it yourself and use on health.
How to use the table
- To start using the table, go to link and select "File" menu select "Create a copy".
- Register their rates of hot and cold water, drainage, electricity and gas. Tariffs can be prescribed once and stretch all the months. If rates rise in the price, just write the new value and again pull that column.
- Each month, make indications of counters in the columns of "fact." Example: to counter hot water can see the 200 - makes it in the table. By the same principle, and everything else.
- There is no drainage column "Fact", because this figure is considered automatically. Wastewater - is spent liters of hot and cold water in total. The table itself adds and multiplies the data on the tariff.
- Once you have entered the tariffs and readings, a table to calculate how much you need to pay for enumerators in this month. You will see the amount of each service and the total amount as a whole.
Using the table, you can not consider the cost of utility bills and stop manually carry a notebook with performance counters. Surely I'm not the first to make such a table. If you advise in the comments how to improve this template, I will be very happy to read it. :)
see also
- What happens if you do not pay for utilities →
- 20 ways to save on utilities →
- How long should I keep the receipts for payment of utility services →