{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Question","Try","MrExcel","excelisfun","Sheet1 (2)"],"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":"Question","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Codes","Add Based On Letters and Lookup table","State: Zero, Over Zero, Under Zero"]
["AGGTACCGTA"]
["AAAA"]
["GAGAGA"]
["GT"]
[]
["Letter","Value"]
["A",1]
["C",1]
["G",-1]
["T",-1]

{"sheet":"Try","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Codes","Add Based On Letters and Lookup table","State: Zero, Over Zero, Under Zero"]
["AGGTACCGTA"]
["AAAA"]
["GAGAGA"]
["GT"]
[]
["Letter","Value"]
["A",1]
["C",1]
["G",-1]
["T",-1]

{"sheet":"MrExcel","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Codes","Add Based On Letters and Lookup table","State: Zero, Over Zero, Under Zero"]
["AGGTACCGTA",{"$f":"SumByChLookup(A2,$A$8:$B$11)","v":0}]
["AAAA",{"$f":"SumByChLookup(A3,$A$8:$B$11)","v":4}]
["GAGAGA",0]
["GT",-2]
[null,{"$f":"SUM(B2:B5)","v":2}]
["Letter","Value"]
["A",1]
["C",1]
["G",-1]
["T",-1]

{"sheet":"excelisfun","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Codes","Add Based On Letters and Lookup table","State: Zero, Over Zero, Under Zero"]
["AGGTACCGTA",{"$f":"CHOOSE(SIGN(SUMPRODUCT(LOOKUP(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1),$A$8:$B$11)))+2,\"Under Zero\",\"Zero\",\"Over Zero\")","v":"Zero"}]
["AAAA",{"$f":"CHOOSE(SIGN(SUMPRODUCT(LOOKUP(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1),$A$8:$B$11)))+2,\"Under Zero\",\"Zero\",\"Over Zero\")","v":"Over Zero"}]
["GAGAGA","Zero"]
["GT","Under Zero"]
[]
["Letter","Value"]
["A",1]
["C",1]
["G",-1]
["T",-1]

{"sheet":"Sheet1 (2)","index":4,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Codes","Add","State: Zero, Over Zero, Under Zero",null,"A",1]
["AGGTACCGTA",{"$f":"SUMPRODUCT(LOOKUP(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1),$E$1:$F$4))","v":0},null,null,"C",1]
["AAAA",{"$f":"SUMPRODUCT(LOOKUP(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1),$E$1:$F$4))","v":4},null,null,"G",-1]
["GAGAGA",0,null,null,"T",-1]
["GT",-2]