{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["電子申請ログSheet","ポイント集計","ポイント計算の手順","メンバー","手書きSheet"],"not_rendered":{"charts":0,"images":2,"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":"電子申請ログSheet","index":0,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,5,3,6],[1,2,1,10]]}
[]
[null,null,"富士山ＱＳＯ　２０１７　アワード　ＬＯＧ　ＳＥＥＴ （ ログシート ）"]
[null,null,null,null,null,null,null,null,null,null,null,"Ver.132"]
[null,null,"Ｓｔａｔｉｏｎ　Ｗｋｄ","Date","Time","ＲＳ",null,"Band","Mode","QTH","Point","Multi."]
[null,"№","交　信　 局","(年)月日","時分　JST","Sent","Reseived","バンド","モード","Hamlog Code","得点","マルチ"]

{"sheet":"ポイント集計","index":1,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,13,5,16],[2,15,2,16]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ver　1.32"]
["富士山ＱＳＯ2017アワードポイント計算表",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ポイント集計結果"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P8:P18)","v":0},{"$f":"SUM(Q8:Q18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"M=ﾒﾝﾊﾞｰ　/　P=移動"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"関数組込"]
["No","Call","Date","Time","His","My","Freq","Mode","Code","G･L","QSL","Name","ＱＴＨ","局","移","Point","マルチ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(LEFT(B8,6),メンバー!$A$3:$B$69,2,0)),0,VLOOKUP(LEFT(B8,6),メンバー!$A$3:$B$69,2,0))","v":0},{"$f":"IF(OR(LEFT(B8,6)=\"JJ2YLX\",N8=0),0,IF(CODE(RIGHT(B8,1))<58,\"P\",0))","v":0},{"$f":"IF(AND(N8=\"M\",O8=\"P\"),5,IF(AND(N8=\"Y\",O8=0),10,IF(N8=\"M\",1,0)))","v":0},{"$f":"IF(COUNTIF($I$8:I8,I8)>1,0,IF((N8)=0,0,IF(LEFT(I8,2)=\"18\",1,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(LEFT(B9,6),メンバー!$A$3:$B$69,2,0)),0,VLOOKUP(LEFT(B9,6),メンバー!$A$3:$B$69,2,0))","v":0},0,0,{"$f":"IF(COUNTIF($I$8:I9,I9)>1,0,IF((N9)=0,0,IF(LEFT(I9,2)=\"18\",1,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(LEFT(B10,6),メンバー!$A$3:$B$69,2,0)),0,VLOOKUP(LEFT(B10,6),メンバー!$A$3:$B$69,2,0))","v":0},{"$f":"IF(OR(LEFT(B10,6)=\"JJ2YLX\",N10=0),0,IF(CODE(RIGHT(B10,1))<58,\"P\",0))","v":0},{"$f":"IF(AND(N10=\"M\",O10=\"P\"),5,IF(AND(N10=\"Y\",O10=0),10,IF(N10=\"M\",1,0)))","v":0},{"$f":"IF(COUNTIF($I$8:I10,I10)>1,0,IF((N10)=0,0,IF(LEFT(I10,2)=\"18\",1,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(LEFT(B11,6),メンバー!$A$3:$B$69,2,0)),0,VLOOKUP(LEFT(B11,6),メンバー!$A$3:$B$69,2,0))","v":0},{"$f":"IF(OR(LEFT(B11,6)=\"JJ2YLX\",N11=0),0,IF(CODE(RIGHT(B11,1))<58,\"P\",0))","v":0},{"$f":"IF(AND(N11=\"M\",O11=\"P\"),5,IF(AND(N11=\"Y\",O11=0),10,IF(N11=\"M\",1,0)))","v":0},{"$f":"IF(COUNTIF($I$8:I11,I11)>1,0,IF((N11)=0,0,IF(LEFT(I11,2)=\"18\",1,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(LEFT(B12,6),メンバー!$A$3:$B$69,2,0)),0,VLOOKUP(LEFT(B12,6),メンバー!$A$3:$B$69,2,0))","v":0},{"$f":"IF(OR(LEFT(B12,6)=\"JJ2YLX\",N12=0),0,IF(CODE(RIGHT(B12,1))<58,\"P\",0))","v":0},{"$f":"IF(AND(N12=\"M\",O12=\"P\"),5,IF(AND(N12=\"Y\",O12=0),10,IF(N12=\"M\",1,0)))","v":0},{"$f":"IF(COUNTIF($I$8:I12,I12)>1,0,IF((N12)=0,0,IF(LEFT(I12,2)=\"18\",1,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(LEFT(B13,6),メンバー!$A$3:$B$69,2,0)),0,VLOOKUP(LEFT(B13,6),メンバー!$A$3:$B$69,2,0))","v":0},0,0,{"$f":"IF(COUNTIF($I$8:I13,I13)>1,0,IF((N13)=0,0,IF(LEFT(I13,2)=\"18\",1,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(LEFT(B14,6),メンバー!$A$3:$B$69,2,0)),0,VLOOKUP(LEFT(B14,6),メンバー!$A$3:$B$69,2,0))","v":0},{"$f":"IF(OR(LEFT(B14,6)=\"JJ2YLX\",N14=0),0,IF(CODE(RIGHT(B14,1))<58,\"P\",0))","v":0},{"$f":"IF(AND(N14=\"M\",O14=\"P\"),5,IF(AND(N14=\"Y\",O14=0),10,IF(N14=\"M\",1,0)))","v":0},{"$f":"IF(COUNTIF($I$8:I14,I14)>1,0,IF((N14)=0,0,IF(LEFT(I14,2)=\"18\",1,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(LEFT(B15,6),メンバー!$A$3:$B$69,2,0)),0,VLOOKUP(LEFT(B15,6),メンバー!$A$3:$B$69,2,0))","v":0},0,0,{"$f":"IF(COUNTIF($I$8:I15,I15)>1,0,IF((N15)=0,0,IF(LEFT(I15,2)=\"18\",1,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(LEFT(B16,6),メンバー!$A$3:$B$69,2,0)),0,VLOOKUP(LEFT(B16,6),メンバー!$A$3:$B$69,2,0))","v":0},{"$f":"IF(OR(LEFT(B16,6)=\"JJ2YLX\",N16=0),0,IF(CODE(RIGHT(B16,1))<58,\"P\",0))","v":0},{"$f":"IF(AND(N16=\"M\",O16=\"P\"),5,IF(AND(N16=\"Y\",O16=0),10,IF(N16=\"M\",1,0)))","v":0},{"$f":"IF(COUNTIF($I$8:I16,I16)>1,0,IF((N16)=0,0,IF(LEFT(I16,2)=\"18\",1,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(LEFT(B17,6),メンバー!$A$3:$B$69,2,0)),0,VLOOKUP(LEFT(B17,6),メンバー!$A$3:$B$69,2,0))","v":0},0,0,{"$f":"IF(COUNTIF($I$8:I17,I17)>1,0,IF((N17)=0,0,IF(LEFT(I17,2)=\"18\",1,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(LEFT(B18,6),メンバー!$A$3:$B$69,2,0)),0,VLOOKUP(LEFT(B18,6),メンバー!$A$3:$B$69,2,0))","v":0},0,0,{"$f":"IF(COUNTIF($I$8:I18,I18)>1,0,IF((N18)=0,0,IF(LEFT(I18,2)=\"18\",1,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(LEFT(B19,6),メンバー!$A$3:$B$69,2,0)),0,VLOOKUP(LEFT(B19,6),メンバー!$A$3:$B$69,2,0))","v":0},{"$f":"IF(OR(LEFT(B19,6)=\"JJ2YLX\",N19=0),0,IF(CODE(RIGHT(B19,1))<58,\"P\",0))","v":0},{"$f":"IF(AND(N19=\"M\",O19=\"P\"),5,IF(AND(N19=\"Y\",O19=0),10,IF(N19=\"M\",1,0)))","v":0},{"$f":"IF(COUNTIF($I$8:I19,I19)>1,0,IF((N19)=0,0,IF(LEFT(I19,2)=\"18\",1,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(LEFT(B20,6),メンバー!$A$3:$B$69,2,0)),0,VLOOKUP(LEFT(B20,6),メンバー!$A$3:$B$69,2,0))","v":0},{"$f":"IF(OR(LEFT(B20,6)=\"JJ2YLX\",N20=0),0,IF(CODE(RIGHT(B20,1))<58,\"P\",0))","v":0},{"$f":"IF(AND(N20=\"M\",O20=\"P\"),5,IF(AND(N20=\"Y\",O20=0),10,IF(N20=\"M\",1,0)))","v":0},{"$f":"IF(COUNTIF($I$8:I20,I20)>1,0,IF((N20)=0,0,IF(LEFT(I20,2)=\"18\",1,0)))","v":0}]

