tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 29575d1224661922-locking-formulas-master
Sheet: Drawings

 | Job No: | 0
 | Main Contractor | 0
 | Site | 0
 | Descripion | #N/A
Drawings
Date | Name | Drawing Description | Hours | Cost per/hr | Total Cost
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  | Total Cost To Date |  | 0
Spreadsheet: monika_causholli__28184__Bank of America Report
Sheet: Sheet1

Major Pulp Producers
BOA Report-June 2001
Estimated 2001 Global Capacities of Selected Market Pulp Producers.
Company | Capacity | [NAME]
Others | 16547
Weyerhaeuser | 2290
Tembec | 2180
G-P | 2167
[NAME] | 2000
IP | 1995
Arauco | 1330
Canfor | 1315
APRIL | 1300
P & W | 1279
Bowater | 1259
[NAME] | 1240
[NAME] | 1059
[NAME] | 1030
Empresas CMPC | 1000
Asia P&P | 850
Ence | 825
Cenibra | 800
Millar Western | 730
Rayonier | 720
Rottneros AB | 700
Total
Spreadsheet: 92114d1291774821-relative-formula-copied-across-worksheets-can-i-use-the-coding-pencilss
Sheet: 1

 |  |  |  | m | t | w | t | f |  | weekly | yearly
 | pencils |  |  | 2 | 2 | 3 | 5 | 6
 | erasers |  |  | 1 | 1 | 1 | 1 | 1
Spreadsheet: 162445d1339886113-help-with-calculations-in-a-meal-plan-menucopy
Sheet: Mon

5 | Monday
Meal 1 | Servings | [NAME] |  | Cals (kcal) | [NAME] (g) | [NAME] (g) | Protein (g) | Carb (g) | [NAME] (mg) | Sodium (mg) | Fiber (g) | Sugars (g)
Fiber One Frosted Shredded Wheat Cereal | 1 | 1 | Cup | 229 | 1 | 0 | 5 | 50 | 0 | 0 | 9 | 12
[NAME] Start Light Multi-Grain | 1 | 1 | Muffin | 133 | 1 | 0 | 5 | 26 | 0 | 180 | 8 | 1
Morning Star Maple Flavored Sausage Patties | 1 | 1 | Pattie | 87 | 3 | 0.5 | 10 | 5 | 0 | 250 | 1 | 2
Total | Meal 1 | Goal | Over | 449 | 5 | 0.5 | 20 | 81 |  | 430 | 18 | 15
Percent of Calories |  | 407 | 42 | 1.103194103194103 | 0.1002227171492205 | 0.01002227171492205 | 0.178173719376392 | 0.7216035634743875 |  | 0.1791666666666667 | 0.6 | 0.1271186440677966
Meal 2 | Servings | [NAME] |  | Cals (kcal) | [NAME] (g) | [NAME] (g) | Protein (g) | Carb (g) | [NAME] (mg) | Sodium (mg) | Fiber (g) | Sugars (g)
Weight Watcher's Cheese | 2 | 1 | Stick | 101 | 5 | 2 | 12 | 2 | 10 | 300 | 0 | 0
Sun-Maid Organic Raisins | 1 | 1.5 | Oz. | 136 | 0 | 0 | 1 | 33 | 0 | 10 | 2 | 30
Total | Meal 2 | Goal | Under | 237 | 5 | 2 | 13 | 35 | 10 | 310 | 2 | 30
Percent of Calories |  | 407 | -170 | 0.5823095823095823 | 0.189873417721519 | 0.0759493670886076 | 0.219409282700422 | 0.5907172995780591 | 0.03333333333333333 | 0.1291666666666667 | 0.06666666666666667 | 0.2542372881355932
Meal 3 | Servings | [NAME] |  | Cals (kcal) | [NAME] (g) | [NAME] (g) | Protein (g) | Carb (g) | [NAME] (mg) | Sodium (mg) | Fiber (g) | Sugars (g)
Nature's Own Double Fiber Wheat Bread | 2 | 1 | Slice | 137 | 1 | 0 | 6 | 26 | 0 | 270 | 10 | 2
[NAME] | 1 | 6 | Slice | 45 | 1 | 0 | 8 | 1 | 20 | 370 | 0 | 0
Yoplait Light Fat Free Yogurt | 1 | 1 | Container | 96 | 0 | 0 | 5 | 19 | 5 | 85 | 0 | 14
Apple | 1 | 1 | Apple | 84 | 0 | 0 | 0 | 21 | 0 | 0 | 2 | 16
Orange | 1 | 1 | Orange | 108 | 0 | 0 | 2 | 25 | 0 | 3 | 7 | 0
Strawberries | 1 | 1 | Cup | 89 | 1 | 0 | 2 | 18 | 0 | 2 | 5 | 11
Total | Meal 3 | Goal | Over | 470 | 2 |  | 21 | 92 | 25 | 728 | 19 | 32
Percent of Calories |  | 407 | 63 | 1.154791154791155 | 0.03829787234042553 |  | 0.1787234042553192 | 0.7829787234042553 | 0.08333333333333333 | 0.3033333333333333 | 0.6333333333333333 | 0.2711864406779661
Spreadsheet: 870979d1717448753-all-data-in-one-line-needs-to-be-sorted-into-separate-entries-of-the-same-id-for-excel-forum
Sheet: Tab 2 - Format I need

