tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 757886d1638495764-formula-help-example
Sheet: Example

Cat 1 | Cat 2 | Cat 3 | Cat 4 | Cat 5 | FINAL OUTCOME |  | Dissatisfaction | Cat 1 | Cat 2 | Cat 3 | Cat 4 | Cat 5
Acceptable | Acceptable | Acceptable | Acceptable | Acceptable | Dissatisfaction |  | Acceptable
Acceptable | Poor | Acceptable | Acceptable | Acceptable | Dissatisfaction |  | Exceptional
Acceptable | Poor | Poor | Acceptable | Poor | Dissatisfaction |  | Poor
Exceptional | Exceptional | Exceptional | Poor | Acceptable | Positive
Acceptable | Poor | Poor | Poor | Poor | Dissatisfaction |  | Positive | Cat 1 | Cat 2 | Cat 3 | Cat 4 | Cat 5
Acceptable | Acceptable | Exceptional | Acceptable | Poor | Dissatisfaction |  | Acceptable
Poor | Acceptable | Exceptional | Exceptional | Exceptional | Neutral |  | Exceptional
Exceptional | Exceptional | Exceptional | Exceptional | Exceptional | Positive |  | Poor
 |  |  |  |  |  |  | Neutral | Cat 1 | Cat 2 | Cat 3 | Cat 4 | Cat 5
 |  |  |  |  |  |  | Acceptable
 |  |  |  |  |  |  | Exceptional
 |  |  |  |  |  |  | Poor
Spreadsheet: 840714d1692910234-conditional-formatting-for-average-above-or-below-20-variance-excel-forum-demo
Sheet: Sheet1

 |  | % Completed |  |  | Average
 |  | 0.8889 | 0.2409
 |  | 0 | -0.648
 |  | 0 | -0.648
 |  | 0.6 | -0.048
 |  | 0.7 | 0.052
 |  | 0.3125 | -0.3355 | <-----
 |  | 0.5714 | -0.0766
 |  | 0.6667 | 0.0187
 |  | 0.6296 | -0.0184
 |  | 0.75 | 0.102
 |  | 1 | 0.352
 |  | 1 | 0.352
 |  | 0.7143 | 0.0663
 |  | 1 | 0.352
 |  | 0.875 | 0.227
 |  | 0.9565 | 0.3085
 |  | 0.2 | -0.448 | <------
 |  | 0.5 | -0.148
 |  | 0.6667 | 0.0187
 |  | 1 | 0.352
 |  | 0.9091 | 0.2611
 |  | 0 | -0.648
 |  | 1 | 0.352
 |  | 0.8 | 0.152
 |  | 0.5 | -0.148
 |  | 0.875 | 0.227
 |  | 0.75 | 0.102
 |  | 0.6875 | 0.0395
 |  | 1 | 0.352
 |  | 0.5 | -0.148
 |  | 0.3333 | -0.3147
 |  | 1 | 0.352
 |  | 0.6667 | 0.0187
 |  | 1 | 0.352
 |  | 0.25 | -0.398 | <------
 |  | 0.75 | 0.102
 |  | 0 | -0.648
 |  | 0.6 | -0.048
 |  | 0.75 | 0.102
 |  | 0.5385 | -0.1095
 |  | 0.5 | -0.148
 |  | 0.6667 | 0.0187
 |  | 0.9677 | 0.3197
 |  | 0.48 | -0.168
 |  | 0.6154 | -0.0326
 |  | 0.9167 | 0.2687
 |  | 0 | -0.648
 |  | 1 | 0.352
 |  | 0.7727 | 0.1247
 |  | 0.5 | -0.148
 |  | 0.6667 | 0.0187
 |  | 1 | 0.352
 |  | 0.5 | -0.148
 |  | 0.6667 | 0.0187
 |  | 0.9375 | 0.2895
 |  | 0.6 | -0.048
 |  | 1 | 0.352
 |  | 0.5 | -0.148
 |  | 1 | 0.352
 |  | 1 | 0.352
 |  | 0.8667 | 0.2187
 |  | 0 | -0.648
 |  | 0.875 | 0.227
 |  | 0.4 | -0.248
 |  | 0.6667 | 0.0187
 |  | 0.4 | -0.248
 |  | 0 | -0.648
 |  | 1 | 0.352
 |  | 0.7059 | 0.0579
 |  | 0.4 | -0.248
 |  | 0.7778 | 0.1298
 |  | 0.75 | 0.102
 |  | 0.25 | -0.398 | <----
 |  | 0.8421 | 0.1941
 |  | 0.6364 | -0.0116
 |  | 0.3333 | -0.3147 | <-----
 |  | 0.6923 | 0.0443
 |  | 0.7143 | 0.0663
