|
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),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.. |
Formula for Game Spreadsheet
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.. |
Formula for Game Spreadsheet
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.. |
| All times are GMT +1. The time now is 08:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com