I'd like some software modules and a carton of milk, please

At 20:52 on New Year’s Day I’m answering an email written in capital letters and bold. “We need VOLUNTEERS! And YOU can help us!” It’s the Observatório Social de São José, looking for people to check town hall websites against the access to information law.

There’s a checklist, an estimate of five hours, and a table of fifteen towns with an empty column for the volunteer’s name. I ask for the first two on the list, Faxinal dos Guedes and Fraiburgo, two towns I have never set foot in. Jaime, the president of the observatory, answers “HAPPY AND BLESSED 2014!!!” and I’m in.

A map of Santa Catarina with red pins on Faxinal dos Guedes and Fraiburgo, in the west of the state, and a grey pin on São José, next to Florianópolis on the coast, with a small world map in the corner circling southern Brazil.
My two towns, and the observatory on the coast. Map © OpenStreetMap contributors.
The responsible adult who lives in my head

Five hours, Diego. On the first day of the year. For a spreadsheet.

The checklist is a spreadsheet with 202 yes or no questions, and my favorite part is the last column. Its header asks you to leave a note if you “didn’t understand the question” or “don’t know the technical term”. Somebody knew exactly who would be filling this in.

The first twelve rows of the transparency checklist for Faxinal dos Guedes, with columns for the requirement, the Yes or No answer, the legal basis and my notes. Several answers are a red "No", and my notes say things like "the Contact page only has the emails".
The first 12 of 202. The last column is for when you’re lost.

I use that column a lot. Budget commitments, settlements, payments carried over from the year before… every cell I’m not sure about gets painted purple. By question 7 I’m lost for a different reason, because question 7 is question 1 again (and 8 is 2). When I email Jaime that 12 and 18 are the same question too, he answers that they’ll report it to the prosecutors, who wrote the checklist. Has any town passed yet? Not yet.

And then I can’t stop

On the second night the checklist stops being the point. One name keeps showing up in Faxinal’s expenses with numbers way bigger than everything around it… “Betha Sistemas”, a software company from Criciúma (another city state).

I go looking for the tender behind it and then for the contract behind the tender, and by ten at night the browser has so many tabs that I can’t read their titles anymore, half from one transparency portal and half from the other.

At 21:24 I send Jaime an excited email about a tender that lasted a single day with a single bidder, and half an hour later I’m telling a friend this must be how intelligence cops feel, hahaha. My next email to Jaime starts with “Sorry to bother you again”, because I’ve just learned that tenders lasting 15 minutes are completely normal (Oooops). It has the better find in it, though.

The milk

The contract from that tender is R$136,964 for one year of renting software to a town of about ten thousand people. I scroll down the items. Accounting, payroll, taxes, the health fund… and then items 18 and 19.

A piece of the tender TP10/2012 of the Faxinal dos Guedes city hall in the state's SIACI system. Rows 15 to 17 are software systems for the health and social assistance funds, row 18 is "AGUA" and row 19 is "Leite UHT integral longa vida, embalagem tetra pak contendo", both highlighted.
Item 18 is water. Item 19 is long life whole milk in a Tetra Pak.

Water, and long life whole milk in a Tetra Pak, R$840 each, the same price as the health fund’s purchasing module. A liter of long life milk costs around R$2.50 at the supermarket, so that’s more than 300 liters of milk, or twelve cartons at R$70 each (some very fancy milk). A few rows down there’s food and lodging for the support staff and 5,000 units of travel reimbursement (kilometers, I hope). I add up the 24 prices twice and they come to exactly R$136,964, so the milk is inside the contract.

The prices page of the same tender, with items 18 and 19 highlighted at R$840.00 each.
R$840 of water, R$840 of milk.

Two portals that don’t agree

The city hall’s site links to one transparency portal, SIACI, made by CIASC, the state’s IT company. The town council’s site links to another one, Fly Transparência, made by… Betha.

Item 7 of the contract is the “Portal Transparência” module, so the company I’m reading about rents the town the website I’m using to read about it.

And the two portals tell different stories. The milk only exists in the CIASC one. The city hall’s news says a software tender was cancelled because its own staff would do the work, while Betha’s contract points to a 2012 tender I can’t find anywhere. On both portals the export button doesn’t work, so the numbers can be looked at but not taken anywhere.

By the 3rd I’m comparing what other towns paid Betha in 2013, as amateur as it gets. Criciúma, Betha’s hometown, paid over R$1.2 million, and support and consulting could explain part of the differences, which I say in the email. Still, São José, the observatory’s own city, has almost twenty times Faxinal’s people and paid about a tenth of what Faxinal paid.

What each town paid Betha in 2013, per resident
Faxinal dos Guedes · 10,661 people · R$130k
R$12.19
Criciúma · 192,305 people · R$1.2M
R$6.24
Fraiburgo · 34,556 people · R$27k
R$0.78
São José · 209,804 people · R$14k
R$0.07
Show the numbers
TownPeople (2010)Paid to Betha (2013)Per resident
Faxinal dos Guedes10,661R$130,000R$12.19
Criciúma192,305R$1,200,000R$6.24
Fraiburgo34,556R$27,000R$0.78
São José209,804R$14,000R$0.07
Totals are the rounded numbers from my notes that week (Criciúma's was "over 1.2 million"). Population from the 2010 census, IBGE.

At lunchtime on the 3rd I send the checklist back with only two cells still purple. Question 53 asks if the official site guarantees the authenticity and integrity of what it publishes, so under the checklist I write:

Do these portals guarantee authenticity and integrity? :(

I don’t know if anybody in Faxinal drank that milk. It could be a real purchase, or two lines picked from the wrong catalog when someone typed the tender in. The observatory says they want to compare software prices between towns of the same size soon. I was supposed to be done in five hours, and the tabs are still open, hehehe…

Updates

Update 1, 28 February 2014. The certificate arrived. Eight hours of relevant volunteer service, from 1 to 7 January. Officially.

A certificate from the Observatório Social de São José saying that Diego Dotta did relevant volunteer service from 01/01/2014 to 07/01/2014, eight hours in total, signed by Jaime Luiz Klein, president of the observatory, on 28 February 2014.
Eight hours, officially.

Update 2, 8 March 2014. A friend asked me about the checklist for an idea he’s entering in a Google social impact challenge, and I wrote him a much longer email than this post. My favorite line in it is “I knew software factories had a reputation for working like bakeries, but not literally” (Brazilian bakeries sell milk). I told him anyone could run this checklist on their own town hall if it were a bit friendlier, and confessed that before January I didn’t understand a thing about tenders. “It was transformative”, I wrote, which sounds dramatic for a spreadsheet, but it was.

Update 3, 13 November 2016. Still at it, now with the new council members of Florianópolis: who’s on their payroll?