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!
