tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 723552d1615777963-counting-if-results-across-rows-on-another-sheet-sample
Sheet: Info

 |  |  | Days in Month | Days Recorded
Metric | Amount |  | Jan Avg Daily Total Grocrey Sales | Jul Avg Daily Total Grocrey Sales |  | Employee Name | Total Shifts Worked | Times Drops > than 200 | % Safe drops were greater than 200
Store Close Credits Grand Total |  |  | 2377.579677419355 |  |  | Mark
Store Close Total Gas Sales |  |  |  |  |  | Becky
Store Close Total Non Fuel Sales |  |  | Feb Average Daily Total Grocrey Sales | Aug Avg Daily Total Grocrey Sales |  | [NAME]
Store Close Credits Crind Total |  |  |  |  |  | Smitty
Store Close Total Grocery Sales |  |  |  |  |  | Sonya
Safe Drop Totals |  |  | Mar Avg Daily Total Grocrey Sales | Sep Avg Daily Total Grocrey Sales |  | Melinda
Store Close Credits Total |  |  |  |  |  | Melinda & Becky
Store Close Lottery Sales Total |  |  |  |  |  | Mark & Ricky
Store Close Debits Grand Total |  |  | Apr Avg Daily Total Grocrey Sales | Oct Avg Daily Total Grocrey Sales |  | Becky & Ed
Store Close Debits Total |  |  |  |  |  | JoJo
Store Close Lottery Wins |  |  |  |  |  | Ricky
Store Close Debits Crind Total |  |  | May Avg Daily Total Grocrey Sales | Nov Avg Daily Total Grocrey Sales |  | Melinda & Jojo
QuickPick Total House Charges
QuickPick Total Employee Payouts
Store Close Total Daily UnderOver |  |  | Jun Avg Daily Total Grocrey Sales | Dec Avg Daily Total Grocrey Sales
QuickPick Total PayIns
 |  |  |  |  |  | Criteria | # Days | Percentage Of Month
 |  |  |  |  |  | Days with sales Below 1500
 |  |  |  |  |  | Days with sales from 1500-2000
 |  |  |  |  |  | Days with sales from 2000-2500
 |  |  |  |  |  | Days with sales from 2500-3000
 |  |  |  |  |  | Days with sales from 3000-3100
 |  |  |  |  |  | Days with sales from 3100-3200
 |  |  |  |  |  | Days with sales from 3200-3300
 |  |  |  |  |  | Days with sales from 3300-3400
 |  |  |  |  |  | Days with sales from 3400-3500
 |  |  |  |  |  | Days with sales Above 3500
 |  |  | 02/01/2021 | 2189
 |  |  | 02/02/2021 | 2270.33
 |  |  | 02/04/2021 | 2454.04
 |  |  | 02/05/2021 | 2658.28
 |  |  | 02/06/2021 | 2445.82
 |  |  | 02/07/2021 | 2515.29
 |  |  | 02/08/2021 | 2134.42
 |  |  | 02/09/2021 | 2527.6
 |  |  | 02/10/2021 | 2164
 |  |  | 02/11/2021 | 2515.55
 |  |  | 02/12/2021 | 2473.52
 |  |  | 02/13/2021 | 2969.39
 |  |  | 02/14/2021 | 2128.97
 |  |  | 02/15/2021 | 2482.48
 |  |  | 02/16/2021 | 628.63
 |  |  | 02/17/2021 | 2334.92
 |  |  | 02/18/2021 | 2142.42
 |  |  | 02/19/2021 | 2634.24
 |  |  | 02/20/2021 | 3252.06
 |  |  | 02/21/2021 | 2585.33
 |  |  | 02/22/2021 | 2588.81
 |  |  | 02/23/2021 | 2601.59
 |  |  | 02/24/2021 | 2518.95
 |  |  | 02/25/2021 | 2318.57
 |  |  | 02/26/2021 | 2489.61
 |  |  | 02/27/2021 | 2697.88
 |  |  | 02/28/2021 | 2517.44
Spreadsheet: 05afee08-8145-43d8-8fb8-6c63292ea716
Sheet: original rfp budget request

Enter Name of School Here!
FY15 Oklahoma Lottery Grant
Original Budget Request
Item # | Description of Item (Include part number if available) | Quantity | Cost per Item | Net Cost per Item
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
 | TOTAL  REQUEST:
Spreadsheet: 809294d1671012247-find-and-show-the-last-value-from-a-row-examplefile-2
Sheet: Sheet1

testheader 1 | testheader 2 | testheader 3 | testheader 4 | testheader 5 | testheader 6 | testheader 7 | testheader 8 | testheader 9 | testheader 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Here find last info | Past header info here
Info1 | Info2 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Testheader 4
Info1 | Info2 | [NAME] | [NAME] | Info 5 | Info 6 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Testheader 7
Info1 | Info2 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Testheader 4
Info1 | Info2 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Testheader 4
Info1 | Info2 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Testheader 4
Info1 | Info2 | [NAME] | [NAME] | Info 5 | Info 6 | [NAME] | [NAME] 8 | [NAME] 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Testheader 9
Info1 | Info2 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Testheader 4
Info1 | Info2 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Testheader 4
Info1 | Info2 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Testheader 4
Info1 | Info2 | [NAME] | [NAME] | Info 5 | Info 6 | [NAME] | [NAME] 8 | [NAME] 9 | [NAME] 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Testheader 10
Spreadsheet: 212072d1360023244-how-to-auto-populate-one-cell-based-on-the-selections-of-two-drop-downs-try5-oeldere4-
Sheet: Trailers & Tents Combo

[NAME] | [NAME] | combined name | Price
Seeker | ST09STD |  | 4395
Seeker | ST09RSL |  | 4695
Seeker | ST09KSL |  | 4695
Seeker | ST09KSS |  | 4945
Seeker | ST12KSL |  | 4995
Seeker | ST09KSS |  | 5295
Sandpiper | ST09STD |  | 6595
Sandpiper | ST09RSL |  | 6895
Sandpiper | ST09KSL |  | 6895
Sandpiper | ST09KSS |  | 7145
Sandpiper | ST12KSL |  | 7195
Sandpiper | ST12KSS |  | 7495
Wanderer | ST09STD |  | 8195
Wanderer | ST09RSL |  | 8495
Wanderer | ST09KSL |  | 8495
Wanderer | ST09KSS |  | 8745
Wanderer | ST12KSL |  | 8795
Wanderer | ST12KSS |  | 9095
[NAME] | ST09STD |  | 7995
[NAME] | ST09RSL |  | 8295
[NAME] | ST09KSL |  | 8295
[NAME] | ST09KSS |  | 8545
[NAME] | ST12KSL |  | 8595
[NAME] | ST12KSS |  | 8895
All Terrain Independent Heavy Duty Coil Suspension | ST12KSS |  | 11990
All Terrain Heavy Duty Suspension | ST12KSS |  | 10750
Spreadsheet: 624744d1558048733-help-calendar-correction-employee-absence-schedule-current
Sheet: January

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | January | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee Name | 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 | Vacation Days Available | Total Vacation  Days Taken | Total Days Picked up | Total Sick Days
 |  |  |  | V | V | V | V |  |  |  |  |  |  | V |  |  | s | s |  | p |  | s | s | p | p | p |  |  | p
 |  |  |  |  |  | S | S |  |  |  |  | P |  |  |  |  |  |  |  |  | S |  |  | v |  | V | V | V
 |  |  |  | P | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s |  |  |  | s | s | s | s | s | S
 |  |  |  |  |  |  |  | P |  |  |  |  |  |  |  |  |  |  |  | V | V | V
 |  | v | v | v |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | v | V
 |  |  |  |  |  | v
Spreadsheet: 05468dfc-19fc-4ad7-a2e0-fac0b8e7c049
Sheet: Raw data - LW Up

