ethercalc | Node.js port of Multi-user SocialCalc | Runtime Evironment library

I have a excel file having Summary and Details records

** here is a excel fiddle ** https://ethercalc.org/t42iqg64tj8p

What I need is that on Summary table, Location 0, Location 1 and Location 2 is calculated.

So I have to lookup into details by ID and Date and Location and get do MAX(Value) - MIN(Value).

So for example if I filter Details by ID 1 and Date 04/09/2019 by Location 0 and get Max Value I should get: 2

and Min Value should get: 1.1

..so result of MAX - MIN should be 0.9

I have tried VLOOKUP and MAX with nested IF statements but dont know how.

Any clue

Given the following spreadsheet of data: https://ethercalc.org/q7n9zwbzym5y

I have the following code that will parse this and will derive a tree from the parent-child relationships in the sheet. Note that fact that every column occurs twice is because the first instance of the columns is for another type of data, I am only concerned with the populated columns. This is the desired output from the sheet above:

Code:

I have the following lookup sheet (named "Formatting"): https://ethercalc.org/zs2n0j4u9xdi

I'm iterating over a column in a different sheet, where I'm getting values that are equivalent with those in the "item" column above. I want to look up these nicknames into the sheet above, and acquire the two values to the left of them, and store them in two variables:

This is my code which gets me these "items":

I have the following sheet of data: https://ethercalc.org/zeacfw3jskc3

The important thing about this data is that every column is repeated twice, one for type-A data, one for type-B. If there is no data in the first set of columns (up until revision), I want to create my range using the second rather than having the code fail. This is the code that attempts to do so:

So I'm recursively writing some text to a sheet. In another sheet, I have all those text values in a column of another sheet, where the column to the right contains the respective rename and formatting of the text values I have. This is an example: https://ethercalc.org/46ky7t3kbik1

How can I reference this "Formatting" sheet, to get the value and formatting of the cell to the right of every cell I can map to?

I have the following input & output data (Sheet1 from 1-19, Sheet2 from 21+, followed by output) https://ethercalc.org/bzrwyz8bsail (Note that the children are aligned to the right instead of having 2 spaces which is the formatting the script does)

I have the following VBA script which parses the parents and items and writes to Sheet 2:

Please see this link: https://ethercalc.org/lh8gegksrlnn

I am looking for a formula to get the daily # of points, as well as the daily # of calls.

My data is in the long format (as required to do the grouped barplot), so that the values for different categories are in one single column. The data is here.

Now, a standard barplot with ggplot2 orders the bars alphabetically (in my case of country names, from Argentina to Uganda). I want to keep the order of countries as it is in the dataframe. Using the suggestion here (i.e. ussing the limits= option inside the scale_x_discrete function) I get the following graph:

My code is this: