Re: Digest for transition-pimlico-food-coop@googlegroups.com - 2 Messages in 2 Topics

1 view
Skip to first unread message

invisible food

unread,
Nov 17, 2011, 5:34:27 AM11/17/11
to transition-pim...@googlegroups.com
Thanks Charles
I've just added one thing as moving soon. its the short grain brown rice 5kg. Same rice as Donna wants. If she's happy with 20kg, I could have 5kg of the 25kg bag. Up to you Donna
thanks all!  Do I need to give money now  - they want payment upfront don't they.
Cerixx

On 16 November 2011 23:17, <transition-pim...@googlegroups.com> wrote:

Group: http://groups.google.com/group/transition-pimlico-food-coop/topics

    "charles bullen" <char...@talktalk.net> Nov 16 02:30PM  

    Hi All ..
     
    Rakesh is away for the week so if you have any questions, you can send to the group or to me char...@talktalk.net and I can probably answer them.
     
    All orders need to be in by the deadline of Friday 25th ... and the earlier you place your orders the better ..especially if we are not having an ordering meeting
     
    We need to think "co-operatively" and try to support each other by coming in on items that have not reached their fullfillment amounts
     
    here's an example ... I need people to help me out on row 28 ......

    1 200517 6x500ml organic Sesame Oil 6.09 Clearspring .... for £4.57 rather than £6.09 rrp It is a very good general purpose cooking oil and my 2 bottles will last me ages so I need others to take up the other 4 ... please ? ..... (these things would normally be negotiated at the ordering meeting)
     
    so remember to check if someone has already added the item you want, or a similar item, higher up the list.
     
    another example ... Donna ... do you really need the whole 25Kg of rice ? .. if you made your "minimum" be, say, 15 Kg then it would allow 10Kg for other members to buy ... and 15 kg is still a LOT of rice !
     
    Don't forget that even if an Item is allready "fulfilled" ... i.e. ROW 1 .. Suma Organic Apple Juice Concentrate .. 6x400 ml ...you can still add orders and we just order another 6, 12, or whatever.
     
     
    To make ordering easy .... I think it makes sense to download BOTH the PDF AND the excel spreadsheet versions of the catalogue from ..
     
    http://www.infinityfoodswholesale.co.uk/catalogue/ ..
     
    The PDF is MUCH easier to read and browse .... but then once you find an item you want, you can copy it's catalogue number and paste it into the "find" box in the spreadsheet ( hit "control-F") .... The "find" function seems to work much better with the catalogue number rather than trying to search for "rice" or whatever
     
    from there you can copy and paste JUST the first 11 cells (Important!) of columns A to K into our order spreadsheet
     
    here it is ..... https://docs.google.com/spreadsheet/ccc?key=0ApmRnH1l4XcOdHJHTFdfa3FBRDZrbm9GRWthYk9SUnc#gid=0
     
    You CAN fill it all in Manually ( e.g if you are using a paper catalogue ) but be very carefull to copy it all correctly ... esp the Cat No and price ... and watch out for VAT which has to be added to ALL non-foods and all "luxury" foods ( eg. apple juice ! )
     
    in fact ... here is a copy from the "instructions" tab in our ordering Spreadsheet ..
     
    and please add your details to the "Contacts" tab
     
    good luck ! ... Charles
     
     
    1. Fill in columns A through to K ( the pale yellow ones ! ) with your order (you can copy and paste from the Infinity spreadsheet).
     
    If you ARE copying and pasting from the Infinity spreadsheet you STILL need to MANUALLY fill in column L .. ""Qty - MANUAL (vol weight)"" to make the automation work ... (that's why it's called ""manual"" ! )
     
    and please make sure you only copy those first 11 cells A thu to K ... NOT a longer line !
     
    i.e ..... at the risk of repetition .. please DO NOT edit or clear or paste into columns M,N,O,P,Q and R !"
     
    2.Column L NEEDS to be filled in MANUALLY it is "Qty - MANUAL (vol weight)"and is the lot quantity (i.e. [ 5 ] for 5kg; [ 6 ] for 6x500ml; [ 5 ] for 5 litres). **
     
    3.PLEASE NOTE ! Columns M to R will be filled in automatically PLEASE do not edit these fields as they contain essential formulas to make this order process work.
     
    Please use the "backspace" key rather than "delete" to clear a cell for editing or re-editing or to "delete" it's value ... or whatever... as "delete" clears all the formatting for that cell as well (which you don't want).....
    And if you DO make a mistake please use "Undo" ( in the Edit menu or "control z" )
     
    4. Q is the max total (used to check if we have above or below the minimum order).
     
    5. R "SPARE" indicates the amount available for others to buy
     
    6. Add the minimum and maximum quantity you want in columns S onwards
     
    Please do not edit ( or clear) the third "£" column of "your" 3 columns as this allso has automated formulas and should NOT be edited or cleared ...

     

    Rakesh B <rake...@googlemail.com> Nov 15 11:23PM  

    Just synchronised the order we added last night to the one on googledoce,
    so you can now edit the one on googledocs to add your orders.
    If we can have all orders in and payments by 25th, so we can place order on
    28th.
    If you need help understanding the spreadsheet then feel free to email the
    group (Charles and Ariel are both experts at this now).
    I am building a forest garden all week in Wembley, so won't have much email
    access.
     
     

     

You received this message because you are subscribed to the Google Group transition-pimlico-food-coop.
You can post via email.
To unsubscribe from this group, send an empty message.
For more options, visit this group.




--
&&&
 
The abundance of this place,
the songs of its people and its birds,
will be health and wisdom and indwelling
light. This is no paradisal dream.
Its hardship is its possibility. 
'A dream' - Wendell Berry
 
A one day workshop in Non violent communication Saturday November 19th, London
 
Check out last walks
 
August monthly walk with Blackberry ice cream and Wild herb jamaican patties
 
July monthly walk to mark Zero Carbon Britain Day
 
Hike the Borough on June 26th 2011
 
Monthly walk: 7th May 2011
 
 

"The window is now, the sun, the suns of elderflower. All of a sudden it’s everywhere and there’s an abundance of graciousness in the air." Text messaging project May 26th via web

 
 
6c Flodden Road
London
SE5 9LH
07963 446605


Rakesh B

unread,
Nov 18, 2011, 8:24:34 AM11/18/11
to transition-pim...@googlegroups.com
Nice one Charles.

We did ask Donna if she really wanted all 25kg and she said she did. Ditto most of the other things she ordered.

I will check with Ellen how much she wants, maybe we can make up a second 25kg between us (I still have at least 10kg left from the last order).

Ceri, do you want something from the rest of the order? Anything which is red in column R is spare, or to put it another way if we dont make it turn green we wont be able to order it.

I added an extra column O which counts all the items which have reached the level where we can order it. O3 sums up these items, so we can tell that so far we have not met the minimum £250 order level. Hence we need to start making the red lines green or amber.

If you can organise a meeting, which Charles or Ariel can host, they may be able to explain how the ordering works and get us to a point where we can place this order.

I thought I may have a few days free before I go to Croatia, but the project I am implementing is running over on time and the trees have not arrived yet, so I suspect those spare days will be eaten up by this project. So would be good if you could meet Charles so he can walk you through the first order if I am not available.
Reply all
Reply to author
Forward
0 new messages