Help:Insert charts into a page

From Triple Performance

Triple Performance makes it easy to insert graphics into the pages, for example to show a rotation over several years, to show the details of an economic balance sheet or a crop rotation. Chart data is entered into a Google Spreadsheet™ document and then synchronized on the page using an Add-On.

Chart Types

It is possible to insert the following graphics:

Accounting

This graph allows you to display a simple economic assessment over several years. The colors make it possible to distinguish what is in the order of operational loads, structural loads, etc. By clicking on an area, you can see the details of what exactly constitutes the charges.




Histogram

This chart allows you to display a simple histogram like the one below. The columns can typically be years but can also be anything else.

Radar

A radar with any number of branches. We can put an average there to compare with the results of a group of farms for example. The maxes of each branch may not all be the same.

The radar, as well as all other graphics, can be positioned on the right, on the left, or centered on the page.

Rotation

A graph to display a rotation. Each element of the rotation extends over a given number of months, and you can specify any additional element in comments (by hovering the mouse or clicking on it on mobile). As on each graph, the colors are chosen directly in Google Spreadsheet™.


Crop surface distribution

The rotation allows us to show how the farmer's useful surface area is distributed between his different productions at a given time.

Environmental analysis and socio-economic analysis

  • Taux de matière organique : Entre 1,5 et 8% de taux de matière organique.[1]
  • Nombre d'espèces cultivées : 100% au delà de 30 espèces cultivées sur la ferme.
  • Absence de chimie : 100% quand la ferme est en bio.
  • Non travail du sol : % de la SAU qui n'est jamais travaillée.
  • Biodiversité : Pourcentage de la surface d'intérêt écologique sur la SAU.
  • Couverture de sol : 100% quand moins de 10 jours de sols nus dans l'année - 0% au delà de 150 j/an.

These radars allow you to display the data found in MSV portraits for example.

Self-production capacity

This graph allows you to display the self-production capacity of the farm on certain aspects (used in particular in farm portraits).

Commercial strategy

This pie chart allows you to understand the share of farm income based on the different sales channels.

Installing the Add-on

Adding graphics to Triple Performance is done via a Google Spreadsheet™ add-on that can be downloaded from the Google Workspace Marketplace by clicking on the following button:

Téléchargement de l'add-on dans le marketplace.png

  • The add-on must first be installed from the "Google Workspace Marketplace" by going to this page: https://workspace.google.com/marketplace/app/triple_performance/427792115089.

    The add-on must first be installed from the "Google Workspace Marketplace" by going to this page: https://workspace.google.com/marketplace/app/triple_performance/427792115089.

  • Once installed, the Triple Performance icon should appear on the right when you are on a Google Spreadsheet™ document (NB: The sidebar with Add-on icons can be shown or hidden with a small chevron at the bottom right).

    Once installed, the Triple Performance icon should appear on the right when you are on a Google Spreadsheet™ document (NB: The sidebar with Add-on icons can be shown or hidden with a small chevron at the bottom right).

  • The next step is to create an account on Triple Performance if you haven't already done so.

    The next step is to create an account on Triple Performance if you haven't already done so.

  • Don't forget to validate the account via the email received

    Don't forget to validate the account via the email received

  • Once logged into Triple Performance, you must go to the Special:BotPasswords page. This page allows you to create a special username and password for using the Add-on. In "Robot name", put for example "Add-on", then click on "Create".

    Once logged into Triple Performance, you must go to the Special:BotPasswords page. This page allows you to create a special username and password for using the Add-on. In "Robot name", put for example "Add-on", then click on "Create".

  • Check the boxes: "Edit existing pages", "Create, modify and move pages", "Upload new files" and "Upload, replace and rename files", then click on "Create"

    Check the boxes: "Edit existing pages", "Create, modify and move pages", "Upload new files" and "Upload, replace and rename files", then click on "Create"

  • Finally, copy the username and password thus created. The username must have the following form: Guy Delucas (2788345452)@Add-on and the password a long string of numbers and characters: pj6mlndh72495qurih489noeh6o2bn6l

    Finally, copy the username and password thus created. The username must have the following form: Guy Delucas (2788345452)@Add-on and the password a long string of numbers and characters: pj6mlndh72495qurih489noeh6o2bn6l

  • Return to the Add-on (Google Spreadsheet), and click on the “Settings” button at the bottom of the Add-on.

    Return to the Add-on (Google Spreadsheet), and click on the “Settings” button at the bottom of the Add-on.

  • Enter the username and password previously created, then click on “Save settings”. If you get an error, check that you haven't forgotten a character in the username or password.

    Enter the username and password previously created, then click on “Save settings”. If you get an error, check that you haven't forgotten a character in the username or password.

