|
These spreadsheets will be e-mailed to you by auto-responder
on request, free of charge. To use them you need Microsoft
Excel 2000 or later. Some require you to enable macros in
order to run (full instructions included, but no batteries).
They are all CareWare. CareWare is free, but
you agree in return to do something to improve the planet: You
decide what and how much. Some suggestions: Give
away something you've made; help someone else; watch an hour less
television; plant a tree; walk instead of driving; be friendly to young people, strangers, the blind and the
elderly; join
EarthLife Africa. If you'd like to tell us what you did, or contribute
a CareWare spreadsheet, please
e-mail us.
Read more about CareWare here.
Contents:
Bank Account Reconciliation
Fuel Consumption Spreadsheet
Rainfall Spreadsheet with Statistics
Water Meter Readings Spreadsheet
Electricity Meter Readings Spreadsheet
Mattress Turning Schedule
Quotation System with Bill of Materials
A Bonus for You!
The problem: Keep track of our internet banking accounts on a
spreadsheet, make sure that all expected entries appear, and plan future income
and expenses. The difficulty is that each bank has its own format with the
result that, in most cases, if you copy from the internet and paste into Excel,
it does not recognise the numbers as numbers. Several banks insist on
doing two lines per entry, which makes sorting difficult. FNB's eBucks
site displays the newest entries at the top (descending order), while the others
display newest at the bottom (ascending).
The solution: We've set up an Excel spreadsheet into which you can
paste from the on-line statements of the big four South African banks: NedBank,
ABSA, First National Bank (FNB) and Standard Bank (popularly known as NerdBank,
GRABSA, Financial Novice Bloopers, and Sub-Standard).
You then click a button on the sheet and it runs a macro that reformats the
selected data into single-line entries for ease of sorting, in ascending order,
with columns to check your running total against the bank's, and a column giving
the available balance with respect to a target balance or overdraft limit.
The available balance appears in different colours as you approach your limit,
and red when you exceed it.
To get the Bank Reconciliation spreadsheet (490 KB zipped to 100KB),
Click here and Send
Our Fuel Consumption spreadsheet comes with sample data and
an explanation of the formulas. You enter your kilometre readings, litres to
fill up, and amount paid. It will work out the fuel consumption and cost
per litre. Fill in your km when the car is serviced, and the "km since
service" figure will go red when you exceed the service interval. There is
also a "Trips" sheet for for recording specific trips (for distances) and Toll
fees (for expense claims).
If you'd like the Fuel Consumption Spreadsheet (75 KB),
Click here and SEND the resulting e-mail.
Is it getting wetter or drier? Is global climate change making rainfall
more erratic? How about tracking your rain and comparing between years?
Hop down to your nearest hardware shop and buy your loved one a rain
gauge as his/her present for Birthday / Christmas / Chanukah / Summer
Solstice / New Year! –You think we're joking? Friends of ours say it's the
most useful present anyone has given them!
Then
click here and SEND the resulting e-mail to request the free rainfall spreadsheet. This
Excel file not only makes data entry easy, but calculates your monthly and
annual statistics (days of rain and mm rainfall for the period). It
also has a full explanation of the formulas used, in case you want to learn
more (no macros).
Our Water Meter Readings spreadsheet lets you enter your monthly water
readings. It has sample data, the web address and instructions on
submitting water readings to Johannesburg Water on-line, with 2006/7 charges for
checking your bill: To get the Water Meter Readings Spreadsheet (70 KB),
Click here and SEND the resulting e-mail.
This works like the Water Meter Readings spreadsheet and lets you enter your
monthly power readings (3 phases). It contains Eskom's latest Johannesburg
Domestic Tariff charges for checking your bill –for City Power and other
suppliers you can enter the charges from your power account. To get it (61
KB)
Click here and SEND the resulting e-mail.
When you buy certain mattresses, the manufacturer requires you to turn them on a
regular basis, typically fortnightly during the first three months and then
monthly thereafter. There are four ways the mattress can be placed, and a
specific order for turning. Who bothers? But if you don't, and your
mattress sags or goes lumpy, your guarantee may not be valid!
So, while it may seem silly, we set up a spreadsheet to solve this problem.
You enter the dates of purchase and delivery, and a suitable number of days to
get to (for example) the domestic worker's preferred day. The program then
works out the schedule for you. You can print it out and stick it on the
back of a door or other suitable place. Cross off each date when the
mattress has been turned to the position shown on the picture. To
get this Excel file (104 KB),
Click here and SEND the resulting e-mail.
This is a spreadsheet for producing general small
business quotations. You can enter your own price lists. Output can be
personalized with your company name and details. File size:
818 KB (zipped). Cost: Free.
To download, go to Quotation
System page.
So that you can stay in touch, when you request any of the above we will
subscribe you to our monthly e-newsletter containing helpful tips for Windows,
Excel, Outlook, Maximizer, etc. If you don't want any of the spreadsheets,
but would like to subscribe to the newsletter,
Click here and SEND the resulting e-mail.
Please feel free to share this web address, the e-mails,
and the spreadsheets with your friends.
Add this page to your favourites and return sometimes to see if we have new
updates.
Would you like a spreadsheet, macro, template,
database or stand-alone PC program to make your life easier and your
business more profitable? Or training or help to create your own?
Contact us!
|
