Merge Calendar in query

Hi Everyone

So I am working with Project for the Web solution accelerator. I need to build a matrix (heatmap) that shows forecast work per day but also taking into consideration the resources calendar. then i can show forecast work per day and "remaining availability" against the resources calendar.

Microsoft stores the resources calendar as its own individual API for every resource in a calendar table.

Table 1 (resources): Resource ID, Calendar

Table 2 (calendar): Calendar ID, Resource ID, Time Off Days, Time off Date , Time off Type etc.. (coudl be like 20 rows in calendar entity for each resource)

So if every resource has its own calendar ID - how do i get to the availability formula? (per day)

Time off is all by date/date ddmmyyyy in calendar entity

all help urgently appreciated... guessing this is tricky??