HSP¥Ý¡¼¥¿¥ë
¥µ¥¤¥È¥Þ¥Ã¥× ¤ªÌ䤤¹ç¤ï¤»


HSPTV!·Ç¼¨ÈÄ


̤²ò·è ²ò·è Ää»ß ºï½üÍ×ÀÁ

2018
0305
É´¹ç»Ò¥¨¥¯¥»¥ë¤Î¥Ç¡¼¥¿Æɹþ¤È½ñ¤­¹þ¤ß¤Ë¤Ä¤¤¤Æ¶µ¤¨¤Æ¤¯¤À¤µ¤¤31²ò·è


É´¹ç»Ò

¥ê¥ó¥¯

2018/3/5(Mon) 13:55:11|NO.82632

¥¨¥¯¥»¥ë¤Î¥Ç¡¼¥¿Æɹþ¤È½ñ¤­¹þ¤ß¤Ë¤Ä¤¤¤Æ¶µ¤¨¤Æ¤¯¤À¤µ¤¤¡£
¥Ç¡¼¥¿1¤òÆɤ߹þ¤ó¤Ç¡¢¥Ç¡¼¥¿2¤Ë½ñ¤­¹þ¤ß¤¿¤¤¤Î¤Ç¤¹¤¬
¤ä¤êÊý¤¬¤è¤¯¤ï¤«¤ê¤Þ¤»¤ó¡£

¥Ç¡¼¥¿1¤Ï
ÈÖ¹æ ÈÖ¹æ2 1 2 3 Ê¿¶Ñ
1 1 19.9 36.4 38.3 31.5
2 4 15.5 16.9 15.4 16.0
3 5 25.2 38.1 24.8 29.4
4 6 39.0 39.6 11.2 29.9
5 7 26.4 24.7 13.8 21.6
6 8 17.0 31.1 15.5 21.2
7 9 23.6 13.8 20.6 19.4
8 11 27.7 30.0 22.9 26.9
9 12 27.4 12.8 13.4 17.9
10 13 16.7 10.4 32.1 19.7
11 14 15.9 27.6 36.6 26.7
12 15 16.6 28.3 18.9 21.3
13 18 26.4 11.9 36.4 24.9
14 19 38.6 27.9 32.0 32.8
15 20 12.2 34.3 38.8 28.4
16 21 18.9 14.0 33.3 22.1
17 22 18.9 19.7 17.1 18.6
18 25 36.4 19.3 27.8 27.8
19 26 17.7 35.8 12.6 22.0
20 27 13.4 20.3 31.2 21.6
21
22
23
24
25

¤³¤Î¤è¤¦¤Ê·Á¤Ç¡¢ÈÖ¹æ2¡¦1¡¦2¡¦3¡¦Ê¿¶Ñ¤òÆɤ߹þ¤ß¡¢
¥Ç¡¼¥¿3¤Î»ØÄꤷ¤¿¥»¥ë¤Ë¡ÊÈÖ¹æ1¤Î¥Ç¡¼¥¿¤ÏÈÖ¹æ2¤òC1¡¢1¡¦2¡¦3¡¦Ê¿¶Ñ¤òC3,C4,C5,C6¤Ë
ÈÖ¹æ2¤Î¥Ç¡¼¥¿¤ÏÈÖ¹æ2¤òP1¡¢1¡¦2¡¦3¡¦Ê¿¶Ñ¤òP3,P4,P5,P6¤Ë¤Ê¤É¥Ç¡¼¥¿¤Î¤¢¤ëʬ»ØÄê²Õ½ê¤Ë¡Ë
½ñ¤­¹þ¤ß¤¿¤¤¤Ç¤¹¡£

¤Þ¤¿¥Ç¡¼¥¿1¤Î¥Ç¡¼¥¿¡ÊÈÖ¹æ¤Î¿ô¡Ë¤Ï¿ô¤Ï¤À¤¤¤¿¤¤20¸Ä¤¯¤é¤¤¤Ê¤Î¤Ç¤¹¤¬¡¢
°ã¤¦¤È¤­¤â¤¢¤ë¤Î¤Ç¥Ç¡¼¥¿¤Î¤¢¤ëʬ¤À¤±Æɤ߹þ¤á¤¿¤ê¤Ç¤­¤ë¤Ç¤·¤ç¤¦¤«¡©

¶µ¤¨¤Æ失¤ëÊý¤¤¤é¤Ã¤·¤ã¤¤¤Þ¤·¤¿¤é¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£



¤³¤Îµ­»ö¤ËÊÖ¿®¤¹¤ë


¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/5(Mon) 19:15:40|NO.82633

Excel¥Ç¡¼¥¿¤È¤¤¤¦¤Î¤Ï¡¢¡û¡û¡û.xls ¤Ê¤É¤Î¥Õ¥¡¥¤¥ë¤È¤¤¤¦»ö¤Ç¤·¤ç¤¦¤«¡©

¤³¤Î·Á¼°¤Î¥Õ¥¡¥¤¥ë¤òÆɤ߽ñ¤­¤¹¤ë»ö¤â½ÐÍè¤ë¤ó¤Ç¤¹¤¬
¤«¤Ê¤êÊ£»¨¤Ê¥½¡¼¥¹¤Ë¤Ê¤ë¤Î¤ÇÍý²ò¤ÏÆñ¤·¤¤¤«¤â¤·¤ì¤Þ¤»¤ó¡£

¾¯¡¹¼ê´Ö¤¬¤«¤«¤ê¤Þ¤¹¤¬¡¢´Êñ¤ÊÊýË¡¤È¤·¤Æ¤Ï
°ìö¥Õ¥¡¥¤¥ë¤òCSV·Á¼°¤ÇÊݸ¤·¡¢HSP¤ÇCSV¥Õ¥¡¥¤¥ë¤òÆɤ߹þ¤ß¡¢
¤ä¤ê¤¿¤¤½èÍý¤ò¤·¤¿¾å¤ÇCSV¤ÇÊݸ¡£
HSP¤Çºî¤Ã¤¿CSV¤òExcel¤ÇÆɤ߹þ¤à¤È¤¤¤¦CSV¤ò´Ö¤Ë¶´¤à·Á¤Ç¤Î½èÍý¤Ê¤é
Èæ³ÓŪ´Êñ¤ËÍý²ò¤Ç¤­¤ë¤È»×¤¤¤Þ¤¹¤è¡£



¤µ¤«

¥ê¥ó¥¯

2018/3/5(Mon) 22:34:01|NO.82635

¾¯¤·Á°¤ËƱ¤¸¤è¤¦¤Ê¼ÁÌ䤬¤¢¤ê¤Þ¤·¤¿¡£
°Ê²¼¤¬»²¹Í¤Ë¤Ê¤ë¤Î¤Ç¤Ï¤È»×¤¤¤Þ¤¹¡£

http://hsp.tv/play/pforum.php?mode=all&num=82038



É´¹ç»Ò

¥ê¥ó¥¯

2018/3/5(Mon) 23:03:38|NO.82636

¤¢¤Þ¤é¤µ¤óÀ§È󤽤ÎÊýË¡¤Ç¶µ¤¨¤Æ¤¤¤¿¤À¤±¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/6(Tue) 01:58:01|NO.82638

CSVÍøÍѤΥµ¥ó¥×¥ë¥½¡¼¥¹¤òºî¤ë¤Î¤Ï¹½¤ï¤Ê¤¤¤Î¤Ç¤¹¤¬¡¢¤¤¤¯¤Ä¤«ÉÔÌÀ¤Ê²Õ½ê¤¬¤¢¤ê¤Þ¤¹¡£

> ¥Ç¡¼¥¿3¤Î»ØÄꤷ¤¿¥»¥ë¤Ë¡ÊÈÖ¹æ1¤Î¥Ç¡¼¥¿¤ÏÈÖ¹æ2¤òC1¡¢1¡¦2¡¦3¡¦Ê¿¶Ñ¤òC3,C4,C5,C6¤Ë
> ÈÖ¹æ2¤Î¥Ç¡¼¥¿¤ÏÈÖ¹æ2¤òP1¡¢1¡¦2¡¦3¡¦Ê¿¶Ñ¤òP3,P4,P5,P6¤Ë¤Ê¤É¥Ç¡¼¥¿¤Î¤¢¤ëʬ»ØÄê²Õ½ê¤Ë¡Ë
> ½ñ¤­¹þ¤ß¤¿¤¤¤Ç¤¹¡£
¤¹¤ß¤Þ¤»¤ó¤¬¡¢¸ÀÍÕ¤À¤±¤Ç¤Ï¤É¤¦¤¤¤¦½èÍý¤ò¤·¤¿¤¤¤Î¤«¤¬¤è¤¯¤ï¤«¤ê¤Þ¤»¤ó¡£

¡Ú¥Ç¡¼¥¿3¤Î»ØÄꤷ¤¿¥»¥ë¡Û¤È¤Ï¡©
> ¥Ç¡¼¥¿1¤òÆɤ߹þ¤ó¤Ç¡¢¥Ç¡¼¥¿2¤Ë½ñ¤­¹þ¤ß¤¿¤¤
¤ÈºÇ½é¤Ë½ñ¤«¤ì¤Æ¤¤¤Þ¤¹¤¬¡¢¥Ç¡¼¥¿3¤È¤Ï¤É¤³¤«¤é½Ð¤Æ¤­¤¿¤Î¤Ç¤·¤ç¤¦¤«¡£

¡ÚÈÖ¹æ1¤Î¥Ç¡¼¥¿¡Û¤È¤Ï¥Ç¡¼¥¿1¥Õ¥¡¥¤¥ë¤Î¡ÖÈÖ¹æ¤ÎÎó¡×¤Î»ö¤Ç¤·¤ç¤¦¤«¡©

> ÈÖ¹æ2¤òC1¡¢1¡¦2¡¦3¡¦Ê¿¶Ñ¤òC3,C4,C5,C6¤Ë
> ÈÖ¹æ2¤Î¥Ç¡¼¥¿¤ÏÈÖ¹æ2¤òP1¡¢¡¢1¡¦2¡¦3¡¦Ê¿¶Ñ¤òP3,P4,P5,P6¤Ë
¤È¤¢¤ê¤Þ¤¹¤¬¡¢Æ±¤¸¥Ç¡¼¥¿¤ò¤½¤ì¤¾¤ìCÎó¤ÈPÎó¤Î£²¤Ä¤Î¾ì½ê¤Ë½ñ¤­¹þ¤ß¤¿¤¤¤È¤¤¤¦¤³¤È¤Ç¤·¤ç¤¦¤«¡©

¤³¤Î¤è¤¦¤Ë°ìÂβ¿¤ò¤·¤¿¤¤¤Î¤«¤¬¤è¤¯¤ï¤«¤ê¤Þ¤»¤ó¡£
¥Ç¡¼¥¿1¤ÎÆâÍƤò½ñ¤­¹þ¤ó¤À¤è¤¦¤Ë
¥Ç¡¼¥¿2¤ÎÆâÍƤò¤³¤¦¤¤¤¦·Á¤Ë¤·¤¿¤¤¤È¾Ü¤·¤¯½ñ¤­¹þ¤ó¤Ç²¼¤µ¤ë¤È
¤ï¤«¤ê¤ä¤¹¤¯¤Ê¤ê¤Þ¤¹¡£
²Äǽ¤Ê¤é¤Ð½èÍýÁ°¤È¸å¤ÎÎã¤ò¥¹¥¯¥ê¡¼¥ó¥·¥ç¥Ã¥È²èÁü¤È¤·¤Æ
¥¢¥Ã¥×¥í¡¼¥É¤·¤Æ¤â¤é¤¨¤ë¤È¤¤¤¤¤«¤â¤·¤ì¤Þ¤»¤ó¡£



