[B! google spreadsheets] aki77ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

aki77 id:aki77

google spreadsheetsã«é–¢ã™ã‚‹aki77ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (25)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Node.js quickstart Â |Â Google Sheets Â |Â Google for Developers
Send feedback Node.js quickstart Stay organized with collections Save and categorize content based on your preferences. Quickstarts explain how to set up and run an app that calls a Google Workspace API. Google Workspace quickstarts use the API client libraries to handle some details of the authentication and authorization flow. We recommend that you use the client libraries for your own apps. Thi
aki77 2016/12/07
node.js

google spreadsheets
ãƒªãƒ³ã‚¯
Google Sheets REST API, connect Google Spreadsheet with your site
Turn a Google Spreadsheet into a JSON API Connect Google sheets to CRM, API, Website, WordPress, any application or tool. Create Free API Use Cases Documentation [ { "id": "1", "name": "Tom", "age": "15", "comment": "" }, { "id": "2", "name": "Alex", "age": "24", "comment": "" } ] Easy to use and implement SheetDB will turn your sheets into a JSON API, easy to integrate with other tools and all pr
aki77 2015/12/16
api

google spreadsheets
ãƒªãƒ³ã‚¯
ä»•äº‹ãŒ10å€æ—ã‚‹ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆç¥žé–¢æ•°10 | Tokyo Otaku Mode Blog
ã“ã‚“ã«ã¡ã¯ã€‚Tokyo Otaku Modeã®å®‰å®…ã§ã™ã€‚å…ˆæ—¥ã‹ã‚‰ã€ã¨ã‚ã‚‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ã‚¸ãƒ§ã‚¤ãƒ³ã—ã¦ã€ä¹…ã€…ã«Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’ã‚´ãƒªã‚´ãƒªæ´»ç”¨ã—ã¦ä»•äº‹ã‚’ã—ã¦ã„ã¾ã™ã€‚ãã‚“ãªä¸ã€ã“ã‚Œã¯æƒšã‚ŒãŸï¼ã¨ã„ã†ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ç¥žé–¢æ•°ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ARRAYFORMULAé–¢æ•° ã“ã‚Œã‚’æ´»ç”¨ã—å§‹ã‚ã¦ã‹ã‚‰ã€é–¢æ•°ã‚’ã„ã¡ã„ã¡å…¨éƒ¨ã®è¡Œã«åŸ‹ã‚è¾¼ã‚“ã§ã„ãã“ã¨ãŒã€ãªã‚“ã ã‹ã‚«ãƒƒã‚³æ‚ªãæ„Ÿã˜ã‚‹ãã‚‰ã„ã€ã‚¹ãƒžãƒ¼ãƒˆã§ã‚ªã‚·ãƒ£ãƒ¬ãªé–¢æ•°ã§ã™ã€‚ä¾‹ãˆã°ã€100è¡Œã®VLOOKUPé–¢æ•°ã‚’è¡Œã†ã¨ãã«ã¯ã€ã“ã‚Œã¾ã§ã¯VLOOKUPé–¢æ•°ã‚’1ã¤ä½œã£ã¦ã€ãã‚Œã‚’æ®‹ã‚Š99å€‹ã®è¡Œã«VLOOKUPé–¢æ•°ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã„ãŸã¨æ€ã„ã¾ã™ãŒã€ARRAYFORMULAé–¢æ•°ã‚’ä½¿ã†ã¨ã€ãªã‚“ã¨1å€‹ã®é–¢æ•°ã§100è¡Œåˆ†ã®å€¤ãŒå‡ºåŠ›ã•ã‚Œã¾ã™ã€‚å®Ÿéš›ã«å‹•ä½œã‚‚è»½ããªã‚‹ã®ã§ã‚«ãƒƒã‚³ã‚ˆã•ã¨å®Ÿç”¨æ€§ã‚’å…¼ãå‚™ãˆãŸé–¢æ•°ã§ã™ã€‚é…åˆ—ã«å¯¾å¿œã™ã‚‹é–¢æ•°ã§ã‚ã‚Œã°ã€ã»ã¼ãªã‚“ã§ã‚‚åˆ©ç”¨ã§ãã‚‹ã®ã‚‚å¥½æ„Ÿåº¦ãŒé«˜ã„ã§ã™ã€‚
aki77 2015/09/25
google spreadsheets
ãƒªãƒ³ã‚¯
https://jp.techcrunch.com/2014/10/14/20141013google-sheets-gets-smart-autofill-to-predict-unknown-values/
aki77 2014/10/14
google spreadsheets
ãƒªãƒ³ã‚¯
Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã«æ›¸ã„ãŸå†…å®¹ã‚’tableã§å®Ÿè£…ã™ã‚‹jQueryãƒ—ãƒ©ã‚°ã‚¤ãƒ³ãƒ»Sheetrock - ã‹ã¡ã³ã¨.net
Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã«æ›¸ã„ãŸå†…å®¹ã‚’tableã§å®Ÿè£…ã™ã‚‹jQueryãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã®ã”ç´¹ä»‹ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ã‚’æ‰‹è»½ã«Webã‚µã‚¤ãƒˆã«è¡¨ç¤ºå‡ºæ¥ã‚‹ã®ã¯æ¥½ã§ã„ã„ã§ã™ãã€‚ Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’tableã§è¡¨ç¤ºã™ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ã™ã€‚ä»¥å‰ã«ã‚‚ä¼¼ãŸã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ã”ç´¹ä»‹ã—ã¦ã„ã‚‹ã®ã§é¸æŠžè‚¢ã®ä¸€ã¤ã¨ã—ã¦ã€‚ ç©ºã®tableã«ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã«æ›¸ã‹ã‚ŒãŸå†…å®¹ãŒæŒ¿å…¥ã•ã‚Œã¦ã„ã¾ã™ã€‚ var mySpreadsheet = 'https://docs.google.com/spreadsheet/foo?key=bar#gid=0'; èªã¿è¾¼ã¿ãŸã„ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’æŒ‡å®šã—ã¾ã™ã€‚ $('#hoge').sheetrock({ url: mySpreadsheet }); tableã‚’ã‚»ãƒ¬ã‚¯ã‚¿ã«è¨å®šã—ã¦ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’èªã¿è¾¼ã¿ã¾ã™ã€‚ <table id="hoge"></table> tableã‚’ç”¨æ„ã™ã‚Œã°OKã€‚ æ‰‹è»½ã§è‰¯
aki77 2014/08/01
google spreadsheets

