tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 130998d1322682622-if-match-and-somewhere-close-to-excelforum-help-sheet
Sheet: Sheet2

[NAME] | Owner [NAME] | Initial Deposit | Contract Number
1 | Last Name 1 | 123457 | 010456010
2 | Last Name 2 | 50 | 010456011
3 | Last Name 3 | 27 | 010456012
4 | Last Name 4 | 11155533 | 010456013
5 | Last Name 5 | 4595 | 010456014
6 | Last Name 6 | 34564 | 010456015
7 | Last Name 7 | 15445000 | 010456016
8 | Last Name 8 | 12154 | 010456017
9 | Last Name 9 | 1 | 010456018
10 | Last Name 10 | 23564 | 010456019
11 | Last Name 11 | 7454 | 010456020
12 | Last Name 12 | 986532 | 010456021
13 | Last Name 13 | 124 | 010456022
14 | Last Name 14 | 3544 | 010456023
15 | Last Name 15 | 575416 | 010456024
16 | Last Name 16 | 21246 | 010456025
17 | Last Name 17 | 54 | 010456026
18 | Last Name 18 | 100 | 010456027
19 | Last Name 19 | 56 | 010456028
20 | Last Name 20 | 4475854 | 010456029
21 | Last Name 21 | 27 | 010456030
22 | Last Name 22 | 50 | 010456031
23 | Last Name 23 | 4456 | 010456032
24 | Last Name 24 | 21456 | 010456033
25 | Last Name 25 | 4754511 | 010456034
26 | Last Name 26 | 214 | 010456035
27 | Last Name 27 | 33333 | 010456036
Spreadsheet: 830244d1684824339-sum-up-revenue-of-customers-by-year-from-another-sheet-of-financial-data-test-file-for-power-query
Sheet: Customer List

