tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 126718d1319832879-running-average-productivity-2011adam
Sheet: Nov

November Valet Totals
PIPER |  |  |  |  | MAIN |  |  |  |  | TOTAL
Average Wait Time |  |  |  |  | Average Wait Time |  |  |  |  | Average Wait Time
Average Storage Length |  |  |  |  | Average Storage Length |  |  |  |  | Average Storage Length
 | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours
5:00am-5:59am |  |  | 1 |  | 5:00am-5:59am | 0 | 0 | 0 |  | 5:00am-5:59am | 0 | 0 | 1
6:00am-6:59am |  |  | 2 |  | 6:00am-6:59am | 0 | 0 | 0 |  | 6:00am-6:59am | 0 | 0 | 2
7:00am-7:59am |  |  | 3.5 |  | 7:00am-7:59am |  |  | 2 |  | 7:00am-7:59am | 0 | 0 | 5.5
8:00am-8:59am |  |  | 5 |  | 8:00am-8:59am |  |  | 2 |  | 8:00am-8:59am | 0 | 0 | 7
9:00am-9:59am |  |  | 5.5 |  | 9:00am-9:59am |  |  | 2 |  | 9:00am-9:59am | 0 | 0 | 7.5
10:00am-10:59am |  |  | 5 |  | 10:00am-10:59am |  |  | 3 |  | 10:00am-10:59am | 0 | 0 | 8
11:00am-11:59am |  |  | 5 |  | 11:00am-11:59am |  |  | 3 |  | 11:00am-11:59am | 0 | 0 | 8
12:00pm-12:59pm |  |  | 5 |  | 12:00pm-12:59pm |  |  | 2 |  | 12:00pm-12:59pm | 0 | 0 | 7
1:00pm-1:59pm |  |  | 5 |  | 1:00pm-1:59pm |  |  | 2 |  | 1:00pm-1:59pm | 0 | 0 | 7
2:00pm-2:59pm |  |  | 4.5 |  | 2:00pm-2:59pm |  |  | 3 |  | 2:00pm-2:59pm | 0 | 0 | 7.5
3:00pm-3:59pm |  |  | 3.5 |  | 3:00pm-3:59pm |  |  | 3 |  | 3:00pm-3:59pm | 0 | 0 | 6.5
4:00pm-4:49pm |  |  | 1.5 |  | 4:00pm-4:49pm |  |  | 2 |  | 4:00pm-4:49pm | 0 | 0 | 3.5
5:00pm-5:59pm |  |  | 1 |  | 5:00pm-5:59pm |  |  | 2 |  | 5:00pm-5:59pm | 0 | 0 | 3
6:00pm-6:59pm |  |  | 1 |  | 6:00pm-6:59pm |  |  | 2 |  | 6:00pm-6:59pm | 0 |  | 3
7:00pm-8:00pm | 0 | 0 | 0 |  | 7:00pm-8:00pm |  |  | 2 |  | 7:00pm-8:00pm | 0 | 0 | 2
 | 0 | 0 | 48.5 |  |  | 0 | 0 | 30 |  |  | 0 | 0 | 78.5
