tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 690062d1596838262-grid-to-list-formula-example2
Sheet: EXAMPLE

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DESIRED OUTPUT
SKU | UPC | [NAME] | FINISH | DLR NET | MAP | MSRP |  | 2020-01-10 00:00:00 | 2020-02-10 00:00:00 | 2020-03-10 00:00:00 | 2020-04-10 00:00:00 | 2020-05-10 00:00:00 | 2020-06-10 00:00:00 | 2020-07-10 00:00:00 | 2020-08-10 00:00:00 | 2020-09-10 00:00:00 | 2020-10-10 00:00:00 | 2020-11-10 00:00:00 | 2020-12-10 00:00:00 |  | SKU | QUANTITY | DATE
A | 1 | [NAME] | FINISH | 1 | 2 | 3 | X |  |  |  |  |  |  |  | 1 |  | 3 | 4 | 5 |  | A | 1 | 2020-08-10 00:00:00
B | 2 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | A | 3 | 2020-10-10 00:00:00
C | 3 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  | 5 | 4 |  | 2 | 1 |  | A | 4 | 2020-11-10 00:00:00
D | 4 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | A | 5 | 2020-12-10 00:00:00
E | 5 | [NAME] | FINISH | 1 | 2 | 3 | X |  |  |  |  |  |  |  |  | 3 |  | 1 |  |  | B | 1 | 2020-08-10 00:00:00
F | 6 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 |  | C | 5 | 2020-08-10 00:00:00
G | 7 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  | 1 |  | 5 |  |  |  | C | 4 | 2020-09-10 00:00:00
H | 8 | [NAME] | FINISH | 1 | 2 | 3 | X |  |  |  |  |  |  |  |  |  |  |  | 2 |  | C | 2 | 2020-11-10 00:00:00
I | 9 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  | 2 |  | 1 |  |  | C | 1 | 2020-12-10 00:00:00
J | 10 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | D | 1 | 2020-10-10 00:00:00
K | 11 | [NAME] | FINISH | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  |  | 2 |  | 3 |  | D | 1 | 2020-12-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 3 | 2020-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 1 | 2020-11-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 1 | 2020-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 1 | 2020-10-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 1 | 2020-12-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | 1 | 2020-08-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | 5 | 2020-10-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 2 | 2020-12-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I | 2 | 2020-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I | 1 | 2020-11-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | 1 | 2020-11-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | 2 | 2020-10-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | 3 | 2020-12-10 00:00:00
Spreadsheet: 478569d1472862097-how-do-i-find-duplicates-between-worksheets-how-do-i-find-duplicates-between-worksheets
Sheet: Sheet3

218 | 283 | 162 | 284 | 126
117 | 273 | 110 | 142 | 174
160 | 109 | 155 | 143 | 201
154 | 279 | 218 | 105 | 208
128 | 269 | 121 | 246 | 172
136 | 178 | 297 | 261 | 195
214 | 162 | 122 | 137 | 294
Spreadsheet: 707718d1607430458-what-formulas-should-i-use-to-bring-all-the-alternatives-listed-sample
Sheet: List

Alternative 1 | Alternative 2 | Alternative 3 | Alternative 4
AY10 | J975 | XX0 | LALA1005
AY11 | J976 | XX1 | LALA1006
AY12 | J977 | XX2 | LALA1007
AY13 | J978 | XX3 | LALA1008
AY14 | J979 | XX4 | LALA1009
AY15 | J980 | XX5 | LALA1010
AY16 | J981 | XX6 | LALA1011
AY17 | J982 | XX7 | LALA1012
[NAME] | J983 | XX8 | LALA1013
AY19 | J984 | XX9 | LALA1014
AY20 | J985 | [NAME] | LALA1015
AY21 | J986 | XX11 | LALA1016
AY22 | J987 | XX12 | LALA1017
AY23 | J988 | XX13 | LALA1018
AY24 | J989 | XX14 | [NAME]
AY25 | J990 | [NAME] | LALA1020
AY26 | J991 | XX16 | LALA1021
AY27 | J992 | XX17 | LALA1022
AY28 | J993 | XX18 | LALA1023
AY29 | J994 | XX19 | LALA1024
AY30 | J995 | XX20 | LALA1025
AY31 | J996 | XX21 | LALA1026
AY32 | J997 | XX22 | LALA1027
AY33 | J998 | XX23 | LALA1028
[NAME] | J999 | XX24 | LALA1029
AY35 | J1000 | XX25 | LALA1030
AY36 | J1001 | XX26 | LALA1031
[NAME] | [NAME] | XX27 | LALA1032
AY38 | J1003 | XX28 | LALA1033
AY39 | J1004 | XX29 | LALA1034
[NAME] | [NAME] | XX30 | LALA1035
Spreadsheet: 73820d1274381430-duplicating-and-linking-data-example
Sheet: by_box

