tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 47864d1247035625-conditional-summing-of-cell-with-multiple-conditions-catdog
Sheet: Sheet1

If 1 = cat | If 1=cat & 2=dog |  | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2
3 | ? |  | cat f | dog | dog | cat f | cat m | cat m | dog | dog | dog | dog | dog | cat f | cat m | cat m | dog | dog
5 |  |  | cat f | cat m | cat f | dog | dog | cat f | cat m | cat m | dog | dog | cat f | dog | dog | cat f | cat m | cat m
4 |  |  | dog | dog | dog | dog | cat f | cat m | cat m | dog | dog | cat f | dog | dog | cat f | cat m | cat m | dog
5 |  |  | cat f | cat m | cat f | dog | dog | cat f | cat m | cat m | dog | dog | cat f | dog | dog | cat f | cat m | cat m
4 |  |  | dog | dog | dog | dog | cat f | cat m | cat m | dog | dog | cat f | dog | dog | cat f | cat m | cat m | dog
5 |  |  | cat f | cat m | cat f | dog | dog | cat f | cat m | cat m | dog | dog | cat f | dog | dog | cat f | cat m | cat m
4 |  |  | dog | dog | dog | dog | cat f | cat m | cat m | dog | dog | cat f | dog | dog | cat f | cat m | cat m | dog
5 |  |  | cat f | cat m | cat f | dog | dog | cat f | cat m | cat m | dog | dog | cat f | dog | dog | cat f | cat m | cat m
4 |  |  | dog | dog | dog | dog | cat f | cat m | cat m | dog | dog | cat f | dog | dog | cat f | cat m | cat m | dog
5 |  |  | cat f | cat m | cat f | dog | dog | cat f | cat m | cat m | dog | dog | cat f | dog | dog | cat f | cat m | cat m
4 |  |  | dog | dog | dog | dog | cat f | cat m | cat m | dog | dog | cat f | dog | dog | cat f | cat m | cat m | dog
5 |  |  | cat f | cat m | cat f | dog | dog | cat f | cat m | cat m | dog | dog | cat f | dog | dog | cat f | cat m | cat m
4 |  |  | dog | dog | dog | dog | cat f | cat m | cat m | dog | dog | cat f | dog | dog | cat f | cat m | cat m | dog
Spreadsheet: 811719d1672760109-multiple-cells-data-based-on-adjacent-drop-down-list-contacts
Sheet: Companies

Company | Contact | [NAME] | Phone
Company 1 | [NAME] |  | 0121 333444
Company 2 | Theresa |  | 0232 111444
Company 3 | [NAME] |  | 0161 222777
Company 4 | [NAME] |  | 0171 111888
Spreadsheet: 883473d1732094715-use-the-other-formula-instead-of-vlookup-formula-file-a-vehile-ecel-help-forum-4
Sheet: data

date | epi# | name | design | slip no. | date | date end | start time | end time | type | reg# | make | capacity | start reading | end reading | Total | PLACE | PURPOSE
2024-11-12 00:00:00 | 0001-01 | Mr.[NAME] | Director | x | 12.11.2024 |  | 11:05:00 | 12:05:00 | Van | ABC-1234 | [NAME] | 800cc | 6800 | 6810 |  | Godown | Site visit
2024-11-11 00:00:00 | 0001-10 | Mr.[NAME] | Manager | y | 11.11.2024 |  | 11:40:00 | 16:40:00 | Toyota [NAME] | LED-8556 | Toyota | 3000CC | 115056 | 115080 |  | Factory | Check the material
2024-11-13 00:00:00 | 001-08 | Mr.[NAME] | Sr.Manager | 3 | 13.11.2024 | 13.11.2024 | 10:30:00 | 12:30:00 | Car | XYZ-4567 | Toyota | 1300CC | 7000 | 7030 |  | Factory sites | Sites visit
Spreadsheet: 0530f440-f325-4797-8dbf-912b86e6875f
Sheet: Sheet1

