tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 875293d1721880029-extract-ordinal-numbers-of-the-same-number-723
Sheet: Sheet1

 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 | 2 | 2 | 3 | 4 | 5 | 2 | 3 | 5 | 4 | 4
 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 6 | 2 | 4
 | 2 | 6 |  |  |  | 6
 | 4 | 7 |  |  | 4 | 7
 | 0 | 9 |  |  | 0 | 9
 | 2 | 7 |  |  | 2 | 7
Spreadsheet: 36641d1234514590-payroll-system-in-excel-payroll-calculator1
Sheet: Individual paystubs

 |  | [Company Name]
 |  | Period: | 2004-02-01 00:00:00 | Employee Name | [NAME] | Employee ID | 1
 |  | Tax Status | 1 | Federal Allowance (From W-4) | 4 | Hours Worked | 50
 |  | [NAME] | 10 | Overtime Rate | 0 | Sick Hours | 1
 |  | Social Security Tax | 35.28 | Federal Income Tax | 156.8 | Vacation Hours | 5
 |  | Medicare Tax | 8.120000000000001 | State Tax | 12.88 | Overtime Hours | 0
 |  | Insurance Deduction | 20 | Other Regular Deduction | 40 | Gross Pay | 560
 |  | Total Taxes and Regular Deductions | 273.08 | Other Deduction | 20 | Total Taxes and Deductions | 293.08
 |  |  |  |  |  | Net Pay | 266.92
 |  | [Company Name]
 |  | Period: | 2004-02-01 00:00:00 | Employee Name | 0 | Employee ID | 2
 |  | Tax Status | 0 | Federal Allowance (From W-4) | 0 | Hours Worked | 0
 |  | [NAME] | 0 | Overtime Rate | 0 | Sick Hours | 0
 |  | Social Security Tax | 0 | Federal Income Tax | 0 | Vacation Hours | 0
 |  | Medicare Tax | 0 | State Tax | 0 | Overtime Hours | 0
 |  | Insurance Deduction | 0 | Other Regular Deduction | 0 | Gross Pay | 0
 |  | Total Taxes and Regular Deductions | 0 | Other Deduction | 0 | Total Taxes and Deductions | 0
 |  |  |  |  |  | Net Pay | 0
 |  | [Company Name]
 |  | Period: | 2004-02-01 00:00:00 | Employee Name | 0 | Employee ID | 3
 |  | Tax Status | 0 | Federal Allowance (From W-4) | 0 | Hours Worked | 0
 |  | [NAME] | 0 | Overtime Rate | 0 | Sick Hours | 0
 |  | Social Security Tax | 0 | Federal Income Tax | 0 | Vacation Hours | 0
 |  | Medicare Tax | 0 | State Tax | 0 | Overtime Hours | 0
 |  | Insurance Deduction | 0 | Other Regular Deduction | 0 | Gross Pay | 0
 |  | Total Taxes and Regular Deductions | 0 | Other Deduction | 0 | Total Taxes and Deductions | 0
 |  |  |  |  |  | Net Pay | 0
 |  | [Company Name]
 |  | Period: | 2004-02-01 00:00:00 | Employee Name | 0 | Employee ID | 4
 |  | Tax Status | 0 | Federal Allowance (From W-4) | 0 | Hours Worked | 0
 |  | [NAME] | 0 | Overtime Rate | 0 | Sick Hours | 0
 |  | Social Security Tax | 0 | Federal Income Tax | 0 | Vacation Hours | 0
 |  | Medicare Tax | 0 | State Tax | 0 | Overtime Hours | 0
 |  | Insurance Deduction | 0 | Other Regular Deduction | 0 | Gross Pay | 0
 |  | Total Taxes and Regular Deductions | 0 | Other Deduction | 0 | Total Taxes and Deductions | 0
 |  |  |  |  |  | Net Pay | 0
Spreadsheet: 710268d1608816086-running-balance-need-to-shows-in-another-sheet-bili
Sheet: Summry

CONCRETE DELIVERY REPORT OCTOBER - 2014
SL.# | Name Customers | Amount
1 | Bilal
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
PREPARED BY:--------------------------------
 |  | LAST MONT RECEIVABLE
 |  | CURRENT DELIVERY
 |  | TOTAL AMOUNT
 |  | COLLECTIONS
 |  | RECEIVABLE
 |  | CURRENT RECEIVABLE
 |  | DIFFERENCE
