tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41654d1240218419-if-name-then-cell-reference-example
Sheet: Summary

 | [NAME] | Score 1 | Score 2 | Score 3 | Score 4 | Score 5 | Total Score % | Extra Cost £
 | Chanowsk, Ania | 0.9 | 0 | N/A | N/A | N/A | 0.45 | 10.5
 | Davies, [NAME] | 0 | N/A | N/A | N/A | N/A | 0 | 0
 | Hilton, [NAME] | 0.9 | N/A | N/A | N/A | N/A | 0.9 | 0
 | Jones, [NAME] | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME], [NAME] | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 | Lyon, [NAME] | 0 | N/A | N/A | N/A | N/A | 0 | 0
 | McCormack, Kirsty | 1 | N/A | N/A | N/A | N/A | 1 | 0
 | McDonald, [NAME] | 0 | 0 | N/A | N/A | N/A | 0 | 1.27
 | Osborne, [NAME] | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 | White, [NAME] | 0 | 0 | N/A | N/A | N/A | 0 | 7
 | Yates, [NAME] | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 |  |  |  |  |  |  |  | 18.77
Spreadsheet: 170765d1343398796-excel-2007-sumif-index-match-formula-book2
Sheet: dump

 | Jan | Feb | March
xxxx | 1 | 6 | 7
yyyy | 8 | 2 | 5
zzzz | 9 | 0 | 4
xxxx | 1 | 6 | 7
yyyy | 8 | 2 | 5
zzzz | 9 | 0 | 4
 | 36 | 16 | 32
Spreadsheet: cce000e6-5c1a-48f9-b98e-ea07ce68587c
Sheet: Sheet1

Comparison of the heart remodelling transcriptional map with other transcriptome studies of ecdysone regulated processes | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Expression clusters | Midgut metamorphosis |  | Steroid Cell Death |  | Ecdysone-induced, [NAME]-dpt
 | up­ (n = 487) | down¯ (n = 459) | up­ ( n =697 ) | down¯ ( n = 708 ) | up­ ( n = 414 ) | down¯ ( n = 70 )
1 - 5   (n = 676) | 74 (2.0E-19)* | 43 (1.5E-05) | 124 (9.8E-40)* | 58 (3.0E-05) | 53 (3.3E-11)* | 8 (1.7E-02)
6 - 7   (n = 129) | 8 (8.1E-02) | 6 (2.5E-01) | 6 (6.2E-01) | 9 (2.0E-01) | 9 (1.4E-02) | 3 (2.6E-02)
8 - 12 (n = 765) | 35 (4.9E-02) | 27 (3.4E-01) | 31 (8.8E-01) | 60 (3.0E-04) | 25 (3.0E-01) | 3 (7.4E-01)
13       (n = 90) | 7 (3.7E-02) | 6 (7.5E-02) | 6 (2.9E-01) | 12 (1.8E-03) | 5 (1.3E-01) | 2 (7.3E-02)
1 - 13 (n = 1660) | 124 (6.4E-18)* | 82 (4.5E-05) | 167 (6.9E-21)* | 139 (1.9E-10)* | 92 (4.5E-10)* | 16 (5.8E-03)
Spreadsheet: 01a31d1e-d5f9-4040-8860-d52e1a953237
Sheet: Easements

 | IMPLAN Sector
WRP
Permanent Easement | 10007 |  | 0.7
30 Year Easements | 10007 |  | 0.7
Restoration | 11
Survey Costs | 369
Closing Costs | 367
Spreadsheet: 130173d1322109952-managing-rules-in-conditional-formatting-color-time-change
Sheet: LOOKUP

 |  | 14:20:13
 |  | NEEDED BY
 | PRODUCT 1 | 15:00:00
 | PRODUCT 2 | 23:00:00
 | PRODUCT 3 | 10:00:00
 | PRODUCT 4 | 04:00:00
 | PRODUCT 5 | 20:30:00
 | PRODUCT 6 | 04:30:00
 | PRODUCT 7 | 06:30:00
 | PRODUCT 8 | 19:00:00
 | PRODUCT 9 | 11:30:00
 | PRODUCT 10 | 01:00:00
 | PRODUCT 11 | 08:30:00
 | PRODUCT 12 | 06:30:00
