tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 470da40e-6262-4ed7-bf34-86a6b1b5b23a
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (14 Entries):
 | 6 Reagents, chemicals 6.1 Reagents/analyzers for chemistry
No. | Company | Country | City | [NAME] | Hall/Booth
1 | ANALYTIKA, spol. s.r.o. | Czech Republic | [NAME] 9-Vysocany | 190 00 | A2.345A
2 | [NAME] [NAME] und Laborbedarf | Germany | Karlsruhe | 76185 | B1.303/406
3 | Diagonal GmbH & Co. [NAME] | Germany | Münster | 48161 | B1.520
4 | Extrasynthese | France | [NAME] Cedex | 69730 | B2.222
5 | FEW Chemicals GmbH | Germany | Wolfen | 06766 | A3.506
6 | [NAME] | Germany | Duisburg | 47167 | B2.140/ Bench
7 | Livchem Logistic GmbH | Germany | Frankfurt | 65933 | A1.508B
8 | Merck Millipore | Germany | Darmstadt | 64293 | A1.408
9 | NACALAI TESQUE, INC. | Japan | Kyoto | 604-0855 | A1.438
10 | Panreac [NAME] | Spain | Castellar del Vallès | 08211 | B1.309
11 | Promens Packaging GmbH | Germany | Ettlingen | 76275 | B1.142
12 | Thermo Scientific | Germany | Dreieich | 63303 | B1.101/202
13 | Th. Geyer GmbH & Co. [NAME] | Germany | Renningen | 71272 | B1.430
14 | VWR International GmbH | Germany | Darmstadt | 64295 | B1.221/320
Spreadsheet: 824420d1680572896-comparing-two-lists-with-multiple-columns-s666-pq-ists-difference
Sheet: INDEX MATCH test

 | ee | ff | gg
a | 1 | 1.25 | 1.5
b | 2 |  | 2.5
c | 3 | 3.25 | 3.5
d | 4 | 4.25 | 4.5
d | gg
Spreadsheet: 176792d1346101644-calculation-vacation-accrual-time-vacation-1-modified-for-you-needs
Sheet: Sheet1

 |  |  |  |  |  | TODAYS DATE
EMP ID | EMP NAME | HIRE DATE | TOTAL DAYS WORKED DATE UP TO TODAYS DATE | TOTAL VACATION ACCRUED DAYS TILL TODAYS DATE | TOTAL VACATION TAKEN | AVAILABLE DAYS
100 | ANSARI | 2011-08-03 00:00:00 |  |  | 25.009 |  |  |  |  |  | ACCRUED DAYS
101 | SHARMA | 2011-08-06 00:00:00
102 | [NAME] | 2011-01-04 00:00:00
Spreadsheet: 38443d1236615305-excel-2007-having-problem-with-averageifs-formula-monthly-gas-reports-2009-ne
Sheet: 1-19 thru 1-25

 |  |  |  |  |  | System:
 |  |  | 2009-01-19 00:00:00 |  | Thru
 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Technician |  | 2009-01-19 00:00:00 |  |  |  |  |  |  | Total
1 |  |  |  |  |  |  | 65
2 |  |  |  |  |  | 57
3 |  |  |  | 52.91
4 |  |  |  |  | 39.86 |  | 35.21
5 |  |  |  |  |  |  | 31.58
6 |  |  |  | 36.77
7 |  |  | 37.6 |  |  |  | 34
8 |  |  |  | 37.08
9 |  |  |  |  |  | 36.93
10 |  |  |  |  |  |  |  | 32.48
11
12 |  |  |  | 34.72
13 |  |  |  | 39
14 |  |  |  |  | 35
15
16 |  |  | 27.5 |  | 33.11 |  |  | 30.06
17 |  |  |  | 34.86 |  |  |  | 34.65
18 |  |  |  | 33 |  | 27.69
19 |  |  |  | 35.75 |  |  | 32.86
20
21
22
23
24
25
 |  |  |  |  |  |  | Total:
Spreadsheet: 221079d1363362095-locking-data-together-big-excel-for-forum-help-updated
Sheet: Site Progress

 |  |  | 2013-03-08 00:00:00 | 2013-03-15 00:00:00 | 2013-03-22 00:00:00 | 2013-03-29 00:00:00 | 2013-04-05 00:00:00 | 2013-04-12 00:00:00 | 2013-04-19 00:00:00 | 2013-04-26 00:00:00 | 2013-05-03 00:00:00
 |  |  |  | % Complete | % Complete | % Complete | % Complete | % Complete | % Complete | % Complete | % Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65464654
Spreadsheet: 01b6b6b9-9856-4a97-bdfe-72e5c66eff0b
Sheet: Sheet1

Students from Denmark Studying Internationally | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Top 10 Hosts/Destinations 2010-2011
 | Top 10 Hosts/ Destinations | Total Number of Students Studying Internationally | Undergraduate   Students | (Post-)Graduate  Students
#1 | Great Britain | 1990 | 1200 | 491
#2 | United States | 967 | 176 | 120
#3 | Germany | 542
#4 | Sweden | 536 | 268 | 142
#5 | Australia | 396
#6 | Norway | 325 | 160 | 75
#7 | France | 321
#8 | Spain | 314
#9 | Canada | 250
#10 | Netherlands | 250
 | Total | 10529 | 2481 | 1193
These figures only include students studying for a full-degree outside of Denmark and students who are enrolled at one of the 8 Danish universities and particiate in an exchange visit abroad.
Source: Danish Agency for Universities and Internationalisation
Spreadsheet: 141768d1329432779-countif-or-other-option-copy-of-randombasicstrategychart
Sheet: 6D S17 RAND Gen

0.6481594697578774 | 2 |  | 0.4227898685853237 | 11 |  | 1 | Ace, Ace
0.9975495678521156 | 3 |  | 0.3556359605814026 | 22 |  | 2 | 2, 2
0.8198205488237158 | 6 |  | 0.9174772482906189 | 3 |  | 3 | 3, 3
0.1612705450096585 | 1 |  | 0.5959127283798474 | 20 |  | 4 | 4, 4
0.1837534637448518 | 7 |  | 0.2528730575099665 | 9 |  | 5 | 5, 5
0.8188354900529907 | 10 |  | 0.245703230874502 | 16 |  | 6 | 6, 6
0.6407364300595649 | 8 |  | 0.5306699278322505 | 19 |  | 7 | 7, 7
0.2443331141091802 | 9 |  | 0.2039825397987629 | 10 |  | 8 | 8, 8
0.2212060660016409 | 5 |  | 0.8009492328159513 | 24 |  | 9 | 9, 9
0.3552935681275414 | 4 |  | 0.7126816439565276 | 26 |  | 10 | 10, 10
 |  |  | 0.9715786677873948 | 14 |  | 11 | Ace, 2
 |  |  | 0.621555618914561 | 12 |  | 12 | Ace, 3
1 | A |  | 0.1887970720079259 | 4 |  | 13 | Ace, 4
2 | 2 |  | 0.7063751621256821 | 21 |  | 14 | Ace, 5
3 | 3 |  | 0.3057641283701124 | 28 |  | 15 | Ace, 6
4 | 4 |  | 0.7447156184493801 | 29 |  | 16 | Ace, 7
5 | 5 |  | 0.09890553299174665 | 7 |  | 17 | Ace, 8
6 | 6 |  | 0.3169363826461031 | 27 |  | 18 | Ace, 9
7 | 7 |  | 0.7389255316488387 | 1 |  | 19 | 5, 6, 7
8 | 8 |  | 0.8965000277770603 | 30 |  | 20 | 8
9 | 9 |  | 0.5813563422651292 | 2 |  | 21 | 9
10 | 10 |  | 0.9618305591192003 | 18 |  | 22 | 10
 |  |  | 0.3045715483468778 | 15 |  | 23 | 11
 |  |  | 0.7126780740886344 | 23 |  | 24 | 12
 |  |  | 0.1717219859181701 | 5 |  | 25 | 13
 |  |  | 0.7073600562048585 | 6 |  | 26 | 14
 |  |  | 0.5026481828958727 | 8 |  | 27 | 15
 |  |  | 0.5694309326612917 | 13 |  | 28 | 16
 |  |  | 0.5359797043405398 | 25 |  | 29 | 17
 |  |  | 0.3958118254679618 | 17 |  | 30 | 18-21
