tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 585586d1533836841-need-and-or-added-to-an-index-small-if-statement-excel-training-index-small-if-need-to-add-or
Sheet: Wholesalers

 | ABC | DEF | [NAME] | ABC3
This is tab name below:
ABC | <----- Coworker manually types this in at the top of each page
Partner | Address | City | State | Zip
 |  |  |  |  |  | NEW PROBLEM 07-24-2018: One of the wholesalers has 3 names, so each partner can call them by a different name, but we want to collect all under the main name which is ABC.  So for this formula to work I have to create several tables for the different names of the same wholesaler.
This is tab name below:
DEF | <----- Coworker manually types this in at the top of each page
Partner | Address | City | State | Zip |  | So instead of referencing one cell for each wholesaler, I know need to write the formulas in Column A with and OR statement, but I keep getting errors.
This is tab name below:
[NAME] | <----- Coworker manually types this in at the top of each page
Partner | Address | City | State | Zip
This is tab name below:
ABC3 | <----- Coworker manually types this in at the top of each page
Partner | Address | City | State | Zip
Spreadsheet: john_griffith__16062__skew table
Sheet: Sheet1

 | Vol Skew Table
 | Days | [NAME], [NAME] |  |  | [NAME], Strike Above
 | Out | 0.3 | 0.2 | 0.1 | 0.1 | 0.2 | 0.3
 | 30 | 0.079 | 0.055 | 0.032 | 0.005 | 0.01 | 0.014
 | 180 | 0.076 | 0.052 | 0.029 | 0.0015 | 0.0035 | 0.005
 | 360 | 0.07 | 0.048 | 0.025 | 0.0005 | 0.001 | 0.0015
 | 720 | 0.063 | 0.041 | 0.02 | 0.0001 | 1e-05 | 1e-05
Spreadsheet: 202904d1356798138-drop-down-list-to-automatically-fill-cells-to-right-copy-of-book1
Sheet: EARLY

Group | PERSONNEL 1 | PERSONNEL 2 | skill 1 | skill 2 | skill3 | skill 4 | skill 5 | skill 6 | skill 7 | skill 8
1 | [NAME] | Damon
2 | [NAME]
3 | Damon
Spreadsheet: rick_buy__32702__npw
Sheet: Sheet1

Analysis of Incremental Book Loss to ENE if
NPW goes from $5/share to worthless
 |  | # of shares |  | Potential Book loss to ENE
Common | On Balance Sheet | 8650400
 | [NAME] | 5000000
 |  |  |  | -75414140 | (1)
Warrants | [NAME] | 6776400
 | [NAME] | 8458200
 | [NAME] | 2791800
 | Raptor 3 | 24117800
 |  | 42134200 |  | -210671000 | (2)
 |  | 55784600 |  | -286085140
(1) | Loss would be the result of EES writing-off its basis (as of 6/30/01)
 | in NPW common ownership
(2) | 42MM shares * $5/share loss (i.e. FMV goes to zero).  Also
 | assumes no credit capacity in Raptor entities
Spreadsheet: d8dd0c57-07cd-46fb-815d-a7816479d03b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2597 | 7962 | [NAME] | Bourseaux | FRA | 11 | 00:26:48 | 00:01:03 | 00:05:25 | 00:15:10 | [NAME] | 1 | 02:11:09
2597 | 13700 | Alfred | Lipp | GER | 15 | 00:38:20 | 00:01:53 | 00:06:23 | 00:18:05 | 01:48:26 | 2 | 02:53:05
2597 | 11531 | [NAME] | Meunier | FRA | 221 | 00:39:00 | 00:02:49 | 00:07:48 | 00:22:33 | 02:05:54 | 3 | 03:18:04
Spreadsheet: tom_donohoe__39894__Morning prod
Sheet: Sheet1

SPINNAKER EXPLORATION
MORNING PRODUCTION SUMMARY
 |  |  |  |  |  |  | Date |  | 2000-11-03 00:00:00