Spreadsheet: 115041d1310669251-concatenate-different-number-of-rows-help-concatenate-rows
Sheet: Sheet1

Current Data:
R6789 | This
 | Is an
 | Example
R7689 | This Is
 | An Example
R4532 | This
 | Is
 | An
 | Example
R1254 | This is An Example
Desired Output:
R6789 | This is an example
R7689 | This is an example
R4532 | This is an example
R1254 | This is an example
Spreadsheet: 721687d1614817111-excel-if-function-record-sheet-2021
Sheet: Students

 | Students
 | List
 | [NAME], [NAME]
 | [NAME], [NAME]
 | Branch, Canaan
 | Branch, Gideon
 | [NAME], [NAME]
 | Brown, Lorelai
 | Brown, Savannah
 | [NAME], Ariella
 | Exposito, Arleigh
 | [NAME], [NAME]
 | Fawcett, [NAME]
 | Hawthorne, [NAME]
 | Hawthorne, [NAME]
 | Herron, [NAME]
 | King, Taryn
 | [NAME], Addison
 | Norrick, Zechariah
 | O’Brien, Kayla
 | Podnar, [NAME]
 | Richardson, Stella
 | [NAME], [NAME]
 | Russo, [NAME]
 | Scheuvront, Chloe
 | Scheuvront, Peyton
 | [NAME], [NAME]
 | Tausch, Avery
 | [NAME], [NAME]
 | Weimer, [NAME]
 | Wells, [NAME]
 | Yoder, Lola
Spreadsheet: 293482d1391003447-auto-populate-a-column-based-on-a-drop-down-choice-from-another-column-2014-special-events-cost-tracking
Sheet: Sheet1

Event Name |  | Date |  | Officers Assigned |  | Hours |  | Rate | Cost
[NAME]
 |  | 2014-02-08 00:00:00 |  | [NAME] |  | 12
 |  | 2014-02-08 00:00:00 |  | [NAME] |  | 12
 |  | 2014-02-08 00:00:00 |  |  |  | 12
 |  | 2014-02-09 00:00:00 |  |  |  | 12
 |  | 2014-02-09 00:00:00 |  |  |  | 12
 |  | 2014-02-09 00:00:00 |  |  |  | 12
 |  | 2014-02-10 00:00:00 |  |  |  | 4
 |  | 2014-02-10 00:00:00 |  |  |  | 4
 |  | 2014-02-11 00:00:00 |  |  |  | 4
 |  | 2014-02-11 00:00:00 |  |  |  | 4
 |  | 2014-02-12 00:00:00 |  |  |  | 4
 |  | 2014-02-12 00:00:00 |  |  |  | 4
Spreadsheet: 730154d1619573147-autopopulating-a-table-using-a-dropdown-and-data-from-another-table-excel-help
Sheet: Example

