{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["playing with group lookup logic","Admin","PGRA1","PGRS","PGRA2","PGRA","UserDetail"],"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":"playing with group lookup logic","index":0,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,"Yes"]
[]
[null,null,null,"Yes"]
[]
[]
[null,null,"account","type","class","subclass","amount"]
[null,null,"cash cash eq","a","CA","Cash",11]
[null,null,"ar","a","FA","ar",15]
[null,null,"inventory","e","CA","ar",20]
[null,null,"ar",null,null,null,30]
[]
[]
[]
[]
[null,null,"find","sumifs",null,"colnum","colnum"]
[null,null,"cash",{"$f":"SUMIFS(Table3[amount],OFFSET(Table3[account],0,IF(ISERROR(MATCH(C16,Table3[account],0)),IF(ISERROR(MATCH(C16,Table3[type],0)),IF(ISERROR(MATCH(C16,Table3[class],0)),IF(ISERROR(MATCH(C16,Table3[subclass],0)),0,3),2),1),0)),C16)","v":11},null,{"$f":"G16","v":4},{"$f":"IF(ISERROR(MATCH(C16,$C$7:$C$10,0)),IF(ISERROR(MATCH(C16,D7:D10,0)),IF(ISERROR(MATCH(C16,E7:E10,0)),IF(ISERROR(MATCH(C16,F7:F10,0)),0,4),3),2),1)","v":4}]
[null,null,"ar",{"$f":"SUMIFS(Table3[amount],IF(ISERROR(MATCH(C17,Table3[account],0)),IF(ISERROR(MATCH(C17,Table3[type],0)),IF(ISERROR(MATCH(C17,Table3[class],0)),IF(ISERROR(MATCH(C17,Table3[subclass],0)),0,Table3[subclass]),Table3[class]),Table3[type]),Table3[account]),C17)","v":45}]
[]
[null,null,"currently, this works; it should be streamlined, but it determines which column has the value and then uses that in an offset function to return the proper range to the sumifs function."]
[null,null,"perhaps, we can eliminate the nested if() functions by using an array formula to determine which column has the match?"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"which col has yes",{"$f":"SUMPRODUCT((C1:J3=\"Yes\")*(COLUMN(C1:J3)))","v":11}]
[null,null,null,null,null,null,"error check for multiple yes values",{"$f":"IF(COUNTIF(C1:J3,\"Yes\")=1,SUMPRODUCT((C1:J3=\"Yes\")*(COLUMN(C1:J3))),\"Error: Too many Yes values\")","v":"Error: Too many Yes values"}]

{"sheet":"Admin","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["PGR"]
["Click Consulting"]
[]
["Purpose","To store admin settings"]
[]
["Settings"]
[null,"Company","New Horizon Software Technologies"]
[]
[]
["Support"]
[null,"For support:"]
[null,"Click Consulting, Inc."]
[null,"clickconsulting.com"]
[null,"Jeff Lenning"]

{"sheet":"PGRA1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"PGRS","index":3,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Global Settings"]
["Name","Value","Notes"]
["Addin Name","PG Reports"]
["Version","2.2","text required"]
["PG Version"]
["Path","c:\\"]
["Dim Account","A","Column"]
["Dim Analysis",1,"Row"]
["Dim Type",2,"Row"]
["Dim Time",3,"Row"]
["Analysis Count",2,"Number of analyses"]
["Dim Account Loc","Column"]
["Dim Analysis Loc","Row"]
["Dim Type Loc","Row"]
["Dim Time Loc","Row"]
["Adv Layout Setting",false]

{"sheet":"PGRA2","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"PGRA","index":5,"n_rows":203,"n_cols":4,"rows_kept":203,"cut":false,"hidden":false,"merged":[]}
["Analysis Settings"]
["Name","DBPath","DBName","TblName"]
["Base Case 2",null,null,"pgr_tbl_PGRA1"]
["Base Case",null,null,"pgr_tbl_PGRA2"]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]
[{"$f":"ROW(pgr_tbl_a[#This Row])-ROW(pgr_tbl_a[#Headers])","v":{"$error":"#VALUE!"}}]

{"sheet":"UserDetail","index":6,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["eyJhbGciOiJIUzUxMiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiJBdmlzaCBTaGFoIiwiZW1haWwiOiJhdmlzaHMzMGp1bHkyM0B5bWFpbC5jb20iLCJodHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL3dzLzIwMDgvMDYvaWRlbnRpdHkvY2xhaW1zL3JvbGUiOiJCdXNpbmVzcyIsIlJvbGVOYW1lIjoiQnVzaW5lc3MiLCJSb2xlSWQiOiIzIiwianRpIjoiOGE1ZDlmNWMtOWU2NS00MzY1LTk5OWQtZTc4N2U2MGZmOWU4IiwiZXhwIjoxNjc4NDY1NTM3LCJpc3MiOiJQR09FeGNlbEFkZEluQXBpIiwiYXVkIjoiUEdPRXhjZWxBZGRJbkFwaSJ9.yiNu0FXjEAtRvzPnO1Km_d39_KjGmXL6aAgVK53jFqH5cg4AjQSVHmEuerrr2mLZlg6_zq3P7o7za2F8Aw_R_Q"]