tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 9b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis* | 169899 | 1017559 | 650085 | 5160137 | 6997680
FRA | 16425942 | 4882840 | 22073 | 15478831 | 36809686
IRS- [NAME] | 49495276 | 8640743 | 12657248 | 34224190 | 105017457
OIS | 15247597 | 3972786 |  | 4033677 | 23254060
VNS | 2566 | <1,000 |  | 1325 | 3891
Zero Coupon | 115809 | 37958 | 32322 | 54432 | 240521
TOTAL | 81457088 | 18551884 | 13361729 | 58952592 | 172323293
Estimated gross notional amount outstanding, February 8 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: 95125d1294796564-vlookup-question-sample
Sheet: Sheet2

Serial Number | Invoice Number | Original Invoice #
2742 | 17009
4198 | 16979
4347 | 16970
3452 | 17063
4572 | 17096
4549 | 17135
4573 | 17152
4907 | 17213
4496 | 17220
4645 | 17225
4159 | 17286
3490 | 17358
3040 | 17368
5031 | 17406
4863 | 17411
5021 | 17435
4811 | 17440
5024 | 17441
3564 | 17492
5243 | 17496
5045 | 17497
4514 | 17501
4285 | 17510
5207 | 17529
0003365A | 17547
4890 | 17548
5109 | 17552
4368 | 17553
4751 | 17651
5583 | 17689
5692 | 17775
5260 | 17872
5251 | 17815
5615 | 17958
5612 | 18152
5013 | 18000
5624 | 18154
5689 | 17966
5705 | 18107
5419 | 18156
5142 | 18157
5727 | 18153
5228 | 18168
5363 | 18149
5572 | 18219
5050 | 18270
4689 | 18271
5941 | 18278
5992 | 18383
5947 | 18385
Spreadsheet: 756662d1637687845-sumif-and-averageif-formulae-not-working-sum-and-average-sales
Sheet: SUMMARY

 | Product: | Product  10 |  | Date (dd/mm/yy) |  | 2021-01-07 00:00:00
 |  |  |  |  | S/be:
 |  | Total Sales last 7 days | Average Sales last 7 days |  | Total Sales last 7 days | Average Sales last 7 days
 | Customer 1
 | Customer 2
 | Customer 3
 | Customer 4
 | Customer 5
Spreadsheet: 183864d1349078515-freeze-half-the-page-verticaly-help1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Risked | Made | Lost
1 |  |  |  |  |  |  |  |  |  |  |  |  |  | NBA |  |  |  | NFL |  |  |  | CFB |  |  |  | WNBA
2 |  |  |  |  |  |  |  |  |  |  |  |  |  | W | L | T | % | W | L | T | % | W | L | T | % | W | L | T | %
 |  |  |  |  |  |  |  |  |  |  |  |  | Underdog
 |  |  |  |  |  |  |  |  |  |  |  |  | Chosen
 |  |  |  |  |  |  |  |  |  |  |  |  | Home
 |  |  |  |  |  |  |  |  |  |  |  |  | Away
 |  |  |  |  |  |  |  |  |  |  |  |  | Spread
 |  |  |  |  |  |  |  |  |  |  |  |  | Money ln
 |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | ALL
 |  |  |  |  |  |  |  |  |  |  |  |  | Home
 |  |  |  |  |  |  |  |  |  |  |  |  | Away
 |  |  |  |  |  |  |  |  |  |  |  |  | W/L
98
99
100
Spreadsheet: 80116d1280330283-retrieve-values-on-multiple-conditions-packages
Sheet: Sheet1

