{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Voorblad","Versiebeheer","Documenten","Planning","Rapportage","Legenda"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Voorblad","index":0,"n_rows":17,"n_cols":5,"rows_kept":17,"merged":[[5,0,5,6],[6,0,6,6],[7,0,7,6],[8,0,8,6],[20,1,20,4]]}
[]
[]
[]
[{"$nulls":4},""]
[]
["Testdraaiboek"]
["[projectnaam]"]
["[FIST of GAT]"]
["[Applicatie/proces]"]
[]
[]
[]
[]
[{"$nulls":3},"Auteur: ","[naam]"]
[{"$nulls":3},"Functie: ","[Rol]"]
[{"$nulls":3},"Datum: ","[datum]"]
[{"$nulls":3},"Versie: ","[versie]"]

{"sheet":"Versiebeheer","index":1,"n_rows":23,"n_cols":8,"rows_kept":23,"merged":[[1,3,1,4],[1,5,1,8],[2,3,2,4],[2,5,2,8],[3,3,3,4],[3,5,3,8],[4,3,4,4],[4,5,4,8],[5,3,5,4],[5,5,5,8],[6,3,6,4],[6,5,6,8],[7,3,7,4],[7,5,7,8],[8,3,8,4],[8,5,8,8],[11,0,11,2],[11,3,11,4],[11,7,11,8],[12,0,12,2],[12,3,12,4],[12,7,12,8],[13,0,13,2],[13,3,13,4],[13,7,13,8],[14,0,14,2],[14,3,14,4],[14,7,14,8],[15,0,15,2],[15,3,15,4],[15,7,15,8],[16,0,16,2],[16,3,16,4],[16,7,16,8],[17,0,17,2],[17,3,17,4],[17,7,17,8],[18,0,18,2],[18,3,18,4],[18,7,18,8],[22,1,22,3],[22,4,22,8],[23,1,23,3],[23,4,23,8],[24,1,24,3],[24,4,24,8],[25,1,25,3],[25,4,25,8]]}
["Versiebeheer"]
["Versie","Status","Datum","Auteur",null,"Omschrijving"]
{"$rows_empty":8}
["Verzendlijst"]
["Verzonden aan",null,null,"Functie",null,"Verzenddatum","Versie","Versie datum "]
{"$rows_empty":9}
["Review"]
["Versie ","Naam"]