Spreadsheet: 779585d1651871580-countif-open-or-filled-totals-count-model-2022-ag-test
Sheet: Model

Spots | Filled | Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 | Name 7 | Name 8 | Name 9 | Name 10
 | 1 | Micky | TBD | TBD | TBD | TBD
 | 0 | TBD
 | 1 | [NAME]
 | 4 | [NAME] | [NAME] | [NAME] | Humpty
 | 1 | June
 | 5 | [NAME] | Tyler | [NAME] | Erika | Bud | TBD | TBD
 | 1 | [NAME] | TBD
 | 0 | TBD
 | 7 | Goofy | [NAME] | Snoopy | [NAME] | [NAME] | TBD | [NAME] | Forest
Spreadsheet: sara_shackleton__36788__Summary of All Mercado Deals
Sheet: All Deals

SUMMARY MERCADO TRANSACTIONS FROM MAY '01
- CURVES AS OF 4/3/01 -
 |  |  |  |  |  | Daily |  | NYMEX | BASIS | INDEX | TOTAL
Deal # |  | BUYER |  | SELLER |  | Quantity |  | MTM | MTM | MTM | MTM |  | TERM REMAINING
NB6076.1 |  | ENA |  | MERCADO |  | 13000 |  | 13375722 | -443328 | 0 |  |  | May '01 - Aug '02
NB8744.1 |  | MERCADO |  | ENA |  | 13000 |  | -13621496 | 535493 | 0 |  |  | May '01 - Aug '02
NE2988.1 |  | ENA |  | MERCADO |  | 1000 |  | 265540 | -22240 | 609 |  |  | May '01 - Aug '01
[NAME] |  | ENA |  | MERCADO |  | 1000 |  | 74726 | -8800 | 154 |  |  | May '01
NF1164.1 |  | ENA |  | MERCADO |  | 10000 |  | 5549077 | -451830 | 0 |  |  | May '01 - Dec '01
NF1164.4 |  | ENA |  | MERCADO |  | 10000 |  | -60011 | 2641291 | 0 |  |  | Jan '02 - Aug '02
NF1164.7 |  | ENA |  | MERCADO |  | 10000 |  | -51783 | -162890 | 0 |  |  | May '01 - Dec '01
NF1164.B |  | ENA |  | MERCADO |  | 10000 |  | 214042 | -138811 | 0 |  |  | May '01 - Dec '01
NF1164.C |  | MERCADO |  | ENA |  | 10000 |  | -23101 | -17698 | 0 |  |  | May '01 - Dec '01
NF1164.D |  | MERCADO |  | ENA |  | 9000 |  | 0 | -94721 | 0 |  |  | May '01 - Oct '01
NF1164.E |  | MERCADO |  | ENA |  | 1000 |  | -33002 | -10525 | 0 |  |  | May '01 - Oct '01
NF1164.F |  | MERCADO |  | ENA |  | 1000, 2000 (Dec '01) |  | 32496 | 4710 | 0 |  |  | Nov '01 - Aug '02
NF1164.G |  | MERCADO |  | ENA |  | 10000 |  | -202250 | -336822 | 0 |  |  | May '01 - Nov '01
 |  |  |  |  |  | TOTAL
Spreadsheet: 161170d1339435357-excel-2007-problem-with-countif-and-sumif-non-continuous-cells-mjc-registro-interactivo
Sheet: TABSR

Volver [NAME] |  |  | TABULACIÓN DE CADA NOTA  Segundo R
N1 |  | % |  | N2 |  | % |  | N3 |  | % |  | N4 |  | % |  | N5 |  | % |  | [NAME] |  | %
100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90
89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80
79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70
69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60
59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0
TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
N7 |  | % |  | N8 |  | % |  | N9 |  | % |  | N10 |  | % |  | N11 |  | % |  | N12 |  | %
100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90
89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80
79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70
69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60
59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0
TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
N13 |  | % |  | [NAME] |  | % |  | N15 |  | % |  | N16 |  | % |  | N17 |  | % |  | N18 |  | %
100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90
89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80
79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70
69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60
59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0
TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
Spreadsheet: 796795d1663544800-calculate-pricing-according-to-selections-made-excel-help
Sheet: Pricing

 | Pricing
 | ONLY UPDATE ORANGE FIELDS
PIPE
 |  | [NAME] | ½ | ¾ | ⅜ | ⅝ | ⅞ | 1⅛ | 1⅜ | 1⅝ | 20mm Drain
Length |  | 16.42 | 32.01 | 67.86 | 24.02 | 50.37 | 96.97 | 161.36 | 228.6 | 320 | 10.3
 |  |  |  | ⅞ - 1⅛ | [NAME] | ⅜ - ⅝ | ¼ - ⅜ | ⅞ - ¾ | ¾ - ⅝ | 1⅛ -½ | ⅞ - ⅜ | ¾ - ⅜ | 1⅜ - 1⅛ | 1⅝ - 1⅜ | ⅜ - ⅝ - ½ | ⅜ - ¾ - ⅞ | ½ - 1⅛ - ¾ | ½ - 1⅛ - ⅞ | ⅝ - 1⅛ - 1⅛ | ¾  - 1⅜ - 1⅛ | ¾  - 1⅝ - 1⅜
Length
P/M
Price incl 19mm INSO
Price incl 25mm INSO
INSO
 |  | [NAME] | ½ | ¾ | ⅜ | ⅝ | ⅞ | 1⅛ | 1⅜ | 1⅝
19mm - Unit |  | 4.62 | 5.72 | 7.65 | 5.34 | 6.77 | 8.8 | 10.95 | 13.75 | 16.72
19mm - P/M
25mm - Unit |  | 8.57 | 8.2 | 11.55 | 7.87 | 10.62 | 11.55 | 13.92 | 17.38 | 21.01
25mm - P/M
Spreadsheet: 700024d1602906870-formula-to-extract-data-based-on-month-and-year-extract-profits
Sheet: BR1

BR1 | 2019-10-01 00:00:00 | Nov 2019 | Dec 2019 | Jan 2020 | Feb 2020 | Mar 2020 | Apr 2020 | May 2020 | Jun 2020 | Jul 2020 | Aug 2020 | Sep 2020
Net Profit Achieved Month-Dept1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Net Profit Achieved Month-Dept2 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Net Profit Achieved Month-Dept3 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Net Profit Achieved Month-Dept4 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 769154d1645354148-need-help-for-conditional-change-cash-forcast-summary
Sheet: SUMMARY

FROM |  |  |  | TO
 | CURRENT PAYPLAN | PAYPLAN |  | CHANGED TO PAYPLAN | PAYPLAN | NO OF CHANGE PAYPLAN
CONDITION NO 1 | CURRENT PAYPLAN>> | NETFLIX/MONTH |  | CHANGE TO NEW PAYPLAN>> | GOOGLE SERVER/MONTH | 1
CONDITION NO 2 | CURRENT PAYPLAN>> | GOOGLE SERVER/MONTH |  | CHANGE TO NEW PAYPLAN>> | GOOGLE SERVER/MONTH | 1
CONDITION NO 3 | CURRENT PAYPLAN>> | LOCALSERVER/1 MONTH |  | CHANGE TO NEW PAYPLAN>> | LOCALSERVER/1 MONTH | 1
 | CURRENT RESULT
Row Labels | Count of PLAN NAME | Sum of USAGE CHARGE |  | [NAME] FOR
JUNGLESIDE | 3 | 22000 |  | 1. IF I CHANGE PAYPLAN FROM "C" COLUMN TO "F") WITH NUMBER OF PAYPLAN NEED TO CHANGE IN COLUMN "G"THEN EFFECT NEED TO BE SEEN AT CURRENT  PIVOT TABLE
LOCALSERVER/1 MONTH | 1 | 2000 |  | 2. ALL THE  PAYPLAN ALONG WITH RATE IS MANTION IN PAYPLAN SHEETS.
YAHOOSERVER/3MONTH | 2 | 20000 |  | 3. I HAD KEEP BLANK COLUMN AT DATA SHEET ,SO THAT WILL BE EASY TO DUMP MY ACTUALLY DATA AFTER I GETTING HELP
RIVERSIDE | 2 | 3000 |  | 4. SORRY THAT AM UNABLE TO PROVIDE SAMPLE DATA,I AM BIT CONFUSE ON HOW TO SHOW SAMPLE DATA
GOOGLE SERVER/MONTH | 1 | 2000
NETFLIX/MONTH | 1 | 1000
ROADSIDE | 2 | 7000
DATA/3MONTH | 1 | 5000
LOCALSERVER/1 MONTH | 1 | 2000
(blank)
(blank)
Grand Total | 7 | 32000
Spreadsheet: darrell_schoolcraft__7779__imbalsumm0106
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -55217 | -49525
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -2753862 | -2693783
58710 | -97487 | -56854
60921 |  | 1899616
78026 |  | 84614
500084 | -10166 | -27000
500085 | -9881
500097
INDEX
2001-05-31 00:00:00 |  |  | 597578.71
2001-06-27 00:00:00
Spreadsheet: 731569d1620413700-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league-2
Sheet: Players

