Thread Tools
This thread is privately moderated by davidterrell80, who may elect to delete unwanted replies.
Mar 08, 2015, 12:11 PM
AMA 986339 FCC KB5LAM/4
davidterrell80's Avatar
Thread OP
Discussion

RCM Plans Thread Database


In this thread, I will start keeping updated copies of the spreadsheet that I use to index the threads and track the status of the cleaning and scaling process.

Subscribing will ensure you are notified of updates.

David
Last edited by davidterrell80; Mar 29, 2018 at 10:54 AM.
Sign up now
to remove ads between posts
Feb 25, 2018, 09:23 PM
AMA 986339 FCC KB5LAM/4
davidterrell80's Avatar
Thread OP

Update of the RCM Plans Thread Index -- 25 FEBRUARY 2018


Update of the RCM Plans Thread Index -- 25 FEBRUARY 2018

NOTES:
1. Zip contains the spreadsheet, with version rolled to 18
2. Some additional plan information found and added to the database, current count is 1227.
3. Continued focus on improving plan image quality. I regraded some images downward.
4. Added a "Dewey Collection" column containing the post containing each plan. Added the Dewey Collection to the Statistics after Outerzone in priority


Statistics:

==================================================

Section 1: Combined Count of Unique Plans, giving precedence to Outerzone, Don Dewey Memorial Plan Collection, & RCM Plans Free threads


Spreadsheet instructions: Check Filters are cleared. Filter column D by the appropriate color. Look to the status row at the Bottom-Left for the numbers. Clear filters after checking each color. "Total Scaled" and the various percentages are manual calculations.

