tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 122185d1316645561-daily-monthly-yearly-pivot-tables-pivot-table-using-slicer
Sheet: Sheet1

Date | Month | Year | Name | Amount
2000-01-12 00:00:00 | January | 2000 | P.Bloggs | 35
2002-05-31 00:00:00 | May | 2002 | T.Thompson | 35
2000-01-12 00:00:00 | January | 2000 | C.Cook | 45
2000-01-29 00:00:00 | January | 2000 | N.McGregor | 36
2000-02-15 00:00:00 | February | 2000 | P.Bloggs | 37
2000-03-03 00:00:00 | March | 2002 | T.Thompson | 38
2000-03-20 00:00:00 | March | 2000 | C.Cook | 39
2000-04-06 00:00:00 | April | 2000 | N.McGregor | 40
2000-04-23 00:00:00 | April | 2000 | P.Bloggs | 41
2002-05-25 00:00:00 | May | 2002 | T.Thompson | 42
2002-05-28 00:00:00 | May | 2002 | C.Cook | 43
2002-05-31 00:00:00 | May | 2002 | N.McGregor | 44
2002-06-03 00:00:00 | June | 2002 | P.Bloggs | 45
2002-06-06 00:00:00 | June | 2002 | T.Thompson | 46
2002-06-09 00:00:00 | June | 2002 | C.Cook | 47
2002-06-12 00:00:00 | June | 2002 | N.McGregor | 48
Spreadsheet: 63443d1264370623-read-data-only-to-current-period-sample
Sheet: Sheet1

Current period |  | December
 |  |  |  | July | August | September | October | November | December | January | February | March | April | May | June |  | Total Available | Total Sold
 |  |  | Available | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  | A | 17 | 31 | 43 | 5 | 27 | 24
 |  |  | B | 49 | 30 | 2 | 38 | 36 | 21
 |  |  | C | 29 | 28 | 6 | 4 | 10 | 19
 |  |  | D | 19 | 29 | 25 | 22 | 12 | 22
 |  |  | E | 17 | 44 | 21 | 22 | 37 | 19
 |  |  | F | 35 | 8 | 47 | 8 | 29 | 45
 |  |  | G | 33 | 32 | 3 | 7 | 36 | 20
Problem: | How to get the Total Available (R5) to include all months up to Current Period (C1)
Spreadsheet: 745973d1630416580-finding-difference-of-two-dates-for-the-same-customer-name-and-the-same-receipt-type-and-c-interest-calculation
Sheet: Sheet1

