Spreadsheet: 144603d1331054536-missing-any-function-in-this-formula-sheet-attached-help
Sheet: DataBase

S.No. | [NAME] | GRN # | GRN Date | Invoice Date | Invoice # | Net Terms | Due Date | Amount Due | Currency | Forecasted Rate | Conversion Rate | Amount in Rs | Aging (Days) | 0 - 30 Days | 31 - 60 Days | 61 - 90 Days | 91 - 120 Days | Over 120 days | PO Number | Contact Person | Direct Phone | Alternate Phone | Fax | E-mail | Country | City
1 | Hachette |  |  | 2011-06-13 00:00:00 | 35968324 | 120 |  | -2.63 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
2 | Hachette |  |  | 2011-07-13 00:00:00 | N/A | 120 |  | 10 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
3 | Hachette |  |  | 2011-09-06 00:00:00 | 36700232 | 120 |  | -1.75 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
4 | Hachette |  |  | 2011-10-10 00:00:00 | N/A | 120 |  | 10.48 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
5 | Hachette |  |  | 2011-12-08 00:00:00 | N/A | 120 |  | 174.13 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
6 | Hachette |  |  | 2011-12-08 00:00:00 | N/A | 120 |  | 210 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
7 | Hachette |  |  | 2011-12-09 00:00:00 | N/A | 120 |  | 12.23 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
8 | Hachette |  |  | 2011-11-01 00:00:00 | 37449486 | 120 |  | 244.65 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
9 | Hachette |  |  | 2011-11-01 00:00:00 | 37471598 | 120 |  | 136.34 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
10 | Hachette |  |  | 2011-11-01 00:00:00 | 37471597 | 120 |  | 12.16 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
11 | Hachette |  |  | 2011-12-01 00:00:00 | 37485535 | 120 |  | 12.23 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
12 | Hachette |  |  | 2011-12-01 00:00:00 | 37485537 | 120 |  | 153.95 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
13 | Hachette |  |  | 2011-12-01 00:00:00 | 37541031 | 120 |  | 291 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
14 | Hachette |  |  | 2011-12-01 00:00:00 | 37541030 | 120 |  | 41.9 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
15 | Hachette |  |  | 2011-12-01 00:00:00 | 37541029 | 120 |  | 26.16 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
16 | Hachette |  |  | 2011-12-01 00:00:00 | 37566938 | 120 |  | 209.65 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
17 | Hachette |  |  | 2011-12-01 00:00:00 | 37558193 | 120 |  | 31.49 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
18 | Hachette |  |  | 2011-12-01 00:00:00 | 37558192 | 120 |  | 125.95 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
19 | Hachette |  |  | 2011-12-01 00:00:00 | 37572378 | 120 |  | 129.33 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
20 | Hachette |  |  | 2011-12-01 00:00:00 | 37572379 | 120 |  | 29.4 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
21 | Hachette |  |  | 2011-12-01 00:00:00 | 37627485 | 120 |  | 20.98 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
22 | Hachette |  |  | 2011-12-01 00:00:00 | 37627488 | 120 |  | 113.66 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
23 | Hachette |  |  | 2011-12-01 00:00:00 | 37627486 | 120 |  | 24.5 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
24 | Hachette |  |  | 2011-12-01 00:00:00 | 37627487 | 120 |  | 108.47 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
25 | Hachette |  |  | 2011-12-01 00:00:00 | 37667622 | 120 |  | 237.71 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
26 | Hachette |  |  | 2011-12-01 00:00:00 | 37697329 | 120 |  | 16.78 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
27 | Hachette |  |  | 2011-12-01 00:00:00 | 37697328 | 120 |  | 48.26 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
28 | Hachette |  |  | 2011-12-01 00:00:00 | 37697330 | 120 |  | 78.31 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
29 | Hachette |  |  | 2011-12-01 00:00:00 | 37697327 | 120 |  | 17.41 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
30 | Hachette |  |  | 2011-12-01 00:00:00 | 37738670 | 120 |  | 26.25 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
31 | Hachette |  |  | 2011-12-01 00:00:00 | 37738668 | 120 |  | 27.97 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
32 | Hachette |  |  | 2011-12-01 00:00:00 | 37738667 | 120 |  | 94.45 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
33 | Hachette |  |  | 2011-12-01 00:00:00 | 3773869 | 120 |  | 47.25 |  |  |  |  |  |  |  |  |  |  | N/A | Umair Siddiqui | (512)-539-2813 | 0092-(0)[PHONE] | (512)-539-2675 | [EMAIL] | United States | Texas
34 | [NAME] and [NAME] |  |  | 2011-12-12 00:00:00 | COA100863767 | 60 |  | -521.1 |  |  |  |  |  |  |  |  |  |  | N/A | [NAME] | ([PHONE] | N/A | ([PHONE] | [EMAIL] | United States | Houston
35 | [NAME] and [NAME] |  |  | 2012-01-25 00:00:00 | 3017666614 | 60 |  | 247.09 |  |  |  |  |  |  |  |  |  |  | N/A | [NAME] | ([PHONE] | N/A | ([PHONE] | [EMAIL] | United States | Houston
36 | [NAME] and [NAME] |  |  | 2012-01-30 00:00:00 | 3017676433 | 60 |  | 69.79 |  |  |  |  |  |  |  |  |  |  | N/A | [NAME] | ([PHONE] | N/A | ([PHONE] | [EMAIL] | United States | Houston
37 | [NAME] and [NAME] |  |  | 2012-02-06 00:00:00 | 3017690781 | 60 |  | 16.02 |  |  |  |  |  |  |  |  |  |  | N/A | [NAME] | ([PHONE] | N/A | ([PHONE] | [EMAIL] | United States | Houston
38 | [NAME] and [NAME] |  |  | 2012-02-13 00:00:00 | 3017705826 | 60 |  | 334.58 |  |  |  |  |  |  |  |  |  |  | N/A | [NAME] | ([PHONE] | N/A | ([PHONE] | [EMAIL] | United States | Houston
39 | [NAME] and [NAME] |  |  | 2012-02-20 00:00:00 | 3017721794 | 60 |  | 162.09 |  |  |  |  |  |  |  |  |  |  | N/A | [NAME] | ([PHONE] | N/A | ([PHONE] | [EMAIL] | United States | Houston