Developed a website for a special-education NGO: inside anvifoundation.org

Developed a website for a special-education NGO: inside anvifoundation.org

What went into the site we built for Anvi Foundation in Kamothe, Navi Mumbai: an enquiry form made for worried parents, UPI and bank donati…

Why our online tools never upload your files

Nothing you open in a BeeProton tool is sent anywhere: the processing happens in your own browser. Here is what a normal online converter d…

How to get a file past a government portal's upload limit

Scholarship forms, Passport Seva, PAN and Aadhaar updates, GST registration and job portals each state their own KB cap, pixel size and for…

How to pick which task to automate first

Most automation projects fail because the wrong task was chosen, not because the code was bad. Here is the arithmetic that says whether a t…

Why Hindi text and leading zeros break when you save a CSV (and the fixes)

CSV carries no encoding declaration and no column types, so Excel guesses both. Here is why Devanagari arrives as हि, why a 6-digit PIN…

Merging twelve monthly sales files into one clean sheet

Twelve monthly exports, slightly different headers, some duplicate invoices and no branch column. How to stack them correctly in the browse…

The data cleaning checklist I run before any analysis

Profile first, fix types second, and handle missing values by asking what the blank means rather than reaching for fillna(0). The seven-ste…

Photo and signature size rules for Indian exam forms (and how to hit them exactly)

SSC, IBPS, RRB, UPSC and state PSC portals each want a photo and signature at fixed pixels and a fixed KB band. Here are the actual numbers…

How image compression actually works, and where quality really goes

JPEG throws detail away on purpose, PNG throws nothing away, and WEBP does both. Here is what the quality slider changes, why re-saving a J…