{"text_format":"5","workbook":"xls","n_sheets":10,"sheets":["MENU","Export","Fiche-A","Fiche-B","Fiche-D","Fiche-E","Mvt-JANV","Mvt-FEV","Mvt-MAR","Fiche-C"],"props":{"creator":"Philippe Tulliez","last_modified_by":"Philippe Tulliez"},"defined_names":["dbTest","dbTest_Label","pTypeTest","znTest"],"not_rendered":{"images":1,"macros":1,"external_links":1,"defined_names":4},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"MENU","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[0,0,0,5],[3,5,4,5]],"flags":["formulas_cached_only"]}
["Classeur de démonstration de la procédure ExportTable version 1.1"]
[]
[]
[{"$nulls":5},"6 Procédure 6"]
[]
[{"$nulls":5},"1-Cliquer sur le bouton pour lancer la boîte de dialogue de sélection"]
[{"$nulls":5},"2-Sélectionner les feuilles à exporter"]
[{"$nulls":5},"3-Cliquer sur OK"]
{"$rows_empty":10}
[null,"© Philippe Tulliez"]

{"sheet":"Export","index":1,"n_rows":39,"n_cols":5,"rows_kept":39,"flags":["formulas_cached_only"]}
["Date","REF","Qté","Prix","Valeur"]
["2013-01-07","R008",7,163,{"v":1141,"d":"1,141"}]
["2013-01-17","R002",13,140,{"v":1820,"d":"1,820"}]
["2013-01-17","R008",4,125,500]
["2013-01-19","R005",7,226,{"v":1582,"d":"1,582"}]
["2013-01-19","R008",10,207,{"v":2070,"d":"2,070"}]
["2013-01-21","R002",7,84,588]
["2013-01-21","R004",15,240,{"v":3600,"d":"3,600"}]
["2013-01-27","R001",4,118,472]
["2013-02-05","R003",14,204,{"v":2856,"d":"2,856"}]
["2013-02-10","R008",8,250,{"v":2000,"d":"2,000"}]
["2013-02-13","R007",2,232,464]
["2013-02-17","R007",2,63,126]
["2013-02-18","R004",6,130,780]
["2013-02-18","R003",13,80,{"v":1040,"d":"1,040"}]
["2013-02-19","R003",5,137,685]
["2013-02-19","R001",13,120,{"v":1560,"d":"1,560"}]
["2013-02-20","R004",13,186,{"v":2418,"d":"2,418"}]
["2013-02-21","R003",1,50,50]
["2013-02-25","R007",10,205,{"v":2050,"d":"2,050"}]
["2013-02-26","R008",1,226,226]
["2013-02-27","R006",9,181,{"v":1629,"d":"1,629"}]
["2013-03-09","R002",12,112,{"v":1344,"d":"1,344"}]
["2013-03-10","R009",2,224,448]
["2013-03-12","R001",14,83,{"v":1162,"d":"1,162"}]
["2013-03-23","R002",5,68,340]
["2013-03-25","R009",4,246,984]
["2013-03-26","R003",7,102,714]
["2013-03-27","R004",15,50,750]
["2013-03-28","R001",20,15,300]
["2013-03-29","R002",37,29,{"v":1073,"d":"1,073"}]
["2013-01-07","R008",7,163,{"v":1141,"d":"1,141"}]
["2013-01-17","R002",13,140,{"v":1820,"d":"1,820"}]
["2013-01-17","R008",4,125,500]
["2013-01-19","R005",7,226,{"v":1582,"d":"1,582"}]
["2013-01-19","R008",10,207,{"v":2070,"d":"2,070"}]
["2013-01-21","R002",7,84,588]
["2013-01-21","R004",15,240,{"v":3600,"d":"3,600"}]
["2013-01-27","R001",4,118,472]

{"sheet":"Fiche-A","index":2,"n_rows":5,"n_cols":11,"rows_kept":5,"flags":["formulas_cached_only"]}
["REF","NOM","PRENOM","SALAIRE","AGE","Naiss","GENRE","CIVIL","ENFANTS","LOGEMENT","VOITURE"]
["C001","Abbott","Rémy",{"v":2860.740110907563,"d":"2,861 €"},{"v":39,"d":"39 ans"},"1973-04-27","M","M",4,"Appartement","Opel"]
["C002","Adam","Anne",{"v":850,"d":"850 €"},{"v":21,"d":"21 ans"},"1991-01-04","F","C",0,"Appartement","VW"]
["C003","Allen","Dawn",{"v":3148,"d":"3,148 €"},{"v":39,"d":"39 ans"},"1973-09-19","F","V",2,"Maison","BMW"]
["C004","Anderson","Dawn",{"v":2196.3854645152815,"d":"2,196 €"},{"v":26,"d":"26 ans"},"1986-06-07","F","D",0,"Maison","VW"]

{"sheet":"Fiche-B","index":3,"n_rows":14,"n_cols":11,"rows_kept":14,"flags":["formulas_cached_only"]}
["REF","NOM","PRENOM","SALAIRE","AGE","Naiss","GENRE","CIVIL","ENFANTS","LOGEMENT","VOITURE"]
["C005","Baker","Kevin",{"v":1850,"d":"1,850 €"},{"v":30,"d":"30 ans"},"1982-05-19","M","C",0,"Maison","Toyota"]
["C006","Baker","Marie",{"v":2084.8333783673233,"d":"2,085 €"},{"v":58,"d":"58 ans"},"1954-04-25","F","M",3,"Appartement","Golf"]
["C007","Banks","John",{"v":2940.0660388349997,"d":"2,940 €"},{"v":48,"d":"48 ans"},"1964-03-14","M","M",4,"Maison","VW"]
["C008","Barrette","Hervé",{"v":2022.8599971740139,"d":"2,023 €"},{"v":33,"d":"33 ans"},"1979-07-16","M","C",0,"Maison","VW"]
[{"$nulls":3},{"v":5000,"d":"5,000 €"}]
["C009","Bastijns","Christian",{"v":2022.8599971740139,"d":"2,023 €"},{"v":22,"d":"22 ans"},"1990-08-08","M","C",0,"Appartement","Opel"]
["C010","Bastijns","Jacques",{"v":2003.0285151921546,"d":"2,003 €"},{"v":30,"d":"30 ans"},"1982-12-20","M","M",2,"Maison","Toyota"]
["C011","Bastion","pierre",{"v":1911.307911026056,"d":"1,911 €"},{"v":51,"d":"51 ans"},"1961-03-22","F","M",1,"Appartement","Opel"]
["C012","Baudouin","Michel",{"v":2469.0683417658447,"d":"2,469 €"},{"v":45,"d":"45 ans"},"1967-03-20","M","D",2,"Maison","VW"]
["C013","Bols","Sandra",{"v":2196.3854645152815,"d":"2,196 €"},{"v":48,"d":"48 ans"},"1964-02-17","F","V",4,"Appartement","VW"]
["C014","Brown","Andrew",{"v":1755.1349904189153,"d":"1,755 €"},{"v":39,"d":"39 ans"},"1973-10-03","M","M",3,"Appartement","Opel"]
["C015","Brown","Ann",{"v":2659.946355841239,"d":"2,660 €"},{"v":46,"d":"46 ans"},"1966-10-20","F","V",1,"Maison","VW"]
["C016","Brown","Gavin",{"v":2196.3854645152815,"d":"2,196 €"},{"v":28,"d":"28 ans"},"1984-10-21","M","M",0,"Maison","Mercedes"]

{"sheet":"Fiche-D","index":4,"n_rows":11,"n_cols":11,"rows_kept":11,"flags":["formulas_cached_only"]}
["REF","NOM","PRENOM","SALAIRE","AGE","Naissance","GENRE","CIVIL","ENFANTS","LOGEMENT","voiture"]
["C023","Davis","Nellie",{"v":2084.8333783673233,"d":"2,085 €"},{"v":45,"d":"45 ans"},"1967-09-02","F","V",1,"Appartement"]
["C024","De Vos","Raymond",{"v":2350,"d":"2,350 €"},{"v":25,"d":"25 ans"},"1987-11-22","M","D",0,"Maison"]
["C025","Dedieu","Dominique",{"v":2022.8599971740139,"d":"2,023 €"},{"v":36,"d":"36 ans"},"1976-06-17","F","M",0,"Maison"]
["C026","Delporte","Patrick",{"v":3235,"d":"3,235 €"},{"v":45,"d":"45 ans"},"1967-09-20","M","C",0,"Appartement"]
["C027","Dralon","Fernand",{"v":2840.908628925704,"d":"2,841 €"},{"v":28,"d":"28 ans"},"1984-01-23","M","M",1,"Maison"]
["C028","Dubois","Marie",{"v":2478.984082756774,"d":"2,479 €"},{"v":40,"d":"40 ans"},"1972-07-05","F","D",2,"Maison"]
["C029","Dufrene","Jean",{"v":2032,"d":"2,032 €"},{"v":25,"d":"25 ans"},"1987-12-16","M","M",1,"Appartement"]
["C030","Dupuis","Dominique",{"v":2407.094960572535,"d":"2,407 €"},{"v":34,"d":"34 ans"},"1978-04-18","F","D",1,"Maison"]
["C031","Durand","Thomas",{"v":1849.3345298327463,"d":"1,849 €"},{"v":32,"d":"32 ans"},"1980-09-03","M","C",0,"Maison"]
["C032","Duval","Bernard",{"v":2920.2345568531405,"d":"2,920 €"},{"v":47,"d":"47 ans"},"1965-02-15","M","M",4,"Maison"]

{"sheet":"Fiche-E","index":5,"n_rows":4,"n_cols":11,"rows_kept":4,"flags":["formulas_cached_only"]}
["REF","NOM","PRENOM","SALAIRE","AGE","Naiss","GENRE","CIVIL","ENFANTS","LOGEMENT","VOITURE"]
["C034","Edwards","Ann",{"v":2084.8333783673233,"d":"2,085 €"},{"v":48,"d":"48 ans"},"1964-07-06","F","M",4,"Appartement","Nissan"]
["C035","Engels","Agnès",{"v":1911.307911026056,"d":"1,911 €"},{"v":48,"d":"48 ans"},"1964-01-04","F","M",0,"Maison","Opel"]
["C036","Englebert","Sophie",{"v":1881.5606880532673,"d":"1,882 €"},{"v":53,"d":"53 ans"},"1959-04-16","F","D",5,"Appartement","VW"]

{"sheet":"Mvt-JANV","index":6,"n_rows":9,"n_cols":5,"rows_kept":9,"flags":["formulas_cached_only"]}
["Date","REF","Qté","Prix","Valeur"]
["2013-01-07","R008",7,163,{"v":1141,"d":"1,141"}]
["2013-01-17","R002",13,140,{"v":1820,"d":"1,820"}]
["2013-01-17","R008",4,125,500]
["2013-01-19","R005",7,226,{"v":1582,"d":"1,582"}]
["2013-01-19","R008",10,207,{"v":2070,"d":"2,070"}]
["2013-01-21","R002",7,84,588]
["2013-01-21","R004",15,240,{"v":3600,"d":"3,600"}]
["2013-01-27","R001",4,118,472]

{"sheet":"Mvt-FEV","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"flags":["formulas_cached_only"]}
["Date","REF","Qté","Prix","Valeur"]
["2013-02-05","R003",14,204,{"v":2856,"d":"2,856"}]
["2013-02-10","R008",8,250,{"v":2000,"d":"2,000"}]
["2013-02-13","R007",2,232,464]
["2013-02-17","R007",2,63,126]
["2013-02-18","R004",6,130,780]
["2013-02-18","R003",13,80,{"v":1040,"d":"1,040"}]
["2013-02-19","R003",5,137,685]
["2013-02-19","R001",13,120,{"v":1560,"d":"1,560"}]
["2013-02-20","R004",13,186,{"v":2418,"d":"2,418"}]
["2013-02-21","R003",1,50,50]
["2013-02-25","R007",10,205,{"v":2050,"d":"2,050"}]
["2013-02-26","R008",1,226,226]
["2013-02-27","R006",9,181,{"v":1629,"d":"1,629"}]

{"sheet":"Mvt-MAR","index":8,"n_rows":10,"n_cols":5,"rows_kept":10,"flags":["formulas_cached_only"]}
["Date","REF","Qté","Prix","Valeur"]
["2013-03-09","R002",12,112,{"v":1344,"d":"1,344"}]
["2013-03-10","R009",2,224,448]
["2013-03-12","R001",14,83,{"v":1162,"d":"1,162"}]
["2013-03-23","R002",5,68,340]
["2013-03-25","R009",4,246,984]
["2013-03-26","R003",7,102,714]
["2013-03-27","R004",15,50,750]
["2013-03-28","R001",20,15,300]
["2013-03-29","R002",37,29,{"v":1073,"d":"1,073"}]

{"sheet":"Fiche-C","index":9,"n_rows":7,"n_cols":11,"rows_kept":7,"flags":["formulas_cached_only"]}
["REF","NOM","PRENOM","SALAIRE","AGE","Naiss","GENRE","CIVIL","ENFANTS","LOGEMENT","VOITURE"]
["C017","Caulier","Suzanne",{"v":2196.3854645152815,"d":"2,196 €"},{"v":40,"d":"40 ans"},"1972-02-06","F","D",4,"Appartement","VW"]
["C018","Clark","Peter",{"v":2022.8599971740139,"d":"2,023 €"},{"v":27,"d":"27 ans"},"1985-10-27","M","D",0,"Maison","VW"]
["C019","Clark","Sue",{"v":1911.307911026056,"d":"1,911 €"},{"v":25,"d":"25 ans"},"1987-03-08","F","M",0,"Maison","VW"]
["C020","Cooke","Tina",{"v":2796,"d":"2,796 €"},{"v":38,"d":"38 ans"},"1974-06-27","F","D",0,"Maison","Land Rover"]
["C021","Cutler","Karen",{"v":2022.8599971740139,"d":"2,023 €"},{"v":26,"d":"26 ans"},"1986-05-06","F","C",0,"Appartement","VW"]
["C022","Cuvelier","Christine",{"v":2084.8333783673233,"d":"2,085 €"},{"v":32,"d":"32 ans"},"1980-05-16","F","M",1,"Maison","Opel"]