Indicators of the Kansas Economy: Assessment and Prototypes
View/ Open
Issue Date
2006-04-14Author
Hoyle, Larry
Oslund, Patricia
Wedel, Xan
Hurd, Genna M.
Hanson, Dane
Al-Baghal, Tarek
Publisher
Institute for Policy and Social Research, University of Kansas
Type
Technical Report
Is part of series
Technical Report;277
Published Version
https://ipsr.ku.eduMetadata
Show full item recordAbstract
The Policy Research Institute at the University of Kansas agreed to perform a comprehensive assessment of the September 2005 Indicators of the Kansas Economy (IKE) structure and data, to design prototypes of programs to download data, to include in the prototype one indicator at the county level, and to develop a prototype web site to display those data dynamically. The existing structure for IKE is a set of Microsoft Excel spreadsheets and Microsoft Word documents. Data are downloaded manually into the spreadsheets. Charts and data from the spreadsheets are then copied manually into the Word documents. The Word documents are then used to create an Adobe Acrobat (pdf) file. This arrangement works reasonably well for state level data. The procedure is somewhat vulnerable to errors such as the data being pasted into the wrong range in a spreadsheet and requires, as we understand it, a couple of days of labor each month. This process would not scale well to county level data though. There are over 600 counties in the seven states currently included in IKE. With monthly data, each variable in IKE involves over 100,000 data points when county level data are included.
Collections
- IPSR Published Works [305]
Citation
Larry Hoyle, Patricia Oslund, Xan Wedel, Genna M. Hurd, Dane Hanson, and Tarek Al-Baghal. Indicators of the Kansas Economy: Assessment and Prototypes. Institute for Policy and Social Research, University of Kansas. Technical Report Series: 277 (April 2006; 389 pages).
Items in KU ScholarWorks are protected by copyright, with all rights reserved, unless otherwise indicated.
We want to hear from you! Please share your stories about how Open Access to this item benefits YOU.