question

Aries Vash avatar image
0 Likes"
Aries Vash asked Aries Vash commented

Is it possible to create a custom chart in the dashboard?

Hi, I need help on the following, is it possible to create a custom chart in the dashboard using the following formula below?

Define the variables:

  1. 1. LC (Labour count is a constant given number)
  2. 2. Standard Efficiency divider = 233
  3. 3. Actual Manpower (Number of operators in the model)
  4. 4. Production Hour (Simulation time/hour)
  5. 5. Output (where output of the end queue)


Formula:

Ideal Time = LC * 233 / Output

Actual Production Hour = Actual Manpower * Production Hour


In the dashboard, calculate:

Efficiency = Ideal Time / Actual Production Hour


Example:

LC = 1.3

Standard Eff Divider = 233

Actual Manpower = 2

production hour = 1 hour

Output = 292 pieces


Ideal Time = 1.3 * 233 / 292 = 1.037

Actual Production Hour = 2 * 1 = 2


Efficiency = Ideal Time / Actual Production Hour = 1.037/2 = 0.518 or 51.8%


1690168512380.png

Custom Dashboard.fsm

FlexSim 19.2.4
dashboard display
1690168512380.png (23.7 KiB)
· 3
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Felix Möhlmann avatar image
1 Like"
Felix Möhlmann answered Aries Vash commented

It looks like all you have to do is divide that value by the current model time (in hours). You can do that directly in the Calculated Table with a custom expression metric.

1690458401872.png

Then add a base chart of your chosen type and choose the Calculated Table as data source.

Though I have some doubts whether your formula is correct. Why would the efficiency drop if the output goes up?


1690458401872.png (5.1 KiB)
· 6
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.