{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","LineNo","POData","TemplatePO","POLog","Export","POIndex"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":64,"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":"Instructions","index":0,"n_rows":105,"n_cols":11,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Smart PO Book"]
["⦿","This workbook is designed to work in tandem to with an excel budget file, such as True Budget or Hot Budget. "]
["⦿","This workbook has 3 primary functions."]
["⦿","It provides and generates PO Pages, without the need for manual duplication and numeration."]
["⦿","Each PO Page is designed to work in synchronicity with the PO Log, without requiring the double entry thereof"]
["⦿","It exports all pages seperately, with ease, and in batch. With appropriate filing numeration, to make wrap that much easier."]
[]
[null,"PAGES"]
[null,"LineNo"]
["⦿","In the line No Page, copy the line numbers from your job. "]
["⦿","Be aware there is also a section for CS Sections as well. Should you need to line items to general Cs Section.For example CS17 Travel, etc"]
[]
[null,"POData"]
["⦿","In the POData tab, you can generate and delete the Pos that are needed for your job"]
["⦿","Enter Production Company Name, Job Name, Job No, Address -> all of this will be sent to TemplatePO"]
["⦿","If you would like to add company logo, add currency conversion if needed, or make other changes/additions etc,. modify the TemplatePO page before generating pages."]
[]
["⦿","Enter the range of PO numbers that will be needed for your job, by entering the starting number, and ending number."]
["⦿","If there is a prefix for the range, enter the prefix in the prefix cell. If the company is using just a linear start number, and end number, leave the prefix cell blank"]
["⦿","Enter range needed. Will immediately display in PO Range table. If to your satisfaction, click Generate POs"]
["⦿","In the event you need additional Pos, simply enter the range needed. And subsequently click Generate Pos"]
["⦿","In the event you need to delete a large amount of Pos, repeat the process, but hit Delete all POs instead"]
[]
[null,"(po pages)"]
["⦿","The PO pages have a PO Log Preview to let you know an item has registered and carried over to the PO Log."]
["⦿","Each PO Page, has a max of 8 different Pay ID combo's it can display on the PO Log"]
["⦿","A Pay ID combo being a UNIQUE set of Line No + Pay ID + Date"]
["⦿","For an item to register, it must have a Line, Date, and Pay ID registered"]
["⦿","Often accounts payable requires a broad Pay ID type. The coding strip satisifies this need, but does NOT link to the PO Log."]
[]
[null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PO Log"]
["⦿","The true benefit of this workbook is to work in synchronous tandem with your PO Log"]
["⦿","Unlike a HotBudget file the PO Log should NOT be edited."]
["⦿","The PO Log works best as a device to copy into your TrueBudget file, knowing the PO Log reflects exactly what is in the PO Book"]
["⦿","To do so select + copy Line through Actual fields in PO Log"]
["⦿","Cmd + Option + V in your TrueBudget file. Select PASTE VALUES or UNICODE TEXT"]
[]
[null,1,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"POIndex"]
["⦿","Do not modify this page at all, it is used for backend PO cross tracking."]
["⦿","Do not hide this page. Workbook will not function"]
[null,"Export Pos"]
["⦿","Export PDF button exports each PO page seperately"]
["⦿","Each PDF file name will be that of its tab name, ie its PO"]
["⦿","output destination is that the PO Book is currently saved in"]
["⦿","Exported PDF POs can simply be dragged into the proper folders in your Finder window"]
["⦿","This is a beta feature. If it doesn't work, you may need to modify the Macro yourself. Under developer tab, macros, MACRO NAME"]
[]
[]
[]
[null,"BETA NOTES"]
["◎","Any bugs, notes, or otherwise email josh@jpax.tv"]

{"sheet":"LineNo","index":1,"n_rows":364,"n_cols":2,"rows_kept":364,"cut":false,"hidden":false,"merged":[]}
["A","PRE-PRO & WRAP CREW"]
[1,"Line Producer"]
[2,"Assistant Director"]
[3,"Director of Photography"]
[4,"2nd Unit DP"]
[5,"1st AC"]
[6,"2nd AC"]
[7,"Phantom Tech"]
[8,"DIT"]
[9,"Crane Operator"]
[10,"Crane Tech"]
[11,"Gaffer"]
[12,"BB Electric"]
[13,"3rd Electric"]
[14,"4th Electric/Driver"]
[15,"Package Truck Driver"]
[16,"Key Grip"]
[17,"BB Grip"]
[18,"3rd Grip"]
[19,"4th Grip/Driver"]
[20,"addt'l Grips"]
[21,"Sound Mixer"]
[22,"Boom Operator"]
[23,"Key Makeup"]
[24,"Key Hair"]
[25,"2nd Makeup/2nd Hair"]
[26,"Key Stylist"]
[27,"Stylist Assistant"]
[28,"Script Supervisor"]
[29,"Manicurist"]
[30,"Stills Digitech"]
[31,"VTR Operator"]
[32,"Bolt Tech"]
[33,"Bolt Op"]
[34,"Cam Car Arm Op + Tech"]
[35,"Camera Car Driver"]
[36,"ALM"]
[37,"Location Manager"]
[38,"Production Supervisor"]
[39,"Commercial Coordinator"]
[40,"Talent Coordinator"]
[41,"Medic/First Aid"]
[42,"Craft Service"]
[43,"Lifeguard"]
[44,"Choreographer"]
[45,"Drivers"]
[46,"Drivers"]
[47,"Teamsters"]
[48,"Production Assistants"]
[49,"Production Assistants"]
[50]
[51,"Line Producer"]
[52,"Assistant Director"]
[53,"Director of Photography"]
[54,"2nd Unit DP"]
[55,"1st AC"]
[56,"2nd AC"]
[57,"Phantom Tech"]
[58,"DIT"]
[59,"Steadicam Operator"]
[60,"Crane Tech"]
[61,"Gaffer"]
[62,"BB Electric"]
[63,"3rd Electric"]
[64,"4th Electric"]
[65,"Package Truck Driver"]
[66,"Key Grip"]
[67,"BB Grip"]
[68,"3rd Grip"]
[69,"4th Grip"]
[70,"Generator Operator"]
[71,"Sound Mixer"]
[72,"Boom Operator"]
[73,"Key Hair/Makeup"]
[74,"Asst Hair/Makeup"]
[75,"2nd Makeup/2nd Hair"]
[76,"Key Stylist"]
[77,"Stylist Assistant"]
[78,"Script Supervisor"]
[79,"Stills Asst"]
[80,"Stills Digitech"]
[81,"VTR Operator"]
[82,"VTR Asst"]
[83,"Bolt Op"]
[84,"Manicurist"]
[85,"Camera Car Driver"]
[86,"ALM"]
[87,"Location Manager"]
[88,"Production Supervisor"]
[89,"Commercial Coordinator"]
[90,"Talent Coordinator"]
[91,"2nd AD"]
[92,"Medic/First Aid"]
[93,"Craft Service"]
[94,"Craft Assistant"]
[95,"Drivers"]
[96,"Drivers"]
[97,"Teamsters"]
[98,"Production Assistants"]
[99,"Production Assistants"]
[100,"Police"]
["C","PRE-PRODUCTION & WRAP EXPENSES"]
[101,"Auto Rentals"]
[102,"Tech Scout Van/People Mover"]
[103,"Rehearsal Space"]
[104,"Pre Pro Expenses"]
[105,"Messengers"]
[106,"Trucking"]
[107,"Deliveries & Taxis"]
[108,"Working Meals"]
[109,"Background Casting"]
[110,"Casting Director"]
[111,"Casting Facilities"]
[112,"Pre Pro Meals"]
[113,"Location Scouting Expenses"]
["D","LOCATION EXPENSES"]
[114,"Location Fees - House/Grocery Store"]
[115,"Permit Fees"]
[116,"Basecamp"]
[117,"Crew Shuttles"]
[118,"Dressing Room Vehicles"]
[119,"Honeywagon/Restrooms"]
[120,"Parking, Tolls, & Gas"]
[121,"Grip & Electric Trucks"]
[122,"Camera Truck"]
[123,"Production Truck"]
[124,"Wardrobe Truck"]
[125,"Location Prep"]
[126,"Van Rentals"]
[127,"Van Rentals - Client/Agency/Chauffers"]
[128,"Client/Agency - Meals/treats"]
[129,"Security"]
[130,"Breakfast"]
[131,"Lunch"]
[132,"Dinner"]
[133,"Client/Agency - Miscellaneous"]
[134,"BG Meals"]
[135,"Kit Rental"]
[136,"BG Holding"]
[137,"Preight Craft"]
[138,"Prelight Meals"]
[139,"Craft Service"]
["E","PROPS, WARDROBE & ANIMALS"]
[140,"Food Truck Rental"]
[141,"Home Ec Supplies"]
[142,"Wardrobe Rentals"]
[143,"Wardrobe Rentals"]
[144,"Wardrobe Rentals"]
[145,"Aniamls & Trainers"]
[146,"Aniamls & Trainers"]
[147,"Humane Rep"]
[148,"Transportation"]
[149,"Wardrobe Misc. Costs"]
[150]
["F","STUDIO RENTAL & EXPENSES"]
[151,"Rental For Build Days "]
[152,"Build OT Hours"]
[153,"Rental for Pre-Lite Days"]
[154,"Pre-Lite OT Hours"]
[155,"Rental for Shoot Days"]
[156,"Shoot OT Hours"]
[157,"Rental for Strike Days"]
[158,"Strike OT Hours"]
[159,"Generator and Operator"]
[160,"Air Conditioning"]
[161,"Power Charges"]
[162,"Misc Studio Charges"]
[163]
[164]
[165]
[166]
[167]
["G","SET CONSTRUCTION CREW"]
[168,"Production Designer"]
[169,"Buyer/Shopper"]
[170,"Prop Master"]
[171,"Leadman"]
[172,"Driver/Set Dresser"]
[173,"Set Dresser"]
[174,"Set Dresser"]
[175,"Prop Assistant"]
[176,"Art Dept Coordinator"]
[177,"Food Stylist Assistant Prep Day"]
[178,"PA"]
[179,"Food Stylist Assists"]
[180,"SPFX Asst"]
["H","SET CONSTRUCTION MATERIALS"]
[181,"Prop Rentals & Purchsses"]
[182,"Set Dressing Rentals & Purchases"]
[183,"Custom Props"]
[184,"Construction"]
[185,"Backdrops"]
[186,"Food Truck"]
[187,"Food Props"]
[188,"Practical Sand and Clean up"]
[189,"Food Stylist Ground Transport"]
[190,"Art Dept Trucking"]
[191,"Parking and fuel"]
[192,"Kits and Meals"]
["I","EQUIPMENT RENTAL"]
[193,"Camera Rental"]
[194,"Sound Rental"]
[195,"Lighting Rental"]
[196,"Grip Rental"]
[197,"Generator Rental"]
[198,"Crane + Remote Head Rental"]
[199,"VTR Rental"]
[200,"Walkie Talkie Rental"]
[201,"Dolly Rental"]
[202,"Slider"]
[203,"Steadicam"]
[204,"Production Supplies"]
[205,"Location Supplies"]
[206,"Expendables"]
[207,"DIT Equipment"]
[208,"Stills Equipment"]
[209,"Package Truck"]
[210,"Phantom Camera Kit"]
["J","FILMSTOCK, DEVELOP & PRINT"]
[211,"Hard Drives"]
[212,"Transcodes"]
[213,"Slingshot Dailies"]
[214,"Film Stock"]
[215,"Processing"]
[216,"Drives"]
["K","MISCELLANEOUS COSTS"]
[217,"Storage Space"]
[218,"Shipping"]
[219,"Tax Waivers"]
[220,"DGA AD Letter"]
[221,"Work Permits / LMIA"]
[222,"Portable Wifi"]
[223,"Wire Rigging Equipment"]
[224,"Photographer Fees"]
[225,"Photographer Assist"]
[226]
["L","DIRECTOR/CREATIVE FEES"]
[227,"Director Prep"]
[228,"Director Shoot"]
[229,"Director Follow-up Shoots"]
[230,"Creative Director"]
[231,"Writers"]
[232,"Choreographer"]
[233]
["M","TALENT                                                                                           "]
[236,"O/C Principals"]
[237,"O/C Principals"]
[238,"O/C Principals"]
[239,"O/C Principals"]
[240,"O/C Principals"]
[241,"O/C Principals"]
[242,"O/C Principals"]
[243,"O/C Principals"]
[244,"O/C Principals"]
[245,"O/C Principals"]
[246]
[247]
[248]
[249,"General Extras"]
[250,"Extras Wardrobe Allowance"]
[251,"Extras Casting fee"]
[252,"Extras Payroll Service"]
[253,"Extras Covid Testing"]
[254,"General Extras"]
[255]
[256]
[257]
[258,"Hand Models"]
[259]
[260]
[261,"Voice Over"]
[262,"Fitting Fees"]
[263,"Fitting Fees"]
[264]
[265,"Audition Fees"]
[266,"Audition Fees"]
[267]
[268,"Talent"]
[269,"Talent Payroll Service"]
[270,"Talent Wardrobe Allowance"]
["N","Other"]
[271,"Director Flights"]
[272,"Per Diems"]
[273,"Director Hotels"]
[274,"Other"]
[275,"Other"]
[276]
["O"]
[277]
[278]
[279]
[280]
[281]
["P"]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310,"Covid Expenses"]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318,"Covid Testing Stipend"]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
["CS1","Pre-Production | Wrap Labor"]
["CS2","Shooting Labor"]
["CS3","Pre-production | Wrap Expenses"]
["CS4","Location And Staging"]
["CS5","Makeup, Wardrobe, And Animals"]
["CS6","Studio | Stage Rental / Expenses"]
["CS7","Art Department Labor"]
["CS8","Art Department Expenses"]
["CS9","Equipment Costs"]
["CS10","Filmstock, Develop And Print"]
["CS11","Miscellaneous"]
["CS12","Director | Creative Fees"]
["CS13","Talent Labor"]
["CS14","Travel Expenses"]
["CS15","Covid Labor"]
["CS16","Covid Expenses"]
["CS17","Travel Expenses"]
["CS18"]
["CS19","Travel"]
["CS20","Production Fee"]
["PC","Petty Cash"]
["PR","Payroll Log"]

