Follow-up: Picture List in Excel

This exercise was originally posted at: http://maritimeorca0.blogspot.com/2013/10/picture-list-in-excel.html

The Task

Create a spreadsheet that keeps track of information relating to pictures that you are keeping on your computer. For now, you can keep it simple.

My Solution

I already have a spreadsheet with a list of pictures that I post to Flickr. I modified the spreadsheet and removed some information. For now, I am including the File Name (I’m using this as a unique ID), File Extension (in case I want to reference the actual file), and the number of the picture at Flickr. This list is incomplete (I revised how I was handling my personal list, and I haven’t converted older uploads to the new format).

I have turned the list into a table (tblPicList).

My spreadsheet can be found at: https://skydrive.live.com/redir?resid=2E6EFB80915ED5BD!5817&authkey=!AG7Z1jfMopPyIOE

 

Notes

This spreadsheet will likely be revisited for future challenges.

 

Feel Free to Comment

Now that this exercise has concluded, feel free to share any thoughts that you had regarding results, your approach, and any other ideas that popped in your head regarding this exercise.

I do not provide space to those who visit my blog. If you would like to share any files, you are going to have to find your own online storage. At that point, you can provide links with your comments. I would like to point out that macros can create security risks. If possible, save all documents as a standard workbook (not macro-enabled) unless macros are vital to your solution. If you are going to download any solutions, make sure that you are not loading macros by default. If a spreadsheet includes macros, check the code before running them.

 

About Sharing

My specific list is mine, and there is limited reason to share the data. You can share, modify, and apply your own list to this spreadsheet without providing credit. Unless otherwise specified, similar guidelines should apply to solutions from other contributors.

 

Upon completion of this exercise, please fill out the following form:
https://docs.google.com/spreadsheet/viewform?formkey=dGlnTld6QmRpQ0puU0hLUW5RYjlzd2c6MA
Responses to the above form are collected and stored in a spreadsheet that can be viewed at:
https://docs.google.com/spreadsheet/pub?key=0Agcdh--NHOS0dGlnTld6QmRpQ0puU0hLUW5RYjlzd2c&output=html