Customer Code | 2018 | 2019 | 2020 | 2021 | 2022 | 2023
1009126
1009790
1008803
1010244
1008991
1008836
1008837
1010665
1008839
1008804
1009658
1008840
1008928
1008841
1010386
1010140
1010767
1011602
1009343
1008838
1008845
1008820
1010240
1008821
1009209
1009601
1008967
1008843
1008849
1008822
1008842
1008853
1008844
1008823
1010074
1008846
1008856
1009274
1008847
1008824
1008858
1008859
1008860
1008848
1008861
1009583
1010998
1008810
1008862
1011565
1009665
1011356
1008865
1008850
1008851
1009049
1010781
1008852
1008871
1008872
1008811
1008873
1008868
1008869
1008830
1008870
1010571
1008875
1008854
NA- UK Account
1010143
1011425
1008855
1008825
1008857
1008880
1009239
1010434
1008882
1008883
1008826
1011546
1010817
1009520
1010871
1008815
1009187
1008827
1008828
1008879
1008829
1009864
1009944
1008863
1010939
1008929
1008864
1011590
1010888
1008896
1010181
1008897
1009090
1008898
1008866
1009102
1010038
1010002
1008901
1009567
1008904
1009350
1008816
1010392
1011300
1008867
1009793
1008907
1010746
1008874
1008910
1008817
1008909
1008913
1008876
1009141
1008877
1008812
1009368
1010865
1008878
1011155
1008831
1009814
1010044
1008813
1010203
1008881
1009644
1009735
1008884
1009219
1008885
1009979
1008814
1011249
IC7000
1009879
1009666
1009698
1009730
1009725
1008887
1009396
1009070
1009370
1008889
1010060
1008888
1010498
1009817
1010690
1011049
1009873
1010390
1008890
1009885
1008541
1009945
1008079
1009973
1009884
1008891
1009981
1008892
1008893
1009692
1009804
1010058
1010080
1008894
1008895
1009038
1010115
1010441
1008832
1011467
1008899
1010385
1009551
1008900
1010252
1010272
1010314
1010327
1009335
1010222
1009731
1008902
1010088
1008975
1010742
1008833
1010444
1008905
1010455
1010477
1008903
1008906
1010568
1010450
1009844
1010394
1010684
1010709
1010081
1010737
1010391
1010393
1009199
1010768
1009523
1008908
1008914
1010856
1008911
1008912
1008834
1010940
1010941
1010942
1010943
1010674
1010986
1008835
1011038
1009112
1011050
1011110
1011115
1011126
1008818
1011189
1011242
1008915
1011264
1011262
1008949
1008916
1011313
1011347
1011348
1008917
1011375
1011397
1008969
1011431
1011432
1011442
1011456
1011457
1011458
1011461
1011466
1011463
1009980
1011485
1011509
1011527
1011542
1011539
1011545
1008918
1011547
1011548
1011555
1011557
1008919
1011578
1008920
1011596
1009922
1011615
1011620
1011635
1011670
1011703
1011704
Spreadsheet: andy_zipper__793__10_26_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 | 300 | 9 | 11 | 138 | 154.2 | 27.1 | 2001-10-25 14:38:00
 | NG Z1 | 320 | 61 | 63 | 81.1 | 83.8 | 16.59 | 2001-10-26 11:34:00
 | NG F2 | 330 | 85 | 86 | 79.8 | 80.8 | 16.66 | 2001-10-26 11:34:00
 | NG G2 | 330 | 96 | 99 | 73 | 75.3 | 15.38 | 2001-10-26 11:34:00
 | NG H2 | 325 | 96 | 98 | 65.3 | 66.7 | 13.49 | 2001-10-26 11:34:00
 | NG J2 | 315 | 79 | 81.5 | 50.1 | 51.7 | 10.08 | 2001-10-26 11:34:00
 | NG K2 | 315 | 81 | 84 | 47 | 48.7 | 9.48 | 2001-10-26 11:34:00
 | NG M2 | 320 | 81 | 84 | 42.7 | 44.3 | 8.75 | 2001-10-26 11:34:00
 | NG N2 | 325 | 92 | 96 | 45 | 47 | 9.4 | 2001-10-26 11:34:00
 | NG Q2 | 325 | 99 | 103 | 45.9 | 47.8 | 9.57 | 2001-10-26 11:34:00
 | NG U2 | 325 | 103 | 108 | 45.4 | 47.6 | 9.5 | 2001-10-26 11:34:00
 | NG V2 | 330 | 105 | 113 | 43.7 | 47.1 | 9.42 | 2001-10-26 11:34:00
 | [NAME] | 365 | 131 | 134 | 45.9 | 46.9 | 10.65 | 2001-10-26 11:34:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 42242d1240847129-help-with-formula-complex-if-and-help-needed
Sheet: Sheet1

