Hi friends, *Pune annual budget 2016-17 SC (final) expenditures extract/database*
Download it: http://ourpuneourbudget.in/files/data/puneMCbudget2016-17/pune_2016-17_SC_budget_expnds_db_12Apr16.xlsx -> this is also linked to from our website, http://ourpuneourbudget.in (which is linked to from PMC offiicial site, http://www.punecorporation.org/budget.aspx). And you can download the original pdf, excel (released by PMC) also from any of the sites. Lots of observations to share, will write in later. Major USPs of this doc : 1. Item-wise tracking of alterations made to budget as it went from MC (Municipal Commissioner's draft) version to SC (Standing Committee's final) version. 2. Each budget item has a parent code assigned so you can trace back where it's coming from; that should help you locate all items under a certain department. 3. Work descriptions are in unicode Marathi, so the doc is fully searchable, info can be copy-pasted anywhere, read from mobile and tablets. (and so a relief from having to install ShreeDev, Kruti etc fonts.. compliments to PMC for making the switch) 4. A depts-lookup worksheet is included which will give you a printable readout of the various departments etc that make up the PMC, with list of budget code prefixes that should help you read any budget item with context. It would be wonderful if you wrote in your analysis, observations in the comments section of our website. Basic idea : we want to empower you to take the full data into your hands, figure it out, and do your own analysis. Also, there is a team of volunteers from Datameet Pune chapter that is working together on analyzing the budget. We have started with education and water sectors, assigning categories and locations. Please contact us on [email protected] if you'd like to join in. /* ===== For the nerds ===== */ Check out the working doc, where all formulas etc are there, if you'd like to see how the data was pulled together from various sources (major excel formula-giri): http://ourpuneourbudget.in/files/data/puneMCbudget2016-17/pune%202016-17%20budget%20simplified_12Apr16-working.xlsx Here is a CSV version: http://ourpuneourbudget.in/files/data/puneMCbudget2016-17/csv_pune_2016-17_SC_budget_expnds_db_12Apr16.csv /* =============== */ Notes: 1. I still have to work on updating the visualizations (which are showing draft budget not final) on the website. Should be done in a couple of days. 2. If you find any _numerical_ error in the doc, then please bring it to my attention asap and avail a free wada pav + chai treat! 3. This is the first time PMC is transparently sharing its budget data in excel format, and it'll be interesting to find where else it's happening in India.. deserves compliments and encouragement from citizens! Pls send in your appreciation to the municipal commissioner on [email protected], [email protected] . 4. No, we're not translating it, you learn to read Marathi! :P :P Or volunteer.. there's only 9.6k lines to translate.. and the automatic translations are too hilarious to publish :D. Addendum: Here is a project proposal / design ppt for an open source bus routes management system that should make life simpler for bus authorities and commuters in Indian cities. Could you pass it on to programmers, comp students who might be interested in taking it up as a summer project? https://docs.google.com/presentation/d/1FuLHS84uHuxQEsEquiWxcuiUdkv7Z8l29ImsYay5SHc/edit?usp=sharing (this is schedule-based, not live GPS tracking-based.) -- -- Cheers, Nikhil +91-966-583-1250 Pune, India Self-designed learner at Swaraj University <http://www.swarajuniversity.org> http://nikhilsheth.blogspot.in -- Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org --- You received this message because you are subscribed to the Google Groups "datameet" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
