tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 267843d1380233660-calculate-labor-hours-by-hour-calculate-labor-by-hour-solved
Sheet: Sheet1

PERFORMANCE BY HOUR
 | 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 | TOTAL
Sales | 0 | 0 | 0 | 850 | 2125 | 1010 | 350 | 175 | 875 | 1550 | 2800 | 3200 | 2715 | 1255 | 900 | 450 | -20 | 0
Covers | 0 | 0 | 0 | 13 | 97 | 34 | 11 | 5 | 19 | 45 | 78 | 90 | 68 | 28 | 14 | 8 | 0 | 0
AGC
[NAME]
Labour $
Labour %
LABOUR |  |  |  |  |  |  | PERFORMANCE BY REVENUE PERIOD
 | Time In | Time Out | Hours | Wages | Cost |  |  | BREAKFAST | LUNCH | DINNER | LATE | TOTAL
[NAME] | 08:00:00 | 16:45:00 |  | 13 |  |  | Sales
[NAME] | 08:00:00 | 1900-01-01 01:30:00 |  | 12 |  |  | Covers
Fred | 10:15:00 | 1900-01-01 00:15:00 |  | 9 |  |  | AGC
[NAME] | 10:45:00 | 23:45:00 |  | 15 |  |  | [NAME]
[NAME] | 09:00:00 | 18:20:00 |  | 13 |  |  | Labour $
Kelly | 10:00:00 | 21:15:00 |  | 17 |  |  | Labour %
This spreadhseet calculates the following criteria by hour;
Sales; user input
Covers; user input
Hours; calculated by start and end times in Labour area
Dollars; calculated by hours multiplied by wages in each hour
Percent; division of Dollars by Sales
Spreadsheet: 542374d1507826036-automate-this-table-automate-this-table-auto-2
Sheet: Comments

 | You are looking for 2 things.
 | 1: A way to quickly record results and have the point values calculate
 | 2: A way to express the results in a table summarized by Team
 | There are 2 ways to handle #1.
 |  | Type the results as you have in the following format
 |  |  | [NAME], space, Result, space, [NAME]
 |  |  | See results tab, cell T4
 |  | Then you can copy/append the results for the Home Team to column A
 |  | and do the same for the Away Team |  |  |  | cells  U4:V9 and W4:X9
 |  | The results then have the point values
 | Issues with this way are that capitalizaiton and spacing matter.
 |  | If they are copied as they currently stand you will lose some of your results.
 |  | Use the dropdown to input results
 |  | Then you can copy/append the results for the Home Team to column A
 |  | and do the same for the Away Team |  |  |  | cells  W16:X21 and ZW16:AA21
 | There are 2 ways to handle #2.
 |  | Update the Pivot table which doesn't show games played or use the SumProduct table.
 | My advise is to use the second option for each one.
 | Good luck!
