tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 162656d1340026312-excel-2007-column-data-transfer-and-automatic-data-deletion-mock-up
Sheet: Raw Data

Start Time | End Time | Raw data | Name | Reason
2012-05-16 00:00:00 | 2012-06-06 23:59:00 | [NAME] | [NAME] | WFH
2012-05-28 10:00:00 | 2012-05-28 10:00:00 | Joe - Vacation | [NAME] | Vacation
2012-05-29 00:00:00 | 2012-06-19 23:59:00 | Cindy - Sick | [NAME] | Sick
2012-05-29 00:00:00 | 2012-05-29 23:59:00 | Billy - Sick | Billy | Sick
2012-05-29 09:00:00 | 2012-05-29 18:00:00
2012-05-30 00:00:00 | 2012-05-30 23:59:00
2012-05-31 00:00:00 | 2012-05-31 23:59:00
2012-05-31 00:00:00 | 2012-05-31 23:59:00
2012-05-31 00:00:00 | 2012-05-31 23:59:00
2012-06-01 00:00:00 | 2012-06-12 23:59:00
2012-06-01 00:00:00 | 2012-06-01 23:59:00
2012-06-04 00:00:00 | 2012-06-08 23:59:00
2012-06-04 00:00:00 | 2012-06-04 23:59:00
2012-06-04 00:00:00 | 2012-06-04 23:59:00
2012-06-05 00:00:00 | 2012-06-05 23:59:00
2012-06-05 00:00:00 | 2012-06-05 23:59:00
2012-06-05 00:00:00 | 2012-06-05 23:59:00
2012-06-06 00:00:00 | 2012-06-06 23:59:00
2012-06-07 00:00:00 | 2012-06-07 23:59:00
2012-06-08 00:00:00 | 2012-06-08 23:59:00
2012-06-08 00:00:00 | 2012-06-08 23:59:00
2012-06-08 00:00:00 | 2012-06-08 23:59:00
2012-06-11 00:00:00 | 2012-06-11 23:59:00
2012-06-11 00:00:00 | 2012-06-11 23:59:00
2012-06-11 00:00:00 | 2012-06-11 23:59:00
2012-06-11 00:00:00 | 2012-06-11 23:59:00
2012-06-12 00:00:00 | 2012-06-14 23:59:00
2012-06-12 00:00:00 | 2012-06-14 23:59:00
2012-06-13 00:00:00 | 2012-06-18 23:59:00
2012-06-13 00:00:00 | 2012-06-13 23:59:00
2012-06-14 00:00:00 | 2012-06-14 23:59:00
2012-06-14 00:00:00 | 2012-06-14 23:59:00
2012-06-15 00:00:00 | 2012-06-19 23:59:00
2012-06-15 00:00:00 | 2012-06-15 23:59:00
2012-06-15 00:00:00 | 2012-06-15 23:59:00
2012-06-15 00:00:00 | 2012-06-15 23:59:00
2012-06-18 00:00:00 | 2012-06-22 23:59:00
2012-06-22 00:00:00 | 2012-06-22 23:59:00
2012-06-29 00:00:00 | 2012-06-29 23:59:00
2012-07-02 00:00:00 | 2012-07-06 23:59:00
2012-07-05 00:00:00 | 2012-07-09 23:59:00
2012-07-05 00:00:00 | 2012-07-09 23:59:00
2012-07-06 00:00:00 | 2012-07-06 23:59:00
Spreadsheet: 219615d1362821301-what-to-enter-in-cell-a7-to-exclude-anything-that-appears-in-cells-a3-a6-linked-to-sumifs-f-to-exc-po-on-summary
Sheet: PO

