tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 754275d1636050009-count-of-unique-values-based-on-two-criteria-count-unique-values
Sheet: Sheet1

Product ID | Description | Category | [NAME] |  |  |  | # of Product IDs | # of [NAME]
NEX-01-0006 | TV | NexTel | 02-A-01-A-01 |  |  | Bouncy Ball |  |  |  | 04-A-12-B-03
NEX-01-0010 | Baskets-3 Piece Set | NexTel | 02-A-01-A-07 |  |  | Coddle Beans |  |  |  | 04-C-04-A-04
NEX-01-0003 | Folio Travel & Tech Organizer (Bundle of 25) | NexTel | 02-A-01-B-06 |  |  | Diamott Corp
NEX-01-0058 | Thank You Black/Purple Sock-M | NexTel | 02-A-01-B-07 |  |  | Gala Fancy
NEX-01-0004 | 3x3 Pop-up Banner | NexTel | 02-A-01-C-01 |  |  | Imagination Corp |  |  |  | 04-C-04-A-04
NEX-01-0007 | [NAME] | NexTel | 02-A-01-C-01 |  |  | NexTel |  |  |  | 02-A-01-A-07 | 02-A-01-B-06 | 02-A-01-B-07 | 02-A-01-C-01 | 02-A-01-C-06
NEX-01-0059 | Thank You Black/Purple Sock-L | NexTel | 02-A-01-C-06 |  |  | Pinkbook |  |  |  | 04-A-12-C-03 | 0
DCFA-01-0017 | Grey DCFA Vintage Tee - XX-Large | Diamott Corp | 03-C-12-C-01
PNKB-01-1741 | Pinkbook Snake T-Shirt - Large / Black | Pinkbook | 03-C-12-C-01
BB-193181201-7 | The Beantown Series Hat, Fitted - Size 7 | Bouncy Ball | 04-A-12-C-03
pnkb-Needs fix | Pinkbook Corporate [NAME] | Pinkbook | 04-A-12-C-03
BB-193181201-718 | The Beantown Series Hat, Fitted - Size 7 1/8 | Bouncy Ball | 04-A-12-B-03
CODL-01-0083 | Safety Yellow Long Sleeve Tee - Medium | Coddle Beans | 04-C-04-A-01
IC-01-0001 | The Camper Hat | Imagination Corp | 04-C-04-A-03
PNKB-01-1694 | Women's Arch Tank - X-Large / Dusty Rose | Pinkbook
PNKB-01-1695 | Women's Arch Tank - 2X-Large / Dusty Rose | Pinkbook
CODL-01-0084 | Safety Yellow Long Sleeve Tee - Large | Coddle Beans | 04-C-04-A-04
GF-01-0076 | Dress Shirt-Grey - Small | Gala Fancy
IC-01-0002 | T-Shirt - Small | Imagination Corp | 04-C-04-A-04
Spreadsheet: 784714d1655917212-count-cells-with-text-it-needs-data-test
Sheet: Metadata

Week | System | Sites
All Weeks | All Systems | All Sites | Yes
 |  |  | No
2021-11-29 00:00:00 | MFA Setup | PBS-F
2021-12-13 00:00:00 | System 1 | PBS-C
 | System 2 | PBS-K
 | System 3 | SO
 | System 4 | 0
 | System 5
 | System 6
 | System 7
 | System 8
 | System 9
 | System 10
 | System 11
 | Other IT Issues
 | Non IT Issues
 | No Issues
Spreadsheet: 41948d1240493131-convert-object-value-to-cell-value-using-macro-sample-1
Sheet: 08-LT-0111-0112

 | OPRNS
 | PMT
 | CERT
 | ENGG
 | [NAME]
 | JO/EWO
 | DATE
 | CERTIFIED
 | OPERATIONS
 |  |  |  |  |  | My requirememt
 |  |  |  |  | S.No | Instrument [NAME] name | SERVICE | Type | P & ID NUMBER | MANUFACTURER | Similarly other field names identified in yellow color as the column header
 |  |  |  |  | 1 | 08-LT-0111 | K43-D-0133 | INTERFACE | RA-565832.001 | YOKOGAWA | corresponding values in  respective rows
 |  |  |  |  | 2 | 08-LT-0112 | K43-D-0133 | INTERFACE | RA-565832.001 | YOKOGAWA | One more criteria is that in any way the check box input shall also be captures.
