tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 832886d1686654773-issue-with-part-of-an-let-function-with-a-if-and-formula-not-giving-correct-information-sample
Sheet: Formula

[NAME]
Spreadsheet: 759392d1639508919-excel-formula-to-check-match-data-between-two-sheet-in-different-orientation-upload
Sheet: Stata

YEAR | COMPANY | Net
1994 | TH:2S | NA
1995 | TH:2S | NA
1996 | TH:2S | NA
1997 | TH:2S | NA
1998 | TH:2S | NA
1999 | TH:2S | NA
2000 | TH:2S | NA
2001 | TH:2S | NA
2002 | TH:2S | NA
2003 | TH:2S | NA
2004 | TH:2S | NA
2005 | TH:2S | NA
2006 | TH:2S | 34020
2007 | TH:2S | 55390
2008 | TH:2S | 112840
2009 | TH:2S | 91864
2010 | TH:2S | 71431
2011 | TH:2S | 64980
2012 | TH:2S | 52643
2013 | TH:2S | 68031
2014 | TH:2S | 41898
1994 | TH:AJ | 21495
1995 | TH:AJ | 27384
1996 | TH:AJ | 52941
1997 | TH:AJ | -616760
1998 | TH:AJ | 121234
1999 | TH:AJ | -81609
2000 | TH:AJ | -51199
2001 | TH:AJ | 152305
2002 | TH:AJ | 352870
2003 | TH:AJ | 255651
2004 | TH:AJ | 240919
2005 | TH:AJ | 172836
2006 | TH:AJ | 102073
2007 | TH:AJ | 129639
2008 | TH:AJ | 160309
2009 | TH:AJ | 288052
2010 | TH:AJ | 984924
2011 | TH:AJ | 878600
2012 | TH:AJ | 190007
2013 | TH:AJ | -97977
2014 | TH:AJ | -247856
Spreadsheet: 261980d1377886669-concatenate-cells-with-5-characters-each-column-but-ignore-if-blank-concatenate
Sheet: Sheet1

CONCATENATE 1 "-" |  | CONCATENATE 2 "-" |  | CONCATENATE 3 "-" |  | CONCATENATE 4 "-" |  | RESULT
[NAME] | End Seg Value | 2nd Beg  Value | 2nd End Value | [NAME] | 3rd End Value | [NAME] | 4th Seg Value
BLK1 | BLK2 | BLK3 |  | BLK5 | BLK6 | BLK7 |  | 0BLK1-0BLK2 0BLK3 0BLK5-0BLK6 0BLK7
Spreadsheet: 55590d1255693844-excel-2007-vertical-to-horizontal-conversion-vlookup-performance-ordersubmit-copy
Sheet: Step1

OrderID Sort Magic | OrderID | Company | Contact Name | Address 1 | Address 2 | City | State | Zip Code | Country | Phone | [NAME] | Insurance Value | Notes | Service
Spreadsheet: 48255d1247502529-vlookup-problem-vlookup
Sheet: S Names

C | D | A
1100 | S1 | O
1125 | S2 | O
1150 | S3 | O
1180 | [NAME] | O
1190 | S5 | O
2700 | S6 | O
2725 | S7 | O
2850 | S8 | O
2875 | S9 | O
2876 | S10 | O
2900 | S11 | O
2925 | S12 | O
2975 | S13 | O
3100 | S14 | O
3101 | S15 | O
3102 | S16 | O
3115 | S17 | O
3130 | S18 | O
3135 | S19 | O
3275 | S20 | O
3700 | S21 | O
3800 | S22 | O
3900 | S23 | O
3950 | S24 | O
4200 | S25 | O
7700 | S26 | O
8000 | [NAME] | O
8150 | S28 | O
8200 | S29 | O
8300 | S30 | O
8400 | S31 | O
8500 | S32 | O
8600 | S33 | O
8700 | S34 | O
9000 | S35 | O
9001 | S36 | O
9002 | S37 | O
9650 | S38 | O
9900 | S39 | O
9980 | S40 | O
Spreadsheet: 678052d1589692070-index-match-for-auto-costings-calculations-jitterbug888_bizcostings-sample
Sheet: FUNCTIONS

