tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 159417d1338630552-create-calendar-by-repeating-values-data-form-sample-2-
Sheet: Sheet1

2012-01-01 00:00:00
 |  | PFD
Codes:
S=called in sick |  |  |  | D=doctors excuse |  |  |  |  | T=tardy/late |  |  | LE=left work early
F=funeral |  |  |  | U=unexcused |  |  | VFD=vacation full day |  |  |  |  | VHD=vacation half day
PFD=personal full day |  |  |  |  |  | PHD=personal half day
July |  |  | August |  |  | September |  |  | October |  |  | November |  |  | December
1 | S |  | 1 | W |  | 1 | S |  | 1 | M |  | 1 | T |  | 1 | S
2 | M |  | 2 | T |  | 2 | S |  | 2 | T |  | 2 | F |  | 2 | S
3 | T |  | 3 | F |  | 3 | M |  | 3 | W |  | 3 | S |  | 3 | M
4 | W |  | 4 | S |  | 4 | T |  | 4 | T |  | 4 | S |  | 4 | T
5 | T |  | 5 | S |  | 5 | W |  | 5 | F |  | 5 | M |  | 5 | W
6 | F |  | 6 | M |  | 6 | T |  | 6 | S |  | 6 | T |  | 6 | T
7 | S |  | 7 | T |  | 7 | F |  | 7 | S |  | 7 | W |  | 7 | F
8 | S |  | 8 | W |  | 8 | S |  | 8 | M |  | 8 | T |  | 8 | S
9 | M |  | 9 | T |  | 9 | S |  | 9 | T |  | 9 | F |  | 9 | S
10 | T |  | 10 | F |  | 10 | M |  | 10 | W |  | 10 | S |  | 10 | M
11 | W |  | 11 | S |  | 11 | T |  | 11 | T |  | 11 | S |  | 11 | T
12 | T |  | 12 | S |  | 12 | W |  | 12 | F |  | 12 | M |  | 12 | W
13 | F |  | 13 | M |  | 13 | T |  | 13 | S |  | 13 | T |  | 13 | T
14 | S |  | 14 | T |  | 14 | F |  | 14 | S |  | 14 | W |  | 14 | F
15 | S |  | 15 | W |  | 15 | S |  | 15 | M |  | 15 | T |  | 15 | S
16 | M |  | 16 | T |  | 16 | S |  | 16 | T |  | 16 | F |  | 16 | S
17 | T |  | 17 | F |  | 17 | M |  | 17 | W |  | 17 | S |  | 17 | M
18 | W |  | 18 | S |  | 18 | T |  | 18 | T |  | 18 | S |  | 18 | T
19 | T |  | 19 | S |  | 19 | W |  | 19 | F |  | 19 | M |  | 19 | W
20 | F |  | 20 | M |  | 20 | T |  | 20 | S |  | 20 | T |  | 20 | T
21 | S |  | 21 | T |  | 21 | F |  | 21 | S |  | 21 | W |  | 21 | F
22 | S |  | 22 | W |  | 22 | S |  | 22 | M |  | 22 | T |  | 22 | S
23 | M |  | 23 | T |  | 23 | S |  | 23 | T |  | 23 | F |  | 23 | S
24 | T |  | 24 | F |  | 24 | M |  | 24 | W |  | 24 | S |  | 24 | M
25 | W |  | 25 | S |  | 25 | T |  | 25 | T |  | 25 | S |  | 25 | T
26 | T |  | 26 | S |  | 26 | W |  | 26 | F |  | 26 | M |  | 26 | W
27 | F |  | 27 | M |  | 27 | T |  | 27 | S |  | 27 | T |  | 27 | T
28 | S |  | 28 | T |  | 28 | F |  | 28 | S |  | 28 | W |  | 28 | F
29 | S |  | 29 | W |  | 29 | S |  | 29 | M |  | 29 | T |  | 29 | S
30 | M |  | 30 | T |  | 30 | S |  | 30 | T |  | 30 | F |  | 30 | S
31 | T |  | 31 | F |  |  |  |  | 31 | W |  |  |  |  | 31 | M
S | S=called in sick
F | F=funeral
PFD | PFD=personal full day
D | D=doctors excuse
U | U=unexcused
PHD | PHD=personal half day
VFD | VFD=vacation full day
T | T=tardy/late
LE | LE=left work early
VHD | VHD=vacation half day
Spreadsheet: 859849d1708084780-convert-irregular-data-to-monthly-power_consumption
Sheet: Data

