tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 140680d1328861077-extract-the-last-word-from-the-cell-excl_prob2
Sheet: Sheet1

 | A.K.AGENCIE                 FARRUKHABAD | FARRUKHABAD
 | ADHUNIK MEDICOSE              AZAMGARH | AZAMGARH
 | AGARWAL MEDICAL STORE         MUSAFIRKHANA | MUSAFIRKHANA
 | ANGLO AYURVEDIC MED.HALL AGS. [NAME] | VARANASI
 | ANJANI MEDICAL AGENCY         DEORIA | DEORIA
 | ARPITA PHARMACEUTICALS        ALLAHABAD | ALLAHABAD
 | ASHOK MEDICAL HALL            SULTANPUR | SULTANPUR
 | ASHUTOSH MEDICO               BALLIA | BALLIA
 | AVADH MEDICAL AGENCY                   AZAMGARH | AZAMGARH
 | BANKA MEDICAL STORE                        PADRAUNA | PADRAUNA
 | BHARAT TRADERS                VARANASI | VARANASI
 | BHARGAVA MEDICAL AGENCIES     SHAMLI | SHAMLI
 | BHATIA MEDICAL AGENCIES       KANPUR | KANPUR
 | C. LAL & COMPANY              AGRA | AGRA
 | CHANDRA AGENCIES              LAKHIMPUR | LAKHIMPUR
 | DAWAA MAHAL HALL              GONDA | GONDA
 | DAYA MEDICAL AGENCY           MUZAFFARNAGAR | MUZAFFARNAGAR
 | DRUG EMPORIUM                 JAUNPUR | JAUNPUR
 | FRIENDS MEDICOSE              SAHARANPUR | SAHARANPUR
 | GARG HELTH PRODUCT'S          SITAPUR | SITAPUR
 | GEETA MEDICAL AGENCIES | AGENCIES
 | GUPTA MEDICAL AGENCIES | AGENCIES
 | HAPPY AGENCIES | AGENCIES
 | HARI OM MEDICAL AGENCIES      GORAKHPUR | GORAKHPUR
 | HIMGIRI PHARMA | PHARMA
 | JAGDISH MEDICAL HALL | HALL
 | JAI DURGA MED.AGENCY | MED.AGENCY
 | JITENDRA MEDICAL STORE | STORE
 | KEDIA PHARMA | PHARMA
 | LAKHIMPUR MEDICAL STORE | STORE
 | LALITA ENTERPRISES | ENTERPRISES
 | LUTHRA CHEMISTS | CHEMISTS
 | M.ISRAIL MEDICAL STORE | STORE
 | M.K.DISTRIBUTORS | M.K.DISTRIBUTORS
 | MEDICARE AGENCIES | AGENCIES
 | N.P.ENTERPRISES | N.P.ENTERPRISES
 | NEHA AGENCY                   ALLAHABAD | ALLAHABAD
 | NEW AVADH MEDICAL HALL        GONDA | GONDA
 | NIDA MEDICAL AGENCY | AGENCY
 | POOJA MEDICAL AGENCY | AGENCY
 | RAHUL PHARMA | PHARMA
 | RAJA REMEDIES | REMEDIES
 | RUCHI ENTERPRISES             VARANASI | VARANASI
 | SHARDA MEDICAL STORES | STORES
 | SHIMLA MEDICAL HALL | HALL
 | SHREE NATH CHEMIST            LUCKNOW | LUCKNOW
 | SHREE PHARMA AGENCY | AGENCY
 | SHREE RAM MEDICAL AGENCIES | AGENCIES
 | SHRI LAL JI TRADERS | TRADERS
 | STANDARD PHARMACEUTICALS LTD. | LTD.
 | STAR MEDICAL STORE | STORE
 | SURAJ PHARMACEUTICALS (AGENCY) | (AGENCY)
 | SUSHIL MEDICAL STORE | STORE
 | THAKUR BROTHERS | BROTHERS
 | VANDANA PHARMA | PHARMA
 | VASU MEDICOSE                 SAHARANPUR | SAHARANPUR
Spreadsheet: 145806d1331749478-working-out-hours-worked-hours-worked-and-break-time
Sheet: Sheet1

