Hi All,
By using Open Building Designer, how can I link/insert Excel spreadsheet into Catalogue and show as 'link/file' in Properties? If it is not a correct way to do it in 'Catalogue', how to do it as long as the Excel can be link in the Properties.
After linked, can it be synchronize after editted the data in Excel?
Moreover, after I produce a schedule and open it in Excel, I found it unable to insert the equation/formula. May I know how to do it?
Thank you very much~~
Hi Ting,
Can you please let us know which version of OpenBuildings Designer you are using?
Regards,Sayan Acharyya
Hi Sayan,
This is Version 10.08.00.44
Hello Ting,
There is no way to link excel data with Catalogs. You can edit the catalog values in the schedules dialog or do Edit in excel.
When you are mentioning about formula, can you explain what kind of formula you are trying to insert in Excel?
Regards,Alifur
To insert the formula like =SUM, + plus, - minus, / divide when editing in Excel instead of calculate and key-in one-by-one.
Yes they are not present, you can export the excel in CSV and do the operation in Excel itself.
After export the Excel and applied the equation, how do I synchronize the Excel back to OBD?
After doing the required equation you can use the option "Update from Excel" from Schedules tool to import (synchronize) those values back to OBD. Please refer to the below screengrab.
HTH!
Answer Verified By: Ting Wei Wong