This is a typical table created by TransCalc. The EXCEL worksheet has input to change the number of users, the range on the KWH/month/user, and initial values. To determine the size of transformer to install, determine the number of consumers connected to the transformer (i.e. 16), then move across the KWH/month/user columns (i.e. 100) to find the size transformer. In this example a 10 KVA transformer would be selected. Note: You must enable macros to make this worksheet perform correctly.
To download this EXCEL worksheet, click here.