PLTF | FTP | Spot | System | P/L | Flare | Hrs |  | Casing Pressure
HI 202-A |  |  | 1180 | 1170 | 0 | 24
A-1 | 6600 | 34017 | 1180 | 1170 | 0 | 24 |  | 3875 | 450 |  |  |  | 50
A-2 | 5900 | 42000 | 1180 | 1170 | 0 | 24 |  | 30 | 470 |  |  |  | 20
A-3 | 7680 | 17856 | 1180 | 1170 | 0 | 24 |  | 3500 | 700 |  |  |  | 0
HI 202-B |  |  |  |  |  | 24
B-1 | 1725 | 7085 | 1180 | 1170 | 0 | 24 |  | 50 | 50 |  |  |  | 50
B-2 | 2200 | 12194 | 1180 | 1170 | 0 | 24 |  | 175 | 50 |  |  |  | 0
B-3 | 2110 | 4201 | 1180 | 1170 | 0 | 24 |  | 200 | 0 |  |  |  | 0
HI A-7 | 7350 | 38243 | 1180 | 1170 | 0 | 24 |  | 0 | 525 |  |  |  | 125
HI 199 totals
Spot rate |  | 155384
Verm 375 |  | 6700 |  |  | 0 | 24
NP 883 |  | 21038 |  | 943 | 0 | 24
HI-235 |  | 17254 |  | 1249 | 0 | 24
WC 39 |  | 7838 |  | 880 | 0 | 24
EC 152 |  | 0 |  | 1008 | 0 | 14
EC138 #2 |  | 0 |  | 943 | 0 | 0
ST 212 |  | 39364 |  | 1140 | 0 | 24
ST 220 |  | 7700 |  | 1023 | 0 | 24
Field Totals
Remarks: | EC 152 SI last night.
 | 202 B-1 well test 24 hr rates---Gas 7085  Cond.- 0  H20- 17
 | Contact numbers         Rate                            Cond
 | ST 212                           [PHONE]              [PHONE](0)
 | WC 39                           [PHONE](0)
 | HI 235                           [PHONE](0)          [PHONE](0)
 | ST 220                          [PHONE]
 | EC 138 & 152               800-231/7794       138#2 flows few days mo.
 |  |  |  | MTR # 3026 |  | 152# [PHONE]
 | NP 883                           [PHONE]
Spreadsheet: 201738d1356099852-how-can-i-match-an-certain-criteria-to-a-product-example
Sheet: GAME

(Original Payout)-(New Bet) | Different | (New Payout)-(Original Bet) | New Bet | New Payout
66.6599999999207 | -0.02000000023792836 | 66.68000000015863 | 83.3400000000793 | 166.6800000001586
66.6699999999207 | 0.009999999762115408 | 66.66000000015859 | 83.3300000000793 | 166.6600000001586 |  | Original Bet | Original Payout
-635.549999999875 | -2106.649999999625 | 1471.09999999975 | 785.549999999875 | 1571.09999999975 |  | 100 | 150
-635.539999999875 | -2106.619999999625 | 1471.07999999975 | 785.539999999875 | 1571.07999999975 |  | Bet Amount | New Payout
-635.529999999875 | -2106.589999999625 | 1471.05999999975 | 785.529999999875 | 1571.05999999975 |  | 100 | 200
-635.519999999875 | -2106.559999999625 | 1471.03999999975 | 785.519999999875 | 1571.03999999975
-635.509999999875 | -2106.529999999625 | 1471.01999999975 | 785.509999999875 | 1571.01999999975
-635.499999999875 | -2106.499999999625 | 1470.99999999975 | 785.499999999875 | 1570.99999999975
-635.489999999875 | -2106.469999999625 | 1470.97999999975 | 785.489999999875 | 1570.97999999975
-635.479999999875 | -2106.439999999625 | 1470.95999999975 | 785.479999999875 | 1570.95999999975
-635.469999999875 | -2106.409999999625 | 1470.93999999975 | 785.469999999875 | 1570.93999999975
-635.459999999875 | -2106.379999999625 | 1470.91999999975 | 785.459999999875 | 1570.91999999975
-635.449999999875 | -2106.349999999625 | 1470.89999999975 | 785.449999999875 | 1570.89999999975
-635.439999999875 | -2106.319999999625 | 1470.87999999975 | 785.439999999875 | 1570.87999999975
-635.429999999875 | -2106.289999999625 | 1470.85999999975 | 785.429999999875 | 1570.85999999975
-635.419999999875 | -2106.259999999625 | 1470.83999999975 | 785.419999999875 | 1570.83999999975
Spreadsheet: 113000d1308943453-sumif-msa-rpt
Sheet: Calculation

 | less than 5% | 5.1% - 7% | 7.1% - 10% | 10% or Greater
