Blacksmith bod tracker tool

Name says it all
Post Reply
Opopanax
Legendary Scribe
Reactions:
Posts: 263
Joined: Sun Jun 30, 2013 10:25 am

Blacksmith bod tracker tool

Post by Opopanax »

Hi everyone,

I've previously made a tailoring BOD tracking tool and have converted it into a blacksmith bod tracker now.

You can find it at the link here: https://docs.google.com/spreadsheets/d/ ... sp=sharing

Anyone can save the google sheet to their own account by clicking "File" and then "make a copy".

There are sepearte sheets for each material, and all you need to do is enter the quantities into columns M,N,O and P,Q,R. It will put the numbers automatically into the correct LBOD cells. If you have all the small BODs but not the large BOD, it will highlight the LBOD cell yellow, so you know which one you're missing. If you have the LBOD, but not all the small BODs, it will highlight them red. If you have all the smalls and the large it will highlight them all green.

You can also check the reward for any BOD, just go to the material page and put the details into cells E17, E18 and E19, BOD type can be blank or 0 for calculating small bods and "Ring", "Chain" or "Plate" for the large BODs. The cells below show the score and potential rewards. As some BODs fall in between point tiers, it shows you the nearest 2 tiers, unless it's bang on and it will just show the same reward twice.

This is a tool that I've made for myself, but hopefully it might be useful to some other people out there :) If anyone has any comments or suggestions for improvment please let me know!
In game name: Abarai
Vranx
Apprentice Scribe
Reactions:
Posts: 10
Joined: Wed May 09, 2018 8:52 pm
Location: Tampa, Florida

Re: Blacksmith bod tracker tool

Post by Vranx »

This tracker tool is very interesting. Thanks for sharing.
In game: Yooden
Post Reply