Fix MIS Dashboard Parsing Bugs -- 2

Job ID: 40479742

Budget: ₹750 – ₹1,250 INR

I maintain a single-file HTML MIS dashboard for ADFC Finance that lives on Netlify and pulls its data directly from a Google Sheet. Two parsing problems have crept in: the Interest Rate, Cost of Fund and Net Spread columns show 0 % on each live sync, and the month labels arrive out of order with phantom future months. I’d like both issues resolved in parallel rather than staged.

While you are inside the code, please also make the automatic data refresh rock-solid at an hourly cadence. To future-proof the whole flow, replace the current gviz call with the Google Sheets API; vanilla JavaScript is already in place, so you can stay within that stack. A short hand-over note explaining any new functions, API keys or deployment tweaks will close the loop.

Deliverables
• Correct numeric parsing so all three percentage fields display accurate values.
• Correct date parsing so months appear in true chronological order with no extra entries.
• Hourly, reliable auto-refresh of sheet data.
• Migration from gviz to Google Sheets API within the same Netlify/GitHub setup.
• One-page hand-over summary (setup, endpoints, troubleshooting tips).

Everything runs against real NBFC customer data, so confidentiality is essential; I’ll provide repository access and a view-only link to the sheet once we start.