Sisters Community Solar

Pre-subscription selection dashboard

Summary

Metrics and submission activity from the pre-subscription list. Lottery # is the permanent random number drawn once for each priority-qualified household; Inst. Rank is that household’s place in line within its own institution’s pool. Full explanation on the Lottery page.
Loading live data from the Google Sheet…

% Completion

Only ~650 spots will be available. Goal set higher to account for churn.

% Low-Income

LMI submissions as a share of total submissions

% Preferred Neighbor

Submissions with a 1 in the Preferred Neighbor column

Submissions by institution

Sorted by most to least submissions

Submission trend by day

Daily submission count for the selected institution filter

Lottery

Compliance tracker, spot allocation, and the generated invitation list

How the lottery works

Definitions for the terms used on this page and in the Submissions tables
Lottery #Every household that qualifies for the Priority List is assigned one random number, once. It is permanent — it is never re-drawn or reassigned, even when new submissions come in, so a household’s place in line cannot move because of anything that happens later. A lower number is earlier in line.
Inst. RankA household’s position within its own institution’s pool, counting up from 1 in lottery-number order. Rank 1 is the first household that institution’s allocated spots go to, rank 2 the second, and so on. Because each institution is ranked separately, rank 1 at a large congregation and rank 1 at a small one are equally first in their own line.
PoolThe group a household competes within. Institution membership takes priority: if someone belongs to a TNO member institution, that institution is their pool. The Neighborhood (set-aside) pool holds only people who qualify solely through the Preferred Neighbor boundary, and receives 10% of available spots.
Tier 1 / WaitlistTier 1 households are offered a subscription in this round. The Waitlist is the ordered backup list — if a Tier 1 household declines, doesn’t respond, or drops out, the spot goes to the next household in line under the same rules that filled it.
Spots AllocatedEach institution’s share of available spots, computed from its share of priority-qualified signups — not from the recruitment goal set before the list opened. The two numbers are different on purpose.
Loading live data from the Google Sheet…

Submission Details

Complete, wrong bill, and missing bill pre-subscription records. Click any table header to collapse or expand it.
Loading live data from the Google Sheet…

Completed submissions

Bill uploaded and readable. Default status is "Needs Review". Status is updated in the CSC Presubscription Dash Responses tab.
NameSubmission dateInstitutionLow income status
Preferred neighbor
Priority
Duplicate
Lottery #Inst. rankStatus

Wrong Bill submissions

A bill was uploaded, but it could not be used — unreadable, not a utility bill, or a file the pipeline can't process. See the issue on each row. These need a replacement bill before they can be counted as complete.
NameSubmission dateInstitutionLow income status
Preferred neighbor
Priority
Duplicate
Lottery #Inst. rankIssue / error messageLast Contacted byLast Contacted atOutreach outcome

Missing Bill submissions

No bill uploaded yet. Solar Captains are responsible for outreach via TNO Now Glide App.
NameSubmission dateInstitutionLow income status
Preferred neighbor
Priority
Duplicate
Lottery #Inst. rankLast Contacted byLast Contacted atOutreach outcome

Pending verification

A bill was uploaded and is waiting on the extraction pipeline. These usually clear within a few minutes; if one sits here, check the Apps Script execution log.
NameSubmission dateInstitutionLow income status
Preferred neighbor
Priority
Duplicate
Lottery #Inst. rankLast Contacted byLast Contacted atOutreach outcome