We Care, We Share (Risalah Excel)
Someone asked me, why don’t I make a channel specifically for programming because he knows my experience in coding, instead make a channel about Spreadsheet (Excel ).
My answer will focus on the question why Risalah Excel ?, the answer is that the first time I created this channel was to provide tutorials for my partners / clients who use My “ERP Software”, while at the same time they still use excel to store data
During the migration process, there are many needs and questions on how to extract, transform, and load from Excel to the database efficiently,
because it is impossible to provide training to each client with the same case, the idea came up to make a video tutorial and share it with them…that’s it.
Actually, the feature in Microsoft Excel especially for programming, Visual Basic For Application, is quite powerful for many needs, especially in offices.
Some of the apps / tools that I created using VB in Microsoft Excel are:
- 𝘕𝘶𝘮2𝘞𝘰𝘳𝘥 (Terbilang) functions,
For Indonesian language, it might be common, what about other languages? Of course it is a challenge, there are some things that need to be considered, namely:
a. The pronunciation process, the relationship between one number / series of numbers to another number / series of numbers will affect the pronunciation, for example in Arabic and German.
b. Character encoding, for example Arabic, and Indian, Chinese, Japanese. character ü for German, etc.
c. Characteristics, each language certainly has its own characteristics, for example
Indian language for numbers there are special groupings, namely “Lakh” (Hundreds of Thousands) and “Crore” (Tens of Millions), so the number 1,000,000 is not read as “one …” but “Ten Lakhs”.
Some of the languages that are already supported in this function are:
✅ Arabic
✅ English
✅ French
✅ German
✅ Indian language
2. Parser
a. Math Parser using Recursive Descent Parser
b. HTML and XML parser from scratch
c. JSON parser from scratch
d. ISO8583 Parser, originally created in Visual Basic 6 for PPOB (Payment Point Online Bank),
From 2007 to 2015 i focused more on in Payment Gateway, and built national payment systems for several client companies where I worked before or when I opened my own company.
Technology: Java, JPOS, JBOSS, EJB server side, VB6 Desktop Side
for the ISO8583 Parsing process I plan to share in my channel (Insya Allah)
e. SQL Parser
f. Java Code Parser (up to version 5, for functional programming / lambda not yet), experimental, still simple but the AST structure has been formed,
Get Takat Wicaksono’s stories in your inbox
Join Medium for free to get updates from this writer.
3. Games
a. Solitaire, not using WinAPI GDI for graphics processing, just dynamic control. using Double Linked List, reading intersection between objects, etc.
4. Tools
a. DB Explorer Supports almost all RDMS databases, for SQL Query there are additional features that other tools do not have, namely:
SHOW TABLE LIST <pattern> with * as wildcard, displays all tables / views based on the input pattern
SHOW TABLE INFO <table/view>, displays table view information, primary key, nullable, etc.
SHOW TABLE CREATE <table/view>, generate Create Table / View completely
b. Source Xode Generator, more utilized to generate source code for the backend (ORM) such as (EJB, Spring, Hibernate, IBatis, Laravel, CI, Prisma, Sequilize, Entity Framework, Linq, Dapper, SQLAlchemy, Django ORM), What about the frontend? why not, the source code can be generated by a mapping process using a pre-defined model.
VBA with all its simplicity and classic style still has a strong magic aura for its fans, I am one of the VB users since the early generation which was previously preceded by BASICA and GWBASIC which I still use VB for several purposes.
Now for the programming channel discourse, it’s actually already in my planning, just still waiting for the right moment, emmm, emmmm the right moment is when this Risalah Excel channel has reached 1K subscribers, so for those who want to support my channel, please subscribe and share.
See you in other stories.