Sr. No | Party Name | Receipt Type | Date | Amount | Days
1 | Laopala RG Ltd. | Land Premium | 2018-11-10 00:00:00 | 50000
2 | [NAME] | Lease Rent | 2018-11-15 00:00:00 | 20000
3 | Laopala RG Ltd. | Lease Rent | 2018-12-04 00:00:00 | 70000
4 | [NAME] | Lease Rent | 2019-01-20 00:00:00 | 40000
5 | Laopala RG Ltd. | Lease Rent | 2019-02-17 00:00:00 | 20000
 | Rate of Interest 12%
 | from this table, I want to calculate total calculate Interest for the year (01/04/2018 to 31/03/2019) for each Receipt Type for each party.. Interest will be calculated as = [Amount]*[No of Days/365]*[12%]
 | For Example, in case of Laopala RG Ltd,
 | a. Interest on land Premium will be calculated for (31/03/2019- 10/11/2018) Days on 50000,
 | b. Interest on Lease Rent will be calculated for (17/02/2019 - 04/11/2018) Days on 70000, + (31/03/2019 - 17/02/2019) Days on [70000+ ( Interest on Lease Rent (Calculated in [NAME]) ]
 | Can this be done using Excel [NAME] (Excel 2007 or Excel 2013 only) ? No VBA due to frequent transfer of files on gmail
 | Though this is similar to interest on ledger balances of a Party with two major difference, table consists more than one party and interest is to be calculated for each receipt type separately.
Spreadsheet: 763892d1642445214-vlookup-formula-with-match-for-4-worksheets-vlook-up-4-sheets
Sheet: Sheet2

name | id
[NAME] | 111
[NAME] | 222
[NAME] | 111
[NAME] | 222
[NAME] | 111
[NAME] | 222
[NAME] | 111
[NAME] | 222
[NAME] | 111
[NAME] | 222
Spreadsheet: joe_parks__14523__tdwaterhouse_2001
Sheet: Sheet1

 | Open | Close | SYMBOL | SHARES | PURCHASE PRICE | SALE PRICE | PURCHASE PRICE | SALE PRICE
 | 2001-01-10 00:00:00 | 2001-01-17 00:00:00 | QQQ | 50 | 58.25 | 63.5 | 2927.5 | 3159.98
 | 2001-02-07 00:00:00 | 2001-02-05 00:00:00 | QQQ | 100 | 61.97 | 65.61 | 6209 | 6548.78
 | 2001-02-14 00:00:00 | 2001-02-08 00:00:00 | QQQ | 100 | 56.46 | 61.62 | 5658 | 6149.79
 | 2001-02-27 00:00:00 | 2001-02-22 00:00:00 | QQQ | 100 | 51.43 | 55.71 | 5155 | 5558.81
 | 2001-02-28 00:00:00 | 2001-02-27 00:00:00 | QQQ | 100 | 48.92 | 50.11 | 4904 | 4998.83
 | 2001-03-06 00:00:00 | 2001-03-02 00:00:00 | QQQ | 100 | 48.23 | 50.51 | 4835 | 5038.83
 | 2001-03-16 00:00:00 | 2001-03-13 00:00:00 | QQQ | 100 | 43.6 | 48.81 | 4372 | 4868.83
 | 2001-03-27 00:00:00 | 2001-03-23 00:00:00 | DIA | 100 | 93.24 | 99.11 | 9339 | 9898.66
 | 2001-03-30 00:00:00 | 2001-03-29 00:00:00 | DIA | 100 | 98.45 | 96.66 | 9860 | 9653.67
Spreadsheet: 862757d1710399370-need-a-complex-formula-to-categorised-and-return-the-value-by-division-bananas
Sheet: Planilha1

MAIN ID | Fruit | BARCODE | STOCK QUANTITY
S01111 | Apple | A111
S01111 | Apple | A222
S01111 | Apple | A333
S02222 | Apple | A111
S02222 | Apple | A222
S03333 | [NAME] | A111
S03333 | [NAME] | A222
S03333 | [NAME] | A333
S03333 | [NAME] | A444
Spreadsheet: drew_fossum__8710__red rock- Y file
Sheet: EXHIBIT Y

EXHIBIT Y
Proposed Accounting Journal Entries to record
Abandonment of Compressors and Appurtenances for
Stations #1, #2, #3, and #4.
ACCOUNT | [NAME] |  |  |  |  | DEBIT | CREDIT
101 | Gas Plant In-Service |  |  |  |  |  | 22380981
108.1 | Accumulated Provision for Depreciation |  |  |  |  | 22380981
 | of Gas Utility Plant
 | To retire abandoned plant.
108.2 | Retirement Work in Progress |  |  |  |  | 400000
131 | Cash |  |  |  |  |  | 400000
 | To record Cost of Removal
131 | Cash |  |  |  |  | 0
108.2 | Retirement Work in Progress |  |  |  |  |  | 0
 | To Record Salvage Proceeds
108.2 | Retirement Work in Progress |  |  |  |  |  | 400000
108.1 | Accumulated Provision for Depreciation |  |  |  |  | 400000
 | of Gas Utility Plant
 | To [NAME] of Cost of Removal
108.2 | Retirement Work in Progress |  |  |  |  | 0
108.1 | Accumulated Provision for Depreciation |  |  |  |  |  | 0
 | of Gas Utility Plant
 | To Record Transfer of Salvage Proceeds
409 | Federal Income Taxes, Utility Operating Income |  |  |  |  |  | 1966988
146 | Federal Income Taxes Accrued-Payable through
 | Enron Corp.
409 | State Income Taxes, Utility Operating Income |  |  |  |  |  | 356699
146 | State Income Taxes Accrued-Payable through
 | Enron Corp.
 | To Record Current Income Taxes
410 | Federal Deferred Income Taxes, Utility |  |  |  |  | 1966988
 | Operating Income
282 | Federal Accumulated Deferred Income Taxes
410 | State Deferred Income Taxes, Utility |  |  |  |  | 356699
 | Operating Income
282 | State Accumulated Deferred Income Taxes
 | To Record Deferred Income Taxes
Spreadsheet: 21434d1208962695-removing-a-space-at-the-end-of-numerous-cells-removing-spaces-from-multiple-cells
Sheet: sheet1

Invoice Date | Net Bill | VAT | Gross Bill
Cust Id: FRES0001
 |  | 294.47 | 1,977.15 | #N/A
 |  | 215.90 | 1,449.59
 |  | 383.30 | 2,573.58 | 2004 | 6000.23
Jan 2005 | 3,068.72 | 537.03 | 3,605.75 |  |  |  |  | Sep 2004 | 1682.68 | 3365.36
Feb 2005 | 2,958.84 | 517.80 | 3,476.64 |  |  |  |  | Nov 2004 | 1233.69 | 2467.38
Mar 2005 | 4,195.21 | 734.16 | 4,929.37 |  |  |  |  | Dec 2004 | 2190.28
Apr 2005 | 5,181.88 | 906.83 | 6,088.71
May 2005 | 2,640.58 | 462.10 | 3,102.68 |  |  |  |  |  | 2916.37
Jun 2005 | 1,274.19 | 222.98 | 1,497.17
Jul 2005 | 2,421.72 | 423.80 | 2,845.52
Aug 2005 | 2,190.35 | 383.31 | 2,573.66
Sep 2005 | 2,711.93 | 474.59 | 3,186.52
Oct 2005 | 2,204.93 | 385.86 | 2,590.79
Nov 2005 | 4,353.11 | 761.79 | 5,114.90
Dec 2005 | 6,269.63 | 1,097.19 | 7,366.82
 |  |  |  | 2005 | £46,378,53
Jan 2006 | 3,421.03 | 598.68 | 4,019.71
Feb 2006 | 12,580.98 | 2,201.67 | 14,782.65
Mar 2006 | 15,509.63 | 2,714.19 | 18,223.82
Apr 2006 | 7,218.40 | 1,263.22 | 8,481.62
May 2006 | 6,234.87 | 1,091.10 | 7,325.97
Jun 2006 | 9,568.72 | 1,674.53 | 11,243.25
Jul 2006 | 7,127.53 | 1,247.32 | 8,374.85
Aug 2006 | 7,231.82 | 1,265.57 | 8,497.39
Sep 2006 | 7,799.17 | 1,364.85 | 9,164.02
Oct 2006 | 6,249.01 | 1,093.58 | 7,342.59
Nov 2006 | 7,830.60 | 1,370.36 | 9,200.96
Dec 2006 | 4,949.31 | 866.13 | 5,815.44
 |  |  |  | 2006 | 112472.27
Jan 2007 | 3,594.51 | 629.04 | 4,223.55
Feb 2007 | 3,167.70 | 554.35 | 3,722.05
Mar 2007 | 6,825.10 | 1,194.39 | 8,019.49
Apr 2007 | 4,322.82 | 756.49 | 5,079.31
May 2007 | 7,772.39 | 1,360.17 | 9,132.56
Jun 2007 | 7,798.74 | 1,364.78 | 9,163.52
Jul 2007 | 7,381.00 | 1,291.68 | 8,672.68
Aug 2007 | 11,273.17 | 1,972.80 | 13,245.97
Sep 2007 | 8,315.09 | 1,455.14 | 9,770.23
Oct 2007 | 11,744.17 | 2,055.23 | 13,799.40
Nov 2007 | 16,915.23 | 2,960.17 | 19,875.40
Dec 2007 | 6,654.32 | 1,164.51 | 7,818.83
 |  |  |  | 2007 | £112,522,99
Jan 2008 | 4,205.23 | 735.92 | 4,941.15
Feb 2008 | 7,102.94 | 1,243.01 | 8,345.95
 |  |  |  | 2008 | 13287.1
Spreadsheet: 734611d1622284062-find-the-maximum-and-minimum-values-ask529
Sheet: Sheet1

name | Price |  | name | MAX | MIN
Color TV | 2000 |  | TV | 5600 | 1800
Black and white TV | 1800 |  | washing machine | 7000 | 2334
34 inch TV | 5600
washing machine | 2334
dishwasher | 2100
Vegetable washing machine | 5433
Testing Machine | 3456
Color TV | 5000
Black and white TV | 4800 |  | MAX
Premium washing machine | 7000 |  | D2 = "TV" including Color TV,Black and white TV,34 inch TV, pls write a formula to find [NAME] the found value to CELL  E2)
 |  |  | D3 = "washing machine" including washing machine,Vegetable washing machine,Premium washing machine .  pls write a formula to find [NAME] the found value to CELL  E3)
 |  |  | Min
 |  |  | D2 = "TV" including Color TV,Black and white TV,34 inch TV, pls write a formula to find Min value(Write the found value to CELL  F2)
 |  |  | D3 = "washing machine" including washing machine,Vegetable washing machine,Premium washing machine .  pls write a formula to find Min value(Write the found value to CELL  F3)
