yogi_Working With Source Data As A Formula Output In New versus Old Google Sheets - part 1

                                         Google Spreadsheet   Post  #1508
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-31-2014
question by Bee Lini via GMail (https://mail.google.com/mail/u/0/#inbox/143e5a80f84ed371) 

Hi Yogi,

Sorry to bug you with a personal question such as this. I was speaking with Adam Lusk about a project and he referenced you. I was wondering if you could take a peek at my formula. I have spent countless hours trying to find a work around to no avail. It use to work on the old google sheets, but I can't wrap my brain around the current error.

If you could take a look and point me in the right direction, or solve it for me I would be very appreciative.

https://docs.google.com/spreadsheets/d/1nx2suoNLcXmnX19ZE2mCTlsPXEdPJenYeXyZdF2zyXE/edit#gid=1448742359

Hope all is well
--------------------------------------------------------------------------------------------------------------------------------------------------------------
this is setup in Old Google Sheets -- for setup in New Google Sheets see part 2