Here is the problem:

I'm running a stable of 7 characters in an MMORPG game [2Moons] and need to
keep track of what armor and weapon upgrades I have found so far as loot for
the upcoming levels as the characters progress. When I'm out hunting with
one char, I pick up interseting loot for the other chars. Farming for those
who haven't played. It's much more efficient to farm with multiple character
classes. I need to keep track of this info on something other than pencil
and paper. Storage space in a char is limited while hunting, so I need to
keep only useful loot to bring home. It takes time to come back home and go
out hunting again, so this needs to be efficient. I ran into the same
problem with Guild Wars, so this is a problem common to MMORPGs.

Problem make sense?

I have considered two approaches:

Spreadsheet

I'll need a spreadsheet that has some locked columns on the left and the
remainder of the columns scroll left and right. Up/down scrolling is
unrestricted. All rows scroll together up and down.

The columns on the left would be the character names, and current level, 
and the columns will be in blocks on the right a block for each significant
level. Weapons upgrade every 6 levels and armor every 10 levels, but I could
finesse that and make the blocks cover every 10 levels. The blocks woujld be
data about the weapon and armor style, status [whether I have it or not] and
whether or not it is enhanced in some way or needs to be.

Can an OO Sheet have columns that are locked against scrolling? I can't see
a menu item to do it and don't know what to search for in the help.

Database

Perhaps this can be done with OOBase. Maybe that's going to be simpler. A
record for each level with all data, indexed by character name and level.
The only problem with this approach is that it's hard to show all characters
together at a particular level. Or maybe not? Query by level and show all
characters at that level with data across in a table?

Anybody else solved a similar problem with Base or Sheets?

Thanks,
ww

-- 
View this message in context: 
http://www.nabble.com/OO-Spreadsheet-or-Base-problem---tp21280691p21280691.html
Sent from the openoffice - users mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to