tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 167174d1341921452-copy-data-with-3-horisontal-or-vertical-criterias-index-and-match-try3
Sheet: Forecasts

Problem 1.
Cars | Last occured quarter | Previous quarter
World TOTAL | [NAME]
Boats | Last occured quarter | Previous quarter
World TOTAL | Q2/11
Problem 2. |  |  |  |  |  |  |  |  | If last occurred is [NAME] I need the Q3/12 and [NAME] to be left empty although Data Source sheet has numbers in them
Cars | Q1/10 | Q2/10 | Q3/10 | Q4/10 | Q1/11 | Q2/11 | Q3/11 | Q4/11 | Q1/12 | [NAME] | Q3/12 | Q4/12
World TOTAL | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287
Boats | Q1/10 | Q2/10 | Q3/10 | Q4/10 | Q1/11 | Q2/11 | Q3/11 | Q4/11 | Q1/12 | [NAME] | Q3/12 | Q4/12
World TOTAL | 2287 | 2287 | 2287 | 2287 | 2287 | 2287
Spreadsheet: 870554d1717056617-display-results-from-imported-csv-file-book1_csv
Sheet: >=1760

Column4 | Column12 | Column13 | Column16 | Column33 | Column34 | Column36
1760 | 4687 | 7193 | 9813 | 100 | 0 | 0
1760 | 4687 | 7193 | 9813 | 0 | 50 | 600
1760 | 4687 | 7193 | 9813 | 450 | 150 | 950
1760 | 4687 | 7193 | 9813 | 250 | 200 | 1125
1760 | 4687 | 7193 | 9813 | 400 | 500 | 1350
1760 | 4687 | 7193 | 9813 | 800 | 1000 | 2150
1870 | 4900 | 7272 | 10269 | 0 | 0 | 0
1870 | 4900 | 7272 | 10269 | 170 | 160 | 425
1870 | 4900 | 7272 | 10269 | 10 | 10 | 625
1870 | 4900 | 7272 | 10269 | 70 | 60 | 650
1870 | 4900 | 7272 | 10269 | 470 | 510 | 1350
1870 | 4900 | 7272 | 10269 | 60 | 360 | 2325
1760 | 5021 | 7379 | 9682 | 150 | 110 | 0
1760 | 5021 | 7379 | 9682 | 0 | 0 | 175
1760 | 5021 | 7379 | 9682 | 350 | 360 | 250
1760 | 5021 | 7379 | 9682 | 50 | 10 | 450
1760 | 5021 | 7379 | 9682 | 200 | 160 | 475
1760 | 5021 | 7379 | 9682 | 360 | 510 | 1450
1760 | 4667 | 7013 | 9431 | 150 | 100 | 0
1760 | 4667 | 7013 | 9431 | 250 | 350 | 25
1760 | 4667 | 7013 | 9431 | 200 | 150 | 75
1760 | 4667 | 7013 | 9431 | 0 | 0 | 100
1760 | 4667 | 7013 | 9431 | 560 | 520 | 275
1760 | 4667 | 7013 | 9431 | 260 | 360 | 300
1760 | 4667 | 7013 | 9431 | 410 | 420 | 325
1760 | 4667 | 7013 | 9431 | 50 | 370 | 1175
... | ... | ... | ... | ... | ... | ...
Spreadsheet: 182600d1348548919-rolling-totals-formula-help-running-totals
Sheet: Sheet1

 |  | Week 1
 |  | Total:
 | 8
 | 7
 | 6
 | 5
 | 4
 | 3
 | 2
 | 1
 | 1 | 125 | 125 | 145
 | 2 | 125 | 147 | 145
 | 3 | 125 | 125 | 211
 | 4 | 147 | 241 | 136
 | 5 | 158 | 169 | 214
 | 6 | 257 | 236 | 222
Spreadsheet: 54184d1254208462-compare-worksheets-for-data-changes-report1
Sheet: Sheet1