Spreadsheet: 831530d1685703543-formular-to-call-data-from-another-sheet-5-and-6-ask
Sheet: WASICHANA

MKOA WA MANYARA
HALMASHAURI Y WILAYA [NAME]
MATOKEO [NAME] WA MUHULA WA KWANZA MEI, 2023 DARASA LA VI WASICHANA
S/N | KATA | SHULE | JINA LA MTAHINIWA | JINSI      2. MS | MASOMO |  |  |  |  |  |  |  |  |  |  |  | JML | WASTANI | DARAJA | [NAME] | [NAME]
 |  |  |  |  | KISWAHILI |  | ENGLISH |  | HISABATI |  | SAYANSI NA TEKNOLOJIA |  | M/JAM |  | URAIA NA MAADILI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1 | KALOLENI | SHEKINA | [NAME] | 2 | 41 |  | 27 |  | 28 |  | 27 |  | 40 |  | 37 |  | 22
2 | KALOLENI | SHEKINA | GLADNESS P SHOSHO | 2 | 41 |  | 30 |  | 31 |  | 34 |  | 39 |  | 36 |  | 25
3 |  |  |  | 2
4 |  |  |  | 2
5 |  |  |  | 2
6 |  |  |  | 2
7 |  |  |  | 2
8 |  |  |  | 2
9 |  |  |  | 2
10 |  |  |  | 2
11 |  |  |  | 2
12 |  |  |  | 2
13 |  |  |  | 2
14 |  |  |  | 2
15 |  |  |  | 2
16 |  |  |  | 2
17 |  |  |  | 2
18 |  |  |  | 2
19 |  |  |  | 2
Spreadsheet: 41435d1239896577-array-formula-test7
Sheet: Wellness Results

 | ABC Company
1 | Globalfit - Product 3
2 | Get up and start walking
3 | Go to a Dance
4 | test wanted
5 | #N/A
6 | #N/A
7 | #N/A
8 | #N/A
9 | #N/A
10 | #N/A
11 | #N/A
12 | #N/A
13 | #N/A
14 | #N/A
15 | #N/A
Spreadsheet: 82486d1282568136-excel-2007-copy-top-10-from-worksheets-to-a-single-sheet-print-prep
Sheet: Counterbalance Stand-Up

Unit Type | Operator ID | Date / Time | Threshold | H Actual | V Actual | Unit No. | Department
[NAME]-Up | [NAME] | 2010-07-14 06:22:00 |  | 4 | 0 | B | Shipping
[NAME]-Up | [NAME] | 2010-07-16 16:41:00 |  | 3.79 | 0 | B | Shipping
 | [NAME] | 2010-07-14 06:22:00 |  | 4 | 0 | B | Shipping
 | [NAME] | 2010-07-16 16:41:00 |  | 3.79 | 0 | B | Shipping
Spreadsheet: 20b29c8b-4aec-4be6-9d11-55ad51f1b527
Sheet: Balance Sheet

Autodesk, Inc.
Condensed Consolidated Balance Sheets
(In millions)
 | April 30, | January 31, | October 31, | July 31, | April 30, | January 31, | October 31, | July 31, | April 30,
 | 2013 | 2013 | 2012 | 2012 | 2012 | 2012 | 2011 | 2011 | 2011
