When I created a spreadsheet of quotes, I wanted to calculate the 35% Hawaii state tax rebate. Its a funky equation, because it's 35% or $5000 for each 5K of DC panels. I'm posting it here in case it's of help to others.
The equation looks like:
=int(B4/5000)*min(G4/B4*5000*0.35, 5000) +min(mod(B4,5000)*G4/B4*0.35, 5000)
where B4 is the DC size in watts, and G4 is the Cost of the system.
From the quotes I have so far, the actual state rebate ranges from 19% up to 33%.
The equation looks like:
=int(B4/5000)*min(G4/B4*5000*0.35, 5000) +min(mod(B4,5000)*G4/B4*0.35, 5000)
where B4 is the DC size in watts, and G4 is the Cost of the system.
From the quotes I have so far, the actual state rebate ranges from 19% up to 33%.