Detailed Analysis on NJ's Solar Program

Job ID: 39176746

Budget: $250 – $750 USD

Project Summary: I need a Freelancer to create a detailed Excel spreadsheet focusing on New Jersey’s Community Solar Energy Program (CSEP). The spreadsheet will support an analysis of current programs, legislative recommendations, and alternative strategies, requiring four key tabs:

Project Data: List all 150 approved CSEP projects (243 MW total capacity, 88 operational), including project names, capacities (e.g., up to 5 MW each), locations, utility territories (e.g., 158 MW for PSE&G), start dates, and subscriber numbers (over 16,000 households). Source data from NJ Clean Energy reports.
State Comparisons: Compare New Jersey to states like New York (over 1 GW capacity) and California, using metrics like total capacity, project count, subscriber numbers, and policy features (e.g., incentives, LMI provisions). Use NREL’s 'Sharing the Sun' dataset for benchmarks.
Financial Analysis: Calculate subscriber savings and developer revenue. Assume 900 kWh monthly usage, 19.8 cents/kWh rate, and 5-10% savings ($8.91-$17.82/month). For a 2 MW project (20% capacity factor, 3,504 MWh/year), compute $315,360 SREC-II revenue ($90/MWh) and $623,522 subscription fees (324 subscribers at $160.38/month), totaling $938,882 annually. Include sensitivity analysis for rates and fees.
Scoring Model: Evaluate CSEP on a 1-5 scale for accessibility (4/5, easy subscription), financial attractiveness (4/5, solid savings/incentives), regulatory stability (5/5, permanent program), environmental impact (4/5, 243 MW contribution), and equity (4/5, LMI focus). Compare with other states.
Required Skills: Excel proficiency, renewable energy knowledge, analytical skills. Deliverable: A comprehensive Excel file with cited data (e.g., NJBPU, EnergySage). The project will need to be completed Sunday 3/9.