tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 874183d1720743743-using-index-to-create-a-dynamic-drop-down-list-example-index-problem-tms
Sheet: Sheet4

[NAME] | Balconero | Carpintero | Electricista |  |  | Balconero | Carpintero | Electricista
[NAME] | Elaboracion de Barandales | Desinstalacion | Desinstalacion
[NAME] | Elaboracion de Estructuras | Detalles | Instalaciones
 | Elaboracion de Lubers | Elaboracion de Puertas | Reparaciones
 | Elaboracion de Pergolas | Instalacion
Spreadsheet: 752441d1634754619-averageifs-with-condition-not-to-include-cells-with-letter-2021-10-20c-culling-analysis-test-not-contain-x
Sheet: Fem

Tg | Yr | Age | Sx | CS | F | MB | MO | G | C%Calc | P1 | P2 | PT | BD
Done: | 2021 |  | Oct | 20
Tag | Year | Age | Sex | Calf | Sex | Num Hd | TOT HD | Tot Poss | % Calc | PubTrg1 | PubTrg2b | TOT PUB | Baby DOB
 |  |  |  | F | M | U | T | P
711y | 2007 |  | f | 3 | 7 | 2 |  |  |  |  |  |  | 3
714y | 2007 |  | f | 8 | 4 | 2 |  |  |  |  |  |  | 3
801y | 2008 |  | f | 5 | 6 | 0 |  |  |  |  |  |  | 4
905y | 2009 |  | f | 5 | 4 | 1 |  |  |  |  |  |  | 2
022y | 2010 |  | f | 4 | 4 | 1 |  |  |  |  |  |  | 0
146y | 2011 |  | f | 4 | 4 | 0 |  |  |  |  | 3 |  | 2
202y | 2012 |  | f | 0 | 6 | 1 |  |  |  | 3 | 3 |  | X
303y | 2013 |  | f | 2 | 2 | 1 |  |  |  | 3 | 3 |  | 1
308y | 2013 |  | f | 3 | 1 | 1 |  |  |  | 3 | -1 |  | 1
310y | 2013 |  | f | 3 | 2 | 1 |  |  |  | 3 | 3 |  | 1
408y | 2014 |  | f | 0 | 4 | 1 |  |  |  | 3 | 1 |  | 2
409y | 2014 |  | f | 4 | 1 | 0 |  |  |  | 3 | 3 |  | 2
620b | 2016 |  | f | 1 | 1 | 1 |  |  |  | 3 | 3 |  | 1
621b | 2016 |  | f | 1 | 1 | 1 |  |  |  | 3 | 0 |  | 2
726b | 2017 |  | f | 2 | 0 | 0 |  |  |  | 3 | 1 |  | 3
727b | 2017 |  | f | 1 | 1 | 0 |  |  |  | 3 | 3 |  | 2
[NAME] | 2018 |  | f | 0 | 1 | 0 |  |  |  | 3 | 3 |  | 3
821b | 2018 |  | f | 1 | 0 | 0 |  |  |  | 3 | 1 |  | 2
822b | 2018 |  | f | 0 | 0 | 0 |  |  |  | 3 | 3 |  | 2
933b | 2019 |  | f |  |  |  |  |  |  | 3 | 3 |  | X
934b | 2019 |  | f |  |  |  |  |  |  | 3 | 3 |  | X
937b | 2019 |  | f |  |  |  |  |  |  | 3 | 3 |  | X
001w | 2020 |  | f |  |  |  |  |  |  | 3 |  |  | -1
003w | 2020 |  | f |  |  |  |  |  |  | 3 |  |  | 3
160w | 2021 |  | f |  |  |  |  |  |  |  |  |  | 1
[NAME] | 2021 |  | f |  |  |  |  |  |  |  |  |  | -3
162w | 2021 |  | f |  |  |  |  |  |  |  |  |  | 2
AVGS
Mat | A/#
4yo
3yo
2yo
1yo
0yo
TOTAL
Spreadsheet: 145822d1331754217-pivot-tables-combining-data-from-multiple-columns-excel-2003-combining-data_pt_jpr73
Sheet: Table

