CoServe Data Entry Project
MILLICENT HERRERA
Portfolio
CoServ Project (Data Entry)
3 Things used for the project:
1.Hola Chrome Extension (I’ve searched
and installed on my Google Chrome web
browser)
2. Coserv website (link was provided)
3. Google Sheet (link was provided)
MILLICENT HERRERA
Portfolio
CoServ Project (Data Entry)
On the CoServ site I need to go to the
“New Service”
MILLICENT HERRERA
Portfolio
CoServ Project (Data Entry)
A pop-up will appear, and this is
where I start my job.
MILLICENT HERRERA
Portfolio
CoServ Project (Data Entry)
Each City I have to select each Zip/Postal Code
and within each Code, I have to select an
address to see the result. Then I put the data on
the Google Sheet.
MILLICENT HERRERA
Portfolio
CoServ Project (Data Entry)
This will be an example of the result. If the
highlighted portion appears, on the Google
Sheet it must be written as Electric & Gas under
the “Type” column
MILLICENT HERRERA
Portfolio
CoServ Project (Data Entry)
This is the Google Sheet where I entered the
necessary details. If the result was Electric &
Gas, I have to type CoServe under the
Electric_Name column and on the Gas_Name.
MILLICENT HERRERA
Portfolio
CoServ Project (Data Entry)
If another option appears on the side, like on
the picture, I have to delete that address on the
Google Sheet.
MILLICENT HERRERA
Portfolio
CoServ Project (Data Entry)
Solution and Process:
• I used a script to extract the Zip/Postal Codes
and Address for me to encode efficiently and
faster on the Google Sheet.
• After I encoded the Code and Address, by 50, I
will check the result each address if it is electric
or both.
• As mentioned on the goals if there is an apt,
suite appears I will delete it on the list.
• I have sped up the result due to the script I
used.