Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Looking For Power App Guidance - Excel Engineering Calculator to Power App

Posted on by

I would like to make an app-based solution for performing calculations and am not sure of the best way to make it. I’d like to make the app UI aimed at laptop/web-app usability for inexperienced engineers, but I am interested in learning how to use the same app for phones and laptops for future development. I also need an exportable Results files with inputs and calculations. I don't really have experience in coding for databases, but am usually able to use brute force logic through coding adjacent situations, so I think I can find my way forward with some direction.

 

I have everything worked out in Excel using drop-down data validation lists, index-match formulas for lookups, and number input cells for additional values. I also have a lot of IF formulas to handle multiple configuration options that would lead to changing formulas. In all, I think there are 100-200 cells with formulas that layer on top of one another as inputs and outputs for the algebraic formulas. There are also about 200 different material mechanical properties referenced in multiple tables, that will potentially grow over time (I add more data, Users just use the custom input property area). There are currently 5-20 inputs with 2-3 needed outputs and 20 alternate output calculations for mechanical calculation troubleshooting (evaluating multiple types of failures/limitations).

 

All of the calculator examples I have seen are just your basic “How to make a calculator” tutorials that let you input a couple values and press a button to multiply/divide/add/subtract them. I think I can see how making several layers of calculations can get me to the result I need, but it seems like I am basically starting from scratch. Are there any tutorials/tips out there for converting an existing Excel based calculator solution into a Power App?

 

For anyone interested in more context, I have multiple calculators for mechanical and hydraulic equations, but the most difficult example referenced above is a bolt torque/stress calculator that uses equations from ASME B1.1, SAE TP 770420 , and T9070-AJ-DPC-120/3010 Appendix G. The Excel sheet calculates torque, preload, bolt stress, compressive joint stress, joint separation, thread stripping, etc. I have also added in a couple equations from other sources, such as Von Mises stress calculations, adding shear and axial stress. The other less complex calculators for other situations use equations from ASME B31.1, ASME BPVC, and multiple engineering text books.

  • ronaldwalcott Profile Picture
    ronaldwalcott 855 on at
    Looking For Power App Guidance - Excel Engineering Calculator to Power App
    I have never seen a tutorial dedicated to converting Excel solutions to Power Apps but software design principles tend to be the same no matter the tools. You can try using the new business plan experience tool if you have access to it and you have a complete description of your solution.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,246

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,884

Leaderboard