ASSETS:
Current assets:
Cash and cash equivalents | 1655.8 | 1612.2 | 827 | 930.2 | 1074.5 | 1156.9 | 1103.3 | 1131.5 | 1091.4
Marketable securities | 432.1 | 342.1 | 502.1 | 500.5 | 437.5 | 254.4 | 240.3 | 241.8 | 258.4
Accounts receivable, net | 285.8 | 495.1 | 293.3 | 361.4 | 300.6 | 395.1 | 259.2 | 297 | 271
Deferred income taxes | 56 | 42.2 | 48.4 | 44.8 | 38.7 | 30.1 | 34.2 | 35.3 | 39.1
Prepaid expenses and other current assets | 81.4 | 60.8 | 53.8 | 65.8 | 60.8 | 59.4 | 61.6 | 73.2 | 72.5
Total current assets |  | 2552.4 | 1724.6 | 1902.7 | 1912.1 | 1895.9 | 1698.6 | 1778.8 | 1732.4
Marketable securities | 392 | 411.1 | 408.3 | 286.1 | 284.1 | 192.8 | 190.6 | 179.2 | 175.9
Computer equipment, software, furniture and leasehold
improvements, net | 129 | 114.9 | 114.6 | 109 | 104 | 104.5 | 102.1 | 105.2 | 99.8
Purchased technologies, net | 69.2 | 76 | 75.9 | 71.4 | 74.8 | 84.6 | 90.4 | 69.4 | 62.8
Goodwill | 895.7 | 871.5 | 824.6 | 739.2 | 682.9 | 682.4 | 653.9 | 607.4 | 605.7
Deferred income taxes, net | 134.3 | 122.8 | 128.3 | 136.8 | 129.3 | 135.8 | 138.7 | 118.8 | 102.7
Other assets | 158.4 | 159.7 | 152.9 | 130.7 | 129.8 | 131.8 | 130.7 | 114.9 | 122.9
 |  | 4308.4 | 3429.2 | 3375.9 | 3317 | 3227.8 | 3005 | 2973.7 | 2902.2
LIABILITIES & STOCKHOLDERS' EQUITY:
Current liabilities:
Accounts payable | 86.1 | 94.2 | 75.9 | 82.9 | 88.9 | 89.3 | 81.9 | 89.8 | 101.7
Accrued compensation | 123.2 | 189.6 | 155.6 | 136.6 | 127.8 | 183.9 | 154.3 | 121.5 | 106
Accrued income taxes | 35.4 | 13.9 | 14.2 | 17 | 17.4 | 14.4 | 22.3 | 15.3 | 24.2
Deferred revenue | 663.7 | 647 | 558.1 | 590.9 | 584.7 | 582.3 | 499.9 | 525.3 | 518.9
Borrowings under line of credit | 0 | 0 | 110 | 0 | 0 | 0 | 0 | 0 | 0
Other accrued liabilities | 71.4 | 99 | 71.5 | 74 | 56.7 | 84.2 | 55.2 | 75.2 | 68.7
Total current liabilities |  | 1043.7 | 985.3 | 901.4 | 875.5 | 954.1 | 813.6 | 827.1 | 819.5
Deferred revenue | 187.7 | 187.6 | 155.6 | 161.1 | 142.2 | 136.9 | 120 | 117.1 | 103.5
Long term income taxes payable | 193.3 | 194.2 | 184.4 | 179 | 171.7 | 174.8 | 161.3 | 157.4 | 144
Long term notes payable, net of discount | 745.8 | 745.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other liabilities | 98.6 | 94.1 | 86 | 83.1 | 82.3 | 79.1 | 82.6 | 83 | 84
Stockholders' equity:
Common stock and additional paid-in capital | 1499.5 | 1449.8 | 1438.9 | 1457.3 | 1496.2 | 1365.4 | 1359.9 | 1356.5 | 1363.5
Accumulated other comprehensive (loss) income | -2 | -5.7 | -6.4 | 0.6 | 3.7 | 5.9 | 3.4 | 14.3 | 4.8
Retained earnings | 587 | 599.1 | 585.4 | 593.4 | 545.4 | 511.6 | 464.2 | 418.3 | 382.9
Total stockholders' equity |  | 2043.2 | 2017.9 | 2051.3 | 2045.3 | 1882.9 | 1827.5 | 1789.1 | 1751.2
 |  | 4308.4 | 3429.2 | 3375.9 | 3317 | 3227.8 | 3005 | 2973.7 | 2902.2