Spreadsheet: john_griffith__16070__1_16_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 52 | 370 | 420 | 49.2 | 55.9 | 1.72 | 2002-01-16 12:03:00
 | [NAME] | 53 | 700 | 750 | 50.2 | 53.8 | 1.73 | 2002-01-16 12:03:00
 | HO J2 | 53 | 900 | 975 | 49.7 | 53.9 | 1.73 | 2002-01-16 12:03:00
 | HO K2 | 53 | 1000 | 1100 | 46 | 50.6 | 1.61 | 2002-01-16 12:03:00
 | HO M2 | 54 | 1100 | 1130 | 43.2 | 44.4 | 1.49 | 2002-01-16 12:03:00
 | HO N2 | 54 | 1150 | 1250 | 41.1 | 44.8 | 1.46 | 2002-01-16 12:03:00
 | HO Q2 | 55 | 1200 | 1300 | 38.8 | 42 | 1.4 | 2002-01-16 12:03:00
 | HO U2 | 55 | 1275 | 1375 | 38.3 | 41.3 | 1.38 | 2002-01-16 12:03:00
 | [NAME] | 57 | 1300 | 1450 | 35.5 | 39.7 | 1.35 | 2002-01-16 12:03:00
 | HO X2 | 57 | 1350 | 1500 | 34.9 | 38.8 | 1.32 | 2002-01-16 12:03:00
 | [NAME] | 58 | 1400 | 1550 | 34 | 37.7 | 1.31 | 2002-01-16 12:03:00
 | HO F3 | 58 | 1400 | 1600 | 32.7 | 37.4 | 1.28 | 2002-01-16 12:03:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 766847d1644092637-conditional-formatting-and-splitting-cell-cond-formatting-split-cell
Sheet: Sheet1

PRODUCT | 2020-12-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00
AAA | -1 | -1.25 | -2
BBB | -1 | -1.25 | 2
CCC | -1 | 1.25 | 2
DDD | 1 | 1.25 | 2
EEE | 1 | 1.25 | -2
FFF | 1 | -1.25 | -2
GGG | -1 | 1.25 | -2
HHH | 1 | -1.25 | 2
Spreadsheet: john_zufferli__16761__positionsummary
Sheet: 2Stdev P&L

 | Sumas |  | Malin |  | Socal |  | AECO |  | Consumers |  | Parkway |  | [NAME] |  | Waddington |  | Dawn |  | Monchy |  | TM3 |  | [NAME] |  | Michcon |  | Chicago |  | Ventura |  | TZ6 |  | PG&E |  | Station 2 |  | Nymex |  | Alberta Power
 | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 2 stdev (30d) |  | 5*16-2 stdev (30d) | 7*8-2 stdev (30d) | [NAME] (30d) | Sun-2 stdev (30d)
Spreadsheet: 773357d1647811386-add-and-delete-rows-from-tables-mock-up-invoice_database_sheet
Sheet: Pivot Table

Row Labels | Sum of Amount | Sum of Ex Commission | Sum of GST | Sum of Inc Commission | Sum of Net Amount
4625WCE | 3659 | 899.75 | 89.98500000000001 | 989.7350000000001 | 2669.265
TX3662 | 3071 | 767.75 | 76.775 | 844.5250000000001 | 2226.475
17-Mar | 3071 | 767.75 | 76.775 | 844.5250000000001 | 2226.475
Mar | 3071 | 767.75 | 76.775 | 844.5250000000001 | 2226.475
TX6188 | 468 | 117 | 11.7 | 128.7 | 339.3
18-Jan | 468 | 117 | 11.7 | 128.7 | 339.3
Jan | 468 | 117 | 11.7 | 128.7 | 339.3
TX7282 | 120 | 15 | 1.51 | 16.51 | 103.49
31-Jan | 120 | 15 | 1.51 | 16.51 | 103.49
Jan | 120 | 15 | 1.51 | 16.51 | 103.49
Grand Total | 3659 | 899.75 | 89.98500000000001 | 989.7350000000001 | 2669.265
Claim Number | Recovery Agent | Agent's Ref | Portfolio Code | Third-Party | Invoice Number | Invoice Date | Amount | Ex Commission | GST | Inc Commission | Net Amount | File Reference 2
4625WCE |  | 55122 |  | Customer 1 | TX7282 | 2022-01-31 00:00:00 | 120 | 15 | 1.51 | 16.51 | 103.49
4625WCE |  | 55122 |  | Customer 1 | TX3662 | 2022-03-17 00:00:00 | 3071 | 767.75 | 76.775 | 844.525 | 2226.475
Claim Number | [NAME] | Gross Amount | Inc Commission
4625WCE | Payment(s) have been received on Invoice(s) TX7282 and TX3662 for the amount of $3,191.00.   There is a commission charge of $2329.97 | 3191 | 861.03
Claim Number | [NAME] | Gross Amount | Inc Commission
4625WCE | Payment has been received on Invoice TX7282 for the amount of $120.00.   There is a commission charge of $16.51. | 120 | 16.51
4625WCE | Payment has been received on Invoice TX3662 for the amount of $3071.   There is a commission charge of $ | 3191 | 844.52
Spreadsheet: 468709d1467471211-can-i-do-custom-filter-in-multiple-columns-oeldere-468567d1467360419-can-i-do-custom-filter-in-multiple-columns-book2
Sheet: Input

