Unknown User2
Walking Challenge Results Report Template | Excel Summary Table That Automatically Calculates Participation Rate, Achievement Rate, and Daily Flow
2026.10.19 16:20
Challenge ยท Data ยท Excel Summary Table
Walking Challenge Results Report Template | Excel Summary Table That Automatically Calculates Participation Rate, Achievement Rate, and Daily Flow
Walking Challenge Result Transcription Method: A free Excel template that automatically organizes participation rates, achievement rates by condition, and daily trends simply by pasting the target participants and daily step counts.
Once the walking challenge ends, the person in charge must finalize the reward recipients and report the results. The aggregation structure used by Nudge EAP when organizing challenge results Excel template that the person in charge can use immediately It has been moved to [Settings]. If you enter the standard value in [Settings] and paste the step count in [Participant Input], the results table will be automatically completed.
View at a glance
Participation rate is calculated based on the target, and achievement rate is calculated based on the number of participants. Separating these two denominators alone makes walking challenge result reporting more accurate and concise.
Participation rate is calculated based on the target, and achievement rate is calculated based on the number of participants. Separating these two denominators alone makes walking challenge result reporting more accurate and concise.
๐ Attachment ยท Walking Challenge Results Summary Table.xlsx
It consists of 5 sheets: Writing Guide / Settings / Participant Input (Max. 300 people ยท 30 days) / Aggregation (Automatic) / Daily Flow (Automatic).
Download Excel Summary Table โ๐งญ Usage sequence ending in 3 steps
Step 1 Setup โ Enter the target number of people, start date, number of operating days, daily recognition limit, period target, and number of certification criteria in the light yellow box.
Step 2 Paste โ Paste the daily step counts for each participant downloaded from the app into the [Participant Input] sheet. We recommend using a random number instead of an employee ID for the participant code.
Step 3 verification โ Check the participation rate, achievement rate, and days when steps were skipped in the [Aggregation] and [Daily Flow] sheets, and transfer them to the report.
๐๏ธ Sheet Composition | Here's how to use it
| sheet | Work | Input status |
|---|---|---|
| Writing Guide | Usage order, reporting tips, privacy precautions | Read only |
| setting | Target number of personnel, start date, number of operating days (max. 30 days), daily recognition limit, period target, number of certification criteria occurrences | light yellow box input |
| Participant Input | Participant code, number of authentications, daily steps (max. 300 people) | Paste |
| Aggregation (Automatic) | Participation rate, number of people/proportion achieved by condition, mean/median | Do not edit |
| Daily Flow (Automatic) | Average recognized steps per person per day, number of people reaching the limit | Do not edit |
Columns after the operating days and non-numeric cells (e.g., โ-โ) are automatically excluded from the calculation, even if the table downloaded from the app contains blank spaces or symbols. To prevent the recognized step count from being inflated I made it.
๐ Automatically calculated indicators and denominators
| characteristic | Calculation criteria | Tips for reporting |
|---|---|---|
| Participation rate | Number of participants รท Number of target participants | Specify the scope of application (regular, contract, dispatch) together |
| Recognized steps | Only up to the daily limit is recognized for aggregation | Displayed as โrecognized valueโ rather than โactual step countโ |
| Step achievement rate | Percentage of participants whose recognized steps โฅ period goal | Participant-based ratio |
| Certification achievement rate | Number of authentications โฅ Standard number of authentications | Check the participation flow by watching with at least one person. |
| Achievement rate of two conditions | Achieved both steps and verification | Basis for Calculating Compensation Quantity |
| Daily flow | Average number of recognized steps per person per day | Automatically display days more than 20% lower than average |
The daily average per person is calculated by dividing by the total number of participants, so participants with no record for that day are counted as 0 steps. Therefore Weekends, holidays, and the last week You can see at a glance the sections where your step count slows down. Please look at these sections first when determining the duration and timing for the next round.
How should we set the target number of steps for the next round?
Based on the aggregated results, we will redesign the daily limit, period target, and number of certifications to suit your organization.
View Nudge EAP Health Challenge๐งพ Please transcribe it into the results report in this order.
| order | Values โโto retrieve from the summary table | Report sentence example |
|---|---|---|
| โ Scale | Number of participants, participation rate | โ out of โ participants (โ% of the target) |
| โก Achievement | Steps, Certification, and Achievement Rate of Both Conditions | โ% of the participants met both conditions |
| โข Flow | Displayed dates of daily flow | โ The average number of steps per person takes a break on the weekend of the week |
| โฃ Compensation | Personnel meeting both conditions | โ people confirmed for compensation |
| โค Next round | Conditions where the achievement rate was low | Review of adjustments to certification frequency and duration |
๐ก Tips for Reporting Walking Challenge Results
Participation rate and achievement rate side by side, denominator in parentheses
If 15% of the target participated and half of the participants achieved the goal, please write them together as โParticipation Rate 15% (based on target), Achievement Rate 50% (based on participants).โ Simply not mixing the two numbers ensures the result is conveyed accurately.
If 15% of the target participated and half of the participants achieved the goal, please write them together as โParticipation Rate 15% (based on target), Achievement Rate 50% (based on participants).โ Simply not mixing the two numbers ensures the result is conveyed accurately.
The achievement judgment is based on the recognized value.
If a daily limit was set, to meet the reward criteria, it is not the actual number of steps Recognized steps Calculate whether it has been achieved. For challenges without certification conditions, set the certification threshold in [Settings] to 0.
If a daily limit was set, to meet the reward criteria, it is not the actual number of steps Recognized steps Calculate whether it has been achieved. For challenges without certification conditions, set the certification threshold in [Settings] to 0.
The compensation list and summary table for reporting are separate.
It is recommended to use arbitrary codes instead of employee IDs and names in summary tables, and to write only aggregated figures in reports to management.
It is recommended to use arbitrary codes instead of employee IDs and names in summary tables, and to write only aggregated figures in reports to management.
๐ ๏ธ This is how Nudge EAP operates
Compilation using the same framework โ Organize into the same structure of participation rate, achievement rate by condition, and flow by date to make it easy to compare between rounds.
Reflecting client standards โ If separate reward criteria are established, achievers are recalculated according to those criteria.
Next round design โ Connect the days when the step count was inactive and the conditions with a low achievement rate to the goal, certification, and period adjustment plan.
Q. Can I use challenges longer than 30 days?
We recommend splitting the file into 30-day units or converting it to weekly totals for input.
Q. Can I paste the file received from the app as is?
You can paste it exactly as is, arranged in the order of Participant Code 1, Authentication Count 1, and then Steps by Date.
โ Checklist Before Reporting Results
- โ Is the target number in [Settings] within the same range as the actual eligible participants?
- โ Did you separate the denominators of the participation rate and the achievement rate in the report?
- โ Did you use the recognized value instead of the actual number of steps to determine achievement?
- โ Did you note down the dates your step count dropped and the reasons?
- โ Did you leave only a random code on the tally sheet instead of a name and contact information?
Recommended Posts
I tried a walking challenge at two general hospitals | What was harder than 100,000 steps was the 'certification' โ
How to Run the Walking Stamp Challenge | Spring Walking Challenge Where 6 Out of 10 Participants Achieved Rewards โ
The harder you walk, the greater the reward | Public enterprise walking challenge where more than half of achievers walked to higher levels โ
๐ A walking challenge that carries the results to the next round
Nudge EAP manages design, operation, result aggregation, and improvement plans for the next round together in the same data structure.
View Nudge EAP Walking Challenge โ Inquiry about Challenge Implementation โThis document is a general form to assist in compiling walking challenge results. Challenge results may vary depending on the size of the organization, work style, and operating period.
Health Management | psychological counseling | Safety Management | Organizational culture | greeting
๋์งEAP(๊ด๋ฆฌ์)'s Expert Column
- Safety and Health Training for Rehired Employees After Resignation | Where to Check Training History Again
- Role Chart for Pre-Return to Work Checklist | HR, Health Managers, Department Heads, and Medical Staff
- Procedures Before Return to Work for Employees on Health Leave | Distinction in the Roles of Medical Opinions, Interviews, and Assessment of Work Suitability
How was this expert column?
Comments2
Most Engaging Posts in the Community
- 0160026.10.22
- 0260026.10.22
- 03CommentsWe also have a lot of short-term contract workers during peak season, so I get confused every time I have to handle the training for rehired employees. I'm also curious how other places handle cases where contracts are renewed immediately without any gaps.132226.10.21
- 01coach AnswerHello, this is Nudge EAP โบ๏ธ You should group tasks based on whether the actual work type and conditions are the same, rather than the process name. Tasks can be considered the same if the worker posture, number of repetitions and time, handling weight and frequency, movement, and equipment and tools are similar. Therefore, even within the same assembly process, it is better to separate "seated assembly" and "standing assembly while moving materials" into separate tasks. First, list the detailed tasks within the process and compare them using the criteria above; separating only the tasks with significant differences makes organization easier, even with a large workforce. If there are multiple tasks under the same conditions, you can select a representative sample that includes the worker with the highest workload. The KOSHA guide suggests using at least two tasks with high work intensity as a sample when there are 10 or fewer identical tasks. Shifts can be grouped together if the equipment, workload, speed, and personnel are the same, but if the conditions differ, please separate them by shift. For rotation workers, you can make a judgment by recording all detailed tasks performed during the day, along with the time and frequency of each. For the final classification, confirm the opinions of on-site workers, and if you record the basis for the grouping on the survey form, it will be easier to explain during inspections.753326.09.18
- 02CommentsThe distinction between receiving a report and reaching a conclusion is important. Global HR teams should secure immediate protection and confidentiality before trying to decide whether the conduct legally qualifies as harassment.734426.09.02
- 03coach AnswerHello, this is Nudge EAP.โบ๏ธ The simplest method is for employees to simply receive guidance and apply directly, as the company does not transfer personal information. If you want a health manager to forward a name and contact information to an EAP agency for contact, it is safer to explain the receiving agency, purpose, items, retention period, and the right to refuse consent, and to obtain clear consent from the individual. Since checkup results and symptoms are sensitive health information, do not consider them included in the existing health checkup consent; instead, please write down only the content to be conveyed and obtain separate consent. In practice, it is common to separate the options into โ consent for forwarding name and contact information and โก consent for forwarding checkup results and symptoms, ensuring that there is no disadvantage in using the EAP even if the second option is not agreed to. The burden of repeating explanations can be reduced by providing the option for employees to send a summary of their consultation request, written directly by the employee, to the agency. However, since the wording and procedures may vary depending on whether the contract with the EAP agency involves the outsourcing of personal information processing or the provision of information to a third party, please review the contract details with your in-house personal information manager before implementation. It is a good idea to define the scope of responses in advance to the company to prevent unnecessary feedback regarding consultation requests or their content.668926.09.21
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 04
- 05
- 06
- 07
- 08
- 09
- 10