Test |  |  |  |  |  | PURCHASE ORDER DETAILS
PO # | Month | PO Date | Contract | Week# | Supplier | Details of Goods/Services i.e. Vehicle Registration, Employee Name etc | GLCode | GL Description | exc GST | GST | GST | inc GST | Emp | Date Inv  Rec'vd | Y/N
100 |  | 2013-01-01 00:00:00 | A |  | Example 1 | Test 1 | 1000 1 |  | 10 |  |  |  | Name
101 |  | 2013-01-08 00:00:00 | D |  | Example 2 | Test 2 | 2000 2 |  | 20 |  |  |  | Name | 2013-01-31 00:00:00
101 |  | 2013-01-16 00:00:00 | G |  | Example 3 | Test 3 | 3000 3 |  | 50 |  |  |  | Name | 2013-01-31 00:00:00
102 |  | 2013-01-22 00:00:00 | J |  | Example 4 | Test 4 | 4000 4 |  | 100 |  |  |  | Name | 2013-01-31 00:00:00
103 |  | 2013-01-28 00:00:00 | M |  | Example 5 | Test 5 | 5000 5 |  | 10 |  |  |  | Name
104 |  | 2013-02-01 00:00:00 | M |  | Example 6 | Test 6 | 6000 6 |  | 20 |  |  |  | Name | 2013-01-31 00:00:00
105 |  | 2013-02-07 00:00:00 | J |  | Example 7 | Test 7 | 7000 7 |  | 50 |  |  |  | Name | 2013-01-31 00:00:00
106 |  | 2013-02-14 00:00:00 | G |  | Example 8 | Test 8 | 8000 8 |  | 100 |  |  |  | Name
107 |  | 2013-02-21 00:00:00 | J |  | Example 9 | Test 9 | 9000 9 |  | 10 |  |  |  | Name
108 |  | 2013-02-28 00:00:00 | A |  | Example 10 | Test 10 | 1000 1 |  | 20 |  |  |  | Name
109 |  | 2013-01-02 00:00:00 | V |  | Example 11 | Test 11 | 2000 2 |  | 50 |  |  |  | Name
110 |  | 2013-02-02 00:00:00 | V |  | Example 12 | Test 12 | 3000 3 |  | 100 |  |  |  | Name
Spreadsheet: 156492d1337314748-golf-handicap-results
Sheet: Sheet1

ASTORIA GOLF SOCIETY
HANDICAPS |  |  |  |  |  |  |  |  | RESULT
No |  | Name | handicap | Category | Double bogie | Change | New Handicap |  | Pos | Scr | NAME
1 | A | [NAME] | 4.9 |  | 85 |  |  |  | 11 | 22 | Almond A
3 | M | Butterworth | 15.9 |  | 82 |  |  |  | 14 | 17 | Butterworth M
4 | J | Hart | 10.7 |  | 77 |  |  |  | 2 | 32 | Hart J
5 | J | [NAME] | 9.9 |  | ~ |  |  |  | 16 |  | [NAME] J
6 | L | [NAME] | 9.6 |  | 80 |  |  |  | 6 | 27 | [NAME]
7 | S | Kenny | 14.3 |  | 81 |  |  |  | 8 | 25 | [NAME]
8 | J | McArdle | 13.5 |  | 74 |  |  |  | 1 | 32 | McArdle J
9 | K | McArdle | 9.2 |  | 80 |  |  |  | 2 | 26 | McArdle K
10 | H | [NAME] | 18.5 |  | 76 |  |  |  | 5 | 27 | Palombella H
11 | T | Pritchard | 17.9 |  | 74 |  |  |  | 4 | 28 | Pritchard P
12 | K | [NAME] | 9.2 |  | 75 |  |  |  | 3 | 32 | [NAME]
13 | J | Shepherd | 24.9 |  | 79 |  |  |  | 13 | 17 | Shepherd J
14 | A | [NAME] | 19.7 |  | 77 |  |  |  | 15 | 15 | [NAME]
15 | J | Tierney | 24.6 |  | 79 |  |  |  | 9 | 25 | Tierney J
16 | P | [NAME] | 19.8 |  | 79 |  |  |  | 12 | 22 | [NAME] P
17 | W | [NAME] | 15.7 |  | 79 |  |  |  | 10 | 24 | [NAME]
Comp No: |  |  |  |  |  |  |  |  |  | Nearest The Pin
4
 |  |  |  |  |  |  |  |  | 5th | J Hart
