Thank you for your question. I have seen the file you attached and used two formulas to calculate the Amount Covered and the Amount not Covered.
You can write the following formula in Cell C2 to calculate the Amount Covered and then drag the Fill Handle down to copy the formula in the other cells.
Then, I used the following formula in Cell D2 to calculate the Amount not Covered and then dragged the Fill Handle down to copy the formula in the other cells.
=A2-C2
I hope this will solve your problem. I have also attached the Excel file here for your convenience. Please let us know if you face any problems.