Column 1 | Column 2
AA1 | AA1
BB1 | AA1
CC1 | BB1
AA1
AA1
 |  |  | column | value
 |  |  | Column 1 | AA1
 |  |  | Column 1 | BB1
 |  |  | Column 1 | CC1
 |  |  | Column 1 | AA1
 |  |  | Column 1 | AA1
 |  |  | Column 2 | AA1
 |  |  | Column 2 | AA1
 |  |  | Column 2 | BB1
Spreadsheet: 825413d1681307029-count-based-on-cell-value-count2-sample
Sheet: Sheet1

STUFF | NAME A | [NAME] | NAME B | CRAP | NAME C | TRASH | PT
FFF | BILL | HH |  | GGG |  | WWW | X
GGG | HARRY | HH | [NAME] |  |  | WWW
 | JOE | HH | JILL | GGG |  | WWW | X
YY | GOLDIE | HH |  |  | KURT | WWW
 | [NAME] | HH | YOKO | GGG |  | WWW
VVV | HUMPHREY | HH |  |  | LAUREN | WWW | X
 | COUNT = 5
Spreadsheet: f261b9b3-9601-42d8-829d-6f5037169cac
Sheet: Sheet1

Instructions: 1. Save this file into new circular directory. Do "save as" s:\shared\circular\0007. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
2. Update cells [NAME], D7, & E7  w/new months (ie change  Feb to March & March to April).
3.  Update prices.
4. On final sheet, replace "ERR" with "n/a"
NASS Agricultural Prices
 | Domestic | 2001 | 2002 |  | % Change | % Change
Commodity | units | April | March | April \1 | Last Month | Last Year
 |  | Dollars/unit
Grapefruit   2/ | Box | 1.41 | 1.23 | 1.02 | -0.1707317073170732 | -0.276595744680851
Lemons   2/ | Box | 3.65 | 5.74 | 5.19 | -0.09581881533101042 | 0.4219178082191782
Limes   2/ | Box | 0 | 0 | 0
Oranges   2/ | Box | 4.71 | 4.88 | 4.3 | -0.1188524590163935 | -0.08704883227176224
Tangelos   2/ | Box | 0 | 0 | 0
Tangerines   2/ | Box | 9 | 8.19 | 13.17 | 0.6080586080586081 | 0.4633333333333333
Temples   2/ | Box | 0 | 1.25 | 0 | -1
Apples, fresh  3/ | [NAME]. | 0.157 | 0.21 | 0.215 | 0.02380952380952383 | 0.3694267515923567
Grapes | [NAME]. | 0 | 0 | 0
Peaches | Ton | 0 | 0 | 0
Pears, fresh  3/ | Ton | 337 | 267 | 267 | 0 | -0.2077151335311573
Strawberries, fresh | [NAME]. | 0.757 | 0.873 | 0.267 | -0.6941580756013745 | -0.6472919418758256
Asparagus  4/ | [NAME]. | 146 | 119 | 88.4 | -0.2571428571428571 | -0.3945205479452054
Broccoli   4/ | [NAME]. | 26.9 | 33.8 | 22.7 | -0.3284023668639053 | -0.1561338289962825
Cantaloupes | [NAME]. | 0 | 0 | 0
Carrots   4/ | [NAME]. | 17.3 | 21.1 | 21.2 | 0.004739336492890894 | 0.2254335260115606
Cauliflower   4/ | [NAME]. | 46.5 | 44.1 | 19.9 | -0.5487528344671202 | -0.5720430107526882
Celery   4/ | [NAME]. | 19.1 | 23.5 | 21.9 | -0.06808510638297878 | 0.1465968586387433
[NAME]4/ | [NAME]. | 18.1 | 26.3 | 14.9 | -0.4334600760456274 | -0.1767955801104973
Cucumbers   4/ | [NAME]. | 31 | 22.9 | 23.9 | 0.04366812227074236 | -0.2290322580645162
Lettuce   4/ | [NAME]. | 21.6 | 86.4 | 19.3 | -0.7766203703703705 | -0.1064814814814815
Onions   4/ | [NAME]. | 12.8 | 6.92 | 16 | 1.312138728323699 | 0.2499999999999999
Snap Beans  4/ | [NAME]. | 57.8 | 42.1 | 38.7 | -0.08076009501187645 | -0.3304498269896193
Tomatoes   4/ | [NAME]. | 19 | 38.5 | 30.2 | -0.2155844155844156 | 0.5894736842105263
1/  Preliminary
2/  Equivalent on-tree returns.
3/  Equivalent packinghouse-door returns for CA and NY (apples only), OR (pears only), and
WA (apples,  peaches, and pears).  Prices as sold for other states.
4/  Fresh-market, FOB shipping point.
Note: Zeroes indicate insufficient information or insufficient sales to establish a price.
Source:  National Agricultural Statistics Service (NASS), USDA.
Spreadsheet: 1796b457-4651-4d2e-921d-40f44d2347c3
Sheet: Inventory

