Guides
Community created guides, helpful strategies, and more.
TOPIC | [TOOL] Comprehensive NOTN Item Tracker
1 2
With NotN coming up shortly, I was looking around to find a NotN tracker to use, but couldn't find any quite to my liking. So, I decided to make one myself! After several days and a lot of tears, the finished result is the Comprehensive NotN Item Tracker 1.0 1.2.1!

Basically, this sheet is a way to track NotN items, and keep track of how many you have and need. Beyond just that, however, it also keeps track of the costs of Marketplace NotN items, the items needed to brew Baldwin NotN items, and the items needed to trade for Swipp NotN items, along with having database links to all items and quite a few automated features to make using it easier!

ALSO: Note that due to this sheet being very recently created and also (due to how ready to be done with it I am) not very bug-tested, there may be some issues or glitches with the sheet. If you see anything that seems wrong or doesn't seem to be working as intended, please ping me @sedge122 in this thread with information about the issue and I'll try and fix it ASAP. :]

Another note, I will add this year's new NotN items as soon as I'm able to, but I'm sharing the sheet now since it's also helpful for preparing for NotN, not just tracking things during it! c:



Link to Sheet

To start using the sheet, just go to File > Make a Copy to create your own editable version of it! There are more instructions on how to use the sheet itself in the 'main' tab of the sheet.

The link above is for the "Dark Mode" version of the sheet, which is the way it was created originally; however, I also made a "Light Mode" version if anyone prefers that. Light Mode version link. Just be aware that due to me not having the time to extensively bug-test right now, there may be discrepancies between the sheets: again, if you see anything that seems wrong please ping me in this thread! c:



CHANGELOG:
23/12/2022 - Tiny bug fix (wrong brew time listed for Vista: Strange Chest) (Version 1.2.1)

18/12/2022 - Added all newly released items to the sheet! (Version 1.2)
- Updated light mode with all new items (only dark mode was up-to-date previously)

15/12/2022 - Actually fixed that issue this time, and some QOL changes! (Version 1.1.1)

14/12/2022 - Finished working on the sheet for now, created this thread (Version 1.0)
- Found a bug and fixed it... sort of... (Version 1.1)
With NotN coming up shortly, I was looking around to find a NotN tracker to use, but couldn't find any quite to my liking. So, I decided to make one myself! After several days and a lot of tears, the finished result is the Comprehensive NotN Item Tracker 1.0 1.2.1!

Basically, this sheet is a way to track NotN items, and keep track of how many you have and need. Beyond just that, however, it also keeps track of the costs of Marketplace NotN items, the items needed to brew Baldwin NotN items, and the items needed to trade for Swipp NotN items, along with having database links to all items and quite a few automated features to make using it easier!

ALSO: Note that due to this sheet being very recently created and also (due to how ready to be done with it I am) not very bug-tested, there may be some issues or glitches with the sheet. If you see anything that seems wrong or doesn't seem to be working as intended, please ping me @sedge122 in this thread with information about the issue and I'll try and fix it ASAP. :]

Another note, I will add this year's new NotN items as soon as I'm able to, but I'm sharing the sheet now since it's also helpful for preparing for NotN, not just tracking things during it! c:



Link to Sheet

To start using the sheet, just go to File > Make a Copy to create your own editable version of it! There are more instructions on how to use the sheet itself in the 'main' tab of the sheet.

The link above is for the "Dark Mode" version of the sheet, which is the way it was created originally; however, I also made a "Light Mode" version if anyone prefers that. Light Mode version link. Just be aware that due to me not having the time to extensively bug-test right now, there may be discrepancies between the sheets: again, if you see anything that seems wrong please ping me in this thread! c:



CHANGELOG:
23/12/2022 - Tiny bug fix (wrong brew time listed for Vista: Strange Chest) (Version 1.2.1)

18/12/2022 - Added all newly released items to the sheet! (Version 1.2)
- Updated light mode with all new items (only dark mode was up-to-date previously)

15/12/2022 - Actually fixed that issue this time, and some QOL changes! (Version 1.1.1)