Spreadsheet: a15823af-1caf-4305-af1b-b117d7fbbd32
Sheet: StartWindow

[NAME] for start window(updated: [NAME] 24 2013)
Command to modify the schedule:
 | Attribute Name | Value(or Start Time) | Duration | Command Option | Notice
x | Policy name
x | Schedule name
x | Sunday | 00:00:00 | 00:00:00
x | Monday | 00:00:00 | 00:00:00
x | Tuesday | 00:00:00 | 00:00:00
x | Wednesday | 00:00:00 | 00:00:00
x | Thursday | 00:00:00 | 00:00:00
x | Friday | 00:00:00 | 00:00:00
x | Saturday | 00:00:00 | 00:00:00
Spreadsheet: 868452d1715183314-excel-pickup-wrong-data-formula-error
Sheet: Historical

From Distributor (HT)/ Future customer
SKU | Description | NA1 | NA2 |  |  | 2023-11-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-04 00:00:00 | 2024-03-11 00:00:00 | 2024-03-18 00:00:00 | 2024-03-25 00:00:00
A1 | [NAME] |  |  | 52 | 47 | 11 | 8 | 11 | 23 | 12 | 4 | 1 | 1 | 1 | 35 | 2 | 7 | 6 | 3 | 13 | 81 |  |  | 1 | 13 | 15 |  | 1 | 0 | 10 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14
A2 | Bell2 |  |  | 101 | 60 | 20 | 29 | 18 | 78 | 43 | 11 | 14 | 3 | 3 | 115 | 39 | 11 | 12 | 15 | 12 | 205 |  |  | 13 | 58 | 67 |  | 37 | 36 | 20 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52
A3 | Bell3 |  |  | 76 | 47 | 11 | 13 | 7 | 16 | 24 | 7 | 4 | 3 | 5 | 59 | 6 | 8 | 5 | 7 | 4 | 50 |  | 7 | 1 | 7 | 17 |  | 1 | 0 | 11 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13
A4 | [NAME] |  |  | 91 | 50 | 19 | 29 | 13 | 17 | 28 | 5 | 8 | 0 | 4 | 109 | 34 | 11 | 9 | 13 | 4 | 52 |  |  | 3 | 36 | 46 |  | 28 | 27 | 27 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32
A5 | Bell5 |  |  | 70 | 57 | 19 | 26 | 3 | 16 | 10 | 5 | 3 | 0 | 2 | 96 | 34 | 10 | 7 | 10 | 3 | 14 | 2 | 6 | 3 | 27 | 41 |  | 23 | 22 | 5 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28
A6 | Bell6 |  |  | 47 | 43 | 7 | 9 | 8 | 33 | 7 | 2 | 0 | 2 | 1 | 34 | 0 | 7 | 5 | 4 | 1 | 79 |  |  | 2 | 14 | 14 |  | 3 | 2 | 10 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
A7 | Bell7 |  |  | 73 | 56 | 21 | 25 | 9 | 11 | 22 | 7 | 3 | 2 | 4 | 94 | 39 | 11 | 13 | 13 | 2 | 53 |  | 15 | 4 | 33 | 47 |  | 29 | 29 | 18 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37
A8 | Bell8 |  |  | 1 | 0 | 0 | 12 | 5 | 9 | 2 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 4 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
A9 | Bell9 |  |  | 0 | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 2.166 |  | 0 | 0 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
A10 | Bell10 |  |  | 0 | 0 | 0 | 12 |  | 9 | 2 | 1 | 0 |  |  |  |  |  | 0 |  |  |  | 0 | 0 |  |  | 1.8333 |  | 0 | 0 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Spreadsheet: 694972d1599927660-extract-unique-distinct-pairs-from-a-range-book1
Sheet: Sheet1