Inventory Template |  |  |  | District #:
 |  |  |  | Period: | Mid-Year (December 31st)
Product Name | Quantity on Hand | Currency | Unit Price | Extended Price | Purchased from Toastmasters WHQ or 3rd Party?
Total Inventory Value on Hand
*** Please complete the white cells only ***
*** Enter columns C & F using the drop-down menus ***
Spreadsheet: dana_davis__4473__CANADA - 28C
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 28C
COMPANY NAME ECT - CANADA ACCOUNTING ENTRY
ANALYSIS OF OTHER DEFERRED CHARGES
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 12-31-99 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Work in Progress:
 |  | 0
Total  (Hyperion Line 0343)
Asset/Expense Accts:  DR/(CR)
Other Deferred Charges:
 |  | 0
Total (Hyperion line 360)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 880716d1728563943-remove-zero-values-from-y-m-d-conversion-formula-y-m-d-conversion
Sheet: Sheet1

 |  | Current output | Desired output
Records | Hours  =(A3/12)/7.5 | Hours converted to years months and days  =DATEDIF(0,B3,"y")& " years " &DATEDIF(0,B3,"ym")& " months "&DATEDIF(0,B3,"md")& " days" | Removes "0" values from result | Comments
43266 |  |  | 1 years 3 months 24 days
4647 |  |  | 1 months 20 days | 0 Years removed
77 |  |  | Less than 1 day | Nice to have: as Y, m and d are 0 default to "Less than 1 day"
292 |  |  | 3 days | Removes 0 years and 0 months
134 |  |  | 1 days | Removes 0 years and 0 months
145 |  |  | 1 days | Removes 0 years and 0 months
145606 |  |  | 4 years 5 months 4 days
10 |  |  | Less than 1 day | Nice to have: as Y, m and d are 0 default to "Less than 1 day"
47285 |  |  | 1 years 5 months 8 days
3738 |  |  | 1 months 10 days | Removes 0 years and 0 months
35000 |  |  | 1 years 22 days | Removes 0 months
Spreadsheet: 79364d1279641699-excel-2007-summing-up-words-and-convert-to-numbers-scorecard-challenge
Sheet: March

 |  |  |  |  | McOpCo SCORECARD CHALLENGE
 |  |  |  |  |  | MARCH 2010