Spreadsheet: 842885d1694875122-automatically-updates-score-sheet-live-sample1-2-2-
Sheet: SELECTIONS

 | VENUE 1 |  |  |  |  |  |  |  |  |  |  | VENUE 2 |  |  |  |  |  |  |  |  |  |  | Race 1 |  |  | Race 2 |  |  | Race 3 |  |  | Race 4 |  |  | Race 5 |  |  | Race 6 |  |  | Race 7 |  |  | Race 8 |  |  | Race 9 |  |  | Race 10 |  |  |  |  | Venue 2 points per race
NAME | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10 |  | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10 |  | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | total |  | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | total
HOPE | 8 | 8 | 4 | 1 | 7 | 3 | 6 | 5 | 10 | 2 |  | 8 | 2 | 3 | 3 | 9 | 5 | 2 | 7 | 2 | 9
FAITH | 2 | 2 | 8 | 333 | 2 | 4 | 1 | 8 | 5 | 5 |  | 3 | 2 | 4 | 2 | 6 | 10 | 10 | 5 | 5 | 3
ab | 9 | 8 | 7 | 8 | 6 | 4 | 10 | 8 | 10 | 5 |  | 10 | 4 | 5 | 5 | 5 | 3 | 1 | 8 | 9 | 6
cb | 1 | 8 | 10 | 5 | 6 | 2 | 7 | 6 | 9 | 5 |  | 8 | 5 | 8 | 3 | 4 | 7 | 1 | 5 | 2 | 5
db | 4 | 8 | 10 | 10 | 7 | 10 | 10 | 4 | 7 | 6 |  | 7 | 3 | 8 | 9 | 6 | 8 | 2 | 1 | 1 | 2
ek | 7 | 4 | 6 | 5 | 6 | 2 | 6 | 2 | 6 | 7 |  | 7 | 3 | 4 | 6 | 7 | 4 | 8 | 1 | 8 | 6
rk | 8 | 9 | 5 | 10 | 8 | 4 | 1 | 3 | 6 | 3 |  | 2 | 1 | 10 | 2 | 7 | 7 | 10 | 6 | 6 | 7
sk | 5 | 6 | 2 | 5 | 10 | 10 | 9 | 5 | 8 | 8 |  | 2 | 2 | 5 | 2 | 6 | 10 | 7 | 7 | 7 | 7
Spreadsheet: 45383d1244118138-worksheet-referencing-and-position-recognition-mockup_book
Sheet: Foreign Only

Security | Holding | Foreign Currency | Total Value in Foreign Currency | Exchange Rate | Price Per Share in Pence
UNILEVER PLC ORD GBP0.031111 (3) | 1500 | CAD 22.9 | 1313.5*exchange rate*holding | CAD 1.9645 = £1. | 1313.5
F&C FUND MANAGEMENT LTD GLOBAL GROWTH SC 1 ACC  (1) | 4500 | EUR€ 22.9 | 84.79*exchange rate*holding | EUR€ 1.41575 = £1. | 84.79
JUPITER UNIT TRUST MANAGERS INCOME TRUST(2) | 14000 | US$ 22.9 | 349.64*exchange rate*holding | US$ 1.61575 = £1. | 349.64
DR PEPPER SNAPPLE GROUP INC COM STK USD0.01  (2) | 2000 | US$ 22.9 | 1368.952685*exchange rate*holding | US$ 1.61575 = £1. | 1368.95268474216
Spreadsheet: 2f926099-9f7a-4e18-8578-64a11ea4d860
Sheet: Exh 3

 |  |  | Quick | Slow
Retro |  |  |  |  | Prior Col. | % Loss
Adj. | Selected | % Loss |  | PDLD x | Upward | Upward
Periods | PDLD | Emerged | CPDLD | Loss Emg | Cumulative | Cumulative | CPDLD
1
2
3
4
5
6
7+ | 0
Spreadsheet: 687537d1595265843-subtract-from-previous-non-empty-cells-with-blank-cells-and-text-2020-07-20-eldere-ippi591-687490d1595249194-subtract-from-previous-non-empty-cells-with-blank
Sheet: Sheet1

 |  | Week 1 | machine1 | [NAME] | machine 3 |  | machine1 | [NAME] | machine 3
 |  | Week 2 | 58946 | Off | 40919
 |  | Week 3
 |  | Week 4 | 59213 | Off | 41137
 |  | Week 5 | 59424 | off | 41299
 |  | Week 6
 |  | Week 7 | 59685 | Off | 41509
 |  | Week 8
 |  | Week 9
 |  | Week 10 | 60169 | 38717 | 41772
 |  | Week 11
 |  | Week 12 | 60391 | 38984 | 41788
 |  | Week 13 | 60551 | 39100 | 41791
 |  | Week 14
