{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["FORM","Additional Descrptn & Comments","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"FORM","index":0,"n_rows":48,"n_cols":54,"rows_kept":48,"cut":false,"hidden":false,"merged":[[3,5,3,20],[4,5,4,18],[38,32,38,40],[1,46,1,52],[2,46,2,52],[1,37,1,45],[8,42,8,43],[6,46,6,48],[7,46,7,48],[6,42,6,43],[7,50,7,53],[8,46,8,48],[1,24,1,25],[27,6,27,9],[27,10,27,17],[9,8,9,18],[6,8,6,18],[16,44,16,53],[1,26,1,30],[0,37,0,45],[0,31,0,32],[1,33,1,36],[0,33,0,36],[1,31,1,32],[0,46,0,52],[14,11,14,41],[15,11,15,41],[5,50,5,53],[7,8,7,30],[16,11,16,41],[8,8,8,18],[12,23,12,44],[13,11,13,41],[9,42,9,43],[8,24,8,30],[9,24,9,30],[31,36,31,52],[23,35,23,38],[27,18,27,37],[23,39,23,44],[31,23,31,27],[24,32,24,34],[24,39,24,44],[31,32,31,34],[28,18,28,37],[23,16,23,19],[23,20,23,22],[23,23,23,27],[24,45,24,52],[23,32,23,34],[23,28,23,31],[28,10,28,17],[26,6,26,9],[26,10,26,17],[24,23,24,27],[26,18,26,37],[24,28,24,31],[24,20,24,22],[23,45,23,52],[21,45,21,52],[22,45,22,52],[21,31,22,36],[20,45,20,53],[32,2,32,15],[35,1,35,15],[33,1,33,15],[33,16,33,19],[33,20,33,22],[33,23,33,27],[35,23,35,27],[28,1,28,5],[35,32,35,34],[34,1,34,15],[34,32,34,34],[34,28,34,31],[34,20,34,22],[22,0,22,9],[21,10,22,25],[24,1,24,15],[24,16,24,19],[35,16,35,19],[34,23,34,27],[34,35,34,38],[32,23,32,27],[32,35,32,38],[23,1,23,15],[0,24,0,25],[28,45,28,52],[26,38,26,44],[26,45,26,52],[27,38,27,44],[27,45,27,52],[28,38,28,44],[5,46,5,49],[24,35,24,38],[18,24,18,30],[17,44,17,53],[19,44,19,46],[19,48,19,51],[2,26,2,30],[2,31,2,32],[6,50,6,53],[9,46,9,48],[8,50,8,53],[9,50,9,53],[13,46,13,48],[13,50,13,53],[15,44,15,53],[17,11,17,41],[18,11,18,20],[45,45,45,52],[32,45,32,52],[42,44,42,53],[41,37,41,43],[42,36,42,43],[35,45,35,52],[33,45,33,52],[35,39,35,44],[35,35,35,38],[44,45,44,52],[43,45,43,52],[34,45,34,52],[44,38,44,44],[43,38,43,44],[43,18,43,37],[34,39,34,44],[33,39,33,44],[44,18,44,37],[18,31,18,41],[7,42,7,43],[10,8,10,29],[45,1,45,5],[45,6,45,9],[45,10,45,17],[45,18,45,37],[32,32,32,34],[33,35,33,38],[33,32,33,34],[33,28,33,31],[45,38,45,44],[35,28,35,31],[34,16,34,19],[35,20,35,22],[43,1,43,5],[43,10,43,17],[44,10,44,17],[44,1,44,5],[43,6,43,9],[44,6,44,9],[27,1,27,5],[26,1,26,5],[28,6,28,9]]}
[null,"Northern Illinois University",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check:",null,null,null,null,"NIU",null,null,null,null,null,"New",null,null,null,null,null,null,null,null,"Dept Ref No:"]
[null,"Purchase Requisition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FDN",null,null,null,"Change ",null,null,null,null,null,null,null,null,null,null,"PO No:"]
[null,null,null,null,null,null,null,null,null,"Rev 3-28-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Renewal"]
[null,null,null,null,null,"EIT Accessible Technology Link",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"IT Security Assessment Link",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Procurement use:",null,null,null,null,null,null,null,null,null,null,"Initials",null,null,null,"Date"]
[null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Req/PO Entered"]
[null,"Department",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Req/PO To Buyer"]
[null,"Entered by",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Req Selected"]
[null,"Requested by",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PO Approved"]
[null,"Email",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Procurement Card Purchase?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accounting use:"]
["Vendor Information:"]
[null,"Vendor Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"initials",null,null,null,"   date"]
[null,"Address 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Budget Office use:"]
[null,"Address 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRF  /  IF  /  NAF"]
[null,"City, State, Zip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FSL   Y  /  N"]
[null,"Email",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FA     Y  /  N"]
[null,"Phone number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fax number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"initials",null,null,null,"   date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTALS"]
["Delivery Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivery",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fund Distribution",{"$f":"SUM(AT34:BA37)","v":0}]
["Dept, Bldg & Room No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Requisition",{"$f":"SUM(AS44:BA47)","v":0}]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q24>0,\"NA\",\"\")","v":""}]
[null,"     "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(B27*K27,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(B28*K28,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(B29*K29,2)","v":0}]
[]
[]
["Funding Distribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AT22=AT23,\"\",\"TOTALS MUST AGREE\")","v":""}]
["Line",null,"Authorized signature",null,null,null,null,null,null,null,null,null,null,null,null,null,"Account",null,null,null,"Fund",null,null,"Center",null,null,null,null,"Program",null,null,null,"Class",null,null,"FY",null,null,null,"Project /Grant",null,null,null,null,null,"Amount"]
["a"]
["b"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q35>0,\"NA\",\"\")","v":""}]
["c","     ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q36>0,\"NA\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AcctEnd"]
["Product Accessibility: ",null,null,null,null,null,null,null,null,"required __no __yes--submitted____ received____"]
["Security Assessment: required __no __yes--submitted____ received____",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPHEC Website",null,null,null,null,null,null,null,null,"IPHEC Vendor:  __no __yes "]
[]
[]
["Requisition Lines",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item Fund"]
["Line",null,null,null,null,"Quantity",null,"Unit",null,null,null,"Unit Price",null,null,null,null,null,null,null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Distribution",null,null,null,null,null,null,null,"Extended Line Amount"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Requisition_Lines * K44,2)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(B45*K45,2)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(B46*K46,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LineEnd"]
["Business Form 359 (03/28/18)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AT22=AT23,\"\",\"FUNDING AND REQ TOTAL MUST AGREE\")","v":""}]

{"sheet":"Additional Descrptn & Comments","index":1,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
[{"$f":"FORM!I7","v":"00:00:00"},{"$f":"CONCATENATE(\"Department Name:\",FORM!I8)","v":"Department Name:"}]
[null,{"$f":"CONCATENATE(\"Entered by:\",FORM!I9)","v":"Entered by:"}]
[null,{"$f":"CONCATENATE(\"Requested by:  \",FORM!I10)","v":"Requested by:  "}]
[null,{"$f":"CONCATENATE(\"Vendor Name:\",FORM!L14)","v":"Vendor Name:"}]
["Comment #","Additional Description"]
[1]
[2]
[3]

{"sheet":"Instructions","index":2,"n_rows":34,"n_cols":28,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Northern Illinois University",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single"]
[null,"Purchase Requisition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiple"]
[]
["              General Instructions:"]
[]
[1,"Select the FORM worksheet tab at the bottom of the screen."]
[]
[2,"Use the Tab key to move from entry field to entry field.  If you press the enter key, the cursor will move to the field directly below, which may or may not be a cell where data is to be entered."]
[]
[3,"Fields that have a red triangle in the upper right corner have a comment attached to it.  To see the  comment (explanation of that field), move your cursor on to the red triangle."]
[]
[4,"Fields outlined in red are required -- please include complete information for these fields.\nFields outlined in teal are automatically calculated."]
[]
[5,"Up to 3 accounting lines can be included on the form as opened.  If more funding entries are needed, press the button labeled \"Add Fund Lines\".  This button will provide lines for an additional funding line each time it is pushed."]
[]
[6,"Up to 3 different items can be ordered on the form as opened.  If more order lines are needed, press the button labeled \"Add Requisition Line\".  One line will be added each time it is pushed."]
[]
[7,"If the description of the items exceeds the  size of the description box, enter the description on the worksheet titled Additional Descrptn & Comments (click on worksheet tab at the bottom of the screen) and note in the Requisition description field the corresponding comment number used on the Additional Descrptn/Comments worksheet."]
[]
[8,"Below the vendor field, the requisition and funding total calculations are automatically calculated.  After entering all the data, verify that these two totals agree.  If they do not, make necessary adjustment(s) as these totals must agree.  "]
[]
["9a.","The fund lines total and requisition lines total must agree.  If they do not, an error message appears in the lower right hand corner below the last requisition line.  Accounting will send requisitions back to departments when these totals do not agree."]
[]
["9b.","SPLIT FUNDING:  Multiple distributions for multiple items where more than one distribution pays for part of several items.   Use the letter and the number to the left of the Fund Distribution and Requisition Line respectively and note the dollar amount to be used for that combination.   This will be noted in the field titled Item Fund Distributions or, on the worksheet entitled Additional Descrptn & Comments (click on worksheet tab at the bottom of the screen).  An example follows for a requisition with two distributions and three items.  "]
[]
[null,"A - Distribution 1:     75.00                                                                                                  B - Distribution 2:     75.00                                                                                                       1 - Item 1:     50.00                                                                                                              2 - Item 2:     50.00                                                                                                             3 - Item 3:     50.00                                                                                                                        A - 1-50.00  all of item 1 is being paid from distribution A                                              B - 2-50.00  all of item 2 is being paid from distribution B                                              A- 3-25.00 & B-3-25.00   item 3 is being split between distribution A & B"]
[]
[null,"NOTE:  If the invoice is for more than the requisition/purchase order, the System will pro-rate the average over the distributions.   If a department will not be contributing more than a specific amount, an internal journal entry initiated by the department may be needed after payment to transfer funds. "]
[]
[10,"Save the form under a unique file name (such as your department reference number, top left of form). "]
[]
[11,"If there are no attachments and there is only one authorized signature required, email the completed form to:  AccountsPayableSrvs@niu.edu.   If there are either attachments or multiple signatures required, print out the completed form, obtain the appropriate signatures on the hard copy, clip attachments, and forward the authorized document with attachments to Accounting."]
[]
[12,"EIT Accessible Technology Policy:  Electronic and information technology that enables all students, faculty and staff to achieve their academic and professional goals and aspirations.  http://doit.niu.edu/doit/Policies/accessible-technology.shtml "]