|
215
|
Preferences.EnergyUnits & " / year"TWh / year3142007201020152020202520302035204020452050
|
216
21INDEX(#REF!, MATCH($C7, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
22INDEX(#REF!, MATCH($C8, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
23INDEX(#REF!, MATCH($C9, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
24INDEX(#REF!, MATCH($C10, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
144INDEX(#REF!, MATCH($C11, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
145INDEX(#REF!, MATCH($C12, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
671SUM(F7:F12)#REF!SUM(H7:H12)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
12INDEX(#REF!, MATCH($C14, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
5INDEX(#REF!, MATCH($C15, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
35INDEX(#REF!, MATCH($C16, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
25INDEX(#REF!, MATCH($C17, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
166F13+F14+F15+F16+F17#REF!H13+H14+H15+H16+H17#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
183MAX(0,H$47-H$18)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
205
6INDEX(#REF!, MATCH($C23, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
18INDEX(#REF!, MATCH($C24, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
7INDEX(#REF!, MATCH($C25, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
8INDEX(#REF!, MATCH($C26, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
9INDEX(#REF!, MATCH($C27, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
10INDEX(#REF!, MATCH($C28, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
11INDEX(#REF!, MATCH($C29, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
38INDEX(#REF!, MATCH($C30, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
239SUM(F23:F30)#REF!SUM(H23:H30)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
56INDEX(#REF!, MATCH($C32, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
33INDEX(#REF!, MATCH($C33, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
172INDEX(#REF!, MATCH($C34, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
37INDEX(#REF!, MATCH($C35, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
173SUM(F33:F35)#REF!SUM(H33:H35)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
155INDEX(#REF!, MATCH($C37, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
158INDEX(#REF!, MATCH($C38, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
58SUM(F37:F38)#REF!SUM(H37:H38)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
159INDEX(#REF!, MATCH($C40, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
156INDEX(#REF!, MATCH($C41, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
111INDEX(#REF!, MATCH($C42, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
200SUM(F40:F42)#REF!SUM(H40:H42)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
157INDEX(#REF!, MATCH($C44, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
160INDEX(#REF!, MATCH($C45, #REF!, 0))#REF!-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
69SUM(F44:F45)#REF!SUM(H44:H45)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
167F31+F32+F36+F39+F43+F46#REF!H31+H32+H36+H39+H43+H46#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
184MAX(0,-(H$47-H$18))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
168
19INDEX(#REF!, MATCH($C52, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
20INDEX(#REF!, MATCH($C53, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
169F47-SUM(F52:F53)#REF!H47-SUM(H52:H53)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
185
|
42INDEX(#REF!, MATCH($C58, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
43INDEX(#REF!, MATCH($C59, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
44INDEX(#REF!, MATCH($C60, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
30INDEX(#REF!, MATCH($C61, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
31INDEX(#REF!, MATCH($C62, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
32INDEX(#REF!, MATCH($C63, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
57INDEX(#REF!, MATCH($C64, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
106INDEX(#REF!, MATCH($C65, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
105INDEX(#REF!, MATCH($C66, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
107INDEX(#REF!, MATCH($C67, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
131INDEX(#REF!, MATCH($C68, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
192INDEX(#REF!, MATCH($C69, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
207INDEX(#REF!, MATCH($C70, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
238INDEX(#REF!, MATCH($C71, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
186SUM(F58:F71)#REF!SUM(H58:H71)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
171F18-F54+F72#REF!H18-H54+H72#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
|
|
217
|
28INDEX(#REF!, MATCH($C80, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!616
29INDEX(#REF!, MATCH($C81, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
187SUM(F80:F81)#REF!SUM(H80:H81)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
2936INDEX(INDIRECT("'"&H$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&H$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&I$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&J$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&K$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&L$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&M$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&N$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&O$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&P$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&Q$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
236-H80-H84#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
237H111#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
|
39INDEX(#REF!, MATCH($C89, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))#REF!
|
174F74+F82+F89#REF!H74+H82+H89#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
188
|
29552007201020152020202520302035204020452050
104INDEX(#REF!, MATCH($C96, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.Matrix"), MATCH($C96, INDIRECT("'"&F$4&"'!Year.Modules"), 0), MATCH($C$95, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.Matrix"), MATCH($C96, INDIRECT("'"&H$4&"'!Year.Modules"), 0), MATCH($C$95, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
117INDEX(#REF!, MATCH($C97, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.Matrix"), MATCH($C97, INDIRECT("'"&F$4&"'!Year.Modules"), 0), MATCH($C$95, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
132INDEX(#REF!, MATCH($C98, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.Matrix"), MATCH($C98, INDIRECT("'"&F$4&"'!Year.Modules"), 0), MATCH($C$95, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
278F96+F97+F98#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
120INDEX(#REF!, MATCH($C100, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.Matrix"), MATCH($C100, INDIRECT("'"&F$4&"'!Year.Modules"), 0), MATCH($C$95, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.Matrix"), MATCH($C100, INDIRECT("'"&H$4&"'!Year.Modules"), 0), MATCH($C$95, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
108INDEX(#REF!, MATCH($C101, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
234INDEX(#REF!, MATCH($C102, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
235INDEX(#REF!, MATCH($C103, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
112INDEX(#REF!, MATCH($C104, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
113INDEX(#REF!, MATCH($C105, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
114INDEX(#REF!, MATCH($C106, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
115INDEX(#REF!, MATCH($C107, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
150INDEX(#REF!, MATCH($C108, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
213SUM(F102:F108)#REF!SUM(H102:H108)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
109INDEX(#REF!, MATCH($C110, #REF!, 0))#REF!INDEX(INDIRECT("'"&F$4&"'!Year.Matrix"), MATCH($C110, INDIRECT("'"&F$4&"'!Year.Modules"), 0), MATCH($C$95, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))#REF!INDEX(INDIRECT("'"&H$4&"'!Year.Matrix"), MATCH($C110, INDIRECT("'"&H$4&"'!Year.Modules"), 0), MATCH($C$95, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
613F99+F100+F101+F109+F110#REF!H99+H100+H101+H109+H110#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!Q111-Q84#REF!
|
614F30-F110#REF!G300H30-H110#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!616
615IF(F113<0,F113+F111,F111)#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
Preferences.PowerUnits&" installed capacity"GW installed capacity2007201020152020202520302035204020452050
104606IFERROR(INDEX(INDIRECT($C117&".info["&H$116&"]"), MATCH("B.02", INDIRECT($C117&".info[Vector]"), 0)), 0)0000000000
6046090000000000
6056110000000000
6036100000000000
120INDEX(#REF!, MATCH($C121, #REF!, 0))#REF!0000000000
108INDEX(#REF!, MATCH($C122, #REF!, 0))#REF!0000000000
234INDEX(#REF!, MATCH($C123, #REF!, 0))#REF!0000000000
235INDEX(#REF!, MATCH($C124, #REF!, 0))#REF!0000000000
112INDEX(#REF!, MATCH($C125, #REF!, 0))#REF!0000000000
350INDEX(#REF!, MATCH($C126, #REF!, 0))#REF!0000000000
351INDEX(#REF!, MATCH($C127, #REF!, 0))#REF!0000000000
352INDEX(#REF!, MATCH($C128, #REF!, 0))#REF!0000000000
114INDEX(#REF!, MATCH($C129, #REF!, 0))#REF!0000000000
150INDEX(#REF!, MATCH($C130, #REF!, 0))#REF!0000000000
1106080000000000
123SUM(H118:H131)0000000000
|
|
125
|
230
1752332007201020152020202520302035204020452050
180INDEX(#REF!, MATCH($C139, #REF!, 0))#REF!
179INDEX(#REF!, MATCH($C140, #REF!, 0))#REF!
1176F182/$F$2050.6828579138027161H182*$H$155/$F$205#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
2INDEX(#REF!, MATCH($C142, #REF!, 0))#REF!3.4882184192791134E-2H183*$H$155/$F$205#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
3INDEX(#REF!, MATCH($C143, #REF!, 0))#REF!0H184*$H$155/$F$205#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
4INDEX(#REF!, MATCH($C144, #REF!, 0))#REF!5.4352073272077611E-2H185*$H$155/$F$205#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
5INDEX(#REF!, MATCH($C145, #REF!, 0))#REF!-2.2259510626399782E-3H186*$H$155/$F$205#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
6INDEX(#REF!, MATCH($C146, #REF!, 0))#REF!2.8590076266100505E-2H187*$H$155/$F$205#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
7INDEX(#REF!, MATCH($C147, #REF!, 0))#REF!0H188*$H$155/$F$205#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
177INDEX(#REF!, MATCH($C148, #REF!, 0))#REF!5.3182960880876672E-2H189*$H$155/$F$205#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
178INDEX(#REF!, MATCH($C149, #REF!, 0))#REF!H190*$H$155/$F$205#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
182INDEX(#REF!, MATCH($C150, #REF!, 0))#REF!H191*$H$155/$F$205#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
59SUM(F141:F148)0.85163925735192203SUM(H141:H150)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
199F194/F2030.82154175185293077(H$194/$F$203)*$H$155#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
232$F$192/$H$192#REF!4211-Q151#REF!
|
460642007201020152020202520302035204020452050
5072SUMIFS(INDIRECT("'"&H$157&"'!Year.EmissionsBySector"), INDIRECT("'"&H$157&"'!Year.Modules"),$C158)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
5173#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
5274#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
53211#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
77279#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
78142#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
79152#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
8087#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
8216#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
8347#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
8427SUMIFS(INDIRECT("'"&H$157&"'!Year.EmissionsBySector"), INDIRECT("'"&H$157&"'!Year.Modules"),$C168)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
8568#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
86319#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
8170#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
147148#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
16361#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
193119#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
59SUM(H158:H174)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
634(H175*(I157-H157))+I175+((I175-H175)*6/(I157-H157))#REF!(I175*(J157-I157-1))+J175+((J175-I175)*10/(J157-I157))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!636
229635I176#REF!J176+I176#REF!K176+J177#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
175209181
180INDEX(#REF!, MATCH($C180, #REF!, 0))#REF!532.63873751129393SUMIFS(INDIRECT("'"&H$4&"'!Year.Emissions"), INDIRECT("'"&H$4&"'!Year.IPCC"), $C180)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
179INDEX(#REF!, MATCH($C181, #REF!, 0))#REF!13.3650064404099#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
1176F180+F181546.00374395170388H180+H181#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
2INDEX(#REF!, MATCH($C183, #REF!, 0))#REF!27.891312059948401SUMIFS(INDIRECT("'"&H$4&"'!Year.Emissions"), INDIRECT("'"&H$4&"'!Year.IPCC"), $C183)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
3INDEX(#REF!, MATCH($C184, #REF!, 0))#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
4INDEX(#REF!, MATCH($C185, #REF!, 0))#REF!43.459166099179903#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
5INDEX(#REF!, MATCH($C186, #REF!, 0))#REF!-1.7798396847837301#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
6INDEX(#REF!, MATCH($C187, #REF!, 0))#REF!22.860229581619201#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
7INDEX(#REF!, MATCH($C188, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
177INDEX(#REF!, MATCH($C189, #REF!, 0))#REF!42.524360000000001#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
178INDEX(#REF!, MATCH($C190, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
182INDEX(#REF!, MATCH($C191, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
59SUM(F182:F189)680.95897200766774SUM(H182:H191)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!636
|
199F192-F189638.43461200766774H192-H189#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!636
|
|
593
594
|
|
220226227226228225
221222223224224202020302050
208777.117669999999980.2*$F203155.423534000000020.66*$F203512.89766220000001
198(31.401/2+6.768)22.468499999999999K205*H151#REF!L205*H151#REF!
59F203+F204799.586169999999920.2*$F205159.917234000000010.66*$F205527.7268722H205/$F$151187.77578959575553I205/$F$151619.66010566599323K151/$H151#REF!M151/$H151#REF!Q151/$H151#REF!
2140.20.20.20.20.20.20.20.20.20.2
2500000000000
|
|
596
|
67
|
2688899596979899100101102
1413040IFERROR(INDEX(INDIRECT($C215&".Outputs["&H$4&"]"),MATCH($D215,INDIRECT($C215&".Outputs[Vector]"),0)),"na")nananananananananana
1413141nananananananananana
1413276nananananananananana
|
4
2183040IFERROR(INDEX(INDIRECT($C220&".Outputs["&H$4&"]"),MATCH($D220,INDIRECT($C220&".Outputs[Vector]"),0)),"na")nananananananananana
2183141nananananananananana
2183276nananananananananana
|
59
2183040H215+H220#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
2183141H216+H221#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
2183276H217+H222#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
|
597598
|
577-(INDEX(INDIRECT(H$214&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(H$214&"!Year.Modules"),0),MATCH("V.03",INDIRECT(H$214&"!Year.Vectors"),0))+INDEX(INDIRECT(H$214&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(H$214&"!Year.Modules"),0),MATCH("V.03",INDIRECT(H$214&"!Year.Vectors"),0)))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
77463INDEX(INDIRECT(H$214&"!Year.Matrix"),MATCH($C232,INDIRECT(H$214&"!Year.Modules"),0),MATCH("V.03",INDIRECT(H$214&"!Year.Vectors"),0))/H$231#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
120INDEX(#REF!, MATCH(C233, #REF!, 0))#REF!-INDEX(INDIRECT(H$214&"!Year.Matrix"),MATCH($C233,INDIRECT(H$214&"!Year.Modules"),0),MATCH("V.03",INDIRECT(H$214&"!Year.Vectors"),0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
104INDEX(#REF!, MATCH(C234, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
8427#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
8216#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
576-(INDEX(INDIRECT(H$214&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(H$214&"!Year.Modules"),0),MATCH("V.04",INDIRECT(H$214&"!Year.Vectors"),0))+INDEX(INDIRECT(H$214&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(H$214&"!Year.Modules"),0),MATCH("V.04",INDIRECT(H$214&"!Year.Vectors"),0)))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
77462INDEX(INDIRECT(H$214&"!Year.Matrix"),MATCH($C239,INDIRECT(H$214&"!Year.Modules"),0),MATCH("V.04",INDIRECT(H$214&"!Year.Vectors"),0))/H$238#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
8568-INDEX(INDIRECT(H$214&"!Year.Matrix"),MATCH($C240,INDIRECT(H$214&"!Year.Modules"),0),MATCH("V.04",INDIRECT(H$214&"!Year.Vectors"),0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
8427#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
149INDEX(#REF!, MATCH(C242, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
575-(INDEX(INDIRECT(H$214&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(H$214&"!Year.Modules"),0),MATCH("V.05",INDIRECT(H$214&"!Year.Vectors"),0))+INDEX(INDIRECT(H$214&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(H$214&"!Year.Modules"),0),MATCH("V.05",INDIRECT(H$214&"!Year.Vectors"),0)))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
77461INDEX(INDIRECT(H$214&"!Year.Matrix"),MATCH($C245,INDIRECT(H$214&"!Year.Modules"),0),MATCH("V.05",INDIRECT(H$214&"!Year.Vectors"),0))/H$244#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
117INDEX(#REF!, MATCH(C246, #REF!, 0))#REF!-INDEX(INDIRECT(H$214&"!Year.Matrix"),MATCH($C246,INDIRECT(H$214&"!Year.Modules"),0),MATCH("V.05",INDIRECT(H$214&"!Year.Vectors"),0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
132INDEX(#REF!, MATCH(C247, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
8427#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
104INDEX(#REF!, MATCH(C249, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
120INDEX(#REF!, MATCH(C250, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
64063763863988899596979899100101102
204H232#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
66H239#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
13H245#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
464
|
|
55788899596979899100101102
465H158-H262#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
466#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
467-H245*H249*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-I245*I249*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-J245*J249*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-K245*K249*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-L245*L249*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-M245*M249*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-N245*N249*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-O245*O249*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-P245*P249*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-Q245*Q249*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!
468-H232*H234*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-I232*I234*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-J232*J234*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-K232*K234*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-L232*L234*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-M232*M234*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-N232*N234*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-O232*O234*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-P232*P234*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-Q232*Q234*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!
469-H232*H233*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-I232*I233*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-J232*J233*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-K232*K233*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-L232*L233*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-M232*M233*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-N232*N233*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-O232*O233*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-P232*P233*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!-Q232*Q233*INDEX(#REF!, MATCH("V.03", #REF!, 0))#REF!
470-H245*H250*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-I245*I250*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-J245*J250*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-K245*K250*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-L245*L250*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-M245*M250*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-N245*N250*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-O245*O250*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-P245*P250*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!-Q245*Q250*INDEX(#REF!, MATCH("V.05", #REF!, 0))#REF!
471SUM(H261:H266)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
55888899596979899100101102
1176H261#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
178252SUM(H263:H266)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
182251H262#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
59H267#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
559595H267/H111#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
599H275*1000#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
560
|
|
206
|
C23N.01#REF!0#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
C24R.01#REF!0#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
C25R.02#REF!0#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
C26R.03#REF!0#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
C27R.04#REF!0#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
C28R.05#REF!0#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
C29R.06#REF!0#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
C30Y.02D30#REF!E300MAX(F30, 0)#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
C32R.07#REF!0#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
279E360#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
D39CoalE390MAX(F39,0)#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
65E430#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
D46Natural gas0#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
D47Total Primary Supply0#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
281MAX(0,F30)+MAX(0,F35)+MAX(0,F37)+MAX(0,F41)+MAX(0,F44)+F23#REF!MAX(0,G30)+MAX(0,G35)+MAX(0,G37)+MAX(0,G41)+MAX(0,G44)0MAX(0,H30)+MAX(0,H35)+MAX(0,H37)+MAX(0,H41)+MAX(0,H44)+H23#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
422Q297/Q296#REF!
60F18+F52+F53#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
|
398
|
282007201020152020202520302035204020452050Preferences.EnergyUnitsTWh
|
151INDEX(#REF!, MATCH($C306, #REF!, 0))#REF!-INDEX(INDIRECT($C306&".Outputs["&H$304&"]"),MATCH($C$304,INDIRECT($C306&".Outputs[Vector]"),0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
129INDEX(#REF!, MATCH($C307, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
191INDEX(#REF!, MATCH($C308, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
117INDEX(#REF!, MATCH($C309, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
132INDEX(#REF!, MATCH($C310, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
133INDEX(#REF!, MATCH($C311, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
134INDEX(#REF!, MATCH($C312, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
124INDEX(#REF!, MATCH($C313, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
126INDEX(#REF!, MATCH($C314, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
127INDEX(#REF!, MATCH($C315, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
140INDEX(#REF!, MATCH($C316, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
149INDEX(#REF!, MATCH($C317, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
153INDEX(#REF!, MATCH($C318, #REF!, 0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
194INDEX(#REF!, MATCH($C319, #REF!, 0))#REF!-INDEX(INDIRECT($C319&".Outputs["&H$304&"]"),MATCH("V.02",INDIRECT($C319&".Outputs[Vector]"),0))#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
59SUM(H306:H319)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
68SUM(H314:H315,H306)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
27SUM(H316:H318,H313,H307)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
212SUM(H308:H310,H319)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
17SUM(H311:H312)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
59SUM(H322:H325)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
|
2050
420453Preferences.EnergyUnitsTWh454455457456458459
161$Q$38#REF!58405SUMIF($H$370:$H$460,$N370,$I$370:$I$460)#REF!SUMIF($J$370:$J$460,$N370,$I$370:$I$460)0O370-P370#REF!IF(Q370=0,"ok",IF(ABS(Q370)=SUM(O370:P370),"ok","error"))#REF!129.496387432148740129.49638743214874
399MAX(Q37,0)#REF!58630#REF!O371-P371#REF!IF(Q371=0,"ok",IF(ABS(Q371)=SUM(O371:P371),"ok","error"))#REF!011.394396627131044-11.394396627131044
162Q40#REF!65404#REF!#REF!#REF!#REF!355.43191795039462355.431917950394560
400MAX(Q41,0)#REF!65418#REF!0#REF!#REF!70070
170Q45#REF!401407#REF!0#REF!#REF!70070
402MAX(Q44,0)#REF!401419#REF!#REF!#REF!#REF!210.8480139335702210.84801393357020
403#REF!+#REF!#REF!40458#REF!#REF!#REF!#REF!86.55506943339304486.5550694333930440
260#REF!#REF!404399#REF!0#REF!#REF!22.59006943339304022.59006943339304
405#REF!+#REF!#REF!404161#REF!0#REF!#REF!63.965000000000003063.965000000000003
406#REF!+#REF!+#REF!#REF!404119#REF!#REF!#REF!#REF!32.94770442824829432.9477044282482940
406#REF!#REF!2041380#REF!#REF!#REF!014.45823092617519-14.45823092617519
407#REF!#REF!204408#REF!#REF!#REF!#REF!551.5637593526618551.56375935266180
418#REF!#REF!6634#REF!0#REF!#REF!15015
58SUM(I370:I371)#REF!20413#REF!#REF!#REF!#REF!350.6393702891703350.639370289170240
65SUM(I372:I373)#REF!66402#REF!0#REF!#REF!214.916488301191630214.91648830119163
401SUM(I374:I375)#REF!13170#REF!0#REF!#REF!82.232541885272198082.232541885272198
14#REF!#REF!45700#REF!#REF!#REF!000
45I386#REF!4083#REF!0#REF!#REF!000
14#REF!#REF!409130#REF!#REF!#REF!#REF!1.70128114852837341.70128114852837340
411#REF!#REF!#REF!#REF!2.20945603704983552.20945603704983550
404#REF!#REF!2044140#REF!#REF!#REF!0100.66839811374751-100.66839811374751
404#REF!#REF!664130#REF!#REF!#REF!0272.59644437905297-272.59644437905297
404#REF!#REF!1315#REF!0#REF!#REF!5.329728000000001105.3297280000000011
404#REF!#REF!36270#REF!#REF!#REF!0355.9804755886297-355.9804755886297
204MAX(-Q37,0)#REF!4121370#REF!#REF!#REF!0186.3002024926071-186.3002024926071
66MAX(-Q41,0)#REF!4121460#REF!#REF!#REF!096.150351350565316-96.150351350565316
13MAX(-Q44,0)#REF!4124160#REF!#REF!#REF!072.906732111649589-72.906732111649589
204-#REF!-#REF!#REF!4104150#REF!#REF!#REF!062.700020025562893-62.700020025562893
66-#REF!#REF!41066#REF!#REF!#REF!#REF!552.17364010502649552.173640105026610
13-#REF!-#REF!#REF!410360#REF!#REF!#REF!0614.65046453115383-614.65046453115383
0-#REF!#REF!410260#REF!0#REF!#REF!000
410#REF!#REF!119620#REF!#REF!#REF!028.046644936214143-28.046644936214143
410#REF!+#REF!+#REF!+#REF!#REF!408401SUMIF($H$370:$H$460,$N402,$I$370:$I$460)#REF!SUMIF($J$370:$J$460,$N402,$I$370:$I$460)#REF!#REF!#REF!297.14903018646385297.149030186463850
410#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!#REF!360#REF!0#REF!#REF!419.988800000000080419.98880000000008
204-#REF!-#REF!#REF!41965#REF!#REF!#REF!#REF!481.57713542622741481.577135426227410
66-#REF!-#REF!#REF!419400#REF!0#REF!#REF!373.873775422388230373.87377542238823
13-#REF!-#REF!#REF!419162#REF!0#REF!#REF!107.703360003839150107.70336000383915
419#REF!+#REF!#REF!408406#REF!0#REF!#REF!59.072098478484804059.072098478484804
419#REF!+#REF!#REF!364120#REF!#REF!#REF!061.288314718968195-61.288314718968195
34#REF!#REF!408417#REF!0#REF!#REF!142.415532524312770142.41553252431277
1#REF!+#REF!#REF!4081650#REF!#REF!#REF!014.302960702035355-14.302960702035355
46#REF!+#REF!#REF!4081640#REF!#REF!#REF!0164.54009825396582-164.54009825396582
2#REF!#REF!40814#REF!0#REF!#REF!000
3#REF!#REF!40845#REF!#REF!#REF!#REF!000
15#REF!#REF!408409#REF!#REF!#REF!#REF!000
408-#REF!#REF!411204#REF!#REF!#REF!#REF!448.34246895228688448.342468952286940
408MAX(-#REF!,0)#REF!412410#REF!#REF!#REF!#REF!927.9827519145847927.98275191458470
408#REF!#REF!3646#REF!0#REF!#REF!000
13-#REF!#REF!411403#REF!0#REF!#REF!182.009517956427690182.00951795642769
411#REF!#REF!1302#REF!0#REF!#REF!000
411#REF!#REF!361#REF!0#REF!#REF!97.390435320000009097.390435320000009
409-#REF!#REF!413
130-#REF!#REF!164
417-#REF!#REF!413
417-#REF!#REF!414
419#REF!#REF!413
419#REF!#REF!414
119-#REF!#REF!413
119-#REF!#REF!414
119-#REF!-#REF!#REF!27
119I401-SUM(I427:I429)#REF!36
408-#REF!-#REF!#REF!413
204-#REF!#REF!413
66-#REF!#REF!413
13-#REF!#REF!413
408-#REF!#REF!414
204-#REF!#REF!414
66-#REF!#REF!414
13-#REF!#REF!414
408-#REF!#REF!415
13-#REF!#REF!415
408-#REF!#REF!416
13-#REF!#REF!416
408-#REF!-#REF!-#REF!#REF!27
204-#REF!-#REF!#REF!27
66-#REF!-#REF!#REF!27
13-#REF!-#REF!-#REF!#REF!27
408-#REF!#REF!63
204-#REF!#REF!63
66-#REF!#REF!63
13-#REF!#REF!63
408-#REF!-#REF!#REF!164
66-#REF!-#REF!#REF!164
408-#REF!-#REF!#REF!165
66-#REF!-#REF!#REF!165
66-#REF!#REF!138
66-#REF!#REF!62
66-#REF!#REF!137
66-#REF!#REF!146
408-#REF!#REF!70
13#REF!#REF!36
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|