THE SPREADSHEET WIKI

Goal Based Mass Collaboration Accounting & Data Processing
(with near real time computation of results)




Abstract
The spreadsheet wiki is needed so as to allow complex data gathering tasks [that are prone to accuracy, consistency and traceability problems] like public accounting, enterprise bookkeeping, etc ... that by their nature "require relatively low computational overhead" (ie: ~1.2 seconds on web server, max) to be continuously updated (and audited) by hundreds of participants.

Ideally it is designed for spreadsheets that are 90% data, 10% computation -- but ideally it works best for 99.5% data, 0.5% computation. Computation means formulas -- and data means numerical data [as per the spreadsheet idiom].

The wiki user interface to the spreadsheet computation engine is paramount. Behind the wiki user interface there must be a 3D spreadsheet computational engine.

This is not a regurgitation of technologically defunct collaborative 2D and 3D spreadsheet designs of the 20th century, as these 2D and 3D spreadsheets did not really allow for Wiki style interactivity as they were designed for corporate workgroups. The 20th century corporate workgroup "collaborative spreadsheet" is technologically defunct in 21st century -- these spreadsheets were always more trouble than they were worth.

Why will wiki spreadsheets succeed where workgroup spreadsheets have failed completely?
  1. Not enough people, corporate workgroups with less than 10 people can generate spreadsheets with unlimited design, logic and "garbage in, garbage out" data input errors.
  2. Corporate workgroup spreadsheets had inferior auditing tools from the time of their inception. Wikis have very good auditing tools, for a technology that is open source.
  3. Lower complexity: The goals and objectives of the spreadsheet administrator are more likely to be met if the administrative owner of the spreadsheet is constantly overseeing the spreadsheets emergence.

How does it work? How should it work?

By using a highly paired down wiki user interface technology a highly controlled user interface

Barriers that will have to be overcome with intellectual leaps in programming


Mechanical implementation details

Modification privileges
Spreadsheet wiki property
Spreadsheet property (single sheet in a 3D page structure)
Cell properties


Never ending problems
You can't just dump a web based spreadsheet program and use it
Known spreadsheet deficiencies that Wiki systems may be able to partly or totally fix
How do you interact with the wiki at the cell level?
This will take some time to consider. This is being worked on.

Possible applications for THE SPREADSHEET WIKI


Computations like "Total National US Debt" need to be wikified in order for the any solution to ever to be known


Column 1
Column 2
Column 3



Known Data
Notes & Sources
Total US Population 304,123,123 Via US Census Clock, now 305 millions
Total US Working Population 244,819,114
Total US Tax Paying Population 200,751,673



Removal Working Population from % pop 19.50% Accurate real world numbers needed
Removal non-Tax Paying Pop from % Working Pop 18.00% Accurate real world numbers needed
Governmental Interest Rate Average 4.55% Accurate real world numbers needed
Commercial Interest Rate Average 8.50% Accurate real world numbers needed
Consumer Interest Rate Average, housing 7.50% Accurate real world numbers needed
Consumer Interest Rate Average, non housing 15.55% Accurate real world numbers needed



Federal Govt Debt $53,000,100,100,100 Dollars
State Govt Debt $5,000,100,100,010 Total Dollars – known guesstimate
Local Govt Debt (county, city, water districts, etc) $2,501,000,100,011 Dollars – known guesstimate
Consumer Housing Debt $30,000,100,100,100 Dollars – known guesstimate
Consumer Credit Card Debt, Car Loan Debt etc... $20,000,100,100,101 Dollars – known guesstimate
Commercial Sector Debt $10,000,000,100,011 Dollars – known guesstimate



Interest Incurred Debt (commercial, 5 years) $4,250,000,042,505 Constant dollars (2008)
Interest Incurred Debt (consumer, 7 years) $37,520,161,511,513 Constant dollars (2008)
Interest Incurred Debt (governmental, 20 years) $55,056,092,273,110 Constant dollars (2008)



