tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: dan_hyvl__4896__ALAGASCO
Sheet: Sheet1

K# | K Type (Global) | K Title | K Date | Term Start | Term End | MDQ | MISC | Status
96029227 | Master Sale Firm & Spot | Natural Gas Sales Term Agreement | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 2000-11-30 00:00:00 | 20,000/Day | Demand Fee ($180,000.00/yr escalated 5% each yr after 12/1/91) | Pending termination per CP notice (Suspended to prevent future deals from attaching)
96029226 | Master Sale Firm & Spot | Natural Gas Sales Term Agreement | 1992-11-01 00:00:00 | 1992-11-01 00:00:00 | 2002-10-31 00:00:00 | 10,000/Day | Demand Fee ($15,250.00/month escalated 5% each yr after 11/1/93) | Active (Suspended to prevent future deals from attaching)
96029224 | Master Sale Firm & Spot | Natural Gas Sales Term Agreement | 1991-11-01 00:00:00 | 1991-11-01 00:00:00 | 2001-10-31 00:00:00 | 5,216/Day | Demand Fee ($58,460.00/yr escalated 5% each yr after 11/1/92) | Active (Suspended to prevent future deals from attaching)
96029223 | Master Sale Firm & Spot | Natural Gas Sales Term Agreement | 1991-01-01 00:00:00 | 1991-01-01 00:00:00 | 2000-12-31 00:00:00 | 20,000/Day | Demand Fee ($360,000.00/yr escalated 5% each yr after 1/1/92) | Pending termination per CP notice (Suspended to prevent future deals from attaching)
OUTSTANDING DEALS
Deal # | [NAME] | Daily Volume | Demand Fee |  |  | Misc Notes | K linked to in Sitara | Correct K
242653 | 8/1/00 - 3/31/01 | 10,000/Day (8/1/00 - 10/31/00) | No Demand Fees noted on deal |  |  |  | 96029223
 |  | 15,000/Day (11/1/00 - 3/31/01)
250042 | 5/1/00 - 12/31/00 | 24,471/Day | Demand Fee |  |  | Noted as a CES deal | 96029223 | 96029223 (?) - - - If so, Volume constraint issue
250050 | 5/1/00 - 11/30/00 | 10,000/Day | Demand Fee |  |  | Noted as a CES deal | 96029223 | 96029227 (?)
250196 | 5/1/00 - 10/31/01 | 10,000/Day | Demand Fee |  |  | Noted as a CES deal | 96029223 | 96029224 (?)  - - - If so, Volume constraint issue
271301 | 6/01/00 - 3/31/00 | 10,000/Day | No Demand Fees noted on deal |  |  |  | 96029226
Spreadsheet: 716880d1612403192-need-help-removing-weekends-in-gantt-chart-status-bars-3-weeks-master-rev-1-1-
Sheet: GanttChart

JOB #
 | Project Start Date | 2021-02-01 00:00:00 |  |  | Display Week | 1
 | Project Lead
 | ACTIVITY | [NAME] | START | END | DAYS | % DONE | WORK DAYS
 | [Task Category]
 | SRTIP NEW WASTE AREA | SITE 4 | 2021-02-01 00:00:00 |  | 24 | 0
 |  |  | 2021-02-02 00:00:00 |  | 5 | 0
 |  |  | 2021-02-03 00:00:00 |  | 4 | 0
 |  |  | 2021-02-04 00:00:00 |  | 4 | 0
 |  |  | 2021-02-05 00:00:00 |  | 2 | 0
 |  |  | 2021-02-06 00:00:00 |  | 10 | 0
 |  |  | 2021-02-07 00:00:00 |  | 5 | 0
 |  |  | 2021-02-08 00:00:00 |  | 7 | 0
 |  |  | 2021-02-09 00:00:00 |  | 7 | 0
 | EMPLOYEE |  | 2021-02-10 00:00:00
 |  |  | 2021-02-11 00:00:00 |  | 4 | 0
 |  |  | 2021-02-12 00:00:00 |  | 3 | 0
 |  |  | 2021-02-13 00:00:00 |  | 3 | 0
 |  |  | 2018-02-17 00:00:00 |  | 6 | 0
 |  |  | 2018-02-23 00:00:00 |  | 3 | 0
 | EQUIPMENT
 |  |  | 2018-02-10 00:00:00 |  | 4 | 0
 |  |  | 2018-02-14 00:00:00 |  | 3 | 0
 |  |  | 2018-02-14 00:00:00 |  | 3 | 0
 |  |  | 2018-02-17 00:00:00 |  | 6 | 0
 |  |  | 2018-02-23 00:00:00 |  | 3 | 0
