tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 600600d1543865268-fill-in-cell-based-on-relative-position-of-other-cell-relative_fill_cell
Sheet: Sheet2

Wake up | Breakfast | Lunch | Work | Dinner | Movie | Snack | Sleep | Day 1 |  |  | Hour | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 1900-01-01 01:00:00 | 1900-01-01 02:00:00 | 1900-01-01 03:00:00 | 1900-01-01 04:00:00 | 1900-01-01 05:00:00 | 1900-01-01 06:00:00
 |  |  |  |  |  |  |  |  |  |  | Relative hour | -12 | -11 | -10 | -9 | -8 | -7 | -6 | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  |  |  |  |  | Activity | Wake up | Breakfast |  |  |  |  | Lunch | Work |  |  |  |  | Dinner |  |  | Movie | Snack |  | Sleep
Wake up | Breakfast | Lunch | Work | Dinner | Movie | Snack | Sleep | Day 2 |  |  | Hour | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 1900-01-01 01:00:00 | 1900-01-01 02:00:00 | 1900-01-01 03:00:00 | 1900-01-01 04:00:00 | 1900-01-01 05:00:00 | 1900-01-01 06:00:00
 |  |  |  |  |  |  |  |  |  |  | Relative hour | -10 | -9 | -8 | -7 | -6 | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 |  |  |  |  |  |  |  |  |  |  | Activity |  |  | Wake up | Breakfast | Work |  | Lunch |  |  |  | Dinner |  |  |  |  | Movie |  |  |  | Snack | Sleep
 |  |  |  | Relative distance between columns |  |  |  | Etc. |  |  | Hour | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 1900-01-01 01:00:00 | 1900-01-01 02:00:00 | 1900-01-01 03:00:00 | 1900-01-01 04:00:00 | 1900-01-01 05:00:00 | 1900-01-01 06:00:00
 |  |  |  |  |  |  |  |  |  |  | Relative hour
Spreadsheet: 769453d1645546014-sort-data-range-in-stepped-using-formula-gk-guess
Sheet: Sheet1

1 | 3 | x | x | x | x | x | x | x |  |  |  |  |  |  |  | 3 | x | x | x | x | x | x | x
x | x | x | x | x | x | x | x | x |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x
x | x | x | x |  |  | x | x | x |  |  |  |  |  |  | x | x |  | x | x | x | x
x | x | x | x |  |  | x | x | x |  |  |  |  |  |  | x | x |  | x | x | x | x | x | x
x | x |  | x | x | x | x |  |  |  |  |  |  |  |  | x | x | x |  |  |  |  |  | x
x | x |  | x | x | x | x | x | x |  |  |  |  |  |  | x | x | x |  |  | x | x | x | x
x | x | x |  |  |  |  |  | x |  |  |  |  |  |  | x | x | x | x |  |  | x | x | x
x | x | x |  |  | x | x | x | x |  |  |  |  |  |  | x | x | x | x |  |  | x | x | x
Spreadsheet: 119049d1314173648-excel-2007-need-unique-vailue-using-multiple-criterias-book2
Sheet: Sheet5

Count of Col1 | Column Labels
Row Labels | ab | bc | Grand Total
w | 1 |  | 1
x | 2 | 1 | 3
y |  | 3 | 3
z | 1 |  | 1
Grand Total | 4 | 4 | 8
Spreadsheet: 215902d1361534800-drop-down-queries-drop_down_form
Sheet: Sheet2

