How To Use the Weight Spreadsheet
Rev. 3 Mar 11, by Vicki Pelton
This spreadsheet is to be used to record the weight of kits (baby rabbits) each day. This is important information
that you can use to tell how well the kits are growing. It is set up to record the weights of up to eight or twelve
kits. For eight kits, print in portrait mode. For twelve kits, print in landscape mode. You can also record the
weight of the mother. It is assumed you will be using a gram scale for the kits & a pound scale for the mother.
For the kits, grams will be converted to ounces & also to pounds. For the mother, pounds & ounces will be
converted to grams. If a kit's weight is less than the day before, it will show in red.
The Example Tab shows how all the data can be entered. The numbers in the Example Tab have been made up
just to show various features. They are not values from real rabbits.
First make a copy of the Blank Tab that you want to use. This will allow you to keep the Blank Tab for future use.
Name the new tab with the name of the mother.
To make a new Tab, right click the Tab, then select "Move or Copy". On the popup window, check "Create a
copy", select "move to end", then click OK. To change the name of a Tab, double click the Tab name (dark
background will appear), type in the new name, then press the Enter key.
In the new Tab, fill in the following values:
name of the mother on the top line
names (or descriptions) of the kits just below the top line
birthdate of the kits in the cell just before where it says "is birthdate"
This will cause the dates to be automatically filled in for a bit more than 2 months.
If you will be writing the weights onto a piece of paper & typing them into the computer later, you can use the "lg"
tabs as described below. Or, if you'd rather use the current tab, this is a good time to print out the spreadsheet,
which will produce a blank form with the dates & names filled in. To print, highlight the area to be printed (all rows
& also columns from the first through all the gram values), choose "Selecton" & print.
There are a few rows that can be used to record the weight of the mother. Enter the date & the weight in pounds
& ounces & fraction of an ounce. E.g., enter pounds as 4; enter ounces as 5 3/8. Grams will be calculated.
For the kits, enter the weights (in grams) each day. Alternatively, you may enter the weights of the kits in either
ounces or pounds (& fractions of pounds). In this case, weights will not be converted to other units.
To plot a graph of the weights of the kits:
highlight the weights you want to plot
click on Insert; Chart
choose Chart Type as Line
choose other options as desired (default values work fine)
The resulting graph can be moved with the cursor. It can also be resized by dragging the black squares on the
edges of the graph.
Once you have determined the sex of the kits, that information can be entered where indicated on the chart.
The following is for Excel experts only. If you want to record the weight of the mother in grams & have it
converted to pounds, do the following. First enter the weight of the mother in grams. After that, enter the
following formula on the same line, in the pounds column: =((ROUND((arg/$M$3)*4,0))/4) . Then change arg to
be the cell that contains the weight in grams. For example, if the weight in grams is in cell P8, then use the
following formula: =((ROUND((P8/$M$3)*4,0))/4) The next time you enter the mother's weight in grams, you can
then copy the formula you entered the first time & paste it into the new row. Note that for each row, you must
enter the weight of the mother in grams BEFORE you enter the formula for pounds.
The above formula is for the Blank 8 tab. If you are using the Blank 12 tab, use this formula:
=((ROUND((arg/$Q$3)*4,0))/4)
In the Pounds (lb) cell, change the number format to: Fraction; Up to one digit (1/4)
The tabs explained above are for entering data into the computer. The tabs labeled "Blank 8 lg" & "Blank 12 lg"
can be printed out & used to enter data by hand. The cells in these tabs are bigger than the cells in the other
tabs. Before you print out the tabs, enter the mom's name in the top row, in the parentheses. Also enter the
birthdate of the kits in the cell just before where it says "is birthdate". This will cause the dates to be automatically
filled in for a bit more than 2 months. You don't need to make a copy of this tab before entering the data. You can
just reuse the tab for the next litter.
Weight of Splash & Kits (Example)
Sex # Description
M 1 white
M 2 mom jr.
F 3 black, white on shoulders
M 4 hotot, wavy fur
F 5 hotot, clear back
F 6 hotot, spot on back
M 7 white, brown spots on sides
F 8 brown
Date Day Days Kits' Weight (grams)
1 2 3 4 5 6 7 8
22-Feb-09 is birthdate
22-Feb-09 Sun 0 108 75 100 70 86 80 86 90
23-Feb-09 Mon 1 114 86 114 80 98 83 97 107
24-Feb-09 Tue 2 128 94 122 89 107 90 105 115
25-Feb-09 Wed 3 142 107 135 100 115 87 123 133
26-Feb-09 Thu 4 150 110 144 113 124 105 131 141
27-Feb-09 Fri 5 164 124 153 124 131 121 140 150
28-Feb-09 Sat 6 178 120 163 135 136 125 149 159
1-Mar-09 Sun 7 201 159 196 164 174 166 179 189
2-Mar-09 Mon 8 210 172 204 180 187 176 189 199
3-Mar-09 Tue 9 226 191 223 193 204 190 205 215
4-Mar-09 Wed 10 231 198 230 211 216 199 214 224
5-Mar-09 Thu 11 247 197 245 215 222 212 233 243
6-Mar-09 Fri 12 251 200 252 224 232 218 236 246
7-Mar-09 Sat 13 266 212 265 228 250 233 246 256
8-Mar-09 Sun 14 281 220 275 236 251 238 241 263
9-Mar-09 Mon 15 293 235 286 252 266 253 269 274
10-Mar-09 Tue 16 303 251 303 263 288 264 287 293
11-Mar-09 Wed 17 322 267 332 285 300 276 302 313
12-Mar-09 Thu 18 350 295 361 306 322 286 327 334
13-Mar-09 Fri 19 423 354 429 379 231 318 382 392
14-Mar-09 Sat 20 446 376 448 395 324 383 397 405
15-Mar-09 Sun 21 600 502 498 509 450 537 576 524
16-Mar-09 Mon 22 723 603 632 543 621 521 721 598
17-Mar-09 Tue 23
18-Mar-09 Wed 24
19-Mar-09 Thu 25
20-Mar-09 Fri 26
21-Mar-09 Sat 27
22-Mar-09 Sun 28 450
23-Mar-09 Mon 29
24-Mar-09 Tue 30
25-Mar-09 Wed 31 400
26-Mar-09 Thu 32
27-Mar-09 Fri 33 350
28-Mar-09 Sat 34
29-Mar-09 Sun 35
30-Mar-09 Mon 36 300
31-Mar-09 Tue 37
1-Apr-09 Wed 38 250
2-Apr-09 Thu 39
3-Apr-09 Fri 40
4-Apr-09 Sat 41 200
5-Apr-09 Sun 42
6-Apr-09 Mon 43 150
7-Apr-09 Tue 44
8-Apr-09 Wed 45
9-Apr-09 Thu 46 100
10-Apr-09 Fri 47
11-Apr-09 Sat 48
50
12-Apr-09 Sun 49 1 3 5 7 9 11 13 15 17 19 21 23
13-Apr-09 Mon 50
14-Apr-09 Tue 51
15-Apr-09 Wed 52
16-Apr-09 Thu 53
17-Apr-09 Fri 54
18-Apr-09 Sat 55
19-Apr-09 Sun 56
20-Apr-09 Mon 57
21-Apr-09 Tue 58
22-Apr-09 Wed 59
23-Apr-09 Thu 60
24-Apr-09 Fri 61
25-Apr-09 Sat 62
28.349523 grams in one ounce
453.592368 grams in one pound
Mom
Weight Weight
Date lb oz grams
27-Feb-09 5 12 2608
21-Mar-09 5 14 2665
Kits' Weight (ounces)
1 2 3 4 5 6 7 8
4 3 4 2 3 3 3 3
4 3 4 3 3 3 3 4
5 3 4 3 4 3 4 4
5 4 5 4 4 3 4 5
5 4 5 4 4 4 5 5
6 4 5 4 5 4 5 5
6 4 6 5 5 4 5 6
7 6 7 6 6 6 6 7
7 6 7 6 7 6 7 7
8 7 8 7 7 7 7 8
8 7 8 7 8 7 8 8
9 7 9 8 8 7 8 9
9 7 9 8 8 8 8 9
9 7 9 8 9 8 9 9
10 8 10 8 9 8 9 9
10 8 10 9 9 9 9 10
11 9 11 9 10 9 10 10
11 9 12 10 11 10 11 11
12 10 13 11 11 10 12 12
15 12 15 13 8 11 13 14
16 13 16 14 11 14 14 14
21 18 18 18 16 19 20 18
26 21 22 19 22 18 25 21
Series1
Series2
Series3
Series4
Series5
Series6
Series7
Series8
23
Kits' Weight (pounds) Difference (gram
1 2 3 4 5 6 7 8 1 2 3
1/4 1/4 1/4 1/4 1/4 1/4 1/4 1/4
1/4 1/4 1/4 1/4 1/4 1/4 1/4 1/4 6 11 14
1/4 1/4 1/4 1/4 1/4 1/4 1/4 1/4 14 8 8
1/4 1/4 1/4 1/4 1/4 1/4 1/4 1/4 14 13 13
1/4 1/4 1/4 1/4 1/4 1/4 1/4 1/4 8 3 9
1/4 1/4 1/4 1/4 1/4 1/4 1/4 1/4 14 14 9
1/2 1/4 1/4 1/4 1/4 1/4 1/4 1/4 14 -4 10
1/2 1/4 1/2 1/4 1/2 1/4 1/2 1/2 23 39 33
1/2 1/2 1/2 1/2 1/2 1/2 1/2 1/2 9 13 8
1/2 1/2 1/2 1/2 1/2 1/2 1/2 1/2 16 19 19
1/2 1/2 1/2 1/2 1/2 1/2 1/2 1/2 5 7 7
1/2 1/2 1/2 1/2 1/2 1/2 1/2 1/2 16 -1 15
1/2 1/2 1/2 1/2 1/2 1/2 1/2 1/2 4 3 7
1/2 1/2 1/2 1/2 1/2 1/2 1/2 1/2 15 12 13
1/2 1/2 1/2 1/2 1/2 1/2 1/2 1/2 15 8 10
3/4 1/2 3/4 1/2 1/2 1/2 1/2 1/2 12 15 11
3/4 1/2 3/4 1/2 3/4 1/2 3/4 3/4 10 16 17
3/4 1/2 3/4 3/4 3/4 1/2 3/4 3/4 19 16 29
3/4 3/4 3/4 3/4 3/4 3/4 3/4 3/4 28 28 29
1 3/4 1 3/4 1/2 3/4 3/4 3/4 73 59 68
1 3/4 1 3/4 3/4 3/4 1 1 23 22 19
1 1/4 1 1 1 1 1 1/4 1 1/4 1 1/4 154 126 50
1 1/2 1 1/4 1 1/2 1 1/4 1 1/4 1 1/4 1 1/2 1 1/4 123 101 134
Difference (grams) Difference (percent)
4 5 6 7 8 1 2 3 4 5 6
10 12 3 11 17 5.6 14.7 14.0 14.3 14.0 3.8
9 9 7 8 8 12.3 9.3 7.0 11.3 9.2 8.4
11 8 -3 18 18 10.9 13.8 10.7 12.4 7.5 -3.3
13 9 18 8 8 5.6 2.8 6.7 13.0 7.8 20.7
11 7 16 9 9 9.3 12.7 6.3 9.7 5.6 15.2
11 5 4 9 9 8.5 -3.2 6.5 8.9 3.8 3.3
29 38 41 30 30 12.9 32.5 20.2 21.5 27.9 32.8
16 13 10 10 10 4.5 8.2 4.1 9.8 7.5 6.0
13 17 14 16 16 7.6 11.0 9.3 7.2 9.1 8.0
18 12 9 9 9 2.2 3.7 3.1 9.3 5.9 4.7
4 6 13 19 19 6.9 -0.5 6.5 1.9 2.8 6.5
9 10 6 3 3 1.6 1.5 2.9 4.2 4.5 2.8
4 18 15 10 10 6.0 6.0 5.2 1.8 7.8 6.9
8 1 5 -5 7 5.6 3.8 3.8 3.5 0.4 2.1
16 15 15 28 11 4.3 6.8 4.0 6.8 6.0 6.3
11 22 11 18 19 3.4 6.8 5.9 4.4 8.3 4.3
22 12 12 15 20 6.3 6.4 9.6 8.4 4.2 4.5
21 22 10 25 21 8.7 10.5 8.7 7.4 7.3 3.6
73 -91 32 55 58 20.9 20.0 18.8 23.9 -28.3 11.2
16 93 65 15 13 5.4 6.2 4.4 4.2 40.3 20.4
114 126 154 179 119 34.5 33.5 11.2 28.9 38.9 40.2
34 171 -16 145 74 20.5 20.1 26.9 6.7 38.0 -3.0
cent)
7 8
12.8 18.9
8.2 7.5
17.1 15.7
6.5 6.0
6.9 6.4
6.4 6.0
20.1 18.9
5.6 5.3
8.5 8.0
4.4 4.2
8.9 8.5
1.3 1.2
4.2 4.1
-2.0 2.7
11.6 4.2
6.7 6.9
5.2 6.8
8.3 6.7
16.8 17.4
3.9 3.3
45.1 29.4
25.2 14.1
Weight of (Mom's Name) & Kits
Sex # Description
1 name1
2 name2
3 name3
4 name4
5 name5
6 name6
7 name7
8 name8
Date Day Days Kits' Weight (grams)
1 2 3 4 5 6 7 8
is birthdate
28.349523 grams in one ounce
453.592368 grams in one pound
Mom
Weight Weight
Date lb oz grams
Kits' Weight (ounces)
1 2 3 4 5 6 7 8
Kits' Weight (pounds) Difference (gram
1 2 3 4 5 6 7 8 1 2 3
Difference (grams) Difference (percent)
4 5 6 7 8 1 2 3 4 5 6
cent)
7 8
Weight of (Mom's Name) & Kits
Sex # Description
1 name1
2 name2
3 name3
4 name4
5 name5
6 name6
7 name7
8 name8
9 name9
10 name10
11 name11
12 name12
Date Day Days Kits' Weight (grams)
1 2 3 4 5 6 7 8 9 10 11 12
is birthdate
28.349523 grams in one ounce
453.592368 grams in one pound
Mom
Weight Weight
Date lb oz grams
Kits' Weight (ounces)
1 2 3 4 5 6 7 8 9 10 11 12
Kits' Weight (pounds) D
1 2 3 4 5 6 7 8 9 10 11 12 1 2 3
Difference (grams) Difference (percent)
4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7
nce (percent)
8 9 10 11 12
Weight of Mom & Kits (Rhonda)
Sex # Description
1
2
3
4
5
6
7
8
Date Day Days Kits' Weight (grams)
1 2 3 4 5 6 7 8
28-Feb-11 is birthdate
28-Feb-11 Mon 0
1-Mar-11 Tue 1
2-Mar-11 Wed 2
3-Mar-11 Thu 3
4-Mar-11 Fri 4
5-Mar-11 Sat 5
6-Mar-11 Sun 6
7-Mar-11 Mon 7
8-Mar-11 Tue 8
9-Mar-11 Wed 9
10-Mar-11 Thu 10
11-Mar-11 Fri 11
12-Mar-11 Sat 12
13-Mar-11 Sun 13
14-Mar-11 Mon 14
15-Mar-11 Tue 15
16-Mar-11 Wed 16
17-Mar-11 Thu 17
18-Mar-11 Fri 18
19-Mar-11 Sat 19
20-Mar-11 Sun 20
21-Mar-11 Mon 21
22-Mar-11 Tue 22
23-Mar-11 Wed 23
24-Mar-11 Thu 24
25-Mar-11 Fri 25
26-Mar-11 Sat 26
27-Mar-11 Sun 27
28-Mar-11 Mon 28
29-Mar-11 Tue 29
30-Mar-11 Wed 30
31-Mar-11 Thu 31
1-Apr-11 Fri 32
2-Apr-11 Sat 33
3-Apr-11 Sun 34
4-Apr-11 Mon 35
5-Apr-11 Tue 36
6-Apr-11 Wed 37
7-Apr-11 Thu 38
8-Apr-11 Fri 39
9-Apr-11 Sat 40
10-Apr-11 Sun 41
11-Apr-11 Mon 42
12-Apr-11 Tue 43
13-Apr-11 Wed 44
14-Apr-11 Thu 45
15-Apr-11 Fri 46
16-Apr-11 Sat 47
17-Apr-11 Sun 48
18-Apr-11 Mon 49
19-Apr-11 Tue 50
20-Apr-11 Wed 51
21-Apr-11 Thu 52
22-Apr-11 Fri 53
23-Apr-11 Sat 54
24-Apr-11 Sun 55
25-Apr-11 Mon 56
26-Apr-11 Tue 57
27-Apr-11 Wed 58
28-Apr-11 Thu 59
29-Apr-11 Fri 60
30-Apr-11 Sat 61
1-May-11 Sun 62
28.349523 grams in one ounce
453.592368 grams in one pound
Mom
Weight Weight
Date lb oz grams
Weight of Mom & Kits ()
Sex # Description
1
2
3
4
5
6
7
8
9
10
11
12
Date Day Days Kits' Weight (grams)
1 2 3 4 5 6 7 8 9 10 11 12
is birthdate
28.349523 grams in one ounce
453.592368 grams in one pound
Mom
Weight Weight
Date lb oz grams