Formula for Game Spreadsheet

  • Thread starter Thrumbar Pathfinder
  • Start date
T

Thrumbar Pathfinder

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

(e-mail address removed)
 
M

Miguel Zapico

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

Thrumbar Pathfinder

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

(e-mail address removed)

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 said:
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/SancMisc/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..

(e-mail address removed)
Click to expand...
Click to expand...
 
T

Thrumbar Pathfinder

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

(e-mail address removed)




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 said:
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/SancMisc/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..

(e-mail address removed)
Click to expand...
Click to expand...
 
Top