Solar Energy Simulator Add-on Guide for Google Sheets
Welcome to the official guide for the Solar Energy Simulator Google Sheets Add-on! This tool helps users evaluate the energy production and economic value of solar panel installations across the globe using real-world satellite data.
📦 Features at a Glance
- ✅ Compare solar panel brands and specifications
- 📍 Estimate solar output using geographic coordinates
- 📈 Calculate daily and annual power generation
- 💰 Simulate economic value based on regional electricity prices
- 🌍 Global coverage with localized data
📌 Intended Users
This add-on is ideal for homeowners, energy consultants, solar product vendors, and developers interested in evaluating or promoting solar energy savings.
🚀 Getting Started
- Install the Add-on:
Open your spreadsheet → Extensions → Add-ons → Get Add-ons → Search “Solar Energy Simulator” - Open the Sidebar:
Go to Extensions → Solar Energy Simulator → “Open”
This opens a user-friendly sidebar with function documentation and quick access buttons. - Allow Permissions:
The add-on requires access to the sheet to inject data and retrieve live satellite info.
📋 Function Descriptions
BRANDS()
Returns a table of registered solar panel brands and their specifications.
= BRANDS()
ELECTRICITY_PRICE(countryCode, electricityType, currencyCode, addCurrency)
Returns electricity price by country, usage type, and currency code.
= ELECTRICITY_PRICE( "JP", "residential", "USD", TRUE )
PANELS()
Alias for BRANDS(), returns panel brand list.
= PANELS()
SIMULATOR_DEFAULT(key)
Retrieves saved general config value by key.
= SIMULATOR_DEFAULT("currency")
PANEL_ANNUAL_OUTPUT(lat, lon, area, name)
Returns annual solar panel output.
= PANEL_ANNUAL_OUTPUT( 35.68, 139.76, 10, "BrandA" )
PANEL_DAILY_OUTPUT(lat, lon, area, name)
Returns daily solar panel output.
= PANEL_DAILY_OUTPUT( 35.68, 139.76, 10, "BrandA" )
PANEL_INSTALLATION_ANNUAL_VALUE(lat, lon, area, name, countryCode, electricityType, currencyCode, addCurrency)
Calculates estimated annual savings from solar panel installation.
= PANEL_INSTALLATION_ANNUAL_VALUE( 35.68, 139.76, 10, "BrandA", "JP", "residential", "USD", TRUE )
PANEL_OUTPUT(lat, lon, area, name, output)
Calculates solar panel output for given location and panel. ‘output’ is “daily” or “annual” (default: daily).
= PANEL_OUTPUT( 35.68, 139.76, 10, "BrandA", "annual" )
Available Country Codes
| Counry Name | Country Code |
|---|---|
| UAE | AE |
| Afghanistan | AF |
| Albania | AL |
| Armenia | AM |
| Angola | AO |
| Argentina | AR |
| Austria | AT |
| Australia | AU |
| Aruba | AW |
| Azerbaijan | AZ |
| Bosnia & Herz. | BA |
| Barbados | BB |
| Bangladesh | BD |
| Belgium | BE |
| Burkina Faso | BF |
| Bulgaria | BG |
| Bahrain | BH |
| Bermuda | BM |
| Brazil | BR |
| Bahamas | BS |
| Bhutan | BT |
| Botswana | BW |
| Belarus | BY |
| Belize | BZ |
| Canada | CA |
| DR Congo | CD |
| Switzerland | CH |
| Ivory Coast | CI |
| Chile | CL |
| Cameroon | CM |
| China | CN |
| Colombia | CO |
| Costa Rica | CR |
| Cuba | CU |
| Cape Verde | CV |
| Cyprus | CY |
| Czech Republic | CZ |
| Germany | DE |
| Denmark | DK |
| Dom. Rep. | DO |
| Algeria | DZ |
| Ecuador | EC |
| Estonia | EE |
| Egypt | EG |
| Spain | ES |
| Ethiopia | ET |
| Finland | FI |
| France | FR |
| Gabon | GA |
| UK | GB |
| Georgia | GE |
| Ghana | GH |
| Greece | GR |
| Guatemala | GT |
| Hong Kong | HK |
| Honduras | HN |
| Croatia | HR |
| Hungary | HU |
| Indonesia | ID |
| Ireland | IE |
| Israel | IL |
| India | IN |
| Iraq | IQ |
| Iran | IR |
| Iceland | IS |
| Italy | IT |
| Jamaica | JM |
| Jordan | JO |
| Japan | JP |
| Kenya | KE |
| Kyrgyzstan | KG |
| Cambodia | KH |
| South Korea | KR |
| Kuwait | KW |
| Cayman Islands | KY |
| Kazakhstan | KZ |
| Laos | LA |
| Lebanon | LB |
| Liechtenstein | LI |
| Sri Lanka | LK |
| Lesotho | LS |
| Lithuania | LT |
| Luxembourg | LU |
| Latvia | LV |
| Libya | LY |
| Morocco | MA |
| Moldova | MD |
| Madagascar | MG |
| N. Maced. | MK |
| Mali | ML |
| Burma | MM |
| Malta | MT |
| Mauritius | MU |
| Maldives | MV |
| Malawi | MW |
| Mexico | MX |
| Malaysia | MY |
| Mozambique | MZ |
| Namibia | NA |
| Nigeria | NG |
| Nicaragua | NI |
| Netherlands | NL |
| Norway | NO |
| Nepal | NP |
| New Zealand | NZ |
| Oman | OM |
| Panama | PA |
| Peru | PE |
| Philippines | PH |
| Pakistan | PK |
| Poland | PL |
| Portugal | PT |
| Paraguay | PY |
| Qatar | QA |
| Romania | RO |
| Serbia | RS |
| Russia | RU |
| Rwanda | RW |
| Saudi Arabia | SA |
| Sudan | SD |
| Sweden | SE |
| Singapore | SG |
| Slovenia | SI |
| Slovakia | SK |
| Sierra Leone | SL |
| Senegal | SN |
| Suriname | SR |
| El Salvador | SV |
| Syria | SY |
| Swaziland | SZ |
| Togo | TG |
| Thailand | TH |
| Tunisia | TN |
| Turkey | TR |
| Trinidad & Tobago | TT |
| Taiwan | TW |
| Tanzania | TZ |
| Ukraine | UA |
| Uganda | UG |
| United States | US |
| Uruguay | UY |
| Uzbekistan | UZ |
| Venezuela | VE |
| Vietnam | VN |
| South Africa | ZA |
| Zambia | ZM |
| Zimbabwe | ZW |
Available Currency Codes
| Currency Name | Currency Code |
|---|---|
| United Arab Emirates dirham | AED |
| Afghan afghani | AFN |
| Albanian lek | ALL |
| Armenian dram | AMD |
| Angolan kwanza | AOA |
| Argentine peso | ARS |
| Euro | EUR |
| Australian dollar | AUD |
| Aruban florin | AWG |
| Azerbaijani manat | AZN |
| Bosnia and Herzegovina convertible mark | BAM |
| Barbados dollar | BBD |
| Bangladeshi taka | BDT |
| CFA franc BCEAO | XOF |
| Bulgarian lev | BGN |
| Bahraini dinar | BHD |
| Bermudian dollar | BMD |
| Brazilian real | BRL |
| Bahamian dollar | BSD |
| Bhutanese ngultrum | BTN |
| Botswana pula | BWP |
| Belarusian ruble | BYN |
| Belize dollar | BZD |
| Canadian dollar | CAD |
| Congolese franc | CDF |
| Swiss franc | CHF |
| Chilean peso | CLP |
| Colombian peso | COP |
| Costa Rican colon | CRC |
| Cape Verdean escudo | CVE |
| Czech koruna | CZK |
| Danish krone | DKK |
| Dominican peso | DOP |
| Algerian dinar | DZD |
| United States dollar | USD |
| Algerian dinar | EEK |
| Egyptian pound | EGP |
| Ethiopian birr | ETB |
| Euro | FIM |
| CFA franc BEAC | XAF |
| Pound sterling | GBP |
| Georgian lari | GEL |
| Ghanaian cedi | GHS |
| Guatemalan quetzal | GTQ |
| Hong Kong dollar | HKD |
| Honduran lempira | HNL |
| Hungarian forint | HUF |
| Indonesian rupiah | IDR |
| Israeli new shekel | ILS |
| Indian rupee | INR |
| Iraqi dinar | IQD |
| Iranian rial | IRR |
| Icelandic króna (plural: krónur) | ISK |
| Jamaican dollar | JMD |
| Jordanian dinar | JOD |
| Japanese yen | JPY |
| Kenyan shilling | KES |
| Kyrgyzstani som | KGS |
| Cambodian riel | KHR |
| South Korean won | KRW |
| Kuwaiti dinar | KWD |
| Cayman Islands dollar | KYD |
| Kazakhstani tenge | KZT |
| Lao kip | LAK |
| Lebanese pound | LBP |
| Sri Lankan rupee | LKR |
| Lesotho loti | LSL |
| Libyan dinar | LYD |
| Moroccan dirham | MAD |
| Moldovan leu | MDL |
| Malagasy ariary | MGA |
| Macedonian denar | MKD |
| Myanmar kyat | MMK |
| Mauritanian ouguiya | MTL |
| Mauritian rupee | MUR |
| Maldivian rufiyaa | MVR |
| Malawian kwacha | MWK |
| Mexican peso | MXN |
| Malaysian ringgit | MYR |
| Mozambican metical | MZN |
| Namibian dollar | NAD |
| Nigerian naira | NGN |
| Nicaraguan córdoba | NIO |
| Norwegian krone | NOK |
| Nepalese rupee | NPR |
| New Zealand dollar | NZD |
| Omani rial | OMR |
| Panamanian balboa | PAB |
| Peruvian sol | PEN |
| Philippine peso | PHP |
| Pakistani rupee | PKR |
| Polish złoty | PLN |
| Paraguayan guaraní | PYG |
| Qatari riyal | QAR |
| Romanian leu | RON |
| Serbian dinar | RSD |
| Russian ruble | RUB |
| Rwandan franc | RWF |
| Saudi riyal | SAR |
| Sudanese pound | SDG |
| Swedish krona (plural: kronor) | SEK |
| Singapore dollar | SGD |
| Sierra Leonean leone (new leone) | SLL |
| Surinamese dollar | SRD |
| Salvadoran colón | SVC |
| Syrian pound | SYP |
| Swazi lilangeni | SZL |
| Thai baht | THB |
| Tunisian dinar | TND |
| Turkish lira | TRY |
| Trinidad and Tobago dollar | TTD |
| New Taiwan dollar | TWD |
| Tanzanian shilling | TZS |
| Ukrainian hryvnia | UAH |
| Ugandan shilling | UGX |
| Uruguayan peso | UYU |
| Uzbekistani sum | UZS |
| Vietnamese đồng | VND |
| South African rand | ZAR |
| Zambian kwacha | ZMW |
| Zimbabwe Gold | ZWL |
| New Taiwan dollar | TZS |
| Tanzanian shilling | UAH |
| Ukrainian hryvnia | UGX |
| Ugandan shilling | USD |
| United States dollar | UYU |
| Uruguayan peso | UZS |
| Uzbekistani sum | VES |
| Venezuelan sovereign bolívar | VND |
| Vietnamese đồng | ZAR |
| South African rand | ZMW |
| Zambian kwacha | ZWL |
| Zimbabwe Gold | ZWG |
🌐 Data Usage
All data retrieved from our Data API is not under the MIT license. It is provided under our terms of service. This includes building data sourced from Overture. These datasets are subject to their own terms of service and licensing. The GHI (Global Horizontal Irradiance) data is used internally for calculations and is not delivered to users. It is sourced from World – Global Horizontal Irradiation (GHI) GIS Data, (Global Solar Atlas) and published under the CC BY 4.0.
🔗 Try Our WordPress Plugin!
Boost your website with advanced solar panel simulation features. Easily integrate output visualization and energy savings calculators with our WordPress plugin. 👉 Click here to view the plugin on WordPress
💬 We’d Love to Hear From You
Your feedback is important to us. If you have any questions, feature requests, or suggestions, please reach out via the plugin support page or contact us directly. Your input helps us make this tool even better.
Feel free to contact us or info@otani.co