Start Time | End Time | Break Time | Total Hours Worked
10:00:00 | 16:00:00 | 00:45:00 | 05:15:00
11:00:00 | 17:00:00 | 01:45:00 | 04:15:00
12:00:00 | 18:00:00 | 02:45:00 | 03:15:00
13:00:00 | 19:00:00 | 03:45:00 | 02:15:00
 |  |  | 15:00:00 | Total for week
Spreadsheet: monika_causholli__28147__Foex Prices
Sheet: FOEX

source: Foex.fi
Prepared by: EIM Fundamentals
 |  | Date | NBSK | % Change | BHKP | % Change |  | Month | NBSK avg | BHKP avg
 |  | 2001-04-17 00:00:00 | 586.53 |  | 543.42 |  |  | April
 |  | 2001-04-24 00:00:00 | 580.42 |  | 536.53 |  |  | May
 |  | 2001-05-02 00:00:00 | 577.98 |  | 524.57 |  |  | June
 |  | 2001-05-08 00:00:00 | 572.04 |  | 512.05 |  |  | July
 |  | 2001-05-15 00:00:00 | 560.19 |  | 497.16
 |  | 2001-05-22 00:00:00 | 545.22 |  | 490.16
 |  | 2001-05-29 00:00:00 | 540.19 |  | 477.39
 |  | 2001-06-05 00:00:00 | 536.63 |  | 465.59
 |  | 2001-06-12 00:00:00 | 519.9 |  | 456.26
 |  | 2001-06-19 00:00:00 | 515.5 |  | 450.7
 |  | 2001-06-26 00:00:00 | 511.5 |  | 440.86
 |  | 2001-07-03 00:00:00 | 499.55 |  | 422.03
 |  | 2001-07-10 00:00:00 | 490.85 |  | 411.92
 |  | 2001-07-17 00:00:00 | 478.91 |  | 408.25
Spreadsheet: 44356d1242943774-ifsum-problem-master
Sheet: Expenses Daily Summary

Monday |  |  |  | Tuesday |  |  |  | Wednesday
Description | Amount | Paid By |  | Description | Amount | Paid By |  | Description | Amount | Paid By
Total | 0 |  |  | Total | 0 |  |  | Total | 0
Thursday |  |  |  | Friday |  |  |  | Saturday
Description | Amount | Paid By |  | Description | Amount | Paid By |  | Description | Amount | Paid By
Total | 0 |  |  | Total | 0 |  |  | Total | 0
Sunday
Description | Amount | Paid By
Total | 0
Spreadsheet: 733232d1621447756-circular-reference-help-sample-calc
Sheet: Sheet1

Contract 1 |  | Contract 2 |  | Totals
Estimated total Cost | 2491483 | Estimated total Cost | 137483
PM Cost Paid thru 4/30/21 | -27422.72 | PM Cost Paid thru 4/30/21
Fund 1 | -70000 | Fund 1
total cost |  | total cost
Fund 2 | -896241.5 | Fund 2 | -33054
Fund 3 | -120000 | Fund 3 | 0
Fund 4 |  | Fund 4 | 0 |  |  |  | Fund 4 FTE
Fund 5 |  | Fund 5 |  |  |  |  | Fund 5 NTE
 |  |  |  |  | unfunded
Spreadsheet: 778163d1650898711-formulas-not-calculating-but-do-in-cell-above-broken-sample
Sheet: Sheet2

Req. ID | Task Priority | Task Priority (SD) | Task Logged Date | Attend Time | Complete Time | Target Attendance Date | Target Completion Date | Last Update | Last Update Timestamp
88241 | B - Priority, response time to be 24 hours |  |  |  |  |  |  | Test
88226 | C - Normal, work to be commenced within 7 days
 |  |  | If there is something in A then this will create a timestamp in D |  |  |  |  |  | If there is something in I then this will create a timestamp in J
 |  |  | If there is nothing in A then D will remain blank |  |  |  |  |  | If there is nothing in I then J will remain blank
Spreadsheet: 884011d1732885079-working-with-representations-of-time-durations-2024-25-track-timing-cut-down-
Sheet: Reference

