You can also add a dropdown for core material (CRGO, CRNGO, Amorphous) with associated Bmax values using Excel’s Data Validation.
: Dedicated modules can determine the overcurrent protection device ratings and calculate prospective short circuit current . transformer design calculation excel
| Row | Parameter | Excel Formula | Unit | | :--- | :--- | :--- | :--- | | | WINDOW CHECK | | | | 26 | Primary Wire Insul. Dia | =C22*1.1 | mm (Estimated with enamel) | | 27 | Secondary Wire Insul. Dia| =C23*1.1 | mm | | 28 | Primary Turns Layers | =ROUNDUP(C18/50,0) | (Assume 50 turns/layer est.) | | 29 | Total Window Area Req. | =(C18*C26^2 + C19*C27^2) | mm² | You can also add a dropdown for core