UNIVERSAL HEALTH SERVICES INC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
8-K
04/25/2014
UNIVERSAL HEALTH SERVICES, INC.
DELAWARE |  | 1-10765 |  | 23-2077891
(State or other jurisdiction of |  | (Commission |  | (I.R.S. Employer
Incorporation or Organization) |  | File Number) |  | Identification No.)
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 116342d1311768563-index-and-match-based-on-max-date-sample-check
Sheet: Sheet1

Customer | Customer No | Status A | Status B
A1 | A111
A2 | A222
A3 | A333
A4 | A444
A5 | A555
A6 | A666
A7 | A777
A8 | A888
A9 | A999
A10 | A1110
A11 | [NAME]
A12 | [NAME]
A13 | A1443
A14 | A1554
A15 | A1665
A16 | A1776
A17 | A1887
A18 | A1998
A19 | A2109
A20 | A2220
A21 | A2331
A22 | A2442
A23 | A2553
A24 | A2664
A25 | A2775
A26 | A2886
A27 | A2997
A28 | A3108
A29 | A3219
A30 | A3330
A31 | A3441
A32 | A3552
A33 | A3663
A34 | A3774
[NAME] | A3885
A36 | A3996
A37 | A4107
A38 | A4218
A39 | A4329
A40 | A4440
A41 | A4551
A42 | A4662
A43 | A4773
[NAME] | [NAME]
A45 | A4995
A46 | A5106
A47 | A5217
A48 | A5328
A49 | A5439
[NAME] | A5550
A51 | A5661
A52 | A5772
A53 | A5883
[NAME] | A5994
A55 | A6105
[NAME] | A6216
A57 | A6327
A58 | A6438
A59 | A6549
A60 | A6660
A61 | A6771
A62 | A6882
Spreadsheet: 81125d1281383222-finding-matching-items-example1
Sheet: Table B

hkjhk | 1234
hjhd | 2345
kjhkjhd | 1235
lkhkjds | 22345
;[NAME] | 1236
lkjlkjd | 22345
l;kjlkjasd | 4567
djkl;k | 2345
dlk;l | 2346
[NAME] | 3345
Spreadsheet: 877721d1724573777-sumifs-only-positive-numbers-with-different-criteria-set-demo-sumifs-250824
Sheet: Demo

GST balance
Code | Month | [NAME] | Amount | S name | Cat
1 | 2024-07-01 00:00:00 | TN 1 | -3765063.79999999 | GST TN | GST July balance
2 | 2024-07-01 00:00:00 | TN 2 | -3765063.79999999 | GST TN | GST July balance
3 | 2024-05-01 00:00:00 | TN 3 | -12810017.7799999 | GST TN | GST May balance
4 | 2024-07-01 00:00:00 | TN 4 | 38994178.4699999 | GST TN | GST July balance
5 | 2024-07-01 00:00:00 | TN 5 | 38994178.4699999 | GST TN | GST July balance
6 | 2024-07-01 00:00:00 | TN 6 | 744112812.559999 | GST TN | GST July balance
7 | 2024-07-01 00:00:00 | TN 7 | -55025113.02 | GST TN | GST July balance
8 | 2024-05-01 00:00:00 | TN 8 | -14706912.02 | GST TN | GST May balance
9 | 2024-07-01 00:00:00 | TN 9 | 92339710.3599999 | GST TN | GST July balance
10 | 2024-05-01 00:00:00 | TN 10 | 123878.28 | GST TN | GST May balance
11 | 2024-07-01 00:00:00 | TN 11 | 123878.28 | GST TN | GST July balance
12 | 2024-07-01 00:00:00 | TN 12 | 103298.44 | GST TN | GST July balance
13 | 2024-07-01 00:00:00 | TN 13 | -803464998.639999 | GST TN | GST July balance
 |  | Total
 |  |  | 914668056.5799987 | Positive | GST July balance
 |  |  | -866020239.259999 | Negetive | GST July balance
 |  |  | 123878.28 | Positive | GST May balance
 |  |  | -27516929.7999999 | Negetive | GST May balance