Note 1:  Totals may not agree with the components due to rounding.
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 8d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 5946 | 2237 | 10425 | 2323
OTHER* | 132 | 2046 | 60 | 1216
TOTAL | 6078 | 4283 | 10485 | 3539
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, FRA,  Inflation, OIS, and Swaption.
Spreadsheet: 200361d1355508360-how-to-find-value-in-another-table-and-return-value-from-same-row-tigeravatar-example-for-jpearson01
Sheet: Sheet1

Table 1 |  |  | Table 2
Items | Group ID |  | Group ID | Item1 | Item2 | Item3
apple | 214 |  | 214 | apple | pear | grape
pear | 214 |  | 33 | fig
grape | 214 |  | 7 | banana | guava
fig | 33 |  | 59 | peach | mango
banana | 7
guava | 7
peach | 59
mango | 59
Spreadsheet: 218022d1362304354-referencing-cells-from-a-master-sheet-master-schedule-test-nhopkins-oeldere-
Sheet: PrintWk1

 | Sunday |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday
 | Start | End | Hours | Start | End | Hours | Start | End | Hours | Start | End | Hours | Start | End | Hours | Start | End | Hours | Start | End | Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Hr/Week
 | Total Hr/Day
Spreadsheet: 825369d1681284118-formula-to-find-specific-data-using-multiple-drop-down-lists-book1-ans1
Sheet: Sheet1

Year: | FY23
Quarter: | All
Account: | All
Forecast: | In Forecast
First Date: | 2023-03-01 00:00:00
 |  |  | Qty | Q1 | Q2 | Q3 | Q4 | Total |  |  | Concatenate
 | Forecast Category
 | Won
 | In Forecast
 | Not In Forecast
Spreadsheet: 837827d1690454131-drop-down-chooses-defined-list-test-file-5-aligw
Sheet: Lookups

Ash AM |  | Ash AM |  | Ash PM
Ash PM |  | GP Anima AM |  | Duty (GP) A PM
Duty (GP) A PM |  | GP Routine AM |  | Duty (GP) B PM
Duty (GP) B PM |  | GP Triage AM (Salaried) A |  | Duty (GP) PM
Duty (GP) PM |  | GP Triage AM (Salaried) B |  | Duty (Salaried) A PM
Duty (Salaried) A PM |  | GP Triage AM A |  | Duty (Salaried) B PM
Duty (Salaried) B PM |  | GP Triage AM B |  | Duty (Salaried) PM
Duty (Salaried) PM |  | Minor Illness AM |  | GP Anima PM
GP Anima AM |  | Salaried GP Anima AM |  | GP Routine PM
GP Anima PM |  | Salaried GP Routine AM |  | Minor Illness PM
GP Routine AM |  |  |  | Salaried GP Anima PM
GP Routine PM |  |  |  | Salaried GP Routine PM
GP Triage AM (Salaried) A
GP Triage AM (Salaried) B
GP Triage AM A
GP Triage AM B
Minor Illness AM
Minor Illness PM
Salaried GP Anima AM
Salaried GP Anima PM
Salaried GP Routine AM
Salaried GP Routine PM
Spreadsheet: 150983d1334752079-drop-down-data-retrieval-core-1-
Sheet: Sheet1

CORE or Non-CORE
---
Non-Core
Non-Core
Non-Core
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
Non-Core
---
---
---
---
---
---
---
---
---
---
CORE
Non-Core
---
---
---
---
---
---
---
---
---
Non-Core
CORE
CORE
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
Total:
Core | 3
Non-Core | 6
--- | 82
Spreadsheet: 842937d1694926618-using-sumproduct-to-rank-by-group-need-to-break-tie-rank
Sheet: h_22SEP22

