creating and using custom spreadsheets in energycap
DESCRIPTION
Spreadsheet definitions, security, categories, design, and modification. Simple and creative use cases, limitations, troubleshooting, customized queries, and EnergyCAP Online bill lists. Learn more at www.EnergyCAP.com.TRANSCRIPT
![Page 1: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/1.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Standard Operations Track
Creating and Using Custom SpreadsheetsPresented by Ryan Ohlson, VP of Implementation Solutions
![Page 2: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/2.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Agenda:What is a Custom Spreadsheet?
Security
Categories
Design
Modify the Design
![Page 3: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/3.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Agenda (continued):Simple and Creative Use Cases
Limitations
Troubleshooting
Customized Queries
EnergyCAP Online Bill Lists
![Page 4: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/4.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
What is a Custom Spreadsheet?
![Page 5: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/5.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Example Demonstration
![Page 6: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/6.jpg)
Ad-Hoc Reporting
Pre-Defined Business Areas
Excel friendly
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 7: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/7.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Security
![Page 8: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/8.jpg)
Designs are available for all users who can view reports.
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 9: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/9.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
No custom security
![Page 10: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/10.jpg)
A user has the right to change any design
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 11: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/11.jpg)
A user has the right to create a design
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 12: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/12.jpg)
A user has the right to delete any design
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 13: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/13.jpg)
A user’s filter selections are saved just like with reports
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 14: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/14.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Categories
![Page 15: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/15.jpg)
Account and meter lists provide non-bill information
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 16: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/16.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Meter Summary provides bill data for the meter
![Page 17: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/17.jpg)
Bill Summary provides bill data without consumption
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 18: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/18.jpg)
Bill Summary provides bill data, not consumption, and includes headers
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 19: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/19.jpg)
Line item provides bill data by caption or observation type
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 20: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/20.jpg)
GHG provides bill data with emissions
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 21: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/21.jpg)
Budgets provides bill data with budgets
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 22: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/22.jpg)
Channel provides meter data collected by smart or other methods
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 23: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/23.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Design
![Page 24: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/24.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
First: Choose a category
![Page 25: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/25.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Second: Choose a name
![Page 26: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/26.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Third: Choose filters
![Page 27: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/27.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Fourth: Choose output
![Page 28: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/28.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Do’s and don’ts
Do choose a TopMost for a Filter
Don’t choose a TopMost for an Output
![Page 29: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/29.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Do’s and don’ts
Do choose a Group for a Filter
Don’t choose a Group for an Output unless you give a value for the Filter other than ‘All’
![Page 30: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/30.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Do’s and don’ts
Do choose BillID as an output column
Don’t leave BillID out as an output column because you risk suppressing bill data
![Page 31: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/31.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Modify Design
![Page 32: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/32.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Ask yourself if this is your spreadsheet or not
![Page 33: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/33.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Select and modify design
![Page 34: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/34.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Changing too many things can result in a failed design
![Page 35: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/35.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Simple and Creative Uses
![Page 36: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/36.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Locate account, meter, bill
![Page 37: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/37.jpg)
Modify Bills
Export Data
Budget Import
Exception Reportfor Bill Interfaces
Audit of Channel Data
Quick Totals
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 38: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/38.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Limitations
![Page 39: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/39.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Results are limited to 50,000 records
![Page 40: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/40.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Not distributable through Report Distribution Manager
![Page 41: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/41.jpg)
Only available in the installed client EnergyCAP Enterprise
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 42: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/42.jpg)
Unless you know SQL, data is limited to pre-defined categories
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 43: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/43.jpg)
Includes detail data, not summary data for a Place, Department, etc.
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 44: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/44.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Troubleshooting
![Page 45: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/45.jpg)
No data? Set filters to ‘All’ or modify design filters or outputs
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 46: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/46.jpg)
Too much data? Change filters set to ‘All’ or modify design to add filters
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 47: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/47.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Custom Query Categories
![Page 48: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/48.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
For knowledgeable SQL and XML clients
![Page 49: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/49.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Make available any data in the entire EnergyCAP database
![Page 50: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/50.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Read tutorial in the help manual to learn how
![Page 51: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/51.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Ask about our custom query service or development tool
![Page 52: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/52.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
EnergyCAP Online Bill Lists
![Page 53: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/53.jpg)
For bill-based data needs—does not typically contain meter or line item data
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 54: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/54.jpg)
In some ways Bill Lists are more functional than Custom Spreadsheets
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 55: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/55.jpg)
Filtered Output
Choose columns
Export to Excel
Audit Bills andManage Problems
Approve Bills
Delete Bills
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 56: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/56.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Set your filters
![Page 57: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/57.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Select your columns
![Page 58: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/58.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Output to Excel
![Page 59: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/59.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Audit, Approve, Delete multiple bills
![Page 60: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/60.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Questions
Check out the Ace Place to learn more!
![Page 61: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/61.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Live Demonstration: Create a custom spreadsheet for Bill Meter Details
![Page 62: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/62.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Click on design spreadsheet
![Page 63: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/63.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Choose Bill Meter
![Page 64: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/64.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Choose Meter Summary– Locate Account
![Page 65: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/65.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Select filters and outputs
![Page 66: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/66.jpg)
Common use can be preferable to native use when commodities are measured in different units
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 67: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/67.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Click on view spreadsheet to viewthe filters list
![Page 68: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/68.jpg)
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
Configure filters
![Page 69: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/69.jpg)
Click on OK to view the Bill Meter Details spreadsheet!
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com
![Page 70: Creating and Using Custom Spreadsheets in EnergyCAP](https://reader035.vdocuments.us/reader035/viewer/2022062514/558382fbd8b42a8e0c8b4584/html5/thumbnails/70.jpg)
Use this spreadsheet design to export meter level data from a bill
©2013 EnergyCAP, Inc. ▪ @energycap ▪ www.EnergyCAP.com