{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Title","Sheet1","Unsorted","Wrap Up"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":18,"comments":0,"pivot_tables":1},"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2075]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: stevepb / Pixabay"]

{"sheet":"Sheet1","index":1,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Customer","Sum of Revenue","Sum of Profit","GP%"]
["Association for Computers & Taxation",34192,14648,0.42840430510060834]
["Blockhead Data Consultants",30186,13228,0.43821639170476379]
["BradEdgar.com",35202,15632,0.44406567808647235]
["Clarity Consultancy Services Ltd",0,654.60000000000036,0]
["Construction Intelligence & Analytics, Inc.",0,752.40000000000146,0]
["CPASelfStudy.com",23592,10864,0.46049508307900983]
["F-Keys Ltd",33576,14648,0.43626399809387656]
["Hartville Marketplace & Flea Market",0,511,0]
["Hybrid Software",8668,3563,0.41105214582371941]
["IMA Houston Chapter",0,474,0]
["Juliet Babcock-Hyde CPA, PLLC",0,185.80000000000018,0]
["Open Sky Martial Arts",39960,17108,0.42812812812812812]
["Spain Enterprise",0,1230.0000000000018,0]
["SurtenExcel.com",0,127.30000000000018,0]
["The Salem Historical Society, Salem, Ohio",0,105.80000000000018,0]
["Wag More Dog Store, San Antonio",32868,14280,0.434465133260314]
["Grand Total",238244,108011.90000000001,0.45336671647554611]

{"sheet":"Unsorted","index":2,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Sales Rep","Date","Customer","Quantity","Product","Revenue","Profit","Cost"]
["David Ringstrom","2018-01-04","Association for Computers & Taxation",800,"Gadget",18552,7872,10680]
["David Ringstrom","2018-01-31","Association for Computers & Taxation",800,"Widget",15640,6776,8864]
["Peter Susen","2018-01-07","Blockhead Data Consultants",400,"Widget",8456,3388,5068]
["Peter Susen","2018-01-07","Blockhead Data Consultants",1000,"Gadget",21730,9840,11890]
["Geoffrey G Lilley","2018-01-23","BradEdgar.com",800,"Widget",14592,6776,7816]
["Geoffrey G Lilley","2018-02-26","BradEdgar.com",900,"Gadget",20610,8856,11754]
["David Ringstrom","2018-01-16","Clarity Consultancy Services Ltd",600,"Widget",11628,5082,6546]
["David Ringstrom","2018-02-20","Clarity Consultancy Services Ltd",600,"Widget",-11628,{"$f":"F9-H9","v":-4427.3999999999996},-7200.6]
["P B Rayudu","2018-01-24","Construction Intelligence & Analytics, Inc.",600,"Widget",12606,5082,7524]
["P B Rayudu","2018-02-27","Construction Intelligence & Analytics, Inc.",600,"Widget",-12606,{"$f":"F11-H11","v":-4329.5999999999985},-8276.4000000000015]
["Kevin J Sullivan","2018-01-04","CPASelfStudy.com",400,"Gizmo",9152,4088,5064]
["Kevin J Sullivan","2018-01-21","CPASelfStudy.com",800,"Doodads",14440,6776,7664]
["Michael Dietterick","2018-01-09","F-Keys Ltd",800,"Widget",16416,6776,9640]
["Michael Dietterick","2018-02-03","F-Keys Ltd",800,"Gadget",17160,7872,9288]
["Kevin J Sullivan","2018-01-15","Hartville Marketplace & Flea Market",500,"Widget",9345,4235,5110]
["Kevin J Sullivan","2018-02-20","Hartville Marketplace & Flea Market",500,"Widget",-9345,{"$f":"F17-H17","v":-3724},-5621]
["P B Rayudu","2018-01-12","Hybrid Software",300,"Widget",6267,2541,3726]
["P B Rayudu","2018-01-14","Hybrid Software",100,"Gizmo",2401,1022,1379]
["David Ringstrom","2018-01-26","IMA Houston Chapter",400,"Widget",8128,3388,4740]
["David Ringstrom","2018-03-01","IMA Houston Chapter",400,"Widget",-8128,{"$f":"F21-H21","v":-2914},-5214]
["Michael Dietterick","2018-01-21","Juliet Babcock-Hyde CPA, PLLC",200,"Doodads",3552,1694,1858]
["Michael Dietterick","2018-02-07","Juliet Babcock-Hyde CPA, PLLC",200,"Doodads",-3552,{"$f":"F23-H23","v":-1508.1999999999998},-2043.8000000000002]
["Geoffrey G Lilley","2018-01-01","Open Sky Martial Arts",1000,"Gizmo",22810,10220,12590]
["Geoffrey G Lilley","2018-01-29","Open Sky Martial Arts",700,"Gadget",17150,6888,10262]
["Kevin J Sullivan","2018-01-25","Spain Enterprise",1000,"Widget",20770,8470,12300]
["Kevin J Sullivan","2018-02-08","Spain Enterprise",1000,"Widget",-20770,{"$f":"F27-H27","v":-7239.9999999999982},-13530.000000000002]
["P B Rayudu","2018-01-02","SurtenExcel.com",100,"Gadget",2257,984,1273]
["P B Rayudu","2018-01-29","SurtenExcel.com",100,"Gadget",-2257,{"$f":"F29-H29","v":-856.69999999999982},-1400.3000000000002]
["Peter Susen","2018-01-19","The Salem Historical Society, Salem, Ohio",100,"Gadget",2042,984,1058]
["Peter Susen","2018-02-26","The Salem Historical Society, Salem, Ohio",100,"Gadget",-2042,{"$f":"F31-H31","v":-878.19999999999982},-1163.8000000000002]
["Geoffrey G Lilley","2018-01-10","Wag More Dog Store, San Antonio",900,"Gizmo",21438,9198,12240]
["Geoffrey G Lilley","2018-02-17","Wag More Dog Store, San Antonio",600,"Widget",11430,5082,6348]

{"sheet":"Wrap Up","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Create a calculated field within a pivot table"]
[null,"Give the calculated field a name that you don't like so you can change it later."]
[null,"That field might be returning errors such as Division by Zero"]
[null,"Choice 1: Suppress Errors when Printing"]
[null,"Choice 2: Wrap the calculation in IFERROR"]
[null,"In a pivot table, the second argument of IFERROR has to be numeric"]
[null,"Use a Number Format of 0.0%;-0.0%;; to hide the zeroes"]