Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes Beginning Java and the fly likes Picture frame calculator Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "Picture frame calculator" Watch "Picture frame calculator" New topic

Picture frame calculator

Ray Smith

Joined: Dec 08, 2012
Posts: 4
Hello everyone, newbie first post here

I've got a calculator that i created in excel that I wanted to learn to code it in Java, been reading and following a few tutorials on YouTube and really enjoying it

I tried to upload the .xlsx calculator for show how it works but it does let me, maybe some one can give a push start or some pointers, calculator it uses a table for reference to pick the finished width of the frame for the picture/photo

Thank you.
Ray Smith

Joined: Dec 08, 2012
Posts: 4
I realized I have a long way to go so I signed up for classes, my question was what would it take to make an app like this work because it uses a chart with four columns and one hundred rows to find the proper width of a frame

Michael Dunn
Ranch Hand

Joined: Jun 09, 2003
Posts: 4632
many things that emulate excel are done in a JTable - but it's just a grid, nothing fancy.

Swing is not easy, so bookmark this page
Darryl Burke

Joined: May 03, 2008
Posts: 5115

The Java equivalent of a lookup table is a java.util.Map.

... it uses a chart with four columns and one hundred rows

What are the column contents? Presumably one is the value looked up, and the other three are returned by spreadsheet functions. In Java, you would create a class encapsulating those three values, and a Map that cross references the lookup value (as "Key") to instances of this class (as "Value").

I strongly recommend that you first try to write this as a command line application; put off even trying to create a GUI till after you have that working correctly.

luck, db
There are no new questions, but there may be new answers.
Ray Smith

Joined: Dec 08, 2012
Posts: 4
thanks for the responses, will look into your suggestions

I uploaded a couple pictures of the calculator and the reference table to give you guys a better Idea, basically a picture 36'' wide will be assigned a predetermined frame size of 46.5" or 37, 38, 39, 40 and 41 will also be assigned a frame width of 46.5'' if I enter 42 thru 47 in the picture width box it will give the next predetermined frame width size of 53" for that range

to get the finished frame size it looks thru first column to find the answer in the second column, the idea is setting this up in the Java desktop application itself, I found Apache POI, functions but I don't want to be depending on excel for my reference table if possible


[Download sample calculator excel pic.bmp] Download

[Download sample calculator excel pic2.bmp] Download

I agree. Here's the link:
subject: Picture frame calculator
It's not a secret anymore!