Name | Status | 2009 Referals | 2008 Referals | 2007 Referals
[NAME] | never refered
[NAME] | new referer | 1
[NAME] | regularly referred | 2 | 1
[NAME] | not refered in 2009 |  | 1 | 4
Carol | refering again | 1 |  | 2
[NAME] | not refrred since 2007 |  |  | 3
I need a complex IF AND formula for status cell that will evaluate the 3 yellow cells and automatically generate and
place one of 7 status indicators in the status cell in that persons associated status cell.
The status cell formula should place one of the following 6 status comments for an individual under associated conditions
if 2009 equal blank and 2008 blank and 2007 blank     satus set to "never referred"
if 2009 not blank and 2008 blank and 2007 equal blank     satus set to "new referer"
if 2009 not blank and 2008 blank and 2007 not blank     satus set to "not refered since 2007 referring again"
if 2009 not blank and 2008 not blank and 2007 not blank      satus set to "regular refererer since 2007"
if 2009 not blank and 2008 not blank and 2007 blank      satus set to "regular refererer since 2008"
if 2009 blank and 2008 blank and 2007 not blank      satus set to "not refered since 2007"
if 2009 blank and 2008 not blank       satus set to "not refered since 2008"
Spreadsheet: 25345d1216636805-how-do-i-populate-multiple-cells-based-on-a-list-combobox-copy-of-sample
Sheet: IIS Lists

 | Plan |  | HMO X | HMO X | [NAME] | Value Plus | US Access 8 | US Access2 | HMO XX
 | HMO |  | 0 | N/A | N/A | N/A | N/A | 1500 | N/A
 | PPO |  |  | N/A | N/A | N/A | $3000/9000 | 1500 | N/A
 | HMO |  |  | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited
 | PPO |  |  | N/A | N/A | N/A | 1Million | 1Million | N/A
 | HMO |  |  | N/A | N/A | N/A | N/A | N/A | N/A
 | PPO |  |  | N/A | N/A | N/A | 80/20 | 70/30 | N/A
 | HMO |  |  | N/A | N/A | N/A | N/A | N/A | N/A
 | PPO |  |  | N/A | N/A | N/A | 70 / 30 | 70/30 | N/A
 | HMO |  |  | 10 | 10 | 10 | 10 | 10 | 20
 | PPO |  |  | N/A | N/A | N/A | 25 | 25 | N/A
 | HMO |  |  | 10 | 15 | 15 | 10 | 10 | 20
 | PPO |  |  | N/A | N/A | N/A | 25 | 25 | N/A
 | HMO |  |  | 10 | 15 | 15 | 10 | 10 | 20
 | PPO |  |  | N/A | N/A | N/A | 25 | 25 | N/A
 | HMO |  |  | 10 | 15 | 15 | 10 | 10 | 20
 | PPO |  |  | N/A | N/A | N/A | 25 | 25 | N/A
 | HMO |  |  | $10/20/35 | $10/20/35 | $10/20/35 | $10/20/35 | $10/20/35 | $10/20/35
 | PPO |  |  | N/A | N/A | N/A | N/A | N/A | N/A
 | HMO |  |  | 50 | None | 100 | 100 | None | 250
 | PPO |  |  | N/A | N/A | N/A | 80/20 | 250 | N/A
 | HMO |  |  | $50.00/d-$250/m | None | 240 | 240 | None | $250/d
Spreadsheet: 128270d1320880080-sumproduct-w-one-criteria-coming-from-a-list-sumproduct-using-list
Sheet: Data 