Key performance Indicators |  |  | Below Target (0) | Slightly Below Target (1) |  | Meets or Exceeds Target (2) |  | Outstanding (3) |  |  |  |  | Below Target
 |  |  |  |  |  |  |  |  |  |  |  |  | Slightly Below
Restuarants |  | 400 North |  | Cookstown |  | Maple |  | [NAME] |  | Rutherford |  |  | Meets or Exceeds
 |  |  |  |  |  |  |  |  |  |  |  |  | Outstanding
Performance
Guest Counts
Sales vs. Last year
Build Your Peak
People
Crew Commitment
90 Day Terms(T6M)
Conv. and [NAME].
Late Night G.C
Drive Thru G.C
CSO
CSO (T6M)
[NAME] TET
Dine In TET
KVS Times
Mornings and Coffee
Morning G.C
Coffee Unit Growth
Profit
Food (vs. [NAME])
Food (FOB T3M)
Labour TPMH
Labour ACR
Labour (TPMH T3M)
P.A.C
Spreadsheet: 123373d1317628431-values-upto-a-specified-date-example
Sheet: Sheet1

 | Shop | 2010-03-07 00:00:00 | 2010-03-14 00:00:00 | 2010-03-21 00:00:00 | 2010-03-28 00:00:00 | 2010-04-04 00:00:00 | 2010-04-11 00:00:00 | 2010-04-18 00:00:00 | 2010-04-25 00:00:00 | 2010-05-02 00:00:00 | 2010-05-09 00:00:00 | 2010-05-16 00:00:00 | 2010-05-23 00:00:00 | 2010-05-30 00:00:00 | 2010-06-06 00:00:00 | 2010-06-13 00:00:00 | 2010-06-20 00:00:00 | 2010-06-27 00:00:00 | 2010-07-04 00:00:00 | 2010-07-11 00:00:00 | 2010-07-18 00:00:00 | 2010-07-25 00:00:00 | 2010-08-01 00:00:00 | 2010-08-08 00:00:00 | 2010-08-15 00:00:00 |  | TOTAL for Shop
 | A | 30 | 30 | 30 | 18 | 12 | 2.58 | 5.17 | 5.17 | 7.75 | 17.9 | 16.23 | 13.3 | 13.3 | 10.7 | 12.7 | 2 |  |  |  | 10 | 10 | 14 | 8 | 20 | 2010-06-13 00:00:00
 | B | 30 | 30 | 30 | 30 | 24 | 2.58 | 5.17 | 7.75 | 7.75 | 11.2 | 11.2 | 28 | 37.3 | 16 | 11 |  |  |  |  |  |  |  |  |  | 2010-06-13 00:00:00
 | C |  |  |  |  |  |  |  |  |  |  | 13.87 |  | 9 | 12.5 | 19 | 18 | 40 |  | 10 |  | 19 | 11 | 19 | 30 | 2010-06-13 00:00:00
 | D | 30 | 30 |  | 30 | 24 | 0 | 0 | 0 | 0 | 0 | 16 |  | 40 |  | 4.8 |  |  |  |  |  | 11 |  | 19.5 |  | 2010-06-13 00:00:00
 | E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 22.5 | 22.5 | 15 | 22.5 | 22.5 | 18 | 2010-06-13 00:00:00
 | F |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 11 | 8 | 8 | 4 | 2010-06-13 00:00:00
 | G | 3 | 8.25 |  | 4.5 | 9 | 0.65 | 0 | 1.62 | 0 | 13 | 22 | 17.3 | 33.7 | 16 | 9.3 |  | 12 | 21 | 24.67 | 22.5 | 18.67 |  | 20 | 22 | 2010-06-13 00:00:00
Spreadsheet: 888529d1739035481-formula-needed-that-only-counts-data-for-certain-months-example
Sheet: YTD Results

 | Note: Rep names must be entered in exactly as they are shown in the survey report. Enter the supervisor name in the green boxes.
 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | Raymi [NAME]
 | [NAME]
 | Ricardo Herrera
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | Alexis Jaimes
 | [NAME]
 | Alexis Jaimes
 |  |  |  | Team Score
 | Sup 5
 |  |  |  | Team Score
 | Sup 6
 |  |  |  | DRG Score
 |  |  |  | Updated 11.15.24
