• Welcome back Guest!

    MARSH is a private reefing group. Comments and suggestions are encouraged, but please keep them positive and constructive. Negative threads, posts, or attacks will be removed from view and reviewed by the staff. Continually disruptive, argumentative, or flagrant rule breakers may be suspended or banned.

PIF Spreadsheet (1 Viewer)

Users who are viewing this thread

Scott

Guest
Joined
Sep 3, 2007
Messages
2,032
Reaction score
0
Location
Webster
Here is the link to a Google Spreadsheet I started:

P.I.F. Spreadsheet

I'm thinking maybe those of us participating should put a P.I.F. in our sig-line with. I would make it but I forgot how...

Its easy to edit, when you pass something along to someone else you would naturally place their name in the next column and to keep it from getting overcrowded place a space between the names of the people you shared with as well as additional spaces between your name and those of the people below you. How do you do this you ask. Its simple, just click on the number of the row to highlight the entire row and then right-click and click add 1 space above or add 1 space below. Kinda like making a family tree for your coral! And I made sure to make it editable by anyone with the link!

To make a new page just click the + sign at the bottom of the page and right click it to rename it to whatever your name is + the name of the coral.
 

soymilk

Supporting Member
Joined
Feb 3, 2010
Messages
2,611
Reaction score
1,358
Location
Fresno, Texas
Nice. But we need to think a little further down the road. The way that spreadsheet is currently setup, with every generation, the number of rows taken increases exponentially. If Gabe was to provide a frag that reached it's 3rd generation. That's 4 rows, what if he provides a 2nd frag, then his first one reaches it's 3rd generation? The 2nd frag is pushed down 4 more rows. Etc etc.

I think it should be set up more like a tree. Times like this I wish I was a programmer lol.
 
R

RocketSurgeon

In the meantime, it is something that can get us started. Right?
 

soymilk

Supporting Member
Joined
Feb 3, 2010
Messages
2,611
Reaction score
1,358
Location
Fresno, Texas
Oh yea..... Sorry if that sounded like I was against the spreadsheet.

I always tend to think too far ahead. Sorry guys. The only problem I see upcoming is the number of tabs. If things go good, I would like to donate 2 different Sps. I could imagine, if participation keeps up, that'll be a lot of tabs lol.

I'm just throwing ideas around. Sorry if I keep sounding like mr negative.
 
OP
OP
S

Scott

Guest
Joined
Sep 3, 2007
Messages
2,032
Reaction score
0
Location
Webster
I agree with you too soymilk, but its a start and a way to keep track until someone smarter than me makes something better! No worries, Im always open to POSITIVE/CONSTRUCTIVE criticism.

I say neigh to the neigh-sayers!
 

gabe_j

Guest
Joined
Aug 14, 2010
Messages
1,389
Reaction score
0
Location
clear lake
We could each have a tab and our frag lines could stay documented from the original donation into PIF. That way we could easily track everything
 
OP
OP
S

Scott

Guest
Joined
Sep 3, 2007
Messages
2,032
Reaction score
0
Location
Webster
There is a separate tab for each original coral named after the originator and coral type
 
R

RocketSurgeon

Scott said:
There is a separate tab for each original coral named after the originator and coral type


RGH69 has a pic attached to the spreadsheet. Looks great.
 

Mark L.

Moved On
Joined
Oct 8, 2010
Messages
7,532
Reaction score
0
Location
The Woodlands
My tank is fairly new (almost 2 months) but I was thinking about joining this also. While thinking about it I also came up with a way to track the lineage of each frag. I use PowerPoint quite a bit to create family tree type charts. It's extremely easy since it draws the tree for you. All you have to do is enter the txt. I'm not sure how we could implement it online so everyone could modify it though. It would most likely have to be done by one person. Just a thought though. Here's a quick one I did in like 3 minutes. Now that I see the online spreadsheet. That may be easiest. It is also easy to get messed up with everyone being able to access it. Each slide can be a mother colony like in the spreadsheet. Then a presentation could be made and posted.

 
OP
OP
S

Scott

Guest
Joined
Sep 3, 2007
Messages
2,032
Reaction score
0
Location
Webster
AWESOME! Does google supports this function as well? That way everyone would have access and could change it when needed. I know they have one called Presentation but can you do the TREE in it?
 

Mark L.

Moved On
Joined
Oct 8, 2010
Messages
7,532
Reaction score
0
Location
The Woodlands
Scott said:
AWESOME! Does google supports this function as well? That way everyone would have access and could change it when needed. I know they have one called Presentation but can you do the TREE in it?

I'm not sure. I'll look into it real quick.
 

Mark L.

Moved On
Joined
Oct 8, 2010
Messages
7,532
Reaction score
0
Location
The Woodlands
Well I got it up in Google Docs. Not sure how to edit though. Let me test this link. Someone else can click the link and see if they can edit also.

https://docs.google.com/viewer?a=v&...I5NjgtZmFjOTg0NDBkNjQz&hl=en&authkey=CPHvgu8F

Edit: Hmmm it looks like I can download the file to edit but I can't edit right there in Google docs. I may be doing something wrong. This is the first time I've used Google docs. LOL
 

lesd

Supporting Member
Joined
Nov 15, 2004
Messages
658
Reaction score
29
Location
Cypress - near Barker Cypress/290
I figured out a way to create a chart like this in Google Docs, but we have to format the data a little differently. The chart is designed to be an org chart, but it works.

Take a look at the "Lesd Tubs Mystic Blue" tab in the spreadsheet to see how to format the data. Then you just click on the "chart" button in google docs and choose the org chart. It automatically recognizes the data if formatted like mine.
 

zeek

Guest
Joined
Oct 27, 2010
Messages
353
Reaction score
0
Location
Pearland, Tx
I couldn't figure out how to edit it, I wanted to remove myself from one of the PIF where I am listed but I didn't receive it.
 

aw1447

Guest
Joined
Jun 11, 2011
Messages
25
Reaction score
0
Location
League City, Tx
Great little thing yall have going here.. I'd heard about PIF in other reef clubs on different forums, very cool to see there's one in Houston! I'm new to the site and will be officially joining soon (as soon I get paid lol). But I'd definitely be willing to contribute to the cause!
 
Top