tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 02ab5fe2-f3b1-4d60-9f43-d9885a6e0a19
Sheet: Sheet1

 |  | IMPERIAL VALLEY COLLEGE
 |  | MEN'S BASKETBALL SCHEDULE
 |  | 2013 - 2014
DAY |  | DATE | OPPONENT |  |  | PLACE | TIME
TUES |  | OCT 29 | RED/WHITE SCRIMMAGE & BBQ SOCIAL |  |  | IVC | 18:00:00
THURS-SAT |  | NOV 7-9 | DESERT TOURNAMENT |  |  | Palm Desert | TBA
SAT |  | NOV 16 | LONG BEACH CITY COLLEGE |  |  | IVC | 15:00:00
THURS-SAT |  | NOV 21-23 | IRVINE VALLEY TOURNAMENT |  |  | [NAME] | TBA
FRI-SUN |  | DEC 6-8 | MT. SAC TOURNAMENT |  |  | Mt Sac | TBA
FRI-SAT |  | DEC 13-14 | LA SOUTHWEST TOURNAMENT |  |  | LA SOUTH | TBA
FRI-SUN |  | DEC 27-29 | IMPERIAL VALLEY HOLIDAY CLASSIC |  |  | IVC | 19:00:00
WED |  | JAN 8 | *# SAN DIEGO MESA COLLEGE |  |  | IVC | 19:00:00
FRI |  | JAN 10 | *SOUTHWESTERN COLLEGE |  |  | IVC | 19:00:00
WED |  | JAN 15 | BYE
FRI |  | JAN 17 | *SAN DIEGO CITY COLLEGE |  |  | SDCC | 17:00:00
WED |  | JAN 22 | *CUYAMACA COLLEGE |  |  | CC | 17:00:00
FRI |  | JAN 24 | * MIRAMAR COLLEGE |  |  | IVC | 19:00:00
WED |  | JAN 29 | *MT. SAN JACINTO COLLEGE |  |  | MSJC | 19:00:00
FRI |  | JAN 31 | *GROSSMONT COLLEGE |  |  | GC | 17:00:00
WED |  | FEB 5 | *# MIRA COSTA COLLEGE |  |  | IVC | 17:00:00
FRI |  | FEB 7 | * SAN DIEGO MESA COLLEGE |  |  | SDMC | 17:00:00
WED |  | FEB 12 | *SOUTHWESTERN COLLEGE |  |  | SW | 17:00:00
FRI |  | FEB 14 | *PALOMAR COLLEGE |  |  | IVC | 19:00:00
WED |  | FEB 19 | *#SAN DIEGO CITY COLLEGE |  |  | IVC | 17:00:00
FRI |  | FEB 21 | *CUYAMACA COLLEGE |  |  | IVC | 19:00:00
WED |  | FEB 26 | PLAY-IN ROUND |  |  | TBA | TBA
FRI-SAT |  | FEB 28-MAR 1 | REGIONAL PLAYOFFS 1ST RD |  |  | TBA | TBA
WED |  | MAR 5 | REGIONAL PLAYOFFS 2ND RD |  |  | TBA | TBA
SAT |  | MAR 8 | REGIONAL PLAYOFFS 3RD RD |  |  | TBA | TBA
FRI-SUN |  | MAR 14-16 | STATE FINAL 4 |  |  | CERRITOS | TBA
Head Coach: [NAME] |  |  | (760) 355 - 6167 | Athletic Director: [NAME] |  |  | (760) 355-6341
Assistant Coach: |  | [NAME] | (760) 355 - 6570 | Athletic Trainer: [NAME] Mays |  |  | (760) 355-6329
Assistant Coach: |  | [NAME] | (760) 355 - 6570 | Athletic Secretary: [NAME] |  |  | (760) 355-6325
Assistant Coach: |  | [NAME] | (760) 355 - 6570
* Denotes Conference Games
# Denotes Double Headers
 |  |  |  |  |  |  | Updated 11/12/13
