tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 754390d1636130678-transfer-specific-information-from-several-files-to-one-payment-history-a20-sample-1
Sheet: Sheet1

PAYMENT HISTORY
 | RENT | PAST DUE | LATE FEE | TOTAL DUE | AMT PAID | BALANCE | DATE PAID
2021-01-01 00:00:00 | 955 | 695.57 | 47.75 | 1698.32 | 0 | 1698.32
2021-02-01 00:00:00 | 955 | 1698.32 | 47.75 | 2701.07 | 1000 | 1701.07
2021-03-01 00:00:00 | 955 | 1701.07 | 43.93 | 2700 | 2700 | 0 | 2021-03-17 00:00:00
2021-04-01 00:00:00 | 955 | 0 | 0 | 955 | 1000 | -45 | 2021-04-02 00:00:00
2021-05-01 00:00:00 | 955 | -45 | 45.49984375 | 955.49984375 | 1000 | -44.50015625000003 | 2021-05-12 00:00:00
2021-06-01 00:00:00 | 970 | -44.50015625000003 | 10 | 935.49984375 | 1000 | -64.50015625000003 | 2021-06-10 00:00:00
2021-07-01 00:00:00 | 970 | -64.50015625000003 | 10 | 915.49984375 | 1000 | -84.50015625000003 | 2021-07-23 00:00:00
2021-08-01 00:00:00 | 970 | -84.50015625000003 | 10 | 895.49984375 | 0 | 895.49984375
2021-09-01 00:00:00 | 970 | 895.49984375 | 10 | 1875.49984375 | 900 | 975.4998437499999 | 2021-09-10 00:00:00
2021-10-01 00:00:00 | 970 | 975.4998437499999 | 10 | 1955.49984375 | 900 | 1055.49984375
Spreadsheet: 790328d1659640728-12-month-rolling-calendar-for-occurences-example-attendance-tracker
Sheet: Attendance Tracker

 | Employee [NAME]
 |  |  |  | If the there is unplanned PTO that lasts for multiple days that should only be logged as unplanned for one day. Consequtive days should be logged as planned PTO as the entire event counts as one occurrence. |  | If a partial day is taken - type in the number of hours over the automatic calculation
 |  | Click in the field you want to insert date in and then click and the date on the calendar and it will enter the date in the selected field. |  |  |  |  |  |  | Always enter a note or comment for each occurrence
 | Employee Name | Start Date | End Date | Type of Leave | Days | Hours | Is this an occurrence? | # of Occurrences | Comments
 | Agent 1 | 2021-07-01 00:00:00 | 2021-07-01 00:00:00 | No Call/No Show |  |  | Yes | 2
 | Agent 1 | 2021-07-06 00:00:00 | 2021-07-06 00:00:00 | No Call/No Show |  |  | Yes
 | Agent 1 | 2022-08-03 00:00:00 | 2022-08-03 00:00:00 | Unscheduled Absence |  |  | Yes
 | Agent 1 | 2022-06-01 00:00:00 | 2022-06-01 00:00:00 | Unscheduled Absence |  |  | Yes
 | Agent 1 | 2021-08-15 00:00:00 | 2021-08-15 00:00:00 | Unscheduled Absence |  |  | Yes
Spreadsheet: 866767d1713683222-debtor-ageing-with-adjustment-of-credit-balance-on-fifo-basis-debtor-ageing-template
Sheet: Debtor ageing template

 | OLD DEBTOR AGEING |  |  |  |  |  |  | DESIRED DEBTOR AGEING
 | Total | 0-30 | 31-60 | 61-90 | 91-120 | >180 |  | New Bal | 0-30 | 31-60 | 61-90 | 91-120 | >180
