{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Pivot Table","Data","Summary","macro"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Pivot Table","index":0,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Sum of Subtotal","Column Labels"]
["Row Labels","assembly","bolt & nut","circuit board","Grand Total"]
["5-14",null,240,65,305]
["15-24",20140,null,null,20140]
["Grand Total",20140,240,65,20445]

{"sheet":"Data","index":1,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Reference Table","Price","Description",null,"Macro Shortcut \"CTL + L\" Highlight Green"]
["SP123",20,"assembly"]
[4567,12,"bolt & nut",null,"Price List"]
["78f22",5,"circuit board",null,"Part No. ","Description","Price","Qty","Subtotal","level of service","tip percentage"]
[null,null,null,null,"SP123",{"$f":"VLOOKUP(E5,PricesAndDescription,3,0)","v":"assembly"},{"$f":"VLOOKUP(E5,PricesAndDescription,2,0)","v":20},1000,{"$f":"G5*H5","v":20000},"OK",{"$f":"IF(J5=\"good\",0.2,IF(J5=\"ok\",0.15,\"service is bad\"))","v":0.15},null,null,4,1,{"$f":"N5-O5","v":3}]
[null,null,null,null,4567,"bolt & nut",12,6,{"$f":"G6*H6","v":72},"good",{"$f":"IF(J6=\"good\",0.2,IF(J6=\"ok\",0.15,\"service is bad\"))","v":0.2},null,null,5,2,{"$f":"N6-O6","v":3}]
[null,null,null,null,"78f22","circuit board",5,2,10,"lousy","service is bad",null,null,6,3,{"$f":"N7-O7","v":3}]
[null,null,null,null,"SP123","assembly",20,3,60,"good",0.2]
[null,null,null,null,4567,"bolt & nut",12,4,48,"good",0.2]
[null,null,null,null,"78f22","circuit board",5,9,45,"good",0.2]
[null,null,null,null,"SP123","assembly",20,4,80,"good",0.2]
[null,null,null,null,4567,"bolt & nut",12,10,120,"ok",0.15]
[null,null,null,null,"78f22","circuit board",5,2,10,"ok",0.15]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I5:I14)","v":20445}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"E3","v":"Price List"},null,{"$f":"I15","v":20445}]
[]
[]
[]
["Auto fill example:"]
["2013-04-07","2013-04-14","2013-04-21","2013-04-28","2013-05-05","2013-05-12","2013-05-19","2013-05-26"]
[]
[]
[]
["Date shortcut \"CTL + ;\""]
["2013-04-08"]
[]
["Time shortcut \"CTL + SHIFT + ;\""]
["22:31:00"]