# | Classification | Type
1 | Classification 1 | Type A
1 | Classification 2 | Type B
2 | Classification 1 | Type B
2 | Classification 2 | Type C
3 | Classification 1 | Type D
3 | Classification 2
4 | Classification 1 | Type B
4 | Classification 2 | Type C
5 | Classification 1 | Type C
5 | Classification 2
6 | Classification 1 | Type C
6 | Classification 2
7 | Classification 1 | Type B
7 | Classification 2
8 | Classification 1 | Type B
8 | Classification 2 | Type D
9 | Classification 1 | Type A
9 | Classification 2 | Type C
Spreadsheet: 683513d1592804274-adding-indirect-function-to-an-existing-if-statement-sample-file_indirect-lookup
Sheet: Draft Selections

 |  |  |  | 2020 Draft Selections
 | Round | Pick | Live Ladder | Pick Owner | Source | Pick Owner (look up) | Future Pick? | Trade #
 | 1 | #1 | [NAME] Pigskins | [NAME] Pigskins | Default Selection | [NAME] Pigskins | 0
 | 1 | #2 | Gobzilla | BeePee Bandits | TRADED | BeePee Bandits | 0 | 1
 | 1 | #3 | Angry Beavers | Angry Beavers | Default Selection | Angry Beavers | 0
 | 1 | #4 | Commentators Curse | Commentators Curse | Default Selection | Commentators Curse | 0
 | 1 | #5 | [NAME] | [NAME] | Default Selection | [NAME] | 0
 | 1 | #6 | [NAME]'s Swansons | TAGS Superstars | TRADED | TAGS Superstars | 0
 | 1 | #7 | BeePee Bandits | BeePee Bandits | Default Selection | BeePee Bandits | 0
 | 1 | #8 | iwashwindows | iwashwindows | Default Selection | iwashwindows | 0
 | 1 | #9 | TAGS Superstars | TAGS Superstars | Default Selection | TAGS Superstars | 0
 | 1 | #10 | Red White & Black | Red White & Black | Default Selection | Red White & Black | 0
 | 2 | #11 | [NAME] Pigskins | [NAME] Pigskins | Default Selection | [NAME] Pigskins | 0
 | 2 | #12 | Gobzilla | BeePee Bandits | TRADED | BeePee Bandits | 0 | 8
 | 2 | #13 | Angry Beavers | Angry Beavers | Default Selection | Angry Beavers | 0
 | 2 | #14 | Commentators Curse | Commentators Curse | Default Selection | Commentators Curse | 0
 | 2 | #15 | [NAME] | [NAME] | Default Selection | [NAME] | 0
 | 2 | #16 | [NAME]'s Swansons | [NAME]'s Swansons | Default Selection | [NAME]'s Swansons | 0
 | 2 | #17 | BeePee Bandits | BeePee Bandits | Default Selection | BeePee Bandits | 0
 | 2 | #18 | iwashwindows | iwashwindows | Default Selection | iwashwindows | 0
 | 2 | #19 | TAGS Superstars | TAGS Superstars | Default Selection | TAGS Superstars | 0
 | 2 | #20 | Red White & Black | BeePee Bandits | TRADED | BeePee Bandits | 0
Spreadsheet: 749219d1632600096-using-multiple-lookups-across-multiple-worksheets-cost-sheet-mock-up
Sheet: 302

302
Diameter |  | Weight (in lbs)
From | To | 10 | 20 | 30 | 40 | 50
From | To | 10-19 | 20-29 | 30-39 | 40-49 | 50-59 | Min Production Qty
0.1 | 0.199 | 1.75 | 1.85 | 1.95 | 2.05 | 2.15 | 100
0.2 | 0.299 | 1.8 | 1.9 | 2 | 2.1 | 2.2 | 150
0.3 | 0.399 | 1.85 | 1.95 | 2.05 | 2.149999999999999 | 2.25 | 200
0.4 | 0.499 | 1.9 | 2 | 2.1 | 2.199999999999999 | 2.299999999999999 | 250
Spreadsheet: 774167d1648254441-calculating-due-installment-dates-based-on-duration-number-of-instalments-qoutation-creator-sample
Sheet: Wizard

 |  |  |  |  |  |  |  |  | contract renew
 |  |  |  |  |  |  |  | Building Name | OBY20 | اسم المبنى
 |  |  |  |  |  |  |  | unit number | 1003 | [NAME]
 |  |  |  |  |  |  |  | unit type |  | نوع الوحده
 |  |  |  |  |  |  |  | contract type |  | نوع العقد
 |  |  |  |  |  |  |  | Contract Start | 2021-01-06 00:00:00 | [NAME]
 |  |  |  |  |  |  |  | Contract Expiry | 2021-09-22 00:00:00 | انتهاء العقد
 |  |  |  |  |  |  |  | Contract value | 46000 | [NAME]
 |  |  |  |  |  |  |  | Security deposit |  | التأمين
 |  |  |  |  |  |  |  | Payments | 3 | الدفعات
 |  |  |  |  |  |  |  | VAT payment | in advance مقدما | [NAME]
 |  |  |  |  |  |  |  | payment method | cheque | طريقه الدفع
 |  |  |  |  |  |  |  | tenant name |  | اسم المستأجر
 |  |  |  |  |  |  |  |  | Get qoutation