article | qty
F4DVD678 | 300
CMED46 | 152
BANDOR45 | 12
R55 | 23
CMETD46 | 100
REDSEAL | 489
PART6 | 1
C4DVD901 | 9
MAJOR1LP | 565
FAVOUR56 | 75
[NAME] | 56
WORZLE78 | 9
Spreadsheet: 544112d1508767610-help-populating-filtering-list-based-on-multi-drop-down-menus-mark-pr-filter-multiple-criteria
Sheet: Settings

 | Employee List |  |  |  |  |  |  | Leave Type |  | Company Holidays
 | ID | Name | Department | Shift | Holiday leave Entitlement | Agency |  | List of Leave Types |  | Company Holiday | Description |  | Weekday |  |  | Months |  |  | Months |  | Shifts |  | Department |  | Agency
 |  | [NAME] | Decant | Red | 20 | Extra |  | Annual leave |  | 2017-01-01 00:00:00 | New Year's Day |  | 1 | Mon |  | January | 1 |  |  |  | Red |  | Decant |  | Extra
 |  | Klaudia Lasota | Assembly | Red | 20 | Ethero |  | Annual leave (half day) |  | 2017-01-02 00:00:00 | New Year Holiday |  | 2 | Tue |  | February | 2 |  |  |  | Blue |  | Assembly |  | Ethero
 |  | [NAME] | Cabling | Red | 20 | Proactive |  | Sick leave |  | 2017-04-14 00:00:00 | Good Friday |  | 3 | Wed |  | March | 3 |  |  |  | Day |  | Cabling |  | Proactive
 |  | [NAME] | Test | Red | 20 | Permanent |  | Sick leave (half day) |  | 2017-04-17 00:00:00 | Easter Monday |  | 4 | Thu |  | April | 4 |  |  |  |  |  | Test |  | Pertemps
 |  | [NAME] | Repair | Blue | 20 | Pertemps |  | Unpaid leave |  | 2017-05-01 00:00:00 | May Day |  | 5 | Fri |  | May | 5 |  |  |  |  |  | Repair |  | Permanent
 |  | [NAME] | QC | Red | 20 | Extra |  | Unpaid leave (half day) |  | 2017-05-29 00:00:00 | Late May Bank Holiday |  | 6 | Sat |  | June | 6 |  |  |  |  |  | QC
 |  | [NAME] | ICBTO | Blue | 20 | Permanent |  | Training |  | 2017-08-28 00:00:00 | August Bank Holiday |  | 7 | Sun |  | July | 7 |  |  |  |  |  | ICBTO
 |  | [NAME] | Packout | Red | 20 | Permanent |  | Training (half day) |  | 2017-12-25 00:00:00 | Christmas Day |  |  |  |  | August | 8 |  |  |  |  |  | Packout
 |  | Employee1 | Cabling | Blue | 20 | Extra |  | Bereavement |  | 2017-12-26 00:00:00 | Boxing Day |  |  |  |  | September | 9 |  |  |  |  |  | Warehouse
 |  | Employee 2 | Cabling | Blue | 20 | Ethero |  | Maternity leave |  | 2018-01-01 00:00:00 | New Year's Day |  |  |  |  | October | 10
 |  | Employee3 | Cabling | Blue | 20 | Extra |  | Other leave |  | 2018-03-30 00:00:00 | Good Friday |  |  |  |  | November | 11
 |  | Employee4 | Cabling | Blue | 20 | Extra |  | Start Date |  | 2018-04-02 00:00:00 | Easter Monday |  |  |  |  | December | 12
 |  | Employee5 | Test | Blue | 20 | Extra |  | Leave Date |  | 2018-05-07 00:00:00 | Early May Bank Holiday
 |  |  |  |  |  |  |  |  |  | 2018-05-28 00:00:00 | Spring Bank Holiday
 |  |  |  |  |  |  |  |  |  | 2018-08-27 00:00:00 | Summer Bank Holiday
 |  |  |  |  |  |  |  |  |  | 2018-12-25 00:00:00 | Christmas Day
 |  |  |  |  |  |  |  |  |  | 2018-12-26 00:00:00 | Boxing Day
