tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40367__EMNNG02PL
Sheet: RegAmort

PRINT: PAGE1
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Gas Research Institute (GRI) Calculation
2002 GRI Rate   (INPUT)
North Transport Commodity Volume   (INPUT VOLUME) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Full Margin % |  | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828
Full Margin Volume - North
South Transport Commodity Volume   (INPUT VOLUME) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0
Full Margin Volume - South
Commodity GRI Expense - North
- South
Total Transport Commodity GRI Expense
Total Transport Demand GRI Expense (INPUT $ AMOUNT) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total GRI Expense
REGULATORY AMORTIZATION EXPENSE
Regulatory Commission Expense | Link D.T.
ACA Expense Amortization | Link D.T.
GSR / GSR R.A. / Rev. Auction 1 (Tracked) | Linked
Order 528 75% Expense | Linked
GRI - Transport Commodity (9302-701)
- Transport Demand
- Discount Adjustment |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- GRI Savings Adjustment |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FAS 106 Amortization | Link D.T.
2223 Dodge Street Buyout Amortization | Link D.T.
Severance & Relocation Amortization | Link D.T.
Uncollectible Accounts Amortization | Link D.T.
Fuel / UAF Amortization | Link D.T.
Equivalent Unit Risk Amortization (SLA) | Link D.T.
Misc. NNG Reg. Assets Item 1
Misc. NNG Reg. Assets Item 2
GSR Expense - Demand Tracker | Linked
- Commodity Tracker | Linked
GSR R.A. Expense Tracker | Linked
Order 528 Expense Tracker | Linked
IMP Amortization | Link D.T.
South Georgia (FAS 96) Adjustment | Link D.T.
Writeoffs (Non Tracked)
Misc. Item 1 (Non Tracked)
Misc. Item 2 (Non Tracked)
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL REGULATORY AMORTIZATION
Spreadsheet: 183762d1349016722-how-to-remove-uniqye-values-excel_help_864451-how-to-remove-unique-values_30sep12_01
Sheet: Sheet1

111
111
112
113
114
114
Spreadsheet: elizabeth_sager__9474__Deal Charts
Sheet: Financial

Financial Trades
Deal Ref No | Commodity | Buyer | [NAME] | Trade Date | Start Date | End Date | Daily Volume | Index | Location | Deal Type | Strike | Confirm
NQ0433.1 | NG | ENA | PG&E | 2000-07-07 00:00:00 | 2001-04-01 00:00:00 | 2001-10-31 00:00:00 | 20000 | NGI | Socal Border | swap | 3.72 | ISDA
NQ0552.1 | NG | PG&E | ENA | 2000-07-07 00:00:00 | 2001-04-01 00:00:00 | 2001-10-31 00:00:00 | -20000 | IF | EPNG- San Juan | swap | 3.12 | ISDA
NQ2300.1 | NG | ENA | PG&E | 2000-07-10 00:00:00 | 2001-04-01 00:00:00 | 2001-10-31 00:00:00 | 10000 | NGI | Socal Border | swap | 3.9075 | ISDA
NQ2300.2 | NG | PG&E | ENA | 2000-07-10 00:00:00 | 2001-04-01 00:00:00 | 2001-10-31 00:00:00 | -10000 | IF | EPNG- San Juan | swap | 3.3125 | ISDA
NR7509.1 | NG | PG&E | ENA | 2000-07-20 00:00:00 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | -10000 | IF | EPNG- San Juan | swap | 2.9725 | ISDA
NR7509.2 | NG | ENA | PG&E | 2000-07-20 00:00:00 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 10000 | NGI | Socal Border | swap | 3.5725 | ISDA
NW5096.1 | NG | ENA | PG&E | 2000-08-23 00:00:00 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 5000 | NGI | Socal Border | swap | 3.61 | ISDA
NW5096.2 | NG | PG&E | ENA | 2000-08-23 00:00:00 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | -5000 | IF | EPNG- San Juan | swap | 3.06 | ISDA
QA8737.1 | NG | ENA | PG&E | 2000-11-17 00:00:00 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 10000 | NGI | Socal Border | swap | 4.4 | ISDA
QA8737.2 | NG | PG&E | ENA | 2000-11-17 00:00:00 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | -10000 | IF | EPNG- San Juan | swap | 3.655 | ISDA
Invoice No | Month | Invoice Date | Due Date | Invoice Amount
105797 | 2001-04-01 00:00:00 | 2001-04-03 00:00:00 | 2001-04-09 00:00:00 | 5822999.98
Spreadsheet: 844683d1696414326-schedule-of-payment-based-on-payment-terms-sample-computation-schedule
Sheet: Sheet1

 |  |  |  | DELIVERY SCHEDULE