[NAME] | [NAME] |  | This is what the formula should return:
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
 |  | <---dynamic formula returns 7 unique pairs here, ignoring dupicates
Spreadsheet: joe_parks__14540__margas1
Sheet: Sheet1

 |  | Purchased | Sold | price | Total | paid
2002-03-01 00:00:00 | x | 25000 |  | 2.55 |  | 111600
2002-03-02 00:00:00 | x | 15000 |  | 2.48 |  | x
2002-03-03 00:00:00 | x | 15000 |  | 2.48 |  | x
2002-03-04 00:00:00 | x | 15000 |  | 2.48 |  | x
2002-03-05 00:00:00 | x | 15000 |  | 2.56 |  | 187500
2002-03-06 00:00:00
2002-03-07 00:00:00 |  |  | -20000 | 2.31 |  | 128450
2002-03-08 00:00:00 |  | 20000 |  | 2.6
2002-03-09 00:00:00 |  | 20000 |  | 2.715
2002-03-10 00:00:00 |  | 20000 |  | 2.715
2002-03-11 00:00:00 |  | 20000 |  | 2.715 |  | 388000
2002-03-12 00:00:00 |  | 20000 |  | 2.82
2002-03-13 00:00:00 |  | 15000 |  | 2.81
2002-03-14 00:00:00 |  | 4000 |  | 2.83
2002-03-15 00:00:00 |  | 4000 |  | 2.665
2002-03-16 00:00:00
2002-03-17 00:00:00
2002-03-18 00:00:00
2002-03-19 00:00:00
2002-03-20 00:00:00
2002-03-21 00:00:00
2002-03-22 00:00:00
2002-03-23 00:00:00
2002-03-24 00:00:00
2002-03-25 00:00:00
2002-03-26 00:00:00
2002-03-27 00:00:00
2002-03-28 00:00:00
2002-03-29 00:00:00
2002-03-30 00:00:00
2002-03-31 00:00:00
Spreadsheet: 32993d1229190162-value-and-codes-lookup
Sheet: Sheet1

