{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["DISTRIBUTOR PRICE SPECIFICATION","FAST PRESELECTION","CUSTOMER OFFER","CUSTOMER OFFER USD","Conversion rate"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":7,"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":"DISTRIBUTOR PRICE SPECIFICATION","index":0,"n_rows":117,"n_cols":6,"rows_kept":117,"cut":false,"hidden":false,"merged":[[40,14,43,14],[40,10,43,10],[40,11,43,11],[40,12,43,12],[40,13,43,13],[99,3,100,3],[101,3,102,3],[33,2,36,2],[83,0,83,5],[37,1,40,1],[6,0,6,5],[49,1,52,1],[49,2,52,2],[49,3,52,3],[49,4,52,4],[113,2,113,4],[93,0,93,5],[101,2,102,2],[49,5,52,5],[2,0,2,5],[20,0,20,5],[32,0,32,5],[3,0,3,5],[69,0,69,5],[76,0,76,5],[27,0,27,5],[14,3,15,3],[14,4,15,4],[14,5,15,5],[41,1,44,1],[59,0,59,5],[116,2,116,4],[33,4,36,4],[41,4,44,4],[33,5,36,5],[99,2,100,2],[112,2,112,4],[37,4,40,4],[111,2,111,4],[60,0,60,5],[99,5,100,5],[101,5,102,5],[37,3,40,3],[114,2,114,4],[115,2,115,4],[41,3,44,3],[33,3,36,3],[0,0,0,3],[41,5,44,5],[45,1,48,1],[41,2,44,2],[37,2,40,2],[45,2,48,2],[33,1,36,1],[45,3,48,3],[45,4,48,4],[45,5,48,5],[14,2,15,2],[16,5,17,5],[16,3,17,3],[16,4,17,4],[16,2,17,2],[37,5,40,5]]}
["xxxxxxxxxxxxxxxxx",null,null,null,null,{"$f":"MID(CELL(\"filename\"),FIND(\"[\",CELL(\"filename\"))+1,SUM(FIND({\"[\";\"]\"},CELL(\"filename\"))*{-1;1})-6)","v":"Phivas_DefPrixV02"}]
["No.","Description","EURO  \nex works ","Qtity","Total","Sales Comments"]
["Type of feature / option:  Std = Standard,    NA = Not available,    OR = On request,      \nSelection only possible in the GREY boxes"]
["xxxxxxxxxxxxxxxxx"]
["A2"," T-APPAREL-PRO",500,1,{"$f":"C5*D5","v":500},"Base"]
[" ","xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"]
["Feeding options :"]
[100,"PU infeed belts for cotton and no slippery garment\n(standard feature)","Std",0,null,"Standard\nPU = normal grip"]
[102,"Silicone infeed belts for tacky grip and for better handling of polyester and slippery garment\n(replace standard feature Nr. 100)",10,1,{"$f":"C9*D9","v":10},"High grip for Polyester"]
[200,"Continus runing infeed conveyor.\n(standard feature) ","Std",1,null,"Singlet and very short sleeves"]
[201,"Removing - Automatic infeed belts start with sensor and adjustable delay ",-10,0,{"$f":"C11*D11","v":0},"Higher feeding speed"]
[202,"Removing - Push button/adjustable delay to start infeed belts ",-10,0,{"$f":"C12*D12","v":0},"Sensitif to feed garment"]
[203,"Removing - Reject push button at right feeding ",-10,0,{"$f":"C13*D13","v":0},"manual reject by operator"]
[520,"Folding and stacking based on size measuring sensor of individual garment length. (standard feature) ","Std",1,null,"random feeding of different sizes"]
[521,"Sorting with 4 photocells at feeding (when different garment have same length and feature Nr. 520 cannot be used) (note: note compatible with features 300, 522)",10,1,{"$f":"C15*D15","v":10},"Manual channel selection when different sizes have same length. \n\nCannot be installed together with option 522"]
[]
[522,"Direct adressing of stackers by 3 vertical photocells at feeding (not compatible with features 300, 521)",10,0,{"$f":"C17*D17","v":0},"Cannot be installed together with option 521"]
[]
[528,"2nd stop function at feeding to correct or readjust rear of long garments ",10,1,{"$f":"C19*D19","v":10},"Long garments"]
[]
["Lateral fold options :"]
[101,"1 single PU belt in lateral fold instead of dual PU belts - Useful when only white, no-polyester  garment hangling\n(remplace standard feature 103)",-10,0,{"$f":"C22*D22","v":0},"One wide belt only"]
[103,"Dual PU Belts and reflective sensor in Lateral instead of single PU belts.\n(standard feature) ","Std",0,null,"Standard\nPU = normal grip"]
[104,"Dual High grip silicone belts in lateral fold section and reflective sensor for all type of garment handling included slippery and color garment. \n(replace standard feature 13)",10,1,{"$f":"C24*D24","v":10},"Silicone = high grip"]
[105,"Removing - High/low pressure in lateral fold for fine tuning of sensitive or heavy/stiff garment like hoddies",-10,0,{"$f":"C25*D25","v":0},"Air pulses fine tuning"]
[109,"1/6 width reduction of extra wide garment",-10,0,{"$f":"C26*D26","v":0},"NA"]
[110,"Removing - Lateral adjustable deflector for thin/thick/stiff material like 100% polyester to hoddies",-10,0,{"$f":"C27*D27","v":0},"for Hoodies"]
["Cross fold options :"]
[106,"Removing - 1st Crossfold gap auto positionning via setup in recipes   ",-10,0,{"$f":"C29*D29","v":0},"adapt to material thickness"]
[107,"Removing - 2nd crossfold swingarm automatic opening for thick item folding",-10,0,{"$f":"C30*D30","v":0},"For Hoodies"]
[108,"Removing - of 2nd crossfold swingarm forcing in upper position via touchscreen panel ",-10,0,{"$f":"C31*D31","v":0},"Polyester"]
[109,"Automatic reject of unexpected wide items","Std",0,null,"Standard"]
["Stacking options:"]
[410,"Drop stacker 1 x 1\ninstead of stacker (412)",-10,0,{"$f":"D34*C34","v":0},"1 drop stacker\nIn replacement of 412"]
[]
[]
[]
[411,"Drop stacker 2 x 1\ninstead of stacker (412)",-10,0,{"$f":"D38*C38","v":0},"2 drop stackers\nIn replacement of 412"]
[]
[]
[]
[412,"Drop stacker 3 x1\nStandard selection","Std",1,null,"Standard\n3 drop stackers"]
[]
[]
[]
[413,"Drop stacker 4 x1\ninstead of stacker (412)","NA",0,null,"4 drop stackers\nIn replacement of 412"]
[]
[]
[]
[401,"Drop stacker 0 x 1\ninstead of stacker (412)",-10,1,{"$f":"D50*C50","v":-10},"Inline exit with 1.5m/5ft delivery belt\n"]
[]
[]
[]
[420,"One Lift stacker instead of one drop stacker (option 410 or 411 or 412 must be selected) handle small items or underwear or sensitive to stack items  ",10,0,{"$f":"C54*D54","v":0},"Only one lift stacker per machine not compatible with 401"]
[430,"Removing - Delivery belt for side or inline delivery with 1.5 meter/5ft accumulator ",-10,0,{"$f":"C55*D55","v":0},"No delivery belt"]
[431,"Extended delivery belt for side or inline delivery with 3 meters/10ft accumulator instead of 5ft",10,0,{"$f":"C56*D56","v":0},"in replacement of 430 or 401"]
[440,"3 meters/10ft accumulator with control box.\n(to install after delivery belt)",10,0,{"$f":"C57*D57","v":0},"Buffer after delivery belt"]
[450,"Sensor at delivery belt end. \n(stop feeding when delivery belt full)",10,0,null,"Stop the infeed when belt is full"]
[null,"Roller conveyor\n(simple roll accumulator)",10,0,{"$f":"D59*C59","v":0},"Per 3 meters/10ft"]
[]
["Panels & communication:"]
[500,"10 recipes instead of 50\n(in replacement of standard configuration 505)",-10,0,{"$f":"C62*D62","v":0},"Reduced recipes"]
[505,"50 recipes\n(standard configuration) ","Std",1,0,"Standard"]
[508,"120 recipes instead of 50\n(in replacement of standard configuration 505) ",10,0,0,"Extended recipes"]
[510,"Removing - of Productivity lights",-10,0,0,"Operator feedbacl of real productivity"]
[530,"Backup via USB connector + battery (hold memory when machine is power off)","Std",1,null,"backup of recipes"]
[531,"Master/slave of 2 machines with one common delivery belt",10,0,0,"snychronisation of 2 machines"]
[532,"Ethernet interface for datas collection",10,0,0,"For production datas transfer"]
[]
["Labeler and stiffener:"]
[300,"Size labeler integrated in feeding (preprinted label)",10,0,{"$f":"C71*D71","v":0},"Insertion of size label during folding"]
[320,"external labeler (preprinted label)",10,0,{"$f":"C72*D72","v":0},"Insertion of sticker after folding"]
[321,"Support for external labeler",10,0,{"$f":"C73*D73","v":0},"for 320"]
[322,"3 meter conveyor for external labeler (320)",10,0,{"$f":"C74*D74","v":0},"for 320"]
[350,"Stiffener inserter integrated in lateral fold",10,0,{"$f":"C75*D75","v":0},"Insertion of stiffener inside the fold"]
[]
["Bagging solution:"]
[600,"Automatic L-Sealer LS56 with 40 recipes",10,0,{"$f":"C78*D78","v":0},"full automatic L-sealer"]
[609,"Gap closing conveyor",10,0,null,"for polyester"]
[610,"Punch hole for LS56",10,0,{"$f":"C80*D80","v":0},"remove air in the bag"]
[630,"Semi-automatic L-Sealer",10,0,{"$f":"C81*D81","v":0}]
[720,"Sapre part kit for LS56",10,0,{"$f":"C82*D82","v":0},"for 600"]
[]
["General:"]
[null,null,null,null,{"$f":"C85*D85","v":0}]
[900,"Voltage: 3 x 200/240 V + PE, 50/60 Hz, +/- 5 %","Std",1]
[905,"Voltage: 3 x 400 V + PE, 50/60 Hz, +/- 5 %","Std",0]
[910,null,10,0,{"$f":"C88*D88","v":0},"On request"]
[915,null,15,0,{"$f":"C89*D89","v":0},"On request"]
[]
[null,"Spare parts kit small for T-Apparel",5,0,{"$f":"C91*D91","v":0}]
[null,"Spare parts kit large for T-Apparel",10,0,{"$f":"C92*D92","v":0}]
[]
["Installation & setup"]
[980,"Service Engineer - working day",80,0,{"$f":"C95*D95","v":0}]
[981,"Service Engineer - travel time (hour)",82,0,{"$f":"C96*D96","v":0}]
[982,"Air Ticket",83,0,{"$f":"C97*D97","v":0}]
[983,null,0,0,{"$f":"C98*D98","v":0}]
[]
[990,"Rear delivery as well as side delivery",10,1,{"$f":"C100*D100","v":10}]
[null,"Extra (1)",null,null,{"$f":"C101*D101","v":0}]
[991,null,10,0,{"$f":"C102*D102","v":0}]
[null,"Extra (2)",null,null,{"$f":"C103*D103","v":0}]
[null,"Total List price in EUROS",null,null,{"$f":"SUM(E5:E103)","v":540}]
[null,"Discount [%]",null,10,{"$f":"E104*D105/100","v":54}]
[null,"Crating in closed wood box (air or truck)",100,0,{"$f":"C106*D106","v":0}]
[null,"Pallet for 20\" container (Up to 2 machines/pallet)",150,0,{"$f":"C107*D107","v":0}]
[null,"Shipping cost",500,0,{"$f":"C108*D108","v":0},"CFR"]
[null,"Total in EURO, ex works Belgium/Holland",null,"Euros",{"$f":"E104-E105+E106+E107+E108","v":486}]
[null,"Total in USD, (exch. rate automatically actualised)",null,"USD",{"$f":"E109*'Conversion rate'!#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Distributor"]
[null,"Customer"]
[null,"Customer Address"]
[null,"Customer Order number"]
[null,"Delivery date (dd.mm.yy)"]
[null,"Order date (dd.mm.yy)"]

{"sheet":"FAST PRESELECTION","index":1,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Fast preselection"]
[1,"Only 100% white cotton","100,101,102,103,104,105,110,","Description 1"]
[2,"Colored and black 100% cotton ","990,983,915,","Description 2"]
[3,"Mixed material from 100% cotton and 50% polyester",0,"Description 3"]
[4,"Mixed material from 100% cotton to 100% poliester",0,"Description 4"]
[5,"Singlet",0,"Description 5"]
[6,"T-shirt short sleeves",0,"Description 6"]
[7,"T-shirt half and long sleeves",0,"Description 7"]
[8,"Undershirt",0,"Description 8"]
[9,"Dry-fit polo-shirt",0,"Description 9"]
[10,"Dry-fit long sleeves",0,"Description 10"]
[11,"Sweeter",0,"Description 11"]
[12,"hoody lite",0,"Description 12"]
[13,"Hoody heavy",0,"Description 13"]
[14,"Pant",0,"Description 14"]
[15,"Jeans",0,"Description 15"]
[16,"Uniform",0,"Description 16"]
[17,"Dress",0,"Description 17"]
[18,"Preselection 18",0,"Description 18"]
[19,"Preselection 19",0,"Description 19"]

{"sheet":"CUSTOMER OFFER","index":2,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[44,0,44,4],[0,3,1,4],[2,3,3,4],[9,0,10,4],[13,0,16,4],[39,0,39,4],[40,0,40,4],[41,0,41,4],[42,0,42,4],[43,0,43,4]]}
[null,"Company name","TEST","OFFER"]
[null,"Attn."]
[null,"Street address",null,{"$f":"'CUSTOMER OFFER'!A14:E17","v":{"$error":"#VALUE!"}}]
[null,"Zip"]
[null,"City"]
[null,"Country"]
[null,"Email"]
[null,"Tel"]
[]
[]
[]
[]
["Note:"]
[" "]
[]
[]
[]
["Pos","Nr.","Description","Qty","Sum"]
[1,"No.","Description","Qtity","Total"]
[2,"A2"," T-APPAREL-PRO",1,500]
[3,102,"Silicone infeed belts for tacky grip and for better handling of polyester and slippery garment\n(replace standard feature Nr. 100)",1,10]
[4,200,"Continus runing infeed conveyor.\n(standard feature) ",1]
[5,520,"Folding and stacking based on size measuring sensor of individual garment length. (standard feature) ",1]
[6,521,"Sorting with 4 photocells at feeding (when different garment have same length and feature Nr. 520 cannot be used) (note: note compatible with features 300, 522)",1,10]
[7,528,"2nd stop function at feeding to correct or readjust rear of long garments ",1,10]
[8,104,"Dual High grip silicone belts in lateral fold section and reflective sensor for all type of garment handling included slippery and color garment. \n(replace standard feature 13)",1,10]
[9,412,"Drop stacker 3 x1\nStandard selection",1]
[10,401,"Drop stacker 0 x 1\ninstead of stacker (412)",1,-10]
[11,505,"50 recipes\n(standard configuration) ",1,0]
[12,530,"Backup via USB connector + battery (hold memory when machine is power off)",1]
[13,900,"Voltage: 3 x 200/240 V + PE, 50/60 Hz, +/- 5 %",1]
[14,990,"Rear delivery as well as side delivery",1,10]
[null,null,null,"Sum in EUROS",{"$f":"SUM(E19:E32)","v":540},{"$f":"SUM(F19:F29)","v":0}]
[null,null,"Discount",0.1,{"$f":"-(E33*D34)","v":-54}]
[null,null,null,"Number of units",1]
[null,null,null,"Packing cost in EUROS",0]
[null,null,null,"Transport cost in EUROS",0]
[null,null,null,"TOTAL to pay in EUROS  ",{"$f":"(E33+E34)*E35+E36+E37","v":486}]
[null,null,null,"TOTAL to pay in USD  ",{"$f":"E38*'Conversion rate'!G3","v":540.66139199999998}]
["Tax:\n\n"]
["Warranty\n\n"]
["Terms of payment\n\n"]
["Validity\n"]
["Factory Installation and setup\n\n"]

{"sheet":"CUSTOMER OFFER USD","index":3,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[[40,0,40,4],[41,0,41,4],[42,0,42,4],[43,0,43,4],[0,3,1,4],[2,3,3,4],[9,0,10,4],[13,0,16,4],[38,0,38,4],[39,0,39,4]]}
[null,"Company name","TEST","OFFER"]
[null,"Attn."]
[null,"Street address",null,{"$f":"LEFT(nomfic,FIND(\"_\",nomfic)-1)","v":"Phivas"}]
[null,"Zip"]
[null,"City"]
[null,"Country"]
[null,"Email"]
[null,"Tel"]
[]
[]
[]
[]
["Note:"]
[]
[]
[]
[]
["Pos","Nr.","Description","Qty","Sum"]
[1,"A2"," T-APPAREL-PRO",1,556.23599999999999]
[2,102,"Silicone infeed belts for tacky grip and for better handling of polyester and slippery garment\n(replace standard feature Nr. 100)",1,11.12472]
[3,200,"Continus runing infeed conveyor.\n(standard feature) ",1]
[4,520,"Folding and stacking based on size measuring sensor of individual garment length. (standard feature) ",1]
[5,521,"Sorting with 4 photocells at feeding (when different garment have same length and feature Nr. 520 cannot be used) (note: note compatible with features 300, 522)",1,11.12472]
[6,528,"2nd stop function at feeding to correct or readjust rear of long garments ",1,11.12472]
[7,104,"Dual High grip silicone belts in lateral fold section and reflective sensor for all type of garment handling included slippery and color garment. \n(replace standard feature 13)",1,11.12472]
[8,412,"Drop stacker 3 x1\nStandard selection",1]
[9,401,"Drop stacker 0 x 1\ninstead of stacker (412)",1,-11.12472]
[10,505,"50 recipes\n(standard configuration) ",1,0]
[11,530,"Backup via USB connector + battery (hold memory when machine is power off)",1]
[12,900,"Voltage: 3 x 200/240 V + PE, 50/60 Hz, +/- 5 %",1]
[13,990,"Rear delivery as well as side delivery",1,11.12472]
[null,null,null,"Sum in EUROS",{"$f":"SUM(E19:E31)","v":600.73488000000009},{"$f":"SUM(F19:F31)","v":0}]
[null,null,"Discount",0.1,{"$f":"-(E32*D33)","v":-60.073488000000012}]
[null,null,null,"Number of units",1]
[null,null,null,"Packing cost in USD",0]
[null,null,null,"Transport cost in USD",0]
[null,null,null,"TOTAL to pay in USD  ",{"$f":"(E32+E33)*E34+E35+E36","v":540.66139200000009}]
[]
["Tax:\n"]
["Warranty\n\n"]
["Terms of payment\n\n"]
["Validity\n\n"]
["Factory Installation and setup\n\n"]

{"sheet":"Conversion rate","index":4,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"EU/USD"]
[null,"Euro","1.00 EUR","inv. 1.00 EUR",null,null,1.1124719999999999]
[null,"US Dollar",1112472,"0.898899"]
[null,"British Pound","0.881403",1134555,null,null,"Convertion rate is automatically actualised every 60 minutes"]
[null,"Indian Rupee",71869177,"0.013914"]
[null,"Australian Dollar",1467667,"0.681354"]
[null,"Canadian Dollar",1474531,"0.678182"]
[null,"Singapore Dollar",1546122,"0.646779"]
[null,"Swiss Franc",1085514,"0.921223"]
[null,"Malaysian Ringgit",4766203,"0.209811"]
[null,"Japanese Yen",124033940,"0.008062"]
[null,"Chinese Yuan Renminbi",7597069,"0.131630"]