tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 830603d1685003732-convert-count-comma-separated-values-into-columns-with-boolean-values-example_optionlist-ans
Sheet: Sheet1

Source | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
1
1
2
2.3
1.3
3
2.3
1,4
2,3,11
2,3,4
1.5
3.5
2,4,5
1,9,10
3.11
Result should look like…
Source | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2.3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.3 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2.3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1,4 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2,3,11 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2,3,4 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.5 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
3.5 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
2,4,5 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
1,9,10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
3.11 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Spreadsheet: 847442d1698364006-if-sheets-have-cell-with-certain-word-then-copy-those-rows-to-another-sheet-test-kinderheim511-
Sheet: AltF4

Anything Column A | Anything Column B | Anything Column C | Reference | Whatever Column E | Whatever Column F | Whatever Column G | Year | Amount | Number of rows | Placehold
Anything A26 | Anything B26 | Anything C26 | PAP47751 | Whatever | Whatever | Whatever | 2026 | 70000 | 3 | TEST
Anything A6 | Anything B6 | Anything C6 |  |  |  |  |  |  |  | TEST
Spreadsheet: 0a74c358-4d1f-4e0e-b6e2-e3f9c0b7cbdf
Sheet: Sheet1

Release: Regional and State Employment and Unemployment (Seasonally Adjusted) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=250
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-07-30 5:30 AM CDT
 | Real-Time | Period
Name: | Start | End
Regional and State Employment and Unemployment (Seasonally Adjusted) | 2012-01-24 00:00:00 | Current
Link:
[NAME] | 2012-01-24 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2012-01-24 00:00:00 | Current
Notes:
Bureau of Labor Statistics data that is seasonally adjusted by the | 2012-01-24 00:00:00 | Current
Federal Reserve Bank of St. Louis.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2012-01-24 00:00:00
2012-03-13 00:00:00
2012-03-30 00:00:00
2012-04-20 00:00:00
2012-05-18 00:00:00
2012-06-15 00:00:00
2012-07-20 00:00:00
2012-07-23 00:00:00
2012-08-17 00:00:00
2012-09-21 00:00:00
2012-10-19 00:00:00
2012-11-20 00:00:00
2012-12-21 00:00:00
2013-01-18 00:00:00
2013-03-18 00:00:00
2013-03-29 00:00:00
2013-04-19 00:00:00
2013-05-16 00:00:00
2013-05-17 00:00:00
2013-06-20 00:00:00
2013-06-21 00:00:00
2013-07-19 00:00:00
2013-08-19 00:00:00
2013-09-20 00:00:00
2013-11-22 00:00:00
2013-12-20 00:00:00
2014-01-28 00:00:00
2014-03-17 00:00:00
2014-03-28 00:00:00
2014-04-18 00:00:00
2014-05-16 00:00:00
2014-06-20 00:00:00
2014-07-18 00:00:00
Spreadsheet: 874028d1720596871-getting-data-from-one-workbook-to-another-athletics-spreadsheet-v14
Sheet: Overall

 |  |  |  |  | OVERALL POINTS
TIBROGARGAN | BOYS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL |  | SENIORS |  |  | JUNIORS
 |  |  |  |  |  |  |  |  | TIBROGARGAN |  |  | TIBROGARGAN
 | GIRLS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL |  | COOCHIN |  |  | COOCHIN
 |  |  |  |  |  |  |  |  | COONOWRIN |  |  | COONOWRIN
COOCHIN | BOYS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL
 | GIRLS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  | Tibro | Coochin | Coonowrin
COONOWRIN | BOYS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL |  |  |  |  | TOTAL
 | GIRLS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  | CHAMPIONS | RUNNER UP | 3RD
Spreadsheet: ac1a795c-8736-40ab-aaa3-1f7ec60f698f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6269 | 40701 | [NAME] | Rodriguez | ESP | 12 | 00:08:02 | 00:01:08 | 00:16:17 | 00:00:54 | 00:18:08 | 1 | 00:44:30
Spreadsheet: matt_motley__26405__July orig final
Sheet: Tracking

