{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["メニュー","食札印刷","栄養士メモ_期間食止め情報など","5月31日夕"],"not_rendered":{"charts":0,"images":0,"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":"メニュー","index":0,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[[5,5,5,13]]}
[]
[null,null,"食札印刷用プログラム",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V202403251"]
[]
[null,null,"指定のデータシートから食札印刷シートにコピーするプログラムが入っています"]
[null,null,"印刷したいシート名を記入して作成ボタンをおしてください"]
[null,null,"シート名",null,null,"5月31日夕"]
[]
[null,"【食事箋データの記入】"]
[null,null,"新しい食事箋データは以前の最新シートをコピーして作成してください。"]
[null,null,"シート名を「(日付)と(区分1文字)」のパタンで入力してください"]
[]
[null,"【注意事項】"]
[null,"メニューsheet"]
[null,null,"本メニューシートはシート名を記入するF6セルは行列共に変更しないでください"]
[null,"各データのsheet"]
[null,null,"処理はB列の4行目より、連番(B列)に数値が入っている行の間を処理します"]
[null,null,"B列行に「空白」が存在するとそこで処理は終了します。"]
[null,null,"フィルタをかけた場合、表示行だけを処理します"]
[null,null,"AからF列までの値とO列を取得して処理していますのでその列は変更しないでください"]
[null,null,"A2とC2セルはシート名から自動表示しています。変更しないでください。"]
[null,"食札印刷sheet"]
[null,null,"1行目から5行目までを雛形として処理しています"]

{"sheet":"食札印刷","index":1,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6],[3,2,3,3],[3,6,3,7],[11,1,11,2],[11,5,11,6],[13,2,13,3],[13,6,13,7],[8,2,8,3],[8,6,8,7],[26,1,26,2],[26,5,26,6],[28,2,28,3],[28,6,28,7],[23,2,23,3],[23,6,23,7],[6,1,6,2],[6,5,6,6],[36,1,36,2],[36,5,36,6],[38,2,38,3],[38,6,38,7],[33,2,33,3],[33,6,33,7],[31,1,31,2],[31,5,31,6],[16,1,16,2],[16,5,16,6],[18,2,18,3],[18,6,18,7],[21,1,21,2],[21,5,21,6]]}
[null,null,null,1,null,null,null,2]
[null,null,null,"様",null,null,null,"様"]
[null,"コード",null,"薬：有・無",null,"コード",null,"薬：有・無"]
[null,"水分：",null,null,null,"水分："]
[null,"主/副\n /",null,null,null,"主/副\n /"]
[null,null,null,3,null,null,null,4]
[null,null,null,"様",null,null,null,"様"]
[null,"コード",null,"薬：有・無",null,"コード",null,"薬：有・無"]
[null,"水分：",null,null,null,"水分："]
[null,"主/副\n /",null,null,null,"主/副\n /"]
[null,null,null,5,null,null,null,6]
[null,null,null,"様",null,null,null,"様"]
[null,"コード",null,"薬：有・無",null,"コード",null,"薬：有・無"]
[null,"水分：",null,null,null,"水分："]
[null,"主/副\n /",null,null,null,"主/副\n /"]
[null,null,null,7,null,null,null,8]
[null,null,null,"様",null,null,null,"様"]
[null,"コード",null,"薬：有・無",null,"コード",null,"薬：有・無"]
[null,"水分：",null,null,null,"水分："]
[null,"主/副\n /",null,null,null,"主/副\n /"]
[null,null,null,9,null,null,null,10]
[null,null,null,"様",null,null,null,"様"]
[null,"コード",null,"薬：有・無",null,"コード",null,"薬：有・無"]
[null,"水分：",null,null,null,"水分："]
[null,"主/副\n /","5月31日(土)","夕",null,"主/副\n /","5月31日(土)","夕"]
[null,null,null,11,null,null,null,12]
[null,null,null,"様",null,null,null,"様"]
[null,"コード",null,"薬：有・無",null,"コード",null,"薬：有・無"]
[null,"水分：",null,null,null,"水分："]
[null,"主/副\n /","5月31日(土)","夕",null,"主/副\n /","5月31日(土)","夕"]
[null,null,null,13,null,null,null,14]
[null,null,null,"様",null,null,null,"様"]
[null,"コード",null,"薬：有・無",null,"コード",null,"薬：有・無"]
[null,"水分：",null,null,null,"水分："]
[null,"主/副\n /","5月31日(土)","夕",null,"主/副\n /","5月31日(土)","夕"]
[null,null,null,15,null,null,null,16]
[null,null,null,"様",null,null,null,"様"]
[null,"コード",null,"薬：有・無",null,"コード",null,"薬：有・無"]
[null,"水分：",null,null,null,"水分："]
[null,"主/副\n /","5月31日(土)","夕",null,"主/副\n /","5月31日(土)","夕"]

{"sheet":"栄養士メモ_期間食止め情報など","index":2,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[0,"連番","ブロック","部屋","名前","食形態","発行日","オーダー開始日","区分","生年月日","年齢","食形態２\nマルチ","食形態2\nサブ","食形態2\n合計","備　考","外出・外泊など記録"]

{"sheet":"5月31日夕","index":3,"n_rows":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1]]}
["日付",null,"区分","人数","平均年齢","食数合計","濃厚\n合計",null,"食形態1j\nマルチ","食形態1j\nサブ","食形態1j\n合計",null,"食形態2\nサブ","食形態2\n合計",null,"食形態3","食形態4","食形態普米"]
[{"$f":"SUBSTITUTE((RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),(RIGHT(CELL(\"filename\",A1),1)),\"\")","v":"5月31日"},null,{"$f":"RIGHT(CELL(\"filename\",A1),1)","v":"夕"},{"$f":"COUNTA(D4:D118)","v":0},{"$f":"AVERAGE(K4:K34)","v":{"$error":"#DIV/0!"}},{"$f":"G2+K2+N2+P2+Q2+R2","v":0},{"$f":"COUNTIFS($C$4:C34,\"サ\",$F$4:$F34,\"濃\")","v":0},null,{"$f":"COUNTIFS($C$4:C34,\"マ\",$F$4:F34,\"j\")","v":0},{"$f":"COUNTIFS($C$4:C34,\"サ\",$F$4:F34,\"j\")","v":0},{"$f":"I2+J2","v":0},{"$f":"COUNTIFS($C$4:C34,\"マ\",$F$4:F34,2)","v":0},{"$f":"COUNTIFS($C$4:C34,\"サ\",$F$4:F34,2)","v":0},{"$f":"L2+M2","v":0},{"$f":"COUNTIFS($C$4:C34,\"マ\",$F$4:F34,3)","v":0},{"$f":"COUNTIFS($C$4:C34,\"サ\",$F$4:F34,3)","v":0},{"$f":"COUNTIFS($C$4:C34,\"サ\",$F$4:F34,\"4\")","v":0},{"$f":"COUNTIFS($C4:$C34,\"サ\",F4:F34,\"普米\")","v":0}]
[0,"連番","ブロック","部屋","名前","食形態","発行日","オーダー開始日","区分","生年月日","年齢","褥瘡","主食摂取量","副食摂取量","備　考"]
[1,1]
[2,2]
[3,3]
[4,4]
[5,5]
[6,6]
[7,7]
[8,8]
[9,9]
[10,10]
[11,11]
[12,12]
[13,13]
[14,14]
[15,15]
[16,16]