On my 39 years of existence I am always grateful for all that happened in my life. Good things that I truly enjoyed and bad experiences that served as hard lessons.
These are my life reflections. Wink-wink.
Health: My memories are still vivid na karga ako ni Nanay and tumatakbo papunta kay Dr Almazan. It’s clear in my mind nung ang daming tao lagi sa bahay namin because suddenly I can’t stretch my legs and can’t walk. Asthma attacks? Yes I have those until college days. Very flimsy creature ako ano? Haha!
But now, you can challenge me to walk 20k steps for days. I can do HIIT for 90mins and jog 5KM. I can say that I am healthier than my younger years. But syempre since I am ageing I am taking extra care sa mga buto-buto ko and extra effort to know ang wants and rejections ng katawan ko.
Money: Dahil natapos na ang una naming goal for HOA mas nakakaluwag na kami ni Abbey ngayon. Dati cut-to-cut, walang malalaking travels..umaasa sa mga pa-contest and freebies para makanood kami ng sine. Lahat yan ay para makaipon, ngayon may kaunting room to wiggle na para sa susunod naming goal and we alloted funds to enjoy life.
Now we are looking forward to more opportunities where to invest para sa HOW.
Career: I am thankful to every boss and everyone na nakatrabaho ko. Madami akong natutunan sa inyo. This is my struggle now. Confusion that I need to clear out para sa sarili ko at ikakatahimik ni Abbey. Haha!
Friendships: Salamat Elite. I realised na mahal talaga namin ang isa’t-isa. Ang problema ng isa ay problema ng lahat. Ang success ng isa ay success naming lahat.
I am opening up myself for new friendships. Sa mga introverts na tulad ko, nakaka-relate kayo? Ang hirap diba?! Out of the box. Haha. So please bare with me.
Relationship: Dahil wala nga akong trabaho since 2020, 24/7 magkasama kami ni Abbey nung pandemic era. Di kami nag-aaway at ang matindi di kami nag-kakasawaan. Lalong nagkakilanlan at lalong tumibay. Ang cheesy! Hehe.
Family: We lost Nanay and somehow it gave us an emotional turmoil. Hanggang ngayon there’s a longing na sana andyan pa sya.
But we do not have time to delve in that past, so here we are making new memories with Tatay.
Selfcare: I have personal battles that I know I have won. The key thing for this is to know what triggers it.
Knowing yourself is not an easy job. There are lies you are telling to yourself that became your truth. Accepting my flaws, limitations and when to stop the fight is the best thing I have learned before hitting 40.
Spirituality: I am always sticking in my beliefs and glad that Abbey never bypassed those.
Well that’s my life before 40. It is playful, painful, crazy, daunting, euphoric and hopeful life!
Happy 40 sa aking mga ka-1983! Let’s all welcome our 40 with a grateful and blessed heart and mind! Kaya natin ito!
Because of my friend Denise I need to post a wish list. Nahihiya kasi ako manghingi (kahit di halata, haha!) ng gifts. There are times na I am thinking that I do not deserve gifts from people around me, but I have read in Dale Carnegie book, learning to receive blessings from others is an important aspect of cultivating positive relationships. I've come to understand that it's important to acknowledge and appreciate the generosity of those around me.. Kaya here I am, putting up my wish list and reasons I need those.
The Importance of Accepting Kindness: My Personal Wish List
Monthly Microsoft 365 Personal For many years I am brushing off Abbey’s idea to upgrade our Microsoft for Mac 2011. But now, I realise it's time to take the plunge and upgrade. I am wishing to start with a monthly subscription only to gauge whether the upgraded software is truly necessary or if Google Sheets can handle my analysis needs just as well. Ultimately, I'm looking to boost my productivity and streamline my workflow, and I'm excited to see how this upgrade can help me achieve those goals. La Panthère Eau de Toilette Last year, when I bought a gift for my friend Chat, I couldn't help but be struck by the incredible elegance and sophistication of Cartier perfume for women. I found myself wishing I could experience that same sense of refinement for myself. Now, I'm considering treating myself to a bottle of this luxurious fragrance. Independent Love Diamond Earrings | SDE02373 Will love to partner it with my dancing diamond necklace given by Abbey last September 2015. After 8 years, it seems mapapartneran na din sya :)
Upon finishing Data Analyst Pathway course offered by Development Academy of the Philippines, the next question is what’s next?
I am loud and proud to say that I am one of the pioneer graduate of Project SPARTA and not only that, I am one of their first interns in their Internship Program. A continuity of learning was offered to chosen graduates. Isn’t it nice?
In the SPARTA internship we were grouped into Marketing and Partnership/Events. I was assigned to the latter. My task is to track the partnership’s engagements on their way to signing MOUs, monitor partners communication strategies through their social media and create topics for challenges on Cauayan’s Open Data Hackathon.
One of the challenging parts of being a SPARTA Intern is to understand the problem that the given task is trying to achieve. As a person that is completely from a different background, I need to look into their ideas to understand where they are coming from. And I was blessed to be under Daniel Rosero who does not shush my idea away but almost and always accepts it with compliments.
The first task given to me in my SPARTA Internship is to create a form that will showcase everything about the stakeholders. I created two forms: without a database and with an automated entry form/database for an easy and printable report sheet. Remembering that gives me a light bulb moment!
After CCBI’s seminar, I thought to myself that data entry, automation or even digitalization of businesses in the Philippines is still out of reach, it is a long-long way to pave. And it is my light bulb moment to recreate the form I made as SPARTA Intern for an automated entry form/database to replace the manual task of truckers in the Philippines in managing their fleets.
As a former import coordinator of one the largest/oldest haulier companies in Singapore, I am blessed that I saw how powerful it is to have a data entry system to track this kind of business.
This form will give the owners/coordinators the summary of each job and the ease to print out an invoice for their customer.
Automated Entry Form and Database with Easy/Printable Invoice
Automated Entry Form and Database with Easy/Printable Invoice Using Google Sheets
This is FREE. If you have a google account you can run the script below using an Extension called Apps Script, copy and paste below.
//TO CLEAR THE FORM function clearForm() { constsheet= SpreadsheetApp.getActiveSpreadsheet().getSheetByName("FLEET TRACKER"); constui= SpreadsheetApp.getUi(); constresponse= ui.alert("Reset Confirmation", 'Do you want to reset this form?', ui.ButtonSet.YES_NO);
//TO DATA VALIDATION FOR DATA ENTRY function validateEntry(){ varmyGooglSheet= SpreadsheetApp.getActiveSpreadsheet(); varWMLUserForm= myGooglSheet.getSheetByName("FLEET TRACKER"); varui= SpreadsheetApp.getUi(); varcellsToCheck= ["C7", "C9", "C11", "C13", "C15", "C17", "C19", "C21", "C23", "C25", "C28", "C29", "C30", "C31", "C33", "C34", "C35", "C36", "C37"];
for (vari=0; i < cellsToCheck.length; i++) { varcurrentCell= WMLUserForm.getRange(cellsToCheck[i]); currentCell.setBackground('#FFFFFF'); if (currentCell.isBlank()) { var errorMessage; switch (cellsToCheck[i]) { case"C7": errorMessage = "Please enter BL Number / Booking Number."; break; case"C9": errorMessage = "Select Import/Export."; break; case"C11": errorMessage = "Please enter Client Name."; break; case"C13": errorMessage = "Please enter the Contact Person."; break; case"C15": errorMessage = "Please enter the Mobile Number / Email Address."; break; case"C17": errorMessage = "Please enter Vessel Name / Voyage Number."; break; case"C19": errorMessage = "Please enter Focal Person's Name."; break; case"C21": errorMessage = "Please enter Pick-Up Address (including unit number and postal code), Contact Person and Mobile Number."; break; case"C23": errorMessage = "Please enter Delivery Address (including unit number and postal code), Contact Person and Mobile Number."; break; case"C25": errorMessage = "Please key-in Mobile Number"; break; case"C28": errorMessage = "Please select..."; break; default: errorMessage = "Please fill out all required fields."; break; } ui.alert(errorMessage); currentCell.activate(); currentCell.setBackground('#FF0000'); returnfalse; } } returntrue; }
//SAVING THE DATA INTO THE DATABASE function submitData() { constss= SpreadsheetApp.getActiveSpreadsheet(); constformSheet= ss.getSheetByName("FLEET TRACKER"); constdataSheet= ss.getSheetByName("Database"); constui= SpreadsheetApp.getUi();
constresponse= ui.alert("Submit", "Do you want to save this data?", ui.ButtonSet.YES_NO); if (response == ui.Button.NO) return;
//RETRIEVING DATA FROM THE DATABASE function searchRecord() {
var myGooglSheet= SpreadsheetApp.getActiveSpreadsheet(); var WMLUserForm= myGooglSheet.getSheetByName("FLEET TRACKER"); vardatasheet= myGooglSheet.getSheetByName("Database");
varstr= WMLUserForm.getRange("C4").getValue(); varvalues= datasheet.getDataRange().getValues(); var valuesFound=false;
for (vari=0; i<values.length; i++) { varrowValue= values[i];
if (rowValue[0] == str) {
WMLUserForm.getRange("C7").setValue(rowValue[0]); WMLUserForm.getRange("C9").setValue(rowValue[1]); WMLUserForm.getRange("C11").setValue(rowValue[2]); WMLUserForm.getRange("C13").setValue(rowValue[3]); WMLUserForm.getRange("C15").setValue(rowValue[4]); WMLUserForm.getRange("C17").setValue(rowValue[5]); WMLUserForm.getRange("C19").setValue(rowValue[6]); WMLUserForm.getRange("C21").setValue(rowValue[7]); WMLUserForm.getRange("C23").setValue(rowValue[8]); WMLUserForm.getRange("C25").setValue(rowValue[9]); WMLUserForm.getRange("C28").setValue(rowValue[10]); WMLUserForm.getRange("C29").setValue(rowValue[11]); WMLUserForm.getRange("C30").setValue(rowValue[12]); WMLUserForm.getRange("C31").setValue(rowValue[13]); WMLUserForm.getRange("C33").setValue(rowValue[14]); WMLUserForm.getRange("C34").setValue(rowValue[15]); WMLUserForm.getRange("C35").setValue(rowValue[16]); WMLUserForm.getRange("C36").setValue(rowValue[17]); WMLUserForm.getRange("C37").setValue(rowValue[18]); return; //come out from the search function
} }
if(valuesFound==false){ varui= SpreadsheetApp.getUi(); ui.alert("No record found!"); }
}
//EDITING RECORD function editRecord() {
var myGooglSheet= SpreadsheetApp.getActiveSpreadsheet(); var WMLUserForm= myGooglSheet.getSheetByName("FLEET TRACKER"); vardatasheet= myGooglSheet.getSheetByName("Database");
varui= SpreadsheetApp.getUi();
varresponse= ui.alert("Submit", 'Do you want to update the data?',ui.ButtonSet.YES_NO);
if(valuesFound==false){ varui= SpreadsheetApp.getUi(); ui.alert("No record found!"); }
}
You can comment here or email me to send you a copy of this form or if you want me to customize some parts just for you.
This is what being an analyst is, analysts are not just all about data wrangling, or creating a dashboard or detecting trends and patterns. Analysts are here to help solve real-life problems using available (free or paid) tools for the betterment of the businesses that we can pass to next generations.