Daytona Beach, FL MSA | 0
Fort Lauderdale, FL    PMSA
[NAME], FL MSA
Fort Pierce-Port St. Lucie, FL MSA
Fort Walton Beach, FL MSA
Gainesville, FL MSA
Geographical Area Not Included in MSA
Jacksonville, FL MSA
Lakeland-Winter Haven, FL MSA
Melbourne-Titusville-Palm Bay, FL MSA
Miami, FL PMSA
Naples, FL MSA
[NAME], FL MSA
Orlando, FL MSA
Panama City, FL MSA
Pensacola, FL MSA
[NAME], FL    MSA
Sarasota-Bradenton, FL    MSA
Tallahassee, FL MSA
Tampa-St. Petersburg-Clearwater, FL MSA
West Palm Beach-Boca Raton, FL    MSA
Spreadsheet: 1993903c-2bb3-4625-bcf1-6eb9d86f9222
Sheet: Sheet1

Table S5. Sequence percent similarity based on amino acids and nucleotides (in parentheses) for the structural (SP) and non-structural (NSP) proteins of selected alphaviruses. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Virus | Strain | Accession No. | 05.115/06.49 | 05.115 | 06.49
 |  |  | NSP | SP | SP
CHIKV | 05.115 | To be submitted | 100 (100) | 100 (100) | -
 | 06.49 | To be submitted | 100 (99.97) | 99.91 (99.95) | 100 (100)
 | [NAME] | AF369024 | 98.79 (97.3) | 98.47 (97.34) | 98.38 (97.33)
 | 37997 | AY726732 | 95.88 (85.5) | 95.82 (84.87) | 95.74 (84.81)
 | Nagpur | AY424803 |  | 97.18 (94.85) | 97.10 (94.79)
 | [NAME] | L37661 |  | 96.92 (94.24) | 96.83 (94.19)
ONNV | Gulu | M20303 | 85.90 | 87.30 | 87.22
SFV | 42S RNA genome | X04129 | 70.55 | 65.20 | 65.20
RRV | NB5092 | M20162 | 69.66 | 64.40 | 64.40
SINV | HRSP | J02363 | 59.25 | 47.40 | 47.31
CHIKV: chikungunya virus; ONNV: o'nyong-nyong virus; SFV: Semliki Forest virus; RRV: [NAME] virus; SINV: Sindbis virus
NA: Not Available.
Spreadsheet: 851992d1702099049-search-letters-and-numbers-to-see-if-exist-in-another-column-by-at-least-7-characters-match-4-1-
Sheet: Hoja1