Date:
2012-04-08 00:00:00 |  |  |  |  |  |  |  |  | 6th | J Hart
[NAME]: |  |  |  |  |  |  |  |  | 12th | M Butterworth
T Pritchard Cup
 |  |  |  |  |  |  |  |  | 17th | J Hart
Course: |  |  | Par
Ellesmere Port |  |  | 71
Format
Stableford
 |  | * Notes a player has gained a shot
 |  | # Notes a player has lost a shot
Spreadsheet: 154a3ce6-d3df-4f46-a384-224f56952f57
Sheet: Sheet1

Table 3--U.S. monthly average farm prices and marketings | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  | 2012/13 |  |  |  | 2011/12 |  |  |  | 2010/11
Month |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August |  | 14.4 |  | 10493 |  | 13.6 |  | 11384 |  | 11.7 |  | 10691
September |  | 14.6 | 1/ |  |  | 14.4 |  | 12507 |  | 11 |  | 15095
October |  |  |  |  |  | 14.7 |  | 11777 |  | 11.5 |  | 17131
November |  |  |  |  |  | 15 |  | 11615 |  | 12.6 |  | 16929
December |  |  |  |  |  | 14.7 |  | 14954 |  | 13.9 |  | 19137
January |  |  |  |  |  | 14.8 |  | 15387 |  | 14 |  | 21806
February |  |  |  |  |  | 14 |  | 13638 |  | 13.4 |  | 14847
March |  |  |  |  |  | 13.9 |  | 14783 |  | 13 |  | 15844
April |  |  |  |  |  | 14.1 |  | 13336 |  | 13.1 |  | 12727
May |  |  |  |  |  | 13.9 |  | 12960 |  | 12.7 |  | 14227
June |  |  |  |  |  | 14.1 |  | 10524 |  | 12.1 |  | 11317
July |  |  |  |  |  | 14.2 |  | 10199 |  | 12.9 |  | 13369
Average price to date |  | 14.5 | 2/
Season average farm price |  | 14.7 | 3/ |  |  | 14.3 | 3/ |  |  | 12.7
Average Marketings |  |  |  | 10493 |  |  |  | 12755.33333333333 |  |  |  | 15260
Total volume marketed |  |  |  | 10493 |  |  |  | 153064 |  |  |  | 183120
N/A = Not available.
1/ Mid-month only.  2/ Simple average.  3/ Mid-point of season-average farm price projection range.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated October 11, 2012.
Spreadsheet: 207879d1358596547-check-if-the-values-of-a-list-are-in-progressive-order-example
Sheet: Feuil1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected result
 | 0 | 0 | 0 | 16 | 12 | 10 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | TRUE
 | 12 | 4 | 12 | 0 | 0 | 1 | 0 | 10 | 0 | 0 | 0 | 0 | 1 | FALSE
 | 19 | 0 | 2 | 1 | 0 | 2 | 10 | 5 | 0 | 0 | 0 | 0 | 1 | FALSE
 | 15 | 8 | 8 | 0 | 7 | 6 | 5 | 4 | 0 | 0 | 3 | 2 | 1 | TRUE
 | 15 | 8 | 8 | 0 | 7 | 5 | 6 | 4 | 0 | 0 | 3 | 2 | 1 | FALSE
Spreadsheet: 0db12bfb-4d56-4c08-8498-9ab47a696964
Sheet: Sheet1

Online
Sales
Day | Climbing Roses | Patio Roses | Tea Roses
Sun | 1911.51 | 2026.46 | 2033.47
Mon | 2310.49 | 2313.85 | 1782.64
Tue | 1942.37 | 2402.99 | 2030.08
Wed | 2185.89 | 1992.29 | 2253.98
Thu | 2003.53 | 1825.79 | 2340.34
Fri | 1931.46 | 1946.92 | 1966.92
Sat | 2047.23 | 1978.23 | 2234.12
Recorded on:
2016-06-03 00:00:00
Reviewed on:
Spreadsheet: 96123d1295555684-alternative-to-vlookup-copy-of-excel-problem
Sheet: Supplier and Materials

