tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 729061d1618892311-rows-10-59-if-col-z-has-value-list-corresponding-cell-in-col-y-and-col-aa-concatenated-example-see-column-y-z-and-aa
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Col Y | Col Z | Col AA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | red |  | triangle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | blue | hello | square
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | red | hello | triangle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | grey | bye | circle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | green |  | triangle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | blue | hello | square
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Desired result, all in one cell:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] blue square
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Alternatively, would be happy with a simple version which just looks up column Y, but it still all needs to be arrayed in 1 cell:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | blue red grey Blue
Spreadsheet: 805915d1669006314-excel-tab-auto-copy-data-log-ans
Sheet: Josh

Hire Date | Emp Name | Emp ID | Dept | Educator
Spreadsheet: 144432d1330977019-continuous-calc-in-one-column-based-on-date-in-another-dry-ice-tracker
Sheet: Dry Ice Tracker

rowid | SCAN | Col1 | Col2 | Time Stamp | Date | Time | Delivery Time in Min & Sec
1 | Dock |  |  | 2012-03-01 08:36:43
2 | 2222 |  |  | 2012-03-01 08:41:15
3 | 2235 |  |  | 2012-03-01 08:46:21
4 | 1217 |  |  | 2012-03-01 08:49:17
5 | 1205 |  |  | 2012-03-01 08:53:33
6 | 1230 |  |  | 2012-03-01 08:59:29
7 | 1116 |  |  | 2012-03-01 09:02:56
8 | 2111A |  |  | 2012-03-01 09:06:53
9 | 2111 |  |  | 2012-03-01 09:09:13
10 | B116A P |  |  | 2012-03-01 09:13:21
11 | B116A R |  |  | 2012-03-01 09:16:13
1 | Dock |  |  | 2012-03-05 09:56:46
2 | 2222 |  |  | 2012-03-05 10:01:51
3 | 2235 |  |  | 2012-03-05 10:06:12
4 | 1217 |  |  | 2012-03-05 10:10:07
5 | 1205 |  |  | 2012-03-05 10:15:21
6 | 1230 |  |  | 2012-03-05 10:20:03
7 | 1116 |  |  | 2012-03-05 10:24:32
8 | 2111A |  |  | 2012-03-05 10:29:54
9 | 2111 |  |  | 2012-03-05 10:33:31
10 | B116A P |  |  | 2012-03-05 10:40:21
11 | B116A R |  |  | 2012-03-05 10:40:32
Spreadsheet: 112622d1308687370-average-vlookup-average
Sheet: ORDERS

 | 2011-06-09 00:00:00 | 2011-06-10 00:00:00 | 2011-06-11 00:00:00 | 2011-06-12 00:00:00 | 2011-06-13 00:00:00 | 2011-06-14 00:00:00 | 2011-06-15 00:00:00 | 2011-06-16 00:00:00 | 2011-06-17 00:00:00 | 2011-06-18 00:00:00 | 2011-06-19 00:00:00 | 2011-06-20 00:00:00 | 2011-06-21 00:00:00 | 2011-06-22 00:00:00
PRODUCT 1 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
PRODUCT 2 | 87 | 6 | 557 | 6 | 34 | 46 | 56 | 65 | 65 | 57 | 334 | 223 | 4 | 65
PRODUCT 3 | 6 | 56 | 6 | 6 | 6 | 46 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
PRODUCT 4 | 3 | 45 | 3 | 3 | 3 | 68 | 12 | 3 | 3 | 3 | 3 | 3 | 3 | 3
PRODUCT 5 | 4 | 34 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
PRODUCT 6 | 5 | 67 | 5 | 35 | 354 | 57 | 79 | 231 | 231 | 56 | 57 | 698 | 8 | 86
PRODUCT 7 | 7 | 43 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
PRODUCT 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
PRODUCT 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
PRODUCT 10 | 87 | 46 | 87 | 65 | 21 | 34 | 34 | 53 | 53 | 53 | 53 | 53 | 53 | 53
PRODUCT 11 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
PRODUCT 12 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54
PRODUCT 13 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Spreadsheet: louise_kitchen__24046__East Power Consolidation
Sheet: Southeast Trading

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays | 130000
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount
 | Analyst & Associate Headcount |  |  | 4
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
 | Relocation Exp | 64113