Date | Week | Athletes | Prog | Calendar Notes |  |  | Date
2024-09-20 00:00:00 | 1 | 382 | A | Abnormal - skills week
2024-09-27 00:00:00 | 2 | 317 | B | Abnormal - skills week
2024-10-04 00:00:00 | 3 | 331 | A
2024-10-11 00:00:00 | 4 | 381 | B
2024-10-18 00:00:00 | 5 | 415 | A | Weather caused early end to the night.
2024-10-25 00:00:00 | 6 | 412 | B
2024-11-01 00:00:00 | 7 | 373 | A
2024-11-08 00:00:00 | 8 | 397 | B
2024-11-15 00:00:00 | 9 | 350 | A
2024-11-22 00:00:00 | 10 | 387 | B
2024-11-29 00:00:00 | 11 |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B |  | EVENT
TRANSPOSE(UNIQUE(FILTER(tbl_RaceRpts[Age], (tbl_RaceRpts[Event]='CT-WkA Races'!A$2)*(tbl_RaceRpts[Date]='CT-WkA Races'!A$4)*(tbl_RaceRpts[racenumber]='CT-WkA Races'!A5)))) |  |  |  |  |  |  |  |  |  |  |  |  |  | 400m | 200m |  | 200m
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 800m | 1500m |  | 300m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 700m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 800m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3000m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100m
Spreadsheet: 74990d1275514123-how-to-get-non-duplicates-with-fixed-data-temp
Sheet: Sheet1

Data I have to work with |  |  | [NAME] to get this
### more contacts |  |  | non duplicates
[NAME] | house phone | 3363956
 | mobile phone | 210132599
 | work phone | 9479665
[NAME] | main contact | 213659850
 | house phone | 39565996
 | mobile phone | 213659850 | -
 | work phone | 213659850 | -
### more contacts
How do I get non-duplicates knowing that contacts may have no numbers or an unlimited number of contact number entries (or 6 if needs a limit)?
Spreadsheet: benjamin_rogers__1110__Bidding Summary
Sheet: Peakers

Round I Bidding Summary and Round II Bidders
[NAME] |  |  |  | Lincon Energy Center |  |  |  | Wheatland |  |  |  | Peaker Total
Bidder | Bid | $/kw |  | Bidder | Bid | $/kw |  | Bidder | Bid | $/kw |  | Bidder | Bid | $/kw
Allegheny Energy | 330 |  |  | Allegheny Energy | 380 |  |  | Allegheny Energy | 284 |  |  | Allegheny Energy
Dynegy | 303 |  |  | Dynegy | 361 |  |  | Dynegy | 281 |  |  | Dynegy
Cinergy Corp | 302 |  |  | Duke Energy | 315 |  |  | Cinergy Corp | 276 |  |  | [NAME] | 923
Duke Energy | 290 |  |  | PECO Energy | 292 |  |  | Duke Energy | 235 |  |  | Duke Energy
LG&E Energy Corp | 252 |  |  | Southern Energy | 284 |  |  | Aquilla Energy | 224 |  |  | Cinergy Corp
Aquilla Energy | 240 |  |  | Calpine Corp | 270 |  |  | LG&E Energy Corp | 220 |  |  | NRG Energy
El Paso | 214 |  |  | Cinergy Corp | 237 |  |  | Southern Energy | 206
Calpine Corp | 214 |  |  | El Paso | 150 |  |  | DPL Inc | 205
AEP | 150 |  |  | NRG Energy |  |  |  | Calpine Corp | 192
NRG Energy |  |  |  | [NAME] |  |  |  | El Paso | 135
[NAME] |  |  |  |  |  |  |  | NRG Energy
 |  |  |  |  |  |  |  | [NAME]