Spreadsheet: 125318d1318966824-pivot-table-days-of-the-week-sequence-ptgroupbyday
Sheet: Sheet1

Date | Value
 |  |  |  | Row Labels | Sum of Value
 |  |  |  | 10-Jul | 721
 |  |  |  | 11-Jul | 709
 |  |  |  | 12-Jul | 1158
 |  |  |  | 13-Jul | 363
 |  |  |  | 14-Jul | 389
 |  |  |  | 15-Jul | 329
 |  |  |  | 16-Jul | 311
 |  |  |  | 17-Jul | 550
 |  |  |  | 18-Jul | 521
 |  |  |  | 19-Jul | 422
 |  |  |  | 20-Jul | 504
 |  |  |  | 21-Jul | 248
 |  |  |  | 22-Jul | 286
 |  |  |  | 23-Jul | 657
 |  |  |  | 24-Jul | 354
 |  |  |  | 25-Jul | 580
 |  |  |  | 26-Jul | 421
 |  |  |  | 27-Jul | 715
 |  |  |  | 28-Jul | 302
 |  |  |  | 29-Jul | 649
 |  |  |  | 30-Jul | 292
 |  |  |  | 31-Jul | 350
 |  |  |  | 1-Aug | 182
 |  |  |  | 2-Aug | 481
 |  |  |  | 3-Aug | 216
 |  |  |  | 4-Aug | 239
 |  |  |  | 5-Aug | 602
 |  |  |  | 6-Aug | 573
 |  |  |  | 7-Aug | 48
 |  |  |  | 8-Aug | 400
 |  |  |  | 9-Aug | 1104
 |  |  |  | 10-Aug | 417
 |  |  |  | 11-Aug | 432
 |  |  |  | 12-Aug | 691
 |  |  |  | 13-Aug | 548
 |  |  |  | 14-Aug | 970
 |  |  |  | 15-Aug | 599
 |  |  |  | 16-Aug | 600
 |  |  |  | 17-Aug | 614
 |  |  |  | 18-Aug | 824
 |  |  |  | 19-Aug | 792
 |  |  |  | 20-Aug | 324
 |  |  |  | 21-Aug | 638
 |  |  |  | 22-Aug | 248
 |  |  |  | 23-Aug | 512
 |  |  |  | 24-Aug | 313
 |  |  |  | 25-Aug | 843
 |  |  |  | 26-Aug | 150
 |  |  |  | 27-Aug | 398
 |  |  |  | 28-Aug | 600
 |  |  |  | 29-Aug | 498
 |  |  |  | 30-Aug | 149
 |  |  |  | 31-Aug | 454
 |  |  |  | 1-Sep | 516
 |  |  |  | 2-Sep | 923
 |  |  |  | 3-Sep | 214
 |  |  |  | 4-Sep | 953
 |  |  |  | 5-Sep | 651
 |  |  |  | 6-Sep | 520
 |  |  |  | 7-Sep | 126
 |  |  |  | 8-Sep | 827
 |  |  |  | 9-Sep | 443
 |  |  |  | 10-Sep | 485
 |  |  |  | 11-Sep | 840
 |  |  |  | 12-Sep | 649
 |  |  |  | 13-Sep | 910
 |  |  |  | 14-Sep | 161
 |  |  |  | 15-Sep | 193
 |  |  |  | 16-Sep | 773
 |  |  |  | 17-Sep | 580
 |  |  |  | 18-Sep | 621
 |  |  |  | 19-Sep | 243
 |  |  |  | 20-Sep | 475
 |  |  |  | 21-Sep | 808
 |  |  |  | 22-Sep | 283
 |  |  |  | 23-Sep | 926
 |  |  |  | 24-Sep | 597
 |  |  |  | 25-Sep | 588
 |  |  |  | 26-Sep | 822
 |  |  |  | 27-Sep | 499
 |  |  |  | 28-Sep | 853
 |  |  |  | 29-Sep | 962
 |  |  |  | 30-Sep | 462
 |  |  |  | 1-Oct | 462
 |  |  |  | 2-Oct | 291
 |  |  |  | 3-Oct | 438
 |  |  |  | 4-Oct | 541
 |  |  |  | 5-Oct | 455
 |  |  |  | 6-Oct | 657
 |  |  |  | 7-Oct | 1056
 |  |  |  | 8-Oct | 1000
 |  |  |  | 10-Oct | 590
 |  |  |  | 11-Oct | 556
 |  |  |  | 12-Oct | 1064
 |  |  |  | 13-Oct | 863
 |  |  |  | 14-Oct | 491
 |  |  |  | 15-Oct | 496
 |  |  |  | 16-Oct | 444
 |  |  |  | 17-Oct | 915
 |  |  |  | 18-Oct | 427
 |  |  |  | Grand Total | 54939
