tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50459d1249918219-i-want-to-calculate-a-result-only-if-a-cell-in-a-previous-worksheet-is-populated-holidays-2009-staff-test
Sheet: Staff & BI Scores 2008

2008 Absence (Periods and Days)
 |  | 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 |  | J | F | M | A | M | J | J | A | S | O | N | D |  | Total
A.N.Other |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  | 30 |  | 8 |  |  |  |  |  |  |  |  |  |  | 1 | 8 | 8
Spreadsheet: 809782d1671309729-how-to-change-cell-with-eur-xx-xx-in-a-currency-cell-import-data-fromweb
Sheet: Table 2

Column1 | Column2 | Column3
[NAME] | [NAME] | [NAME]
slotkoers16-12-2022 |  | EUR 115,79
Rendement 1 Dag |  | -0,57%
[NAME]™ |  | Obligaties [NAME]
Vestigingsland |  | Ierland
Volume |  | 9129
Beurs |  | EURONEXT AMSTERDAM
ISIN |  | IE00B3F81R35
Grootte Fonds (Mil)15-12-2022 |  | EUR 11200,45
[NAME] (Mil)15-12-2022 |  | EUR 9567,92
Lopende [NAME]2022 |  | 0,20%
*  Deze rating en het rapport zijn uitgegeven voor een andere fondsklasse van dit fonds. De rendementen, kostenstructuur en [NAME]. Mocht het rapport niet aanwezig [NAME] dit nog rapporten in de oude stijl, deze worden niet meer vertoont. Excuses voor het ongemak. | *  Deze rating en het rapport zijn uitgegeven voor een andere fondsklasse van dit fonds. De rendementen, kostenstructuur en [NAME]. Mocht het rapport niet aanwezig [NAME] dit nog rapporten in de oude stijl, deze worden niet meer vertoont. Excuses voor het ongemak. | *  Deze rating en het rapport zijn uitgegeven voor een andere fondsklasse van dit fonds. De rendementen, kostenstructuur en [NAME]. Mocht het rapport niet aanwezig [NAME] dit nog rapporten in de oude stijl, deze worden niet meer vertoont. Excuses voor het ongemak.
Spreadsheet: 70818d1271508970-conditional-formatting-book1
Sheet: Sheet1

April-2009 | May-2009 | June-2009 |  | July-2009 | August-2009 | September-2009 | October-2009 | November-2009 | December-2009 | [NAME] | February-2010 | March-2010 | April-2010 | Total | Weighted Average
7866.25 | 10986.51 | 770 |  | 4902.53 | 4196.25 | 15394.54 | 5611.51 |  | 8320 | 6533.52 | 14971.25 | 2418.75 |  | 81971.11 | 7451.919090909091
Spreadsheet: 68414d1268941121-summarize-data-from-multiple-worksheets-onto-one-master-equip-list
Sheet: CNC_Lathe

