O
O5O
A line drawn in Microsoft Excel seem here, not to be a line at all.
I was trying to find patterns for number factors, and started working
on this rather large 80MB spreadsheet to illustrate. I know this is
probably not the proper venue for doing this kind of work, but it
seemed appropriate for me at the time to try and get a handle on the
problem.
You can get the spreadsheet here, but it will probably take an hour to
download if you are the only one trying to get it. If you are sharing
bandwidth with someone else, it will obviously take longer.
http://christoffur.hopto.org/PrimesFL/FactorTableWithDiagonals32+65.xls
or you can view just the printed output in jpeg form here:
http://christoffur.hopto.org/PrimesFL/index.shtml
The problem here is with the line drawing from View->Toolbars->Drawing-
However when the slope becomes large enough, the lines begin to do
weird things in the spreadsheet like instead of piercing a gray cell
in the middle, it will walk around the outside and usually to the
left. After around line 28 I began to notice this behavior, and the
problem became more pronounced as the slopes of the lines continued to
increase.
When the pages of the spreadsheet are printed out separately, the
lines are no longer continuous, nor intersect the page boundaries at
the correct horizontal cell location, but become discontinuous
independent lines for each page with incorrect slopes and intercepts.
This of course makes tracking the higher order slopes by the use of
line drawing commands virtually impossible, unless perhaps if I were
of course to break the lines up into shorter segments that do not
extend page boundaries. Maybe. I haven't tried this yet, but it will
only work if the slopes can be reproduced accurately, which seems on
its face unlikely.
What we know is that all of the cells from E to ED have a common
column width of 10, and a row height of 14.25 making the slopes of the
angles between consecutive diagonal cells consistent. It appears
however that there are certain angles which Microsoft Excel is unable
to reproduce reliably. At least I have not yet been able to determine
how to acheive this feat.
As you can see from the spreadsheet output, the angles of low slope
which Excel is able to reproduce reliably are of no significant
interest because there are basically no interferring, or column
sharing lines. Where the slope is large and might reach closer and
closer to infinity, that is where the interest begins, but because
Excel is unable to correctly intersect the appropriate cells, the
excercise is at this point futile.
Any help from anyone with experience in this area would be greatly
appreciated.
Regards from,
Chris.
I was trying to find patterns for number factors, and started working
on this rather large 80MB spreadsheet to illustrate. I know this is
probably not the proper venue for doing this kind of work, but it
seemed appropriate for me at the time to try and get a handle on the
problem.
You can get the spreadsheet here, but it will probably take an hour to
download if you are the only one trying to get it. If you are sharing
bandwidth with someone else, it will obviously take longer.
http://christoffur.hopto.org/PrimesFL/FactorTableWithDiagonals32+65.xls
or you can view just the printed output in jpeg form here:
http://christoffur.hopto.org/PrimesFL/index.shtml
The problem here is with the line drawing from View->Toolbars->Drawing-
multiples of 15 degrees, and this was the best I could come up with.
However when the slope becomes large enough, the lines begin to do
weird things in the spreadsheet like instead of piercing a gray cell
in the middle, it will walk around the outside and usually to the
left. After around line 28 I began to notice this behavior, and the
problem became more pronounced as the slopes of the lines continued to
increase.
When the pages of the spreadsheet are printed out separately, the
lines are no longer continuous, nor intersect the page boundaries at
the correct horizontal cell location, but become discontinuous
independent lines for each page with incorrect slopes and intercepts.
This of course makes tracking the higher order slopes by the use of
line drawing commands virtually impossible, unless perhaps if I were
of course to break the lines up into shorter segments that do not
extend page boundaries. Maybe. I haven't tried this yet, but it will
only work if the slopes can be reproduced accurately, which seems on
its face unlikely.
What we know is that all of the cells from E to ED have a common
column width of 10, and a row height of 14.25 making the slopes of the
angles between consecutive diagonal cells consistent. It appears
however that there are certain angles which Microsoft Excel is unable
to reproduce reliably. At least I have not yet been able to determine
how to acheive this feat.
As you can see from the spreadsheet output, the angles of low slope
which Excel is able to reproduce reliably are of no significant
interest because there are basically no interferring, or column
sharing lines. Where the slope is large and might reach closer and
closer to infinity, that is where the interest begins, but because
Excel is unable to correctly intersect the appropriate cells, the
excercise is at this point futile.
Any help from anyone with experience in this area would be greatly
appreciated.
Regards from,
Chris.