Material code | Name | Material Name
109882 | supplier 1 | Oranges | supplier 1_1
117616 | supplier 2 | Lime | supplier 2_1
115528 | supplier 3 | Chocolate Stars | supplier 3_1
145267 | supplier 3 | MELON SLICES | supplier 3_2
104915 | supplier 3 | Rasin | supplier 3_3
110676 | supplier 3 | Mango Juice | supplier 3_4
115382 | supplier 3 | Carrots (chopped) | supplier 3_5
109875 | supplier 3 | Melon | supplier 3_6
140882 | supplier 3 | Sized Onions | supplier 3_7
111488 | supplier 9 | Pear Puree | supplier 9_1
104622 | supplier 9 | Apple slices | supplier 9_2
139871 | supplier 9 | Air Freighted Mix | supplier 9_3
144815 | supplier 12 | Orange Juice | supplier 12_1
115456 | supplier 13 | Plum | supplier 13_1
109866 | supplier 14 | Lime Juice | supplier 14_1
117146 | supplier 15 | [NAME] | supplier 15_1
115456 | supplier 16 | Plum | supplier 16_1
117146 | supplier 16 | [NAME] | supplier 16_2
125757 | supplier 16 | [NAME] (4) | supplier 16_3
116055 | supplier 16 | French [NAME] | supplier 16_4
144227 | supplier 16 | Peaches | supplier 16_5
116055 | supplier 16 | French [NAME] | supplier 16_6
129734 | supplier 16 | Trial Mix 1013 | supplier 16_7
151956 | supplier 16 | Air Dried Apple | supplier 16_8
116852 | supplier 16 | Blueberries | supplier 16_9
116852 | supplier 26 | Blueberries | supplier 26_1
103107 | supplier 27 | [NAME] | supplier 27_1
105137 | supplier 28 | British Grapes | supplier 28_1
103072 | supplier 28 | Gooseberry | supplier 28_2
103073 | supplier 30 | Lemon Juice | supplier 30_1
116823 | supplier 31 | Tropical Mix | supplier 31_1
102267 | supplier 32 | [NAME] | supplier 32_1
105137 | supplier 33 | British Grapes | supplier 33_1
Spreadsheet: rick_buy__32663__Rac allocations budget pack 29 Nov
Sheet: Alloc out by CC (IO)

 | Adaytum
 | Risk Assessment & Control | TOTAL G&A
Plan 2001 | $ | IO Allocations Received | IO Allocations Received (People Costs only) | Imputed Average Headcount | % of Total Heads
 | UK | 1678214.666977612 | 1540408.159514925
 | Teesside | 239012.9975124378 | 211625.5348258707 | 1.65 | 0.03235294117647058
 | Metals | 1683259.260105721 | 1538560.812344527
 | Credit Markets Group | 0 | 0 | 1.83 | 0.0358823529411765
 | EnronCredit.com | 266615.4440298507 | 240221.7126865671 | 1.83 | 0.03588235294117647
 | Spain/Portugal | 157358.5105721393 | 141024.480721393 | 1.09 | 0.02137254901960784
 | Scandinavia | 532325.0178793533 | 478418.450715174 | 3.66 | 0.07176470588235294
 | German Speaking | 152411.2852922885 | 141429.3748445273 | 1.04 | 0.0203921568627451
 | Central Europe | 158974.6102300995 | 157900.1027674129 | 1.06 | 0.02078431372549019
 | Continental Power | 12745.86427238806 | 12522.04337686567 | 0.08 | 0.001568627450980393
 | Continental Gas | 0 | 0 | 0 | 0
 | Italy | 182520.7952425373 | 171637.3325559701 | 1.24 | 0.02431372549019607
 | Benelux/France | 85036.95429104478 | 79308.71548507463 | 0.59 | 0.01156862745098039
 | Poland | 175694.9280161692 | 164363.8235385572 | 1.2 | 0.02352941176470588
 | FSU | 26696.57633706467 | 26571.20320273631 | 0.18 | 0.003529411764705881
 | EES (50%) | 244280.0758706467 | 241781.8669154228 | 1.68 | 0.03294117647058823
 | IT Origination | 16158.79788557213 | 16158.79788557213 | 0.09999999999999995 | 0.001960784313725489
 | Corporate Finance Origination | 0 | 0 | 0 | 0
 | EnCom/EPower (67%) | 0 | 0 | 0 | 0
 | Japan | 0 | 0 | 0 | 0
 | Australia | 0 | 0 | 0 | 0
 | Non Region Specific | 53393.15267412934 | 53142.40640547263 | 0.36 | 0.007058823529411762
 | RECHARGE | 494565.5785136815 | 459829.2800062188 | 3.36 | 0.06588235294117648
 | Enron Corp | 0 | 0 | 0 | 0
 | India/APACHI/CALME | 0 | 0 | 0 | 0
 | EES (50%) - non-EEL | 244280.0758706467 | 241781.8669154228 | 1.68 | 0.03294117647058823
 | EnCom/EPower (Non Enron Europe) | 0 | 0 | 0 | 0
 | Global Markets | 555961.043221393 | 526532.26710199 | 3.65 | 0.07156862745098039
 | EBS | 490411.9491604478 | 446412.7849813433 | 3.38 | 0.06627450980392156
 | Total
