574441_en-US

liliconcom

Find a way to determine the length of an data extract

Hi all, 

 

I am trying to find a way to determine the length of a charge session of an EV.

In the data you can see different vehicles which are charged from a start SoC to an end SOC.

Now I am trying to find a way for a fomula, that gives me the length of the charging procedure for the different vehicles / power outputs.

I started to pre-select the SOC to be between 20 and 60%. With the column max - cloumn min the solustion works fine for ONE occasion (i.e. vehicle / power output) - is there a way to also do it for all of the single combinations car /power output?

Please find data sheet attached.

Data TableOtherScriptingRe: Find a way to determine the length of an data extract

You can use Fahrzeug and Powerlimit as byVar in your formulas

 

Re: Find a way to determine the length of an data extract

The Col Maximum() and Col Minimum() support By variables, so you can just add them to your calculation of the range t20 bis t60

Col Maximum( :t20 und t60, :Fahrzeug, :Power Limit )
- Col Minimum( :t20 und t60, :Fahrzeug, :Power Limit )

Re: Find a way to determine the length of an data extract

This sounds interesting, thanks @jthi  for the graph. @tbps - Maybe there is a presentation here.