Spreadsheet: 862982d1710526181-how-to-insert-row-and-keep-all-the-data-together-sample
Sheet: Sheet2

 |  |  | Color
 |  |  | Blue
 |  |  | Gray
 |  |  | [NAME]
 |  |  | Green
 |  |  | Pink
Spreadsheet: 204429d1357517816-refreshing-a-protected-worksheet-workflow-draft-20130106-excelforum
Sheet: Commercial Team

LEGAL SERVICES - COMMERCIAL CLAIMS TEAM WORKLOAD & WORKFLOW
Type | Claimant, Insured or Claims/ Underwriting issue | Claim # | Requesting team | Urgency | Date received | SLA due date | Completed or Current | Allowed time | Allowed time - current
Operator 1 |  |  |  |  |  |  | Current
 |  |  |  |  |  |  | Current | Workload
Spreadsheet: 605761d1547251528-populate-name-vacation-date-information-into-calendar-format-in-separate-tab-leave-planner-template-v2
Sheet: February

Legend:
b | = bereavement
o | = other day off |  | o.5 | = half other day off
v | = paid vacation |  | v.5 | = half paid vacation
s | = sick day |  | s.5 | = half sick day
u | = unpaid day off |  | u.5 | = half unpaid day off
x | = present
st | = statutory holiday
 | Summary of Leave Taken This Month
Employee Name | Vacation | Sick | Unpaid | Bereavement | Statutory | Other | 2018-02-01 00:00:00 | 2018-02-02 00:00:00 | 2018-02-03 00:00:00 | 2018-02-04 00:00:00 | 2018-02-05 00:00:00 | 2018-02-06 00:00:00 | 2018-02-07 00:00:00 | 2018-02-08 00:00:00 | 2018-02-09 00:00:00 | 2018-02-10 00:00:00 | 2018-02-11 00:00:00 | 2018-02-12 00:00:00 | 2018-02-13 00:00:00 | 2018-02-14 00:00:00 | 2018-02-15 00:00:00 | 2018-02-16 00:00:00 | 2018-02-17 00:00:00 | 2018-02-18 00:00:00 | 2018-02-19 00:00:00 | 2018-02-20 00:00:00 | 2018-02-21 00:00:00 | 2018-02-22 00:00:00 | 2018-02-23 00:00:00 | 2018-02-24 00:00:00 | 2018-02-25 00:00:00 | 2018-02-26 00:00:00 | 2018-02-27 00:00:00 | 2018-02-28 00:00:00 | # of Days Worked | # of Week Days | Days in Lieu Earned
Spreadsheet: 74304d1274849277-removing-a-legend-entry-on-a-chart-optional-series
Sheet: Sheet1

 | Chart Data |  |  |  |  |  | Working
 | Yes | No | Yes | Dropdowns in yes no cells |  |  |  | Yes | No
 | A |  | C
 | 50 |  | 54 |  |  |  | 50 | 56 | 54
 | 55 |  | 56 |  |  |  | 55 | 23 | 56
 | 60 |  | 36 |  |  |  | 60 | 12 | 36
 | 45 |  | 44 |  |  |  | 45 | 15 | 44
 |  |  |  |  |  |  | I don't want the B to be displayed if the no option is selected
Spreadsheet: 770063d1645799077-offset-with-count-not-working-horizontally-problem
Sheet: scores-averages

 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  |  |  |  |  |  | Average
Team 1
Team 2 | 12 | 11 | 10
Team 3 | 12
Team 4
Team 5
Team 6
Team 7
Team 8
Team 9
Team 10
Team 11
Team 12
Team 13
Team 14
Team 15
Spreadsheet: 841328d1693506986-calculating-shift-schedules-into-hours-allocated-wage-ratio
Sheet: Sheet1