Mach# | Make | Model | Description | Install_Date | Today | Age |  | Age
11 | Hwacheon | [NAME] |  | 2005-01-01 00:00:00 | 2010-03-18 00:00:00 | 5 | years | 5 years
12 | Hwacheon | [NAME] |  | 2010-01-01 00:00:00 | 2010-03-18 00:00:00 | 2 | months | 2 months
13 | Hwacheon | [NAME] |  | 2009-01-01 00:00:00 | 2010-03-18 00:00:00 | 1 | years | 1 years
14 | Hwacheon | [NAME] |  | 2005-01-01 00:00:00 | 2010-03-18 00:00:00 | 5 | years | 5 years
15 | Hwacheon | [NAME] |  | 1997-01-01 00:00:00 | 2010-03-18 00:00:00 | 13 | years | 13 years
Spreadsheet: 886078d1736072722-nearest-value-formula-need-nearest-value-formula-need
Sheet: Sheet1

 | 23930
 |  | 23900 |  |  |  | BAT:BATCH09JAN25C23900
 |  | 23950 |  |  |  | BAT:BATCH09JAN25C23950
 |  | 24000 |  |  |  | BAT:BATCH09JAN25C24000
 |  | 24050 |  |  |  | BAT:BATCH09JAN25C24050
 |  | 24100 |  |  |  | BAT:BATCH09JAN25C24100
 |  | 24150 |  |  |  | BAT:BATCH09JAN25C24150
 |  | 24200 |  |  |  | BAT:BATCH09JAN25C24200
 |  | 24250 |  |  |  | BAT:BATCH09JAN25C24250
 |  | 24300 |  |  |  | BAT:BATCH09JAN25C24300
 |  | 24350 |  |  |  | BAT:BATCH09JAN25C24350
 |  | 24400 |  |  |  | BAT:BATCH09JAN25C24400
 |  | 24450 |  |  |  | BAT:BATCH09JAN25C24450
 |  | 24500 |  |  |  | BAT:BATCH09JAN25C24500
 |  | 24550 |  |  |  | BAT:BATCH09JAN25C24550
 |  | 24600 |  |  |  | BAT:BATCH09JAN25C24600
 |  | 24650 |  |  |  | BAT:[NAME]
 |  | 24700 |  |  |  | BAT:BATCH09JAN25C24700
 |  | 24750 |  |  |  | BAT:BATCH09JAN25C24750
 |  | 24800 |  |  |  | BAT:BATCH09JAN25C24800
 |  | 24850 |  |  |  | BAT:BATCH09JAN25C24850
 |  | 24900 |  |  |  | BAT:BATCH09JAN25C24900
 |  | 24950 |  |  |  | BAT:BATCH09JAN25C24950
 |  |  | FORMULA |  |  | BAT:BATCH09JAN25C24000 | FORMULA REQUIRED
 |  |  | FORMULA |  |  | BAT:BATCH09JAN25C24050 | FORMULA REQUIRED
Spreadsheet: 11c89d6b-5e48-417a-b586-2d6d111b505d
Sheet: Capstone

CAPSTONE CAR
Course color corresponds with term of offering. RED for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term.
Art Management | AMGT 441
Archaelogy | ARCH 450 |  | cross listed with CLAS 450
 | ARCH 495
[NAME] | ARTH 422
 | ARTH 450
Asian Studies | ASTU 401
Biology | BIOL 400
 | BIOL 487-488
 | BIOL 496-498
 | BIOL 499
Chemistry | CHEM 400
 | CHEM 401
 | CHEM 442L
 | CHEM 495
 | CHEM 496-498
Classical Studies | CLAS 401
 | CLAS 450 |  | cross listed with ARCH 450
Communication Studies | COMM 381 |  | Spring 2011 only
 | COMM 490
Computer Science | CSCI 401
 | [NAME]
 | CSCI 485-486
Drama | DRAM 422
Economics/Business | ECON 440 |  | Economics & Economics/Business majors
 | ECON 450-451 |  | Economics; Econ/Business & Accounting majors
 | ECON 455 |  | Economics; Econ/Business & Accounting majors
 | ECON 491-492 |  | Economics; Economics/Business majors
 | ECON 496-498 |  | Economics; Economics/Business majors
 | BUSN 425 |  | Accounting; Economics/Business majors
 | BUSN 450-451 |  | Accounting; Economics/Business majors
 | BUSN 452 |  | Accounting; Economics/Business majors
 | BUSN 455 |  | Accounting; Economics/Business majors
 | BUSN 491-492 |  | Accounting; Economics/Business majors
 | BUSN 496-498 |  | Accounting; Economics/Business majors
Education | EDUC 426
English | ENGL 495
Engineering Physics
 | EPHY 450
Environmental Studies | EVST 405
French | FREN 435
 | FREN 437
 | FREN 443
 | FREN 445
 | FREN 447
 | FREN 448
 | FREN 449
 | FREN 472
 | FREN 495
German | GERM 495
History | HIST 401
International Studies | INST 422
 | INST 448-449
 | INST 452-453
 | INST 483-484
 | INST 493-494
 | INST 496-498