# OF DAYS | PO # | PO VALUE | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | TOTAL | BALANCE
90D ADVANCE | PO1 | 500000
30D AFTER DELIVERY | PO2 | 360000 |  | 100000 |  |  | 20000 |  | 20000 | 30000 |  | 90000 |  | 100000
180D 90% AFTER DELIVERY | PO3 | 1800000 |  |  | 100000
60D ADVANCE | PO4 | 6500000 |  |  |  |  |  | 450000 |  |  | 1000000
PAYMENT SCHEME
Spreadsheet: 840186d1692540824-dynamic-formula-to-pull-data-from-multiple-columns-in-a-specific-manner-dynamic-array-question
Sheet: Workings

 | Expected Results
 | Questions >
 | Answers > |  | Q1 A2 | Q1 A3 | Q1 A4 | Q1 A5 | Q1 A6 |  | [NAME] |  | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME]
 | Weights > |  | 0.25 | 0.1 | 0.15 | 0.1 | 0.05 |  | 0.55 |  | 0.4 | 0.4 |  | 0.3 | 0.25 | 0.25
 | Emptly table for calculation
 | Questions >
 | Answers >
 | Weights >
 | Tasks
 | Objective : I need to pull the list of questions, answers & weights from the [NAME] tab to Rows 8, 9 & 10 above.
 | Objective : I need to use dynamic array formulas in Cells C8, C9 and C10 to get the result. There should be formula only in Column C which populates values towards the right.
 | Row 8 - Each question shall repeat, times the number of it's unique answers. Any new question addded in the Inputs sheet (Column B) shall automatucally reflect here. ([NAME] expected results in row 3)
 | Row 9 - All answers in order from the inputs sheet shall be called up here below it's corresponding questions in row 8. ([NAME] expected results in row 4)
 | Row 10 - All weights in order from the inputs sheet shall be called up here below it's corresponding answers in row 9. ([NAME] expected results in row 5)
Spreadsheet: 599264d1542939717-isna-match-formula-how-to-remove-the-nul-cells-sample-data
Sheet: Sheet1

[PHONE]/53 | [PHONE]/53
[PHONE]/07 | [PHONE]/53
[PHONE]/07 | [PHONE]/52
[PHONE]/53 | [PHONE]/51
[PHONE]/07 | [PHONE]/53
[PHONE]/07 | [PHONE]/51
[PHONE]/52 | [PHONE]/53
[PHONE]/07 | [PHONE]/62
[PHONE]/07 | [PHONE]/51
[PHONE]/07 | [PHONE]/53
[PHONE]/07 | [PHONE]/53
Spreadsheet: 804391d1668037293-formula-for-printing-all-sheets-xcvbtr10
Sheet: 12

 |  | [NAME])  YA MSHIRIKA T.A.G HERMON REVIVAL CHURCH |  |  |  |  |  |  |  |  | MWAKA
 |  | JINA KAMILI | WEEKS | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGU | SEPT | OKT | NOV | DEC | JUMLA
 |  | ht8 | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | JUMLA
Spreadsheet: 3eab0e0a-bdb2-4660-8f3f-274bd9fe6604
Sheet: Sheet1

2014 General Election - OFFICIAL RESULTS | Unnamed: 1 | Unnamed: 2
State of North Dakota Results
Precincts Reporting: 427/427 - Total Ballots Cast: 255128
Downloaded at 12/20/2014 10:04:51 PM
 | Yes - | No -