Sales | 25000
Wages
Wage Ratio
EMPLOYEE | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY |  | Wage
Garth |  |  |  |  |  |  |  |  | 20
[NAME] |  |  | 9-6 | 9-6 | 9-6 | 9-6 | 9-6 |  | 17
[NAME] | 9-6 | 9-6 | 9-6 | 9-6 | 9-6 |  |  |  | 15 |  | Shift | Hours
CUSTOMER SERVICE |  |  |  |  |  |  |  |  |  |  | 9-6 | 8
[NAME] |  | 9-6 | 9-6 | 9-6 | 9-6 | 9-6 |  |  | 17 |  | 10-3 | 5
Jessica | 9-6 |  |  |  |  |  | 9-6 |  | 14 |  | 10-2 | 4
PICK/FILL TEAM
[NAME] |  |  |  |  |  |  |  |  | 18
Candy |  | 10-3 | 10-3 | 10-3 | 10-3 | 10-3 |  |  | 15
[NAME] |  | 9-6 | 9-6 | 9-6 | 9-6 | 9-6 |  |  | 15
DEPARTMENTS
[NAME] | 9-6 |  |  |  |  |  | 9-6 |  | 14
[NAME] | 9-6 |  |  |  |  |  | 9-6 |  | 14
[NAME] |  |  |  |  |  |  | TBD |  | 14
Kerry | 9-6 | 9-6 | 9-6 |  |  | 9-6 | 9-6 |  | 14
[NAME] |  |  |  |  |  |  |  |  | 14
Mitchell | 9-6 |  |  | 9-6 | 9-6 | 9-6 | 9-6 |  | 14
[NAME] | 9-6 |  |  |  |  |  | 9-6 |  | 14
Stuart |  | 9-6 | 9-6 | 9-6 | 9-6 | 9-6 |  |  | 14
[NAME] | 9-6 |  |  |  |  |  | 9-6 |  | 14
Hours
Spreadsheet: 750406d1633440199-conditional-formatting-with-color-coding-is-not-working-color-matching-for-numbers
Sheet: Color Matching

Working Scenario
Set1
78 | 74 | 97 | 37 | 74 | 81
43 | 31 | 99 | 79 | 73 | 09 |  |  | 99 | 9+3=12 | 3 | 38
06 | 99 | 33 | 27 | 63 | 09 |  |  | 27 | 9+8=17 | 8
09 | 94 | 84 | 91 | 85 | 62
39 | 19 | 07 | 01 | 60 | 49
62 | 02 | 68 | 06 | 07 | 06
35 | 60 | 98 | 74 | 23 | 62
62 | 87 | 04 | 34 | 58 | 90
66 | 32 | 86 | 21 | 14 | 82 |  | 66 | 6+6=12 | 6 | 62
28 | 34 | 34 | 32 | 17 | 09 |  | 28 | 6+2=08 | 2
Set2
89 | 00 | 66 | 08 | 22 | 29
66 | 25 | 66 | 26 | 14 | 33 |  |  | 66 | 6+3=09 | 3 | 38
80 | 07 | 54 | 94 | 60 | 18 |  |  | 94 | 6+8=14 | 8
83 | 15 | 07 | 24 | 45 | 23
59 | 64 | 15 | 91 | 92 | 18
35 | 14 | 27 | 92 | 76 | 64
30 | 85 | 10 | 73 | 55 | 87
82 | 58 | 18 | 57 | 51 | 94
80 | 99 | 76 | 22 | 18 | 30 |  | 80 | 8+6=14 | 6 | 62
42 |  |  |  |  |  |  | 42 | 0+2=02 | 2
 | Working Formula
 | "=MOD((IF(LEFT(A16,1)>=LEFT(A3,1),LEFT(A16,1)-LEFT(A3,1),LEFT(A16,1)+10-LEFT(A3,1))&(IF(RIGHT(A16,1)>=RIGHT(A3,1),RIGHT(A16,1)-RIGHT(A3,1),RIGHT(A16,1)+10-RIGHT(A3,1))))),100)=99"