Pass1 | Pass2
A847295016 | E280475631
E203847561 | A590827346
A509283746 | E650143728
E615204837 | A214365879
A123456789 | A421390786
[NAME] | [NAME]
A432109876 | E345890176
E876543210 | A870925461
A765432109 | E879563421
E345678901 | E876504321
EE1234567 | FF123000
Spreadsheet: 860709d1708701868-formula-that-gives-different-results-according-to-the-selected-client-profile-formula-v2-
Sheet: Dashboard

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Profile A
 |  | Type | Profile B |  |  |  |  |  |  |  |  |  |  |  |  | Profile B
 |  | Result
 |  |  |  | 0.07 |  |  |  |  | 0.25 |  |  |  | Low
 |  |  |  | 0.07 |  |  |  |  | 0.25 |  |  |  | Low
 |  |  |  | 0.07 |  |  |  |  | 0.25 |  |  |  | Low
 |  |  |  | 0.07 |  |  |  |  | 0.25 |  |  |  | Low
 |  |  |  | 0.05 |  |  |  |  | 0.25 |  |  |  | 0 | to escalate to CAC
 |  |  |  | 0.1 |  |  |  |  | 0.25 |  |  |  | Low | to escalate to CAC
 |  |  |  | 0.05 |  |  |  |  | 0.25 |  |  |  | Low
 |  |  |  | 0.08 |  |  |  |  | 0.1
 |  |  |  | 0.05 |  |  |  |  | 0.25
 |  |  |  | 0.03 |  |  |  |  | 0
 |  |  |  | 0.03 |  |  |  |  | 0
 |  |  |  | 0.05 |  |  |  |  | 0.25
 |  |  |  | 0.07 |  |  |  |  | 1
 |  |  |  | 0.1 |  |  |  |  | 0.25
 |  |  |  | 0.11 |  |  |  |  | 0.25
 |  |  |  |  |  |  |  |  |  |  | Profile A
 |  |  |  |  |  |  |  | Total Score |  |  |  | Risk Score (Range) | LB (Parameter) | UB (Parameter) |  | Classification | score adjustment
 |  |  |  |  |  |  | Score: | 63 |  |  | Extreme | 80.01-100 | 80.01 | 100 |  | Prohibited | 2
 |  |  |  |  |  |  | Risk Rating : |  |  |  | High Risk | 60.01 - 80.00 | 60.01 | 80 |  | Very High | 2
 |  |  |  |  |  |  |  |  |  |  | Medium Risk | 45.01 - 60.00 | 45.01 | 60 |  | High | 1
 |  |  |  |  |  |  |  |  |  |  | Low Risk | 25.85 - 45.00 | 25.85 | 45 |  | Medium | -1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low | -2
 |  |  |  |  |  |  | Action |  |  |  | Profile B |  |  |  |  | N/A | 0
 |  |  |  |  |  |  |  |  |  |  |  | Risk Score (Range) | LB (Parameter) | UB (Parameter)
 |  |  |  |  |  |  |  |  |  |  | Extreme | 80.01-100 | 80.01 | 100
 |  |  |  |  |  |  |  |  |  |  | High Risk | 65.01 - 80.00 | 65.01 | 80
 |  |  |  |  |  |  |  |  |  |  | Medium Risk | 50.01 - 65.00 | 50.01 | 65
 |  |  |  |  |  |  |  |  |  |  | Low Risk | 25.85 -50.00 | 25.85 | 50
 | Andorra
 | Andorra
 | Andorra
 | Andorra
 | Andorra
 | Andorra
 | Andorra
Spreadsheet: daren_farmer__6016__WC580reveff061500
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/19/00
Subject:  Revised Availabilities Effective 6/15/00 6/16/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-15 00:00:00 | WC 580 | 28517 | 0.1925 |  |  | 20145
1st of month DBQ = 20145/d
Spreadsheet: sara_shackleton__36617__Pre-Petition Terminations1
Sheet: Post-Petition Terminations (2)

