{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Hide Macro Demo","Hide Macro Demo (2)","Sheet1","Sheet2"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Hide Macro Demo","index":0,"n_rows":28,"n_cols":5,"rows_kept":28}
[]
[null,"Directions"]
[null,"1. In the report, select a column that will act as the flag column to determine if the row will be hidden."]
[null,"In this example, column A contains a formula, where if the sum of the Actual and the Budget values are equal to 0, then it will flag the row to hide."]
[null,"2. The macro code is in \"This Workbook\" after hitting Alt+F11. It is hardcoded to column A and will loop through the first 1000 rows and hide rows flagged with \"!\"."]
[null,"Note that if the OSR_ReportComplete name is used, this macro will run automatically after a BI360 Report has been run."]
[]
[null,"You can demonstrate how the macro works by clicking the \"Run Macro\" button below."]
[null,"Reset the hidden rows by clicking the \"Reset\" button."]
[]
[]
[]
[]
[]
[null,"Account",null,"Actual","Budget"]
[{"$f":"IF(SUM($D16:$E16)=0,\"!\",\"\")","v":""},4000,null,0,1000]
[{"$f":"IF(SUM($D17:$E17)=0,\"!\",\"\")","v":""},{"$f":"B16+1","v":4001},null,3000,2500]
["!",{"$f":"B17+1","v":4002},null,0,0]
["",4003,null,2000,1900]
["",4004,null,100,0]
["!",4005,null,0,0]
["",4006,null,0,200]
["!",4007,null,0,0]
["",4008,null,300,1000]
["",4009,null,0,500]
["",4010,null,200,0]
["",4011,null,0,100]
["",4012,null,100,100]

{"sheet":"Hide Macro Demo (2)","index":1,"n_rows":28,"n_cols":5,"rows_kept":28}
[]
[null,"Directions"]
[null,"1. In the report, select a column that will act as the flag column to determine if the row will be hidden."]
[null,"In this example, column A contains a formula, where if the sum of the Actual and the Budget values are equal to 0, then it will flag the row to hide."]
[null,"2. The macro code is in \"This Workbook\" after hitting Alt+F11. It is hardcoded to column A and will loop through the first 1000 rows and hide rows flagged with \"!\"."]
[null,"Note that if the OSR_ReportComplete name is used, this macro will run automatically after a BI360 Report has been run."]
[]
[null,"You can demonstrate how the macro works by clicking the \"Run Macro\" button below."]
[null,"Reset the hidden rows by clicking the \"Reset\" button."]
[]
[]
[]
[]
[]
[null,"Account",null,"Actual","Budget"]
[{"$f":"IF(SUM($D16:$E16)=0,\"!\",\"\")","v":""},4000,null,0,1000]
[{"$f":"IF(SUM($D17:$E17)=0,\"!\",\"\")","v":""},{"$f":"B16+1","v":4001},null,3000,2500]
["!",{"$f":"B17+1","v":4002},null,0,0]
["",4003,null,2000,1900]
["",4004,null,100,0]
["!",4005,null,0,0]
["",4006,null,0,200]
["!",4007,null,0,0]
["",4008,null,300,1000]
["",4009,null,0,500]
["",4010,null,200,0]
["",4011,null,0,100]
["",4012,null,100,100]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Sheet2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}