Non-Working Scenario
Set 1
78 | 74 | 97 | 37 | 74 | 81
43 | 31 | 99 | 79 | 73 | 09
06 | 99 | 33 | 27 | 63 | 09
09 | 94 | 84 | 91 | 85 | 62 |  |  |  |  | 94 | 4+6=10 | 6
39 | 19 | 07 | 01 | 60 | 49 |  | eg 2
62 | 02 | 68 | 06 | 07 | 06 |  |  |  |  | 02 | 9+3=12 | 3
35 | 60 | 98 | 74 | 23 | 62 |  | 74 | 4+4=08 | 4
62 | 87 | 04 | 34 | 58 | 90 | eg 1
66 | 32 | 86 | 21 | 14 | 82 |  | 86 | 7+9=16 | 9
28 | 34 | 34 | 32 | 17 | 09
Set 2
89 | 00 | 66 | 08 | 22 | 29
66 | 25 | 66 | 26 | 14 | 33
80 | 07 | 54 | 94 | 60 | 18
83 | 15 | 07 | 24 | 45 | 23 |  |  |  |  | 15 | 5+6=11 | 6
59 | 64 | 15 | 91 | 92 | 18 |  | eg 2
35 | 14 | 27 | 92 | 76 | 64 |  |  |  |  | 14 | 1+3=04 | 3
30 | 85 | 10 | 73 | 55 | 87 |  | 73 | 3+4=07 | 4
82 | 58 | 18 | 57 | 51 | 94 | eg 1
80 | 99 | 76 | 22 | 18 | 30 |  | 76 | 7+9=16 | 9
42
 |  | Issue
 |  | > The similar formula is working for Scenario 1 and it is not working for Scenario 2
 |  | > The formula is just comparing the cells across the sets and not within the set
 |  | Requirement:
 |  | > The formuala or script should identify the pair of numbers with same output within the set and outside the set as in above examples
 |  | > The currently known formula is as below
 |  |  |  | "=MOD((IF(LEFT(A49,1)>=RIGHT(A36,1),LEFT(A49,1)-RIGHT(A36,1),LEFT(A49,1)+10[NAME])))))
 |  | > The matching cells should be highlighted with same color
Spreadsheet: 864149d1711451972-sorting-names-by-surname-alphabetically-without-using-two-columns-marvo-on-a-mission-aligw
Sheet: Sheet2

ALL-TIME PRIZE WINNERS |  |  |  |  |  |  |  |  | TOTAL PAID OUT =
POST | PLAYER | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | TOTAL
1st | MARVESLEY. [NAME] | 75 | 65 | 145 | 110 | 20 | 145 | 70 | 90 | 130 | 10 | 65 | 120 | 50
2nd | MITCHELL. [NAME] | 60 | 65 | 45 | 130 | 125 | 135 | 80 | 135 | 65 | 30 | 105 | 41 | 46
3rd | MUNTING. [NAME] | 50 | 20 | 15 | 70 | 100 | 45 | 200 | 50 | 50 | 90 | 100 | 82 | 100
4th | GROUT. [NAME] | 55 | 35 | 45 | 55 | 125 | 50 | 110 | 65 | 60 | 110 | 110 | 74 | 30
5th | SMITH. [NAME] | 10 | 45 | 50 | 30 | 85 | 210 | 65 | 115 | 85 | 10 | 30 | 58 | 106
6th | SMITH. [NAME] |  | 35 | 30 | 15 | 80 | 75 | 115 | 55 | 60 | 65 | 30 | 150 | 32
7th | PYM. [NAME] | 50 | 30 |  | 25 | 200 | 45 | 80 | 30 | 40 | 20 | 65 | 109 | 35
8th | [NAME]. [NAME] | 140 | 135 | 55 | 120 | 180 | 35 | 30
ALL-TIME PRIZE WINNERS |  |  |  |  |  |  |  |  | TOTAL PAID OUT =
POST | PLAYER | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | TOTAL | Helper
1st | [NAME] | 75 | 65 | 145 | 110 | 20 | 145 | 70 | 90 | 130 | 10 | 65 | 120 | 50 |  |  | 3
2nd | [NAME] | 60 | 65 | 45 | 130 | 125 | 135 | 80 | 135 | 65 | 30 | 105 | 41 | 46 |  |  | 4
3rd | [NAME] | 50 | 20 | 15 | 70 | 100 | 45 | 200 | 50 | 50 | 90 | 100 | 82 | 100 |  |  | 5
4th | [NAME] | 55 | 35 | 45 | 55 | 125 | 50 | 110 | 65 | 60 | 110 | 110 | 74 | 30 |  |  | 2
5th | [NAME] | 10 | 45 | 50 | 30 | 85 | 210 | 65 | 115 | 85 | 10 | 30 | 58 | 106 |  |  | 7
6th | [NAME] |  | 35 | 30 | 15 | 80 | 75 | 115 | 55 | 60 | 65 | 30 | 150 | 32 |  |  | 8
7th | [NAME] | 50 | 30 |  | 25 | 200 | 45 | 80 | 30 | 40 | 20 | 65 | 109 | 35 |  |  | 6
8th | [NAME] | 140 | 135 | 55 | 120 | 180 | 35 | 30 |  |  |  |  |  |  |  |  | 1
Spreadsheet: 37fdf648-dacf-4fab-a5ac-07c2a733e3e8
Sheet: Global Markets Accept. Criteria