Spreadsheet: 875810d1722438564-create-single-array-of-repeated-row-values-stacked-array-example
Sheet: Sheet1

 | Value | Quantity |  | Desired Output |  | [NAME]
 | a | 1
 | b | 2 |  | b |  | a
 | cd | 3 |  | b |  | a
 | efg | 4 |  | cd |  | a
 | h | 5 |  | cd |  | a
 | i | 6 |  | cd |  | a
 |  |  |  | efg
 |  |  |  | efg
 |  |  |  | efg
 |  |  |  | efg
 |  |  |  | h
 |  |  |  | h
 |  |  |  | h
 |  |  |  | h
 |  |  |  | h
 |  |  |  | i
 |  |  |  | i
 |  |  |  | i
 |  |  |  | i
 |  |  |  | i
 |  |  |  | i
Spreadsheet: 153226d1335808828-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: August 15

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2011-08-15 00:00:00 | 2011-08-16 00:00:00 | 2011-08-17 00:00:00 | 2011-08-18 00:00:00 | 2011-08-19 00:00:00 | 2011-08-20 00:00:00
[NAME] | off | 9:30-5:30 | 8:00-5:00 | 8:00-5:00 | 8:30-5:30 | 9:15-5:15
 |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 38
[NAME] | 8:30-5:30 | 8:30-5:30 | 9:30-5:30 | 8:30-5:30 | 9:30-5:30 | off
 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 |  | 38
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | 8:00-4:00 | off
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 |  | 38
Mark | 8:30-5:30 | 9:00-4:00 | 8:30-5:30 | 8:30-5:30 | off | 9:00-5:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 |  | 1:00-2:00 | 38
[NAME] | 8:00-4:00 | off | 8:30-5:30 | 7:00-4:00-HOMER | 8:00-5:00 | 9:15-5:15-ctr
ctr 12-2 | 11:00-12:00 | off | 11:00-12:00 | 1ub | 11:00-12:00 | 11:00-12:00 | 38
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00 | 15
 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: tracy_geaccone__40179__timeline
Sheet: Sheet1

2002 PLAN REVIEW SCHEDULE
October 2 |  | 1:00-5:00 |  | EGAS
October 3 |  | 8:30-11:30 |  | Wessex
October 5 |  | 8:30-11:00 |  | EEOS
October 11 |  | All Day |  | Portland
October 12 |  | 8:30-5:00 |  | ETS and EREC
October 29 |  | 2:30-5:00 |  | Azurix
October 30 |  | 8:30-10:30 |  | EOTT
November 1 |  | 1:00-5:00 |  | Run Through for Lay Reviews
November 8 |  | 1:00-5:00 |  | [NAME]
Spreadsheet: 97264d1296498253-using-max-with-sumifs-example
Sheet: Results

At What Utilization Percentage and Below would you like to designate as Flex/WAH User? | 0.4
Assumed PTO/Travel | 0.08
Desired Vacancy Rate of Full-time Seats | 0
[NAME] for NP, NQ, TO1, & TO2 | 2931
 |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday
 |  | Morning | Lunch | Afternoon | Morning | Lunch | Afternoon | Morning | Lunch | Afternoon | Morning | Lunch | Afternoon | Morning | Lunch | Afternoon | Morning | Lunch | Afternoon | Morning | Lunch | Afternoon | Morning | Lunch | Afternoon | Morning | Lunch | Afternoon | Morning | Lunch | Afternoon
 | Flex/WAH Seats Utilized |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flex/WAH Seats Utilized
 | Assumed PTO/Travel (Fulltime Seat) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assumed PTO/Travel (Fulltime Seat)
 | Growth/Vacant Space |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Growth/Vacant Space
 | Full-Time Contractor Seats |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full-Time Contractor Seats
 | Full-Time Associate Seats |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full-Time Associate Seats
 | Total Seat Need
 | Available Seats NP, NQ, TO1 & TO2
 | [NAME]
Spreadsheet: 169259d1342755814-count-sick-day-occurrences-based-on-dates-and-the-duration-of-each-occurrence-in-hours-sick-day-test
Sheet: Sheet1