Debt Total $217,327,654,427,460 Dollars for total debt from all sources



Implied outcomes

Debt per person $714,604.18 What is owed per person
Debt per working person $887,707.05 What is owed per working person
Debt per tax paying person $1,082,569.58 What is owed per working tax paying person

User interface notes:
Users would only be allowed to input: Text into Column 1, Numeric Data & Formulas into Column 2, and Text into Column 3.

Model notes for spreadsheet above and in question

A taxable person is a person that has paid at least 1 USD more in taxes (from their own microsegment of GDP or GNP that they produce) than they have consumed in government services in their lifetime (and technically is a moving average number that changes as the economy does). However, due to the depth of consumption of government services the above numbers relating to taxable persons in this spreadsheet model are probably overestimates (by an unknown order of magnitude). Taxable people are generally tied to corporate entities (even if the corporate entities are minor), so corporate taxes and personal taxes do at least have the possibility of nominally meeting in the spreadsheet model. Corporations in some situations are notorious for consuming more government services than the taxable GNP or GDP that they produce. In the US model, corporations can never technically die -- except via select forms of bankruptcy or insolvency.

Under the Internal Revenue Code, the income of a U.S. citizen is taxable without regard to the citizen's place of residence, and, significantly, without regard to where the income is earned or produced. Hence, a US citizen can eliminate his tax liability only by both moving abroad and renouncing citizenship.

The process of renunciation requires the US citizen to appear at a foreign US embassy or consulate, prove that another citizenship has already been obtained (so that the renunciation will not make one a stateless person), and sign various documents which basically state that you are of good mental health, acting without force or duress, and realise that the renunciation is irrevocable. The State Department then reviews the documentation and may decide to permanently bar the person from entering the US - even for visits. This decision is based upon whether or not State decides that the person renouncing is or is not doing so for tax reasons alone. For the purposes of the IRS, the effective date of the renunciation becomes the final day that US income taxes are due - assuming that all US assets are liquidated and have left US jurisdiction.

An immigrant who has been granted permanent resident status in the U.S. is generally treated as a citizen for tax purposes. An immigrant not legally admitted for permanent residence (such as a guest worker) becomes liable for U.S. taxes if he spends more than 122 days in the year in the United States.

The US tax law, at the state and federal level -- broadly speaking -- only tolerates Americans taking money outside the US. As long as money taken outside the US is never brought back into the US there is no violation of the law. It is broadly understood that Americans can use corporations or trusts to cover moving money outside the US, providing that said corporations or trusts are not based in nations that would raise suspicion.

Broadly speaking, the US taxation rules encourage people to move their assets offshore -- and to retire offshore. This creates a permanent outflow of United States dollars into other currency zones.

Tax avoidance is the legal utilisation of the tax regime to one's own advantage, in order to reduce the amount of tax that is payable by means that are within the law. By contrast tax evasion is the general term for efforts to not pay taxes by illegal means. The term tax mitigation is a synonym for tax avoidance. Its original use was by tax advisers as an alternative to the pejorative term tax avoidance. Latterly the term has also been used in the tax regulations of some jurisdictions to distinguish tax avoidance foreseen by the legislators from tax avoidance which exploits loopholes in the law.

Some of those attempting not to pay tax believe that they have discovered interpretations of the law that show that they are not subject to being taxed: these individuals and groups are sometimes called tax protesters. An unsuccessful tax protester has been attempting openly to evade tax, while a successful one avoids tax. Tax resistance is the declared refusal to pay a tax for conscientious reasons (because the resister does not want to support the government or some of its activities). Tax resistors typically do not take the position that the tax laws are themselves illegal or do not apply to them (as tax protesters do) and they are more concerned with not paying for particular government policies that they oppose.



Further reading

Ideas and Systems applicable to this technology

Similar technologies, but different operating principals

Wiki technology notable modifications



Created by
Max Power

Created
10 OCT 2008

Last updated
23 March 2013