8 Round II bidders |  |  |  | 9 bidders |  |  |  | 10 bidders
Spreadsheet: 762967d1641919791-help-with-sort-filter-formula-to-produce-bank-statement-zwl-and-us-
Sheet: Transactions

 |  |  | Payment Method | Date | Name | Cash Received or Paid | Receipt | Revenue ZWL | Expenses ZWL | Revenue US$ | Expenses US$ | Financial Category | Item bought / paid for | Terms | Status | Customer / Supplier | Column1 | Debit ZWL | Credit ZWL | Debit US$ | Credit US$
 |  |  | Bank | 2022-01-01 00:00:00 | KO | Accounts Payable | 100 | 950487.77 |  |  |  | Opening Balance |  |  | Accruals | Supplier | 400
 |  |  | Bank | 2022-01-02 00:00:00 | RK | Accounts Receivable | 101 | 10000 |  |  |  | Direct expenses | Chairs |  | Accruals | Supplier | 400
 |  |  | Bank | 2022-01-03 00:00:00 | HYO | Accounts Payable | 102 |  | 8000 |  |  | Other Income 2 |  |  | Invoiced | Customer | 100
 |  |  | Cash | 2022-01-01 00:00:00 | HYO | Cash receipts from customers | 103 | 5000 |  |  |  | Other Income 3 |  |  | Received | Customer | 200
 |  |  | Cash | 2022-01-02 00:00:00 | CJ | Cash receipts from customers | 104 | 950000 |  |  |  | Other Income 4 |  |  | Received | Customer | 200
 |  |  | Bank | 2022-01-03 00:00:00 | KO | Accounts Payable | 105 |  |  |  | 4000 | Direct expenses |  |  | Accruals | Supplier | 400
 |  |  | Bank | 2022-01-01 00:00:00 | YT | Cash paid to suppliers | 106 |  | 3000 |  |  | Direct expenses |  |  | Paid | Supplier | 500
 |  |  | Bank | 2022-01-02 00:00:00 | AML | Accounts Receivable | 107 |  |  | 7000 |  | Opening Balance |  |  | Invoiced | Customer | 100
 |  |  | Bank | 2022-01-10 00:00:00 | AML | Accounts Receivable | 109 |  |  | 4500 |  | Sales |  |  | Invoiced | Customer | 100
 |  |  | Bank | 2022-01-10 00:00:00 | RJ | Cash receipts from customers | 110 |  |  | 4300 |  | Sales |  |  | Received | Customer | 200
 |  |  | Cash | 2022-01-10 00:00:00 | AML | Cash paid to suppliers | 111 |  |  |  | 3500 | Direct expenses
 |  |  | Bank | 2022-01-11 00:00:00 | KO | Cash paid to suppliers | 112 |  | 1200 |  |  | Direct expenses
 |  |  | Bank | 2022-01-12 00:00:00 | HYO | Cash receipts from customers | 113 | 80000 |  |  |  | Sales
Spreadsheet: 166907d1341844260-combining-two-unlike-sets-of-data-sample-eoy_reply
Sheet: Summary

 |  | <700000 | >700000 | <800000 | >800000
 |  | Revenue | Expense |  | Grant
100 |  |  |  |  |  |  | I am trying to get a formula with summary numbers
200 |  |  |  |  |  |  | into this table without having to manually input
250 |  |  |  |  |  |  | all of the ranges, was hoping there was some way with a
273 |  |  |  |  |  |  | vlookup or an index match search
300 |  |  |  |  |  |  | All numbers in column A here aren't on sheet 3
 |  |  |  |  |  |  | * 3 Named Ranges: SumData; AccountCode; Index
 |  |  |  |  |  |  | * Index & Match formulas with [NAME]
 |  |  |  |  |  |  | * The #N/A errors can be hidden with the IFERROR function if needed
Spreadsheet: 728713d1618584704-dynamic-dropdown-list-dependent-dropdown-torso-
Sheet: Sheet1

City | New York | ⇐ Select the city
Code | c | ⇐ Dropdown list that should propose only the codes corresponding to the selected city
 |  | If San Francisco is selected, it should propose only "a" and "b"
City | Code |  | City List
San Francisco | a |  | San Francisco
San Francisco | b |  | New York
New York | c
New York | d
New York | e
Spreadsheet: 821295d1678594028-need-help-on-my-formula-to-return-not-found-sample23
Sheet: Sheet1

 |  |  | Driver | Vehicle # |  | Job | Driver | Vehicle
 |  |  | [NAME] | 1 |  | Test job #1 | [NAME]
 |  |  | [NAME] | 2 |  | Test job #2 | [NAME]
 |  |  | [NAME] | 3 |  | Test job #3 | [NAME]
 |  |  | [NAME] | 4 |  | Test job #4 | [NAME]
 |  |  | [NAME] | 5 |  | Test job #5 | [NAME]
 |  |  |  |  |  | Test job #6 | [NAME]