Middle Market/Trading Origination Agreement
Actual Trading Earnings
Book | Starting (Benchmark) Value:  Actual Trading Earnings through April 30, 2001 | Middle Market % of Book | Through May 30, 2001 | Through June 30, 2001 | Through July 31, 2001 | Through Aug 31, 2001 | Through Sep 30 31, 2001 | Through Oct 31, 2001 | Through Nov 30, 2001 | Through Dec 31, 2001
[NAME] ([NAME]) | 106290833 | 0.08 | 105586268 | 102567522 | 121693212
[NAME] Northwest ([NAME]) | 146981038 | 0.12 | 156276251 | 135487513 | 164377866
[NAME] California ([NAME]) | 53346914 | 0.08 | 107104375 | 121944800 | 124744624
Long Term West Management ([NAME]) | 15461811 | 0.12 | 52017299 | 73190382 | 76373124
Short Term Southwest (Fischer/Alonso) | 19642529 | 0.05 | 22040230 | 27419473 | 28055767
Short Term Northwest (Crandall/Scholtes) | 37823394 | 0.05 | 32112238 | 28458788 | 31182658
Short Term California (Richter/Mallory) | 61104497 | 0.05 | 57371639 | 59812265 | 68828735
Total
Actual Middle Market Earnings
Middle Market | Actual Middle Market through April 30, 2001 | July Orig | Through May 30, 2001 |  | Through July 31, 2001 | Through Aug 31, 2001 | Through Sep 30 31, 2001 | Through Oct 31, 2001 | Through Nov 30, 2001 | Through Dec 31, 2001
[NAME] ([NAME])
[NAME] Northwest ([NAME])
[NAME] California ([NAME])
Long Term West Management ([NAME])
Short Term Southwest (Fischer/Alonso)
Short Term Northwest (Crandall/Scholtes)
Short Term California (Richter)
Total
Spreadsheet: 146fe49a-f984-4e2b-94ad-39ee93893825
Sheet: Sheet1

