I am attempting to forecast claim denials, whether it will ultimately be adjusted off or not. I am running all the data through excel. The information I have is what the denial was, which insurance denied, how much the initial charge was, and how much the adjustment was for. The problem I am running into is how to set up the variables in excel. Any ideas of how to appropriately forecast whether or not the denial will be adjusted off.