Constitutional Measure No. 1 Relating to the inalienable rights to life of every human being at every stage of development. | 90224 | 161303
 | Yes - | No -
Constitutional Measure No. 2 Relating to the prohibition of the imposition of mortgage taxes or any sales or transfer taxes on the mortgage or transfer of real property. | 188283 | 60478
 | Yes - | No -
Constitutional Measure No. 3 Relating to repealing the existing Board of Higher Education and to creating a three member commission of higher education appointed by the Governor. | 61007 | 182492
 | Yes - | No -
Constitutional Measure No. 4 Relating to the fiscal impact of measures to initiate constitutional amendments and to the placing of initiated measures on the ballot | 104245 | 135899
 | Yes - | No -
Initiated Constitutional Measure No. 5 Constitutional Petition Related to a Clean Water, Wildlife, and Parks Trust and a Clean Water, Wildlife, and Parks Fund | 51775 | 199305
 | Yes - | No -
Initiated Statutory Measure No. 6 Relating to Parental Rights and Responsibilities | 92807 | 152004
 | Yes - | No -
Initiated Statutory Measure No. 7 Relating to the Operation of a Pharmacy | 102731 | 147644
 | Yes - | No -
Initiated Statutory Measure No. 8 Statutory Petition Related to School Classes Beginning After Labor Day | 109489 | 136963
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 848583d1699290442-align-data-from-rows-to-columns-parent-1-and-2-example-2-aligw
Sheet: Sheet1

student_lastName | student_firstName | Parent Last Name | Parent First
[NAME] | [NAME] | [NAME] | Mom
[NAME] | [NAME] | [NAME] | Dad
[NAME] | Kaylee | [NAME] | Dad
[NAME] | Kaylee | [NAME] | Mom
Spreadsheet: 131952d1323395622-calculating-fiscal-month-book1
Sheet: MTD Dec

Enter Month | Dec'11
Day | Date
Sunday | 2011-11-27 00:00:00 | WK1
Monday | 2011-11-28 00:00:00
Tuesday | 2011-11-29 00:00:00
Wednesday | 2011-11-30 00:00:00
Thursday | 2011-12-01 00:00:00
Friday | 2011-12-02 00:00:00
Saturday | 2011-12-03 00:00:00
Sunday | 2011-12-04 00:00:00 | WK2
Monday | 2011-12-05 00:00:00
Tuesday | 2011-12-06 00:00:00
Wednesday | 2011-12-07 00:00:00
Thursday | 2011-12-08 00:00:00
Friday | 2011-12-09 00:00:00
Saturday | 2011-12-10 00:00:00
Sunday | 2011-12-11 00:00:00 | WK3
Monday | 2011-12-12 00:00:00
Tuesday | 2011-12-13 00:00:00
Wednesday | 2011-12-14 00:00:00
Thursday | 2011-12-15 00:00:00
Friday | 2011-12-16 00:00:00
Saturday | 2011-12-17 00:00:00
Sunday | 2011-12-18 00:00:00 | WK4
Monday | 2011-12-19 00:00:00
Tuesday | 2011-12-20 00:00:00
Wednesday | 2011-12-21 00:00:00
Thursday | 2011-12-22 00:00:00
Friday | 2011-12-23 00:00:00
Saturday | 2011-12-24 00:00:00
Sunday | 2011-12-25 00:00:00 | WK5
Monday | 2011-12-26 00:00:00
Tuesday | 2011-12-27 00:00:00
Wednesday | 2011-12-28 00:00:00
Thursday | 2011-12-29 00:00:00
Friday | 2011-12-30 00:00:00
Saturday | 2011-12-31 00:00:00
Spreadsheet: 852192d1702297870-formula-needed-for-lookup-sync-between-two-sheets-in-same-workbook-test-file
Sheet: List

