{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Credit Control List"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Credit Control List","index":0,"n_rows":8,"n_cols":11,"rows_kept":8,"merged":[[0,1,0,6]]}
[null,"Credit Control List",{"$nulls":5},"Period from","date","to","date"]
[null," Account #"," Account Name","Date Opened","Credit Line","Credit Available","Credit Used","Current","30 days","60 days","90+ days"]
[{"$nulls":5},{"$f":"IFERROR(IF(Data[[#This Row],[Credit Line]]>0,Data[[#This Row],[Credit Line]]-Data[[#This Row],[Credit Used]],\"\"), \"\")","v":""},{"$f":"IFERROR(IF(Data[[#This Row],[Credit Line]]>0,SUM(Data[[#This Row],[Current]:[90+ days]]),\"\"), \"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(Data[[#This Row],[Credit Line]]>0,Data[[#This Row],[Credit Line]]-Data[[#This Row],[Credit Used]],\"\"), \"\")","v":""},{"$f":"IFERROR(IF(Data[[#This Row],[Credit Line]]>0,SUM(Data[[#This Row],[Current]:[90+ days]]),\"\"), \"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(Data[[#This Row],[Credit Line]]>0,Data[[#This Row],[Credit Line]]-Data[[#This Row],[Credit Used]],\"\"), \"\")","v":""},{"$f":"IFERROR(IF(Data[[#This Row],[Credit Line]]>0,SUM(Data[[#This Row],[Current]:[90+ days]]),\"\"), \"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(Data[[#This Row],[Credit Line]]>0,Data[[#This Row],[Credit Line]]-Data[[#This Row],[Credit Used]],\"\"), \"\")","v":""},{"$f":"IFERROR(IF(Data[[#This Row],[Credit Line]]>0,SUM(Data[[#This Row],[Current]:[90+ days]]),\"\"), \"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(Data[[#This Row],[Credit Line]]>0,Data[[#This Row],[Credit Line]]-Data[[#This Row],[Credit Used]],\"\"), \"\")","v":""},{"$f":"IFERROR(IF(Data[[#This Row],[Credit Line]]>0,SUM(Data[[#This Row],[Current]:[90+ days]]),\"\"), \"\")","v":""}]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,Data[Credit Line])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Data[Credit Available])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Data[Credit Used])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Data[Current])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Data[30 days])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Data[60 days])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Data[90+ days])","v":{"v":0,"d":"$0.00"}}]