Cost Code | Name | Hrs | $ |  | Pkg | MR
20956532 | [NAME] | 5 | 335 |  | 565 | 32
20956532 | [NAME] | 18 | 1080 |  | 565 | 32
20956532 | Amber Hicks | 5 | 250 |  | 565 | 32
20956532 | [NAME] | 20 | 1520 |  | 565 | 32
20956532 | [NAME] | 15 | 1290 |  | 565 | 32
20956532 | [NAME] | 20 | 1260 |  | 565 | 32
20956532 | [NAME] | 4 | 400 |  | 565 | 32
20578224 | [NAME] | 12 | 972 |  | 782 | 24
20578224 | [NAME] | 11 | 715 |  | 782 | 24
20578224 | [NAME] | 10 | 810 |  | 782 | 24
20578224 | [NAME] | 28 | 2156 |  | 782 | 24
20578224 | [NAME] | 14 | 1134 |  | 782 | 24
20188815 | [NAME] | 28 | 2156 |  | 888 | 15
20288815 | [NAME] | 7 | 567 |  | 888 | 15
20388815 | [NAME] | 11 | 715 |  | 888 | 15
20388815 | [NAME] | 28 | 1932 |  | 888 | 15
20488815 | [NAME] | 1 | 87 |  | 888 | 15
20488815 | [NAME] | 1 | 65 |  | 888 | 15
20388815 | [NAME] | 23 | 1771 |  | 888 | 15
20388815 | [NAME] | 2 | 174 |  | 888 | 15
20188815 | [NAME] | 13 | 1053 |  | 888 | 15
20488815 | [NAME] | 8 | 616 |  | 888 | 15
20288815 | [NAME] | 7 | 539 |  | 888 | 15
20288815 | [NAME] | 25 | 1625 |  | 888 | 15
20388815 | [NAME] | 1 | 81 |  | 888 | 15
20488815 | [NAME] | 20 | 1740 |  | 888 | 15
20288815 | [NAME] | 11 | 715 |  | 888 | 15
20288815 | [NAME] | 24 | 1560 |  | 888 | 15
20188815 | [NAME] | 21 | 1449 |  | 888 | 15
20388815 | [NAME] | 16 | 1392 |  | 888 | 15
20188815 | [NAME] | 29 | 2320 |  | 888 | 15
20388815 | [NAME] | 29 | 2755 |  | 888 | 15
20288815 | [NAME] | 16 | 1280 |  | 888 | 15
20388815 | [NAME] | 1 | 100 |  | 888 | 15
20188815 | Amber Hicks | 24 | 1200 |  | 888 | 15
20388815 | [NAME] | 19 | 1235 |  | 888 | 15
20188815 | [NAME] | 12 | 696 |  | 888 | 15
20288819 | Amber Hicks | 27 | 2484 |  | 888 | 19
20288819 | [NAME] | 16 | 1392 |  | 888 | 19
20288819 | [NAME] | 16 | 1104 |  | 888 | 19
20288819 | Amber Hicks | 17 | 1326 |  | 888 | 19
20288819 | [NAME] | 3 | 177 |  | 888 | 19
20488823 | [NAME] | 18 | 900 |  | 888 | 23
20188823 | [NAME] | 23 | 1656 |  | 888 | 23
20888823 | [NAME] | 21 | 1953 |  | 888 | 23
20188823 | [NAME] | 13 | 897 |  | 888 | 23
20188823 | [NAME] | 13 | 897 |  | 888 | 23
20188823 | [NAME] | 16 | 1296 |  | 888 | 23
20188823 | [NAME] | 16 | 1424 |  | 888 | 23
20296932 | [NAME] | 23 | 1495 |  | 969 | 32
20296932 | [NAME] | 14 | 910 |  | 969 | 32
20296932 | [NAME] | 7 | 455 |  | 969 | 32
20296932 | [NAME] | 28 | 2156 |  | 969 | 32
20296932 | [NAME] | 28 | 1820 |  | 969 | 32
20296932 | Amber Hicks | 4 | 264 |  | 969 | 32
20296932 | Amber Hicks | 12 | 1080 |  | 969 | 32
20296932 | [NAME] | 13 | 1027 |  | 969 | 32
Spreadsheet: 94229d1294090732-auto-fill-consecutive-row-after-processing-from-different-sheet-inputoutput2
Sheet: Sell

Date | Buyer | Coupon | Type | [NAME] | Price | Weight | Decrease/Increase | Total
2010-03-23 00:00:00 | Billy | 102 | bowl |  | 14000 | 5400 | -115 | 75600000
2010-03-29 00:00:00 | [NAME] | 102 | triangle |  | 12600 | 3450 | -166 | 43470000
2011-03-29 00:00:00 | [NAME] | 107 | triangle |  | 12900 | 2800 | -169 | 36120000
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0 |  | my previous H2
 |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0 |  | snb's H2
 |  |  |  |  |  |  | 0 | 0 |  | -115
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
2011-03-30 00:00:00 | [NAME] | 102 | broken |  | 8500 | 4925 | -130 | 41862500
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 197052500
Spreadsheet: 83006d1283016192-two-values-in-drop-down-list-issue_1-dynamicrangesanddatavalidation
Sheet: Sheet2