>GlycineRS_NoGlyc | Unnamed: 1 | Unnamed: 2
GGACAGAGAGGAUAUGAGGAGAGAUUUCAUUUUAAUGAAACACCGAAGAAGUAAAUCUUUCAGGUAAAAAGGACUCAUAUUGGACGAACCUCUGGAGAGCUUAUCUAAGAGAUAACACCGAAGGAGCAAAGCUAAUUUUAGCCUAAACUCUCAGGUAAAAGGACGGAGAAAACACAACAAAGAAACAACAACAACAAC
U13A | eSDC | 1.8766715254856
A17U | eSDC | 0.2966241682605
U25A | eSDC | 0.191564268474452
U30A | eSDC | 0.117818480749502
U31A | eSDC | 0.0568675929216789
U32A | eSDC | 0.0542953865048038
A34U | eSDC | 0.260496496254176
A35U | eSDC | 0.221129075328171
A38U | eSDC | 0.126061273339854
A39U | eSDC | 0.14937646708769
C41G | eSDC | 0.33955633605335
G45C | eSDC | 0.240676240520106
A47U | eSDC | 0.151459580905479
U60A | eSDC | 0.295756922298526
A62U | eSDC | 0.250693613940758
A66U | eSDC | 0.209583768642037
A67U | eSDC | 0.166662262332782
A69U | eSDC | 0.146099005434204
A70U | eSDC | 0.130951830172728
A77U | eSDC | 0.119874935296872
U81A | eSDC | 0.367045156843781
G82C | eSDC | 0.540524530336401
G83C | eSDC | 0.19779394217666
A84U | eSDC | 0.594916314036872
A87U | eSDC | 0.246923190503107
A88U | eSDC | 0.154162000032377
U93A | eSDC | 0.786476921774779
A107U | eSDC | 0.491004225729494
A108U | eSDC | 0.167391742257826
G109C | eSDC | 0.420190251504982
A110U | eSDC | 0.291434876263936
U113A | eSDC | 2.31376535291386
U133A | eSDC | 0.77143598489803
U136A | eSDC | 0.26760748739678
U137A | eSDC | 0.229906863727699
U138A | eSDC | 0.233984128783816
U139A | eSDC | 0.366825246859122
A147U | eSDC | 0.590479241556355
A157U | eSDC | 1.39793389325212
A158U | eSDC | 1.02703214984555
A159U | eSDC | 1.30038658137337
G166C | eSDC | 1.43621277492068
Spreadsheet: 769969d1645738094-sums-of-dynamic-unique-values-with-multiple-criteria-isolate-tests
Sheet: Calculation

 | Selected Information (Form Controls) |  |  |  |  |  |  |  |  |  |  | Calculation for scrolling table
 |  | Selected Type | 1
 |  | Selected Year | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Year
 | For Drop_down selections |  |  |  |  | Types data |  |  |  |  |  |  |  |  |  |  | difference from  previous year
 | Year | Type | Values |  |  |  | gram_positive |  |  |  |  | Nr. | Type | isolates_tested | isolates_susceptible | %susceptibility | Δ% susceptibility
 | 2018 | gram_negative | isolates_tested |  |  | Amikacin-Citrobacter freundii | Ampicillin-Enterococcus spp.
 | 2019 | gram_positive | isolates_susceptible |  |  | Amikacin-Klebsiella pneumoniae | Group A Strep-Penicillin
 | 2020 |  | %susceptibility |  |  | Amikacin-Proteus mirabilis | Group B Strep-Penicillin
 |  |  |  |  |  | [NAME] cloacae complex | Linezolid-MRSA
 |  |  |  |  |  | [NAME] morganii | Penicillin-Staphylococcus aureus
 |  |  |  |  |  | [NAME] coli | Linezolid-MSSA
 |  |  |  |  |  | Ertapenem-Acinetobacter baumannii | Penicillin-MRSA
 |  |  |  |  |  | Ertapenem-E. coli | Penicillin-MSSA
 |  |  |  |  |  | Tobramycin-Klebsiella aerogenes
 |  |  |  |  |  | Imipenem-Citrobacter freundii
 |  |  |  |  |  | Meripenem-Citrobacter freundii
 |  |  |  |  |  | Amikacin-E. coli
 |  |  |  |  |  |  |  |  |  |  |  |  | Calculations for headers
 |  |  |  |  |  |  |  |  |  |  |  |  | Hospital Numbers
 |  |  |  |  |  |  |  |  |  |  |  |  | isolate_hospital_n | `=sum of unique values  for each "type",  "year" and "bug"
Spreadsheet: 756336d1637444941-sumif-function-showing-a-zero-value-everytime-jia26-sumif-function-problem
Sheet: Sheet1

Months | Branch Sales
2021-01-01 00:00:00 | 2346990
 | 5598067
 | 6278199
 | 5123580
 | 5378822
 | 6184512
 | 8140894
 | 7248380
 | 5628090
 | 4987535
Start: | 2021-03-01 00:00:00 | End: | 2021-08-31 00:00:00
[NAME]:
Spreadsheet: 05bd2c95-0328-4bdb-9b14-62ca30e6b6bd
Sheet: 2004-05

Table U
Student Numbers by Disability
2004-05
Disability | Undergraduate | Graduate | Total
Blind / Are Partially Sighted | 3 | 1
Deaf / Have a Hearing Impairment | 19 | 13
Dyslexia | 181 | 53
Mental Health Difficulties | 9 | 1
Multiple Disabilities | 11 | 3
Unseen Disability eg Diabetes, [NAME], [NAME] | 59 | 36
Wheelchair User / Have Mobility Difficulties | 3 | 9
Disability Not Listed Elsewhere | 53 | 15
No Known Disability | 11716 | 6570
Not Known | 87 | 572
Total
The data in this table reflects disability information voluntarily provided by students at the time of application. Students who do not wish to declare their disability or subsequently develop or are diagnosed as having a disability while studying at UCL will remain in the "No Known Disability" or "Not Known" categories. Therefore, the actual number of students with disabilities registered at UCL will be higher than indicated in this table.
Spreadsheet: 195237d1353452719-auto-pop-chart-book2
Sheet: Sheet1

Error Value
No cost | Under $250 over $0 | Over $250 under $1000 | Over $1000 | Amount
 |  |  |  | 0
 |  |  |  | 200
 |  |  |  | 249
 |  |  |  | 250
 |  |  |  | 999
 |  |  |  | 1000
 |  |  |  | 2000
 |  |  |  | 3000
Spreadsheet: 274974d1383298394-list-client-appointments-outside-of-normal-induction-dates-client-bookings-register
Sheet: Bookings Display Sheet

 | CLIENT BOOKING REGISTER
 | Select Month |  | Select Year | First Monthly Induction Date
 | November |  | 2013
 | EXTRA APPOINTMENTS - PLEASE USE ONLY IF CLIENT IS UNABLE TO ATTEND REGULAR INDUCTION !
 | Time | Date | Day | Name | Client No. | Requirement | Contact No. 1 | Contact No. 2 | Advisor | Centre | Doc | Status
 | 10 | 2013-11-01 00:00:00 |  | Mr E
 | 10.3 | 2013-11-01 00:00:00 |  | Mr F
 | 10.45 | 2013-11-01 00:00:00 |  | Mr G
 | 13 | 2013-11-01 00:00:00 |  | Mr H
 | 15 | 2013-11-06 00:00:00 |  | Mr I
 | 12 | 2013-11-14 00:00:00 |  | Mr J
 | Additonal Bookings outside of the Monday Dates to be Listed here.
 | Time | Date | Day | Name | Client No. | Requirement | Contact No. 1 | Contact No. 2 | Advisor | Centre | Doc | Status
 | 13 |  |  | Mr A
 | Time | Date | Day | Name | Client No. | Requirement | Contact No. 1 | Contact No. 2 | Advisor | Centre | Doc | Status
 | 13 |  |  | Mr B
 | Time | Date | Day | Name | Client No. | Requirement | Contact No. 1 | Contact No. 2 | Advisor | Centre | Doc | Status
 | 13 |  |  | Mr C
 | Time | Date | Day | Name | Client No. | Requirement | Contact No. 1 | Contact No. 2 | Advisor | Centre | Doc | Status
 | 13 |  |  | Mr D
 | Time | Date | Day | Name | Client No. | Requirement | Contact No. 1 | Contact No. 2 | Advisor | Centre | Doc | Status
Spreadsheet: 53344d1253218387-merging-two-spreadsheets-test
Sheet: Total

Shippers # | Carrier # | Date | Month | Year | Logs Picked up from | Carrier | Driver/Truck # | Log count on B/L | Log count on yard | # Tagged  logs | Gross BFT | Net BFT | [NAME] | Buyer | Cost | Ticket # | Load | Cost
603303 | 107-207 | 2009-01-08 00:00:00 | 1 | 2009 | [NAME], KY | RIPATO | DICKIE | 451 | 450 | 452 | 45648 | 44587 | 83500 | HUSTONVILLE | 45125 | J0900025 | 1
Spreadsheet: 796382d1663245653-drag-formula-that-needs-symbols-across-columns-index-aggregate-help-aligw
Sheet: Sheet1

 | Name | Score |  | 10 | 9 | 8 | 7 | 6 | 5
 | [NAME] | 10
 | Balbert | 9 |  | Elbert | [NAME] | [NAME]
 | [NAME] | 9 |  | Helbert | Dalbert
 | Dalbert | 9 |  | [NAME]
 | Elbert | 10
 | Felbert | 8
 | [NAME] | 8
 | Helbert | 10
 | [NAME] | 7
 | [NAME] | 6
 | [NAME] | 10
 | Lilbert | 5
Spreadsheet: 862228d1709973302-subtract-in-match-sample
Sheet: Salary Rate

Salary Structure:  [NAME]
Month/Year:  Feb/2024
SLNO | EMP ID. | Name | DA | HRA | CONVEYANCE | LUNCH | OTHERS | UNIFORM | BASIC. | RES CH PAY | Remarks |  | Gross | [NAME]
1 |  |  |  |  |  | 0 | 0 | 0 |  |  | 15107
Spreadsheet: 87462291-112b-45fa-8d81-68b16ddb29cc
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (2 Entries):
 | 14 Wireless 14.1 Cellular systems 14.1.8 Tetra
No. | Company | Country | City | [NAME] | Hall/Booth
1 | [NAME] | Germany | Dachau | 85221 | A1.117
2 | BHE Bonn Hungary Electronics Ltd. | Hungary | Budapest | 1044 | A1.146
Spreadsheet: 83588d1283543735-cross-reference-a-table-sample2
Sheet: USD AP AA

 |  | January | February | March | April | May | June | July | August | September | October | November | December
00002 | AED | 0 | 0 | 0 | -0.19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
00002 | AUD | 48252.88 | -22626.23 | 27330.61 | 16253.41 | -13400.69 | -11763.7 | -3537.24 | -126.78 | 0 | 0 | 0 | 0
00002 | BRL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
00002 | CAD | 12410.13 | 11752.93 | 12967.98 | 8191.96 | -5827.23 | 6618.18 | 27632.46 | 67088.11 | 0 | 0 | 0 | 0
00002 | CHF | -316.48 | -972.13 | -1855 | 518.93 | -1822.82 | -15043.13 | 4085.44 | 967.47 | 0 | 0 | 0 | 0
00002 | CNY | 0 | 0 | 0 | 0 | 0 | -239.39 | 1777.23 | 53.16 | 0 | 0 | 0 | 0
00002 | DKK | 229.83 | -6817.57 | -68.15 | -800.4 | -5596.49 | -4958.14 | 4376.97 | 2320.23 | 0 | 0 | 0 | 0
00002 | EUR | -477094.88 | -618552.25 | -252552.66 | -93686.62 | -955454.16 | -1184228.67 | 561085.65 | 738723.45 | 0 | 0 | 0 | 0
00002 | GBP | -24307.55 | -12600.25 | -39855.62 | -16154.2 | -46241.85 | -39074.95 | 140411.61 | 77620.86 | 0 | 0 | 0 | 0
00002 | HKD | -18.98 | -34.58 | 183.13 | 20.19 | -18.95 | -76.74 | 2.39 | 0 | 0 | 0 | 0 | 0
00002 | [NAME] | 0 | 0 | 0 | -4585.98 | -1019.82 | 318.18 | 5993.28 | 7952.44 | 0 | 0 | 0 | 0
00002 | MAD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
00002 | NOK | 1712.87 | -17016.86 | 516.84 | -2755.78 | -30360.01 | -12842.3 | 25684.18 | 16101.18 | 0 | 0 | 0 | 0
00002 | NZD | 2439.7 | -34655.03 | 2666 | 6013.4 | -100.26 | -372.54 | -269.31 | -203.77 | 0 | 0 | 0 | 0
00002 | SEK | 1605.39 | -13540.7 | 10275.85 | -5049.46 | -22388.88 | -22260.58 | 34490.96 | 21982.61 | 0 | 0 | 0 | 0
00002 | SGD | -147.02 | -3548.63 | -25.5 | 1204.05 | 794.4 | 192.18 | -311.36 | 111.75 | 0 | 0 | 0 | 0
00002 | THB | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
00002 | USD | 74075.55 | 88834.78 | 66167.13 | 87847.44 | 65819.46 | 26175.06 | 37686.88 | 0 | 0 | 0 | 0 | 0
00002 | ZAR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
00006 | CAD | 19.24 | 0 | 69.91 | 0 | 0 | -1467.31 | -1900.94 | 522.17 | 0 | 0 | 0 | 0
00084 | CAD | 0 | 223.34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
00084 | CHF | 0 | 0 | -65.78 | 0 | 0 | -89.55 | 63.14 | 0 | 0 | 0 | 0 | 0
00084 | DKK | 0 | -47.46 | -3.6 | 0 | -56.86 | 0 | 0 | 0 | 0 | 0 | 0 | 0
00084 | EUR | -3061.48 | -1910.28 | -2618.28 | -4609.79 | -3298.19 | -12149.43 | 287.13 | 3392.52 | 0 | 0 | 0 | 0
00084 | GBP | -402.37 | -186.01 | -565.88 | 284.22 | -1304.01 | -8246.44 | -75.21 | 130.56 | 0 | 0 | 0 | 0
00084 | NOK | 4.58 | -147.01 | 38.27 | -1.88 | 287.37 | -1226.71 | -127.04 | 1179.53 | 0 | 0 | 0 | 0
00084 | SEK | 10.29 | -98.3 | 1610.83 | 49.81 | -839.02 | -211.27 | 1728.6 | 0 | 0 | 0 | 0 | 0
00084 | USD | 0 | 0 | 0 | 0 | 0 | 0 | -308.84 | 0 | 0 | 0 | 0 | 0
00085 | GBP | 0 | 0 | -1297.2 | -2123.59 | -2927.06 | 4030.76 | 3973.41 | -7185.62 | 0 | 0 | 0 | 0
Spreadsheet: 267478d1380090986-problem-using-sumproduct-nafty
Sheet: Sheet1

Number of pages
19
 |  |  |  |  |  |  |  |  |  |  | Cost Schedule
 |  |  |  |  |  |  |  |  |  |  | Start | End | Rate
 |  |  |  |  |  |  |  |  |  |  | 0 | 19 | 1 |  | 1-19 pages would be charged at 1.75 per page
 |  |  |  |  |  |  |  |  |  |  | 20 | 50 | 1 |  | 20-50 pages would be charged at 1.45 per page
 |  |  |  |  |  |  |  |  |  |  | 51 | and over | 1 |  | 51 or more pages would be charged at 1.00 per page
 |  |  |  |  |  |  | Total
 |  |  |  |  | [NAME] used is   =SUMPRODUCT(--(A2>L$6:$L8),(A2-$L$6:$L$8), $N$6:$N$8)
 |  | In the above example when 19 is entered into the number of pages, the total cost calculate correctly as $19.00. [NAME] if 21 pages are entered the answer is given as $22.00, when it should be $21.00.
Spreadsheet: john_griffith__15722__Daily Settles
Sheet: Sheet1

Today's Settles
$5 Swaption on CY 02 |  | 0
Cal 02 |  | 2.915
$6 Calls on Q1 02 |  | .005 @ .015 | 3 delta
$5.25 Calls on Cal 02 |  | .065 @ .085 | 12 delta
Jan 02 3.50 Calls |  | .16 @ .18 | 33 delta
Dec 01 $2.25 Puts (Gas Daily) |  | .14 @ .16 | -24 delta
Dec 01 $3.50 Calls (Gas Daily) |  | .12 @ .14 | 26 delta
Spreadsheet: 42dfca6f-db15-4c23-b030-fba5c783d9e2
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TSI | Test | TSI | Thyroid-Stimulating Immunoglobulin (TSI), Serum | Thyroid-Stimulating Immunoglob, S | Recombinant Bioassay | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top  Acceptable: Serum gel  [NAME]: 0.5 mL | 0.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK <24 hrs - note to lab; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | < or =1.3 TSI index Reference values apply to all ages. | Monday through Friday; 10 a.m. | 2 days | 6 days | 1 | 84445 |  |  |  |  | Rochester
TSI | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TSI | Result | 8634 | Thyroid-Stimulating Immunoglob, S | Thyroid-Stimulating Immunoglob, S | Numeric |  |  |  |  | TSI index |  |  |  |  |  |  |  |  |  | 30567-2 | Thyroid stimulating immunoglobulins:ACnc:Pt:Ser:Qn:
Spreadsheet: 109443d1306300617-adding-like-values-sumif
Sheet: Sheet1

A | B | C | D
6 | 10 | 3 |  |  | CELL REF D2 SUMIF(A$2:A$11,C2,B$2:B$11)
6 | 10 | 4
6 | 10 | 5
4 | 10 | 6
5 | 10
3 | 10
6 | 10
5 | 10
3 | 10
6 | 10
Spreadsheet: 267008d1379908653-extract-specific-data-from-a-report-and-re-produce-cleaner-output-offset-for-svtf
Sheet: Sheet2

Agent ID | Calls Handled In | Avg Handle Time Total | Avg Wrap Time Total | Not Ready Time (Per Agent)
AC | 20 | 08:01 | 02:54 | 09:38
[NAME] | 14 | 15:41 | 03:26 | 23:59
JG | 17 | 11:30 | 02:22 | 08:12
AL | 28 | 09:37 | 03:14 | 08:13
CL | 21 | 10:15 | 02:39 | 22:07
MM | 18 | 10:52 | 01:45 | 07:08
LS | 22 | 13:07 | 03:14 | 07:24
Report Total: | 140 | 11:07 | 02:47
Agent ID | Calls Handled In | Avg Handle Time Total | Avg Wrap Time Total | Not Ready Time (Per Agent)
AC | 20 | 08:01 | 02:54 | 09:38
[NAME] | 14 | 15:41 | 03:26 | 23:59
JG | 17 | 11:30 | 02:22 | 08:12
AL | 28 | 09:37 | 03:14 | 08:13
CL | 21 | 10:15 | 02:39 | 22:07
MM | 18 | 10:52 | 01:45 | 07:08
LS | 22 | 13:07 | 03:14 | 07:24
Report Total: | 140 | 11:07 | 02:47
Spreadsheet: 875158d1721733205-display-name-not-code-from-a-cell-into-another-cell-room-inventory-template-new
Sheet: Plotting

Legend | Tables | Kills | Tables | Kills |  | Tables | Kills | Tables | Kills |  | Tables |  |  | Tables |  |  |  | Tables |  |  | Tables
None
Very Low | 1 |  | 17 |  |  | 33 |  | 49 |  |  | 1 |  |  | 17 |  |  |  | 33 |  |  | 49
Low
Medium | 2 |  | 18 |  |  | 34 |  | 50 |  |  | 2 |  |  | 18 |  |  |  | 34 |  |  | 50
High
Very High | 3 |  | 19 |  |  | 35 |  | 51 |  |  | 3 |  |  | 19 |  |  |  | 35 |  |  | 51
 | 4 |  | 20 |  |  | 36 |  | 52 |  |  | 4 |  |  | 20 |  |  |  | 36 |  |  | 52
 | 5 |  | 21 |  |  | 37 |  | 53 |  |  | 5 |  |  | 21 |  |  |  | 37 |  |  | 53
 | 6 |  | 22 |  |  | 38 |  | 54 |  |  | 6 |  |  | 22 |  |  |  | 38 |  |  | 54
 | 7 |  | 23 |  |  | 39 |  | 55 |  |  | 7 |  |  | 23 |  |  |  | 39 |  |  | 55
 | 8 |  | 24 |  |  | 40 |  | 56 |  |  | 8 |  |  | 24 |  |  |  | 40 |  |  | 56
 | 9 |  | 25 |  |  | 41 |  | 57 |  |  | 9 |  |  | 25 |  |  |  | 41 |  |  | 57
 | 10 |  | 26 |  |  | 42 |  | 58 |  |  | 10 |  |  | 26 |  |  |  | 42 |  |  | 58
 | 11 |  | 27 |  |  | 43 |  | 59 |  |  | 11 |  |  | 27 |  |  |  | 43 |  |  | 59
 | 12 |  | 28 |  |  | 44 |  | 60 |  |  | 12 |  |  | 28 |  |  |  | 44 |  |  | 60
 | 13 |  | 29 |  |  | 45 |  | 61 |  |  | 13 |  |  | 29 |  |  |  | 45 |  |  | 61
 | 14 |  | 30 |  |  | 46 |  | 62 |  |  | 14 |  |  | 30 |  |  |  | 46 |  |  | 62
 | 15 |  | 31 |  |  | 47 |  | 63 |  |  | 15 |  |  | 31 |  |  |  | 47 |  |  | 63
 | 16 |  | 32 |  |  | 48 |  | 64 |  |  | 16 |  |  | 32 |  |  |  | 48 |  |  | 64
Room | 17
13
Spreadsheet: 791270d1660231871-ar-forecast-formula-ar-forecast
Sheet: Sheet1

Customer | Job Name/Number | Total PO | Invoice 1 | date | [NAME] | Invoice 2 | date | [NAME] | Invoice 3 | date | [NAME] | Invoice 4 | date | [NAME]
ATT | CVL02147_Chrissman Rd (Tracy) | 484314.54 | 100000 | 2022-06-11 00:00:00 |  | 200000 | 2022-08-01 00:00:00 |  | 100000 | 2022-08-11 00:00:00
ATT | CVL06162_Mission Jacob | 725390
ATT | CVL06207_VanGuard | 8645.95
SMTL | 10150840_Prosperity [NAME] | 59430 | 30000 | 2022-07-11 00:00:00 |  | 29430 | 2022-07-30 00:00:00
Crown | CCL03716_Morgan Hill Sports Center | 599233
ATT | CCU03360_Alma Street Palo Alto Ave | 1099395
SMTL | CVL01347_Rockefeller | 44316
Crown | 123557_San Bruno City | 46900
Vz | 264599_Louis & Colorado | 287860
Vz | 392297_Sparks Highland | 336676
Terms | days
ATT | 5
Vz | 5
SMTL | 35
Crown | 50
Spreadsheet: 106751d1303938303-too-few-arguments-lookup
Sheet: Sheet1

 |  | Lookup Tables
 |  |  | Income | Tax rate |  | Lookup=D6:E9
 |  |  | 0 | 0.15
 |  |  | 10000 | 0.3
 |  |  | 30000 | 0.34
 |  |  | 100000 | 0.4 |  |  |  |  | Lookup2=H11:[NAME]
 |  |  |  |  |  |  | Product ID | Price
 |  |  |  | True | False |  | A134 | 3.5
 |  |  | Income | Rate |  |  | B242 | 4.2
 |  |  | -1000 |  |  |  | X212 | 4.8
 |  |  | 30000 |  |  |  | C413 | 5
 |  |  | 29000 |  |  |  | B2211 | 5.2
 |  |  | 98000
 |  |  | 104000 |  |  |  | ID | Price
 |  |  |  |  |  |  | B2211
 |  |  |  |  |  |  | B2211