tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 101799d1299845373-using-data-from-different-worksheets-feb-team-target
Sheet: WK 1

Agent | Ski Tar | Lakes T | Ski Ach | Lakes Ac | Agt [NAME] | Tot Pax | Tot Book | Extra Tar | [NAME] | % Dir Ski | % Dir Lake | Calls | Conv | Enq | Conv
Chrissy | 17 | 3 | 47 | 2 | 30 | 79 | 22 | 60 | 42 | 2.76 | 0.67 | 149 | 0.15 | 82
Clare | 17 | 3 | 11 | 2 | 43 | 56 | 18 | 60 | 67 | 0.65 | 0.67 | 74 | 0.24 | 76
[NAME] | 17 | 3 | 5 | 0 | 34 | 39 | 14 | 60 | 49 | 0.29 | 0 | 90 | 0.16 | 54
Grace | 13 | 3 | 2 | 2 | 11 | 19 | 7 | 48 | 46 | 0.15 | 0.67 | 72 | 0.18 | 45
[NAME] | 17 | 3 | 19 | 6 | 20 | 45 | 19 | 60 | 62 | 1.12 | 2 | 108 | 0.18 | 39
Kallie | 17 | 3 | 0 | 0 | 59 | 59 | 18 | 60 | 50 | 0 | 0 | 112 | 0.16 | 69
Meegan | 17 | 3 | 18 | 0 | 15 | 33 | 10 | 60 | 44 | 1.06 | 0 | 64 | 0.16 | 42
[NAME] | 17 | 3 | 20 | 0 | 31 | 51 | 16 | 60 | 54 | 0.18 | 0 | 97 | 0.16
[NAME] | 17 | 3 | 11 | 2 | 18 | 31 | 9 | 60 | 40 | 0.65 | 0.67 | 142 | 0.06
[NAME] | 149 | 27 | 133 | 14 | 261 | 412 | 133 | 528 | 454 | 0.89 | 0.52 | 908 | 0.15
[NAME] | 17 | 3 | 12 | 0 | 37 | 49 | 15 | 60 | 49 | 0.71 | 0 | 97 | 0.15
Olivia | 17 | 3 | 9 | 0 | 29 | 38 | 14 | 60 | 67 | 0.53 | 0 | 77 | 0.18 | 44
TTL ROE | 34 | 6 | 21 | 0 | 66 | 87 | 29 | 120 | 116 | 0.62 | 0 | 174 | 0.17
[NAME] | 17 | 3 | 18 | 6 | 28 | 52 | 18 | 60 | 15 | 1.06 | 2 | 124 | 0.15 | 46
[NAME] | 17 | 3 | 22 | 6 | 24 | 52 | 17 | 60 | 68 | 1.29 | 2 | 93 | 0.18 | 63
Ian | 17 | 3 | 10 | 4 | 24 | 38 | 17 | 60 | 68 | 0.59 | 1.33 | 74 | 0.23 | 45
[NAME] | 17 | 3 | 11 | 7 | 32 | 50 | 23 | 60 | 0 | 0.65 | 2.33 | 107 | 0.21 | 66
[NAME] | 12 | 2 | 9 | 5 | 30 | 44 | 20 | 42 | 49 | 0.53 | 2.5 | 73 | 0.27 | 35
[NAME] | 17 | 3 | 18 | 4 | 39 | 61 | 24 | 60 | 80 | 1.06 | 1.33 | 134 | 0.18 | 47
Sagar | 17 | 3 | 16 | 2 | 21 | 39 | 14 | 60 | 81 | 0.94 | 0.67 | 59 | 0.24 | 39
[NAME] | 17 | 3 | 23 | 0 | 20 | 43 | 15 | 60 | 43 | 1.35 | 0 | 108 | 0.14 | 74
TTL ITALY | 131 | 21 | 127 | 34 | 218 | 379 | 148 | 462 | 404 | 0.97 | 1.62 | 772 | 0.19 | 415
Alana | 9 | 2 | 4 | 8 | 18 | 30 | 9 | 11 | 28 | 0.44 | 4 | 35 | 0.26 | 28
Amanda | 9 | 2 | 2 | 0 | 17 | 19 | 6 | 11 | 36 | 0.22 | 0 | 50 | 0.12 | 17
[NAME] | 9 | 2 | 12 | 0 | 2 | 14 | 6 | 11 | 34 | 1.33 | 0 | 38 | 0.16 | 27 | 0.71
[NAME] | 15 | 3 | 9 | 4 | 59 | 75 | 30 | 18 | 51 | 0.6 | 1.33 | 108 | 0.28 | 79
[NAME] | 10 | 2 | 6 | 4 | 23 | 33 | 12 | 12 | 30 | 0.6 | 2 | 79 | 0.15 | 45
Rainer | 7 | 2 | 4 | 0 | 10 | 14 | 3 | 9 | 26 | 0.57 | 0 | 37 | 0.08 | 22
[NAME] | 12 | 2 | 6 | 2 | 35 | 43 | 18 | 14 | 48 | 0.5 | 1 | 75 | 0.24 | 42
[NAME] | 9 | 2 | 7 | 0 | 27 | 34 | 12 | 11 | 32 | 0.77 | 0 | 70 | 0.17 | 40
Suzanne | 12 | 2 | 2 | 2 | 22 | 26 | 14 | 14 | 40 | 0.17 | 1 | 58 | 0.24 | 34
TTL AUS | 92 | 19 | 52 | 20 | 213 | 288 | 110 | 111 | 325 | 0.57 | 1.05 | 550 | 0.2 | 334
Spreadsheet: 877912d1724849408-help-with-getting-a-total-on-specific-cells-spreadsheet-help
Sheet: Dec

