tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 53354d1253224059-excel-2007-bar-chart-x-axis-labels-show-up-vertical-profit-and-loss-account-example-091609b
Sheet: Variables

 | start year |  | Selected Year [NAME]
 | end year
 | Years
 |  |  | Chart Title
Spreadsheet: sally_beck__35756__MgmtSum-Q1-0222
Sheet: Whalley

ENRON NORTH AMERICA
1ST QUARTER 2000 EARNINGS ESTIMATE
Results based on Activity through February 17, 2000
 |  | Earnings Before Tax |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Estimate | Plan | [NAME] |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expense | Expense | Total
Gas Trading
Power Trading
Financial Drift
Financial Trading
Canada
Coal
Weather
Emissions
Insurance Group
Gas Assets - Trading
Executive Trading
Total Trading & Risk Mgt.
Spreadsheet: 202312d1356501962-email-to-multiple-people-in-a-sheet-email_distribution_list
Sheet: Distribution_List

 |  | [NAME] | TAB | Ranges
 |  | [EMAIL] | Report 1 | B2:d25
 |  |  | Report 2 | B2:K27
 |  |  | Report 3 | B2:K29
 |  | [EMAIL] | Report 1 | B2:K25
 |  |  | Report 2 | B2:K27
 |  | [EMAIL] | Report 1 | B2:K25
 |  |  | Report 3 | B2:K16
 |  | [EMAIL] | Report 1 | B2:K25
 |  |  | Report 3 | B17:K29
Spreadsheet: 197886d1354598471-automatically-enter-time-and-date-sign-out-log
Sheet: Sheet1

DON'T COPY CELLS/CLEAR MONTHLY
Date | Initial | Name | Time Out | Radio | Key | Comments/Other | Initial | Time In
2012-12-03 00:00:00 | JPH | POL 1 | 2012-12-03 15:24:17 | 10
2012-12-03 00:00:00 | JPH | CALLAHAN | 2012-12-03 15:25:08 | 8 |  |  | JPH | 09:49:00
Spreadsheet: 737999d1624734477-change-specific-column-letter-inside-formula-for-drag-down-keto-food-calculator-copy
Sheet: Monat Juli Statistik

Datum | Kohlenhydrate | Protein | [NAME] | kcal | [NAME] | Vitamin A | Vitamin B1 | Vitamin B2 | [NAME] | [NAME] | Niacin | Folat | Pantothensäure | Vitamin C | Vitamin D | Vitamin E | Natrium | Kalium | Chlorid | Calcium | Magnesium | Phosphor | Eisen | Jod | Zink | Selen
2021-07-01 00:00:00
2021-07-02 00:00:00
2021-07-03 00:00:00
2021-07-04 00:00:00 | …
2021-07-05 00:00:00 | …
2021-07-06 00:00:00 | …
2021-07-07 00:00:00
2021-07-08 00:00:00
2021-07-09 00:00:00
2021-07-10 00:00:00
2021-07-11 00:00:00
2021-07-12 00:00:00
2021-07-13 00:00:00
2021-07-14 00:00:00
2021-07-15 00:00:00
2021-07-16 00:00:00
2021-07-17 00:00:00
2021-07-18 00:00:00
2021-07-19 00:00:00
2021-07-20 00:00:00
2021-07-21 00:00:00
2021-07-22 00:00:00
2021-07-23 00:00:00
2021-07-24 00:00:00
2021-07-25 00:00:00
2021-07-26 00:00:00
2021-07-27 00:00:00
2021-07-28 00:00:00
2021-07-29 00:00:00
2021-07-30 00:00:00
2021-07-31 00:00:00
Spreadsheet: 815790d1675198437-countif-issue-across-multiple-criteria-dummy_logic
Sheet: CRV_Not_Meters

Account Number | Contract Number | Visit Type | Date of Visit | Operative Name | Overall Outcomes | ID | Single / Dual
ABC | C-001 |  |  | [NAME] |  | AAA
ABC | C-002 |  |  | [NAME] |  | AAA
ABC | C-003 |  |  | [NAME] |  | BBB
XYZ | C-004 |  |  | [NAME] |  | BBB
Spreadsheet: 824398d1680542029-comparing-two-lists-with-multiple-columns-lists
Sheet: VLOOKUP

