Forum Discussion
Calculate battery power used
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.
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.
Like this do you mean?...
https://crownequipmentcorporation-my.sharepoint.com/:x:/g/personal/ian_james_crown_com/EeYSGwvz5mpKsrQ2EqE5g08BICRCo10jHKLclywQOCptdA?e=4OIsDM