tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 787371d1657750447-conditioning-formatting-to-match-in-rows-stock-short-term-comparison-19-lar9149-
Sheet: Sheet1

 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 1 | 1 | 2 | 2 | 4 | 4 | 2
all | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 1 | 2 | 2 | 4 | 4 | 5 | 6 | 4
[NAME]) | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 1 | 2 | 2 | 4 | 4 | 7 | 6 | 6
all(s/fexp) | 2 | 0 | 4 | 0 | 1 | 5 | 3 | 3 | 4 | 4 | 5 | 7 | 9 | 9 | 10
all(s/fexp) | 3 | 0 | 5 | 1 | 1 | 6 | 3 | 4 | 4 | 5 | 8 | 9 | 12 | 15 | 15
all(s/fexp) | 4 | 0 | 6 | 1 | 2 | 7 | 4 | 6 | 4 | 7 | 11 | 14 | 18 | 22 | 22
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 2 | 3 | 8 | 7 | 9 | 9 | 13
all | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 2 | 3 | 8 | 7 | 9 | 10 | 13
[NAME]) | 0 | 1 | 0 | 0 | 2 | 1 | 2 | 2 | 3 | 3 | 10 | 9 | 10 | 11 | 15
all(s/fexp) | 0 | 1 | 0 | 0 | 2 | 1 | 2 | 2 | 4 | 4 | 10 | 9 | 10 | 12 | 15
all(s/fexp) | 0 | 1 | 0 | 0 | 2 | 1 | 2 | 2 | 4 | 4 | 10 | 9 | 10 | 12 | 16
all(s/fexp)
Spreadsheet: 103077d1300904448-countif-given-numerous-conditions-or-use-macro-attendanceandsafetymonitor1
Sheet: Individual

First name | John23
Last name | Smith
 |  | Days taken
P | Present
WE | Weekend
WH | Works Holiday
H | Holiday
A | Absent
L | Lost time
F | First Aid
N | Near miss
TC | Training Course
Spreadsheet: b918f827-d76f-423c-a28f-b6a82be48753
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Cox | Jake |  | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | [NAME] | Justin | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | McNair | [NAME] | [EMAIL] | [PHONE] | [PHONE] | [NAME] |  | Elizabeth City | NC | 27909
Fayetteville State University | Jones | [NAME] | [NAME] | [PHONE] |  | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | [NAME] | Allahquan | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | McCrimmon | [NAME] | [EMAIL] | [PHONE] |  | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Walsh | [NAME] | [EMAIL] | [PHONE] |  |  |  | Raleigh | NC | 27695
UNC Asheville | Judge | [NAME] | [EMAIL] | [PHONE] |  | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Leimenstoll | Will | [EMAIL] | [PHONE] |  |  |  | Chapel Hill | NC | 27599
UNC Charlotte | Dugan | Conor | [EMAIL] | [PHONE] |  | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | Boccardo | Chelsea | [EMAIL] | [PHONE] |  | Student Government Association | 226 Elliott University Center, 221 EUC, [NAME],                              P.O. Box 26170 | Greensboro | NC | 27402
UNC Pembroke | Nunnery | [NAME] | [EMAIL] | [PHONE] |  | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | [NAME] | [NAME] | [NAME] | [PHONE] |  | 601 S. College Road |  | [NAME] | NC | 28403
UNC School of the Arts | [NAME] | [NAME] | [EMAIL] |  |  | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University | Page | Aleica | [EMAIL] | [PHONE] |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | Butler | [NAME] | [EMAIL] | [PHONE] |  | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics | [NAME] | [NAME] | [EMAIL] |  |  | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 684932d1593619808-how-to-pick-up-correct-data-in-multiple-rows-and-columns-in-a-table-how-to-pick-up-correct-data-in-multiple-rows-and-columns-in-a-table-pq
Sheet: Sheet1 (2)

 | Table 1 - Data |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 2 - Selling Price Summary
 | Item | 1
 |  | Product A |  |  |  | Product B |  |  |  | Product C |  |  |  |  |  |  | Our selling price over different sales channels
 | Sales to | [NAME] |  | MT |  | MT |  | FR |  | OT |  | FS |  |  | Item | Product Name | [NAME] | FR | FS | GT | MT | OT
 | Our Cost Price |  | 15 |  |  |  | 20 |  |  |  | 38 |  |  |  | 1 |  |  |  |  |  |  |  |  | Product Name | [NAME] | FR | FS | GT | MT | OT
 | Desired Margin |  |  | 0.11 |  |  |  | 0.15 |  | 0.2 |  | 0.18 |  |  | 2 |  |  |  |  |  |  |  |  | Product A | 16.6667 |  | 17.2414 | 17.0455 | 16.8539
 | Our Selling Price |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | Product B |  | 23.5294 |  |  | 22.2222 | 22.7273
 | Sales to | GT |  | FS |  | OT |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  | Product C |  |  | 46.3415 |  |  | 47.5
 | Our Cost Price |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | Desired Margin | 0.12 |  | 0.13 |  | 0.12 |  |  |  |  |  |  |  |  | 6
 | Our Selling Price
Spreadsheet: 199745d1355316604-formula-required-for-summary-attendance-2012
Sheet: Jan 2012

Sr. | CodeNo | NAME | 2012-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-31 00:00:00 |  | Leave Adjustment | Days | Present | Absent | [NAME] | Annual Leave | Half Day | Net Present
1 | E001 | Employee1 | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | SL | SL | P | P | P | P | P | P | P | P | P |  |  | 31
2 | E002 | Employee2 | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P |  |  | 31
3 | E003 | Employee3 | P | P | P | P | P | P | P | SL | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P |  |  | 31
4 | E004 | Employee4 | P | P | P | P | P | P | AL | AL | AL | AL | AL | AL | AL | AL | AL | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P |  |  | 31
5 | E005 | Employee5 | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | HD | P | SL | P | P | P | P | P | P | P | P | P | P | P | SL |  |  | 31
6 | E006 | Employee6 | P | P | P | P | P | P | P | P | P | P | P | P | P | P | SL | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P |  |  | 31
7 | E007 | Employee7 | P | P | P | P | P | P | P | P | P | P | P | P | P | SL | P | P | P | P | P | P | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL |  |  | 31
8 | E008 | Employee8 | AL | AL | AL | AL | AL | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P |  |  | 31
9 | E009 | Employee9 | P | P | P | P | P | P | P | P | P | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL | AL |  |  | 31
Spreadsheet: 0349e30c-f271-4f59-b87c-24ed42763be7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 49. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (ACT), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413727L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413728R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413729T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413730A | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413731C | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413732F | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413733J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413734K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413735L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413736R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 764244d1642658934-help-needed-with-splitting-data-into-separate-columns-example
Sheet: Sheet2

TEAM | CLUB | PRESIDENT | COACH
test team 7 | test club | [NAME] | seven
PLAYER # | NAME | DATE OF BIRTH | MOBILE | SIGNATURE
1
2
3
4
5
6
7
8
9
10
11
12
Spreadsheet: 804391d1668037293-formula-for-printing-all-sheets-xcvbtr10
Sheet: 10

 |  | [NAME])  YA MSHIRIKA T.A.G HERMON REVIVAL CHURCH |  |  |  |  |  |  |  |  | MWAKA
 |  | JINA KAMILI | WEEKS | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGU | SEPT | OKT | NOV | DEC | JUMLA
 |  | ht6 | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | JUMLA
Spreadsheet: 10100372-619b-4bc7-8379-41f4b52ca6b3
Sheet: FORMA 4 

ფორმა [NAME]
კაპიტალში ცვლილებების შესახებ ანგარიში
N | დასახელება |  | (საანგარიშო წელი)
 |  | ბიუჯეტით | საკუთარი სახსრებით | სულ
010 | ნაშთი წლის დასაწყისისათვის
020 | ფლობით მიღებული მოგება/ზარალი
030 | კურსთაშორის სხვაობით
040 | [NAME]
050 | გადაფასებით
060 | [NAME]
070 | ბიუჯეტის წინაშე ვალდებულებებით
080 | მ.შ შემოსავლების საკასო შესრულებით
090 | ბიუჯეტის წინაშე დარიცხული ვალდებულებებით
100 | საანგარიშგებო პერიოდის ფინანსური შედეგი
110 | ნაშთი წლის ბოლოს
Spreadsheet: 824580d1680693073-how-to-move-cells-by-formula-planned
Sheet: Sheet1

היתכנות | (All) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | planned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26-Feb | 23-Mar | 29-Mar | 2-Apr | 17-Apr | 20-Apr | 26-Apr | 10-May | 15-May | 20-May | 25-May | 30-May | 1-Jun | 15-Jun | 30-Jun
Sum of מספור עיר |  | תאריך חזוי
מספור עיר | עיר | 26-Feb | 23-Mar | 29-Mar | 2-Apr | 17-Apr | 20-Apr | 26-Apr | 10-May | 15-May | 20-May | 25-May | 30-May | 1-Jun | 15-Jun | 30-Jun
1 | חדרה | 1
2 | אשדוד |  | 2
3 | קריות |  |  | 3
4 | מעלה אדומים |  |  |  | 4
5 | ביתר עלית |  |  |  | 5
6 | אריאל |  |  |  | 6
7 | עפולה |  |  |  |  |  |  | 7
8 | כרמיאל |  |  |  |  | 8
9 | טבריה |  |  |  |  | 9
10 | קצרין |  |  |  |  |  |  |  |  | 10
11 | קרית שמונה |  |  |  |  | 11
12 | נוף הגליל |  |  |  |  | 12
13 | צפת |  |  |  |  |  |  |  |  |  |  | 13
14 | מצפה רמון |  |  |  |  |  |  |  |  |  | 14
15 | דימונה |  |  |  |  |  |  |  |  |  | 15
16 | קרית גת |  |  |  |  |  |  |  | 16
17 | רמלוד |  |  |  |  |  |  |  |  |  | 17
18 | בנימינה זכרון ופורדיס |  |  |  |  |  |  |  | 18
19 | טירת [NAME] כרמל |  |  |  |  |  |  |  |  |  | 19
20 | [NAME] [NAME] |  |  |  |  |  |  |  |  |  | 20
21 | בקעת אונו |  |  |  |  |  |  |  |  |  | 21
22 | [NAME] |  |  |  |  |  | 22
23 | בית שאן |  |  |  |  |  |  |  |  |  | 23
24 | אור עקיבא |  |  |  |  |  |  |  | 24
25 | מעלות תרשיחא |  |  |  |  |  |  |  | 25
26 | טמרה |  |  |  |  |  |  |  | 26
27 | פרדס חנה-כרכור + חריש |  |  |  |  |  |  |  | 27
28 | סחנין ועראבה |  |  |  |  |  |  |  |  | 28
29 | ראש פינה וחצור |  |  |  |  |  |  |  |  | 29
30 | רחובות והסביבה |  |  |  |  |  |  |  |  |  |  |  | 30
31 | האב רהב |  |  |  |  |  |  |  |  |  |  |  | 31
32 | נתניה |  |  |  |  |  |  |  |  |  |  |  | 32
33 | ירושלים |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
34 | פתח תקווה |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
35 | ראש העין + אלעד |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
36 | מודיעין |  |  |  |  |  |  |  |  |  |  |  |  | 36
37 | קריית מלאכי |  |  |  |  |  |  |  |  |  |  |  | 37
38 | כפר סבא |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
39 | כפר קאסם |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
40 | שדרות |  |  |  |  |  |  |  |  |  |  |  | 40
41 | [NAME] |  |  |  |  |  |  |  |  |  | 41
42 | רהט |  |  |  |  |  |  |  |  |  | 42
43 | חבר |  |  |  |  |  |  |  |  |  |  |  |  | 43
44 | מתחם ת"א |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
45 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
46 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
47 | בית שמש |  |  |  |  |  |  |  |  |  |  |  |  |  | 47
48 | [NAME] גרביה |  |  |  |  |  |  |  |  |  |  |  | 48
49 | עומר |  |  |  |  |  |  |  |  |  | 49
50 | רמת גן |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
51 | גבעתיים |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51
52 | ערד |  |  |  |  |  |  |  |  |  | 52
53 | [NAME] |  |  |  |  |  |  |  |  |  | 53
54 | רעננה |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54
55 | הוד השרון |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55
56 | האב טייבה |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56
Spreadsheet: d54d441a-718a-4958-aa5a-f9ec1a7a9ddd
Sheet: Balance Sheet & Cash Flow Info.

