tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 861748d1709586604-linking-and-deleting-cell-data-league-blank-dj
Sheet: BLANK

 |  | MATCH 1 |  | POINTS | MATCH 2 |  | POINTS | MATCH 3 |  | POINTS | MATCH 4 |  | POINTS | MATCH 5 |  | POINTS | MATCH 6 |  | POINTS | MATCH 7 |  | POINTS | MATCH 8 |  | POINTS | POINTS | DROPS | NET POINTS | SECTION WINS | TOTAL WEIGHT
 |  | 2023-11-12 00:00:00 |  |  | 2023-11-26 00:00:00 |  |  | 2023-12-10 00:00:00 |  |  | 2023-12-17 00:00:00 |  |  | 2024-01-07 00:00:00 |  |  | 2024-02-04 00:00:00 |  |  | 2024-02-18 00:00:00 |  |  | 2024-03-03 00:00:00
 |  | lbs | ozs |  | lbs | ozs |  | lbs | ozs |  | lbs | ozs |  | lbs | ozs |  | lbs | ozs |  | lbs | ozs |  | lbs | ozs
1
2
3
4
5 |  | 151 | 0 | 2 | 167 | 2 | 2 | 173 | 3 | 2 | 80 | 1 | 4 | 62 | 0 | 3 | 150 | 7 | 1 | 237 | 14 | 2 | 124 | 12
6
7 |  | 183 | 15 | 1 | 117 | 15 | 3 | 114 | 11 | 2 | 162 | 15 | 2 | 9 | 7 | 5 | 104 | 5 | 3 | 155 | 15 | 5 | 84 | 10 | 2
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 855424d1704988457-matching-2-columns-with-multiple-same-values-sample
Sheet: Sheet1

