{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Inventory","Menus","Issue","NOG","InvReport","Issue Invoice","NOG Invoice","InvCount"],"not_rendered":{"charts":0,"images":1,"macros":1,"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":"Inventory","index":0,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Date","Vendor","Area","Category","Type","Condition",null,"Size","Gender","Hand","Cost","Depreciation","Count","Description"]
["2010-08-04","Absolute Fencing Gear, Inc.","Weaponry","Barrel","Foil","New",null,null,null,null,22.95,2.87,9,"87004 - French Foil Barrel"]
["2010-08-04","Absolute Fencing Gear, Inc.","Weaponry","Barrel","Epee","New",null,null,null,null,15.3,1.91,6,"97004 - French Foil Barrel"]
["2010-08-04","Absolute Fencing Gear, Inc.","Weaponry","Wire","Epee","New",null,null,null,null,3.1880000000000002,0.4,1,"97008 - French Epee Wire"]
["2010-08-04","Absolute Fencing Gear, Inc.","Misc","DVD","N/A","New",null,null,null,null,35,4.38,1,"133028 - Referee Study Guide (2008-2009): DVD"]
["2010-08-04","Absolute Fencing Gear, Inc.","Attire","Jacket","N/A","New",null,42,"Male","Left",43.2,5.4,1,"21025-L42 AF Men's F/Z Comfort Jacket: L/H Size 42"]
["2010-08-24","Absolute Fencing Gear, Inc.","Attire","Mask","Foil","New",null,"Medium",null,null,36,4.5,1,"11001-M AF Standard 3-W Mask: M"]
["2010-08-24","Absolute Fencing Gear, Inc.","Attire","Pants","N/A","New",null,32,null,null,51.2,6.4,2,"21023-32 AF Unisex Cotton Pants (w/ Inside Lining): Size 32"]
["2010-08-24","Absolute Fencing Gear, Inc.","Attire","Jacket","N/A","New",null,32,"Male","Right",36,4.5,1,"21005-R32 AF Cotton Boy's F/Z Jacket: R/H Size 32"]
["2010-08-31","Big 5 Sporting Goods","Misc","Pull-up Bar","N/A","New",null,null,null,null,32.04,4.01,1,"Excercise pull-up bar"]
["2010-09-13","Blue Guantlet Fencing Gear, Inc.","Weaponry","Cord","N/A","New",null,null,null,null,83.2,10.4,8,"BG 2-Prong classic heavy duty BODY CORD"]
["2010-09-13","Blue Guantlet Fencing Gear, Inc.","Weaponry","Socket","Foil","New",null,null,null,null,38.4,4.8,8,"BG 2-Prong SOCKET (foil)"]
["2010-09-13","Blue Guantlet Fencing Gear, Inc.","Weaponry","Base","Epee","New",null,null,null,null,25.5,3.19,10,"French epee BASE"]
["2010-09-13","Blue Guantlet Fencing Gear, Inc.","Weaponry","Spring","Epee","New",null,null,null,null,5.61,0.7,20,"French epee Contact SPRING (10 pcs pack)"]
["2010-09-13","Blue Guantlet Fencing Gear, Inc.","Weaponry","Spring","Epee","New",null,null,null,null,5.61,0.7,20,"French epee Press. SPRING (10 pcs pack)"]
["2010-09-13","Blue Guantlet Fencing Gear, Inc.","Weaponry","Tip","Epee","New",null,null,null,null,20.399999999999999,2.5499999999999998,6,"French epee TIP"]
["2010-09-13","Blue Guantlet Fencing Gear, Inc.","Weaponry","Screw","Epee","New",null,null,null,null,5.6,0.7,20,"SG epee SCREW (10 pcs Pack for SG epee point)"]
["2010-09-13","Blue Guantlet Fencing Gear, Inc.","Weaponry","Base","Foil","New",null,null,null,null,21.25,2.66,10,"ST French foil BASE"]
["2010-09-13","Blue Guantlet Fencing Gear, Inc.","Weaponry","Spring","Foil","New",null,null,null,null,2.8050000000000002,0.35,10,"ST French foil SPRING (10 pcs pack)"]
["2010-09-13","Blue Guantlet Fencing Gear, Inc.","Weaponry","Tip","Foil","New",null,null,null,null,17.850000000000001,2.23,6,"ST French foil TIP"]
["2010-09-13","Blue Guantlet Fencing Gear, Inc.","Weaponry","Wire","Foil","New",null,null,null,null,19.125,2.39,9,"French Foil WIRE"]
["2010-09-15","Burlington Coat Factory","Misc","Mats","N/A","New",null,null,null,null,102.45,12.81,12,"Yoga Mats"]
["2010-09-24","Utah Swords Academy","Weaponry","Blade","Sabre","New",null,null,null,null,225,28.13,5,"Sabre blades"]
["2010-10-02","Utah Swords Academy","Weaponry","Sword","Sabre","New",null,"#5",null,null,315,55.13,7,"Sabres # 5"]
["2010-10-02","Utah Swords Academy","Attire","Mask","Sabre","New",null,"Small",null,null,114,19.95,2,"Saber Masks"]
["2010-10-02","Utah Swords Academy","Attire","Cuff","N/A","New",null,null,null,null,36,6.3,3,"Glove Cuff"]
["2010-10-05","Blue Guantlet Fencing Gear, Inc.","Attire","Jacket","N/A","New",null,36,"Male","Right",36.799999999999997,6.44,1,"BG 350N Standard Front Zipper JACKET Size: 36 R/H Male"]
["2010-10-05","Blue Guantlet Fencing Gear, Inc.","Attire","Lame","Sabre","New",null,38,null,null,152.15,26.63,1,"EDGE Stainless steel Sabre LAME"]
["2010-10-05","Ross","Misc","Mats","N/A","New",null,null,null,null,42.69,7.47,5,"Yoga Mats"]
["2010-10-11","Blue Guantlet Fencing Gear, Inc.","Weaponry","Socket","Epee","New",null,null,null,null,28.8,5.04,6,"BG Epee SOCKET"]
["2010-10-11","Blue Guantlet Fencing Gear, Inc.","Weaponry","Socket","Foil","New",null,null,null,null,24,4.2,5,"BG 2-Prong SOCKET (foil)"]
["2010-10-11","Blue Guantlet Fencing Gear, Inc.","Attire","Lame","Foil","New",null,"XXXL","Male","Right",62.4,10.92,1,"BG high density copper foil LAME Size: 64 R/H Male"]
["2010-10-11","Blue Guantlet Fencing Gear, Inc.","Attire","Lame","Foil","New",null,"XXL","Male","Right",124.8,21.84,2,"BG high density copper foil LAME Size: 56 R/H Male"]
["2010-10-11","Blue Guantlet Fencing Gear, Inc.","Weaponry","Screw","Foil","New",null,null,null,null,8.42,1.47,30,"ST French foil SCREW (10 pcs pack)"]
["2010-10-15","Utah Swords Academy","Weaponry","Cord","N/A","New",null,null,null,null,64,11.2,4,"Cords"]
["2010-10-15","Utah Swords Academy","Weaponry","Blade","Sabre","New",null,null,null,null,60,10.5,3,"Saber Blades"]
["2010-10-15","Utah Swords Academy","Attire","Glove","Sabre","New",null,null,null,null,80,14,8,"Fencing Glove"]
["2010-11-17","Utah Swords Academy","Weaponry","Sword","Foil","Used",null,null,null,null,45,7.88,1,"Electric foil (counted in inventory count, not sure on invoice)"]
["2010-11-17","Utah Swords Academy","Weaponry","Sword","Foil","Damaged",null,null,null,null,90,15.75,2,"Electric foils (counted in inventory count, not sure on invoice)"]
["2010-11-17","Donated","Misc","Video Game","N/A","Used",null,null,null,null,50,8.75,1,"Band Hero bundle - Used"]
["2010-11-17","Absolute Fencing Gear, Inc.","Weaponry","Socket","Epee","New",null,null,null,null,4.8,0.84,1,"Counted in inventory count (not sure on invoice)"]
["2010-11-17","Utah Swords Academy","Weaponry","Sword","Sabre","New",null,"#5",null,null,315,55.13,7,"Sabres #5 (counted in inventory, not sure on invoice)"]
["2010-11-17","Utah Swords Academy","Weaponry","Sword","Sabre","New",null,"#2",null,null,225,39.380000000000003,5,"Sabres #2 (counted in inventory, not sure on invoice)"]