EE IDN | Sick Date | Sick Hours on Sick Date | # incidents (manual) | # hours in that incident (manual) |  |  |  |  | to count the number or sick occurences per employee #
54321 | 2011-07-20 00:00:00 | 7.5 | 1
54321 | 2011-10-03 00:00:00 | 7.5 | 1 |  |  |  |  |  | one sick occurrence equals consecutive sick days off work
54321 | 2011-10-18 00:00:00 | 7.5 | 0 |  | no weekend |  |  |  | one sick occurrence could be separated by 2 days (a weekend) off work, usually a Friday and Saturdy
54321 | 2011-10-19 00:00:00 | 7.5 | 0 |  | no weekend |  |  |  | for each occurrence for each emmployee, count the # hours in each occurrence
54321 | 2011-10-20 00:00:00 | 4 | 0 |  | no weekend |  |  |  | I have tried this formula to get a count of occurrences per employee #:
54321 | 2011-10-21 00:00:00 | 7.5 | 1 |  | no weekend |  |  |  | =IF(AND(A3=A2,(OR(B3=B2+1,B3=B2+3))),0,1)
67894 | 2011-07-21 00:00:00 | 7.5 | 0 |  |  |  |  |  | But I now need to count the duration in #hours of each occurrence for each employee
67894 | 2011-07-22 00:00:00 | 7.5 | 0 |  | Friday | weekend - count within 1 occurrence
67894 | 2011-07-25 00:00:00 | 7.5 | 0 |  | Monday | weekend - count within 1 occurrence
67894 | 2011-07-26 00:00:00 | 3.5 | 0
67894 | 2011-07-27 00:00:00 | 7.5 | 0
67894 | 2011-07-28 00:00:00 | 7.5 | 0
67894 | 2011-07-29 00:00:00 | 7.5 | 1
55448 | 2011-08-15 00:00:00 | 7.5 | 0
55448 | 2011-08-16 00:00:00 | 7.5 | 1
55448 | 2011-08-29 00:00:00 | 2 | 1
99544 | 2011-10-04 00:00:00 | 7.5 | 0
99544 | 2011-10-05 00:00:00 | 7.5 | 1
99544 | 2011-12-06 00:00:00 | 7.5 | 1
99544 | 2012-01-12 00:00:00 | 7.5 | 0
99544 | 2012-01-13 00:00:00 | 6.5 | 1
99544 | 2012-01-16 00:00:00 | 7.5 | 0
99544 | 2012-01-17 00:00:00 | 7.5 | 0
99544 | 2012-01-18 00:00:00 | 7.5 | 1
33567 | 2012-03-19 00:00:00 | 7.5 | 1 |  | Monday | not weekend - 1 separate occurrenc
33567 | 2012-03-22 00:00:00 | 7.5 | 0 |  | Thursday
33567 | 2012-03-23 00:00:00 | 7.5 | 1 |  |  | a new separate occurrence
I need to count the number of CONSECUTIVE days to = 1 indicident
If there is a Friday & Monday sick, then this is still 1 consecutive incident even though there is a gap in the dates
I need to also add up the total # hours in each incident
Spreadsheet: 386039d1427562104-calculating-number-of-games-won-match-results
Sheet: Sheet1

Won | Lost | F | A | F | A | F | A | F | A
3 | 1 | 21 | 20 | 20 | 21 | 21 | 6 | 21 | 8
Spreadsheet: 769632d1645624321-delete-every-5th-row-year_202020-temp2
Sheet: indexQuarterly

 | Q1-12 | Q2-12 | Q3-12 | Q4-12 | Q1-13 | Q2-13 | Q3-13 | Q4-13 | Q1-14 | Q2-14 | Q3-14 | Q4-14 | Q1-15 | Q2-15 | Q3-15 | Q4-15 | Q1-16 | Q2-16 | Q3-16 | Q4-16 | Q1-17 | Q2-17 | Q3-17 | Q4-17 | Q1-18 | Q2-18 | Q3-18 | Q4-18 | Q1-19 | Q2-19 | Q3-19 | Q4-19 | Q1-20 | Q2-20
