ProjectLine Technical Services Inc.
2900 Bristol, Ste D-103
Costa Mesa, Ca 92626
Phone: (714) 540-5460
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.