Electronic Resources - YouTube - Websites

[ez24]

List A  -  Educational and Selected Youtube Resources

See List B for Entertainment, Repair, Teardowns, and Misc

Special thanks to Brumby, and Cliff Matthews both of whom made these lists possible 

List A
===================================================================

YouTube Name	General	Number	Additional Info
+ URL link	Content	Subs
		1,000s
-----------------	----------	-------	------------------------------------------
A2C Arts And Crafts	Misc	336	Interesting projects with DC motors
AddOhms	Tutorials	76	Electronics tutorials in plain simple english
Afrotechmods	Tutorials	383	Straight to the point electronics tutorial videos with practical examples
Akira Tsukamoto	Misc	1	Multimeters, Digital Circuit and etc
Andreas Spiess	Misc	59	Small electronic projects , tutorials, and reviews
Applied Science	Misc	414	Applications of science and technology.
Arrow Electronics	Misc	5	Source of inspiration, education and entertainment for electronic
Ben Eater	Misc	111	Tutorial-style videos about electronics, computers, networking
Bob Kalpon	Misc	20	This is electronics... we don't work. We just enjoy with it!
Bruce Land	MCU	27	University courses (good)
CodeNMore	Tutorial	37	Electronics tutorials
Cody A Jones	Tutorial	2	Your place for all of your electronic questions!
Craig Hollinger	MCU	2	Video tutorials on how to build microcontroller projects
CuriousInventor	Misc	32	Concise explanations of technical topics
Darryl Morrell	Tutorial	38	Signals and systems, circuit analysis, and mechanics.
David Watts	Arduino	17	Arduino platform, Raspberry Pi, electronics and 3D Printing
David Williams	Tutorial	21	Electronic and electrical circuit theory tutorials and examples
Design World	Misc	15	Technical how-to's, current engineering trends and product releases.
Digilent, Inc.	Tutorial	10	Educational videos
DIY Perks	Misc	1100	DIY projects on electronics, audio, and more!
Doc Schuster	Tutorial	100	Physics teachers at Webster Groves High School in St. Louis, MO.
Dorian McIntire	Tutorial	16	Tutorial
Dr. Montgomery	Tutorial	4	Tutorial
DrMattMarshall	Tutorial	1	Tutorial
Drone Mesh	Drones	8	Drone Reviews and Mods.
EcProjects	Misc	41	DIY projects, repairs, ideas and more
educ8s.tv	Arduino	55	Arduino, Raspberry Pi or with ESP8266
EEEnthusiast	Arduino	24	Arduino, Raspberry Pi, Launchpad and other electrical topics
EEVblog	King	534	gear mailbag education repair teardown
EEVblog2	King 2	55	The other center
ElectroBOOM	Fun	1300	Craziness in engineering!
electronicsNmore	Misc	162	A channel primarily devoted to electronics
Electronoobs	Misc	28	Tutorials on basic circuits , lights , lasers, arduino and much more.
electronzapdotcom	Misc	3	Videos to help those that are interested in learning electronics
Eric Wasatonic	Teardowns	7	Misc
Evione Group	Misc	3	Misc
FFcossag	Misc	13	Misc
Fran Blanche	Misc	26	Fran is a pedal designer, engineer, artist, musician
Gadget Review Videos	Misc	NA	Gadget tech electronics 3D Printers and more
GadgetUK164	Repair	11	Game repairs
Garage Geek Guy	Misc	7	A site for electronics hobbyists
GreatScott!	Misc	724	Electronics Tutorials, Projects and How To´s
Hafeez KT	Tutorials	4	Misc
humanHardDrive	Misc	40	Electronics, microcontrollers, math, or programming
iFixit Video	Misc	379	In-depth video repair guides
Jenko022	Tutorials	2	Electronics and Computer Tutorials
Jeremy Blum	Misc	159	Engineering, technology, and science
Jeri Ellsworth	Misc	95	Jeri Ellsworth documents her amateur science experiments
Jim Lindenas	Radio	6	Vintage radio repair
Jim Pytel	Misc	12	Basic electronics, hydraulics, electrical machines, control electronics
joe smith	Multimeters	6	Mainly multimeter testing
Joel Gegner	Tutorials	2	Misc
John Santiago	Misc	8	A series of engineering topics and tutorials
Julian Ilett	Misc	136	Cheapest electronic modules and components
K Temkin	Tutorials	2	Tutorial
KainkaLabs	Misc	3	A well-known electronics-autthor and kit-maker in Germany
Kasyan TV	Misc	22	Misc
Kathy Loves Physics	History	1	Good history
katkimshow	Tutorial	33	Tutorial
Kevin Darrah	Misc	77	Just a fellow hobbyist giving his two cents
Keysight Oscilloscopes	Oscilloscope	24	Oscilloscope
Khan Academy	Tutorials	3800	Educational videos
kipkay	Misc	2621	Pranks and how-to videos in the world!
Learn Engineering	Misc	1400	Misc
learnelectronics	Misc	10	Electronics projects, tutorials, teardowns, and reviews.
LinearTechnology	Tutorial	NA	Linear Technology Corporation
Made 2 Hack	Misc	1	Giving back and contributing to the strong DIY
Mateo Aboy	Tutorials	NA	Digital signal processing, communications, programming
MickMake	Arduino	25	Arduino
misperry	Misc	10	For makers, inventors, beginners, professionals
MKme Lab	Misc	39	Technology, Inventions, Innovations, Arduino, Pi, Drones, 3D Printing
Mr. Delphi	Misc	7	Misc
NatureAndTech	Misc	2	Misc
NFM	Misc	6	Videos about electronics and other nifty gear
Onstate LED Lighting	Misc	1	LED lighting products, parts and electronics
paceworldwide	Repair	17	Mostly soldering
Patrick Hood-Daniel	MCU	57	A wealth of videos dedicated to helping hobbyists
Peter Oakes	Misc	24	Tutorials, Reviews and general blogs
Professor Curtis Meyer	Tutorials	1	Tutorial
Programming Elect…	Arduino	65	Series of Arduino tutorials
PyroElectro	Tutorial	23	Showing the world how to make their own electronix
Quantum Leaps, LLC	Embedded	20	Learn modern embedded systems programming the right way
Ralph S Bacon	Arduino	8	Arduino compatibles and other electronics for beginners!
RimstarOrg	Misc	162	Science, electronics, making stuff
Robert Paz	Arduino	16	University arduino tutorials
Robledo Einstein	Misc	1	Sharing my experiments and drone footages
Robot Brigade	Misc	14	All about making things!
rolinychupetin	Tutorials	30	Misc
RSD Academy	Tutorials	3	Electronics, computer and fiber optic technology
Scott Mon	Arduino	1	Arduino
Scullcom Hobby..	Misc	17	Projects for the hobbyist and tutorials
ShellWaveX	Tutorial	11	FPGA, Verilog, and Electronics, as well as Math and Digitals.
Simply Electronics	Misc	44	Inspire, Educate and Entertain
SmarterEveryDay	Misc	5700	Very popular channel
stiquitojmconrad	Tutorial	10	Embedded university tutorials
svsembedded	Tutorial	18	Special !  But hard to understand  ?
Tampatec	Repair	336	How to install & Fix it Tech channel
Tech Explorations	Misc	8	Video tutorials on Arduino hacking
TechnologyCatalyst	Misc	6	Tutorials, experiments, investigations, mythbusting, reviews
Tektronix	Misc	7	Mostly on Tektronix equipment
Texas Instruments	Misc	37	Texas Instruments YouTube channel
The Engineering Mindset	Tutorial	38	Tutorials
The Offset Volt	Tutorial	3	This channel is geared to those new to electronics
The Post Apocalyptic	Misc	272	Channel mainly focused on electrical and mechanical engineering
The Radio Shop	Radio	8	Gear mailbag repair ham
The White Byte	Misc	2	Electronics, microcontrollers, programming, technology
TheDefpom	Misc	1	Pretty much anything that needs fixing, not just electronics
Timothy Schulz	Tutorials	4	Electrical engineering and math tutorials
tomtektest	Misc	2	Misc
VoltLog	Misc	7	Electronics video blog
w2aew	Misc	81	http://www.qsl.net/w2aew//youtube/W2AEW_video_index.pdf
Zahi Haddad	Tutorial	17	Tutorials

   List A   

