{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Overview","Startup Costs","Study Management Costs","Patient Costs","Data Validation"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Instructions","index":0,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,12],[2,0,2,12],[4,0,4,12],[6,0,6,12],[26,0,26,12],[12,0,12,12],[14,0,14,12],[15,0,15,12],[16,0,16,12],[17,0,17,12],[19,0,19,12],[22,0,22,12],[20,0,20,12],[21,0,21,12],[23,0,23,12],[24,0,24,12],[25,0,25,12],[5,0,5,12],[13,0,13,12],[8,0,8,12],[9,0,9,12],[10,0,10,12],[11,0,11,12],[18,0,18,12],[7,0,7,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Version Date: 06-MAR-2023"]
["School of Medicine Office of Grants and Contracts (SOMOGC)\nSalary Over the Cap (SOC) Costing Allocation Template\nUser Instructions"]
["Clinical Trial Budget Template"]
[]
["• \"Overview\":"]
["   □ Enter the administrative details about the clinical trial in cells I3-I16. The indirect cost (IDC) rate entered in I5 will be used to calculate the IDC for all tabs. "]
["   □ In cell F17, enter the total number of patients you plan to enroll in this clinical trial. This number will be the multipler used to determine the total patient costs (F18)."]
["• \"Data Validation\":"]
["   □ Enter all of the clinical trial roles and their hourly pay rate in the \"Personnel\" table (A4:B23)."]
["   □ Enter the non-personnel startup costs and their prices in the \"Startup Costs - Other Cost\" table (A26:B42)."]
["   □ Etner study management costs and their prices in the \"Study Management Costs\" table (D4:E35)."]
["   □ Enter procedures and their associated negotiated price, research cost, UPG fee, and sponsor rate in the \"Procedures\" table (G4:L49)."]
["• \"Startup Costs\":"]
["   □ Enter the names of the personnel committing time/effort for \"Study Meeting Costs & Setup,\" (B7:B14) \"IRB and GCRC Submission and Setup,\" (B19:B26) and \"Budget and Contract Costs and Setup\" (B31:B38)."]
["   □ In cells C7:C14/C19:C26/C31:C38 choose the role from the dropdown menu for each name you have listed; these options are populated from the \"Personnel\" table on the \"Data Validation\" tab and the hourly rate for those roles will auto-populate in cells D7:D14/D19:D26/D31:D38."]
["   □ In cells E7:E14/E19:E26/E31:E38 enter the number of hours for each person."]
["   □ In cells B44:B58 select non-personnel startup costs from the dropdown menu; these options are populated from the \"Startup Costs - Other Costs\" table on the \"Data Validation\" tab."]
["• \"Study Management Costs\""]
["   □ In cells B8:B26 select study management fees from the dropdown menu; these options are populated from the \"Study Mangement Costs\" table on the \"Data Validation\" tab."]
["   □ In cells D8:D26 enter the quantity of each study management fee across the entire clinical trial project period."]
["• Patient Costs\":"]
["   □ The \"Patient Costs\" tab is preloaded with 10 visits. There is an option to increase this to as many as 24 visits by using the \"Add/Remove Visits\" buttons (C7:D14). When you remove visits all of the data therein will be deleted."]
["   □ The prodedures listed in cells G4:G48 are populated from the procedures entered on the \"Data Validation\" tab (cells D5:D49)."]
["   □ In cells H3:AE3 you can enter unique names for each visit."]
["   □ To include a procedure for a specific visit, enter an \"X\" in the correct cell on the \"Procedure\" table (H4:AE48). The cell will become highlighted in yellow and the cost of that procedure—based on the amount you listed as the negotiated price in cells H5:H49 on the \"Data Validation\" tab—will be added to the total cost per visit (H49:AE49) and the total cost per procedure (AF4:AF48)."]
["   □ On the \"Non-Procedures\" table, enter the name of the non-procedure (G53:G99) and then select the personnel responsible for each non-procedure from the drop downlist (F53:F99)."]
["   □ Enter the number of hours for each non-procedure. This will serve as the multiplier for the hourly pay rate which is determined by the personnel selected from the dropdown menu for each non-procedure."]

{"sheet":"Overview","index":1,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,5],[2,1,2,5],[8,1,8,5],[1,1,1,5],[10,1,10,4],[11,1,11,5],[9,1,9,5],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[19,1,19,4],[21,1,21,4],[12,1,12,5],[13,1,13,4],[14,1,14,4],[17,1,17,4],[15,1,15,4],[16,1,16,4],[2,8,2,13],[3,8,3,13],[4,8,4,13],[5,8,5,13],[6,8,6,13],[12,8,12,13],[13,8,13,13],[14,8,14,13],[15,8,15,13],[7,8,7,13],[8,8,8,13],[9,8,9,13],[10,8,10,13],[11,8,11,13]]}
[null,"BUDGET OVERVIEW FOR ENTIRE CLINICAL TRIAL"]
[]
[null,"STARTUP COSTS",null,null,null,null,null,"Principal Investigator"]
[null,"Subtotal - Study Meetings",null,null,null,{"$f":"'Startup Costs'!F15","v":0},null,"Study Title"]
[null,"Subtotal - IRB & GCRC Submission",null,null,null,{"$f":"'Startup Costs'!F27","v":0},null,"IDC Rate (%)"]
[null,"Subtotal - Budget and Contract",null,null,null,{"$f":"'Startup Costs'!F39","v":0},null,"Study IRB#"]
[null,"Subtotal - Other Costs",null,null,null,{"$f":"'Startup Costs'!F59","v":0},null,"Study Phase"]
[null,"Total Startup Costs",null,null,null,{"$f":"'Startup Costs'!F61","v":0},null,"Study Type"]
[null,null,null,null,null,null,null,"Therapeutic Agent Class"]
[null,"STUDY MANAGEMENT COSTS",null,null,null,null,null,"Randomized vs Open-Label"]
[null,"Total Study Management & Site Costs",null,null,null,{"$f":"'Study Management Costs'!E27","v":0},null,"Study Arm # (out of X)"]
[null,null,null,null,null,null,null,"Mode of Study Agent Treatment"]
[null,"PATIENT COSTS",null,null,null,null,null,"Cycle Length"]
[null,"Subtotal - Per Patient Procedure Costs",null,null,null,{"$f":"'Patient Costs'!AF49","v":0},null,"Total # Study Drug Treatments"]
[null,"Subtotal - Per Patient Non-Procedure Costs",null,null,null,{"$f":"'Patient Costs'!AF101","v":0},null,"Study Duration"]
[null,"Total Per Patient Costs",null,null,null,{"$f":"Overview!F14+Overview!F15","v":0},null,"Maximum # Study Visits"]
[null,"# of Patients"]
[null,"Total Patient Costs",null,null,null,{"$f":"F16*F17","v":0}]
[]
[null,"Institutional Overhead",null,null,null,{"$f":"(F8+F11+F18)*I5","v":0}]
[]
[null,"TOTAL STUDY MANAGEMENT & SITE COSTS",null,null,null,{"$f":"F8+F11+F18+F20","v":0}]

{"sheet":"Startup Costs","index":2,"n_rows":65,"n_cols":6,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,1,0,5],[64,1,64,4],[63,1,63,5],[4,1,4,5],[15,1,15,5],[28,1,28,5],[59,1,59,5],[60,1,60,4],[62,1,62,4],[61,1,61,5],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,4],[41,1,41,5],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[54,1,54,2],[49,1,49,2],[53,1,53,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[1,2,1,5],[2,2,2,5],[42,1,42,4],[43,1,43,2],[44,1,44,2],[14,1,14,4],[39,1,39,5],[40,1,40,3],[16,1,16,5],[26,1,26,4],[27,1,27,5],[38,1,38,4]]}
[null,"STARTUP COSTS"]
[null,{"$f":"\"Principal Investigator: \"","v":"Principal Investigator: "},{"$f":"IF(Overview!I3=\"\",\"\",Overview!I3)","v":""}]
[null,"Project Title:",{"$f":"IF(Overview!I4=\"\",\"\",Overview!I4)","v":""}]
[]
[null,"Study Meetings Costs & Setup"]
[null,"Name","Title / Rate Designation","Hourly \nRate","Hours","Total \nCost"]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C7,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(D7*E7,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C8,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(D8*E8,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C9,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C10,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C11,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C12,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C13,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C14,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,"Subtotal Study Meetings:",null,null,null,{"$f":"SUM(F7:F14)","v":0}]
[]
[null,"IRB and GCRC Submission & Setup"]
[null,"Name","Title / Rate Designation","Hourly \nRate","Hours","Total \nCost"]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C19,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(D19*E19,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C20,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(D20*E20,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C21,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C22,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C23,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C24,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C25,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C26,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,"Subtotal Submission:",null,null,null,{"$f":"SUM(F19:F26)","v":0}]
[]
[null,"Budget and Contract Costs & Setup"]
[null,"Name","Title / Rate Designation","Hourly \nRate","Hours","Total \nCost"]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C31,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(D31*E31,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C32,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C33,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C34,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C35,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C36,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C37,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$C38,'Data Validation'!$A$5:$B$23,2,FALSE),\"\")","v":""},null,""]
[null,"Subtotal Budget & Contract:",null,null,null,{"$f":"SUM(F31:F38)","v":0}]
[]
[null,"Subtotal Study Meeting/Submission/Budget & Contract Costs",null,null,{"$f":"SUM(E31:E38,E19:E26,E7:E14)","v":0},{"$f":"SUM(F39+F27+F15)","v":0}]
[]
[null,"Other Startup Costs (Supplies, Fees, etc.)",null,null,null,"Total \nCost"]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B44,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B45,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B46,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B47,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B48,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B49,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B50,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B51,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B52,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B53,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B54,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B55,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B56,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B57,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Startup Costs'!$B58,'Data Validation'!$A$27:$B$42,2,FALSE),\"\")","v":""}]
[null,"Subtotal Other Costs",null,null,null,{"$f":"SUM(F44:F58)","v":0}]
[]
[null,"Subtotal Startup Costs",null,null,null,{"$f":"SUM(F59+F41)","v":0}]
[]
[null,"Institutional Overhead ",null,null,null,{"$f":"IF(F61=\"\",0,F61*Overview!I5)","v":0}]
[]
[null,"TOTAL STARTUP COST",null,null,null,{"$f":"SUM(F61+F63)","v":0}]

