As we all know, hosting a meme can sometimes involve quite a bit of work by the host in putting together summaries. Sam wrote about this previously in "Hosting a meme - be careful what you wish for!" For the Eat Local Challenge month, I came up with a way to track what was going on via an excel spreadsheet. It's pretty geeky, and I wouldn't recommend it if you are not an excel junkie. But it is possible to enter the information for your participants and then have excel build the code for you.
By making a formula in excel using an ampersand, you can make excel combine text. In the example below, the formula =A1&" "&B1 is used to create "tom jones".
this formula can be copied into every cell of the C column, and the result will change in each row.
Things get a little more complicated when you try to do entire sentences, but it is possible. In the participant list that I created, you will notice that there is a pattern to every single blog listed. It's something like NAME from BLOGNAME (LOCATION). < reference =" '"> BLURB < / a >
The images below give you a clue as to how I built this in Excel.
Now, most people don't do their posts quite as uniform as I do. Different people like to have the post links within paragraphs and stories. You could still use Excel to do the main work, you would just have to be a little more creative. In the end, I was able to take all of the data from the "code" column and paste that straight into a blog post and it worked fairly seamlessly. I also cut and pasted all the urls from the "trackback ping" column to ping everyone I needed to.
For me personally, building the data in Excel and tracking it this way was much easier than trying to proof all of my code in html and typepad.
Other benefits to doing the meme post in this manner include:
* Easy ability to sort the blogs however you want them sorted
* You can see where there are blanks that need to be filled in and deal with that.
* You know that if the code is correct for one entry, it will be correct for all entries.
I have posted the actual excel sheet here if anyone would like to play around with it. Document password = "geekcode". If you'd like to try this method and need help, feel free to email me at fogcityblogATyahooDOTcom.
This is probably one of those things that only works for A-R freaks like me, but thought I'd put it out there in case it can help anyone else in the future.
Thursday, August 18, 2005
Subscribe to:
Post Comments (Atom)
14 comments:
from an AR freak to another...
that's awesome! lol! i am an excel monster (have to use it quite extensively for my day job, lol!) and use it for everything from recipes to calendars.
:)
ha ha ha - this is a very nice idea except i am, like totally anti-Microsoft, don't use their software if i can help it.
I don't think i even have excel.
I have another organisational idea for hosting memes which i am going to test out when i next a host a meme. It's gonna be very soon, but i need to test it before I announce it.
too bad i didn't think of it time for Rachael Ray, which i think might turn out crazy.
(I have had some hints so far that they may be a contingent of non-food bloggers entering too!)
we'll see...
Awesome tips.
I've managed to avoid doing any work in Excel, even though I've done years of corporate work. People send me memos and notes done in Excel, and I wonder about those people. But hey, I do the same thing to people with html.
I need to organize my food blog list like this. Not only would it allow for searching and categorizing, but it would make it easier to export to other systems for others who want to apply other tools to it.
Jen:
I think this is a great tip and tool! Kudos to you for sharing.
And for those of you who prefer not to use excel, this would work in any spreadsheet on the market.
~ B
For those that just want to track the URLs and take notes, check out backpack at www.backpackit.com - you get a free account with five pages and I just redo pages when a project is over - it is awesome for taking nots off web research.
I do Paper chef by tracking all the emails and comments together and then keeping a list of the URLs and then going to them one at a time and wrriting them up as I go. I can do one every three or four minutes that way.
Jen - wow. That is being organized! I had no idea you could use Excel that way. Thanks for posting the tip.
I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work... hosting en chile
Thanks for sharing such a nice Blog.I like it.
norton product key
mcafee activate product key
comcast customer support number
AVG contact number
webroot customer service number
kaspersky customer service
Outlook Customer service number
microsoft edge support number
webroot activate
www trendmicro com bestbuypc
Hi there! Nice material, do keep me posted when you post something like this again! I will visit this blog leaps and bounds for more quality posts like it. Thanks... Unlimited websites
Really awesome information.Your blogs are really awesome and full of good information. I would like to say thank you to share such good information. If you are encountering HP customer support number with the app, consider connecting the printer with some other devices.
Awesome Blog. I enjoyed reading your blog. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new blog. Keep up the good work. Know about steam link roku.
This is my first visit to your web journal! We are a group of volunteers and new activities in the same specialty. Website gave us helpful data to work. Best Offshore Hosting
Poker Rules. Play Poker Tournaments In India
ordinarily feature a forced bet, such as the Big Blind and Small Blind in Hold'em and Omaha or the Antes and Bring-In in Stud.
Thank your for this awesome information. Check this article about - 9 highly effective churn rate prevention strategies.
churn rate prevention strategies
mobile game app marketing
bonus in gaming
Post a Comment