MATTEL, INC. AND SUBSIDIARIES
CONDENSED CONSOLIDATED BALANCE SHEETS
 |  |  |  |  |  |  | 2 0 1 1 |  | 2 0 1 2
(In millions) |  |  |  |  |  |  | At 3/31 |  | At 3/31
Assets
Cash and equivalents |  |  |  |  |  | $ | 1049.4 | $ | 784.6
Accounts receivable, net |  |  |  |  |  |  | 758.6 |  | 743.6
Inventories |  |  |  |  |  |  | 607.2 |  | 603.7
Prepaid expenses and other current assets |  |  |  |  |  |  | 336.5 |  | 372.1
Total current assets |  |  |  |  |  |  | 2751.7 |  | 2504
Property, plant and equipment, net |  |  |  |  |  |  | 494.1 |  | 535.7
Other noncurrent assets |  |  |  |  |  |  | 1736.3 |  | 2500.7
Total Assets |  |  |  |  |  | $ | 4982.1 | $ | 5540.4
Liabilities and Stockholders' Equity
Current portion of long-term debt |  |  |  |  |  | $ | 250 | $ | 400
Accounts payable and accrued liabilities |  |  |  |  |  |  | 771.6 |  | 722.4
Income taxes payable |  |  |  |  |  |  | 18.6 |  | 10.8
Total current liabilities |  |  |  |  |  |  | 1040.2 |  | 1133.2
Long-term debt |  |  |  |  |  |  | 950 |  | 1150
Other noncurrent liabilities |  |  |  |  |  |  | 474.5 |  | 616.1
Stockholders' equity |  |  |  |  |  |  | 2517.4 |  | 2641.1
Total Liabilities and Stockholders' Equity |  |  |  |  |  | $ | 4982.1 | $ | 5540.4
SUPPLEMENTAL BALANCE SHEET AND CASH FLOW DATA ([NAME])
 |  |  |  |  |  |  | 2 0 1 1 |  | 2 0 1 2
(In millions, except days and percentage information) |  |  |  |  |  |  | At 3/31 |  | At 3/31
Key Balance Sheet Data:
Accounts Receivable, Net Days of Sales Outstanding (DSO) |  |  |  |  |  |  | 72 |  | 72
Total Debt Outstanding |  |  |  |  |  | $ | 1200 | $ | 1550
Total Debt-to-Total-Capital Ratio |  |  |  |  |  |  | 0.323 |  | 0.37
 |  |  |  |  |  |  | 2 0 1 1 |  | 2 0 1 2
 |  |  |  |  |  |  | 3 Months |  | 3 Months