Flip-flops
Jeans
Shoes
High heels
Suit
[NAME]
Swimsuit
Jacket
 |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 11
 | sample Values not needed from above table
 | sample result |  | only quarterly values being retrieved
 | Q1-12 | Q2-12 | Q3-12 | Q4-12 | Q1-13 | Q2-13 | Q3-13 | Q4-13 | Q1-14 | Q2-14 | Q3-14 | Q4-14 | Q1-15 | Q2-15 | Q3-15 | Q4-15 | Q1-16 | Q2-16
Spreadsheet: 828945d1683806669-vlookup-and-sum-in-one-formula-sample
Sheet: Sales_2

 | Sales | This is an import of sale so it has the Item by Code rather than description so I need to look it up on the Stock Database for the Description
 | Item | UnitPrice | Qty
 | 101 - Prepacked Carrots 1kg | 2.3 | 236
 | 102 - Prepacked Garlic 100g | 1.5 | 32
 | 104 - Prepacked Baby Potatoes 1kg | 2 | 18
 | 106 - Prepacked Mixed Peppers 450g | 4 | 45
 | 107 - Prepacked Apples 650g | 3.25 | 33
 | 108 - Prepacked Brown Onions 1kg | 2.2 | 63
 | 109 - Prepacked Leeks 500g | 2.2 | 121
 | 107 - Prepacked Apples 650g | 2.2 | 100
Spreadsheet: 145611d1331662836-excel-2007-using-checkboxes-that-reference-another-cell-copy-of-checkbox
Sheet: Sheet1

Names | Codes | Green Eggs N Hame | The Lorax | Oh, The places You'll Go | Your Only Old Once | How the [NAME] Stol Christmas
[NAME] | FJDE15487  VAWX94862  KFRS74358
[NAME] | NESP58234  VAWX94862  KFRS74358
[NAME] | FJDE15487    NESP58234  KFRS74358
Michelle | [NAME]
 |  |  |  |  |  | Legend
 |  |  |  |  |  | Book | Code
 |  |  |  |  |  | Green Eggs N Hame | FJDE15487
 |  |  |  |  |  | The Lorax | JUDL69485
 |  |  |  |  |  | Oh, The places You'll Go | NESP58234
 |  |  |  |  |  | Your Only Old Once | VAWX94862
 |  |  |  |  |  | How the [NAME] Stol Christmas | KFRS74358
Spreadsheet: sally_beck__35365__enwfloors
Sheet: Sheet1

ENRON NET WORKS
Floor Meeting Times/Locations
 |  |  |  |  |  |  |  | Approx #