=====================================================================
Updated: July 27, 2018

Footnotes:

To be on List A there must be a Playlist. 

Original idea and list by Cliff Matthews, spreadsheet and technical help by Brumby

For history see original list:  https://www.eevblog.com/forum/other-blog-specific/dd/msg1093983/#msg1093983

The beginning: https://www.eevblog.com/forum/beginners/electronics-primers-course-material-and-books/msg1093036/#msg1093036

If I am unable to maintain this list, fanOfeeDIY, is willing to take it over.

[ez24]

List B  -  Entertainment, Repair, Teardowns, and Misc

See List A for Educational and Selected Youtube Resources

Special thanks to Brumby, and Cliff Matthews both of whom made these lists possible 

List B
=======================================================================

YouTube Name	General	Number	Additional Info
+ URL link	Content	Subs
		1,000s
-----------------	----------	-------	------------------------------------------
0033mer	Misc	1	Focus on embedded platforms
AA Computers	Computer	22	In-depth reviews, interesting experiments, easy to follow how to's
Adafruit	Misc	237	Adafruit store
Anamorphic Square	Misc	2	Teaching basic electronics and video production
Andrew Paul	Misc	8	Troubleshooting and repair of electronics
AvE	Misc	702	Misc
bigclivedotcom	Misc	265	The trashiest electronic channel on YouTube
bitluni's lab	Misc	40	Elaborate and funny tutorial videos
Bootstrap Workbench	Misc	1	Repairing and rejuvenating old test equipment
Brek Martin	Misc	1	Electronics, Programming, Radio, and Vintage/Retro Electronics
Brian Lough	Arduino	3	Videos on projects and libraries, mainly with ESP8266
Chris Ball	Make	2	Make electronics experiments
Connor Wolf	Teardowns	8	Electronics teardowns and EE-related waffling
CuriousMarc	Misc	10	Repairs old mainframe stuff
Dalibor Farný	Nixie Tube	11	Vacuum tube stuff - A nixie tube maker
devttys0	Misc	6	Adventures in learning and designing analog electronics!
DextersLab2013	Misc	5	Electronics, teardowns, geiger counters and fixing things
DiodeGoneWild	Misc	26	Misc
Dr. Fayçal Saffih	Tutorial	1	Tutorial
EdisonTechCenter	Misc	37	Engineering Videos, History, Present, and Future Technologies
Edx	Tutorials	114	Online learning destination and MOOC provider
EHobby Guy	Misc	1	Everything Hobby Electronics
Electrical Projects	Misc	5	DIY Projects with Microcontrollers, High voltage and much more
electronhacks	Misc	24	Electronic and tech hacks, projects, DIY, how to, and tutorials
Electronics repair school	Repair	12	Repair and maintenance of electronic systems and equipment
ElectronicsLearning	Misc	2	This is a channel to help you learn about electronics
ElectronicsNotes	Misc	2	Know-how & experience for electronics & radio enthusiasts & students
electronupdate	Misc	13	Review of electronic test and measurement equipment
ElPaso TubeAmps	Misc	9	Misc
ENGR 313	Tutorial	1	Tutorial
glasslinger	Vintage	8	Vacuum tube making
Grants Pass TV	TV	21	Trying to understand the art of electronic troubleshooting
HBPowerwall	18650	30	18650
Hill's Workbench	Misc	1	Features DIY projects, repairs, electronics, and other content
Iain Portalupi	Misc	4	If you like electronics you came to the right place.
Ing. Max Koschuh	Misc	2	Misc
iPad Rehab	Repair	51	Fixing Apple stuff, mostly
Jan Beta	Misc	3	Repair/hack/make/destroy stuff on camera.
Jericho Uno	Misc	2	My channel is about making stuff.
jersagfast	Misc	31	Snippets from my website, a lot about electronics
Jim Conner	Misc	7	Electronics, Hydroponics, Woodworking, Projects, Hacks, Teardowns
John Gammell	Soldering	14	Misc
Joop Brokking	Multicopter	32	A passion for rc model helicopters, multicopters and electronics
Julio Rodriguez	Misc	1	Intermediate Electronics Blob
Kaizer Power Electronics	High Volt	1	High voltage stuff
Kenneth Finnegan	Misc	4	Misc
Kerry Wong	Misc	3	Electronic Projects, teardowns and test equipment
kevtris	Misc	5	FPGA stuff, old console mods and stuff
Keystone Science	Misc	155	Amazing aspects of science and technology
knurlgnar24	Misc	44	Misc
Kristian_Laholm	Misc	1	Videos about Electronics
lasersaber	Misc	123	Misc
Lewis Loflin	Misc	13	Broad range of electronics and micro-controller projects
Louis Rossmann	Repair	312	Teaching electronics from a common sense perspective
Ludic Science	Misc	61	Find projets and experiments that explore the fun side of science!
Marco Reps	Misc	21	Electronics videos from northern Germany.
Michel van Biezen	Tutorials	202	Tutorials
mikeselectricstuff	Misc	87	High voltage, vintage electronics etc
MikesRadioRepair	Radio	6	Repairs and how to videos on everything from antique to modern
MrCarlsonsLab	Misc	84	Electronic "how to's,"  and random project descriptions
MrJohhhnnnyyy	Misc	3	Videos about my electronics projects, repair
MrTesla1337	Misc	1	Big tesla toys
msylvain59	Teardowns	4	French and English teardown videos
nTOOBEa	Misc	1	Mechanical and electronics projects
Open Green Energy	Misc	55	DIY projects on Energy Generation and Storage, Arduino , Quadcopters
OpenTechLab	Misc	3	A channel about Open Source technology.
orbiter8 (John)	Repair	3	Love dabbling with electronics and building/repairing circuits
patrickikis	Misc	16	Misc
Paul McGowan, Jr.	Pic	8	Misc
pcbreflux	Misc	5	Advanced ESP32 stuff
Pete Vree	Misc	7	Electronics, PLC's, pneumatic's and Arduino
Peter Brockie	Misc	2	Trying not to burn the place down with electronics projects.
Proto G	Misc	15	Prototyping, Projects, Experiments, Microcontrollers, random topics
radiofun232	Radio	6	Misc
Raiya Energy Academy	Tutorials	5	Free Review of FE/EIT Electrical and PE Power Exam.
randomtronic	Misc	2	Teardowns, reviews, builds, design, and destruction
Robert Murray-Smith	Misc	92	Energy, graphene, batteries and super capacitors.
ROBRENZ	Misc	14	Misc
rx8pilot	Misc	1	EEVBlog Keysight winner - Factory 400 builder
Sam Ben-Yaakov	Tutorials	5	Tutorial
SDG Electronics	Misc	7	For anyone interested in electronics, firmware and audio
SeanHodgins	Misc	7	I like building, creating, making.
ShopJimmy.com	TV	64	TV repair tips and TV part solutions for all LCD LED Plasma TVs
Simon Spiers	Scope	3	Oscilloscope repairs
Solid State Workshop	Tutorials	8	Videos by EE student at The College of New Jersey
SparkFun Electronics	Misc	102	Videos by the geeks at Spark Fun Electronics
Stan Gibilisco	Misc	14	Diverse technical topics, particularly electronics
State of Electronics	Misc	8	Dedicated to the discussion on electronics and where its going
Steel Wheels Down	Tutorials	9	Understand electronics without needing to know a lot of mathematics
Steven Casagrande	Misc	1	Electrical engineering video blog for professionals and enthusiasts
Student Companion SA	Pic	7	PIC Microcontroller Tutorials and Projects
subcooledheatpump	Misc	3	Power Electronics, Electric Vehicles, Refrigeration, Computers
SuperHouseTV	DIY	55	Arduino esp home automation
Tanner Tech	Misc	2	How to build different electronics projects
Techmoan	Misc	538	Consumer Tech - from a Tech Consumer
tgsoapbox	Misc	1	Test equipment teardown and repair
The Ben Heck Show	Misc	627	Step by step on all kinds of electronic projects
The Combat Engineer	18650	NA	18650
The Current Source	Misc	3	Lover of all things nerd
The Signal Path	Repair	44	Gear education repair teardown
Tinkering With Terrius	Misc	1	Adventures of a newbie electronics hobbyist
Upcycle Electronics	Misc	1	Jake of All Trades
vk2zay	Misc	9	Analog wizard
Wayne Holder	Misc	1	Misc
Yokogawa….	Misc	2	Industrial Automation and Test & Measurement markets

   List B   