javascript
ãƒªãƒ³ã‚¯
Spreadsheetsã¨Confluenceã§ãŠæ‰‹è£½ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã‚’æ§‹ç¯‰
ã“ã‚“ã«ã¡ã¯ã€ãƒªãƒ–ã‚»ãƒ³ã‚¹ã®æ¡‚ã§ã™ã€‚ä»Šå›žã¯Google Spreadsheetsã¨Confluenceã‚’ä½¿ã£ãŸãŠæ‰‹è£½ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã®ä½œã‚Šæ–¹ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ã“ã‚Œã¾ã§å¼Šç¤¾ã§ã¯ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã‚’ãã‚Œãžã‚Œã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒå®Ÿè£…ã—ã€ãƒ¡ãƒ‡ã‚£ã‚¢æ¯Žãƒ»æŒ‡æ¨™æ¯Žã«ç”»é¢ã‚’ä½œæˆã—ãŸã‚Šã—ã¦ã„ã¾ã—ãŸã€‚ã—ã‹ã—ã“ã‚Œã«ã¯ ä½œæˆã‚„ã‚°ãƒ©ãƒ•ã®å¤‰æ›´ãªã©ã«æ‰‹é–“ãŒå¤šãã‹ã‹ã‚‹çŸæœŸãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç”¨ã®ã‚‚ã®ãªã©ã‚’ä½œæˆã—ã¥ã‚‰ã„è¦‹ã‚‹ã¹ãç”»é¢ãŒæ•£ä¹±ã—ã¦ã—ã¾ã†å€‹äººæ¯Žã®ç”»é¢ãªã©ã¯ä½œæˆã§ããªã„ã¨ã„ã£ãŸæ¬ ç‚¹ãŒã‚ã‚Šã¾ã—ãŸã€‚ãã“ã§ã€ã©ã†ã™ã‚Œã°ãƒ—ãƒãƒ€ã‚¯ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ‰‹ã‚’å‡ºæ¥ã‚‹ã ã‘ç…©ã‚ã›ã‚‹ã“ã¨ãªãã€ç°¡å˜ã«ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ç·¨é›†ã‚’è¡Œãˆã‚‹ã‹ã‚’è€ƒãˆãŸçµæžœãŒä»Šå›žã®å–ã‚Šçµ„ã¿ã«ãªã‚Šã¾ã™ã€‚å¼Šç¤¾ã§ã¯ç¤¾å†…æƒ…å ±å…±æœ‰ã«åˆ©ç”¨ã—ã¦ã„ã‚‹Atlassianç¤¾ã®Confluenceã‚’æ´»ç”¨ã—ã€Google Spreadsheetsã¨ã‚ã‚ã›ã¦ç°¡æ˜“ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã‚’ä½œæˆã—ã¾ã—ãŸã€‚ ã¡ãªã¿ã«Confluenceã‚’ãŠä½¿ã„ã§ãª
aki77 2014/06/06
google spreadsheets
ãƒªãƒ³ã‚¯
Googleã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ãŒGoogleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ã‚¢ãƒ‰ã‚ªãƒ³ã§åˆ©ç”¨å¯èƒ½ã«ãªã£ãŸ
Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ã‚¢ãƒ‰ã‚ªãƒ³ã§æä¾›é–‹å§‹ çœŸæ‘¯ã®ã„ã¡ã—ã¾ã•ã‚“ã«ã€ãƒ¡ãƒ³ã‚·ãƒ§ãƒ³ã§æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸã®ã§ã™ãŒã€Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§ã€Googleã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã§ãã‚‹ã‚¢ãƒ‰ã‚ªãƒ³ãŒå…¬é–‹ã•ã‚ŒãŸã‚ˆã†ã§ã™ã€‚ Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’ä½œæˆã—ã€ã‚¢ãƒ‰ã‚ªãƒ³ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰å®Ÿè£…ã™ã‚Œã°OKã¨ã„ã†ç°¡å˜ã•ã€‚ ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚‚ã‚·ãƒ³ãƒ—ãƒ«ã§ä½¿ã„ã‚„ã™ãã†ã§ã™ã€‚ ãƒ¬ãƒãƒ¼ãƒˆã‚’ä½œã£ã¦ã™ãå®Ÿè¡Œã¨ã„ã†ç°¡å˜ã• Googleãƒ‰ãƒ©ã‚¤ãƒ–ã‹ã‚‰ã€ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’æ–°è¦ä½œæˆã—ã¾ã™ã€‚ Googleã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ã‚¢ãƒ‰ã‚ªãƒ³ã‚’çµ„ã¿è¾¼ã¿ã¾ã—ãŸã‚‰ã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ã€ã‚¢ãƒ‰ã‚ªãƒ³ï¼žGoogle Analyticsï¼žCreate a New Report ã‚’é¸ã³ã¾ã™ã€‚ã™ã‚‹ã¨ã€ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆå³å´ã«ãƒ‘ãƒ¬ãƒƒãƒˆãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ GAã‚¢ã‚«ã‚¦ãƒ³ãƒˆã€ãƒ—ãƒãƒ‘ãƒ†ã‚£ï¼ˆã‚µã‚¤ãƒˆï¼‰ã€ãƒ“ãƒ¥ãƒ¼ã‚’é¸ã³ã¾ã™ã€‚Nameã¯ä»»æ„ã®åå‰ã§OKã§ã™ã€‚ ãƒ‡ã‚£ãƒ¡ãƒ³ã‚·ãƒ§ãƒ³ï¼ˆç¸¦è»¸ãƒ»dimensionï¼‰ã¨
aki77 2014/03/13
google analytics

