{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,7,42,8],[43,7,43,8],[44,0,44,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[40,4,40,5],[41,4,41,5],[42,4,42,5],[43,4,43,5],[26,0,26,6],[26,7,26,8],[27,0,27,6],[27,7,27,8],[36,2,36,3],[36,4,36,5],[43,2,43,3],[24,0,24,6],[24,7,24,8],[19,0,19,1],[19,2,19,3],[19,4,19,9],[22,6,22,9],[43,0,43,1],[34,0,34,1],[34,2,34,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[29,7,29,8],[30,7,30,8],[40,0,40,1],[41,0,41,1],[42,0,42,1],[42,2,42,3],[37,4,37,5],[38,4,38,5],[39,4,39,5],[39,0,39,1],[23,0,23,6],[25,0,25,6],[28,0,28,6],[29,0,29,6],[37,0,37,1],[38,0,38,1],[6,0,8,9],[30,0,30,6],[23,7,23,8],[25,7,25,8],[28,7,28,8],[14,0,14,1],[14,2,14,3],[11,4,11,9],[12,4,12,9],[13,4,13,9],[14,4,14,9],[18,0,18,1],[18,2,18,3],[18,4,18,9],[21,0,21,9],[16,0,16,9],[32,0,32,9],[12,0,12,1],[12,2,12,3],[13,0,13,1],[13,2,13,3],[9,0,9,9],[5,0,5,9],[11,0,11,1],[11,2,11,3]]}
[]
[]
[]
[]
[]
["Dental PPE Estimator"]
["The purpose of the PPE estimator is to provide dentists with a calculator and methodology to estimate their PPE needs based on their staffing and patients. Please note that this tool is based on various organizations (CDC & ADA) recommended PPE guidelines and may change as the pandemic continues to evolve. Additionally, the calculator is simply a tool to estimate PPE and will not be accurate for every practice. "]
[]
[]
["Staffing"]
[]
["Number of Doctors",null,null,null,"< Enter Number of Doctors on staff"]
["Number of Hygenists",null,null,null,"< Enter Average number of hygenists on staff daily"]
["Number of Assistants",null,null,null,"< Enter Average number of Assistants on staff daily"]
["Number of Front Office",null,null,null,"< Enter Average front office staff working daily"]
[]
["Practice/Patients"]
[]
["Avg. Patients/Day",null,null,null,"< Enter Average patients seen per day"]
["# of Open Operatories",null,null,null,"< Enter # of open operatories"]
[]
["Personal Methodology"]
[null,null,null,null,null,null,"                 Please select from the lists below"]
["Are you utilizing scrubs or disposable gowns for you and your team?"]
["If you're using disposable gowns, how many patients do you estimate seeing with each gown?"]
["Do you plan on wearing an earloop mask over your N95 or KN95 mask and dispose after each patient?"]
["Are you requiring your front office staff to wear an earloop mask or KN95 mask?"]
["Are you requiring your front office staff to wear a face shield? "]
["Are you requiring your staff to wear head covers?"]
["Are you requiring your staff to wear shoe covers?"]
["Are you requiring your patients to wear shoe covers?"]
[]
["PPE Requirements"]
[]
["# of Days Purchased",null,20,null,"< Preloaded for 4 weeks of inventory, but can be changed for your needs"]
[]
[null,null,"Daily Requirement",null,"Order Quantity (in EA)",null,"Estimated Unit Price","Order Total"]
["KN95 Masks",null,{"$f":"IF(E38=\"\",\"\",ROUNDUP(E38/$C$35,0))","v":""},null,{"$f":"IF(H26=\"\",\"\",SUM(C12:D14)*C35+IF(H27=\"KN95\",C15*C35,0))","v":""},null,4,{"$f":"IF(E38=\"\",\"\",E38*G38)","v":""}]
["Earloop Masks",null,{"$f":"IF(E39=\"\",\"\",ROUNDUP(E39/$C$35,0))","v":""},null,{"$f":"IF(H26=\"\",\"\",IF(H27=\"Earloop\",C15*C35,0)+IF(H26=\"YES\",C19/C20*SUM(C12:D14)*C35,0))","v":""},null,0.8,{"$f":"IF(E39=\"\",\"\",E39*G39)","v":""}]
["Face Shields",null,"",null,{"$f":"IF(H28=\"\",\"\",SUM(C12:D14)*C35+IF(H28=\"YES\",C15*C35/10,0))","v":""},null,3.5,""]
["Gowns",null,"",null,{"$f":"IF(H24=\"\",\"\",IF(H24=\"Gowns\",SUM(C12:D14)*C19*C35/H25,0))","v":""},null,5,""]
["Head Covers",null,"",null,{"$f":"IF(H29=\"\",\"\",IF(H29=\"YES\",SUM(C12:D14)*C35,0))","v":""},null,1,""]
["Shoe Covers",null,"",null,{"$f":"IF(H30=\"\",\"\",IF(H30=\"YES\",SUM(C12:D14)*C35+IF(H31=\"YES\",C19*C35,0),0))","v":""},null,1,""]
["Gloves",null,"",null,{"$f":"IF(C12=\"\",\"\",SUM(C12:D14)*C19*C35+C15*C35)","v":""},null,0.5,""]
["*Please note that the Estimated Unit Prices can be changed based on your actual costs; the current inputs are an estimate based on the current market"]

{"sheet":"Sheet2","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Scrubs",null,1,null,"KN95"]
["Gowns",null,2,null,"Earloop"]
[null,null,3]
["Yes",null,4]
["No",null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]