Kansas State Department of Education
search_arrow
 
Search




FaceBook Twitter Contact KSDE


Bug Report for the 2013-13 USD Budget

7/11/2013
Sumexpen.xlsx
A formula error was discovered on cell H1078.  Credit goes to Doug Maxwell at Goddard for discovering this formula error.  Please follow the steps below to update the formula:
  1. Unprotect Sheet:  Go to Review tab on Excel and click "unprotect sheet"
  2. Enter Password:  7287
  3. Update Formula in Excel cell H1078:
  1. Protect Sheet:  Go to Review tab on Excel and click "protect sheet"
  2. Enter Password:  7287 and reconfirm password
  3. Save
7/12/2013
Sumexpen.xlsx

An incorrect chart data range was discovered on the Reserve Funds-Unencumbered Cash Balance Graph.  This will only affect districts that use the Code 47-Special Reserve Fund.  In addition, an incorrect cell reference was discovered on a hidden worksheet within the Sumexpen.xlsx file, which is used to generae the Miscellaneous Information-Mill Rates by Fund Table on the Budget_Glance.xlsx (Excel rows 470 and 472).  This only affects districts that use th eCode 84-Recreation Commission Fund or Code 86-Recreation Commission Employee Benefits Fund.

As a result of the incorrect chart data range and incorrect cell reference discovered 7/12/2013 AND the formula error that was discovered on 7/11/2013, it is recommended all districts download the updated Sumexpen.xlsx file and replace your existing file.  Follow these steps:
  1. Click Here
  2. Locate the File Updates section
  3. Click on the Windows or Macintosh version of the Sumexpen.xlsx
  4. On the popup window, click "Save As".  This will prompt for the location to save to.  (Filename should be Sumexpen.xlsx)
  5. Replace existing file when prompted
7/18/2013
Sumexpen.xlsx

With all the changes made to the Sumexpen this year, there were bound to be a few errors.  To get the latest version, you can download the Sumexpen when your budget is done.  The latest version was posted on Thursday, July 18, 2013.  If we update it again and post a new version, the date will be published here.

8/9/2013
Sumexpen.xlsx
A formula error was discovered on Excel cells C1094, E1094, and H1094.  Credit goes to Jimmy Hay at Paola for discovering this formula error.  For any district reporting expenditures on Code 35-Gifts and Grants, Function 3300-Community Services Operations (budget line 795 or Excel row 237), you will need to download the latest version of th eSumexpen.xlsx file.  Districts identified as reporting 2011-12 actual expenditures (2012-13 USD Budget submission) were emailed an updated file on Monday, August 5, 2013.

The latest version was posted on the web Wednesday, August 9, 2013.  If we update it again and post a new version, the date will be published here.

If you have questions, please contact School Finance at 785-296-3872

School Finance Team Director
Craig Neuenswander
785-296-3872
craign@ksde.org

Questions about this page contact:
Sherry Root
785-296-3872
sroot@ksde.org

Copyright 2014 by Kansas State Department of Education | 900 SW Jackson St. | Topeka, KS 66612 Privacy Statement  |  Terms Of Use  |  System Maintenance Notices  |  Open Records
The Kansas State Department of Education does not discriminate on the basis of race, color, national origin, sex, disability, or age in its programs and activities. (more information...)