d2jsp
Log InRegister
d2jsp Forums > d2jsp > Ladder Slasher > ++ New Events ++
Prev1435436437438439967Next
Add Reply New Topic New Poll
Views: 263292Replies: 9662Track Topic
Member
Posts: 40,183
Joined: Apr 29 2006
Gold: 20,826.51
#4361
Jul 14 2020 02:26pm
Quote (schmoogalaboo @ Jul 14 2020 10:00pm)
https://docs.google.com/spreadsheets/d/1ntOvUpY8ZOvFhXOOyPVLIoZCgiDG-AIh4IT1AzbnUWo/edit?usp=sharing

This is what I have. Maybe if it's going to be a public document, I'll take the time to make some formatting changes or add color to make it prettier if it isn't just me looking at it anymore


Thanks for that, I took a very brief look at it and maybe look at it more, but within the first 5 or 6 columns, I noticed there were 3xx% mods and each time there were only 5 mods

Not sure if you can use "VLookup" & "if" statements at the end of each column adding up how many "Cells" have content.

Quote (ahs_darkhunter @ Jul 14 2020 10:15pm)
Ah alright, makes sense. So 7x monsterdif plz :P
So we would have to check if on several events with just 5 or 6 stats, one or two of them were higher than usual. Doesnt have to be higher as the double roll could be low as well

Cute list!

Nic got a point as well.. if double roll is possible there should be 4 mods or less at some point


I think Nic has a point as well... the minimum amount shown can still be 5 and 7 being maximum, I will take a look at the list later on to see if there are any 6 mod Events (doubt it though, since I noticed 3xx mod maybe an answer this)
Member
Posts: 4,104
Joined: Apr 30 2007
Gold: 7,189.25
#4362
Jul 14 2020 02:48pm
Quote (izParagonzi @ 14 Jul 2020 16:26)
Thanks for that, I took a very brief look at it and maybe look at it more, but within the first 5 or 6 columns, I noticed there were 3xx% mods and each time there were only 5 mods

Not sure if you can use "VLookup" & "if" statements at the end of each column adding up how many "Cells" have content.


I was thinking about doing something like that along with adding a column for maximum value that has been seen so far, but I was thinking it would be best added into the first couple frozen columns
Member
Posts: 40,183
Joined: Apr 29 2006
Gold: 20,826.51
#4363
Jul 14 2020 03:00pm
Quote (schmoogalaboo @ Jul 15 2020 08:48am)
I was thinking about doing something like that along with adding a column for maximum value that has been seen so far, but I was thinking it would be best added into the first couple frozen columns


Sounds great, once you have completed the code (VLookup / If statement etc) in one of the cells, you can easily just Drag (copy) & drop (paste) it across every column instead of individually copy / paste. (I guess you already know this though)

This post was edited by izParagonzi on Jul 14 2020 03:01pm
Member
Posts: 4,104
Joined: Apr 30 2007
Gold: 7,189.25
#4364
Jul 14 2020 03:51pm
Quote (izParagonzi @ 14 Jul 2020 17:00)
Sounds great, once you have completed the code (VLookup / If statement etc) in one of the cells, you can easily just Drag (copy) & drop (paste) it across every column instead of individually copy / paste. (I guess you already know this though)


Excel 101 ;)
Member
Posts: 19,051
Joined: Apr 29 2005
Gold: 2,578.08
Trader: Trusted
#4365
Jul 16 2020 07:20am
16x Transmuting Experience,
11.11% Faster Transmuting,
+10% to Proficiency Cap Per Fight,
+26% Map Final Chest Quality,
25% Faster Cooking,
29.87% Faster Glyphing
Bonus Event in progress for 3 days, 23 hours


This post was edited by Mezzer69 on Jul 16 2020 07:21am
Member
Posts: 50,172
Joined: Mar 19 2006
Gold: 4,082.59
#4366
Jul 16 2020 07:23am
Quote (Mezzer69 @ Jul 16 2020 06:20am)
16x Transmuting Experience,
11.11% Faster Transmuting,
+10% to Proficiency Cap Per Fight,
+26% Map Final Chest Quality,
25% Faster Cooking,
29.87% Faster Glyphing
Bonus Event in progress for 3 days, 23 hours


so another bad event for people who want to gain muting prof and it's for 4 days to top it off

at least it think the 16x muting exp is for char level and not muting level if i remember correctly
Member
Posts: 52,947
Joined: Nov 2 2007
Gold: 273.10
#4367
Jul 16 2020 07:25am
Quote (low-ki @ Jul 16 2020 09:23am)
so another bad event for people who want to gain muting prof and it's for 4 days to top it off

at least it think the 16x muting exp is for char level and not muting level if i remember correctly


well game up
Member
Posts: 61,015
Joined: Jan 31 2008
Gold: 1,500.55
#4368
Jul 16 2020 10:59am
Quote (low-ki @ 16 Jul 2020 06:23)
so another bad event for people who want to gain muting prof and it's for 4 days to top it off

at least it think the 16x muting exp is for char level and not muting level if i remember correctly


Damn.. Was excited at first about the muting
Member
Posts: 4,104
Joined: Apr 30 2007
Gold: 7,189.25
#4369
Jul 16 2020 11:36am
Quote (Linux @ 16 Jul 2020 12:59)
Damn.. Was excited at first about the muting


It's amazing how fast you can climb 1-71 just from transmuting
Member
Posts: 7,692
Joined: Mar 30 2006
Gold: 1,765.30
#4370
Jul 16 2020 01:23pm
Quote (low-ki @ Jul 16 2020 04:23pm)
so another bad event for people who want to gain muting prof and it's for 4 days to top it off

at least it think the 16x muting exp is for char level and not muting level if i remember correctly



This and the last event are not bad for muting.....it just means you can and should mute higher items.
Really liked the last muting event here as it allowed me to mute better essences for the same time/xp as my normal range....so dont understand the hate
Go Back To Ladder Slasher Topic List
Prev1435436437438439967Next
Add Reply New Topic New Poll

© 2003-2026 d2jsp  Contact