http://www.hfma.org/Content.aspx?id=32027#.VgNfflVcR_w.mailto Financial assistance programs IRS rules on hospital FAP’s
You can find the Payer sending the 835 by opening the .835 file in notepad and searching for "N1*PR* You can find the Amount of the total remittance, by searching for "BPR*I"
View this video on how to protect cells in an Excel spreadsheet https://youtu.be/4f1j0oCGeRk
This video shows the use of vlookup with indirect Fx https://youtu.be/0kYzmBncec4
Watch this video on how to create dependent drop-down boxes in excel 2013
Iowa Medicaid Websites IMPA Group Admin manual