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.
I needed a network. A network that can understand me.
Who can understand a woman at the age of 40 who will suddenly pivot to an unknown world of data? There are many questions lingering in my head. Is this a wise decision? Will it bring joy and excitement to my career? Will it sustain me financially? But before I can answer those questions for myself I realised that attending courses will not suffice for me to be a Data Analyst. I needed someone to teach me and make me comfortable in every step that I need to take. With that, I looked for a community that has this culture who believes to the capacity of a late career shifter like me. Then, I found SHE LOVES DATA.
2021 I was assigned to be on a group under Singapore Chapter but Richa, Head of Global Operations, reached out and let me to be a part of her team. Inch by inch with guidance from Venetia and trust of Richa I am now managing some of She Loves Data Signature Program. I can know first hand the dates of trainings I can attend and somewhat a free brain picking from top notch instructors of She Loves Data.
Last Thursday (11 August 2022), it is a big in-person event for She Loves Data! The very first Singapore event for 2022. The vibe is wonderful! Quinn and Aimee removed my doubts and gave comfort to alleviate my anxiety. Ohhh.. I want to cry now. They have told me stuffs that makes me think and push away the imposter syndrome out of my head.
The event is CELEBRATE YOU and it clearly stands on its name. I know and I feel that every woman and man in that room have picked some nuggets of wisdom from each other. That we all felt the warmth of community and someone is behind our back to achieve not only our data career goals but also developing ourselves for betterment.
Thank you Jana for building this kind of network.. a network of women that can understand what a career shifter like me is going through. A camaraderie indeed! Thank you for the free workshops that enhances and challenges our skills. Thank you so much.
With all that, I can say that I am confident to join the data workforce and let’s crunch those data! *wink-wink*
May ALMIGHTY always bless SHE LOVES DATA and all the volunteers behind it! Onward Sisters!