DATE | ID | pq | RANK
9/22/2022 | 2022-09-22RAS6 | 1.105541814
9/22/2022 | 2022-09-22RAS6 | 1.320816819
9/22/2022 | 2022-09-22RAS6 | 1.320816819 |  | <---- should be 3
9/22/2022 | 2022-09-22RAS6 | 1.389979305
9/22/2022 | 2022-09-22RAS6 | 1.454043606
9/22/2022 | 2022-09-22RAS6 | 1.529743825
9/22/2022 | 2022-09-22RAS6 | 1.60003801
9/22/2022 | 2022-09-22RAS6 | 1.664364518
9/22/2022 | 2022-09-22RAS6 | 1.676241628
9/22/2022 | 2022-09-22RAS6 | 1.851029466
9/22/2022 | 2022-09-22RAS6 | 1.913304948
9/22/2022 | 2022-09-22RAS6 | 2.262634276
9/22/2022 | 2022-09-22RAS7 | 0.867735254
9/22/2022 | 2022-09-22RAS7 | 1.320816819
9/22/2022 | 2022-09-22RAS7 | 1.412181546
9/22/2022 | 2022-09-22RAS7 | 1.454043606
9/22/2022 | 2022-09-22RAS7 | 1.454043606 |  | <---- should be 5
9/22/2022 | 2022-09-22RAS7 | 1.565383486
9/22/2022 | 2022-09-22RAS7 | 1.617393528
9/22/2022 | 2022-09-22RAS7 | 1.676241628
9/22/2022 | 2022-09-22RAS7 | 1.781893894
9/22/2022 | 2022-09-22RAS7 | 1.793072091
9/22/2022 | 2022-09-22RAS7 | 1.945533859
Spreadsheet: 3ff733ed-0dc6-405e-9128-9c7c0c31f357
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-02-07 09:45:57.190000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.25 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.125 | 101.805 | 101.68 | 101.555 | 101.18
4 | 101.358 | 101.233 | 101.108 | 100.733 |  | Note: | Refer To Price [NAME]
3.875 | 100.536 | 100.411 | 100.286 | 99.911 |  |  | For all Price Adjs
3.75 | 99.558 | 99.433 | 99.308 | 98.683
3.625 | 99.105 | 98.98 | 98.855 | 98.23
3.5 | 98.6 | 98.475 | 98.35 | 97.725
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.625 | 101.933 | 101.808 | 101.683 | 101.308
3.5 | 101.593 | 101.468 | 101.343 | 100.968
3.375 | 101.062 | 100.937 | 100.812 | 100.437
3.25 | 100.431 | 100.306 | 100.181 | 99.806
3.125 | 99.665 | 99.54 | 99.415 | 98.79
3 | 99.322 | 99.197 | 99.072 | 98.447
2.875 | 98.763 | 98.638 | 98.513 | 97.888 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-02-21 09:45:57.190000
30 DAY | 2012-03-07 09:45:57.190000
45 DAY | 2012-03-22 09:45:57.190000
60 DAY | 2012-04-06 09:45:57.190000
90 DAY | 2012-05-06 09:45:57.190000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 828626d1683644855-while-using-xlookup-the-first-2-lines-work-than-it-stops-testboox-aligw
Sheet: solarIn

