tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220179d1363091110-vlookup-not-working-as-intended-vlookup-problem
Sheet: 01

 | Weekly Time Sheet
 | Week Number: | 1
 | Week Start: | 2013-01-01 00:00:00
 | Rate Per Hour: | 10 |  |  |  |  |  |  | Monthly Summery
 | Day | Date | Time In | Time Out | Break | Total Hours | Total Pay |  | Total Hours | Total Pay |  | Break Parameters
 | Sunday |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  | 0 | 00:00:00 |  | I get a break as soon as I hit these parameters
 | Monday |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  | 04:45:00 | 00:15:00
 | Tuesday |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  | 06:00:00 | 00:30:00
 | Wednesday |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  | 08:15:00 | 00:45:00
 | Thursday |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  | 09:00:00 | 01:30:00
 | Friday |  | 00:00:00 | 00:00:00
 | Saturday |  | 00:00:00 | 00:00:00
 |  |  |  |  | Total:
 | Week Number:
 | Week Start:
 | Rate Per Hour: | 10
 | Day | Date | Time In | Time Out | Break | Total Hours | Total Pay
 | Sunday |  | 07:00:00 | 13:00:00 |  |  |  | Showing a 15 minute break rather than 30
 | Monday |  | 08:00:00 | 14:00:00 |  |  |  | Correctly showing up as 30 here
 | Tuesday |  | 12:00:00 | 16:45:00 |  |  |  | Wrong
 | Wednesday |  | 00:00:00 | 04:45:00 |  |  |  | Correct
 | Thursday |  | 00:00:00 | 00:00:00
 | Friday |  | 00:00:00 | 00:00:00
 | Saturday |  | 00:00:00 | 00:00:00
 |  |  |  |  | Total:
 | Week Number:
 | Week Start:
 | Rate Per Hour: | 10
 | Day | Date | Time In | Time Out | Break | Total Hours | Total Pay
 | Sunday |  | 00:00:00 | 00:00:00
 | Monday |  | 00:00:00 | 00:00:00
 | Tuesday |  | 00:00:00 | 00:00:00
 | Wednesday |  | 00:00:00 | 00:00:00
 | Thursday |  | 00:00:00 | 00:00:00
 | Friday |  | 00:00:00 | 00:00:00
 | Saturday |  | 00:00:00 | 00:00:00
 |  |  |  |  | Total:
 | Week Number:
 | Week Start:
 | Rate Per Hour: | 10
 | Day | Date | Time In | Time Out | Break | Total Hours | Total Pay
 | Sunday |  | 00:00:00 | 00:00:00
 | Monday |  | 00:00:00 | 00:00:00
 | Tuesday |  | 00:00:00 | 00:00:00
 | Wednesday |  | 00:00:00 | 00:00:00
 | Thursday |  | 00:00:00 | 00:00:00
 | Friday |  | 00:00:00 | 00:00:00
 | Saturday |  | 00:00:00 | 00:00:00
 |  |  |  |  | Total:
Spreadsheet: 132103d1323480952-combining-vlookup-and-if-formula-to-return-a-value-breeze123
Sheet: Sheet2

[NAME] | Jan Sales | Comm % | Bonus  Scheme
Gibbons,[NAME] | 2450
Pascoe,[NAME] | 8890
Walters,[NAME] | 4765
Stringer,[NAME] | 7680
Knott,Delia | 5790
Thompson,[NAME] | 4730
[NAME],[NAME] | 7988
Gordon,Marie | 6750
Spreadsheet: 55bdde3f-7eba-41de-88c8-eea3928191a1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-01-10 09:23:59.740000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.5 | 101.5 | 101.375 | 100.875 |  | and are added to price quote
5.125 | 101.145 | 101.145 | 101.02 | 100.52
5 | 100.843 | 100.843 | 100.718 | 100.218 |  | Note: | Refer To Price [NAME]
4.875 | 100.032 | 100.032 | 99.907 | 99.407 |  |  | For all Price Adjs
4.75 | 99.521 | 99.521 | 99.396
4.625 | 98.51 | 98.51 | 98.385
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.625 | 101.067 | 101.067 | 100.942 | 100.442
4.5 | 100.89 | 100.89 | 100.765 | 100.265
4.375 | 100.658 | 100.658 | 100.533 | 100.033
4.25 | 100.164 | 100.164 | 100.039 | 99.53899999999999
4.125 | 98.893 | 98.893 | 98.768
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-01-10 09:23:59.740000
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-01-24 09:23:59.740000
30 DAY | 2011-02-08 09:23:59.740000
45 DAY | 2011-02-23 09:23:59.740000
60 DAY | 2011-03-10 09:23:59.740000
90 DAY | 2011-04-09 09:23:59.740000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 751448d1634124116-convert-sumifs-to-sumproduct-or-similar-example-2-
Sheet: Stock Requirement

 |  |  | 2021
 |  | Year to Analyse
 |  | Description |  | Totals
 | Wallets | Wallet Clear Plastic -B/fly/A7 Slot
 |  | Wallet Print @ Home
 |  | Wallet [NAME]
 |  | Wallet A7 with Croc Clip
 |  | Wallet [NAME]
 |  | Wallet [NAME]
 |  | No Wallets