RecordID
1 | QU_1 | I love this website | Agree
1 | QU_2 | I  am a fan of bonjovi | Disagree |  | I need a formula that will be abel to take the date in the format in Tab 1 to give me a format in this [NAME] (Tab 2)
1 | QU_3 | I live in the UK | Agree
1 | QU_4 | I do not get sea sick | Disagree
1 | QU_5 | I am dog lover | Agree
1 | QU_6 | I drive a car | Agree
1 | QU_7 | I love my job | Agree
1 | QU_8 | I have a smarphone | Not sure
1 | QU_9 | my laptop is old | Agree
1 | QU_10 | I love going to the cinemas | Agree
2 | QU_1 | I love this website | Disagree
2 | QU_2 | I  am a fan of bonjovi | Not sure
2 | QU_3 | I live in the UK | Disagree
2 | QU_4 | I do not get sea sick | Not sure
2 | QU_5 | I am dog lover | Agree
2 | QU_6 | I drive a car | Not sure
2 | QU_7 | I love my job | Not sure
2 | QU_8 | I have a smarphone | Not sure
2 | QU_9 | my laptop is old | Agree
2 | QU_10 | I love going to the cinemas | Disagree
3 | QU_1 | I love this website | Agree
3 | QU_2 | I  am a fan of bonjovi | Disagree
3 | QU_3 | I live in the UK | Disagree
3 | QU_4 | I do not get sea sick | Disagree
3 | QU_5 | I am dog lover | Disagree
3 | QU_6 | I drive a car | Not sure
3 | QU_7 | I love my job | Disagree
3 | QU_8 | I have a smarphone | Agree
3 | QU_9 | my laptop is old | Agree
3 | QU_10 | I love going to the cinemas | Agree
4
4
4
4
4
4
4
4
4
4
5
5
5
5
5
5
5
5
5
5
6
6
6
6
6
6
6
6
6
6
Spreadsheet: 599000d1542816223-event-on-off-status-help-event-tracker
Sheet: Std. DDG51 Configuration 1EVENT

DATE TIME | DATE | TIME (24 hr) | EVENT | START/STOP | Column1
 | 2018-01-01 00:00:00 | 0 | A | START
 | 2018-01-01 00:00:00 | 1 | B | START
 | 2018-01-01 00:00:00 | 2 | A | STOP
 | 2018-01-01 00:00:00 | 5
 | 2018-01-01 00:00:00 | 6 | A | START
 | 2018-01-01 00:00:00 | 10 | A | STOP
 | 2018-01-01 00:00:00 | 55 | B | STOP
 | 2018-01-01 00:00:00 | 1502
Spreadsheet: 792832d1661183101-want-to-make-simple-dynamic-dashboard-example-1-
Sheet: valid email

Sl no. | [NAME] | Valid
Spreadsheet: joe_parks__14774__bridgeline 4-16
Sheet: Sheet1

