{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["AFU","CO","Scenarios","CF(1)","CF(2)","Logical","CF(3)","CF(4)","CF(5)","CF(6)","DT","GS"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"AFU","index":0,"n_rows":106,"n_cols":3,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["Date","SalesRep","Sales"]
["2011-01-12","Gault",1271.47]
["2011-01-11","Smith",1673.3799999999999]
["2011-01-06","Franks",1349.5]
["2011-01-03","Gault",1415.4099999999999]
["2011-01-16","Franks",1271.47]
["2011-01-24","Pham",778.58999999999992]
["2011-01-10","Smith",298.87]
["2011-01-24","Smith",1511.4399999999998]
["2011-01-13","Gault",949.49999999999989]
["2011-01-25","Smith",493.73999999999995]
["2011-01-10","Pham",597.74]
["2011-01-29","Gault",1112.47]
["2011-01-17","Pham",1160.57]
["2011-01-03","Gault",971.64]
["2011-01-24","Franks",242.91]
["2011-01-23","Gault",1439.3999999999999]
["2011-01-20","Gault",146.92999999999998]
["2011-01-25","Sioux",1349.5]
["2011-01-15","Smith",383.84]
["2011-01-25","Gault",643.71999999999991]
["2011-01-06","Smith",1006.4699999999999]
["2011-01-24","Franks",1646.3899999999999]
["2011-01-23","Pham",482.77]
["2011-01-02","Sioux",303.83999999999997]
["2011-01-14","Chin",1160.57]
["2011-01-26","Franks",608.70999999999992]
["2011-01-13","Sioux",1439.3999999999999]
["2011-01-28","Franks",455.80999999999995]
["2011-01-14","Gault",782.70999999999992]
["2011-01-25","Gault",503.78999999999996]
["2011-01-20","Pham",643.71999999999991]
["2011-01-09","Franks",854.55]
["2011-01-25","Pham",296.89]
["2011-01-02","Sioux",1217.4199999999998]
["2011-01-05","Chin",1310.4299999999998]
["2011-01-05","Smith",818.6099999999999]
["2011-01-25","Chin",311.87]
["2011-01-05","Chin",1457.4599999999998]
["2011-01-09","Gault",239.89999999999998]
["2011-01-13","Pham",1177.3799999999999]
["2011-01-18","Pham",968.4899999999999]
["2011-01-12","Franks",505.78]
["2011-01-12","Sioux",1149.5]
["2011-01-10","Pham",215.91]
["2011-01-01","Franks",551.76]
["2011-01-17","Franks",1133.58]
["2011-01-02","Smith",390.83]
["2011-01-29","Smith",459.79999999999995]
["2011-01-26","Sioux",539.79999999999995]
["2011-01-13","Gault",208.89]
["2011-01-02","Chin",593.78]
["2011-01-23","Pham",436.80999999999995]
["2011-01-21","Gault",767.68]
["2011-01-08","Smith",701.74]
["2011-01-19","Franks",1538.4299999999998]
["2011-01-24","Pham",1082.4299999999998]
["2011-01-12","Chin",1592.4099999999999]
["2011-01-11","Smith",344.84999999999997]
["2011-01-23","Smith",1349.5]
["2011-01-23","Gault",608.70999999999992]
["2011-01-30","Smith",482.77]
["2011-01-05","Smith",229.89999999999998]
["2011-01-29","Sioux",759.59999999999991]
["2011-01-05","Sioux",482.77]
["2011-01-25","Pham",229.89999999999998]
["2011-01-17","Smith",1268.53]
["2011-01-22","Smith",1215.3599999999999]
["2011-01-30","Pham",229.89999999999998]
["2011-01-08","Smith",1448.37]
["2011-01-14","Gault",1195.48]
["2011-01-09","Smith",417.78]
["2011-01-22","Smith",550.70999999999992]
["2011-01-10","Gault",1149.5]
["2011-01-26","Sioux",1049.5]
["2011-01-14","Sioux",1151.52]
["2011-01-13","Pham",728.7299999999999]
["2011-01-12","Smith",137.94]
["2011-01-28","Pham",1487.3799999999999]
["2011-01-22","Sioux",239.89999999999998]
["2011-01-04","Gault",791.67]
["2011-01-26","Sioux",458.83]
["2011-01-19","Gault",229.89999999999998]
["2011-01-01","Smith",191.92]
["2011-01-06","Pham",629.69999999999993]
["2011-01-08","Sioux",527.78]
["2011-01-28","Smith",809.69999999999993]
["2011-01-12","Gault",1471.36]
["2011-01-10","Chin",1160.57]
["2011-01-28","Smith",1034.55]
["2011-01-22","Pham",1079.55]
["2011-01-25","Sioux",1044.4499999999998]
["2011-01-18","Smith",1177.3799999999999]
["2011-01-06","Gault",263.89]
["2011-01-26","Pham",458.83]
["2011-01-11","Chin",1310.4299999999998]
["2011-01-20","Franks",1215.3599999999999]
["2011-01-23","Gault",836.68999999999994]
["2011-01-20","Pham",440.78999999999996]
["2011-01-03","Pham",863.68]
["2011-01-05","Gault",1127.53]
["2011-01-11","Gault",436.80999999999995]
["2011-01-28","Chin",335.85999999999996]
["2011-01-05","Franks",265.85999999999996]
["2011-01-15","Pham",1484.4499999999998]
["2011-01-04","Sioux",702.63]

{"sheet":"CO","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Text cell content will be aligned Left"]
["Text in formulas must be in double quoates \"Text\""]
["COUNTIF uses Text for its comparative operators. For example: \">30\" or \">\"&D2"]
["Logical formulas do not use text for comparative operators"]
[]
[]
["DR","CR","Equal?",">?","DR = CR?",null,">1",1]
[1,1,null,null,null,null,"COUNTIF","SUMIF"]
[2.0099999999999998,2]
[23,23]
[]
["Date",null,"Year","Count"]
["2010-04-16",null,2010]
["2010-04-17"]
["2011-04-16"]
["2011-04-17"]

{"sheet":"Scenarios","index":2,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Budget"]
[null,"Jan","Feb","Mar","Apr","May","Jun","Total"]
["Revenue",1000,1250,1370,1250,2000,2215,{"$f":"SUM(B3:G3)","v":9085}]
[{"$f":"A14","v":"Expense1"},{"$f":"B$3*$B14","v":50},62.5,68.5,62.5,100,110.75,454.25]
["Expense2",75,93.75,102.75,93.75,150,166.125,681.375]
["Expense3",155,193.75,212.35,193.75,310,343.32499999999999,1408.175]
["Expense4",225,281.25,308.25,281.25,450,498.375,2044.125]
["Expense5",45,56.25,61.65,56.25,90,99.674999999999997,408.82499999999999]
["Expense6",120,150,164.4,150,240,{"$f":"G$3*$B19","v":265.8},1090.2]
["Total Expenses",{"$f":"SUM(B4:B9)","v":670},837.5,917.9,837.5,1340,1484.05,6086.95]
["Net Income",{"$f":"B3-B10","v":330},412.5,452.1,412.5,660,730.95,2998.05]
[]
["Assumptions - Formula Inputs"]
["Expense1",0.05]
["Expense2",7.4999999999999997E-2]
["Expense3",0.155]
["Expense4",0.22500000000000001]
["Expense5",4.4999999999999998E-2]
["Expense6",0.12]
[]
["Assumptions - Formula Inputs"]
["Expense1","Expense2","Expense3","Expense4","Expense5","Expense6"]
[0.05,7.4999999999999997E-2,0.155,0.22500000000000001,4.4999999999999998E-2,0.12]

{"sheet":"CF(1)","index":3,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Hilights Duplicates",null,"Above Average",null,"Top 10%",null,null,"Hilights Duplicates",null,null,"Above Average",null,null,"Top 20%"]
["Customer",null,"Sales",null,"Sales",null,null,"Customer",null,null,"Sales",null,null,"Sales"]
["Rod Kloer Firm",null,3.04,null,3.04,null,null,"Rod Kloer Firm",{"$f":"COUNTIF($A$3:$A$13,H3)>1","v":false},null,3.04,{"$f":"K3>AVERAGE($C$3:$C$13)","v":false},null,3.04,{"$f":"N3>_xlfn.PERCENTILE.EXC($E$3:$E$13,0.8)","v":false}]
["Hal Hinchliff Firm",null,19.41,null,19.41,null,null,"Hal Hinchliff Firm",true,null,19.41,true,null,19.41,true]
["Hal Hinchliff Firm",null,18.87,null,18.87,null,null,"Hal Hinchliff Firm",true,null,18.87,true,null,18.87,false]
["Shakia Warning Inc.",null,6.9,null,6.9,null,null,"Shakia Warning Inc.",false,null,6.9,false,null,6.9,false]
["Cliff Stalworth Firm",null,11.37,null,11.37,null,null,"Cliff Stalworth Firm",false,null,11.37,false,null,11.37,false]
["Jackson Kings LLP",null,18.89,null,18.89,null,null,"Jackson Kings LLP",true,null,18.89,true,null,18.89,true]
["Jackson Kings LLP",null,18.59,null,18.59,null,null,"Jackson Kings LLP",true,null,18.59,true,null,18.59,false]
["Rob Swearegene Company",null,7.36,null,7.36,null,null,"Rob Swearegene Company",false,null,7.36,false,null,7.36,false]
["Marcel Mittelsteadt Firm",null,13.05,null,13.05,null,null,"Marcel Mittelsteadt Firm",false,null,13.05,true,null,13.05,false]
["Rob Schiesher LLP",null,4.29,null,4.29,null,null,"Rob Schiesher LLP",false,null,4.29,false,null,4.29,false]
["Jackson Kings LLP",null,11.24,null,11.24,null,null,"Jackson Kings LLP",true,null,11.24,false,null,11.24,false]

{"sheet":"CF(2)","index":4,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Hilights Duplicates",null,"Above Average",null,"Top 10%",null,"Icons",null,"Data Bars"]
["Customer",null,"Sales",null,"Sales",null,"Sales",null,"Sales"]
["Rod Kloer Firm",null,3.04,null,3.04,null,3.04,null,3.04]
["Hal Hinchliff Firm",null,19.41,null,19.41,null,19.41,null,19.41]
["Hal Hinchliff Firm",null,18.87,null,18.87,null,18.87,null,18.87]
["Shakia Warning Inc.",null,6.9,null,6.9,null,6.9,null,6.9]
["Cliff Stalworth Firm",null,11.37,null,11.37,null,11.37,null,11.37]
["Jackson Kings LLP",null,18.89,null,18.89,null,18.89,null,18.89]
["Jackson Kings LLP",null,18.59,null,18.59,null,18.59,null,18.59]
["Rob Swearegene Company",null,7.36,null,7.36,null,7.36,null,7.36]
["Marcel Mittelsteadt Firm",null,13.05,null,13.05,null,13.05,null,13.05]
["Rob Schiesher LLP",null,4.29,null,4.29,null,4.29,null,4.29]
["Jackson Kings LLP",null,11.24,null,11.24,null,11.24,null,11.24]

{"sheet":"Logical","index":5,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Comparative Operators",null,"1st number","2nd number","Logical Formula Result","Logical Formula"]
[" > Greater Than",null,34,43,null,{"$f":"\" \"&_xll.FORMULATEXT(E2)","v":" "}]
[" >= Greater Than Or Equal To",null,34,34,null,{"$f":"\" \"&_xll.FORMULATEXT(E3)","v":" "}]
[" < Less Than",null,500,100,null,{"$f":"\" \"&_xll.FORMULATEXT(E4)","v":" "}]
[" <= Less Than Or Equal To",null,"Jo","Joe",null,{"$f":"\" \"&_xll.FORMULATEXT(E5)","v":" "}]
[" = Equal To",null,"Jo","Jo",null,{"$f":"\" \"&_xll.FORMULATEXT(E6)","v":" "}]
[" <> Not Equal To",null,"Jo","Jo",null,{"$f":"\" \"&_xll.FORMULATEXT(E7)","v":" "}]

{"sheet":"CF(3)","index":6,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Highlight Cell Based on another Cells Value"]
["Date to Highlight","2010-03-09"]
[]
["Date","Sales"]
["2011-03-07",8336,null,{"$f":"A5=$B$2","v":false}]
["2010-03-11",9894,null,false]
["2011-03-07",11686,null,false]
["2010-03-11",7599,null,false]
["2011-03-07",9609,null,false]
["2010-03-09",11210,null,true]
["2010-03-09",12561,null,true]
["2011-03-07",7125,null,false]
["2010-03-09",11140,null,true]

{"sheet":"CF(4)","index":7,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Highlight Whole Row for an exact value"]
["Date to Highlight","2011-03-07"]
[]
["Date","Sales"]
["2011-03-07",8336,null,{"$f":"$A5=$B$2","v":true},true]
["2010-03-11",9894,null,false,false]
["2011-03-07",11686,null,true,true]
["2010-03-11",7599,null,false,false]
["2011-03-07",9609,null,true,true]
["2010-03-09",11210,null,false,false]
["2010-03-09",12561,null,false,false]
["2011-03-07",7125,null,true,true]
["2010-03-09",11140,null,false,false]

{"sheet":"CF(5)","index":8,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Highlight Whole Row for an aproximate value"]
["Income",5555]
[]
["Upper Value For Tax","Tax Rate"]
[0,0,null,{"$f":"VLOOKUP($B$2,$A$5:$A$13,1)=$A5","v":false},false]
[500,5.0000000000000001E-3,null,false,false]
[1000,0.01,null,false,false]
[2000,1.2500000000000001E-2,null,false,false]
[3000,1.7500000000000002E-2,null,false,false]
[5000,0.02,null,true,true]
[10000,0.03,null,false,false]
[20000,0.04,null,false,false]
[30000,0.05,null,false,false]

{"sheet":"CF(6)","index":9,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,0,9,0]]}
[null,null,null,"Product Commission Rate"]
[null,null,null,{"$f":"IF(D3=$C$12,COUNTA($D3:D3)&\" column ====>>\",\"\")","v":""},{"$f":"IF(E3=$C$12,COUNTA($D3:E3)&\" column ====>>\",\"\")","v":""},{"$f":"IF(F3=$C$12,COUNTA($D3:F3)&\" column ====>>\",\"\")","v":""},{"$f":"IF(G3=$C$12,COUNTA($D3:G3)&\" column ====>>\",\"\")","v":"4 column ====>>"},{"$f":"IF(H3=$C$12,COUNTA($D3:H3)&\" column ====>>\",\"\")","v":""}]
[null,null,null,"Pro1","Pro2","Pro3","Pro4","Pro5"]
["Sales",{"$f":"IF(MATCH(C$13,$C$4:$C$10,1)=COUNT(C$4:C4),COUNT(C$4:C4)&\" row =>\",\"\")","v":""},0,{"$f":"(ROW()+COLUMN())/1000","v":8.0000000000000002E-3},8.9999999999999993E-3,0.01,1.0999999999999999E-2,1.2E-2]
[null,{"$f":"IF(MATCH(C$13,$C$4:$C$10,1)=COUNT(C$4:C5),COUNT(C$4:C5)&\" row =>\",\"\")","v":""},{"$f":"C4+1500","v":1500},8.9999999999999993E-3,0.01,1.0999999999999999E-2,1.2E-2,1.2999999999999999E-2]
[null,{"$f":"IF(MATCH(C$13,$C$4:$C$10,1)=COUNT(C$4:C6),COUNT(C$4:C6)&\" row =>\",\"\")","v":"3 row =>"},{"$f":"C5+1500","v":3000},0.01,1.0999999999999999E-2,1.2E-2,1.2999999999999999E-2,1.4E-2]
[null,{"$f":"IF(MATCH(C$13,$C$4:$C$10,1)=COUNT(C$4:C7),COUNT(C$4:C7)&\" row =>\",\"\")","v":""},4500,1.0999999999999999E-2,1.2E-2,1.2999999999999999E-2,1.4E-2,1.4999999999999999E-2]
[null,{"$f":"IF(MATCH(C$13,$C$4:$C$10,1)=COUNT(C$4:C8),COUNT(C$4:C8)&\" row =>\",\"\")","v":""},6000,1.2E-2,1.2999999999999999E-2,1.4E-2,1.4999999999999999E-2,1.6E-2]
[null,{"$f":"IF(MATCH(C$13,$C$4:$C$10,1)=COUNT(C$4:C9),COUNT(C$4:C9)&\" row =>\",\"\")","v":""},7500,1.2999999999999999E-2,1.4E-2,1.4999999999999999E-2,1.6E-2,1.7000000000000001E-2]
[null,{"$f":"IF(MATCH(C$13,$C$4:$C$10,1)=COUNT(C$4:C10),COUNT(C$4:C10)&\" row =>\",\"\")","v":""},9000,1.4E-2,1.4999999999999999E-2,1.6E-2,1.7000000000000001E-2,1.7999999999999999E-2]
[]
[null,"Pro","Pro4"]
[null,{"$f":"A4","v":"Sales"},4200]
[null,"Tax",{"$f":"INDEX(D4:H10,MATCH(C13,C4:C10),MATCH(C12,D3:H3,0))","v":1.2999999999999999E-2}]
[null,null,{"$f":"VLOOKUP(C13,C4:H10,MATCH(C12,C3:H3,0))","v":1.2999999999999999E-2}]
[]
[null,"column",{"$f":"MATCH(C12,D3:H3,0)","v":4}]
[null,"row",{"$f":"MATCH(C13,C4:C10)","v":3}]

{"sheet":"DT","index":10,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[{"$f":"ROWS(A$1:A1)&\")\"","v":"1)"},"Data Table 1 Variable"]
[{"$f":"ROWS(A$1:A2)&\")\"","v":"2)"},"Data Tables allow you to do what if analysis for 1 or more formulas by changing 1 variable that is present in the \"1 or more formulas\""]
[{"$f":"ROWS(A$1:A3)&\")\"","v":"3)"},"You must set up the inputs for the \"1 variable\" as row headers or column headers."]
[{"$f":"ROWS(A$1:A4)&\")\"","v":"4)"},"If your inputs are row headers, the formulas (or references to the formulas) must be listed at the top of the table area."]
[{"$f":"ROWS(A$1:A5)&\")\"","v":"5)"},"The formulas must refer to (directly or indirectly) the original input value cell that all the formulas at the top of the table use."]
[{"$f":"ROWS(A$1:A6)&\")\"","v":"6)"},"The upper left cell should be empty."]
[{"$f":"ROWS(A$1:A7)&\")\"","v":"7)"},"Highlight the empty cell, row headers, formulas and blank table area."]
[{"$f":"ROWS(A$1:A8)&\")\"","v":"8)"},"In Excel 2003, go to the Data menu, Tables"]
[{"$f":"ROWS(A$1:A9)&\")\"","v":"9)"},"In Excel 2007, go to the Data Ribbon, Data Tools group, what if analysis, Data Tables"]
[{"$f":"ROWS(A$1:A10)&\")\"","v":"10)"},"In the Data Table dialog box: \"Row input cells\" refers to the column headers (these are the values that sit in a row): what goes in this text box is the \"the original input value cell\";  \"Column input cells\" refers to the row headers (these are the values that sit in a column): what goes in this text box is the \"the original input value cell\"."]
[{"$f":"ROWS(A$1:A11)&\")\"","v":"11)"},"In Excel 2003, to See Precedents, go to the Tools menu, Formula Auditing, Trace Precedents. In Excel 2007, to See Precedents, go to the Formulas Ribbon, Formula Auditing group, Trace Precedents."]
[{"$f":"ROWS(A$1:A12)&\")\"","v":"12)"},"When you create a 1 variable or 2 variable Data Table, an array formula is entered that uses the array function TABLE. The first argument in the table function is the \"Row input cells\"; The second argument in the table function is the \"Column input cells\"."]
[{"$f":"ROWS(A$1:A13)&\")\"","v":"13)"},"Conditional Formatting is on the Home Ribbon in Excel 2007 and in the Formatting menu in Excel 2003. When you create a formula that evaluates to TRUE or False for Conditional Formatting, if you want the whole row to be highlighted: 1) be sure the active cell is in the upper left corner, 2) Lock the Column Reference only, not the Row reference."]
[]
[null,"Rad Corp.",null,null,null,"Units","Sales","Variable Costs","Contribution Margin","Net Income","Total Costs"]
[null,"Income Statement"]
[null,"June, 2008"]
[null,"Sales",{"$f":"C$27*C28","v":150000}]
[null,"Variable Costs",{"$f":"C$27*C29","v":68450}]
[null,"Contribution Margin",{"$f":"C18-C19","v":81550}]
[null,"Fixed Costs",{"$f":"C30","v":79250}]
[null,"Net Income",{"$f":"C20-C21","v":2300}]
[]
[null,"Total Costs",{"$f":"C21+C19","v":147700}]
[]
[null,"Assumptions"]
[null,"Units Sold",5000]
[null,"Price per Unit",30]
[null,"VariableCost per Unit",13.69]
[null,"Fixed Costs",79250]
[null,"Start Units Sold",0]
[null,"Increment Units Sold",1000]

{"sheet":"GS","index":11,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[{"$f":"ROW()&\")\"","v":"1)"},"In Excel 2003, Goal Seek is in the Tools menu. In Excel 2007, Goal Seek is in the Data Ribbon, Data Tools group, What-If Analysis icon. The keyboard shortcut that works for both is: Alt + T + G"]
[{"$f":"ROW()&\")\"","v":"2)"},"Goal Seek will change the formula result to a value you want by adjusting one of the formula input values."]
[{"$f":"ROW()&\")\"","v":"3)"},"\"Set cell\" must be the cell reference where the formula is; \"To value\" must be the value you want the formula to evaluate to; \"By changing cell\" must be a number (not a formula) that is in a cell and is used by the formula in the \"Set cell\" cell."]
[]
["Rad Corp."]
["Income Statement"]
["June, 2008"]
["Sales",{"$f":"B$17*B18","v":150000}]
["Variable Costs",{"$f":"B$17*B19","v":68450}]
["Contribution Margin",{"$f":"B8-B9","v":81550}]
["Fixed Costs",{"$f":"B20","v":79250}]
["Net Income",{"$f":"B10-B11","v":2300}]
[]
["Total Costs",{"$f":"B11+B9","v":147700}]
[]
["Assumptions"]
["Units Sold",5000]
["Price per Unit",30]
["VariableCost per Unit",13.69]
["Fixed Costs",79250]
["Start Units Sold",0]
["Increment Units Sold",1000]
[]
[]
["Loan",10000]
["Years",5]
["Months",{"$f":"B26*12","v":60}]
["Annual Rate",0.1]
["Monthly Rate",{"$f":"B28/12","v":8.3333333333333332E-3}]
["PMT",{"$f":"PMT(B29,B27,B25)","v":-212.47044711268276}]