From PESWiki

Procedure for manually tallying the New Energy Congress' Top 100 Clean Energy Technology polls in order to derive an updated T100 listing. Instructions compiled by Sterling D. Allan on Sept. 12, 2008 for Susan Carter, who has "observer" status with the NEC.

Procedure

Step One

Copy the raw votes under "open polls" at http://tech.groups.yahoo.com/group/NEC-TechRev/polls into a word doc. Just start at the top and go down.

Include the url of the YahooGroups poll.

Add a space after the "reference" url so it turns into a hyperlink.

Omit the actual radiobuttoned answer options, but include everything else.

Step Two

The next step will be to modify the doc as follows:

(Don't need Table of Contents; that's just busy work.)

Suggested doc file name: NEC T100 Voting Snapshot {Date and Time of Day}

Add headers/footers to the doc

header/title: NEC T100 Voting Snapshot Sept. 12, 2008, 12:00 pm Mountain footer: page number

Each poll can begin on a new page.

At the opening of the doc, add:

"Compiled by Susan M. Carter, who has NEC "observer" status. (had to lodge “abstain” vote in order to access the information to compile this report)"

Step Three

The next step in this process will be to tally the numbers into Excel to create a Raw Votes listing in a spreadsheet. Add Revision number to each file when submitted.

As a point of reference, the finished spreadsheet should have three presentations of the information:

A. Official Top 100, #1-100 (actually it's more like 80) (only including technologies for which more than 50% of NEC votes ranked it somewhere in the T100; and where at least a quorum was represented. Quorum = 25% of NEC members will come to about 12 people once our present voting on new member ratifications is complete.)

B. Entire List ranked according to points/vote (low score wins)

C. Raw votes

Since A is derived from B, and B is derived from C, let me first describe the contents of C:

RAW VOTES TALLY IN SPREADSHEET

The Raw Votes listing sequence is the same as the Word document tally that has been assembled.

Only the non-crossed-out votes should be counted in the Raw Votes listing.

ALGORITHMS FOR RAW VOTES LISTING

"Total # Voting" is a tally of all votes in that row (should not include those voters who are crossed out) "Votes" is a little tricky. The sum is derived from these four elements: - Include T2 through T100 - Include "NotT100" - Don't include "Abstain", "Need more time", "Recuse" (these are irrelevant to this tally) - Multiply "Not Enough Info" by 1/3. (this factor weighs a little)

"Not T100 if < .50" is a little tricky too.

It comes from an NEC policy that a technology will not be included in our Top 100 listing unless at least 50% of those who voted on it place it somewhere between (or including) T2 and T100.

So the denominator will be "Total # Voting"

The numerator will be the sum of votes in the T2 - T100 columns. Also, "recuse" counts as "T100 or above" for the >50% rule.

The sum of votes at the bottom of each column is interesting but not required, and can be done later for kicks and grins.

Memo: (fyi)
- Some polls dropped the "need more time" option.
- The "recuse" option was added about a year ago, and is a subset of "abstain".

Step Four

The next step is to generate a ranked listing of all technologies voted on -- list "B" above.

ALGORITHMS FOR COMPREHENSIVE RANKING

Items in the T2 column will be multiplied by 2x

• T5: 5x
• T10: 10x
• T20: 20x
• T50: 50x
• 100: 100x
• Not T100: 200x
• Another column should be added for "Not Enough Info". This will be calculated as (1/3 x rawvote) x 200 and will be added to the sum.

The reason for this change is to create a wider spread of numbers in the "points per vote" tally, to significantly reduce the incidence of two technologies having the same tally.

"Total Points" is the sum of the above: (T2 x 2) + (T5 x 5) + (Tn x n...) + (T100 x 100) + (NotT100 x 200) + (NotEnoughInfo x 1/3 x 200).

"Total Votes" (should probably be renamed: "Total Weighed Votes") is as described in step 3 for "Votes" in Table C, Raw Votes. Ditto for "Total # voting", and "Not T100 if <.50" (they are as described in step 3 -- derived from that data, not from the data in Table B, which has a multiplication factor applied).

"Points Per Vote" > This is simply: "Total Points"/"Total Votes".

It is this number that should determine the sorting of this entire list, with the low score being first.

Step Five

Now we're ready to generate the official list, Table A.

This is done by modifying Table B so that it only includes those technologies that meet two screening criteria:
- At least a "quorum" (12 people presently) have voted (as given in "Total # Voting" column)
- "Not T100 if <.50" is not less than 0.50, as derived from Table C.

Table A uses the same sorting criteria as Table B.

When that Table A is generated, we now have what we need to update the Top100Energy.com listing (at PESWiki).

Completed Tallies

• Sept. 2008 (only accessible to NEC members)

See also

• Congress:Top 100 Tally
• Congress:Technology Score Calculation Formulas

• Submit
• LISTS
  • Main T100 Page - lists the Top 20
  • Top 100 - Complete T100 list
  • Top 100 Techs in the News
  • Commercially Ready
  • Sterling's List - partitioned first by extent of commercial readiness and second by price point and other NEC criteria
  • T100 Listing by Category
  • Related Lists
  • Best Exotic Clean Energy Technologies
  • Congress:T100:Hopper - awaiting evaluation for inclusion in the T100 list.
  • Congress:T100:Former - bumped off the T100 island.
  • Congress:T100:Not - The NEC voting never put it in the T100.
  • Tally | Report | Polls (NEC)
• BRAGGING RIGHTS
  • T100:Award Images for Top 20 Recipients
  • T100:Award Images for Top 100 Recipients
• Congress:Technology Criteria - renewable, environmentally safe, affordable, credible, reliable, feasible, safe, good team, developed
• About - A brief description and history of the Top 100 listing, as well as guidelines and suggested bullet format.
• T100 see also

- New Energy Congress
- Members
- PESWiki home page