Case1 |  | 100 | 700 | 400 | -2500 | 1800 |  |  |  |  | 0 | 0 | 0
Case2 |  | 100 | -200 | -300 | 400 | 1800 |  |  |  | 0 | 0
Case3 |  | 100 | -200 | -300 | -1900 | 1800 |  |  | 0 |  |  | 0
Case 1
2500 negative balance is adjusted till 31-60 bucket and balance of 400 placed in 31-60 bucket and 0-30 bucket kept as it is since negative 2500 is exhausted in bucket 31-60
Case 2
Positive balance of 1800 in bucket >180 adjusted against 61-90 & 31-60 and balance 1300 kept as it is same bucket. Rest bucket same as it since there is no negative balance to adjust.
Case 3
Balance 1800 in bucket is adjusted in bucket >180 and bucket 0-30. Being balance in 91-120 exhausted, rest bucket kept as it.
Spreadsheet: 91503d1291221185-automatic-ranking-of-multiple-datasets-formula-or-code-example
Sheet: Sheet1

 | Dataset1 | 3.130199999999999 | 2 |  |  | So in this example i have performed a simple rank, however i had to maually create the formulae for it, ideally since i have to analyse so much data i would like a formulae which recognises the blanks either side and knows whish array to rank as a result. Im sure this must be possible?
 |  | 2.9187 | 3
 |  | 1.8189 | 6
 |  | 2.8341 | 4
 |  | 1.8189 | 6
 |  | 2.284199999999999 | 5
 |  | 6.048900000000001 | 1
 |  | 1.8189 | 6 |  |  | Data sets can range from 2 - 35, are always numerical and always have a blank cell above and below (assuming this can be used as a reference point somhow?.) Also i need to analyse up to 150 data sets per day, this ranking step is but a small component of the bigger picture, and shouldnt take me as long as it is currently.
 | Dataset2 | 1.8189
 |  | 2.6649
 |  | 1.8189
 |  | 2.538
 |  | 2.5803
 | Dataset3 | 2.8341
 |  | 2.115
 |  | 2.6649
 |  | 1.8189
Spreadsheet: chris_germany__1805__2000new11
Sheet: CGAS

 | A | B | C | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y
 |  |  |  |  | A+B+C |  | Storage | Storage |  | F-I
 | CES Retail | [NAME] | Dayton |  | Total |  | Gross | Net |  |  |  | Exhibit 1 |  | 1st of Month | [NAME] | Total Req |  | O-K |  | Gas Daily
1 | 135955 | 11185 | 13262 |  |  |  | 33135 |  |  |  |  | n/a |  |  | 36124 |  |  |  |  | 2.77
 | 172800 | 11168 |  |  |  |  | 44907 |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.9
 | 158218 | 10419 |  |  |  |  | 40994 |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.985
 | 135473 | 10363 |  |  |  |  | 30645 |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.92
 | 130408 | 10383 |  |  |  |  | 36820 |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.895
 | 0 | 0 | 0 |  |  |  | 0 |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.895
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.895
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.93
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.99
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.76
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.77
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.775
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.775
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.775
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.745
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.755
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.785
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.79
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.78
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.78
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.78
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.78
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.67
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.595
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.63 |  |  | 166288 | 2.63
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.63 |  |  | 166288 | 2.63
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.63 |  |  | 166288 | 2.63
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.63 |  |  | 166288 | 2.63
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.63 |  |  | 166288 | 2.63
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.63 |  |  | 166288 | 2.63
 |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  | 2.63 |  |  | 166288 | 2.63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <== Total Undertakes
Spreadsheet: 92125d1291782619-match-and-countif-match-and-countif-help
Sheet: W13

Player1 | X | X | X | x | X | X | X | 7
Player2 |  | X | X | X |  |  |  | 3
Player3 | X | x | X |  | X |  | X | 5
Player4 | X | X | x |  | X | X | X | 6
Spreadsheet: 830231d1684812340-automate-totals-from-employees-entering-data-book1-1-
Sheet: Expenses Trips

 |  | INPUT AREA FOR STAFF
 |  | Enter Trip number (1, 2, 3…) | Month Needed | Transport | Taskforce days | Room | Room  Cost | Meals  Cost | Automatic calculation | Automatic calculation | Automatic calculation | 12 | 11.5 | 11 | 10.5 | 10 | 9.5 | 9 | 8.5 | 8 | 7.5 | 7 | 6.5 | 6 | 5.5 | 5 | 4.5 | 4 | 3.5 | 3 | 2.5 | 2 | 1.5 | 1 | 0.5 | Opening
 | Position | Trip Number | Month out | Plane/car | Work Days | Nights | Per Night | Per Day | Room & Meals Cost | Transportation Cost | TOTAL  Cost | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months
