Software for pricing?

« **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

« **Reply #1 on:** June 24, 2005, 10:27:41 pm »

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'

)

How would you want your quotes laid out and what would you want them to include?

Regards

Mike

« **Reply #2 on:** June 24, 2005, 11:04:23 pm »

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

« **Reply #3 on:** June 24, 2005, 11:13:53 pm »

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

« **Reply #4 on:** June 24, 2005, 11:14:14 pm »

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!!

« **Reply #5 on:** June 24, 2005, 11:17:01 pm »

any chance of a copy then john i will pay of course

dave

« **Reply #6 on:** June 24, 2005, 11:18:09 pm »

In your dreams.

« **Reply #7 on:** June 24, 2005, 11:21:25 pm »

ok worth a try

« **Reply #8 on:** June 24, 2005, 11:23:18 pm »

:

« **Reply #9 on:** June 24, 2005, 11:30:02 pm »

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

« **Reply #10 on:** June 25, 2005, 12:00:38 am »

Quote from: Shaun_Ashmore on June 24, 2005, 11:30:02 pm

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

« **Reply #11 on:** June 25, 2005, 11:14:05 am »

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

« **Reply #12 on:** June 25, 2005, 02:35:06 pm »

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

« **Reply #13 on:** June 25, 2005, 03:11:16 pm »

William could u sent me a copy aswell please ?

Arthur

« **Reply #14 on:** June 25, 2005, 03:46:20 pm »

James

On way

« **Reply #15 on:** June 25, 2005, 04:00:50 pm »

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

« **Reply #16 on:** June 25, 2005, 04:04:01 pm »

Could I have a copy to please

« **Reply #17 on:** June 25, 2005, 04:28:54 pm »

Gary
On way

« **Reply #18 on:** June 25, 2005, 04:39:01 pm »

Thanks very much William. I've sent you an email which might be of interest.

Arthur

« **Reply #19 on:** June 25, 2005, 04:44:33 pm »

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.

« **Reply #20 on:** June 25, 2005, 04:50:31 pm »

Thanks William did you get the email? hope it's of some use

« **Reply #21 on:** June 25, 2005, 04:54:55 pm »

No I have received no emails

« **Reply #22 on:** June 25, 2005, 05:11:15 pm »

I sent it to the blueyonder one as a reply to the costings calculator

« **Reply #23 on:** June 25, 2005, 06:25:17 pm »

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

« **Reply #24 on:** June 25, 2005, 06:28:41 pm »

123 james

many thanks for email

« **Reply #25 on:** June 25, 2005, 06:35:10 pm »

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)

« **Reply #26 on:** June 25, 2005, 09:02:15 pm »

can i be a pain and ask for the program too william,be much appreciated

« **Reply #27 on:** June 25, 2005, 09:18:24 pm »

William. Congratulations your excel spreadsheet is proving to be a hit! I have pm'd you

« **Reply #28 on:** June 26, 2005, 08:25:37 am »

Much appreciated, email and time.

« **Reply #29 on:** June 26, 2005, 08:40:13 am »

Hi Chris

I have just been viewing your Website, may I ask " What is the discreet service that you provide??".

« **Reply #30 on:** June 26, 2005, 12:31:38 pm »

would it be possible for me to have a copy?

« **Reply #31 on:** June 26, 2005, 01:38:22 pm »

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

.

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

http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=4390695889&rd=1&sspagename=STRK%3AMESE%3AIT&rd=1

« **Reply #32 on:** June 26, 2005, 02:12:42 pm »

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

« **Reply #33 on:** June 26, 2005, 03:02:43 pm »

if it not too much trouble........................can u send it to me....

tyvm

« **Reply #34 on:** June 26, 2005, 03:27:43 pm »

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

« **Reply #35 on:** June 27, 2005, 09:29:29 am »

can you post a dummy screen ,so i can see what it looks like before i line your pocket with my silver please william

« **Reply #36 on:** June 27, 2005, 09:52:38 am »

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

« **Reply #37 on:** June 28, 2005, 11:51:54 pm »

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

« **Reply #38 on:** June 28, 2005, 11:59:44 pm »

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.

« **Reply #39 on:** June 29, 2005, 09:43:26 am »

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

« **Reply #40 on:** June 29, 2005, 09:59:55 am »

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

« **Reply #41 on:** June 29, 2005, 10:06:36 am »

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.

« **Reply #42 on:** June 29, 2005, 07:38:29 pm »

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

« **Reply #43 on:** July 01, 2005, 10:34:14 am »

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

« **Reply #44 on:** July 17, 2005, 09:21:40 pm »

Or you can still email me for it FREE

Paul

« **Reply #45 on:** July 17, 2005, 10:14:11 pm »

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.