I declare my first Excel Model, the Vienna Hair Salon Simulation as licensed under a Creative Commons Attribution 3.0 Unported License.
Here the Problem and its Solution rawly traduced via Google Translate:
How many salons there are in Vienna?I put the following considerations:
- There are approximately 1.8 million "Wiener"
- Almost all have hair and almost all cut not privately
- Viennese cut them every one to two months
- The hairdressers work about 220 days a year, but some part-time
- Pro Salon work 1-4 Hairdressers
- A hairdresser needs 20min to 1h for a haircut
I queried the Yellow Pages after and as of may 9th , 2010 there are 1136 registered salons in Vienna.
The dirty truth is that the model tends to favor slightly the 0-200 salons bin. Of course the Garbage-In/ Grabage-Out Principle says you can't look at the details if your model is that rough. So the result is fairly good.