# Variables

Shedmate contains more than 70k different variables from client, project and shed data that can be used for multiple purposes such as:&#x20;

* To create advanced formulas for material, labour or fabrication quantification
* To be used in document templates to fill out information automatically for reports such as quotations, contracts or engineering forms.
* Send data via API to third-party integrations for custom requests.

To access our list of available variables for the costing database, follow the steps below:

1. Open a draft or job with the imported database.

<figure><img src="https://lh7-us.googleusercontent.com/QHXH0vqMNtaZ-AFwDNmUghvbLmlbZ3PQ9nEjn7Xt0oy1Y0RSuCZOeg4raxNu2vUtJj_G8nndI0cbvlYhoE3STMjbTukhAI69AoY7BkNmWGr3NIgjiNpxX2P-Q83f94iQEJzdaMJ8uv9wzYQDLYYxz3w" alt=""><figcaption></figcaption></figure>

2. Click on Instant Quoting.

<figure><img src="https://lh7-us.googleusercontent.com/XQcaqcvToU7ZaZkcQCvrY057kcW-XebVwstjZHzMMZUS-9Y-rK01_LorfduyLz_P3Kt6bSONhMreC-NIymyZGr-ylMwPO5wiGd0v-tSlxbdHa-OYn7412x1CS9_zVRH62ufMqOoTBGyuMPWDymTAg30" alt=""><figcaption></figcaption></figure>

3. Click on Variables.

<figure><img src="https://lh7-us.googleusercontent.com/rQQn2O_1BEDGOFqvBHSW1a2gDhozjij_dULDR2ziqzMUbHJM44Gud3ygEHDWheoT2CBya2A_TK2qxgONj-ERG-ilGuY2Ui8wgTn0siAdW7R_9RSySuiGXRk2lIDWFxZrSEPoUneQHW_8PEjlB9H7PDk" alt=""><figcaption></figcaption></figure>

4. Create a new Variable by clicking on New Variable.

<figure><img src="https://lh7-us.googleusercontent.com/g1axxx7cgPpfNeHEuMWiE-YZMmkFFfGIO03icfoJD2ITzUadgX2w9NL965-MZKKqPZ7LO8daSdvTRhoYc6Kbo6FFCnJL4yRZFSrub7wjwJdCXPA-W10Wh6U4YESJ0m__EMC69cne6ztz5LtB00lPQdA" alt=""><figcaption></figcaption></figure>

5. Enter the fields:

* **Variables Name**: Enter the variable name
* **Is Public = YES:** Public Variables are displayed on the Point of Sales System (Edit Shed) as per below, and are mostly used to create Formulas that will be used by the Salesperson, such as Delivery Costs based on Distance, Discounts, etc.

<figure><img src="https://1247870272-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSXoRgDyJukQzyOctBwWG%2Fuploads%2FB6JyeulAA4Y2VXHY2Gzd%2Fimage.png?alt=media&#x26;token=9443a5ae-3ac2-4317-b001-f69e78e56012" alt=""><figcaption></figcaption></figure>

* **Is Public = NO:** Non-Public Variables are only used to assist Pricing Calculations, thus, they won't be displayed on the Point of Sales System (Edit Shed). For instance, the image below shows how a Variable was used to calculate Reinforced Mesh per m². This Value is not available to the User when editing the Shed on the Shed Editor, but it is being considered on the Pricing Calculations.

<figure><img src="https://1247870272-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSXoRgDyJukQzyOctBwWG%2Fuploads%2FfJKnZA6hAkRKqaEQXpAl%2Fimage.png?alt=media&#x26;token=c13f1d2f-d8e7-4e87-959d-476529e84916" alt=""><figcaption></figcaption></figure>

&#x20;

* **Is Formula Variable = NO:** The new Variable will be a fixed number (as per the Reinforced Mesh per m² above)
* **Is Formula Variable = YES**: The new Variable will be defined using Formulas, as per the image below (Edit Formula):

