+ Reply to Thread
Results 1 to 4 of 4

Punnet square shortcut?

  1. #1
    Registered User
    Join Date
    04-10-2014
    Location
    Columbus, Ohio
    MS-Off Ver
    Word 2000 and XP, Access 2000 and XP, Powerpoint 2000 and XP, Excel 2000 and XP
    Posts
    12

    Punnet square shortcut?

    Is there a faster way to do all possible 2x2 punnet squares? I have been copying and pasting but that isn't very fast. I am doing phenotype punnet squares so the mother and father are still represented with alleles but the offspring are represented with phenotypes. All colors are incomplete dominant resulting in 1 intermediate for each multi color combination.

    Here is the spreadsheet. The second sheet(which shows up when you open it) is where the punnet squares are. There is a sheet to the left of it where I display all the alleles:
    Attached Files Attached Files
    Last edited by caters; 07-17-2016 at 10:16 PM.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Punnet square shortcut?

    OK, I recognize the term punnet squares from when Professor Mendel taught me biology back in high school. (Yeah, it's been that long). That's about all I remember. So re-educate me and maybe I can help you .

    Can you walk us through one or two examples of how you get from sheet 1 to sheet 2, please?
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    04-10-2014
    Location
    Columbus, Ohio
    MS-Off Ver
    Word 2000 and XP, Access 2000 and XP, Powerpoint 2000 and XP, Excel 2000 and XP
    Posts
    12

    Re: Punnet square shortcut?

    I will give you an example:

    I copy and paste Lava(Color and all) from sheet 1 5 times onto sheet 2(twice in a single column for mom's alleles, once in a single row for father's alleles, and twice for offspring phenotypes). I then copy and paste Sand next to Lava in the father's alleles row. Then I type and fill Sandstone once in the column below Sand and then copy and paste it 1 row below.

    Another example of what I might do is like this:

    Make AA+/+, BB+/+, etc. on a diagonal in blood types(An example of a 2 gene monohybrid cross). Copy any already existing blood types(color and text) into new punnet squares with different combinations(So for example I might have in the mother's column A+ and O+ and in the father's row B+ and O-. This would mean that I would copy these from the diagonal: AB+/+, BO+/+, AO+/-, and OO+/-).

    So that is how I go between sheets or between parts of the same sheet in genetics spreadsheets. I often have at least 1 sheet for the total probability of each allele combination.

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Punnet square shortcut?

    The second example makes more sense to me. Basically you are looking for the combinations. So if we were comparing Luster you are looking for:
    Non-metallic-Non-metallic
    Non-metallic-Metallic
    Metallic-Metallic

    I am still not quite sure how you want to display this.

    In the first example you gave in what cells on the Punnet Squares sheet do you put mom's alleles. What cells father's alleles and what cells for the offspring. I'm mapping "Lava" (Cell A2 on Sheet1) to which 5 cells on the Punnet Square page?

    I got that the very first example is mom and dad both lava. Then I change one parent to Fire and repeat the process. Can you take a snapshot of what that would look like and post it in JPEG format (or as an actual spreadsheet).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 02-21-2014, 10:19 AM
  2. [SOLVED] convert square meters to square feet
    By mroberts in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-07-2013, 12:51 PM
  3. Replies: 2
    Last Post: 04-28-2012, 10:19 PM
  4. using alt as a shortcut key/list of symbols for shortcut keys
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2010, 09:12 AM
  5. Replies: 3
    Last Post: 08-19-2009, 08:53 AM
  6. how to center a square plot area in a square chart
    By xppuser in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-11-2006, 04:20 AM
  7. Replies: 1
    Last Post: 10-24-2005, 08:05 PM
  8. Making Punnet Squares
    By desolatax in forum Excel General
    Replies: 5
    Last Post: 01-17-2005, 10:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1