Author Topic: specific time/area "caveman" spreadsheet  (Read 612 times)

0 Members and 0 Guests are viewing this topic.

Offline Cut4fun .

  • Administrator
  • Nitro Hotsaw
  • *******
  • Posts: 22076
  • Karma: 548
  • OHIO REDNECK Saw Repair Getter Done
    • Redneck Chainsaw Repair
Re: specific time/area "caveman" spreadsheet
« Reply #30 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
REDNECK Saw Repair Getter Done

Offline Cut4fun .

  • Administrator
  • Nitro Hotsaw
  • *******
  • Posts: 22076
  • Karma: 548
  • OHIO REDNECK Saw Repair Getter Done
    • Redneck Chainsaw Repair
Re: specific time/area "caveman" spreadsheet
« Reply #31 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.
REDNECK Saw Repair Getter Done

Offline Cut4fun .

  • Administrator
  • Nitro Hotsaw
  • *******
  • Posts: 22076
  • Karma: 548
  • OHIO REDNECK Saw Repair Getter Done
    • Redneck Chainsaw Repair
Re: specific time/area "caveman" spreadsheet
« Reply #32 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.
REDNECK Saw Repair Getter Done

Offline 660magnum

  • Global Moderator
  • Nitro Hotsaw
  • *******
  • Posts: 6437
  • Karma: 249
  • For The Love Of Chainsaws
  • Location: NCO
Re: specific time/area "caveman" spreadsheet
« Reply #33 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
We should share what we know... someone may learn...
That knowledge can live after us... and that "Pays It Forward".
Be all that you can be . . .

Offline 660magnum

  • Global Moderator
  • Nitro Hotsaw
  • *******
  • Posts: 6437
  • Karma: 249
  • For The Love Of Chainsaws
  • Location: NCO
Re: specific time/area "caveman" spreadsheet
« Reply #34 on: December 23, 2013, 10:12:36 pm »
looks to me like it is a ZIPPED zip
We should share what we know... someone may learn...
That knowledge can live after us... and that "Pays It Forward".
Be all that you can be . . .

Offline KilliansRedLeo

  • Nitro Hotsaw
  • *******
  • Posts: 2361
  • Karma: 80
  • Location: Rochester, NY
    • RoCHusqvarna
Re: specific time/area "caveman" spreadsheet
« Reply #35 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.
"When the people fear the government...you have tyranny....When the government fears the people....you have liberty"

Thomas Jefferson
1743-1826

Offline KilliansRedLeo

  • Nitro Hotsaw
  • *******
  • Posts: 2361
  • Karma: 80
  • Location: Rochester, NY
    • RoCHusqvarna
Re: specific time/area "caveman" spreadsheet
« Reply #36 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.
"When the people fear the government...you have tyranny....When the government fears the people....you have liberty"

Thomas Jefferson
1743-1826

Offline 660magnum

  • Global Moderator
  • Nitro Hotsaw
  • *******
  • Posts: 6437
  • Karma: 249
  • For The Love Of Chainsaws
  • Location: NCO
Re: specific time/area "caveman" spreadsheet
« Reply #37 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)
We should share what we know... someone may learn...
That knowledge can live after us... and that "Pays It Forward".
Be all that you can be . . .

Offline KilliansRedLeo

  • Nitro Hotsaw
  • *******
  • Posts: 2361
  • Karma: 80
  • Location: Rochester, NY
    • RoCHusqvarna
Re: specific time/area "caveman" spreadsheet
« Reply #38 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.
"When the people fear the government...you have tyranny....When the government fears the people....you have liberty"

Thomas Jefferson
1743-1826

Offline KilliansRedLeo

  • Nitro Hotsaw
  • *******
  • Posts: 2361
  • Karma: 80
  • Location: Rochester, NY
    • RoCHusqvarna
Re: specific time/area "caveman" spreadsheet
« Reply #39 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.
"When the people fear the government...you have tyranny....When the government fears the people....you have liberty"

Thomas Jefferson
1743-1826

 

Related Topics

  Subject / Started by Replies Last post
12 Replies
148 Views
Last post January 24, 2014, 07:53:05 pm
by SDB777
9 Replies
369 Views
Last post January 24, 2014, 04:16:01 am
by Magnus
6 Replies
423 Views
Last post May 07, 2014, 05:19:23 pm
by SawTroll
6 Replies
264 Views
Last post November 08, 2014, 09:59:01 pm
by Cut4fun .
3 Replies
787 Views
Last post March 11, 2015, 07:31:43 pm
by Cut4fun .
7 Replies
472 Views
Last post September 11, 2015, 03:44:31 pm
by Cut4fun .
5 Replies
230 Views
Last post April 15, 2016, 09:09:13 pm
by SawTroll
0 Replies
150 Views
Last post April 30, 2016, 09:48:31 am
by Cut4fun .
0 Replies
199 Views
Last post December 06, 2016, 01:16:42 am
by weimedog
1 Replies
190 Views
Last post April 11, 2017, 01:43:42 pm
by Cut4fun .