Lubricant Resource?

[Ford F834]

Ok, I got the manuals scanned and uploaded to the Specifications/Lubricant Specifications page.

But then I started to modify the table and came to the conclusion that I can't maintain that table. The widget on Weebly is atrocious - for instance there's no way to insert rows in the middle of the table, and I need to insert rows. So, I found a way to insert a spreadsheet onto a Weebly page, and then I converted the 1989 lubrication table to a spreadsheet and loaded it up on the Lubrication page.

But, I have two problems. First, the spreadsheet doesn't show up on my iPad, but it does on my iPhone and my Windows computers. Second, if I get the iPad showing the spreadsheet then I need to the size of the spreadsheet under control. As you can see, there's a lot more to the spreadsheet than just the data.

So, please go see what you see on that page and let me know.

Gary, the chart displays fine on my phone in horizontal mode. In vertical position the wrapped text gets a little ridiculous since it wants to display the whole width in smashed columns instead of scrolling.

Is the E4OD going to be included at some point as it is another popular retrofit?

I did not see the gear oil transfer cases on the chart, or is that what you were talking about needing to add lines to the spreadsheet? Would it be beneficial to name the t case models used 80-86 to clarify which ones get that fluid?

It probably needs its own chart, but I still think a list of capacities would be helpful.

And THANK YOU for all the work you put into this!!!

[Gary Lewis]

Gary, the chart displays fine on my phone in horizontal mode. In vertical position the wrapped text gets a little ridiculous since it wants to display the whole width in smashed columns instead of scrolling.

Is the E4OD going to be included at some point as it is another popular retrofit?

I did not see the gear oil transfer cases on the chart, or is that what you were talking about needing to add lines to the spreadsheet? Would it be beneficial to name the t case models used 80-86 to clarify which ones get that fluid?

It probably needs its own chart, but I still think a list of capacities would be helpful.

And THANK YOU for all the work you put into this!!!

Jonathan - Which chart, the Tables, Spreadsheet, or Word Doc? Or, can you not see the document on the spreadsheet and doc tabs?

And, we do need to add the E4OD, which means yet another row will be needed.

As for the gear oil, I haven't gotten that far as I didn't want to put more effort into a table that may get ditched. But I do agree with need to call out the t-case models as their lubes vary.

Boy, this is getting more and more complex. Which may be why it doesn't already exist. But, it'll be worth it. And, you are welcome.

EDIT: My iphone, running Safari on iOS 10.x sees the spreadsheet and Word doc just fine. This iPad’s Safari on iOS 11 doesn’t see either of them. Just gives a white space. But Chrome on iOS 11 sees them just fine. 😳

And, I’ve discovered that the way I was doing the Word doc, meaning dropping the spreadsheet onto a page in the doc,isn’t going to work. That’s because it renders the page into an image and Google won’t be able to find the words, meaning you can’t find them via a search. But, the spreadsheet does present them as words and they should be able to be found. Given that and how cleanly my pdf software creates a spreadsheet from a document I’d say that’s the way to go.

And, that gives me an idea. On the Transfer Case page and the Manual and Automatic transmission pages there are tables from the parts catalog of which transfer cases were used when and in what trucks. But they are all jumbled up and there seems to be little logic to it. However, I could output those pages into a spreadsheet and sort them by t-case and then year and then model and we might have something. Thoughts?

[Gary Lewis]

Jonathan - Which chart, the Tables, Spreadsheet, or Word Doc? Or, can you not see the document on the spreadsheet and doc tabs?

And, we do need to add the E4OD, which means yet another row will be needed.

As for the gear oil, I haven't gotten that far as I didn't want to put more effort into a table that may get ditched. But I do agree with need to call out the t-case models as their lubes vary.

Boy, this is getting more and more complex. Which may be why it doesn't already exist. But, it'll be worth it. And, you are welcome.

EDIT: My iphone, running Safari on iOS 10.x sees the spreadsheet and Word doc just fine. This iPad’s Safari on iOS 11 doesn’t see either of them. Just gives a white space. But Chrome on iOS 11 sees them just fine. 😳

And, I’ve discovered that the way I was doing the Word doc, meaning dropping the spreadsheet onto a page in the doc,isn’t going to work. That’s because it renders the page into an image and Google won’t be able to find the words, meaning you can’t find them via a search. But, the spreadsheet does present them as words and they should be able to be found. Given that and how cleanly my pdf software creates a spreadsheet from a document I’d say that’s the way to go.

