{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["建玉練習"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"建玉練習","index":0,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,"トレード練習　損益計算シート ver2.04",null,null,null,null,null,null,null,null,null,null,"銘柄コード：","1001",{"$f":"kname($N$1)","v":"日経225"},null,null,null,"時間軸：","日足"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"約定モード（1=当引、2=翌寄）：",2]
[null,null,null,null,null,null,null,"繰越建数：",null,null,"開始日：","2019-01-01",null,null,null,null,null,null,"１枚あたりの倍率 ：",100]
[null,null,null,null,null,null,null,0,0,null,"開始残高：",0,"繰越建残：",0,0,null,null,null,"１枚あたりの往復手数料 ：",2000]
[]
[null,"No.","日付","曜","ロ足","下髭","上髭","売建","買建","売注","買注","当日終値","翌日始値","売平均値","買平均値","売損益","買損益","手数料","評価損益","残高"]
[null,1,{"$f":"L3","v":"2019-01-01"},{"$f":"IF(OR(H7=\"\",I7=\"\"),\"\", WEEKDAY(C7))","v":""},{"$f":"IF(OR(H7=\"\",I7=\"\"),\"\", hike($N$1,$C7) - yori($N$1,$C7))","v":""},{"$f":"IF(OR(H7=\"\",I7=\"\"),\"\", IF(yori($N$1,$C7) < hike($N$1,$C7), yori($N$1,$C7) - yasu($N$1,$C7), hike($N$1,$C7) - yasu($N$1,$C7) ) )","v":""},{"$f":"IF(OR(H7=\"\",I7=\"\"),\"\", IF(yori($N$1,$C7) < hike($N$1,$C7), taka($N$1,$C7) - hike($N$1,$C7), taka($N$1,$C7) - yori($N$1,$C7) ) )","v":""},null,null,{"$f":"IF(OR(H7=\"\",I7=\"\"),\"\",  H7-H$4)","v":""},{"$f":"IF(OR(I7=\"\",J7=\"\"),\"\",  I7-I$4)","v":""},{"$f":"IF(OR(H7=\"\",I7=\"\"),\"\", hike($N$1,$C7))","v":""},{"$f":"IF(OR(H7=\"\",I7=\"\"),\"\", yokuyori($N$1,$C7))","v":""},{"$f":"IF(OR($H7=\"\",$I7=\"\"),\"\",  IF(H7=0, N4, IF(J7<=0,N4, INT(( (N4*H4) + (CHOOSE($T$2,L7,M7)*J7) )/H7 ) ) ) )","v":""},{"$f":"IF(OR($H7=\"\",$I7=\"\"),\"\",  IF(I7=0, O4, IF(K7<=0,O4, INT(( (O4*I4) + (CHOOSE($T$2,L7,M7)*K7) )/I7 ) ) ) )","v":""},{"$f":"IF(OR(H7=\"\",I7=\"\"),\"\", IF(N7=0,0,IF(J7<0,(N7*ABS(J7))-(CHOOSE($T$2,L7,M7)*ABS(J7)),0)))","v":""},{"$f":"IF(OR(H7=\"\",I7=\"\"),\"\", IF(O7=0,0,IF(K7<0,(CHOOSE($T$2,L7,M7)*ABS(K7))-(O7*ABS(K7)),0)))","v":""},{"$f":"IF(OR(H7=\"\",I7=\"\"),\"\", $T$4*(IF(J7<0, ABS(J7),0) + IF(K7<0,ABS(K7),0)))","v":""},{"$f":"IF(OR(H7=\"\",I7=\"\"),\"\", ( IF(N7=0,0, (N7*ABS(H7)) - (CHOOSE($T$2,L7,M7)*ABS(H7)) ) + IF(O7=0,0, (CHOOSE($T$2,L7,M7)*ABS(I7)) - (O7*ABS(I7)) ) )*$T$3)","v":""},{"$f":"IF(OR(H7=\"\",I7=\"\"),\"\", $L$4+ ((P7+Q7)*$T$3-R7) )","v":""}]
[null,2,{"$f":"IF(OR(H8=\"\",I8=\"\"),\"\", kdate($N$1,C7,1))","v":""},{"$f":"IF(OR(H8=\"\",I8=\"\"),\"\", WEEKDAY(C8))","v":""},{"$f":"IF(OR(H8=\"\",I8=\"\"),\"\", hike($N$1,$C8) - yori($N$1,$C8))","v":""},{"$f":"IF(OR(H8=\"\",I8=\"\"),\"\", IF(yori($N$1,$C8) < hike($N$1,$C8), yori($N$1,$C8) - yasu($N$1,$C8), hike($N$1,$C8) - yasu($N$1,$C8) ) )","v":""},{"$f":"IF(OR(H8=\"\",I8=\"\"),\"\", IF(yori($N$1,$C8) < hike($N$1,$C8), taka($N$1,$C8) - hike($N$1,$C8), taka($N$1,$C8) - yori($N$1,$C8) ) )","v":""},null,null,{"$f":"IF(OR(H8=\"\",I8=\"\"),\"\",  H8-H7)","v":""},{"$f":"IF(OR(H8=\"\",I8=\"\"),\"\", I8-I7)","v":""},{"$f":"IF(OR(H8=\"\",I8=\"\"),\"\", hike($N$1,$C8))","v":""},{"$f":"IF(OR(H8=\"\",I8=\"\"),\"\", yokuyori($N$1,$C8))","v":""},{"$f":"IF(OR($H8=\"\",$I8=\"\"),\"\",  IF(H8=0, N7, IF(J8<=0,N7, INT(( (N7*H7) + (CHOOSE($T$2,L8,M8)*J8) )/H8 ) ) ) )","v":""},{"$f":"IF(OR($H8=\"\",$I8=\"\"),\"\",  IF(I8=0, O7, IF(K8<=0,O7, INT(( (O7*I7) + (CHOOSE($T$2,L8,M8)*K8) )/I8 ) ) ) )","v":""},{"$f":"IF(OR(H8=\"\",I8=\"\"),\"\", IF(N8=0,0,IF(J8<0,(N8*ABS(J8))-(CHOOSE($T$2,L8,M8)*ABS(J8)),0)))","v":""},{"$f":"IF(OR(H8=\"\",I8=\"\"),\"\", IF(O8=0,0,IF(K8<0,(CHOOSE($T$2,L8,M8)*ABS(K8))-(O8*ABS(K8)),0)))","v":""},"",{"$f":"IF(OR(H8=\"\",I8=\"\"),\"\", ( IF(N8=0,0, (N8*ABS(H8)) - (CHOOSE($T$2,L8,M8)*ABS(H8)) ) + IF(O8=0,0, (CHOOSE($T$2,L8,M8)*ABS(I8)) - (O8*ABS(I8)) ) )*$T$3)","v":""},{"$f":"IF(OR(H8=\"\",I8=\"\"),\"\", T7+ ((P8+Q8)*$T$3-R8) )","v":""}]
[null,3,{"$f":"IF(OR(H9=\"\",I9=\"\"),\"\", kdate($N$1,C8,1))","v":""},"",{"$f":"IF(OR(H9=\"\",I9=\"\"),\"\", hike($N$1,$C9) - yori($N$1,$C9))","v":""},{"$f":"IF(OR(H9=\"\",I9=\"\"),\"\", IF(yori($N$1,$C9) < hike($N$1,$C9), yori($N$1,$C9) - yasu($N$1,$C9), hike($N$1,$C9) - yasu($N$1,$C9) ) )","v":""},{"$f":"IF(OR(H9=\"\",I9=\"\"),\"\", IF(yori($N$1,$C9) < hike($N$1,$C9), taka($N$1,$C9) - hike($N$1,$C9), taka($N$1,$C9) - yori($N$1,$C9) ) )","v":""},null,null,"","",{"$f":"IF(OR(H9=\"\",I9=\"\"),\"\", hike($N$1,$C9))","v":""},{"$f":"IF(OR(H9=\"\",I9=\"\"),\"\", yokuyori($N$1,$C9))","v":""},"","","","","","",""]
[null,4,{"$f":"IF(OR(H10=\"\",I10=\"\"),\"\", kdate($N$1,C9,1))","v":""},"",{"$f":"IF(OR(H10=\"\",I10=\"\"),\"\", hike($N$1,$C10) - yori($N$1,$C10))","v":""},{"$f":"IF(OR(H10=\"\",I10=\"\"),\"\", IF(yori($N$1,$C10) < hike($N$1,$C10), yori($N$1,$C10) - yasu($N$1,$C10), hike($N$1,$C10) - yasu($N$1,$C10) ) )","v":""},{"$f":"IF(OR(H10=\"\",I10=\"\"),\"\", IF(yori($N$1,$C10) < hike($N$1,$C10), taka($N$1,$C10) - hike($N$1,$C10), taka($N$1,$C10) - yori($N$1,$C10) ) )","v":""},null,null,"","",{"$f":"IF(OR(H10=\"\",I10=\"\"),\"\", hike($N$1,$C10))","v":""},{"$f":"IF(OR(H10=\"\",I10=\"\"),\"\", yokuyori($N$1,$C10))","v":""},"","","","","","",""]
[null,5,{"$f":"IF(OR(H11=\"\",I11=\"\"),\"\", kdate($N$1,C10,1))","v":""},"",{"$f":"IF(OR(H11=\"\",I11=\"\"),\"\", hike($N$1,$C11) - yori($N$1,$C11))","v":""},{"$f":"IF(OR(H11=\"\",I11=\"\"),\"\", IF(yori($N$1,$C11) < hike($N$1,$C11), yori($N$1,$C11) - yasu($N$1,$C11), hike($N$1,$C11) - yasu($N$1,$C11) ) )","v":""},{"$f":"IF(OR(H11=\"\",I11=\"\"),\"\", IF(yori($N$1,$C11) < hike($N$1,$C11), taka($N$1,$C11) - hike($N$1,$C11), taka($N$1,$C11) - yori($N$1,$C11) ) )","v":""},null,null,"","",{"$f":"IF(OR(H11=\"\",I11=\"\"),\"\", hike($N$1,$C11))","v":""},{"$f":"IF(OR(H11=\"\",I11=\"\"),\"\", yokuyori($N$1,$C11))","v":""},"","","","","","",""]
[null,6,{"$f":"IF(OR(H12=\"\",I12=\"\"),\"\", kdate($N$1,C11,1))","v":""},"",{"$f":"IF(OR(H12=\"\",I12=\"\"),\"\", hike($N$1,$C12) - yori($N$1,$C12))","v":""},{"$f":"IF(OR(H12=\"\",I12=\"\"),\"\", IF(yori($N$1,$C12) < hike($N$1,$C12), yori($N$1,$C12) - yasu($N$1,$C12), hike($N$1,$C12) - yasu($N$1,$C12) ) )","v":""},{"$f":"IF(OR(H12=\"\",I12=\"\"),\"\", IF(yori($N$1,$C12) < hike($N$1,$C12), taka($N$1,$C12) - hike($N$1,$C12), taka($N$1,$C12) - yori($N$1,$C12) ) )","v":""},null,null,"","",{"$f":"IF(OR(H12=\"\",I12=\"\"),\"\", hike($N$1,$C12))","v":""},{"$f":"IF(OR(H12=\"\",I12=\"\"),\"\", yokuyori($N$1,$C12))","v":""},"","","","","","",""]
[null,7,{"$f":"IF(OR(H13=\"\",I13=\"\"),\"\", kdate($N$1,C12,1))","v":""},"",{"$f":"IF(OR(H13=\"\",I13=\"\"),\"\", hike($N$1,$C13) - yori($N$1,$C13))","v":""},{"$f":"IF(OR(H13=\"\",I13=\"\"),\"\", IF(yori($N$1,$C13) < hike($N$1,$C13), yori($N$1,$C13) - yasu($N$1,$C13), hike($N$1,$C13) - yasu($N$1,$C13) ) )","v":""},{"$f":"IF(OR(H13=\"\",I13=\"\"),\"\", IF(yori($N$1,$C13) < hike($N$1,$C13), taka($N$1,$C13) - hike($N$1,$C13), taka($N$1,$C13) - yori($N$1,$C13) ) )","v":""},null,null,"","",{"$f":"IF(OR(H13=\"\",I13=\"\"),\"\", hike($N$1,$C13))","v":""},{"$f":"IF(OR(H13=\"\",I13=\"\"),\"\", yokuyori($N$1,$C13))","v":""},"","","","","","",""]
[null,8,{"$f":"IF(OR(H14=\"\",I14=\"\"),\"\", kdate($N$1,C13,1))","v":""},"",{"$f":"IF(OR(H14=\"\",I14=\"\"),\"\", hike($N$1,$C14) - yori($N$1,$C14))","v":""},{"$f":"IF(OR(H14=\"\",I14=\"\"),\"\", IF(yori($N$1,$C14) < hike($N$1,$C14), yori($N$1,$C14) - yasu($N$1,$C14), hike($N$1,$C14) - yasu($N$1,$C14) ) )","v":""},{"$f":"IF(OR(H14=\"\",I14=\"\"),\"\", IF(yori($N$1,$C14) < hike($N$1,$C14), taka($N$1,$C14) - hike($N$1,$C14), taka($N$1,$C14) - yori($N$1,$C14) ) )","v":""},null,null,"","",{"$f":"IF(OR(H14=\"\",I14=\"\"),\"\", hike($N$1,$C14))","v":""},{"$f":"IF(OR(H14=\"\",I14=\"\"),\"\", yokuyori($N$1,$C14))","v":""},"","","","","","",""]
[null,9,{"$f":"IF(OR(H15=\"\",I15=\"\"),\"\", kdate($N$1,C14,1))","v":""},"",{"$f":"IF(OR(H15=\"\",I15=\"\"),\"\", hike($N$1,$C15) - yori($N$1,$C15))","v":""},{"$f":"IF(OR(H15=\"\",I15=\"\"),\"\", IF(yori($N$1,$C15) < hike($N$1,$C15), yori($N$1,$C15) - yasu($N$1,$C15), hike($N$1,$C15) - yasu($N$1,$C15) ) )","v":""},{"$f":"IF(OR(H15=\"\",I15=\"\"),\"\", IF(yori($N$1,$C15) < hike($N$1,$C15), taka($N$1,$C15) - hike($N$1,$C15), taka($N$1,$C15) - yori($N$1,$C15) ) )","v":""},null,null,"","",{"$f":"IF(OR(H15=\"\",I15=\"\"),\"\", hike($N$1,$C15))","v":""},{"$f":"IF(OR(H15=\"\",I15=\"\"),\"\", yokuyori($N$1,$C15))","v":""},"","","","","","",""]
[null,10,{"$f":"IF(OR(H16=\"\",I16=\"\"),\"\", kdate($N$1,C15,1))","v":""},"",{"$f":"IF(OR(H16=\"\",I16=\"\"),\"\", hike($N$1,$C16) - yori($N$1,$C16))","v":""},{"$f":"IF(OR(H16=\"\",I16=\"\"),\"\", IF(yori($N$1,$C16) < hike($N$1,$C16), yori($N$1,$C16) - yasu($N$1,$C16), hike($N$1,$C16) - yasu($N$1,$C16) ) )","v":""},{"$f":"IF(OR(H16=\"\",I16=\"\"),\"\", IF(yori($N$1,$C16) < hike($N$1,$C16), taka($N$1,$C16) - hike($N$1,$C16), taka($N$1,$C16) - yori($N$1,$C16) ) )","v":""},null,null,"","",{"$f":"IF(OR(H16=\"\",I16=\"\"),\"\", hike($N$1,$C16))","v":""},{"$f":"IF(OR(H16=\"\",I16=\"\"),\"\", yokuyori($N$1,$C16))","v":""},"","","","","","",""]
[null,11,{"$f":"IF(OR(H17=\"\",I17=\"\"),\"\", kdate($N$1,C16,1))","v":""},"",{"$f":"IF(OR(H17=\"\",I17=\"\"),\"\", hike($N$1,$C17) - yori($N$1,$C17))","v":""},{"$f":"IF(OR(H17=\"\",I17=\"\"),\"\", IF(yori($N$1,$C17) < hike($N$1,$C17), yori($N$1,$C17) - yasu($N$1,$C17), hike($N$1,$C17) - yasu($N$1,$C17) ) )","v":""},{"$f":"IF(OR(H17=\"\",I17=\"\"),\"\", IF(yori($N$1,$C17) < hike($N$1,$C17), taka($N$1,$C17) - hike($N$1,$C17), taka($N$1,$C17) - yori($N$1,$C17) ) )","v":""},null,null,"","",{"$f":"IF(OR(H17=\"\",I17=\"\"),\"\", hike($N$1,$C17))","v":""},{"$f":"IF(OR(H17=\"\",I17=\"\"),\"\", yokuyori($N$1,$C17))","v":""},"","","","","","",""]
[null,12,{"$f":"IF(OR(H18=\"\",I18=\"\"),\"\", kdate($N$1,C17,1))","v":""},"",{"$f":"IF(OR(H18=\"\",I18=\"\"),\"\", hike($N$1,$C18) - yori($N$1,$C18))","v":""},{"$f":"IF(OR(H18=\"\",I18=\"\"),\"\", IF(yori($N$1,$C18) < hike($N$1,$C18), yori($N$1,$C18) - yasu($N$1,$C18), hike($N$1,$C18) - yasu($N$1,$C18) ) )","v":""},{"$f":"IF(OR(H18=\"\",I18=\"\"),\"\", IF(yori($N$1,$C18) < hike($N$1,$C18), taka($N$1,$C18) - hike($N$1,$C18), taka($N$1,$C18) - yori($N$1,$C18) ) )","v":""},null,null,"","",{"$f":"IF(OR(H18=\"\",I18=\"\"),\"\", hike($N$1,$C18))","v":""},{"$f":"IF(OR(H18=\"\",I18=\"\"),\"\", yokuyori($N$1,$C18))","v":""},"","","","","","",""]
[null,13,{"$f":"IF(OR(H19=\"\",I19=\"\"),\"\", kdate($N$1,C18,1))","v":""},"",{"$f":"IF(OR(H19=\"\",I19=\"\"),\"\", hike($N$1,$C19) - yori($N$1,$C19))","v":""},{"$f":"IF(OR(H19=\"\",I19=\"\"),\"\", IF(yori($N$1,$C19) < hike($N$1,$C19), yori($N$1,$C19) - yasu($N$1,$C19), hike($N$1,$C19) - yasu($N$1,$C19) ) )","v":""},{"$f":"IF(OR(H19=\"\",I19=\"\"),\"\", IF(yori($N$1,$C19) < hike($N$1,$C19), taka($N$1,$C19) - hike($N$1,$C19), taka($N$1,$C19) - yori($N$1,$C19) ) )","v":""},null,null,"","",{"$f":"IF(OR(H19=\"\",I19=\"\"),\"\", hike($N$1,$C19))","v":""},{"$f":"IF(OR(H19=\"\",I19=\"\"),\"\", yokuyori($N$1,$C19))","v":""},"","","","","","",""]
[null,14,{"$f":"IF(OR(H20=\"\",I20=\"\"),\"\", kdate($N$1,C19,1))","v":""},"",{"$f":"IF(OR(H20=\"\",I20=\"\"),\"\", hike($N$1,$C20) - yori($N$1,$C20))","v":""},{"$f":"IF(OR(H20=\"\",I20=\"\"),\"\", IF(yori($N$1,$C20) < hike($N$1,$C20), yori($N$1,$C20) - yasu($N$1,$C20), hike($N$1,$C20) - yasu($N$1,$C20) ) )","v":""},{"$f":"IF(OR(H20=\"\",I20=\"\"),\"\", IF(yori($N$1,$C20) < hike($N$1,$C20), taka($N$1,$C20) - hike($N$1,$C20), taka($N$1,$C20) - yori($N$1,$C20) ) )","v":""},null,null,"","",{"$f":"IF(OR(H20=\"\",I20=\"\"),\"\", hike($N$1,$C20))","v":""},{"$f":"IF(OR(H20=\"\",I20=\"\"),\"\", yokuyori($N$1,$C20))","v":""},"","","","","","",""]
[null,15,{"$f":"IF(OR(H21=\"\",I21=\"\"),\"\", kdate($N$1,C20,1))","v":""},"",{"$f":"IF(OR(H21=\"\",I21=\"\"),\"\", hike($N$1,$C21) - yori($N$1,$C21))","v":""},{"$f":"IF(OR(H21=\"\",I21=\"\"),\"\", IF(yori($N$1,$C21) < hike($N$1,$C21), yori($N$1,$C21) - yasu($N$1,$C21), hike($N$1,$C21) - yasu($N$1,$C21) ) )","v":""},{"$f":"IF(OR(H21=\"\",I21=\"\"),\"\", IF(yori($N$1,$C21) < hike($N$1,$C21), taka($N$1,$C21) - hike($N$1,$C21), taka($N$1,$C21) - yori($N$1,$C21) ) )","v":""},null,null,"","",{"$f":"IF(OR(H21=\"\",I21=\"\"),\"\", hike($N$1,$C21))","v":""},{"$f":"IF(OR(H21=\"\",I21=\"\"),\"\", yokuyori($N$1,$C21))","v":""},"","","","","","",""]
[null,16,{"$f":"IF(OR(H22=\"\",I22=\"\"),\"\", kdate($N$1,C21,1))","v":""},"",{"$f":"IF(OR(H22=\"\",I22=\"\"),\"\", hike($N$1,$C22) - yori($N$1,$C22))","v":""},{"$f":"IF(OR(H22=\"\",I22=\"\"),\"\", IF(yori($N$1,$C22) < hike($N$1,$C22), yori($N$1,$C22) - yasu($N$1,$C22), hike($N$1,$C22) - yasu($N$1,$C22) ) )","v":""},{"$f":"IF(OR(H22=\"\",I22=\"\"),\"\", IF(yori($N$1,$C22) < hike($N$1,$C22), taka($N$1,$C22) - hike($N$1,$C22), taka($N$1,$C22) - yori($N$1,$C22) ) )","v":""},null,null,"","",{"$f":"IF(OR(H22=\"\",I22=\"\"),\"\", hike($N$1,$C22))","v":""},{"$f":"IF(OR(H22=\"\",I22=\"\"),\"\", yokuyori($N$1,$C22))","v":""},"","","","","","",""]
[null,17,{"$f":"IF(OR(H23=\"\",I23=\"\"),\"\", kdate($N$1,C22,1))","v":""},"",{"$f":"IF(OR(H23=\"\",I23=\"\"),\"\", hike($N$1,$C23) - yori($N$1,$C23))","v":""},{"$f":"IF(OR(H23=\"\",I23=\"\"),\"\", IF(yori($N$1,$C23) < hike($N$1,$C23), yori($N$1,$C23) - yasu($N$1,$C23), hike($N$1,$C23) - yasu($N$1,$C23) ) )","v":""},{"$f":"IF(OR(H23=\"\",I23=\"\"),\"\", IF(yori($N$1,$C23) < hike($N$1,$C23), taka($N$1,$C23) - hike($N$1,$C23), taka($N$1,$C23) - yori($N$1,$C23) ) )","v":""},null,null,"","",{"$f":"IF(OR(H23=\"\",I23=\"\"),\"\", hike($N$1,$C23))","v":""},{"$f":"IF(OR(H23=\"\",I23=\"\"),\"\", yokuyori($N$1,$C23))","v":""},"","","","","","",""]
[null,18,{"$f":"IF(OR(H24=\"\",I24=\"\"),\"\", kdate($N$1,C23,1))","v":""},"",{"$f":"IF(OR(H24=\"\",I24=\"\"),\"\", hike($N$1,$C24) - yori($N$1,$C24))","v":""},{"$f":"IF(OR(H24=\"\",I24=\"\"),\"\", IF(yori($N$1,$C24) < hike($N$1,$C24), yori($N$1,$C24) - yasu($N$1,$C24), hike($N$1,$C24) - yasu($N$1,$C24) ) )","v":""},{"$f":"IF(OR(H24=\"\",I24=\"\"),\"\", IF(yori($N$1,$C24) < hike($N$1,$C24), taka($N$1,$C24) - hike($N$1,$C24), taka($N$1,$C24) - yori($N$1,$C24) ) )","v":""},null,null,"","",{"$f":"IF(OR(H24=\"\",I24=\"\"),\"\", hike($N$1,$C24))","v":""},{"$f":"IF(OR(H24=\"\",I24=\"\"),\"\", yokuyori($N$1,$C24))","v":""},"","","","","","",""]
[null,19,{"$f":"IF(OR(H25=\"\",I25=\"\"),\"\", kdate($N$1,C24,1))","v":""},"",{"$f":"IF(OR(H25=\"\",I25=\"\"),\"\", hike($N$1,$C25) - yori($N$1,$C25))","v":""},{"$f":"IF(OR(H25=\"\",I25=\"\"),\"\", IF(yori($N$1,$C25) < hike($N$1,$C25), yori($N$1,$C25) - yasu($N$1,$C25), hike($N$1,$C25) - yasu($N$1,$C25) ) )","v":""},{"$f":"IF(OR(H25=\"\",I25=\"\"),\"\", IF(yori($N$1,$C25) < hike($N$1,$C25), taka($N$1,$C25) - hike($N$1,$C25), taka($N$1,$C25) - yori($N$1,$C25) ) )","v":""},null,null,"","",{"$f":"IF(OR(H25=\"\",I25=\"\"),\"\", hike($N$1,$C25))","v":""},{"$f":"IF(OR(H25=\"\",I25=\"\"),\"\", yokuyori($N$1,$C25))","v":""},"","","","","","",""]
[null,20,{"$f":"IF(OR(H26=\"\",I26=\"\"),\"\", kdate($N$1,C25,1))","v":""},"",{"$f":"IF(OR(H26=\"\",I26=\"\"),\"\", hike($N$1,$C26) - yori($N$1,$C26))","v":""},{"$f":"IF(OR(H26=\"\",I26=\"\"),\"\", IF(yori($N$1,$C26) < hike($N$1,$C26), yori($N$1,$C26) - yasu($N$1,$C26), hike($N$1,$C26) - yasu($N$1,$C26) ) )","v":""},{"$f":"IF(OR(H26=\"\",I26=\"\"),\"\", IF(yori($N$1,$C26) < hike($N$1,$C26), taka($N$1,$C26) - hike($N$1,$C26), taka($N$1,$C26) - yori($N$1,$C26) ) )","v":""},null,null,"","",{"$f":"IF(OR(H26=\"\",I26=\"\"),\"\", hike($N$1,$C26))","v":""},{"$f":"IF(OR(H26=\"\",I26=\"\"),\"\", yokuyori($N$1,$C26))","v":""},"","","","","","",""]
[null,21,{"$f":"IF(OR(H27=\"\",I27=\"\"),\"\", kdate($N$1,C26,1))","v":""},"",{"$f":"IF(OR(H27=\"\",I27=\"\"),\"\", hike($N$1,$C27) - yori($N$1,$C27))","v":""},{"$f":"IF(OR(H27=\"\",I27=\"\"),\"\", IF(yori($N$1,$C27) < hike($N$1,$C27), yori($N$1,$C27) - yasu($N$1,$C27), hike($N$1,$C27) - yasu($N$1,$C27) ) )","v":""},{"$f":"IF(OR(H27=\"\",I27=\"\"),\"\", IF(yori($N$1,$C27) < hike($N$1,$C27), taka($N$1,$C27) - hike($N$1,$C27), taka($N$1,$C27) - yori($N$1,$C27) ) )","v":""},null,null,"","",{"$f":"IF(OR(H27=\"\",I27=\"\"),\"\", hike($N$1,$C27))","v":""},{"$f":"IF(OR(H27=\"\",I27=\"\"),\"\", yokuyori($N$1,$C27))","v":""},"","","","","","",""]
[null,22,{"$f":"IF(OR(H28=\"\",I28=\"\"),\"\", kdate($N$1,C27,1))","v":""},"",{"$f":"IF(OR(H28=\"\",I28=\"\"),\"\", hike($N$1,$C28) - yori($N$1,$C28))","v":""},{"$f":"IF(OR(H28=\"\",I28=\"\"),\"\", IF(yori($N$1,$C28) < hike($N$1,$C28), yori($N$1,$C28) - yasu($N$1,$C28), hike($N$1,$C28) - yasu($N$1,$C28) ) )","v":""},{"$f":"IF(OR(H28=\"\",I28=\"\"),\"\", IF(yori($N$1,$C28) < hike($N$1,$C28), taka($N$1,$C28) - hike($N$1,$C28), taka($N$1,$C28) - yori($N$1,$C28) ) )","v":""},null,null,"","",{"$f":"IF(OR(H28=\"\",I28=\"\"),\"\", hike($N$1,$C28))","v":""},{"$f":"IF(OR(H28=\"\",I28=\"\"),\"\", yokuyori($N$1,$C28))","v":""},"","","","","","",""]
[null,23,{"$f":"IF(OR(H29=\"\",I29=\"\"),\"\", kdate($N$1,C28,1))","v":""},"",{"$f":"IF(OR(H29=\"\",I29=\"\"),\"\", hike($N$1,$C29) - yori($N$1,$C29))","v":""},{"$f":"IF(OR(H29=\"\",I29=\"\"),\"\", IF(yori($N$1,$C29) < hike($N$1,$C29), yori($N$1,$C29) - yasu($N$1,$C29), hike($N$1,$C29) - yasu($N$1,$C29) ) )","v":""},{"$f":"IF(OR(H29=\"\",I29=\"\"),\"\", IF(yori($N$1,$C29) < hike($N$1,$C29), taka($N$1,$C29) - hike($N$1,$C29), taka($N$1,$C29) - yori($N$1,$C29) ) )","v":""},null,null,"","",{"$f":"IF(OR(H29=\"\",I29=\"\"),\"\", hike($N$1,$C29))","v":""},{"$f":"IF(OR(H29=\"\",I29=\"\"),\"\", yokuyori($N$1,$C29))","v":""},"","","","","","",""]
[null,24,{"$f":"IF(OR(H30=\"\",I30=\"\"),\"\", kdate($N$1,C29,1))","v":""},"",{"$f":"IF(OR(H30=\"\",I30=\"\"),\"\", hike($N$1,$C30) - yori($N$1,$C30))","v":""},{"$f":"IF(OR(H30=\"\",I30=\"\"),\"\", IF(yori($N$1,$C30) < hike($N$1,$C30), yori($N$1,$C30) - yasu($N$1,$C30), hike($N$1,$C30) - yasu($N$1,$C30) ) )","v":""},{"$f":"IF(OR(H30=\"\",I30=\"\"),\"\", IF(yori($N$1,$C30) < hike($N$1,$C30), taka($N$1,$C30) - hike($N$1,$C30), taka($N$1,$C30) - yori($N$1,$C30) ) )","v":""},null,null,{"$f":"IF(OR(H30=\"\",I30=\"\"),\"\",  H30-H29)","v":""},{"$f":"IF(OR(H30=\"\",I30=\"\"),\"\", I30-I29)","v":""},{"$f":"IF(OR(H30=\"\",I30=\"\"),\"\", hike($N$1,$C30))","v":""},{"$f":"IF(OR(H30=\"\",I30=\"\"),\"\", yokuyori($N$1,$C30))","v":""},"","","","","","",""]
[null,25,{"$f":"IF(OR(H31=\"\",I31=\"\"),\"\", kdate($N$1,C30,1))","v":""},"",{"$f":"IF(OR(H31=\"\",I31=\"\"),\"\", hike($N$1,$C31) - yori($N$1,$C31))","v":""},{"$f":"IF(OR(H31=\"\",I31=\"\"),\"\", IF(yori($N$1,$C31) < hike($N$1,$C31), yori($N$1,$C31) - yasu($N$1,$C31), hike($N$1,$C31) - yasu($N$1,$C31) ) )","v":""},{"$f":"IF(OR(H31=\"\",I31=\"\"),\"\", IF(yori($N$1,$C31) < hike($N$1,$C31), taka($N$1,$C31) - hike($N$1,$C31), taka($N$1,$C31) - yori($N$1,$C31) ) )","v":""},null,null,"","",{"$f":"IF(OR(H31=\"\",I31=\"\"),\"\", hike($N$1,$C31))","v":""},{"$f":"IF(OR(H31=\"\",I31=\"\"),\"\", yokuyori($N$1,$C31))","v":""},"","","","","","",""]
[null,26,{"$f":"IF(OR(H32=\"\",I32=\"\"),\"\", kdate($N$1,C31,1))","v":""},"",{"$f":"IF(OR(H32=\"\",I32=\"\"),\"\", hike($N$1,$C32) - yori($N$1,$C32))","v":""},{"$f":"IF(OR(H32=\"\",I32=\"\"),\"\", IF(yori($N$1,$C32) < hike($N$1,$C32), yori($N$1,$C32) - yasu($N$1,$C32), hike($N$1,$C32) - yasu($N$1,$C32) ) )","v":""},{"$f":"IF(OR(H32=\"\",I32=\"\"),\"\", IF(yori($N$1,$C32) < hike($N$1,$C32), taka($N$1,$C32) - hike($N$1,$C32), taka($N$1,$C32) - yori($N$1,$C32) ) )","v":""},null,null,"","",{"$f":"IF(OR(H32=\"\",I32=\"\"),\"\", hike($N$1,$C32))","v":""},{"$f":"IF(OR(H32=\"\",I32=\"\"),\"\", yokuyori($N$1,$C32))","v":""},"","","","","","",""]
[null,27,{"$f":"IF(OR(H33=\"\",I33=\"\"),\"\", kdate($N$1,C32,1))","v":""},"",{"$f":"IF(OR(H33=\"\",I33=\"\"),\"\", hike($N$1,$C33) - yori($N$1,$C33))","v":""},{"$f":"IF(OR(H33=\"\",I33=\"\"),\"\", IF(yori($N$1,$C33) < hike($N$1,$C33), yori($N$1,$C33) - yasu($N$1,$C33), hike($N$1,$C33) - yasu($N$1,$C33) ) )","v":""},{"$f":"IF(OR(H33=\"\",I33=\"\"),\"\", IF(yori($N$1,$C33) < hike($N$1,$C33), taka($N$1,$C33) - hike($N$1,$C33), taka($N$1,$C33) - yori($N$1,$C33) ) )","v":""},null,null,"","",{"$f":"IF(OR(H33=\"\",I33=\"\"),\"\", hike($N$1,$C33))","v":""},{"$f":"IF(OR(H33=\"\",I33=\"\"),\"\", yokuyori($N$1,$C33))","v":""},"","","","","","",""]
[null,28,{"$f":"IF(OR(H34=\"\",I34=\"\"),\"\", kdate($N$1,C33,1))","v":""},"",{"$f":"IF(OR(H34=\"\",I34=\"\"),\"\", hike($N$1,$C34) - yori($N$1,$C34))","v":""},{"$f":"IF(OR(H34=\"\",I34=\"\"),\"\", IF(yori($N$1,$C34) < hike($N$1,$C34), yori($N$1,$C34) - yasu($N$1,$C34), hike($N$1,$C34) - yasu($N$1,$C34) ) )","v":""},{"$f":"IF(OR(H34=\"\",I34=\"\"),\"\", IF(yori($N$1,$C34) < hike($N$1,$C34), taka($N$1,$C34) - hike($N$1,$C34), taka($N$1,$C34) - yori($N$1,$C34) ) )","v":""},null,null,"","",{"$f":"IF(OR(H34=\"\",I34=\"\"),\"\", hike($N$1,$C34))","v":""},{"$f":"IF(OR(H34=\"\",I34=\"\"),\"\", yokuyori($N$1,$C34))","v":""},"","","","","","",""]
[null,29,{"$f":"IF(OR(H35=\"\",I35=\"\"),\"\", kdate($N$1,C34,1))","v":""},{"$f":"IF(OR(H35=\"\",I35=\"\"),\"\", WEEKDAY(C35))","v":""},{"$f":"IF(OR(H35=\"\",I35=\"\"),\"\", hike($N$1,$C35) - yori($N$1,$C35))","v":""},{"$f":"IF(OR(H35=\"\",I35=\"\"),\"\", IF(yori($N$1,$C35) < hike($N$1,$C35), yori($N$1,$C35) - yasu($N$1,$C35), hike($N$1,$C35) - yasu($N$1,$C35) ) )","v":""},{"$f":"IF(OR(H35=\"\",I35=\"\"),\"\", IF(yori($N$1,$C35) < hike($N$1,$C35), taka($N$1,$C35) - hike($N$1,$C35), taka($N$1,$C35) - yori($N$1,$C35) ) )","v":""},null,null,"","",{"$f":"IF(OR(H35=\"\",I35=\"\"),\"\", hike($N$1,$C35))","v":""},{"$f":"IF(OR(H35=\"\",I35=\"\"),\"\", yokuyori($N$1,$C35))","v":""},"","","","","","",""]
[null,30,{"$f":"IF(OR(H36=\"\",I36=\"\"),\"\", kdate($N$1,C35,1))","v":""},{"$f":"IF(OR(H36=\"\",I36=\"\"),\"\", WEEKDAY(C36))","v":""},{"$f":"IF(OR(H36=\"\",I36=\"\"),\"\", hike($N$1,$C36) - yori($N$1,$C36))","v":""},{"$f":"IF(OR(H36=\"\",I36=\"\"),\"\", IF(yori($N$1,$C36) < hike($N$1,$C36), yori($N$1,$C36) - yasu($N$1,$C36), hike($N$1,$C36) - yasu($N$1,$C36) ) )","v":""},{"$f":"IF(OR(H36=\"\",I36=\"\"),\"\", IF(yori($N$1,$C36) < hike($N$1,$C36), taka($N$1,$C36) - hike($N$1,$C36), taka($N$1,$C36) - yori($N$1,$C36) ) )","v":""},null,null,"","",{"$f":"IF(OR(H36=\"\",I36=\"\"),\"\", hike($N$1,$C36))","v":""},{"$f":"IF(OR(H36=\"\",I36=\"\"),\"\", yokuyori($N$1,$C36))","v":""},"","","","","","",""]
[]
[null,"＜注意事項＞",null,null,null,null,null,"・",null,"色のセル以外は、計算式が含まれていますので、上書きしないでください。"]
[null,null,null,null,null,null,null,"・","行を加える時は、最終行をコピーし、計算式をそのままスライドさせてください。",null,null,null,null,null,null,null,null,null,null,"Copyright (C) 細野俊一 All Rights Reserved."]