{"sheet":"Study Management Costs","index":3,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[27,1,27,4],[29,1,29,4],[0,1,0,4],[5,1,5,4],[26,1,26,3],[1,2,1,4],[2,2,2,4],[3,1,3,2],[28,1,28,3]]}
[null,"STUDY MANAGEMENT COSTS"]
[null,"Principal Investigator:",{"$f":"IF(Overview!I3=\"\",\"\",Overview!I3)","v":""}]
[null,"Project Title:",{"$f":"IF(Overview!I4=\"\",\"\",Overview!I4)","v":""}]
[null,null,null,"IDC Rate (%):",{"$f":"IF(Overview!I5=\"\",\"\",Overview!I5)","v":""}]
[]
[null,"Study Management Costs"]
[null,"Study Management Fees","Rate","Quantity","Total \nCost*"]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B8,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(C8*D8,\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B9,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(C9*D9,\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B10,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B11,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B12,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B13,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B14,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B15,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B16,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B17,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B18,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B19,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B20,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B21,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B22,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B23,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B24,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B25,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(VLOOKUP('Study Management Costs'!$B26,'Data Validation'!$D$5:$E$35,2,FALSE),\"\")","v":""},null,""]
[null,"Subtotal Study Management Costs:",null,null,{"$f":"SUM(E8:E26)","v":0}]
[]
[null,"Institutional Overhead",null,null,{"$f":"IF(E4=\"\",0,E4*E27)","v":0}]
[]
[null,"TOTAL STUDY MANAGEMENT & SITE COSTS",null,null,{"$f":"E27+E29","v":0}]
[]
[null,"*Does not include institutional overhead"]

{"sheet":"Patient Costs","index":4,"n_rows":107,"n_cols":32,"rows_kept":107,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,4],[2,1,2,4],[6,2,6,3],[3,1,3,2]]}
["PATIENT COSTS",null,null,null,null,null,null,"Visit 1","Visit 2","Visit 3","Visit 4","Visit 5","Visit 6","Visit 7","Visit 8","Visit 9","Visit 10","Visit 11","Visit 12","Visit 13","Visit 14","Visit 15","Visit 16","Visit 17","Visit 18","Visit 19","Visit 20","Visit 21","Visit 22","Visit 23","Visit 24"]
["Principal Investigator:",{"$f":"IF(Overview!I3=\"\",\"\",Overview!I3)","v":""}]
["Project Title:",{"$f":"IF(Overview!I4=\"\",\"\",Overview!I4)","v":""},null,null,null,null,"Procedures",null,null,null,null,null,null,null,null,null,null,"Visit 11","Visit 12","Visit 13","Visit 14","Visit 15","Visit 16","Visit 17","Visit 18","Visit 19","Visit 20","Visit 21","Visit 22","Visit 23","Visit 24","TOTAL"]
[null,null,null,"IDC Rate (%)",{"$f":"IF(Overview!I5=\"\",\"\",Overview!I5)","v":""},null,{"$f":"'Data Validation'!$G5","v":"[INSERT PROCEDURE #1]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H5*SUMPRODUCT(LEN($H4:$AE4)-LEN(SUBSTITUTE($H4:$AE4,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G6","v":"[INSERT PROCEDURE #2]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H6*SUMPRODUCT(LEN($H5:$AE5)-LEN(SUBSTITUTE($H5:$AE5,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G7","v":"[INSERT PROCEDURE #3]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H7*SUMPRODUCT(LEN($H6:$AE6)-LEN(SUBSTITUTE($H6:$AE6,\"X\",\"\")))","v":0}]
[null,null,"Add/Remove Visits",null,null,null,{"$f":"'Data Validation'!$G8","v":"[INSERT PROCEDURE #4]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H8*SUMPRODUCT(LEN($H7:$AE7)-LEN(SUBSTITUTE($H7:$AE7,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G9","v":"[INSERT PROCEDURE #5]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H9*SUMPRODUCT(LEN($H8:$AE8)-LEN(SUBSTITUTE($H8:$AE8,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G10","v":"[INSERT PROCEDURE #6]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H10*SUMPRODUCT(LEN($H9:$AE9)-LEN(SUBSTITUTE($H9:$AE9,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G11","v":"[INSERT PROCEDURE #7]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H11*SUMPRODUCT(LEN($H10:$AE10)-LEN(SUBSTITUTE($H10:$AE10,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G12","v":"[INSERT PROCEDURE #8]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H12*SUMPRODUCT(LEN($H11:$AE11)-LEN(SUBSTITUTE($H11:$AE11,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G13","v":"[INSERT PROCEDURE #9]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H13*SUMPRODUCT(LEN($H12:$AE12)-LEN(SUBSTITUTE($H12:$AE12,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G14","v":"[INSERT PROCEDURE #10]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H14*SUMPRODUCT(LEN($H13:$AE13)-LEN(SUBSTITUTE($H13:$AE13,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G15","v":"[INSERT PROCEDURE #10]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H15*SUMPRODUCT(LEN($H14:$AE14)-LEN(SUBSTITUTE($H14:$AE14,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G16","v":"[INSERT PROCEDURE #12]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H16*SUMPRODUCT(LEN($H15:$AE15)-LEN(SUBSTITUTE($H15:$AE15,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G17","v":"[INSERT PROCEDURE #13]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H17*SUMPRODUCT(LEN($H16:$AE16)-LEN(SUBSTITUTE($H16:$AE16,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G18","v":"[INSERT PROCEDURE #14]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H18*SUMPRODUCT(LEN($H17:$AE17)-LEN(SUBSTITUTE($H17:$AE17,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G19","v":"[INSERT PROCEDURE #15]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H19*SUMPRODUCT(LEN($H18:$AE18)-LEN(SUBSTITUTE($H18:$AE18,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G20","v":"[INSERT PROCEDURE #16]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H20*SUMPRODUCT(LEN($H19:$AE19)-LEN(SUBSTITUTE($H19:$AE19,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G21","v":"[INSERT PROCEDURE #17]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H21*SUMPRODUCT(LEN($H20:$AE20)-LEN(SUBSTITUTE($H20:$AE20,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G22","v":"[INSERT PROCEDURE #18]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H22*SUMPRODUCT(LEN($H21:$AE21)-LEN(SUBSTITUTE($H21:$AE21,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G23","v":"[INSERT PROCEDURE #19]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H23*SUMPRODUCT(LEN($H22:$AE22)-LEN(SUBSTITUTE($H22:$AE22,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G24","v":"[INSERT PROCEDURE #20]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H24*SUMPRODUCT(LEN($H23:$AE23)-LEN(SUBSTITUTE($H23:$AE23,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G25","v":"[INSERT PROCEDURE #21]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H25*SUMPRODUCT(LEN($H24:$AE24)-LEN(SUBSTITUTE($H24:$AE24,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G26","v":"[INSERT PROCEDURE #22]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H26*SUMPRODUCT(LEN($H25:$AE25)-LEN(SUBSTITUTE($H25:$AE25,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G27","v":"[INSERT PROCEDURE #23]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H27*SUMPRODUCT(LEN($H26:$AE26)-LEN(SUBSTITUTE($H26:$AE26,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G28","v":"[INSERT PROCEDURE #24]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H28*SUMPRODUCT(LEN($H27:$AE27)-LEN(SUBSTITUTE($H27:$AE27,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G29","v":"[INSERT PROCEDURE #25]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H24*SUMPRODUCT(LEN($H28:$AE28)-LEN(SUBSTITUTE($H28:$AE28,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G30","v":"[INSERT PROCEDURE #26]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H25*SUMPRODUCT(LEN($H29:$AE29)-LEN(SUBSTITUTE($H29:$AE29,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G31","v":"[INSERT PROCEDURE #27]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H26*SUMPRODUCT(LEN($H30:$AE30)-LEN(SUBSTITUTE($H30:$AE30,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G32","v":"[INSERT PROCEDURE #28]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H27*SUMPRODUCT(LEN($H31:$AE31)-LEN(SUBSTITUTE($H31:$AE31,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G33","v":"[INSERT PROCEDURE #29]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H28*SUMPRODUCT(LEN($H32:$AE32)-LEN(SUBSTITUTE($H32:$AE32,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G34","v":"[INSERT PROCEDURE #30]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H29*SUMPRODUCT(LEN($H33:$AE33)-LEN(SUBSTITUTE($H33:$AE33,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G35","v":"[INSERT PROCEDURE #31]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H30*SUMPRODUCT(LEN($H34:$AE34)-LEN(SUBSTITUTE($H34:$AE34,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G36","v":"[INSERT PROCEDURE #32]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H31*SUMPRODUCT(LEN($H35:$AE35)-LEN(SUBSTITUTE($H35:$AE35,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G37","v":"[INSERT PROCEDURE #33]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H27*SUMPRODUCT(LEN($H36:$AE36)-LEN(SUBSTITUTE($H36:$AE36,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G38","v":"[INSERT PROCEDURE #34]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H28*SUMPRODUCT(LEN($H37:$AE37)-LEN(SUBSTITUTE($H37:$AE37,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G39","v":"[INSERT PROCEDURE #35]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H29*SUMPRODUCT(LEN($H38:$AE38)-LEN(SUBSTITUTE($H38:$AE38,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G40","v":"[INSERT PROCEDURE #36]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H30*SUMPRODUCT(LEN($H39:$AE39)-LEN(SUBSTITUTE($H39:$AE39,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G41","v":"[INSERT PROCEDURE #37]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H31*SUMPRODUCT(LEN($H40:$AE40)-LEN(SUBSTITUTE($H40:$AE40,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G42","v":"[INSERT PROCEDURE #38]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H32*SUMPRODUCT(LEN($H41:$AE41)-LEN(SUBSTITUTE($H41:$AE41,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G43","v":"[INSERT PROCEDURE #39]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H33*SUMPRODUCT(LEN($H42:$AE42)-LEN(SUBSTITUTE($H42:$AE42,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G44","v":"[INSERT PROCEDURE #40]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H34*SUMPRODUCT(LEN($H43:$AE43)-LEN(SUBSTITUTE($H43:$AE43,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G45","v":"[INSERT PROCEDURE #41]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H35*SUMPRODUCT(LEN($H44:$AE44)-LEN(SUBSTITUTE($H44:$AE44,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G46","v":"[INSERT PROCEDURE #42]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H36*SUMPRODUCT(LEN($H45:$AE45)-LEN(SUBSTITUTE($H45:$AE45,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G47","v":"[INSERT PROCEDURE #43]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H37*SUMPRODUCT(LEN($H46:$AE46)-LEN(SUBSTITUTE($H46:$AE46,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G48","v":"[INSERT PROCEDURE #44]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H38*SUMPRODUCT(LEN($H47:$AE47)-LEN(SUBSTITUTE($H47:$AE47,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,{"$f":"'Data Validation'!$G49","v":"[INSERT PROCEDURE #45]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Validation'!$H39*SUMPRODUCT(LEN($H48:$AE48)-LEN(SUBSTITUTE($H48:$AE48,\"X\",\"\")))","v":0}]
[null,null,null,null,null,null,"Subtotal Per Pt Procedure Costs",{"$f":"(IF(H$4=\"X\",'Data Validation'!$H$5,0)+IF(H$5=\"X\",'Data Validation'!$H$6,0)+IF(H$6=\"X\",'Data Validation'!$H$7,0)+IF(H$7=\"X\",'Data Validation'!$H$8,0)+IF(H$8=\"X\",'Data Validation'!$H$9,0)+IF(H$9=\"X\",'Data Validation'!$H$10,0)+IF(H$10=\"X\",'Data Validation'!$H$11,0)+IF(H$11=\"X\",'Data Validation'!$H$12,0)+IF(H$12=\"X\",'Data Validation'!$H$13,0)+IF(H$13=\"X\",'Data Validation'!$H$14,0)+IF(H$14=\"X\",'Data Validation'!$H$15,0)+IF(H$15=\"X\",'Data Validation'!$H$16,0)+IF(H$16=\"X\",'Data Validation'!$H$17,0)+IF(H$17=\"X\",'Data Validation'!$H$18,0)+IF(H$18=\"X\",'Data Validation'!$H$19,0)+IF(H$19=\"X\",'Data Validation'!$H$20,0)+IF(H$20=\"X\",'Data Validation'!$H$21,0)+IF(H$21=\"X\",'Data Validation'!$H$22,0)+IF(H$22=\"X\",'Data Validation'!$H$23,0)+IF(H$23=\"X\",'Data Validation'!H$24,0)+IF(H$24=\"X\",'Data Validation'!$H$25,0)+IF(H$25=\"X\",'Data Validation'!$H$26,0)+IF(H$26=\"X\",'Data Validation'!$H$27,0)+IF(H$27=\"X\",'Data Validation'!$H$28,0)+IF(H$28=\"X\",'Data Validation'!$H$29,0)+IF(H$29=\"X\",'Data Validation'!$H$30,0)+IF(H$30=\"X\",'Data Validation'!$H$31,0)+IF(H$31=\"X\",'Data Validation'!$H$32,0)+IF(H$32=\"X\",'Data Validation'!$H$33,0)+IF(H$33=\"X\",'Data Validation'!$H$34,0)+IF(H$34=\"X\",'Data Validation'!$H$35,0)+IF(H$35=\"X\",'Data Validation'!$H$36,0)+IF(H$36=\"X\",'Data Validation'!$H$37,0)+IF(H$37=\"X\",'Data Validation'!$H$38,0)+IF(H$38=\"X\",'Data Validation'!$H$39,0)+IF(H$39=\"X\",'Data Validation'!$H$40,0)+IF(H$40=\"X\",'Data Validation'!$H$41,0)+IF(H$41=\"X\",'Data Validation'!$H$42,0)+IF(H$42=\"X\",'Data Validation'!$H$43,0)+IF(H$43=\"X\",'Data Validation'!$H$44,0)+IF(H$44=\"X\",'Data Validation'!$H$45,0)+IF(H$45=\"X\",'Data Validation'!$H$46,0)+IF(H$46=\"X\",'Data Validation'!$H$47,0)+IF(H$47=\"X\",'Data Validation'!$H$48,0) +IF(H$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(I$4=\"X\",'Data Validation'!$H$5,0)+IF(I$5=\"X\",'Data Validation'!$H$6,0)+IF(I$6=\"X\",'Data Validation'!$H$7,0)+IF(I$7=\"X\",'Data Validation'!$H$8,0)+IF(I$8=\"X\",'Data Validation'!$H$9,0)+IF(I$9=\"X\",'Data Validation'!$H$10,0)+IF(I$10=\"X\",'Data Validation'!$H$11,0)+IF(I$11=\"X\",'Data Validation'!$H$12,0)+IF(I$12=\"X\",'Data Validation'!$H$13,0)+IF(I$13=\"X\",'Data Validation'!$H$14,0)+IF(I$14=\"X\",'Data Validation'!$H$15,0)+IF(I$15=\"X\",'Data Validation'!$H$16,0)+IF(I$16=\"X\",'Data Validation'!$H$17,0)+IF(I$17=\"X\",'Data Validation'!$H$18,0)+IF(I$18=\"X\",'Data Validation'!$H$19,0)+IF(I$19=\"X\",'Data Validation'!$H$20,0)+IF(I$20=\"X\",'Data Validation'!$H$21,0)+IF(I$21=\"X\",'Data Validation'!$H$22,0)+IF(I$22=\"X\",'Data Validation'!$H$23,0)+IF(I$23=\"X\",'Data Validation'!$H$24,0)+IF(I$24=\"X\",'Data Validation'!$H$25,0)+IF(I$25=\"X\",'Data Validation'!$H$26,0)+IF(I$26=\"X\",'Data Validation'!$H$27,0)+IF(I$27=\"X\",'Data Validation'!$H$28,0)+IF(I$28=\"X\",'Data Validation'!$H$29,0)+IF(I$29=\"X\",'Data Validation'!$H$30,0)+IF(I$30=\"X\",'Data Validation'!$H$31,0)+IF(I$31=\"X\",'Data Validation'!$H$32,0)+IF(I$32=\"X\",'Data Validation'!$H$33,0)+IF(I$33=\"X\",'Data Validation'!$H$34,0)+IF(I$34=\"X\",'Data Validation'!$H$35,0)+IF(I$35=\"X\",'Data Validation'!$H$36,0)+IF(I$36=\"X\",'Data Validation'!$H$37,0)+IF(I$37=\"X\",'Data Validation'!$H$38,0)+IF(I$38=\"X\",'Data Validation'!$H$39,0)+IF(I$39=\"X\",'Data Validation'!$H$40,0)+IF(I$40=\"X\",'Data Validation'!$H$41,0)+IF(I$41=\"X\",'Data Validation'!$H$42,0)+IF(I$42=\"X\",'Data Validation'!$H$43,0)+IF(I$43=\"X\",'Data Validation'!$H$44,0)+IF(I$44=\"X\",'Data Validation'!$H$45,0)+IF(I$45=\"X\",'Data Validation'!$H$46,0)+IF(I$46=\"X\",'Data Validation'!$H$47,0)+IF(I$47=\"X\",'Data Validation'!$H$48,0) +IF(I$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(J$4=\"X\",'Data Validation'!$H$5,0)+IF(J$5=\"X\",'Data Validation'!$H$6,0)+IF(J$6=\"X\",'Data Validation'!$H$7,0)+IF(J$7=\"X\",'Data Validation'!$H$8,0)+IF(J$8=\"X\",'Data Validation'!$H$9,0)+IF(J$9=\"X\",'Data Validation'!$H$10,0)+IF(J$10=\"X\",'Data Validation'!$H$11,0)+IF(J$11=\"X\",'Data Validation'!$H$12,0)+IF(J$12=\"X\",'Data Validation'!$H$13,0)+IF(J$13=\"X\",'Data Validation'!$H$14,0)+IF(J$14=\"X\",'Data Validation'!$H$15,0)+IF(J$15=\"X\",'Data Validation'!$H$16,0)+IF(J$16=\"X\",'Data Validation'!$H$17,0)+IF(J$17=\"X\",'Data Validation'!$H$18,0)+IF(J$18=\"X\",'Data Validation'!$H$19,0)+IF(J$19=\"X\",'Data Validation'!$H$20,0)+IF(J$20=\"X\",'Data Validation'!$H$21,0)+IF(J$21=\"X\",'Data Validation'!$H$22,0)+IF(J$22=\"X\",'Data Validation'!$H$23,0)+IF(J$23=\"X\",'Data Validation'!$H$24,0)+IF(J$24=\"X\",'Data Validation'!$H$25,0)+IF(J$25=\"X\",'Data Validation'!$H$26,0)+IF(J$26=\"X\",'Data Validation'!$H$27,0)+IF(J$27=\"X\",'Data Validation'!$H$28,0)+IF(J$28=\"X\",'Data Validation'!$H$29,0)+IF(J$29=\"X\",'Data Validation'!$H$30,0)+IF(J$30=\"X\",'Data Validation'!$H$31,0)+IF(J$31=\"X\",'Data Validation'!$H$32,0)+IF(J$32=\"X\",'Data Validation'!$H$33,0)+IF(J$33=\"X\",'Data Validation'!$H$34,0)+IF(J$34=\"X\",'Data Validation'!$H$35,0)+IF(J$35=\"X\",'Data Validation'!$H$36,0)+IF(J$36=\"X\",'Data Validation'!$H$37,0)+IF(J$37=\"X\",'Data Validation'!$H$38,0)+IF(J$38=\"X\",'Data Validation'!$H$39,0)+IF(J$39=\"X\",'Data Validation'!$H$40,0)+IF(J$40=\"X\",'Data Validation'!$H$41,0)+IF(J$41=\"X\",'Data Validation'!$H$42,0)+IF(J$42=\"X\",'Data Validation'!$H$43,0)+IF(J$43=\"X\",'Data Validation'!$H$44,0)+IF(J$44=\"X\",'Data Validation'!$H$45,0)+IF(J$45=\"X\",'Data Validation'!$H$46,0)+IF(J$46=\"X\",'Data Validation'!$H$47,0)+IF(J$47=\"X\",'Data Validation'!$H$48,0) +IF(J$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(K$4=\"X\",'Data Validation'!$H$5,0)+IF(K$5=\"X\",'Data Validation'!$H$6,0)+IF(K$6=\"X\",'Data Validation'!$H$7,0)+IF(K$7=\"X\",'Data Validation'!$H$8,0)+IF(K$8=\"X\",'Data Validation'!$H$9,0)+IF(K$9=\"X\",'Data Validation'!$H$10,0)+IF(K$10=\"X\",'Data Validation'!$H$11,0)+IF(K$11=\"X\",'Data Validation'!$H$12,0)+IF(K$12=\"X\",'Data Validation'!$H$13,0)+IF(K$13=\"X\",'Data Validation'!$H$14,0)+IF(K$14=\"X\",'Data Validation'!$H$15,0)+IF(K$15=\"X\",'Data Validation'!$H$16,0)+IF(K$16=\"X\",'Data Validation'!$H$17,0)+IF(K$17=\"X\",'Data Validation'!$H$18,0)+IF(K$18=\"X\",'Data Validation'!$H$19,0)+IF(K$19=\"X\",'Data Validation'!$H$20,0)+IF(K$20=\"X\",'Data Validation'!$H$21,0)+IF(K$21=\"X\",'Data Validation'!$H$22,0)+IF(K$22=\"X\",'Data Validation'!$H$23,0)+IF(K$23=\"X\",'Data Validation'!$H$24,0)+IF(K$24=\"X\",'Data Validation'!$H$25,0)+IF(K$25=\"X\",'Data Validation'!$H$26,0)+IF(K$26=\"X\",'Data Validation'!$H$27,0)+IF(K$27=\"X\",'Data Validation'!$H$28,0)+IF(K$28=\"X\",'Data Validation'!$H$29,0)+IF(K$29=\"X\",'Data Validation'!$H$30,0)+IF(K$30=\"X\",'Data Validation'!$H$31,0)+IF(K$31=\"X\",'Data Validation'!$H$32,0)+IF(K$32=\"X\",'Data Validation'!$H$33,0)+IF(K$33=\"X\",'Data Validation'!$H$34,0)+IF(K$34=\"X\",'Data Validation'!$H$35,0)+IF(K$35=\"X\",'Data Validation'!$H$36,0)+IF(K$36=\"X\",'Data Validation'!$H$37,0)+IF(K$37=\"X\",'Data Validation'!$H$38,0)+IF(K$38=\"X\",'Data Validation'!$H$39,0)+IF(K$39=\"X\",'Data Validation'!$H$40,0)+IF(K$40=\"X\",'Data Validation'!$H$41,0)+IF(K$41=\"X\",'Data Validation'!$H$42,0)+IF(K$42=\"X\",'Data Validation'!$H$43,0)+IF(K$43=\"X\",'Data Validation'!$H$44,0)+IF(K$44=\"X\",'Data Validation'!$H$45,0)+IF(K$45=\"X\",'Data Validation'!$H$46,0)+IF(K$46=\"X\",'Data Validation'!$H$47,0)+IF(K$47=\"X\",'Data Validation'!$H$48,0) +IF(K$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(L$4=\"X\",'Data Validation'!$H$5,0)+IF(L$5=\"X\",'Data Validation'!$H$6,0)+IF(L$6=\"X\",'Data Validation'!$H$7,0)+IF(L$7=\"X\",'Data Validation'!$H$8,0)+IF(L$8=\"X\",'Data Validation'!$H$9,0)+IF(L$9=\"X\",'Data Validation'!$H$10,0)+IF(L$10=\"X\",'Data Validation'!$H$11,0)+IF(L$11=\"X\",'Data Validation'!$H$12,0)+IF(L$12=\"X\",'Data Validation'!$H$13,0)+IF(L$13=\"X\",'Data Validation'!$H$14,0)+IF(L$14=\"X\",'Data Validation'!$H$15,0)+IF(L$15=\"X\",'Data Validation'!$H$16,0)+IF(L$16=\"X\",'Data Validation'!$H$17,0)+IF(L$17=\"X\",'Data Validation'!$H$18,0)+IF(L$18=\"X\",'Data Validation'!$H$19,0)+IF(L$19=\"X\",'Data Validation'!$H$20,0)+IF(L$20=\"X\",'Data Validation'!$H$21,0)+IF(L$21=\"X\",'Data Validation'!$H$22,0)+IF(L$22=\"X\",'Data Validation'!$H$23,0)+IF(L$23=\"X\",'Data Validation'!$H$24,0)+IF(L$24=\"X\",'Data Validation'!$H$25,0)+IF(L$25=\"X\",'Data Validation'!$H$26,0)+IF(L$26=\"X\",'Data Validation'!$H$27,0)+IF(L$27=\"X\",'Data Validation'!$H$28,0)+IF(L$28=\"X\",'Data Validation'!$H$29,0)+IF(L$29=\"X\",'Data Validation'!$H$30,0)+IF(L$30=\"X\",'Data Validation'!$H$31,0)+IF(L$31=\"X\",'Data Validation'!$H$32,0)+IF(L$32=\"X\",'Data Validation'!$H$33,0)+IF(L$33=\"X\",'Data Validation'!$H$34,0)+IF(L$34=\"X\",'Data Validation'!$H$35,0)+IF(L$35=\"X\",'Data Validation'!$H$36,0)+IF(L$36=\"X\",'Data Validation'!$H$37,0)+IF(L$37=\"X\",'Data Validation'!$H$38,0)+IF(L$38=\"X\",'Data Validation'!$H$39,0)+IF(L$39=\"X\",'Data Validation'!$H$40,0)+IF(L$40=\"X\",'Data Validation'!$H$41,0)+IF(L$41=\"X\",'Data Validation'!$H$42,0)+IF(L$42=\"X\",'Data Validation'!$H$43,0)+IF(L$43=\"X\",'Data Validation'!$H$44,0)+IF(L$44=\"X\",'Data Validation'!$H$45,0)+IF(L$45=\"X\",'Data Validation'!$H$46,0)+IF(L$46=\"X\",'Data Validation'!$H$47,0)+IF(L$47=\"X\",'Data Validation'!$H$48,0) +IF(L$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(M$4=\"X\",'Data Validation'!$H$5,0)+IF(M$5=\"X\",'Data Validation'!$H$6,0)+IF(M$6=\"X\",'Data Validation'!$H$7,0)+IF(M$7=\"X\",'Data Validation'!$H$8,0)+IF(M$8=\"X\",'Data Validation'!$H$9,0)+IF(M$9=\"X\",'Data Validation'!$H$10,0)+IF(M$10=\"X\",'Data Validation'!$H$11,0)+IF(M$11=\"X\",'Data Validation'!$H$12,0)+IF(M$12=\"X\",'Data Validation'!$H$13,0)+IF(M$13=\"X\",'Data Validation'!$H$14,0)+IF(M$14=\"X\",'Data Validation'!$H$15,0)+IF(M$15=\"X\",'Data Validation'!$H$16,0)+IF(M$16=\"X\",'Data Validation'!$H$17,0)+IF(M$17=\"X\",'Data Validation'!$H$18,0)+IF(M$18=\"X\",'Data Validation'!$H$19,0)+IF(M$19=\"X\",'Data Validation'!$H$20,0)+IF(M$20=\"X\",'Data Validation'!$H$21,0)+IF(M$21=\"X\",'Data Validation'!$H$22,0)+IF(M$22=\"X\",'Data Validation'!$H$23,0)+IF(M$23=\"X\",'Data Validation'!$H$24,0)+IF(M$24=\"X\",'Data Validation'!$H$25,0)+IF(M$25=\"X\",'Data Validation'!$H$26,0)+IF(M$26=\"X\",'Data Validation'!$H$27,0)+IF(M$27=\"X\",'Data Validation'!$H$28,0)+IF(M$28=\"X\",'Data Validation'!$H$29,0)+IF(M$29=\"X\",'Data Validation'!$H$30,0)+IF(M$30=\"X\",'Data Validation'!$H$31,0)+IF(M$31=\"X\",'Data Validation'!$H$32,0)+IF(M$32=\"X\",'Data Validation'!$H$33,0)+IF(M$33=\"X\",'Data Validation'!$H$34,0)+IF(M$34=\"X\",'Data Validation'!$H$35,0)+IF(M$35=\"X\",'Data Validation'!$H$36,0)+IF(M$36=\"X\",'Data Validation'!$H$37,0)+IF(M$37=\"X\",'Data Validation'!$H$38,0)+IF(M$38=\"X\",'Data Validation'!$H$39,0)+IF(M$39=\"X\",'Data Validation'!$H$40,0)+IF(M$40=\"X\",'Data Validation'!$H$41,0)+IF(M$41=\"X\",'Data Validation'!$H$42,0)+IF(M$42=\"X\",'Data Validation'!$H$43,0)+IF(M$43=\"X\",'Data Validation'!$H$44,0)+IF(M$44=\"X\",'Data Validation'!$H$45,0)+IF(M$45=\"X\",'Data Validation'!$H$46,0)+IF(M$46=\"X\",'Data Validation'!$H$47,0)+IF(M$47=\"X\",'Data Validation'!$H$48,0) +IF(M$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(N$4=\"X\",'Data Validation'!$H$5,0)+IF(N$5=\"X\",'Data Validation'!$H$6,0)+IF(N$6=\"X\",'Data Validation'!$H$7,0)+IF(N$7=\"X\",'Data Validation'!$H$8,0)+IF(N$8=\"X\",'Data Validation'!$H$9,0)+IF(N$9=\"X\",'Data Validation'!$H$10,0)+IF(N$10=\"X\",'Data Validation'!$H$11,0)+IF(N$11=\"X\",'Data Validation'!$H$12,0)+IF(N$12=\"X\",'Data Validation'!$H$13,0)+IF(N$13=\"X\",'Data Validation'!$H$14,0)+IF(N$14=\"X\",'Data Validation'!$H$15,0)+IF(N$15=\"X\",'Data Validation'!$H$16,0)+IF(N$16=\"X\",'Data Validation'!$H$17,0)+IF(N$17=\"X\",'Data Validation'!$H$18,0)+IF(N$18=\"X\",'Data Validation'!$H$19,0)+IF(N$19=\"X\",'Data Validation'!$H$20,0)+IF(N$20=\"X\",'Data Validation'!$H$21,0)+IF(N$21=\"X\",'Data Validation'!$H$22,0)+IF(N$22=\"X\",'Data Validation'!$H$23,0)+IF(N$23=\"X\",'Data Validation'!$H$24,0)+IF(N$24=\"X\",'Data Validation'!$H$25,0)+IF(N$25=\"X\",'Data Validation'!$H$26,0)+IF(N$26=\"X\",'Data Validation'!$H$27,0)+IF(N$27=\"X\",'Data Validation'!$H$28,0)+IF(N$28=\"X\",'Data Validation'!$H$29,0)+IF(N$29=\"X\",'Data Validation'!$H$30,0)+IF(N$30=\"X\",'Data Validation'!$H$31,0)+IF(N$31=\"X\",'Data Validation'!$H$32,0)+IF(N$32=\"X\",'Data Validation'!$H$33,0)+IF(N$33=\"X\",'Data Validation'!$H$34,0)+IF(N$34=\"X\",'Data Validation'!$H$35,0)+IF(N$35=\"X\",'Data Validation'!$H$36,0)+IF(N$36=\"X\",'Data Validation'!$H$37,0)+IF(N$37=\"X\",'Data Validation'!$H$38,0)+IF(N$38=\"X\",'Data Validation'!$H$39,0)+IF(N$39=\"X\",'Data Validation'!$H$40,0)+IF(N$40=\"X\",'Data Validation'!$H$41,0)+IF(N$41=\"X\",'Data Validation'!$H$42,0)+IF(N$42=\"X\",'Data Validation'!$H$43,0)+IF(N$43=\"X\",'Data Validation'!$H$44,0)+IF(N$44=\"X\",'Data Validation'!$H$45,0)+IF(N$45=\"X\",'Data Validation'!$H$46,0)+IF(N$46=\"X\",'Data Validation'!$H$47,0)+IF(N$47=\"X\",'Data Validation'!$H$48,0) +IF(N$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(O$4=\"X\",'Data Validation'!$H$5,0)+IF(O$5=\"X\",'Data Validation'!$H$6,0)+IF(O$6=\"X\",'Data Validation'!$H$7,0)+IF(O$7=\"X\",'Data Validation'!$H$8,0)+IF(O$8=\"X\",'Data Validation'!$H$9,0)+IF(O$9=\"X\",'Data Validation'!$H$10,0)+IF(O$10=\"X\",'Data Validation'!$H$11,0)+IF(O$11=\"X\",'Data Validation'!$H$12,0)+IF(O$12=\"X\",'Data Validation'!$H$13,0)+IF(O$13=\"X\",'Data Validation'!$H$14,0)+IF(O$14=\"X\",'Data Validation'!$H$15,0)+IF(O$15=\"X\",'Data Validation'!$H$16,0)+IF(O$16=\"X\",'Data Validation'!$H$17,0)+IF(O$17=\"X\",'Data Validation'!$H$18,0)+IF(O$18=\"X\",'Data Validation'!$H$19,0)+IF(O$19=\"X\",'Data Validation'!$H$20,0)+IF(O$20=\"X\",'Data Validation'!$H$21,0)+IF(O$21=\"X\",'Data Validation'!$H$22,0)+IF(O$22=\"X\",'Data Validation'!$H$23,0)+IF(O$23=\"X\",'Data Validation'!$H$24,0)+IF(O$24=\"X\",'Data Validation'!$H$25,0)+IF(O$25=\"X\",'Data Validation'!$H$26,0)+IF(O$26=\"X\",'Data Validation'!$H$27,0)+IF(O$27=\"X\",'Data Validation'!$H$28,0)+IF(O$28=\"X\",'Data Validation'!$H$29,0)+IF(O$29=\"X\",'Data Validation'!$H$30,0)+IF(O$30=\"X\",'Data Validation'!$H$31,0)+IF(O$31=\"X\",'Data Validation'!$H$32,0)+IF(O$32=\"X\",'Data Validation'!$H$33,0)+IF(O$33=\"X\",'Data Validation'!$H$34,0)+IF(O$34=\"X\",'Data Validation'!$H$35,0)+IF(O$35=\"X\",'Data Validation'!$H$36,0)+IF(O$36=\"X\",'Data Validation'!$H$37,0)+IF(O$37=\"X\",'Data Validation'!$H$38,0)+IF(O$38=\"X\",'Data Validation'!$H$39,0)+IF(O$39=\"X\",'Data Validation'!$H$40,0)+IF(O$40=\"X\",'Data Validation'!$H$41,0)+IF(O$41=\"X\",'Data Validation'!$H$42,0)+IF(O$42=\"X\",'Data Validation'!$H$43,0)+IF(O$43=\"X\",'Data Validation'!$H$44,0)+IF(O$44=\"X\",'Data Validation'!$H$45,0)+IF(O$45=\"X\",'Data Validation'!$H$46,0)+IF(O$46=\"X\",'Data Validation'!$H$47,0)+IF(O$47=\"X\",'Data Validation'!$H$48,0) +IF(O$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(P$4=\"X\",'Data Validation'!$H$5,0)+IF(P$5=\"X\",'Data Validation'!$H$6,0)+IF(P$6=\"X\",'Data Validation'!$H$7,0)+IF(P$7=\"X\",'Data Validation'!$H$8,0)+IF(P$8=\"X\",'Data Validation'!$H$9,0)+IF(P$9=\"X\",'Data Validation'!$H$10,0)+IF(P$10=\"X\",'Data Validation'!$H$11,0)+IF(P$11=\"X\",'Data Validation'!$H$12,0)+IF(P$12=\"X\",'Data Validation'!$H$13,0)+IF(P$13=\"X\",'Data Validation'!$H$14,0)+IF(P$14=\"X\",'Data Validation'!$H$15,0)+IF(P$15=\"X\",'Data Validation'!$H$16,0)+IF(P$16=\"X\",'Data Validation'!$H$17,0)+IF(P$17=\"X\",'Data Validation'!$H$18,0)+IF(P$18=\"X\",'Data Validation'!$H$19,0)+IF(P$19=\"X\",'Data Validation'!$H$20,0)+IF(P$20=\"X\",'Data Validation'!$H$21,0)+IF(P$21=\"X\",'Data Validation'!$H$22,0)+IF(P$22=\"X\",'Data Validation'!$H$23,0)+IF(P$23=\"X\",'Data Validation'!$H$24,0)+IF(P$24=\"X\",'Data Validation'!$H$25,0)+IF(P$25=\"X\",'Data Validation'!$H$26,0)+IF(P$26=\"X\",'Data Validation'!$H$27,0)+IF(P$27=\"X\",'Data Validation'!$H$28,0)+IF(P$28=\"X\",'Data Validation'!$H$29,0)+IF(P$29=\"X\",'Data Validation'!$H$30,0)+IF(P$30=\"X\",'Data Validation'!$H$31,0)+IF(P$31=\"X\",'Data Validation'!$H$32,0)+IF(P$32=\"X\",'Data Validation'!$H$33,0)+IF(P$33=\"X\",'Data Validation'!$H$34,0)+IF(P$34=\"X\",'Data Validation'!$H$35,0)+IF(P$35=\"X\",'Data Validation'!$H$36,0)+IF(P$36=\"X\",'Data Validation'!$H$37,0)+IF(P$37=\"X\",'Data Validation'!$H$38,0)+IF(P$38=\"X\",'Data Validation'!$H$39,0)+IF(P$39=\"X\",'Data Validation'!$H$40,0)+IF(P$40=\"X\",'Data Validation'!$H$41,0)+IF(P$41=\"X\",'Data Validation'!$H$42,0)+IF(P$42=\"X\",'Data Validation'!$H$43,0)+IF(P$43=\"X\",'Data Validation'!$H$44,0)+IF(P$44=\"X\",'Data Validation'!$H$45,0)+IF(P$45=\"X\",'Data Validation'!$H$46,0)+IF(P$46=\"X\",'Data Validation'!$H$47,0)+IF(P$47=\"X\",'Data Validation'!$H$48,0) +IF(P$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(Q$4=\"X\",'Data Validation'!$H$5,0)+IF(Q$5=\"X\",'Data Validation'!$H$6,0)+IF(Q$6=\"X\",'Data Validation'!$H$7,0)+IF(Q$7=\"X\",'Data Validation'!$H$8,0)+IF(Q$8=\"X\",'Data Validation'!$H$9,0)+IF(Q$9=\"X\",'Data Validation'!$H$10,0)+IF(Q$10=\"X\",'Data Validation'!$H$11,0)+IF(Q$11=\"X\",'Data Validation'!$H$12,0)+IF(Q$12=\"X\",'Data Validation'!$H$13,0)+IF(Q$13=\"X\",'Data Validation'!$H$14,0)+IF(Q$14=\"X\",'Data Validation'!$H$15,0)+IF(Q$15=\"X\",'Data Validation'!$H$16,0)+IF(Q$16=\"X\",'Data Validation'!$H$17,0)+IF(Q$17=\"X\",'Data Validation'!$H$18,0)+IF(Q$18=\"X\",'Data Validation'!$H$19,0)+IF(Q$19=\"X\",'Data Validation'!$H$20,0)+IF(Q$20=\"X\",'Data Validation'!$H$21,0)+IF(Q$21=\"X\",'Data Validation'!$H$22,0)+IF(Q$22=\"X\",'Data Validation'!$H$23,0)+IF(Q$23=\"X\",'Data Validation'!$H$24,0)+IF(Q$24=\"X\",'Data Validation'!$H$25,0)+IF(Q$25=\"X\",'Data Validation'!$H$26,0)+IF(Q$26=\"X\",'Data Validation'!$H$27,0)+IF(Q$27=\"X\",'Data Validation'!$H$28,0)+IF(Q$28=\"X\",'Data Validation'!$H$29,0)+IF(Q$29=\"X\",'Data Validation'!$H$30,0)+IF(Q$30=\"X\",'Data Validation'!$H$31,0)+IF(Q$31=\"X\",'Data Validation'!$H$32,0)+IF(Q$32=\"X\",'Data Validation'!$H$33,0)+IF(Q$33=\"X\",'Data Validation'!$H$34,0)+IF(Q$34=\"X\",'Data Validation'!$H$35,0)+IF(Q$35=\"X\",'Data Validation'!$H$36,0)+IF(Q$36=\"X\",'Data Validation'!$H$37,0)+IF(Q$37=\"X\",'Data Validation'!$H$38,0)+IF(Q$38=\"X\",'Data Validation'!$H$39,0)+IF(Q$39=\"X\",'Data Validation'!$H$40,0)+IF(Q$40=\"X\",'Data Validation'!$H$41,0)+IF(Q$41=\"X\",'Data Validation'!$H$42,0)+IF(Q$42=\"X\",'Data Validation'!$H$43,0)+IF(Q$43=\"X\",'Data Validation'!$H$44,0)+IF(Q$44=\"X\",'Data Validation'!$H$45,0)+IF(Q$45=\"X\",'Data Validation'!$H$46,0)+IF(Q$46=\"X\",'Data Validation'!$H$47,0)+IF(Q$47=\"X\",'Data Validation'!$H$48,0) +IF(Q$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(R$4=\"X\",'Data Validation'!$H$5,0)+IF(R$5=\"X\",'Data Validation'!$H$6,0)+IF(R$6=\"X\",'Data Validation'!$H$7,0)+IF(R$7=\"X\",'Data Validation'!$H$8,0)+IF(R$8=\"X\",'Data Validation'!$H$9,0)+IF(R$9=\"X\",'Data Validation'!$H$10,0)+IF(R$10=\"X\",'Data Validation'!$H$11,0)+IF(R$11=\"X\",'Data Validation'!$H$12,0)+IF(R$12=\"X\",'Data Validation'!$H$13,0)+IF(R$13=\"X\",'Data Validation'!$H$14,0)+IF(R$14=\"X\",'Data Validation'!$H$15,0)+IF(R$15=\"X\",'Data Validation'!$H$16,0)+IF(R$16=\"X\",'Data Validation'!$H$17,0)+IF(R$17=\"X\",'Data Validation'!$H$18,0)+IF(R$18=\"X\",'Data Validation'!$H$19,0)+IF(R$19=\"X\",'Data Validation'!$H$20,0)+IF(R$20=\"X\",'Data Validation'!$H$21,0)+IF(R$21=\"X\",'Data Validation'!$H$22,0)+IF(R$22=\"X\",'Data Validation'!$H$23,0)+IF(R$23=\"X\",'Data Validation'!$H$24,0)+IF(R$24=\"X\",'Data Validation'!$H$25,0)+IF(R$25=\"X\",'Data Validation'!$H$26,0)+IF(R$26=\"X\",'Data Validation'!$H$27,0)+IF(R$27=\"X\",'Data Validation'!$H$28,0)+IF(R$28=\"X\",'Data Validation'!$H$29,0)+IF(R$29=\"X\",'Data Validation'!$H$30,0)+IF(R$30=\"X\",'Data Validation'!$H$31,0)+IF(R$31=\"X\",'Data Validation'!$H$32,0)+IF(R$32=\"X\",'Data Validation'!$H$33,0)+IF(R$33=\"X\",'Data Validation'!$H$34,0)+IF(R$34=\"X\",'Data Validation'!$H$35,0)+IF(R$35=\"X\",'Data Validation'!$H$36,0)+IF(R$36=\"X\",'Data Validation'!$H$37,0)+IF(R$37=\"X\",'Data Validation'!$H$38,0)+IF(R$38=\"X\",'Data Validation'!$H$39,0)+IF(R$39=\"X\",'Data Validation'!$H$40,0)+IF(R$40=\"X\",'Data Validation'!$H$41,0)+IF(R$41=\"X\",'Data Validation'!$H$42,0)+IF(R$42=\"X\",'Data Validation'!$H$43,0)+IF(R$43=\"X\",'Data Validation'!$H$44,0)+IF(R$44=\"X\",'Data Validation'!$H$45,0)+IF(R$45=\"X\",'Data Validation'!$H$46,0)+IF(R$46=\"X\",'Data Validation'!$H$47,0)+IF(R$47=\"X\",'Data Validation'!$H$48,0) +IF(R$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(S$4=\"X\",'Data Validation'!$H$5,0)+IF(S$5=\"X\",'Data Validation'!$H$6,0)+IF(S$6=\"X\",'Data Validation'!$H$7,0)+IF(S$7=\"X\",'Data Validation'!$H$8,0)+IF(S$8=\"X\",'Data Validation'!$H$9,0)+IF(S$9=\"X\",'Data Validation'!$H$10,0)+IF(S$10=\"X\",'Data Validation'!$H$11,0)+IF(S$11=\"X\",'Data Validation'!$H$12,0)+IF(S$12=\"X\",'Data Validation'!$H$13,0)+IF(S$13=\"X\",'Data Validation'!$H$14,0)+IF(S$14=\"X\",'Data Validation'!$H$15,0)+IF(S$15=\"X\",'Data Validation'!$H$16,0)+IF(S$16=\"X\",'Data Validation'!$H$17,0)+IF(S$17=\"X\",'Data Validation'!$H$18,0)+IF(S$18=\"X\",'Data Validation'!$H$19,0)+IF(S$19=\"X\",'Data Validation'!$H$20,0)+IF(S$20=\"X\",'Data Validation'!$H$21,0)+IF(S$21=\"X\",'Data Validation'!$H$22,0)+IF(S$22=\"X\",'Data Validation'!$H$23,0)+IF(S$23=\"X\",'Data Validation'!$H$24,0)+IF(S$24=\"X\",'Data Validation'!$H$25,0)+IF(S$25=\"X\",'Data Validation'!$H$26,0)+IF(S$26=\"X\",'Data Validation'!$H$27,0)+IF(S$27=\"X\",'Data Validation'!$H$28,0)+IF(S$28=\"X\",'Data Validation'!$H$29,0)+IF(S$29=\"X\",'Data Validation'!$H$30,0)+IF(S$30=\"X\",'Data Validation'!$H$31,0)+IF(S$31=\"X\",'Data Validation'!$H$32,0)+IF(S$32=\"X\",'Data Validation'!$H$33,0)+IF(S$33=\"X\",'Data Validation'!$H$34,0)+IF(S$34=\"X\",'Data Validation'!$H$35,0)+IF(S$35=\"X\",'Data Validation'!$H$36,0)+IF(S$36=\"X\",'Data Validation'!$H$37,0)+IF(S$37=\"X\",'Data Validation'!$H$38,0)+IF(S$38=\"X\",'Data Validation'!$H$39,0)+IF(S$39=\"X\",'Data Validation'!$H$40,0)+IF(S$40=\"X\",'Data Validation'!$H$41,0)+IF(S$41=\"X\",'Data Validation'!$H$42,0)+IF(S$42=\"X\",'Data Validation'!$H$43,0)+IF(S$43=\"X\",'Data Validation'!$H$44,0)+IF(S$44=\"X\",'Data Validation'!$H$45,0)+IF(S$45=\"X\",'Data Validation'!$H$46,0)+IF(S$46=\"X\",'Data Validation'!$H$47,0)+IF(S$47=\"X\",'Data Validation'!$H$48,0) +IF(S$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(T$4=\"X\",'Data Validation'!$H$5,0)+IF(T$5=\"X\",'Data Validation'!$H$6,0)+IF(T$6=\"X\",'Data Validation'!$H$7,0)+IF(T$7=\"X\",'Data Validation'!$H$8,0)+IF(T$8=\"X\",'Data Validation'!$H$9,0)+IF(T$9=\"X\",'Data Validation'!$H$10,0)+IF(T$10=\"X\",'Data Validation'!$H$11,0)+IF(T$11=\"X\",'Data Validation'!$H$12,0)+IF(T$12=\"X\",'Data Validation'!$H$13,0)+IF(T$13=\"X\",'Data Validation'!$H$14,0)+IF(T$14=\"X\",'Data Validation'!$H$15,0)+IF(T$15=\"X\",'Data Validation'!$H$16,0)+IF(T$16=\"X\",'Data Validation'!$H$17,0)+IF(T$17=\"X\",'Data Validation'!$H$18,0)+IF(T$18=\"X\",'Data Validation'!$H$19,0)+IF(T$19=\"X\",'Data Validation'!$H$20,0)+IF(T$20=\"X\",'Data Validation'!$H$21,0)+IF(T$21=\"X\",'Data Validation'!$H$22,0)+IF(T$22=\"X\",'Data Validation'!$H$23,0)+IF(T$23=\"X\",'Data Validation'!$H$24,0)+IF(T$24=\"X\",'Data Validation'!$H$25,0)+IF(T$25=\"X\",'Data Validation'!$H$26,0)+IF(T$26=\"X\",'Data Validation'!$H$27,0)+IF(T$27=\"X\",'Data Validation'!$H$28,0)+IF(T$28=\"X\",'Data Validation'!$H$29,0)+IF(T$29=\"X\",'Data Validation'!$H$30,0)+IF(T$30=\"X\",'Data Validation'!$H$31,0)+IF(T$31=\"X\",'Data Validation'!$H$32,0)+IF(T$32=\"X\",'Data Validation'!$H$33,0)+IF(T$33=\"X\",'Data Validation'!$H$34,0)+IF(T$34=\"X\",'Data Validation'!$H$35,0)+IF(T$35=\"X\",'Data Validation'!$H$36,0)+IF(T$36=\"X\",'Data Validation'!$H$37,0)+IF(T$37=\"X\",'Data Validation'!$H$38,0)+IF(T$38=\"X\",'Data Validation'!$H$39,0)+IF(T$39=\"X\",'Data Validation'!$H$40,0)+IF(T$40=\"X\",'Data Validation'!$H$41,0)+IF(T$41=\"X\",'Data Validation'!$H$42,0)+IF(T$42=\"X\",'Data Validation'!$H$43,0)+IF(T$43=\"X\",'Data Validation'!$H$44,0)+IF(T$44=\"X\",'Data Validation'!$H$45,0)+IF(T$45=\"X\",'Data Validation'!$H$46,0)+IF(T$46=\"X\",'Data Validation'!$H$47,0)+IF(T$47=\"X\",'Data Validation'!$H$48,0) +IF(T$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(U$4=\"X\",'Data Validation'!$H$5,0)+IF(U$5=\"X\",'Data Validation'!$H$6,0)+IF(U$6=\"X\",'Data Validation'!$H$7,0)+IF(U$7=\"X\",'Data Validation'!$H$8,0)+IF(U$8=\"X\",'Data Validation'!$H$9,0)+IF(U$9=\"X\",'Data Validation'!$H$10,0)+IF(U$10=\"X\",'Data Validation'!$H$11,0)+IF(U$11=\"X\",'Data Validation'!$H$12,0)+IF(U$12=\"X\",'Data Validation'!$H$13,0)+IF(U$13=\"X\",'Data Validation'!$H$14,0)+IF(U$14=\"X\",'Data Validation'!$H$15,0)+IF(U$15=\"X\",'Data Validation'!$H$16,0)+IF(U$16=\"X\",'Data Validation'!$H$17,0)+IF(U$17=\"X\",'Data Validation'!$H$18,0)+IF(U$18=\"X\",'Data Validation'!$H$19,0)+IF(U$19=\"X\",'Data Validation'!$H$20,0)+IF(U$20=\"X\",'Data Validation'!$H$21,0)+IF(U$21=\"X\",'Data Validation'!$H$22,0)+IF(U$22=\"X\",'Data Validation'!$H$23,0)+IF(U$23=\"X\",'Data Validation'!$H$24,0)+IF(U$24=\"X\",'Data Validation'!$H$25,0)+IF(U$25=\"X\",'Data Validation'!$H$26,0)+IF(U$26=\"X\",'Data Validation'!$H$27,0)+IF(U$27=\"X\",'Data Validation'!$H$28,0)+IF(U$28=\"X\",'Data Validation'!$H$29,0)+IF(U$29=\"X\",'Data Validation'!$H$30,0)+IF(U$30=\"X\",'Data Validation'!$H$31,0)+IF(U$31=\"X\",'Data Validation'!$H$32,0)+IF(U$32=\"X\",'Data Validation'!$H$33,0)+IF(U$33=\"X\",'Data Validation'!$H$34,0)+IF(U$34=\"X\",'Data Validation'!$H$35,0)+IF(U$35=\"X\",'Data Validation'!$H$36,0)+IF(U$36=\"X\",'Data Validation'!$H$37,0)+IF(U$37=\"X\",'Data Validation'!$H$38,0)+IF(U$38=\"X\",'Data Validation'!$H$39,0)+IF(U$39=\"X\",'Data Validation'!$H$40,0)+IF(U$40=\"X\",'Data Validation'!$H$41,0)+IF(U$41=\"X\",'Data Validation'!$H$42,0)+IF(U$42=\"X\",'Data Validation'!$H$43,0)+IF(U$43=\"X\",'Data Validation'!$H$44,0)+IF(U$44=\"X\",'Data Validation'!$H$45,0)+IF(U$45=\"X\",'Data Validation'!$H$46,0)+IF(U$46=\"X\",'Data Validation'!$H$47,0)+IF(U$47=\"X\",'Data Validation'!$H$48,0) +IF(U$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(V$4=\"X\",'Data Validation'!$H$5,0)+IF(V$5=\"X\",'Data Validation'!$H$6,0)+IF(V$6=\"X\",'Data Validation'!$H$7,0)+IF(V$7=\"X\",'Data Validation'!$H$8,0)+IF(V$8=\"X\",'Data Validation'!$H$9,0)+IF(V$9=\"X\",'Data Validation'!$H$10,0)+IF(V$10=\"X\",'Data Validation'!$H$11,0)+IF(V$11=\"X\",'Data Validation'!$H$12,0)+IF(V$12=\"X\",'Data Validation'!$H$13,0)+IF(V$13=\"X\",'Data Validation'!$H$14,0)+IF(V$14=\"X\",'Data Validation'!$H$15,0)+IF(V$15=\"X\",'Data Validation'!$H$16,0)+IF(V$16=\"X\",'Data Validation'!$H$17,0)+IF(V$17=\"X\",'Data Validation'!$H$18,0)+IF(V$18=\"X\",'Data Validation'!$H$19,0)+IF(V$19=\"X\",'Data Validation'!$H$20,0)+IF(V$20=\"X\",'Data Validation'!$H$21,0)+IF(V$21=\"X\",'Data Validation'!$H$22,0)+IF(V$22=\"X\",'Data Validation'!$H$23,0)+IF(V$23=\"X\",'Data Validation'!$H$24,0)+IF(V$24=\"X\",'Data Validation'!$H$25,0)+IF(V$25=\"X\",'Data Validation'!$H$26,0)+IF(V$26=\"X\",'Data Validation'!$H$27,0)+IF(V$27=\"X\",'Data Validation'!$H$28,0)+IF(V$28=\"X\",'Data Validation'!$H$29,0)+IF(V$29=\"X\",'Data Validation'!$H$30,0)+IF(V$30=\"X\",'Data Validation'!$H$31,0)+IF(V$31=\"X\",'Data Validation'!$H$32,0)+IF(V$32=\"X\",'Data Validation'!$H$33,0)+IF(V$33=\"X\",'Data Validation'!$H$34,0)+IF(V$34=\"X\",'Data Validation'!$H$35,0)+IF(V$35=\"X\",'Data Validation'!$H$36,0)+IF(V$36=\"X\",'Data Validation'!$H$37,0)+IF(V$37=\"X\",'Data Validation'!$H$38,0)+IF(V$38=\"X\",'Data Validation'!$H$39,0)+IF(V$39=\"X\",'Data Validation'!$H$40,0)+IF(V$40=\"X\",'Data Validation'!$H$41,0)+IF(V$41=\"X\",'Data Validation'!$H$42,0)+IF(V$42=\"X\",'Data Validation'!$H$43,0)+IF(V$43=\"X\",'Data Validation'!$H$44,0)+IF(V$44=\"X\",'Data Validation'!$H$45,0)+IF(V$45=\"X\",'Data Validation'!$H$46,0)+IF(V$46=\"X\",'Data Validation'!$H$47,0)+IF(V$47=\"X\",'Data Validation'!$H$48,0) +IF(V$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(W$4=\"X\",'Data Validation'!$H$5,0)+IF(W$5=\"X\",'Data Validation'!$H$6,0)+IF(W$6=\"X\",'Data Validation'!$H$7,0)+IF(W$7=\"X\",'Data Validation'!$H$8,0)+IF(W$8=\"X\",'Data Validation'!$H$9,0)+IF(W$9=\"X\",'Data Validation'!$H$10,0)+IF(W$10=\"X\",'Data Validation'!$H$11,0)+IF(W$11=\"X\",'Data Validation'!$H$12,0)+IF(W$12=\"X\",'Data Validation'!$H$13,0)+IF(W$13=\"X\",'Data Validation'!$H$14,0)+IF(W$14=\"X\",'Data Validation'!$H$15,0)+IF(W$15=\"X\",'Data Validation'!$H$16,0)+IF(W$16=\"X\",'Data Validation'!$H$17,0)+IF(W$17=\"X\",'Data Validation'!$H$18,0)+IF(W$18=\"X\",'Data Validation'!$H$19,0)+IF(W$19=\"X\",'Data Validation'!$H$20,0)+IF(W$20=\"X\",'Data Validation'!$H$21,0)+IF(W$21=\"X\",'Data Validation'!$H$22,0)+IF(W$22=\"X\",'Data Validation'!$H$23,0)+IF(W$23=\"X\",'Data Validation'!$H$24,0)+IF(W$24=\"X\",'Data Validation'!$H$25,0)+IF(W$25=\"X\",'Data Validation'!$H$26,0)+IF(W$26=\"X\",'Data Validation'!$H$27,0)+IF(W$27=\"X\",'Data Validation'!$H$28,0)+IF(W$28=\"X\",'Data Validation'!$H$29,0)+IF(W$29=\"X\",'Data Validation'!$H$30,0)+IF(W$30=\"X\",'Data Validation'!$H$31,0)+IF(W$31=\"X\",'Data Validation'!$H$32,0)+IF(W$32=\"X\",'Data Validation'!$H$33,0)+IF(W$33=\"X\",'Data Validation'!$H$34,0)+IF(W$34=\"X\",'Data Validation'!$H$35,0)+IF(W$35=\"X\",'Data Validation'!$H$36,0)+IF(W$36=\"X\",'Data Validation'!$H$37,0)+IF(W$37=\"X\",'Data Validation'!$H$38,0)+IF(W$38=\"X\",'Data Validation'!$H$39,0)+IF(W$39=\"X\",'Data Validation'!$H$40,0)+IF(W$40=\"X\",'Data Validation'!$H$41,0)+IF(W$41=\"X\",'Data Validation'!$H$42,0)+IF(W$42=\"X\",'Data Validation'!$H$43,0)+IF(W$43=\"X\",'Data Validation'!$H$44,0)+IF(W$44=\"X\",'Data Validation'!$H$45,0)+IF(W$45=\"X\",'Data Validation'!$H$46,0)+IF(W$46=\"X\",'Data Validation'!$H$47,0)+IF(W$47=\"X\",'Data Validation'!$H$48,0) +IF(W$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(X$4=\"X\",'Data Validation'!$H$5,0)+IF(X$5=\"X\",'Data Validation'!$H$6,0)+IF(X$6=\"X\",'Data Validation'!$H$7,0)+IF(X$7=\"X\",'Data Validation'!$H$8,0)+IF(X$8=\"X\",'Data Validation'!$H$9,0)+IF(X$9=\"X\",'Data Validation'!$H$10,0)+IF(X$10=\"X\",'Data Validation'!$H$11,0)+IF(X$11=\"X\",'Data Validation'!$H$12,0)+IF(X$12=\"X\",'Data Validation'!$H$13,0)+IF(X$13=\"X\",'Data Validation'!$H$14,0)+IF(X$14=\"X\",'Data Validation'!$H$15,0)+IF(X$15=\"X\",'Data Validation'!$H$16,0)+IF(X$16=\"X\",'Data Validation'!$H$17,0)+IF(X$17=\"X\",'Data Validation'!$H$18,0)+IF(X$18=\"X\",'Data Validation'!$H$19,0)+IF(X$19=\"X\",'Data Validation'!$H$20,0)+IF(X$20=\"X\",'Data Validation'!$H$21,0)+IF(X$21=\"X\",'Data Validation'!$H$22,0)+IF(X$22=\"X\",'Data Validation'!$H$23,0)+IF(X$23=\"X\",'Data Validation'!$H$24,0)+IF(X$24=\"X\",'Data Validation'!$H$25,0)+IF(X$25=\"X\",'Data Validation'!$H$26,0)+IF(X$26=\"X\",'Data Validation'!$H$27,0)+IF(X$27=\"X\",'Data Validation'!$H$28,0)+IF(X$28=\"X\",'Data Validation'!$H$29,0)+IF(X$29=\"X\",'Data Validation'!$H$30,0)+IF(X$30=\"X\",'Data Validation'!$H$31,0)+IF(X$31=\"X\",'Data Validation'!$H$32,0)+IF(X$32=\"X\",'Data Validation'!$H$33,0)+IF(X$33=\"X\",'Data Validation'!$H$34,0)+IF(X$34=\"X\",'Data Validation'!$H$35,0)+IF(X$35=\"X\",'Data Validation'!$H$36,0)+IF(X$36=\"X\",'Data Validation'!$H$37,0)+IF(X$37=\"X\",'Data Validation'!$H$38,0)+IF(X$38=\"X\",'Data Validation'!$H$39,0)+IF(X$39=\"X\",'Data Validation'!$H$40,0)+IF(X$40=\"X\",'Data Validation'!$H$41,0)+IF(X$41=\"X\",'Data Validation'!$H$42,0)+IF(X$42=\"X\",'Data Validation'!$H$43,0)+IF(X$43=\"X\",'Data Validation'!$H$44,0)+IF(X$44=\"X\",'Data Validation'!$H$45,0)+IF(X$45=\"X\",'Data Validation'!$H$46,0)+IF(X$46=\"X\",'Data Validation'!$H$47,0)+IF(X$47=\"X\",'Data Validation'!$H$48,0) +IF(X$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(Y$4=\"X\",'Data Validation'!$H$5,0)+IF(Y$5=\"X\",'Data Validation'!$H$6,0)+IF(Y$6=\"X\",'Data Validation'!$H$7,0)+IF(Y$7=\"X\",'Data Validation'!$H$8,0)+IF(Y$8=\"X\",'Data Validation'!$H$9,0)+IF(Y$9=\"X\",'Data Validation'!$H$10,0)+IF(Y$10=\"X\",'Data Validation'!$H$11,0)+IF(Y$11=\"X\",'Data Validation'!$H$12,0)+IF(Y$12=\"X\",'Data Validation'!$H$13,0)+IF(Y$13=\"X\",'Data Validation'!$H$14,0)+IF(Y$14=\"X\",'Data Validation'!$H$15,0)+IF(Y$15=\"X\",'Data Validation'!$H$16,0)+IF(Y$16=\"X\",'Data Validation'!$H$17,0)+IF(Y$17=\"X\",'Data Validation'!$H$18,0)+IF(Y$18=\"X\",'Data Validation'!$H$19,0)+IF(Y$19=\"X\",'Data Validation'!$H$20,0)+IF(Y$20=\"X\",'Data Validation'!$H$21,0)+IF(Y$21=\"X\",'Data Validation'!$H$22,0)+IF(Y$22=\"X\",'Data Validation'!$H$23,0)+IF(Y$23=\"X\",'Data Validation'!$H$24,0)+IF(Y$24=\"X\",'Data Validation'!$H$25,0)+IF(Y$25=\"X\",'Data Validation'!$H$26,0)+IF(Y$26=\"X\",'Data Validation'!$H$27,0)+IF(Y$27=\"X\",'Data Validation'!$H$28,0)+IF(Y$28=\"X\",'Data Validation'!$H$29,0)+IF(Y$29=\"X\",'Data Validation'!$H$30,0)+IF(Y$30=\"X\",'Data Validation'!$H$31,0)+IF(Y$31=\"X\",'Data Validation'!$H$32,0)+IF(Y$32=\"X\",'Data Validation'!$H$33,0)+IF(Y$33=\"X\",'Data Validation'!$H$34,0)+IF(Y$34=\"X\",'Data Validation'!$H$35,0)+IF(Y$35=\"X\",'Data Validation'!$H$36,0)+IF(Y$36=\"X\",'Data Validation'!$H$37,0)+IF(Y$37=\"X\",'Data Validation'!$H$38,0)+IF(Y$38=\"X\",'Data Validation'!$H$39,0)+IF(Y$39=\"X\",'Data Validation'!$H$40,0)+IF(Y$40=\"X\",'Data Validation'!$H$41,0)+IF(Y$41=\"X\",'Data Validation'!$H$42,0)+IF(Y$42=\"X\",'Data Validation'!$H$43,0)+IF(Y$43=\"X\",'Data Validation'!$H$44,0)+IF(Y$44=\"X\",'Data Validation'!$H$45,0)+IF(Y$45=\"X\",'Data Validation'!$H$46,0)+IF(Y$46=\"X\",'Data Validation'!$H$47,0)+IF(Y$47=\"X\",'Data Validation'!$H$48,0) +IF(Y$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(Z$4=\"X\",'Data Validation'!$H$5,0)+IF(Z$5=\"X\",'Data Validation'!$H$6,0)+IF(Z$6=\"X\",'Data Validation'!$H$7,0)+IF(Z$7=\"X\",'Data Validation'!$H$8,0)+IF(Z$8=\"X\",'Data Validation'!$H$9,0)+IF(Z$9=\"X\",'Data Validation'!$H$10,0)+IF(Z$10=\"X\",'Data Validation'!$H$11,0)+IF(Z$11=\"X\",'Data Validation'!$H$12,0)+IF(Z$12=\"X\",'Data Validation'!$H$13,0)+IF(Z$13=\"X\",'Data Validation'!$H$14,0)+IF(Z$14=\"X\",'Data Validation'!$H$15,0)+IF(Z$15=\"X\",'Data Validation'!$H$16,0)+IF(Z$16=\"X\",'Data Validation'!$H$17,0)+IF(Z$17=\"X\",'Data Validation'!$H$18,0)+IF(Z$18=\"X\",'Data Validation'!$H$19,0)+IF(Z$19=\"X\",'Data Validation'!$H$20,0)+IF(Z$20=\"X\",'Data Validation'!$H$21,0)+IF(Z$21=\"X\",'Data Validation'!$H$22,0)+IF(Z$22=\"X\",'Data Validation'!$H$23,0)+IF(Z$23=\"X\",'Data Validation'!$H$24,0)+IF(Z$24=\"X\",'Data Validation'!$H$25,0)+IF(Z$25=\"X\",'Data Validation'!$H$26,0)+IF(Z$26=\"X\",'Data Validation'!$H$27,0)+IF(Z$27=\"X\",'Data Validation'!$H$28,0)+IF(Z$28=\"X\",'Data Validation'!$H$29,0)+IF(Z$29=\"X\",'Data Validation'!$H$30,0)+IF(Z$30=\"X\",'Data Validation'!$H$31,0)+IF(Z$31=\"X\",'Data Validation'!$H$32,0)+IF(Z$32=\"X\",'Data Validation'!$H$33,0)+IF(Z$33=\"X\",'Data Validation'!$H$34,0)+IF(Z$34=\"X\",'Data Validation'!$H$35,0)+IF(Z$35=\"X\",'Data Validation'!$H$36,0)+IF(Z$36=\"X\",'Data Validation'!$H$37,0)+IF(Z$37=\"X\",'Data Validation'!$H$38,0)+IF(Z$38=\"X\",'Data Validation'!$H$39,0)+IF(Z$39=\"X\",'Data Validation'!$H$40,0)+IF(Z$40=\"X\",'Data Validation'!$H$41,0)+IF(Z$41=\"X\",'Data Validation'!$H$42,0)+IF(Z$42=\"X\",'Data Validation'!$H$43,0)+IF(Z$43=\"X\",'Data Validation'!$H$44,0)+IF(Z$44=\"X\",'Data Validation'!$H$45,0)+IF(Z$45=\"X\",'Data Validation'!$H$46,0)+IF(Z$46=\"X\",'Data Validation'!$H$47,0)+IF(Z$47=\"X\",'Data Validation'!$H$48,0) +IF(Z$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(AA$4=\"X\",'Data Validation'!$H$5,0)+IF(AA$5=\"X\",'Data Validation'!$H$6,0)+IF(AA$6=\"X\",'Data Validation'!$H$7,0)+IF(AA$7=\"X\",'Data Validation'!$H$8,0)+IF(AA$8=\"X\",'Data Validation'!$H$9,0)+IF(AA$9=\"X\",'Data Validation'!$H$10,0)+IF(AA$10=\"X\",'Data Validation'!$H$11,0)+IF(AA$11=\"X\",'Data Validation'!$H$12,0)+IF(AA$12=\"X\",'Data Validation'!$H$13,0)+IF(AA$13=\"X\",'Data Validation'!$H$14,0)+IF(AA$14=\"X\",'Data Validation'!$H$15,0)+IF(AA$15=\"X\",'Data Validation'!$H$16,0)+IF(AA$16=\"X\",'Data Validation'!$H$17,0)+IF(AA$17=\"X\",'Data Validation'!$H$18,0)+IF(AA$18=\"X\",'Data Validation'!$H$19,0)+IF(AA$19=\"X\",'Data Validation'!$H$20,0)+IF(AA$20=\"X\",'Data Validation'!$H$21,0)+IF(AA$21=\"X\",'Data Validation'!$H$22,0)+IF(AA$22=\"X\",'Data Validation'!$H$23,0)+IF(AA$23=\"X\",'Data Validation'!$H$24,0)+IF(AA$24=\"X\",'Data Validation'!$H$25,0)+IF(AA$25=\"X\",'Data Validation'!$H$26,0)+IF(AA$26=\"X\",'Data Validation'!$H$27,0)+IF(AA$27=\"X\",'Data Validation'!$H$28,0)+IF(AA$28=\"X\",'Data Validation'!$H$29,0)+IF(AA$29=\"X\",'Data Validation'!$H$30,0)+IF(AA$30=\"X\",'Data Validation'!$H$31,0)+IF(AA$31=\"X\",'Data Validation'!$H$32,0)+IF(AA$32=\"X\",'Data Validation'!$H$33,0)+IF(AA$33=\"X\",'Data Validation'!$H$34,0)+IF(AA$34=\"X\",'Data Validation'!$H$35,0)+IF(AA$35=\"X\",'Data Validation'!$H$36,0)+IF(AA$36=\"X\",'Data Validation'!$H$37,0)+IF(AA$37=\"X\",'Data Validation'!$H$38,0)+IF(AA$38=\"X\",'Data Validation'!$H$39,0)+IF(AA$39=\"X\",'Data Validation'!$H$40,0)+IF(AA$40=\"X\",'Data Validation'!$H$41,0)+IF(AA$41=\"X\",'Data Validation'!$H$42,0)+IF(AA$42=\"X\",'Data Validation'!$H$43,0)+IF(AA$43=\"X\",'Data Validation'!$H$44,0)+IF(AA$44=\"X\",'Data Validation'!$H$45,0)+IF(AA$45=\"X\",'Data Validation'!$H$46,0)+IF(AA$46=\"X\",'Data Validation'!$H$47,0)+IF(AA$47=\"X\",'Data Validation'!$H$48,0) +IF(AA$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(AB$4=\"X\",'Data Validation'!$H$5,0)+IF(AB$5=\"X\",'Data Validation'!$H$6,0)+IF(AB$6=\"X\",'Data Validation'!$H$7,0)+IF(AB$7=\"X\",'Data Validation'!$H$8,0)+IF(AB$8=\"X\",'Data Validation'!$H$9,0)+IF(AB$9=\"X\",'Data Validation'!$H$10,0)+IF(AB$10=\"X\",'Data Validation'!$H$11,0)+IF(AB$11=\"X\",'Data Validation'!$H$12,0)+IF(AB$12=\"X\",'Data Validation'!$H$13,0)+IF(AB$13=\"X\",'Data Validation'!$H$14,0)+IF(AB$14=\"X\",'Data Validation'!$H$15,0)+IF(AB$15=\"X\",'Data Validation'!$H$16,0)+IF(AB$16=\"X\",'Data Validation'!$H$17,0)+IF(AB$17=\"X\",'Data Validation'!$H$18,0)+IF(AB$18=\"X\",'Data Validation'!$H$19,0)+IF(AB$19=\"X\",'Data Validation'!$H$20,0)+IF(AB$20=\"X\",'Data Validation'!$H$21,0)+IF(AB$21=\"X\",'Data Validation'!$H$22,0)+IF(AB$22=\"X\",'Data Validation'!$H$23,0)+IF(AB$23=\"X\",'Data Validation'!$H$24,0)+IF(AB$24=\"X\",'Data Validation'!$H$25,0)+IF(AB$25=\"X\",'Data Validation'!$H$26,0)+IF(AB$26=\"X\",'Data Validation'!$H$27,0)+IF(AB$27=\"X\",'Data Validation'!$H$28,0)+IF(AB$28=\"X\",'Data Validation'!$H$29,0)+IF(AB$29=\"X\",'Data Validation'!$H$30,0)+IF(AB$30=\"X\",'Data Validation'!$H$31,0)+IF(AB$31=\"X\",'Data Validation'!$H$32,0)+IF(AB$32=\"X\",'Data Validation'!$H$33,0)+IF(AB$33=\"X\",'Data Validation'!$H$34,0)+IF(AB$34=\"X\",'Data Validation'!$H$35,0)+IF(AB$35=\"X\",'Data Validation'!$H$36,0)+IF(AB$36=\"X\",'Data Validation'!$H$37,0)+IF(AB$37=\"X\",'Data Validation'!$H$38,0)+IF(AB$38=\"X\",'Data Validation'!$H$39,0)+IF(AB$39=\"X\",'Data Validation'!$H$40,0)+IF(AB$40=\"X\",'Data Validation'!$H$41,0)+IF(AB$41=\"X\",'Data Validation'!$H$42,0)+IF(AB$42=\"X\",'Data Validation'!$H$43,0)+IF(AB$43=\"X\",'Data Validation'!$H$44,0)+IF(AB$44=\"X\",'Data Validation'!$H$45,0)+IF(AB$45=\"X\",'Data Validation'!$H$46,0)+IF(AB$46=\"X\",'Data Validation'!$H$47,0)+IF(AB$47=\"X\",'Data Validation'!$H$48,0) +IF(AB$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(AC$4=\"X\",'Data Validation'!$H$5,0)+IF(AC$5=\"X\",'Data Validation'!$H$6,0)+IF(AC$6=\"X\",'Data Validation'!$H$7,0)+IF(AC$7=\"X\",'Data Validation'!$H$8,0)+IF(AC$8=\"X\",'Data Validation'!$H$9,0)+IF(AC$9=\"X\",'Data Validation'!$H$10,0)+IF(AC$10=\"X\",'Data Validation'!$H$11,0)+IF(AC$11=\"X\",'Data Validation'!$H$12,0)+IF(AC$12=\"X\",'Data Validation'!$H$13,0)+IF(AC$13=\"X\",'Data Validation'!$H$14,0)+IF(AC$14=\"X\",'Data Validation'!$H$15,0)+IF(AC$15=\"X\",'Data Validation'!$H$16,0)+IF(AC$16=\"X\",'Data Validation'!$H$17,0)+IF(AC$17=\"X\",'Data Validation'!$H$18,0)+IF(AC$18=\"X\",'Data Validation'!$H$19,0)+IF(AC$19=\"X\",'Data Validation'!$H$20,0)+IF(AC$20=\"X\",'Data Validation'!$H$21,0)+IF(AC$21=\"X\",'Data Validation'!$H$22,0)+IF(AC$22=\"X\",'Data Validation'!$H$23,0)+IF(AC$23=\"X\",'Data Validation'!$H$24,0)+IF(AC$24=\"X\",'Data Validation'!$H$25,0)+IF(AC$25=\"X\",'Data Validation'!$H$26,0)+IF(AC$26=\"X\",'Data Validation'!$H$27,0)+IF(AC$27=\"X\",'Data Validation'!$H$28,0)+IF(AC$28=\"X\",'Data Validation'!$H$29,0)+IF(AC$29=\"X\",'Data Validation'!$H$30,0)+IF(AC$30=\"X\",'Data Validation'!$H$31,0)+IF(AC$31=\"X\",'Data Validation'!$H$32,0)+IF(AC$32=\"X\",'Data Validation'!$H$33,0)+IF(AC$33=\"X\",'Data Validation'!$H$34,0)+IF(AC$34=\"X\",'Data Validation'!$H$35,0)+IF(AC$35=\"X\",'Data Validation'!$H$36,0)+IF(AC$36=\"X\",'Data Validation'!$H$37,0)+IF(AC$37=\"X\",'Data Validation'!$H$38,0)+IF(AC$38=\"X\",'Data Validation'!$H$39,0)+IF(AC$39=\"X\",'Data Validation'!$H$40,0)+IF(AC$40=\"X\",'Data Validation'!$H$41,0)+IF(AC$41=\"X\",'Data Validation'!$H$42,0)+IF(AC$42=\"X\",'Data Validation'!$H$43,0)+IF(AC$43=\"X\",'Data Validation'!$H$44,0)+IF(AC$44=\"X\",'Data Validation'!$H$45,0)+IF(AC$45=\"X\",'Data Validation'!$H$46,0)+IF(AC$46=\"X\",'Data Validation'!$H$47,0)+IF(AC$47=\"X\",'Data Validation'!$H$48,0) +IF(AC$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(AD$4=\"X\",'Data Validation'!$H$5,0)+IF(AD$5=\"X\",'Data Validation'!$H$6,0)+IF(AD$6=\"X\",'Data Validation'!$H$7,0)+IF(AD$7=\"X\",'Data Validation'!$H$8,0)+IF(AD$8=\"X\",'Data Validation'!$H$9,0)+IF(AD$9=\"X\",'Data Validation'!$H$10,0)+IF(AD$10=\"X\",'Data Validation'!$H$11,0)+IF(AD$11=\"X\",'Data Validation'!$H$12,0)+IF(AD$12=\"X\",'Data Validation'!$H$13,0)+IF(AD$13=\"X\",'Data Validation'!$H$14,0)+IF(AD$14=\"X\",'Data Validation'!$H$15,0)+IF(AD$15=\"X\",'Data Validation'!$H$16,0)+IF(AD$16=\"X\",'Data Validation'!$H$17,0)+IF(AD$17=\"X\",'Data Validation'!$H$18,0)+IF(AD$18=\"X\",'Data Validation'!$H$19,0)+IF(AD$19=\"X\",'Data Validation'!$H$20,0)+IF(AD$20=\"X\",'Data Validation'!$H$21,0)+IF(AD$21=\"X\",'Data Validation'!$H$22,0)+IF(AD$22=\"X\",'Data Validation'!$H$23,0)+IF(AD$23=\"X\",'Data Validation'!$H$24,0)+IF(AD$24=\"X\",'Data Validation'!$H$25,0)+IF(AD$25=\"X\",'Data Validation'!$H$26,0)+IF(AD$26=\"X\",'Data Validation'!$H$27,0)+IF(AD$27=\"X\",'Data Validation'!$H$28,0)+IF(AD$28=\"X\",'Data Validation'!$H$29,0)+IF(AD$29=\"X\",'Data Validation'!$H$30,0)+IF(AD$30=\"X\",'Data Validation'!$H$31,0)+IF(AD$31=\"X\",'Data Validation'!$H$32,0)+IF(AD$32=\"X\",'Data Validation'!$H$33,0)+IF(AD$33=\"X\",'Data Validation'!$H$34,0)+IF(AD$34=\"X\",'Data Validation'!$H$35,0)+IF(AD$35=\"X\",'Data Validation'!$H$36,0)+IF(AD$36=\"X\",'Data Validation'!$H$37,0)+IF(AD$37=\"X\",'Data Validation'!$H$38,0)+IF(AD$38=\"X\",'Data Validation'!$H$39,0)+IF(AD$39=\"X\",'Data Validation'!$H$40,0)+IF(AD$40=\"X\",'Data Validation'!$H$41,0)+IF(AD$41=\"X\",'Data Validation'!$H$42,0)+IF(AD$42=\"X\",'Data Validation'!$H$43,0)+IF(AD$43=\"X\",'Data Validation'!$H$44,0)+IF(AD$44=\"X\",'Data Validation'!$H$45,0)+IF(AD$45=\"X\",'Data Validation'!$H$46,0)+IF(AD$46=\"X\",'Data Validation'!$H$47,0)+IF(AD$47=\"X\",'Data Validation'!$H$48,0) +IF(AD$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"(IF(AE$4=\"X\",'Data Validation'!$H$5,0)+IF(AE$5=\"X\",'Data Validation'!$H$6,0)+IF(AE$6=\"X\",'Data Validation'!$H$7,0)+IF(AE$7=\"X\",'Data Validation'!$H$8,0)+IF(AE$8=\"X\",'Data Validation'!$H$9,0)+IF(AE$9=\"X\",'Data Validation'!$H$10,0)+IF(AE$10=\"X\",'Data Validation'!$H$11,0)+IF(AE$11=\"X\",'Data Validation'!$H$12,0)+IF(AE$12=\"X\",'Data Validation'!$H$13,0)+IF(AE$13=\"X\",'Data Validation'!$H$14,0)+IF(AE$14=\"X\",'Data Validation'!$H$15,0)+IF(AE$15=\"X\",'Data Validation'!$H$16,0)+IF(AE$16=\"X\",'Data Validation'!$H$17,0)+IF(AE$17=\"X\",'Data Validation'!$H$18,0)+IF(AE$18=\"X\",'Data Validation'!$H$19,0)+IF(AE$19=\"X\",'Data Validation'!$H$20,0)+IF(AE$20=\"X\",'Data Validation'!$H$21,0)+IF(AE$21=\"X\",'Data Validation'!$H$22,0)+IF(AE$22=\"X\",'Data Validation'!$H$23,0)+IF(AE$23=\"X\",'Data Validation'!$H$24,0)+IF(AE$24=\"X\",'Data Validation'!$H$25,0)+IF(AE$25=\"X\",'Data Validation'!$H$26,0)+IF(AE$26=\"X\",'Data Validation'!$H$27,0)+IF(AE$27=\"X\",'Data Validation'!$H$28,0)+IF(AE$28=\"X\",'Data Validation'!$H$29,0)+IF(AE$29=\"X\",'Data Validation'!$H$30,0)+IF(AE$30=\"X\",'Data Validation'!$H$31,0)+IF(AE$31=\"X\",'Data Validation'!$H$32,0)+IF(AE$32=\"X\",'Data Validation'!$H$33,0)+IF(AE$33=\"X\",'Data Validation'!$H$34,0)+IF(AE$34=\"X\",'Data Validation'!$H$35,0)+IF(AE$35=\"X\",'Data Validation'!$H$36,0)+IF(AE$36=\"X\",'Data Validation'!$H$37,0)+IF(AE$37=\"X\",'Data Validation'!$H$38,0)+IF(AE$38=\"X\",'Data Validation'!$H$39,0)+IF(AE$39=\"X\",'Data Validation'!$H$40,0)+IF(AE$40=\"X\",'Data Validation'!$H$41,0)+IF(AE$41=\"X\",'Data Validation'!$H$42,0)+IF(AE$42=\"X\",'Data Validation'!$H$43,0)+IF(AE$43=\"X\",'Data Validation'!$H$44,0)+IF(AE$44=\"X\",'Data Validation'!$H$45,0)+IF(AE$45=\"X\",'Data Validation'!$H$46,0)+IF(AE$46=\"X\",'Data Validation'!$H$47,0)+IF(AE$47=\"X\",'Data Validation'!$H$48,0) +IF(AE$48=\"X\",'Data Validation'!$H$49,0))","v":0},{"$f":"SUM(AF4:AF48)","v":0}]
[]
[]
[null,null,null,null,null,"Personnel","Non-Procedures","Visit 1","Visit 2","Visit 3","Visit 4","Visit 5","Visit 6","Visit 7","Visit 8","Visit 9","Visit 10","Visit 11","Visit 12","Visit 13","Visit 14","Visit 15","Visit 16","Visit 17","Visit 18","Visit 19","Visit 20","Visit 21","Visit 22","Visit 23","Visit 24","TOTAL"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #1]",{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$54))","v":"$0"},{"$f":"(IF($F$53=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$53,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$54))","v":"$0"},{"$f":"SUMIF(H53:AE53, \">0\")","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #2]",{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$56))","v":"$0"},{"$f":"(IF($F$55=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$55,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$56))","v":"$0"},{"$f":"SUMIF(H55:AE55, \">0\")","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #3]",{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$58))","v":"$0"},{"$f":"(IF($F$57=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$57,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$58))","v":"$0"},{"$f":"SUMIF(H57:AE57, \">0\")","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #4]",{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$60))","v":"$0"},{"$f":"(IF($F$59=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$59,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$60))","v":"$0"},{"$f":"SUMIF(H59:AE59, \">0\")","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #5]",{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$62))","v":"$0"},{"$f":"(IF($F$61=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$61,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$62))","v":"$0"},{"$f":"SUMIF(H61:AE61, \">0\")","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #6]",{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$64))","v":"$0"},{"$f":"(IF($F$63=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$63,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$64))","v":"$0"},{"$f":"SUMIF(H63:AE63, \">0\")","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #7]",{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$66))","v":"$0"},{"$f":"(IF($F$65=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$65,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$66))","v":"$0"},{"$f":"SUMIF(H65:AE65, \">0\")","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #8]",{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$68))","v":"$0"},{"$f":"(IF($F$67=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$67,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$68))","v":"$0"},{"$f":"SUMIF(H67:AE67, \">0\")","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #9]",{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$70))","v":"$0"},{"$f":"(IF($F$69=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$69,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$70))","v":"$0"},{"$f":"SUMIF(H69:AE69, \">0\")","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #10]",{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$72))","v":"$0"},{"$f":"(IF($F$71=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$71,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$72))","v":"$0"},{"$f":"SUMIF(H71:AE71, \">0\")","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #11]",{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$74))","v":"$0"},{"$f":"(IF($F$73=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$73,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$74))","v":"$0"},{"$f":"SUMIF(H73:AE73, \">0\")","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #12]",{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$76))","v":"$0"},{"$f":"(IF($F$75=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$75,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$76))","v":"$0"},{"$f":"SUMIF(H75:AE75, \">0\")","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #13]",{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$78))","v":"$0"},{"$f":"(IF($F$77=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$77,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$78))","v":"$0"},{"$f":"SUMIF(H77:AE77, \">0\")","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #14]",{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$80))","v":"$0"},{"$f":"(IF($F$79=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$79,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$80))","v":"$0"},{"$f":"SUM(H79:AE79)","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #15]",{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$82))","v":"$0"},{"$f":"(IF($F$81=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$81,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$82))","v":"$0"},{"$f":"SUM(H81:AE81)","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #16]",{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$84))","v":"$0"},{"$f":"(IF($F$83=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$83,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$84))","v":"$0"},{"$f":"SUM(H83:AE83)","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #17]",{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$86))","v":"$0"},{"$f":"(IF($F$85=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$85,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$86))","v":"$0"},{"$f":"SUM(H85:AE85)","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #18]",{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$88))","v":"$0"},{"$f":"(IF($F$87=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$87,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$88))","v":"$0"},{"$f":"SUM(H87:AE87)","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #19]",{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$90))","v":"$0"},{"$f":"(IF($F$89=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$89,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$90))","v":"$0"},{"$f":"SUM(H89:AE89)","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #20]",{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$92))","v":"$0"},{"$f":"(IF($F$91=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$91,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$92))","v":"$0"},{"$f":"SUM(H91:AE91)","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #21]",{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$94))","v":"$0"},{"$f":"(IF($F$93=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$93,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$94))","v":"$0"},{"$f":"SUM(H93:AE93)","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #22]",{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$96))","v":"$0"},{"$f":"(IF($F$95=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$95,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$96))","v":"$0"},{"$f":"SUM(H95:AE95)","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #23]",{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$98))","v":"$0"},{"$f":"(IF($F$97=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$97,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$98))","v":"$0"},{"$f":"SUM(H97:AE97)","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"[INSERT OTHER NON-PROCEDURE #24]",{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*H$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*I$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*J$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*K$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*L$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*M$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*N$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*O$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*P$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Q$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*R$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*S$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*T$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*U$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*V$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*W$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*X$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Y$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*Z$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AA$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AB$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AC$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AD$100))","v":"$0"},{"$f":"(IF($F$99=\"\",\"$0\",(IFERROR(VLOOKUP('Patient Costs'!$F$99,'Data Validation'!$A$5:$B$22,2,FALSE),\"\"))*AE$100))","v":"$0"},{"$f":"SUM(H99:AE99)","v":0}]
[null,null,null,null,null,null,"Frequency (hours)"]
[null,null,null,null,null,null,"Subtotal Per Pt Non-Procedure Costs",{"$f":"H$53+H$55+H$57+H$59+H$61+H$63+H$65+H$67+H$69+H$71+H$73+H$75+H$77+H$79+H$81+H$83+H$85+H$87+H$89+H$91+H$93+H$95+H$97+H$99","v":0},{"$f":"I$53+I$55+I$57+I$59+I$61+I$63+I$65+I$67+I$69+I$71+I$73+I$75+I$77+I$79+I$81+I$83+I$85+I$87+I$89+I$91+I$93+I$95+I$97+I$99","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AF53:AF99)","v":0}]
[]
[null,null,null,null,null,null,"Institutional Overhead",{"$f":"IF($E$4=\"\",0,((H$49+H$101)*$E$4))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(E4=\"\",0,((AF49+AF101)*E4))","v":0}]
[]
[null,null,null,null,null,null,"Total Per Visit Cost",{"$f":"H49+H101+H103","v":0},{"$f":"I49+I101+I103","v":0},{"$f":"J49+J101+J103","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,"TOTAL PER PATIENT COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF49+AF101+AF103","v":0}]

{"sheet":"Data Validation","index":5,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,6,0,9],[0,0,0,1]]}
["*Does not include institutional overhead",null,null,null,null,null,"Use the link below to search for the research cost and UPG fee for any CPT code"]
[null,null,null,null,null,null,"https://apps.med.virginia.edu/gpr?wfguid=3A1F9E45-47C3-4CDB-8D76-650F6E4BCEC3 ",null,null,null,null,null," *Feeds into \"Patient Costs\" tab"]
[]
["Personnel","Hourly Rate",null,"Study Management Costs","Cost",null,"Procedure","Negotiated Price*","Research Cost","UPG Fee","Sponsor Rate","Variance"]
["Principal Investigator I",0,null,"Annual Maintenance Fee",0,null,"[INSERT PROCEDURE #1]",0,0,0,0,{"$f":"($I5+$J5)-$K5","v":0}]
["Principal Investigator II",0,null,"Annual Pharmacy Maintenance Fee",0,null,"[INSERT PROCEDURE #2]",0,0,0,0,{"$f":"($I6+$J6)-$K6","v":0}]
["Principal Investigator III",0,null,"Study Close Out Fee",0,null,"[INSERT PROCEDURE #3]",0,0,0,0,0]
["Principal Investigator IV",0,null,"Pharmacy Close Out Fee",0,null,"[INSERT PROCEDURE #4]",0,0,0,0,0]
["Principal Investigator V",0,null,"IRB Annual Renewal Fee - Doc Prep Fee",0,null,"[INSERT PROCEDURE #5]",0,0,0,0,0]
["CRC I",0,null,"Protocol Amendment Fee - Doc Prep Fee",0,null,"[INSERT PROCEDURE #6]",0,0,0,0,0]
["CRC II",0,null,"Document Storage (Record Retention)",0,null,"[INSERT PROCEDURE #7]",0,0,0,0,0]
["CRC III",0,null,"IND Safety Report (ea)",0,null,"[INSERT PROCEDURE #8]",0,0,0,0,0]
["Admin Asst",0,null,"Serious Adverse Event",0,null,"[INSERT PROCEDURE #9]",0,0,0,0,0]
["[INSERT PERSONNEL #1]",0,null,"Hotel",0,null,"[INSERT PROCEDURE #10]",0,0,0,0,0]
["[INSERT PERSONNEL #2]",0,null,"Conference Calls",0,null,"[INSERT PROCEDURE #10]",0,0,0,0,0]
["[INSERT PERSONNEL #3]",0,null,"Initiation Visit",0,null,"[INSERT PROCEDURE #12]",0,0,0,0,0]
["[INSERT PERSONNEL #4]",0,null,"Interim Monitoring Visits",0,null,"[INSERT PROCEDURE #13]",0,0,0,0,0]
["[INSERT PERSONNEL #5]",0,null,"Shipping",0,null,"[INSERT PROCEDURE #14]",0,0,0,0,0]
["[INSERT PERSONNEL #6]",0,null,"Mileage",0,null,"[INSERT PROCEDURE #15]",0,0,0,0,0]
["[INSERT PERSONNEL #7]",0,null,"Stipend/Subject Reimbursement",0,null,"[INSERT PROCEDURE #16]",0,0,0,0,0]
["[INSERT PERSONNEL #8]",0,null,"[OTHER STUDY MGMT COSTS #1]",0,null,"[INSERT PROCEDURE #17]",0,0,0,0,0]
["[INSERT PERSONNEL #9]",0,null,"[OTHER STUDY MGMT COSTS #2]",0,null,"[INSERT PROCEDURE #18]",0,0,0,0,0]
["[INSERT PERSONNEL #10]",0,null,"[OTHER STUDY MGMT COSTS #3]",0,null,"[INSERT PROCEDURE #19]",0,0,0,0,0]
[null,null,null,"[OTHER STUDY MGMT COSTS #4]",0,null,"[INSERT PROCEDURE #20]",0,0,0,0,0]
[null,null,null,"[OTHER STUDY MGMT COSTS #5]",0,null,"[INSERT PROCEDURE #21]",0,0,0,0,0]
["Startup Costs - Other Costs","Cost",null,"[OTHER STUDY MGMT COSTS #6]",0,null,"[INSERT PROCEDURE #22]",0,0,0,0,0]
["IRB Fee",0,null,"[OTHER STUDY MGMT COSTS #7]",0,null,"[INSERT PROCEDURE #23]",0,0,0,0,0]
["Pharmacy Startup Fees",0,null,"[OTHER STUDY MGMT COSTS #8]",0,null,"[INSERT PROCEDURE #24]",0,0,0,0,0]
["Other Institutional Fees",0,null,"[OTHER STUDY MGMT COSTS #9]",0,null,"[INSERT PROCEDURE #25]",0,0,0,0,0]
["Office Supplies",0,null,"[OTHER STUDY MGMT COSTS #10]",0,null,"[INSERT PROCEDURE #26]",0,0,0,0,0]
["General Supplies",0,null,"[OTHER STUDY MGMT COSTS #11]",0,null,"[INSERT PROCEDURE #27]",0,0,0,0,0]
["Recruitment Materials",0,null,"[OTHER STUDY MGMT COSTS #12]",0,null,"[INSERT PROCEDURE #28]",0,0,0,0,0]
["[OTHER STARTUP COSTS #1]",0,null,"[OTHER STUDY MGMT COSTS #13]",0,null,"[INSERT PROCEDURE #29]",0,0,0,0,0]
["[OTHER STARTUP COSTS #2]",0,null,"[OTHER STUDY MGMT COSTS #14]",0,null,"[INSERT PROCEDURE #30]",0,0,0,0,0]
["[OTHER STARTUP COSTS #3]",0,null,"[OTHER STUDY MGMT COSTS #15]",0,null,"[INSERT PROCEDURE #31]",0,0,0,0,0]
["[OTHER STARTUP COSTS #4]",0,null,null,null,null,"[INSERT PROCEDURE #32]",0,0,0,0,0]
["[OTHER STARTUP COSTS #5]",0,null,null,null,null,"[INSERT PROCEDURE #33]",0,0,0,0,0]
["[OTHER STARTUP COSTS #6]",0,null,null,null,null,"[INSERT PROCEDURE #34]",0,0,0,0,0]
["[OTHER STARTUP COSTS #7]",0,null,null,null,null,"[INSERT PROCEDURE #35]",0,0,0,0,0]
["[OTHER STARTUP COSTS #8]",0,null,null,null,null,"[INSERT PROCEDURE #36]",0,0,0,0,0]
["[OTHER STARTUP COSTS #9]",0,null,null,null,null,"[INSERT PROCEDURE #37]",0,0,0,0,0]
["[OTHER STARTUP COSTS #10]",0,null,null,null,null,"[INSERT PROCEDURE #38]",0,0,0,0,0]
[null,null,null,null,null,null,"[INSERT PROCEDURE #39]",0,0,0,0,0]
[null,null,null,null,null,null,"[INSERT PROCEDURE #40]",0,0,0,0,0]
[null,null,null,null,null,null,"[INSERT PROCEDURE #41]",0,0,0,0,0]
[null,null,null,null,null,null,"[INSERT PROCEDURE #42]",0,0,0,0,0]
[null,null,null,null,null,null,"[INSERT PROCEDURE #43]",0,0,0,0,0]
[null,null,null,null,null,null,"[INSERT PROCEDURE #44]",0,0,0,0,0]
[null,null,null,null,null,null,"[INSERT PROCEDURE #45]",0,0,0,0,0]