Prod. Name | Part # | Price | Description |  | [NAME] names
Bread | 43g-44 | 1 | I eat bread |  | Bread
Car | 23433-je | 333222 | I have better car |  | Car |  |  | column A is now  named range Products
Ice Cream | sdfd-334 | 3.2 | IceCream Desc |  | Ice Cream |  |  | column B is now a named range Parts
Ice Cream | sdfd-333 | 3.3 | IceCream2 Desc |  | Juice |  |  | column C is now a named range Prices
Juice | 43-44ggf | 2.2 | [NAME] from FL |  | Onion |  |  | column D is now a named range Desc
Onion | 999-uuu | 2.1 | I hate Onions |  | Salt
Salt | 23432-gf | 1 | Salt is good for cooking |  | Shoe |  |  | column F is now a dynamic named range Products2
Salt | 23432-gf2 | 1 | Salt is good for cooking |  | Sugar
Shoe | fg565s | 3 | Shoe Shaw |  | Tomato |  |  | There are formulas in column F to collect the unique names from column A
Sugar | 1234-se | 23 | Don't eat sugar |  | -
Sugar | 1234-se2 | 23 | Don't eat sugar |  | -
Sugar | 1234-se3 | 23 | Don't eat sugar |  | -
Tomato | 123-hgj | 1.1 | Tomato are MUST |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
Spreadsheet: 829585d1684324209-creating-a-list-based-on-criteria-example-data
Sheet: Sheet1

Name | Location
[NAME] | Birmingham
[NAME] | London
[NAME] | [NAME]
[NAME] | Liverpool
[NAME] | Cardiff
[NAME] | Birmingham
[NAME] | London
Billy | [NAME]
Michelle | Liverpool
Derek | Cardiff
[NAME] | Birmingham
Spreadsheet: 14a6a830-835b-4a81-9440-3389ef828f66
Sheet: 24

 |  | Transactions
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated swap dollar volumes, week ending November 23, by product type and cleared status (value of all trades in millions of USD), all participant types, tenors, and currencies. 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 cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****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: 791279d1660237016-cross-reference-person-date-from-database-sample-technician-tracker
Sheet: Data

 | Date | Press | Process | Name | Job Title
 | 2022-08-08 00:00:00 | Press 30 | Start Up | Person 1
 | 2022-08-08 00:00:00 | Press 25 | Start Up | Person 1
 | 2022-08-08 00:00:00 | Press 9 | Start Up | Person 1
 | 2022-08-08 00:00:00 | Press 13 | Start Up | Person 1
 | 2022-08-08 00:00:00 | Press 29 | Start Up | Person 2
 | 2022-08-08 00:00:00 | Press 8 | Start Up | Person 2
 | 2022-08-08 00:00:00 | Press 10 | Start Up | Person 2
 | 2022-08-10 00:00:00 | Press 01 | Start Up | Person 1
 | 2022-08-10 00:00:00 | Press 27 | Start Up | Person 1
 | 2022-08-10 00:00:00 | Press 29 | Start Up | Person 3
 | 2022-08-10 00:00:00 | Press 25 | Set Up | Person 6
 | 2022-08-10 00:00:00 | Press 03 | Set Up | Person 6
 | 2022-08-10 00:00:00 | Press 29 | Set Up | Person 6
 | 2022-08-10 00:00:00 | Press 08 | Set Up | Person 6
 | 2022-08-10 00:00:00 | Press 10 | Set Up | Person 6
Spreadsheet: 81332d1281544200-sumif-formula-sumif
Sheet: Sheet1