{"sheet":"Documenten","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[3,0,3,2],[3,3,3,4],[3,7,3,9],[4,0,4,2],[4,3,4,4],[4,7,4,9],[5,0,5,2],[5,3,5,4],[5,7,5,9],[6,0,6,2],[6,3,6,4],[6,7,6,9],[7,0,7,2],[7,3,7,4],[7,7,7,9],[8,0,8,2],[8,3,8,4],[8,7,8,9],[9,0,9,2],[9,3,9,4],[9,7,9,9],[14,0,14,2],[14,3,14,4],[14,7,14,9],[15,0,15,2],[15,3,15,4],[15,7,15,9],[16,0,16,2],[16,3,16,4],[16,7,16,9],[17,0,17,2],[17,3,17,4],[17,7,17,9],[18,0,18,2],[18,3,18,4],[18,7,18,9],[19,0,19,2],[19,3,19,4],[19,7,19,9],[20,0,20,2],[20,3,20,4],[20,7,20,9]]}
["Testbasis"]
["De testontwerpen zijn gebaseerd op de volgende uitgangsdocumentatie (testbasis):"]
[]
["Nummer",null,null,"Titel",null,"Versie","Datum","Auteur"]
{"$rows_empty":7}
["Gerelateerde documenten"]
["Het testdraaiboek maakt gebruik van de volgende documenten:"]
[]
["Nummer",null,null,"Titel",null,"Versie","Datum","Auteur"]

{"sheet":"Planning","index":3,"n_rows":89,"n_cols":10,"rows_kept":89}
["Stap","Testontwerp","Actie(s)/Stappen","uitgevoerd door ","Uitgevoerd (J/N):","Fout/Goed/hold","Bevindingnr","Opmerking","Uitvoer Datum","Uitvoer tijd"]
[{"$f":"IF(E2=\"\",\"\",IF(A1<1,1,MAXA(A$1:A1)+1))","v":""}]
[{"$f":"IF(E3=\"\",\"\",IF(A2<1,1,MAXA(A$1:A2)+1))","v":""}]
[{"$f":"IF(E4=\"\",\"\",IF(A3<1,1,MAXA(A$1:A3)+1))","v":""}]
[{"$f":"IF(E5=\"\",\"\",IF(A4<1,1,MAXA(A$1:A4)+1))","v":""}]
[{"$f":"IF(E6=\"\",\"\",IF(A5<1,1,MAXA(A$1:A5)+1))","v":""}]
[{"$f":"IF(E7=\"\",\"\",IF(A6<1,1,MAXA(A$1:A6)+1))","v":""}]
[{"$f":"IF(E8=\"\",\"\",IF(A7<1,1,MAXA(A$1:A7)+1))","v":""}]
[{"$f":"IF(E9=\"\",\"\",IF(A8<1,1,MAXA(A$1:A8)+1))","v":""}]
[{"$f":"IF(E10=\"\",\"\",IF(A9<1,1,MAXA(A$1:A9)+1))","v":""}]
[{"$f":"IF(E11=\"\",\"\",IF(A10<1,1,MAXA(A$1:A10)+1))","v":""}]
[{"$f":"IF(E12=\"\",\"\",IF(A11<1,1,MAXA(A$1:A11)+1))","v":""}]
[{"$f":"IF(E13=\"\",\"\",IF(A12<1,1,MAXA(A$1:A12)+1))","v":""}]
[{"$f":"IF(E14=\"\",\"\",IF(A13<1,1,MAXA(A$1:A13)+1))","v":""}]
[{"$f":"IF(E15=\"\",\"\",IF(A14<1,1,MAXA(A$1:A14)+1))","v":""}]
[{"$f":"IF(E16=\"\",\"\",IF(A15<1,1,MAXA(A$1:A15)+1))","v":""}]
[{"$f":"IF(E17=\"\",\"\",IF(A16<1,1,MAXA(A$1:A16)+1))","v":""}]
[{"$f":"IF(E18=\"\",\"\",IF(A17<1,1,MAXA(A$1:A17)+1))","v":""}]
[{"$f":"IF(E19=\"\",\"\",IF(A18<1,1,MAXA(A$1:A18)+1))","v":""}]
[{"$f":"IF(E20=\"\",\"\",IF(A19<1,1,MAXA(A$1:A19)+1))","v":""}]
[{"$f":"IF(E21=\"\",\"\",IF(A20<1,1,MAXA(A$1:A20)+1))","v":""}]
[{"$f":"IF(E22=\"\",\"\",IF(A21<1,1,MAXA(A$1:A21)+1))","v":""}]
[{"$f":"IF(E23=\"\",\"\",IF(A22<1,1,MAXA(A$1:A22)+1))","v":""}]
[{"$f":"IF(E24=\"\",\"\",IF(A23<1,1,MAXA(A$1:A23)+1))","v":""}]
[{"$f":"IF(E25=\"\",\"\",IF(A24<1,1,MAXA(A$1:A24)+1))","v":""}]
[{"$f":"IF(E26=\"\",\"\",IF(A25<1,1,MAXA(A$1:A25)+1))","v":""}]
[{"$f":"IF(E27=\"\",\"\",IF(A26<1,1,MAXA(A$1:A26)+1))","v":""}]
[{"$f":"IF(E28=\"\",\"\",IF(A27<1,1,MAXA(A$1:A27)+1))","v":""}]
[{"$f":"IF(E29=\"\",\"\",IF(A28<1,1,MAXA(A$1:A28)+1))","v":""}]
[{"$f":"IF(E30=\"\",\"\",IF(A29<1,1,MAXA(A$1:A29)+1))","v":""}]
[{"$f":"IF(E31=\"\",\"\",IF(A30<1,1,MAXA(A$1:A30)+1))","v":""}]
[{"$f":"IF(E32=\"\",\"\",IF(A31<1,1,MAXA(A$1:A31)+1))","v":""}]
[{"$f":"IF(E33=\"\",\"\",IF(A32<1,1,MAXA(A$1:A32)+1))","v":""}]
[{"$f":"IF(E34=\"\",\"\",IF(A33<1,1,MAXA(A$1:A33)+1))","v":""}]
[{"$f":"IF(E35=\"\",\"\",IF(A34<1,1,MAXA(A$1:A34)+1))","v":""}]
[{"$f":"IF(E36=\"\",\"\",IF(A35<1,1,MAXA(A$1:A35)+1))","v":""}]
[{"$f":"IF(E37=\"\",\"\",IF(A36<1,1,MAXA(A$1:A36)+1))","v":""}]
[{"$f":"IF(E38=\"\",\"\",IF(A37<1,1,MAXA(A$1:A37)+1))","v":""}]
[{"$f":"IF(E39=\"\",\"\",IF(A38<1,1,MAXA(A$1:A38)+1))","v":""}]
[{"$f":"IF(E40=\"\",\"\",IF(A39<1,1,MAXA(A$1:A39)+1))","v":""}]
[{"$f":"IF(E41=\"\",\"\",IF(A40<1,1,MAXA(A$1:A40)+1))","v":""}]
[{"$f":"IF(E42=\"\",\"\",IF(A41<1,1,MAXA(A$1:A41)+1))","v":""}]
[{"$f":"IF(E43=\"\",\"\",IF(A42<1,1,MAXA(A$1:A42)+1))","v":""}]
[{"$f":"IF(E44=\"\",\"\",IF(A43<1,1,MAXA(A$1:A43)+1))","v":""}]
[{"$f":"IF(E45=\"\",\"\",IF(A44<1,1,MAXA(A$1:A44)+1))","v":""}]
[{"$f":"IF(E46=\"\",\"\",IF(A45<1,1,MAXA(A$1:A45)+1))","v":""}]
[{"$f":"IF(E47=\"\",\"\",IF(A46<1,1,MAXA(A$1:A46)+1))","v":""}]
[{"$f":"IF(E48=\"\",\"\",IF(A47<1,1,MAXA(A$1:A47)+1))","v":""}]
[{"$f":"IF(E49=\"\",\"\",IF(A48<1,1,MAXA(A$1:A48)+1))","v":""}]
[{"$f":"IF(E50=\"\",\"\",IF(A49<1,1,MAXA(A$1:A49)+1))","v":""}]
[{"$f":"IF(E51=\"\",\"\",IF(A50<1,1,MAXA(A$1:A50)+1))","v":""}]
[{"$f":"IF(E52=\"\",\"\",IF(A51<1,1,MAXA(A$1:A51)+1))","v":""}]
[{"$f":"IF(E53=\"\",\"\",IF(A52<1,1,MAXA(A$1:A52)+1))","v":""}]
[{"$f":"IF(E54=\"\",\"\",IF(A53<1,1,MAXA(A$1:A53)+1))","v":""}]
[{"$f":"IF(E55=\"\",\"\",IF(A54<1,1,MAXA(A$1:A54)+1))","v":""}]
[{"$f":"IF(E56=\"\",\"\",IF(A55<1,1,MAXA(A$1:A55)+1))","v":""}]
[{"$f":"IF(E57=\"\",\"\",IF(A56<1,1,MAXA(A$1:A56)+1))","v":""}]
[{"$f":"IF(E58=\"\",\"\",IF(A57<1,1,MAXA(A$1:A57)+1))","v":""}]
[{"$f":"IF(E59=\"\",\"\",IF(A58<1,1,MAXA(A$1:A58)+1))","v":""}]
[{"$f":"IF(E60=\"\",\"\",IF(A59<1,1,MAXA(A$1:A59)+1))","v":""}]
[{"$f":"IF(E61=\"\",\"\",IF(A60<1,1,MAXA(A$1:A60)+1))","v":""}]
[{"$f":"IF(E62=\"\",\"\",IF(A61<1,1,MAXA(A$1:A61)+1))","v":""}]
[{"$f":"IF(E63=\"\",\"\",IF(A62<1,1,MAXA(A$1:A62)+1))","v":""}]
[{"$f":"IF(E64=\"\",\"\",IF(A63<1,1,MAXA(A$1:A63)+1))","v":""}]
[{"$f":"IF(E65=\"\",\"\",IF(A64<1,1,MAXA(A$1:A64)+1))","v":""}]
[{"$f":"IF(E66=\"\",\"\",IF(A65<1,1,MAXA(A$1:A65)+1))","v":""}]
[{"$f":"IF(E67=\"\",\"\",IF(A66<1,1,MAXA(A$1:A66)+1))","v":""}]
[{"$f":"IF(E68=\"\",\"\",IF(A67<1,1,MAXA(A$1:A67)+1))","v":""}]
[{"$f":"IF(E69=\"\",\"\",IF(A68<1,1,MAXA(A$1:A68)+1))","v":""}]
[{"$f":"IF(E70=\"\",\"\",IF(A69<1,1,MAXA(A$1:A69)+1))","v":""}]
[{"$f":"IF(E71=\"\",\"\",IF(A70<1,1,MAXA(A$1:A70)+1))","v":""}]
[{"$f":"IF(E72=\"\",\"\",IF(A71<1,1,MAXA(A$1:A71)+1))","v":""}]
[{"$f":"IF(E73=\"\",\"\",IF(A72<1,1,MAXA(A$1:A72)+1))","v":""}]
[{"$f":"IF(E74=\"\",\"\",IF(A73<1,1,MAXA(A$1:A73)+1))","v":""}]
[{"$f":"IF(E75=\"\",\"\",IF(A74<1,1,MAXA(A$1:A74)+1))","v":""}]
[{"$f":"IF(E76=\"\",\"\",IF(A75<1,1,MAXA(A$1:A75)+1))","v":""}]
[{"$f":"IF(E77=\"\",\"\",IF(A76<1,1,MAXA(A$1:A76)+1))","v":""}]
[{"$f":"IF(E78=\"\",\"\",IF(A77<1,1,MAXA(A$1:A77)+1))","v":""}]
[{"$f":"IF(E79=\"\",\"\",IF(A78<1,1,MAXA(A$1:A78)+1))","v":""}]
[{"$f":"IF(E80=\"\",\"\",IF(A79<1,1,MAXA(A$1:A79)+1))","v":""}]
[{"$f":"IF(E81=\"\",\"\",IF(A80<1,1,MAXA(A$1:A80)+1))","v":""}]
[{"$f":"IF(E82=\"\",\"\",IF(A81<1,1,MAXA(A$1:A81)+1))","v":""}]
[{"$f":"IF(E83=\"\",\"\",IF(A82<1,1,MAXA(A$1:A82)+1))","v":""}]
[{"$f":"IF(E84=\"\",\"\",IF(A83<1,1,MAXA(A$1:A83)+1))","v":""}]
[{"$f":"IF(E85=\"\",\"\",IF(A84<1,1,MAXA(A$1:A84)+1))","v":""}]
[{"$f":"IF(E86=\"\",\"\",IF(A85<1,1,MAXA(A$1:A85)+1))","v":""}]
[{"$f":"IF(E87=\"\",\"\",IF(A86<1,1,MAXA(A$1:A86)+1))","v":""}]
[{"$f":"IF(E88=\"\",\"\",IF(A87<1,1,MAXA(A$1:A87)+1))","v":""}]
[{"$f":"IF(E89=\"\",\"\",IF(A88<1,1,MAXA(A$1:A88)+1))","v":""}]

{"sheet":"Rapportage","index":4,"n_rows":10,"n_cols":3,"rows_kept":10}
["Rapportage"]
[]
[]
[null,"Aantal","Procenten"]
["Aantal stappen niet uitgevoerd",{"$f":"COUNTIF(Planning!E2:E89,\"N\")","v":0},{"$f":"IF(MAXA(Planning!A2:'Planning'!A2000)=0,0,SUM(B5/(MAXA(Planning!A2:'Planning'!A2000))*100))","v":{"v":0,"d":"0.00"}}]
["Aantal stappen uitgevoerd",{"$f":"COUNTIF(Planning!E2:E2000,\"J\")","v":0},{"$f":"IF(MAXA(Planning!A2:'Planning'!A2000)=0,0,SUM(B6/(MAXA(Planning!A2:'Planning'!A2000))*100))","v":{"v":0,"d":"0.00"}}]
["aantal stappen fout",{"$f":"COUNTIF(Planning!F2:F2000,\"Fout\")","v":0},{"$f":"IF(MAXA(Planning!A2:'Planning'!A2000)=0,0,SUM(B7/(MAXA(Planning!A2:'Planning'!A2000))*100))","v":{"v":0,"d":"0.00"}}]
["Aantal stappen hold",{"$f":"COUNTIF(Planning!F2:F2000,\"Hold\")","v":0},{"$f":"IF(MAXA(Planning!A2:'Planning'!A2000)=0,0,SUM(B8/(MAXA(Planning!A2:'Planning'!A2000))*100))","v":{"v":0,"d":"0.00"}}]
["Aantal stappen goed",{"$f":"COUNTIF(Planning!F2:F2000,\"Goed\")","v":0},{"$f":"IF(MAXA(Planning!A2:'Planning'!A2000)=0,0,SUM(B9/(MAXA(Planning!A2:'Planning'!A2000))*100))","v":{"v":0,"d":"0.00"}}]
["Aantal stappen met bevinding:",{"$f":"COUNTA(Planning!G2:G2000)","v":0},{"$f":"IF(MAXA(Planning!A2:'Planning'!A2000)=0,0,SUM(B10/(MAXA(Planning!A2:'Planning'!A2000))*100))","v":{"v":0,"d":"0.00"}}]

{"sheet":"Legenda","index":5,"n_rows":32,"n_cols":2,"rows_kept":32,"merged":[[23,0,23,1]]}
["Legenda"]
["Voorblad"]
["[projectnaam]","Geef hier de naam van het project"]
["[GAT of FAT]","Geef hier de testfase op"]
["Applicatie","Geef hier de applicatie weer die getest wordt in dit draaiboek"]
["Auteur","Geef hier de naam van de samensteller van het draaiboek"]
["Status","Geef de status van het draaiboek aan"]
["Versie","Geef hier het versienummer van het draaiboek"]
["Datum","Geef hier de datum waarop het draaiboek is gemaakt"]
[]
["Versiebeheer"]
["Versiebeheer","Geef  hier de status weer waar het document zich inbevind"]
["Verzendlijst","Geef hier aan waar het document naartoe gestuurd is"]
["Review","Geef hier aan wie het document gereviewd heeft"]
[]
["Documenten"]
["Testbasis","Geef hier de testbasis weer waarop de tests zijn gebaseerd"]
["Gerelateerde documenten","Geef hier de documenten weer waar o.a. testscripts in staan"]
[]
["Planning"]
["Hier wordt de volgorde van de testscripts neergezet."]
["Afhankelijk van de status waarin de stap zich verkeerd, wordt de regel gekleurd"]
[]
["Kleur verklaring"]
["Goed","Stap is goed gegaan"]
["Fout","Stap is fout en moet hertest worden"]
["Hold","Stap moet wachten eer het uitgevoerd kan worden"]
["Ja","Stap is uitgevoerd"]
["Nee","Stap Is nog niet uitgevoerd"]
[]
["Rapportage"]
["Dit wordt automatisch gemaakt. Hierin is te zien hoe de tests zijn verlopen."]