REDCap End Survey Calculation Tool

Model survey stopping rules before final publishing decisions. Review score thresholds, exclusions, and completion risk. Download CSV or PDF reports for clear documentation today.

Calculator

Formula Used

Eligible Started = Started Surveys − Consent Denied − Duplicate or Excluded

Response Rate = Started Surveys ÷ Invited Records × 100

Started Completion Rate = Completed Surveys ÷ Started Surveys × 100

Valid Completion Rate = Valid Completed Records ÷ Eligible Started × 100

End Survey Rate = Ended by Survey Logic ÷ Eligible Started × 100

Required Field Completion = Answered Required Fields ÷ Required Fields × 100

Score Percent = Calculated Score ÷ Maximum Score × 100

Target Gap = Valid Completion Rate − Target Completion Rate

How to Use This Calculator

Enter the total invited records and the number of surveys started.

Add completed, partial, excluded, consent denied, and end logic records.

Enter required field counts to review form completeness.

Add the calculated score, maximum score, cutoff, and rule type.

Press calculate to view the result above the form.

Use CSV or PDF buttons to save the report.

Example Data Table

Scenario Invited Started Completed Ended Score Cutoff Rule
Eligibility Screening 500 310 220 50 7 8 Less than cutoff
Safety Trigger 400 260 190 35 12 10 Greater or equal
Consent Review 250 140 100 18 5 5 Equal cutoff

About This Calculator

A REDCap end survey action can stop a survey when a rule is met. This calculator helps plan that rule before launch. It checks score cutoffs, survey outcomes, completion rates, and data quality signals. It is useful for screening surveys, consent checks, eligibility reviews, and follow up workflows.

Why End Survey Logic Matters

End survey logic protects participants and saves review time. A project may need to stop a form when consent is denied. Another project may stop the survey when an eligibility score is too low. Some teams also stop surveys when a safety score reaches a high value. The rule should be clear before data collection starts.

Key Metrics Reviewed

The calculator separates invited records, started records, completed records, partial records, and ended records. It also reviews exclusions, duplicate responses, and consent denials. These values show whether the survey flow is balanced. A high end survey rate may be correct. It may also signal a strict cutoff or confusing question design.

Score Based Decisions

The score section compares the entered score with the cutoff. You can choose whether the survey should end below the cutoff, at or above the cutoff, or only at the exact cutoff. The result explains whether the action should trigger. It also shows the score percent and the gap from the cutoff.

Completion Planning

Completion rate is a core measure for survey quality. This tool compares valid completion rate with your target rate. It also estimates total completion time and incentive cost. These values help teams plan staffing, recruitment, and monitoring needs.

Data Review Notes

Before publishing a project, compare the category totals with the started records. If the entered categories exceed starts, the tool flags the totals for review. This does not replace REDCap testing. It supports a careful prelaunch check.

Best Practice

Test several examples before enabling the survey. Try scores just below the cutoff. Try scores equal to it. Try scores above it. Confirm that the final action matches the protocol. Save the exported report with project notes. Clear documentation helps audits and later team handoffs. Use the notes during weekly checks. Update thresholds only after protocol approval, stakeholder review, and validation testing in a copy project first.

FAQs

What does end survey logic mean?

It means a survey can stop when a defined rule is true. The rule may use a score, answer choice, consent response, or eligibility condition.

Can this calculator replace project testing?

No. It supports planning and review. Always test the actual project, branching logic, survey queue, and end action before collecting real responses.

What is eligible started?

Eligible started means started surveys minus consent denied records and duplicate or excluded records. It helps show a cleaner completion base.

Why is the valid completion rate useful?

It measures completed surveys against eligible started records. This can be more useful than a raw completion rate when exclusions are present.

What score rule should I choose?

Choose the rule that matches your protocol. Use less than cutoff for low eligibility. Use greater or equal for risk or threshold triggers.

Why does the data status show a warning?

The warning appears when category totals exceed started surveys. Review the entered counts. A response should not usually be counted in multiple final categories.

Can I export the result?

Yes. After calculation, use the CSV or PDF buttons. The exported report includes key metrics, decision text, and review notes.

Is this only for REDCap surveys?

It is designed around REDCap style survey planning. You can also use it for similar survey systems with score cutoffs and stopping rules.

Related Calculators

Paver Sand Bedding Calculator (depth-based)Paver Edge Restraint Length & Cost CalculatorPaver Sealer Quantity & Cost CalculatorExcavation Hauling Loads Calculator (truck loads)Soil Disposal Fee CalculatorSite Leveling Cost CalculatorCompaction Passes Time & Cost CalculatorPlate Compactor Rental Cost CalculatorGravel Volume Calculator (yards/tons)Gravel Weight Calculator (by material type)

Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.