google spreadsheets
ãƒªãƒ³ã‚¯
Google Driveã®è£æŠ€ã¾ã¨ã‚ã€ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆç·¨ã€‘
FINDJOB! çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› 2023å¹´9æœˆ29æ—¥ã«FINDJOB!ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§FINDJOB!ã‚’ã”åˆ©ç”¨ã„ãŸã ã„ãŸä¼æ¥æ§˜ã€æ±‚è·è€…æ§˜ã€æ§˜ã€…ãªã”é–¢ä¿‚è€…æ§˜ã€‚ å¤§å¤‰é•·ã‚‰ãFINDJOB!ã‚’ã”æ„›é¡§ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ IT/Webç³»ã®ä»•äº‹ã‚„æ±‚äººãŒã¾ã åºƒãæ™®åŠã—ã¦ã„ãªã„é ƒã«Find Job!ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¦ã‹ã‚‰ ç´„26å¹´é–“ã€å¤šãã®æ–¹ã€…ã«æ”¯ãˆã¦ã„ãŸã ãã€é‹å–¶ã‚’ç¶šã‘ã¦ã¾ã„ã‚Šã¾ã—ãŸã€‚ è»¢è·æˆåŠŸã®ãŠå£°ã€æŽ¡ç”¨æˆåŠŸã®ãŠå£°ãªã©ã€å¬‰ã—ã„è¨€è‘‰ã‚‚ãŸãã•ã‚“ã„ãŸã ãã¾ã—ãŸã€‚ ã¾ãŸFINDJOB!çµŒç”±ã§å…¥ç¤¾ã•ã‚ŒãŸæ–¹ãŒäººäº‹æ‹…å½“ã«ãªã‚Šã€ FINDJOB!ã‚’é€šã˜ã¦ã€æ–°ãŸãªäººæã«å‡ºä¼šã†ã“ã¨ãŒã§ããŸãªã©ã€ ãŸãã•ã‚“ã®ã”ç¸ã‚’ã¤ãã‚‹ã“ã¨ãŒã§ããŸã®ã§ã¯ãªã„ã‹ã¨æ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ 2023å¹´9æœˆ29æ—¥ã‚’ã‚‚ã£ã¦ã€FINDJOB!ã¯ãã®æ´å²ã®å¹•ã‚’ä¸‹ã‚ã™ã“ã¨ã¨ãªã‚Šã¾ã—ãŸãŒã€ ä»Šå¾Œã‚‚ã€IT/Webæ¥ç•Œã‚„ã‚¯ãƒªã‚¨ã‚¤ãƒ†ã‚£ãƒ–
aki77 2013/12/24
google spreadsheets
ãƒªãƒ³ã‚¯
VLOOKUP é–¢æ•°ã«ã‚ˆã‚‹å€¤ã®å‚ç…§ - Google ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§ã€Œæ—¥ä»˜ã€ã‹ã‚‰ã€Œæ›œæ—¥ã€ã‚’è¡¨ç¤º.WEEKDAY é–¢æ•°ã€ã€Œç¯„å›²åã€ã‚’åˆ©ç”¨ã—ã¦
ç‰¹å®šã®å€¤ã«å¯¾å¿œã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’å‚ç…§ã™ã‚‹ã«ã¯ vlookup é–¢æ•°ã€‚ å„å¼•æ•°ã®æ„å‘³ã¯ã€ä»¥ä¸‹ã®é€šã‚Šã€‚ æ¤œç´¢ã™ã‚‹ãŸã‚ã®ã‚ãƒ¼ æ¤œç´¢ã™ã‚‹å¯¾è±¡ã®ãƒ‡ãƒ¼ã‚¿ å–å¾—ã™ã‚‹ãƒ‡ãƒ¼ã‚¿åˆ—ã®ä½ç½®ã€‚(å…ˆé ã®åˆ—ã‚’ 1 ã¨æ•°ãˆã‚‹ã€‚) flase ã‚’æŒ‡å®šã—ã¦ã€å®Œå…¨ã«ä¸€è‡´ã™ã‚‹ã‚‚ã®ã®ã¿è¿”ã™ã€‚è©³ç´°ã¯ä»¥ä¸‹ã‚’å‚ç…§ã€‚ Google ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®é–¢æ•°ãƒªã‚¹ãƒˆ - Google ãƒ‰ãƒ©ã‚¤ãƒ– ãƒ˜ãƒ«ãƒ— ã«ã‚ˆã‚‹ã¨ã€ [ä¸¦ã¹æ›¿ãˆé †åº]ï¼ˆã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯ TRUEï¼‰ã§ã¯ã€é…åˆ—å†…ã®å…ˆé åˆ—ã‚’ä¸¦ã¹æ›¿ãˆã‚‹ã‹ã©ã†ã‹ã‚’æŒ‡å®šã—ã¾ã™ã€‚TRUE ã®å ´åˆã¯ã€æ¤œç´¢æ¡ä»¶ã«ã‚‚ã£ã¨ã‚‚è¿‘ã„ã‚‚ã®ã‚’è¿”ã—ã¾ã™ã€‚FALSE ã®å ´åˆã¯ã€å®Œå…¨ã«ä¸€è‡´ã™ã‚‹ã‚‚ã®ã®ã¿ã‚’è¿”ã—ã¾ã™ã€‚ Documentation/How Tos/Calc: VLOOKUP function - OpenOffice.org Wiki 4. æ›œæ—¥ã«è‰²ä»˜ã‘ã‚’ã—ã¦è¦‹ã‚„ã™ãã™ã‚‹ åœŸæ›œæ—¥ã‚’é’è‰²ã€æ—¥æ›œæ—¥ã‚’èµ¤è‰²ã«ã—ãŸã„ã€‚ãã®ãŸã‚ã«ã¯
aki77 2013/10/01
google spreadsheets
ãƒªãƒ³ã‚¯
Google ãƒ‰ãƒ©ã‚¤ãƒ–ã«ä¿ç®¡å¯èƒ½ãªãƒ•ã‚¡ã‚¤ãƒ« - Google ãƒ‰ãƒ©ã‚¤ãƒ– ãƒ˜ãƒ«ãƒ—
Google ãƒ‰ãƒ©ã‚¤ãƒ–ã«ä¿ç®¡ã§ãã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºã®ä¸Šé™ã¯æ¬¡ã®ã¨ãŠã‚Šã§ã™ã€‚ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ â€‹åŠè§’ 102 ä¸‡æ–‡å—ã¾ã§ã€‚ ãƒ†ã‚ã‚¹ãƒˆ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ Google ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆå½¢å¼ã«å¤‰æ›ã—ãŸå ´åˆã¯ 50 MB ã¾ã§ã€‚ ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆ â€‹Google ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§ä½œæˆã—ãŸã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã¾ãŸã¯ Google ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆå½¢å¼ã«å¤‰æ›ã—ãŸã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®å ´åˆã¯ 1,000 ä¸‡ã‚»ãƒ«ã¾ãŸã¯ 1 ä¸‡ 8,278 åˆ—ï¼ˆåˆ— ZZZï¼‰ã¾ã§ã€‚ Microsoft Excel ã‹ã‚‰ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ãŸã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®å ´åˆã¯ 1,000 ä¸‡ã‚»ãƒ«ã¾ãŸã¯ 1 ä¸‡ 8,278 åˆ—ã¾ã§ã€‚ä¸Šé™ã¯ Excel ã¨ CSV ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§åŒä¸€ã§ã™ã€‚ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ Excel ã‹ã‚‰ Google ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã«å¤‰æ›ã™ã‚‹ã¨ã€5 ä¸‡æ–‡å—ã‚’è¶…ãˆã‚‹æ–‡å—ãŒå…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ã‚»ãƒ«ã¯ã™ã¹ã¦ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‹ã‚‰å‰Šé™¤ã•ã‚Œã¾ã™ã€‚ ã‚³ãƒã‚¯ãƒ†ãƒƒãƒ‰
aki77 2013/10/01
google spreadsheets
ãƒªãƒ³ã‚¯
VLOOKUPé–¢æ•°ï¼ˆGoogleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆï¼‰ - ã‚¸ãƒ£ãƒ ã‚¹ã‚¿
åˆ¥ã®ãƒ‡ãƒ¼ã‚¿ã‹ã‚‰ä¸€è‡´ã™ã‚‹ã‚‚ã®ã‚’æŒã£ã¦ãã‚‹ã€‚ VLOOKUPï¼ˆæ¤œç´¢æ¡ä»¶, é…åˆ—, æŒ‡æ•°, ä¸¦ã³æ›¿ãˆé †åºï¼‰ â€»è©³ç´°ã¯ãƒšãƒ¼ã‚¸ä¸‹éƒ¨å‚ç…§ã€‚ =IF(C31="","",VLOOKUP(C31,è²»ç›®ãƒ»é©ç”¨è¡¨!$A$7:$B$13,2,FALSE)) ãŸã¨ãˆã°ã€ä¸Šã®å¼ãŒD31ã«å…¥ã£ã¦ã„ã‚‹ã¨ã—ã‚ˆã†ã€‚C31ã¯å·¦éš£ã®ã‚»ãƒ«ã¨ã„ã†ã“ã¨ã«ãªã‚‹ã€‚ ãã“ã«å…¥ã£ã¦ã„ã‚‹å€¤ãŒã€ç©ºç™½ãªã‚‰ã°ç©ºç™½ã€‚ã¤ã¾ã‚Šä½•ã‚‚ã—ãªã„ã€‚ ã‚‚ã—ä½•ã‹å…¥ã£ã¦ã„ã‚‹ã®ãªã‚‰ã°ã€VLOOKUPé–¢æ•°ãŒåƒãã€‚ã“ã“ã¾ã§ãŒIFé–¢æ•°ã®åƒãã€‚ä»¥ä¸‹ãŒVLOOKUPé–¢æ•°ã€‚ æ¤œç´¢æ¡ä»¶ã¯C31ã«å…¥ã£ã¦ã„ã‚‹å€¤ã€‚ä½•ã‹ã®æ•°å—ã¨ã—ã¦ãŠã“ã†ã€‚ ãã®æ•°å—ã‚’ã€Œè²»ç›®ãƒ»é©ç”¨è¡¨ã¨ã„ã†åˆ¥ã®ã‚·ãƒ¼ãƒˆã®A7ã‹ã‚‰B13ã®ç¯„å›²ã€ã§æ¤œç´¢ã‚’ã‹ã‘ã‚‹ã€‚ ãŸã¨ãˆã°ã€C31ã«ã€Œï¼“ã€ã¨ã„ã†æ•°å—ãŒå…¥åŠ›ã•ã‚ŒãŸã‚‰ã€ã€Œè²»ç›®ãƒ»é©å¿œè¡¨ã€ã¨ã„ã†ã‚·ãƒ¼ãƒˆã®A7ã‹ã‚‰B13ã®ä¸ã§ãã‚ŒãŒå…¥ã£ã¦ã„ã‚‹è¡Œã‚’æŽ¢ã™ã€‚ ã‚‚ã—ç™ºè¦‹ã—ãŸã‚‰ãã®è¡Œã®äºŒã¤ç›®ã®è¦ç´ ã‚’æ¤œç´¢çµæžœã¨
aki77 2013/09/25
google spreadsheets
ãƒªãƒ³ã‚¯
ã‚¯ã‚¨ãƒªè¨€èªžãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼ˆãƒãƒ¼ã‚¸ãƒ§ãƒ³ 0.7ï¼‰ Â |Â Charts Â |Â Google for Developers
ãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯ã‚’é€ä¿¡ ã‚¯ã‚¨ãƒªè¨€èªžãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼ˆãƒãƒ¼ã‚¸ãƒ§ãƒ³ 0.7ï¼‰ ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã§ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’æ•´ç† å¿…è¦ã«å¿œã˜ã¦ã€ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã®ä¿å˜ã¨åˆ†é¡žã‚’è¡Œã„ã¾ã™ã€‚ GoogleVisualization API ã®ã‚¯ã‚¨ãƒªè¨€èªžã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã«å¯¾ã™ã‚‹ã‚¯ã‚¨ãƒªã§ã•ã¾ã–ã¾ãªãƒ‡ãƒ¼ã‚¿æ“ä½œã‚’è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ ç›®æ¬¡ ã¯ã˜ã‚ã« é€šå¸¸ã€ãƒ“ã‚¸ãƒ¥ã‚¢ãƒªã‚¼ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¯ç‰¹å®šã®å½¢å¼ã®ãƒ‡ãƒ¼ã‚¿ãŒå¿…è¦ã§ã™ã€‚ãŸã¨ãˆã°ã€å††ã‚°ãƒ©ãƒ•ã§ã¯ãƒ‡ãƒ¼ã‚¿ãŒãƒ†ã‚ã‚¹ãƒˆãƒ©ãƒ™ãƒ«ã¨æ•°å€¤ã® 2 ã¤ã®åˆ—ã§ã‚ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹å†…ã®ãƒ‡ãƒ¼ã‚¿ã¯ã€ã“ã®æ§‹é€ ã¨å®Œå…¨ã«ã¯ä¸€è‡´ã—ãªã„å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ãŸã¨ãˆã°ã€ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã« 3 ã¤ä»¥ä¸Šã®åˆ—ãŒã‚ã‚‹å ´åˆã‚„ã€åˆ—ã®é †åºãŒå††ã‚°ãƒ©ãƒ•ã§æƒ³å®šã•ã‚Œã¦ã„ã‚‹é †åºã¨ç•°ãªã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ã‚¯ã‚¨ãƒªè¨€èªžã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿æ“ä½œã¨ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã«é€ä¿¡ã—ã€è¿”ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿æ§‹é€ ã¨ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ãŒæƒ³å®šã•ã‚Œã‚‹æ§‹é€ ã¨ä¸€è‡´ã™ã‚‹ã‚ˆã†ã«ã§ãã¾
aki77 2013/09/06
Query