Spreadsheet: mary_fischer__25637__31T
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031T
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other
Gross PP & E
Accumulated DD & A
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
 |  |  |  |  |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: michelle_lokay__26799__sharris0700wk3
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  | July, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
West Demand Revenues |  | 9.8464 | 9.886147939999999 | 0.03974793999999982 |  | Rates for 63/day in excess of $0.12/mmbtu in plan
West Commodity Revenues |  | 0.7731999999999999 | 0.7796404943 | 0.006440494300000155 |  | 977/day west through the 19th
East Demand Revenues |  | 1.1254 | 0.9716890015 | -0.1537109985000001 |  | Burlington 24216--($53k), [NAME])
East Commodity Revenues |  | 0.1709 | 0.24726098714 | 0.07636098714 |  | Higher east volumes
[NAME] |  | 0.6644000000000001 | 0.6474582499999999 | -0.0169417500000002
[NAME] Revenues |  | 0.05890000000000001 | 0.1484711491 | 0.08957114910000002 |  | higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance |  | 12.6382 | 12.68066782204 | 0.04246782204000077
[NAME] due to Price |  |  |  | 0.6053290066473013 |  | Current index price of $3.92
[NAME] due to transport volumes |  |  |  | -0.193234117983775
Hedging Adjustment |  |  |  | -0.08369999999999993
Unaccounted for Variance |  |  |  | -0.019
 |  |  |  | -------------
Fuel Variance |  |  |  | 0.3093948886635263
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE |  |  |  | 0.3518627107035271
 |  |  |  | ========
[NAME]
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (throughJune) |  | 84.7768 | 11.7072 | 96.484
Actuals through May, June and July est. |  | 84.60526782203999 | 14.3025 | 98.90776782204
 |  | ------------- | ------------- | -------------
Variance from Plan |  | -0.1715321779600032 | 2.595299999999998 | 2.423767822039995
 |  | ------------- | ------------- | -------------
Spreadsheet: 24691d1215435198-game-tasking-games
Sheet: Sheet1

names |  | time | game 1 | game 2 | game 3 | game 4 | game 5 | game 6
martin
[NAME] |  | 10:00 | martin | mark | [NAME] | fred | [NAME] | mary
mary |  |  | v | v | v | v | v | v
viv |  |  | [NAME] | helen | sid | [NAME] | [NAME] | viv
[NAME]
[NAME] |  | 10:30 | mary | martin | mark | [NAME] | fred | [NAME]
fred |  |  | v | v | v | v | v | v
[NAME] |  |  | viv | [NAME] | helen | sid | [NAME] | [NAME]
[NAME]
sid |  | 11:00 | [NAME] | mary | martin | mark | [NAME] | fred
mark |  |  | v | v | v | v | v | v
helen |  |  | [NAME] | viv | [NAME] | helen | sid | [NAME]
 |  | 11:30 | fred | [NAME] | mary | martin | mark | [NAME]
 |  |  | v | v | v | v | v | v
 |  |  | [NAME] | [NAME] | viv | [NAME] | helen | sid
 |  | 12:00 | [NAME] | fred | [NAME] | mary | martin | mark
 |  |  | v | v | v | v | v | v
 |  |  | sid | [NAME] | [NAME] | viv | [NAME] | helen
 |  | 12:30 | mark | [NAME] | fred | [NAME] | mary | martin
 |  |  | v | v | v | v | v | v
 |  |  | helen | sid | [NAME] | [NAME] | viv | [NAME]
Spreadsheet: hunter_shively__12738__EnovateDPR0116
Sheet: 5 Day Roll

ENRON CAPITAL AND TRADE RESOURCES
 |  | DO NOT TOUCH!! | ONLY RUN BEFORE YOU LINK ANY NEW ROLLS!!
