Sample_Report_Final-003.xlsx

XLSX spreadsheet 26 KB Posted Feb 19, 2024

Attached to: Tax Appraisal Ratio Study Software System
Solicitation number: EVT0009555
Issued by: Shawnee County, Topeka City, Kansas

About this file

Written by GovTribe AI · Mar 25, 2024

This document contains information related to a state and local contract opportunity for a Property Tax Appraisal Ratio Study Software solution for the Property Valuation Division of the Kansas Department of Revenue. The state is seeking a contractor to provide a software program that can replicate and improve the existing VB6-based system and Excel macro-driven functionalities used to format and compile preliminary data for the ratio study. The proposed contract is for one (1) year with the option for four (4) one-year renewals. The jurisdictions involved are Shawnee County and Topeka City.

The contract opportunity requires experience in appraisal-related ratio study data and techniques. Pricing terms, set asides, incumbent information, funding requirements and sources, and other salient details were not provided in the given document.

View the file

Other files

File	Type	Posted
Cost_Sheet.pdf	PDF	Feb 19, 2024
Tax_Appraisal_Ratio_Study_Software_System.pdf	PDF	Feb 19, 2024
Sample_Report_Prelim-005.xls	XLS spreadsheet	Feb 19, 2024
Amendment_1_-_Q_A_Bid_Extension.pdf	PDF	Feb 19, 2024
Sample_Report_Prelim-006.pdf	PDF	Feb 19, 2024
Sample_Report_Mid-Year-001.pdf	PDF	Feb 19, 2024
Sample_Report_Final-001.pdf	PDF	Feb 19, 2024
RFP_Tax_Ratio_Study_System.pdf	PDF	Feb 19, 2024
Sample_Report_Prelim-002.xls	XLS spreadsheet	Feb 19, 2024
Sample_Report_Prelim-004.xlsx	XLSX spreadsheet	Feb 19, 2024
Sample_Report_Prelim-003.pdf	PDF	Feb 19, 2024
Sample_Report_Prelim-001.xlsx	XLSX spreadsheet	Feb 19, 2024
PVD_Ratio_Study_Project_Requirements.xlsx	XLSX spreadsheet	Feb 19, 2024
Sample_Report_Final-002.xlsx	XLSX spreadsheet	Feb 19, 2024
Input_and_Output_Examples.pdf	PDF	Feb 19, 2024

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Res2022FinalResults

	Total		Trim			Median				COD				PRD