Table 1
Class Number | Class Name | Class ID | Test Number | Test ID | Test Name | Location | Result Number | [NAME] | Result Type | Day Students | Night School | [NAME]
[NAME] | Psychology | PSY | PSY-1 | [PSY] SKINNER | [PSY] Behavior Skinner | Class/Vir | [PSY] SKINNER-1 | Psych, Skinner, Fail | Fail | 0.935 | 0.529 | 15
[NAME] | Psychology | ACS | PSY-1 | [PSY] SKINNER | [PSY] SKINNER | Class/Vir | [PSY] SKINNER-2 | Psych, [NAME], Pass | Pass | 0.935 | 0.529 | 15
CS-2 | Algebra | ALG | ALG-1 | [ALG] FACTOR | [ALG] Factoring Lesson 1 | Virtual | [ALG] FACTOR-1 | Algeb, Factor, Fail | Fail | 0.859 | 0.722 | 10
CS-3 | Algebra | ALG | ALG-1 | [ALG] FACTOR | [ALG] Factoring Lesson 1 | Virtual | [ALG] FACTOR-2 | Algeb, Factor, Pass | Pass | 0.677 | 0.898 | 10
CS-2 | Algebra | ALG | [NAME] | [ALG] QUAD | [ALG] Quadratic Equation 1 | Classroom | [ALG] QUAD-1 | Algeb, Quad, Fail | Fail | 0.933 | 0.531 | 18
[NAME] | Algebra | ALG | [NAME] | [ALG] QUAD | [ALG] Quadratic Equation 1 | Classroom | [ALG] QUAD-2 | Algeb, Quad, Pass | Pass | 0.933 | 0.531 | 18
CS-4 | Theater | THTR | THTR-1 | [THTR] SHAKE | [THTR] [NAME] (Comedies) | Class/Vir | [THTR] SHAKE-1 | Theat, Shake, Fail | Fail | 0.944 | 0.646 | 7
CS-3 | Theater | THTR | THTR-1 | [THTR] SHAKE | [THTR] Shakespear (Comedies) | Class/Vir | [THTR] SHAKE-2 | Theat, Shake, Pass | Pass | 0.944 | 0.646 | 7
CS-3 | Theater | THTR | THTR-2 | [THTR] SHAKE | [THTR] Shakespear (Tragedy) | Classroom | [THTR] SHAKE-3 | Theat, Shake, Fail | Fail | 0.904 | 0.382 | 9
CS-3 | Theater | THTR | THTR-2 | [THTR] SHAKE | [THTR] Shakespear (Tragedy) | Virtual | [THTR] SHAKE-4 | Theat, Shake, Pass | Pass | 0.904 | 0.382 | 9
Class ID | THTR
Class Name | Test Name | Location | [NAME] | [NAME] | Day Students | Night School | Result Type
Class ID | THTR
Table 3
Class Name | Test Name | Location | [NAME] | [NAME] | Day Students | Night School | Result Type
 | [THTR] [NAME] (Comedies) | Class/Vir | Theat, Shake, Fail | 7 | 0.944 | 0.646 | Fail
 | [THTR] Shakespear (Comedies) | Class/Vir | Theat, Shake, Pass | 7 | 0.944 | 0.646 | Pass
 | [THTR] Shakespear (Tragedy) | Classroom | Theat, Shake, Fail | 9 | 0.904 | 0.382 | Fail
 | [THTR] Shakespear (Tragedy) | Virtual | Theat, Shake, Pass | 9 | 0.904 | 0.382 | Pass
Spreadsheet: larry_campbell__21077__expense report SAP 12b-2000
Sheet: Short Form

 |  |  | Enron Corp
 |  |  | Employee Expense Report |  |  |  |  |  |  |  |  | EXP | 2000-11-15 00:00:00
 |  |  | Short Form |  |  |  |  |  |  | Page | 1 | of
LAST NAME |  |  |  | FIRST NAME, INITIAL |  |  | TITLE |  |  | EMPLOYEE NUMBER
Campbell |  |  |  | [NAME], T |  |  | Division Environmental  Specialist |  |  | P00505622
COMPANY NUMBER |  |  |  | OFFICE NUMBER/FIELD LOCATION |  |  |  |  |  | PHONE NUMBER FOR QUESTIONS
0060 |  |  |  | 0325   [NAME], New Mexico |  |  |  |  |  | (505) 625-8022
MEALS AND ENTERTAINMENT -  Enter the cost of all meals (including food charges from hotel receipts) and entertainment.  Attach guest list for entertainment expense.
Meal: B = Breakfast, L = Lunch, D = Dinner, R = Refreshments, T = Travel Status.  See the Accounts Payable information page at http://hrweb.enron.com/accts/index.asp for detailed instructions.
Date | Meal |  | Location and Business Purpose |  |  |  | Guests |  |  |  | Cost/Quantity | Rate | $ [NAME]
ACCOUNT CODING - For multiple lines of coding, use supplemental page. |  |  |  |  |  |  |  |  |  |  | MEALS THIS PAGE
GL Acct      Asset | GL Co       Tr Ptr |  | Cost Center                  WBS Element |  |  | Order                                      Network |  | Material        Activity | Plant                            Func Area |  | MEALS, SUPP PAGES
 |  |  |  |  |  |  |  |  |  |  | TOTAL MEALS
