Thanks for sharing this, Sherwood. I'd probably have exported a CSV and
written a Python program to do the conversions, but solving the problem
using Excel itself is a much better solution. :)
On 2 February 2014 08:33, Sherwood Botsford <sgbotsford at gmail.com>
wrote:
> While MMD is wonderful, much of the time you want to do other things with
> the data first.
>
> My problem: I have a whole bunch of small tables I keep on an excel
> spreadsheet for setting my prices for various numbers of trees and whatnot.
>
>
> Here's a couple recipes for using excel data.
>
> Layout your spreadsheet as normal.
> Insert a blank row for the formating row.
> Create a wide column to the right of your table
>
> Each row corresponding to a table row has a formula something like this:
>
> "|"&A1&"|"&B1&"|"&C1...
>
> You will need to modify for possible grouping. E.g. A one line title on a
> 5 column table will end up being
> "|"&A1&"||||"
>
>
> In the blank cell corresponding to the formatting row, type an appropriate
> string of |:--------:|...
>
> My problem was a bit messier than that. I advertise on Canada kijiji (not
> the same as the US version) They allow some formatting in ads but do not
> have a table format at all.
>
> I needed as ascii table. The results of cut and paste from excell into a
> text processor are less than stellar, as data is separated with a single
> tab character. Anything that lines up is coincidence.
>
> My route was to take this notion one step further, and make an ascii
> formated column that would work for either MMD or for text base ads.
>
> First attempt:
>
> "|" & A1 & REPT(" ",15-LEN(A1)) &
> "|" & B1 &...
>
> I didn't like the hard coding of the column widths.
> And if your source column is $2.50 it comes across as 2.5
>
> Second attempt.
>
> 1 blank column for column I want to use.
>
> If our table is 5 columns wide, I need another 5 columns.
>
> F1 in this one has the formula =TEXT(A1,"$0.00")
> Replicate across and down as needed.
>
> Secondly, insert a row above. In this row, but the column width you want
> for the output.
>
> Now your formula for K2 will look like this:
> "|" & F1 & REPT(" ",K$1-LEN(F1)) &
> "|" & G1 ...
>
> At this point if I want flush right text, I have to reverse
> the REPT and the Cell reference. No thoughts of centering.
>
> Sample output results
>
> |Bareroot Bundles of 25 2-3 year olds ||||
> |Bundles |# Trees | Cost| Price Per Tree|
> |:-------------------|:---------|---------:|--------------:|
> |5 Trees |5 | $30.00| $6.00|
> |Single Bundle |25 | $75.00| $3.00|
> |5 Bundles |125 | $300.00| $2.40|
> |10 Bundles |250 | $525.00| $2.10|
>
>
>
> Respectfully,
>
> Sherwood of Sherwood's Forests
>
> Sherwood Botsford
> Sherwood's Forests -- http://Sherwoods-Forests.com
> 780-848-2548
> 50042 Range Rd 31
> Warburg, Alberta T0C 2T0
>
> _______________________________________________
> Markdown-Discuss mailing list
> Markdown-Discuss at six.pairlist.net
> http://six.pairlist.net/mailman/listinfo/markdown-discuss
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://six.pairlist.net/pipermail/markdown-discuss/attachments/20140202/8e66a589/attachment.html>