Spreadsheet: 90838d1290550061-how-to-average-using-vlookup-tender-register-v4-0-nov-2010-1
Sheet: Averages

Per Estimator |  | Estimator | Ave bid | ave winning tender | ave variance | % | ave finishing position | Strike/success rate
 |  | MAB | 174166.6666666667 | #N/A | #N/A | #N/A | #N/A | 0.3333333333333333
 |  | LH | 31750 | #N/A | #N/A | #N/A | #N/A
 |  | KJL | 500000 | #N/A | #N/A | #N/A | #N/A
 |  | JST | 425000 | #N/A | #N/A | #N/A | #N/A
 |  | SP | 10000 | #N/A | #N/A | #N/A | #N/A
 |  | MW | 75000 | #N/A | #N/A | #N/A | #N/A
Per Client |  | Client | Ave bid | ave winning tender | ave variance | % | ave finishing position
 |  | Priory | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Craegmoor | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Oxfam | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | EMC | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 831031d1685362624-sumifs-issue-can-not-find-correct-number-pet
Sheet: Sheet1

Sample
 |  |  |  |  |  | Note | tds applicable for after 10000
Sr. No | Party Name | pan No | month | [NAME] | Amount | tds section | TDS Applicable / Not Applicable |  | Actual Result
1 | A | XXXXX | 2023-04-01 00:00:00 | 1 | 5000 | 94C |  |  | NOT TAXABLE
 | B | CCCCC | 2023-04-01 00:00:00 |  | 6000 | 94C |  |  | NOT TAXABLE
 | C | XXXXX | 2023-04-01 00:00:00 |  | 4000 | 94C |  |  | NOT TAXABLE
 | D | DDDDD | 2023-04-01 00:00:00 |  | 1000 | 94C |  |  | NOT TAXABLE
 | E | CCCCC | 2023-05-01 00:00:00 |  | 10000 | 94H |  |  | NOT TAXABLE
 | F | XXXXX | 2023-05-01 00:00:00 |  | 2000 | 94C |  |  | TAXABLE VALUE
Spreadsheet: 97246d1296486012-if-statement-and-summing-copy-20of-20excel-1-
Sheet: Sheet1

Company | Days | Days overtime | Sum of company A | Sum of company B | Sum of Company C | Date |  |  | Sum of Days overtime
A | 8 | 2 | 2 | 5 | 0 | 2011-01-14 00:00:00 |  |  | Date | Company | Total
B | 8 | 5 |  |  |  | 2011-01-31 00:00:00 |  |  | Jan | A | 2
C | 8 | 3 |  |  |  | 2011-01-03 00:00:00 |  |  |  | B | 5
 |  |  |  |  |  |  |  |  | Feb | C | 3
Spreadsheet: 807835d1670082884-calling-data-from-main-sheet-g6-ver-256
Sheet: SUBJECT GRADES

HALMASHAURI YA WILAYA [NAME]
MTIHANI WA KUMALIZA MUHULA WA PILI DARASA LA V NOVEMBA, 2022
B. UFAULU KIMASOMO
SOMO | REGISTERED |  |  |  |  |  | STUDENTS SCORED GRADES |  |  |  |  |  |  | FAILED |  |  |  | % FAILED
 | SAT |  |  | PASSED |  |  | A |  | B |  | C |  | % PASSED | D |  | E
 | M | F | TOTAL | M | F | TOTAL | M | F | M | F | M | F |  | M | F | M | F
KISWAHILI
ENGLISH
HISABATI
SAYANSI & TEKNOLOJIA
[NAME]
URAIA NA MAADILI
S/KAZI
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: Midway

Hour |  |  |  |  |  |  | Linked Data
Ending
Pacific | Midway physical | WAPA | West Plains | (PSCO)CSU | (PSCO)CSU | TSGT | To CSU | To San Juan | WAPA | Tristate | WAPA | Balance
Standard | position | Purch | Utilicorp | Purch | Purch | Purch | Call Option | WAPA trans | Sale | Sale | Sale
(PST)
 |  |  |  |  |  |  | 28.9245