Commodity | 5 Day Rolling Total | Current Day | Current Day-1 | Current Day-2 | Current Day-3 | Current Day-4
ENA Gas Trading
Short Term Gas |  |  | 10.61723725999802 | -50.20831987300177 | -168.1440735500014 | 87.82937327400799
 |  | 13 | 12 | 11 | 10 | 7 | 6
 |  | 17 | 84 | 12 | -54 | 19 | -53
Spreadsheet: 758978d1639207980-copy-and-paste-retain-certain-cells-values-in-a-formula-help-forum
Sheet: Sheet2

3 | 4
 |  |  |  | [NAME]
 | 5 | 7
 | 2 | 8
 | 9 | 5
 | 10 | 3
 | 8 | 8
 | 1 | 1
 | 5 | 3
 | 1 | 1
 | 3 | 2
 | 1 | 1
 | 2 | 5
 | 1 | 7
 | 4 | 1
 | 4 | 7
 | 2 | 5
 | 4 | 4
 | 2 | 6
 | 8 | 6
 | 9 | 10
 | 9 | 6
 | 6 | 5
 | 3 | 7
 | 6 | 1
 | 1 | 2
 | 6 | 7
 | 8 | 5
 | 4 | 8
 | 2 | 8
 | 5 | 1
 | 4 | 8
 | 10 | 6
 | 3 | 3
 | 2 | 2
 | 5 | 6
 | 7 | 4
 | 3 | 9
 | 10 | 7
 | 3 | 8
 | 5 | 6
 | 8 | 7
 | 7 | 8
 | 5 | 8
 | 4 | 2
 | 4 | 5
 | 8 | 4
 | 4 | 1
 | 2 | 8
 | 7 | 7
 | 4 | 6
 | 6 | 1
 | 4 | 7
 | 1 | 2
 | 10 | 10
 | 6 | 10
 | 7 | 10
 | 6 | 1
 | 3 | 4
 | 7 | 3
 | 8 | 7
 | 8 | 2
 | 8 | 1
 | 4 | 7
 | 2 | 2
 | 1 | 9
 | 8 | 2
 | 3 | 9
 | 2 | 6
 | 6 | 10
 | 7 | 9
 | 9 | 7
 | 7 | 1
 | 1 | 9
 | 10 | 8
 | 1 | 7
 | 10 | 1
 | 2 | 1
 | 2 | 7
 | 7 | 1
 | 8 | 2
 | 9 | 6
 | 10 | 3
 | 9 | 3
 | 3 | 7
 | 2 | 10
 | 7 | 7
 | 9 | 2
 | 5 | 3
 | 3 | 6
 | 3 | 7
 | 3 | 4
 | 9 | 4
 | 6 | 4
 | 2 | 10
 | 7 | 3
 | 6 | 1
 | 7 | 9
 | 9 | 7
 | 6 | 8
Spreadsheet: 105379d1302748648-excel-2007-return-value-based-on-multiple-criteria-testdata
Sheet: Sheet1