Scaled Plans:
ORANGE (OZ): 928/1227 = 75.6%
Blue (Don Dewey Collection): 86/1227 = 7.0%
Dark GREEN (RCM Plans Thread): 171/1227 = 13.9%
Sand BROWN (Elijah's blog): 13/1227 = 1.1%
Total scaled: 1189/1227 = 97.6%
Uncaptured
WHITE: 30/1227 = 2.4%
==================================================

Section 2: Separate count of plans in the Dewey Collection, "RCM Plans Free" and hlsat threads.

Spreadsheet Instructions: Check Filters are cleared. Get the Dewey collection number by filtering column K for non-blank values. Get the RCM Thread number by filtering column E for Green. Clear filters. Get the Elijah thread number by filtering column G for sand-brown. Clear filters.
Dewey Collection
Scaled: 576/1227 = 46.9%

RCM Plans Thread
Scaled: 1017/1227 = 82.9%

Elijah's blog (posts scaled plans only)
Scaled: 1129/1227 = 92.0%
==================================================

Section 3. Other Sources

Spreadsheet Instructions: Check Filters are cleared. Filter column H for Blue to get the number. Clear filters.
Note: a few cells are uncolored but contain a value (filter blue AND content greater than zero). These have a plan but no article.

J. Hatton Blog (posts articles with unscaled plans)
Available articles: 1113/1227 = 90.7%

==================================================

Section 4. Article Audit (All 4 Sources)

Spreadsheet Instructions: Clear filters. Filter column J for light Green to get the number. Clear filters.
Articles Captured: 1113/1227 = 90.7%
==================================================

Section 5. Plan Grades

Spreadsheet Instructions: Clear filters. Filter column K for Desired Grade the number. Clear filters.

AA - 776/1227 = 63.2%
BB - 227/1227 = 22.4%
CC - 94/1227 = 7.7%
DD - 13/1227 = 1.1%
XX - 38/1227 = 3.1% (not flight plans)
(blank) - 29/1227 = 2.4% (missing plans)

==================================================

References (the 5 sources tracked in this database):
Outerzone RCM Entries: http://outerzone.co.uk/advanced/list...ans_number.asp
Don Dewey Memorial Radio Control Modeler Plans Collection: https://www.rcgroups.com/forums/show...ans-Collection
"RCM Plans FREE!!!!" Thread: https://www.rcgroups.com/forums/show....php?t=2233857
Elijah's (hlsat) Blog: https://www.rcgroups.com/forums/show....php?t=2354459
J. Hatton Blog: http://pulling-gz.blogspot.com/?view=sidebar


Read-only link to my cloud-based repository
https://1drv.ms/f/s!AhJ_mZ04GPZNg5BQee62am2zGc8spA
Last edited by davidterrell80; Jul 13, 2018 at 06:12 PM.
Mar 29, 2018, 03:24 PM
AMA 986339 FCC KB5LAM/4
davidterrell80's Avatar
Thread OP

Update of the RCM Plans Thread Index -- 29 MARCH 2018


Update of the RCM Plans Thread Index -- 29 MARCH 2018

NOTES:
1. Zip contains the spreadsheet, with version rolled to 20
2. Some additional plan information found and added to the database, current count is 1230. Including one of the missing plans.
3. Continued focus on improving plan image quality. I regraded some images downward.
4. Added a "Dewey Collection" column containing the post containing each plan. Added the Dewey Collection to the Statistics after Outerzone in priority.
5. Added a macro function that can tell when a cell contains BOLD text or not. Created columns enabling me to filter by whether OZ had an article, the Dewey Collection had Cover/Editorial/TOC, Elijah had an article, and when I had a copy of the issue.
6. Additional tabs hold analysis of numbers of designs produced by various designers.


Statistics:

==================================================

Section 1: Combined Count of Unique Plans, giving precedence to Outerzone, Don Dewey Memorial Plan Collection, & RCM Plans Free threads


Spreadsheet instructions: Check Filters are cleared. Filter column D by the appropriate color. Look to the status row at the Bottom-Left for the numbers. Clear filters after checking each color. "Total Scaled" and the various percentages are manual calculations.

Scaled Plans:
ORANGE (OZ): 932/1230 = 75.8%
Blue (Don Dewey Collection): 130/1230 = 10.6%
Dark GREEN (RCM Plans Thread): 128/1230 = 10.4%
Sand BROWN (Elijah's blog): 11/1230 = 0.9%
Total scaled: 1201/1230 = 97.6%
Uncaptured
WHITE: 29/1230 = 2.4%
==================================================

Section 2: Separate count of plans in the Dewey Collection, "RCM Plans Free" and hlsat threads.

Spreadsheet Instructions: Check Filters are cleared. Get the Dewey collection number by filtering column E for blue. Clear Filters. Get the RCM Thread number by filtering column F for Green. Clear filters. Get the Elijah thread number by filtering column H for sand-brown. Clear filters.
Dewey Collection
Scaled: 777/1230 = 63.7%

RCM Plans Thread
Scaled: 1020/1230 = 82.9%

Elijah's blog (posts scaled plans only, but does not keep current versions)
Scaled: 1129/1230 = 91.8%
==================================================

Section 3. Other Sources

Spreadsheet Instructions: Check Filters are cleared. Filter column I (India) for Blue to get the number. Clear filters.
Note: a few cells are uncolored but contain a value (filter blue AND content greater than zero). These have a plan but no article.

J. Hatton Blog (posts articles with unscaled plans)
Available articles: 1113/1230 = 90.5%

==================================================

Section 4. Article Audit (All 4 Sources)

Spreadsheet Instructions: Clear filters. Filter column K for light Green to get the number. Clear filters.
Articles Captured: 1201/1230 = 97.6%
==================================================

Section 5. Plan Grades

Spreadsheet Instructions: Clear filters. Filter column L for Desired Grade the number. Clear filters.

AA - 777/1230 = 63.2%
BB - 276/1230 = 22.4%
CC - 94/1230 = 7.6%
DD - 13/1230 = 1.1%
XX - 41/1230 = 3.3% (not flight plans)
(blank) - 29/1230 = 2.4% (missing plans)

==================================================

References (the 5 sources tracked in this database):
Outerzone RCM Entries: http://outerzone.co.uk/advanced/list...ans_number.asp
Don Dewey Memorial Radio Control Modeler Plans Collection: https://www.rcgroups.com/forums/show...ans-Collection
"RCM Plans FREE!!!!" Thread: https://www.rcgroups.com/forums/show....php?t=2233857
Elijah's (hlsat) Blog: https://www.rcgroups.com/forums/show....php?t=2354459
J. Hatton Blog: http://pulling-gz.blogspot.com/?view=sidebar


Read-only link to my cloud-based repository
https://1drv.ms/f/s!AhJ_mZ04GPZNg5BQee62am2zGc8spA
Last edited by davidterrell80; May 27, 2018 at 02:00 PM.
May 27, 2018, 02:18 PM
AMA 986339 FCC KB5LAM/4
davidterrell80's Avatar
Thread OP

Update of the RCM Plans Thread Index -- 27 MAY 2018


Update of the RCM Plans Thread Index -- 27 MAY 2018

NOTES:
1. Zip contains the spreadsheet, with version set at 20
2. Continuing work on the "Dewey Collection"


Statistics:

==================================================

Section 1: Combined Count of Unique Plans, giving precedence to Outerzone, Don Dewey Memorial Plan Collection, & RCM Plans Free threads


Spreadsheet instructions: Check Filters are cleared. Filter column D by the appropriate color. Look to the status row at the Bottom-Left for the numbers. Clear filters after checking each color. "Total Scaled" and the various percentages are manual calculations.

Scaled Plans:
ORANGE (OZ): 934/1233 = 75.7%
Blue (Don Dewey Collection): 224/1233 = 18.2%
Dark GREEN (RCM Plans Thread): 46/1233 = 0.4%
Sand BROWN (Elijah's blog): 0/1233 = 0.9% (Note: all of Elijah's Plans are now superseded by the "Dewey Collection".
Total scaled: 1194/1233 = 96.8%
Uncaptured
WHITE: 29/1233 = 2.4%
==================================================

Section 2: Separate count of plans in the Dewey Collection, "RCM Plans Free" and hlsat threads.

Spreadsheet Instructions: Check Filters are cleared. Get the Dewey collection number by filtering column E for blue. Clear Filters. Get the RCM Thread number by filtering column F for Green. Clear filters. Get the Elijah thread number by filtering column H for sand-brown. Clear filters.
Dewey Collection
Scaled: 1080/1233 = 87.6%

RCM Plans Thread
Scaled: 1023/1233 = 83.0%

Elijah's blog (posts scaled plans only, but does not keep current versions)
Scaled: 1129/1233 = 91.6%
==================================================

Section 3. Other Sources

Spreadsheet Instructions: Check Filters are cleared. Filter column I (India) for Blue to get the number. Clear filters.
Note: a few cells are uncolored but contain a value (filter blue AND content greater than zero). These have a plan but no article.

J. Hatton Blog (posts articles with unscaled plans)
Available articles: 1113/1233 = 90.3%

==================================================

Section 4. Article Audit (All 4 Sources)

Spreadsheet Instructions: Clear filters. Filter column K for light Green to get the number. Clear filters.
Articles Captured: 1205/1233 = 97.7%
==================================================

Section 5. Plan Grades

Spreadsheet Instructions: Clear filters. Filter column L for Desired Grade the number. Clear filters.

AA - 779/1233 = 63.2%
BB - 275/1233 = 22.3%
CC - 93/1233 = 7.5%
DD - 13/1233 = 1.1%
XX - 44/1233 = 3.6% (not flight plans)
(blank) - 29/1233 = 2.4% (missing plans)

==================================================

References (the 5 sources tracked in this database):
Outerzone RCM Entries: http://outerzone.co.uk/advanced/list...ans_number.asp
Don Dewey Memorial Radio Control Modeler Plans Collection: https://www.rcgroups.com/forums/show...ans-Collection
"RCM Plans FREE!!!!" Thread: https://www.rcgroups.com/forums/show....php?t=2233857
Elijah's (hlsat) Blog: https://www.rcgroups.com/forums/show....php?t=2354459
J. Hatton Blog: http://pulling-gz.blogspot.com/?view=sidebar


Read-only link to my cloud-based repository
https://1drv.ms/f/s!AhJ_mZ04GPZNg5BQee62am2zGc8spA
Last edited by davidterrell80; Jul 13, 2018 at 06:12 PM.
Jul 13, 2018, 06:26 PM
AMA 986339 FCC KB5LAM/4
davidterrell80's Avatar
Thread OP
Update of the RCM Plans Thread Index -- 13 JULY 2018

NOTES:
1. Zip contains the spreadsheet, with version set at 21
2. Continuing work on the "Dewey Collection"


Statistics:

==================================================

Section 1: Combined Count of Unique Plans, giving precedence to Outerzone, Don Dewey Memorial Plan Collection, & RCM Plans Free threads


Spreadsheet instructions: Check Filters are cleared. Filter column D by the appropriate color. Look to the status row at the Bottom-Left for the numbers. Clear filters after checking each color. "Total Scaled" and the various percentages are manual calculations.

Scaled Plans:
ORANGE (OZ): 940/1233 = 76.2%
Blue (Don Dewey Collection): 252/1233 = 20.4%
Dark GREEN (RCM Plans Thread): 12/1233 = 0.1%
Sand BROWN (Elijah's blog): 0/1233 = 0.0% (Note: all of Elijah's Plans are now superseded by the "Dewey Collection".
Total scaled: 1204/1233 = 97.6%
Uncaptured
WHITE: 29/1233 = 2.4%
==================================================

Section 2: Separate count of plans in the Dewey Collection, "RCM Plans Free" and hlsat threads.

Spreadsheet Instructions: Check Filters are cleared. Get the Dewey collection number by filtering column E for blue. Clear Filters. Get the RCM Thread number by filtering column F for Green. Clear filters. Get the Elijah thread number by filtering column H for sand-brown. Clear filters.
Dewey Collection
Scaled: 1165/1233 = 94.5%

RCM Plans Thread
Scaled: 1023/1233 = 83.0%

Elijah's blog (posts scaled plans only, but does not keep current versions)
Scaled: 1129/1233 = 91.6%
==================================================

Section 3. Other Sources

Spreadsheet Instructions: Check Filters are cleared. Filter column I (India) for Blue to get the number. Clear filters.
Note: a few cells are uncolored but contain a value (filter blue AND content greater than zero). These have a plan but no article.

J. Hatton Blog (posts articles with unscaled plans)
Available articles: 1113/1233 = 90.3%

==================================================

Section 4. Article Audit (All 4 Sources)

Spreadsheet Instructions: Clear filters. Filter column K for light Green to get the number. Clear filters.
Articles Captured: 1205/1233 = 97.7%
==================================================

Section 5. Plan Grades

Spreadsheet Instructions: Clear filters. Filter column L for Desired Grade the number. Clear filters.

AA - 780/1233 = 63.3%
BB - 274/1233 = 22.2%
CC - 92/1233 = 7.5%
DD - 12/1233 = 1.0%
XX - 44/1233 = 3.6% (not flight plans)
(blank) - 29/1233 = 2.4% (missing plans - including 26 "Hobby House" planes from the early days, not published in the magazine but sold by the Plans Service))

==================================================

References (the 5 sources tracked in this database):
Outerzone RCM Entries: http://outerzone.co.uk/advanced/list...ans_number.asp
Don Dewey Memorial Radio Control Modeler Plans Collection: https://www.rcgroups.com/forums/show...ans-Collection
"RCM Plans FREE!!!!" Thread: https://www.rcgroups.com/forums/show....php?t=2233857
Elijah's (hlsat) Blog: https://www.rcgroups.com/forums/show....php?t=2354459
J. Hatton Blog: http://pulling-gz.blogspot.com/?view=sidebar


Read-only link to my cloud-based repository
https://1drv.ms/f/s!AhJ_mZ04GPZNg5BQee62am2zGc8spA
Latest blog entry: RCM Magazine Covers
Jul 31, 2018, 08:06 PM
AMA 986339 FCC KB5LAM/4
davidterrell80's Avatar
Thread OP

Update of the RCM Plans Thread Index -- 31 JULY 2018


Update of the Don Dewey Memorial RCM Plans Index -- 31 JULY 2018

NOTES:
1. Zip contains the spreadsheet, with version set at 22
2. Another Item located, the Royal Coachman Revisited. Total count stands at 1,234 items.
3. Finished Phase One of the "Dewey Collection"
4. I am transferring the posting of my spreadsheet from the "RCM Plans Free!!!!" thread to the "Dewey Collection" Thread. I will keep the copy in Post #1 of that thread.


Statistics:

==================================================

Section 1: Combined Count of Unique Plans, giving precedence to Outerzone, Don Dewey Memorial Plan Collection, & RCM Plans Free threads


Spreadsheet instructions: Check Filters are cleared. Filter column D by the appropriate color. Look to the status row at the Bottom-Left for the numbers. Clear filters after checking each color. "Total Scaled" and the various percentages are manual calculations.

Scaled Plans:
ORANGE (OZ): 943/1234 = 76.4%
Blue (Don Dewey Collection): 263/1234 = 21.3%
Dark GREEN (RCM Plans Thread): 0/1234 = 0.0% (Note: all of RCM Plans Thread plans are now superseded by the "Dewey Collection".)
Sand BROWN (Elijah's blog): 0/1234 = 0.0% (Note: all of Elijah's Plans are now superseded by the "Dewey Collection".)
Total scaled: 1206/1234 = 97.7%
Uncaptured
WHITE: 28/1234 = 2.3%
==================================================

Section 2: Separate count of plans in the Dewey Collection, "RCM Plans Free" and hlsat threads.

Spreadsheet Instructions: Check Filters are cleared. Get the Dewey collection number by filtering column E for blue. Clear Filters. Get the RCM Thread number by filtering column F for Green. Clear filters. Get the Elijah thread number by filtering column H for sand-brown. Clear filters.
Dewey Collection
Scaled: 1206/1234 = 97.7%

RCM Plans Thread
Scaled: 1024/1234 = 83.0%

Elijah's blog (posts scaled plans only, but does not keep current versions)
Scaled: 1129/1234 = 91.5%
==================================================

Section 3. Other Sources

Spreadsheet Instructions: Check Filters are cleared. Filter column I (India) for Blue to get the number. Clear filters.
Note: a few cells are uncolored but contain a value (filter blue AND content greater than zero). These have a plan but no article.

J. Hatton Blog (posts articles with unscaled plans)
Available articles: 1113/1234 = 90.2%

==================================================

Section 4. Article Audit (All 4 Sources)

Spreadsheet Instructions: Clear filters. Filter column K for light Green to get the number. Clear filters.
Articles Captured: 1206/1234 = 97.7%
==================================================

Section 5. Plan Grades

Spreadsheet Instructions: Clear filters. Filter column L for Desired Grade the number. Clear filters.

AA - 781/1234 = 63.3%
BB - 275/1234 = 22.3%
CC - 91/1234 = 7.4%
DD - 14/1234 = 1.1%
XX - 44/1234 = 3.6% (not flight plans)
ZZ - 3/1234 = 0.2% (missing plans that were published in the magazine)
(blank) - 26/1234 = 2.1% (missing plans from the "Hobby House" Plans Service, from the early days, not published in the magazine but sold by the Plans Service in the early to mid 1960s))

==================================================

References (the 5 sources tracked in this database):
Outerzone RCM Entries: http://outerzone.co.uk/advanced/list...ans_number.asp
Don Dewey Memorial Radio Control Modeler Plans Collection: https://www.rcgroups.com/forums/show...ans-Collection

"RCM Plans FREE!!!!" Thread: https://www.rcgroups.com/forums/show....php?t=2233857
Elijah's (hlsat) Blog: https://www.rcgroups.com/forums/show....php?t=2354459
J. Hatton Blog: http://pulling-gz.blogspot.com/?view=sidebar


Read-only link to my cloud-based repository
https://1drv.ms/f/s!AhJ_mZ04GPZNg5BQee62am2zGc8spA
Latest blog entry: RCM Magazine Covers
Aug 05, 2018, 05:23 PM
AMA 986339 FCC KB5LAM/4
davidterrell80's Avatar
Thread OP

Setting up for the Future


Update of the Don Dewey Memorial RCM Plans Index -- 31 JULY 2018

NOTES:
1. Zip contains the spreadsheet, with version set at 22
2. I will stop active tracking of Elijah's Blog.
3. i will continue to track the "RCM Plans Free" thread, but will lower it's significance in my reporting..


Statistics:

==================================================

Section 1: Combined Count of Unique Plans in Outerzone and the Don Dewey Memorial Plan Collection


Spreadsheet instructions: Check Filters are cleared. Filter column D by the appropriate color. Look to the status row at the Bottom-Left for the numbers. Clear filters after checking each color. "Total Scaled" and the various percentages are manual calculations.

Scaled Plans:
ORANGE (OZ): 943/1234 = 76.4%
Blue (Don Dewey Collection): 263/1234 = 21.3%
Total scaled: 1206/1234 = 97.7%
Uncaptured
WHITE: 28/1234 = 2.3%
==================================================

Section 2: Separate count of plans in the Dewey Collection, "RCM Plans Free" and hlsat threads.

Spreadsheet Instructions: Check Filters are cleared. Get the Dewey collection number by filtering column E for blue. Clear Filters. Get the RCM Thread number by filtering column F for Green. Clear filters. Get the Elijah thread number by filtering column H for sand-brown. Clear filters.
Dewey Collection
Scaled: 1206/1234 = 97.7%

RCM Plans Thread
Scaled: 1024/1234 = 83.0%

Elijah's blog (posts scaled plans only, but does not keep current versions)
Scaled: 1129/1234 = 91.5%
==================================================

Section 3. Other Sources

Spreadsheet Instructions: Check Filters are cleared. Filter column I (India) for Blue to get the number. Clear filters.
Note: a few cells are uncolored but contain a value (filter blue AND content greater than zero). These have a plan but no article.

J. Hatton Blog (posts articles with unscaled plans)
Available articles: 1113/1234 = 90.2%

==================================================

Section 4. Article Audit (All 4 Sources)

Spreadsheet Instructions: Clear filters. Filter column K for light Green to get the number. Clear filters.
Articles Captured: 1206/1234 = 97.7%
==================================================

Section 5. Plan Grades

Spreadsheet Instructions: Clear filters. Filter column L for Desired Grade the number. Clear filters.

AA - 781/1234 = 63.3%
BB - 275/1234 = 22.3%
CC - 91/1234 = 7.4%
DD - 14/1234 = 1.1%
XX - 44/1234 = 3.6% (not flight plans)
ZZ - 3/1234 = 0.2% (missing plans that were published in the magazine)
(blank) - 26/1234 = 2.1% (missing plans from the "Hobby House" Plans Service, from the early days, not published in the magazine but sold by the Plans Service in the early to mid 1960s))

==================================================

References (the 5 sources tracked in this database):
Outerzone RCM Entries: http://outerzone.co.uk/advanced/list...ans_number.asp
Don Dewey Memorial Radio Control Modeler Plans Collection: https://www.rcgroups.com/forums/show...ans-Collection

"RCM Plans FREE!!!!" Thread: https://www.rcgroups.com/forums/show....php?t=2233857
Elijah's (hlsat) Blog: https://www.rcgroups.com/forums/show....php?t=2354459
J. Hatton Blog: http://pulling-gz.blogspot.com/?view=sidebar


Read-only link to my cloud-based repository
https://1drv.ms/f/s!AhJ_mZ04GPZNg5BQee62am2zGc8spA
Latest blog entry: RCM Magazine Covers
Sep 30, 2018, 08:57 PM
AMA 986339 FCC KB5LAM/4
davidterrell80's Avatar
Thread OP

Update of the Don Dewey Memorial RCM Plans Index -- 30 SEP 2018


Update of the Don Dewey Memorial RCM Plans Index -- 30 SEP 2018

NOTES:
1. Zip contains the spreadsheet, with version set at 23. I will post a second copy in the first post.


Statistics:

==================================================

Section 1: Combined Count of Unique Plans in Outerzone and the Don Dewey Memorial Plan Collection


Spreadsheet instructions: Check Filters are cleared. Filter column D by the appropriate color. Look to the status row at the Bottom-Left for the numbers. Clear filters after checking each color. "Total Scaled" and the various percentages are manual calculations.

Scaled Plans:
ORANGE (OZ): 948/1234 = 76.8%
Blue (Don Dewey Collection): 258/1234 = 20.9%
Total scaled: 1206/1234 = 97.7%
Uncaptured
WHITE: 28/1234 = 2.3%
==================================================

Section 2: Separate count of plans in the Dewey Collection, "RCM Plans Free" and hlsat threads.

Spreadsheet Instructions: Check Filters are cleared. Get the Dewey collection number by filtering column E for blue. Clear Filters. Get the RCM Thread number by filtering column F for Green. Clear filters. Get the Elijah thread number by filtering column H for sand-brown. Clear filters.
Dewey Collection
Scaled: 1206/1234 = 97.7%

RCM Plans Thread
Scaled: 1024/1234 = 83.0%

Elijah's blog (posts scaled plans only, but does not keep current versions)
Scaled: 1129/1234 = 91.5%
==================================================

Section 3. Other Sources

Spreadsheet Instructions: Check Filters are cleared. Filter column I (India) for Blue to get the number. Clear filters.
Note: a few cells are uncolored but contain a value (filter blue AND content greater than zero). These have a plan but no article.

J. Hatton Blog (posts articles with unscaled plans)
Available articles: 1113/1234 = 90.2%

==================================================

Section 4. Article Audit (All 4 Sources)

Spreadsheet Instructions: Clear filters. Filter column K for light Green to get the number. Clear filters.
Articles Captured: 1206/1234 = 97.7%
==================================================

Section 5. Plan Grades

Spreadsheet Instructions: Clear filters. Filter column L for Desired Grade the number. Clear filters.

AA - 782/1234 = 63.4%
BB - 274/1234 = 22.2%
CC - 91/1234 = 7.4%
DD - 14/1234 = 1.1%
XX - 44/1234 = 3.6% (not flight plans)
ZZ - 3/1234 = 0.2% (missing plans that were published in the magazine)
(blank) - 26/1234 = 2.1% (missing plans from the "Hobby House" Plans Service, from the early days, not published in the magazine but sold by the Plans Service in the early to mid 1960s))