Spreadsheet: 125839d1319252208-excel-2007-copy-formula-in-consequent-rows-with-data-from-a-column-summary-tables-testing
Sheet: meeting 1

 | ACRONYM | [NAME] | No. OF DOCS |  | TOTAL ATTENDANCE: |  | 4 |  | TOTAL No. OF DOCS: |  | 4
1 | name 1 | A | 1
2 | name 2
3 | name 3 | A
4 | name 4
5 | name 5
6 | name 6 |  | 1
7 | name 7 | A
8 | name 8
9 | name 9
10 | name 10
11 | name 11
12 | name 12
13 | name 13
14 | name 14
15 | name 15
16 | name 16
17 | name 17
18 | name 18
19 | name 19
20 | name 20 |  | 2
21 | name 21
22 | name 22
23 | name 23 | A
24 | name 24
25 | name 25
26 | name 26
Spreadsheet: 48997d1248280103-time-calculation-example
Sheet: Sheet1

Month | Date | Amount of Users | Days Taken | Time Taken | TOTAL
6 | 2009-06-01 00:00:00 | 1 | 1 | 10:32:01 | 1 Day(s) 10:32:01
7 | 2009-07-01 00:00:00 | 5 | 2 | 12:30:00 | 12 Day(s) 14:30:00
7 | 2009-07-02 00:00:00 | 12 | 3 | 16:00:00 | 44 Day(s) [NAME]
7 | 2009-07-13 00:00:00 | 7 | 1 | 23:59:00 | 13 Day(s) 23:53:00
7 | 2009-07-14 00:00:00 | 5 | 0 | 05:00:00 | 1 Day(s) [NAME]
Spreadsheet: 793817d1661758460-formula-to-consider-first-value-of-multiple-same-values-edit-formula-to-get-match-hd
Sheet: Exp. Result in Remarks column

Line | As per | [NAME] | X | Invoice number | Date | IGST | CGST | SGST | EXACT MATCH CEFGHI | EXACT MATCH CEGHI | EXACT MATCH CGHI | APPROXIMATE MATCH CEFGHI | APPROXIMATE MATCH CEGHI | APPROXIMATE MATCH CGHI
7 | PORTAL | 29XXXTB0431R1XD |  | 78910 | 2019-05-22 00:00:00 |  | 100 | 100 |  |  |  |  |  |  |  | Solved by [NAME]
8 | PORTAL | 29XXXTB0431R1XD |  | 12355 | 2019-06-07 00:00:00 |  | 110 | 110
15 | TALLY | 29XXXTB0431R1XD |  | 12355 | 2019-06-07 00:00:00 |  | 110 | 110
17 | TALLY | 29XXXTB0431R1XD |  | 78910 | 2019-05-22 00:00:00 |  | 100 | 100
3 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001163 | 2019-06-05 00:00:00 | 660
4 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001164 | 2019-06-05 00:00:00 | 900
6 | PORTAL | 29XXXTB0431R1XD |  | 10012345 | 2019-06-05 00:00:00 |  | 450 | 450
12 | TALLY | 07XXXTB0431R1XD |  | 2019000893 | 2019-05-22 00:00:00 | 660
13 | TALLY | 07XXXTB0431R1XD |  | 2019001163 | 2019-06-05 00:00:00 | 900
14 | TALLY | 29XXXTB0431R1XD |  | 12345 | 2019-06-06 00:00:00 |  | 450 | 450
9 | PORTAL | 29XXXTB0431R1XD |  | 12356 | 2019-06-09 00:00:00 |  | 130 | 130
16 | TALLY | 29XXXTB0431R1XD |  | 12356 | 2019-06-08 00:00:00 |  | 129.75 | 129.75
2 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001162 | 2019-06-05 00:00:00 | 999
10 | TALLY | 07XXXTB0431R1XD |  |  | 2019-06-05 00:00:00 | 899
11 | TALLY | 07XXXTB0431R1XD |  | 2019001162 | 2019-06-05 00:00:00 | 998.5
5 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001169 | 2019-06-05 00:00:00 | 1000
1 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019000893 | 2019-05-22 00:00:00 | 899.5
132 | PORTAL | 27DREPK9227D1ZQ |  | 2021-22464 | 14-04-2019 | 15.24
471 | TALLY | 27DREPK9227D1ZQ |  | 464 | 14-04-2019 | 15.24
733 | TALLY | 27DREPK9227D1ZQ |  | 3402 | 11-07-2019 | 15.24
1258 | PORTAL | 23ABCDK9227D1ZQ |  | 2019-20 /1234 | 2019-06-05 00:00:00 | 222
2158 | PORTAL | 23ABCDK9227D1ZQ |  | 2019-20 /1235 | 2019-06-05 00:00:00 | 222
2133 | TALLY | 23ABCDK9227D1ZQ |  | 234 | 2019-06-05 00:00:00 | 222
 |  |  | The cells colored as yellow should display blank.