Client | Date sent | Ins company | Amount Claimed | For | Pay to who | Amount paid | Status
 |  |  | 3 |  |  |  | Pending
 |  |  | 3 |  |  |  | Pending
 |  |  | 6 |  |  | 6 | Settled
 |  |  | 7.5 |  |  |  | Declined
 |  |  | 2.2 |  |  |  | Chase
 |  |  | 3 |  |  |  | Pending
 |  |  | 3 |  |  |  | Pending
 |  |  | 2 |  |  | 2 | Settled
Spreadsheet: b7c0332b-bc1c-4937-8fb7-995d192a5d30
Sheet: Sheet1

BUDGET ADJUSTMENT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  | Approval Deadline |  |  | Reason
Details |  |  |  |  | Department, Program, or Accounts Affected
Reason for Adjustment |  |  |  |  | Sponsor
This ordinance will officially transfer the funds for |  |  |  |  | [NAME]
Tow Service division from Public Works to
Neighborhood and Community Services.  The sum of
$1,049,718 will be used for Tow Service to create |  |  |  |  | From/Transferor(s) or Fund Title(s)
and fund this program. |  |  |  |  | [PHONE]
 |  |  |  |  | To/Transferee(s) or [NAME])
 |  |  |  |  | [PHONE]
This ordinance would authorize expenditures for
Tow Services through Neighborhood and Community
Service.  This is being done in the interest of |  |  |  |  | Policy / Program Impact
continuous improvement which would make the
program more responsive to the neighborhoods that |  |  |  |  | Policy or Program | No | X        Yes
are most effected by abandoned automobiles.  With |  |  |  |  | Emphasis Change
Tow Service incorporated into Neighborhood and
Communtiy Services, the department can coordinate |  |  |  |  |  | Moves function from Public
efforts with neighborhood groups to quickly remove |  |  |  |  |  | Works to Neighborhood
the unwanted automobiles from neighborhoods. |  |  |  |  |  | and Community Services
 |  |  |  |  |  | The department is in the
 |  |  |  |  | Operational | process of reviewing [NAME]
 |  |  |  |  | Impact | Service policies to
 |  |  |  |  | Assessment | determine how to best
 |  |  |  |  |  | provide services.
 |  |  |  |  | Council Committee Actions
 |  |  |  |  | Do Pass |  | Hold
 |  |  |  |  | Do Pass (as amended) |  | w/o Recommendation
 |  |  |  |  | Committee Sub. |  | Do Not Pass
 |  |  |  |  | Fact Sheet prepared by: |  | Date
 |  |  |  |  | [NAME]
 |  |  |  |  | Fact Sheet reviewed by: |  | Date
 |  |  |  |  | Reference Numbers
Spreadsheet: 767683d1644579927-variable-column-for-vlookup-possible-index-match-match-to-replicate-values-aligw
Sheet: Sheet2