list | DAY | WEEK | MONTH | QTR | BI-ANNUAL | YEAR |  | cost category
daily | 1 |  | 30 | 90 | 180 | 360 |  | business cost
weekly |  |  | 4 | 13 | 26 | 52 |  | businss loan
monthly |  |  | 1 | 3 | 6 | 12 |  | charity
quarterly |  |  |  | 1 | 2 | 4 |  | subscriptions
6 months |  |  |  |  | 1 | 2 |  | personal loan
yearly |  |  |  |  |  | 1 |  | other costs
2 years
3 years
4 years
5 years
paused
Spreadsheet: 677845d1589553095-how-to-display-data-from-jumped-multiple-sheet1-columns-e-g-a-and-d-and-g-in-sheet2-test-1-_v1
Sheet: m2

Invoice Number | Job Number | Details of charges | Revenue | Outlay
Spreadsheet: 268428d1380634275-how-to-use-if-to-pull-in-values-from-another-column-efrcocalm
Sheet: Sheet1

Header1 | Header2 | Formula1 | Formula2
a | Pre
b | Post
c | Pre
d | Pre
e | Post
f | Post
g | Pre
Spreadsheet: 89571d1289354024-drop-down-menus-fantasy-ball
Sheet: Sheet1

Player | pts | Rb | Ass | St | Bl | 3's | ft% | fg% | Total | ## | PG | SG | SF | PF | C
[NAME] | 13 | 10 | 10 | 11 | 8 | 7 | 10 | 9 | 78 | 13 |  |  | 1
[NAME] | 12 | 1 | 11 | 12 | 7 | 13 | 8 | 5 | 69 | 12 |  | 1
[NAME] | 7 | 12 | 9 | 2 | 9 | 5 | 9 | 11 | 64 | 11 |  |  |  | 1 | 1
[NAME] | 9 | 4 | 8 | 9 | 4 | 12 | 12 | 6 | 64 | 11 |  | 1
[NAME] | 10 | 8 | 5 | 9 | 11 | 5 | 5 | 10 | 63 | 9 |  |  |  | 1
[NAME] | 6 | 5 | 7 | 13 | 4 | 10 | 7 | 7 | 59 | 8 | 1 | 1
[NAME] | 11 | 7 | 13 | 10 | 4 | 6 | 6 | 2 | 59 | 8 | 1
[NAME] | 1 | 9 | 1 | 6 | 12 | 5 | 11 | 13 | 58 | 6 |  |  |  |  | 1
Blake Griffin | 9 | 13 | 6 | 9 | 5 | 5 | 1 | 8 | 56 | 5 |  |  |  | 1
Dj [NAME] | 4 | 3 | 12 | 4 | 4 | 10 | 13 | 1 | 51 | 4 | 1
Emeka Okafor | 3 | 11 | 2 | 1 | 13 | 5 | 3 | 12 | 50 | 3 |  |  |  |  | 1
[NAME] | 5 | 6 | 3 | 6 | 11 | 11 | 4 | 3 | 49 | 2 |  |  | 1 | 1
[NAME] | 2 | 2 | 4 | 4 | 6 | 8 | 2 | 4 | 32 | 1 |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 3 | 4 | 3
Player | Pts | Rb | Ass | St | Bl | 3's | FGM | FGA | FTM | FTA
[NAME] | 180 | 54 | 23 | 12 | 5 | 9 | 67 | 131 | 37 | 41
game 1
game 2
[NAME] | 131 | 18 | 30 | 12 | 2 | 18 | 44 | 96 | 25 | 29
game 1
game 2
[NAME] | 137 | 76 | 26 | 5 | 5 | 0 | 59 | 91 | 19 | 22
game 1
game 2
[NAME] | 138 | 31 | 19 | 6 | 0 | 18 | 51 | 110 | 18 | 20
game 1
game 2
[NAME] | 110 | 39 | 9 | 4 | 6 | 0 | 45 | 82 | 20 | 25
game 1
game 2
[NAME] | 99 | 25 | 13 | 15 | 0 | 11 | 36 | 74 | 16 | 19
[NAME] | 121 | 31 | 54 | 7 | 0 | 7 | 40 | 92 | 34 | 42
[NAME] | 43 | 49 | 1 | 4 | 9 | 0 | 13 | 16 | 17 | 19
Blake Griffin | 127 | 77 | 13 | 5 | 1 | 0 | 48 | 96 | 31 | 52
Dj [NAME] | 84 | 27 | 45 | 3 | 0 | 12 | 28 | 73 | 16 | 16
Emeka Okafor | 74 | 50 | 2 | 1 | 13 | 0 | 28 | 39 | 18 | 26
[NAME] | 98 | 34 | 6 | 4 | 7 | 15 | 35 | 84 | 13 | 18
[NAME] | 63 | 17 | 6 | 3 | 2 | 9 | 25 | 57 | 4 | 6
Spreadsheet: 709067d1608144183-report-values-between-2-sheets-cerca-vert-partic
Sheet: Sheet2

 |  |  |  | ordine | PZ | SETTIMANA 1
 |  |  |  | 1234 | 22 | ABC1 |  | ITALIA
 |  |  |  | 1234 | 22 | ABC1 |  | FRANCIA
 |  |  |  | 1235 | 22 | ABC3 |  | SPAGNA
 |  |  |  | 1237 | 22 | ABC1 |  | ITALIA
 |  |  |  | 1237 | 22 | ABC1 |  | FRANCIA
 |  |  |  | 1237 | 22 | ABC1 |  | GERMANIA
 |  |  |  | 4533 | 12 | DSC1 |  | SPAGNA
 |  |  |  | 4533 | 12 | DSC1 |  | FRANCIA
 |  |  |  | 4533 | 12 | DSC1 |  | GERMANIA
 |  |  |  | 3344 | 5 | EFG3 |  | FRANCIA
 |  |  |  | 8899 | 12 | [NAME] |  | ITALIA
 |  |  |  | 8899 | 12 | [NAME] |  | FRANCIA
 |  |  |  | 8899 | 12 | [NAME] |  | SPAGNA
 |  |  |  | 9999 | 12 | [NAME] |  | SPAGNA
 |  |  |  | 9999 | 12 | [NAME] |  | SPAGNA
 |  |  |  | 7788 | 12 | ABC5 |  | FRANCIA
 |  |  |  | 1237 | 33 | ABC1 |  | ITALIA
 |  |  |  | 1237 | 33 | ABC1 |  | FRANCIA
 |  |  |  | 789 | 12 | ABC5 |  | FRANCIA
 |  |  |  | 789 | 12 | DSC1 |  | SPAGNA
 |  |  |  | 789 | 12 | DSC1 |  | FRANCIA
 |  |  |  | 789 | 12 | DSC1 |  | FRANCIA
 |  |  |  | 148 | 24 | DSC2 |  | SPAGNA
 |  |  |  | 148 | 24 | DSC2 |  | SPAGNA
 |  |  |  | 99 | 24 | EFG1 |  | SPAGNA
 |  |  |  | 99 | 24 | EFG1 |  | SPAGNA
 |  |  |  | 24 | 24 | EFG2 |  | ITALIA
 |  |  |  | 33 | 24 | EFG2 |  | FRANCIA
 |  |  |  | 987 | 45 | EFG3 |  | FRANCIA
 |  |  |  | 85 | 12 | [NAME] |  | ITALIA
 |  |  |  | 85 | 12 | [NAME] |  | FRANCIA
 |  |  |  | 1237 | 33 | ABC1 |  | ITALIA
 |  |  |  | 1237 | 33 | ABC1 |  | FRANCIA
 |  |  |  | 99 | 24 | EFG1 |  | SPAGNA
