M
Mitch
Okay, so here is what I’m trying to do: I have developed this rather complex
“calculator†in excel that uses 28 sheets simultaneously to generate a
graphical output that the users of the “calculator†can see and from that
make planning decisions. The calculator is for the planning department of my
company and basically calculates project feasibility based on cost and GHG
reduction (but that is beside the point). So that the folks in the planning
department actually use the calculator, I was told that I need dumb down the
interface. If they have to look at a huge excel file, theory is, they will
not use it. I am using sharepoint 03 to upload the calculator but I have to
find a way to create a friendlier user interface, while retaining the
functionality of excel. I want the user to be able to input parameters that
are specific to the project they are working on, have those inputs assigned
to particular cells in the excel file and then generate the graphs and
display them to the user. Anyone have any ideas on how to tackle this? I
looked at infopath, trying to generate a form for the user to look at, but
was unsuccessful. In infopath I had to use a third party importer and in
doing so I lost the mathematical and graphical capabilities of excel. I have
been told by others in the office that Access may be the way to go. The
other thing that I thought of was trying to code in a friendlier interface
directly in excel and posting that. What do you all think?
Thanks guys.
Mitch
“calculator†in excel that uses 28 sheets simultaneously to generate a
graphical output that the users of the “calculator†can see and from that
make planning decisions. The calculator is for the planning department of my
company and basically calculates project feasibility based on cost and GHG
reduction (but that is beside the point). So that the folks in the planning
department actually use the calculator, I was told that I need dumb down the
interface. If they have to look at a huge excel file, theory is, they will
not use it. I am using sharepoint 03 to upload the calculator but I have to
find a way to create a friendlier user interface, while retaining the
functionality of excel. I want the user to be able to input parameters that
are specific to the project they are working on, have those inputs assigned
to particular cells in the excel file and then generate the graphs and
display them to the user. Anyone have any ideas on how to tackle this? I
looked at infopath, trying to generate a form for the user to look at, but
was unsuccessful. In infopath I had to use a third party importer and in
doing so I lost the mathematical and graphical capabilities of excel. I have
been told by others in the office that Access may be the way to go. The
other thing that I thought of was trying to code in a friendlier interface
directly in excel and posting that. What do you all think?
Thanks guys.
Mitch