Google AI Doctor Ranking Report
Budget: $250 – $750 USD
I have an Excel workbook, two of them that lists each doctor’s name, every procedure they have completed, the total count of those procedures, and the corresponding adjusted net production. I need an automated, Google-AI–powered bot that can read this file, generate an individual “report card” for every doctor, then rank them procedure-by-procedure so they instantly see how they stack up against their peers.
The excel sheets I have are consolidated, so it lists all doctors and their production on one excel, the second excel has all the procedures they have done.
It needs to look like a report card and very aesthetic.
Core workflow
1. Upload or drop the Excel file.
2. The bot parses the sheet, grouping data by doctor and procedure.
3. Google AI processes the numbers, builds a clean side-by-side comparison, and flags any statistical anomalies.
4. A finished report—PDF and/or Google Sheet tab—is produced for each doctor, complete with overall rank, per-procedure rank, and peer average benchmarks.
Acceptance criteria
• Reads the provided fields exactly: Doctor’s name, Procedure, Procedure count, Adjusted net production.
• Creates one concise report card per doctor plus an aggregate dashboard.
• Ranking logic is transparent and editable.
• End-to-end run is fully automated from file upload to report output.
Please highlight relevant experience with Google AI (Vertex AI, PaLM API, or similar) and any prior work on data-driven reporting automations so I can gauge fit quickly.
The excel sheets I have are consolidated, so it lists all doctors and their production on one excel, the second excel has all the procedures they have done.
It needs to look like a report card and very aesthetic.
Core workflow
1. Upload or drop the Excel file.
2. The bot parses the sheet, grouping data by doctor and procedure.
3. Google AI processes the numbers, builds a clean side-by-side comparison, and flags any statistical anomalies.
4. A finished report—PDF and/or Google Sheet tab—is produced for each doctor, complete with overall rank, per-procedure rank, and peer average benchmarks.
Acceptance criteria
• Reads the provided fields exactly: Doctor’s name, Procedure, Procedure count, Adjusted net production.
• Creates one concise report card per doctor plus an aggregate dashboard.
• Ranking logic is transparent and editable.
• End-to-end run is fully automated from file upload to report output.
Please highlight relevant experience with Google AI (Vertex AI, PaLM API, or similar) and any prior work on data-driven reporting automations so I can gauge fit quickly.