¤½¤·¤ÆÊ¿¶Ñ¤ÎÃͤǤ¹¤¬¡¢Îã¤È¤·¤ÆÊ¿¶Ñ¤ÎºÇ½é¤Ë¤¢¤¿¤ë¡Ö¥»¥ë¤Ç¤¤¤¦F2¤Î 31.5 ¡×¤Î²Õ½ê¤Ï
¤¿¤À¤Î¿ôÃͤʤé¤Ð¤¤¤¤¤Î¤Ç¤¹¤¬¡¢
¤â¤·¤«¤·¤Æ´Ø¿ô¡Ê¡Ø=AVERAGE(C2,D2,E2)¡Ù ¤È¤« ¡Ø=(C2+D2+E2)/3¡Ù ¤Ê¤É¡Ë¤ò
»ÈÍѤ·¤Æ¤¤¤ë¤Î¤Ç¤·¤ç¤¦¤«¡©
¤À¤È¤¹¤ë¤ÈCSV¤Ç¤ä¤ë¤Î¤Ï¾¯¡¹ÌÌÅݤ«¤â¤·¤ì¤Þ¤»¤ó¡£

¤³¤ÎÊÕ¤ê¤òÌÀ³Î¤Ë¤·¤Æ²¼¤µ¤ë¤È¾Ü¤·¤¯ÀâÌÀ¤¹¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£



É´¹ç»Ò

¥ê¥ó¥¯

2018/3/6(Tue) 15:02:28|NO.82639

¤µ¤«¤µ¤ó¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡¢»²¹Í¤Ë¤µ¤»¤Æ夭¤Þ¤¹¡£



É´¹ç»Ò

¥ê¥ó¥¯

2018/3/6(Tue) 15:41:20|NO.82640

¤¢¤Þ¤é¤µ¤ó
ʸ¾Ï¤¬¤ª¤«¤·¤¯¤Æ¤¹¤ß¤Þ¤»¤ó¡£

> ¥Ç¡¼¥¿2¤Î»ØÄꤷ¤¿¥»¥ë¤Ë¡ÊÈÖ¹æ1¤Î¥Ç¡¼¥¿¤ÏÈÖ¹æ2¤òC1¡¢1¡¦2¡¦3¡¦Ê¿¶Ñ¤òC3,C4,C5,C6¤Ë
> ÈÖ¹æ2¤Î¥Ç¡¼¥¿¤ÏÈÖ¹æ2¤òP1¡¢1¡¦2¡¦3¡¦Ê¿¶Ñ¤òP3,P4,P5,P6¤Ë¤Ê¤É¥Ç¡¼¥¿¤Î¤¢¤ëʬ»ØÄê²Õ½ê¤Ë¡Ë
> ½ñ¤­¹þ¤ß¤¿¤¤¤Ç¤¹¡£
¤¹¤ß¤Þ¤»¤ó¤¬¡¢¸ÀÍÕ¤À¤±¤Ç¤Ï¤É¤¦¤¤¤¦½èÍý¤ò¤·¤¿¤¤¤Î¤«¤¬¤è¤¯¤ï¤«¤ê¤Þ¤»¤ó¡£

¤â¤È¤â¤È¤Î¥¨¥¯¥»¥ë¥Õ¥¡¥¤¥ë¡¦¥Ç¡¼¥¿1¡ÊÆɤ߹þ¤ß¤¿¤¤¥Õ¥¡¥¤¥ë¡Ë
ÈÖ¹æ1,ÈÖ¹æ2,no1,no2,no3,Ê¿¶Ñ
1,1,19.9,36.4,38.3,31.5
2,4,15.5,16.9,15.4,16.0
¡¦
¡¦
¡¦
¡¦
¡¦
20,27,13.4,20.3,31.2,21.6


¥Ç¡¼¥¿2¡Ê½ñ¤­¹þ¤ß¤¿¤¤¥Õ¥¡¥¤¥ë¥¤¥á¡¼¥¸¡Ë
¤¦¤Þ¤¯ÀâÌÀ¤Ç¤­¤ì¤Ð¤¤¤¤¤Î¤Ç¤¹¤¬¡¢
Î㤨¤Ð¥Ç¡¼¥¿1¤Î2¹ÔÌܤÎ1,1,19.9,36.4,38.3,31.5¤Î³Æ¿ô»ú¤ò¹¥¤­¤Ê¤È¤³¤í¤Ë½ñ¤­¹þ¤á¤ë¤è¤¦¤Ë
¤·¤Æ¤ß¤¿¤¤¤Ç¤¹¡£
1¤ÏA2,1¤ÏB2,19.9¤ÏF2,36.4¤ÏG2,38.3¤ÏH2,31.5¤ÏI2¤Ê¤É¤Ç¤¹¡£
2¹ÔÌܰʹߤâ
2¤ÏA3,4¤ÏB3,15.5¤ÏF3,16.9¤ÏG3,15.4¤ÏH3,16.0¤ÏI3¤Ê¤É
¥Ç¡¼¥¿1¤Ë¤¢¤ë¹Ô¿ôʬÆɤ߹þ¤ó¤Ç½ñ¤­¹þ¤ß¤¿¤¤¤Ç¤¹¡£

¤Þ¤¿½ñ¤­¹þ¤à°ÌÃÖ¤ÏǤ°Õ¤Î¾ì½ê¤Ë»ØÄꤷ¤¿¤¤¤Ç¤¹¡£¡Ê¹¥¤­¤Ê¾ì½ê¡Ë


¡Ú¥Ç¡¼¥¿3¤Î»ØÄꤷ¤¿¥»¥ë¡Û¤È¤Ï¡©
> ¥Ç¡¼¥¿1¤òÆɤ߹þ¤ó¤Ç¡¢¥Ç¡¼¥¿2¤Ë½ñ¤­¹þ¤ß¤¿¤¤
¤ÈºÇ½é¤Ë½ñ¤«¤ì¤Æ¤¤¤Þ¤¹¤¬¡¢¥Ç¡¼¥¿3¤È¤Ï¤É¤³¤«¤é½Ð¤Æ¤­¤¿¤Î¤Ç¤·¤ç¤¦¤«¡£
¤¹¤ß¤Þ¤»¤ó¥Ç¡¼¥¿3¤Ï¡ß¡¡¢ª¡¡¥Ç¡¼¥¿2¤ò½ñ¤­´Ö°ã¤¨¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¡£

¡ÚÈÖ¹æ1¤Î¥Ç¡¼¥¿¡Û¤È¤Ï¥Ç¡¼¥¿1¥Õ¥¡¥¤¥ë¤Î¡ÖÈÖ¹æ¤ÎÎó¡×¤Î»ö¤Ç¤·¤ç¤¦¤«¡©
¤Ï¤¤¤½¤ÎÄ̤ê¤Ç¤¹¡£

> ÈÖ¹æ2¤òC1¡¢1¡¦2¡¦3¡¦Ê¿¶Ñ¤òC3,C4,C5,C6¤Ë
> ÈÖ¹æ2¤Î¥Ç¡¼¥¿¤ÏÈÖ¹æ2¤òP1¡¢¡¢1¡¦2¡¦3¡¦Ê¿¶Ñ¤òP3,P4,P5,P6¤Ë
¤È¤¢¤ê¤Þ¤¹¤¬¡¢Æ±¤¸¥Ç¡¼¥¿¤ò¤½¤ì¤¾¤ìCÎó¤ÈPÎó¤Î£²¤Ä¤Î¾ì½ê¤Ë½ñ¤­¹þ¤ß¤¿¤¤¤È¤¤¤¦¤³¤È¤Ç¤·¤ç¤¦¤«¡©
¤¹¤ß¤Þ¤»¤ó¤³¤ì¤â´Ö°ã¤¨¤Æ¤·¤Þ¤¤¡¢ÈÖ¹æ2¤ÈÈÖ¹æ3¤Ç¤·¤¿¡£
ÈÖ¹æ2¤ò3¹ÔÌܤ˽ñ¤­¹þ¤ß¡¢¼¡¤ÎÈÖ¹æ3¤ò16¹ÔÌܤ˽ñ¤­¹þ¤ß¡¢¤½¤Î¼¡¤ÏÈֹ棴¤ò¡¦¡¦¡¦
ÈÖ¹æ¤Î¿ôÃͤò13¹Ô¤È¤Ð¤·¤Ë½ñ¤­¹þ¤ß¤¿¤¤¤È»×¤Ã¤Æ¤¤¤Þ¤·¤¿¡£

Ê¿¶Ñ¤Î·×»»¤Ï¥¨¥¯¥»¥ë¤Ç¡Ø=AVERAGE(C2,D2,E2)¡Ù¤ò »È¤Ã¤Æ¤·¤Þ¤Ã¤Æ¤¤¤Þ¤¹¡£

»ä¤ÎÀâÌÀ¤Ë´Ö°ã¤¤¤ä²¼¼ê¤Ç¤´¤á¤ó¤Ê¤µ¤¤¡¢
¤¢¤È¥¢¥Ã¥×¥í¡¼¥É¤È¤¤¤¦¤Î¤â¤É¤¦¤ä¤ë¤«¤ï¤«¤ê¤Þ¤»¤ó¡¢
¤¤¤í¤¤¤í¶µ¤¨¤Æ¤Û¤·¤¤¤Ç¤¹¡¢¤ª´ê¤¤¤·¤Þ¤¹¡£



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/6(Tue) 19:33:02|NO.82643

>¤Þ¤¿½ñ¤­¹þ¤à°ÌÃÖ¤ÏǤ°Õ¤Î¾ì½ê¤Ë»ØÄꤷ¤¿¤¤¤Ç¤¹¡£¡Ê¹¥¤­¤Ê¾ì½ê¡Ë
¤ª¤ª¤è¤½¤ï¤«¤ê¤Þ¤·¤¿¤¬¡¢Ç¤°Õ¤Î¾ì½ê¤Ç¤¹¤«¡Ä
¤Á¤ç¤Ã¤È»þ´Ö¤¬¤«¤«¤ê¤½¤¦¤Ç¤¹¡£


¤¢¤ÈÄɲädzÎǧ¤µ¤»¤Æ¤¯¤À¤µ¤¤¡£

´Ø¿ôÅù¤Î·×»»¤ò»È¤Ã¤Æ¤¤¤ë²Õ½ê¤ÏÊ¿¶Ñ¤À¤±¤Ç¤·¤ç¤¦¤«¡©

¸½ºß»ä¤ÎPC¤ËExcel¤òÆþ¤ì¤Æ¤¤¤Ê¤¤¤¿¤á³Îǧ¤Ç¤­¤Ê¤¤¤Î¤Ç¤¹¤¬¡¢
CSV¤ÎÆɤ߹þ¤ß¤äÊݸ¤ÎºÝ¤Ë¶èÀڤ국¹æ¤òÀßÄê¤Ç¤­¤ë¤Ç¤·¤ç¤¦¤«¡©

LibreOffice¤ÏÆþ¤ì¤Æ¤¤¤ë¤Î¤Ç¡¢
¤³¤ì¤À¤ÈÆɤ߹þ¤ß»þ¤Ëʸ»ú¥³¡¼¥É¤ä¶èÀڤ국¹æ¤ÎÀßÄ꤬²Äǽ¤Ç¤¹¤·¡¢
Êݸ¤ÎºÝ¤Ë¤âʸ»ú¥³¡¼¥É¡¦¶èÀڤ국¹æ¡¦·×»»·ë²Ì¤ÎÂå¤ï¤ê¤Ë¥»¥ë¤Î¿ô¼°¤òÊݸ
¤È¤¤¤¦ÀßÄ꤬²Äǽ¤Ê¤ó¤Ç¤¹¤¬¡¢Excel¤Ï¤½¤¦¤¤¤¦ºÙ¤«¤¤½ê¤ÏÀßÄê¤Ç¤­¤¿¤Ç¤·¤ç¤¦¤«¡£