ID | Value
111 | 10
123 | 8
321 | 9
222 | 1
333 | 1
111 | 8
123 | 9
321 | 0
222 | 4
333 | 5
111 | 10
123 | 5
321 | 10
222 | 9
333 | 4
111 | 8
123 | 0
321 | 7
222 | 6
333 | 1
111 | 2
123 | 1
321 | 2
222 | 6
333 | 8
111 | 2
123 | 6
321 | 4
222 | 8
333 | 9
111 | 4
123 | 0
321 | 6
222 | 7
333 | 3
111 | 0
123 | 6
321 | 5
222 | 2
333 | 8
111 | 8
123 | 5
321 | 2
222 | 4
333 | 9
111 | 1
123 | 1
321 | 5
222 | 5
333 | 7
111 | 7
123 | 3
321 | 3
222 | 7
333 | 4
111 | 5
123 | 8
321 | 1
222 | 1
333 | 5
111 | 1
123 | 10
321 | 9
222 | 9
333 | 6
111 | 0
123 | 4
321 | 1
222 | 6
333 | 8
111 | 8
123 | 7
321 | 4
222 | 8
333 | 1
111 | 7
123 | 8
321 | 6
222 | 2
333 | 9
111 | 2
123 | 5
321 | 2
222 | 3
333 | 9
111 | 7
123 | 8
321 | 1
222 | 9
333 | 4
111 | 5
123 | 4
321 | 0
222 | 3
333 | 16
Spreadsheet: 116705d1312032214-masterfile-to-subfile-updating-transaction
Sheet: 0003

Contact Person | Com Code | Company | Truck ID | Make | Model | Date | Job Description | Parts | Hours | Call No | Inv Amt | Paid | 2nd Pay | 3rd Pay | Balance |  | Total O/S
Mr [NAME] | 0003 | KLM Motors | FL2374 | Nissan | PL02A25 | 28.07.11 | overhaul engine |  | 20 | 1411 | 1500 | 500 |  |  | 1000
Mr [NAME] | 0003 | KLM Motors | FL2374 | Nissan | PL02A25 | 28.07.11 | lube service |  | 4 | 1413 | 250 | 250 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 266786d1379744843-copy-or-remove-particular-count-of-records-and-pasting-in-another-excel-workbook-count-sample
Sheet: required records 

Webaddress | email address
www.2xu.com.au | [NAME]
www.aadarsheng.com.au | [EMAIL]
www.aawglobal.com.au | [EMAIL]
www.aawglobal.com.au | [EMAIL]
www.aawglobal.com.au | [EMAIL]
www.abelmet.com.au | [EMAIL]
www.abelmet.com.au | [EMAIL]
www.abelmet.com.au | [NAME]
www.abetterperspective.com.au | [EMAIL]
www.abetterperspective.com.au | [EMAIL]
www.abmauri.com.au | [EMAIL]
www.abmauri.com.au | [EMAIL]
www.abmauri.com.au | [NAME]
www.accaustpac.com.au | [EMAIL]
www.accaustpac.com.au | [EMAIL]
www.accaustpac.com.au | [EMAIL]
www.acl.com.au | [EMAIL]
www.acl.com.au | [EMAIL]
www.acl.com.au | [EMAIL]
Spreadsheet: 100929d1299143739-matching-off-figures-in-different-cells-tes
Sheet: Sheet4

Store Name | Loaned To Store/Borrowed From Store | Borrowed | Loaned
Store 1 | Store 6 | 4
Store 2 | Store 8 |  | 27
Store 2 | Store 9 |  | 10
Store 3 | Store 7 | 37
Store 3 | Store 5 | 10
Store 4 | Store 12 | 5
Store 5 | Store 8 | 14
Store 5 | Store 3 |  | 10
Store 6 | Store 1 |  | 4
Store 6 | Store 11 | 15 |  |  | << does not match
Store 6 | Store 10 | 16
Store 7 | Store 3 |  | 37
Store 8 | Store 5 |  | 14
Store 8 | Store 2 | 27
Store 9 | Store 2 | 10
Store 10 | Store 6 |  | 16
Store 10 | Store 13 | 10
Store 11 | Store 13 | 5 |  |  | << there is no match for this
Store 11 | Store 6 |  | 14 |  | << does not match
Store 12 | Store 4 |  | 5
Store 13 | Store 10 |  | 10
Spreadsheet: 138530d1327697196-compute-a-score-based-off-many-variables-ufpmxxxx2
Sheet: Sheet1

