tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 72613d1273307842-match-data-dummya
Sheet: Sheet1

Company |  | 2.72 |  |  |  |  |  | Murphys | Whiskey house | topples | spinning wheel | the edge | Coalmans | Flannerys | The pit | Beer house | stewarts |  |  |  |  |  |  |  |  | pubs
Whiskey house |  | 1.87 |  |  |  |  |  | 1.4 | 2.45 | 2.41 | 1.3 | 6.63 | 1.59 | 1.01 | 2.09 | 3.05 | 2.95 |  |  |  |  |  |  |  |  | Murphys
topples |  | 3.1 |  |  |  |  |  | 0.86 | 4.8 | 1.87 | 0.88 | 2.43 | 0.84 | 2.81 | 2.84 | 1.48 | 1.51 |  |  |  |  |  |  |  |  | Whiskey house
Murphys |  | 2.74 |  |  |  |  |  | 1.73 | 1.79 | 0.77 | 1.76 | 2.74 | 1.78 | 1.72 | 3.3 | 1.42 | 2.15 |  |  |  |  |  |  |  |  | topples
The Edge |  | 0.88 |  |  |  |  |  | 1.45 | 4.42 | 3.46 | 1.48 | 1.49 | 1.42 | 1.47 | 2.9 | 7.01 | 3.42 |  |  |  |  |  |  |  |  | spinning wheel
spinning wheel |  |  |  |  |  |  |  | 0.7 | 2.72 | 6.7 | 0.73 | 0.77 | 2.29 | 2.76 | 0.88 | 1.2 | 2.47 |  |  |  |  |  |  |  |  | The Edge
Flannerys |  |  |  |  |  |  |  | 2.8 | 2.89 | 1.22 | 2.82 | 2.84 | 2.81 | 2.83 | 0.98 | 3.21 | 3.04 |  |  |  |  |  |  |  |  | Coalmans
The Pit |  |  |  |  |  |  |  | 0.5 | 5.5 | 8.5 | 0.51 | 0.99 | 2.1 | 0.56 | 1.98 | 4.5 | 4.43 |  |  |  |  |  |  |  |  | Flannerys
Beer House |  |  |  |  |  |  |  | 3.1 | 4.1 | 1.33 | 3.12 | 3.15 | 0.9 | 3.16 | 5.9 | 2.2 | 1.65 |  |  |  |  |  |  |  |  | The Pit
Stewarts |  |  |  |  |  |  |  | 2.5 | 2.53 | 3.31 | 2.58 | 5.59 | 2.53 | 2.55 | 6 | 1.19 | 2.97 |  |  |  |  |  |  |  |  | Beer House
Coalmans |  |  |  |  |  |  |  | 1.1 | 1.18 | 1.13 | 1.17 | 1.19 | 1 | 2 | 3.08 | 0.91 | 1.93 |  |  |  |  |  |  |  |  | Stewarts
 |  |  |  |  | if I pick a2(whiskey house) then c1 will equal a random number from j2:j11 and if I pick a3
 |  |  |  |  | (topples) then c2 equals a random number from k2:k11.
Spreadsheet: 792574d1660987270-retrieving-data-from-a-table-based-on-two-drop-down-box-values-2022-08-20-oeldere-niknolte84-sample1
Sheet: PT Oeldere

 | Kolomlabels
 | 06 |  | 07
