tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 799001d1664871868-how-can-i-group-data-by-a-certain-attribute-example
Sheet: Tabelle1

Example Data
City | District | Plot Number | Owner First Name | Owner [NAME] | Staff member
Dresden | 2 | 45 | [NAME] | Tauber | [NAME] |  |  |  | [NAME] | Berlin | 8 | 42 | [NAME]
Dresden | 2 | 45 | [NAME] | Tauber | [NAME] |  |  | Gesine | Held | Dresden | 3 | 78 | [NAME]
Dresden | 2 | 62 | Manfred | Maurer | [NAME] |  |  | Gesine | Held | Dresden | 3 | 8 | [NAME]
Dresden | 3 | 78 | Gesine | Held | [NAME] |  |  | Manfred | Maurer | Dresden | 2 | 62 | [NAME]
Dresden | 3 | 23 | [NAME] | Zänker | [NAME] |  |  | [NAME] | Tauber | Dresden | 2 | 45 | [NAME]
Dresden | 3 | 8 | Gesine | Held | [NAME] |  |  | [NAME] | Tauber | Berlin | 8 | 39 | [NAME]
Berlin | 8 | 6 | [NAME] | Tauber | [NAME] |  |  | [NAME] | Tauber | Dresden | 2 | 45 | [NAME]
Berlin | 8 | 42 | Anne | [NAME] | [NAME] |  |  | [NAME] | Tauber | Berlin | 8 | 6 | [NAME]
Berlin | 8 | 39 | [NAME] | Tauber | [NAME] |  |  | [NAME] | Tauber | Berlin | 8 | 39 | [NAME]
Berlin | 8 | 39 | [NAME] | Tauber | [NAME] |  |  | [NAME] | Tauber | Berlin | 9 | 24 | [NAME]
Berlin | 9 | 78 | [NAME] | Zänker | [NAME] |  |  | [NAME] | Zänker | Dresden | 3 | 23 | [NAME]
Berlin | 9 | 24 | [NAME] | Tauber | [NAME] |  |  | [NAME] | Zänker | Berlin | 9 | 78 | [NAME]
What I want:
Owner First Name | Owner [NAME] | City | District | Plot Number | Staff member
[NAME] | Tauber | Dresden | 2 | 45 | [NAME]
[NAME] | Tauber | Berlin | 8 | 6 | [NAME]
[NAME] | Tauber | Berlin | 9 | 24 | [NAME]
[NAME] | Tauber | Berlin | 8 | 39 | [NAME]
[NAME] | Tauber | Dresden | 2 | 45 | [NAME]
[NAME] | Tauber | Berlin | 8 | 39 | [NAME]
Manfred | Maurer | Dresden | 2 | 62 | [NAME]
Gesine | Held | Dresden | 3 | 78 | [NAME]
Gesine | Held | Dresden | 3 | 8 | [NAME]
[NAME] | Zänker | Dresden | 3 | 23 | [NAME]
[NAME] | Zänker | Berlin | 9 | 78 | [NAME]
Anne | [NAME] | Berlin | 8 | 42 | [NAME]
Spreadsheet: 856889d1706054943-help-with-dropdown-list-and-multiplier-kpi-tracker-test-1-
Sheet: Data

Task | Multiplier
13PF1 | 36
13PKD | 23
ZP1 | 32
ZP3 | 38
ZP4 | 46
13IRE | 36
14P1 | 21
11P2 | 44
REPLEN | 6.5
PUTAWAY | 13
Spreadsheet: chris_germany__1750__ces_bookout
Sheet: Sheet1

CES Deals
Deal | CES/New |  | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00
372088 | CES |  | 107 | 222 | 489 | 962 | 1035
229344 | CES |  | -38 | -30 | -137 | -418 | -395
229357 | CES |  | -69 | -192 | -352 | -544 | -640
 |  | Totals
376962 | CES |  | 20000
372096 | CES |  | -19875
226553 | CES |  | -20000
231667 | CES |  | -3405
226703 | CES |  | -153382 | -142776 | -75812 | -83178 | -125990 | -123971
227882 | CES |  | -125 | -123 | -161 | -224 | -258
372048 | CES |  | 0 | 123 | 161 | 224 | 258
Spreadsheet: 167505d1342014458-selecting-a-3-value-data-range-for-graphs-chart-example
Sheet: Sheet1

