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

Windows 10 to 11 + bios change

Many f a i offer a €2 subscription and the card €1"

Fraud related to the new european small parcel tax

The impôt.gouvn identifier is no longer offered on edge

Be able to use google play apps on huawei

Ami, the app to centralize your administrative processes

Vba macro repeat action until end of document

How to turn on a kobo e-reader

Helpsoft driver updater impossible to uninstall!!!

Ink absorber