Spreadsheet: louise_kitchen__23080__ena
Sheet: Power-East

Trading
Acevedo, [NAME] |  | Sr. Spec
[NAME], [NAME] |  | Sr. Spec
[NAME], [NAME] |  | VP
[NAME], [NAME] |  | Dir
Ballato, [NAME] |  | Analyst
[NAME], [NAME] |  | Sr. Spec
Baughman, [NAME] | Hourly | Manager
Benchluch, Moises |  | Associate
Benson, [NAME] |  | Dir
Broderick, [NAME] |  | Manager
[NAME], [NAME] |  | Manager
[NAME], [NAME]
[NAME], [NAME] |  | Manager
[NAME] | Trading | [NAME]
Cline, [NAME] |  | Sr. Spec
Comeaux, [NAME] |  | Manager
[NAME], [NAME] | Northeast Trading | VP
[NAME] | Marketing | [NAME]
Forney, [NAME] |  | Dir
[NAME], [NAME] |  | Staff
[NAME], [NAME] |  | Dir
Giron, Gustavo |  | Associate
Gualy, Jaime |  | Associate
[NAME], Gautum |  | Manager
Imai, Rika |  | Manager
Kaniss, [NAME] |  | Analyst
King, [NAME] |  | Manager
[NAME], [NAME] | Hourly | Analyst
[NAME] | admin | [NAME]
Lowell, [NAME] |  | Analyst
Makkai, [NAME] |  | Analyst
Marquez, Maurico |  | Associate
Matthews, [NAME] |  | Associate
May, [NAME] |  | Manager
Misra, Narsimha |  | Manager
Padron, [NAME] |  | Analyst
Presto, [NAME] | East Power Trading | VP
Rogers, [NAME] |  | Associate
Rust, [NAME] |  | Manager
[NAME], [NAME] |  | Manager
Saibi, [NAME] |  | Analyst
Santucci, [NAME] |  | Sr. Spec
Schiavon, [NAME] |  | Associate
[NAME], [NAME] |  | Associate
Seely, [NAME] |  | Associate
Serio, [NAME] |  | Manager
Stalford, [NAME] |  | Manager
Sturm, [NAME] | Midwest Trading | VP
[NAME], [NAME] |  | Dir
Symms, [NAME] |  | Sr. Spec
Taek Oh, [NAME] |  | Associate
[NAME], [NAME] |  | Associate
[NAME] | Marketing | [NAME]
[NAME] | Marketing | [NAME]
TJ Black | Trading | [NAME]
[NAME], [NAME] |  | Analyst
Wagner, [NAME] |  | Associate
Wang, [NAME] |  | Manager
[NAME], [NAME] |  | Analyst
[NAME], [NAME]
Reyes, [NAME] |  | [NAME]
Abler, [NAME]
Aucoin, [NAME] | Power Origination | Dir
[NAME], Terrell | Power Origination | Associate
Braddock, [NAME] | Power Origination | Associate
Cross, [NAME] | Power Origination | Manager
[NAME], [NAME] | Power Origination | Dir
[NAME], [NAME] | Power Origination | Dir
Forster, [NAME] | Power Origination | Dir
Furrow, Dale | Power Origination | VP
Herrera, [NAME] | Power Origination | VP
Hiemstra, Nick | Power Origination | Sr. Spec
[NAME], [NAME] | Power Origination | Dir
Jafry, [NAME] | Power Origination | Dir
Jones, [NAME] | Power Origination | Dir
[NAME], [NAME] | Power Origination | Dir
[NAME], Greg | Power Origination | Manager
Meyn, [NAME] | Power Origination | Dir
Mitro, Fred | Power Origination | Dir
Munoz, Victor | Power Origination | Manager
Pacheco, [NAME] | Power Origination | Manager
Pan, Liqun | Power Origination | Manager
[NAME], [NAME] | Power Origination | Dir
Rorshock, [NAME] | Power Origination | Associate
Simoes, Catherine | Power Origination | Manager
Trefz, Greg | Power Origination | Sr. Spec
[NAME], [NAME] | Power Origination | Manager
Wood, George | Power Origination | Manager
Spreadsheet: 841319d1693500988-search-and-result-excel-search-1-
Sheet: Blad1