[NAME] | 1 | 1 | d | d |  |  |  |  |  | input | output
[NAME] | d | 1 | 1 | 1 |  |  |  |  |  | 1 | 8
 |  |  |  |  |  |  |  |  |  | d | 0
result
[NAME]
jane
total hours
[NAME]
jane
Spreadsheet: kevin_hyatt__19592__ProjReqForm
Sheet: List Box info

Pipeline Name |  | Cost Estimate Level |  | Other Component, Units
 |  |  |  | Units?
Transwestern Pipeline Company |  | Level A (+/-30%) |  | mole %
Northern Natural Gas Company |  | Level B (+/-10%) |  | [NAME]
Other, specify |  |  |  | grs/100cf
 |  | Type of Expenditure
Type of Measurement |  |  |  | Type of Power Req'd
 |  | Reimbursable-Expense
EFM only |  | Reimbursable-Capital |  | Purchase
Orifice |  | Capital-Prepaid |  | Solar
Turbine |  | Capital-Enron |  | Generator
Ultrasonic |  | Expense, O&M |  | Provided by others
Bi-directional
Positive Displ. |  | Type of Regulatory Filing |  | Other Equipment Required
Type of Compression |  | "Auxiliary Installations" Sec 2.55a |  | Moisture monitor
 |  | "Like for Like" Sec 2.55b |  | Quality monitor
