tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 23

 |  | 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 transaction volumes, week ending August 16, by product type, participant type, and cleared status (in number of transactions), all tenors, currencies, and deliveries. 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: 779090d1651583817-sum-datas-by-date-across-different-sheets-sample
Sheet: May

Date | Sales
2022-05-01 00:00:00 | 1
2022-05-02 00:00:00 | 1
2022-05-03 00:00:00 | 1
2022-05-04 00:00:00 | 1
2022-05-05 00:00:00 | 1
2022-05-06 00:00:00 | 1
2022-05-07 00:00:00 | 1
2022-05-08 00:00:00 | 1
2022-05-09 00:00:00 | 1
2022-05-10 00:00:00 | 1
2022-05-11 00:00:00 | 1
2022-05-12 00:00:00 | 1
2022-05-13 00:00:00 | 1
2022-05-14 00:00:00 | 1
2022-05-15 00:00:00 | 1
2022-05-16 00:00:00 | 1
2022-05-17 00:00:00 | 1
2022-05-18 00:00:00 | 1
2022-05-19 00:00:00 | 1
2022-05-20 00:00:00 | 1
2022-05-21 00:00:00 | 1
2022-05-22 00:00:00 | 1
2022-05-23 00:00:00 | 1
2022-05-24 00:00:00 | 1
2022-05-25 00:00:00 | 1
2022-05-26 00:00:00 | 1
2022-05-27 00:00:00 | 1
2022-05-28 00:00:00 | 1
2022-05-29 00:00:00 | 1
2022-05-30 00:00:00 | 1
2022-05-31 00:00:00 | 1
Spreadsheet: 0bc154fd-c883-4d59-9f1f-5a034f2b6121
Sheet: Sheet1

 |  | Men's E/Rec NIT
 |  | C&J Stoneworks
 |  |  | 10:10AM AF North (2
Lightning |  | Ambition MMA
 |  |  |  |  | 3:00PM AF North (7
 | 9:00AM AF North (1
Enfield/Breakaway |  |  | 11:30AM AF North (3
 |  | Mars/TK Masonry/CA Gear |  |  |  |  |  | 7:40PM [NAME] (10
L-1
 | 12:40PM AF North (4 |  |  |  |  | L-7
L-2 |  |  |  |  |  |  | 6:30 PM AF North (9 |  |  | 8:50PM AF North(11
 |  |  | 1:50PM AF North (5 |  |  |  |  |  |  | IF Needed
 |  | [NAME]
 |  |  |  |  | 5:20PM AF North (8
 |  | L-4
 |  |  | 4:10PM AF North (6
 |  | [NAME]
Spreadsheet: eba7f322-1ceb-4b33-a9f8-3e392b56300a
Sheet: Sheet1

Asthma Prevalence Rates among Maine Children by Selected Demographics, Maine, 2006-2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
 |  | [NAME] |  |  |  |  |  |  |  |  | Current Asthma
 |  | Total Respondents |  | n |  | weighted n |  | % |  | 95% CI | Total Respondents |  | n |  | weighted n |  | % |  | 95% CI
Total |  | 6283 |  | 910 |  | 36824 |  | 13.5 |  | 13% - 14% | 6256 |  | 608 |  | 24342.4 |  | 8.9 |  | 8.1% - 9.8%
Gender
 | Male | 3212 |  | 554 |  | 22249.4 |  | 16.1 |  | 15% - 18% | 3193 |  | 350 |  | 13850.8 |  | 10.1 |  | 8.9% - 11.3%
 | Female | 3045 |  | 353 |  | 14447.4 |  | 10.8 |  | 10% - 12% | 3037 |  | 255 |  | 10364.4 |  | 7.8 |  | 6.7% - 8.8%
Race/Ethnicity
 | Non-Hispanic White | 5849 |  | 843 |  | 33556.8 |  | 13.2 |  | 12% - 14% | 5822 |  | 557 |  | 21745 |  | 8.6 |  | 7.8% - 9.4%
 | Other Race or Hispanic | 434 |  | 67 |  | 3267.4 |  | 16.5 |  | 12% - 21% | 434 |  | 51 |  | 2597.4 |  | 13.1 |  | 8.9% - 17.4%
Age
 | 0-11 | 3497 |  | 402 |  | 18127 |  | 11.1 |  | 9.9% - 12.3% | 3480 |  | 277 |  | 12614 |  | 7.8 |  | 6.7% - 8.8%
 | 12+ | 2488 |  | 473 |  | 17355.6 |  | 17.6 |  | 16% - 19% | 2478 |  | 301 |  | 10672 |  | 10.9 |  | 9.5% - 12.2%
Household Income
 | Less than $25,000 | 1058 |  | 203 |  | 7990.4 |  | 17.2 |  | 14% - 20% | 1054 |  | 140 |  | 5466.8 |  | 11.8 |  | 9.4% - 14.1%
 | $25,000-49,999 | 1659 |  | 249 |  | 9966.2 |  | 14.3 |  | 12% - 16% | 1651 |  | 153 |  | 6248.4 |  | 9 |  | 7.4% - 10.5%
 | 50,000+ | 3144 |  | 399 |  | 16548.6 |  | 11.9 |  | 11% - 13% | 3130 |  | 268 |  | 10774.4 |  | 7.8 |  | 6.7% - 8.8%
Data Source:  Maine Behavioral Risk Factor Surveillance System.
All percentges are weighted to be more representative of the general child population of Maine and to adjust for non-response.
Use caution in interpreting percentages with a numerator less than 20.
Total respondents = unweighted denominator
n = unweighted numerator;  95% CI = 95% Confidence Interval.
weighted n = weighted numerator (for pooled data, equals final child weight divided by number of years)
Spreadsheet: 94868d1294636160-extracting-info-to-another-worksheet-fault-issues-
Sheet: LYNX

 | QUOTE NUMBER | DATE REPORTED | TIME REPORTED | FAULT TYPE | FAULT DETAILS | PRIORITY | STATUS | DATE RESOLVED | TIME RESOLVED | RELEVANT FILES | CONTACT
 | 1 | 2010-10-12 00:00:00 | N/A | Out of sequence | Data out of sequence | MEDIUM | Closed | 2011-01-09 00:00:00 | 2011-01-09 21:08:37 |  |  |  |  |  |  |  |  |  |  |  |  | ..\EM80
 |  | 2010-10-13 00:00:00 | N/A | System boot out |  | HIGH | Closed | 2011-01-09 00:00:00 | 21:08:18 |  |  |  |  |  |  |  |  |  |  |  |  | ..\FMECA
 |  | 2010-10-14 00:00:00 | N/A | Hardware |  | HIGH | Closed | 2011-01-09 00:00:00 | 2011-01-09 21:08:37 |  |  |  |  |  |  |  |  |  |  |  |  | ..\VI system developments
 |  | 2010-10-18 00:00:00 | N/A | Irretrievable images |  | MEDIUM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ..\Video Imaging System
 |  | 2010-10-18 00:00:00 | N/A | Other |  | HIGH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ..\Work Files
 |  | 2010-10-20 00:00:00 | N/A | Data drop offs |  | HIGH
 |  | 2010-10-27 00:00:00 | N/A | Data drop offs |  | HIGH
 |  | 2010-10-28 00:00:00 | N/A | Data drop offs |  | MEDIUM
 |  | 2010-11-06 00:00:00 | 13:31 PM | Irretrievable images |  | MEDIUM
 |  | 2010-11-12 00:00:00 | 07:14:00 | Out of sequence |  | MEDIUM
 |  | 2010-11-12 00:00:00 | 08:17:00 | Irretrievable images |  | HIGH
 |  | 2010-11-13 00:00:00 | 10:57:00 | Incorrect Flagging |  | HIGH
 |  | 2010-11-20 00:00:00 | 09:10:00 | Out of sequence |  | MEDIUM
 |  | 2010-11-21 00:00:00 | 06:50:00 | Out of sequence |  | HIGH
 |  | 2010-11-27 00:00:00 | 06:16:00 | Data drop offs |  | HIGH
 |  | 2010-12-22 00:00:00 | 14:07:00 | Incorrect Flagging |  | HIGH
 |  | 2010-12-28 00:00:00 | 17:25:00 | Hardware |  | HIGH
 |  | 2010-12-30 00:00:00 | 14:46:00 | Hardware |  | HIGH
Spreadsheet: 831960d1686032278-drop-down-data-validation-with-non-unique-recurring-lookup-values-in-the-named-range-car_list
Sheet: Range_Data

Country | CZE | DEU | FRA | GBR | ITA | JPN | KOR | SWE | USA
CZE | Skoda | Audi | Bugatti | [NAME] | Alfa-Romea | Acura | Hyundai | Volvo | Dodge-Chrysler
DEU |  | BMW | Citroen | Bentley | Ferrari | Honda | Kia |  | Ford
FRA |  | Mercedes-Benz | Peugeot | Jaguar | FIAT | Infiniti |  |  | GM
GBR |  | Porsche | Renault | Land Rover | Lamborghini | Lexus |  |  | Tesla
ITA |  | Volkswagen |  | Lotus | [NAME] | Nissan
JPN |  |  |  | [NAME] | Maserati | Toyota
KOR |  |  |  | Mini
SWE |  |  |  | RollsRoyce
USA
Spreadsheet: 780197d1652344981-get-a-list-of-people-who-are-less-than-150-or-taller-than-185-filter-outside-range-aligw
Sheet: Page1

[NAME] | 200 |  | Answer: |  |  | Or: |  | 149
Yulia | 149 |  |  | [NAME] |  |  | [NAME] | 187
Leo | 180 |  |  | Mark |  |  | Mark | 148
[NAME] | 187
Mark | 148
 |  |  |  | =
Spreadsheet: matt_motley__26377__Pwr west P&L
Sheet: Power West P&L 

ENRON POWER TRADING & TRANSMISSION
DAILY PROFIT LOSS STATEMENT - WEST |  |  |  |  |  |  |  |  |  |  |  | YTD  Rolling Check | MTD  Rolling Check
DATE: | 1999-02-11 00:00:00 |  |  |  |  |  |  |  |  |  |  | Figures - If not | Figures - If not
 |  |  |  |  |  |  |  |  |  |  |  | zero, you are | zero, you are
 |  |  |  |  |  |  |  |  |  |  |  | not finished! | not finished!
 |  |  |  |  |  |  |  |  |  |  | CHECK FIGURE
 |  | DESK | 1 DAY | 5 DAY | MTD | 1ST QTD | 2ND QTD | 3RD QTD | 4TH QTD | YTD |  | YTD | Expected Liquidations | YTD check | MTD check | 4th Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter |  | [NAME]
 |  | W-MGMT [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-WM-LT
 |  | Northwest  [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-NW-LT
 |  | [NAME]   [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-CA-LT
 |  | Southwest  [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-SW-LT
 |  | W-Trans  M.Swerzbin, [NAME]
 |  | W- Options  [NAME]
 |  | Spread Option
 |  | Service
 |  | TOTAL  LONG TERM
 |  | California  [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-CA-ST
 |  | Northwest  Sean Crandall, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-NW-ST
 |  | Southwest  [NAME], [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-SW-ST
 |  | Hourly  [NAME]
 |  | Management
 |  | W-BOM  [NAME]
 |  | W-Services G. Wolfe, [NAME]
 |  | W-RENEWABL Elliot Mainzer
 |  | W-CALIFORNIA SERVICES ([NAME] Richter)
 |  | TOTAL  SHORT TERM
 |  | Middle Market Origination |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26994388 | 10647640
 |  | TOTAL WEST TRADING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | West Origination
 |  | TOTAL WEST
 |  | [NAME] ([NAME])
 |  | [NAME] (Cooper Richey)
 |  | St transmission (Real Time Traders)
 |  | ALBERTA ORIGINATION ([NAME])
 |  | [NAME] ([NAME])
 |  | TOTAL ALBERTA POWER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAND-DPR-VAR
 |  | TOTAL WEST AND ALBERTA
 |  | *Be sure to update VaR date in $I$7 in the morning
 |  | -27151
 |  | 780343.4841893384
 |  | -558558.1094205244
 |  | -74357
 |  | 214990
 |  | 360860
 |  | -274755
 |  | -214
 |  | -76
 |  | 851224
 |  | 97
 |  | -127
 |  | 57
 |  | 0
Spreadsheet: 100520d1298889275-conditional-median-function-medianif-test
Sheet: Table

 | 0 | 300 | 600 | 900 | 1200 | 1500 | 1800 | 2100 | 2400 | 2700
 | 0-300 | 300-600 | 600-900 | 900-1200 | 1200-1500 | 1500-1800 | 1800-2100 | 2100-2400 | 2400-2700 | 2700+
2006-01-01 00:00:00
2006-02-01 00:00:00
2006-03-01 00:00:00
2006-04-01 00:00:00
2006-05-01 00:00:00
2006-06-01 00:00:00
2006-07-01 00:00:00
2006-08-01 00:00:00
2006-09-01 00:00:00
2006-10-01 00:00:00
2006-11-01 00:00:00
2006-12-01 00:00:00
2007-01-01 00:00:00
2007-02-01 00:00:00
2007-03-01 00:00:00
2007-04-01 00:00:00
2007-05-01 00:00:00
2007-06-01 00:00:00
2007-07-01 00:00:00
2007-08-01 00:00:00
2007-09-01 00:00:00
2007-10-01 00:00:00
2007-11-01 00:00:00
2007-12-01 00:00:00
2008-01-01 00:00:00
2008-02-01 00:00:00
2008-03-01 00:00:00
2008-04-01 00:00:00
2008-05-01 00:00:00
2008-06-01 00:00:00
2008-07-01 00:00:00
2008-08-01 00:00:00
2008-09-01 00:00:00
2008-10-01 00:00:00
2008-11-01 00:00:00
2008-12-01 00:00:00
2009-01-01 00:00:00
2009-02-01 00:00:00
2009-03-01 00:00:00
2009-04-01 00:00:00
2009-05-01 00:00:00
2009-06-01 00:00:00
2009-07-01 00:00:00
2009-08-01 00:00:00
2009-09-01 00:00:00
Spreadsheet: 818030d1676558796-identify-overlaps-in-employees-and-days-book1-44-ans
Sheet: Job Roster

 | Raw Data (Input) |  |  |  |  |  | Desired Results
 | Monday | Tuesday | Wednesday | Thursday | Friday |  |  | Monday | Tuesday | Wednesday | Thursday | Friday |  |  | Employee | Job
Week 1 | Tax | Stat | Tax |  |  |  | Week 1 | Tax | Stat | Tax |  |  |  |  | Employee 1 | Tax
 |  | IT | Legal |  |  |  |  |  | IT | Legal |  |  |  |  | Employee 2 | Tax
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 3 | Tax
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 4 | Tax
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 5 | Tax
Week 2 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  |  | Employee 6 | Tax
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 7 | Tax
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 8 | Tax
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 9 | Tax
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 10 | Tax
Week 3 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  |  | Employee 11 | Tax
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 12 | Tax
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 1 | Legal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 2 | Legal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 3 | Legal
Week 4 |  |  |  |  |  |  | Week 4 |  |  |  |  |  |  |  | Employee 4 | Legal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 5 | Legal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 6 | Legal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 7 | Legal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 8 | Legal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 9 | Legal
 | =(COUNTIF(B$3:B$7,"Tax")+COUNTIF(B$3:B$7,"Legal"))>1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 10 | Legal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 11 | Legal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 12 | Legal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 1 | IT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 2 | IT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 3 | IT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 4 | Cyber
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 5 | Cyber
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 6 | Cyber
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 7 | Tele
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 8 | Tele
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 9 | Tele
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 10 | Stat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 11 | Stat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee 12 | Stat
Spreadsheet: 805289d1668613695-excel-compare-data-and-rank-in-order-book1
Sheet: Consolidated

 | Value | Manager |  |  |  |  |  |  |  |  |  | Manager 1 |  |  |  |  |  |  |  |  |  | Manager 1
No of cases handled (highest) |  |  |  |  |  |  |  |  |  |  |  | Manager 2 |  |  |  |  |  |  |  |  |  | Manager 2
No of case reviewed (highest) |  |  |  |  |  |  |  |  |  |  |  | Manager 3 |  |  |  |  |  |  |  |  |  | Manager 3
Late cases (lowest)
HIPAA Errors (lowest)
Spreadsheet: louise_kitchen__23828__Agmt Update - 4-20-01a
Sheet: Sheet1 (2)

[NAME]
 |  |  | Grant
 |  |  | Submitted
 |  |  | or will be
 | [NAME] |  | Submitted
Employee | Type | Signed | For ... | Notes
ARORA, HARPREET S | Executable | Y | May Grant | Submit for a May grant.
BAUGHMAN, EDWARD D | Executable | Y | April Grant | Done. Submitted for an April grant.
BELDEN, TIMOTHY N | Executable |  |  | Executable out. As of 4/20/01, have not received word of agreement being signed.
BENSON, [NAME] | Executable | Y | April Grant | Done. Submitted for an April grant.
BILLS, LISA A | [NAME] |  |  | Draft copy out.
CALGER, [NAME] | Executable | Y | April Grant | Done. Submitted for an April grant.
CLYNES, TERRI B | Executable | Y | April Grant | Done. Submitted for an April grant.
DAVIS JR, MARK D | Executable | Y | May Grant | Submit for a May grant.
DONOVAN, TERRY W | Executable | Y | May Grant | Submit for a May grant.
DORLAND, CHRISTOPHER | Executable | Y | May Grant | Submit for a May grant.
DURAN, WILLIAM D | Executable | Y | April Grant | Done. Submitted for an April grant.
HEIZENRADER, TIMOTHY A | [NAME] |  |  | Draft copy out.
HERNDON, ROGERS | [NAME] |  |  | Draft copy out.
IRVIN, STEVEN P | [NAME] |  |  | Draft copy out.
KERRIGAN, BRIAN A | [NAME] |  |  | Draft copy out.
MILLER, LLOYD D | Executable | Y | May Grant | Submit for a May grant.
MOTLEY, MATTHEW H | [NAME] |  |  | Draft copy out.
PAGAN, J O | [NAME] |  |  | Draft copy out.
PRESTO, KEVIN M | Executable |  |  | No current agreement executed.  Previous agreement retrieved due to not being signed by deadline for an April Grant.
PROFFITT, TIMOTHY | [NAME] |  |  | Draft copy out.
STURM, FLETCHER J | Executable | Y | April Grant | Done. Submitted for an April grant.
SWERZBIN, [NAME] | Executable |  |  | Executable out. As of 4/20/01, have not received word of agreement being signed.
WILL, [NAME] | Executable | Y | May Grant | Submit for a May grant.
WOLFE, GREGORY E | [NAME] |  |  | Draft copy out.
YZAGUIRRE, MARIO M | [NAME] |  |  | Draft copy out.
ZISMAN, STUART | Executable | Y | May Grant | Submit for a May grant.
Spreadsheet: 844648d1696400324-need-a-formulae-mentioned-in-enclosed-sheet-sample
Sheet: Sheet7 (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
2023-09-23 00:00:00
DAY-1 | P | P | P | P | P | R | P | P | P | R | P | P | P | SD | P | r | R | P | R | P | P | P | P | R | P | P | P | P | P | P | R | P
DAY-2 | P | P | SD | P | P | R | P | P | P | SD | P | SD | P | SD | P | P | R | P | P | P | P | P | P | R | P | P | P | P | P | P | R | P
 |  |  | Number of Presents
 |  |  | September | October | 01 TO 07
 |  | Day-1 |  |  |  |  | NEED TO COUNT in F13
 |  | Day-2 |  |  |  |  | IF | row one is equal to october
 |  |  |  |  |  |  | IF | B3:AG3 is >= 1 and <=7
 |  |  |  |  |  |  | IF | B4:AG4 is = P
Spreadsheet: 156240d1337239562-manage-data-using-macro-send-out
Sheet: input 1

Zone | Code | Sold By | name | Option
E | 11 | dealer | a (dealer) | 2+2
E | 11 | workshop | a(workshop) | 2+1
S | 13 | dealer | b (dealer) | 2+1
S | 12 | dealer | c(dealer) | 2+2
S | 13 | dealer | b (dealer) | 2+2
E | 11 | workshop | a(workshop) | 2+2
E | 11 | dealer | a( dealer) | 2+2
N | 34 | dealer | d( dealer) | 2+2
S | 12 | workshop | c(workshop) | 3+1
S | 13 | dealer | b (dealer) | 2+2
W | 45 | workshop | e( dealer) | 2+2
W | 32 | workshop | f(workshop) | 2+2
W |  |  |  | 2+2
Spreadsheet: 846990d1698107283-if-cells-duplicate-in-a-column-return-the-first-value-example-1-
Sheet: Sheet1

Column A | value | desired output
Hello | 45 | 45
Hello | 87 | 45
Hello | 94 | 45
Goodbye | 15657 | 15657
Goodbye | 5498 | 15657
Goodbye | 165 | 15657
Goodbye | 3279 | 15657
[NAME] | 198 | 198
[NAME] | 53897 | 198
[NAME] | 165 | 165
[NAME] | 1568 | 165
[NAME] | 67814 | 165
[NAME] | 152 | 165
[NAME] | 12 | 165
abc | 576 | 576
def | 156 | 156
ghi | 7 | 7
Spreadsheet: benjamin_rogers__1210__Fixed Costs (O&M)
Sheet: Debt Calc.

Rate (Libor + 2.50) | 0.085
Output per LM 6000 (MW) | 46 | Debt Service
Beg. Balance (000) | 20000
Semi-Annual Payments | 20
Term (yrs.) | 10
Year: | [NAME] | Principal | Interest | Debt Service | Ending Balance
2000-10-01 00:00:00
2001-04-01 00:00:00
2001-10-01 00:00:00
2002-04-01 00:00:00
2002-10-01 00:00:00
2003-04-01 00:00:00
2003-10-01 00:00:00
2004-04-01 00:00:00
2004-10-01 00:00:00
2005-04-01 00:00:00
2005-10-01 00:00:00
2006-04-01 00:00:00
2006-10-01 00:00:00
2007-04-01 00:00:00
2007-10-01 00:00:00
2008-04-01 00:00:00
2008-10-01 00:00:00
2009-04-01 00:00:00
2009-10-01 00:00:00
2010-04-01 00:00:00
Spreadsheet: 127131d1320173449-goup-sorting-memfile
Sheet: Sheet1

"Before" |  |  |  |  | Desired "After"
Mem First Name | [NAME] | Mem# | MemSub# |  | Mem First Name | [NAME] | Mem# | MemSub#
EARL | KLEESE | 1111 | 01 |  | WILLIAM | [NAME] | 4444 | 01
BONNIE | KLEESE | 1111 | 02 |  | BARBARA | [NAME] | 4444 | 02
RONI | STIGER | 2222 | 01 |  | SCOTT | CUNNINGHAM | 3333 | 01
JAN | STIGER | 2222 | 02 |  | BONNIE | CUNNINGHAM | 3333 | 02
SCOTT | CUNNINGHAM | 3333 | 01 |  | RAYMOND | HUGGINS | 6666 | 01
BONNIE | CUNNINGHAM | 3333 | 02 |  | [NAME] | HUGGINS | 6666 | 02
WILLIAM | [NAME] | 4444 | 01 |  | KIRK | [NAME] | 7777 | 01
BARBARA | [NAME] | 4444 | 02 |  | EVELYN | KROTINE | 7777 | 02
[NAME] | NAUGLE | 5555 | 01 |  | EARL | KLEESE | 1111 | 01
CATHY | NAUGLE | 5555 | 02 |  | BONNIE | KLEESE | 1111 | 02
RAYMOND | HUGGINS | 6666 | 01 |  | [NAME] | NAUGLE | 5555 | 01
[NAME] | HUGGINS | 6666 | 02 |  | CATHY | NAUGLE | 5555 | 02
KIRK | [NAME] | 7777 | 01 |  | RONI | STIGER | 2222 | 01
EVELYN | KROTINE | 7777 | 02 |  | JAN | STIGER | 2222 | 02
Spreadsheet: 585586d1533836841-need-and-or-added-to-an-index-small-if-statement-excel-training-index-small-if-need-to-add-or
Sheet: Raw Data

This is what the main page looks like:
 |  |  |  |  | PREFERRED WHOLESALER IN ORDER
Business Partner | Address | City | State | Zip | WS Pref 1 | WS Pref 2
Titos Inc. | 123 Main Street | Indy | IN | 11111 | ABC | DEF
Absolute Inc. | 456 Maple Drive | Chicago | IL | 22222 | ABC | DEF |  | <--- Coworker types in the various wholesalers our partner buys from in the blue area.
Smirnoff Inc. | 789 State Street | Seattle | WA | 33333 | ABC | DEF
Titos2 Inc. | 123 Main Street | Indy | IN | 11111 | [NAME]
Titos3 Inc. | 123 Main Street | Indy | IN | 11111 |  | ABC3
Spreadsheet: 91836d1291511852-count-with-two-conditions-number-of-canceled-bills-per-client
Sheet: # of canceled bills

# client | Status
 | canceled/pending
1 | c
2 | c
3 | p
1 | p
4 | c
3 | c
1 | c
1 | c
2 | p
2 | c
3 | c
client# | # of canceled bills
1 | 3 | I need in B18:B21 a formula showing the number of canceled bills per client
2 | 2
3 | 2
4 | 1
Spreadsheet: 166207d1341500006-using-index-match-equal-or-less-than-with-multiple-criteria-padal_excel_lookup_test
Sheet: Sheet1

Main Category Name | Sub Category ID | [NAME]
ADG | 1 |  |  | Select Main Category: | BEF
ADG | 5 |  |  | Enter Sub Category ID: | 5
ADG | 9
ADG | 11 |  |  | [NAME]):
ADG | 15 |  |  | [NAME]):
BEF | 1
BEF | 5
BEF | 9
BEF | 11
BEF | 15
CPZ | 1
CPZ | 3
CPZ | 5
CPZ | 12
CPZ | 20
Spreadsheet: 884728d1733983740-find-data-within-a-dynamic-range-calendar-feed
Sheet: calendar

 | Project ID | Project Name | 2024-12-16 00:00:00
 | P0206 | Project MES
 | P0404 | Project AAA
 | P0509 | Project HRD
 | P0562 | Project AAB
 | P0573 | Project RSA |  |  | R4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R6
 | P0578 | Project CGA
 | P0702 | Project MRG
 |  | Result
Spreadsheet: 482447d1475067631-copy-chart-from-one-area-to-another-without-fixed-cells-book29
Sheet: Data

Description | MIN Target | [NAME] | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00
Customer A |  | 110000 | 9000 | 11000 | 7500 | 8300 | 10000 | 6000 | 9000 | 8000 | 9000 | 9000 | 15000 | 9000
Customer B | 85000 | 100000 | 9900 | 12100 | 8250 | 9130 | 11000 | 6600.000000000001 | 9900 | 8800 | 9900 | 9900 | 16500 | 9900
Customer C | 85000 | 105000 | 10890 | 13310 | 9075 | 10043 | 12100 | 7260.000000000002 | 10890 | 9680 | 10890 | 10890 | 18150 | 10890
Customer D |  | 70000 | 11979 | 14641.00000000001 | 9982.5 | 11047.3 | 13310 | 7986.000000000003 | 11979 | 10648 | 11979 | 11979 | 19965 | 11979