VARIABLE : All Sky Surface Upward Longwave Flux (W m-2)
FILENAME : srb_rel3.0_longwave_daily_lw_sfc_up.nc
FILEPATH : /usr/local/fer_data/data/SRB_DAILY/
BAD FLAG :  -9.900001
[NAME]   : 92 points (TIME)
LONGITUDE: 90.5W(-90.5)
LATITUDE : 34.5N
coordinates | 90.5W
01-JUN-2007 00 | 448.3
02-JUN-2007 00 | 450.9
03-JUN-2007 00 | 460.8
04-JUN-2007 00 | 452
05-JUN-2007 00 | 467.4
06-JUN-2007 00 | 466.1
07-JUN-2007 00 | 467.2
08-JUN-2007 00 | 456.9
09-JUN-2007 00 | 455.3
10-JUN-2007 00 | 453.3
11-JUN-2007 00 | 460
12-JUN-2007 00 | 477.4
13-JUN-2007 00 | 475.3
14-JUN-2007 00 | 465.3
15-JUN-2007 00 | 457.9
16-JUN-2007 00 | 458.5
17-JUN-2007 00 | 456.8
18-JUN-2007 00 | 458.6
19-JUN-2007 00 | 452.2
20-JUN-2007 00 | 464.3
21-JUN-2007 00 | 445.5
22-JUN-2007 00 | 459.9
23-JUN-2007 00 | 470.3
24-JUN-2007 00 | 461.7
25-JUN-2007 00 | 454.9
26-JUN-2007 00 | 459.1
27-JUN-2007 00 | 458.7
28-JUN-2007 00 | 460.3
29-JUN-2007 00 | 462.1
30-JUN-2007 00 | 462.7
01-JUL-2007 00 | 451
02-JUL-2007 00 | 457.4
03-JUL-2007 00 | 458.4
04-JUL-2007 00 | 455.2
05-JUL-2007 00 | 457
06-JUL-2007 00 | 455
07-JUL-2007 00 | 444.6
08-JUL-2007 00 | 473.9
09-JUL-2007 00 | 457.5
10-JUL-2007 00 | 454.2
11-JUL-2007 00 | 450.3
12-JUL-2007 00 | 450.9
13-JUL-2007 00 | 448.9
14-JUL-2007 00 | 454.4
15-JUL-2007 00 | 450.8
16-JUL-2007 00 | 460.5
17-JUL-2007 00 | 452.1
18-JUL-2007 00 | 456
19-JUL-2007 00 | 461.9
20-JUL-2007 00 | 454.5
21-JUL-2007 00 | 454.7
22-JUL-2007 00 | 454.8
23-JUL-2007 00 | 447.6
24-JUL-2007 00 | 449.5
25-JUL-2007 00 | 460.9
26-JUL-2007 00 | 455.7
27-JUL-2007 00 | 462.3
28-JUL-2007 00 | 455.9
29-JUL-2007 00 | 463.2
30-JUL-2007 00 | 455.1
31-JUL-2007 00 | 468.4
01-AUG-2007 00 | 467
02-AUG-2007 00 | 477.5
03-AUG-2007 00 | 470.8
04-AUG-2007 00 | 472.1
05-AUG-2007 00 | 472.2
06-AUG-2007 00 | 473.2
07-AUG-2007 00 | 495.8
08-AUG-2007 00 | 487
09-AUG-2007 00 | 505.9
10-AUG-2007 00 | 506.9
11-AUG-2007 00 | 491.9
12-AUG-2007 00 | 498.9
13-AUG-2007 00 | 515.9
14-AUG-2007 00 | 506.4
15-AUG-2007 00 | 503.8
16-AUG-2007 00 | 473.4
17-AUG-2007 00 | 507.4
18-AUG-2007 00 | 484.2
19-AUG-2007 00 | 475.7
20-AUG-2007 00 | 466.4
21-AUG-2007 00 | 477.3
22-AUG-2007 00 | 493.2
23-AUG-2007 00 | 491.3
24-AUG-2007 00 | 502.5
25-AUG-2007 00 | 496.4
26-AUG-2007 00 | 471.8
27-AUG-2007 00 | 489.8
28-AUG-2007 00 | 471.2
29-AUG-2007 00 | 451.9
30-AUG-2007 00 | 465.6
31-AUG-2007 00 | 473.3
Spreadsheet: 5bdcfb3b-c645-4f2b-b6bc-7f18b5d7143c
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
44428051 | 2014-12-13 19:37:00 | AXIS | 1 | 6 | 1 | 260791 | SjoerdW | 12506 | eastern | 1941-07-21 | 1941-07-31 | [NAME] | Percée russe
44428261 | 2014-12-13 19:54:37 | ALLIES | 0 | 3 | 6 | 260791 | SjoerdW | 12506 | eastern | 1941-07-21 | 1941-07-31 | [NAME] | Percée russe
44437612 | 2014-12-14 11:22:48 | AXIS | 1 | 10 | 5 | 381238 | generale1964 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44437836 | 2014-12-14 11:57:42 | ALLIES | 0 | 4 | 10 | 381238 | generale1964 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44458496 | 2014-12-15 20:27:36 | AXIS | 1 | 6 | 4 | 1458791 | torombolo | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
44458722 | 2014-12-15 20:45:28 | ALLIES | 0 | 3 | 6 | 1458791 | torombolo | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
44472975 | 2014-12-16 20:53:29 | AXIS | 0 | 2 | 6 | 946197 | Groka | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
44473164 | 2014-12-16 21:05:12 | AXIS | 1 | 6 | 5 | 1228328 | Woodrow Call | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
44473336 | 2014-12-16 21:18:30 | ALLIES | 1 | 6 | 5 | 1228328 | Woodrow Call | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
44473573 | 2014-12-16 21:37:59 | AXIS | 0 | 4 | 6 | 1228328 | Woodrow Call | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
44473874 | 2014-12-16 21:55:17 | ALLIES | 1 | 6 | 2 | 1228328 | Woodrow Call | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
Spreadsheet: 863884d1711289768-count-no-of-persons-with-multiple-conditions-count-with-multiple-conditions-ans
Sheet: Sheet1