Material code | Customer | Type 1 | Type 2 | Type 3 | Type 4 | Type 5 | Type 6 | Type 7 | Type 8 | Type 9 | Type 10
123 | A | 1 | 5 | 8 | 10 | 15 | 100 | 1000 | 2000 | 2500 | 3000
123 | G | 3 | 4 | 8 | 10 | 15 | 100 | 1000 | 2000 | 2500 | 3000
124 | B | 2 | 7 | 8 | 40 | 500 | 1000 | 2000 | 5000 | 100000 | 150000
125 | C | 1 | 5 | 8 | 10 | 15 | 100 | 1000 | 2000 | 2500 | 3000
126 | D | 1.5 | 6 | 8 | 25 | 257.5 | 550 | 1500 | 3500 | 51250 | 76500
126 | E | 1.4 | 6.3 | 8 | 28 | 306 | 640 | 1600 | 3800 | 61000 | 91200
126 | H | 1.3 | 6.6 | 8 | 31 | 354.5 | 730 | 1700 | 4100 | 70750 | 105900
127 | E | 1.2 | 6.9 | 8 | 34 | 403 | 820 | 1800 | 4400 | 80500 | 120600
128 | F | 1.1 | 7.2 | 8 | 37 | 451.5 | 910 | 1900 | 4700 | 90250 | 135300
129 | G | 1 | 7.5 | 8 | 40 | 500 | 1000 | 2000 | 5000 | 100000 | 150000
130 | H | 0.9 | 7.8 | 8 | 43 | 548.5 | 1090 | 2100 | 5300 | 109750 | 164700
131 | I | 0.8 | 8.1 | 8 | 46 | 597 | 1180 | 2200 | 5600 | 119500 | 179400
132 | J | 0.7 | 8.4 | 8 | 49 | 645.5 | 1270 | 2300 | 5900 | 129250 | 194100
133 | A | 0.6 | 8.7 | 8 | 52 | 694 | 1360 | 2400 | 6200 | 139000 | 208800
134 | B | 0.5 | 9 | 8 | 55 | 742.5 | 1450 | 2500 | 6500 | 148750 | 223500
135 | C | 1 | 9.3 | 8 | 58 | 791 | 1540 | 2600 | 6800 | 158500 | 238200
136 | L | 3 | 9.6 | 8 | 61 | 839.5 | 1630 | 2700 | 7100 | 168250 | 252900
137 | E | 1 | 9.9 | 8 | 64 | 888 | 1720 | 2800 | 7400 | 178000 | 267600
138 | F | 1 | 10.2 | 8 | 67 | 936.5 | 1810 | 2900 | 7700 | 187750 | 282300
139 | G | 1 | 10.5 | 8 | 70 | 985 | 1900 | 3000 | 8000 | 197500 | 297000
140 | H | 1 | 10.8 | 8 | 73 | 1033.5 | 1990 | 3100 | 8300 | 207250 | 311700
141 | I | 1 | 11.1 | 8 | 76 | 1082 | 2080 | 3200 | 8600 | 217000 | 326400
142 | V | 4 | 11.4 | 8 | 79 | 1130.5 | 2170 | 3300 | 8900 | 226750 | 341100
Spreadsheet: 73442d1274113277-multi-sheet-formula-auto-populate-updated-week-4
Sheet: WEEK 2

 |  | THE HIT PARADE
 |  | Monday |  |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 |  | 2010-04-26 00:00:00 |  |  | 2010-04-27 00:00:00 |  | 2010-04-28 00:00:00 |  | 2010-04-29 00:00:00 |  | 2010-04-30 00:00:00 |  | 2010-05-01 00:00:00 |  | 2010-05-02 00:00:00
 | Player | Hits | Points |  | Hits | Points | Hits | Points | Hits | Points | Hits | Points | Hits | Points | Hits | Points |  |  |  | TOTAL HITS
Cubie | Pablo Sandoval | 2 |  |  | 2 |  | 2 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0 |  |  | 7 | 18
 | [NAME] | 1 |  |  | 0 |  | 1 |  | 1 |  | 1 |  | 3 |  | 0 |  |  |  |  | 7
 | Geovany Soto | 0 |  |  | 2 |  | 0 |  | 0 |  | 1 |  | 1 |  | 0 |  |  |  |  | 4
Dwayne | [NAME] | 0 |  |  | 1 |  | 2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 3 | 16
 | [NAME] Holliday | 1 |  |  | 0 |  | 0 |  | 1 |  | 2 |  | 1 |  | 0 |  |  |  |  | 5
 | [NAME] | 0 |  |  | 1 |  | 0 |  | 0 |  | 2 |  | 2 |  | 3 |  |  |  |  | 8
[NAME] | Prince Fielder | 3 | 1 |  | 1 |  | 0 |  | 1 |  | 0 |  | 1 |  | 0 |  | 1 |  |  | 6 | 23
 | [NAME] | 3 |  |  | 1 |  | 2 |  | 0 |  | 2 |  | 1 |  | 1 |  |  |  |  | 10
 | [NAME] | 0 |  |  | 0 |  | 0 |  | 2 |  | 1 |  | 2 |  | 2 |  |  |  |  | 7
[NAME] | [NAME] | 3 |  |  | 1 |  | 2 |  | 0 |  | 2 | 1 | 1 |  | 1 |  | 1 |  |  | 10 | 22
 | [NAME] | 0 |  |  | 1 |  | 0 |  | 0 |  | 3 |  | 2 |  | 3 |  |  |  |  | 9
 | [NAME] | 0 |  |  | 1 |  | 1 |  | 0 |  | 1 |  | 0 |  | 0 |  |  |  |  | 3