TCFTD | Royal Mail Mail Item | Royal Mail Post Class | Big Book / Heavyweight Post Class | Royal Mail Sortation | TNT Mail Item | TNT Post Class | TNT Sortation | Mail house id
Royal Mail | Letter | Economy | 2 Weeks | High Sort | Letter | Economy | 1400 | 1
TNT | Large Letter | 2nd Class |  | [NAME] | Mechanical Letter |  | 120 | 2
 | A3 Packet | 1st Class |  | Low Sort CBC | Large Letter |  | 120 OCR | 3
 | Packet |  |  |  |  |  | 120 CBC | 4
 | Big Book |  |  |  |  |  |  | 5
 | Heavyweight |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | a
 |  |  |  |  |  |  |  | b
 |  |  |  |  |  |  |  | c
 |  |  |  |  |  |  |  | d
 |  |  |  |  |  |  |  | e
 |  |  |  |  |  |  |  | f
 |  |  |  |  |  |  |  | g
 |  |  |  |  |  |  |  | h
 |  |  |  |  |  |  |  | i
 |  |  |  |  |  |  |  | j
 |  |  |  |  |  |  |  | k
 |  |  |  |  |  |  |  | l
 |  |  |  |  |  |  |  | m
 |  |  |  |  |  |  |  | n
 |  |  |  |  |  |  |  | o
 |  |  |  |  |  |  |  | p
 |  |  |  |  |  |  |  | q
 |  |  |  |  |  |  |  | r
 |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  | t
 |  |  |  |  |  |  |  | u
 |  |  |  |  |  |  |  | v
 |  |  |  |  |  |  |  | w
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | y
 |  |  |  |  |  |  |  | z
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 13a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | - | 1048781 | 1048781
Europe | - | 483858 | 483858
North America/Asia | - | 564923 | 564923
Other | - | - | -
Index | 2066270 | 5323996 | 7390266
Asia | - | 114151 | 114151
Europe | 875064 | 2472479 | 3347543
North America | 1173458 | 2481360 | 3654818
Other | 17748 | 256006 | 273754
Other | - | 431878 | 431878
Exotic | - | 46405 | 46405
Swaptions | - | 385243 | 385243
Total Return Swap | - | 230 | 230
TOTAL | 2066270 | 6804655 | 8870925
Spreadsheet: 868234d1714981536-tier-incentive-will-be-automatically-calculated-based-on-tier-doctors-calculation-april-2024-allan-sampling-of-doing-formula-copy-1-aligw
Sheet: Dr. Nouf Al Saud

Contract Terms (*)
 |  | Description | Commission
 |  | Consultation | 0.5
 |  | Refferal | 0.1
 |  | Procedure in the Clinics (After deducting direct and indirect expenses + OHE 5%) | 0.4
 |  | OR in the Clinics (From Gross & After Revenue 200,000 50%) | 0.4
 |  | OR outside the Clinics (After deducting direct and indirect expenses + OHE 5%) | 0.6
Doctor Calculation
 |  | Gross Revenue | 0
 |  | Doctors Revenue | 0
 |  | Doctor Consultation Revenue | 0
 |  | OHE (5%)
 |  | Net Consultation Revenue | 0
 |  | Amount to be paid | 0
 |  | Refferal Revenue | 0
 |  | Amount to be paid
 |  | Procedure Revenue | 0
 |  | Consumables | 0
 |  | OHE (5%)
 |  | Net Consultation Revenue
 |  | Amount to be Paid
 |  | OR in the Clinic Doctor Revenue | 0
 |  | Less: Implant Consumables | 0
 |  | Less: J Plasma | 0
 |  | Net OR in the Clinic Doctor Revenue
 |  | Amount to be Paid
 |  | OR in the Clinic Doctor Revenue >200000 | 0
 |  | Less: J Plasma | 0
 |  | Net OR in the Clinic Doctor Revenue
 |  | Amount to be Paid
 |  | Net Amount to be Paid
 |  | OR outside the Clinics Revenue | 0
 |  | Hospital Fees
 |  | OHE 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | Less: Consumables ( Dr. [NAME] ) | 0
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | CFO: | .......................
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-11-30 00:00:00 |  | 1481856.66
 |  |  |  |  |  |  |  | Duke Energy Trading and Marketing, L.L.C.
2001-12-08 00:00:00 |  |  |  |  |  |  |  | OBA Balances as of 11/30/01
50895
60874
78169 |  |  |  |  |  |  |  | Contract# | Amount | Description/Points
500235 |  |  |  |  |  |  |  | 24361 |  | Pyote points - fuel is still being delivered causing amount to grow each month
500248 |  |  |  |  |  |  |  | 24693 | 275313.72 | [NAME] plant - hasn't had activity since 12/2000
500251 |  |  |  |  |  |  |  | 21665 | 73449.16 | no activity since 11/98
500254 |  |  |  |  |  |  |  | 22664 | 23612.35 | Grand Valley plant - last activity 4/96
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-11-30 00:00:00 |  | 275313.72
2001-12-08 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 357086 | 117857 | 173271
2001-11-30 00:00:00 |  | 811179.69
2001-12-08 00:00:00
500241
500391 | 1815
500392 | 349
Duke Energy Trading and Marketing
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36403
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
Spreadsheet: 814905d1674655364-using-cells-and-wildcards-to-determine-a-folder-and-file-location-in-a-formula-example
Sheet: Sheet1

