Hi, I'm an Electrical Engineer/Lighting Designer that can give you a detailed lighting design for your residential project. You expect to receive dwg and pdf lighting layout( Including switch location, type of switch and light switch circuit).
Although I'm not using excel for all the calculation you required but I can do it through lighting software Dialux Evo. All calculations: cavity ratio, illumination levels per room, point to point calculation etc.
Looking forward to working with you.
Regards,
Jed