Spreadsheet: 867633d1714460891-how-to-use-xlookup-to-get-value-when-lookup-column-contains-delimiters-example-worksheet
Sheet: Sheet2

WOS ID | Organisational Unit
995691000001 | Need the value from Sheet 1, Column B here
820412200001 | Need the value from Sheet 1, Column B here
1076331200002 | Need the value from Sheet 1, Column B here
1170341900010 | Need the value from Sheet 1, Column B here
1087557900001 | Need the value from Sheet 1, Column B here
1062350900014 | Need the value from Sheet 1, Column B here
852908600001 | Need the value from Sheet 1, Column B here
867496600001 | Need the value from Sheet 1, Column B here
992025900001 | Need the value from Sheet 1, Column B here
932007600001 | Need the value from Sheet 1, Column B here
1116649900001 | Need the value from Sheet 1, Column B here
951953100001 | Need the value from Sheet 1, Column B here
1127715000001 | Need the value from Sheet 1, Column B here
957125500001 | Need the value from Sheet 1, Column B here
1103847400001 | Need the value from Sheet 1, Column B here
1195011200001 | Need the value from Sheet 1, Column B here
1203546900001 | Need the value from Sheet 1, Column B here
1193922500001 | Need the value from Sheet 1, Column B here
1197107900008 | Need the value from Sheet 1, Column B here
Spreadsheet: 140886d1328923648-large-database-yfeb-food-total-values
Sheet: 2-23-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 | Daily Total
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
Spreadsheet: 776257d1649654821-sum-category-by-month-book2-3-
Sheet: Summary

Total expenses for the year
 | Van | Truck | [NAME] | Pam
101
102
201
202
Van, [NAME], and [NAME]
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
101
102
201
202
Pam Expenses
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Cash
Check
Credit Card
Spreadsheet: 69002d1269527253-work-rota-workroatatest
Sheet: Sheet1

 |  | NIKOLA | [NAME] | [NAME] | KAYLEIGH | [NAME] | JESSICA | STEPHEN | [NAME] |  | CHRIS
Day | Date | B | C | D | E | A
FRI | 4 | 12-8 | COURSE | 2.30-10.30 | 6-2 |  | COURSE
SAT | 5 | OFF | 1.30-9.30 | OFF | 10-6 |  | HOL
SUN | 6 | 7-3 | OFF | OFF | 1.30-9.30 |  | HOL
MON | 7 | 6-2 | 7-3 | 2.30-10.30 | OFF |  | ER
TUE | 8 | OFF | 2.30-10.30 | 7-3 | OFF |  | HOL
WED | 9 | 7-3 | OFF | 6-2 | 2.30-10.30 |  | HOL |  | 12-8
THUR | 10 | 6-2 | 7-3 | 2.30-10.30 | 12-8 |  | HOL
 | Sub Total | 40 | 40 | 40 | 40 | 0 | 0 | 0 | 8 |  | 40 |  | Total | 208
 | Late to Early
 | Cell is red if there is an late to an early schedualed
 | lates are 2.30- 10.30 or 1.30-9.30
 | earlys are 6-2 or 7-3
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: Payment

