Forum Discussion
07_19
Apr 07, 2020Iron Contributor
High CPU usage because of service worker (sw.js)
Since the last update, almost each time I close a tab, Edge starts to take a lot of CPU.
In the browser task manager, I see that it's the service worker that cause this : it's written either "service worker " or I can see the url of the page I just close appended with a "sw.js"
This also happens when I open/close a new tab or even an extension (rss, password manager...)
I have disabled the setting : Allow recently closed sites to finish sending and receiving data (recommended) but this didn't change anything.
Version 83.0.467.0 (Official build) dev (64-bit)
Hi there,
So I took a stab at it and looked like you were doing a lot of manual things to get the calculations going. First thing I did is change up the formulas in column E,I, L, & P. I put in an index/match formula that will crawl through the "Factors" sheet to find the respective CO2 emissions (factors 1 & 2). With different data entries, you'll need to update these values for the fields in the raw data to compute properly. Secondly, because there are mulitple methods of transportation that vary from 1 - 4 selections, I added in a column (R) to find the main method of transportation (I used the max time of commute among the values in the row). Column R will spit back the main method of transportation. And lastly (regarding the column changes), added in 1s for column T to count the unique survey participants.
I formatted everything as a table, so the pivot will reference the table instead of a range (this will help you avoid having to update the pivot range each time an entry is made).
If you enter in new data, just click the refresh button on the data tab.
I would recommend that you finalize the survey and export in the rawest form and then build formulas around on new columns on the right. That will make it much easier if you anticipate thousands of incoming surveys.
The pivot chart will show the total CO2 emission by individuals (using their primary form of transportation) along with the count of survey takers. You could also show averages, but in this case, I think sheer volume might be the way to go. Secondary axis will show the count of unique survey takers.
Try keying in data and then hitting refresh to make sure things don't break. The "Factors" sheet will be your source of truth so anything missing will throw off the calculations (i.e., adding in a new type of transportation without updating the "factors" sheet will break the formulas)
Hopefully this helps, let me know if you have any questions.
6 Replies
Sort By
- Jeff SherCopper Contributor
That's it! I've seen that before, never used it...until now.
Thanks
- Matt MickleBronze Contributor
You're welcome. Always happy to help!