universal social access to data and calculation

Imagine a cheap, mobile device with a notebook-sized screen that could form an ad hoc network with other such devices nearby.  Imagine that the users of these devices had free spreadsheet software that would allow them to collaboratively share and analyze data across that network. With such hardware and software, persons could meet and set-up custom, multi-period financing transactions with all the details fully accessible, understandable, and analyzable for all parties to the transactions. With such hardware and software, a group could meet, share data concerning their progress toward a common goal, and collectively adjust priorities and resource allocations.  These sort of capabilities could contribute greatly to persons’ efforts to improve their lives.

Work to make such capabilities available to everyone around the world is now underway.  SEETA is adapting SocialCalc, a light-weight, open-source spreadsheet, for the Sugar platform.  The Sugar platform can operate on a  low-cost notebook computer that supports mesh networking, such as OLPC’s XO. Unlike a service that depends on the Internet cloud, SocialCalc on Sugar will work with a peer-to-peer network that can be established through geographic proximity and local wireless networking. Thus collaborative data sharing and analysis will be available to the many persons around the world who lack good, pre-existing data network infrastruture.

With a great spirit of community service and generosity, SEETA has also volunteered to work on making more publicly accessible the Lotus spreadsheets of publicly filed U.S. telephone company tariff data. Telephone company tariff data is quite complicated.  So too is telephone company regulation. Making a large archive of telephone company public tariff data more publicly accessible can help to increase knowledge about communications services and price-cap regulation.  Securing for everyone adequate communication services at reasonable rates is a challenge that could benefit from broad, informed public engagement.  SocialCalc on Sugar can help make broad, informed public engagement with communications data a reality.

*  *  *  *  *

You can experiment with SocialCalc both through a browser and on the Sugar platform.  A browser version of SocialCalc (lacking load and save functions) is available here.   A simple, low-impact way to run  SocialCalc on Sugar is to run Sugar via the Sugar Live CD. Download a disk image (.iso) file of the XO-LiveCD here.  Burn that file as a disk image (ISO) file to a CD (not a DVD). Then download a SocialCalc.xo build to a USB drive.  After that, boot your computer from that XO-LiveCD that you made (shut down your computer, and then immediately on power-up press F-12 or some other key to get into the set-up menu, which should then give you an option to boot from a CD). Booting from the CD will put you in the Sugar environment.  From there, open the Sugar terminal activity and type the command:

sugar-install-bundle "/media/USB DISK/SocialCalc0-8-3g.xo"

(modify appropriately if your USB drive has a different name or you’re using a different build of SocialCalc). That should install SocialCalc as an activity. You may need to restart Sugar to see SocialCalc in the activity list. You can then run it as you would run any other activity under Sugar.

Update: if the SocialCalc install fails, try

sudo sugar-install-bundle "/media/USB DISK/SocialCalc0-8-3g.xo"

and then proceed as described above.

the real X-factor in price-cap regulation

Price-cap regulation often involves extensive discussion of price-cap index formulas.  These formulas usually account for economy-wide price inflation, or, in a more complex scheme, price trends for the regulated-company’s inputs.  Price-cap index formulas typically also account for productivity growth.  Technical issues associated with measuring and interpreting input prices and productivity growth provide fertile ground for contentious regulatory proceedings among dueling economic experts.

The FCC’s telephone company price-cap regulation has involved extensive discussion of index formulas, bands, and index adjustments.  Informed by a variety of economic studies of productivity growth, FCC telephone company price caps have included a productivity factor (called the X-factor) that was 6.5% prior to 2004.  While alternative inflation indices have been considered, FCC telephone company price caps include an inflation adjustment based on the GDP deflator (2.1% for the 2009 filing).  In addition, Service Band Indices (SBIs) have formally limited price changes in service categories such as special-access DS1s and DS3s to 5% per year. [1]