Rijlabels | Som [NAME] | Differance | Som [NAME] | Differance
[NAME] | 406.57 |  | 0 | -406.57
AJet | 0 |  | 0 | 0
All Suppliers | 16539.36 |  | 8626.99 | -7912.369999999997
Amazon | 636.67 |  | 1162.64 | 525.9700000000001
Arboritom | 0 |  | 0 | 0
Arleigh | 0 |  | 1494 | 1494
Asgard | 0 |  | 0 | 0
AvantiGas | 0 |  | 0 | 0
Buildbase | 206.78 |  | 0 | -206.78
Calor | 0 |  | 0 | 0
[NAME] | 8064 |  | 0 | -8064
Coast & County Ltd | 0 |  | 0 | 0
Creative Play | 0 |  | 0 | 0
DeeBee | 1232.87 |  | 904.47 | -328.3999999999999
Eden Farm Hulleys | 196.01 |  | 517.13 | 321.12
EuroCell | 236.6 |  | 9.58 | -227.02
Firestop Services | 657.3 |  | 0 | -657.3
Foundations and Buildings | 0 |  | 0 | 0
[NAME] | 114.17 |  | 60.98 | -53.19
[NAME]'s Homeware | 0 |  | 0 | 0
Keycraft | 251.75 |  | 0 | -251.75
[NAME] | 0 |  | 0 | 0
[NAME] | 1104.84 |  | 0 | -1104.84
LincsPest Ltd | 602.4200000000001 |  | 0 | -602.4200000000001
Miscellaneous Vendor | 205.93 |  | 579.0999999999999 | 373.1699999999999
Office Stationary | 116.73 |  | 0 | -116.73
S and A Colclough | 0 |  | 0 | 0
Screwfix | 288.27 |  | 530.5400000000001 | 242.2700000000001
SGS | 0 |  | 0 | 0
Smart Spanner | 90 |  | 0 | -90
SSE | 0 |  | 0 | 0
Tesco | 0 |  | 133.5 | 133.5
Veolia | 2018.05 |  | 0 | -2018.05
Victorian Plumbing | 82.55 |  | 0 | -82.55
Weldricks Pharmacy | 27.85 |  | 0 | -27.85
Welton Aggregate | 0 |  | 0 | 0
Windhager | 0 |  | 0 | 0
Y Pellets | 0 |  | 3235.05 | 3235.05
Spreadsheet: 733374d1621531931-index-of-terms-based-on-overlapping-dates-gantt-chart-utilizing-conditional-distinct-values-lilybickel-
Sheet: Sheet2

name | variable 1 | start date 1 | end date 1 | variable 2 | start date 2 | end date 2 | variable 3 | start date 3 | end date 3 | variable 4 | start date 4 | end date 4 | variable 5 | start date 5 | end date 5 |  |  |  |  |  |  |  |  |  | Names
name1 | A | 2010-01-01 00:00:00 | 2015-01-01 00:00:00 | B | 2014-01-01 00:00:00 |  | C | 2015-01-01 00:00:00 |  | A | 2018-01-01 00:00:00 |  | E | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | name1
[NAME] | G | 2015-01-01 00:00:00 | 2018-01-01 00:00:00 | B | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | E | 2019-01-01 00:00:00 |  | A | 2019-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Name | Variable | Start Date | End Date | End Date 2 |  | Name: | name1
name1 | A | 2010-01-01 00:00:00 | 2015-01-01 00:00:00
name1 | B | 2014-01-01 00:00:00
name1 | C | 2015-01-01 00:00:00
name1 | A | 2018-01-01 00:00:00
name1 | E | 2020-01-01 00:00:00
[NAME] | G | 2015-01-01 00:00:00 | 2018-01-01 00:00:00
[NAME] | B | 2015-01-01 00:00:00 | 2016-01-01 00:00:00
[NAME] | E | 2019-01-01 00:00:00
[NAME] | A | 2019-01-01 00:00:00
Spreadsheet: 764335d1642690916-compare-information-on-different-sheets-and-highlight-differences-rooms-etaf
Sheet: Sheet1

FILTER | Building No | Room No | Room Name | Area (m2) | Height (m)
 | B | B.ST.01 | Staircase | 11.8240000000003 | 10.4
 | B | B.0.01 | Process Room | 79.2995475476171 | 4.34
 | B | B.0.03 | Process Tanks | 28.6411345671637 | 5.38061630251183
 | B | [NAME] | Big Bag Station | 11.844399999997 | 9.91999999999999
 | B | B.0.02 | Candle Filter room | 44.2998000000182 | 4.34
Spreadsheet: darrell_schoolcraft__7824__imbalsumm0110
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 160749 | 160590 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 147094 | 166627 |  | -13300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-09-30 00:00:00 |  |  |  | 51206
 | 2001-10-02 00:00:00
 | CBS Dollars
 |  |  |  | -347016
Spreadsheet: 053ef7c5-aed4-43bb-abb6-f6a8c1a9fb9c
Sheet: MathSciNet

MathSciNet
2005-2006
 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | Total | 2005-2006 price | Price per search