S. No. | SAP | NAME | Dept. | 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
 |  | ABC | WELDING | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A
2 | 119 | CD | CLEARING | B | B | B | B | B | B | B | B | A | A | A | A | A | A | A | A | A | A | A | A | C | C | C | C | C | C | C | C | C | C | C
3 | 120 | AAA | STORES | G | G | G | G | G | G | G | A | A | A | A | A | A | A
4 | 121 | CVV | COLDFORM | C | C | C | C | C | C | A | A | A | A | A | A | A
5 | 122 | CCC | PAINTING
6 | 127 | DDD | SHEAR
7 | 128 | EEE | FABRICATION
8 | 129 | FFF | BEAMWELDING
9 | 133 | GGG | COLDFORM
10 | 134 | HHH | WAREHOUSE
11 | 135 | III | DETAILS
12 | 140 | JJJ | DETAILS
13 | 141 | KKK | WELDING
14 | 142 | LLL | BEAMWELDING
15 | 143 | MMM | FABRICATION
16 | 144 | NNN | SHEETING
17 | 145 | OOO | WELDING | B | B | B | B | B | B | B | B | A | A | A | A | A | A | A | A | A | A | A | A | C | C | C | C | C | C | C | C | C | C | C
Spreadsheet: 829533d1684300901-return-data-from-one-table-to-another-table-based-on-dates-entered-and-summing-duplicates-book1-146-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  | Table2 Data Manually Entered
 |  |  |  |  |  |  |  | Name | Date | Week # | Year | Data1 | Data2 | Data3
Date: | 2023-01-10 00:00:00 | <-- Enter Date  (Use 1/1/23 or 1/10/23 for this example) |  |  |  |  |  | [NAME] | 2023-01-01 00:00:00 |  |  | 10 | 20 | 30
Week #: |  |  |  |  |  |  |  | [NAME] | 2023-01-05 00:00:00 |  |  | 5 | 25 | 20
Year: | 2023 | <-- Or enter Year (Enter 2023 and Totals are not working) |  |  |  |  |  | [NAME] | 2023-01-10 00:00:00 |  |  | 5 | 15 | 35
 |  |  |  |  |  |  |  | [NAME] | 2023-01-12 00:00:00 |  |  | 15 | 20 | 25
 |  |  |  |  |  |  |  | [NAME] | 2023-01-12 00:00:00 |  |  | 10 | 20 | 35
Table1 to Return Data from Table2 Based on "Date" Entered in B2
Name | Data1 | Data2 | Data3 |  | Name | Data1 | Data2 | Data3
 |  |  |  |  |  | 10 | 20 | 30
 |  |  |  |  | [NAME] | 5 | 25 | 20
 |  |  |  |  | [NAME] | 5 | 15 | 35
 |  |  |  |  | [NAME] | 15 | 20 | 25
 |  |  |  |  | [NAME] | 10 | 20 | 35
Spreadsheet: 871177d1717584253-football-prediction-formula-euro24-goal-prediction
Sheet: Sheet1

Correct Score |  |  |  |  |  | Paarticipant 1 |  |  | Participant 2 |  |  | Participant 4 |  |  | Participant 5 |  |  | Participant 6 |  |  | Participant 7 |  |  | Participant 8 |  |  | Participant 9 |  |  | Participant 10 |  |  | Participant 11 |  |  | Participant 12
 | Home team | Home score | Away score | Away team |  | Home | Away | Points | Home | Away | Points | Home | Away | Points | Home | Away | Points | Home | Away | Points | Home | Away | Points | Home | Away | Points | Home | Away | Points | Home | Away | Points | Home | Away | Points | Home | Away | Points
