{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Macro","Tab1","Tab2"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Macro","index":0,"n_rows":8,"n_cols":3,"rows_kept":8}
[]
[null,"Directions"]
[]
[null,"1.","In the report, select a cell that will act as the flag cell to determine if the sheet will be hidden."]
[null,null,"In this example, cell A1 contains a formula, where if the sum of the Actual and the Budget total values are equal to 0, then it will flag the sheet to hide."]
[null,null,"Note that Tab1 has data so it will not be hidden. Tab 2 does not have data so the flag in cell A1 shows \"!\" and will be hidden when the macro is run."]
[null,"2.","The macro code is in \"This Workbook\" after hitting Alt+F11. It is hardcoded to cell A1 and will loop through the tabs and hide ones flagged with \"!\"."]
[null,null,"Note that if the OSR_ReportComplete name is used, this macro will run automatically after a BI360 Report has been run."]

{"sheet":"Tab1","index":1,"n_rows":20,"n_cols":11,"rows_kept":20}
[{"$f":"IF(SUMSQ(I11:J11,I18:J18)<>0,\"\",\"!\")","v":""}]
[null,"Income Statement"]
[null,"Dept:",100]
[null,"Period:","2014-02-01"]
[{"$nulls":4},"Month-to-Date",{"$nulls":3},"Year-to-Date"]
[null,"Revenue",null,null,"Actual","Budget","Variance",null,"Actual","Budget","Variance"]
[null,4000,"Software Revenue",null,{"v":4886,"d":"4,886"},{"v":4934,"d":"4,934"},{"$f":"E7-F7","v":{"v":-48,"d":"(48)"}},null,{"v":13708,"d":"13,708"},{"v":13199,"d":"13,199"},{"$f":"I7-J7","v":509}]
[null,4010,"Service Revenue",null,{"v":7561,"d":"7,561"},{"v":6378,"d":"6,378"},{"$f":"E8-F8","v":{"v":1183,"d":"1,183"}},null,{"v":13510,"d":"13,510"},{"v":12743,"d":"12,743"},{"$f":"I8-J8","v":767}]
[null,4020,"Renewal Revenue",null,{"v":7477,"d":"7,477"},{"v":7891,"d":"7,891"},{"v":-414,"d":"(414)"},null,{"v":10123,"d":"10,123"},{"v":13675,"d":"13,675"},{"v":-3552,"d":"(3,552)"}]
[null,4030,"Other Revenue",null,{"v":5944,"d":"5,944"},{"v":4381,"d":"4,381"},{"v":1563,"d":"1,563"},null,{"v":12248,"d":"12,248"},{"v":8540,"d":"8,540"},{"v":3708,"d":"3,708"}]
[null,"Total Revenue",null,null,{"$f":"SUM(E7:E10)","v":{"v":25868,"d":"25,868"}},{"$f":"SUM(F7:F10)","v":{"v":23584,"d":"23,584"}},{"v":2284,"d":"2,284"},null,{"$f":"SUM(I7:I10)","v":{"v":49589,"d":"49,589"}},{"$f":"SUM(J7:J10)","v":{"v":48157,"d":"48,157"}},{"v":1432,"d":"1,432"}]
[]
[null,"Expenses"]
[null,6010,"Salary Expenses",null,3746,4845,{"$f":"F14-E14","v":{"v":1099,"d":"1,099"}},null,9710,8103,{"$f":"J14-I14","v":{"v":-1607,"d":"(1,607)"}}]
[null,6020,"Office Supplies",null,4042,4123,{"$f":"F15-E15","v":81},null,9862,7813,{"$f":"J15-I15","v":{"v":-2049,"d":"(2,049)"}}]
[null,6030,"Depreciation Expense",null,3087,3058,{"v":-29,"d":"(29)"},null,7592,8123,531]
[null,6040,"Other Expense",null,3830,3694,{"v":-136,"d":"(136)"},null,7731,7127,{"v":-604,"d":"(604)"}]
[null,"Total Expenses",null,null,{"$f":"SUM(E14:E17)","v":{"v":14705,"d":"14,705"}},{"$f":"SUM(F14:F17)","v":{"v":15720,"d":"15,720"}},{"v":1015,"d":"1,015"},null,{"$f":"SUM(I14:I17)","v":{"v":34895,"d":"34,895"}},{"$f":"SUM(J14:J17)","v":{"v":31166,"d":"31,166"}},{"v":-3729,"d":"(3,729)"}]
[]
[null,"Net Income",null,null,{"$f":"E11-E18","v":{"v":11163,"d":"11,163"}},{"$f":"F11-F18","v":{"v":7864,"d":"7,864"}},{"$f":"E20-F20","v":{"v":3299,"d":"3,299"}},null,{"$f":"I11-I18","v":{"v":14694,"d":"14,694"}},{"$f":"J11-J18","v":{"v":16991,"d":"16,991"}},{"$f":"I20-J20","v":{"v":-2297,"d":"(2,297)"}}]

{"sheet":"Tab2","index":2,"n_rows":20,"n_cols":11,"rows_kept":20}
[{"$f":"IF(SUMSQ(I11:J11,I18:J18)<>0,\"\",\"!\")","v":"!"}]
[null,"Income Statement"]
[null,"Dept:",100]
[null,"Period:","2014-02-01"]
[{"$nulls":4},"Month-to-Date",{"$nulls":3},"Year-to-Date"]
[null,"Revenue",null,null,"Actual","Budget","Variance",null,"Actual","Budget","Variance"]
[null,4000,"Software Revenue",null,0,0,{"$f":"E7-F7","v":0},null,0,0,{"$f":"I7-J7","v":0}]
[null,4010,"Service Revenue",null,0,0,{"$f":"E8-F8","v":0},null,0,0,{"$f":"I8-J8","v":0}]
[null,4020,"Renewal Revenue",null,0,0,0,null,0,0,0]
[null,4030,"Other Revenue",null,0,0,0,null,0,0,0]
[null,"Total Revenue",null,null,{"$f":"SUM(E7:E10)","v":0},{"$f":"SUM(F7:F10)","v":0},0,null,{"$f":"SUM(I7:I10)","v":0},{"$f":"SUM(J7:J10)","v":0},0]
[]
[null,"Expenses"]
[null,6010,"Salary Expenses",null,0,0,{"$f":"F14-E14","v":0},null,0,0,{"$f":"J14-I14","v":0}]
[null,6020,"Office Supplies",null,0,0,{"$f":"F15-E15","v":0},null,0,0,{"$f":"J15-I15","v":0}]
[null,6030,"Depreciation Expense",null,0,0,0,null,0,0,0]
[null,6040,"Other Expense",null,0,0,0,null,0,0,0]
[null,"Total Expenses",null,null,{"$f":"SUM(E14:E17)","v":0},{"$f":"SUM(F14:F17)","v":0},0,null,{"$f":"SUM(I14:I17)","v":0},{"$f":"SUM(J14:J17)","v":0},0]
[]
[null,"Net Income",null,null,{"$f":"E11-E18","v":0},{"$f":"F11-F18","v":0},{"$f":"E20-F20","v":0},null,{"$f":"I11-I18","v":0},{"$f":"J11-J18","v":0},{"$f":"I20-J20","v":0}]