Spreadsheet: 165801d1341343644-index-and-match-3-criterias-multiple-sheets-test-sample
Sheet: Gross Margin

Gross Margin
Cars | GROSS MARGIN | Markets Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GROSS MARGIN | Markets Europe
 | 2010 |  |  |  |  |  |  |  |  |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  | 2012
TOTAL | P1/10 | [NAME] | P3/10 | P4/10 | P5/10 | P6/10 | P7/10 | P8/10 | P9/10 | P10/10 | P11/10 | P12/10 | P1/11 | P2/11 | P3/11 | P4/11 | P5/11 | P6/11 | P7/11 | P8/11 | P9/11 | P10/11 | P11/11 | [NAME] | P1/12 | [NAME] | P3/12 | P4/12 | P5/12 | P6/12 | [NAME] | P8/12 | P9/12 | P10/12 | P11/12 | P12/12
Europe | 2287 | 2287 | 99999 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Eurasia
MEA
SEAP
India
NA
LATAM
China
World TOTAL
Spreadsheet: andy_zipper__215__DYNEGY-ICE VOL May25
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
ICE CRUDE PRODUCTS VOLUME: |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], G | NG Fin BS, LD1 for GDM | MMBtus | 2 | 1810000 |  | [NAME], R | Firm-LD Peak | MWhs | 1 | 35200
Mckay, B | NG Fin BS, LD1 for IF | MMBtus | 2 | 1132500 |  | Richter, J | Firm-LD Off-Peak | MWhs | 1 | 7600
[NAME], E | NG Fin BS, LD1 for IF | MMBtus | 2 | 600000 |  | Stalford, R | Firm-LD Peak | MWhs | 2 | 32000
Goodell, S | NG [NAME], FP | MMBtus | 1 | 20000 |  | Dorland, C | Firm-LD Peak | MWhs | 5 | 4000
Grand Total |  |  | 7 | 3562500 |  | Carson, M | Firm-LD Peak | MWhs | 1 | 800
 |  |  |  |  |  | Grand Total |  |  | 10 | 79600
Spreadsheet: 94993d1294721147-match-formula-syntax-traymond_match_formula-1-
Sheet: Setup Data

Combination MACHINE SETUP per ORDER
 |  | (minutes)
Constant Laser Prep Time |  | 5
Tooling Build and [NAME] time per tool |  | 1
Material Staging & Program Download order |  | 6
 |  |  | TOTAL SETUP MINUTES
 | PF&D Factor | 0.15 | 0.15 | 0.15 | 0.15
 |  | Simple | Non-Std Cutout | Forms, | Tapping
 |  | Geometry | Geometries | etc...
PROGRAM AUDIT & 1st Pc INSPECTION |  | 0.03 | 0.04 | 0.06 | 0.08
TIME COMPLEXITY FACTOR => |  | 1 | 2 | 3 | 4
 | 1 | 14.214 | 14.352 | 14.628 | 14.904
 | 2 | 15.3985 | 15.548 | 15.847 | 16.146
 | 3 | 16.583 | 16.744 | 17.066 | 17.388
Q | 4 | 17.7675 | 17.94 | 18.285 | 18.63
T | 5 | 18.952 | 19.136 | 19.504 | 19.872
Y | 6 | 20.1365 | 20.332 | 20.723 | 21.114
 | 7 | 21.321 | 21.528 | 21.942 | 22.356
o | 8 | 22.5055 | 22.724 | 23.161 | 23.598
f | 9 | 23.69 | 23.92 | 24.38 | 24.84
 | 10 | 24.8745 | 25.116 | 25.599 | 26.082
