OOC: Easy thread tracking
Feb. 1st, 2016 12:16 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
While I am in the process of building a fancier thread tracker, here is my basic simpler excel html generator:
Step one:
Open Exel and set up a sheet like this:

In Colum A put the urls to the posts/threads, in B put what you want the text to be to show that url. If you like to seperate your links into groups with titles like I do, put the title of the group in C and leave A and B empty for that row
Step 2:
Add this formula to E2 and then copy it down for all the rows you are using
This is a cheap work around to get the correct formatting
Step 3:
Add this formula in G2 and then copy it down for all the rows you are using
Your excel should now look something like this:

Step 4:
Mark and copy the rows you want to use from Colum G and then paste it into dreamwidth in html format
Step one:
Open Exel and set up a sheet like this:

In Colum A put the urls to the posts/threads, in B put what you want the text to be to show that url. If you like to seperate your links into groups with titles like I do, put the title of the group in C and leave A and B empty for that row
Step 2:
Add this formula to E2 and then copy it down for all the rows you are using
This is a cheap work around to get the correct formatting
Step 3:
Add this formula in G2 and then copy it down for all the rows you are using
Your excel should now look something like this:

Step 4:
Mark and copy the rows you want to use from Colum G and then paste it into dreamwidth in html format