Roll20 uses cookies to improve your experience on our site. Cookies enable you to enjoy certain features, social sharing functionality, and tailor message and display ads to your interests on our site and others. They also help us understand how our site is being used. By continuing to use our site, you consent to our use of cookies. Update your cookie preferences .
×
Create a free account

Looking for someone to (successfully) create some very complicated macros for me.

1589433645

Edited 1589433696
I HAVE A TALL ORDER. I NEED TO ENLIST THE HELP OF SOMEONE WHO HAS AN EXPERT LEVEL KNOWLEDGE OF ROLL20 AND ATTACK MACROS. I WILL SOON BE CRAFTING MY " PIÈCE DE RÉSISTANCE" ARTIFACT-LEVEL EPIC+ WEAPON. (LONG STORY SHORT, IT'S A GESTALT GAME AND WE ARE WELL INTO EPIC LEVELS AND I CAN DO IT.) ANYWAY, I WILL BE CREATING A SET. IT WILL CONSIST OF A BOW, WEAPON CRYSTAL, ARROWS, AND A QUIVER. WHAT I NEED HELP WITH IS CREATING A MACRO FOR THE ATTACK AND DAMAGE ROLLS WHICH WILL STREAMLINE EVERYTHING BECAUSE AS IS IT WILL TAKE *FOREVER* TO ROLL EVERYTHING SEPARATELY AS IT IS HIGHLY COMPLICATED. IF ANYONE IS WILLING TO HELP ME OUT AND SUCCESSFULLY GET EVERYTHING IRONED OUT AND WORKING 100% PROPERLY, I'LL PAYPAL YOU $20. IF YOU ARE INTERESTED, LET ME KNOW AND I WILL SEND YOU THE DETAILS OF WHAT I'LL BE CRAFTING. (this is a 3.5e game)
1589435049
Oosh
Sheet Author
API Scripter
Not really interested in the money, happy to help out if everyone is pitching in though. A bit more info would be handy - are you a player or GM? What level of membership does the GM have? This will make an enormous difference as to what can be achieved.
I am a player. As far as my GM's membership goes, I have no idea? I'd be willing to buy him a better membership as long as it is not too pricey. 
1589435617
GiGs
Pro
Sheet Author
API Scripter
Why dont you describe what is needed (IN FULL DETAIL - include all needed attribute names and roll details), and people might do it for free. Or would be able to judge if its worth the money. Mu gut feeling is you are offering too little if its very complex. If it takes a few hours to create, you're offering too little.
Perhaps I am offering too little. I have no idea how long it would take but I am assuming that someone with expert level knowledge of roll20 should probably be able to crank it out fairly quickly. I'll now post what would be included. (this will take a while to type up lol)
1589437054

Edited 1589437825
I will leave out the unnecessary information and just focus on what I hope is relevant for the macros. The bow has a +8 enhancement bonus.  It is also a +6 composite longbow.  Crit range: 19-20 x 3. It will have the Splitting property, so all (successful) attacks made with it are x2 and have the same attack rolls and crit chance.  +2 bonus to hit evil outsiders. per-hit effects: +5 damage (Collision property, multiplied with crits) 2d6 points of acid, fire, frost, shock damage 1d6 points of extra damage vs. constructs (multiplied with crits) 5d6+2 points of extra damage vs. evil outsiders (multiplied with crits) 1d4 points of dessication damage, 1d8 if target is plant or elemental with water subtype 1d4 points of sonic damage 1d6 points of extra damage vs. undead (multiplied with crits) 2d6 points of extra damage vs. targets capable of casting arcane spells or using invocations (multiplied with crits) 1 point of STR damage per hit 1 point of CON damage per hit 3d6 points of holy damage per hit if evil One negative level per hit 1d6 points of extra damage from Exit Wound property (multiplied with crits) critical hit effects (this is on top of normal per-hit effects unless otherwise noted): 2d10 points of acid, frost, shock, fire damage 2d8 points of dessication damage (4d8 against plants and elementals with the water subtype) 2d8 points of sonic damage 2d10 points of positive energy damage if undead and 4d10 damage if evil outsider 9d6 points of holy damage (does not stack with normal 3d6 holy damage) 3 negative levels (does not stack with the 1 negative level for simply hitting target; greater effect applies per shot)
Please let me know if this is not clear enough.
1589440514

Edited 1589441065
Oosh
Sheet Author
API Scripter
Have you cleared this with your GM? If they're not comfortable using API scripts, and/or don't have a Pro subscription, this will be an absolute nightmare for them to calculate & manually modify each token. I honestly wouldn't even bother starting on this without API use, as just using the weapon against multiple targets in a round will bring the game grinding to a halt. You'd either need to roll all of the damage & penalty types you've listed, then (per target AND per shot) manually add up the ones which apply, then modify the token HP/CON/STR/Level manually -or- you need  to fill the macro with queries about whether the enemy meets any and all of the listed criteria above before it rolls damage - that'll mean clicking through 5+ drop down menus every time you attack with the bow, for every shot and every target. If your GM has Pro membership and is confident using Token Mod, it's a different story - you should be able to achieve this with a bit of setting up. If you're limited to vanilla macros I'd very strongly recommend streamlining the weapon to be less conditional. edit - I've never played 3.5 on Roll20. I'm assuming the monsters all have their alignment and type(s) readable in some way by the API without manually setting up
I have cleared it with the GM but obviously I know that with an item this complicated, rolling attacks and damage would be a nightmare. I am not 100% certain but I am fairly confident that my GM has pro membership and he knows Roll20 far better than my fellow party members do. However, I don't think that he would know how to set up a macro this complex, which is why I tried to get some help because we are somewhat close to the end of our game and I want this item to be a completely OP, devastating, and memorable thing.  The STR and CON damage we can take care of outside of the macros, as well as the negative levels. The GM can keep track of that whenever we attack something. Everything else needs to be pretty much included in the macros though.
1589446060

Edited 1589447296
Oosh
Sheet Author
API Scripter
No worries, you really should make 100% sure you are going to be able to use TokenMod, otherwise the script will be 100% useless. You can't just write the macro then paste it into an API script later, as they are different beasts. To illustrate how much fun this bow will be to use with regular macros: &{template:default}{{name=Bow of Complexity}}{{Base damage=[[2d6+5]]}}{{Acid damage=[[floor(2d6*(?{Is target resistant to Acid?|No,1|Yes,0.5}))]]}}{{Fire damage=[[floor(2d6*(?{Is target resistant to Fire?|No,1|Yes,0.5}))]]}}{{Frost damage=[[floor(2d6*(?{Is target resistant to Frost?|No,1|Yes,0.5}))]]}}{{Shock damage=[[floor(2d6*(?{Is target resistant to Shock?|No,1|Yes,0.5}))]]}} this is only the first 2 lines of a non-crit damage roll. Or you could lump up the damage: &{template:default}{{name=Bow of Complexity}}{{Base damage=[[2d6+5]]}}{{Elemental damage=[[ [[floor(2d6*(?{Is target resistant to Acid?|No,1|Yes,0.5}))]] + [[floor(2d6*(?{Is target resistant to Fire?|No,1|Yes,0.5}))]] + [[floor(2d6*(?{Is target resistant to Frost?|No,1|Yes,0.5}))]] + [[floor(2d6*(?{Is target resistant to Shock?|No,1|Yes,0.5}))]] ]]}} and just hope your DM trusts you, as that level of inline rolling the mouseover isn't telling you a great deal. And again, we're only 2 lines in. And I haven't even bothered with vulnerability or immunity. Anyways, it's honestly not that hard to macro the damage calculations, it's using it that will be the headache. It looks like there's another... 10+??? conditionals (resistances/alignment/type/subtype) to take into account for every single shot fired. 15+ clicks per arrow fired, and that's without the attack roll. If you make a mistake you would need to click your way through all those dropdowns again. Anyways, if you're 100% sure you can use API then someone can probably help you. I'm a scrubby Plus subscriber and can't do this unfortunately, as TokenMod looks like amazing fun! Good luck with your Bow of Spreadsheets! edit - I might actually finish this macro off for fun, always looking for new ways to make my DM cry...
1589450105
Oosh
Sheet Author
API Scripter
Okay, so I was bored enough to at least do the base damage. A standard shot, with no splitting involved, no character stats called on and guessed at the base damage: &{template:default}{{name=Bow of Spreadsheets}}{{Base damage=[[(2d6+6+8)*?{Is target resistant to Piercing damage?|No,1|Yes,0.5|Immune,0|Vulnerable,2}]]}}{{Collision damage=[[5*?{Is target resistant to Piercing damage?}]]}}{{Acid damage=[[floor(2d6*(?{Is target resistant to Acid?|No,1|Yes,0.5|Immune,0|Vulnerable,2}))]]}}{{Fire damage=[[floor(2d6*(?{Is target resistant to Fire?|No,1|Yes,0.5|Immune,0|Vulnerable,2}))]]}}{{Frost damage=[[floor(2d6*(?{Is target resistant to Frost?|No,1|Yes,0.5|Immune,0|Vulnerable,2}))]]}}{{Shock damage=[[floor(2d6*(?{Is target resistant to Shock?|No,1|Yes,0.5|Immune,0|Vulnerable,2}))]]}} {{Sonic damage=[[floor(1d4*(?{Is target resistant to Sonic?|No,1|Yes,0.5|Immune,0|Vulnerable,2}))]]}} {{Construct damage=[[1d6*?{Is target a Construct?|No,0|Yes,1}*?{Is target resistant to Piercing damage?}]]}} {{Outsider damage=[[(5d6+2)*?{Is target resistant to Piercing damage?}*?{Is target an Evil Outsider|No,0|Yes,1}]]}}{{Dessication=[[1d4*?{Is target a Water type Elemental or Plant?|No,1|Yes,2}]]}}{{Undead=[[1d6*?{Is target Undead?|No,0|Yes,1}*?{Is target resistant to Piercing damage?}]]}} {{Arcane/Invocation=[[2d6*?{Can you target cast arcane spells or use invocations?|No,0|Yes,1}*?{Is target resistant to Piercing damage?}]]}}{{Evil damage=[[3d6*(?{Is your target Evil?|No,0|Yes,1}*?{Is your target resistant to Holy?|No,1|Yes,0.5|Immune,0|Vulnerable,2})]]}}{{Exit wound=[[1d6]], arrow can hit target behind at -4 to hit}}{{Other effects=[[0-1]] STR [[0-1]] CON [[0-1]] Level}} It's like being interrogated by an accountant! Honestly, does it need that many damage types? Even with TokenMod I feel like it's loads of extra work for very little benefit in spreading the damage so wide, but again I haven't used it so I don't know.
1589457818
Ziechael
Forum Champion
Sheet Author
API Scripter
I'm pretty experienced in writing complex 3.5e macros and can see how this one would be doable for sure. As andrew p. says you are looking at a number of queries per attack (I've managed to get it down to roughly 3 or 4 queries in my head assuming you also want/need anything like 'other att' and 'other damage' bonus options). Not sure how much time I'll need but happy to take a look as a mental exercise/distraction from all the other things I'm doing right now... I don't accept payment for this kind of thing but if you are desperate to have money be involved I can suggest a couple of things (charity or gifting sub money to your GM for allowing such an item ;) ). Again, not sure with regards to time but...
1589461806
Ziechael
Forum Champion
Sheet Author
API Scripter
Could do with some more info on this one: 9d6 points of holy damage (does not stack with normal 3d6 holy damage) Is that only vs evil as per the normal damage?
1589465008