{"sheet":"Summary","index":2,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Data!E3","v":"Price List"},{"$f":"Data!I15","v":20445}]

{"sheet":"macro","index":3,"n_rows":472,"n_cols":2,"rows_kept":472,"cut":false,"hidden":false,"merged":[]}
["Number","Sum of Squares"]
[0,{"$f":"SumofSquares(A2)","v":0}]
[1,{"$f":"SumofSquares(A3)","v":1}]
[2,5]
[3,14]
[4,30]
[5,55]
[6,91]
[7,140]
[8,204]
[9,285]
[10,385]
[11,506]
[12,650]
[13,819]
[14,1015]
[15,1240]
[16,1496]
[17,1785]
[18,2109]
[19,2470]
[20,2870]
[21,3311]
[22,3795]
[23,4324]
[24,4900]
[25,5525]
[26,6201]
[27,6930]
[28,7714]
[29,8555]
[30,9455]
[31,10416]
[32,11440]
[33,12529]
[34,13685]
[35,14910]
[36,16206]
[37,17575]
[38,19019]
[39,20540]
[40,22140]
[41,23821]
[42,25585]
[43,27434]
[44,29370]
[45,31395]
[46,33511]
[47,35720]
[48,38024]
[49,40425]
[50,42925]
[51,45526]
[52,48230]
[53,51039]
[54,53955]
[55,56980]
[56,60116]
[57,63365]
[58,66729]
[59,70210]
[60,73810]
[61,77531]
[62,81375]
[63,85344]
[64,89440]
[65,{"$f":"SumofSquares(A67)","v":93665}]
[66,98021]
[67,102510]
[68,107134]
[69,111895]
[70,116795]
[71,121836]
[72,127020]
[73,132349]
[74,137825]
[75,143450]
[76,149226]
[77,155155]
[78,161239]
[79,167480]
[80,173880]
[81,180441]
[82,187165]
[83,194054]
[84,201110]
[85,208335]
[86,215731]
[87,223300]
[88,231044]
[89,238965]
[90,247065]
[91,255346]
[92,263810]
[93,272459]
[94,281295]
[95,290320]
[96,299536]
[97,308945]
[98,318549]
[99,328350]
[100,338350]
[101,348551]
[102,358955]
[103,369564]
[104,380380]
[105,391405]
[106,402641]
[107,414090]
[108,425754]
[109,437635]
[110,449735]
[111,462056]
[112,474600]
[113,487369]
[114,500365]
[115,513590]
[116,527046]
[117,540735]
[118,554659]
[119,568820]
[120,583220]
[121,597861]
[122,612745]
[123,627874]
[124,643250]
[125,658875]
[126,674751]
[127,690880]
[128,707264]
[129,{"$f":"SumofSquares(A131)","v":723905}]
[130,740805]
[131,757966]
[132,775390]
[133,793079]
[134,811035]
[135,829260]
[136,847756]
[137,866525]
[138,885569]
[139,904890]
[140,924490]
[141,944371]
[142,964535]
[143,984984]
[144,1005720]
[145,1026745]
[146,1048061]
[147,1069670]
[148,1091574]
[149,1113775]
[150,1136275]
[151,1159076]
[152,1182180]
[153,1205589]
[154,1229305]
[155,1253330]
[156,1277666]
[157,1302315]
[158,1327279]
[159,1352560]
[160,1378160]
[161,1404081]
[162,1430325]
[163,1456894]
[164,1483790]
[165,1511015]
[166,1538571]
[167,1566460]
[168,1594684]
[169,1623245]
[170,1652145]
[171,1681386]
[172,1710970]
[173,1740899]
[174,1771175]
[175,1801800]
[176,1832776]
[177,1864105]
[178,1895789]
[179,1927830]
[180,1960230]
[181,1992991]
[182,2026115]
[183,2059604]
[184,2093460]
[185,2127685]
[186,2162281]
[187,2197250]
[188,2232594]
[189,2268315]
[190,2304415]
[191,2340896]
[192,2377760]
[193,{"$f":"SumofSquares(A195)","v":2415009}]
[194,2452645]
[195,2490670]
[196,2529086]
[197,2567895]
[198,2607099]
[199,2646700]
[200,2686700]
[201,2727101]
[202,2767905]
[203,2809114]
[204,2850730]
[205,2892755]
[206,2935191]
[207,2978040]
[208,3021304]
[209,3064985]
[210,3109085]
[211,3153606]
[212,3198550]
[213,3243919]
[214,3289715]
[215,3335940]
[216,3382596]
[217,3429685]
[218,3477209]
[219,3525170]
[220,3573570]
[221,3622411]
[222,3671695]
[223,3721424]
[224,3771600]
[225,3822225]
[226,3873301]
[227,3924830]
[228,3976814]
[229,4029255]
[230,4082155]
[231,4135516]
[232,4189340]
[233,4243629]
[234,4298385]
[235,4353610]
[236,4409306]
[237,4465475]
[238,4522119]
[239,4579240]
[240,4636840]
[241,4694921]
[242,4753485]
[243,4812534]
[244,4872070]
[245,4932095]
[246,4992611]
[247,5053620]
[248,5115124]
[249,5177125]
[250,5239625]
[251,5302626]
[252,5366130]
[253,5430139]
[254,5494655]
[255,5559680]
[256,5625216]
[257,{"$f":"SumofSquares(A259)","v":5691265}]
[258,5757829]
[259,5824910]
[260,5892510]
[261,5960631]
[262,6029275]
[263,6098444]
[264,6168140]
[265,6238365]
[266,6309121]
[267,6380410]
[268,6452234]
[269,6524595]
[270,6597495]
[271,6670936]
[272,6744920]
[273,6819449]
[274,6894525]
[275,6970150]
[276,7046326]
[277,7123055]
[278,7200339]
[279,7278180]
[280,7356580]
[281,7435541]
[282,7515065]
[283,7595154]
[284,7675810]
[285,7757035]
[286,7838831]
[287,7921200]
[288,8004144]
[289,8087665]
[290,8171765]
[291,8256446]
[292,8341710]
[293,8427559]
[294,8513995]
[295,8601020]
[296,8688636]
[297,8776845]
[298,8865649]
[299,8955050]
[300,9045050]
[301,9135651]
[302,9226855]
[303,9318664]
[304,9411080]
[305,9504105]
[306,9597741]
[307,9691990]
[308,9786854]
[309,9882335]
[310,9978435]
[311,10075156]
[312,10172500]
[313,10270469]
[314,10369065]
[315,10468290]
[316,10568146]
[317,10668635]
[318,10769759]
[319,10871520]
[320,10973920]
[321,{"$f":"SumofSquares(A323)","v":11076961}]
[322,11180645]
[323,11284974]
[324,11389950]
[325,11495575]
[326,11601851]
[327,11708780]
[328,11816364]
[329,11924605]
[330,12033505]
[331,12143066]
[332,12253290]
[333,12364179]
[334,12475735]
[335,12587960]
[336,12700856]
[337,12814425]
[338,12928669]
[339,13043590]
[340,13159190]
[341,13275471]
[342,13392435]
[343,13510084]
[344,13628420]
[345,13747445]
[346,13867161]
[347,13987570]
[348,14108674]
[349,14230475]
[350,14352975]
[351,14476176]
[352,14600080]
[353,14724689]
[354,14850005]
[355,14976030]
[356,15102766]
[357,15230215]
[358,15358379]
[359,15487260]
[360,15616860]
[361,15747181]
[362,15878225]
[363,16009994]
[364,16142490]
[365,16275715]
[366,16409671]
[367,16544360]
[368,16679784]
[369,16815945]
[370,16952845]
[371,17090486]
[372,17228870]
[373,17367999]
[374,17507875]
[375,17648500]
[376,17789876]
[377,17932005]
[378,18074889]
[379,18218530]
[380,18362930]
[381,18508091]
[382,18654015]
[383,18800704]
[384,18948160]
[385,{"$f":"SumofSquares(A387)","v":19096385}]
[386,19245381]
[387,19395150]
[388,19545694]
[389,19697015]
[390,19849115]
[391,20001996]
[392,20155660]
[393,20310109]
[394,20465345]
[395,20621370]
[396,20778186]
[397,20935795]
[398,21094199]
[399,21253400]
[400,21413400]
[401,21574201]
[402,21735805]
[403,21898214]
[404,22061430]
[405,22225455]
[406,22390291]
[407,22555940]
[408,22722404]
[409,22889685]
[410,23057785]
[411,23226706]
[412,23396450]
[413,23567019]
[414,23738415]
[415,23910640]
[416,24083696]
[417,24257585]
[418,24432309]
[419,24607870]
[420,24784270]
[421,24961511]
[422,25139595]
[423,25318524]
[424,25498300]
[425,25678925]
[426,25860401]
[427,26042730]
[428,26225914]
[429,26409955]
[430,26594855]
[431,26780616]
[432,26967240]
[433,27154729]
[434,27343085]
[435,27532310]
[436,27722406]
[437,27913375]
[438,28105219]
[439,28297940]
[440,28491540]
[441,28686021]
[442,28881385]
[443,29077634]
[444,29274770]
[445,29472795]
[446,29671711]
[447,29871520]
[448,30072224]
[449,{"$f":"SumofSquares(A451)","v":30273825}]
[450,30476325]
[451,30679726]
[452,30884030]
[453,31089239]
[454,31295355]
[455,31502380]
[456,31710316]
[457,31919165]
[458,32128929]
[459,32339610]
[460,32551210]
[461,32763731]
[462,32977175]
[463,33191544]
[464,33406840]
[465,33623065]
[466,33840221]
[467,34058310]
[468,34277334]
[469,34497295]
[470,34718195]