Get documents about "Vehicles
Document Sample
State College - Vehicles List
Author:
Date:
Purpose: Track data on cars, vans, and trucks
PURCHASE
ID # YEAR MAKE TYPE ODOMETER DEPARTMENT ASSIGNED PRICE
87 1991 FORD SEDAN 37780 Police & Security 20,888.00
195 1995 FORD TRUCK 19870 Telecomm 18,682.00
503 1999 CHEVROLET SEDAN 8900 Police & Security 20,904.00
678 1981 FORD PICKUP 73419 Housing & Residential Life 11,866.00
696 1996 DODGE VAN 43907 Police & Security 15,844.00
798 1999 FORD VAN 890 Housing & Residential Life 19,846.00
817 1990 CHEVROLET VAN 16896 Housing & Residential Life 20,824.00
818 1991 CHEVROLET PICKUP 37786 Housing & Residential Life 13,783.00
829 1981 FORD PICKUP 32765 Housing & Residential Life 5,000.00
834 1987 CHEVROLET VAN 138456 Property 11,449.00
841 1995 FORD SEDAN 59378 Printing Services 20,315.00
865 1989 GMC VAN 42313 Housing & Residential Life 12,500.00
866 1997 FORD SEDAN 49973 Police & Security 15,090.00
874 2000 FORD VAN 3744 Telecomm 21,580.00
877 1989 CHEVROLET PICKUP 50580 Property 14,130.00
888 1995 FORD SEDAN 62743 Police & Security 22,413.00
897 1995 FORD TRUCK 12703 Housing & Residential Life 22,724.00
904 1991 CHEVROLET SEDAN 53383 Police & Security 16,539.00
1016 1985 FORD PICKUP 52728 Housing & Residential Life 14,757.00
1055 1998 FORD VAN 3500 Dining Services 22,438.00
1071 1989 FORD VAN 93484 Printing Services 12,149.00
1140 1994 FORD TRUCK 29781 Property 19,634.00
1167 1986 FORD TRUCK 39292 Housing & Residential Life 15,366.00
1172 1997 FORD SEDAN 78740 Police & Security 15,871.00
1196 1984 CHEVROLET VAN 53560 Housing & Residential Life 12,493.00
1374 1991 CHEVROLET SEDAN 137534 Police & Security 20,453.00
1375 1985 FORD PICKUP 45608 Housing & Residential Life 15,866.00
1415 1993 GMC VAN 89006 Athletics 16,748.00
1445 1987 DODGE VAN 56788 Telecomm 10,105.00
1455 1988 FORD TRUCK 76681 Housing & Residential Life 12,850.00
1462 1993 GMC VAN 82091 Athletics 20,882.00
1476 1986 DODGE PICKUP 47222 Property 11,232.00
1575 1989 CHEVROLET PICKUP 43896 Property 12,643.00
1585 1995 FORD SEDAN 65404 Police & Security 22,674.00
1599 1985 CHEVROLET VAN 52672 Printing Services 15,773.00
1602 1992 GMC VAN 35860 Dining Services 16,356.00
1642 1981 CHEVROLET SEDAN 44108 Property 11,136.00
1643 1984 CHEVROLET TRUCK 43912 Housing & Residential Life 7,200.00
1648 1988 CHEVROLET VAN 101712 Housing & Residential Life 14,929.00
1649 2000 CHEVROLET PICKUP 2250 Printing Services 20,680.00
1675 1988 CHEVROLET PICKUP 54741 Property 9,839.00
1678 1989 FORD VAN 25126 Housing & Residential Life 12,957.00
1680 1991 CHEVROLET PICKUP 23915 Housing & Residential Life 16,763.00
1733 1990 FORD PICKUP 5272 Police & Security 15,914.00
1735 1989 CHEVROLET SEDAN 110863 Property 11,041.00
1776 1983 CHEVROLET SEDAN 81802 Housing & Residential Life 14,993.00
1861 1987 CHEVROLET VAN 8993 Police & Security 15,592.00
1878 1987 CHEVROLET VAN 56047 Housing & Residential Life 15,930.00
1949 1992 CHEVROLET VAN 34474 Dining Services 18,712.00
2020 1999 FORD VAN 3398 Housing & Residential Life 22,045.00
2021 1987 DODGE VAN 59800 Dining Services 14,965.00
2063 1997 FORD SEDAN 62611 Police & Security 18,872.00
2071 2000 FORD VAN 3476 Property 20,336.00
2084 1993 GMC VAN 89094 Athletics 14,187.00
2112 1982 FORD SEDAN 103123 Housing & Residential Life 12,007.00
2124 1986 FORD VAN 36838 Printing Services 11,518.00
2126 1986 FORD TRUCK 43670 Housing & Residential Life 9,471.00
2128 1987 FORD VAN 99880 Athletics 15,197.00
2131 1991 CHEVROLET PICKUP 31394 Housing & Residential Life 15,613.00
2132 1986 CHEVROLET PICKUP 77104 Housing & Residential Life 14,019.00
2139 1985 DODGE VAN 10650 Property 11,985.00
2141 1996 FORD VAN 5721 Housing & Residential Life 22,546.00
2142 2003 GMC TRUCK Telecomm 13,410.00
2153 1990 CHEVROLET VAN 32315 Telecomm 14,109.00
2166 1990 CHEVROLET VAN 43038 Housing & Residential Life 17,022.00
2167 1999 FORD TRUCK 2229 Dining Services 21,743.00
2353 1986 GMC PICKUP 58570 Dining Services 14,127.00
2364 1986 CHEVROLET SEDAN 92419 Athletics 11,630.00
2388 1987 DODGE VAN 33321 Housing & Residential Life 15,485.00
2412 1987 FORD VAN 35497 Housing & Residential Life 9,025.00
2489 1988 CHEVROLET VAN 26493 Property 14,347.00
MAINTENANCE
COST-ANNUAL
1,932.76
1,331.30
938.75
507.00
565.82
167.65
705.00
1,593.97
1,370.00
1,235.29
472.68
29.50
566.94
28.04
279.12
111.87
1,591.00
1,640.71
2,000.00
694.89
378.22
575.00
3,491.22
723.70
1,299.00
2,235.00
72.07
755.00
345.47
80.88
980.00
2,000.00
602.71
489.92
2,932.83
1,825.79
2,000.00
499.15
664.34
369.55
159.90
675.00
1,775.42
1,838.72
963.62
1,820.00
1,871.00
1,382.90
1,025.00
379.19
1,948.46
751.37
401.86
558.62
1,350.00
2,000.00
104.64
1,974.79
450.00
594.45
1,245.08
1,118.41
257.37
731.96
1,200.00
202.36
1,255.00
2,257.16
117.64
191.38
1,002.10
PURCHASE
ID # YEAR MAKE TYPE ODOMETER DEPARTMENT ASSIGNED PRICE
87 1991 FORD SEDAN 37780 Police & Security 20,888.00
195 1995 FORD TRUCK 19870 Telecomm 18,682.00
503 1999 CHEVROLET SEDAN 8900 Police & Security 20,904.00
678 1981 FORD PICKUP 73419 Housing & Residential Life 11,866.00
696 1996 DODGE VAN 43907 Police & Security 15,844.00
798 1999 FORD VAN 890 Housing & Residential Life 19,846.00
817 1990 CHEVROLET VAN 16896 Housing & Residential Life 20,824.00
818 1991 CHEVROLET PICKUP 37786 Housing & Residential Life 13,783.00
829 1981 FORD PICKUP 32765 Housing & Residential Life 5,000.00
834 1987 CHEVROLET VAN 138456 Property 11,449.00
841 1995 FORD SEDAN 59378 Printing Services 20,315.00
865 1989 GMC VAN 42313 Housing & Residential Life 12,500.00
866 1997 FORD SEDAN 49973 Police & Security 15,090.00
874 2000 FORD VAN 3744 Telecomm 21,580.00
877 1989 CHEVROLET PICKUP 50580 Property 14,130.00
888 1995 FORD SEDAN 62743 Police & Security 22,413.00
897 1995 FORD TRUCK 12703 Housing & Residential Life 22,724.00
904 1991 CHEVROLET SEDAN 53383 Police & Security 16,539.00
1016 1985 FORD PICKUP 52728 Housing & Residential Life 14,757.00
1055 1998 FORD VAN 3500 Dining Services 22,438.00
1071 1989 FORD VAN 93484 Printing Services 12,149.00
1140 1994 FORD TRUCK 29781 Property 19,634.00
1167 1986 FORD TRUCK 39292 Housing & Residential Life 15,366.00
1172 1997 FORD SEDAN 78740 Police & Security 15,871.00
1196 1984 CHEVROLET VAN 53560 Housing & Residential Life 12,493.00
1374 1991 CHEVROLET SEDAN 137534 Police & Security 20,453.00
1375 1985 FORD PICKUP 45608 Housing & Residential Life 15,866.00
1415 1993 GMC VAN 89006 Athletics 16,748.00
1445 1987 DODGE VAN 56788 Telecomm 10,105.00
1455 1988 FORD TRUCK 76681 Housing & Residential Life 12,850.00
1462 1993 GMC VAN 82091 Athletics 20,882.00
1476 1986 DODGE PICKUP 47222 Property 11,232.00
1575 1989 CHEVROLET PICKUP 43896 Property 12,643.00
1585 1995 FORD SEDAN 65404 Police & Security 22,674.00
1599 1985 CHEVROLET VAN 52672 Printing Services 15,773.00
1602 1992 GMC VAN 35860 Dining Services 16,356.00
1642 1981 CHEVROLET SEDAN 44108 Property 11,136.00
1643 1984 CHEVROLET TRUCK 43912 Housing & Residential Life 7,200.00
1648 1988 CHEVROLET VAN 101712 Housing & Residential Life 14,929.00
1649 2000 CHEVROLET PICKUP 2250 Printing Services 20,680.00
1675 1988 CHEVROLET PICKUP 54741 Property 9,839.00
1678 1989 FORD VAN 25126 Housing & Residential Life 12,957.00
1680 1991 CHEVROLET PICKUP 23915 Housing & Residential Life 16,763.00
1733 1990 FORD PICKUP 5272 Police & Security 15,914.00
1735 1989 CHEVROLET SEDAN 110863 Property 11,041.00
1776 1983 CHEVROLET SEDAN 81802 Housing & Residential Life 14,993.00
1861 1987 CHEVROLET VAN 8993 Police & Security 15,592.00
1878 1987 CHEVROLET VAN 56047 Housing & Residential Life 15,930.00
1949 1992 CHEVROLET VAN 34474 Dining Services 18,712.00
2020 1999 FORD VAN 3398 Housing & Residential Life 22,045.00
2021 1987 DODGE VAN 59800 Dining Services 14,965.00
2063 1997 FORD SEDAN 62611 Police & Security 18,872.00
2071 2000 FORD VAN 3476 Property 20,336.00
2084 1993 GMC VAN 89094 Athletics 14,187.00
2112 1982 FORD SEDAN 103123 Housing & Residential Life 12,007.00
2124 1986 FORD VAN 36838 Printing Services 11,518.00
2126 1986 FORD TRUCK 43670 Housing & Residential Life 9,471.00
2128 1987 FORD VAN 99880 Athletics 15,197.00
2131 1991 CHEVROLET PICKUP 31394 Housing & Residential Life 15,613.00
2132 1986 CHEVROLET PICKUP 77104 Housing & Residential Life 14,019.00
2139 1985 DODGE VAN 10650 Property 11,985.00
2141 1996 FORD VAN 5721 Housing & Residential Life 22,546.00
2142 2003 GMC TRUCK Telecomm 13,410.00
2153 1990 CHEVROLET VAN 32315 Telecomm 14,109.00
2166 1990 CHEVROLET VAN 43038 Housing & Residential Life 17,022.00
2167 1999 FORD TRUCK 2229 Dining Services 21,743.00
2353 1986 GMC PICKUP 58570 Dining Services 14,127.00
2364 1986 CHEVROLET SEDAN 92419 Athletics 11,630.00
2388 1987 DODGE VAN 33321 Housing & Residential Life 15,485.00
2412 1987 FORD VAN 35497 Housing & Residential Life 9,025.00
2489 1988 CHEVROLET VAN 26493 Property 14,347.00
MAINTENANCE
COST-ANNUAL
1,932.76
1,331.30
938.75
507.00
565.82
167.65
705.00
1,593.97 Sort this list first based
1,370.00 on "MAKE" and then
1,235.29 based on "DEPARTMEN"
472.68 and then "PRICE"
29.50
566.94
28.04
279.12
111.87
1,591.00
1,640.71
2,000.00
694.89
378.22
575.00
3,491.22
723.70
1,299.00
2,235.00
72.07
755.00
345.47
80.88
980.00
2,000.00
602.71
489.92
2,932.83
1,825.79
2,000.00
499.15
664.34
369.55
159.90
675.00
1,775.42
1,838.72
963.62
1,820.00
1,871.00
1,382.90
1,025.00
379.19
1,948.46
751.37
401.86
558.62
1,350.00
2,000.00
104.64
1,974.79
450.00
594.45
1,245.08
1,118.41
257.37
731.96
1,200.00
202.36
1,255.00
2,257.16
117.64
191.38
1,002.10
PURCHASE
ID # YEAR MAKE TYPE ODOMETER DEPARTMENT ASSIGNED PRICE
87 1991 FORD SEDAN 37780 Police & Security 20,888.00
195 1995 FORD TRUCK 19870 Telecomm 18,682.00
503 1999 CHEVROLET SEDAN 8900 Police & Security 20,904.00
678 1981 FORD PICKUP 73419 Housing & Residential Life 11,866.00
696 1996 DODGE VAN 43907 Police & Security 15,844.00
798 1999 FORD VAN 890 Housing & Residential Life 19,846.00
817 1990 CHEVROLET VAN 16896 Housing & Residential Life 20,824.00
818 1991 CHEVROLET PICKUP 37786 Housing & Residential Life 13,783.00
829 1981 FORD PICKUP 32765 Housing & Residential Life 5,000.00
834 1987 CHEVROLET VAN 138456 Property 11,449.00
841 1995 FORD SEDAN 59378 Printing Services 20,315.00
865 1989 GMC VAN 42313 Housing & Residential Life 12,500.00
866 1997 FORD SEDAN 49973 Police & Security 15,090.00
874 2000 FORD VAN 3744 Telecomm 21,580.00
877 1989 CHEVROLET PICKUP 50580 Property 14,130.00
888 1995 FORD SEDAN 62743 Police & Security 22,413.00
897 1995 FORD TRUCK 12703 Housing & Residential Life 22,724.00
904 1991 CHEVROLET SEDAN 53383 Police & Security 16,539.00
1016 1985 FORD PICKUP 52728 Housing & Residential Life 14,757.00
1055 1998 FORD VAN 3500 Dining Services 22,438.00
1071 1989 FORD VAN 93484 Printing Services 12,149.00
1140 1994 FORD TRUCK 29781 Property 19,634.00
1167 1986 FORD TRUCK 39292 Housing & Residential Life 15,366.00
1172 1997 FORD SEDAN 78740 Police & Security 15,871.00
1196 1984 CHEVROLET VAN 53560 Housing & Residential Life 12,493.00
1374 1991 CHEVROLET SEDAN 137534 Police & Security 20,453.00
1375 1985 FORD PICKUP 45608 Housing & Residential Life 15,866.00
1415 1993 GMC VAN 89006 Athletics 16,748.00
1445 1987 DODGE VAN 56788 Telecomm 10,105.00
1455 1988 FORD TRUCK 76681 Housing & Residential Life 12,850.00
1462 1993 GMC VAN 82091 Athletics 20,882.00
1476 1986 DODGE PICKUP 47222 Property 11,232.00
1575 1989 CHEVROLET PICKUP 43896 Property 12,643.00
1585 1995 FORD SEDAN 65404 Police & Security 22,674.00
1599 1985 CHEVROLET VAN 52672 Printing Services 15,773.00
1602 1992 GMC VAN 35860 Dining Services 16,356.00
1642 1981 CHEVROLET SEDAN 44108 Property 11,136.00
1643 1984 CHEVROLET TRUCK 43912 Housing & Residential Life 7,200.00
1648 1988 CHEVROLET VAN 101712 Housing & Residential Life 14,929.00
1649 2000 CHEVROLET PICKUP 2250 Printing Services 20,680.00
1675 1988 CHEVROLET PICKUP 54741 Property 9,839.00
1678 1989 FORD VAN 25126 Housing & Residential Life 12,957.00
1680 1991 CHEVROLET PICKUP 23915 Housing & Residential Life 16,763.00
1733 1990 FORD PICKUP 5272 Police & Security 15,914.00
1735 1989 CHEVROLET SEDAN 110863 Property 11,041.00
1776 1983 CHEVROLET SEDAN 81802 Housing & Residential Life 14,993.00
1861 1987 CHEVROLET VAN 8993 Police & Security 15,592.00
1878 1987 CHEVROLET VAN 56047 Housing & Residential Life 15,930.00
1949 1992 CHEVROLET VAN 34474 Dining Services 18,712.00
2020 1999 FORD VAN 3398 Housing & Residential Life 22,045.00
2021 1987 DODGE VAN 59800 Dining Services 14,965.00
2063 1997 FORD SEDAN 62611 Police & Security 18,872.00
2071 2000 FORD VAN 3476 Property 20,336.00
2084 1993 GMC VAN 89094 Athletics 14,187.00
2112 1982 FORD SEDAN 103123 Housing & Residential Life 12,007.00
2124 1986 FORD VAN 36838 Printing Services 11,518.00
2126 1986 FORD TRUCK 43670 Housing & Residential Life 9,471.00
2128 1987 FORD VAN 99880 Athletics 15,197.00
2131 1991 CHEVROLET PICKUP 31394 Housing & Residential Life 15,613.00
2132 1986 CHEVROLET PICKUP 77104 Housing & Residential Life 14,019.00
2139 1985 DODGE VAN 10650 Property 11,985.00
2141 1996 FORD VAN 5721 Housing & Residential Life 22,546.00
2142 2003 GMC TRUCK Telecomm 13,410.00
2153 1990 CHEVROLET VAN 32315 Telecomm 14,109.00
2166 1990 CHEVROLET VAN 43038 Housing & Residential Life 17,022.00
2167 1999 FORD TRUCK 2229 Dining Services 21,743.00
2353 1986 GMC PICKUP 58570 Dining Services 14,127.00
2364 1986 CHEVROLET SEDAN 92419 Athletics 11,630.00
2388 1987 DODGE VAN 33321 Housing & Residential Life 15,485.00
2412 1987 FORD VAN 35497 Housing & Residential Life 9,025.00
2489 1988 CHEVROLET VAN 26493 Property 14,347.00
MAINTENANCE
COST-ANNUAL
1,932.76
1,331.30
938.75
507.00
565.82
167.65
705.00
1,593.97 Use AutoFilter to find a 1981
1,370.00
1,235.29 Ford whose price is greater
472.68 than $6000
29.50
566.94
28.04
279.12
111.87
1,591.00
1,640.71
2,000.00
694.89
378.22
575.00
3,491.22
723.70
1,299.00
2,235.00
72.07
755.00
345.47
80.88
980.00
2,000.00
602.71
489.92
2,932.83
1,825.79
2,000.00
499.15
664.34
369.55
159.90
675.00
1,775.42
1,838.72
963.62
1,820.00
1,871.00
1,382.90
1,025.00
379.19
1,948.46
751.37
401.86
558.62
1,350.00
2,000.00
104.64
1,974.79
450.00
594.45
1,245.08
1,118.41
257.37
731.96
1,200.00
202.36
1,255.00
2,257.16
117.64
191.38
1,002.10
PURCHASE
ID # YEAR MAKE TYPE ODOMETER DEPARTMENT ASSIGNED PRICE
87 1991 FORD SEDAN 37780 Police & Security 20,888.00
195 1995 FORD TRUCK 19870 Telecomm 18,682.00
503 1999 CHEVROLET SEDAN 8900 Police & Security 20,904.00
678 1981 FORD PICKUP 73419 Housing & Residential Life 11,866.00
696 1996 DODGE VAN 43907 Police & Security 15,844.00
798 1999 FORD VAN 890 Housing & Residential Life 19,846.00
817 1990 CHEVROLET VAN 16896 Housing & Residential Life 20,824.00
818 1991 CHEVROLET PICKUP 37786 Housing & Residential Life 13,783.00
829 1981 FORD PICKUP 32765 Housing & Residential Life 5,000.00
834 1987 CHEVROLET VAN 138456 Property 11,449.00
841 1995 FORD SEDAN 59378 Printing Services 20,315.00
865 1989 GMC VAN 42313 Housing & Residential Life 12,500.00
866 1997 FORD SEDAN 49973 Police & Security 15,090.00
874 2000 FORD VAN 3744 Telecomm 21,580.00
877 1989 CHEVROLET PICKUP 50580 Property 14,130.00
888 1995 FORD SEDAN 62743 Police & Security 22,413.00
897 1995 FORD TRUCK 12703 Housing & Residential Life 22,724.00
904 1991 CHEVROLET SEDAN 53383 Police & Security 16,539.00
1016 1985 FORD PICKUP 52728 Housing & Residential Life 14,757.00
1055 1998 FORD VAN 3500 Dining Services 22,438.00
1071 1989 FORD VAN 93484 Printing Services 12,149.00
1140 1994 FORD TRUCK 29781 Property 19,634.00
1167 1986 FORD TRUCK 39292 Housing & Residential Life 15,366.00
1172 1997 FORD SEDAN 78740 Police & Security 15,871.00
1196 1984 CHEVROLET VAN 53560 Housing & Residential Life 12,493.00
1374 1991 CHEVROLET SEDAN 137534 Police & Security 20,453.00
1375 1985 FORD PICKUP 45608 Housing & Residential Life 15,866.00
1415 1993 GMC VAN 89006 Athletics 16,748.00
1445 1987 DODGE VAN 56788 Telecomm 10,105.00
1455 1988 FORD TRUCK 76681 Housing & Residential Life 12,850.00
1462 1993 GMC VAN 82091 Athletics 20,882.00
1476 1986 DODGE PICKUP 47222 Property 11,232.00
1575 1989 CHEVROLET PICKUP 43896 Property 12,643.00
1585 1995 FORD SEDAN 65404 Police & Security 22,674.00
1599 1985 CHEVROLET VAN 52672 Printing Services 15,773.00
1602 1992 GMC VAN 35860 Dining Services 16,356.00
1642 1981 CHEVROLET SEDAN 44108 Property 11,136.00
1643 1984 CHEVROLET TRUCK 43912 Housing & Residential Life 7,200.00
1648 1988 CHEVROLET VAN 101712 Housing & Residential Life 14,929.00
1649 2000 CHEVROLET PICKUP 2250 Printing Services 20,680.00
1675 1988 CHEVROLET PICKUP 54741 Property 9,839.00
1678 1989 FORD VAN 25126 Housing & Residential Life 12,957.00
1680 1991 CHEVROLET PICKUP 23915 Housing & Residential Life 16,763.00
1733 1990 FORD PICKUP 5272 Police & Security 15,914.00
1735 1989 CHEVROLET SEDAN 110863 Property 11,041.00
1776 1983 CHEVROLET SEDAN 81802 Housing & Residential Life 14,993.00
1861 1987 CHEVROLET VAN 8993 Police & Security 15,592.00
1878 1987 CHEVROLET VAN 56047 Housing & Residential Life 15,930.00
1949 1992 CHEVROLET VAN 34474 Dining Services 18,712.00
2020 1999 FORD VAN 3398 Housing & Residential Life 22,045.00
2021 1987 DODGE VAN 59800 Dining Services 14,965.00
2063 1997 FORD SEDAN 62611 Police & Security 18,872.00
2071 2000 FORD VAN 3476 Property 20,336.00
2084 1993 GMC VAN 89094 Athletics 14,187.00
2112 1982 FORD SEDAN 103123 Housing & Residential Life 12,007.00
2124 1986 FORD VAN 36838 Printing Services 11,518.00
2126 1986 FORD TRUCK 43670 Housing & Residential Life 9,471.00
2128 1987 FORD VAN 99880 Athletics 15,197.00
2131 1991 CHEVROLET PICKUP 31394 Housing & Residential Life 15,613.00
2132 1986 CHEVROLET PICKUP 77104 Housing & Residential Life 14,019.00
2139 1985 DODGE VAN 10650 Property 11,985.00
2141 1996 FORD VAN 5721 Housing & Residential Life 22,546.00
2142 2003 GMC TRUCK Telecomm 13,410.00
2153 1990 CHEVROLET VAN 32315 Telecomm 14,109.00
2166 1990 CHEVROLET VAN 43038 Housing & Residential Life 17,022.00
2167 1999 FORD TRUCK 2229 Dining Services 21,743.00
2353 1986 GMC PICKUP 58570 Dining Services 14,127.00
2364 1986 CHEVROLET SEDAN 92419 Athletics 11,630.00
2388 1987 DODGE VAN 33321 Housing & Residential Life 15,485.00
2412 1987 FORD VAN 35497 Housing & Residential Life 9,025.00
2489 1988 CHEVROLET VAN 26493 Property 14,347.00
MAINTENANCE
COST-ANNUAL
1,932.76
1,331.30
938.75
507.00
565.82
167.65
705.00
1,593.97 Use conditional formating to
1,370.00
1,235.29 highlight all the prices
472.68 between $10000 and $15000
29.50
566.94
28.04
279.12
111.87
1,591.00
1,640.71
2,000.00
694.89
378.22
575.00
3,491.22
723.70
1,299.00
2,235.00
72.07
755.00
345.47
80.88
980.00
2,000.00
602.71
489.92
2,932.83
1,825.79
2,000.00
499.15
664.34
369.55
159.90
675.00
1,775.42
1,838.72
963.62
1,820.00
1,871.00
1,382.90
1,025.00
379.19
1,948.46
751.37
401.86
558.62
1,350.00
2,000.00
104.64
1,974.79
450.00
594.45
1,245.08
1,118.41
257.37
731.96
1,200.00
202.36
1,255.00
2,257.16
117.64
191.38
1,002.10
PURCHASE
ID # YEAR MAKE TYPE ODOMETER DEPARTMENT ASSIGNED PRICE
87 1991 FORD SEDAN 37780 Police & Security 20,888.00
195 1995 FORD TRUCK 19870 Telecomm 18,682.00
503 1999 CHEVROLET SEDAN 8900 Police & Security 20,904.00
678 1981 FORD PICKUP 73419 Housing & Residential Life 11,866.00
696 1996 DODGE VAN 43907 Police & Security 15,844.00
798 1999 FORD VAN 890 Housing & Residential Life 19,846.00
817 1990 CHEVROLET VAN 16896 Housing & Residential Life 20,824.00
818 1991 CHEVROLET PICKUP 37786 Housing & Residential Life 13,783.00
829 1981 FORD PICKUP 32765 Housing & Residential Life 5,000.00
834 1987 CHEVROLET VAN 138456 Property 11,449.00
841 1995 FORD SEDAN 59378 Printing Services 20,315.00
865 1989 GMC VAN 42313 Housing & Residential Life 12,500.00
866 1997 FORD SEDAN 49973 Police & Security 15,090.00
874 2000 FORD VAN 3744 Telecomm 21,580.00
877 1989 CHEVROLET PICKUP 50580 Property 14,130.00
888 1995 FORD SEDAN 62743 Police & Security 22,413.00
897 1995 FORD TRUCK 12703 Housing & Residential Life 22,724.00
904 1991 CHEVROLET SEDAN 53383 Police & Security 16,539.00
1016 1985 FORD PICKUP 52728 Housing & Residential Life 14,757.00
1055 1998 FORD VAN 3500 Dining Services 22,438.00
1071 1989 FORD VAN 93484 Printing Services 12,149.00
1140 1994 FORD TRUCK 29781 Property 19,634.00
1167 1986 FORD TRUCK 39292 Housing & Residential Life 15,366.00
1172 1997 FORD SEDAN 78740 Police & Security 15,871.00
1196 1984 CHEVROLET VAN 53560 Housing & Residential Life 12,493.00
1374 1991 CHEVROLET SEDAN 137534 Police & Security 20,453.00
1375 1985 FORD PICKUP 45608 Housing & Residential Life 15,866.00
1415 1993 GMC VAN 89006 Athletics 16,748.00
1445 1987 DODGE VAN 56788 Telecomm 10,105.00
1455 1988 FORD TRUCK 76681 Housing & Residential Life 12,850.00
1462 1993 GMC VAN 82091 Athletics 20,882.00
1476 1986 DODGE PICKUP 47222 Property 11,232.00
1575 1989 CHEVROLET PICKUP 43896 Property 12,643.00
1585 1995 FORD SEDAN 65404 Police & Security 22,674.00
1599 1985 CHEVROLET VAN 52672 Printing Services 15,773.00
1602 1992 GMC VAN 35860 Dining Services 16,356.00
1642 1981 CHEVROLET SEDAN 44108 Property 11,136.00
1643 1984 CHEVROLET TRUCK 43912 Housing & Residential Life 7,200.00
1648 1988 CHEVROLET VAN 101712 Housing & Residential Life 14,929.00
1649 2000 CHEVROLET PICKUP 2250 Printing Services 20,680.00
1675 1988 CHEVROLET PICKUP 54741 Property 9,839.00
1678 1989 FORD VAN 25126 Housing & Residential Life 12,957.00
1680 1991 CHEVROLET PICKUP 23915 Housing & Residential Life 16,763.00
1733 1990 FORD PICKUP 5272 Police & Security 15,914.00
1735 1989 CHEVROLET SEDAN 110863 Property 11,041.00
1776 1983 CHEVROLET SEDAN 81802 Housing & Residential Life 14,993.00
1861 1987 CHEVROLET VAN 8993 Police & Security 15,592.00
1878 1987 CHEVROLET VAN 56047 Housing & Residential Life 15,930.00
1949 1992 CHEVROLET VAN 34474 Dining Services 18,712.00
2020 1999 FORD VAN 3398 Housing & Residential Life 22,045.00
2021 1987 DODGE VAN 59800 Dining Services 14,965.00
2063 1997 FORD SEDAN 62611 Police & Security 18,872.00
2071 2000 FORD VAN 3476 Property 20,336.00
2084 1993 GMC VAN 89094 Athletics 14,187.00
2112 1982 FORD SEDAN 103123 Housing & Residential Life 12,007.00
2124 1986 FORD VAN 36838 Printing Services 11,518.00
2126 1986 FORD TRUCK 43670 Housing & Residential Life 9,471.00
2128 1987 FORD VAN 99880 Athletics 15,197.00
2131 1991 CHEVROLET PICKUP 31394 Housing & Residential Life 15,613.00
2132 1986 CHEVROLET PICKUP 77104 Housing & Residential Life 14,019.00
2139 1985 DODGE VAN 10650 Property 11,985.00
2141 1996 FORD VAN 5721 Housing & Residential Life 22,546.00
2142 2003 GMC TRUCK Telecomm 13,410.00
2153 1990 CHEVROLET VAN 32315 Telecomm 14,109.00
2166 1990 CHEVROLET VAN 43038 Housing & Residential Life 17,022.00
2167 1999 FORD TRUCK 2229 Dining Services 21,743.00
2353 1986 GMC PICKUP 58570 Dining Services 14,127.00
2364 1986 CHEVROLET SEDAN 92419 Athletics 11,630.00
2388 1987 DODGE VAN 33321 Housing & Residential Life 15,485.00
2412 1987 FORD VAN 35497 Housing & Residential Life 9,025.00
2489 1988 CHEVROLET VAN 26493 Property 14,347.00
MAINTENANCE
COST-ANNUAL
1,932.76
1,331.30
938.75
507.00
565.82
167.65
705.00
1,593.97
Using Subtotals, create a price sum
1,370.00
1,235.29 after each department change
472.68
29.50
566.94
28.04
279.12
111.87
1,591.00
1,640.71
2,000.00
694.89
378.22
575.00
3,491.22
723.70
1,299.00
2,235.00
72.07
755.00
345.47
80.88
980.00
2,000.00
602.71
489.92
2,932.83
1,825.79
2,000.00
499.15
664.34
369.55
159.90
675.00
1,775.42
1,838.72
963.62
1,820.00
1,871.00
1,382.90
1,025.00
379.19
1,948.46
751.37
401.86
558.62
1,350.00
2,000.00
104.64
1,974.79
450.00
594.45
1,245.08
1,118.41
257.37
731.96
1,200.00
202.36
1,255.00
2,257.16
117.64
191.38
1,002.10
PURCHASE
ID # YEAR MAKE TYPE ODOMETER DEPARTMENT ASSIGNED PRICE
87 1991 FORD SEDAN 37780 Police & Security 20,888.00
195 1995 FORD TRUCK 19870 Telecomm 18,682.00
503 1999 CHEVROLET SEDAN 8900 Police & Security 20,904.00
678 1981 FORD PICKUP 73419 Housing & Residential Life 11,866.00
696 1996 DODGE VAN 43907 Police & Security 15,844.00
798 1999 FORD VAN 890 Housing & Residential Life 19,846.00
817 1990 CHEVROLET VAN 16896 Housing & Residential Life 20,824.00
818 1991 CHEVROLET PICKUP 37786 Housing & Residential Life 13,783.00
829 1981 FORD PICKUP 32765 Housing & Residential Life 5,000.00
834 1987 CHEVROLET VAN 138456 Property 11,449.00
841 1995 FORD SEDAN 59378 Printing Services 20,315.00
865 1989 GMC VAN 42313 Housing & Residential Life 12,500.00
866 1997 FORD SEDAN 49973 Police & Security 15,090.00
874 2000 FORD VAN 3744 Telecomm 21,580.00
877 1989 CHEVROLET PICKUP 50580 Property 14,130.00
888 1995 FORD SEDAN 62743 Police & Security 22,413.00
897 1995 FORD TRUCK 12703 Housing & Residential Life 22,724.00
904 1991 CHEVROLET SEDAN 53383 Police & Security 16,539.00
1016 1985 FORD PICKUP 52728 Housing & Residential Life 14,757.00
1055 1998 FORD VAN 3500 Dining Services 22,438.00
1071 1989 FORD VAN 93484 Printing Services 12,149.00
1140 1994 FORD TRUCK 29781 Property 19,634.00
1167 1986 FORD TRUCK 39292 Housing & Residential Life 15,366.00
1172 1997 FORD SEDAN 78740 Police & Security 15,871.00
1196 1984 CHEVROLET VAN 53560 Housing & Residential Life 12,493.00
1374 1991 CHEVROLET SEDAN 137534 Police & Security 20,453.00
1375 1985 FORD PICKUP 45608 Housing & Residential Life 15,866.00
1415 1993 GMC VAN 89006 Athletics 16,748.00
1445 1987 DODGE VAN 56788 Telecomm 10,105.00
1455 1988 FORD TRUCK 76681 Housing & Residential Life 12,850.00
1462 1993 GMC VAN 82091 Athletics 20,882.00
1476 1986 DODGE PICKUP 47222 Property 11,232.00
1575 1989 CHEVROLET PICKUP 43896 Property 12,643.00
1585 1995 FORD SEDAN 65404 Police & Security 22,674.00
1599 1985 CHEVROLET VAN 52672 Printing Services 15,773.00
1602 1992 GMC VAN 35860 Dining Services 16,356.00
1642 1981 CHEVROLET SEDAN 44108 Property 11,136.00
1643 1984 CHEVROLET TRUCK 43912 Housing & Residential Life 7,200.00
1648 1988 CHEVROLET VAN 101712 Housing & Residential Life 14,929.00
1649 2000 CHEVROLET PICKUP 2250 Printing Services 20,680.00
1675 1988 CHEVROLET PICKUP 54741 Property 9,839.00
1678 1989 FORD VAN 25126 Housing & Residential Life 12,957.00
1680 1991 CHEVROLET PICKUP 23915 Housing & Residential Life 16,763.00
1733 1990 FORD PICKUP 5272 Police & Security 15,914.00
1735 1989 CHEVROLET SEDAN 110863 Property 11,041.00
1776 1983 CHEVROLET SEDAN 81802 Housing & Residential Life 14,993.00
1861 1987 CHEVROLET VAN 8993 Police & Security 15,592.00
1878 1987 CHEVROLET VAN 56047 Housing & Residential Life 15,930.00
1949 1992 CHEVROLET VAN 34474 Dining Services 18,712.00
2020 1999 FORD VAN 3398 Housing & Residential Life 22,045.00
2021 1987 DODGE VAN 59800 Dining Services 14,965.00
2063 1997 FORD SEDAN 62611 Police & Security 18,872.00
2071 2000 FORD VAN 3476 Property 20,336.00
2084 1993 GMC VAN 89094 Athletics 14,187.00
2112 1982 FORD SEDAN 103123 Housing & Residential Life 12,007.00
2124 1986 FORD VAN 36838 Printing Services 11,518.00
2126 1986 FORD TRUCK 43670 Housing & Residential Life 9,471.00
2128 1987 FORD VAN 99880 Athletics 15,197.00
2131 1991 CHEVROLET PICKUP 31394 Housing & Residential Life 15,613.00
2132 1986 CHEVROLET PICKUP 77104 Housing & Residential Life 14,019.00
2139 1985 DODGE VAN 10650 Property 11,985.00
2141 1996 FORD VAN 5721 Housing & Residential Life 22,546.00
2142 2003 GMC TRUCK Telecomm 13,410.00
2153 1990 CHEVROLET VAN 32315 Telecomm 14,109.00
2166 1990 CHEVROLET VAN 43038 Housing & Residential Life 17,022.00
2167 1999 FORD TRUCK 2229 Dining Services 21,743.00
2353 1986 GMC PICKUP 58570 Dining Services 14,127.00
2364 1986 CHEVROLET SEDAN 92419 Athletics 11,630.00
2388 1987 DODGE VAN 33321 Housing & Residential Life 15,485.00
2412 1987 FORD VAN 35497 Housing & Residential Life 9,025.00
2489 1988 CHEVROLET VAN 26493 Property 14,347.00
MAINTENANCE
COST-ANNUAL
1,932.76
1,331.30
938.75
507.00
565.82
167.65
705.00
1,593.97
1,370.00 Create a pivote table based on the
1,235.29 follwing instruction: "Department" in
472.68
29.50 the Page area - "Make" in the Row
566.94 area- "Type" in the column area and
28.04
279.12
"Purchase" in the Data area
111.87
1,591.00
1,640.71
2,000.00
694.89
378.22
575.00
3,491.22
723.70
1,299.00
2,235.00
72.07
755.00
345.47
80.88
980.00
2,000.00
602.71
489.92
2,932.83
1,825.79
2,000.00
499.15
664.34
369.55
159.90
675.00
1,775.42
1,838.72
963.62
1,820.00
1,871.00
1,382.90
1,025.00
379.19
1,948.46
751.37
401.86
558.62
1,350.00
2,000.00
104.64
1,974.79
450.00
594.45
1,245.08
1,118.41
257.37
731.96
1,200.00
202.36
1,255.00
2,257.16
117.64
191.38
1,002.10
