Freelancer : imfarrukh47
Partager :
Signaler la proposition

improved template

hi, i improve the template: following changes has been made: image 1 analysis sheet -- automate all false alarm calculations. 2 auto calculate percentage of false alarm by each model, 3 percentage of the cause of each alarm (highest, which cause most alarms), 4 the total number of alarms by both models. 5 major cause of alarm. ----- image 2 datasheets. I slightly change the design. I add a dropdown list for each model column and cause column so that no item is left behind due to spelling error because these two columns are used to calculate values on the analysis sheet. ------ image 3 comparison sheet. I add conditional formatting so that for each advantage it will auto color the cell green and for each disadvantage it auto color red --- hopefully, you like this. i am also figuring out how to improve it further

Proposition n°20 du concours Creating Excel templates for smart tracking
Proposition n°20

Tableau de clarification publique

  • blui88
    blui88
    • il y a 1 mois

    Always Welcome. :)

    • il y a 1 mois
  • blui88
    blui88
    • il y a 1 mois

    Heartiest Congratulations to become a winner. :)
    All the best.

    • il y a 1 mois
    1. imfarrukh47
      imfarrukh47
      • il y a 1 mois

      thanks

      • il y a 1 mois
  • imfarrukh47
    imfarrukh47
    • il y a 1 mois

    analysis sheet update
    https://drive.google.com/file/d/1EqP61-ckaTrBH84XoP-shIga-MyW7PnW/view?usp=sharing

    • il y a 1 mois