tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 178556ab-989e-4b26-b114-fffe45a686e6
Sheet: Sheet1

Statutory Results | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Half Year |  |  |  | Movement
 | Mar 13 $M | Sep 12 $M | [NAME] |  | Mar 13 v. Sep 12 | Mar 13 v. Mar 12
Net interest income |  | 6126 | 5984
Other operating income |  | 2768 | 2833
Operating income |  | 8894 | 8817
Operating expenses |  | -4386 | -4133
Profit before credit impairment and income tax |  | 4508 | 4684
Provision for credit impairment |  | -660 | -538
Profit before income tax |  | 3848 | 4146
Income tax expense |  | -1104 | -1223
Non-controlling interests |  | -2 | -4
Profit attributable to shareholders of the Company |  | 2742 | 2919
 | Half Year |  |  |  | Movement
Earnings per ordinary share (cents) | Mar 13 | Sep 12 | [NAME] |  | Mar 13 v. Sep 12 | Mar 13 v. Mar 12
Basic |  | 102.6429240862231 | 110.8320012179341
Diluted |  | 99.12989434431324 | 106.1545388425172
 | Half Year
Ordinary share dividends (cents) | [NAME] 13 | Sep 12 | [NAME] 12
Interim - 100% franked |  |  | 66
Final - 100% franked |  | 79
Ordinary share dividend payout ratio |  | 0.7852447041636231 | 0.6084862637362637
Preference share dividend ($M)
Dividend paid |  | 4 | 7
Profitability ratios
Return on average ordinary shareholders' equity |  | 0.1373016072010631 | 0.1557011094773426
Return on average assets |  | 0.008538611370179321 | 0.009534853335075456
Net interest margin |  | 0.02276642120109038 | 0.02352376946391437
Net interest margin (excluding Global Markets) |  | 0.02674252594252594 | 0.02747909466671123
Efficiency ratios
Operating expenses to operating income |  | 0.4931414436698898 | 0.4687535442894408
Operating expenses to average assets |  | 0.01365804138205926 | 0.01350035931273274
Credit impairment provisioning/(release)
Individual provision charge ($M) |  | 887 | 690
Collective provision charge/(release) ($M) |  | -227 | -152
Total provision charge ($M) |  | 660 | 538
Individual provision charge as a % of average net advances |  | 0.004189531373017243 | 0.003419786189020008
Total provision charge as a % of average net advances |  | 0.003120869871547833 | 0.002666441985061978
Refer to the March 2013 Consolidated Results & Dividend Announcement for explanations of terms
Spreadsheet: 195686d1353600255-cell-formating-and-sheet-protection-gilwern-invoice-xlv1
Sheet: Sheet1

 |  | Invoice
 |  | Invoice Number
 |  | Date
 |  | Customer
 |  | Ordr Number
 |  | Invoice Address
 |  | Delivery/Site Address
 |  | Fixed Price Job | [NAME] |  |  |  | Quantity | Unit Price | Amount
 |  | Option 1 | As per our quotation reference:
 |  | Option 2 | As per customer order reference:
 |  | Other
 |  | Parts Supplied | Description
 |  | Labour | Rate Detail
 |  | First 1/2 Hour
 |  | Subsequent 1/2 Hours
 |  | Other
 |  | Comments: |  |  |  |  |  | Sub-total
 |  |  |  |  |  |  |  | Carriage
 |  |  |  |  |  |  |  | VAT
 |  |  | Thank you. We appreciate your business. |  |  |  |  | Grand Total
 |  | Deltapoint Services
 |  | VAT Registration: 922 5317 42
 |  | Bank Details: Santander, Sort 09-01-28, Act 36080651 |  |  |  |  |  | Internal Use Only
 |  | 1 Crossroads, Gilwern,[NAME], [NAME], NP7 0DX |  |  |  |  |  | Amount Paid:
 |  | Phone: [PHONE]                  Fax: [PHONE] |  |  |  |  |  | Date:
 |  | www.deltapointservices.net        email: [EMAIL]
Spreadsheet: 815237d1674829315-take-the-qty-out-of-stock-vehicle-parts-pricing
Sheet: #25

 |  |  | Stock Codes