Spreadsheet: 785475d1656433388-index-match-for-multiple-values-in-array-data
Sheet: ActionReasons (2)

Column1 | Column2 | Column3
Action | Reason | Reason Description (i.e. [NAME])
Data Adjustment | JED | Job Earnings Distribution
Data Adjustment | DAT | Date Adjustment
Hire | AST | Appointment Start Conversion
Hire | HIR | New Hire
Hire | CNV | Conversion
Hire | CNV | Conversion
Hire | CNV | Conversion
Job Change | RTC | Reports To Change
Job Change | ROT | Reduction of Teaching
Job Change | ERT | End Reduction of Teaching
Job Change | ARC | Academic Rank Change
Job Data Adjustment | UDJ | Job Data Update
Leave of Absence | ACD | Academic
Leave of Absence | NEG | Negotiated
Leave of Absence | TMP | Temporary Assignment
Leave of Absence | PER | General
Leave of Absence | PER | General
Leave of Absence | SWB | Short Work Break
Pay Change | CSA | Conversion Salary
Pay Change | SCI | Scale Increase
Pay Change | ASI | Academic Salary Increase
Pay Change | SAI | [NAME]
Pay Change | SPI | Step Increase
Pay Change | MER | Merit Increase
Position Change | PRU | Position Reclassification Up
Position Data Adjustment | UPD | Position Data Update
Rehire | REH | Rehire
Retirement | ERT | Early Retirement
Return from Leave | ACD | Academic
Return from Leave | NEG | Negotiated
Return from Leave | TMP | Temporary Assignment
Return from Leave | PER | General
Return from Leave | SWB | Short Work Break
Termination | JOB | End of Contract
Transfer | PRO | Promotion
Transfer | LTL | Lateral
Spreadsheet: 704860d1605786183-unwanted-ordering-columns-sample
Sheet: what i expect