Spreadsheet: 55183d1255355575-percentage-of-total-formula-taking-into-account-volume-example
Sheet: Sheet1

Employee | Successful | Unsuccessful | Total
Employee 1 | 0 | 3 | 3
Employee 2 | 2 | 1 | 3
Employee 3 | 3 | 2 | 5
Employee 4 | 4 | 6 | 10
Employee 5 | 2 | 4 | 6
Employee 6 | 3 | 4 | 7
Employee 7 | 1 | 1 | 2
Employee 8 | 5 | 5 | 10
Employee 9 | 5 | 8 | 13
Employee 10 | 0 | 2 | 2
Total | 25 | 36 | 61
Spreadsheet: 856684d1705894754-if-then-vlookup-defined-names-test-travel-tacnola-
Sheet: EMPLINFO

Office_Names |  |  | SECTION | TRAVELERS_NAME | EMPLID |  |  |  | SECTION | TRAVELERS_NAME | EMPLID |  |  |  | SECTION | TRAVELERS_NAME | EMPLID |  |  |  | SECTION | TRAVELERS_NAME | EMPLID
SELECT OFFICE |  |  |  | SELECT NAME |  | TK13 |  |  |  | DANZA, [NAME] | ABC | TK02 |  |  |  | AHMED, FAISAL | DSS | TK14 |  |  | TAD | HOWARD DUCK | 485
PPMD |  |  |  | BROWN, CHARLIE | 456 | TK13 |  |  |  | WILLIS, BRUCE | CDE | TK02 |  |  |  | JOKERS, WILD | 4154 | TK16 |  |  | TAD | LUCY, [NAME] | 545
C_S |  |  |  | WALKER, TEXAS | 789 | TK13 |  |  |  | ANNISTON, JENNIFER | ASD | TK02 |  |  |  | APPLE, RED | 665 | TK16 |  |  | TAM | SPEARS, BRITNEY | 957
E_C |  |  |  | SIMPSON, GLORIA | 321 | TK13 |  |  |  | JORDON, MICHEAL | LKJ | TK02 |  |  |  | MAKERS MARK | 454 | TK16 |  |  | TAM | [NAME], ARABIA | 458
OTHER |  |  |  | MARK, MARK E | 123 |  |  |  |  |  |  |  |  |  |  | RISEN, SUN | 255 | TK16 |  |  | TAM | KANGAROO, JACK | 128
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WASHER, WINDSHIELD | [NAME] | TK14 |  |  | TAM | SELLERS, STASON | 485
Spreadsheet: 22950d1212159113-summing-based-on-criteria-sumproductbudgett
Sheet: Checking