MM |  | MM | Custom
147 |  | 147 | Policy - ISMS
149, 150 |  | 149, 150 | Overview - Interested Parties Overview - Contracts Interested Parties
147 |  | 147 | Policy - ISMS
139 |  | 139 | Compliance Tool - De Compliance Afdeling
1, 52, 56, 57, 58, 99 |  | 1, 52, 56, 57, 58, 99 | Code of Conduct By laws - Compliance Committee  Tone for the Top Intranet - Corporate Coverance Communication message - new(update) policy Overview - Corporate Governance
8, 57, 99, 137, 147 |  | 8, 57, 99, 137, 147 | Guideline - Information Protection Intranet - Corporate Coverance Overview - Corporate Governance Compliance Committee - Mitigating Measures Policy - ISMS
1, 54, 55 |  | 1, 54, 55 | Code of Conduct Organization chart Job description
134, 145 |  | 134, 145 | Minutes - Compliance Committee Compliance Annual Report
4, 5, 135, 136 |  | 4, 5, 135, 136 | Guideline - Risk Strategy Guideline - Risk Management Risk Profile Risk Analysis
93, 137, 138 |  | 93, 137, 138 | Overview - Mitigating Measures Compliance Committee - Mitigating Measures The statement of applicability (SoA)
52, 145 |  | 52, 145 | By laws - Compliance Committee  Compliance Annual Report
20 |  | 20 | Guideline - Governance Standards
145 |  | 145 | Compliance Annual Report
43, 55, 112 |  | 43, 55, 112 | Work Instruction - pre-employment Job description Training - Compliance Onboarding
56, 57, 58 |  | 56, 57, 58 | Tone for the Top Intranet - Corporate Coverance Communication message - new(update) policy
12 |  | 12 | Guideline - Communication
20, 57, 99 |  | 20, 57, 99 | Guideline - Governance Standards Intranet - Corporate Coverance Overview - Corporate Governance
15, 137 |  | 15, 137 | Guideline - Corporate Rules Compliance Committee - Mitigating Measures
57, 99 |  | 57, 99 | Intranet - Corporate Coverance Overview - Corporate Governance
139 |  | 139 | Compliance Tool - De Compliance Afdeling
136 |  | 136 | Risk Analysis
93 |  | 93 | Overview - Mitigating Measures
2, 52, 94, 145 |  | 2, 52, 94, 145 | Policy - Compliance By laws - Compliance Committee  Overview - Sample Checks Compliance Annual Report
140 |  | 140 | Internal Audit
141 |  | 141 | Planning - Internal Audit
52 |  | 52 | By laws - Compliance Committee
93, 136, 140, 145 |  | 93, 136, 140, 145 | Overview - Mitigating Measures Risk Analysis Internal Audit Compliance Annual Report
134, 145 |  | 134, 145 | Minutes - Compliance Committee Compliance Annual Report
139 |  | 139 | Compliance Tool - De Compliance Afdeling
8, 29, 50, 62 |  | 8, 29, 50, 62 | Guideline - Information Protection Instruction - Compliance Consultation and Notification Work Instruction - incident handling Incident notifications (orally/telephone/email/push notifications)
Spreadsheet: 2465bf03-ec38-4ebf-b8ad-1dc80b0c6ed1
Sheet: Sheet1