Date | Amount | Units (KWh) | Price (Ex Tax) | Price/KWh
2022-07-21 00:00:00 | 500 | 22.87 | 288.17
2022-08-12 00:00:00 | 2000 | 91.47 | 1152.54
2022-08-22 00:00:00 | 2500 | 114.33 | 1440.65
2022-09-28 00:00:00 | 4000 | 158.71 | 1999.76
2022-10-01 00:00:00 | 0 | 0 | 0 | 0
2022-11-04 00:00:00 | 2499 | 97.37 | 1226.88
2022-11-18 00:00:00 | 2500 | 101.04 | 1273.08
2022-12-03 00:00:00 | 3000 | 121.4 | 1527.69
2022-12-29 00:00:00 | 2000 | 76.08 | 958.63
2023-01-20 00:00:00 | 1000 | 37.89 | 477.44
2023-01-29 00:00:00 | 3000 | 113.67 | 1432.28
2023-02-19 00:00:00 | 1500 | 58.53 | 737.47
2023-03-08 00:00:00 | 2500 | 97.55 | 1229.1
2023-03-27 00:00:00 | 2000 | 71.62 | 902.5
2023-04-12 00:00:00 | 2500 | 78.74 | 1651.25
2023-04-30 00:00:00 | 4000 | 125.99 | 2642.01
2023-05-27 00:00:00 | 5000 | 155.37 | 3258.13
2023-06-28 00:00:00 | 4000 | 119.28 | 2501.3
2023-07-17 00:00:00 | 1500 | 47.41 | 975.82
2023-07-23 00:00:00 | 5000 | 158.05 | 3252.63
2023-07-25 00:00:00 | 250 | 7.9 | 162.66
2023-07-27 00:00:00 | 500 | 15.8 | 325.29
2023-08-17 00:00:00 | 3000 | 93.44 | 1922.93
2023-09-07 00:00:00 | 4000 | 124.58 | 2563.9
2023-10-05 00:00:00 | 4000 | 127.26 | 2619.1
2023-11-07 00:00:00 | 4000 | 121.18 | 2493.93
2023-12-01 00:00:00 | 4000 | 122.39 | 2518.88
2023-12-24 00:00:00 | 4500 | 136.31 | 2805.27
2024-01-01 00:00:00 | 0 | 0 | 0 | 0
2024-02-01 00:00:00 | 0 | 0 | 0 | 0
2024-03-01 00:00:00
Spreadsheet: 5c476c47-4df7-42d5-a284-fe1650a2e534
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 | Table S4. Total GSH and enzyme activities of NQO1 and GST in matched NSCLC and normal tissues.
 | Patient # | PT-42 | PT-18* | PT-17* | PT-43 | PT-44 | PT-24 | PT-25 | [NAME] | PT-40 | PT-23* | PT-29* | PT-27 | PT-45 | Mean + SEM
 | GSH Normal | 0.4749787955894827 | 16.41221374045801 | 5.979643765903308 | 0.1357082273112805 | 3.358778625954201 | 6.581849024597111 | 5.648854961832065 | 6.208651399491094 | 6.666666666666666 | 2.391857506361324 | 2.222222222222223 | 7.370653095843933 | 1.950805767599672 | 5.0 + 1.1
 | [NAME] | 0.5597964376590332 | 24.38507209499575 | 0.356234096692111 | 16.75996607294317 | 19.98303647158609 | 7.26039016115352 | 31.51823579304495 | 9.601357082273115 | 32.2815945716709 | 44.82612383375741 | 22.59541984732824 | 22.23070398642918 | 35.8863443596268 | 20.6 + 3.7§
 | NQO1 Normal | 3.8 | 28.57142857142857 | 17.14285714285714 | 5.71 | 5.23 | 4.28 | 5.71 | 12.87 | 3.8 | 23.33333333333333 | 14.28571428571428 | 23.33333333333333 | 20 | 12.9 + 2.4
 | [NAME] | 3.33 | 1 | 22.85714285714285 | 8.57 | 26.19 | 34.76 | 22.38 | 68.09 | 21.9 | 3.809523809523812 | 51.42857142857144 | 135.2380952380952 | 170.9523809523809 | 43.9 + 14.6†
 | GST Normal | 15.625 | 23.4375 | 18.75 | 5.208333333333333 | 11.97916666666667 | 25 | 22.91666666666666 | 18.75 | 16.66666666666667 | 36.97916666666667 | 23.95833333333334 | 21.875 | 31.77083333333333 | 21.0 + 2.2
 | GST Tumor | 6.25 | 40.625 | 19.79166666666666 | 14.0625 | 20.3125 | 45.3125 | 32.29166666666666 | 23.4375 | 42.70833333333334 | 98.95833333333333 | 81.25 | 27.08333333333334 | 23.4375 | 36.6 + 7.3‡
 | *, Patients whose tumors had somatic mutations.  Total GSH is expressed as nmol/mg protein. Data for NQO1 and GST is expressed as nmol DCPIP reduced/min/mg protein and nmol of product formed /min/mg protein respectively. §, P < 0.001; †, P = 0.046 ‡,  P = 0.025 (paired t test)
