Technical Support to LADWP’s Solar Incentive Program (SIP)

ProjectLine provided strategic planning services as required to support LADWP’s renewable portfolio projects as a subconsultant to Black & Veatch. ProjectLine assisted LADWP in developing tools to more efficiently process LADWP’s Solar Incentive Program data and customer reservation requests. Specific tools developed included:

• scripts to automate forms – creation, emailing and saving PDFs
• scripts to extract and store email addresses contained in email folders, and load to database
• scripts using AutoIT to extract data from PDF forms and store in Excel
• VBA code for mass email and mouse wheel disable function in Access form
• Excel macros with a view to semi automating SIP processes.