box# | item# | date | type_1 | type_2
1108246 | 3744 | 2010-01-27 00:00:00 | z+-
1108246 | 3745 | 2010-01-27 00:00:00 | z+- | g+-
1108246 | 3746 | 2010-01-27 00:00:00 | w | g-
1108246 | 8341 | 2010-02-23 00:00:00 | w
1111164 | 8337 | 2010-02-23 00:00:00 | z+-
1111164 | 8338 | 2010-02-23 00:00:00 | z+- | w
1111164 | 8339 | 2010-02-23 00:00:00 |  | g+-
1111164 | 8340 | 2010-02-23 00:00:00 |  | g+-
1111238 | 6572 | 2009-11-04 00:00:00 | z--
1117159 | 3668 | 2010-01-05 00:00:00 |  | g-
1117159 | 3674 | 2010-01-05 00:00:00 | z--
1120246 | 4149 | 2010-03-04 00:00:00 | z+-
1120246 | 3672 | 2010-01-05 00:00:00 |  | g+-
1120249 | 3580 | 2010-01-18 00:00:00 | w | g+-
1121665 | 6038 | 2009-09-12 00:00:00 |  | w
1125423 | 6071 | 2009-09-18 00:00:00 | z--
Spreadsheet: kate_symes__18280__DJ Index 4-8 RTC
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-04-09 00:00:00
Flow Date: | 4/8/01 - Sunday Round-the-Clock
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4683 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 256.6666666666666 | 1200
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 256.6666666666666 | 600
 | Firm Trades Purchases | #[NAME]! | 0
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 263.5714285714286 | 2800
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 263.5714285714286 | 1400
 | Firm Trades Purchases | #[NAME]! | 0
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 98.75745526838966 | 8048
 | Firm Trades Purchases | 98.25 | 1600
[NAME] | Firm Trades Sales | 98.75745526838966 | 4024
 | Firm Trades Purchases | 98.25 | 800
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 110 | 752
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 110 | 376
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 226.6666666666667 | 6000
 | Firm Trades Purchases | 218.25 | 1600
[NAME] | Firm Trades Sales | 226.6666666666667 | 3000
 | Firm Trades Purchases | 218.25 | 800
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 114.7058823529412 | 6800
 | Firm Trades Purchases | 110.4247104247104 | 4144
[NAME] | Firm Trades Sales | 114.7058823529412 | 3400
 | Firm Trades Purchases | 110.4247104247104 | 2072
Spreadsheet: darrell_schoolcraft__7691__Ultra Sonic callibration_flow data
Sheet: UltraSonic pressure data

 |  |  |  |  | Ultra Sonic Calibration pressure vs flowing pressure worksheet
Region/Station | 3rd Party owned y/n | [NAME] type | Flow conditioner type | Date of install | Company* | Receipt or Delivery | Calibrated at pressure | Flowing at pressure | Potential Drift % | Drift  High or Low | Jan 2002 flow | Potential inpact | Possible Pulsation at this point Y or N
Minneapolis / North
Craddock/Fraiser/Miller
Des Moines
Mowrer / Cowart
Beatrice
Kile
Amarillo
Kneisley/Tanner/Williams
Albuquerque
Kneisley/Tanner/Williams
Midland
Kneisley/Tanner/Williams
Orlando
Campo/Figueroa
Tallahassee
McClary
Lafayette
Tidwell
*enter the pipeline impacted
Spreadsheet: errol_mclaughlin_jr__10107__TXU01072002
Sheet: Phys Basis