[NAME] | [NAME] | 2 |  |  | 1 |  | 2 |  | 2 |  | 1 |  | 2 |  | 3 | 1 | 1 |  |  | 13 | 24
 | [NAME] | 2 |  |  | 1 |  | 0 |  | 0 |  | 2 |  | 0 |  | 1 |  |  |  |  | 6
 | [NAME] | 0 |  |  | 1 |  | 1 |  | 0 |  | 1 |  | 1 |  | 1 |  |  |  |  | 5
Kent | [NAME] | 2 |  |  | 1 |  | 2 |  | 2 |  | 1 |  | 3 | 1 | 3 | 1 | 2 |  |  | 14 | 29
 | [NAME] | 0 |  |  | 1 |  | 0 |  | 0 |  | 3 |  | 2 |  | 3 |  |  |  |  | 9
 | [NAME] | 0 |  |  | 1 |  | 1 |  | 1 |  | 0 |  | 1 |  | 2 |  |  |  |  | 6
Nate | Pablo Sandoval | 2 |  |  | 2 |  | 2 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0 |  |  | 7 | 17
 | [NAME] | 1 |  |  | 1 |  | 2 |  | 2 |  | 1 |  | 2 |  | 0 |  |  |  |  | 9
 | [NAME] | 0 |  |  | 1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  | 1
[NAME] | [NAME] | 3 |  |  | 1 |  | 2 | 1 | 0 |  | 2 | 1 | 1 |  | 1 |  | 2 |  |  | 10 | 23
 | [NAME] | 0 |  |  | 0 |  | 1 |  | 4 |  | 1 |  | 1 |  | 0 |  |  |  |  | 7
 | [NAME] | 0 |  |  | 0 |  | 2 |  | 0 |  | 2 |  | 2 |  | 0 |  |  |  |  | 6
Scott | [NAME] | 3 |  |  | 1 | 1 | 2 | 1 | 0 |  | 2 |  | 1 |  | 1 |  | 2 |  |  | 10 | 28
 | [NAME] | 1 |  |  | 3 |  | 1 |  | 0 |  | 1 |  | 2 |  | 0 |  |  |  |  | 8
 | [NAME] | 0 |  |  | 3 |  | 2 |  | 1 |  | 1 |  | 1 |  | 2 |  |  |  |  | 10
Top hitter | [NAME] | 14
Not Hitter | [NAME] | 1
Spreadsheet: 797382d1663855187-formula-to-pull-above-average-branches-to-winners-column-winners
Sheet: Sheet1