Category | Date | [NAME] | [NAME] |  |  | Category | Date | [NAME] | [NAME]
A | 2010-03-11 00:00:00 | 1 |  |  |  | A | 2010-03-11 00:00:00 | 1
A | 2010-06-02 00:00:00 |  | 1 |  |  |  | 2010-06-02 00:00:00 |  | 1
A | 2010-11-03 00:00:00 | 1 |  |  |  |  | 2010-11-03 00:00:00 | 1
A | 2011-02-07 00:00:00 | 1 |  |  |  |  | 2011-02-07 00:00:00 | 1
B | 2010-09-05 00:00:00 | 1 |  |  |  | B | 2010-09-05 00:00:00 | 1
B | 2010-12-20 00:00:00 |  | 2 |  |  |  | 2010-12-20 00:00:00 |  | 1
B | 2010-12-27 00:00:00 |  | 2 |  |  |  | 2010-12-27 00:00:00 |  | 1
C | 2011-01-14 00:00:00 | 1 |  |  |  | C | 2011-01-14 00:00:00 | 1
D | 2011-03-01 00:00:00 |  | 2 |  |  | D | 2011-03-01 00:00:00 |  | 1 |  |  | Category | Date
D | 2011-03-23 00:00:00 |  | 2 |  |  |  | 2011-03-23 00:00:00 |  | 1 |  |  | A
E | 2009-12-07 00:00:00 |  | 2 |  |  | E | 2009-12-07 00:00:00 |  | 1 |  |  | B
E | 2010-04-05 00:00:00 | 1 |  |  |  |  | 2010-04-05 00:00:00 | 1 |  |  |  | C
E | 2010-11-19 00:00:00 | 1 |  |  |  |  | 2010-11-19 00:00:00 | 1 |  |  |  | D
F | 2010-03-26 00:00:00 | 1 |  |  |  | F | 2010-03-26 00:00:00 | 1 |  |  |  | E
F | 2010-07-09 00:00:00 | 1 |  |  |  |  | 2010-07-09 00:00:00 | 1 |  |  |  | F
F | 2010-08-25 00:00:00 | 1 |  |  |  |  | 2010-08-25 00:00:00 | 1 |  |  |  | G
F | 2011-01-12 00:00:00 | 1 |  |  |  |  | 2011-01-12 00:00:00 | 1
G | 2009-09-04 00:00:00 | 1 |  |  |  | G | 2009-09-04 00:00:00 | 1
G | 2009-10-22 00:00:00 |  | 2 |  |  |  | 2009-10-22 00:00:00 |  | 1
G | 2010-01-16 00:00:00 | 1 |  |  |  |  | 2010-01-16 00:00:00 | 1 |  |  |  |  | Criteria | Date of Last Batch 2 if there is [NAME] for a category
G | 2010-05-03 00:00:00 |  | 2 |  |  |  | 2010-05-03 00:00:00 |  | 1 |  |  |  |  | -or-
G | 2010-08-05 00:00:00 | 1 |  |  |  |  | 2010-08-05 00:00:00 | 1 |  |  |  |  |  | Date of First Batch 1 if there is [NAME]
G | 2010-10-18 00:00:00 |  | 2 |  |  |  | 2010-10-18 00:00:00 |  | 1
G | 2010-11-30 00:00:00 | 1 |  |  |  |  | 2010-11-30 00:00:00 | 1
G | 2011-04-11 00:00:00 |  | 2 |  |  |  | 2011-04-11 00:00:00 |  | 1
Spreadsheet: 688569d1595855481-reset-button-for-pressure-column-and-remove-cell-color-pressure-2-
Sheet: Pressure

 | SEPT |  |  |  |  |  |  |  |  |  |  |  | OCT |  |  |  |  |  |  |  |  |  |  |  | NOV |  |  |  |  |  |  |  |  |  |  |  | DEC
 | 2019-09-04 00:00:00 |  |  | 2019-09-08 00:00:00 |  |  | 2019-09-12 00:00:00 |  |  | 2019-09-15 00:00:00 |  |  | 2019-10-01 00:00:00 |  |  | 2019-10-05 00:00:00 |  |  | 2019-10-10 00:00:00 |  |  | 2019-10-12 00:00:00 |  |  | 2019-11-02 00:00:00 |  |  | 2019-11-05 00:00:00 |  |  | 2019-11-10 00:00:00 |  |  | 2019-11-22 00:00:00 |  |  | 2019-12-16 00:00:00
Car Machine | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter
JAW 302 | 0
BET 102
JAC 209
Spreadsheet: 61437d1262283603-sorting-data-by-date-within-a-date-range-month-factors
Sheet: Data