100 | 0
200 | 0
300 | 0
400 | 0
500 | 0
600 | 0
700 | 0
800 | 0
900 | 0
1000 | 0
1100 | 0
1200 | 0
1300 | 0
1400 | 0
1500 | 0
1600 | 0
1700 | 0
1800 | 0
1900 | 0
2000 | 0
2100 | 0
2200 | 0
2300 | 0
2400 | 0
Spreadsheet: benjamin_rogers__1186__Rogers
Sheet: Deals

 | Deal / Prospect | Structuring / Execution Activities | Hardware | Origination | Group | GTD Assigned | Associates | Analysts | Other
10 | Motown (MCN) | Base Model & PPA Restructuring |  | [NAME] | QF | [NAME] | [NAME] | [NAME]
20 | Wilhelm (Kaiser) | Base Model & PPA Restructuring | Aluminum |  | Other | [NAME] | [NAME]
30 | East Coast Power |  |  | [NAME] | QF |  | [NAME] | [NAME]
31 | Tosco / Linden6 |  |  | [NAME] | QF | [NAME] | [NAME] |  | [NAME] (CTG Midstream)
40 | [NAME] (Brooklyn) / Battleship | Base Model & PPA Restructuring |  | [NAME] | QF | [NAME]   Jeff Hoover | [NAME]
50 | Lakewood | Base Model & PPA Restructuring |  | [NAME] | QF | [NAME] | [NAME] | [NAME] | [NAME])
60 | ENA - West L.B. | Buying FIAT Turbines |  | [NAME] | IPP |  | [NAME] |  | [NAME]
70 | Peoples |  |  | [NAME] | IPP | [NAME] | [NAME] | [NAME] | [NAME]
71 | Wilton (Lincoln Center) | ENA to take back advisor role | 7FA |  | IPP
72 | Calumet |  | ABB,LM's |  | IPP
73 | Torrence |  |  |  | IPP
80 | [NAME] |  | GAS | [NAME] | IPP | [NAME] |  | [NAME] | [NAME][NAME]
90 | [NAME] | PPA Restructuring w/ [NAME] |  | [NAME] | QF | [NAME] | [NAME] | [NAME]
100 | Duke Florida Projects & 3 other sites | Turbines |  | [NAME] | GEN
 | 2000 Peakers | Gleason / Done except for TVA Inter-connectCinergy / Water Supply needed |  | [NAME] | GEN
 | LM 6000 Turbines | Base Model Base Pricing |  | [NAME] | GEN | [NAME] | [NAME] |  | [NAME]
 | WH 501 D5A Turbine |  | WH | [NAME] | IPP
 | Development / Structuring Fees | LM6000 7FA | LM's | [NAME] | GEN |  |  |  | [NAME],[NAME], [NAME]
 | Synthetic Combined Cycle | Selling L.T. 16 hr power |  | [NAME] | IPP |  | [NAME]
 | Selling Turbines/Sites | Monetizing ENA Positions |  | [NAME] | IPP
 | Restructure to Accelerate Income for IPP's |  |  | [NAME] | IPP
 | Power Curves (+18 months) | Developing model for long-term merchane valuation |  |  | Other |  | [NAME] |  | [NAME]     [NAME]
 | Endeck |  |  | [NAME] | QF
 | IPP/QF Coverage |  |  | [NAME] | QF | [NAME] | [NAME]
 | PPA Auctions |  |  | [NAME] | QF |  | [NAME] |  | [NAME]
 | GE 7 Series Turbines |  |  | [NAME] | IPP
 | [NAME] | Labor Role Issues |  | [NAME] | IPP | [NAME]
 | STAT Oil |  |  | [NAME] | QF | [NAME]
 | [NAME] |  |  | Industrials |  | [NAME] | [NAME] | [NAME] | [NAME]
 | Tomen |  |  | [NAME] | QF
 | El Paso / Dynegy | Dynegy Asets |  | [NAME]
 | West Coast Power Deals | CTG Functions for Portland / S.F. |  | [NAME] | VAR | [NAME]
 | Development Management | Managing Pre Construction Development |  | [NAME] | GEN
 | Hardware Lists | Tracking Turbine Inventory |  | [NAME] | GEN
Spreadsheet: 176261d1345797129-matching-and-printing-values-from-two-excel-columns-in-another-column-on-certain-condition-task
Sheet: Sheet1