=======================================================================
Updated:  July 27, 2018


Footnotes:

Original idea and list by Cliff Matthews, spreadsheet and technical help by Brumby

For history see original list:  https://www.eevblog.com/forum/other-blog-specific/dd/msg1093983/#msg1093983

The beginning: https://www.eevblog.com/forum/beginners/electronics-primers-course-material-and-books/msg1093036/#msg1093036

If I am unable to maintain this list, fanOfeeDIY, is willing to take it over.

[ez24]

List  C  -  Website and PDF resources (With an emphasis on learning and basics)

Most of this info came from a post started by Chasm in 2011
https://www.eevblog.com/forum/beginners/electronics-primers-course-material-and-books/msg28589/#msg28589

List C
=======================================================================

CONTENT	NAME + LINK
-----------------------------	----------------------------------------
$1000 Electronic Lab ideas	EEVBlog
73 Magazine	73 Magazine (Amateur Radio Today)
Aliexpress – Member recommended seller	MCIGICM
Aliexpress – Member recommended seller	vanxy
Aliexpress – Member recommended seller	Your Cee
Aliexpress – Member recommended seller	YUNYIDA
Analog – video and written material………………………………………………..	Digilentinc
Analog Circuit Topics	PlayHookey
Arduino – 10 ways to destroy	Rugged Circuits
Arduino – Univ level course	NYU
Audio	DiyAudio
Auto electronics	Autoshop
Auto electronics – Interesting PDF	Infineon
Autodesk Circuits……………………………………………………………………………	CircuitsIio
Basics – good resource	All About Circuits
Basics – good resource	Electronics Club
Book - AoE Chap 9 – sample chap from popular book	AoE
Book - Electronics from the Ground Up:	Amazon
Book - Make: Electronics…………………………………………………………………	Amazon
Book – Practical Electronics for Inventors	Amazon
Book – Practical Electronics for Inventors – Errata	Scherz
Books	Leanpub
Books – Used	AbeBooks
Books – Used	Alibris
Capacitor Codes	Synthrotek
Capacitors……………………………………………………………………………………….	ConradHoffman
Circuits	Discovercircuits
Connectors	IPC
Crimping Tool FYI	EEVBlog
Dave's website	AlternativeZone
DIY Stuff	Element 14
DIY Stuff………………………………………………………………………………………….	Instructables
Ebay seller – Forum member	Ebay
EE Design Forum	Eeweb
EEVBlog Wiki	EEVBlog
Electrical Engineering 101 – Amazon book	Ashby
Electronics primers, course material and books	EEVBlog
Epoxy Glues Video	Project Farm
Forum……………………………………………………………………………………………..	Edaboard
General resource	RadioElectronics [Good]
Grounds, electronic	AnalogVsdigitalGround
Hardware development	Hackaday
Hardware Projects	Electronics-Lab
History of electricity	Video
HP App notes--------------------------------------------------------	HP
Kathy Loves Physics	Kathylovesphysics
LCD Technology Tutorial	EEVBlog
Learning	Contextual electronics
Learning	Core-electronics
Learning	Coursera
Learning	Edx
Learning	ElectronicTutorials
Learning	Ibiblio
Learning	Khan
Learning	MIT EE degree
Learning	Radioamateur
Learning	RSDAcademy [current]
Learning	Sparkfun
Learning	TI  [Good]
Learning	TronClub [recommended]
Learning	Udemy
Learning	Williamson Labs
Learning -----------------------------------------------	NI
Learning – General search MOOC	MOOC
Learning………………………………………………………………………………………….	AocNrao [Worth taking a look at]
Learning………………………………………………………………………………………….	NEETS (Navy)
Links	WiseWartog
Links – Infinite number	Educypedia
Links to PDFs	Sencore
Links……………………………………………………………………………………………….	OpenCircuits
Magazines	AmericanRadioHistory
Maxwell's Equations	Maxwells-equations.com
MCU-AVR	Avrfreaks
MOSFETs vs Transistors	EEVBlog
Multimeter Selection Guide	EEVBlog
Navy – NEETS………………………………………………………………………………….	Hnsa
Online resources for self-education	EEVBlog
Op amp videos	EEVBlog
Op amps	TI
Optocoupler  PDF	Onsemi
Optocoupler Basics	Nutsvolts
Oscilloscope Selection Guide	EEVBlog
Oscilloscope YT Videos	EEVBlog
PCB – How to make………………………………………………………………………..	ElectricStuff
PCB Stuff	QuickTeck
PCB Stuff and Links	PCB UI
PDF – Analog Pocket Ref – 101 p	TI
PDF – Analog Seekrets – 588 p…………………………………………………………	Green  – hosted on EEVBlog
PDF – Book – 186 p	Atari [Good for beginners]
PDF – Electronic Devices and Circuit Theory – 934 p	Boylstead
PDF – Foundations – 1009 p	Agarwal  [Not for beginners]
PDF – Intro to Practical ….  - 1030p	Bill Collis
PDF – Linear regs – 31 p	TI
PDF – many ref books……………………………………………………………………..	Analog Devices
PDF – Op Amps – 130 p	Analog Devices
PDF – Op Amps – 26 p	Mims
PDF – Op Amps – 609 p	Siongboon
PDF – Oscilloscope – 16 p……………………………………………………….	Phys.ufl.edu
PDF – Oscilloscope – 8 p	Tektronix
PDF – RTD Tutorial – 55 p	Vree
PDF – Switching regulators – 12 p	Linear Tech
PDF – Transistors – 6 p	AmQRP
PDF on web page – 1030 p	Bill Collis
PIC tutorials…………………………………………………………………………………….	Gooligum
Popular Electronics magazine	AmericanRadioHistory
Radio and Electronics School	Res
Resistor Guide	ResistorGuide
Robotics	Hades
Schematic drawing (not design)	EEVBlog
Simulator – Online…………………………………………………………………………..	Falstad [Pretty cool]
Simulators – App based	EveryCircuit
Solar course	Stanford
Solder FYI	EEVBlog
Solder FYI	YT
Spice info	EcircuitCenter
Switch Mode PS – PDF – 73 p	Onsemi
Switching Power Supply	YouTube
Termistor tutorial	Sensorsci
Thermocouple  FYI	Lygte
Transistor Manual – PDF – 338 p…………………………………………………	GE
Transistor videos	EEVBlog

   List C   