ID | Name | Street | Number | ZIP | City | Assigned To | Appointment | Appointment 2
1 | Business 1 | Boulevard | 1 | 12345 | City |  | 2024-01-01 00:00:00
2 | Business 2 | Street | 3 | 12345 | City | Team Member 1 | 2024-01-01 00:00:00
3 | Business 3 | Avenue | 5 | 12345 | City | Team Member 1 | 2024-01-01 00:00:00
4 | Business 4 | Boulevard | 7 | 12345 | City
5 | Business 5 | Street | 9 | 12345 | City
6 | Business 6 | Avenue | 11 | 12345 | City | Team Member 1 | 2024-03-05 00:00:00
7 | Business 7 | Boulevard | 13 | 12345 | City | Team Member 1 | 2024-03-05 00:00:00
8 | Business 8 | Street | 15 | 12345 | City | Team Member 1 | 2024-03-05 00:00:00
9 | Business 9 | Avenue | 17 | 12345 | City | Team Member 1 | 2024-02-02 00:00:00
10 | Business 10 | Boulevard | 19 | 12345 | City | Team Member 1 | 2024-02-02 00:00:00
11 | Business 11 | Street | 21 | 12345 | City | Team Member 1 | 2024-02-02 00:00:00
12 | Business 12 | Avenue | 23 | 12345 | City | Team Member 1 | 2024-02-02 00:00:00
13 | Business 13 | Boulevard | 25 | 12345 | City | Team Member 1 | 2024-02-02 00:00:00
14 | Business 14 | Street | 27 | 12345 | City | Team Member 1 | 2024-02-02 00:00:00
15 | Business 15 | Avenue | 29 | 12345 | City
16 | Business 16 | Boulevard | 31 | 12345 | City
17 | Business 17 | Street | 33 | 12345 | City
18 | Business 18 | Avenue | 35 | 12345 | City
19 | Business 19 | Boulevard | 37 | 12345 | City
20 | Business 20 | Street | 39 | 12345 | City
Spreadsheet: 205881d1357926690-unique-records-in-a-column-with-a-twist-unique_columns_example
Sheet: Sheet1

Running Category Count | Animal | Colour
1 | Dog | White
2 | Dog | [NAME]
1 | Cat | [NAME]
2 | Cat | Orange
1 | Tiger | Orange
1 | Snake | Red
3 | Dog | Spotty
3 | Cat | Pink
Spreadsheet: 57674d1257886199-automatically-make-new-tables-doctor_a-2-
Sheet: Total Book

1
 |  | Nr. Book/Page | Date | Payment | code or [NAME] |  |  | vb: 1=regular
 |  | 09*0102/01 | 31-12-2009 | 25 | 3 |  |  | 2= after 7
 |  | 09*0102/02 |  | 22 | 1 |  |  | 3=weekend
 |  | 09*0102/03 |  | 23 | 2 |  |  | etc
 |  | 09*0102/04 |  | 25 | 3
 |  | 09*0102/05
 |  | 09*0102/06
 |  | 09*0102/07
 |  | 09*0102/08
 |  | 09*0102/09
 |  | 09*0102/10
 |  | 09*0102/11
 |  | 09*0102/12
 |  | 09*0102/13
 |  | 09*0102/14
 |  | 09*0102/15
 |  | 09*0102/16
 |  | 09*0102/17
 |  | 09*0102/18
 |  | 09*0102/19
 |  | 09*0102/20
 |  | 09*0102/21
 |  | 09*0102/22
 |  | 09*0102/23
 |  | 09*0102/24
 |  | 09*0102/25
 |  | 09*0102/26
 |  | 09*0102/27
 |  | 09*0102/28
 |  | 09*0102/29
 |  | 09*0102/30
 |  | 09*0102/31
 |  | 09*0102/32
 |  | 09*0102/33
 |  | 09*0102/34
 |  | 09*0102/35
 |  | 09*0102/36
 |  | 09*0102/37
 |  | 09*0102/38
 |  | 09*0102/39
 |  | 09*0102/40
 |  | 09*0102/41
 |  | 09*0102/42
 |  | 09*0102/43
 |  | 09*0102/44
 |  | 09*0102/45
 |  | 09*0102/46
 |  | 09*0102/47
 |  | 09*0102/48
 |  | 09*0102/49
 |  | 09*0102/50
 |  |  | Total: | 95
