View difference between Paste ID: b39vsFqz and 3XuDx0MS
SHOW: | | - or go back to the newest paste.
1-
Can someone post the following reply on my behalf in [URL="https://www.freemathhelp.com/forum/threads/109452-Formula-using-arithmetic-and-simple-functions-on-a-table"]Formula using arithmetic and simple functions on a table?[/URL] The inline file replacing the lines starting with "TO REPLACE THIS WITH ATTACHMENT" with the corresponding files? The files in question: https://drive.google.com/open?id=1tQnRTorfFnp8mJVY18BA276Mwx3Ximdu https://drive.google.com/open?id=10WkpVualfILyoIUGjSY4It41oFey92du https://drive.google.com/open?id=1gnLY_eV6lowVjzBfWXS84ghTzmhQcu9b
1+
Can someone post the following reply on my behalf in [URL="https://www.freemathhelp.com/forum/threads/109452-Formula-using-arithmetic-and-simple-functions-on-a-table"]Formula using arithmetic and simple functions on a table?[/URL] The inline file replacing the lines starting with "TO REPLACE THIS WITH ATTACHMENT" with the corresponding files? The files in question: https://drive.google.com/open?id=10WkpVualfILyoIUGjSY4It41oFey92du https://drive.google.com/open?id=1gnLY_eV6lowVjzBfWXS84ghTzmhQcu9b
2
3
[QUOTE]I apologize for the delay; after successfully testing it in a spreadsheet, I procrastinated to test test it in the profile/sheet/info type, but then there was [URL="http://www.freemathhelp.com/forum/threads/109498-What-s-going-on"]this[/URL] delay.
4
5
[QUOTE=mmm4444bot;421228]Let x = Level number
6
Rage Damage = floor(((x+58)*(x+58)*(x+58))/100000)[/QUOTE]
7
That's exactly what I was looking for. Here's the test:
8
TO REPLACE THIS WITH ATTACHMENT VTT-Roll20-template_OGL-Barbarian-Rage_Damage-freemathhelp_mmm4444bot_formula.png
9-
and its result is included in the spreadsheet I referred to earlier; one can see it for oneself by opening the attached zip file
9+
10-
TO REPLACE THIS WITH ATTACHMENT VTT-Roll20-OGL_template-Barbarian-formula-Rage_Damage_from_Level-171228-1824.zip
10+
11-
with OpenOffice as the native spreadsheet file of OpenOffice Calc, .ods, is actually a zip file with another extension name (so just renaming the .zip to .ods with OpenOffice Calc content make it a native file).
11+
12
then in the tab Attributes & Abilities verify there's the Attribute base_level and make sure one has the exact name of it. The at the top (of the same tab) press the related button Add (so Attribute, which should be by default Untitled) then name it bbn_dmg, standing for Barbarian Damage, then include the formula floor(((@{base_level}+58)*(@{base_level}+58)*(@{base_level}+58))/100000), which of course should match exactly what was mentioned previously (do not use the base_level of this formula but the one from the sheet). In the tab Character Sheet sub-tab CORE section ATTACKS & SPELLCASTING create a new one by pressing the + icon (there's a better way but the goal is not to teach Roll20) then fill something that make sens (see the image for an example) and have 1 of the damages be @{bbn_dmg} then press the cog icon of what was just added then press what's now standing instead of it. To see what it is for different level, just change the level (as explained earlier in this paragraph) then press the weapon name again.[/QUOTE]