Edited 1589479094
Ziechael
Forum Champion
Sheet Author
API Scripter
Here is what I have for you so far, it's minimal in terms of queries but naturally still a behemoth. [edit] Just realised I haven't taken into account the splitting property... likely way to resolve that would be to run the macro multiple times... First, set up your weapon as normal: I added the extra fluff as special properties for visibility. Then replace the standard macros as below: 1. 1d20cs>@{weapon1critmin} +@{bab}[BAB] +@{epicattackbonus}[Epic AB] + @{weapon1stat}[Ability] +@{size}[size] +@{weapon1enh}[Weapon Enh] +@{weapon1focus}[Weapon Focus] +[[{?{Enemy Type},0}kh1]][Type] +?{Additional Attack Bonus?}[Ad'l Atk Bon]  2. (The bold text can be rearranged to ask queries in any order you want, you can also alter the default answer to the queries by editing this section) ! ?{Additional Attack Bonus?|0} ?{Enemy Type|None specific,-100|Evil Outsider,2|Undead,0|Constructs,-2} ?{Desiccation applicable|No,0|Plant/Elemental(Water),2|Other applicable,1} ?{Arcane Caster/Invocator|No,0|Yes,2d6[Caster]} ?{Evil Alignment|No,0|Yes,3} ?{Additional Damage Bonus?|0} &{template:DnD35Attack} {{pcflag=true}} {{name=@{character_name}}} {{subtags=attacks with the @{weapon1name} }} {{attack1=hitting AC [[ @{weapon1attackcalc} ]] }} {{critconfirm1=Crit?: [[ @{weapon1attackcalc} ]] }} {{fumbleroll=Fumble: [[ d20 ]] }} {{damage1=for [[ @{weapon1damage} ]]dmg}} {{critdmg1=+ [[ @{weapon1crit} ]] crit dmg}} {{fullattackflag= [[ 0d1 ]] }} {{notes=@{weapon1specialproperties} }} 3. ! ?{Additional Attack Bonus?|0} ?{Enemy Type|None specific,-100|Evil Outsider,2|Undead,0|Constructs,-2} ?{Desiccation applicable|No,0|Plant/Elemental(Water),2|Other applicable,1} ?{Arcane Caster/Invocator|No,0|Yes,2d6[Caster]} ?{Evil Alignment|No,0|Yes,3} ?{Additional Damage Bonus?|0} &{template:DnD35Attack} {{pcflag=true}} {{name=@{character_name}}} {{subtags=attacks with a @{weapon1name} }} {{attack1=A1: [[ @{weapon1attackcalc} ]] }} {{critconfirm1=Crit?: [[ @{weapon1attackcalc} ]] }} {{fumbleroll=Fumble: [[ d20 ]] }} {{damage1=D1: [[ @{weapon1damage} ]] }} {{critdmg1=+ [[ @{weapon1crit} ]] }} {{fullattackflag= [[ ?{Full Attack?|No, 0d1|Yes, d1} ]] }} {{attack2=A2: [[ @{weapon1attackcalc}-5 ]] }} {{critconfirm2=Crit!: [[ @{weapon1attackcalc}-5 ]] }} {{damage2=D2: [[ @{weapon1damage} ]] }} {{critdmg2=+ [[ @{weapon1crit} ]] }} {{attack3=A3: [[ @{weapon1attackcalc}-10 ]] }} {{critconfirm3=Crit!: [[ @{weapon1attackcalc}-10 ]] }} {{damage3=D3: [[ @{weapon1damage} ]] }} {{critdmg3=+ [[ @{weapon1crit} ]] }} {{attack4=A4: [[ @{weapon1attackcalc}-15 ]] }} {{critconfirm4=Crit!: [[ @{weapon1attackcalc}-15 ]] }} {{damage4=D4: [[ @{weapon1damage} ]] }} {{critdmg4=+ [[ @{weapon1crit} ]] }} {{notes=@{weapon1specialproperties} }}  4. 1d8 + {@{weapon1damagestat},6}kl1[Weapon Dmg Ability] +@{weapon1enh}[Weapon Enh] +@{weapon1specialize}[Weapon Spec] + 5[Collision] + 2d6[Acid] + 2d6[Fire] + 2d6[Frost] + 2d6[Shock] +[[ [[ {?{Enemy Type}*2+1,1}kh1 ]]d[[ {?{Enemy Type}+100,6}kl1 ]] +[[ {?{Enemy Type},0}kh1 ]] ]][Type] +1d[[ ?{Desiccation applicable}*4 ]][Desiccation] +?{Arcane Caster/Invocator} +?{Evil Alignment}d6[Holy] +1d6[Exit Wound] +1d4[Sonic] +?{Additional Damage Bonus?}[Ad'l Dmg Bon] 5. [[ (@{weapon1critmult}-1) ]]d8 + (@{weapon1critmult}-1) * ({@{weapon1damagestat},6}kl1[Weapon Dmg Ability] +@{weapon1enh}[Weapon Enh] +@{weapon1specialize}[Weapon Spec] + 5[Collision] +[[ [[ {?{Enemy Type}*2+1,1}kh1 ]]d[[ {?{Enemy Type}+100,6}kl1 ]] +[[ {?{Enemy Type},0}kh1 ]] ]][Type] +?{Arcane Caster/Invocator} +1d6[Exit Wound] +?{Additional Damage Bonus?}[Ad'l Dmg Bon])  +2d10[Acid] +2d10[Frost] +2d10[Shock] +2d10[Fire] +[[ ?{Desiccation applicable}*2 ]]d8[Desiccation] +2d8[Sonic] +[[ ?{Evil Alignment}*3 ]]d6[Holy] +[[ {?{Enemy Type}+2,0}kh1 ]]d10[Positive] 6. ! ?{Enemy Type|None specific,-100|Evil Outsider,2|Undead,0|Constructs,-2} ?{Desiccation applicable|No,0|Plant/Elemental(Water),2|Other applicable,1} ?{Arcane Caster/Invocator|No,0|Yes,2d6[Caster]} ?{Evil Alignment|No,0|Yes,3d6[Holy]} ?{Additional Damage Bonus?|0} &{template:DnD35Attack} {{pcflag=true}} {{name=@{character_name}'s @{weapon1name} }} {{damage1=does [[ @{weapon1damage} ]]damage}} {{fullattackflag= [[ 0d1 ]] }} You might want to check the math on the damage, specifically the crit once you are using your info and know what your expected values should be... it should  be correct but it's easy to go macro-blind on these things! [Edit] GAH, you might also want to amend the prefix depending on your weapon name... 'a' uber bow... OCD going crazy right now!
1589469635
Oosh
Sheet Author
API Scripter
Good gravy, that's impressive! I thought enemies could potentially have resistance/immunity/vulnerability to pretty much anything in 3.5e? I'm not really familiar with it thought, and haven't looked at it on Roll20. I do like the way you've handled those enemy type queries, very clever!
1589470078