P | 11 | 26.059 | 26.312 | 26.818 | 27.324
U | 12 | 27.2435 | 27.508 | 28.037 | 28.566
N | 13 | 28.428 | 28.704 | 29.256 | 29.808
C | 14 | 29.6125 | 29.9 | 30.475 | 31.05
H | 15 | 30.797 | 31.096 | 31.694 | 32.292
E | 16 | 31.9815 | 32.292 | 32.913 | 33.534
S | 17 | 33.166 | 33.488 | 34.132 | 34.776
 | 18 | 34.3505 | 34.684 | 35.351 | 36.018
 | 19 | 35.535 | 35.88 | 36.57 | 37.26000000000001
 | 20 | 36.7195 | 37.076 | 37.78899999999999 | 38.502
 | 21 | 37.904 | 38.272 | 39.008 | 39.744
 | 22 | 39.0885 | 39.468 | 40.227 | 40.986
 | 23 | 40.273 | 40.66399999999999 | 41.446 | 42.22799999999999
 | 24 | 41.4575 | 41.85999999999999 | 42.665 | 43.47
 | 25 | 42.642 | 43.056 | 43.884 | 44.712
 | 26 | 43.8265 | 44.252 | 45.10299999999999 | 45.954
 | 27 | 45.011 | 45.448 | 46.322 | 47.19600000000001
 | 28 | 46.1955 | 46.644 | 47.541 | 48.438
 | 29 | 47.38 | 47.84 | 48.76000000000001 | 49.68
 | 30 | 48.5645 | 49.03599999999999 | 49.979 | 50.922
Spreadsheet: 124435d1318419198-sumifs-problem-sumifs-problem
Sheet: Link Factors

 | Click to Change
Status | Incurred
Open/Closed
[NAME] (>=) :
 |  | Development Year
 | Year | DevYr1 | DevYr2 | DevYr3 | DevYr4 | DevYr5 | DevYr6 | DevYr7 | DevYr8 | DevYr9 | DevYr10 | DevYr11 | DevYr12 | DevYr13 | DevYr14 | DevYr15 | DevYr16
 | 1996
 | 1997
 | 1998
 | 1999
 | 2000
 | 2001
 | 2002
 | 2003
 | 2004
 | 2005
 | 2006
 | 2007
 | 2008
 | 2009
 | 2010
 | 2011
 |  | Development Periods
 |  | 1-2 | 2-3 | 3-4 | 4-5 | 5-6 | 6-7 | 7-8 | 8-9 | 9-10 | 10-11 | 11-12 | 12-13 | 13-14 | 14-15 | 15-16
 | [NAME]
Spreadsheet: 700254d1603098578-summary-creation-from-source-data-help2
Sheet: Sample

List of workers who are available on Friday for Decant: |  |  |  |  |  |  | List of workers who are available on Sunday for Pick:
user | Decant |  |  |  |  |  | user | Pick
ahnasimo | 1 |  |  |  |  |  | [NAME] | 1
[NAME] | 1 |  |  |  |  |  | greenupe | 1
budulecb | 1 |  |  |  |  |  | guymakus | 1
davieowe | 1 |  |  |  |  |  | kaylems | 1
eleabrow | 1 |  |  |  |  |  | lappleby | 1
greenupe | 1 |  |  |  |  |  | samsprat | 1
guymakus | 1 |  |  |  |  |  | [NAME] | 1
[NAME] | 1 |  |  |  |  |  | lewmande | 1
jokelseu | 1 |  |  |  |  |  | sophieni | 1
juaainho | 1 |  |  |  |  |  | adquinn | 1
kaylems | 1 |  |  |  |  |  | cgebreme | 1
lappleby | 1 |  |  |  |  |  | josleac | 1
[NAME] | 1 |  |  |  |  |  | [NAME] | 1
noodowd | 1 |  |  |  |  |  | qadeekha | 1
ntywi | 1 |  |  |  |  |  | reevesza | 1
sameerdi | 1 |  |  |  |  |  | [NAME] | 1
samsprat | 1 |  |  |  |  |  | methvenp | 1
[NAME] | 1 |  |  |  |  |  | [NAME] | 1
[NAME] | 1 |  |  |  |  |  | sarahlei | 1
[NAME] |  |  |  |  |  |  | alfonsav | 1
hussaifu | 1 |  |  |  |  |  | buckdavb | 1
judgegre | 1 |  |  |  |  |  | pebecket | 1
kylord
lmbchri | 1
molnaram
nsmthem | 1
sophanso | 1
stevbras | 1
tonsmedl
tylorxy | 1
welkrist | 1
hamkashi | 1
[NAME] | 1
lewmande | 1
newmgare | 1
simavesz | 1
sophieni | 1
[NAME] | 1
aldc | 1
garetbak | 1
kondlaur | 1
longraha | 1
shohaibh
smcnnor | 1
ahmedxbr | 1
alfonsav | 1
buckdavb | 1
chahabal | 1
grahaeri | 1
hmzma | 1
huhaleem | 1
lbecjosh | 1
ljoshcoo | 1
mcgeepau
[NAME] | 1
pebecket | 1
samusteq | 1
shaugibb | 1
[NAME] | 1
ylouidan | 1
Spreadsheet: 70642d1271347308-require-help-with-counting-based-on-multiple-criteria-array-example
Sheet: Data

