{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Home","BVA","EP"],"not_rendered":{"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":16,"n_cols":1,"rows_kept":16,"merged":[[15,0,15,10]]}
{"$rows_empty":15}
["Designed by www.QAInsights.com"]

{"sheet":"BVA","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"merged":[[0,0,0,13],[2,0,6,13]]}
["BOUNDARY VALUE ANALYSIS TOOL"]
[]
["Boundary Value Analysis (BVA) is a Black box testing technique to optimize the input data for writing test cases. BVA focuses on boundary values of the input data. It has Lower Limit, On the boundary and Upper Limit.\n\nE.g. Credit Card Cash Limit should be from 1000$ to 5000$. Boundary Value Analysis yields:"]
[]
[]
[]
[]
["Lower Limit","+/- 1 (Lower Limit)","999$ , 1001$"]
["On the boundary",null,"1000$ , 5000$"]
["Upper Limit","+/-  (Lower Limit)","4999$, 5001$"]
[]
[]
["Enter your Lower Limit",5000]
["Enter your Upper Limit",1000]
[]
["Lower Limits",{"$f":"IF(ISNUMBER(B13),B13-1,\"Not a Number\")","v":4999},{"$f":"IF(ISNUMBER(B13),B13+1,\"Not a Number\")","v":5001}]
["On the boundary",{"$f":"B13","v":5000},{"$f":"B14","v":1000}]
["Upper Limits",{"$f":"IF(ISNUMBER(B14),B14-1,\"Not a Number\")","v":999},{"$f":"IF(ISNUMBER(B14),B14+1,\"Not a Number\")","v":1001}]

{"sheet":"EP","index":2,"n_rows":20,"n_cols":3,"rows_kept":20,"merged":[[0,0,0,13],[2,0,6,13]]}
["EQUIVALENCE PARTITIONING"]
[]
["Equivalence Partitioning is a Black box testing technique to optimize the input data for writing test cases. Equivalence Partitioning is technique which helps testers to consider only data from equivalence classes instead of exhaustive values in the larger class. \n\nE.g. Credit Card Cash Limit should be from 1000$ to 5000$. Equivalence Partitioning yields:"]
[]
[]
[]
[]
[]
[]
["Value less than ","1000$","Invalid"]
["Value between ","1000$ and 5000$","Valid"]
["Value greater than","5000$","Invalid"]
[]
["Enter your Lower Limit",100]
["Enter your Upper Limit",90]
[]
["Equivalence Class"]
["Invalid Class",{"$f":"B14-RANDBETWEEN(1,100)","v":58}]
["Valid Class",{"$f":"RANDBETWEEN(B14,B15)","v":{"$error":"#NUM!"}}]
["Invalid Class",{"$f":"B15+RANDBETWEEN(1,100)","v":171}]