google spreadsheets

reference
ãƒªãƒ³ã‚¯
Sheetsee.js
Sheetsee.js is a client-side library for connecting Google Spreadsheets to a website and visualizing the information in tables and maps. Spreadsheets!? Google Spreadsheets can be used as simple and collaborative databases, they make getting a data driven site going much easier than traditional databases. Read more about using spreadsheets for databases. Modules Each of Sheetsee's functions are div
aki77 2013/09/03
ã€ŽGoogle Spreadsheetã‚’DBã¿ãŸã„ã«åˆ©ç”¨ã§ãã‚‹JavaScriptãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€

google spreadsheets

javascript

library
ãƒªãƒ³ã‚¯
Using Google Spreadsheets Like a Database â€“ The QUERY Formula
OUseful.Info, the blogâ€¦ Trying to find useful things to do with emerging techno logies in open education and data journalism. Snarky and sweary to anyone who em ails to offer me content for the site. In this yearâ€™s student satisfaction tables, which universities have a good teaching score but low employment prospects? How would you find out? In this post, youâ€™ll find outâ€¦ Whether or not it was one o
aki77 2013/06/19
google spreadsheets
ãƒªãƒ³ã‚¯
æš®ã‚‰ã—ã®æƒ…å ±ã‚µã‚¤ãƒˆnanapiã¯ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸ | nanapi [ãƒŠãƒŠãƒ”]
2020å¹´8æœˆ31æ—¥(æœˆ)ã‚’ã‚‚ã¡ã¾ã—ã¦ã€nanapiã«é–¢ã‚ã‚‹ã™ã¹ã¦ã®ã‚µãƒ¼ãƒ“ã‚¹ã¯çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ nanapiã¯ã€2009å¹´ã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‚ˆã‚Šã€Œã¿ã‚“ãªã§ä½œã‚‹æš®ã‚‰ã—ã®ãƒ¬ã‚·ãƒ”ã€ã¨ã„ã†è€ƒãˆã®ã‚‚ã¨ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®çš†ã•ã¾ã«ç”Ÿæ´»ã«é–¢ã™ã‚‹æ§˜ã€…ãªã€Œãƒã‚¦ãƒ„ãƒ¼ã€ã‚’æŠ•ç¨¿ã—ã¦ã„ãŸã ãæŠ•ç¨¿åž‹ãƒã‚¦ãƒ„ãƒ¼ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦é‹å–¶ã—ã¦ã¾ã„ã‚Šã¾ã—ãŸã€‚ ç´„11å¹´é–“ã«ã‚ãŸã£ã¦çš†ã•ã¾ã‹ã‚‰ã”æ”¯æ´ã‚’ã„ãŸã ãã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶™ç¶šã§ããŸã“ã¨ã€nanapiç·¨é›†éƒ¨ä¸€åŒã€å¿ƒã‚ˆã‚Šå¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ æŽ²è¼‰ã•ã‚Œã¦ã„ãŸã‚³ãƒ³ãƒ†ãƒ³ãƒ„ãªã©ã®nanapiã«ã¤ã„ã¦ã®ãŠå•ã„åˆã‚ã›ã¯ã€nanapi@supership.jp ã¾ã§ãŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ é•·ãã«æ¸¡ã‚Šnanapiã‚’å¿œæ´ã—ã¦ãã ã•ã‚Šã€æœ¬å½“ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
aki77 2013/05/20
google spreadsheets
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
aki77 2012/12/06
google spreadsheets