Spreadsheet: 112948d1308913150-multiple-column-pivot-chart-chart-upload
Sheet: Report 1

Reference 1 | Date 1
1 | 2011-06-22 00:00:00
2 | 2011-06-22 00:00:00
3 | 2011-06-22 00:00:00
4 | 2011-06-22 00:00:00
5 | 2011-06-22 00:00:00
6 | 2011-06-22 00:00:00
7 | 2011-06-22 00:00:00
8 | 2011-06-22 00:00:00
9 | 2011-06-22 00:00:00
10 | 2011-06-22 00:00:00
11 | 2011-06-22 00:00:00
12 | 2011-06-22 00:00:00
13 | 2011-06-22 00:00:00
14 | 2011-06-22 00:00:00
15 | 2011-06-22 00:00:00
16 | 2011-06-22 00:00:00
17 | 2011-06-22 00:00:00
18 | 2011-06-22 00:00:00
19 | 2011-06-22 00:00:00
20 | 2011-06-22 00:00:00
21 | 2011-06-22 00:00:00
22 | 2011-06-22 00:00:00
23 | 2011-06-22 00:00:00
24 | 2011-06-22 00:00:00
25 | 2011-06-22 00:00:00
26 | 2011-06-22 00:00:00
27 | 2011-06-22 00:00:00
28 | 2011-06-22 00:00:00
29 | 2011-06-22 00:00:00
30 | 2011-06-22 00:00:00
31 | 2011-06-22 00:00:00
32 | 2011-06-22 00:00:00
33 | 2011-06-22 00:00:00
34 | 2011-06-22 00:00:00
35 | 2011-06-22 00:00:00
36 | 2011-06-22 00:00:00
37 | 2011-06-23 00:00:00
38 | 2011-06-23 00:00:00
39 | 2011-06-23 00:00:00
40 | 2011-06-23 00:00:00
41 | 2011-06-23 00:00:00
42 | 2011-06-23 00:00:00
43 | 2011-06-23 00:00:00
44 | 2011-06-23 00:00:00
45 | 2011-06-23 00:00:00
46 | 2011-06-23 00:00:00
47 | 2011-06-23 00:00:00
48 | 2011-06-23 00:00:00
49 | 2011-06-23 00:00:00
50 | 2011-06-23 00:00:00
51 | 2011-06-23 00:00:00
52 | 2011-06-23 00:00:00
53 | 2011-06-23 00:00:00
54 | 2011-06-23 00:00:00
55 | 2011-06-24 00:00:00
56 | 2011-06-24 00:00:00
57 | 2011-06-24 00:00:00
58 | 2011-06-24 00:00:00
59 | 2011-06-24 00:00:00
60 | 2011-06-24 00:00:00
61 | 2011-06-24 00:00:00
62 | 2011-06-24 00:00:00
63 | 2011-06-24 00:00:00
64 | 2011-06-24 00:00:00
65 | 2011-06-24 00:00:00
66 | 2011-06-24 00:00:00
67 | 2011-06-24 00:00:00
68 | 2011-06-24 00:00:00
69 | 2011-06-24 00:00:00
70 | 2011-06-24 00:00:00
71 | 2011-06-24 00:00:00
72 | 2011-06-24 00:00:00
73 | 2011-06-24 00:00:00
74 | 2011-06-24 00:00:00
75 | 2011-06-24 00:00:00
76 | 2011-06-24 00:00:00
77 | 2011-06-24 00:00:00
78 | 2011-06-24 00:00:00
79 | 2011-06-24 00:00:00
80 | 2011-06-24 00:00:00
81 | 2011-06-24 00:00:00
82 | 2011-06-24 00:00:00
83 | 2011-06-24 00:00:00
84 | 2011-06-24 00:00:00
85 | 2011-06-24 00:00:00
86 | 2011-06-24 00:00:00
87 | 2011-06-24 00:00:00
88 | 2011-06-24 00:00:00
Spreadsheet: 266543d1379656285-conditional-formatting-due-dates-for-production-ppic-board
Sheet: Sheet1

