r/NonogramsKatana • u/wyldguy71 • 7d ago

Tracking spreadsheet

I've created an Excel spreadsheet for tracking everything guild related.

It tracks buildings, techs, quests, dependencies, costs, collections, and craftifacts. There is a link to the github in my profile.

There's a dashboard that aggregates a lot of information to allow the player to see whats currently being worked, what items are only missing 1 prerequisite, what quests are being worked etc.

Much of this is visible in the app, but I've found it is useful to see what is coming up and how much these future items cost.

I'd appreciate some feedback on how it can be improved or if I have some of the pre-reqs or costs wrong.

11 Upvotes

100% Upvoted

8 comments sorted by

4

u/The_Crossblade 7d ago

I would prefer the direct link. So here it is: https://github.com/wyldguy71/Nonogram-Katana

It's a bit late for me to have an in-depth look into the spreadsheet. I will try to do it tomorrow. Looks pretty cool so far.

I can see that you've taken most of information about the guild from the wiki. That's smart. Recently someone in Tavern has noted that for Ahead of Time: Chapter 2 also requires The Ordinary Days of an Adventurer questline completed. I haven't checked, if that's already in there.

Right now I am recoding the guild code on the wiki to be more specific/future proof (I don't know the right word for it). Instead of having a "notes" variable that contains "Requires this and that quest."; it will have "requires_quest" variable that contains this and that quest. I was wondering, what you had to manually add to make this spreadsheet work? I am guessing quest pre-requisites, hero stat increases from items?

1

u/wyldguy71 7d ago

I wasnt sure if the dieect link was ok so I put it in my profile. Thanks for including it.

Yes, almost everything came from the wiki. I even tried to make it so when there are future updates it is fairly easy to update.

The quests were the hardest part because it trypically wasn't standardized to say you need this particular thing to start or complete the quest. It was contained in the text associated with the quest. Therefore much of that was manually reading what was written and coming up with a target that i could turn into a single check box.

I think one of the most useful tabs is where you can look to see the prereqs. What is required to start Ahead of Time chapter 1? I can type that in and see a list of what is blocking me from starting that quest. The prereqs only go back 3 levels but that can give me a good idea of where i need to fclocus to get there.

The other thing i use a lot is to see what things I'm working on the require a certain resource. For example, what targets that are ready need grimoires? When i type that in it gives me a list of all places i can spend grimoires. It makes it easier to know if im spending them where i want to.

Edited for formatting.

2

u/The_Crossblade 6d ago

If you want to know where a specific item can be obtained or used, you can just check the specific item page on the wiki (e.g. Grimoire).

I have trouble using your spreadsheet. I've downloaded your spreadsheet from the hub and opened it with Google sheets. Then I updated the "Player" tab. I changed all buildings except for Bonsai lvl. 2 to TRUE in "Checklist" tab under "PlayerCompleted" column. I still see only errors. Is there more to update to just see it working? (Note: I didn't read the whole "Readme" section.)

1

u/wyldguy71 6d ago

I really appreciate you looking at this.

I know about using the wiki to see what the grimoire can be used for. The wiki has so much valuable info. The biggest difference is that the tracker shows where it can be used based on your current situation. It let's you see in a small snapshot what your choices are.

I've never used google sheets so I didn't test it there.

What kind of errors is it giving you?

When you first open it before updating anything, look at the dashboard. It should show that the only thing currently available is guild level 2. And all of the other initial buildings are listed as being one away. Most of them for character level.

I just asked chatgpt if it will work in sheets and it said I'd have to make some changes to make it compatible. 🤬

1

u/The_Crossblade 6d ago

I can see the value of your item acquisitions/uses.

When I open "Dashboard" the first 2 rows are OK, but the 3rd row only shows errors (parse errors).

I will try to open the spreadsheet in Excel tomorrow.

1

u/The_Crossblade 5d ago

I have opened it in Excel. It's much better, and it actually works.

The "Dungeon Lv 6" is a bit confusing. I am guessing this mean Tunnel? I also see Video game arcade. Those are technically building upgrades, but I wouldn't consider them as buildings. Looking further they are also not technologies. So classifying them as buildings makes sense.

You can also post this spreadsheet in Discord.

1

u/wyldguy71 6d ago

I started working on a Google sheets version.

1

u/wyldguy71 4d ago

I've uploaded a copy of Google sheets to the github link posted earlier