View allAll Photos Tagged spreadsheets
slides B7-R160
see xls spreadsheet Box B8-R190 slides
GEPE glass mount to clean of Creamy Flats trip ACT Forests
just searching for images and data for GMcS
In a typical phylogenetic analysis workflow, common practice has been to manage data inside spreadsheets and in collaborative teams, to share them via email, as represented by Alternative a).While easy and effective for small data sets, spreadsheets can get out of sync and provenance is not well maintained. TOLKIN provides an Alternative b) to provide collaboration through a web portal, bulk data import and export of common formats, metadata and versioning support.
Hemerocallis 'Cherry Cheeks' 2014, Rose Pink Daylily, hem-ur -oh-KAL-iss, 28 " M-L D Perennial (Peck, 1968),Z3, 6" Rose pink blend, R2
I use google spreadsheets to track all of my plants. I wanted to be able to easily link (click) to photos of each plant on my Flickr account. Here's how I did it.
In my sheet, I use column B for the name of the plant.
In another column, I convert the text in Column B into web friendly text. Specifically, I convert all the spaces to %20, which is the web equivalent to space.
I use column T for this conversion. T13 looks like this: =SUBSTITUTE(B13," ","%20"). Of course, T14 looks like this: =SUBSTITUTE(B14," ","%20").
In that same row, I have an cell entry that looks like this:
=HYPERLINK("https://www.flickr.com/search/?user_id=50697352%40N00&sort=date-posted-desc&text="&T13,"flickr")
this is the clickable cell. If you have a flickr account, you can figure out this URL by doing a search of your photos & recording the URL.
So, when I click on this link in my spreadsheet, I search my Photos on Flickr for this plant entry. This is especially interesting if you have been taking photos of a given plant every year. For example, I have plants that I have taken photos of for several years, clicking on my sheet link, opens up a page with all of the photos (this is cool!).
When I add new plants to my sheet, it automatically fills in the search data. Of course, new plant items will usually not produce any search results for my Flickr photos:) However, I am starting to take photos of purchased potted plants, before I plant them. And, yes, I have been taking photos of tubers and roots prior to planting.
With modification, you can use any web photo site to do this. Picasa or Smugmug, for example. Also, I use this method to link to a google image search of my plant entry. Many times after I add a plant to my sheet, I manually copy the name and do a google search in another browser tab. This makes it much easier, just a click away:)
For my sheet, the google image link looks like this:
=HYPERLINK("https://www.google.com/search?hl=en&site=imghp&tbm=isch&source=hp&biw=1687&bih=1083&q="&T13,"g")
Gear available for purchase is listed here: docs.google.com/spreadsheets/d/1zrBzcCe2moh0CvZkhUuWSKXi2...
Well "Open Office"actually, but the daily tasks of a buisiness don't disappear just because it's a bank holiday. I've been lucky, and managed to grab a couple of lazy days, but these were the first for 9 months so I'm not feeling particularly guilty!
This template is prepared for calculating the gravitational acceleration, g, for given altitude and latitudes. Also a latitude-gravitational acceleration chart is provided to understand the behabiour of g with respect to increasing latitudes. SpreadsheetWEB version provides all features of the template online.
Download for free at
狗腳印幸福聯盟
20131004狗腳印救援: 內湖收容所黃金弟~金恩
四合一過 目前有咳嗽+血便現象
隔離醫療完畢開放認養
照片來源: 貓狗同樂會
醫療支援捐款請至：
docs.google.com/spreadsheet/viewform?formkey=dHMwbFpSSFlX...