Project Name | Risk | Budget
Project 1 | 6 | 356194000
Project 2 | 5 | 13330000
Project 3 | 4 | 14250000
Project 4 | 9 | 126805724
Project 5 | 7 | 5000000
Project 6 | 2 | 34000000
Project 7 | 9 | 1081000
Project 8 | 0 | 999295
Project 9 | 4 | 16459399
Project 10 | 7 | 3100000
Project 11 | 2 | 9921656
Project 12 | 6 | 23000000
Project 13 | 4 | 3000000
Project 14 | 6 | 9500000
Project 15 | 8 | 12000000
Project 16 | 1 | 1340000
Project 17 | 3 | 45400000
Project 18 | 9 | 21000000
Project 19 | 6 | 13459399
Spreadsheet: 53495d1253380254-how-to-get-sum-based-on-column-test1
Sheet: Sheet1

Ave order | Items | [NAME] | Store2A | Store1B | Store2B | Store2C | [NAME] | Total Store 1 | Total Store 2 | Total
25 | Corn | 50 | 20 | 30 |  | 20 | 30 | A formula to get sum of Store1 A, B & C. If cell B3 to G3 is blank, display zero (eg. row 5). [NAME] will be copied down. | A formula to get sum of Store2 A, B & C. If cell B3 to G3 is blank, display zero (eg. row 5). [NAME] will be copied down. | Sum of columns H and I
20 | Tomato | 20 |  |  | 20 |  | 20
5 | Potato
20 | Cabbage | 30 | 30 | 20 | 10 | 30 | 10
 |  | I would also like to add conditional formating that if value is > Average order value font should be green and if < then turn to red.
 |  |  |  |  |  |  |  | Here's the sample expected result:
Ave order | Items | [NAME] | Store2A | Store1B | Store2B | Store2C | [NAME] | Total Store 1 | Total Store 2 | Total
25 | Corn | 50 | 20 | 30 |  | 20 | 30 | 110 | 40 | 150
20 | Tomato | 20 |  |  | 20 |  | 20 | 40 | 20 | 60
5 | Potato
20 | Cabbage | 30 | 30 | 20 | 10 | 30 | 10 | 60 | 70 | 130
Spreadsheet: 124232d1318262144-excel-2007-confused-by-combining-and-or-and-if-defs-and-weight
Sheet: Defs and Weight

 | Cell Position of answers in the  workbook | Example Ansswers | Rationale for returning overall case status | Overall Status
Case 1 | F3 | Green | RED : If  ( F3 or F4  ) overall score is red (because thse are high priority). Otherwise if there are 5 or more red in total then overall should be red  Amber: Similalry, If F3 or F4 are Amber, or 4 or more are amber, including F3 and F4, then overall should be amber  Any other Count is green.
 | F4 | Amber
 | F5 | Red
 | F6 | Amber
 | F7 | Green
 | F8 | Red
 | F9 | Amber
 | [NAME] | Amber
Case 2 | F11 | Green | RED :if F11 or F12 are red, overall is red.   AMBER: If F11 or F12 is Amber, overall is amber.  Any other Count is green
 | F12 | Green
Case 3 | F13 | Amber | RED: if  F13 and F14 are red ( as combined they prove a problem),or or if 3 or more in total are red then overall is red   Amber: 2 or less amber, overall is  (including F13 and or F14).  Any other Count is green
 | F14 | Amber
 | F15 | Amber
 | F16 | Amber
 |  | Red
 |  | Amber
 |  | Green
Spreadsheet: 834446d1687844390-finding-the-closest-location-with-inventory-closest_location
Sheet: Orders

 | Destination | Product number | Closest Location with inventory
 | Location 1 | 1
 | Location 2 | 2
 | Location 3 | 3
 | Location 4 | 4
 | Location 5 | 5
 | Location 6 | 6
 | Location 7 | 7
 | Location 8 | 8
 | Location 9 | 9
 | Location 10 | 10
 | Location 1 | 6
 | Location 2 | 7
 | Location 3 | 8
 | Location 4 | 9
 | Location 5 | 10
 | Location 6 | 1
 | Location 7 | 2
 | Location 8 | 3
 | Location 9 | 4
 | Location 10 | 5
