{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Documentation","Consolidated","Manchester","Sales Data Entry Form"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":1,"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":"Documentation","index":0,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,1],[3,0,3,1],[7,0,9,2]]}
["New Perspectives Excel 2013"]
["Tutorial 7: SAM Project 1a"]
["Spring Software"]
["CUSTOMIZING WORKBOOKS USING MACROS AND DATA VALIDATION"]
[]
["Author:"]
[]
["Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website."]

{"sheet":"Consolidated","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,2,5]]}
[]
[null,"Spring Software-Consolidated Sales"]
[null,"Product Revenues"]
[null,"Revenues","2014","2015","2016","Total","Trend"]
[null,"Spring Groupware"]
[null,"Subscriptions",5372865.3000000007,5390853,{"$f":"5803769.4","v":5803769.4000000004},{"$f":"SUM(C6:E6)","v":16567487.700000001}]
[null,"Site Licenses",2442211.5,3096873,3957115.5,{"$f":"SUM(C7:E7)","v":9496200}]
[null,"Other",1953769.2000000002,2982174,3429500.1,8365443.3000000007]
[null,"Groupware Total",{"$f":"SUM(C6:C8)","v":9768846},{"$f":"SUM(D6:D8)","v":11469900},{"$f":"SUM(E6:E8)","v":13190385},{"$f":"SUM(F6:F8)","v":34429131}]
[null,"Spring Mail"]
[null,"Subscriptions",875957.85420000006,1967212.7999999998,{"$f":"2638607.4","v":2638607.4},{"$f":"SUM(C11:E11)","v":5481778.0541999992}]
[null,"Site Licenses",1112703.2202000001,2866510.08,4397679,{"$f":"SUM(C12:E12)","v":8376892.3002000004}]
[null,"Other",378792.58560000005,786885.12000000011,959493.6,2125171.3056000001]
[null,"Spring Mail Total",{"$f":"SUM(C11:C13)","v":2367453.66},{"$f":"SUM(D11:D13)","v":5620608},7995780,15983841.66]
[null,"Spring Math Genius"]
[null,"Subscriptions",249522.6,316785.48,150450]
[null,"Site Licenses",939379.20000000007,1017048.12,51000]
[null,"Other",278878.2,333458.40000000002,53550]
[null,"Math Genius Total",1467780,1667292,255000,{"$f":"SUM(F16:F18)","v":0}]
[null,"Consulting Services",13734300,15810000,19125000,48669300]
[]
[null,"Total",{"$f":"C9+C14+C19+C20","v":27338379.66},{"$f":"D9+D14+D19+D20","v":34567800},40566165,99082272.659999996]

{"sheet":"Manchester","index":2,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,2,5]]}
[]
[null,"Spring Software-Manchester Sales"]
[null,"Product Revenues"]
[null,"Revenues","2014","2015","2016","Total","Trend"]
[null,"Spring Groupware"]
[null,"Subscriptions",268643.26500000007,269542.65000000002,290188.47000000003,{"$f":"SUM(C6:E6)","v":828374.38500000001}]
[null,"Site Licenses",122110.57500000001,154843.65,197855.77500000002,{"$f":"SUM(C7:E7)","v":474810}]
[null,"Other",97688.460000000021,149108.70000000001,171475.005,418272.16500000004]
[null,"Groupware Total",{"$f":"SUM(C6:C8)","v":488442.3000000001},{"$f":"SUM(D6:D8)","v":573495},{"$f":"SUM(E6:E8)","v":659519.25},{"$f":"SUM(F6:F8)","v":1721456.55}]
[null,"Spring Mail"]
[null,"Subscriptions",87595.785420000015,196721.28,263860.74,{"$f":"SUM(C11:E11)","v":548177.80541999999}]
[null,"Site Licenses",111270.32202000002,286651.00800000003,439767.9,{"$f":"SUM(C12:E12)","v":837689.23002000013}]
[null,"Other",37879.258560000009,78688.512000000017,95949.36,212517.13056000002]
[null,"Spring Mail Total",{"$f":"SUM(C11:C13)","v":236745.36600000007},{"$f":"SUM(D11:D13)","v":562060.80000000005},799578,1598384.1660000002]
[null,"Spring Math Genius"]
[null,"Subscriptions",87332.91,110874.91799999999,52657.5,{"$f":"SUM(C16:E16)","v":250865.32799999998}]
[null,"Site Licenses",328782.72000000003,355966.842,17850,{"$f":"SUM(C17:E17)","v":702599.56200000003}]
[null,"Other",97607.37,116710.44,18742.5,233060.31]
[null,"Math Genius Total",1467780,1667292,255000,{"$f":"SUM(F16:F18)","v":1186525.2}]
[null,"Consulting Services",6180435,7114500,8606250,48669300]
[]
[null,"Total",{"$f":"C9+C14+C19+C20","v":8373402.6660000002},{"$f":"D9+D14+D19+D20","v":9917347.8000000007},10320347.25,53175665.916000001]

{"sheet":"Sales Data Entry Form","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[3,1,3,2]]}
[]
[]
[null,"Spring Software "]
[null,"Sales Data Entry Form"]
[null,"Product Name"]
[null,"Customer Name"]
[null,"Contract Type"]
[null,"Date of Sale"]
[null,"Total Sale"]
[null,"Spring Sales Contact","Rohan Mateev"]