Aantal ronden aan de leiding gereden per race. |  |  |  | Aantal
 |  |  | Totaal |  | 10° Targa [NAME] | 1° Circuito di Mugello | 11° Targa [NAME]
 |  |  |  |  | nWK | nWK | nWK
 |  |  |  |  | 108 | 64.9 | 108
Abate | Carlo
Ábate | Walter
Abecassis | George
Abney | [NAME]
[NAME] | Lino
Accadia | Agostino
Achard | [NAME]
Acheson | Kenny
Ación | [NAME]
Adams | [NAME]
Adant | [NAME]
Adas | [NAME]
Ader | [NAME]
Adolff | Kurt
Agabashian | Fred
Agostini | Giacomo
Agúero | [NAME]
Aguirre | Juan
Aguirre | [NAME]
Ahrens | Kurt
[NAME] | Guido
Aitken | [NAME]
Alabern | [NAME]
Albanese | [NAME]
Albers | Christijan
Alberti | Augustín
Spreadsheet: 867275d1714124124-logical-test-issue-sample
Sheet: DB_GAAR

Data Extract | Month & Year | Year (FY & YTD) | Valid from | Valid to | Valid from (Out of Usable Stock Alerts Only) DATE ONLY - Helping Column | Valid to (Out of Usable Stock Alerts Only) DATE ONLY - Helping Column | Out of Usable Stock Alert -  Valid from in 30+ weeks (comparison: date of data extract)
2024-01-04 00:00:00 |  |  | 12.06.2024 00:00:05 | 12.06.2024 00:00:05
2024-01-04 00:00:00 |  |  | 27.01.2023 23:59:59 | 27.01.2023 23:59:59
2024-01-04 00:00:00 |  |  | 04.01.2024 11:01:24 | 04.01.2024 11:01:24
2024-01-04 00:00:00 |  |  | 05.03.2024 23:59:58 | 05.03.2024 23:59:58
2024-01-04 00:00:00 |  |  | [NAME] 23:59:58 | [NAME] 23:59:58
2024-01-04 00:00:00 |  |  | 03.06.2023 01:59:59 | 03.06.2023 01:59:59
2024-01-04 00:00:00 |  |  | 19.01.2023 23:59:59 | 19.01.2023 23:59:59
2024-01-04 00:00:00 |  |  | 11.08.2022 14:00:00 | 11.08.2022 14:00:00
2024-01-04 00:00:00 |  |  | 11.08.2022 14:00:00 | 11.08.2022 14:00:00
2024-01-04 00:00:00 |  |  | 25.01.2022 00:59:59 | 25.01.2022 00:59:59
2024-01-04 00:00:00 |  |  | 11.08.2022 14:00:00 | 11.08.2022 14:00:00
2024-01-04 00:00:00 |  |  | 13.02.2024 23:59:58 | 13.02.2024 23:59:58
2024-01-04 00:00:00 |  |  | 08.06.2022 [NAME] | 08.06.2022 [NAME]
2024-01-04 00:00:00 |  |  | 08.06.2022 [NAME] | 08.06.2022 [NAME]
2024-01-04 00:00:00 |  |  | 08.06.2022 [NAME] | 08.06.2022 [NAME]
2024-01-04 00:00:00 |  |  | 08.06.2022 [NAME] | 08.06.2022 [NAME]
2024-01-04 00:00:00 |  |  | 08.06.2022 [NAME] | 08.06.2022 [NAME]
2024-01-04 00:00:00 |  |  | 04.03.2021 00:59:59 | 04.03.2021 00:59:59
2024-01-04 00:00:00 |  |  | 08.02.2022 00:59:59 | 08.02.2022 00:59:59
Spreadsheet: 780411d1652440983-cell-are-supposed-to-be-actual-excel-dates-but-they-are-not-invalid-dates
Sheet: Test File

Comments on Column B | Given Dates (Constants) Are in Column D | Add 1 to test if date is valid | Non-Dates Just Echo Value | Text to columns from Column B | Non-Dates Just Echo Value
 | Date |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