(In millions) |  |  |  |  |  |  | 3/31 |  | 3/31
Condensed Cash Flow Data:
Cash Flows (Used For) From Operating Activities |  |  |  |  |  | $ | -42 | $ | 172
Cash Flows (Used For) Investing Activities |  |  |  |  |  |  | -9 |  | -703
Cash Flows (Used For) Financing Activities and Other |  |  |  |  |  |  | -181 |  | -53
Decrease in Cash and Equivalents |  |  |  |  |  | $ | -232 | $ | -584
The financial information included herein should be read in conjunction with Mattel's consolidated financial statements and related notes in its Annual Reports on Form 10-K and/or Quarterly Reports on Form 10-Q, as applicable.
Spreadsheet: sara_shackleton__36409__SITA
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | SITA France | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State | France | S&P Rating | n/a
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING) | Societe Industrielle de Transports Automobiles | Enron Corp
LIMIT $ MILLIONS | 7.5 | 12.5
Incorporation State | France | OR
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings
 | 5 | 10
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change |  | X
-Below = S&P/Moody's |  | BBB-
Financial Covenants | X
-Funded Debt to Worth | 2.5 to 1
-Minimum Net Worth
-EBITDA/Interest Expense | 4X
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME])
-Guarantor ($[NAME]) | 75MM Euro | 100
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS: | Revised credit for new draft.
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | X3-3263
Spreadsheet: 220797d1363268767-sumproduct-to-extract-quarterly-data-started-but-not-working-quarterly-sumif-help
Sheet: Sheet1

2012-10-31 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00
0 | 0 | 0 | 0 | 0 | 0 | 390000 | 573600 | 764544 | 963125.76 | 1169650.7904 | 1384436.822016 | 1607814.29489664 | 1840126.866692506 | 2081131.941360206 | 2164977.219014614 | 2251576.307775199 | 2341639.360086207 | 2435304.934489655 | 2532717.131869242 | 2634025.817144011 | 2739386.849829772 | 2848962.323822964 | 2962920.816775882 | 3081437.649446917 | 3204695.155424794 | 3332882.961641786 | 3466198.280107458 | 3604846.211311756 | 3749040.059764226 | 3899001.662154795 | 4054961.728640987 | 4217160.197786626 | 4385846.605698092 | 4561280.469926016 | 4743731.688723057 | 4933480.956271979 | 5130820.194522859 | 5336053.002303773 | 5549495.122395924 | 5771474.92729176 | 6002333.924383431 | 6242427.281358768 | 6492124.372613119 | 6751809.347517645 | 7021881.721418351 | 7302756.990275086 | 7594867.269886089 | 7898661.960681533 | 8214608.439108795 | 8543192.776673147 | 8884920.487740073 | 9240317.307249676 | 9609929.999539664 | 9994327.19952125 | 10394100.2875021 | 10809864.29900219 | 11242258.87096227 | 11691949.22580076 | 12159627.1948328 | 12646012.28262611 | 13151852.77393115 | 13677926.8848884
 |  |  |  |  | 2013 |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4
Spreadsheet: 56578d1256747667-dynamic-range-for-pivot-table-dynamicrange
Sheet: Sheet2

Product | Year | Quantity
A | 2000 | 14
B | 2004 | 18
C | 2001 | 17
D | 2000 | 12
A | 2000 | 35
B | 2002 | 62
C | 2005 | 15
D | 2004 | 41
A | 2006 | 23
A | 2001 | 2
C | 2001 | 34
B | 2005 | 89
D | 2007 | 16
Spreadsheet: 691792d1597877704-average-of-calculations-on-every-row-in-a-table-my-results
Sheet: Sheet1