Spreadsheet: 713367d1610665181-formula-to-return-multiple-matches-from-a-reference-list-excel_help
Sheet: Sheet2

group_names | assigned_categories
Group A | Red
Group B | Red
Group C | Red
Group D | Red
Group E | Red
Group F | Red
Group G | Red
Group H | Red
Group I | Red
Group J | Blue
Group K | Blue
Group L | Blue
Group M | Blue
Group N | Blue
Group O | Blue
Group P | Blue
Group Q | Blue
Group R | Blue
Group S | Red
Group T | Red
Group U | Red
Group V | Red
Group W | Red
Group X | Red
Group Y | Red
Group Z | Red
Spreadsheet: 356120d1414990250-anyone-know-how-to-make-a-chart-from-turnover-and-variance-hr-benefits-specialist-pre-work-assignment
Sheet: Employee Terminations

Count of Vol/Inv | Column Labels
Termination Date | Claims | Sales | SVC | Grand Total
2013-03-13 00:00:00 | 1 |  |  | 1
2013-08-19 00:00:00 | 1 |  |  | 1
2014-01-15 00:00:00 | 1 |  |  | 1
2014-01-20 00:00:00 |  |  | 1 | 1
2014-01-31 00:00:00 |  | 1 |  | 1
2014-02-02 00:00:00 | 1 |  |  | 1
2014-02-05 00:00:00 |  |  | 1 | 1
2014-02-10 00:00:00 | 1 |  |  | 1
2014-02-17 00:00:00 |  | 2 |  | 2
2014-02-18 00:00:00 |  |  | 1 | 1
2014-02-26 00:00:00 |  | 1 |  | 1
2014-03-04 00:00:00 | 1 |  |  | 1
2014-03-07 00:00:00 |  | 1 |  | 1
2014-03-11 00:00:00 | 1 |  | 1 | 2
2014-03-12 00:00:00 | 1 |  |  | 1
2014-03-13 00:00:00 |  |  | 1 | 1
2014-03-17 00:00:00 |  |  | 1 | 1
2014-03-18 00:00:00 |  | 1 |  | 1
2014-03-21 00:00:00 | 1 |  | 2 | 3
2014-03-25 00:00:00 |  |  | 2 | 2
2014-03-27 00:00:00 |  |  | 1 | 1
2014-03-28 00:00:00 | 1 |  |  | 1
2014-04-01 00:00:00 | 1 | 1 |  | 2
2014-04-04 00:00:00 |  | 1 | 1 | 2
2014-04-06 00:00:00 |  | 1 |  | 1
2014-04-11 00:00:00 | 1 |  |  | 1
2014-04-15 00:00:00 |  | 1 |  | 1
2014-04-18 00:00:00 | 1 | 1 |  | 2
2014-04-21 00:00:00 | 1 |  |  | 1
2014-04-23 00:00:00 |  |  | 1 | 1
2014-04-28 00:00:00 | 1 |  | 1 | 2
2014-04-29 00:00:00 |  | 1 | 2 | 3
2014-05-05 00:00:00 | 1 |  |  | 1
2014-05-07 00:00:00 |  |  | 2 | 2
2014-05-16 00:00:00 | 1 | 1 |  | 2
2014-05-23 00:00:00 | 1 |  |  | 1
2014-06-05 00:00:00 |  |  | 1 | 1
2014-06-06 00:00:00 | 2 |  |  | 2
2014-06-09 00:00:00 |  |  | 1 | 1
2014-06-13 00:00:00 |  | 1 |  | 1
2014-06-19 00:00:00 |  |  | 1 | 1
2014-06-20 00:00:00 |  | 2 |  | 2
2014-06-23 00:00:00 |  |  | 1 | 1
2014-06-26 00:00:00 |  |  | 1 | 1
2014-07-02 00:00:00 | 1 | 1 |  | 2
2014-07-03 00:00:00 |  | 1 |  | 1
2014-07-07 00:00:00 | 1 |  |  | 1
2014-07-10 00:00:00 | 1 |  |  | 1
2014-07-15 00:00:00 |  | 1 |  | 1
2014-07-17 00:00:00 | 1 |  |  | 1
2014-07-18 00:00:00 |  |  | 1 | 1
2014-07-22 00:00:00 |  |  | 1 | 1
2014-07-25 00:00:00 | 2 | 1 |  | 3
2014-07-27 00:00:00 |  |  | 1 | 1
2014-07-29 00:00:00 |  | 1 |  | 1
2014-07-30 00:00:00 |  | 1 |  | 1
2014-08-05 00:00:00 | 1 |  |  | 1
2014-08-06 00:00:00 |  | 1 |  | 1
2014-08-14 00:00:00 |  |  | 1 | 1
2014-08-16 00:00:00 |  |  | 1 | 1
2014-08-21 00:00:00 |  | 1 |  | 1
2014-08-22 00:00:00 | 1 |  |  | 1
2014-08-25 00:00:00 |  |  | 1 | 1
2014-08-26 00:00:00 |  |  | 1 | 1
2014-08-28 00:00:00 |  |  | 1 | 1
2014-08-29 00:00:00 |  |  | 1 | 1
2014-09-02 00:00:00 |  |  | 1 | 1
2014-09-04 00:00:00 |  | 1 | 1 | 2
2014-09-05 00:00:00 |  |  | 1 | 1
2014-09-12 00:00:00 | 2 | 1 |  | 3
2014-09-16 00:00:00 |  |  | 2 | 2
2014-09-24 00:00:00 |  | 1 |  | 1
2014-09-25 00:00:00 |  |  | 1 | 1
2014-09-28 00:00:00 |  |  | 2 | 2
2014-10-03 00:00:00 | 1 |  |  | 1
2014-10-04 00:00:00 |  |  | 1 | 1
2014-10-13 00:00:00 | 1 |  |  | 1
2014-10-19 00:00:00 |  |  | 1 | 1
2014-10-20 00:00:00 |  |  | 1 | 1
2014-10-21 00:00:00 |  |  | 1 | 1
Grand Total | 32 | 27 | 44 | 103
Spreadsheet: 58447d1258674935-dates-in-a-pivot-table-707994-dates-in-a-pivot-table
Sheet: Sheet1

