Create Bridge Process Aggregated List

[pweiler22]

Create a master list of bridge processes across the FLCAC for data curator/provider reference.

@Gonzalo-RG

[bl-young]

@Gonzalo-RG - i'm working on a script to grab all the bridge processes and present them, can you help me think through what information is most useful to report out?

see example attached - at a minimum i'll improve the field names.

bridges.csv

[Gonzalo-RG]

Hi Paige, hi Ben,

Thank you for doing this. I think the idea of script is great, it seems a very efficient way of knowing quickly what is available in the Commons. On a first glance, I think I would find useful knowing which two exchanges are connected through the bridge process. It seems to me that with your results as they stand, I would know the output flow, but not the input one.

Although it is still raw, I'd like to take this opportunity and share with you the Excel file I have been working on in the past few months. Based on what Ben Morelli did (which remain in the Excel file as 'Example'), I've tried to automate the generation of bridges to USEEIO in 'USEEIO V2 Conversions'. There you have a list of all the bridge processes I have created so far for the Building Systems database. From that sheet, a macro creates additional sheets (one per bridge process) that can then be exported to openLCA using a script I have. Although any feedback from you is welcome at any time, Josh and I plan to ask you more formally once the associated report is in good shape. In the meantime, I would ask you not to disseminate them.

2025.09.05 USEEIO bridges.xlsm