Terms of Service 14-june-2018

Terms of Service

Disclaimer

Definitions:

  • Tool: Sheet, Script and/or Invoice Doc.
  • You: The person using the tool.
  • ZIMONH: The company ZIMONH
  • To Agree: To read comprehend and accept the Disclaimer part B and License.
  • Initiator: Person setting up the tool,
  • Active tool: Tool set up by Initiator.

Disclaimer Part A

The initiator is responsible: To ensure that anyone that uses the active tool, Agrees.
Any usage of the active tool without agreeing falls under the responsibility of the Initiator.

Disclaimer Part B

  • It’s important you double check the data in the tool, to ensure it functions properly,
  • ZIMONH is not responsible for any incorrect data, texts, calculations, values, amounts or any errors or other mistakes in the tool,
  • The feature to ‘update the invoice doc, based on the data in the sheet’ will become unavailable if there is an update ready,/li>
  • Any other feature of the tool can also become unavailbale at any time. (This is not a goal for now but it could happen in te future),
  • This tool runs in the Google cloud. So, Google’s ‘Terms of Service’ and other legal text that you agreed on with Google still apply,
  • If there are any updates to these terms of service ZIMONH will display this at the top of the projects page in the tool and
  • The late fee is calculated using Dutch law so it might not be the same as the legal late fee in your country.

License

The Sheet and The Script (Connected to the sheet, build using Google App script),

Are property of ZIMONH.
And have the following license:
Attribution NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0)

Some of the features of this sheet script are:

  • Spread values,
  • Protect values,
  • Store the sheet data in local parameters,
  • Generate an invoice,
  • And use settings from in sheet table.

Finance Tool – How to Use


Finance Tool – How to Use

Settings Tab

This is where you can change the information that is visible on the invoice. You can also change the names of the Tabs.

Green

Here you can add the tile of the invoice. You can use your own language.

Red

This is the contact information on the invoice. Left is the tile right is your personal information. You should change this text.

Purple

This is the tile of bill number and different dates. You can change the names or use your own language.

Yellow

This is the header of the item list on the invoice. You can change the names or use your own language.

Blue

This is the financial information used on the invoice. The tax rate gets used to calculate the Total Price.

Gray

This is the billing information on the invoice. You should change this text.

White 1

This is the text that gets used to create the invoices. Make sure to add “&ltdeadline>” in the right place. In Orange, you can see the text with the deadline. You can change the text or use your own language.

Pink

This is the end text of the invoice. You should change this text.

White 2

These are the ids of the files needed to create an invoice. You should change these. You can use
Step 2: Connect the Doc to the Sheet. and
Step 7: Add Signature that you can find on this page: Finance Tool – How to Install (press NEXT)

White 3

These are the names of the Tabs Finance, Projects, and Clients. If you want to use custom names press the small down arrow on the bottom tab menu and select rename and choose a new name then make sure to add these to this section of the settings. Make sure you DO NOT rename the Lists tab or Settings tab.

Orange

Here you can change the dates used as deadlines in the Finance tab and on the text in your Invoice. You can only change the numbers. You can change the text in white 1.

Violet

Here you can select the invoice font. Make sure to test that the layout of your invoice still looks good since some fonts can result in bigger text than others.


Projects Tab

Projects are used to track groups of bills and have an overview of project status and financial status.

Project column

The name of the project.

Status column

Select whether the project is Active, On Hold or Completed. You can add more to the status list. Like Lead, Billing or any custom name in the Lists tab under the Status column.

Description column

Her you can write a short description of the project.

Owner column

Select a project owner from the drop-down list. You can change the owner list. In the Lists tab under the Owner column.

⚄ column

Select the change the estimate is accurate. You can change the drop-down list. In the Lists tab under the Chance column. Don’t forget to add the % symbol.

Estimate column

An estimate of your total balance at the end of the project. This can be a profit or a loss.

Pipeline column