Acceptance Criteria for the
Global Markets Program for Primary Production Basic or Intermediate Level Assessment Field Operations and Harvesting
In addition to the USDA acceptance criteria, growers utilizing this audit to meet Global Markets Program for Primary Production Basic or Intermediate Level Assessment requirements must meet the following additional criteria, which are listed as major elements within the  Global Markets Capacity Building Program for Primary Production.
Audit Element(s) | Criteria
1.3 | Documentation and Recordkeeping (includes all 3 sub-questions).
1.4 | [NAME].
2.1.1 | Field History and Assessment (pre-planting).
2.2.1 | Hygienic Procedure for All Activities Which Take Place on the Farm.
2.2.2 | Hygienic Practices are Effectively Implemented.
2.2.4 & 2.2.5 | Access to Clean Toilets and Hand Washing Facilities.
2.3.1 | Agricultural Chemicals are Registered.
2.3.2 | If Exporting - Agriculture Chemicals Registered or Permitted for use in the Destination Country
2.3.4 | Water Used for Plant Protection Products does not Present a Food Safety Risk.
2.3.5 | Agricultural Chemical Disposal.
2.4.3.1 | No Untreated Sewage Water Used for Irrigation.
2.4.3.1, 2.5.1, 2.6.1, 2.7.2 | Where Food Safety Hazards have been Identified - Records to Demonstrate that They are Effectively Managed (water, animals, soil amendments, equipment).
2.5 | Animal Control (includes all 3 sub-questions).
2.6 | Soil Amendments (includes 2 sub-questions).
2.7.2 | Documented Cleaning and Sanitation Procedures.
3.2.2 | Water Used on Harvested Crops is Potable.
3.3 | Containers, Bins & Packing Material (includes all 4 sub-questions).
3.5.3 | Storage of Harvested Product.
5.1.1 & 5.1.2 | Awareness and Compliance to Customer Specific Food Safety Specifications.
5.1.7 | Food Safety Incidents Recorded and Assessed.
5.3.1 | No Untreated Human Sewage is Used.
5.5.2 | Operation Keeps List of Agricultural Chemicals Used on the Crops being Grown.
5.5.6 | Operations Demonstrate Knowledge of Calculating and Preparing Application Mix.
Spreadsheet: 49646d1248983907-table-lookup-inversetablelookup-2-
Sheet: Sheet1

Amps | 6 | <-- Input
Distance | 4 | <-- Input
Gauge | E | <-- Calc |  | E | formula without helper column, seems to give identical results
 | J | I | H | G | F | E | D | C | B | A