==================================================

References (the 5 sources tracked in this database):
Outerzone RCM Entries: http://outerzone.co.uk/advanced/list...ans_number.asp
Don Dewey Memorial Radio Control Modeler Plans Collection: https://www.rcgroups.com/forums/show...ans-Collection

"RCM Plans FREE!!!!" Thread: https://www.rcgroups.com/forums/show....php?t=2233857
Elijah's (hlsat) Blog: https://www.rcgroups.com/forums/show....php?t=2354459
J. Hatton Blog: http://pulling-gz.blogspot.com/?view=sidebar


Read-only link to my cloud-based repository
https://1drv.ms/f/s!AhJ_mZ04GPZNg5BQee62am2zGc8spA
Last edited by davidterrell80; Jul 12, 2019 at 05:28 PM.
Jul 12, 2019, 05:40 PM
AMA 986339 FCC KB5LAM/4
davidterrell80's Avatar
Thread OP
Update of the Don Dewey Memorial RCM Plans Index -- 12 JUN 2019

NOTES:
1. Zip contains the spreadsheet, with version set at 26. I will post a second copy in the first post.
2. I am no longer tracking the counts in the "RCM Plans Free" and the hlsat threads.
3. Eliminated Article Audit


Statistics:

==================================================

Section 1: Combined Count of Unique Plans in Outerzone and the Don Dewey Memorial Plan Collection