The difference between the estimate or budget and the amount billed. This column is filed automatically. So you can’t add anything here. This is how it’s calculated:

  • If the amount in Estimate is higher than the amount in Budget,
    show the amount in Estimate minus the amount in Billed.
  • If the amount in Budget is higher than the amount in Estimate,
    show the amount in Budget minus the amount Billed.

Budget column

The sum of this projects budgeted items. This column is filed automatically. So you can’t add anything here. This is how it’s calculated:

  • Sum the Budget Total in the Finance tab,
    if the name in the Finance tab in column Project
    is the same as the name in the Projects tab in column Project.

⚠ column

Gives a warning if there is anything that was added but not billed. This column is filed automatically. So you can’t add anything here. This is how it’s calculated:

  • Count all the un-billed rows in the Finance tab. If the name in the Finance tab in column Project is the same as the name in the Projects tab in column Project.

Billed column

Calculates the amount billed. This column is filed automatically. So you can’t add anything here. This is how it’s calculated:

  • Sum the Bill Total from the Finance tab. If there is a date in column Dates Bill and if the name in column Project is the same as the name in the Projects tab in column Project.


Finance Tab

Search Project column

Here you can select a project from the Projects tab using a drop-down list. If this list is empty or you can not find the project, add the project in the Projects tab.
This information is needed to track projects finances.

Search Client column

Here you can select a client from the Clients tab using a drop-down list. If this list is empty or you can not find the client, add the client to the Clients tab. This information is needed to create an invoice.

Search № column

Here you can add a unique invoice number that will be visible on your invoice. Add the same number in the rows you want to show in your invoice.

Item ☯ column

Here you can select whether this is income or expenditure from a drop-down list.

Item Description column

Here you can write a description of the service or product. This is for your own administration and a legal agreement between you and your client that will be visible on your invoice.

Item Type column

Here you can select the type of the item from a drop-down list. You can add types to the Lists tab in the Types column.

Budget columns

The financial information you predict for this project. Needed to create an accurate overview in the Projects tab and needed to create a budget line in the Graph tab.

Budget № column

Here you can add the amount of this item you predict you are buying or selling.

Budget Price column

Here you can add the price of each individual item you predict you are buying or selling.

Budget Total column

The product of the times the Price. This column is filed automatically. So you can’t add anything here.

Bill № column

Here you add the amount of this item you are buying or selling.

Bill Price column

Here you add the price of each individual item you are buying or selling.

Bill Total column

The product of the times the Price. This column is filed automatically. So you can’t add anything here.

Dates Bill column

By double clicking this column you can select a date. This will update the invoice document and transforms it into a proper Invoice. All the rows with the same Search as the row you just added the date will be added to the invoice.
Your Contact and Billing Information, Logo, Currency, Tax rate, Invoice Text and Payment Deadlines will be taken from the Settings tab.

Dates Rem column

By double clicking this column you can select a date. This will update the invoice document and transforms it into a proper Reminder. All the rows with the same Search as the row you just added the date will be added to the invoice.
Your Contact and Billing Information, Logo, Currency, Tax rate, Invoice Text and Payment Deadlines will be taken from the Settings tab.

Dates Not column

By double clicking this column you can select a date. This will update the invoice document and transforms it into a proper Final Notice. All the rows with the same Search as the row you just added the date will be added to the invoice.
Your Contact and Billing Information, Logo, Currency, Tax rate, Invoice Text and Payment Deadlines will be taken from the Settings tab.

Dates Fee column

By double clicking this column you can select a date. This will update the invoice document and transforms it into a proper Invoice with Late Fee. All the rows with the same Search as the row you just added the date will be added to the invoice.
Your Contact and Billing Information, Logo, Currency, Tax rate, Invoice Text and Payment Deadlines will be taken from the Settings tab.

Dates Paid column

This is the date you got the payment. By double clicking this column you can select a date. This will be used to update the Graph tab.

Finance Tool – How to Install

Finance Tool - How to Install

Important: Use Google Chrome