<figure><img src="https://1247870272-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSXoRgDyJukQzyOctBwWG%2Fuploads%2FdIPCeIsv6jhQWnmsIvAQ%2Fimage.png?alt=media&#x26;token=ccd2c702-5678-4a48-a3ed-5266cbee367a" alt=""><figcaption></figcaption></figure>

*   **Restrict Options = YES:** Allows you to create a list of pre-defined values. You can use this, for example, to estimate Delivery Costs for specific Regions based on the distance, as per below. By setting the Distance in Kilometers (km) for specific Regions, you can then multiply these Values by a Delivery Cost per km in the Pricing Calculation to estimate Delivery Costs directly from the Point of Sales System (Edit Shed):

    <figure><img src="https://1247870272-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSXoRgDyJukQzyOctBwWG%2Fuploads%2FjwlwJB2W3A6PPkV0mWCR%2Fimage.png?alt=media&#x26;token=63c6d61c-a522-4238-bf9e-4744e06b63c3" alt=""><figcaption></figcaption></figure>

    * **Restrict Options = NO**: By selecting this option, you'll be free to set the Value as you want since there will be no restrictions, as per the example in which we defined that the Variable Reinforced Mesh per m² was equal to 13.

6. Once you create your Variable, it will appear on the bottom of the list. If **Is Formula Variable = YES**, click on Edit Formula to set the Formula:

<figure><img src="https://lh7-us.googleusercontent.com/qU-mGXSE93iUwYZ7gIO7oSeZA2yz-F2ESgnI3rCo3vq_cvEYpXI-otz29F62_-yNA62ic2xqhrCVwfcBf_pf_iC9XG9xtzAMylx875IGhhyUuObN4Hi2IOIadFnha5M88NYbzviXjnakgAFGBUcFBJA" alt=""><figcaption></figcaption></figure>

7. Search for relevant Variables and copy the exact name into the Formula input area. The value appears in the formula results.

<figure><img src="https://lh7-us.googleusercontent.com/i-8QN4036uB6FnHOgpx118XqIfjCTLsNPJ_SJv8MG44gthHF3foG48BqyNRscd-xpPJidgDGyD55ADRuPWWo6ZCw2uRgGDfDsT22GWNRaDcxGWD4f_lecAzcBFWUQRADYxzptgxFBoV9Qf9OB4mdDNM" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-us.googleusercontent.com/pVKlxWSR8UcHfbfZolRaj7kApCbxA-lRxw5FaReu2TZp6QHBjzhHIdlJa0LsIjxyi8Iyjh9lwEWlyvHg0Zv7GB-_iBLL9q9mRvR0QV5SCRvJNa7IHrKBH_dBAuiYVFPtVJ_CNjhwbgeBkOZmvQoboww" alt=""><figcaption></figcaption></figure>

8. Customize the formula: In the example below, we assumed that Screws for External Walls = Area of External Walls x 8:

<figure><img src="https://lh7-us.googleusercontent.com/dipeB6zqqo9oBy27eLwHfw4xVvYYhDP0aD0mQRpePlk7bBNrOg1ebzbMfd6JW4_8-_x0H-ZLa_ZSGjy3BKpEm95rN_vzAAqtAgCskFTHXTSFSxWKkIpHEecPJMDTv6OixTfO1raWyObb7ljf63J4SFI" alt=""><figcaption></figcaption></figure>

9. Click Okay to finalize.

<figure><img src="https://lh7-us.googleusercontent.com/g0pWF2T4Lb5rf7fD1dS0ToQQCGquRzBR3DFbUs8FBZRpKfOZ5Svllov31rzGdY2GUl65MlVGGUCjyI1mxPkZJfGKR0uUT5ndia_rwrpqQdvDSjFbHMXQp_CR_J9oLWDnzb8ElBi8Y3IiMaZJmpStAnE" alt=""><figcaption></figcaption></figure>

Now, you can use the Variable in the price calculation.