{"sheet":"ポイント計算の手順","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ポイント計算の手順"]

{"sheet":"メンバー","index":3,"n_rows":69,"n_cols":2,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["2017QSO"]
["メンバー"]
["7N1FRQ","M"]
["JA1IOA","M"]
["JA2EPR","M"]
["JA2GXY","M"]
["JA2KIG","M"]
["JA2PDJ","M"]
["JA2PEI","M"]
["JA2PFZ","M"]
["JA2QZU","M"]
["JA2RSF","M"]
["JA2SXS","M"]
["JE2FXI","M"]
["JE2HDZ","M"]
["JE2RZS","M"]
["JF2AXH","M"]
["JF2GCI","M"]
["JF2HTO","M"]
["JG2FIM","M"]
["JG2ODA","M"]
["JG2UZS","M"]
["JH0SGO","M"]
["JH2DLJ","M"]
["JH2MCP","M"]
["JH2NTH","M"]
["JH2QLC","M"]
["JH2QUQ","M"]
["JI2BKO","M"]
["JI2BKQ","M"]
["JI2GSR","M"]
["JI2SVL","M"]
["JI2TPJ","M"]
["JI2WUC","M"]
["JJ0SRL","M"]
["JJ2AOA","M"]
["JJ2CBV","M"]
["JJ2FUQ","M"]
["JJ2IOA","M"]
["JJ2TFF","M"]
["JJ2YLX","Y"]
["JK2INT","M"]
["JK2NAO","M"]
["JL2LJY","M"]
["JL2UHI","M"]
["JM2LSJ","M"]
["JM8JZI","M"]
["JN1FKW","M"]
["JN2LRW","M"]
["JO1MJJ","M"]
["JO2LNC","M"]
["JO2PMW","M"]
["JO2SCG","M"]
["JP2IBL","M"]
["JQ2DLM","M"]
["JQ2FOY","M"]
["JQ2NBN","M"]
["JQ2RVS","M"]
["JQ2XTA","M"]
["JR2ESU","M"]
["JR2GEQ","M"]
["JR2GGV","M"]
["JR2IKH","M"]
["JR2KDG","M"]
["JR2LEZ","M"]
["JR2NXA","M"]
["JR2PMQ","M"]
["JR2UYJ","M"]
["JS2JDX","M"]

{"sheet":"手書きSheet","index":4,"n_rows":58,"n_cols":24,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,1,1,22],[5,1,5,4],[4,1,4,4],[4,5,4,6],[4,7,4,12],[4,14,4,19],[5,14,5,16],[49,8,49,13],[40,8,40,13],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[45,8,45,13],[46,8,46,13],[47,8,47,13],[11,8,11,13],[12,8,12,13],[20,8,20,13],[21,14,21,16],[21,17,21,19],[17,8,17,13],[19,8,19,13],[15,14,15,16],[2,0,2,5],[6,8,6,13],[7,8,7,13],[9,8,9,13],[8,8,8,13],[10,8,10,13],[56,6,57,6],[2,17,2,19],[2,13,2,16],[2,6,2,8],[25,0,26,0],[35,0,36,0],[55,0,56,0],[54,8,54,13],[5,5,5,6],[5,7,5,13],[13,8,13,13],[14,8,14,13],[15,8,15,13],[16,8,16,13],[18,8,18,13],[15,0,16,0],[21,8,21,13],[15,17,15,19],[22,8,22,13],[22,14,22,16],[22,17,22,19],[23,14,23,16],[23,17,23,19],[25,8,25,13],[24,8,24,13],[24,14,24,16],[24,17,24,19],[25,14,25,16],[23,8,23,13],[29,8,29,13],[28,8,28,13],[28,14,28,16],[28,17,28,19],[29,14,29,16],[29,17,29,19],[27,8,27,13],[26,8,26,13],[26,14,26,16],[26,17,26,19],[27,14,27,16],[27,17,27,19],[57,1,57,4],[55,8,55,13],[51,8,51,13],[50,8,50,13],[38,8,38,13],[37,8,37,13],[36,8,36,13],[36,14,36,16],[35,8,35,13],[35,14,35,16],[48,8,48,13],[53,8,53,13],[42,14,42,16],[48,14,48,16],[51,14,51,16],[5,17,5,19],[6,14,6,16],[6,17,6,19],[7,14,7,16],[7,17,7,19],[8,14,8,16],[8,17,8,19],[52,8,52,13],[2,20,2,21],[39,8,39,13],[34,8,34,13],[34,14,34,16],[34,17,34,19],[35,17,35,19],[33,8,33,13],[32,8,32,13],[32,14,32,16],[32,17,32,19],[33,14,33,16],[33,17,33,19],[31,8,31,13],[30,8,30,13],[30,14,30,16],[30,17,30,19],[12,14,12,16],[12,17,12,19],[13,14,13,16],[13,17,13,19],[14,14,14,16],[14,17,14,19],[9,14,9,16],[9,17,9,19],[10,14,10,16],[10,17,10,19],[11,14,11,16],[11,17,11,19],[36,17,36,19],[37,14,37,16],[37,17,37,19],[38,14,38,16],[38,17,38,19],[25,17,25,19],[16,17,16,19],[17,14,17,16],[17,17,17,19],[18,14,18,16],[18,17,18,19],[19,14,19,16],[19,17,19,19],[31,14,31,16],[31,17,31,19],[16,14,16,16],[20,14,20,16],[20,17,20,19],[42,17,42,19],[43,14,43,16],[43,17,43,19],[44,14,44,16],[44,17,44,19],[39,14,39,16],[39,17,39,19],[40,14,40,16],[40,17,40,19],[41,14,41,16],[41,17,41,19],[48,17,48,19],[49,14,49,16],[49,17,49,19],[50,14,50,16],[50,17,50,19],[45,14,45,16],[45,17,45,19],[46,14,46,16],[46,17,46,19],[47,14,47,16],[47,17,47,19],[51,17,51,19],[55,14,55,16],[55,17,55,19],[56,22,57,22],[56,23,57,23],[52,14,52,16],[52,17,52,19],[53,14,53,16],[53,17,53,19],[54,14,54,16],[54,17,54,19],[57,14,57,19],[56,20,57,20],[56,21,57,21]]}
[null,"富士山ＱＳＯ　２０１７　アワード　ＬＯＧ　ＳＥＥＴ （ ログシート ）"]
[]
["Callsign(コールサイン)",null,null,null,null,null,null,null,null,",","Seet No."]
[]
[null,"Ｄａｔｅ Ｔｉｍｅ ＵＴＣ",null,null,null,"Ｓｔａｔｉｏｎ　Ｗｋｄ",null,"QTH",null,null,null,null,null,null,"RS",null,null,null,null,null,"Band","Mode","Pts","Multi."]
[null,"月日　時分　ＪＳＴ",null,null,null,"交　信　 局",null,"Hamlog Code",null,null,null,null,null,null,"Sent",null,null,"Reseived",null,null,"バンド","モード","得点","マルチ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[20]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[30]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[40]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[50]
[]
[null,"Ｔｏｔａｌ （合計）",null,null,null,null,null,null,null,null,null,null,null,null,"Ｔｏｔａｌ （合計）"]