{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["ID","COMPTES","CENTRES","Abc","POU","ACTIVITES","MàJ"],"not_rendered":{"macros":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"ID","index":0,"n_rows":7,"n_cols":15,"rows_kept":7}
["ID","CENTRE","ACTIVITE","EQUIPEMENT","TYP_CTT","NAT_CTT","CAT_GRADE","EMPLOI","NDOSSIER","FLEX_VALUE","ETABLISSEMENT","MONTANT","NMATRI-NDOSS","DPT","UNITE"]
[1,86,340001,null,"TO",null,1,"Assistante","A",835,1,10000,{"$f":"ID!$A2&\" - \"&ID!$I2","v":"1 - A"},{"$f":"VLOOKUP(ID!$A2,Abc!$A:$D,3,FALSE)","v":"ABC"},{"$f":"VLOOKUP(ID!$A2,Abc!$A:$D,4,FALSE)","v":"Batman"}]
[2,96,340002,null,"TO",null,2,"Manager","A",930,1,20000,{"$f":"ID!$A3&\" - \"&ID!$I3","v":"2 - A"},{"$f":"VLOOKUP(ID!$A3,Abc!$A:$D,3,FALSE)","v":"DEF"},{"$f":"VLOOKUP(ID!$A3,Abc!$A:$D,4,FALSE)","v":"Wonderwoman"}]
[3,100,340003,null,"TO",null,2,"Consultant","A",7100,1,30000,{"$f":"ID!$A4&\" - \"&ID!$I4","v":"3 - A"},{"$f":"VLOOKUP(ID!$A4,Abc!$A:$D,3,FALSE)","v":"GHI"},{"$f":"VLOOKUP(ID!$A4,Abc!$A:$D,4,FALSE)","v":"Ironman"}]
[4,101,340004,null,"TO",null,1,"Directeur","A",1514,2,40000,{"$f":"ID!$A5&\" - \"&ID!$I5","v":"4 - A"},{"$f":"VLOOKUP(ID!$A5,Abc!$A:$D,3,FALSE)","v":"JKL"},{"$f":"VLOOKUP(ID!$A5,Abc!$A:$D,4,FALSE)","v":"Mistic"}]
[5,103,340005,null,"TO",null,1,"Xmen","X",359,2,50000,{"$f":"ID!$A6&\" - \"&ID!$I6","v":"5 - X"},{"$f":"VLOOKUP(ID!$A6,Abc!$A:$D,3,FALSE)","v":"MNO"},{"$f":"VLOOKUP(ID!$A6,Abc!$A:$D,4,FALSE)","v":"Spiderman"}]
[6,113,340006,null,"TO",null,1,"Magicien","A",1541,1,15000,{"$f":"ID!$A7&\" - \"&ID!$I7","v":"6 - A"},{"$f":"VLOOKUP(ID!$A7,Abc!$A:$D,3,FALSE)","v":"PQR"},{"$f":"VLOOKUP(ID!$A7,Abc!$A:$D,4,FALSE)","v":"Jean"}]

{"sheet":"COMPTES","index":1,"n_rows":2,"n_cols":16,"rows_kept":2}
["Concaténation","TYP_CTT","NAT_CTT","COD_ABO","CG_SAL","ET_CG_SAL","CG_CNTRP_SAL","TX_CHAR_SOC","CG_CHAR_SOC","ET_CHAR_SOC","CG_CNTRP_CHAR_SOC","TX_CHAR_FISC","CG_CHAR_FISC","ET_CHAR_FISC","CG_CNPRT_CHAR_FISC","DATE_SAISIE"]
[{"$f":"B2&\" - \"&C2&\" - \"&D2","v":"TO -    - 13"},"TO","  ",13,6429000,1,4286040,38.33,6489000,1,4386040,7.07,6380000,1,4486040,"2018-01-24"]

{"sheet":"CENTRES","index":2,"n_rows":7,"n_cols":8,"rows_kept":7}
["FLEX_VALUE","DESCRIPTION","START_DATE_ACTIVE","END_DATE_ACTIVE","ENABLED_FLAG","CHARGEABLE_FLAG","SERVER_UPDATE_DATE","ETABLISSEMENT"]
[86,"N/A",null,null,"Y","Y","2018-01-09",1]
[96,"N/A",null,null,"Y","Y","2018-01-12",1]
[100,"N/A",null,null,"Y","Y","2017-12-22",1]
[101,"N/A",null,null,"Y","Y","2013-06-20",1]
[103,"N/A",null,null,"Y","Y","2017-12-22",1]
[113,"N/A",null,null,"Y","Y","2017-02-27",1]

{"sheet":"Abc","index":3,"n_rows":7,"n_cols":10,"rows_kept":7}
["ID","NUDOSP","DPT","UNITE","PERIODE_PAIE","ETAB","g","h","i","(G*(H-I))/12"]
[1,1,"ABC","Batman","MT201812",1,5097.15,2,0,{"v":849.525,"d":"849.53"}]
[2,1,"DEF","Wonderwoman","MT201812",1,6013.46,2,0,{"v":1002.2433333333333,"d":"1002.24"}]
[3,1,"GHI","Ironman","MT201812",2,0,2,0,{"v":0,"d":"0.00"}]
[4,1,"JKL","Mistic","MT201812",2,6502.16,2,0,{"v":1083.6933333333334,"d":"1083.69"}]
[5,1,"MNO","Spiderman","MT201812",3,0,2,0,{"v":0,"d":"0.00"}]
[6,1,"PQR","Jean","MT201812",3,0,2,0,{"v":0,"d":"0.00"}]

{"sheet":"POU","index":4,"n_rows":4,"n_cols":6,"rows_kept":4}
["POU_CENTRE","POU_ACTIVITE","POU_DATMAJ","POU_ETABLISSEMENT","POU_ET_MAITRE","CONCAT"]
[{"v":300,"d":"00300"},999000,"2015-12-17",1,1,{"$f":"D2&\"-\"&E2","v":"1-1"}]
[{"v":400,"d":"00400"},100000,"2015-12-17",2,1,{"$f":"D3&\"-\"&E3","v":"2-1"}]
[{"v":500,"d":"00500"},500000,"2015-12-17",3,1,"3-1"]

{"sheet":"ACTIVITES","index":5,"n_rows":7,"n_cols":8,"rows_kept":7}
["FLEX_VALUE","DESCRIPTION","START_DATE_ACTIVE","END_DATE_ACTIVE","ENABLED_FLAG","CHARGEABLE_FLAG","SERVER_UPDATE_DATE","ETABLISSEMENT"]
[340001,"/NA","2010-01-01",null,"Y","Y","2010-09-04",1]
[340002,"/NA","2010-01-01",null,"Y","Y","2010-09-04",1]
[340003,"/NA","2010-01-01",null,"Y","Y","2010-09-04",1]
[340004,"/NA","2010-01-01",null,"Y","Y","2010-09-04",1]
[340005,"/NA","2010-01-01",null,"Y","Y","2010-09-04",1]
[340006,"/NA","2010-01-01",null,"Y","Y","2010-09-04",1]

{"sheet":"MàJ","index":6,"n_rows":16,"n_cols":13,"rows_kept":16,"merged":[[0,0,0,12],[2,2,3,12],[4,2,4,12],[10,2,11,11]]}
["MODE OPERATOIRE - GENERATION SCHEMAS COMPTABLES DETTES DE TEMPS - CALCUL 13E MOIS"]
[]
[null,1,"Mettre à jour les inputs présents dans les onglets ci-dessous (ID, Table COMPTE, CENTRE, Abc, POU et ACTIVITES) et vérifier que les formules aillent bien jusqu'à la dernière ligne (colonne grisée sur ID & Table COMPTE & POU)"]
[]
[null,null,"Lors de la mise à jour de la table AGENT > Faire un filtre sur la colonne MONTANT et supprimer les données à 0."]
[]
[null,null,"A compléter :",null,"Mois de traitement",null,"2018-10-01"]
[]
[null,2,"Appuyer sur le bouton >",{"$nulls":5},"40 min d'exécution"]
[]
[null,3,"Une fois la macro terminée, ouvrir le fichier \"Schémas_cptables_VP\" et vérifier que les formules descendent bien jusqu'à la dernière ligne. Faire F9 pour actualiser les formules",{"$nulls":9},"1h10 d'actualisation"]
[]
[]
[null,4,"Une fois les calculs mis à jour, cliquer sur le bouton >"]
[]
[null,5,"Actualiser les TCD (Données > Actualiser tout)"]