[NAME] all other expenses (memberships, fees, supplies, mileage, etc.) not associated with business transportation or lodging.
Date |  |  |  |  | Description |  |  |  |  |  | Cost/Quantity | Rate | $ [NAME]
ACCOUNT CODING - For multiple lines of coding, use supplemental page. |  |  |  |  |  |  |  |  |  |  | MISC THIS PAGE
GL Acct      Asset | GL Co       Tr Ptr |  | Cost Center                  WBS Element |  |  | Order                                      Network |  | Material        Activity | Plant                            Func Area |  | MISC., SUPP PAGES
 |  |  |  |  |  |  |  |  |  |  | TOTAL MISC
This section used in conjunction with all expense reports. |  |  |  |  |  |  |  |  | Total Travel  (attach Summary)
ADVANCES TO BE CLEARED |  |  |  |  |  |  |  |  | Total Expenses (travel, entertainment, [NAME].)
DATE |  | CO. |  | AMOUNT |  |  |  |  | Less: Total Advances
DATE |  | CO. |  | AMOUNT |  |  |  |  | Balance Due: |  |  | Company
DATE |  | CO. |  | AMOUNT |  |  |  |  |  |  |  | Employee
 |  |  | TOTAL ADVANCES |  |  |  |  |  | Personal Check Amount
SIGNATURES
I have paid the amount shown on this statement for necessary expenses incurred on behalf of the Company.  Original receipts are attached or have been mailed to Accounts Payable.
EMPLOYEE |  |  |  |  | DATE | APPROVAL |  |  |  | DATE | APPROVAL |  | DATE
Revised 7/1/00 |  |  |  |  |  | (Print Name) |  |  |  |  | (Print Name)
lname | fname | expdate | socsec | bal | code | sform | trav | mealsup | miscsup | travsup2 | mealsup2 | miscsup2 | cono
 |  |  |  |  | 1 | 2
Spreadsheet: joe_parks__14772__bridgeline 4-11
Sheet: Sheet1

b/s | contract | price | volume | time | cm | account | cti | order # | trader | reference | trade #
S | NGK2 | 3107 | 30 | 08:10:30 | 905 | 97563 | 4C | 4431 | amk | EO-4431 | 1670 | 0 | N
S | NGK2 | 3112 | 25 | 08:22:08 | 905 | 97563 | 4C | 4500 | amk | EO-4500 | 1707 | 0 | N
S | NGK2 | 3130 | 42 | 06:56:14 | 905 | 97563 | 4C | 3994 | amk | EO-3994 | 1441 | 0 | N
S | NGK2 | 3130 | 20 | 06:56:14 | 905 | 97563 | 4C | 3994 | amk | EO-3994 | 1442 | 0 | N
B | NGK2 | 3143 | 10 | 20:05:24 | 905 | 97563 | 4C | 2597 | amk | EO-2597 | 709 | 0 | Y
S | NGM2 | 3150 | 12 | 08:08:00 | 905 | 97563 | 4C | 4414 | amk | EO-4414 | 1660 | 0 | N
S | NGM2 | 3155 | 7 | 08:07:49 | 905 | 97563 | 4C | 4413 | amk | EO-4413 | 1659 | 0 | N
Spreadsheet: phillip_allen__28859__pivot_1210
Sheet: pivot