Mutual Post-Petition Terminations
(as of 12/23/01)
Counterparty | Enron Entity | Responsible Attorney | [NAME] | Date of Liquidation | Contract(s) Terminated | Liquidation Amount | Comments
Giant Refining Company | Enron North America Corp. |  |  | 2001-12-01 00:00:00 | Enfolio Firm Confirm No. 1035543 | None | As of Termintion Date, ENA shall not be obligated to sell and deliver and Cpy shall not be obligated to purchase and receive.
Giant Refining Company | Enron North America Corp. |  |  | 2001-12-01 00:00:00 | Enfolio Firm Confirm No. 1176046 | None | As of Termintion Date, ENA shall not be obligated to sell and deliver and Cpy shall not be obligated to purchase and receive.
Giant Refining Company | Enron North America Corp. |  |  | 2001-12-01 00:00:00 | Enfolio Firm Confirm No. 1176056 | None | As of Termintion Date, ENA shall not be obligated to sell and deliver and Cpy shall not be obligated to purchase and receive.
Spreadsheet: ec386f84-7e45-46ff-a32f-61648fb0df92
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6864 | 8131 | Tiare | Lund | NZL | 987 | 00:00:00 | 00:00:00 | 04:44:18 | 00:05:29 | 03:09:03 | 1 | 07:58:49
6864 | 54014 | [NAME] | Lockwood | USA | 986 | 00:00:00 | 00:00:00 | 05:35:55 | 00:04:31 | 03:26:35 | 2 | 09:07:01
6864 | 54011 | [NAME] | Minor | USA | 985 | 00:00:00 | 00:00:00 | 05:33:46 | 00:06:13 | 00:00:00 | DNS | 00:00:00
Spreadsheet: 168789d1342581526-extending-formulas-containing-worksheets-phat-routine
Sheet: % of Bodyweight (Bench)

 |  | BENCH PRESS
 | Bodyweight (KG) | Weight Lifted (KG) | Reps | 1RM | % of BW
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Week 11
Week 12
Week 13
Week 14
Week 15
Week 16
Week 17
Week 18
Week 19
Week 20
Week 21
Week 22
Week 23
Week 24
Week 25
Week 26
Week 27
Week 28
Week 29
Week 30
Week 31
Week 32
Week 33
Week 34
Week 35
Week 36
Week 37
Week 38
Week 39
Week 40
Week 41
Week 42
Week 43
Week 44
Week 45
Week 46
Week 47
Week 48
Week 49
Week 50
Week 51
Week 52
Spreadsheet: 09123603-e64c-469e-b404-ed581fd92e5d
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
[NAME] | Men's Soccer | Hartford (WVU Nike Classic) | 12:00 AM | W, 2-1
08/27/2012 | Men's Soccer | [NAME] (WVU Nike Classic) | 12:00 AM | W, 1-0
08/31/2012 | Men's Soccer | at North Carolina | 12:00 AM | L, 0-1
09/02/2012 | Men's Soccer | at Wake Forest | 12:00 AM | L, 0-1
09/06/2012 | Men's Soccer | at Penn State | 12:00 AM | T, 0-0 (2OT)
[NAME] | Men's Soccer | Oakland | 12:00 AM | W, 4-2
09/15/2012 | Men's Soccer | American | 12:00 AM | W, 2-0
09/23/2012 | Men's Soccer | Florida Atlantic* | 12:00 AM | W, 4-0
09/26/2012 | Men's Soccer | Iona | 12:00 AM | W, 3-1
09/29/2012 | Men's Soccer | at Western Michigan* | 12:00 AM | T, 1-1 (2OT)
10/02/2012 | Men's Soccer | Elon | 12:00 AM | L, 2-3
10/07/2012 | Men's Soccer | Buffalo* | 12:00 AM | W, 2-0
10/14/2012 | Men's Soccer | Hartwick* | 12:00 AM | W, 3-1
10/20/2012 | Men's Soccer | at Akron* | 12:00 AM | L, 1-2
10/27/2012 | Men's Soccer | at Northern Illinois* | 12:00 AM | L, 0-1
10/30/2012 | Men's Soccer | [NAME] | 12:00 AM | Cancelled
11/03/2012 | Men's Soccer | at Bowling Green* | 12:00 AM | W, 1-0
11/09/2012 | Men's Soccer | vs. Northern Illinois (MAC Semifinals) | 12:00 AM | L, 0-1
Spreadsheet: 16a94a1a-16fd-4d0e-b4af-56bc3c1a9a60
Sheet: Sheet1

Table 7--U.S. feed grain imports by selected sources (1,000 metric tons) 1/, 7/15/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Import and country/region |  | ---------- 2010/11 ---------- |  | ---------- 2011/12 ---------- |  | ---------- 2012/13 ----------
 |  | Mkt year | [NAME] | Mkt year | [NAME] | Mkt year | [NAME]
Oats | Canada | 1393.292808 | 1393.292808 | 1556.499397 | 1556.499397 | 1590.304046 | 1590.304046
 | Finland | 73.93257200000001 | 73.932572 | 34.84057 | 34.84057
 | Jamaica | 0.159212 | 0.159212 | 0.285218 | 0.285218
 | All other countries | 0.264317 | 0.264317 | 29.802409 | 29.802409 | 9.787764 | 9.787764
 | Total 2/ | 1467.648909 | 1467.648909 | 1621.427594 | 1621.427594 | 1600.09181 | 1600.09181
Malting barley | Canada | 174.724159 | 174.724159 | 263.660306 | 263.660306 | 342.0999420000001 | 342.099942
 | All other countries | 0.006579999999999999 | 0.006579999999999999 | 0.244638 | 0.244638 | 0.06603 | 0.06603
 | Total 2/ | 174.730739 | 174.730739 | 263.904944 | 263.904944 | 342.165972 | 342.165972