S.N. | Player Name | Rarity | fmdataba Score | Days to Contract End | Age | Position | Club | League | Country | Club Contract Ends | Starting 11? | D.O.B | Bought Price |  | Date | $USD Cost | Card/Bank | Today's Date
 | Owned
1 | [NAME] | Common | 88 |  |  | Forward | Real Madrid |  | Belgium | 2024-06-30 00:00:00 | Yes | 1991-01-07 00:00:00
23 | [NAME] | Super-Rare |  |  |  | Midfielder | Club Brugge |  | Belgium | 2023-06-30 00:00:00 |  | 2001-03-10 00:00:00
11 | Ivo Grbić | Common | 68 |  |  | Goalkeeper | Atlético de Madrid |  | Croatia | 2024-06-30 00:00:00 | Yes | 1996-01-18 00:00:00
3 | Koke | Common | 82 |  |  | Midfielder | Atlético de Madrid |  | Spain | 2024-06-30 00:00:00 | Yes | 1992-01-08 00:00:00
7 | [NAME] | Common | 74 |  |  | [NAME] | Real Madrid |  | Brazil | 2025-06-30 00:00:00 | No | 1998-01-18 00:00:00
16 | [NAME] | Rare | 79 |  |  | Midfielder | Real Madrid |  | Uruguay | 2025-06-30 00:00:00 |  | 1998-07-22 00:00:00
17 | [NAME] | Rare | 79 |  |  | Midfielder | Real Madrid |  | Uruguay | 2025-06-30 00:00:00 |  | 1998-07-22 00:00:00
6 | Luka Modrić | Common | 84 |  |  | Midfielder | Real Madrid |  | Croatia | 2021-06-30 00:00:00 | No | 1985-09-09 00:00:00
5 | [NAME] | Common | 86 |  |  | Goalkeeper | Real Madrid |  | Belgium | 2024-06-30 00:00:00 | Yes | 1992-05-11 00:00:00
9 | [NAME] | Common | 85 |  |  | Midfielder | Real Madrid |  | Germany | 2023-06-30 00:00:00 | Yes | 1990-01-04 00:00:00
13 | Vinícius Júnior | Rare | 73 |  |  | Forward | Real Madrid |  | Brazil | 2025-06-30 00:00:00 |  | 2000-07-12 00:00:00
8 | [NAME] | Common | 53 |  |  | [NAME] | Atlanta United |  | England | 2021-12-31 00:00:00 | No | 1997-02-08 00:00:00
2 | [NAME] | Common | 88 |  |  | Goalkeeper | Liverpool |  | Brazil | 2023-06-30 00:00:00 | Yes | 1992-10-02 00:00:00
12 | [NAME] | Common | 77 |  |  | Forward | Liverpool |  | Portugal | 2025-06-30 00:00:00 | Yes | 1996-12-04 00:00:00
10 | [NAME] | Common | 64 |  |  | [NAME] | Liverpool |  | Turkey | 2024-06-30 00:00:00 | Yes | 2000-03-25 00:00:00
14 | Alessandro Bastoni | Rare | 76 |  |  | [NAME] | Inter Milan |  | Italy | 2023-06-30 00:00:00 |  | 1999-04-13 00:00:00
15 | Matthijs de Ligt | Rare | 82 |  |  | [NAME] | Juventus |  | Netherlands | 2024-06-30 00:00:00 |  | 1999-08-12 00:00:00
21 | Alexis Soto | Rare | 63 |  |  | [NAME] | Racing Club |  | Argentina | 2022-06-30 00:00:00 |  | 1993-08-20 00:00:00
20 | [NAME] | Rare | 66 |  |  | [NAME] | Racing Club |  | Chile | 2022-06-30 00:00:00 |  | 1988-07-18 00:00:00
22 | [NAME] | Rare | 55 |  |  | Goalkeeper | Racing Club |  | Argentina | 2022-06-30 00:00:00 |  | 1996-03-04 00:00:00
19 | [NAME] | Rare | 55 |  |  | Midfielder | Racing Club |  | Argentina | 2024-06-30 00:00:00 |  | 1999-07-01 00:00:00
4 | [NAME] | Common | 59 |  |  | Forward | Racing Club |  | Argentina | 2023-12-31 00:00:00 | No | 1999-01-01 00:00:00
18 | [NAME] | Rare | 59 |  |  | Forward | Racing Club |  | Argentina | 2023-12-31 00:00:00 |  | 1999-01-01 00:00:00
24
25
26
27
28
29
30
31
32
33
Spreadsheet: 768463d1644980272-minimum-average-percentage-needed-to-meet-month-end-expectation-with-range-constraints-example
Sheet: Sheet1

