
KQM | Genshin Impact
laggy-erc-with-sim-embeded-into-a-sheet
146 messages

TiBotSat, January 14, 2023 at 12:07 AM
@rarepossum - As an author, it is your responsibility to complete the ticket
Guidelines
- You can rename your ticket with
- If this ticket was created by accident or it can be deleted, you can use
- When you are ready to submit the ticket, compile everything into one message following the format below and pin it. Then type
- To add contributors to your ticket you can use
- The ticket will be scrapped if: no activity >1 week or open for >1 month.
Guidelines
- You can rename your ticket with
/rename <ticket name>
or with the button below- If this ticket was created by accident or it can be deleted, you can use
/delete
within the first 5 minutes, otherwise ask a Scholar.- When you are ready to submit the ticket, compile everything into one message following the format below and pin it. Then type
/close
or click the button below; the ticket will automatically be moved to be reviewed.- To add contributors to your ticket you can use
/contributor add <user>
.- The ticket will be scrapped if: no activity >1 week or open for >1 month.
Write-up Format
Theory/Finding/Bug: Title of your submission
Evidence: Explanations with calculations and/or YouTube/Imgur proofs
Significance: Conclusion
Evidence: Explanations with calculations and/or YouTube/Imgur proofs
Significance: Conclusion

rarepossumSat, January 14, 2023 at 12:09 AM
I hath created an erc which uses a monte carlo simulation to more accurately determine thresholds to be able to burst 80% of the tiem (or whatever you want)
https://1drv.ms/x/s!Ap7IaLqG1nQsrmust_so0wQ7axAk?e=TeUlI2
https://1drv.ms/x/s!Ap7IaLqG1nQsrmust_so0wQ7axAk?e=TeUlI2
montecarloerc.xlsx
Microsoft Excel Workbook
Featuring:
- should be a more accurate erc overall
- percentage funneling
- adding paimon as a teammate, disabling electro resonance but increasing the off field energy mod
- a terrible interface
- some other stuff I can't remember
- noticable lag during inputs because its running 4K iterations
- should be a more accurate erc overall
- percentage funneling
- adding paimon as a teammate, disabling electro resonance but increasing the off field energy mod
- a terrible interface
- some other stuff I can't remember
- noticable lag during inputs because its running 4K iterations
will migrate to google sheets when done
still need to to do a how to use page for this mess
and some tools like raiden refund and that jaz
ALso nothing is a turret anymroe

wrong pingSat, January 14, 2023 at 01:24 AM


wrong pingSat, January 14, 2023 at 01:25 AM

4k iterations in google sheets

rarepossumSat, January 14, 2023 at 01:25 AM
Not my problem
it doesnt need solver
so its fine
1


the lit | Hear Me OutSat, January 14, 2023 at 03:08 AM
can you explain how this is more accurate 

it probably is but im failing to understand how monte carlo sims would be necessary for accurate energy sims

rarepossumSat, January 14, 2023 at 03:09 AM
Its more accurate when you want a conservative guess
so for example with the main erc
its just an average
you set it to safe
it lowers the average
but it does it in a method which isnt particualrly accurate
with some characters being more or less penalised than others
Yae for exmaple is penalised extremely heavily for being a turret, even though she has no variance in particle gen
Similarly turretns in general are pretty in accurate

the lit | Hear Me OutSat, January 14, 2023 at 03:11 AM
wait what 


rarepossumSat, January 14, 2023 at 03:11 AM
For example guoba is modelled as a turret, so his paticles will get funnelled based on field time
but its 100% possible to funnel guoba

the lit | Hear Me OutSat, January 14, 2023 at 03:11 AM
ah

rarepossumSat, January 14, 2023 at 03:11 AM
at least I think hes modelled as a turret

the lit | Hear Me OutSat, January 14, 2023 at 03:12 AM
ye he is

rarepossumSat, January 14, 2023 at 03:12 AM
this means taht character may be getting particles when they shouldn't be
or characters aren't getting enough particles

the lit | Hear Me OutSat, January 14, 2023 at 03:12 AM
so is no one a turret now

rarepossumSat, January 14, 2023 at 03:13 AM
Yeah, but you can keep them as turrets if you want
with work arounds
but it allows for more accurate, if more hassel
But the main thing is you can determine how much er you would need to burst with 0%, 25% 50% 75% 80% or 100% consistency (assuming fav procs as stated and you hit all your abilities)

the lit | Hear Me OutSat, January 14, 2023 at 03:14 AM
interesting

dont fully get it but this is really interesting

rarepossumSat, January 14, 2023 at 03:15 AM
This is replicating the erc's "safe mode"
but without the arbitrary penalities

the lit | Hear Me OutSat, January 14, 2023 at 03:16 AM
okay 

so just
now noticably accurate in certain areas
more intensive in all areas?
now noticably accurate in certain areas
more intensive in all areas?


rarepossumSat, January 14, 2023 at 03:17 AM
Yep

Though if you have no turrets
its very simple
also percentage funneling
for when a character funnels to multiple other charactesr

the lit | Hear Me OutSat, January 14, 2023 at 03:18 AM

best@feature
so it really is erc++

rarepossumSat, January 14, 2023 at 03:18 AM
but even uglier
1


the lit | Hear Me OutSat, January 14, 2023 at 03:18 AM
are there any features not present?

rarepossumSat, January 14, 2023 at 03:18 AM


the lit | Hear Me OutSat, January 14, 2023 at 03:18 AM
switch to google sheets 


rarepossumSat, January 14, 2023 at 03:19 AM
I'm planning on adding shit like raiden er restoring calc
klee energy refund chance/average

Mr. Pillow | PhD. in IttoSimpingSat, January 14, 2023 at 03:19 AM
this is basically #alternative-erc but better isnt it 


