Chainsaw Repair

How To Basics - Carb Fixes + Mods - IPL and Service Manuals => How To Basics and Fixes => Topic started by: 1manband on November 21, 2013, 11:22:51 pm

Title: specific time/area "caveman" spreadsheet
Post by: 1manband on November 21, 2013, 11:22:51 pm
if it's ok with you (cut4fun), would like to post it here.  thought about making $ on it, but this is much better. folks that do this kind of thing..... just want to share some info is all.

it's done, just need some editing. spent about 100+ hours putting this together.

let me know.  don't know how to pm on this site.

-joe
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on November 22, 2013, 01:15:05 pm
Have at it.     

2 ways to PM   Click the little white (http://cdn.smfboards.com/caf/images/im_off.gif)  under username or.
To PM someone just click on username and go from there.   Then on left side you will see, Send personal message
Title: Re: specific time/area "caveman" spreadsheet
Post by: farmboy on November 22, 2013, 09:05:43 pm
Awesome! looking forward to your input.  This is a great place to hang out.  Everybody is here to pass on what we have learned to help others.
Shep
Title: Re: specific time/area "caveman" spreadsheet
Post by: 1manband on November 23, 2013, 07:02:18 am
thanks.

the spreadsheet program used to make it is called micro$oft excel.  maybe a program called quattro pro can run it as well but unsure on that one.  maybe there is a free program out there that can as well, don't know.

hope folks may already have one of those programs installed.  i have an old pc.  it did not come with it.

-joe

Title: Re: specific time/area "caveman" spreadsheet
Post by: farmboy on November 23, 2013, 07:54:03 am
Excell comes in Microsoft Office.  My version is Office 2000 you don't have to have keycodes to install it. 
Shep
Title: Re: specific time/area "caveman" spreadsheet
Post by: 660magnum on November 23, 2013, 01:19:23 pm
Excell is the best one to use
Title: Re: specific time/area "caveman" spreadsheet
Post by: pops21 on November 24, 2013, 03:33:14 pm
. I'm all set to give it a shot. Found I have excel on my PC. I have been looking foward to this program for a looooong time.  I have been watching AS for it to be posted untill one man informed me to check this site. ;D
Title: Re: specific time/area "caveman" spreadsheet
Post by: 1manband on December 01, 2013, 11:23:04 am
here it is:

caveman STA v1.0 120113

size:  522KB (534656 bytes)
size on disk: 524 KB (536576 bytes)

file hashes (checksum):
CRC32: 9646D032
MD5:  243700B89D5EC21FCEB3CBFFFFC93187

EDIT:those sizes above are uncompressed.

open for everyone.  no PW.  know how secretive yall are.  hahaha.

enjoy

-joe



EDIT:  Removed the file, because the zip compression did not work.  Has been emailed as of 12/01/13 6pm....
 
Title: Re: specific time/area "caveman" spreadsheet
Post by: 660magnum on December 01, 2013, 11:40:06 am
There's nothing there but the title
Title: Re: specific time/area "caveman" spreadsheet
Post by: 660magnum on December 01, 2013, 11:54:07 am
.15 kB = 150 bites and is most likely just the label?
Title: Re: specific time/area "caveman" spreadsheet
Post by: 660magnum on December 01, 2013, 11:58:17 am
If it is a .XLS file, just Email it to cut4fun?
Title: Re: specific time/area "caveman" spreadsheet
Post by: 1manband on December 01, 2013, 12:14:58 pm
If it is a .XLS file, just Email it to cut4fun?

emailed it is.

the zzip program compressed it..... but only on my drive. wierd.

it wont go with attachment as is.  its over 400kb.

thanks 660
Title: Re: specific time/area "caveman" spreadsheet
Post by: 660magnum on December 01, 2013, 12:33:10 pm
cut4fun will work it out to get it posted?

We'll try to get it going?

he is not at his computer right now but will be back soon?
Title: Re: specific time/area "caveman" spreadsheet
Post by: 660magnum on December 01, 2013, 12:44:25 pm
The Excell spreadsheet is sometimes difficult for an individual to come by?

There is a freebe Office suite available that will run all the Microsoft office files. It is called LibeOffice.

http://www.libreoffice.org/
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 01, 2013, 05:09:04 pm
I'm where I can do it = home now.  If the file is just 400kb original please sent to email I gave you and I will embed it.
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 01, 2013, 05:12:34 pm
If it is a .XLS file, just Email it to cut4fun?

emailed it is.

the zzip program compressed it..... but only on my drive. wierd.

it wont go with attachment as is.  its over 400kb.

thanks 660

email it to the chainsawrepair email I sent you. Received nothing yet on this end.
Title: Re: specific time/area "caveman" spreadsheet
Post by: 1manband on December 01, 2013, 06:16:41 pm
just got back from visiting family.  a house full for the last 4 days wasnt enough!

just emailed it to cut4fun 6pm sunday

-joe
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 01, 2013, 06:40:54 pm
Wont let me link the file type it is.  caveman sta v1.0 120113.xlsm.
You cannot upload that type of file. The only allowed extensions are doc,gif,jpg,mpg,pdf,png,txt,zip.


Can you change to one of those and resend it?  I'm going to go try something with the download you sent me too.
Title: Re: specific time/area "caveman" spreadsheet
Post by: 1manband on December 01, 2013, 07:07:38 pm
Wont let me link the file type it is.  caveman sta v1.0 120113.xlsm.
You cannot upload that type of file. The only allowed extensions are doc,gif,jpg,mpg,pdf,png,txt,zip.


Can you change to one of those and resend it?  I'm going to go try something with the download you sent me too.

that is the full uncompressed file.

i can try the zip thing again and email it...

or maybe you can try right clicking on the file.  then click "send".  a "compress and send" choice appears.......  thats what i tried the second time.   it did not work for me. 

thats all i can do unless someone has an idea.

-joe

Edit:  cannot get the file into any other formats other than .zip or .pdf.
the file will not be able to work in .pdf format.
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 01, 2013, 07:34:45 pm
Send to me in pdf if you can.
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 01, 2013, 09:55:43 pm
The zip one you just sent.   

specific time/area "caveman" spreadsheet

REMOVED
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 01, 2013, 10:06:03 pm
It just worked for me if open with windows and then click the link there, excel opened up.   
Title: Re: specific time/area "caveman" spreadsheet
Post by: 660magnum on December 01, 2013, 10:14:53 pm
It all seems to work for me also. I ran it with LibeOffice.

Had to download the zipped file and extract the program and put it on my HD and this only took a couple clicks. Then just clicked on the file name and up it came.

The output extracted filename is caveman sta v1.0 120113.xlsm which only differs from the Zip file name by the .xlsm suffix.
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 01, 2013, 10:21:43 pm
All way over my head. 

Now I'll set back and learn from you smart folks.
Title: Re: specific time/area "caveman" spreadsheet
Post by: countryhog on December 12, 2013, 01:40:06 pm
where does one acquire said file?
Title: Re: specific time/area "caveman" spreadsheet
Post by: 660magnum on December 12, 2013, 03:33:43 pm
In the bottom of the first post on this page
Title: Re: specific time/area "caveman" spreadsheet
Post by: 1manband on December 14, 2013, 01:13:37 pm
folks......

asked cut4fun to remove version 1 from download.  if any of you have it, dump it.

some calculations, are not working,  which will prevent the program from listing the target port sizes for the modified motor.

the offline version works on my computer, when i hid the calculations for the online download version, it prevented a few calculations from working at all.

my mistake.  appreciate the patience with this.  i am not a expert programmer, just know some math, and want this to work correctly.  will be fixed soon.

-joe

ps: next time, i will test the encrypted version as well.  wont make that error again.

Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 22, 2013, 08:01:00 pm
new version caveman 1.1 spreadsheet

Says wont open.. Going to try something else.

Removing link.
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 22, 2013, 09:33:00 pm
Try again.

 Cant get it to open here when in zip and get  this when try different way.  ???

caveman_version_1.1__122213[1].xlsm.
You cannot upload that type of file. The only allowed extensions are doc,gif,jpg,mpg,pdf,png,txt,zip.
Title: Re: specific time/area "caveman" spreadsheet
Post by: KilliansRedLeo on December 23, 2013, 06:42:05 pm
OK, all: I just repaired the .zip file problem for Joe! The .zip file is 1MB in size and is a single layer zip file. It contains the caveman.xls file. The repaired file is in Kevin's gmail mailbox, so he still has to upload it to the site for use.

Remember that this is a multi-sheet spreadsheet. There are tabs across the bottom, when you point to a tab with your mouse and click that portion of the spread sheet will be presented to you.

I'll bet no one knows who actually invented the mouse... and no it wasn't that idiot Al Gore!

Enjoy
TJ Holcomb
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 23, 2013, 07:46:36 pm
new version caveman 1.1 spreadsheet

That new file download looked and went the right way. Should work for you guys. 

LINK REMOVED
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 23, 2013, 07:50:43 pm
Not opening. Needs saved in different format that is inside the zipped folder.  Zip folder will upload here but I cant get the excel file to open.  Out of my league. 

Anyone figures out how to open to read let us know.
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 23, 2013, 08:52:40 pm
If I click and save to HD on puter. I then can open file excel spread sheet from there.
Title: Re: specific time/area "caveman" spreadsheet
Post by: 660magnum on December 23, 2013, 09:59:34 pm
Archive:  /home/Documents/caveman version 1.1  122213.zip
[/home/Documents/caveman version 1.1  122213.zip]
  End-of-central-directory signature not found.  Either this file is not
  a zipfile, or it constitutes one disk of a multi-part archive.  In the
  latter case the central directory and zipfile comment will be found on
  the last disk(s) of this archive.
zipinfo:  cannot find zipfile directory in one of /home/Documents/caveman version 1.1  122213.zip or
          /home/Documents/caveman version 1.1  122213.zip.zip, and cannot find /home/Documents/caveman version 1.1  122213.zip.ZIP, period
Title: Re: specific time/area "caveman" spreadsheet
Post by: 660magnum on December 23, 2013, 10:12:36 pm
looks to me like it is a ZIPPED zip
Title: Re: specific time/area "caveman" spreadsheet
Post by: KilliansRedLeo on December 23, 2013, 10:20:36 pm
OK guys there is nothing wrong with the spread sheet. The only reason the file was zipped up is because the forum software will not let you upload an excel (.xls) spread sheet. If you have the free utility winzip from www.winzip.com on your computer the file will download to your machine and winzip will unzip the file and excel will start.

So, the key here is that Joe zipped the spreadsheet up just so he could get it to Kevin. At which time Kevin could either unzip the file and make the .xls file available to you or leave it alone and you could unzip it on your computer.

The way it is set up now you need winzip on your computer.

Kevin I will PM you with a number you can call me at.
Title: Re: specific time/area "caveman" spreadsheet
Post by: KilliansRedLeo on December 23, 2013, 10:32:18 pm
Correct 660, that was the original problem. You can do something called a multi layer zip file. The file I sent Kevin this evening was a single layer zip file e.g. a single .xls file that has been compressed by Winzip.

I have just tested the current file on 6 different computers:
Microsoft Windows Enterprise Server 2008
Microsoft Windows XP
Microsoft Windows Vista
Microsoft Windows 7
ASUS Android 4.1 Ice Cream Sandwich
Apple IPad
And even my wife's smart phone.

It works everywhere! As long as you have Winzip installed on your computer and something that can process zip files.
Title: Re: specific time/area "caveman" spreadsheet
Post by: 660magnum on December 23, 2013, 10:47:43 pm
I still proclaim that it has been double zipped. Or it was already a zipped file that someone added another .zip suffix to it?  (zip.zip)
Title: Re: specific time/area "caveman" spreadsheet
Post by: KilliansRedLeo on December 23, 2013, 10:53:57 pm
I agree that is exactly what either joe or Kevin did. The file attatched to this has a .zip extension but it is a text document created by microsoft notepad. If you download it and save it on your computer you change the name back to test.txt and notepad will open it.

ObTW, I am not throwing rocks but trying to get to the bottom of this problem.

I just did exactly as stated above and it worked. So the forum software is NOT checking the internal file format only the extension for one of the allowed types.

So, the next question is if a file with and extension other than those covered by upload restrictions can be downloaded.

If joe were to send Kevin the XLST file with a zip extension but not really a zip file then Kevin could change the extension to .XlsT and it could be directly downloaded.

So I just added a second attachment, it is an excel file (foo.xls) that I just changed the name to foo.zip. the point here is to test if I can upload and download an xls file named zip and use it as an xls file after changing the name back to xls.

That worked, son now all we hav left to test is if I send Kevin the file and see if he can do it on his end.
Title: Re: specific time/area "caveman" spreadsheet
Post by: KilliansRedLeo on December 24, 2013, 08:14:15 am
One other thought, the file 'caveman version 1.1 122213.zip' actually contains a .xlsm file not an .xls file created older versions of excel which could only create .xls files. I used Microsoft Excel 2007 for the tests I ran.

An .xlsm file contains multiple spread sheets MS refers to as an Excel 'workbook'. That is data can be moved from individual calculations in one sheet to other sheers within the same workbook.

Since only certain later versions on Excel recognize and can process .xlsm files, perhaps that is the problem you re ruining into when you get the file to your computer.

Additionally, perhaps Kevin uses the same method for uploading files as users do, just not restricted in size. So, when I hear from Kevin we will find out and can figure out a way to fool the software. In an earlier post I demonstrated how we can fool the software just by changing the file extension without really changing the file itself. So, perhaps that is the key.
Title: Re: specific time/area "caveman" spreadsheet
Post by: countryhog on December 24, 2013, 08:41:48 am
can't get anything to work. whether its .xls or .xlsm doesn't matter to me since i've got newer version of excel. also, the file might be dependent upon features included in the newer version of excel to it might be .xlsm anyway.
if the file were merely zipped as a spreadsheet, either .zip or .exe then i could probly open it. changing the extension from .zip to .xls has proven to be a problem for me since i can't get the file extensions to show up in my explorer. looks like i'm a dunderhead or microsoft has finally fixed us. lol
Title: Re: specific time/area "caveman" spreadsheet
Post by: KilliansRedLeo on December 24, 2013, 09:20:42 am
Go to control panel/files and folders/ there you will see tabs across the top in one of them there is a checkbox that says 'hide extensions of known file types', uncheck it if it is checked (default)

The file IS an .xlsm file, if you change the extension to anything but that it will not work correctly.
Title: Re: specific time/area "caveman" spreadsheet
Post by: KilliansRedLeo on December 24, 2013, 09:35:30 am
how to unhide file extensions

The last screenshot is why the file MUST be an XLSM file in order to work....and YES it is a macro enabled workbook however it could be saved as a .xlsx spread sheet but Joe would have to test to make sure all was working in that format.
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 24, 2013, 10:13:24 am
So your saying all folks need is that unzip program downloaded ( you showed) to their puters. To open the link I embedded straight from the site?

 Files types etc is all xyz to me, all just a foreign language to me. Like I have said before,not a puter person.


I remember having upzip downlad back in the late 90's maybe early 2000's but never had a need for it since. 

Thanks if thats all folks is needing.
Title: Re: specific time/area "caveman" spreadsheet
Post by: 1manband on December 24, 2013, 10:44:40 am
howdy folks

2007 excel was used.  no experience with trying this file on newer versions, (at least until next week) to be sure of compatibilty.

sorry about all the confusion issues with opening the file.  my knowledge of websites is nil.  killiansredleo schooled me on zipping yesterday.  appreciate his and cut4funs time and help.

if someone that wants to give it a go, after exhausting the options, and still cannot get it opened.  willing to send out a cd in the mail for those folks.  pm me if this is the case.

enjoy the holidays!

-joe
Title: Re: specific time/area "caveman" spreadsheet
Post by: KilliansRedLeo on December 24, 2013, 11:02:50 am
Just a clarification, if what you are looking for is to have the spread sheet operate from the forum like viewing a YouTube video, that is not going to happen. A web service that would be able to do that would need a back end application server to process the user requests from users to excel and keep all user data on the forum and keep all user data separate from each other.

Joe's spread sheet is designed to run on 'your' computer where it can communicate directly with excel on your computer and keep your data on your computer, the whole .zip file thing is only there to get past upload restrictions placed on us by the forum software and has nothing to do with Caveman.

If as noted before if you can get the .zip file from the site to your computer, unzip it and save the resulting .xlsm file on your computer it will run when you click on the caveman file, just as Kevin noted earlier.
Title: Re: specific time/area "caveman" spreadsheet
Post by: KilliansRedLeo on December 24, 2013, 12:27:10 pm
I also thought that I should mention that there is no way to make a self executing Excel spread sheet. That would be one that would run on your computer without Excel or any other program that could process Excel files installed on your computer.

There are free alternatives to excel that may work for the caveman file, as mentioned earlier. I use a free one called 'Kingsoft Office' on my Android tablet that will run caveman.
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 24, 2013, 01:46:01 pm
On break from family right now.  So real  quick.

 Instead of CD being needed like 1manband said he could do.   I have a copy on HD puter, is it TJ? and joe has a copy now that could be emailed to folks wanting to go that route?  Yes?

If so folks could PM us or post here to contact us then email us.  IF unable to open from site where embedded above.

Also I can send copy to Jim 660mag so he can email too. He is the only other person besides me that can see emails without needing to be  sent  a PM to do so.
Title: Re: specific time/area "caveman" spreadsheet
Post by: KilliansRedLeo on December 24, 2013, 03:17:46 pm
My name is Tim, and I don't have a problem e-Mailing the file to members. However I did not create the spreadsheet and it is not my intellectual property, it belongs to Joe. So he would have to make the decision on who gets to distribute the file.

We could also research a freeware spreadsheet processor that will work with Joe's file and point users to where they can get it free. Or could mail it out with the file. Along with instructions on how to install the software and Joe's file.

If we did it this way Joe would get to make the contribution to the chainsaw community and you would not have to pay for storage for it
Title: Re: specific time/area "caveman" spreadsheet
Post by: KilliansRedLeo on December 24, 2013, 05:27:17 pm
Being that the spreadsheet that Joe created is a Macro enabled spread sheet (file extension .xlsm). Joe's work can be protected simply locking the Macros with Joe being the only person with the password. People will still be able to run and use the spread sheet, just not alter the design, operation or even the ability to see the Macros. As Joe states the formulas used to make the calculations have been in the public domain for 20 years!

Joe's genius and work was in translating those formulae into Excel macros so that we could all benefit! The time and effort Joe spent developing Caveman is what must be protected.

The technique of making the macros unalterable or even visible to the end user can be simply done by Joe himself. In fact when Xerox internally published spread sheets to its' global divisions and the branch offices to collect and process financial data the macros were routinely password protected in order to meet 'Sorbaines Oxley' legal requirements.
Title: Re: specific time/area "caveman" spreadsheet
Post by: 1manband on December 24, 2013, 07:03:49 pm
idea was just to make this porting program available was the goal.
nothing groundbreaking.  the formulas were out there. 

software is out there that will do much much more than this... and give more accuracy than what i have presented.  if you need that kind of accuracy, the issue becomes that it is pay to play only.

mine does not include anything to do with modeling compression, combustion, squish, etc.  those are needed for accuracy.  personally have never ran one of these kind of softwares for a 2 stroke.

wanted mine to be made available for free, and hopefully easy enough to use for the members here.  realize that its not everyones bag.  no worries.  if it helps someone out then great.

regards
-joe
Title: Re: specific time/area "caveman" spreadsheet
Post by: countryhog on December 30, 2013, 09:36:11 pm
did what red said and changed the file extension to xlsm. still no go. guess i need someone to email me a copy. who should i pm my addy to?
Title: Re: specific time/area "caveman" spreadsheet
Post by: 1manband on December 31, 2013, 07:35:21 am
i  as well, cannot open the file as posted here on the site.

older laptop, running window$ xp.  downloaded the file from this site.  then, choose "save" (instead of "open"). 

clicked on the file to open it.

box came up on screen:

Compressed (zipped) Folders

Please insert the
last disk of the
multi-volume set
and click to continue.

two choices:  1. either click "ok"  OR   2. click "cancel"

clicked "ok".......  nothing happens.

-joe
Title: Re: specific time/area "caveman" spreadsheet
Post by: 1manband on December 31, 2013, 07:40:43 am
did what red said and changed the file extension to xlsm. still no go. guess i need someone to email me a copy. who should i pm my addy to?

pm me.  if anyone else needs it emailed, will do a mass email.

-joe
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on December 31, 2013, 03:14:07 pm
Going to go through and remove links then.

Let's just use email for those wanting to try it.   Sound good 1manband?
Title: Re: specific time/area "caveman" spreadsheet
Post by: 1manband on December 31, 2013, 03:59:21 pm
ok w/me.
Title: Re: specific time/area "caveman" spreadsheet
Post by: KilliansRedLeo on January 01, 2014, 05:44:31 pm
I can do that but we should put a copy somewhere on the site so we are all mailing out the same version. If that is possible!
Title: Re: specific time/area "caveman" spreadsheet
Post by: Cut4fun . on January 01, 2014, 07:56:48 pm
Dont seem we can put it on the site and get it to work.  I have the last one 1man and killred sent me.  I'l

l just let you 2 do the sending and I'll be a back up means if needed.  That way you can control it if you never password protected it.