Spreadsheet: phillip_m_love__30020__STORAGE
Sheet: December 2000 GulfCoast   

NGPL GULF COAST STORAGE
 | 1.70% for fuel
 | K#114786  MAX MDQ=18,283 |  |  |  |  | K#114846  MAX MDQ=13,333
 | LA Injection | LA Withdrawl | STX Injection | STX Withdrawl |  | LA Injection | LA Withdrawl | STX Injection | STX Withdrawl | [NAME]
 |  | December |  | December |  |  | December |  | December
Beg Balance | 0 |  | 0 |  |  |  | 489334
2000-12-01 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -15 | 0 | -3118
2000-12-02 00:00:00 | 0 | -8884 | 0 | -9399 | 0 | 0 | -15 | 0 | -3118 | 0
2000-12-03 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -15 | 0 | -3118
2000-12-04 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -15 | 0 | -3118
2000-12-05 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -5884 | 0 | -3118
2000-12-06 00:00:00 | 0 | 0 | 0 | -9399 | 0 |  | 0 | 0 | -3118
2000-12-07 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -1343 | 0 | -3118
2000-12-08 00:00:00 | 0 | -8064 | 0 | -9399 | 0 |  | 0 | 0 | -3118
2000-12-09 00:00:00 | 0 | -8064 | 0 | -9399 | 0 |  | 0 | 0 | -3118
2000-12-10 00:00:00 | 0 | -8064 | 0 | -9399 | 0 |  | 0 | 0 | -3118
2000-12-11 00:00:00 | 0 | -8064 | 0 | -9399 | 0 |  | 0 | 0 | -3118
2000-12-12 00:00:00 | 0 | -5564 | 0 | -9399 | 0 |  | 0 | 0 | -3118
2000-12-13 00:00:00 | 0 | 0 | 0 | -17462 | 0 |  | -9900 | 0 | -3118
2000-12-14 00:00:00 | 17972 | 0 | 0 | -11978 | 0 | 3591 | 0 | 0 | 0 | 0
2000-12-15 00:00:00 | 0 | 0 | 0 | -12517 | 0 |  | -8064 | 0 | 0
2000-12-16 00:00:00 | 0 | 0 | 0 | -12517 | 0 |  | -8064 | 0 | 0
2000-12-17 00:00:00 | 0 | 0 | 0 | -12517 | 0 |  | -8064 | 0 | 0
2000-12-18 00:00:00 | 0 | 0 | 0 | -12517 | 0 |  | -8064 | 0 | 0
2000-12-19 00:00:00 | 0 | 0 | 0 | -12517 | 0 |  | -8064 | 0 | 0
2000-12-20 00:00:00 | 0 | -5064 | 0 | -221 | 0 | . | 0 | 0 | -12296 | 1525
2000-12-21 00:00:00 | 0 | -7973 | 0 | 0 | 0 |  | 0 | 0 | -12478
2000-12-22 00:00:00 | 0 | -3367 | 0 | 0 | 0 |  | 0 | 0 | -13333
2000-12-23 00:00:00 | 0 | -8080 | 0 | 0 | 0 |  | 0 | 0 | -12357
2000-12-24 00:00:00 | 0 | -8080 | 0 | 0 | 0 |  | 0 | 0 | -12357
2000-12-25 00:00:00 | 0 | -8080 | 0 | 0 | 0 |  | 0 | 0 | -12357
2000-12-26 00:00:00 | 0 | -8080 | 0 | 0 | 0 |  | 0 | 0 | -12357
2000-12-27 00:00:00 | 0 | -8229 | 0 | 0 | 0 |  | 0 | 0 | -12357
2000-12-28 00:00:00 | 0 | -8229 | 0 | 0 | 0 |  | 0 | 0 | -12357 | 4915
2000-12-29 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
2000-12-30 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
2000-12-31 00:00:00 | 0 |  |  | 0 |  | 0 |  |  |  | 0
Net Withdrawl/Injection
Ending Balance
Diff Stor Bal & MWQ
Total Combined Balance
Spreadsheet: 751534d1634158210-set-up-multiple-if-conditions-misc-etaf
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Expected Result | Column10 | Column11 | Column12 | Column13 | Column14
 |  |  |  |  | 2021-10-01 00:00:00 | 2021-10-02 00:00:00 |  | Yes
 |  |  |  |  |  | 2021-10-03 00:00:00 |  | No
 |  |  |  |  | 2021-10-03 00:00:00 | 2021-10-04 00:00:00 |  | Yes
 |  |  |  |  | 2021-10-04 00:00:00 |  |  | Yes
 |  |  |  |  | 2021-10-05 00:00:00 |  |  | Yes
 |  |  |  |  | 2021-10-06 00:00:00 |  |  | Yes
 |  |  |  |  |  |  |  | Blank
 |  |  | 1. The column to stay blank with no text in it if both Columns F and G are left blank. 2. For it give me an output of "Yes" if something is written in Column F. 3. For the output to give me a "No" if [NAME] is blank but something is written in Column G.
