리그전_경기진행표 자동으로 만들기 2

<p><span data-ke-size="size16">리그전 경기 순서에 대하여</span></p><p><span data-ke-size="size16">인터넷 검색을 하여 보았습니다</span><span data-ke-size="size16">.</span></p><p><span data-ke-size="size16">많이 나와 있습니다만</span><span data-ke-size="size16">, </span><span data-ke-size="size16">대부분 팀이 홀수일 때 경기 간격이 맞지 않습니다</span><span data-ke-size="size16">.</span></p><p><span data-ke-size="size16">가장 정확하게 잘 맞는 것은 아래 내용이라 생각됩니다</span><span data-ke-size="size16">.</span></p><p><u></u><u><a href="https://blog.naver.com/atmyhome/222607702613" target="_top" class="ke-link">https://blog.naver.com/atmyhome/222607702613</a></u></p><p><span data-ke-size="size16">위 내용을 제가 엑셀 함수로 작성한 파일이 </span><span data-ke-size="size16">"</span><span data-ke-size="size16">리그대진쌍</span><span data-ke-size="size16">_50_3.xlsm" </span><span data-ke-size="size16">파일입니다</span><span data-ke-size="size16">.</span></p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1Xw6s/b9375ccbb4ada79db3c70540717cc60e6e76c23e?download" data-file-name="리그대진쌍_50_3.xlsm" data-file-size="1135128" data-mimetype="application/vnd.ms-excel.sheet.macroEnabled.12" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1Xw6s%26fldid%3DsPqD%26dataid%3D46%26fileid%3D1%26regdt%3D20230730165444&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1Xw6s%2Fb9375ccbb4ada79db3c70540717cc60e6e76c23e')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">리그대진쌍_50_3</span><span class="type">.xlsm</span></div><div class="size">1.08MB</div></div></a></div><p><span data-ke-size="size16">제가 함수로 작성한 것을</span><br><span data-ke-size="size16">엑사모 황기성 선생님께서 </span><span data-ke-size="size16">VBA</span><span data-ke-size="size16">로 다시 작성하신 내용입니다</span><span data-ke-size="size16">.</span></p><p><u></u><u><a href="https://cafe.naver.com/ex4mo/41268" target="_top" class="ke-link">https://cafe.naver.com/ex4mo/41268</a></u></p><p> </p><p><span data-ke-size="size16">짝수 팀일 경우 똑같지는 않지만</span><span data-ke-size="size16">, </span><span data-ke-size="size16">경기 간격은 같습니다</span><span data-ke-size="size16">.</span></p><p><span data-ke-size="size16">홀수 팀일 경우는 위 내용 모두 같습니다</span><span data-ke-size="size16">.</span></p><p><span data-ke-size="size16">리그전 경기순서의 합리적인 자료가 완성되었으므로 제가 경기진행표와 순위표를 만들어 보았습니다</span><span data-ke-size="size16">.</span></p><p><span data-ke-size="size16">아직은 완성 단계라 생각하는 것보다 현재 여러 가지 검토 중인 파일입니다</span><span data-ke-size="size16">.</span></p><p><span data-ke-size="size16">제가 여러 번 가상으로 데이터를 넣어서 사용해 보았습니다만</span><span data-ke-size="size16">, </span><span data-ke-size="size16">실제로 몇 번 사용해 보고 문제점 파악 후 몇 차례 수정해야 할 것으로 생각됩니다</span><span data-ke-size="size16">.</span></p><p> </p><p><span style="color: #006dd7;"><b>3세트 경기용</b></span> : 족구 이외 3세트 경기면 사용 가능할 것으로 생각됩니다.</p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1Xw6s/53aa6f86aea1176e720709f1c9cf5112bde5fa29?download" data-file-name="리그전_경기진행표_순위표_만들기.xlsm" data-file-size="167271" data-mimetype="application/vnd.ms-excel.sheet.macroEnabled.12" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1Xw6s%26fldid%3DsPqD%26dataid%3D46%26fileid%3D4%26regdt%3D20230730165444&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1Xw6s%2F53aa6f86aea1176e720709f1c9cf5112bde5fa29')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">리그전_경기진행표_순위표_만들기</span><span class="type">.xlsm</span></div><div class="size">163.35KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1Xw6s/a97a9e9277f33ff1c37f6f8176e585764bddcddf?download" data-file-name="리그전_경기진행표_순위표_만들기_암호X.xlsm" data-file-size="162995" data-mimetype="application/vnd.ms-excel.sheet.macroEnabled.12" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1Xw6s%26fldid%3DsPqD%26dataid%3D46%26fileid%3D10%26regdt%3D20230730165444&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1Xw6s%2Fa97a9e9277f33ff1c37f6f8176e585764bddcddf')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">리그전_경기진행표_순위표_만들기_암호X</span><span class="type">.xlsm</span></div><div class="size">159.17KB</div></div></a></div><div class="figure-video" data-ke-type="video" data-video-url="https://kakaotv.daum.net/embed/player/cliplink/rv0ebtu98tmkhxq72ste0wc8j@my?service=daum_cafe" data-video-host="kakaotv" data-video-play-service="daum_cafe" data-video-width="712" data-video-height="400" data-ke-style="alignCenter" data-video-thumbnail="https://thumb.kakaocdn.net/dna/kamp/source/rv0ebtu98tmkhxq72ste0wc8j/thumbs/2.jpg?credential=TuMuFGKUIcirOSjFzOpncbomGFEIdZWK&expires=33256502368&signature=ZR0sJD5mUBImwZiv1oUjgVJXzoc%3D" data-ke-mobile-mobileStyle="widthFull" data-video-origin-width="712" data-video-origin-height="400"><iframe src="https://kakaotv.daum.net/embed/player/cliplink/rv0ebtu98tmkhxq72ste0wc8j@my?service=daum_cafe&ptoken=v2_9d58ed246df60cc9b6dfac835351ec4d98920a0c4cac41c2cbb9e44d684fba976ac66456d741bac1300ac73fdc0216dcff638996f0f8403b2900e2a189" width="712" height="400" frameborder="0" scrolling="no" allowfullscreen="" allow="encrypted-media"></iframe><div class="figcaption"></div></div><div class="figure-video" data-ke-type="video" data-video-url="https://kakaotv.daum.net/embed/player/cliplink/rvn0n9g61ydgn2yxkwgjk0in7@my?service=daum_cafe" data-video-host="kakaotv" data-video-play-service="daum_cafe" data-video-width="712" data-video-height="400" data-ke-style="alignCenter" data-video-thumbnail="https://thumb.kakaocdn.net/dna/kamp/source/rvn0n9g61ydgn2yxkwgjk0in7/thumbs/2.jpg?credential=TuMuFGKUIcirOSjFzOpncbomGFEIdZWK&expires=33256434429&signature=iy%2BNfcCLQjZlGF%2B%2FU%2FQ9PIl6xeo%3D" data-ke-mobile-mobileStyle="widthFull" data-video-origin-width="712" data-video-origin-height="400"><iframe src="https://kakaotv.daum.net/embed/player/cliplink/rvn0n9g61ydgn2yxkwgjk0in7@my?service=daum_cafe&ptoken=v2_30e45ddd8ad165e4cf8685ac1a5785772ffab22b84e55a0a29b2965ac1f72aa70a69a0d1ed9db817c8c82c3b8ed517984af3319468001d078cd81cbb53" width="712" height="400" frameborder="0" scrolling="no" allowfullscreen="" allow="encrypted-media"></iframe><div class="figcaption"></div></div><p>리그전 세트 없는 경기용</p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1Xw6s/83c626c35d503a8a57210e468b2d02c6c8c932f4?download" data-file-name="리그일반.xlsm" data-file-size="159847" data-mimetype="application/vnd.ms-excel.sheet.macroEnabled.12" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1Xw6s%26fldid%3DsPqD%26dataid%3D46%26fileid%3D7%26regdt%3D20230730165444&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1Xw6s%2F83c626c35d503a8a57210e468b2d02c6c8c932f4')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">리그일반</span><span class="type">.xlsm</span></div><div class="size">156.10KB</div></div></a></div><p>수정하시고 싶은 부분. 함께 만들기를 원하시는 분 등</p><p>기타 좋은 말씀 기다립니다.</p><p> </p><p>메일 : cyh611@naver.com</p><p> </p><p>23년 리그전 파일</p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1Xw6s/43e3753674757c606176d29317bf5119651244a6?download" data-file-name="족구리그전.xlsm" data-file-size="78634" data-mimetype="application/vnd.ms-excel.sheet.macroEnabled.12" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1Xw6s%26fldid%3DsPqD%26dataid%3D46%26fileid%3D8%26regdt%3D20230730165444&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1Xw6s%2F43e3753674757c606176d29317bf5119651244a6')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">족구리그전</span><span class="type">.xlsm</span></div><div class="size">76.79KB</div></div></a></div>