Today :
 |  |  |  | Production Planning and Control Board
Product |  | Component |  | Material |  | Assembly |  | Metal
 |  |  |  | Preparation |  | Department |  | Treatment |  | Finishing
Description | Qty | Description | Pcs | Schd | Actual | Schd | Actual | Schd. | Actual | Schd. | Actual | Schd. | Actual
Accent Chair | 10 | Back Legs | 20 | 2013-09-18 00:00:00 | 2013-09-29 00:00:00 | 2013-10-01 00:00:00 | 2013-10-05 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | 2013-10-12 00:00:00
Spreadsheet: sally_beck__33698__MgmtSum-Q2-0609
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
2000-06-01 00:00:00 | 2ND QUARTER 2000 DETAIL OF GROSS MARGIN
M.QTD
ENA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecast Margin Calculation
 |  |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Margin |  |  |  | Earnings Before Allocated Expenses
 | Business Team |  | DPR (1) | MPR | Accruals |  | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME] |  |  | Plan | Forecast | [NAME]
GAS_TRAD | Gas Trading |  | 206743
ASST_TRD | Texas Desk |  | 46648
[NAME] | Power Trading |  | 138753
IR_FX | Financial Drift |  | 27181
ECT_INV_IRFX | Financial Trading
TRD_MKT | Canada Trading |  |  |  |  |  |  |  |  |  |  |  | 11556
COAL | Coal Trading |  | 1086
WEATHER | GRM -  Weather |  | 2608
SO2 | Emissions |  | -3689
 | Total Trading & Risk Management
E_ORG | East Midstream
W_ORIG | West Midstream |  |  | 506
DWNSTRM_IND_ORIG | Industrial Downstream |  |  |  | 0
N_BS_DEV | Generation Investments |  |  | 16150
 | Coal-Origination & Finance |  |  | 182 | 115
fin | Canada Origination & Finance |  | 230 | 1901 |  |  |  |  |  |  |  |  | 11556
ASST_ORIG | ENA Upstream Assets |  | 2102 | 115 | 16766 |  | 5850
INSURANCE | GRM - New Products |  |  |  |  |  | 653
MEXICO | Mexico
 | Total Origination
EQUITY | Principal Investing |  |  | -29338 | 0
PROD_FIN | Energy Capital Resources |  |  | 2861 | 0
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets |  |  | 7096 | 830 |  | 0
 | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group |  |  | 0.5
OF_CHAIR | Office of the Chairman
TREASURY_INT | Other Interest Related Charges |  |  | -3776 | -15401
 | Overview
 | Total |  |  |  |  | Other Expenses:
 | (1) Excludes Cap. Charge & Operating Costs
 |  | MPR Change
 |  | Other Margin Changes |  |  |  | Other
 | Check Figures
 | Gas Trading
 | Emerging Businesses
Spreadsheet: 91276d1291048065-vlookup-working-for-some-values-but-not-others-book1
Sheet: Orders

 |  | Number of Cakes |  |  |  | 24
 |  |  | INGREDIENTS |  |  |  |  |  | QUANTITY |  |  |  |  | COSTS
 |  | Item Code |  | E001 |  |  |  |  |  | 6
 |  | Item Code |  | M001 |  |  |  |  |  | 568
 |  | Item Code |  | F001 |  |  |  |  |  | 500
 |  | Item Code |  | I001 |  |  |  |  |  | 500
 |  | Item Code
 |  | Item Code
 |  | Extra's | Little feet |  |  |  |  |  |  |  |  |  |  | 13.25
 |  | Extra's
 |  |  |  |  |  |  | Cost of Ingredients
 |  |  |  |  |  |  | Cost of Extras
 |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  | Cost per Cupcake (ingredients)
 |  |  |  |  |  | Cost Per Cupcake (charge)
 |  |  |  |  |  |  | TOTAL INCOME
 |  |  |  |  |  |  | TOTAL PROFIT
