Excelsior

Hi everyone,

I recently embarked upon making a BOD tracker for myself in google sheets to try and keep track of all my tailoring bods. I have now completed the first version and would like to share it with anyone in case it is useful.

**V2 - updated June 2018 (see notes in later post)
https://docs.google.com/spreadsheets/d/ ... 1879399248

To be able to make use of this you will need a google account as this version is view only. If you click file and then make a copy (make sure popups are enabled) you will get another tab that opens with an editable version for yourself that will be saved on your google drive.

There is a tab for each material and columns A-J show you large bod info and M - R show small bod info. You only need to enter numbers into columns M-R, it will populate the large bod info itself. I made the small bod lists as I find it much easier to add stuff when the list is in alphabetical order. In columns B and C you can add if you own the large bod for that type. There is formatting that shows up when some of the fields are full:

1. If you have the large bod but not all the smalls it will highlight the smalls needed in red
2. If you have all the bods needed, all the cells show in green
3. If you have all the smalls but no large it will highlight the large needed in yellow

One quirk with entering footwear items is that this must be done on the leather page and it pulls through automatically to the cloth bod page. There is a formula in those cells in the cloth bod, so dont change it otherwise it won't update your footwear in the cloth bods

The cloth bod page doesn't do the red green thing as I ran out of patience at that point, but it does still do yellow and green.

I hope it's useful to someone besides me! If anyone has any ideas or feedback on how to improve it please let me know, I may do, but it depends how much time I have and if I have an idea on how to make any improvements suggested!

Finally - remember, only enter info into columns M-R and B and C on each sheet!

Thank you Abarai for your time and effort. I will certainly make use of this.

No problem, hope it's useful!

This is great! Thanks for sharing!

Sorry to necro bump this, but I've made an update.

You can access the new version via the link below and add it to your google sheets as shown in the first post

https://docs.google.com/spreadsheets/d/ ... 1879399248

I've finished off the conditional formatting completely now, including the cloth bods.

I've also added a little tool the the bottom of each table so you can see what the reward is depending on the bod you fill in. The one on each page take into consideration the material for that page. Bod size can either be 0 (for s bods) 4,5 or 6, exceptional needs to be y or n, amount is the number of items in that bod. It will then work out the score and the tier and pull the info into the cells beneath automatically. If it is between tiers, it will give you the ones above and below.

Just for interest there is also a distribution page at the end that shows you the distribution of the bods you hold by material type.

Any questions or comments or bugs you spot, just let me know.