Mathematics | MATH 415
Music | MUSC 422
Philosophy | PHIL 401
Physics | PHYS 450
 | PHYS 496-498
 | PHYS 499
Political Science | PSCI 401
Psychology | PSYC 433
Religious Studies | RELS 401
Sociology | SOCI 400
 | SOCI 410
 | SOCI 420
 | SOCI 430
 | SOCI 440
 | SOCI 460
 | SOCI 496-498
Spanish | SPAN 452
 | SPAN 435
 | SPAN 453
 | SPAN 456
 | SPAN 458
 | SPAN 462
 | SPAN 464
 | SPAN 467
 | SPAN 495
Studio Art | STAR 422
Women's Studies | WMST 300 & 301
 | WMST 300 & 450
 | WMST 300 & 455
Spreadsheet: 850888d1701197808-need-to-have-7-different-formulas-in-the-same-cell-all-with-different-outcomes-problem-etaf
Sheet: Sheet1

ID | Ordered By | Code | Added Cost | Weight | [NAME] | Aisle | Row | Price/lb | Income From Sale | Cost 1 | Total Cost | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  | (h14/2)+k3 | H14+K3 | h14/2 | h14 | blank
2 | [NAME] | K.5 |  | 341 | [NAME] | 1 | 4 |  |  |  | 1099.39 |  |  |  |  |  |  | A3=""
3 | [NAME] | K1 |  | 341 | [NAME] | 2 | 7 |  |  |  | 2198.78
5 | [NAME] | K.5 | 1 | 777 | [NAME] | 1 | 12 |  |  | 807.22 | 1906.61
6 | Dwayne | K1 | 1 | 409 | [NAME] | 2 | 38 |  |  | 336.52 | 2535.3
7 | Adam | S.5 | 1 | 409 | [NAME] | 1 | 55 |  |  | 336.52 | 1435.91
44 | [NAME] | S1 | 1 | 801 | [NAME] | 1 | 10 |  |  | 825.23 | 3024.1
 |  |  |  |  |  | Cost of unit | 2198.775890077821 | Selling Price | 5.5
I need a formula that will have 7 options and 7 different outcomes. I need to have in [NAME] (L3) a formula that will look at column (C) and match the Code and Added Cost and give me a value. So if (C3) shows "K.5" and (D3) shows Blank then it will calculate (H14)/2. Or if (C3) shows "K1" and (D3) Shows Blank then it will return (H14). Or if (C3) shows "K.5" and (D3) shows 1 then it will calculate (H14)/2+(K3). Or if (C3) shows "K1" and (D3) shows 1 then it will calculate (H14)+(K3). Or if (C3) shows "S.5" and (D3) shows 1 it will calculate (H14)/2+(K3). Or if (C3) shows "S1" and (D3) shows 1 then it will calculate (H14)+(K3). And to top it all off if (A3) is Blank then leave (L3) Blank
 | c3 | d3
 | k.5 |  | h14/2
 | k1 |  | h14
 | k.5 | 1 | (h14/2)+k3 | *
 | k1 | 1 | h14+k3 | 1
 | s.5 | 1 | (h14/2)+k3 | *
 | S1 | 1 | h14+k3 | 1
A3 blank
Spreadsheet: vladi_pimenov__41079__DailyPrices
Sheet: Variable Rates

 |  |  |  |  |  | San Juan | Permian
Pipline | Receipt | Alt. Receipt | Volume | Delivery | Alt. Delivery | Volume | Variable | Fuel | Comm | GRI | ACA | Notes
Transwestern | [NAME] | Any | 40000 | [NAME] | Any | 25000 |  | 0.0156 | 0 | 0 | 0
 |  |  |  | [NAME] | Any | 15000 |  | 0.0156 | 0 | 0 | 0
 | West Texas | None | 8000 | [NAME] | Any EOT | 8000 |  | 0.0131 | 0 | 0 | 0
 | [NAME] | Any La Plata | 25000 | [NAME] | TW SJ Pool | 25000 |  | 0.0025 | 0 | 0 | 0
 | [NAME] | Any La Plata | 12500 | [NAME] | TW SJ Pool | 12500 |  | 0.0025 | 0.06 | 0 | 0
 | SJ Pool | None | 25000 | Thoreau | None | 25000 |  | 0.0025 | 0.0011 | 0 | 0
 | Thoreau | None | 25000 | Citizens | None | 25000 |  | 0.045 | 0.0153 | 0.0072 | 0.0022