Other barley 3/ | Canada | 30.69757099999999 | 30.697571 | 89.27383699999999 | 89.27383699999999 | 160.983119 | 160.983119
 | All other countries | 1.288141 | 1.288141 | 0.7575110000000002 | 0.7575109999999999 | 3.99892 | 3.99892
 | Total 2/ | 31.985712 | 31.985712 | 90.031348 | 90.031348 | 164.982039 | 164.982039
1/ Grain only. Market year (June-May) and market year to date. 2/ Totals may not add due to rounding.
3/ Grain for purposes other than malting, such as feed and seed use. Source: U.S. Department of Commerce, Bureau of the Census, Foreign Trade Statistics.
Date run: 7/12/2013
Spreadsheet: 875332d1721917334-how-to-automatically-filter-multiple-arrays-of-data-by-their-relevant-headings-lookup-sheet-test
Sheet: AccidentHazardData

AccidentHazardID | AccidentID | HazardID | Sequence | Contribution | Priority
602092 | 358056 | 519486 |  |  | 1
602093 | 358057 | 519487 |  |  | 1
602094 | 358056 | 519487 |  |  | 1
602095 | 358059 | 519488 |  |  | 1
602096 | 358062 | 519489 |  |  | 1
602097 | 358050 | 519490 |  |  | 1
602098 | 358049 | 519491 |  |  | 1
656755 | 358059 | 519491 |  |  | 1
602099 | 358054 | 519492
602100 | 358061 | 519493
602101 | 358061 | 519494 |  |  | 1
602102 | 358051 | 519495 |  |  | 1
656754 | 358059 | 519495 |  |  | 1
602103 | 358055 | 519496
602104 | 358054 | 519496
602105 | 358063 | 519497
602106 | 358066 | 519497
602107 | 358054 | 519498 |  |  | 1
661418 | 358055 | 519498 |  |  | 1
602108 | 358054 | 519499 |  |  | 1
661417 | 358055 | 519499
602109 | 358063 | 519500
602110 | 358064 | 519500
602111 | 358066 | 519500
602112 | 358065 | 519500
602113 | 358060 | 519500 |  |  | 1
602114 | 358065 | 519501
602115 | 358055 | 519502
656753 | 358054 | 519502
656757 | 358056 | 519502 |  |  | 1
602116 | 358056 | 519503 |  |  | 1
602117 | 358053 | 519504 |  |  | 1
602118 | 358065 | 519504
602119 | 358063 | 519505
602120 | 358058 | 519506 |  |  | 1
602121 | 358057 | 519507 |  |  | 1
602122 | 358059 | 519507 |  |  | 1
656756 | 358056 | 519507 |  |  | 1
602123 | 358048 | 519508
602124 | 358052 | 519509 |  |  | 1
602126 | 358062 | 519510 |  |  | 1
602127 | 358063 | 519511
602128 | 358064 | 519511
602129 | 358066 | 519511
661419 | 358055 | 519511 |  |  | 1
602130 | 358057 | 519512 |  |  | 1
602131 | 358056 | 519512 |  |  | 1
602132 | 358053 | 519513 |  |  | 1
602133 | 358056 | 519514 |  |  | 1
602134 | 358056 | 519515 |  |  | 1
602135 | 358056 | 519516 |  |  | 1
602136 | 358060 | 519517 |  |  | 1
602137 | 358062 | 519518 |  |  | 1
602138 | 358062 | 519519
602139 | 358062 | 519520
602140 | 358066 | 519521
602141 | 358064 | 519521
602142 | 358065 | 519521
602143 | 358060 | 519521 |  |  | 1
602144 | 358063 | 519521
602145 | 358066 | 519522
602146 | 358060 | 519522 |  |  | 1
602147 | 358064 | 519522
602148 | 358063 | 519522
602149 | 358064 | 519523
602150 | 358066 | 519523
602151 | 358060 | 519523 |  |  | 1
602152 | 358063 | 519523
602153 | 358065 | 519524
Spreadsheet: 106516d1303787677-conditional-formatting-help-needed-cfolderthantodayminus
Sheet: Sheet1

 |  |  | << Today
