Matrix Pepco WTEA Report Generation
Switch branches/tags
Nothing to show
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
Matrix WTEA Data Collection Form for Data Entry.xlsm
Pepco SB Walk-Through Assessment.xlsx
Quote for Co-Payment.xlsx
README.md
SB_Pepco_Lighting_v1.2.xls
WTEA_Pepco_v1.6 10-23-12-unlocked.xlsx
Work Order - Lighting.xlsx

README.md

Matrix Pepco file generation

This project is designed to help Matrix Energy Services produce their WTEA reports at a higher and more productive speed.

3/18/2013
v.2.7.3
-Cleaner WTEA Report
-Auto-Capitalize Indoor Lighting Page
-Update macro to add in WTEA Date to LIA

2/15/2013
v.2.7.2
-Floor same as above logic
-Ceiling height and sensors now make it to work order again
-notes make it to wtea data collection
-Application filled out correctly.

2/13/2013
V.2.7
-Work order formula for 4 lamp low ballasts fixed
-Lighting color now sent from iPad
-CSV parent removed for walk-incooler
-R1 sum tab auto-completes Not Applicable
-Business Description on iPad
-Floor specific to indoor lighting added
-model numbers updated
-Macro moves tabs instead of hides them now.

12/19/2012
-New WTEA Report version
-New iPad version Matrix Form 2.5 is out
-Exported.CSV macro updated to work with new matrix form
-New logic in some of the macros
-New fields added to indoor lighting and hvac
-Everything seems to be working now... :)

12/13/2012 -New WTEA Report version released -still many bugs, not really working correctly in many areas

12/5/2012
-Lamp Color added. if empty, will show up as 5000K on the work order.

12/3/2012
-Work Order has been changed, it is now more compatible with Andrey.

11/27/2012 -Fixed several bugs that came along v2.2.
-Added new work order and materials form list

11/20/2012
-Added 50 fields to indoor lighting

11/16/2012
v2.1.2

-Matrix WTEA Data Collection Form
-There are now indicators throughout the form.
-You now cannot run the macro unless certain conditions are met. On the front page, you can see these conditions and their statuses.
-"Not Quite" is allowed on the Outdoor Lighting and Indoor Lighting page, those lights will just not be processed on the other forms. However, "Not Quite" is not allowed on any other pages.

-WTEA Pepco form
R1 Sum 'Assessment Overview' now fills itself out.

10/11/2012
-macro saves the matrix form after run
-data validation added to indoor lighting
-fixed t8/t5/metal hallide in outdoor lighting form
-closes and saves WTEA report after hiding/unhiding things
-fixed hvac replacement formulas

10/10/2012
-fixed work order report
-macro is better/safer
-random bug fixes
-documentation on front page of matrix form
-all cells that have an effect on other forms are highlighted yellow
-data validation is added throughout the matrix data form