°ìÅÙ²¼µ­¤Î¥Ç¡¼¥¿¤òtest.csv¤È¤·¤Æ¥á¥âÄ¢¤Ê¤É¤ÇÊݸ¤·¤Æ
¥¨¥¯¥»¥ë¤ÇÆɤ߹þ¤ó¤Ç¤ß¤Æ¤¯¤À¤µ¤¤¡£

test.csv
A1¤Ë¤Ê¤ë,B1¤Ë¤Ê¤ë,C1¤Ë¤Ê¤ë
A2¤Ë¤Ê¤ë,B2¤Ë¤Ê¤ë,C2¤Ë¤Ê¤ë A3¤Ë¤Ê¤ë,B3¤Ë¤Ê¤ë,C3¤Ë¤Ê¤ë



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/6(Tue) 19:49:37|NO.82644

¤¹¤ß¤Þ¤»¤ó
²¿¸Î¤«ÊѤʽê¤Ë²þ¹Ô¤¬Æþ¤Ã¤Æ¤¤¤Þ¤¹¤Í¡£
test.csv¤Î¶õ¹Ô¤Ïºï½ü¤·¤Æ¤«¤éÊݸ¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£



Φ

¥ê¥ó¥¯

2018/3/6(Tue) 20:37:48|NO.82646

¡¡¤³¤ó¤Ð¤ó¤Ï¡¢²£¤«¤é¤¹¤ß¤Þ¤»¤ó¡£

¡¡Excel¤Ç¤ÎCSV·Á¼°¤Î°·¤¤¤Ë¤Ä¤¤¤Æ¤Ç¤¹¡£
¡¡¤Ê¤ª¡¢¤³¤ì¤Ï2013°Ê¹ß¤Ç³Îǧ¤·¤Æ¤ª¤ê¡¢2007¤È¤«2003¤Ç¤Ï¤É¤¦¤Ê¤Ã¤Æ¤¤¤ë¤Î¤«¡¢¼ê¸µ¤Ë³ºÅö¤Î¥×¥í¥°¥é¥à¤¬¤Ê¤¤¤Î¤Ç¡¢¤ï¤«¤é¤Ê¤¤¤Ç¤¹¡£

¡¡¤Þ¤º¡¢Æɤ߹þ¤ß¤Ë´Ø¤·¤Æ

¡¡´ØÏ¢ÉÕ¤±¤«¤éÆɤ߹þ¤ó¤À¾ì¹ç¤Ï¡¢´ðËÜŪ¤Ë¡¢¥¿¥Ö¤Ç¶èÀÚ¤é¤ì¤¿¥Æ¥­¥¹¥È¤Ç¤¢¤ì¤Ð¡¢¤­¤Á¤ó¤ÈÆɤ߹þ¤ó¤Ç¤¯¤ì¤Þ¤¹¡£
¡¡¤¿¤À¡¢¥³¥ó¥Þ¤ä¤½¤Î¾¤Îʸ»ú¤Ç¶èÀÚ¤é¤ì¤¿¥Æ¥­¥¹¥È¤À¤È¤¦¤Þ¤¯Æɤ߹þ¤ó¤Ç¤¯¤ì¤Þ¤»¤ó¡£
¡¡¤Ê¤ª¡¢Excel¤Î¡Ö¥Õ¥¡¥¤¥ë¤ò³«¤¯¡×¤«¤é³°Åå¤Î¥Õ¥¡¥¤¥ë¤ò»ØÄꤷ¤ÆÆɤ߹þ¤ó¤À¾ì¹ç¤Ï¡¢¶èÀÚ¤êʸ»úÅù¤òÀßÄꤹ¤ë¥¦¥£¥¶¡¼¥É¤¬É½¼¨¤µ¤ì¤Þ¤¹¡£

¡¡Â³¤¤¤Æ¡¢Êݸ¤Ë´Ø¤·¤Æ¡£

¡¡Excel¤Ç¤ÎÊݸ¤ÎºÝ¤Ï¡¢¡Ö̾Á°¤òÉÕ¤±¤ÆÊݸ¡×¤Î¥À¥¤¥¢¥í¥°¤Î¡Ö¥Õ¥¡¥¤¥ë¤Î¼ïÎà¡×¤Ç¡ÖCSV(¥³¥ó¥Þ¶èÀÚ¤ê)¡×¤â¤·¤¯¤Ï¡Ö¥Æ¥­¥¹¥È¥Õ¥¡¥¤¥ë¡×¤È¤¤¤¦·Á¼°¤ò»ØÄꤹ¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£
¡¡¤³¤ÎºÝ¡¢¡Ö¥Æ¥­¥¹¥È¥Õ¥¡¥¤¥ë¡×¤È¤·¤ÆÊݸ¤·¤¿¾ì¹ç¤Ï¡¢¥¿¥Ö¶èÀÚ¤ê¤Î¥Æ¥­¥¹¥È¤È¤·¤ÆÊݸ¤µ¤ì¤ë¤è¤¦¤Ç¤¹¡£
¡¡¤Ê¤Î¤Ç¡¢¥³¥ó¥Þ¤Ç¶èÀÚ¤é¤ì¤¿¥Ç¡¼¥¿¤ÇÊݸ¤·¤¿¤¤¾ì¹ç¤Ï¡ÖCSV¡×¤òÁª¤ó¤Ç¤¯¤À¤µ¤¤¡£
¡¡¤Ê¤ª¡¢Êݸ¤¹¤ëºÝ¤Ë¥Õ¥¡¥¤¥ë¤Î¼ïÎà¤Ë¡ÖUTF-8¡×¤È¤«¡ÖUnicode¡×¤Ê¤É¤È¤Ä¤¤¤Æ¤ë·Á¼°¤ÇÊݸ¤¹¤ë¤È¡¢¥æ¥Ë¥³¡¼¥É¤ÇÊݸ¤µ¤ì¤Æ¤·¤Þ¤¦¤Î¤Ç¡¢HSP¤ÇÆɤ߹þ¤à¤³¤È¤òÁÛÄꤹ¤ë¤Î¤Ç¤¢¤ì¤Ð¡¢Ãí°Õ¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£
¡¡¤Ê¤ª¡¢Excel2013¤À¤È¥¿¥Ö¶èÀÚ¤ê¤À¤±¤Ç¤·¤«Êݸ¤Ç¤­¤Ê¤«¤Ã¤¿¤«¤â¤·¤ì¤Þ¤»¤ó¡£
¡¡¼Âµ¡¤¬¤Ê¤¤¤Î¤Ç¡¢º£³Îǧ¤Ç¤­¤Ê¤¤¤Î¤¬¿½¤·Ìõ¤Ê¤¤¤Ç¤¹¡£

¡¡°Ê¾å¡¢»²¹Í¤Ë¤Ê¤ì¤Ð¹¬¤¤¤Ç¤¹¡£



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/6(Tue) 21:02:36|NO.82647

Φ¤µ¤ó¾ðÊóÄ󶡤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£

¥¿¥Ö¶èÀڤ꤬»È¤¨¤ë¤Ê¤é´Ø¿ô¤¬¤¢¤Ã¤Æ¤âÂç¾æÉפ½¤¦¤Ç¤¹¤Í¡£
¥³¥ó¥Þ¤Ï´Ø¿ôÆâ¤Ë¤âÆþ¤Ã¤Æ¤¤¤ë¤Î¤Ç¡¢
¤½¤³¤Ç¶èÀÚ¤é¤ì¤ë¤ÈÌÌÅݤʤ³¤È¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¤Î¤Ç¡£



Φ

¥ê¥ó¥¯

2018/3/6(Tue) 22:46:30|NO.82649

¡¡¤³¤ó¤Ð¤ó¤Ï¡£

¡¡Excel2016¤Ç»î¤·¤Æ¤ß¤Þ¤·¤¿¡£
¡¡Excel¤ÇCSV·Á¼°¤ÇÊݸ¤·¤¿¾ì¹ç¡¢´Ø¿ô¤Ï·×»»·ë²Ì¤¬Êݸ¤µ¤ì¤ë¤è¤¦¤Ç¤¹¡£

¡¡¤½¤ì¤Ç¤Ï¡£



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/6(Tue) 23:37:24|NO.82652

>¡¡Excel¤ÇCSV·Á¼°¤ÇÊݸ¤·¤¿¾ì¹ç¡¢´Ø¿ô¤Ï·×»»·ë²Ì¤¬Êݸ¤µ¤ì¤ë¤è¤¦¤Ç¤¹¡£
¤¢¤¢¡¢¤ä¤Ï¤ê¼°¤Ç¤Ï¤Ê¤¯·ë²Ì¤Î¿ôÃͤˤʤäƤ·¤Þ¤¤¤Þ¤¹¤«¡£


¥Ð¡¼¥¸¥ç¥ó¤Ë¤è¤Ã¤Æ¿¾¯°ã¤¦¤Ç¤·¤ç¤¦¤¬¡¢¶èÀڤ국¹æ¤ä·×»»¼°¤Î½ÐÎϤˤĤ¤¤ÆÄ´¤Ù¤Æ¤ß¤Þ¤·¤¿¡£

¤Þ¤º¡¢¸ø¼°¤ÎÀâÌÀ¤Ç¤Ï¥³¥ó¥È¥í¡¼¥ë¥Ñ¥Í¥ë¤ÎÀßÄê¤Ç
CSV¤Î¶èÀڤ국¹æ¤òÊѹ¹¤Ç¤­¤ë¤è¤¦¤Ç¤¹¡£
https://support.office.com/ja-jp/article/%E3%83%86%E3%82%AD%E3%82%B9%E3%83%88-%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB-txt-%E3%81%BE%E3%81%9F%E3%81%AF-csv-%E3%81%AE%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88%E3%81%BE%E3%81%9F%E3%81%AF%E3%82%A8%E3%82%AF%E3%82%B9%E3%83%9D%E3%83%BC%E3%83%88-5250ac4c-663c-47ce-937b-339e391393ba

¤³¤Î¶èÀڤ국¹æ¤¬¡¢¤É¤³¤Þ¤ÇÀßÄꤵ¤ì¤ë¤Î¤«¤ï¤«¤é¤Ê¤¤¤Î¤Ç
̵Æñ¤Ë¡Ö¥Æ¥­¥¹¥È¡Ê¥¿¥Ö¶èÀÚ¤ê¡Ë¡×¤Çtxt¥Õ¥¡¥¤¥ë¤Ë¤¹¤ëÊý¤¬Îɤµ¤½¤¦¤Ç¤¹¤Í¡£

¤½¤·¤Æ·×»»¼°¤Î½ÐÎϤ˴ؤ·¤Æ¤Ï¡¢¤³¤Á¤é¤Ç²òÀ⤵¤ì¤Æ¤¤¤Þ¤·¤¿¡£
http://mokichi7.blog.fc2.com/blog-entry-105.html



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/7(Wed) 00:19:20|NO.82655

¥¨¥é¡¼¥Á¥§¥Ã¥¯Åù¤Þ¤Ã¤¿¤¯Ìµ¤·¤Î¼êÈ´¤­¤À¤é¤±¤Î¥½¡¼¥¹¤Ç¤¹¤¬
°ì±þ¤³¤ì¤Ç½ÐÍè¤ë¤È»×¤¤¤Þ¤¹¡£

