Sample_Report_Prelim-005.xls
XLS spreadsheet 7 KB Posted
- Attached to
- Tax Appraisal Ratio Study Software System
- Solicitation number
- EVT0009555
- Issued by
- Shawnee County, Topeka City, Kansas
About this file
This document contains information about a state and local contract opportunity for a Tax Appraisal Ratio Study Software System issued by the Kansas Department of Revenue's Property Valuation Division. The state is seeking a contractor to provide a software solution that can replicate and improve the existing VB6-based system and Excel macro-driven functionalities used to format and compile preliminary data for the property tax appraisal ratio study. The proposed contract is for one year with the option for four one-year renewals and targets the jurisdictions of Shawnee County and Topeka City. Experience in appraisal-related ratio study data and techniques is preferred.
The key details regarding pricing, funding, and other salient information were not provided in the document. The document indicates that a bid package is attached, which may contain additional information about the pricing terms, set-asides, incumbents, funding requirements and sources, and any other relevant details.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Cost_Sheet.pdf | ||
| Tax_Appraisal_Ratio_Study_Software_System.pdf | ||
| Amendment_1_-_Q_A_Bid_Extension.pdf | ||
| Sample_Report_Final-003.xlsx | XLSX spreadsheet | |
| Sample_Report_Prelim-006.pdf | ||
| Sample_Report_Mid-Year-001.pdf | ||
| Sample_Report_Final-001.pdf | ||
| RFP_Tax_Ratio_Study_System.pdf | ||
| Sample_Report_Prelim-002.xls | XLS spreadsheet | |
| Sample_Report_Prelim-004.xlsx | XLSX spreadsheet | |
| Sample_Report_Prelim-003.pdf | ||
| Sample_Report_Prelim-001.xlsx | XLSX spreadsheet | |
| PVD_Ratio_Study_Project_Requirements.xlsx | XLSX spreadsheet | |
| Sample_Report_Final-002.xlsx | XLSX spreadsheet | |
| Input_and_Output_Examples.pdf |
Show all 15
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
| County | Median | COD | PRD | Valid Sales | Trim Sales | ||||||
| 001 : ALLEN | 92.8 | 87.1 | 97.3 | 18.9 | 16. | 22.3 | 1.03 | 1. | 1.06 | 108 | 10 |
| 002 : ANDERSON | 83.4 | 77.7 | 90.7 | 20.7 | 17.2 | 26.3 | 1.05 | 1.02 | 1.09 | 71 | 6 |
| 003 : ATCHISON | 93.5 | 89.3 | 97.1 | 21. | 18.4 | 23.9 | 1.04 | 1.02 | 1.07 | 178 | 10 |
| 004 : BARBER | 93.7 | 86.7 | 101. | 15.3 | 12.1 | 20.5 | 1.04 | .99 | 1.11 | 36 | 2 |
| 005 : BARTON | 90.9 | 87.2 | 97.9 | 19.2 | 17.2 | 22. | 1.03 | 1.01 | 1.06 | 163 | 9 |
| 006 : BOURBON | 80.2 | 74.3 | 89.3 | 29.7 | 26.1 | 34.4 | 1.13 | 1.03 | 1.32 | 150 | 7 |
| 007 : BROWN | 96. | 88.5 | 101.9 | 23.6 | 19.7 | 28.8 | 1.04 | 1. | 1.09 | 104 | 4 |
| 008 : BUTLER | 93. | 91.5 | 94.3 | 10.7 | 9.7 | 11.9 | 1. | .99 | 1.01 | 313 | 25 |
| 009 : CHASE | 73.6 | 59.2 | 93. | 29.8 | 22.1 | 42.5 | 1.02 | .94 | 1.13 | 24 | 0 |
| 010 : CHAUTAUQUA | 91.6 | 68.8 | 106.7 | 27.4 | 19.3 | 44.7 | 1.2 | 1.07 | 1.38 | 25 | 1 |
| 011 : CHEROKEE | 84.7 | 81. | 90.6 | 24.1 | 21.6 | 27.1 | 1.03 | 1.01 | 1.06 | 216 | 15 |
| 012 : CHEYENNE | 96.5 | 84.1 | 100.2 | 17.2 | 13.5 | 21.3 | 1.04 | 1. | 1.09 | 56 | 5 |
| 013 : CLARK | 82.7 | 74. | 98.7 | 24.8 | 19.6 | 34.5 | 1.04 | .98 | 1.11 | 38 | 2 |
| 014 : CLAY | 92.8 | 88.4 | 96.4 | 14.1 | 11.9 | 16.7 | 1.03 | 1.01 | 1.06 | 97 | 5 |
| 015 : CLOUD | 88.1 | 83.3 | 92.5 | 15.6 | 13.7 | 18.1 | 1.04 | 1.01 | 1.06 | 140 | 14 |
| 016 : COFFEY | 83.6 | 79.7 | 87.4 | 14.9 | 12.6 | 17.9 | 1.04 | 1.02 | 1.08 | 107 | 14 |
| 017 : COMANCHE | 81.9 | 76.9 | 92.3 | 13.4 | 9.2 | 20. | .99 | .96 | 1.02 | 21 | 3 |
| 018 : COWLEY | 87.2 | 84.8 | 90.3 | 17.2 | 15.2 | 19.6 | 1.03 | 1.01 | 1.05 | 189 | 15 |
| 019 : CRAWFORD | 81.4 | 78.2 | 85.9 | 20.5 | 18.3 | 23.1 | 1.03 | 1. | 1.05 | 209 | 9 |
| 020 : DECATUR | 65.2 | 59.9 | 80.3 | 31.6 | 25.2 | 40.7 | 1.11 | 1.04 | 1.19 | 46 | 1 |
| 021 : DICKINSON | 90.9 | 88. | 93.1 | 16.3 | 14.6 | 18.3 | 1.02 | 1. | 1.03 | 236 | 19 |
| 022 : DONIPHAN | 81.4 | 74.7 | 90.1 | 24.5 | 19.7 | 31.5 | 1.09 | 1.03 | 1.17 | 55 | 3 |
| 023 : DOUGLAS | 93.2 | 91.4 | 94.2 | 9.2 | 8.3 | 10.3 | 1. | 1. | 1.01 | 256 | 19 |
| 024 : EDWARDS | 86.2 | 81. | 91.2 | 21. | 14.7 | 30. | 1.08 | 1.02 | 1.18 | 29 | 1 |
| 025 : ELK | 77.1 | 69.5 | 93. | 24.2 | 17.7 | 33.6 | 1.09 | 1.01 | 1.21 | 28 | 1 |
| 026 : ELLIS | 95.3 | 93.3 | 97.3 | 9.7 | 8.6 | 10.9 | 1.02 | 1.01 | 1.04 | 200 | 8 |
| 027 : ELLSWORTH | 97.3 | 92.6 | 99.5 | 13.1 | 11.1 | 15.8 | 1.05 | 1.03 | 1.08 | 92 | 5 |
| 028 : FINNEY | 92.5 | 89.9 | 94.9 | 10.5 | 9.5 | 11.8 | 1.01 | 1.01 | 1.02 | 186 | 5 |
| 029 : FORD | 76. | 73.5 | 79.5 | 18.9 | 16.9 | 21.4 | 1.05 | 1. | 1.14 | 185 | 11 |
| 030 : FRANKLIN | 96.8 | 93.5 | 99.5 | 16.9 | 15.3 | 18.8 | 1.04 | 1.03 | 1.06 | 356 | 38 |
| 031 : GEARY | 97.5 | 95.6 | 98.7 | 9.9 | 9.3 | 10.7 | 1.02 | 1.01 | 1.04 | 600 | 65 |
| 032 : GOVE | 92. | 73.1 | 104. | 24.7 | 16.9 | 38. | 1.04 | .97 | 1.12 | 24 | 1 |
| 033 : GRAHAM | 92.6 | 83.4 | 98.3 | 14.3 | 10.6 | 19.9 | 1.04 | 1.01 | 1.08 | 31 | 1 |
| 034 : GRANT | 93.3 | 88.7 | 97. | 9.1 | 7.5 | 11.3 | .99 | .98 | 1. | 69 | 3 |
| 035 : GRAY | 88.6 | 84.3 | 92. | 9.5 | 7.4 | 12.5 | 1. | .99 | 1.02 | 43 | 4 |
| 036 : GREELEY | 95.1 | 72.4 | 109.9 | 25.2 | 16.6 | 39.4 | 1.07 | .97 | 1.23 | 17 | 1 |
| 037 : GREENWOOD | 85.9 | 72.1 | 95.7 | 32.3 | 26.1 | 44.1 | 1.06 | .99 | 1.14 | 70 | 5 |
| 038 : HAMILTON | 67. | 59.7 | 76.1 | 20.4 | 13.2 | 33.9 | 1. | .94 | 1.05 | 16 | 2 |
| 039 : HARPER | 87.3 | 82.6 | 98.9 | 20.2 | 16.3 | 25.5 | 1.02 | .99 | 1.07 | 66 | 9 |
| 040 : HARVEY | 82.4 | 80.9 | 85.6 | 13.4 | 12. | 15.3 | 1.01 | .99 | 1.02 | 207 | 21 |
| 041 : HASKELL | 88.3 | 82.7 | 97. | 16.4 | 12.1 | 22.5 | .96 | .92 | 1. | 37 | 4 |
| 042 : HODGEMAN | 83.3 | 73.9 | 97.2 | 13.2 | 7. | 31.2 | 1.04 | .98 | 1.19 | 7 | 0 |
| 043 : JACKSON | 89.4 | 85.9 | 94.5 | 17.2 | 14.6 | 20.5 | 1.05 | 1.03 | 1.08 | 110 | 9 |
| 044 : JEFFERSON | 90.4 | 87. | 93.5 | 15. | 13.2 | 17. | 1.02 | 1.01 | 1.05 | 179 | 19 |
| 045 : JEWELL | 91.5 | 76.7 | 101.1 | 18.7 | 13.2 | 27.4 | 1.03 | .98 | 1.1 | 27 | 1 |
| 046 : JOHNSON | 93.7 | 92.5 | 94.8 | 9.1 | 8.3 | 9.8 | .99 | .95 | 1.02 | 418 | 24 |
| 047 : KEARNY | 87.7 | 81.2 | 90.2 | 16.2 | 11.4 | 23.1 | 1.01 | .97 | 1.07 | 32 | 2 |
| 048 : KINGMAN | 85.4 | 78.3 | 89.1 | 26.7 | 22.5 | 32.5 | 1.05 | 1.01 | 1.1 | 96 | 5 |
| 049 : KIOWA | 90.8 | 87.5 | 97. | 13.7 | 7.5 | 25.5 | .96 | .88 | 1.02 | 13 | 1 |
| 050 : LABETTE | 90.2 | 85.4 | 94.3 | 24.8 | 22. | 28.1 | 1.05 | 1.02 | 1.09 | 216 | 14 |
| 051 : LANE | 82.3 | 69.3 | 98.9 | 24.8 | 17.1 | 38.1 | 1.02 | .94 | 1.09 | 21 | 1 |
| 052 : LEAVENWORTH | 92.5 | 90.2 | 95. | 9.9 | 8.9 | 11.2 | 1. | .99 | 1.01 | 239 | 34 |
| 053 : LINCOLN | 94.2 | 79.5 | 99.8 | 17.4 | 12.6 | 24.9 | .98 | .94 | 1.03 | 38 | 0 |
| 054 : LINN | 86.6 | 82.1 | 92.8 | 25.9 | 22.3 | 30.6 | 1. | .96 | 1.04 | 129 | 4 |
| 055 : LOGAN | 94.7 | 89.6 | 97.1 | 14.2 | 10.6 | 18.5 | 1.03 | 1. | 1.06 | 46 | 4 |
| 056 : LYON | 87.8 | 85.8 | 90.7 | 13.7 | 12. | 15.6 | 1.02 | 1. | 1.05 | 189 | 15 |
| 057 : MARION | 86.1 | 82.2 | 90.5 | 19.3 | 16.8 | 22.1 | 1.02 | .99 | 1.06 | 137 | 10 |
| 058 : MARSHALL | 88.7 | 81. | 92.4 | 18.9 | 16.1 | 22.5 | 1.03 | 1. | 1.06 | 108 | 6 |
| 059 : MCPHERSON | 94.3 | 91.7 | 96. | 12.4 | 10.9 | 14.3 | 1. | .99 | 1.02 | 171 | 11 |
| 060 : MEADE | 85.7 | 80.7 | 95. | 18.7 | 14.8 | 24.2 | 1.02 | .99 | 1.06 | 46 | 3 |
| 061 : MIAMI | 90.2 | 88.9 | 91.7 | 9.2 | 7.9 | 10.6 | 1. | .99 | 1.01 | 176 | 23 |
| 062 : MITCHELL | 91.6 | 85.9 | 96. | 20.2 | 16.7 | 25.3 | 1.07 | 1.02 | 1.15 | 75 | 6 |
| 063 : MONTGOMERY | 87.8 | 83.6 | 91.5 | 21.9 | 19.5 | 24.8 | 1.05 | 1.02 | 1.08 | 192 | 11 |
| 064 : MORRIS | 84.5 | 76.2 | 97.6 | 23.9 | 19.2 | 30. | 1.03 | .97 | 1.1 | 53 | 2 |
| 065 : MORTON | 90.2 | 82.2 | 100.3 | 17.1 | 13.9 | 21.8 | 1.01 | .98 | 1.06 | 50 | 3 |
| 066 : NEMAHA | 91.9 | 86.2 | 97.3 | 16.5 | 14. | 19.9 | 1.03 | 1. | 1.06 | 109 | 11 |
| 067 : NEOSHO | 86.6 | 81.8 | 91.9 | 24.3 | 21.4 | 27.5 | 1.04 | 1.01 | 1.06 | 197 | 13 |
| 068 : NESS | 85.2 | 73.1 | 96.9 | 22.5 | 17.3 | 30.2 | 1.05 | .99 | 1.15 | 29 | 2 |
| 069 : NORTON | 87.4 | 82.1 | 94.8 | 17.2 | 13.5 | 23.2 | 1.09 | 1.04 | 1.2 | 38 | 2 |
| 070 : OSAGE | 89.3 | 85.8 | 93.8 | 19.5 | 17.3 | 22. | 1.03 | 1.02 | 1.05 | 224 | 25 |
| 071 : OSBORNE | 97.5 | 81.8 | 102. | 15.9 | 9.2 | 28.5 | 1.01 | .95 | 1.07 | 21 | 4 |
| 072 : OTTAWA | 94. | 83.2 | 99.5 | 18.4 | 14.3 | 23.4 | 1.05 | 1.01 | 1.09 | 50 | 2 |
| 073 : PAWNEE | 85.6 | 82. | 90.4 | 19.8 | 16.6 | 24. | 1.03 | 1. | 1.07 | 89 | 7 |
| 074 : PHILLIPS | 82. | 73.8 | 91.4 | 24.9 | 20.8 | 31.4 | 1.05 | 1. | 1.11 | 69 | 4 |
| 075 : POTTAWATOMIE | 93.4 | 91.5 | 96. | 10.8 | 9.5 | 12.3 | 1.01 | 1. | 1.02 | 183 | 11 |
| 076 : PRATT | 90.1 | 85.7 | 95. | 17.6 | 15.2 | 20.6 | 1.04 | 1.02 | 1.06 | 130 | 6 |
| 077 : RAWLINS | 84. | 73.2 | 96.7 | 16.9 | 13.1 | 24.9 | 1.04 | .99 | 1.11 | 23 | 3 |
| 078 : RENO | 87.7 | 86.2 | 90.2 | 14.1 | 12.6 | 15.9 | 1.03 | 1.01 | 1.05 | 231 | 22 |
| 079 : REPUBLIC | 90.2 | 73.8 | 96.4 | 19.6 | 15. | 25.5 | 1.02 | .97 | 1.09 | 47 | 1 |
| 080 : RICE | 89.2 | 85.4 | 94.3 | 27.1 | 23. | 32.2 | 1.01 | .97 | 1.05 | 108 | 2 |
| 081 : RILEY | 92. | 90.6 | 93.2 | 8.1 | 7.2 | 9.1 | 1.01 | 1. | 1.02 | 229 | 22 |
| 082 : ROOKS | 83.6 | 78.3 | 90.3 | 20. | 16.6 | 25. | 1.04 | 1. | 1.09 | 71 | 8 |
| 083 : RUSH | 74.6 | 64.1 | 84.3 | 20.5 | 14.8 | 28.9 | .97 | .91 | 1.04 | 30 | 2 |
| 084 : RUSSELL | 91.5 | 87.6 | 96.8 | 15.1 | 12.9 | 18.4 | 1.04 | 1.01 | 1.07 | 95 | 8 |
| 085 : SALINE | 91.1 | 89.8 | 93.2 | 10.7 | 9.5 | 12.1 | 1.01 | 1. | 1.02 | 225 | 19 |
| 086 : SCOTT | 86.4 | 80.3 | 92.9 | 16.4 | 13.8 | 19.9 | 1.05 | 1.02 | 1.09 | 84 | 8 |
| 087 : SEDGWICK | 87. | 85.5 | 88.8 | 12.2 | 11.2 | 13.3 | .99 | .98 | .99 | 400 | 30 |
| 088 : SEWARD | 85.2 | 82.9 | 87.9 | 12.1 | 10.6 | 13.9 | 1.02 | 1. | 1.03 | 169 | 17 |
| 089 : SHAWNEE | 90.1 | 88.5 | 92.4 | 12.4 | 11.4 | 13.6 | 1.02 | 1. | 1.05 | 312 | 15 |
| 090 : SHERIDAN | 84.8 | 67. | 90.8 | 19.8 | 12.8 | 33.6 | 1.07 | 1.04 | 1.14 | 13 | 1 |
| 091 : SHERMAN | 85.4 | 79.8 | 91.1 | 16.6 | 13.8 | 20.4 | 1.02 | .99 | 1.07 | 79 | 5 |
| 092 : SMITH | 83.8 | 77.2 | 96.5 | 26. | 21.1 | 33.9 | .98 | .93 | 1.04 | 55 | 2 |
| 093 : STAFFORD | 91.7 | 80.9 | 97.2 | 20. | 15.5 | 27.4 | 1.11 | 1.02 | 1.29 | 46 | 5 |
| 094 : STANTON | 84.9 | 59.3 | 99. | 27.1 | 17.2 | 43.8 | 1.09 | 1. | 1.26 | 14 | 0 |
| 095 : STEVENS | 84.1 | 78.5 | 90.1 | 15.3 | 10.8 | 21. | .99 | .95 | 1.02 | 35 | 3 |
| 096 : SUMNER | 83.9 | 80.6 | 88.6 | 25.5 | 23. | 28.6 | 1.02 | 1. | 1.05 | 288 | 15 |
| 097 : THOMAS | 91.1 | 84.7 | 95.1 | 15. | 12.9 | 17.9 | 1.02 | 1. | 1.05 | 105 | 7 |
| 098 : TREGO | 91.4 | 81.2 | 97.1 | 20. | 14.7 | 27.8 | 1.05 | .99 | 1.13 | 38 | 3 |
| 099 : WABAUNSEE | 86.5 | 81.2 | 91.2 | 18. | 14.5 | 22.3 | 1.02 | .99 | 1.05 | 62 | 3 |
| 100 : WALLACE | 77.5 | 59.4 | 98. | 32.2 | 22.7 | 52.4 | 1.13 | 1.04 | 1.31 | 19 | 0 |
| 101 : WASHINGTON | 90.6 | 76.3 | 99.4 | 21.5 | 16.5 | 30.8 | 1.05 | 1.01 | 1.1 | 30 | 1 |
| 102 : WICHITA | 84.9 | 69.7 | 92.3 | 17.3 | 10.9 | 31.3 | .95 | .89 | 1. | 19 | 2 |
| 103 : WILSON | 85.9 | 76.6 | 94.8 | 26.5 | 22.1 | 33. | 1.09 | 1.04 | 1.16 | 77 | 9 |
| 104 : WOODSON | 98.1 | 92.1 | 112.3 | 25.1 | 16.8 | 37.3 | 1.11 | 1.05 | 1.21 | 30 | 2 |
| 105 : WYANDOTTE | 79.6 | 76.7 | 83.3 | 20.9 | 18.8 | 23.3 | 1. | .98 | 1.01 | 286 | 16 |
Residential Subclass - Preliminary Ratio Study 2022
File details come from the government source that posted it. Updated .