[NAME] shows date is  valid | 2020-12-11 00:00:00 |  |  | 2020-12-11 00:00:00
C4 shows date is not valid | 3/4/22 |  |  | 3/4/22
I expect some invalid dates | Unknown |  |  | Cat
C6 shows date is valid | 2021-02-19 00:00:00 |  |  | 2021-02-19 00:00:00
I expect some invalid dates | Dec. 3rd 2021 |  |  | Dec. 3rd 2021
C8 shows date is valid | 2021-02-05 00:00:00 |  |  | Unknown
C9 shows date is valid | 2020-11-13 00:00:00 |  |  | 2020-11-13 00:00:00
C10 shows date is valid | 2020-11-06 00:00:00 |  |  | 2020-11-06 00:00:00
C11 shows date is not valid | 11/4/2020 |  |  | 11/4/2020
C12 shows date is not valid | 11/2/2020 |  |  | 11/2/2020
C13 shows date is valid | 2021-02-11 00:00:00 |  |  | 2021-02-11 00:00:00
C14 shows date is valid | 2021-03-01 00:00:00 |  |  | 2021-03-01 00:00:00
C15 shows date is valid | 2021-02-18 00:00:00 |  |  | 2021-02-18 00:00:00
C16 shows date is valid | 2021-02-15 00:00:00 |  |  | 2021-02-15 00:00:00
C17 shows date is valid | 2020-05-27 00:00:00 |  |  | 2020-05-27 00:00:00
C18 shows date is valid | 2020-10-30 00:00:00 |  |  | 2020-10-30 00:00:00
 | 10/27/2020 |  |  | 10/27/2020
 | 11/06/2020 |  |  | 11/06/2020
 | 11/11/2020 |  |  | 11/11/2020
 | 2020-11-06 00:00:00 |  |  | 2020-11-06 00:00:00
 | 11/11/2020 |  |  | 11/11/2020
 | 11/12/2020 |  |  | 11/12/2020
 | 2021-02-05 00:00:00 |  |  | 2021-02-05 00:00:00
 | 2021-02-04 00:00:00 |  |  | 2021-02-04 00:00:00
 | 2021-02-08 00:00:00 |  |  | 2021-02-08 00:00:00
 | 2021-02-05 00:00:00 |  |  | 2021-02-05 00:00:00
 | 2021-02-10 00:00:00 |  |  | 2021-02-10 00:00:00
 | 3/19/2021 |  |  | 3/19/2021
Spreadsheet: 141425d1329255823-sorting-based-on-two-columns-chandramohan19
Sheet: Copy of date trim for 2000b

START_DATE | END_DATE | TYPES | RECIPIENT | CODE | Pattern | Description | Result
2000-04-27 00:00:00 | 2000-05-13 00:00:00 | PP | VE421 | 1 | ACTIVE | VE421 is part of PP,FF,MM and both dates are in 2000
2000-05-14 00:00:00 | 2000-07-18 00:00:00 | MM | YN599 | 2 | NEED NOT BE CONSIDERED | Because the RECIPIENT is associated with MM and FF.
2000-07-19 00:00:00 | 2000-08-20 00:00:00 | FF | [NAME] | 1 | ACTIVE | [NAME] is part of FF,PP.
2000-08-26 00:00:00 | 2000-10-13 00:00:00 | MM | VE421 | 1 | ACTIVE | VE421 is part of PP,FF,MM and both dates are in 2000
2000-10-14 00:00:00 | 2000-11-16 00:00:00 | FF | YN599 | 2 | NEED NOT BE CONSIDERED | Because the RECIPIENT is associated with MM and FF.
2000-01-01 00:00:00 | 2000-02-03 00:00:00 | PP | WA998 | 1 | ACTIVE | WA998 is part of PP,MM nd both dates are in 2000
2000-12-23 00:00:00 | 2000-04-25 00:00:00 | FF | VE421 | 1 | ACTIVE | VE421 is part of PP,FF,MM and both dates are in 2000
2000-01-27 00:00:00 | 2000-02-24 00:00:00 | MM | WA998 | 1 | ACTIVE | WA998 is part of PP,MM nd both dates are in 2000
2000-04-01 00:00:00 | 2000-05-03 00:00:00 | PP | [NAME] | 2 | ACTIVE | Because   i)YZ681 is part of PP and FF  ii)The Start and End dates are in 2000.
2000-03-16 00:00:00 | 2000-05-18 00:00:00 | PP | WE034 | 2 | ACTIVE | Because both dates are part of year 2000 and WE034 is of Type PP and code is of type '1' or '2'.
2000-05-19 00:00:00 | 2000-08-15 00:00:00 | MM | WX622 | 3 | NEED NOT BE CONSIDERED | Because the RECIPIENT is associated with MM only
2000-04-10 00:00:00 | 2000-05-12 00:00:00 | FF | ZZ072 | 1 | NEED NOT BE CONSIDERED | Because the RECIPIENT is associated with FF only
2001-06-12 00:00:00 | 2001-06-30 00:00:00 | PP | WE034 | 1 | NEED NOT BE CONSIDERED | Because either of the dates end in 2001.
2000-06-12 00:00:00 | 2000-06-30 00:00:00 | PP | WE034 | 3 | NEED NOT BE CONSIDERED | Because the Code is '3'.
PP,MM,FF = VE421(SINCE IT IS COMMON ACROSS ALL THREE) PP,MM=WA998(SINCE IT IS COMMON ACROSS PP,MM) PP,FF=YZ681(SINCE IT IS COMMON ACROSS PP,FF) PP = WE034 (SINCE IT OCCURS FOR PP ALONE).  ALL OTHER RECIPIENTS CAN BE DISCARDED. ALSO SINCE THE RECIPIENT IDs WILL BE UNIQUE,HOW DO I CHECK FOR EVERY SINGLE RECIPIENT IN THIS IF CONDITION? SHOULD I HAVE TO DECLARE IT IN A DIFFERENT WAY?
Spreadsheet: 704551d1605620502-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects-web-post
Sheet: TGR View