Á°Äó¾ò·ï¤È¤·¤ÆExcel¤Ç¤ÎÆɤ߽ñ¤­¤Ï¤É¤Á¤é¤â
¥¿¥Ö¶èÀÚ¤ê¤ÇShift-JIS¤Î¥Õ¥¡¥¤¥ë¤È¤·¤Æ¤¯¤À¤µ¤¤¡£

Ê¿¶Ñ¤Î·×»»¼°¤Ï¸µ¤Î¥Ç¡¼¥¿¤Ë´Ø·¸¤Ê¤¯¡¢¥½¡¼¥¹¤ÇÊ¿¶Ñ¤Î·×»»¼°¤òºî¤ë¤è¤¦¤Ë¤·¤Þ¤·¤¿¡£

¹Ô¤Î¿ô»ú¤äÎó¤Î¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤ËŬÅö¤Ê¿ô»ú¡¦¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤òÆþ¤ì¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£
±¦¾å¤Î¡Ö´Ø¿ô¤Î¹¹¿·¡×¥Ü¥¿¥ó¥¯¥ê¥Ã¥¯¤Ç´Ø¿ô¤Î¥»¥ëÃͤ¬Êѹ¹¤·¤¿¹Ô¡¦Îó¤Ë¹ç¤ï¤»¤ÆÊѹ¹¤µ¤ì¤Þ¤¹¡£

ɬ¤º¡Ö´Ø¿ô¤Î¹¹¿·¡×¤ò¤·¤Æ¤«¤é¡ÖCSVÊݸ¡×¤·¤Æ¤¯¤À¤µ¤¤¡£


Îó¤Î¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤Ë¿ô»ú¤äµ­¹æ¤òÆþ¤ì¤ë¤È¤¿¤Ö¤óÉÔ¶ñ¹ç¤¬µ¯¤³¤ê¤Þ¤¹¡£
¹Ô¤Î¿ô»ú¤Î½ê¤âȾ³Ñ¿ô»ú°Ê³°¤òÆþ¤ì¤ë¤ÈƱÍͤËÉÔ¶ñ¹ç¤Ë¤Ê¤ê¤½¤¦¤Ç¤¹¡£

°ìÈÖ±¦¤Î¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤òºÇ½ªÎó¡¢°ìÈÖ²¼¤Î¹Ô¤òºÇ½ª¹Ô¤È¤·¤Æ½èÍý¤¹¤ë¤Î¤Ç
Îó¤ÏÄ̾ï¤Î¥¨¥¯¥»¥ë¤ÈƱ¤¸¤Çº¸¤«¤é½ç¤Ë¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È½ç¤Ç
¹Ô¤Ï¾å¤«¤é½ç¤ËÂ礭¤Ê¿ô¡Ê°ìÈÖ²¼¤¬°ìÈÖÂ礭¤Ê¿ô¡Ë¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡£

// ³ÆÊÑ¿ôÅù¤Î½é´ü²½ #const TAB 0x09 // ¥¿¥Öʸ»ú¥³¡¼¥É #const CEL 100 // ¥»¥ë¤Ë´Þ¤Þ¤ì¤ëºÇÂçʸ»ú¿ô¡ÊExcel¤Ç¤Ï 32,767¤é¤·¤¤¤±¤Éº£²ó¤Ï¤½¤ó¤Ê¤Ë»È¤ï¤Ê¤¤¡Ë #const IPTW 80 // ÆþÎϥܥ寥¹Éý #const IPTH 20 // ÆþÎϥܥ寥¹¹â¤µ filename1 = "¥Ç¡¼¥¿1.csv"; // Æɤ߹þ¤à¥Õ¥¡¥¤¥ë̾ filename2 = "¥Ç¡¼¥¿2.csv"; // Êݸ¤¹¤ë¥Õ¥¡¥¤¥ë̾ data1c = 0; // ¥Ç¡¼¥¿1¤ÎÎó¿ô data1r = 0; // ¥Ç¡¼¥¿1¤Î¹Ô¿ô screen 0, 800, 600, 0; #module // ¿ôÃͤò¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤ËÊÑ´¹ #defcfunc NumToA int p01 rcstr = ""; // 1ʸ»úÌܤÏA¤ò0¡¡2ʸ»úÌܰʾå¤ÏA¤ò1¤È¹Í¤¨¤ë if( (p01 / 676) == 0 ) { if( (p01 / 26) == 0 ) { // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È1ʸ»ú poke rcstr, 0, p01+0x41; poke rcstr, 1, 0; } else { // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È2ʸ»ú poke rcstr, 0, p01/26+0x40; poke rcstr, 1, p01\26+0x41; poke rcstr, 2, 0; } } else { // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È3ʸ»ú poke rcstr, 0, p01/676+0x40; poke rcstr, 1, (p01\676)/26+0x40; poke rcstr, 2, (p01\676)\26+0x41; poke rcstr, 3, 0; } return rcstr; // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤ò¿ôÃͤËÊÑ´¹ #defcfunc AToNum str s01 len = strlen(s01); s02 = s01; if( len == 3 ) { // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È3ʸ»ú¤Î¾ì¹ç rcint = (peek(s02, 0)-0x40)*676 + (peek(s02, 1)-0x40)*26 + (peek(s02, 2)-0x41); } else:if( len == 2 ) { // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È1ʸ»ú¤Î¾ì¹ç rcint = (peek(s02, 0)-0x40)*26 + (peek(s02, 1)-0x41); } else { // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È1ʸ»ú¤Î¾ì¹ç rcint = peek(s02, 0)-0x41; } return rcint; // ¾®Ê¸»ú¤òÂçʸ»ú¤ØÊÑ´¹ #defcfunc aToA str s01 len = strlen(s01); rcstr = s01; repeat len w = peek(rcstr, cnt); if( (0x61 <= w) && (w <= 0x7A) ) { poke rcstr, cnt, w-0x20; } loop return rcstr; #global // ¥Ç¡¼¥¿1¥Õ¥¡¥¤¥ë¤ÎÆɤ߹þ¤ß sdim csvdata1, 64; // Æɤ߹þ¤ß»þ¤Ë¼«Æ°¤ÇÍÆÎ̳ÎÊݤµ¤ì¤ë¤¿¤á¿ô»ú¤ÏŬÅö notesel csvdata1; noteload filename1; data1r = notemax; // ¹Ô¿ô¼èÆÀ // Îó¿ô¼èÆÀ½èÍý sdim data0, 64; noteget data0, 0; // 0¹ÔÌܼèÆÀ idxmax = strlen(data0); repeat idxmax // 0¹ÔÌܤ˴ޤޤì¤ë¥¿¥Ö¤Î¿ô¤ò¿ô¤¨¤ë¡Ê¥¿¥Ö¿ô¡Ü£±¤¬Îó¿ô¤Ë¤Ê¤ë¡Ë p01 = peek(data0, cnt); if( p01 == TAB ) { data1c++; } loop data1c++; // ºÇ¸å¤Ë¡Ü£±¤¬Îó¿ô¤Ë¤Ê¤ë // ¥Ç¡¼¥¿1¥Õ¥¡¥¤¥ë¤ÎÆâÍƤò¥»¥ëñ°Ì¤ÇÊÑ¿ô¤Ë½ñ¤­¹þ¤à sdim data1, CEL, data1c, data1r; // data1(Îó, ¹Ô)¤Î½ç repeat data1r sdim data0, 64; // °ì±þÊÑ¿ô½é´ü²½ noteget data0, cnt; // ¹Ô¼èÆÀ cnt1 = cnt; idx = 0; repeat data1c getstr data1(cnt, cnt1), data0, idx, TAB; idx += strsize; loop loop // ¥ª¥Ö¥¸¥§¥¯¥ÈÇÛÃÖ objsize IPTW, IPTH; dim objidr, data1r; // ¹Ô¿ôʬ dim rnums, data1r; dim objidc, data1c; // Îó¿ôʬ sdim cnums, data1c; // ¹Ô¡Ê¿ô»ú¤ÎÆþÎϥܥ寥¹¡Ë pos 0, IPTH; repeat data1r rnums(cnt) = cnt+1; input rnums(cnt); objidr(cnt) = stat; loop // Îó¡Ê¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤ÎÆþÎϥܥ寥¹¡Ë repeat data1c pos IPTW*(cnt+1), 0; cnums(cnt) = NumToA(cnt); input cnums(cnt); objidc(cnt) = stat; loop pos 700, 0; button gosub "´Ø¿ô¤Î¹¹¿·", *replace; pos 700, 40; button gosub "CSVÊݸ", *save; gosub *print_data; stop; *print_data // ¥Ç¡¼¥¿É½¼¨ color 255, 255, 255:boxf; color 0, 0, 0; repeat data1r y = (cnt+1)*IPTH; cnt1 = cnt; repeat data1c x = (cnt+1)*IPTW; pos x, y; mes data1(cnt, cnt1); loop loop return; *replace // ¤Ä¤¤¤Ç¤ËÎó¤Î¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤òÁ´¤ÆÂçʸ»ú¤ËÊÑ´¹ repeat data1c cnums(cnt) = aToA(cnums(cnt)); objprm objidc(cnt), cnums(cnt); loop // ´Ø¿ô¤ÎÀ°·Á repeat data1r // 1ʸ»úÌܤ¬=¤Ê¤é¤Ð´Ø¿ô¤ÈȽÃǤ¹¤ë if( peek(data1(5, cnt), 0) == '=' ) { cel01 = ""+cnums(2)+""+rnums(cnt)+""; // AVERAGE´Ø¿ô¡¡¥»¥ë1¤ÄÌÜ cel02 = ""+cnums(3)+""+rnums(cnt)+""; // AVERAGE´Ø¿ô¡¡¥»¥ë2¤ÄÌÜ cel03 = ""+cnums(4)+""+rnums(cnt)+""; // AVERAGE´Ø¿ô¡¡¥»¥ë3¤ÄÌÜ data1(5, cnt) = "=AVERAGE("+cel01+","+cel02+","+cel03+")"; } loop gosub *print_data; return; *save // CSVÊݸ½èÍý col = AToNum(cnums(data1c-1))+1; // Ê¿¶Ñ¤ÎÎó¤ò°ìÈÖ±¦Ã¼¤È¤¹¤ë row = rnums(data1r-1); // °ìÈÖ²¼¤Î¹Ô¤òºÇ½ª¹Ô¤È¤¹¤ë sdim data2, CEL, col, row; // ÊݸÍѥǡ¼¥¿ // ºÇ½é¤ËÁ´¤Æ¤ò¶èÀڤ국¹æ¡Ê¥¿¥Ö¡Ë¤Ë¤¹¤ë repeat row cnt1 = cnt; repeat col data2(cnt, cnt1) = "\t"; loop loop // 1¹Ô¤º¤Ä¥Ç¡¼¥¿¤ò³ÊǼ¤¹¤ë repeat data1r cnt1 = cnt; r = rnums(cnt)-1; repeat data1c c = AToNum(cnums(cnt)); data2(c, r) = data1(cnt, cnt1); if( (cnt+1) != data1c ) { // ¹ÔËö¤Ç¤Ê¤±¤ì¤Ð¶èÀڤ국¹æ¡Ê¥¿¥Ö¡Ë¤òÄɲà data2(c, r) += "\t"; } loop loop // ÊݸÍÑCSV¥Ç¡¼¥¿ºîÀ® csvdata2 = ""; notesel csvdata2; repeat row data0 = ""; cnt1 = cnt; repeat col data0 += data2(cnt, cnt1); loop noteadd data0, cnt; loop notesave filename2; dialog ""+filename2+"¤ËÊݸ¤·¤Þ¤·¤¿¡£", 0, "CSV½ÐÎÏ"; return;