Category2 | (All)
Description | (All)
Vendor | (All)
Written | (All)
Type | Operating
Year | 2000
Sum of Amount | Cleared
Category | January | February | March | April | May | June | July | August | November | October | September | December | Grand Total | December | 2000 Total
Income | 16199.83 | 22900.35 | 16804.24 | 17109.79 | 18488.41 | 22300.72 | 18268.54 | 23837.8 | 300 | 23183.55 | 18308.53 | 300 | 198001.76 | 20000
Labor | -1815 | -2726 | -2789 | -2410 | -3368.1 | -2867 | -2520 | -2220 |  | -2120 | -2662 |  | -25497.1 | -2400
Materials | -1890.81 | -2191.02 | -2027.02 | -1750.33 | -1761.7 | -1916.26 | -1911.93 | -1711 |  | -2056.63 | -1066.83 |  | -18283.53 | -2000
Services | -66.69 | -47.41 | -47.41 | -52.78 | -311.96 | -53.43 | -651.16 | -464.41 |  | -292.51 | -1172.41 |  | -3160.17 | -150
Utilities | -3675.44 | -5081.28 | -3857.15 | -3933.72 | -3633.04 | -3133.21 | -3658.34 | -5441.89 |  | -5634.56 | -4891.67 |  | -42940.3 | -5000
Taxes/Insurance | -11639.77 |  |  |  |  |  |  | -4071.58 |  |  |  |  | -15711.35
Grand Total | -2887.88 | 12854.64 | 8083.66 | 8962.96 | 9413.61 | 14330.82 | 9527.11 | 9928.92 | 300 | 13079.85 | 8515.62 | 300 | 92409.31
Spreadsheet: 94455d1294261380-conditional-formatting-help-book1
Sheet: Sheet1

Product (Column A) | Rating (Column B) | Description (Column C)
a | 10 | Excellent
b | 8 | Very Good
c | 7 | Good
d | 6 | Good
e | 5 | Average
f | 2 | Poor
Spreadsheet: 456810d1461072917-nested-if-and-vlookup-nested-if
Sheet: Sheet1

ID# | Count | Attribute | Answer | Count of Response | All Answers Available | Final | final (formula)
27625 |  |  |  | 0 | 0 | 0 |  | 1.  Totals for "Final" are for each different value in column A value
27651 |  |  |  | 0 | 0 | 0 |  | 2.  Count of response (column e) counts total of column A for each different value in A
27621 |  |  |  | 0 | 0 | 0 |  | 3.  All Answers (column F) column are vlookup pulled from another spreadsheet
27418 | 1 | Racks | YES | 1 |  | 1
27419 | 1 | Type Off | Home | 6 |  | 1
27419 |  | Type Off | Work | 6 |  | 0 |  | So what I need is a formula that says:
27419 |  | Type Off | Store | 6 |  | 0
27419 |  | Type Off | Military | 6 |  | 0 |  | At each different value in column A
27419 |  | Type Off | Club | 6 |  | 0 |  | And if column B has the value "1"
27419 |  | Type Off | Warehouse/Club | 6 |  | 0 |  | And if column E is not equal and less than column F (see formula in "F" to see if we can roll it into this formula)
27420 | 1 | Type Off | Home | 6 |  | 1 |  | So all my final answers in column G should be a 1 or blank (can we also hide the zero)
27420 |  | Type Off | Work | 6 |  | 0
27420 |  | Type Off | Store | 6 |  | 0
27420 |  | Type Off | Military | 6 |  | 0
27420 |  | Type Off | Club | 6 |  | 0
27420 |  | Type Off | Warehouse/Club | 6 |  | 0
27851 | 1 | Display | 4-5 Case | 4 |  | 0
27851 |  | Display | 6-2 Case | 4 |  | 0
27851 |  | Display | 0 to 3 Case | 4 |  | 0
27851 |  | Display | Mass Displays | 4 |  | 0
27857 | 1 | Display | 4-5 Case | 4 |  | 0
27857 |  | Display | 6-2 Case | 4 |  | 0
27857 |  | Display | Bin to 3 Case | 4 |  | 0
27857 |  | Display | Mass Displays | 4 |  | 0
27864 | 1 | Display | 4-5 Case | 4 |  | 0
27864 |  | Display | 6-2 Case | 4 |  | 0
27864 |  | Display | Bin to 3 Case | 4 |  | 0
27864 |  | Display | Mass Displays | 4 |  | 0
27871 | 1 | Type Off | Home | 6 |  | 0
27871 |  | Type Off | Work | 6 |  | 0
Spreadsheet: 113823d1309706258-pull-column-from-one-sheet-to-another-affiliated-new-order-book
Sheet: MISC

