sheetchanger

SheetChanger action

Create and execute a changesheet action for each sheet in an app. This can be used to cache the inital state for all objects or, by chaining two subsequent sheetchanger actions, to measure how well the calculations in an app utilize the cache.

• thinktimesettings: (optional) Settings for the thinktime action, which is automatically inserted between every changesheet action.
  • type: Type of think time
    • static: Static think time, defined by delay.
    • uniform: Random think time with uniform distribution, defined by mean and dev.
  • delay: Delay (seconds), used with type static.
  • mean: Mean (seconds), used with type uniform.
  • dev: Deviation (seconds) from mean value, used with type uniform.
• continueonerror: Continue changing sheets on errors without breaking execution. ⚠️ this might compound errors. Defaults to false.

Example

Change to all sheets once to calculate states, then once more to get response times with cached initial states

{
    "label" : "Sheetchanger uncached",
    "action": "sheetchanger"
},
{
    "label" : "Sheetchanger cached",
    "action": "sheetchanger"
}

Add a 5-15s think time inbetween each changesheet action.

{
    "label" : "Sheetchanger uncached",
    "action": "sheetchanger",
    "settings": {
        "thinktimesettings": {
            "type": "uniform",
            "mean": 10,
            "dev": 5
        }
    }
}

Only log errors from each sub action instead of breaking execution.

{
    "label" : "Sheetchanger uncached",
    "action": "sheetchanger",
    "settings": {
        "continueonerror": true
    }
}