14/12/2022 - Finished working on the sheet for now, created this thread (Version 1.0)
- Found a bug and fixed it... sort of... (Version 1.1)
Sedge | they/them | avatar dragon | wishlist
I don't mind pings, even if I'm subscribed :]
x6IT4JO.png
UPDATE - Version 1.1
While using my personal version of the sheet I discovered that I hadn't taken into account the fact that 2 glass beaker/reinforced glass beaker are made for every one use of the recipe, so I changed the 'N#' and 'I#' for them to be half of the actual needed/ideal numbers rounded up. Then I realized that that does unfortunately mean that the N# and I# numbers for the glass beakers and reinforced beakers are not exact, but there's nothing I can think of that could solve that issue for now. (I tried making it so the N# and I# numbers for the ingredients only were halved, but that was annoyingly complex.)

So, for now, the glass beaker and reinforced glass beaker needed numbers are half of the actual needed number rounded up, and so aren't exact, but I don't have the time or energy to try and fix that problem rn. :']
UPDATE - Version 1.1
While using my personal version of the sheet I discovered that I hadn't taken into account the fact that 2 glass beaker/reinforced glass beaker are made for every one use of the recipe, so I changed the 'N#' and 'I#' for them to be half of the actual needed/ideal numbers rounded up. Then I realized that that does unfortunately mean that the N# and I# numbers for the glass beakers and reinforced beakers are not exact, but there's nothing I can think of that could solve that issue for now. (I tried making it so the N# and I# numbers for the ingredients only were halved, but that was annoyingly complex.)

So, for now, the glass beaker and reinforced glass beaker needed numbers are half of the actual needed number rounded up, and so aren't exact, but I don't have the time or energy to try and fix that problem rn. :']
Sedge | they/them | avatar dragon | wishlist
I don't mind pings, even if I'm subscribed :]
x6IT4JO.png
@sedge122
Neat!

Silly question: what are O# N# I#? Owned, Needed...?
@sedge122
Neat!

Silly question: what are O# N# I#? Owned, Needed...?
deseczka2.pngaxolotl_100.pngw8o0xW1.pngWpBgddH.pngKeikoKat.png
@beBlueberry

They stand for owned amount, needed amount, and ideal amount respectively, with ideal amount being how many of that item you would like to get, but don't necessarily have to get! :] It's mentioned in the Main tab of the sheet but is very easy to overlook, so don't worry, not a silly question! c:

Also - I'm currently in the process of editing the sheet to add some quick improvements, so if you've made a copy of the sheet already, you'll need to make a new copy after I've made these changes for them to actually take effect - when I actually finish adding them that is, since I'm still in the process of doing so (it should be quite quick though)! I can ping you when it's all updated if you'd like, so you can make a new copy! c:
@beBlueberry

They stand for owned amount, needed amount, and ideal amount respectively, with ideal amount being how many of that item you would like to get, but don't necessarily have to get! :] It's mentioned in the Main tab of the sheet but is very easy to overlook, so don't worry, not a silly question! c:

Also - I'm currently in the process of editing the sheet to add some quick improvements, so if you've made a copy of the sheet already, you'll need to make a new copy after I've made these changes for them to actually take effect - when I actually finish adding them that is, since I'm still in the process of doing so (it should be quite quick though)! I can ping you when it's all updated if you'd like, so you can make a new copy! c:
Sedge | they/them | avatar dragon | wishlist
I don't mind pings, even if I'm subscribed :]
x6IT4JO.png
(another) UPDATE - Version 1.1.1
I figured out a solution to the glass beaker/reinforced glass beaker issue (just have two separate cells for total needed amount, vs amount of times to make the recipe itself) and also added highlights based on number of O# vs N#/I# to more cells (by highlights, I mean that cells will be highlighted red if you have less Owned then Needed, or orange if you have less Owned then Ideal), so this is Version 1.1...1. x'D

Hopefully, I won't need to fiddle with this sheet more until it's time to actually add whatever new NotN items are released this year! c: (I am so ready to be done with this sheet...)

@beBlueberry - I'm so so sorry for the ping especially as I already pinged you earlier,,, but I just wanted to notify you of this update to the sheet, since if you've already made a copy of the sheet you'll unfortunately have to make a new copy to actually get the new features. Sorry for the trouble! :']
(another) UPDATE - Version 1.1.1
I figured out a solution to the glass beaker/reinforced glass beaker issue (just have two separate cells for total needed amount, vs amount of times to make the recipe itself) and also added highlights based on number of O# vs N#/I# to more cells (by highlights, I mean that cells will be highlighted red if you have less Owned then Needed, or orange if you have less Owned then Ideal), so this is Version 1.1...1. x'D