Date | Veh # | [NAME] | Part # | Description | Quantity | Product Cost | Total | In [NAME]
2022-09-06 00:00:00 | #25 | 1N6AD0ER4KN728147 | 5486WS |  | 1
2022-09-06 00:00:00 | #25 | 1N6AD0ER4KN728147 | F4683 |  | 1
 |  |  |  |  |  | Total |  | Yes
Spreadsheet: 63818d1264692125-excel-2007-automatically-sum-for-specific-lines-in-a-pivot-table-forum_example
Sheet: Sheet1

 |  | NOW: |  |  |  |  |  |  |  | Should be:
 |  | Region | (All) |  |  |  |  |  |  | Region | (All)
 |  | Sum of Commision EUR |  | Week |  |  |  |  |  | Sum of Commision EUR |  | Week
 |  | Location | Year | 3 | 2 | 1 | Grand Total |  |  | Location | Year | 3 | 2 | 1 | Grand Total
 |  | Amsterdam | 2010 | 78000 | 100000 | 20000 | 198000 |  |  | Amsterdam | 2010 | 78000 | 100000 | 20000 | 198000
 |  |  | 2009 | 160000 | 80000 | 25000 | 265000 |  |  |  | 2009 | 160000 | 80000 | 25000 | 265000
 |  | Amsterdam 2 | 2010 | 2000 | 60000 | 20000 | 82000 |  |  | Amsterdam 2 | 2010 | 2000 | 60000 | 20000 | 82000
 |  |  | 2009 | 200 | 2000 | 14000 | 16200 |  |  |  | 2009 | 200 | 2000 | 14000 | 16200
 |  | Amsterdam 3 | 2010 | 60000 | 3000 | 16000 | 79000 |  |  | Amsterdam 3 | 2010 | 60000 | 3000 | 16000 | 79000
 |  |  | 2009 | 10000 | 4000 | 17000 | 31000 |  |  |  | 2009 | 10000 | 4000 | 17000 | 31000
 |  | Amsterdam 4 | 2010 | 14000 | 7000 | 2000 | 23000 |  |  | Amsterdam 4 | 2010 | 14000 | 7000 | 2000 | 23000
 |  |  | 2009 | 3000 | 2000 | 5000 | 10000 |  |  |  | 2009 | 3000 | 2000 | 5000 | 10000
 |  | Amsterdam 5 | 2010 | 240000 | 100000 | 15000 | 355000 |  |  | Amsterdam 5 | 2010 | 240000 | 100000 | 15000 | 355000
 |  |  | 2009 | 200000 | 50000 | 17000 | 267000 |  |  |  | 2009 | 200000 | 50000 | 17000 | 267000
 |  | Amsterdam 6 | 2010 | 20000 | 30000 | 20000 | 70000 |  |  | Amsterdam 6 | 2010 | 20000 | 30000 | 20000 | 70000
 |  |  | 2009 | 15000 | 40000 | 30000 | 85000 |  |  |  | 2009 | 15000 | 40000 | 30000 | 85000
 |  | Amsterdam 7 | 2009 | 2000 | 50000 | 70000 | 122000 |  |  | Amsterdam 7 | 2009 | 2000 | 50000 | 70000 | 122000
 |  | Amsterdam 8 | 2010 | 20000 | 3000 | 75000 | 98000 |  |  | Amsterdam 8 | 2010 | 20000 | 3000 | 75000 | 98000
 |  |  | 2009 | 10000 | 33000 | 23000 | 66000 |  |  |  | 2009 | 10000 | 33000 | 23000 | 66000
 |  | Grand Total |  | 834200 | 564000 | 369000 | 1767200 |  |  | Grand Total | 2010
 |  |  |  |  |  |  |  |  |  | Grand Total | 2009
Spreadsheet: 738599d1625142413-how-to-use-sumif-or-vlookup-throughout-all-sheets-of-excel-test-sheet
Sheet: Sheet4