Meet Name: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | #3 | Unnamed: 7 | Unnamed: 8 | Pre District | District | City
Meet Date: | 2014-05-31 00:00:00 | 2014-06-07 00:00:00 | 2014-06-14 00:00:00 | 2014-06-21 00:00:00 | 2014-06-28 00:00:00 | 2014-07-05 00:00:00 | 2014-07-05 00:00:00 | 2014-07-12 00:00:00 | 2014-07-19 00:00:00 | 2014-07-26 00:00:00 | 2014-08-02 00:00:00
Corrales (COR) | [NAME] WMAC. Clinics will be focused on coaching and swimming.      9am- 11am. |  | RGZoo | SVW | RGZoo | MONT |  | SAN | SVW | WMAC | WMAC
[NAME] (EST) |  |  | EIS | VAL | WIL | LAP |  | MONT | LAP | WMAC | WMAC
Eisenhower (EIS) |  |  | WMAC | HIGH | EIS | MONT |  | HIGH | LAP | WMAC | WMAC
Wilson(WIL) |  |  | EIS | VAL | WIL | LAP |  | HIGH | VAL | WMAC | WMAC
Los Altos (LAP) |  |  | WMAC | LAP | SAN | SVW |  | MONT | VAL | WMAC | WMAC
Los Padillas (LPAD) |  |  | SAN | MONT | SAN | MONT |  | HIGH | WIL | WMAC | WMAC
Montgomery (MONT) |  |  | RGZoo | LAP | EIS | MONT |  | EIS | LAP | WMAC | WMAC
Paradise Hills (PH) |  |  | EIS | LAP | Wil | SVW |  | SAN | MONT | WMAC | WMAC
Rio Grande High School (RGHS) |  |  | EIS | SVW | SAN | SVW |  | EIS | WIL | WMAC | WMAC
Rio Grande Zoo (RGZoo) |  |  | RGZoo | VAL | EIS | VAL |  | EIS | WIL | WMAC | WMAC
Rio Rancho (RR) |  |  | WMAC | MONT | SVW | LAP |  | EIS | MONT | WMAC | WMAC
Sierra Vista West (SVW) |  |  | WMAC | SVW | RGZoo | VAL |  | SVW | SVW | WMAC | WMAC
South Valley (SV) |  |  | WMAC | HIGH | RGZoo | SVW |  | HIGH | SVW | WMAC | WMAC
Sunport (SUN) |  |  | RGZoo | MONT | EIS | LAP |  | SAN | MONT | WMAC | WMAC
Valley (VAL) |  |  | EIS | VAL | SVW | VAL |  | SVW | VAL | WMAC | WMAC
West Mesa (WMAC) |  |  | SAN | HIGH | SVW | VAL |  | SVW | SVW | WMAC | WMAC
All swim meet  warm up starts @ 8 AM to 9AM.
This schedule is subject to change so please verify specific meet locations with your coaches before each meet.
For questions about this schedule or the Metro Aquatic League, please contact [NAME] at [PHONE] or [EMAIL]
If you do not swim at the District Meet on July 26th, you cannot swim at City except for relays.  There are NO Exceptions to this rule.  District is the ONLY qualifying Meet
Spreadsheet: 91340d1291103450-calculation-field-in-pivot-table-pivot-q
Sheet: data

Employee | Questions | Answers
Name1 | 5 | 5
[NAME] | 4 | 3
Name3 | 5 | 4
Name4 | 4 | 3
Name5 | 5 | 4
Name6 | 5 | 5
Name7 | 3 | 3
Name8 | 5 | 4
Name9 | 5 | 4
Name10 | 5 | 3
Name11 | 4 | 1
Spreadsheet: 778272d1650968062-allocating-where-the-total-available-is-less-than-the-total-needed-allocation-by-ranking-with-under-supply
Sheet: Sheet1 (2)

RANK ALLOCATION
1 | 0.8
2 | 0.5
3 | 0.2
ORDER |  |  |  |  |  |  |  |  |  | ALLOCATION
 | CUST RANK |  | 1 | 3 | 2 | 2 | 3 | 1
AVAIL STOCK | CUST TOTAL | Minimum | CUST1 | CUST2 | CUST3 | CUST4 | CUST5 | CUST6 |  |  |  |  |  |  |  |  |  |  | TOTAL ALLOCATION | STOCK REMAINING
20 |  |  | 10 | 5 | 2 | 10 | 5 | 1
80 |  |  | 20 | 10 | 5 | 20 | 10 | 2
50 |  |  | 20 | 10 | 5 | 20 | 20 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | should be modify
35 |  |  | 10 | 5 | 2 | 20 | 10 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | should be modify
10 |  |  | 10 | 5 | 2 | 10 | 5 | 1
Spreadsheet: 97703d1296815296-sumproduct-generating-value-error-book1
Sheet: DATA