{"sheet":"POData","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[7,1,7,3],[9,1,9,3],[4,1,5,2]]}
[null,"*Enter Job Name + Number*"]
[null,"Production Company"]
[null,"Job Name:"]
[null,"Job Number:"]
[null,"Production Address:"]
[]
[]
[null,"Enter PO Prefix Here",null,null,null,"PO range"]
[null,2555,null,null,null,{"$f":"Prefix & \"-\" & TEXT(_xlfn.SEQUENCE(C11 - B11 + 1, 1, B11, 1), \"000\")","v":"2555-001"}]
[null,"Enter PO Range Here"]
[null,1,1]
[]
[null,null,null,null,null,null,null,"Emergency Button Only"]

{"sheet":"TemplatePO","index":3,"n_rows":57,"n_cols":41,"rows_kept":57,"cut":false,"hidden":false,"merged":[[17,2,17,4],[17,5,17,8],[19,2,19,4],[19,5,19,8],[22,1,25,1],[38,2,38,3],[35,2,35,3],[27,2,27,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[31,2,31,3],[36,2,36,3],[37,2,37,3],[8,2,8,3],[8,5,8,8],[45,34,45,40],[9,2,9,3],[9,5,9,8],[28,2,28,3],[10,2,10,3],[12,5,12,8],[13,2,13,3],[13,5,13,8],[29,2,29,3],[30,2,30,3],[4,4,5,7],[6,1,6,2],[6,3,6,4],[4,2,4,3],[5,2,5,3],[0,6,0,8],[1,1,1,2],[1,3,1,6],[2,6,2,8],[3,1,3,6]]}
[null,{"$f":"IF(TRIM(ProductionCompany)=\"\", \"Production Company\", ProductionCompany)","v":"Production Company"}]
[]
[null,"PURCHASE ORDER / CHECK REQUEST",null,null,null,"P.O. NO.","{{PO_NUMBER}}"]
[]
[null,"Address",{"$f":"IF(TRIM(Job_Number)=\"\", \"\", Street_address)","v":""}]
[null,null,{"$f":"IF(TRIM(Job_Number)=\"\", \"\", city_address)","v":""}]
[]
[]
[null,"DATE",null,null,"JOB NO.",{"$f":"IF(TRIM(Job_Number)=\"\", \"\", Job_Number)","v":""}]
[null,"TO",null,null,"JOB NAME",{"$f":"IF(TRIM(Job_Name)=\"\", \"\", Job_Name)","v":""}]
[]
[null,"ADDRESS",{"$f":"IF(TRIM(Job_Name)=\"\", \"\", Street_address)","v":""},null,"TERMS"]
[null,null,{"$f":"IF(TRIM(Job_Name)=\"\", \"\", city_address)","v":""}]
[null,null,null,null,"SS or TIN"]
[]
[null,"NOTES:"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#A","#B","#C","#D","#E","#F","#G","#H","#OTHER"]
[null,null,null,null,null,null,null,null,null,null,"Line",{"$f":"IFERROR(\n    _xlfn.WRAPCOLS(\n        _xlfn.TOCOL(\n            INDEX(\n                _xlfn._xlws.FILTER(\n                    _xlfn.UNIQUE(_xlfn.HSTACK(LineEntry, DateEntry, PayIDEntry)),\n                    _xlfn.BYROW(_xlfn.UNIQUE(_xlfn.HSTACK(LineEntry, DateEntry, PayIDEntry)), _xlfn.LAMBDA(_xlpm.row, AND(_xlpm.row<>\"\")))\n                ),\n                _xlfn.SEQUENCE(8,1),\n                {1,2,3}\n            )\n        ),\n        3\n    ),\n    \"\"\n)","v":""},"","","","","","","",null,{"$f":"SUMPRODUCT(--(TRIM(L22:T22)<>\"\"))","v":0},"Line",{"$f":"IF(U22=0,\"\",TRANSPOSE(_xlfn._xlws.SORT(TRANSPOSE(INDEX(L22:T24,_xlfn.SEQUENCE(ROWS(L22:T24)),_xlfn.SEQUENCE(,U22))),1,TRUE)))","v":""}]
[null,"ACCOUNTS\nPAYABLE\nCODING\nSTRIP","DEPOSIT","PAYMENT","PETTY","CREDIT","WILL",null,"PAY",null,"Date","","","","","","","","",null,null,"Date"]
[null,null,"CHECK","CHECK","CASH","CARD","BILL",null,"ID",null,"PayID","","","","","","","","",null,null,"PayID"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#A","#B","#C","#D","#E","#F","#G","#H","#OTHER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B29=\"\", \"\", IF(AND($I29, $B29=W$22, $E29=W$23, $F29=W$24, SUM($I$29)>0), $I29, \"\"))","v":""},{"$f":"IF($B29=\"\", \"\", IF(AND($I29, $B29=X$22, $E29=X$23, $F29=X$24, SUM($I$29)>0), $I29, \"\"))","v":""},{"$f":"IF($B29=\"\", \"\", IF(AND($I29, $B29=Y$22, $E29=Y$23, $F29=Y$24, SUM($I$29)>0), $I29, \"\"))","v":""},{"$f":"IF($B29=\"\", \"\", IF(AND($I29, $B29=Z$22, $E29=Z$23, $F29=Z$24, SUM($I$29)>0), $I29, \"\"))","v":""},{"$f":"IF($B29=\"\", \"\", IF(AND($I29, $B29=AA$22, $E29=AA$23, $F29=AA$24, SUM($I$29)>0), $I29, \"\"))","v":""},{"$f":"IF($B29=\"\", \"\", IF(AND($I29, $B29=AB$22, $E29=AB$23, $F29=AB$24, SUM($I$29)>0), $I29, \"\"))","v":""},{"$f":"IF($B29=\"\", \"\", IF(AND($I29, $B29=AC$22, $E29=AC$23, $F29=AC$24, SUM($I$29)>0), $I29, \"\"))","v":""},{"$f":"IF($B29=\"\", \"\", IF(AND($I29, $B29=AD$22, $E29=AD$23, $F29=AD$24, SUM($I$29)>0), $I29, \"\"))","v":""},{"$f":"IF(AND(B29=\"\", E29=\"\", F29=\"\"), \"\", IF(OR(B29=\"\", E29=\"\", F29=\"\"), I29, \"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B30=\"\", \"\", IF(AND($I30, $B30=W$22, $E30=W$23, $F30=W$24, SUM($I$30)>0), $I30, \"\"))","v":""},{"$f":"IF($B30=\"\", \"\", IF(AND($I30, $B30=X$22, $E30=X$23, $F30=X$24, SUM($I$30)>0), $I30, \"\"))","v":""},{"$f":"IF($B30=\"\", \"\", IF(AND($I30, $B30=Y$22, $E30=Y$23, $F30=Y$24, SUM($I$30)>0), $I30, \"\"))","v":""},{"$f":"IF($B30=\"\", \"\", IF(AND($I30, $B30=Z$22, $E30=Z$23, $F30=Z$24, SUM($I$30)>0), $I30, \"\"))","v":""},{"$f":"IF($B30=\"\", \"\", IF(AND($I30, $B30=AA$22, $E30=AA$23, $F30=AA$24, SUM($I$30)>0), $I30, \"\"))","v":""},{"$f":"IF($B30=\"\", \"\", IF(AND($I30, $B30=AB$22, $E30=AB$23, $F30=AB$24, SUM($I$30)>0), $I30, \"\"))","v":""},{"$f":"IF($B30=\"\", \"\", IF(AND($I30, $B30=AC$22, $E30=AC$23, $F30=AC$24, SUM($I$30)>0), $I30, \"\"))","v":""},{"$f":"IF($B30=\"\", \"\", IF(AND($I30, $B30=AD$22, $E30=AD$23, $F30=AD$24, SUM($I$30)>0), $I30, \"\"))","v":""},{"$f":"IF(AND(B30=\"\", E30=\"\", F30=\"\"), \"\", IF(OR(B30=\"\", E30=\"\", F30=\"\"), I30, \"\"))","v":""}]
[null,"LINE","DESCRIPTION",null,"DATE","PAY ID","QUANTITY","COST","AMOUNT",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B31=\"\", \"\", IF(AND($I31, $B31=W$22, $E31=W$23, $F31=W$24, SUM($I$31)>0), $I31, \"\"))","v":""},{"$f":"IF($B31=\"\", \"\", IF(AND($I31, $B31=X$22, $E31=X$23, $F31=X$24, SUM($I$31)>0), $I31, \"\"))","v":""},{"$f":"IF($B31=\"\", \"\", IF(AND($I31, $B31=Y$22, $E31=Y$23, $F31=Y$24, SUM($I$31)>0), $I31, \"\"))","v":""},{"$f":"IF($B31=\"\", \"\", IF(AND($I31, $B31=Z$22, $E31=Z$23, $F31=Z$24, SUM($I$31)>0), $I31, \"\"))","v":""},{"$f":"IF($B31=\"\", \"\", IF(AND($I31, $B31=AA$22, $E31=AA$23, $F31=AA$24, SUM($I$31)>0), $I31, \"\"))","v":""},{"$f":"IF($B31=\"\", \"\", IF(AND($I31, $B31=AB$22, $E31=AB$23, $F31=AB$24, SUM($I$31)>0), $I31, \"\"))","v":""},{"$f":"IF($B31=\"\", \"\", IF(AND($I31, $B31=AC$22, $E31=AC$23, $F31=AC$24, SUM($I$31)>0), $I31, \"\"))","v":""},{"$f":"IF($B31=\"\", \"\", IF(AND($I31, $B31=AD$22, $E31=AD$23, $F31=AD$24, SUM($I$31)>0), $I31, \"\"))","v":""},{"$f":"IF(AND(B31=\"\", E31=\"\", F31=\"\"), \"\", IF(OR(B31=\"\", E31=\"\", F31=\"\"), I31, \"\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"G29*H29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B32=\"\", \"\", IF(AND($I32, $B32=W$22, $E32=W$23, $F32=W$24, SUM($I$32)>0), $I32, \"\"))","v":""},{"$f":"IF($B32=\"\", \"\", IF(AND($I32, $B32=X$22, $E32=X$23, $F32=X$24, SUM($I$32)>0), $I32, \"\"))","v":""},{"$f":"IF($B32=\"\", \"\", IF(AND($I32, $B32=Y$22, $E32=Y$23, $F32=Y$24, SUM($I$32)>0), $I32, \"\"))","v":""},{"$f":"IF($B32=\"\", \"\", IF(AND($I32, $B32=Z$22, $E32=Z$23, $F32=Z$24, SUM($I$32)>0), $I32, \"\"))","v":""},{"$f":"IF($B32=\"\", \"\", IF(AND($I32, $B32=AA$22, $E32=AA$23, $F32=AA$24, SUM($I$32)>0), $I32, \"\"))","v":""},{"$f":"IF($B32=\"\", \"\", IF(AND($I32, $B32=AB$22, $E32=AB$23, $F32=AB$24, SUM($I$32)>0), $I32, \"\"))","v":""},{"$f":"IF($B32=\"\", \"\", IF(AND($I32, $B32=AC$22, $E32=AC$23, $F32=AC$24, SUM($I$32)>0), $I32, \"\"))","v":""},{"$f":"IF($B32=\"\", \"\", IF(AND($I32, $B32=AD$22, $E32=AD$23, $F32=AD$24, SUM($I$32)>0), $I32, \"\"))","v":""},{"$f":"IF(AND(B32=\"\", E32=\"\", F32=\"\"), \"\", IF(OR(B32=\"\", E32=\"\", F32=\"\"), I32, \"\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"G30*H30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B33=\"\", \"\", IF(AND($I33, $B33=W$22, $E33=W$23, $F33=W$24, SUM($I$33)>0), $I33, \"\"))","v":""},{"$f":"IF($B33=\"\", \"\", IF(AND($I33, $B33=X$22, $E33=X$23, $F33=X$24, SUM($I$33)>0), $I33, \"\"))","v":""},{"$f":"IF($B33=\"\", \"\", IF(AND($I33, $B33=Y$22, $E33=Y$23, $F33=Y$24, SUM($I$33)>0), $I33, \"\"))","v":""},{"$f":"IF($B33=\"\", \"\", IF(AND($I33, $B33=Z$22, $E33=Z$23, $F33=Z$24, SUM($I$33)>0), $I33, \"\"))","v":""},{"$f":"IF($B33=\"\", \"\", IF(AND($I33, $B33=AA$22, $E33=AA$23, $F33=AA$24, SUM($I$33)>0), $I33, \"\"))","v":""},{"$f":"IF($B33=\"\", \"\", IF(AND($I33, $B33=AB$22, $E33=AB$23, $F33=AB$24, SUM($I$33)>0), $I33, \"\"))","v":""},{"$f":"IF($B33=\"\", \"\", IF(AND($I33, $B33=AC$22, $E33=AC$23, $F33=AC$24, SUM($I$33)>0), $I33, \"\"))","v":""},{"$f":"IF($B33=\"\", \"\", IF(AND($I33, $B33=AD$22, $E33=AD$23, $F33=AD$24, SUM($I$33)>0), $I33, \"\"))","v":""},{"$f":"IF(AND(B33=\"\", E33=\"\", F33=\"\"), \"\", IF(OR(B33=\"\", E33=\"\", F33=\"\"), I33, \"\"))","v":""}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B34=\"\", \"\", IF(AND($I34, $B34=W$22, $E34=W$23, $F34=W$24, SUM($I$34)>0), $I34, \"\"))","v":""},{"$f":"IF($B34=\"\", \"\", IF(AND($I34, $B34=X$22, $E34=X$23, $F34=X$24, SUM($I$34)>0), $I34, \"\"))","v":""},{"$f":"IF($B34=\"\", \"\", IF(AND($I34, $B34=Y$22, $E34=Y$23, $F34=Y$24, SUM($I$34)>0), $I34, \"\"))","v":""},{"$f":"IF($B34=\"\", \"\", IF(AND($I34, $B34=Z$22, $E34=Z$23, $F34=Z$24, SUM($I$34)>0), $I34, \"\"))","v":""},{"$f":"IF($B34=\"\", \"\", IF(AND($I34, $B34=AA$22, $E34=AA$23, $F34=AA$24, SUM($I$34)>0), $I34, \"\"))","v":""},{"$f":"IF($B34=\"\", \"\", IF(AND($I34, $B34=AB$22, $E34=AB$23, $F34=AB$24, SUM($I$34)>0), $I34, \"\"))","v":""},{"$f":"IF($B34=\"\", \"\", IF(AND($I34, $B34=AC$22, $E34=AC$23, $F34=AC$24, SUM($I$34)>0), $I34, \"\"))","v":""},{"$f":"IF($B34=\"\", \"\", IF(AND($I34, $B34=AD$22, $E34=AD$23, $F34=AD$24, SUM($I$34)>0), $I34, \"\"))","v":""},{"$f":"IF(AND(B34=\"\", E34=\"\", F34=\"\"), \"\", IF(OR(B34=\"\", E34=\"\", F34=\"\"), I34, \"\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"G32*H32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B35=\"\", \"\", IF(AND($I35, $B35=W$22, $E35=W$23, $F35=W$24, SUM($I$35)>0), $I35, \"\"))","v":""},{"$f":"IF($B35=\"\", \"\", IF(AND($I35, $B35=X$22, $E35=X$23, $F35=X$24, SUM($I$35)>0), $I35, \"\"))","v":""},{"$f":"IF($B35=\"\", \"\", IF(AND($I35, $B35=Y$22, $E35=Y$23, $F35=Y$24, SUM($I$35)>0), $I35, \"\"))","v":""},{"$f":"IF($B35=\"\", \"\", IF(AND($I35, $B35=Z$22, $E35=Z$23, $F35=Z$24, SUM($I$35)>0), $I35, \"\"))","v":""},{"$f":"IF($B35=\"\", \"\", IF(AND($I35, $B35=AA$22, $E35=AA$23, $F35=AA$24, SUM($I$35)>0), $I35, \"\"))","v":""},{"$f":"IF($B35=\"\", \"\", IF(AND($I35, $B35=AB$22, $E35=AB$23, $F35=AB$24, SUM($I$35)>0), $I35, \"\"))","v":""},{"$f":"IF($B35=\"\", \"\", IF(AND($I35, $B35=AC$22, $E35=AC$23, $F35=AC$24, SUM($I$35)>0), $I35, \"\"))","v":""},{"$f":"IF($B35=\"\", \"\", IF(AND($I35, $B35=AD$22, $E35=AD$23, $F35=AD$24, SUM($I$35)>0), $I35, \"\"))","v":""},{"$f":"IF(AND(B35=\"\", E35=\"\", F35=\"\"), \"\", IF(OR(B35=\"\", E35=\"\", F35=\"\"), I35, \"\"))","v":""}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B36=\"\", \"\", IF(AND($I36, $B36=W$22, $E36=W$23, $F36=W$24, SUM($I$36)>0), $I36, \"\"))","v":""},{"$f":"IF($B36=\"\", \"\", IF(AND($I36, $B36=X$22, $E36=X$23, $F36=X$24, SUM($I$36)>0), $I36, \"\"))","v":""},{"$f":"IF($B36=\"\", \"\", IF(AND($I36, $B36=Y$22, $E36=Y$23, $F36=Y$24, SUM($I$36)>0), $I36, \"\"))","v":""},{"$f":"IF($B36=\"\", \"\", IF(AND($I36, $B36=Z$22, $E36=Z$23, $F36=Z$24, SUM($I$36)>0), $I36, \"\"))","v":""},{"$f":"IF($B36=\"\", \"\", IF(AND($I36, $B36=AA$22, $E36=AA$23, $F36=AA$24, SUM($I$36)>0), $I36, \"\"))","v":""},{"$f":"IF($B36=\"\", \"\", IF(AND($I36, $B36=AB$22, $E36=AB$23, $F36=AB$24, SUM($I$36)>0), $I36, \"\"))","v":""},{"$f":"IF($B36=\"\", \"\", IF(AND($I36, $B36=AC$22, $E36=AC$23, $F36=AC$24, SUM($I$36)>0), $I36, \"\"))","v":""},{"$f":"IF($B36=\"\", \"\", IF(AND($I36, $B36=AD$22, $E36=AD$23, $F36=AD$24, SUM($I$36)>0), $I36, \"\"))","v":""},{"$f":"IF(AND(B36=\"\", E36=\"\", F36=\"\"), \"\", IF(OR(B36=\"\", E36=\"\", F36=\"\"), I36, \"\"))","v":""}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B37=\"\", \"\", IF(AND($I37, $B37=W$22, $E37=W$23, $F37=W$24, SUM($I$37)>0), $I37, \"\"))","v":""},{"$f":"IF($B37=\"\", \"\", IF(AND($I37, $B37=X$22, $E37=X$23, $F37=X$24, SUM($I$37)>0), $I37, \"\"))","v":""},{"$f":"IF($B37=\"\", \"\", IF(AND($I37, $B37=Y$22, $E37=Y$23, $F37=Y$24, SUM($I$37)>0), $I37, \"\"))","v":""},{"$f":"IF($B37=\"\", \"\", IF(AND($I37, $B37=Z$22, $E37=Z$23, $F37=Z$24, SUM($I$37)>0), $I37, \"\"))","v":""},{"$f":"IF($B37=\"\", \"\", IF(AND($I37, $B37=AA$22, $E37=AA$23, $F37=AA$24, SUM($I$37)>0), $I37, \"\"))","v":""},{"$f":"IF($B37=\"\", \"\", IF(AND($I37, $B37=AB$22, $E37=AB$23, $F37=AB$24, SUM($I$37)>0), $I37, \"\"))","v":""},{"$f":"IF($B37=\"\", \"\", IF(AND($I37, $B37=AC$22, $E37=AC$23, $F37=AC$24, SUM($I$37)>0), $I37, \"\"))","v":""},{"$f":"IF($B37=\"\", \"\", IF(AND($I37, $B37=AD$22, $E37=AD$23, $F37=AD$24, SUM($I$37)>0), $I37, \"\"))","v":""},{"$f":"IF(AND(B37=\"\", E37=\"\", F37=\"\"), \"\", IF(OR(B37=\"\", E37=\"\", F37=\"\"), I37, \"\"))","v":""}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B38=\"\", \"\", IF(AND($I38, $B38=W$22, $E38=W$23, $F38=W$24, SUM($I$38)>0), $I38, \"\"))","v":""},{"$f":"IF($B38=\"\", \"\", IF(AND($I38, $B38=X$22, $E38=X$23, $F38=X$24, SUM($I$38)>0), $I38, \"\"))","v":""},{"$f":"IF($B38=\"\", \"\", IF(AND($I38, $B38=Y$22, $E38=Y$23, $F38=Y$24, SUM($I$38)>0), $I38, \"\"))","v":""},{"$f":"IF($B38=\"\", \"\", IF(AND($I38, $B38=Z$22, $E38=Z$23, $F38=Z$24, SUM($I$38)>0), $I38, \"\"))","v":""},{"$f":"IF($B38=\"\", \"\", IF(AND($I38, $B38=AA$22, $E38=AA$23, $F38=AA$24, SUM($I$38)>0), $I38, \"\"))","v":""},{"$f":"IF($B38=\"\", \"\", IF(AND($I38, $B38=AB$22, $E38=AB$23, $F38=AB$24, SUM($I$38)>0), $I38, \"\"))","v":""},{"$f":"IF($B38=\"\", \"\", IF(AND($I38, $B38=AC$22, $E38=AC$23, $F38=AC$24, SUM($I$38)>0), $I38, \"\"))","v":""},{"$f":"IF($B38=\"\", \"\", IF(AND($I38, $B38=AD$22, $E38=AD$23, $F38=AD$24, SUM($I$38)>0), $I38, \"\"))","v":""},{"$f":"IF(AND(B38=\"\", E38=\"\", F38=\"\"), \"\", IF(OR(B38=\"\", E38=\"\", F38=\"\"), I38, \"\"))","v":""}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B39=\"\", \"\", IF(AND($I39, $B39=W$22, $E39=W$23, $F39=W$24, SUM($I$39)>0), $I39, \"\"))","v":""},{"$f":"IF($B39=\"\", \"\", IF(AND($I39, $B39=X$22, $E39=X$23, $F39=X$24, SUM($I$39)>0), $I39, \"\"))","v":""},{"$f":"IF($B39=\"\", \"\", IF(AND($I39, $B39=Y$22, $E39=Y$23, $F39=Y$24, SUM($I$39)>0), $I39, \"\"))","v":""},{"$f":"IF($B39=\"\", \"\", IF(AND($I39, $B39=Z$22, $E39=Z$23, $F39=Z$24, SUM($I$39)>0), $I39, \"\"))","v":""},{"$f":"IF($B39=\"\", \"\", IF(AND($I39, $B39=AA$22, $E39=AA$23, $F39=AA$24, SUM($I$39)>0), $I39, \"\"))","v":""},{"$f":"IF($B39=\"\", \"\", IF(AND($I39, $B39=AB$22, $E39=AB$23, $F39=AB$24, SUM($I$39)>0), $I39, \"\"))","v":""},{"$f":"IF($B39=\"\", \"\", IF(AND($I39, $B39=AC$22, $E39=AC$23, $F39=AC$24, SUM($I$39)>0), $I39, \"\"))","v":""},{"$f":"IF($B39=\"\", \"\", IF(AND($I39, $B39=AD$22, $E39=AD$23, $F39=AD$24, SUM($I$39)>0), $I39, \"\"))","v":""},{"$f":"IF(AND(B39=\"\", E39=\"\", F39=\"\"), \"\", IF(OR(B39=\"\", E39=\"\", F39=\"\"), I39, \"\"))","v":""}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM($W$26:$W$36), SUM($W$26:$W$36),\"\")","v":""},{"$f":"IF(SUM($X$26:$X$36), SUM($X26:$X36),\"\")","v":""},{"$f":"IF(SUM(Y$26:Y$36), SUM(Y$26:Y$36),\"\")","v":""},{"$f":"IF(SUM(Z$26:Z$36), SUM(Z$26:Z$36),\"\")","v":""},{"$f":"IF(SUM(AA$26:AA$36), SUM(AA$26:AA$36),\"\")","v":""},{"$f":"IF(SUM(AB$26:AB$36), SUM(AB$26:AB$36),\"\")","v":""},{"$f":"IF(SUM(AC$26:AC$36), SUM(AC$26:AC$36),\"\")","v":""},{"$f":"IF(SUM(AD$26:AD$36), SUM(AD$26:AD$36),\"\")","v":""},{"$f":"IF(SUM($AE$26:$AE$36), SUM($AE$26:$AE$36),\"\")","v":""}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[]
[null,"Ordered By",null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(I28:I39)","v":0}]
[]
[null,null,null,null,null,null,"TAX","(Enter if needed)"]
[null,"Authorized By",null,null,null,null,"TOTAL",null,{"$f":"SUM(I41:I43)","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,{"$f":"IF(AN57<>I44, \"ERROR IN BREAKDOWN!!!\", \"\")","v":""},null,null,{"$f":"IF(AI44=\"ERROR IN BREAKDOWN!!!\", \"Exceeded Max Pay IDs. OR missing details\", \"\")","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,"PO LOG PREVIEW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HHEADER","LINE","PAYEE","PO","DATE","PAY ID","ACTUAL","LINE DESCRIPTION"]
[null,null,null,null,null,null,null,null,null,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(SUM($W$26:$W$36), \"#A\",\"\")","v":""},{"$f":"IF(TemplatePO!$AH48=\"#A\", W22,\"\")","v":""},{"$f":"IF(TemplatePO!$AH48=\"#A\", Vendor,\"\")","v":""},{"$f":"IF(TemplatePO!$AH48=\"#A\", Sheet_PO,\"\")","v":""},{"$f":"IF(TemplatePO!$AH48=\"#A\", W$23,\"\")","v":""},{"$f":"IF(TemplatePO!$AH48=\"#A\", W$24,\"\")","v":""},{"$f":"IF(TemplatePO!$AH48=\"#A\", W$37,\"\")","v":""},{"$f":"IF(TemplatePO!$AH48=\"#A\",\n      INDEX(LineNo!$B$1:$B$374, MATCH(TemplatePO!$AI48, LineNo!$A$1:$A$374, 0)),\n      \"\")","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,{"$f":"IF(SUM($X$26:$X$36), \"#B\", \"\")","v":""},{"$f":"IF(TemplatePO!$AH49=\"#B\", X22,\"\")","v":""},{"$f":"IF(TemplatePO!$AH49=\"#B\", Vendor,\"\")","v":""},{"$f":"IF(TemplatePO!$AH49=\"#B\", Sheet_PO,\"\")","v":""},{"$f":"IF(TemplatePO!$AH49=\"#B\", X23,\"\")","v":""},{"$f":"IF(TemplatePO!$AH49=\"#B\", X24,\"\")","v":""},{"$f":"IF(TemplatePO!$AH49=\"#B\", X37,\"\")","v":""},{"$f":"IF(TemplatePO!$AH49=\"#B\",\n      INDEX(LineNo!$B$1:$B$374, MATCH(TemplatePO!$AI49, LineNo!$A$1:$A$374, 0)),\n      \"\")","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,{"$f":"IF(SUM($Y$26:$Y$36), \"#C\", \"\")","v":""},{"$f":"IF(TemplatePO!$AH50=\"#C\", Y22,\"\")","v":""},{"$f":"IF(TemplatePO!$AH50=\"#C\", Vendor,\"\")","v":""},{"$f":"IF(TemplatePO!$AH50=\"#C\", Sheet_PO,\"\")","v":""},{"$f":"IF(TemplatePO!$AH50=\"#C\", Y23,\"\")","v":""},{"$f":"IF(TemplatePO!$AH50=\"#C\", Y24,\"\")","v":""},{"$f":"IF(TemplatePO!$AH50=\"#C\", Y37,\"\")","v":""},{"$f":"IF(TemplatePO!$AH50=\"#C\",\n      INDEX(LineNo!$B$1:$B$374, MATCH(TemplatePO!$AI50, LineNo!$A$1:$A$374, 0)),\n      \"\")","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,{"$f":"IF(SUM($Z$26:$Z$36), \"#D\", \"\")","v":""},{"$f":"IF(TemplatePO!$AH51=\"#D\", Z22,\"\")","v":""},{"$f":"IF(TemplatePO!$AH51=\"#D\", Vendor,\"\")","v":""},{"$f":"IF(TemplatePO!$AH51=\"#D\", Sheet_PO,\"\")","v":""},{"$f":"IF(TemplatePO!$AH51=\"#D\", Z23,\"\")","v":""},{"$f":"IF(TemplatePO!$AH51=\"#D\", Z24,\"\")","v":""},{"$f":"IF(TemplatePO!$AH51=\"#D\", Z37,\"\")","v":""},{"$f":"IF(TemplatePO!$AH51=\"#D\",\n      INDEX(LineNo!$B$1:$B$374, MATCH(TemplatePO!$AI51, LineNo!$A$1:$A$374, 0)),\n      \"\")","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,{"$f":"IF(SUM($AA$26:$AA$36), \"#E\", \"\")","v":""},{"$f":"IF(TemplatePO!$AH52=\"#E\", AA22,\"\")","v":""},{"$f":"IF(TemplatePO!$AH52=\"#E\", Vendor,\"\")","v":""},{"$f":"IF(TemplatePO!$AH52=\"#E\", Sheet_PO,\"\")","v":""},{"$f":"IF(TemplatePO!$AH52=\"#E\", AA23,\"\")","v":""},{"$f":"IF(TemplatePO!$AH52=\"#E\", AA24,\"\")","v":""},{"$f":"IF(TemplatePO!$AH52=\"#E\",AA37, \"\")","v":""},{"$f":"IF(TemplatePO!$AH52=\"#E\",\n      INDEX(LineNo!$B$1:$B$374, MATCH(TemplatePO!$AI52, LineNo!$A$1:$A$374, 0)),\n      \"\")","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,{"$f":"IF(SUM($AB$26:$AB$36), \"#F\", \"\")","v":""},{"$f":"IF(TemplatePO!$AH53=\"#F\", AB22,\"\")","v":""},{"$f":"IF(TemplatePO!$AH53=\"#F\", Vendor,\"\")","v":""},{"$f":"IF(TemplatePO!$AH53=\"#F\", Sheet_PO,\"\")","v":""},{"$f":"IF(TemplatePO!$AH53=\"#F\", AB23,\"\")","v":""},{"$f":"IF(TemplatePO!$AH53=\"#F\", AB24,\"\")","v":""},{"$f":"IF(TemplatePO!$AH53=\"#F\", AB37,\"\")","v":""},{"$f":"IF(TemplatePO!$AH53=\"#F\",\n      INDEX(LineNo!$B$1:$B$374, MATCH(TemplatePO!$AI53, LineNo!$A$1:$A$374, 0)),\n      \"\")","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,{"$f":"IF(SUM($AC$26:$AC$36), \"#G\", \"\")","v":""},{"$f":"IF(TemplatePO!$AH54=\"#G\", AC22,\"\")","v":""},{"$f":"IF(TemplatePO!$AH54=\"#G\", Vendor,\"\")","v":""},{"$f":"IF(TemplatePO!$AH54=\"#G\", Sheet_PO,\"\")","v":""},{"$f":"IF(TemplatePO!$AH54=\"#G\", AC23,\"\")","v":""},{"$f":"IF(TemplatePO!$AH54=\"#G\", AC24,\"\")","v":""},{"$f":"IF(TemplatePO!$AH54=\"#G\", AC37,\"\")","v":""},{"$f":"IF(TemplatePO!$AH54=\"#G\",\n      INDEX(LineNo!$B$1:$B$374, MATCH(TemplatePO!$AI54, LineNo!$A$1:$A$374, 0)),\n      \"\")","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,"LineCount",{"$f":"IF(SUM($AD$26:$AD$36), \"#H\", \"\")","v":""},{"$f":"IF(TemplatePO!$AH55=\"#H\", AD22,\"\")","v":""},{"$f":"IF(TemplatePO!$AH55=\"#H\", Vendor,\"\")","v":""},{"$f":"IF(TemplatePO!$AH55=\"#H\", Sheet_PO,\"\")","v":""},{"$f":"IF(TemplatePO!$AH55=\"#H\", AD23,\"\")","v":""},{"$f":"IF(TemplatePO!$AH55=\"#H\", AD24,\"\")","v":""},{"$f":"IF(TemplatePO!$AH55=\"#H\", AD37,\"\")","v":""},{"$f":"IF(TemplatePO!$AH55=\"#H\",\n      INDEX(LineNo!$B$1:$B$374, MATCH(TemplatePO!$AI55, LineNo!$A$1:$A$374, 0)),\n      \"\")","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,{"$f":"SUMPRODUCT(--(AH48:AH55<>\"\"))","v":0},{"$f":"IF(SUM($AE$26:$AE$36), \"#OTHER\", \"\")","v":""},null,{"$f":"IF(TemplatePO!$AH56=\"#OTHER\", Vendor,\"\")","v":""},{"$f":"IF(TemplatePO!$AH56=\"#OTHER\", Sheet_PO,\"\")","v":""},null,null,{"$f":"IF(TemplatePO!$AH56=\"#OTHER\", AE37,\"\")","v":""},{"$f":"IF(TemplatePO!$AH56=\"#OTHER\",\n     \"Line No., Date, Pay ID required for PO Log\",\n     \"\")","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,"LogTotal",{"$f":"SUM(Template_table[ACTUAL])","v":0}]

{"sheet":"POLog","index":4,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[3,1,3,7]]}
[null,"TOTAL",{"$f":"SUM(INDEX(PO_Log, 2, 7):INDEX(PO_Log, ROWS(PO_Log)-1, 7))","v":0}]
[]
[]
[null,"PURCHASE ORDER LOG"]
[]
[null,"LINE","PAYEE","PO","DATE","PAY ID","ACTUAL","LINE DESCRIPTION"]
[{"$f":"_xlfn.LET(\n    _xlpm.poList, PO_Index[PO],\n    _xlpm.rowCounts, PO_Index[RowCount],\n    _xlpm.firstPO, _xlfn.TAKE(\n        INDIRECT(\"'\" & INDEX(_xlpm.poList, 1) & \"'!_\" & SUBSTITUTE(INDEX(_xlpm.poList, 1), \"-\", \"_\") & \"_table\"),\n        INDEX(_xlpm.rowCounts, 1)\n    ),\n    _xlfn.REDUCE(\n        _xlpm.firstPO, _xlfn.SEQUENCE(ROWS(_xlpm.poList)-1, ,2),\n        _xlfn.LAMBDA(_xlpm.a,_xlpm.i,\n            _xlfn.VSTACK(_xlpm.a, _xlfn.TAKE(\n                INDIRECT(\"'\" & INDEX(_xlpm.poList, _xlpm.i) & \"'!_\" & SUBSTITUTE(INDEX(_xlpm.poList, _xlpm.i), \"-\", \"_\") & \"_table\"),\n                INDEX(_xlpm.rowCounts, _xlpm.i)\n            ))\n        )\n    )\n)","v":{"$error":"#VALUE!"}}]

{"sheet":"Export","index":5,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Export"]
["⦿","Export buttons assumes user is a Mac user, and exports all PDF pages to Users Desktop"]
["⦿","Button 1: Export PDF's each PO page individually, by sheet name to folder location of the PO Book"]
[]
[]
[]
[]
[]
["⦿","If that did not work, check to see if there are spaces in the file path of your PO Book location. "]
[null,"If so, move the PO book to a location where no spaces are in file path. Such as user desktop. And try again."]

{"sheet":"POIndex","index":6,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"DO NOT MODIFY"]
[]
[null,"Sheet Index"]
[null,"PO","RowCount"]