During this installation it's important you use the Chrome browser.
If you do not have Chrome installed you can download it here: www.google.com/chrome/
After this installation you can use any browser.

Before: Sign in

Make sure you have a Google account and are signed in.
If you don't have an account you can make one here: accounts.google.com/SignUp

Step 1: Download

On this page you can find the two files: download
By setting up this tool, you agree to the Terms of Service.
Click + drag and select both files,
Now right click on one of the selected files and choose Make a copy.
Wait 30 seconds for the copying to complete and the files are now part of your drive.

Step 2: Connect the Doc to the Sheet.

In the left menu click My Drive.
Now double click Copy of Invoice to open the invoice document.
Once the file is open select the following part of the URL:
And press Ctrl + C.
Now go back to My Drive.
And double click Copy of Finance Sheet By ZIMONH.
In the bottom click the Settings tab.
Now find Google Drive file id for invoice Document:
And click on the cell next to it and press Ctrl + V.
Now refresh the page.

Step 4: Authorize

In the top menu click Tools > Script editor.
Now in the top menu click Edit > Current project's triggers.
Now a prompt will appear, click No triggers set up. Click here to add one now..
In the first list click createDoc and select onEdit,
In the second list click Time-driven and select From spreadsheet and
In the third list click On open and select On Edit.
Click Save.
Now a prompt will appear saying: Authorization required.
This is needed to allow the finance sheet to connect to the invoice doc.
This script will never send information to 3rd parties or try to access other files.
Click Review Permissions and select your account.
Now a warning will appear.
In the bottom click Advanced.
Next scroll down and click Go to Billy (unsafe).
Now a prompt will apear asking permission for this script: Click "Allow".
What permissions you are granting? find out.

Step 5: Test

Click X On the current Billy tab in your browser.
And in the Finance sheet go to the Finance tab.
Now double click the Bill column of row 5.
And click on a date.
Wait 30 sec.
Now open the Copy of Invoice and check if the date is correct.

Step 6: Add Logo

Make sure you have a logo with a white or transparent background on your computer.
Click and Drag the file into Copy of Invoice next to the logo.
Click the old logo and press Delete.
Now Click the new logo and adjust the size.
The file will automatically save.

Step 7: Add Signature

Make sure you have a signature with a white or transparent background on your computer.
Click and Drag the file into My Drive.
Right Click on the new file and choose Get sharable link.
Select the text after id= and press Ctrl + C.
Now open Copy of Finance Sheet By ZIMONH go to the Settings tab.
And Click next to File id for Signature Image and press Ctrl + C.
Now when you send a final notice or a bill with late fee it will have your signature.

Step 8: Add Company Info

In the Settings tab you can add your company info.
This will all appear when you create an invoice.
You can adjust all the text that doesn't have a black background.

Step 9: Other Customization

You can also translate, adjust the tax-rate and the currency. For more information visit How to use.

Web Development – An Introduction to AJAX

Web Development – An Introduction to AJAX

A tutorial for the Ajax function. Assuming you understand PHP and JavaScript.

index.html

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script>
	var pineapple_js 	= "pineapple";
	var pen_js 		= "pen";

	$.ajax({
		url: "hello.php",
		method: "POST",
		data:{
			pineapple_php  : pineapple_js,
			pen_php        : pen_js
		},
		success: function(data){
			if(data == "pineapple"		){	$('body').html('<img src="https://tinyurl.com/y9lurfan">');	}
			if(data == "pen"		){	$('body').html('<img src="https://tinyurl.com/y79nx6j7">');	}
			if(data == "pineapplepen"	){	$('body').html('<img src="https://tinyurl.com/ybxro2ng">');	}
		},
		error: function(){
			alert("error");
		}
	});
</script>
</head>
<body>START</body>
</html>

hello.php

<?php
	$php_var1 = $_POST["pineapple_php"];
	$php_var2 = $_POST["pen_php"];
	echo $php_var1.$php_var2;
?>