Site | Name | Date | Incident
Alpha | Johns | 2010-04-15 00:00:00 | Critical
Beta | Adams | 2010-03-12 00:00:00 | Serious
Delta | Smith | 2010-03-12 00:00:00 | Critical
Omega | Johns | 2010-03-01 00:00:00 | Important
Alpha | Johns | 2010-03-01 00:00:00 | Critical
Beta | Adams | 2010-04-15 00:00:00 | Critical
Delta | Smith | 2010-04-03 00:00:00 | Serious
Omega | Johns | 2010-04-03 00:00:00 | Critical
Alpha | Johns | 2010-04-08 00:00:00 | Serious
Beta | Adams | 2010-03-21 00:00:00 | Serious
Delta | Smith | 2010-03-21 00:00:00 | Important
Omega | Johns | 2010-03-21 00:00:00 | Important
Spreadsheet: 725096d1616525924-annual-pay-raise-formula-to-add-to-personnel-budget-costs-payroll-annual-raises-formula-v2
Sheet: Personnel

 | Job Title | Employee Name | Status | Hire Date | Term Date | Annual Pay | FT or PT | [NAME] or Hourly | [NAME] |  | 2019-01-01 00:00:00
 | Art Director |  | Filled | 2018-07-15 00:00:00 | 2020-01-31 00:00:00 | 150000 | FT | Salary
 | Senior Marketing Manager |  | Filled | 2019-03-20 00:00:00 |  | 150000 | FT | Salary
 | VP Product |  | Filled | 2022-03-01 00:00:00 |  | 150000 | FT | Salary
 | Annual raises on anniversary date of hire: |  | 0.03
 | Start date of annual raises: |  | 2022-01-01 00:00:00
Spreadsheet: 0f1f086d-7e83-4f0a-84f8-c1b3dc0ac137
Sheet: CPI-Aug2013

 |  |  |  | Referendum Cap Calculation with Final Inflation Data
 |  |  |  |  |  | FY 2005-FY 2013
CPI - All Urban Consumers
Series Id:    CUUR0000SA0
U.S. All items, 1982-84=100
Source: | U.S. Department of Labor
 | Bureau of Labor Statistics
 | http://www.bls.gov/
 |  | A | B | C | D | E | F | G | H | I | J
 |  |  |  |  |  |  |  |  |  | [NAME]. [NAME] | Actual
 |  | Calendar | Calendar | Fiscal | Annual | Inflation | [NAME] | Inflation | Actual | Increase | Inflation
Fiscal | Calendar | First | Second | Year | Projected | Ratio | Allow Based | Based | [NAME]. [NAME] | over | Ratio
Year | Year | Half | Half | Average | Inflation | [NAME]. [NAME] | [NAME]. [NAME] | [NAME]. [NAME] | Gtr of F or G | FY 2004 | Alt. [NAME]
2002 | 2002
2003 | 2003
2014 | 2014
2015 | 2015
2016 | 2016
Spreadsheet: joe_parks__14601__POSTIONTRAX_OCT
Sheet: NOV_SWAP

 | SELL |  |  |  | BUY
