Hi guys! I'm new here - from Sweden and I just ordered my first ever solar panels for my home. This winter, electricity prices in Sweden are expected to go up 10-20x the normal price, so I really hope I get them installed soon. When the sales guy visited me and we sat down in my kitchen, he made a calculation using pen and paper where he laid out what my investment would mean. How many solar panels, what they would generate, how it all correlates to what I pay for electricity today, and so on.
I happen to work for a company that has a software as a service that turns Excel files and Google Sheets models into web apps, so during the meeting, I jolted all of his numbers and calculations down in Google Sheets. Since our software uses regular Excel functions and formulas, turning the spreadsheet I made into an app is super quick and I also did this during the meeting. When I said yes to the salesman I showed him my ready-to-go solar calculation app. He was quite amazed.
I thought I would share this app with more people who might benefit from it and if you like, you can try it out here: https://app.molnify.com/app/solarpanelcalculation
If you like to "peek under the hood", you can access the Google Sheets sheet from where the app came from, within the app. Since the app is made using Google Sheets, modifications to its functionality are also made in the GS. This means, that modifying the app itself is really easy. I made it so that it fits the Swedish market (but changed the currency to EURO), but if someone would like to have a tariff in the calculation, or add a battery feature, that's really easy.
Hope you like it and feedback is much appreciated!
Take care // Mattias
Screenshot 2022-09-15 at 10.12.51.png
I happen to work for a company that has a software as a service that turns Excel files and Google Sheets models into web apps, so during the meeting, I jolted all of his numbers and calculations down in Google Sheets. Since our software uses regular Excel functions and formulas, turning the spreadsheet I made into an app is super quick and I also did this during the meeting. When I said yes to the salesman I showed him my ready-to-go solar calculation app. He was quite amazed.
I thought I would share this app with more people who might benefit from it and if you like, you can try it out here: https://app.molnify.com/app/solarpanelcalculation
If you like to "peek under the hood", you can access the Google Sheets sheet from where the app came from, within the app. Since the app is made using Google Sheets, modifications to its functionality are also made in the GS. This means, that modifying the app itself is really easy. I made it so that it fits the Swedish market (but changed the currency to EURO), but if someone would like to have a tariff in the calculation, or add a battery feature, that's really easy.
Hope you like it and feedback is much appreciated!
Take care // Mattias
Screenshot 2022-09-15 at 10.12.51.png
Comment