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),INDIRE CT(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..

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),INDIREC T(I13)))+IF(J13="",INDIRECT(H13),MIN(INDIRECT(H13) ,INDIRECT(J13)))+Sta+IF(M13="",0,$G$2)+MIN(INDIREC T(G13),INDIRECT(H13),IF(I13="",INDIRECT(G13),INDIR ECT(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),INDIRE CT(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..

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..



On Mon, 15 May 2006 14:13:02 -0700, Miguel Zapico
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),INDIRE CT(I13)))+IF(J13="",INDIRECT(H13),MIN(INDIRECT(H13 ),INDIRECT(J13)))+Sta+IF(M13="",0,$G$2)+MIN(INDIRE CT(G13),INDIRECT(H13),IF(I13="",INDIRECT(G13),INDI RECT(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),INDIRE CT(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..

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






On Mon, 15 May 2006 14:13:02 -0700, Miguel Zapico
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),INDIRE CT(I13)))+IF(J13="",INDIRECT(H13),MIN(INDIRECT(H13 ),INDIRECT(J13)))+Sta+IF(M13="",0,$G$2)+MIN(INDIRE CT(G13),INDIRECT(H13),IF(I13="",INDIRECT(G13),INDI RECT(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),INDIRE CT(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..