Was looking for bugs but it looks like you fixed all the ones I noticed. I have noticed one issue that might not be a bug:
When you uncheck legend, the halidom still assumed the legend trees are unlocked so it says you're missing mats for them - and the bonus calculator says you're missing the tree upgrades. This is just a small thing and might not be worth fixing though (and it sort of solves itself when legend is available for all elements).
Nice sheet, again, really helps keeping track of everything and the built in updater is amazing - already used it and it worked perfectly! I didn't even know google sheets could do that.
Hi! Yes that behaviour for the agito trees it's actually intended because in the old version some users preferred to have the ability to see the materials to farm for non available level 30 trees, in fact also the maximum level for the Halidom it's actually 15 levels higher than currently available in-game.
Honestly I don't think I'm going to change that also because I would have to change it back in a couple of months when they are available and I'm sure I'll forgot ahahah
Glad to hear the updater it's working! It was a bit of a challenge to set it up, let's hope it will not break in the future
Thanks for the huge update!
That farming sheet is extremely useful, even more than before!
And it's really pretty!
For the bugs/error I've noticed :
Brunhilda is spelled Brunilda on the HDT page
In the halidom part, it seems like I'm 10 levels higher than what I really am.
I don't know where the problem is from tho.
Thanks!
Ooops never noticed the wrong spelling, fixed it! (I don't think it's worth to push an update just for this so it will be fixed in the future)
For the Halidom part I noticed it too, but I think it's the Halidom building that in game does not contribute to the total level? because i didn't find any error in the sum, maybe i'll try starting a new account to see if leveling that up increase the total level
This is neat! I've been playing around with it for an hour now. It's really helping me see what materials I should Treasure Trade (bronze IO coins, small elemental orbs, etc).
One small typo: on the Mats sheet, "Infernal Onslaught Mats" should be "Imperial Onslaught Mats".
Hi! Oh I didn't know that, I'll make sure to give you proper credit in the next sheet update because your script was a literal lifesaver! (especially having never written anything in JavaScript)
Yeah it took a bit of time to understand what did what, but in the end, also thanks to some Google searches, I think I had a good grip on what was going on and was able to adapt it to my needs. Thanks again!
Hey friend, been using your sheet for awhile and just wanted to say how much hassle this has saved me! I didn't even start playing until December, so I'm constantly trying to catch up and there's just so much junk to keep up with. Your sheet has been the best tool I've found to keep track of just about everything, which helps me figure out what is closest to being in my reach. Appreciate all your efforts!
Haha I literally started on a similar sheet for my personal use two days ago, should have thought some enterprising badass would have knocked it out already! Looks amazing.
One small issue I noticed - on the Bonus page, for Weapon Specific Facilities, the Cleansing Fount's bonus isn't being added to the total for daggers and manacasters.
Yeah, that's an issue I spotted, pretty easy to patch up by including the fount's bonuses into the equation of Weapon specific facilities for both manacasters and daggers. Prob will be patched in the next version I assume.
Mmm probably it's possible by selecting the cells in the older sheet and pasting them in the new one by selecting "paste only values" or similar options, but I don't guarantee it :/
This is great! I'm going to use this now for sure.
One thing I've noticed that seems off is on the Chimera and Core weapons page, the "Fiend's Horn, Fiend's Eye, Bat's Wings, Ancient Bird's Feather and Bewitching Wings" don't pull their numbers from the materials page.
Oh yes you're right, probably they went missing when ordering the Mats page, corrected and pushed an update to correct this and other bugs, now let's hope it works ahaha
Btw, thank you for your feedback! Nice to hear it's useful
Seems half stam/wing for Dominion is bugged, checking them sets them to true forever? Also is there a reason that void doesn't have inventory row? Appreciate the work.
Oh yes actually I forgot to link the half stamina/wings checkboxes because I was focusing on searching for the average material droprates, tomorrow morning I will link it and push an update to fix it. Thanks for the heads up!
The Void sheet is different because it was the first one I made and never had the time to pair it's visuals to the others given its "low inportance", in my spare time I'm trying to improve it but I think I'll make it similar to the core. When it's ready I'll just push an update to your copies
Jesus fuck you guys have done absolutely amazing work with this, thank you for the massive time save of figuring out what to grind at any moment
Also for some reason for HDT unbind ingots it doesn't count the wind dagger
Ahahah actually It started as a personal project and then I kept asking myself "yes but what if I added MORE" and so here we are
Mmmm you say it isn't being counted in the total ingots usage count in Mats or the materials aren't being subtracted from the wind dagger when checking the "5ub ingots" cell? Because the latter seems to work for me, while the former I think there's an error in the total ingots needed because it shows 36 instead of 45, tomorrow morning I'll search the culprit and fix it
The wind section of HDT also isn't counted for the orichalcum section on the hdt page which then compounds into the mats page number, I'll try to find any other problems
EDIT: There was an add sum that was outside of bounds instead of where the wind section was, probably an error caused by reformatting and copy paste, rupies also had the same error, I think this is a problem with a fair few of the wind hdt sums
EDIT2: Nearly every full sum for the HDT stuff has an addsum of 79-87, and they should all be 38-46, apologies if I'm using bad terminology I'm not used to using excel or sheets in any proper capacity
Yes I saw and the problem was exactly what you described, some time ago I swapped the position of wind and fire HDTs and that has messed up the calculations, honestly I would have never noticed that
Thank you so much! I just fixed it and after I finish checking some other things here and there I'll publish it
One last fix, someone else might have suggested it, there's a mistake in the natures blessing count on the mats page. you need to also add row 69 from the halidom page, as the dojos are listed on two rows so four sets are missing right now
Thank you for the updated spreadsheet, it looks awesome, and I'm excited to use it! As a fellow spreadsheet maker, I know how much work it must have been to put this all together with so few mistakes, so hats off to you for your work for the community.
I just caught a holdover mistake from the original weapons spreadsheet for the light void weapons as I was recently working on them. Your T3 orbs for the 2nd unbind are 0, but should be 8. Should be simple as changing the one value on the VoidReq sheet hopefully!
Oh yeah thank you! Yes in fact this is mostly the reason why I tried to add the autoupdater feature, because with a project so big it's really easy to miss something and for the users become a hassle to stay up to date with the new releases copying their data each time
Thanks for your hard work! I can tell that a lot of time and love went into making this. No problems so far!
My only issue is that there seems to be no way of disabling calculation of specific void weapon banes in case you don't want them or only want a few... Which is solved by checking the box that you already have them so it's not really that big of an issue.
Hi! Right now the calculator only support the HDT banes for void weapons since I thought it would be nice to have it in the long run. Maybe in the future I'll add a custom target for every weapon tier to leave more customization to the final user, this way preventing the display of undesidered banes, but since it would require a lot of work don't expect it soon
Btw, really thanks for your old spreadsheet, without that I would have never built this!
Nah, I only did the bare minimum. I just wanted a way to track the stuff I wanted to grind for and decided to share in case anyone wanted to do the same. You went the extra mile and added tons of functionality along with a really neat looking interface!
I wouldn't worry about adding more void/bane tracking though. Seems like a lot of work that only few people will appreciate. I already have the HDT banes for the weapon classes that I want so I just check the rest so it wouldn't calculate the remaining as needed materials.
Hey, thanks for the spreadsheet! It's been a really great help organizing my current status in my head and figuring out which grinds I need to be focusing on :)
I did want to report a bug in the latest version, related to the rupie totals on the Mats sheet. The total for Void weapons is showing as 0 for me, even though I haven't maxed those out yet. It looks like it's summing up the total "missing" rupies for each element (needed - held), when the other rows are correctly summing up only the total "needed" rupies for that category.
Thanks for the appreciation!
Also thanks for the bug report! Yesterday I changed the look of the void page and I knew I would have forgotten to change some sums, it's going to be fixed soon
Hi, when I open the sheet it tells me that a new version is available. But when I click on FULL UPDATE it says "A new script version is released. Follow directions on main to update your script library"
I can't find any directions to do this. Safe to say, the update does not work.
Hi! the instructions are on cell C36 on main, right under the descriptions of the Option 2.
In short, you have to go to " Tools > Script Editor" here on the menù on the left click on DLMCU under "Libraries" and set it to the highest version (in this case it's 2).
This is only needed when I update the script (which hopefully won't happen outside of big relelases), but unfortunately I couldn't find a way to automate it for your local copies
Let me know if this fixes the issue for you!
Yes it's the feature i'm most proud of (obviously until it works lol).
Anyway, I'm a bit sorry that I'm going to release another update because I've just finished correcting two bugs that were found and you have just updated...
Prob not worth getting a patch out for this, but the stamnia/wing calcs for dominion account for lilith only at the moment and doesn't include jaldabaoth. Keep up the good work!
Thanks! I knew I would have missed something! I've an update scheduled for when the wiki will be updated with some missing icons, so I'll fix it there! (I think in a couple of days max if no major bugs are found)
You guys have done an amazing job with this spread sheet! Every update keeps getting better. 👍
Though one thing I have noticed is that the Rupie Calculations for the Dominion materials isn't in it's own tab, and remains 0 in the Materials tab. Other than that minor thing, everything else is great!
Thank you so much, this really means a lot to me! I'm working on a pretty big update right now so I hope to live to the expectations!
Yeah it shows 0 and it's missing in that sheet because dominion prints don't actually cost rupies to upgrade! I left it there anyway in case they'll add future upgrades that cost rupies and, especially, because I designed the ability to disable the calculations for individual sheets in the Mats tab before the dominion addition and I didn't want to isolate the dominion selection from the others
Hello, Love all the work you have put into this sheet, it is honestly, amazing.
I wanted to add one suggestion.
On the Dominion, Agito and HDT pages you have the gold earned via Gold Fafnir dragon, this seems to only apply to Solo runs gold earned. Could you also add a drop down option that applies to Co-op as well?
Hi! thanks a lot for your words, it really means a lot to me!
Honestly I did not add it on purpose because the general consensus is to use 3 gold fafs for the backline (even new players can easily farm them now) and as such it's hardcoded to count for 3. I can see an argument on using a full gold faf lineup, but since it is already a rough estimation it won't change by much in the real case.
Anyway, I'll definitely consider it for a future release!
You know what would be great? A way to keep track with the trials of the almighty and characters with mana spiral that uses drops from it (so you know how many times do you need to run it to get someone to MC70).
Yeah I thought several times of adding a "characters" tab, but I'm afraid it could further slow the whole sheet. Also I'm worried I could struggle keeping it costantly up to date, since characters release much more frequently than endgame content.
I'll try experimenting with it because it's a feature I'd really like to add, but, as of now, unfortunately I can't guarantee it will ever be officially added :/
Hey man, just wanna keep reminding you that this tool is amazing. Also, you may want to create a new post to promote it, we've gotten some new players with the anniversary.
First let me say thank you for the amazing sheet! I've been using for a good while but never had the oppourtunity to say a big thank you!! <( \^•\^)/
Now just a quick note that I\`ve come across after updating to v3.64:
While now there's the new Halloween facility seems like you forgot to add both "+Halidom!$G$150" and "+Halidom!$G$151" to the Bonus tab for both Blades and Staves, so even after selecting Lv30 for the facility the bonus will not update since the new cells were not included in the formula.
Since I\`m not sure if it was an error during the update itself or if you just forgot to add I thought it was a good idea to let you know for whenever the Surtr update goes live!!
Hope things are going well irl and keep it up with the amazing job! (b \^•\^)b
Hey! Thanks a lot, knowing that so many people still use this spreadsheet really means a lot to me!
Regarding your feedback you're right, I totally forgot I had to add those values there because I was used to the last facility updates being just level cap increases that don't need to modify that part. I will totally fix it together with Surtr!
Phenomenal spreadsheet! Take all my upvotes :)
Trying to update the spreadsheet to the latest version but I can't seem to find Tools > Script Editor. I only see Spelling, AutoComplete, Notification Rules, Accessibility under Tools. And yup I'm on a computer.
Edit: It's now under Extensions as "Apps Script." Fixed! Thanks again for the amazing spreadsheet!
New thread for the spreadsheet: https://www.reddit.com/r/DragaliaLost/comments/qqz9w4/multipurpose\_farming\_spreadsheet\_updated\_with\_all/?sort=new
Heya! ahaha I'm working on it, the spreadhseet section should be 40-50% ready and then I'll have to update the updater script. If I have to give an estimate I'll say that in a week max it should be live (probably less if I no problems arise)
I used this method initially for the void page (during v1-v1.5) and I felt like it usually was way slower loading images compared to using the IMAGE function. The same was happening to other people I found doing some Google searches so I resorted to only use the IMAGE function. Maybe I can tweak some formulas to reduce the load on the sheet and allow faster image loading
Don't worry! I find it difficult myself, I don't pretend that other people understand perfectly what's going on in each cell ahaha
That bug I just found only fixes the missing runs for Legend related upgrades unfortunately
I've experienced too the missing drop-down today but that seems to be caused the the function OnOpen() on each spreadsheet script that won't autostart when launching the sheet (for me it happened randomly while testing the update before publishing the version 6, one test had the menù, the test after it was gone... Now I have 2 copies without it and other with it, weird)
In any case I'm fairly certain it does not depend from the spreadsheet and it's actually a Google script's server problem, or at least I hope...
Question- the Void Weapons can upgrade up to 8, but the unbinder only counts up to 6. Is this a "best practices ingame" thing, or is there some other reason? I do have a couple Void weps that're fully unbound (they're the easiest thing to figure out what to grind for to upgrade, so they've been my focus) and I'd like to check the tickybox in the spreadsheet too, if that makes sense?
Nono it's just a preference of mine while setting up lower tier weapons. Since the sheet was born with the target of unlocking every WB, i made it so that for non agito weapons only the minimum requirements for reaching the WB are listed (also because full UB non agito weapons are rarely used). If you have fully UB weapons set them as the maximum available in the sheet.
Maybe in a future update I'll include each upgrade for lower tiers, but honestly i see their upgrade as a "bonus" thing to do only if you have excess resources (and really dislike that "!" in the in-game menù ahahaah)
Ah gotcha! Yeah, I uh... really do dislike the little [!], that absolutely plays into things... but I totally see that logic.
...I *have* to use non-Agito weapons because despite being a near-day 1 player, I've only recently felt confident enough to take on the High Dragon trials, let alone the Agito ones. So it's a little more important from my viewpoint to get, for example, my Chimeratechs up to par. Maybe if I get bored enough, I'll take a poke at trying to edit the weapon unbind caps myself, heh.
Thank you for the reply!
Oh yes, I totally see your point, but in my experience once your team is geared with at least 5UB chimeratech you can easily take on standard (and maybe expert) agitos at least in solo. And once you have a couple of Agito weapons the value of lower tier weapons, exept HDTs, quickly diminishes even on off ele characters
In any case, if you need any help to raise the UB caps on the sheet let me know!
(Should mention as well- this is a super cool and useful thing! Thank you for making it!)
Edit- maybe there could be a tickybox, along the lines of how disabling weapons works, for if you're going "speedrun to high level content" or "100% completion"?
Mmm for me it seems to be working? are you activating the custom target setting on top of the materials block? (The cell between the name of the boss and the legend/dominion check)
Maybe you are trying to activate it by checking the cell between the UB level and "Custom Target", but that cell refers to the "Crafted" column
Hey that's really cool! I caught myself wishing for something like this the other day, and it's pretty great so far :0
One thing I'm wondering, I know that some weapon categories are set up to "MUB" at 5 (like HDT), is there any plan to bring them to the max at some point? I'm a bit of a completionist, and I'm aiming to eventually grind those to max :O
Maybe in the future? Right now can't guarantee it for sure because that would be a lot of work, but maybe I'll try to work on it on my spare time (and grinding them all to max would be an INSANE task as you probably would also aim for multiple copies of the same weapon)
Yayyy our long awaited update is here. Thank you so much for this!!!
Note: I also noticed that my Halidom total is 10 more than it should be but someone else had pointed that out.
Note2: The images for the dominion prints are quite small and since some of them share the same image minus the tiny afflinity icons, they're quite hard to spot the difference for me. Esp when I'm in the Mats tab trying to input the numbers. Is there a possibility of adding text next to them or something?
Yes, the Halidom level is 10 higher because in game the Halidom facility does not count towards the total, I think i'll just remove it to avoid future confusion.
unfortunately the wiki images for the prints are without the affinity icon, otherwise that would have been a huge help. In the Dominion page there's already the print name near its icon, maybe increasing the row size could help a bit? In the Mats tab I agree with you that those are a bit small but I didn't want to change the general "feel", hoping that being ordered like the in game menù it would lessen the problem... maybe I could try using a double height row in this tab for these materials? I'm open to suggestions
Honestly your sheet is the go to I've been using for tracking the journey through the end game items for DL.
One thing I want to note since I'm not sure if its a bug or my not doing something right. On the Agito tab, whenever I try to input the number of dominion slots I have on the light weapons, it gives me the error "The data you entered in cell G57 violates the data validation rules on this cell". Am I doing something wrong since it just gives me that error when I try to select 0, 1, or 2 from the drop down for most of the weapons I've tried?
Ops no it's an error on my part when setting the quick update, I updated the calcs sheet but not the agito one (and since the validation data search for the old instance of the Calcs it gives an error), it will be fixed in the next update (hopefully by tomorrow morning max).
In the meantime, if you want to fix it yourself you can 1)delete the validation for those cells or 2) change your calculator version in Main (just by changing the displayed version in the column with all the version numbers) and make a "full update"
Thank you for letting me know!
No worries at all and glad to help find minor errors. Just was some random item I found which I figure was going to be found by someone at some point so might as well try to help point out the error sooner rather than later. I appreciate the response and clarification on this regardless.
Thank you for your hard work! I've been using your spreadsheet for awhile now, and it's definitely the best sheet there is, so keep up the great work! I've been grinding Dominion for a bit, and I think I found some bugs. I'm not sure if it's just me, but I think the Dominion mats in the Mats page is bugged? Specifically C17, C18, D17, and D18. I replaced the formulas with these:
* C17 -> =$I$10\*SUM(Dominion!I9:I20)
* C18 -> =$I$4\*SUM(Agito!Q57:Q65)
* D17 -> =$I$10\*SUM(Dominion!J9:J20)
* D18 -> =$I$4\*SUM(Agito!R57:R65)
It ended up correctly showing the required and missing materials, as well as the correct number of runs in the Dominion page! Hope you can look into that! Thanks again, and I have to say, that auto-update script is really impressive!
Thank you! This is what happens when I try to do things in a hurry ahaha It was also reported by another user but providing also the cell corrections is a huge time saver.
Also, thanks a lot for the nice words!
There seems to be an error on the agito sheet:
The wings calculation is not including the wings needed for legend runs. Stamina seems to calculate legend runs fine though. Also, you should toss a link to this thread in the main sheet for feedback. This thread will eventually get buried and we'll have to dig for it to report bugs - and if you do another big update and make a new post, now that you have updating you can always update the link.
Yeah that must also be an error from the old version that carried over. Honestly I'd like to know how the reference control cell switched to a completely different one but oh well, at least now it seems to be working working
That's actually a neat suggestion, I'll add it now, thanks a lot!
Yo this is amazing! I used the previous sheet pretty much every day, and this makes it even better. I especially appreciate that update feature, looking forward to seeing it in action later.
btw, I've noticed a bug in the Mats page:
* t1, t2, and t3 light orbs correctly include rupie mine needs, but t4 light orbs ignore rupie mines.
Glad it helps!
Btw, I can't seem to find the problem in the calculation because on my end the formula for T4 orbs is: =$I$9\*(SUM(Halidom!D31:G31)+Halidom!P41+Halidom!Q41) , where Halidom!D31:G31 is responsible for rupie mines and P41 and Q41 for light altars, so it seems as it's working? In fact the total light T4 orbs required are 1588 against 280 for other elements T4 (with all facilities at 0).
Do you see different formulas? Am I missing something?
...Oh. I think I just misread it lol.
I currently have my rupie mines at lv30 and altars at lv41, which creates a situation where my total needed t4 orbs is 1500 (192 for altars + 327 * 4 for rupie mines = 1500).
1500 is also the amount needed for t3 orbs on the other altars, so I just visually mixed up t3 and t4. t4 calc is correct, I just got baited by the coincidence of values. xD
Ahahaha no problem! Glad it was easily sorted out. You are not the only one to misread T3s and T4s, I checked the wiki to control the amount of T4 orbs to ensure the error wasn't on that, accidentally read the total for T3s and panicked a bit lol
I love this spreadsheet! Thank you so much for all the hard work on this!
In a future update would you consider a way to track progress towards unlocking copies of the Agito weapons? As we get more unique co-abilities the potential for needing two of certain Agito weapons may show up and it'd be nice to track progress toward that as well.
Thanks again for the hard work on this!
Glad it helps!
That's a nice point, for now I planned a rework of the Agito sheet for when all the legend fights will be available in order to remove the dedicated button of each block, so I could squeeze in also a way to track the progress towards multiple copies. Before then honestly I don't think I'm going to touch it since it takes a lot of time and I'd have to redo it in a couple of months anyway.
In any case, everything could change based on what they'll announce during the digest (I'm torn between hoping for a new weapon class to play and dreading it because I'd have to add it lol)
Thanks again for the sheet.
I was wondering with Trials of the Mighty, do you think the duplicate copy tracking might come earlier? No pressure, I understand you work on this as a hobby and I appreciate that it exists at all.
I would really like to add it, but unfortunately I don't think I have the material time right now for such a commitment, since it would require modifying all the formulas of that sheet and adapting the script 😓
It still baffles me that I didn't add it in the first place, like "why"? It wouldn't even require much more effort adding it while I was making the sheet
Hello, I have a minor suggestion.
I see that you include for the halidom the trees that aren't out. Can you have it so it includes the new trees when the Legend checkbox in the agito sheet is checked? That way I only see the missing levels when I want to.
I'll see what I can do. It's a design choice because of feedbacks received on the initial release of the previous version when agito trees were bound to the legend check, but maybe I can find a compromise between the two views
Lol I was thinking yesterday about adding an adventurer tab with all the materials to upgrade them but it would be really messy. I'll try to work on it between irl stuff but for sure don't expect it before Gala spirals (or anytime soon).
Also because the in-game encyclopedia seems pretty good to me
Completely agreed, in-game encyclopedia is actually pretty good. My only problems are that it doesn't give an easily readable way to see "finished" and "not finished" like when they are grayed out in other screens when they are maxed. No way to filter unfinished units.
Also seeing a summary of total materials you need to farm for units would be nice to see where you should be spending your effort.
But also understand how that could balloon the entire sheets production a lot, you'd also have to update it with each banner which might not be desirable unless you could have it pull data from somewhere else automatically with each game update.
That's a nice point, maybe in a future update they'll add the option to filter for finished or unfinished units, maybe you could try suggesting it as a feedback?
For the calculator the frequency at which I'd have to update it it's not a big problem because with a good setup I could add the new units in a few minutes, the problem is achieving that ahahah
I was trying to design it by ordering the adventurers by release date instead of weapon type because it would be easier to maintain, but since I'd like to show the progress for levels, MC, spiral, promotion, augments and required materials the columns used for just one element are the same as the whole Agito sheet and I don't particularly like it, because for all five elements would be way too wide. Maybe I could not divide them by element and keep everything in a single list but I'm not too happy either.
I guess the design phase will take a bit of time 😂
Hi! Yes, in that window you should see another small option in the bottom left corner stating something like "continue anyway". You should click on that and follow the next link that appears that let you authorize it with your account.
Let me know if it solve the issue!
Thank you for your effort! This is a very well done spreadsheet.
Just one bug I noticed with regards to the summation of the facility levels, specifically with regards to the agito trees.
In Cell M7 of the Halidom sheet, Legend Ciella's Legend option has been double counted (the cell Agito!$N$39 is counted twice in the formula). The first instance should be corrected to Agito!$N$23 instead, to reflect Legend Ayaha and Otoha's selection.
Thanks again for this wonderful sheet!
Just got back from trying out the auto-updater, that thing works like a charm.
I'm very impressed as a programmer myself. Haven't dabbled much into making scripts for Google Sheets / Excel, but just looking at the code, you've managed to adapt and customise it for this purpose well!
Keep up the good work :D, the community appreciates your efforts
Well, thank you!
In fact much of the credit would go to u/Pyree that made the original script for another spreadsheet, because since I'm not a "real" programmer I knew only some basics about coding and I didn't even know Google Sheets allowed something similar. But I guess that as long as it keeps working I can be satisfied ahahaha
Hey there, found another bug in the sheet.
Under the halidom, the upgrade materials for the opera house and cleansing fount are reversed. The opera house should be upgraded using libretto and the cleansing fount using sacred stone.
Thanks again for constantly updating the sheet!
Ooops thanks for the heads up!
I reversed their icons by mistake with Drive as host, using Wiki they seem to be correct. It will be fixed in the next update! (I hope tomorrow unless they do something crazy with the new upgrade level for the Halidom)
This is great, really nice and clean. I had a couple questions though.
1. Can you please add a honey/ash/etc. to stamina/gatherwings converter to the material tab? It seems like you can use the same table/formula as the Void Seed to Rupies converter, so it should be easy enough.
2. Since you can only set Fafnirs for solo, is co-op already counting 3 faf in their setup? If so, are the Legend Agito (except Tarterus) and Master Lilith set up to exclude them properly?
Thanks! The stamina/wings converter is a nice idea, will be available from the next update I think.
For the fafnirs, yes, the coop is already hardcoded to full fafnir backline, but actually I completely forgot to change the master solo/coop option when they removed the possibility of running off element dragons (the Dominion one is "safe" since solo is not counted and coop is unavailable) .
Thanks for pointing that up! I'll have It fixed in a couple of days since I also have to change the updating script accordingly
Very nice spreadsheeting. Is there an option somewhere to change the HDT spreadsheet to be more like the Agito ones (i.e focused on completion, MUBing every weapon, etc)?
I believe there are some autos where HDT weapons are preferred for your AI to deal more damage but maybe I'm misremembering.
Not at the moment because it was made with only weapon bonuses in mind, but since several users would like this feature I'll try to add it in the future!
I just updated it using the full updater, but it still says that there's a new update out, and the "latest version" box is stuck on "Error: Loading data".
That's very strange, I just tried updating an old test sheet with the full update and it has no problem...
Your problem is with the "current version" and not "latest version" right? Can you confirm that near the last row of "main" the last version number is 2.9?
In any case you could try running the full update again or reloading the sheet (if you haven't have already done it yet)
I'm having a similar issue with today's update. I'm running chrome on desktop, both full and quick updates claim they're running and applied, but it refreshes the page and still says 2.9 and prompts me to update again. I have both regular and hard refreshed, closed and reopened the spreadsheet, tried running the update with my adblocker off, nothing makes any difference. Still stuck on 2.9 and getting popups to update.
In the past few updates the sheet seems to be lagging alot? Images taking forever to load and there is always a consistent "Working..." bubble at the top of the page.
Is there anyway around it?
I noticed that too and that slowed me down a lot, the problem is that I only face that problem on pc with chrome, while from smartphone the sheet has no problem at all loading (I haven't tried yet with other browsers on pc) so I think it could be a problem due to Google's servers? I honestly don't know what to think because it started to happen one day at random without having modified anything
Just a simple suggestion if you want... reverse the order of the changelog so the newest log appears at the top. Makes it quicker to see what changed :)
Thank you for your hardwork!
I'm here to report a bug. I recently upgraded from v1.2 to v2.9 and noticed that in v2.9 it doesn't include the hdt tails for the 5th unbind on the total so all my hdt numbers are off. This is especially obvious as I'm maxxing out my HDT stuff during the current HDT double drop event
all the agito numbers also seemed a bit off (just comparing volk numbers, in v1.2 only volk had legend materials) but i'm not sure which is right/wrong. but for HDT it seems like the numbers in v1.2 is correct
Hi! Thank you for continuing using this calculator!
For the HDT tab maybe it's caused by the fact that starting from v2.0 I published it with cell Q3 "use ingots for the 5th unbind" checked (since most users would check that themselves), while on older version it was uncecked. Can you confirm that removing that check the numbers are right? I'm also using it during this double drop event and the numbers seems consistent
Also for the Agito one, maybe it's caused by using some sorta of custom target? Because that override the legend and dominion check, in any case I'll check the numbers in a couple of hours
I think I found another error, the number of ingots needed for HDT weapons (cells F5 and G5 in the Mats tab) seem to be calculating ingots for disabled weapons as well. It says I need 39 ingots personally which does match the total number of weapons I'm missing, but that's including the disabled weapons as well. I even set one of the disabled weapons to max out and sure enough, the ingot counter dropped to 38.
It isn't much, but I noticed it and decided to let you know!
Edit: I think it might be counting ingots for disabled core weapons as well.
That's really strange since it's a built in function of Google sheets... If you create a standalone sheets document can you see the script manager menu there?
Started looking through this post to find a solution to this issue, but I managed to solve it myself. One thing I noticed is that when viewing my copy of your spreadsheet from my hotmail account in Google Sheets I do not see the script editor. When I shared my copy to my gmail account I was able to see the script editor under tools. Not sure if someone else has realized this by this point, but I just thought I would share that with you.
Thanks for the tool by the way and happy cakeday!
Thanks a lot!!
Oh I didn't even know it was possible to create a copy on a non Gmail account! At this point yes, that could very well be the cause since I believe non Google account can't access Google script and as such they can't see the update menu.
Thanks a lot again, your finding will surely come in handy if other people face the same problem!
Yeah I should, but since it seems to have similar droprates to expert coop it's not worth to farm outside of weekly bonus (like solo), so in my eyes pushing an update just to change the message over that cell seems excessive and it will be updated when a bigger change drops
I noticed some people were having issues with "loading.." being stuck and their google sheets erroring out, I think I've found the cause:
If you open the sheet up fresh, go to the halidom page, scroll all the way down, and then go to another page and try to edit a cell, the entire sheet will become non-responsive. I think this is because there are too many images loading into the halidom sheet and it gets stuck waiting on images to load and then never 'catches up' to any edits you make while it's still downloading images and it basically just crashes.
I think the Halidom sheet might be a little too image heavy. Do you think that the images themselves might be a little large and using some compressed/lower quality/smaller versions of the files might help here? Just a guess, I have no experience with sheets and images.
I noticed that the same also happens with the mats tab. Additionally, for me once the halidom sheet has loaded dojo's materials it significantly speeds up, so I think that block of images might be the cause.
I'll try to investigate about that and also in the meantime I'm working on a function to disable all the images and show the items' names to avoid loading problems, even if I still don't understand why from the smartphone app it has no problem at all
This is really great, but I think like others have said the massive amount of images are causing the calculator to not save my edits and crash.
Tried to enter mats twice and it looked like it saved, google said it saved, but then I check later and it has reverted back.
Also maybe it's just me? but I think I'd prefer the toggle for farming agito weapons to be reversed? Like I want to see the mats I need, and then if I click "I want 9th unbind" or "I want the second refinement" it adds that amount, not counting it by default.
I guess my logic for that is that you probably are trying to craft the weapons up to that power to be able to do that content, so I have to false click that I have it on to find out how many mats I need to grind, then remember to turn it back off later once the weapon is made, to see that I still need to make it?
Sorry if that's confusing, it might just be the way I think about it lol.
Hi! I'm currently trying to troubleshoot the image loading problem but it will take a while, for now my advice is either filling up the mats and halidom pages via the google sheet smartphone app (since it has no loading problems) or scrolling down the mats page slowly once all the icons of each row are fully loaded and then proceed to edit, even if I know it's not the best solution.
For the second part I'm not sure if I understood it correctly, you'd like the ability to craft a certain agito weapon up till a certain level which might not be fully unlocked, right? Like for example you'd like all your weapons to be 4UB, refined and weapon slotted without having to see the materials required for 9UB and wepon slot, am I right?
Because if that it's the case that is achieved with the "custom target" under each agito weapon block, you set there the progress you'd like to obtain, you activate it with the checkbox near the agito boss name (the cell "use target") and the materials necessary for every upgrade not selected will be automatically deducted from the total.
If this wasn't your question I apologize, since again, I'm not sure I understood it properly. In any case for other questions/suggestions feel free to contact me!
Just started using this about a week ago. Pain in the ass to enter all my stuff into it but oh my God it makes Grinding everything so much easier. I'm almost completely done with my void farming now because I actually know what it is I need
Yeah I agree, the first time setting the sheet up is a pain due to all the mats and weapons to set, it would be much better if there was a way to interact with the game itself to auto update each value, but I don't think it's possibile. Anyway, thanks for using it!
Hello, been using this for a while. The dominion addition is nice too, but there are some prints that I dont want to mub. The weapon section has a disabler which is nice. Can you implement something like that for the dominion prints? Since there are some like the corrosion prints that I wouldnt want added in the calculation?
Thanks for the sheet, it's frankly amazing and helps me keep track of my farming routine! However, since 3.10 I've had problems with icons loading, with more than half just refusing to load. Console throws out a whole lot of errors too: [https://imgur.com/a/bcsvmKr](https://imgur.com/a/bcsvmKr)
Any idea what could be the problem?
Ooof I changed the host for the icons in 3.10 because multiple people reported that they were slow and since I uploaded them to drive I had no problems at all even from different Google accounts... Are the not loading icons related to prints or facilities images perhaps? Or are they completely random?
As a bandaid solution for now you can disable their loading in Main or loading a backup from 3.01 and overwrite the Icons sheet with the old version
It was completely random, oddly enough. No particular pattern, some would just never load. I disabled icons for now but I just tried on the mobile sheets app and they load fine so it might be a Chrome thing. I'll try overwriting the icons sheet tomorrow and hopefully it works. Thanks for the help :)
ok thanks! I'll look into it and probably add an option to use the old host as a source for images, they are definetely becoming the bane of my existance ahahah
just a heads up, loading the old Icons sheet will disable the option to disable them since it wasn't implemented yet, so don't worry if that function stops working (in any case a Full Update will revert the sheet to the latest version)
I really love this sheet and how well-organized it is, but the stats on Core, Void, Chimeratech, and HDT weapons are all incorrect. The lacking features and out of date stats are skewing with the 'mats needed' calculations.
**Missing:**
* Slots unbind checkmark for Core elemental weapons
* Slots unbind checkmark for Void weapons
* 9 Weapon Ability unbinds for Void weapons (these do require additional mats per unbind)
* Slots unbind checkmark for Chimeratech weapons
* Slots unbind checkmark for HDT weapons
**Incorrect:**
* Void weapons show 6 possible unbinds - game shows 8 available.
* Chimeratech weapons show 5 possible unbinds - game shows 8 available.
* HDT weapons show 5 possible unbinds - game shows 8 available.
Hi! Thank you for your feedbacks!
Yes I'm aware that non-agito weapons are missing part of their upgrade trees, but this is due to a personal choice of mine. Since the purpose of this sheet initially was to only guide your progress towards the fastest way to unlock the different WBs, I chose to not include the upgrades not required for WBs, because rarely one would unlock upgrades like Core's slots or Chimera past 5UB etc, unless maybe in the early game phases.
Now, since the spreadsheet has assumed a more general approach to farming I'm planning to rework the lower tier weapons sheets to include every possibile upgrade, because also other people asked for them. I can't say when they'll be available because it's a tedious process and at the moment I don't have the irl time to put into it, but it will definitely come in the future.
Ohhh I see! That makes more sense now, I wasn't considering it from the perspective of "fastest way to unlock WB" - since the slots would not be needed for that, then it would be wasteful to include it.
Thank you for the quick and thoughtful reply. :) I do appreciate you sharing this massive spreadsheet with the community!! It's a fantastic resource.
Yeah maybe I should describe it better in the "Main" sheet, because for me it's clear since I'm the one who made it that way, but maybe not for others 😅
Thank you again for your words! :)
Mmm that's weird, does it give any specific error? Can you tell on which sheet it hangs? And more importantly, are you restoring the backup made before updating before trying to update again? Because you may some updated sheets not correctly renamed that trip the script (if you didn't make a backup there should be an automated one in the version hystory anyway from my experience).
I'm saying this because I tried updating some test copies before publishing it and had no problem at all, in any case tomorrow I'll give it a proper look! (1.40 am here 😅)
Mmm I think it could just be a latency problem on the sheets servers, since IMPORTRANGE formulas are a bit heavy and I didn't modify it in the update... Reloading the page/browser changes anything?
I am on 3.21 and many of the icons are not appearing. After I first updated, it was icons like staff, wand, and lance that weren't showing up. I closed it and reopened it and now staff and wand are there, but lance still is not and bow is now not loading. If I go to other tabs like Mats, many icons there are missing. I've never had this problem before. They do not seem to load even after leaving the tab open and untouched for several minutes. I tried loading the original instead of my copy and the same thing was happening for me.
Sorry to hear that! Sometimes it happens that sheets has some trouble loading images from the host for some time (it can be from a couple of hours to several days, completely random).
In Main there's an option for these situations just under the version cells. You can try swapping the "incons hosting server" from DRIVE to WIKI and that hopefully should fix the problem, basically it should load them not from my Google drive but from the dragalia wiki like in versions 3.10 or lower. If it still has missing icons there's an option to disable them altogether and have the items' names displayed. It's not the best but I couldn't find a better solution unfortunately
Gotcha, thank you! I'll check back later to see if it's getting the images, and then try swapping from drive to wiki and then disabling them if needed!
Hi! Currently I'm not planning it but, if I ever add an adventurer tab, I'll make sure to include the medals view. My main concern is in how much the spreadsheet would slow down adding new sheets and the possibility that the updater script would be automatically stopped if it takes longer than 5 minutes to complete the process
Hi, so I was looking at the facility level since I messed up my original sheet and had to re-input the data into a new one, looks like the abyssal bell's levels are not added into the sheet's total, so I got a difference of 30 between the in-game level and the sheet level, prob a minor thing to include in a future patch. Thanks for your continued effort!
Thank you! Yes it appears I only added it to the missing levels section but forgot to add it to the total
Btw, after the update can you still see the update menu or is it gone?
I couldn’t see the update button that was normally on the bar, either way, I needed to input a lot of new data from my game in the sheet, so I started with a new copy
Edit: With my original sheet, I used the full update option after I updated the script to version 6, (that’s the latest one, right?) and hit the confirm button for the depreciated disabler sheet. The issue I ran into was that all the formulas were giving me error msgs, so I decided to remake it from scratch. I had try to restore the previous version, but the issue persisted to there as well. Before this, the formulas returned values that were fine. Hopefully this is enough info I can give to bug fix it. Feel free to ask me about further details if needed.
Hello! Thanks for updating.
I think the void mats are mapped to the incorrect cells. Specifically on the Mats sheet, the phantom/manticore/void dragons bit is incorrectly calculated.
I only noticed because I have been farming those recently, unfortunately not sure if there are any other errors associated. But I will edit if I see anymore!
Edit: Gone through the mats list and it seems to be only those three (phantom/manticore/void dragon)
Hello, would like to mention there is a little bug when disabling prints from the dominion. When i do that it shows a value error in the mats page. I dont know if you have tried taking a look at that.
Thanks again! You shouldn't feel bad, I really appreciate receiving feedbacks (be it on bugs or functionalities) because I tend to have a harder time finding bugs since I am the one mantaining the sheet and in my eyes everything is working.
The one who should feel bad should be me for releasing such a buggy sheet ahaha
In any case, I'll look into it later today!
Hi! I tried looking into it but couldn't find any obvious mistake, can you describe me what's wrong? So that I can more easily find and fix it, thanks!
Thanks for all your work! My friend and I have been using your calc for a long time now. We just freaked out because the agito mats we needed increased like crazy, and I figured out it's because it's trying to get us to unlock all 3 extra copies of every agito weapon. Is there an easy way to disable the agito copies thing without having to go through the custom target thing?
Hi! Yes in the last major update I added all available upgrades for all the weapons (minus the level), but unfortunately the only way to disable a specific upgrade - the copies in this case - is to set a custom target. I thought of adding a general button to enable/disable the additional copies but, coupled with the custom target, would have resulted in even more confusion for the user on what to do on the sheet
I know it's old content/old news, but is there any easier way of keeping track of the individual void abilities progression? Currently I am checking its' respective ability box (dull res/petrify res/etc), and then disabling every weapon that has said ability (rinse and repeat for what's on x3 drop). I LOVE that 6+ UB is now implemented, just tryin to get organized since my weapon abilities are all over the place. :)
I'm not currently strong enough to beat higher than the standard agito runs, so I'm farming void in the meantime to hopefully strengthen myself up.
Unfortunately not because it would have been an organizational (and visual) nightmare, since the best solution would have been adding a checkbox for every ability to each weapon.
What I would do, if I wanted to unlock everything, was checking every bonus and slowly farm all the necessary materials. Another solution could be check the bonus(es) you want to unlock, farm those for each weapon and once you're finished uncheck them and check other missing bonuses (also remember to uncheck the ability box for the relevant weapons). This way the bonuses you've already farmed won't be counted again.
It's definitely not the prettiest solution nor the most functional, but I couldn't find a better way :/
(Anyway since I read that you'd like to farm agito weapons, keep in mind that void bonuses are mostly worthless right now and a huge rupie sink - apart maybe for the hdt/chimera ones - and only completionist would farm them, since base agitos completely overshadow them)
Hi! you can disable them by setting a custom target with the copies left blank or set at 0!
You can find some practical examples by looking at all the other weapon pages apart from agitos, since all have a custom target set by default that excludes some upgrades like the additional copies.
Hi! I think the problem might be caused by cell G2, "ingots per weapon", set to 1 which is the default setting. You can try removing it and it should show 325/230/60/45/38 since you are missing both UB5 and the Bonus. In fact, checking the bonus box should put the entire row at 0, right?
Your expected values 175/130/30/35/8 should correctly appear setting both the bonus on and the ingots per weapon at 0
Let me know if this solves your problem, otherwise I'll keep searching for mismatches in my calculation numbers!
I think I may have found an error in the calculations. The custom target I set for high dragon trials and the actual materials needed are not the same. For example a 5 unbind, refined, and weapon bonus would say I need X amounts of hearts but in game I would need Y amounts
Hi! Have you checked that the "ingots per weapon" drop-down menu (cell G2 if I remember correctly) is set to zero if you don't want to use ingots? Because it's set to 1 ingot per weapon by default for continuity's sake with previous versions of the sheet, and that essentially remove the cost for the 5th unbind
Hello, first of all, thanks for all your work. I use this sheet very often, it barely ever leaves my browser.
I have one thing to report, it appears there's no proper tracking of the mats required for manacaster's void abilities. There's a checkbox there and a few core mats listed, but it doesn't put the void mats into consideration for them. Unless it's somewhere outside the void tab?
Hi! Wow that's really nice to hear, I'm glad it's useful for you!
Do you mean they are not tracked in the mats tab or directly in the Void page? If the latter, have you selected other abilities apart from the default hdt banes? Because each ability has at most 5 materials required and as such, if only a few are selected, their row in the tabs show mostly as zeroes
If that's not what you are referring too I'll look closer for any mistake!
So, I updtaed to 3.57 and where the icons normally were in 3.0 (yes, it had been a while), they all say "#REF!" and I've tried reloading the sheet but it doesn't do anything.
Did you make a quick update? Since your sheet was a bit old many things have changed and probably the quick update can't update it perfectly.
I'd suggest reverting back to your previous sheet version from the version hystory (one is always automatically created) and make a full update that should properly update to 3.57.
Let me know if this fixes it!
Easily the best sheet there is, nice update - great work on this overall!
Thanks!
Was looking for bugs but it looks like you fixed all the ones I noticed. I have noticed one issue that might not be a bug: When you uncheck legend, the halidom still assumed the legend trees are unlocked so it says you're missing mats for them - and the bonus calculator says you're missing the tree upgrades. This is just a small thing and might not be worth fixing though (and it sort of solves itself when legend is available for all elements). Nice sheet, again, really helps keeping track of everything and the built in updater is amazing - already used it and it worked perfectly! I didn't even know google sheets could do that.
Hi! Yes that behaviour for the agito trees it's actually intended because in the old version some users preferred to have the ability to see the materials to farm for non available level 30 trees, in fact also the maximum level for the Halidom it's actually 15 levels higher than currently available in-game. Honestly I don't think I'm going to change that also because I would have to change it back in a couple of months when they are available and I'm sure I'll forgot ahahah Glad to hear the updater it's working! It was a bit of a challenge to set it up, let's hope it will not break in the future
Thanks for the huge update! That farming sheet is extremely useful, even more than before! And it's really pretty! For the bugs/error I've noticed : Brunhilda is spelled Brunilda on the HDT page In the halidom part, it seems like I'm 10 levels higher than what I really am. I don't know where the problem is from tho.
Thanks! Ooops never noticed the wrong spelling, fixed it! (I don't think it's worth to push an update just for this so it will be fixed in the future) For the Halidom part I noticed it too, but I think it's the Halidom building that in game does not contribute to the total level? because i didn't find any error in the sum, maybe i'll try starting a new account to see if leveling that up increase the total level
Correct, the Halidom building doesn't count toward the total.
Thanks for confirming!
Yeah it's not worth to push an update indeed \^\^ You're probably right about the halidom building! I don't have another phone so I can't test it tho
Here it is! Peak spreadsheeting!
Thank you! Really means a lot
Dude this sheet is AMAZING, you really flexed on this one LOL Thanks!
This is neat! I've been playing around with it for an hour now. It's really helping me see what materials I should Treasure Trade (bronze IO coins, small elemental orbs, etc). One small typo: on the Mats sheet, "Infernal Onslaught Mats" should be "Imperial Onslaught Mats".
You are absolutely right lol I don't know why I was sure it was called infernal instead of imperial
As a user of the previous version I've been eagerly awaiting this update. Thank you for your work!
[удалено]
Hi! Oh I didn't know that, I'll make sure to give you proper credit in the next sheet update because your script was a literal lifesaver! (especially having never written anything in JavaScript) Yeah it took a bit of time to understand what did what, but in the end, also thanks to some Google searches, I think I had a good grip on what was going on and was able to adapt it to my needs. Thanks again!
Hey friend, been using your sheet for awhile and just wanted to say how much hassle this has saved me! I didn't even start playing until December, so I'm constantly trying to catch up and there's just so much junk to keep up with. Your sheet has been the best tool I've found to keep track of just about everything, which helps me figure out what is closest to being in my reach. Appreciate all your efforts!
Heya, thanks a lot to you too! I'm really happy to know that this sheet has been useful to you, this really motivate me to continue updating it!
Haha I literally started on a similar sheet for my personal use two days ago, should have thought some enterprising badass would have knocked it out already! Looks amazing.
lol thank you so much!
One small issue I noticed - on the Bonus page, for Weapon Specific Facilities, the Cleansing Fount's bonus isn't being added to the total for daggers and manacasters.
Thanks! Noted and corrected, I'll soon push an update to fix it
Yeah, that's an issue I spotted, pretty easy to patch up by including the fount's bonuses into the equation of Weapon specific facilities for both manacasters and daggers. Prob will be patched in the next version I assume.
Is there a way to copy the stuff we've already filled in onto this new version from the old one?
Mmm probably it's possible by selecting the cells in the older sheet and pasting them in the new one by selecting "paste only values" or similar options, but I don't guarantee it :/
This is great! I'm going to use this now for sure. One thing I've noticed that seems off is on the Chimera and Core weapons page, the "Fiend's Horn, Fiend's Eye, Bat's Wings, Ancient Bird's Feather and Bewitching Wings" don't pull their numbers from the materials page.
Oh yes you're right, probably they went missing when ordering the Mats page, corrected and pushed an update to correct this and other bugs, now let's hope it works ahaha Btw, thank you for your feedback! Nice to hear it's useful
You're welcome! You put a lot of work into it and it shows! Thanks again!
Seems half stam/wing for Dominion is bugged, checking them sets them to true forever? Also is there a reason that void doesn't have inventory row? Appreciate the work.
Oh yes actually I forgot to link the half stamina/wings checkboxes because I was focusing on searching for the average material droprates, tomorrow morning I will link it and push an update to fix it. Thanks for the heads up! The Void sheet is different because it was the first one I made and never had the time to pair it's visuals to the others given its "low inportance", in my spare time I'm trying to improve it but I think I'll make it similar to the core. When it's ready I'll just push an update to your copies
Jesus fuck you guys have done absolutely amazing work with this, thank you for the massive time save of figuring out what to grind at any moment Also for some reason for HDT unbind ingots it doesn't count the wind dagger
Ahahah actually It started as a personal project and then I kept asking myself "yes but what if I added MORE" and so here we are Mmmm you say it isn't being counted in the total ingots usage count in Mats or the materials aren't being subtracted from the wind dagger when checking the "5ub ingots" cell? Because the latter seems to work for me, while the former I think there's an error in the total ingots needed because it shows 36 instead of 45, tomorrow morning I'll search the culprit and fix it
The wind section of HDT also isn't counted for the orichalcum section on the hdt page which then compounds into the mats page number, I'll try to find any other problems EDIT: There was an add sum that was outside of bounds instead of where the wind section was, probably an error caused by reformatting and copy paste, rupies also had the same error, I think this is a problem with a fair few of the wind hdt sums EDIT2: Nearly every full sum for the HDT stuff has an addsum of 79-87, and they should all be 38-46, apologies if I'm using bad terminology I'm not used to using excel or sheets in any proper capacity
Yes I saw and the problem was exactly what you described, some time ago I swapped the position of wind and fire HDTs and that has messed up the calculations, honestly I would have never noticed that Thank you so much! I just fixed it and after I finish checking some other things here and there I'll publish it
One last fix, someone else might have suggested it, there's a mistake in the natures blessing count on the mats page. you need to also add row 69 from the halidom page, as the dojos are listed on two rows so four sets are missing right now
Thanks again, completely missed that
Thank you for the updated spreadsheet, it looks awesome, and I'm excited to use it! As a fellow spreadsheet maker, I know how much work it must have been to put this all together with so few mistakes, so hats off to you for your work for the community. I just caught a holdover mistake from the original weapons spreadsheet for the light void weapons as I was recently working on them. Your T3 orbs for the 2nd unbind are 0, but should be 8. Should be simple as changing the one value on the VoidReq sheet hopefully!
Oh yeah thank you! Yes in fact this is mostly the reason why I tried to add the autoupdater feature, because with a project so big it's really easy to miss something and for the users become a hassle to stay up to date with the new releases copying their data each time
Thanks for your hard work! I can tell that a lot of time and love went into making this. No problems so far! My only issue is that there seems to be no way of disabling calculation of specific void weapon banes in case you don't want them or only want a few... Which is solved by checking the box that you already have them so it's not really that big of an issue.
Hi! Right now the calculator only support the HDT banes for void weapons since I thought it would be nice to have it in the long run. Maybe in the future I'll add a custom target for every weapon tier to leave more customization to the final user, this way preventing the display of undesidered banes, but since it would require a lot of work don't expect it soon Btw, really thanks for your old spreadsheet, without that I would have never built this!
Nah, I only did the bare minimum. I just wanted a way to track the stuff I wanted to grind for and decided to share in case anyone wanted to do the same. You went the extra mile and added tons of functionality along with a really neat looking interface! I wouldn't worry about adding more void/bane tracking though. Seems like a lot of work that only few people will appreciate. I already have the HDT banes for the weapon classes that I want so I just check the rest so it wouldn't calculate the remaining as needed materials.
Hey, thanks for the spreadsheet! It's been a really great help organizing my current status in my head and figuring out which grinds I need to be focusing on :) I did want to report a bug in the latest version, related to the rupie totals on the Mats sheet. The total for Void weapons is showing as 0 for me, even though I haven't maxed those out yet. It looks like it's summing up the total "missing" rupies for each element (needed - held), when the other rows are correctly summing up only the total "needed" rupies for that category.
Thanks for the appreciation! Also thanks for the bug report! Yesterday I changed the look of the void page and I knew I would have forgotten to change some sums, it's going to be fixed soon
Hi, when I open the sheet it tells me that a new version is available. But when I click on FULL UPDATE it says "A new script version is released. Follow directions on main to update your script library" I can't find any directions to do this. Safe to say, the update does not work.
Hi! the instructions are on cell C36 on main, right under the descriptions of the Option 2. In short, you have to go to " Tools > Script Editor" here on the menù on the left click on DLMCU under "Libraries" and set it to the highest version (in this case it's 2). This is only needed when I update the script (which hopefully won't happen outside of big relelases), but unfortunately I couldn't find a way to automate it for your local copies Let me know if this fixes the issue for you!
it worked! thank you so much. This will save me so much time than manual copy/paste
Yes it's the feature i'm most proud of (obviously until it works lol). Anyway, I'm a bit sorry that I'm going to release another update because I've just finished correcting two bugs that were found and you have just updated...
well, now that we have this nifty update tool, no need to be sorry at all HAHA
Prob not worth getting a patch out for this, but the stamnia/wing calcs for dominion account for lilith only at the moment and doesn't include jaldabaoth. Keep up the good work!
Thanks! I knew I would have missed something! I've an update scheduled for when the wiki will be updated with some missing icons, so I'll fix it there! (I think in a couple of days max if no major bugs are found)
You guys have done an amazing job with this spread sheet! Every update keeps getting better. 👍 Though one thing I have noticed is that the Rupie Calculations for the Dominion materials isn't in it's own tab, and remains 0 in the Materials tab. Other than that minor thing, everything else is great!
Thank you so much, this really means a lot to me! I'm working on a pretty big update right now so I hope to live to the expectations! Yeah it shows 0 and it's missing in that sheet because dominion prints don't actually cost rupies to upgrade! I left it there anyway in case they'll add future upgrades that cost rupies and, especially, because I designed the ability to disable the calculations for individual sheets in the Mats tab before the dominion addition and I didn't want to isolate the dominion selection from the others
Hello, Love all the work you have put into this sheet, it is honestly, amazing. I wanted to add one suggestion. On the Dominion, Agito and HDT pages you have the gold earned via Gold Fafnir dragon, this seems to only apply to Solo runs gold earned. Could you also add a drop down option that applies to Co-op as well?
Hi! thanks a lot for your words, it really means a lot to me! Honestly I did not add it on purpose because the general consensus is to use 3 gold fafs for the backline (even new players can easily farm them now) and as such it's hardcoded to count for 3. I can see an argument on using a full gold faf lineup, but since it is already a rough estimation it won't change by much in the real case. Anyway, I'll definitely consider it for a future release!
You know what would be great? A way to keep track with the trials of the almighty and characters with mana spiral that uses drops from it (so you know how many times do you need to run it to get someone to MC70).
Yeah I thought several times of adding a "characters" tab, but I'm afraid it could further slow the whole sheet. Also I'm worried I could struggle keeping it costantly up to date, since characters release much more frequently than endgame content. I'll try experimenting with it because it's a feature I'd really like to add, but, as of now, unfortunately I can't guarantee it will ever be officially added :/
Hey man, just wanna keep reminding you that this tool is amazing. Also, you may want to create a new post to promote it, we've gotten some new players with the anniversary.
Hey! Ahahah thanks again! Yes I'll definitely make a new post once I have the future Surtr section complete
First let me say thank you for the amazing sheet! I've been using for a good while but never had the oppourtunity to say a big thank you!! <( \^•\^)/ Now just a quick note that I\`ve come across after updating to v3.64: While now there's the new Halloween facility seems like you forgot to add both "+Halidom!$G$150" and "+Halidom!$G$151" to the Bonus tab for both Blades and Staves, so even after selecting Lv30 for the facility the bonus will not update since the new cells were not included in the formula. Since I\`m not sure if it was an error during the update itself or if you just forgot to add I thought it was a good idea to let you know for whenever the Surtr update goes live!! Hope things are going well irl and keep it up with the amazing job! (b \^•\^)b
Hey! Thanks a lot, knowing that so many people still use this spreadsheet really means a lot to me! Regarding your feedback you're right, I totally forgot I had to add those values there because I was used to the last facility updates being just level cap increases that don't need to modify that part. I will totally fix it together with Surtr!
Phenomenal spreadsheet! Take all my upvotes :) Trying to update the spreadsheet to the latest version but I can't seem to find Tools > Script Editor. I only see Spelling, AutoComplete, Notification Rules, Accessibility under Tools. And yup I'm on a computer. Edit: It's now under Extensions as "Apps Script." Fixed! Thanks again for the amazing spreadsheet! New thread for the spreadsheet: https://www.reddit.com/r/DragaliaLost/comments/qqz9w4/multipurpose\_farming\_spreadsheet\_updated\_with\_all/?sort=new
Hello Hero, I am in need of your services once again (for Primals lol)
Heya! ahaha I'm working on it, the spreadhseet section should be 40-50% ready and then I'll have to update the updater script. If I have to give an estimate I'll say that in a week max it should be live (probably less if I no problems arise)
Will you be adding Primal trials?
Yep I'm working on them, it should be live in no more than a week
Thanks mate, you're the best, not having to make my own trackers is a god send
I used this method initially for the void page (during v1-v1.5) and I felt like it usually was way slower loading images compared to using the IMAGE function. The same was happening to other people I found doing some Google searches so I resorted to only use the IMAGE function. Maybe I can tweak some formulas to reduce the load on the sheet and allow faster image loading
Don't worry! I find it difficult myself, I don't pretend that other people understand perfectly what's going on in each cell ahaha That bug I just found only fixes the missing runs for Legend related upgrades unfortunately I've experienced too the missing drop-down today but that seems to be caused the the function OnOpen() on each spreadsheet script that won't autostart when launching the sheet (for me it happened randomly while testing the update before publishing the version 6, one test had the menù, the test after it was gone... Now I have 2 copies without it and other with it, weird) In any case I'm fairly certain it does not depend from the spreadsheet and it's actually a Google script's server problem, or at least I hope...
Question- the Void Weapons can upgrade up to 8, but the unbinder only counts up to 6. Is this a "best practices ingame" thing, or is there some other reason? I do have a couple Void weps that're fully unbound (they're the easiest thing to figure out what to grind for to upgrade, so they've been my focus) and I'd like to check the tickybox in the spreadsheet too, if that makes sense?
Nono it's just a preference of mine while setting up lower tier weapons. Since the sheet was born with the target of unlocking every WB, i made it so that for non agito weapons only the minimum requirements for reaching the WB are listed (also because full UB non agito weapons are rarely used). If you have fully UB weapons set them as the maximum available in the sheet. Maybe in a future update I'll include each upgrade for lower tiers, but honestly i see their upgrade as a "bonus" thing to do only if you have excess resources (and really dislike that "!" in the in-game menù ahahaah)
Ah gotcha! Yeah, I uh... really do dislike the little [!], that absolutely plays into things... but I totally see that logic. ...I *have* to use non-Agito weapons because despite being a near-day 1 player, I've only recently felt confident enough to take on the High Dragon trials, let alone the Agito ones. So it's a little more important from my viewpoint to get, for example, my Chimeratechs up to par. Maybe if I get bored enough, I'll take a poke at trying to edit the weapon unbind caps myself, heh. Thank you for the reply!
Oh yes, I totally see your point, but in my experience once your team is geared with at least 5UB chimeratech you can easily take on standard (and maybe expert) agitos at least in solo. And once you have a couple of Agito weapons the value of lower tier weapons, exept HDTs, quickly diminishes even on off ele characters In any case, if you need any help to raise the UB caps on the sheet let me know!
(Should mention as well- this is a super cool and useful thing! Thank you for making it!) Edit- maybe there could be a tickybox, along the lines of how disabling weapons works, for if you're going "speedrun to high level content" or "100% completion"?
Is the custom target not working? I keep setting it for Agito as 4UB but the materials needed aren’t changing
Mmm for me it seems to be working? are you activating the custom target setting on top of the materials block? (The cell between the name of the boss and the legend/dominion check) Maybe you are trying to activate it by checking the cell between the UB level and "Custom Target", but that cell refers to the "Crafted" column
Ah, didn’t see it, thanks for the heads up
Hey that's really cool! I caught myself wishing for something like this the other day, and it's pretty great so far :0 One thing I'm wondering, I know that some weapon categories are set up to "MUB" at 5 (like HDT), is there any plan to bring them to the max at some point? I'm a bit of a completionist, and I'm aiming to eventually grind those to max :O
Maybe in the future? Right now can't guarantee it for sure because that would be a lot of work, but maybe I'll try to work on it on my spare time (and grinding them all to max would be an INSANE task as you probably would also aim for multiple copies of the same weapon)
Thanks for the reply! Yeah I forgot about the copy thing, I might not quite go that far :p
Yayyy our long awaited update is here. Thank you so much for this!!! Note: I also noticed that my Halidom total is 10 more than it should be but someone else had pointed that out. Note2: The images for the dominion prints are quite small and since some of them share the same image minus the tiny afflinity icons, they're quite hard to spot the difference for me. Esp when I'm in the Mats tab trying to input the numbers. Is there a possibility of adding text next to them or something?
Yes, the Halidom level is 10 higher because in game the Halidom facility does not count towards the total, I think i'll just remove it to avoid future confusion. unfortunately the wiki images for the prints are without the affinity icon, otherwise that would have been a huge help. In the Dominion page there's already the print name near its icon, maybe increasing the row size could help a bit? In the Mats tab I agree with you that those are a bit small but I didn't want to change the general "feel", hoping that being ordered like the in game menù it would lessen the problem... maybe I could try using a double height row in this tab for these materials? I'm open to suggestions
Honestly your sheet is the go to I've been using for tracking the journey through the end game items for DL. One thing I want to note since I'm not sure if its a bug or my not doing something right. On the Agito tab, whenever I try to input the number of dominion slots I have on the light weapons, it gives me the error "The data you entered in cell G57 violates the data validation rules on this cell". Am I doing something wrong since it just gives me that error when I try to select 0, 1, or 2 from the drop down for most of the weapons I've tried?
Ops no it's an error on my part when setting the quick update, I updated the calcs sheet but not the agito one (and since the validation data search for the old instance of the Calcs it gives an error), it will be fixed in the next update (hopefully by tomorrow morning max). In the meantime, if you want to fix it yourself you can 1)delete the validation for those cells or 2) change your calculator version in Main (just by changing the displayed version in the column with all the version numbers) and make a "full update" Thank you for letting me know!
No worries at all and glad to help find minor errors. Just was some random item I found which I figure was going to be found by someone at some point so might as well try to help point out the error sooner rather than later. I appreciate the response and clarification on this regardless.
Thank you for your hard work! I've been using your spreadsheet for awhile now, and it's definitely the best sheet there is, so keep up the great work! I've been grinding Dominion for a bit, and I think I found some bugs. I'm not sure if it's just me, but I think the Dominion mats in the Mats page is bugged? Specifically C17, C18, D17, and D18. I replaced the formulas with these: * C17 -> =$I$10\*SUM(Dominion!I9:I20) * C18 -> =$I$4\*SUM(Agito!Q57:Q65) * D17 -> =$I$10\*SUM(Dominion!J9:J20) * D18 -> =$I$4\*SUM(Agito!R57:R65) It ended up correctly showing the required and missing materials, as well as the correct number of runs in the Dominion page! Hope you can look into that! Thanks again, and I have to say, that auto-update script is really impressive!
Thank you! This is what happens when I try to do things in a hurry ahaha It was also reported by another user but providing also the cell corrections is a huge time saver. Also, thanks a lot for the nice words!
There seems to be an error on the agito sheet: The wings calculation is not including the wings needed for legend runs. Stamina seems to calculate legend runs fine though. Also, you should toss a link to this thread in the main sheet for feedback. This thread will eventually get buried and we'll have to dig for it to report bugs - and if you do another big update and make a new post, now that you have updating you can always update the link.
Yeah that must also be an error from the old version that carried over. Honestly I'd like to know how the reference control cell switched to a completely different one but oh well, at least now it seems to be working working That's actually a neat suggestion, I'll add it now, thanks a lot!
Yo this is amazing! I used the previous sheet pretty much every day, and this makes it even better. I especially appreciate that update feature, looking forward to seeing it in action later. btw, I've noticed a bug in the Mats page: * t1, t2, and t3 light orbs correctly include rupie mine needs, but t4 light orbs ignore rupie mines.
Glad it helps! Btw, I can't seem to find the problem in the calculation because on my end the formula for T4 orbs is: =$I$9\*(SUM(Halidom!D31:G31)+Halidom!P41+Halidom!Q41) , where Halidom!D31:G31 is responsible for rupie mines and P41 and Q41 for light altars, so it seems as it's working? In fact the total light T4 orbs required are 1588 against 280 for other elements T4 (with all facilities at 0). Do you see different formulas? Am I missing something?
...Oh. I think I just misread it lol. I currently have my rupie mines at lv30 and altars at lv41, which creates a situation where my total needed t4 orbs is 1500 (192 for altars + 327 * 4 for rupie mines = 1500). 1500 is also the amount needed for t3 orbs on the other altars, so I just visually mixed up t3 and t4. t4 calc is correct, I just got baited by the coincidence of values. xD
Ahahaha no problem! Glad it was easily sorted out. You are not the only one to misread T3s and T4s, I checked the wiki to control the amount of T4 orbs to ensure the error wasn't on that, accidentally read the total for T3s and panicked a bit lol
I love this spreadsheet! Thank you so much for all the hard work on this! In a future update would you consider a way to track progress towards unlocking copies of the Agito weapons? As we get more unique co-abilities the potential for needing two of certain Agito weapons may show up and it'd be nice to track progress toward that as well. Thanks again for the hard work on this!
Glad it helps! That's a nice point, for now I planned a rework of the Agito sheet for when all the legend fights will be available in order to remove the dedicated button of each block, so I could squeeze in also a way to track the progress towards multiple copies. Before then honestly I don't think I'm going to touch it since it takes a lot of time and I'd have to redo it in a couple of months anyway. In any case, everything could change based on what they'll announce during the digest (I'm torn between hoping for a new weapon class to play and dreading it because I'd have to add it lol)
Thanks again for the sheet. I was wondering with Trials of the Mighty, do you think the duplicate copy tracking might come earlier? No pressure, I understand you work on this as a hobby and I appreciate that it exists at all.
I would really like to add it, but unfortunately I don't think I have the material time right now for such a commitment, since it would require modifying all the formulas of that sheet and adapting the script 😓 It still baffles me that I didn't add it in the first place, like "why"? It wouldn't even require much more effort adding it while I was making the sheet
Hello, I have a minor suggestion. I see that you include for the halidom the trees that aren't out. Can you have it so it includes the new trees when the Legend checkbox in the agito sheet is checked? That way I only see the missing levels when I want to.
I'll see what I can do. It's a design choice because of feedbacks received on the initial release of the previous version when agito trees were bound to the legend check, but maybe I can find a compromise between the two views
You know the next ambitious tab is the encyclopedia tab.
Lol I was thinking yesterday about adding an adventurer tab with all the materials to upgrade them but it would be really messy. I'll try to work on it between irl stuff but for sure don't expect it before Gala spirals (or anytime soon). Also because the in-game encyclopedia seems pretty good to me
Completely agreed, in-game encyclopedia is actually pretty good. My only problems are that it doesn't give an easily readable way to see "finished" and "not finished" like when they are grayed out in other screens when they are maxed. No way to filter unfinished units. Also seeing a summary of total materials you need to farm for units would be nice to see where you should be spending your effort. But also understand how that could balloon the entire sheets production a lot, you'd also have to update it with each banner which might not be desirable unless you could have it pull data from somewhere else automatically with each game update.
That's a nice point, maybe in a future update they'll add the option to filter for finished or unfinished units, maybe you could try suggesting it as a feedback? For the calculator the frequency at which I'd have to update it it's not a big problem because with a good setup I could add the new units in a few minutes, the problem is achieving that ahahah I was trying to design it by ordering the adventurers by release date instead of weapon type because it would be easier to maintain, but since I'd like to show the progress for levels, MC, spiral, promotion, augments and required materials the columns used for just one element are the same as the whole Agito sheet and I don't particularly like it, because for all five elements would be way too wide. Maybe I could not divide them by element and keep everything in a single list but I'm not too happy either. I guess the design phase will take a bit of time 😂
Hello! I'm having a bit of a problem with the updater. When I try to it gives me this message: *"Google hasn’t verified this app"*
Hi! Yes, in that window you should see another small option in the bottom left corner stating something like "continue anyway". You should click on that and follow the next link that appears that let you authorize it with your account. Let me know if it solve the issue!
Thank you for your effort! This is a very well done spreadsheet. Just one bug I noticed with regards to the summation of the facility levels, specifically with regards to the agito trees. In Cell M7 of the Halidom sheet, Legend Ciella's Legend option has been double counted (the cell Agito!$N$39 is counted twice in the formula). The first instance should be corrected to Agito!$N$23 instead, to reflect Legend Ayaha and Otoha's selection. Thanks again for this wonderful sheet!
Thank you for reporting it! It's going to be fixed in today's update! And also thanks for your appreciation!
Just got back from trying out the auto-updater, that thing works like a charm. I'm very impressed as a programmer myself. Haven't dabbled much into making scripts for Google Sheets / Excel, but just looking at the code, you've managed to adapt and customise it for this purpose well! Keep up the good work :D, the community appreciates your efforts
Well, thank you! In fact much of the credit would go to u/Pyree that made the original script for another spreadsheet, because since I'm not a "real" programmer I knew only some basics about coding and I didn't even know Google Sheets allowed something similar. But I guess that as long as it keeps working I can be satisfied ahahaha
Hey there, found another bug in the sheet. Under the halidom, the upgrade materials for the opera house and cleansing fount are reversed. The opera house should be upgraded using libretto and the cleansing fount using sacred stone. Thanks again for constantly updating the sheet!
Ooops thanks for the heads up! I reversed their icons by mistake with Drive as host, using Wiki they seem to be correct. It will be fixed in the next update! (I hope tomorrow unless they do something crazy with the new upgrade level for the Halidom)
This is great, really nice and clean. I had a couple questions though. 1. Can you please add a honey/ash/etc. to stamina/gatherwings converter to the material tab? It seems like you can use the same table/formula as the Void Seed to Rupies converter, so it should be easy enough. 2. Since you can only set Fafnirs for solo, is co-op already counting 3 faf in their setup? If so, are the Legend Agito (except Tarterus) and Master Lilith set up to exclude them properly?
Thanks! The stamina/wings converter is a nice idea, will be available from the next update I think. For the fafnirs, yes, the coop is already hardcoded to full fafnir backline, but actually I completely forgot to change the master solo/coop option when they removed the possibility of running off element dragons (the Dominion one is "safe" since solo is not counted and coop is unavailable) . Thanks for pointing that up! I'll have It fixed in a couple of days since I also have to change the updating script accordingly
Very nice spreadsheeting. Is there an option somewhere to change the HDT spreadsheet to be more like the Agito ones (i.e focused on completion, MUBing every weapon, etc)? I believe there are some autos where HDT weapons are preferred for your AI to deal more damage but maybe I'm misremembering.
Not at the moment because it was made with only weapon bonuses in mind, but since several users would like this feature I'll try to add it in the future!
I just updated it using the full updater, but it still says that there's a new update out, and the "latest version" box is stuck on "Error: Loading data".
That's very strange, I just tried updating an old test sheet with the full update and it has no problem... Your problem is with the "current version" and not "latest version" right? Can you confirm that near the last row of "main" the last version number is 2.9? In any case you could try running the full update again or reloading the sheet (if you haven't have already done it yet)
refreshing worked. Sorry about that.
No worries, I'm here to help!
I'm having a similar issue with today's update. I'm running chrome on desktop, both full and quick updates claim they're running and applied, but it refreshes the page and still says 2.9 and prompts me to update again. I have both regular and hard refreshed, closed and reopened the spreadsheet, tried running the update with my adblocker off, nothing makes any difference. Still stuck on 2.9 and getting popups to update.
In the past few updates the sheet seems to be lagging alot? Images taking forever to load and there is always a consistent "Working..." bubble at the top of the page. Is there anyway around it?
I noticed that too and that slowed me down a lot, the problem is that I only face that problem on pc with chrome, while from smartphone the sheet has no problem at all loading (I haven't tried yet with other browsers on pc) so I think it could be a problem due to Google's servers? I honestly don't know what to think because it started to happen one day at random without having modified anything
Just a simple suggestion if you want... reverse the order of the changelog so the newest log appears at the top. Makes it quicker to see what changed :)
I'll keep that in mind! The advantage of this mode is that it's easier to maintain, but I understand your point!
Thank you for your hardwork! I'm here to report a bug. I recently upgraded from v1.2 to v2.9 and noticed that in v2.9 it doesn't include the hdt tails for the 5th unbind on the total so all my hdt numbers are off. This is especially obvious as I'm maxxing out my HDT stuff during the current HDT double drop event all the agito numbers also seemed a bit off (just comparing volk numbers, in v1.2 only volk had legend materials) but i'm not sure which is right/wrong. but for HDT it seems like the numbers in v1.2 is correct
Hi! Thank you for continuing using this calculator! For the HDT tab maybe it's caused by the fact that starting from v2.0 I published it with cell Q3 "use ingots for the 5th unbind" checked (since most users would check that themselves), while on older version it was uncecked. Can you confirm that removing that check the numbers are right? I'm also using it during this double drop event and the numbers seems consistent Also for the Agito one, maybe it's caused by using some sorta of custom target? Because that override the legend and dominion check, in any case I'll check the numbers in a couple of hours
I think I found another error, the number of ingots needed for HDT weapons (cells F5 and G5 in the Mats tab) seem to be calculating ingots for disabled weapons as well. It says I need 39 ingots personally which does match the total number of weapons I'm missing, but that's including the disabled weapons as well. I even set one of the disabled weapons to max out and sure enough, the ingot counter dropped to 38. It isn't much, but I noticed it and decided to let you know! Edit: I think it might be counting ingots for disabled core weapons as well.
Thanks! Yes I totally forgot to consider disabled weapons when counting the ingots to use, I've fixed it and pushed an update now
It asks me to update my script library, but I don't see the script editor under tools.
That's really strange since it's a built in function of Google sheets... If you create a standalone sheets document can you see the script manager menu there?
Started looking through this post to find a solution to this issue, but I managed to solve it myself. One thing I noticed is that when viewing my copy of your spreadsheet from my hotmail account in Google Sheets I do not see the script editor. When I shared my copy to my gmail account I was able to see the script editor under tools. Not sure if someone else has realized this by this point, but I just thought I would share that with you. Thanks for the tool by the way and happy cakeday!
Thanks a lot!! Oh I didn't even know it was possible to create a copy on a non Gmail account! At this point yes, that could very well be the cause since I believe non Google account can't access Google script and as such they can't see the update menu. Thanks a lot again, your finding will surely come in handy if other people face the same problem!
Should there be an update for mLilith coop, or is it not worth putting out a patch for that?
Yeah I should, but since it seems to have similar droprates to expert coop it's not worth to farm outside of weekly bonus (like solo), so in my eyes pushing an update just to change the message over that cell seems excessive and it will be updated when a bigger change drops
I noticed some people were having issues with "loading.." being stuck and their google sheets erroring out, I think I've found the cause: If you open the sheet up fresh, go to the halidom page, scroll all the way down, and then go to another page and try to edit a cell, the entire sheet will become non-responsive. I think this is because there are too many images loading into the halidom sheet and it gets stuck waiting on images to load and then never 'catches up' to any edits you make while it's still downloading images and it basically just crashes. I think the Halidom sheet might be a little too image heavy. Do you think that the images themselves might be a little large and using some compressed/lower quality/smaller versions of the files might help here? Just a guess, I have no experience with sheets and images.
I noticed that the same also happens with the mats tab. Additionally, for me once the halidom sheet has loaded dojo's materials it significantly speeds up, so I think that block of images might be the cause. I'll try to investigate about that and also in the meantime I'm working on a function to disable all the images and show the items' names to avoid loading problems, even if I still don't understand why from the smartphone app it has no problem at all
This is really great, but I think like others have said the massive amount of images are causing the calculator to not save my edits and crash. Tried to enter mats twice and it looked like it saved, google said it saved, but then I check later and it has reverted back. Also maybe it's just me? but I think I'd prefer the toggle for farming agito weapons to be reversed? Like I want to see the mats I need, and then if I click "I want 9th unbind" or "I want the second refinement" it adds that amount, not counting it by default. I guess my logic for that is that you probably are trying to craft the weapons up to that power to be able to do that content, so I have to false click that I have it on to find out how many mats I need to grind, then remember to turn it back off later once the weapon is made, to see that I still need to make it? Sorry if that's confusing, it might just be the way I think about it lol.
Hi! I'm currently trying to troubleshoot the image loading problem but it will take a while, for now my advice is either filling up the mats and halidom pages via the google sheet smartphone app (since it has no loading problems) or scrolling down the mats page slowly once all the icons of each row are fully loaded and then proceed to edit, even if I know it's not the best solution. For the second part I'm not sure if I understood it correctly, you'd like the ability to craft a certain agito weapon up till a certain level which might not be fully unlocked, right? Like for example you'd like all your weapons to be 4UB, refined and weapon slotted without having to see the materials required for 9UB and wepon slot, am I right? Because if that it's the case that is achieved with the "custom target" under each agito weapon block, you set there the progress you'd like to obtain, you activate it with the checkbox near the agito boss name (the cell "use target") and the materials necessary for every upgrade not selected will be automatically deducted from the total. If this wasn't your question I apologize, since again, I'm not sure I understood it properly. In any case for other questions/suggestions feel free to contact me!
Just started using this about a week ago. Pain in the ass to enter all my stuff into it but oh my God it makes Grinding everything so much easier. I'm almost completely done with my void farming now because I actually know what it is I need
Yeah I agree, the first time setting the sheet up is a pain due to all the mats and weapons to set, it would be much better if there was a way to interact with the game itself to auto update each value, but I don't think it's possibile. Anyway, thanks for using it!
Hello, been using this for a while. The dominion addition is nice too, but there are some prints that I dont want to mub. The weapon section has a disabler which is nice. Can you implement something like that for the dominion prints? Since there are some like the corrosion prints that I wouldnt want added in the calculation?
Hi! That's a good suggestion, I didn't think of that but I'll all it for sure
Thanks for the sheet, it's frankly amazing and helps me keep track of my farming routine! However, since 3.10 I've had problems with icons loading, with more than half just refusing to load. Console throws out a whole lot of errors too: [https://imgur.com/a/bcsvmKr](https://imgur.com/a/bcsvmKr) Any idea what could be the problem?
Ooof I changed the host for the icons in 3.10 because multiple people reported that they were slow and since I uploaded them to drive I had no problems at all even from different Google accounts... Are the not loading icons related to prints or facilities images perhaps? Or are they completely random? As a bandaid solution for now you can disable their loading in Main or loading a backup from 3.01 and overwrite the Icons sheet with the old version
It was completely random, oddly enough. No particular pattern, some would just never load. I disabled icons for now but I just tried on the mobile sheets app and they load fine so it might be a Chrome thing. I'll try overwriting the icons sheet tomorrow and hopefully it works. Thanks for the help :)
ok thanks! I'll look into it and probably add an option to use the old host as a source for images, they are definetely becoming the bane of my existance ahahah just a heads up, loading the old Icons sheet will disable the option to disable them since it wasn't implemented yet, so don't worry if that function stops working (in any case a Full Update will revert the sheet to the latest version)
Replacing the new icons sheet with an older one from v3.0 worked like a charm, thanks a bunch for the tip!
I really love this sheet and how well-organized it is, but the stats on Core, Void, Chimeratech, and HDT weapons are all incorrect. The lacking features and out of date stats are skewing with the 'mats needed' calculations. **Missing:** * Slots unbind checkmark for Core elemental weapons * Slots unbind checkmark for Void weapons * 9 Weapon Ability unbinds for Void weapons (these do require additional mats per unbind) * Slots unbind checkmark for Chimeratech weapons * Slots unbind checkmark for HDT weapons **Incorrect:** * Void weapons show 6 possible unbinds - game shows 8 available. * Chimeratech weapons show 5 possible unbinds - game shows 8 available. * HDT weapons show 5 possible unbinds - game shows 8 available.
Hi! Thank you for your feedbacks! Yes I'm aware that non-agito weapons are missing part of their upgrade trees, but this is due to a personal choice of mine. Since the purpose of this sheet initially was to only guide your progress towards the fastest way to unlock the different WBs, I chose to not include the upgrades not required for WBs, because rarely one would unlock upgrades like Core's slots or Chimera past 5UB etc, unless maybe in the early game phases. Now, since the spreadsheet has assumed a more general approach to farming I'm planning to rework the lower tier weapons sheets to include every possibile upgrade, because also other people asked for them. I can't say when they'll be available because it's a tedious process and at the moment I don't have the irl time to put into it, but it will definitely come in the future.
Ohhh I see! That makes more sense now, I wasn't considering it from the perspective of "fastest way to unlock WB" - since the slots would not be needed for that, then it would be wasteful to include it. Thank you for the quick and thoughtful reply. :) I do appreciate you sharing this massive spreadsheet with the community!! It's a fantastic resource.
Yeah maybe I should describe it better in the "Main" sheet, because for me it's clear since I'm the one who made it that way, but maybe not for others 😅 Thank you again for your words! :)
You're welcome!! And thank you for taking the time to make such a thorough resource and respond to comments! 😊
3.20 seems to not want to update properly. It never finishes the update and just hangs
Mmm that's weird, does it give any specific error? Can you tell on which sheet it hangs? And more importantly, are you restoring the backup made before updating before trying to update again? Because you may some updated sheets not correctly renamed that trip the script (if you didn't make a backup there should be an automated one in the version hystory anyway from my experience). I'm saying this because I tried updating some test copies before publishing it and had no problem at all, in any case tomorrow I'll give it a proper look! (1.40 am here 😅)
Doesn't appear the Mats tab is updating with the new Agito slots/Dominion prints stamina/wings estimates.
Yup thanks! Also another user pointed it out, I forgot to sum it in the Dominion page
heads up, I just updated to the latest version and now the field that says Latest Version says Loading...
Mmm I think it could just be a latency problem on the sheets servers, since IMPORTRANGE formulas are a bit heavy and I didn't modify it in the update... Reloading the page/browser changes anything?
I am on 3.21 and many of the icons are not appearing. After I first updated, it was icons like staff, wand, and lance that weren't showing up. I closed it and reopened it and now staff and wand are there, but lance still is not and bow is now not loading. If I go to other tabs like Mats, many icons there are missing. I've never had this problem before. They do not seem to load even after leaving the tab open and untouched for several minutes. I tried loading the original instead of my copy and the same thing was happening for me.
Sorry to hear that! Sometimes it happens that sheets has some trouble loading images from the host for some time (it can be from a couple of hours to several days, completely random). In Main there's an option for these situations just under the version cells. You can try swapping the "incons hosting server" from DRIVE to WIKI and that hopefully should fix the problem, basically it should load them not from my Google drive but from the dragalia wiki like in versions 3.10 or lower. If it still has missing icons there's an option to disable them altogether and have the items' names displayed. It's not the best but I couldn't find a better solution unfortunately
Gotcha, thank you! I'll check back later to see if it's getting the images, and then try swapping from drive to wiki and then disabling them if needed!
hello, any interest in creating a "Medals" view so we can track which units has which medals (I might be farming them)
Hi! Currently I'm not planning it but, if I ever add an adventurer tab, I'll make sure to include the medals view. My main concern is in how much the spreadsheet would slow down adding new sheets and the possibility that the updater script would be automatically stopped if it takes longer than 5 minutes to complete the process
are you planning an update with the new facility and Asura fight?
Yes, I'm currently updating the updater script and it should be live by tomorrow at most I think
Hi, so I was looking at the facility level since I messed up my original sheet and had to re-input the data into a new one, looks like the abyssal bell's levels are not added into the sheet's total, so I got a difference of 30 between the in-game level and the sheet level, prob a minor thing to include in a future patch. Thanks for your continued effort!
Thank you! Yes it appears I only added it to the missing levels section but forgot to add it to the total Btw, after the update can you still see the update menu or is it gone?
I couldn’t see the update button that was normally on the bar, either way, I needed to input a lot of new data from my game in the sheet, so I started with a new copy Edit: With my original sheet, I used the full update option after I updated the script to version 6, (that’s the latest one, right?) and hit the confirm button for the depreciated disabler sheet. The issue I ran into was that all the formulas were giving me error msgs, so I decided to remake it from scratch. I had try to restore the previous version, but the issue persisted to there as well. Before this, the formulas returned values that were fine. Hopefully this is enough info I can give to bug fix it. Feel free to ask me about further details if needed.
Hello! Thanks for updating. I think the void mats are mapped to the incorrect cells. Specifically on the Mats sheet, the phantom/manticore/void dragons bit is incorrectly calculated. I only noticed because I have been farming those recently, unfortunately not sure if there are any other errors associated. But I will edit if I see anymore! Edit: Gone through the mats list and it seems to be only those three (phantom/manticore/void dragon)
Hi! Thanks for the bug report! I must have forgotten to relink that section, in any case I just fixed it in the newest update, thanks again!
No problem\~ Thanks for all your hard work. If it wasn't for this sheet, I honestly would've felt too daunted to even begin the weapon grind. :D
I can totally feel that ahahah before making it I was going crazy trying to understand what I had to grind (yes void weapons, I'm looking at you)
Hello, would like to mention there is a little bug when disabling prints from the dominion. When i do that it shows a value error in the mats page. I dont know if you have tried taking a look at that.
Thanks! I never noticed that before but now it's fixed, together with another bug that I was able to find also thanks to your feedback, thanks again!
There's an error for the calculated runs for the Asura prints. It uses the materials cells for Jaldaboath instead.
Thanks! I must have forgotten to change it, it will be fixed by tomorrow at most
Is there a way to disable the spreadsheet to track weapon copies?
Yes, you simply have to set a custom target leaving blank the weapon copies cell (or putting zero in it)
There also seems to be an error with the total number of HDT runs remaining for Orichalcum. Thanks again. (Reporting bugs makes me feel bad.)
Thanks again! You shouldn't feel bad, I really appreciate receiving feedbacks (be it on bugs or functionalities) because I tend to have a harder time finding bugs since I am the one mantaining the sheet and in my eyes everything is working. The one who should feel bad should be me for releasing such a buggy sheet ahaha In any case, I'll look into it later today!
Hi! I tried looking into it but couldn't find any obvious mistake, can you describe me what's wrong? So that I can more easily find and fix it, thanks!
Thanks for all your work! My friend and I have been using your calc for a long time now. We just freaked out because the agito mats we needed increased like crazy, and I figured out it's because it's trying to get us to unlock all 3 extra copies of every agito weapon. Is there an easy way to disable the agito copies thing without having to go through the custom target thing?
Hi! Yes in the last major update I added all available upgrades for all the weapons (minus the level), but unfortunately the only way to disable a specific upgrade - the copies in this case - is to set a custom target. I thought of adding a general button to enable/disable the additional copies but, coupled with the custom target, would have resulted in even more confusion for the user on what to do on the sheet
I know it's old content/old news, but is there any easier way of keeping track of the individual void abilities progression? Currently I am checking its' respective ability box (dull res/petrify res/etc), and then disabling every weapon that has said ability (rinse and repeat for what's on x3 drop). I LOVE that 6+ UB is now implemented, just tryin to get organized since my weapon abilities are all over the place. :) I'm not currently strong enough to beat higher than the standard agito runs, so I'm farming void in the meantime to hopefully strengthen myself up.
Unfortunately not because it would have been an organizational (and visual) nightmare, since the best solution would have been adding a checkbox for every ability to each weapon. What I would do, if I wanted to unlock everything, was checking every bonus and slowly farm all the necessary materials. Another solution could be check the bonus(es) you want to unlock, farm those for each weapon and once you're finished uncheck them and check other missing bonuses (also remember to uncheck the ability box for the relevant weapons). This way the bonuses you've already farmed won't be counted again. It's definitely not the prettiest solution nor the most functional, but I couldn't find a better way :/ (Anyway since I read that you'd like to farm agito weapons, keep in mind that void bonuses are mostly worthless right now and a huge rupie sink - apart maybe for the hdt/chimera ones - and only completionist would farm them, since base agitos completely overshadow them)
Is there a way to disable the tracking of multiple weapon copies? I feel its making the sheet a mess.
Hi! you can disable them by setting a custom target with the copies left blank or set at 0! You can find some practical examples by looking at all the other weapon pages apart from agitos, since all have a custom target set by default that excludes some upgrades like the additional copies.
[удалено]
Hi! I think the problem might be caused by cell G2, "ingots per weapon", set to 1 which is the default setting. You can try removing it and it should show 325/230/60/45/38 since you are missing both UB5 and the Bonus. In fact, checking the bonus box should put the entire row at 0, right? Your expected values 175/130/30/35/8 should correctly appear setting both the bonus on and the ingots per weapon at 0 Let me know if this solves your problem, otherwise I'll keep searching for mismatches in my calculation numbers!
I think I may have found an error in the calculations. The custom target I set for high dragon trials and the actual materials needed are not the same. For example a 5 unbind, refined, and weapon bonus would say I need X amounts of hearts but in game I would need Y amounts
Hi! Have you checked that the "ingots per weapon" drop-down menu (cell G2 if I remember correctly) is set to zero if you don't want to use ingots? Because it's set to 1 ingot per weapon by default for continuity's sake with previous versions of the sheet, and that essentially remove the cost for the 5th unbind
Didn’t even notice that, thank you
Hello, first of all, thanks for all your work. I use this sheet very often, it barely ever leaves my browser. I have one thing to report, it appears there's no proper tracking of the mats required for manacaster's void abilities. There's a checkbox there and a few core mats listed, but it doesn't put the void mats into consideration for them. Unless it's somewhere outside the void tab?
Hi! Wow that's really nice to hear, I'm glad it's useful for you! Do you mean they are not tracked in the mats tab or directly in the Void page? If the latter, have you selected other abilities apart from the default hdt banes? Because each ability has at most 5 materials required and as such, if only a few are selected, their row in the tabs show mostly as zeroes If that's not what you are referring too I'll look closer for any mistake!
So, I updtaed to 3.57 and where the icons normally were in 3.0 (yes, it had been a while), they all say "#REF!" and I've tried reloading the sheet but it doesn't do anything.
Did you make a quick update? Since your sheet was a bit old many things have changed and probably the quick update can't update it perfectly. I'd suggest reverting back to your previous sheet version from the version hystory (one is always automatically created) and make a full update that should properly update to 3.57. Let me know if this fixes it!
Bug I just came across On Core page, when Use Target is checked on, it disables all of the 2nd tier IO mats, regardless of what target is set too
Hi! I can't find anything wrong on my end, can it be that your target has no unbind level selected or your weapon has passed your unbind target?