Gas driven - reciprocal |  | "On behalf Of" Sec 311 |  | Chromatograph
Gas driven - centrifugal |  | "Automatic or Prior Notice" Blanket |  | [NAME] sampler
Gas driven - rotary/screw |  | "Abandonment or Construction" Sec 7 |  | Actuator/Controller
Electric driven - centrifugal |  | Other, specify |  | CPU
 |  |  |  | Transmitter(s)
Other Gas Treating Facilities |  | Type of Piping Required |  | CPU & Xmtrs.
 |  |  |  | SCADA-phone line
Separation |  | Tap only |  | SCADA-tower/radio
Dehydration |  | Tap and riser |  | Cathodic Protection
[NAME]. |  | Tap and linepipe |  | [NAME]
Amine |  | Tap, linepipe & station |  | C.P.-Anode
Gas Cooler |  | Tap & station |  | C.P.-Rectifier
[NAME] |  | Station only
Other, specify
Type of Regulation
Pressure Cntrl
Flow Cntrl
P. & F. Cntrl
P. Cntrl w/ monitor
P. & F. Cntrl w/ monitor
F. Cntrl w/ monitor
Relief Valve
P. Cntrl w/ Rlf. Vlv
P. & F. Cntrl w/ Rlf. Vlv.
F. Cntrl w/ Rlf. Vlv.
Spreadsheet: 34549d1231862700-subtracting-cells-in-a-column-noble-1-
Sheet: Sheet2

Tractor | Trailers | Drivers | Month | Day | Year
5 | 1 | Scott | Jan. | 1 | 2008
3910 | 2 | Greg | Feb. | 2 | 2009
3911 | 3 | [NAME] | March | 3 | 2010
 | 4 | [NAME] | April | 4 | 2011
 | 71 | [NAME] | May | 5 | 2012
 | 6141 | [NAME] | June | 6 | 2013
 | 95889 |  | July | 7 | 2014
 | [NAME] |  | August | 8 | 2015
 |  |  | Sept. | 9 | 2016
 |  |  | Oct. | 10 | 2017
 |  |  | Nov. | 11 | 2018
 |  |  | Dec. | 12 | 2019
 |  |  |  | 13 | 2020
 |  |  |  | 14 | 2021
 |  |  |  | 15 | 2022
 |  |  |  | 16 | 2023
 |  |  |  | 17 | 2024
 |  |  |  | 18 | 2025
 |  |  |  | 19 | 2026
 |  |  |  | 20 | 2027
 |  |  |  | 21 | 2028
 |  |  |  | 22 | 2029
 |  |  |  | 23 | 2030
 |  |  |  | 24 | 2031
 |  |  |  | 25 | 2032
 |  |  |  | 26 | 2033
 |  |  |  | 27 | 2034
 |  |  |  | 28 | 2035
 |  |  |  | 29 | 2036
 |  |  |  | 30 | 2037
 |  |  |  | 31 | 2038
Spreadsheet: 883388d1732013848-sumif-not-working-if-sumif-to-a-self-define-array-sumif-not-working-if-array-nest-inside
Sheet: Sheet1