Test Date | Due Date | Section | Rank/AFSC | Name | Age/Gen | Weight | Height | HR | [NAME] | [NAME] | PU | PU Points | SU | SU Points | Run/Walk | Time | Time Points | VO2 | VO2 Points | Score
2012-01-01 00:00:00 |  |  |  |  | M < 30 |  |  |  | 34 |  | Exp |  | 45 |  | Run | 11.21
Spreadsheet: 883411d1732032101-trying-to-customize-the-excel-template-attendance-record-employee-attendance-record-jul-to-jun-1-
Sheet: Employee Leave Tracker

 | Employee leave tracker
 | Employee name | Start date | End date | Type of leave | Days
 | Aldayani, [NAME] |  |  | Vacation
 | Aldayani, [NAME] |  |  | Sick leave
 | [NAME], [NAME] |  |  | Sick leave |  |  |  |  |  |  | **=DATE(Year(TODAY())+1-1,M,D)
 | Long, [NAME] |  |  | Vacation |  |  |  |  |  |  | **=[NAME],d)
 | Job, Manna |  |  | Vacation
 | Job, Manna |  |  | Vacation
 | Ngo, Ivy |  |  | Vacation
 | Ngo, Ivy |  |  | Sick leave
Spreadsheet: 49577d1248939674-lookup-with-a-dropdown-box-blitz-day
Sheet: Sheet1

# | Product | Sub Product | Reference Number | Client ID Number |  |  |  | [NAME] | Lock2 | [NAME]
1 | Transactional Accounts |  |  |  | Cheque |  |  | 1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | Transactional Accounts
2 |  |  |  |  | Savings |  |  | 1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | Notify Me
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enhanced Notify Me
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Spreadsheet: 132239d1323633204-extract-data-into-master-work-sheet-given-format
Sheet: MW-8

LOW FLOW SAMPLING
FIELD DATA SHEETS
 |  |  | Client:
 | Site:
 | Date: |  |  | 2011-11-18 00:00:00
 |  |  | Monitoring Well #: | MW-8 |  |  |  | Well Depth: | 11.13 |  | ft |  |  | Screened/Open Interval: | 2 - 8 |  | ft
 |  |  | Well Permit #: |  |  |  |  | Well Diameter: | 2 |  | inches
 | PID Readings (ppm)
 |  |  |  | Background: |  | 0 |  |  | Pump Intake Depth: |  |  | 5.75 |  |  | ft below TOC
 |  |  |  | [NAME]: |  | 0 |  |  |  |  |  |  | Depth to Water Before Pump Installation: | 3.7 |  | ft below TOC
 |  |  |  | Beneath Inner Cap: |  | 0 |  |  |  |  |  |  | [NAME] | stainless steel submersible pump
 | TIME | Purging | Sampling |  |  |  |  | Specific |  | Dissolved |  | Redox |  |  |  |  | Depth to
 |  |  |  | pH |  | Temperature |  | Conductivity |  | [NAME] |  | Potential |  | Turbidity |  | Pumping | Water
 |  |  |  | (pH units) |  | (oC) |  | (uS/cm) |  | (mg/L) |  | (mV) |  | (NTU) |  | Rate | (ft below
 |  |  |  | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | (ml/min) | TOC)
 | 9:45 | x |  | 6.78 | NA | 9.7 | NA | 548 | NA | 1.09 | NA | 20.8 | NA | 27 | NA | 210 | 3.72
 | 9:50 | x |  | 6.77 |  | 10.03 |  | 545 |  | 0.75 |  | 7.1 |  | 16 |  | 210 | 3.72
 | 9:55 | x |  | 6.77 |  | 10.24 |  | 552 |  | 0.68 |  | -4.6 |  | 12.4 |  | 210 | 3.72
 | 10:00 | x |  | 6.77 |  | 10.24 |  | 563 |  | 0.61 |  | -14.8 |  | 9.71 |  | 210 | 3.72
 | 10:05 | x |  | 6.76 |  | 10.37 |  | 567 |  | 0.64 |  | -21.8 |  | 7.16 |  | 210 | 3.72
 | 10:10 | x |  | 6.77 |  | 10.31 |  | 586 |  | 0.55 |  | -23.3 |  | 5.66 |  | 210 | 3.72
 | 10:15 | x |  | 6.77 |  | 10.33 |  | 599 |  | 0.72 |  | -25.7 |  | 4.52 |  | 210 | 3.72
 | 10:20 | x |  | 6.76 |  | 10.4 |  | 602 |  | 0.68 |  | -29.6 |  | 5.54 |  | 210 | 3.72
 | 10:25 | x |  | 6.76 |  | 10.55 |  | 606 |  | 0.67 |  | -32.4 |  | 4.39 |  | 210 | 3.72
 | 10:30 |  | x | 6.77 |  | 11.05 |  | 617 |  | 0.44 |  | -40.1 |  | 2.78 |  | 210 | 3.72
 | [NAME]: |  | 09:35:00 |  | Sample notes: |  |  | Field blank done at 10:45
 | [NAME]: |  | 10:25:00
 | Sample Time: |  | 10:27:00
 | *INDICATOR PARAMETERS HAVE STABILIZED WHEN 3 CONSECUTIVE READINGS ARE WITHIN: + 0.1 for pH; + 3% for Specific Conductivity and
 | Temperature; + 10 mV for Redox Potential; and + 10% for [NAME] and Turbidity