Ëè²ó¡¢¹Ô¡¦Îó¤òÆþÎϤ¹¤ë¤Î¤¬ÌÌÅݤʤé¤Ð
¡ÊÊѤʽê¤Ë²þ¹Ô¤¬Æþ¤é¤Ê¤±¤ì¤Ð¡Ë

123¹ÔÌܤΡ¡rnums(cnt) = cnt+1;
131¹ÔÌܤΡ¡cnums(cnt) = NumToA(cnt);

¤¬¤½¤ì¤¾¤ì¹Ô¤ÈÎó¤Î½é´üÃͤǤ¹¤«¤é¡¢
¤³¤ì¤ò¾Ã¤·¤Ærepeat¤ÎÁ°¤Ë²¿¤é¤«¤ÎÊýË¡¤Ç½é´üÃͤòÀßÄꤷ¤Æ¤¯¤À¤µ¤¤¡£

ͽÁ۰ʾå¤ËŤ¯¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¤¬¡¢
¤³¤ì¤Ç¤âExcel¥Õ¥¡¥¤¥ë¤òľÀÜÆɤ߽ñ¤­¤¹¤ë¤è¤ê¤Ï¥Þ¥·¤À¤È»×¤¤¤Þ¤¹¡£



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/7(Wed) 00:36:20|NO.82656

¤¹¤ß¤Þ¤»¤ó¡¢¤¦¤½¤Ä¤­¤Þ¤·¤¿¡£

>Ê¿¶Ñ¤Î·×»»¼°¤Ï¸µ¤Î¥Ç¡¼¥¿¤Ë´Ø·¸¤Ê¤¯¡¢¥½¡¼¥¹¤ÇÊ¿¶Ñ¤Î·×»»¼°¤òºî¤ë¤è¤¦¤Ë¤·¤Þ¤·¤¿¡£
ºÇ½é¤Îʸ»ú¤¬¡Ö=¡×¤À¤È·×»»¼°¤ÈȽÃǤ¹¤ë¤è¤¦¤Ë¥½¡¼¥¹¤òÁȤó¤Ç¤¤¤¿¤Î¤Ç¡¢
NO.82652¤Î·×»»¼°¤Î½ÐÎϤò»²¹Í¤Ë¡¢Ê¿¶Ñ¤ÎÎó¤Ï¿ôÃͤǤϤʤ¯¼°¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡£



É´¹ç»Ò

¥ê¥ó¥¯

2018/3/7(Wed) 10:17:07|NO.82659

¤¢¤Þ¤é¤µ¤ó¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£´¶Æ°¤Ç¤¹¡£
¤½¤ì¤Ë¤¤¤í¤¤¤íÄ´¤Ù¤Æ¤¤¤¿¤À¤¤¤ÆËÜÅö¤Ë¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
»ä¤â¤³¤ó¤Ê¥³¡¼¥É¤ò½ñ¤±¤ë¤è¤¦¤Ë¤Ê¤ê¤¿¤¤¤Ç¤¹¡£



É´¹ç»Ò

¥ê¥ó¥¯

2018/3/7(Wed) 13:34:13|NO.82662

¤¢¤Þ¤é¤µ¤ó¤¹¤ß¤Þ¤»¤ó
Îó¤Î¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤Ç¤¹¤¬ÊѤ¨¤Æ¤ß¤Æ¤â
°ÌÃÖ¤¬ÊѤ¨¤é¤ì¤Þ¤»¤ó¡£
¤¤¤í¤¤¤í¤ä¤Ã¤Æ¤â¤é¤Ã¤Æ¤Ð¤«¤ê¤Ç¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¤¬¡¢
¶µ¤¨¤Æ¤â¤é¤¨¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡©



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/7(Wed) 14:25:54|NO.82663

¤¦¡¼¤ó¡¢LibreOffice¤À¤È¶èÀÚ¤êʸ»ú¤À¤±¤Ç¤âÎó¤È¤·¤Æ°·¤Ã¤Æ¤¯¤ì¤ë¤ó¤Ç¤¹¤¬
Excel¤À¤È¶õ¤Î¥Õ¥£¡¼¥ë¥É¤Ï̵»ë¤µ¤ì¤ë¤ó¤Ç¤·¤ç¤¦¤«¡£

Êݸ½èÍý¤Î½ê¤À¤±½¤Àµ¤·¡¢¶õ¤Î¥Õ¥£¡¼¥ë¥É¡Ê¥»¥ë¡Ë¤Ë¤Ï""¤òÆþ¤ì¤ë¤è¤¦¤Ë¤·¤Þ¤·¤¿¡£
¤³¤ì¤Ç¤É¤¦¤Ç¤·¤ç¤¦¤«¡©

*save // CSVÊݸ½èÍý col = AToNum(cnums(data1c-1))+1; // Ê¿¶Ñ¤ÎÎó¤ò°ìÈÖ±¦Ã¼¤È¤¹¤ë row = rnums(data1r-1); // °ìÈÖ²¼¤Î¹Ô¤òºÇ½ª¹Ô¤È¤¹¤ë sdim data2, CEL, col, row; // ÊݸÍѥǡ¼¥¿ // ºÇ½é¤ËÁ´¤Æ¤ò¥À¥Ö¥ë¥¯¥©¡¼¥Æ¡¼¥·¥ç¥ó+¶èÀڤ국¹æ¡Ê¥¿¥Ö¡Ë¤Ë¤¹¤ë repeat row cnt1 = cnt; repeat col if( (cnt+1) == col ) { // ¹ÔËö¤Ë¤Ï¶èÀÚ¤êʸ»ú¤òÆþ¤ì¤Ê¤¤ data2(cnt, cnt1) = "\"\""; } else { data2(cnt, cnt1) = "\"\"\t"; } loop loop // 1¹Ô¤º¤Ä¥Ç¡¼¥¿¤ò³ÊǼ¤¹¤ë repeat data1r cnt1 = cnt; r = rnums(cnt)-1; repeat data1c c = AToNum(cnums(cnt)); if( data1(cnt, cnt1) == "" ) { // ¶õ¥Ç¡¼¥¿¤Ï¥À¥Ö¥ë¥¯¥©¡¼¥Æ¡¼¥·¥ç¥ó¤òÆþ¤ì¤Æ¤ª¤¯ data1(cnt, cnt1) = "\"\""; } data2(c, r) = data1(cnt, cnt1); if( (cnt+1) != data1c ) { // ¹ÔËö¤Ç¤Ê¤±¤ì¤Ð¶èÀڤ국¹æ¡Ê¥¿¥Ö¡Ë¤òÄɲà data2(c, r) += "\t"; } loop loop // ÊݸÍÑCSV¥Ç¡¼¥¿ºîÀ® csvdata2 = ""; notesel csvdata2; repeat row data0 = ""; cnt1 = cnt; repeat col data0 += data2(cnt, cnt1); loop noteadd data0, cnt; loop notesave filename2; dialog ""+filename2+"¤ËÊݸ¤·¤Þ¤·¤¿¡£", 0, "CSV½ÐÎÏ"; return;



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/7(Wed) 22:08:37|NO.82668

ºÆ½¤Àµ¤Ç¤¹¡£

¸µ¥Ç¡¼¥¿¤Ë¶õ¥»¥ë¤¬¤¢¤Ã¤¿¤é¡Ø""¤ò¸µ¥Ç¡¼¥¿¤ËÆþ¤ì¤ë¡Ù¤È¤¤¤¦½ê¤ò
¸µ¥Ç¡¼¥¿¤Ë¶õ¥»¥ë¤¬¤¢¤Ã¤¿¤é¡Ø""¤òÊݸ¥Ç¡¼¥¿¤ËÆþ¤ì¤ë¡Ù¤È¤·¤Þ¤·¤¿¡£


ÀâÌÀÉÔ­¤Ç¤·¤¿¤¬¡Ø""¡Ù¤È¤¤¤¦¤Î¤Ï¶õ¤Î¥»¥ë¤¬¤¢¤ë¤È¤¤¤¦»ö¤ò¼¨¤¹¤À¤±¤Ç¡¢
Excel¤ÇÆɤ߹þ¤ó¤À»þ¤Ë¤Ï²¿¤âɽ¼¨¤·¤Ê¤¤¤Ï¤º¤Ç¤¹¡£

*save // CSVÊݸ½èÍý col = AToNum(cnums(data1c-1))+1; // Ê¿¶Ñ¤ÎÎó¤ò°ìÈÖ±¦Ã¼¤È¤¹¤ë row = rnums(data1r-1); // °ìÈÖ²¼¤Î¹Ô¤òºÇ½ª¹Ô¤È¤¹¤ë sdim data2, CEL, col, row; // ÊݸÍѥǡ¼¥¿ // ºÇ½é¤ËÁ´¤Æ¤ò¥À¥Ö¥ë¥¯¥©¡¼¥Æ¡¼¥·¥ç¥ó+¶èÀڤ국¹æ¡Ê¥¿¥Ö¡Ë¤Ë¤¹¤ë repeat row cnt1 = cnt; repeat col if( (cnt+1) == col ) { data2(cnt, cnt1) = "\"\""; } else { data2(cnt, cnt1) = "\"\"\t"; } loop loop // 1¹Ô¤º¤Ä¥Ç¡¼¥¿¤ò³ÊǼ¤¹¤ë repeat data1r cnt1 = cnt; r = rnums(cnt)-1; repeat data1c c = AToNum(cnums(cnt)); if( data1(cnt, cnt1) == "" ) { // ¶õ¥Ç¡¼¥¿¤Ï¥À¥Ö¥ë¥¯¥©¡¼¥Æ¡¼¥·¥ç¥ó¤òÆþ¤ì¤Æ¤ª¤¯ data2(c, r) = "\"\""; } else { data2(c, r) = data1(cnt, cnt1); } if( (cnt+1) != data1c ) { // ¹ÔËö¤Ç¤Ê¤±¤ì¤Ð¶èÀڤ국¹æ¡Ê¥¿¥Ö¡Ë¤òÄɲà data2(c, r) += "\t"; } loop loop // ÊݸÍÑCSV¥Ç¡¼¥¿ºîÀ® csvdata2 = ""; notesel csvdata2; repeat row data0 = ""; cnt1 = cnt; repeat col data0 += data2(cnt, cnt1); loop noteadd data0, cnt; loop notesave filename2; dialog ""+filename2+"¤ËÊݸ¤·¤Þ¤·¤¿¡£", 0, "CSV½ÐÎÏ"; return;



É´¹ç»Ò

¥ê¥ó¥¯

2018/3/8(Thu) 10:24:58|NO.82670

¤¢¤Þ¤é¤µ¤ó²¿Å٤⤢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
¤Ê¤ó¤É¤â¤´¤á¤ó¤Ê¤µ¤¤¤Ê¤Î¤Ç¤¹¤¬¡¢
¼Â¹Ô¤·¤¿¤È¤­¤Ë¹Ô¤ÎÆþÎϥܥ寥¹¤Ï¹Ô¤Î¿ô½Ð¤ë¤Î¤Ç¤¹¤¬
Îó¤ÎÆþÎϥܥ寥¹¤Ï1¤Ä¤·¤«¤Ç¤Ê¤¤¤ß¤¿¤¤¤Ç¡¢
Î㤨¤ÐºÇ½éA¤¬½Ð¤Æ¤¤¤ë¤Î¤òC¤ËÊѤ¨¤Æ"´Ø¿ô¤Î¹¹¿·"¤ò¤·¤¿¤Î¤Ç¤¹¤¬¡¢
·ë²Ì¤¬ÊѤï¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£
¹Ô¤Î¤Û¤¦¤Ï»ØÄꤷ¤¿¹¥¤­¤Ê¤È¤³¤í¤Ë¤Ç¤ë¤è¤¦¤Ë¤Ê¤Ã¤Æ¤Þ¤·¤¿¡£