La liste 2017 (au bas) contient les numéros
[NAME] transférer a la liste 2021.
J'ai mélangé les noms, sur la liste 2021
[NAME] fonctionne
Cette méthode utilise les "array" et a la fin
pour "entrer" la formule is faut faire
CTRL+SHIFT+ENTER puisqu'il y a un
un "array" dans la formule
Liste 2021
Arsenault | Stéphane | V
Eastwood | [NAME] | v
Arcand | [NAME] | A
Rozon | Gilles
Kelso | [NAME]
Du Preez | [NAME]
Cross | [NAME] | X
Beaulieu | Michel
Legault | [NAME]
Covo | [NAME] | V
Roman | [NAME]
Liste 2021 (sans les #N/A)
Arsenault | Stéphane | V
Eastwood | [NAME] | v
Arcand | [NAME] | A
Rozon | Gilles
Kelso | [NAME]
Du Preez | [NAME]
Cross | [NAME] | X
Beaulieu | Michel
Legault | [NAME]
Covo | [NAME] | V
Roman | [NAME]
Nouvelle liste (on met la cellule vide si elle
contient des 0)
Arsenault | Stéphane | V
Eastwood | [NAME] | v
Arcand | [NAME] | A
Rozon | Gilles
Kelso | [NAME]
Du Preez | [NAME]
Cross | [NAME] | X
Beaulieu | Michel
Legault | [NAME]
Covo | [NAME] | V
Roman | [NAME]
Liste 2017
Arsenault | Stéphane | V | 697-7803
Covo | [NAME] | V
Eastwood | [NAME] | v | 695-3197
Arcand | [NAME] | A | 695-2732
Beaulieu | Michel
Legault | [NAME]
Rozon | Gilles |  | 695-6565
Cross | [NAME] | X | 694-4895
Kelso | [NAME]
Du Preez | [NAME]
Spreadsheet: 526085d1499107786-multiple-criteria-within-date-range-and-matching-value-within-row-excelforum
Sheet: BeforeSheet1

Date Obtained | One week before date obtained | One week after date obtained | Identifier
2015-01-30 00:00:00 |  |  | ABC123
2014-01-30 00:00:00 |  |  | ABC123
2013-01-30 00:00:00 |  |  | ABC123
2012-01-30 00:00:00 |  |  | ABC123
2015-12-30 00:00:00 |  |  | ABC456
2014-12-30 00:00:00 |  |  | ABC456
2013-12-30 00:00:00 |  |  | ABC456
2012-12-30 00:00:00 |  |  | ABC456
Spreadsheet: 75895d1276512825-average-of-value-in-different-cells-in-multiple-worksheet-test-vsb-reco-201011-and-summary-sheet
Sheet: Dec'10

 |  | [NAME]
 |  | Monthly Reconciliation
 |  | 2010-12-31 00:00:00
 |  | Summary of Stocks
 |  | New Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Used Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals |  | Units over | % Of Stock
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value | 70 Days | Overage
 |  | Stock 1 |  |  |  |  |  |  | 0 | 0
 |  | Stock 2 |  |  |  |  |  |  | 0 | 0
 |  | Stock 3 |  |  |  |  |  |  | 0 | 0
 |  | Stock 4 |  |  |  |  |  |  | 0 | 0
 |  | Stock 5 |  |  |  |  |  |  | 0 | 0
 |  | Stock 6 |  |  |  |  |  |  | 0 | 0
 |  | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 93895d1293658320-formula-for-sport-rankings-cagrapplerrankings2010
Sheet: 285

Ranking | First Name | Last Name | School | Section | Grade
1 | Gavin | [NAME] | Granite Bay | SJ | 11 | 2010 CIF 5
2 | [NAME] | Elor | College Park | NC | 12
3 | [NAME] | [NAME] | Servite | SS | 12 | 2010 CIF t12
4 | [NAME] | Wood | Lemoore | CS | 12 | reno 2
5 | [NAME] | Case | Rancho [NAME] | SD | 12
6 | [NAME] | [NAME] | Vista | SD | 12
7 | Dominick | [NAME] | Homestead | CC | 11
8 | [NAME] | Fusi | Corona | SS | 12
9 | Brain | [NAME] | Diamond Bar | SS | 12
10 | [NAME] | Rocha | [NAME] | SJ | 12 | reno t12
11 | Zach | Smith | [NAME] | SS | 12 | reno t12
12 | Narciso | [NAME] | Sanger | CS | 11 | reno t12
13 | Nick | Nevills | Clovis | CS | 9 | zink 1
Spreadsheet: 782032d1653718857-pulling-min-data-from-another-sheet-error-detection-daily-tickets-report-forums-
Sheet: Daily Tickets Report

FreshDesk | Open Tickets | Pending Tickets | Oldest Open Response
Total Open
CallTek | Open Tickets |  | Oldest Ticket Age
Tier - 1 (Calltek-Guest) |  |  |  |  |  |  | [NAME]
Tier - 2 (Calltek-NOC) |  |  |  |  |  |  | HKI-NOC
Tier - 3 (HIS-NOC) |  |  |  |  |  |  | HKI NOC USA
BeyondTV Support |  |  |  |  |  |  | BeyondTV Support
Total Open |  |  |  |  |  |  | [NAME]
Kentrone | Open Tickets |  | Oldest Ticket Age
Tier - 1 |  |  |  |  |  |  | Open Level 1 - CallBack/Follow Up
Tier - 2 |  |  |  |  |  |  | Open Level 2 - Escalated to Supervisor
Tier - 3 |  |  |  |  |  |  | Open Level 3 - Client
Total Open
CRM | Open Tickets |  | Oldest Ticket Age |  | Open | Oldest
[NAME] |  |  | 2020-07-16 00:00:00
[NAME] |  |  | 2021-08-07 00:00:00
[NAME] |  |  | 2022-02-03 00:00:00
[NAME] |  |  | 2022-03-03 00:00:00
[NAME] |  |  | 2022-03-31 00:00:00
[NAME] [NAME] |  |  | 2022-04-20 00:00:00 |  |  |  | << Remove space at A26
[NAME] |  |  | 2022-04-20 00:00:00
[NAME] |  |  | 2022-05-02 00:00:00
[NAME]
[NAME]
[NAME]
Nate Thibault
[NAME]
Total Open
 | DO NOT COPY ZERO ROWS
Spreadsheet: 866864d1713789334-scatter-plot-data-labels-duplicating-sample-worksheet
Sheet: pivot

Row Labels | Sum of Income |  |  |  | X | Y | Amount | [NAME] | Without Max | Both
Usage fees | 7700 |  |  | Usage fees | 1 | 3
Subscription | 6892.2 |  |  | Subscription | 7 | 2
Renting | 5492.639999999999 |  |  | Renting | 4 | 1
Licensing | 15092.76 |  |  | Licensing | 2 | 8
Asset sale | 7260 |  |  | Asset sale | 5 | 9
Advertising | 10984.92 |  |  | Advertising | 6 | 6
Grand Total | 53422.52
 |  |  |  | Data Labels "Duplicate" when using the slicer
Spreadsheet: eric_saibi__9739__011402R
Sheet: Keystone 01

Owner Name |  | Reliant Energy
Station Name |  | Keystone Power Station
Unit Name |  | Keystone 01
NERC Region |  | MAAC
State |  | PA
Fuel Type |  | Coal
Capacity |  | 936 MW
Start Date |  | 2002-01-10 00:00:00
End Date |  | 2002-01-13 00:00:00
Prv. Start Date |  | 2002-01-10 00:00:00
Prv. End Date |  | 2002-01-16 00:00:00
Comments |  | Unplanned Repairs
SIC |  | 4931
Plant ID |  | 1016346
Unit ID |  | 1004381
Outage ID |  | 19436
Spreadsheet: 356397d1415098707-retrieving-a-value-based-on-comparison-of-multiple-columns-sample_dataset-1-
Sheet: Sheet1

userid | date | feedback_id |  |  | userid | date | feedback_id | rating |  |  | Desired output: | userid | date | feedback_id | rating
[EMAIL] | 2014-08-27 00:00:00 | P00061 |  |  | [EMAIL] | 2014-08-27 00:00:00 | P00061 | 1 |  |  |  | [EMAIL] | 2014-08-27 00:00:00 | P00061 | 1
[EMAIL] | 2014-08-28 00:00:00 | QD00026 |  |  | [EMAIL] | 2014-08-31 00:00:00 | P00053 | 2 |  |  |  | [EMAIL] | 2014-08-28 00:00:00 | QD00026
[EMAIL] | 2014-09-25 00:00:00 | QD00038 |  |  | [EMAIL] | 2014-08-25 00:00:00 | QD00023 | 3 |  |  |  | [EMAIL] | 2014-09-25 00:00:00 | QD00038
[EMAIL] | 2014-08-31 00:00:00 | P00053 |  |  | [EMAIL] | 2014-09-01 00:00:00 | QD00015 | 2 |  |  |  | [EMAIL] | 2014-08-31 00:00:00 | P00053 | 2
[EMAIL] | 2014-08-25 00:00:00 | QD00023 |  |  | [EMAIL] | 2014-08-26 00:00:00 | QD00024 | 5 |  |  |  | [EMAIL] | 2014-08-25 00:00:00 | QD00023 | 3
[EMAIL] | 2014-09-17 00:00:00 | QD00030 |  |  | [EMAIL] | 2014-08-26 00:00:00 | QD00024 | 6 |  |  |  | [EMAIL] | 2014-09-17 00:00:00 | QD00030
[EMAIL] | 2014-08-28 00:00:00 | [NAME] |  |  | [EMAIL] | 2014-09-26 00:00:00 | QD00039 | 3 |  |  |  | [EMAIL] | 2014-08-28 00:00:00 | [NAME]
[EMAIL] | 2014-08-28 00:00:00 | P00012 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-08-28 00:00:00 | P00012
[EMAIL] | 2014-09-01 00:00:00 | QD00015 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-09-01 00:00:00 | QD00015 | 2
[EMAIL] | 2014-08-26 00:00:00 | QD00024 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-08-26 00:00:00 | QD00024 | 5
[EMAIL] | 2014-08-26 00:00:00 | QD00024 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-08-26 00:00:00 | QD00024 | 6
[EMAIL] | 2014-09-26 00:00:00 | QD00039 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-09-26 00:00:00 | QD00039 | 3
[EMAIL] | 2014-09-19 00:00:00 | QD00032 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-09-19 00:00:00 | QD00032
[EMAIL] | 2014-09-16 00:00:00 | QD00029 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-09-16 00:00:00 | QD00029
[EMAIL] | 2014-08-27 00:00:00 | P00061 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-08-27 00:00:00 | P00061
Spreadsheet: 767373d1644430417-using-ifisnumber-match-along-rows-to-cover-specific-date-period-book1
Sheet: Data with formula

 |  |  |  | Either Exp Date would need to cover thru 12/31/2024
Entity | Space | DBA | Begin Date 1 | Expiration Date 1 | Expiration Date 2 | FORMULA NOT WORKING | WHAT IT SHOULD BE
117 | 1 | Yogurt | 2003-07-31 00:00:00 |  | 2023-01-31 00:00:00
117 | 1 | Yogurt | 2023-02-01 00:00:00 |  | 2028-01-31 00:00:00
117 | 2 | Insurance | 2018-10-31 00:00:00 |  | 2021-10-31 00:00:00 |  | Needs a new row to go out to end of 2024
117 | 3 | Mr. [NAME] | 2018-09-14 00:00:00 |  | 2023-09-30 00:00:00
117 | 3 | vacant assumption | 2023-10-01 00:00:00 |  | 2026-09-30 00:00:00
117 | 4 | Furniture | 2020-11-01 00:00:00 |  | 2024-09-30 00:00:00 |  | Needs a new row to go out to end of 2024
118 | 5 | Restaurant 1 | 1999-10-30 00:00:00 |  | 2026-04-30 00:00:00
118 | 6 | Dry Cleaners | 1995-10-10 00:00:00 |  | 2022-05-31 00:00:00
118 | 6 | vacant assumption | 2024-12-01 00:00:00 |  | 2029-11-30 00:00:00
118 | 7 | Bank 1 | 2011-12-05 00:00:00 |  | 2027-12-31 00:00:00
118 | 8 | Restaurant 2 | 2001-01-18 00:00:00 | 2021-02-28 12:00:00 | 2021-02-28 00:00:00 |  | Needs a new row to go out to end of 2024
118 | 32 | Restaurant 3 | 2023-01-01 00:00:00 |  | 2024-06-01 00:00:00 |  | Needs a new row to go out to end of 2024
120 | 33 | Restaurant 1 | 2001-01-18 00:00:00 | 2024-12-01 00:00:00 | 2024-11-01 00:00:00
120 | 1 | Shoes | 2001-01-18 00:00:00 | 2022-03-01 00:00:00 | 2022-06-01 00:00:00
120 | 1 | New | 2022-07-01 00:00:00 |  | 2023-08-01 00:00:00 |  | Needs a new row to go out to end of 2024
Spreadsheet: 29447d1224489050-dynamic-chart-based-on-chosen-radio-button-659184
Sheet: Sheet1

 |  |  |  |  |  |  | 6
 | ONE | TWO | THREE | FOUR | FIVE | SIX | SIX
a | 0.4983753682781922 | 0.008938954663102905 | 0.219282614841287 | 0.5359040160103907 | 0.8617462821917652 | 0.9560528299847002 | 0.9560528299847002
b | 0.9692936239981693 | 0.3854182732315548 | 0.2089340514302103 | 0.1459717765893291 | 0.04034561197949404 | 0.4518041708628608 | 0.4518041708628608
c | 0.5923438962128449 | 0.2806152949021323 | 0.6686165704142439 | 0.6898601590955904 | 0.3469965785887243 | 0.5974448723809296 | 0.5974448723809296
d | 0.03660849985790482 | 0.5583684499067352 | 0.05257518716906384 | 0.1150319670133255 | 0.6465896165223146 | 0.06207742693589058 | 0.06207742693589058
e | 0.995060001350982 | 0.7173962709787454 | 0.9039920554143963 | 0.03776991306151367 | 0.7178549861592938 | 0.8869704008415848 | 0.8869704008415848
Spreadsheet: 86941bec-7746-4793-b59d-ada9820bf335
Sheet: Sheet1

Public Service Commissioner (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 6/20/2013 6:40:21 AM
Precincts Reporting: 567/567 - Total Ballots Cast: 220479
2006 General Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] | TOTALS
Precinct 2001 | 80 | 46 | 126
Precinct 2002 | 102 | 81 | 183
Precinct 2003 | 58 | 73 | 131
Precinct 2004 | 44 | 56 | 100
Precinct 2005 | 70 | 52 | 122
Precinct 2006 | 40 | 32 | 72
Precinct 2007 | 139 | 166 | 305
Precinct 2008 | 85 | 91 | 176
Precinct 2009 | 144 | 122 | 266
Precinct 2010 | 150 | 159 | 309
Precinct 2011 | 124 | 126 | 250
Precinct 2012 | 162 | 155 | 317
Precinct 2013 | 147 | 111 | 258
TOTAL | 1345 | 1270 | 2615
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 124011d1317997135-excel-2007-vlookup-enter-same-look-up-and-populate1
Sheet: Sheet3

A | B | C | A
A |  |  |  |  | A
Spreadsheet: 812874d1673434846-help-with-datedif-function-help-please-beamer
Sheet: גיליון1

 |  |  |  |  |  | results |  | wanted results
 |  | years | months |  |  | years | months | years | months
1995-01-01 00:00:00 | 1999-12-31 00:00:00 |  |  | 2014-09-01 00:00:00 | 2019-07-06 00:00:00 |  |  | 4 | 10
1996-01-11 00:00:00 | 2018-03-04 00:00:00 |  |  | 2010-02-01 00:00:00 | 2019-08-06 00:00:00 |  |  | 4 |  | 1 month between 06/08/2019-06/07/2019 + 4 years and 7 months between 2010 to 2014
1994-07-03 00:00:00 | 2022-03-04 00:00:00 |  |  | 2008-06-01 00:00:00 | 2013-12-31 00:00:00 |  |  | 1 | 8 | between 2008-2010
 |  |  |  | 2007-12-01 00:00:00 | 2008-03-02 00:00:00 |  |  | 0 | 4
 | SUM |  |  | 1998-03-07 00:00:00 | 2007-05-23 00:00:00 |  |  | 9 | 2
 |  |  |  | 1995-10-01 00:00:00 | 1998-04-20 00:00:00 |  |  | 2 | 5
 |  |  |  |  | SUM
Spreadsheet: 854115d1704098455-cubesetcount-function-filtrando-f-rmulas-com-slicer
Sheet: Slicer

 |  |  |  | Método com tabela |  |  |  |  | Método com LAMBDA
 |  |  |  | Slicer Selecionado | Atual | Orçamento | Variação |  | Slicer Selecionado | Atual | Orçamento | Variação
 |  |  |  | Echo | 249 | 220 | 29 |  | Echo | 249 | 220 | 29
 |  |  |  | Foxtrot | 123 | 200 | -77 |  | Foxtrot | 123 | 200 | -77
 |  |  |  | Golf | 112 | 150 | -38 |  | Golf | 112 | 150 | -38
Spreadsheet: 863344d1710863767-adding-max-to-formula-to-get-the-highest-number-when-solution-is-more-than-one-number-sample-to-limit-to-highest-score
Sheet: Sheet1

Sue | [NAME]
 |  |  | 133 | 115 | 118
 |  |  | 96 | 136 | 87
 |  |  | 106 | 141 | 97
 |  |  | 107 | 113 | 110
 |  |  | 91 | 116 | 122
 |  |  | 119 | 90 | 115
 |  |  | 143 | 136 | 88
 |  |  | 141 | 143 | 132
 |  |  | 160 | 179 | 112
 |  |  | 130 | 119 | 125
 |  |  | 86 | 134 | 127
 |  |  | 118 | 155 | 120
 |  |  | 128 | 112 | 106
 |  |  | 134 | 111 | 126
 |  |  | 154 | 110 | 128
 |  |  | 99 | 108 | 125
 |  |  | 89 | 138 | 122
 |  |  | 131 | 107 | 129
Limit Column L to the Highest Score in Columns D, E, and F
Spreadsheet: 62045d1262946959-timekeeping-example
Sheet: Sheet1

rr |  |  |  | =IF(ISBLANK(X1),"",ROW())
tt |  |  |  | then in AB1 and copy down
 |  |  |  | =IF(ROW(X1)-ROW(X$1)+1>COUNT(AA$1:AA$10),"",INDEX(X:X,[NAME]:AA$10,1+ROW(X1)-ROW(X$1))))
