HomeMy WebLinkAboutFW BILLED GAR (format issue)Hello Bethani,
It was great to speak with you this afternoon.
I have attached the two files you created for January 2015 and two that
were created by Chris Perry for Month End October 2014.
Could you tweak your two Excel reports to match the format that Chris
used? It would be very helpful for me, so I can sort the data by street
name, direction of street (N or E, etc), address and COMP code.
Above is Chris’s CC GBG BILLED report and below is your CC BILLED GAR
JAN report.
Your report has spill over text from the CUSTOMER (column C) into the
SERV (column D) and also the ICE ADDRESS (column E) contains both the
street direction (N, E, etc) and the Street name.
I am unable sort your report by street name, direction of street (N or
E, etc), address and COMP code.
Same goes for the REUSE CC report.
Anything you can do to make these format changes would be greatly
appreciated.
Thank you,
Lonnie
Lonnie Dunn
Deputy Director of Public Works Services
City of Cape Canaveral
P.O. Box 326
Cape Canaveral, FL 32920
L.Dunn@cityofcapecanaveral.org <mailto:L.Dunn@cityofcapecanaveral.org>
www.cityofcapecanaveral.org <http://www.cityofcapecanaveral.org/>
Office Phone: 321-868-1240
Office Fax: 321-868-1233
From: John DeLeo
Sent: Tuesday, February 10, 2015 5:09 PM
To: Lonnie Dunn
Subject: FW: BILLED GAR
Here you go……….let me know.
John C. DeLeo
Administrative/Financial Services Director
City of Cape Canaveral
P.O. Box 326
Cape Canaveral, FL 32920
www.cityofcapecanaveral.org <http://www.cityofcapecanaveral.org/>
Telephone: 321.868.1234 x230
Fax: 321.868.1248
From: Bethani Foster [mailto:bfoster@cocoafl.org]
Sent: Tuesday, February 10, 2015 4:32 PM
To: John DeLeo
Subject: BILLED GAR
Bethani Foster
Accounting Tech
65 Stone St., Cocoa, FL 32922
(321) 433-8418 I bfoster@cocoafl.org <mailto:bfoster@cocoafl.org>
Fax: (321) 433-8408
Stay Connected:
<https://www.facebook.com/pages/City-of-Cocoa-Government/125152240842388
> <https://twitter.com/CityofCocoa>
<https://www.linkedin.com/company/city-of-cocoa?trk=company_logo>
<https://www.youtube.com/channel/UCbWJK7XQyPVBmp15Fwoa4jA>
<https://plus.google.com/b/116258217957232717525/116258217957232717525/a
bout> <http://www.pinterest.com/CityofCocoa/cocoa-florida/>
www.cocoafl.org <http://www.cocoafl.org/>
This electronic message is privileged and confidential material. This
message is intended solely for the individual or entity named above. If
the receiver of this message is not the intended recipient, please be
advised that any dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify the sender immediately and delete
it.
Florida has a very broad public records law. As a result, any written
communication created or received by the City of Cape Canaveral
officials and employees will be made available to the public and/or
media upon request, unless otherwise exempt. Under Florida Law, email
addresses are public records. If you do not want your email address
released in response to a public-records request, do not send electronic
email to this entity. Instead, contact our office by phone or in writing
Florida has a very broad public records law. As a result, any written
communication created or received by the City of Cape Canaveral
officials and employees will be made available to the public and/or
media upon request, unless otherwise exempt. Under Florida Law, email
addresses are public records. If you do not want your email address
released in response to a public-records request, do not send electronic
email to this entity. Instead, contact our office by phone or in writing
Florida has a very broad public records law. As a result, any written
communication created or received by the City of Cape Canaveral
officials and employees will be made available to the public and/or
media upon request, unless otherwise exempt. Under Florida Law, email
addresses are public records. If you do not want your email address
released in response to a public-records request, do not send electronic
email to this entity. Instead, contact our office by phone or in writing
ƽɛ