Product | Client | Qty | Price | Invoice Amount | Book |  |  | Closing price
Bear | [NAME] | 1 | 100 |  | 15 |  |  | "=INDEX('C:\User\NGillham\Billboard\20230124\Location\market\[20230124_182305_LOC.csv]20230124_182305_LOC'!$I:$I,MATCH(1,(A6='C:\User\NGillham\Billboard\20230124\Location\market\[20230124_182305_LOC.csv]20230124_182305_LOC'!$C:$C)*(I1-1='C:\User\NGillham\Billboard\20230124\Location\market\[20230124_182305_LOC.csv]20230124_182305_LOC'!$F:$F),0))"
Bird | [NAME] | 5 | 20 |  | 21 |  |  | "=INDEX('C:\User\NGillham\Billboard\20230124\Location\market\[20230124_182305_LOC.csv]20230124_182305_LOC'!$I:$I,MATCH(1,(A7='C:\User\NGillham\Billboard\20230124\Location\market\[20230124_182305_LOC.csv]20230124_182305_LOC'!$C:$C)*(I$1-1='C:\User\NGillham\Billboard\20230124\Location\market\[20230124_182305_LOC.csv]20230124_182305_LOC'!$F:$F),0))"
Spreadsheet: 694884d1599855296-vlookup-not-working-sample
Sheet: Export 1

VLOOKUP | Date | Time | Home | Away |  | Vlookup
 | 2020-08-29 00:00:00 | 18:00:00 | Chateauroux | Auxerre |  |  |  | 1 | 01:02:00 | 01 | 2 |  | 0.43 | 0.22 | 0.35 |  | 0.25 | 0.52 | 0.23 |  | 0.83 | 0.58 | 0.29 |  | 0.32 | 0.26 | 0.42 |  | 1 | 0 | 0
 | 2020-08-29 00:00:00 | 14:00:00 | Caen | [NAME] |  |  |  | 0 | 01:00:00 | 01 | 0 |  | 0.34 | 0.33 | 0.33 |  | 0.35 | 0.37 | 0.28 |  | 0.67 | 0.39 | 0.2 |  | 0.2 | 0.4 | 0.4 |  | 0 | 0 | 0
 | 2020-08-29 00:00:00 | 18:00:00 | Dunkerque | [NAME] 63 |  |  |  | 0 | 01:01:00 | 01 | 1 |  | 0.27 | 0.47 | 0.26 |  | 0.24 | 0.56 | 0.2 |  | 0.72 | 0.41 | 0.27 |  | 0.13 | 0.56 | 0.31 |  | 0 | 0 | 0
 | 2020-08-29 00:00:00 | 14:00:00 | [NAME] | Guingamp |  |  |  | 1 | 02:02:00 | 02 | 2 |  | 0.46 | 0.28 | 0.26 |  | 0.33 | 0.41 | 0.26 |  | 0.67 | 0.45 | 0.19 |  | 0.35 | 0.34 | 0.31 |  | 0 | 0 | 0
Spreadsheet: 49090d1248358520-help-with-counting-number-of-unique-values-book1
Sheet: Sheet1

name | Territory |  | territory
[NAME] | 1 |  | 1 | 3
[NAME] | 1
[NAME] | 2
[NAME] | 2
George | 2
Igor | 3
[NAME] | 4
Fred | 1
[NAME] | 2
[NAME] | 1
Spreadsheet: 52684d1252519231-return-all-values-that-equal-0-book2
Sheet: Sheet1

75 | 1 | 1 |  | 75 | 43 | 90
60 | 0 | 0
55 | 0 | 0
43 | -1 | 2
90 | 1 | 3
10 | 0 | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: 770858d1646306057-check-values-in-one-column-against-a-fixed-value-then-change-value-in-another-column-example
Sheet: Sheet1

Column Title | Column Title | Column Title | Column Title | Column Title | Column Title | Column Title | Column Title | Column Title | Column Title | Column Title | Column Title | Column Title
101222 | Data | Data | Data | Data | Data | Data | Data | Data | Data | 0 | Data | Data | ABC1
ABC1 | Data | Data | Data | Data | Data | Data | Data | Data | Data | 1 | Data | Data | [NAME]
XYZ9 | Data | Data | Data | Data | Data | Data | Data | Data | Data | 1 | Data | Data
999111 | Data | Data | Data | Data | Data | Data | Data | Data | Data | 0 | Data | Data
[NAME] | Data | Data | Data | Data | Data | Data | Data | Data | Data | 1 | Data | Data
[NAME] | Data | Data | Data | Data | Data | Data | Data | Data | Data | 1 | Data | Data
Spreadsheet: 774001d1648152117-apply-filter-selections-across-different-tabs-example-2
Sheet: Category 1