1 | 1.9 | 1.8 | 1.7 | 1.6 | 1.5 | 1.4 | 1.3 | 1.2 | 1.1 | 1
2 | 1.9 | 1.8 | 1.7 | 1.6 | 1.5 | 1.4 | 1.3 | 1.2 | 1.1 | 1
3 | 2.85 | 2.7 | 2.55 | 2.4 | 2.25 | 2.1 | 1.95 | 1.8 | 1.65 | 1.5
4 | 3.8 | 3.6 | 3.4 | 3.2 | 3 | 2.8 | 2.6 | 2.4 | 2.2 | 2
5 | 4.75 | 4.5 | 4.25 | 4 | 3.75 | 3.5 | 3.25 | 3 | 2.75 | 2.5
6 | 5.699999999999999 | 5.4 | 5.1 | 4.800000000000001 | 4.5 | 4.199999999999999 | 3.9 | 3.6 | 3.3 | 3
7 | 6.649999999999999 | 6.3 | 5.95 | 5.600000000000001 | 5.25 | 4.899999999999999 | 4.55 | 4.2 | 3.850000000000001 | 3.5
8 | 7.6 | 7.2 | 6.8 | 6.4 | 6 | 5.6 | 5.2 | 4.8 | 4.4 | 4
9 | 8.549999999999999 | 8.1 | 7.649999999999999 | 7.2 | 6.75 | 6.3 | 5.850000000000001 | 5.399999999999999 | 4.95 | 4.5
10 | 9.5 | 9 | 8.5 | 8 | 7.5 | 7 | 6.5 | 6 | 5.5 | 5
11 | 10.45 | 9.9 | 9.35 | 8.8 | 8.25 | 7.699999999999999 | 7.15 | 6.6 | 6.050000000000001 | 5.5
12 | 11.4 | 10.8 | 10.2 | 9.600000000000001 | 9 | 8.399999999999999 | 7.800000000000001 | 7.199999999999999 | 6.600000000000001 | 6
13 | 12.35 | 11.7 | 11.05 | 10.4 | 9.75 | 9.1 | 8.450000000000001 | 7.8 | 7.15 | 6.5
14 | 13.3 | 12.6 | 11.9 | 11.2 | 10.5 | 9.799999999999999 | 9.1 | 8.4 | 7.700000000000001 | 7
15 | 14.25 | 13.5 | 12.75 | 12 | 11.25 | 10.5 | 9.75 | 9 | 8.25 | 7.5
16 | 15.2 | 14.4 | 13.6 | 12.8 | 12 | 11.2 | 10.4 | 9.6 | 8.8 | 8
17 | 16.15 | 15.3 | 14.45 | 13.6 | 12.75 | 11.9 | 11.05 | 10.2 | 9.350000000000001 | 8.5
18 | 17.1 | 16.2 | 15.3 | 14.4 | 13.5 | 12.6 | 11.7 | 10.8 | 9.9 | 9
19 | 18.05 | 17.1 | 16.15 | 15.2 | 14.25 | 13.3 | 12.35 | 11.4 | 10.45 | 9.5
20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10
21 | 19.95 | 18.9 | 17.85 | 16.8 | 15.75 | 14.7 | 13.65 | 12.6 | 11.55 | 10.5
22 | 20.9 | 19.8 | 18.7 | 17.6 | 16.5 | 15.4 | 14.3 | 13.2 | 12.1 | 11
23 | 21.85 | 20.7 | 19.55 | 18.4 | 17.25 | 16.1 | 14.95 | 13.8 | 12.65 | 11.5
24 | 22.8 | 21.6 | 20.4 | 19.2 | 18 | 16.8 | 15.6 | 14.4 | 13.2 | 12
25 | 23.75 | 22.5 | 21.25 | 20 | 18.75 | 17.5 | 16.25 | 15 | 13.75 | 12.5
6 | 5.699999999999999 | 5.4 | 5.1 | 4.800000000000001 | 4.5 | 4.199999999999999 | 3.9 | 3.6 | 3.3 | 3
Spreadsheet: 267536d1380105625-help-with-lookup-formulae-please-test-2-
Sheet: Expert

Name | Last Name | Club | Class | No
 |  |  |  | 4 |  | Here you can enter the numbers
 |  |  |  | 6
 |  |  |  | 5
 |  |  |  | ^^^^^^
 |  |  |  | IF YOU ENTER A VALID RIDER NUMBER THE DATA SPRINGS FORWARD IN THE BOXES
 |  |  |  | ^^^^^^ | INSERT ONLY "EXPERT'' NUMBERS IN ORDER FROM THE RIDERS LIST WORKSHEET
Spreadsheet: 820616d1678199966-search-box-with-multiple-tables-sample17
Sheet: Sheet1

 |  | Search | Entity 17
 |  | Entity | Username | Password
 |  | Table 1 |  |  |  | Table 2 |  |  |  | Table 3
 |  | Entity | Username | Password |  | Entity | Username | Password |  | Entity | Username | Password
 |  | Entity 1 | rick1 | s7a8 |  | Entity 4 | bravo81 | a782j |  | Entity 2 | char009 | 81ksa
 |  | Entity 5 | rick711 | smmx8 |  | Entity 9 | bravo220 | dd7g |  | Entity 6 | char81 | 2nn82
 |  | Entity 12 | rick45 | 27sh8 |  | Entity 11 | [NAME] | s7b2 |  | Entity 7 | char582 | a89k
 |  | Entity 20 | rick900 | 9al2m |  | Entity 19 | bravo28 | s6vha |  | Entity 17 | [NAME] | 27gd6
 |  | Entity 13 | rick822 | s87g4 |  | Entity 10 | bravo56 | 82nxh |  | Entity 8 | char371 | 28janh
Spreadsheet: 57925d1258138134-compile-staggered-data-into-a-single-row-compile-results
Sheet: Sheet5

