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.
What should I enter in T2, H3… Fields on the Fundraising form?
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.
What is the Design Letter I should enter?
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.
What to fill in the bottom of the fundraising form?
What is Design Theme to fill in the order sheet?
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.
How to fill the Excel Order Calculation Sheet?
You need to compile all orders into the single sheet like this – see example.
"*" indicates required fields