MathSciNet
Sessions | 136 | 35 | 213 | 220 | 189 | 182 | 229 | 316 | 582 | 328 | 702 | 129
Searches | 299 | 193 | 501 | 445 | 369 | 388 | 491 | 634 | 844 | 648 | 947 | 304 |  | 6856
Spreadsheet: john_griffith__16125__1_23_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 53 | 240 | 320 | 48.5 | 64.7 | 1.89 | 2002-01-23 11:37:00
 | [NAME] | 53 | 640 | 700 | 50.5 | 55.3 | 1.76 | 2002-01-23 11:37:00
 | HO J2 | 53 | 840 | 900 | 49 | 52.5 | 1.69 | 2002-01-23 11:37:00
 | HO K2 | 53 | 950 | 1025 | 45.3 | 48.9 | 1.57 | 2002-01-23 11:37:00
 | HO M2 | 53 | 1100 | 1200 | 45.2 | 49.3 | 1.57 | 2002-01-23 11:37:00
 | HO N2 | 54 | 1150 | 1250 | 42 | 45.7 | 1.49 | 2002-01-23 11:37:00
 | HO Q2 | 55 | 1225 | 1323 | 40.3 | 43.6 | 1.45 | 2002-01-23 11:37:00
 | HO U2 | 56 | 1300 | 1400 | 38.9 | 41.9 | 1.42 | 2002-01-23 11:37:00
 | [NAME] | 57 | 1300 | 1450 | 36 | 40.2 | 1.37 | 2002-01-23 11:37:00
 | HO X2 | 58 | 1375 | 1525 | 35.3 | 39.2 | 1.36 | 2002-01-23 11:37:00
 | [NAME] | 58 | 1400 | 1525 | 34.4 | 37.5 | 1.31 | 2002-01-23 11:37:00
 | HO F3 | 59 | 1425 | 1575 | 33 | 36.5 | 1.29 | 2002-01-23 11:37:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 717215d1612532561-sumif-ignoring-duplicates-if-exist-during-lookup-test
Sheet: Sheet1

 |  |  |  |  | Desired Result
 |  |  | Lookup |  | 1st | 2nd
 |  |  | 42420 | 2801
 |  |  | 42486 | 11007
 |  |  | 42486 | 19263
 |  |  | 43063 | 89081
 |  |  | 43063 | 97760
 |  |  | 43063 | 89599
Spreadsheet: 851624d1701811520-countif-function-for-buisness-personal-mileage-log-milage-log
Sheet: Sheet1

Business |  |  | Personal
Date of Travel | Purpose of Travel | Odmeter Reading |  | Milage | Comments
 |  | Start | End
2023-09-11 00:00:00 | Personal | 2001 | 2010
2023-09-12 00:00:00 | Business | 2010 | 2090
2023-09-13 00:00:00
2023-09-14 00:00:00
2023-09-15 00:00:00
2023-09-16 00:00:00
2023-09-17 00:00:00
2023-09-18 00:00:00
2023-09-19 00:00:00
2023-09-20 00:00:00
2023-09-21 00:00:00
2023-09-22 00:00:00
2023-09-23 00:00:00
Spreadsheet: 735560d1623075269-extract-unique-values-from-a-range-book2-17-ans
Sheet: Sheet1

1 | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  | g is not there in table
a | 3 | c
d | e | 4 |  | a | b | c | d | e | f | g | EXPECTED
5 | a | b
e | f | d
2 | 4 | b
d | a | f
Spreadsheet: 831153d1685453640-referencing-spilled-array-to-create-spilled-array-test3
Sheet: Sheet1