Player | (£) | (£)
[NAME] | 5 | 5
[NAME] | 5
[NAME] | 5
[NAME] | 5
[NAME] | 5
[NAME] | 5
[NAME] | 5
[NAME] | 5 | 5
Damian West | 5 | 5
[NAME] | 5
[NAME] | 5
[NAME] | 5
[NAME] | 5
[NAME] | 5 |  | [NAME]
[NAME] | 5 |  | [NAME]
[NAME] | 5 | 5
[NAME] | 5 | 5
[NAME] | 5
[NAME] | 5
[NAME] | 5
 |  |  |  |  | Winnings
 |  |  |  |  | 1st | 75
 |  |  |  |  | 2nd | 10
 |  |  |  |  | 3rd | 5
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -132997 | -79207 | -39109 | -92874
2 | -112568 | -53005 | -40001 | -99950 |  |  |  |  |  |  |  |  |  | Avg
3 | -144086 | -117734 | -40000 | -65000 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
4 | -151514 | -150002 | -55771 | -56162
5 | -151656 | -150001 | -55077 | -56162
6 | -153786 | -150001 | -52179 | -56162 |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -705664 |  | 8.21
7 | -138012 | -58418 | -1800 | -79718 |  |  |  |  |  | 2001-02-01 00:00:00 | -661568 | -648307 |  | 5.62
8 | -144890 | -82115 | -48170 | -109950 |  |  |  |  |  | 2001-03-01 00:00:00 | -1831536 | -1828209 |  | 4.98
9 | -123111 | -64023 | -1611 | -59950 |  |  |  |  |  | 2001-04-01 00:00:00 |  | -3486797 |  | 4.87
10 | -150424 | -90703 |  | -59808 |  |  |  |  |  | 2001-05-01 00:00:00 | -3735499 | -3753054 |  | 3.82
11 | -159237 | -138136 | -58416 | -79950 |  |  |  |  |  | 2001-06-01 00:00:00 |  | -5025875 |  | 3.2
12 | -153130 | -130080 | -56945 | -79950 |  |  |  |  |  | 2001-07-01 00:00:00 | -4565965 | -4525416 |  | 2.77
13 | -136048 | -141366 | -105213 | -100666
14 | -141659 | -117756 | -48404 | -72615
15 | -141744 | -97671 | -39144 | -73315
16 | -131618 | -109589 | -88744 | -109950
17 | -142840 | -150006 | -124297 | -120000
18 | -100414 | -81014 | -83965 | -102848
19 | -107048 | -80107 | -83003 | -111256
20 | -119742 | -81015 | -57920 | -97982
21 | -141966 | -127453 | -96866 | -114950
22 | -137179 | -120862 | -74547 | -91154
23
24
25
26
27
28
29
30
31
 |  |  |  | 2001-07-31 00:00:00 |  |  | 460835.37
 |  |  |  | 2001-08-22 00:00:00
 | CBS Volume
 |  |  |  | 111236
Spreadsheet: 0980606f-0ab9-4374-9053-e157cd572d16
Sheet: Sheet1

Table 6--U.S. rice imports  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Country | 2012/13 | 2011/12 | 2011/12 | 2010/11 | 2009/10 | 2008/09
or | through | through | market | market | market | market
region | October | October | year | year | year | year
 |  |  | 1,000 metric tons