Spreadsheet: 150149d1334312168-copying-data-to-another-worksheet-test-tracker
Sheet: Instructors

FIRST NAME | INITIAL | LAST NAME | DEPARTMENT | TEST # COMPLETED | TEST RESULT % | DATE
Another Last | A | Sample | Sales |  | 10 | 2012-04-13 00:00:00
Last | A | Sample | Sales |  | 20 | 2012-04-13 00:00:00
Fourth | A | Sample | Management |  | 10 | 2012-04-13 00:00:00
Third | A | Sample | Public Affairs |  | 40 | 2012-04-13 00:00:00
Second | A | Sample | Accounting |  | 20 | 2012-04-13 00:00:00
First | A | Sample | Sales |  | 20 | 2012-04-13 00:00:00
Spreadsheet: 390895d1429791965-counting-most-common-string-across-two-columns-book3
Sheet: Sheet1

Team | Result
Rangers | L | L
[NAME] | L | W
[NAME] | D
[NAME] | D
[NAME] | W
[NAME] | L
Accrington | W
Notts County | W
[NAME] | L
[NAME] | L
[NAME] | W
Notts County | L
Derby County | W
Derby County | W
[NAME] | W
[NAME] | L
Burnley | D
Burnley | W
West Bromwich Albion | L
Stoke | D
[NAME] | L
Accrington | L
Stoke | W
[NAME] | L
[NAME] | L
Spreadsheet: 692269d1598248145-retrieve-data-based-on-qty-greater-than-zero-in-multiple-columns-test-file
Sheet: MRF

 | Total no. of items
 | Total Amount
 |  | [NAME] |  |  |  | (Auto Completion-Unique)
 | Item Code | Item Description | Qty. + UOM |  |  | Storage Location
 |  |  |  |  |  | STORAGE2
 |  |  |  |  |  | STORAGE3
 |  |  |  |  |  | STORAGE4
 |  |  |  |  |  | STORAGE5
Spreadsheet: 767768d1644610154-create-a-summary-sheet-to-include-data-their-from-multiple-sheets-dummy-workbook
Sheet: Sheet3

 | Date | Time | Item | PO Number | Quantity  Ordered | Quantity  Delivered | Booking  Reference Number | STATUS
JANUARY | 2022-01-04 00:00:00 | 10:00 | Forest Green | 448327 | 2000 | 2000 | 21184 | DELIVERED
 | 2022-01-13 00:00:00 | 10:00 | Forest Green | 448600 | 4000 | 4000 | 21317 | DELIVERED
 | 2022-01-28 00:00:00 | 10:00 | Forest Green | 448832 | 6000 | 6000 | 21556 | DELIVERED
FEBRUARY | 2022-02-16 00:00:00 | 12:00 | Forest Green | 449760 | 6000 |  | 21889 | NOT DELIVERED
Spreadsheet: e9d912e4-7688-43fa-a31b-12d1d66a6704
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
5446 | 15575 | [NAME] | Isom | USA | 0 | 00:23:06 | 00:00:00 | 00:34:49 | 00:00:00 | [NAME] | 1 | 01:29:48
5446 | 39249 | [NAME] | White | USA | 0 | 00:25:10 | 00:00:00 | 00:44:54 | 00:00:00 | 00:33:13 | 2 | 01:43:18
5446 | 39248 | [NAME] | [NAME] | USA | 0 | [NAME] | 00:00:00 | 00:43:55 | 00:00:00 | 00:39:39 | 3 | 01:50:12
5446 | 19237 | [NAME] | Wilkinson | USA | 0 | 00:23:40 | 00:00:00 | 00:46:43 | 00:00:00 | [NAME] | 4 | 01:50:43