2007-12-01 00:00:00 | 1.056673286991063
2008-01-01 00:00:00 | 1.425675675675676
2008-02-01 00:00:00 | 1.586195372750643
2008-03-01 00:00:00 | 1.012375296912114
2008-04-01 00:00:00 | 1.880872483221476
2008-05-01 00:00:00 | 1.27
2008-06-01 00:00:00 | 1.23
2008-07-01 00:00:00 | 1.25
2008-08-01 00:00:00 | 1.27
2008-09-01 00:00:00 | 1.01
2008-10-01 00:00:00 | 1.25
2008-11-01 00:00:00 | 1.260056818181818
2008-12-01 00:00:00 | 1.055634920634921
2009-01-01 00:00:00 | 1.25
2009-02-01 00:00:00 | 1.332240663900415
2009-03-01 00:00:00 | 1.012375296912114
2009-04-01 00:00:00 | 1.352040816326531
2009-05-01 00:00:00 | 1.27
2009-06-01 00:00:00 | 1.01
2009-07-01 00:00:00 | 1.25
2009-08-01 00:00:00 | 1.27
2009-09-01 00:00:00 | 1.01
2009-10-01 00:00:00 | 1.25
2009-11-01 00:00:00 | 1.342307692307692
Spreadsheet: 62664d1263567462-look-up-and-replace-book3
Sheet: Sheet1

 | IDNUM | IDNUM | REASON | COMMENT
0 | 28 | 0
4 | 105 | 6 |  | ANS
0 | 147 | 33 |  | NA
0 | 148 | 35 |  | ANS
1 | 257 | 41 |  | ANS
1 | 300 | 49 |  | ANS
1 | 315 | 57 | 4 | said there today-12/3/09
0 | 443 | 124 |  | ANS
0 | 478 | 158 |  | ANS
0 | 507 | 193 |  | ANS
0 | 572 | 205 |  | ANS
0 | 604 | 239 | 1 | last time in some spotting and clothes a little smelly
0 | 617 | 375 |  | ANS
2 | 716 | 451 |  | ANS
3 | 739 | 512 |  | ANS
2 | 778 | 532 | 4 | HAVE A COAT TO BRING IN
2 | 780 | 556 |  | ANS
0 | 966 | 576 |  | ANS
0 | 1099 | 591 |  | NA
0 | 1143 | 615 |  | ANS
0 | 1170 | 627 |  | NA
0 | 1176 | 638 |  | ANS
0 | 1294 | 641 |  | ANS
0 | 1295 | 676 |  | ANS
0 | 1469 | 699 | 2 | NOTHING TO BRING IN
0 | 1579 | 729 | 1 | spots on shits, road being worked on making it hard to get to store
0 | 1632 | 731 | 3 | 1= leave soap on clothes, 3=retired
0 | 1707 | 740 |  | ANS
0 | 1799 | 747 | 2 | OFF WORK FOR THE WINTER
0 | 1869 | 788 |  | ANS
Spreadsheet: 148898d1333608495-change-formula-if-number-format-changes-test
Sheet: TEST

 |  |  |  |  |  | UNIT RATES |  |  | TOTAL |  |  |  | QUANTITY |  |  | AMOUNT
 | 02000 |  | SITEWORK
 | 02261 |  | Backfill
 | 02261 | 002 | Sand for Trench | 47 | M3 | 7.51 | 42.55 |  |  |  |  |  | 1 |  |  | 2352.82
 | 02301 |  | Excavation
 | 02301 | 001 | General Volume of Excavation | 38 | M3 | 0 | 59.39 |  |  |  |  |  | 1 | 1 |  | 2256.82
 | 02301 | 002 | Disposal |  | M3 | 0 | 50.06
 |  |  | Disposal (escalated rate as at Jan 07) | 58 | M3 | 0 | 50.06 |  |  |  |  |  | 1 |  |  | 2903.48
 |  |  | SUB-TOTAL OF SECTION 02000 |  |  |  |  |  |  |  |  |  |  |  |  | 7513.12
