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.
Hello Patrick - I've just spent the day working out what you did 🙂
I have reduced my data down to a month's worth - it was originally an entire quarter. I then made a slight mod because we have an anomaly in our data retrieval system that could mean it is up to 30% out. We just live with it. Other than that it worked very well - Thank you very much - I would never had got to that point on my own.