=======================================================================
Updated:  July 27, 2018

[Shock]

Here is another decent channel just starting up, unlike many others he shows good signs of activity.

Artifact Electronics
https://www.youtube.com/channel/UCK5y1jaqmysO9WPszfr3BMQ/videos

[Shock]

Here is another decent channel just starting up, unlike many others he shows good signs of activity.

Artifact Electronics
https://www.youtube.com/channel/UCK5y1jaqmysO9WPszfr3BMQ/videos

They are already in the list.  Did you miss them because you only saw the M-Z list?  I have wondered if people will miss part of the list because it is split.

No I must have missed it unless you added them just in the last week, the channel came up as a recommended video while I was watching youtube. I think most intelligent people can see where the alphabet ends but if not you can always add in bold at the bottom "list continues in the next post" etc.

[tombi]

One more -

https://www.youtube.com/channel/UCftUpOO4h9EgH0eDOZtjzcA

Jan Beta 2k subs - Vintage computing, electronics repair

[imidis]

Keep up the good work! Techmoan is an excellent retro unusual technology channel - 500k subs.  https://www.youtube.com/user/Techmoan

[Brumby]

Testing.  Will be removed when checked out OK

A-L table:

Removed: Checked out OK.

[Brumby]

Testing.  Will be removed when checked out OK

