tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 156406d1337280605-excel-2007-need-to-create-batting-order-depending-on-stats-and-cant-have-a-player-twice-in-line-up-softball-stats-monday-night
Sheet: Game 12

 | Game # | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Total
 | Date | 2012-08-06 19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JBC |  |  |  |  |  |  |  | 0 | 0 | 0
 | Location | Jamestown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jenison Bible #1 |  |  |  |  |  |  |  | 0 | 0 | 0
 | Opponent | Jenison Bible #1
 | Result | Loss
# | Name | G | AB | H | 1B | 2B | 3B | HR | BB | ROE | SAC | R | RBI | BA | OBP | SLG | OPS
1 | Scott |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
2 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
3 | Jared |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
4 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
5 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
6 | Joel |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
7 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
8 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
9 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
10 | Kris |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
11 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
 | MAX
Spreadsheet: 43925d1242585742-use-of-sumproduct-countif-example
Sheet: Sheet1

Type | Outcome
A | N/A
B | Y
A | N/A
C | Y
D | N
A | N/A
E | Y
F | Y
B | N
C | N
B | Y
Expected Results
A | N/A | Not worried about outcome for A, always N/A
B | 2
C | 1
D | 0
E | 1
F | 1
Spreadsheet: 739763d1625921320-phone-format-00-to-1-or-86-excelphone-1-
Sheet: Sheet1

Billing Country | Phone
Macedonia | 00389 2 2550 850
Trinidad and Tobago | [PHONE]
Italy | 0039 [PHONE]
Bahamas | [PHONE]
Trinidad and Tobago | [PHONE]
Nigeria | 00234-[PHONE]
United Kingdom | 0044-1457-860006
Belgium | 0032-14-578100
Macedonia | 00389 2 2461583
Jamaica | [PHONE]
Slovakia | 00421 33 640 00 71
Singapore | 0065 6221 1181
Portugal | 00351 217226110
Guyana | [PHONE]
France | 0033 4 78 04 41 04
Trinidad and Tobago | [PHONE]
China | 00852 2 8322060
Indonesia | 0062 21 - 5152-040
Belgium | 0032-2-7632222
Russia | [PHONE]
Jamaica | [PHONE]
Jamaica | [PHONE]
Trinidad and Tobago | [PHONE]
Macedonia | 00389-2-240-0850
Hungary | 0036-52-418-666
Czech Republic | 0042-[PHONE]
Ireland | 00353-1-8365007
United Kingdom | 00353-48-90738395
Czech Republic | 00420 272 690 799
Canada | [PHONE]
Slovakia | 00421 232115017
United Kingdom | 0044-20-8207 3222
Ireland | 00353 1 276 3500
Argentina | 0054 11 47 33 33 03
NL | 076-123456
Spreadsheet: 737253d1624297937-data-to-be-arranged-in-01st-and-last-cells-book3-trial
Sheet: Sheet2

 |  |  |  | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | d | a | s | d | f
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: Week 28

Fixtures | Week 28 |  |  |  |  | Player Scores
Home Team | Score |  |  | Away Team |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Damian West | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  |  |  |  | Weekly Total
Spreadsheet: ryan_slinger__33675__5_14act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 889908d1740939764-formula-works-except-for-one-cell-blood-pressure-2025-a
Sheet: Mar25

2025-03-01 00:00:00
date | day | time | Sys | [NAME] | Pul | Sugar
2025-03-01 00:00:00 |  | 09:51:00 | 128 | 69 | 67 | 174
2025-03-02 00:00:00 |  | 10:10:00 | 124 | 71 | 61 | 160
2025-03-03 00:00:00
2025-03-04 00:00:00
2025-03-05 00:00:00
2025-03-06 00:00:00
2025-03-07 00:00:00
2025-03-08 00:00:00
2025-03-09 00:00:00
2025-03-10 00:00:00
2025-03-11 00:00:00
2025-03-12 00:00:00
2025-03-13 00:00:00 |  |  |  |  |  |  | ,
2025-03-14 00:00:00
2025-03-15 00:00:00
2025-03-16 00:00:00
2025-03-17 00:00:00
2025-03-18 00:00:00
2025-03-19 00:00:00
2025-03-20 00:00:00
2025-03-21 00:00:00
2025-03-22 00:00:00
2025-03-23 00:00:00
2025-03-24 00:00:00
2025-03-25 00:00:00
2025-03-26 00:00:00
2025-03-27 00:00:00
2025-03-28 00:00:00
2025-03-29 00:00:00
2025-03-30 00:00:00
2025-03-31 00:00:00
Median
 |  |  | Sys | [NAME] | Pul | Sugar
High value
Low Value
Standard Deviation
Spreadsheet: phillip_m_love__30020__STORAGE
Sheet: DEC99GULFCOAST

NGPL GULF COAST STORAGE
DECEMBER 1999
 | K#114786 |  |  |  | K#114846
 | LA Injection | LA Withdrawl | STX Injection | STX Withdrawl | LA Injection | LA Withdrawl | STX Injection | STX Withdrawl
[NAME] | 931225 |  |  |  | 992271
1999-12-03 00:00:00 |  |  |  |  | 0 | 0 | 4129 | 0
1999-12-04 00:00:00 | 5463 | 0 | 555 |  | 0 | 0 | 3573 | 0
 | 1859 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 1859 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 1887 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4200 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | 0 | 0 | 0
 | 0 | 0 | 4129 |  | 0 | -5278 | 0 | 0
 |  |  | 4129 |  | 0 | 0 | 0 | 0
 |  |  | 4129 |  | 0 |  | 0 | 0
 |  |  | 4129 |  | 0 |  | 0 | 0
Ending Balance
MWQ | 1371225 |  |  |  | 999975
Diff Stor Bal & MWQ
Spreadsheet: 212044d1360017649-trying-to-turn-abbreviated-words-into-their-full-words-st-abbrev-solution
Sheet: Sheet1

 | IL |  |  |  |  |  | IL | Illinois
 | GA |  |  |  |  |  | GA | Georgia
 | IL |  |  |  |  |  | IN | Indiana
 | IL |  |  |  |  |  | IA | Iowa
 | IL |  |  |  |  |  | AR | Arkansas
 | IL |  |  |  |  |  | AL | Alabama
 | IL |  |  |  |  |  | DE | Delaware
 | GA |  |  |  |  |  | CT | Conneticut
 | GA
 | GA
 | IN
 | IA
 | IA
 | IA
 | IA
 | IA
 | IA
 | IA
 | IL
 | IL
 | IL
 | IL
 | IN
 | IN
 | IN
 | IN
 | IN
 | IN
 | IN
 | IL
 | IL
 | IL
 | AR
 | AL
 | AL
 | GA
 | IL
 | DE
 | AL
 | AL
 | AL
 | AL
 | IN
 | IN
 | IN
 | IN
 | IN
 | IN
 | IN
 | IN
 | IA
 | IA
 | AR
 | AR
 | AR
 | AR
 | AR
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IN
 | IL
 | IA
 | IA
 | IA
 | IL
 | IL
 | IL
 | GA
 | IN
 | AL
 | IN
 | IN
 | IL
 | GA
 | GA
 | GA
 | DE
 | DE
 | DE
 | IL
 | AR
 | AR
 | AR
 | AR
 | AR
 | AR
 | IA
 | IN
 | IN
 | IN
 | IN
 | IN
 | IN
 | IN
 | IN
 | IN
 | IN
 | IN
 | IN
 | GA
 | GA
 | IL
 | IL
 | IL
 | IL
 | AL
 | AL
 | AL
 | AL
 | AL
 | AL
 | AL
 | AL
 | AL
 | AL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
 | AR
 | AR
 | AR
 | AR
 | IN
 | CT
 | IA
 | IA
 | IA
 | IA
 | IL
 | IL
 | IL
 | IL
 | IL
 | IL
Spreadsheet: 755275d1636746292-if-formula-to-ignore-result-if-both-index-functions-return-from-the-same-cell-example
Sheet: Sheet1

Respondent |  | How often do you go to the cinema? |  |  |  |  |  |  | Difference between most recent answer and the answer before that
 | Answer in: | January | July | January | July |  |  |  | Previous | Most recent | Difference
A |  | Often | Sometimes | Sometimes
B |  | Sometimes | Sometimes
C |  | Often | Often | No data
D |  | Hardly ever or never | No data | Hardly ever or never | Sometimes
E |  | No data | Hardly ever or never | Sometimes
F |  | Sometimes | Often
Spreadsheet: 713855d1610980098-match-function-looking-up-number-value-20210718_su2xl_kalk-update_xl-help
Sheet: KALK

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MLxML2 | ML2xMIN | MLxMIN | MLxML | ML2=0 | ML2=MIN | [NAME] | CODE | CL | CB | CH | L | B | H | B-Z-A | EBENE
Spreadsheet: 688486d1595818513-adding-all-purchases-from-a-custom-date-range-from-a-purchase-journal-pj-finbar-sample
Sheet: Sheet2

DAILY SALES  QUARTER 3, 2020
PER 7 |  | PER 8 |  | PER 9 |  |  |  |  | SALES | ACTUAL  PURCHASES  $ | ACTUAL  PURCHASE % | PURCHASE %  TARGET | [NAME]
2020-07-01 00:00:00 |  | 2020-08-01 00:00:00 |  | 2020-09-01 00:00:00 |  |  | P7 | WEEK 1
2020-07-02 00:00:00 |  | 2020-08-02 00:00:00 |  | 2020-09-02 00:00:00 |  |  | P7 | WEEK 2
2020-07-03 00:00:00 |  | 2020-08-03 00:00:00 |  | 2020-09-03 00:00:00 |  |  | P7 | WEEK 3
2020-07-04 00:00:00 |  | 2020-08-04 00:00:00 |  | 2020-09-04 00:00:00 |  |  | P7 | WEEK 4
2020-07-05 00:00:00 |  | 2020-08-05 00:00:00 |  | 2020-09-05 00:00:00 |  |  | P7 | WEEK 5
2020-07-06 00:00:00 |  | 2020-08-06 00:00:00 |  | 2020-09-06 00:00:00 |  |  | P8 | WEEK 1
2020-07-07 00:00:00 |  | 2020-08-07 00:00:00 |  | 2020-09-07 00:00:00 |  |  | P8 | WEEK 2
2020-07-08 00:00:00 |  | 2020-08-08 00:00:00 |  | 2020-09-08 00:00:00 |  |  | P8 | WEEK 3
2020-07-09 00:00:00 |  | 2020-08-09 00:00:00 |  | 2020-09-09 00:00:00 |  |  | P8 | WEEK 4
2020-07-10 00:00:00 |  | 2020-08-10 00:00:00 |  | 2020-09-10 00:00:00 |  |  | P8 | WEEK 5
2020-07-11 00:00:00 |  | 2020-08-11 00:00:00 |  | 2020-09-11 00:00:00 |  |  | P8 | WEEK 6
2020-07-12 00:00:00 |  | 2020-08-12 00:00:00 |  | 2020-09-12 00:00:00 |  |  | P9 | WEEK 1
2020-07-13 00:00:00 |  | 2020-08-13 00:00:00 |  | 2020-09-13 00:00:00 |  |  | P9 | WEEK 2
2020-07-14 00:00:00 |  | 2020-08-14 00:00:00 |  | 2020-09-14 00:00:00 |  |  | P9 | WEEK 3
2020-07-15 00:00:00 |  | 2020-08-15 00:00:00 |  | 2020-09-15 00:00:00 |  |  | P9 | WEEK 4
2020-07-16 00:00:00 |  | 2020-08-16 00:00:00 |  | 2020-09-16 00:00:00 |  |  | P9 | WEEK 5
2020-07-17 00:00:00 |  | 2020-08-17 00:00:00 |  | 2020-09-17 00:00:00
2020-07-18 00:00:00 |  | 2020-08-18 00:00:00 |  | 2020-09-18 00:00:00
2020-07-19 00:00:00 |  | 2020-08-19 00:00:00 |  | 2020-09-19 00:00:00
2020-07-20 00:00:00 |  | 2020-08-20 00:00:00 |  | 2020-09-20 00:00:00
2020-07-21 00:00:00 |  | 2020-08-21 00:00:00 |  | 2020-09-21 00:00:00
2020-07-22 00:00:00 |  | 2020-08-22 00:00:00 |  | 2020-09-22 00:00:00
2020-07-23 00:00:00 |  | 2020-08-23 00:00:00 |  | 2020-09-23 00:00:00
2020-07-24 00:00:00 |  | 2020-08-24 00:00:00 |  | 2020-09-24 00:00:00
2020-07-25 00:00:00 |  | 2020-08-25 00:00:00 |  | 2020-09-25 00:00:00
2020-07-26 00:00:00 |  | 2020-08-26 00:00:00 |  | 2020-09-26 00:00:00
2020-07-27 00:00:00 |  | 2020-08-27 00:00:00 |  | 2020-09-27 00:00:00
2020-07-28 00:00:00 |  | 2020-08-28 00:00:00 |  | 2020-09-28 00:00:00
2020-07-29 00:00:00 |  | 2020-08-29 00:00:00 |  | 2020-09-29 00:00:00
2020-07-30 00:00:00 |  | 2020-08-30 00:00:00 |  | 2020-09-30 00:00:00
2020-07-31 00:00:00 |  | 2020-08-31 00:00:00
PURCHASE  TARGET | 0.55 |  | 0.55 |  | 0.55
Spreadsheet: 191540d1352141925-colum-count-based-n-values-in-colum-a-and-b-v1-2001jesper-oeldere-
Sheet: owssvr

Fruit | Who cares |  |  | Fruit | Who cares
apple | banana |  |  | apple | banana
apple | banana |  |  | apple | banana |  |  | Rijlabels | Aantal van Who cares
apple | ice |  |  | apple | ice |  |  | apple | 9
bee | ice |  |  | bee | ice |  |  | banana | 2
bee | ice |  |  | bee | ice |  |  | ice | 7
bee | ice |  |  | bee | ice |  |  | bee | 6
bee | ice |  |  | bee | ice |  |  | ice | 6
ice | ice |  |  | ice | ice |  |  | beer | 2
ice | ice |  |  | ice | ice |  |  | ice | 2
ice | ice |  |  | ice | ice |  |  | entry | 1
ice | ice |  |  | ice | ice |  |  | ice | 1
ice | ice |  |  | ice | ice |  |  | ice | 6
bee | ice |  |  | bee | ice |  |  | ice | 6
bee | ice |  |  | bee | ice |  |  | Eindtotaal | 24
apple | ice |  |  | apple | ice
apple | ice |  |  | apple | ice
entry | ice |  |  | entry | ice
beer | ice |  |  | beer | ice
beer | ice |  |  | beer | ice
ice | ice |  |  | ice | ice
apple | ice |  |  | apple | ice
apple | ice |  |  | apple | ice
apple | ice |  |  | apple | ice
apple | ice |  |  | apple | ice
 | =countifs(A2:A25;"apple";B2:B25;"banana")
 | apple
 | banana
 | apple
Spreadsheet: 488803d1478839258-text-number-separator-tool-text-seperation
Sheet: 4 numbers

Initial Data | # | aux | Denomination | aux1 | no. Spaces | Debit Mov. | Credit Mov. | Debit Balance | Credit Balance
1213 sdajkasd 23123 23123 5435 97887
1 MEIOS FINANCEIROS LÍQUIDOS 124.128,30 117.265,40 6.862,90
11 Caixa 2.099,28 2.099,28
111 Caixa Sede 2.099,28 2.099,28
2 CONTAS A RECEBER E A PAGAR 244.498,58 340.819,10 96.320,52
21 Clientes 58.482,85 31.622,05 26.860,80
211 Clientes c/c 58.482,85 31.622,05 26.860,80
2111 Clientes gerais 58.482,85 31.622,05 26.860,80
21111 Clientes Nacionais 57.832,85 31.297,05 26.535,80
[NAME]
Spreadsheet: 754445d1636201514-formula-to-extract-data-from-worksheets-test-cosmica-aligw
Sheet: Year 1

Upn | Name | Subject 1 | Subject 2 | Subject 3 | Subject 4
 | Name 1 | 0.42 | 0.94 | 1.11 | -0.26
 | Name 2 | 2.61 | 3.07 | 3.73 | 1.88
 | Name 3 | -0.74 | -0.51 | 0.52 | -1.46
 | Name 4 | -0.51 | -0.69 | -0.07 | -0.68
 | Name 5 | -0.69 | 1.08 | 2.2 | 3.35
 | Name 6 | 0.62 | 1.28 | 3.58 | -0.93
 | Name 7 | 0.19 | -0.08 | 1.08 | -0.05
 | Name 8 | 2.09 | 2.2 | 3.05 | 1.62
 | Name 9 | 2.22 | 2.72 | 3.35 | 1.46
Spreadsheet: 876630d1723360629-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.13.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-13 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 10 | 0 | 2 | 1 | 1 | 0 | 1 | 1 | 0
 | 4TH FL | 38 | 22 | 21 | 1 | 3.8 | 1 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 21 | 0 | 3 | 0 | 0 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 16 | 0 | 3 | 0 | 1 | 0 | 1 | 2 | 0
 | MNO | 12 | 6 | 7 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 4 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 1 | 0 | 3 | 1 | 0 | 1 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-13 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 21 | 0 | 4 | 0 | 1 | 1 | 0 | 1 | 0
 | 5TH FL | 34 | 20 | 15 | 0 | 3 | 0 | 2 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 15 | 0 | 5 | 1 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 7 | 0 | 3 | 0 | 1 | 0 | 1 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 4 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 2 | 0 | 4 | 0 | 0 | 0 | 0 | 1 | 0
 | Total House Census
Spreadsheet: 794575d1662124538-how-to-highlight-the-cells-using-a-formula-with-conditional-formatting-or-else-book1-steiny88-
Sheet: Test

Serial Number | Description |  |  | Serial # | Test 2 | Test 3
75E395X | Test1
 | Test1
 | Test1
 | Test1
 | Test1
 | Test1
 | Test2
 | Test2
 | Test2
 | Test2
 | Test2
 | Test2
 | Test2
 | Test2
Subtotal
75E3A4M | Test2
 | Test2
 | Test2
 | Test1
 | Test1
 | Test1
 | Test1
 | Test1
 | Test1
 | Test3
 | Test3
 | Test3
 | Test3
 | Test3
Subtotal
75E3A4Y | Test2
 | Test2
 | Test2
 | Test1
 | Test1
 | Test1
 | Test1
 | Test1
 | Test1
Subtotal
Spreadsheet: 525694d1498841035-sensitivity-data-table-based-off-goal-seek-input-mr06-example
Sheet: Sheet1

 | T-18 | T-12 | Opening | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-12-31 00:00:00
Growth rate |  |  |  |  |  |  | 0.05 | 0.08
Units | 0 | 0 | 0 | 1000 | 1500 | 2000 | 2500 | 3000
Price |  |  |  | 10 | 11 | 12
Revenue
Buy/Sell | -500000 | -1000000 |  |  |  |  |  | 4000000
CF
Equity | 437972.8027677294
Net
XIRR
 |  | 0.25
XIRR Fixed at |  |  | Equity
 | Year 3 Price | 9
 |  | 10
 |  | 11
 |  | 12 | 437973
 |  | 13
 |  | 14
 |  | 15
Spreadsheet: 098e3266-ca79-48f1-b28a-a1813574fa84
Sheet: Professional Certifications

FY 2011 Professional Certifications by Federal Agencies
CMDSM: Certified Mail and Distribution Systems Manager
EMCM:    Executive Mail Center Manager (USPS)
MDP: | Mailpiece Design Professional
MAILCOM: Offered at MAILCOM conferences
CMM-IPMA: Certified Mail Manager (International Publishing Management Association)
Agency | Certification | Number of Certifications
Department of Agriculture | CMDSM | 1
 | EMCM | 7
 | MAILCOM | 2
 | MDP | 5
 | Other mail-related certifications | 29
Department of Commerce | CMM-IPMA | 1
 | EMCM | 8
 | MAILCOM | 22
 | MDP | 5
 | Other mail-related certifications | 3
Department of Defense | CMDSM | 13
 | EMCM | 25
 | MAILCOM | 11
 | MDP | 6
 | Other mail-related certifications | 90
Department of Energy | CMM-IPMA | 1
 | EMCM | 3
 | MAILCOM | 10
 | MDP | 3
 | Other mail-related certifications | 18
Department of Homeland Security | CMDSM | 1
 | EMCM | 30
 | MAILCOM | 109
 | MDPI | 11
 | Other mail-related certifications | 19
Department of Housing and Urban Development | CMDSM | 1
 | CMM-IPMA | 1
 | EMCM | 2
 | MAILCOM | 2
 | MDP | 2
 | Other mail-related certifications | 3
Department of Justice | EMCM | 1
 | MAILCOM | 10
 | MDP | 1
 | Other mail-related certifications | 18
Department of Labor | EMCM | 2
 | MAILCOM | 1
 | Other mail-related certifications | 1
Department of Transportation | CMDSM | 1
 | CMM-IPMA | 2
 | EMCM | 5
 | MDP | 1
Department of the Interior | EMCM | 4
 | MAILCOM | 4
 | MDP | 2
Department of the Treasury | EMCM | 1
Environmental Protection Agency | EMCM | 3
 | MAILCOM | 8
 | MDP | 4
Equal Employment Opportunity Commission | CMDSM | 1
 | CMM-IPMA | 1
 | EMCM | 1
 | MAILCOM | 1
 | MDP | 1
General Services Administration | EMCM | 1
 | MAILCOM | 2
 | MDP | 1
 | Other mail-related certifications | 1
Government Printing Office | EMCM | 1
Health and Human Services | EMCM | 3
 | MAILCOM | 5
 | MDP | 1
National Aeronautics and Space Administration | EMCM | 1
 | MDP | 4
 | Other mail-related certifications | 7
Office of Personnel Management | EMCM | 1
Small Business Administration | CMDSM | 2
 | MAILCOM | 6
Social Security Administration | MAILCOM | 4
 | MDP | 1
 | Other mail-related certifications | 1
Total |  | 560
Spreadsheet: 179053d1347013965-formatting-check-boxes-issue-sample3
Sheet: Sheet2

Location | Number of Widgets
Designation | 1-3 | 4-6 | 7-10 | 10-15 | 15-20
North | 10 | 20 | 30 | 40 | 50
South | 15 | 25 | 35 | 45 | 55
Spreadsheet: 765831d1643632941-compare-2-columns-on-multiple-values-exdata2
Sheet: Last Month