Supplier 1 | 1
Supplier 2 | 2
Supplier 3 | 4
Supplier 4 | 6
Supplier 5 | 5
Supplier 6 | 654
Supplier 7 | 64
Supplier 8 | 7
Supplier 9 | 4674
Supplier 10 | 345
Supplier 11 | 45
Supplier 12 | 654
Supplier 13 | 654
Spreadsheet: 65740d1266422637-return-the-max-value-from-pivot-table-totals-example
Sheet: Sheet1

 | Pivot
 | Date | Manager | Supervisor | AGENT | SALES
 | 2010-02-16 00:00:00 | ManagerName | Supv1 | Agenta | 0
 |  |  |  | Agentb | 2
 |  |  | Supv1 Total |  | 2
 |  |  | Supv2 | Agentc | 5
 |  |  | Supv2 Total |  | 5
 |  |  | Supv3 | Agentd | 1 |  |  | Summary
 |  |  |  | Agente | 0 |  |  | Yesterday
 |  |  | Supv3 Total |  | 1
 |  | ManagerName  Total |  |  | 8 |  |  |  | Supv | Sales
 | 2010-02-17 00:00:00 | ManagerName | Supv1 | Agenta | 3 |  |  | Top | Supv2 | 5
 |  |  |  | Agentb | 2 |  |  | Bottom | Supv3 | 1
 |  |  | Supv1 Total |  | 5
 |  |  | Supv2 | Agentc | 7
 |  |  | Supv2 Total |  | 7
 |  |  | Supv3 | Agentd | 2
 |  |  |  | Agente | 1
 |  |  | Supv3 Total |  | 3
 |  | ManagerName  Total |  |  | 15
Spreadsheet: 94534d1294327839-stuck-up-in-using-lookup-and-reference-prob2
Sheet: Sheet1

A | day1 | eve1 | ngt1
B | day2 | eve2 | ngt2
C | day3 | eve3 | [NAME]
D | day4 | eve4 | ngt4
E | day5 | [NAME] | ngt5
fri1 | A
fri2 | B
fri3 | C
fri4 | D
fri5 | E
fri6 | A
fri7 | B
fri8 | C
fri9 | D
fri10 | E
fri11 | A
fri12 | B
fri13 | C
[NAME] | D
fri15 | E
fri16 | A
[NAME] | B
[NAME] | C
fri19 | D
fri20 | E
fri21 | A
fri22 | B
fri23 | C
fri24 | D
fri25 | E
fri26 | A
fri27 | B
fri28 | C
fri29 | D
fri30 | E
fri31 | A
fri32 | B
fri33 | C
fri34 | D
fri35 | E
fri36 | A
fri37 | B
fri38 | C
fri39 | D
fri40 | E
fri41 | A
fri42 | B
[NAME] | C
fri44 | D
fri45 | E
fri46 | A
fri47 | B
fri48 | C
fri49 | D
fri50 | E
[NAME] | A
fri52 | B
fri53 | C
[NAME] | D
fri55 | E
Spreadsheet: e41d476b-867a-4744-9b2c-7dec3ff1f80a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42239642 | 2014-07-10 12:04:15 | AXIS | 1 | 6 | 4 | 1542223 | guy.warmoes | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
42239766 | 2014-07-10 12:14:37 | ALLIES | 1 | 6 | 0 | 1542223 | guy.warmoes | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
42239874 | 2014-07-10 12:34:16 | ALLIES | 0 | 3 | 6 | 1542223 | guy.warmoes | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
42240048 | 2014-07-10 12:55:24 | AXIS | 0 | 3 | 6 | 1542223 | guy.warmoes | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
42244116 | 2014-07-10 19:46:59 | AXIS | 1 | 6 | 3 | 1005773 | Verny | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42244790 | 2014-07-10 20:39:58 | ALLIES | 1 | 6 | 5 | 1005773 | Verny | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42316526 | 2014-07-15 20:29:16 | AXIS | 1 | 6 | 4 | 973858 | Sadoprest | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 58

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
58 | 2007-01-31 00:00:00 | 7.7 | 3.17 | 11.8 | 4.7 | 17.5 | 4.8 |  |  |  | 28 |  | 8.61640436855329 | 8.2 | 0.2 | 20 |  |  |  |  | 1
Well #58 | 2013-10-11 00:00:00 | 7.5 | 2.11 | 11.06 | 3.46 | 4.6 | 3.2 |  |  | 4.6 | 12.9 |  | 1.7 | 4.2 | 0.06 | 2.3 |  | <0.10 | 0.21 |  | 0.5
Well - 58 | 2014-02-12 00:00:00 | 7.8 | 2.95 | 8.77 | 3.6 | 15 | 5 |  |  | 2.6 | 20.3 |  | 6 | 15.2 | 0.06 | 8.9 |  | <0.10 | <0.02 |  | 0.4
Well 58 | 2015-03-24 00:00:00 | 7.7 | 2.85 | 8.53 | 3.42 | 15.8 | 5.1 |  |  | 2.6 | 21.7 |  | 6.4 | 16.2 | 0.06 | 5.8 |  | <0.10 | <0.02 |  | 0.8
Well 58 | 2016-04-01 00:00:00 | 7.96 | 2.992 | 8.809999999999999 | 3.6 | 17.5 | 4.72783950123891 | 4.72783950123891 | 0 | 2.76 | 21.439 | 1913.6 | 7.03 | 16.4 | 0.024 | 8.1357 | 0.018 | 0.006 | 0.002 | 0.052
Well 58 | 2017-05-02 00:00:00 | 7.61 | 2.999 | 8.78 | 3.47 | 18.2 | 4.763807849092799 | 4.763807849092799 | 0 | 2.85 | 27.682 | 1919 | 7.35 | 17.17 | 0.049 | 7.4748 | 0.003 | 0.034 | 0.002 | 0.016
W58 | 2018-05-30 00:00:00 | 7.87 | 3.069 | 8.74 | 3.59 | 18.2 |  | 4.881704100391656 | 0 | 3 | 19.541 | 1964 |  |  | 0.057 | 8.502 | 0.046 | 0 | 0 | 0.016
Spreadsheet: 888143d1738587022-extract-multiple-employee-id-based-on-project-name-from-one-sheet-to-another-using-formula-sample_repivot_data
Sheet: Required 

