tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 289598d1389633198-data-validation-look-up-a-whole-table-rather-than-a-selection-sample
Sheet: MATRIX ATTRIBUTES

 | MATRIX ATTRIBUTES
 | SKILL LEVEL | SKILL SET | COMPETENT | COLLEAGUES
 | New Starter (0-6 Weeks) | Customer Service & Aftersales | Yes | ADAM HARRISON
 | In Training | Sales | No | GREG KNOWLES
 | Competent | Product Administration |  | INNIS TAYLOR
 | Able to train others | Website Maintenance
 | Special Skill | Multi Channel
 |  | IT / Web Admin
 |  | Advanced
Spreadsheet: 48053679-0843-4f3b-b384-5f15e12ff980
Sheet: Budget

PHB FY 2014-15 BUDGET PROPOSAL WORKSHEET
SUBRECIPIENT:
PROJECT:
See also "Types of Expenses" tab and "Instructions" tab.
Table 1: Program Budget Worksheet
Budget Category | Total FY 14/15 PHB Request | FY 14/15 Total Program Budget
Personnel (Direct Program)
Salaries | 0 | 0
Benefits & Payroll Taxes | 0 | 0
Total Personnel
Operating Expenses
General operating expenses | 0 | 0
Subcontracts | 0 | 0
Consultants
Client Assistance | 0 | 0
Total Operating Expenses
Administrative Expenses (Indicate direct or indirect)
Salaries | 0 | 0
Benefits & Payroll Taxes | 0 | 0
Indirect Costs | 0 | 0
Other | 0 | 0
Total Administrative Expenses
TOTAL BUDGET
Table 2: PHB Funded Staff Positions
Position Title and 1 Sentence Description | PHB Requested FTE | PHB Requested Dollar Amount
TOTAL PHB-FUNDED STAFF BUDGET
Table 3: Other Funding Sources
Fund Source | Status of Funding (Received, Committed, or Pending) | Amount
TOTAL (Non-PHB) PROGRAM FUNDING
Spreadsheet: 707064d1607017573-find-common-number-between-two-cells-common
Sheet: Sheet1

 |  |  | number | Series
 |  |  | 1 | 9 , 2 , 5,3 , 6 , 1 |  |  |  | expected result
 |  |  | 2 | 1 , 5 , 3, 2
 |  |  | 3 | 1,5,3,2,7* |  |  | 12 | 1,2,3,5
 |  |  | 4 | 7,1,5,6,4*,8*
 |  |  | 5 | 1,2,3,6,5
 |  |  | 6 | 1,5,7,6
 |  |  | 7 | 4,6,1,3,5 |  |  | 54 | 1,5,6,
 |  |  | 8 | 5,6,3,7,4*,8*
 |  |  | 9 | 1,5,3
Spreadsheet: 870775d1717214932-finding-an-average-feedback-rating-for-each-name-example3
Sheet: Sheet1

Row Labels | 4 | 5 | 6 | 7 | 8 | 9 | 10 | (blank) | Grand Total
NAME1 | 1 |  | 2 | 1 | 1 | 3 | 6
NAME2 |  |  | 1 |  | 1 | 2 | 6
NAME3 |  |  | 1 | 1 | 1 | 3 | 8
NAME4 | 1 | 2 | 1 | 1 | 3 | 7 | 18
NAME5 |  |  |  |  |  | 1 | 4
NAME1 |  |  |  |  |  |  | 1
NAME1
NAME2
NAME3
NAME4
NAME5
NAME1
Spreadsheet: 868961d1715670181-embedded-excel-file-not-working-on-website-funeral-landing-page_quote_v4
Sheet: 1

Cover | (18-24) | (25-34) | (35-44) | (45-54) | (55-64)
2000 | 10 | 11 | 13 | 14 | 18
5000 | 23 | 27 | 30 | 34 | 45
10000 | 45 | 53 | 59 | 67 | 89
20000 | 89 | 105 | 118 | 133 | 177
25000 | 103 | 123 | 138 | 155 | 206
30000 | 120 | 142 | 160 | 180 | 239
50000 | 184 | 219 | 245 | 276 | 367
100000 | 353 | 420 | 471 | 530 | 707
 |  |  |  |  |  |  |  | Op hierdie een moet die kliënt die cover amount kies en hul ouderdom insit.
Age | Cover Amount |  | Premium
52 | 100000
Spreadsheet: 53299d1253195274-if-function-fifa_night_2009-1-
Sheet: Knock Out

Butchers Arms FIFA 09 Tournament
 |  |  |  | Friday 25th September 2009
 | www.butchersarmsfc.co.uk
 |  |  |  | Quarter Final 1
 |  |  |  |  | Winner Group 1 |  |  |  |  | Runner Up Group 3
 |  |  |  | 10:00pm TV
 |  |  |  | Quarter Final 2
 |  |  |  |  | Winner Group 2 |  |  |  |  | Runner Up Group 1
 |  |  |  | 10:00pm TV 2
 |  |  |  | Quarter Final 3
 |  |  |  |  | Winner Group 3 |  |  |  |  | Runner Up Group 2
 |  |  |  | 10:20pm TV 1
 |  |  |  | Quarter Final 4
 |  |  |  |  | Third Place 1 |  |  |  |  | Third Place 2
 |  |  |  | 10:20pm TV 2
 |  |  |  | Semi Final 1
 |  |  |  |  | Winner QF 1 |  |  |  |  | Winner QF 2
 |  |  |  | 10:40pm TV 1
 |  |  |  | Semi Final 2
 |  |  |  |  | Winner QF 3 |  |  |  |  | Winner QF 4
 |  |  |  | 11:00pm TV 1
 |  |  |  | Third Place
 |  |  |  |  | Loser SF 1 |  |  |  |  | Loser SF 2
 |  |  |  | 11:20pm TV 1
 |  |  |  | Final
 |  |  |  |  | Winner SF 1 |  |  |  |  | Winner SF 2
 |  |  |  | 11:40pm TV 1
Butchers Arms FIFA 09 Champion
Spreadsheet: 264291d1378836444-how-to-find-the-variation-between-two-sheets-sample
Sheet: Invoice Level

Invoice# | Billed Amt | discout Amt | after reprice amt
D123 | 200 | 20
D124 | 159 | 9
D125 | 1234 | 111
D126 | 3842 | 22
D127 | 23232 | 222
D128 | 1342 | 10
D129 | 11223 | 65.5
D130 | 9972.99999999999 | 22
D131 | 9998.29999999999 | 222
D132 | 10023.6 | 10
D133 | 10048.9 | 65.5
D134 | 10074.2 | 55.2
D135 | 10099.5 | 44.9
D136 | 3842 | 22
D137 | 23232 | 222
D138 | 1342 | 10
D139 | 11223 | 65.5
D140 | 9972.99999999999 | 55.2
D141 | 9913.96666666666 | 44.9
D142 | 9903.1238095238 | 222
D143 | 9892.28095238094 | 222
D144 | 9857.34285714284 | 265.86
D145 | 9832.04285714284 | 313.84
D146 | 9806.74285714284 | 361.82
D147 | 9781.44285714284 | 409.8
D148 | 9756.14285714284 | 456.132
D149 | 9730.84285714284 | 503.288
D150 | 9705.54285714284 | 550.444
Spreadsheet: 159631d1338790504-update-worksheets-using-a-button-in-a-mastersheet-request-handling-partial
Sheet: Mouse

Name | Department | Location | Designation | Comp./ID # | Supervisor | Ref # | Request Date | Description | Remarks | Status
[NAME] | ICTD | field | 2 | 900333 | [NAME] | 96773 | [NAME] | computer set
Spreadsheet: 133662d1324520225-extract-data-into-another-sheet-filter-data-by-various
Sheet: Sheet1

 | [NAME] | 65
Row # | Date | [NAME] | Lot No | Code | Moisture | TVBN | Bag No FROM | Bag No TO | Total       Bags | Issued | Remaining Bags | Fish Item
Spreadsheet: 107048d1304207947-calculation-using-array-book7
Sheet: Sheet1

 | 12
Civics | C |  |  |  |  | Points:
History | B |  |  |  |  | A | 1
English | B |  |  |  |  | B | 2
Geography | D |  |  |  |  | C | 3
Kiswahili | A |  |  |  |  | D | 4
Biology | A |  |  |  |  | F | 5
Chemistry | B
Physics | C
Math | A
Spreadsheet: 728830d1618679969-how-to-get-vlookup-to-pick-the-second-row-when-the-first-row-is-blank-scheduling-doc-1-
Sheet: Schedule Snapshot

2021-04-14 08:17:00 | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | MAY-Sat | Sun | Mon
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3
 | 4 to 10 | 4 to 10 | 6 to 10
1892 Alabama | ?
AZ- [NAME] | 35 | ? | 70
[NAME] | 135 | 190
Mobile/Stimpson Modeling |  |  |  |  | 50 |  | 50 | 50 | 50 | 50 |  | 50 |  | 50 | 50 | 50 | 50
Reserve
TSS Modeling
TOTAL Work
Staffing Goal
TOTAL Agent Hours Scheduled | 181 | 202
Over/Under
Agent Hours Goal(s)
i8iio
Spreadsheet: darrell_schoolcraft__7608__imball0201
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 | 219 | 150
2 | 22 | 150
3 | 305 | 150
4 | 287 | 150
5 | 214 | 150
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 180032
2002-01-05 00:00:00
CBS Volume
 |  |  | 78993
Spreadsheet: 820527d1678147587-change-scroll-numbers-from-imperial-to-metric-based-on-separate-drop-down-cell-sample-form-1
Sheet: Form Sheet

Company: | ClearwaterPaper |  |  | Blade Code / Stock No.:
[NAME]: | North Las Vegas, NV |  |  | Position:
PM: | 2 |  |  | Paper / Tissue & Type: |  | Paper
[NAME] |  | [NAME] |  | [NAME] |  | Holder Type |  | KF/DST | [NAME]
Clouth |  | VP6 |  | EsscoHolders |  | Accumate
Imperial   Metric | Thickness | Routed | Routed Thickness | [NAME] | Length | Front / End Removal | Bevel | Front / Rear Bevel
Imperial | 250 | Yes | 40 | 300
Roll Cover Mfgr |  | Cover Material |  | Roll Cover Name |  | P&J | Diameter | Roll Install Date
Spreadsheet: 743685d1628676894-last-3-game-results-in-a-league-last-3-game-results-in-a-league-ans
Sheet: Sheet1 (2)

 | League Results |  |  |  |  |  |  | League Table
 | # | Date | Home Team | Away Team | Home Team | Away Team |  | # | Team | Last 3 Games |  |  | P | W | D | L | F | A | [NAME] | Pts
 | 1 | 2021-01-01 00:00:00 | Team H | Team E | 1 | 0 |  | 1 | Team A | D | W | L
 | 2 |  | Team C | Team G | 0 | 1 |  | 2 | Team B | W | L | W
 | 3 |  | Team E | Team C | 2 | 5 |  | 3 | Team C | W | L | -
 | 4 |  | Team A | Team D | 0 | 2 |  | 4 | Team D | D | D | L
 | 5 |  | Team I | Team J | 1 | 3 |  | 5 | Team E
 | 6 |  | Team H | Team G | 1 | 2 |  | 6 | Team F
 | 7 |  | Team J | Team B | 2 | 5 |  | 7 | Team G
 | 8 |  | Team A | Team H | 4 | 0 |  | 8 | Team H
 | 9 |  | Team F | Team D | 7 | 2 |  | 9 | Team I
 | 10 |  | Team G | Team D | 2 | 2 |  | 10 | Team J
 | 11 |  | Team A | Team E | 3 | 3 |  |  | Total
 | 12 |  | Team B | Team F | 0 | 1
 | 13 |  | Team E | Team G | 2 | 0
 | 14 |  | Team I | Team H | 2 | 0
 | 15 |  | Team F | Team E | 3 | 4
 | 16 |  | Team B | Team I | 1 | 0
 | 17 |  | Team J | Team D | 1 | 1
 | 18 |  | Team C | Team J
 | 19 |  | Team D | Team B
 | 20 |  | Team I | Team E
 | 21 |  | Team A | Team C
 | 22 |  | Team D | Team I
 | 23 |  | Team I | Team F
 | 24 |  | Team G | Team A
 | 25 |  | Team H | Team C
 | 26 |  | Team I | Team A
 | 27 |  | Team B | Team G
 | 28 |  | Team D | Team C
 | 29 |  | Team H | Team D
 | 30 |  | Team E | Team J
 | 31 |  | Team C | Team B
 | 32 |  | Team F | Team H
 | 33 |  | Team I | Team C
 | 34 |  | Team H | Team B
 | 35 |  | Team A | Team F
 | 36 |  | Team A | Team J
 | 37 |  | Team E | Team D
 | 38 |  | Team I | Team G
 | 39 |  | Team B | Team E
 | 40 |  | Team J | Team H
 | 41 |  | Team B | Team A
 | 42 |  | Team J | Team F
 | 43 |  | Team A | Team I
 | 44 |  | Team G | Team B
 | 45 |  | Team C | Team D
 | 46 |  | Team H | Team I
 | 47 |  | Team E | Team F
 | 48 |  | Team C | Team A
 | 49 |  | Team I | Team B
 | 50 |  | Team D | Team J
 | 51 |  | Team B | Team D
 | 52 |  | Team J | Team C
 | 53 |  | Team E | Team I
 | 54 |  | Team G | Team J
 | 55 |  | Team E | Team A
 | 56 |  | Team D | Team G
 | 57 |  | Team F | Team B
 | 58 |  | Team G | Team E
 | 59 |  | Team J | Team I
 | 60 |  | Team D | Team A
 | 61 |  | Team F | Team I
 | 62 |  | Team C | Team H
 | 63 |  | Team A | Team G
 | 64 |  | Team J | Team E
 | 65 |  | Team I | Team D
 | 66 |  | Team F | Team C
 | 67 |  | Team B | Team J
 | 68 |  | Team G | Team H
 | 69 |  | Team D | Team F
 | 70 |  | Team H | Team A
 | 71 |  | Team G | Team C
 | 72 |  | Team C | Team E
 | 73 |  | Team F | Team J
 | 74 |  | Team B | Team H
 | 75 |  | Team E | Team B
 | 76 |  | Team H | Team J
 | 77 |  | Team G | Team F
 | 78 |  | Team J | Team A
 | 79 |  | Team D | Team E
 | 80 |  | Team E | Team H
 | 81 |  | Team F | Team G
 | 82 |  | Team H | Team F
 | 83 |  | Team C | Team I
 | 84 |  | Team A | Team B
 | 85 |  | Team G | Team I
 | 86 |  | Team C | Team F
 | 87 |  | Team F | Team A
 | 88 |  | Team B | Team C
 | 89 |  | Team D | Team H
 | 90 |  | Team J | Team G
Spreadsheet: 150496d1334580190-working-schedule-hjb-schedule
Sheet: Master

Plt No | Part | Name | Cycle Time | Scheduled Time | Extra for 1st one | Minus | I/D | Scheduled Finish | I/D | Dkt No when finished | Actual Finish | Operator
 |  |  | 16:00:00 | 07:00:00 |  |  |  | 07:00:00
2 | 0B071500023 | QTS 2 Axis Turret | 107 | 02:19:00 |  |  | Thur | 09:19:00 | D6 |  | 09:25:00 | [NAME]
1 | 0B071500023 | QTS 2 Axis Turret | 107 | 02:19:00 |  |  |  | 11:38:00 | D4 |  | 12:05:00 | [NAME]
2 | 0B071500023 | QTS 2 Axis Turret | 107 | 02:19:00 |  |  |  | 13:57:00 | D7 |  | 14:50:00 | [NAME]
1 | 0B071500023 | QTS 2 Axis Turret | 107 | 02:19:00 |  |  | Fri | 07:00:00 | D5 | 71092 | 06:35:00 | [NAME]
2 | 0B071500023 | QTS 2 Axis Turret | 107 | 02:19:00 |  |  |  | 09:19:00 | D8 |  | 09:40:00 | [NAME]
1 | 0B071500023 | QTS 2 Axis Turret | 107 | 02:19:00 |  |  |  | 11:38:00 | D10 |  | 12:20:00 | [NAME]
2 | 0B071500023 | QTS 2 Axis Turret | 107 | 02:19:00 |  |  |  | 13:57:00 | D9 |  | 15:05:00 | [NAME]
1 | 0B071500023 | QTS 2 Axis Turret | 107 | 02:19:00 |  |  | Sat | 07:00:00 | D11 | 71383 | 06:45:00 | [NAME]
2 | [PHONE] | QTN [NAME] | 114 | 02:28:00 |  | 02:28:00 | Sun | 07:00:00
1 | [PHONE] | QTN [NAME] | 114 | 02:28:00 |  |  |  | 09:28:00
2 | [PHONE] | QTN 350 M Turret. | 102 | 02:12:00 |  |  | Mon | 11:40:00
1 | [PHONE] | QTN 350 M Turret. | 102 | 02:12:00 |  |  |  | 13:52:00
2 | [PHONE] | QTN 350 M Turret. | 102 | 02:12:00 |  |  | [NAME] | 07:00:00
1 | [PHONE] | QTN 350 M Turret. | 102 | 02:12:00 |  |  |  | 09:12:00
2 | 0B081500311 | QTS 350 M Turret | 185 | 06:00:00 | 02:00:00 |  |  | 15:12:00
1 | 0B081500311 | QTS 350 M Turret | 185 | 04:00:00 |  |  | Wed | 07:00:00
2 | 0B081500023 | QTS 350 2Axis [NAME] | 148 | 04:12:00 | 01:00:00 |  |  | 11:12:00
1 | 0B081500023 | QTS 350 2Axis [NAME] | 148 | 03:12:00 |  |  |  | 14:24:00
2 | 0B081500023 | QTS 350 2Axis [NAME] | 148 | 03:12:00 |  |  | Thur | 07:00:00
1 | [PHONE] | QTN 350 M Turret. | 102 | 04:12:00 | 02:00:00 |  |  | 11:12:00
2 | [PHONE] | QTN 350 M Turret. | 102 | 02:12:00 |  |  |  | 13:24:00
1 | [PHONE] | QTN 350 M Turret. | 102 | 02:12:00 |  |  |  | 15:36:00
2 | [PHONE] | QTN 350 M Turret. | 102 | 02:12:00 |  |  | Fri | 07:00:00
1 | 0B071500563 | QTS M Turret | 170 | 05:41:00 | 02:00:00 |  |  | 12:41:00
2 | 0B071500563 | QTS M Turret | 170 | 03:41:00 |  |  | Sat | 07:00:00
1 | 0B071500563 | QTS M Turret | 170 | 03:41:00 |  |  |  | 10:41:00
2 | 0B071500563 | QTS M Turret | 170 | 03:41:00 |  |  |  | 14:22:00
1 | 0B071500563 | QTS M Turret | 170 | 03:41:00 |  |  | Mon | 07:00:00
2 | 0B071500563 | QTS M Turret | 170 | 03:41:00 |  |  |  | 10:41:00
1 | 0B071500563 | QTS M Turret | 170 | 03:41:00 |  |  |  | 14:22:00
2 | 0B071500563 | QTS M Turret | 170 | 03:41:00 |  |  | [NAME] | 07:00:00
1 | 0B071500563 | QTS M Turret | 170 | 03:41:00 |  |  |  | 10:41:00
2 | 0B071500563 | QTS M Turret | 170 | 03:41:00 |  |  |  | 14:22:00
1 | 0B071500563 | QTS M Turret | 170 | 03:41:00 |  |  | Wed | 07:00:00
Spreadsheet: 0a145a3c-f30c-4991-acdc-a1947774b273
Sheet: Sheet1

Release: Annual Estimates of the Population of Metropolitan and Micropolitan Statistical Areas | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=111
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-08-28 10:53 AM CDT
 | Real-Time | Period
Name: | Start | End
Annual Estimates of the Population of Metropolitan and Micropolitan | 2005-06-07 00:00:00 | Current
Statistical Areas
Link:
http://www.census.gov/popest/ | 2005-06-07 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2005-06-07 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2005-06-07 00:00:00
2006-01-19 00:00:00
2006-08-21 00:00:00
2006-09-14 00:00:00
2007-04-05 00:00:00
2008-03-27 00:00:00
2009-03-19 00:00:00
2010-03-25 00:00:00
2012-04-05 00:00:00
2013-03-27 00:00:00
2014-06-20 00:00:00
Spreadsheet: 822816d1679550431-a-little-complicated-range-selection-example2-ans2
Sheet: List1

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | HOUR
 |  | [NAME] | Čet | Pet | Sub | Ned | Pon | Uto | [NAME] | Čet | Pet | Sub | Ned | Pon | Uto | [NAME] | Čet | Pet | Sub | Ned | Pon | Uto | [NAME] | Čet | Pet | Sub | Ned | Pon | Uto
1. | NAME 1 | 12 | 5 | 7 |  |  |  | 12 | 5 | 7 |  | 12 |  | 12 | 5 | 7 |  | 12 | 5 | 7 | bo | bo | bo | bo | bo |  |  | bo | bo
2. | [NAME] 2 | bo | bo | bo |  |  | 12 | 5 | 7 |  | 12 | 5 | 7 |  | 12 | 5 | 7 |  | 12 | 5 | 7 |  | 12 | 5 | 7 |  | 12 | 5 | 7
 |  |  |  | For additional names drag down all formulas
 |  |  |  | NAME1 | 1 |  | 2 |  | 3 |  |  | RESULT
 |  |  |  | NAME2 | 1 |  | 2 |  | 3 |  |  | RESULT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | an example of a formula made by hand
 | 1. First it need to check is in A3:AD3 is word "go", "bo" if FALSE 0
 | 2. If TRUE then need to check range of cells in A2:AD2 for whole Week fom MON to SUN. In example above first sequence is YELLOW. Then he make FORMULA in that range in A3. When it finish first sequence search for second BLUE make same FORMULA, and so on till end.
 |  |  |  |  |  |  |  | FORMULA | "IF(SUM(IN RANGE)>40;SUM(IN RANGE)-40;0)" |  |  |  |  |  |  | basically it count hours and if it is more then 40 return that value
 | It is Croatian so Mon is Pon and Sun is Ned. [NAME] is converted to show croatian time and cells are formated like 24 hours but i think that it doesnt matter
Spreadsheet: eric_saibi__9834__100201
Sheet: Alamitos 05

Owner Name | AES Alamitos LLC
Station Name | Alamitos Power Station
Unit Name | Alamitos 05
NERC Region | WSCC
State | CA
Fuel Type | Natural Gas
Capacity | 495 MW
Start Date | 2001-10-02 00:00:00
End Date | 2001-10-03 00:00:00
Comments | Boiler Tube Leak
SIC | 4931
Plant ID | 1012708
Unit ID | 1005921
Outage ID | 18565
Spreadsheet: 169625d1342984817-need-to-split-multiple-rows-of-four-column-grouping-into-a-single-row-extract-to-row
Sheet: Sheet1

CODE | STAFF # | ADMIN 1 | ADMIN 1 RAW PHONE | ADMIN 1 RAW CELL | ADMIN 1 EMAIL
ALAU | 1 | [NAME] | 5551234567 |  | [EMAIL] | 2 | ALAU1
ALAU | 2 | [NAME] | 5550981234 |  | [EMAIL] |  | ALAU2
ALAU | 3 | [NAME] | 5559801342 | 5554441212 | [EMAIL] |  | ALAU3
ALAU | 4 | [NAME] | 5559994444 |  | [EMAIL] |  | ALAU4
ALAU | 5 | [NAME] | 5558881111 |  | [NAME] |  | ALAU5
ALAU | 6 | [NAME] | 5557778888 |  | [EMAIL] |  | ALAU6
ALAU | 7 | CHRIS LARSON - ADMIN | 5556661212 |  | [EMAIL] |  | ALAU7
AxxU | 1 | [NAME] | 123454678 |  | [EMAIL] | 9 | AxxU1
AxxU | 2 | barbs admin - ADMIN | 123454679 |  | [EMAIL] |  | AxxU2
AxxU | 3 | micky - ADMIN | 123454680 | 5554441212 | [EMAIL] |  | AxxU3
ayyyy | 5 | donny - ADMIN | 3331234 |  | [NAME] | 12 | [NAME]
ayyyy | 6 | abe- ADMIN | 3331234 |  | [EMAIL] |  | ayyyy2
Spreadsheet: 113160d1309146987-find-oldest-record-based-on-another-cell-being-empty-or-not-example
Sheet: Sheet1

Asset Tag | Date | Type | End of Service
555 | 2000-01-01 00:00:00 | Computer | 2009-05-05 00:00:00
666 | 2001-02-02 00:00:00 | Apple | 2009-06-06 00:00:00 |  |  | Note: Actual data is picked in I1 to L1 and shown in B9 through excel camera function
777 | 2004-03-03 00:00:00 | Tree | 2009-07-07 00:00:00
888 | 2006-05-05 00:00:00 | Car | 2009-08-08 00:00:00
999 | 2007-06-06 00:00:00 | Computer
 | The oldest computer STILL IN SERVICE is:
 | B9 should read "(999) 6/6/2007" (without quotes) or "6/6/2007 (999)" without quotes.  Ideally it would recognize that D6 does not have a date in it whereas D1, also a computer, does have a date in it.
Spreadsheet: 845063d1696608413-problem-with-vlookup-test
Sheet: Hierarchy

 |  | STR | Store
 |  | 500 | PFS CANADA
 |  | 309 | EDMONTON
 |  | 351 | TORONTO
 |  | 352 | [NAME]
 |  | 353 | NIAGARA ON THE LAKE
 |  | 354 | COOKSTOWN
 |  | 355 | OTTAWA
 |  | 356 | MONTREAL
 |  | 361 | CALGARY CROSSIRON MILLS
 |  | 362 | WINNIPEG
 |  | 364 | VAUGHAN MILLS FOC
 |  | 365 | TSAWWASSEN
 |  | 366 | VAUGHAN MILLS FOA
Spreadsheet: 536576d1504585494-excel-template-for-monthly-work-recording-pay-by-day-v2
Sheet: Calculations

 |  | Date from | Date to | Sick Days Count |  | Holidays Count |  |  |  |  | Staff | Role | Daily rate |  | Work day
 |  | 2017-08-01 00:00:00 | 2017-08-15 00:00:00 |  |  |  |  |  |  |  | [NAME] | Driver | 600 |  | Normal
Staff | Role | Days worked | Payment due |  |  |  |  |  |  |  | [NAME] | Driver | 600 |  | Sick
[NAME] | Driver |  |  |  | Right |  |  |  |  |  | [NAME] | Helper | 250 |  | Holiday
[NAME] | Driver |  |  |  |  |  |  |  |  |  | [NAME] | Helper | 250
[NAME] | Helper |  |  |  | Wrong |  |  |  |  |  | [NAME] | Driver | 600
[NAME] | Helper
[NAME] | Driver
Spreadsheet: 481612d1474551918-retaining-a-manual-entry-in-an-index-table-comments
Sheet: Control sheet

 | Industry (select from drop-down) |  | Name | Phone | [NAME] | Comments
 | Manufacturing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manufacturing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plastics
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marketing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Automotive
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Legal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Food & Beverage
Spreadsheet: 838079d1690695555-change-sheet-refernce-incrementally-in-adjacent-cells-2023-league-standings-sample
Sheet: T12

