Still having trouble figuring out calculations...

[Dexx]

So the calculations tab is separate from the property editors...

so if I wanted to create a calculation based text-editor that summed up "Outstanding IOU's" for January

and take the list of 5 records of IOUs from the Person, Amount, When I lent them the money etc.

so at the bottom of the grid (or wherever) it said: "Current Oustanding IOU's - $200.00"

How do I do this? I dont see a way of selecting the property editors used in the calculation? Do I just type out the editor name with the ( + ) and ( - ) symbols?

How would I go about creating multiple creation fields that would then say take the "Outstanding IOUs" and multiply it by a fake interest of 10% to let me know the "Total Additional Interest for the Month - $20"


and then of course I still have NO idea how to create charts and stuff, so I still need to play with that when I have time....anyone feel like making a quick demo video of chart / report basics so Thomas can focus on programming more goodies? <3 hehe

-Dexx

[fortesque]

Hi Dexx:
here's how I used calculations property. When you click on calculations the "Calculations" window appears. It already is set for numeric. Type in the caption name. If I recall correctly the bottom window , called "Expression Builder" lists math, text and property function. Select the property editor and it lists the editor you want as the first part of your equation. For example I need to add "migraine", "tension" and "sharp" headache scores for a "total daily score." Each of these (excluding "total daily score") is an editor created using "Numeric" editor when I built them. So, the calculation caption is "total daily score" and then I revert to property editors. When I click property editors, my editors appear in the window. I then double click on "migraine". Now the Expression window shows "migraine." Next I click the math function in the "Expression Builder" window which brings up the "+" sign and other symbols. Double click the plus sign and the Expression window now shows "migraine +". Next I return to property function and double click on "tension." The window now shows "migraine + tension" . I continue until I have all the editors and math symbols in the window that create an equation.
I don't think that you can link one calculation to another calculation to build multi stage equation. Never tried it.
As for charts and graphs, I have a help page at http://www.headacheanalyzer.com/headachetracker.html that shows users of one of my applications how to create charts of their data.
Hope this is helpful.

Best regards,
John Burns

[Dexx]

Oh wow John thank you so much x 10000

I'll try playing around with that information tonight after work, I kept forgetting about your headache tracker help file, I had remembered you posting that long ago, sorry about that! That also helps a lot!

Thanks :-)

[TigerSoftware]

Calculations is a property editor of its own. I think that is where some people are getting confused.

So you set up a calculation for the sum of a few fields on program, it will create a property editor to display the calculations.


Thomas

[Dexx]

Hey Thomas is the calculations / software capable of creating something similar to a mortgage calculator where people could enter in say "$500,000" as a mortgage amount, then enter in the interest % and mortgage length of time

and then have the software able to spit out the amortization schedule, monthly payments, etc?


Or say a debt calculator where someone enters in a debt of $1000, with interest of 12%, and payments of $120 a month...

and then the software could show a chart etc. with how long it will take to pay off that debt?



Just thinking of different usages for calculations that people might doing in excel which a program could be created for...

Is the software capable of doing such calculations and/or showing results like mentioned above?

Thanks!

[TigerSoftware]

Hey Thomas is the calculations / software capable of creating something similar to a mortgage calculator where people could enter in say "$500,000" as a mortgage amount, then enter in the interest % and mortgage length of time

and then have the software able to spit out the amortization schedule, monthly payments, etc?


Or say a debt calculator where someone enters in a debt of $1000, with interest of 12%, and payments of $120 a month...

and then the software could show a chart etc. with how long it will take to pay off that debt?



Just thinking of different usages for calculations that people might doing in excel which a program could be created for...

Is the software capable of doing such calculations and/or showing results like mentioned above?

Thanks!


Sure, you create all your editors for debt, payments and interest and then create a calculation field using all of those property editors.


Thomas

[MikeM]

Or say a debt calculator where someone enters in a debt of $1000, with interest of 12%, and payments of $120 a month...

Allright Dexx you keep bringing up debt collectors. Are you a loan shark or what? :D

Best not to keep those kind of records, except in your head ;)

[TigerSoftware]

Allright Dexx you keep bringing up debt collectors. Are you a loan shark or what? :D

Best not to keep those kind of records, except in your head ;)

I was starting to worry myself. :D



Thomas

[Dexx]

LOL guys! haha!

I'm just looking at high download niches on Download.com where a program that does calculations could come in handy. Debt and Credit are big ones, what can I say!


On that note, Thomas two more questions:

1) Can calculations be performed on the results of other calculations? Similar to how in Excel is cell A2's formula changes it from a value of 2 to 5...then Cell B2's formula updates itself based on the new value of cell A2

and also

2) Are the calculations restricted to the record object they are being created in, or can be they be applied to the grid (collection of records) in total. For example, a grocery budget program that tracks grocery expenses each trip... can a calculation be done on the grid (etc.) that could then sum up the monthly cost of the grocery trips as a running total that constantly updates itself as each new record is entered?

This could also be applied to say the mortgage example where a person might enter in there down payment information and mortgage interest % one time, and then records would only need to track cost of the house, and other real estate information related to the house.