Spreadsheet: 678651d1589993791-product-sum-with-itemcodes-2020-05-20-oeldere-sealpino-678644d1589992007-product-sum-with-itemcodes-productsum
Sheet: Blad1

 |  |  |  |  |  |  | RESULT | RESULT
 |  | List of variables |  |  |  |  | CODE | CODE | CODE
 |  | Value | Code |  |  |  | 3000 | 4000 | 5000
 |  | 100 | 3000 |  |  |  | 600 | 900 | 200
 |  | 400 | 4000
 |  | 500 | 4000 |  |  |  | Summarize item values with certain code!
 |  | 500 | 3000
 |  | 200 | 5000
 |  |  |  |  |  |  |  | Kolomlabels
 |  |  |  |  |  |  |  | 3000 | 4000 | 5000 | Eindtotaal
 |  |  |  |  |  |  | Som van Value | 600 | 900 | 200 | 1700
I want to accumulate item values with certain codes.
Each line has an item code for example 4000.
Each line has a value. I want to add those!
Spreadsheet: 12b0dd05-3d9d-42b8-93b3-e55b50b198be
Sheet: Page 12

 | Insurance Premium Taxes - By Source of Tax 1
 | ($ thousands)
 | Source of Tax |  |  |  | 2009-10 |  | 2010-11 |  | 2011-12
 | Domestic Casualty 2 |  |  |  | 2718.89375 |  | 40005.31273 |  | 7660.52025
 | Domestic Casualty - Accelerated |  |  |  | 89405.091 |  | 55232.901 |  | 93959.706
 | Domestic Life & Previously Exempt Lines |  |  |  | 15918.31058 |  | 12908.7491 |  | 26661.05228
 | Domestic Life - Accelerated |  |  |  | 62879.6232 |  | 50605.3751 |  | 50472.88901
 | Domestic Fire 3 |  |  |  | -2318.46176 |  | 4970.22799 |  | 5513.57998
 | Domestic Fire - Accelerated |  |  |  | 20212.939 |  | 17115.14646 |  | 21818.519
 | Marine Insurance |  |  |  | 337.88688 |  | 415.318 |  | 120.63699
 | Foreign Casualty (Payable to Municipal Pension Aid Fund) |  |  |  | 212700.6705 |  | 342605.16939 |  | 227931.97577
 | Excess Foreign Casualty |  |  |  | 4428.27406 |  | 5744.37733 |  | 12091.83016
 | Foreign Life |  |  |  | 78166.15248 |  | 87934.3447 |  | 27225.78807
 | Foreign Life - Accelerated |  |  |  | 154033.1413 |  | 116127.22867 |  | 170876.62246
 | Foreign Fire (Payable to Fire Insurance Tax Fund) |  |  |  | 88949.90724 |  | 138342.30026 |  | 78422.35138
 | Excess Foreign Fire |  |  |  | 1540.91862 |  | 1536.39724 |  | 8585.899589999999
 | Foreign Title Insurance |  |  |  | 1885.67925 |  | 2102.27305 |  | 928.262
 | Foreign Title Insurance - Accelerated |  |  |  | 3457.43755 |  | 2919.6345 |  | 5329.50207
 | Unauthorized Insurance |  |  |  | 6040.1435 |  | 8978.079800000001 |  | 9219.70039
 | Excess Insurance Brokers |  |  |  | 20822.30168 |  | 21998.94688 |  | 17944.03637
 | Total |  |  |  | 761178.9088300002 |  | 909541.7821999998 |  | 764762.8717700001
