{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["OOP","AVERAGE","Text & Adding","Errors","CNF","CNF(2)","Other Peoples Worksheets","Dates"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"OOP","index":0,"n_rows":34,"n_cols":1,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Arithmetic operation signs in Excel:"]
[" ( ) represents Parentheses"]
[" ^ represents Exponents (powers and roots)"]
[" * represents Multiplication"]
[" /  represents Division"]
[" + represents Addition"]
[" – represents Subtraction"]
[]
["Order of Operations form Algebra class (Each one is left to right):"]
["Please è Parenthesis è ( )"]
["Excuse è Exponents è ^ è 2^2 = 4 or 4^(1/2) = 2"]
["My Dear è Multiplication è * and Division è /"]
["Aunt Sally è Adding (SUM) è + and Subtraction è -"]
[]
["Excel's Order of Operations:"]
["Parenthesis ( )"]
["Ranges use of colon symbol \":\""]
["Example: =SUM(A1:A4)"]
["Evaluate intersections (spaces (labels))"]
["(If you ever use labels or names for natural language formulas, or two ranges separated by a space)"]
["Evaluate unions (,)"]
["Example: =SUM(A1:A4,B2:C7)"]
["Negation (-)"]
["Example: =-2^4 è 16"]
["Example: =-(2^4) è -16"]
["Converts % (1% è .01)"]
["Exponents (^)"]
["Example 1: 4^(1/2) = 2"]
["Example: 3^2 = 9"]
["Multiplication (*) and division (/), left to right"]
["Adding (+) and subtraction (-), left to right"]
["Text operators (& è Concatenation)"]
["Comparative symbols: =, <>, >=, <=, <, >"]
["If anything is still left, then left to right"]

{"sheet":"AVERAGE","index":1,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
["Names","Test 1","Test 2","Test 3","Test 4","Test 5",null,"Find"]
["Ali Schudel",44,5,19,43,2]
["Un Adamis",42,52,12,17,13]
["Loria Tsutsui",0,0,57,2,14]
["Delsie Derick",4,56,7,54,19]
["Ji Jarrel",30,14,58,16,0]
["Carolin Benet",0,46,19,29,30]
["Bulah Euber",13,13,17,5,5]
["Armand Errington",22,15,0,46,29]
["Fidel Sivers",60,1,23,9,37]
["Ileen Shadid",3,38,10,44,0]
["Average"]
[]
["Names","Test 1","Test 2","Test 3","Test 4","Test 5",null,"Go To"]
["Ali Schudel",44,5,19,43,2]
["Un Adamis",42,52,12,17,13]
["Loria Tsutsui",null,null,57,2,14]
["Delsie Derick",4,56,7,54,19]
["Ji Jarrel",30,14,58,16]
["Carolin Benet",null,46,19,29,30]
["Bulah Euber",13,13,17,5,5]
["Armand Errington",22,15,null,46,29]
["Fidel Sivers",60,1,23,9,37]
["Ileen Shadid",3,38,10,44]
["Average"]

{"sheet":"Text & Adding","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Convert to Numbers w Text To Columns","Convert to Numbers w Paste Special Operations Add zero"]
[null,"Values1","Values2","Values2","Values2"]
[null,1,1,1,1]
[null,"1","1","1","1"]
[null,1,1,1,1]
[null,1,1,1,1]
[null,"1","1","1","1"]
[null,1,1,1,1]
[null,1,1,1,1]
[null,"1","1","1","1"]
[null,1,1,1,1]
[null,"1","1","1","1"]
[null,1,1,1,1]
["Add",{"$f":"SUM(B3:B13)","v":7}]

{"sheet":"Errors","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Error Message","Description of Error","Example","Example",null,"VLOOKUP TABLE"]
["#######","Column width not wide enough to display data (values), or negative date or time","The column that is narrower than the number it contains",101010101010,null,1,"Red"]
[{"$error":"#NAME?"},"Text that is not a \"name\" is being used in a formula","A formula like \"=red\" where red is not an Excel name",{"$f":"red","v":{"$error":"#NAME?"}},null,2,"Blue"]
[{"$error":"#N/A"},"Not Available/ No Answer","VLOOKUP function can not find an answer",{"$f":"VLOOKUP(E4,$F$2:$G$3,2)","v":{"$error":"#N/A"}}]
[{"$error":"#REF!"},"Formula is using cell reference that has been deleted, or other invalid cell reference","Formula said \"=A1\" then cell A1 was deleted.",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$error":"#VALUE!"},"Invalid operand or argument type (argument in a function)","The formula \"=F1:G2\" confused Excel because it does not know what to do with the \":\" (unless it was an array function).",{"$f":"F2:G3","v":{"$error":"#VALUE!"}},{"$f":"F3+G3","v":{"$error":"#VALUE!"}}]
[{"$error":"#NUM!"},"Invalid numeric values in a formula or function, or an iterative function like IRR cannot find an answer, or the number is too big or small (number must be between -1*10^307 and 1*10^307)","Formula entered was: \"=1*10^500\"",{"$f":"1*10^500","v":{"$error":"#NUM!"}}]
[{"$error":"#DIV/0!"},"Divide by zero","Dividing by zero is not defined because 4*? = 0",{"$f":"J7/E8","v":{"$error":"#DIV/0!"}}]
["Circular Cell Reference","Cell reference in formula refers to the formulas result (itself)","In cell D9 you type the formula: \"=J7+D9\""," =J7+D9",{"$f":"E8+E9","v":0}]
[{"$error":"#NULL!"},"No Intersection","No intersection: =E10:E12 C14:D14",{"$f":"E10:E11 C14:D14","v":{"$error":"#NULL!"}}]
[]
["For more about Circular References, see this video:"]
["Excel Magic Trick #214: Circular Reference in Formula"]

{"sheet":"CNF","index":4,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[{"$f":"ROW()&\")\"","v":"1)"},"Ctrl + 1 is the keyboard shortcut for the Format Cells Dialog Box"]
[{"$f":"ROW()&\")\"","v":"2)"},"The Number Tab has many EXCELlent number formats"]
["3)","The Custom section let's you create custom Number Formatting"]
["4)","Before the 1st semi-colon is how to display positive numbers"]
["5)","Before the 2nd semi-colon and after the 1st semi-colon is how to display negative numbers"]
["6)","Before the 3rd semi-colon and after the 2nd semi-colon is how to display zeros"]
["7)","After the 3rd semi-colon is whether or not and how to display text"]
["8)","If you just have formatting symbols before the 1st semi-colon, the formatting will apply to positive, negative and zero numbers and text will display"]
["9)","When General Number Format is applied, all Custom Number Formatting will be removed"]
["10)","The TEXT function converts a number to text with a Custom Number Format that you specify. TEXT(number, \"Custom Number Format in quotes\")"]
[]
["Symbol","Usage","Typed digits","Displayed value"]
["#","Digit placeholder that displays significant digits only; example ####.#",12.77,12.77]
[null,null,5,5]
[0,"Digit placeholder that displays significant and insignificant zeroes; example: 0.00",0.35,0.35]
[null,null,23,23]
[0,"Zeros before digit like 00345; example: 00000",345,345]
[0,"display many digits 0.000000000000000",".125489632586635",0.12548963258663501]
["?","Acts as a digit placeholder that does not display insignificant digits but does hold a place so that decimal points will align; example: 0.00?",27.3,27.3]
[null,null,5.1319999999999997,5.1319999999999997]
["?","Scoots the decimal over; example: 0.00????",27.3,27.3]
[null,null,5.1319999999999997,5.1319999999999997]
["%","Rules for formatting a % (times 100 and add symbol); example 0.00%",0.3,0.3]
[",","Inserts a comma for thousands; example: #,###",1000000,1000000]
[",","Use as a scaling operator; example #,,",1000000,1000000]
["*","Tells the cell to put enough of the character (space) after it to fill the column; example $* 0.00",548,548]
["*","Tells the cell to put enough of the character (^) after it to fill the column; example $*^0.01",548,548]
["_","Skip the width of the next character - often used with ) to help positive numbers align with negative numbers; example: _($* #,###0.00_);_($* (#,###0.00);_(* \"-\"??_);_(@_)",256.36,256.36]
["_","example: _($* #,###0.00_);_($* (#,###0.00);_(* \"-\"??_);_(@_)",-256.36,-256.36]
["_","example: _($* #,###0.00_);_($* (#,###0.00);_(* \"-\"??_);_(@_)",0,0]
[]
["\" \"","adds text; example: 0.00\" Rad\"",23,23]
["\" \"","\"surplus\";\"deficit\"",5,5]
[null,null,-10,-10]
["@","Indicates the location where text should be inserted in cells formatted with custom format; if the @ is not included in the code, the text will not be displayed; example: _($@_)","none","none"]
["@","Use formatting to hide words; example: 0.00;-0.00;\"--\";","none","none"]
["@","How to put a single character in front of a word; example: _(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(^@_)","rad","rad"]
["@","This scoots the text over one width of a parenthesis; example: _($* #,###0.00_);_($* (#,###0.00);_(* \"-\"??_);_(@_)","rad","rad"]
["d","day; example: dddd","2006-12-31","2006-12-31"]
["m","month; example: mmm.","2006-12-31","2006-12-31"]
["y","year; example: yy","2006-12-31","2006-12-31"]
["d","day; example: d","2006-12-31","2006-12-31"]
["m","month; example: m","2006-12-31","2006-12-31","Be careful ==>",{"$f":"12*D43","v":468984}]
["y","year; example: yyyy","2006-12-31","2006-12-31"]
["hh:mm:ss AM/PM","Time","08:00:00",{"$f":"C45","v":"08:00:00"}]
["[h]:mm","Show time greater than 24 hours",2,{"$f":"C46","v":2}]
["Note 1==>","If you specify only two formats, the first is used for positive and zero"]
["Note 2==>","If you specify only one formats, it is used for all numbers"]

{"sheet":"CNF(2)","index":5,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Time"]
["Time Greater than 24 hours"]
["Percents"]
["Fraction"]
["Words with numbers",null,null,null,null,null,"Assumptions"]
["Four Sections",null,null,null,null,null,"Start Date","2010-01-01",null,null,null,null,null,"Start Date"]
["Blank",null,null,null,null,null,"End Date",{"$f":"EOMONTH(H7,0)","v":40209},null,null,null,null,null,"2010-04-01"]
["General: keyboard: Ctrl + Shift + ~"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales"]
["Assumptions",null,null,"Date","MON?",null,"Date","Memo","Withdraw","Deposit","Balance",null,null,"Days","SR1","SR2","SR3","SR4","SR5"]
[35,null,null,"2010-04-22",null,null,"Bal",null,null,null,500,null,null,null,494,118,349,452,319]
[50,null,null,"2010-04-23",null,null,"2010-04-22",null,null,null,null,null,null,null,240,171,393,122,453]
[null,null,null,"2010-04-24",null,null,"2010-04-23",null,null,null,null,null,null,null,199,458,380,498,482]
["Units","Sales",null,"2010-04-25",null,null,"2010-04-24",null,null,null,null,null,null,null,187,329,474,246,323]
[0,null,null,"2010-04-26",null,null,null,null,null,null,null,null,null,null,162,484,252,374,221]
[null,null,null,"2010-04-27",null,null,null,null,null,null,null,null,null,null,399,332,124,142,304]
[null,null,null,"2010-04-28",null,null,null,null,null,null,null,null,null,null,190,427,423,232,182]
[null,null,null,"2010-04-29",null,null,null,null,null,null,null,null,null,null,363,121,138,122,259]
[null,null,null,"2010-04-30",null,null,null,null,null,null,null,null,null,null,245,257,157,376,121]
[null,null,null,"2010-05-01",null,null,null,null,null,null,null,null,null,null,490,467,320,272,181]
[null,null,null,"2010-05-02",null,null,null,null,null,null,null,null,null,null,114,378,469,273,393]
[null,null,null,"2010-05-03",null,null,null,null,null,null,null,null,null,null,130,239,261,109,472]
[null,null,null,"2010-05-04",null,null,null,null,null,null,null,null,null,null,164,299,171,167,318]
[null,null,null,"2010-05-05"]
[null,null,null,"2010-05-06"]

{"sheet":"Other Peoples Worksheets","index":6,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["2/1/2010",null,null,null,null,null,null,null,null,null,1]
[null,"Client 1","Client 2","Client 3","Client 4","Client 5",null,null,null,null,2]
["Jan",341,907,991,506,920,null,null,null,null,3]
["Feb",831,536,941,941,560,null,null,null,null,4]
["Mar",980,815,694,953,400,null,null,null,null,5]
["Apr",101,206,396,181,740,null,null,null,null,6]
["May",648,946,873,444,"772",null,null,null,null,7]
["Jun",551,391,179,970,"327",null,null,null,null,8]
["Jul",963,544,330,455,"211",null,null,null,null,9]
["Aug",142,834,573,338,"884"]
["Sep",950,529,615,758,"755"]
["Oct",846,830,803,525,"532"]
[null,{"$f":"B12+B11+B10+B9+B8+B7+B6+B5+B4+B3","v":6353},{"$f":"SUM(C4:C12)","v":5631},"=SUM(D3:D11)",{"$f":"SUM(E3:E12)","v":6071},{"$f":"SUM(F3:F12)","v":2620}]

{"sheet":"Dates","index":7,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Time In","Time Out","Time worked",null,"See this video:"]
["08:00:00","17:30:00",{"$f":"A2-B2","v":-0.39583333333333331},null,"Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negative Time) "]