5.101 | Position 1 | 1 | 12 | 5000 | 5 | 4 | 2000 | 300
 | Position 1 | 2 | 8 | 5000 | 5 | 4 | 2000 | 300
 | Position 1 | 3 | 6 | 5000 | 6 | 5 | 2000 | 300
 | Position 2 | 1 | 2 | 5000 | 14 | 13 | 2000 | 300
 | Position 2 | 2 | 1 | 5000 | 7 | 6 | 2000 | 300
 |  | DESIRED OUTPUT
 |  |  |  | 12 | 11.5 | 11 | 10.5 | 10 | 9.5 | 9 | 8.5 | 8 | 7.5 | 7 | 6.5 | 6 | 5.5 | 5 | 4.5 | 4 | 3.5 | 3 | 2.5 | 2 | 1.5 | 1 | 0.5 | Opening
 | Position | total trips | Total Trips days | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months | Months
Spreadsheet: 777893d1650649113-how-to-change-cell-name-based-on-another-cell-and-place-data-on-correct-row-sample-workbook
Sheet: eCheck-in Data

 | Completed | % | In Progress | % | Not Yet Available | % | Not Started | % | Total Clinic Visits | % of TH Compared to All Clinics
CLINIC
CLINIC 1 OP
CLINIC 2 OP
CLINIC 3 OP
Spreadsheet: 816728d1675794674-conditional-formatting-based-on-two-cells-matching-using-a-different-range-year-planner-annual-leave-planner
Sheet: Planner

Apprentice: | Start date | End date | Scheme | Carry over | Total | Used | Balance
Person 1 | 2022-09-19 00:00:00 | 2024-03-15 00:00:00 | (BCD2) Scheme Level 4 | 0
Person 2 | 2022-04-04 00:00:00 | 2023-10-03 00:00:00 | (CDE3) Scheme Level 5 | 0
Person 3 | 2022-04-04 00:00:00 | 2023-10-03 00:00:00 | (CDE3) Scheme Level 5 | 0
Person 4 | 2022-04-04 00:00:00 | 2023-10-03 00:00:00 | (DEF4) Scheme Level 6 | 0
Person 5 | 2022-04-04 00:00:00 | 2023-10-03 00:00:00 | (EFG5) Scheme Level 4 | 0
Spreadsheet: 110214d1306943628-3d-vlookup-test-results-for-forum-v5
Sheet: KS3 Boundaries

[NAME] | RefCell | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | Level
 | Level 2 | 24 | 20 | 15 | 26 | 27 | 27 | 26 | 26 | 28 | 23 | 23 | 24 | 25 | 20 | 2
 | Level 3 | 39 | 30 | 20 | 32 | 33 | 33 | 32 | 32 | 34 | 29 | 29 | 30 | 31 | 26 | 3
 | Level 4 | 68 | 61 | 54 | 72 | 69 | 69 | 67 | 66 | 68 | 64 | 63 | 63 | 67 | 59 | 4
 | Level 5 | 90 | 88 | 87 | 107 | 108 | 104 | 104 | 102 | 102 | 99 | 100 | 99 | 103 | 96 | 5
[NAME] |  | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
 | Level 3 | 27 | 24 | 23 | 26 | 26 | 27 | 26 | 27 | 24 | 23 | 24 | 26 | 25 | 24 | 3
 | Level 4 | 37 | 32 | 28 | 32 | 32 | 33 | 32 | 33 | 30 | 29 | 30 | 32 | 31 | 30 | 4
 | Level 5 | 60 | 55 | 55 | 63 | 61 | 60 | 58 | 59 | 55 | 54 | 55 | 56 | 58 | 54 | 5
 | Level 6 | 81 | 79 | 81 | 92 | 92 | 89 | 89 | 88 | 83 | 83 | 84 | 83 | 87 | 82 | 6
