A lot has been written on the use of excel in knit charting, I don’t believe there is anything “out there” on doing the same with Numbers. After my latest OS upgrade, I thought I would revisit playing with the updated program. This is not a tutorial as such, just a sharing of some results and observations on this particular effort. For the design, I used the same motif as in the last post on 2 color drop stitch on Japanese machines. Under the table menu, there is an option to split rows or split columns. This can be achieved in any selected area, without affecting the remainder of the spreadsheet. Copying and pasting the split image over an area of full-size cells will change its format, and in turn, allow for splitting again. In the image below A is the original motif, B the first split after selecting only those colored cells, C repasting B in an area of full-size cells, D selecting and splitting C to achieve elongating the original motif X 4.
to separate the colors for the 2 color drop stitch using white “erase” every other row: these rows will result in no pattern selection, and will be the rows on which stitches are dropped. Select and copy and paste again. Choose either of the 2 colors and white-out that color (I chose to start with cyan) on the first and then every other colored combination row. Note there are 3 blank rows between each “erasure” after the first. Once the process is completed to the top of the design, select, copy, and paste again. On alternate rows that are still in 2 colors, the magenta can now be whited out, and this repeat when complete, visually be checked for any errors. Colored squares remaining in either color now translate to punched holes or black squares on mylar depending on the size of the original motif
This particular method works on even motifs with an even number of colors, as splits double existing rows. Row and stitch numbers, text, etc may all be added. The image below does not refer to color separations. It illustrates the ability to go twice as long, twice as wide through using splitting rows, and in turn, splitting columns. Twice as wide used alone comes in handy for any knitting on every other needle, sometimes used for thicker yarns on the standard machines that do not have the ability to do that via electronic programming.
WordPress will not allow uploading a numbers document; here is a numbers document exported as excel .xls that should open in Numbers on a Mac for anyone wanting to play with charting a bit. The extra color square on the far right is a “place holder” of sorts, needed to avoid cropping of all empty cells to the right of the motif in the software’s exporting the file numbers_test_doc
4/30/2018: the feature described below in 2012 disappeared from later versions of numbers, I am presently using version 5.0. Later versions offered these options for working with rows and columns. The highlighted row will be duplicated, a slower process than simply splitting cells. A positive feature is that an individual table may be changed while still within view on other tables on a single sheet, without globally affecting the document. 
While playing with more table options today I sorted out a way of creating blank rows between design ones, possible charting uses still TBD. Though the results from such charting are not capable of being downloaded directly into knitting software, they are a good way to sort out repeats and begin to understand and create any necessary color separations. By holding the command key, rows on the table can be highlighted and hidden as a group. I chose all the even-numbered rows. The repeat then is drawn. When it is complete, rows originally targeted for hiding are “unhidden”, leaving the design motif with a blank row between each design row, at twice its length. Hiding could take place at irregular intervals as well. 
December 8, 2012: in writing my latest post I found an easier way to deal with split rows and columns. If the motif area is copied and pasted on a “blank” part of the spreadsheet a new table is created, which can be altered without concerns about affecting the remainder of the document. It’s like working with small pieces of graph paper rather than a very large one. The motif area is chosen and pasted, creating a new table
the table, split into row option is used
simply select all, click on the line at bottom of any numbered, grey row cell on the left of the table, and resize to match the remainder of your document, when the desired measurement is achieved, release the mouse and the document cells will be uniform in size.
the same process may be applied to split columns, may well have to try this on some of my huge excel charted spreadsheets





Images from left to right
purl side
The emerging pattern can be seen, and to be noted is the elongation factor involved as in many color separation DBJ fabrics


The explanation: further analysis of the original design reveals the fact that some of the pixel numbers in the design black square blocks are uneven in width. In this instance, 3.5 is half of 7, and half pixels cannot be rendered, so the software assigns the split to 4 and 3.
A 




an isolated repeat segment worked out on a striped template after choosing and marking the transfer direction of the eyelets on the original, green for to the left, yellow for to the right, 




the symbols key for this post
a multiple transfer stitch charted for machine knitting
location for holes, and directions for lace carriage transfers on the next row
the punched card and associated actions
going wider, and combining different size motifs
the expanded version
An alternative way of working: colors are chosen for horizontal lines on which holes for transfers are placed, in the direction indicated by the inspiration chart
The equivalent mylar repeat 








May 24, 2019 a greyscale mode scaled image processed in 

The image is used with the kind permission of Rocco’s owner. I have used this image before, when I posted previously on some ways to reduce colored images to B/W for possible knitting using a Mac computer, please see post on 013/03/14/ color-reduction- conversions-mac-os/. Gimp offers some alternatives to the familiar dithers and is available, free, for both PC and Mac platforms. Tutorial links on Gimp edge detection available online as of May 2019 are listed at bottom of the post.



Difference of Gaussians






adjusting B/W with Threshold
after a bit of “tweaking”
Image_Mode_Indexed, rendering it “knittable in 2 colors” 








default Stucki




Check dithered results, downloaded images may be in RGB Mode. Prior to any knitting, they will need to be converted to B/W indexed.
imported the result into Gimp and saved it in indexed 2 color BW and in turn, 3 color indexed mode, no color adjustments, finding the result pleasantly simple
beginning with the greyscale generated image followed by Mode changes in Gimp, indexed 2 color BW, then indexed 3 color, there appear to be very subtle differences with a bit more detail: 

It is possible to reduce images to 4 or 3 colors using the program as well: a slider for color count is used to choose the final number of colors in the reduction. Again, these instances have no added manipulation 
To retain the quality and size of the dithered image, download it, rather than using a screen grab. The software used to separate the chosen dither may alter the result somewhat. I am writing my posts using an iMac M1 with OS 12.0.1. At this point Ayab is not operable, img2track does open images, but in this case, with interesting distortions, and it does not download any files at all.
Yet another dithering 




