1The total deposits are correct.  However, due to uncertainty about the validity of recorded revenue codes for the corporations making payments, an unknown amount of distortion may be present in the distributed data.
2 Beginnning in fiscal year 2000-01, the Domestic Casualty revenue code is reduced by the transfer of Pennsylvania Property and Casualty Insurance Guaranty Association (PIGA) credits to the Municipal Pension Aid Fund.
3 Beginning in fiscal year 2000-01, the Domestic Fire revenue code is reduced by the transfer of PIGA credits to the Fire Insurance Tax Fund.
Spreadsheet: 879644d1727208231-conditional-format-not-working-and-giving-me-a-headache-vdc-coordination-schedule-template
Sheet: NonWorkDays

Non-Work Days |  |  |  | Add dates to this list to highlight them in the gantt chart.
Date | Reason | Date | Holiday
1900-01-01 00:00:00 |  |  |  | ◄ Leave this row as-is. You can insert rows below it.
2024-01-06 00:00:00 | Saturday
2024-01-07 00:00:00 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
2024-12-25 00:00:00 | Christmas Day
 | Saturday
 | Sunday
2024-12-25 00:00:00 | New Years Day
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
 | Sunday
 | Saturday
Spreadsheet: 856009d1705419315-return-a-calculated-value-thats-based-on-shift-worked-during-a-month-ef1622_shift_allowances
Sheet: Sheet1