google apps script
ãƒªãƒ³ã‚¯
GitHub - jlord/sheetsee.js: :eyes: Visualize Data from a Google Spreadsheet
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
aki77 2012/10/06
ã€ŽGoogleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚°ãƒ©ãƒ•ãªã©ã«ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ«åŒ–ã—ã¦ã‚µã‚¤ãƒˆã«åŸ‹ã‚è¾¼ã‚€ã“ã¨ãŒã§ãã‚‹JavaScriptãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€

google spreadsheets

javascript

library

graph
ãƒªãƒ³ã‚¯
Hive (SQL-style) Query Language | Treasure Data
{"serverDuration": 35, "requestCorrelationId": "b45a8231fbaabbfb"}
aki77 2012/09/26
treasuredata

document

workspace
ãƒªãƒ³ã‚¯
Google ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®é–¢æ•°ãƒªã‚¹ãƒˆ - Google ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ ãƒ˜ãƒ«ãƒ—
Google ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§ã¯ã€ã»ã¨ã‚“ã©ã®ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ— ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆ ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ä¸€èˆ¬çš„ã«ä½¿ç”¨ã•ã‚Œã‚‹ã‚»ãƒ«ã®æ•°å¼ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã™ã€‚ã“ã‚Œã‚‰ã®é–¢æ•°ã‚’ä½¿ã£ã¦ã€ãƒ‡ãƒ¼ã‚¿ã®æ“ä½œã‚„ã€æ–‡å—åˆ—ã€æ•°å€¤ã®è¨ˆç®—ã‚’è¡Œã†ãŸã‚ã®æ•°å¼ã‚’ä½œæˆã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ä¸‹ã®ãƒªã‚¹ãƒˆã¯ã€ä½¿ç”¨ã§ãã‚‹ã™ã¹ã¦ã®é–¢æ•°ã‚’ã‚«ãƒ†ã‚´ãƒªåˆ¥ã«ç¤ºã—ã¦ã„ã¾ã™ã€‚é–¢æ•°ã‚’ä½¿ç”¨ã™ã‚‹éš›ã¯ã€ã‚»ãƒ«å‚ç…§ã‚„åˆ—å‚ç…§ã§ãªã„ã‚¢ãƒ«ãƒ•ã‚¡ãƒ™ãƒƒãƒˆæ–‡å—ã§æ§‹æˆã•ã‚Œã‚‹é–¢æ•°è¦ç´ ã¯ã™ã¹ã¦ã€äºŒé‡å¼•ç”¨ç¬¦ã§å›²ã‚€ã‚ˆã†ã«ã—ã¦ãã ã•ã„ã€‚ Google ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§ã¯ã€é–¢æ•°ã®è¨€èªžã‚’è‹±èªžä»¥å¤–ã® 21 ã® è¨€èªžã«å¤‰æ›´ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚
aki77 2012/03/28
google spreadsheets
ãƒªãƒ³ã‚¯
Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ã‚»ãƒ«å†…ã«ã‚°ãƒ©ãƒ•ã‚’æã‘ã‚‹é–¢æ•°ã€Œã‚¹ãƒ‘ãƒ¼ã‚¯ãƒ©ã‚¤ãƒ³ã€ãŒä¾¿åˆ©ã§ãŠã‚‚ã—ã‚ã„
ä¼šç¤¾ã®ä¼šè°ã‚„MTGã§ã‚‚Officeã®ã‚¨ã‚¯ã‚»ãƒ«ã§ã¯ãªãã€Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’ä½¿ã£ã¦å®Ÿç¸¾å ±å‘Šãªã©ã‚’ãŠã“ãªã†æ©Ÿä¼šãŒå¢—ãˆã¦ã„ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ãã“ã§å°‘ã—ãƒãƒƒã‚¯ã¨ãªã‚‹ã®ãŒã€ã‚°ãƒ©ãƒ•ä½œæˆã®é¢å€’ã•ã€‚å¤šæ©Ÿèƒ½ã§ã‚°ãƒ©ãƒ•ã‚£ã‚«ãƒ«ã«æå†™ã§ãã‚‹ã®ã¯è‰¯ã„ã®ã§ã™ãŒã€æ„å¤–ã¨è¨å®šãŒé¢å€’ã ã£ãŸã‚Šã—ã¾ã™ã‚ˆãã€‚ ãã“ã§ä»Šå›žã¯ã€é€šå¸¸ã®ã‚°ãƒ©ãƒ•ã‚ˆã‚Šã‚‚æ‰‹è»½ã«ã‚°ãƒ©ãƒ•ã‚’æå†™ã§ãã‚‹æ–°ã—ã„Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®Sparklineé–¢æ•°ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ çµ„ç¹”ã®ãƒžã‚¤ãƒ³ãƒ‰ãƒžãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã‚’ãƒžã‚¤ãƒ³ãƒ‰ãƒžã‚¤ã‚¹ã‚¿ãƒ¼ã«ã™ã¹ãç†ç”± ä¼¸ã³ã¦ã‚‹ç”£æ¥ã€ä¼šç¤¾ã€äº‹æ¥ã‚’ç´¹ä»‹ã—ã¾ãã‚‹Strainerã®ãƒ‹ãƒ¥ãƒ¼ã‚¹ãƒ¬ã‚¿ãƒ¼ã«ç™»éŒ²!! ã‚¨ã‚¯ã‚»ãƒ«ã®ã‚»ãƒ«ã¸æ‰‹è»½ã«ã‚°ãƒ©ãƒ•ã‚’æã‘ã‚‹ã€Œã‚¹ãƒ‘ãƒ¼ã‚¯ãƒ©ã‚¤ãƒ³ã€é–¢æ•° ã‚¹ãƒ‘ãƒ¼ã‚¯ãƒ©ã‚¤ãƒ³ï¼ˆSparklineï¼‰ã¯ã€Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆï¼ˆGoogleã®ã‚¨ã‚¯ã‚»ãƒ«ï¼‰ã®ã‚»ãƒ«å†…ã«é–¢æ•°ã‚’å…¥ã‚Œã‚‹ã ã‘ã§æŠ˜ã‚Œç·šã‚°ãƒ©ãƒ•ã¨æ£’ã‚°ãƒ©ãƒ•ã‚’æå†™ã§ãã‚‹æ–°ã—ã„é–¢æ•°ã€‚ ã‚°ãƒ©ãƒ•ã®
aki77 2012/02/19
google spreadsheets
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