{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["MD_2007_Simulate"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"MD_2007_Simulate","index":0,"n_rows":34,"n_cols":44,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["2000-01-05",2003,1,2,3,4,5,6,7,8,9,10,11,12,null,null,{"$f":"B1","v":2003},1,2,3,4,5,6,7,8,9,10,11,12,null,null,{"$f":"B1","v":2003},1,2,3,4,5,6,7,8,9,10,11,12]
["[ ] ： by XL2007",1,{"$f":"\"[\"&R2&\"]  (\"&AG2&\")\"","v":"[27]  (27)"},{"$f":"\"[\"&S2&\"]  (\"&AH2&\")\"","v":"[24]  (27)"},"[27]  (27)","[26]  (27)","[27]  (27)","[26]  (27)","[27]  (27)","[27]  (27)","[26]  (27)","[27]  (27)","[26]  (27)","[27]  (27)",null,null,1,{"$f":"DATEDIF($A$1,DATE($B$1,$C$1,$B2),\"md\")","v":27},{"$f":"DATEDIF($A$1,DATE($B$1,$D$1,$B2),\"md\")","v":24},{"$f":"DATEDIF($A$1,DATE($B$1,$E$1,$B2),\"md\")","v":27},{"$f":"DATEDIF($A$1,DATE($B$1,$F$1,$B2),\"md\")","v":26},{"$f":"DATEDIF($A$1,DATE($B$1,$G$1,$B2),\"md\")","v":27},{"$f":"DATEDIF($A$1,DATE($B$1,$H$1,$B2),\"md\")","v":26},{"$f":"DATEDIF($A$1,DATE($B$1,$I$1,$B2),\"md\")","v":27},{"$f":"DATEDIF($A$1,DATE($B$1,$J$1,$B2),\"md\")","v":27},{"$f":"DATEDIF($A$1,DATE($B$1,$K$1,$B2),\"md\")","v":26},{"$f":"DATEDIF($A$1,DATE($B$1,$L$1,$B2),\"md\")","v":27},{"$f":"DATEDIF($A$1,DATE($B$1,$M$1,$B2),\"md\")","v":26},{"$f":"DATEDIF($A$1,DATE($B$1,$N$1,$B2),\"md\")","v":27},null,null,1,{"$f":"DATEDIF2007MD($A$1,DATE($B$1,$C$1,$B2))","v":27},{"$f":"DATEDIF2007MD($A$1,DATE($B$1,$D$1,$B2))","v":27},{"$f":"DATEDIF2007MD($A$1,DATE($B$1,$E$1,$B2))","v":27},{"$f":"DATEDIF2007MD($A$1,DATE($B$1,$F$1,$B2))","v":27},{"$f":"DATEDIF2007MD($A$1,DATE($B$1,$G$1,$B2))","v":27},{"$f":"DATEDIF2007MD($A$1,DATE($B$1,$H$1,$B2))","v":27},{"$f":"DATEDIF2007MD($A$1,DATE($B$1,$I$1,$B2))","v":27},{"$f":"DATEDIF2007MD($A$1,DATE($B$1,$J$1,$B2))","v":27},{"$f":"DATEDIF2007MD($A$1,DATE($B$1,$K$1,$B2))","v":27},{"$f":"DATEDIF2007MD($A$1,DATE($B$1,$L$1,$B2))","v":27},{"$f":"DATEDIF2007MD($A$1,DATE($B$1,$M$1,$B2))","v":27},{"$f":"DATEDIF2007MD($A$1,DATE($B$1,$N$1,$B2))","v":27}]
["( ) ： シュミレート",2,{"$f":"\"[\"&R3&\"]  (\"&AG3&\")\"","v":"[28]  (28)"},{"$f":"\"[\"&S3&\"]  (\"&AH3&\")\"","v":"[25]  (28)"},{"$f":"\"[\"&T3&\"]  (\"&AI3&\")\"","v":"[28]  (28)"},{"$f":"\"[\"&U3&\"]  (\"&AJ3&\")\"","v":"[27]  (28)"},{"$f":"\"[\"&V3&\"]  (\"&AK3&\")\"","v":"[28]  (28)"},{"$f":"\"[\"&W3&\"]  (\"&AL3&\")\"","v":"[27]  (28)"},{"$f":"\"[\"&X3&\"]  (\"&AM3&\")\"","v":"[28]  (28)"},{"$f":"\"[\"&Y3&\"]  (\"&AN3&\")\"","v":"[28]  (28)"},{"$f":"\"[\"&Z3&\"]  (\"&AO3&\")\"","v":"[27]  (28)"},{"$f":"\"[\"&AA3&\"]  (\"&AP3&\")\"","v":"[28]  (28)"},{"$f":"\"[\"&AB3&\"]  (\"&AQ3&\")\"","v":"[27]  (28)"},{"$f":"\"[\"&AC3&\"]  (\"&AR3&\")\"","v":"[28]  (28)"},null,null,2,28,25,28,27,28,27,28,28,27,28,27,28,null,null,2,28,28,28,28,28,28,28,28,28,28,28,28]
[null,3,"[29]  (29)","[26]  (29)","[29]  (29)","[28]  (29)","[29]  (29)","[28]  (29)","[29]  (29)","[29]  (29)","[28]  (29)","[29]  (29)","[28]  (29)","[29]  (29)",null,null,3,29,26,29,28,29,28,29,29,28,29,28,29,null,null,3,29,29,29,29,29,29,29,29,29,29,29,29]
[null,4,"[30]  (30)","[27]  (30)","[30]  (30)","[29]  (30)","[30]  (30)","[29]  (30)","[30]  (30)","[30]  (30)","[29]  (30)","[30]  (30)","[29]  (30)","[30]  (30)",null,null,4,30,27,30,29,30,29,30,30,29,30,29,30,null,null,4,30,30,30,30,30,30,30,30,30,30,30,30]
[null,5,"[0]  (0)","[0]  (0)","[0]  (0)","[0]  (0)","[0]  (0)","[0]  (0)","[0]  (0)","[0]  (0)","[0]  (0)","[0]  (0)","[0]  (0)","[0]  (0)",null,null,5,0,0,0,0,0,0,0,0,0,0,0,0,null,null,5,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,"[1]  (1)","[1]  (1)","[1]  (1)","[1]  (1)","[1]  (1)","[1]  (1)","[1]  (1)","[1]  (1)","[1]  (1)","[1]  (1)","[1]  (1)","[1]  (1)",null,null,6,1,1,1,1,1,1,1,1,1,1,1,1,null,null,6,1,1,1,1,1,1,1,1,1,1,1,1]
[null,7,"[2]  (2)","[2]  (2)","[2]  (2)","[2]  (2)","[2]  (2)","[2]  (2)","[2]  (2)","[2]  (2)","[2]  (2)","[2]  (2)","[2]  (2)","[2]  (2)",null,null,7,2,2,2,2,2,2,2,2,2,2,2,2,null,null,7,2,2,2,2,2,2,2,2,2,2,2,2]
[null,8,"[3]  (3)","[3]  (3)","[3]  (3)","[3]  (3)","[3]  (3)","[3]  (3)","[3]  (3)","[3]  (3)","[3]  (3)","[3]  (3)","[3]  (3)","[3]  (3)",null,null,8,3,3,3,3,3,3,3,3,3,3,3,3,null,null,8,3,3,3,3,3,3,3,3,3,3,3,3]
["赤字が不一致",9,"[4]  (4)","[4]  (4)","[4]  (4)","[4]  (4)","[4]  (4)","[4]  (4)","[4]  (4)","[4]  (4)","[4]  (4)","[4]  (4)","[4]  (4)","[4]  (4)",null,null,9,4,4,4,4,4,4,4,4,4,4,4,4,null,null,9,4,4,4,4,4,4,4,4,4,4,4,4]
[null,10,"[5]  (5)","[5]  (5)","[5]  (5)","[5]  (5)","[5]  (5)","[5]  (5)","[5]  (5)","[5]  (5)","[5]  (5)","[5]  (5)","[5]  (5)","[5]  (5)",null,null,10,5,5,5,5,5,5,5,5,5,5,5,5,null,null,10,5,5,5,5,5,5,5,5,5,5,5,5]
[null,11,"[6]  (6)","[6]  (6)","[6]  (6)","[6]  (6)","[6]  (6)","[6]  (6)","[6]  (6)","[6]  (6)","[6]  (6)","[6]  (6)","[6]  (6)","[6]  (6)",null,null,11,6,6,6,6,6,6,6,6,6,6,6,6,null,null,11,6,6,6,6,6,6,6,6,6,6,6,6]
[null,12,"[7]  (7)","[7]  (7)","[7]  (7)","[7]  (7)","[7]  (7)","[7]  (7)","[7]  (7)","[7]  (7)","[7]  (7)","[7]  (7)","[7]  (7)","[7]  (7)",null,null,12,7,7,7,7,7,7,7,7,7,7,7,7,null,null,12,7,7,7,7,7,7,7,7,7,7,7,7]
[null,13,"[8]  (8)","[8]  (8)","[8]  (8)","[8]  (8)","[8]  (8)","[8]  (8)","[8]  (8)","[8]  (8)","[8]  (8)","[8]  (8)","[8]  (8)","[8]  (8)",null,null,13,8,8,8,8,8,8,8,8,8,8,8,8,null,null,13,8,8,8,8,8,8,8,8,8,8,8,8]
[null,14,"[9]  (9)","[9]  (9)","[9]  (9)","[9]  (9)","[9]  (9)","[9]  (9)","[9]  (9)","[9]  (9)","[9]  (9)","[9]  (9)","[9]  (9)","[9]  (9)",null,null,14,9,9,9,9,9,9,9,9,9,9,9,9,null,null,14,9,9,9,9,9,9,9,9,9,9,9,9]
["[A1][B1]入力可",15,"[10]  (10)","[10]  (10)","[10]  (10)","[10]  (10)","[10]  (10)","[10]  (10)","[10]  (10)","[10]  (10)","[10]  (10)","[10]  (10)","[10]  (10)","[10]  (10)",null,null,15,10,10,10,10,10,10,10,10,10,10,10,10,null,null,15,10,10,10,10,10,10,10,10,10,10,10,10]
[null,16,"[11]  (11)","[11]  (11)","[11]  (11)","[11]  (11)","[11]  (11)","[11]  (11)","[11]  (11)","[11]  (11)","[11]  (11)","[11]  (11)","[11]  (11)","[11]  (11)",null,null,16,11,11,11,11,11,11,11,11,11,11,11,11,null,null,16,11,11,11,11,11,11,11,11,11,11,11,11]
[null,17,"[12]  (12)","[12]  (12)","[12]  (12)","[12]  (12)","[12]  (12)","[12]  (12)","[12]  (12)","[12]  (12)","[12]  (12)","[12]  (12)","[12]  (12)","[12]  (12)",null,null,17,12,12,12,12,12,12,12,12,12,12,12,12,null,null,17,12,12,12,12,12,12,12,12,12,12,12,12]
[null,18,"[13]  (13)","[13]  (13)","[13]  (13)","[13]  (13)","[13]  (13)","[13]  (13)","[13]  (13)","[13]  (13)","[13]  (13)","[13]  (13)","[13]  (13)","[13]  (13)",null,null,18,13,13,13,13,13,13,13,13,13,13,13,13,null,null,18,13,13,13,13,13,13,13,13,13,13,13,13]
[null,19,"[14]  (14)","[14]  (14)","[14]  (14)","[14]  (14)","[14]  (14)","[14]  (14)","[14]  (14)","[14]  (14)","[14]  (14)","[14]  (14)","[14]  (14)","[14]  (14)",null,null,19,14,14,14,14,14,14,14,14,14,14,14,14,null,null,19,14,14,14,14,14,14,14,14,14,14,14,14]
[null,20,"[15]  (15)","[15]  (15)","[15]  (15)","[15]  (15)","[15]  (15)","[15]  (15)","[15]  (15)","[15]  (15)","[15]  (15)","[15]  (15)","[15]  (15)","[15]  (15)",null,null,20,15,15,15,15,15,15,15,15,15,15,15,15,null,null,20,15,15,15,15,15,15,15,15,15,15,15,15]
[null,21,"[16]  (16)","[16]  (16)","[16]  (16)","[16]  (16)","[16]  (16)","[16]  (16)","[16]  (16)","[16]  (16)","[16]  (16)","[16]  (16)","[16]  (16)","[16]  (16)",null,null,21,16,16,16,16,16,16,16,16,16,16,16,16,null,null,21,16,16,16,16,16,16,16,16,16,16,16,16]
[null,22,"[17]  (17)","[17]  (17)","[17]  (17)","[17]  (17)","[17]  (17)","[17]  (17)","[17]  (17)","[17]  (17)","[17]  (17)","[17]  (17)","[17]  (17)","[17]  (17)",null,null,22,17,17,17,17,17,17,17,17,17,17,17,17,null,null,22,17,17,17,17,17,17,17,17,17,17,17,17]
["下記で試す",23,"[18]  (18)","[18]  (18)","[18]  (18)","[18]  (18)","[18]  (18)","[18]  (18)","[18]  (18)","[18]  (18)","[18]  (18)","[18]  (18)","[18]  (18)","[18]  (18)",null,null,23,18,18,18,18,18,18,18,18,18,18,18,18,null,null,23,18,18,18,18,18,18,18,18,18,18,18,18]
["2000/1/5～",24,"[19]  (19)","[19]  (19)","[19]  (19)","[19]  (19)","[19]  (19)","[19]  (19)","[19]  (19)","[19]  (19)","[19]  (19)","[19]  (19)","[19]  (19)","[19]  (19)",null,null,24,19,19,19,19,19,19,19,19,19,19,19,19,null,null,24,19,19,19,19,19,19,19,19,19,19,19,19]
["2000/1/31～",25,"[20]  (20)","[20]  (20)","[20]  (20)","[20]  (20)","[20]  (20)","[20]  (20)","[20]  (20)","[20]  (20)","[20]  (20)","[20]  (20)","[20]  (20)","[20]  (20)",null,null,25,20,20,20,20,20,20,20,20,20,20,20,20,null,null,25,20,20,20,20,20,20,20,20,20,20,20,20]
[null,26,"[21]  (21)","[21]  (21)","[21]  (21)","[21]  (21)","[21]  (21)","[21]  (21)","[21]  (21)","[21]  (21)","[21]  (21)","[21]  (21)","[21]  (21)","[21]  (21)",null,null,26,21,21,21,21,21,21,21,21,21,21,21,21,null,null,26,21,21,21,21,21,21,21,21,21,21,21,21]
[null,27,"[22]  (22)","[22]  (22)","[22]  (22)","[22]  (22)","[22]  (22)","[22]  (22)","[22]  (22)","[22]  (22)","[22]  (22)","[22]  (22)","[22]  (22)","[22]  (22)",null,null,27,22,22,22,22,22,22,22,22,22,22,22,22,null,null,27,22,22,22,22,22,22,22,22,22,22,22,22]
[null,28,"[23]  (23)","[23]  (23)","[23]  (23)","[23]  (23)","[23]  (23)","[23]  (23)","[23]  (23)","[23]  (23)","[23]  (23)","[23]  (23)","[23]  (23)","[23]  (23)",null,null,28,23,23,23,23,23,23,23,23,23,23,23,23,null,null,28,23,23,23,23,23,23,23,23,23,23,23,23]
[null,29,"[24]  (24)","[]  ()","[24]  (24)","[24]  (24)","[24]  (24)","[24]  (24)","[24]  (24)","[24]  (24)","[24]  (24)","[24]  (24)","[24]  (24)","[24]  (24)",null,null,29,24,{"$f":"IF(MONTH(DATE($B$1,$D$1,$B30))=2,DATEDIF($A$1,DATE($B$1,$D$1,$B30),\"md\"),\"\")","v":""},24,24,24,24,24,24,24,24,24,24,null,null,29,24,{"$f":"IF(MONTH(DATE($B$1,$D$1,$B30))=2,DATEDIF2007MD($A$1,DATE($B$1,$D$1,$B30)),\"\")","v":""},24,24,24,24,24,24,24,24,24,24]
[null,30,"[25]  (25)",null,"[25]  (25)","[25]  (25)","[25]  (25)","[25]  (25)","[25]  (25)","[25]  (25)","[25]  (25)","[25]  (25)","[25]  (25)","[25]  (25)",null,null,30,25,null,25,25,25,25,25,25,25,25,25,25,null,null,30,25,null,25,25,25,25,25,25,25,25,25,25]
[null,31,"[26]  (26)",null,"[26]  (26)",null,"[26]  (26)",null,"[26]  (26)","[26]  (26)",null,"[26]  (26)",null,"[26]  (26)",null,null,31,26,null,26,null,26,null,26,26,null,26,null,26,null,null,31,26,null,26,null,26,null,26,26,null,26,null,26]
[]
[null,"Excel2007 DATEDIF(MD) ロジックのシミュレーション ( by AddinBox )"]