MEP filters listing help please both 804A/B and others.

[Zed254]

I'm thinking option 2 would be less repetitive work: the major brands are already at top of columns.

 

[155mm]

I like the first one... scan 2.... item at top then manufacture and pn below, infinite number of lines going down, left to right not so much

 

[BobbyT]

I think both are good. But as 155 mentioned, (scan 2) i think its better to have the info under the column headers. It's easier for most to filter if using Excel that way. For example, you can filter the "Oil Filters" column by alphabetical order or if you only want to see the Donaldson filters, if there are more than one listed. Then have a tab in that excel sheet for each generator model.

 

[Guyfang]

I think both are good. But as 155 mentioned, (scan 2) i think its better to have the info under the column headers. It's easier for most to filter if using Excel that way. For example, you can filter the "Oil Filters" column by alphabetical order or if you only want to see the Donaldson filters, if there are more than one listed. Then have a tab in that excel sheet for each generator model.

I would like to do the Tab thing, but if we post it in SS, thats not allowed. Sooooooooo, if we want a "living document, we need to put it someplace else. And that defeats the purpose of having all our info in SS. Any other ideas? Some way around that?

 

[wciguy]

Howdy folks. I have been buying and selling MEP gensets for several years and created spreadsheets with a maintenance schedule and a place to record hours and dates when the items were accomplished to furnish to the purchasers. I am attaching an example. I have a filter interchange at the bottom.

 

[Guyfang]

That's very nice. Its what I am talking about, mines the service schedule.

 

[BobbyT]

I would like to do the Tab thing, but if we post it in SS, thats not allowed. Sooooooooo, if we want a "living document, we need to put it someplace else. And that defeats the purpose of having all our info in SS. Any other ideas? Some way around that?

Guy, I forgot to reply to you the other day, but you mention its "not allowed"? i didn't see anywhere in the rules section that an excel spreadsheet wasn't allowed, unless I'm totally missing it, which wouldn't be the first time . Surely there is a way to create a dynamic document in a forum scenario.

 

[Guyfang]

Guy, I forgot to reply to you the other day, but you mention its "not allowed"? i didn't see anywhere in the rules section that an excel spreadsheet wasn't allowed, unless I'm totally missing it, which wouldn't be the first time . Surely there is a way to create a dynamic document in a forum scenario.

I talked to Patracy once about us making a list of TM's, in a Excel format. If I remember right, he explained to me that the SS format would not accept it. I wanted to post a list of TM's in a listing, that was a "Living Document". Meaning, I could add, subtract and change the listing. That way we could post something that was up to date in real time, and not post a never ending line of PDF documents. If one or two people had "control" over the living document, then it would be up to date, in real time, but could NOT be changed by anyone else. You could lump all the TM's in the SS forum, into one list. Search it by any number of ways, for the TM you want. Then link the TM number to the TM. Find the TM you want, click on the TM number and presto, there it is. You could do it also with gen sets, service parts and or other common parts.

 

[reset2]

Don't know what happened to everyone but it looks great to me. I does appear to be a lot of work to pull it all together, but you will never know just how many hours you will save the new owners of this MEP sickness at some point we get. Thanks for you help.

Edit-- I should have read to the end before posting.