DayNum | Day | Date | Human 1 | Human 2 | Human 3 | Human 4 | Human 5 | Human 6 | Human 7 | Human 8 | Human 9 | Human 10 |  |  | Day of the Week | Shift Allowance Hours
 | Monday | 2024-01-01 00:00:00 | N | E | L | L | E | E | X | X | X | X |  |  | WkDay Early | 2
 | Tuesday | 2024-01-02 00:00:00 | N | N | L | L | E | E | X | X | X | X |  |  | WkDay Late | 4
 | Wednesday | 2024-01-03 00:00:00 | X | N | N | X | L | L | E | E | D | X |  |  | [NAME] | 9
 | Thursday | 2024-01-04 00:00:00 | X | N | N | X | L | L | E | E | D | X |  |  | WkEnd Early 1 | 2
 | Friday | 2024-01-05 00:00:00 | X | X | X | X | N | N | L | L | E | E |  |  | WkEnd Early 2 | 5
 | Saturday | 2024-01-06 00:00:00 | X | X | X | X | N | N | L | L | E | E |  |  | WkEnd Late 1 | 4
 | Sunday | 2024-01-07 00:00:00 | E | X | X | E | X | X | N | N | L | L |  |  | WkEnd Late 2 | 4
 | Monday | 2024-01-08 00:00:00 | E | X | X | E | X | X | N | N | D | L |  |  | [NAME] | 9
 | Tuesday | 2024-01-09 00:00:00 | L | L | E | E | X | X | X | X | D | N
 | Wednesday | 2024-01-10 00:00:00 | L | L | E | E | X | X | X | X | D | N
 | Thursday | 2024-01-11 00:00:00 | N | N | L | L | E | E | X | X | X | X |  |  | Example Output for the Month
 | Friday | 2024-01-12 00:00:00 | N | N | L | L | E | E | X | X | X | X |  |  | Shift Allowance | Human 1 | Human 2 | Human 3 | Human 4 | Human 5 | Human 6 | Human 7 | Human 8 | Human 9 | Human 10
 | Saturday | 2024-01-13 00:00:00 | X | N | N | X | L | L | E | E | X | X |  | E | WkDay Early
 | Sunday | 2024-01-14 00:00:00 | X | N | N | X | L | L | E | E | X | X |  | L | WkDay Late
 | Monday | 2024-01-15 00:00:00 | X | X | X | X | N | N | L | L | E | E |  | N | [NAME]
 | Tuesday | 2024-01-16 00:00:00 | X | X | X | X | N | N | L | L | E | E |  | E | WkEnd Early 1
 | Wednesday | 2024-01-17 00:00:00 | E | X | X | E | X | X | N | L | L | L |  | E | WkEnd Early 2
 | Thursday | 2024-01-18 00:00:00 | E | X | X | E | X | X | N | L | L | L |  | L | WkEnd Late 1
 | Friday | 2024-01-19 00:00:00 | L | L | E | E | X | X | X | X | N | N |  | L | WkEnd Late 2
 | Saturday | 2024-01-20 00:00:00 | L | L | E | E | X | X | X | X | N | N |  | N | [NAME]
 | Sunday | 2024-01-21 00:00:00 | N | N | L | L | E | E | X | X | X | X
 | Monday | 2024-01-22 00:00:00 | N | N | L | L | E | E | X | X | D | X
 | Tuesday | 2024-01-23 00:00:00 | X | N | N | X | L | L | E | E | D | X
 | Wednesday | 2024-01-24 00:00:00 | X | N | N | X | L | L | E | E | D | X
 | Thursday | 2024-01-25 00:00:00 | X | X | X | L | N | N | L | L | D | E
 | Friday | 2024-01-26 00:00:00 | X | X | X | E | N | N | L | L | D | L
 | Saturday | 2024-01-27 00:00:00 | E | X | X | E | X | X | N | N | L | L
 | Sunday | 2024-01-28 00:00:00 | E | X | X | E | X | X | N | N | L | L
 | Monday | 2024-01-29 00:00:00 | L | L | E | E | X | X | X | X | D | N
 | Tuesday | 2024-01-30 00:00:00 | L | L | E | E | X | X | X | X | D | N
 | Wednesday | 2024-01-31 00:00:00 | N | N | L | L | E | E | X | X | D | X
Spreadsheet: 686420d1594616003-inventory-control-last-hl
Sheet: Daily Balance

Date |  | 2020-06-06 00:00:00
S/N | M&N | S&T | First Move Type | First Move Date | Last Move Type | Last Move Date | Last destination (Yard) | Days In last destination (Yard)
 | HAMU 1298403 | 40 HC | Gate In | 2020-06-06 00:00:00 | Transport | 2020-06-06 00:00:00 | ACHC | 1
 | FSCU 7772134 | 20 DRY | Gate In | 2019-11-13 00:00:00 | Transport | 2019-11-14 00:00:00 | Yard4 | 206