Spreadsheet: frank_ermis__11174__West NatGas Prices 1108
Sheet: Gas Average FinIdx

FinIdx Curves
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEST NATURAL GAS PRICES- Fin Idx
 |  | AS OF
 |  |  |  |  |  |  |  |  |  | Last-Day | Cash | Cash | Change | BOM | BOM | Change | Prompt Month | Change | Q4 | Change | Winter 2001-02 | Change | Q1 | Change | Q2 | Change | Summer 2002 | Change | Q3 | Change | Q4 | Change | Winter 2002-03 | Change
 |  |  |  |  |  |  |  |  |  | Cash Settle | Price | Spread |  | Price | Spread |  |  |  | 2001 |  | Nov-01/Mar-02 |  | 2002 |  | 2002 |  | Apr-02/Oct-02 |  | 2002 |  | 2002 |  | Nov-02/Mar-03
 |  | California Region Notional
 |  |  |  |  | Sheet Name | Row Num for CurveName | Column Letter for Date
 |  |  |  | Basis | IndexCurves | 13 | B
 |  | Gas Trading |  | IntraMonth | CurveFetch | 4 | D
 |  |  |  |  |  |  |  |  | IntraMonth
 |  |  |  | IntraMonth Hub Curve | IF-HEHUB
 |  |  |  | IntraMonth Month
 |  |  |  |  |  |  |  |  | Date Start |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 |  |  |  | 2002-01-01 00:00:00 |  | 2002-04-01 00:00:00 |  | 2002-04-01 00:00:00 |  | 2002-07-01 00:00:00 |  | 2002-10-01 00:00:00 |  | 2002-11-01 00:00:00
 |  |  |  |  |  |  |  |  | Date End |  |  |  |  |  |  |  |  |  | 2001-12-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 2002-06-01 00:00:00 |  | 2002-10-01 00:00:00 |  | 2002-09-01 00:00:00 |  | 2002-12-01 00:00:00 |  | 2003-03-01 00:00:00
 |  | WEST REGION BASIS NOTIONAL |  | Intra-Month | Basis |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IntraMonth Match |  | Basis Match
 |  | NGI-PGE/CG |  | NGI-PGE/CG | GD-PG&E/CITIGAT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.043 |  |  |  | -0.0483 |  | -0.01 |  |  |  | -0.045 |  | -0.03
 |  | NGI-PGE/TOPOCK |  | NGI-PGE/TOPOCK | GDP-PGE/TOPOCK
 |  | NGI-MALIN |  | NGI-MALIN | GDP-MALIN-CTYGA
 |  | NGI-SOCAL |  | NGI-SOCAL | GDP-CAL BORDER
 |  | Southwest Region Notional
 |  | SAN JUAN |  | IF-ELPO/SJ | GDP-ELPO/SANJUA
 |  | ELPO/PERMIAN |  | IF-ELPO/PERMIAN | GDP-ELPO/PERM2
 |  | WAHA |  | IF-WAHA-TX | GDP-WAHA
 |  | NGPL/MIDCON |  | IF-NGPL/MIDCON | GDP-NGPL/OK
 |  | Northwest Region Notional
 |  | OPAL |  | IF-NWPL_ROCKY_M | GDP-KERN/OPAL
 |  | STANFIELD |  | NW-STANFIELD | GD-NW STANFIELD
 |  | SUMAS |  | IF-NWPL/CNBR-US | GDP-NTHWST/CANB
 |  | AECO |  | CGPR-AECO/USIM | [NAME]
 |  | CIG |  | IF-CIG/RKYMTN | GDP-CIG/RKYMTN
 |  | Ontario Region Notional
 |  | Central Region Notional
 |  | East & Texas Region Notional
 |  | Nymex
 |  | Nymex |  | GDP-HEHUB | NG