{"sheet":"Menus","index":1,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Absolute Fencing Gear, Inc.","Epee","Barrel","Weaponry","New"]
["Blue Guantlet Fencing Gear, Inc.","Foil","Base","Weaponry","Used"]
["Utah Swords Academy","Sabre","Blade","Weaponry","Damaged"]
["Donated","N/A","Cord","Weaponry","Scrap"]
["Big 5 Sporting Goods",null,"Cuff","Weaponry","N/A"]
[null,null,"DVD","Misc"]
[null,null,"Glove","Attire"]
[null,null,"Jacket","Attire"]
[null,null,"Lame","Attire",null,null,null,"Have ability to move items from Inventory to NOG (sets header & detail automatically - 1 item per header)"]
[null,null,"Manual","Misc"]
[null,null,"Mask","Attire"]
[null,null,"Mats","Misc"]
[null,null,"Pants","Attire"]
[null,null,"Screw","Weaponry"]
[null,null,"Socket","Weaponry",null,null,"A:","Vendor"]
[null,null,"Spring","Weaponry",null,null,"B:","Type"]
[null,null,"Sword","Weaponry",null,null,"C:","Category"]
[null,null,"Tip","Weaponry",null,null,"D:","Area"]
[null,null,"Wire","Weaponry",null,null,"E: ","Condition"]
[null,null,"Video Game","Misc",null,null,"F:","Location"]
[null,null,"Pull-up Bar","Misc"]

{"sheet":"Issue","index":2,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Date","Category","Type","Size","Gender","Hand","Value","Issued To","Return Date"]
["2010-01-01","Jacket","Epee",42,"Male","Right",145,"Robin Hood ","2010-01-25"]
["2010-01-01","Glove","N/A","M",null,"Right",10,"Robin Hood","2010-01-25"]
["2010-11-26","Sword","Sabre",null,null,null,45,"M. Todd Norman Esquire","2010-12-10"]
["2010-11-26","Lame","N/A",36,"Male","Right",152.15,"M. Todd Norman Esquire","2010-12-10"]
["2010-12-04","Sword","Epee",null,null,null,0,"Bob Cratchet","2010-01-01"]
["2010-12-04","Lame","Epee",null,null,null,0,"Bob Cratchet","2011-01-01"]

{"sheet":"NOG","index":3,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Date","Category","Type","Size","Gender","Hand","Cost","Resale","Purchased For","Notes","Paid On"]
["2010-01-01","Jacket","Epee",42,"Male","Right",null,145,"Robin Hood",null,"2010-01-25"]
["2010-01-01","Glove","N/A","M",null,"RIght",null,10,"Elvis Presley",null,"2010-01-25"]
["2010-11-26","Sword","Sabre",null,null,null,null,45,"M. Todd Norman Esquire",null,"2010-12-10"]
["2010-11-26","Lame","N/A",36,"Male","Right",null,152.15,"M. Todd Norman Esquire",null,"2010-12-10"]
["2010-11-27","Jacket","Epee",12,"Female","Right",125.24,136.58000000000001,"Little Betty Lou Who","Embroidered LBLW","2010-12-04"]
["2010-11-27","Lame","Epee",12,"Female","Right",54.69,73.52,"Little Betty Lou Who",null,"2010-12-16"]
["2010-11-27","Glove","N/A",8,"Female","Right",10,15,"Little Betty Lou Who"]
["2010-11-27","Sword","Sabre",null,"Female","Right",75,89.88,"Little Betty Lou Who"]
["2008-01-25","Jacket","N/A",32,"Male","Right",123.45,234.56,"Frosty the Snowman","Embroidered \"Frosty\""]
["2008-01-25","Sword","Foil",null,null,null,45,58,"Frosty the Snowman","Works well in frozen conditions"]
["2008-01-25","Pants","N/A",32,"Male",null,37,42,"Frosty the Snowman","Breathes well"]
["2008-01-25","Jacket","N/A",32,"Male","Right",123.45,234.56,"Elvis Presley","Embroidered \"Presley\""]
["2008-01-25","Pants","N/A",32,"Male","Right",35,25,"Elvis Presley","Discount for the King"]
["2008-01-25","Sword","Epee",null,null,"Right",65,98,"Elvis Presley","Elvis has left the building"]
["2010-12-27","Jacket","N/A",32,"Female","Left",123,234,"Mrs. Claus","sadfgjhsghsdlgjsdlgsdjglsdkgj"]
["2010-12-27","Pants","N/A",32,"Female",null,123,456,"Mrs. Claus"]
["2010-12-27","Sword","Epee",null,null,null,123,456,"Mrs. Claus","dslkfgsdlfjgshdlgdkj;"]
["2010-12-08","Sword","Sabre",null,null,null,45,52.95,"Gove Allen"]
["2010-12-08","Lame","Sabre","L","Male","Right","1900-06-01T18:00:00",162.5,"Gove Allen"]
["2010-12-08","Glove","N/A",10,"Male","Right",10,12.95,"Gove Allen"]

{"sheet":"InvReport","index":4,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,2,3,4],[7,2,7,4]]}
[]
[null,"Inventory Report"]
[null,"Search Criteria:"]
[null,"Vendor:","Utah Swords Academy"]
[null,"Date:"]
[null,"Type:",null,"Sabre"]
[null,"Condition:"]
[null,"Description:"]
[]
["Category","Type","Size","Gender","Hand","Quantity","Avrg. Value","Total Value"]
["Blade","Sabre",null,null,null,5,39.374000000000002,196.87]
["Sword","Sabre","#5",null,null,7,37.124285714285712,259.87]
["Mask","Sabre","Small",null,null,2,47.024999999999999,94.05]
["Lame","Sabre",38,null,null,1,125.52,125.52]
["Blade","Sabre",null,null,null,3,16.5,49.5]
["Glove","Sabre",null,null,null,8,8.25,66]
["Sword","Sabre","#5",null,null,7,37.124285714285712,259.87]
["Sword","Sabre","#2",null,null,5,37.124000000000002,185.62]

{"sheet":"Issue Invoice","index":5,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[8,3,8,7],[3,7,3,8],[4,7,4,8],[8,1,8,2]]}
[]
[null,null,null,"Utah Valley Fencing Academy, Inc."]
[null,null,null,"728 South State Street"]
[null,null,null,"Orem, UT 84058",null,null,null,"Invoice"]
[null,null,null,"(801) 380-3461",null,null,null,"Student Issued Inventory"]
[null,null,null,"http://www.fencingutah.org"]
[null,null,null,null,null,null,null,"Invoice Date:","2010-01-01"]
[null,null,null,null,null,null,null,"Return Date:","2010-01-25"]
[null,"Student:",null,"Robin Hood "]
[]
[null,null,"Line #","Category","Type","Size","Gender","Hand","Value"]
[null,null,1,"Jacket","Epee",42,"Male","Right",145]
[null,null,2,"Glove","N/A","M",null,"Right",10]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[null,null,21]
[null,null,22]
[null,null,23]
[null,null,24]
[null,null,25]
[null,null,26]
[null,null,27]
[null,null,28]
[null,null,29]
[null,null,30]
[null,null,31]
[null,null,32]
[null,null,33]
[null,null,34]
[null,null,null,null,null,null,null,{"$f":"COUNT(I12:I45)","v":2},{"$f":"SUM(I12:I45)","v":155}]
[]
[null,"As the above named student (or legal guardian of the above named student if student is under the age of 18) , I take "]
[null,"full responsibility for all equipment listed in this invoice until such time that it is returned to Utah Valley Fencing Academy, Inc."]
[null,"(hereafter know as \"The Academy\") I agree to return each item in their original condition to The Academy on or before the "]
[null,"return date above unless an agreement is made in writing with the director or coach of The Academy to return the items"]
[null,"at a later date. I further agree that all items will be returned in their current condition. Any damage to the items on issuance "]
[null,"will be noted on this invoice. I agree to pay The Academy for any items lost or damaged while in my care."]
[]
[]
[null,"Student/Guardian:"]
[]
[]
[]
[null,"Utah Valley Fencing Academy, Inc.:"]

