{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Daily Budget Data","Daily Budget Pivot Table","NY Rangers Web Query","Movie Grosses Data","Movie Pivot Table","Nested if function","Macro"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":3},"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":"Daily Budget Data","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Item","Day 1"]
["bread",4]
["gas",25]
["gifts",75]
["groceries",90]
["groceries",35]
["pen",0]
["scooter",70]
["shirt",75]
["shoes",150]

{"sheet":"Daily Budget Pivot Table","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Count of Item","Min of Day 1","Max of Day 1_2","Average of Day 1_2"]
["0-19",2,0,4,2]
["20-39",2,25,35,30]
["60-79",3,70,75,73.333333333333329]
["80-99",1,90,90,90]
["140-159",1,150,150,150]
["Grand Total",9,0,150,58.222222222222221]

{"sheet":"NY Rangers Web Query","index":2,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["#","Pos","Player","GP ","G","A ","P ","+/- ","PIM ","PP ","SH ","GW ","S ","S% ",null,null,null,"Player","(Multiple Items)"]
[19,"C","Brad Richards",6,4,3,7,-1,2,1,0,1,27,14.8]
[21,"C","Derek Stepan",6,0,5,5,-7,0,0,0,0,10,0,null,null,null,"Count of Player","Column Labels"]
[16,"C","Derick Brassard",6,0,4,4,1,4,0,0,0,7,0,null,null,null,"Row Labels",0,3,"Grand Total"]
[61,"L","Rick Nash",3,0,3,3,0,5,0,0,0,9,0,null,null,null,"1-10",3,null,3]
[24,"R","Ryan Callahan",5,3,0,3,-5,0,2,0,0,14,21.4,null,null,null,"11-20",null,1,1]
[22,"C","Brian Boyle",6,0,2,2,-1,6,0,0,0,18,0,null,null,null,"Grand Total",3,1,4]
[27,"D","Ryan McDonagh",6,1,1,2,-3,0,0,1,0,4,25]
[18,"D","Marc Staal",6,1,0,1,-7,2,1,0,0,8,12.5]
[6,"D","Anton Stralman",6,0,1,1,-2,8,0,0,0,7,0]
[15,"R","Derek Dorsett",6,1,0,1,-2,32,0,0,0,7,14.3]
[17,"D","John Moore",6,1,0,1,-3,2,0,0,1,11,9.1]
[45,"R","Arron Asham",3,0,0,0,-3,14,0,0,0,1,0]
[14,"L","Taylor Pyatt",6,0,0,0,-6,2,0,0,0,9,0]
[28,"C","Dominic Moore",6,0,0,0,-4,4,0,0,0,4,0]
[67,"L","Benoit Pouliot",6,0,0,0,-3,4,0,0,0,11,0]
[5,"D","Dan Girardi",6,0,0,0,-6,2,0,0,0,6,0]
[44,"D","Justin Falk",2,0,0,0,0,9,0,0,0,2,0]
[4,"D","Michael Del Zotto",5,0,0,0,-6,0,0,0,0,7,0]
[36,"L","Mats Zuccarello",6,0,0,0,-2,2,0,0,0,5,0]
[12,"R","Jesper Fast",4,0,0,0,-4,0,0,0,0,3,0]
[10,"C","J.T. Miller",2,0,0,0,0,2,0,0,0,1,0]

{"sheet":"Movie Grosses Data","index":3,"n_rows":128,"n_cols":10,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
["Rank","Title","Studio","Worldwide","Domestic","%","Overseas","%","Year","If function"]
[1,"Avatar","Fox",2782.3,760.5,0.27300000000000002,2021.8,0.72699999999999998,2009,{"$f":"IF(D2>800,\"over800Million\",\"under800million\")","v":"over800Million"}]
[2,"Titanic","Par.",2186.8000000000002,658.7,0.30099999999999999,1528.1,0.69899999999999995,1997,{"$f":"IF(D3>800,\"over800Million\",\"under800million\")","v":"over800Million"}]
[3,"Marvel's The Avengers","BV",1511.8,623.4,0.41199999999999998,888.4,0.58799999999999997,2012,"over800Million"]
[4,"Harry Potter and the Deathly Hallows Part 2","WB",1341.5,381,0.28399999999999997,960.5,0.71599999999999997,2011,"over800Million"]
[5,"Iron Man 3","BV",1214.7,409,0.33700000000000002,805.7,0.66300000000000003,2013,"over800Million"]
[6,"Transformers: Dark of the Moon","P/DW",1123.8,352.4,0.314,771.4,0.68600000000000005,2011,"over800Million"]
[7,"The Lord of the Rings: The Return of the King","NL",1119.9000000000001,377.8,0.33700000000000002,742.1,0.66300000000000003,2003,"over800Million"]
[8,"Skyfall","Sony",1108.5999999999999,304.39999999999998,0.27500000000000002,804.2,0.72499999999999998,2012,"over800Million"]
[9,"The Dark Knight Rises","WB",1084.4000000000001,448.1,0.41299999999999998,636.29999999999995,0.58699999999999997,2012,"over800Million"]
[10,"Pirates of the Caribbean: Dead Man's Chest","BV",1066.2,423.3,0.39700000000000002,642.9,0.60299999999999998,2006,"over800Million"]
[11,"Toy Story 3","BV",1063.2,415,0.39,648.20000000000005,0.61,2010,"over800Million"]
[12,"Pirates of the Caribbean: On Stranger Tides","BV",1043.9000000000001,241.1,0.23100000000000001,802.8,0.76900000000000002,2011,"over800Million"]
[13,"Jurassic Park","Uni.",1029.2,402.5,0.39100000000000001,626.70000000000005,0.60899999999999999,1993,"over800Million"]
[14,"Star Wars: Episode I - The Phantom Menace","Fox",1027,474.5,0.46200000000000002,552.5,0.53800000000000003,1999,"over800Million"]
[15,"Alice in Wonderland (2010)","BV",1024.3,334.2,0.32600000000000001,690.1,0.67400000000000004,2010,"over800Million"]
[16,"The Hobbit: An Unexpected Journey","WB",1017,303,0.29799999999999999,714,0.70199999999999996,2012,"over800Million"]
[17,"The Dark Knight","WB",1004.6,534.9,0.53200000000000003,469.7,0.46800000000000003,2008,"over800Million"]
[18,"Harry Potter and the Sorcerer's Stone","WB",974.8,317.60000000000002,0.32600000000000001,657.2,0.67400000000000004,2001,"over800Million"]
[19,"Pirates of the Caribbean: At World's End","BV",963.4,309.39999999999998,0.32100000000000001,654,0.67900000000000005,2007,"over800Million"]
[20,"The Lion King","BV",961.5,422.8,0.44,538.70000000000005,0.56000000000000005,1994,"over800Million"]
[21,"Harry Potter and the Deathly Hallows Part 1","WB",960.3,296,0.308,664.3,0.69199999999999995,2010,"over800Million"]
[22,"Harry Potter and the Order of the Phoenix","WB",939.9,292,0.311,647.9,0.68899999999999995,2007,"over800Million"]
[23,"Harry Potter and the Half-Blood Prince","WB",934.4,302,0.32300000000000001,632.5,0.67700000000000005,2009,"over800Million"]
[24,"The Lord of the Rings: The Two Towers","NL",926,342.6,0.37,583.5,0.63,2002,"over800Million"]
[25,"Finding Nemo","BV",921.7,380.8,0.41299999999999998,540.9,0.58699999999999997,2003,"over800Million"]
[26,"Shrek 2","DW",919.8,441.2,0.48,478.6,0.52,2004,"over800Million"]
[27,"Harry Potter and the Goblet of Fire","WB",896.9,290,0.32300000000000001,606.9,0.67700000000000005,2005,"over800Million"]
[28,"Spider-Man 3","Sony",890.9,336.5,0.378,554.29999999999995,0.622,2007,"over800Million"]
[29,"Ice Age: Dawn of the Dinosaurs","Fox",886.7,196.6,0.222,690.1,0.77800000000000002,2009,"over800Million"]
[30,"Despicable Me 2","Uni.",885.4,363.3,0.41,522.1,0.59,2013,"over800Million"]
[31,"Harry Potter and the Chamber of Secrets","WB",879,262,0.29799999999999999,617,0.70199999999999996,2002,"over800Million"]
[32,"Ice Age: Continental Drift","Fox",877.2,161.30000000000001,0.184,715.9,0.81599999999999995,2012,"over800Million"]
[33,"The Lord of the Rings: The Fellowship of the Ring","NL",871.5,315.5,0.36199999999999999,556,0.63800000000000001,2001,"over800Million"]
[34,"Star Wars: Episode III - Revenge of the Sith","Fox",848.8,380.3,0.44800000000000001,468.5,0.55200000000000005,2005,"over800Million"]
[35,"Transformers: Revenge of the Fallen","P/DW",836.3,402.1,0.48099999999999998,434.2,0.51900000000000002,2009,"over800Million"]
[36,"The Twilight Saga: Breaking Dawn Part 2","LG/S",829.7,292.3,0.35199999999999998,537.4,0.64800000000000002,2012,"over800Million"]
[37,"Inception","WB",825.5,292.60000000000002,0.35399999999999998,533,0.64600000000000002,2010,"over800Million"]
[38,"Spider-Man","Sony",821.7,403.7,0.49099999999999999,418,0.50900000000000001,2002,"over800Million"]
[39,"Independence Day","Fox",817.4,306.2,0.375,511.2,0.625,1996,"over800Million"]
[40,"Shrek the Third","P/DW",799,322.7,0.40400000000000003,476.2,0.59599999999999997,2007,"under800million"]
[41,"Harry Potter and the Prisoner of Azkaban","WB",796.7,249.5,0.313,547.1,0.68700000000000006,2004,"under800million"]
[42,"E.T.: The Extra-Terrestrial","Uni.",792.9,435.1,0.54900000000000004,357.8,0.45100000000000001,1982,"under800million"]
[43,"Fast & Furious 6","Uni.",788.7,238.7,0.30299999999999999,550,0.69699999999999995,2013,"under800million"]
[44,"Indiana Jones and the Kingdom of the Crystal Skull","Par.",786.6,317.10000000000002,0.40300000000000002,469.5,0.59699999999999998,2008,"under800million"]
[45,"Spider-Man 2","Sony",783.8,373.6,0.47699999999999998,410.2,0.52300000000000002,2004,"under800million"]
[46,"Star Wars","Fox",775.4,461,0.59499999999999997,314.39999999999998,0.40500000000000003,1977,"under800million"]
[47,2012,"Sony",769.7,166.1,0.216,603.6,0.78400000000000003,2009,"under800million"]
[48,"The Da Vinci Code","Sony",758.2,217.5,0.28699999999999998,540.70000000000005,0.71299999999999997,2006,"under800million"]
[49,"Shrek Forever After","P/DW",752.6,238.7,0.317,513.9,0.68300000000000005,2010,"under800million"]
[50,"The Amazing Spider-Man","Sony",752.2,262,0.34799999999999998,490.2,0.65200000000000002,2012,"under800million"]
[51,"Madagascar 3: Europe's Most Wanted","P/DW",746.9,216.4,0.28999999999999998,530.5,0.71,2012,"under800million"]
[52,"The Chronicles of Narnia: The Lion, the Witch and the Wardrobe","BV",745,291.7,0.39200000000000002,453.3,0.60799999999999998,2005,"under800million"]
[53,"The Matrix Reloaded","WB",742.1,281.60000000000002,0.379,460.6,0.621,2003,"under800million"]
[54,"Monsters University","BV",737.6,267.2,0.36199999999999999,470.4,0.63800000000000001,2013,"under800million"]
[55,"Up","BV",731.3,293,0.40100000000000002,438.3,0.59899999999999998,2009,"under800million"]
[56,"The Twilight Saga: Breaking Dawn Part 1","Sum.",712.2,281.3,0.39500000000000002,430.9,0.60499999999999998,2011,"under800million"]
[57,"The Twilight Saga: New Moon","Sum.",709.8,296.60000000000002,0.41799999999999998,413.2,0.58199999999999996,2009,"under800million"]
[58,"Transformers","P/DW",709.7,319.2,0.45,390.5,0.55000000000000004,2007,"under800million"]
[59,"The Twilight Saga: Eclipse","Sum.",698.5,300.5,0.43,398,0.56999999999999995,2010,"under800million"]
[60,"Mission: Impossible - Ghost Protocol","Par.",694.7,209.4,0.30099999999999999,485.3,0.69899999999999995,2011,"under800million"]
[61,"The Hunger Games","LGF",691.2,408,0.59,283.2,0.41,2012,"under800million"]
[62,"Forrest Gump","Par.",677.4,329.7,0.48699999999999999,347.7,0.51300000000000001,1994,"under800million"]
[63,"The Sixth Sense","BV",672.8,293.5,0.436,379.3,0.56399999999999995,1999,"under800million"]
[64,"Kung Fu Panda 2","P/DW",665.7,165.2,0.248,500.4,0.752,2011,"under800million"]
[65,"Man of Steel","WB",662.8,291,0.439,371.8,0.56100000000000005,2013,"under800million"]
[66,"Ice Age: The Meltdown","Fox",655.4,195.3,0.29799999999999999,460.1,0.70199999999999996,2006,{"$f":"IF(D67>800,\"over800Million\",\"under800million\")","v":"under800million"}]
[67,"Pirates of the Caribbean: The Curse of the Black Pearl","BV",654.29999999999995,305.39999999999998,0.46700000000000003,348.9,0.53300000000000003,2003,"under800million"]
[68,"Star Wars: Episode II - Attack of the Clones","Fox",649.4,310.7,0.47799999999999998,338.7,0.52200000000000002,2002,"under800million"]
[69,"Kung Fu Panda","P/DW",631.70000000000005,215.4,0.34100000000000003,416.3,0.65900000000000003,2008,"under800million"]
[70,"The Incredibles","BV",631.4,261.39999999999998,0.41399999999999998,370,0.58599999999999997,2004,"under800million"]
[71,"Fast Five","Uni.",626.1,209.8,0.33500000000000002,416.3,0.66500000000000004,2011,"under800million"]
[72,"Hancock","Sony",624.4,227.9,0.36499999999999999,396.4,0.63500000000000001,2008,"under800million"]
[73,"MIB 3","Sony",624,179,0.28699999999999998,445,0.71299999999999997,2012,"under800million"]
[74,"Iron Man 2","Par.",623.9,312.39999999999998,0.501,311.5,0.499,2010,"under800million"]
[75,"Ratatouille","BV",623.70000000000005,206.4,0.33100000000000002,417.3,0.66900000000000004,2007,"under800million"]
[76,"The Lost World: Jurassic Park","Uni.",618.6,229.1,0.37,389.6,0.63,1997,"under800million"]
[77,"The Passion of the Christ","NM",611.9,370.8,0.60599999999999998,241.1,0.39400000000000002,2004,"under800million"]
[78,"Mamma Mia!","Uni.",609.79999999999995,144.1,0.23599999999999999,465.7,0.76400000000000001,2008,"under800million"]
[79,"Life of Pi","Fox",609,125,0.20499999999999999,484,0.79500000000000004,2012,"under800million"]
[80,"Madagascar: Escape 2 Africa","P/DW",603.9,180,0.29799999999999999,423.9,0.70199999999999996,2008,"under800million"]
[81,"Casino Royale","Sony",599,167.4,0.28000000000000003,431.6,0.72,2006,"under800million"]
[82,"War of the Worlds","Par.",591.70000000000005,234.3,0.39600000000000002,357.5,0.60399999999999998,2005,"under800million"]
[83,"Tangled","BV",590.70000000000005,200.8,0.34,389.9,0.66,2010,"under800million"]
[84,"Men in Black","Sony",589.4,250.7,0.42499999999999999,338.7,0.57499999999999996,1997,"under800million"]
[85,"The Hangover Part II","WB",586.79999999999995,254.5,0.434,332.3,0.56599999999999995,2011,"under800million"]
[86,"Quantum of Solace","Sony",586.1,168.4,0.28699999999999998,417.7,0.71299999999999997,2008,"under800million"]
[87,"I Am Legend","WB",585.29999999999995,256.39999999999998,0.438,329,0.56200000000000006,2007,"under800million"]
[88,"The Croods","Fox",585.20000000000005,187.2,0.32,398,0.68,2013,"under800million"]
[89,"Iron Man","Par.",585.20000000000005,318.39999999999998,0.54400000000000004,266.8,0.45600000000000002,2008,"under800million"]
[90,"Night at the Museum","Fox",574.5,250.9,0.437,323.60000000000002,0.56299999999999994,2006,"under800million"]
[91,"The Smurfs","Sony",563.70000000000005,142.6,0.253,421.1,0.747,2011,"under800million"]
[92,"Monsters, Inc.","BV",562.79999999999995,289.89999999999998,0.51500000000000001,272.89999999999998,0.48499999999999999,2001,"under800million"]
[93,"Cars 2","BV",559.9,191.5,0.34200000000000003,368.4,0.65800000000000003,2011,"under800million"]
[94,"Puss in Boots","P/DW",555,149.30000000000001,0.26900000000000002,405.7,0.73099999999999998,2011,"under800million"]
[95,"Armageddon","BV",553.70000000000005,201.6,0.36399999999999999,352.1,0.63600000000000001,1998,"under800million"]
[96,"King Kong","Uni.",550.5,218.1,0.39600000000000002,332.4,0.60399999999999998,2005,"under800million"]
[97,"Ted","Uni.",549.4,218.8,0.39800000000000002,330.6,0.60199999999999998,2012,"under800million"]
[98,"Mission: Impossible II","Par.",546.4,215.4,0.39400000000000002,331,0.60599999999999998,2000,"under800million"]
[99,"Sherlock Holmes: A Game of Shadows","WB",545.4,186.8,0.34300000000000003,358.6,0.65700000000000003,2011,"under800million"]
[100,"The Day After Tomorrow","Fox",544.29999999999995,186.7,0.34300000000000003,357.5,0.65700000000000003,2004,"under800million"]
[]
[null,null,"Total",{"$f":"SUM(D2:D102)","v":81373.999999999956},{"$f":"SUM(E2:E102)","v":29839.300000000014},null,51534.80000000001]
[null,null,"Average",{"$f":"AVERAGE(D2:D101)","v":813.73999999999955},{"$f":"AVERAGE(E2:E101)","v":298.39300000000014},null,{"$f":"AVERAGE(G2:G101)","v":515.34800000000007}]
[null,null,"Sumif greater than average",{"$f":"SUMIF(D2:D101,\">\"&AVERAGE(D2:D101))","v":41418.000000000007},{"$f":"SUMIF(E2:E101,\">\"&AVERAGE(E2:E101))","v":17111.300000000007},null,{"$f":"SUMIF(G2:G101,\">\"&AVERAGE(G2:G101))","v":26859.3}]
[]
[]
[]
[]
[]
[]
[null,null,"Pmt() function example"]
[null,null,"Loan Amount",22190]
[null,null,"Interest Rate",0.02]
[null,null,"Months",60]
[null,null,"Payment",{"$f":"-PMT(D114/12,D115,D113,0,0)","v":388.94099558149276}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"C113","v":"Loan Amount"}]
[]
[null,null,{"$f":"Macro!I1","v":"I recorded with relative references."}]

{"sheet":"Movie Pivot Table","index":4,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Overseas","Column Labels"]
["Row Labels","2000-2009","2010-2019","1990-1999","1980-1989","<1980","Grand Total"]
["BV",4138.5000000000009,5063.8999999999996,1270.0999999999999,null,null,10472.5]
["WB",4967.9000000000005,4570.8000000000011,null,null,null,9538.7000000000007]
["Fox",4660.3,1597.9,1063.7,null,314.39999999999998,7636.2999999999993]
["Sony",3772.5,2160.5,338.7,null,null,6271.7]
["P/DW",2141.1,2721.8999999999996,null,null,null,4863]
["Par.",1424.8,796.8,1875.8,null,null,4097.3999999999996]
["Uni.",798.09999999999991,1819,1016.3000000000001,357.8,null,3991.2]
["NL",1881.6,null,null,null,null,1881.6]
["Sum.",413.2,828.9,null,null,null,1242.0999999999999]
["LG/S",null,537.4,null,null,null,537.4]
["DW",478.6,null,null,null,null,478.6]
["LGF",null,283.2,null,null,null,283.2]
["NM",241.1,null,null,null,null,241.1]
["Grand Total",24917.7,20380.3,5564.6,357.8,314.39999999999998,51534.799999999988]

{"sheet":"Nested if function","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Player","Home Runs","Batting Average","Result"]
["John",10,0.2,{"$f":"IF(B2>=15,IF(C2>0.3,\"Home Run Batter and Good Batting Average\",\"\"),\"\")","v":""}]
["Jim",15,0.25,{"$f":"IF(B3>=15,IF(C3>0.3,\"Home Run Batter and Good Batting Average\",\"\"),\"\")","v":""}]
["Pat",20,0.3,""]
["Greg",25,0.35,"Home Run Batter and Good Batting Average"]
["Mike",30,0.4,"Home Run Batter and Good Batting Average"]
["Chris",10,0.2,""]
["Frank",15,0.25,""]
["Andrew",20,0.3,""]
["Jim",25,0.35,"Home Run Batter and Good Batting Average"]
["Alberto",30,0.4,"Home Run Batter and Good Batting Average"]

{"sheet":"Macro","index":6,"n_rows":4,"n_cols":16,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Date","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","I recorded with relative references.",null,null,null,null,null,null,"The shortcut for this macro is \"Control T\"."]
[]
[null,null,"Date","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","I recorded with relative references."]
[null,null,"Date","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","I recorded with relative references."]