X | Y
5.1 | 158.69 | "matched with row 6" | << I'm in need of a formula in C2 that would check if value from A2 is found in collumn B and return row number of matched cell in column B but on the next same value the first "match" would have to be ignored
-139.47 | 45.67
-89.38 | 0
-80.46 | -139.47
123.5 | 5.1
55.98 | 5.36
65.55 | 9.87
0 | 5.1
5.1 | 0 | "matched with row 9" | << I tried using lookup and match formulas but they always find just the first record (in this case both for A2 and A10 result would be [NAME] which is not what I'm looking for, I'd need to match A2 with [NAME] and A10 with B9 , and A13 with "no match"
10.5 | 0
5.22 | 55.98
5.1 | 1.24 | "no match"
Spreadsheet: 552929d1513850355-urgent-help-in-vlookup-copy-of-book3
Sheet: Sheet1

 |  | Bond No. | Bond Date | Import Value $ | Export Cts. | Export Amt. | Export Cts. | Total Cts.
 |  | FIPL-15 | 2015-03-19 00:00:00 | 1494490.57 | 16.17 | 19705.2
 |  | FIPL-17 | 2015-03-19 00:00:00 |  | 8.05 | 16259.6 |  | 1250
 |  | FIPL-18 | 2015-03-19 00:00:00 |  | 435.35 | 1326868.4 |  | 1456
 |  |  |  |  |  |  |  | A
 |  | FIPL-15 | 2015-03-19 00:00:00 |  | 99.37 | 265577.2 |  |  | Result I want
 |  | FIPL-17 | 2015-03-19 00:00:00 |  | 389.5 | 622420.7 |  | B
 |  | FIPL-18 | 2015-03-19 00:00:00 |  | 90.06 | 53652.25 |  | C
 |  |  |  |  |  |  |  | D
 |  | FIPL-15 | 2015-03-19 00:00:00 | 1209208.17 | 406.74 | 905324.1 |  |  | Result I want
 |  | FIPL-16 | 2015-03-19 00:00:00 |  | 631.89 | 259835.1 |  | F
 |  | FIPL-15 | 2015-03-19 00:00:00 | 303884.0700000002 | 13.28 | 8287.2 |  | G | Result I want
 |  | FIPL-18 | 2015-03-19 00:00:00 |  | 5.55 | 4278.2 |  | H
Spreadsheet: f169392c-503b-4995-b5ae-1aa219d0da8c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259957 | 75919 | Marianne | Hüche | DEN | 255 | 00:17:15 | 00:02:21 | [NAME] | 00:01:37 | 00:26:53 | DQ | 00:00:00
259957 | 60937 | Hailey | Danisewicz | USA | 254 | 00:15:36 | 00:03:01 | 00:44:37 | 00:01:12 | 00:25:05 | 1 | 01:29:29
259957 | 41634 | [NAME] | Stockwell | USA | 252 | 00:12:09 | 00:02:48 | [NAME] | 00:02:12 | 00:26:42 | 2 | 01:30:39
259957 | 32629 | [NAME] | Reinertsen | USA | 253 | 00:16:06 | [NAME] | 00:46:15 | 00:01:14 | 00:32:08 | 3 | 01:38:32
Spreadsheet: 300962d1393614167-sound-alert-as-a-cell-value-changes-excelforumsoundalert-2014-02-28-13-59
Sheet: Sheet1

Category |  |  |  |  | Amount
 |  | Groceries |  |  | -164 |  |  | Expenses
Walmart |  |  |  |  | -144 |  |  | Walmart |  |  | -30
Target |  |  |  |  | -20 |  |  | Target |  |  | -20
 |  | Dining |  |  | -131 |  |  | Shell |  |  | -15
McDonald's |  |  |  |  | -31 |  |  | TGIF |  |  | -20
Taco Bell |  |  |  |  | -60 |  |  | Walmart |  |  | -90
TGIF |  |  |  |  | -40 |  |  | Sunoco |  |  | -30
 |  | Gas/ Fuel |  |  | -75 |  |  | Taco Bell |  |  | -50
Shell |  |  |  |  | -15 |  |  | TGIF |  |  | -20
Marathon |  |  |  |  | 0 |  |  | Walmart |  |  | -14
Sunoco |  |  |  |  | -60 |  |  | Sunoco |  |  | -30
TOTAL |  |  |  |  | -370 |  |  | McDonald's |  |  | -16
 |  |  |  |  |  |  |  | McDonald's |  |  | -15
 |  |  |  |  |  |  |  | Taco Bell |  |  | -10
 |  |  |  |  |  |  |  | Walmart |  |  | -10
 |  |  |  |  |  |  |  |  |  |  | -20
 |  |  |  |  |  |  |  | Now, If I type "Walmart" in the red cell, It will
 |  |  |  |  |  |  |  | Add "-20" to Groceries, and to the total.
 |  |  |  |  |  |  |  | However, if I type something that is not in the
 |  |  |  |  |  |  |  | Category list (ex: [NAME]), nothing will happen.
 |  |  |  |  |  |  |  | Which means I would have to add "Publix" to my
 |  |  |  |  |  |  |  | Category list to be included in the calculations.
 |  |  |  |  |  |  |  | I want to heat a beep or a .wav file evey time "F13"
 |  |  |  |  |  |  |  | changes value.
Spreadsheet: 856569d1705770932-compare-planned-vs-actual-values-monthly-and-generate-a-table-20240121_o365_compare-planned-vs-actuals-excelforum
Sheet: Comparison

 | Activity | Month | Plan | Actual | Actual > Plan | [NAME] | Cumulative Variance | Actuals to cover Previous Months Backlog |  |  | Plan As of | 2023-03-01 00:00:00
 | Activity 1 | 2023-01-01 00:00:00 | 100 | 150 | 50 | 50 | 50 | 0 |  |  | Actual As of | 2023-03-30 00:00:00
 | Activity 1 | 2023-02-01 00:00:00 | 200 | 200 | 0 | 0 | 50 | 0
 | Activity 1 | 2023-03-01 00:00:00 | 300 | 600 | 300 | 300 | 350 | 0
 | Activity 2 | 2023-01-01 00:00:00 | 0 | 100 | 100 | 100 | 100 | 0
 | Activity 2 | 2023-02-01 00:00:00 | 200 | 0 | 0 | -200 | -100 | 0
 | Activity 2 | 2023-03-01 00:00:00 | 0 | 250 | 250 | 250 | 150 | 100
 | Activity 3 | 2023-03-01 00:00:00 | 200 | 0 | 0 | -200 | -200 | 0
 |  | 2023-01-01 00:00:00 | 100 | 150 | 50 | 50 | 50 | 0
 | Activity 1 | 2023-02-01 00:00:00 | 200 | 200 | 0 | 0 | 50 | 0
 | Activity 1 | 2023-03-01 00:00:00 | 300 | 600 | 300 | 300 | 350 | 0
 | Activity 2 | 2023-01-01 00:00:00 | 0 | 100 | 100 | 100 | 100 | 0
 | Activity 2 | 2023-02-01 00:00:00 | 200 | 0 | 0 | -200 | -100 | 0
 | Activity 2 | 2023-03-01 00:00:00 | 0 | 250 | 250 | 250 | 150 | 100
 | Activity 3 | 2023-03-01 00:00:00 | 200 | 0 | 0 | -200 | -200 | 0
Spreadsheet: 67409d1268056852-excel-2007-adjusting-stock-level-formula-testinventory
Sheet: Sold & Received Stock

DATE
PRODUCT CODE | STOCK | SOLD | RIGHT FOODS, LIGHT EXPERIENCE |  | FACTORY PUMPS
40001 | 500 | 12 | -6
40002 | 500 | 23
40003 | 500 | 24
40003A | 500 | 25
40004 | 500 | 32 | -5
40005 | 500 | 45
40006 | 500 | 34 | -5
Spreadsheet: 696129d1600651175-writing-an-if-formula-or-other-formula-that-will-do-this-number-series-numbers-i-want-repeated
Sheet: Blad1

 |  |  | 0.5 |  | 0
 |  |  | 0.9
 |  |  | 1
 |  |  | 0.7
 |  |  | 0.8
 |  |  | 1.1
 |  |  | 2
 |  |  | 2.2
 |  |  | 1.2
 |  |  | 1.3
 |  |  | 1.4
Spreadsheet: 142bc510-de4d-4304-90f2-85741ce70aa1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 10. LEASE FINANCE COMMITMENTS, For Motor Vehicles: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Motor cars and station wagons - New ; |  |  | Original | A2413502X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Motor cars and station wagons - Used ; |  |  | Original | A2413503A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Light trucks - New ; |  |  | Original | A2413504C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Light trucks - Used ; |  |  | Original | A2413505F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Heavy trucks - New ; |  |  | Original | A2413506J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Heavy trucks - Used ; |  |  | Original | A2413507K | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Other motor vehicles ; |  |  | Original | A2413508L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2413509R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 593033d1538903315-extract-a-specific-line-from-a-excel-cell-containing-multi-line-text-representative-sample-07-10-2018
Sheet: Sheet 1

Representative Sample
$99.99_x000D_ free  shippingsku:  EZEZ3101B2G1
condition:_new_x000D_ $119.99_x000D_ free  shippingsku:  228242910
condition:_new_x000D_ $119.99_x000D_ free  shippingsku:  9B-81-389-05_x000D_ _x000D_ _x000D_ _x000D_ 6
condition:_new_x000D_ $119.99_x000D_ free  shippingsku:  9SIAENY70G80_x000D_ _x000D_ _x000D_ _x000D_ 49
condition:_new_x000D_ $119.99_x000D_ free  shippingsku:  N82E16881389_x000D_ _x000D_ _x000D_ _x000D_ 056
condition:_new_x000D_ $119.99_x000D_ free  shipping
$119.99sku:  EZ3101B2G16
condition:_new_x000D_ $240.99_x000D_ free  shippingsku:  9SIV0BA7CP97_x000D_ _x000D_ _x000D_ _x000D_ 79
condition:_new_x000D_ $400.00_x000D_ free  shippingsku:  9SIAACD61X90_x000D_ _x000D_ _x000D_ _x000D_ 62
condition:_new_x000D_ $403.00_x000D_ free  shipping
$403.00sku:  OO917407
condition:_new_x000D_ $119.00_x000D_ free  shippingsku:  9SIAEFK65U47_x000D_ _x000D_ _x000D_ _x000D_ 86
$118.19sku:  277115
condition:_new_x000D_ $122.16_x000D_ free  shippingsku:  9SIA6ZP4G324_x000D_ _x000D_ _x000D_ _x000D_ 94
condition:_new_x000D_ $130.59_x000D_ free  shippingsku:  9SIV1DS7B208_x000D_ _x000D_ _x000D_ _x000D_ 43
condition:_new_x000D_ $133.98_x000D_ free  shippingsku:  39385812
condition:_new_x000D_ $149.99_x000D_ free  shippingsku:  15394651-000_x000D_ _x000D_ _x000D_ _x000D_ -000
condition:_new_x000D_ $214.75_x000D_ shipping:$10.00sku:  9SIV19776N29_x000D_ _x000D_ _x000D_ _x000D_ 68
condition:_new_x000D_ $214.75_x000D_ free  shippingsku:  9SIA17P76N28_x000D_ _x000D_ _x000D_ _x000D_ 59
$124.79sku:  [PHONE]
condition:_new_x000D_ $99.00_x000D_ free  shippingsku:  072848
condition:_new_x000D_ $122.62_x000D_ free  shippingsku:  170417795
condition:_New_x000D_ $132.59_x000D_ shipping:$10.00sku:  53663062
$150.00
$151.96sku:  060256752375_x000D_ _x000D_ _x000D_ _x000D_ 8
condition:_new_x000D_ $122.62_x000D_ free  shippingsku:  170417795
condition:_New_x000D_ $132.59_x000D_ shipping:$10.00sku:  53663062
$150.00
$151.96sku:  060256752375_x000D_ _x000D_ _x000D_ _x000D_ 8
condition:_new_x000D_ $119.99_x000D_ shipping:$3.99sku:  [NAME]_ _x000D_ _x000D_ _x000D_ 177
Spreadsheet: 35994d1233745067-v-lookup-or-if-function-vlookup-test
Sheet: 401K

SSN | Name | Status | 2009 Plan Yr Compensation | Birth Date | Hire Date | Plan Entry Date | Term Date | Company Ownership % |  | Define Relationship to Owner |  | Relative SSN
123-12-3221 | DOE, ANDREW | 1 |  | 1985-01-08 00:00:00 | 2008-03-29 00:00:00 | 2004-02-08 00:00:00
123-12-3220 | DOE, JON | 1 |  | 1985-01-07 00:00:00 | 2008-08-16 00:00:00 | 2004-02-07 00:00:00
123-12-3216 | SMITH, KATIE | 1 |  | 1985-01-03 00:00:00 | 2003-07-19 00:00:00 | 2004-02-03 00:00:00
123-12-3219 | DOE, [NAME] | 0 |  | 1985-01-06 00:00:00 |  | 2004-02-06 00:00:00 | 2008-08-08 00:00:00
123-12-3214 | SMITH, [NAME] | 0 |  | 1985-01-01 00:00:00 |  | 2004-02-01 00:00:00 | 2003-07-02 00:00:00
123-12-3217 | SMITH, JOE | 0 |  | 1985-01-04 00:00:00 |  | 2004-02-04 00:00:00 | 2003-08-08 00:00:00
123-12-3218 | SMITH, JOHNNY | 0 |  | 1985-01-05 00:00:00 |  | 2004-02-05 00:00:00 | 2005-09-10 00:00:00
123-12-3215 | SMITH, JON | 0 |  | 1985-01-02 00:00:00 |  | 2004-02-02 00:00:00 | 2008-03-15 00:00:00
Spreadsheet: 137449d1327117620-extending-formulas-on-linked-sheet-to-continue-onto-other-worksheets-dummy-file-with-extended-worksheets
Sheet: Expense Report - pg 1

Name |  | Company | Purpose | Start Date | End Date
Date | Payee | Type of Expense | Purpose | Individuals/Companies | Amount
I CERTIFY THAT THE ABOVE EXPENSES HAVE BEEN INCURRED BY ME ONLY ON BEHALF OF THE COMPANY AND HAVE NOT BEEN PREVIOUSLY PAID OR REIMBURSED BY THE COMPANY. |  |  |  | Balance Due Employee:
Signature of Employee |  |  |  | Date
Approval by Immediate Supervisor |  |  |  | Date
Spreadsheet: 733370d1621529796-return-last-value-from-a-row-on-another-tab-eh_bau-project-planner_v2
Sheet: Background stuff_DO NOT AMEND!

Andi |  |  |  |  |  | On hold |  |  |  |  |  |  | Low |  | No |  |  | N/A
[NAME] |  |  |  |  |  | Not Started |  |  |  |  |  |  | Medium |  | Yes |  |  | 0
Jo |  |  |  |  |  | In progress |  |  |  |  |  |  | High |  | N/A |  |  | 1
[NAME] |  |  |  |  |  | Completed |  |  |  |  |  |  |  |  | TBC |  |  | 2
[NAME] |  |  |  |  |  | Total Tasks |  |  |  |  |  |  |  |  |  |  |  | 3
Rohit
Shetal
Shetal & Molly
SRM Leads
Other (specify in notes)
Spreadsheet: louise_kitchen__23045__11-07 Short Term Cash
Sheet: Variance

Changes as of 10 am
Current Day Variance
 | 770.21 |  | Projected beginning last night
 | 13.7 |  | [NAME] receipts
 |  |  | Actual Opening Balance
 | -224.25 |  | Business units detailed on schedule
 |  |  | Net A2P2 shown on schedule
 |  |  | Net A1P1 shown on schedule
 |  |  | Rounding
 |  |  | Expected Ending 11/7/01
Total Variance
 | 274.1 | 12/31 Forecast as of 11/6
 | 13.7 | Beg. [NAME].
 |  | Current Day BU/Corp Activity
 |  |  | Estimate
 |  | -224.25 | Actual for all operations
 |  | End of Day adj
 | -0.1 | Rounding
 |  | 12/31 Forecast as of 11/7
Spreadsheet: 683517d1592805475-adding-indirect-function-to-an-existing-if-statement-no-need-for-indirct-aligw
Sheet: LeagueADP

ESPN |  |  |  |  | NFL
Spreadsheet: 835796d1688824355-text-split-then-create-spilling-table-textsplit-unknow-dimension
Sheet: Feuil1

 |  |  |  |  |  |  |  |  |  |  | EXPECTED RESULT (SPILLING ARRAY)
Column1 | Column2 | Column3 | Column4 |  |  |  | c,d | a,c,b |  |  | a |  | c | a
a,b |  | c,d | a,c,b |  |  |  |  |  |  |  | b |  | d | c
 |  |  |  |  |  |  |  |  |  |  |  |  |  | b
 |  |  |  |  |  |  |  |  |  |  | Column1 | Column2 | Column3 | Column4
 |  |  |  |  |  |  |  |  |  |  | a |  | c | a
 |  |  |  |  |  |  |  |  |  |  | b |  | d | c
 |  |  |  |  |  |  |  |  |  |  |  |  |  | b
Spreadsheet: 135901d1326297977-help-with-having-data-automatically-sorted-in-highest-to-lowest-order-masterstudentscoresheet
Sheet: List

Pos. | Name | Score |  | Pos. | Name | Score
7 | [NAME] | 73 |  | 1 | [NAME] | 95
5 | [NAME] | 80 |  | 2 | [NAME] | 92
3 | Jon | 86 |  | 3 | Jon | 86
4 | [NAME] | 84 |  | 4 | [NAME] | 84
2 | [NAME] | 92 |  | 5 | [NAME] | 80
6 | [NAME] | 78 |  | 6 | [NAME] | 78
1 | [NAME] | 95 |  | 7 | [NAME] | 73
8 | Curt | 63 |  | 8 | Curt | 63
Spreadsheet: 150355d1334465868-how-to-pull-multiple-values-examplev2
Sheet: Sheet2

Consultant | 2012-04-06 00:00:00
AS
SB
DS
CC
KB
SS
Spreadsheet: 491859d1480674518-mulitple-rows-to-a-single-column-leave-blanks-out-test-frames
Sheet: RNG (1)

 |  |  |  | FRAMES
 |  |  |  | Column | A | B | C | D | E | F | G | H | I | J | K | L
 |  |  |  | Row 1 | [NAME] | [NAME] | CDT1
 |  |  |  | Row 2 | DES2 | BCS2 | CDA2 | [NAME]
 |  |  |  | Row 3 | ABC3 | BCD3
 |  |  |  | Row 4 | DET4 | EFT4 | FGT4 | ABA4
 |  |  |  | Row 5
 |  |  |  | Row 6
 |  |  |  | Row 7
 |  |  |  | Row 8
 |  |  |  | Row 9
 |  |  |  | Row 10
 |  |  |  | Row 11
 |  |  |  | Row 12
 |  |  |  | Row 13
 |  |  |  | Row 14
 |  | Neet to list above items sorted in a single column |  |  |  | Need to list each row left to right with comma seperated and with a PERIOD (.) at end
 |  | Raw Data (via formula) BY ROW LEFT TO RIGHT | Raw Data in Column "C" Sorted | NEEDED RESULT #1 |  | Concatenate Transpose Columns (A to L)  Leave Blanks out |  |  | Needed Result #2
 |  |  |  | ABA4 |  |  | If I use an Array |  | Row1: GHT1, [NAME], CDT1.
 |  |  |  | [NAME] |  |  | formula I get this |  | Row2: DES2, BCS2, CDA2, [NAME].
 |  |  |  | ABC3 |  |  | but only the first |  | Row3: ABC3, BCD3.
 |  |  |  | BCD3 |  |  | cell value & |  | Row4: DET4, EFT4, FGT4, ABA4.
 |  |  |  | BCS2 |  |  | no blanks
 |  |  |  | [NAME]
 |  |  |  | CDA2 |  |  | If I use a regular
 |  |  |  | CDT1 |  |  | formula I get the values
 |  |  |  | DES2 |  |  | starting with column
 |  |  |  | DET4 |  |  | "B" (G) and blanks
 |  |  |  | EFT4 |  |  | show as zeros (0)
 |  |  |  | FGT4 |  |  | but still only the
 |  |  |  | [NAME] |  |  | first cell value
Spreadsheet: 032c4cdf-1cf0-4ca4-bde0-c7f1833775b3
Sheet: Sheet1

Additional file 8:  Overrepresented gene categories with transcript accumulation changes during seed fill. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Gene ontology (GO) categories that are overrepresented in the NIL genotypes [NAME] and [NAME] are shown next to the stages compared and the direction of trend changes.
For Stage comparison: 1 to 4 and Trend: decrease, the trend of transcript accumulation decreases from stage one to stage four.   The GO term identifier is indicated along with the functional categorization.
BP = biological process.  MF = molecular function. # of genes = number of genes represented by the Affymetrix® Soy GeneChip with transcript accumulation changes.
Genotype | Stage comparison | Trend | GO term | GO description | # of genes | P-value
LoPro | 1 to 4 | Decrease | [NAME] | photosynthetic electron transport in photosystem I | 7 | 0.000875
LoPro | 1 to 4 | Decrease | GO:0015979 BP | photosynthesis | 12 | 0.00382
LoPro | 1 to 4 | Decrease | GO:0016168 MF | chlorophyll binding | 7 | 0.00528
HiPro | 1 to 4 | Increase | GO:0009250 BP | glucan biosynthetic process | 5 | 1.9e-05
HiPro | 1 to 3 | Decrease | GO:0003777 MF | microtubule motor activity | 9 | 0.00322
HiPro | 1 to 3 | Increase | GO:0045735 MF | nutrient reservoir activity | 9 | 3.81e-06
HiPro | 1 to 4 | Decrease | GO:0007018 BP | microtubule-based movement | 17 | 1.07e-07
HiPro | 1 to 4 | Decrease | GO:0005975 BP | carbohydrate metabolic process | 31 | 0.0112
HiPro | 1 to 4 | Decrease | GO:0003777 MF | microtubule motor activity | 22 | 0
HiPro | 1 to 4 | Decrease | GO:0016538 MF | cyclin-dependent protein kinase regulator activity | 9 | 0.000352
HiPro | 1 to 4 | Decrease | GO:0004356 MF | glutamate-ammonia ligase activity | 5 | 0.00133
HiPro | 1 to 4 | Decrease | GO:0004553 MF | hydrolase activity, hydrolyzing O-glycosyl compounds | 18 | 0.00676
HiPro | 1 to 4 | Increase | GO:0019915 BP | sequestering of lipid | 6 | 0.00279
HiPro | 1 to 4 | Increase | GO:0045735 MF | nutrient reservoir activity | 12 | 0.00055
Spreadsheet: 70225d1270984913-random-answers-generated-from-a-list-myproblem-1-
Sheet: Sheet1

 |  | Result appears Below
Random number below press F9 to generate
8 |  | Have a walk | 4
 |  |  | 1-4 | 5 | 6-10
 |  | Key | Morning | Noon | Evening
 |  |  | Weekday | Weekend | Today
 |  |  | Monday | Thursday | Friday
 | 1 | Wash car | 1-3 | 4-8 | 9-10
 | 2 | Cut the grass | 1 | 2-9 | 10
 | 3 | Walk the dog | 1-4 | 5 | 6-10
 | 4 | [NAME] lunch | 1-3 | 4-8 | 9-10
 | 5 | Go shopping | 1-4 | 5 | 6-10
 | 6 | Watch Tv | 1-3 | 4-8 | 9-10
 | 7 | Phone a friend | 1 | 2-9 | 10
 | 8 | Have a walk | 1-4 | 5 | 6-10
 | 9 | Go to the Gym | 1-3 | 4-8 | 9-10
 | 10 | Hover the House | 1-4 | 5 | 6-10
Spreadsheet: 62295d1263266109-data-validation-and-if-statements-713612-help-appreciated-data-validation-and-combined-if-statements
Sheet: Sheet2

utility | ElectDist | GasDist | Service | EReadSub | GReadSub | EInvestSub | GInvestSub
Gas | Edist1 | Gdist1 | Special Read | e read sub 1 | g read sub 1 | e invest sub 1 | g invest sub 1
Electricity | Edist2 | Gdist2 | Investigation | e read sub 2 | g read sub 2 | e invest sub 2 | g invest sub 2
 | Edist3 | Gdist3 |  | e read sub 3 | g read sub 3 | e invest sub 3 | g invest sub 3
 |  | [NAME]
 |  | Gdist5
Spreadsheet: 491019d1480267899-time-formula-to-calculate-employees-working-shift-hours-formula
Sheet: Sheet2

Day | Clock in | Clock out | Day Hours | Afternoons | Nights | Total Hours |  | 06:00:00 | 0.25
Monday | 06:00:00 | 14:00:00 |  |  |  |  |  | 14:00:00 | 0.5833333333333334
Tuesday | 14:00:00 | 22:00:00 |  |  |  |  |  | 22:00:00 | 0.9166666666666666
Wednesday | 22:00:00 | 06:00:00
Thursday | 06:00:00 | 17:00:00
Friday | 23:00:00 | 08:00:00
Saturday | 15:00:00 | 23:00:00
Sunday | 21:00:00 | 04:00:00
 | Day Shift Rate: |  | 24.5
 | Afternoon Shift Premium: |  | 0.96 |  |  |  | Total | Regular | Shift |  | Actual
 | Night Shift Premium: |  | 1.22 |  |  |  | Paid | Pay | Premium pay |  | Pay
Day | Clock in | Clock out | Days | Afternoons | Nights | Break | Hours | Day | Aft | Night | Total
Monday | 06:00:00 | 14:00:00
Tuesday | 14:00:00 | 22:00:00
Wednesday | 22:00:00 | 06:00:00
Thursday | 06:00:00 | 17:00:00
Friday | 23:00:00 | 08:00:00
Saturday | 14:00:00 | 06:00:00
Sunday | 21:00:00 | 04:00:00
 |  | Day Shift Formula > | =IF(C2>B2,IF(MOD(C2+1/12,1)<=1/3,0,MIN(0.5833,C2)-IF(C2<=0.25,B2,MAX(B2,0.25))),MAX(0,0.5833-MAX(0.25,B2))+MAX(0,C2-0.25))*24
 |  | Afternoon Shift Formula > | =(B2>C2)*MEDIAN(0,C2-0.5833,0.5833)+MAX(0,MIN(0.9167,C2+(B2>C2))-MAX(0.5833,B2))*24
 |  | Night Shift Formula > | =IF(C2<B2,(1+C2-B2)*24,(C2-B2)*24)-(D2+E2)
Spreadsheet: 752289d1634688709-auto-fill-up-of-cells-in-excel-workbook-2-with-reference-from-workbook-1-work-book-2
Sheet: Sheet1

MIKE |  | YEAR 2021
MONTH |  | MONTH
JAN |  | FEB
1 | V | 1
2 |  | 2
3 |  | 3
4 | VT | 4 | V
5 | VL | 5
6 |  | 6 | VL
7 |  | 7
8 |  | 8
9 | VT | 9 | VL
10 |  | 10
11 | V | 11
12 |  | 12 | V
Spreadsheet: 214026d1360776680-auto-populate-vacation-calendar-dates-per-employee-holidaycalendar
Sheet: Calendar

 |  | Month, Year selection
 |  | Employee Selection
Employee |  | Type of leave |  | 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
Employee Name Selection |  | PTO
 |  | Unscheduled Absence
 |  | Class
 |  | Training
 |  | FMLA
 |  |  |  | I would like this calendar to tie in to the 2012 Calendar tab and have a drop down of the employee's name and the type of leave will auto-populate across the correct days to show what they were gone for in that year.
 |  | Month, Year selection
 |  | Employee Selection
Employee |  | Type of leave |  | 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
Employee Name Selection |  | PTO
 |  |  |  | I would like this calendar to tie in to the Season 1 tab (if possible).  This is not particular to a "type of leave" as in the other calendar, so this would only show the dates requesting per month by the current selected employee.