{"sheet":"NOG Invoice","index":6,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[13,4,13,7],[14,4,14,7],[15,4,15,7],[3,7,3,8],[4,7,4,8],[8,1,8,2],[8,3,8,7],[11,4,11,7],[27,4,27,7],[16,4,16,7],[17,4,17,7],[18,4,18,7],[19,4,19,7],[20,4,20,7],[21,4,21,7],[22,4,22,7],[23,4,23,7],[24,4,24,7],[25,4,25,7],[26,4,26,7],[12,4,12,7],[39,4,39,7],[28,4,28,7],[29,4,29,7],[30,4,30,7],[31,4,31,7],[32,4,32,7],[33,4,33,7],[34,4,34,7],[35,4,35,7],[36,4,36,7],[37,4,37,7],[38,4,38,7],[40,4,40,7],[41,4,41,7],[42,4,42,7],[43,4,43,7],[44,4,44,7]]}
[]
[null,null,null,"Utah Valley Fencing Academy, Inc."]
[null,null,null,"728 South State Street"]
[null,null,null,"Orem, UT 84058",null,null,null,"Invoice"]
[null,null,null,"(801) 380-3461",null,null,null,"Student Purchase"]
[null,null,null,"http://www.fencingutah.org"]
[null,null,null,null,null,null,null,"Invoice Date:","2010-12-08"]
[]
[null,"Student:",null,"Gove Allen"]
[]
[null,null,"Line #","Item","Description",null,null,null,"Price"]
[null,null,1,"Sword",null,null,null,null,52.95]
[null,null,2,"Lame",null,null,null,null,162.5]
[null,null,3,"Glove",null,null,null,null,12.95]
[null,null,4,"Jacket","Embroidered \"Gove\"",null,null,null,75.5]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[null,null,21]
[null,null,22]
[null,null,23]
[null,null,24]
[null,null,25]
[null,null,26]
[null,null,27]
[null,null,28]
[null,null,29]
[null,null,30]
[null,null,31]
[null,null,32]
[null,null,33]
[null,null,34]
[null,null,null,null,null,null,null,{"$f":"COUNT(I12:I45)","v":4},{"$f":"SUM(I12:I45)","v":303.89999999999998}]
[]
[null,"All Purchases must be paid in full upon arrival. Any exception must be stated in writing and signed by both the "]
[null,"Student/Guardian, and Utah Valley Fencing Academy, Inc."]
[]
[]
[null,"Utah Valley Fencing Academy, Inc.:"]

