Clean It Up
UK Floor Cleaning Forum => Carpet Cleaning Forum => Topic started by: dave washbrook on June 24, 2005, 09:42:57 pm
-
hi all
i was thinking of doing my quotes on my lap top but i need a programe that allows me to enter size of room and then works out a price something simular to the fast track programe. does anyone use one or can you reccomende one
thanks
dave
-
I've never seen a specific software programme for carpet cleaning quotes but I would guess that it's pretty easy to set up a template in Exel to do them for you.
The problem with off the shelf software is that it often doesnt have the ability to add specific costs (like an extra charge for 'Allergy Treatment' :-X )
How would you want your quotes laid out and what would you want them to include?
Regards
Mike
-
mike
i dont realy know but i do know the fast track guys use one so i was after something along those lines but any ideas would be appreacet,
i would want different price structers for cleaning,protecting and maybe allergy treatment
thanks
dave
-
I won't promise anything but I have someone who may be able to make up a simple quote system. I'm going on holiday for 2 weeks so I'll 'sticky' this topic in the hope that other members may be able to contribute some ideas for it. Maybe it's something we could offer as a download (for a modest charge, of course ;) )
Anyone that contributes any ideas to it here can have it free of charge.
How does that sound?
Regards
Mike
-
The one the 'Fast trak guys' use was written at great expence and the only way I can see that you are going to get it is to join!!
It is great and you can create different levels of prices in it.
Show the client the price on the Laptop screen and they believe it and pay it, no hesitation!!
-
any chance of a copy then john i will pay of course
dave
-
In your dreams.
-
ok worth a try
-
:o :o :o ::) ::) :o :o :o
-
Mike Bloxxom, please keep the forum in order I know you may make a shilling potentially selling computer programs but it is blooming annoying when you keep threads at the top when they should take order like evrything else!
Said with sincerety
Shaun
-
Mike Bloxxom, please keep the forum in order I know you may make a shilling potentially selling computer programs but it is blooming annoying when you keep threads at the top when they should take order like evrything else!
Said with sincerety
Shaun
Shaun
Dave asked about something that may be of interest to lots of others. If everyone chips in and everyone benefits from it, what's the problem? It's not about us making money, it's about us covering our costs (and besides, I can think of easier ways of making money). Then it's a win-win situation. The more people that contribute the better it could be.
Regards
Mike
-
In a past life the company I worked for got an employee, who was fairly well clued up with MS Access, to create a database for production.
It was basically a database with a pretty bolt-on front end with dropdowns for selections etc., one department added the items they had built, serial nos etc, another department added theirs and so on, then final assembly allocated and issued the parts via the dropdown menus.
This can be easily adapted for cc's if someone is familiar enough to create it in the first place. Main benifit....... can i take your details madam.... which level of service would you like.......... that'll be...... ta very much......
Easy peasy... if you know access well enough, and I don't.
I think this would be better than excel, as the customer will see something other than a spreadsheet, something along the lines of the fast track boys.
Just a thought.
Chris
-
This is something that I have just done on Excel its a basic program that converts the sq yardage of carpet into a total clean price for the house, with the breakdown of everything that you need to do to the carpet.
The prices can be changed whenever you want to.
you just go to the cell which needs changing press f2 and change the figure to what you want.
Hope this helps
Carpet Cleaning Quotation
Room Sizes Cleaning Per Sq Yard Pre-Spray Stain - Removal Allergy - Stop Other Total Price
Lounge 24 £24.00 £1.44 £12.00 £5.76 £2.40 £45.60
Dining Room 10 £10.00 £0.60 £5.00 £2.40 £1.00 £19.00
Kitchen 8 £8.00 £0.48 £4.00 £1.92 £0.80 £15.20
Hall 6 £6.00 £0.36 £3.00 £1.44 £0.60 £11.40
Stairs 6.5 £6.50 £0.39 £3.25 £1.56 £0.65 £12.35
Landing 4 £4.00 £0.24 £2.00 £0.96 £0.40 £7.60
Toilet 3 £3.00 £0.18 £1.50 £0.72 £0.30 £5.70
Bathroom 3 £3.00 £0.18 £1.50 £0.72 £0.30 £5.70
Bedroom 1 24 £24.00 £1.44 £12.00 £5.76 £2.40 £45.60
Bedroom 2 16 £16.00 £0.96 £8.00 £3.84 £1.60 £30.40
Bedroom 3 16 £16.00 £0.96 £8.00 £3.84 £1.60 £30.40
Bedroom 4 15 £15.00 £0.90 £7.50 £3.60 £1.50 £28.50
Bedroom 5 12 £12.00 £0.72 £6.00 £2.88 £1.20 £22.80
Other Rooms 0 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00
Total Price £280.25
VAT £49.04
Grand Total £329.29
I have sent you a copy of the program Dave
-
William could u sent me a copy aswell please ?
Arthur
-
James
On way
-
Thanks William i got it but can you tell me how to get it onto an excel spread sheet? Sorry to be a pain but i'm hopeless with excel
Arthur
-
Could I have a copy to please
-
Gary
On way
-
Thanks very much William. I've sent you an email which might be of interest.
Arthur
-
Arthur
When you open the message save the attachment to you computer and them open. You will need an excel sofeware program installed on your computer.
You will need to imput your prices yourself as the figures I have use are only make up ones, all you do is go to the cell which you want to change and press f2.
you will see the figure I have put in all you do is change it to what you want.
If you then drag the cursor down though the column it will change al the other rooms price as well.
-
Thanks William did you get the email? hope it's of some use
-
No I have received no emails
-
I sent it to the blueyonder one as a reply to the costings calculator
-
william
thanks very much it looks great i'll play around with it later i have excel on my computor so no problem there, nice to know theres still some helpful cc out there
thanks
dave
-
123 james
many thanks for email
-
Dave
Its only a basic program which took 10 minutes to set up, but it can be added to with Access or Word to enhance it further.
I believe we should all help each out (what goes around comes around)
-
can i be a pain and ask for the program too william,be much appreciated :)
-
William. Congratulations your excel spreadsheet is proving to be a hit! I have pm'd you
-
Much appreciated, email and time. 8)
-
Hi Chris
I have just been viewing your Website, may I ask " What is the discreet service that you provide??".
-
would it be possible for me to have a copy?
-
Sorry folks but I've had so much interest in this software that its taking up so much time that I thought I earn a penny or two ;D.
So I have enhanced it further than the ones I've sent out for free and have put it on ebay for a modest fee of £5.99 ;D
http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=4390695889&rd=1&sspagename=STRK%3AMESE%3AIT&rd=1
-
Hi William pleasure mate if there's anything else your looking for and i can help you've got my email like you said what goes round comes round
Thanks again Arthur
-
if it not too much trouble........................can u send it to me....
tyvm
-
Spindle2k
Sorry but its only available on ebay now but is has been upgraded on what on I did send out.
http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=4390695889&rd=1&sspagename=STRK%3AMESE%3AIT&rd=1
-
can you post a dummy screen ,so i can see what it looks like before i line your pocket with my silver please william
-
Matt
Hopes this gives you a feel for the program
Remenber it is done on excel so all the cells show and this site does not show the programat its best.
Samvic Cleaning Services
0121 458 1296 - 0778 971 1371
Customer Name
House Number
Street
Area
City/Town
Postcode
Telephone Number
Date
Cleaning Date and Time
Total Price £728.68
Carpet Cleaning Quotation
Room Sizes Cleaning Per Sq Yard Pre-Spray Stain - Removal Allergy - Stop Stain-Protector Rugs Total Price
Lounge 35 £35.00 £2.10 £17.50 £8.40 £3.50 £25.00 £91.50
Dining Room 10 £10.00 £0.60 £5.00 £2.40 £1.00 £0.00 £19.00
Kitchen 8 £8.00 £0.48 £4.00 £1.92 £0.80 £0.00 £15.20
Hall 6 £6.00 £0.36 £3.00 £1.44 £0.60 £0.00 £11.40
Stairs 6.5 £6.50 £0.39 £3.25 £1.56 £0.65 £0.00 £12.35
Landing 4 £4.00 £0.24 £2.00 £0.96 £0.40 £0.00 £7.60
Toilet 3 £3.00 £0.18 £1.50 £0.72 £0.30 £0.00 £5.70
Bathroom 3 £3.00 £0.18 £1.50 £0.72 £0.30 £0.00 £5.70
Bedroom 1 24 £24.00 £1.44 £12.00 £5.76 £2.40 £15.00 £60.60
Bedroom 2 16 £16.00 £0.96 £8.00 £3.84 £1.60 £15.00 £45.40
Bedroom 3 16 £16.00 £0.96 £8.00 £3.84 £1.60 £0.00 £30.40
Bedroom 4 15 £15.00 £0.90 £7.50 £3.60 £1.50 £0.00 £28.50
Bedroom 5 12 £12.00 £0.72 £6.00 £2.88 £1.20 £0.00 £22.80
Other Rooms 0 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00
Total Price £356.15
VAT @17.5% £62.33
Grand Total £418.48
Upholstery Cleaning Quotation
Armchair 2 £20.00 £20.00 £80.00
2 Seater Settee £40.00 £0.00
3 Seater Settee 1 £60.00 £60.00
4 Seater Settee £80.00 £0.00
5 Seater Settee £100.00 £0.00
6 Seater Settee £120.00 £0.00
Foot - Stool £5.00 £2.00 £0.00
Cushions £3.00 £0.00
£0.00
Mattress £0.00
£0.00
Single 2 £15.00 £30.00
Double 1 £20.00 £20.00
Queen £25.00 £0.00
King 1 £30.00 £30.00
Super - King £35.00 £0.00
£0.00
Headboards £0.00
£0.00
Single 2 £5.00 £2.00 £14.00
Double 1 £10.00 £10.00
Queen £15.00 £0.00
King 1 £20.00 £20.00
Super - King £25.00 £0.00
Total Price £264.00
VAT @17.5% £46.20
Grand Total £310.20
-
I think the qoute has to be presented in a logical manor Giving the benifits of the service for the price charged.
Mike while you continue to Rival Joe Polish.
A Cheap selling protection DVD
A Powerpoint Carpet Audit Presentation.
Perhaps you could get the UK Agency for a JP rival. Howard Partridge
-
Matt
It does not look like this when you see the product on a spredsheet layout, by cutting and pasting it has shrunk all the figures together.
-
William,
Send me a copy of the spreadsheet and I'll have a lpay with it and format into an Access Database.
In a former life I have done quite alot of this.
Excel is OK, but you have to lock cells and hide them to make it more user friendly. In essence Access is very similar, but you can put on a front and back end. Basically the customer will see the front end and where you are putting the details in, when you want to present the quote, the printed report - either on screen or piece of paper - just shows the information they need.
Things like levels of service can be pointed out on the 'report' and you can explain them or offer another listing separate to the quote as additional information.
Makes things ALOT tidier and more presentable to a customer - obviously giving a good impression of a professional outfit.
I went on the discovery day too, and apart from the marketing stuff AND training, most of what they give you can do for yourself.
I am NOT knocking Alltec, far from it - they gave me some excellent ideas which I have put into practise. The quote system is something I intended to do, but been a bit busy recently. So William, send me what you've got and I'll sort out the Access side.
You can sell it on Ebay if you want, all I ask is for a 99% cut ;)
Paul
-
John,
Discreet as in some buildings are 'sensitive politically' and some famous clients who live in places they don't want known.
Or have overnight visitors they don't want known :-X
-
Many thanks for the offer paul and you only wany a 99% cut what a bargain ::)
I only developed this program because some cc out there wanted something where they can go into a customers house take the meausments and hay presto out pops a professional looking quotation, which this program does.
At first I was giving them away for free but I got so many requests for copies that I would end up spending all my time on the computer, that why I decided to sell copies on ebay for a small fee. ( I have seen others programs like this one been sold for £25 or more)
From the copies that I have sold or given away I have had a lot of Emails concratulating me, they have said how great the program is and I should give up carpet cleaning and go on to computer programming.
Anyway the program will stay on ebay for a short while longer and when the interest in it wanes then it will be taken off ebay and deleted.
-
Chris
Surely we all in this business are expected to and do offer that type of service, in my eyes it just read that you were offering that little bit of something extra ;) ;) ;)
-
The software program is now show on ebay in all of its glory
http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=4390695889&rd=1&sspagename=STRK%3AMESE%3AIT&rd=1
-
Or you can still email me for it FREE
Paul
-
Paul
You can have it all now.
My program has been deleted.
Why don't you advetise it on ebay like I did.
You will be able to give them away free of charge of course.