And, that gives me an idea. On the Transfer Case page and the Manual and Automatic transmission pages there are tables from the parts catalog of which transfer cases were used when and in what trucks. But they are all jumbled up and there seems to be little logic to it. However, I could output those pages into a spreadsheet and sort them by t-case and then year and then model and we might have something. Thoughts?

I think I've turned the corner on how to do the documentation - spreadsheet. I've put the lube section of the 1985 owner's manual on the Using Spreadsheet tab of the Lubricant Specifications page. And I've tested it with these results:

• Windows machines running Chrome - works well

• 12" iPad Pro running Safari on iOS 11.0.1 - works well

• iPad Mini running Safari on iOS 11.0.2 - cannot see the spreadsheet at all

• iPad Mini running Chrome on iOS 11.0.2 - works well

• iPhone 6 running Safari on iOS 10.3.3 - works well

So, please go check it out yourself and let me know how it works for you.

If it appears to be working well then I'm confident this is the way to go as Google should be able to read the text so we'll be able to search for the info - in a few days after Google crawls the site again. And, I can do things with the spreadsheet, like inserting rows or columns, changing widths, etc to get the info usable.

What 'cha think?

[Ford F834]

I think I've turned the corner on how to do the documentation - spreadsheet. I've put the lube section of the 1985 owner's manual on the Using Spreadsheet tab of the Lubricant Specifications page. And I've tested it with these results:

• Windows machines running Chrome - works well

• 12" iPad Pro running Safari on iOS 11.0.1 - works well

• iPad Mini running Safari on iOS 11.0.2 - cannot see the spreadsheet at all

• iPad Mini running Chrome on iOS 11.0.2 - works well

• iPhone 6 running Safari on iOS 10.3.3 - works well

So, please go check it out yourself and let me know how it works for you.

If it appears to be working well then I'm confident this is the way to go as Google should be able to read the text so we'll be able to search for the info - in a few days after Google crawls the site again. And, I can do things with the spreadsheet, like inserting rows or columns, changing widths, etc to get the info usable.

What 'cha think?

The table displays well in horizontal mode, the spreadsheet displays and scrolls well, the word doc is cut off even in horizontal and cannot scroll. I like the spreadsheet view on my iPhone.

[Gary Lewis]

The table displays well in horizontal mode, the spreadsheet displays and scrolls well, the word doc is cut off even in horizontal and cannot scroll. I like the spreadsheet view on my iPhone.

Glad it is working. Let's see, you have an iPhone 7? What iOS are you on?

[Ford F834]

Glad it is working. Let's see, you have an iPhone 7? What iOS are you on?

10.3.3. I'm nervous to upgrade to 11, I've heard things about battery drain 😬

[Gary Lewis]

Glad it is working. Let's see, you have an iPhone 7? What iOS are you on?

10.3.3. I'm nervous to upgrade to 11, I've heard things about battery drain 😬

I'm running it on the iPad and haven't noticed any battery drain problems. But I have noticed that it is a bit slower - I think. And I haven't upgraded the phone as my app that keeps my gas mileage records doesn't run under 11.

[Gary Lewis]

I'm running it on the iPad and haven't noticed any battery drain problems. But I have noticed that it is a bit slower - I think. And I haven't upgraded the phone as my app that keeps my gas mileage records doesn't run under 11.

Well, I just learned another way place PDF's on the website. Check out the Using PDF tab that replaced the Using Word Doc tab. I think that Google can find the words/numbers in it, but we won't know for sure for several days.

[Ford F834]

Well, I just learned another way place PDF's on the website. Check out the Using PDF tab that replaced the Using Word Doc tab. I think that Google can find the words/numbers in it, but we won't know for sure for several days.

That works nice Gary, I hope google searches work 👍

[Gary Lewis]

Well, I just learned another way place PDF's on the website. Check out the Using PDF tab that replaced the Using Word Doc tab. I think that Google can find the words/numbers in it, but we won't know for sure for several days.

That works nice Gary, I hope google searches work 👍

I just added the new way to post PDF's above the old way on the BW1345 tab on the Transfer Case page. Which do you like best?