Datum | value (kWh)
2022-01-01 01:00:00 | 0
2022-01-01 02:00:00 | 0
2022-01-01 03:00:00 | 0
2022-01-01 04:00:00 | 0
2022-01-01 05:00:00 | 0
2022-01-01 06:00:00 | 0
2022-01-01 07:00:00 | 0
2022-01-01 08:00:00 | 0
2022-01-01 09:00:00 | 0
2022-01-01 10:00:00 | 0.087932884
2022-01-01 11:00:00 | 0.232685166
2022-01-01 12:00:00 | 0.404156988
2022-01-01 13:00:00 | 0.695984986
2022-01-01 14:00:00 | 0.408590079
2022-01-01 15:00:00 | 0.456782036
2022-01-01 16:00:00 | 0.0644530929999999
2022-01-01 17:00:00 | 0.001953125
2022-01-01 18:00:00 | 0
2022-01-01 19:00:00 | 0
2022-01-01 20:00:00 | 0
2022-01-01 21:00:00 | 0
2022-01-01 22:00:00 | 0
2022-01-01 23:00:00 | 0
2022-01-02 00:00:00 | 0
2022-01-02 01:00:00 | 0
2022-01-02 02:00:00 | 0
2022-01-02 03:00:00 | 0
2022-01-02 04:00:00 | 0
Spreadsheet: 870680d1717149874-summarise-multiple-tables-into-master-table-summary-formula-request
Sheet: Summary Per Year Per Item

Year | Stamp | FX | Comm
2017 |  |  |  |  | Stamp
2018 |  |  |  |  | FX
2019 |  |  |  |  | Comm
2020 |  |  |  |  |  | Yellow highlight to show where I have grabbed the formulatext
2021
2022 |  |  |  |  | Imagine this for a collection of 200 plus (and growing) tables. The formula involved would become massive, would be very error prone, and become very difficult to manage in a dynamic way. What I would ike to do is have a dynamic formula (or method) that would pick up all the the stamp duty totals from all of the tables and return it to the summary sheet.
2023
2024
2025
2026
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Measured | Scheduled | Measured | Scheduled
1 |  |  |  | 10422 |  | -13751 | -15946
2 |  |  | 1216 | 17926 |  | -6539 | -22233 | 69
3 |  |  |  | 24926 |  | -17881 | -14137
4 |  |  | 1922 | -2574 |  |  | -30024
5 |  |  | -435 | -17837 |  |  | -6181
6 |  |  | -14269 | -12837 |  | -380
7 |  |  | -16674 | -12837 |  |  | -22790
8
9
10 |  |  |  |  |  |  | -97
11 |  |  |  |  |  | -78 | -8984
12 |  |  |  |  |  | -7076
13 |  |  |  |  |  | -3692 | -18024
14 |  |  |  |  |  | -13222 | -4227
15 |  |  |  |  |  |  | -43 | 6745
16 |  |  |  |  |  |  |  | 3603
17 |  |  |  |  |  |  | -511 | 458
18
19 |  |  |  |  |  | -22203
20 |  |  |  |  |  | -844
21
22
23
24
25
26 |  |  |  |  |  |  | -16792
27 |  |  |  |  |  |  | -51
28 |  |  |  |  |  |  |  | 23096
29 |  |  |  |  |  |  |  | 3702
30
31
index
2001-09-30 00:00:00 |  |  |  |  | 483326.7
2001-10-06 00:00:00
CBS Volume
 |  |  | 36377
Spreadsheet: 137113d1326966048-conditional-formatting-not-working-after-adding-new-formulas-within-the-worksheet-example34
Sheet: JAN 1

Code/Key
F
H
T
S
C
Number
 |  | [NAME] By | ALL "F" Taken | All "S" Taken | All "T" Taken | All "c" Taken | 2012-01-30 00:00:00
 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  | Days |  |  |  |  | C | S | F | F | F | F |  |  |  |  | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
 |  | Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | F | F | F |  |  | H
 |  | Days |  |  |  |  | C |  |  |  |  |  |  |  | C |  | T |  | T |  |  |  |  |  |  |  |  |  |  |  |  | H
 |  | Days |  |  |  |  |  |  |  | F | F | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
 |  | Days |  |  |  |  |  |  |  | F |  | F |  |  |  |  |  |  |  |  |  |  |  |  | H
 |  | Days |  |  |  |  |  |  |  |  | F | F |  |  |  | F |  |  |  |  |  | F |  |  |  |  | F |  | F |  |  |  |  | F
 |  | Days |  |  |  |  |  | S