Edited 1589470412
Ziechael
Forum Champion
Sheet Author
API Scripter
Thanks, tried to work a few more in there but once you get to crits etc it becomes impossible to deal with. As for immunity etc, I leave that for the DM to handle, the sheet does provide places for damage resistance, spell resistance as well as alignment and type/subtype which could have been read to minimise yet more but it would assume that the sheets are filled out fully by the DM and with values that make sense to a macro... it becomes a whole thing. The only real way to deal with resistances is by liberal use of the roll tagging (like [Shock], [Acid] etc) so that the result can be reduced by those accordingly using the 'on hover' tooltip. This is so complex and huge however that the tooltip isn't fully visible until the roll is higher up the chat pane lol... but again, that's the DMs problem ;) I do like your way of handling immunity, vulnerability etc however! For a less complex attack macro that is a really good way of helping out a DM.
1589471608
Oosh
Sheet Author
API Scripter
This is so complex and huge however that the tooltip isn't fully visible until the roll is higher up the chat pane lol... but again, that's the DMs problem ;) Hahaha! If I was this DM, I think I'd be crunching a big old monster spreadsheet for the average % resistance spread across every monster and resistance type to get a factor like 0.9 (to pluck a number out of thin air) and just apply that to every damage roll regardless of what it hits.
Ziechael said: Could do with some more info on this one: 9d6 points of holy damage (does not stack with normal 3d6 holy damage) Is that only vs evil as per the normal damage? Yes, only vs. evil. (Holy Power epic weapon enhancement.)
Ziechael said: Here is what I have for you so far, it's minimal in terms of queries but naturally still a behemoth. [edit] Just realised I haven't taken into account the splitting property... likely way to resolve that would be to run the macro multiple times... First, set up your weapon as normal: I added the extra fluff as special properties for visibility. Then replace the standard macros as below: 1. 1d20cs>@{weapon1critmin} +@{bab}[BAB] +@{epicattackbonus}[Epic AB] + @{weapon1stat}[Ability] +@{size}[size] +@{weapon1enh}[Weapon Enh] +@{weapon1focus}[Weapon Focus] +[[{?{Enemy Type},0}kh1]][Type] +?{Additional Attack Bonus?}[Ad'l Atk Bon]  2. (The bold text can be rearranged to ask queries in any order you want, you can also alter the default answer to the queries by editing this section) ! ?{Additional Attack Bonus?|0} ?{Enemy Type|None specific,-100|Evil Outsider,2|Undead,0|Constructs,-2} ?{Desiccation applicable|No,0|Plant/Elemental(Water),2|Other applicable,1} ?{Arcane Caster/Invocator|No,0|Yes,2d6[Caster]} ?{Evil Alignment|No,0|Yes,3d6[Holy]} ?{Additional Damage Bonus?|0} &{template:DnD35Attack} {{pcflag=true}} {{name=@{character_name}}} {{subtags=attacks with the @{weapon1name} }} {{attack1=hitting AC [[ @{weapon1attackcalc} ]] }} {{critconfirm1=Crit?: [[ @{weapon1attackcalc} ]] }} {{fumbleroll=Fumble: [[ d20 ]] }} {{damage1=for [[ @{weapon1damage} ]]dmg}} {{critdmg1=+ [[ @{weapon1crit} ]] crit dmg}} {{fullattackflag= [[ 0d1 ]] }} {{notes=@{weapon1specialproperties} }} 3. ! ?{Additional Attack Bonus?|0} ?{Enemy Type|None specific,-100|Evil Outsider,2|Undead,0|Constructs,-2} ?{Desiccation applicable|No,0|Plant/Elemental(Water),2|Other applicable,1} ?{Arcane Caster/Invocator|No,0|Yes,2d6[Caster]} ?{Evil Alignment|No,0|Yes,3d6[Holy]} ?{Additional Damage Bonus?|0} &{template:DnD35Attack} {{pcflag=true}} {{name=@{character_name}}} {{subtags=attacks with a @{weapon1name} }} {{attack1=A1: [[ @{weapon1attackcalc} ]] }} {{critconfirm1=Crit?: [[ @{weapon1attackcalc} ]] }} {{fumbleroll=Fumble: [[ d20 ]] }} {{damage1=D1: [[ @{weapon1damage} ]] }} {{critdmg1=+ [[ @{weapon1crit} ]] }} {{fullattackflag= [[ ?{Full Attack?|No, 0d1|Yes, d1} ]] }} {{attack2=A2: [[ @{weapon1attackcalc}-5 ]] }} {{critconfirm2=Crit!: [[ @{weapon1attackcalc}-5 ]] }} {{damage2=D2: [[ @{weapon1damage} ]] }} {{critdmg2=+ [[ @{weapon1crit} ]] }} {{attack3=A3: [[ @{weapon1attackcalc}-10 ]] }} {{critconfirm3=Crit!: [[ @{weapon1attackcalc}-10 ]] }} {{damage3=D3: [[ @{weapon1damage} ]] }} {{critdmg3=+ [[ @{weapon1crit} ]] }} {{attack4=A4: [[ @{weapon1attackcalc}-15 ]] }} {{critconfirm4=Crit!: [[ @{weapon1attackcalc}-15 ]] }} {{damage4=D4: [[ @{weapon1damage} ]] }} {{critdmg4=+ [[ @{weapon1crit} ]] }} {{notes=@{weapon1specialproperties} }}  4. 1d8 + {@{weapon1damagestat},6}kl1[Weapon Dmg Ability] +@{weapon1enh}[Weapon Enh] +@{weapon1specialize}[Weapon Spec] + 5[Collision] + 2d6[Acid] + 2d6[Fire] + 2d6[Frost] + 2d6[Shock] +[[ [[ {?{Enemy Type}*2+1,1}kh1 ]]d[[ {?{Enemy Type}+100,6}kl1 ]] +[[ {?{Enemy Type},0}kh1 ]] ]][Type] +1d[[ ?{Desiccation applicable}*4 ]][Desiccation] +?{Arcane Caster/Invocator} +?{Evil Alignment} +1d6[Exit Wound] +1d4[Sonic] +?{Additional Damage Bonus?}[Ad'l Dmg Bon] 5. [[ (@{weapon1critmult}-1) ]]d8 + (@{weapon1critmult}-1) * ({@{weapon1damagestat},6}kl1[Weapon Dmg Ability] +@{weapon1enh}[Weapon Enh] +@{weapon1specialize}[Weapon Spec] + 5[Collision] +[[ [[ {?{Enemy Type}*2+1,1}kh1 ]]d[[ {?{Enemy Type}+100,6}kl1 ]] +[[ {?{Enemy Type},0}kh1 ]] ]][Type] +?{Arcane Caster/Invocator} +1d6[Exit Wound] +?{Additional Damage Bonus?}[Ad'l Dmg Bon])  +2d10[Acid] +2d10[Frost] +2d10[Shock] +2d10[Fire] +[[ ?{Desiccation applicable}*2 ]]d8[Desiccation] +2d8[Sonic] +9d6[Holy] +[[ {?{Enemy Type}+2,0}kh1 ]]d10[Positive] 6. ! ?{Enemy Type|None specific,-100|Evil Outsider,2|Undead,0|Constructs,-2} ?{Desiccation applicable|No,0|Plant/Elemental(Water),2|Other applicable,1} ?{Arcane Caster/Invocator|No,0|Yes,2d6[Caster]} ?{Evil Alignment|No,0|Yes,3d6[Holy]} ?{Additional Damage Bonus?|0} &{template:DnD35Attack} {{pcflag=true}} {{name=@{character_name}'s @{weapon1name} }} {{damage1=does [[ @{weapon1damage} ]]damage}} {{fullattackflag= [[ 0d1 ]] }} You might want to check the math on the damage, specifically the crit once you are using your info and know what your expected values should be... it should  be correct but it's easy to go macro-blind on these things! [Edit] GAH, you might also want to amend the prefix depending on your weapon name... 'a' uber bow... OCD going crazy right now! Fantastic work so far! Is is possible to to do this, however? -  When calculating the damage is it possible to separate the damage by type? As in show physical damage, then each other type of damage separately so it's easy to keep track of elemental and other damages in case a creature has resistance? That is, rather than it being all bundled together because then it is impossible to sell what damage is what. 
Vincent B. said: Ziechael said: Fantastic work so far! Is is possible to to do this, however? -  When calculating the damage is it possible to separate the damage by type? As in show physical damage, then each other type of damage separately so it's easy to keep track of elemental and other damages in case a creature has resistance? That is, rather than it being all bundled together because then it is impossible to sell what damage is what. 
1589477160
Kraynic
Pro
Sheet Author
All those labels inside the single square brackets become visible if you mouse over the total to see the calculations.
1589479294

