Steem Basic Income
Steem Basic Income is a social experiment to bring a basic income to as many Steemians as possible. Members join by sponsoring others into the program. Steem Basic Income is delivered through providing regular upvotes to member content.
Pulling Back the Screen
I'm going to do something a little different for the membership update today. Instead of copying in and publishing the list of names and share counts, I'm going to provide View Only access to the full sheet. This will also enable members to see what's happening with bonuses, upvote weights, etc.
Understanding the Document
The rest of this update will break down what is happening with the calculations, and what each field represents.
Tabs
The first thing to notice is that the page has multiple tabs. The SBI tabs contain the membership lists from each pool. The data tab has the supporting information from daily data pulls that support our calculations. If you're looking for your name in the list, you need to do search (ctrl + f) in each of the pool tabs. Please check all three tabs if you don't see yourself in the first page you check!
Share Counts
The 'Shares' column is the column that most members will be using the most. It shows how many shares you are registered for, based on total enrollment transactions received. This is the column you should check to verify that our count matches your expectation.
Bonus
The 'Bonus' column shows shares that members have received from delegation. In a couple of cases, larger supporters have opted to temporarily assign some of their shares to other members. These adjustments are also tracked in the Bonus column. (This is only available to supporters with at least 25 shares, so we have not previously announced or explained it.)
Upvote bonuses
Upvote bonus calculations happen in the next three columns. The Upvote column shows each members upvote frequency. It represents upvotes received by the 
Formula =min(iferror(vlookup(B2,Data!F:G,2,false)/28,0),1)
The Upvote Weight column shows the average weight each member upvoted
Adjusted Shares
Adjusted shares are the end result after adding all adjustments (effective shares).
Formula=(H2+I2)(1+J2K2/100) = (Shares + bonus shares) * (1+%upvoted+%Upvote weight)
% of Shares and Weekly Upvote Weight
Within each pool, the member's Adj Shares are divided into the total number of effective shares, to identify the percentage held by that member. This is multiplied by 7000 to determine the total weekly upvote weight assigned to the member.
Frequency and Vote Strength
Frequency 1 and Frequency 2 are different measures of the member's posting frequency. Frequency 1 is weekly average over 28 days (total posts in last 28 days, divided by 7). Frequency 2 is the member's actual posting frequency in the last 7 days. A green square indicates the member had not posted within 7 days (as of the last data pull). For the upvote weight per post calculations, we use the greater of the 2 frequencies to protect against member's varying their posting patterns to to game the system. Vote strength is then calculated by dividing their weekly weight across their posting frequency. It is capped at 100 per post, since we cannot upvote a post at greater than 100%
Formula = min(N2/max(O2,P2),100) = weekly weight / (max of frequency 1 and frequency 2), capped at 100
The Rest
The remaining columns are used to support more convenient usage of the data to manually manage the weights in steemvoter. Per Post at the beginning is the same value as Vote Strength. It is Rounded off in 'Rounded'. Prev. Round shows the weight the member currently has configured in 
Days Inactive shows how many days it has been since a member's last post (only populated for inactive agents). This may be highlighted for movement into a lower pool if the member has been inactive for too long. Currently there is a 30 day threshold for pool 1, and 60 for pool 2. We will start removing member's that have been inactive for longer than 180 days.
The shares column is highlighted if the count has changed since the last member update. Since we are now printing this sheet, we will clear the highlighting more frequently. In the future, it will be highlighted if the count has changed since the last time that member's voting weight was validated.
Per Post colors
Some members may show a pink or green shading in Per Post. Pink means the member is flagged for movement down into the next pool. The calculations show that their voting weight per post would be below 0.50% in their existing pool. Green means the member is tagged for potential movement into a higher pool as spaces become available.
Pending Registrations
I am deliberately posting this at a point where there are multiple pending registrations. Currently these show at the bottom of the SBI2 tab. These registrations have been captured from the transaction history, but not configured in
Adjustment Frequency
Since voting weights are maintained manually in
Steem Basic Income Enrollment
If you want to join Steem Basic Income... Send 1 STEEM to
Questions?
We broke down the mechanics for how the program works in the complete overview. If you have any questions, ask away in the comments section or join us in our Discord room. https://discord.gg/fpSnkFM