Meeting Time |  | Location |  | Floor |  | Group |  | Employees |  | [NAME]. Lead |  | Bus. Lead
 |  |  |  | ECS 4 |  | Ops -DPR |  | 13 |  | [NAME] |  | [NAME] |  | x39123
 |  |  |  |  |  | EOL |  | 45 |  | Brad Richter |  | Savita Puthigai |  | x31787
 |  |  |  |  |  | Ops -EIM |  | 35 |  | [NAME] |  |  |  | x37206
 |  |  |  |  |  | OOC; [NAME] |  | 12
 |  |  |  | ECS 3 |  | Ops - EGM Risk |  | 12 |  | Brent Price |  | [NAME]; |  | x39111
 |  |  |  |  |  | Ops - EGM Struc. |  | 9 |  | Brent Price |  | [NAME]; |  | x31746
 |  |  |  |  |  | Ops - EGM Freight |  | 23 |  | Brent Price |  | [NAME]; |  | x57532
 |  |  |  |  |  | Ops - EGM Freight |  | 15 |  | Brent Price |  | [NAME] |  | x36557
 |  |  |  | ECN 6 |  | Ops - EES Risk |  | 25 |  | [NAME] |  | [NAME] |  | [NAME]
 |  |  |  | ECN 14 |  | Ops - EES Deal [NAME]. |  | 27 |  | [NAME] |  | [NAME] |  | x35081
 |  |  |  |  |  | Ops - EA OA |  | 10 |  | [NAME] |  | [NAME]; |  | x33954
 |  |  |  |  |  | Ops - EES Logistics |  | 30 |  | [NAME] |  | [NAME] |  | x39517
 |  |  |  |  |  | [NAME] |  | 83 |  |  |  | [NAME] |  | x30327
 |  |  |  | ECN 18 |  | [NAME] |  | 280 |  | ? |  | [NAME] |  | x57316
 |  |  |  | ECN 21 |  | Ops -EA |  | 45 |  | [NAME] |  | [NAME] |  | x31771
 |  |  |  | ECN 22 |  | Infrastructure |  | 315 |  | [NAME] |  |  |  | x34771
 |  |  |  | ECN 24 |  | Ops - EIM |  | 40 |  | [NAME] |  | [NAME] |  | [NAME]
 |  |  |  |  |  | Ops - EGM |  | 36 |  | Brent Price |  | [NAME] |  | x57048
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | x36139
 |  |  |  | ECN 25 |  | [NAME] |  | 280 |  | ? |  | ?
 |  |  |  | ECN 26 |  | [NAME] |  | 35 |  | ? |  | [NAME] |  | x33240
 |  |  |  |  |  | Infrastructure |  | 74 |  | [NAME] |  | [NAME] |  | x36383
 |  |  |  | ECN 31 |  | Ops - EA Power |  | 55 |  | [NAME] |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | x31870
 |  |  |  | ECN 32 |  | Ops - EA Gas Risk |  | 50 |  | [NAME] |  | [NAME] |  | [NAME]
 |  |  |  |  |  | Ops- EA Gas Logis. |  | 60 |  | [NAME] |  | [NAME] |  | x30957
 |  |  |  | ECN 34 |  | Infrastructure |  | 155 |  | [NAME] |  | [NAME] |  | x37468
 |  |  |  | ECN 37 |  | Ops - EA Vol Mgmt. |  | 25 |  | [NAME] |  | [NAME]; |  | x37398
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  | Ops - EA Gas Settle |  | 40 |  | [NAME] |  | [NAME] |  | x36587
 |  |  |  |  |  | Ops - Global Ser. |  | 96 |  | [NAME] |  | [NAME] |  | x35324
 |  |  |  | ECN 44 |  | Ops - EBS |  | 22 |  | [NAME] |  | [NAME] |  | x34763
 |  |  |  | ECN 45 |  | Ops- EBS |  | 15 |  | [NAME] |  |  |  | x57419
 |  |  |  | 3 AC 16 |  | Ops- EES |  | 150 |  | [NAME] |  | [NAME] |  | x35778
Spreadsheet: 180581d1347645850-formula-that-averages-percentages-based-on-said-criteria-barcode-example-modified-by-tigeravatar-
Sheet: Sheet1

SPL
0.1
0.3
0.2
0.8
SPL
0.15
1
0.6
0.3
SPL
1
1
0.5
0.3
0.5
0.5
Spreadsheet: kenneth_lay__19472__1208_Violation
Sheet: Sheet1

 |  |  | To: |  | [NAME], [NAME] |  |  |  |  | Risk Policy Notification Requirements
 |  |  | Copy to: |  | Distribution |  |  |  |  |  |  |  | Skilling |  | Lay |  |  | Finance Committe Chairman
 |  |  |  |  |  |  |  |  |  | Daily Loss |  |  | 50% of VaR |  | 75% of VaR |  |  | Aggregate Loss > 100% Aggregate VaR Limit
 |  |  | From: |  | Global Risk Management Operations |  |  |  |  | Cumulative 5-day Loss |  |  | 75% of VaR |  | 100% of VaR
 |  |  |  |  |  |  |  |  |  | NOP, M/G, VaR |  |  | 105% of VaR |  | 110% of VaR |  |  | Aggregate VaR > 115% Aggregate VaR Limit
 |  |  | Date: |  | 2000-12-11 00:00:00
 |  |  | Re: |  | Limit Violations and Notifications for December 8, 2000
 |  |  |  |  |  |  | Loss Notification or Limit Violation |  |  |  |  |  | P/L RESULTS
 |  |  |  |  |  |  |  |  |  | Violation/
 | Occurrence |  |  |  |  |  | VaR | NOP or M/G | Type | Notification | Number |  | QTD |  | YTD
 | Date |  | Business Unit |  | Commodity Group |  | Limit | Limit | Violation | Amount | YTD |  | P/L |  | P/L |  |  | Explanation
 |  |  |  |  |  |  | ($MMs) |  |  | ($MMs) |  |  | ($MMs) |  | ($MMs)