County	Sales	Out	n	Median		Confidence Interval		COD		Confidence Interval		PRD		Confidence Interval
001 : ALLEN	108	10	98	92.8	87.1	to	97.3	18.9	16.0	to	22.3	1.03	1.00	to	1.06
002 : ANDERSON	71	6	65	83.4	77.7	to	90.7	20.7	17.2	to	26.1	1.05	1.02	to	1.09
003 : ATCHISON	178	10	168	93.5	89.3	to	97.1	21.0	18.4	to	23.9	1.04	1.02	to	1.07
004 : BARBER	36	2	34	93.6	86.7	to	101.1	15.3	12.1	to	20.4	1.04	0.99	to	1.10
005 : BARTON	163	9	154	90.9	87.5	to	97.9	19.2	17.2	to	22.0	1.03	1.01	to	1.06
006 : BOURBON	150	7	143	80.1	74.3	to	89.3	29.7	26.1	to	34.4	1.13	1.03	to	1.32
007 : BROWN	104	4	100	96.0	88.5	to	101.9	23.6	19.7	to	28.7	1.04	1.00	to	1.09
008 : BUTLER	313	25	288	93.0	91.5	to	94.3	10.7	9.7	to	11.9	1.00	0.99	to	1.01
009 : CHASE	23	0	23	79.8	61.2	to	93.0	27.2	19.2	to	40.0	1.02	0.93	to	1.13
010 : CHAUTAUQUA	25	1	24	91.6	68.8	to	106.7	27.4	19.2	to	44.7	1.20	1.07	to	1.38
011 : CHEROKEE	216	15	201	84.7	80.6	to	90.5	24.1	21.5	to	27.0	1.03	1.01	to	1.06
012 : CHEYENNE	56	5	51	96.5	84.1	to	100.0	17.2	13.5	to	21.4	1.04	1.00	to	1.09
013 : CLARK	38	2	36	82.7	74.0	to	98.8	24.8	19.6	to	34.7	1.04	0.98	to	1.11
014 : CLAY	97	5	92	92.8	88.4	to	96.4	14.1	11.9	to	16.7	1.03	1.01	to	1.06
015 : CLOUD	140	14	126	88.1	83.3	to	92.5	15.6	13.7	to	18.2	1.04	1.01	to	1.06
016 : COFFEY	107	14	93	83.6	79.7	to	87.4	14.9	12.7	to	17.9	1.04	1.02	to	1.08
017 : COMANCHE	21	3	18	81.9	76.9	to	92.3	13.4	9.2	to	20.0	0.99	0.96	to	1.02
018 : COWLEY	189	15	174	87.2	84.8	to	90.3	17.2	15.2	to	19.6	1.03	1.01	to	1.05
019 : CRAWFORD	209	9	200	81.4	78.2	to	85.9	20.5	18.4	to	23.1	1.03	1.00	to	1.05
020 : DECATUR	46	1	45	65.2	59.9	to	80.3	31.6	25.1	to	40.5	1.11	1.04	to	1.19
021 : DICKINSON	236	19	217	90.9	88.0	to	93.1	16.3	14.6	to	18.3	1.02	1.00	to	1.03
022 : DONIPHAN	55	3	52	81.4	74.7	to	90.1	24.5	19.6	to	31.3	1.09	1.03	to	1.17
023 : DOUGLAS	256	19	237	93.1	91.4	to	94.2	9.2	8.3	to	10.3	1.00	1.00	to	1.01
024 : EDWARDS	29	1	28	86.2	81.0	to	91.2	21.0	14.7	to	29.9	1.08	1.02	to	1.18
025 : ELK	28	1	27	77.1	69.5	to	93.0	24.2	17.7	to	33.5	1.09	1.01	to	1.21
026 : ELLIS	200	8	192	95.3	93.3	to	97.3	9.7	8.6	to	10.9	1.02	1.01	to	1.04
027 : ELLSWORTH	92	5	87	97.3	92.5	to	99.4	13.1	11.1	to	15.8	1.05	1.03	to	1.08
028 : FINNEY	186	5	181	92.5	89.9	to	94.9	10.5	9.5	to	11.8	1.01	1.01	to	1.02
029 : FORD	185	11	174	76.0	73.5	to	79.5	18.9	16.9	to	21.4	1.05	1.00	to	1.14
030 : FRANKLIN	356	38	318	96.8	93.5	to	99.5	16.9	15.3	to	18.8	1.04	1.03	to	1.06
031 : GEARY	600	65	535	97.5	95.6	to	98.7	9.9	9.3	to	10.7	1.02	1.01	to	1.04
032 : GOVE	24	1	23	92.0	73.1	to	104.0	24.7	16.8	to	37.9	1.04	0.97	to	1.12
033 : GRAHAM	31	1	30	92.6	83.4	to	98.3	14.3	10.6	to	19.9	1.04	1.01	to	1.08
034 : GRANT	69	3	66	93.3	88.7	to	97.0	9.1	7.5	to	11.3	0.99	0.98	to	1.00
035 : GRAY	42	3	39	89.2	84.8	to	92.2	9.5	7.4	to	12.5	1.00	0.99	to	1.02
036 : GREELEY	17	1	16	95.1	72.4	to	109.9	25.2	16.6	to	39.3	1.07	0.97	to	1.23
037 : GREENWOOD	64	4	60	88.1	77.2	to	96.9	27.5	21.2	to	35.8	1.08	1.02	to	1.16
038 : HAMILTON	16	2	14	67.0	56.9	to	76.1	20.4	13.2	to	34.1	1.00	0.94	to	1.05
039 : HARPER	66	9	57	87.3	82.6	to	99.2	20.2	16.4	to	25.5	1.02	0.99	to	1.07
040 : HARVEY	207	21	186	82.4	80.9	to	85.6	13.4	11.9	to	15.3	1.01	0.99	to	1.02
041 : HASKELL	37	4	33	88.3	82.7	to	97.0	16.4	12.2	to	22.6	0.96	0.92	to	1.00
042 : HODGEMAN	7	0	7	83.3	73.9	to	97.2	13.2	7.1	to	32.3	1.04	0.98	to	1.19
043 : JACKSON	110	9	101	89.4	86.1	to	94.5	17.2	14.7	to	20.5	1.05	1.03	to	1.08
044 : JEFFERSON	179	19	160	90.4	87.0	to	93.5	15.0	13.2	to	17.0	1.02	1.01	to	1.05
045 : JEWELL	27	1	26	91.5	76.7	to	101.1	18.7	13.3	to	27.5	1.03	0.98	to	1.10
046 : JOHNSON	418	24	394	93.7	92.5	to	94.8	9.1	8.4	to	9.9	0.99	0.95	to	1.02
047 : KEARNY	32	2	30	87.7	81.2	to	90.2	16.2	11.4	to	23.2	1.01	0.97	to	1.07
048 : KINGMAN	96	5	91	85.4	78.3	to	89.1	26.7	22.5	to	32.4	1.05	1.01	to	1.10
049 : KIOWA	13	1	12	90.8	87.5	to	97.0	13.7	7.6	to	25.3	0.96	0.88	to	1.02
050 : LABETTE	203	13	190	91.4	87.5	to	96.0	22.2	19.8	to	25.0	1.03	1.01	to	1.06
051 : LANE	21	1	20	82.3	69.3	to	98.9	24.8	17.2	to	37.8	1.02	0.94	to	1.09
052 : LEAVENWORTH	239	34	205	92.5	90.2	to	95.0	9.9	8.9	to	11.2	1.00	0.99	to	1.01
053 : LINCOLN	38	0	38	94.2	80.9	to	99.8	17.4	12.7	to	24.9	0.98	0.94	to	1.03
054 : LINN	123	6	117	88.3	83.6	to	94.1	23.2	19.8	to	27.5	0.99	0.95	to	1.03
055 : LOGAN	46	4	42	94.6	89.6	to	97.1	14.2	10.6	to	18.5	1.03	1.00	to	1.06
056 : LYON	189	15	174	87.8	85.8	to	90.7	13.7	12.0	to	15.6	1.02	1.00	to	1.05
057 : MARION	137	10	127	86.1	82.2	to	90.5	19.3	16.8	to	22.2	1.02	0.99	to	1.06
058 : MARSHALL	108	6	102	88.7	81.0	to	92.4	18.9	16.1	to	22.5	1.03	1.00	to	1.06
059 : MCPHERSON	171	11	160	94.3	91.7	to	96.0	12.4	10.9	to	14.3	1.00	0.99	to	1.02
060 : MEADE	46	3	43	85.7	80.7	to	95.0	18.7	14.8	to	24.1	1.02	0.99	to	1.06
061 : MIAMI	176	23	153	90.2	89.0	to	91.7	9.2	8.0	to	10.6	1.00	0.99	to	1.01
062 : MITCHELL	75	6	69	91.6	85.9	to	96.0	20.2	16.7	to	25.3	1.07	1.02	to	1.14
063 : MONTGOMERY	192	11	181	87.8	83.6	to	91.6	21.9	19.5	to	24.7	1.05	1.02	to	1.08
064 : MORRIS	53	2	51	84.5	76.2	to	97.6	23.9	19.2	to	29.9	1.03	0.97	to	1.10
065 : MORTON	50	3	47	90.2	82.2	to	100.3	17.1	13.9	to	21.8	1.01	0.98	to	1.06
066 : NEMAHA	109	11	98	91.9	86.2	to	97.3	16.5	14.0	to	19.8	1.03	1.00	to	1.06
067 : NEOSHO	197	13	184	86.6	81.5	to	91.9	24.3	21.4	to	27.5	1.04	1.01	to	1.06
068 : NESS	29	2	27	85.2	73.1	to	96.9	22.5	17.3	to	30.1	1.05	0.99	to	1.15
069 : NORTON	38	2	36	87.4	81.9	to	94.8	17.2	13.5	to	23.1	1.09	1.04	to	1.20
070 : OSAGE	224	25	199	89.3	85.8	to	93.7	19.5	17.2	to	22.1	1.03	1.02	to	1.05
071 : OSBORNE	21	4	17	97.5	81.8	to	102.0	15.9	9.2	to	28.6	1.01	0.95	to	1.07
072 : OTTAWA	50	2	48	94.0	83.2	to	99.5	18.4	14.4	to	23.5	1.05	1.01	to	1.10
073 : PAWNEE	89	7	82	85.6	82.0	to	90.4	19.8	16.5	to	23.9	1.03	1.00	to	1.07
074 : PHILLIPS	69	4	65	82.0	73.8	to	91.4	24.9	20.8	to	31.4	1.05	1.00	to	1.11
075 : POTTAWATOMIE	183	11	172	93.4	91.5	to	96.0	10.8	9.5	to	12.3	1.01	1.00	to	1.02
076 : PRATT	130	6	124	90.1	85.7	to	94.9	17.6	15.2	to	20.7	1.04	1.02	to	1.06
077 : RAWLINS	23	3	20	84.0	73.2	to	96.7	16.9	13.1	to	24.6	1.04	0.99	to	1.11
078 : RENO	231	22	209	87.7	86.2	to	90.2	14.1	12.5	to	15.9	1.03	1.01	to	1.05
079 : REPUBLIC	47	1	46	90.2	73.8	to	97.2	19.6	15.0	to	25.4	1.02	0.97	to	1.09
080 : RICE	108	2	106	89.1	85.4	to	94.3	27.1	22.9	to	32.2	1.01	0.97	to	1.05
081 : RILEY	229	22	207	92.0	90.6	to	93.2	8.1	7.2	to	9.1	1.01	1.00	to	1.02
082 : ROOKS	71	8	63	83.6	78.3	to	90.3	20.0	16.6	to	25.0	1.04	1.00	to	1.09
083 : RUSH	30	2	28	75.4	66.0	to	86.8	20.9	15.3	to	29.3	0.98	0.91	to	1.05
084 : RUSSELL	95	8	87	91.5	87.6	to	96.8	15.1	12.8	to	18.4	1.04	1.01	to	1.07
085 : SALINE	225	19	206	91.1	89.8	to	93.2	10.7	9.5	to	12.2	1.01	1.00	to	1.02
086 : SCOTT	84	8	76	86.4	80.3	to	92.9	16.4	13.8	to	19.9	1.05	1.02	to	1.09
087 : SEDGWICK	363	26	337	88.6	87.0	to	90.2	10.7	9.9	to	11.7	0.99	0.98	to	1.00
088 : SEWARD	169	17	152	85.2	82.9	to	88.0	12.1	10.6	to	13.9	1.02	1.00	to	1.03
089 : SHAWNEE	312	15	297	90.1	88.5	to	92.4	12.4	11.4	to	13.5	1.02	1.00	to	1.05
090 : SHERIDAN	13	1	12	84.8	67.0	to	90.8	19.8	12.9	to	33.9	1.07	1.04	to	1.14
091 : SHERMAN	79	5	74	85.4	79.8	to	91.1	16.6	13.8	to	20.3	1.02	0.99	to	1.07
092 : SMITH	55	2	53	83.8	77.2	to	96.5	26.0	21.1	to	34.1	0.98	0.93	to	1.04
093 : STAFFORD	46	5	41	91.7	80.9	to	97.2	20.0	15.4	to	27.3	1.11	1.02	to	1.29
094 : STANTON	14	0	14	84.9	59.3	to	99.0	27.1	17.2	to	43.7	1.09	1.00	to	1.26
095 : STEVENS	35	3	32	84.1	78.5	to	90.1	15.3	10.9	to	21.1	0.99	0.95	to	1.02
096 : SUMNER	288	15	273	83.9	80.4	to	88.6	25.5	23.0	to	28.6	1.02	1.00	to	1.05
097 : THOMAS	105	7	98	91.1	84.7	to	95.1	15.0	12.9	to	17.9	1.02	1.00	to	1.05
098 : TREGO	38	3	35	91.4	80.5	to	97.1	20.0	14.6	to	27.9	1.05	0.99	to	1.13
099 : WABAUNSEE	62	3	59	86.5	81.2	to	91.2	18.0	14.6	to	22.3	1.02	0.99	to	1.05
100 : WALLACE	19	0	19	77.5	59.4	to	98.0	32.2	22.7	to	52.3	1.13	1.04	to	1.31
101 : WASHINGTON	30	1	29	90.6	76.3	to	99.4	21.5	16.4	to	30.5	1.05	1.01	to	1.10
102 : WICHITA	19	2	17	84.9	69.7	to	92.3	17.3	10.9	to	31.2	0.95	0.89	to	1.00
103 : WILSON	71	8	63	87.1	77.0	to	96.5	23.9	19.8	to	30.6	1.10	1.05	to	1.16
104 : WOODSON	30	2	28	98.1	92.1	to	112.3	25.1	16.9	to	37.3	1.11	1.05	to	1.21
105 : WYANDOTTE	248	22	226	87.0	83.6	to	90.5	16.4	14.7	to	18.3	1.00	0.98	to	1.02
Residential Subclass Final Ratio Study: 2022

File details come from the government source that posted it. Updated Mar 25, 2024.