Improve health tracker v2 · HTML
Copy
iMPROve Health — Materials Tracker
🌿
iMPROve Health — Event Materials Tracker
Not connected to Excel file
📋 Connect to your shared Excel file
This tracker reads and writes to your iMPROve Health Materials Tracker.xlsx file stored on OneDrive or SharePoint. Follow these steps once:
1
Upload
iMPROve_Health_Materials_Tracker.xlsx to your SharePoint or OneDrive.2
Open the file in Excel Online, click File → Share → Copy Link. Make sure it's set to "Anyone with link can edit" or your org can edit.
3
Paste the SharePoint/OneDrive share URL below and click Connect.
Total Items
—
Checked Out
—
People with Items
—
Available Now
—
Who currently has items
Upcoming / Overdue Returns
| Staff Member | Items | Due Date | Days Out | Status |
|---|
All Materials
Sun
Mon
Tue
Wed
Thu
Fri
Sat
| ID | Staff Member | Items | Out Date | Return Date | Days Out | Status | Notes |
|---|
📖 Full Setup Guide
1
Upload the Excel file — drag
iMPROve_Health_Materials_Tracker.xlsx into your SharePoint document library or OneDrive folder that your whole team can access.2
Get the share link — open the file in Excel Online, go to File → Share → Copy Link. Set permissions to "People in your organization can edit."
3
Upload this HTML file — upload
iMPROve_Health_Tracker.html to the same SharePoint library. Anyone can click it to open the tracker in their browser.4
Connect on first load — paste the Excel share URL in the connection box at the top. The tracker will read your live data.
5
Share with your team — send everyone the link to this HTML file. They'll each connect once and then have live access to the tracker.
Note: When someone fills out the checkout form, a new row is added to the Checkouts sheet of your Excel file automatically. The Excel file itself is always the source of truth — your team can also open it directly in SharePoint if needed.
Check Out Materials
Return Items