ERF | Site [NAME] | Date (Estimate Complete) | Date  (Outage Start) | SORT ALL FROM HERE Status | Notes | SN# or PO# or  WBS# | SO# (ZM02, ZM03) OR MHPS Standard Order
Spreadsheet: 798059d1664288749-countifs-produces-only-zeros-paige-absence-tracker
Sheet: Sheet1

SICKNESS RECORDS |  |  |  |  | SUMMARY
EMPLOYEE NAME | START DATE | END DATE | TOTAL DAYS BY OCCASION |  |  | TOTAL DAYS (LAST 3 MONTHS) | TOTAL DAYS (LAST 12 MONTHS) | TOTAL OCCASIONS (LAST 3 MONTHS) | TOTAL OCCASIONS (LAST 12 MONTHS)
[NAME] |  |  | 0 |  | [NAME] |  |  |  |  |  |  | [NAME] points:
[NAME] | 25/09/2022 | 25/09/2022 | 1 |  | [NAME] |  |  |  |  |  |  | 3 episodes in 3 months
[NAME] | 24/06/2022 | 25/06/2022 | 2 |  | Georgie |  |  |  |  |  |  | 6 working days in 3 months
[NAME] | 16/06/2022 | 16/06/2022 | 1 |  | Daniella |  |  |  |  |  |  | 5 episodes in 12 months
[NAME] | 2022-09-06 00:00:00 | 2022-10-06 00:00:00 | 1.5 |  | [NAME] |  |  |  |  |  |  | 10 working days / 12 months
[NAME] | 21/04/2022 | 22/04/2022 | 2 |  | [NAME]
[NAME] | [NAME] | [NAME] | 2 |  | [NAME]
[NAME] | 2021-11-11 00:00:00 | 22/11/2021 | 10 |  | [NAME]
Georgie | 14/06/2022 | 14/06/2022 | 1
Georgie | 30/03/2022 | 31/03/2022 | 2
Daniella | 23/06/2022 | 23/06/2022 | 1
Daniella | 29/03/2022 | 31/03/2022 | 3
Daniella | 26/10/2021 | 26/10/2021 | 1
[NAME] |  |  | 0
[NAME] | 23/09/2022 | 23/09/2022 | 1
[NAME] | 26/08/2022 | 26/08/2022 | 1
[NAME] | 13/08/2022 | 13/08/2022 | 1
[NAME] | 31/07/2022 | 31/07/2022 | 1
[NAME] | 2022-07-07 00:00:00 | 2022-07-07 00:00:00 | 1
[NAME] | 27/06/2022 | 27/06/2022 | 1
[NAME] | 17/06/2022 | 17/06/2022 | 1
[NAME] | 24/05/2022 | 24/05/2022 | 1
[NAME] | 2022-07-05 00:00:00 | 2022-08-05 00:00:00 | 2
[NAME] | 20/04/2022 | 22/04/2022 | 2
[NAME] | 2022-04-04 00:00:00 | 2022-04-04 00:00:00 | 1
[NAME] | [NAME] | [NAME] | 1
[NAME] | 2022-07-03 00:00:00 | 2022-07-03 00:00:00 | 1
[NAME] | 2022-11-02 00:00:00 | 2022-11-02 00:00:00 | 1
[NAME] | 25/01/2022 | 25/01/2022 | 1
[NAME] | 2022-02-01 00:00:00 | 2022-02-01 00:00:00 | 1
[NAME] | 19/11/2021 | 19/11/2021 | 1
[NAME] | 2021-01-11 00:00:00 | 2021-02-11 00:00:00 | 2
[NAME] | 13/10/2021 | 13/10/2021 | 1
[NAME] | 2021-04-10 00:00:00 | 2021-05-10 00:00:00 | 2
[NAME] | 2022-07-09 00:00:00 | 13/09/2022 | 4
[NAME] | 23/08/2022 | 26/08/2022 | 3
[NAME] | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 1
[NAME] | 2022-02-02 00:00:00 | 2022-02-02 00:00:00 | 0.5
[NAME] | 28/01/2022 | 28/01/2022 | 1
[NAME] | 15/01/2022 | 16/01/2022 | 2
[NAME] | 2022-06-01 00:00:00 | 14/01/2022 | 6
[NAME] | 13/12/2021 | 14/12/2021 | 2
[NAME] | 30/06/2022 | 30/06/2022 | 1
[NAME] | 26/12/2021 | 26/12/2021 | 1
Spreadsheet: 177892d1346505024-eliminating-numbers-associated-with-a-percentage-in-a-list-workbook68
Sheet: Sheet1

 |  |  |  |  |  | 0.3
 |  |  |  |  |  |  | 5
 |  |  | 0.3 |  |  |  | 9
 |  |  | 0.35 |  |  |  | 10
 |  |  | 0.3166666666666667 |  |  |  | 11
 |  |  | 0.3666666666666666 |  |  |  | 12
 |  |  | 0.2833333333333333 |  |  |  | 17
 |  |  | 0.3333333333333333 |  |  |  | 21
 |  |  | 0.4 |  |  |  | 22
 |  |  | 0.3833333333333334 |  |  |  | 23
 |  |  | 0.3666666666666666 |  |  |  | 25
 |  |  | 0.4166666666666667 |  |  |  | 26
 |  |  |  |  |  |  | 32
 |  |  |  |  |  |  | 33
 |  |  |  |  |  |  | 35
 |  |  |  |  |  |  | 41
 |  |  |  |  |  |  | 43
 |  |  |  |  |  |  | 45
 |  |  |  |  |  |  | 49
 |  |  |  |  |  |  | 53
 |  |  |  |  |  |  | 54
 |  |  |  |  |  |  | 58
 |  |  |  |  |  |  | 62
 |  |  |  |  |  |  | 64
 |  |  |  |  |  |  | 65
 |  |  |  |  |  |  | 67
 |  |  |  |  |  |  | 68
 |  |  |  |  |  |  | 73
 |  |  |  |  |  |  | 76
 |  |  |  |  |  |  | 77
 |  |  |  |  |  |  | 79
