Forum Discussion
Solved
Calculate battery power used
Help please. I have four columns of data with 50k lines. Col1 has an equipment identifier (23 units), cols2 & 3 contain datetime codes for equipment login/logout and col4 holds battery level percen...
This was a fascinating project because MAP was bonking out (I7 processor, 32 GB RAM) with this large data set. I had used MAP to identify the rows where the calculations would run and to help with the subtraction. MAP/INDEX/ROW seems to have limits. I did not try this with insider functions.
I went with simpler dynamic arrays. Ultimately, this data set has to be paired down to perform the calculations.
This is do-able with a formula. Do you happen to have a sample workbook?
I do have a sample sheet but I don't know how to attach it here.
Interesting that you have a drag and drop option below the 'Hint @ links to members' note! Whereas I do not?? Any idea?
- It could be the user level. It seems file upload might be unavailable for newer accounts. You could upload the file to OneDrive or another file hosting site and share the link.