s'ok panic and blonde moment over - the only one i couldnt open was the currency and summary s/s it was saying errors with the formula.

But it has all become clear now!!

Michelle

Sorry, another question:

- Does 1 week in the hostel dorm mean 7 nights, or 6?

- Is everyone pricing their 2L a day soda/water as if you purchased a big 2L bottle of soda (as opposed to several smaller bottles per day)? That would be the cheapest way to meet the quantity to buy a big bottle.

quote:

Originally posted by christina-in-brooklyn:
Sorry, another question:

- Does 1 week in the hostel dorm mean 7 nights, or 6?

- Is everyone pricing their 2L a day soda/water as if you purchased a big 2L bottle of soda (as opposed to several smaller bottles per day)? That would be the cheapest way to meet the quantity to buy a big bottle.

I did seven nights. How about the rest of you? I had put 7x on the spreadsheet so hopefully everyone saw that and entered as I expected. If not let me know. If you all think six days is more appropriate then let me know.

Soda/water: I went for big bottles.

I've three more cities in (for a total of five). Once we get this pesky little issue out of the way I'll update accordingly.

7 is fine with me, esp if that was the note on your spreadsheet. let's assume everyone's doing that unless someone else posts here.

quote:

Originally posted by christina-in-brooklyn:
Sorry, another question:

- Does 1 week in the hostel dorm mean 7 nights, or 6?

Yeah, Stoo was right -- it was noted on the spreadsheet as 7 nights.

quote:

- Is everyone pricing their 2L a day soda/water as if you purchased a big 2L bottle of soda (as opposed to several smaller bottles per day)? That would be the cheapest way to meet the quantity to buy a big bottle.

We don't have 2L bottles here but rather 1.5L bottles or 600 ml bottles so I went with the 1.5L pricing instead to be on the safe side.

OK, here is the latest then! WCCIT v2 (five cities)

EDIT from cib post below: oops...fixed.

Hey Stoo, it's still the mock up one on your last post. fyi.

here's the link to version 2

http://www.dietpizza.ch/stuff/bna-wccit-v2.xls

The link was pointing to v1

If you end up with data for lots of cities it would make sense to make a real database rather than excel.

If someone knows how to program SQL it could be pretty user-firendly and people could weight different things differently (beer, theater, etc.) so that people could personalize the cost indexes fairly easily. Add a little BnA design and we're set.

Thanks Nina.

BTW, there's a couple empty (zero) fields on some of the cities. Maybe intended for free events, but I think we should price everything, so it's an equal basket? Can everyone check that they plug in values for each field? Otherwise it will skew it if we don't price equally

Realistically, you can drink the tap water for free in NYC, get free internet at the library, and do free museums, but I ignored that and priced as if I were spending the average cost for things as a tourist.

I hope I'm not sounding all nitpicky, just taking care we are as consistent as possible, so it's a helpful index. It's very cool to see so far! Cheers all.

OK, the Lisbon came in at 308 Euros, I think, but I'm not sure I did everything right. Let me know if it doesn't show up on your version.

Is this going to be an on going project? If so, I can do a few Eastern Europe countries in the fall.

Also, I had a question about the London bit. Under museums/walks/attractions it has $0. I know that most museums in London are free, however, things like Westminster Abbey, the Tower of London, and St. Pauls are not. Isn't this where they would be included?

I plan on sorting out the rest of the values this weekend, but I will have a blank for transport because I am calculating city transit at 7 days of day passes (there are no weekly passes here) because that will include transport to/from the airport.

As for other things that are free - sometimes they are easy to access, like the museums in London, but other times they aren't, like free library internet access. Sometimes a value will be zero and that is the value that reflects the cost.

The one thing I would suggest, though, is that we actually verify our data. Don't estimate from 6 months ago. If you can't be current, don't participate for that city because your results will skew the overall picture.

But, that's just my thoughts....

quote:

Originally posted by Sky Annie:
I plan on sorting out the rest of the values this weekend, but I will have a blank for transport because I am calculating city transit at 7 days of day passes (there are no weekly passes here) because that will include transport to/from the airport.

As for other things that are free - sometimes they are easy to access, like the museums in London, but other times they aren't, like free library internet access. Sometimes a value will be zero and that is the value that reflects the cost.

I think we need to price everything because otherwise it's a whole bunch of very subjective grey area to try to figure in "free" stuff, it's going to skew it. There's a ton of free stuff here in NYC, including major museums & free museum nights. I think most major cities have free stuff available like that.

I didn't count that at all in my pricing, I treated it as the average cost of 3 tourist events like museum tickets/Statue of Liberty trip/Empire State/walking tour. My thinking is that in 7 days, a traveler will see more than 3 tourist activities (in other words, I think it's fair to assume we'll pay for 3 things, and fill up other days doing free stuff).

Question on the water:
should we just nix water as a cost on all the cities? Or should we price it only if local don't drink tap water?

On transport:
A one-week unlimited Metrocard on the transit here will get you to the airport. But I added in the back and forth cost to the airport as a separate item, since it was a separate field. Should we nix the cost of a round-trip to the airport if it's covered by a weekly transit pass?

What does everyone think?

" I think we need to price everything because otherwise it's a whole bunch of very subjective grey area to try to figure in "free" stuff, it's going to skew it. There's a ton of free stuff here in NYC, including major museums & free museum nights. I think most major cities have free stuff available like that."

Definitely! There's tons of free things everywhere, but I think it's ver important to consider only what an average visitor might REALISTICALLY find. Otherwise it's a pretty useless index because people who know a town so well that they find the free stuff don't need an index.

"Question on the water:
should we just nix water as a cost on all the cities? Or should we price it only if local don't drink tap water?"

I think if everyone drinks the tap water, there's no reason to price it.

"On transport:
A one-week unlimited Metrocard on the transit here will get you to the airport. But I added in the back and forth cost to the airport as a separate item, since it was a separate field. Should we nix the cost of a round-trip to the airport if it's covered by a weekly transit pass?"
I priced it for Vienna as a single trip, because I figured the vast majority of visitors won't figure out the whole zoning/pricing system and the machines when their straight off the plane. But if it's realistic that a visitor to your city would KNOW that the Metrocard covers it, then I wouldn't price it seperately.