Number 1 | Number 2 | Sequence | Final Sequence | Answer by [NAME]
1001 | 1001 | AGCTAGCTCTTAGCGCGCGCG | AGCTAGCTCTTAGCGCGCGCG
1002 | 1002 | CTTCAGC | CTTCAGC
1003 | 1003 | AAAAAGCTCC | AAAAAGCTCC
1005 | 1004 | GCTCTTAGCGCGCGCG | AAAGCTCCCAGC
1006 | 1005 | AAAGCTCCCAGC | GCTCTTAGCGCGCGCG
1008 | 1006 | GCTCTTAGCGCGCGCG | CTTAGCGCGCGCG
 | 1007 | TTAGCGCGCGCG
 | 1008 | CTTAGCGCGCGCG
[NAME]
Spreadsheet: 689469d1596444459-check-price-for-different-related-part-number-check-latest-part-price
Sheet: Sheet2

Part | Price | Effective from | Effective To |  |  |  | Check Part | Current quotation | Last 1st quotation | Last 2nd quotation
123K45670 | 525 | 2015-04-20 00:00:00 | 2015-10-01 00:00:00 | quotation expired |  |  | 123K45674
993K45670 | 519 | 2015-10-02 00:00:00 | 2016-10-03 00:00:00 | quotation expired
123K45670 | 516 | 2016-10-04 00:00:00 | 2019-10-06 00:00:00 | quotation expired |  |  | can use concatenate
123K45670 | 508 | 2019-10-07 00:00:00 |  | <=active quotaton
123K45671 | 541 | 2015-05-13 00:00:00 | 2017-04-18 00:00:00 | quotation expired |  |  | Notes
123K45673 | 609 | 2015-08-20 00:00:00 | 2015-10-01 00:00:00 | quotation expired |  |  | part roll up on last part number
123K45673 | 602 | 2015-10-02 00:00:00 | 2016-10-03 00:00:00 | quotation expired |  |  | D5, D12 are active quotation
123K45673 | 673 | 2016-10-04 00:00:00 | 2017-10-03 00:00:00 | quotation expired |  |  | input 123K45674, want [NAME] part price for previous revision part number
123K45673 | 635 | 2017-10-04 00:00:00 | 2018-09-30 00:00:00 | quotation expired
123K45673 | 630 | 2018-10-01 00:00:00 | 2019-09-30 00:00:00 | quotation expired
123K45673 | 626 | 2019-10-01 00:00:00 |  | <=active quotaton
part roll up on last part number
…
…
…
A list of different part quotation.
…
…
…
…
…
…
Spreadsheet: 132638d1323870596-sales-rankings-forum
Sheet: Arkusz1