Spreadsheet: 456926d1461130993-copy-items-from-dropdown-list-to-new-sheets-meal-choices-16-04-15-new-test-b
Sheet: MIDDLE

 |  |  | M I D D L E
NAME | ADDRESS | JUICE | FROZENS | SOUP
 |  |  |  |  | BEEF / CHICKEN |  | PORK / LASAGNE |  | CHICK / MEATBALLS |  | S/SIDE / QUICHE |  | FISH / BOLOGNAISE
Client 1 |  | NO JUICE |  |  | CHICKEN PIE | [NAME] | LASAGNE | YOGHURT | CHICKEN FILLET | [NAME] | [NAME] | YOGHURT | BOLOGNAISE | [NAME] |  |  |  | Week 1 | Main 1 | Main 2 | Diabetic Sweet | Sweet | Soup
Client 2 |  | ORANGE JUICE |  |  | CHICKEN PIE | YOGHURT | LASAGNE | YOGHURT | MEATBALLS | YOGHURT | [NAME] | YOGHURT | CRUMBED FISH | YOGHURT |  |  |  | Monday | [NAME] | Quiche Lorraine | [NAME] |  | Tomato
Client 3 |  | ORANGE JUICE |  |  | CHICKEN PIE | JELLY |  |  |  |  |  |  |  |  |  |  |  | Tuesday | Baked Fish | [NAME] | Apple Peach & Custard |  | Beef & Veg
Client 4 |  | ORANGE JUICE |  |  | CHICKEN PIE | JELLY |  |  |  |  |  |  |  |  |  | no corn |  | Wednesday | Curried Sausages | Crumbed Chicken | Pears & Custard |  | Chicken
Client 5 |  | APPLE JUICE |  |  | CHICKEN PIE | JELLY |  |  |  |  |  |  |  |  |  |  |  | Thursday | [NAME] | Roast Beef & Veg | Berry Cream Cheesecake |  | Veg
Client 6 |  | NO JUICE |  |  | ROAST BEEF | [NAME] | PORK STEAK | [NAME] | MEATBALLS | [NAME] | QUICHE | [NAME] | BOLOGNAISE | [NAME] |  | 2 pub meals |  | Friday | Crumbed Fish | [NAME] | Fruit & Custard | Banana Bread & Custard | Pumpkin
Client 7 |  | APPLE JUICE |  |  | ROAST BEEF | JELLY | PORK STEAK | YOGHURT | MEATBALLS | JELLY | [NAME] | YOGHURT | CRUMBED FISH | JELLY
Client 8 |  | ORANGE JUICE |  |  | ROAST BEEF | JELLY |  |  |  |  | QUICHE
Client 9 |  | APPLE JUICE |  |  | ROAST BEEF | [NAME] | PORK STEAK | [NAME] | MEATBALLS | YOGHURT | [NAME] | [NAME] | FISH | YOGHURT |  | no corn
Client 10 |  | NO JUICE |  |  | ROAST BEEF | JELLY | LASAGNE | [NAME] | CHICKEN FILLET | [NAME] | [NAME] | [NAME] | CRUMBED FISH | [NAME]
Client 11 |  | NO JUICE | 7 FROZ (Meal only) |  | FROZENS |  | FROZENS |  | FROZENS |  | FROZENS |  | FROZENS
Client 12 |  | ORANGE JUICE |  |  | CHICKEN PIE | JELLY
Client 13 |  | ORANGE JUICE | 2 froz, sw, ju |  | ROAST BEEF | [NAME] |  |  | CHICKEN FILLET | [NAME] |  |  | CRUMBED FISH | [NAME]
Client 14 |  | NO JUICE | 1 froz,sw ju |  | CHICKEN PIE | JELLY
Client 15 |  | NO JUICE |  |  | ROAST BEEF | JELLY | PORK STEAK |  | MEATBALLS |  |  |  | BOLOGNAISE
Client 16 |  | APPLE JUICE |  |  | ROAST BEEF | YOGHURT | LASAGNE | YOGHURT | CHICKEN FILLET | YOGHURT | [NAME] | YOGHURT | CRUMBED FISH | YOGHURT
Client 17 |  | APPLE JUICE |  |  | ROAST BEEF | YOGHURT | LASAGNE | YOGHURT | CHICKEN FILLET | YOGHURT | [NAME] | YOGHURT | CRUMBED FISH | YOGHURT
Client 18
Client 19
Client 20
Client 21
Client 22
Client 23
Client 24
Client 25
Client 26
Spreadsheet: 110055d1306849177-excel-2007-copying-conditional-format-rule-778112-copying-conditional-format
Sheet: Actions

 | Item No. | Raised | Description | Priority | Owner | Status | Deadline | Update | Closed | Comments/Detail
 | 001 |  |  |  |  | Closed
 | 002 |  |  |  |  | Closed
 | 003 |  |  |  |  | Open
 | 004 |  |  |  |  | Closed
 | 005 |  |  |  |  | Open
 | 006 |  |  |  |  | Open
 | 007 |  |  |  |  | Open
 | 008 |  |  |  |  | Open
 | 009 |  |  |  |  | Open
 | 010 |  |  |  |  | Closed
 |  |  |  |  |  |  | Status
 |  |  |  |  |  |  | Open
 |  |  |  |  |  |  | Closed