Spreadsheet: 682666d1592244322-an-ugly-variance-formula-needs-help-to-be-pretty-exampleforugly
Sheet: Sheet1

 |  |  |  |  |  |  |  | REVENUE
 |  | 1
 |  | 1 | 3252405.044664206 | 3362693.814597109 |  | 2753299.319987969 |  | Auto Revenue
 |  | 1 | 1298411.933399935 | 1060529.478133083 |  | 858065.2635061527 |  | Home Revenue
 |  | 1 | 2981.149563982322 | 1943.760518059123 |  | 1895.491455702383 |  | Specialty Revenue
 |  | 1 |  |  |  | 0 |  | Travel Revenue
 |  | 1 |  |  |  | 0 |  | Life Revenue
 |  | 1 |  |  |  |  |  | TOTAL REVENUE
 |  |  |  |  |  |  |  | EXPERIENCE CREATION COSTS
 |  | -1 | 2654337.23 | 2949999.99 |  | 2672726.45 |  | ERS Expense
 |  | -1 | 0 | 0 |  | 0 |  | Club Owned Repair
 |  | -1 | 0 | 0 |  | 0 |  | Branch Operations Expense
 |  | -1 | 1179372.32 | 1061624.46 |  | 1292743.88 |  | Sales Commissions
 |  | -1 | 1074692.21 | 1343166.76 |  | 1381493.76 |  | Call Center
 |  | -1 | 0 | 0 |  | 0 |  | Other Experience Creation Costs
 |  | -1 | 4908401.76 | 5354791.21 |  | 5346964.09 |  | TOTAL EXPERIENCE CREATION COSTS
