Hello
i was wondering if you can help me with my dilemma. i run a small website with a small team of just two people, but i want to make sure they are updating our main attraction on the homepage regularly and be able to track that meticulously. this main attraction is square shaped and consists of about 30 slides users can flick through and each slide offers different content.
my request is, can we build an excel sheet where all team members can go in and have for example each slide number on column A from 1 to 30. then there would be a timer for each slide and a checkbox or a button beside each timer.
what i imagine the solution to track their updates without putting extra effort on them, is have them go to that excel sheet click on the button or mark the check mark beside each slide name and the timer would reset to zero and start counting the time between each click on the button.
and to help me track efficiency the excel sheet would record the period between each click for each slide by day and mark the cell in red if the time went over a specific limit.
sorry for such a long message, i'm not even sure if this is the best visualization to what i'm trying to achieve. if you have any ideas or examples to help, please share them with me.
Thank you!
i was wondering if you can help me with my dilemma. i run a small website with a small team of just two people, but i want to make sure they are updating our main attraction on the homepage regularly and be able to track that meticulously. this main attraction is square shaped and consists of about 30 slides users can flick through and each slide offers different content.
my request is, can we build an excel sheet where all team members can go in and have for example each slide number on column A from 1 to 30. then there would be a timer for each slide and a checkbox or a button beside each timer.
what i imagine the solution to track their updates without putting extra effort on them, is have them go to that excel sheet click on the button or mark the check mark beside each slide name and the timer would reset to zero and start counting the time between each click on the button.
and to help me track efficiency the excel sheet would record the period between each click for each slide by day and mark the cell in red if the time went over a specific limit.
sorry for such a long message, i'm not even sure if this is the best visualization to what i'm trying to achieve. if you have any ideas or examples to help, please share them with me.
Thank you!