“All of the calculations were correct for step increases, benefits. It’s just that the Excel calculations within a couple of different sections were incorrect, and so it wasn’t giving us the right total at the bottom of the spreadsheet.”

County Sheriff Bill Benedict said the net effect of the mistake was that budget lines for personnel were reduced by 10 percent to 12 percent.

“We did some forensics,” Benedict said Wednesday. “The spreadsheets were emailed back and forth between us and [County Administrator] Jim Jones’ office. Because of some cutting and pasting, not all the formulas were pasted correctly. It was an unintended error.”

In the future, Benedict said he would “take a hard look” at all of the personnel forms at the beginning of the budget cycle in July and compare year-over-year salary schedules to ensure that the forms are populated correctly.

“This was an error that was generated through two departments working together,” Benedict said in a telephone interview.

“It was the proverbial computer glitch. I’ll certainly take responsibility for it, but I don’t think anything is going to be gained by looking back.”

At the work session, Benedict said he calculates his department’s “burn rate” every month to keep spending in line with the budget.

“The only number I want to see at the end of each month, or each quarter, is how much of our projected budget have we burned through, and does that match where we are in the calendar,” Benedict said.

By the end of January, budget lines for personnel in the sheriff’s office were considerably higher than the baseline.

“I thought, ‘Holy crap this isn’t right,’ ” Benedict told the board.

Benedict said he rarely negotiates for personnel costs in the budget process because salaries and benefits are driven by union agreements and government programs.

“I don’t have any control of Medicaid,” he said.

Commissioner Bill Peach said he examined the worksheets and determined that “the issue was the transferring of data and also transferring equations.”

“I think a lot of us can look in the mirror and say, ‘Well, gee, we should have caught that,’ ” Commissioner Randy Johnson said.

“Here’s the thing is, yeah, we should have, but it’s worked,” said Benedict, an 11th-year sheriff.

“It’s worked for 10 years. It’s been fine. We haven’t had this. But then it’s one of those things, maybe the fact that it worked so well in the past led us to be complacent.”

County Budget Director Debi Cook said she, Hoffman and Koon “have had lots of conversations about how we’re going to do things differently and better.”

“We’re just going to do a better job of double checking each other and more communication,” Cook said.

During public testimony the next day, Creasey asked commissioners to ponder two questions: Would the board have made different budget decisions had it known the “true magnitude” of the projected deficit, and who will be accountable for the mistakes?

“Errors happen,” Creasey said. “Mistakes are made. We are all human. But at some point, the county’s tolerance for sloppy work cannot stand.”