²¿Å٤⤹¤ß¤Þ¤»¤ó¤¬¡¢¶µ¤¨¤Æ¤â¤é¤¨¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡©



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/8(Thu) 10:40:58|NO.82672

¼Â¹Ô»þ¤ËÆɤ߹þ¤ó¤À¥Õ¥¡¥¤¥ë¤ÎÆâÍƤòºÇ½é¤Î°ì¹Ô¡Ê¸ø³«¤·¤Æ¤âÌäÂê¤Î¤Ê¤¤¹Ô¡Ë¤À¤±¤Ç¤â¤¤¤¤¤Î¤Ç
¤³¤³¤Ë¥³¥Ô¡¼¡õ¥Ú¡¼¥¹¥È¤·¤Æ¤â¤é¤¨¤Þ¤¹¤«¡©

¥á¥âÄ¢¤Ê¤ó¤«¤Î¥Æ¥­¥¹¥È¥¨¥Ç¥£¥¿¤Ç³«¤±¤ë¤Ï¤º¤Ç¤¹¡£

Î󤬣±¤Ä¤È¤¤¤¦¤³¤È¤Ï¥½¡¼¥¹Åª¤Ë¹Í¤¨¤ë¤È¥¿¥Ö¤¬Ìµ¤¤¡á¥¿¥Ö¶èÀÚ¤ê¤Ë¤Ê¤Ã¤Æ¤¤¤Ê¤¤¡£
¤È¤¤¤¦¾õ¶·¤Î¤Ï¤º¤Ç¤¹¡£

¹Ô¤Ï²þ¹Ô¤ÇȽÄꤵ¤ì¤ë¤Î¤ÇÌäÂê¤Ê¤«¤Ã¤¿¤Î¤Ç¤·¤ç¤¦¤Í¡£
¤¿¤Ö¤ó¶èÀÚ¤êʸ»ú¤¬Ê̤Îʸ»ú¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤Î¤¬ÌäÂê¤Ê¤ó¤À¤È»×¤¤¤Þ¤¹¡£



É´¹ç»Ò

¥ê¥ó¥¯

2018/3/8(Thu) 10:57:37|NO.82673

¤¢¤Þ¤é¤µ¤ó

¼ÂºÝ¤ËÆɤ߹þ¤ó¤À¥Ç¡¼¥¿1.csv¤Ç¤¹¡£¡Ê¥Æ¥­¥¹¥È¤Ç³«¤¤¤Æ¤ß¤¿¤â¤Î¤Ç¤¹¡Ë


ÈÖ¹æ ÈÖ¹æ2 ­¡ ­¢ ­£
1 1 74.1 73.5 71 =AVERAGE()
2 4 68.1 67.6 69.6 =AVERAGE()
3 5 70.7 72.5 69.1 =AVERAGE()
4 6 71.7 72.7 73.2 =AVERAGE()
5 7 67.7 65.4 68 =AVERAGE()
6 9 72.7 74.5 71.1 =AVERAGE()
7 11 66.9 64.3 66.1 =AVERAGE()
8 12 66.8 64.6 64.4 =AVERAGE()
9 13 71.1 70.5 73.2 =AVERAGE()
10 14 68.8 65.3 66.1 =AVERAGE()
11 15 67.8 69.6 65.5 =AVERAGE()
12 18 67 68.1 70.1 =AVERAGE()
13 19 73.2 74 70.3 =AVERAGE()
14 20 67 68.6 67 =AVERAGE()
15 21 67.8 65.9 67.7 =AVERAGE()
16 22 72.7 70.6 71.4 =AVERAGE()
17 25 67 66.6 70.1 =AVERAGE()
18 27 70.8 70.3 68.8 =AVERAGE()
19 28 67.8 70.4 68.7 =AVERAGE()
20
21
22
23
24
25

¤½¤ì¤È¤¢¤Þ¤é¤µ¤ó¤¬»È¤ï¤ì¤Æ¤¤¤ëLibreOffice¤Îcalc¤È¤¤¤¦¤Î¤ò»È¤Ã¤Æ¤ß¤Þ¤·¤¿¤é
¤·¤Ã¤«¤ê¤È¤Ç¤­¤Þ¤·¤¿¡£
¥¨¥¯¥»¥ë¤È¤Ï¤Á¤¬¤¦¤â¤Î¤Ê¤Î¤Ç¤·¤ç¤¦¤«¡©



É´¹ç»Ò

¥ê¥ó¥¯

2018/3/8(Thu) 11:04:52|NO.82674

¤¢¤Þ¤é¤µ¤ó¤Þ¤¿¤ª´ê¤¤¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¦¤Î¤Ç¤¹¤¬¡¢
¹Ô¤Î¤è¤¦¤ËÎó¤â£±ÎóÌܤÈ2ÎóÌܤ˴֤ò¤È¤ë¤è¤¦¤Ê¤³¤È¤Ï¤Ç¤­¤ë¤Ç¤·¤ç¤¦¤«¡©
¥Ç¡¼¥¿1¡¡1ÎóÌÜ¡¢2ÎóÌÜ¡¢3ÎóÌÜ¡¦¡¦¡¦
¥Ç¡¼¥¿2¡¡1ÎóÌÜ¡¢2ÎóÌܡʶõÇò¤ÎÎó¡Ë¡¢3ÎóÌܡʥǡ¼¥¿1¤Î2ÎóÌÜ¡Ë¡¢4ÎóÌܡʥǡ¼¥¿1¤Î3ÎóÌÜ¡Ë¡¦¡¦¡¦

¤¤¤í¤ó¤Ê¤³¤È¤òʹ¤¤¤Æ¤·¤Þ¤¤¤¹¤ß¤Þ¤»¤ó¡£



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/8(Thu) 11:35:10|NO.82675

¤¢¤ì¡Ä¤Á¤ã¤ó¤È¥¿¥Ö¶èÀÚ¤ê¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¤Í
¥¿¥Ö¤Î¥³¡¼¥É¤¬°ã¤¦¤ó¤Ç¤·¤ç¤¦¤«¡©
¥Ð¥¤¥Ê¥ê¥¨¥Ç¥£¥¿¤Ç¤½¤Î¥Õ¥¡¥¤¥ë¤Î¥¿¥Ö¤Î°ÌÃÖ¤Îʸ»ú¥³¡¼¥É¤ò¸«¤ë¤È¤ï¤«¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¡¢
¤¹¤ß¤Þ¤»¤ó¤¬Excel¤Ç½ÐÎϤµ¤ì¤¿¥Õ¥¡¥¤¥ë¤ò¤³¤Á¤é¤ÇºÙ¤«¤¯³Îǧ¤Ç¤­¤Ê¤¤¤Î¤Ç¤ï¤«¤ê¤Þ¤»¤ó¡£

LibreOffice¤Ï¸µ¡¹¥ª¡¼¥×¥ó¥½¡¼¥¹¤Ç
Office¤ÈƱ¤¸¤è¤¦¤Ê¤³¤È¤¬½ÐÍè¤ë¥½¥Õ¥È¤òÌܻؤ·¤Æ³«È¯¤µ¤ì¤Æ¤­¤¿Êª¤Ê¤Î¤Ç
¸«¤¿ÌܤäÆ°ºî¤¬Èó¾ï¤Ë»÷¤Æ¤¤¤Þ¤¹¤¬¡¢

Office¤Ë¤¢¤ë¤è¤¦¤Ê¤³¤ì¤ÏÊ̤ËÍפé¤Ê¤¤¤À¤í¤¦¤È¤¤¤¦µ¡Ç½¤¬ºï¤é¤ì¤Æ¤¤¤¿¤ê¡¢
µÕ¤Ë¤³¤¦¤¤¤¦¤³¤È¤â½ÐÍ褿¤é¤¤¤¤¤Î¤Ë¤È¤¤¤¦µ¡Ç½¤¬Äɲ䵤ì¤Æ¤¤¤¿¤ê¡¢
¡Êº£²ó¤Ç¸À¤¦¤ÈCSV¤ÇÆɤ߽ñ¤­¤¹¤ë¤È¤­¤Ë¶èÀÚ¤êʸ»ú¤ò¹¥¤­¤ËÁª¤Ù¤ë¤è¤¦¤Ë¡Ë
Èù̯¤Ë°ã¤¦½ê¤â·ë¹½¤¢¤ê¤Þ¤¹¡£



>¹Ô¤Î¤è¤¦¤ËÎó¤â£±ÎóÌܤÈ2ÎóÌܤ˴֤ò¤È¤ë¤è¤¦¤Ê¤³¤È¤Ï¤Ç¤­¤ë¤Ç¤·¤ç¤¦¤«¡©
¤½¤ì¤Ï²Äǽ¤Ê¤Ï¤º¤Ç¤¹¡£
¶õ¤¤¤Æ¤¤¤ëÎó¤ÏÊݸ¤¹¤ë¤È¤­¤Ë¡¢""¡Ú¥¿¥Ö¡Û¤È¤Ê¤ê
²¿¤â¥Ç¡¼¥¿¤¬¤Ê¤¤Îó¤¬Æþ¤ê¤Þ¤¹¡£
LibreOffice¤Ç¤Ï¤¢¤ê¤Þ¤¹¤¬²¿ÅÙ¤«³Îǧ¤·¤¿¤Î¤Ç
´Ö°ã¤¤¤Ê¤¯¶õ¤ÎÎó¤¬Æþ¤ê¤Þ¤·¤¿¡£



É´¹ç»Ò

¥ê¥ó¥¯

2018/3/8(Thu) 13:49:32|NO.82676

¤¢¤Þ¤é¤µ¤ó¡¢ÀâÌÀ¤¬¤Ø¤¿¤Ç¤¹¤ß¤Þ¤»¤ó¡£

¡Ö¹Ô¤Î¤è¤¦¤ËÎó¤â£±ÎóÌܤÈ2ÎóÌܤ˴֤ò¤È¤ë¤è¤¦¤Ê¤³¤È¤Ï¤Ç¤­¤ë¤Ç¤·¤ç¤¦¤«¡©¡×
¤¢¤Þ¤é¤µ¤ó¤Ëºî¤Ã¤Æ¤â¤é¤Ã¤¿¥³¡¼¥É¤Ç¼Â¹Ô²èÌ̾å¤ÇAÎó¤ÏAÎó¡¢BÎó¤ò¤ÏCÎó¤ß¤¿¤¤¤Ê»ØÄ꤬
½ÐÍè¤ë¤è¤¦¤Ë¤Ê¤Ã¤¿¤ê¤·¤Þ¤¹¤«¡©

¥Ç¡¼¥¿1¡ÊÆɤ߹þ¤ß¥Õ¥¡¥¤¥ë¡Ë
A B C D E
ÈÖ¹æ ÈÖ¹æ2 ­¡ ­¢ ­£
1 1 74.1 73.5 71 =AVERAGE()
2 4 68.1 67.6 69.6 =AVERAGE()
3 5 70.7 72.5 69.1 =AVERAGE()
¡¦
¡¦
¡¦