Data Item | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00
CARP | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TUNA | 10 | 245 | 6 | 4 | 54 | 0 | 0 | 2
PERCH | 50 | 0 | 0 | 0 | 221 | 5 | 5 | 22
BASS | 52 | 0 | 202 | 0 | 0 | 5 | 0 | 22
TROUT | 545 | 14 | 0 | 33 | 44 | 5 | 0 | 55
Spreadsheet: 01e4d396-2c49-4fd3-bac1-3374ad92b16e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Table 2.1.3 – Share of export activated by companies involved in foreign trade in the Veneto per export category - 2004:2006(*)
 |  | 2004 | 2005 | 2006
 | 0 - 0.1m | 0.9968985737705207 | 0.8738806174317564 | 0.8153935062230573
 | 0.1m - 1m | 5.416941090403794 | 5.285982976047938 | 4.7464648210682
 | 1m - 5m | 16.22002299888844 | 15.49766849619432 | 14.24410213752305
 | 5m - 20m | 25.66575643431076 | 25.83830884115386 | 25.10774643064809
 | 20m - 100m | 30.02839603928096 | 29.96079619834265 | 30.72944367196755
 | more than 100 million euro | 21.67198486334552 | 22.54336287082948 | 24.35684943257005
 | (*) provisional data.
 | Source: processing by [NAME] SISTAR on Istat data
Spreadsheet: 1cb2bf8b-59e7-4c42-aacf-01cc04d77574
Sheet: FC Financial Commitment

Financial Commitment | is the effective and responsible management of income and expenses by individual members, Chapters, and the International Fraternity.  Financial commitment provides the means for all fraternal operations, programs, and services as well as realistic fiscal training for members.  ~Doctrine of Excellence
 |  | Tier 1 | Tier 2 Points | Tier 3 Points | Documentation Requirements |  |  |  |  |  | Points
Item No. | Performance Area | Foundational Elements |  |  | CA Verif. | GA/UO Verif. | IFC [NAME]. | Written Descript. | HQ [NAME]. | Other | [NAME]. | Bonus | Reporting Time(s) | Tools | Remarks
FC1 | Chapter Financial Commitments | All invoices are paid no worse than Net 60 and Chapter has zero ($0) balance with International Headquarters and all other creditors at June 15th. | Chapter pays all bills within 30 days of invoice: ·         Insurance due November 1 ·         Undergraduate Fee due November 1 ·         Chapter Assessment due February 15 ·         Grand Chapter Assessment due February 15 ·         NM Fees online within 2 wks of bid acceptance ·         Initiation Fees due  2 weeks prior to initiation. |  |  |  |  |  | X |  | 1 |  | Fall/Spring
FC2 | Personal Financial Commitments | Chapter has a written policy/process in bylaws to address delinquent payments by members. | Chapter has an Accounts Receivable (among its members) less than 5% of total amt. owed as of May 1st. | Chapter uses a 3rd party financial mgt. service (i.e. [NAME], Greek Bill, [NAME] or a CPA firm) |  |  |  | X | X | Tier 1: Copy of Bylaws and reference to location of policy [NAME]:monthly statements (using templates) Tier 3:documentation indicating Chapter uses a 3rd Party Financial Service. | 1 | 1 | Spring
FC3 | Financial Planning & Management | Chapter submits a budget at the beginning of each academic term | Chapter tracks all income/expenses against budget and maintains total expenses within budgeted amount and increases reserve account by $25/member per year. Chapter evaluates lessons learned and submits an annual report. | Chapter creates/maintains a long-term capital/housing fund with minimum $25/member contribution per year. |  |  |  |  | X | Tier 1: Budget submitted Tier 2: Chapter provides budget vs. actuals report with a written analyis of same monthly statements (using templates), proof of increase to reserve at $25 /man Tier 3: evidence of $25/man capital/housing fund being maintained | 1 | 1 | Fall/Spring | [NAME]
FC4 | Financial Reporting | Chapter submits income statements and balance sheets on a monthly basis | Chapter tracks budget and income/expenses using spreadsheets or other software (i.e. [NAME]). |  |  |  |  |  | X | Monthly statements (using templates) | 1 |  | Fall/Spring | [NAME]
FC5 | Regulatory Compliance | Chapter completes & submits IRS Form 990 if required. |  |  |  |  |  |  | X | Copy of Form 990 |  |  | Fall | Web link; comments/ guidance on rules
Notes:
1. | All Foundational Elements in all Categories must be met to be eligible for points (in all Categories.)
Spreadsheet: 118551d1313755805-re-extracting-data-from-multiple-sheets-rows-opennumbers
Sheet: Data1

