Formula for Game Spreadsheet

I am currenly playing a game of Ars Magica. I am using a spreadsheet to compute
the info for my character. I am having a probllem with the casting total for
spells related to a paticular character. The Formula is as follows :

=IF(H13="","--",IF(J13="",INDIRECT(H13),MIN(INDIRECT(H13),INDIRECT(LEFT(J13,2)),INDIRECT(RIGHT(J13,2))))+IF(K13="",INDIRECT(I13),MIN(INDIRECT(I13),INDIRECT(LEFT(K13,2)),INDIRECT(RIGHT(K13,2))))+Sta+IF(N13="",0,$H$2))

I am trying to compute the casting total for the spells castable by this
character. The total for the casting total is the Technique + Form + Stanima.
This character has a additional abuility to double the lowest Technique or Form
and use that number for the casting total.

H13 is the Technique
I13 is the Form
J13 is the Requisite Technique
K13 is the Requisite Form


If you like to you can download the spreadsheet to look at

http://www.geocities.com/sanctumhr/SancMisc/magus.xls

At

http://www.geocities.com/sanctumhr/S.../sancmisc.html

The formula I am refering to is on the GRIMOIRE page in cell ( M13 ).

I am trying to compute the casting formula based on the Tech and For adjusted by
the requisited to double the lowest one and add that into the compution.. (add
the lowest applicable Art score twice)

The formula is for figuring the Diedne casting total (When you spend a fatigue
on casting a spontaneous spell, the lowest applicable art (Technique or Form)
is doubled)

Tech Cr(41) + Form Im(25) (Req Me 20) [ 41 + (20*2)] = 81

41 + min[25,20]*2 = 81


Any help would be appreciated..

[email protected]

Taking into account that there are no blanks in the column H, and there are
no spells with two requesities on form or technique, you may use this
formula, that simplifies the first part and includes a final part to add once
more the minimum of the four possible values of techniques and forms:
=IF(I13="",INDIRECT(G13),MIN(INDIRECT(G13),INDIRECT(I13)))+IF(J13="",INDIRECT(H13),MIN(INDIRECT(H13),INDIRECT(J13)))+Sta+IF(M13="",0,$G$2)+MIN(INDIRECT(G13),INDIRECT(H13),IF(I13="",INDIRECT(G13),INDIRECT(I13)),IF(J13="",INDIRECT(H13),INDIRECT(J13)))

This works in the version I have downloaded from the web (that is one column
displaced to the left from your formulas)

Good luck in the game!
Miguel.

"Thrumbar Pathfinder" wrote:

> I am currenly playing a game of Ars Magica. I am using a spreadsheet to compute
> the info for my character. I am having a probllem with the casting total for
> spells related to a paticular character. The Formula is as follows :
>
> =IF(H13="","--",IF(J13="",INDIRECT(H13),MIN(INDIRECT(H13),INDIRECT(LEFT(J13,2)),INDIRECT(RIGHT(J13,2))))+IF(K13="",INDIRECT(I13),MIN(INDIRECT(I13),INDIRECT(LEFT(K13,2)),INDIRECT(RIGHT(K13,2))))+Sta+IF(N13="",0,$H$2))
>
> I am trying to compute the casting total for the spells castable by this
> character. The total for the casting total is the Technique + Form + Stanima.
> This character has a additional abuility to double the lowest Technique or Form
> and use that number for the casting total.
>
> H13 is the Technique
> I13 is the Form
> J13 is the Requisite Technique
> K13 is the Requisite Form
>
>
> If you like to you can download the spreadsheet to look at
>
> http://www.geocities.com/sanctumhr/SancMisc/magus.xls
>
> At
>
> http://www.geocities.com/sanctumhr/S.../sancmisc.html
>
> The formula I am refering to is on the GRIMOIRE page in cell ( M13 ).
>
> I am trying to compute the casting formula based on the Tech and For adjusted by
> the requisited to double the lowest one and add that into the compution.. (add
> the lowest applicable Art score twice)
>
> The formula is for figuring the Diedne casting total (When you spend a fatigue
> on casting a spontaneous spell, the lowest applicable art (Technique or Form)
> is doubled)
>
> Tech Cr(41) + Form Im(25) (Req Me 20) [ 41 + (20*2)] = 81
>
> 41 + min[25,20]*2 = 81
>
>
> Any help would be appreciated..
>
> [email protected]
>

Could you email me the spreadsheet, tried pasting the formula but got a error,
either that or lack of sleep for 20+ hours is getting to me..

[email protected]

On Mon, 15 May 2006 14:13:02 -0700, Miguel Zapico
<[email protected]> wrote:

