Skip to content

The Info Sheets

Information to improve your life

Archive

Author Archive

(this version is 1-14. For network use see 1-14N below)

Many of my customers have requested additional features of our popular Customer Database for Service Businesses including Point of Sale functions

continue reading…

A concrete calculator in Microsoft Excel can be found in many locations, but many won’t tell you the number of bags for self mixing nor give a total cost. What makes this one of my favorite Excel applications is that it uses no VB its formulas include Herons triangle so all triangles can calculate. It ends with bag needs and then comes up with a total cost. A must for all contractors and any handyman.

continue reading…

Customer Database

Customer Database with Email, Invoicing,

There are many corporate Microsoft Access relational databases but very few for Service Businesses. continue reading…

A very useful macro is to make a new book from a page in your current book.  The scenerio is this you take some information using formulas and look ups and now you need to save it specifying a new name, clear the old sheet, then increment the save name to be unique next save. continue reading…

Combining data from different sheets you need to keep it from overlapping or simply overwriting.  To do this you need to find the end row of the data and then paste just below it.
continue reading…

 Boy on clean carpet

Boy on clean carpet public domain Flickr

The controversy– With the contrary opinions of cleaning processes out there, we find a few that should be unbiased. Since the authority in carpet cleaning is the  IICRC, we would expect them to tell us what is best. But,  since they have members of most cleaning methods, how can they alienate one part of their constituency.  So, we must find another source that can be more objective in recomending a carpet cleaning method.  

continue reading…

Excel Name List Correction

So recently I responded to a forum question on how to search a name field.   The problem is you can’t search a mixed one column name field, but how do you get the messed up entries into individual cells without retyping your data.  I was amazed that so many people used long formulas instead of the built in Text to columns method so I created this toutorial.   The video above best illustrates my method. continue reading…

So I broke down and purchased a new Dm4-1062nr from the Microsoft store for 699.00.  My search took me to best buy and Fry’s and looked over many windows experience scores. I went online to stores like Amazon Newegg, Tiger Direct but ended up at the Microsoft store and got free shipping.  This unit number is only available at the Microsoft store but is the same (or at least very close) to the dm4-1060us at Amazon which is about 100.00 more.  My criteria was a 14 inch good looking fast computer with good battery life.  continue reading…

Photographing a wedding is certainly not easy but with today’s cameras a lot of the work is done for you. continue reading…

The need for an Excel passord generator Is often talked about in security Lockdown.co.uk reports that 8 digits of a 26 character code (typical leter based no caps or all caps) can be busted in 3 1/2 minutes. continue reading…