If nothing else, I would love people to include one is these with their build videos, especially if you need to farm for certain pieces. Would make a nice reference.
Returning player here, until now i used the build planner from mxswat took that data and inserted it in my own spreadsheet. This is a 2in1 and MUCH LESS work ❤ The only thing i miss from my own spreadsheet is one DPS number which shows the average DPS over the mag taking crit chance and headshot „chance“ in to the equation. But if the tables are editable i can add that by myself 😊
I haven’t tried adding a headshot chance but there is an ‘on/off’ headshot drop-down. It’s tough to know what the realistic chance of a headshot would be due to it being partly down to the player’s ability
@@Scooby_VI i know its hard to assume the average player (nearly impossible) for the majority it completly depends on the players abilities. I for myself did run a test with no damage talents (which could get body shots close to headshot damage (high optmist stacks on body vs. low optimist stacks on head could get really close and mix up the numbers) on a standard highend build to get stacking mechanics out the way. Damage numbers in chat turned on. I ran a few floor 10 in summit and a few more CPs. My headshot % ranged from ~ 25-35% AK-M + TKB -> F2000 + Famas. After that i put 30% as the middle of that range as my „average“ and never tested again. I know this changes even for myself based on the environment, star alignment and so on 😅 Don‘t get me wrong here, i appreciate your and the former work on this spreadsheet - it‘s amazing!!! I would add a cell where i put in the headshot „chance“ and one more with the formula to get my mixed crit/headshot average DPS. All numbers needed are already there. But its down to the player to be honest with himself (better test it). Headshot % tested in the range on 5m doesn’t count either :D Edit: I hope my german autocorrect didn‘t mess up the english grammar to badly.
@@fanaticmd3032 That makes perfect sense. You sound more than capable of doing this yourself, but I had a play with it. If you format a new cell as a percentage to use as your HS chance, you can use that to calculate average DPS (Headshot and Normal) by using the below formula: =(HLOOKUP('Main Build'!$AM$18,Calculations!G275:J282,8)* [HS PERCENTAGE] )+HLOOKUP('Main Build'!$AM$18,Calculations!G289:J295,7)*(100%- [HS PERCENTAGE] ) Hope that helps
@@Scooby_VI that helps alot, i‘m not that good at excel. I can setup/build formulas and so on but i don’t know all tricks and shortcuts in excel. My formula would‘ve been way more clunkier than yours. Thanks a lot, now i only need to find a good place for this (when i’m back home), without messing up the whole layout 🫣😅
@@fanaticmd3032 No worries! You could replace the standard Burst DPS field already there with this. There is also a blank space to the right of Burst DPS that would be a good area for the ‘HS chance’ field to go :) Also the “[HS PERCENTAGE]” in the formula will need to be replaced with the cell that you decide to use for the HS chance%
Why can't I choose a second attribute for the Side Arm? I have the Px4 Storm Type-T with one core attribute and two attributes. This only allows me to select one attribute. Also, I saw no way to choose this for mods for my Striker Drone: 20% Scan Range and 3% Damage Reduction. Looking at Skill Attr it seems the assumption is that it is not even possible to put those mods on it.. although I have them.
I'm sorry for not knowing this , I'm on a 38'' Ultra-wide monitor , 3840x1600 resolution , a lot of this app doesn't fit very well , any tips on making it fit the view more like yours thanks for this video and keeping this project alive
No worries! Hmm, I’m not sure the best way of doing that. I just experiment with different zoom levels on the page until everything is visible width-wise
Hi Scooby, really awesome work that you have done. Iam a german Content Creator for the Division and i would like to translate everything to German, can i do that, and if so, how do i do that :D
Hi! Of course! The original version was Japanese and was later translated to English. I’m not sure what the easiest way to do this would be, but if you select File > Make a Copy on the spreadsheet you can get an editable copy that can be changed this way. The best way would probably be using the Google Sheets ‘Find / Replace’ feature with the “Also Search Within Formulas” option to replace words and phrases - as many of the calculations are using references to the pages and words. I hope that’s of some help!
In theory, yes - but it’s a bit of a pain. It will function the same way from a phone, but unfortunately Google Sheets doesn’t adjust its size and scaling for smaller screens, so it’s very fiddly to use
The calculations apply for consoles too if consoles have the same game version. If you meant to open the spreadsheet on a console i would say its not possible.
I disagree, especially since you have the choice to not use this at all. The game isn’t very good at telling players what items are better than others and what builds can do more than others. That’s fine for the most part, but a lot of players want to know what works best for the job they are using it for. When it comes to farming: to me, this is a way of planning out a build first, then looking for those pieces when I know what I’m after
Lol looks like not but that surprise me most is that some players care about the numbers lol. I dont pay attention to that as long my build kill like nothing and i can survive is enough for me lol
This is wild how you did this on a sheet!!! That’s insane
This is dope sir, thank you 🙏🏻 doing the RNGesus’s work
This is absolutely insane!! Y’all some geniuses
If nothing else, I would love people to include one is these with their build videos, especially if you need to farm for certain pieces. Would make a nice reference.
Thank you for picking up the reins on this massive project ScoobyVI! I will use this tool a LOT!!!
Thank you for the updated spreadsheet, love using it. Much appreciated
The TD2 community is still amazing, thank you :)
Scooby you absolute babe! I didn't even know something like this existed. Thank you so much!
WoW, this is going on my Clan Page, hats off to you
Duuude, thank you! So eloquently explained!
Amazing work 👍👍👍 Very helpful!
Brooo, you've given us the keys to the god damn kingdom!!
I really needed this, thanks!!
Thank you bro it’s really very useful
Returning player here, until now i used the build planner from mxswat took that data and inserted it in my own spreadsheet. This is a 2in1 and MUCH LESS work ❤
The only thing i miss from my own spreadsheet is one DPS number which shows the average DPS over the mag taking crit chance and headshot „chance“ in to the equation.
But if the tables are editable i can add that by myself 😊
I haven’t tried adding a headshot chance but there is an ‘on/off’ headshot drop-down. It’s tough to know what the realistic chance of a headshot would be due to it being partly down to the player’s ability
@@Scooby_VI i know its hard to assume the average player (nearly impossible) for the majority it completly depends on the players abilities.
I for myself did run a test with no damage talents (which could get body shots close to headshot damage (high optmist stacks on body vs. low optimist stacks on head could get really close and mix up the numbers) on a standard highend build to get stacking mechanics out the way.
Damage numbers in chat turned on.
I ran a few floor 10 in summit and a few more CPs.
My headshot % ranged from ~ 25-35% AK-M + TKB -> F2000 + Famas.
After that i put 30% as the middle of that range as my „average“ and never tested again.
I know this changes even for myself based on the environment, star alignment and so on 😅
Don‘t get me wrong here, i appreciate your and the former work on this spreadsheet - it‘s amazing!!!
I would add a cell where i put in the headshot „chance“ and one more with the formula to get my mixed crit/headshot average DPS.
All numbers needed are already there.
But its down to the player to be honest with himself (better test it).
Headshot % tested in the range on 5m doesn’t count either :D
Edit: I hope my german autocorrect didn‘t mess up the english grammar to badly.
@@fanaticmd3032 That makes perfect sense.
You sound more than capable of doing this yourself, but I had a play with it.
If you format a new cell as a percentage to use as your HS chance, you can use that to calculate average DPS (Headshot and Normal) by using the below formula:
=(HLOOKUP('Main Build'!$AM$18,Calculations!G275:J282,8)* [HS PERCENTAGE] )+HLOOKUP('Main Build'!$AM$18,Calculations!G289:J295,7)*(100%- [HS PERCENTAGE] )
Hope that helps
@@Scooby_VI that helps alot, i‘m not that good at excel.
I can setup/build formulas and so on but i don’t know all tricks and shortcuts in excel. My formula would‘ve been way more clunkier than yours.
Thanks a lot, now i only need to find a good place for this (when i’m back home), without messing up the whole layout 🫣😅
@@fanaticmd3032 No worries!
You could replace the standard Burst DPS field already there with this. There is also a blank space to the right of Burst DPS that would be a good area for the ‘HS chance’ field to go :)
Also the “[HS PERCENTAGE]” in the formula will need to be replaced with the cell that you decide to use for the HS chance%
Thank you, but if u could help me... I made a copy but cannot use... Need a permition.
Wow never knew this existed.
I’m the 13th subscriber, thanks!
nice ! i'll try it
Why can't I choose a second attribute for the Side Arm? I have the Px4 Storm Type-T with one core attribute and two attributes. This only allows me to select one attribute. Also, I saw no way to choose this for mods for my Striker Drone: 20% Scan Range and 3% Damage Reduction. Looking at Skill Attr it seems the assumption is that it is not even possible to put those mods on it.. although I have them.
Is there a way to account for different pieces having different levels of expertise?
Unfortunately not at the moment. It is something I’ve thought about adding in the future, but I haven’t got back to the To-Do list for a little yet
@@Scooby_VI If you ever need or want help, I’d be happy to contribute a bit of time. You’ve done some great work so far.
Thank you
I'm sorry for not knowing this , I'm on a 38'' Ultra-wide monitor , 3840x1600 resolution , a lot of this app doesn't fit very well , any tips on making it fit the view more like yours thanks for this video and keeping this project alive
No worries!
Hmm, I’m not sure the best way of doing that. I just experiment with different zoom levels on the page until everything is visible width-wise
@@Scooby_VI Okay thank you !
Hi Scooby,
really awesome work that you have done.
Iam a german Content Creator for the Division and i would like to translate everything to German, can i do that, and if so, how do i do that :D
Hi! Of course! The original version was Japanese and was later translated to English.
I’m not sure what the easiest way to do this would be, but if you select File > Make a Copy on the spreadsheet you can get an editable copy that can be changed this way.
The best way would probably be using the Google Sheets ‘Find / Replace’ feature with the “Also Search Within Formulas” option to replace words and phrases - as many of the calculations are using references to the pages and words.
I hope that’s of some help!
Can I use from a phone ?
In theory, yes - but it’s a bit of a pain.
It will function the same way from a phone, but unfortunately Google Sheets doesn’t adjust its size and scaling for smaller screens, so it’s very fiddly to use
@@Scooby_VI thank you 🙏🏽
Can you please update it i love it but i cant use ouro😢
@@Chasethedummy Hmm, Ouroboros should be there? It's right at the bottom of the SMG list
@@Scooby_VI yep sorry realized i was on an outdated version thats my bad
For PC players only ?
Dam, i usually just jam a bunch of stuff together and hooe itnworks.
This is for PC or can this be use on console as well ?
As far as I know the spreadsheet can only be used on PC sadly
The calculations apply for consoles too if consoles have the same game version.
If you meant to open the spreadsheet on a console i would say its not possible.
How to use game itself to create a build and learn about items, this creators only killin fun from farmin items :D
I disagree, especially since you have the choice to not use this at all. The game isn’t very good at telling players what items are better than others and what builds can do more than others. That’s fine for the most part, but a lot of players want to know what works best for the job they are using it for. When it comes to farming: to me, this is a way of planning out a build first, then looking for those pieces when I know what I’m after
gg
🤦🏽♂️🤷🏽♂️ don’t nobody read their own builds huh 🤔
Lol looks like not but that surprise me most is that some players care about the numbers lol. I dont pay attention to that as long my build kill like nothing and i can survive is enough for me lol
@@nikotearcangel numbers that’s all it about in this game but to get there also have to read on how it works.
Comentário vindo daquele tipo de jogador que não sabe como a construção dele funciona.🤡
waste of time
Useless
Sorry bro