Spreadsheet: 56783d1256876688-excel-2007-comparing-cells-to-find-best-results-monthly-report-test
Sheet: Monthly Review

 |  |  | Monthly  Percentages
 | Technician |  |  |  | Work Comp % | QC Pass % | Activation Server % | VOD %
 | 1 | [NAME]
 | 2 | [NAME]
 | 3 | [NAME]
 | 4 | [NAME]
 | 5 | [NAME]
 | 6 | [NAME]
 | 7 | [NAME]
 | 8 | [NAME]
 | 9 | [NAME]
 | 10 | [NAME]
 | 11 | [NAME]
 | 12 | [NAME]
 | 13 | [NAME]
 | 14 | [NAME]
 | 15 | [NAME]
 | 16 | [NAME]
 | 17 | [NAME]
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
Spreadsheet: 692760d1598542417-finding-the-biggest-value-in-a-custom-list-example
Sheet: Blad1

 | 6a+ | medium | 2020-04-10 00:00:00
 | 6c | large | 2020-04-11 00:00:00 |  |  |  | find biggest value:
 | 7b | large | 2020-04-12 00:00:00 |  |  |  | find biggest if large:
 | 8a | large | 2020-04-13 00:00:00 |  |  |  | find second biggest value:
 | 6b+ | medium | 2020-04-14 00:00:00 |  |  |  | find second biggest if large:
 | 7c+ | large | 2020-04-15 00:00:00 |  |  |  | find third biggest value:
 | 4a | small | 2020-04-16 00:00:00 |  |  |  | find third biggest value if large:
 | 7c | large | 2020-04-17 00:00:00
 | 8b | small | 2020-04-18 00:00:00
Spreadsheet: 787230d1657700624-index-match-multple-criterai-eh_index-match-master
Sheet: Sheet1

Ticket | Date | Summary | Type | Sub Type | Clients Affected | Owner | The Rep | Unit | Internal | Display | ID | Status
123 | 2021-05-14 00:00:00 | Analaysis | Thing |  | Ssis | Ray | Mark | MFP |  |  |  | On Hold
344 | 2021-12-20 00:00:00 | Analysis | Thing |  | [NAME] | [NAME] | [NAME] | MFP |  |  |  | On Hold
455 | 2022-05-17 00:00:00 | New block | Block |  | 7 station | [NAME] | Matty | MFP | rff |  |  | Assigned
12 | 2022-05-17 00:00:00 | New thing | Thing |  | 7 station | Ray | Hero | MFP |  |  |  | Assigned
134 | 2022-04-20 00:00:00 | New block | Block |  | ABR | Ray | Lond | MFP |  |  |  | Assigned
244 | 2022-04-29 00:00:00 | New block | Block |  | ABD | Ray | Lond | MFP | ABR | Cheese Sector | 163 | Awaiting Permissions
144 | 2022-05-27 00:00:00 | New thig | Thing |  | ABR | Ray | Lor | MFP |  |  |  | Awaiting Feedback
Spreadsheet: 828501d1683557137-combine-duplicate-rows-and-empty-columns-sample
Sheet: Sheet1

 | COL 1 | COL 2 | COL 3 |  |  | COL 1 | COL 2 | COL 3
