MomToEliEm
Moderator
Idea for gathering carseat measurements as a group
For a while now, I felt that we needed a way to collaborate carseat information and measurements into one location so that it can be easily viewed and compared. I know there is a carseat measurements page, but it is often not updated or missing some carseat information I would like to see.
Just as a test to see if this system might work, I created a google document spreadsheet/form for gathering various pieces of information for dedicated booster seats. If the system actually works for gathering data, we can expand it to collect information on infant, convertible, youth, and combination type carseats.
If you want to try it out to see if you have access (I believe that I set it for everyone to have rights to submit data via the form, but read-only on the spreadsheet), use the following links.
Link to dedicated booster entry form:
http://spreadsheets.google.com/viewform?formkey=dHhtQ2FGOHRmVERoQ3laUWhwcU5WSEE6MA
Link to spreadsheet displaying the submitted data:
http://spreadsheets.google.com/ccc?key=0Agz99-M7a5EedHhtQ2FGOHRmVERoQ3laUWhwcU5WSEE&hl=en
If you want to just test submit something, enter whatever information you want and enter "testsubmit" in the username field (very last field on the form) as a way for me to see that you are just submitting a test entry and not valid data. I can purge those records so they are not displayed on the end report.
If you have actual seat information, feel free to enter that on the form. I would love to see 2-4 entries of data entered for each seat (at least with measurements) so that on whatever final spreadsheet is created, an average or most agreed upon measurement can be entered for each seat. I may periodically do an alphabetical sort of the seats so you can easily see all the seats in order which have been submitted. If you don't want to deal with gathering all the data I have on my form, just enter some of it, and hopefully someone else will fill in the other data later.
If there is an issue with security to the form, I may need assistance from anyone with google documents experience to help me figure out what settings I need to do. I can also invite people to view the form if needed, though I was hoping it could be open to all so we could easily gather the data.
Let me know if the system seems to be working. If you have any questions or suggestions about the data being collected, I can still make changes, deletions, or additions.
Edited to add the links to the other carseat types:
Infant Seats:
Form to enter the data:
http://spreadsheets.google.com/viewform?formkey=dE9jYXd4TEpTaEJsa1BrZTFPWEE0Rnc6MA
Spreadsheet Summary:
http://spreadsheets.google.com/ccc?key=0Agz99-M7a5EedE9jYXd4TEpTaEJsa1BrZTFPWEE0Rnc&hl=en
Convertible Seats:
Form to enter the data:
http://spreadsheets.google.com/viewform?formkey=dEd2ZjVzRHdxTkdzLVpzek5YOVVsdVE6MA
Spreadsheet Summary:
http://spreadsheets.google.com/ccc?key=0Agz99-M7a5EedEd2ZjVzRHdxTkdzLVpzek5YOVVsdVE&hl=en
Combination Seats/Youth Seats:
Form to enter the data:
http://spreadsheets.google.com/viewform?formkey=dHh6R0pDQk9mU01pSXFfT2dxQ0dqb3c6MA
Spreadsheet Summary:
http://spreadsheets.google.com/ccc?key=0Agz99-M7a5EedHh6R0pDQk9mU01pSXFfT2dxQ0dqb3c&hl=en
Dedicated Booster Seats
Form to enter the data:
http://spreadsheets.google.com/viewform?formkey=dHhtQ2FGOHRmVERoQ3laUWhwcU5WSEE6MA
Spreadsheet Summary:
http://spreadsheets.google.com/ccc?key=0Agz99-M7a5EedHhtQ2FGOHRmVERoQ3laUWhwcU5WSEE&hl=en
Shortly, we will add a new thread asking for people to add their data, but feel free to add your data now as the spreadsheet links are the same as what they will be in the new data gathering threads. I have added 3 of my seats (regent, monterey, graco cargo, and will try to get my older style parkway later on). If you make any mistakes and need something changed, just PM the info and I can edit or delete anything that needs to be done.
For a while now, I felt that we needed a way to collaborate carseat information and measurements into one location so that it can be easily viewed and compared. I know there is a carseat measurements page, but it is often not updated or missing some carseat information I would like to see.
Just as a test to see if this system might work, I created a google document spreadsheet/form for gathering various pieces of information for dedicated booster seats. If the system actually works for gathering data, we can expand it to collect information on infant, convertible, youth, and combination type carseats.
If you want to try it out to see if you have access (I believe that I set it for everyone to have rights to submit data via the form, but read-only on the spreadsheet), use the following links.
Link to dedicated booster entry form:
http://spreadsheets.google.com/viewform?formkey=dHhtQ2FGOHRmVERoQ3laUWhwcU5WSEE6MA
Link to spreadsheet displaying the submitted data:
http://spreadsheets.google.com/ccc?key=0Agz99-M7a5EedHhtQ2FGOHRmVERoQ3laUWhwcU5WSEE&hl=en
If you want to just test submit something, enter whatever information you want and enter "testsubmit" in the username field (very last field on the form) as a way for me to see that you are just submitting a test entry and not valid data. I can purge those records so they are not displayed on the end report.
If you have actual seat information, feel free to enter that on the form. I would love to see 2-4 entries of data entered for each seat (at least with measurements) so that on whatever final spreadsheet is created, an average or most agreed upon measurement can be entered for each seat. I may periodically do an alphabetical sort of the seats so you can easily see all the seats in order which have been submitted. If you don't want to deal with gathering all the data I have on my form, just enter some of it, and hopefully someone else will fill in the other data later.
If there is an issue with security to the form, I may need assistance from anyone with google documents experience to help me figure out what settings I need to do. I can also invite people to view the form if needed, though I was hoping it could be open to all so we could easily gather the data.
Let me know if the system seems to be working. If you have any questions or suggestions about the data being collected, I can still make changes, deletions, or additions.
Edited to add the links to the other carseat types:
Infant Seats:
Form to enter the data:
http://spreadsheets.google.com/viewform?formkey=dE9jYXd4TEpTaEJsa1BrZTFPWEE0Rnc6MA
Spreadsheet Summary:
http://spreadsheets.google.com/ccc?key=0Agz99-M7a5EedE9jYXd4TEpTaEJsa1BrZTFPWEE0Rnc&hl=en
Convertible Seats:
Form to enter the data:
http://spreadsheets.google.com/viewform?formkey=dEd2ZjVzRHdxTkdzLVpzek5YOVVsdVE6MA
Spreadsheet Summary:
http://spreadsheets.google.com/ccc?key=0Agz99-M7a5EedEd2ZjVzRHdxTkdzLVpzek5YOVVsdVE&hl=en
Combination Seats/Youth Seats:
Form to enter the data:
http://spreadsheets.google.com/viewform?formkey=dHh6R0pDQk9mU01pSXFfT2dxQ0dqb3c6MA
Spreadsheet Summary:
http://spreadsheets.google.com/ccc?key=0Agz99-M7a5EedHh6R0pDQk9mU01pSXFfT2dxQ0dqb3c&hl=en
Dedicated Booster Seats
Form to enter the data:
http://spreadsheets.google.com/viewform?formkey=dHhtQ2FGOHRmVERoQ3laUWhwcU5WSEE6MA
Spreadsheet Summary:
http://spreadsheets.google.com/ccc?key=0Agz99-M7a5EedHhtQ2FGOHRmVERoQ3laUWhwcU5WSEE&hl=en
Shortly, we will add a new thread asking for people to add their data, but feel free to add your data now as the spreadsheet links are the same as what they will be in the new data gathering threads. I have added 3 of my seats (regent, monterey, graco cargo, and will try to get my older style parkway later on). If you make any mistakes and need something changed, just PM the info and I can edit or delete anything that needs to be done.
Last edited: