tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 88119d1288039440-multiple-column-lookup-example-7
Sheet: Legend

Opting Into DB? | New or Existing | Original | Direct Mail Flag | [NAME] (Only if email exists; otherwise no action is taken)
Yes | Existing | Y | N | N
Yes | Existing | Null | Null | Null
Yes | Existing | N | N | N
Yes | New | New Record | Null | Null
No | Existing | Y | Y | Y
No | Existing | Null | Null | Null
No | Existing | N | N | N
No | New | New Record | Y | Y
New Record | Existing Record | Yes | No
New Record | Y | New | New
 | Null | Existing | Existing
 | N
Spreadsheet: 50832d1250332089-excel-2007-help-with-vlookup-hlookup-footy
Sheet: Points

 |  |  |  |  |  |  | Football Sweep
 |  |  |  |  | Rab |  | [NAME] |  | Heather |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Ricky |  | Derek |  | [NAME] A |  | na |  | na |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME] |  | Stuart |  | Rab |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] A |  | [NAME]
 |  |  |  |  | 3 | 0 | 3 | 1 | 2 | 0 | 2 | 0 | 2 | 0 | 3 | 1 | 2 | 1 | 2 | 0 | 2 | 1 | 4 | 0 | 3 | 0
 |  |  |  |  | 1 | 1 | 0 | 2 | 0 | 1 | 1 | 2 | 1 | 2 | 0 | 2 | 1 | 1 | 2 | 2 | 1 | 2 | 1 | 2 | 0 | 0 | na | na | na | na
 |  |  |  |  | 1 | 2 | 1 | 3 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 0 | 1 | 2 | 1 | 2 | 0 | 1 | 1 | 1 | 1 | 2 | na | na | na | na
 |  |  |  |  | 0 | 2 | 1 | 1 | 1 | 2 | 0 | 1 | 0 | 1 | 1 | 2 | 2 | 2 | 0 | 2 | 1 | 1 | 1 | 0 | 1 | 1 | na | na | na | na
 |  |  |  |  | 1 | 1 | 0 | 1 | 1 | 2 | 1 | 2 | 0 | 3 | 0 | 3 | 1 | 3 | 1 | 2 | 1 | 2 | 0 | 3 | 1 | 2 | na | na | na | na
 |  |  |  |  | 2 | 0 | 0 | 2 | 1 | 0 | 0 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 0 | 2 | 0 | 1 | 1 | na | na | na | na
 |  |  |  |  | 2 | 1 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 0 | 2 | 2 | 1 | 1 | 1 | 2 | 0 | 2 | 2 | 1 | 1 | na | na | na | na
 |  |  |  |  | 0 | 2 | 1 | 3 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 3 | 2 | 1 | 2 | 0 | 1 | 0 | 3 | 1 | 1 | 1 | na | na | na | na
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 0 | 2 | 1 | 2 | 0 | 2 | 0 | 1 | 1 | 2 | 1 | 2 | 1 | na | na | na | na
 |  |  |  |  | 0 | 1 | 1 | 2 | 0 | 0 | 2 | 1 | 2 | 0 | 1 | 0 | 2 | 2 | 1 | 1 | 1 | 0 | 2 | 1 | 1 | 2 | na | na | na | na
 |  |  |  |  | 4 | 0 | 3 | 0 | 2 | 0 | 3 | 0 | 2 | 0 | 4 | 0 | 2 | 1 | 3 | 0 | 3 | 0 | 3 | 1 | 3 | 0 | na | na | na | na
h |  | a | d
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME] |  | Stuart |  | Rab |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] A |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Current League Standings
 |  |  |  |  |  |  |  |  | Name |  |  |  | Correct score |  |  | Correct Result |  |  | Points
Spreadsheet: 785483d1656439264-excel-skills-for-business-advanced-week-2-problem-wssa
Sheet: Raw

 | Location | High_F | Low_F | High_C | Low_C |  |  | Helper Index
 | San Antonio, Texas | 80 | 59 | 27 | 15
 | Virginia Beach, Virginia | 68 | 52 | 20 | 11 |  |  | 2
 | Portland, Oregon | 63 | 45 | 17 | 7 |  |  | 3
 | Boston, Massachusetts | 59 | 44 | 15 | 7 |  |  | 4
 | New Orleans, Louisiana | 78 | 61 | 26 | 16 |  |  | 5
 | Atlanta, Georgia | 72 | 53 | 22 | 12 |  |  | 6
 | Austin, Texas | 80 | 59 | 27 | 15 |  |  | 7
 | Denver, Colorado | 64 | 36 | 18 | 2 |  |  | 8
 | Phoenix, Arizona | 87 | 63 | 31 | 17 |  |  | 9
 | Minneapolis, Minnesota | 55 | 37 | 13 | 3 |  |  | 10
 | San Francisco, California | 64 | 51 | 18 | 10 |  |  | 11
 | New York, New York | 62 | 48 | 17 | 9 |  |  | 12
 | Buffalo, New York | 56 | 40 | 14 | 5 |  |  | 13
 | Tampa, Florida | 82 | 65 | 28 | 18 |  |  | 14
 | Cleveland, Ohio | 60 | 43 | 15 | 6 |  |  | 15
 | Dallas, Texas | 77 | 57 | 25 | 14 |  |  | 16
 | Birmingham, Alabama | 74 | 53 | 23 | 12 |  |  | 17
 | Indianapolis, Indiana | 63 | 44 | 17 | 7 |  |  | 18
 | Miami, Florida | 84 | 70 | 29 | 21 |  |  | 19
 | Houston, Texas | 80 | 60 | 27 | 16 |  |  | 20
 | San Jose, California | 71 | 50 | 22 | 10 |  |  | 21
 | Pittsburgh, Pennsylvania | 61 | 42 | 16 | 6 |  |  | 22
 | Kansas City, Missouri | 66 | 48 | 19 | 9 |  |  | 23
 | St. Louis, Missouri | 66 | 48 | 19 | 9 |  |  | 24
 | Sacramento, California | 74 | 48 | 23 | 9 |  |  | 25
 | Providence, Rhode Island | 61 | 43 | 16 | 6 |  |  | 26
 | Columbus, Ohio | 63 | 44 | 17 | 7 |  |  | 27
 | Nashville, Tennessee | 70 | 49 | 21 | 9 |  |  | 28
 | Hartford, Connecticut | 61 | 40 | 16 | 5 |  |  | 29
 | Orlando, Florida | 83 | 63 | 28 | 17 |  |  | 30
 | Baltimore, Maryland | 65 | 45 | 18 | 7 |  |  | 31
 | Raleigh, North Carolina | 72 | 50 | 22 | 10 |  |  | 32
 | Louisville, Kentucky | 68 | 49 | 20 | 9 |  |  | 33
 | Salt Lake City, Utah | 64 | 42 | 18 | 5 |  |  | 34
 | Richmond, Virginia | 70 | 48 | 21 | 9 |  |  | 35
 | Washington, DC | 67 | 50 | 19 | 10 |  |  | 36
 | Charlotte, North Carolina | 71 | 49 | 22 | 9 |  |  | 37
 | Detroit, Michigan | 59 | 42 | 15 | 5 |  |  | 38
 | Rochester, New York | 57 | 39 | 14 | 4 |  |  | 39
 | Oklahoma City, Oklahoma | 72 | 51 | 22 | 10 |  |  | 40
 | Jacksonville, Florida | 79 | 58 | 26 | 14 |  |  | 41
 | Seattle, Washington | 61 | 46 | 16 | 8 |  |  | 42
 | Riverside, California | 81 | 53 | 27 | 11 |  |  | 43
 | Milwaukee, Wisconsin | 56 | 40 | 13 | 5 |  |  | 44
 | Memphis, Tennessee | 73 | 54 | 23 | 12 |  |  | 45
 | Los Angeles, California | 75 | 56 | 24 | 13 |  |  | 46
 | San Diego, California | 70 | 58 | 21 | 14 |  |  | 47
 | Las Vegas, Nevada | 80 | 59 | 27 | 15 |  |  | 48
 | Philadelphia, Pennsylvania | 65 | 47 | 18 | 8 |  |  | 49
 | Cincinnati, Ohio | 65 | 43 | 18 | 6 |  |  | 50
 | Chicago, Illinois | 59 | 41 | 15 | 5 |  |  | 51
Spreadsheet: 154439d1336426507-excel-2007-excel-percentages-kedon-ar-2011-copy
Sheet: 042

 |  |  |  |  | 0.003
Account Number | City, State | Balance | Subsequent payment | Adjustment Amount | Bad Debt Expense
100-042-00000.00 00020 | Albany, Ga | 15 | -15
100-042-00000.00 00030 | Americus, GA | 7606.34 | -1190.5
100-042-00000.00 00040 | [NAME], SC | 66556.76 | 0
100-042-00000.00 00080 | Atlanta, Ga - Berean | 270 | 0
100-042-00000.00 00094 | Atlanta, GA - Ebenezer French | 129621.04 | -17706
100-042-00000.00 00095 | Atlanta, GA - Philadelphia FR | 22398.21 | 0
Spreadsheet: 94284d1294146741-excel-2007-automatic-conditional-merging-automatic-conditional-merging
Sheet: Pivot Table

a | b | c | d | e
S5903050 | 72506 | 001039760 | 1884 | 2583622
S5918277 | 72506 | 001039795 | 1922 | 2583622
 |  |  | 1923 | 2583622
S5968426 | 72506 | 001039761 | 1885 | 2583622
S5986311 | 72506 | 001039802 | 1930 | 2583622
S6583861 | 72506 | 001039788 | 1912 | 2583622
S6597063 | 72506 | 001039776 | 1900 | 2583622
S6604732 | 72506 | 001039800 | 1928 | 2583622
Spreadsheet: 103266d1301035663-extracting-data-from-a-cell-help-request-11-3-25
Sheet: Sheet1

 | Amount | Qty | Total Cost | With variable lenght | With same lenght | Qty | total cost
01-556-6134    1EA    $3,94 EA | 3.94 | 1
01-361-8386    1EA    $18,48 BG | 18.48 | 1
01-556-6508    1EA    $0,62 BG | 0.62 | 1
01-581-0106    1EA    $53,17 EA | 53.17 | 1
01-556-6057    2EA    $3,26 EA | 3.62 | 2
01-581-0102    1EA    $57,83 EA | 57.83 | 1
01-512-1519    6EA    $0,53 EA
01-568-6030    1EA    $698,00 EA
00-137-9240    2EA    $2,68 EA
01-583-8521    2EA    $12,57 EA
01-556-6605    1EA    $18,51 BG
01-512-1654    1EA    $0,80 EA
01-512-6164    1EA    $0,27 EA
01-587-3381    1EA    $100,00 EA
01-556-4751    1EA    $3,58 EA
01-556-6155    1EA    $16,30 BG
01-372-1516    4FT    $2,61 FT
01-556-4707    4FT    $4,96 FT
01-577-1125    1EA    $117,83 EA
01-556-4631    4EA    $0,09 EA
01-166-8517    4EA    $0,05 EA
Spreadsheet: 702099d1604078499-vlookup-match-function-requires-tweaking-to-distinguish-between-2-data-lookup-ranges-radio-buttons
Sheet: Prototype

 | 1 | 1 | 2 | 3 | 4 | 5 | 6
 | A
 | B
 | C
Group |  | 1 | 2 | 3 | 4 | 5 | 6
1 | A | A11 | A12 | A13 | A14 | A15 | A16
 |  | A21 | A22 | A23 | A24 | A25 | A26
 |  | A31 | A32 | A33 | A34 | [NAME] | A36
2 | B | B11 | B12 | B13 | B14 | B15 | B16
 |  | B21 | B22 | B23 | B24 | B25 | B26
 |  | B31 | B32 | B33 | B34 | B35 | B36
3 | C | C11 | C12 | C13 | C14 | C15 | C16
 |  | C21 | C22 | C23 | C24 | C25 | C26
 |  | C31 | C32 | C33 | C34 | C35 | C36
Spreadsheet: 0a2bd4ea-0ccb-49d9-a5de-27d897f531a7
Sheet: Calculations

Yes
No
Are they pregnant?
Are they under 19 years old?
This person may be eligible for Medicaid.
This person would not be eligible for Medicaid
This person does not qualify for presumptive eligibility.
Please complete the highlighted question.
Please tell us about each household member and their income.
None | *0
Annually | /12
Bi-Weekly | *2.15
Monthly
Quarterly | /3
Semi-Annually | /6
Semi-Monthly | *2
Weekly | *4.3
 | Title XIX Rules | Title XIX Rules | Title XIX Rules | 88 Basic | 67 Pregnancy | 60 Basic | 86 Basic | 80 Basic
 | 82 Basic | Need DRA | Need DRA | 89 Enhanced | Title XIX Rules | 63 Enhanced | 87 Enhanced | 81 Enhanced
 | 83 Enhanced |  |  | Title XIX Rules | Need DRA | Age 6-19 | 76 Access | 71 Access
 | Need DRA |  |  | Need DRA |  | Title XXI Rules | Title XXI Rules | Title XXI Rules
1 | 205 | 643 | 1190 | 958 | 1273 | 958 – 1273 | 1436 | 1771
2 | 251 | 786 | 1454 | 1293 | 1719 | 1293 - 1719 | 1939 | 2391
3 | 317 | 991 | 1833 | 1628 | 2165 | 1628 - 2165 | 2441 | 3011
4 | 382 | 1196 | 2213 | 1963 | 2610 | 1963 - 2610 | 2944 | 3631
5 | 448 | 1401 | 2592 | 2298 | 3056 | 2298 - 3056 | 3446 | 4250
6 | 513 | 1606 | 2971 | 2633 | 3501 | 2633 - 3501 | 3949 | 4870
7 | 579 | 1811 | 3350 | 2968 | 3947 | 2968 - 3947 | 4451 | 5490
8 | 645 | 2016 | 3730 | 3303 | 4392 | 3303 - 4392 | 4954 | 6110
Additional Individual | 65 | 205 | 380 | 335 | 446 |  | 503 | 620
9 | 710 | 2221 | 4110 | 3638 | 4838 |  | 5457 | 6730
10 | 775 | 2426 | 4490 | 3973 | 5284 |  | 5960 | 7350
11 | 840 | 2631 | 4870 | 4308 | 5730 |  | 6463 | 7970
12 | 905 | 2836 | 5250 | 4643 | 6176 |  | 6966 | 8590
13 | 970 | 3041 | 5630 | 4978 | 6622 |  | 7469 | 9210
14 | 1035 | 3246 | 6010 | 5313 | 7068 |  | 7972 | 9830
15 | 1100 | 3451 | 6390 | 5648 | 7514 |  | 8475 | 10450
Spreadsheet: 834592d1687934867-i-need-som-help-with-my-excel-sheet-for-risk-management-example
Sheet: Riskregister

Risk-ID | Analysobjekt | Hotkategori | Threat | Probability | Most likely probability | Pert beta Distribution | Motivering sannolikhet | Consequense | Most likely consequense | Pert beta distribution2 | Motivering konsekvensnivå | Exposure level | Motivering exponeringsnivå | [NAME] beräknad | Risk | Risk level
R-001 | x.x.x | Personalbrist | It rains | 1 & < 9,99 ggr/år (Måttlig) | 3 |  |  | 100-999 tkr (måttlig) | 100 |  |  | Måttlig (Rv +0)
R-002 |  |  | it snows | 0,1 & < 0,99 ggr/år (Låg) | 0.5 |  |  | 1000-4999 tkr (Allvarlig) | 4000 |  |  | Måttlig (Rv +0)
R-003 |  |  | hell freezes over | 0 & < 0,099 ggr/år ([NAME] låg) | 0.08 |  |  | > 5000 tkr ([NAME] allvarlig) | 20000 |  |  | Låg (Rv -1)
Spreadsheet: d3c7295a-9904-43e7-8c54-c27a9bfbd359
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44390116 | 2014-12-10 23:13:25 | ALLIES | 0 | 2 | 6 | 1375770 | damsr | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
44390925 | 2014-12-10 23:42:13 | AXIS | 0 | 3 | 6 | 1375770 | damsr | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
44414161 | 2014-12-12 19:52:13 | AXIS | 0 | 3 | 6 | 1671057 | SigmundFreud | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
44456411 | 2014-12-15 17:24:31 | AXIS | 1 | 6 | 2 | 1509251 | mrmanley31 | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44456497 | 2014-12-15 17:39:17 | ALLIES | 0 | 5 | 6 | 1509251 | mrmanley31 | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44459657 | 2014-12-15 21:40:57 | ALLIES | 0 | 2 | 7 | 701256 | player701256 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
44459827 | 2014-12-15 21:52:14 | AXIS | 0 | 4 | 7 | 701256 | player701256 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
44469527 | 2014-12-16 15:40:50 | ALLIES | 1 | 10 | 5 | 1680945 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44469726 | 2014-12-16 16:15:46 | AXIS | 1 | 10 | 7 | 1680945 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44487803 | 2014-12-17 22:24:50 | ALLIES | 1 | 6 | 5 | 1546936 | KATANA PAPA | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
44488102 | 2014-12-17 22:45:33 | AXIS | 0 | 0 | 6 | 1546936 | KATANA PAPA | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
44510541 | 2014-12-19 17:10:40 | AXIS | 0 | 4 | 10 | 1088314 | bino_zoet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44510747 | 2014-12-19 17:32:07 | ALLIES | 1 | 10 | 4 | 1088314 | bino_zoet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 806025d1669056365-counting-unique-values-within-multiple-values-efmultivalue
Sheet: Sheet1

Account | Month |  |  |  |  | Account | Jan | Feb | Mar | Apr | May | Jun
10 | Jan |  |  |  |  | 10
12 | Feb |  |  |  |  | 12
15 | Mar |  |  |  |  | 15
15 | Apr
10 | May |  |  |  |  | Account | Jan | Feb | Mar | Apr | May | Jun
15 | Jun |  |  |  |  | 10 | 1 |  |  |  | 1
15 | Jun |  |  |  |  | 12 |  | 1
 |  |  |  |  |  | 15 |  |  | 1 | 1 |  | 2
Spreadsheet: 725532d1616728650-locating-a-corresponding-value-by-looking-for-a-value-in-a-previous-cell-locating-a-corresponding-value-from-previous-cells-values
Sheet: Sheet1

 | Present | Prev 1 | Prev 2 | Prev 3 | Prev 4
[NAME] | 0
[NAME] | 0.15
[NAME] | 0.02
[NAME] | -0.11
[NAME] | 0.06
[NAME] | 0 | 0
[NAME] | -0.04
[NAME] | -0.02 | 0.06 | 0.02
[NAME] | -0.01 | 0 | 0
[NAME] | -0.03
[NAME] | 0.02 | 0
[NAME] | 0.07 | -0.02 | 0.06 | 0.02
[NAME] | -0.03 | -0.01 | 0 | 0.15
[NAME] | 0.04 | -0.03
 | [NAME] required in cells C2:F15 to return values as shown above
 | The table above is in chronological order. [NAME] at the top is the first event. [NAME] at the bottom is the most recent event
 | Starting from the most recent event [NAME] (row 15) and then working upwards, I would like to locate all the other [NAME]' and place them in cells C15:F15 within the grid
 | ..then do the same for [NAME] in A14 and place all the previous [NAME] values in C14:F14… and so on
 | Examples
 | Cell C15 needs to return -0.03 because it looks at cell A15 ([NAME]) and searches for the most recent [NAME] in A:A (A11) and places the B row equivalent value (which is -0.03 found in B11) into that cell
 | Cell C14 returns -0.01 because it looks for the previous [NAME] in A10 and returns B10. Then, [NAME] looks for the next previous [NAME] (A7) therefore returning the value in B7. E14 returns 0.15. F15 returns nothing because there are no more [NAME]'s in the list
Spreadsheet: eric_saibi__9841__100401R
Sheet: San Juan 04 (3)

Owner Name |  | New Mexico Public Service Company
Station Name |  | San Juan Generating Station
Unit Name |  | San Juan 04
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 534 MW
Start Date |  | 2001-10-02 00:00:00
End Date |  | 2001-10-04 00:00:00
Prv. Start Date |  | 2001-10-02 00:00:00
Prv. End Date |  | 2001-10-05 00:00:00
Comments |  | Unit was back online early in the a.m. 10/4/01. Unit will begin turbine work starting. 10/6/01 not 10/5/01 as we previously had. Called back to clarify. Planned outage # 18528
SIC |  | 4911
Plant ID |  | 1016385
Unit ID |  | 1007773
Outage ID |  | 18570
Spreadsheet: 869666d1716277119-propotionally-assign-condition-total-condition-1-aligw
Sheet: Sheet1

Object code | Object | Condition | Area size | Total area | Total condition
AIAHARIDUSKESK_3 | PARGISAREVERE | 4 | 2406.1 |  | 3
AIAHARIDUSKESK_3_1 | PARGISAREVERE | 3 | 3000 |  | 3
ADALA2D | ADALA2D | 5 | 392.1 |  | 5
ADALA2D01 | ADALA2D | 2 | 0 |  | 5
ADALA2D02 | ADALA2D | 2 | 0 |  | 5
ADALA2D03 | ADALA2D | 5 | 624.7 |  | 5
ADALA2D04 | ADALA2D | 5 | 1265.7 |  | 5
ADALA2D05 | ADALA2D | 4 | 1013.4 |  | 5
ADALA4E_1 | ADALA2D | 3 | 569 |  | 5
ADALA4E_2 | ADALA2D | 3 | 128.1 |  | 5
ADALA4E_3 | ADALA2D | 2 | 453.8 |  | 5
ADALA4E_4 | ADALA2D | 2 | 1000.1 |  | 5
Spreadsheet: 855958d1705395931-looking-to-find-the-correct-formulas-open-to-ideas-copy-panel-builder
Sheet: PANEL BUILDER

WESCO PANEL BUILDER TOOL |  |  |  |  |  |  |  |  | PART NUMBERS NEEDED SHOWN BELOW (EXCLUDES ACCESSORIES) - NOTE THAT TUB SIZES MAY BE DIFFERENT IF SUB FEED OR THROUGH FEED LUGS ARE REQUIRED. REFER TO WESCO REPRESENTATIVE FOR ASSISTANCE.
MAIN BREAKER REQUIRED? | IF YES, MAIN BREAKER AMPERAGE? | 1PH OR 3PH? | VOLTAGE? | BUS AMPERAGE? | CIRCUITS? | BUS MATERIAL? | SURFACE OR FLUSH MOUNT? |  |  |  | BOX PART # | INTERIOR PART # | TRIM PART #
NO | N/A | 3PH | 120/208V | 225A | 42CC | AL | SURFACE
 |  |  |  |  |  |  |  |  |  | WESCO SIM # -->
Spreadsheet: 726979d1617633110-nested-if-then-and-statements-ob-scan-status-forum
Sheet: Sheet1

MRN | Date | Appt Time | Appt Status | Next Appt Date | Recshed/New Appt
1181073 | 2021-01-13 00:00:00 | 11:30:00 | No Show | 2021-04-06 00:00:00 | NO ACTION NEEDED
1728888 | 2021-04-06 00:00:00 | 17:15:00 | Sch | 2021-04-06 00:00:00 | FUTURE
2431003 | 2021-04-09 00:00:00 | 15:45:00 | Sch | 2021-04-09 00:00:00 | FUTURE
2611505 | 2021-03-09 00:00:00 | 15:15:00 | No Show | 2021-04-07 00:00:00 | NS/SCHED
2611505 | 2021-04-07 00:00:00 | 15:00:00 | Sch | 2021-04-07 00:00:00 | NS/SCHED
2657722 | 2021-03-25 00:00:00 | 13:30:00 | No Show | 2021-04-06 00:00:00 | NS/SCHED
2657722 | 2021-04-01 00:00:00 | 15:45:00 | Sch | 2021-04-06 00:00:00 | NS/SCHED
2657722 | 2021-04-06 00:00:00 | 15:45:00 | Sch | 2021-04-06 00:00:00 | NS/SCHED
2686160 | 2021-02-23 00:00:00 | 09:45:00 | No Show |  | CALL PT
2785127 | 2021-01-06 00:00:00 | 15:30:00 | No Show | 2021-04-09 00:00:00 | NO ACTION NEEDED
2971347 | 2021-04-08 00:00:00 | 13:45:00 | Sch | 2021-04-07 00:00:00 | FUTURE
3196920 | 2021-02-10 00:00:00 | 11:00:00 | No Show | 2021-04-07 00:00:00 | NS/SCHED
3196920 | 2021-04-07 00:00:00 | 11:30:00 | Sch | 2021-04-07 00:00:00 | NS/SCHED
19465582 | 2021-04-06 00:00:00 | 16:30:00 | Sch | 2021-04-06 00:00:00 | FUTURE
19465582 | 2021-04-20 00:00:00 | 17:15:00 | Sch | 2021-04-06 00:00:00 | FUTURE
19465582 | 2021-04-27 00:00:00 | 16:30:00 | Sch | 2021-04-06 00:00:00 | FUTURE
19548155 | 2021-03-30 00:00:00 | 11:15:00 | No Show | 2021-04-08 00:00:00 | NO ACTION NEEDED
19616648 | 2021-04-23 00:00:00 | 11:30:00 | Sch | 2021-04-23 00:00:00 | FUTURE
20176244 | 2021-03-16 00:00:00 | 16:15:00 | No Show |  | CALL PT
Spreadsheet: 472745d1469725906-employee-attendance-tracker-viewing-all-together-on-a-year-calendar-welse
Sheet: Settings

 | List of Employees |  | Type of Leave |  | Company Holidays | Description
 | Employee 1 |  | [NAME] |  | 2012-01-01 00:00:00 | New Year's Day
 | Employee 2 |  | Annual |  | 2012-07-04 00:00:00 | Independence Day
 | Employee 3 |  | Bereavement |  | 2012-11-24 00:00:00 | Thanksgiving
 | Employee 4 |  | Compassionate |  | 2012-11-25 00:00:00 | Thanksgiving
 | Employee 5 |  | Study/Workshop |  | 2012-12-24 00:00:00 | Christmas
 |  |  |  |  | 2012-12-26 00:00:00 | Christmas
 |  |  |  |  | 2012-12-31 00:00:00 | New Year's Eve
Spreadsheet: 686132d1594377808-how-to-create-a-formula-but-only-if-it-doesnt-match-any-entries-in-another-column-payrol-test-v11
Sheet: Payroll ID & Holiday

Payroll Ref | Name | Surname |  | Status | Check everyone included | Accrued Holiday pay last month | Holiday pay this month
1 | [NAME] | Smith |  | Active Salaried
2 | [NAME] | Smith |  | Active Salaried
3 | [NAME] | Johns |  | Terminated
5 | Lula | [NAME] |  | Active |  | 309.2
6 | Milo | Blue |  | Active |  | 0
7 | Trent | Soundly |  | Terminated
8 | [NAME] | [NAME] |  | Terminated
9 | Carol | [NAME] |  | Active |  | 442.19
10 | Archie | Bored |  | Active |  | 373.65
11 | [NAME] | black |  | Active |  | 791.3
12 | [NAME] | green |  | Active |  | 0
13 | [NAME] | rays |  | Suspended
14 | Traver | Powers |  | Active |  | 358.7
15 | Yanis | [NAME] |  | Terminated
Spreadsheet: 889445d1740236183-creating-a-dynamic-table-from-a-pivot-from-google-sheets-pgt-aol-dashboard-burnsie-
Sheet: Lookup - PASTE LINK HERE

Programme | Module | Year | Below expectations | Meets expectations | Exceeds expectations | Dashboard!a7:f11
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1B37SHd5uy7eYHqXEHv3kxP8myBMIRjrUoVjCTTeupIk/edit?gid=54982496#gid=54982496
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1FXsN_7aoJSGmPbWQQdbewT3C1B363aEvsqFW3FHzfkw/edit?gid=54982496#gid=54982496
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1iqMT1dKx7uSeLlgxSw7pDceBJQj4e5sJCVQF99t2bbg/edit?gid=54982496#gid=54982496
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1y-8o4-wwDYYici3J6gqU4wjyJA6lsGI2D5P_tWE1za4/edit?gid=54982496#gid=54982496
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1iOlGUIa-e2Tg07ADHZQ6MMl2T6OIwi4vzB3z3KT2x_U/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1ukZclxqiR6uX4vazxSnpFULwsDYn4J8di_sPrc9Cfgg/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/18Sv2gzrD6Fv-UHzTUl6v3eBD_9aQRyN08LbbXl1ym9Q/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/10GRe5pK0ZAHEZizBYF9mrCHigkHTffayXLvevYTvbtA/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1tyb3DwUQHetdEqoMy3k-IaC5Ilgb7iK6kHCAk4SDTdM/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1Gpr8vJyQevkQt9LlizZGd7T4fDLTc5r9861E47_gFr8/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1DwMWkGhyQmM-GodUpcBEBID5-4kEFTw5Rf1a9Jaqbko/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1763ZpmQJWat7lFqVFE0ZvDQp8ST9gmzBjhFhoAUr6s0/edit?gid=[PHONE]#gid=[PHONE]
Spreadsheet: 774732d1648638274-if-and-formula-would-work-here-example
Sheet: Current

 | Number | [NAME] | Category | % |  |  | Category
 | 59 | 25000 |  | 22.5 |  |  | A | 0 up to and including 59
 | 60 | 25000 |  | 26.25 |  |  | B | More than 59 up to and including 99
 | 100 | 26002 |  | 24 |  |  | C | More than 99 up to and including 139
 |  |  |  |  |  |  | D | More than 139 up to and including 179
 |  |  |  |  |  |  | E | More than 179
 |  |  |  |  |  |  | [NAME] |  | Categories
 |  |  |  |  |  |  |  |  | A | B | C | D | E
 |  |  |  |  |  |  |  |  | % | % | % | % | %
 |  |  |  |  |  |  | -- | 26000 | 22.5 | 26.25 | 30 | 30 | 37.5
 |  |  |  |  |  |  | 26001 | 39000 | 18 | 21 | 24 | 24 | 30
 |  |  |  |  |  |  | 39001 | 52000 | 13.5 | 15.75 | 18 | 18 | 22.5
Spreadsheet: 268612d1380713141-change-a-date-cell-to-red-test-piece-traceability-sheet
Sheet: Sheet1

[NAME]. | Date In | Customer | Part No. | Batch No. | Description | Spec. | Cast | Qty | Process | T/P No.
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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96