Growth |  |  |  | Profit |  |  |  | Service Score
Branch | Percent |  |  | Branch | Profit |  |  | Branch | Service |  |  | Winners
Branch 18 | 0.26 |  |  | Branch 1 | 600 |  |  | Branch 2 | 90
Branch 10 | 0.25 |  |  | Branch 2 | 600 |  |  | Branch 3 | 90
Branch 20 | 0.25 |  |  | Branch 3 | 600 |  |  | Branch 6 | 90
Branch 9 | 0.24 |  |  | Branch 17 | 600 |  |  | Branch 7 | 90
Branch 8 | 0.23 |  |  | Branch 18 | 600 |  |  | Branch 9 | 90
Branch 7 | 0.22 |  |  | Branch 19 | 600 |  |  | Branch 11 | 90
Branch 17 | 0.22 |  |  | Branch 20 | 600 |  |  | Branch 13 | 90
Branch 19 | 0.22 |  |  | Branch 5 | 550 |  |  | Branch 17 | 90
Branch 6 | 0.21 |  |  | Branch 6 | 550 |  |  | Branch 19 | 90
Corporate Avg | 0.2 |  |  | Corporate Avg | 500 |  |  | Branch 20 | 90
Branch 5 | 0.19 |  |  | Branch 13 | 450 |  |  | Corporate Avg | 85
Branch 4 | 0.18 |  |  | Branch 14 | 450 |  |  | Branch 1 | 80
Branch 13 | 0.18 |  |  | Branch 15 | 450 |  |  | Branch 4 | 80
Branch 3 | 0.17 |  |  | Branch 16 | 450 |  |  | Branch 5 | 80
Branch 12 | 0.17 |  |  | Branch 4 | 400 |  |  | Branch 8 | 80
Branch 14 | 0.17 |  |  | Branch 7 | 300 |  |  | Branch 10 | 80
Branch 2 | 0.16 |  |  | Branch 8 | 300 |  |  | Branch 12 | 80
Branch 11 | 0.16 |  |  | Branch 9 | 300 |  |  | Branch 14 | 80
Branch 15 | 0.16 |  |  | Branch 10 | 300 |  |  | Branch 15 | 80
Branch 1 | 0.15 |  |  | Branch 11 | 300 |  |  | Branch 16 | 80
Branch 16 | 0.15 |  |  | Branch 12 | 300 |  |  | Branch 18 | 80
Spreadsheet: michelle_lokay__26635__tw 2 01
Sheet: Sheet1

 |  |  | tw | epng | cb |  | san juan | perm | san juan | perm
 |  |  | san juan | perm | gas daily | fixed | volume | volume | fuel | fuel | total p/l | SET p/l | TW p/l |  |  | sj/fixed | perm/fixed
 | 2001-02-01 00:00:00 |  | 5.82 | 6.08 | 13.745 | 13.745 | 0 | 5000
 | 2001-02-02 00:00:00 |  | 5.81 | 6.005 | 15.63 | 14.7 | 8024 | 5000
 | 2001-02-03 00:00:00 |  | 6.41 | 6.58 | 15.63 |  | 10000 | 5000
 | 2001-02-04 00:00:00 |  | 6.41 | 6.58 | 15.63 |  | 10000 | 5000
 | 2001-02-05 00:00:00 |  | 6.41 | 6.58 | 15.63 |  | 10000 | 5000
 | 2001-02-06 00:00:00 |  | 5.61 | 5.725 | 15.63 |  | 10000 | 5000
 | 2001-02-07 00:00:00 |  | 5.38 | 5.53 | 12.61 |  | 10000 | 5000
 | 2001-02-08 00:00:00 |  | 5.725 | 5.79 | 13.23 | 13.23 | 10000 | 5000
 | 2001-02-09 00:00:00 |  | 6.37 | 6.425 | 12.28 | 12.28 | 10000 | 5000
 | 2001-02-10 00:00:00 |  | 6.29 | 6.305 | 14.83 | 14.81 | 10000 | 5000
 | 2001-02-11 00:00:00 |  | 6.29 | 6.305 | 14.83 | 14.81 | 10000 | 5000
 | 2001-02-12 00:00:00 |  | 6.29 | 6.305 | 14.83 | 14.81 | 10000 | 5000
 | 2001-02-13 00:00:00 |  | 5.765 | 5.725 | 19.775 | 18.28 | 10000 | 5000
 | 2001-02-14 00:00:00 |  | 5.445 | 5.575 | 34.525 | 30 | 9747 | 5000
 | 2001-02-15 00:00:00 |  | 5.85 | 5.93 | 36.79 | 33.98 | 10000 | 5000
 | 2001-02-16 00:00:00 |  | 5.405 | 5.485 | 33.25 | 30.98 | 10000 | 5000
 | 2001-02-17 00:00:00 |  | 5.39 | 5.505 | 25.245 | 21 | 9975 | 5000
 | 2001-02-18 00:00:00 |  | 5.39 | 5.505 | 25.245 | 21 | 9983 | 5000
 | 2001-02-19 00:00:00 |  | 5.39 | 5.505 | 25.245 | 21 | 10000 | 5000
 | 2001-02-20 00:00:00 |  | 5.39 | 5.505 | 25.245 | 21 | 10000 | 5000
 | 2001-02-21 00:00:00 |  | 5.205 | 5.255 | 24.43 | 22.98 | 10000 | 5000
 | 2001-02-22 00:00:00 |  | 5.27 | 5.27 | 21.69 | 18.98 | 10000 | 5000
 | 2001-02-23 00:00:00 |  | 5.085 | 5.15 | 17.48 | 17.48 | 10000 | 5000
 | 2001-02-24 00:00:00 |  | 4.9 | 5.005 | 12.68 | 12.48 | 9999 | 5000
 | 2001-02-25 00:00:00 |  | 4.9 | 5.005 | 12.68 | 12.48 | 10000 | 5000
 | 2001-02-26 00:00:00 |  | 4.9 | 5.005 | 12.68 | 12.48 | 10000 | 5000
 | 2001-02-27 00:00:00 |  | 4.91 | 5.045 | 13.12 | 12.98 | 9943 | 5000
 | 2001-02-28 00:00:00 |  | 4.97 | 5.09 | 12.45 | 11.98 | 9652 | 4885
Spreadsheet: john_griffith__15988__AIG
Sheet: Sheet1

 |  |  |  |  |  |  |  | 2001-11-19 00:00:00 |  |  | 2001-11-20 00:00:00 |  |  | 2001-11-21 00:00:00
 |  |  |  |  |  |  |  | Premium | MTM |  | Premium | MTM |  | Premium | MTM
 |  |  |  |  | Strike
Deal 1 | 300 bbl/day | 2001-12-01 00:00:00 | Long | Call | 28.7 |  |  | 6.51022 |  |  | 5.7 |  |  | 5.99
 |  |  | Short | Put | 25
Deal 2 | 600 bbl/day | Dec-01-Dec-02 | Long | Call | 26.9 |  |  | 4.83364 |  |  | 4.35 |  |  | 4.69
 |  |  | Short | Put | 24