Spreadsheet: 709720d1608522308-help-with-ipmt-formulas-for-advance-payments-on-a-loan-amortization-schedule-loan_amortization-2
Sheet: Beginning

Loan Amount
Residual Value
APR
[NAME] (m)
 |  | Residual Balance Realized Immediately upon Final Payment |  |  |  |  |  | Residual Balance Realized at the End of the Last Month
Month |  | Begin Balance | Payment | Interest | Principle | End Balance |  | Begin Balance | Payment | Interest | Principle | End Balance
0 |  |  |  | 0 |  |  |  |  |  | 0
Spreadsheet: 866031d1712956827-same-formula-for-different-workbook-book1
Sheet: TOTALS

Reg | LUNCH /2 | REG. HRS. | LUNCH+REG | OT1 | LUNCH+REG+OT | pto
Spreadsheet: 724603d1616255533-summing-columns-and-rows-using-dynamic-inputs-emails-issue-for-forumsumifs
Sheet: Sheet1

 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | George | Harold | Isabelle
2021-03-01 00:00:00 | 0 | 0 | 0 | 0 | 7 | 28 | 0 | 1 | 2 |  | Start | 2021-03-02 00:00:00
2021-03-02 00:00:00 | 0 | 0 | 0 | 0 | 22 | 9 | 15 | 66 | 9 |  | End | 2021-03-08 00:00:00
2021-03-03 00:00:00 | 0 | 0 | 0 | 0 | 68 | 24 | 26 | 2 | 23 |  | Name | [NAME]
2021-03-04 00:00:00 | 0 | 0 | 0 | 0 | 12 | 9 | 10 | 10 | 90
2021-03-05 00:00:00 | 0 | 0 | 0 | 0 | 52 | 18 | 4 | 33 | 9 |  |  | SUM |  | Array
2021-03-06 00:00:00 | 30 |  |  |  | 32 |  | 67 | 74 |  |  | Output:
2021-03-07 00:00:00
2021-03-08 00:00:00 | 0 | 121 | 0 | 0 | 0 | 0 | 0 | 8 | 8 |  | Example: | 186 |  | 2021-03-02 00:00:00 | 22
2021-03-09 00:00:00 | 0 | 63 | 0 | 0 | 0 | 0 | 58 | 91 | 12 |  |  |  |  | 2021-03-03 00:00:00 | 68
2021-03-10 00:00:00 | 0 | 27 | 0 | 0 | 0 | 26 | 22 | 26 | 81 |  |  |  |  | 2021-03-04 00:00:00 | 12
2021-03-11 00:00:00 | 0 | 59 | 0 | 0 | 0 | 64 | 27 | 40 | 27 |  |  |  |  | 2021-03-05 00:00:00 | 52
2021-03-12 00:00:00 | 0 | 43 | 0 | 0 | 41 | 11 | 12 | 48 | 16 |  |  |  |  | 2021-03-06 00:00:00 | 32
2021-03-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-03-07 00:00:00
2021-03-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-03-08 00:00:00 | 0
2021-03-15 00:00:00 | 0 | 0 | 24 | 0 | 24 | 10 | 14 | 10 | 84
2021-03-16 00:00:00 | 0 | 0 | 25 | 0 | 36 | 15 | 78 | 79 | 0
2021-03-17 00:00:00 | 0 | 0 | 62 | 0 | 65 | 17 | 14 | 22 | 0
Spreadsheet: 829758d1684425122-need-to-add-cells-j9-j16-for-all-icoy-working-capital-inside-ifna-formula-feb23-trial-balances-lse-test
Sheet: 411750 - Accrued Expenses 

