Excel columns to SQL WHERE IN Operator
HTML, CSS, Javascript, React
A tool to parse data from excel to format that can be used for the IN operator in SQL.
I wanted to learn front end to be able to build tools that everyone can use instead of running scripts on their machine. Although scripts are still useful, I felt that certain tasks are easier with a user interface, especially for non technical users.
HTML, CSS, Javascript, React
A tool to parse data from excel to format that can be used for the IN operator in SQL.
HTML, CSS, Javascript, React
A tool to help determine when you should stop increment $500 and forgo the save bonus.
HTML, CSS, Javascript, React
A tool to help you calculate monthly average balance.
HTML, CSS, Javascript, React
Upload your SCB account statement CSV file to automatically calculate monthly average balances with detailed daily breakdown. Current month appears first, followed by previous months.
HTML, CSS, Javascript, React, Tailwind CSS
Calculate the Monthly Average Balance (MAB) required to maximize your miles based on your spending.
HTML, CSS, Javascript, React, Tailwind CSS
Parse your UOB KrisFlyer Debit Card transaction history to calculate the Monthly Average Balance (MAB) required to maximize your miles based on your spending.
HTML, CSS, Javascript, React, Tailwind CSS
Upload UOB credit card XLS exports, group by calendar posting month, assign bonus categories, track S$750 per category, and remember merchants by description.
HTML, CSS, Javascript, React, Tailwind CSS
Punch in a purchase amount and see which UOB and DBS Woman’s cards earn the most miles, including a split across cards when that beats a single swipe.
HTML, CSS, Javascript, React, Tailwind CSS
Drop in a DBS card transaction CSV to track calendar-month spend against the S$1,000 Woman’s Card cap. Counts by transaction date, including pending, less refunds, and ignores payments.
HTML, CSS, Javascript, React, Tailwind CSS
UOB’s export stops at 100 rows, so the statement file can’t rebuild the month. Enter UOB One, UOB Lady’s Savings, and UOB KrisFlyer, name each card, and see how much KrisFlyer spend still earns 6.4 miles per dollar.