Spreadsheet: 17a1a999-1b5d-4b97-a93b-b23e2fb88bfe
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 30. LEASE FINANCE COMMITMENTS, By Industry: Australia ($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
Agriculture, forestry and fishing ; |  |  | Original | A2420286X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2420287A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2420288C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2420289F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2420290R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | A2420291T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2420292V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2420293W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2420294X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2420295A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Public Administration ; |  |  | Original | A2420296C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2420297F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2420298J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2420299K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 7a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 119315428 | 71134267 | 190449695
FRA | 51331330 | 6578200 | 57909530
OIS | 27764541 | 7422455 | 35186996
Swaption | - | 17429324 | 17429324
OTHER* | 5683408 | 26612203 | 32295611
TOTAL | 204094707 | 129176449 | 333271156
* OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 158545d1338302900-mileage-tracking-and-charging-mileage
Sheet: Sheet1

5000 | 0.52
5001 | 0.46
 |  | OCTOBER | NOVEMBER | DECEMBER | JANUARY | FEBRUARY | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER
 |  | 755 | 2000 | 1000 | 1050 | 305.6 | 2555 | 0 | 0 | 0 | 0 | 0 | 0
 | Current Mileage | 755 | 2755 | 3755 | 4805 | 5110.6 | 7665.6 | 7665.6 | 7665.6 | 7665.6 | 7665.6
 | Current Expense | 392.6 | 1432.6 | 1952.6 | 2498.6 | 2650.876 | 3826.176 | 3826.176 | 3826.176 | 3826.176 | 3826.176 | 0 | 0
Spreadsheet: 123163d1317387126-absence-reporting-in-excel-2007-count-of-absence
Sheet: Sheet1

Employee ID | Known as | Surname | Reason | 2010-01-01 00:00:00 | Absence Type | Count of Days
123456 | [NAME] | Bloggs | SICK | 2010-08-09 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2010-08-10 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2010-09-03 00:00:00 | Single Day
123456 | [NAME] | Bloggs | SICK | 2010-09-07 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2010-09-08 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2010-09-09 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2010-09-10 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2010-09-13 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2010-09-14 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2010-09-15 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2010-09-16 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2010-09-17 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2010-10-08 00:00:00 | Single Day
123456 | [NAME] | Bloggs | SICK | 2010-11-22 00:00:00 | Single Day
123456 | [NAME] | Bloggs | SICK | 2011-01-24 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2011-01-25 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2011-01-26 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2011-05-23 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2011-05-24 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2011-06-06 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2011-06-07 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2011-07-14 00:00:00 | Consecutive Days
123456 | [NAME] | Bloggs | SICK | 2011-07-15 00:00:00 | Consecutive Days
 |  |  |  |  | [NAME] had 9 periods of absence
Spreadsheet: 105396d1302766755-transpose-with-slight-re-arrangement-prep0311_-_copy
Sheet: OUTPUT

REGION | BRCODE | BRNAME | 2009-03-01 00:00:00 |  |  | 2010-03-01 00:00:00 |  |  | 2011-03-01 00:00:00
10 | 40006 | M G ROAD BANGAL | 237.65 | 203.83 | 0.9 | 177.54 | 73.26 | 0.69 | 221.27 | 80.91 | 0.77
11 | 40008 | BANASHANKARI | 93.4 | 43.61 | 0.33 | 111.98 | 53.12 | 0.38 | 129.03 | 44.72 | 0.35
14 | 40009 | CHAMARAJPET | 86.64 | 21.63 | 0.37 | 136.66 | 24.91 | 0.42 | 156.22 | 31.1 | 0.35
14 | 40010 | CHICKPET | 70.39 | 10 | 0.25 | 72.88 | 10.71 | 0.22 | 61.08 | 11.63 | 0.19
Spreadsheet: 0d3b2f25-eb09-4d97-a6aa-af933210ddad
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
42435167 | 2014-07-24 16:18:48 | AXIS | 1 | 6 | 1 | 694159 | dugoutdoug | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42435295 | 2014-07-24 16:44:03 | ALLIES | 1 | 6 | 4 | 694159 | dugoutdoug | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42473954 | 2014-07-27 14:03:02 | AXIS | 1 | 6 | 5 | 1604857 | BreakerMorant | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
42474253 | 2014-07-27 14:36:25 | ALLIES | 1 | 6 | 4 | 1604857 | BreakerMorant | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
Spreadsheet: 757197d1638111995-filter-the-top-12-highest-number-with-duplicates-then-lookup-to-its-reference-criteria-sort-but-not-top-6
Sheet: sample file

 | No. | Qty |  | No. | Qty |  |  | TOP 12
 | 1 | 4 |  | 20 | 7
 | 2 | 2 |  | 21 | 5 |  |  | No. | Qty |  | No. | Qty
 | 3 | 10 |  | 22 | 5 |  |  | 3 | 10 |  | 32 | 7 |  | Expected Result
 | 4 | 6 |  | 23 | 8 |  |  | 6 | 9 |  | 34 | 7
 | 5 | 6 |  | 24 | 5 |  |  | 23 | 8 |  | 4 | 6
 | 6 | 9 |  | 25 | 3 |  |  | 8 | 7 |  | 5 | 6
 | 7 | 3 |  | 26 | 4 |  |  | 11 | 7 |  | 12 | 6
 | 8 | 7 |  | 27 | 5 |  |  | 20 | 7 |  | 13 | 5
 | 9 | 4 |  | 28 | 2
 | 10 | 3 |  | 29 | 4 |  |  |  | 10 |  |  | 8 |  | Using Excel 365 Sort() formula gets you half way there.
 | 11 | 7 |  | 30 | 3 |  |  | 6 | 9 |  | 20 | 7 |  | See the yellow cell formulas.
 | 12 | 6 |  | 31 | 3 |  |  | 8 | 7 |  | 32 | 7
 | 13 | 5 |  | 32 | 7 |  |  | 11 | 7 |  | 34 | 7
 | 14 | 3 |  | 33 | 4 |  |  | 4 | 6 |  | 21 | 5
 | 15 | 5 |  | 34 | 7 |  |  | 5 | 6 |  | 22 | 5
 | 16 | 5 |  | 35 | 5 |  |  | 12 | 6 |  | 24 | 5
 | 17 | 3 |  | 36 | 4 |  |  | 13 | 5 |  | 27 | 5
 | 18 | 5 |  | 37 | 4 |  |  | 15 | 5 |  | 35 | 5
 | 19 | 4 |  | 38 | 4 |  |  | 16 | 5 |  | 26 | 4
 |  |  |  |  |  |  |  | 18 | 5 |  | 29 | 4
 |  |  |  |  |  |  |  | 1 | 4 |  | 33 | 4
 |  |  |  |  |  |  |  | 9 | 4 |  | 36 | 4
 |  |  |  |  |  |  |  | 19 | 4 |  | 37 | 4
 |  |  |  |  |  |  |  | 7 | 3 |  | 38 | 4
 |  |  |  |  |  |  |  | 10 | 3 |  | 25 | 3
 |  |  |  |  |  |  |  | 14 | 3 |  | 30 | 3
 |  |  |  |  |  |  |  | 17 | 3 |  | 31 | 3
 |  |  |  |  |  |  |  | 2 | 2 |  | 28 | 2
Spreadsheet: 01655955-0add-4273-921c-802605aaf617
Sheet: Docket

TICKET | VIOL | OCCUR | NAME | VIOLATION | FINE AMT | COST AMT | REST AMT | TOTAL AMT | TIME SERVED | PAID AMT | BALANCE | OFFENSE DT | ATTORNEY | BOND POSTED | COMPLAINANT
1019574 | 1231 | 0 | BROWDER,LINCOLN CEDRIC | DL-DWLI - FIRST OFFENSE - SUSPENDED | 0 | 402.1 | 0 | 402.1 | 0 | 201 | 201.1 | 2012-10-02 00:00:00 |  | 0 | C VINSON
1019615 | 2244 | 0 | CAMPBELL,CORINTHIA CHASE | SPEEDING | 61 | 102.1 | 0 | 163.1 | 0 | 0 | 163.1 | 2012-10-17 00:00:00 |  | 0 | C VINSON
1022091 | 1334 | 0 | CARABBIO,ORISSA J | SEAT BELTS-PASSENGER | 0 | 147.1 | 0 | 147.1 | 0 | 0 | 147.1 | 2013-04-08 00:00:00 |  | 0 | C VINSON
1016580 | 3002 | 0 | CHAPPELL,JUSTIN ISAAC | LIABILITY INSURANCE-FMFR | 0 | 309.1 | 0 | 309.1 | 0 | 0 | 309.1 | 2012-08-30 00:00:00 |  | 0 | W SUMMERS
169939 | 1201 | 0 | GABRIEL,LATISHA LANETTE | DL-NO OPERATOR'S LICENSE | 0 | 371.23 | 0 | 371.23 | 0 | 20 | 351.23 | 2010-02-18 00:00:00 | REGINALD CARPENTER | 0 | K V JONES
169939 | 3002 | 0 | GABRIEL,LATISHA LANETTE | LIABILITY INSURANCE-FMFR | 0 | 462.1 | 0 | 462.1 | 0 | 0 | 462.1 | 2010-02-18 00:00:00 | REGINALD CARPENTER | 0 | K V JONES
1014415 | 1200 | 0 | JUDGE,[NAME] | DL-NO DRIVER'S LICENSE IN POSSESSION | 0 | 242.1 | 0 | 242.1 | 0 | 0 | 242.1 | 2012-09-28 00:00:00 |  | 0 | J R ZIHLMAN
1014415 | 1751 | 0 | JUDGE,[NAME] | ONE-WAY STREET-7:00 AM-8:30 AM & 2:30 PM-4:15 PM | 0 | 222.1 | 0 | 222.1 | 0 | 0 | 222.1 | 2012-09-28 00:00:00 |  | 0 | J R ZIHLMAN
1017114 | 2244 | 0 | [NAME],[NAME] | SPEEDING | 0 | 221.1 | 0 | 221.1 | 0 | 0 | 221.1 | 2012-11-19 00:00:00 |  | 0 | R JESIONEK
1021564 | 2244 | 0 | PUT,[NAME] | SPEEDING | 0 | 221.1 | 0 | 221.1 | 0 | 0 | 221.1 | 2013-02-07 00:00:00 |  | 0 | K JORDAN
1014902 | 1231 | 0 | [NAME],[NAME] | DL-DWLI - FIRST OFFENSE - SUSPENDED | 0 | 402.1 | 0 | 402.1 | 0 | 0 | 402.1 | 2012-08-14 00:00:00 |  | 0 | K JORDAN
1014902 | 2244 | 0 | [NAME],[NAME] | SPEEDING | 0 | 202.1 | 0 | 202.1 | 0 | 0 | 202.1 | 2012-08-14 00:00:00 |  | 0 | K JORDAN
Spreadsheet: 274257d1383059039-formula-to-automatically-duplicate-row-information-to-another-area-in-a-worksheet-shiftnotesblake3
Sheet: ORDERS TO UPDATE

50471 | OF | 53078 | OF | 53284 |  | 53366 |  | 53402 |  | O | OPEN |  | 2013-10-23 00:00:00
51516 | C | 53079 | WJ | 53284 |  | 53367 |  | 53402 |  | OL | LATE
51596 |  | 53093 |  | 53296 |  | 53367 |  | 53403 |  | OF | FUTURE
52095 | B | 53094 | B | 53296 |  | 53368 |  | 53403 |  | B | BLANKET
52096 | B | 53109 | CA | 53301 |  | 53368 |  | 53404 |  | C | CANCELLED
52213 |  | 53109 |  | 53302 |  | 53369 |  | 53404 |  | CA | CUSTOMER APPROVAL
52213 |  | 53112 |  | 53305 |  | 53369 |  | 53405 |  | WJ | WATERJET
52287 |  | 53112 |  | 53306 |  | 53372 |  | 53405
52667 |  | 53113 |  | 53307 |  | 53372 |  | 53406 | O 10/23
52667 |  | 53113 |  | 53307 |  | 53375 |  | 53407
52678 |  | 53124 |  | 53308 |  | 53375 |  | 53407
52756 |  | 53124 |  | 53308 |  | 53376 |  | 53408
52756 |  | 53134 | C | 53313 |  | 53376 |  | 53408
52757 |  | 53156 |  | 53316 |  | 53377 |  | 53409 | OF
52757 |  | 53156 |  | 53316 |  | 53377 |  | 53410 | OF
52938 |  | 53166 |  | 53317 |  | 53379 |  | 53411
52938 |  | 53195 |  | 53317 |  | 53379 |  | 53411
52939 |  | 53202 | OL | 53318 |  | 53384 |  | 53412
52939 |  | 53220 | OL | 53318 |  | 53385 |  | 53412
52940 |  | 53224 |  | 53319 |  | 53385 |  | 53413
52940 |  | 53224 |  | 53319 |  | 53386 |  | 53413
52941 |  | 53229 |  | 53320 |  | 53386 |  | 53414 | OF
52941 |  | 53229 |  | 53320 |  | 53387 |  | 53415 | OF
52975 |  | 53233 |  | 53321 |  | 53387 |  | 53416 | OF
52986 |  | 53233 |  | 53321 |  | 53388 |  | 53417 | O
52986 |  | 53237 |  | 53323 |  | 53388 |  | 53418 | OF
52991 |  | 53237 |  | 53323 |  | 53389 |  | 53419 | OF
52991 |  | 53249 |  | 53324 |  | 53389 |  | 53420 | OF
52992 |  | 53249 |  | 53324 |  | 53390 |  | 53421 | OF
52992 |  | 53256 |  | 53325 |  | 53390 |  | 53422 | OF
52993 |  | 53263 |  | 53325 |  | 53391
52993 |  | 53263 |  | 53326 |  | 53391
52994 |  | 53265 |  | 53326 |  | 53392
52994 |  | 53265 |  | 53328 |  | 53392
53019 |  | 53266 |  | 53337 |  | 53393
53019 |  | 53266 |  | 53337 |  | 53393
53020 |  | 53267 |  | 53342 | OF | 53394
53020 |  | 53267 |  | 53344 |  | 53394
53027 |  | 53273 |  | 53350 |  | 53395
53027 |  | 53273 |  | 53350 |  | 53395
53032 |  | 53276 |  | 53351 |  | 53396
53032 |  | 53276 |  | 53351 |  | 53396
53038 |  | 53277 |  | 53362 |  | 53397 | C
53038 |  | 53277 |  | 53362 |  | 53398
53042 |  | 53278 |  | 53363 |  | 53398
53042 |  | 53278 |  | 53363 |  | 53399
53043 |  | 53279 |  | 53364 |  | 53399
53043 |  | 53279 |  | 53364 |  | 53400
53044 | B | 53281 |  | 53365 |  | 53400
53072 | REJ | 53281 |  | 53365 |  | 53401
53078 |  |  |  | 53366 |  | 53401
Spreadsheet: 9ef4b4f2-7b39-4d49-877d-a9c28d874bee
Sheet: Sheet1

DEC - JAN
NAME/DATE | MON 26 | TUES 27 | WED 28 | THURS 29 | FRI 30 | SAT 31 | SUN 01
ALVIN | OFF | P.M | P.M | A.M | OFF | P.M | P.M
SHAHIL | P.M | OFF | P.M | P.M | P.M | OFF | OFF
ANUSHKA | A.M | A.M | OFF | OFF | A.M | A.M | A.M
TINA | OFF | A.M | A.M | OFF | A.M | A.M | A.M
NAME/DATE | MON 02 | TUES 03 | WED 04 | THURS 05 | FRI 06 | SAT 07 | SUN 08
ALVIN | P.M | OFF | OFF | P.M | P.M | P.M | P.M
SHAHIL | A.M | P.M | P.M | OFF | OFF | A.M | A.M
ANUSHKA | OFF | P.M | P.M | P.M | P.M | OFF | OFF
TINA | OFF | P.M | P.M | P.M | P.M | OFF | OFF
NAME/DATE | MON 09 | TUES 10 | WED 11 | THURS 12 | FRI 13 | SAT 14 | SUN 15
ALVIN | P.M | P.M | P.M | OFF | A.M | OFF | OFF
SHAHIL | A.M | OFF | OFF | P.M | P.M | P.M | P.M
ANUSHKA | OFF | A.M | A.M | A.M | OFF | A.M | A.M
TINA | OFF | A.M | A.M | A.M | OFF | A.M | A.M
NAME/DATE | MON 16 | TUES 17 | WED 18 | THURS 19 | FRI 20 | SAT 21 | SUN 22
ALVIN | P.M | OFF | A.M | A.M | P.M | OFF | OFF
SHAHIL | OFF | P.M | P.M | P.M | OFF | P.M | P.M
ANUSHKA | A.M | A.M | OFF | OFF | P.M | P.M | P.M
TINA | A.M | A.M | OFF | OFF | A.M | A.M | A.M
NAME/DATE | MON 23 | TUES 24 | WED 25 | THURS 26 | FRI 27 | SAT 28 | SUN 29
ALVIN | P.M | P.M | P.M | OFF | P.M | OFF | OFF
SHAHIL | OFF | A.M | A.M | P.M | OFF | P.M | P.M
ANUSHKA | A.M | OFF | OFF | A.M | A.M | A.M | A.M
TINA | A.M | OFF | OFF | A.M | A.M | A.M | A.M
Spreadsheet: 54195d1254224800-calculated-item-in-pivot-tables-problem-book1
Sheet: PT

Sum of DATA |  | KF
SR1 | SR2 | FCST | SHIP | FCST-SHIP | Grand Total
CEE | FRANCE |  |  | 0 | 0
 | HUNGARY | 200 | 100 | 100 | 400
 | SLOVENIA | 200 | 100 | 100 | 400
 | UKRAINE | 200 | 100 | 100 | 400
CEE Total |  | 600 | 300 | 300 | 1200
FRANCE | FRANCE | 200 | 100 | 100 | 400
 | HUNGARY |  |  | 0 | 0
 | SLOVENIA |  |  | 0 | 0
 | UKRAINE |  |  | 0 | 0
FRANCE Total |  | 200 | 100 | 100 | 400
Grand Total |  | 800 | 400 | 400 | 1600
Spreadsheet: eric_saibi__9799__091801R
Sheet: McMeekin 01

Owner Name | South Carolina Electric and Gas Company
Station Name | McMeekin Power Station
Unit Name | McMeekin 01
NERC Region | SERC
State | SC
Fuel Type | Coal / Natural Gas
Capacity | 147 MW
Start Date | 2001-09-27 00:00:00
End Date | 2001-11-25 00:00:00
Prv. Start Date | 2001-10-06 00:00:00
Prv. End Date | 2001-11-30 00:00:00
Comments
SIC | 4911
Plant ID | 1011934
Unit ID | 1008493
Outage ID | 10959
Spreadsheet: 356662d1415181655-column-sort-without-chaning-formulae-jc-booking-september-2014
Sheet: 31st

Date |  |  |  |  |  |  |  |  |  |  |  | DAY SHEET
Job No | Due | Contact | Contact No. | Car | Imax | 13 Pax | 20 Pax | 24 Pax | 29 Pax | 44 Pax | FROM | TO | Retn | Price  $ | Dep  $ | Bal | Mode | Pax | Trailer | Con | Bus | Des | Driver
 | 8.45 |  |  |  |  |  |  |  |  |  | \
 |  |  |  |  |  |  |  |  |  |  | Malaysia - 0645 Hotel
 |  |  |  |  |  |  |  |  |  |  | Malaysia - 0730 - Apt
TOTAL
 |  |  |  |  |  |  |  |  |  |  |  | Monthly Total
Spreadsheet: 818015d1676553485-vlookup-with-conditions-example
Sheet: Accounting

Date | Stuff | Amount | [NAME] | House 1 | House 2 | House 3 | House 4 | House 5 | House 6
2022-02-01 00:00:00 | Water | 100 | Person | 23.07692307692308 | 23.07692307692308 | 7.692307692307693 | 7.692307692307693 | 15.38461538461539 | 23.07692307692308
2022-03-01 00:00:00 | Taxes | 100 | Area | 12.82051282051282 | 19.23076923076923 | 10.25641025641026 | 10.25641025641026 | 25.64102564102564 | 21.7948717948718
2022-07-01 00:00:00 | Water | 100 | Person | 27.27272727272727 | 9.090909090909092 | 9.090909090909092 | 9.090909090909092 | 18.18181818181818 | 27.27272727272727
2023-02-01 00:00:00 | Water | 100 | Person | 27.27272727272727 | 18.18181818181818 | 9.090909090909092 | 9.090909090909092 | 9.090909090909092 | 27.27272727272727
2023-02-01 00:00:00 | Taxes | 100 | Area | 18.07228915662651 | 18.07228915662651 | 9.63855421686747 | 9.63855421686747 | 24.09638554216868 | 20.48192771084337
Spreadsheet: 732627d1621067654-if-all-cells-are-equal-choose-one-and-ignore-blanks-tst
Sheet: Hoja4

SOURCE1 | SOURCE2 | SOURCE3 | NOTE | RESULT
YEPY596003YJYRNR08 | YEPY596003YJYRNR08 | YEPY596003YJYRNR08 |  |  |  | ALL EQUAL | YEPY596003YJYRNR08
 | FOHT320328YDFFLRR08 |  |  |  |  | OK | FOHT320328YDFFLRR08
 | YTGI860367HJYSRV08 | YTGI860367HJYSRV08 |  |  |  | ALL EQUAL | YTGI860367HJYSRV08
 | EIYG820907HJYSRL02 | EIYG820907HJYSRL09 |  |  |  | NOT EQUAL | ?
TUJF626260HJYNYR02 |  |  |  |  |  | OK | TUJF626260HJYNYR02
 | TUJF626260HJYNYR02 |  |  |  |  | OK | TUJF626260HJYNYR02
 |  | JTDY526262HJYRZN08 |  |  |  | OK | JTDY526262HJYRZN08
TUJF626260HJYNYR02 |  |  |  |  |  | OK | TUJF626260HJYNYR02
TTIT586227YJYVXN05 |  |  |  |  |  | OK | TTIT586227YJYVXN05
 | ZULB600726HJYXPN00 |  |  |  |  | OK | ZULB600726HJYXPN00
ROTT990225YYSYNN06 |  |  |  |  |  | OK | ROTT990225YYSYNN06
 | YUBR550309HYSRRB02 | YUBR550309HYSRRB02 |  |  |  | ALL EQUAL | YUBR550309HYSRRB02
Spreadsheet: 84989d1285075376-if-function-cross-workbooks-summary
Sheet: Sheet1

 |  | VLOOKUP |  |  |  |  | IF FUNCTION
Name | ID | Start Date |  |  | Name | ID | Start Date
Name1 | ID1 |  |  |  | Name1 | ID1
[NAME] | ID2 |  |  |  | [NAME] | ID2
Name3 | ID3 |  |  |  | Name3 | ID3
Name4 | ID4 |  |  |  | Name4 | ID4
Name5 | ID5 |  |  |  | Name5 | ID5
Name6 | ID6 |  |  |  | Name6 | ID6
Name7 | ID7 |  |  |  | Name7 | ID7
Name8 | ID8 |  |  |  | Name8 | ID8
Name9 | ID9 |  |  |  | Name9 | ID9
Name10 | ID10 |  |  |  | Name10 | ID10
Name11 | ID11 |  |  |  | Name11 | ID11
Name12 | ID12 |  |  |  | Name12 | ID12
Name13 | ID13 |  |  |  | Name13 | ID13
Spreadsheet: 831548d1685709672-really-weird-date-problem-example-file-2
Sheet: Bank Holidays

Holidays
2022-01-03 00:00:00
2022-04-15 00:00:00
2022-04-18 00:00:00
2022-05-02 00:00:00
2022-06-02 00:00:00
2022-06-03 00:00:00
2022-08-29 00:00:00
2022-09-19 00:00:00
2022-12-26 00:00:00
2022-12-27 00:00:00
2023-01-02 00:00:00
2023-07-07 00:00:00
2023-04-10 00:00:00
2023-05-01 00:00:00
2023-05-08 00:00:00
2023-05-29 00:00:00
2023-08-28 00:00:00
2023-12-25 00:00:00
2023-12-26 00:00:00
2024-01-01 00:00:00
2024-03-29 00:00:00
2024-04-01 00:00:00
2024-05-06 00:00:00
2024-05-27 00:00:00
2024-08-26 00:00:00
2024-12-25 00:00:00
2024-12-26 00:00:00
2025-01-01 00:00:00
2025-04-18 00:00:00
2025-04-21 00:00:00
2025-05-05 00:00:00
2025-05-26 00:00:00
2025-08-25 00:00:00
2025-12-25 00:00:00
2025-12-26 00:00:00
Spreadsheet: 02bb5c89-418b-4570-9d55-26d084b3e6f7
Sheet: Risks

Project Name |  |  |  |  |  |  | Sponsor
Project Manager |  |  |  |  |  |  | Date Updated
ID | Description | Date Opened | Date Opened | Status | Category | Probability | Impact | Risk  Score | Risk Response | Detailed Risk Response | Risk Trigger(s) | Timing | Risk Owner | Risk Owner | Close Date |  | Prob Score | Impact Score
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Probability | Impact
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High | Medium | Low
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low
6
7
8
9
10
11
12
13
14
15
 |  |  |  |  | List….
 |  |  |  |  | Architecture
 |  |  |  |  | Business
 |  |  |  |  | [NAME]
 |  |  |  |  | Cost
 |  |  |  |  | Cust. Satisfaction
 |  |  |  |  | End User
 |  |  |  |  | Enterprise
 |  |  |  |  | Political
 |  |  |  |  | Quality
 |  |  |  |  | Regulatory
 |  |  |  |  | Requirements
 |  |  |  |  | Res. Avail
 |  |  |  |  | Schedule
 |  |  |  |  | Staffing
 |  |  |  |  | Technical
 |  |  |  |  | Vendor