Formula Chart Challenge

[GB]

Hi,
I have a problem which I can't solve efficiently (but I can solve in some clunky steps). I am asking for your help. The file attached contains all the data and also a copy of the instructions of what I am trying to achieve. Below is a copy of what I am trying to resolve but it won't make too much sense until you see the workbook and the name manager as all cells, ranges are named.

Step 1
From qy and rd worksheet
if qyBeV < qyVal
and rdDate => qyDateFrom
and rdDate =< qyDateTo
and rdValue <= qyValue

then

Step 2
From rd worksheet
get all dates from rdDate that are true.
(at this point we have obtained all dates from the rd worksheet that fall within the date range on qy worksheet that also have a rdValue less than the qyVal)

then

Step 3
From da and qy worksheet
with all dates from step 2
find where daTDTE = qyTDTE
and daDFC = qyDFC

then

Step 4
From da worksheet
now get corresponding daSeries, daLevel, daAmount

then

Step 5
Create a Chart (of your choice)
Series name = daSeries and dalevel
Series X Values = =FCC.xlsx!daDate
Series Y Values = =FCC.xlsx!daAmount

I look forward to any response.
regards
GB