55
ty
66
Spreadsheet: 474227d1470678694-creating-a-follow-up-list-on-first-tab-of-large-spreadsheet-_help-474207d1470674878-creating-a-follow-up-list-on-first-tab-of-large-spreadsheet-_help-aaa
Sheet: Follow Up

I need a list of the accounts with follow up dates here (entire row) |  |  |  |  |  |  |  |  |  | Follow-up Date |  | 2016-08-10 00:00:00
# | Entity | X date | Carrier | Notes | Follow up | Phone Number
Spreadsheet: 799792d1665305357-counting-the-emails-that-match-another-column-while-so-matching-a-condition-in-another-example-question-etaf
Sheet: Sheet2

email | date
[EMAIL] | 2020-05-05 00:00:00 |  |  |  | [EMAIL] | mobile
[EMAIL] | 2020-05-05 00:00:00 |  |  |  | [EMAIL] | computer
[EMAIL] | 2020-05-06 00:00:00 |  |  |  | [EMAIL] | computer
[EMAIL] | 2020-05-06 00:00:00 |  |  |  | [EMAIL] | mobile
[EMAIL] | 2020-05-07 00:00:00 |  |  |  | [EMAIL] | mobile
[EMAIL] | 2020-05-07 00:00:00 |  |  |  | [EMAIL] | computer
Spreadsheet: 879464d1727005913-list-the-missing-number-in-2-columns-vice-versa-allanortiz-btk-spill-365-aligw
Sheet: Sheet1

 |  |  |  |  |  | Need formula to list numbers here | Need formula to list numbers here |  | Need formula to list numbers here | Need formula to list numbers here
