logo ljt transparent
HOME
DOWNLOAD
DONATE
TUTORIAL
F.A.Q.
CONTACT
FRANCAIS GERMAN ENGLISH


barre
F.A.Q.
barre


GENERAL QUESTIONS

Why this file ?
Setting 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 ?
Simply 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?
Paypal 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 card.
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
total turnover
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?
LJT 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"?
Combining 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.

TECHNICAL QUESTIONS


What to start with  ?
The 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?
Excel 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 ?
LJT 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.
Error 504 ?
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.
This 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