After a student submits the fundraising form with collected preorders, the order information needs to be updated in the following Excel sheet which calculates the total order from your school. Please upload the final sheet on the Fundraiser Ordering page, enter your tree total and place your order.
These are just short codes so it is easy to fill the form column ‘Seed Number’.
First, decide from here which seed species you want to grow with your community. Remember to choose species native to your area.
Here’s an example selection:
After doing this, just add them to the form like this:
You can add maximum 3 options each for Trees, Herbs, Flowers. So a total of 9 options. But you don’t have to have the full 9 options always. It’s up to you if you want to plant just 1 tree species or give a few options to choose. So your selection can simply be for instance T1 – Crape Myrtle, F1 – Lavender.
Here’s what a filled up form looks like with the tree codes added to Seed number column.
Standard Cup and Standard Pouch only have single designs. All other themes have 5 design options named from A to E. These are the Design Letters you need to enter when taking orders.
For example, if someone likes the tree pouch design B, then add B to the Design Letter column.
Here’s an example form submitted with design letters.
Design Theme is simply the name of the Tree kit design. These are the 6 design themes you can choose from:
You can choose multiple design themes or a single theme.
You need to compile all orders into the single sheet like this – see example.