|Why this file ?
up a market gardening installation project, dimensioning it and then
managing a diversified production and the composition of AMAP baskets
week after week are much easier tasks with the help of a few tools.
This is why I have developed an Excel tool to plan my vegetable
production, and why I would like to make it available to as many people
as possible free of charge.
This set of basic tables aims to provide financial visibility for those who set up in market gardening, and a production planning tool for those who are already established.
You will easily obtain useful information: number of rows, number of beds, total area occupied by each crop and overall, cost, turnover and profits for each crop and overall, automatic list week after week of the composition of AMAP baskets, price and average cost of a basket, number of seeds to sow, etc. You will be able to act on many variables such as the number of baskets / client, the width and length of your cultivation boards and grids, the quantities per basket as well as all the information relating to the cultivation such as yields, inter- and between-row spaces, germination rates, etc.
And above all, because there is an emergency! “Conventional” production techniques kill the life of the soil, our food crosses the oceans with great reinforcements of polluting energy, industrial food, acidifying our bodies, participates in the increase of cancers, etc ... Faced with the drifts of a system which only guides its decisions according to returns on investments, distributing resources only between too few hands, it is time to work so that a multitude of producers make a good living from their production, on small surfaces and respecting life!
Facilitate your installation in diversified market gardening and participate in transforming mass production into mass production, this is the goal of LJT Pro!
|Why is it important to donate ?
to thank me for the time and energy spent to build LJT Pro and to
participate in the payment of the structural charges so that the LJT
Pro workbook is available for free
But also to prove that another economy is possible, that of donation. I am not making any money with this file. Currently, donations cover expenses.
Finally, you will appear in the summary of donations.
|Is sending a donation by Paypal or credit card secure?
is the world leader in online payments. 346 million active accounts
generate a transaction amount of 222 billion dollars in 2020. During
your donation, the Paypal platform will also secure payment by credit
Paypal is therefore the most secure platform on the web.
|What can "LJT Pro"do?
|As soon as you have entered all the data necessary for the workbook to work, you will automatically and instantly obtain:
the rank numbers
the number of boards
the total area
the total area occupied by each crop
the total cost of production
turnover per basket / product / menu
the price and average (annual) cost of a basket / product / menu
the benefits for each crop
the total profit
the automatic list week after week of the composition of AMAP baskets
the automatic list of crops to transplant / sow / plant with quantity
a calendar presentation of the production schedule
But the workbook will not be frozen. This is the whole advantage of Excel! Each modification of a variable will impact the whole workbook. In other words, change a quantity of a product in a basket and the surfaces of the crop will change. Change the number of baskets delivered and all the surfaces will change (as well as all the other information concerned: number of seeds, turnover, average price, quantity to harvest, etc ...)
It will not be necessary to restart all the calculations each time, Excel will take care of it.
|How does the LJT Pro workbook do the calculations? Is it reliable?
is the setting to music of a method of evaluating production areas
written by Anne Weil and Jean Duval in the manuscript of the "Global
management guide for organic and diversified market gardening".
Anne Weil is an Innovation Advisor, holder of the NSERC Research Chair in Organic Crop Protection at CETAB and Jean Duval is Director of CETAB (Center of Expertise and Transfer in Organic Agriculture). Their work is recognized and reliable. LJT is one result.
Finally, LJT, already posted on the site of the "Fermes d 'Avenir" network, is used by many professionals who have not noticed any flaws.
|Why lock the LJT Pro file?|
|For security, locking these files ensures their stability. Complex formulas work for you and save you precious hours. If any of these were changed, all of your configuration work would also be lost. A foreclosure is therefore a recommendation, even an obligation, both for you, your work and the stability of the whole.|
|Why advise "Fisy"?|
LJT Pro and Fisy is interesting for the complete sizing of a future
activity. While Fisy will offer you financial forecasts over five
years, LJT Pro will allow you to know your production costs and the
minimum selling price of each of your baskets. So it's a winning pair,
each looking after their own specialty, Fisy for financial forecasting
and LJT Pro for production management and cost evaluation.
When your costs and turnover are provided by LJT Pro, you just have to inject them into the "Fisy" workbook to obtain your financial forecast over five years.
|What to start with ?
first worksheet is a user guide that you are strongly advised to read
completely. There you will find a description of the five steps to
follow to configure your file.
If, however, the user manual was not explicit enough, a tutorial is available THERE
|Which units to use?
is a program. No intelligence. No thinking skills. For a given crop, if
the units of your digits, numbers or quantities relate to kilos, they
will remain kilos. It is you and you alone who know the differences in
unity between different cultures (salad in unit, radish in bunch,
potato in kilo, for example). Neither Excel nor the LJT Pro workbook
will be able to do conversions, if, for example, for a crop, you
indicate yields by weight and units in the composition of the baskets.
|How do I include products that are not from my farm in the file?|
|It is very simple ! Treat outside produce as your farm's crops. The difference is that they will not occupy any surface. To do this, in the inter-row and inter-row distance columns, simply enter "0".|
|I have more than 60 different cultures. How to do ?|
Pro is already very heavy. Each modification on your variables
generates new calculations. For the workbook to handle more culture
would make it unusable.
The best solution is to duplicate LJT Pro workbook by crop type. For example, if you have a lot of different species of tomatoes (some handle more than 200 different ones), you can copy / paste the workbook and rename the copy "LJT Pro tomatoes". The same goes for aromatics or any other crop.
|Many matrix functions are used to generate lists. List of crops to harvest, to sow, of products per basket, etc ... And currently, only Excel correctly manages the matrix functions. As a result, the 504 error will appear because your spreadsheet does not understand matrix functions.|
|Mac, Windows, Linux, what compatibility ?|
|The xlsx format is very general and standard. It is therefore compatible with all operating systems. On the other hand, the matrix functions used unfortunately force you to use spreadsheets capable of interpreting them, such as Excel.|
|As soon as a change is made, the computer freezes or slows down.|
is indeed a problem :-( LJT Pro is a heavy workbook (6.5MB) and all the
sheets in the workbook are interconnected. As soon as you change a
setting, all the sheets are changed. Therefore, it is better to use a
computer with minimal power and RAM, a simple tablet won't do.
The next step after Excel is the database, see the computer program or the smartphone application. This represents much larger investments.
FAIRE UN DON