Tier 5 - 7 |  | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
 | Level 4 | 22 | 22 | 24 | 31 | 30 | 32 | 31 | 31 | 26 | 25 | 28 | 26 | 27 | 26 | 4
 | Level 5 | 32 | 30 | 29 | 37 | 36 | 38 | 37 | 37 | 32 | 31 | 34 | 32 | 33 | 32 | 5
 | Level 6 | 53 | 48 | 45 | 62 | 61 | 61 | 61 | 59 | 54 | 55 | 57 | 54 | 56 | 55 | 6
 | Level 7 | 81 | 81 | 78 | 99 | 95 | 93 | 93 | 89 | 86 | 89 | 88 | 87 | 90 | 88 | 7
Tier 6 - 8 |  | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
 | Level 5 | 20 | 22 | 24 | 39 | 38 | 37 | 35 | 32 | 33 | 33 | 34 | 33 | 33 | 33 | 5
 | Level 6 | 30 | 30 | 29 | 45 | 44 | 43 | 41 | 38 | 39 | 39 | 40 | 39 | 39 | 39 | 6
 | Level 7 | 51 | 48 | 46 | 72 | 70 | 68 | 66 | 58 | 60 | 63 | 61 | 61 | 62 | 62 | 7
 | Level 8 | 81 | 81 | 79 | 109 | 108 | 110 | 107 | 94 | 97 | 101 | 98 | 99 | 72 | 100 | 8
Tier 7 - 8 |  | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
 | Level 5 | 20 | 22 | 24 | 39 | 38 | 37 | 35 | 32 | 33 | 33 | 34 | 33 | 50 | 33 | 5
 | Level 6 | 30 | 30 | 29 | 45 | 44 | 43 | 41 | 38 | 39 | 39 | 40 | 39 | 60 | 39 | 6
 | Level 7 | 51 | 48 | 46 | 72 | 70 | 68 | 66 | 58 | 60 | 63 | 61 | 61 | 70 | 62 | 7
 | Level 8 | 81 | 81 | 79 | 109 | 108 | 110 | 107 | 94 | 97 | 101 | 98 | 99 | 80 | 100 | 8
EP |  | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006
 | Level 9 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | Level 10 | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | EP |  | 28 | 22 | 22 | 24 | 24 | 22 | 23 |  |  |  |  |  |  | EP
Spreadsheet: 875420d1721990561-sum-after-sort-unique-vstack-with-criteria-for-multiple-worksheet-vstack-with-criteria-3-
Sheet: Summary

 |  |  | P1 |  | P2 |  | P3 |  | P4
 | Particulars | ID | Header 1 | [NAME] | Header 1 | [NAME] | Header 1 | [NAME] | Header 1 | [NAME]
 | Apple | 5263 | 52 |  | 147
 | Apple |  | 36 | 44 | 36
 | Deep | 412 | 44 |  | 44
 | Nuts | 3 | 4 |  | 4
 | Orange | 125 | 55 |  | 57
 | Text1 | 26 | 64 |  | 64
Spreadsheet: 25ed47dc-389e-416c-995f-ef35e8d7bfea
Sheet: EPR BS

Unaudited Condensed Consolidated Balance Sheets
 | September 30,
 | 2012 |  | 2011