Required Result
SL.no | Project | Name
 |  |  |  |  |  | 1) | Projects may be in total of 100 to 150 nos
1 | Project-1 |  |  |  |  | 2) | Employee / Name will be Around 500 nos
 | Project-2 |  |  |  |  | 3) | Unique data is Employee ID that could be Numeric or [NAME] numeric
 | Project-3 |  |  |  |  | 4) | Data Range could be "A1 to AIN 142"
 | Project-4
 | Project-5
 | Project-6
 | Project-7
 | Project-8
 | Project-9
 | Project-10
 | Project-11
 | Project-12
 | Project-13
Spreadsheet: 67855d1268371409-return-sales-for-specified-month-and-department-721457-return-sales-for-specified-month-and-department
Sheet: Examples

 | EXAMPLE 1 |  |  |  |  |  |  |  |  | EXAMPLE 2
 | Month | 2010-06-01 00:00:00 | <-------- | Specified by user |  |  |  |  |  | Month | 2010-02-01 00:00:00 | <-------- | Specified by user
 | Type | Ladies | <--------- | Specified by user |  |  |  |  |  | Type | [NAME] | <--------- | Specified by user
 |  | Mem No. | Name | Amount |  |  |  |  |  |  | Mem No. | Name | Amount
 | ANSWER |  |  |  |  |  |  |  |  | ANSWER
 |  | Result should look like: |  |  |  |  |  |  |  |  | Result should look like:
 | Month | 2010-06-01 00:00:00 |  |  |  |  |  |  |  | Month | 2010-02-01 00:00:00
 | Type | Ladies |  |  |  |  |  |  |  | Type | [NAME]
 |  | Mem No. | Name | Amount |  |  |  |  |  |  | Mem No. | Name | Amount
 |  | 843 | [NAME] | 3 |  |  |  |  |  |  | 222 | [NAME] | 5
 |  | 320 | [NAME] | 4 |  |  |  |  |  |  | 456 | [NAME] | 9
 |  |  |  |  |  |  |  |  |  |  | 359 | [NAME] | 7
Spreadsheet: 693308d1598906235-summarize-a-list-newlist-2-index-and-small-6-
Sheet: List

[NAME] | Name of project | Order Date | [NAME]. | Salesperson | [NAME].
1 | test 1 | 2020-03-31 00:00:00 | 10101001 | Person 1 | 1899
 | test 2 | 2020 04 02 | 10201001 | Person 2 | 1898
