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?