[NAME] |  |  |  |  |  |  |  |  | Totals | 0
 |  | Phy/ |  |  | Monthly | PV | Discount | Mid | Fixed |  | Mid
Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value
TXUENETRA | EA1267.2 | P | NGI/CHI. GATE | 2002-01-01 00:00:00 | 0 | 0 | 1 | 0.0825 | 0.0275 | 0 | -17050
TXUENETRA | EA1267.2 | P | NGI/CHI. GATE | 2002-02-01 00:00:00 | -280000 | -279599.0232 | 0.998567939851437 | 0.03 | 0.0275 | 0 | -698.9976
TXUENETRA | EA1267.2 | P | NGI/CHI. GATE | 2002-03-01 00:00:00 | -310000 | -309108.1287 | 0.997122995769223 | 0.03 | 0.0275 | 0 | -772.7703
TXUENETRA | EA1267.2 | P | NGI/CHI. GATE | 2002-04-01 00:00:00 | -300000 | -298656.657 | 0.995522189948383 | 0.01 | 0.0275 | 0 | 5226.4915
TXUENETRA | EA1267.2 | P | NGI/CHI. GATE | 2002-05-01 00:00:00 | -310000 | -308108.963 | 0.993899880697326 | 0.01 | 0.0275 | 0 | 5391.9069
TXUENETRA | EA1267.2 | P | NGI/CHI. GATE | 2002-06-01 00:00:00 | -300000 | -297653.336 | 0.992177786569085 | 0.01 | 0.0275 | 0 | 5208.9334
TXUENETRA | EA1267.2 | P | NGI/CHI. GATE | 2002-07-01 00:00:00 | -310000 | -307027.8366 | 0.990412376159538 | 0.01 | 0.0275 | 0 | 5372.9871
TXUENETRA | EA1267.2 | P | NGI/CHI. GATE | 2002-08-01 00:00:00 | -310000 | -306409.922 | 0.988419103134012 | 0.01 | 0.0275 | 0 | 5362.1736
TXUENETRA | EA1267.2 | P | NGI/CHI. GATE | 2002-09-01 00:00:00 | -300000 | -295899.422 | 0.986331406739108 | 0.01 | 0.0275 | 0 | 5178.2399
TXUENETRA | EA1267.2 | P | NGI/CHI. GATE | 2002-10-01 00:00:00 | -310000 | -305090.5758 | 0.984163147794663 | 0.01 | 0.0275 | 0 | 5339.0851
TXUENETRA | EA1267.2 | P | NGI/CHI. GATE | 2002-11-01 00:00:00 | -300000 | -294517.6907 | 0.981725635654835 | 0.1 | 0.0275 | 0 | -21352.5326
TXUENETRA | EA1267.2 | P | NGI/CHI. GATE | 2002-12-01 00:00:00 | -310000 | -303567.0369 | 0.979248506096738 | 0.1 | 0.0275 | 0 | -22008.6102
Spreadsheet: 157a19b4-5107-4e11-9380-543b36a9d4ce
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
 | 8501.0 Retail Trade, Australia
 | TABLE 16. Retail Turnover ($ millions), Completely Enumerated sector: Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Turnover ;  Total CE and [NAME] ; |  |  | Original | [NAME] | 1994-04-01 00:00:00 | 2010-02-01 00:00:00 | 191 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350334L | 1994-04-01 00:00:00 | 2010-02-01 00:00:00 | 191 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Trend | A3350340J | 1994-04-01 00:00:00 | 2010-02-01 00:00:00 | 191 | $ Millions | FLOW | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Original | A3350329V | 1994-04-01 00:00:00 | 2010-02-01 00:00:00 | 191 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350335R | 1994-04-01 00:00:00 | 2010-02-01 00:00:00 | 191 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Trend | A3350341K | 1994-04-01 00:00:00 | 2010-02-01 00:00:00 | 191 | Percent | PERCENT | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 676226d1588707244-reducing-list-of-values-by-fixed-amount-until-zero-example-file
Sheet: Sheet1

Outstanding Debt (US$) | Number of charges to clear debt | Total amount charged
64.56060000000004 |  |  |  |  | 16.78 | 25 | 30 | 32
166.8204
89.02140000000001
2.698800000000037
123.3414
10.60020000000005
6.645600000000083
92.43000000000004
Spreadsheet: 842608d1694629009-generate-random-number-for-work-from-home-wfh
Sheet: Sheet1

 |  | [NAME] | Betty | Michelle | JR | [NAME] | [NAME] | [NAME] | No of staff
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | To Office Count
 |  | *Everyday must have at least 3 staffs, can be more but cannot be less
 |  | *Each Staff to be in office at least 2 times per week. But can be more in the case of [NAME], if there is no choice
Spreadsheet: 185505d1349736013-formula-to-rank-and-populate-values-base-don-rank-ranking-query
Sheet: Sheet1