That way calculations could be done without re-entering the downpayment and interest % every single time a new record is entered.



Just trying to figure out what is possible so it makes it easier to brainstorm different ideas (I've been so busy with work I haven't had much time to actually CREATE projects...so I just brainstorm a lot until the weekend! heh)

Thanks!

-Dexx

[TigerSoftware]

LOL guys! haha!

I'm just looking at high download niches on Download.com where a program that does calculations could come in handy. Debt and Credit are big ones, what can I say!


On that note, Thomas two more questions:

1) Can calculations be performed on the results of other calculations? Similar to how in Excel is cell A2's formula changes it from a value of 2 to 5...then Cell B2's formula updates itself based on the new value of cell A2

and also

2) Are the calculations restricted to the record object they are being created in, or can be they be applied to the grid (collection of records) in total. For example, a grocery budget program that tracks grocery expenses each trip... can a calculation be done on the grid (etc.) that could then sum up the monthly cost of the grocery trips as a running total that constantly updates itself as each new record is entered?

This could also be applied to say the mortgage example where a person might enter in there down payment information and mortgage interest % one time, and then records would only need to track cost of the house, and other real estate information related to the house.

That way calculations could be done without re-entering the downpayment and interest % every single time a new record is entered.



Just trying to figure out what is possible so it makes it easier to brainstorm different ideas (I've been so busy with work I haven't had much time to actually CREATE projects...so I just brainstorm a lot until the weekend! heh)

Thanks!

-Dexx


No, calcs can't be used with other calcs right now. Steve hates me for it. ;)

It should display in the grid as well. As for total, I am not sure what you mean. You can total particular columns.


Thomas

[Dexx]

Yes totaling columns is what I'm referring to, good to hear!

[stevinium]

How can I hate you Thomas? You're the best. :)
Dexx if you right click on the bottom of the grid, it brings up a menu for the columns.
Sum
Min
Max
Count
Average

You can add it to whatever column you choose. Lots of possibilities there.
Steve

[Dexx]

Ah didnt know that! Thanks :-)

[fortesque]

Thomas, Dexx and Forum Members
If anyone really has a smooth process for utilizing the possible options in the grid and could post a set of instructions describing those steps it would be very helpful. The software Thomas wrote is really powerful, and I for one need tutorial help on maximizing the options.
I worked a number of options on the grid including the instructions Thomas gave to Dexx on right clicking on the bottom of the grid to access stat functions for a column (count,+,average, etc.). Thomas' instructions worked very well once I realized that bottom of the grid is below the bottom horrizontal line in grid window. I also have "played" with other options on the grid (such as grouping by by column, etc.) and got into a mess. I hit every possible action I could imagine to back out of the revised grid I had created and get back to the original grid depiction. Point is that I was lost among the trees in the forest. I don't think I could retrace my steps. I didn't know what I was doing.
Best regards,
John Burns

[MikeM]

Cool. I didn't know that either. Now I have to remake the software to add that in :)

[TigerSoftware]

Thomas, Dexx and Forum Members
If anyone really has a smooth process for utilizing the possible options in the grid and could post a set of instructions describing those steps it would be very helpful. The software Thomas wrote is really powerful, and I for one need tutorial help on maximizing the options.
I worked a number of options on the grid including the instructions Thomas gave to Dexx on right clicking on the bottom of the grid to access stat functions for a column (count,+,average, etc.). Thomas' instructions worked very well once I realized that bottom of the grid is below the bottom horrizontal line in grid window. I also have "played" with other options on the grid (such as grouping by by column, etc.) and got into a mess. I hit every possible action I could imagine to back out of the revised grid I had created and get back to the original grid depiction. Point is that I was lost among the trees in the forest. I don't think I could retrace my steps. I didn't know what I was doing.
Best regards,
John Burns

Hi John,

Yes, this is my fault and I am trying to rectify with more documentation. I am trying to balance too many things right now. My goal is to get some great documentation done in the next couple of months. Reporting and charts are in that as well.



Thomas

[fortesque]

Hi John,

Yes, this is my fault and I am trying to rectify with more documentation. I am trying to balance too many things right now. My goal is to get some great documentation done in the next couple of months. Reporting and charts are in that as well.



Thomas

Thomas and others:
I think with the talent in this forum community folks can contribute to building documentation on "how to's" and not leave it all up to you. Seems to me as one plays with and explores the TSBPro software and finds out how to handle a specific operation or come up with a neat trick, it wouldn't be too much to ask them to post a few lines explaining what they did and how. Heck, the Perl programming language open source community is really powerful and share a whale of lot of "here's how" and "why that won't work" stuff. That's what makes the Perl programming language so fantastic (along with the fact that it is truly an amazing program language). Any interest in building some "how to's" documentation for TSBPro?
John Burns

[Alton]

Thomas and others:
I think with the talent in this forum community folks can contribute to building documentation on "how to's" and not leave it all up to you. Seems to me as one plays with and explores the TSBPro software and finds out how to handle a specific operation or come up with a neat trick, it wouldn't be too much to ask them to post a few lines explaining what they did and how. Heck, the Perl programming language open source community is really powerful and share a whale of lot of "here's how" and "why that won't work" stuff. That's what makes the Perl programming language so fantastic (along with the fact that it is truly an amazing program language). Any interest in building some "how to's" documentation for TSBPro?
John Burns