1 | test 3 | 2020-05-01 00:00:00 | 10201001 | Person 1 | 1899
 | test 4 | 2020-06-12 00:00:00 | 10201001 | Person 2 | 1898
1 | test 5 | 2020-07-07 00:00:00 | 10201001 | Person 1 | 1899
1 | test 6 | 2021-06-01 00:00:00 | 10201001 | Person 2 | 1898
Overview:
Name of project | Order Date | [NAME]. | Salesperson | [NAME].
Spreadsheet: theresa_staab__39596__Producer Pricing Detail Nov01
Sheet: North Finn Summary

in |  | [NAME] To: |  |  | Remit To:
 |  |  |  |  | North Finn LLC | Verification Date:
 |  | Enron North America Corp. |  |  | Hilltop National Bank
 |  |  |  |  | Routing #10230119
 |  |  |  |  | Account #021674 | Due Date:
 |  |  |  |  | Country Club Rd. | 2001-12-26 00:00:00
 |  |  |  |  | Casper, WY  82609
 |  |  |  |  |  | Payment Method:
 |  | Contact:  [NAME] |  |  | Attn:  [NAME] | Wire
 |  | Tel:  (303) 575-6485 |  |  | Phone:  (307) 237-7854 | Terms:
Enron North America Corp. |  | Fax: (303) 534-0552 |  |  | E-mail:  [EMAIL] | On or before 25th of month
Delivery Period: | Contract # | Meter # / Meter Name
 | [NAME] | 0814042-Palomino #3 Discharge Mtr
 | Index | Discount / Premium | Price/MMBtu | Mcf Quantity | MMBtu Quantity | Amount Due
 | CIG GD
 |  | Fuel Loss | $             0.00 |  |  | $                                        0.00
 |  |  | TOTAL PAYMENT
Spreadsheet: 833148d1686817304-power-query-how-to-get-prev-months-value-how-to-get-prev-months-value-example-spreadsheet-aligw
Sheet: Sheet1

Data Set |  |  |  | Fake Pivot Table with intended result |  |  |  | slicers non functional for demonstration
Date | Item | Stock |  | Row Labels | Sum of Stock | Stock Change |  |  |  |  |  |  |  |  | Date | Item | Stock | Stock Change
2023-01-01 00:00:00 | Box | 100 |  | Mar | 373 | 168 |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Bag | 137 | 11
2023-01-01 00:00:00 | Bottle | 84 |  | Bag | 137 | 11 |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Barrel | 8 | 8
2023-01-01 00:00:00 | Crate | 65 |  | Barrel | 8 | 8 |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Bottle | 22 | 22
2023-01-01 00:00:00 | Barrel | 45 |  | Bottle | 22 | 22 |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Box | 152 | 86
2023-01-01 00:00:00 | Bag | 67 |  | Box | 152 | 86 |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Crate | 54 | 41
2023-02-01 00:00:00 | Box | 66 |  | Crate | 54 | 41 |  |  |  |  |  |  |  |  | Total
2023-02-01 00:00:00 | Bottle | 0 |  | Grand Total | 373
2023-02-01 00:00:00 | Crate | 13
2023-02-01 00:00:00 | Barrel | 0
2023-02-01 00:00:00 | Bag | 126
2023-03-01 00:00:00 | Box | 152
2023-03-01 00:00:00 | Bottle | 22
2023-03-01 00:00:00 | Crate | 54
2023-03-01 00:00:00 | Barrel | 8
2023-03-01 00:00:00 | Bag | 137
2023-04-01 00:00:00 | Box | 100
2023-04-01 00:00:00 | Bottle | 96
2023-04-01 00:00:00 | Crate | 31
2023-04-01 00:00:00 | Barrel | 8
2023-04-01 00:00:00 | Bag | 218
2023-05-01 00:00:00 | Box | 147
2023-05-01 00:00:00 | Bottle | 4
2023-05-01 00:00:00 | Crate | 27
2023-05-01 00:00:00 | Barrel | 56
2023-05-01 00:00:00 | Bag | 222
Spreadsheet: 467675d1466809011-excel-data-transfer-vlook-1
Sheet: JAN '16 

 |  |  |  |  |  |  |  |  |  | %Tunnel Steam Condensate Return
 |  |  |  |  |  |  |  |  |  | 60# Tunnel East = |  |  | 60# Tunnel West=
 |  | Boiler Steam Flow |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tunnel Steam
 |  | M1 | #1 Boiler |  | M2 | #2 Boiler |  | Daily Peak | M3 | [NAME] |  | M4 | Autoclave |  | Total Steam produced from month |  | M5 | 60# Tunnel East |  | M6 | 60# Tunnel West |  |  | M7 | Main Plant Steam |  | Total monthly Steam to Campus
 |  | Steam Flow Klbs |  |  | Steam Flow Klbs |  |  | Steam Flow Klbs | Steam Flow Klbs |  |  | Steam Flow Klbs |  |  | Klbs |  | Steam Flow Klbs (from lb mass) |  |  | Steam Flow Klbs (from lb mass) |  |  | Tunnel Steam | East and West from Siemens Klbs |  |  | Klbs
 |  | Read From Wonderware |  |  | Read From Wonderware |  |  |  |  |  |  | Read From FC on Panel at ACSG |  |  |  |  | Read From Siemens |  |  | Read From Siemens |  |  | Klbs. | Read From Siemens