ASIA | 174.245 | 129.413 | 541.563 | 529.833 | 563.943544 | 536.401387
China | 0.594 | 1.474 | 3.571 | 3.1 | 3.786815 | 3.951477
India | 34.996 | 25.086 | 110.58 | 96.454 | 94.809691 | 74.049801
Pakistan | 3.388 | 3.084 | 15.258 | 17.297 | 19.386689 | 16.851572
Thailand | 91.98 | 94.094 | 387.642 | 393.464 | 400.976938 | 422.132044
Vietnam | 42.27 | 4.949 | 21.664 | 15.601 | 41.55395 | 17.477892
Other | 1.016999999999989 | 0.7260000000000115 | 2.84800000000007 | 3.916999999999916 | 3.429461 | 1.938601
EUROPE & FSU | 2.747 | 4.258 | 14.244 | 12.51 | 9.410672 | 7.566448
Italy | 1.994 | 1.861 | 8.201 | 7.53 | 6.220285 | 5.73241
Spain | 0.25 | 1.996 | 4.671 | 3.753 | 1.55218 | 0.419219
Russia | 0.002 | 0 | 0.024 | 0.034 | 0.032442 | 0.064456
United Kingdom | 0.1 | 0.037 | 0.039 | 0.009 | 0.126368 | 0.429608
Other | 0.4009999999999999 | 0.3640000000000003 | 1.309000000000001 | 1.183999999999997 | 1.479397 | 0.920755
WESTERN HEMISPHERE | 7.093 | 15.505 | 64.526 | 42.735403 | 42.735 | 31.065164
Argentina | 1.003 | 0.561 | 3.366 | 2.677 | 2.466583 | 1.121503
Brazil | 1.503 | 7.384 | 30.499 | 6.331 | 3.51007 | 3.902248
Canada | 2.698 | 3.906 | 16.323 | 17.067 | 15.357974 | 18.035834
Mexico | 0.264 | 0.414 | 1.085 | 1.264 | 6.120591 | 6.094151
Uruguay | 1.617 | 3.235 | 13.211 | 15.35 | 2.871551 | 1.710958
Other | 0.007999999999999785 | 0.005000000000000338 | 0.04199999999998738 | 0.045744 | 0.030665 | 0.20047
OTHER | 0.3359999999999879 | 0.3349999999999849 | 3.958000000000069 | 3.532636 | 5.470538 | 39.298261
Egypt | 0.015 | 0 | 0 | 0 | 0.644508 | 36.591199
United Arab Emirates | 0.008 | 0.2 | 0.522 | 3.03 | 4.441327 | 2.224564
Other | 0.3129999999999878 | 0.1349999999999849 | 4.2 | 0.5 | 0.384703 | 0.482498
TOTAL | 184.421 | 149.511 | 624.291 | 588.611 | 609.182188 | 614.33126
1/ Columns labeled "market year" are total August-July imports reported by the U.S. Census Bureau.
All data is reported on a product-weight basis.  Categories may not sum to total due to rounding.
Source: U.S. Census Bureau, Department of Commerce.
Last updated December 12, 2012.
Spreadsheet: 127782d1320566191-5-minute-average-but-the-time-data-is-not-constant-as-filtered-799734_neilc73
Sheet: Sheet1

Time | Date | 0
13:39:00 | 125.24
13:39:30 | 135.23 |  |  |  | Row Labels | Average of Date
13:40:00 | 200.36 |  |  |  | 13:39:00 | 165.7172727272727
13:40:30 | 125.24 |  |  |  | 13:44:30 | 113.1042857142857
13:41:00 | 100.69 |  |  |  | 13:50:30 | 94.91
13:41:30 | 125.24 |  |  |  | Grand Total | 136.1027272727272
13:42:00 | 125.24
13:42:30 | 126
13:43:00 | 254.36
13:43:30 | 250.47
13:44:00 | 254.82
13:44:30 | 125.24
13:45:00 | 113.42
13:45:30 | 113.49
13:46:30 | 148.65
13:47:00 | 124.56
13:49:00 | 113.42
13:49:30 | 52.95
13:50:30 | 52.95
13:52:30 | 59.99
13:55:00 | 135.69
13:55:30 | 131.01
Spreadsheet: 720412d1614149949-need-guidance-as-to-how-to-look-up-values-with-multiple-qualifiers-desertmj-example-for-conditional-formating-re-written
Sheet: Sheet1

 |  |  | details
 | store | Item | Status
 | 1 | RED | A
 | 1 | BLUE | A
 | 1 | ORANGE | A
 | 1 | PURPLE | A
 | 2 | RED | A
 | 2 | BLUE | O
 | 2 | ORANGE | U
 | 2 | PURPLE | A
 | 3 | RED | A
 | 3 | BLUE | A
 | 3 | ORANGE | U
 | 3 | PURPLE | U
 | 4 | RED | A
 | 4 | BLUE | A
 | 4 | ORANGE | A
 | 4 | PURPLE | A
 | 5 | RED | O
 | 5 | BLUE | A
 | 5 | ORANGE | O
 | 5 | PURPLE | A
Spreadsheet: 491401d1480455455-weighted-percentile-calculation-help-weightedpercentilesample-v2
Sheet: Sheet1