14.jun 22.00 | Germany | 3 | 2 | Scotland |  | 3 | 2
15.jun 16.00 | Hungary | 2 | 1 | Switserland
15.jun 19:00 | Spain |  |  | Croatia
15.jun 22.00 | Italy |  |  | Albania
16.jun 16.00 | Poland |  |  | Netherlands
16.jun 19.00 | Slovenia |  |  | Denmark
Spreadsheet: 806848d1669633840-trying-to-modify-a-complex-formula-that-outputs-a-spilled-result-in-multiple-columns-dpd-gk-2-
Sheet: Result

Drug | Diphenhydramine | AIS | 1 | Valid rows |  |  |  |  | Oral
 |  |  |  |  |  |  |  |  | Intramuscular
 |  |  |  |  |  |  |  |  | Intravenous
Generic Name | Strength | Dosage Form | Route | DIN/PDIN/NPN |  |  |  |  | Topical
 |  |  |  | Marketed | Approved
 | 25 mg | Tablet | Oral | 02141728, 02017849, 02097583, 02229492, 02229960, 02239029, 02257548, 02348608, 02479710 | 02246449, 02258994, 02249529, 02515849, 02245778, 02521512, 02431599, 02436930, 02508796
Diphenhydramine | 6.25 mg/5 mL | Solution | Oral | 02019698, 02248858, 02478242 | 02311232
Diphenhydramine | 50 mg | Tablet | Oral | 01934414, 01991086, 01946986, 02097575, 02229959, 02230398, 02230485, 00583332, 02237789, 02239138, 02257556, 02490943, 02478757, 02498952, 02470144, 02409259 | 02246450, 02263882, 02456303, 02515830, 02532484
Diphenhydramine | 50 mg | Capsule | Oral | 02061597, 00757691, 00489867, 02237169, 02238644, 02244203, 02409224, 02321270 | 02361256, 02447827, 02247659, 02270900, 02318849, 02483122, 02491850
Diphenhydramine | 25 mg | Capsule | Oral | 00757683, 02306352, 02383268, 02365685, 02304252 | 02520745, 02411415
Diphenhydramine | 12.5 mg | Tablet (Chewable) | Oral | 02061287 | 02312352
Diphenhydramine | 12.5 mg/5 mL | Solution | Oral | 02019736, 02465108
Diphenhydramine | 12.5 mg/5 mL | Liquid | Oral | 02248859
Diphenhydramine | 12.5 mg/5 mL | Elixir | Oral | 02298503 | 02311240
Diphenhydramine | 12.5 mg | Tablet (Orally Disintegrating) | Oral | 02505649
Diphenhydramine | 50 mg/30 mL | Liquid | Oral | 02419769
Diphenhydramine | 50 mg/30 mL | Solution | Oral | 02427427, 02432129, 02474867, 02464683
DIPHENHYDRAMINE | 6.25 mg/5 mL | Syrup | Oral |  | 02368374
DIPHENHYDRAMINE | 25 mg | Strip | Oral |  | 02284170
DIPHENHYDRAMINE | 12.5 mg | Tablet | Oral |  | 02247762
Diphenhydramine | 50 mg/mL | Liquid | Intramuscular, [NAME] | 02219336, 00596612
Diphenhydramine | 50 mg/mL | Solution | Intramuscular, [NAME] | 02369567
Diphenhydramine | 2% | Cream | Topical | 02247560 | 02401932, 02354578
DIPHENHYDRAMINE | 2%/w/w | Cream | Topical |  | 02321076
Spreadsheet: 649088d1573471146-how-to-find-nearest-value-in-excel-nearest-point
Sheet: Sheet1