{"sheet":"InvCount","index":7,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"Total Inventory Count",null,null,null,null,"2010-12-04T22:18:39"]
[null,"Utah Valley Fencing Academy, Inc."]
[null,"Total Count","Total Value"]
[null,{"$f":"SUM(D:D)","v":262},{"$f":"SUM(F:F)","v":2291.75}]
["Category","Type","Condition","Count","Average Cost","Total Cost"]
["Barrel","Epee","New",6,2.2316666666666665,13.39]
["Base","Epee","New",10,2.2309999999999999,22.31]
["Screw","Epee","New",20,0.245,4.9000000000000004]
["Socket","Epee","New",7,3.96,27.72]
["Spring","Epee","New",40,0.2455,9.82]
["Tip","Epee","New",6,2.9750000000000001,17.850000000000001]
["Wire","Epee","New",1,2.79,2.79]
["Barrel","Foil","New",9,2.2311111111111113,20.079999999999998]
["Base","Foil","New",10,1.859,18.59]
["Lame","Foil","New",3,51.48,154.44]
["Mask","Foil","New",1,31.5,31.5]
["Screw","Foil","New",30,0.23166666666666666,6.95]
["Socket","Foil","New",13,4.1076923076923073,53.4]
["Spring","Foil","New",10,0.246,2.46]
["Tip","Foil","New",6,2.6033333333333335,15.62]
["Wire","Foil","New",9,1.86,16.739999999999998]
["Blade","Sabre","New",8,30.796250000000001,246.37]
["Glove","Sabre","New",8,8.25,66]
["Lame","Sabre","New",1,125.52,125.52]
["Mask","Sabre","New",2,47.024999999999999,94.05]
["Sword","Sabre","New",19,37.124210526315792,705.36]
["Cord","N/A","New",12,10.466666666666667,125.6]
["Cuff","N/A","New",3,9.9,29.7]
["DVD","N/A","New",1,30.62,30.62]
["Jacket","N/A","New",3,33.22,99.66]
["Mats","N/A","New",17,7.3447058823529412,124.86]
["Pants","N/A","New",2,22.4,44.8]
["Pull-up Bar","N/A","New",1,28.03,28.03]
["Sword","Foil","Used",1,37.119999999999997,37.119999999999997]
["Video Game","N/A","Used",1,41.25,41.25]
["Sword","Foil","Damaged",2,37.125,74.25]