ID | Customer | Deposit |  | Customer | Deposit |  | Step 1 |  |  |  | What I wan
#1 | Abc | 700 |  |  |  |  |  | Abc | 700
#1 | Abc | 700 |  | EEE | #[NAME]! |  | #2 | Abc | 500 |  | 0
#1 | Abc | 700 |  | FFFF | #[NAME]! |  | #3 | EEE | 0 |  | 2300
#2 | Abc | 500 |  | GGG | #[NAME]! |  | #4 | FFFF | 1000 |  | 0
#3 | EEE |  |  | HHH | #[NAME]! |  | #5 | FFFF | 1000 |  | 800
#3 | EEE |  |  | JJJ | #[NAME]! |  | #6 | FFFF | 300 |  | 900
#3 | EEE |  |  |  | #[NAME]! |  | #7 | GGG | 0
#3 | EEE |  |  |  | #[NAME]! |  | #8 | HHH | 800
#4 | FFFF | 1000 |  |  | #[NAME]! |  | #9 | JJJ | 0
#4 | FFFF | 1000 |  |  | #[NAME]! |  | #10 | JJJ | 900
#5 | FFFF | 1000 |  |  | #[NAME]! |  | #11 | JJJ | 0
#6 | FFFF | 300
#7 | GGG
#7 | GGG
#8 | HHH | 800 |  |  | * My formula in F is same as column L,
#8 | HHH | 800 |  |  | just that I nested Step 1 inside F.
#9 | JJJ |  |  |  | How come it show errors in F while L is ok?
#10 | JJJ | 900
#11 | JJJ
 |  |  |  |  | in F |  |  |  |  |  | in L
 |  |  |  |  | SUMIF(INDEX(x,,2),E2#,INDEX(H2#,,3)) |  |  |  |  |  | SUMIF(INDEX(H2#,,2),E2#,INDEX(H2#,,3))
Spreadsheet: 675735d1588443673-use-data-in-multiple-cells-to-return-result-example
Sheet: Daily

 | Under 2
 | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday
 | AM | PM |  | AM | PM |  | AM | PM |  | AM | PM |  | AM | PM
 | 2 Year Old
 | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday
 | AM | PM |  | AM | PM |  | AM | PM |  | AM | PM |  | AM | PM
 | 3 Years +
 | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday
 | AM | PM |  | AM | PM |  | AM | PM |  | AM | PM |  | AM | PM
Spreadsheet: 86207d1286234809-how-to-lookup-multiple-rows-of-data-by-value-group-data
Sheet: Group B

Group | Data 1 | Data 2 | Data 3 | Data 4 | Data 5
B | 36 | 37 | 38 | 39 | 40
B | 41 | 42 | 43 | 44 | 45
B | 46 | 47 | 48 | 49 | 50
B | 51 | 52 | 53 | 54 | 55
B | 56 | 57 | 58 | 59 | 60
B | 61 | 62 | 63 | 64 | 65
B | 66 | 67 | 68 | 69 | 70
Spreadsheet: 875326d1721913976-sum-date-range-into-month-total-month-sum-etaf
Sheet: Sheet1

2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
DATE |  | TIME FRAME |  | AREA |  |  | TYPE |  |  | CUSTODIAN
 |  | START | END
2024-01-01 00:00:00
2024-01-20 00:00:00
2024-01-30 00:00:00
2024-03-30 00:00:00
Spreadsheet: 77859942-2e54-478c-beab-ead8b6802481
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FNTPX | Test | FNTPX | N-Telopeptide, Cross-Linked, Serum | N-Telopeptide, Cross-Linked, Serum | Quantitative Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain, red-top tube(s). (Serum gel tube is acceptable.) Spin down and send 0.5 mL serum frozen in a plastic vial. | 0.2 mL | Hemolysis:	Mild OK; Gross reject Thawing:	Warm reject; Cold OK Lipemia:	Mild OK; [NAME] OK Icterus:	NA Other:	NA | [NAME]: 5.4-24.2 nM BCE Premenopausal, [NAME]: 6.2-19.0 nM BCE   The target value for treated post-menopausal adult females is the same as the premenopausal reference interval.   BCE = Bone Collagen Equivalent   Test Performed by:  ARUP Laboratories                               500 [NAME]                               Salt Lake City, UT 84108 | Monday, Wednesday, Friday | 1-4 days | 3 - 6 days | 1 | 82523 |  |  |  |  | ARUP Laboratories
FNTPX | [NAME] | SERUM | Serum |  |  |  | Frozen | 180 days
FNTPX | Result | Z2645 | N-Telopeptide, Cross-Linked, Serum | N-Telopeptide, Cross-Linked, Serum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 748399d1632133521-google-sheets-allow-data-entry-only-against-current-date-not-past-or-future-dates-car-log-sheet
Sheet: Sheet1

 | CAR LOG SHEET
 | Employee Name:
 | Employee Code:
 | CAR #
 | DATE | KM Driven beyond working hours | DEPOT - IN |  | DEPOT - OUT |  | Total KM Run | Verified by
 |  |  | KM (A) | TIME | KM (B) | TIME
 | 1st Oct |  |  |  |  |  | 0
 | 2nd Oct | 0 |  |  |  |  | 0
 | 3rd Oct | 0 |  |  |  |  | 0
 | [NAME] | 0 |  |  |  |  | 0
 | 5th Oct | 0 |  |  |  |  | 0
 | 6th Oct | 0 |  |  |  |  | 0
 | 7th Oct | 0 |  |  |  |  | 0
 | 8th Oct
 | 9th Oct | 0 |  |  |  |  | 0
 | 10th Oct | 0 |  |  |  |  | 0
 | [NAME] | 0 |  |  |  |  | 0
 | 12th [NAME] | 0 |  |  |  |  | 0
 | 13th Oct | 0 |  |  |  |  | 0
 | 14th Oct | 0 |  |  |  |  | 0
 | 15th Oct
 | 16th Oct | 0 |  |  |  |  | 0
 | 17th Oct | 0 |  |  |  |  | 0
 | 18th Oct | 0 |  |  |  |  | 0
 | 19th Oct | 0 |  |  |  |  | 0
 | 20th Oct | 0 |  |  |  |  | 0
 | 21st Oct | 0 |  |  |  |  | 0
 | 22nd [NAME]
 | 23rd Oct | 0 |  |  |  |  | 0
 | 24th [NAME] | 0 |  |  |  |  | 0
 | 25th Oct | 0 |  |  |  |  | 0
 | [NAME] | 0 |  |  |  |  | 0
 | 27th Oct | 0 |  |  |  |  | 0
 | 28th Oct | 0 |  |  |  |  | 0
 | 29th Oct
 | 30th Oct | 0 |  |  |  |  | 0
 | 31st Oct | 0 |  |  |  |  | 0
 | Total KM run | 0 |  |  |  |  | 0
Spreadsheet: chris_germany__1778__FOM Oct-00
Sheet: October Storage

 |  | First-of-the Month Baseload Storage Injections/(Withdrawals)
 |  |  | Monthly | Daily
 |  |  | Inj/(WD) | Inj/(WD) | Delivery
LDC |  | Pipe/Service | Dth# | Dth# | Point
Atlanta Gas Light
 | IBSS
 | ## | Transco / AGL City Gate |  | 500 | citygate | This volume included in citygate requirements for AGL
 |  | Sonat / ANR Shadyside |  | 1468 | Shadyside | This volume was already purchased on SONAT as part of "customer retention hedge."
 | DAS | [NAME] WSS |  | 1573 | storage injection meter
 |  | Transco ESS |  | 80 | storage injection meter
 |  | Tennessee FS-MA |  | 0
 |  | Tennessee FS-PA |  | 0 | citygate
 |  | CNG |  | 0
 |  | SONAT |  | 2645 | storage injection meter
Columbia Gas of Ohio
 |  | TCO FSS |  | 3904 | storage injection meter
## IBSS injections on [NAME] at AGL citygate are included in Transco citygate requirements in "Total Reqs" and 'Oct-00 EPA' worksheets.