Entity | 390072
Gl Account | 411750
Ending Balance
Accruals
Soft Cost
DM Fee
WIP
Interest
RET
Deposit -Unit | 279857.61
Prior Draw Unpaid Invoices
Total
Variance to TB
Entity | 390062
Gl Account | 411750
Ending Balance
Accruals
Soft Cost
DM Fee
WIP
Interest
RET | 0
Deposit -Unit | 0
Total
Variance to TB
Spreadsheet: 355808d1414787513-move-a-row-to-a-new-sheet-based-on-a-cells-value-job-requisition-workbook
Sheet: OGALLALA AL

Welcov Assisted Living at Ogallala |  |  |  | Director: [NAME] DOHS: [NAME] |  | EEO: Phone: [PHONE]
Requisition # | Job Title | Department | [NAME] | Position Open | Offer Accepted | Shift | Reason for Opening | Days Open | Satus
WALOG14002 | Housekeeper | Environmental Services | 9 | 2014-10-30 00:00:00 |  | FT NIGHT | New Position
WALOG14001 | Medication Aide | Nursing | 12 | 2014-10-30 00:00:00 |  | FT NIGHT | New Position
Spreadsheet: 833104d1686789628-formula-to-see-if-a-date-and-other-criteria-are-within-a-range-book1
Sheet: Sheet1

Country | App | Show | Start | End |  |  |  | Date Lookup | 2023-06-14 00:00:00
USA | Netflix | Stranger Things | 2023-06-01 00:00:00 | 2023-06-30 00:00:00
USA | Netflix | I Think You Should Leave | 2023-06-01 00:00:00 | 2023-06-15 00:00:00 |  |  |  | Country | App | Live Shows
USA | Disney+ | The Mandolorian | 2023-06-01 00:00:00 | 2023-06-15 00:00:00 |  |  |  | USA | Netflix
USA | Disney+ | Loki | 2023-07-01 00:00:00 | 2023-07-20 00:00:00 |  |  |  | USA | Disney+
USA | HBO Max | Succession | 2023-06-15 00:00:00 | 2023-07-20 00:00:00 |  |  |  | USA | HBO Max
USA | HBO Max | House of the Dragon | 2023-08-01 00:00:00 | 2023-08-30 00:00:00 |  |  |  | Canada | Netflix
Canada | Netflix | Stranger Things | 2023-06-01 00:00:00 | 2023-06-30 00:00:00 |  |  |  | Canada | Disney+
Canada | Disney+ | The Mandolorian | 2023-06-01 00:00:00 | 2023-06-30 00:00:00
Canada | Disney+ | Loki | 2023-07-01 00:00:00 | 2023-07-20 00:00:00
Canada | Netflix | Breaking Bad | 2023-06-15 00:00:00 | 2023-07-15 00:00:00
Spreadsheet: 264531d1378909556-consolidating-duplicate-data-and-recording-of-duplicates-copy-of-help-me-
Sheet: Sheet1

Alarm | Occurrence |  | Row Labels | Sum of Occurrence
alarm 1 | 1 |  | alarm 1 | 13
alarm 1 | 1 |  | alarm 3 | 15
alarm 1 | 1 |  | (blank)
alarm 1 | 1 |  | Grand Total | 28
alarm 1 | 1
alarm 1 | 1
alarm 1 | 1
alarm 1 | 1
alarm 1 | 1
alarm 1 | 1
alarm 1 | 1
alarm 1 | 1
alarm 1 | 1
alarm 3 | 1
alarm 3 | 1
alarm 3 | 1
alarm 3 | 1
alarm 3 | 1
alarm 3 | 1
alarm 3 | 1
alarm 3 | 1
alarm 3 | 1
alarm 3 | 1
alarm 3 | 1
alarm 3 | 1
alarm 3 | 1
alarm 3 | 1
alarm 3 | 1
Spreadsheet: 21d5a073-5676-4124-afe5-7bbc0c478f45
Sheet: Sheet1

