(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.
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 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.
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…
Staging 101
As a professional home stager, I know getting your home to have the right “look” will get your home sold fast and for more money. To obtain that “look” here are some points to follow. continue reading…