BEGINNING | 159 | 2.486 |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  | 30 | 2.655 |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  | 15 | 2.655 |  |  |  |  | NEW DEALS
 |  |  |  |  | 22.5 | 2.645
 |  |  |  |  | 15 | 2.675 |  |  |  |  | TOTAL  P&L
 |  |  |  |  | 22.5 | 2.69
 |  |  |  |  | 30 | 2.675
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  |  |  | 31 | 3.15
 |  |  |  |  |  |  |  |  |  |  | 15.5 | 3.115
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 863354d1710866299-replace-a-list-of-countifs-with-a-lookup-formula-test-workbook
Sheet: Points

 | Total | Match | Match | Won | High Breaks (HB) |  |  | HB | Total
Name | Points | Count | Av |  | 1 | 1.5 | 2 | Points | Points
 | Scored |  |  |  | 30-49 | 50-69 | 70+
Name  04
Name  03
Name  01
Name  06
Name  05
Name  02
Spreadsheet: 469693d1468068329-report-using-looksup-match-and-pivot-help-file
Sheet: Consolidated

Report  type with dropdown , look up & matching conditions
Report 1 |  |  | Report 2 |  |  |  | Report 3 |  |  |  |  |  | Report 4
Teacher | [NAME] |  | Teacher | [NAME] |  |  | Month | In | From | Out | To |  | Teacher | [NAME]
Month | No of Student in  In Morning Coach |  | Month | No of Student in  In | No of Student OUT |  | Jan |  |  |  |  |  | Month | No of Coaches Handled | No of Student OUT
Jan | 160 |  | Jan | 160 | 68 |  | [NAME] | 1 | Home | 1 | Home |  | Jan | 1 | 1
Feb |  |  | Feb |  |  |  | Virgin | 1 | Home | 1 | Home |  | Feb | 2 | 2
 |  |  |  |  |  |  | June
 |  |  |  |  |  |  | Virgin | 1 | Coaching Center
 |  |  |  |  |  |  | [NAME] | 2 | Day Care | 1 | Day Care
 |  |  |  |  |  |  |  |  |  | 1 | Coaching Center
Data
Teacher | Month | Week Num | Date | Morning Coach No. | Coach Reg No. | From | Student In | Evening  Coach No. | To | Students  Out
[NAME] |  |  | 2016-01-02 00:00:00 | MA 1 | AB1 | Home | 160 | MA 2 | Home | 68
Virgin |  |  | 2016-01-03 00:00:00 | VG 1 | AB2 | Home | 104 | VG 2 | Home | 53
[NAME] |  |  | 2016-02-20 00:00:00 | MA 1 | AB3 | Home | 176 | MA 2 | Home | 68
[NAME] |  |  | 2016-02-20 00:00:00 | MA 1 | AB4 | Home | 99 | MA 2 | Day Care | 59
Virgin |  |  | 2016-03-03 00:00:00 | VG 1 | AB5 | Day Care | 103 | VG 2 | Day Care | 132
Virgin |  |  | 2016-03-03 00:00:00 | VG 1 | AB6 | Day Care | 111 | VG 2 | Coaching Center | 79
[NAME] |  |  | 2016-03-03 00:00:00 | JY 1 | AB7 | Home | 109 | JY 2 | Coaching Center | 35
[NAME] |  |  | 2016-03-03 00:00:00 | MA 1 | AB8 | Day Care | 86 | MA 2 | Coaching Center | 71
[NAME] |  |  | 2016-04-10 00:00:00 | MA 1 | AB9 | Coaching Center | 99 | MA 1 | Home | 37
Virgin |  |  | 2016-04-15 00:00:00 | VG 1 | AB10 | Coaching Center | 102 | VG 2 | Home | 117
Virgin |  |  | 2016-04-15 00:00:00 | VG 1 | AB11 | Coaching Center | 109 | VG 1 | Day Care | 77
Virgin |  |  | 2016-04-15 00:00:00 | VG 3 | AB12 | Home | 91 | VG 3 | Day Care | 30
Virgin |  |  | 2016-06-04 00:00:00 | VG 1 | AB13 | Coaching Center | 92 | JY 2 | Coaching Center | 65
[NAME] |  |  | 2016-06-04 00:00:00 | JY 2 | AB14 | Day Care | 136 | JY 2 | Day Care | 136