Edited 1589479480
Ziechael
Forum Champion
Sheet Author
API Scripter
Vincent B. said: Fantastic work so far! Is is possible to to do this, however? -  When calculating the damage is it possible to separate the damage by type? As in show physical damage, then each other type of damage separately so it's easy to keep track of elemental and other damages in case a creature has resistance? That is, rather than it being all bundled together because then it is impossible to sell what damage is what.  You could separate the damage with labels for visibility if you really REALLY want to, it would give a much messier output though... and it'll mean you'd need to add it all together manually to get a total though. I'll do an example and show you what I mean when I get chance... Vincent B. said: Ziechael said: Could do with some more info on this one: 9d6 points of holy damage (does not stack with normal 3d6 holy damage) Is that only vs evil as per the normal damage? Yes, only vs. evil. (Holy Power epic weapon enhancement.) I've updated 4) and 5) in my original post to allow for the evil only holy damage.
1589514383
Oosh
Sheet Author
API Scripter
The example damage output I had further up had the damage separately (not in the template you want, but still an example): Do you want that much in your chat log for every arrow? Note that macros don't store any results, so you can't have it both ways i.e. itemised damage with a grand total at the end (without API magic). The mouseover + tags that Ziechael already did is the only real compromise. Although, I would assume that using TokenMod, you can write values to token fields, so you could have a character and out-of-sight token representing the bow, then use it's bar1,2,3 fields to store 6 damage values from each shot? Someone with API access would need to chime in on that.
1589569213

