Download OnGrid Tool v5 User Manual

Chapter 4: Getting Started & Basic Setup
The first thing you’ll want to do in the Tool is take a cursory glace at the different worksheets
(i.e. ‘sheets’). As with other Excel workbooks, you can select a sheet by clicking its tab at the
bottom of the window.
To activate a sheet, click its ‘tab’ at the bottom of the Excel window
The sheet names are meant to give you a general idea of sheet content.
>’Settings & Support’: This sheet has the settings for your viewing, file updating, and backup
preferences. It also lists the names and locations of your OnGrid files. You’ll find your OnGrid
support options lower down on the sheet (including a link to this manual) .
The ‘Settings & Support’ sheet is referred to as the Settings sheet hereafter.
>’Inputs’: The Inputs sheet is where you enter most of your customer’s data. It’s where you’ll
spend most of your OnGrid time.
>’Pricing’: On this sheet, you can set up an automatic pricing system. With your pricing system
in place, project costs will be calculated automatically based on the variables you enter on the
Inputs sheet.
>’Shading’: This is where you enter shading data from the Solmetric SunEye, Solar Pathfinder,
or another shading device.
>’Overview’: This sheet shows your customer’s financials over the twenty-five year analysis.
>’Blank 1’ & ‘Blank 2’: These sheets are completely blank. The blank sheets can be used for
intermediate calculations that assist you in entering Inputs sheet data, or any other custom
calculations. They’re NOT for custom proposals and documents, which should be incorporated
into the respective workbooks (discussed in chapter 12).
OnGrid Tool User Manual © 2013
14