HomeMy WebLinkAbout167172 12/17/2008 CITY OF CARMEL, INDIANA VENDOR: 360762 Page 1 of 1
rF ONE CIVIC SQUARE BRET SCHMUTTE
CHECK AMOUNT: $3,600.00
CARMEL, INDIANA 46032 21108 N BANBURY ROAD
oN `o NOBLESVILLE IN 46062 CHECK NUMBER: 167172
CHECK DATE: 12/17/2008
DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER A DESCRIPTION
1701 4341903 BAS112008 1,069.41 SOFTWARE SUPPORT FEES
1701 R4341903 10362 BAS112008 805.59 YEAR END SUPPORT
1701 R4341903 10362 BAS122008 1,725.00 YEAR END SUPPORT
�m
Bret Schmutte
21108 N. Banbury Rd
Noblesville, IN 46062
12/12/2008
City of Carmel Clerk Treasurer
One Civic Square
Carmel, IN 46032
ATTN: Diana Cordray
Invoice: BAS112008 Total Due for this Invoice: $1,875.00
Hours: Rate: Amount:
11/21/2008 On -site with Diana, Jean and Connie to discuss issues with the 1:00 N/A $0.00
Payroll Time System over the past year and resolutions I would
recommend.
(1:30 pm 2:30 pm BAS)
11/24/2008 Work on adding the logic to the Payroll Time System that will allow 8:00 $75.00 $600.00
reports to be created in a PDF format as well as code that will
automatically update local copies of the program. On -site to work on
creating the connection to SQL Server on Jean's computer. Work with
Jun on the problems I am having connecting to the SQL Server
database.
(8:00 am 4:00 pm BAS)
11/25/2008 Finish -up adding the PDF code and the auto update logic. Work on 4:00 $75.00 $300.00
the SQL Server connection issues at Carmel. Start testing the entire
product for any issues it might have with the new code and the SQL
Server back -end.
(8:00 am 12:00 pm BAS)
11/26/2008 Add in logic that will allow quicker entry of time per Teresa Lewis 2:30 $75.00 $187.50
request we discussed at Thursday's meeting.
(9:00 am 11:30 am BASO
11/29/2008 Rewrite the accrual program to work with the SQL Server back -end. 4:00 $75.00 $300.00
Continue testing all areas of the application to see if there are any
additional modifications needed for the SQL Server back -end.
(8:00 am 12:00 pm BAS)
11/30/2008 Continue testing modifications to all reports. Test the deploy process 4:00 $75.00 $300.00
to make sure everything is working correctly.
(8:00 am 12:00 pm BAS)
11/30/2008 Run through the process of moving the Payroll Time System data 2:30 $75.00 $187.50
from the Access back -end to the SQL Server back -end.
(2:30 pm 5:00 pm BAS)
Total Chargeable: C$I .00
Total not charged: .00
Bret Schmutte
21108 N. Banbury Rd
Noblesville, IN 46062
12/12/2008
City of Carmel Clerk Treasurer
One Civic Square
Carmel, IN 46032
ATTN: Diana Cordray
Invoice: BAS112008 Total Due for this Invoice: $1,725.00
Hours: Rate: Amount:
12/01/2008 On -site to test the new program on Jean's and Connie's computer. 4:00 $75.00 $300.00
Modify program to fix some issues with the 99a is having with the
SQL Server back -end. Modify program to not initiate the printer
selection code if a default printer is not selected. This was causing
Connie's PC to error out.
(10:30 am 12:30 pm BAS)
(1:30 pm 3:30 pm BAS)
12/04/2008 Work on creating some ad hoc reports for Connei and Jean to help 4:00 $75.00 $300.00
determine if the number of regular work hours is a glitch or a problem
with how users are entering data. Determined problem is with how
data is being entered in most cases. Will modify database to prevent
duplication of records in the Over -time table. Document for Terry
Crockett what will be installed on the machines.
(11:00 am 12:00 pm BAS)
(1:00 pm 4:00 pm BAS)
12/08/2008 On -site to install the new Payroll time system program at the remote 7:00 $75.00 $525.00
locations.
(8:00 am 12:30 pm BAS)
(1:30 pm 4:00 pm BAS)
12/09/2008 On -site to install new version of the payroll time system program at 4:00 $75.00 $300.00
the departments in City Hall.
(8:00 am.. 11:00 am BAS)
(12:00 pm 1:00 pm BAS)
12/10/2008 On -site to fix Karen's copy at the Mayor's department. On -site at the 2:30 $75.00 $187.50
Comm. Center to load up the program at Garry's computer and
discuss with him the changes. Make one final adjustment to the
program so department administrator assignments are made globally
rather than locally.
(10:00 am 11:30 am BAS)
(1:00 pm 2:00 pm BAS)
12/10/2008 Work on 2009 Excel Timesheet changes. Make modification to 1:30 $75.00 $112.50
program to accept the new version.
(8:30 am 10:00 am BAS)
Total Chargeable: _$1,725.00
Prescribed by State Board of Accounts City Form No. 201 (Rev. 1995)
ACCOUNTS PAYABLE VOUCHER
CITY OF CARMEL
An invoice or bill to be properly itemized must show: kind of service, where performed, dates service rendered, by
whom, rates per day, number of hours, rate per hour, number of units, price per unit, etc.
Payee
Purchase Order No.
Terms
Date Due
Invoice Invoice Description Amount
Date Number (or note attached invoice(s) or bill(s))
Ca 20
S
Total
I hereby certify that the attached invoice(s), or bill(s), is (are) true and correct and I have audited same in accordance
with IC 5- 11- 10 -1.6.
20
Clerk- Treasurer
VOUCHER NO. WARRANT NO.
F ALLOWED 20
IN SUM OF
acv
ON ACCOUNT OF APPROPRIATION FOR
Board Members
PO# or INVOICE NO. ACCT #/TITLE AMOUNT
DEPT. I hereby certify that the attached invoice(s), or
bill(s) is (are) true and correct and that the
materials or services itemized thereon for
�4sIlav Q��,S which charge is made were ordered and
4 1 received except
20
Signature
Cost distribution ledger classification if Title
claim paid motor vehicle highway fund