Agent: | Donner
Report Period: | 01/01/2022-01/31/2022
MTD QA Average
# of Calls pulled
QA Scores |  |  | Average needed to pass
#1
#2
#3
#4
#5
#6
#7
#8
#9
#10
Spreadsheet: 809747d1671278258-data-cleansing-query-compare-lookup-return-standard-value-1395843
Sheet: Sheet1

 | Current Data Example | DESIRED Result |  | RETURN THIS | For ANY of These |  |  |  |  |  |  | Current Data Example | Desired Result
 | [NAME] | Floor 01 |  | Floor 01 | [NAME] | Flr 1 | [NAME] | Flr One | 1 | 1 |  | [NAME]
 | Flr 1 | Floor 01 |  |  |  |  |  |  |  |  |  | Flr 1
 | [NAME] | Floor 01 |  |  |  |  |  |  |  |  |  | [NAME]
 | Flr One | Floor 01 |  |  |  |  |  |  |  |  |  | Flr One
 | [NAME] | Floor 01 |  | CurrentData | UseData |  |  |  |  |  |  | [NAME]
 | [NAME] | Floor 01 |  | 1 | Floor 01 |  |  |  |  |  |  | [NAME]
 | [NAME] | Floor 01 |  | [NAME] | Floor 01 |  |  |  |  |  |  | [NAME]
 | 1 | Floor 01 |  | [NAME] | Floor 01 |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  | Flr 1 | Floor 01 |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  | Flr One | Floor 01 |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  |  |  |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  |  |  |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  |  |  |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 218066d1362329126-help-how-to-display-passport-and-visa-almost-expired-dates-to-another-sheet-sample-1-ver2