ID | Property | Field | Value |  |  | ID | Property | colour | engine | version |  | ID | Property | colour | engine | version
1 | car | colour | X |  |  | 1 | car | X | X |  |  | 1 | car | X | X
1 | car | engine | X |  |  | 1 | - car1 |  |  | X |  | 1 | - car1 |  |  | X
1 | - car1 | engine |  |  | What I expect - > | 1 | - car2 |  |  | X |  | 1 | - car2 |  |  | X
1 | - car1 | version | X |  |  | 2 | car | X | X |  |  | 2 | car | X | X
1 | - car2 | version | X |  |  | 2 | - car1 |  | X |  |  | 2 | - car1 |  | X
2 | car | colour | X |  |  | 2 | - car2 |  |  | X |  | 2 | - car2
2 | car | engine | X
2 | - car1 | engine | X
2 | - car2 | version
Spreadsheet: 778765d1651306590-unable-to-get-index-match-to-make-data-from-one-worksheet-to-to-a-summary-worksheet-index-match-sample-file
Sheet: BT Investors Choice

This is the worksheet INTO which I want to pull data using INDEX/Match
to come FROM the Combined worksheet
 | Account Number | Bank Statement Order Number | Date |  |  |  |  |  | Expected Value
BT Investors Choice | 1026 |  | 2020-07-01 00:00:00 |  |  |  |  |  | 0
BT Investors Choice | 2180 |  | 2020-10-01 00:00:00 |  |  |  |  |  | 1
BT Investors Choice | 2180 |  | 2020-01-01 00:00:00 |  |  |  |  |  | 2
BT Investors Choice | 2180 |  | 2020-04-01 00:00:00 |  |  |  |  |  | 3
BT Investors Choice | 2180 |  | 2021-06-30 00:00:00 |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 1 |  | 44013
I am using the suggested formulae: |  |  |  |  |  |  |  |  | 2 | 1 | 44105
 | Expected Value |  |  |  |  |  |  |  | 3 | 2 | 43831
 | 1 |  |  |  |  |  |  |  | 4 | 3 | 43922
 | 1 |  |  |  |  |  |  |  | Blank | 4 | 44377
What am I doing incorrrectly in EACH formula?
Index | Expected Value
 | 0
 | 1
 | 2
 | 3
 | 4
 | Blank
Match | Expected Value
 | 0
 | 1
 | 2
 | 3
 | 4
 | Blank
 | Expected Value
 | 0
 | 1
 | 2
 | 3
 | 4
 | Blank