RUSSIA | Q3 VS Q2 $ | Ranking (descending order of Column B Data) |  |  | Ranking (ascending order order of Column B Data) |  |  | Pay Out
AB | -14172 | 9
BC | 8320 | 5
CD | 364.2000000000116 | 6
EF | 12962 | 4
GH | 58741 | 2
IJ | -5294.919999999984 | 8
KL | -106623 | 12 |  |  | 2
LM | 101244.25 | 1 |  |  |  |  |  | 800
NO | -3899 | 7 |  | To use formula to rank |  |  | To use formula to rank |  |  | Based on the table of payout given below, formula to match payout to rank
PQ | 36674 | 3 |  |  |  |  |  |  |  | For Eg, If Rank 1 (based on descending order), "LM" will get $800
RS | -53171 | 11
 |  |  |  |  | 3
 | 35145.53
ITALY
TU | -38473.19 | 10
XY | -148197.02 | 13 |  |  | 1
 | -186670.21
Ranking Total Payout: |  | 2000
PSR Rank 1 |  | 800
PSR Rank 2 |  | 600
PSR Rank 3 |  | 400
PSR Rank 4 |  | 200
Spreadsheet: 678377d1589859854-index-match-for-auto-costings-calculations-jitterbug888_bizcostings-sample_v2
Sheet: FUNCTIONS

CANDLES
list | DAY | WEEK | MONTH | QTR | BI-ANNUAL | YEAR |  | cost category
daily |  |  |  |  |  |  |  | business cost
weekly |  |  |  |  |  |  |  | businss loan
monthly |  |  |  |  |  |  |  | charity
quarterly |  |  |  |  |  |  |  | subscriptions
6 months |  |  |  |  |  |  |  | personal loan
yearly |  |  |  |  |  |  |  | other costs
2 years
3 years
4 years
5 years
paused
Spreadsheet: 9ca331e3-a740-459a-82f0-bf148f81912b
Sheet: Sheet1

Program Name ([NAME] to Attachment A) | Program Type                         C = Clinical or  R = Research | Program Accreditation  (A) or (E) or (N) ([NAME] to  Attachment A) | Last  Name | First Name | Preferred Name | Middle Initial | SS# xxx-xx-xxxx | Hire Date if New or       Contract Start Date | Contract End Date (MM/DD/YY) | Department | Position | Job Code                  ([NAME] to Attachment C) | Rate | Percent (%) FTE | Date  of  Birth | Place of Birth | Gender  (male or female) | Ethnicity                AK - Alaskan Native          AS - Asian                           BL- Black/African Am.     PI - Native Hawaiian/ Pacific Islander                                 T- other TM - two/more                   WH - White/Non-Hispanic | Current Address 1 | Current Address 2 | Current City | Current State | Current Zip Code | County | Country | Current Phone Number | US Citizen   Y = Yes N = No P = Permanent Resident (green card) | Visa Type         J-1C (clinical visa) J-1R (research visa) | International                                             Medical Graduate                   Y = Yes N = No | ECFMG Certificate # Required if column R = Y | Current Email Address | Current (or to be Assigned) In-House Beeper | Current (or to be assigned)Long Range  Beeper | Credentialing History | Contract Type  R = Resident F = Fellow | SalaryAppearing  on Contract | Payroll Status | Payroll Cost Center ([NAME] to Attachment D)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Derivatives w-o  AA

 | Derivatives Marketing
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  | 1222275 | Compensation | 0
 | Special Pays |  |  | 0
 | Analyst & Associates |  |  |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 67500
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 225000 | Total
ENAOUTSV | Outside Services |  |  |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  | 45000
ENAMKTEX | Marketing |  |  |  |  |  | 0 | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  | 531 | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  | 67500 | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  | 90000 | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  | 1.8 | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | 13500 | Analyst | 60500 | 1
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  | 9 | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 2
 | A&A Headcount |  |  |  |  |  | 0 | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 127169d1320193237-coyping-down-merged-cell-that-references-non-merged-cell-merged
Sheet: Sheet1

1 |  | 1
 |  | 2
 |  | 3
 |  | 4
2 |  | 5 |  |  |  | 17
 |  | 6
 |  | 7 |  |  |  |  | 17
 |  | 8 |  |  |  |  | 34
3 |  | 9 |  |  |  | 34 | 51
 |  | 10 |  |  |  |  | 68
 |  | 11 |  |  |  |  | 85
 |  | 12 |  |  |  |  | 102
4 |  | 13 |  |  |  | 51 | 119
 |  | 14 |  |  |  |  | 136
 |  | 15 |  |  |  |  | 153
 |  | 16 |  |  |  |  | 170