Spreadsheet: 741572d1627150234-list-of-combinations-how-many-times-a-specific-combination-repeat-the-same-value-book2
Sheet: Sheet1

 | 1 | 2 | 3
Apple | 1 | 0 | 0
[NAME] | 0 | 3 | 2
Grape | 0 | 0 | 0
Output
 | Apple | [NAME] | Grape
Apple | - | 0 | 2
[NAME] | 0 | - | 1
Grape | 2 | 1 | -
Spreadsheet: 788859d1658767903-how-to-find-a-minimum-maximum-values-with-vlookup-formula-2022-07-25-oeldere-herring282-teamdata_ch220725_forum
Sheet: Sheet2

Athlete | Athlete 1 |  |  |  |  | Start Date | 2020-02-03 00:00:00
 |  |  |  | Athlete 2 |  | End Date | 2022-06-24 00:00:00
TEST | Latest |  |  | Athlete 3
 |  |  |  | Athlete 4
Fly 10 |  |  |  | Athlete 5
 |  |  |  | Athlete 6
MPH
10yd Sprint
20yd Sprint
Pro Agility
CMJ
Spreadsheet: 834967d1688200745-intersperse-blank-cells-within-a-list-sample-48-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | [NAME] | HD 1 | HD2 | HD3 |  |  | Post`#13 |  | Post #15 |  | Correct |  | Post #8
Header 1 | [NAME] | [NAME] | [NAME] | [NAME] | Header 6 | [NAME] | [NAME] | Header 9
Q | 1 | 2 | W | E
W | 5 | 6 |  |  |  |  |  |  | W | W | W | W |  |  |  |  |  |  | W
E |  |  |  |  |  |  |  |  | E | E | E | E |  |  |  |  | W |  | R
R | c | d |  |  |  |  |  |  |  | R | R | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
Spreadsheet: 0cc647f2-1018-4c5c-b84f-7f7325646363
Sheet: Sheet1

Member | CoS | CoS Email | FS Staffer | Staffer Email | Phone
Financial Services:
[NAME] (MA-04) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-5931
Maloney (NY-14) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-7944
[NAME] (PA-11) | Karen Feather | [EMAIL] | [NAME] | [EMAIL] | 225-6511
[NAME] (IL-04) | Jennice Fuentes | [EMAIL] | [NAME] | [EMAIL] | 225-8203
Waters (CA-35) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-2201
Watt (NC-12) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-1510
Meeks (NY-06) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-3461
Moore (KS-03) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-2865
Bachus (AL-06) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-4921
Garrett (NJ-05) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-4465
[NAME] (WV-02) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-2711
Maloney (NY-14) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-7944
Hensarling (TX-5) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-3484
Biggert (IL-13) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-3515
Kilroy (OH-15) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-2015
[NAME] (MI-09) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-5802
Royce (CA-40) | [NAME] | [EMAIL] | Darrin Schrader | [EMAIL] | 225-4111
Member | CoS | Cos Email | FS Staffer | FS Staffer Email | Phone
Energy and Commerce
[NAME] (CA-30) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-3976
Barton (TX-06) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-2002
Rush (IL-01) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-4372
Oversight/Gov Reform
Towns (NY-10) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-5936
Issa (CA-49) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-3906
Cummings (MD-7) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-4741
Small Business:
Velazquez (NY-12) | [NAME] | [EMAIL] | Aixa Aleman-Diaz | [EMAIL] | 225-2361
Graves (MO-06) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-7041
Shuler (NC-11) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-6401
Judiciary:
Conyers (MI-14) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-5126
[NAME] ([NAME]) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-4236
[NAME] (CA-28) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-4695
Agriculture:
[NAME] (MN-07) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-2165
Lucas (OK-03) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-5565
Boswell (IA-03) | [NAME] | [EMAIL] | [NAME] | [EMAIL] | 225-3806
Spreadsheet: 808092d1670282859-filtered-data-error-excel-help-6
Sheet: Fiona

 | Name | Position | State | Clinic | Hiring Manager | Entity | Employment Type | Start Date
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PFT | 2022-10-11 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | Casual | 2022-10-10 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PPT | 2022-10-04 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PFT | 2022-10-24 00:00:00
 | Alayna Woods | ONAC | VIC | CCDM | [NAME] | 1 | Casual | 2022-10-17 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PFT | 2022-10-05 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PPT | 2022-08-15 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PPT | 2022-07-25 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PFT | 2022-10-11 00:00:00 |  | 2022-11-11 00:00:00 | 2023-01-11 00:00:00 | 2023-03-11 00:00:00 | 2023-04-11 00:00:00 |  | 2023-01-11 00:00:00 | yes | no | no | no
 | Alayna Woods | ONAC | VIC | CCDM | [NAME] | 1 | Casual | 2022-10-17 00:00:00 |  | 2022-11-17 00:00:00 | 2023-01-17 00:00:00 | 2023-03-17 00:00:00 | 2023-04-17 00:00:00 |  | 2023-01-17 00:00:00 | yes | no | no | no
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PPT | 2022-10-04 00:00:00 |  | 2022-11-04 00:00:00 | 2023-01-04 00:00:00 | 2023-03-04 00:00:00 | 2023-04-04 00:00:00 |  | 2023-01-04 00:00:00 | yes | no | no | no
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PPT | 2022-07-25 00:00:00 |  | 2022-08-25 00:00:00 | 2022-10-25 00:00:00 | 2022-12-25 00:00:00 | 2023-01-25 00:00:00 |  | 2022-12-25 00:00:00 | yes | no | no | no
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PFT | 2022-10-05 00:00:00 |  | 2022-11-05 00:00:00 | 2023-01-05 00:00:00 | 2023-03-05 00:00:00 | 2023-04-05 00:00:00 |  | 2023-01-05 00:00:00 | yes | yes | no | no
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | Casual | 2022-10-10 00:00:00 |  | 2022-11-10 00:00:00 | 2023-01-10 00:00:00 | 2023-03-10 00:00:00 | 2023-04-10 00:00:00 |  | 2023-01-10 00:00:00 | yes | no | no | no
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PFT | 2022-10-24 00:00:00 |  | 2022-11-24 00:00:00 | 2023-01-24 00:00:00 | 2023-03-24 00:00:00 | 2023-04-24 00:00:00 |  | 2023-01-24 00:00:00 | yes | no | no | no
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PPT | 2022-08-15 00:00:00 |  | 2022-09-15 00:00:00 | 2022-11-15 00:00:00 | 2023-01-15 00:00:00 | 2023-02-15 00:00:00 |  | 2023-01-15 00:00:00 | yes | no | no | no
Spreadsheet: 805448d1668690358-a-woodworker-in-need-of-help-with-if-function-with-sum-as-a-condition-new-template-2022-v3
Sheet: Test Template

Material Cost
 |  | Price per unit |  |  |  |  |  |  | Primary Wood | Nogal USA |  |  |  |  |  | K2 = Wood type
Total Wood Cost |  |  |  |  |  |  |  |  | Secondary Wood | Roble EU |  |  |  |  |  | K22 = wood thickness |  | 0.076
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.038
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.027
 |  |  |  |  |  |  |  | Final Dimensions
Drawer runners | 3 | 18
Tooling | 1 | 35 |  |  |  |  |  | Wood | Element | Quantity | Length | [NAME] | Thickness | m2
 |  | Total |  |  |  |  |  | 1st | Top/Bottom | 2 | 1.4 | 1.4 | 0.045
Labor Cost |  |  |  |  |  |  |  | 1st | Walls | 1 | 0.9 | 0.8 | 0.03
Time |  | Price per minute |  |  |  |  |  | 1st | Back | 1 | 3 | 0.8 | 0.03
Processing |  | 5 |  |  |  |  |  | 1st | Legs | 1 | 0.5 | 0.05 | 0.05
Cutting All pieces | 3 | 40 |  |  |  |  |  | 1st | Sttrecther | 1 | 2.8 | 0.1 | 0.033
Drawers | 6 | 40 |  |  |  |  |  | 1st | Rails | 1 | 0.8 | 0.05 | 0.02
Glue up | 6 | 30 |  |  |  |  |  | 1st | Seperations | 1 | 0.8 | 0.8 | 0.02
Sanding | 5 | 30 |  |  |  |  |  | 1st | Doors | 1 | 1 | 0.8 | 0.04
Finish | 10 | 20
Assemply and cutting joints | 4 | 40
Delivery | 0 | 350 |  |  |  |  |  |  | RAW LUMBER
Stacking | 0 | 100 |  |  |  |  |  |  |  |  |  |  | [NAME] | Per unit quantity | All Unit quantity
 |  | Total |  |  |  |  |  |  |  | length | thickness | width |  |  |  | m2 | m3 | Price/m3 | Price | [NAME]
Shop Costs |  | 14 |  |  |  |  |  |  |  | 3.6 |  | 0.18 | 0.16
 |  |  |  |  |  |  |  |  |  | 4 |  | 0.18 | 0.16
 |  | Construction Total |  |  |  |  |  |  |  | 3.6 |  | 0.18 | 0.16
 |  | Profit |  |  |  |  |  |  |  | 3.6 |  | 0.18 | 0.16
 |  | Total |  |  |  |  |  |  |  | 3.6 |  | 0.18 | 0.16
 |  | IVA |  |  |  |  |  |  |  | 3.6 |  | 0.18 | 0.16
 |  |  |  |  |  |  |  |  |  | 3.6 |  | 0.18 | 0.16
 |  |  |  |  |  |  |  |  |  | 3.6 |  | 0.18 | 0.16
Spreadsheet: 826714d1682190384-confused-using-countif-s-across-multiple-worksheets-with-drop-down-menus-fy-23-icass-count-2023-2024-
Sheet: Jun 23

Inbound |  |  |  |  |  | Outbound
Date | Office | Owner (if personal) | Content/Service | Agency/Icass Code | Reference #/ Description | Date2 | office2 | Owner (if personal)2 | Content/Service2 | Agency/Icass Code2 | Reference # / Description
1906-01-30 00:00:00 |  |  |  | 1150.0 DSCA - Defense Security Cooperation Agency
1960-11-02 00:00:00 |  |  |  | 1525  DOJ - FBI - LEGATT, [NAME]
1991-04-05 00:00:00 |  |  |  | 1330.0 DOC - ITA - Global Markets
1909-02-14 00:00:00 |  |  |  | 1150.0 DSCA - Defense Security Cooperation Agency
8313-02-10 00:00:00 |  |  |  | 1150 DSCA - Defense Security Cooperation Agency
Spreadsheet: 106388d1303592473-project-sales-based-on-known-awards-amount-over-time-mre497673-beta-labor-distribution
Sheet: Spread

 | A | 0.5 |  |  | See p 168 et seq of the NASA Cost Estimating Handbook
 | B | 0
 | A+B | 0.5
 | nPer |  | Amount
 | 12 |  | 2000000
 | Per | Value | Cum
 | 1 | 58802.72633744856 | 58802.72633744856
 | 2 | 140785.7510288066 | 199588.4773662552
 | 3 | 183224.0226337448 | 382812.5
 | 4 | 201549.6399176955 | 584362.1399176955
 | 5 | 207336.6769547324 | 791698.8168724279
 | 6 | 208301.1831275721 | 1000000
 | 7 | 208301.1831275723 | 1208301.183127572
 | 8 | 207336.6769547325 | 1415637.860082305
 | 9 | 201549.6399176952 | 1617187.5
 | 10 | 183224.0226337451 | 1800411.522633745
 | 11 | 140785.751028806 | 1941197.273662551
 | 12 | 58802.72633744893 | 2000000
 | 13 | #N/A | #N/A
 | 14 | #N/A | #N/A
 | 15 | #N/A | #N/A
 | 16 | #N/A | #N/A
 | 17 | #N/A | #N/A
 | 18 | #N/A | #N/A
 | 19 | #N/A | #N/A
 | 20 | #N/A | #N/A
 | 21 | #N/A | #N/A
 | 22 | #N/A | #N/A
 | 23 | #N/A | #N/A
 | 24 | #N/A | #N/A
 | 25 | #N/A | #N/A
 | 26 | #N/A | #N/A
 | 27 | #N/A | #N/A
 | 28 | #N/A | #N/A
 | 29 | #N/A | #N/A
 | 30 | #N/A | #N/A
 | 31 | #N/A | #N/A
 | 32 | #N/A | #N/A
 | 33 | #N/A | #N/A
 | 34 | #N/A | #N/A
 | 35 | #N/A | #N/A
 | 36 | #N/A | #N/A
 | 37 | #N/A | #N/A
 | 38 | #N/A | #N/A
 | 39 | #N/A | #N/A
 | 40 | #N/A | #N/A
 | 41 | #N/A | #N/A
 | 42 | #N/A | #N/A
 | 43 | #N/A | #N/A
 | 44 | #N/A | #N/A
 | 45 | #N/A | #N/A
 | 46 | #N/A | #N/A
 | 47 | #N/A | #N/A
 | 48 | #N/A | #N/A
 | 49 | #N/A | #N/A
 | 50 | #N/A | #N/A
 | 51 | #N/A | #N/A
 | 52 | #N/A | #N/A
 | 53 | #N/A | #N/A
 | 54 | #N/A | #N/A
 | 55 | #N/A | #N/A
 | 56 | #N/A | #N/A
 | 57 | #N/A | #N/A
 | 58 | #N/A | #N/A
 | 59 | #N/A | #N/A
 | 60 | #N/A | #N/A
Spreadsheet: 732532d1621006985-text-join-substitute-formula-assistance-textjoin-sub
Sheet: Sheet1

 |  | (Always 3 digits) | Sometimes given as a string like this where Prog and [NAME] are already combined | (Always 4 digits) | (Always 2 digits, could start with 0, but would need to display as 2 digits (EXAMPLE: 2 = 02))
 | Acct-Prog-Loc | ACCT | [NAME] | Prog | [NAME]
 | 123-1011-35|123-1011-90|123-1025-90..123-1045-90|123-1047-90..123-1076-90|123-1082-90..123-1085-90|123-1300-90..123-1301-90|123-4100-90 | 123 | 1011-35|1011-90|1025-90..1045-90|1047-90..1076-90|1082-90..1085-90|1300-90..1301-90|4100-90
 | 123-4014-90..125-4014-90 | 123..125 |  | 4014 | 90
 | 123-4010-90|123-4012-90|123-4013-90|123-4015-90..123-4018-90|123-4950-90 | 123 |  | 4010|4012|4013|4015..4018|4950 | 90
 | 123-1079-90..123-1081-90|155-1079-90..155-1081-90 | 123|155 |  | 1079..1081 | 90
Spreadsheet: 859888d1708101356-if-cell-value-matches-same-value-in-another-cell-return-adjacent-cells-test-excel-7
Sheet: NO HISTORY ITEMS & SPA ANALYSIS

NO HISTORY ITEMS |  | [NAME] | Authorization Name | Contract Start Date | Contract Stop Date | Cost-Side Claim | Market Cost (Includes WTT) | Sell | Loaded Margin
 | gfhj
[PHONE] | sds
[PHONE] | sdfds
[PHONE] | sddfs
[PHONE] | sf
[PHONE] | sdf
[PHONE] | sdf
[PHONE] | sdf
 |  | If value in a matches value in column d on rps data 'rps data' sheet then  specfic columns 14,43,16,17,41,58,10 on rps data sheet fill cells C,D,E,F,G,H,I
Spreadsheet: 855239d1704887254-transfer-table-to-unique-row-dataset-example
Sheet: Blad1

 |  | overview 1
 |  |  |  | week nr
 |  | Customer name | Order type | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  | Customer A | Firm orders | 4 | 3 | 2 | 3 | 5 | 10 | 0 | 0 | 0 | 0
 |  | Customer A | Forecast orders | 0 | 0 | 1 | 3 | 0 | 4 | 5 | 6 | 4 | 6
 |  | Customer A | Total orders | 4 | 3 | 3 | 6 | 5 | 14 | 5 | 6 | 4 | 6
 |  | Customer B | Firm orders | 12 | 15 | 13 | 10 | 8 | 7 | 0 | 0 | 0 | 0
 |  | Customer B | Forecast orders | 0 | 2 | 3 | 2 | 4 | 8 | 12 | 14 | 13 | 11
 |  | Customer B | Total orders | 12 | 17 | 16 | 12 | 12 | 15 | 12 | 14 | 13 | 11
 |  | Overview 2
 |  | Customer name | week nr | Order type | #
 |  | Customer A | 1 | Firm orders | 4
 |  | Customer A | 1 | Forecast orders | 0
 |  | Customer A | 1 | Total orders | 4
 |  | Customer A | 2 | Firm orders | 3
 |  | Customer A | 2 | Forecast orders | 0
 |  | Customer A | 2 | Total orders | 3
 |  | Customer A | 3 | Firm orders | 2
 |  | Customer A | 3 | Forecast orders | 1
 |  | Customer A | 3 | Total orders | 3
 |  | Customer A | 4 | Firm orders | 3
 |  | Customer A | 4 | Forecast orders | 3
 |  | Customer A | 4 | Total orders | 6
 |  | Customer A | 5 | Firm orders | 5
 |  | Customer A | 5 | Forecast orders | 0
 |  | Customer A | 5 | Total orders | 5
 |  | Customer A | 6 | Firm orders | 10
 |  | Customer A | 6 | Forecast orders | 4
 |  | Customer A | 6 | Total orders | 14
Spreadsheet: 03394ff5-770e-415a-baf2-64482e98b43e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-06-15 09:30:00.450000
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 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.556 | 101.431 | 101.306 | 100.931
3.75 | 100.721 | 100.596 | 100.471 | 100.096 |  | Note: | Refer To Price [NAME]
3.625 | 100.372 | 100.247 | 100.122 | 99.747 |  |  | For all Price Adjs
3.5 | 99.772 | 99.647 | 99.522 | 98.897
3.375 | 98.885 | 98.76 | 98.635 | 98.01
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.73 | 101.605 | 101.48 | 101.105
3.25 | 101.23 | 101.105 | 100.98 | 100.605
3.125 | 100.896 | 100.771 | 100.646 | 100.271
3 | 100.569 | 100.444 | 100.319 | 99.944
2.875 | 99.986 | 99.861 | 99.736 | 99.111
2.75 | 99.308 | 99.183 | 99.058 | 98.433
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-06-29 09:30:00.450000
30 DAY | 2012-07-14 09:30:00.450000
45 DAY | 2012-07-29 09:30:00.450000
60 DAY | 2012-08-13 09:30:00.450000
90 DAY | 2012-09-12 09:30:00.450000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.