<commit_before>const React = require('react')
const Helmet = require('react-helmet')

const About = React.createClass({
  renderContent () {
    return (
      <div>
        <div><p className="c1 c6"><span className="c3"></span></p></div><h2 className="c8" id="h.7enzlilnfjz4"><span className="c18">About</span></h2><p className="c1"><span className="c3">The Georgian Budget site allows you to explore the planned and spent budgets of the Georgian government from 2012 to present. You can view the entire national budget at a monthly, quarterly, or yearly level, and you can zoom into the budget to inspect the government's priorities, spending agencies, and programs.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c0"><span>The data in the Georgian Budget site comes from Freedom of Information (FOI) requests to the Ministry of Finance and the Ministry of Finance website. You can click here to </span><span className="c11"><a className="c7" href="https://github.com/JumpStartGeorgia/Georgian-Budget-Files/files_from_government">view all of the files we have received from the Ministry of Finance</a></span><span>. We plan is to update the Georgian Budget site with the latest data every month. We have spent a lot of time cleaning and merging the data so it can be analyzed over time. You can download the </span><span className="c11"><a className="c7" href="https://biujeti-api.jumpstart.ge/ka/csv/complete_primary_finances">Georgian</a></span><span>&nbsp;and </span><span className="c11"><a className="c7" href="https://biujeti-api.jumpstart.ge/en/csv/complete_primary_finances">English</a></span><span className="c2">&nbsp;versions of our cleaned dataset.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>The Georgia Budget site was funded by the </span><span className="c16"><a className="c13" href="http://www.ned.org/">National Endowment for Democracy (NED)</a></span><span>&nbsp;and implemented by </span><span className="c16"><a className="c13" href="https://jumpstart.ge">JumpStart Georgia</a></span><span>.</span></p><h2 className="c8" id="h.eqwwt8vs0mgo"><span className="c18">Understanding the Georgian Budget</span></h2><p className="c1"><span className="c3">The Georgian budget has many parts to comprehend, so here is a small introduction to the ins and outs of the budget.</span></p><h3 className="c5" id="h.3tkm49sfbjvq"><span className="c14">The Main Components</span></h3><p className="c1"><span className="c3">The Georgian budget is made up of three components:</span></p><ul className="c12 lst-kix_aayeb5tzyo5t-0 start"><li className="c0"><span>The entire Georgian budget is split amongst all </span><span className="c9">Spending Agencies</span><span className="c3">&nbsp;(ministries, LEPLs, etc).</span></li><li className="c0"><span>Each Spending Agency can have </span><span className="c9">Programs</span><span className="c3">&nbsp;that they fund.</span></li><li className="c0"><span>A collection of these Spending Agencies and Programs are combined to form </span><span className="c9">Priorities</span><span className="c3">.</span></li></ul><h3 className="c5" id="h.k1usq3d1jqr2"><span>T</span><span className="c14">he Relationships Between the Components</span></h3><ul className="c12 lst-kix_d8g0k5a4cmsy-0 start"><li className="c0"><span className="c3">A Priority can have many Spending Agencies (and all of the Spending Agency’s Programs) and/or individual Programs within a Spending Agency.</span></li><li className="c0"><span className="c3">A Spending Agency belongs to one or more Priorities and can have zero or more Programs.</span></li><li className="c0"><span className="c3">A Program belongs to one Priority and one Spending Agency and can have zero or more subprograms.</span></li></ul><h3 className="c5" id="h.ov86btcauj8a"><span className="c14">Relationships Change</span></h3><p className="c1"><span>Every time the government releases a new budget, they have the possibility to change the</span><span>&nbsp;relationships between Priorities, Spending Agencies, and Programs. For instance, </span><span>they may assign Program A to Spending Agency A in 2012, and then move it to Spending Agency B in 2013. This means that a Program, when considered over its entire lifetime, can belong to multiple Spending Agencies and Priorities.</span><span>&nbsp;</span></p><h3 className="c5" id="h.fr4fs1hkrne8"><span className="c14">The Finances</span></h3><p className="c1"><span className="c3">The Georgian Budget is split into two main finance types: </span></p><ul className="c12 lst-kix_3afxef41plvs-0 start"><li className="c0"><span>Planned - how much </span><span>the government plans to spend</span></li><li className="c0"><span>Spent - how much </span><span>the government actually spent</span></li></ul><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>The</span><span>&nbsp;government plans the budget in quarterly and yearly increments. However, the quarterly plans are released three times, in each of the quarter’s three monthly budget spreadsheets, which means that the government can (and sometimes does) change the quarterly plan one or two times (in the second and third month’s spreadsheets). Similarly, the initial plan for a year is first released at the beginning of a year, but can be revised once the year is completed, in the following year’s budget.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>The </span><span>government publishes how much was spent every month. </span><span>Spent budget for a year is recorded on a monthly basis. The official finalized Spent budget is not available until a year after the year is completed (i.e., the final Spent budget for 2015 is released </span><span>at the beginning of</span><span>&nbsp;2017).</span></p><p className="c1 c6"><span className="c3"></span></p><h2 className="c8" id="h.3e7t0tu5f6lv"><span className="c18">Methodology</span></h2><p className="c1"><span>The Georgian Budget data available on this site is a combination of original data from the Ministry of Finance and </span><span>data computed from this original data</span><span className="c3">.</span></p><h3 className="c5" id="h.iz3d5yyj9j1e"><span className="c14">Data Sources</span></h3><p className="c1"><span className="c3">The data on the Georgian Budget site comes from 3 different sets of files.</span></p><h4 className="c17" id="h.dfhjwjdo3c25"><span className="c2">Monthly Spreadsheets</span></h4><p className="c1"><span>Through Freedom of Information (FOI) requests, we obtain spreadsheets with the Planned and Spent finances that occurred in a given month for </span><span>the total national budget, </span><span>all Spending Agencies</span><span>, and all</span><span>&nbsp;Programs. You can click here to </span><span className="c16"><a className="c13" href="https://github.com/JumpStartGeorgia/Georgian-Budget-Files/tree/master/files_from_government/monthly_spreadsheets">view all of the monthly spreadsheet files we have received from these FOI requests</a></span><span className="c3">.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">Please Note:</span></p><ul className="c12 lst-kix_mk43hej5vmeg-0 start"><li className="c0"><span>The Planned and Spent values are cumulative for the year</span><span>. To get each month’s non-cumulative Spent amount,</span><span>&nbsp;you have to subtract the </span><span>previous month’s cumulative </span><span>value</span><span>&nbsp;from that month’s cumulative value</span><span>.</span><span>&nbsp;To get each quarter’s non-cumulative Planned amount, you have to subtract the previous quarter’s cumulative value from that quarter’s cumulative value.</span></li><li className="c0"><span className="c3">Each Planned amount is for the quarter that the monthly spreadsheet belongs to. In other words, if the government planned to spend 100,000 lari on a program during each month in the first quarter of the year, then it would record 300,000 lari in the January spreadsheet for that program’s plan. </span></li></ul><h4 className="c17" id="h.s3v0db79318w"><span className="c2">Yearly Spreadsheets</span></h4><p className="c1"><span>Through Freedom of Information (FOI) requests, we obtain spreadsheets with the Planned and Spent finances that occurred in a given year for</span><span>&nbsp;the total national budget,</span><span>&nbsp;all Spending Agencies</span><span>, and all</span><span>&nbsp;Programs. You can click here to </span><span className="c16"><a className="c13" href="https://github.com/JumpStartGeorgia/Georgian-Budget-Files/tree/master/files_from_government/yearly_spreadsheets">view all of the yearly spreadsheet files we have received from these FOI requests</a></span><span className="c3">.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">Please Note:</span></p><ul className="c12 lst-kix_mk43hej5vmeg-0"><li className="c0"><span className="c3">The yearly spreadsheet contains data for three different years.</span></li></ul><ul className="c12 lst-kix_mk43hej5vmeg-1 start"><li className="c1 c7"><span className="c3">Two years ago - official finalized Spent finances </span></li><li className="c1 c7"><span className="c3">One year ago - official finalized Planned finances</span></li><li className="c1 c7"><span className="c3">Current year - proposed Planned finances</span></li><li className="c1 c7"><span className="c3">For example, the 2015 yearly spreadsheet has the following:</span></li></ul><ul className="c12 lst-kix_mk43hej5vmeg-2 start"><li className="c1 c10"><span className="c3">2013 official finalized Spent finances</span></li><li className="c1 c10"><span className="c3">2014 official finalized Planned finances</span></li><li className="c1 c10"><span className="c3">2015 proposed Planned finances</span></li></ul><ul className="c12 lst-kix_mk43hej5vmeg-0"><li className="c0"><span className="c3">Exceptions to the above rules:</span></li></ul><ul className="c12 lst-kix_mk43hej5vmeg-1 start"><li className="c1 c7"><span>The 2012 yearly spreadsheet contain</span><span>s neither</span><span>&nbsp;the 2011 final Planned finances </span><span>n</span><span className="c3">or the 2010 final Spent finances</span></li><li className="c1 c7"><span>The 2013 yearly spreadsheet contain</span><span>s neither</span><span>&nbsp;the 2012 final Planned finances </span><span>n</span><span className="c3">or the 2011 final Spent finances</span></li></ul><h4 className="c17" id="h.e788sf8loisp"><span className="c2">Priority PDFs</span></h4><p className="c1"><span className="c3">The Ministry of Finance posts PDF documents to their website that indicate which Spending Agencies and Programs belong to a Priority for a given year. </span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>You can click here to </span><span className="c16"><a className="c13" href="https://github.com/JumpStartGeorgia/Georgian-Budget-Files/tree/master/files_from_government/priority_pdfs">view all of the Priority PDFs</a></span><span>&nbsp;that we have downloaded from the Ministry of Finance website</span><span>. Or you can find them directly from the Ministry of Finance website by </span><span>following these instructions</span><span className="c3">:</span></p><ol className="c12 lst-kix_1nktlzyfnqih-0 start" start="1"><li className="c0"><span>Go to the </span><span className="c16"><a className="c13" href="http://mof.gov.ge/4562">Ministry of Finance Budget page</a></span></li><li className="c0"><span className="c3">In the bottom, select the year you want to view</span></li><li className="c0"><span className="c3">Again, in the bottom select the year you want to view</span></li><li className="c0"><span className="c3">Now you see a long list of links to documents</span></li><li className="c0"><span>Look for the link labeled ‘ბიუჯეტით განსაზღვრული პროგრამების მოსალოდნელი შედეგები და ინდიკატორები’ and click on it to get the PDF</span></li></ol><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">Please Note:</span></p><ul className="c12 lst-kix_r83f73h0xvb3-0 start"><li className="c0"><span>We use these documents to assign Spending Agencies and Programs to Priorities</span><span>, and to figure out how to calculate Priority finances from its Spending Agencies and Programs</span><span className="c3">&nbsp;so that we can calculate the Priority finances. </span></li><li className="c0"><span>We do not use any of the financial information recorded in </span><span>these documents</span><span>.</span><span className="c3">&nbsp;These documents only include yearly plans; they include neither quarterly plans nor any data about how much was spent. Therefore, we choose to calculate all of a Priority’s financial information by summing the financial data we have for its Spending Agencies and Programs from the yearly and monthly spreadsheets.</span></li><li className="c0"><span>Because </span><span>we calculate Priority yearly plans from the yearly and monthly spreadsheets</span><span>, it is possible that our numbers do not match the numbers in the PDF document for one of the following reasons:</span></li></ul><ul className="c12 lst-kix_r83f73h0xvb3-1 start"><li className="c1 c7"><span className="c3">We have found that a Program is included in the Priority PDF document but never appears in the monthly or yearly spreadsheets.</span></li><li className="c1 c7"><span className="c3">We have found that a Program is included in the Priority PDF document and the monthly spreadsheet, but never appears in the yearly spreadsheets.</span></li><li className="c1 c7"><span>We are trying to get answers from the Ministry of Finance on why this discrepancy is occurring.</span></li></ul><p className="c1 c6"><span className="c3"></span></p><h3 className="c5" id="h.l89fqj9u1a0p"><span className="c14">Using the Data</span></h3><p className="c1"><span>The following is a breakdown of which data we pull directly from the Ministry of Finance spreadsheets and PDF documents</span><span>,</span><span>&nbsp;and which </span><span>data we calculate</span><span className="c3">.</span></p><h4 className="c17" id="h.i8tosyu2r9y0"><span>Official</span><span className="c2">&nbsp;Data</span></h4><p className="c1"><span className="c3">From the monthly spreadsheets, we get the Planned and Spent amounts for the total national budget, Spending Agencies, and Programs.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">Please Note:</span></p><ul className="c12 lst-kix_gcwbozehe4p1-0 start"><li className="c0"><span className="c3">The monthly data is recorded as a cumulative value of all months in the year, so we have to subtract the previous month’s value to get the amount for a given month.</span></li></ul><ul className="c12 lst-kix_gcwbozehe4p1-1 start"><li className="c1 c7"><span className="c3">For example, March’s Spending value is 400,000 and April’s Spending value is 500,000, so the actual money spent in April is 100,000 (500,000-400,000).</span></li></ul><ul className="c12 lst-kix_gcwbozehe4p1-0"><li className="c0"><span>The monthly data for Planned is actually the amount planned for the quarter the month is in and not the month</span><span>&nbsp;itself</span><span>. Given this, the planned amount can change every month, so we do the following to get the </span><span>correct</span><span className="c3">&nbsp;value:</span></li></ul><ul className="c12 lst-kix_gcwbozehe4p1-1 start"><li className="c1 c7"><span className="c3">If we do not have all monthly spreadsheets for a quarter, we use the value from the last month in the quarter that we do have.</span></li><li className="c1 c7"><span className="c3">If we have all monthly spreadsheets for a quarter, we use the value from the last month in the quarter.</span></li></ul><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">From the yearly spreadsheets, we get the following data:</span></p><ul className="c12 lst-kix_kcua5tf962fg-0 start"><li className="c0"><span>Official</span><span>,</span><span>&nbsp;finalized Spent amounts for the total national budget, Spending Agencies, and Programs that </span><span>describe what was Spent two years before the spreadsheet was published</span><span className="c3">.</span></li><li className="c0"><span>Official</span><span>,</span><span>&nbsp;finalized Planned amounts for the total national budget, Spending Agencies, and Programs that occurred </span><span>one year before the spreadsheet was published</span><span className="c3">.</span></li><li className="c0"><span className="c3">The proposed Planned amounts for the total national budget, Spending Agencies, and Programs that are to occur in the current year.</span></li></ul><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">Please Note:</span></p><ul className="c12 lst-kix_tuczby54wam8-0 start"><li className="c0"><span>The Official finalized yearly Planned data </span><span>for any given year is released after the year is finished</span><span className="c3">, so if this data has not been released yet, we use the proposed Planned data from that year’s yearly spreadsheet. When the final data becomes available, this value will be updated with the correct finalized value.</span></li></ul><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">From the yearly Priority PDFs, we are able to assign Spending Agencies and Programs to each Priority.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">Please Note:</span></p><ul className="c12 lst-kix_ac4g7j37p0du-0 start"><li className="c0"><span className="c3">If a Spending Agency is assigned to a Priority and that Spending Agency has Programs, all of those Programs are also assigned to the Priority.</span></li><li className="c0"><span>If a Program is assigned to a Priority, its Agency, Programs it is a Subprogram of, and all of its Subprograms are &nbsp;also assigned to the Priority.</span></li></ul><h4 className="c17" id="h.1foezkgvhc50"><span className="c2">Computed Data</span></h4><ul className="c12 lst-kix_8izxqj7p1qav-0 start"><li className="c0"><span className="c3">The Spent data is not available in quarterly time frames, so we compute the quarterly amounts by summing up the Spent values for the three months in each quarter. For example, if we had the following Spent amounts: January - 100,000; February - 250,000; March - 150,000, then the total Spent for the quarter is 500,000.</span></li></ul><ul className="c12 lst-kix_8izxqj7p1qav-1 start"><li className="c1 c7"><span className="c3">If we do not have all the Spent values for all months in a quarter, the quarter amount is the sum of the months that we do have.</span></li></ul><ul className="c12 lst-kix_8izxqj7p1qav-0"><li className="c0"><span>The Official finalized yearly Spent data is not released until two years later, so if this data has not been released yet, we add up the monthly Spent data of the year to get the total for the year. </span><span>This value is updated with the official value when it becomes available. </span></li></ul><ul className="c12 lst-kix_ac4g7j37p0du-0"><li className="c0"><span>All </span><span>Priority financial data </span><span>&nbsp;are computed by </span><span>aggregating &nbsp;the data for the Spending Agencies and Programs listed below each Priority in the Priority PDFs. </span></li></ul><ul className="c12 lst-kix_ac4g7j37p0du-1 start"><li className="c1 c7"><span className="c3">As described in the above section, we assign Spending Agencies and Programs to a Priority that are related to the Spending Agencies and Programs listed below the Priority. However, these Spending Agencies and Programs are not used in calculating the Priority’s financial data; only those that are listed below the Priority are used in the calculations.</span></li><li className="c1 c7"><span className="c3">Note - The Spending Agencies and Programs assigned to a Priority can change every year so all computations are done using the assignments for the given year. </span></li></ul><h3 className="c5" id="h.cgu4fk7v7vmt"><span className="c14">Tracking Over Time</span></h3><p className="c1"><span>As mentioned previously, the Priorities, Spending Agencies, and Programs are in a constant state of flux, so tracking a particular budget item </span><span>can be a significant challenge</span><span>. Below is an explanation of how we attempt</span><span>ed</span><span className="c3">&nbsp;to accomplish this task.</span></p><h4 className="c17" id="h.svc6xo6jeyjm"><span className="c2">The Situation</span></h4><p className="c1"><span>The government assigns</span><span>&nbsp;each Spending Agency and Program</span><span>&nbsp;a code</span><span>, </span><span>such as “01 00” or “05 03 02”. However,</span><span>&nbsp;</span><span>the codes of a Spending Agency and Program can change at any time.</span><span className="c3">&nbsp;It is possible for a new Spending Agency or Program to be assigned a code of a previous Spending Agency or Program. If the previous Spending Agency or Program still exists, it has now been assigned a new code. This means that we cannot simply match the code from each spreadsheet and assume it is for the same Spending Agency or Program.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>On top of that, Spending Agency and Program names constantly change, even within a year.</span><span>&nbsp;so using the combination of code and name is also not a perfect way to match records from each spreadsheet.</span></p><h4 className="c17" id="h.ixyl2bog6e3m"><span>Our Solution</span></h4><p className="c1"><span>We programmatically attempt to match records from one time period to another by looking for records that have the same code and name.</span><span>&nbsp;</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>W</span><span>hen this approach does not find a match, we have to manually </span><span>determine </span><span>which record</span><span>s correspond to one another. This occurs, for example, when we identify two records that have the same code but different names. </span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>Given this</span><span>&nbsp;process</span><span>, human error is possible</span><span>. We</span><span>&nbsp;</span><span>may</span><span>&nbsp;have matched Spending Agencies or Programs that are actually different</span><span>,</span><span>&nbsp;or we </span><span>may</span><span className="c3">&nbsp;have missed records that should have been matched.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">When we do match records, we had to come up with a process of how to properly merge these records. Below is the explanation of what we do.</span></p><ul className="c12 lst-kix_gbx2dh3jrvtf-0 start"><li className="c0"><span className="c3">When the code changes, we use the most recent code.</span></li><li className="c0"><span className="c3">When the name changes, we use the most recent name.</span></li><li className="c0"><span className="c3">For a Priority, we show:</span></li></ul><ul className="c12 lst-kix_gbx2dh3jrvtf-1 start"><li className="c1 c7"><span className="c3">All related Spending Agencies that have at one time been associated with this Priority</span></li><li className="c1 c7"><span>All related</span><span>&nbsp;top-level</span><span>&nbsp;Programs</span><span>&nbsp;(not Subprograms)</span><span className="c3">&nbsp;that have at one time been associated with this Priority</span></li></ul><ul className="c12 lst-kix_gbx2dh3jrvtf-0"><li className="c0"><span className="c3">For a Spending Agency, we show:</span></li></ul><ul className="c12 lst-kix_gbx2dh3jrvtf-1 start"><li className="c1 c7"><span className="c3">All Priorities that have at one time been associated with this Spending Agency</span></li><li className="c1 c7"><span>All </span><span>top-level </span><span>Programs</span><span>&nbsp;(but not Subprograms of these programs) </span><span className="c3">associated with this Spending Agency</span></li></ul><ul className="c12 lst-kix_gbx2dh3jrvtf-0"><li className="c0"><span className="c3">For a Program, we show:</span></li></ul><ul className="c12 lst-kix_gbx2dh3jrvtf-1 start"><li className="c1 c7"><span className="c3">The most recent Spending Agency</span></li><li className="c1 c7"><span className="c3">The most recent parent Program, if one exists</span></li><li className="c1 c7"><span className="c3">All Priorities that have at one time been associated with this Program</span></li></ul><h3 className="c5" id="h.l2yjexj9480i"><span className="c14">Final Thoughts</span></h3><p className="c1"><span>Budgets are complicated</span><span>, and trying to make sense of the Georgian budget has presented many challenges.</span><span className="c3">&nbsp;Please get in touch with us if you find an error in the data or in the logic of our methodology, or if you wish to contribute to this project.</span></p><p className="c1 c6"><span className="c3"></span></p>
      </div>
    )
  },

  render () {
    return (
      <div>
        <Helmet
          title='About'
        />

        {this.renderContent()}
      </div>
    )<commit_msg>Fixed files from government about links.<commit_after>const React = require('react')
const Helmet = require('react-helmet')

const About = React.createClass({
  renderContent () {
    return (
      <div>
        <div><p className="c1 c6"><span className="c3"></span></p></div><h2 className="c8" id="h.7enzlilnfjz4"><span className="c18">About</span></h2><p className="c1"><span className="c3">The Georgian Budget site allows you to explore the planned and spent budgets of the Georgian government from 2012 to present. You can view the entire national budget at a monthly, quarterly, or yearly level, and you can zoom into the budget to inspect the government's priorities, spending agencies, and programs.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c0"><span>The data in the Georgian Budget site comes from Freedom of Information (FOI) requests to the Ministry of Finance and the Ministry of Finance website. You can click here to </span><span className="c11"><a className="c7" href="https://github.com/JumpStartGeorgia/Georgian-Budget-Files/tree/master/files_from_government">view all of the files we have received from the Ministry of Finance</a></span><span>. We plan is to update the Georgian Budget site with the latest data every month. We have spent a lot of time cleaning and merging the data so it can be analyzed over time. You can download the </span><span className="c11"><a className="c7" href="https://biujeti-api.jumpstart.ge/ka/csv/complete_primary_finances">Georgian</a></span><span>&nbsp;and </span><span className="c11"><a className="c7" href="https://biujeti-api.jumpstart.ge/en/csv/complete_primary_finances">English</a></span><span className="c2">&nbsp;versions of our cleaned dataset.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>The Georgia Budget site was funded by the </span><span className="c16"><a className="c13" href="http://www.ned.org/">National Endowment for Democracy (NED)</a></span><span>&nbsp;and implemented by </span><span className="c16"><a className="c13" href="https://jumpstart.ge">JumpStart Georgia</a></span><span>.</span></p><h2 className="c8" id="h.eqwwt8vs0mgo"><span className="c18">Understanding the Georgian Budget</span></h2><p className="c1"><span className="c3">The Georgian budget has many parts to comprehend, so here is a small introduction to the ins and outs of the budget.</span></p><h3 className="c5" id="h.3tkm49sfbjvq"><span className="c14">The Main Components</span></h3><p className="c1"><span className="c3">The Georgian budget is made up of three components:</span></p><ul className="c12 lst-kix_aayeb5tzyo5t-0 start"><li className="c0"><span>The entire Georgian budget is split amongst all </span><span className="c9">Spending Agencies</span><span className="c3">&nbsp;(ministries, LEPLs, etc).</span></li><li className="c0"><span>Each Spending Agency can have </span><span className="c9">Programs</span><span className="c3">&nbsp;that they fund.</span></li><li className="c0"><span>A collection of these Spending Agencies and Programs are combined to form </span><span className="c9">Priorities</span><span className="c3">.</span></li></ul><h3 className="c5" id="h.k1usq3d1jqr2"><span>T</span><span className="c14">he Relationships Between the Components</span></h3><ul className="c12 lst-kix_d8g0k5a4cmsy-0 start"><li className="c0"><span className="c3">A Priority can have many Spending Agencies (and all of the Spending Agency’s Programs) and/or individual Programs within a Spending Agency.</span></li><li className="c0"><span className="c3">A Spending Agency belongs to one or more Priorities and can have zero or more Programs.</span></li><li className="c0"><span className="c3">A Program belongs to one Priority and one Spending Agency and can have zero or more subprograms.</span></li></ul><h3 className="c5" id="h.ov86btcauj8a"><span className="c14">Relationships Change</span></h3><p className="c1"><span>Every time the government releases a new budget, they have the possibility to change the</span><span>&nbsp;relationships between Priorities, Spending Agencies, and Programs. For instance, </span><span>they may assign Program A to Spending Agency A in 2012, and then move it to Spending Agency B in 2013. This means that a Program, when considered over its entire lifetime, can belong to multiple Spending Agencies and Priorities.</span><span>&nbsp;</span></p><h3 className="c5" id="h.fr4fs1hkrne8"><span className="c14">The Finances</span></h3><p className="c1"><span className="c3">The Georgian Budget is split into two main finance types: </span></p><ul className="c12 lst-kix_3afxef41plvs-0 start"><li className="c0"><span>Planned - how much </span><span>the government plans to spend</span></li><li className="c0"><span>Spent - how much </span><span>the government actually spent</span></li></ul><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>The</span><span>&nbsp;government plans the budget in quarterly and yearly increments. However, the quarterly plans are released three times, in each of the quarter’s three monthly budget spreadsheets, which means that the government can (and sometimes does) change the quarterly plan one or two times (in the second and third month’s spreadsheets). Similarly, the initial plan for a year is first released at the beginning of a year, but can be revised once the year is completed, in the following year’s budget.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>The </span><span>government publishes how much was spent every month. </span><span>Spent budget for a year is recorded on a monthly basis. The official finalized Spent budget is not available until a year after the year is completed (i.e., the final Spent budget for 2015 is released </span><span>at the beginning of</span><span>&nbsp;2017).</span></p><p className="c1 c6"><span className="c3"></span></p><h2 className="c8" id="h.3e7t0tu5f6lv"><span className="c18">Methodology</span></h2><p className="c1"><span>The Georgian Budget data available on this site is a combination of original data from the Ministry of Finance and </span><span>data computed from this original data</span><span className="c3">.</span></p><h3 className="c5" id="h.iz3d5yyj9j1e"><span className="c14">Data Sources</span></h3><p className="c1"><span className="c3">The data on the Georgian Budget site comes from 3 different sets of files.</span></p><h4 className="c17" id="h.dfhjwjdo3c25"><span className="c2">Monthly Spreadsheets</span></h4><p className="c1"><span>Through Freedom of Information (FOI) requests, we obtain spreadsheets with the Planned and Spent finances that occurred in a given month for </span><span>the total national budget, </span><span>all Spending Agencies</span><span>, and all</span><span>&nbsp;Programs. You can click here to </span><span className="c16"><a className="c13" href="https://github.com/JumpStartGeorgia/Georgian-Budget-Files/tree/master/files_from_government/monthly_spreadsheets">view all of the monthly spreadsheet files we have received from these FOI requests</a></span><span className="c3">.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">Please Note:</span></p><ul className="c12 lst-kix_mk43hej5vmeg-0 start"><li className="c0"><span>The Planned and Spent values are cumulative for the year</span><span>. To get each month’s non-cumulative Spent amount,</span><span>&nbsp;you have to subtract the </span><span>previous month’s cumulative </span><span>value</span><span>&nbsp;from that month’s cumulative value</span><span>.</span><span>&nbsp;To get each quarter’s non-cumulative Planned amount, you have to subtract the previous quarter’s cumulative value from that quarter’s cumulative value.</span></li><li className="c0"><span className="c3">Each Planned amount is for the quarter that the monthly spreadsheet belongs to. In other words, if the government planned to spend 100,000 lari on a program during each month in the first quarter of the year, then it would record 300,000 lari in the January spreadsheet for that program’s plan. </span></li></ul><h4 className="c17" id="h.s3v0db79318w"><span className="c2">Yearly Spreadsheets</span></h4><p className="c1"><span>Through Freedom of Information (FOI) requests, we obtain spreadsheets with the Planned and Spent finances that occurred in a given year for</span><span>&nbsp;the total national budget,</span><span>&nbsp;all Spending Agencies</span><span>, and all</span><span>&nbsp;Programs. You can click here to </span><span className="c16"><a className="c13" href="https://github.com/JumpStartGeorgia/Georgian-Budget-Files/tree/master/files_from_government/yearly_spreadsheets">view all of the yearly spreadsheet files we have received from these FOI requests</a></span><span className="c3">.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">Please Note:</span></p><ul className="c12 lst-kix_mk43hej5vmeg-0"><li className="c0"><span className="c3">The yearly spreadsheet contains data for three different years.</span></li></ul><ul className="c12 lst-kix_mk43hej5vmeg-1 start"><li className="c1 c7"><span className="c3">Two years ago - official finalized Spent finances </span></li><li className="c1 c7"><span className="c3">One year ago - official finalized Planned finances</span></li><li className="c1 c7"><span className="c3">Current year - proposed Planned finances</span></li><li className="c1 c7"><span className="c3">For example, the 2015 yearly spreadsheet has the following:</span></li></ul><ul className="c12 lst-kix_mk43hej5vmeg-2 start"><li className="c1 c10"><span className="c3">2013 official finalized Spent finances</span></li><li className="c1 c10"><span className="c3">2014 official finalized Planned finances</span></li><li className="c1 c10"><span className="c3">2015 proposed Planned finances</span></li></ul><ul className="c12 lst-kix_mk43hej5vmeg-0"><li className="c0"><span className="c3">Exceptions to the above rules:</span></li></ul><ul className="c12 lst-kix_mk43hej5vmeg-1 start"><li className="c1 c7"><span>The 2012 yearly spreadsheet contain</span><span>s neither</span><span>&nbsp;the 2011 final Planned finances </span><span>n</span><span className="c3">or the 2010 final Spent finances</span></li><li className="c1 c7"><span>The 2013 yearly spreadsheet contain</span><span>s neither</span><span>&nbsp;the 2012 final Planned finances </span><span>n</span><span className="c3">or the 2011 final Spent finances</span></li></ul><h4 className="c17" id="h.e788sf8loisp"><span className="c2">Priority PDFs</span></h4><p className="c1"><span className="c3">The Ministry of Finance posts PDF documents to their website that indicate which Spending Agencies and Programs belong to a Priority for a given year. </span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>You can click here to </span><span className="c16"><a className="c13" href="https://github.com/JumpStartGeorgia/Georgian-Budget-Files/tree/master/files_from_government/priority_pdfs">view all of the Priority PDFs</a></span><span>&nbsp;that we have downloaded from the Ministry of Finance website</span><span>. Or you can find them directly from the Ministry of Finance website by </span><span>following these instructions</span><span className="c3">:</span></p><ol className="c12 lst-kix_1nktlzyfnqih-0 start" start="1"><li className="c0"><span>Go to the </span><span className="c16"><a className="c13" href="http://mof.gov.ge/4562">Ministry of Finance Budget page</a></span></li><li className="c0"><span className="c3">In the bottom, select the year you want to view</span></li><li className="c0"><span className="c3">Again, in the bottom select the year you want to view</span></li><li className="c0"><span className="c3">Now you see a long list of links to documents</span></li><li className="c0"><span>Look for the link labeled ‘ბიუჯეტით განსაზღვრული პროგრამების მოსალოდნელი შედეგები და ინდიკატორები’ and click on it to get the PDF</span></li></ol><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">Please Note:</span></p><ul className="c12 lst-kix_r83f73h0xvb3-0 start"><li className="c0"><span>We use these documents to assign Spending Agencies and Programs to Priorities</span><span>, and to figure out how to calculate Priority finances from its Spending Agencies and Programs</span><span className="c3">&nbsp;so that we can calculate the Priority finances. </span></li><li className="c0"><span>We do not use any of the financial information recorded in </span><span>these documents</span><span>.</span><span className="c3">&nbsp;These documents only include yearly plans; they include neither quarterly plans nor any data about how much was spent. Therefore, we choose to calculate all of a Priority’s financial information by summing the financial data we have for its Spending Agencies and Programs from the yearly and monthly spreadsheets.</span></li><li className="c0"><span>Because </span><span>we calculate Priority yearly plans from the yearly and monthly spreadsheets</span><span>, it is possible that our numbers do not match the numbers in the PDF document for one of the following reasons:</span></li></ul><ul className="c12 lst-kix_r83f73h0xvb3-1 start"><li className="c1 c7"><span className="c3">We have found that a Program is included in the Priority PDF document but never appears in the monthly or yearly spreadsheets.</span></li><li className="c1 c7"><span className="c3">We have found that a Program is included in the Priority PDF document and the monthly spreadsheet, but never appears in the yearly spreadsheets.</span></li><li className="c1 c7"><span>We are trying to get answers from the Ministry of Finance on why this discrepancy is occurring.</span></li></ul><p className="c1 c6"><span className="c3"></span></p><h3 className="c5" id="h.l89fqj9u1a0p"><span className="c14">Using the Data</span></h3><p className="c1"><span>The following is a breakdown of which data we pull directly from the Ministry of Finance spreadsheets and PDF documents</span><span>,</span><span>&nbsp;and which </span><span>data we calculate</span><span className="c3">.</span></p><h4 className="c17" id="h.i8tosyu2r9y0"><span>Official</span><span className="c2">&nbsp;Data</span></h4><p className="c1"><span className="c3">From the monthly spreadsheets, we get the Planned and Spent amounts for the total national budget, Spending Agencies, and Programs.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">Please Note:</span></p><ul className="c12 lst-kix_gcwbozehe4p1-0 start"><li className="c0"><span className="c3">The monthly data is recorded as a cumulative value of all months in the year, so we have to subtract the previous month’s value to get the amount for a given month.</span></li></ul><ul className="c12 lst-kix_gcwbozehe4p1-1 start"><li className="c1 c7"><span className="c3">For example, March’s Spending value is 400,000 and April’s Spending value is 500,000, so the actual money spent in April is 100,000 (500,000-400,000).</span></li></ul><ul className="c12 lst-kix_gcwbozehe4p1-0"><li className="c0"><span>The monthly data for Planned is actually the amount planned for the quarter the month is in and not the month</span><span>&nbsp;itself</span><span>. Given this, the planned amount can change every month, so we do the following to get the </span><span>correct</span><span className="c3">&nbsp;value:</span></li></ul><ul className="c12 lst-kix_gcwbozehe4p1-1 start"><li className="c1 c7"><span className="c3">If we do not have all monthly spreadsheets for a quarter, we use the value from the last month in the quarter that we do have.</span></li><li className="c1 c7"><span className="c3">If we have all monthly spreadsheets for a quarter, we use the value from the last month in the quarter.</span></li></ul><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">From the yearly spreadsheets, we get the following data:</span></p><ul className="c12 lst-kix_kcua5tf962fg-0 start"><li className="c0"><span>Official</span><span>,</span><span>&nbsp;finalized Spent amounts for the total national budget, Spending Agencies, and Programs that </span><span>describe what was Spent two years before the spreadsheet was published</span><span className="c3">.</span></li><li className="c0"><span>Official</span><span>,</span><span>&nbsp;finalized Planned amounts for the total national budget, Spending Agencies, and Programs that occurred </span><span>one year before the spreadsheet was published</span><span className="c3">.</span></li><li className="c0"><span className="c3">The proposed Planned amounts for the total national budget, Spending Agencies, and Programs that are to occur in the current year.</span></li></ul><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">Please Note:</span></p><ul className="c12 lst-kix_tuczby54wam8-0 start"><li className="c0"><span>The Official finalized yearly Planned data </span><span>for any given year is released after the year is finished</span><span className="c3">, so if this data has not been released yet, we use the proposed Planned data from that year’s yearly spreadsheet. When the final data becomes available, this value will be updated with the correct finalized value.</span></li></ul><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">From the yearly Priority PDFs, we are able to assign Spending Agencies and Programs to each Priority.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">Please Note:</span></p><ul className="c12 lst-kix_ac4g7j37p0du-0 start"><li className="c0"><span className="c3">If a Spending Agency is assigned to a Priority and that Spending Agency has Programs, all of those Programs are also assigned to the Priority.</span></li><li className="c0"><span>If a Program is assigned to a Priority, its Agency, Programs it is a Subprogram of, and all of its Subprograms are &nbsp;also assigned to the Priority.</span></li></ul><h4 className="c17" id="h.1foezkgvhc50"><span className="c2">Computed Data</span></h4><ul className="c12 lst-kix_8izxqj7p1qav-0 start"><li className="c0"><span className="c3">The Spent data is not available in quarterly time frames, so we compute the quarterly amounts by summing up the Spent values for the three months in each quarter. For example, if we had the following Spent amounts: January - 100,000; February - 250,000; March - 150,000, then the total Spent for the quarter is 500,000.</span></li></ul><ul className="c12 lst-kix_8izxqj7p1qav-1 start"><li className="c1 c7"><span className="c3">If we do not have all the Spent values for all months in a quarter, the quarter amount is the sum of the months that we do have.</span></li></ul><ul className="c12 lst-kix_8izxqj7p1qav-0"><li className="c0"><span>The Official finalized yearly Spent data is not released until two years later, so if this data has not been released yet, we add up the monthly Spent data of the year to get the total for the year. </span><span>This value is updated with the official value when it becomes available. </span></li></ul><ul className="c12 lst-kix_ac4g7j37p0du-0"><li className="c0"><span>All </span><span>Priority financial data </span><span>&nbsp;are computed by </span><span>aggregating &nbsp;the data for the Spending Agencies and Programs listed below each Priority in the Priority PDFs. </span></li></ul><ul className="c12 lst-kix_ac4g7j37p0du-1 start"><li className="c1 c7"><span className="c3">As described in the above section, we assign Spending Agencies and Programs to a Priority that are related to the Spending Agencies and Programs listed below the Priority. However, these Spending Agencies and Programs are not used in calculating the Priority’s financial data; only those that are listed below the Priority are used in the calculations.</span></li><li className="c1 c7"><span className="c3">Note - The Spending Agencies and Programs assigned to a Priority can change every year so all computations are done using the assignments for the given year. </span></li></ul><h3 className="c5" id="h.cgu4fk7v7vmt"><span className="c14">Tracking Over Time</span></h3><p className="c1"><span>As mentioned previously, the Priorities, Spending Agencies, and Programs are in a constant state of flux, so tracking a particular budget item </span><span>can be a significant challenge</span><span>. Below is an explanation of how we attempt</span><span>ed</span><span className="c3">&nbsp;to accomplish this task.</span></p><h4 className="c17" id="h.svc6xo6jeyjm"><span className="c2">The Situation</span></h4><p className="c1"><span>The government assigns</span><span>&nbsp;each Spending Agency and Program</span><span>&nbsp;a code</span><span>, </span><span>such as “01 00” or “05 03 02”. However,</span><span>&nbsp;</span><span>the codes of a Spending Agency and Program can change at any time.</span><span className="c3">&nbsp;It is possible for a new Spending Agency or Program to be assigned a code of a previous Spending Agency or Program. If the previous Spending Agency or Program still exists, it has now been assigned a new code. This means that we cannot simply match the code from each spreadsheet and assume it is for the same Spending Agency or Program.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>On top of that, Spending Agency and Program names constantly change, even within a year.</span><span>&nbsp;so using the combination of code and name is also not a perfect way to match records from each spreadsheet.</span></p><h4 className="c17" id="h.ixyl2bog6e3m"><span>Our Solution</span></h4><p className="c1"><span>We programmatically attempt to match records from one time period to another by looking for records that have the same code and name.</span><span>&nbsp;</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>W</span><span>hen this approach does not find a match, we have to manually </span><span>determine </span><span>which record</span><span>s correspond to one another. This occurs, for example, when we identify two records that have the same code but different names. </span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span>Given this</span><span>&nbsp;process</span><span>, human error is possible</span><span>. We</span><span>&nbsp;</span><span>may</span><span>&nbsp;have matched Spending Agencies or Programs that are actually different</span><span>,</span><span>&nbsp;or we </span><span>may</span><span className="c3">&nbsp;have missed records that should have been matched.</span></p><p className="c1 c6"><span className="c3"></span></p><p className="c1"><span className="c3">When we do match records, we had to come up with a process of how to properly merge these records. Below is the explanation of what we do.</span></p><ul className="c12 lst-kix_gbx2dh3jrvtf-0 start"><li className="c0"><span className="c3">When the code changes, we use the most recent code.</span></li><li className="c0"><span className="c3">When the name changes, we use the most recent name.</span></li><li className="c0"><span className="c3">For a Priority, we show:</span></li></ul><ul className="c12 lst-kix_gbx2dh3jrvtf-1 start"><li className="c1 c7"><span className="c3">All related Spending Agencies that have at one time been associated with this Priority</span></li><li className="c1 c7"><span>All related</span><span>&nbsp;top-level</span><span>&nbsp;Programs</span><span>&nbsp;(not Subprograms)</span><span className="c3">&nbsp;that have at one time been associated with this Priority</span></li></ul><ul className="c12 lst-kix_gbx2dh3jrvtf-0"><li className="c0"><span className="c3">For a Spending Agency, we show:</span></li></ul><ul className="c12 lst-kix_gbx2dh3jrvtf-1 start"><li className="c1 c7"><span className="c3">All Priorities that have at one time been associated with this Spending Agency</span></li><li className="c1 c7"><span>All </span><span>top-level </span><span>Programs</span><span>&nbsp;(but not Subprograms of these programs) </span><span className="c3">associated with this Spending Agency</span></li></ul><ul className="c12 lst-kix_gbx2dh3jrvtf-0"><li className="c0"><span className="c3">For a Program, we show:</span></li></ul><ul className="c12 lst-kix_gbx2dh3jrvtf-1 start"><li className="c1 c7"><span className="c3">The most recent Spending Agency</span></li><li className="c1 c7"><span className="c3">The most recent parent Program, if one exists</span></li><li className="c1 c7"><span className="c3">All Priorities that have at one time been associated with this Program</span></li></ul><h3 className="c5" id="h.l2yjexj9480i"><span className="c14">Final Thoughts</span></h3><p className="c1"><span>Budgets are complicated</span><span>, and trying to make sense of the Georgian budget has presented many challenges.</span><span className="c3">&nbsp;Please get in touch with us if you find an error in the data or in the logic of our methodology, or if you wish to contribute to this project.</span></p><p className="c1 c6"><span className="c3"></span></p>
      </div>
    )
  },

  render () {
    return (
      <div>
        <Helmet
          title='About'
        />

        {this.renderContent()}
      </div>
    )
{'fraction_non_alphanumeric': 0.14680930269009973, 'fraction_numerical': 0.030368933560610514, 'mean_word_length': 6.5358039273586295, 'pattern_counts': {'":': 0, '<': 1753, '<?xml version=': 0, '>': 1753, 'https://': 14, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 4, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2476704', 'n_tokens_mistral': 15428, 'n_tokens_neox': 14666, 'n_words': 5157}