NEW DATA |  |  |  | OLD DATA |  |  |  | LOOKUP-MMULT |  |  |  | FREQUENCY |  |  |  | INDEX-MATCH
GULLY | FM_EASTING | FM_NORTHING |  | GULLY | Easting (X) | Northing (Y) |  | GULLY | Easting (X) | Northing (Y) |  | GULLY | Easting (X) | Northing (Y) |  | GULLY | Easting (X) | Northing (Y)
1 | 220738.544 | 387238.219 |  | A | 222529.349 | 387863.667
2 | 227316.391 | 391205.881 |  | B | 222460.898 | 387652.85
3 | 221820.297 | 387640.736 |  | C | 221852.452 | 387640.789
4 | 221852.384 | 387640.742 |  | D | 221820.068 | 387628.96
5 | 221844.918 | 387628.963 |  | E | 221844.784 | 387628.926
6 | 221821.016 | 387628.803 |  | F | 222522.967 | 387868.383
7 | 221820.414 | 387628.816 |  | G | 222511.128 | 387856.551
8 | 221965.634 | 387629.571 |  | H | 222454.09 | 387842.85
9 | 221965.634 | 387629.571 |  | I | 222416.716 | 387839.652
10 | 221915.21 | 387629.225 |  | J | 221965.511 | 387679.604
11 | 222445.005 | 387677.73 |  | K | 221965.83 | 387629.612
12 | 222460.823 | 387652.888 |  | L | 221915.022 | 387629.329
13 | 222459.856 | 387851.735 |  | M | 222459.825 | 387851.675
14 | 222454.046 | 387842.838 |  | N | 221820.132 | 387640.596
15 | 222436.785 | 387838.095 |  | O | 221820.938 | 387628.995
16 | 222416.509 | 387839.669 |  | P | 222445.054 | 387677.866
17 | 222523.037 | 387868.282 |  | Q | 222436.88 | 387838.154
18 | 222529.394 | 387863.609 |  | R | 220738.59 | 387237.87
19 | 222511.09 | 387856.545 |  | S | 227316.454 | 391205.907
20 | 222503.597 | 387863.268
 |  |  |  |  |  |  |  | Only accurate if you treat long and lat as a unit x and unit y change. For locations on the surface of the earth this will only be a reasonable approximation near the tropics. |  |  |  | Standard formula for spherical distances |  |  |  | Based on square root of the sum of squares
Spreadsheet: 852552d1702549730-choose-with-array-function-sample
Sheet: Sheet1

Points |  | 1 | 2 | 3 | 4 |  |  | Points |  | 11 | 12 | 1 | 2
1 |  | 1 |  | 1 |  |  |  | 2 |  | 1 |  |  | 1
3 | 12 | 1 |  |  | 1 | 5 |  | 7 | 10 |  |  |  |  | 3
5 | 11 |  |  |  |  | 6 |  | 11 | 9 |  |  |  |  | 4
12 |  |  |  |  |  |  |  |  |  |  | 1
 |  | 10 | 9 | 8 | 7 |  |  |  |  | 8 | 7 | 6 | 5
 |  | Box number dynamic every time will change the orders
Spreadsheet: 90735d1290500047-lookup-from-separate-sheet-export
Sheet: Sheet1

Item | Cores_Dipped | CoreNotes | MinPouringTemp | MaxPouringTemp | ChillWedgeTest | MetalMeltingNotes | PouringTime | PouringCupLevel | MouldProductionNotes | HBWCheckPositions | HBWSpreadCheck | CrossJointExceed | [NAME] | MicroStructureCheck | MachineTrial | StressRelieve | BrakePlateThickness | InspectionNotes | Angle | Dwell | Advanced | DespatchMedium | OilWrapPaper | StackingMethod | StackingPattern | StackingPatternForm | FinishingNotes | QACertRequired | PatternNotes | [NAME] | NoteExistsFlag | RecordDate | CreatedBy | UpdatedBy | CreateDate
120/214 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9 |  | 9 |  |  |  |  |  |  |  |  | 0 | 0 | 2010-11-11 11:05:28.020000 | sa | sa | 2010-10-27 09:53:07.590000
3462.01 | No | *** Core Notes *** | 1370 | 1400 | 2 | ***MetalMeltingNotes*** | 0 | 2 | ***MouldProductionNotes*** | N/A |  | 0.75 | No | No | No | No | 0 | ***InspectionNotes*** | A9 | 8 | 2 | S/W Pallet | No | Interlocked | 5 x 3 x 8 | Form F82 & F83 | ***FinishingNotes*** | No |  | 0 | 0 | 2010-10-26 12:05:53.023000 |  |  | 2010-10-26 11:42:34.260000
Spreadsheet: 32459d1228638341-how-to-reference-cells-in-different-rows-example-of-weekly-account-sheets
Sheet: Week 2