image | itemNumber | itemNumberQualifier | descriptionValue | itemDescriptionQualifier | itemDescriptionClassification | unitOfMeasure | value | packageUnitDescription | unitOfMeasure2 | value3 | unitOfMeasure4 | value5 | weightQualifier | unitOfMeasure6 | [NAME] | unitOfMeasure8 | value9 | unitOfMeasure10 | [NAME] | unitOfMeasure12 | value13 | itemUnitDescription | unitOfMeasure14 | value15 | unitOfMeasure16 | value17 | unitOfMeasure18 | value19
B492-31-36-39-57-54-96-93-SD_BIG.jpg | B492-93 | SellerAssigned | NIGHTSTAND LT BRN FNSH |  |  | Each | 1 | NIGHTSTAND LT BRN FNSH | CubicFeet | 9.41 | Pounds | 62.7 | GrossWeight | Inches | 21 | Inches | 27.25 | Inches | 27.75 | Each | 1 | NIGHTSTAND LT BRN FNSH | Inches | 18 | Inches | 29 | Inches | 26
Spreadsheet: 702522d1604401016-shift-differentials-with-overtime-payroll-extract
Sheet: Payroll Extract

 |  |  |  |  | Regular Hrs Within Shifts |  |  | Overtime Hrs Within Shifts
Full Name | Date | Start - Time | End - Time | Type | 12am-8am | 8am-4pm | 4pm-12am | 12am-8am | 8am-4pm | 4pm-12am
Employee 1 | 2020-10-13 00:00:00 | 08:00:00 | 16:00:00 | Regular Hours
Employee 1 | 2020-10-14 00:00:00 | 08:00:00 | 14:00:00 | Regular Hours
Employee 1 | 2020-10-15 00:00:00 | 00:00:00 | 08:00:00 | Overtime
Employee 1 | 2020-10-15 00:00:00 | 08:00:00 | 14:00:00 | Regular Hours
Employee 1 | 2020-10-16 00:00:00 | 08:00:00 | 16:00:00 | Regular Hours
Employee 1 | 2020-10-15 00:00:00 | 18:00:00 | 20:30:00 | Overtime
Employee 1 | 2020-10-16 00:00:00 | 19:00:00 | 21:00:00 | Overtime
Employee 2 | 2020-10-11 00:00:00 | 08:00:00 | 11:00:00 | Overtime
Employee 2 | 2020-10-11 00:00:00 | 16:00:00 | 00:00:00 | Regular Hours
Employee 2 | 2020-10-12 00:00:00 | 16:00:00 | 00:00:00 | Regular Hours
Employee 2 | 2020-10-13 00:00:00 | 16:00:00 | 00:00:00 | Regular Hours
Employee 2 | 2020-10-14 00:00:00 | 16:00:00 | 00:00:00 | Regular Hours
Employee 2 | 2020-10-17 00:00:00 | 16:00:00 | 00:00:00 | Regular Hours
Employee 3 | 2020-10-11 00:00:00 | 08:00:00 | 16:00:00 | Regular Hours
Employee 3 | 2020-10-12 00:00:00 | 08:00:00 | 16:00:00 | Regular Hours
Employee 3 | 2020-10-13 00:00:00 | 00:00:00 | 08:00:00 | Regular Hours
Employee 3 | 2020-10-14 00:00:00 | 00:00:00 | 08:00:00 | Regular Hours
Employee 3 | 2020-10-14 00:00:00 | 16:00:00 | 00:00:00 | Overtime
Employee 3 | 2020-10-16 00:00:00 | 08:00:00 | 16:00:00 | Overtime
Employee 3 | 2020-10-17 00:00:00 | 08:00:00 | 16:00:00 | Regular Hours
Employee 3 | 2020-10-17 00:00:00 | 16:00:00 | 00:00:00 | Overtime
Employee 4 | 2020-10-13 00:00:00 | 08:00:00 | 16:00:00 | Regular Hours
Employee 4 | 2020-10-14 00:00:00 | 00:00:00 | 08:00:00 | Overtime
Employee 4 | 2020-10-14 00:00:00 | 08:00:00 | 16:00:00 | Regular Hours
Employee 4 | 2020-10-15 00:00:00 | 08:00:00 | 16:00:00 | Regular Hours
Employee 4 | 2020-10-16 00:00:00 | 08:00:00 | 16:00:00 | Regular Hours
Employee 4 | 2020-10-16 00:00:00 | 16:00:00 | 00:00:00 | Overtime
Spreadsheet: 101608d1299697876-excel-2007-formula-to-organize-data-example2
Sheet: FINISH

FINISH:
ABC Co. | DEF Co. | Item |  | ABC |  | DEF
Sequence |  |  |  | cost | profit | cost | profit
 |  | apple
 |  | pear
 |  | orange
 |  | banana
 |  | grape
 |  | blueberry