Spreadsheet: 42181d1240758854-determin-x-value-from-a-y-test-subject-1
Sheet: Infomation Sheet

Lactate vx. Power Profile - Cycling
Power Watts | RPE | Heartrate bpm | Lactate mMol/L
100 | 0.5 | 130 | 0.9 |  |  |  |  |  |  | 2 | 250 |  | 1 | 0
130 | 1 | 133 | 1.1 |  |  |  |  |  |  | 4 | 250 |  | 1
160 | 2 | 142 | 1.2
190 | 3 | 153 | 2.4
220 | 4 | 160 | 4.3 |  | Weight | 155 | lbs |  | kgs
250 | 5.5 | 168 | 7.2 |  | Profile | 30 | Watts
280 | 7.5 | 173 | 9.1 |  | Per | 3 | Minutes
 |  |  |  |  | Starting | 100 | Watts
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 200
 |  |  |  |  | [NAME] | 280 | Watts |  |  |  |  |  | 156 | 200
 |  |  |  |  | Power to Weight |  | w/Lbs |  | w/kgs
 |  |  |  |  | Power at OBLA | 222
 |  |  |  |  | Power to Weight at OBLA |  | w/lbs |  | w/kgs
 |  |  |  |  |  |  |  |  |  | [NAME] would be Lactate 3.0 mMol/L the power would be 200 Watts
 |  |  |  |  |  |  |  |  |  | This was manualy calculated how do I do it automaticly
 |  |  |  |  |  |  |  |  |  | So if we know the Lactate crossed 3.0mMol/L and we can see its close to 200 watts
 |  |  |  |  |  |  |  |  |  | how do I automaticly get the value? I need the same for 4.0 and 2.0.
 |  |  |  |  |  | All Values were manually input. Need to automatically input values
 |  |  |  |  |  | Power at LT |  | 160 | Watts
 |  |  |  |  |  | HR at LT |  | 142 | bpm
 |  |  |  |  |  | Power at L2 |  | 182 | Watts
 |  |  |  |  |  | HR at L2 |  | 150 | bpm
 |  |  |  |  |  | Power at L3 |  | 200 | Watts
 |  |  |  |  |  | HR at L3 |  | 156 | bpm
 |  |  |  |  |  | Power at L4 |  | 216 | Watts
 |  |  |  |  |  | Hrate at L4 |  | 159 | bpm
 |  |  |  |  |  | Power at OBLA |  | 222 | Watts
 |  |  |  |  |  | Hrate at OBLA |  | 161 | bpm