Getting values using my iterative calculations

I have attached an excel file as well as a word document with some formulas. The excel file I have attached is a condensed version of the original and in order to get back to the original, on Sheet1, you need to select A3 to CZ2001 and use the fill feature to fill down.

Next you need to copy the first array formula, that has a summation, from the word document into Sheet1!BW2001. Then you need to use the fill feature to fill right from BW2001 to CB2001, in sheet1. Next you need to copy the second array formula, that has a summation, from the word document into Sheet1!CC2001. After that you need to use the fill feature to fill right from CC2001 to CH2001, in sheet1. Then you need to copy the third array formula, that has a summation, from the word document into Sheet1!CI2001. Next you need to use the fill feature to fill right from CI2001 to CN2001. Also make sure you have Iterative Calculations enabled as in my original excel document I have iterative calculations enabled and the question I am about to ask involves iterative calculations.

I tried selecting BW2000 to CN2001 and using the fill feature to fill up but I got an error message in the form of #NUM! in all the cells involved in the group of iterative calculations when I did that, so I undid that as it's impossible to get ride of an error message in a group of iterative calculations without redoing the entire group of iterative calculations. I want to select from BW2 to CN2001 and use the fill feature to fill up but I'm not sure how to get actual values as opposed to an error message doing that. How do get values when I fill the formulas in columns BW to CN from row 2001 up to row 2, and get values from the formulas involving iterative calculations?