tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 866819d1713749664-combining-two-formulas-into-one-cell-combine-problem
Sheet: Sheet1

DATE | DAY | MIDO | MIDO | DAILY HIGH | DAYHIGH | DAILY LOW | DAYLOW | MIDOCLOSE | MIDOCLOSE | DRANGE | 5DADR | R+MIDO | R-MIDO | WBODY | HOWDAY | WHIGHTIME | WHIGH | LOWDAY | WLOWTIME | WLOW | WR
2024-04-14 00:00:00 | SUN | 2024-04-14 18:00:00 | 18151 | 2024-04-14 19:48:36 | 18255 | 2024-04-14 18:00:01 | 18146.75 | 2024-04-15 00:00:00 | 18230.75 | 108.25 |  | 104 | 4.25
2024-04-15 00:00:00 | MON | 2024-04-15 00:00:00 | 18231 | 2024-04-15 09:16:15 | 18350.75 | 2024-04-15 22:38:10 | 17795.75 | 2024-04-16 00:00:00 | 17846.5 | 555 | 337.7 | 119.75 | 435.25
2024-04-16 00:00:00 | TUE | 2024-04-16 00:00:00 | 17847 | 2024-04-16 14:12:21 | 17988 | 2024-04-16 06:25:26 | 17792 | 2024-04-17 00:00:00 | 17929 | 196 | 421 | 141 | 55
2024-04-17 00:00:00 | WED | 2024-04-17 00:00:00 | 17929.5 | 2024-04-17 09:27:41 | 17968.5 | 2024-04-17 12:46:31 | 17615.25 | 2024-04-18 00:00:00 | 17729.75 | 353.25 | 410.9 | 39 | 314.25
2024-04-18 00:00:00 | THU | 2024-04-18 00:00:00 | 17730 | 2024-04-18 02:22:56 | 17770.75 | 2024-04-18 22:20:07 | 17181.75 | 2024-04-19 00:00:00 | 17337.75 | 589 | 397.4 | 40.75 | 548.25
2024-04-19 00:00:00 | FRI | 2024-04-19 00:00:00 | 17338.5 | 2024-04-19 08:34:45 | 17553.25 | 2024-04-19 15:46:37 | 17113.25 | 2024-04-19 17:00:00 | 17179.25 | 440 | 429.05 | 214.75 | 225.25
Spreadsheet: 547585d1510636895-conditional-formatting-conditional-formating
Sheet: Sheet1

Check | Service | Country | Route | Year
Ok | X001 | AE | AG | 2017
Ok | X002 | IN | IS | 2017
Check | X003 | BH | AG | 2017
Ok | X005 | BE | EU | 2017
Ok | X009 | DE | EU | 2017
I would like to highlight the data when the column A value become "Check"
Spreadsheet: randall_gay__31452__32614_2
Sheet: Gen Consumables

 |  |  |  |  |  |  | List Total: |  |  |  | List Total: | Credit Total
Generator Consumable
LINE | CATALOG | CAT |  |  |  |  |  |  | SIMILAR-TO | UNIT
ITEM | NUMBER | LOC | PART NAME | PART DESCRIPTION | CYC | QTY | SYS PRICE | UM | DWG NUMBER | PRICE | LINE PRICE
 | ____________