Edited 1589569672
andrew p. said: The example damage output I had further up had the damage separately (not in the template you want, but still an example): Do you want that much in your chat log for every arrow? Note that macros don't store any results, so you can't have it both ways i.e. itemised damage with a grand total at the end (without API magic). The mouseover + tags that Ziechael already did is the only real compromise. Although, I would assume that using TokenMod, you can write values to token fields, so you could have a character and out-of-sight token representing the bow, then use it's bar1,2,3 fields to store 6 damage values from each shot? Someone with API access would need to chime in on that. I'd say that it doesn't ALL need to be separated. Aside from the elemental damages (including Dessication and Holy Power) it is all just physical damage with only some of it applying at any given time, such as whether or not a target is undead, evil outsider, etc. There's also no need to roll each arrow twice because since they have the Splitting property we can just use the attack and damage rolls for each basic arrow shot... if it hits, then all the damage is just x2, including crits. I think that'd be simplest. In other words, collision/construct/outsider/undead/arcane-invocation user/and exit wound are all just added physical damage so I don't think they need to be separate, just accounted for with a yes/no question when rolling so things get applied as they should. Also the one labeled "evil damage" I think should be instead labeled Holy Damage. The positive energy damage that happens upon a crit should be listed separately from Holy.  Thank you guys so much for helping me out with this. Also, I asked my DM and he does indeed have a Pro account.
1590682667
Ziechael
Forum Champion
Sheet Author
API Scripter
This recent revelation might be of use when trying to display the various damage types without ultimately having to rip the whole macro apart. I haven't had time to play with it yet but can see how you might be able to get a total damage and then break down said damage by type after the fact... will see what I can do at some point when time allows ;)
1590711473
Oosh
Sheet Author
API Scripter
Oh yes, clever. Here is a mock-up with made up rolls and just the default template, just for proof of concept. 3.5 template is all yours though :) &{template:default}{{name=Stickchucker}}{{Physical Damage=[[ [[4d6 + 10]] + [[?{Construct|Yes,1d6|No,0}]] + [[?{Outsider?|Yes,2d6|No,0}]] + [[ ?{Undead?|Yes,3d6|No,0}]] ]]  $[[0]] Base  $[[1]] Construct  $[[2]] Outsider  $[[3]] Undead}}{{Elemental Damage=[[ [[2d6]] + [[2d6]] + [[2d6]] + [[2d6]] ]]  $[[5]] Acid  $[[6]] Fire  $[[7]] Frost  $[[8]] Shock}}
Just wanted to say thanks for all of the work and thought involved here. Can't wait to actually get this item crafted. ;)