5 |  |  |  |  |  | 68 | 187
 |  |  |  |  |  |  | 204
 |  |  |  |  |  |  | 221
 |  |  |  |  |  |  | 238
6 |  |  |  |  |  | 85 | 255
 |  |  |  |  |  |  | 272
7 |  |  |  |  |  | 102
8 |  |  |  |  |  | 119
9 |  |  |  |  |  | 136
10
11
12
13
14
Spreadsheet: 706158d1606501994-excel-sum-if-function-with-different-conditions-excel-sum-if-function-different-conditions-
Sheet: Complete item list

 | One time cost | Recurring
 | cAlarm retour via retourdoos / retourenveloppe | [NAME] huur per maand
 | cAlarm installatie | Korting professionele opvolging
 | Korting combinatie plaatsing cKey + cAlarm | cAlarm Home
 | cKey installatie en instructie thuis | cKey Door huur per maand
 | No Show | cKey pin plus huur per maand
 | [NAME] [NAME] | Vergoed door uw verzekeraar
 | Korting Installatie cKey Door Zorggroep Almere | Professionele opvolging Zorgstichting 't Heem
 | Spoedinstallatie thuis | Professionele opvolging [NAME]
 | Voorrijkosten | Professionele opvolging [NAME]
 | Activatiekosten bij zelf-installatie | Professionele opvolging Zuidzorg
 | Rookmelder | Professionele opvolging Proteion
 |  | Korting Abonnement cKey Door Zorggroep Almere
 |  | Professionele opvolging STMG
 |  | Extra hals- of polszender Basis
 |  | Professionele opvolging RijnWaal Zorggroep
 |  | Professionele opvolging Sterker Sociaal Werk
 |  | Professionele opvolging Internos
 |  | Professionele opvolging [NAME]
 |  | Professionele opvolging [NAME] (NIET GEBRUIKEN)
 |  | Professionele opvolging [NAME]
 |  | Papieren factuur
 |  | Professionele opvolging [NAME]
 |  | Trekkoord incl. extra drukknop
Spreadsheet: 735016d1622645932-counting-duplicates-in-specific-case-example
Sheet: Sheet1

 | Name | Group |  |  |  | Attended more than once from Group A
 | B.Almond | A |  |  |  | Attended more than once from Group B
 | C.Carrot | B |  |  |  | Attended more than once from Group C
 | D.Juice | C
 | B.Almond | A
 | A.Cabbage | C
 | C.Carrot | B
 | B.Fairy | A
 | B.Fairy | A
Spreadsheet: 34904d1232349596-calculations-using-codes-schedule2
Sheet: Schedule

 |  |  |  |  |  |  | Total Hours
Name | Sun | Mon | Tue | Wed | Thu | Fri
Fisher-Grace, Khaliah | A | A |  | P | P | P
[NAME], Louann | A | N
[NAME], [NAME] | A | 7 | 3
Chura, [NAME] | CL4
[NAME], [NAME] | P | P | P | P | P
Lashinger, [NAME] |  | CL8
Sullivan, Jen
[NAME], Marina |  | OF8
Adler, [NAME]
[NAME], [NAME] | P | P | P |  | A | A
Spreadsheet: 3e7c6c7b-9b29-4da2-a715-61e614612906
Sheet: Index

 | Research Expenditures | Links to Institution Tabs
 | FY 2011 - Year Ended August 31, 2011 |  | Accountability
 |  |  | Research
 |  |  | Data
 |  |  |  |  |  |  | For Insitution Specific Questions, Please Contact the Institution Point of Contact
 | HRI Institutions - Summary |  | Click Here |  |  |  | Institution Point of Contact for Sources & Uses Package
 |  |  |  |  |  |  | Name | Phone Number | [NAME]
 | The University of Texas Southwestern Medical Center at Dallas |  | Click Here
 | The University of Texas Medical Branch at Galveston |  | Click Here
 | The University of Texas Health Science Center at Houston |  | Click Here
 | The University of Texas Health Science Center at San Antonio |  | Click Here
 | The University of Texas M.D. [NAME] |  | Click Here
 | The University of Texas Health Center at Tyler |  | Click Here
 | Texas A&M University System Health Science Center |  | Click Here
 | University of North Texas Health Science Center at Fort Worth |  | Click Here
 | Texas Tech University Health Sciences Center |  | Click Here
 | Input Schedules
 | FTSE & FTFE
 | [NAME]
 | Template Input Schedule
 | Output Schedules
 | Almanac
 | Accountability - HRI_IE_Research