Datasets
Open Access
Arc Flash IE and Iarc Calculators
- Citation Author(s):
- Submitted by:
- SA Dataport
- Last updated:
- Thu, 01/02/2020 - 09:36
- DOI:
- 10.21227/8gch-a963
- Data Format:
- License:
30408 Views- Categories:
- Keywords:
Abstract
The excel spreadsheet files provide access to a functional Arc Flash Calculator that includes various equipment configurations (VCB, VCBB, HCB, VOA and HOA), Incident Energy and voltage ranges.
As equipment’s configuration and input fields are presented, the user will be able to key entry specific data using the proper input fields and/or pull down menus provided. All variables and constants are defined. When all variables inputs have been entered, and proper equipment configuration has been selected, the Calculator will solve the equations and the answer is returned.
The Calculator function within the spreadsheets provide quick access to data analysis that could increase the productivity for the user.
THIS CALCULATOR IS NOT A PART OF IEEE 1584-2018 AND WAS NOT DEVELOPED BY THE IEEE P1584 WORKING GROUP.
THIS SOFTWARE IS PROVIDED "AS IS" AND "WITH ALL FAULTS." IEEE AND ITS CONTRIBUTORS EXPRESSLY DISCLAIM ALL WARRANTIES (EXPRESS, IMPLIED AND STATUTORY) RELATED TO THE SOFTWARE, INCLUDING, BUT NOT LIMITED TO, THE WARRANTIES OF: MERCHANTABILITY; FITNESS FOR A PARTICULAR PURPOSE; NON-INFRINGEMENT; AND QUALITY, ACCURACY, EFFECTIVENESS, CURRENCY, OR COMPLETENESS OF THE SOFTWARE. IN ADDITION, IEEE AND ITS CONTRIBUTORS DISCLAIM ANY AND ALL CONDITIONS RELATING TO: RESULTS; WORKMANLIKE EFFORT; AND LACK OF VIRUSES.
IN NO EVENT SHALL IEEE OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO: PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE AND REGARDLESS OF WHETHER SUCH DAMAGE WAS FORESEEABLE.
YOU ARE SOLELY RESPONSIBLE FOR COMPLYING WITH ALL APPLICABLE LAWS AND REGULATIONS, INCLUDING, BUT NOT LIMITED TO, ANY THAT GOVERN YOUR USE, EXPORTATION OR IMPORTATION OF THIS SOFTWARE. IEEE AND ITS CONTRIBUTORS DISCLAIM ALL LIABILITY ARISING FROM YOUR USE OF THE SOFTWARE IN VIOLATION OF ANY APPLICABLE LAWS OR REGULATIONS.
See Arc Flash IE and Iarc Calculators User Manual.pdf for full instructions.
Dataset Files
IEEE ExcelCalculator_V 2.6.6__mm_08_29_2019.xlsm (2.49 MB)- IEEE ExcelCalculator_V 2.6.6_M_mm_08_29_2019.xlsm (2.59 MB)
Open Access dataset files are accessible to all logged in users. Don't have a login? Create a free IEEE account. IEEE Membership is not required.
Documentation
| Attachment | Size |
|---|---|
 Arc Flash IE and Iarc Calculators User Manual.pdf | 758.3 KB |
| Arc Flash Disclaimer.pdf | 266.26 KB |
Comments
This xlsx file does not take reduced arcing current I_arc_min into account.
I_arc_min has an effect on tripping time of protection and can cause higher incident energy.
The second listed calculator named "IEEE ExcelCalculator_V 2.6.6_M_mm_08_29_2019.xlsm" is intended specifically for the reduced arcing current (I_arc_min) case. However, there are some errors in how the Incident Energy and Arc Flash Boundary equations have been translated into Excel formulae (which I have reported via the "Report a problem with this Dataset" link AND have included in a comment below as well), so I believe correct numbers will only be generated for LV equipment (i.e. < 0.6 kV) and not MV and HV cases at the present time.
Thank you.
I have entered the data inputs given in Annex D.1 of IEEE Std 1584-2018 (using an arc duration of 223ms given on page 64, which corresponds to the reduced arcing current) into the spreadsheet named "IEEE ExcelCalculator_V 2.6.6_M_mm_08_29_2019.xlsm".
Unfortunately, this results in calculated Incident Energy and Arc Flash Boundary values which are higher than those given on pages 67 and 68. Incident Energy in the standard is 13.343 J/cm^2, whilst in the spreadsheet is 13.44 J/cm^2. Arc Flash Boundary in the standard is 1704mm, whilst in the spreadsheet is 1712.51mm.
Having had a closer look at the equations in the standard, I strongly suspect that in the equations for E_600 (Eq. D.53), E_2700 (Eq. D.55) and E_14300 (Eq. D.57), the arcing current multiplied by the k3 coefficient is the full arcing current (Iarc_600, Iarc_2700, Iarc_14300) rather than the reduced arcing current (Iarc_600_min, Iarc_2700_min, Iarc_14300_min).
Clive,
I had done a bit of work on this back in Feb 2022.
I think your suspicions are correct.
See https://github.com/LiaungYip/arcflash/tree/main/ieee_1584/additional_tes... .
Like yourself, I had tried to report these issues at the time (a copy of the email is located at the link above), however I received no response.
PS, are you the same Clive Wickham who used to work on ERACS?
I may have corresponded with you in a past life. :)
Regards, Lewis.