DAFTAR PESERTA PLPG RAYON 112 UNIVERSITAS NEGERI SEMARANG | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
TAHAP XIV GUGUS BADAN DIKLAT PROPINSI JATENG GEDUNG SUMBING
[NAME] Tanggal 13 s/d 22 Nopember 2011
Kelas | : [NAME]
No | No peserta | Nama | Sekolah | [NAME]
1 | [PHONE] | Muhaimin | MI [NAME] | Pati
2 | [PHONE] | [NAME] | MI Tarbiyatul Islam | Pati
3 | [PHONE] | Sumendar | MI Miftahul Ulum | Pati
4 | [PHONE] | BURHANUDIN PA | MI Sultan Agung 02 | Pati
5 | [PHONE] | Siti Ma'unah | MTs [NAME] | Pati
6 | [PHONE] | I'ANAH | MI NAHJATUL FALAH | Pati
7 | [PHONE] | MOH. DURI | MTs. MANAHIJUL HUDA | Pati
8 | [PHONE] | ZAENAL ARIFIN | MI  MANAHIJUL  HUDA NGAGEL | Pati
9 | [PHONE] | ISTIROKHAH | MI Naba'ul Ulum | Pati
10 | [PHONE] | Eko [NAME] | MI Raudhotul Falah | Pati
11 | [PHONE] | Siti Zunairoh | MI Matholiul Ulum | Pati
12 | [PHONE] | Sofwan | MI Al Hidayah | Pati
13 | [PHONE] | M. AKHWAN AS | MTs. Assyafi'iyyah | Pati
14 | [PHONE] | Rebin | MI Tarbiyatul Athfal | Pati
15 | [PHONE] | Risnayati | MI Manbaul Ulum | Pati
16 | [PHONE] | PARNADI | MI MAMBAUL ULUM | Pati
17 | [PHONE] | Suharjo | MI Nihayaturroghibin | Pati
18 | [PHONE] | [NAME] | MI Miftahul Huda Sukobubuk | Pati
19 | [PHONE] | [NAME] | MI Tarbiyatul Islamiyah | Pati
20 | [PHONE] | AKHMAD TAHRIR | MI MIFTAHUL HUDA | Pati
21 | [PHONE] | M. MU'TASHOM | [NAME] | Pati
22 | [PHONE] | Siti Markamah | MI Matholiul Ulum | Pati
23 | [PHONE] | Khotimah | MA Darul Falah | Pati
24 | [PHONE] | Hermawan Adi Nugroho | MTs [NAME] | Pati
25 | [PHONE] | RUMHIYYATI | MI TARBIYATUL ATHFAL | Pati
26 | [PHONE] | [NAME] | MI Tarbiyatul Islam 01 Wedusan | Pati
27 | [PHONE] | MASNAH | MTs [NAME] | Pati
28 | [PHONE] | SRI AYUMI | MTs. Tarbiyatul Aulad | Pati
29 | 11032021720057 | [NAME] | MTS MIFTAHUL ULUM | Jepara
30 | 11032121720001 | Asyhari | MA Yasua Pilangwetan | Demak
31 | 11032121720040 | Musyafaatun | MTs [NAME] | Demak
32 | 11032121720058 | Atik Fatmaniswati | MTs NU Serangan | Demak
33 | 11032121720087 | Eddy [NAME] | MA Takhassus Al qur'an | Demak
34 | 11032121720103 | [NAME] | MTsN Gajah | Demak
35 | 11032121720120 | Siti Nurus Sa'adah | MTs [NAME] | Demak
36 | 11032121720151 | Rochmatun,S.PdI | MTs Nurul Qur'an Purwosari | Demak
37 | 11032021720023 | AHMAD ROSYID | MTS MIFTAHUL ULUM TANJUNG | Jepara
38 | 11031922720094 | SITI MARFUTIHAH | MI NU MIFTAHUL MA'ARIF | Kudus
39 | 11031922720095 | ISTIANAH | MTS NU MUALLIMAT | Kudus
40 | 11031922720096 | ROHANAH | MTS NU TAMRINUT THULLAB | Kudus
Spreadsheet: 21713d1209565978-select-in-drop-down-box-to-a-different-drop-down-box-offset_dropdown
Sheet: Sheet1

Name 6 | Dropdown 1 |  | 7 | Horzontal Offset
 | Dropdown 2 |  | 15 | Vertical Offset (Hard Coded)
 |  |  | 3 | Qty Vertical (Avoids blanks in Validation List)
Names |  | Options
 |  | Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name 6