2
 |  | Nr. Book/Page | Date | Payment
 |  | 09*0103/01 | 31-12-2009 | 50
 |  | 09*0103/02 |  | 50
 |  | 09*0103/03
 |  | 09*0103/04
 |  | 09*0103/05
 |  | 09*0103/06
 |  | 09*0103/07
 |  | 09*0103/08
 |  | 09*0103/09
 |  | 09*0103/10
 |  | 09*0103/11
 |  | 09*0103/12
 |  | 09*0103/13
 |  | 09*0103/14
 |  | 09*0103/15
 |  | 09*0103/16
 |  | 09*0103/17
 |  | 09*0103/18
 |  | 09*0103/19
 |  | 09*0103/20
 |  | 09*0103/21
 |  | 09*0103/22
 |  | 09*0103/23
 |  | 09*0103/24
 |  | 09*0103/25
 |  | 09*0103/26
 |  | 09*0103/27
 |  | 09*0103/28
 |  | 09*0103/29
 |  | 09*0103/30
 |  | 09*0103/31
 |  | 09*0103/32
 |  | 09*0103/33
 |  | 09*0103/34
 |  | 09*0103/35
 |  | 09*0103/36
 |  | 09*0103/37
 |  | 09*0103/38
 |  | 09*0103/39
 |  | 09*0103/40
 |  | 09*0103/41
 |  | 09*0103/42
 |  | 09*0103/43
 |  | 09*0103/44
 |  | 09*0103/45
 |  | 09*0103/46
 |  | 09*0103/47
 |  | 09*0103/48
 |  | 09*0103/49
 |  | 09*0103/50
 |  |  | Total: | 100
3
 |  | Nr. Book/Page | Date | Payment
 |  | 09*0104/01 | 31-12-2009 | 50
 |  | 09*0104/02 |  | 50
 |  | 09*0104/03
 |  | 09*0104/04
 |  | 09*0104/05
 |  | 09*0104/06
 |  | 09*0104/07
 |  | 09*0104/08
 |  | 09*0104/09
 |  | 09*0104/10
 |  | 09*0104/11
 |  | 09*0104/12
 |  | 09*0104/13
 |  | 09*0104/14
 |  | 09*0104/15
 |  | 09*0104/16
 |  | 09*0104/17
 |  | 09*0104/18
 |  | 09*0104/19
 |  | 09*0104/20
 |  | 09*0104/21
 |  | 09*0104/22
 |  | 09*0104/23
 |  | 09*0104/24
 |  | 09*0104/25
 |  | 09*0104/26
 |  | 09*0104/27
 |  | 09*0104/28
 |  | 09*0104/29
 |  | 09*0104/30
 |  | 09*0104/31
 |  | 09*0104/32
 |  | 09*0104/33
 |  | 09*0104/34
 |  | 09*0104/35
 |  | 09*0104/36
 |  | 09*0104/37
 |  | 09*0104/38
 |  | 09*0104/39
 |  | 09*0104/40
 |  | 09*0104/41
 |  | 09*0104/42
 |  | 09*0104/43
 |  | 09*0104/44
 |  | 09*0104/45
 |  | 09*0104/46
 |  | 09*0104/47
 |  | 09*0104/48
 |  | 09*0104/49
 |  | 09*0104/50
 |  |  | Total: | 100
Spreadsheet: 669180d1585236502-move-rows-to-separate-sheets-astro_kt
Sheet: 2100 21 5610

Date | Vendor | Item | P.O.# | Amount | Acct Code
Spreadsheet: 116023d1311506325-selective-columns-marcol
Sheet: dc

[NAME]. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 26766d1219245051-automate-values-from-and-into-other-cells-book1
Sheet: Sheet1

