How to extract information from one excel sheet based on every entry on another excel sheet
Hello all,
I’m exporting programme date from Asta powerproject. This programme can be filtered out based on codes that we have assigned to tasks. The codes can change depending on project but we’ve got standard code libraries that will be consistent on all programmes. The issue I have is I’m not sure how to extract programme data based on the code library used for that programme. My initial idea was to use a loop start and end node but that is as far as I got 🤦♂️ Wasn’t sure if that was the correct way of solving this
So the code Library has folders - in this case its called GBL Cost Code. In this Library there are three folders (architectural, mechanical and electrical) and my programme will have activities with those codes in the three sections assigned to it. I’d like to extract activities with ‘UPS’ assigned to it, perform some manipulation, then get extract ‘BMS and Controls’ and perform the same manipulation and then join each of those sections into 1 single sheet of S curves for each of those codes.
I’ve attached a dummy programme export. For ease of use, please look at ‘Code Library’, ‘Code Library Entry’ and 'Task. ’
One manipulation is S curve creation of which I’ve got a sequence of nodes for as attached if required. Trust that makes sense. Any help is greatly appreciated