Potentially Helpful: Google Sheets based on Holt's Exam Prep Books

[paullmullen]

Hey all,

I've been studying for the Master Exam in Wisconsin, now scheduled for January. My way of studying involves trying to take the NEC and training materials and turn them into spreadsheets. It is my weird way of studying; it keeps me from reading without thinking.

It is based on the 2017 code since that's where Wisconsin is these days.

In any case, if others are interested, you can find the google sheets here: LINK

I am aware that others have attempted the same and I do not claim authority. Just sharing what I've been learning.

If you find errors/bugs, let me know. I claim no copyright. Feel free to use however you like so long as you use the code as the only authority.


Sources:

• NEC 2017
• NEC Handbook 2017
• Holt's Electrical Exam Prep
• Miller's Illustrated Guide to NEC

Errors in the spreadsheet are certainly mine, not from the source materials. Let me know where the document could be improved.

Paul

 

[infinity]

I took a quick look at the transformer tab the conductors sizes and the SBJ size are incorrect.

 

[cadpoint]

I could only see one page about colored boxes for a few disciplines, from the Link.

 

[paullmullen]

I took a quick look at the transformer tab the conductors sizes and the SBJ size are incorrect.

Cool... I'll take a look.

 

[paullmullen]

I could only see one page about colored boxes for a few disciplines, from the Link.

There are tabs at the bottom of the page to move from topic to topic.

 

[paullmullen]

Cool... I'll take a look.

 

[paullmullen]

OK. I see what's happening. The Blue boxes are user input. It looks like whoever was playing with the spreadsheet left it in a kind of unfinished state. Anyway, I updated the status there to be sensible, but another user could change it again. Just in case it messed with the link, I've reposted the link here.

 

[paullmullen]

Hey all,

I've been studying for the Master Exam in Wisconsin, now scheduled for January. My way of studying involves trying to take the NEC and training materials and turn them into spreadsheets. It is my weird way of studying; it keeps me from reading without thinking.

It is based on the 2017 code since that's where Wisconsin is these days.

In any case, if others are interested, you can find the google sheets here: LINK

I am aware that others have attempted the same and I do not claim authority. Just sharing what I've been learning.

If you find errors/bugs, let me know. I claim no copyright. Feel free to use however you like so long as you use the code as the only authority.


Sources:

• NEC 2017
• NEC Handbook 2017
• Holt's Electrical Exam Prep
• Miller's Illustrated Guide to NEC

Errors in the spreadsheet are certainly mine, not from the source materials. Let me know where the document could be improved.

Paul

Just a quick update. In case people miss it. Blue boxes are user input. Yellow boxes are automatically calculated but MAY need user override under certain circumstances.