{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["AMAZON.COM ONLY","Data Lists","THIS IS AN EXAMPLE"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":7,"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":"AMAZON.COM ONLY","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[43,2,43,4],[42,2,42,4],[0,1,0,6],[1,1,1,6],[5,4,5,6],[6,2,6,6],[7,4,7,5],[8,2,8,6],[9,2,9,6]]}
[null,"Jamestown Community College - Jamestown, Olean, Dunkirk"]
[null,"Purchase Requistion for AMAZON.COM"]
[]
[null,"Purchase Order Type","Blanket",null,"JCC Blanket PO for Amazon"]
[null,"Today's Date",null,"Fiscal Year","2019-2020","Delivery Options"]
[null,"Vendor ID","J00300233","Vendor Name","AMAZON.COM CREDIT PLAN"]
[null,"Requestor Name"]
[null,"Ship To Campus",null,null,"Campus Mail Delivery Location"]
[null,"Attention To:"]
[null,"Document Notes"]
[]
["Line","Link from Amazon","Description","Unit of Measure","Quantity","Unit Price","Extension"]
[1,null,null,null,null,null,{"$f":"E13*F13","v":0}]
[2,null,null,null,null,null,0]
[3,null,null,null,null,null,0]
[4,null,null,null,null,null,0]
[5,null,null,null,null,null,0]
[6,null,null,null,null,null,0]
[7,null,null,null,null,null,0]
[8,null,null,null,null,null,0]
[9,null,null,null,null,null,0]
[10,null,null,null,null,null,0]
[11,null,null,null,null,null,0]
[12,null,null,null,null,null,0]
[13,null,null,null,null,null,0]
[14,null,null,null,null,null,0]
[15,null,null,null,null,null,0]
[16,null,null,null,null,null,0]
[17,null,null,null,null,null,0]
[18,null,null,null,null,null,0]
[19,null,null,null,null,null,0]
[20,null,null,null,null,null,0]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G13:G32)","v":0}]
[null,"Budget Distribution"]
[null,"Fund","Org","Account","Program","Amount"]
[null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,"TOTAL",{"$f":"SUM(F36:F40)","v":0}]
[]
[null,"Submitted by:"]
[null,"Approved by:"]
[]
[null,"When complete, email this worksheet to purchasing@mail.sunyjcc.edu. Do not send a pdf. It must be the Excel file attached to your email."]
[null,"Purchasing will cut & paste from Column B into Amazon order. You will receive an email confirmation when order placed."]

{"sheet":"Data Lists","index":1,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["PO Type","FY","Delivery Options","Vendor","Campus","Ship To Bldg","Unit of Measure","Event","Fund","Org","Account","Org Responsibility"]
[null,"2019-2020","Free No Rush",null,"Jamestown","COCE","Each","Commodity",1000]
["Blanket","2020-2021","Free Prime Delivery",null,"Olean","MTI","Box","Service"]
["Standing Prices","2021-2022","Expedite - Emergency",null,"Dunkirk","RTPI","Carton"]
["Regular",null,null,null,"Warren","CATT","Case"]
["Confirming",null,null,null,null,"NCEC","Person"]
[null,null,null,null,null,null,"Pound"]
[null,null,null,null,null,null,"Thousand"]
[null,null,null,null,null,null,"Ton"]
[null,null,null,null,null,null,"Gallon"]
[null,null,null,null,null,null,"Gram"]
[null,null,null,null,null,null,"Yard"]
[null,null,null,null,null,null,"Day"]
[null,null,null,null,null,null,"Week"]
[null,null,null,null,null,null,"Month"]

{"sheet":"THIS IS AN EXAMPLE","index":2,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[[9,2,9,6],[10,2,10,6],[44,2,44,4],[45,2,45,4],[16,1,16,6],[0,1,0,6],[1,1,1,6],[5,4,5,6],[6,2,6,6],[7,4,7,5],[8,2,8,6]]}
[null,"Jamestown Community College - Jamestown, Olean, Dunkirk"]
[null,"Purchase Requistion for AMAZON.COM"]
[]
[null,"Purchase Order Type","Blanket",null,"JCC Blanket PO for Amazon"]
[null,"Today's Date","2020-03-25","Fiscal Year","2019-2020","Delivery Options","Free No Rush"]
[null,"Vendor ID","J00300233","Vendor Name","AMAZON.COM CREDIT PLAN"]
[null,"Requestor Name","Dave Johnson"]
[null,"Ship To Campus",null,null,"Campus Mail Delivery Location"]
[null,"Home Ship To During COVID19","123 Main Street, Anytown, NY 12345"]
[null,"Attention To:","John Doe"]
[null,"Document Notes","I need these right away. Thanks."]
[]
["Line","Link from Amazon","Description","Unit of Measure","Quantity","Unit Price","Extension"]
["EXAMPLE","https://www.amazon.com/Parking-SmartSign-Intensity-Reflective-Aluminum/dp/B0089OU1IK/ref=sr_1_12?keywords=sign+no+parking&qid=1585193353&sr=8-12","Sign","Each",2,14.95,{"$f":"E14*F14","v":29.9}]
[1,null,null,null,null,null,{"$f":"E15*F15","v":0}]
[2,null,null,null,null,null,0]
[3,"THIS IS AN EXAMPLE ONLY - PLEASE USE FIRST TAB FOR YOUR REQUISITION"]
[4,null,null,null,null,null,0]
[5,null,null,null,null,null,0]
[6,null,null,null,null,null,0]
[7,null,null,null,null,null,0]
[8,null,null,null,null,null,0]
[9,null,null,null,null,null,0]
[10,null,null,null,null,null,0]
[11,null,null,null,null,null,0]
[12,null,null,null,null,null,0]
[13,null,null,null,null,null,0]
[14,null,null,null,null,null,0]
[15,null,null,null,null,null,0]
[16,null,null,null,null,null,0]
[17,null,null,null,null,null,0]
[18,null,null,null,null,null,0]
[19,null,null,null,null,null,0]
[20,null,null,null,null,null,0]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G14:G34)","v":29.9}]
[null,"Budget Distribution"]
[null,"Fund","Org","Account","Program","Amount"]
[null,1000,1602,7344,60,19.899999999999999]
[]
[]
[]
[]
[null,null,null,null,"TOTAL",{"$f":"SUM(F38:F42)","v":19.899999999999999}]
[]
[null,"Submitted by:","Dave Johnson"]
[null,"Approved by:","Mike Martello"]
[]
[null,"When complete, email this worksheet to purchasing@mail.sunyjcc.edu. Do not send a pdf. It must be the Excel file attached to your email."]
[null,"Purchasing will cut & paste from Column B into Amazon order. You will receive an email confirmation when order placed."]