Spreadsheet: 854006d1703959928-calculating-annual-totals-of-various-cells-columns-annualtotals-dynamic-table
Sheet: DT2

[NAME] | Soma de Miles (dec)
DL | 178.625
DMU | 4293.35
EL | 592.1500000000001
EMU | 19239.72500000006
Misc | 2.55
MON | 1.5
SL | 66.67500000000001
Tram | 17.5
Tube | 105.2499999999999
Total Geral | 24497.32500000006
Spreadsheet: dan_hyvl__4908__lakeland transaction agrmt exhibit c
Sheet: Sheet1

FGT Receipt Points
FTS - I Receipt Points
Volume at | Zone 1 | Zone 2 | Zone 2 | Zone 2 | Zone 3 | Zone 3 | Zone 3 | Zone 3 | Zone 3 | Zone 3 | Zone 3 | All Zone
Receipt | 25809 | 28166 | 10876 | 32606 | 71287 | 9903 | 9908 | 41512 | 9906 | 157553 | 41513 | Using
Point | MOPS | CSX Plant | LRC | NGPL | AIM-ANGI | Transco | [NAME] | Main | UGPL | FGT | Main | FTS - I
Month | Refugio | Outlet | [NAME] | Vermilion | [NAME] | [NAME] | [NAME] | Pass 77 | [NAME] | Citronell | Pass 108 | Total
Jan | 3261 | 3637 | 547 | 0 | 544 | 1587 | 1909 | 0 | 0 | 0 | 0 | 11485
Feb | 3261 | 3637 | 547 | 0 | 544 | 1587 | 1909 | 0 | 0 | 0 | 0 | 11485
Mar | 3261 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3261
Apr | 4172 | 0 | 0 | 0 | 194 | 2643 | 663 | 0 | 0 | 0 | 0 | 7672
May | 6029 | 0 | 0 | 2277 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8306
Jun | 6029 | 0 | 0 | 2277 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8306
Jul | 6029 | 0 | 0 | 2277 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8306
Aug | 6029 | 0 | 0 | 2277 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8306
Sep | 6029 | 0 | 0 | 2277 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8306
Oct | 6882 | 0 | 0 | 3070 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9952
Nov | 3261 | 9876 | 547 | 0 | 544 | 1587 | 1909 | 0 | 0 | 0 | 0 | 17724
Dec | 3261 | 3637 | 547 | 0 | 544 | 1587 | 1909 | 0 | 0 | 0 | 0 | 11485
Ave | 4792 | 1732.25 | 182.3333333333333 | 1204.583333333333 | 197.5 | 749.25 | 691.5833333333334 | 0 | 0 | 0 | 0 | 9549.5
FTS - II Receipt Points
Volume at | Zone 1 | Zone 2 | Zone 2 | Zone 2 | Zone 3 | Zone 3 | Zone 3 | Zone 3 | Zone 3 | Zone 3 | Zone 3 | All Zone
Receipt | 25809 | 28166 | 10876 | 32606 | 71287 | 9903 | 9908 | 41512 | 9906 | 157553 | 41513
Point | MOPS | CSX Plant | LRC | NGPL | AIM-ANGI | Transco | [NAME] | Main | UGPL | FGT | Main
Month | Refugio | Outlet | [NAME] | Vermilion | [NAME] | [NAME] | [NAME] | Pass 77 | [NAME] | Citronell | Pass 108 | Total
Jan | 4404 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 780 | 4028 | 4232 | 13444
Feb | 4404 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 780 | 4028 | 4232 | 13444
Mar | 4404 | 0 | 1572 | 0 | 544 | 3137 | 0 | 0 | 3027 | 4028 | 4232 | 20944
Apr | 4404 | 2153 | 642 | 990 | 0 | 3270 | 0 | 0 | 2917 | 4028 | 4232 | 22636
May | 5218 | 0 | 0 | 3401 | 0 | 0 | 0 | 967 | 1411 | 4994 | 4232 | 20223
Jun | 5218 | 0 | 0 | 3401 | 0 | 0 | 0 | 967 | 1411 | 4994 | 4232 | 20223
Jul | 5218 | 0 | 0 | 3401 | 0 | 0 | 0 | 967 | 1411 | 4994 | 4232 | 20223
Aug | 5218 | 0 | 0 | 3401 | 0 | 0 | 0 | 967 | 1411 | 4994 | 4232 | 20223
Sep | 5218 | 0 | 0 | 3401 | 0 | 0 | 0 | 967 | 1411 | 4994 | 4232 | 20223
Oct | 5218 | 0 | 0 | 4757 | 0 | 0 | 0 | 967 | 780 | 4994 | 4232 | 20948
Nov | 4404 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 780 | 4028 | 4232 | 13444
Dec | 4404 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 780 | 4028 | 4232 | 13444
Ave | 4811 | 179.4166666666667 | 184.5 | 1896 | 45.33333333333334 | 533.9166666666666 | 0 | 483.5 | 1408.25 | 4511 | 4232 | 18284.91666666667
Proposed [NAME]
Volume at | Mobile Bay
Receipt | at Golden, AL
Point | Gas Plants
Month
Jan | 30000
Feb | 30000
Mar | 30000
Apr | 30000
May | 30000
Jun | 30000
Jul | 30000
Aug | 30000
Sep | 30000
Oct | 30000
Nov | 30000
Dec | 30000
Ave | 30000
Spreadsheet: 204723d1357625062-reminder-and-payment-renewal-listing_avk
Sheet: TRACKER

 |  | ILP RENEWAL LISTING 2013