b/s | contract | price | volume | time | cm | account | cti | order # | trader | reference | trade #
B | NGK2 | 3425 | 5 | 15:43:36 | 905 | 97563 | 4C | 1130 | [NAME] | EO-1130 | 102 | 0 | Y
B | NGK2 | 3460 | 14 | 07:51:09 | 905 | 97563 | 4C | 3931 | [NAME] | EO-3931 | 1863 | 0 | N
B | NGK2 | 3460 | 10 | 07:51:09 | 905 | 97563 | 4C | 3931 | [NAME] | EO-3931 | 1864 | 0 | N
B | NGK2 | 3460 | 2 | 07:51:50 | 905 | 97563 | 4C | 3937 | [NAME] | EO-3937 | 1868 | 0 | N
B | NGK2 | 3460 | 31 | 07:51:50 | 905 | 97563 | 4C | 3937 | [NAME] | EO-3937 | 1869 | 0 | N
B | NGK2 | 3460 | 10 | 07:56:03 | 905 | 97563 | 4C | 4010 | amk | [NAME] | 1968 | 0 | N
S | NGK2 | 3425 | 20 | 08:55:52 | 905 | 97563 | 4C | 4631 | [NAME] | [NAME] | 2541 | 0 | N
Spreadsheet: 70309d1271098914-excel-want-to-calculate-based-on-text-entry-to-a-call-excel_test
Sheet: Sheet1

Name | Weekdays | Weekend | Bank holiday | [NAME] | Mark
[NAME] | 1
Mark | 1
Mark | 1
[NAME] |  | 1
[NAME] |  | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
Mark | 1
[NAME] | 1
Refer to bit highlighted in yellow
So we will say weekday rate is 20 euro
If [NAME] entered in cell B8 and weekday set as 1, it should popluateboth  cell F8 with 20 euro ( [NAME] )  and also cell G8 with 20 Euro ( for mark )
Spreadsheet: 795251d1662575593-color-cells-of-one-sheet-based-on-contents-from-multiple-other-sheets-mconry-class-schedule
Sheet: Course Schedule

 | Monday | Tuesday | Wednesday | Thursday | Friday
08:00:00 |  | Class 6 | Class 11 | Class 16 | Class 21
08:30:00 | Class 1 | Class 6 | Class 11 | Class 16 | Class 21
09:00:00 | Class 1 | Class 6 | Class 11 | Class 16 | Class 21
09:30:00
10:00:00 | Class 2 | Class 7 | Class 12 | Class 17 | Class 22
10:30:00 | Class 2 | Class 7 | Class 12 | Class 17 | Class 22
11:00:00 | Class 2 | Class 7 | Class 12 | Class 17 | Class 22
11:30:00
12:00:00 | Class 3 | Class 8 | Class 13 | Class 18 | Class 23
12:30:00 | Class 3 | Class 8 | Class 13 | Class 18 | Class 23
13:00:00 | Class 3 | Class 8 | Class 13 | Class 18 | Class 23
13:30:00
14:00:00 | Class 4 | Class 9 | Class 14 | Class 19 | Class 24
14:30:00 | Class 4 | Class 9 | Class 14 | Class 19 | Class 24
15:00:00 | Class 4 | Class 9 | Class 14 | Class 19 | Class 24
15:30:00
16:00:00 | Class 5 | Class 10 | Class 15 | Class 20 | Class 25
16:30:00 | Class 5 | Class 10 | Class 15 | Class 20 | Class 25
17:00:00 | Class 5 | Class 10 | Class 15 | Class 20 | Class 25
Spreadsheet: 588325d1535560209-creating-categories-based-on-order-of-test-completion-samplework
Sheet: Desired Result

