Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 67
  • Last Modified:

Can I do this in a stand-alone HTML file?

Here is what it would look like.

http://screencast.com/t/GmGlcy3vv
0
frugalmule
Asked:
frugalmule
1 Solution
 
GaryCommented:
There is no correlation as to what the entry is and what the calculation should be
Area can 1,2,3,4,
The cube can be 1-900
Extension can be 1200-1900

So ????
0
 
frugalmuleAuthor Commented:
OK, I'll work on posting an update tomorrow when I get all the right numbers.  There are 4 areas, about 900 cubes, and about 800 phone extensions with one phone extension per almost every cube.

If I were to paste the lookup table, the phone extensions would be looked up, and to the left would be the rest of the data.
0
 
GaryCommented:
Type a number in cell C2 and have the numbers populate automatically
But you say the figures in the other cells could be anything in the ranges above. How is anyone to know what those numbers should be...?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
frugalmuleAuthor Commented:
Enter-an-Extension.xlsxThe attached should give some indication as to what I am trying to accomplish, but not much I guess till I get the exact numbers.  Whatever is to the left of the extension would be filled in.
0
 
GaryCommented:
No attachment
0
 
frugalmuleAuthor Commented:
Sorry, just posted it.
0
 
frugalmuleAuthor Commented:
If I were to paste the lookup table, the phone extensions would be looked up, and to the left would be the rest of the data, whatever that is, subject to new entries and modifying it constantly to correct the data we have.
0
 
GaryCommented:
So you want to do a lookup based on a column value so what do you mean
Can I do this in a stand-alone HTML file
HTML is just HTML - it has no dynamic nature, it is just plain text.

You could load up the data in an associative array and use JS to filter the rows you want...
0
 
frugalmuleAuthor Commented:
Most everything remotely java related is blocked at work so I am working on putting it on a public file share and providing access from work.  I am VERY restricted there so I don't think I can even get access to a web server, but a file share potentially.

Ideally, I would like to create a method for users to input an extension and gain the desired output.

We have office 2007, not 2010, but It does have MS Access, so that might be an option.  Thanks for the assist.
0
 
frugalmuleAuthor Commented:
Here is an updated sheet with most extensionsEnter-an-Extension.xlsx and cube numbers which will change and be added to.
0
 
Brian TaoSenior Business Solutions ConsultantCommented:
Why don't you just put the lookup table (I assume it be an Excel file) to the public file share?
0
 
frugalmuleAuthor Commented:
Anyone can do a spreadsheet.  I'm looking to create an interactive web-based solution in hopes that they will hire me to help with some I.T. projects.Enter-an-Extension-v2.xlsx
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
frugalmule, I don't understand why your question consists of a link to a screenshot and that screenshot has text that explains your question.

If you don't get a lot of response to your question, you may want to re-think your question approach. If you make it as hard as you can for people to help you, then don't be surprised if you don't get a lot of replies.

You could have typed the text explaining what you want right into your question.

You could have posted a screenshot right into your question.

Instead you hide your question in a screenshot and sent us to another site to load it. Why?

Just sayin'.
0
 
frugalmuleAuthor Commented:
Latest revision 40521353.  It should be clearer now by looking at the file, what I am trying to accomplish.
0
 
Ray PaseurCommented:
One of the problems with this application is that the data in column "E" (named "Ext") is not unique.  So if someone typed "Supervisor" what would you give back?

1363-B1D Blue                  654      Supervisor      
1256-B1A Blue                  655            
TR100-C4D Blue                  656      Trainer      
TR099-C4D Red                  657      Trainer      
TR098-C4D Red                  658      Supervisor      

Applications like these typically use database driven web scripts, and have some sets of rules for dealing with duplicate row keys.  I think trying to do this with HTML may be difficult.  You may be able to get some results with JavaScript and HTML.  But I think this may be like using a wrench to drive nails.  HTML by itself is not the right tool for the job.
0
 
frugalmuleAuthor Commented:
Ok, can we get it to happen in Excel only with a simple formula and without custom coding?
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now