How can I make this calculator for quotes?

[costargh]

I need to make this little calculator that can automatically work out a quote for me depending on the amount of words a project is.

For example for a 10,000 word project

The first 1000 words (ie. 0-1000) is charged at $38 per 100 words
then the next 1001 - 4000 words is charged at $36 per 100 words
then 4000 - 8000 words is charged at $34 per 100 words
and then 8000-20000 words are chargedat $32 per 100 words

We want to also have aproximately 4 differnt rates of pay (eg. CAT A starts at $38 per 100 and moves down, CAT B starts at $40 per 100 and moves down , CAT C starts at $42 per 100) etc

How can I do this? If it can be as simple as in an excel file then thats fine. I just don't know where to start and I dont know what to google to find out about this because I dont know what its called.

[Mao]

Any introductory books on excel should work. You need to know how to use the if statement, and know how to translate a scenario into a logical process (step by step flow chart)

Or, you can just look at the attached file.

[costargh]

Mao,

Thanks incredibly for all your help. I used your template as a model for the real thing, changed the values a bit now and added some extra functionality (average cost per 100 words for projects, savings based on if costing was done on $40 per 100 -which is new pricing structure, added GST for total cost). Can't post it on here because it's for work but if you want to see how it turned out just PM me and I'll e-mail it to you.

In the future am looking into having different pricings for different languages. However there is the inevitable problem of how to discount when a project is in say 10 languages and all the languages are spread across different pricing structures as discounting could only be applied per language categorisation rather than the project as a whole.

Thanks !

[Mao]

Is this for uni work or a business? You probably want a better solution than an excel spreadsheet if it is for business.

[costargh]

It's for business but it serves its purpose. Especially with the added functionality. My work is a bit behind with technology... still quoting with manual calcs

[Mao]

It's for business but it serves its purpose. Especially with the added functionality. My work is a bit behind with technology... still quoting with manual calcs

I would suggest something web based, but anything goes. GL