{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SOS BAT","Numéro"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":"SOS BAT","index":0,"n_rows":78,"n_cols":7,"rows_kept":78,"cut":false,"hidden":false,"merged":[[70,2,70,4],[69,2,69,4],[58,2,58,4],[59,2,59,4],[60,2,60,4],[61,2,61,4],[64,2,64,4],[65,2,65,4],[66,2,66,4],[68,2,68,4],[63,2,63,4],[56,2,56,4],[67,2,67,4],[38,2,38,4],[40,2,40,4],[39,2,39,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[48,2,48,4],[49,2,49,4],[50,2,50,4],[51,2,51,4],[53,2,53,4],[54,2,54,4],[8,0,8,2],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[13,5,13,6],[37,2,37,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[34,2,34,4],[35,2,35,4],[26,2,26,4],[27,2,27,4],[0,5,0,6],[83,0,83,6],[75,5,76,5],[80,0,80,6],[23,2,23,4],[24,2,24,4],[25,2,25,4],[28,2,28,4],[32,2,32,4],[10,5,10,6],[12,5,12,6],[22,2,22,4],[30,2,30,4],[31,2,31,4],[72,0,72,2],[76,0,76,2],[77,0,77,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[36,2,36,4],[33,2,33,4],[29,2,29,4],[41,2,41,4],[55,2,55,4],[62,2,62,4],[57,2,57,4],[52,2,52,4],[47,2,47,4]]}
[null,null,null,null,null,"FACTURE"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(F1<>\"\",UPPER(LEFT(F1,1))&LOWER(MID(F1,2,100))&\" N°\")","v":"Facture N°"},"001"]
["Client",null,null,null,null,"2013-10-27"]
[]
[{"$f":"IF(A12=0,\"\",VLOOKUP(A12,DonnéeClient,2,FALSE))","v":""},null,null,null,null,"Chantier"]
[{"$f":"IF(A12=0,\"\",VLOOKUP(A12,DonnéeClient,3,FALSE))","v":""}]
[{"$f":"IF(A12=0,\"\",VLOOKUP(A12,DonnéeClient,4,FALSE))","v":""}]
[{"$f":"IF(A12=0,\"\",VLOOKUP(A12,DonnéeClient,5,FALSE))","v":""}]
[]
[]
[]
["Quantité","Unité","Désignation",null,null,"P.U. T.H.","Total H.T."]
[1,"hre(s)","Exemple 01",null,null,2,{"$f":"IF(A21*F21=0,\"\",A21*F21)","v":2}]
[2,"hre(s)","Exemple 02",null,null,2,{"$f":"IF(A22*F22=0,\"\",A22*F22)","v":4}]
[3,"hre(s)","Exemple 03",null,null,2,{"$f":"IF(A23*F23=0,\"\",A23*F23)","v":6}]
[4,"hre(s)","Exemple 04",null,null,2,8]
[5,"hre(s)","Exemple 05",null,null,2,10]
[6,"hre(s)","Exemple 06",null,null,2,12]
[7,"hre(s)","Exemple 07",null,null,2,14]
[8,"hre(s)","Exemple 08",null,null,2,16]
[9,"hre(s)","Exemple 09",null,null,2,18]
[10,"hre(s)","Exemple 10",null,null,2,20]
[11,"hre(s)","Exemple 11",null,null,2,22]
[12,"hre(s)","Exemple 12",null,null,2,24]
[13,"hre(s)","Exemple 13",null,null,2,26]
[14,"hre(s)","Exemple 14",null,null,2,{"$f":"IF(A34*F34=0,\"\",A34*F34)","v":28}]
[15,"hre(s)","Exemple 15",null,null,2,30]
[16,"hre(s)","Exemple 16",null,null,2,32]
[17,"hre(s)","Exemple 17",null,null,2,34]
[18,"hre(s)","Exemple 18",null,null,2,36]
[19,"hre(s)","Exemple 19",null,null,2,38]
[20,"hre(s)","Exemple 20",null,null,2,40]
[21,"hre(s)","Exemple 21",null,null,2,42]
[22,"hre(s)","Exemple 22",null,null,2,44]
[23,"hre(s)","Exemple 23",null,null,2,46]
[24,"hre(s)","Exemple 24",null,null,2,48]
[25,"hre(s)","Exemple 25",null,null,2,50]
[26,"hre(s)","Exemple 26",null,null,2,52]
[27,"hre(s)","Exemple 27",null,null,2,54]
[28,"hre(s)","Exemple 28",null,null,3,{"$f":"IF(A48*F48=0,\"\",A48*F48)","v":84}]
[29,"hre(s)","Exemple 29",null,null,4,116]
[30,"hre(s)","Exemple 30",null,null,5,150]
[31,"hre(s)","Exemple 31",null,null,6,186]
[32,"hre(s)","Exemple 32",null,null,7,224]
[33,"hre(s)","Exemple 33",null,null,8,264]
[34,"hre(s)","Exemple 34",null,null,9,306]
[35,"hre(s)","Exemple 35",null,null,10,350]
[36,"hre(s)","Exemple 36",null,null,11,396]
[37,"hre(s)","Exemple 37",null,null,12,444]
[38,"hre(s)","Exemple 38",null,null,13,494]
[39,"hre(s)","Exemple 39",null,null,14,546]
[40,"hre(s)","Exemple 40",null,null,15,600]
[41,"hre(s)","Exemple 41",null,null,16,656]
[42,"hre(s)","Exemple 42",null,null,17,714]
[43,"hre(s)","Exemple 43",null,null,18,774]
[44,"hre(s)","Exemple 44",null,null,19,836]
[45,"hre(s)","Exemple 45",null,null,20,900]
[46,"hre(s)","Exemple 46",null,null,21,966]
[47,"hre(s)","Exemple 47",null,null,22,1034]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,"Total H.T.",{"$f":"SUM(G$21:G71)","v":10796}]
["Analyse T.V.A",null,null,null,null,"T.V.A. 19.6 %",{"$f":"BoutonAjouterSupprimerLigneTotalH.T.*19.6/100","v":2116.0160000000001}]
["Base","Taux","T.V.A.",null,null,"Total T.T.C.",{"$f":"BoutonAjouterSupprimerLigneTotalH.T.+G73","v":12912.016}]
[{"$f":"G72","v":10796},19.600000000000001,{"$f":"A75*B75/100","v":2116.0160000000001},null,null,"Réserve de 20 %",{"$f":"G74*(RIGHT(F75,(LEN(F75)-10)))","v":2582.4032000000002}]
[null,null,null,null,null,"TOTAL T.T.C.           Soit en francs",{"$f":"G74-G75","v":10329.612799999999}]
["Mode de Règlement",null,null,null,null,null,{"$f":"G76*6.55957","v":67757.818234495993}]
["Chèque"]

{"sheet":"Numéro","index":1,"n_rows":1000,"n_cols":1,"rows_kept":1000,"cut":false,"hidden":true,"merged":[]}
["001"]
["002"]
["003"]
["004"]
["005"]
["006"]
["007"]
["008"]
["009"]
["010"]
["011"]
["012"]
["013"]
["014"]
["015"]
["016"]
["017"]
["018"]
["019"]
["020"]
["021"]
["022"]
["023"]
["024"]
["025"]
["026"]
["027"]
["028"]
["029"]
["030"]
["031"]
["032"]
["033"]
["034"]
["035"]
["036"]
["037"]
["038"]
["039"]
["040"]
["041"]
["042"]
["043"]
["044"]
["045"]
["046"]
["047"]
["048"]
["049"]
["050"]
["051"]
["052"]
["053"]
["054"]
["055"]
["056"]
["057"]
["058"]
["059"]
["060"]
["061"]
["062"]
["063"]
["064"]
["065"]
["066"]
["067"]
["068"]
["069"]
["070"]
["071"]
["072"]
["073"]
["074"]
["075"]
["076"]
["077"]
["078"]
["079"]
["080"]
["081"]
["082"]
["083"]
["084"]
["085"]
["086"]
["087"]
["088"]
["089"]
["090"]
["091"]
["092"]
["093"]
["094"]
["095"]
["096"]
["097"]
["098"]
["099"]
["100"]
["101"]
["102"]
["103"]
["104"]
["105"]
["106"]
["107"]
["108"]
["109"]
["110"]
["111"]
["112"]
["113"]
["114"]
["115"]
["116"]
["117"]
["118"]
["119"]
["120"]
["121"]
["122"]
["123"]
["124"]
["125"]
["126"]
["127"]
["128"]
["129"]
["130"]
["131"]
["132"]
["133"]
["134"]
["135"]
["136"]
["137"]
["138"]
["139"]
["140"]
["141"]
["142"]
["143"]
["144"]
["145"]
["146"]
["147"]
["148"]
["149"]
["150"]
["151"]
["152"]
["153"]
["154"]
["155"]
["156"]
["157"]
["158"]
["159"]
["160"]
["161"]
["162"]
["163"]
["164"]
["165"]
["166"]
["167"]
["168"]
["169"]
["170"]
["171"]
["172"]
["173"]
["174"]
["175"]
["176"]
["177"]
["178"]
["179"]
["180"]
["181"]
["182"]
["183"]
["184"]
["185"]
["186"]
["187"]
["188"]
["189"]
["190"]
["191"]
["192"]
["193"]
["194"]
["195"]
["196"]
["197"]
["198"]
["199"]
["200"]
["201"]
["202"]
["203"]
["204"]
["205"]
["206"]
["207"]
["208"]
["209"]
["210"]
["211"]
["212"]
["213"]
["214"]
["215"]
["216"]
["217"]
["218"]
["219"]
["220"]
["221"]
["222"]
["223"]
["224"]
["225"]
["226"]
["227"]
["228"]
["229"]
["230"]
["231"]
["232"]
["233"]
["234"]
["235"]
["236"]
["237"]
["238"]
["239"]
["240"]
["241"]
["242"]
["243"]
["244"]
["245"]
["246"]
["247"]
["248"]
["249"]
["250"]
["251"]
["252"]
["253"]
["254"]
["255"]
["256"]
["257"]
["258"]
["259"]
["260"]
["261"]
["262"]
["263"]
["264"]
["265"]
["266"]
["267"]
["268"]
["269"]
["270"]
["271"]
["272"]
["273"]
["274"]
["275"]
["276"]
["277"]
["278"]
["279"]
["280"]
["281"]
["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"]
["311"]
["312"]
["313"]
["314"]
["315"]
["316"]
["317"]
["318"]
["319"]
["320"]
["321"]
["322"]
["323"]
["324"]
["325"]
["326"]
["327"]
["328"]
["329"]
["330"]
["331"]
["332"]
["333"]
["334"]
["335"]
["336"]
["337"]
["338"]
["339"]
["340"]
["341"]
["342"]
["343"]
["344"]
["345"]
["346"]
["347"]
["348"]
["349"]
["350"]
["351"]
["352"]
["353"]
["354"]
["355"]
["356"]
["357"]
["358"]
["359"]
["360"]
["361"]
["362"]
["363"]
["364"]
["365"]
["366"]
["367"]
["368"]
["369"]
["370"]
["371"]
["372"]
["373"]
["374"]
["375"]
["376"]
["377"]
["378"]
["379"]
["380"]
["381"]
["382"]
["383"]
["384"]
["385"]
["386"]
["387"]
["388"]
["389"]
["390"]
["391"]
["392"]
["393"]
["394"]
["395"]
["396"]
["397"]
["398"]
["399"]
["400"]
["401"]
["402"]
["403"]
["404"]
["405"]
["406"]
["407"]
["408"]
["409"]
["410"]
["411"]
["412"]
["413"]
["414"]
["415"]
["416"]
["417"]
["418"]
["419"]
["420"]
["421"]
["422"]
["423"]
["424"]
["425"]
["426"]
["427"]
["428"]
["429"]
["430"]
["431"]
["432"]
["433"]
["434"]
["435"]
["436"]
["437"]
["438"]
["439"]
["440"]
["441"]
["442"]
["443"]
["444"]
["445"]
["446"]
["447"]
["448"]
["449"]
["450"]
["451"]
["452"]
["453"]
["454"]
["455"]
["456"]
["457"]
["458"]
["459"]
["460"]
["461"]
["462"]
["463"]
["464"]
["465"]
["466"]
["467"]
["468"]
["469"]
["470"]
["471"]
["472"]
["473"]
["474"]
["475"]
["476"]
["477"]
["478"]
["479"]
["480"]
["481"]
["482"]
["483"]
["484"]
["485"]
["486"]
["487"]
["488"]
["489"]
["490"]
["491"]
["492"]
["493"]
["494"]
["495"]
["496"]
["497"]
["498"]
["499"]
["500"]
["501"]
["502"]
["503"]
["504"]
["505"]
["506"]
["507"]
["508"]
["509"]
["510"]
["511"]
["512"]
["513"]
["514"]
["515"]
["516"]
["517"]
["518"]
["519"]
["520"]
["521"]
["522"]
["523"]
["524"]
["525"]
["526"]
["527"]
["528"]
["529"]
["530"]
["531"]
["532"]
["533"]
["534"]
["535"]
["536"]
["537"]
["538"]
["539"]
["540"]
["541"]
["542"]
["543"]
["544"]
["545"]
["546"]
["547"]
["548"]
["549"]
["550"]
["551"]
["552"]
["553"]
["554"]
["555"]
["556"]
["557"]
["558"]
["559"]
["560"]
["561"]
["562"]
["563"]
["564"]
["565"]
["566"]
["567"]
["568"]
["569"]
["570"]
["571"]
["572"]
["573"]
["574"]
["575"]
["576"]
["577"]
["578"]
["579"]
["580"]
["581"]
["582"]
["583"]
["584"]
["585"]
["586"]
["587"]
["588"]
["589"]
["590"]
["591"]
["592"]
["593"]
["594"]
["595"]
["596"]
["597"]
["598"]
["599"]
["600"]
["601"]
["602"]
["603"]
["604"]
["605"]
["606"]
["607"]
["608"]
["609"]
["610"]
["611"]
["612"]
["613"]
["614"]
["615"]
["616"]
["617"]
["618"]
["619"]
["620"]
["621"]
["622"]
["623"]
["624"]
["625"]
["626"]
["627"]
["628"]
["629"]
["630"]
["631"]
["632"]
["633"]
["634"]
["635"]
["636"]
["637"]
["638"]
["639"]
["640"]
["641"]
["642"]
["643"]
["644"]
["645"]
["646"]
["647"]
["648"]
["649"]
["650"]
["651"]
["652"]
["653"]
["654"]
["655"]
["656"]
["657"]
["658"]
["659"]
["660"]
["661"]
["662"]
["663"]
["664"]
["665"]
["666"]
["667"]
["668"]
["669"]
["670"]
["671"]
["672"]
["673"]
["674"]
["675"]
["676"]
["677"]
["678"]
["679"]
["680"]
["681"]
["682"]
["683"]
["684"]
["685"]
["686"]
["687"]
["688"]
["689"]
["690"]
["691"]
["692"]
["693"]
["694"]
["695"]
["696"]
["697"]
["698"]
["699"]
["700"]
["701"]
["702"]
["703"]
["704"]
["705"]
["706"]
["707"]
["708"]
["709"]
["710"]
["711"]
["712"]
["713"]
["714"]
["715"]
["716"]
["717"]
["718"]
["719"]
["720"]
["721"]
["722"]
["723"]
["724"]
["725"]
["726"]
["727"]
["728"]
["729"]
["730"]
["731"]
["732"]
["733"]
["734"]
["735"]
["736"]
["737"]
["738"]
["739"]
["740"]
["741"]
["742"]
["743"]
["744"]
["745"]
["746"]
["747"]
["748"]
["749"]
["750"]
["751"]
["752"]
["753"]
["754"]
["755"]
["756"]
["757"]
["758"]
["759"]
["760"]
["761"]
["762"]
["763"]
["764"]
["765"]
["766"]
["767"]
["768"]
["769"]
["770"]
["771"]
["772"]
["773"]
["774"]
["775"]
["776"]
["777"]
["778"]
["779"]
["780"]
["781"]
["782"]
["783"]
["784"]
["785"]
["786"]
["787"]
["788"]
["789"]
["790"]
["791"]
["792"]
["793"]
["794"]
["795"]
["796"]
["797"]
["798"]
["799"]
["800"]
["801"]
["802"]
["803"]
["804"]
["805"]
["806"]
["807"]
["808"]
["809"]
["810"]
["811"]
["812"]
["813"]
["814"]
["815"]
["816"]
["817"]
["818"]
["819"]
["820"]
["821"]
["822"]
["823"]
["824"]
["825"]
["826"]
["827"]
["828"]
["829"]
["830"]
["831"]
["832"]
["833"]
["834"]
["835"]
["836"]
["837"]
["838"]
["839"]
["840"]
["841"]
["842"]
["843"]
["844"]
["845"]
["846"]
["847"]
["848"]
["849"]
["850"]
["851"]
["852"]
["853"]
["854"]
["855"]
["856"]
["857"]
["858"]
["859"]
["860"]
["861"]
["862"]
["863"]
["864"]
["865"]
["866"]
["867"]
["868"]
["869"]
["870"]
["871"]
["872"]
["873"]
["874"]
["875"]
["876"]
["877"]
["878"]
["879"]
["880"]
["881"]
["882"]
["883"]
["884"]
["885"]
["886"]
["887"]
["888"]
["889"]
["890"]
["891"]
["892"]
["893"]
["894"]
["895"]
["896"]
["897"]
["898"]
["899"]
["900"]
["901"]
["902"]
["903"]
["904"]
["905"]
["906"]
["907"]
["908"]
["909"]
["910"]
["911"]
["912"]
["913"]
["914"]
["915"]
["916"]
["917"]
["918"]
["919"]
["920"]
["921"]
["922"]
["923"]
["924"]
["925"]
["926"]
["927"]
["928"]
["929"]
["930"]
["931"]
["932"]
["933"]
["934"]
["935"]
["936"]
["937"]
["938"]
["939"]
["940"]
["941"]
["942"]
["943"]
["944"]
["945"]
["946"]
["947"]
["948"]
["949"]
["950"]
["951"]
["952"]
["953"]
["954"]
["955"]
["956"]
["957"]
["958"]
["959"]
["960"]
["961"]
["962"]
["963"]
["964"]
["965"]
["966"]
["967"]
["968"]
["969"]
["970"]
["971"]
["972"]
["973"]
["974"]
["975"]
["976"]
["977"]
["978"]
["979"]
["980"]
["981"]
["982"]
["983"]
["984"]
["985"]
["986"]
["987"]
["988"]
["989"]
["990"]
["991"]
["992"]
["993"]
["994"]
["995"]
["996"]
["997"]
["998"]
["999"]
["1000"]