S | No. | Customer Name | Policy No. | Policy Date | Mode | Payment | Premium | Trade In |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | DUE DURING PERIOD | Remark | MONTHS | END DATE | TODAY DATE | STATUS | 1 |  |  |  |  |  |  |  |  |  |  |  | DAYS | DUE DATE INTIMATION BEFORE 30 DAYS | DAYS LEFT | CURRENT MONTH&YEAR | CURRENT MONTH | CURRENT YEAR
 | 26 | ABCD | 12345678 | 2012-08-22 00:00:00 | Yearly | D.Payment | 2220 | 5000 |  | O | N | R |  |  |  |  |  |  |  |  |  |  | 2013-07-22 00:00:00
 | 37 | ABCD | 12345678 | 2012-06-07 00:00:00 | Half Yearly | C.Card | 1944 |  |  | O | N | R |  |  |  |  |  |  |  |  |  |  | 2013-05-07 00:00:00
 | 42 | ABCD | 12345678 | 2012-09-27 00:00:00 | Quarterly | C.Card | 2400 | 3000 |  | O | N | R |  |  |  |  |  |  |  |  |  |  | 2013-08-27 00:00:00
 | 43 | ABCD | 12345678 | 2012-01-15 00:00:00 | Monthly | C.Card | 2400 | 8000 |  | O | N | R |  |  |  |  |  |  |  |  |  |  | 2013-02-08 00:00:00
 | 44 | ABCD | 12345678 | 2012-10-08 00:00:00 | Yearly | C.Card | 3000 |  |  | O | N | R |  |  |  |  |  |  |  |  |  |  | 2013-09-08 00:00:00
 | 45 | ABCD | 12345678 | 2012-10-09 00:00:00 | Top Up | C.Card | 2100 |  |  | O | N | R |  |  |  |  |  |  |  |  |  |  | 2013-09-09 00:00:00
 | 1 | For this policy date & remark, can I make a remind in reminder sheet? All the date is just show on the current month in the reminder sheet. (can be do it on excel?)
 | 2 | I wan the policy due date highlight until the payment is made (for payment is pay is "O green colour"). I oso have 4 mode "yearly / half yearly / quarterly / monthly" (how to set it for I choose any one will happen to the highlingt