¥Ç¡¼¥¿2¡Ê½ñ¤­¹þ¤ß¥Õ¥¡¥¤¥ë¡Ë
A B C D E¡¡£Æ
ÈÖ¡¡¶õÇò¡¡¹æ ÈÖ¹æ2 ­¡ ­¢ ­£
1 ¶õÇò¡¡1 74.1 73.5 71 =AVERAGE()
2¡¡¶õÇò¡¡ 4 68.1 67.6 69.6 =AVERAGE()
3¡¡¶õÇò¡¡ 5 70.7 72.5 69.1 =AVERAGE()
¡¦
¡¦
¡¦
½ÐÎϤ¹¤ë¤È¤­¤ËA¤Ï¤½¤Î¤Þ¤Þ¤ÇB¤ò¶õÇò¤Ë¤·¤Æ¡¡C,D,E,F¤Ë½ñ¤¯¤è¤¦¤Ê´¶¤¸¤Ç¤¹¡£

¤Ç¤­¤ë¤Ç¤·¤ç¤¦¤«¡©



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/8(Thu) 14:32:27|NO.82677

¤³¤Á¤é¤âÀâÌÀ¤¬°­¤«¤Ã¤¿¤Ç¤¹¤Í¡£

>¤¢¤Þ¤é¤µ¤ó¤Ëºî¤Ã¤Æ¤â¤é¤Ã¤¿¥³¡¼¥É¤Ç¼Â¹Ô²èÌ̾å¤ÇAÎó¤ÏAÎó¡¢BÎó¤ò¤ÏCÎó¤ß¤¿¤¤¤Ê»ØÄ꤬
>½ÐÍè¤ë¤è¤¦¤Ë¤Ê¤Ã¤¿¤ê¤·¤Þ¤¹¤«¡©
¤Ê¤Ã¤Æ¤¤¤Þ¤¹¤è¡£

¾¯¤·¥Ç¡¼¥¿¤Çµ¤¤Ë¤Ê¤ë½ê¤¬¤¢¤ê¤Þ¤¹¤¬
¼Â¹Ô²èÌ̤ǤÎÎó¤Î½é´üÃͤÏ
¡ØA B C D E F¡Ù
¤È¤Ê¤Ã¤Æ¤¤¤ë¤«¤È»×¤¤¤Þ¤¹

¤½¤³¤òÎ㤨¤Ð
¡ØA C G H I J¡Ù
¤È¤·¤Æ¹¹¿·¡õÊݸ¤¹¤ë¤È
Èô¤Ð¤·¤¿Îó¡ØB D E F¡Ù¤Ï¶õÇò¤·¤ÆÊݸ¤µ¤ì¤Æ¤¤¤ë¤Ï¤º¤Ç¤¹¡£


°Ê²¼µ¤¤Ë¤Ê¤ë½ê
>¥Ç¡¼¥¿1¡ÊÆɤ߹þ¤ß¥Õ¥¡¥¤¥ë¡Ë
>ÈÖ¹æ ÈÖ¹æ2 ­¡ ­¢ ­£
¤È¤Ê¤Ã¤Æ¤¤¤Þ¤¹¤¬¡¢
ºÇ½é¤Î¹Ô¤Ç²¿Î󤢤ë¤Î¤«¡ÊºÇ½é¤Î¹Ô¤Î¥¿¥Ö¤Î¿ô¡Ü£±¤¬Îó¿ô¡Ë¤ò¿ô¤¨¤Æ¤¤¤ë¤Î¤Ç
ÈÖ¹æ ÈÖ¹æ2 ­¡ ­¢ ­£ Ê¿¶Ñ
¤È¤·¤Æ6ÎóÁ´¤Æ¤Ë²¿¤é¤«¤Îʸ»ú¤òÆþ¤ì¤¿Êý¤¬³Î¼Â¤ËÎ󤬿ô¤¨¤é¤ì¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¡£

¤â¤·¤¯¤Ï
¥½¡¼¥¹¤Î88¹ÔÌÜ
noteget data0, 0; // 0¹ÔÌܼèÆÀ
¤³¤Î²Õ½ê¤ò

noteget data0, 1; // 1¹ÔÌܼèÆÀ
¤È¤·¤Æ1¹ÔÌÜ(ºÇ½é¤«¤é2ÈÖÌܤιÔ)¤ÎÊý¤ÇÎó¿ô¤ò¿ô¤¨¤ëÊý¼°¤ËÊѹ¹¤·¤Æ¤¯¤À¤µ¤¤¡£



>¥Ç¡¼¥¿2¡Ê½ñ¤­¹þ¤ß¥Õ¥¡¥¤¥ë¡Ë
>A B C D E¡¡£Æ
>ÈÖ¡¡¶õÇò¡¡¹æ ÈÖ¹æ2 ­¡ ­¢ ­£
¡ØÈÖ¡¡¶õÇò¡¡¹æ¡Ù¤³¤ì¤Ï¥ß¥¹¤Ç¤¹¤è¤Í¡©
°ì¥ö½ê¤À¤±¤Î¥»¥ë¤Îʬ³ä¤ß¤¿¤¤¤Ê»ö¤Þ¤Ç¤Ï
¤µ¤¹¤¬¤Ë¤´¼«Ê¬¤Ç¤ä¤Ã¤Æ¤¤¤¿¤À¤­¤¿¤¤¤Ç¤¹¡Ê¡°¡°¡¨



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/8(Thu) 14:45:30|NO.82678

Äɵ­

>¼Â¹Ô²èÌ̤ǤÎÎó¤Î½é´üÃͤÏ
>¡ØA B C D E F¡Ù
>¤È¤Ê¤Ã¤Æ¤¤¤ë¤«¤È»×¤¤¤Þ¤¹

>¤½¤³¤òÎ㤨¤Ð
>¡ØA C G H I J¡Ù
>¤È¤·¤Æ¹¹¿·¡õÊݸ¤¹¤ë¤È
>Èô¤Ð¤·¤¿Îó¡ØB D E F¡Ù¤Ï¶õÇò¤·¤ÆÊݸ¤µ¤ì¤Æ¤¤¤ë¤Ï¤º¤Ç¤¹¡£

AÎó¤ÏAÎó¤Î¤Þ¤Þ
BÎó¤ÏCÎó¤Ë
ƱÍͤËC¡¢D¡¢E¡¢FÎó¤ÏG¡¢H¡¢I¡¢JÎó¤È¤·¤Æ°ÜÆ°¤µ¤ìÊݸ¤µ¤ì¤Þ¤¹¡£



É´¹ç»Ò

¥ê¥ó¥¯

2018/3/8(Thu) 16:54:12|NO.82679

¤¢¤Þ¤é¤µ¤ó²¿Å٤ⲿÅ٤⤹¤ß¤Þ¤»¤ó¡£

>¼Â¹Ô²èÌ̤ǤÎÎó¤Î½é´üÃͤÏ
>¡ØA B C D E F¡Ù

¼Â¹Ô²èÌ̤Ǥʤ¼¤«A¤·¤«½Ð¤Æ¤­¤Þ¤»¤ó¡£¤¢¤È¡ôerror7 in line 172¤È½Ð¤Æ¤­¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¡£
Ê¿¶Ñ¤Î=AVERAGE()¤Îʸ»ú¤¬°­¤¤¤Î¤Ç¤·¤ç¤¦¤«¡©
¥¨¥¯¥»¥ë¤«¤écvs¤ËÊѤ¨¤ë¤È¤­Ê¿¶Ñ¤¬¿ô»ú¤Ë¤â¤Ê¤ë¤è¤¦¤Ê¤Î¤Ç¡¢
ʸ»ú¤Ç¤Ê¤¯¿ôÃͤǹԤ¦¾ì¹ç¤Ï´Êñ¤ËÊѤ¨¤é¤ì¤ë¤Ç¤·¤ç¤¦¤«¡©
¤½¤ÎÉôʬ¤é¤·¤¤¤È¤³¤í¤ò¾Ã¤·¤¿¤ê¤·¤¿¤Î¤Ç¤¹¤¬¡¢
¤¦¤Þ¤¯¤¤¤­¤Þ¤»¤ó¤Ç¤·¤¿¡£



É´¹ç»Ò

¥ê¥ó¥¯

2018/3/8(Thu) 17:08:50|NO.82680

¤¢¤Þ¤é¤µ¤ó
º£csv¤òtxt¡Ê¥¿¥Ö¶èÀÚ¤ê¡Ë¤ËÊѤ¨¤Æ¤ß¤¿¤é¡¢¤·¤Ã¤«¤ê¼Â¹Ô¤Ç¤­¤Þ¤·¤¿¡£



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/8(Thu) 17:28:20|NO.82681

¤¢¡¼¤ä¤Ã¤Ñ¤ê¥¿¥Ö¤Ç¤Ê¤¯¥³¥ó¥Þ¶èÀÚ¤ê¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤·¤¿¤«¡£


¸å¤Ï°ì±þÊ䭤Ȥ·¤Æ

A¤·¤«½Ð¤ÆÍè¤Ê¤¤¤È¤¤¤¦¤³¤È¤Ï¡¢Îó¤¬1¤Ä¤·¤«¤Ê¤¤¤È¤¤¤¦¤³¤È¤Ç
¥¿¥Ö¤¬¥«¥¦¥ó¥È¤µ¤ì¤Æ¤¤¤Þ¤»¤ó¤Í¡£
¤¿¤Ö¤ó¥³¥ó¥Þ¶èÀÚ¤ê¤È¤«Ê̤ζèÀڤ국¹æ¥Õ¥¡¥¤¥ë¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤Ã¤Æ¤¤¤ë¤Î¤Ç¤·¤ç¤¦¡£

6ÎóÌÜ¡ÊFÎó¤Î¤³¤È¡Ë¤ò¸ÇÄê¤ÇÊ¿¶ÑÃÍ´Ø¿ô¤À¤È¤¤¤¦Á°Äó¤Ç¹¹¿·¤·¤Æ¤¤¤ë¤Î¤Ç
A¤·¤«¤Ê¤¤¤È¤¤¤¦¤Î¤Ç¡¢¤¿¤Ö¤óÇÛÎóÊÑ¿ô¤Î»²¾È¥¨¥é¡¼¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤Ã¤Æ¤¤¤ë¤Î¤À¤È»×¤ï¤ì¤Þ¤¹¡£
172¹ÔÌܤΡ¡data1(5, cnt)¡¡¤¬¡¢Æɤ߹þ¤ó¤À¥Ç¡¼¥¿¤ÎFÎó¡Ê5¡Ë¤ÎǤ°Õ¤Î¹Ô¡Êcnt¡Ë¤ò
»²¾È¤È¤¤¤¦°ÕÌ£¤Ç¤¹¡£



>Ê¿¶Ñ¤Î=AVERAGE()¤Îʸ»ú¤¬°­¤¤¤Î¤Ç¤·¤ç¤¦¤«¡©
¤³¤³¤Ç¸«¤Æ¤¤¤ë¤Î¤ÏºÇ½é¤Î¡Ö=¡×¤À¤±¤Ê¤Î¤Ç
¤½¤Î¸å¤¬¤É¤ó¤Êʸ»ú¤À¤í¤¦¤¬¿ô»ú¤À¤í¤¦¤¬µ­¹æ¤À¤í¤¦¤¬´Ø·¸¤¢¤ê¤Þ¤»¤ó¡£
¤à¤·¤í¡Ö=¡×¤À¤±¤Ç¤âAVERAGE´Ø¿ô¤È¤ß¤Ê¤·¤Æ¹¹¿·»þ¤Ë
¼«Æ°¤Ç =AVERAGE(C2,D2,E2) ¤Ê¤É¤Ë½ñ¤­´¹¤¨¤Þ¤¹¡£
Ê̤η׻»¼°¤Ç¤âAVERAGE¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¦¤Î¤Ç¡¢¤½¤³¤ÏÃí°Õ¤·¤Æ¤¯¤À¤µ¤¤¡£



