{"text_format":"1","workbook":"xlsx","n_sheets":37,"sheets":["Topics","CF(1-5)","CF(6-7)","CF(8-11)","CF(12-13)","CF(14-15)","CF(16)","CF(17)","CF(18-21)","CF(22-23)","CF(24)","CF(25)","CF(26)","CF(27)","CF(28)","CF(29)","CF(30)","CF(31)","CF(32)","CF(33)","CF(34)","CF(35)","CF(36)","CF(37)","CF(38)","CF(39)","CF(40)","CF(41)","CF(42)","CF(43)","CF(44-45)","CF(46)","CF(47)","CF(48)","CF(49)","CF(50)","CF(51)"],"not_rendered":{"charts":1,"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":"Topics","index":0,"n_rows":71,"n_cols":2,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["Highline Excel 2013 Class Video 40:"]
["Conditional Formatting Basic To Advanced 50 Examples"]
[]
[null,"Topics:"]
[1,"Conditional Formatting to cells: A logical test that comes out TRUE or FALSE. TRUE = get Formatting. FALSE = Not get Formatting."]
[null,"Built-in Conditional Formatting"]
[null,"Highlight Cell Rules for different data types and comparative operators"]
[2,"Type in textbox: Greater than 1000"]
[3,"Type in textbox: Contains \"Fun\""]
[4,"Link textbox to cell: Greater than 1000"]
[5,"Link textbox to cell: Contains \"Fun\""]
[null,"Top Bottom Rules for numbers"]
[6,"Top 3"]
[7,"Above Average"]
[null,"Data Bars = Ranks the numbers with length of bar"]
[8,"Data Bar on top of numbers"]
[9,"Data bars in cell next to numbers. Also RANDBETWEEN Conditional Formatting."]
[10,"Manage Rules dialog Box"]
[11,"Manage Rule dialog box keyboard: Alt, O, D"]
[12,"Color scales = Ranks number by color."]
[13,"Fun with CF, RAND, and Bubble Chart"]
[null,"Icons = divides the numbers into 3, 4, or 5 groups (Top, middle, bottom)"]
[14,"Arrow Icons on top of numbers"]
[15,"Arrow Icons next to numbers"]
[16,"Logical Formulas:"]
[null,"Any formula that comes out TRUE or FALSE"]
[null,"TRUE = get Formatting. FALSE = Not get Formatting."]
[null,"FALSE = Not get Formatting."]
[null,"Array Formulas work in Conditional Formatting dialog box"]
[null,"Errors are ignored"]
[null,"Any non-zero number = TRUE"]
[null,"Zero = FALSE"]
[null,"This means the full list for what the formula can evaluate to and apply formatting is:"]
[null,"Get Formatting = TRUE or Any Non-Zero Number"]
[null,"NOT Get Formatting = FALSE or Zero or Error"]
[null,"Formula Examples:"]
[17,"Format number less than zero: 3 methods"]
[18,"Format Actual when Actual Exceeds Budgeted: 2 methods"]
[19,"Keyboard for New Format Rule dialog box: Alt, O, D, Alt + N    or   Alt, H, L, N"]
[20,"Keyboard to delete rule: Alt, O, D, D, Enter"]
[21,"Clear Content and CF still remains"]
[22,"Format cell based on a different cell's value: Format Net Sales based on date"]
[23,"Sort and CF will adjust"]
[24,"Format cell based on a different cell's value: Format Net Sales based on Invoice number"]
[25,"Format whole row based on date"]
[26,"Format whole row based on Invoice number"]
[27,"Format Row when Actual Exceeds Budgeted"]
[28,"Format whole column"]
[29,"Format cell based on OR criteria: OR function."]
[30,"Format cell based on OR criteria: MATCH function (Errors are ignored, Any non-zero number = TRUE)."]
[31,"Format whole row based on OR Criteria  (Errors are ignored, Any non-zero number = TRUE)."]
[32,"Format cell based on AND Criteria: Between Upper and Lower Date: AND Function."]
[33,"Format whole row based on between Date Criteria"]
[34,"Format whole row based on AND Criteria"]
[35,"Format whole row based on OR and AND Criteria"]
[36,"Format entire row when sales are above average"]
[37,"Format every other row with MOD function (1 = TRUE, 0 = FALSE)"]
[38,"Format Row In Checkbook when Reconciled"]
[39," Format Entire Row for the 3 Biggest Values"]
[40,"Format lowest Price in Row"]
[41,"Format intersecting cell"]
[42,"Format row based on Approximate Match based on VLOOKUP"]
[43,"Multiple Rules applied to each cell: Format row, column and intersection value"]
[44,"Gantt Chart for Days"]
[45,"Format Weekends and Holidays NOT WORKDAY.INTL NETWORKDAYS.INTL function"]
[46,"Format Duplicates Formula: 2 methods"]
[47,"Format items in List 2 that are NOT in List 1"]
[48,"Format items that are in List 2 that are also in List 1 (Errors are ignored, Any non-zero number = TRUE)."]
[49,"Format stocks with a loss"]
[50,"Format cells that are not empty, using COUNTA (Any non-zero number = TRUE, Zero = FALSE)"]
[51,"MAX For Seattle (Array Formulas work in Conditional Formatting dialog box)"]

{"sheet":"CF(1-5)","index":1,"n_rows":114,"n_cols":9,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
["Conditional Formatting to cells: A logical test that comes out TRUE or FALSE."]
["TRUE = the cell gets the formatting"]
["FALSE = the cell does NOT get the formatting"]
[]
["Highlight Cell Rules for different data types and comparative operators"]
[]
[null,null,null,null,null,"Greater than",1000]
[null,null,null,null,null,"Contains","Fun"]
[]
["Date","Product","Net Sales","Cost",null,"Date","Product","Net Sales","Cost"]
["2013-01-01","Quad",1232.44,591.58000000000004,null,"2013-01-01","Quad",1232.44,591.58000000000004]
["2013-01-02","V-Rang",1000,212.08,null,"2013-01-02","V-Rang",1000,212.08]
["2013-01-02","Carlota",357.5,193.06,null,"2013-01-02","Carlota",357.5,193.06]
["2013-01-02","Darnell",1957.6,1037.55,null,"2013-01-02","Darnell",1957.6,1037.55]
["2013-01-03","Quad",561.67999999999995,303.31,null,"2013-01-03","Quad",561.67999999999995,303.31]
["2013-01-03","Fun Fly",1980,990,null,"2013-01-03","Fun Fly",1980,990]
["2013-01-04","Quad",2772,1469.16,null,"2013-01-04","Quad",2772,1469.16]
["2013-01-05","Quad",4536,2358.7199999999998,null,"2013-01-05","Quad",4536,2358.7199999999998]
["2013-01-05","Bellen",503.1,251.56,null,"2013-01-05","Bellen",503.1,251.56]
["2013-01-05","Fun Rang",3938.4,1890.4,null,"2013-01-05","Fun Rang",3938.4,1890.4]
["2013-01-05","Bellen",464.96,237.12,null,"2013-01-05","Bellen",464.96,237.12]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Criteria:"]
["Net Sales","Product"]
[1000,"Fun"]
[]
[]
["Invoice","Date","Company","Product","Net Sales","Cost"]
[659439,"2013-01-01","Gel Booms","Quad",1232.44,591.58000000000004]
[659440,"2013-01-02","Tri Fly","V-Rang",451.2,212.08]
[659440,"2013-01-02","Gel Booms","Carlota",357.5,193.06]
[659440,"2013-01-02","Tri Fly","Darnell",1957.6,1037.55]
[659441,"2013-01-03","Gel Booms","Quad",561.67999999999995,303.31]
[659441,"2013-01-03","Gel Booms","Carlota",1980,990]
[659442,"2013-01-04","Gel Booms","Quad",2772,1469.16]
[659443,"2013-01-05","Gel Booms","Quad",4536,2358.7199999999998]
[659443,"2013-01-05","Gel Booms","Bellen",503.1,251.56]
[659444,"2013-01-05","Tri Fly","Darnell",3938.4,1890.4]
[659444,"2013-01-05","Gel Booms","Bellen",464.96,237.12]
[659445,"2013-01-05","Gel Booms","Carlota",1650,792]
[659445,"2013-01-05","Colorad Boom","Yanaki",114,55.86]
[659446,"2013-01-05","Colorad Boom","Mt. Fun",1008.72,504.36]
[659446,"2013-01-05","Colorad Boom","Yanaki",730.2,365.1]
[659446,"2013-01-05","Gel Booms","Sunset",3174,1713.96]
[659446,"2013-01-05","Gel Booms","Quad",2304,1082.8800000000001]
[659446,"2013-01-05","Gel Booms","Quad",2744.98,1317.61]
[659446,"2013-01-05","Gel Booms","Quad",3361.2,1579.75]
[659447,"2013-01-05","Colorad Boom","Aspen",48.48,25.2]
[659447,"2013-01-05","Colorad Boom","Crest",1664,881.92]
[659448,"2013-01-06","Colorad Boom","Yanaki",670.4,355.28]
[659449,"2013-01-07","Gel Booms","Sunset",611.41999999999996,324.06]
[659450,"2013-01-08","Gel Booms","Quad",962.88,510.32]
[659451,"2013-01-09","Tri Fly","V-Rang",203.04,95.4]
[659451,"2013-01-09","Tri Fly","Fun Fly",256.2,140.9]
[659452,"2013-01-10","Colorad Boom","Aspen",1360,639.20000000000005]
[659453,"2013-01-10","Tri Fly","FastFly",4309.2,2326.9499999999998]
[659453,"2013-01-10","Tri Fly","V-Rang",241.28,132.72]
[659454,"2013-01-11","Colorad Boom","Mt. Fun",1672,819.28]
[659455,"2013-01-11","Gel Booms","Bellen",2631.6,1421.04]
[659455,"2013-01-11","Colorad Boom","Yanaki",368.72,188.04]
[659455,"2013-01-11","Colorad Boom","Aspen",1632,767.04]
[659455,"2013-01-11","Colorad Boom","Yanaki",670.4,341.92]
[659455,"2013-01-11","Tri Fly","Fun Fly",39.04,19.52]
[659455,"2013-01-11","Tri Fly","V-Rang",394.8,197.4]
[659455,"2013-01-11","Colorad Boom","Yanaki",219.06,118.3]
[659455,"2013-01-11","Gel Booms","Quad",200.6,106.32]
[659456,"2013-01-12","Gel Booms","Sunset",1150,552]
[659456,"2013-01-12","Colorad Boom","Mt. Fun",495,237.6]
[659456,"2013-01-12","Tri Fly","Fun Fly",51.24,27.16]
[659457,"2013-01-12","Tri Fly","Fun Fly",40.26,21.33]
[659457,"2013-01-12","Colorad Boom","Aspen",60.6,28.5]
[659457,"2013-01-12","Colorad Boom","Yanaki",2394,1292.76]
[659458,"2013-01-13","Tri Fly","Fun Fly",207.36,107.82]
[659458,"2013-01-13","Tri Fly","FastFly",1316.7,618.84]
[659459,"2013-01-14","Tri Fly","Fun Fly",183,95.2]

{"sheet":"CF(6-7)","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Top Bottom Rules for numbers"]
["Top 3",null,null,null,null,null,null,"Above Average"]
[]
["Date","Product","Net Sales","Cost",null,"Date","Product","Net Sales","Cost"]
["2013-01-01","Quad",1232.44,591.58000000000004,null,"2013-01-01","Quad",1232.44,591.58000000000004]
["2013-01-02","V-Rang",1000,212.08,null,"2013-01-02","V-Rang",1000,212.08]
["2013-01-02","Carlota",357.5,193.06,null,"2013-01-02","Carlota",357.5,193.06]
["2013-01-02","Darnell",1957.6,1037.55,null,"2013-01-02","Darnell",1957.6,1037.55]
["2013-01-03","Quad",561.67999999999995,303.31,null,"2013-01-03","Quad",561.67999999999995,303.31]
["2013-01-03","Fun Fly",1980,990,null,"2013-01-03","Fun Fly",1980,990]
["2013-01-04","Quad",2772,1469.16,null,"2013-01-04","Quad",2772,1469.16]
["2013-01-05","Quad",4536,2358.7199999999998,null,"2013-01-05","Quad",4536,2358.7199999999998]
["2013-01-05","Bellen",503.1,251.56,null,"2013-01-05","Bellen",503.1,251.56]
["2013-01-05","Fun Rang",3938.4,1890.4,null,"2013-01-05","Fun Rang",3938.4,1890.4]
["2013-01-05","Bellen",464.96,237.12,null,"2013-01-05","Bellen",464.96,237.12]

{"sheet":"CF(8-11)","index":3,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Data Bars = Ranks the numbers with length of bar"]
["Data Bar on top of numbers"]
["Data bars in cell next to numbers"]
[]
["Grades",null,null,"Grades","Chart",null,"Grades","Chart"]
[19,null,null,19,{"$f":"D6","v":19},null,{"$f":"RANDBETWEEN(0,100)","v":75},{"$f":"G6","v":75}]
[76,null,null,76,76,null,0,0]
[23,null,null,23,23,null,82,82]
[92,null,null,92,92,null,41,41]
[73,null,null,73,73,null,56,56]
[92,null,null,92,92,null,39,39]
[36,null,null,36,36,null,23,23]
[59,null,null,59,59,null,70,70]
[81,null,null,81,81,null,15,15]
[98,null,null,98,98,null,70,70]

{"sheet":"CF(12-13)","index":4,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Color scales = Ranks number by color."]
[]
["Grades"]
[19,null,null,{"$f":"RAND()","v":0.46315109553532052},0.13340332460749593,1.6758901660998804E-2,0.96231871646972877,0.38461496272175599,3.1143211610893284E-2,0.54368028956116343]
[76,null,null,0.4466353325753426,0.82679250025647322,0.81986066424478654,0.28497438706746347,0.56182966982824534,0.33275700070705039,0.30366662388505683]
[23,null,null,0.32736840437424997,0.48367094696177892,0.46591936530244238,5.2068934572163439E-2,0.14170267693432925,0.75504716066433053,0.25442949788075919]
[92,null,null,0.81260272494623698,0.49388926876300332,0.99667712967113475,0.47107233548214922,0.87408867255386302,0.76054542272527093,0.49624185334448256]
[73,null,null,0.97423638908700538,0.97548020638697319,0.49730866799639617,0.40542652062054463,0.13878730192057365,0.1430000347290562,0.2188024729705792]
[92,null,null,0.14783307612669949,0.73599961488755739,0.6640050968443173,0.52263076275219356,0.96278259537780431,0.8650574548267419,0.8061397096398556]
[36,null,null,0.25438556315525596,0.89603987156481391,0.33160427601233189,0.7735989798795726,0.84664614433274687,3.6568902694563921E-2,0.69023886471456686]
[59,null,null,0.79613657763726198,0.74416145835828529,0.78042582378872605,0.40634069009412921,0.22148165026075761,0.71695470747097056,0.52952064153046852]
[81,null,null,0.716396063016986,0.64219175202067535,0.60446120279865512,0.40351336402296434,0.97749781212350328,0.85918295273620271,0.89722983279376878]
[98]

{"sheet":"CF(14-15)","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Icons = divides the numbers into 3, 4, or 5 groups (Top, middle, bottom)"]
[]
[]
["Grades",null,"Grades","Category"]
[19,null,19,{"$f":"C5","v":19}]
[76,null,76,76]
[23,null,23,23]
[92,null,92,92]
[73,null,73,73]
[92,null,92,92]
[36,null,36,36]
[59,null,59,59]
[81,null,81,81]
[98,null,98,98]

{"sheet":"CF(16)","index":6,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[13,"Logical Formulas:"]
[null,"Any formula that comes out TRUE or FALSE"]
[null,"TRUE = get Formatting. FALSE = Not get Formatting."]
[null,"FALSE = Not get Formatting."]
[null,"Array Formulas work in Conditional Formatting dailog box"]
[null,"Errors are ignored"]
[null,"Any non-zero number = TRUE"]
[null,"Zero = FALSE"]
[null,"This means the full list for what the formula can evaluate to and apply formatting is:"]
[null,"Get Formatting = TRUE or Any Non-Zero Number"]
[null,"NOT Get Formatting = FALSE or Zero or Error"]

{"sheet":"CF(17)","index":7,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Format number less than zero: 3 methods"]
[]
["Stock","Buy Price","Price today","Quantity","Profit"]
["GOOG",755,1015,700,{"$f":"D4*(C4-B4)","v":182000}]
["GE",22,29.1,2200,15620.000000000004]
["KO",36,37,300,300]
["MSFT",36,36,4000,0]
["KK",51,42,700,-6300]
["SW",31,17,400,-5600]
[]
[null,null,null,null,"OR:"]
[]
["Stock","Buy Price","Price today","Quantity","Profit",null,"Value:"]
["GOOG",755,1015,700,{"$f":"D14*(C14-B14)","v":182000},null,0]
["GE",22,29.1,2200,15620.000000000004]
["KO",36,37,300,300]
["MSFT",36,36,4000,0]
["KK",51,42,700,-6300]
["SW",31,17,400,-5600]
[]
[null,null,null,null,"OR:"]
[]
["Stock","Buy Price","Price today","Quantity","Profit",null,"Value:"]
["GOOG",755,1015,700,{"$f":"D24*(C24-B24)","v":182000},null,0,null,{"$f":"E24<$G$24","v":false}]
["GE",22,29.1,2200,15620.000000000004,null,null,null,{"$f":"E25<$G$24","v":false}]
["KO",36,37,300,300,null,null,null,false]
["MSFT",36,36,4000,0,null,null,null,false]
["KK",51,42,700,-6300,null,null,null,true]
["SW",31,17,400,-5600,null,null,null,true]

{"sheet":"CF(18-21)","index":8,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Format Actual when Actual Exceeds Budgeted: 2 methods"]
[]
["Expense","Budgeted Amount","Actual"]
["Rent",15000,15000]
["Operations",195500,215809.25]
["Administration",59800,59852.11]
["COGS",356500,345089.25]
["Wage",159000,149087.25]
["Depr",105000,105000]
["Other",7500,65809.25]
[]
["Expense","Budgeted Amount","Actual"]
["Rent",15000,15000,null,{"$f":"C13>B13","v":false}]
["Operations",195500,215809.25,null,{"$f":"C14>B14","v":true}]
["Administration",59800,59852.11,null,true]
["COGS",356500,345089.25,null,false]
["Wage",159000,149087.25,null,false]
["Depr",105000,105000,null,false]
["Other",7500,65809.25,null,true]

{"sheet":"CF(22-23)","index":9,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Format cell based on a different cell's value: Format Net Sales based on date"]
[]
["Date"]
["2013-01-05"]
[]
["Invoice","Date","Company","Product","Net Sales","Cost"]
[659443,"2013-01-05","Gel Booms","Quad",4536,2358.7199999999998]
[659453,"2013-01-10","Tri Fly","FastFly",4309.2,2326.9499999999998]
[659444,"2013-01-05","Tri Fly","Darnell",3938.4,1890.4]
[659446,"2013-01-05","Gel Booms","Quad",3361.2,1579.75]
[659446,"2013-01-05","Gel Booms","Sunset",3174,1713.96]
[659442,"2013-01-04","Gel Booms","Quad",2772,1469.16]
[659446,"2013-01-05","Gel Booms","Quad",2744.98,1317.61]
[659455,"2013-01-11","Gel Booms","Bellen",2631.6,1421.04]
[659457,"2013-01-12","Colorad Boom","Yanaki",2394,1292.76]
[659446,"2013-01-05","Gel Booms","Quad",2304,1082.8800000000001]
[659441,"2013-01-03","Gel Booms","Carlota",1980,990]
[659440,"2013-01-02","Tri Fly","Darnell",1957.6,1037.55]
[659454,"2013-01-11","Colorad Boom","Mt. Fun",1672,819.28]
[659447,"2013-01-05","Colorad Boom","Crest",1664,881.92]
[659445,"2013-01-05","Gel Booms","Carlota",1650,792]
[659455,"2013-01-11","Colorad Boom","Aspen",1632,767.04]
[659452,"2013-01-10","Colorad Boom","Aspen",1360,639.20000000000005]
[659458,"2013-01-13","Tri Fly","FastFly",1316.7,618.84]
[659439,"2013-01-01","Gel Booms","Quad",1232.44,591.58000000000004]
[659456,"2013-01-12","Gel Booms","Sunset",1150,552]
[659446,"2013-01-05","Colorad Boom","Mt. Fun",1008.72,504.36]
[659450,"2013-01-08","Gel Booms","Quad",962.88,510.32]
[659446,"2013-01-05","Colorad Boom","Yanaki",730.2,365.1]
[659448,"2013-01-06","Colorad Boom","Yanaki",670.4,355.28]
[659455,"2013-01-11","Colorad Boom","Yanaki",670.4,341.92]
[659449,"2013-01-07","Gel Booms","Sunset",611.41999999999996,324.06]
[659441,"2013-01-03","Gel Booms","Quad",561.67999999999995,303.31]
[659443,"2013-01-05","Gel Booms","Bellen",503.1,251.56]
[659456,"2013-01-12","Colorad Boom","Mt. Fun",495,237.6]
[659444,"2013-01-05","Gel Booms","Bellen",464.96,237.12]
[659440,"2013-01-02","Tri Fly","V-Rang",451.2,212.08]
[659455,"2013-01-11","Tri Fly","V-Rang",394.8,197.4]
[659455,"2013-01-11","Colorad Boom","Yanaki",368.72,188.04]
[659440,"2013-01-02","Gel Booms","Carlota",357.5,193.06]
[659451,"2013-01-09","Tri Fly","Fun Fly",256.2,140.9]
[659453,"2013-01-10","Tri Fly","V-Rang",241.28,132.72]
[659455,"2013-01-11","Colorad Boom","Yanaki",219.06,118.3]
[659458,"2013-01-13","Tri Fly","Fun Fly",207.36,107.82]
[659451,"2013-01-09","Tri Fly","V-Rang",203.04,95.4]
[659455,"2013-01-11","Gel Booms","Quad",200.6,106.32]
[659459,"2013-01-14","Tri Fly","Fun Fly",183,95.2]
[659445,"2013-01-05","Colorad Boom","Yanaki",114,55.86]
[659457,"2013-01-12","Colorad Boom","Aspen",60.6,28.5]
[659456,"2013-01-12","Tri Fly","Fun Fly",51.24,27.16]
[659447,"2013-01-05","Colorad Boom","Aspen",48.48,25.2]
[659457,"2013-01-12","Tri Fly","Fun Fly",40.26,21.33]
[659455,"2013-01-11","Tri Fly","Fun Fly",39.04,19.52]

{"sheet":"CF(24)","index":10,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Format cell based on a different cell's value: Format Net Sales based on Invoice number"]
[]
["Invoice"]
[659440]
[]
["Invoice","Date","Company","Product","Net Sales","Cost"]
[659439,"2013-01-01","Gel Booms","Quad",1232.44,591.58000000000004]
[659440,"2013-01-02","Tri Fly","V-Rang",451.2,212.08]
[659440,"2013-01-02","Gel Booms","Carlota",357.5,193.06]
[659440,"2013-01-02","Tri Fly","Darnell",1957.6,1037.55]
[659441,"2013-01-03","Gel Booms","Quad",561.67999999999995,303.31]
[659441,"2013-01-03","Gel Booms","Carlota",1980,990]
[659442,"2013-01-04","Gel Booms","Quad",2772,1469.16]
[659443,"2013-01-05","Gel Booms","Quad",4536,2358.7199999999998]
[659443,"2013-01-05","Gel Booms","Bellen",503.1,251.56]
[659444,"2013-01-05","Tri Fly","Darnell",3938.4,1890.4]
[659444,"2013-01-05","Gel Booms","Bellen",464.96,237.12]
[659445,"2013-01-05","Gel Booms","Carlota",1650,792]
[659445,"2013-01-05","Colorad Boom","Yanaki",114,55.86]
[659446,"2013-01-05","Colorad Boom","Mt. Fun",1008.72,504.36]
[659446,"2013-01-05","Colorad Boom","Yanaki",730.2,365.1]
[659446,"2013-01-05","Gel Booms","Sunset",3174,1713.96]
[659446,"2013-01-05","Gel Booms","Quad",2304,1082.8800000000001]
[659446,"2013-01-05","Gel Booms","Quad",2744.98,1317.61]
[659446,"2013-01-05","Gel Booms","Quad",3361.2,1579.75]
[659447,"2013-01-05","Colorad Boom","Aspen",48.48,25.2]
[659447,"2013-01-05","Colorad Boom","Crest",1664,881.92]
[659448,"2013-01-06","Colorad Boom","Yanaki",670.4,355.28]
[659449,"2013-01-07","Gel Booms","Sunset",611.41999999999996,324.06]
[659450,"2013-01-08","Gel Booms","Quad",962.88,510.32]
[659451,"2013-01-09","Tri Fly","V-Rang",203.04,95.4]
[659451,"2013-01-09","Tri Fly","Fun Fly",256.2,140.9]
[659452,"2013-01-10","Colorad Boom","Aspen",1360,639.20000000000005]
[659453,"2013-01-10","Tri Fly","FastFly",4309.2,2326.9499999999998]
[659453,"2013-01-10","Tri Fly","V-Rang",241.28,132.72]
[659454,"2013-01-11","Colorad Boom","Mt. Fun",1672,819.28]
[659455,"2013-01-11","Gel Booms","Bellen",2631.6,1421.04]
[659455,"2013-01-11","Colorad Boom","Yanaki",368.72,188.04]
[659455,"2013-01-11","Colorad Boom","Aspen",1632,767.04]
[659455,"2013-01-11","Colorad Boom","Yanaki",670.4,341.92]
[659455,"2013-01-11","Tri Fly","Fun Fly",39.04,19.52]
[659455,"2013-01-11","Tri Fly","V-Rang",394.8,197.4]
[659455,"2013-01-11","Colorad Boom","Yanaki",219.06,118.3]
[659455,"2013-01-11","Gel Booms","Quad",200.6,106.32]
[659456,"2013-01-12","Gel Booms","Sunset",1150,552]
[659456,"2013-01-12","Colorad Boom","Mt. Fun",495,237.6]
[659456,"2013-01-12","Tri Fly","Fun Fly",51.24,27.16]
[659457,"2013-01-12","Tri Fly","Fun Fly",40.26,21.33]
[659457,"2013-01-12","Colorad Boom","Aspen",60.6,28.5]
[659457,"2013-01-12","Colorad Boom","Yanaki",2394,1292.76]
[659458,"2013-01-13","Tri Fly","Fun Fly",207.36,107.82]
[659458,"2013-01-13","Tri Fly","FastFly",1316.7,618.84]
[659459,"2013-01-14","Tri Fly","Fun Fly",183,95.2]

{"sheet":"CF(25)","index":11,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Format whole row based on date"]
[]
["Date"]
["2013-01-05"]
[]
["Invoice","Date","Company","Product","Net Sales","Cost",null,"Invoice","Date","Company","Product","Net Sales","Cost"]
[659455,"2013-01-11","Tri Fly","Fun Fly",39.04,19.52,null,{"$f":"$B7=$A$4","v":false},{"$f":"$B7=$A$4","v":false},false,false,false,false]
[659457,"2013-01-12","Tri Fly","Fun Fly",40.26,21.33,null,{"$f":"$B8=$A$4","v":false},false,false,false,false,false]
[659447,"2013-01-05","Colorad Boom","Aspen",48.48,25.2,null,true,true,true,true,true,true]
[659456,"2013-01-12","Tri Fly","Fun Fly",51.24,27.16,null,false,false,false,false,false,false]
[659457,"2013-01-12","Colorad Boom","Aspen",60.6,28.5,null,false,false,false,false,false,false]
[659445,"2013-01-05","Colorad Boom","Yanaki",114,55.86,null,true,true,true,true,true,true]
[659459,"2013-01-14","Tri Fly","Fun Fly",183,95.2,null,false,false,false,false,false,false]
[659451,"2013-01-09","Tri Fly","V-Rang",203.04,95.4,null,false,false,false,false,false,false]
[659455,"2013-01-11","Gel Booms","Quad",200.6,106.32,null,false,false,false,false,false,false]
[659458,"2013-01-13","Tri Fly","Fun Fly",207.36,107.82,null,false,false,false,false,false,false]
[659455,"2013-01-11","Colorad Boom","Yanaki",219.06,118.3,null,false,false,false,false,false,false]
[659453,"2013-01-10","Tri Fly","V-Rang",241.28,132.72,null,false,false,false,false,false,false]
[659451,"2013-01-09","Tri Fly","Fun Fly",256.2,140.9,null,false,false,false,false,false,false]
[659455,"2013-01-11","Colorad Boom","Yanaki",368.72,188.04,null,false,false,false,false,false,false]
[659440,"2013-01-02","Gel Booms","Carlota",357.5,193.06,null,false,false,false,false,false,false]
[659455,"2013-01-11","Tri Fly","V-Rang",394.8,197.4,null,false,false,false,false,false,false]
[659440,"2013-01-02","Tri Fly","V-Rang",451.2,212.08,null,false,false,false,false,false,false]
[659444,"2013-01-05","Gel Booms","Bellen",464.96,237.12,null,true,true,true,true,true,true]
[659456,"2013-01-12","Colorad Boom","Mt. Fun",495,237.6,null,false,false,false,false,false,false]
[659443,"2013-01-05","Gel Booms","Bellen",503.1,251.56,null,true,true,true,true,true,true]
[659441,"2013-01-03","Gel Booms","Quad",561.67999999999995,303.31,null,false,false,false,false,false,false]
[659449,"2013-01-07","Gel Booms","Sunset",611.41999999999996,324.06,null,false,false,false,false,false,false]
[659455,"2013-01-11","Colorad Boom","Yanaki",670.4,341.92,null,false,false,false,false,false,false]
[659448,"2013-01-06","Colorad Boom","Yanaki",670.4,355.28,null,false,false,false,false,false,false]
[659446,"2013-01-05","Colorad Boom","Yanaki",730.2,365.1,null,true,true,true,true,true,true]
[659446,"2013-01-05","Colorad Boom","Mt. Fun",1008.72,504.36,null,true,true,true,true,true,true]
[659450,"2013-01-08","Gel Booms","Quad",962.88,510.32,null,false,false,false,false,false,false]
[659456,"2013-01-12","Gel Booms","Sunset",1150,552,null,false,false,false,false,false,false]
[659439,"2013-01-01","Gel Booms","Quad",1232.44,591.58000000000004,null,false,false,false,false,false,false]
[659458,"2013-01-13","Tri Fly","FastFly",1316.7,618.84,null,false,false,false,false,false,false]
[659452,"2013-01-10","Colorad Boom","Aspen",1360,639.20000000000005,null,false,false,false,false,false,false]
[659455,"2013-01-11","Colorad Boom","Aspen",1632,767.04,null,false,false,false,false,false,false]
[659445,"2013-01-05","Gel Booms","Carlota",1650,792,null,true,true,true,true,true,true]
[659454,"2013-01-11","Colorad Boom","Mt. Fun",1672,819.28,null,false,false,false,false,false,false]
[659447,"2013-01-05","Colorad Boom","Crest",1664,881.92,null,true,true,true,true,true,true]
[659441,"2013-01-03","Gel Booms","Carlota",1980,990,null,false,false,false,false,false,false]
[659440,"2013-01-02","Tri Fly","Darnell",1957.6,1037.55,null,false,false,false,false,false,false]
[659446,"2013-01-05","Gel Booms","Quad",2304,1082.8800000000001,null,true,true,true,true,true,true]
[659457,"2013-01-12","Colorad Boom","Yanaki",2394,1292.76,null,false,false,false,false,false,false]
[659446,"2013-01-05","Gel Booms","Quad",2744.98,1317.61,null,true,true,true,true,true,true]
[659455,"2013-01-11","Gel Booms","Bellen",2631.6,1421.04,null,false,false,false,false,false,false]
[659442,"2013-01-04","Gel Booms","Quad",2772,1469.16,null,false,false,false,false,false,false]
[659446,"2013-01-05","Gel Booms","Quad",3361.2,1579.75,null,true,true,true,true,true,true]
[659446,"2013-01-05","Gel Booms","Sunset",3174,1713.96,null,true,true,true,true,true,true]
[659444,"2013-01-05","Tri Fly","Darnell",3938.4,1890.4,null,true,true,true,true,true,true]
[659453,"2013-01-10","Tri Fly","FastFly",4309.2,2326.9499999999998,null,false,false,false,false,false,false]
[659443,"2013-01-05","Gel Booms","Quad",4536,2358.7199999999998,null,true,true,true,true,true,true]

{"sheet":"CF(26)","index":12,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Format whole row based on Invoice number"]
[]
["Invoice"]
[659440]
[]
["Invoice","Date","Company","Product","Net Sales","Cost"]
[659447,"2013-01-05","Colorad Boom","Aspen",48.48,25.2]
[659452,"2013-01-10","Colorad Boom","Aspen",1360,639.20000000000005]
[659455,"2013-01-11","Colorad Boom","Aspen",1632,767.04]
[659457,"2013-01-12","Colorad Boom","Aspen",60.6,28.5]
[659443,"2013-01-05","Gel Booms","Bellen",503.1,251.56]
[659444,"2013-01-05","Gel Booms","Bellen",464.96,237.12]
[659455,"2013-01-11","Gel Booms","Bellen",2631.6,1421.04]
[659440,"2013-01-02","Gel Booms","Carlota",357.5,193.06]
[659441,"2013-01-03","Gel Booms","Carlota",1980,990]
[659445,"2013-01-05","Gel Booms","Carlota",1650,792]
[659447,"2013-01-05","Colorad Boom","Crest",1664,881.92]
[659440,"2013-01-02","Tri Fly","Darnell",1957.6,1037.55]
[659444,"2013-01-05","Tri Fly","Darnell",3938.4,1890.4]
[659453,"2013-01-10","Tri Fly","FastFly",4309.2,2326.9499999999998]
[659458,"2013-01-13","Tri Fly","FastFly",1316.7,618.84]
[659451,"2013-01-09","Tri Fly","Fun Fly",256.2,140.9]
[659455,"2013-01-11","Tri Fly","Fun Fly",39.04,19.52]
[659456,"2013-01-12","Tri Fly","Fun Fly",51.24,27.16]
[659457,"2013-01-12","Tri Fly","Fun Fly",40.26,21.33]
[659458,"2013-01-13","Tri Fly","Fun Fly",207.36,107.82]
[659459,"2013-01-14","Tri Fly","Fun Fly",183,95.2]
[659446,"2013-01-05","Colorad Boom","Mt. Fun",1008.72,504.36]
[659454,"2013-01-11","Colorad Boom","Mt. Fun",1672,819.28]
[659456,"2013-01-12","Colorad Boom","Mt. Fun",495,237.6]
[659439,"2013-01-01","Gel Booms","Quad",1232.44,591.58000000000004]
[659441,"2013-01-03","Gel Booms","Quad",561.67999999999995,303.31]
[659442,"2013-01-04","Gel Booms","Quad",2772,1469.16]
[659443,"2013-01-05","Gel Booms","Quad",4536,2358.7199999999998]
[659446,"2013-01-05","Gel Booms","Quad",2304,1082.8800000000001]
[659446,"2013-01-05","Gel Booms","Quad",2744.98,1317.61]
[659446,"2013-01-05","Gel Booms","Quad",3361.2,1579.75]
[659450,"2013-01-08","Gel Booms","Quad",962.88,510.32]
[659455,"2013-01-11","Gel Booms","Quad",200.6,106.32]
[659446,"2013-01-05","Gel Booms","Sunset",3174,1713.96]
[659449,"2013-01-07","Gel Booms","Sunset",611.41999999999996,324.06]
[659456,"2013-01-12","Gel Booms","Sunset",1150,552]
[659440,"2013-01-02","Tri Fly","V-Rang",451.2,212.08]
[659451,"2013-01-09","Tri Fly","V-Rang",203.04,95.4]
[659453,"2013-01-10","Tri Fly","V-Rang",241.28,132.72]
[659455,"2013-01-11","Tri Fly","V-Rang",394.8,197.4]
[659445,"2013-01-05","Colorad Boom","Yanaki",114,55.86]
[659446,"2013-01-05","Colorad Boom","Yanaki",730.2,365.1]
[659448,"2013-01-06","Colorad Boom","Yanaki",670.4,355.28]
[659455,"2013-01-11","Colorad Boom","Yanaki",368.72,188.04]
[659455,"2013-01-11","Colorad Boom","Yanaki",670.4,341.92]
[659455,"2013-01-11","Colorad Boom","Yanaki",219.06,118.3]
[659457,"2013-01-12","Colorad Boom","Yanaki",2394,1292.76]

{"sheet":"CF(27)","index":13,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Format Row when Actual Exceeds Budgeted"]
[]
["Expense","Budgeted Amount","Actual"]
["Rent",15000,15000,null,{"$f":"$C4>$B4","v":false},false,false]
["Operations",195500,215809.25,null,true,true,true]
["Administration",59800,59852.11,null,true,true,true]
["COGS",356500,345089.25,null,false,false,false]
["Wage",159000,149087.25,null,false,false,false]
["Depr",105000,105000,null,false,false,false]
["Other",7500,65809.25,null,true,true,true]

{"sheet":"CF(28)","index":14,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Format whole column"]
[]
["Month","May"]
[]
["Jan","Feb","Mar","Apr","May","Jun"]
[244,605,596,116,970,170]
[589,385,959,778,1067,419]
[565,929,685,606,497,591]
[704,355,1114,686,678,1121]
[1118,1023,733,998,174,123]
[1045,1162,819,877,945,1106]
[681,121,652,993,214,448]
[666,627,1188,817,530,344]
[1030,121,384,965,734,1188]
[645,773,115,362,804,730]
[697,300,866,377,1184,789]

{"sheet":"CF(29)","index":15,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Format cell based on OR criteria: OR function."]
[]
["Invoice"]
[659440]
[659442]
[]
[]
["Invoice","Date","Company","Product","Net Sales","Cost"]
[659439,"2013-01-01","Gel Booms","Quad",1232.44,591.58000000000004,null,{"$f":"OR(A9=$A$4,A9=$A$5)","v":false}]
[659440,"2013-01-02","Tri Fly","V-Rang",451.2,212.08,null,{"$f":"OR(A10=$A$4,A10=$A$5)","v":true}]
[659440,"2013-01-02","Gel Booms","Carlota",357.5,193.06,null,true]
[659440,"2013-01-02","Tri Fly","Darnell",1957.6,1037.55,null,true]
[659441,"2013-01-03","Gel Booms","Quad",561.67999999999995,303.31,null,false]
[659441,"2013-01-03","Gel Booms","Carlota",1980,990,null,false]
[659442,"2013-01-04","Gel Booms","Quad",2772,1469.16,null,true]
[659443,"2013-01-05","Gel Booms","Quad",4536,2358.7199999999998,null,false]
[659443,"2013-01-05","Gel Booms","Bellen",503.1,251.56,null,false]
[659444,"2013-01-05","Tri Fly","Darnell",3938.4,1890.4,null,false]
[659444,"2013-01-05","Gel Booms","Bellen",464.96,237.12,null,false]
[659445,"2013-01-05","Gel Booms","Carlota",1650,792,null,false]
[659445,"2013-01-05","Colorad Boom","Yanaki",114,55.86,null,false]
[659446,"2013-01-05","Colorad Boom","Mt. Fun",1008.72,504.36,null,false]
[659446,"2013-01-05","Colorad Boom","Yanaki",730.2,365.1,null,false]
[659446,"2013-01-05","Gel Booms","Sunset",3174,1713.96,null,false]
[659446,"2013-01-05","Gel Booms","Quad",2304,1082.8800000000001,null,false]
[659446,"2013-01-05","Gel Booms","Quad",2744.98,1317.61,null,false]
[659446,"2013-01-05","Gel Booms","Quad",3361.2,1579.75,null,false]
[659447,"2013-01-05","Colorad Boom","Aspen",48.48,25.2,null,false]
[659447,"2013-01-05","Colorad Boom","Crest",1664,881.92,null,false]
[659448,"2013-01-06","Colorad Boom","Yanaki",670.4,355.28,null,false]
[659449,"2013-01-07","Gel Booms","Sunset",611.41999999999996,324.06,null,false]
[659450,"2013-01-08","Gel Booms","Quad",962.88,510.32,null,false]
[659451,"2013-01-09","Tri Fly","V-Rang",203.04,95.4,null,false]
[659451,"2013-01-09","Tri Fly","Fun Fly",256.2,140.9,null,false]
[659452,"2013-01-10","Colorad Boom","Aspen",1360,639.20000000000005,null,false]
[659453,"2013-01-10","Tri Fly","FastFly",4309.2,2326.9499999999998,null,false]
[659453,"2013-01-10","Tri Fly","V-Rang",241.28,132.72,null,false]
[659454,"2013-01-11","Colorad Boom","Mt. Fun",1672,819.28,null,false]
[659455,"2013-01-11","Gel Booms","Bellen",2631.6,1421.04,null,false]
[659455,"2013-01-11","Colorad Boom","Yanaki",368.72,188.04,null,false]
[659455,"2013-01-11","Colorad Boom","Aspen",1632,767.04,null,false]
[659455,"2013-01-11","Colorad Boom","Yanaki",670.4,341.92,null,false]
[659455,"2013-01-11","Tri Fly","Fun Fly",39.04,19.52,null,false]
[659455,"2013-01-11","Tri Fly","V-Rang",394.8,197.4,null,false]
[659455,"2013-01-11","Colorad Boom","Yanaki",219.06,118.3,null,false]
[659455,"2013-01-11","Gel Booms","Quad",200.6,106.32,null,false]
[659456,"2013-01-12","Gel Booms","Sunset",1150,552,null,false]
[659456,"2013-01-12","Colorad Boom","Mt. Fun",495,237.6,null,false]
[659456,"2013-01-12","Tri Fly","Fun Fly",51.24,27.16,null,false]
[659457,"2013-01-12","Tri Fly","Fun Fly",40.26,21.33,null,false]
[659457,"2013-01-12","Colorad Boom","Aspen",60.6,28.5,null,false]
[659457,"2013-01-12","Colorad Boom","Yanaki",2394,1292.76,null,false]
[659458,"2013-01-13","Tri Fly","Fun Fly",207.36,107.82,null,false]
[659458,"2013-01-13","Tri Fly","FastFly",1316.7,618.84,null,false]
[659459,"2013-01-14","Tri Fly","Fun Fly",183,95.2,null,false]

{"sheet":"CF(30)","index":16,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Format cell based on OR criteria: MATCH function (Errors are ignored, Any non-zero number = TRUE)."]
[]
["Invoice"]
[659440]
[659442]
[]
[]
["Invoice","Date","Company","Product","Net Sales","Cost"]
[659439,"2013-01-01","Gel Booms","Quad",1232.44,591.58000000000004,null,{"$f":"MATCH(A9,$A$4:$A$5,0)","v":{"$error":"#N/A"}}]
[659440,"2013-01-02","Tri Fly","V-Rang",451.2,212.08,null,{"$f":"MATCH(A10,$A$4:$A$5,0)","v":1}]
[659440,"2013-01-02","Gel Booms","Carlota",357.5,193.06,null,1]
[659440,"2013-01-02","Tri Fly","Darnell",1957.6,1037.55,null,1]
[659441,"2013-01-03","Gel Booms","Quad",561.67999999999995,303.31,null,{"$error":"#N/A"}]
[659441,"2013-01-03","Gel Booms","Carlota",1980,990,null,{"$error":"#N/A"}]
[659442,"2013-01-04","Gel Booms","Quad",2772,1469.16,null,2]
[659443,"2013-01-05","Gel Booms","Quad",4536,2358.7199999999998,null,{"$error":"#N/A"}]
[659443,"2013-01-05","Gel Booms","Bellen",503.1,251.56,null,{"$error":"#N/A"}]
[659444,"2013-01-05","Tri Fly","Darnell",3938.4,1890.4,null,{"$error":"#N/A"}]
[659444,"2013-01-05","Gel Booms","Bellen",464.96,237.12,null,{"$error":"#N/A"}]
[659445,"2013-01-05","Gel Booms","Carlota",1650,792,null,{"$error":"#N/A"}]
[659445,"2013-01-05","Colorad Boom","Yanaki",114,55.86,null,{"$error":"#N/A"}]
[659446,"2013-01-05","Colorad Boom","Mt. Fun",1008.72,504.36,null,{"$error":"#N/A"}]
[659446,"2013-01-05","Colorad Boom","Yanaki",730.2,365.1,null,{"$error":"#N/A"}]
[659446,"2013-01-05","Gel Booms","Sunset",3174,1713.96,null,{"$error":"#N/A"}]
[659446,"2013-01-05","Gel Booms","Quad",2304,1082.8800000000001,null,{"$error":"#N/A"}]
[659446,"2013-01-05","Gel Booms","Quad",2744.98,1317.61,null,{"$error":"#N/A"}]
[659446,"2013-01-05","Gel Booms","Quad",3361.2,1579.75,null,{"$error":"#N/A"}]
[659447,"2013-01-05","Colorad Boom","Aspen",48.48,25.2,null,{"$error":"#N/A"}]
[659447,"2013-01-05","Colorad Boom","Crest",1664,881.92,null,{"$error":"#N/A"}]
[659448,"2013-01-06","Colorad Boom","Yanaki",670.4,355.28,null,{"$error":"#N/A"}]
[659449,"2013-01-07","Gel Booms","Sunset",611.41999999999996,324.06,null,{"$error":"#N/A"}]
[659450,"2013-01-08","Gel Booms","Quad",962.88,510.32,null,{"$error":"#N/A"}]
[659451,"2013-01-09","Tri Fly","V-Rang",203.04,95.4,null,{"$error":"#N/A"}]
[659451,"2013-01-09","Tri Fly","Fun Fly",256.2,140.9,null,{"$error":"#N/A"}]
[659452,"2013-01-10","Colorad Boom","Aspen",1360,639.20000000000005,null,{"$error":"#N/A"}]
[659453,"2013-01-10","Tri Fly","FastFly",4309.2,2326.9499999999998,null,{"$error":"#N/A"}]
[659453,"2013-01-10","Tri Fly","V-Rang",241.28,132.72,null,{"$error":"#N/A"}]
[659454,"2013-01-11","Colorad Boom","Mt. Fun",1672,819.28,null,{"$error":"#N/A"}]
[659455,"2013-01-11","Gel Booms","Bellen",2631.6,1421.04,null,{"$error":"#N/A"}]
[659455,"2013-01-11","Colorad Boom","Yanaki",368.72,188.04,null,{"$error":"#N/A"}]
[659455,"2013-01-11","Colorad Boom","Aspen",1632,767.04,null,{"$error":"#N/A"}]
[659455,"2013-01-11","Colorad Boom","Yanaki",670.4,341.92,null,{"$error":"#N/A"}]
[659455,"2013-01-11","Tri Fly","Fun Fly",39.04,19.52,null,{"$error":"#N/A"}]
[659455,"2013-01-11","Tri Fly","V-Rang",394.8,197.4,null,{"$error":"#N/A"}]
[659455,"2013-01-11","Colorad Boom","Yanaki",219.06,118.3,null,{"$error":"#N/A"}]
[659455,"2013-01-11","Gel Booms","Quad",200.6,106.32,null,{"$error":"#N/A"}]
[659456,"2013-01-12","Gel Booms","Sunset",1150,552,null,{"$error":"#N/A"}]
[659456,"2013-01-12","Colorad Boom","Mt. Fun",495,237.6,null,{"$error":"#N/A"}]
[659456,"2013-01-12","Tri Fly","Fun Fly",51.24,27.16,null,{"$error":"#N/A"}]
[659457,"2013-01-12","Tri Fly","Fun Fly",40.26,21.33,null,{"$error":"#N/A"}]
[659457,"2013-01-12","Colorad Boom","Aspen",60.6,28.5,null,{"$error":"#N/A"}]
[659457,"2013-01-12","Colorad Boom","Yanaki",2394,1292.76,null,{"$error":"#N/A"}]
[659458,"2013-01-13","Tri Fly","Fun Fly",207.36,107.82,null,{"$error":"#N/A"}]
[659458,"2013-01-13","Tri Fly","FastFly",1316.7,618.84,null,{"$error":"#N/A"}]
[659459,"2013-01-14","Tri Fly","Fun Fly",183,95.2,null,{"$error":"#N/A"}]

{"sheet":"CF(31)","index":17,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Format whole row based on OR Criteria  (Errors are ignored, Any non-zero number = TRUE)."]
[]
["Invoice"]
[659440]
[659442]
[659455]
[659458]
[659459]
[]
[]
["Invoice","Date","Company","Product","Net Sales","Cost"]
[659439,"2013-01-01","Gel Booms","Quad",1232.44,591.58000000000004,null,{"$f":"MATCH($A12,$A$4:$A$8,0)","v":{"$error":"#N/A"}},{"$f":"MATCH($A12,$A$4:$A$8,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659440,"2013-01-02","Tri Fly","V-Rang",451.2,212.08,null,{"$f":"MATCH($A13,$A$4:$A$8,0)","v":1},1,1,1,1,1]
[659440,"2013-01-02","Gel Booms","Carlota",357.5,193.06,null,1,1,1,1,1,1]
[659440,"2013-01-02","Tri Fly","Darnell",1957.6,1037.55,null,1,1,1,1,1,1]
[659441,"2013-01-03","Gel Booms","Quad",561.67999999999995,303.31,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659441,"2013-01-03","Gel Booms","Carlota",1980,990,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659442,"2013-01-04","Gel Booms","Quad",2772,1469.16,null,2,2,2,2,2,2]
[659443,"2013-01-05","Gel Booms","Quad",4536,2358.7199999999998,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659443,"2013-01-05","Gel Booms","Bellen",503.1,251.56,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659444,"2013-01-05","Tri Fly","Darnell",3938.4,1890.4,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659444,"2013-01-05","Gel Booms","Bellen",464.96,237.12,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659445,"2013-01-05","Gel Booms","Carlota",1650,792,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659445,"2013-01-05","Colorad Boom","Yanaki",114,55.86,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659446,"2013-01-05","Colorad Boom","Mt. Fun",1008.72,504.36,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659446,"2013-01-05","Colorad Boom","Yanaki",730.2,365.1,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659446,"2013-01-05","Gel Booms","Sunset",3174,1713.96,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659446,"2013-01-05","Gel Booms","Quad",2304,1082.8800000000001,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659446,"2013-01-05","Gel Booms","Quad",2744.98,1317.61,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659446,"2013-01-05","Gel Booms","Quad",3361.2,1579.75,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659447,"2013-01-05","Colorad Boom","Aspen",48.48,25.2,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659447,"2013-01-05","Colorad Boom","Crest",1664,881.92,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659448,"2013-01-06","Colorad Boom","Yanaki",670.4,355.28,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659449,"2013-01-07","Gel Booms","Sunset",611.41999999999996,324.06,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659450,"2013-01-08","Gel Booms","Quad",962.88,510.32,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659451,"2013-01-09","Tri Fly","V-Rang",203.04,95.4,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659451,"2013-01-09","Tri Fly","Fun Fly",256.2,140.9,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659452,"2013-01-10","Colorad Boom","Aspen",1360,639.20000000000005,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659453,"2013-01-10","Tri Fly","FastFly",4309.2,2326.9499999999998,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659453,"2013-01-10","Tri Fly","V-Rang",241.28,132.72,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659454,"2013-01-11","Colorad Boom","Mt. Fun",1672,819.28,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659455,"2013-01-11","Gel Booms","Bellen",2631.6,1421.04,null,3,3,3,3,3,3]
[659455,"2013-01-11","Colorad Boom","Yanaki",368.72,188.04,null,3,3,3,3,3,3]
[659455,"2013-01-11","Colorad Boom","Aspen",1632,767.04,null,3,3,3,3,3,3]
[659455,"2013-01-11","Colorad Boom","Yanaki",670.4,341.92,null,3,3,3,3,3,3]
[659455,"2013-01-11","Tri Fly","Fun Fly",39.04,19.52,null,3,3,3,3,3,3]
[659455,"2013-01-11","Tri Fly","V-Rang",394.8,197.4,null,3,3,3,3,3,3]
[659455,"2013-01-11","Colorad Boom","Yanaki",219.06,118.3,null,3,3,3,3,3,3]
[659455,"2013-01-11","Gel Booms","Quad",200.6,106.32,null,3,3,3,3,3,3]
[659456,"2013-01-12","Gel Booms","Sunset",1150,552,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659456,"2013-01-12","Colorad Boom","Mt. Fun",495,237.6,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659456,"2013-01-12","Tri Fly","Fun Fly",51.24,27.16,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659457,"2013-01-12","Tri Fly","Fun Fly",40.26,21.33,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659457,"2013-01-12","Colorad Boom","Aspen",60.6,28.5,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659457,"2013-01-12","Colorad Boom","Yanaki",2394,1292.76,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[659458,"2013-01-13","Tri Fly","Fun Fly",207.36,107.82,null,4,4,4,4,4,4]
[659458,"2013-01-13","Tri Fly","FastFly",1316.7,618.84,null,4,4,4,4,4,4]
[659459,"2013-01-14","Tri Fly","Fun Fly",183,95.2,null,5,5,5,5,5,5]

{"sheet":"CF(32)","index":18,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Format cell based on AND Criteria: Between Upper and Lower Date: AND Function."]
[]
["Lower Date","2013-01-02"]
["Upper Date","2013-01-05"]
[]
["Invoice","Date","Company","Product","Net Sales","Cost"]
[659443,"2013-01-05","Gel Booms","Quad",4536,2358.7199999999998]
[659453,"2013-01-10","Tri Fly","FastFly",4309.2,2326.9499999999998]
[659444,"2013-01-05","Tri Fly","Darnell",3938.4,1890.4]
[659446,"2013-01-05","Gel Booms","Quad",3361.2,1579.75]
[659446,"2013-01-05","Gel Booms","Sunset",3174,1713.96]
[659442,"2013-01-04","Gel Booms","Quad",2772,1469.16]
[659446,"2013-01-05","Gel Booms","Quad",2744.98,1317.61]
[659455,"2013-01-11","Gel Booms","Bellen",2631.6,1421.04]
[659457,"2013-01-12","Colorad Boom","Yanaki",2394,1292.76]
[659446,"2013-01-05","Gel Booms","Quad",2304,1082.8800000000001]
[659441,"2013-01-03","Gel Booms","Carlota",1980,990]
[659440,"2013-01-02","Tri Fly","Darnell",1957.6,1037.55]
[659454,"2013-01-11","Colorad Boom","Mt. Fun",1672,819.28]
[659447,"2013-01-05","Colorad Boom","Crest",1664,881.92]
[659445,"2013-01-05","Gel Booms","Carlota",1650,792]
[659455,"2013-01-11","Colorad Boom","Aspen",1632,767.04]
[659452,"2013-01-10","Colorad Boom","Aspen",1360,639.20000000000005]
[659458,"2013-01-13","Tri Fly","FastFly",1316.7,618.84]
[659439,"2013-01-01","Gel Booms","Quad",1232.44,591.58000000000004]
[659456,"2013-01-12","Gel Booms","Sunset",1150,552]
[659446,"2013-01-05","Colorad Boom","Mt. Fun",1008.72,504.36]
[659450,"2013-01-08","Gel Booms","Quad",962.88,510.32]
[659446,"2013-01-05","Colorad Boom","Yanaki",730.2,365.1]
[659448,"2013-01-06","Colorad Boom","Yanaki",670.4,355.28]
[659455,"2013-01-11","Colorad Boom","Yanaki",670.4,341.92]
[659449,"2013-01-07","Gel Booms","Sunset",611.41999999999996,324.06]
[659441,"2013-01-03","Gel Booms","Quad",561.67999999999995,303.31]
[659443,"2013-01-05","Gel Booms","Bellen",503.1,251.56]
[659456,"2013-01-12","Colorad Boom","Mt. Fun",495,237.6]
[659444,"2013-01-05","Gel Booms","Bellen",464.96,237.12]
[659440,"2013-01-02","Tri Fly","V-Rang",451.2,212.08]
[659455,"2013-01-11","Tri Fly","V-Rang",394.8,197.4]
[659455,"2013-01-11","Colorad Boom","Yanaki",368.72,188.04]
[659440,"2013-01-02","Gel Booms","Carlota",357.5,193.06]
[659451,"2013-01-09","Tri Fly","Fun Fly",256.2,140.9]
[659453,"2013-01-10","Tri Fly","V-Rang",241.28,132.72]
[659455,"2013-01-11","Colorad Boom","Yanaki",219.06,118.3]
[659458,"2013-01-13","Tri Fly","Fun Fly",207.36,107.82]
[659451,"2013-01-09","Tri Fly","V-Rang",203.04,95.4]
[659455,"2013-01-11","Gel Booms","Quad",200.6,106.32]
[659459,"2013-01-14","Tri Fly","Fun Fly",183,95.2]
[659445,"2013-01-05","Colorad Boom","Yanaki",114,55.86]
[659457,"2013-01-12","Colorad Boom","Aspen",60.6,28.5]
[659456,"2013-01-12","Tri Fly","Fun Fly",51.24,27.16]
[659447,"2013-01-05","Colorad Boom","Aspen",48.48,25.2]
[659457,"2013-01-12","Tri Fly","Fun Fly",40.26,21.33]
[659455,"2013-01-11","Tri Fly","Fun Fly",39.04,19.52]

{"sheet":"CF(33)","index":19,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Format whole row based on between Date Criteria"]
[]
["Lower Date","2013-01-02"]
["Upper Date","2013-01-05"]
[]
["Invoice","Date","Company","Product","Net Sales","Cost"]
[659443,"2013-01-05","Gel Booms","Quad",4536,2358.7199999999998]
[659453,"2013-01-10","Tri Fly","FastFly",4309.2,2326.9499999999998]
[659444,"2013-01-05","Tri Fly","Darnell",3938.4,1890.4]
[659446,"2013-01-05","Gel Booms","Quad",3361.2,1579.75]
[659446,"2013-01-05","Gel Booms","Sunset",3174,1713.96]
[659442,"2013-01-04","Gel Booms","Quad",2772,1469.16]
[659446,"2013-01-05","Gel Booms","Quad",2744.98,1317.61]
[659455,"2013-01-11","Gel Booms","Bellen",2631.6,1421.04]
[659457,"2013-01-12","Colorad Boom","Yanaki",2394,1292.76]
[659446,"2013-01-05","Gel Booms","Quad",2304,1082.8800000000001]
[659441,"2013-01-03","Gel Booms","Carlota",1980,990]
[659440,"2013-01-02","Tri Fly","Darnell",1957.6,1037.55]
[659454,"2013-01-11","Colorad Boom","Mt. Fun",1672,819.28]
[659447,"2013-01-05","Colorad Boom","Crest",1664,881.92]
[659445,"2013-01-05","Gel Booms","Carlota",1650,792]
[659455,"2013-01-11","Colorad Boom","Aspen",1632,767.04]
[659452,"2013-01-10","Colorad Boom","Aspen",1360,639.20000000000005]
[659458,"2013-01-13","Tri Fly","FastFly",1316.7,618.84]
[659439,"2013-01-01","Gel Booms","Quad",1232.44,591.58000000000004]
[659456,"2013-01-12","Gel Booms","Sunset",1150,552]
[659446,"2013-01-05","Colorad Boom","Mt. Fun",1008.72,504.36]
[659450,"2013-01-08","Gel Booms","Quad",962.88,510.32]
[659446,"2013-01-05","Colorad Boom","Yanaki",730.2,365.1]
[659448,"2013-01-06","Colorad Boom","Yanaki",670.4,355.28]
[659455,"2013-01-11","Colorad Boom","Yanaki",670.4,341.92]
[659449,"2013-01-07","Gel Booms","Sunset",611.41999999999996,324.06]
[659441,"2013-01-03","Gel Booms","Quad",561.67999999999995,303.31]
[659443,"2013-01-05","Gel Booms","Bellen",503.1,251.56]
[659456,"2013-01-12","Colorad Boom","Mt. Fun",495,237.6]
[659444,"2013-01-05","Gel Booms","Bellen",464.96,237.12]
[659440,"2013-01-02","Tri Fly","V-Rang",451.2,212.08]
[659455,"2013-01-11","Tri Fly","V-Rang",394.8,197.4]
[659455,"2013-01-11","Colorad Boom","Yanaki",368.72,188.04]
[659440,"2013-01-02","Gel Booms","Carlota",357.5,193.06]
[659451,"2013-01-09","Tri Fly","Fun Fly",256.2,140.9]
[659453,"2013-01-10","Tri Fly","V-Rang",241.28,132.72]
[659455,"2013-01-11","Colorad Boom","Yanaki",219.06,118.3]
[659458,"2013-01-13","Tri Fly","Fun Fly",207.36,107.82]
[659451,"2013-01-09","Tri Fly","V-Rang",203.04,95.4]
[659455,"2013-01-11","Gel Booms","Quad",200.6,106.32]
[659459,"2013-01-14","Tri Fly","Fun Fly",183,95.2]
[659445,"2013-01-05","Colorad Boom","Yanaki",114,55.86]
[659457,"2013-01-12","Colorad Boom","Aspen",60.6,28.5]
[659456,"2013-01-12","Tri Fly","Fun Fly",51.24,27.16]
[659447,"2013-01-05","Colorad Boom","Aspen",48.48,25.2]
[659457,"2013-01-12","Tri Fly","Fun Fly",40.26,21.33]
[659455,"2013-01-11","Tri Fly","Fun Fly",39.04,19.52]

{"sheet":"CF(34)","index":20,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Format whole row based on AND Criteria"]
[]
["Product","Net Sales"]
["Quad",3000]
[]
["Invoice","Date","Company","Product","Net Sales","Cost"]
[659439,"2013-01-01","Gel Booms","Quad",1232.44,591.58000000000004]
[659440,"2013-01-02","Tri Fly","Darnell",1957.6,1037.55]
[659440,"2013-01-02","Tri Fly","V-Rang",451.2,212.08]
[659440,"2013-01-02","Gel Booms","Carlota",357.5,193.06]
[659441,"2013-01-03","Gel Booms","Carlota",1980,990]
[659441,"2013-01-03","Gel Booms","Quad",561.67999999999995,303.31]
[659442,"2013-01-04","Gel Booms","Quad",2772,1469.16]
[659443,"2013-01-05","Gel Booms","Quad",4536,2358.7199999999998]
[659443,"2013-01-05","Gel Booms","Bellen",503.1,251.56]
[659444,"2013-01-05","Tri Fly","Darnell",3938.4,1890.4]
[659444,"2013-01-05","Gel Booms","Bellen",464.96,237.12]
[659445,"2013-01-05","Gel Booms","Carlota",1650,792]
[659445,"2013-01-05","Colorad Boom","Yanaki",114,55.86]
[659446,"2013-01-05","Gel Booms","Quad",3361.2,1579.75]
[659446,"2013-01-05","Gel Booms","Sunset",3174,1713.96]
[659446,"2013-01-05","Gel Booms","Quad",2744.98,1317.61]
[659446,"2013-01-05","Gel Booms","Quad",2304,1082.8800000000001]
[659446,"2013-01-05","Colorad Boom","Mt. Fun",1008.72,504.36]
[659446,"2013-01-05","Colorad Boom","Yanaki",730.2,365.1]
[659447,"2013-01-05","Colorad Boom","Crest",1664,881.92]
[659447,"2013-01-05","Colorad Boom","Aspen",48.48,25.2]
[659448,"2013-01-06","Colorad Boom","Yanaki",670.4,355.28]
[659449,"2013-01-07","Gel Booms","Sunset",611.41999999999996,324.06]
[659450,"2013-01-08","Gel Booms","Quad",962.88,510.32]
[659451,"2013-01-09","Tri Fly","Fun Fly",256.2,140.9]
[659451,"2013-01-09","Tri Fly","V-Rang",203.04,95.4]
[659452,"2013-01-10","Colorad Boom","Aspen",1360,639.20000000000005]
[659453,"2013-01-10","Tri Fly","FastFly",4309.2,2326.9499999999998]
[659453,"2013-01-10","Tri Fly","V-Rang",241.28,132.72]
[659454,"2013-01-11","Colorad Boom","Mt. Fun",1672,819.28]
[659455,"2013-01-11","Gel Booms","Bellen",2631.6,1421.04]
[659455,"2013-01-11","Colorad Boom","Aspen",1632,767.04]
[659455,"2013-01-11","Colorad Boom","Yanaki",670.4,341.92]
[659455,"2013-01-11","Tri Fly","V-Rang",394.8,197.4]
[659455,"2013-01-11","Colorad Boom","Yanaki",368.72,188.04]
[659455,"2013-01-11","Colorad Boom","Yanaki",219.06,118.3]
[659455,"2013-01-11","Gel Booms","Quad",200.6,106.32]
[659455,"2013-01-11","Tri Fly","Fun Fly",39.04,19.52]
[659456,"2013-01-12","Gel Booms","Sunset",1150,552]
[659456,"2013-01-12","Colorad Boom","Mt. Fun",495,237.6]
[659456,"2013-01-12","Tri Fly","Fun Fly",51.24,27.16]
[659457,"2013-01-12","Colorad Boom","Yanaki",2394,1292.76]
[659457,"2013-01-12","Colorad Boom","Aspen",60.6,28.5]
[659457,"2013-01-12","Tri Fly","Fun Fly",40.26,21.33]
[659458,"2013-01-13","Tri Fly","FastFly",1316.7,618.84]
[659458,"2013-01-13","Tri Fly","Fun Fly",207.36,107.82]
[659459,"2013-01-14","Tri Fly","Fun Fly",183,95.2]

{"sheet":"CF(35)","index":21,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Format whole row based on AND and OR Criteria"]
[]
["Product","Net Sales"]
["Quad",250]
["FastFly"]
[]
["Invoice","Date","Company","Product","Net Sales","Cost"]
[659439,"2013-01-01","Gel Booms","Quad",1232.44,591.58000000000004,null,{"$f":"AND($E8>$B$4,ISNUMBER(MATCH($D8,$A$4:$A$5,0)))","v":true},{"$f":"AND($E8>$B$4,ISNUMBER(MATCH($D8,$A$4:$A$5,0)))","v":true},true,true,true,true]
[659440,"2013-01-02","Tri Fly","Darnell",1957.6,1037.55,null,{"$f":"AND($E9>$B$4,ISNUMBER(MATCH($D9,$A$4:$A$5,0)))","v":false},false,false,false,false,false]
[659440,"2013-01-02","Tri Fly","V-Rang",451.2,212.08,null,false,false,false,false,false,false]
[659440,"2013-01-02","Gel Booms","Carlota",357.5,193.06,null,false,false,false,false,false,false]
[659441,"2013-01-03","Gel Booms","Carlota",1980,990,null,false,false,false,false,false,false]
[659441,"2013-01-03","Gel Booms","Quad",561.67999999999995,303.31,null,true,true,true,true,true,true]
[659442,"2013-01-04","Gel Booms","Quad",2772,1469.16,null,true,true,true,true,true,true]
[659443,"2013-01-05","Gel Booms","Quad",4536,2358.7199999999998,null,true,true,true,true,true,true]
[659443,"2013-01-05","Gel Booms","Bellen",503.1,251.56,null,false,false,false,false,false,false]
[659444,"2013-01-05","Tri Fly","Darnell",3938.4,1890.4,null,false,false,false,false,false,false]
[659444,"2013-01-05","Gel Booms","Bellen",464.96,237.12,null,false,false,false,false,false,false]
[659445,"2013-01-05","Gel Booms","Carlota",1650,792,null,false,false,false,false,false,false]
[659445,"2013-01-05","Colorad Boom","Yanaki",114,55.86,null,false,false,false,false,false,false]
[659446,"2013-01-05","Gel Booms","Quad",3361.2,1579.75,null,true,true,true,true,true,true]
[659446,"2013-01-05","Gel Booms","Sunset",3174,1713.96,null,false,false,false,false,false,false]
[659446,"2013-01-05","Gel Booms","Quad",2744.98,1317.61,null,true,true,true,true,true,true]
[659446,"2013-01-05","Gel Booms","Quad",2304,1082.8800000000001,null,true,true,true,true,true,true]
[659446,"2013-01-05","Colorad Boom","Mt. Fun",1008.72,504.36,null,false,false,false,false,false,false]
[659446,"2013-01-05","Colorad Boom","Yanaki",730.2,365.1,null,false,false,false,false,false,false]
[659447,"2013-01-05","Colorad Boom","Crest",1664,881.92,null,false,false,false,false,false,false]
[659447,"2013-01-05","Colorad Boom","Aspen",48.48,25.2,null,false,false,false,false,false,false]
[659448,"2013-01-06","Colorad Boom","Yanaki",670.4,355.28,null,false,false,false,false,false,false]
[659449,"2013-01-07","Gel Booms","Sunset",611.41999999999996,324.06,null,false,false,false,false,false,false]
[659450,"2013-01-08","Gel Booms","Quad",962.88,510.32,null,true,true,true,true,true,true]
[659451,"2013-01-09","Tri Fly","Fun Fly",256.2,140.9,null,false,false,false,false,false,false]
[659451,"2013-01-09","Tri Fly","V-Rang",203.04,95.4,null,false,false,false,false,false,false]
[659452,"2013-01-10","Colorad Boom","Aspen",1360,639.20000000000005,null,false,false,false,false,false,false]
[659453,"2013-01-10","Tri Fly","FastFly",4309.2,2326.9499999999998,null,true,true,true,true,true,true]
[659453,"2013-01-10","Tri Fly","V-Rang",241.28,132.72,null,false,false,false,false,false,false]
[659454,"2013-01-11","Colorad Boom","Mt. Fun",1672,819.28,null,false,false,false,false,false,false]
[659455,"2013-01-11","Gel Booms","Bellen",2631.6,1421.04,null,false,false,false,false,false,false]
[659455,"2013-01-11","Colorad Boom","Aspen",1632,767.04,null,false,false,false,false,false,false]
[659455,"2013-01-11","Colorad Boom","Yanaki",670.4,341.92,null,false,false,false,false,false,false]
[659455,"2013-01-11","Tri Fly","V-Rang",394.8,197.4,null,false,false,false,false,false,false]
[659455,"2013-01-11","Colorad Boom","Yanaki",368.72,188.04,null,false,false,false,false,false,false]
[659455,"2013-01-11","Colorad Boom","Yanaki",219.06,118.3,null,false,false,false,false,false,false]
[659455,"2013-01-11","Gel Booms","Quad",200.6,106.32,null,false,false,false,false,false,false]
[659455,"2013-01-11","Tri Fly","Fun Fly",39.04,19.52,null,false,false,false,false,false,false]
[659456,"2013-01-12","Gel Booms","Sunset",1150,552,null,false,false,false,false,false,false]
[659456,"2013-01-12","Colorad Boom","Mt. Fun",495,237.6,null,false,false,false,false,false,false]
[659456,"2013-01-12","Tri Fly","Fun Fly",51.24,27.16,null,false,false,false,false,false,false]
[659457,"2013-01-12","Colorad Boom","Yanaki",2394,1292.76,null,false,false,false,false,false,false]
[659457,"2013-01-12","Colorad Boom","Aspen",60.6,28.5,null,false,false,false,false,false,false]
[659457,"2013-01-12","Tri Fly","Fun Fly",40.26,21.33,null,false,false,false,false,false,false]
[659458,"2013-01-13","Tri Fly","FastFly",1316.7,618.84,null,true,true,true,true,true,true]
[659458,"2013-01-13","Tri Fly","Fun Fly",207.36,107.82,null,false,false,false,false,false,false]
[659459,"2013-01-14","Tri Fly","Fun Fly",183,95.2,null,false,false,false,false,false,false]

{"sheet":"CF(36)","index":22,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Format entire row when sales are above average"]
[]
[null,"Average Net Sales:"]
[null,{"$f":"AVERAGE(E8:E54)","v":1231.8140425531913}]
[]
[]
["Invoice","Date","Company","Product","Net Sales","Cost"]
[659439,"2013-01-01","Gel Booms","Quad",1232.44,591.58000000000004,null,{"$f":"$E8>=AVERAGE($E$8:$E$54)","v":true},{"$f":"$E8>=AVERAGE($E$8:$E$54)","v":true},true,true,true,true]
[659440,"2013-01-02","Tri Fly","Darnell",1957.6,1037.55,null,{"$f":"$E9>=AVERAGE($E$8:$E$54)","v":true},true,true,true,true,true]
[659440,"2013-01-02","Tri Fly","V-Rang",451.2,212.08,null,false,false,false,false,false,false]
[659440,"2013-01-02","Gel Booms","Carlota",357.5,193.06,null,false,false,false,false,false,false]
[659441,"2013-01-03","Gel Booms","Carlota",1980,990,null,true,true,true,true,true,true]
[659441,"2013-01-03","Gel Booms","Quad",561.67999999999995,303.31,null,false,false,false,false,false,false]
[659442,"2013-01-04","Gel Booms","Quad",2772,1469.16,null,true,true,true,true,true,true]
[659443,"2013-01-05","Gel Booms","Quad",4536,2358.7199999999998,null,true,true,true,true,true,true]
[659443,"2013-01-05","Gel Booms","Bellen",503.1,251.56,null,false,false,false,false,false,false]
[659444,"2013-01-05","Tri Fly","Darnell",3938.4,1890.4,null,true,true,true,true,true,true]
[659444,"2013-01-05","Gel Booms","Bellen",464.96,237.12,null,false,false,false,false,false,false]
[659445,"2013-01-05","Gel Booms","Carlota",1650,792,null,true,true,true,true,true,true]
[659445,"2013-01-05","Colorad Boom","Yanaki",114,55.86,null,false,false,false,false,false,false]
[659446,"2013-01-05","Gel Booms","Quad",3361.2,1579.75,null,true,true,true,true,true,true]
[659446,"2013-01-05","Gel Booms","Sunset",3174,1713.96,null,true,true,true,true,true,true]
[659446,"2013-01-05","Gel Booms","Quad",2744.98,1317.61,null,true,true,true,true,true,true]
[659446,"2013-01-05","Gel Booms","Quad",2304,1082.8800000000001,null,true,true,true,true,true,true]
[659446,"2013-01-05","Colorad Boom","Mt. Fun",1008.72,504.36,null,false,false,false,false,false,false]
[659446,"2013-01-05","Colorad Boom","Yanaki",730.2,365.1,null,false,false,false,false,false,false]
[659447,"2013-01-05","Colorad Boom","Crest",1664,881.92,null,true,true,true,true,true,true]
[659447,"2013-01-05","Colorad Boom","Aspen",48.48,25.2,null,false,false,false,false,false,false]
[659448,"2013-01-06","Colorad Boom","Yanaki",670.4,355.28,null,false,false,false,false,false,false]
[659449,"2013-01-07","Gel Booms","Sunset",611.41999999999996,324.06,null,false,false,false,false,false,false]
[659450,"2013-01-08","Gel Booms","Quad",962.88,510.32,null,false,false,false,false,false,false]
[659451,"2013-01-09","Tri Fly","Fun Fly",256.2,140.9,null,false,false,false,false,false,false]
[659451,"2013-01-09","Tri Fly","V-Rang",203.04,95.4,null,false,false,false,false,false,false]
[659452,"2013-01-10","Colorad Boom","Aspen",1360,639.20000000000005,null,true,true,true,true,true,true]
[659453,"2013-01-10","Tri Fly","FastFly",4309.2,2326.9499999999998,null,true,true,true,true,true,true]
[659453,"2013-01-10","Tri Fly","V-Rang",241.28,132.72,null,false,false,false,false,false,false]
[659454,"2013-01-11","Colorad Boom","Mt. Fun",1672,819.28,null,true,true,true,true,true,true]
[659455,"2013-01-11","Gel Booms","Bellen",2631.6,1421.04,null,true,true,true,true,true,true]
[659455,"2013-01-11","Colorad Boom","Aspen",1632,767.04,null,true,true,true,true,true,true]
[659455,"2013-01-11","Colorad Boom","Yanaki",670.4,341.92,null,false,false,false,false,false,false]
[659455,"2013-01-11","Tri Fly","V-Rang",394.8,197.4,null,false,false,false,false,false,false]
[659455,"2013-01-11","Colorad Boom","Yanaki",368.72,188.04,null,false,false,false,false,false,false]
[659455,"2013-01-11","Colorad Boom","Yanaki",219.06,118.3,null,false,false,false,false,false,false]
[659455,"2013-01-11","Gel Booms","Quad",200.6,106.32,null,false,false,false,false,false,false]
[659455,"2013-01-11","Tri Fly","Fun Fly",39.04,19.52,null,false,false,false,false,false,false]
[659456,"2013-01-12","Gel Booms","Sunset",1150,552,null,false,false,false,false,false,false]
[659456,"2013-01-12","Colorad Boom","Mt. Fun",495,237.6,null,false,false,false,false,false,false]
[659456,"2013-01-12","Tri Fly","Fun Fly",51.24,27.16,null,false,false,false,false,false,false]
[659457,"2013-01-12","Colorad Boom","Yanaki",2394,1292.76,null,true,true,true,true,true,true]
[659457,"2013-01-12","Colorad Boom","Aspen",60.6,28.5,null,false,false,false,false,false,false]
[659457,"2013-01-12","Tri Fly","Fun Fly",40.26,21.33,null,false,false,false,false,false,false]
[659458,"2013-01-13","Tri Fly","FastFly",1316.7,618.84,null,true,true,true,true,true,true]
[659458,"2013-01-13","Tri Fly","Fun Fly",207.36,107.82,null,false,false,false,false,false,false]
[659459,"2013-01-14","Tri Fly","Fun Fly",183,95.2,null,false,false,false,false,false,false]

{"sheet":"CF(37)","index":23,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Format every other row with MOD function (1 = TRUE, 0 = FALSE)"]

{"sheet":"CF(38)","index":24,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Format Row In Checkbook when Reconciled"]
[]
[]
["Check No.","Date","Check Issued To","Withdrawal","Reconcile?","Date of Deposit","Amount of Deposit","Balance"]
[null,null,null,null,null,null,"Balance Forward ==>",3587.77]
[2097,"1910-06-05","Starbuck's",456,"x",null,null,{"$f":"IF(C6=\"\",\"\",H5-D6+G6)","v":3131.77}]
["e","1910-06-06","Office Depot",415,"x",null,null,{"$f":"IF(C7=\"\",\"\",H6-D7+G7)","v":2716.77}]
[2099,"1910-06-07","Whole Foods Market",157,"x",null,null,2559.77]
["e","1910-06-07","Suix Trucking",59,"x",null,null,2500.77]
[null,"1910-06-08","Deposit",null,"x","1910-06-08",588,3088.77]
[2101,"1910-06-08","Macbeth Hardwoods",499,null,null,null,2589.77]
[2102,"1910-06-08","Chin Ho",392,"x",null,null,2197.77]
[null,"1910-06-10","Deposit",null,"x","1910-06-10",612,2809.77]
[2103,"1910-06-11","Home Depot",411,"x",null,null,2398.77]
["e","1910-06-11","Macbeth Hardwoods",490,"x",null,null,1908.77]
["e","1910-06-11","Google",251,"x",null,null,1657.77]
[2106,"1910-06-11","Starbuck's",36,null,null,null,1621.77]
[2107,"1910-06-12","Sheliadawn Smith",411,null,null,null,1210.77]
[null,"1910-06-12","Deposit",null,"x","1910-06-12",2116,3326.77]
[2108,"2010-06-13","Suix Trucking",50,null,null,null,3276.77]
["e","2010-06-13","Suix Trucking",150,null,null,null,3126.77]
["e","2009-06-14","Google",20,null,null,null,3106.77]
[2109,"2009-06-14","Google",100,null,null,null,3006.77]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]

{"sheet":"CF(39)","index":25,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[" Format Entire Row for the 3 Biggest Values"]
[]
["Sales Rep","Sales","Product",null,"Number?",{"$f":"\"Large # \"&E4","v":"Large # 3"}]
["Your Name",4831,"ABC",null,3,{"$f":"LARGE(B4:B14,E4)","v":3740}]
["Sioux",3527,"RRP"]
["Tina",3167,"ABC"]
["Gigi",1154,"ABC"]
["Tim",3740,"DEF"]
["Mo",2518,"DEF"]
["Sioux",3372,"RRP"]
["Your Name",3933,"RRP"]
["Gigi",654,"RRP"]
["Gigi",3740,"DEF"]
["Tina",3589,"RRP"]

{"sheet":"CF(40)","index":26,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Format lowest Price in Row"]
[]
[]
["Crank'ys","Bay Air","Compressor R Us","Mech-Aid","Han's Shop","Vendor for Low Bid"]
[38.99,48.6,43.53,40.08,47.92,{"$f":"INDEX($A$4:$E$4,MATCH(MIN(A5:E5),A5:E5,0))","v":"Crank'ys"},null,{"$f":"MIN($A5:$E5)=A5","v":true},{"$f":"MIN($A5:$E5)=B5","v":false},{"$f":"MIN($A5:$E5)=C5","v":false},{"$f":"MIN($A5:$E5)=D5","v":false},{"$f":"MIN($A5:$E5)=E5","v":false}]
[57.68,31.8,52.78,31.42,55.19,{"$f":"INDEX($A$4:$E$4,MATCH(MIN(A6:E6),A6:E6,0))","v":"Mech-Aid"},null,false,false,false,true,false]
[53.32,32.64,37.69,48.29,41.59,"Bay Air",null,false,true,false,false,false]
[35.200000000000003,40.549999999999997,32.65,36.81,41.14,"Compressor R Us",null,false,false,true,false,false]
[56.72,47.16,36.42,49.56,39.25,"Compressor R Us",null,false,false,true,false,false]
[47.91,35.08,51.129999999999995,49.84,42.12,"Bay Air",null,false,true,false,false,false]
[34.81,35.11,48.629999999999995,33.32,37.83,"Mech-Aid",null,false,false,false,true,false]
[42.25,35.76,58.6,46.28,40.53,"Bay Air",null,false,true,false,false,false]
[40.14,42.31,37.619999999999997,59.97,42.57,"Compressor R Us",null,false,false,true,false,false]
[36.480000000000004,40.79,53.239999999999995,51.010000000000005,51.239999999999995,"Crank'ys",null,true,false,false,false,false]
[38.57,40.06,54.71,39.700000000000003,54.730000000000004,"Crank'ys",null,true,false,false,false,false]
[52.66,43.61,59.980000000000004,34.61,52.65,"Mech-Aid",null,false,false,false,true,false]

{"sheet":"CF(41)","index":27,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Format intersecting cell"]
[]
["Sales Rep","Sioux"]
["Month","Feb"]
[]
["Sales Rep","Jan","Feb","Mar","Apr","May","Jun"]
["Fred",74013,126962,104833,122227,126482,109129]
["Sioux",101176,124102,106755,55589,84046,119333]
["Chin",50734,106591,98950,93474,128035,69383]
["Sheliadawn",119764,75350,82873,55768,95833,64097]
["Tyrone",66714,50370,128610,63971,127042,128302]
[]
[null,{"$f":"AND(B$6=$B$4,$A7=$B$3)","v":false},{"$f":"AND(C$6=$B$4,$A7=$B$3)","v":false},false,false,false,false]
[null,{"$f":"AND(B$6=$B$4,$A8=$B$3)","v":false},true,false,false,false,false]
[null,{"$f":"AND(B$6=$B$4,$A9=$B$3)","v":false},false,false,false,false,false]
[null,{"$f":"AND(B$6=$B$4,$A10=$B$3)","v":false},false,false,false,false,false]
[null,{"$f":"AND(B$6=$B$4,$A11=$B$3)","v":false},false,false,false,false,false]

{"sheet":"CF(42)","index":28,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Format row based on Approximate Match based on VLOOKUP",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((ROWS(B$13:B13)*7-7-COLUMNS($B13:B13))<0,0,ROWS(B$13:B13)*7-7-COLUMNS($B13:B13))","v":0}]
[]
["Income",4589.25]
["Allowances",2]
[]
["Income/Allowances",0,1,2,3,4,5,6]
[0,0,0,0,0,0,0,0]
[500,6,5,4,3,2,1,0]
[1500,13,12,11,10,9,8,7]
[2750,20,19,18,17,16,15,14]
[5000,27,26,25,24,23,22,21]
[7000,34,33,32,31,30,29,28]
[]
[null,{"$f":"VLOOKUP($B$3,$A$7:$A$12,1)=$A7","v":false},false,false,false,false,false,false]
[null,false,false,false,false,false,false,false]
[null,false,false,false,false,false,false,false]
[null,true,true,true,true,true,true,true]
[null,false,false,false,false,false,false,false]
[null,false,false,false,false,false,false,false]

{"sheet":"CF(43)","index":29,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Format row, column and intersection value",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((ROWS(B$6:B6)*7-7-COLUMNS($B6:B6))<0,0,ROWS(B$6:B6)*7-7-COLUMNS($B6:B6))","v":0}]
[]
["Income",4589.25]
["Allowances",2]
[]
["Income/Allowances",0,1,2,3,4,5,6]
[0,0,0,0,0,0,0,0]
[500,6,5,4,3,2,1,0]
[1500,13,12,11,10,9,8,7]
[2750,20,19,18,17,16,15,14]
[5000,27,26,25,24,23,22,21]
[7000,34,33,32,31,30,29,28]
[]
[null,{"$f":"AND(VLOOKUP($B$3,$A$7:$A$12,1)=$A7,B$6=$B$4)","v":false},false,false,false,false,false,false]
[null,false,false,false,false,false,false,false]
[null,false,false,false,false,false,false,false]
[null,false,false,true,false,false,false,false]
[null,false,false,false,false,false,false,false]
[null,false,false,false,false,false,false,false]

{"sheet":"CF(44-45)","index":30,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Gantt Chart for Days"]
["Format Weekends and Holidays NOT WORKDAY.INTL NETWORKDAYS.INTL function"]
[]
["Weekends =","Sunday"]
["Holidays","2014-01-01"]
[null,null,null,null,{"$f":"E7","v":"2013-12-30"},{"$f":"F7","v":"2013-12-31"},"2014-01-01","2014-01-02","2014-01-03","2014-01-04","2014-01-05","2014-01-06","2014-01-07","2014-01-08"]
["Project","Start Date","Days","End Date","2013-12-30","2013-12-31","2014-01-01","2014-01-02","2014-01-03","2014-01-04","2014-01-05","2014-01-06","2014-01-07","2014-01-08"]
["Main St.","2013-12-30",4,{"$f":"IF(COUNTA(A8:C8)=3,WORKDAY.INTL(B8,C8,11,$B$5)-1,\"\")","v":"2014-01-03"}]
["3476 14th","2013-12-31",3,{"$f":"IF(COUNTA(A9:C9)=3,WORKDAY.INTL(B9,C9,11,$B$5)-1,\"\")","v":"2014-01-03"}]
["Downtown","2014-01-02",4,"2014-01-06"]
["Project","2014-01-02",5,"2014-01-07"]
[null,null,null,""]
[]
[null,null,null,null,{"$f":"AND(E$7>=$B8,E$7<=$D8,ISNUMBER($D8))","v":true},{"$f":"AND(F$7>=$B8,F$7<=$D8,ISNUMBER($D8))","v":true},true,true,true,false,false,false,false,false]
[null,null,null,null,{"$f":"AND(E$7>=$B9,E$7<=$D9,ISNUMBER($D9))","v":false},true,true,true,true,false,false,false,false,false]
[null,null,null,null,{"$f":"AND(E$7>=$B10,E$7<=$D10,ISNUMBER($D10))","v":false},false,false,true,true,true,true,true,false,false]
[null,null,null,null,{"$f":"AND(E$7>=$B11,E$7<=$D11,ISNUMBER($D11))","v":false},false,false,true,true,true,true,true,true,false]
[null,null,null,null,{"$f":"AND(E$7>=$B12,E$7<=$D12,ISNUMBER($D12))","v":false},false,false,false,false,false,false,false,false,false]
[]
[null,null,null,null,{"$f":"AND(NOT(NETWORKDAYS.INTL(E$7,E$7,11,$B$5)),E$7>=$B8,E$7<=$D8,ISNUMBER($D8))","v":false},{"$f":"AND(NOT(NETWORKDAYS.INTL(F$7,F$7,11,$B$5)),F$7>=$B8,F$7<=$D8,ISNUMBER($D8))","v":false},true,false,false,false,false,false,false,false]
[null,null,null,null,{"$f":"AND(NOT(NETWORKDAYS.INTL(E$7,E$7,11,$B$5)),E$7>=$B9,E$7<=$D9,ISNUMBER($D9))","v":false},false,true,false,false,false,false,false,false,false]
[null,null,null,null,{"$f":"AND(NOT(NETWORKDAYS.INTL(E$7,E$7,11,$B$5)),E$7>=$B10,E$7<=$D10,ISNUMBER($D10))","v":false},false,false,false,false,false,true,false,false,false]
[null,null,null,null,{"$f":"AND(NOT(NETWORKDAYS.INTL(E$7,E$7,11,$B$5)),E$7>=$B11,E$7<=$D11,ISNUMBER($D11))","v":false},false,false,false,false,false,true,false,false,false]
[null,null,null,null,{"$f":"AND(NOT(NETWORKDAYS.INTL(E$7,E$7,11,$B$5)),E$7>=$B12,E$7<=$D12,ISNUMBER($D12))","v":false},false,false,false,false,false,false,false,false,false]

{"sheet":"CF(46)","index":31,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Format Duplicates Formula: 2 methods"]
[]
[]
["Built-in:",null,"Formula:"]
["Names",null,"Names"]
["Jo",null,"Jo",null,{"$f":"COUNTIF(C$6:C6,C6)>1","v":false}]
["Phil",null,"Phil",null,{"$f":"COUNTIF(C$6:C7,C7)>1","v":false}]
["Gigi",null,"Gigi",null,{"$f":"COUNTIF(C$6:C8,C8)>1","v":false}]
["Jo",null,"Jo",null,{"$f":"COUNTIF(C$6:C9,C9)>1","v":true}]
["Gigi",null,"Gigi",null,{"$f":"COUNTIF(C$6:C10,C10)>1","v":true}]
["Tyrone",null,"Tyrone",null,{"$f":"COUNTIF(C$6:C11,C11)>1","v":false}]
["Smitty",null,"Smitty",null,{"$f":"COUNTIF(C$6:C12,C12)>1","v":false}]
["Smitty",null,"Smitty",null,{"$f":"COUNTIF(C$6:C13,C13)>1","v":true}]

{"sheet":"CF(47)","index":32,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Format items in List 2 that are NOT in List 1"]
[]
[]
["List 1",null,"List 2"]
["Gigi",null,"Gigi",null,{"$f":"ISNA(MATCH(C5,$A$5:$A$12,0))","v":false}]
["Batty",null,"Timmy",null,true]
["Tom",null,"Batty",null,false]
["Chim",null,"Rob",null,true]
["Pham",null,"Kim",null,true]
["Lim",null,"Lim",null,false]
["Susan",null,"Hal",null,false]
["Hal",null,"Bobbie",null,true]
[null,null,"Fran",null,true]

{"sheet":"CF(48)","index":33,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Format items that are in List 2 that are also in List 1 (Errors are ignored, Any non-zero number = TRUE)."]
[]
[]
["List 1",null,"List 2"]
["Gigi",null,"Gigi",null,{"$f":"MATCH(C5,$A$5:$A$12,0)","v":1}]
["Batty",null,"Timmy",null,{"$f":"MATCH(C6,$A$5:$A$12,0)","v":{"$error":"#N/A"}}]
["Tom",null,"Batty",null,2]
["Chim",null,"Rob",null,{"$error":"#N/A"}]
["Pham",null,"Kim",null,{"$error":"#N/A"}]
["Lim",null,"Lim",null,6]
["Susan",null,"Hal",null,8]
["Hal",null,"Bobbie",null,{"$error":"#N/A"}]
[null,null,"Fran",null,{"$error":"#N/A"}]

{"sheet":"CF(49)","index":34,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Format stocks with a loss"]
[]
[]
["Stock","Buy Price","Price today","Quantity","Profit",null,"Value:"]
["GOOG",755,1015,700,{"$f":"D5*(C5-B5)","v":182000},null,0]
["GE",22,29.1,2200,15620.000000000004]
["KO",36,37,300,300]
["MSFT",36,36,4000,0]
["KK",51,42,700,-6300]
["SW",31,17,400,-5600]

{"sheet":"CF(50)","index":35,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Format Product with no Sales: COUNTA (Any non-zero number = TRUE, Zero = FALSE)"]
[]
[]
[null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10"]
["Product 1",4]
["Product 2",null,null,null,null,null,null,null,4]
["Product 3",null,null,null,3,null,34]
["Product 4",null,null,34]
["Product 5",3]
["Product 6"]
["Product 7"]
["Product 8",null,null,null,3,null,4,null,5]
["Product 9",3,3]
["Product 10"]
["Product 11"]

{"sheet":"CF(51)","index":36,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["MAX For Seattle (Array Formulas work in Conditional Formatting dialog box)",null,null,null,null,null,null,null,null,null,"City"]
[null,null,null,null,null,null,null,null,null,null,"Seattle"]
[null,null,null,null,"City","Max",null,null,null,null,"Oakland"]
["City","Rep","Sales",null,"Oakland",{"$f":"MAX(IF($A$5:$A$11=$E$4,$C$5:$C$11))","v":388},null,null,null,null,"Berkeley"]
["Seattle","Rep 2",561]
["Oakland","Rep 1",282]
["Berkeley","Rep 2",685]
["Oakland","Rep 1",388]
["Seattle","Rep 2",785]
["Seattle","Rep 2",687]
["Berkeley","Rep 1",674]