Product | Subscription key | Company | Usage | Total seats
Product1 | abc123 | Comp1 | 10 | 20
Product2 | def456 | Comp1 | 4 | 5
Product1 | ghi789 | Comp1 | 4 | 4
Product3 | jkl123 | Comp1 | 1 | 1
Product2 | mno456 | Comp1 | 19 | 19
Product1 | pqr789 | Comp1 | 1 | 1
Product2 | stu123 | Comp1 | 5 | 5
Product1 | vwx456 | comp2 | 25 | 25
Product3 | yza789 | comp3 | 4 | 4
Product2 | bcd123 | comp2 | 18 | 20
Product1 | efg456 | comp2 | 42 | 46
Product2 | hij789 | comp3 | 9 | 9
Product1 | klm123 | comp2 | 31 | 36
Product3 | nop456 | comp3 | 19 | 19
Product2 | qrs789 | comp2 | 2 | 2
Product1 | tuv123 | comp2 | 4 | 4
Product2 | wxy456 | comp3 | 2 | 2
Spreadsheet: 725002d1616495850-building-a-truck-even-pallet-quantities-pallet-builder
Sheet: Info

 |  |  |  |  |  | MAX's |  |  |  |  | Weight/pallet
 |  |  |  |  |  | 12ct | 26 | pallets/truck |  | 12ct | 1660 | lb
 |  |  |  |  |  | 3x4 | 26 | pallets/truck |  | 3x4 | 1660 | lb
 |  |  |  |  |  | 24ct | 24 | pallets/truck |  | 24ct | 1825 | lb
 |  |  |  |  |  | Cartons | 20 | pallets/truck |  | Cartons | 2075 | lb
 | Cases/Pallet | pallets/truck
12ct | 161 | 26
3x4 | 161 | 26
24ct | 120 | 24 |  |  |  | Example.. |  |  |  |  |  |  |  | This would be 1 truck. All uneven quantites would need to be in the last truck as "leftovers"
Cartons | 120 | 20 |  |  |  | Truck # | SKU | Item | Lot # | Qty | Cases per Pallet | # of Pallets
 |  |  |  |  |  | Truck 1 | 5634 | Chocolate 12ct | 1234E | 161
Example of items to build in a truck… |  |  |  |  |  | Truck 1 | 5634 | Chocolate 12ct | 1234F
Item | SKU | Lot # | Qty (Cases) | Cases per Pallets | #Pallets | Leftover | max_pallets |  | [NAME] |  |  |  |  | distribution/truck
24 ct Vanilla | 5634 | 1234A | 158
Chocolate 12ct | 5634 | 1234B | 9902
Chocolate 12ct | 5634 | 1234C | 9924
24 ct Vanilla | 5634 | 1234D | 10053
Chocolate 12ct | 5634 | 1234E | 161
Chocolate Cartons | 5634 | 1234F | 9435
Spreadsheet: 474871d1470940570-displaying-sub-categories-in-report-master-list
Sheet: Participating

 | Facility | Unit Description | Candidate Profile | Contacted | Interview Completed | [NAME] | Extensions | Cancellation | Follow up
Unit Name
Unit Location
Director/Manager
Beds
AVG Daily Census
Shift Hours
Shift start & End
Patient Age Group
Patient Population
[NAME]
Medication System
Special Procedures
Special Equipment
Documentation System
Length of Orientation
Communication Process
Support Services
Floating Requirements
Unit Specific Skills
Certifications (Req/Pref?)
Min Exp Required
Spreadsheet: 832871d1686649548-is-it-possible-to-make-the-reference-element-of-an-offset-formula-dynamic-offset-issue-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | start ref | end ref
 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  |  | 4 | 5
 |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | sum
 |  |  |  |  |  | 351.36978 | 398.26435 | 446.7180699999999 | 391.61136 | 361.29847 | 398.94532 | 390.0334300000001 | 388.10408 | 397.2278599999999 | 370.51434 | 397.9263799999999 | 342.2486699999999 |  |  | formula
Spreadsheet: 114093d1309950332-find-approximate-match-book1
Sheet: Sheet1

0.05 | 2
0.1 | 85 |  |  |  | LookUp Value | [NAME]
0.15 | 74 |  |  |  | 0.18 | 74
0.2 | 43 |  |  |  | 0.25 | 100
0.25 | 100 |  |  |  | 0.29 | 100
0.3 | 65 |  |  |  | 0.3 | 65
0.35 | 22
0.4 | 89
0.45 | 12
0.5 | 49
0.55 | 67
0.6 | 100
0.65 | 45
0.7 | 44
0.75 | 99
0.8 | 2
0.85 | 21
0.9 | 10
0.95 | 90
1 | 4