{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil2"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":1,"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":"Feuil1","index":0,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,1,63,4],[58,0,60,1],[58,2,58,4],[59,2,60,4],[62,0,62,1],[9,0,9,1],[9,2,9,4],[6,0,6,1],[26,0,26,1],[12,2,12,4],[23,0,23,1],[21,0,21,1],[20,0,20,1],[17,0,17,4],[15,0,15,2],[22,0,22,4],[20,3,20,4],[15,3,15,4],[14,3,14,4],[16,0,16,2],[11,0,11,4],[42,0,42,4],[2,6,3,6],[0,2,0,4],[23,3,23,4],[25,3,25,4],[1,3,1,4],[2,3,2,4],[3,3,3,4],[5,2,5,4],[6,2,6,4],[4,0,4,4],[0,0,0,1],[24,0,24,1],[25,0,25,1],[24,3,24,4],[5,0,5,1],[3,0,3,1],[7,0,7,4],[34,0,35,4],[51,2,51,4],[52,2,52,4],[38,0,38,4],[39,1,39,4],[45,0,45,4],[46,2,46,4],[27,2,27,4],[21,2,21,4],[10,3,10,4],[8,3,8,4],[19,3,19,4],[18,3,18,4],[26,3,26,4],[64,1,64,4],[36,0,36,1],[36,2,36,4],[55,2,55,4],[62,2,62,4],[53,2,53,4],[54,2,54,4],[56,2,56,4],[57,0,57,4],[61,1,61,2],[61,3,61,4],[47,2,49,4],[50,0,50,4],[43,2,43,4],[44,2,44,4],[37,0,37,4],[18,0,18,1],[19,0,19,1],[27,0,27,1],[30,3,30,4],[29,3,29,4],[28,3,28,4],[32,0,32,1],[31,0,31,1],[30,0,30,1],[28,0,28,1],[29,0,29,1]]}
["13-07-10-form/Préparation pompe PCA - Feuille de calcul DMAJ le 160919",null,"PREPARATION                          POMPE                                      RYTHMIC                                     "]
[null,"Nom","Date",{"$f":"TODAY()","v":"2020-12-30"},null,null,"MISE A ZERO"]
[null,"Prenom","Prescripteur",null,null,null,null,{"$f":"CONCATENATE(A2,\"-\",A3,\"-PCA du \",TEXT(D2,\"-jj-mm-aaaa\"),\" par \",D4)","v":"--PCA du -30-12-2020 par "}]
["Coller etiquette",null,"Calculateur"]
["PRESCRIPTION"]
["VOIE D'ADMINISTRATION",null,"PRODUIT"]
[null,null,"Morphine"]
["DOSE CONTINUE "]
[null,"mg/24h",null,"mg/h"]
["Calcul débit continu ",null,"Calcul dose continue/24 h"]
[{"$f":"A9/24","v":0},"mg/h",{"$f":"C9*24","v":0},"mg/24h"]
["BOLUS"]
["Dose ",null,"mg"]
["Periode refractaire",null,"heure",null,"minutes"]
["Limitation nombre bolus",null,"/24h",{"$f":"(B14*60)+D14","v":0}]
["Calcul Nb bolus maximum/24h selon periode refractaire",null,null,{"$f":"(1440/((B14*60)+D14))","v":{"$error":"#DIV/0!"}}]
["Calcul dose bolus maximale necessaire/24h",null,null,{"$f":"IF(B15>0,(B15*B13),(D16*B13))","v":{"$error":"#DIV/0!"}},"mg"]
["POCHE DE PERFUSION"]
["Dose ampoule ",null,100,"mg"]
["Volume ampoule ",null,10,"ml"]
["Volume poche de perfusion",null,200,"ml"]
["Durée  de perfusion souhaitée en jours"]
["CALCULS"]
["Dose totale continue",null,{"$f":"IF(C11=0,A9,C11)","v":0},"mg"]
["Dose totale bolus",null,{"$f":"D17","v":{"$error":"#DIV/0!"}},"mg"]
["Dose totale continue + bolus",null,{"$f":"C24+C25","v":{"$error":"#DIV/0!"}},"mg"]
["Dose totale minimale poche perfusion",null,{"$f":"C26*C22","v":{"$error":"#DIV/0!"}},"mg"]
["Nombre ampoules necessaire",null,{"$f":"ROUNDUP(C27/C19,0)","v":{"$error":"#DIV/0!"}}]
["Dose totale réelle poche perfusion",null,{"$f":"C28*C19","v":{"$error":"#DIV/0!"}},"mg"]
["Volume totale des ampoules",null,{"$f":"C20*C28","v":{"$error":"#DIV/0!"}},"ml"]
["Concentration finale ",null,{"$f":"C29/C21","v":{"$error":"#DIV/0!"}},"mg/ml"]
["Calcul debit de base ",null,{"$f":"IF(C9<>0,C9,A11)/C31","v":{"$error":"#DIV/0!"}},"ml/heure","IV>0,3"]
["Calcul volume bolus",null,{"$f":"B13/C31","v":{"$error":"#DIV/0!"}},"ml ","SC<2"]
[]
[]
[]
["13-07-10-form/Préparation pompe PCA - Feuille de calcul DMAJ le 160919",null,"PREPARATION                          POMPE                                      RYTHMIC                                          "]
["PREPARATION POCHE DE PERFUSION"]
["PRODUIT DE PERFUSION"]
["Produit",{"$f":"C7","v":"Morphine"}]
["Dose ampoule ",{"$f":"C19","v":100},"mg            dans",{"$f":"C20","v":10},"ml"]
["Nombre d'ampoules à mettre",{"$f":"C28","v":{"$error":"#DIV/0!"}},"volume",{"$f":"B42*D41","v":{"$error":"#DIV/0!"}},"ml"]
["SOLUTE DE PERFUSION"]
["Volume a ajouter",{"$f":"C21-(C28*C20)","v":{"$error":"#DIV/0!"}},"ml"]
["Volume final",{"$f":"B44+(B42*D41)","v":{"$error":"#DIV/0!"}},"ml"]
["PROGRAMMATION POMPE "]
["Code sélection mode perfusion","0112","par défaut programmée continu + bolus"]
["Code programmation","0111","Pour toute modification de  programmation après le commencement de la perfusion, mettre la pompe en pause"]
["Code changement de poche","0011"]
["Code ré-démarrage  après OFF","0000"]
[]
["CONCENTRATION",{"$f":"C31","v":{"$error":"#DIV/0!"}},"mg/ml"]
["DEBIT",{"$f":"C24/24","v":0},"mg/heure"]
["BOLUS",{"$f":"B13","v":0},"mg"]
["PERIODE REFRACTAIRE",{"$f":"D15","v":0},"minutes"]
["CHOISIR LIMITE",{"$f":"B15/6","v":0},"bolus/4 h"]
["VOLUME A PERFUSER",{"$f":"C21","v":200},"ml"]
["CONTRÔLE VALIDITE DES CALCULS"]
["Je soussigné, certifie avoir controlé la validité des calculs effectués pour la programmation de la pompe de",null,"Nom-Prenom IDE"]
[]
[]
["Monsieur - Madame",{"$f":"A2","v":0},null,{"$f":"A3","v":0}]
["en rapport avec la prescription du",null,{"$f":"D3","v":0}]
["Date","Signature"]

{"sheet":"Feuil2","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["sous-cutanée","Morphine"]
["intra-veineuse","Oxycodone"]
[null,"Midazolam"]