Sample Data |  |  |  |  |  |  | Desired Result
Item Number | Qty | Value |  |  |  |  |  |  | 0.05
101 | 1 | 289 |  |  |  |  |  |  | 0.25
102 | 1 | 207 |  |  |  |  |  |  | 0.5
103 | 1 | 255
104 | 2 | 204
105 | 3 | 270
106 | 1 | 277
107 | 5 | 272
108 | 1 | 259
109 | 1 | 257
110 | 1 | 253
111 | 4 | 212
112 | 1 | 234
113 | 4 | 241
114 | 3 | 291
115 | 3 | 282
116 | 4 | 231
117 | 4 | 204
118 | 4 | 277
119 | 2 | 247
120 | 2 | 237
121 | 2 | 265
122 | 1 | 278
123 | 4 | 233
124 | 4 | 202
125 | 3 | 202
126 | 2 | 210
127 | 1 | 288
128 | 2 | 259
129 | 1 | 200
130 | 2 | 268
131 | 4 | 202
132 | 1 | 238
133 | 1 | 295
134 | 3 | 267
135 | 8 | 232
136 | 1 | 227
137 | 4 | 280
138 | 1 | 252
139 | 1 | 242
140 | 1 | 270
141 | 4 | 261
142 | 2 | 209
143 | 1 | 272
144 | 3 | 286
145 | 3 | 294
146 | 4 | 209
147 | 1 | 293
148 | 4 | 217
Spreadsheet: errol_mclaughlin_jr__10018__Financial Terminations 12-19
Sheet: Termination

 |  | Events of Default/Termination
 |  | As of December 19, 2001
Term |  | Counterparty | Attorney Assigned | Enron Entity | Amount (if applicable) | Early Termination Date | Nature of Default (if any) | Contract Type(s) | Comments | Margin (Posted by Enron/Posted to Enron)
Y | 71533 | Commercial Risk Reinsurance Company Limited |  | ENA |  | 2001-12-19 00:00:00 | bankruptcy | Deal Nos. WR1288 (03/05/2001), WR1545 ([NAME]), W1566 (07/05/2001), W10254.1 (08/07/2001), and W10310.1 (08/22/2001) | Commercial Risk will calculate amount due
Y | 154968 | JP Morgan Chase Bank |  | ENA | 68907152 | 2001-11-29 00:00:00 | bankruptcy | Interest Rate and Currency Exchange Agreement (04/05/1994)
Y | 61526 | Magnum Hunter Resources, Inc. |  | ENA |  | 11/30/2001 or 12/18/2001 (date fax received) | ? | Deal Nos. Y77402.1/2 | should be 11/30 ltr terminating deal (do not have record of such ltr), if 11/30 termination is ineffective, terminate as of 12/18
Y | 90538 | Smurfit Packaging Corporation |  | ENA |  | 2001-12-19 00:00:00 | bankruptcy | swap confirmation ([NAME])
Y - ISDA & GISB | 51880 | MarkWest Hydrocarbon, Inc. |  | ENA |  | 12/21/2001; 12/02/2001 for Enfolio | credit support default, bankruptcy | ISDA ([NAME]); GISB (10/01/2001); Enfolio Master Firm Purchase/Sale Agreement (06/01/2001) | MarkWest will calculate amount due and exercise rights of setoff
Y | 53167 | Credit Lyonnais Rouse Derivatives |  | ENA |  | 2001-12-07 00:00:00 | Events of Default | financial confirmation and ISDA with NY Branch (10/30/1998) | Under the ISDA Master Agreement CLRD will determine the net amount due
Spreadsheet: rick_buy__32846__Risk Pool Report Template101501
Sheet: Current Risk Pool