Order | Item # | UPC # | Name | Cost | % |  | # of Items | SRP
0 | 68248 | 0-154000-01146 | BUTCHER WRAP | 30.27
1 | 68487 | 0-00000-00000 | ICE BAG DRAWSTRING - 8lb | 70.38
2 | 60447 | 0-41594-26580 | DART CUP TRVL 32AJ20E | 53.22 | 0 |  | 400
0 | 63158 | 0-41594-20010 | DART CUP 16 oz 16J16 | 47.06 | 0 |  | 100
0 | 69183 | 0-41594-20071 | DART CUP 12 oz 12J16 | 37.13 | 0 |  | 100
0 | 63149 | 0-41594-20075 | DART CUP 20 oz 20J16 | 28.69 | 0 |  | 500
0 |  |  | DART LID 16UL | 18.29 | 0 |  | 100
1 | 63169 | 0-41594-20061 | Dart Lid 32 [NAME] | 19.63 | 0 |  | 500
0 | 61709 | 6-99320-35004 | [NAME] LARGE | 1.02 | 0 |  | 100
0 | 62841 | 0-70052-55091 | CAN LINER 55 GL NATURAL H
0 | 61130 | 0-48200-59810 | RPP SALT PACKET PC
0 | 68654 | 0-48200-80235 | RPP PEPPER PACKET PC
0 | 34819 | 7-19098-40000 | RPP SUGAR PKT .10 OZ
0 | 50340 | 0-48200-58755 | RPP SWEETNER PINK
0 | 59437 | 0-48200-37678 | RPP YELLOW PACKET SWEETEN
0 | 58454 | 0-21000-66371 | KRAFT PC MIRACLE WHIP
0 | 61136 | 0-13000-98480 | HNZ/FA TOMATO CATSUP
0 | 61148 | 7-16037-60415 | RPP PICANTE SAUCE
0 | 61418 | 7-16037-41570 | PPI TACO SAUCE 9 GR
0 | 43811 | 0-13000-53060 | HNZ SS MUSTARD PKT
0 | 60318 | 0-41330-60318 | STRAW WRAPPED JUMBO
1 | 68404 | 0-15400-07162 | GROCERY BAG - 2 LB |  | 0.25
1 | 68408 | 0-15400-07164 | GROCERY BAG - 6 LB |  | 0.25
1 | 68410 | 0-15400-07165 | GROCERY BAG - 8 LB |  | 0.25
1 | 68416 | 0-15400-07169 | GROCERY BAG - 25 LB |  | 0.25
1 |  | 63137 | Wrap Deli Wax Interfold 12x10.7
0 |  |  | Perferated Meat Film
Spreadsheet: 46959d1245870396-combine-several-spreadsheets-into-one-vendor-documents-register-p01-20090622
Sheet: BEA

No. | P.O. No. | Submitted Date | Tansmittal No. | [NAME]) | Vendor Document No. | Document Title | Latest Version | Vendor | Status | Comments (Y,N) | Transmittal Returned By Eng.Dept | Status | Date | Transmittal Returned by Company | Status | Date | Remarks
1 | 3435-510-PO-0056A | 2008-10-01 00:00:00 | WIP-PCU-ENG-TN-0206 | 3435-560-P-CA-BEA-00010 | DDR-080-0200-301 | Mechanical calculation for automatic backwash filter | P00 | BEA | A | Y | 见Remarks |  |  | EOL-G-TN-CPP-G-368-0926 | IFI | 2008-10-06 00:00:00 | 设计意见见业主意见
2 | 3435-510-PO-0056A | 2008-10-01 00:00:00 | WIP-PCU-ENG-TN-0206 | 3435-560-P-CA-BEA-00011 | DDR-080-0200-302 | Mechanical calculation for cartridge filter | P00 | BEA | A | Y | 见Remarks |  |  | EOL-G-TN-CPP-G-368-0926 | IFI | 2008-10-06 00:00:00 | 设计意见见业主意见
3 | 3435-510-PO-0056A | 2008-10-01 00:00:00 | WIP-PCU-ENG-TN-0206 | 3435-560-P-DP-BEA-00003 | DWG-080-0200-002 | General arrang. With foundation layout loading plan for Automatic backwash filters | P00 | BEA | A | Y | 见Remarks |  |  | EOL-G-TN-CPP-G-368-0926 | RWC | 2008-10-06 00:00:00 | 设计意见见业主意见
4 | 3435-510-PO-0056A | 2008-10-01 00:00:00 | WIP-PCU-ENG-TN-0206 | 3435-560-P-DP-BEA-00007 | DWG-080-0200-020 | General arrang. With foundation layout loading plan for Cartridge filters | P00 | BEA | A | Y | 见Remarks |  |  | EOL-G-TN-CPP-G-368-0926 | RWC | 2008-10-06 00:00:00 | 设计意见见业主意见
5 | 3435-510-PO-0056A | 2008-10-24 00:00:00 | WIP-PCU-ENG-TN-0247 | 3435-510-A-ED-BEA-00001 | GEN-080-0200-601 | Suppler document list for filters | P01 | BEA | A | Y | WIP-PCU-ENG-TN-0247 Comments | D | 2008-10-28 00:00:00
6 | 3435-510-PO-0056A | 2008-10-24 00:00:00 | WIP-PCU-ENG-TN-0247 | 3445-510-P-QB-BEA-00026 | PCQ -080-0200-551 | Quality control plan for automatic backwash filter | P00 | BEA | A | Y | WIP-PCU-ENG-TN-0247 Comments | D | 2008-10-28 00:00:00 | EOL-G-TN-CPP-G-368-0982 | RWC | 2008-10-28 00:00:00
7 | 3435-510-PO-0056A | 2008-10-24 00:00:00 | WIP-PCU-ENG-TN-0247 | 3445-510-P-QB-BEA-00027 | PCQ -080-0200-552 | Quality control plan for cartridge filters | P00 | BEA | A | Y | WIP-PCU-ENG-TN-0247 Comments | D | 2008-10-28 00:00:00 | EOL-G-TN-CPP-G-368-0982 | RWC | 2008-10-28 00:00:00
Spreadsheet: juan_hernandez__17553__NERC Training Schedule
Sheet: Sheet1

