Home Tutorials Forums Articles Blogs Movies Library Employment Press
Old 08-13-2009, 02:17 PM   #1
Registered User
Join Date: Aug 2009
Posts: 1
Question excel to enterprise RIA data model?

So, my friend has a company whose financial product runs in flash in a browser, which is designed based on a financial model specific to their industry created in excel. Currently, it relies on PHP to re-run every calculation in the application (returning roughly 25 arraycollections) based on a small amount of user input. They want to convert this to something that would run self-contained in AIR or without having to rely on PHP to perform the calculations (don't ask why it was done this way in the first place).

So, a boiled down example might be:
One table of generic variables A,B,C
One table of products (different variations) 1,2,3
One table that is performed calculations- i.e. one column user input, one column that multiplies by a generic value, and the rest are simple (value/month, value/year, etc). Each row in this final table directly corresponds to each row in the table of products.
column1: A*.5, column2: column1/.5, column3: column2*12;
Is there any decent way to do this with arraycollections? the saved user input is stored in a database, and loaded on startup, after which all the other data in the program is calculated. After each change, there are a cascade of calculations that need to be performed. My only guess is that there's a different sort of data structure that would be better suited, but I'm not from a background where these structures are often needed, unfortunately
dzdrazil is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT. The time now is 06:57 PM.

Follow actionscriptorg on Twitter


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Ad Management plugin by RedTyger
Copyright 2000-2013 ActionScript.org. All Rights Reserved.
Your use of this site is subject to our Privacy Policy and Terms of Use.