Name | Date From | Date To | Days
[NAME] | 2009-01-01 00:00:00 | 2009-01-03 00:00:00 | 2
[NAME] | 2009-01-02 00:00:00 | 2009-01-04 00:00:00 | 2
[NAME] | 2009-01-03 00:00:00 | 2009-01-05 00:00:00 | 2
[NAME] | 2009-01-04 00:00:00 | 2009-01-06 00:00:00 | 2
[NAME] | 2009-01-05 00:00:00 | 2009-01-07 00:00:00 | 2
[NAME] | 2009-01-06 00:00:00 | 2009-01-08 00:00:00 | 2
[NAME] | 2009-01-07 00:00:00 | 2009-01-09 00:00:00 | 2
[NAME] | 2009-02-05 00:00:00 | 2009-02-10 00:00:00 | 5
[NAME] | 2009-02-06 00:00:00 | 2009-02-11 00:00:00 | 5
[NAME] | 2009-02-07 00:00:00 | 2009-02-12 00:00:00 | 5
[NAME] | 2009-02-08 00:00:00 | 2009-02-13 00:00:00 | 5
[NAME] | 2009-02-09 00:00:00 | 2009-02-14 00:00:00 | 5
[NAME] | 2009-02-10 00:00:00 | 2009-02-15 00:00:00 | 5
[NAME] | 2009-02-11 00:00:00 | 2009-02-16 00:00:00 | 5
[NAME] | 2009-03-12 00:00:00 | 2009-03-13 00:00:00 | 1
[NAME] | 2009-03-13 00:00:00 | 2009-03-14 00:00:00 | 1
[NAME] | 2009-03-14 00:00:00 | 2009-03-15 00:00:00 | 1
[NAME] | 2009-03-15 00:00:00 | 2009-03-16 00:00:00 | 1
[NAME] | 2009-03-16 00:00:00 | 2009-03-17 00:00:00 | 1
[NAME] | 2009-03-17 00:00:00 | 2009-03-18 00:00:00 | 1
[NAME] | 2009-03-18 00:00:00 | 2009-03-19 00:00:00 | 1
[NAME] | 2009-04-14 00:00:00 | 2009-04-20 00:00:00 | 6
[NAME] | 2009-04-15 00:00:00 | 2009-04-21 00:00:00 | 1
[NAME] | 2009-04-16 00:00:00 | 2009-04-22 00:00:00 | 6
[NAME] | 2009-04-17 00:00:00 | 2009-04-23 00:00:00 | 6
[NAME] | 2009-04-18 00:00:00 | 2009-04-24 00:00:00 | 6
[NAME] | 2009-04-19 00:00:00 | 2009-04-25 00:00:00 | 6
[NAME] | 2009-04-20 00:00:00 | 2009-04-26 00:00:00 | 6
[NAME] | 2009-05-01 00:00:00 | 2009-05-03 00:00:00 | 2
[NAME] | 2009-05-02 00:00:00 | 2009-05-04 00:00:00 | 2
[NAME] | 2009-05-03 00:00:00 | 2009-05-05 00:00:00 | 2
[NAME] | 2009-05-04 00:00:00 | 2009-05-06 00:00:00 | 2
[NAME] | 2009-05-05 00:00:00 | 2009-05-07 00:00:00 | 2
[NAME] | 2009-05-06 00:00:00 | 2009-05-08 00:00:00 | 2
[NAME] | 2009-05-07 00:00:00 | 2009-05-09 00:00:00 | 2
[NAME] | 2009-06-06 00:00:00 | 2009-06-15 00:00:00 | 9
[NAME] | 2009-06-07 00:00:00 | 2009-06-16 00:00:00 | 9
[NAME] | 2009-06-08 00:00:00 | 2009-06-17 00:00:00 | 9
[NAME] | 2009-06-09 00:00:00 | 2009-06-18 00:00:00 | 9
[NAME] | 2009-06-10 00:00:00 | 2009-06-19 00:00:00 | 9
[NAME] | 2009-06-11 00:00:00 | 2009-06-20 00:00:00 | 9
[NAME] | 2009-06-12 00:00:00 | 2009-06-21 00:00:00 | 9
Spreadsheet: 23533d1213094248-can-this-be-done-in-excel-help
Sheet: Totals