1 | SALES | 1
1 | SALES | 1 |  |  |  |  |  | 520
1 | SALES | 1
1 | SALES | 1 |  |  |  | 770
1 | SALES | 1
1 | SALES | 1 |  |  |  |  | YELLOW
1 | SALES | 1
1 | SALES | 1
1 | SALES | 1 |  | 958
1 | SALES | 1
1 | SALES | 3
1 | SALES | 3 |  |  |  |  |  | 521
1 | SALES | 3
1 | SALES | 3 |  |  |  | 756
1 | SALES | 3
1 | SALES | 3 |  |  |  |  | PURPLE
1 | SALES | 3
1 | SALES | 3
1 | SALES | 3 |  | 964
1 | SALES | 3
1 | SALES | 4
1 | SALES | 4 |  |  |  |  |  | 522
1 | SALES | 4
1 | SALES | 4 |  |  |  | 741
1 | SALES | 4
1 | SALES | 4 |  |  |  |  | BLACK
1 | SALES | 4
1 | SALES | 4
1 | SALES | 4 |  | 959
1 | SALES | 4
Spreadsheet: 889427d1740218484-2-way-look-up-formula-to-transpose-data-from-calculation-sh-to-sample-results-sheet-calculation
Sheet: SAMPLE RESULTS

DAT | DATA | DATA | DATA | DATA | DATA | DATA | DATA | ROUND | Item No | 24 | 30 | 11 | 33 | 12 | 26
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 721 | 2
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 247 | 3
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 24 | 4
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 407 | 5
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 722 | 6
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 11204 | 7
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 540 | 8
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 3012 | 9
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 860 | 10
DAT | DAT | FR | 0 | 0 | 0 | 0 | 45 | 155 | 11
DAT | DAT | ES | 0 | 0 | 0 | 0 | 0 | 317 | 12
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 591 | 13
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 92 | 14
DAT | DAT | ES | 0 | 0 | 0 | 0 | 0 | 345 | 15
DAT | DAT | BE | 0 | 0 | 0 | 0 | 0 | 671 | 16
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 4036 | 17
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 21 | 18
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 28 | 19
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 18 | 20
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 57 | 21
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 905 | 22
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 54 | 23
DAT | DAT | BE | 0 | 0 | 0 | 0 | 0 | 186 | 24
DAT | DAT | DE | 0 | 0 | 0 | 0 | 0 | 83 | 25
DAT | DAT | ES | 0 | 0 | 0 | 0 | 0 | 223 | 26
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 505 | 27
DAT | DAT | NL | 0 | 0 | 0 | 0 | 0 | 83 | 28
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 435 | 29
DAT | DAT | IT | 0 | 0 | 0 | 0 | 0 | 34 | 30
DAT | DAT | FR | 0 | 0 | 0 | 0 | 60 | 850 | 31
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 292 | 32
DAT | DAT | FR | 0 | 0 | 0 | 0 | 30 | 72 | 33
DAT | DAT | PT | 0 | 0 | 0 | 0 | 0 | 83 | 34
DAT | DAT | IT | 0 | 0 | 0 | 0 | 0 | 224 | 35
DAT | DAT | ES | 0 | 0 | 0 | 0 | 0 | 27 | 36
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 128 | 37
DAT | DAT | FR | 0 | 0 | 0 | 0 | 60 | 79 | 38
DAT | DAT | GB | 0 | 0 | 0 | 0 | 30 | 75 | 39
DAT | DAT | FR | 0 | 0 | 0 | 0 | 450 | 1475 | 40
DAT | DAT | FR | 0 | 0 | 0 | 0 | 15 | 54 | 41
DAT | DAT | IR | 0 | 0 | 0 | 0 | 30 | 152 | 42
DAT | DAT | FR | 0 | 0 | 0 | 0 | 15 | 72 | 43
DAT | DAT | FR | 0 | 0 | 0 | 0 | 30 | 45 | 44
DAT | DAT | FR | 0 | 0 | 0 | 0 | 150 | 120 | 45
DAT | DAT | FR | 0 | 0 | 0 | 0 | 30 | 40 | 46
DAT | DAT | FR | 0 | 0 | 0 | 0 | 15 | 24 | 47
DAT | DAT | FR | 0 | 0 | 0 | 0 | 15 | 9 | 48
DAT | DAT | IN | 0 | 0 | 0 | 0 | 0 | 419 | 49
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 1922 | 50
DAT | DAT | FR | 0 | 0 | 0 | 0 | 15 | 5 | 51
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 1184 | 52
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 74 | 53
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 486 | 54