[Herts] openoffice calc

[Neil Youngman]

On or around Tuesday 06 March 2007 20:13, Barry Sharpe reorganised a bunch of 
electrons to form the message:
>
> I am trying to model a skill tree that a character in game performs to get
> better at a certain task the skill tree is based on rank, level and skill
> points the skill continues to train whilst the character is offline. Rank
> represents the length of time it takes to train the skill, level represents
> how good you are at the given skill. The skill points just represent the
> time taken to train a given skill
>
> So
>
> A rank 1 skill as follows
> Level 1 = 250 (Skill points)
> Level 2 = 1415
> Level 3 = 8000
> Level 4 = 45255
> Level 5 = 256000
>
> A rank 3 skill as follows
> Level 1 = 750
> Level 2 = 4243
> Level 3 = 24000
> Level 4 = 135765
> Level 5 = 768000
>
> Clearly the Rank 3 skill takes a lot longer to train than a Rank 1 skill.
> The following formula is used to calculate length of time to train a given
> skill.
>
> ( SP_Needed - Current_SP ) / ( Pri_Attrib + ( Sec_Attrib / 2 ) )
>
> Attributes are just a number given by a player to his character so he can
> better personalise his/her character for example some skills use memory as
> a primary attribute and chrisma as a secondary attribute.
>
> Typically primary and secondary attrbitues hold a value of P=19 S=17
> The output of the above formula is always in minutes this works great for
> when a skill is due to be completed in minutes or hours but for the life of
> me when days are involved it seems to be a whole different story trying to
> get openoffice to successfully convert the result from the above formula
> such as 8000 minutes.

OK. Are you trying to get it to OO.o to display something like "5 13:20" for 
8000 minutes or just get 5 days out of it?

AFAICS there doesn't seem to be a format code that gives you a number of days, 
as opposed to a date. You may need to build a relatively complex expression 
to get it to work. The text function may help, e.g. =TEXT(D2;"#") & " days" 
displays 5 days if D2 contains 5. See 
http://www.openofficetips.com/blog/archives/2005/08/basic_functions_11.html ,  
for a couple of examples.

To get 5 from 8000 "=trunc(8000/(24*60))" works just fine.

> I was hoping to use this to better clarify my thoughts so that I might
> write a kde desktop app that warns a player when a skill change is required
> but that's another project :)
>
> Barry