Google Sheets

[Dmitry KOSTYUK]

Hi all, 

Has anyone been able to adapt Coolprop to run in Google Sheets? 

If so how, did you go about it?

If not, how would you theoretically go about it? 

I am prepared to go as far as re-writing the code in Apps Script, but I would appreciate any help or guidance on the matter.

Thanks

Dmitry

[Ian Bell]

I am not sure this would be possible, since CoolProp is compiled code, and getting that sort of code into cloud computing platforms is never easy.

I don't think you want to rewrite CoolProp; it is several tens of thousands of lines of code and a massive undertaking. better would be to try to figure out how to get Google Sheets to call compiled code, either via calling a shared library or via Python. I think both would not be permitted by their security :(

--------------------------------------------------------------------------------------------

This e-mail transmission (message and any attached files) may contain information that is proprietary, privileged and/or confidential to Veolia Environnement and/or its affiliates and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient, please notify the sender by return e-mail and delete all copies of this e-mail, including all attachments. Unless expressly authorized, any use, disclosure, publication, retransmission or dissemination of this e-mail and/or of its attachments is strictly prohibited. 

Ce message electronique et ses fichiers attaches sont strictement confidentiels et peuvent contenir des elements dont Veolia Environnement et/ou l'une de ses entites affiliees sont proprietaires. Ils sont donc destines a l'usage de leurs seuls destinataires. Si vous avez recu ce message par erreur, merci de le retourner a son emetteur et de le detruire ainsi que toutes les pieces attachees. L'utilisation, la divulgation, la publication, la distribution, ou la reproduction non expressement autorisees de ce message et de ses pieces attachees sont interdites.

--------------------------------------------------------------------------------------------

--
You received this message because you are subscribed to the Google Groups "coolprop-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to coolprop-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/coolprop-users/e73e04dc-108b-49ba-99c1-d06e3d169227n%40googlegroups.com.

[Dmitry KOSTYUK]

Thanks for coming back to me.

Have you ever thought about building a Coolprop Rest API ? I'd be interested in contributing :)

[Ian Bell]

No REST API exists for CoolProp, but you would be welcomed to develop one.

To view this discussion on the web visit https://groups.google.com/d/msgid/coolprop-users/bb0dbacf-4b34-4845-89ad-2055efea030dn%40googlegroups.com.

[qnikil7]

Hello,

I want to use CoolProp on google sheets. 

Wanted to know if anyone is successful in implementing it.

Found another discussion here regarding this. (https://groups.google.com/g/coolprop-users/c/9j-SaHsz3oc/m/TB7CIoWPCQAJ)

Based on what I could search Creating API, hosting it somewhere, and an AppScript function querying it.

Would like to know what would be the best way to approach this.

Thank you!

[Chris Mui]

Copy the template here and use PropsSI, Props1SI, and HAPropsSI just like you would in the excel wrapper. 

https://www.coolpropsheets.com

[D Arnaud]

You can use this method:

https://github.com/adegard/CoolPropAPI