El Paso | SJ | None | 16495 | Ivalero | None | 16495 |  | 0.0388 | 0.0031 | 0 | 0.0022 | Havasu
 | Perm | None |  | Ivalero |  |  |  | 0.0158 | 0.0058 | 0 | 0.0022
 | SJ |  | 80000 | Topock (except SWG) |  | 80000 |  | 0.0388 | 0.0166 | 0.0072 | 0.0022
 | Perm |  |  |  |  |  |  | 0.0388 | 0.0341 | 0.0072 | 0.0022
 | Anadarko |  |  |  |  |  |  | 0.0388 | 0.0383 | 0.0072 | 0.0022
 | SJ |  | 20000 | [NAME] |  | 20000 |  | 0.0388 | 0.0166 | 0.0072 | 0.0022
 | Perm |  |  |  |  |  |  | 0.0388 | 0.0341 | 0.0072 | 0.0022
 | Anadarko |  |  |  |  |  |  | 0.0388 | 0.0383 | 0.0072 | 0.0022
 | None | SJ | 467513 | All Topock Deliveries |  | 467513 |  | 0.0388 | 0.0166 | 0 | 0.0022 | Block 1
 |  | Perm |  | Socal [NAME] |  |  |  | 0.0388 | 0.0341 | 0 | 0.0022
 |  | Anadarko |  |  |  |  |  | 0.0388 | 0.0383 | 0 | 0.0022
 |  |  |  |  | Plains |  |  | 0 | 0.04 | 0 | 0
 |  |  |  |  | Felmac (Westar Storage) |  |  | 0.0158 | 0.04 | 0 | 0
 |  |  |  |  | Oasis |  |  | 0.0158 | 0.04 | 0 | 0
 |  |  |  |  | Westar |  |  | 0.0158 | 0.04 | 0 | 0
 |  |  |  |  | Valero |  |  | 0.0158 | 0.04 | 0 | 0
 |  |  |  |  | Delhi |  |  | 0.0158 | 0.04 | 0 | 0
 |  |  |  |  | Lonestar |  |  | 0.0158 | 0.04 | 0 | 0
 |  |  |  |  | Window Rock |  |  | 0.0388 | 0.04 | 0 | 0
 |  |  |  |  | Icanute - TexOK |  |  | 0.0158 | 0.06 | 0 | 0
 |  |  |  |  | NGPL Washita #7 |  |  | 0.0158 | 0.06 | 0 | 0 | Perm to
 |  |  |  |  | NGPL Moore |  |  | 0.0158 | 0.06 | 0 | 0 | Midcon
 |  |  |  |  | [NAME] |  |  | 0.0158 | 0.06 | 0 | 0
 |  |  |  |  | IHUECO - Pemex |  |  | 0.0388 | 0.14 | 0 | 0
 | SJ | None | 593122 | Socal Topock |  |  |  | 0.0388 | 0.0166 | 0 | 0.0022
 | Perm |  |  | PG&E Topock |  |  |  | 0.0388 | 0.0341 | 0 | 0.0022
 | Anadarko |  |  | Mojave Topock |  |  |  | 0.0388 | 0.0383 | 0 | 0.0022
 | SJ | None | 193454 | Socal Topock |  |  |  | 0.0388 | 0.0166 | 0 | 0.0022
 | Perm |  |  | PG&E Topock |  |  |  | 0.0388 | 0.0341 | 0 | 0.0022
 | Anadarko |  |  | Mojave Topock |  |  |  | 0.0388 | 0.0383 | 0 | 0.0022