Adding a chart to a Google Spreadsheet document

  • Start by going to a new tab.
  • Click on the chart you want to create. A table will be added at the end of the current tab.
  • When adding the first graph, a new tab "General data' will be added. This tab can be used to store any information about the farm studied, but is especially important to know the name of the page to which the new graphics should be inserted.
    • Create, if not already done, the Triple Performance page for the farm portrait, giving it the name of the farm (for example EARL of the Great Woods). The same principle applies to any page, you can also insert graphics into any page (technical route, etc.). The page must exist before syncing the first chart!
    • Enter the name of the page in cell B1 of the "General Data" tab, opposite the cell marked "Triple Performance Page Name". When you synchronize the graphics, they will be sent to this page.
Entering the page name in the add-on
  • Now complete/edit the chart, completing/editing the data in the table that was created previously.
  • Click the blue button at the bottom of the “Synchronize page” add-on.
    • Choose the chart to sync.
    • Click "Sync Chart".
  • Go to the Triple Performance page, and reload there to see that the graph has been added.

Frequently asked questions

  • I edited the chart and resynced it, but it remains unchanged in Triple Performance?

The previous graph was cached (for performance reasons). Go to the menu on the right of the page and select "Purge page".


  • In the rotation graph, I cannot return to the line in the comment cells!

Simply click Ctrl-Enter to move to a line within a cell. You can also add bold, italics, etc... with the keyboard shortcuts: Ctrl-b, Ctrl-i, ...


  • I changed the title of my Triple Performance page, should I also change the name in the "General data" tab?

Yes, the name in front of “Triple Performance Page Name” must always match the title of the Triple Performance page


  • Can I add other texts in the "General data" tab?

Yes, the important thing is that somewhere in the tab, we have the two cells in column A "Triple Performance page name" and B with the title of your page.


  • I'm trying to sync an X or Y chart, but it's not showing in Triple Performance

Check that you have not modified any texts necessary for the Add-on to find your way... In particular, the Add-on will look for the line with "Graphic" written and the type of graphic in the cell following. This is how it recognizes this or that type of graph. If you modify this text, synchronization is no longer possible. It is the same with the texts "End of graph", etc... If necessary, add a new graph of the same type by clicking on the corresponding button, and report the values ​​one by one to understand when it stops to work !


  • In the economic balance sheet graph, is it possible to add other fields (for example metric expenditure, etc.)?

No unfortunately, all the fields managed by this chart are displayed by default when you add the chart to your Spreadsheet. You can delete lines that are unnecessary but you cannot create new ones. The same goes for analytical radars, self-production capacity and business strategy. If you see fields that would be interesting to add, contact us!


  • I have a problem that is not on the list?

No worries, we are responsive. The best thing is to go to Slack and ask us directly!

  1. ↑ Dans l'analyse de terre, la matières organiques (MO) est quantifiée à partir du dosage de la teneur en carbone organique (C) son constituant majeur, que l'on multiplie par un coefficient censé refléter la teneur en carbone de la MO, qui peut différer selon les laboratoires Français : 1.72 ou 2. Ce coefficient est toujours précisé sur les bulletins d'analyse. Il est donc nécessaire de vérifier le coefficient utilisé si on change de laboratoire pour éviter une interprétation erronée de l'évolution de la teneur en MO.
Retrieved from "https://en.tripleperformance.ag/index.php?title=Help:Insert_charts_into_a_page&oldid=4447"
 

 

 

 
Discussion
Suggest a page?
Share on:

Triple Performance

Community

Productions

Themes

 

Made with ♡ by Neayi