AREA ONE | TOTALS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The Priory |  | 2008/9
 | Week No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Dates | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 |  |  |  | 2008-09-01 00:00:00 |  |  |  |  | 2008-10-01 00:00:00 |  |  |  | 2008-11-01 00:00:00 |  |  |  | 2008-12-01 00:00:00 |  |  |  |  | 2009-01-01 00:00:00 |  |  |  | 2009-02-01 00:00:00 |  |  |  | 2009-03-01 00:00:00 |  |  |  |  | 2009-04-01 00:00:00 |  |  |  | 2009-05-01 00:00:00 |  |  |  | 2009-06-01 00:00:00 |  |  |  |  | 2009-07-01 00:00:00
 |  | 2008-07-28 00:00:00 | 2008-08-04 00:00:00 | 2008-08-11 00:00:00 | 2008-08-18 00:00:00 | 2008-08-25 00:00:00 | 2008-09-01 00:00:00 | 2008-09-08 00:00:00 | 2008-09-15 00:00:00 | 2008-09-22 00:00:00 | 2008-09-29 00:00:00 | 2008-10-06 00:00:00 | 2008-10-13 00:00:00 | 2008-10-20 00:00:00 | 2008-10-27 00:00:00 | 2008-11-03 00:00:00 | 2008-11-10 00:00:00 | 2008-11-17 00:00:00 | 2008-11-24 00:00:00 | 2008-12-01 00:00:00 | 2008-12-08 00:00:00 | 2008-12-15 00:00:00 | 2008-12-22 00:00:00 | 2008-12-29 00:00:00 | 2009-01-05 00:00:00 | 2009-01-12 00:00:00 | 2009-01-19 00:00:00 | 2009-01-26 00:00:00 | 2009-02-02 00:00:00 | 2009-02-09 00:00:00 | 2009-02-16 00:00:00 | 2009-02-23 00:00:00 | 2009-03-02 00:00:00 | 2009-03-09 00:00:00 | 2009-03-16 00:00:00 | 2009-03-23 00:00:00 | 2009-03-30 00:00:00 | 2009-04-06 00:00:00 | 2009-04-13 00:00:00 | 2009-04-20 00:00:00 | 2009-04-27 00:00:00 | 2009-05-04 00:00:00 | 2009-05-11 00:00:00 | 2009-05-18 00:00:00 | 2009-05-25 00:00:00 | 2009-06-01 00:00:00 | 2009-06-08 00:00:00 | 2009-06-15 00:00:00 | 2009-06-22 00:00:00 | 2009-06-29 00:00:00 | 2009-07-06 00:00:00 | 2009-07-13 00:00:00 | 2009-07-20 00:00:00
 | [NAME] (2) | 1 | 2 | 2 | 2 | 1
 | Lower Court
 | West Wing
 | Upper Court
 | TOTAL | 1 | 2 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 1 | 2 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 328705d1404035624-index-match-if-function-wonder-why-excel-kept-refer-to-the-wrong-want-formula-error-dgk-3