Client (Parent) | Client (Site)  *indicates network | * | [NAME] | Manager | Contact | # Collections Category 1 | $ Collections Category 1 | Agreement | Start date | End date | Type | Next year Type | Collection 1 | Collection 2 | Collection 3 | Collection 4 | Collection 5 | Collection 6 | Collection 7 | Collection 8
Parent 1 | [NAME] | * | 150 | [NAME] | [NAME] | 1 | 50 | 1 | 2022-01-01 00:00:00 | 2023-01-01 00:00:00 | Standard | Standard | a | c | d | p | o | k | z | g
Parent 1 | Smithville blvd |  | 200 | [NAME] | [NAME] | 3 | 25 | 1 | 2022-01-02 00:00:00 | 2023-01-02 00:00:00 | Standard | Standard | n | b | l | p | o | k | z | g
Parent 2 | Coronado ave |  | 50 | [NAME] | [NAME] | 2 | 30 | 1 | 2022-01-03 00:00:00 | 2023-01-03 00:00:00 | Standard | Standard | a | b | l | h | o | k | z | g
Parent 2 | Lorne st |  | 45 | [NAME] | [NAME] | 1 | 20 | 1 | 2022-01-04 00:00:00 | 2023-01-04 00:00:00 | Standard | Standard | a | b | l | h | o | j | z | g
Parent 3 | [NAME] |  | 32 | [NAME] | [NAME] | 3 | 40 | 1 | 2022-01-05 00:00:00 | 2023-01-05 00:00:00 | Standard | Standard | n | b | d | h | o | j | z | x
Parent 3 | Purveyor St |  | 100 | [NAME] | [NAME] | 4 | 30 | 1 | 2022-01-06 00:00:00 | 2023-01-06 00:00:00 | Standard | Standard | n | c | d | h | o | k | z | x
Parent 4 | Fifth av |  | 25 | [NAME] | [NAME] | 2 | 10 | 1 | 2022-01-07 00:00:00 | 2023-01-07 00:00:00 | Standard | Standard | n | c | d | h | o | k | z | x
Parent 5 | Sixth av |  | 30 | [NAME] | [NAME] | 1 | 15 | 1 | 2022-01-08 00:00:00 | 2023-01-08 00:00:00 | Standard | Standard | n | c | d | h | o | k | z | x
Parent 5 | [NAME] |  | 20 | [NAME] | [NAME] | 3 | 20 | 1 | 2022-01-09 00:00:00 | 2023-01-09 00:00:00 | Standard | Standard | a | b | d | h | o | k | z | x
Spreadsheet: 72781d1273511035-how-to-retrieve-names-from-the-table-2-criteria-given-packaging
Sheet: MAIN

UNIT 2 PACKAGING KEY PERFORMANCE INDICATOR
 |  |  | SHIFT |  |  | SUPERVISOR |  |  |  |  |  | DATE | 2010-05-01 00:00:00 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | H | S | UNPD
 | PRODUCTS | TASKS |  |  |  |  |  |  |  | PROCESS CREDITS |  | STAFFING 4X4
 |  | COLOUR | CARAMEL | TOPPING | CUTTING | BOATING | PACKING | REWRAPING | [NAME] |  |  | HOLIDAYS | SICK | UNPAID LEAVE
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | name11 | name18 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | name4 | name14 |  | In this table I want to retrieve names of staff who are on holidays, off sick or on unpaid leave. All data is in the sheet named "staff"
 |  |  |  |  |  |  |  |  |  |  |  | name8
 |  |  |  |  |  |  |  |  |  |  |  | name12
 |  |  |  |  |  |  |  |  |  |  |  | STAFFING 8 HRS
 |  |  |  |  |  |  |  |  |  |  |  | HOLIDAYS | SICK | UNPAID LEAVE
 |  |  |  |  |  |  |  |  | TOTAL | 0