(In millions)
Assets
Current assets
Cash and equivalents | 206.3 |  | 460
Restricted cash and investments | 81.9 |  | 92
Jackpot annuity investments | 60.2 |  | 63.2
Receivables, net | 564.8 |  | 487.2
Inventories | 92.9 |  | 73
Other assets and deferred costs | 257.2 |  | 234.5
Total current assets | 1263.3 |  | 1409.9
Property, plant and equipment, net | 555.6999999999999 |  | 552.1
Jackpot annuity investments | 295.7 |  | 324.6
Contracts and notes receivable, net | 139.3 |  | 126.4
Goodwill and other intangibles, net | 1663.1 |  | 1401.8
Other assets and deferred costs | 368 |  | 339.6
Total Assets | 4285.1 |  | 4154.400000000001
Liabilities and Shareholders' Equity
Current liabilities
Accounts payable | 87.5 |  | 103
Jackpot liabilities, current portion | 152.4 |  | 143
Dividends payable | 16 |  | 17.8
Other accrued liabilities | 374.4 |  | 270.9
Total current liabilities | 630.3 |  | 534.7
Long-term debt | 1846.4 |  | 1646.3
Jackpot liabilities | 328.6 |  | 365.4
Other liabilities | 282 |  | 163.2
Total Liabilities | 3087.3 |  | 2709.6
Total Equity | 1197.8 |  | 1444.8
Total Liabilities and Shareholders' Equity | 4285.099999999999 |  | 4154.4
Spreadsheet: 679793d1590632788-extract-peak-value-with-date-and-timestamp-meter-totalization-1-
Sheet: Sheet1

 |  | [NAME] | Date | Time | KW |  | [NAME] | Date | Time | KW
 |  | 5000 | 5012020 | 17:00:00 | 14.1 |  | 5001 | 5012020 | 17:00:00 | 13.33
 |  | 5000 | 5022020 | 17:15:00 | 14.34 |  | 5001 | 5022020 | 17:15:00 | 13.42
 |  | 5000 | 5032020 | 17:30:00 | 14.2 |  | 5001 | 5032020 | 17:30:00 | 13.33
 |  | 5000 | 5042020 | 17:45:00 | 13.83 |  | 5001 | 5042020 | 17:45:00 | 13.58
 |  | 5000 | 5052020 | 18:00:00 | 13.65 |  | 5001 | 5052020 | 18:00:00 | 13.34
 |  | 5000 | 5062020 | 18:15:00 | 13.65 |  | 5001 | 5062020 | 18:15:00 | 13.51
 |  | 5000 | 5072020 | 18:30:00 | 13.65 |  | 5001 | 5072020 | 18:30:00 | 14.49
 |  |  |  |  | [NAME] | 5000 | 5001
 |  |  |  |  | [NAME]
 |  |  |  |  | Date
 |  |  |  |  | Time
 |  |  |  |  | Totalized
 |  |  |  |  |  |  | Input | 5032020
 |  |  |  |  |  |  | Input | 17:30:00
 |  |  |  |  | Response | Meter # | 5000
 |  |  |  |  | Response | Meter # | 5001
 |  |  |  |  | Total
Spreadsheet: 36869d1234844796-transfer-data-between-sheets-trial-roster
Sheet: Report

 |  |  |  | Progressive
 |  |  |  | Record of rent paid
Enter date |  |  |  | (date) | ($ amount) | date according to date entered B2
Enter Time |  | This data from sheet 1 (Data) |  | (date) | ($ amount) | and amount from 'Rent paid today' B15
 | Service type | according to date and time entered |  | (date) | ($ amount)
 | Officiate | according to date and time entered |  | (date) | ($ amount)
 | Sentence | according to date and time entered |  | (date) | ($ amount)
 | Topic | according to date and time entered |  | (date) | ($ amount)
 | Welcomer | according to date and time entered |  | (date) | ($ amount)
 |  |  |  | (date) | ($ amount)
 |  |  |  | (date) | ($ amount)
 | Enter |  |  | (date) | ($ amount)
 | Rent paid today |  |  | (date) | ($ amount)
 | $ |  |  | (date) | ($ amount)
 |  |  |  | (date) | ($ amount)
 |  |  |  | (date) | ($ amount)
 |  |  |  | (date) | ($ amount)
 |  |  |  | Total so far =
Spreadsheet: 872099d1718459220-help-to-understand-and-amend-lambda-functions-0187-spill-multiple-filter-functions-complete-aligw
Sheet: Sheet1

PO Number | Value | Invoice List |  | Invoice Number | PO Number | Value |  | PO Number | PO Value | Invoice Value | [NAME] | Invoice List
PO0001 | 120 |  |  | INV01 | PO0001 | 60
PO0002 | 160 |  |  | INV02 | PO0003 | 150 |  | PO0002 | 160 | 160 | 0 | INV03
PO0003 | 450 |  |  | INV03 | PO0002 | 160 |  | PO0003 | 450 | 600 | -150 | INV02, INV05, INV07
PO0004 | 290 |  |  | [NAME] | PO0001 | 60 |  | PO0004 | 290 | 250 | 40 | INV06, INV08
 |  |  |  | INV05 | PO0003 | 300
 |  |  |  | INV06 | PO0004 | 200 |  |  |  |  |  | MAKEARRAY
 |  |  |  | INV07 | PO0003 | 150 |  |  |  |  |  |  | [NAME]
 |  |  |  | INV08 | PO0004 | 50 |  |  |  |  |  | INV03
 |  |  |  |  |  |  |  |  |  |  |  | INV02 | INV05 | INV07