Date | [NAME] | Buy-In | Entrants | # Cash | Result | Return
2020-08-18 00:00:00 | Bovada daily 6pm PLO8 | 33 | 75 | 39 | 39 | 52.48
2020-08-16 00:00:00 | Bovada 9-handed turbo | 54.5 | 9 | 3 | 2 | 135 |  | Total In:
2020-08-15 00:00:00 | Bovada daily 6pm PLO8 | 33 | 90 | 49 | 61 | 0 |  | Total Out:
2020-08-13 00:00:00 | Bovada daily 6pm PLO8 | 33 | 75 | 39 | 45 | 0 |  | Net Profit:
2020-08-11 00:00:00 | Bovada 9-handed turbo | 54.5 | 9 | 3 | 1 | 225 |  | [NAME]:
2020-08-07 00:00:00 | Nuts home game | 60 | 6 | 2 | 1 | 322 |  | Average Finish:
2020-07-18 00:00:00 | Bovada 9-handed turbo | 54.5 | 9 | 3 | 1 | 225
2020-07-16 00:00:00 | Bovada 9-handed turbo | 54.5 | 9 | 3 | 1 | 225
2020-07-12 00:00:00 | Bovada PLO8 big tourney | 11 | 75 | 39 | 1 | 310
 |  |  |  |  | 4 | 1
 |  |  |  |  | 5 | 2
Spreadsheet: 161405d1339513319-how-to-consolidate-or-compress-this-equation-jack-lewis-new-schedule-revised-modified-by-tigeravatar-
Sheet: Schedule

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Paid
Employee | 2012-05-12 00:00:00 | 2012-05-13 00:00:00 | 2012-05-14 00:00:00 | 2012-05-15 00:00:00 | 2012-05-16 00:00:00 | 2012-05-17 00:00:00 | 2012-05-18 00:00:00 | Hours | Notes For The Week
[NAME] |  | 9 to 7 | 9 to 6 | 11 to 7 | 12 to 5 | Off | 9 to 5 | 40
Sallie
Scott
[NAME]
[NAME]
Gayle
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Sue
Open |  |  |  |  |  |  |  | 40 | Total Hours
Close
Special
Events
Spreadsheet: 575456d1527514301-help-with-formulas-to-perform-indexation-to-rental-income-on-annual-semi-annual-etc-dummy-file-1-ans1
Sheet: Income Calc

 | Helper column
 |  | Tenant 1 | 1
 |  | [NAME] | 1
 |  | Tenant 3 | 1
 |  |  | I want to add formulas here with the below outcome. The idea is to add a formula which takes into account number of years in tab "Rent Roll". I.e if [NAME] is 1 year then tenant 1 here have indexation every year - see correct end result below under tenant 1. Same for tenant 2 and so on, if tenant 2 has "2 year in D4 on tab "rent roll" the indexation will take place every second year. Indexation is supposed to happen in 1st quarter when the rent is subject to indexation
 | NOTE: Column D is changed
 |  | What I like to achieve by adding a dynamic formula
 |  |  | Tenant 1 | 1.01 | 1.01 | 1.01 | 1.01 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.136444526 | 1.136444526 | 1.136444526 | 1.136444526
 |  |  | [NAME] | 1 | 1 | 1 | 1 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812
 |  |  | Tenant 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106
Spreadsheet: daren_farmer__5499__Book2
Sheet: Map

 |  |  |  |  |  | [NAME] starting balance =
 |  |  | CIG/DOW Balance
 |  | DT SCH
 |  | DT VOL
Flow Date: |  | DT BAL
Reported at:
 |  |  |  |  |  |  | [NAME] | [NAME] | CIG Act | CIG Sch | HPL Act | [NAME]
 |  |  |  |  |  | Received
 |  |  |  |  |  | Delivered
 |  |  |  |  |  | Balance
 |  |  |  |  |  |  |  | (*Calculated Line Pack Change)
 |  |  |  |  |  | Net UAF
 |  |  |  |  |  | Current Line Pack
MBBAL
ActMB
[NAME]
SchTGPAD
ActTGPAD
SchHoeSt
ActHoeSt
schHPLAD
actHPLAD
schHPLGreg
actHPLGreg
schSeahawk
actSeahawk
schcedar
actcedar
schTGPSAB
actTGPSAB
schSCTTL
actSCTTL