Spreadsheet: 678338d1589827491-why-am-i-losing-some-of-the-conditional-formatting-when-copying-the-sheet-to-a-new-wb-keeping-conditional-format
Sheet: MASTER

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23
Name 1 |  |  |  | 0.3895975900194893 | 210 | 970.7332758620689 | 268.1072857142857 | 80 | 7 | 0.03333333333333333 |  | Excellent | Excellent | 58 | 3 | 1 | 2 | 3 | 1 | 2 | 2
[NAME] |  |  |  | 0.3405146549900641 | 151 | 789.7170454545454 | 230.1162251655629 | 85 | 2 | 0.01324503311258278 |  | Excellent | Excellent | 44 | 2
[NAME] |  |  |  | 0.4496545246700048 | 217 | 1066.393650793651 | 309.5981566820276 | 97 | 2 | 0.009216589861751152 |  | Excellent | Excellent | 63 | 1
Spreadsheet: 525631d1498817508-help-needed-on-sorting-time-values-sample
Sheet: Sheet1

 | Desired Result |  | All days can be combined together as follow: |  |  |  |  | Day 1 |  | Day 2 |  | Day 3
 |  |  |  |  |  |  |  | 2017-06-12 09:15:00 |  | 2017-06-13 09:15:00 |  | 2017-06-14 09:15:00
 |  |  |  |  |  |  |  | 2017-06-12 13:10:27 |  | 2017-06-13 09:42:39 |  | 2017-06-14 09:25:14
 | 2017-06-12 15:30:00 |  |  |  |  |  |  | 2017-06-12 15:23:44 |  | 2017-06-13 14:08:34 |  | 2017-06-14 13:51:09
 |  |  |  |  |  |  |  | 2017-06-12 16:57:18 |  | 2017-06-13 15:28:40 |  | 2017-06-14 15:11:15
 |  |  |  |  |  |  |  | 2017-06-12 20:56:18 |  | 2017-06-13 17:02:14 |  | 2017-06-14 17:24:32
 |  |  |  |  |  |  |  | 2017-06-13 00:29:02 |  | 2017-06-13 21:01:14 |  | 2017-06-14 21:23:32
 | 2017-06-13 15:30:00 |  |  |  |  |  |  | 2017-06-13 04:41:29 |  | 2017-06-14 00:33:58 |  | 2017-06-15 00:56:16
 |  |  |  |  |  |  | In Col I,K & M, those are auto-generated time values, changing everyday
 |  |  |  |  |  |  | In col B, I am looking for time values in between 9:15 and 15:30 for every day
 | 2017-06-14 15:30:00 |  |  |  |  |  | Excluding 9:15 AND Including 15:30
 |  |  |  |  |  |  | It would be better if the result is without 'gaps'
Spreadsheet: 837164d1689891637-data-validation-drop-down-list-based-another-data-validation-drop-down-list-result-data-validation-drop-down-list-tms-v2
Sheet: Employees

EMPLOYEE | DEPARTMENT |  | Helper Columns
Employee #01 | Finance
Employee #02 | Finance |  | Floor
Employee #03 | Finance |  | HR
Employee #04 | Finance |  | Test
Employee #05 | Finance
Employee #06 | Finance
Employee #07 | HR
Employee #08 | HR
Employee #09 | HR
Employee #10 | HR
Employee #11 | HR
Employee #12 | HR
Employee #13 | HR
Employee #14 | Floor
Employee #15 | Floor
Employee #16 | Floor
Employee #17 | Floor
Employee #18 | Floor
Employee #19 | Floor
Employee #20 | Floor
Test Employee | Test
Spreadsheet: 765609d1643413009-insert-a-column-of-cells-based-on-a-simple-number-insert-a-block-of-cells-003
Sheet: Sheet1