Column 1 | Column 2 |  | Column 3 | Column 4 |  | Missing - what numbers in Col 1 but not Col 3 | Missing - what numbers in Col 3 but not Col 1 |  | Missing - what numbers in Col 2 but not Col 4 | Missing - what numbers in Col 4 but not Col 2
2500 | 2678 |  | 0 | 0 |  |  |  |  | 17856 | 750
555 | 17856 |  | 0 | 0 |  | 456 |  |  | 2678 | 4639
0 | 0 |  | 2500 | 2678
0 | 2678 |  | 966 | 0
649 | 0 |  | 0 | 14607
2500 | 0 |  | 0 | 2678
0 | 2678 |  | 2500 | 0
0 | 14607 |  | 649 | 0
2500 | 0 |  | 0 | 12828
966 | 0 |  | 0 | 2678
0 | 2678 |  | 2500 | 0
0 | 12828 |  | 910 | 0
456 | 0 |  | 0 | 13933
2500 | 0 |  | 0 | 2678
0 | 2678 |  | 2500 | 0
0 | 13933 |  | 597 | 0
910 | 0 |  | 0 | 3386
2500 | 0 |  | 0 | 2678
0 | 2678 |  | 2500 | 0
0 | 3386 |  | 745 | 0
597 | 0 |  | 0 | 2678
2500 | 0 |  | 0 | 16683
0 | 16683 |  | 2500 | 0
0 | 2678 |  | 815 | 0
745 | 0 |  | 0 | 5038
2500 | 0 |  | 0 | 2678
0 | 5038 |  | 2500 | 0
0 | 2678 |  | 924 | 0
2500 | 0 |  | 0 | 14797
815 | 0 |  | 0 | 750
924 | 14797 |  | 0 | 0
2500 | 0 |  | 0 | 4639
0 | 0 |  | 2500 | 2678
0 | 2678 |  | 796 | 0
Diff |  |  |  |  |  | Diff |  |  | Diff
Spreadsheet: a6a3969b-6601-47f9-a2e8-40af1df410fc
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
P1433 | Test | P1433 | 14-3-3 Protein, Spinal Fluid | 14-3-3 Protein, CSF | Immunochemiluminometric Assay (ICMA) | [NAME], round-bottom, plastic vial: ScwRBPl |  |  | 1 | mL | Collection Container/Tube: Sterile vial Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Obtain aliquot from second collection vial. 2. Immediately place aliquot on ice. Additional Information: 1. Specimens that have not been kept refrigerated, or which have been tested for other analytes previously, may give a false-positive result. 2. Hemolyzed specimens will give false-positive results. Specimens should be centrifuged to remove any red cells before shipping. The test will be canceled if there is any level of hemolysis present. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.6 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Normal: <1.5 ng/mL Elevated: > or =1.5 ng/mL; compatible with, but not diagnostic of, Creutzfeldt-Jakob disease | Monday, Thursday; 1 p.m. | 2 days | 6 days | 1 | 83520 |  |  |  |  | Rochester
P1433 | [NAME] | CSF | CSF |  |  |  | Refrigerated | 7 days
P1433 | Result | 82528 | 14-3-3 Protein, CSF | 14-3-3 Protein, CSF | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 36924-9 | 14-3-3 protein:MCnc:Pt:CSF:Qn:
Spreadsheet: e5533742-5f43-481e-8b32-68ceab193052
Sheet: H1.  Rating Factors