NAME |  |  |  |  |  |  |  |  |  |  | A | B | C | D | E | F | G | H
A | 52 | 98 | 93 | 95 |  | 5 | 15 | 29 | 52 |  | 31 | 3 | 4 | 3 | 64 | 94 | 19 | 48
B | 88 | 81 | 99 | 53 | 7 | 88 |  |  |  |  | 98 | 93 | 95 | 38 | 5 | 15 | 29 | 52
C | 11 | 83 | 100 | 63 | 15 | 4 | 62 | 9 | 11 |  | 81 | 99 |  |  | 88
D | 50 | 25 |  |  | 58 | 37 | 50 |  |  |  |  | 100 | 63 | 15 | 4 | 62 | 9 | 11
E | 39 | 63 | 18 | 67 | 7 | 25 | 29 | 39 |  |  |  | 14 | 19 | 58 | 37 | 50
F | 56 | 28 | 4 |  | 3 | 56 |  |  |  |  | 63 | 18 | 67 | 7 | 25 | 29 | 39
G | 43 | 11 | 81 | 92 |  | 19 | 94 | 41 | 43 |  | 28 | 4 | 4 | 3 | 56
H | 48 | 31 | 3 | 90 | 53 | 64 |  | 19 | 48 |  | 11 | 81 |  |  | 19 | 94 | 41 | 43
 |  |  |  |  |  |  |  |  |  |  | 31 | 3 |  |  | 64 |  | 19 | 48
NAME | LAST IN ROW |  |  |  |  |  |  |  |  |  | NAME | LAST IN COLUMN
A | 52 |  |  |  |  |  |  |  |  |  | A | 31
B | 88 |  |  |  |  |  |  |  |  |  | B | 3
C | 11 |  |  |  |  |  |  |  |  |  | C | 4
D | 50 |  |  |  |  |  |  |  |  |  | D | 3
E | 39 |  |  |  |  |  |  |  |  |  | E | 64
F | 56 |  |  |  |  |  |  |  |  |  | F | 94
G | 43 |  |  |  |  |  |  |  |  |  | G | 19
H | 48 |  |  |  |  |  |  |  |  |  | H | 48
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 20477 | 19264 | 8730 | 9000
2 | 20570 | 19264 | 8272 | 9000 |  |  | 3274
3 | 20460 | 19264 | 8090 | 9000
4 | 20200 | 19264 | 8341 | 9000
5 | 19480 | 19264 | 8726 | 9000
6 | 19664 | 19264 | 8659 | 9000
7 | 19522 | 19264 | 8267 | 9000
8 | 19534 | 18764 | 8970 | 8500
9 | 19377 | 18764 | 8969 | 8500
10 | 19196 | 18764 | 8684 | 8500
11 | 19383 | 18764 | 8639 | 8500
12 | 18982 | 18764 | 9230 | 8500
13 | 19311 | 18764 | 9675 | 8500
14 | 19051 | 18764 | 9185 | 8500
15 | 18948 | 18764 | 8955 | 8500
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  |  |  |  |  |  |  | 87198.44
2001-09-15 00:00:00
CBS Volume
 |  |  | -82729
Spreadsheet: 151218d1334833116-pivot-table-how-to-sort-drop-down-lists-da6126-ctreconciler-redacted_reply
Sheet: DT Journal

Version | 2012-04-16-01 | DT Journal
MWH Ref | 0
Taxpayer name | 0
CT ref | 0
Control account | DT (931, 933)
Run date/time | 2012-04-19 16:25:30
 |  | APE | 2012-04-30 00:00:00
 |  | Sum of Movement total £ Dr/(Cr) | Processed?
 |  | Account | FALSE | Grand Total
 |  | 506 PL DT | 0 | 0
 |  | Grand Total | 0 | 0
Spreadsheet: 275789d1383647677-removing-last-lowercase-letters-charts-question-excel-forum-2007-updated
Sheet: Question2

 |  | Month | Cases OPENED | Cases CLOSED
2009 | January | 2009-01 | 51 | 68
 | February | 2009-02 | 59 | 57
 | March | 2009-03 | 66 | 60
 | April | 2009-04 | 54 | 46
 | May | 2009-05 | 59 | 66
 | June | 2009-06 | 59 | 76
 | July | 2009-07 | 65 | 56
 | August | 2009-08 | 41 | 55
 | September | 2009-09 | 77 | 60
 | October | 2009-10 | 66 | 59
 | November | 2009-11 | 77 | 74
 | December | 2009-12 | 58 | 65