2008-05-01 00:00:00 | Fast Food | 15.23
2008-05-01 00:00:00 | Utilities | 64.09
2008-05-06 00:00:00 | Utilities | 23
2008-05-06 00:00:00 | Utilities | 9.86
2008-05-07 00:00:00 | Fast Food | 13
2008-05-09 00:00:00 | Home Improve | 12
2008-05-11 00:00:00 | Home Improve | 134
2008-05-13 00:00:00 | Car | 56
2008-05-14 00:00:00 | Fast Food | 23
2008-05-14 00:00:00 | Home Improve | 22.55
2008-05-14 00:00:00 | Car | 33.5
2008-05-17 00:00:00 | Car | 41
2008-05-18 00:00:00 | Misc | 22.11
2008-05-18 00:00:00 | Car | 56
2008-05-19 00:00:00 | Entertainment | 34.99
2008-05-21 00:00:00 | Misc | 45
2008-05-22 00:00:00 | Misc | 67
2008-05-23 00:00:00 | Entertainment | 45
2008-05-23 00:00:00 | Entertainment | 9.99
2008-05-23 00:00:00 | Misc | 41
2008-05-30 00:00:00 | Home Improve | 115.22
Spreadsheet: 876934d1723643487-calculation-of-work-experience-work-expirience
Sheet: Sheet1

START DATE | END DATE | WORK EXPERIENCE |  |  | TOTAL EXPERIENCE
 |  | YEAR | MONTH | DAYS
2018-12-24 00:00:00 | 2020-09-20 00:00:00
2017-06-19 00:00:00 | 2018-12-23 00:00:00
2020-09-21 00:00:00 | 2024-06-30 00:00:00
 | TOTAL:
Spreadsheet: 732090d1620764060-historical-stock-inventory-pricing-by-unit-triple-lookup-criteria-excel-sample
Sheet: Price History

DATE | DIA | PG | QQQ | SPY | TQQQ | UCO | UDOW | UMDD | UPRO | URTY | VTWO | UYG | DAILY MARKET VALUE | NOTES (FOR EXCEL FORUM REFERENCE ONLY)
2020-07-20 00:00:00 | 266.82 | 125.24 | 266.78 | 324.32 | 60.68 | 30.72 | 69.42 | 52.35 | 51.26 | 34.11 | 117.72 | 30.11 |  | 40 PG
2020-07-21 00:00:00 | 268.34 | 125.07 | 264 | 325.01 | 58.74 | 32.15 | 70.67 | 54.23 | 51.57 | 35.5 | 119.18 | 30.83 |  | 40 PG
2020-07-22 00:00:00 | 269.98 | 126.14 | 264.93 | 326.86 | 59.42 | 32.16 | 71.92 | 55.5 | 52.48 | 35.61 | 119.36 | 31.14 |  | 55 DIA, 40 PG, 100 QQQ, 60 SPY, 45 TQQQ, 125 UCO, 60 UDOW, 75 UMDD, 80 UPRO, 115 URTY, 125 VTWO
2020-07-23 00:00:00 | 266.69 | 126.16 | 258.01 | 322.96 | 54.76 | 31.38 | 69.2 | 55.77 | 50.58 | 35.71 | 119.55 | 31.11 |  | 55 DIA, 40 PG, 100 QQQ, 60 SPY, 45 TQQQ, 125 UCO, 60 UDOW, 75 UMDD, 80 UPRO, 115 URTY, 125 VTWO
2021-01-27 00:00:00 | 303.26 | 128.38 | 319.43 | 374.41 | 95.08 | 41.3 | 99.76 | 108.56 | 76.71 | 94.65 | 168.9 | 40.41 |  | 55 DIA, 40 PG, 100 QQQ, 60 SPY, 90 TQQQ, 125 UCO, 60 UDOW, 75 UMDD, 80 UPRO, 115 URTY, 125 VTWO
2021-01-28 00:00:00 | 306.07 | 130.36 | 321.32 | 377.63 | 96.48 | 40.73 | 102.38 | 111.25 | 78.64 | 93.65 | 168.72 | 41.76 |  | 53 DIA, 40 PG, 98 QQQ, 59 SPY, 85 TQQQ, 115 UCO, 55 UDOW, 70 UMDD, 75 UPRO, 110 URTY, 122 VTWO
2021-01-29 00:00:00 | 299.81 | 128.21 | 314.56 | 370.07 | 90.47 | 40.59 | 96.1 | 105.01 | 74.01 | 89.33 | 166 | 40.14 |  | 53 DIA, 40 PG, 98 QQQ, 59 SPY, 85 TQQQ, 115 UCO, 55 UDOW, 70 UMDD, 75 UPRO, 110 URTY, 122 VTWO
Spreadsheet: 1c03343c-e18d-459b-8449-6579dd5259de
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-07-12 09:44:31.820000
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 | 101.502 | 101.377 | 101.252 | 100.877
4.625 | 100.803 | 100.678 | 100.553 | 100.178 |  | Note: | Refer To Price [NAME]
4.5 | 100.289 | 100.164 | 100.039 | 99.664 |  |  | For all Price Adjs
4.375 | 99.68 | 99.555 | 99.43
 |  |  |  |  |  | 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.125 | 101.719 | 101.594 | 101.469 | 101.094