NERC Certification Training
Teams: | Beginning Date | Room Location
#1, [NAME], [NAME], | 2000-09-18 00:00:00 | Classroom 3109 |  |  | Swapped [NAME] and [NAME] because [NAME]
[NAME], [NAME], [NAME], | 2000-09-25 00:00:00 | Sample Testing |  |  | was not going to be in house.08/23/00
[NAME], [NAME], [NAME].
#2 , [NAME], [NAME], | 2000-10-02 00:00:00 | Classroom 3109 |  |  | Check w/[NAME] about [NAME] and available
[NAME], [NAME], | 2000-10-09 00:00:00 | Sample Testing |  |  | space for PC usage?
[NAME], [NAME],[NAME]
[NAME], Dean Laurent
 |  |  |  |  | Have [NAME] book a room for the training period
#3, [NAME], [NAME], | 2000-10-16 00:00:00 | Classroom 3109
Chad Starnes, [NAME], | 2000-10-23 00:00:00 | Sample Testing
[NAME], [NAME], [NAME]
#4 [NAME], [NAME], | 2000-10-30 00:00:00 | Classroom 3109
[NAME], Russel Ballato, [NAME], | 2000-11-06 00:00:00 | Sample Testing
[NAME], Alton
#5 Cyril Price, [NAME], [NAME], | 2000-11-13 00:00:00 | Classroom 3109
[NAME], [NAME], [NAME] | 2000-11-20 00:00:00 | Sample Testing
[NAME],[NAME]
Note: The training is structured as:
Week one will consist of classroom training from 08:00 until 04:00. A copy of the NERC book will be
issued on the first day of class. Planned for Monday through Friday.
Week two NERC sample test will be taken. This will be performed in a classroom
setting with one practice test a day for a duration of 2-3 hours.
You will then report to your work station.
A large amount of information will be covered in a short time. To make the most of our classroom
time together please eat and use the restroom before leaving the house since there will not be any
scheduled breaks for such time consuming activities.Thanks for your support on this matter.
Spreadsheet: 814217d1674228229-combine-multiple-functions-into-a-single-formula-test-combine-two-formulas-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1,18 | 1,10 | 3,4 | 4,8,14,21 | 8,10,15,19 | 1,14,23,24 |  |  | 1,18 | 1,10 | 3,4 | 4,8,14,21 | 8,10,15,19 | 1,14,23,24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 | 8 | 0 | 50 | 35
Line | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z
1 | 18 | 2 | 2 | 22 | 0 | 2 | 1 | 2 | 1 | 3 | 1 | 2 | 1 | 3 | 26 | 2 | 0 | 22 | 0 | 22 | 2 | 32 | 2 | 4 | 2 | 2
2 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 2 | 1 | 4 | 24 | 0 | 0 | 2 | 0 | 2 | 1 | 3 | 2 | 5 | 0 | 0
3 | 10 | 2 | 2 | 222 | 0 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 24 | 0 | 2 | 2 | 0 | 2 | 1 | 3 | 1 | 5 | 0 | 2
4 | 12 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 0 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0
5 | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 2 | 1 | 22 | 1 | 4 | 2 | 0
6 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 20 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0
7 | 15 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0
8 | 18 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0
9 | 8 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 24 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 2
10 | 14 | 2 | 2 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 12 | 0 | 2 | 22 | 0 | 2 | 1 | 22 | 2 | 3 | 0 | 2
11 | 14 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 4 | 0 | 22
12 | 18 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 28 | 2 | 0 | 2 | 0 | 2 | 1 | 32 | 2 | 5 | 2 | 2
13 | 20 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 25 | 0 | 0 | 22 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 22
14 | 24 | 2 | 2 | 222 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 22
15 | 8 | 2 | 0 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 22 | 0 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 2
16 | 18 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 0
17 | 22 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 0
18 | 24 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 3 | 2 | 5 | 21 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 0
19 | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 16 | 2 | 2 | 22 | 0 | 0 | 0 | 22 | 1 | 3 | 2 | 0
Spreadsheet: 41909d1240451916-working-with-large-list-of-company-names-need-a-bar-chart-perhaps
Sheet: Sheet1

