Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
How Excel programs should be developed (1 viewing) (1) Guest
Please post any suggestions or ideas that you think the ExcelCalcs team should consider.
Go to bottom Favoured: 0
TOPIC: How Excel programs should be developed
#2404
crystalinv (User)
Tadpole (Junior Boarder)
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
How Excel programs should be developed 6 Years, 9 Months ago Karma: 0  
If you find yourself searching through ExcelCals Repository, it means you are either looking for a spreadsheet that can help you solve a problem or you are looking for materials to help you improve upon your excel programming skills. i say with all confidence that you are at the right place.

I think Turan Babacan has set the way forward in the "next generation" of excel programming. He has a unique and consistent way of developing his spreadsheet that i think is worth emulating. Please search through the repository for the following Excel programs from Turan and study and compare them very well:
1. EXCretwall
2. ExcelSta2D
3. EXCsta_3D
4. ExcelFEM

All this programs feature a very nice and interactive graphical user interface, One-time-click navigation, no macros and easy-to-use layouts. I believe we can all make use of the strategies he has adopted in his programs to enhance our spreadsheets. Keep up the good work Turan, and thanks to John Doyle for making this platform available.
 
Logged Logged  
  The administrator has disabled public write access.
#2405
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1747
graph
User Offline Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:How Excel programs should be developed 6 Years, 9 Months ago Karma: 493  
Thanks for your comments crystalinv Turan's work is simply masterful. The most enjoyable part of running the site is meeting people like Turan and learning how they get the best out of Excel. I was thinking about writing an article on top ten calculation tips for Excel. Here is a flavour of what I mean.


  • Use of consistent systems of units.

  • Validation of calculations.

  • Transparency of calculation method.

  • Use of drop down lists (data validation or combo boxes).

  • Use of charts to provide a graphical response to user input.

  • Use of calculation menus to separate constituent parts of a calculation.

  • Use of data lookups (tabular lookups or curve fitting data).




I would be very grateful for any other tips and suggestions.
 
Logged Logged  
 
  The administrator has disabled public write access.
#2476
BABACAN (User)
Frog Prince (Platinum Boarder)
Posts: 36
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Türkiye Birthdate: 1964-08-05
Re:How Excel programs should be developed 6 Years, 7 Months ago Karma: 21  
...
 
Logged Logged  
 
Last Edit: 2011/04/16 23:08 By BABACAN.
  The administrator has disabled public write access.
Go to top
We have 30 guests and 37 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Google Analytics Alternative