Exhibit H1:  Summary of Rating Factors
[NAME]:
Plan Type(s):
Market Segment:
Rate Effective Date:
 | A | B | C | D
 | Will your rates in this proposed Rate Filing vary by this characteristic? | If this rating characteristic was used in the past, indicate if there have been changes to the rating factors since the most recently approved rate filing? | Brief Description of "Other" Rating Factors | Rating Band (Ratio of Highest to Lowest Factor)
1.  Age/Gender |  |  | n/a
2.  Tobacco |  |  | n/a
3.  Health Underwriting |  |  | n/a
4.  [NAME] |  |  | n/a
5.  Industry |  |  | n/a
6.  Tier/Conversion Factors1 |  |  | n/a
Please list out all other variables by which rates will vary and provide responses to columns A and B
1
2
3
4
5
Notes:
1.  Tier or Conversion Factors are the factors that are applied the health coverage plan PMPM rate to arrive at a rate specific to a policyholder within a specific tier (e.g. 2 tier, 3 tier or 4 tier.)
Spreadsheet: 0cf80e6d-4330-4469-a6ce-5cccd687fb64
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 11. FINANCE COMMITMENTS, For Plant and Equipment: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Commercial Finance - Transport equipment ; |  |  | Original | A2413510X | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Commercial Finance - Other plant and equipment ; |  |  | Original | A2413511A | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Commercial Finance - Total ; |  |  | Original | A2413512C | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Lease Finance - Total ; |  |  | Original | A2413513F | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | DERIVED | Month | 1
TOTAL ; |  |  | Original | A2413514J | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 745380d1629892796-highlight-duplicate-name-based-on-birthdate-excel-forum-duplicates-query
Sheet: Sheet1

Name | DOB
[NAME] | 1966-02-01 00:00:00 | Duplicate of A4
[NAME] | 1987-07-03 00:00:00 | Duplicate of A8
[NAME] | 1966-02-01 00:00:00 | Duplicate of A2
[NAME] | 1987-07-03 00:00:00 | Unique record
[NAME] | 1998-11-09 00:00:00 | Unique record
[NAME] | 1998-11-09 00:00:00 | Unique record
[NAME] | 1987-07-03 00:00:00 | Duplicate of A3