Lay Level
1 | 2000-12-08 00:00:00 |  | Enron Energy Services |  | Gas & Power Trading |  | 7 | n/a | Daily Loss | -28.65 | 20 |  | -35.061 |  | 233.081 |  |  | The loss was due to COB off-peak and Palo Verde peak price volatility.
Skilling Level
2 | 2000-12-08 00:00:00 |  | Enron Energy Services |  | Gas & Power Trading |  | 7 | n/a | VaR | 7.6 | 9 |  | -35.061 |  | 233.081 |  |  | The EES VaR violation is due to volatile power prices in the West.
RAC COMMENTS:
EES NA Power desk has lost ~$90 MM in the last four days.  We recommend that EES transfer its West Power positions to ENA during this period of market volatility.
 | Distribution: |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 107409d1304593812-finding-words-and-copying-adjacent-cell-test
Sheet: Data

Red Apple | 4 | Yes
Red Banana | 3 | No
Blue Apple | 2 | Yes
Blue Orange | 5 | Yes
Blue Banana | 6 | No
[NAME] | 7 | Yes
[NAME] | 6 | Yes
Green Orange | 2 | No
Spreadsheet: 194384d1353147387-how-do-i-get-excel-to-ignore-cells-that-have-no-data-entry-yet-when-calculating-mode-test-14
Sheet: Sheet1

Student Name | WAF1 | WAF2 | WAF3 | WAF4 | WAF5 | WAF6 | WAF7 | WAF8 | MODE | W Actual Mark | [NAME] | RAF2 | RAF3 | [NAME] | RAF5 | RAF6 | RAF7 | MODE | R Actual Mark | S&LAF1 | S&LAF2 | S&LAF3 | S&LAF4 | MODE | S&L Act.[NAME]
Student | 4a | 6a | 4b | 6a | 3a | 7a | 6a | 2a |  |  | 3a | 4b | 4a | 7a | 6b | 6c | 3a
Student | 4a | 3a | 4b | 3a | 3a | 3a |  | 2a |  |  | 3a | 4a | 2a | 4a | 5a | 3a | 4a |  |  | 3a | 2a | 2a | 4c
Student | 4a | 2a | 4b | 2a | 3a | 1b | 2a | 2a |  |  | 5a | 7b | 4a | 6c |  | 4a | 5b
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Spreadsheet: 757494d1638292209-dynamic-drop-down-list-box-dilemma-demo
Sheet: List

1941
1962
1941
1918
1874
1872
1931
1941
1962
1955
1941
1962
1941
1918
1874
1872
1931
1941
1962
1955
Spreadsheet: 105707d1302975977-lookup-new-microsoft-excel-worksheet1
Sheet: Sheet1

aeBux Profit/Loss Calculator 2011
Date | Membership | No. of Referrals |  | No. of Clicks |  |  |  |  | Income |  |  | Expenses |  |  |  |  | Profit | Invest | Cashout | Average |  | Break even point average (including membership costs) |  | Clicks Prices
 |  | Direct | Rented | Mine |  |  | Direct refs | Rented refs | My clicks | Referrals clicks | Total | Rent | Extend | Autopay | Recycle | Total |  |  |  | Direct refs | Rented refs
 |  |  |  | Standard | Mini | Tiny |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Membership | Clicks