Spreadsheet instructions: Check Filters are cleared. Filter column D by the appropriate color. Look to the status row at the Bottom-Left for the numbers. Clear filters after checking each color. "Total Scaled" and the various percentages are manual calculations.

Scaled Plans:
ORANGE (OZ): 972/1234 = 78.8%
Blue (Don Dewey Collection): 234/1234 = 20.0%
Total scaled: 1206/1234 = 97.7%
Uncaptured
WHITE: 28/1234 = 2.3%
==================================================

Section 2: Separate count of plans in the Dewey Collection thread.

Spreadsheet Instructions: Check Filters are cleared. Get the Dewey collection number by filtering column E for blue. Clear Filters.
Dewey Collection
Scaled: 1206/1234 = 97.7%
==================================================

Section 3. Other Sources

Spreadsheet Instructions: Check Filters are cleared. Filter column H for Blue to get the number. Clear filters.
Note: a few cells are uncolored but contain a value (filter blue AND content greater than zero). These have a plan but no article.

J. Hatton Blog (posts articles with unscaled plans)
Available articles: 1120/1234 = 90.8%

==================================================

Section 4. Plan Grades

Spreadsheet Instructions: Clear filters. Filter column K for Desired Grade the number. Clear filters.

AA - 799/1234 = 64.7%
BB - 265/1234 = 21.5%
CC - 84/1234 = 6.8%
DD - 13/1234 = 1.1%
XX - 44/1234 = 3.6% (not flight plans)
ZZ - 3/1234 = 0.2% (missing plans that were published in the magazine)
(blank) - 26/1234 = 2.1% (missing plans from the "Hobby House" Plans Service, from the early days, not published in the magazine but sold by the Plans Service in the early to mid 1960s))

==================================================

References (the 3 sources tracked in this database):
Outerzone RCM Entries: http://outerzone.co.uk/advanced/list...ans_number.asp
Don Dewey Memorial Radio Control Modeler Plans Collection: https://www.rcgroups.com/forums/show...ans-Collection

J. Hatton Blog: http://pulling-gz.blogspot.com/?view=sidebar


Read-only link to my cloud-based repository
https://1drv.ms/f/s!AhJ_mZ04GPZNg5BQee62am2zGc8spA
Latest blog entry: RCM Magazine Covers


Quick Reply
Message:
Thread Tools

Similar Threads
Category Thread Thread Starter Forum Replies Last Post
Gallery RCM Basic Trainer 1/2a (RCM Plan from 1978) mukaghigonetto 1/2A Planes 4 Nov 23, 2015 08:48 PM