M-Z table

Removed: Checked out OK.

[Brumby]

Do these ^^^^^^ look OK ?

[Brumby]

OK.  Have fun with this....

A couple of structural changes - but things should be pretty self-explanatory.


For anyone who is interested, I use a technique to pull out selected rows and create a list in a secondary location (another worksheet in this case) ... without any gaps.

Obsolete (and has a formula error) version of spreadsheet removed.

[Cerebus]

Thanks for all the work putting this together, it's appreciated.

[Brumby]

Hmmmm....

I am out at the moment - but I will have a look when I get home.

[Brumby]

Had a light bulb moment as I was walking up the drive.

Will check if it's what I think......

[Brumby]

Yep.   

Give me a few minutes...

[Brumby]

Hopefully this will fix it.

Rookie mistake.  I used the INDIRECT function to isolate the positions of the entries from the formatting ... except for the added tests I included for splitting the list.  Doh.

Just applied the same technique for the extra tests and it all looks good.

The rookie mistake wasn't the formula ... it was inadequate testing. 

<attachment removed - obsolete>

[Brumby]

Wondering why the numbers in the first columns in wk2 when there are none in wk1?

Simple.  wk1 and wk2 do different things - and they do them on all the data

Sheet wk1 is the same as it was in the previous spreadsheet.  It is used to preformat certain sections - and it does this for all the input data.
Sheet wk2 was the old "Forum Data" worksheet and uses the pre-formatted data from wk1, just as it did before. If you copy column "D" you will get the original, single list.  The addition of columns "A" and "B" were to enable the filtering required to split the list.  Column "C" is for future expansion.

