API tools faq
paste
Advertisement
Zuleau

D2 Database FAQ

Zuleau
Jan 24th, 2023 (edited)
1,237
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.24 KB | None | 0 0
raw download clone embed print report
  1. ---FAQ---
  2.  
  3. **How exactly is a weapon's score calculated**
  4.  
  5. - I've written up an in-depth explanation of the Calculation here: https://pastebin.com/DByzPtfg
  6.  
  7. ---------------------------------------------------------------------------------------------------------------------------------------
  8. **Wouldn't this be better as a website or app?**
  9.  
  10. - That would be amazing, and if I knew how to create those things then I would!
  11. - I suppose the positives of using a sheet is how instantly everything loads, no adverts etc.
  12.  
  13. ---------------------------------------------------------------------------------------------------------------------------------------
  14. **Can I request access?**
  15.  
  16. - I keep the same sheet running to maintain the same link, I usually test anything new on a copy of the sheet for myself before updating the master sheet. Please make your own copy of the sheet to make your own edits and use the different selector options (link at the top of this post).
  17.  
  18. ---------------------------------------------------------------------------------------------------------------------------------------
  19. **Why does Opponent HP say 192.01, what's the .01?**
  20.  
  21. - This comes from the amazing testing done by Castle and friends; the [video here](https://youtu.be/OtGnq0TH_QM) is well worth a watch.
  22.  
  23. ---------------------------------------------------------------------------------------------------------------------------------------
  24. **What's unique about this?**
  25.  
  26. Here's a few things unique to my sheet that I've not found anywhere else:
  27. - Weapon score calculation (in-depth explanation on the info tab). Piggy-backing off this - the 'best in slot' calculator and auto-best perk picker
  28. - Historical usage data snapshots do see a weapons' usage over time, with snapshots of what the meta was at different points
  29. - Usage data displayed and analysed by not only individual weapons, but also by archetype, ammo type, weapon slot etc.
  30. - The resilience breakpoint finder to display exactly what differences there are between each Resilience level, filterable to the current meta
  31.  
  32. ---------------------------------------------------------------------------------------------------------------------------------------
  33. **Why did you do this?**
  34.  
  35. - Originally this was a project for myself to learn more about advanced Excel and how to use different formula. I absolutely love the Massive Breakdowns and originally just wanted to add a Search function to it, so I started figuring out how I could add a search function, then a comparison function then it just grew from there bit by bit, adding more as and when I wanted to learn something new. I have also learned a bit of SQL with Google Sheets awesome Query function!
  36. - At the stage we're at now, we have a wealth of data to play with, and many possible tools that can be created, so I'll keep going until I run out of ideas!
  37.  
  38. ---------------------------------------------------------------------------------------------------------------------------------------
  39. **When did you start this?**
  40.  
  41. - I started doing this around Jan 2022
  42.  
  43. ---------------------------------------------------------------------------------------------------------------------------------------
  44. **What is the date format?**
  45.  
  46. - Any dates used in the sheet use [YYYY-MM-DD](https://en.m.wikipedia.org/wiki/ISO_8601).
  47.  
  48. ---------------------------------------------------------------------------------------------------------------------------------------
  49. **Can I use the data in my own projects?**
  50.  
  51. - Definitely! This resource is free to use for anyone
  52. - Here's 2 ways to extract the data:
  53. 1. Create a copy of the sheet, copy the full data that you'd like and paste as Values only to avoid copying over all the formula
  54. 2. In a new Google Sheet copy this formula into a cell to pull the data main bulk of the data from the 'STAT LIST' tab: *=importrange("https://docs.google.com/spreadsheets/d/1B2zWeT99SksMzmptNeIt66Mv8YZu38R7t-KR50BJ0p0/edit#gid=817864056","Full Stats List!A2:BG1500")*
  55. - If making a copy of the sheet to work on yourself, make sure to un-hide the hidden tabs, especially the Reference tab, as this feeds most of the data in the sheet
  56. - Let me know if I can help, and if you'd like, let me know about the stuff you're working on, I love that shit :}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!