{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MOU","Help & Guidance","MOU sample"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"MOU","index":0,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":false,"merged":[[62,0,62,11],[1,0,2,1],[1,2,2,3],[3,6,3,7],[3,4,3,5],[4,2,4,3],[3,0,3,1],[5,6,5,7],[5,4,5,5],[8,0,8,3],[9,0,9,3],[5,0,5,3],[1,10,3,11],[18,0,18,3],[1,6,1,7],[14,0,14,3],[61,0,61,11],[2,6,2,7],[12,0,12,3],[3,8,3,9],[33,0,33,11],[1,8,1,9],[2,8,2,9],[19,0,19,3],[11,0,11,3],[13,0,13,3],[16,0,16,3],[17,0,17,3],[6,0,6,3],[7,0,7,3],[10,0,10,3],[1,4,2,5],[5,8,5,9],[15,0,15,3]]}
[]
["Investigator Name:",null,null,null,"Boston University",null,"VA",null,"Other Institution                   ",null,"TOTAL"]
[null,null,null,null,null,null,"Select VA Name",null,"Type Other Institution Name Here"]
["Title/Rank:"]
["Department: ",null,null,null,"Hrs/wk","%","Hrs/wk","%","Hrs/wk","%","Hrs/wk","%"]
["Total Appointed Hours/week",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:J6)","v":0}]
["Research:"]
[null,null,null,null,null,{"$f":"IF($E$20=0,\"\",E8/$E$20)","v":""},null,{"$f":"IF($G$19=0,\"\",G8/$G$19)","v":""},null,{"$f":"IF($I$20=0,\"\",I8/$I$20)","v":""},{"$f":"SUM(E8, G8, I8)","v":0},{"$f":"IF($K$20=0,\"\",K8/$K$20)","v":""}]
[null,null,null,null,null,{"$f":"IF($E$20=0,\"\",E9/$E$20)","v":""},null,{"$f":"IF($G$19=0,\"\",G9/$G$19)","v":""},null,{"$f":"IF($I$20=0,\"\",I9/$I$20)","v":""},0,{"$f":"IF($K$20=0,\"\",K9/$K$20)","v":""}]
[null,null,null,null,null,{"$f":"IF($E$20=0,\"\",E10/$E$20)","v":""},null,{"$f":"IF($G$19=0,\"\",G10/$G$19)","v":""},null,"",0,""]
[null,null,null,null,null,"",null,{"$f":"IF($G$19=0,\"\",G11/$G$19)","v":""},null,"",0,""]
[null,null,null,null,null,"",null,"",null,"",0,""]
[null,null,null,null,null,"",null,"",null,"",0,""]
[null,null,null,null,null,"",null,"",null,"",0,""]
[null,null,null,null,null,"",null,"",null,"",0,""]
[null,null,null,null,null,"",null,"",null,"",0,""]
["Teaching",null,null,null,null,{"$f":"IF($E$20=0,\"\",E17/$E$20)","v":""},null,{"$f":"IF($G$20=0,\"\",G17/$G$20)","v":""},null,{"$f":"IF($I$20=0,\"\",I17/$I$20)","v":""},0,{"$f":"IF($K$20=0,\"\",K17/$K$20)","v":""}]
["Clinical, Administration",null,null,null,null,{"$f":"IF($E$20=0,\"\",E18/$E$20)","v":""},null,{"$f":"IF(G20=0,\"\",G18/G20)","v":""},null,{"$f":"IF($I$20=0,\"\",I18/$I$20)","v":""},0,{"$f":"IF($K$20=0,\"\",K18/$K$20)","v":""}]
["Total Institutional Hours",null,null,null,{"$f":"SUM(E8:E18)","v":0},{"$f":"SUM(F8:F18)","v":0},0,0,0,0,{"$f":"SUM(K8:K18)","v":0},{"$f":"SUM(L8:L18)","v":0}]
["Total Appointed Time",null,null,null,{"$f":"SUM(E7:E18)","v":0},{"$f":"IF($K$20=0, 0%, E20/$K$20)","v":0},{"$f":"SUM(G7:G18)","v":0},{"$f":"IF($K$20=0, 0%, G20/$K$20)","v":0},{"$f":"SUM(I7:I18)","v":0},{"$f":"IF($K$20=0, 0%, I20/$K$20)","v":0},{"$f":"SUM(E20, G20, I20)","v":0},{"$f":"SUM(L7:L18)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["APPROVALS:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["All applicable Institutional Signatures must be completed before submission to BU Sponsored Programs"]

{"sheet":"Help & Guidance","index":1,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[12,0,12,3],[13,0,13,3],[14,0,14,3],[15,0,15,3],[16,0,16,3],[11,0,11,3],[3,8,3,9],[4,2,4,3],[5,0,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[6,0,6,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[10,0,10,3],[1,10,3,11],[2,8,2,9],[3,0,3,1],[3,4,3,5],[3,6,3,7],[1,0,2,1],[1,2,2,3],[1,4,2,5],[1,8,1,9],[1,6,1,7],[2,6,2,7]]}
[]
["Investigator Name:",null,null,null,"Boston University",null,"VA",null,"Other Institution                   ",null,"TOTAL"]
[null,null,null,null,null,null,"VA Location",null,"Other Institution Name                  "]
["Title/Rank:"]
["Department: ",null,null,null,"Hrs/wk","%","Hrs/wk","%","Hrs/wk","%","Hrs/wk","%"]
["Total Appointed Hours/week",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:J6)","v":0}]
["Research:"]
["BU SAP Grant #",null,null,null,null,{"$f":"IF(E17=0,\"\",E8/E17)","v":""},null,null,null,null,{"$f":"SUM(E8, G8, I8)","v":0},{"$f":"IF(K17=0,\"\",K8/K17)","v":""}]
["BU SAP Grant #",null,null,null,null,{"$f":"IF(E17=0,\"\",E9/E17)","v":""},null,{"$f":"IF(G17=0,\"\",G9/G17)","v":""},null,{"$f":"IF(I17=0,\"\",I9/I17)","v":""},{"$f":"SUM(E9, G9, I9)","v":0},{"$f":"IF(K17=0,\"\",K9/K17)","v":""}]
["BU SAP Grant #",null,null,null,null,{"$f":"IF(E17=0,\"\",E10/E17)","v":""},null,{"$f":"IF(G17=0,\"\",G10/G17)","v":""},null,{"$f":"IF(I17=0,\"\",I10/I17)","v":""},{"$f":"SUM(E10, G10, I10)","v":0},{"$f":"IF(K17=0,\"\",K10/K17)","v":""}]
["BU SAP Grant #",null,null,null,null,{"$f":"IF(E17=0,\"\",E11/E17)","v":""},null,{"$f":"IF(G17=0,\"\",G11/G17)","v":""},null,{"$f":"IF(I17=0,\"\",I11/I17)","v":""},0,{"$f":"IF(K17=0,\"\",K11/K17)","v":""}]
["VA Merit # ",null,null,null,null,{"$f":"IF(E17=0,\"\",E12/E17)","v":""},null,{"$f":"IF(G17=0,\"\",G12/G17)","v":""},null,{"$f":"IF(I17=0,\"\",I12/I17)","v":""},0,{"$f":"IF(K17=0,\"\",K12/K17)","v":""}]
["VA Merit # ",null,null,null,null,{"$f":"IF(E17=0,\"\",E13/E17)","v":""},null,{"$f":"IF(G17=0,\"\",G13/G17)","v":""},null,{"$f":"IF(I17=0,\"\",I13/I17)","v":""},0,{"$f":"IF(K17=0,\"\",K13/K17)","v":""}]
["Teaching",null,null,null,null,{"$f":"IF(E17=0,\"\",E14/E17)","v":""},null,{"$f":"IF(G17=0,\"\",G14/G17)","v":""},null,{"$f":"IF(I17=0,\"\",I14/I17)","v":""},0,{"$f":"IF(K17=0,\"\",K14/K17)","v":""}]
["Clinical, Administration",null,null,null,null,{"$f":"IF(E17=0,\"\",E15/E17)","v":""},null,{"$f":"IF(G17=0,\"\",G15/G17)","v":""},null,{"$f":"IF(I17=0,\"\",I15/I17)","v":""},0,{"$f":"IF(K17=0,\"\",K15/K17)","v":""}]
["Total Institutional Hours",null,null,null,{"$f":"SUM(E8:E15)","v":0},0,0,0,0,0,0,0]
["Total Appointed Time",null,null,null,{"$f":"SUM(E7:E15)","v":0},{"$f":"IF($K$17=0, 0%, E17/$K$17)","v":0},{"$f":"SUM(G7:G15)","v":0},{"$f":"IF($K$17=0, 0%, G17/$K$17)","v":0},{"$f":"SUM(I7:I15)","v":0},{"$f":"IF($K$17=0, 0%, I17/$K$17)","v":0},0,{"$f":"SUM(L7:L15)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Select VA Name"]
[null,"Boston"]
[null,"Bedford"]

{"sheet":"MOU sample","index":2,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,0,54,11],[55,0,55,11],[12,0,12,3],[13,0,13,3],[14,0,14,3],[15,0,15,3],[16,0,16,3],[26,0,26,11],[11,0,11,3],[3,8,3,9],[4,2,4,3],[5,0,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[6,0,6,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[10,0,10,3],[1,10,3,11],[2,8,2,9],[3,0,3,1],[3,4,3,5],[3,6,3,7],[1,6,1,7],[2,6,2,7],[1,0,2,1],[1,2,2,3],[1,4,2,5],[1,8,1,9]]}
[]
["Investigator Name:",null,"Penny Lane",null,"Boston University",null,"VA",null,"Other Institution                   ",null,"TOTAL"]
[null,null,null,null,null,null,"Boston",null,"   BVARI            "]
["Title/Rank:",null,null,null,"Assistant Professor",null,"Physician",null,"Physician"]
["Department: ",null,"School of Medicine - Infectious Diseases",null,"Hrs/wk","%","Hrs/wk","%","Hrs/wk","%","Hrs/wk","%"]
["Total Appointed Hours/week",null,null,null,20,null,32,null,8,null,{"$f":"SUM(E6:J6)","v":60}]
["Research:"]
["BU SAP Grant # 55200001",null,null,null,5,{"$f":"IF(E17=0,\"\",E8/E17)","v":0.25},null,null,null,null,{"$f":"SUM(E8, G8, I8)","v":5},{"$f":"IF(K17=0,\"\",K8/K17)","v":8.3333333333333329E-2}]
["BU SAP Grant # 55200002",null,null,null,2,{"$f":"IF(E17=0,\"\",E9/E17)","v":0.1},null,{"$f":"IF(G17=0,\"\",G9/G17)","v":0},null,{"$f":"IF(I17=0,\"\",I9/I17)","v":0},{"$f":"SUM(E9, G9, I9)","v":2},{"$f":"IF(K17=0,\"\",K9/K17)","v":3.3333333333333333E-2}]
["BU SAP Grant # 55200003",null,null,null,2,{"$f":"IF(E17=0,\"\",E10/E17)","v":0.1},null,{"$f":"IF(G17=0,\"\",G10/G17)","v":0},null,{"$f":"IF(I17=0,\"\",I10/I17)","v":0},{"$f":"SUM(E10, G10, I10)","v":2},{"$f":"IF(K17=0,\"\",K10/K17)","v":3.3333333333333333E-2}]
["BU SAP Grant # 55200004",null,null,null,4,{"$f":"IF(E17=0,\"\",E11/E17)","v":0.2},null,{"$f":"IF(G17=0,\"\",G11/G17)","v":0},null,{"$f":"IF(I17=0,\"\",I11/I17)","v":0},4,{"$f":"IF(K17=0,\"\",K11/K17)","v":6.6666666666666666E-2}]
["VA Merit # 1111111",null,null,null,null,{"$f":"IF(E17=0,\"\",E12/E17)","v":0},null,{"$f":"IF(G17=0,\"\",G12/G17)","v":0},5,{"$f":"IF(I17=0,\"\",I12/I17)","v":0.625},5,{"$f":"IF(K17=0,\"\",K12/K17)","v":8.3333333333333329E-2}]
["VA Merit # 1111112",null,null,null,null,{"$f":"IF(E17=0,\"\",E13/E17)","v":0},null,{"$f":"IF(G17=0,\"\",G13/G17)","v":0},3,{"$f":"IF(I17=0,\"\",I13/I17)","v":0.375},3,{"$f":"IF(K17=0,\"\",K13/K17)","v":0.05}]
["Teaching",null,null,null,6,{"$f":"IF(E17=0,\"\",E14/E17)","v":0.3},null,{"$f":"IF(G17=0,\"\",G14/G17)","v":0},null,{"$f":"IF(I17=0,\"\",I14/I17)","v":0},6,{"$f":"IF(K17=0,\"\",K14/K17)","v":0.1}]
["Clinical, Administration",null,null,null,1,{"$f":"IF(E17=0,\"\",E15/E17)","v":0.05},32,{"$f":"IF(G17=0,\"\",G15/G17)","v":1},null,{"$f":"IF(I17=0,\"\",I15/I17)","v":0},33,{"$f":"IF(K17=0,\"\",K15/K17)","v":0.55000000000000004}]
["Total Institutional Hours",null,null,null,{"$f":"SUM(E8:E15)","v":20},1,32,1,8,1,60,1]
["Total Appointed Time",null,null,null,{"$f":"SUM(E7:E15)","v":20},{"$f":"IF($K$17=0, 0%, E17/$K$17)","v":0.33333333333333331},{"$f":"SUM(G7:G15)","v":32},{"$f":"IF($K$17=0, 0%, G17/$K$17)","v":0.53333333333333333},{"$f":"SUM(I7:I15)","v":8},{"$f":"IF($K$17=0, 0%, I17/$K$17)","v":0.13333333333333333},60,{"$f":"SUM(L7:L15)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["APPROVALS:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["All applicable Institutional Signatures must be completed before submission to BU Sponsored Programs"]