Giving Credit and Posting Links Made Easier

*Kathleen* · 01-08-2008, 09:58 PM

Do you links look like this:

http://store.digitalscrapbookplace.c...oducts_id=6913

... but you want them to look like this:

Swirl Box Embellishment Stamp Set by Suzanne C. Walker

I can be really goofy and very particular about things sometimes! It took me a while to figure out how people were creating neat and clean links in posts, and once I did, it took me a bit longer to figure out a way I was happy with to keep track of information and easily have the information at the ready.

I use Excel way too much in my day job, so it seemed like a natural fit to create a spreadsheet to do the work of creating the link for me. By entering three bits of information (kit name, designer, and store number) when I purchase a kit, Excel then creates the "code" for me to copy and paste into a post and create a "pretty" link. I can sort in Excel by kit name or designer, and if I am really curious check out the pivot table to see which designers top my list.

The Excel sheet has more instruction information included.

If I have done this correctly, you should be able to get the ZIP file in this post and unzip the Excel file.

I hope you find this useful, feel free to PM me if you have questions, or post in this thread.

~ Kathleen

January 24, 2011 Update

Version 4 is now available! Read about it in post 252 of this thread.

With the recent store upgrades, I updated some formulas so everything should be working well again!.

I also updated Post 93 in this thread which has some good step-by-step instructions on copy/pasting into the spreadsheet, as well as transferring from one spreadsheet (old version) to another (new version).

Post any questions, and I will do what I can to help. Attached Files

DSP Links to Share v4.zip (280.9 KB, 0 views)

**shazzt** · 01-09-2008, 03:03 AM

I usually just manually type the code in but that looks like a cool idea!
PS - the tutorial for sharing links is here if anyone is interested

.

*felynn* · 01-09-2008, 04:05 AM

The excel file looks really cool. I'll give it a try.

I usually just make a "pretty link" of the kit and paste it into the terms text file that comes with the kit.

*Scrapping4Him* · 01-18-2008, 02:35 PM

Awesome spreadsheet Kathleen! I've been doing something very similar but those lovely formulas make it way easier and faster to do the data entry. Thanks for sharing this!!!

*scamptx* · 01-18-2008, 06:53 PM

Oh thank you, thank you! I had made a spreadsheet, but I'm not nearly as skilled in Excel...love this!

*Jill W* · 01-18-2008, 07:26 PM

Oh what a swell formula! I don't know why I hadn't thought about doing it that - I keep track of all of my kits in Excel so this would work great! (However, after a lot of practice, using the html code is simple now ... but I'm going to try your formula...).
I can't imagine work OR home computing without Excel!!

Thanks for sharing!

lmilgram · 01-18-2008, 08:29 PM

This is cool! I'm a big fan of Excel too, but I was really excited to learn how to store the credits right in the Photoshop file....no more random Text Files for me! Thank you!

*Kathleen* · 01-18-2008, 10:18 PM

Glad to be able to share a few little tidbits of information. I have learned so much at DSP, so it is fun to give a little back!

~Kathleen

*Muma* · 01-19-2008, 12:49 AM

Just downloaded your excel file and I'm impressed LOL .... I have played with excel a few times but not really got to grips with it. I think the formulas put me off. However I took a look at this and I'm certainly gonna keep this up to date ...... thank you very much for your hard work.

Emma · 01-19-2008, 09:14 AM

hey, that's pretty cool! I always feel so nerdy when I make Excel stuff, and I'm not even that good at it, but I love how all the numbers come out so neatly at the end when my formulas work!

For those wondering how to make neat links like that, first go to the URL you want to use and copy it from the Address Bar. Then use the "Go Advanced" reply in the forums and type the WORDS you want, highlight them and click the Globe/Link icon at the top and paste in the URL.

If you then hit PREVIEW, it'll generate the code for you, which you can then copy/paste into the gallery since it has no Advanced area (two different pieces of software, gallery and forum, though they both use PHP code, the gallery makes you put it in manually: bummer!)

hope that help

carlalee · 01-19-2008, 10:05 AM

Hey Kathleen - you gave me a *THUNK* V8 moment! So like I have an Excel spreadsheet that I've been keeping since before my ACDSee days with all of this same info with one BIG exception - DUH no formulas! Sometimes it takes quite a while to complete my postings because of all of the copying and pasting to get things right. How EASY is this. YOU TOTALLY ROCK CHICK!!!! Say a little tid bit for you, did you know you can generate a text file listing of ALL of your digiscrapping supplies using ACDSee? Then you can open the text file with Excel, then using your spreadsheet get maybe 90% of the work done in just a few minutes. TYVM -c-

*Fade2Pink* · 01-20-2008, 11:59 AM

Very cool, thank you!!

**Meryl** · 01-20-2008, 01:27 PM

Kathleen this is great

I keep all my links in a spreadsheet but am not clever enough to make it create a pastable pretty link

thanks fantastic work

Caro · 01-20-2008, 05:11 PM

wow that is awesome work

**Erica** · 01-20-2008, 05:55 PM

Great idea Kathleen and I too use excel a lot (even used to teach it) but I keep all my kit info in a wordpad doc and just do what Emma suggests above.