Spreadsheet: 8bedd06d-15c4-4963-a4e5-465d1a304ce6
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44474712 | 2014-12-16 23:01:17 | ALLIES | 0 | 5 | 6 | 642023 | [NAME] | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
44475173 | 2014-12-16 23:36:43 | AXIS | 1 | 6 | 3 | 642023 | [NAME] | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
Spreadsheet: 04fd88cc-ff8d-4ecb-9fc1-e7b34f3ead83
Sheet: Sheet1

Table 9--U.S. cotton textile exports, by destination | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Feb. | Mar. | Apr. |  | Apr.
Region/country | 2013 | 2013 | 2013 |  | 2012
 | 1,000 pounds 1/
North America | 113224.327 | 121121.766 | 117247.01 |  | 101248.096
Bahamas | 86.596 | 129.17 | 106.318 |  | 281.214
Canada | 8659.685 | 9233.424 | 10365.76 |  | 8996.319
Costa Rica | 171.939 | 364.467 | 246.946 |  | 199.209
Dominican Republic | 16711.35 | 17055.426 | 17554.287 |  | 17927.3
El Salvador | 10789.044 | 13156.602 | 10316.615 |  | 9246.243
Guatemala | 2540.559 | 2773.381 | 2971.156 |  | 2849.952
Haiti | 816.993 | 751.702 | 603.512 |  | 629.717
Honduras | 45831.215 | 50353.831 | 43939.094 |  | 37073.223
Jamaica | 98.532 | 174.977 | 89.045 |  | 91.947
Mexico | 25749.423 | 24749.035 | 28897.319 |  | 21961.391
Nicaragua | 1375.862 | 1840.126 | 1548.606 |  | 1364.042
Panama | 129.201 | 169.834 | 296.404 |  | 335.137
South America | 3684.424 | 3456.125 | 3323.286 |  | 2417.648
Brazil | 461.833 | 531.3 | 275.477 |  | 379.817
Chile | 180 | 182.96 | 565.706 |  | 451.813
Colombia | 2042.043 | 1993.958 | 1764.445 |  | 532.394
Peru | 356.737 | 287.014 | 292.124 |  | 325.808
Venezuela | 373.754 | 173.891 | 91.186 |  | 526.986
Europe | 2919.335 | 3337.19 | 2904.101 |  | 2756.668
Belgium | 203.35 | 254.531 | 201.127 |  | 240.639
France | 97.247 | 159.073 | 132.203 |  | 122.224
Germany | 455.53 | 501.735 | 510.902 |  | 444.172
Italy | 127.671 | 151.074 | 155.001 |  | 116.963
Netherlands | 389.53 | 470.241 | 475.201 |  | 339.737
Russia | 62.512 | 78.056 | 67.085 |  | 54.471
Turkey | 47.434 | 72.275 | 55.031 |  | 38.075
United Kingdom | 1078.039 | 1128.288 | 805.758 |  | 973.847
Asia | 19088.564 | 18243.016 | 17373.065 |  | 7910.147
China | 15924.417 | 13737.203 | 13762.11 |  | 4075.864
Hong Kong | 381.75 | 717.87 | 545.224 |  | 573.708
India | 102.093 | 119.394 | 157.04 |  | 148.595
Israel | 103.73 | 248.291 | 119.419 |  | 261.95
Japan | 892.33 | 1099.579 | 907.679 |  | 854.931
Pakistan | 100.122 | 5.332 | 9.149 |  | 28.32
Saudi Arabia | 122.511 | 195.459 | 67.842 |  | 124.62
Singapore | 100.697 | 210.527 | 223.189 |  | 233.022
South Korea | 389.963 | 581.105 | 552.299 |  | 626.873
Taiwan | 87.874 | 155.436 | 97.534 |  | 119.811
United Arab Emirates | 238.539 | 455.867 | 294.269 |  | 284.401
Oceania | 702.022 | 904.327 | 813.657 |  | 586.049
Australia | 547.243 | 735.432 | 640.059 |  | 467.765
Africa | 223.448 | 273.673 | 298.052 |  | 253.156
South Africa | 53.649 | 29.769 | 42.392 |  | 59.382
World 2/ | 139842.121 | 147336.096 | 141959.172 |  | 115171.764
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update: 06/14/13.
Spreadsheet: 689579d1596529697-shade-cells-in-staff-rota-if-staff-are-at-work-rota-edit-copy-copy
Sheet: Rota

