One thing that is certain life is that there will be changes.
And so, that is what today is about is some changes to
a tool that I made a couple of years ago.
And this is the Segment Phasing spreadsheet. The Segment Phasing is similar to Visual Phasing,
and in the notes below we will include the links to the videos where I talk about Segment Phasing,
and how to do Segment Phasing, as well as links to the Segment Phasing spreadsheet. Now,
this spreadsheet was made in Google Docs and it is based on Stephen Fox's spreadsheet in
Excel that he uses for Visual Phasing. So let me walk you through some of the
changes that I have made to these Segment Phasing spreadsheet. First off, one of the things that
you will notice is I've actually divided this up into three different spreadsheets.
Now, before I had all the templates in one spreadsheet.
Now, I have one for three people, one for four people,
and one four five people. So whether you have three siblings,
four siblings, or five siblings, then you're gonna wanna pick the specific spreadsheet for it.
They're slightly different as far as the formulas that they use.
The other thing that you will notice is instead of just the templates down here, I have actually
divided it out by chromosomes so that you have all the chromosomes plus the extra chromosome.
And then there is the template at the end on each one of these.
So all these have been broken out. And this just makes it much easier.
You don't have to do as much duplicating and entering in the information on that.
It only takes about five minutes to do it, but, hey, I did it for five minutes.
And it saves everybody else from doing it for five minutes.
Now, the third change is something that somebody actually had told me about and that is for this.
You're primarily taking information from GEDmatch from the One-to-One tool.
And what you want to do is you want to get the position information. Well,
GEDmatch has made some changes over the last year, and this is one of the changes they made is.
They actually added in three columns here the Segment Threshold, Bunch Limit,
and the SNP Density Ratio. Now, you don't use that information in Visual Phasing at all, but because
it's in the table we need to account for it so that we don't mess up where our formulas are.
And because of that, then on the Segment Tab, what you will find is I've added these
three new columns for the Segment Threshold, the Bunch Limit, and the SNP Density Ratio.
The idea here just to show you is we want to take and we want to copy all of this.
And let me see if I can get it here and paste it back in this table here.
And it should fill in those columns which is going to automatically calculate
the start and end position in millions. And this is a comparison, you know, A to B.
And again you can go through and watch the video to see everything there.
I'm just going to highlight this so you can see what is great about this now.
And this is a half identity. In other words, it's a half-match.
So I'm going to highlight all of those here. Other than those three new
columns this is still the same. And actually, what I'm going to do is.
I'm going to go through and I'm going to hide these three columns because the data is going
to paste in where we want it anyway. I just needed to add them in.
Ao I'm going to hide those columns. What you will see, now, is because I've added
all these chromosome halve, that chromosome information- the segment information- is now
going to automatically populate these areas. And so, you don't have to go and create
it and make sure that the formula is right and have that populated.
It's going to automatically populate it all throughout the table.
So I've basically made this spreadsheet so it's a little bit more user friendly.
Now, one of the things that I have planned to do- I just have not gotten to it- is elaborate more on
the instructions on how to use this specifically. So I expect to be doing that here- hopefully
within the next six months - that all three of these are
going to be much better much more useful for it. But since there are several people that do use the
Segment Phasing spreadsheet, I wanted to make sure that you had that information for you as well.
Now, if you have used the old spreadsheet and you're downloading this new spreadsheet, a couple
of things that you can do to make your job easier. First thing is unhide these columns by just
clicking on that little arrow at the top there. Then when you grab the information, you should be
able to just copy it all from your old spreadsheet and paste it into this new spreadsheet here.
Now, do you need to upgrade to this spreadsheet? Only for new Segment Phasing.
You don't need to do that for the ones you've already done unless you're adding information
into it- maybe another sibling or something like that. The old spreadsheet's still going
to work just fine the way that it is. So I hope that you found those updates
to the spreadsheet useful. And if you've been using it, then great let me know of
any errors that you find in it and I can get those corrected so that everybody that's using
the spreadsheet is able to use that. And I told you that I am going to put
the videos for the Segment Phasing down below, but you can always click on the
first one over here and they're also going to have the links in the description as well.