Pattern | Sku | Sales
[NAME] | VERA FLIRT 5PPS |  |  | Pattern | Sku | Suma z Sales
[NAME] | VERA FLIRT RIM SOUP | 854 |  | [NAME] |  | 2201.44
[NAME] | VERA FLIRT OVAL PLATTER | 653 |  |  | V.W. DUSK BOWL CEREAL 6.0 | 1000
[NAME] | VERA FLIRT OPEN VEG | 754 |  |  | V.W. DUSK RECTANGULAR TRAY 15.0 | 525
[NAME] | VERA FLIRT ACCENT PLATE |  |  |  | V.W. DUSK 4 PIECE SET | 500
[NAME] | VERA FLIRT DINNER | 80 |  |  | V.W. DUSK MUG                       (MF) | 79.8
[NAME] | VERA FLIRT TEAPOT |  |  |  | V.W. DUSK CREAMER | 76.64
[NAME] | VERA FLIRT CREAMER | 24.54 |  |  | V.W. DUSK PLATE  9.0 23CM | 20
[NAME] | VERA FLIRT SUGAR |  |  |  | V.W. DUSK BOWL                    M/S
[NAME] | VERA FLIRT SALAD |  |  |  | V.W. DUSK ROUND SERVING BOWL 10.0
[NAME] | VERA FLIRT B&B |  |  |  | V.W. DUSK DIP BOWL 4.0
[NAME] | V.W. VERA FLIRT TEACUP IMP |  |  |  | V.W. DUSK PLATE SQUARE 9.0
[NAME] | VERA FLIRT 5PPS |  |  |  | VW NATURALS DUSK LOW FRUIT BOWL 33CM
[NAME] | V.W. VERA FLIRTA TEASAUCER IMP |  |  |  | V.W. DUSK ROUND PLATTER
[NAME] | VERA FLIRTSOP/SAL BWL 6.0 | 207.26 |  |  | DUSK SUGAR
[NAME] | V.W. DUSK PITCHER M/S |  |  |  | V.W. DUSK DINNER PLATE 10.75  LINC
[NAME] | V.W. DUSK 4 PIECE SET | 500 |  |  | V.W. DUSK SQUARE PLATTER/CHARGER PLATE
[NAME] | V.W. DUSK BOWL CEREAL 6.0 | 1000 |  |  | V.W. DUSK PITCHER M/S
[NAME] | V.W. DUSK PLATE  9.0 23CM | 20 |  |  | V.W. DUSK PITCHER L/S
[NAME] | V.W. DUSK MUG                       (MF) | 79.8 |  | [NAME] |  | 2572.8
[NAME] | V.W. DUSK DINNER PLATE 10.75  LINC |  |  |  | VERA FLIRT RIM SOUP | 854
[NAME] | V.W. DUSK PITCHER L/S |  |  |  | VERA FLIRT OPEN VEG | 754
[NAME] | V.W. DUSK RECTANGULAR TRAY 15.0 | 525 |  |  | VERA FLIRT OVAL PLATTER | 653
[NAME] | V.W. DUSK ROUND SERVING BOWL 10.0 |  |  |  | VERA FLIRTSOP/SAL BWL 6.0 | 207.26
[NAME] | V.W. DUSK BOWL                    M/S |  |  |  | VERA FLIRT DINNER | 80
[NAME] | V.W. DUSK ROUND PLATTER |  |  |  | VERA FLIRT CREAMER | 24.54
[NAME] | DUSK SUGAR |  |  |  | VERA FLIRT SALAD
[NAME] | V.W. DUSK CREAMER | 76.64 |  |  | VERA FLIRT TEAPOT
[NAME] | VW NATURALS DUSK LOW FRUIT BOWL 33CM |  |  |  | V.W. VERA FLIRT TEACUP IMP
[NAME] | V.W. DUSK DIP BOWL 4.0 |  |  |  | VERA FLIRT SUGAR
[NAME] | V.W. DUSK SQUARE PLATTER/CHARGER PLATE |  |  |  | V.W. VERA FLIRTA TEASAUCER IMP
[NAME] | V.W. DUSK PLATE SQUARE 9.0 |  |  |  | VERA FLIRT B&B
 |  |  |  |  | VERA FLIRT 5PPS
 |  |  |  |  | VERA FLIRT ACCENT PLATE
 |  |  |  | Suma końcowa |  | 4774.24
Spreadsheet: 825254d1681213706-excell-icon-sets-based-on-date-in-other-cells-budget-transfer-worksheet-test
Sheet: PICK LISTS

SENDER FUND CENTRE | RECEIVER FUND CENTRE | FUND | CI | FUNCTIONAL AREA
420087 | 420086 | B120 | SO1 | BTF0201
310002 | 420087 | B125 | TNS | BTF0801
310003 | 420089 |  |  | BTF0901
310004 | 420090 |  |  | BTF1001
310005 | 420091 |  |  | BTF1101
310016 | 420092 |  |  | BTG0301
310029 | 420094 |  |  | BTG0401
470068 | 420096 |  |  | BTG0501
 | 420097 |  |  | BTG0601
 | 420098 |  |  | [NAME]
 | 420099 |  |  | BTI0202
 | 420100 |  |  | BTI0402
 | 420101
 | 420102
 | 420103
 | 420104
 | 420106
 | 420107
 | 420108
 | 420109
 | 420112
 | 420114
Spreadsheet: 82015d1282084445-pulling-data-from-column-bandp
Sheet: Sheet1