names
apstudio
Anatomical Travelogue
Ansys Fluent India Pvt Ltd
AMI
amsah
AlpineSoft
Apprender
AlpineSoft
Alpha Square LLC
Applanix
Apple Inc.
apstudio
Alsdorf
amsah
Ansys Fluent India Pvt Ltd
Alpha Square LLC
AMD Japan
Applied Acoustics Systems DVM Inc.
AMnesty
alpha medium group
AMD
Applied Materials
AMnesty
Alsdorf
AMD
apple
Altera
Alpha Square LLC
Anatomical Travelogue
Alpine
alpha medium group
Apprender
apstudio
AMI
altibase
anonym
Apprender
alpha medium group
amsah
Anatomical Travelogue
Amphora
Applied Materials
Anonymous
Altera
amf
AMD India
Applanix
AMD India
AMST
Alpine
AMD Japan
Anita Grant Ltd
Anita Grant Ltd
Alpine
Amphora
AMST
anonym
Apprender
aardvark
Amphora
apstudio
AMnesty
Apple Inc.
altibase
Anonymous
AMI
AMST
Ansys Fluent India Pvt Ltd
anonym
apple
Applied Materials
Anita Grant Ltd
Alsdorf
aardvark
Applanix
amf
Applied Materials
AMD India
Altera
AMD Japan
Applied Acoustics Systems DVM Inc.
Applied Acoustics Systems DVM Inc.
altibase
AlpineSoft
Apple Inc.
AMD
amf
Anonymous
[NAME]
Spreadsheet: 169420d1342816249-formula-for-counting-conditional-on-unique-values-uploaded-excel-formula
Sheet: Data Lists

Location | Distributors | Type
USA | A | Inside
India | B | Outside
Ireland | C | Exhibit
Spain | D | International
 | E | Skills
 | F | Video
 | G | Two Day
 | H | Three Day
 | I | Sales
 | J
 | K
 | L
 | M
 | N
 | O
 | P
 | Q
 | R
 | S
 | T
 | U
 | V
 | W
 | X
 | Y
 | Z
 | AA
 | BB
 | CC
 | DD
 | EE
 | FF
 | GG
 | HH
 | II
 | JJ
 | KK
 | LL
 | MM
 | NN
 | OO
Spreadsheet: 152214d1335288087-dynamic-entries-in-excel-book1_bliby
Sheet: Sheet1

Type | attachment | linking | qc pass | outbox
online | X |  | X
dummy |  | X |  | X
forms | Y
forms | Y
online | X |  | X
dummy |  | X |  | X
forms | Y
forms | Y