Company 1 | A |  |  |  | Company 1 | A | B | C
Company 1 |  | B
Company 1 |  |  | C
Company 2 |  |  | C |  | Company 2 | A | B | C
Company 2 |  | B
Company 2 | A
Spreadsheet: 146339d1332119004-would-you-please-help-me-to-solve-this-problem-stock-tracker
Sheet: Sheet1

 | Stock Name | B / S | Invoive Number | Date | Stock Qty | Stock Price | Transaction Amount | Agent fees | [NAME] | Groos Stock Price | 1 St Question | 2 nd Question
 | NBD Bank | Buy | 115625 | 14/3/2001 | 1000 | 5.6 |  |  |  |  |  | 1000
 | American Cement Company | Buy | 115626 | 14/3/2001 | 500 | 10.6 |  |  |  |  |  | 500
 | NBD Bank | Buy | 115627 | 15/3/2001 | 500 | 5.7 |  |  |  |  |  | 1500
 | NBD Bank | Sell | 189413 | 15/3/2001 | 500 | 6.5 |  |  |  |  |  | 1000
 | American Cement Company | Buy | 115628 | 16/3/2001 | 250 | 10.7 |  |  |  |  |  | 750
 | American Cement Company | Sell | 189414 | 18/3/2001 | 250 | 11.5 |  |  |  |  |  | 500
 | 1 St Question | Cells In Column L ( Stock Profit Or Loss )  must be calculated under FIFO Rule ( First In First Out ) ,For example [NAME] should be = J7-(K4*500/1000) OR any other formula give such result like J7*500/1000 …………….. Final Result Should be  147.5
 | 2 nd Question | Cells In Column M ( Stock Balance ) for each stock separatly to show intered values
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -1376 | -2139
2 | -2054 | -2139
3 | -664 | -2139
4 | -1983 | -2139
5 | -1856 | -2139
6 | -1043 | -2139
7 |  | -438
8 |  | -438 |  |  |  |  |  |  |  |  | Avg
9 |  | -438 |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
10 |  | -438
11 |  | -438 |  |  |  |  | 2001-01-01 00:00:00 | -50582 | -68700 |  | 8.21
12 |  | -408 |  |  |  |  | 2001-02-01 00:00:00 | -54068 | -70278 |  | 5.62
13 |  | -1118 |  |  |  |  | 2001-03-01 00:00:00 | -58719 | -82564 |  | 4.98
14 |  | -346 |  |  |  |  | 2001-04-01 00:00:00 | -52309 | -39370 |  | 4.87
15 |  | -369 |  |  |  |  | 2001-05-01 00:00:00 | -57841 | -49325 |  | 3.82
16 |  |  |  |  |  |  | 2001-06-01 00:00:00 | -50325 | -65214 |  | 3.2
17 |  |  |  |  |  |  | 2001-07-01 00:00:00 | -43678 | -59252 |  | 2.77
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | -421481.58
2001-09-15 00:00:00
CBS Volume
 |  |  | -77754
Spreadsheet: 77972d1278437985-clustering-data-clusters
Sheet: Sheet2

 | No |  | Cluster 1 | 0.42
 | No |  | Cluster 2 | 0.56
 | No |  | Cluster 3 | 0.4615384615384616
 | Yes
 | Yes
 | Yes
 | No
 | Yes
 | Yes
 | Yes
 | No
 | No
 | Yes
 | No
 | Yes
 | No
 | No
 | No
 | No
 | No
 | Yes
 | No
 | Yes
 | Yes
 | No
 | Yes
 | No
 | No
 | Yes
 | Yes
 | No
 | Yes
 | Yes
 | Yes
 | Yes
 | No
 | No
 | No
 | No
 | No
 | Yes
 | Yes
 | Yes
 | No
 | No
 | No
 | No
 | No
 | No
 | No
 | Yes
 | No
 | No
 | Yes
 | No
 | No
 | No
 | No
 | No
 | Yes
 | Yes
 | Yes
 | Yes
 | No
 | No
 | Yes
 | Yes
 | Yes
 | No
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | No
 | No
 | No
 | Yes
 | Yes
 | No
 | No
 | Yes
 | Yes
 | Yes
 | No
 | Yes
 | Yes
 | Yes
 | Yes
 | No
 | No
 | Yes
 | No
 | No
 | Yes
 | Yes
 | Yes
 | No
 | No
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | No
 | No
 | Yes
 | No
 | No
 | No
 | Yes
 | No
 | Yes
 | No
 | Yes
 | No
 | No
 | No
 | No
 | No
 | Yes
 | Yes
 | Yes
 | No
 | No
 | No
 | No
 | No
 | Yes
 | Yes
 | Yes
 | No
 | No
 | No
 | Yes
 | No
 | No
 | No
 | No
 | Yes
 | Yes
 | No
 | Yes
 | No
 | No
 | Yes
 | No
 | Yes
 | Yes