Sheet: Screening

Job Screening |  |  |  | Job No. |  | 163378845
Date | 2014-06-29 00:00:00 | Sea | Import | FCL | D.Port |  | Door
Vessel's Shipment Details
MBL No. | 0254A49739 |  |  |  |  | Original
HBL/DO No.
Vessel Name |  | Voyage | Depart Date | [NAME] | SeaPort Location Name
WAN HAI 312 |  | S114 | 2014-06-07 00:00:00 |  | Asia | China | Shekou
 |  |  |  | 2014-06-13 00:00:00 | Asia | Malaysia | [NAME]
Container No. | Seal No. | Total Packages | [NAME] (KGS) | M3 | Chargeable | Marking
BMOU4030849 | WHL5241989 |  |  |  |  | 40'
WHLU5219667 | WHL5241987 |  |  |  |  | 40'
WHLU5230558 | WHL5241988 |  |  |  |  | 40'
Flight's Shipment Details
MAWB No.
HAWB No.
Flight Name |  | Direct/ Transit | Depart Date | [NAME] | AirPort Location Name
Cargo Dimensions (CM) |  |  | Qty | Volumetric | Weight | Marking
 |  | Chargeable Weight
Agent's Details
COMPANY NAME | Empire [NAME] |  |  | PIC
[NAME] |  |  |  | MOBILE
TEL |  |  |  | FAX
ADDRESS
Descriptions |  | Charges Collect From |  | Charges to be Collected
FREIGHT
FREIGHT SURCHARGE
TERMINAL CHARGES
CUSTOM CLEARANCE
TRANSPORTATION
WAREHOUSE
ACCESSORIES CHARGES
Profit Sharing
Date | Special Instructions & Notes
Spreadsheet: 715563d1611767183-rounding-by-a-percent-split-rounding-example
Sheet: Sheet1

 |  | No Rounding | Round | Round Up | Round Down
 | %Split | 160
 | 0.02
 | 0.04
 | 0.1
 | 0.12
 | 0.14
 | 0.52
 | 0.06
 | Total
Spreadsheet: 841693d1693861503-assign-two-fixed-values-randomly-in-a-column-fixed-values-in-random-rows
Sheet: Sheet1

 |  |  |  |  |  |  |  | =LET(Crow,F3,s,SEQUENCE(Crow),p,TAKE(SORTBY(s,RANDARRAY(Crow)),Crow*C4),HSTACK(s,IF(ISNUMBER(MATCH(s,p,)),B4,B5)))
 |  |  |  | for 80%, integers multiple of 5
 |  | Probability |  | rows | 20 |  |  |  |  |  | Press F9