ID | Date | Test | Slot | Description of the Slot Column
1 | August 20, 2018 at 10:49 AM (MDT) | Math | 1 | This chunk did Math then English, then Science (based on their date of test completion), so they get categorized into Slot 1
1 | August 24, 2018 at 01:03 PM (MDT) | English | 1
1 | August 24, 2018 at 12:41 PM (MDT) | Science | 1
2 | August 20, 2018 at 10:49 AM (MDT) | Math | 2 | This chunk did Math then Science, then English so they get categorized into Slot 2
2 | August 24, 2018 at 01:03 PM (MDT) | Science | 2
2 | August 24, 2018 at 12:41 PM (MDT) | English | 2
Spreadsheet: 888728d1739299077-sum-lookups-across-multiple-tabs-using-dynamic-formulas-demand-planning
Sheet: 9160

 | NAME |  |  | Building Project 3 |  |  |  |  |  | Fund |  |  | Unfunded |  |  | OPP |  |  | 9160 |  |  | VALUE |  |  | 60000
 | [NAME] |  |  |  |  |  |  |  |  | PYRAMID |  |  |  |  |  |  |  |  | PHOTO
 | M2 |  |  | 1200
 | ASM Lead
 | Status
 | High/Low Rise
 | New Build/Retrofit
 | No. Blocks/Houses
 | Houses per Week
 | Access Method
 | [NAME]
 | PROGRAMME (mmm-yy) |  |  | INSTALLER APPOINTMENT |  |  |  | ENABLING |  |  |  | ACCESS INSTALLATION |  |  |  | STRIP OFF |  |  |  | WINDOW REPLACEMENT |  |  |  | EWI START
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-09-01 00:00:00
 | SYSTEM |  |  | FINISH |  |  | INSULATION |  |  | THICKNESS |  |  | SUPPLY SOURCE |  |  | # BOARDS |  |  | SYSTEM TTW/m2 |  |  | DURATION |  |  | BOARDS/MONTH
 | OTHER KML MANUFACTURED COMPONENTS (Estimate Only) |  |  |  |  |  |  |  |  | NOTES on INSULATION AVAILABILITY |  |  |  |  |  |  |  |  | NOTES on FINISHES (Colour References)
 | BASECOATS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 | FINISHES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | Can they take direct shipments? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | Vehicle type required? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 | NOTES on PROGRAMME DELAYS
 | Material Demand Plan - Essential Items
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | Item Code |  |  |  | Item Description |  |  |  |  |  |  |  |  |  | Unit of Sale |  |  | Qty in Job |  |  | Start Taking |  |  | Duration
 | Component 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Board |  |  | 1000 |  |  | 2025-10-01 00:00:00 |  |  | 5 |  |  |  |  | 200 | 200 | 200 | 200 | 200
 | Component 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Board |  |  | 300 |  |  | 2025-10-01 00:00:00 |  |  | 5 |  |  |  |  | 100 |  | 150 |  | 50
 | Component 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Board |  |  | 600 |  |  | 2025-11-01 00:00:00 |  |  | 5 |  |  |  |  |  | 100 | 100 | 100 | 100 | 100 | 100
 | Component 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | Board |  |  | 200 |  |  | 2026-01-01 00:00:00 |  |  | 5 |  |  |  |  |  |  |  | 25 | 25 | 25 | 25
 | Component 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | Board |  |  | 100 |  |  | 2026-04-01 00:00:00 |  |  | 2 |  |  |  |  |  |  |  |  |  |  | 50 | 50
Spreadsheet: 211424d1359741933-leaving-a-cell-blank-unless-referenced-cells-contain-a-value-time-card-ref
Sheet: Sheet1

 | Day | Date | Start | End | Lunch | Vacation | Personal | Total
 | Sunday |  | 0 | 0 | 0 | 0 | 0
 | Monday |  | 0 | 0 | 0 | 0 | 0
 | Tuesday |  | 0 | 0 | 0 | 0 | 0
 | Wednesday |  | 0 | 0 | 0 | 0 | 0
 | Thursday |  | 0 | 0 | 0 | 0 | 0
 | Friday |  | 0 | 0 | 0 | 0 | 0
 | Saturday |  | 0 | 0 | 0 | 0 | 0
 | Total hours
Spreadsheet: 295539d1391719468-sorting-by-column-a-name-col-b-has-multiple-rows-sorting-question
Sheet: Sheet1

 | Name | Instructions |  |  | I want to use sort on Name alphabetically without changing the instruction order.
 | Anthology company | Select 124
 |  | Report by Campaign Name
 |  | Enter 0's for AV campaign
 | Basket Company | Select 101
 |  | Report by [NAME]
 |  | Enter impressions
 | Dairy Company | Select 121
 |  | Report by Campaign Name
 |  | Enter impressions
 |  | Enter clicks
 | Colgate Company | Select 2301
 |  | Report by Campaign Name
 |  | Enter impressions
Spreadsheet: 63461d1264383392-need-to-modify-some-x-axis-labels-in-pivot-chart-sampledata
Sheet: Sheet1

Bugs | Component | Cars
1 | L2 | Saab
2 | L3 | Chevrolet
3 | L2 | Dodge
4 | [NAME] | Ford
5 | L5 | Porsche
6 | [NAME] | VW
7 | L2 | [NAME]
8 | L3 | Pontiac
9 | L2 | Citroen
10 | [NAME] | FIAT
Spreadsheet: sara_shackleton__36558__Legal Agreements Status
Sheet: Sheet1