Spreadsheet: darrell_schoolcraft__7304__imball0201
Sheet: WTG inc

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  |  |  |  |  |  |  | -677 | -581
2 |  |  |  |  |  |  |  |  |  |  | -928 | -581
3 |  |  |  |  |  |  |  |  |  |  | -911 | -581
4 |  |  |  |  |  |  |  |  |  |  | -981 | -581
5 |  |  |  |  |  |  |  |  |  |  | -658 | -581
6 |  |  |  |  |  |  |  |  |  |  | -805 | -581
7 |  |  |  |  |  |  |  |  |  |  | -709 | -581
8 |  |  |  |  |  |  |  |  |  |  | -828 | -581
9 |  |  |  |  |  |  |  |  |  |  | -884 | -581
10 |  |  |  |  |  |  |  |  |  |  | -856 | -581
11 |  |  |  |  |  |  |  |  |  |  | -595 | -581
12 |  |  |  |  |  |  |  |  |  |  | -582 | -581
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 31688.49
2002-01-12 00:00:00
CBS Volume
 |  |  | 11681
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: Pyodene

Raw Material |  | Pyodene
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 0
Total
Spreadsheet: 490992d1480240931-colour-cell-depending-on-date-help-please-thank-you-test-bsb-
Sheet: Sheet1

Data | Start Date | End Date | 2016-10-29 00:00:00 | 2016-11-05 00:00:00 | 2016-11-12 00:00:00 | 2016-11-19 00:00:00 | 2016-11-26 00:00:00 | 2016-12-03 00:00:00 | 2016-12-10 00:00:00 | 2016-12-17 00:00:00 | 2016-12-24 00:00:00 | 2016-12-31 00:00:00 | 2017-01-07 00:00:00 | 2017-01-14 00:00:00 | 2017-01-21 00:00:00 | 2017-01-28 00:00:00 | 2017-02-04 00:00:00 | 2017-02-11 00:00:00 | 2017-02-18 00:00:00 | 2017-02-25 00:00:00 | 2017-03-04 00:00:00 | 2017-03-11 00:00:00 | 2017-03-18 00:00:00 | 2017-03-25 00:00:00 | 2017-04-01 00:00:00
Project 1 | 2016-11-29 00:00:00 | 2016-11-26 00:00:00
Project 2 | 2016-11-15 00:00:00 | 2016-12-30 00:00:00
Project 3 | 2016-11-22 00:00:00 | 2016-12-01 00:00:00
Project 4 | 2016-11-28 00:00:00 | 2016-12-30 00:00:00
Spreadsheet: 880589d1728402100-filtering-worksheet-issues-teamtasks_v1
Sheet: Filter_by_Name

Enter name assignee below
[NAME]
All tasks
 | [NAME] | complete | pink lady
Buy bananas | [NAME] | canceled | 0
Buy melons | [NAME] | 2024-10-12 00:00:00 | green preferred, orange if no green
Return glass bottles | [NAME] | 2024-10-13 00:00:00 | 100 bottles
Pay phone bill | [NAME] | completed | 0
Pay bank statement | Alex/Jill | 2024-10-10 00:00:00 | 0
Spreadsheet: 791776d1660582860-formula-for-co-occurrence-with-counting-and-percentage-book1
Sheet: Sheet1

 | PRODUCT #1 | PRODUCT #2 | PRODUCT #3 | COLOR |  |  |  | [NAME] | PANTS | COAT | JACKET
DAY1 | [NAME] | PANTS | JACKET | RED |  |  | [NAME]
DAY2 | PANTS | JACKET | COAT | YELLOW |  |  | PANTS
DAY3 | COAT | PANTS | [NAME] | BLUE |  |  | COAT
DAY4 | JACKET | COAT | PANTS | BLUE |  |  | JACKET
DAY5 | [NAME] | PANTS | JACKET | RED
[NAME] | PANTS | [NAME] | COAT | YELLOW
DAY7 | [NAME] | COAT | PANTS | BLUE
Spreadsheet: 299051d1392992295-array-formula-for-top-10-how-to-deal-with-duplicate-values-top-10-formula-v2
Sheet: Sheet1

 | SC02 - CONSULTING