Example 1 |  |  |  |  |  |  | key
1 | Open |  |  |  |  |  | 1
2 | Open |  |  |  |  |  | 2
3 | Closed |  |  |  |  |  | 2
4 | Open |  |  |  |  |  | 3
5 | Closed |  |  |  |  |  | 3
6 | Closed |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 3
Spreadsheet: 870242d1716796786-add-a-row-before-a-group-of-values-book1-gk-v2-1-
Sheet: Sheet2

 |  |  |  |  | 6 | This is the output of customized formula provided by @GK |  |  |  |  |  |  |  |  | Add Empty Row before |  | x | y | If this output is achieved, then row will be added as required
 | Region | Employee | Product |  |  | EMP Sub Total (Region-1) | 6 | 0.3333333333333333 | 0.5 | 0 | 0.1666666666666667 | 0 | 0 |  |  | Region-1 | 0 |  | 0.8
 | Region-1 | EMP-1 | PRO-1 |  | 10.5 | EMP Sub Total (Region-2) | 4 | 0 | 0.5 | 0.5 | 0 | 0 | 0 |  | 7 | [NAME] |  |  | 6.8
 | Region-1 | EMP-2 | PRO-2 |  | 14.5 | EMP Sub Total (Region-3) | 4 | 0 | 0.5 | 0.5 | 0 | 0 | 0 |  | 11 | Region-3 |  |  | 10.8
 | Region-1 | EMP-3 | PRO-4 |  | 18.5 | EMP Sub Total (Region-4) | 4 | 0.25 | 0.25 | 0.5 | 0 | 0 | 0 |  | 15 | Region-4 |  |  | 14.8
 | Region-1 | EMP-4 | PRO-2 |  | 21.5 | EMP Sub Total (Region-5) | 3 | 0.3333333333333333 | 0 | 0.6666666666666666 | 0 | 0 | 0 |  | 19 | Region-5 |  |  | 18.8
 | Region-1 | EMP-5 | PRO-1 |  | 29.5 | EMP Sub Total (Region-6) | 8 | 0.375 | 0 | 0.625 | 0 | 0 | 0 |  | 22 | Region-6 |  |  | 21.8
 | Region-1 | [NAME] | PRO-2 |  | 30.5 | EMP Sub Total (Region-7) | 1 | 1 | 0 | 0 | 0 | 0 | 0 |  | 30 | [NAME] |  |  | 29.8
 | [NAME] | EMP-1 | PRO-3
 | [NAME] | EMP-2 | PRO-2 |  |  |  |  |  |  |  |  |  |  |  |  | Following formula is used to add row after each group.
 | [NAME] | EMP-3 | PRO-3 |  |  |  |  |  |  |  |  |  |  |  |  | SCAN(0,G,LAMBDA(x,y,x+y))+0.5,
 | [NAME] | EMP-4 | PRO-2
 | Region-3 | EMP-1 | PRO-3
 | Region-3 | EMP-2 | PRO-2
 | Region-3 | EMP-3 | PRO-3
 | Region-3 | EMP-4 | PRO-2
 | Region-4 | EMP-1 | PRO-3
 | Region-4 | EMP-2 | PRO-1
 | Region-4 | EMP-3 | PRO-3
 | Region-4 | EMP-4 | PRO-2
 | Region-5 | EMP-1 | PRO-1
 | Region-5 | EMP-2 | PRO-3
 | Region-5 | EMP-3 | PRO-3
 | Region-6 | EMP-1 | PRO-1
 | Region-6 | EMP-2 | PRO-3
 | Region-6 | EMP-3 | PRO-3
 | Region-6 | EMP-4 | PRO-1
 | Region-6 | EMP-5 | PRO-3
 | Region-6 | [NAME] | PRO-1
 | Region-6 | EMP-7 | PRO-3
 | Region-6 | EMP-8 | PRO-3
 | [NAME] | EMP-1 | PRO-1
Spreadsheet: 729127d1618923902-compare-dates-and-return-result-for-cash-flow-forecast-cash-flow-forecast-etaf-
Sheet: Sheet1

 |  | Month | 2021-01-31 00:00:00