EIM RISK POOL
as of 10/15/2001
 |  |  |  |  | Exposure
 | COUNTERPARTY NAME | TRADER / ORIGINATOR | DEAL DATE | Credit Approved Exposure | A/R | MTM | Committed | Total Risk Pool Exposure | Total Counterparty Exposure | COMMENTS
 | Stellar Printing Inc. | [NAME] | 2001-08-03 00:00:00 | 100000 | 458888 | 0 | 0 |  |  | Placed in Risk Pool because exposure exceeded credit line of $100,000 approved for customer & credit is awaiting financials.
 | Michigan Web Offset | [NAME] | 2001-08-22 00:00:00 | 0 | 22393.57 | 0 | 0 |  |  | Placed in Risk Pool because customer has poor payment history.
 | Enterprise NewsMedia, Inc. | [NAME] | 2001-08-30 00:00:00 | 0 | 179955.31 | 461690 |  |  |  | Placed in Risk Pool because exposure exceeded credit line of $400,000 approved for customer.
 | Tribune Review Publishing Company | [NAME] | 2001-09-07 00:00:00 | 100000 | 10841 | 0 |  |  |  | Placed in Risk Pool because exposure exceeded credit line of $100,000 approved for customer.
 | Asia Pacific Resources International Holdings Ltd. | Om Bhatia | 2001-09-12 00:00:00 | 0 | 0 | 147648 | 0 |  |  | Placed in Risk Pool because RAC is not approving any credit since company is on the verge of bankruptcy.
 | [NAME] | [NAME] | 2001-09-14 00:00:00 | 100000 | 9380 | 0 | 0 |  |  | Placed in Risk Pool because exposure exceeded credit line of $100,000 approved for customer.
 | Casey Printing | [NAME] | 2001-09-17 00:00:00 | 100000 | 0 | 0 | 22640 |  |  | Placed in Risk Pool because exposure exceeded credit line of $100,000 approved for customer.
 | Daily Gazette Company | [NAME] | 2001-09-21 00:00:00 | 100000 | 0 | 0 | 36480 |  |  | Placed in Risk Pool because exposure exceeded credit line of $100,000 approved for customer.
 | AFL Web Printing, Inc. | [NAME] | 2001-09-26 00:00:00 | 75000 | 0 | 0 | 40000 |  |  | Placed in Risk Pool because total committed value exceeded credit line of $75,000.
 | Summit Supply Company Inc. | [NAME] | 2001-09-27 00:00:00 | 100000 | 0 | 527 | 46700 |  |  | Placed in Risk Pool because total committed value exceeded credit line of $100,000
 | Bartash Printing, Inc. | [NAME] | 2001-10-03 00:00:00 | 125000 | 0 | 0 | 92200 |  |  | Placed in Risk Pool because total committed value exceeded credit line of $100,000
Total Forest Products
Remaining Forest Products Risk Pool Balance
Steel
 | Metron Steel, division of Primary Steel | [NAME] | 2001-07-31 00:00:00 | 25000 | 86893 | -9200 |  |  |  | Transaction placed in the Risk Pool because it exceeds credit line of $25,000 by $169,400.
 | Ispat Karmat | London/Bruce Garner | July | 0 |  |  | 1100000 |  |  | Enron has posted a documentary LC by which Enron is exposed to 80% of it's value is paid prior to physical receipt of steel.
 | Southmark Steel Inc | [NAME] | 2001-09-20 00:00:00 | 50000 | 230332 | 8352 | 0 |  |  | Transaction exceeds credit line by $188,684.
Total Steel
Remaining Steel Risk Pool Balance
Spreadsheet: 690984d1597405867-countifs-with-2-and-criteria-and-3-or-criteria-double-counting-multiple-criteria-countifs-example
Sheet: Sheet1

 |  | Date | 2020-08-01 00:00:00 |  |  | 2020-08-02 00:00:00 |  |  | 2020-08-03 00:00:00
Client No. | Client type | Area | Phone call | Meeting in person | Training session | Phone call | Meeting in person | Training session | Phone call | Meeting in person | Training session
1 | Space use | 1 | Yes | 1 | 1 | No | 1 | 0 | No | 0 | 0
2 | Space use | 2 | No | 4 | 1 | Yes | 2 | 1 | No | 0 | 0
3 | Respite | 2 | Yes | 2 | 1 | Yes | 1 | 2 | Yes | 0 | 0
4 | Full time | 2 | Yes | 2 | 1 | Yes | 0 | 1 | Yes | 0 | 0
5 | Space use | 1 | No | 1 | 1 | No | 1 | 1 | Yes | 0 | 0
6 | Full time | 1 | Yes | 1 | 1 | No | 2 | 1 | Yes | 0 | 0
7 | Respite | 2 | Yes | 0 | 1 | No | 1 | 2 | Yes | 0 | 0
8 | Respite | 1 | No | 1 | 1 | Yes | 1 | 1 | Yes | 0 | 0
9 | Space use | 1 | Yes | 0 | 0 | Yes | 1 | 1 | Yes | 0 | 0
10 | Space use | 2 | No | 0 | 0 | Yes | 1 | 2 | Yes | 0 | 0
Counts | 2020-08-01 00:00:00 |  | 2020-08-02 00:00:00 |  | 2020-08-03 00:00:00
 | Area 1 | Area 2 | Area 1 | Area 2 | Area 1 | Area 2