Deal 3 | 500 bbl/day | 2002-12-01 00:00:00 | Long | Call | 24.85 |  |  | 3.09277 |  |  | 2.71 |  |  | 3.06
 |  |  | Short | Put | 23
Spreadsheet: 558246d1516981783-using-if-function-across-multiple-sheets-and-cell-sample-data
Sheet: Inventory

Computer Name | Business Unit
MICKEY5-LAP
FREDWALLS-LAP
AABLUE1
MIHILL-mac
CALLSYS-mac1
FORESTGUMP-LAP
CIAALPHA
[NAME]
WADISNEY-LAP
TBRADY-LAP
DWROCK-LAP
APBIO
Spreadsheet: 783302d1654713814-filter-instead-of-index-and-small-sample
Sheet: FilteredResult

[NAME] |  | DATE | TIME | COURSE | CLASSROM |  |  |  |  | DATE | TIME | COURSE | CLASSROM
Name1 |  |  | 12:00:00 | Literature | ? |  |  |  |  |  |  |  | 10A
 |  | 2020-11-11 00:00:00 | 12:00:00 | Chemistry | ? |  |  |  |  |  |  |  | 11B
 |  | 2020-11-25 00:00:00 | 12:00:00 | Physics | ? |  |  |  |  |  |  |  | 10A
 |  | ? |  |  |  |  |  |  |  |  |  |  | 10B
 |  | ? |  |  |  |  |  |  |  |  |  |  | 10A
 |  | "F1:=FILTER(GivenTable!A2:C13; GivenTable!D2:D13=A2)" |  |  |  |  |  |  |  |  |  |  | 10B
 |  |  |  |  |  |  |  |  |  |  |  |  | 10C
 |  |  | 12:00:00 | Literature | 10A
 |  | 2020-11-05 00:00:00 | 12:00:00 | German | 11B
 |  | 2020-11-11 00:00:00 | 12:00:00 | Chemistry | 10A
 |  | 2020-11-12 00:00:00 | 12:00:00 | English | 10B
 |  | 2020-11-25 00:00:00 | 12:00:00 | Physics | 10A
 |  | 2020-11-26 00:00:00 | 12:00:00 | History | 10B
 |  | 2020-12-02 00:00:00 | 12:00:00 | Geometry | 10C
 |  |  | 12:00:00 | Literature | 10A
 |  | 2020-11-05 00:00:00 | 12:00:00 | German | 11B
 |  | 2020-11-11 00:00:00 | 12:00:00 | Chemistry | 10A
 |  | 2020-11-12 00:00:00 | 12:00:00 | English | 10B
 |  | 2020-11-25 00:00:00 | 12:00:00 | Physics | 10A
 |  | 2020-11-26 00:00:00 | 12:00:00 | History | 10B
 |  | 2020-12-02 00:00:00 | 12:00:00 | Geometry | 10C
 |  |  | 12:00:00 | Literature | 10A
 |  | 2020-11-05 00:00:00 | 12:00:00 | German | 11B
 |  | 2020-11-11 00:00:00 | 12:00:00 | Chemistry | 10A
 |  | 2020-11-12 00:00:00 | 12:00:00 | English | 10B
 |  | 2020-11-25 00:00:00 | 12:00:00 | Physics | 10A
 |  | 2020-11-26 00:00:00 | 12:00:00 | History | 10B
 |  | 2020-12-02 00:00:00 | 12:00:00 | Geometry | 10C
