{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Réponses au formulaire 1","Résumé  Trésorerie"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Réponses au formulaire 1","index":0,"n_rows":183,"n_cols":18,"rows_kept":183,"cut":false,"hidden":false,"merged":[[0,1,0,8],[0,10,0,15]]}
[null,"Tarif Normal",null,null,null,null,null,null,null,"TARIF SPECIAL","TARIF SPECIAL (asso/réseau)"]
["Horodateur","Nom","Prénom","Promo","Adhérent","Type de place","Numéro de place","Paiement","Commentaires","TARIF SPECIAL (ademkel ; gaelis...)","Pourquoi ?","Quel prix payé ?","Type de place","Numéro de place","Nom / Prénom","Moyen de paiement","Asso (si GAELIS)","Adresse e-mail"]
["2017-05-10T15:46:05.697","Nom 1","Prénom 1","K1","Oui","Soirée",1,"Internet",null,"NON"]
["2017-05-10T18:39:22.467","Nom 3","Prénom 3","Exté","Non","Soirée",2,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:38:51.201","Nom 5","Prénom 5","Exté","Non","Soirée",3,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-11T12:45:33.132","Nom 7","Prénom 7","K2","Oui","Soirée",4,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-11T12:47:55.560","Nom 9","Prénom 9","Exté","Non","Soirée",5,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T14:51:02.101","Nom 17","Prénom 17","K2","Oui","Cocktail",10,"Internet",null,"NON"]
["2017-05-10T14:51:30.507","Nom 18","Prénom 18","K2","Oui","Cocktail",11,"Internet",null,"NON"]
["2017-05-10T14:54:10.837","Nom 19","Prénom 19","K3","Oui","Cocktail",12,"Internet",null,"NON"]
["2017-05-10T14:54:47.877","Nom 20","Prénom 20","K2","Oui","Cocktail",13,"Internet",null,"NON"]
["2017-05-10T14:55:31.382","Nom 21","Prénom 21","K3","Oui","Cocktail",14,"Internet",null,"NON"]
["2017-05-10T15:28:58.053","Nom 38","Prénom 38","K1","Oui","Cocktail",31,"Internet",null,"NON"]
["2017-05-10T15:41:11.959","Nom 50","Prénom 50","K1","Oui","Cocktail",47,"Internet",null,"NON"]
["2017-05-10T15:41:42.976","Nom 51","Prénom 51","E2","Oui","Cocktail",48,"Internet",null,"NON"]
["2017-05-10T15:43:00.026","Nom 52","Prénom 52","E2","Oui","Cocktail",49,"Internet",null,"NON"]
["2017-05-10T15:56:20.514","Nom 55","Prénom 55","K2","Oui","Cocktail",52,"Internet",null,"NON"]
["2017-05-10T15:59:19.191","Nom 60","Prénom 60","DE","Oui","Cocktail",57,"Internet",null,"NON"]
["2017-05-10T15:59:46.278","Nom 61","Prénom 61","K2","Oui","Cocktail",58,"Internet",null,"NON"]
["2017-05-10T16:00:49.840","Nom 62","Prénom 62","DE","Oui","Cocktail",59,"Internet",null,"NON"]
["2017-05-10T16:01:16.586","Nom 63","Prénom 63","K2","Oui","Cocktail",60,"Internet",null,"NON"]
["2017-05-10T16:02:35.065","Nom 64","Prénom 64","K2","Oui","Cocktail",61,"Internet",null,"NON"]
["2017-05-10T16:03:59.854","Nom 65","Prénom 65","K2","Oui","Cocktail",62,"Internet",null,"NON"]
["2017-05-10T16:05:19.749","Nom 66","Prénom 66","K2","Oui","Cocktail",63,"Internet",null,"NON"]
["2017-05-10T16:06:09.801","Nom 67","Prénom 67","K2","Oui","Cocktail",64,"Internet",null,"NON"]
["2017-05-10T16:06:32.540","Nom 68","Prénom 68","DE","Oui","Cocktail",65,"Internet",null,"NON"]
["2017-05-10T16:07:08.680","Nom 69","Prénom 69","E2","Oui","Cocktail",66,"Internet",null,"NON"]
["2017-05-10T16:07:32.278","Nom 70","Prénom 70","K2","Oui","Cocktail",67,"Internet",null,"NON"]
["2017-05-10T16:08:11.619","Nom 71","Prénom 71","K2","Oui","Cocktail",68,"Internet",null,"NON"]
["2017-05-10T16:19:03.044","Nom 72","Prénom 72","K2","Oui","Cocktail",69,"Internet",null,"NON"]
["2017-05-10T16:26:34.723","Nom 73","Prénom 73","K2","Oui","Cocktail",70,"Internet",null,"NON"]
["2017-05-10T16:45:13.707","Nom 76","Prénom 76","E2","Oui","Cocktail",73,"Internet",null,"NON"]
["2017-05-10T18:41:47.401","Nom 89","Prénom 89","K1","Oui","Cocktail",86,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:42:53.109","Nom 91","Prénom 91","Exté","Non","Cocktail",88,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T17:06:38.502","Nom 92","Prénom 92","Exté","Non","Cocktail",89,"Internet",null,"NON"]
["2017-05-10T18:13:30.476","Nom 93","Prénom 93","K3","Oui","Cocktail",90,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:14:23.338","Nom 94","Prénom 94","K2","Oui","Cocktail",91,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:14:54.059","Nom 95","Prénom 95","Exté","Non","Cocktail",92,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:15:19.806","Nom 96","Prénom 96","Exté","Non","Cocktail",93,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:15:48.590","Nom 97","Prénom 97","Exté","Non","Cocktail",94,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:16:14.719","Nom 98","Prénom 98","Exté","Non","Cocktail",95,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:16:54.339","Nom 99","Prénom 99","Exté","Non","Cocktail",96,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:19:07.311","Nom 100","Prénom 100","K1","Oui","Cocktail",97,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:21:11.654","Nom 101","Prénom 101","K3","Oui","Cocktail",98,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:21:48.419","Nom 102","Prénom 102","Exté","Non","Cocktail",99,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:22:15.358","Nom 103","Prénom 103","Exté","Non","Cocktail",100,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:25:19.111","Nom 104","Prénom 104","DE","Oui","Cocktail",101,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:25:50.862","Nom 105","Prénom 105","K3","Oui","Cocktail",102,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:26:21.073","Nom 106","Prénom 106","Exté","Non","Cocktail",103,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:26:47.531","Nom 107","Prénom 107","K1","Oui","Cocktail",104,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:27:45.929","Nom 108","Prénom 108","Exté","Oui","Cocktail",105,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:28:23.363","Nom 109","Prénom 109","E2","Oui","Cocktail",106,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:32:03.540","Nom 110","Prénom 110","Exté","Non","Cocktail",107,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:32:31.068","Nom 111","Prénom 111","E2","Oui","Cocktail",108,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:33:56.429","Nom 112","Prénom 112","Exté","Non","Cocktail",109,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:34:18.581","Nom 113","Prénom 113","Exté","Non","Cocktail",110,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:36:01.929","Nom 114","Prénom 114","K2","Oui","Cocktail",111,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:38:00.377","Nom 115","Prénom 115","Exté","Non","Cocktail",112,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:40:03.942","Nom 116","Prénom 116","Exté","Non","Cocktail",113,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T18:40:28.237","Nom 117","Prénom 117","Exté","Non","Cocktail",114,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-11T12:40:33.272","Nom 129","Prénom 129","Exté","Non","Cocktail",127,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-12T17:04:22.246","Nom 130","Prénom 130","K3","Oui","Cocktail",128,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-11T12:48:50.323","Nom 132","Prénom 132","K2","Oui","Cocktail",130,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-11T12:49:32.163","Nom 133","Prénom 133","Exté","Non","Cocktail",131,"Internet",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T14:18:34.048","Nom 6","Prénom 6","E2","Oui","Cocktail",3,"CB",null,"NON"]
["2017-05-10T14:45:55.978","Nom 8","Prénom 8","E2","Oui","Cocktail",4,"CB",null,"NON"]
["2017-05-11T11:33:03.551","Nom 10","Prénom 10","E2","Oui","Cocktail",5,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T14:46:37.105","Nom 11","Prénom 11","K3","Oui","Cocktail",6,"CB",null,"NON"]
["2017-05-15T13:39:03.995","Nom 12","Prénom 12","Exté","Non","Soirée",7,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-15T13:39:59.898","Nom 14","Prénom 14","Exté","Non","Soirée",8,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T14:50:10.948","Nom 16","Prénom 16","E2","Oui","Cocktail",9,"CB",null,"NON"]
["2017-05-10T14:55:58.438","Nom 22","Prénom 22","E3","Oui","Cocktail",15,"CB",null,"NON"]
["2017-05-10T14:56:25.771","Nom 23","Prénom 23","K1","Oui","Cocktail",16,"CB",null,"NON"]
["2017-05-10T14:57:08.321","Nom 24","Prénom 24","K1","Oui","Cocktail",17,"CB",null,"NON"]
["2017-05-10T14:57:38.065","Nom 25","Prénom 25","K1","Oui","Cocktail",18,"CB",null,"NON"]
["2017-05-10T14:58:05.177","Nom 26","Prénom 26","K1","Oui","Cocktail",19,"CB",null,"NON"]
["2017-05-10T15:02:38.644","Nom 28","Prénom 28","K1","Oui","Cocktail",21,"CB",null,"NON"]
["2017-05-10T15:05:50.169","Nom 29","Prénom 29","K1","Oui","Cocktail",22,"CB",null,"NON"]
["2017-05-10T15:07:42.741","Nom 31","Prénom 31","E1","Oui","Cocktail",24,"CB",null,"NON"]
["2017-05-10T15:08:49.979","Nom 33","Prénom 33","E1","Oui","Cocktail",26,"CB",null,"NON"]
["2017-05-11T11:37:39.579","Nom 34","Prénom 34","K1","Oui","Cocktail",27,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T15:10:27.794","Nom 35","Prénom 35","K1","Oui","Cocktail",28,"CB",null,"NON"]
["2017-05-10T15:10:57.783","Nom 36","Prénom 36","K1","Oui","Cocktail",29,"CB",null,"NON"]
["2017-05-10T15:11:33.557","Nom 37","Prénom 37","K1","Oui","Cocktail",30,"CB",null,"NON"]
["2017-05-10T15:30:11.247","Nom 39","Prénom 39","K3","Oui","Cocktail",33,"CB",null,"NON"]
["2017-05-10T15:38:21.679","Nom 45","Prénom 45","E1","Oui","Cocktail",42,"CB",null,"NON"]
["2017-05-10T15:38:49.416","Nom 46","Prénom 46","E1","Oui","Cocktail",43,"CB",null,"NON"]
["2017-05-10T15:39:27.215","Nom 47","Prénom 47","K1","Oui","Cocktail",44,"CB",null,"NON"]
["2017-05-10T15:39:53.044","Nom 48","Prénom 48","K1","Oui","Cocktail",45,"CB",null,"NON"]
["2017-05-10T15:40:20.723","Nom 49","Prénom 49","K1","Oui","Cocktail",46,"CB",null,"NON"]
["2017-05-10T15:44:03.932","Nom 53","Prénom 53","E1","Oui","Cocktail",50,"CB",null,"NON"]
["2017-05-10T15:44:43.045","Nom 54","Prénom 54","E1","Oui","Cocktail",51,"CB",null,"NON"]
["2017-05-10T15:52:57.305","Nom 57","Prénom 57","E1","Oui","Cocktail",54,"CB",null,"NON"]
["2017-05-10T15:53:30.932","Nom 58","Prénom 58","K3","Oui","Cocktail",55,"CB",null,"NON"]
["2017-05-10T16:29:29.341","Nom 74","Prénom 74","K1","Oui","Cocktail",71,"CB",null,"NON"]
["2017-05-10T16:22:58.961","Nom 75","Prénom 75","K3","Oui","Cocktail",72,"CB","Payé pour pl.80","NON"]
["2017-05-10T16:46:14.680","Nom 77","Prénom 77","K3","Oui","Cocktail",74,"CB",null,"NON"]
["2017-05-10T16:48:40.145","Nom 79","Prénom 79","K1","Oui","Cocktail",76,"CB","Payé pour pl.77","NON"]
["2017-05-10T16:49:05.142","Nom 80","Prénom 80","K1","Oui","Cocktail",77,"CB","Payé par pl.76","NON"]
["2017-05-10T16:49:46.354","Nom 81","Prénom 81","E1","Oui","Cocktail",78,"CB",null,"NON"]
["2017-05-10T16:50:44.420","Nom 83","Prénom 83","Exté","Non","Cocktail",80,"CB","Payé par pl.72","NON"]
["2017-05-10T16:51:58.990","Nom 85","Prénom 85","K1","Oui","Cocktail",82,"CB",null,"NON"]
["2017-05-10T16:52:58.755","Nom 87","Prénom 87","Exté","Non","Cocktail",84,"CB",null,"NON"]
["2017-05-10T16:53:23.910","Nom 88","Prénom 88","Exté","Non","Cocktail",85,"CB",null,"NON"]
["2017-05-11T11:49:10.718","Nom 90","Prénom 90","K3","Oui","Cocktail",87,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T16:54:07.866","Nom 118","Prénom 118","E1","Oui","Cocktail",115,"CB",null,"NON"]
["2017-05-10T16:55:31.455","Nom 119","Prénom 119","K1","Oui","Cocktail",116,"CB","Abandon de paiement mais place réservée (VOIR COFFRE)","NON"]
["2017-05-10T17:04:10.009","Nom 120","Prénom 120","K1","Oui","Cocktail",117,"CB",null,"NON"]
["2017-05-10T17:04:37.017","Nom 121","Prénom 121","K1","Oui","Cocktail",118,"CB",null,"NON"]
["2017-05-11T12:50:34.017","Nom 134","Prénom 134","Exté","Non","Cocktail",132,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-12T11:53:14.790","Nom 135","Prénom 135","K3","Oui","Cocktail",133,"CB","Paie pour 134","NON",null,null,null,null,null,null,null,""]
["2017-05-12T11:53:47.485","Nom 136","Prénom 136","K3","Oui","Cocktail",134,"CB","Payé par 133","NON",null,null,null,null,null,null,null,""]
["2017-05-12T12:37:49.652","Nom 142","Prénom 142","K3","Oui","Cocktail",143,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-12T12:49:40.777","Nom 143","Prénom 143","K3","Oui","Cocktail",144,"CB","Paie pour 144 145 146 147","NON",null,null,null,null,null,null,null,""]
["2017-05-12T12:54:15.364","Nom 144","Prénom 144","Exté","Non","Cocktail",145,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-12T12:54:43.309","Nom 145","Prénom 145","Exté","Non","Cocktail",146,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-12T12:55:09.850","Nom 146","Prénom 146","Exté","Non","Cocktail",147,"CB","payé par 144","NON",null,null,null,null,null,null,null,""]
["2017-05-12T12:52:45.994","Nom 147","Prénom 147","K3","Oui","Cocktail",148,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-12T12:53:21.331","Nom 148","Prénom 148","Exté","Non","Cocktail",149,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-12T16:58:56.088","Nom 149","Prénom 149","Exté","Non","Cocktail",150,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-15T12:26:44.985","Nom 152","Prénom 152","K3","Oui","Soirée",154,"CB","Paye aussi la 155 Pour exté cocktail","NON",null,null,null,null,null,null,null,""]
["2017-05-15T12:30:48.391","Nom 153","Prénom 153","Exté","Non","Cocktail",155,"CB","Payé par 154","NON",null,null,null,null,null,null,null,""]
["2017-05-15T12:27:42.823","Nom 154","Prénom 154","K3","Oui","Cocktail",156,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-15T12:28:47.643","Nom 155","Prénom 155","K3","Oui","Cocktail",157,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-15T12:31:57.839","Nom 156","Prénom 156","K3","Oui","Cocktail",158,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-15T12:37:29.444","Nom 157","Prénom 157","K2","Oui","Cocktail",159,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-15T12:38:52.400","Nom 158","Prénom 158","K2","Oui","Cocktail",160,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-15T12:51:43.994","Nom 161","Prénom 161","K2","Oui","Cocktail",163,"CB",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-16T16:21:56.582","Nom 163","Prénom 163","DE","Non","Cocktail",166,"CB","Plus de papier","NON",null,null,null,null,null,null,null,""]
["2017-05-16T16:21:23.097","Nom 164","Prénom 164","DE","Non","Cocktail",167,"CB","Plus de papier","NON",null,null,null,null,null,null,null,""]
["2017-05-16T16:20:52.758","Nom 165","Prénom 165","DE","Non","Cocktail",168,"CB","Plus de papier","NON",null,null,null,null,null,null,null,""]
["2017-05-16T16:20:05.663","Nom 166","Prénom 166","DE","Non","Cocktail",169,"CB","Plus de papier","NON",null,null,null,null,null,null,null,""]
["2017-05-16T16:16:09.697","Nom 167","Prénom 167","Exté","Non","Cocktail",170,"CB","Plus de papier paye pour 166 -> 170","NON",null,null,null,null,null,null,null,""]
["2017-05-16T16:23:34.282","Nom 168","Prénom 168","Exté","Non","Cocktail",171,"CB","Plus de papier payé par 172","NON",null,null,null,null,null,null,null,""]
["2017-05-16T16:23:07.106","Nom 169","Prénom 169","K2","Oui","Cocktail",172,"CB","Plus de papier","NON",null,null,null,null,null,null,null,""]
["2017-05-16T16:25:53.407","Nom 170","Prénom 170","K2","Oui","Cocktail",173,"CB","Plus de papier","NON",null,null,null,null,null,null,null,""]
["2017-05-10T12:53:42.646","Nom 2","Prénom 2","E2","Oui","Cocktail",1,"Chèque"]
["2017-05-10T14:47:16.839","Nom 13","Prénom 13","K3","Oui","Cocktail",7,"Chèque",null,"NON"]
["2017-05-10T14:49:40.476","Nom 15","Prénom 15","E2","Oui","Cocktail",8,"Chèque",null,"NON"]
["2017-05-10T15:06:47.332","Nom 30","Prénom 30","K1","Oui","Cocktail",23,"Chèque",null,"NON"]
["2017-05-11T12:22:06.859","Nom 126","Prénom 126","Exté","Non","Cocktail",124,"Chèque",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-11T12:36:44.367","Nom 128","Prénom 128","K3","Oui","Cocktail",126,"Chèque",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-12T11:59:04.080","Nom 138","Prénom 138","E3","Oui","Cocktail",136,"Chèque","payé par 137","NON",null,null,null,null,null,null,null,""]
["2017-05-12T11:59:56.172","Nom 139","Prénom 139","E3","Oui","Cocktail",137,"Chèque","paye pour 136 et 138","NON",null,null,null,null,null,null,null,""]
["2017-05-12T12:00:51.091","Nom 140","Prénom 140","Exté","Non","Cocktail",138,"Chèque","payé par 137","NON",null,null,null,null,null,null,null,""]
["2017-05-15T12:47:53.234","Nom 160","Prénom 160","K2","Oui","Cocktail",162,"Chèque",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T12:56:51.229","Nom 4","Prénom 4","E2","Oui","Cocktail",2,"Espèce"]
["2017-05-10T15:00:20.214","Nom 27","Prénom 27","K1","Oui","Cocktail",20,"Espèce",null,"NON"]
["2017-05-10T15:08:20.591","Nom 32","Prénom 32","E1","Oui","Cocktail",25,"Espèce",null,"NON"]
["2017-05-10T15:31:11.706","Nom 40","Prénom 40","K2","Oui","Cocktail",34,"Espèce",null,"NON"]
["2017-05-10T15:33:15.140","Nom 41","Prénom 41","K1","Oui","Cocktail",35,"Espèce",null,"NON"]
["2017-05-10T15:35:56.018","Nom 42","Prénom 42","E1","Oui","Cocktail",38,"Espèce",null,"NON"]
["2017-05-10T15:36:24","Nom 43","Prénom 43","E1","Oui","Cocktail",39,"Espèce",null,"NON"]
["2017-05-10T15:37:56.197","Nom 44","Prénom 44","K2","Oui","Cocktail",41,"Espèce",null,"NON"]
["2017-05-10T15:47:17.926","Nom 56","Prénom 56","E1","Oui","Cocktail",53,"Espèce",null,"NON"]
["2017-05-10T15:54:50.716","Nom 59","Prénom 59","K3","Oui","Cocktail",56,"Espèce",null,"NON"]
["2017-05-10T16:47:28.218","Nom 78","Prénom 78","Exté","Non","Cocktail",75,"Espèce","Moyen de paiement pas sûr.","NON"]
["2017-05-10T16:50:15.038","Nom 82","Prénom 82","E1","Oui","Cocktail",79,"Espèce",null,"NON"]
["2017-05-10T16:51:26.652","Nom 84","Prénom 84","K3","Oui","Cocktail",81,"Espèce",null,"NON"]
["2017-05-10T16:52:37.199","Nom 86","Prénom 86","Exté","Non","Cocktail",83,"Espèce",null,"NON"]
["2017-05-11T12:17:05.557","Nom 122","Prénom 122","K3","Oui","Cocktail",120,"Espèce","paye pour place 121","NON",null,null,null,null,null,null,null,""]
["2017-05-11T12:17:42.419","Nom 123","Prénom 123","Exté","Non","Cocktail",121,"Espèce","payé par place 120","NON",null,null,null,null,null,null,null,""]
["2017-05-11T12:19:15.374","Nom 124","Prénom 124","K3","Oui","Cocktail",122,"Espèce","paye pour 123","NON",null,null,null,null,null,null,null,""]
["2017-05-11T12:20:10.199","Nom 125","Prénom 125","DE","Non","Cocktail",123,"Espèce","payé par 122","NON",null,null,null,null,null,null,null,""]
["2017-05-11T12:33:15.681","Nom 127","Prénom 127","K3","Oui","Cocktail",125,"Espèce",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-11T12:44:25.490","Nom 131","Prénom 131","K3","Oui","Cocktail",129,"Espèce",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-12T11:58:34.304","Nom 137","Prénom 137","E3","Oui","Cocktail",135,"Espèce",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-12T12:33:58.122","Nom 141","Prénom 141","Exté","Non","Cocktail",142,"Espèce",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-15T12:22:53.455","Nom 150","Prénom 150","K3","Oui","Cocktail",152,"Espèce",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-15T12:24:56.978","Nom 151","Prénom 151","K3","Oui","Cocktail",153,"Espèce",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-15T12:41:44.420","Nom 159","Prénom 159","Exté","Non","Cocktail",161,"Espèce",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-15T12:57:42.743","Nom 162","Prénom 162","K2","Oui","Cocktail",165,"Espèce",null,"NON",null,null,null,null,null,null,null,""]
["2017-05-10T15:29:28.158",null,null,null,null,null,null,null,null,"OUI","Asso","Prix 1","Cocktail",32,"Nom TS 1","CB"]
["2017-05-10T15:33:59.734",null,null,null,null,null,null,null,null,"OUI","Asso","Prix 2","Cocktail",36,"Nom TS 2","CB"]
["2017-05-10T15:34:32.860",null,null,null,null,null,null,null,null,"OUI","Asso","Prix 3","Cocktail",37,"Nom TS 3","CB"]
["2017-05-10T15:36:57.302",null,null,null,null,null,null,null,null,"OUI","Asso","Prix 4","Cocktail",40,"Nom TS 4","Chèque"]
["2017-05-10T17:05:20.081",null,null,null,null,null,null,null,null,"OUI","Asso","Prix 5","Cocktail",119,"Nom TS 5","CB"]
["2017-05-12T17:10:43.469",null,null,null,null,null,null,null,null,"OUI","Réseau","Prix 6","Cocktail",141,"Nom TS 6","CB",null,""]
["2017-05-12T17:13:41.608",null,null,null,null,null,null,null,null,"OUI","Réseau","Prix 7","Cocktail",140,"Nom TS 7","CB",null,""]
["2017-05-12T17:14:40.025",null,null,null,null,null,null,null,null,"OUI","Réseau","Prix 8","Cocktail",139,"Nom TS 8","CB",null,""]
["2017-05-12T17:40:52.067",null,null,null,null,null,null,null,null,"OUI","Asso","Prix 9","Cocktail",151,"Nom TS 9","CB",null,""]
["2017-05-12T17:53:21.968",null,null,null,null,null,null,null,null,"OUI","Réseau","Prix 10","Soirée",6,"Nom TS 10","CB",null,""]
["2017-05-15T12:55:32.334",null,null,null,null,null,null,null,null,"OUI","Asso","Prix 11","Cocktail",164,"Nom TS 11","CB",null,""]

{"sheet":"Résumé  Trésorerie","index":1,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,8,21,9],[22,8,22,9],[17,5,18,5],[17,4,18,4],[13,5,14,5],[15,5,16,5],[5,5,6,5],[5,4,6,4],[13,4,14,4],[11,4,12,4],[15,4,16,4],[7,4,8,4],[7,5,8,5],[11,5,12,5],[1,5,2,5],[1,4,2,4],[0,4,0,5],[3,5,4,5],[3,4,4,4],[0,0,8,0],[11,0,18,0],[15,1,16,1],[15,2,16,2],[13,1,14,1],[11,1,12,1],[11,2,12,2],[13,2,14,2]]}
["Statistiques","Nb par type de place",null,null,"Nb par paiement"]
[null,"Cocktail Adhérent (normal)",{"$f":"COUNTIFS('Réponses au formulaire 1'!F:F,\"cocktail\",'Réponses au formulaire 1'!E:E,\"OUI\")","v":120},null,"Nb places chèques",{"$f":"COUNTIFS('Réponses au formulaire 1'!H:H,\"chèque\") + COUNTIFS('Réponses au formulaire 1'!P:P,\"chèque\")","v":11},null,"% adhérents",{"$f":"(I3)/(C8+C9)","v":0.6795580110497238}]
[null,"Cocktail Extés (normal)",{"$f":"COUNTIFS('Réponses au formulaire 1'!F:F,\"cocktail\",'Réponses au formulaire 1'!E:E,\"Non\")","v":42},null,null,null,null,"Nb adhérents",{"$f":"COUNTIF('Réponses au formulaire 1'!K:K,\"ADEMKEL\")+C2+C4","v":123}]
[null,"Soirée Adhérent (normal)",{"$f":"COUNTIFS('Réponses au formulaire 1'!F:F,\"soirée\",'Réponses au formulaire 1'!E:E,\"OUI\")","v":3},null,"Nb places espèces",{"$f":"COUNTIFS('Réponses au formulaire 1'!H:H,\"espèce\") + COUNTIFS('Réponses au formulaire 1'!P:P,\"espèce\")","v":26}]
[null,"Soirée Extés (normal)",{"$f":"COUNTIFS('Réponses au formulaire 1'!F:F,\"soirée\",'Réponses au formulaire 1'!E:E,\"Non\")","v":5},null,null,null,null,"Places asso",{"$f":"COUNTIFS('Réponses au formulaire 1'!K:K,\"ADEMKEL\")","v":0}]
[null,"Cocktail tarif réduit",{"$f":"COUNTIFS('Réponses au formulaire 1'!M:M,\"cocktail\")","v":10},null,"Nb places billetweb",{"$f":"COUNTIFS('Réponses au formulaire 1'!H:H,\"billetweb\") + COUNTIFS('Réponses au formulaire 1'!P:P,\"billetweb\")","v":0},null,"Places réseau",{"$f":"COUNTIFS('Réponses au formulaire 1'!K:K,\"GAELIS\")","v":0}]
[null,"Soirée tarif réduit",{"$f":"COUNTIFS('Réponses au formulaire 1'!M:M,\"soirée\")","v":1}]
[null,"Places cocktail (TOTAL)",{"$f":"C2+C3+C6","v":172},null,"Nb places CB",{"$f":"COUNTIFS('Réponses au formulaire 1'!H:H,\"CB\") + COUNTIFS('Réponses au formulaire 1'!P:P,\"CB\")","v":82},null,"Pl.Cocktail restant",{"$f":"350-C8","v":178}]
[null,"Places soirées (TOTAL)",{"$f":"C4+C5+C7","v":9},null,null,null,null,"% pl cocktail vendues",{"$f":"C8/350","v":0.49142857142857144}]
[]
[]
["Trésorerie","Recettes cocktail (TN)",null,null,"Argent chèque (TOTAL)"]
[null,null,null,null,null,null,null,"Recettes total (brut)",{"$f":"C12+C14+C16","v":0}]
[null,"Recettes soirée (TN)",null,null,"Argent espèce (TOTAL)",null,null,"Déficit CB",{"$f":"(F18)*0.004","v":0}]
[null,null,null,null,null,null,null,"Bénéfices TOTAL",{"$f":"I13-I14","v":0}]
[null,"Recette TS",null,null,"Argent billetweb (TOTAL)"]
[null,null,null,null,null,null,null,"Dernier billet","internet"]
[null,null,null,null,"Argent CB (TOTAL)",null,null,"N° de place",{"$f":"INDEX('Réponses au formulaire 1'!G:G,MAX(IF('Réponses au formulaire 1'!H:H=I17,ROW(INDIRECT(\"1:\"&ROWS('Réponses au formulaire 1'!G:G))))))","v":131}]
[null,null,null,null,null,null,null,"Nom",{"$f":"INDEX('Réponses au formulaire 1'!B:B,MAX(IF('Réponses au formulaire 1'!H:H=I17,ROW(INDIRECT(\"1:\"&ROWS('Réponses au formulaire 1'!G:G))))))","v":"Nom 133"}]
[]
[null,null,null,null,null,null,null,"Dernier billet","Cocktail","Chèque"]
[null,null,null,null,null,null,null,"N° de place",162]
[null,null,null,null,null,null,null,"Nom","Nom 160"]