WEEK A |  |  |  |  |  |  |  |  | WEEK B
Name |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Staff A |  | 10:30-12 | x | x | x | x | x | 11.15-6.45 | x | x | x | x | x | x | 11.15-6.45
Staff B |  | 9-4.15 | x | x | x | x | x | 11.30-6.45 | 9-4.15 | x | x | x | x | x | 11.30-6.45
Staff C |  | x | x | 8.15-4.45 | 8-4.30 | 10.15-6.45 | 8-4.30 | 8.15-4.45 | x | 10.15-6.45 | 8.15-4.45 | 8-4.30 | 10.15-6.45 | 8-4.30 | x
Staff D |  | 9-4.15 | x | x | x | x | x | x | 9-4.15 | x | x | x | x | x | x
Staff E |  | x | 8-5 | 8.30-5.30 | 9.45-6.45 | 8.15-5.15 | 8.30-5.30 | x | x | 8-5 | x | 9.45-6.45 | 8.15-5.15 | 9.45-6.45 | 8.15-5.15
Staff F |  | 11-3 | 11.30-6.45 | 9.45-5 | 8-3.15 | 10.30-5 | x | 8.15-4.45 | x | 11.30-6.45 | 11.30-6.45 | 8-3.15 | 10.30-5 | x | x
Staff G |  | 9-1 | 9-5.30 | 10.15-6.45 | 8.30-5 | 10.15-6.45 | 8-4.30 | x | x | 8-4.30 | 10.15-6.45 | x | 8.15-16.45 | 9-5.30 | 8.15-4.45
Staff H |  | 10:15-5 | 8-1.30 | 9-2.30 | x | 9.30-3.30 | 1.15-6.45 | 9-2 | x | 9-2.30 | 9.30-3.30 | 9-2 | 1.15-6.45 | 8-1.30 | x
Staff I |  | x | 3.45-6.45 | 8.15-1.45 | 3.45-6.45 | 8.15-12.15 | 9-2.30 | x | x | x | 8.15-12.45 | 2.45-6.45 | 9.30-2 | 10-2.30 | 9-1
Staff J |  | 10-3 | x | 9.45-6.45 | 9-6 | x | 9.45-6.45 | x | x | x | 9-6 | 9-6 | x | 9.45-6.45 | x
Staff K |  | 9-6 | 9.30-6 | 8.30-5 | x | 9-5.30 | 10.15-6.45 | 10.15-6.45 | 10-4.15 | x | 10.30-6.45 | 9-5.30 | 8.30-5 | 8-4.30 | x
 |  |  | 6 | 8 | 6 | 7 | 7 | 6 |  | 5 | 7 | 7 | 7 | 7 | 5
Spreadsheet: eric_saibi__9742__011402R
Sheet: Palisades 01

Owner Name |  | Consumers Energy
Station Name |  | Palisades Nuclear Power
Unit Name |  | Palisades 01
NERC Region |  | ECAR
State |  | MI
Fuel Type |  | Nuclear
Capacity |  | 812 MW
Start Date |  | 2001-06-20 00:00:00
End Date |  | 2002-02-03 00:00:00
Prv. Start Date |  | 2001-06-20 00:00:00
Prv. End Date |  | 2002-01-14 00:00:00
Comments |  | They are hoping to be back on-line by late Jan. or early Feb.
SIC |  | 4911
Plant ID |  | 100363
Unit ID |  | 1004300
Outage ID |  | 17046
Spreadsheet: 770260d1645963013-tune-working-macro-in-order-makinmomb-rept-to-sort-alphabetically-aligw
Sheet: Sheet1

DLNAEIA
DLRAEIA
DLSAEIA
DLTAEIA
LNRAEIA
LNSAEIA
LNTAEIA
NRDAEIA
NRSAEIA
NRTAEIA
RSDAEIA
RSLAEIA
RSTAEIA
STDAEIA
STLAEIA
STNAEIA
DRTAEIA
LRTAEIA
Spreadsheet: 48315d1247557160-perform-formatting-problem-button
Sheet: Sheet2

Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | 2009-07-07 18:14:36
Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | 2009-07-07 18:14:39
Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Spreadsheet: 6263c4bb-6cb5-46d8-a66c-471cd878254d
Sheet: SW097