1 |  |  | BAL WGT ASM (0.75 OZ/IN) | ROTOR ASSY | 8 | 6 | 159.39 |  | 0438B758G0001 | 159.39
2 |  |  | BALANCE WEIGHTS | ROTOR ASSY | 17 | 1 | 4688.71 |  | 0699L984G0001 | 4688.71
3 |  |  | BREATHER CAP | PIPING HARDWARE | 12 | 2 | 165.43 |  | 323B5821P0002 | 165.43
4 |  |  | CARBON BRUSH (W/PIGTAIL) | GROUND BRUSH RIGGING | 13 | 4 | 30.33 |  | 323B7989P0008 | 30.33
5 |  |  | GASKET | BASE ASSY | 5 | 2 | 9.24 |  | 314A2518P0001 | 9.24
6 |  |  | GASKET | BASE ASSY | 6 | 1 | 5.88 |  | 314A2553P0001 | 5.88
7 |  |  | GASKET | BASE ASSY | 6 | 60 | 1.68 |  | 0659A937P0017 | 1.68
8 |  |  | GASKET | OUTER FRAME | 5 | 20 | 0.42 |  | 0659A937P0036 | 0.42
9 |  |  | GASKET | OUTER FRAME | 6 | 2 | 14.28 |  | 341A1811P0001 | 14.28
10 |  |  | GASKET | WEB SUPPORT | 6 | 20 | 0.74 |  | 0659A937P0018 | 0.74
11 |  |  | GASKET | SHP LSE TW/BR/GL/GSHMS | 6 | 2 | 14.28 |  | 341A1811P0001 | 14.28
12 |  |  | GASKET | LINE BOX INSERT | 6 | 2 | 4.83 |  | 236B5451P0001 | 4.83
13 |  |  | GASKET | LINE BOX INSERT | 6 | 2 | 3.99 |  | 236B5451P0002 | 3.99
14 |  |  | GASKET(.25TX2.25WX30.50L) | COOL-PKG ASSY | 6 | 8 | 28.07 |  | 224B4026P0002 | 28.07
15 |  |  | GASKET(.25TX2.25WX33.00L) | COOL-PKG ASSY | 6 | 8 | 35.3 |  | 224B4026P0003 | 35.3
16 |  |  | GASKET,HEATER FLANGE | OUTER FRAME | 6 | 2 | 15.86 |  | 341A4032P0001 | 15.86
17 |  |  | GASKET-EDGE SEAL | ORT AIR SHLD/OV | 8 | 21 | 15.26 |  | 341A1812P0001 | 15.26
18 |  |  | GASKET-NEOPRENE(.50X3.00) | OUTER FRAME | 6 | 160 | 2.52 |  | 313A7331P0001 | 2.52
19 |  |  | GASKET-NEOPRENE(.50X3.00) | CE SEALING | 6 | 1 | 2.52 |  | 313A7331P0001 | 2.52
20 |  |  | GASKET-NEOPRENE(.50X3.00) | SHP LSE TW/BR/GL/GSHMS | 6 | 110 | 2.52 |  | 313A7331P0001 | 2.52
21 |  |  | GASKET-NEOPRENE(1.00X1.25 | TE-SEALING | 4 | 20 | 10.4 |  | 313A7331P0003 | 10.4
22 |  |  | GASKET-NEOPRENE(1.00X1.25 | CE SEALING | 4 | 20 | 10.4 |  | 313A7331P0003 | 10.4
23 |  |  | GASKET-SPIRAL WOUND(2.00) | OUTER FRAME | 6 | 2 | 6.09 |  | N5605P02001C1 | 6.09
24 |  |  | GASKET-SPIRAL WOUND(2.00) | MIST ELIMI FIELD MOD | 6 | 1 | 11.76 |  | N5605P02001G1 | 11.76
25 |  |  | GEN/BASE GASKET | GEN FINAL ASSY | 18 | 1 | 242.55 |  | 108E3072G0008 | 242.55
26 |  |  | LINE LEAD SEAL | LINE BOX INSERT | 6 | 3 | 6.93 |  | 341A6408P0001 | 6.93
27 |  |  | SEAL | STA FRM SEAL | 6 | 50 | 12.86 |  | 313A7323P0001 | 12.86
28 |  |  | SEAL | COOL-PKG ASSY | 6 | 22 | 12.86 |  | 313A7323P0001 | 12.86
Spreadsheet: 05791dbf-2995-470f-bad3-ff145007780b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | RESULTATS
 | CHAMPIONNAT DE France D 2 |  |  | 21 ET 22/11/2009
 | MASCULINS
 | CATEGORIE DE POIDS | PLACE | NOM, PRENOM | CLUB
 | -60kg | NC | PAOLOZZI HUGO | SGS
 |  | NC | JAAOUNAI KARIM | AJ 91 LM
 | [NAME] | NC | GINGREAU EDOUARD | SGS
 | [NAME] |  | DERET NILS | JC CHILLY-M/MORANGIS
 |  |  | ROLLIN GEOFFREY | JC CHILLY-M/MORANGIS
 |  |  | ANDRIEU BENJAMIN | AJ91LM
 |  | 7ème | EMILIEN LAURENT | SGS
 | [NAME] |  | DELSUC SEBASTIEN | SGS
 |  |  | [NAME] | AJ91LM
 |  | 3ème | [NAME] | SGS
 | [NAME] | 3ème | SOETENS LLYOD | JC CHILLY-M/MORANGIS
 |  |  |  | JC CHILLY-M/MORANGIS
 | [NAME] | 5ème | [NAME] | AJ91LM
 |  |  | [NAME] | JC CHILLY-M/MORANGIS
 | [NAME] |  | [NAME] | JC CHILLY-M/MORANGIS
 |  |  | [NAME] | AJ91LM
 |  |  | KEMOUCHE MEHDI | SGS
 | RESULTATS
 | CHAMPIONNAT DE France D 2 |  |  | 21 ET 22/11/2009
 | FEMININES
 | CATEGORIE DE POIDS | PLACE | NOM, PRENOM | CLUB
 | [NAME] | NC | ARGENTAIS EMILIE | SGS
 | [NAME] | NC | BOUCHARD CHARLOTTE | AJ91LM
 |  |  |  | ASVL SAINT-CHARLES
 | [NAME] | NC | ALIOUI SIHEM | JCO VIGNEUX
 |  | 3ème | BRUNET MORGANE | AJ91LM
 | -63 kg | 2ème | BOSSOREIL ANNE LISE | SGS
 |  |  |  | [NAME]
 | [NAME] | 7ème | THEPOT GAELLE | AJ91LM
 |  | NC | DELALLEE DIANE | AJ91LM
 |  |  |  | JC CHILLY-M/MORANGIS
 | -78 kg | 1ère | DELPLANQUE ALICE | AJ91LM
 | +78 kg
Spreadsheet: jeffrey_a_shankman__13928__JCC Swap Model-DPR (JH)
Sheet: Historical JCC

JCC and Brent Settlement History |  |  |  |  |  |  |  | Last Updated | 2001-09-01 00:00:00
 | JCC | JCC | Brent Swap
 | ($[NAME]) | (Y/kl) | ($[NAME])
1999-07-01 00:00:00 | 16.65332932811117 | 12749.12230082891 | 18.72913043478261
 | 18.50149689668075 | 13517.06652743127 | 20.43761904761904
 | 20.23939344200026 | 14033.48594667126 | 22.84272727272727
 | 22.58064740997939 | 15102.02064909287 | 22.24333333333333
 | 23.13429946606722 | 15303.53492864845 | 24.23863636363636
 | 24.66573449025636 | 16097.09339279099 | 25.157
 | 25.72399022394743 | 16771.54335232309 | 25.2215
 | 26.0111316219329 | 17458.09416254718 | 27.02809523809524
 | 26.82044286333781 | 18281.87471144807 | 27.27260869565217
 | 27.23586630253822 | 18169.62918987245 | 23.13611111111111
 | 25.11380639050319 | 16959.35953304795 | 27.4795238095238
 | 27.4255682661921 | 18457.02046837905 | 29.76090909090909
 | 29.32053882108823 | 19582.02546584327 | 28.66619047619047
 | 29.03762679348186 | 19851.99785516658 | 30.22545454545455
 | 29.34462277133854 | 19675.15911027147 | 32.33047619047619
 | 31.59055388129882 | 21424.39892140382 | 31.3859090909091
 | 32.35658126488899 | 22007.09487394486 | 32.38227272727272
 | 31.89365252142048 | 22225.17611826279 | 25.97
 | 25.59729603548353 | 18573.38940265538 | 25.83909090909091
 | 25.17010012749347 | 18425.90576618952 | 27.6345
 | 26.04898548893132 | 19364.58775360359 | 25.44863636363636
 | 25.90619804999269 | 20211.5466868886 | 26.39578947368421
 | 26.17626670557416 | 20187.00375084632 | 28.56086956521739
 | 27.63105509748073 | 21002.48275696745 | 27.8647619047619
 | 27.69620398160539 | 21663.37950969724 | 25.23727272727273
 | 25.9351991665067 | 20161.91666779935 | 25.72333333333334
 |  |  | 26.12473684210527
Spreadsheet: 802955d1667174820-sum-column-based-row-value-and-cell-get-column-and-sum
Sheet: Hours

Named | Project | 2022-10-08 00:00:00 | 2022-10-15 00:00:00 | 2022-10-22 00:00:00 | 2022-10-28 00:00:00 | on and on for a year
[NAME] | South | 30 | 20 | 15 | 32
Fred | North | 25 | 40 |  | 15
[NAME] | North | 5 | 10 | 15 | 20
[NAME] | South | 14 | 20 | 40 | 10
[NAME] | South | 10 | 20 | 20 | 8
[NAME] | North | 26 | 20 | 0 | 25
Spreadsheet: 22266d1210882152-multi-level-reporting-test-employee-file
Sheet: Alltel_kenexa_posns051108

Emp Id | Mgr Emp Id
1893 | 1712
1780 | 1431
1811 | 1712
1644 | 1431
1173 | 1680
1539 | 1680
1712 | 1200
1784 | 1712
1573 | 1431
1598 | 1539
1291 | 1539
1648 | 1712
1627 | 1431
1937 | 1539
1431 | 1200
1509 | 1937
1680 | 1712
1486 | 1431
1929 | 1937
1936 | 1937
Spreadsheet: 192ba249-fe18-4da5-955a-c8d0eaad435b
Sheet: Sheet1

TOURNOI NATIONAL DOUBLETTE HANDICAP | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
MILLAU les 7, 8, 9, 10 Novembre 2013
CLASSEMENT  GRANDE FINALE
 |  |  |  |  | TOTAL + HCP+BONUS
 | EQUIPE | NOMS | HCP | BONUS
1 | [NAME] | Larrieu / Combaluzier | 380 | 240 | 2519
2 | AURILLAC Leveque | Leveque / Leveillé | 410 | 180 | 2303
3 | [NAME] | [NAME] | 350 | 180 | 2224
4 | [NAME] | Cabot / Joseph | 400 | 120 | 2207
5 | CARCASSONNE | Piquemal / Giorgino | 230 | 120 | 2134
6 | NICE Avesque | Avesque / Consiglio | 375 | 60 | 2008
CLASSEMENT  PETITE FINALE
 |  |  |  |  | TOTAL + HCP+BONUS
 | EQUIPE | NOMS | HCP | BONUS
1 | MILLAU Noyrigat | Noyrigat A / Noyrigat V | 500 | 240 | 2425
2 | NARBONNE | Cerdan N / Cerdan V | 225 | 180 | 2330
3 | [NAME] | Mancino / Cohen | 315 | 150 | 2246
4 | ORLEANS | [NAME] | 320 | 120 | 2172
5 | MILLAU Devilliers | Forner / Devilliers | 385 | 90 | 2170
6 | [NAME] | Bogey / Voiret | 260 | 120 | 2141
Spreadsheet: 865972d1712913221-how-to-find-out-quantity-in-every-day-virtue-king-03-
Sheet: Result

NGÀY THÁNG 日期 | 管理部 BP Quản lý | 會計  Kế toán | 人事 Nhân sự | 總務 Tổng vụ | 人權 [NAME] quyền | 進出口 XNK | 採購 [NAME] | 生管  SINH QUẢN | [NAME] | 廠務 XƯỞNG | 机修 Bảo trì | 電腦車 MAY VI TÍNH | IT 資訊 | 外托 [NAME] công | 裁斷 CHẶT | 備料    BỊ LIỆU | 品檢 [NAME] phẩm | 包裝 ĐÓNG GÓI | quantity
2024-03-25 00:00:00
2024-03-26 00:00:00
2024-03-27 00:00:00
2024-03-28 00:00:00
2024-03-29 00:00:00
2024-03-30 00:00:00
2024-03-31 00:00:00
2024-04-01 00:00:00
2024-04-02 00:00:00
2024-04-03 00:00:00
2024-04-04 00:00:00
2024-04-05 00:00:00
2024-04-06 00:00:00
2024-04-07 00:00:00
2024-04-08 00:00:00
2024-04-09 00:00:00
2024-04-10 00:00:00
2024-04-11 00:00:00
2024-04-12 00:00:00
2024-04-13 00:00:00
2024-04-14 00:00:00
2024-04-15 00:00:00
2024-04-16 00:00:00
2024-04-17 00:00:00
2024-04-18 00:00:00
2024-04-19 00:00:00
2024-04-20 00:00:00
2024-04-21 00:00:00
2024-04-22 00:00:00
2024-04-23 00:00:00
2024-04-24 00:00:00
TOTAL
Spreadsheet: 754714d1636460893-xlookup-return-maximum-value-for-multiple-criteria-xlookup-return-max-value-example
Sheet: Sheet1

Type | Breed | DoB | Price | Age
Cat | Persian | 2021-01-03 00:00:00 | 1500 | 3
Dog | Labrador | 2021-06-02 00:00:00 | 1000 | 1
Cat | Siberian | 2021-08-31 00:00:00 | 2000 | 12
Dog | Husky | 2021-12-29 00:00:00 | 2500 | 4
Dog | Husky |  | 2000 | 4
Cat | Siberian |  | 1500 | 12
Spreadsheet: daren_farmer__5664__Tenaska IV 2000
Sheet: November 2000 Act.

Enron North America Corp
Summary of Gas Activity for Tenaska IV Partners, Ltd.
November 2000
November Sales
 | Counterparty | Volume | Dollars
 | Brazos Electric and Power | 1035000 | 2995290
 | Tenaska IV Partners | 255493 | 583801.51
 | Tenaska Marketing | 40000 | 171600
 | TXU Gas Distribution | 20000 | 87400
 | Total Sales per Unify |  |  | actual
November Purchases
 | Apache Marketing | -580000 | -1261500
 | [NAME] | -750000 | -2056725
 | TXU [NAME] |  | -26481.05
 | Total Purchases per Unify |  |  | actual
November Netout
 | Total Sales
 | Total Purchases
 | Amount due Enron from Plant
 | Agency Fee (1,350,493 x $0.04) |  | -54019.72 | actual
 | Payable to Tenaska IV Partners/(ENA): |  |  | actual
 | Calculation for Purchase Demand Fee: |  | 610780.5 | sale-Tenaska IV paid
 |  |  | 54000 | sale-Tenaska IV paid
 |  |  |  | due ENA |  |  |  | Unify Adjustments:
 |  |  |  | Total Due Tenaska IV |  |  |  | 152115.28 | demand fee change
 |  |  |  |  |  |  |  | -7340.95 | demand fee change
 |  | Paid 1/4/01 | 341250.46 |  |  |  |  | -19.72 | agency fee change
 |  |  |  |  |  |  |  | 34359.37 | Unify volume adj.
 |  | Due [NAME]
 |  |  |  |  |  |  |  | Difference:  $19.71
Spreadsheet: e02c87dc-d1ad-4eba-a932-86976da06fdb
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
9889 | Test | 9889 | Jones' Methenamine Silver Stain | Jones' [NAME] | Includes pathology consultation charged separately. | H & E Slide: HE |  |  |  | Varies | Container/Tube:  Preferred: Formalin-fixed, paraffin-embedded tissue block Acceptable: Tissue in formalin Collection Instructions: Include 1 hematoxylin-and-eosin stained slide. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | The laboratory will provide a pathology consultation and stained slide. | Monday through Friday 7 a.m. | 2 days | 5 days | 1 | 88313 |  |  |  |  | Rochester
9889 | [NAME] | MIXED | Mixed |  |  |  | Ambient
9889 | Result | 9889 | Jones' [NAME] | Jones' [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10792-0
Spreadsheet: 716497d1612239201-lookup-between-2-dates-and-return-value-lookup-help
Sheet: Sheet1

Pos | Start date | End date | [NAME] |  |  | Pos | Date | [NAME]
65006369 | 2012-11-02 00:00:00 | 2017-05-03 00:00:00 | 92096965 |  |  | 65006369 | 2013-01-01 00:00:00 | 92096965
65006390 | 2012-11-02 00:00:00 | 2013-03-10 00:00:00 | 92023335 |  |  | 65006369 | 2015-04-01 00:00:00 | 92096965
65006390 | 2013-03-11 00:00:00 | 2013-06-17 00:00:00 | 92029385 |  |  | 65006390 | 2013-01-01 00:00:00 | 92023335
65006390 | 2013-06-18 00:00:00 | 2014-11-30 00:00:00 | 92023475 |  |  | 65006390 | 2015-04-01 00:00:00 | 93259976
65006390 | 2014-12-01 00:00:00 | 9999-12-31 00:00:00 | 93259976 |  |  | 65006434 | 2013-01-01 00:00:00 | 92029250
65006434 | 2012-11-05 00:00:00 | 2015-04-15 00:00:00 | 92029250 |  |  | 65006434 | 2015-04-01 00:00:00 | 92029250
65006434 | 2015-04-16 00:00:00 | 2015-05-20 00:00:00 | 92099876
65006434 | 2015-05-21 00:00:00 | 2018-11-11 00:00:00 | 92029250
Spreadsheet: 75813d1276391717-sumproduct-sumproduct
Sheet: Sheet1

 | OK
 |  |  |  | user1 |  |  |  | =SUMPRODUCT((user_grp1=E3)*(table1))
 |  |  |  | user2 |  |  |  | =SUMPRODUCT((user_grp1=E4)*(ABS(table1)))
 |  |  |  | user1 |  | -1 | 2 | 3 | 9 | -3 | 5
 |  |  |  | user2 |  | 0 | 4 | 0 | 0 | 8 | 0
 | Not OK |  |  | user3
 |  |  |  | user4
 |  |  |  | user3 |  | 9 | 2 | 7 | 7 | -3 | 5
 |  |  |  | user4 |  | # | 1 | 0 | 3 | 8 | 0
 | I need to have a formula in cells G14 and [NAME] that SUM with ABS the values on "table2" based on cells E14 and E15, ignoring th "#"
 | Note: See NAME MANAGER
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 9c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis* | 133002 | 70708 | 152232 | <1,000 |  | <1,000 |  | <1,000 |  | 355942
FRA |  |  | 463181 | 130160 |  | 346446 |  | 917925 |  | 1857712
IRS- [NAME] | 2495150 | 2937529 | 1492148 | 103904 |  | 281471 | 564172 | 1008448 | 453896 | 9336718
OIS |  | 383599 | 71916 |  |  |  |  |  |  | 455515
VNS
Zero Coupon | 7589 | <1,000 |  |  |  |  |  | <1,000 |  | 7589
TOTAL | 2635741 | 3391836 | 2179477 | 234065 |  | 627917 | 564172 | 1926373 | 453896 | 12013477
Estimated gross notional amount outstanding, August 16 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 92166d1291823110-lookup-for-specific-values-in-multiple-cells-export
Sheet: PDCGrade

PDCGrade | Ingredient | LowerLimit | UpperLimit | LowerSecLimit | UpperSecLimit
JU12A |  | 4.44 | 5.66
KU32A | Copper
KU32A
KU32A
KU32A
KU32A
KU32A
KU32A
KU32A
KU32A
KU32A
KU32A
KU32A
KU32A
Spreadsheet: 821152d1678467375-sum-group-of-values-then-collapse-s666-pq-sum-group-of-values-then-collapse
Sheet: Calculation (ILLUSTRATION ONLY)

id | name | unused | unused2 | unused3 | count | sum_count
455387 | apple | 40354 |  | Enter | 33 |  |  | Sum the count by their respective grouping only (either thru the "id" or "name", whichever is more convenient or doable)
455387 | apple | 40387 |  | Exit | blank
455387 | apple | 40541 |  | Enter | 440
455387 | apple | 40981 |  | Exit | blank
422727 | mango | 39034 |  | Enter | 18
422727 | mango | 39052 |  | Exit | blank
251700 | cherry | 40598 |  | Enter | 578
251700 | cherry | 41176 |  | Exit | blank
251700 | cherry | 41219 |  | Enter | 73
251700 | cherry | 41292 |  | Exit | blank
251700 | cherry | 41857 |  | Enter | 168
251700 | cherry | 42025 |  | Exit | blank
Spreadsheet: louise_kitchen__22736__Turbine Position Report 032301
Sheet: Summary by Type

Turbine Position Report |  |  |  |  |  |  |  | CONFIDENTIAL
Summary by Turbine Type
($ MMs) |  |  |  |  |  |  |  | DRAFT
 |  |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | PROJECT(S) | DASH APPROVAL DATE / STATUS | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION | STATUS
 |  |  |  |  |  |  |  | Available
 |  |  |  | total per above
 |  |  |  | per Summary By [NAME] report
 |  |  |  | Difference
Spreadsheet: 0c47f5ca-d53d-4c43-9178-23fde728b772
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
 | 6202.0 Labour Force, Australia
 | Table 11. Labour force status by Sex - Australian Capital Territory - Trend and Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Employed - full-time ;  [NAME] ; |  |  | Trend | A184182L | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | 000 | STOCK | Month | 1
Employed - full-time ;  Females ; |  |  | Trend | A184199J | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | 000 | STOCK | Month | 1
Employed - full-time ;  Persons ; |  |  | Trend | A184216X | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | 000 | STOCK | Month | 1
Employed - total ;  [NAME] ; |  |  | Trend | A184184T | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | 000 | STOCK | Month | 1
Employed - total ;  Females ; |  |  | Trend | A184201J | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | 000 | STOCK | Month | 1
Employed - total ;  Persons ; |  |  | Trend | A184218C | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | 000 | STOCK | Month | 1
Unemployed - total ;  [NAME] ; |  |  | Trend | A184187X | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | 000 | STOCK | Month | 1
Unemployed - total ;  Females ; |  |  | Trend | A184204R | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | 000 | STOCK | Month | 1
Unemployed - total ;  Persons ; |  |  | Trend | A184221T | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | 000 | STOCK | Month | 1
Unemployment rate ;  [NAME] ; |  |  | Trend | A184194W | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | Percent | PERCENT | Month | 1
Unemployment rate ;  Females ; |  |  | Trend | A184211L | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | Percent | PERCENT | Month | 1
Unemployment rate ;  Persons ; |  |  | Trend | A184228J | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | Percent | PERCENT | Month | 1
Participation rate ;  [NAME] ; |  |  | Trend | A184193V | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | Percent | PERCENT | Month | 1
Participation rate ;  Females ; |  |  | Trend | A184210K | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | Percent | PERCENT | Month | 1
Participation rate ;  Persons ; |  |  | Trend | A184227F | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | Percent | PERCENT | Month | 1
Civilian population ;  [NAME] ; |  |  | Original | A163537W | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | 000 | STOCK | Month | 1
Civilian population ;  Females ; |  |  | Original | A163554X | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | 000 | STOCK | Month | 1
Civilian population ;  Persons ; |  |  | Original | A163571A | 1978-02-01 00:00:00 | 2012-11-01 00:00:00 | 418 | 000 | STOCK | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 838498d1691068961-formula-help-to-add-recurring-number-sequence-up-to-a-limit-and-age-formula-excel-query1
Sheet: Sheet1

DOB | Event Date | Age at event | Until age | Result date
1957-08-11 00:00:00 | 2012-03-16 00:00:00 |  | 66 | [NAME] result date would be 11/08/1969
1958-08-11 00:00:00 | 2012-03-16 00:00:00 |  | 66 | [NAME] result date would be 11/08/1973
 |  |  |  | ( formula to add every 3 years until reaching "until age" - (to include the last full 3 year period either before or after the until age date))
Example 1 |  | Looking for a formula which adds continuous 3 years increments up to the "Until Age" input number in column D
 | plus 3 years | 57 years 217 days
 | plus 3 years | 60 years 217 days
 | plus 3 years | 63 years 217 days |  | Then as per this example adds the 12 years to give the date at that age
 | plus 3 years | 66 years 217 days |  | Date at 66 years 217days = 11/08/1969
Example 2 |  | Looking for a formula which adds continuous 3 years increments up to the "Until Age" input number in column D
 | plus 3 years | 56 years 217 days
 | plus 3 years | 59 years 217 days
 | plus 3 years | 62 years 217 days
 | plus 3 years | 65 years 217 days
 | plus 3 years | 68 years 217 days |  | Then as per this example adds the 15 years to give the date at that age
Spreadsheet: 856567d1705768845-retrieving-and-moving-transferring-data-latest-problem-tashface-
Sheet: Wk1

 | Main Total
1 | Week | Month | Year | Value
Spreadsheet: 07da40f0-6113-4109-bc2e-8a64e5f690d2
Sheet: Sheet1

2015-2016 Class Schedule | 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 | Unnamed: 16 | Unnamed: 17 | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected. | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
Criminal Justice and Forensic Science
Summer 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 182014d1348238539-a-pick-list-that-defines-another-pick-list-picklistexample
Sheet: Data

Department | Sub Department
Accounting | Tax
Accounting | Filings
Accounting | Payroll
Communications | Emergency
Communications | General
Communications | Press Releases
Legal | Contracts
Legal | Litigation
Human Resources | Onboarding
Human Resources | Training
Human Resources | Resourcing