Space use
Respite
Comments
Cell O3 - Answer I want is 2. Only clients 1 & 9 have received contact & contain Space use AND Area 1.
Cell O4 - Answer I want is 1. Only client 8 has received contact & contains Respite AND Area 1.
Cell P3 - Answer I want is 1. Only client 2 has received catanct & contains Space use AND Area 2.
Cell P4 - Answer I want is 2. Only clients 3 & 7 have received contact & contain respite AND Area 2.
Spreadsheet: edca3cf3-d61d-42e4-95a8-ac2ffa6fb6b4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
263458 | 56625 | Zoltán | Balogh | HUN |  | 00:12:08 |  | 00:35:11 |  | 00:22:10 | 1 | 1:09:29
263458 | 16966 | [NAME] | [NAME] | HUN |  | 00:12:10 |  | 00:35:35 |  | 00:22:21 | 2 | 1:10:06
Spreadsheet: 80448d1280671418-automatic-updating-one-way-11
Sheet: Sheet1

0
1
1
2 | 1
2
3
3
3
3
4 | 2
5
5
6 | 6
7
8 | 3
9
10 | 7
11 | 4
12 | 5
13
14
15
16
Spreadsheet: 59785d1260339062-how-to-use-pivottable-to-count-records-in-various-categories-pivottable-to-count-records-in-various-categories
Sheet: Sheet1

 | Name | SrtuffSize
 | Name 1 | 3033 |  |  |  | Name | (All)
 | Name 3 | 3637
 | Name 5 | 167 |  |  |  | Row Labels | Sales
 | Name 2 | 4575 |  |  |  | 1-1000 | 19
 | Name 1 | 3864 |  |  |  | 1001-2000 | 20
 | Name 3 | 3090 |  |  |  | 2001-3000 | 17
 | Name 5 | 3126 |  |  |  | 3001-4000 | 28
 | Name 2 | 3435 |  |  |  | 4001-5000 | 17
 | Name 1 | 1897 |  |  |  | Grand Total | 101
 | Name 3 | 4328
 | Name 5 | 4273
 | Name 2 | 3910
 | Name 1 | 3171
 | Name 3 | 1993
 | Name 5 | 355
 | Name 2 | 3907
 | Name 1 | 307
 | Name 3 | 2235
 | Name 5 | 2958
 | Name 2 | 4008
 | Name 1 | 4835
 | Name 3 | 2145
 | Name 5 | 58
 | Name 2 | 2619
 | Name 1 | 1300
 | Name 3 | 3190
 | Name 5 | 3088
 | Name 2 | 495
 | Name 1 | 1178
 | Name 3 | 2322
 | Name 5 | 2087
 | Name 2 | 4468
 | Name 1 | 831
 | Name 3 | 4539
 | Name 5 | 112
 | Name 2 | 3210
 | Name 1 | 4429
 | Name 3 | 2823
 | Name 5 | 649
 | Name 2 | 4322
 | Name 1 | 1907
 | Name 3 | 1975
 | Name 5 | 1690
 | Name 2 | 972
 | Name 1 | 2864
 | Name 3 | 4785
 | Name 5 | 4798
 | Name 2 | 4870
 | Name 1 | 357
 | Name 3 | 3764
 | Name 5 | 3830
 | Name 2 | 3439
 | Name 1 | 3642
 | Name 3 | 795
 | Name 5 | 2961
 | Name 2 | 721
 | Name 1 | 3623
 | Name 3 | 299
 | Name 5 | 3959
 | Name 2 | 1771
 | Name 1 | 2674
 | Name 3 | 807
 | Name 5 | 1005
 | Name 2 | 4106
 | Name 1 | 3639
 | Name 3 | 2424
 | Name 5 | 2558
 | Name 2 | 1054
 | Name 1 | 1939
 | Name 3 | 417
 | Name 5 | 2990
 | Name 2 | 3256
 | Name 1 | 1954
 | Name 3 | 4971
 | Name 5 | 1181
 | Name 2 | 4691
 | Name 1 | 337
 | Name 3 | 1603
 | Name 5 | 2009
 | Name 2 | 3772
 | Name 1 | 43
 | Name 3 | 3224
 | Name 5 | 1305
 | Name 2 | 1811
 | Name 1 | 1851
 | Name 3 | 1297
 | Name 5 | 1923
 | Name 2 | 3476
 | Name 1 | 207
 | Name 3 | 1755
 | Name 5 | 3916
 | Name 2 | 4249
 | Name 1 | 2119
 | Name 3 | 2554
 | Name 5 | 2387
 | Name 2 | 3132
 | Name 1 | 4489
 | Name 3 | 3480
 | Name 5 | 3209
 | Name 2 | 3771
 | Name 1 | 637