Data Table |  |  |  | Set Target Name: |  | Yellow section should match Green sections |  |  |  |  |  |  |  |  |  |  |  |  |  | Scores Table
[NAME] | Report Year | Sales |  | [NAME] |  | Spilled arrays. |  |  |  |  |  | Expected Results |  |  |  |  |  |  |  |  | 2001 | 2003
Name1 | 2001 | 0.2601754007917111 |  |  |  | Automatically adjusting number of rows |  |  |  |  |  | Manually set number of Rows |  |  |  |  |  |  |  |  | 3 | 5
Name1 | 2001 | 0.5589487394348224 |  | Year List |  | Target Score | Target Value | Min Score | Min Name | Min Name Value |  | Target Score | Target Value | Min Score | Min Name | Min Name Value |  |  | [NAME] | 2 | 4 | 6
Name1 | 2002 | 0.0339131073571044
Name1 | 2003 | 0.6124610747021023 |  | 2001 |  | 4 | 1.352177124367662 |  |  | 0
Name1 | 2002 | 0.2151687574897279 |  | 2003 |  | 6 | 0.002212278013714819 |  |  | 0
[NAME] | 2002 | 0.0273300349704646
[NAME] | 2001 | 0.5169532134791222
[NAME] | 2001 | 0.8352239108885394
[NAME] | 2002 | 0.3439801552874848
[NAME] | 2003 | 0.002212278013714819 |  |  |  | [NAME] |  |  |  |  |  |  | u |  |  |  | d |  | f
Name3 | 2005 | 0.33333 |  |  |  |  |  |  |  |  |  |  |  | 2001 | 0.8191241402265335 |  |  |  |  | 2002 | 0.3713101902579494
 |  |  |  |  |  | 4 |  | 4 | [NAME] | 1.352177124367662 |  |  | Name1 | 2002 | 0.2490818648468323 |  | 0.8191241402265335 |  | [NAME] | 2001 | 1.352177124367662
 |  |  |  |  |  | 6 |  | 6 | [NAME] | 0.002212278013714819 |  |  | Name1 | 2003 | 0.6124610747021023 |  | 0.2490818648468323 |  | [NAME] | 2003 | 0.002212278013714819
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2002 | 0.3713101902579494 |  | 0.6124610747021023
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2001 | 1.352177124367662 |  | 0.2490818648468323
 |  |  |  |  |  | Bo_Ry Solution |  |  |  |  |  |  | [NAME] | 2003 | 0.002212278013714819 |  | 0.3713101902579494
 |  |  |  |  |  |  |  |  |  |  |  |  | Name3 | 2005 | 0.33333 |  | 1.352177124367662
 |  |  |  |  |  | 4 |  | 3 | Name1 | 0.8191241402265335 |  |  |  |  |  |  | 1.352177124367662
 |  |  |  |  |  | 6 |  | 5 | Name1 | 0.6124610747021023 |  |  |  |  |  |  | 0.3713101902579494
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.002212278013714819
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.33333
Spreadsheet: 735713d1623151251-counting-and-pasting-characters-help-example
Sheet: Sheet1

Raw Data: | Charlotte - client received a backup but could not restore, so logon and created a new folder with the same name and unzipped the file and added to the [NAME] folder, open data and correct, advised that going forward the folder will be the same name so can just restore, but the zip file must be saved on the hard rive from the email first.
Intended Result | Charlotte - client received a backup but
 | but could not restore, so logon and cre
 | ated a new folder with the same name and
 | unzipped the file and added to the Xpres
 | etc etc
Spreadsheet: 692493d1598391516-extrapolate-roll-existing-data-in-same-format-extrap-dummy
Sheet: 14

Stat | Assignment | DocumentNo | Type | SG | DD | Clrng doc. | Text | CoCd | Doc. Date | Amount in local cur. | LCurr | Amount in doc. curr. | Curr. | Pmnt date | Day1
Bla | 123 | 12345 | RE |  |  | 12345 | [NAME] | 1 | 2020-08-03 00:00:00 | -34650 | EUR | -34650 | EUR | 2020-08-17 00:00:00 | 14
Spreadsheet: 70789d1271466136-conditional-formatting-payment-tracker-after
Sheet: Bill Payment Tracker

 | [NAME] |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Van Insurance |  |  | 2010-05-17 00:00:00 |  | X
 | Van Payment |  |  | 2010-04-20 00:00:00
 | Cell Phone |  |  | 2010-05-01 00:00:00
Spreadsheet: 55565d1255680925-formula-to-count-multiple-ifs-and-take-an-average-703475_sam_d_v2
Sheet: PT

 |  |  | Data
Years | Query Arrived | Company | Average of Process Time | Average of Company Internal Lag | Average of Overal Company Lag Time Due to Query Deficencies | Average of Lag Time Per Rejection
2009 | May | Company B | 6 | 1 | 1 | 0
 | Jun | Company A | 13 | 15 | 15 | 0
 |  | Company C | 8.5 | 3 | 3 | 0
 | Jul | Company A | 10.90909090909091 | 13.27272727272727 | 17.18181818181818 | 3.181818181818182
 |  | Company B | 4 | 0.6666666666666666 | 1.666666666666667 | 1
 |  | Company C | 4.444444444444445 | 1.666666666666667 | 3.666666666666667 | 0.1111111111111111
 | Aug | Company A | 1.5 | 22 | 23.5 | 0
 | Sep | Company A | 12 | 62 | 68 | 6