Spreadsheet: 51948d1251552602-excel-2007-connecting-empty-cells-and-adding-a-trendline-no-longer-possible-in-2007-697603
Sheet: Sheet1

 | Y1 | Y2
1 | 1 | 2
2 | 1 | 3
3 |  | 4
4 |  | 5
5 |  | 8
6
7 | 5
8 | 7 | 25
9 | 8 | 40
Spreadsheet: 719310d1613613068-possible-indirect-function-needed-or-any-feasible-method-indirect-function-help
Sheet: 46547-20241100041

Client ID | Client Name | Account | Name | Group Name | Invoice No | Description Total | Charge Type | Random | Random | Random | Random | Random | Random | Random | Random | Random | CCY | Invoice Charge
46547 | Example | 666457 | Example |  | 20241100041 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | AUD | 1324.5
46547 | Example | 746546 | Example |  | 20241100041 | Surcharges |  |  |  |  |  |  |  |  |  |  | AUD | 12.56
46547 | Example | 666458 | Example |  | 20241100041 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | AUD | 31316.46
46547 | Example | 744976 | Example |  | 20241100041 | Other Fees |  |  |  |  |  |  |  |  |  |  | AUD | 9.55
46547 | Example | 666459 | Example |  | 20241100041 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | AUD | 61308.42
46547 | Example | 446798 | Example |  | 20241100041 | Valuations Fee |  |  |  |  |  |  |  |  |  |  | AUD | 4.55
46547 | Example | 666460 | Example |  | 20241100041 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | USD | 91300.38
Spreadsheet: 059271e1-22b9-477c-a9eb-937026cd90f8
Sheet: Sheet1

Informacion mbi rezultatet e ankandeve te bonove te thesarit -  Information on the results of the treasury bills auction | 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
(ne mije leke/ in 000'ALL) | (ne mije leke/ in 000'ALL)
[NAME] | Treasury bills | 27.03.2012 |  | 13.03.2012 |  | 28.02.2012 |  | 14.02.2012 |  | 31.01.2012 |  | 10.01.2012
 |  | 3/m | 12/m | 6/m | 12/m | 3/m | 12/m | 6/m | 12/m | 3/m | 12/m | 6/m | 12/m
