EScanlon Posted October 22, 2005 Share #25 Posted October 22, 2005 What about scanning a copy of the MF into Textbridge, Omnipage, or other OCR, and exporting the file to Access, and setting up a relational file set?That way all models and parts would be covered, and the supercession data could be used to filter for model specific entries.Leave it to me to complicate the crap out of something...WillGeez, after Chris' remark about being too anal and now you're complaining about over-complicating something. What's going to happen next?As far as a relational database, I bought one from a guy on the Roadster list, but unfortunately it's in Access 2000 and I only have 97. Since I've not been able to open it I'm not sure of what it will / won't do. I'm not sure if it can be saved in an older version of Access, but if someone with Access 2k is willing to try or knows.....Enrique Link to comment https://www.classiczcars.com/topic/17680-restoration-spreadsheets/?page=3#findComment-142641 Share on other sites More sharing options...
Zak's Z Posted October 22, 2005 Share #26 Posted October 22, 2005 ESCANLON, I have Excel 2k, and if you wanna email that thing to me, Ill save it as an Excel 97 for you. I just saw this thread, and I'd love a spreadsheet for a 240z, I have the fiche cd, and ill do what needs to be done on my part over here...Zak Link to comment https://www.classiczcars.com/topic/17680-restoration-spreadsheets/?page=3#findComment-142647 Share on other sites More sharing options...
26th-Z Posted October 22, 2005 Share #27 Posted October 22, 2005 Enigma's comment made me chuckle. Thanks.It's too late for me to start counting beers. The horse is already out of the barn. And knowing me, I wouldn't keep up with a spreadsheet anyhow. I think all of you would be impressed enough that I have a file cabinet with labeled file folders. I actually found a contact I made two years ago and finally ordered the other day! I was impressed.What webdawg has done is organize his restoration plan. By going through the parts fiche and selecting his applicable part, he has begun to organize his work schedule. He has a grasp of the total amount of work. He might use the spreadsheet to select all the parts that go to a powder-coater or all the parts that go to the machine shop and realize some economy in his restoration. Time could be added to the list in order to help keep the project moving. I could imagine programming a calendar to provide a little pop-up smiley on the computer screen that says; "Time to buy your new cam sprocket, Mr. webdawg". Or; "Pick up your parts from Thrashwell & Snailby today!!!"What's important is that these spreadsheets represent a restoration plan. Some sort of organization that will help account for the mess created when a Z car is taken apart. These little Datsuns are easy cars to work on, really. A spreadsheet like these are a big help and pretty easy to make.Thanks again Link to comment https://www.classiczcars.com/topic/17680-restoration-spreadsheets/?page=3#findComment-142650 Share on other sites More sharing options...
EScanlon Posted October 22, 2005 Share #28 Posted October 22, 2005 Zak: Thanks for the offer but Access databases cannot be opened with Excel and vice versa. Enrique Link to comment https://www.classiczcars.com/topic/17680-restoration-spreadsheets/?page=3#findComment-142653 Share on other sites More sharing options...
Zak's Z Posted October 22, 2005 Share #29 Posted October 22, 2005 I dont know why I said Excel. I MEANT to say access. I have the MS visual studio..I think I was looking at one of the spreadsheets while I was typing...my bad.Zak Link to comment https://www.classiczcars.com/topic/17680-restoration-spreadsheets/?page=3#findComment-142655 Share on other sites More sharing options...
hls30.com Posted October 22, 2005 Share #30 Posted October 22, 2005 Enrique, I have MsOffice Pro in every release.Will Link to comment https://www.classiczcars.com/topic/17680-restoration-spreadsheets/?page=3#findComment-142661 Share on other sites More sharing options...
EScanlon Posted October 23, 2005 Share #31 Posted October 23, 2005 I got it to run after loading the Access 2k Jet Engine. I'll upload it as a Zip file.The database is specifically for Roadsters and it has pictures on the forms, but apparently the writer; Matt Silvey did not leave the database open to be able to modify the forms / code / database. Then again that might be because of just having the Jet and not the full version.The db has 3 screens separate from the main, and the resolution must be fixed for 1024 x 768 as the forms exceed the screen size alloted, but that again may be due to it being on the Jet and not the full.EnriqueOOPS. Upload manager says it's too big. 2.75MbI'll e-mail it to those that have sent me an e-mail.Sorry, and thanks. Link to comment https://www.classiczcars.com/topic/17680-restoration-spreadsheets/?page=3#findComment-142700 Share on other sites More sharing options...
webdawg1 Posted October 23, 2005 Author Share #32 Posted October 23, 2005 Here's some more spreadsheets I currently have done that can be posted for general use by all concerned...Fiche section 91-1 is still << inwork >> (will post this one at a later date)Remember to makes any changes to the spreadsheet(s) based on your model year as there will be "some" differences between model years...but for the most part should be pretty accurate...34-1 (E.F.I - L28E - Dec 74 - Jul 77)93-1 (Hand Brake & Hand Brake Cable)Fiche 34-1 (E.F.I - L28E Dec 74-Jul 77).xlsFiche 93-1 (Hand Brake & Hand Brake Cable).xls Link to comment https://www.classiczcars.com/topic/17680-restoration-spreadsheets/?page=3#findComment-142738 Share on other sites More sharing options...
sideshowbob Posted October 27, 2005 Share #33 Posted October 27, 2005 Those that don't have access 2k should be able to use open office (if you're able to d/l it). Link to comment https://www.classiczcars.com/topic/17680-restoration-spreadsheets/?page=3#findComment-143298 Share on other sites More sharing options...
webdawg1 Posted October 27, 2005 Author Share #34 Posted October 27, 2005 Here's the link for Open Office v2.0 in case you need it...http://www.openoffice.org/webdawg1 Link to comment https://www.classiczcars.com/topic/17680-restoration-spreadsheets/?page=3#findComment-143402 Share on other sites More sharing options...
webdawg1 Posted October 31, 2005 Author Share #35 Posted October 31, 2005 Here's some more spreadsheets I currently have done that can be posted for general use by all concerned...Fiche section 91-1 is still << inwork >> (will post this one at a later date)Remember to makes any changes to the spreadsheet(s) based on your model year as there will be "some" differences between model years...but for the most part should be pretty accurate...webdawg1Fiche 29-1 (Manifold EGR L28E Dec 74 - Jul 76).xlsFiche 35-1 (E.F.I - Air Flow - L28E From Dec 74).xlsFiche 41-1 (Accelerator L28E From Dec '74).xlsFiche 94-1 (Front Brake).xlsFiche 95-1 (Rear Brake).xls Link to comment https://www.classiczcars.com/topic/17680-restoration-spreadsheets/?page=3#findComment-143798 Share on other sites More sharing options...
webdawg1 Posted November 13, 2005 Author Share #36 Posted November 13, 2005 Here's a couple more spreadsheets that I currently have done that can be posted for general use by all concerned...Remember to makes any changes to the spreadsheet(s) based on your model year as there will be "some" differences between model years...but for the most part should be pretty accurate...webdawg1Fiche 91-1 (Rear Axle & Drive Shaft).xlsFiche 134-1 (Floor Console & Ash Tray).xls Link to comment https://www.classiczcars.com/topic/17680-restoration-spreadsheets/?page=3#findComment-145715 Share on other sites More sharing options...
Wilbur
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now