Grand Total |  |  | 7.433333333333334 | 9.7 | 12.13333333333333 | 1.5
Spreadsheet: 34c43780-e829-422c-8ede-d9415128f7db
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: |  |  | 2011-05-24 09:40:10.690000
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.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 100.981 | 100.856 | 100.731 | 100.356
4.625 | 99.883 | 99.758 | 99.633 | 99.258 |  | Note: | Refer To Price [NAME]
4.5 | 99.412 | 99.287 | 99.162 | 98.787 |  |  | For all Price Adjs
4.375 | 98.802 | 98.677 | 98.552
 |  |  |  |  |  | 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
4.25 | 101.875 | 101.75 | 101.625 | 101.25
4.125 | 101.039 | 100.914 | 100.789 | 100.414
4 | 100.713 | 100.588 | 100.463 | 100.088
3.875 | 100.283 | 100.158 | 100.033 | 99.658
3.75 | 99.739 | 99.614 | 99.489
 |  |  |  |  |  | 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 | 2011-06-07 09:40:10.690000
30 DAY | 2011-06-22 09:40:10.690000
45 DAY | 2011-07-07 09:40:10.690000
60 DAY | 2011-07-22 09:40:10.690000
90 DAY | 2011-08-21 09:40:10.690000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 836911d1689710994-merged-cell-values-to-adjacent-single-cells-merged-cell-values-to-single-cells
Sheet: Sheet1

Fee Account Num |  |  |  | My Desired Result
3624
3633
3831
3950
4115
4118
4120
4218
4232
4254
Spreadsheet: 813532d1673838322-automatically-fill-calendar-from-master-table-calendar-draft
Sheet: M1

JANUARY |  |  |  | JANUARY
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Notes
1
Spreadsheet: 0e7e74e2-e573-47ac-a2d2-05565576354a
Sheet: Fringe Calculation

Illustrative Computation of Fringe Benefit in the Absence of an approved NICRA
Applicant  may be authorized to assess fringe benefits provided the documentation properly supports these costs
All costs must be reasonable, allocable, and allowable.
As a part of the cost proposal , applicant must provide detailed information
as to how it calculates its fringe benefits.
For that reason, please list the items that make up your corporate fringe benefit pool
Additionally, please provide a written explanation of exactly how your
rates are determined.
You must substantiate these costs with your organization's policy and financial statement(s).
Below is an example of what costs  might be included in your employees fringe benefits
Include only those costs you can substantiate.
 | PERCENTAGES
 | Estimate | Actual | Actual
FRINGE BENEFITS: | 2009 | 2010 | 2011
Leave: | in % | in % | in %
Vacation (e.g. 10 days out of 260 work days/yr) | 0.0385 | 0.0385 | 0.0385
[NAME]  (e.g. 5 days out of 260 work days/yr) | 0.0192 | 0.0192 | 0.0192
Holidays (.e.g 10 days out of 260 work days/yr) | 0.0385 | 0.0385 | 0.0385
[NAME] (e.g. 2 days out of 260 work days/yr) | 0.0077 | 0.0077 | 0.0077
TOTAL ANNUAL LEAVE | 0.1038 | 0.1038 | 0.1038
Other Fringe Benefits:
Health Insurance | 0 | 0 | 0
Pension | 0 | 0 | 0
Disability Insurance | 0 | 0 | 0
Unemployment | 0 | 0 | 0
Employer FICA | 0 | 0 | 0
Other:specify | 0 | 0 | 0
fr | 0 | 0 | 0
Other: | 0 | 0 | 0
TOTAL OTHER FRINGE BENEFITS % | 0 | 0 | 0
Proposed [NAME] rate for this application
An alternative method can be provided by using costs
Direct Cost Base
Total Direct Labor costs to which fringe is applied | 30000 | 32000 | 29000
Finge costs applied to direct labor | 5000 | 5000 | 5000
[NAME] | 0.17 | 0.16 | 0.17
Proposed [NAME] rate for this application | 0.17
Spreadsheet: darrell_schoolcraft__7818__imbalsumm0109
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 | -11978 | -1386
500046 | -259 |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 | -25849
500528
500529
500619
INDEX
2001-08-31 00:00:00 |  |  | -757792.37
2001-09-11 00:00:00
CBS Volume
 |  |  | -152176