4 | 101.367 | 101.242 | 101.117 | 100.742
3.875 | 100.964 | 100.839 | 100.714 | 100.339
3.75 | 100.399 | 100.274 | 100.149 | 99.774
3.625 | 99.378 | 99.253 | 99.128
 |  |  |  |  |  | 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-07-26 09:44:31.820000
30 DAY | 2011-08-10 09:44:31.820000
45 DAY | 2011-08-25 09:44:31.820000
60 DAY | 2011-09-09 09:44:31.820000
90 DAY | 2011-10-09 09:44:31.820000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 583776d1532635975-index-match-for-sheet-name-in-another-workbook-md_de_dash-forum_help
Sheet: 054400-020

07/24/18
10:47 AM |  |  |  |  |  | 12 Month Actual
 |  |  |  |  |  | VA TFC
054400-020 |  |  |  |  |  | For the Month Ending June 30, 2018
 | July | August | September | October | November | December | January | February | March | April | May | June | Year to Date
Operating Income | 91607 | 111796 | 121678 | 123000 | 101597 | 107346 | 109353 | 101837 | 106283 | 91646 | 87431 | 89177 | 1242751
Personnel Expenses | 14969 | 14375 | 17677 | 17628 | 20915 | 18141 | 21147 | 19896 | 21748 | 22354 | 18586 | 18588 | 226024
Operating Expenses | 41892 | 50499 | 55097 | 56086 | 51427 | 50122 | 47966 | 50212 | 53082 | 44812 | 40501 | 41726 | 583422
Total Direct Expenses | 56861 | 64874 | 72774 | 73714 | 72342 | 68263 | 69113 | 70108 | 74830 | 67166 | 59087 | 60314 | 809446
 | - | - | - | - | - | - | - | - | - | - | - | - | -
Program Operating Margin | 34746 | 46922 | 48904 | 49286 | 29255 | 39083 | 40240 | 31729 | 31453 | 24480 | 28344 | 28863 | 433305
Program Operating % | 0.379294158743327 | 0.419710902000072 | 0.401913246437318 | 0.40069918699187 | 0.287951415888264 | 0.364084362714959 | 0.367982588497801 | 0.311566522972986 | 0.295936320954433 | 0.26711476769308 | 0.324187073234894 | 0.323659688036153 | 4.14410023416516
 | - | - | - | - | - | - | - | - | - | - | - | - | -
Overhead Expenses | 4554 | 2973 | 4516 | 4368 | 4772 | 4581 | 5510 | 5175 | 4530 | 5375 | 4011 | 4530 | 54895
Total Expenses | 61415 | 67847 | 77290 | 78082 | 77114 | 72844 | 74623 | 75283 | 79360 | 72541 | 63098 | 64844 | 864341
 | - | - | - | - | - | - | - | - | - | - | - | - | -
