Data Entry

AMAZON VENDOR LISTING - The client asked me to arrange, merge, and finalize the listings, simplifying the process of copying and pasting data into the waybill form. Additionally, this procedure helps us confirm transit times, accurate waybill details, packaging, weight, and quantity for each destination. It's important to note that this listing is also uploaded to their database, and therefore, no modifications or changes to data validation are allowed on this sheet.
COMPETITORS WATCHLIST -The client assigned me the task of analyzing their competitors based on specific product comparisons. I was responsible for creating a list that included the distributor's name, item name, link, price, date (sorted), price evaluation (high or low), and any relevant details for remarks. This task was executed using Microsoft Excel, incorporating hyperlinks and data validation with drop-down menus to ensure convenient navigation.
HOA CONCERN ISSUES - I compiled this list by collecting homeowners' complaints related to water supply issues. The information includes their addresses, Service Reference Numbers, and concerns. This list was created using Microsoft Excel, incorporating a drop-down menu for ease of use.
MATERIALS TO CANVASS - This listing serves the purpose of organizing supply procurement and canvassing efforts at various Hardware Supply stores near the project site. It provides details such as the number of items to be canvassed and their respective prices at different hardware locations. The column highlighted in yellow indicates the winning bid.
MERALCO CONSUMPTION REPORT - This document tracks monthly electricity consumption for monitoring and comparison with previous months and years. It was created using Microsoft Excel and features a graphical representation to facilitate trend analysis.