SW | SUV | PS# | Ln | Item | Description | UOM | $ | Cat | Cat Desc
[NAME] | Kiamichi | 3156 | 1 |  | MACARONI:100% pure semolina fl~Macaroni Cut 100% pure semolina flour salt & water only container must be water proof, must be purchased in 20# boxes.~CUT, 100% PURE SEMOLINE FLOUR SALT & WATER ONLY CONTAINER MU |  | 18.25 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 2 |  |  |  | 17.6 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 3 |  |  |  | 9.5 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 4 |  |  |  | 13 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 5 |  |  |  | 12.3 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 6 |  |  |  | 0.01 |  | Freight Fee
[NAME] | Kiamichi | 3156 | 7 | 1000029779 | [NAME]:Egg #2 10lb (subject to availability, call vendor (580) 326-7548) |  | 7.7 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 8 | 1000029780 | PASTA:Macaroni #2 20lb (subject to availability,call vendor (580) 326-7548) |  | 12.1 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 9 | 1000029781 | PASTA:Spaghetti #1 10lb |  | 8.3 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 10 | 1000029782 | PASTA:Spaghetti #2 20lb (subject to availablity,call vendor (580) 326-7548) |  | 12.1 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 11 | 1000029770 | PASTA:Rotini #1 10lb |  | 8.7 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 12 | 1000029771 | PASTA:Rotini #1 20lb |  | 17.4 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 13 | 1000029772 | PASTA:Rotini #2 20lb (subject to availability, call vendor (580) 326-7548) |  | 12.1 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 14 | 1000029773 | PASTA:Penne #1 10lb |  | 8.7 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 15 | 1000029774 | PASTA:Penne #1 20lb |  | 17.4 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 16 | 1000029775 | PASTA:Penne#2 20lb (subject to availability, call vendor (580) 326-7548) |  | 12.1 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 17 | 1000029776 | PASTA:Ziti #1 10lb |  | 8.7 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 18 | 1000029777 | PASTA:Ziti #1 20lb |  | 17.4 |  | Shelf Stable Plain Pasta or [NAME]
[NAME] | Kiamichi | 3156 | 19 | 1000029778 | PASTA:Ziti #2 20lb (subject to availability,call vendor (580) 326-7548) |  | 12.1 |  | Shelf Stable Plain Pasta or [NAME]
Spreadsheet: 688041d1595536786-counting-columns-based-on-criteria-dates-match-column-data-exampler2
Sheet: Sheet2

2020-07-20 00:00:00 | 2020-08-03 00:00:00 | 2020-08-17 00:00:00 | 2020-08-31 00:00:00 |  | Yes | No | Yes | No
 |  |  |  |  | No | Yes | No | Yes
 |  |  |  |  | No | Yes | No | Yes
 |  |  |  |  | Yes | No | Yes | No
 | [NAME] |  | YESNO |  | No | Yes | No | Yes
 |  |  |  |  | No | Yes | No | Yes
 |  |  |  |  | Yes | No | Yes | No
YE |  | Ye |  |  | No | Yes | No | Yes
 |  |  | YOYO |  | No | Yes | No | Yes
 |  |  |  |  | Yes | No | Yes | No
 |  |  |  |  | No | Yes | No | Yes
 |  | Yessir |  |  | No | Yes | No | Yes
Spreadsheet: 92482d1292033091-vlookup-help-dummy
Sheet: Sheet1

Name | [NAME] | Phone
Person1 | Email1 | 111111111
Person2 | Email2 | 222222222
Person3 | Email3 | 333333333
Person4 | Email4 | 444444444
Person5 | Email5 | 555555555
Person6 | Email6 | 666666666
Person7 | Email7 | 777777777
Person8 | Email8 | 888888888
Person9 | Email9 | 999999999
Spreadsheet: 708234d1607684825-non-consecutive-count-sample-workbook
Sheet: DEC 1

