Automated Simograms Solved

Question

Hello everyone,

I need help with an Excel file. It contains 3 flowcharts, corresponding to 3 different positions.
Each position has its input data corresponding to the different tasks to be performed, indicating whether this task is manual (Tm), technical-manual (Ttm), or technical (Tt).
In the attached file, everything is written out, nothing is automated. I have filled in the cells of my flowcharts myself.

My wish is that when I change the duration of an input data, the flowchart updates automatically (either through conditional formatting or a macro – it doesn’t matter).
Additionally, for some positions, tasks are simultaneous to "save" time.

Displaying the duration of a cycle is a plus but is not a priority.

Thank you in advance for your help and feedback!

(Attached is the file in question: https://www.cjoint.com/c/JFzpyqpxOhp)

Best regards,
Peybernes

Raymond PENTIER · Accepted Answer

Hello.

Interesting exercise!
So far, I've managed to complete what was necessary for the first two simograms.
Let me know if this is what you wanted before I tackle the third one...
You'll notice that I'm using column E, which was fortunately available, and cells C8 and C16.
https://www.cjoint.com/c/JFzxo4Laj6w
--
Retirement is nice! Especially in the Caribbean... Raymond (INSA, AFPA)

Raymond PENTIER · Answer

Finally, the third one wasn't that much more difficult to complete... https://www.cjoint.com/c/JFzx7si8uZw  Best regards.  -- Retirement is great! Especially in the Caribbean... Raymond (INSA, AFPA)

peybernes · Answer

Hello,

Thank you very much for your help, which is immensely useful to me!!
This solution suits me perfectly!

I just had one point to clarify regarding the simograms; when I change the duration of the input data, there is sometimes a "shift" with the expected result.

I have attached an example in the attached file: https://www.cjoint.com/c/JFAnaLc5qip

Thanks again!

Best regards

Raymond PENTIER · Answer

Hi.

Yes ... you are absolutely right: I had only tested one data change; it worked, and I was satisfied ... fatal mistake!
So I've started over, and this time it should fit all scenarios.
https://www.cjoint.com/c/JFAxfIkEqVw

But be careful if you copy the file, or if you want to modify it:
The formulas in G7, H7, G15, and H15 are specific and different from those in the following cells.
For the conditional formatting, the formulas have been completely changed.

I hope you will be satisfied with the final result.

--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)

ccm81 · Answer

Hello

> Raymond: Friendly hello
I tested your file, I found two cases where the result is not as expected
https://mon-partage.fr/f/CvLcZE6z/
On my side, my old Excel 2003 only allows me 3 rules for conditional formatting, so I started working on a macro solution... to be tested of course
https://mon-partage.fr/f/wifBeKmX/

Best regards

Raymond PENTIER · Answer

Hello peybernes.  I must thank you for giving me the opportunity to do a fun exercise, as unusual as it was.   As a reward, here is a final version, where the vertical reminder lines (blue axis line and red dashed line) are drawn by the software, as well as the cycle duration range (lines 9, 17, and 27). I spent time on it, but I really enjoyed it. https://www.cjoint.com/c/JFCvY2J1Tzw Thank you again.  -- It's nice, retirement! Especially in the West Indies... Raymond (INSA, AFPA)

ccm81 · Answer

Hi Raymond  Great job I've finally realized that my old Excel completely goes haywire with "all" your conditional formatting.  Have a great day

Automated Simograms

7 answers

Wi-fi connection

A company legally obliged to dump its production to its rivals

Line height not remembered in calc

I no longer have the "birthday" calendar in thunderbird

Error message during et2861 driver installation

Activation of the esu program for updates on windows 10

Update w10 kb5122878 impossible

Xelitan pdf reader: a lightweight, ad-free alternative to acrobat

How to type the at symbol (@)

Ephemeral messages