Sample Problem 1 |  |  |  |  |  |  |  |  |  |  |  | INV06 | INV08
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | INV03
 |  |  |  |  |  |  |  |  |  |  |  | INV02 | INV05 | INV07
 |  |  |  |  |  |  |  |  |  |  |  | INV06 | INV08
 |  |  |  |  |  |  |  |  |  |  |  | Custom LAMBDA Version 1
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | INV03
 |  |  |  |  |  |  |  |  |  |  |  | INV02 | INV05 | INV07
 |  |  |  |  |  |  |  |  |  |  |  | INV06 | INV08
 |  |  |  | Sample Problem 2
 |  |  |  |  |  |  |  |  |  |  |  | Custom LAMBDA: | [NAME],fn,LET(indices,SEQUENCE(ROWS(arr)),DROP(REDUCE("",indices,LAMBDA(output,indx,VSTACK(output,[NAME],indx,))))),1)))
 |  |  |  | Input 1 | Input 2 |  |  | Unique List
 |  |  |  | UC1001 | [EMAIL] |  |  |  |  |  |  |  | [EMAIL] | [EMAIL]
 |  |  |  | UC1001 | [EMAIL] |  |  | UC1002 |  |  |  | [EMAIL]
 |  |  |  | UC1001 | [EMAIL] |  |  | UC1005 |  |  |  | [EMAIL] | [EMAIL]
 |  |  |  | UC1002 | [EMAIL]
 |  |  |  | UC1005 | [EMAIL] |  |  |  |  |  |  | Custom LAMBDA Version 2
 |  |  |  | UC1005 | [EMAIL] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | INV03
 |  |  |  | Desired Output |  |  |  |  |  |  |  | INV02 | INV05 | INV07
 |  |  |  |  |  |  |  |  |  |  |  | INV06 | INV08
 |  |  |  |  | [EMAIL] | [EMAIL]
 |  |  |  | [EMAIL] |  |  |  |  |  |  |  | Custom LAMBDA: | =LAMBDA(ar,fn,LET(a,IF(ar="","",ar),c,--(COLUMNS(a)=1),r,REDUCE(0,SEQUENCE(ROWS(a)),LAMBDA(v,i,VSTACK(v,fn(INDEX(a,i,[NAME])))
 |  |  |  | [EMAIL] | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | [EMAIL]
Spreadsheet: louise_kitchen__22856__Netco Commercial4122pm
Sheet: Canada

Power Orig |  | Gas Orig |  | Trading |  | Toronto
Biever |  | Burnham |  | Brodeur |  | Borg
Davies |  | Dunsmore |  | [NAME] |  | DeVries
Lalani |  | [NAME] |  | Cowan |  | Dorland
[NAME] |  | Hrap |  | Disturnal |  | Ellis
Milnthorp |  | Le Dain |  | Dorland |  | Goddard
Savidant |  | Oh |  | Draper |  | Sangermano
 |  | Sangwine |  | Garvey |  | Tripp
 |  |  |  | [NAME] |  | Wilson
 |  |  |  | Richey
 |  |  |  | [NAME]
 |  |  |  | Watt
 |  |  |  | Zufferli
Spreadsheet: tracy_geaccone__40395__NNG3rdCEEM
Sheet: RegAmort

PRINT: PAGE1
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Gas Research Institute (GRI) Calculation
2001 GRI Rate   (INPUT)
North Transport Commodity Volume   (INPUT VOLUME) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Full Margin % |  | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828
Full Margin Volume - North
South Transport Commodity Volume   (INPUT VOLUME) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0
Full Margin Volume - South
Commodity GRI Expense - North
- South
Total Transport Commodity GRI Expense
Total Transport Demand GRI Expense (INPUT $ AMOUNT) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total GRI Expense
REGULATORY AMORTIZATION EXPENSE
Regulatory Commission Expense | Link D.T.
ACA Expense Amortization | Link D.T.
GSR / GSR R.A. / Rev. Auction 1 (Tracked) | Linked
Order 528 75% Expense | Linked
GRI - Transport Commodity (9302-701)
- Transport Demand
- Discount Adjustment |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- GRI Savings Adjustment |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FAS 106 Amortization | Link D.T.
2223 Dodge Street Buyout Amortization | Link D.T.
Severance & Relocation Amortization | Link D.T.
Uncollectible Accounts Amortization | Link D.T.
Fuel / UAF Amortization | Link D.T.
Equivalent Unit Risk Amortization (SLA) | Link D.T.
Misc. NNG Reg. Assets Item 1
Misc. NNG Reg. Assets Item 2
GSR Expense - Demand Tracker | Linked
- Commodity Tracker | Linked
GSR R.A. Expense Tracker | Linked
Order 528 Expense Tracker | Linked
IMP Amortization | Link D.T.
South Georgia (FAS 96) Adjustment | Link D.T.
GSR R.A. Writeoff (1/01), [NAME] (4/01)
Misc. Item 1 (Non Tracked)
Misc. Item 2 (Non Tracked)
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL REGULATORY AMORTIZATION
Spreadsheet: fa2ad396-5b37-4bdb-b039-70dd5ab255a7
Sheet: MULTIFAMILY  

 |  |  | CITY OF RIO RANCHO, NEW MEXICO
 |  |  | SEPTEMBER 2013 MULTI-FAMILY
APPLICATION TYPE | ADDRESS |  |  |  | LEGAL DESCRIPTION |  |  | PERMIT |  | STATUS | YMMDD | SQUARE FOOTAGE | VALUATION | # OF UNITS
 | Street Number | Street Name | Suffix | Quandrant | Unit | Block | Lot | Permit Year | Permit number
 |  |  | NONE | FOR | SEPTEMBER | 2013
Spreadsheet: mary_fischer__25611__32E-2001
Sheet: E15.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032E
COMPANY NAME    Enron Building Services, Invest Co
ANALYSIS OF MINORITY INTERESTS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  | E-15
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  | AMOUNT |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | ENRON'S |  | BALANCE |  | PER INCOME |  | OTHER |  |  |  | BALANCE
 |  | OWNERSHIP % |  | DR. (CR.) |  | STATEMENT |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Minority Interest | * |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0855  DR/(CR)
Spreadsheet: 765904d1643660973-find-words-with-letter-interchange-vowel-exchange-makinmomb-
Sheet: Sheet1

NOTAIRE |  | s | 1 | AEINORT
OTARINE |  |  | 2 | AEINORT
ETAERIO |  | s | 3 | AEEIORT
ANEROID |  | s | 4 | ADEINOR
AILERON | t | s | 5 | AEILNOR
ALERION |  | s | 6 | AEILNOR
ALIENOR |  | s | 7 | AEILNOR
ELATION | dgr | s | 8 | AEILNOT
TOENAIL |  | s | 9 | AEILNOT
ERASION |  | s | 10 | AEINORS
ATONIES |  |  | 11 | AEINOST
OARIEST | hr |  | 12 | AEIORST
OTARIES | [NAME] |  | 13 | AEIORST
ROASTIE |  | s | 14 | AEIORST | NEW IN CSW15
SKREIGH |  | s | 21463 | EGHIKRS
SKRIEGH |  | s | 21464 | EGHIKRS
[NAME]
TRAINEE
Spreadsheet: 95244d1294872782-formula-that-looks-at-the-text-and-month-and-then-adds-the-correct-numbers-excelhelp
Sheet: Sheet1

Employee | Amount | Date
Smith, [NAME] | 2231.32 | 2011-01-01 00:00:00
Doe, [NAME] | 156 | 2011-01-16 00:00:00
Smith, [NAME] | 658.32 | 2011-01-22 00:00:00
Doe, [NAME] | 123.34 | 2011-03-20 00:00:00
Doe, [NAME] | 6524 | 2011-08-06 00:00:00
Smith, [NAME] | 2365 | 2011-06-08 00:00:00
Smith, [NAME] | Amount
January, 2011
February, 2011
March, 2011