Watch X-axis - how can I make it to show the same as for Cases Opened?
Spreadsheet: 814289d1674254738-formula-to-calculate-up-to-a-number-then-back-to-zero-game-stats-3
Sheet: Field

YD | SIDE | CON |  |  | Teams
0 |  | TD |  |  | Home | Visitor
1 |  |  |  |  | TB | DAL
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 | M
0
Spreadsheet: 96831d1296111246-estimate-the-sales-tax-usa_state_taxes
Sheet: USA State Taxes

Summary table
Sales taxes in the United States
State | General | +max local | Groceries | Prepared Food | Prescription Drug | Non-prescription Drug | Clothing
 | Tax | Surtax
Alabama | 0.04 | 0.1 |  |  |  |  |  |  |  | Color | Explanation
Alaska | 0 | 0.07 |  |  |  |  |  |  |  |  | Exempt from general sales tax
Arizona | 0.066 | 0.106 |  |  |  |  |  |  |  |  | Subject to general sales tax
Arkansas | 0.06 | 0.06 | 0.02 |  |  |  |  |  |  | 0.07 | Taxed at a higher rate than the general rate
California | 0.0825 | 0.1075 |  |  |  |  |  |  |  | 0.03 | Taxed at a lower rate than the general rate
Colorado | 0.029 | 0.08 |  |  |  |  |  |  |  | 3%+ | Some locations tax more
Connecticut | 0.06 | 0.06 |  |  |  |  | > $50 |  |  | 3% ([NAME]) | Some locations tax less
Delaware | 0 | 0 |  |  |  |  |  |  |  | > $50 | Taxed purchases over $50 (otherwise exempt)
District of Columbia | 0.06 | 0.06 |  | 0.1 |  |  |  |  |  |  | No state-wide general sales tax
Florida | 0.06 | 0.075 |  | 9% ([NAME])
Georgia | 0.04 | 0.08 | 0.03 |  |  |  |  |  |  | (1) Some states tax food, but allow an (income) tax credit to compensate poor households. They are: HI, ID, KS, OK, SD, and WY.
Hawaii | 0.04 | 0.04712 |  |  |  |  |  |  |  | (2) Includes statewide local tax of 1.0% in California and 1.0% in Virginia.
Idaho | 0.06 | 0.06 |  |  |  |  |  |  |  | (3) Tax rate may be adjusted annually according to a formula based on balances in the unappropriated general fund and the school foundation fund.
Illinois | 0.0625 | 0.115 | 1%+ |  | 1%+ | 1%+ |  |  |  | (4) Food sales are subject to local sales taxes.
Indiana | 0.07 | 0.09 |  | 9% ([NAME])
Iowa[4] | 0.06 | 0.07
Kansas | 0.053 | 0.0865
Kentucky | 0.06 | 0.06
Louisiana | 0.04 | 0.09
Maine | 0.05 | 0.05 |  | 0.07
Maryland | 0.06 | 0.06
Massachusetts | 0.0625 | 0.0625 |  | 7% ([NAME]) |  |  | > $175
Michigan | 0.06 | 0.06
Minnesota | 0.06875 | 0.07775 |  | 9.75% ([NAME])
Mississippi | 0.07 | 0.09
Missouri | 0.04225 | 0.09241 | 0.01225
Montana | 0 | 0.03
Nebraska | 0.055 | 0.07
Nevada | 0.0685 | 0.081
New Hampshire | 0 | 0 |  | 0.09
New Jersey | 0.07 | 0.07
New Mexico | 0.05125 | 0.085625
New York | 0.04 | 0.08875
North Carolina | 0.0575 | 0.0825 | 0.02 | 9.25% ([NAME])
North Dakota | 0.05 | 0.05
Ohio[5] | 0.055 | 0.0775
Oklahoma | 0.045 | 0.085 | 0.045
Oregon | 0 | 0 |  | 5% ([NAME])
Pennsylvania | 0.06 | 0.08
Puerto Rico | 0.055 | 0.07
Rhode Island | 0.07 | 0.07 |  | 0.08
South Carolina | 0.06 | 0.09 |  | 0.105
South Dakota | 0.04 | 0.06
Tennessee | 0.07 | 0.0975 | 0.055
Texas | 0.0625 | 0.0825
Utah | 0.0475 | 0.0835 | 0.04
Vermont | 0.06 | 0.07 |  | 0.1 |  |  | > $100
Virginia | 0.04 | 0.05 | 0.025 | 5%+
Washington | 0.065 | 0.095 |  | 10% ([NAME])
West Virginia | 0.06 | 0.06 | 0.03
Wisconsin | 0.05 | 0.056
Wyoming | 0.04 | 0.07
Spreadsheet: 219127d1362672012-help-with-a-formula-function-if-its-possible-admit-dc-2013
Sheet: 8