Spreadsheet: 884621d1733843870-need-to-add-quarter-end-dates-minus-2-months-to-formula-dates
Sheet: Sheet1

 |  |  |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  | Quarterly |  |  |  |  | 2024-09-30 00:00:00
 |  |  |  |  | 2024-02-01 00:00:00 |  |  |  |  |  |  |  | Quarterly |  |  |  |  | 2023-12-29 00:00:00
 |  |  |  |  | 2024-03-01 00:00:00 |  |  |  |  |  |  |  | Quarterly |  |  |  |  | 2023-12-29 00:00:00
 |  |  |  |  | 2024-04-01 00:00:00 |  |  |  |  |  |  |  | Quarterly |  |  |  |  | 2023-12-29 00:00:00
 |  |  |  |  | 2024-05-01 00:00:00 |  |  |  |  |  |  |  | Quarterly |  |  |  |  | 2024-03-28 00:00:00
 |  |  |  |  | 2024-06-01 00:00:00 |  |  |  |  |  |  |  | Quarterly |  |  |  |  | 2024-03-28 00:00:00
 |  |  |  |  | 2024-07-01 00:00:00 |  |  |  |  |  |  |  | Quarterly |  |  |  |  | 2024-03-28 00:00:00
 |  |  |  |  | 2024-08-01 00:00:00 |  |  |  |  |  |  |  | Quarterly |  |  |  |  | 2024-06-28 00:00:00
 |  |  |  |  | 2024-09-01 00:00:00 |  |  |  |  |  |  |  | Quarterly |  |  |  |  | 2024-06-28 00:00:00
 |  |  |  |  | 2024-10-01 00:00:00 |  |  |  |  |  |  |  | Quarterly |  |  |  |  | 2024-06-28 00:00:00
 |  |  |  |  | 2024-11-01 00:00:00 |  |  |  |  |  |  |  | Quarterly |  |  |  |  | 2024-09-30 00:00:00
 |  |  |  |  | 2024-12-01 00:00:00 |  |  |  |  |  |  |  | Quarterly |  |  |  |  | 2024-09-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column R is current formula I am using
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column R should return what is in Column S
Spreadsheet: 810182d1671589031-combine-data-in-2-rows-into-1-single-row-bbl_data_2-rows-merge
Sheet: Output

 | Team Name |  | Result |  | PREPLAY_LAST_TRADED_PRICE |  | PREPLAY_MIN_PRICE |  | PREPLAY_MAX_PRICE |  | INPLAY_MIN_PRICE |  | INPLAY_MAX_PRICE
Date | T1 | T2 | T1 result | T2 result | P_LTP T1 | P_LTP T2 | P_MIN T1 | P_MIN T2 | P_MAX T1 | P_MAX T2 | I_MIN T1 | I_MIN T2 | I_MAX T1 | I_MAX T2
2015-12-17 00:00:00 | [NAME] | [NAME] | W | L | 1.88 | 2.14 | 1.85 | 1.51 | 2.5 | 2.16 | 1.01 | 1.72 | 2.4 | 1000
 | [NAME] | [NAME] | W | L | 1.88 | 2.14 | 1.85 | 1.51 | 2.5 | 2.16 | 1.01 | 1.72 | 2.4 | 1000
