Excel an Innovative Tool

I will make some research on that idea and i will get back to you if i find something interesting, otherwise update us as you go.

Good luck!

I have created a bill of materials/quotation system system that sounds similar. I am interested. If you care to send me your work, please send to chrisg288@hotmail.com

Thanks,

Chris

HI,

I too am thinking of a similar application and would be very interested

in what you've done so far. I'd be happy to make suggestions as to

whatever I might find.

thanks

Please send your Excel pkg to Russbassani@yahoo.com

Russ

then there is..

http://excel.tips.net/

Aurizon,

thats a great link, but, for clarification, I think we are referring to an application written in excel (at least I am) I've written a few hundred lines of code in my application, and it works with a parts list that has ~5000 parts in it. (could be more too.) Your link is more about using excel interface functions than programming, don't you think? or did I miss something?

Chris

It seems to me that the assembly of tips might have items within it that deal with the original matter.

I think it might have items of merit?

They also sell premium tips, which makes me suspect the free trips are more-or-less trivial.

I have written quite a few programs using the features within Excel,I Find the "LIST " feature is nice as it works with data returned via lookup,So I can sort vast datafiles and examin columns of data.

a Program aclled SIMARIS outputs a DAT file of Component parts used to build a Elecrtical distribution panel.The parts are processed and I can delete those marked as no needed,I can then split the parts into groups IE Insulating parts,Metal parts,Sundries,and Copper parts.Once filtered I can copy these into a "workpack" this is basically a blank book of formatted pages where I can list the items in an order suitable to issue to my CNC operator and manufacturing pricess,And finally to the Assemblers who put it all together like 'MECCANO" the work pack has a Client set up area where I record important information that then "floodes to the range of documents and QC formats.

I do not know much about "code" and pivot tables and I basically found a way within Excel to deliver what it is that I needed.

Needless to say noone in my company wants to use it as they say it is too complicated, They all seem to use Excel as a data recording area without any features.

I would need to send you a DAT file and the excel prog I call 8PT gal and the workpack.

Does this interest you.

I would love to know a bit more about mavro's and the code you speak of.

In the early AppleIIe days i did a bit of basic.I got a lot of pleasure with a simple program called 'RAPIDFILE. id could run direct macro's and a pust of the F3 could convert your data base "list " into a FORM.

It was a nice feature,that I look for in Excel.

Please come back

10:4

Hi Leo,

You can send to me at chrisg288@hotmail.com

There is a feature in excel (pre-2007) called "Form". Just select your header row and the first row of data, like so... then select Data > Form

and then this is the resulting form.

and you now have a form with a scrollbar control and search feature on it.

Chris

Hi Chris,I did try to send you a copy of the work I do but my bandwidth is not good It took over 20 MB for 7MB file.

I will need to see about better connectivity!

I had a look at the Form feature but it is very tame and not as customisable as I would like.

Can I as a question.

Excel is sometimes too cleaver IE if a part number startes wit a "zero" 0 OR if a 6-5 type number is inserted Excel tries to format it for me .The result is that I battle to get these numbers to work.

I have a sheet with a mixture of general formatted part numbers.I then have what I call a "LOOKUP sheet " Here I can either copy ,paste or directly type a part number,...The problem arises where the LOOKUP formula does mot find a match.

I have tried to format as text and I have tried a Apostrophy but I do not get the reults I need.

Can you understand my problem? I fno maybe I need to try to write a tiny sheet to demo the situation.

Please come back.

Leo Ted

Leo,

Problems like these are why I like to use vba. If using an apostrophe doesn't work, at the beginning of each part number, I would suggest adding a prefix to every part#. (ie PRT- for parts, ASY- for assemblies) Then if you ever need to export the data, you can use mid function to extract the original part number, if you stict religiously to an exact number of characters for the prefix.

Chris.

I'm interested in your project, could you please send me the details.Thank you, Best Regards, Manuel email: manuelcfortes@gmail.com

I can give you some inputs, if I can get the file.

Looking forward to recieving.

Thanks and regards

Ashok Toshniwal, Bangalore, India

Have you tried pivot tables to group your list?

I'm an Industrial Engineer and your work sounds like it might be helpful since the company I work for is on a budget. I have knowledge in other software for manufacturing so if would like to email me your work at pink_dolphins17@yahoo.com I could make suggestions. I wish you find the help you seek!

I am interested in your work since I am currently working on a similar project building an assembly from a pick list. I would like to look at what you've done please email me at wjacob@ebi-inc.com , Thanks