>Taking into account that there are no blanks in the column H, and there are
>no spells with two requesities on form or technique, you may use this
>formula, that simplifies the first part and includes a final part to add once
>more the minimum of the four possible values of techniques and forms:
>=IF(I13="",INDIRECT(G13),MIN(INDIRECT(G13),INDIRECT(I13)))+IF(J13="",INDIRECT(H13),MIN(INDIRECT(H13),INDIRECT(J13)))+Sta+IF(M13="",0,$G$2)+MIN(INDIRECT(G13),INDIRECT(H13),IF(I13="",INDIRECT(G13),INDIRECT(I13)),IF(J13="",INDIRECT(H13),INDIRECT(J13)))
>
>This works in the version I have downloaded from the web (that is one column
>displaced to the left from your formulas)
>
>Good luck in the game!
>Miguel.
>
>"Thrumbar Pathfinder" wrote:
>
>> I am currenly playing a game of Ars Magica. I am using a spreadsheet to compute
>> the info for my character. I am having a probllem with the casting total for
>> spells related to a paticular character. The Formula is as follows :
>>
>> =IF(H13="","--",IF(J13="",INDIRECT(H13),MIN(INDIRECT(H13),INDIRECT(LEFT(J13,2)),INDIRECT(RIGHT(J13,2))))+IF(K13="",INDIRECT(I13),MIN(INDIRECT(I13),INDIRECT(LEFT(K13,2)),INDIRECT(RIGHT(K13,2))))+Sta+IF(N13="",0,$H$2))
>>
>> I am trying to compute the casting total for the spells castable by this
>> character. The total for the casting total is the Technique + Form + Stanima.
>> This character has a additional abuility to double the lowest Technique or Form
>> and use that number for the casting total.
>>
>> H13 is the Technique
>> I13 is the Form
>> J13 is the Requisite Technique
>> K13 is the Requisite Form
>>
>>
>> If you like to you can download the spreadsheet to look at
>>
>> http://www.geocities.com/sanctumhr/SancMisc/magus.xls
>>
>> At
>>
>> http://www.geocities.com/sanctumhr/S.../sancmisc.html
>>
>> The formula I am refering to is on the GRIMOIRE page in cell ( M13 ).
>>
>> I am trying to compute the casting formula based on the Tech and For adjusted by
>> the requisited to double the lowest one and add that into the compution.. (add
>> the lowest applicable Art score twice)
>>
>> The formula is for figuring the Diedne casting total (When you spend a fatigue
>> on casting a spontaneous spell, the lowest applicable art (Technique or Form)
>> is doubled)
>>
>> Tech Cr(41) + Form Im(25) (Req Me 20) [ 41 + (20*2)] = 81
>>
>> 41 + min[25,20]*2 = 81
>>
>>
>> Any help would be appreciated..
>>
>> [email protected]
>>

Finnaly got it, I had added a column to the magus spreadsheet and deleted it
corrected the problem..

[email protected]




On Mon, 15 May 2006 14:13:02 -0700, Miguel Zapico
<[email protected]> wrote:

>Taking into account that there are no blanks in the column H, and there are
>no spells with two requesities on form or technique, you may use this
>formula, that simplifies the first part and includes a final part to add once
>more the minimum of the four possible values of techniques and forms:
>=IF(I13="",INDIRECT(G13),MIN(INDIRECT(G13),INDIRECT(I13)))+IF(J13="",INDIRECT(H13),MIN(INDIRECT(H13),INDIRECT(J13)))+Sta+IF(M13="",0,$G$2)+MIN(INDIRECT(G13),INDIRECT(H13),IF(I13="",INDIRECT(G13),INDIRECT(I13)),IF(J13="",INDIRECT(H13),INDIRECT(J13)))
>
>This works in the version I have downloaded from the web (that is one column
>displaced to the left from your formulas)
>
>Good luck in the game!
>Miguel.
>
>"Thrumbar Pathfinder" wrote:
>
>> I am currenly playing a game of Ars Magica. I am using a spreadsheet to compute
>> the info for my character. I am having a probllem with the casting total for
>> spells related to a paticular character. The Formula is as follows :
>>
>> =IF(H13="","--",IF(J13="",INDIRECT(H13),MIN(INDIRECT(H13),INDIRECT(LEFT(J13,2)),INDIRECT(RIGHT(J13,2))))+IF(K13="",INDIRECT(I13),MIN(INDIRECT(I13),INDIRECT(LEFT(K13,2)),INDIRECT(RIGHT(K13,2))))+Sta+IF(N13="",0,$H$2))
>>
>> I am trying to compute the casting total for the spells castable by this
>> character. The total for the casting total is the Technique + Form + Stanima.
>> This character has a additional abuility to double the lowest Technique or Form
>> and use that number for the casting total.
>>
>> H13 is the Technique
>> I13 is the Form
>> J13 is the Requisite Technique
>> K13 is the Requisite Form
>>
>>
>> If you like to you can download the spreadsheet to look at
>>
>> http://www.geocities.com/sanctumhr/SancMisc/magus.xls
>>
>> At
>>
>> http://www.geocities.com/sanctumhr/S.../sancmisc.html
>>
>> The formula I am refering to is on the GRIMOIRE page in cell ( M13 ).
>>
>> I am trying to compute the casting formula based on the Tech and For adjusted by
>> the requisited to double the lowest one and add that into the compution.. (add
>> the lowest applicable Art score twice)
>>
>> The formula is for figuring the Diedne casting total (When you spend a fatigue
>> on casting a spontaneous spell, the lowest applicable art (Technique or Form)
>> is doubled)
>>
>> Tech Cr(41) + Form Im(25) (Req Me 20) [ 41 + (20*2)] = 81
>>
>> 41 + min[25,20]*2 = 81
>>
>>
>> Any help would be appreciated..
>>
>> [email protected]
>>