Date | Type | Company | Broker | Requested by | Priority | Comments
2000-12-05 00:00:00 | Electronic Trading Agreement | ECT Investments | [NAME], LLC | [NAME]
2000-12-06 00:00:00 | Electronic Trading Agreement | ECT Investments | Merrill Lynch | [NAME]
 | Electronic Trading Agreement | ECT Investments | Bear Stearns | [NAME] | HIGH
 | Electronic Trading Agreement | ECT Investments | JP Morgan | [NAME] | HIGH
 | Electronic Trading Agreement | ECT Investments | Salomon Smith Barney Inc | [NAME]
2000-05-19 00:00:00 | Executing Broker Agreement | ECT Investments | Frost Securities
2000-06-01 00:00:00 | Executing Broker Agreement | ECT Investments | ING Barrings - Furman Selz
2000-07-10 00:00:00 | Executing Broker Agreement | ECT Investments | Lehman Brothers
2000-07-13 00:00:00 | Executing Broker Agreement | ECT Investments | Jefferies & Co
2000-08-08 00:00:00 | Executing Broker Agreement | ECT Investments | Simmons & Co
2000-08-31 00:00:00 | Executing Broker Agreement | ECT Investments | [NAME] |  | HIGH
2000-09-22 00:00:00 | Executing Broker Agreement | ECT Investments | Deutsche Bank Securities
2001-01-10 00:00:00 | Executing Broker Agreement | ECT Investments | ITG
 | Executing Broker Agreement | ECT Investments | [NAME]
 | Executing Broker Agreement | ECT Investments | Salomon Smith Barney Inc |  |  | Executed per legal's lotus notes
 | Options [NAME] | ECT Investments | Goldman Sachs
 | Letter of Guarantee | ENA | Bear Stearns | [NAME] | HIGH
 | Stock Loan Agreement | ENA | Bear Stearns | [NAME] | HIGH
Spreadsheet: 60155d1260702077-annual-summary-with-categories-and-matching-example
Sheet: Monthly Cost

Country | Item | Date | Cost
X | A | 2009-06-01 00:00:00 | 10
 | B | 2009-07-01 00:00:00 | 5
 | D | 2009-07-01 00:00:00 | 10
Y | A | 2008-06-01 00:00:00 | 20
 | C | 2009-06-01 00:00:00 | 10
 | E | 2009-08-01 00:00:00 | 5
Spreadsheet: 83414d1283403482-problem-w-formula-and-empty-cells-staff-schedule-0830-0905
Sheet: Layout2

 | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat |  | Sun |  | Total hours
NAMES | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out
Employee1 | 16:00:00 | 22:00:00 | 22:00:00 | 06:00:00 |  |  |  |  | 11:00:00 | 15:00:00 |  |  | 17:00:00 | 20:00:00 | 21
Employee2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Employee3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Employee4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Employee5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Employee6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Employee7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: daren_farmer__6544__hpl0118
Sheet: Sheet1

HPLN0118.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective January 18 , 2000
 |  |  |  |  |  | ** Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-01-18 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM | VOLUME
Enron / HPL (FM) |  | LS HPL- [NAME] |  | HPL | 30 | 0 | *
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | Delhi TOG #3 |  |  | 5 | 5
Empire (Enron) |  | [NAME]. |  |  | 8 | 8
Empire (Enron) |  | Oasis Turine |  |  | 4 | 4
Empire (Enron) |  | Sterling Plant |  |  | 1 | 1
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 861508d1709384767-if-statement-not-differentiating-between-blank-cell-and-a-zero-test-formula-blank-zero
Sheet: Sheet1

 |  | BIKES ARE SHIPPABLE IF  MAP VALUES ARE 0  OR  blank IN COL E
 |  | USING FORMULA IN COL G AND H  --------------------------------------> |  |  |  | =IF($E6=0,"SHIPPABLE","") | =IF($E6="","SHIPPABLE","")
 |  |  |  |  |  | [NAME]
 |  | SKU | PRODUCT | MAP |  | FOR  0 IN COL E | FOR  blank IN  COL E
 |  | SPEC223 | BIKE2 | 0
 |  | SPEC453 | BIKE 4
 |  | SPEC998 | BIKE88 | 123
 |  | SPEC124 | BIKE67 | 0
 |  | SPEC889 | BIKE33
 |  | SPEC654 | BIKE99 | 567
 |  | PROBLEM :  FORMULA DOESN’T DIFFERENTIATE BETWEEN 0 AND A BLANK IN COLUMN  E
 |  | THE FORMULA WORKS OK  in COL H
 |  | [NAME] : FORMULA TO USE IN COL G TO RETURN "SHIPPABLE" FOR A BLANK IN COL E