F1 | F |  | D1 | E1 | F1 | [NAME]
F2 | D |  | D2 | E2 | F2 | G2
F3 | G |  | D3 |  | F3 | G3
F4 | D |  |  |  | F4 | G4
F5 | F |  |  |  | F5
[NAME] | G
G2 | E
G3 | E
G4 | F
E1 | E
E2 | D
[NAME] | G
G2 | E | THIS IS HOW I LAY OUT MY JOB SPREADSHEETS TO COMPILE THE DATA INTO COLUMN A,
G3 | F | I HAVE SIMPLIFIED THE SHEET TO FOCUS ON THE PROGRAMMING PROBLEM AND NOT CLUTTER THE EXAMPLE WITH RANDOM LETTER GENERATION.
G4 | D | I HAVE BEEN DOING COPY AND PASTE TO GET THE DATA NEEDED, COMPILED INTO A SINGLE COLUMN.
D1 | D | COLUMN B IS RANDOMLY GENERATED LETTERS THAT I USE TO DETERMINE THE NEXT DATA SET USED.
D2 | E | THESE DATA SETS ARE FOR ILLUSTRATION ONLY.
D3 | G | THE PROPRIETARY DATA SETS ARE AS SHORT AS 7 CELLS AND AS LONG AS HUNDEREDS OF CELLS.
[NAME] | G | THIS MAKES COPY AND PASTE CUMBERSOME, ESPECIALLY WHEN COLUMN A IS USUALLY HUNDREDS OF SEQUENTIAL DATA SETS.
G2 | D
G3 | E
G4 | E
F1 | F
F2 | G
F3 | D
F4 | F
F5 | E
 | D | IF CELL "A28" IS EMPTY, THEN DATA FROM COLUMN D IS TO START HERE
 | G | NOTICE THAT THE RANDOM LETTER D IN CELL "B28" IS THE REFERENCE FOR SELECTING COLUMN D AS THE NEXT DATA SET.
 | E | AT A MINIMUM, IT WOULD SPEED UP WORK FLOW IF I COULD ENTER A FUNCTON IN "A28" THAT WOULD INSERT COLUMN D
 | E | IT WOULD BE OPTIMAL IF THIS EMPTY CELL TRIGGERED INSERT COLUMN D
 | F | COLUMN B IS RANDOMLY GENERATED. EMPTY CELL "A28" AND RANDOM REFERENCE "B28" WOULD THEN TRIGGER INSERT COLUMN D.
 | E | IT WOULD BE OPTIMAL IF COLUMN B IS NUMBERS, BUT I CAN WORK WITH LETTERS. I KNOW HOW TO PROGRAM BOTH.
 | D | COLUMN A IS REFERENCED IN ANOTHER PROGRAM, SO ALL I NEED THIS PROGRAM TO DO IS COMPILE THE RANDOM PLACEMENT OF DATA IN COLUMN A.
 | G | I NEED TO UNDERSTAND THE PROGRAM FOR DIFFERENT JOBS WITH DIFFERENT QUANTITIES OF REFERENCE COLUMNS (D,E,F,G IN THIS EXAMPLE).
 | F | EACH JOB HAS IT'S OWN UNIQUE SET OF DATA SEQUENCES.
 | D
 | D
 | E
 | G
Spreadsheet: 6ce61564-bbce-49ef-ad38-08838c604569
Sheet: Sheet1

AQR Risk-Balanced Commodities Strategy Fund | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
2014-01-31 00:00:00
[NAME]
NAV: $31,202,527
Asset Class | Security Description | Exposure | Quantity
Commodity | Brent Oil Future | 5479240 | 52
Commodity | Cocoa Future | 640420 | 22
Commodity | Coffee Future | 2582250 | 55
Commodity | Corn Future | 4856475 | 221
Commodity | Cotton No. 2 Future | 1029960 | 24
Commodity | Gas Oil Future (100MT) | 1813000 | 20
Commodity | Gold Future | 1983680 | 16
Commodity | Heating Oil ULSD Future | 863095.8 | 7
Commodity | Lead Future | 476325 | 9
Commodity | Lean Hog Future | 1820160 | 48
Commodity | Live Cattle Future | 3707220 | 66
Commodity | LME Aluminum | 2592750 | 60
Commodity | LME Copper | 7055250 | 40
Commodity | Natural Gas Future | 2583320 | 58
Commodity | Nickel Future | 672048 | 8
Commodity | Silver Future | 3537200 | 37
Commodity | Soy Meal Future | 1193080 | 28
Commodity | Soy Oil Future | 2687496 | 119
Commodity | Soybean Future | 3678650 | 58
Commodity | Sugar Future | 801136 | 46
Commodity | Unleaded Gas RBOB Future | -1536061.8 | -13
Commodity | Wheat Future | -197337.5 | -7
Commodity | WTI Crude Future | 6189440 | 64
Commodity | Zinc Future | 2124200 | 43
Spreadsheet: 823130d1679728966-lookup-multiple-values-from-a-table-cmms-etaf
Sheet: Drill Drop Downs

 | TblEquipCat
 | [NAME]
 | Light Vehicle
 | [NAME]
 | [NAME]
 | Water Truck
 | TblServiceSizes
 | 250
 | 500
 | 750
 | 1000
 | 1250
 | 1500
 | 1750
 | 2000
 | TblComponentLife
 | Carousel
 | Compressor
 | [NAME]
 | Engine
 | [NAME]
 | Final Drive - CS
 | Final Drive - OCS
 | Final Drive Motor - CS
 | Final Drive Motor - OCS
 | Func Box
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Pump - Auxillary
 | Pump - Charge
 | Pump - Feed
 | Pump - Rotation
 | Ropes - Hoist
 | Ropes - Pulldown
 | Rotary Head
 | [NAME]
 | [NAME]
 | TblDrillNumbers
 | P55