Name 1 | 2 | a | a | a | a | a | a
Name 2 | 3 | b | b | b | b | b | b
Name 3 | 4 | c | c | c | c | c | c
Name 4 | 5 | d | d | d | d | d
Name 5 | 6 | e | e | e | e
Name 6 | 7 | f | f | f
 |  | g | g
 |  | h
 |  | 8 | 7 | 6 | 5 | 4 | 3
Spreadsheet: 730046d1619522836-countifs-error-sample-book
Sheet: Sheet1

 | Total Value |  |  | No of accounts with spend above £200K
Customer Name | 0 |  |  | COUNTIFS(B3:B119,">200000",A3:A119)
a1 | 2665.85
a2 | 191.26
a3 | 184.43
a4 | 186
a5 | 2629
a6 | 574.1
a7 | 784.77
[NAME] | 8926.84
a9 | 3015.1
a10 | 1077.55
a11 | 1726.57
a12 | 1755.84
a13 | 12313.8
a14 | 791.67
a15 | 12778.02
a16 | 0
a17 | 3068.72
a18 | 4748.87
a19 | 1312.5
a20 | 1506.12
a21 | 0
a22 | 331.04
a23 | 100.14
a24 | 2810.88
a25 | 505.68
a26 | 155.08
a27 | 5191.2
a28 | 58960.57
a29 | 4619.59
a30 | 32.22
a31 | 168.75
a32 | 0
a33 | 1004.4
a34 | 28913.31
a35 | 1435.68
a36 | 1187.42
a37 | 2058.84
a38 | 1710.53
a39 | 2016.24
a40 | 168.8
a41 | 1968.53
a42 | 65.11
a43 | 12130.65
a44 | 4783.56
a45 | 3654.4
a46 | 241.97
a47 | 19768.84
a48 | 20232.14
a49 | 68756.61
a50 | 89.7
a51 | 73
a52 | 202.32
a53 | 2395.98
a54 | 5906.56
a55 | 1717.2
a56 | 85.68
a57 | 555.5
a58 | 1006.19
a59 | 1358.54
a60 | 850684.5
a61 | 855.21
a62 | 248
a63 | 8831.11
a64 | 124.35
a65 | 0
a66 | 798.71
a67 | 605.75
a68 | 702.26
a69 | 1044.2
a70 | 12749.1
[NAME] | 4078.49
a72 | 1545.94
a73 | 2926.69
a74 | 622.24
a75 | 7122.12
a76 | 2258.06
a77 | 2080
a78 | 1139.4
a79 | 463.79
a80 | 2194.47
a81 | 108.6
a82 | 94.2
a83 | 41.62
a84 | 26927.47
a85 | 88.2
a86 | 252.88
a87 | 12746.2
a88 | 0
a89 | 66.24
a90 | 0
a91 | 6382.1
a92 | 856.24
a93 | 744.48
a94 | 2244.86
a95 | 38645.13
a96 | 279.4
a97 | 0
a98 | 3855.01
a99 | 546
a100 | 272.08
[NAME] | 8863.64
a102 | 9011.69
a103 | 817.16
a104 | 1529.84
a105 | 2801.97
a106 | 621.5
a107 | 4440.67
a108 | 5141.55
a109 | 824.26
a110 | 1902.48
a111 | 1388.36
a112 | 1274.31
a113 | 220.8
a114 | 17756.36
[NAME] | 347141.25
a116 | 3646.71
a117 | 2126.74
Spreadsheet: 88665d1288477400-using-if-function-within-a-countifs-function-example
Sheet: Sheet1

Team | points for | Points Against |  |  |  | Team | Wins | Losses
XYZ | 20 | 10 |  |  |  | XYZ | 2 | 2
XYZ | 0 | 30 |  |  |  | FGH | 3 | 2
XYZ | 21 | 24
XYZ | 18 | 14
FGH | 24 | 27
FGH | 34 | 33
FGH | 14 | 13
FGH | 6 | 42
FGH | 40 | 14
Spreadsheet: 487137d1477932827-formula-to-consolidate-tables-consolidatetables2
Sheet: Table2

Code | Name | Age
A16 | [NAME]
R60 | [NAME]
A16 | [NAME]
R60 | [NAME]
R60 | [NAME]
69U | [NAME]
69U | [NAME]
A16 | [NAME]
R60 | [NAME]
R60 | Gavin
A16 | [NAME]