{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Framework"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Framework","index":0,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[[35,12,36,12],[11,12,12,12],[19,12,20,12],[27,12,28,12],[11,3,12,3],[19,3,20,3],[27,3,28,3],[35,3,36,3],[5,2,7,2],[8,2,10,2],[11,2,12,2],[19,2,20,2],[13,2,15,2],[16,2,18,2],[27,2,28,2],[35,2,36,2],[21,2,23,2],[24,2,26,2],[29,2,31,2],[32,2,34,2],[1,1,1,13],[37,1,38,1],[11,4,12,4],[19,4,20,4],[27,4,28,4],[35,4,36,4],[5,1,12,1],[13,1,20,1],[21,1,28,1],[29,1,36,1],[11,10,12,10],[19,10,20,10],[27,8,28,8],[35,8,36,8],[11,8,12,8],[19,8,20,8],[35,11,36,11],[11,9,12,9],[19,9,20,9],[27,9,28,9],[35,9,36,9],[11,11,12,11],[19,11,20,11],[27,11,28,11],[27,10,28,10],[35,10,36,10]]}
[]
[null,"PROJECT TBD: Requirements Definition Framewok"]
[null,null,"*Copy & insert new section after first. Copy down formula from 1st section."]
[null,"*Copy & insert new section after first.",null,"*Insert new detail lines after first. Copy down formula from 1st detail line.",null,"*Potential skeleton to use for building each requirement..."]
[null,"Process","Sub-Process","Requirement ID","Requirement Description","As a [who], ","the system shall [what/when/where]","in order to [why].","Priority Level","Feasability Level","System Fit (Configuration) or Gap (Development) or Manual Task","Gap Solution Type\n(FRICE)","Effort Estimate","Owner"]
[null,"A",{"$f":"IF(IFERROR(LEFT(mergedText(C5),LEN(mergedText(C5))-LEN(TRIM(MID(mergedText(C5),FIND(\"#\",SUBSTITUTE(mergedText(C5),\".\",\"#\",1)),255)))),mergedText(C5))=mergedText(B6),(LEFT(mergedText(C5),LEN(mergedText(C5))-LEN(TRIM(MID(mergedText(C5),FIND(\"#\",SUBSTITUTE(mergedText(C5),\".\",\"#\",1))+1,255))))) & (RIGHT(mergedText(C5),LEN(TRIM(MID(mergedText(C5),FIND(\"#\",SUBSTITUTE(mergedText(C5),\".\",\"#\",1))+1,255))))+1),mergedText(B6) & \".\" & 1)","v":"A.1"},{"$f":"C6","v":"A.1"},null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(D7:D8)","v":2}]
[null,null,null,{"$f":"IF(mergedText(C6)=D6,D6 & \".\"&1,LEFT(D6,LEN(D6)-LEN(TRIM(MID(D6,FIND(\"#\",SUBSTITUTE(D6,\".\",\"#\",2))+1,255)))) & (RIGHT(D6,LEN(TRIM(MID(D6,FIND(\"#\",SUBSTITUTE(D6,\".\",\"#\",2))+1,255))))+1))","v":"A.1.1"}]
[null,null,null,{"$f":"IF(mergedText(C7)=D7,D7 & \".\"&1,LEFT(D7,LEN(D7)-LEN(TRIM(MID(D7,FIND(\"#\",SUBSTITUTE(D7,\".\",\"#\",2))+1,255)))) & (RIGHT(D7,LEN(TRIM(MID(D7,FIND(\"#\",SUBSTITUTE(D7,\".\",\"#\",2))+1,255))))+1))","v":"A.1.2"}]
[null,null,{"$f":"IF(IFERROR(LEFT(mergedText(C8),LEN(mergedText(C8))-LEN(TRIM(MID(mergedText(C8),FIND(\"#\",SUBSTITUTE(mergedText(C8),\".\",\"#\",1)),255)))),mergedText(C8))=mergedText(B9),(LEFT(mergedText(C8),LEN(mergedText(C8))-LEN(TRIM(MID(mergedText(C8),FIND(\"#\",SUBSTITUTE(mergedText(C8),\".\",\"#\",1))+1,255))))) & (RIGHT(mergedText(C8),LEN(TRIM(MID(mergedText(C8),FIND(\"#\",SUBSTITUTE(mergedText(C8),\".\",\"#\",1))+1,255))))+1),mergedText(B9) & \".\" & 1)","v":"A.2"},{"$f":"C9","v":"A.2"},null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(D10:D11)","v":2}]
[null,null,null,{"$f":"IF(mergedText(C9)=D9,D9 & \".\"&1,LEFT(D9,LEN(D9)-LEN(TRIM(MID(D9,FIND(\"#\",SUBSTITUTE(D9,\".\",\"#\",2))+1,255)))) & (RIGHT(D9,LEN(TRIM(MID(D9,FIND(\"#\",SUBSTITUTE(D9,\".\",\"#\",2))+1,255))))+1))","v":"A.2.1"}]
[null,null,null,{"$f":"IF(mergedText(C10)=D10,D10 & \".\"&1,LEFT(D10,LEN(D10)-LEN(TRIM(MID(D10,FIND(\"#\",SUBSTITUTE(D10,\".\",\"#\",2))+1,255)))) & (RIGHT(D10,LEN(TRIM(MID(D10,FIND(\"#\",SUBSTITUTE(D10,\".\",\"#\",2))+1,255))))+1))","v":"A.2.2"}]
[null,null,{"$f":"B6","v":"A"},{"$f":"C12","v":"A"},null,null,null,null,null,null,null,null,null,{"$f":"SUM(N6:N11)","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$38<>0,N12/$N$38,0)","v":0.25}]
[null,"B",{"$f":"IF(IFERROR(LEFT(mergedText(C13),LEN(mergedText(C13))-LEN(TRIM(MID(mergedText(C13),FIND(\"#\",SUBSTITUTE(mergedText(C13),\".\",\"#\",1)),255)))),mergedText(C13))=mergedText(B14),(LEFT(mergedText(C13),LEN(mergedText(C13))-LEN(TRIM(MID(mergedText(C13),FIND(\"#\",SUBSTITUTE(mergedText(C13),\".\",\"#\",1))+1,255))))) & (RIGHT(mergedText(C13),LEN(TRIM(MID(mergedText(C13),FIND(\"#\",SUBSTITUTE(mergedText(C13),\".\",\"#\",1))+1,255))))+1),mergedText(B14) & \".\" & 1)","v":"B.1"},{"$f":"C14","v":"B.1"},null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(D15:D16)","v":2}]
[null,null,null,{"$f":"IF(mergedText(C14)=D14,D14 & \".\"&1,LEFT(D14,LEN(D14)-LEN(TRIM(MID(D14,FIND(\"#\",SUBSTITUTE(D14,\".\",\"#\",2))+1,255)))) & (RIGHT(D14,LEN(TRIM(MID(D14,FIND(\"#\",SUBSTITUTE(D14,\".\",\"#\",2))+1,255))))+1))","v":"B.1.1"}]
[null,null,null,{"$f":"IF(mergedText(C15)=D15,D15 & \".\"&1,LEFT(D15,LEN(D15)-LEN(TRIM(MID(D15,FIND(\"#\",SUBSTITUTE(D15,\".\",\"#\",2))+1,255)))) & (RIGHT(D15,LEN(TRIM(MID(D15,FIND(\"#\",SUBSTITUTE(D15,\".\",\"#\",2))+1,255))))+1))","v":"B.1.2"}]
[null,null,{"$f":"IF(IFERROR(LEFT(mergedText(C16),LEN(mergedText(C16))-LEN(TRIM(MID(mergedText(C16),FIND(\"#\",SUBSTITUTE(mergedText(C16),\".\",\"#\",1)),255)))),mergedText(C16))=mergedText(B17),(LEFT(mergedText(C16),LEN(mergedText(C16))-LEN(TRIM(MID(mergedText(C16),FIND(\"#\",SUBSTITUTE(mergedText(C16),\".\",\"#\",1))+1,255))))) & (RIGHT(mergedText(C16),LEN(TRIM(MID(mergedText(C16),FIND(\"#\",SUBSTITUTE(mergedText(C16),\".\",\"#\",1))+1,255))))+1),mergedText(B17) & \".\" & 1)","v":"B.2"},{"$f":"C17","v":"B.2"},null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(D18:D19)","v":2}]
[null,null,null,{"$f":"IF(mergedText(C17)=D17,D17 & \".\"&1,LEFT(D17,LEN(D17)-LEN(TRIM(MID(D17,FIND(\"#\",SUBSTITUTE(D17,\".\",\"#\",2))+1,255)))) & (RIGHT(D17,LEN(TRIM(MID(D17,FIND(\"#\",SUBSTITUTE(D17,\".\",\"#\",2))+1,255))))+1))","v":"B.2.1"}]
[null,null,null,{"$f":"IF(mergedText(C18)=D18,D18 & \".\"&1,LEFT(D18,LEN(D18)-LEN(TRIM(MID(D18,FIND(\"#\",SUBSTITUTE(D18,\".\",\"#\",2))+1,255)))) & (RIGHT(D18,LEN(TRIM(MID(D18,FIND(\"#\",SUBSTITUTE(D18,\".\",\"#\",2))+1,255))))+1))","v":"B.2.2"}]
[null,null,{"$f":"B14","v":"B"},{"$f":"C20","v":"B"},null,null,null,null,null,null,null,null,null,{"$f":"SUM(N14:N19)","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$38<>0,N20/$N$38,0)","v":0.25}]
[null,"C",{"$f":"IF(IFERROR(LEFT(mergedText(C21),LEN(mergedText(C21))-LEN(TRIM(MID(mergedText(C21),FIND(\"#\",SUBSTITUTE(mergedText(C21),\".\",\"#\",1)),255)))),mergedText(C21))=mergedText(B22),(LEFT(mergedText(C21),LEN(mergedText(C21))-LEN(TRIM(MID(mergedText(C21),FIND(\"#\",SUBSTITUTE(mergedText(C21),\".\",\"#\",1))+1,255))))) & (RIGHT(mergedText(C21),LEN(TRIM(MID(mergedText(C21),FIND(\"#\",SUBSTITUTE(mergedText(C21),\".\",\"#\",1))+1,255))))+1),mergedText(B22) & \".\" & 1)","v":"C.1"},{"$f":"C22","v":"C.1"},null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(D23:D24)","v":2}]
[null,null,null,{"$f":"IF(mergedText(C22)=D22,D22 & \".\"&1,LEFT(D22,LEN(D22)-LEN(TRIM(MID(D22,FIND(\"#\",SUBSTITUTE(D22,\".\",\"#\",2))+1,255)))) & (RIGHT(D22,LEN(TRIM(MID(D22,FIND(\"#\",SUBSTITUTE(D22,\".\",\"#\",2))+1,255))))+1))","v":"C.1.1"}]
[null,null,null,{"$f":"IF(mergedText(C23)=D23,D23 & \".\"&1,LEFT(D23,LEN(D23)-LEN(TRIM(MID(D23,FIND(\"#\",SUBSTITUTE(D23,\".\",\"#\",2))+1,255)))) & (RIGHT(D23,LEN(TRIM(MID(D23,FIND(\"#\",SUBSTITUTE(D23,\".\",\"#\",2))+1,255))))+1))","v":"C.1.2"}]
[null,null,{"$f":"IF(IFERROR(LEFT(mergedText(C24),LEN(mergedText(C24))-LEN(TRIM(MID(mergedText(C24),FIND(\"#\",SUBSTITUTE(mergedText(C24),\".\",\"#\",1)),255)))),mergedText(C24))=mergedText(B25),(LEFT(mergedText(C24),LEN(mergedText(C24))-LEN(TRIM(MID(mergedText(C24),FIND(\"#\",SUBSTITUTE(mergedText(C24),\".\",\"#\",1))+1,255))))) & (RIGHT(mergedText(C24),LEN(TRIM(MID(mergedText(C24),FIND(\"#\",SUBSTITUTE(mergedText(C24),\".\",\"#\",1))+1,255))))+1),mergedText(B25) & \".\" & 1)","v":"C.2"},{"$f":"C25","v":"C.2"},null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(D26:D27)","v":2}]
[null,null,null,{"$f":"IF(mergedText(C25)=D25,D25 & \".\"&1,LEFT(D25,LEN(D25)-LEN(TRIM(MID(D25,FIND(\"#\",SUBSTITUTE(D25,\".\",\"#\",2))+1,255)))) & (RIGHT(D25,LEN(TRIM(MID(D25,FIND(\"#\",SUBSTITUTE(D25,\".\",\"#\",2))+1,255))))+1))","v":"C.2.1"}]
[null,null,null,{"$f":"IF(mergedText(C26)=D26,D26 & \".\"&1,LEFT(D26,LEN(D26)-LEN(TRIM(MID(D26,FIND(\"#\",SUBSTITUTE(D26,\".\",\"#\",2))+1,255)))) & (RIGHT(D26,LEN(TRIM(MID(D26,FIND(\"#\",SUBSTITUTE(D26,\".\",\"#\",2))+1,255))))+1))","v":"C.2.2"}]
[null,null,{"$f":"B22","v":"C"},{"$f":"C28","v":"C"},null,null,null,null,null,null,null,null,null,{"$f":"SUM(N22:N27)","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$38<>0,N28/$N$38,0)","v":0.25}]
[null,"D",{"$f":"IF(IFERROR(LEFT(mergedText(C29),LEN(mergedText(C29))-LEN(TRIM(MID(mergedText(C29),FIND(\"#\",SUBSTITUTE(mergedText(C29),\".\",\"#\",1)),255)))),mergedText(C29))=mergedText(B30),(LEFT(mergedText(C29),LEN(mergedText(C29))-LEN(TRIM(MID(mergedText(C29),FIND(\"#\",SUBSTITUTE(mergedText(C29),\".\",\"#\",1))+1,255))))) & (RIGHT(mergedText(C29),LEN(TRIM(MID(mergedText(C29),FIND(\"#\",SUBSTITUTE(mergedText(C29),\".\",\"#\",1))+1,255))))+1),mergedText(B30) & \".\" & 1)","v":"D.1"},{"$f":"C30","v":"D.1"},null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(D31:D32)","v":2}]
[null,null,null,{"$f":"IF(mergedText(C30)=D30,D30 & \".\"&1,LEFT(D30,LEN(D30)-LEN(TRIM(MID(D30,FIND(\"#\",SUBSTITUTE(D30,\".\",\"#\",2))+1,255)))) & (RIGHT(D30,LEN(TRIM(MID(D30,FIND(\"#\",SUBSTITUTE(D30,\".\",\"#\",2))+1,255))))+1))","v":"D.1.1"}]
[null,null,null,{"$f":"IF(mergedText(C31)=D31,D31 & \".\"&1,LEFT(D31,LEN(D31)-LEN(TRIM(MID(D31,FIND(\"#\",SUBSTITUTE(D31,\".\",\"#\",2))+1,255)))) & (RIGHT(D31,LEN(TRIM(MID(D31,FIND(\"#\",SUBSTITUTE(D31,\".\",\"#\",2))+1,255))))+1))","v":"D.1.2"}]
[null,null,{"$f":"IF(IFERROR(LEFT(mergedText(C32),LEN(mergedText(C32))-LEN(TRIM(MID(mergedText(C32),FIND(\"#\",SUBSTITUTE(mergedText(C32),\".\",\"#\",1)),255)))),mergedText(C32))=mergedText(B33),(LEFT(mergedText(C32),LEN(mergedText(C32))-LEN(TRIM(MID(mergedText(C32),FIND(\"#\",SUBSTITUTE(mergedText(C32),\".\",\"#\",1))+1,255))))) & (RIGHT(mergedText(C32),LEN(TRIM(MID(mergedText(C32),FIND(\"#\",SUBSTITUTE(mergedText(C32),\".\",\"#\",1))+1,255))))+1),mergedText(B33) & \".\" & 1)","v":"D.2"},{"$f":"C33","v":"D.2"},null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(D34:D35)","v":2}]
[null,null,null,{"$f":"IF(mergedText(C33)=D33,D33 & \".\"&1,LEFT(D33,LEN(D33)-LEN(TRIM(MID(D33,FIND(\"#\",SUBSTITUTE(D33,\".\",\"#\",2))+1,255)))) & (RIGHT(D33,LEN(TRIM(MID(D33,FIND(\"#\",SUBSTITUTE(D33,\".\",\"#\",2))+1,255))))+1))","v":"D.2.1"}]
[null,null,null,{"$f":"IF(mergedText(C34)=D34,D34 & \".\"&1,LEFT(D34,LEN(D34)-LEN(TRIM(MID(D34,FIND(\"#\",SUBSTITUTE(D34,\".\",\"#\",2))+1,255)))) & (RIGHT(D34,LEN(TRIM(MID(D34,FIND(\"#\",SUBSTITUTE(D34,\".\",\"#\",2))+1,255))))+1))","v":"D.2.2"}]
[null,null,{"$f":"B30","v":"D"},{"$f":"C36","v":"D"},null,null,null,null,null,null,null,null,null,{"$f":"SUM(N30:N35)","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$38<>0,N36/$N$38,0)","v":0.25}]
[null,"Total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N12,N20,N28,N36)","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N38<>0,N38/N38,0)","v":1}]