AH!!! A volunteer in the audience! Step on up! :D

[Dexx]

Thomas, perhaps a "Tips and Tricks" forum could be created where people could post interesting things / methods they found possible with the program?

[RolandK]

--------------------------------------------------------------------------------

How can I hate you Thomas? You're the best.
Dexx if you right click on the bottom of the grid, it brings up a menu for the columns.
Sum
Min
Max
Count
Average

You can add it to whatever column you choose. Lots of possibilities there.
Steve


Hi Guys,


I have been trying to use the calculation but no matter where I right click on the calculation setup form I donot get:
Sum
Min
Max
Count
Average

At the bottom of th page is a grid that on the left says:
Math
Text
Property
In the middle it says for math
+
-
*
etc.
But I can right click all day and not see:
Sum
Min
Max
Count
Average

I must be doing something wrong or need an update.

Roland

[fortesque]

Roland K:
I think you may be in the wrong window when you are trying to use the statistics function.

Go to the grid window, that is, where all the records are displayed with data entries made under each of the editors you set up when creating the application. Then go down to be bottom section of the grid, under the last horrizontal line and right click. Here's an image showing one of my application grids and the use of the statistics function.

Hope this is helpful and clarifies procedure for you.
Best regards,
John Burns

[TigerSoftware]

Hi Roland,

As John pointed out very nicely, it is part of the grid functionality.



Thanks John. :)



Thomas

[RolandK]

Roland K:
I think you may be in the wrong window when you are trying to use the statistics function.

Go to the grid window, that is, where all the records are displayed with data entries made under each of the editors you set up when creating the application. Then go down to be bottom section of the grid, under the last horrizontal line and right click. Here's an image showing one of my application grids and the use of the statistics function.

Hope this is helpful and clarifies procedure for you.
Best regards,
John Burns

You were right I found it on that page. I was thinking the calculations were like Excel spreadsheats but they are Not! I am trying to turn a speadsheet I have into a program.

Thanks again John,

Roland K

[Alton]

Hello Thomas,
It appears that the calculations editor is limited to 100 characters. Can you increase that to at least 300 in the next update. I can't get all of my text into it.
Thanks,
Alton

[TigerSoftware]

Hello Thomas,
It appears that the calculations editor is limited to 100 characters. Can you increase that to at least 300 in the next update. I can't get all of my text into it.
Thanks,
Alton


Interesting, it should have been unlimited. I will see what I can do.


Thomas

[countrytechie]

Let me get this straight: if I have first input $ 1 and then a second input $ 2 for same client (on different dates), so I would have 2 entries showing for this customer; I can't have or get a running total of input 1 and 2 ?

Klaus

[tripro]

Klaus,
What I think you are asking can be show as 'SUM' in any 'grid view' page. Just right click on the bottom bar under the field that you are trying to get a total for and select 'SUM' and it will keep a running total of all amounts you add to that field.

HTH

Mark

[countrytechie]

OK, I have a "sum" for each entry page (since I actually have 3 currency input for each customer), can the "Total Sum" (you are referring to) be put on a report for print-out?

Klaus

[tripro]

I believe the report writer can do that, although an easier/faster way would be to just print preview from that page and the sum (or any calculation/total) will display on the bottom.

HTH!

Mark

[TigerSoftware]

OK, I have a "sum" for each entry page (since I actually have 3 currency input for each customer), can the "Total Sum" (you are referring to) be put on a report for print-out?

Klaus

Klaus, is this what you are trying to do?

http://profittigersystems.com/help/TSB/lessons/Add_Totals_to_a_Report.html



Thomas

[countrytechie]

Yes, this is what I am trying to do; worked fine. Now I have the customer's address in another "object," how do I get their address on the "total Sum" page. I see I can email it to them, but if no email, need to send by snail mail. Still need to learn "reports," would I use this? Also, while I'm thinking about it, at the end of the year I want to purge all receipts and start a new year; how do I do that (without deleting one by one? Backup and delete?

Sorry for the double whammy question, but getting old and need to ask before I forget.

Klaus

[TigerSoftware]

Yes, this is what I am trying to do; worked fine. Now I have the customer's address in another "object," how do I get their address on the "total Sum" page. I see I can email it to them, but if no email, need to send by snail mail. Still need to learn "reports," would I use this? Also, while I'm thinking about it, at the end of the year I want to purge all receipts and start a new year; how do I do that (without deleting one by one? Backup and delete?

Sorry for the double whammy question, but getting old and need to ask before I forget.

Klaus


Hi Klause,

I need you to create one post per question in it's own thread. I won't be able to find your questions nor will others be helped if they can't find it.

Thanks,


Thomas

[countrytechie]

Yes, this great. Sorry if this is my second reply to same question, but can't find my other reply.

Have to learn reports though.

Thanks for the help guys.

Klaus