2011-04-01 00:00:00 | Standard |  |  | 4 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mine |  |  | My refs
2011-04-02 00:00:00 | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Standard | Mini | Tiny
2011-04-03 00:00:00 | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Golden | 0.01 | 0.003 | 0.001 | 0.01
2011-04-04 00:00:00 | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Standard | 0.01 | 0.003 | 0.001 | 0.005
2011-04-05 00:00:00 | -
2011-04-06 00:00:00 | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In J5, the result should be 0.04 (E5*Z8) Until I add any value in F5 or G5 If I add 1 in F5 then the result should be 4*0.01 + 1*0.003 = 0.043
2011-04-07 00:00:00 | -
2011-04-08 00:00:00 | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Referrals | Golden | Standard
2011-04-09 00:00:00 | -
2011-04-10 00:00:00 | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 - 250 | 0.21 | 0.25
2011-04-11 00:00:00 | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 251 - 500 | 0.21 | 0.26
2011-04-12 00:00:00 | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 501 - 750 | 0.22
2011-04-13 00:00:00 | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 751 - 1000 | 0.23
2011-04-14 00:00:00 | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1001 - 1250 | 0.24
2011-04-15 00:00:00 | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1251 - 1500 | 0.25
2011-04-16 00:00:00 | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1501 - 1750 | 0.26
2011-04-17 00:00:00 | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Over 1750 | 0.28
2011-04-18 00:00:00
2011-04-19 00:00:00
2011-04-20 00:00:00
2011-04-21 00:00:00
2011-04-22 00:00:00
2011-04-23 00:00:00
2011-04-24 00:00:00
2011-04-25 00:00:00
2011-04-26 00:00:00
2011-04-27 00:00:00
2011-04-28 00:00:00
2011-04-29 00:00:00
2011-04-30 00:00:00
Total
Spreadsheet: 888722d1739294885-how-to-divert-two-different-values-following-two-column-using-same-time-sample
Sheet: Sheet1

Nos. Of  Workers |  | Time |  | ABC Workers Total Hrs | Outside Workers Total Hrs | Workers Cost QR |  | Material / Equipments/ Instruments/Transp. Cost…
ABC | Out Side | From | Till |  |  | ABC | OUTSIDE | ABC | ABC  Transp... | Outside
5 | 5 | 08:00:00 | 16:00:00
10 |  | 07:00:00 | 13:00:00
 | 10 | 07:00:00 | 13:00:00
 |  | 08:00:00 | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | If I type any numbers in " A4" then value require to "E4" Only.   If "B4" is empty then "F4" shoud be Zero Value
 |  | 09:00:00 | 13:00:00
 |  | 10:00:00 | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | And Similarly If I type any numbers in  "B4" then value require to "F4"Only. If "A4"Zero Value then "E 4" shoud be Zero Value
 |  | 11:00:00 | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Note:  I don't have enough space. by adding two more colmn.. Sorry my bad English and  THANKS LOT …
 |  | 12:00:00 | 13:00:00
 |  | 12:00:00 | 13:00:00
 |  | 12:00:00 | 13:00:00
 |  | 09:00:00 | 13:00:00
 |  | 09:00:00 | 18:59:00
 |  | 09:00:00 | 13:00:00
 |  | 09:00:00 | 13:00:00
 |  | 09:00:00 | 13:00:00
ABC  Workers  Total Hours |  |  | Total Workers Hours
Outside Workers Total Hours
Spreadsheet: 889947d1741014531-rank-countif-help-please-help
Sheet: formulas

NAME | STAKE | PAID | X | X | RANK | WHAT THE RANK SHOULD BE
 |  |  |  |  |  | 4
 |  |  |  |  |  | 5
 |  |  |  |  |  | 11
 |  |  |  |  |  | 2
 |  |  |  |  |  | 3
 |  |  |  |  |  | 6
 |  |  |  |  |  | 10
 |  |  |  |  |  | 1
 |  |  |  |  |  | 9
 |  |  |  |  |  | 7
 |  |  |  |  |  | 8