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.
Like this do you mean?...
https://crownequipmentcorporation-my.sharepoint.com/:x:/g/personal/ian_james_crown_com/EeYSGwvz5mpKsrQ2EqE5g08BICRCo10jHKLclywQOCptdA?e=4OIsDM
I think this might work for you. Adjustments can be made as needed.
Thank you for this but if it were only that easy, I think even I could have done it. I didn't explain my requirement very well I don't think. Take a look at the attached; it will describe my problem.
https://crownequipmentcorporation-my.sharepoint.com/:x:/g/personal/ian_james_crown_com/Efi_TTh-22dKouDDMTDV8U0Bn67PGDGuVAor3gA5x4YrTg?e=jSkNAz
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 doable with an array. Are you using 365? I'll have a formula as soon as I get a spare moment or two to create the formula.