Income Over/Under Expenses | 30192 | 43949 | 44388 | 44918 | 24483 | 34502 | 34730 | 26554 | 26923 | 19105 | 24333 | 24333 | 378410
 | = | = | = | = | = | = | = | = | = | = | = | = | =
6020 Population | 20 | 22 | 25 | 25 | 21 | 22 | 21 | 21 | 21 | 19 | 18 | 0
Spreadsheet: 116436d1311836852-how-to-autopopulate-cells-based-on-values-from-other-cells-training-compilation2-1-
Sheet: List

Department | Competencies | Types of Training
MNSG | MNSG Project Management | Webinar
Planning | Manufacturing Systems and Operational Solutions | Internal
Scheduling | Supply Chain Management Systems and Support | External
CET | Performance Management
QCL | Learning and Development
QAO | Supply Planning and Inventory Control
LQA | Management of Supply Value Chain Stakeholder
CMTU | Production Scheduling
MFG | Inventory Control
SQA | Collaboration with Supply Stakeholders
 | Plant Utilitites Management
 | Building and Grounds Maintenance
 | Construction Project Management
 | In-house Disposal Operation
 | Hazardous Waste Management
 | Budget Monitoring and Control
 | Inventory Management
 | Document Management
 | Laboratory Testing and Evaluation
 | QCL Documentation and Records Management
 | Knowledge and Application of Good Manufacturing Practices (GMP) / Good Laboratory Practices
 | Inspection and Disposition
 | QAO Documentation and Records Management
 | Quality Management
 | Quality of Product Management
 | Quality Improvement
 | Document, Sample and Data Management
 | Technical Evaluation
 | CMTU Project Management
 | Technology Transfer and Consulting
 | Pharmaceutical Manufacturing Operation
 | Quality Fulfillment
 | Resource Management
 | Technical Solutions (TSU)
Spreadsheet: 790451d1659712341-using-lookup-to-find-the-1st-2nd-3rd-and-4th-value-test-2-how-to-return-nth-value-in-lookup
Sheet: Sheet2

ss | ss | ss | ss | ss | ss | ss | ss | Subject name | Price | ff | ff | ff | ff | ff | ff | ff | ff | ff | ff | School name
 |  |  |  |  |  |  |  | Maths | 50 |  |  |  |  |  |  |  |  |  |  | St Marys School
 |  |  |  |  |  |  |  | Maths | 50 |  |  |  |  |  |  |  |  |  |  | St Peters School
 |  |  |  |  |  |  |  | English | 15 |  |  |  |  |  |  |  |  |  |  | London Free School
 |  |  |  |  |  |  |  | Science | 100 |  |  |  |  |  |  |  |  |  |  | St Pauls Academy
 |  |  |  |  |  |  |  | Science | 25 |  |  |  |  |  |  |  |  |  |  | St Marys School
 |  |  |  |  |  |  |  | English | 75 |  |  |  |  |  |  |  |  |  |  | St Marys School
 |  |  |  |  |  |  |  | Maths | 25 |  |  |  |  |  |  |  |  |  |  | St Pauls Academy
 |  |  |  |  |  |  |  | Science | 15 |  |  |  |  |  |  |  |  |  |  | St Pauls Academy
 |  |  |  |  |  |  |  | English | 90 |  |  |  |  |  |  |  |  |  |  | St Pauls Academy
 |  |  |  |  |  |  |  | History | 75 |  |  |  |  |  |  |  |  |  |  | St Pauls Academy
Spreadsheet: 109118d1306045787-lookup-and-match-information-lookupmatch
Sheet: Sheet2

Number | [NAME] | [NAME] | [NAME] | [NAME] | Info 5
111036 | A
123465
465789
1324789
987654 |  | J
956423 |  |  |  |  | L
5798745
698432 |  | T
111036 |  |  | H
987654 |  |  |  | D
698432 |  |  |  |  | W
111036 |  | pp