Sheet: Program

EMPLOYEE'S VISA & PASSPORT NEAR EXPIRY LIST
SR. No. | EMP. ID | Name of EMP. | Nationality | Passport No. | [NAME] | Salary | Sponsor | Designation | Joining Date | Joining Date | [NAME]
Spreadsheet: 763206d1642050432-count-formula-based-on-date-asking-formula
Sheet: Asking formula

Date | Count
2022-01-12 00:00:00 | 7868
2022-01-12 00:00:00 | 7867
2022-01-12 00:00:00 | 7866
2022-01-11 00:00:00 | 7865
2022-01-11 00:00:00 | 7864
2022-01-11 00:00:00 | 7863
2022-01-11 00:00:00 | 7862
2022-01-11 00:00:00 | 7861
2022-01-11 00:00:00 | 7860
2022-01-11 00:00:00 | 7859
2022-01-11 00:00:00 | 7858
2022-01-11 00:00:00 | 7857
2022-01-11 00:00:00 | 7856
2022-01-10 00:00:00 | 7855
2022-01-10 00:00:00 | 7854
2022-01-10 00:00:00 | 7853
2022-01-10 00:00:00 | 7852
2022-01-10 00:00:00 | 7851
2022-01-10 00:00:00 | 7850
2022-01-10 00:00:00 | 7849
2022-01-10 00:00:00 | 7848
2022-01-10 00:00:00 | 7847
2022-01-10 00:00:00 | 7846
2022-01-10 00:00:00 | 7845
2022-01-09 00:00:00 | 7844
2022-01-09 00:00:00 | 7843
2022-01-09 00:00:00 | 7842
2022-01-09 00:00:00 | 7841
2022-01-09 00:00:00 | 7840
2022-01-09 00:00:00 | 7839
2022-01-09 00:00:00 | 7838
2022-01-09 00:00:00 | 7837
2022-01-09 00:00:00 | 7836
2022-01-09 00:00:00 | 7835
2022-01-09 00:00:00 | 7834
2022-01-08 00:00:00 | 7833
2022-01-08 00:00:00 | 7832
2022-01-08 00:00:00 | 7831
2022-01-08 00:00:00 | 7830
2022-01-08 00:00:00 | 7829
2022-01-08 00:00:00 | 7828
2022-01-08 00:00:00 | 7827
2022-01-08 00:00:00 | 7826
2022-01-08 00:00:00 | 7825
2022-01-08 00:00:00 | 7824
2022-01-08 00:00:00 | 7823
2022-01-08 00:00:00 | 7822
2022-01-07 00:00:00 | 7821
2022-01-07 00:00:00 | 7820
2022-01-07 00:00:00 | 7819
2022-01-07 00:00:00 | 7818
2022-01-07 00:00:00 | 7817
2022-01-07 00:00:00 | 7816
2022-01-07 00:00:00 | 7815
2022-01-07 00:00:00 | 7814
Spreadsheet: 847559d1698419558-power-pivot-not-displaying-intended-result-efh2
Sheet: Sales

 | Product ID | Sales
 | 320 | Client 2
 | 950 | Client 6
 | 950 | Client 7
 | 950 | Client 1
 | 1010 | Client 3
 | 1010 | Client 7
 | 1160 | Client 3
 | 1160 | Client 9
 | 1160 | Client 1
 | 1220 | Client 3
 | 1220 | Client 2
 | 1850 | Client 8
 | 2550 | Client 5
 | 3340 | Client 3
 | 3340 | Client 6
 | 3490 | Client 10
 | 3560 | Client 3
 | 3560 | Client 7
 | 3780 | Client 8
 | 3780 | Client 2
 | 3980 | Client 9
 | 3980 | Client 1
 | 4150 | Client 2
 | 5670 | Client 2
 | 5670 | Client 7
 | 6740 | Client 8
 | 6760 | Client 4
 | 6760 | Client 5
 | 7770 | Client 8
 | 7770 | Client 7
 | 7770 | Client 1
 | 8030 | Client 1
 | 8030 | Client 5
 | 8030 | Client 7
 | 8500 | Client 9
 | 8500 | Client 2
 | 8730 | Client 3
 | 8770 | Client 7
 | 9210 | Client 8
 | 9210 | Client 3
 | 9220 | Client 5
 | 9220 | Client 2
 | 9220 | Client 6