Spreadsheet: 598785d1542719942-returning-a-sum-and-max-result-dependent-on-data-return-sum-and-max-result
Sheet: Sheet1

 | Date | Exercise | Weight ([NAME]) | Add. Weight ([NAME]) | Total Weight ([NAME]) | Set1 | Set2 | Set3 | Set4 | Set5 | Total Reps | Rest Period | Time | Notes
 |  | Press-Ups | 82 | 10 |  | 25 | 30 | 20 | 16 | 12
 |  | [NAME] | 82 | 10 |  | 10 | 8 | 6 | 16 | 12
 |  | Press-Ups | 82 | 10 |  | 22 | 31 | 21 | 16 | 12
 |  | Press-Ups | 82 | 10 |  | 25 | 27 | 20 | 16 | 12
 | Date | Exercise | Weight ([NAME]) | Add. Weight ([NAME]) | Total Weight ([NAME]) | Set | Score
 | 2018-11-01 00:00:00 | Press-Ups | 82 | 10 | 92 | 1 | 25
 | 2018-11-01 00:00:00 | Press-Ups | 82 | 10 | 92 | 2 | 30
 | 2018-11-01 00:00:00 | Press-Ups | 82 | 10 | 92 | 3 | 20
 | 2018-11-01 00:00:00 | Press-Ups | 82 | 10 | 92 | 4 | 16
 | 2018-11-01 00:00:00 | Press-Ups | 82 | 10 | 92 | 5 | 12
 | 2018-11-02 00:00:00 | [NAME] | 82 | 10 | 92 | 1 | 10
 | 2018-11-02 00:00:00 | [NAME] | 82 | 10 | 92 | 2 | 8
 | 2018-11-02 00:00:00 | [NAME] | 82 | 10 | 92 | 3 | 6
 | 2018-11-02 00:00:00 | [NAME] | 82 | 10 | 92 | 4 | 16
 | 2018-11-02 00:00:00 | [NAME] | 82 | 10 | 92 | 5 | 12
 | 2018-11-03 00:00:00 | Press-Ups | 82 | 10 | 92 | 1 | 22
 | 2018-11-03 00:00:00 | Press-Ups | 82 | 10 | 92 | 2 | 31
 | 2018-11-03 00:00:00 | Press-Ups | 82 | 10 | 92 | 3 | 21
 | 2018-11-03 00:00:00 | Press-Ups | 82 | 10 | 92 | 4 | 16
 | 2018-11-03 00:00:00 | Press-Ups | 82 | 10 | 92 | 5 | 12
 | 2018-11-04 00:00:00 | Press-Ups | 82 | 10 | 92 | 1 | 25
 | 2018-11-04 00:00:00 | Press-Ups | 82 | 10 | 92 | 2 | 27
 | 2018-11-04 00:00:00 | Press-Ups | 82 | 10 | 92 | 3 | 20
 | 2018-11-04 00:00:00 | Press-Ups | 82 | 10 | 92 | 4 | 16
 | 2018-11-04 00:00:00 | Press-Ups | 82 | 10 | 92 | 5 | 12
Spreadsheet: 41780d1240307613-copy-and-paste-using-if-criteria-example
Sheet: Sheet1

Date | Home | Away | Home Score | Away Score | Result | Home Odds | Draw Odds | Away Odds | Complete
2008-08-08 00:00:00 | Barrow | Oxford United | 3 | 0 | H | 3.3 | 3.3 | 2.2 | X
2008-08-09 00:00:00 | Crawley Town | York City | 0 | 1 | A | 2.25 | 3.3 | 3.2 | X
2008-08-09 00:00:00 | [NAME] | Rushden & Diamonds | 0 | 1
2008-08-09 00:00:00 | Ebbsfleet United | Mansfield Town | 2 | 2 | D | 2.3 | 3.3 | 3.1 | X
2008-08-09 00:00:00 | Histon | [NAME] | 1 | 1 | D | 2.8 | 3.4 | 2.3 | X
2008-08-09 00:00:00 | Kettering Town | Forest Green Rovers | 1 | 1 | D | 2.38 | 3.3 | 2.8 | X
2008-08-09 00:00:00 | Kidderminster Harriers | Lewes | 1 | 1 | D | 1.67 | 3.5 | 5.5 | X
2008-08-09 00:00:00 | [NAME] | Cambridge United | 0 | 1 | A | 3.2 | 3.3 | 2.45 | X
2008-08-09 00:00:00 | Salisbury City | [NAME] | 0 | 1
2008-08-09 00:00:00 | Weymouth | Grays Athletic | 3 | 1 | H | 1.86 | 3.4 | 4.2 | X
2008-08-09 00:00:00 | Woking | [NAME] | 1 | 2
2008-08-09 00:00:00 | [NAME] | Stevenage Borough | 5 | 0
Spreadsheet: 369c973c-2cc6-49fb-90f9-9cee2eeab7e3
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Internettoperatører
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
[NAME] | [NAME]. 2 | 0159 | Oslo | 400 01 525
[NAME] | Langkaia 1 | 0150 | Oslo | 22 91 03 50
Filemail AS | [NAME] vei 3 | 0667 | Oslo | 23 05 19 75
Iper Direkte AS | [NAME] | 1067 | Oslo | 21 42 02 42
Gylløw Kjersti www.klonus.no | Bondalsåsen 5 | 1400 | Ski | 915 20 937
Themoon AS | Agathe [NAME] gate 44 | 0478 | Oslo | 907 38 000
Dipper AS | [NAME] gate 21 | 0153 | Oslo | 06020
Yoo DA | [NAME] 7 | 0190 | Oslo | 22 17 72 17
Nowshop AS | [NAME] 15D | 0790 | Oslo | 456 90 361
[NAME] |  | 3183 | Horten | 33 03 69 28
Damaca-Trading [NAME] | [NAME] gate 4B | 2315 | Hamar | 942 56 932
Natt & Dag Hybel.no | Strandgata 19 | 0152 | Oslo | 22 41 94 41
[NAME] | Eikskollen 6B | 1361 | Østerås | 959 29 758
TradeDoubler AS | Youngstorget 1 | 0181 | Oslo | 22 40 35 30
Go Mobil AS | [NAME] | 3264 | Larvik | 904 18 599
[NAME] Ide | Skånevegen 14C | 2067 | Jessheim | 934 28 850
Greeninspirations AS | Vøyenalléen 20 | 2160 | Vormsund | 909 37 909
[NAME] | Lillovegen 7 | 1925 | Blaker | 930 43 454
Numaquest AS | Fürstveien 1B | 1367 | Snarøya | 928 58 355
[NAME] AS | Vabråten 142 | 1392 | Vettre | 905 56 300
Poi Nordic AS | [NAME] | 2020 | Skedsmokorset | 472 42 617
All In Web | Strandgata 13C | 2815 | Gjøvik | 61 17 32 60
Stayonline AS | Lislebyveien 58-60 | 1604 | Fredrikstad | 69 31 50 10
Oogababy AS | Hissingbygata 10 | 1640 | [NAME] | 402 22 020
[NAME] |  | 3440 | [NAME] | 996 09 168
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 71075d1271803411-countif-with-multiple-criteria-example1
Sheet: Metals

 | Criteria |  |  | A | B | C | D | E | F | G | H | # Times Exceeds Criteria
 | 1 | 2 | 3 |  |  |  |  |  |  |  |  | 1 | 2 | 3
