QA/PI and Med Error Calculations

0
How do you calculate your unit's medication error rate for your QA/PI program? All I can think of is errors/number of times medication is supposed to be given. This is so tedious per patient in an excel spreadsheet. How are you all calculating this for reporting? We use paper MARS and cannot get statistics from pharmacy or our Pyxis.