Notes
Slide Show
Outline
1
Introducing Structured Formula Builder©
  • A product to help you manage business rules, complex algorithms, developed by Steve Diamond and marketed by:
  • Pragmatic Systems International
  • (305) 365-9400
  • www.pragmatic-systems.com
2
Introduction
  • Steve Diamond, Architect of SFB
    • Developer for over 20 years
    • Strengths in PERL and VISUAL BASIC
    • Developed completed web based applications in .NET
    • Graduate of FSU, Mathematics
    • Exclusive developer of product
    • Over 4,000 hours of development
    • Tested in variety of Microsoft environments
3
Structured Formula Builder-WHY?
  • Was born out of frustration over maintaining complex Macros and Formulas in Excel such as:


  • =IF(AND($D$7=5,NPV(0.15,$Q$77*0.85,$AE$77*0.85,$AS$77*0.85)*1/($Q$11+$AE$11+$AS$11)>2),NPV(0.15,$Q$77*0.85,$AE$77*0.85,$AS$77*0.85)*1/($Q$11+$AE$11+$AS$11),IF(AND($D$7=5,NPV(0.15,$Q$77*0.85,$AE$77*0.85,$AS$77*0.85)*1/($Q$11+$AE$11+$AS$11)<2),NPV(0.15,$Q$77*0.85,$AE$77*0.85,$AS$77*0.85)*1/($Q$11+$AE$11+$AS$11),IF(AND($D$7=3,NPV(0.15,$Q$77*0.85,$AE$77*0.85)*0.9/($Q$11+$AE$11)>2),NPV(0.15,$Q$77*0.85,$AE$77*0.85)*0.9/($Q$11+$AE$11),IF(AND($D$7=3,NPV(0.15,$Q$77*0.85,$AE$77*0.85)*0.9/($Q$11+$AE$11)<2),NPV(0.15,$Q$77*0.85,$AE$77*0.85)*0.9/($Q$11+$AE$11),IF(AND($D$7=2,NPV(0.15,$Q$77*0.85)*0.8/$Q$11>2),NPV(0.15,$Q$77*0.85)*0.8/$Q$11,IF(AND($D$7=2,NPV(0.15,$Q$77*0.85)*0.8/$Q$11<2),NPV(0.15,$Q$77*0.85)*0.8/$Q$11))))))

  • Can YOU really decipher this formula?  NOW and then after a FEW WEEKS?


4
Structured Formula Builder-NOW?
  • Grew to a ROBUST system that allows users to develop their OWN rules and then create ACTIVE X or .NET Assembled COMPONENTS for use by server or client applications to run automatically.
  • Users can WRITE and CONTROL their own RULES and they can CHANGE them as often as they want.
  • I.T. becomes the recipient of the rules not the interpreter of the rules.
  • I.T. can package the rules inside more complex user interfaces and can ensure they run correctly.
  • Structured Formula Builder lets the USERS control the rules creation though.



5
Structured Formula Builder-WHAT?
  • Structured Formula Builder was DESIGNED FOR AND WITH BUSINESS USERS
  • Just a few hours of training or reading of the HELP that is provided with the product is all an ANALYTICAL business user will need.
  • If you can understand the words IF, ELSE, and RETURN you are set!!!


6
Structured Formula Builder-HOW?
7
Structured Formula Builder-HOW?
  • Create the FIRST Variable


8
Structured Formula Builder-HOW?
  • Create a FORMULA that determines what to do under what circumstances. This example determines when a travel customer should buy NEGOTIATED air and when to buy PUBLISHED fares.




9
Structured Formula Builder-HOW?
  • Suppose we want to TEST out the conditions. There are several aids. Here we select “Show Values In Place” and can see what our Model will do based on currently assigned values:




10
Structured Formula Builder-HOW?
  • This view shows how each variable is used throughout the model:



11
Structured Formula Builder-HOW?
  • The user can select data from an external source



12
Structured Formula Builder-HOW?
  • Once the model is built and tested, the user can create an ACTIVE X component



13
Structured Formula Builder-HOW?
  • Documentation is built as the model is built. Select USER DOCUMENTATION:



14
Structured Formula Builder-HOW?
  • Example of automatically created User Documentation:



15
Structured Formula Builder-HOW?
  • Second page of User Documentation



16
Structured Formula Builder-Expandability
  • The product is built with Visual Basic and PERL as the “engine”
  • Any PERL function can be included in the application—which provides a HUGE SUITE of built in functions for Statistics, String Parsing, and all sorts of thing.



17
Structured Formula Builder-Competitive Analysis
  • This product is COMPETITIVELY PRICED
  • You do NOT need to be a computer scientist to understand!
  • Training takes a few HOURS not a few MONTHS
  • Compare to Rules Engines of hundreds of thousands
  • Interested?  Just fill out our form and we can contact you to get you started!!!!



18
Structured Formula Builder-Interested?
  • Interested?  Just fill out our form and we can contact you to get you started!!!!