But at least under FCC telephone company price-cap regulation, detailed issues of rate element structure have had more actual importance than price index rules and adjustments. Southwestern Bell Telephone Company’s rate detail, like that for Pacific Bell, has included substantial revenue-aggregate rate elements. Elements with positive aggregate revenue have been included under descriptions such as miscellaneous revenue, expediting charges, and cancellation charges. Aggregate revenue elements are not relevant to a meaningful price index.  Across Southwestern Bell’s annual access filings from 2002 to 2009, the weight of revenue aggregate elements (not including discount elements) varied from 1.0% to 8.5%. Those shares are roughly of the same magnitude as inflation adjustments (1.1% to 3.3%), X-factor productivity adjustments (0 to 6.5%), and SBI band limits (2% to 5%) applied to the constructed price indices.[2]

Credit aggregate-revenue elements (which report negative aggregate revenue) are even larger than the positive aggregate revenue elements.  In its 2009 annual filing, Southwestern Bell included Managed Value Plan (MVP) aggregate credit elements for DS1 and DS3 service that amounted to 18% and 24% of reported DS1 and DS3 revenue before subtracting the credit value.  In the special access basket overall, aggregate credit elements amounted to 22% of total basket revenue before credits. The relation of these credits to rates for services included in the special access basket isn’t clear.[3]  But clearly these credits have more weight in price caps than typical inflation and productivity adjustment factors.

* *  *  *  *

Data:  Southwestern Bell Telephone rate detail, 1993-2009;  online spreadsheets detailing Southwestern Bell statistics described above (also available as an Excel workbook)

Notes:

[1] FCC telephone company (interstate access) price cap regulations are set out mainly in 47 CFR 61.41 through 47 CFR 61.49.  Updating of the price cap indices (PCIs) is set out in 47 CFR 61.45. In 1999, FCC price caps included an Actual Price Index (API) and Price Cap Index (PCI) for five service baskets — common line, traffic sensitive, trunking, inter-exchange, and marketing.  In addition, FCC price caps included 40 Service Band Indices (SBIs).  Prior to 1997, lower bounds as well as upper bounds constrained changes in SBIs.  After 1999, a special access basket was split off from the trunking basket, and the marketing basket was eliminated.  By 2009. the number of SBIs had risen to 104, mainly as the result of the permitted number of zones expanding from three to seven.

[2] SBI increases of up to 15% were permitted for SBIs applied at the level of a specific zone for a particular service, e.g. zone 1 for DS1 service.  See 47 CFR 61.47(f).

[3] Southwestern Bell MVP commitment discounts increase from 9% to 14% over the course of the five-year MVP.  In addition, Southwestern Bell offers up to 2% credit for its failure to meet specified service-level assurance standards.  Even if all DS3 service was bought under a MVP, all plans were in the fifth year of the contract, and Southwestern Bell paid the maximum credit for service shortcomings, MVP credits would amount to only 16% of top-line DS3 revenue.  Why DS3 MVP credits amount to 24% of Southwestern Bell’s total price-cap-reported DS3 revenue (before subtracting credit) isn’t clear.  Southwestern Bell’s MVP tariff is Section 38 in its FCC tariff.

Orwellian authorship

The title page declares:

Seneca’s

Oedipus

Adapted by Ted Hughes

Introduction by Peter Brook

Illustrated by Reginald Pollack

Doubleday & Company, Inc.,

Garden City, New York 1972

The next page notes:

Note: Seneca’s Oedipus is the sole property of the author and is fully protected by copyright. … All rights, including professional, amateur, stock, radio and television broadcasting, motion picture, recitation, lecturing, public readings, and the rights of translation in [sic] foreign languages are reserved.  All inquiries should be addressed to the author’s agent: Olwyn Hughes….

This conception of authorship isn’t romantic; it’s horrible and fearful. It’s a worse curse than Merwin’s.  Hell, if I foolishly believed I would generate some pity, I would stick my head into a heating oven.