Welcome to the Second Life Forums Archive
These forums are CLOSED. Please visit the new forums HERE
MegaTower Financials Posted |
|
|
Hank Ramos
Lifetime Scripter
Join date: 15 Nov 2003
Posts: 2,328
|
11-28-2004 17:07
In the interest of helping others learn how the MegaTowers are being run, I'm posting again the prim and financial worksheet for the MegaTowers.
_____________________
|
|
Aaron Levy
Medicated Lately?
Join date: 3 Jun 2004
Posts: 2,147
|
11-28-2004 17:14
Thanks for posting this data, Hank. I love spreadsheets.
Although I get a lot of #VALUE errors on all of the worksheets, like on MegaTower 1, in cells F-K31,35,36,40,41. All of the errors are the same "A value used in this formula is the wrong data type." I poked at it and can't find which variable from the formula is the wrong data type. I'm using Excel 2003 SP1. Also a lot of the header boxes are black text on black background, too. Are you making this in Excel or something like OpenOffice? _____________________
|
|
Hank Ramos
Lifetime Scripter
Join date: 15 Nov 2003
Posts: 2,328
|
11-28-2004 17:15
mmm, I'm using Open Office to generate the MS Excel Compatible version of the spreadsheet. Do you have Open Office to open it with?
Updated original attachment above. _____________________
|
|
Aaron Levy
Medicated Lately?
Join date: 3 Jun 2004
Posts: 2,147
|
11-28-2004 19:17
That second version didn't work either. I downloaded and installed OpenOffice and it's working fine in it.
Looks like OpenOffice doesn't create the 100% compatible files it says it does.  Cool either way. _____________________
|
|
Tito Gomez
Mi Vida Loca
Join date: 1 Aug 2004
Posts: 921
|
11-28-2004 20:44
Thanks, Hank. Useful info for us non-business types trying to understand how the wheels turn. I actuall have always wished I could get my hands on the books of a McDonalds, Radio Shack, or something like that, just to see how they make their $$$ one hamburger or battery at a time
 BTW. Had tons of #VALUE errors too, using Excel XP (2002). I'll check it out using Open Office (Solaris) at work tomorrow. - T - _____________________
|
|
blaze Spinnaker
1/2 Serious
Join date: 12 Aug 2004
Posts: 5,898
|
11-28-2004 23:23
Very very impressive. Hats off.
_____________________
Taken from The last paragraph on pg. 16 of Cory Ondrejka's paper "Changing Realities: User Creation, Communication, and Innovation in Digital Worlds :
"User-created content takes the idea of leveraging player opinions a step further by allowing them to effectively prototype new ideas and features. Developers can then measure which new concepts most improve the products and incorporate them into the game in future patches." |
|
Carnildo Greenacre
Flight Engineer
Join date: 15 Nov 2003
Posts: 1,044
|
11-28-2004 23:28
KOffice doesn't like the first version, giving the same errors that Excel does. It *really* doesn't like the second version.
_____________________
perl -le '$_ = 1; (1 x $_) !~ /^(11+)\1+$/ && print while $_++;'
|
|
blaze Spinnaker
1/2 Serious
Join date: 12 Aug 2004
Posts: 5,898
|
11-28-2004 23:47
This should be a fixed version for Excel 2000, though you might want to wait for Hank to verify.
_____________________
Taken from The last paragraph on pg. 16 of Cory Ondrejka's paper "Changing Realities: User Creation, Communication, and Innovation in Digital Worlds :
"User-created content takes the idea of leveraging player opinions a step further by allowing them to effectively prototype new ideas and features. Developers can then measure which new concepts most improve the products and incorporate them into the game in future patches." |
|
Hank Ramos
Lifetime Scripter
Join date: 15 Nov 2003
Posts: 2,328
|
11-29-2004 05:06
Thank blaze, looks good. Guess I need to install Excel 97 just to get the conversion correct
I had thought that Open Office did a good job with simple conversions like this. The sheets I created use very simple formulas and arithmetic.I downloaded the beta of Open Office 2.0, and resaved and reuploaded the file in my original message. See if that works okay now. _____________________
|
|
Azelda Garcia
Azelda Garcia
Join date: 3 Nov 2003
Posts: 819
|
11-29-2004 05:36
From what Aaron is saying, it looks like it might be a particular Date Format that is the issue, rather than arithmetic or formulae.
Azelda _____________________
|
|
Burke Prefect
Cafe Owner, Superhero
Join date: 29 Oct 2004
Posts: 2,785
|
11-29-2004 09:48
I'm not gonna bother looking at the sheet, but..
Newer versions of M$Office will intentionally bork up files it knows are from OpenOffice. This could be a glitch, but I COULD also be entirely right. |
|
Blake Rockwell
Fun Businesses
Join date: 31 Oct 2004
Posts: 1,606
|
11-29-2004 09:53
Question..how do we get to the roof of the Mega Towers..what floor is that?
_____________________
|
|
Jacqueline Richelieu
SL Resident Economist
Join date: 28 Jul 2004
Posts: 260
|
11-29-2004 13:15
Thanks, Hank. Useful info for us non-business types trying to understand how the wheels turn. I actuall have always wished I could get my hands on the books of a McDonalds, Radio Shack, or something like that, just to see how they make their $$$ one hamburger or battery at a time BTW. Had tons of #VALUE errors too, using Excel XP (2002). I'll check it out using Open Office (Solaris) at work tomorrow. - T - McDonald's financials at your fingertips: http://finance.yahoo.com/q/is?s=MCD No need to thank me... love being of service ~Jaq |