Month | Date | Present | Previous | Difference | Present | Previous | Difference | (#1 + #2) | Present | Previous | Difference | Present | Previous | Difference |  |  | Present | Previous | Difference  ÷ 1000Klbs | Present | Previous | Difference  ÷ 1000 Klbs | East  +  West | Present | Previous | Difference
January | 2016-01-01 00:00:00 | 454891 | 410452 |  | 530513 | 456753 |  |  | 57 | 152 |  | 533672 | 285004 |  |  |  | 554646 | 497655 |  | 25490858 | 22473240 |  |  | 80257 | 502
 | 2016-01-02 00:00:00
 | 2016-01-03 00:00:00
 | 2016-01-04 00:00:00
 | 2016-01-05 00:00:00
 | 2016-01-06 00:00:00
 | 2016-01-07 00:00:00
 | 2016-01-08 00:00:00
 | 2016-01-09 00:00:00
 | 2016-01-10 00:00:00
 | 2016-01-11 00:00:00
 | 2016-01-12 00:00:00
 | 2016-01-13 00:00:00
 | 2016-01-14 00:00:00
 | 2016-01-15 00:00:00
 | 2016-01-16 00:00:00
 | 2016-01-17 00:00:00
 | 2016-01-18 00:00:00
 | 2016-01-19 00:00:00
 | 2016-01-20 00:00:00
 | 2016-01-21 00:00:00
 | 2016-01-22 00:00:00
 | 2016-01-23 00:00:00
 | 2016-01-24 00:00:00
 | 2016-01-25 00:00:00
 | 2016-01-26 00:00:00
 | 2016-01-27 00:00:00
 | 2016-01-28 00:00:00
 | 2016-01-29 00:00:00
 | 2016-01-30 00:00:00
 | 2016-01-31 00:00:00
 | Total Usage
 |  |  |  | Klbs |  |  | Klbs | Klbs |  |  | Klbs |  |  | Klbs |  |  |  |  | Klbs |  |  | Klbs | Klbs |  |  | Klbs
Spreadsheet: 488964d1478925023-function-help-categorizing-budgets
Sheet: Budget Tracking

 | 2017
 | MONTHLY | BUDGET | Budget Remaining
A3 | Transportation/Gas | 100
A4 | Clothing | 50
A5 | Entertainment | 50
A6 | Groceries | 125
A7 | Restaurant/Bars | 200
A8 | Alcohol | 45
 | Budget Total:
 | Spenditure Tracking |  | January | February | March | April | May | June | July | August | September | October | November | December
 | Item | Category
 | Gas | A3 | 75
 | Beer | A8 | 22
 | Movies | A5 | 25
 | Wings | A7 | 800
 |  | A3 | 55
 |  | A7 | 55
 | Running Total:
 | Total Budget Left:
Spreadsheet: 870839d1717287385-calculate-total-hours-and-minutes-total-hours-min
Sheet: Sheet1

 |  | START OF OPERATION | 01:00:00 |  |  | 2024-05-27 00:00:00
 |  | SUSPENDED | 05:55:00 |  |  | 2024-05-27 00:00:00
 |  | RESUMED | 06:50:00 |  |  | 2024-05-27 00:00:00
 |  | SUSPENDED | 12:30:00 |  |  | 2024-05-27 00:00:00
 |  | RESUMED | 00:25:00 |  |  | 2024-05-29 00:00:00
 |  | SUSPENDED | 11:15:00 |  |  | 2024-05-29 00:00:00
 |  | RESUMED | 01:00:00 |  |  | 2024-05-31 00:00:00
 |  | COMPLETE OF OPERATION | 11:35:00 |  |  | 2024-05-31 00:00:00
 |  | TOTAL OPERATION HOURS : MINUTES | ?
Spreadsheet: 715709d1611841281-metric-to-determine-the-amount-of-quantity-for-a-certain-amount-of-allocated-funds-example-help-metric
Sheet: Issue

Account | Unit Price | Quantity | Input Cost | Funds Allocated
ExampleName | 3.5e-05 |  |  | 84981
ExampleName | 3.5e-05 |  |  | 27534
ExampleName | 3.5e-05 |  |  | 479274
ExampleName | 3.5e-05 |  |  | 163675
ExampleName | 3.5e-05 |  |  | 42127
ExampleName | 3.5e-05 |  |  | 4083
ExampleName | 3.5e-05 |  |  | 42764
Spreadsheet: 275446d1383516495-finding-a-value-in-row-based-on-a-condition-sample
Sheet: Sheet2

Name | Age | Weight | Height | Name | Age | Weight | Height | Name | Age | Weight | Height | Name | Age | Weight | Height
[NAME] | 20 | 108 | 5 | Rachel | 30 | 175 | 6 | Samule | 20 | 150 | 6 | [NAME] | 34 | 125 | 5
Spreadsheet: 1b302f33-e2ce-45a4-a2cc-e15fff778a5b
Sheet: MULTIFAMILY  

 |  |  | CITY OF RIO RANCHO, NEW MEXICO
 |  |  | JULY 2014 MULTI-FAMILY
APPLICATION TYPE | ADDRESS |  |  |  | LEGAL DESCRIPTION |  |  | PERMIT |  | STATUS | YMMDD | SQUARE FOOTAGE | VALUATION | # OF UNITS
 | Street Number | Street Name | Suffix | Quandrant | Unit | Block | Lot | Permit Year | Permit number
 |  |  | NONE | FOR | JULY | 2014
Spreadsheet: lynn_blair__24442__REPS COVERAGE 2001
Sheet: Sheet1

 |  |  |  | PRIMARY | PRIMARY | [NAME]
 |  |  |  | REPS | BACK UP | BACK UP
 |  | REPORTS
 |  | [NAME] PRICING |  | RANDY | [NAME] | SHERRY/HARRY
 |  | LAMAR POWER PLT TRUEUP |  | JEAN | RANDY | JOE
 |  | GREAT RIVER POWER PLT |  | JEAN | [NAME] | JOE
 |  | PVR REPORT |  | HARRY | JOE | [NAME]
 |  | ONEOK OBA GATHERING |  | JOE | HARRY | [NAME]
 |  | NNG ADMINISTRATIVE CONT |  | CHRIS | [NAME] | SHERRY
 |  | SPS POWER PLT TRUE UP |  | [NAME] | JEAN | CHRIS
 |  | CONOCO POWER PLT TRUE UP |  | [NAME] | HARRY | SCOTT
 |  | MOPS DAILY TO GAS CONTROL |  | CARA | [NAME] | [NAME]
 |  | [NAME]OXY ALLOC. |  | JOE | HARRY | CHRIS
 |  | TRANSCO NOMINATIONS |  | CARA | [NAME] | JOE
 |  | SHIPPERS
 |  | BP AMOCO |  | HARRY | [NAME] | JOE
 |  | DUKE MKTG |  | [NAME] | [NAME] | RANDY
 |  | DUKE GPM |  | RANDY | JOE | CHRIS
 |  | DYNEGY |  | SCOTT | SHERRY | CHRIS
 |  | EL PASO MKTG |  | KATHY | SCOTT | CARA
 |  | ENA |  | JEAN | CHRIS | JOE
 |  | ONEOK ENERGY |  | JOE | HARRY | [NAME]
 |  | RELIANT ENERGY |  | [NAME] | SCOTT | [NAME]
 |  | TRANSCANADA |  | SHERRY | CHRIS | HARRY
 |  | USGT |  | RANDY | SHERY | JOE
 |  | WEST TX GAS |  | [NAME] | HARRY | JEAN
 |  | OPERATORS
 |  | EL PASO NATURAL |  | SCOTT | CHRIS | JOE
 |  | TRANSWESTERN |  | CHRIS | SHERRY | SCOTT
 |  | PANHANDLE EASTERN |  | CARA | RANDY | [NAME]
Spreadsheet: 2a39c681-4df5-4c1a-a57b-6b2b72df1ed7
Sheet: Sheet1

Table 6--Wheat: National average prices received by farmers by class (dollars per bushel), 7/13/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | Hard red winter |  | Soft red winter |  | Hard red spring |  | White
 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12
June | 3.94 | 7.2 | 4.5 | 7 | 4.59 | 9.34 | 4.28 | 6.94
July | 4.38 | 6.96 | 4.77 | 6.5 | 4.72 | 8.49 | 5.26 | 6.72
August | 5.42 | 7.42 | 5.75 | 7.08 | 5.49 | 8.37 | 5.52 | 6.79
September | 5.82 | 7.27 | 5.89 | 6.91 | 6.03 | 8.21 | 5.54 | 6.56
October | 6.09 | 6.82 | 6.12 | 6.64 | 5.96 | 8.38 | 5.76 | 6.04
November | 6.15 | 6.66 | 5.46 | 6.25 | 6.41 | 8.65 | 5.88 | 6.07
December | 6.51 | 6.54 | 6.73 | 6.58 | 6.64 | 8.43 | 6.07 | 6.13
January | 6.5 | 6.71 | 6.31 | 6.85 | 7.22 | 8.33 | 6.05 | 6.17
February | 7.07 | 6.75 | 7.11 | 7.1 | 7.7 | 8.22 | 6.78 | 6.44
March | 7.1 | 6.72 | 6.7 | 6.7 | 8.12 | 8.13 | 6.65 | 6.63
April | 7.5 | 6.43 | 7.27 | 6.67 | 8.75 | 8.05 | 7.06 | 6.55
May | 8 | 6.35 | 7.09 | 6.75 | 8.95 | 8.01 | 7.22 | 6.54
Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 7/12/2012
Spreadsheet: 880586d1728397557-trying-to-create-a-count-of-parts-like-a-stock-check-parts-count
Sheet: Sheet1

 | Early Version Changes in bold
 | Part | Type | Qty | No of Pins | Circuit section | Function
 | Semiconductors
 | 23 | 74LS20 | 1 |  | RAM
 | 24 | 74LS10 | 1 |  | RAM
 | 25 | 74LS32 | 1 |  | RAM
 | 26 | 74LS612 | 1 |  | Ebus (Memory)
 | 27 | 74LS04 | 1 |  | RAM
 | 28 | 74LS27 | 1 |  | RAM
 | 29 | 74LS27 | 1 |  | RAM
 | 30 | 74LS02 | 1 |  | RAM
 | 31 | 74LS00 | 1 |  | RAM
 | 32 | TMS4500 | 1 |  | RAM | [NAME] controller
 | 33 | 74LS139 | 1 |  | RAM
 | 34 | 74LS138 | 1 |  | RAM
 | 35 | 74LS138 | 1 |  | RAM
 | IC36-43 | TMS4164 | 8 |  | RAM | Main RAM
 | 44 | 74LS245 | 1 |  | RAM
 | IC45-47 | TMS2564 | 3 |  | RAM | EPROM
 | 48 | TMS9929 | 1 |  | Video | VDP
 | IC49-56 | 4816 | 8 |  | Video | Video RAM
 | 57 | 4016B | 1 |  | Video
 | 58 | 4016B | 1 |  | Video
 | 59 | LM1889 | 1 |  | Video
 | 60 | 4013 | 1 |  | Video
 | Miscellaneous
 | IC socket 14 way
 | IC socket 16 way
 | IC socket 18 way
 | IC socket 20 way
 | IC socket 28 way
 | IC socket 40 way