Hi,
With my expertise in Excel advanced formulas, Power Pivot, data validation, template design, conditional formatting etc. I will design the automated system, to generate the required Doctor wise charge sheet and Hospital wise bills for the selected period, based on the attached Rate card as the input.
I have handled excel files containing data sets with 1,80,000+ rows containing four years of data and successfully delivered similar Projects on various Freelancing platforms.
If we move forward on this Project, I will discuss with you further details of how the system would work. If you need it to be on cloud, I will develop it using Google sheets.
Please do revert with any queries which you might have.
Look forward to work with you soon.
BR,
Devashish.