Spreadsheet: 828454d1683523852-help-with-a-formula-to-calculate-employees-productivity-bonus-bonus-sample-aligw
Sheet: Sheet1

 | Performace Bonus Employee A
 | Day | Actual (minutes) | Standard (minutes) | %
 | Mon | 360.25 | 525.25
 | Tue | 400.25 | 511.12
 | Wed | 360.25 | 547.23
 | Thu | 389.45 | 410.36
 | Fri | 325.25 | 442.25
 | Total
 | Total Actual  [NAME]
 | Bonus paid
Spreadsheet: 863678d1711087594-converting-model-data-table-simulation-5-1-
Sheet: Sheet10

Table 1 |  |  |  |  |  |  |  |  | Table 2 |  |  |  | Answer Table 2
Name | Item 1 | Item 2 | Item 3 | Item 4 | Total items due date on march 2024 | answer |  |  | Name | Item Type | Due date |  | Name | Item Type | Due date |  | Name | Item Type | Due date
a | 2024-03-19 00:00:00 |  |  |  |  | 1 |  |  |  |  |  |  | a | Item 1 | 2024-03-19 00:00:00
b |  | 2024-03-19 00:00:00 | 2024-03-30 00:00:00 |  |  | 2 |  |  |  |  |  |  | b | Item 2 | 2024-03-19 00:00:00
c | 2024-01-30 00:00:00 | 2024-03-12 00:00:00 |  |  |  | 1 |  |  |  |  |  |  | b | Item 3 | 2024-03-30 00:00:00
d |  |  |  |  |  | 0 |  |  |  |  |  |  | c | Item 1 | 2024-01-30 00:00:00
e |  |  | 2024-06-30 00:00:00 |  |  | 0 |  |  |  |  |  |  | c | Item 2 | 2024-03-12 00:00:00
f |  | 2024-06-30 00:00:00 | 2024-07-12 00:00:00 |  |  | 0 |  |  |  |  |  |  | e | Item 3 | 2024-06-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | f | Item 2 | 2024-06-30 00:00:00
Notes |  |  |  |  |  |  |  |  |  |  |  |  | f | Item 3 | 2024-07-12 00:00:00
every name has 4 items
every items has its own due date
count items that has due date on march 2024
convert table type from table 1 to table 2
Spreadsheet: 844785d1696464620-salary-calculation-untitled-spreadsheet-4-
Sheet: Sheet1

Employee | Start Date | End Date | Annual Salary | 2024-02-28 00:00:00
A | 2024-03-05 00:00:00 |  | 260000
B | 2024-03-15 00:00:00 | 2024-11-25 00:00:00 | 230000
C | 2024-02-15 00:00:00 |  | 230000
Spreadsheet: 462972d1464261213-lookup-formula-with-more-than-2-criteria-lookup-with-more-than-2-criteria
Sheet: Planned

 |  |  |  |  |  |  |  |  | PLANNED | PLANNED | PLANNED |  | PLANNED
 | Category |  | Full Year 2015 |  | 2016-01-15 00:00:00 |  | [NAME] |  | 2016-01-15 00:00:00 |  |  |  | Q1 2016
 | Current Assets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual
 | Cash |  | 0 |  |  |  |  |  | 500 | 400 | 250 |  |  |  |  | 2016-01-15 00:00:00 | Planned
 | Bank of America Checking |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Bank of America Payroll |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | [NAME] |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | Q1 2016
 | Petty Cash |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Union Bank |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Union Bank- Operations |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Union Bank- Payroll |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | Q2 2016
 | Union Bank- Recurring Payments |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Bank of the West- Operations |  | 0 |  | 0 |  |  |  | 0 | 0 | 0