INPUT | b | p |  |  |  |  |  | run | b
B |  |  |  |  |  |  |  | 25
B |  |  |  |  |  |  |  | 24
B |  |  |  |  |  |  |  | 23
B |  |  |  |  |  |  |  | 22
P |  |  |  |  |  |  |  | 21
B |  |  |  |  |  |  |  | 20
B |  |  |  |  |  |  |  | 19
B |  |  |  |  |  |  |  | 18
P |  |  |  |  |  |  |  | 17
P |  |  |  |  |  |  |  | 16
P |  |  |  |  |  |  |  | 15
P |  |  |  |  |  |  |  | 14
P |  |  |  |  |  |  |  | 13
P |  |  |  |  |  |  |  | 12
P |  |  |  |  |  |  |  | 11
B |  |  |  |  |  |  |  | 10
B |  |  |  |  |  |  |  | 9
P |  |  |  |  |  |  |  | 8
B |  |  |  |  |  |  |  | 7
B |  |  |  |  |  |  |  | 6
B |  |  |  |  |  |  |  | 5
P |  |  |  |  |  |  |  | 4 |  | ok
P |  |  |  |  |  |  |  | 3 |  | ok
B |  |  |  |  |  |  |  | 2 |  | ok
B |  |  |  |  |  |  |  | 1 |  | ok
B
B
P
B
P
P
P
B
B
B
B
P
P
B
B
P
B
B
P
P
P
P
P
B
B
B
P
B
P
P
P
B
B
B
Spreadsheet: 760255d1640099804-randomizing-pairs-from-odd-or-even-list-rand_pairings
Sheet: Sheet1

 | Event date | 2021-12-22 00:00:00
 | Participants | Randomiser |  |  | Pairings
 | Fred |  |  | 1
 | Barney |  |  | 2
 | George |  |  | 3
 | Elroy |  |  | 4
 | [NAME]
 | Linus
 | Schroeder
Spreadsheet: 806492d1669343898-apply-different-penalty-rates-over-a-24-hr-period-pay-calculator_rev-08b
Sheet: Pay Calculator

Employee Name :
Employee Staff # : |  |  |  | PROBLEM - when you work a public holiday this should be zero PLUS ADOC, AND CHECK ALL OTHER ENTRIES |  | TO SOLVE THE PROBLEM INSERT A NEW COLUMN AND LINK TO THE DROP DOWN BOX, THEN NORMAL HOURS PAID LINKED TO THAT COLUMN TO SHOW ZEROSHOULD BE ZERO
 |  |  |  |  |  |  |  |  | PENALTY AWARDS and ADDITIONS
DATE | DAY | SHIFT [NAME] |  | NORMAL HOURS PAID $ |  | [NAME] |  |  | LATE/EARLY PENALTY |  | BROKEN SHIFT |  | HIGH CAPACITY ALLOWANCE | TRAVELLING TIME |  | PUBLIC HOLIDAY |  |  |  | ROSTERED DAY OFF CANCELLED (RDOC) |  | ADO | ALLOCATED DAY OFF CANCELLED (ADOC) |  |  |  | ANNUAL LEAVE | ANNUAL LEAVE LOADING | SICK DAY
 |  |  |  |  |  | 1½ | DOUBLE |  | 1st. HALF | 2nd. HALF | 0.5 | 1 |  |  |  | WORK | +  PUBLIC HOLIDAY | NO WORK |  | 1st. 3 hrs | After 3hrs |  | ADO Default | 1st. 3 hrs | After 3hrs
WEEK 1
 |  |  |  | 0 |  | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 |  | Week 1 Totals :
WEEK 2
 |  |  |  | 0 |  | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 |  | Week 2 Totals :
 |  | COMBINED TOTAL :
Spreadsheet: 227039d1365584766-splitting-data-from-cells-examples-included-template-for-data-result
Sheet: Sheet1

Title | Foremane | Surname | Add1 | Add2 | Add3 | Add4 | Postcode | Tel1 | Tel2 | Tel3
Mr | [NAME] | Twoshoes | 1 Green Park Lane | [NAME] | [NAME] | West Yorkshire | BD74  7RE | [PHONE] | [PHONE] | [PHONE]
Spreadsheet: 58450d1258676358-pulling-multiple-and-varied-of-rows-from-one-sheet-into-another-incentive-payment-report4
Sheet: Incentive Payment Summary

 | Incentive Payment Report
 | Territory Manager [NAME]: |  | [NAME]
 | Territory Manager Number: |  | 343
 | Employee #: |  | 28830
 | Incentive Payment Summary
 |  | Total Incentive Payment | Dealer Incentive | Retail Incentive | W Incentive
 |  | 34.67 | 34.67 | 0 | 0
 |  |  | Comments
 | 0
 | Incentive Payment Details
 | Customer # | Customer Name | Sales | Territory | Cust Type | Currency
 | 100550 | EFG | 3467 | 32 | L | CD
Spreadsheet: 760620d1640339953-problem-incorrect-value-returned-using-index-match-min-problem-calculation
Sheet: Sheet1

 | Cows | Pigs