Hopefully, I won't need to fiddle with this sheet more until it's time to actually add whatever new NotN items are released this year! c: (I am so ready to be done with this sheet...)

@beBlueberry - I'm so so sorry for the ping especially as I already pinged you earlier,,, but I just wanted to notify you of this update to the sheet, since if you've already made a copy of the sheet you'll unfortunately have to make a new copy to actually get the new features. Sorry for the trouble! :']
Sedge | they/them | avatar dragon | wishlist
I don't mind pings, even if I'm subscribed :]
x6IT4JO.png
Oh this is great! Could I get a ping once you’ve added this year’s items please?
Oh this is great! Could I get a ping once you’ve added this year’s items please?
______
((They/Them)) ((Ve/Vir))
CIZA4AC.png
^ Agree! This would be super cool, I'd love a ping.
^ Agree! This would be super cool, I'd love a ping.
Sun| he/him
BPco0tZ.png nb5YUNX.png HQsa6bD.png +1 FR

FObX7rS.png
R1dejfm.png
unknown.png
Is there any easy way, from this tool, to calculate how many of each thing you would need to create one of every item?

like... in order to brew every notn item you need x green goo, x yellow good, x beakers... etc?

I'm not very good at this spreadsheet stuff ^^;
Is there any easy way, from this tool, to calculate how many of each thing you would need to create one of every item?

like... in order to brew every notn item you need x green goo, x yellow good, x beakers... etc?

I'm not very good at this spreadsheet stuff ^^;
WGmBNXJ.png Tiefling Treasures: Lore-Based Hatchery & Rescuexxxxxxxxxxxxxxxxxxx
WGmBNXJ.png Hatchery Masterlist
WGmBNXJ.png Seeking & Sales
WGmBNXJ.png Wishlist
shadow.gif
@SleepyTiefling

Yep, there is a way - the Baldwin Materials, Misc Needed Items, and Main tabs of the sheet should all automatically update based on how many NotN items are set as N# (needed) or I# (ideal) elsewhere in the sheet. For example, if you have N# for a 50,000 treasure MP item set to 1, then in the Main tab the amount of treasure you need will be set to 50,000, and if you have N# of a Baldwin item that requires 2 green goo set to 1, then in the Baldwin Materials tab the amount of green goo you need should be set to 2.

So, if you would ideally like to get at least 1 of, say, every baldwin item, you could go to the Baldwin Items tab and set I# (the first I#, with the orange header) to 1 for all of the items. Then, the Baldwin Materials/Misc Needed Items tabs, along with the treasure/minutes counters in the Main tab, should automatically update with how many of each item you need in total. You could also set the first I# in the tabs MP Items/Swipp Items to be 1 for all the items as well, if you wanted, to also calculate the resources needed for getting all of those items.

I hope I explained that clearly enough, I'm bad at explaining stuff aaa. I hope that helps, but let me know if I need to try and explain it better! :']
@SleepyTiefling

Yep, there is a way - the Baldwin Materials, Misc Needed Items, and Main tabs of the sheet should all automatically update based on how many NotN items are set as N# (needed) or I# (ideal) elsewhere in the sheet. For example, if you have N# for a 50,000 treasure MP item set to 1, then in the Main tab the amount of treasure you need will be set to 50,000, and if you have N# of a Baldwin item that requires 2 green goo set to 1, then in the Baldwin Materials tab the amount of green goo you need should be set to 2.

So, if you would ideally like to get at least 1 of, say, every baldwin item, you could go to the Baldwin Items tab and set I# (the first I#, with the orange header) to 1 for all of the items. Then, the Baldwin Materials/Misc Needed Items tabs, along with the treasure/minutes counters in the Main tab, should automatically update with how many of each item you need in total. You could also set the first I# in the tabs MP Items/Swipp Items to be 1 for all the items as well, if you wanted, to also calculate the resources needed for getting all of those items.

I hope I explained that clearly enough, I'm bad at explaining stuff aaa. I hope that helps, but let me know if I need to try and explain it better! :']
Sedge | they/them | avatar dragon | wishlist
I don't mind pings, even if I'm subscribed :]
x6IT4JO.png
this is SO useful for planning, thanks for sharing it - would love to be added to an update pinglist when the new recipes come out please!
this is SO useful for planning, thanks for sharing it - would love to be added to an update pinglist when the new recipes come out please!
HW4lpxl.png
1 2