SARS RD | ADP | MARKET ROAD | OPM | SHELL ESTATE | PIPE LINE | AIRPORT | IGWURITA | IGWURUTA ROAD | ELIMGBU | TOTAL | MBAK | IDORO ROAD | AKA ROAD | IBB AVENUE | INDONGESIT NKANGA | SIR UDO UDOMA
SS | SS | SS | 2.4 | 0.4 | 2 | 0.5 | 0 | SS | SS |  | NS | NS | SS | SS | SS | SS
SS | SS | SS | 2.3 | 0.4 | LS | 0.4 | 0 | SS | SS |  | NS | NS | SS | SS | SS | SS
SS | SS | SS | 2.3 | 0.4 | LS | 0.4 | 0 | SS | SS |  | NS | NS | SS | SS | SS | SS
SS | SS | SS | 2.3 | 0.4 | LS | 0.4 | 0 | 4.8 | LS |  | NS | NS | SS | SS | SS | SS
LS | LS | 3.5 | 2.7 | 0.4 | 2.4 | 0.5 | 0 | 4.8 | LS |  | NS | NS | LS | LS | 0.2 | LS
LS | LS | 4 | LS | 0.4 | 2.6 | 0.4 | 0 | 5 | LS |  | NS | NS | LS | EF | 0.2 | LS
LS | 4.1 | LS | LS | 0.4 | 2.5 | 0.7 | 0 | LS | 4.7 |  | NS | NS | LS | EF | 0.2 | 2.6
LS | 3.5 | LS | LS | 0.4 | EF | 0.7 | 0 | LS | 4.2 |  | NS | NS | LS | 4.1 | 0.3 | 2.5
3 | LS | LS | 2.8 | 0.4 | EF | 1 | 0 | SS | SS |  | NS | NS | LS | 3.8 | 0.3 | 2.5
2.6 | LS | LS | 2.9 | 0.4 | EF | 1.7 | 0 | SS | SS |  | NS | NS | LS | 3.6 | 0.2 | 2.6
NS | NS | NS | NS | NS | NS | 1.8 | 0 | SS | SS |  | NS | NS | LS | LS | 0.2 | 2.5
NS | NS | NS | NS | NS | NS | 1.7 | 0 | 4.4 | LS |  | NS | NS | LS | LS | 0.1 | 2.7
NS | NS | NS | NS | NS | NS | 1.8 | 0 | NS | NS |  | NS | NS | 4.8 | LS | 0.1 | LS
NS | NS | NS | NS | NS | NS | 1.8 | 0 | NS | NS |  | NS | NS | 4.6 | LS | 0.2 | LS
NS | NS | NS | NS | NS | NS | 1.8 | 0 | NS | NS |  | NS | NS | 4.8 | LS | 0.2 | LS
NS | NS | NS | NS | NS | NS | 1.4 | 0 | 4.7 | LS |  | NS | NS | 4.8 | LS | 0.1 | LS
NS | NS | NS | NS | NS | NS | 0.9 | 0 | NS | NS |  | NS | NS | LS | LS | 0.2 | LS
NS | NS | NS | NS | NS | NS | NS | 0 | NS | NS |  | NS | NS | LS | LS | 0.2 | LS
SS | SS | SS | SS | SS | SS | 0.8 | 0 | NS | NS |  | NS | NS | LS | LS | 0.2 | LS
LS | LS | 4.7 | LS | 0.7 | 3.3 | 0.8 | 0 | NS | NS |  | NS | NS | LS | 4.4 | 0.3 | LS
LS | LS | 4.6 | LS | 0.6 | 3.2 | 0.8 | 0 | NS | NS |  | NS | NS | EF | 4.2 | 0.2 | 2.3
3.3 | 3.6 | LS | LS | 0.5 | 3 | 0.7 | 0 | Ns | NS |  | NS | NS | EF | 3.5 | 0.3 | 2.3
3.2 | 3.5 | LS | LS | 0.5 | 2.8 | 0.6 | 0 | NS | NS |  | NS | NS | EF | NS | NS | NS
2.9 | 3.3 | LS | LS | 0.4 | 2.7 | 0.5 | 0 | NS | NS |  | NS | NS | EF | SS | SS | SS