{"id":257,"date":"2005-07-01T13:41:33","date_gmt":"2005-07-01T20:41:33","guid":{"rendered":"http:\/\/www.stardel.com\/eg\/?p=257"},"modified":"2005-07-01T13:41:33","modified_gmt":"2005-07-01T20:41:33","slug":"260","status":"publish","type":"post","link":"https:\/\/stardel.com\/eg\/2005\/07\/260\/","title":{"rendered":"Playing with tables again"},"content":{"rendered":"

This time I have set up the template in a spreadsheet and set up the row data elements in a row so it goes .tr..td..X..\/td..td.X..\/td..td..X..\/td………….\/tr. and copied in the original table to the same spreadsheet. I then link each data element (.X.) of the html data back to the original table data element and then C&P the html parts from the spreadsheet into wordpress.<\/p>\n

It seems to work. And next week I can just copy the original table into the same R\/C and that will produce next week’s table. All I need to do is C&P. (The Total column is for the Season, the +\/- column is point delta since Monday)<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\t06.30.05 \t<\/caption>\n
\tTeamName\t<\/th>\n\tHR \t<\/th>\n\tR \t<\/th>\n\tRBI \t<\/th>\n\tAVG \t<\/th>\n\tSB \t<\/th>\n\tW \t<\/th>\n\tSV \t<\/th>\n\tSO \t<\/th>\n\tERA \t<\/th>\n\tWHIP \t<\/th>\n\tTOTAL \t<\/th>\n\t+\/- \t<\/th>\n<\/tr>\n<\/thead>\n
\tBudchuggers\t<\/td>\n\t7.5\t<\/td>\n\t10\t<\/td>\n\t10\t<\/td>\n\t9\t<\/td>\n\t2\t<\/td>\n\t7.5\t<\/td>\n\t7\t<\/td>\n\t8\t<\/td>\n\t8\t<\/td>\n\t9\t<\/td>\n\t78\t<\/td>\n\t2\t<\/td>\n<\/tr>\n
\tRocky Coloradans\t<\/td>\n\t7.5\t<\/td>\n\t9\t<\/td>\n\t8\t<\/td>\n\t8\t<\/td>\n\t9\t<\/td>\n\t9\t<\/td>\n\t3\t<\/td>\n\t7\t<\/td>\n\t9\t<\/td>\n\t5\t<\/td>\n\t74.5\t<\/td>\n\t-3.5\t<\/td>\n<\/tr>\n
\tDingleberries\t<\/td>\n\t10\t<\/td>\n\t5.5\t<\/td>\n\t6.5\t<\/td>\n\t1\t<\/td>\n\t8\t<\/td>\n\t1\t<\/td>\n\t10\t<\/td>\n\t1\t<\/td>\n\t10\t<\/td>\n\t10\t<\/td>\n\t63\t<\/td>\n\t0\t<\/td>\n<\/tr>\n
\tPork Pirates\t<\/td>\n\t6\t<\/td>\n\t7\t<\/td>\n\t6.5\t<\/td>\n\t5\t<\/td>\n\t1\t<\/td>\n\t10\t<\/td>\n\t4\t<\/td>\n\t10\t<\/td>\n\t7\t<\/td>\n\t6\t<\/td>\n\t62.5\t<\/td>\n\t2.5\t<\/td>\n<\/tr>\n
\tIndians\t<\/td>\n\t4\t<\/td>\n\t5.5\t<\/td>\n\t4\t<\/td>\n\t3\t<\/td>\n\t7\t<\/td>\n\t5\t<\/td>\n\t6\t<\/td>\n\t6\t<\/td>\n\t6\t<\/td>\n\t7\t<\/td>\n\t53.5\t<\/td>\n\t2\t<\/td>\n<\/tr>\n
\tGANYFs\t<\/td>\n\t1\t<\/td>\n\t2\t<\/td>\n\t5\t<\/td>\n\t10\t<\/td>\n\t3\t<\/td>\n\t7.5\t<\/td>\n\t9\t<\/td>\n\t5\t<\/td>\n\t5\t<\/td>\n\t4\t<\/td>\n\t51.5\t<\/td>\n\t-0.5\t<\/td>\n<\/tr>\n
\tShamu Whales\t<\/td>\n\t9\t<\/td>\n\t8\t<\/td>\n\t9\t<\/td>\n\t7\t<\/td>\n\t4\t<\/td>\n\t6\t<\/td>\n\t1\t<\/td>\n\t2\t<\/td>\n\t1\t<\/td>\n\t1\t<\/td>\n\t48\t<\/td>\n\t0\t<\/td>\n<\/tr>\n
\tBoston Ballbusters\t<\/td>\n\t5\t<\/td>\n\t3\t<\/td>\n\t2\t<\/td>\n\t2\t<\/td>\n\t6\t<\/td>\n\t3.5\t<\/td>\n\t2\t<\/td>\n\t9\t<\/td>\n\t4\t<\/td>\n\t8\t<\/td>\n\t44.5\t<\/td>\n\t0.5\t<\/td>\n<\/tr>\n
\tHomestead Grays\t<\/td>\n\t2\t<\/td>\n\t4\t<\/td>\n\t3\t<\/td>\n\t6\t<\/td>\n\t5\t<\/td>\n\t2\t<\/td>\n\t8\t<\/td>\n\t4\t<\/td>\n\t2\t<\/td>\n\t3\t<\/td>\n\t39\t<\/td>\n\t4\t<\/td>\n<\/tr>\n
\tRangers\t<\/td>\n\t3\t<\/td>\n\t1\t<\/td>\n\t1\t<\/td>\n\t4\t<\/td>\n\t10\t<\/td>\n\t3.5\t<\/td>\n\t5\t<\/td>\n\t3\t<\/td>\n\t3\t<\/td>\n\t2\t<\/td>\n\t35.5\t<\/td>\n\t-7\t<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

This time I have set up the template in a spreadsheet and set up the row data elements in a row so it goes .tr..td..X..\/td..td.X..\/td..td..X..\/td………….\/tr. and copied in the original table to the same spreadsheet. I then link each data element (.X.) of the html data back to the original table data element and then … Continue reading Playing with tables again<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[6],"tags":[],"class_list":["post-257","post","type-post","status-publish","format-standard","hentry","category-geek-stuff"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/s4NpF-260","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/stardel.com\/eg\/wp-json\/wp\/v2\/posts\/257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stardel.com\/eg\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stardel.com\/eg\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stardel.com\/eg\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/stardel.com\/eg\/wp-json\/wp\/v2\/comments?post=257"}],"version-history":[{"count":0,"href":"https:\/\/stardel.com\/eg\/wp-json\/wp\/v2\/posts\/257\/revisions"}],"wp:attachment":[{"href":"https:\/\/stardel.com\/eg\/wp-json\/wp\/v2\/media?parent=257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stardel.com\/eg\/wp-json\/wp\/v2\/categories?post=257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stardel.com\/eg\/wp-json\/wp\/v2\/tags?post=257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}