rarepossumSat, January 14, 2023 at 03:19 AM
Yeah

the lit | Hear Me OutSat, January 14, 2023 at 03:19 AM
whats alt erc even

rarepossumSat, January 14, 2023 at 03:19 AM
monte carlo instead of formula
I worked on taht too


the lit | Hear Me OutSat, January 14, 2023 at 03:19 AM
wait

rarepossumSat, January 14, 2023 at 03:19 AM
well gave feed back on it

Mr. Pillow | PhD. in IttoSimpingSat, January 14, 2023 at 03:20 AM
it can also do "er needed to burst x% of the time" etc.

the lit | Hear Me OutSat, January 14, 2023 at 03:20 AM
what does alt erc do better than erc

the lit | Hear Me OutSat, January 14, 2023 at 03:20 AM


rarepossumSat, January 14, 2023 at 03:20 AM
It attempts the same thing as this
but with formula

the lit | Hear Me OutSat, January 14, 2023 at 03:20 AM
ic

rarepossumSat, January 14, 2023 at 03:20 AM
instead of simualtions

the lit | Hear Me OutSat, January 14, 2023 at 03:20 AM
instead of brute force


rarepossumSat, January 14, 2023 at 03:20 AM
conclusion was, you needed a solver for it to work
so it stalled

Mr. Pillow | PhD. in IttoSimpingSat, January 14, 2023 at 03:21 AM
i'm still waiting for a gcsim erc tho 

gonna ask kyle about it after he completes the histogram request first

rarepossumSat, January 14, 2023 at 03:21 AM
hes already mentioned it
erc.gcsim.app
today actually
Its missing er buffs and doesnt account for fav proc chance though

the lit | Hear Me OutSat, January 14, 2023 at 03:26 AM
was there one previously

rarepossumSat, January 14, 2023 at 03:26 AM
cos I need to figure out how to actually do those

the lit | Hear Me OutSat, January 14, 2023 at 03:26 AM
in the desktop client

SilentSat, January 14, 2023 at 03:27 AM
This is pretty cool, funneling hasn't been implanted yet in this, right?

rarepossumSat, January 14, 2023 at 03:27 AM
They have
theyre just in drop downs

SilentSat, January 14, 2023 at 03:27 AM
Oh

rarepossumSat, January 14, 2023 at 03:27 AM
So you need to expand the groups
cos it gets really long
if you don't collapse them

SilentSat, January 14, 2023 at 03:27 AM
Ooooh I see

the lit | Hear Me OutSat, January 14, 2023 at 03:27 AM
reminding me of gcsim made me understand how this works now
thanks


SilentSat, January 14, 2023 at 03:27 AM
Thank you


unleashurgeekSat, January 14, 2023 at 03:55 AM
how considerate of you to not stack requests

Mr. Pillow | PhD. in IttoSimpingSat, January 14, 2023 at 03:57 AM
it's cuz the latter depends on the former


unleashurgeekSat, January 14, 2023 at 03:58 AM

maybe

twce_Sat, January 14, 2023 at 08:23 PM
Can't you just like
Poke Zak
And make him fix

rarepossumSat, January 14, 2023 at 08:36 PM
Its a flat penality to all turrets, I think its more than a simple fix
thats needed
All Character data in copies should now update if I update the master copy
al haitham and yaoyao should be good now
@charliex3000
👍1

TiBotThu, January 26, 2023 at 04:30 AM
This channel hasn't been active in the past week!


rarepossumTue, January 31, 2023 at 05:55 AM
I;ve added a how to use page now

TiBotTue, February 7, 2023 at 06:00 AM
This channel hasn't been active in the past week!


rarepossumTue, February 7, 2023 at 06:22 AM
Its done, technically
I just need to port it
https://docs.google.com/spreadsheets/d/1xHEy8rz6tz9fNGTpRDGTWOEwT0jfD5xQQlch-iIDGZQ/edit?usp=sharing
montecarloerc
How to Use
Preface
This is an attempt to create a more accurate Energy Recharge Calculator for Theorycrafting Purposes.
It uses a Monte Carlo simulation to simulate all Particle Drops and uses that to determine how much Energy each Character needs
This does mean though, that it does run slower ...
Preface
This is an attempt to create a more accurate Energy Recharge Calculator for Theorycrafting Purposes.
It uses a Monte Carlo simulation to simulate all Particle Drops and uses that to determine how much Energy each Character needs
This does mean though, that it does run slower ...
Ported over to google sheets

charliex3000Wed, February 8, 2023 at 04:32 AM
How... Laggy... Is it in Google sheets?

rarepossumWed, February 8, 2023 at 06:22 AM
I dunno
I was remoting when I did it
But it wasn't that laggy it semed
Its actually pretty smooth
on sheets
rare sheets dub?
Wait no
thats because its not montecarloing at all
1

Alright thats fixed
Takes ~10s on my pc after a change is made
Sheets is a faster by a bit
on my pc anywya
Anyway I think its done

charliex3000Sat, February 11, 2023 at 03:12 AM
Can you set how many iterations it runs?

rarepossumSat, February 11, 2023 at 03:16 AM
I could implement that yes
Sheets now has an interations option
defaulted to 250
now takes 4-5s on my pc, much faster
I think its done

TiBotMon, February 13, 2023 at 09:13 AM
Ticket closed by @rarepossum. If there are any issues with it - it can be reopened by the owner or staff by using the buttons below or
/open
.
charliex3000Fri, March 24, 2023 at 09:15 PMupdate for mika?
✅1

TiBotTue, August 22, 2023 at 10:39 AM
2
Ticket verified by @Shampoo | burger enthusiast

Ticket verified by @🐟
Creating transcript...