High | 2 | 456
High | 15 | 12
High | 7 | 165
High | 20 | 126
High | 1 | 23
Low | 15 | 48
Low | 20 | 1
Low | 13 | 66
Low | 1 | 543
Low | 18 | 159
Low
Cows
Pigs
Spreadsheet: 0b75e463-0a66-483b-9d81-e98c8ceff765
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Table 10--Acreage, yield, and production estimates, 2013
State/region | Planted |  | Harvested |  | Yield |  | Production
 |  |  |  |  | Pounds/
 | -- 1,000 acres -- |  |  |  | [NAME] |  | 1,000 bales
Upland:
Alabama | 330 |  | 328 |  | 768 |  | 525
Florida | 125 |  | 118 |  | 915 |  | 225
Georgia | 1300 |  | 1275 |  | 941 |  | 2500
North Carolina | 420 |  | 415 |  | 775 |  | 670
South Carolina | 280 |  | 275 |  | 663 |  | 380
Virginia | 70 |  | 69 |  | 1050 |  | 151
Southeast | 2525 |  | 2480 |  | 861 |  | 4451
Arkansas | 320 |  | 315 |  | 1036 |  | 680
Louisiana | 130 |  | 125 |  | 960 |  | 250
Mississippi | 320 |  | 315 |  | 990 |  | 650
Missouri | 270 |  | 261 |  | 1103 |  | 600
Tennessee | 260 |  | 255 |  | 979 |  | 520
Delta | 1300 |  | 1271 |  | 1020 |  | 2700
Kansas | 30 |  | 29 |  | 662 |  | 40
Oklahoma | 150 |  | 135 |  | 818 |  | 230
Texas | 5700 |  | 3300 |  | 596 |  | 4100
Southwest | 5880 |  | 3464 |  | 606 |  | 4370
Arizona | 170 |  | 168 |  | 1500 |  | 525
California | 110 |  | 109 |  | 1585 |  | 360
New Mexico | 30 |  | 27 |  | 1191 |  | 67
West | 310 |  | 304 |  | 1503 |  | 952
Total Upland | 10015 |  | 7519 |  | 796 |  | 12473
Pima:
Arizona | 1 |  | 1 |  | 864 |  | 2
California | 170 |  | 169 |  | 1562 |  | 550
New Mexico | 4 |  | 4 |  | 1011 |  | 8
Texas | 11 |  | 10 |  | 960 |  | 20
Total Pima | 186 |  | 184 |  | 1514 |  | 580
Total all | 10201 |  | 7703 |  | 813 |  | 13053
Source:  USDA, August 2013 Crop Production report.
Last update: 08/14/13.
Spreadsheet: 39943d1238173978-double-lookup-lookup-example
Sheet: Sheet1

 | A | B | C | D | E | F | G | H | I
1 | A 1 | B 1 | C 1 | D 1 | E 1 | F 1 | G 1 | H 1 | I 1
2 | A 2 | B 2 | C 2 | D 2 | E 2 | F 2 | G 2 | H 2 | I 2
3 | A 3 | B 3 | C 3 | D 3 | E 3 | F 3 | G 3 | H 3 | I 3
4 | A 4 | B 4 | C 4 | D 4 | E 4 | F 4 | G 4 | H 4 | I 4
5 | A 5 | B 5 | C 5 | D 5 | E 5 | F 5 | G 5 | H 5 | I 5
6 | A 6 | B 6 | C 6 | D 6 | E 6 | F 6 | G 6 | H 6 | I 6
7 | A 7 | B 7 | C 7 | D 7 | E 7 | F 7 | G 7 | H 7 | I 7
8 | A 8 | B 8 | C 8 | D 8 | E 8 | F 8 | G 8 | H 8 | I 8
9 | A 9 | B 9 | C 9 | D 9 | E 9 | F 9 | G 9 | H 9 | I 9
10 | A 10 | B 10 | C 10 | D 10 | E 10 | F 10 | G 10 | H 10 | I 10
11 | A 11 | B 11 | C 11 | D 11 | E 11 | F 11 | G 11 | H 11 | I 11
12 | A 12 | B 12 | C 12 | D 12 | E 12 | F 12 | G 12 | H 12 | I 12
13 | A 13 | B 13 | C 13 | D 13 | E 13 | F 13 | G 13 | H 13 | I 13
14 | A 14 | B 14 | C 14 | D 14 | E 14 | F 14 | G 14 | H 14 | I 14
15 | A 15 | B 15 | C 15 | D 15 | E 15 | F 15 | G 15 | H 15 | I 15