Consulting | Top 10 Proft + | Top 10 Cashflow + | Top 10 Loss - | Bottom 10 Cashflow - | Top 10 Bad Debt Charge (-) | Top 10 Debt Recovery (+) | Top 10 Prj Wins + | Top 10 Fee Extensions + | Top 10 Write Downs -
1 | 21085400 | 21989300 | 21604000 | 23133600 | 21604000 | 21960600 | 23452900 | 23133300 | 22748500
2 | 22631800 | 23208600 | 22479900 | 23038200 | 21636000 | 22409900 | 22568040 | 23038200 | 21989300
3 | 22622300 | 22408100 | 21829700 | 21790500 | 22684100 | 21907000 | 23453900 | 22631800 | 23270200
4 | 21989300 | 22518600 | 22376000 | 22967200 | 22479900 | 22357800 | 23446700 | 23148200 | 23177900
5 | 22408100 | 23148200 | 21253900 | 23188100 | 21829700 | 21741600 | 23482000 | 23106000 | 22586200
6 | 21900400 | 21384600 | 21741600 | 21604000 | 21909500 | 21949900 | 23469400 | 23207200 | 21079700
7 | 21038400 | 21085400 | 21909500 | 22568050 | 22940800 | 12344700 | 23470600 | 23208600 | 23337000
8 | 21652900 | 22758800 | 22636800 | 23106000 | 22580800 | 21705800 | 23483900 | 22408100 | 22833500
9 | 23188100 | 22775900 | 12582700 | 22766200 | 22741400 | 21694800 | 23439200 | 22962300 | 23416800
10 | 21960600 | 21114604 | 23009100 | 23389300 | 22623900 | 22513500 | 23468000 | 23096400 | 21939900
=INDEX('Current Month'!$A:$AN,MATCH(LARGE(IF('Current Month'!$AM:$AM<>"X",IF('Current Month'!$F:$F=$A$29,IF('Current Month'!$AJ:$AJ="Increase",'Current Month'!$AI:$AI))),$A39),'Current Month'!$AI:$AI,0),1)
Spreadsheet: 22eac69b-e6d4-427a-b8d0-d327c60e76c3
Sheet: Sheet1

2004-09-14 00:00:00 | UNITED STATES SENATOR - DEMOCRATIC | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Haddock, d | Alciere, r | [NAME], r | Tipa, r | scatter
Belknap County
Alton | 112
Barnstead | 141
Belmont | 155
Center Harbor | 31
Gilford | 171 |  | 2 |  | 2
Gilmanton | 98 |  | 1 |  | 2
[NAME] | 77 |  | 1 |  | 2
[NAME] | 61 |  | 1
[NAME] 3 | 75
[NAME] | 61 |  | 2
[NAME] | 71 | 1 | 3 |  | 2
[NAME] 6 | 68 |  | 2 |  | 1
Meredith | 177 |  | 1 |  | 5
New Hampton | 70 |  | 1 |  | 2
Sanbornton | 94 |  | 1
[NAME] | 112 |  | 1 |  | 3
TOTALS | 1574 | 1 | 16 |  | 19
 | UNITED STATES SENATOR - DEMOCRATIC
 | Haddock, d | Alciere, r | [NAME], r | Tipa, r | scatter
Carroll County
Albany | 39
[NAME] | 78 |  | 1 |  | 1
[NAME] | 38 |  | 1 |  | 1
Chatham | 9
Conway | 159 |  |  |  | 6
Eaton | 19
[NAME] | 50
Freedom | 57
Hale's Location | 1
Hart's Location | 1
[NAME] | 76
[NAME] | 73
Moultonborough | 90
Ossipee | 91 |  | 1 |  | 2
Sandwich | 135 |  |  |  | 5
Tamworth | 183 |  | 1
Tuftonboro | 51 |  |  |  | 2
Wakefield | 115 |  |  |  | 2
Wolfeboro | 196 |  | 2 |  | 1
TOTALS | 1461 |  | 6 |  | 20