Spreadsheet: 26180d1218111032-match-and-replace-cells-indexmatch
Sheet: Sheet3

Dataset | A | Dataset | B | (edited)
10 | 11 | 100 | 30 | 33 | 300
20 | 22 | 200 | 20 | 22 | 200
30 | 33 | 300 | 40 | 44 | 400
40 | 44 | 400 | 50 | 55 | 500
50 | 55 | 500 | 10 | 11 | 100
Spreadsheet: 703620d1605087175-copy-different-and-changing-length-lists-from-multiple-sheets-dept-summary-for-questions-ans
Sheet: DEPT HEAD

 |  |  |  | Divisions can be added to next columns
Total dvns |  |  |  | Change the range B3:C3 in the formulas.
 | 1ST DIV | 2ND DIV
TYPE 1
TYPE 2
TYPE 3
TYPE 4
TOTAL
TYPE 2
LAST NAME | FIRST NAME | DIVISION | START | STOP
TYPE 3
LAST NAME | FIRST NAME | DIVISION | START | STOP
Spreadsheet: 123524d1317717003-help-with-lookup-test
Sheet: Sheet1

Reference no. | [NAME] |  |  |  | Reference no. | Prod No. | Detail 1 | [NAME] 2
1 | OK |  |  |  | 1 | 11 | A | OK
2 | NOT OK |  |  |  | 1 | 12 | B | OK
3 | NOT OK |  |  |  | 1 | 13 | C | OK
 |  |  |  |  | 2 | 14 | D | OK
OK if all cells in column I have OK for the Reference no. and NOT OK if even any one cell has NOT OK in [NAME] n I for a Reference no. |  |  |  |  | 2 | 15 | E | OK
 |  |  |  |  | 2 | 16 | F | OK
 |  |  |  |  | 2 | 17 | G | NOT OK
 |  |  |  |  | 3 | 18 | H | OK
 |  |  |  |  | 3 | 19 | I | OK
 |  |  |  |  | 3 | 20 | J | OK
 |  |  |  |  | 3 | 21 | K | NOT OK
 |  |  |  |  | 3 | 22 | L | OK
 |  |  |  |  | 3 | 23 | M | OK
 |  |  |  |  | 3 | 24 | N | OK
Spreadsheet: 116068d1311576245-sumproduct-multiple-worksheets-sumproduct
Sheet: Sheet1

Stat | Mark
Urgent | x
Urgent | x
Routine | ok
Pending | ok
Routine | ok
Urgent | x
Routine | ok
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Routine | ok
Pending | ok
Urgent | x
Routine | ok
Pending | ok
Routine | ok
Pending | ok
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Urgent | x
Spreadsheet: 845303d1696846804-lookup-formula-that-can-handle-duplicates-leavedata
Sheet: Sheet1

Name and Surname | Type of Leave | Leave Balance | Number of Days Approved | New Leave Balance
User 1 | Annual Leave | 15 | 1
User 2 | Annual Leave | 15 | 3
User 3 | Annual Leave | 15 | 5
User 4 | Annual Leave | 15 | 5
User 5 | Annual Leave | 15 | 2
User 1 | Annual Leave |  | 3
User 4 | Annual Leave |  | 5
User 2 | Annual Leave |  | 4
User 3 | Annual Leave |  | 6
User 5 | Annual Leave |  | 3
User 5 | Annual Leave |  | 8
User 1 | Annual Leave |  | 1
User 3 | Annual Leave |  | 2
User 2 | Annual Leave |  | 4
User 4 | Annual Leave |  | 4
Spreadsheet: 238589d1369638238-pulling-data-from-one-spread-sheet-into-another-retrieve-last-20-dates-of-data2
Sheet: Sheet1

Date |  | data-22 | data-21 | data-20 | data-19 | data-18 | data-17 | data-16 | data-15 | data-14 | data-13 | data-12 | data-11 | data-10 | data-9 | data-8 | data-7 | data-6 | data-5 | data-4 | data-3 | data-2 | data-1 | data
2013-06-27 00:00:00