¤¢¤Þ¤é

¥ê¥ó¥¯

2018/3/8(Thu) 17:47:14|NO.82682

ºÇ½é¤Ë¥½¡¼¥¹¤ò¤Î¤»¤¿¤È¤­¤È¤½¤ÎÁ°¤Ç¡¡¥Æ¥­¥¹¥È¡Ê¥¿¥Ö¶èÀÚ¤ê¡Ë¤Ç¡Á
¤È·Ú¤¯½ñ¤¤¤Æ¤¤¤¿¤ó¤Ç¤¹¤¬¡¢¥½¡¼¥¹Æâ¤Î¥Õ¥¡¥¤¥ë̾¤Ê¤É¤¬csv¤Ë¤Ê¤Ã¤Æ¤¤¤¿¤»¤¤¤Ç
¿§¡¹¤Èº®Í𤵤»¤Æ¤·¤Þ¤Ã¤¿¤è¤¦¤Ç¤¹¤Í¡£

°ì±þ½¤ÀµÈÇÁ´¥½¡¼¥¹¤ò¤Î¤»¤Æ¤ª¤­¤Þ¤¹¡£
filename¤Ï¹¥¤­¤Ê¤è¤¦¤ËÊѤ¨¤Æ¤¯¤À¤µ¤¤¡£

// ³ÆÊÑ¿ôÅù¤Î½é´ü²½ #const TAB 0x09 // ¥¿¥Öʸ»ú¥³¡¼¥É #const CEL 100 // ¥»¥ë¤Ë´Þ¤Þ¤ì¤ëºÇÂçʸ»ú¿ô¡ÊExcel¤Ç¤Ï 32,767¤é¤·¤¤¤±¤Éº£²ó¤Ï¤½¤ó¤Ê¤Ë»È¤ï¤Ê¤¤¡Ë #const IPTW 80 // ÆþÎϥܥ寥¹Éý #const IPTH 20 // ÆþÎϥܥ寥¹¹â¤µ filename1 = "¥¿¥Ö¶èÀÚ¤ê¤ÎCSV¤È¤«TXT¤Î¥Õ¥¡¥¤¥ë̾"; // Æɤ߹þ¤à¥Õ¥¡¥¤¥ë̾ filename2 = "Êݸ¤¹¤ë¤È¤­¤Î¥Õ¥¡¥¤¥ë̾"; // Êݸ¤¹¤ë¥Õ¥¡¥¤¥ë̾ data1c = 0; // ¥Ç¡¼¥¿1¤ÎÎó¿ô data1r = 0; // ¥Ç¡¼¥¿1¤Î¹Ô¿ô screen 0, 800, 600, 0; #module // ¿ôÃͤò¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤ËÊÑ´¹ #defcfunc NumToA int p01 rcstr = ""; // 1ʸ»úÌܤÏA¤ò0¡¡2ʸ»úÌܰʾå¤ÏA¤ò1¤È¹Í¤¨¤ë if( (p01 / 676) == 0 ) { if( (p01 / 26) == 0 ) { // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È1ʸ»ú poke rcstr, 0, p01+0x41; poke rcstr, 1, 0; } else { // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È2ʸ»ú poke rcstr, 0, p01/26+0x40; poke rcstr, 1, p01\26+0x41; poke rcstr, 2, 0; } } else { // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È3ʸ»ú poke rcstr, 0, p01/676+0x40; poke rcstr, 1, (p01\676)/26+0x40; poke rcstr, 2, (p01\676)\26+0x41; poke rcstr, 3, 0; } return rcstr; // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤ò¿ôÃͤËÊÑ´¹ #defcfunc AToNum str s01 len = strlen(s01); s02 = s01; if( len == 3 ) { // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È3ʸ»ú¤Î¾ì¹ç rcint = (peek(s02, 0)-0x40)*676 + (peek(s02, 1)-0x40)*26 + (peek(s02, 2)-0x41); } else:if( len == 2 ) { // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È1ʸ»ú¤Î¾ì¹ç rcint = (peek(s02, 0)-0x40)*26 + (peek(s02, 1)-0x41); } else { // ¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È1ʸ»ú¤Î¾ì¹ç rcint = peek(s02, 0)-0x41; } return rcint; // ¾®Ê¸»ú¤òÂçʸ»ú¤ØÊÑ´¹ #defcfunc aToA str s01 len = strlen(s01); rcstr = s01; repeat len w = peek(rcstr, cnt); if( (0x61 <= w) && (w <= 0x7A) ) { poke rcstr, cnt, w-0x20; } loop return rcstr; #global // ¥Ç¡¼¥¿1¥Õ¥¡¥¤¥ë¤ÎÆɤ߹þ¤ß sdim csvdata1, 64; // Æɤ߹þ¤ß»þ¤Ë¼«Æ°¤ÇÍÆÎ̳ÎÊݤµ¤ì¤ë¤¿¤á¿ô»ú¤ÏŬÅö notesel csvdata1; noteload filename1; data1r = notemax; // ¹Ô¿ô¼èÆÀ // Îó¿ô¼èÆÀ½èÍý sdim data0, 64; noteget data0, 0; // 0¹ÔÌܼèÆÀ idxmax = strlen(data0); repeat idxmax // 0¹ÔÌܤ˴ޤޤì¤ë¥¿¥Ö¤Î¿ô¤ò¿ô¤¨¤ë¡Ê¥¿¥Ö¿ô¡Ü£±¤¬Îó¿ô¤Ë¤Ê¤ë¡Ë p01 = peek(data0, cnt); if( p01 == TAB ) { data1c++; } loop data1c++; // ºÇ¸å¤Ë¡Ü£±¤¬Îó¿ô¤Ë¤Ê¤ë // ¥Ç¡¼¥¿1¥Õ¥¡¥¤¥ë¤ÎÆâÍƤò¥»¥ëñ°Ì¤ÇÊÑ¿ô¤Ë½ñ¤­¹þ¤à sdim data1, CEL, data1c, data1r; // data1(Îó, ¹Ô)¤Î½ç repeat data1r sdim data0, 64; // °ì±þÊÑ¿ô½é´ü²½ noteget data0, cnt; // ¹Ô¼èÆÀ cnt1 = cnt; idx = 0; repeat data1c getstr data1(cnt, cnt1), data0, idx, TAB; idx += strsize; loop loop // ¥ª¥Ö¥¸¥§¥¯¥ÈÇÛÃÖ objsize IPTW, IPTH; dim objidr, data1r; // ¹Ô¿ôʬ dim rnums, data1r; dim objidc, data1c; // Îó¿ôʬ sdim cnums, data1c; // ¹Ô¡Ê¿ô»ú¤ÎÆþÎϥܥ寥¹¡Ë pos 0, IPTH; repeat data1r rnums(cnt) = cnt+1; input rnums(cnt); objidr(cnt) = stat; loop // Îó¡Ê¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤ÎÆþÎϥܥ寥¹¡Ë repeat data1c pos IPTW*(cnt+1), 0; cnums(cnt) = NumToA(cnt); input cnums(cnt); objidc(cnt) = stat; loop pos 700, 0; button gosub "´Ø¿ô¤Î¹¹¿·", *replace; pos 700, 40; button gosub "CSVÊݸ", *save; gosub *print_data; stop; *print_data // ¥Ç¡¼¥¿É½¼¨ color 255, 255, 255:boxf; color 0, 0, 0; repeat data1r y = (cnt+1)*IPTH; cnt1 = cnt; repeat data1c x = (cnt+1)*IPTW; pos x, y; mes data1(cnt, cnt1); loop loop return; *replace // ¤Ä¤¤¤Ç¤ËÎó¤Î¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤òÁ´¤ÆÂçʸ»ú¤ËÊÑ´¹ repeat data1c cnums(cnt) = aToA(cnums(cnt)); objprm objidc(cnt), cnums(cnt); loop // ´Ø¿ô¤ÎÀ°·Á repeat data1r // 1ʸ»úÌܤ¬=¤Ê¤é¤Ð´Ø¿ô¤ÈȽÃǤ¹¤ë if( peek(data1(5, cnt), 0) == '=' ) { cel01 = ""+cnums(2)+""+rnums(cnt)+""; // AVERAGE´Ø¿ô¡¡¥»¥ë1¤ÄÌÜ cel02 = ""+cnums(3)+""+rnums(cnt)+""; // AVERAGE´Ø¿ô¡¡¥»¥ë2¤ÄÌÜ cel03 = ""+cnums(4)+""+rnums(cnt)+""; // AVERAGE´Ø¿ô¡¡¥»¥ë3¤ÄÌÜ data1(5, cnt) = "=AVERAGE("+cel01+","+cel02+","+cel03+")"; } loop gosub *print_data; return; *save // CSVÊݸ½èÍý col = AToNum(cnums(data1c-1))+1; // Ê¿¶Ñ¤ÎÎó¤ò°ìÈÖ±¦Ã¼¤È¤¹¤ë row = rnums(data1r-1); // °ìÈÖ²¼¤Î¹Ô¤òºÇ½ª¹Ô¤È¤¹¤ë sdim data2, CEL, col, row; // ÊݸÍѥǡ¼¥¿ // ºÇ½é¤ËÁ´¤Æ¤ò¥À¥Ö¥ë¥¯¥©¡¼¥Æ¡¼¥·¥ç¥ó+¶èÀڤ국¹æ¡Ê¥¿¥Ö¡Ë¤Ë¤¹¤ë repeat row cnt1 = cnt; repeat col if( (cnt+1) == col ) { data2(cnt, cnt1) = "\"\""; } else { data2(cnt, cnt1) = "\"\"\t"; } loop loop // 1¹Ô¤º¤Ä¥Ç¡¼¥¿¤ò³ÊǼ¤¹¤ë repeat data1r cnt1 = cnt; r = rnums(cnt)-1; repeat data1c c = AToNum(cnums(cnt)); if( data1(cnt, cnt1) == "" ) { // ¶õ¥Ç¡¼¥¿¤Ï¥À¥Ö¥ë¥¯¥©¡¼¥Æ¡¼¥·¥ç¥ó¤òÆþ¤ì¤Æ¤ª¤¯ data2(c, r) = "\"\""; } else { data2(c, r) = data1(cnt, cnt1); } if( (cnt+1) != data1c ) { // ¹ÔËö¤Ç¤Ê¤±¤ì¤Ð¶èÀڤ국¹æ¡Ê¥¿¥Ö¡Ë¤òÄɲà data2(c, r) += "\t"; } loop loop // ÊݸÍÑCSV¥Ç¡¼¥¿ºîÀ® csvdata2 = ""; notesel csvdata2; repeat row data0 = ""; cnt1 = cnt; repeat col data0 += data2(cnt, cnt1); loop noteadd data0, cnt; loop notesave filename2; dialog ""+filename2+"¤ËÊݸ¤·¤Þ¤·¤¿¡£", 0, "¥Õ¥¡¥¤¥ë½ÐÎÏ"; return;



É´¹ç»Ò

¥ê¥ó¥¯

2018/3/8(Thu) 19:04:51|NO.82683

¤¢¤Þ¤é¤µ¤ó¤Ç¤­¤Þ¤·¤¿¡£
¤¤¤í¤¤¤íËÜÅö¤Ë¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
»ä¤â¤³¤ó¤Ê¥³¡¼¥É¤¬¤Ç¤­¤ë¤è¤¦¤ËÊÙ¶¯¤¬¤ó¤Ð¤ê¤Þ¤¹¡£



ONION software Copyright 1997-2023(c) All rights reserved.