Code | Amount | End Date
1 | 10 | 2021-01-31 00:00:00
2 | 10 | 2021-01-31 00:00:00
3 | 10 | 2021-01-31 00:00:00
3 | 30
1 | 40
1 | 50
1 | 60
1 | 70
2 | 100
2
2
2
 |  |  | AND((($C3+(VLOOKUP($A3,$A$22:$C$25,2))+(VLOOKUP($A3,$A$22:$C$25,3))-1)<=D$1,  ($C3+(VLOOKUP($A3,$A$22:$C$25,2))+(VLOOKUP($A3,$A$22:$C$25,3))-1) DATE(YEAR(D$1),MONTH(D$1),DAY(1)))
 | Invoice Lag | Collection
1 | 30 | 60 | total of 90 days or 3 months before the payment is received
2 | 30 | 90
3 | 0 | 0
Spreadsheet: 857507d1706521720-slicer-filter-on-pivot-table-sample
Sheet: Sheet1

Name | FTE | Funding | Product | 01/01/2024 | 08/01/2024 | 15/01/2024 | 22/01/2024 | 29/01/2024 | [NAME] | 12/02/2024 | 19/02/2024 | 26/02/2024 | 04/03/2024 | 11/03/2024
Staff 1 | 1 | AA | CCC | 0.5 |  | 0.5
Staff 2 | 2 | AA | CCC | 1
Staff 3 | 1 | CC | BBB |  |  |  |  |  | 1
Staff 4 | 3 | BB | AAA |  |  |  | 0.5 | 0.5 |  | 0.5 | 0.5 | 0.5 | 0.5
Staff 5 | 1 | BB | AAA |  | 0.2 | 0.2 |  |  | 0.2 |  |  |  |  | 0.4
Spreadsheet: 6d9c2207-f13e-4bd5-8541-59a78eea4567
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-11-08 15:04:20.370000
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.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.464 | 101.339 | 101.214 | 100.839
4.25 | 100.79 | 100.665 | 100.54 | 100.165 |  | Note: | Refer To Price [NAME]
4.125 | 100.441 | 100.316 | 100.191 | 99.816 |  |  | For all Price Adjs
4 | 99.985 | 99.86 | 99.735 | 99.11
3.875 | 99.423 | 99.298 | 99.173 | 98.548
 |  |  |  |  |  | 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.875 | 101.321 | 101.196 | 101.071 | 100.696
3.75 | 100.873 | 100.748 | 100.623 | 100.248
3.625 | 100.524 | 100.399 | 100.274 | 99.899
3.5 | 100.173 | 100.048 | 99.923 | 99.548
3.375 | 99.789 | 99.664 | 99.539 | 98.914
3.25 | 99.276 | 99.151 | 99.026 | 98.401
 |  |  |  |  |  | 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-11-22 15:04:20.370000
30 DAY | 2011-12-07 15:04:20.370000
45 DAY | 2011-12-22 15:04:20.370000
60 DAY | 2012-01-06 15:04:20.370000
90 DAY | 2012-02-05 15:04:20.370000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 106486d1303762476-excel-2007-display-dates-without-weekends-sample1
Sheet: Sheet2 (2)

Task | Start Date | Effort | End Date | Strt Time | End Time
Task 1 | 2011-04-20 08:00:00 | 08:00:00 | 2011-04-21 08:00:00
Task 2 | 2011-04-21 08:00:00 | 08:00:00 | 2011-04-22 08:00:00 | 08:00:00 | 16:00:00
Task 3 | 2011-04-22 08:00:00 | 08:00:00 | 2011-04-25 08:00:00
Task 4 | 2011-04-25 08:00:00 | 08:00:00 | 2011-04-26 08:00:00
Task 5 | 2011-04-26 08:00:00 | 08:00:00 | 2011-04-27 08:00:00
Task 6 | 2011-04-27 08:00:00 | 08:00:00 | 2011-04-28 08:00:00
Spreadsheet: 887789d1738115804-preserving-relationship-between-power-queried-field-and-user-entered-one-book1-jtopham19-
Sheet: Sheet1

Old table |  |  | New table |  |  | Appended table |  |  | Old table replacement
ID | Comment |  | ID | Comment |  | ID | Comment |  | ID | Comment
4 | Green |  | 3 |  |  | 3 |  |  | 3
5 | Yellow |  |  |  |  | 4 | Green |  | 4 | Green
6 | Orange |  |  |  |  | 5 | Yellow |  | 5 | Yellow
 |  |  |  |  |  | 6 | Orange |  | 6 | Orange