Spreadsheet: 0b71db3a-6869-4f09-97c6-37eca95de6f4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8525 | 63986 | Gino | Eindnoren | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:57:52
8525 | 63880 | Ismael | Perales | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 00:58:08
8525 | 63881 | Victor | Bitriago | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 00:59:12
8525 | 63940 | [NAME] | Piccinetti Boccitto | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 01:02:19
8525 | 63838 | [NAME] | Caceres | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 01:03:12
8525 | 63841 | [NAME] | Odreman | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 6 | 01:03:45
8525 | 63839 | [NAME] | Sanchez | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 7 | 01:10:32
Spreadsheet: 39df6029-3d9a-4ee8-baf5-46b44cb4792a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: September 1, 2014 (4:16 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008
2009
2010
2011
2012
Spreadsheet: 3b794d9b-53ce-46aa-bd69-5dc3a8b68183
Sheet: Sheet1

State of New Hampshire - Gemeral Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
State Representatives - BELKNAP County
District No. 1 (1) | Quinney, r | Gulick ,d | [NAME]
Center Harbor | 373 | 285
New Hampton | 525 | 694 | 6
Totals | 898 | 979 | 6
District No. 2 (4) | Worsman, r | Greemore, Jr., r | Leandro, r | Vadney, r | Miller, d
Gilford | 1749 | 1658 | 1868 | 1629 | 1705
Meredith | 1768 | 1733 | 1517 | 1781 | 1646
Totals | 3517 | 3391 | 3385 | 3410 | 3351
 | Mucci, d | [NAME], d | [NAME], d | [NAME], und |  | [NAME]
Gilford | 1544 | 2056 | 1811 | 688 |  | 12
Meredith | 1438 | 1434 | 1404 | 239 |  | 3
Totals | 2982 | 3490 | 3215 | 927 |  | 15
District No. 3 (4) | [NAME], r | Recount | Flanders, r | Recount | Kingsbury, r | Recount | Luther, r | Recount
Laconia Wd 1 | 737 | 738 | 750 | 750 | 640 | 642 | 647 | 647
Laconia Wd 2 | 486 | 492 | 474 | 479 | 400 | 405 | 424 | 434
Laconia Wd 3 | 635 | 639 | 630 | 633 | 490 | 492 | 539 | 541
Laconia Wd 4 | 501 | 501 | 508 | 507 | 409 | 407 | 424 | 424
Laconia Wd 5 | 432 | 429 | 418 | 416 | 353 | 351 | 366 | 362
Laconia Wd 6 | 814 | 822 | 806 | 812 | 698 | 705 | 740 | 745
Totals | 3605 | 3621 | 3586 | 3597 | 2990 | 3002 | 3140 | 3153
 | Vaillancourt, d | Recount | Fisher, d | Recount | Huot, d | Recount | Smith,d | Recount
Laconia Wd 1 | 448 | 450 | 408 | 408 | 558 | 557 | 432 | 433
Laconia Wd 2 | 420 | 423 | 378 | 382 | 559 | 562 | 398 | 401
Laconia Wd 3 | 581 | 581 | 478 | 478 | 696 | 696 | 500 | 501
Laconia Wd 4 | 483 | 486 | 428 | 432 | 597 | 582 | 445 | 447
Laconia Wd 5 | 424 | 422 | 374 | 372 | 549 | 551 | 398 | 396
Laconia Wd 6 | 584 | 586 | 520 | 520 | 725 | 730 | 552 | 553
Totals | 2940 | 2948 | 2586 | 2592 | 3684 | 3678 | 2725 | 2731
District No. 4 (2) | Fields, r | Recount | Lang, Sr., r | Recount | [NAME], d | Recount | Alden, d | Recount
Sanbornton | 881 | 883 | 729 | 732 | 788 | 791 | 658 | 649
[NAME] | 803 | 803 | 649 | 647 | 778 | 778 | 885 | 887
Totals | 1684 | 1686 | 1378 | 1379 | 1566 | 1569 | 1543 | 1536
District No. 5 (2) | [NAME], r | Burchell, r | Henry, d | Chase, d | [NAME]
Alton | 1860 | 1661 | 929 | 1171 | 5
Gilmanton | 907 | 985 | 692 | 999
Totals | 2767 | 2646 | 1621 | 2170 | 5
District No. 6 (2) | [NAME], r | Fink, r | Cormier, d | Condod-  emetraky, d | [NAME]
Belmont | 1646 | 1575 | 1517 | 1118 | 14
District No. 7 (1) | [NAME], r | Marriott, d | [NAME]
Barnstead* | 1255 | 1003 | 4
District No. 8 (1) F | Cormier, r | Smith, d | [NAME]
Alton | 2035 | 1054 | 2
Barnstead* | 1193 | 991 | 2
Gilmanton | 1113 | 836
Totals | 4341 | 2881 | 4
District No. 9 (1) F | Accornero, r | Arsenault, d | [NAME]
Belmont | 1566 | 1704 | 5
Laconia Wd 1 | 673 | 518 | 7
Laconia Wd 2 | 432 | 589 | 16
Laconia Wd 3 | 546 | 712
Laconia Wd 4 | 456 | 631
Laconia Wd 5 | 375 | 589
Laconia Wd 6 | 776 | 782 | 1
Totals | 4824 | 5525 | 29
*corrections received from clerk
Spreadsheet: 870863d1717328301-how-to-tell-if-function-returns-array-or-range-raulserg-post5955261-test-bed-tms
Sheet: Sheet1

A | 1 | A |  |  |  |  | 1 |  |  | A |  |  |  |  | Hi, just looking at these 3 variations of a simple summation exercise:
A | 2 | C |  |  |  | A | 2
A | 3 |  |  |  |  | A | 3 |  |  |  |  |  |  |  | =SUMIFS(INDEX(G3#,,2),INDEX(G3#,,1),K3)
B | 4 |  |  |  |  | C | 6 |  |  |  |  |  |  |  | works because index returns a range that SUMIFS can work with
B | 5 |  |  |  |  | A | 7
C | 6 |  |  |  |  | C | 9 |  |  |  |  |  |  |  | =SUMIFS(CHOOSECOLS(G3#,2),CHOOSECOLS(G3#,1),K3)
A | 7 |  |  |  |  | A | 10 |  |  |  |  |  |  |  | does not work because CHOOSECOLS (I assume) returns an array only that fails within SUMIFS
B | 8
C | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME])
A | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | also works but I am not sure why; does it even return a range?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | And how can I tell?
 |  |  |  |  |  |  |  |  |  | A | 2
 |  |  |  |  |  |  |  |  |  | A | 3 |  |  |  | Just for fun, a couple more options:
 |  |  |  |  |  |  |  |  |  | C | 6
 |  |  |  |  |  |  |  |  |  | A | 7 |  |  |  | =SUM(FILTER(INDEX(G3#,,2),INDEX(G3#,,1)=K3))
 |  |  |  |  |  |  |  |  |  | C | 9
 |  |  |  |  |  |  |  |  |  | A | 10 |  |  |  | =SUM(CHOOSECOLS(G3#,2)*(CHOOSECOLS(G3#,1)=K3))
Spreadsheet: 691106d1597477739-index-match-formula-with-2-match-criterias-2020-08-15-oeldere-jclaborn-691085d1597445689-index-match-formula-with-2-match-criterias-test
Sheet: SOURCE DATA

 |  | Order Number | Status | Department
 |  | 16 | Complete | Floors
 |  | 16 | Complete | Boxing
 |  | 17 | Released | Floors
 |  | 17 | Complete | Boxing
 |  | 17 | Released | Rigout
 |  | 18 | Complete | Floors
 |  | 18 | Released | Boxing
 |  | 18 | Released | Rigout
 |  | 19 | Complete | Floors
 |  | 19 | Released | Boxing
 |  | 19 | Complete | Rigout
 |  | 20 | Complete | Floors
 |  | 20 | Released | Boxing
 |  | 20 | Complete | Rigout
 |  | 21 | Released | Floors
 |  | 21 | Complete | Boxing
Spreadsheet: larry_campbell__20966__Kingman
Sheet: Netting 2

[NAME]
RED ROCK EXPANSION PROJECT
KINGMAN COMPRESSOR STATION
1999 Emissions Reported to ADEQ (from EI)
Unit | Nox (tpy) | CO (tpy) | VOC (tpy)
101 | 106.98 | 92 | 1.5
102 | 98.83 | 85 | 1.38
103 | 120.08 | 103.27 | 1.68
121 | 0 | 0 | 0
122 | 0 | 0 | 0
Total
2000 Emissions Reported to ADEQ (from EI)
Unit | Nox (tpy) | CO (tpy) | VOC (tpy)
101 | 280.87 | 472.77 | 3.76
102 | 236.95 | 398.84 | 3.17
103 | 214.98 | 361.87 | 2.88
121 | 5.26 | 8.85 | 0.07
122 | 0 | 0 | 0
Total
Last 2-Year Emissions Average (from EIs)
Unit | Nox (tpy) | CO (tpy) | VOC (tpy)
101
102
103
121
122
Total
Proposed Emission Increases (tpy)
Turbine | 128.34 | 78.27 | 2.65
[NAME] | 9.23 | 9.65 | 0.12
TOTAL
Contemporaneous Emission Decreases (tpy)
Net Change (Increase - Decrease) (tpy)
Notes:
(1) Proposed NOx, CO, and VOC emissions based on 80/20 split.  Turbine will operate at 100% load 80% of the time
and 64% load 20% of  the time.
(2) Proposed increases are from proposed turbine and generator engines.
Only one generator engine will be run at a time.
(3) Contemporaneous decreases are from permanent shutdown of Units 101, 102, 103, 121, and 122.
Spreadsheet: 786190d1657031170-football-league-modelling-formula-to-return-result-of-last-5-games-football-league-last-5-games-v2-sebgrs-
Sheet: League table

 |  | FOOTBALL LEAGUE
 |  | Date
 |  | Matchday |  | 20
 |  | Qualification |  | 0.4
 |  | # |  | Players | [NAME] |  |  |  |  | Goal Average |  |  | Last 5 Games |  |  |  |  | Ranking
 |  |  |  |  | P | W | D | L | FF | GF | GA | [NAME] | 1 | 2 | 3 | 4 | 5 | Qual? | Pts | Win % | PPG
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
Spreadsheet: 712696d1610379747-probability-of-occurrence-probability-prediction
Sheet: main

Error | Months | 2019 x defects | 2020 x defects | Total 2020 x defects | Total devices |  |  | Probability of occurrence
NEST1 | 1 | 46 | 66 | 627 | 7000 |  |  | % of something
NEST1 | 2 | 20 | 24 | 627 | 7000
NEST1 | 3 | 15 | 93 | 627 | 7000
NEST1 | 4 | 10 | 72 | 627 | 7000
NEST1 | 5 | 20 | 34 | 627 | 7000
NEST1 | 6 | 19 | 33 | 627 | 7000
NEST1 | 7 | 10 | 91 | 627 | 7000
NEST1 | 8 | 51 | 41 | 627 | 7000
NEST1 | 9 | 38 | 71 | 627 | 7000
NEST1 | 10 | 21 | 33 | 627 | 7000
NEST1 | 11 | 55 | 49 | 627 | 7000
NEST1 | 12 | 26 | 20 | 627 | 7000
Spreadsheet: 157363d1337708848-index-matching-with-reference-column-after-data-rolling-trends
Sheet: Jan

 |  |  | Month Ending 1/31/12 |  |  |  |  |  |  |  |  | Year To Date
 |  |  |  |  | [NAME] |  | Revenue: |  |  |  |  |  |  | [NAME]
 |  |  |  |  | From Budget |  |  |  |  |  |  |  |  | From Budget
 | Budget |  | Actual |  | Fav (Unfav) |  |  |  |  | Budget |  | Actual |  | Fav (Unfav)
 | 186472 |  |  |  |  |  | Patient Service Revenue |  |  | 1305306
 |  |  |  |  |  |  | Other Income
 |  |  |  |  |  |  | Total Revenue
 | Prepared By: [NAME]
 | Center for Dental & Oral Health
 | File: FP12JANA.XLS
 | 08-FEB-12 (Final)
Spreadsheet: 75248d1275835130-how-to-make-formulas-with-numbers-from-several-sheets-book1-2-
Sheet: number4

51
54
57
60
63
66
69
72
75
78
81
84
87
90
93
96
99
102
105
108
90
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
Spreadsheet: 859341d1707754344-count-instances-of-different-words-in-a-column-top-5-counts
Sheet: Sheet1

USA |  |  | 5
USA |  | CDN | 4
CDN |  | GBR | 2
USA |  | IRL | 2
GBR |  | MEX | 2
USA
CDN
MEX
CDN
CDN
USA
GBR
MEX
NED
IRL
IRL
BEL
FRA
Spreadsheet: 120905d1315622745-cell-reads-other-cells-from-another-sheet-nfl-football-schedule-2011-2012-testing-
Sheet: Week 14

Thursday, December 8, 2011
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
[NAME]
Pittsburgh Steelers
Sunday, December 11, 2011
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Kansas City Chiefs
New York Jets
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Tampa Bay Buccaneers
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New England Patriots
Washington Redskins
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Atlanta Falcons
Carolina Panthers
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Indianapolis Colts
Baltimore Ravens
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Philadelphia Eagles
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Minnesota Vikings
Detroit Lions
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New Orleans Saints
Tennessee Titans
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Oakland Raiders
Green Bay Packers
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Houston Texans
Cincinnati Bengals
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Chicago Bears
Denver Broncos
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
San Francisco 49ers
Arizona Cardinals
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Buffalo Bills
San Diego Chargers
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New York Giants
Dallas Cowboys
Monday, December 12, 2011
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
St. Louis Rams
[NAME]
Teams on Bye
Spreadsheet: 846557d1697720402-lookup-formula-help-to-extract-multiple-values-based-on-one-reference-lookup_samrat_v1
Sheet: Costing

Batch Number | 27666 | If I enter any batch number here (which is in records in "Production Consumption" sheet), then below table shall be populated (from the actual data as recorded in "Production Sheet")as shown below
 |  | If I change the batch number then, below data shall be changed accordingly
Date | Product Code | Product Name | Customer | RM Code | RM Name | [NAME] | [NAME] | Standard Qty (in Kg) | Actual Qty Used in [NAME] (in Kg)
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | RTU TH. | a | 0.5 | 1000 | 500 | 600
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KS-017 | b | 0.01 | 1000 | 10 | 10
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KAS-041 | c | 0.055 | 1000 | 55 | 55
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KM-23 | d | 0.02 | 1000 | 20 | 20
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KR4-014 | e | 0.05 | 1000 | 50 | 50
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KR3-014 | f | 0.06 | 1000 | 60 | 60
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | [NAME] | g | 0.18 | 1000 | 180 | 180
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | PA-52 | h | 0.001 | 1000 | 1 | 1
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | EA | i | 0.085 | 1000 | 85 | 85
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | BA | j | 0.05 | 1000 | 50 | 50
Spreadsheet: 220499d1363181827-can-i-calculate-tax-percentage-deduction-based-on-individual-circumstance-copy-of-payment-record
Sheet: 5 May (1)

PAYMENT RECORD
Name | job | payment refrence | gross | tax deducted | [NAME] added | amount paid | CIS | Paid | on return
MONTH ENDING 5/5/2012      PAYMENT DATE  06/04/12 |  |  |  |  |  |  |  |  |  | 1a
Company 1 | JOB 1 | 8/4641 | 1000 |  | 1000 |  | yes | yes | yes
MONTH ENDING 5/5/2012      PAYMENT DATE  15/04/12 |  |  |  |  |  |  |  |  |  | 1b
SUB 1 | JOB 1 | Payment 19 | 1000 |  | 0 |  | yes | yes | yes
SUB 4 | JOB 1 | invoice 68 | 1000 |  | 0 |  | yes | yes | yes
SUB 2 | JOB 1 | invoice 120 | 1000 |  | 0 |  | yes | yes | yes
SUB 3 | JOB 1 | invoice 132 | 1000 |  | 0 |  | yes | yes | yes
MONTH ENDING 5/5/2012      PAYMENT DATE  29/04/12 |  |  |  |  |  |  |  |  |  | 1c
SUB 3 | JOB 1 | Payment 20 | 1000 |  | 0 |  | yes | yes | yes
SUB 5 | JOB 1 | invoice 69 | 1000 |  | 0 |  | yes | yes | yes
SUB 2 | JOB 1 | invoice 121 | 1000 |  | 0 |  | yes | yes | yes
SUB 7 | JOB 1 | invoice 133 | 1000 |  | 0 |  | yes | yes | yes
SUB 6 | JOB 1 | invoice 6 | 1000 |  | 0 |  | yes | yes | yes
SUB 1 | JOB 1 | Invoice 1 | 1000 |  | 0 |  | yes | yes | yes
SUB 4 | JOB 2 | 6 / 58 | 1000 |  | 1000 |  | yes | yes | yes
Sub-Contractor | Tax Deducted
SUB 5 | 0.2
SUB 3 | 0.1
SUB 6 | 0.2
SUB 2 | 0.2
SUB 1 | 0.2
SUB 4 | 0
SUB 7 | 0.5
Spreadsheet: 60104d1260628373-vlookup-with-multiple-criteria-data
Sheet: Data

Book Name | Category | Language | Author
Birds and Beasts | Fiction
[NAME] | Fiction
August Coup | Fiction
And [NAME] the Don | Non-Fiction
[NAME] was it in that [NAME] | Fiction
Bang-i-Dara | Fiction
Answer to History | Fiction
Adhe Adhure | Fiction
Atoms of Hope | Fiction
Beast and Man | Fiction
A Himalayan Love Story | Fiction
Autobiography of an Unknown Indian | Fiction
Bharal Aur Europe | Fiction
 |  | Language Should be returned if The book Name & Category Matches to the rows in DUMP Sheet
 |  | Is it Possible with Vlookup Using Multiple Criteria.
Spreadsheet: 804080d1667875042-formula-to-find-maximum-consecutive-positive-values-by-year-data
Sheet: PSL 2017

 |  |  | Team Names |  | Team Score |  | Team Odds
Date | Time | Playoff - Y/N | Home | Away | Home Score | Away Score | Home Odds | Away Odds | Fav Odds | Winner Odds | Winner | Return | Season
2017-03-05 00:00:00 | 23:00:00 | Y | [NAME] | Quetta Gladiators | 148 | 90 | 1.61 | 2.3 | 1.61 | 1.61 | Fav | -61.00000000000001
2017-03-04 00:00:00 | 00:00:00 | Y | Karachi Kings | [NAME] | 157 | 181 | 1.73 | 2.14 | 1.73 | 2.14 | Dog | 95
2017-03-02 00:00:00 | 00:00:00 | Y | Islamabad United | [NAME] | 82 | 126 | 2.07 | 1.73 | 1.73 | 1.73 | Fav | -73
2017-03-01 00:00:00 | 00:00:00 | Y | [NAME] | Quetta Gladiators | 199 | 200 | 1.76 | 2.06 | 1.76 | 2.06 | Dog | 95
2017-02-27 00:00:00 | 00:00:00 |  | Islamabad United | [NAME] | 123 | 127 | 2.05 | 1.73 | 1.73 | 1.73 | Fav | -73
2017-02-26 00:00:00 | 00:00:00 |  | [NAME] | Quetta Gladiators | 130 | 128 | 1.77 | 2.07 | 1.77 | 1.77 | Fav | -77
2017-02-26 00:00:00 | 19:30:00 |  | Karachi Kings | Lahore Qalandars | 158 | 155 | 1.73 | 2.09 | 1.73 | 1.73 | Fav | -73
2017-02-25 00:00:00 | 00:00:00 |  | Islamabad United | Quetta Gladiators | 165 | 164 | 2.02 | 1.76 | 1.76 | 2.02 | Dog | 95
2017-02-25 00:00:00 | 19:30:00 |  | Lahore Qalandars | [NAME] | 149 | 166 | 1.69 | 2.1 | 1.69 | 2.1 | Dog | 95
2017-02-24 00:00:00 | 00:00:00 |  | Karachi Kings | Quetta Gladiators | 154 | 158 | 1.68 | 2.1 | 1.68 | 2.1 | Dog | 95
2017-02-21 00:00:00 | 00:00:00 |  | Islamabad United | Lahore Qalandars | 145 | 146 | 2.19 | 1.64 | 1.64 | 1.64 | Fav | -63.99999999999999
2017-02-20 00:00:00 | 00:00:00 |  | Karachi Kings | [NAME] | 174 | 165 | 1.83 | 1.92 | 1.83 | 1.83 | Fav | -83
2017-02-19 00:00:00 | 00:00:00 |  | Islamabad United | [NAME] | 137 | 136 | 1.89 | 1.85 | 1.85 | 1.89 | Dog | 95
2017-02-19 00:00:00 | 19:30:00 |  | Lahore Qalandars | Quetta Gladiators | 200 | 202 | 1.68 | 2.1 | 1.68 | 2.1 | Dog | 95
2017-02-18 00:00:00 | 00:00:00 |  | Islamabad United | Karachi Kings | 90 | 75 | 2.07 | 1.73 | 1.73 | 2.07 | Dog | 95
2017-02-18 00:00:00 | 19:30:00 |  | [NAME] | Quetta Gladiators |  |  | 1.83 | 1.92 | 1.83 | 1.92
2017-02-17 00:00:00 | 00:00:00 |  | Karachi Kings | Lahore Qalandars | 172 | 179 | 1.66 | 2.21 | 1.66 | 2.21 | Dog | 95
2017-02-16 00:00:00 | 00:00:00 |  | Islamabad United | Quetta Gladiators | 149 | 148 | 1.66 | 2.15 | 1.66 | 1.66 | Fav | -65.99999999999999
2017-02-13 00:00:00 | 00:00:00 |  | Lahore Qalandars | [NAME] | 59 | 60 | 1.9 | 1.82 | 1.82 | 1.82 | Fav | -82
2017-02-12 00:00:00 | 00:00:00 |  | Karachi Kings | Quetta Gladiators | 159 | 160 | 1.57 | 2.34 | 1.57 | 2.34 | Dog | 95
2017-02-12 00:00:00 | 19:30:00 |  | Islamabad United | Lahore Qalandars | 158 | 160 | 2.24 | 1.61 | 1.61 | 1.61 | Fav | -61.00000000000001
2017-02-11 00:00:00 | 00:00:00 |  | Karachi Kings | [NAME] | 118 | 119 | 1.67 | 2.16 | 1.67 | 2.16 | Dog | 95
2017-02-11 00:00:00 | 19:30:00 |  | Lahore Qalandars | Quetta Gladiators | 128 | 136 | 1.55 | 2.41 | 1.55 | 2.41 | Dog | 95
2017-02-10 00:00:00 | 00:00:00 |  | Islamabad United | [NAME] | 175 | 190 | 1.77 | 1.98 | 1.77 | 1.98 | Dog | 95
Spreadsheet: 816073d1675349737-how-to-remove-brackets-and-everything-inside-brackets-if-cell-meets-criteria-sample
Sheet: Sheet1

Details | Title | Size | Color | Is Primary
 | [NAME] | Small | Black | No
 | [NAME] | Medium | Black
 | [NAME] | Large | Black | Yes
 | [NAME] | X-Large | Black