The data only gets split when it reaches the two output worksheets.

[Brumby]

Rookie mistake.

  The spreadsheet is so complex no rookie could have made it.

As I said, the rookie mistake wasn't the formula ... it was inadequate testing.  That mistake applies to even a single cell formula.

[Cliff Matthews]

Roger, YouTuber Marco Reps would not mind having his member name baltersice added here. https://www.eevblog.com/forum/beginners/beginners-say-hello-to-ds212-($99-open-source-1mhz-stm32-color-pocket-scope)/msg1352515/#msg1352515

Interesting factoid dept:
His channel has rocketed to 35,000 subs (gaining over 100 new subs each day for the last 100). I wished him success and I hope he doesn't forget to chum-around on the forum now and then on his way to stardom.. With his camera, production and layout skills he could make so much more (so I guess he's a real electronics aficionado then..). IMHO, watching his video's is like watching the older Leslie Neilson comedies, you begin to notice things hidden in plain sight on the 2nd and 3rd viewing. It's definitely not something you'd expect from someone so gifted in our geeky electronics world.

Updated subs count again... this channel really seems to be catching air!

 *edit - subs now at 35k (still catching around 100 subs daily. Gee-whiz, this guy dosen't have to try..)

[transistor12]

Hard work & Nice effort. Thanks a lot.

[German_EE]

Please add:

The Radio Mechanic      Misc    5353 Subs    Lots of old test gear, teardowns plus the odd non-electronics item  https://www.youtube.com/channel/UCckddeQWd8Jefct3IP8xbRw

[Cliff Matthews]

Not sure if this is where I should post what I consider a YouTube hint, but here goes:

Q - This list is proof that really good creative electronics content exists, but what happens when we subscribe to too many?
A - YouTube sometimes makes decisions on what to show you, depending on what you watch and who shares your PC. 

For quick, date-ordered channel viewing, make this URL a frequent bookmark. (you must be signed-in to YT or Gmail)
https://www.youtube.com/feed/subscriptions?flow=grid&view=0&sort=dd

Leave results tab open, and right-click open video's in new tabs (so you have a static page to maintain viewing order). - Cheers!

[Cliff Matthews]

Something I never noticed that maybe we should update..? DiodeGoneWild is also the author of the very popular danyk.cz electronics site. http://danyk.cz/index_en.html Over the last few years, I cannot count the amount of visits I've made to this very informative site. I'm sure others will agree and if he's a member here, we should probably list his member name too. FWIW, not much time has passed since we listed him and the channel has risen to 26k subscribers. His reverse engineering descriptions are well done! (he must be a genuine DaveCAD Deluxe licensee..) 

[Cliff Matthews]

FWIW, Danyk.cz also has a YouTube channel (in his own native language) with at least 9-years of history. Eat your heart out Dave, this guy's a pile of fun! https://www.youtube.com/user/danyk666/videos

[faekjarz]

Mark Furneaux: https://www.youtube.com/user/TheUbuntuGuy/ AFAIK, he's an embedded designer / developer.