Event
1 | 20 | 40 | 40 | 0.9 | 0.8 | 2.8 | 1.3 | 0.8 | 0.7 | < 0.1 | 0.6 | 0 | 0 | 0
2 | 12 | 12 | 15 | 22 | 14.8 | 43.6 | 16.7 | 18.2 | 19.4 | 10.6 | 14.3 | 0 | 2 | 5
3 | 500 | 2000 | 4000 | 53 | 600 | 118 | 2500 | 56 | 61 | 5000 | 55 | 1 | 1 | 1
4 | 4 | 8 | 8 | < 1 | < 1 | < 1 | < 1 | < 1 | < 1 | < 1 | < 1 | 0 | 0 | 0
5 | ns | ns | ns | < 1 | < 1 | < 1 | < 1 | < 1 | 2 | < 1 | < 1 | 0 | 0 | 0
6 | 10 | 22 | 22 | < 0.2 | < 0.2 | < 0.2 | < 0.2 | < 0.2 | < 0.2 | < 0.2 | < 0.2 | 0 | 0 | 0
7 | 64 | 87 | 87 | 10 | 9 | 9 | 8 | 10 | 10 | 10 | 11 | 0 | 0 | 0
8 | 50 | 300 | 300 | 6 | 5 | 5 | 6 | 6 | 7 | 7 | 7 | 0 | 0 | 0
9 | 63 | 91 | 91 | 38 | 40 | 45 | 24 | 45 | 34 | 28 | 32 | 0 | 0 | 0
10 | 140 | 260 | 600 | 9.4 | 11.5 | 7.7 | 7.3 | 12.5 | 9 | 6.4 | 6 | 0 | 0 | 0
11 | ns | ns | ns | 350 | 293 | 285 | 384 | 383 | 453 | 322 | 403 | 0 | 0 | 0
12 | 6.6 | 24 | 50 | 0.1 | 0.04 | 0.11 | 0.04 | 0.09 | 0.07 | 0.02 | 0.05 | 0 | 0 | 0
13 | 10 | 40 | 40 | 1.5 | 2.3 | 1.9 | 0.9 | 1.2 | 1.3 | 0.7 | 1.3 | 0 | 0 | 0
14 | 50 | 50 | 50 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 0 | 0 | 0
15 | 1 | 2.9 | 2.9 | 1 | 0.9 | 2.6 | 1.5 | 0.8 | 1.1 | 0.3 | 0.7 | 4 | 0 | 0
16 | 20 | 40 | 40 | < 0.1 | < 0.1 | 0.1 | < 0.1 | < 0.1 | 0.1 | < 0.1 | 0.1 | 0 | 0 | 0
17 | ns | ns | ns | 109 | 103 | 217 | 149 | 137 | 119 | 123 | 129 | 0 | 0 | 0
18 | ns | ns | ns | 11 | 10 | 17 | 9 | 11 | 12 | 12 | 10 | 0 | 0 | 0
19 | 1 | 1 | 1 | < 0.1 | < 0.1 | < 0.1 | < 0.1 | < 0.1 | < 0.1 | < 0.1 | < 0.1 | 0 | 0 | 0
20 | 50 | 300 | 300 | < 5 | < 5 | < 5 | < 5 | < 5 | < 5 | < 5 | < 5 | 0 | 0 | 0
21 | 130 | 130 | 130 | 39 | 38 | 43 | 35 | 39 | 42 | 42 | 44 | 0 | 0 | 0
22 | 200 | 360 | 360 | 52 | 45 | 39 | 42 | 102 | 58 | 81 | 62 | 0 | 0 | 0
Spreadsheet: 789716d1659321447-ratio-to-staff-calculator-ratio-calc-copy
Sheet: Sheet1

 |  |  |  | [NAME]'s ratio to staff calcuator
 |  |  |  | Ratio
 |  |  |  | 1 | 2 | 3 | 4
 |  |  |  | 1:1 | 1:2 | 1:3 | 1:4
 |  |  |  | 0 | 5 | 12 | 2
 |  |  | Total | 0 | 3 | 4 | 0
 |  |  | Residual | 0 | 0 | 1 | 2
 |  |  | Total staff | 7
 |  |  | Total + IC | 8
 |  |  | Nursing hours (8hrs) |  | 64
 |  |  | Nursing night (10hrs) |  | 80
 |  |  | Total no of pt |  | 19