0
0
Spreadsheet: 704063d1605333908-in-a-summary-sheet-different-ways-sum-up-all-values-as-per-criteria-from-multiple-sheets-sum-up-all-amounts-as-per-different-criterias
Sheet: Summary

Criteria1 | Criteria2 | Sum |  | Criteria1 | Criteria2 | Criteria3 | Sum |  | Criteria1 | Sum
Date | Name | Amount |  | from Month | to Month | Name | Amount |  | Name | Amount
2020-01-01 00:00:00 | ASD |  |  | Jan-2020 | Mar-2020 | ASD |  |  | ASD
2020-01-02 00:00:00 | BCD |  |  | Jan-2020 | June-2020 | BCD |  |  | BCD
2020-02-04 00:00:00 | ASD |  |  | Apr-2020 | June-2020 | ASD |  |  | ABV
2020-03-04 00:00:00 | ABV |  |  | Jan-2020 | Mar-2020 | ABV |  |  | ABC
2020-04-01 00:00:00 | ABC |  |  | Jan-2020 | June-2020 | ABC |  |  | FGH
2020-05-05 00:00:00 | ABV |  |  | Apr-2020 | June-2020 | ABV
2020-06-06 00:00:00 | FGH |  |  | Jan-2020 | June-2020 | FGH
Spreadsheet: 875391d1721971539-highlight-cells-relating-to-data-input-book2
Sheet: book2

 | Name: | Por2gal
MONDAY | DATE: | 2024-07-22 00:00:00 |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  | Leave this Column Blank
 | number | SIGN ON |  | SIGN OFF |  | ALLOCATION
 |  |  | AM |  | AM |  |  | AM |  | AM
 | 1 |  | PM |  | PM |  |  | PM |  | PM
TUESDAY | DATE:
 |  |  |  |  |  |  |  |  |  |  |  | Leave this Column Blank
 | number | SIGN ON |  | SIGN OFF |  | ALLOCATION
 | 2 |  | AM |  | AM |  |  | AM |  | AM
 |  |  | PM |  | PM |  |  | PM |  | PM
WEDNESDAY | DATE:
 |  |  |  |  |  |  |  |  |  |  |  | Leave this Column Blank
 | number | SIGN ON |  | SIGN OFF |  | ALLOCATION
 |  |  | AM |  | AM |  |  | AM |  | AM
 | 3 |  | PM |  | PM |  |  | PM |  | PM
THURSDAY | DATE:
 |  |  |  |  |  |  |  |  |  |  |  | Leave this Column Blank
 | number | SIGN ON |  | SIGN OFF |  | ALLOCATION
 |  |  | AM |  | AM |  |  | AM |  | AM
 | 4 |  | PM |  | PM |  |  | PM |  | PM
FRIDAY | DATE:
 |  |  |  |  |  |  |  |  |  |  |  | Leave this Column Blank
 | number | SIGN ON |  | SIGN OFF |  | ALLOCATION
 | 5 |  | AM |  | AM
 | 6 |  | PM |  | PM
at this point I have set the conditional formatting to show the rows to relate to any data placed in column B. but I only want to show AM or PM
 |  |  | AM |  |  | PM
 |  | 1 |  |  |  | 14:45:00 | 16:15:00
 |  | 2 | 07:15:00 | 08:50:00 |  | 14:45:00 | 16:45:00 | the whole row fills with colour however, I just want the AM column D37 & D38 to show from the data in B13
 |  | 3 | 07:00:00 | 08:50:00 |  | 14:30:00 | 16:15:00 | I would like only G38 & G39 to be highlighted to correspond with the data from [NAME]
 |  | 4 | 06:30:00 | 09:00:00 |  | 14:00:00 | 17:00:00 | likewise with row 39 to correspond with data pu in from B26 to be highlighted.
 |  | 5 | 07:00:00 | 08:50:00 |  | 14:00:00 | 17:00:00
 |  | 6 | 07:15:00 | 09:15:00 |  | 14:30:00 | 17:00:00