Admission and Discharges
2013
Date: | 2013-01-08 00:00:00
ADMISSIONS |  |  |  |  |  |  | DISCHARGES
Room # | Name | Time | From | Status | Telemetry Box # |  | Room # | Name | Time | To
206 | z | 01:45:00 | ED |  |  |  | 326 | a | 10:20:00
335 | x | 03:10:00 | ED |  |  |  | 306 | s | 10:40:00
325 | y | 04:45:00 | ED |  |  |  | 315 | d | 14:00:00
IC04 | b | 11:50:00 | ED |  |  |  | 319 | f | 16:05:00
316 | a | 10:20:00 | ED |  |  |  | 323 | g | 15:45:00
330 | c | 10:40:00 | ED |  |  |  | 331 | h | 17:35:00
332 | d | 14:00:00 | ASU |  |  |  | 314 | j | 16:35:00
IC08 | t | 16:05:00 | [NAME] |  |  |  | 330 | k | 15:55:00
334 | y | 15:45:00 | [NAME] |  |  |  | 204 | l | 16:00:00
313 | u | 17:35:00 | ED |  |  |  | 205 | q | 18:01:00
204 | i | 16:35:00 | DA
333 | o | 17:10:00 | ED
302 | p | 19:30:00 | ED
IC08 | x | 21:00:00 | ED
202 | c | 21:13:00 | ED
201 | v | 22:22:00 | ED
336 | b | 22:55:00 | ED
 | How many admits: 0001-0200: | 1 | How many  From ED | How many inpt | Total # Admits |  |  | How many d/c: 0001-0200: | 0 | Total #  Discharges
 | How many admits: 0201-0400: | 1 | 13 | 0 | 17 |  |  | How many d/c: 0201-0400: | 0 | 10
 | How many admits: 0401-0600: | 1 | How many  From CDU | How many obs |  |  |  | How many d/c: 0401-0600: | 0
 | How many admits: 0601-0800: | 0 | 0 | 0 |  |  |  | How many d/c: 0601-0800: | 0
 | How many admits: 0801-1000: | 0 | How many from ASU |  |  |  |  | How many d/c: 0801-1000: | 0
 | How many admits: 1001-1200: | 3 | 1 |  |  |  |  | How many d/c: 1001-1200: | 2
 | How many admits: 1201-1400: | 1 | How many from OR |  |  |  |  | How many d/c: 1201-1400: | 1
 | How many admits: 1401-1600: | 1 | 0 |  |  |  |  | How many d/c: 1401-1600: | 3
 | How many admits: 1601-1800: | 4 | How many from CV |  |  |  |  | How many d/c: 1601-1800: | 3
 | How many admits: 1801-2000: | 1 | 2 |  |  |  |  | How many d/c: 1801-2000: | 1
 | How many admits: 2001-2200: | 2 | How many DA |  |  |  |  | How many d/c: 2001-2200: | 0
 | How many admits: 2201-2400: | 2 | 1 |  |  |  |  | How many d/c: 2201-2400: | 0
ROOM TRANSFERS |  |  |  |  |  |  | TELEMETRY - ON / OFF
Room # | Name | To Room # |  |  |  |  | Room# | Name | On/Off | Box #
 | Maloney