{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["PO Form"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"PO Form","index":0,"n_rows":32,"n_cols":56,"rows_kept":32,"cut":false,"hidden":false,"merged":[[10,1,10,5],[2,4,3,5]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"Disc.Price","No-Disc Price","Spl.Amt."]
[null,null,null,null,"Customer Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/4 inch Bulk COMAND",37,43,{"$f":"\"$ 43.00 *\"","v":"$ 43.00 *"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/8 inch Bulk COMAND",50,57,{"$f":"\"$ 57.00 *\"","v":"$ 57.00 *"}]
[null,null,null,null,"Name :"]
[null,"863-665-5800 | (866) 853-4653",null,null,"Customer Name :"]
[null,null,null,null,"Customer Number:"]
[null,null,null,null,"Email :"]
[null,null,null,null,"Phone :"]
[]
[null,"Book Now – Save Later\nCOMAND Purchase Agreement\nBuy 4 truckloads between April and October to qualify for huge savings."]
[]
[null,"Delivery Month","# Truckloads (~60 Yards)","Item","Price / Yard","Total"]
[null,null,null,null,{"$f":"IF(OR($C14=\"\",$D14=\"\"),\"\",IF(AND($C$26>=4,$D14=\"1/4 inch Bulk COMAND\"),$BD$3,IF(AND($C$26<=4,$D14=\"1/4 inch Bulk COMAND\"),$BC$3,IF(AND($C$26>=4,$D14=\"1/8 inch Bulk COMAND\"),$BD$4,IF(AND($C$26<=4,$D14=\"1/8 inch Bulk COMAND\"),$BC$4)))))","v":""},{"$f":"IF(OR($C14=\"\",$D14=\"\"),\"\",IF(AND(COUNTA($C$14:$C14)>=4,$D14=\"1/4 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$3*$C14)),IF(AND(COUNTA($C$14:$C14)<=4,$D14=\"1/4 inch Bulk COMAND\"),$BA$2*$BC$3*$C14,IF(AND(COUNTA($C$14:$C14)>=4,$D14=\"1/8 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$4*$C14)),IF(AND(COUNTA($C$14:$C14)<=4,$D14=\"1/8 inch Bulk COMAND\"),$BA$2*$BC$4*$C14)))))","v":""}]
[null,null,null,null,{"$f":"IF(OR($C15=\"\",$D15=\"\"),\"\",IF(AND($C$26>=4,$D15=\"1/4 inch Bulk COMAND\"),$BD$3,IF(AND($C$26<=4,$D15=\"1/4 inch Bulk COMAND\"),$BC$3,IF(AND($C$26>=4,$D15=\"1/8 inch Bulk COMAND\"),$BD$4,IF(AND($C$26<=4,$D15=\"1/8 inch Bulk COMAND\"),$BC$4)))))","v":""},{"$f":"IF(OR($C15=\"\",$D15=\"\"),\"\",IF(AND(COUNTA($C$14:$C15)>=4,$D15=\"1/4 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$3*$C15)),IF(AND(COUNTA($C$14:$C15)<=4,$D15=\"1/4 inch Bulk COMAND\"),$BA$2*$BC$3*$C15,IF(AND(COUNTA($C$14:$C15)>=4,$D15=\"1/8 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$4*$C15)),IF(AND(COUNTA($C$14:$C15)<=4,$D15=\"1/8 inch Bulk COMAND\"),$BA$2*$BC$4*$C15)))))","v":""}]
[null,null,null,null,"",{"$f":"IF(OR($C16=\"\",$D16=\"\"),\"\",IF(AND(COUNTA($C$14:$C16)>=4,$D16=\"1/4 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$3*$C16)),IF(AND(COUNTA($C$14:$C16)<=4,$D16=\"1/4 inch Bulk COMAND\"),$BA$2*$BC$3*$C16,IF(AND(COUNTA($C$14:$C16)>=4,$D16=\"1/8 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$4*$C16)),IF(AND(COUNTA($C$14:$C16)<=4,$D16=\"1/8 inch Bulk COMAND\"),$BA$2*$BC$4*$C16)))))","v":""}]
[null,null,null,null,"",{"$f":"IF(OR($C17=\"\",$D17=\"\"),\"\",IF(AND(COUNTA($C$14:$C17)>=4,$D17=\"1/4 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$3*$C17)),IF(AND(COUNTA($C$14:$C17)<=4,$D17=\"1/4 inch Bulk COMAND\"),$BA$2*$BC$3*$C17,IF(AND(COUNTA($C$14:$C17)>=4,$D17=\"1/8 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$4*$C17)),IF(AND(COUNTA($C$14:$C17)<=4,$D17=\"1/8 inch Bulk COMAND\"),$BA$2*$BC$4*$C17)))))","v":""}]
[null,null,null,null,"",{"$f":"IF(OR($C18=\"\",$D18=\"\"),\"\",IF(AND(COUNTA($C$14:$C18)>=4,$D18=\"1/4 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$3*$C18)),IF(AND(COUNTA($C$14:$C18)<=4,$D18=\"1/4 inch Bulk COMAND\"),$BA$2*$BC$3*$C18,IF(AND(COUNTA($C$14:$C18)>=4,$D18=\"1/8 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$4*$C18)),IF(AND(COUNTA($C$14:$C18)<=4,$D18=\"1/8 inch Bulk COMAND\"),$BA$2*$BC$4*$C18)))))","v":""}]
[null,null,null,null,"",{"$f":"IF(OR($C19=\"\",$D19=\"\"),\"\",IF(AND(COUNTA($C$14:$C19)>=4,$D19=\"1/4 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$3*$C19)),IF(AND(COUNTA($C$14:$C19)<=4,$D19=\"1/4 inch Bulk COMAND\"),$BA$2*$BC$3*$C19,IF(AND(COUNTA($C$14:$C19)>=4,$D19=\"1/8 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$4*$C19)),IF(AND(COUNTA($C$14:$C19)<=4,$D19=\"1/8 inch Bulk COMAND\"),$BA$2*$BC$4*$C19)))))","v":""}]
[null,null,null,null,"",{"$f":"IF(OR($C20=\"\",$D20=\"\"),\"\",IF(AND(COUNTA($C$14:$C20)>=4,$D20=\"1/4 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$3*$C20)),IF(AND(COUNTA($C$14:$C20)<=4,$D20=\"1/4 inch Bulk COMAND\"),$BA$2*$BC$3*$C20,IF(AND(COUNTA($C$14:$C20)>=4,$D20=\"1/8 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$4*$C20)),IF(AND(COUNTA($C$14:$C20)<=4,$D20=\"1/8 inch Bulk COMAND\"),$BA$2*$BC$4*$C20)))))","v":""}]
[null,null,null,null,"",{"$f":"IF(OR($C21=\"\",$D21=\"\"),\"\",IF(AND(COUNTA($C$14:$C21)>=4,$D21=\"1/4 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$3*$C21)),IF(AND(COUNTA($C$14:$C21)<=4,$D21=\"1/4 inch Bulk COMAND\"),$BA$2*$BC$3*$C21,IF(AND(COUNTA($C$14:$C21)>=4,$D21=\"1/8 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$4*$C21)),IF(AND(COUNTA($C$14:$C21)<=4,$D21=\"1/8 inch Bulk COMAND\"),$BA$2*$BC$4*$C21)))))","v":""}]
[null,null,null,null,"",{"$f":"IF(OR($C22=\"\",$D22=\"\"),\"\",IF(AND(COUNTA($C$14:$C22)>=4,$D22=\"1/4 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$3*$C22)),IF(AND(COUNTA($C$14:$C22)<=4,$D22=\"1/4 inch Bulk COMAND\"),$BA$2*$BC$3*$C22,IF(AND(COUNTA($C$14:$C22)>=4,$D22=\"1/8 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$4*$C22)),IF(AND(COUNTA($C$14:$C22)<=4,$D22=\"1/8 inch Bulk COMAND\"),$BA$2*$BC$4*$C22)))))","v":""}]
[null,null,null,null,"",{"$f":"IF(OR($C23=\"\",$D23=\"\"),\"\",IF(AND(COUNTA($C$14:$C23)>=4,$D23=\"1/4 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$3*$C23)),IF(AND(COUNTA($C$14:$C23)<=4,$D23=\"1/4 inch Bulk COMAND\"),$BA$2*$BC$3*$C23,IF(AND(COUNTA($C$14:$C23)>=4,$D23=\"1/8 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$4*$C23)),IF(AND(COUNTA($C$14:$C23)<=4,$D23=\"1/8 inch Bulk COMAND\"),$BA$2*$BC$4*$C23)))))","v":""}]
[null,null,null,null,"",{"$f":"IF(OR($C24=\"\",$D24=\"\"),\"\",IF(AND(COUNTA($C$14:$C24)>=4,$D24=\"1/4 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$3*$C24)),IF(AND(COUNTA($C$14:$C24)<=4,$D24=\"1/4 inch Bulk COMAND\"),$BA$2*$BC$3*$C24,IF(AND(COUNTA($C$14:$C24)>=4,$D24=\"1/8 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$4*$C24)),IF(AND(COUNTA($C$14:$C24)<=4,$D24=\"1/8 inch Bulk COMAND\"),$BA$2*$BC$4*$C24)))))","v":""}]
[null,null,null,null,"",{"$f":"IF(OR($C25=\"\",$D25=\"\"),\"\",IF(AND(COUNTA($C$14:$C25)>=4,$D25=\"1/4 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$3*$C25)),IF(AND(COUNTA($C$14:$C25)<=4,$D25=\"1/4 inch Bulk COMAND\"),$BA$2*$BC$3*$C25,IF(AND(COUNTA($C$14:$C25)>=4,$D25=\"1/8 inch Bulk COMAND\"),-((($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2)-($BA$2*$BC$4*$C25)),IF(AND(COUNTA($C$14:$C25)<=4,$D25=\"1/8 inch Bulk COMAND\"),$BA$2*$BC$4*$C25)))))","v":""}]
[null,"Total :",{"$f":"IF(COUNTA($C$14:$C$25)=0,\"\",SUM($C$14:$C$25))","v":""},null,null,{"$f":"IF(COUNTBLANK($F$14:$F$25)=12,\"\",SUM($F$14:$F$25))","v":""}]
[null,null,null,null,"Your Savings:",{"$f":"IF(OR($F$26=\"\",$C$26<4),\"\",(($BC$3-$BB$3)*SUMIF($D$14:$D$25,\"1/4 inch Bulk COMAND\",$C$14:$C$25)*$BA$2)+(SUMIF($D$14:$D$25,\"1/8 inch Bulk COMAND\",$C$14:$C$25)*($BC$4-$BB$4)*$BA$2))","v":""}]
[]
[null,"Book Now Save Later Program",null,"1st Application  – Spring into Action"]
[null,"4 loads = 2 wall to wall COMAND Applications",null,"2nd Application  – Dial it in for season"]
[null,"Save $6 Yard on 1/4\" COMAND ",null,"Must receive at least 4 truckloads to qualify for discount."]
[null,"Save $7 Yard on 1/8\" COMAND",null,"Earned discount applied to last order"]