Spreadsheet: 441205d1453150028-how-do-i-calculate-lead-time-between-two-dates-during-working-hours-and-exclude-weekends-lead-time-formula
Sheet: Lead Time Formula

Open Date | Close Date | FORMULA 1 Lead Time (Working Hours including weekends) | FORMULA 2 Lead Time (Working days and Working Hours) | Holidays | Difference | Working Days
2015-06-04 08:23:02 | 2015-08-06 14:33:38
2015-06-04 10:57:33 | 2015-10-23 09:09:28
2015-06-03 00:19:34 | 2015-06-03 00:30:46
2015-06-18 02:17:21 | 2015-06-18 02:20:46
2015-07-10 15:13:01 | 2015-07-15 14:34:59 |  |  |  | 3:39:41
2015-06-12 14:23:54 | 2015-08-12 09:27:31
2015-09-09 11:15:21 | 2015-10-02 16:33:12
2015-07-17 11:05:24 | 2015-08-10 11:28:14
2015-10-23 00:26:43 | 2015-10-23 00:32:31
2015-07-17 17:11:31 | 2015-09-17 10:16:58
2015-08-19 08:25:25 | 2015-09-10 18:21:49
2015-07-28 16:58:07 | 2015-09-28 11:23:10
2015-08-06 17:46:51 | 2015-10-05 17:24:28
2015-08-07 17:41:51 | 2015-10-06 08:18:25
2015-11-02 11:09:14 | 2015-11-23 10:12:16
2015-10-29 20:05:50 | 2015-11-17 11:02:54
2015-10-22 03:44:23 | 2015-10-22 03:49:55
2015-10-25 04:22:26 | 2015-10-25 04:27:10
2015-08-10 05:00:15 | 2015-08-10 05:03:50
2015-08-02 05:04:44 | 2015-08-02 05:09:29
2015-10-11 15:57:26 | 2015-10-11 16:13:42
2015-10-20 09:33:59 | 2015-10-21 20:17:22
2015-08-28 16:43:55 | 2015-11-04 17:16:09
2015-11-04 11:28:13 | 2015-11-09 10:51:52 |  |  |  | 1 day, 0:50:02
2015-08-03 10:36:12 | 2015-09-03 10:58:42
2015-10-15 11:47:49 | 2015-11-10 10:48:04
2015-06-17 10:34:51 | 2015-06-17 20:40:51
2015-08-27 20:56:32 | 2015-08-27 21:58:25
2015-10-18 08:16:42 | 2015-10-18 08:59:30 |  |  |  | 0:42:48
2015-11-09 18:18:30 | 2015-11-17 20:47:31
2015-06-12 11:38:36 | 2015-06-29 19:29:07
2015-10-08 14:40:46 | 2015-10-29 15:43:06
2015-07-10 21:57:58 | 2015-07-10 22:53:31
2015-11-03 11:33:44 | 2015-11-27 15:46:08
2015-09-08 02:10:03 | 2015-09-08 02:55:29
2015-07-10 18:16:51 | 2015-08-05 09:49:15
2015-11-03 15:11:32 | 2015-11-27 15:51:33
2015-11-10 15:18:06 | 2015-12-02 14:03:12
2015-06-22 14:33:06 | 2015-07-13 14:43:21
2015-10-13 13:46:56 | 2015-11-02 17:37:07
2015-08-14 08:25:34 | 2015-09-07 14:01:54
2015-07-17 18:55:14 | 2015-07-17 20:06:17
2015-08-20 21:39:59 | 2015-08-20 21:41:48
Spreadsheet: 9d5bd741-fd29-4029-91f1-08a43445f85c
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: |  |  | 2013-09-26 09:22:30.900000
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.75 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.625 | 102.059 | 101.934 | 101.809 | 101.434
4.5 | 101.594 | 101.469 | 101.344 | 100.969 |  | Note: | Refer To Price [NAME]
4.375 | 100.764 | 100.639 | 100.514 | 100.139 |  |  | For all Price Adjs
4.25 | 100.254 | 100.129 | 100.004 | 99.379
4.125 | 99.512 | 99.387 | 99.262 | 98.637
4 | 98.593 | 98.468 | 98.343 | 97.718
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.125 | 102 | 101.875 | 101.5
3.75 | 101.951 | 101.826 | 101.701 | 101.326
3.625 | 101.56 | 101.435 | 101.31 | 100.935
3.5 | 101.055 | 100.93 | 100.805 | 100.43
3.375 | 100.352 | 100.227 | 100.102 | 99.477
3.25 | 99.609 | 99.484 | 99.359 | 98.734
3.125 | 98.819 | 98.694 | 98.569 | 97.944 |  | 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 | 2013-10-10 09:22:30.900000
30 DAY | 2013-10-25 09:22:30.900000
45 DAY | 2013-11-09 09:22:30.900000
60 DAY | 2013-11-24 09:22:30.900000
90 DAY | 2013-12-24 09:22:30.900000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.