Spreadsheet: 122124d1316622977-help-with-barcodes-searching-and-returning-cursors-helpme1
Sheet: Sheet1

 |  |  | DAILY RUN/LOAD SHEET
 |  |  |  |  | RUN |  |  |  | ITEM
 |  |  |  |  |  |  |  |  | PDA | FLUKE | DRILL | F FIX
 | ZONE
 | VA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pda barcodes start with P
 | VB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] barcodes start with F
 | VC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] barcodes start with D
 | VD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F Fix barcodes start with I
 | VE
 | VF
 | VG
 | VH
 | VI
 | VJ
 | VK
 | VL
 | VM
 | VN
 | VO
 | VP
 | VQ
 | VR
 | VS
 | VT
 | VU
 | VV
 | VW
 | VX
 | VY
 | VZ
 | WA
 | WB
 | WC
 | WD
 | WE
 | WF
 | WG
 | WH
 | WI
 | WJ
 | WK
 | WL
 | WM
 | WN
 | WO
 | WP
 | WQ
 | WR
Spreadsheet: 149868d1334167325-advanced-filtering-by-using-functions-only-test
Sheet: Sheet1

 |  |  | /hungary |  |  | /hungary
 |  |  |  |  |  | /europe
 |  |  | /europe |  |  | /united-states
 |  |  | /united-states |  |  | /denmark
 |  |  |  | ???? |  | /france
 |  |  |  |  |  | /austria
 |  |  | /denmark |  |  | /asia-pacific
 |  |  | /france |  |  | /americas
 |  |  | /austria |  |  | /spain
 |  |  | /asia-pacific |  |  | /netherlands
 |  |  | /americas
 |  |  | /spain
 |  |  | /netherlands
 |  |  | /australia
 |  |  | /singapore
 |  |  | /portugal
 |  |  | /south-africa
Spreadsheet: 178930d1346958090-desperate-noob-needs-help-searching-columns-searching-columns
Sheet: Sheet1

col a | col b |  | col d
99 | 1 |  | 10
100 | 2 |  | 20
101 | 3 |  | 30
102 | 4 |  | 40
103 | 5 |  | 50
104 | 6 |  | 60
105 | 7 |  | 70
106 | 8 |  | 80
107 | 9 |  | 90
108 | 10 |  | 100
109 | 11 |  | 110
110 | 12 |  | 120
111 | 13 |  | 130 |  |  | formula
 |  |  |  |  |  | =D42+INDEX($D$7:$D$19,MATCH(D40,A7:A19,0))
 |  |  | 99 | lookup value
 |  |  | 100 | value to be added
Spreadsheet: 848749d1699387249-real-beginner-question-how-to-avoid-repetitive-autofill-actions-7-options
Sheet: Sheet1

0
20
40
60
80
100
120
140
160
180
200
220
240
260
280
300
320
340
360
380
400
420
440
460
480
500
520
540
560
580
600
620
640
660
680
700
Spreadsheet: 775810d1649334141-formula-to-pull-data-from-master-bill-of-materials-excel-matrix-help
Sheet: Sheet2

OEM Part # | Supplier Part # | Supplier Part # [NAME] | Part Description
85100022 | 7416795-107H | AA | OB SIDE SHIELD LH
85100077 | [PHONE] | AA | OB SIDE SHIELD RH
85100099 | 8886801-401H | AA | CENTER FRONT FOOT COVER
84929977 | 9876802-103H | AA | LH 2 POSITION HIGH LATCH SHOULDER BEZEL (BLACK)
84929988 | 8886803-103H | AA | RH 2 POSITION HIGH LATCH SHOULDER BEZEL (BLACK)
Spreadsheet: 152685d1335470215-excel-2003-highlighting-a-row-based-on-cell-entry-repair-request-detail-record-template-1-
Sheet: Sheet1

Repair Request / Detail Record |  |  |  |  |  |  |  |  |  |  |  |  | Repair Requested
 |  |  |  |  |  |  |  |  |  |  |  |  | Repair Received