Team # | Team Name | Permanent Bowler | Reserves | Lineup | Average | Handicap |  |  |  | Game 1 Scratch | Game 1 Handicap | Game 2 Scratch | Game 2 Handicap | Game 3 Scratch | Game 3 Handicap | Scratch Series | Handicap Series | Indiv Points
12 | A Team | Player35 |  |  |  |  |  |  | Week 1
 |  | Player36 |  |  |  |  |  |  | Week 2
 |  | Player37 |  |  |  |  |  |  | Week 3
 |  |  |  |  |  |  |  |  | Week 4
 |  |  |  |  |  |  |  |  | Week 5
 |  |  |  |  |  |  |  |  | Week 6
 |  |  |  |  |  |  |  |  | Week 7
 |  |  |  |  |  |  |  |  | Week 8
 |  |  |  |  |  |  |  |  | Week 9
 | [NAME] |  |  |  |  |  |  |  | Week 10
 |  | Player35 | 125 |  |  |  |  |  | Week 11
 |  | Player36 | 99 |  |  |  |  |  | Week 12
 |  | Player37 | 100 |  |  |  |  |  | Week 13
 |  | Player38 | 0 |  |  |  |  |  | Week 14
 |  |  |  |  |  |  |  |  | Week 15
 |  |  |  |  |  |  |  |  | Week 16
 |  | Vacant |  |  |  |  |  |  | Week 17
 |  |  |  |  |  |  |  |  | Week 18
 |  |  |  |  |  |  |  |  | Week 19
 | Reserves Lookup |  | Average |  |  |  |  |  | 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
 | VLOOKUP(B11,C11:C18,1,FALSE) |  |  |  |  |  |  |  | Week 37
 |  |  |  |  |  |  |  |  | Week 38
 |  |  |  |  |  |  |  |  | Week 39
 |  |  |  |  |  |  |  |  | Week 40
 |  |  |  |  |  |  |  |  | Week 41
 |  |  |  |  |  |  |  |  | Week 42
 |  |  |  |  |  |  |  |  | Week 43
 |  |  |  |  |  |  |  |  | Week 44
 |  |  |  |  |  |  |  |  | Week 45
Spreadsheet: 754778d1636494293-faster-alternative-to-sumifs-sumifs-alternatives-tms
Sheet: Sheet1 (v2) DynamicNamedRanges

Gas Day | Flow | Pipeline | Path | From | To
2021-09-11 00:00:00 | -526 | El Paso - NML | Dutch Flats | North Permian | Topock
2021-09-11 00:00:00 | -131 | El Paso - NML | Maricopa | North Permian | Topock
2021-09-11 00:00:00 | 1608 | El Paso - NML | NML Cap | Permian | Topock
2021-09-11 00:00:00 | 1608 | El Paso - NML | NML Cap | North Permian | Topock
2021-09-11 00:00:00 | -105 | El Paso - NML | NML Demand | North Permian | Topock
Spreadsheet: 130976d1322675726-fill-out-a-cell-based-on-anothers-value-schedules
Sheet: Sheet1

 | 06:00:00 | 06:15:00 | 06:30:00 | 06:45:00 | 07:00:00 | 07:15:00 | 07:30:00 | 07:45:00 | 08:00:00 | 08:15:00 | 08:30:00 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00
1st Shift
1 |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  |  |  | X
2
3 |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  | X | X
4
1st Shift - Monday
1 | [NAME] | 07:45:00 | 09:50:00 | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 08:15:00 | 10:00:00 | 13:00:00
2 | [NAME] | 07:45:00 | 09:50:00 | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | off | off | off
3 | [NAME] | off | off | off |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 11:45:00 | 15:15:00
4 | [NAME] | 08:40:00 | 11:50:00 | 14:45:00 |  |  |  |  |  |  |  |  |  |  |  |  | off | off | off
 | [NAME] | off | off | off