{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["PO Services (30)","PO Goods (45)","PO Services - External PMs (30)","PO Goods - External PM(45)"],"not_rendered":{"images":1,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"PO Services (30)","index":0,"n_rows":43,"n_cols":9,"rows_kept":43,"merged":[[1,7,1,9],[2,2,2,4],[2,7,2,9],[3,2,3,4],[3,7,3,9],[4,2,4,4],[4,7,4,9],[8,2,8,4],[8,7,8,9],[9,2,9,4],[9,7,9,9],[10,2,10,4],[10,7,10,9],[11,2,11,4],[11,7,11,9],[15,0,17,0],[15,1,17,6],[15,7,17,7],[15,8,17,9],[18,0,20,0],[18,1,20,6],[18,7,20,7],[18,8,20,9],[21,0,23,0],[21,1,23,6],[21,7,23,7],[21,8,23,9],[24,0,26,0],[24,1,26,6],[24,7,26,7],[24,8,26,9],[27,0,29,0],[27,1,29,6],[27,7,29,7],[27,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[36,0,36,1],[36,3,36,4],[36,8,36,9],[37,0,37,6],[41,8,41,9],[44,8,44,9]]}
["PURCHASE ORDER REQUEST FORM"]
["To:",null,"Capital Accounting",null,null,"Purchase Order Number:",null,30]
["Date:",{"$nulls":4},"Project Manager:"]
["Project Name:",{"$nulls":4},"PM Telephone:"]
["Project Number:",{"$nulls":4},"PM Email:"]
["HST Number:",null,"R108162330",null,null,"Importer Number:",null,500011]
[]
["VENDOR"]
["Suggested Vendor:",{"$nulls":4},"Vendor Number:"]
["Attention:",{"$nulls":4},"Vendor Address:"]
["Telephone Number:"]
["Email:"]
[]
["ORDER"]
["Item","Full Name and Description",{"$nulls":5},"GL","Estimated Cost"]
{"$rows_empty":15}
["Send Commercial Invoice To: ",{"$nulls":6},"Subtotal",{"$f":"SUM(I16:I30)","v":{"v":0,"d":"$0.00"}}]
["University of Toronto, Project Management, UPDC",{"$nulls":6},"HST (13%)",{"$f":"PRODUCT(I31,0.13)","v":{"v":0,"d":"$0.00"}}]
["255 McCaul St, 4th Floor, Toronto, ON, M5T 1W7",{"$nulls":6},"Total",{"$f":"SUM(I31:I32)","v":{"v":0,"d":"$0.00"}}]
[]
["RECOMMENDED BY "]
[]
["x"]
["Name, Title",{"$nulls":7},"Date"]
[]
["APPROVALS"]
[]
["x"]
["Adrienne De Francesco, Director, Project Management - UPDC",{"$nulls":7},"Date"]

{"sheet":"PO Goods (45)","index":1,"n_rows":46,"n_cols":9,"rows_kept":46,"merged":[[1,7,1,9],[2,2,2,4],[2,7,2,9],[3,2,3,4],[3,7,3,9],[4,2,4,4],[4,7,4,9],[5,2,5,4],[5,7,5,9],[6,2,6,4],[7,2,7,4],[10,2,10,4],[10,7,10,9],[11,2,11,4],[11,7,11,9],[12,2,12,4],[12,7,12,9],[13,2,13,4],[13,7,13,9],[17,3,17,6],[17,8,17,9],[18,3,18,6],[18,8,18,9],[19,3,19,6],[19,8,19,9],[20,3,20,6],[20,8,20,9],[21,3,21,6],[21,8,21,9],[22,3,22,6],[22,8,22,9],[23,3,23,6],[23,8,23,9],[24,3,24,6],[24,8,24,9],[25,3,25,6],[25,8,25,9],[26,3,26,6],[26,8,26,9],[27,3,27,6],[27,8,27,9],[28,3,28,6],[28,8,28,9],[29,3,29,6],[29,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[36,0,36,1],[36,3,36,4],[36,8,36,9],[37,0,37,6],[39,0,39,1],[39,3,39,4],[39,8,39,9],[40,0,40,6]]}
["PURCHASE ORDER REQUEST FORM"]
["To:",null,"Capital Accounting",null,null,"Purchase Order Number:",null,45]
["Date:",{"$nulls":4},"Project Manager:"]
["Project Name:",{"$nulls":4},"PM Telephone:"]
["Project Number:",{"$nulls":4},"PM Email:"]
["Delivery Address:",{"$nulls":4},"Project Administrator"]
[{"$nulls":5},"Importer Number:",null,500011]
[{"$nulls":5},"HST Number:",null,"R108162330"]
[]
["VENDOR"]
["Suggested Vendor:",{"$nulls":4},"Vendor Number:"]
["Attention:",{"$nulls":4},"Vendor Address:"]
["Telephone Number:"]
["Email:"]
[]
["ORDER"]
["Item","Quantity","Unit Price","Description & Product Number",{"$nulls":3},"GL","Cost"]
[{"$nulls":8},{"$f":"PRODUCT(B18,C18)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"$f":"PRODUCT(B19,C19)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
["Send Commercial Invoice To: ",{"$nulls":6},"Subtotal",{"$f":"SUM(I18:I30)","v":{"v":0,"d":"$0.00"}}]
["University of Toronto, Project Management, UPDC",{"$nulls":6},"HST (13%)",{"$f":"PRODUCT(I31,0.13)","v":{"v":0,"d":"$0.00"}}]
["255 McCaul St, 4th Floor, Toronto, ON, M5T 1W7",{"$nulls":6},"Total",{"$f":"SUM(I31:I32)","v":{"v":0,"d":"$0.00"}}]
[]
["RECOMMENDED BY"]
[]
["x"]
["Name, Title",{"$nulls":7},"Date"]
[]
["x"]
["Name, Title",{"$nulls":7},"Date"]
[]
["APPROVALS"]
[]
["x"]
["Adrienne De Francesco, Director, Project Management - UPDC",{"$nulls":7},"Date"]

{"sheet":"PO Services - External PMs (30)","index":2,"n_rows":46,"n_cols":11,"rows_kept":46,"merged":[[1,7,1,9],[2,2,2,4],[2,7,2,9],[3,2,3,4],[3,7,3,9],[4,2,4,4],[4,7,4,9],[8,2,8,4],[8,7,8,9],[9,2,9,4],[9,7,9,9],[10,2,10,4],[10,7,10,9],[11,2,11,4],[11,7,11,9],[15,0,17,0],[15,1,17,6],[15,7,17,7],[15,8,17,9],[18,0,20,0],[18,1,20,6],[18,7,20,7],[18,8,20,9],[21,0,23,0],[21,1,23,6],[21,7,23,7],[21,8,23,9],[24,0,26,0],[24,1,26,6],[24,7,26,7],[24,8,26,9],[27,0,29,0],[27,1,29,6],[27,7,29,7],[27,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[36,0,36,1],[36,3,36,4],[36,8,36,9],[37,0,37,6],[41,8,41,9],[44,8,44,9]]}
["PURCHASE ORDER REQUEST FORM"]
["To:",null,"Capital Accounting",null,null,"Purchase Order Number:",null,30]
["Date:",{"$nulls":4},"Project Manager:"]
["Project Name:",{"$nulls":4},"PM Telephone:"]
["Project Number:",{"$nulls":4},"PM Email:"]
["HST Number:",null,"R108162330",null,null,"Importer Number:",null,500011]
[]
["VENDOR"]
["Suggested Vendor:",{"$nulls":4},"Vendor Number:"]
["Attention:",{"$nulls":4},"Vendor Address:"]
["Telephone Number:"]
["Email:"]
[]
["ORDER"]
["Item","Full Name and Description",{"$nulls":5},"GL","Estimated Cost"]
{"$rows_empty":15}
["Send Commercial Invoice To: ",{"$nulls":6},"Subtotal",{"$f":"SUM(I16:I30)","v":{"v":0,"d":"$0.00"}}]
["University of Toronto, Project Management, UPDC",{"$nulls":6},"HST (13%)",{"$f":"PRODUCT(I31,0.13)","v":{"v":0,"d":"$0.00"}}]
["255 McCaul St, 4th Floor, Toronto, ON, M5T 1W7",{"$nulls":6},"Total",{"$f":"SUM(I31:I32)","v":{"v":0,"d":"$0.00"}}]
[]
["RECOMMENDED BY "]
[]
["x"]
["Name, Title",{"$nulls":7},"Date"]
[]
["APPROVALS"]
[]
["x",{"$nulls":9},"Where an external Project Manager is assigned, "]
["Adrienne De Francesco, Director, Project Management - UPDC",{"$nulls":7},"Date",null,"the PO may be created by the PM but approvals must include:"]
[{"$nulls":10},"(1) Associate Director, Project Management (Manual)"]
["x",{"$nulls":9},"(2) Director, Project Management (Electronic)"]
["Brian Szuberwood, Associate Director, Project Management - UPDC",{"$nulls":7},"Date"]

{"sheet":"PO Goods - External PM(45)","index":3,"n_rows":46,"n_cols":11,"rows_kept":46,"merged":[[1,7,1,9],[2,2,2,4],[2,7,2,9],[3,2,3,4],[3,7,3,9],[4,2,4,4],[4,7,4,9],[5,2,5,4],[5,7,5,9],[6,2,6,4],[7,2,7,4],[10,2,10,4],[10,7,10,9],[11,2,11,4],[11,7,11,9],[12,2,12,4],[12,7,12,9],[13,2,13,4],[13,7,13,9],[17,3,17,6],[17,8,17,9],[18,3,18,6],[18,8,18,9],[19,3,19,6],[19,8,19,9],[20,3,20,6],[20,8,20,9],[21,3,21,6],[21,8,21,9],[22,3,22,6],[22,8,22,9],[23,3,23,6],[23,8,23,9],[24,3,24,6],[24,8,24,9],[25,3,25,6],[25,8,25,9],[26,3,26,6],[26,8,26,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[33,0,33,1],[33,3,33,4],[33,8,33,9],[34,0,34,6],[36,0,36,1],[36,3,36,4],[36,8,36,9],[37,0,37,6]]}
["PURCHASE ORDER REQUEST FORM"]
["To:",null,"Capital Accounting",null,null,"Purchase Order Number:",null,45]
["Date:",{"$nulls":4},"Project Manager:"]
["Project Name:",{"$nulls":4},"PM Telephone:"]
["Project Number:",{"$nulls":4},"PM Email:"]
["Delivery Address:",{"$nulls":4},"Project Administrator"]
[{"$nulls":5},"Importer Number:",null,500011]
[{"$nulls":5},"HST Number:",null,"R108162330"]
[]
["VENDOR"]
["Suggested Vendor:",{"$nulls":4},"Vendor Number:"]
["Attention:",{"$nulls":4},"Vendor Address:"]
["Telephone Number:"]
["Email:"]
[]
["ORDER"]
["Item","Quantity","Unit Price","Description & Product Number",{"$nulls":3},"GL","Cost"]
[{"$nulls":8},{"$f":"PRODUCT(B18,C18)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"$f":"PRODUCT(B19,C19)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"}]
["Send Commercial Invoice To: ",{"$nulls":6},"Subtotal",{"$f":"SUM(I18:I27)","v":{"v":0,"d":"$0.00"}}]
["University of Toronto, Project Management, UPDC",{"$nulls":6},"HST (13%)",{"$f":"PRODUCT(I28,0.13)","v":{"v":0,"d":"$0.00"}}]
["255 McCaul St, 4th Floor, Toronto, ON, M5T 1W7",{"$nulls":6},"Total",{"$f":"SUM(I28:I29)","v":{"v":0,"d":"$0.00"}}]
[]
["RECOMMENDED BY"]
[]
["x"]
["Name, Title",{"$nulls":7},"Date"]
[]
["x"]
["Name, Title",{"$nulls":7},"Date"]
[]
["APPROVALS",{"$nulls":9},"Where an external Project Manager is assigned, "]
[{"$nulls":10},"the PO may be created by the PM but approvals must include:"]
["x",{"$nulls":9},"(1) Associate Director, Project Management (Manual)"]
["Adrienne De Francesco, Director, Project Management - UPDC",{"$nulls":7},"Date",null,"(2) Director, Project Management (Electronic)"]
[]
["x"]
["Brian Szuberwood, Associate Director, Project Management - UPDC",{"$nulls":7},"Date"]