Value 1 | 0.15 | 0.8
Value 2 | 0.4 |  |  | test
Test:
Row # | Data
1 | 0.15
2 | 0.4
3 | 0.15
4 | 0.4
5 | 0.15
6 | 0.15
7 | 0.15
8 | 0.15
9 | 0.4
10 | 0.4
11 | 0.15
12 | 0.15
13 | 0.15
14 | 0.15
15 | 0.15
16 | 0.15
17 | 0.15
18 | 0.4
19 | 0.15
20 | 0.15
21 | 0.15
22 | 0.15
23 | 0.15
24 | 0.15
25 | 0.4
26 | 0.15
27 | 0.4
28 | 0.15
29 | 0.4
30 | 0.15
31 | 0.15
32 | 0.15
33 | 0.15
34 | 0.15
35 | 0.15
36 | 0.15
37 | 0.15
38 | 0.4
39 | 0.4
40 | 0.15
41 | 0.15
42 | 0.15
43 | 0.15
44 | 0.15
45 | 0.15
46 | 0.15
47 | 0.4
48 | 0.15
49 | 0.15
50 | 0.4
51 | 0.15
52 | 0.15
53 | 0.15
54 | 0.15
55 | 0.15
56 | 0.15
57 | 0.15
58 | 0.4
59 | 0.15
60 | 0.15
61 | 0.15
62 | 0.15
63 | 0.15
64 | 0.4
65 | 0.15
66 | 0.15
67 | 0.4
68 | 0.4
69 | 0.15
70 | 0.15
71 | 0.15
72 | 0.15
73 | 0.15
74 | 0.15
75 | 0.15
76 | 0.4
77 | 0.15
78 | 0.15
79 | 0.15
80 | 0.15
81 | 0.15
82 | 0.15
83 | 0.15
84 | 0.15
85 | 0.15
86 | 0.15
87 | 0.4
88 | 0.15
89 | 0.15
90 | 0.15
91 | 0.15
92 | 0.15
93 | 0.15
94 | 0.15
95 | 0.15
96 | 0.4
97 | 0.4
98 | 0.15
99 | 0.15
100 | 0.15
Spreadsheet: phillip_m_love__30139__200006_OA
Sheet: DEN-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 3454894 | 12336669
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 5098819 | 19858480
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 148976.09
 | Total Sales: |  | 8553713 | 32344125.09
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -5280552 | -18326942
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -3517539 | -13563594
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 11741 | 44321
 | Total Purchases: |  | -8786350 | -31846215
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 5326 | 45234
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 5326 | 45234
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 227311 | 774269.4128312934
 |  |  | 0 | 0
23 | Fuel: |  | -11741 | -44321
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -342852.31
25 |  | Demand | 0 | -585889.82
 | Total Transport Expense: |  | 0 | -928742.13
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 1000000
31 |  | Prior Month Book Balance | 0 | -1096737
 |  | Total MTM Income | 0 | -96737
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 1775
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -732
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -28234
 |  | TOTAL INTRA-MTH
FT-Denver
 |  | Current Month MTM | 0 | 54892 | 0 | 0 |  |  | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: kimberly_watson__20556__imbalsumm0109
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -623008 | -616826 | -25138 | -25000
2 | -610523 | -585078 | -25001 | -25000
3 | -663655 | -658037 | -25919 | -25000
4 | -684927 | -709416 | -24748 | -25000
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  |  |  | 151133
2001-09-04 00:00:00
CBS Dollars
 |  |  | 465120
Spreadsheet: 108385d1305437921-if-a-cell-in-a-column-in-any-worksheet-x-copy-entire-row-budget_update
Sheet: Entertainment

Entertainment
 |  |  |  |  | Total Entertainment Budget | Spent So Far | Total Remaining
 |  |  |  |  | 100 | 69.9 | 30.09999999999999
Date | Location | Memo | Method | Amount
2011-05-02 00:00:00 | Cinemark |  | DISC | 15
2011-05-08 00:00:00 | Texas Roadhouse |  | DISC | 54.9
Spreadsheet: 796826d1663586269-adding-a-further-criterion-to-an-existing-formula-in-order-to-create-a-tiebreak-ramsey
Sheet: Results

CAMBRIDGESHIRE |  |  |  |  |  |  | MASTERS |  |  |  |  |  |  |  |  | LAST CHANCE
No | PLAYER | PAR 3 | TOTAL | No |  |  | No | PLAYER | TOTAL | S/I 1 | S/I 2 | S/I 3 | No |  |  | No | PLAYER | TOTAL | S/I 1 | S/I 2 | S/I 3 | No
1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
18
19
20
21
22
23
24
25
26
Spreadsheet: 709523d1608371089-automatically-fill-in-common-info-based-on-keyword-match-book1
Sheet: Sheet2

Animal | Type | Weight | Fur? | Tail
Cat | Pet | 5-10kg | Yes | Long
Pig | Farm Animal | 150-300kg | No | Short
猫 | Pet | 5-10kg | Yes | Long