2015-12-18 00:00:00 | [NAME] | Adealide Strikers | L | W | 1.57 | 2.76 | 1.53 | 2.1 | 1.73 | 2.9 | 1.23 | 1.01 | 1000 | 5.2
2015-12-19 00:00:00 | [NAME] | Melbourne Renegades | L | W | 2.58 | 1.63 | 2.18 | 1.59 | 2.64 | 1.85 | 1.43 | 1.01 | 1000 | 3.25
2015-12-20 00:00:00 | [NAME] | [NAME] | L | W | 2 | 1.99 | 1.96 | 1.66 | 2.34 | 2.04 | 1.56 | 1.01 | 1000 | 2.7
2015-12-20 00:00:00 | [NAME] | [NAME] | L | W | 1.6 | 2.66 | 1.48 | 2.36 | 1.73 | 3.05 | 1.1 | 1.01 | 20 | 11
2015-12-21 00:00:00 | [NAME] | Adelaide Strikers | L | W | 1.61 | 2.64 | 1.48 | 2.42 | 1.7 | 3 | 1.46 | 1.01 | 1000 | 3.15
2015-12-22 00:00:00 | [NAME] | [NAME] | L | W | 2.38 | 1.73 | 2.06 | 1.52 | 2.48 | 1.94 | 1.94 | 1.01 | 1000 | 2.08
Spreadsheet: 267357d1380052350-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-mailing-address-state-county-fips-codes
Sheet: IOWA-14

 | COUNTY | CODE
 | Adair | 1
 | Adams | 3
 | Allamakee | 5
 | Appanoose | 7
 | Audubon | 9
 | [NAME] | 11
 | Black Hawk | 13
 | Boone | 15
 | Bremer | 17
 | [NAME] | 19
 | [NAME] | 21
 | Butler | 23
 | [NAME] | 25
 | Carroll | 27
 | [NAME] | 29
 | Cedar | 31
 | [NAME] | 33
 | Cherokee | 35
 | Chickasaw | 37
 | Clarke | 39
 | Clay | 41
 | [NAME] | 43
 | [NAME] | 45
 | Crawford | 47
 | Dallas | 49
 | [NAME] | 51
 | Decatur | 53
 | Delaware | 55
 | Des Moines | 57
 | Dickinson | 59
 | Dubuque | 61
 | Emmet | 63
 | Fayette | 65
 | [NAME] | 67
 | Franklin | 69
 | Fremont | 71
 | Greene | 73
 | [NAME] | 75
 | Guthrie | 77
 | [NAME] | 79
 | Hancock | 81
 | Hardin | 83
 | [NAME] | 85
 | [NAME] | 87
 | [NAME] | 89
 | Humboldt | 91
 | Ida | 93
 | Iowa | 95
 | [NAME] | 97
 | Jasper | 99
 | [NAME] | 101
 | [NAME] | 103
 | Jones | 105
 | Keokuk | 107
 | Kossuth | 109
 | [NAME] | 111
 | [NAME] | 113
 | [NAME] | 115
 | Lucas | 117
 | Lyon | 119
 | [NAME] | 121
 | Mahaska | 123
 | Marion | 125
 | [NAME] | 127
 | Mills | 129
 | Mitchell | 131
 | Monona | 133
 | Monroe | 135
 | Montgomery | 137
 | Muscatine | 139
 | [NAME] | 141
 | Osceola | 143
 | Page | 145
 | Palo Alto | 147
 | Plymouth | 149
 | Pocahontas | 151
 | Polk | 153
 | Pottawattamie | 155
 | Poweshiek | 157
 | [NAME] | 159
 | Sac | 160
 | Scott | 163
 | Shelby | 165
 | Sioux | 167
 | Story | 169
 | Tama | 171
 | [NAME] | 173
 | Union | 175
 | [NAME] | 177
 | Wapello | 179
 | [NAME] | 181
 | Washington | 183
 | Wayne | 185
 | [NAME] | 187
 | Winnebago | 189
 | Winneshiek | 191
 | Woodbury | 193
 | Worth | 195
 | [NAME] | 197
Spreadsheet: 774167d1648254441-calculating-due-installment-dates-based-on-duration-number-of-instalments-qoutation-creator-sample
Sheet: data

 | payments | owner | IBAN | account name | location | unit number | unit type | contract type | [NAME] payment | contract type |  | طريقه الدفع | payment types
 | 1 | [NAME] youssef | 111111 | [NAME] youssef |  |  | studio | commercial | in advance مقدما | new contract |  | تحويل بنكى Bank transfer | Bank tranfer
 | 2 |  |  |  |  |  | 1BHK | residential | with installments مع الدفعات | contract renew |  | شيك Cheque | cheque
 | 3 |  |  |  |  |  | 2BHK | industrial |  | contract extension |  | نقدى cash | cash and cheque
 | 4 |  |  |  |  |  | 3BHK |  |  |  |  | نقدي و شيك cash and cheque
 | 5 |  |  |  |  |  | 4BHK
 | 6 |  |  |  |  |  | 5BHK
 |  |  |  |  |  |  | Office
 |  |  |  |  |  |  | Shop
 |  |  |  |  |  |  | Workshop
 |  |  |  |  |  |  | Showroom
 |  |  |  |  |  |  | Warehouse
 |  |  |  |  |  |  | Factory
 |  |  |  |  |  |  | Villa