I put together a stat block for the Steel Defender using Google Sheets. Select your level and intelligence from the dropdowns to generate your defender's stats.
Looks pretty good! the DAMAGE calculation should be: ="1d8+"&data!B7 (B7 changed from B8). The damage is supposed to be calculated as 1d8 + PB, not 1d8 + SPELL ATTACK.
Nice work, though! I just gained a steel defender and I've been looking for how to use it accurately!
I put together a stat block for the Steel Defender using Google Sheets. Select your level and intelligence from the dropdowns to generate your defender's stats.
Let me know if it works for you, and if you find any errors. Thanks.
Can I suggest having two dropdowns for level? Most of an SD scales with Int modifier and Proficiency bonus, but the hit points scale with Int modifier and Artificer level. For multiclassing purposes, it would be nice to be able to tell the sheet your Artificer level separately from your character level.
Thanks! I'm learning Sheets on the fly. Of course, there's a floor function. *face palm*
There are min and max functions, too - you shouldn't need duplicate cells and nested if statements for what you're doing. For example, this is total levels if you want a cap of level 20:
As someone playing an artificer for the 1st time I would like to say thank you so very much for the help with this. Keeping track of the steel defender is 10000% easier thanks to you
Thanks for the site. Too bad my Steel Defender is a Large Wombat, and finding existing pictures of them (in robotic form) has been, um, disappointing. Oh well!
I put together a stat block for the Steel Defender using Google Sheets. Select your level and intelligence from the dropdowns to generate your defender's stats.
https://docs.google.com/spreadsheets/d/1gNHEOWDZECINmb5seiIRAMSrWvDh5KT9BsWwOetp0PE/edit?usp=sharing
Let me know if it works for you, and if you find any errors. Thanks.
Looks pretty good! the DAMAGE calculation should be: ="1d8+"&data!B7 (B7 changed from B8). The damage is supposed to be calculated as 1d8 + PB, not 1d8 + SPELL ATTACK.
Nice work, though! I just gained a steel defender and I've been looking for how to use it accurately!
Thanks for the catch. I'll make the update.
You might appreciate this guys animal sculptures for Steel Defender looks: https://www.andrewchase.com
Can I suggest having two dropdowns for level? Most of an SD scales with Int modifier and Proficiency bonus, but the hit points scale with Int modifier and Artificer level. For multiclassing purposes, it would be nice to be able to tell the sheet your Artificer level separately from your character level.
Excellent point! I'll make that update.
Working on an automatic bump to Improved Steel Defender at level 14, too.
Updated the sheet.
It gets wonky if your total levels are over 20. A fix for another day.Guess it was a fix for today after all.I see, you're using a select, not calculating the PB on the fly. Try this PB formula:
PB(Level) = floor((Level-1)/4)+2
Thanks! I'm learning Sheets on the fly. Of course, there's a floor function. *face palm*
There are min and max functions, too - you shouldn't need duplicate cells and nested if statements for what you're doing. For example, this is total levels if you want a cap of level 20:
=min(20,SUM(B4:B5))
As someone playing an artificer for the 1st time I would like to say thank you so very much for the help with this. Keeping track of the steel defender is 10000% easier thanks to you
Thanks for the site. Too bad my Steel Defender is a Large Wombat, and finding existing pictures of them (in robotic form) has been, um, disappointing. Oh well!
Sounds like a job for an AI art generator
I can only veiw
Make a copy to use it.