Spreadsheet: 873031d1719475978-output-based-on-the-leading-status-excel-formula-with-condition
Sheet: Sheet1

TB Cash | TB Trade | DCDA | CC | FM | Output
Completed | Completed | Completed | Completed | Completed | Completed
Completed | Overdue | In Progress | Completed | Not Started | Overdue
At Risk | Completed | In Progress | Completed | Completed | At Risk
Completed | Completed | In Progress | Completed | Completed | In Progress
 |  |  |  |  | Not Started
Spreadsheet: 759632d1639642790-query-to-find-the-highest-overal-percentage-from-different-data-types-subs-generals-hydr2-
Sheet: Sheet1

 | [NAME]
General | Total Attack | Total Def | Total HP | GR Atk | Gr Def | GR HP | Mount Atk | Mount Def | Mount HP | [NAME] | [NAME] | Range HP | [NAME] | Seige Def | Seige HP
Baldwin IV |  |  |  |  |  |  |  |  |  | -0.3 |  |  | -0.2
[NAME] | -0.1 |  | -0.1
[NAME] |  | -0.1 |  |  |  |  |  |  |  | -0.3
Cnut the Great |  |  |  |  |  | -0.15 |  |  | -0.15 | -0.25
Arminius |  |  |  |  |  | -0.1 |  |  | -0.1 | -0.15 |  |  | -0.15
Jester | -0.15
Flavius Aetius |  |  |  |  |  | -0.2 |  |  |  |  |  |  | -0.2
[NAME] I | -0.1 |  |  |  |  |  | -0.2
[NAME] |  |  |  | -0.25 |  |  |  |  |  | -0.15 |  |  | -0.15
[NAME] I |  |  |  | -0.35 |  | -0.2 |  |  | -0.2
Empress Dowager Cixi |  | -0.15 |  |  | -0.15
Nero |  |  | -0.15
[NAME] | -0.1
[NAME] |  |  |  |  |  |  |  |  | -0.2 | -0.2
[NAME] |  |  |  |  |  |  |  |  |  | -0.1 |  |  | -0.1
Honda Tadakatsu |  |  |  |  |  | -0.15 |  |  | -0.15
Constantine the Great |  |  |  | -0.2 |  |  | -0.2
Himiko |  |  |  |  |  |  | -0.25
[NAME] |  |  |  | -0.15 |  |  | -0.15
General Selection | Total Attack | Total Def | Total HP | GR Atk | Gr Def | GR HP | Mount Atk | Mount Def | Mount HP | [NAME] | [NAME] | Range HP | [NAME] | Seige Def | Seige HP
1,2,3,4,5,6,7,8,9
 | the needed calculator sample it’s static as of now but I really want to find a way to select and choose form the above list 9 Generals and Excel sheet at the end calculate and show results automatically as shown below
 | Select Generals
 |  | [NAME] | [NAME] | Baldwin IV | Baldwin IV | Baldwin IV | Baldwin IV | Baldwin IV | Baldwin IV | Baldwin IV
 | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
 | Ground | Mounted | Ranged | Seige | Ground | Mounted | Ranged | Seige | Ground | Mounted | Ranged | Seige
 | in which here the values will calculate all the debuffs in each field of the above table and put it here, the total is added to all troop types, as example:  [NAME], has -10% atk and HP for all troops, means this will give a -10% in attack in all the values calculated in cells B35,C35,D35,E35 and same goes in J35,K35,L35,M35