Job Name |  | [NAME] Here |  |  |  | Superintendent |  | [NAME] Here |  |  |  |  | Repair Complete
RD# | Drawing | Level | Piece # | Conn. # | Description | Date Req. | Date Rec. | Date Comp. | Eqp. Used | Eqp. Hrs | Man Pwr | Man Hrs | Comments
1 |  |  |  |  |  | 2011-12-25 00:00:00
2 |  |  |  |  |  | 2011-12-26 00:00:00 | 2011-12-30 00:00:00
3 |  |  |  |  |  | 2011-12-27 00:00:00 | 2011-12-30 00:00:00 | 2012-01-05 00:00:00
Job Name |  |  |  | [NAME] Here |  |  |  |  |  |  |  |  | Repair Request / Detail Record       Page 2
RD# | Drawing | Level | Piece # | Conn. # | Description | Date Req. | Date Rec. | Date Comp. | Eqp. Used | Eqp. Hrs | Man Pwr | Man Hrs | Comments
Job Name |  |  |  | [NAME] Here |  |  |  |  |  |  |  |  | Repair Request / Detail Record       Page 3
RD# | Drawing | Level | Piece # | Conn. # | Description | Date Req. | Date Rec. | Date Comp. | Eqp. Used | Eqp. Hrs | Man Pwr | Man Hrs | Comments
Spreadsheet: 803884d1667764810-sum-of-maximum-value-based-on-unique-sales-man-sample
Sheet: PolicyData

Policy | Date | Premium | Sales Man # | Revenue | Premium Sum
100242 | 2021-01-02 00:00:00 | 180 | A1001 | 50 | 0
100242 | 2021-01-02 00:00:00 | 20 | A1001 | 5 | 0
100242 | 2021-01-02 00:00:00 | 250 | A1003 | 0 | 0
100242 | 2021-01-02 00:00:00 | 48 | A1003 | 10 | 0
100242 | 2021-01-02 00:00:00 | 750 | A1009 | 100 | 0
100242 | 2021-01-02 00:00:00 | 450 | A1009 | 50 | 0
100242 | 2021-01-02 00:00:00 | 900 | A1015 | -250 | 0
100242 | 2021-01-02 00:00:00 | 250 | A1015 | 10 | 0
100242 | 2021-01-05 00:00:00 | 180 | A1001 | 50 | 2080
100242 | 2021-01-05 00:00:00 | 20 | A1001 | 5 | 2080
100242 | 2021-01-05 00:00:00 | 250 | A1003 | 0 | 2080
100242 | 2021-01-05 00:00:00 | 48 | A1003 | 10 | 2080
100242 | 2021-01-05 00:00:00 | 750 | A1009 | 100 | 2080
100242 | 2021-01-05 00:00:00 | 450 | A1009 | 50 | 2080
100242 | 2021-01-05 00:00:00 | 900 | A1015 | 250 | 2080
100242 | 2021-01-05 00:00:00 | 250 | A1015 | 10 | 2080
100242 | 2021-01-09 00:00:00 | 180 | A1001 | 50 | 2080
100242 | 2021-01-09 00:00:00 | 20 | A1001 | 5 | 2080
100242 | 2021-01-09 00:00:00 | 250 | A1003 | 0 | 2080
100242 | 2021-01-09 00:00:00 | 48 | A1003 | 10 | 2080
100242 | 2021-01-09 00:00:00 | 750 | A1009 | 100 | 2080
100242 | 2021-01-09 00:00:00 | 450 | A1009 | 50 | 2080
100242 | 2021-01-05 00:00:00 | 900 | A1015 | 300 | 2080
100242 | 2021-01-05 00:00:00 | 250 | A1015 | 10 | 2080
Spreadsheet: andy_zipper__206__DYNEGY-ICE VOL May24
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
ICE CRUDE PRODUCTS VOLUME: |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 3 | 3650000 |  | Fischer, M | Firm-LD Off-Peak | MWhs | 1 | 7600
[NAME], G | NG Fin BS, LD1 for GDM | MMBtus | 1 | 300000 |  | Richter, J | Firm-LD Off-Peak | MWhs | 2 | 2400
 | NG Fin BS, LD1 for NGI | MMBtus | 1 | 3020000 |  | Stalford, R | Firm-LD Peak | MWhs | 1 | 204000
 | NG [NAME], ID, GDM | MMBtus | 2 | 750000 |  | Carson, M | Firm-LD Peak | MWhs | 1 | 800
Mckay, B | NG Fin BS, LD1 for IF | MMBtus | 5 | 3775000 |  | Grand Total |  |  | 5 | 214800
Goodell, S | NG [NAME], FP | MMBtus | 1 | 5000
Grand Total |  |  | 13 | 11500000