Date Emetimi | Settlement Date | 29.03.2012 | 29.03.2012 | 15.03.2012 | 15.03.2012 | 01.03.2012 | 01.03.2012 | 16.02.2012 | 16.02.2012 | 02.02.2012 | 02.02.2012 | 12.01.2012 | 12.01.2012
Date Maturimi | Maturity date | 28.06.2012 | 28.03.2013 | 13.09.2012 | 14.03.2013 | 31.05.2012 | 28.02.2013 | 16.08.2012 | 14.02.2013 | 03.05.2012 | 31.01.2013 | 12.07.2012 | 10.01.2013
Shuma e shpallur (fillestare) | Ammount offered (initial) | 3700000 | 9600000 | 4700000 | 9600000 | 4300000 | 11000000 | 4600000 | 11800000 | 3500000 | 12300000 | 16900000 | 10600000
Shuma e shpallur (ndryshim strukture) | Ammount offered (structure's changes) | 3221250 | 10078950 | 4237070 | 10062930 |  |  | 4543050 | 11856950 | 3795320 | 11861290
Shuma e kerkuar | Ammount requested | 3221250 | 11012780 | 4237070 | 12371710 | 3422830 | 10003590 | 4543050 | 11926130 | 3795320 | 11861290 | 17223550 | 10722500
Shuma e pranuar | Ammount accepted | 3221250 | 10078950 | 4237070 | 10062930 | 3422830 | 10003590 | 4543050 | 11856950 | 3795320 | 11861290 | 16900000 | 10522500
Prorata Konkuruese | Competitive pro-rate | 1 | 0.9978 | 1 | 0.314 | 1 | 1 | 1 | 0.3082 | 1 | 1 | 0.2548 | 1
[NAME] | Non competitive prorate | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Yieldi Mesatar I Ponderuar | Wieghted average yield | 0.0530298246 | 0.0732968939 | 0.0609889423 | 0.0734010376 | 0.0527094972 | 0.0732265471 | 0.0609889423 | 0.0720520963 | 0.0508 | 0.0701 | 0.0623 | 0.0711
Yieldi Maksimal I Kerkuar | Maximum requested yield | 0.0534 | 0.075 | 0.063 | 0.075 | 0.0535 | 0.0742 | 0.0629 | 0.0739 | 0.0535 | 0.0729 | 0.0633 | 0.0745
Yieldi Maksimal I Pranuar | Maximum accepted yield | 0.0534 | 0.0739 | 0.063 | 0.0741 | 0.0535 | 0.0742 | 0.0629 | 0.0739 | 0.0535 | 0.0729 | 0.063 | 0.0731
[NAME] | Minimum yield | 0.0527 | 0.072 | 0.0609 | 0.072 | 0.0507 | 0.071 | 0.0607 | 0.0683 | 0.05 | 0.0655 | 0.061 | 0.0655
Spreadsheet: 725225d1616593749-help-on-data-lookup-example-2
Sheet: REPORT

Report
Employee ID | Surname | Firstname | Sunday | 80% Furlough Pay | Average Working Hours | Back Pay | Car Allowance | Company Car BIK | [NAME] | Furlough Top Up | Holiday Pay | Holiday Trade Allowance | Medical BIK | Overtime 1 | Overtime Special | Relief Driver Allowance | Risk Assessor | Salary | Savings scheme payout | [NAME] | Unpaid Time Off
48 |  | Employee
Spreadsheet: 072799b0-6577-4f00-bb02-d40825262259
Sheet: SUM-Home

Summary Exhibit |  |  | SUM-Home
Insurance Company: | Insert Company Name
Effective Date: | MM/DD/YYYY
Form | Earned Premium or Earned Exposures | Indicated Change | Proposed Change
(Add/Delete rows as needed)
F 1
F 2
F 3
etc
Overall Total
Insurer Notes:
Notes:
1.  The Form Indicated Change value should balance to the Form Credibility Weighted Indicated Change value in RLI-Home Exhibit
2. The Form Proposed Change value should balance to the Form Overall Change value in OB-Home Exhibit
Spreadsheet: 752601d1634846198-find-matching-value-and-get-the-index-within-substring-lookup-examples
Sheet: Source

TableName | Mapped Values | ExpectedResult |  | LookUpValues
Table1 | Dog;Cat;;;Dog | 1;2;5 |  | Dog |  |  | Cat |  |  | Dog
Table1 | Dog;;;;;; | 1;2;5 |  | [NAME] |  | Dog
Table1 | default;default;default | 1;2;5 |  |  |  | default | default | default
Table2 | [NAME] | 1;7 |  |  |  | [NAME]
Table2 | Vn_Input;Vn_Input;Vn_Input;Vn_Input;Vn_Input;;Mouse | 1;7 |  |  |  | Vn_Input | Vn_Input | Vn_Input | Vn_Input | Vn_Input |  | [NAME]
Table2 | Curious;;;;;; | 1;7 |  |  |  | Curious
 |  |  |  |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 5
Spreadsheet: 153972d1336136756-somewhat-complex-document-problems-extracting-and-organizing-data-from-cells-6maxhyper
Sheet: Sheet1

 | Players | [NAME] | Seat 1 | Seat 2 | Seat 3 | Seat 4 | Seat 5 | Seat 6 |  | Seat 1 | Seat 2 | Seat 3 | Seat 4 | Seat 5 | Seat 6 |  | If there are 6 players and seat #1 has button, seat #2 will have SB, seat #3 BB, #4 UTG, #5 MP and #6 will have CO.
 | 6 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If #2 has button then #3 has SB, #4 BB, #5 UTG, #6 MP and #1 CO and so on. If there are 5 players then there is no MP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and if there are 4 players there is no MP and no UTG. If there are only 3 players (the minimum) then there is only
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BU, SB and BB.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | BU | SB | BB | UTG | MP | CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | BU | SB | BB | UTG | CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | BU | SB | BB | CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | BU | SB | BB
 |  |  |  |  |  |  |  |  |  | UTG | MP | CO | BU | SB | BB
Spreadsheet: 80922d1281137447-find-combo-of-numbers-for-a-specific-value-book2
Sheet: Sheet1

2010-07-29 00:00:00 |  |  | [NAME]
 | [NAME] | 2x4 | 2x6 | 2x8 | 2x10 | 2x12
Length
8 | Packs | 13 | 8 | 0 | 0 | 0
10 | Packs | 10 | 7 | 4 | 13 | 22
12 | Packs | 9 | 12 | 0 | 7 | 0
14 | Packs | 5 | 15 | 7 | 0 | 5
16 | Packs | 4 | 15 | 9 | 3 | 7
18 | Packs | 3 | 17 | 9 | 0 | 0
20 | Packs | 3 | 24 | 3 | 4 | 5
22 | Packs | 0 | 38 | 1 | 0 | 0
24 | Packs | 10 | 16 | 17 | 9 | 11
Total Board Feet |  | 89539 | 325346 | 129529 | 59955 | 73812
NOTE | *Need at least 6 packs in inventory or another length must be used
 | *Can't mix and match ie 2x4 plus 2x6's. Must be one or the other
 |  | Recent 2x6 Charges |  | 96' is the perferred length
20 | 20 | 22 | 22 | 24 | 12 | 8
16 | 18 | 22 | 22 | 24 | 14 | 22
14 | 16 | 22 | 22 | 24 | 14 | 22
14 | 16 | 22 | 20 | 24 | 16 | 22
12 | 14 | 8 | 10 |  | 16 | 24
12 | 12 |  |  |  | 24
8
96 | 96 | 96 | 96 | 96 | 96 | 98
Spreadsheet: 132392d1323726126-running-total-including-null-values-null-example
Sheet: Sheet1

A1 = Total Charge | B1 = First Allowance (Manual entry) | C1 = Second Allowance (Manual entry) | D1 = Third Allowance (Manual  entry)
 | B2 = First Savings (A1 - B1) | C2 = 2nd Savings (If C1 = Null  then B1 - B1) | D2 = 3rd Savings (IF B1 and/C1 = Null then use value from A1 or last Line 1 value > 0
All Numbers have a value
500 | 300 | 250 | 100 | 1
 | 200
Null Examples
500 | NULL | 250 | 250 | 2
 |  | 250 | 250
500 | NULL | NULL | 400 | 3
500 | 300 | NULL | 250 | 4
 | 200 |  | 50
Example 1 500 - 300 = 200. 300 - 250 = 50 and 250 - 100 = 150. Total savings = 200 + 50 + 150 = 400.  [NAME] to maintain value when there is no entry for B1 but entry for C1 and D1. Logic 500 - 250 = 250 where C1 knows to start with a value = 500 from A1 not Null  Examples 3 - 4 are simply other Null examples using starting subtotals not = Total Charge
Spreadsheet: 221104d1363367066-match-data-across-multiple-worksheets-fill-new-column-with-exsisting-information-solution
Sheet: Sheet1

State | County | Sales
OH | ADAMS | 156.31
WI | ADAMS | 1169.28
IN | ADAMS | 1150.71
IL | ADAMS | 28.9
IL | ALEX | 12.95
MI | ALLEGAN | 734.77
OH | ALLEN | 1851.7
IN | ALLEN | 7577.15
MI | ALPENA | 2631.21
MI | ANTRIM | 468.93
OH | [NAME] | 862.4
WI | [NAME] | 161.7
Spreadsheet: 47071d1245964558-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: GNH - CS-SPD PACKS (#1)

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS-SPD PACKS (1)
FACILITY: | GREY NUNS HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X
** If more/less linen required please fax in this order by 7:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
G-LAPAROTOMY |  |  |  | CP0033 |  | 10
UG-SM SPLIT PACK |  |  |  | CP0027 |  | 1
UG-BASIC PACK |  |  |  | CP0028 |  | 5
UG-LITHOTOMY PACK |  |  |  | CP0020 |  | 10
UG- CHEST/BREAST PACK |  |  |  | CP0019 |  | 10
VASCULAR PACK |  |  |  | CP0015 |  | 6
LITHO GENERAL SURG |  |  |  | CP0016 |  | 4
LG TABLE COVER |  |  |  | SP0037 |  | 35
2-LEGGINGS |  |  |  | SP0002 |  | 3
MAYO COVER |  |  |  | SP0003 |  | 20
SM SPLIT DRAPE |  |  |  | SP0009 |  | 1
LAP DRAPE |  |  |  | SP0018 |  | 2
CHEST/BREAST DRAPE |  |  |  | SP0035 |  | 3
LG SPLIT DRAPE |  |  |  | SP0010 |  | 10
HALF SHEET |  |  |  | SP0015 |  | 25
3/4 SHEET |  |  |  | SP0020 |  | 20
FULL SHEET |  |  |  | SP0021 |  | 1
MED BARRIER |  |  |  | SP0016 |  | 8
TABLE COVER |  |  |  | SP0019 |  | 10
2-HUCK TOWEL |  |  |  | SP0081 |  | 40
1-HUCK TOWEL |  |  |  | SP0080 |  | 40
UPDATED:
June 17th 2009
Spreadsheet: 263854d1378706068-rotating-overtime-schedule-help-move-rows
Sheet: Sheet1

# | Shift A/B | Phone # | Select Employee # | # | Shift A/B | Phone #
1 | employee name 1 | 123456 | 9
2 | employee name 2 | 123457
3 | employee name 3 | 123458
4 | employee name 4 | 123459
5 | employee name 5 | 123460
6 | employee name 6 | 123461
7 | employee name 7 | 123462
8 | employee name 8 | 123463
9 | employee name 9 | 123464
10 | employee name 10 | 123465
 | Shift C/D
 | employee name 1 | phone #
 | employee name 2 | phone #
 | employee name 3 | phone #
 | employee name 4 | phone #
 | employee name 5 | phone #
 | employee name 6 | phone #
 | employee name 7 | phone #
 | employee name 8 | phone #
 | employee name 9 | phone #
 | employee name 10 | phone #
Spreadsheet: 720404d1614142400-find-a-price-from-mulitple-sheets-based-on-item-type-width-and-height-sample
Sheet: TH

 | 24 | 28 | 32 | 36 | 40 | 44
24 | 200 | 204 | 208 | 212 | 216 | 220
28 | 205 | 209 | 213 | 217 | 221 | 225
32 | 210 | 214 | 218 | 222 | 226 | 230
36 | 215 | 219 | 223 | 227 | 231 | 235
40 | 220 | 224 | 228 | 232 | 236 | 240
44 | 225 | 229 | 233 | 237 | 241 | 245
Spreadsheet: 852297d1702385923-my-index-and-match-formula-is-returning-duplicate-entries-sample
Sheet: Names

Person | Include
Jon
[NAME]
[NAME]
[NAME]
[NAME]
Aspen
George
Mark
Pauline
Sandra
Ella
Allayna
Savannah
anne
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Alexandra
Hugo
Graeme
Thwaite
[NAME]
[NAME]
Ptriam
Myers
Spreadsheet: 729238d1618973856-creating-a-new-permit-register-permit-register-example-2
Sheet: BP

ABC Job Number | Address | Description | Client | Date of Confirmation  to Proceed | Permit  Number
 | Address 1 | Description 1 | Client 1 | 2021-03-05 00:00:00 | 123/123/123
ABC-21005 | Address 5 | Description 5 | Client 5 | 2021-04-10 00:00:00 | 456/456/456
ABC-21010 | Address 10 | Description 10 | Client 10 | 2021-04-15 00:00:00 | 789/789/789