tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 142224d1329744276-formula-error-vbax-state-updtd
Sheet: CP

 |  |  | ITEM | Average TAT for Supplier Dispatch (from PO release to order readiness at [NAME]'s location) | Average Transit Time (from [NAME]'s factory to Indian Port of Entry) | Average TAT for custom clearance (for Imported Items only) | Average Transit Time for Receipt at TWH (either from CHA or domestic supplier location to TWH) |  |  | Item Code | Description | UOM | Capex/Opex | Aging | QTY | Value | Material Type | Logic | Month
 |  |  |  |  |  |  |  |  |  | IF008446 | 2 CORE 16 SQ MM CU ARMOURD | EA | Capex | 23 | 5 | 606.55 | New Stock |  | 2012-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | MW021075 | Ceragon - 18 GHz Single Polarization Antenna - 1.2 m | EA | Capex | 45 |  |  | Used stock in repairable condition |  | 2012-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | AC002008 | AIR CONDITIONER 4T X 1 PH (ROTARY COMPRESSOR) | EA | Capex | 432 |  |  | New Stock |  | 2012-01-01 00:00:00
 |  | 2012-01-01 00:00:00 | PDH Antenna | 0 | 7 | 2 | 2 |  |  | MW077010 | CERAGON IP-10 R1 | EA | Capex | 170 | 30 | 1750330.8 | Used stock in Non Working Condition/Non-repairable Condition |  | 2012-01-01 00:00:00
 |  | 2012-01-01 00:00:00 | Microwave Hop | 0 | 4 | 2 | 3 |  |  | N/A | Second Supporting Road For 1.8 MW Antenna | PCS | Capex | 56 | 9 | 16886.52 | New Stock |  | 2012-01-01 00:00:00
 |  | 2012-01-01 00:00:00 | Indoor BTS | 0 | 9 | 1 | 3 |  |  | N/A | Second Supporting Road For 1.2 MW Antenna | PCS | Capex | 67 | 35 | 65669.8 | Non- Working Stock |  | 2012-01-01 00:00:00
 |  | 2012-01-01 00:00:00 | Outdoor BTS | 0 | 0 | 0 | 0 |  |  | MW021077 | Ceragon - 18 GHz Single Polarization Antenna - 1.8 m | EA | Capex | 91 | 2 | 138892.83428 | Repaired stock |  | 2012-01-01 00:00:00
 |  | 2012-02-01 00:00:00 | PDH Antenna | 0 | 7 | 2 | 2
 |  | 2012-02-01 00:00:00 | Microwave Hop | 0 | 4 | 2 | 3
 |  | 2012-02-01 00:00:00 | Indoor BTS | 0 | 9 | 1 | 3
 |  | 2012-02-01 00:00:00 | Outdoor BTS | 0 | 0 | 0 | 0
 |  | 2012-03-01 00:00:00 | PDH Antenna | 0 | 7 | 2 | 2
 |  | 2012-03-01 00:00:00 | Microwave Hop | 0 | 4 | 2 | 3
 |  | 2012-03-01 00:00:00 | Indoor BTS | 0 | 9 | 1 | 3
 |  | 2012-03-01 00:00:00 | Outdoor BTS | 0 | 0 | 0 | 0
 |  | 2012-04-01 00:00:00 | PDH Antenna | 0 | 7 | 2 | 2
 |  | 2012-04-01 00:00:00 | Microwave Hop | 0 | 4 | 2 | 3
 |  | 2012-04-01 00:00:00 | Indoor BTS | 0 | 9 | 1 | 3
 |  | 2012-04-01 00:00:00 | Outdoor BTS | 0 | 0 | 0 | 0
Spreadsheet: 87822d1287679177-key-formula-adjustment-new-example
Sheet: 1161 BUD

KEY | Lead column | YTD Budget
212018  Sales in Cnt to Proc*        Total Sales | 212018  Sales in Cnt to Proc | -829401
212201  Sales in Cnty out BL*        Total Sales | 212201  Sales in Cnty out BL | 0
212401  Sales out Cnt to PPE*        Total Sales | 212401  Sales out Cnt to PPE | 0
212708  Energy Surcharge Int*        Total Sales | 212708  Energy Surcharge Int | -55900
213011  External Sales*        Total Sales | 213011  External Sales | -7464600
213519  Energy Surcharge Ext*        Total Sales | 213519  Energy Surcharge Ext | -503099
*        Total Sales*        Total Sales | *        Total Sales | -8853000
612114  Finished Gds PC Revv*        Inter Segmental Transfers | 612114  Finished Gds PC Revv | 0
*        Inter Segmental Transfers*        Inter Segmental Transfers | *        Inter Segmental Transfers | 0
**       Gross Segmental Sales**       Gross Segmental Sales | **       Gross Segmental Sales | -8853000
Spreadsheet: 136006d1326365902-need-a-macro-for-compare-and-copy-data-from-one-sheet-to-another-sheet-in-excel-copydata
Sheet: Sheet1

ID | Name | Title | Comments | Request Type | Impacted Area | Impacted Sub Area | Description | Request_Status | RequestType_Previous | Request SubType | EPMS | Request Number | Release Date | Request DateTime | Application | Developer Name | Hours Worked
aaa | asfd |  | AAA | Core |  | xxxx |  |  |  |  |  | 101
bb | sdafdsf |  | AAA | Core |  | xxxx |  |  |  |  |  | 102
cc | dsafds |  | AAA | Core |  | xxxx |  |  |  |  |  | 103
dd | zfdsf |  | AAA | Core |  | xxxx |  |  |  |  |  | 104
ee | sdfsdf |  | BB | Core |  | xxxx |  |  |  |  |  | 105
ff | sdfsd |  | VV | Core |  | xxxx |  |  |  |  |  | 106
gg | sdafdsf |  | BB | Core |  | xxxx |  |  |  |  |  | 107
hh | sdfsd |  | BB | auto |  | xxxx |  |  |  |  |  | 108
kk | sdfsd |  | CC | auto |  | xxxx |  |  |  |  |  | 109
ll | sdfds |  | DD | auto |  | xxxx |  |  |  |  |  | 110
Spreadsheet: 865003d1712121152-sla-exclude-non-working-days-weekend-and-public-holidays-excel-formula
Sheet: Sheet2

 |  |  |  |  |  |  | TimeCommented | TimeResponded | TimeCommented | TimeResponded | SLA | [NAME] | Actual SLA | result | Should be | Public Holidays |  | Start Hour | End Hour
 |  |  |  |  |  |  | 2024-03-28 09:14:00 | 2024-04-02 12:10:00 |  |  |  |  |  | correct |  | 2024-01-01 00:00:00 |  | 09:00:00 | 18:00:00
 |  |  |  |  |  |  | 2024-03-28 22:58:00 | 2024-04-02 11:58:00 |  |  |  |  |  | correct |  | 2024-01-25 00:00:00
 |  |  |  |  |  |  | 2024-04-01 00:00:00 | 2024-04-01 08:05:00 |  |  |  |  |  | wrong | 0:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  |  | 2024-04-01 11:53:00 | 2024-04-01 12:34:00 |  |  |  |  |  | wrong | 0:41:00 | 2024-02-12 00:00:00
 |  |  |  |  |  |  | 2024-03-28 13:04:00 | 2024-04-02 11:46:00 |  |  |  |  |  | correct |  | 2024-03-28 00:00:00
 |  |  |  |  |  |  | 2024-03-28 16:45:00 | 2024-04-02 11:43:00 |  |  |  |  |  | correct |  | 2024-04-10 00:00:00
 |  |  |  |  |  |  | 2024-04-01 11:40:00 | 2024-04-01 13:04:00 |  |  |  |  |  | wrong | 1:24:00 | 2024-04-11 00:00:00
Spreadsheet: 133500d1324424418-excel-2007-menu-greyed-out-productdb
Sheet: SUPPLIER LOOKUP

 | Company | Contact Name | [NAME] | Phone
1 | Shenzhen  Lead Opto Co | [NAME] | [EMAIL] | 86-159-2000-6070(m)
2 | BRT | [NAME] | [EMAIL] | 86-134-1864-3184(m)
3 | ANERN | Ms [NAME] | [EMAIL] | 86-186-6616-8446 (m)
4 | Furuier | [NAME] | [EMAIL] | 86 137-9847-4773
5 | Quality LED Co Ltd | Sophie | [EMAIL] | 86-134-1034-5204
6 | J B Pele Electronics | [NAME] | [EMAIL] | 86-[PHONE]
7 | Laileede | Michelle | [EMAIL] | 86 755 23054800
8
9
10
11
12
13
Spreadsheet: 465398d1465605745-conditional-formatting-help-conditional-formatting
Sheet: Sheet1

Value | Color | Value2 | Color | Value3 | Color
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
1 |  | 1 |  | 1
1 |  | 1 |  | 1
1 |  | 1 |  | 1
2 |  | 2 |  | 2
2 |  | 2 |  | 2
Spreadsheet: 167058d1341883939-how-to-pick-up-the-numbers-from-the-data-but-not-duplicate-them-by-formula-123-1-
Sheet: Sheet1

Data
20 |  |  | Row Labels | Count of Data
40 |  |  | 20 | 1
40 |  |  | 40 | 2
100 |  |  | 100 | 3
100 |  |  | 200 | 2
100 |  |  | 300 | 1
200 |  |  | 400 | 1
200 |  |  | 500 | 1
300 |  |  | 555 | 3
400 |  |  | 663 | 1
500 |  |  | Grand Total | 15
555
555
555
663
Spreadsheet: eric_saibi__9935__103101R
Sheet: Leland Olds 01

Owner Name |  | Basin Electric Power
Station Name |  | Leland Olds Power Station
Unit Name |  | Leland Olds 01
NERC Region |  | MAPP
State |  | ND
Fuel Type |  | Coal
Capacity |  | 216 MW
Start Date |  | 2001-09-14 00:00:00
End Date |  | 2001-11-13 00:00:00
Prv. Start Date |  | 2001-09-14 00:00:00
Prv. End Date |  | 2001-10-26 00:00:00
Comments |  | Boiler/Major O/H
SIC |  | 4911
Plant ID |  | 1014227
Unit ID |  | 1007280
Outage ID |  | 8515
Spreadsheet: 56323d1256496921-vlookup-countif-nest-test-shirt-count
Sheet: Draft_Night_Database

1 | 30382853 | Test | Smith | 9 | AL
2 | 30427291 | Test | Smith | 5 | YL
3 | 30427293 | Test | Smith | 9 | AS
4 | 30463504 | Test | Smith | 4 | YL
5 | 30508988 | Test | Smith | 6 | AS
6 | 30508989 | Test | Smith | 4 | YL
7 | 30509066 | Test | Smith | 6 | AX
8 | 30509407 | Test | Smith | 8 | AM
9 | 30510655 | Test | Smith | 8 | AL
10 | 30510790 | Test | Smith | 4 | YM
11 | 30510999 | Test | Smith | 3 | YM
12 | 30511532 | Test | Smith | 5 | AM
13 | 30511538 | Test | Smith | 2 | YL
14 | 30511576 | Test | Smith | 4 | YL
16 | 30511577 | Test | Smith | 11 | AXX
17 | 30512063 | Test | Smith | 11 | AX
18 | 30512772 | Test | Smith | 8 | AM
19 | 30512800 | Test | Smith | 4 | YM
20 | 30512849 | Test | Smith | 3 | YL
21 | 30513294 | Test | Smith | 3 | AM
22 | 30514017 | Test | Smith | 11 | AL
23 | 30514619 | Test | Smith | 4 | YL
24 | 30514620 | Test | Smith | 8 | AM
25 | 30517086 | Test | Smith | 4 | YL
26 | 30517087 | Test | Smith | 2 | YL
27 | 30517395 | Test | Smith | 2 | YM
28 | 30518080 | Test | Smith | 5 | YL
29 | 30518561 | Test | Smith | 2 | YL
30 | 30518562 | Test | Smith | 3 | YL
Spreadsheet: 776461d1649749539-return-two-or-more-strings-from-the-text-located-in-one-cell-return_two_and_more_strings_form_text_in_one_cell_v02
Sheet: Cas_Number

CAS Number
106-42-3
106-46-7
106-65-0
107-06-2
108-03-2
108-19-0
108-90-7
108-93-0
109-66-0
109-86-4
109-86-5
109-99-9
110-12-3
110-49-6
110-80-5
11103-86-9
111-03-86-9
111109-77-4
111-15-8
111-15-9
111-84-2
1163-19-5
118-82-1
122-39-4
122-93-4
123-42-2
123-54-6
12656-85-8
127-19-5
13530-65-9
13654-09-6
138495-42-8
138495-42-8
142-82-5
142844-00-6
147783-69-5
150-76-5
16096-31-4
19019-43-3
21850-44-2
25013-15-4
2602-34-8
26172-55-4
2682-20-4
3107-18-4
32536-52-0
34590-94-8
353-50-4
375-03-1
5026-74-4
51160-97-5
5117-12-4
63936-56-1
67584-42-3
68156-01-4
68156-07-0
7439-97-6
75-05-8
75-15-0
7758-97-6
78-59-1
79-00-5
79-20-9
79-46-9
79-94-7
79-94-8
8005-02-5
900169-60-0
91-20-3
98-29-3
Spreadsheet: 184163d1349170251-condensing-several-rows-of-data-into-a-single-row-ef199_example1
Sheet: Sheet1

 | Table 1 |  |  |  |  |  |  | Table 2
 |  |  |  |  |  |  |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00
 | Date | Item | Credit | Debit
 | 2010-10-08 00:00:00 | A | -1750 |  |  |  | A
 | 2011-04-08 00:00:00 | A | -1750 |  |  |  | A
 | 2011-10-07 00:00:00 | A | -1750 |  |  |  | A
 | 2012-04-10 00:00:00 | A | -1840 |  |  |  | A
 | 2012-07-02 00:00:00 | B | -104.84 |  |  |  | B
 | 2012-08-01 00:00:00 | B | -1885.56 |  |  |  | B
 | 2012-09-03 00:00:00 | B | -1885.56 |  |  |  | B
 | 2012-10-01 00:00:00 | B | -1885.56 |  |  |  | B
 | 2010-12-01 00:00:00 | C | -1146.66 |  |  |  | C
 | 2011-06-01 00:00:00 | C | -1150 |  |  |  | C
 | 2011-12-01 00:00:00 | C | -1171.67 |  |  |  | C
 | 2012-06-01 00:00:00 | C | -1176 |  |  |  | C
 | 2010-10-28 00:00:00 | D | -584.53 |  |  |  | D
 | 2011-10-28 00:00:00 | D | -613.45 |  |  |  | D
 | 2010-11-01 00:00:00 | E |  | 2444 |  |  | E
 | 2011-11-01 00:00:00 | E |  | 2506 |  |  | E
 | 2011-07-07 00:00:00 | F | -8140.4 |  |  |  | F
 |  |  |  |  |  |  |  | Table 3
 |  |  |  |  |  |  |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00
 |  |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  | C
 |  |  |  |  |  |  | D
 |  |  |  |  |  |  | E
 |  |  |  |  |  |  | F
Spreadsheet: 869970d1716488586-array-returning-duplicate-values-seemingly-at-random-sample-bvj-
Sheet: Operator Data

 |  | Operator: | [NAME]
Spreadsheet: james_steffes__12963__Lindberg
Sheet: Sheet1

 | Support Type | Deal Name | Responsible Person | Impact ($[NAME]) | Background/Key Issues | Updated | Strategies/Comments/Next Actions
 | Deal Support | Interconnection with Georgia Power (Athens Development Company) | [NAME] |  | Negotiate interconnection agreement between Georgia Power and Athens Development for 564 MW combined cycle plant. | 2001-10-05 00:00:00 | Deadline for executing agreement is 9/20/01.  If no agreement is reached, unexecuted agreement will be filed with FERC.
 | Deal Support | Interconnection with WAPA | [NAME] |  | Provide information on regulatory precedent. | 2001-10-05 00:00:00 | Interconnection study has been requested; next step would be to negotiate interconnection agreement if indicated.
 | Deal Support | Interconnection with FPL (Midway Project). | [NAME] |  | Negotiate interconnection agreement between Enron Midway Development Company and FPL. | 2001-10-05 00:00:00 | Deadline for executing agreement has been extended.  If no agreement is reached, unexecuted agreement will be filed with FERC.
 | Deal Support | Doyle I LLC Sale | [NAME] |  | Obtain FERC approval for disposition of assets. | 2001-10-05 00:00:00 | Filing Sec 203 application Oct 12, 2001.  Follow application through FERC to expedite approvals.
 | Deal Support | Interconnection with Entergy | [NAME] |  | Negotiate interconnection study agreement | 2001-10-05 00:00:00 | Focus  on Notice to Proceed concept with finalized Interconnection agreement.
 | [NAME] | FERC - Proposed Rulemaking on Generation Interconnection Standards | [NAME] |  | FERC has issued Discussion paper that recommended short-term Rulemaking standardizing interconnection procedures and long-term Rulemaking on cost assignment issues. | 2001-10-05 00:00:00 | Support FERC through EPSA.
 | [NAME] | FERC - NOPR on Public Utility Filing Requirements | [NAME] |  | Assist ENA Legal in developing Enron's comments on NOPR | 2001-10-05 00:00:00 | File comments with EPSA and as Enron to FERC.  Key issues involve what transactions are included (e.g., bookouts) and timeliness.
Spreadsheet: 749119d1632512221-excel-formula-to-calculate-hourly-forcast-book1
Sheet: Sheet1

Question 1  You were given the following 5 years of sales history broken down by hour for Monday in the same week as the scenario above.   a)  Using a formula calculate an hourly goal breakdown that you would recommend be used.   b) Note all observations about the data & how useful it may/may not be in forecasting goals for the week ahead.
Hour Begin | Current Open/Close |  | 2014 |  | 2013 |  | 2012 |  | 2011 |  | 2010 |  | HOURLY GOAL FORECAST
10:00:00 | Open |  | 0.02 |  | 0.02 |  | 0.03 |  | 0.01 |  | 0.01
11:00:00 | Open |  | 0.11 |  | 0.03 |  | 0.07 |  | 0.03 |  | -0.01
12:00:00 | Open |  | 0.04 |  | 0.08 |  | 0.13 |  | 0.09 |  | 0.08
13:00:00 | Open |  | 0.12 |  | 0.1 |  | 0.08 |  | 0.08 |  | 0.18
14:00:00 | Open |  | 0.14 |  | 0.16 |  | 0.09 |  | 0.19 |  | 0.28
15:00:00 | Open |  | -0.02 |  | 0.08 |  | 0.03 |  | 0.08 |  | 0.36
16:00:00 | Open |  | 0.1 |  | 0.13 |  | 0.11 |  | 0.03 |  | 0.1
17:00:00 | Open |  | 0.05 |  | 0.06 |  | 0.12 |  | 0.07
18:00:00 | Open |  | 0.16 |  | 0.11 |  | 0.03 |  | 0.17
19:00:00 | Open |  | 0.16 |  | 0.1 |  | 0.22 |  | 0.08
20:00:00 | Open |  | 0.11 |  | 0.13 |  | 0.09 |  | 0.15
21:00:00 | Closed |  | 0.01 |  |  |  | 0 |  | 0.02
22:00:00 | Closed
23:00:00 | Closed
Total |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
Spreadsheet: 114971d1310630962-automatically-updating-data-from-one-sheet-to-another-june1
Sheet: 90

Date | Trip Details | Amount | Toll | Other | Party | Payment Yes/N0 | [NAME]
2011-06-01 00:00:00
2011-06-02 00:00:00
2011-06-03 00:00:00
2011-06-04 00:00:00 | Gateway To India | Yes
2011-06-05 00:00:00 | Gateway To India | Yes
2011-06-06 00:00:00 | Gateway To India | Yes
2011-06-07 00:00:00 | Gateway To India | Yes
2011-06-08 00:00:00 | Gateway To India | Yes
2011-06-09 00:00:00 | Gateway To India | Yes
2011-06-10 00:00:00 | Gateway To India | Yes
2011-06-11 00:00:00 | Gateway To India | Yes
2011-06-12 00:00:00 | Gateway To India | Yes
2011-06-13 00:00:00 | Gateway To India | Yes
2011-06-14 00:00:00
2011-06-15 00:00:00
2011-06-16 00:00:00
2011-06-17 00:00:00
2011-06-18 00:00:00
2011-06-19 00:00:00 | Skyarch - A/c Complaint
2011-06-20 00:00:00
2011-06-21 00:00:00
2011-06-22 00:00:00
2011-06-23 00:00:00 | Marriage from Shari Eroor | Yes
2011-06-24 00:00:00 | Intersight
2011-06-25 00:00:00 | Intersight
2011-06-26 00:00:00 | Intersight
2011-06-27 00:00:00 | Intersight
2011-06-28 00:00:00
2011-06-29 00:00:00
2011-06-30 00:00:00 | Intersight
2011-07-01 00:00:00 | Intersight
2011-07-02 00:00:00 | Intersight
2011-07-03 00:00:00 | Intersight
2011-07-04 00:00:00 | Intersight
2011-07-05 00:00:00 | Intersight
2011-07-06 00:00:00 | Intersight
2011-07-07 00:00:00
2011-07-08 00:00:00
2011-07-09 00:00:00 | [NAME]
2011-07-10 00:00:00 | [NAME]
2011-07-11 00:00:00
2011-07-12 00:00:00
2011-07-13 00:00:00
2011-07-14 00:00:00
2011-07-15 00:00:00
2011-07-16 00:00:00
2011-07-17 00:00:00
2011-07-18 00:00:00
2011-07-19 00:00:00
2011-07-20 00:00:00
2011-07-21 00:00:00
2011-07-22 00:00:00
2011-07-23 00:00:00
2011-07-24 00:00:00
2011-07-25 00:00:00
2011-07-26 00:00:00
2011-07-27 00:00:00
2011-07-28 00:00:00
2011-07-29 00:00:00
2011-07-30 00:00:00
2011-07-31 00:00:00
Spreadsheet: 1434dd6c-bd04-45d4-bce0-ab4b60d1938e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 48. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (NT), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413737T | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413738V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413739W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413740F | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413741J | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413742K | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413743L | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413744R | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413745T | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413746V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413747W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 115366d1311007274-question-abotu-if-function-sample-index-match-2-columns
Sheet: Sheet2

2011-06-01 00:00:00 | Live | r1
2011-06-01 00:00:00 | Staged | f1
2011-09-01 00:00:00 | Live | u1
2011-09-01 00:00:00 | Staged | i1
2011-12-01 00:00:00 | Live | x1
2011-12-01 00:00:00 | Staged | l1
2012-03-01 00:00:00 | Live | o2
2012-03-01 00:00:00 | Staged | c2
2012-06-01 00:00:00 | Live | r2
2012-06-01 00:00:00 | Staged | f2
Spreadsheet: 456785d1461061160-how-to-fill-down-merged-cells-fill-down
Sheet: Sheet1

NO |  | YES |  | NO |  |  | NO
 |  |  |  |  | double 5
Spreadsheet: 0ae3bf8c-28c6-4907-b2f2-44944e4b417c
Sheet: Sheet1

[NAME] | Contig | Primer
Tester Genes
 | TC10560_F | AAACAAATTGCCAACCAGGA
 | TC10560_R | CACCAAGTAGGGCACCACTAA
 | TC10775_F | CCCATTAACTTCCCAAACGA
 | [NAME] | TCCAGAACCACGAGTTGTCA
 | TC10854_F | GGTCACCACGGATAATGGTT
 | TC10854_R | GCCAATATCTCCACCCCATA
 | TC12511_F | ATGGGCGTGCTGTAGCTAAT
 | TC12511_R | AAGCACTCGGTCCAGTTTGT
 | [NAME] | TGTGGGTCAACATGGTGTTT
 | [NAME] | TTTACCGGAATTGCCTGTCT
 | TC14173_F | ATGCATTCACACGTGAACAA
 | TC14173_R | AGCTGATACGGTGCACATTG
 | TC14697_F | TCATTTGTGGAGGGGTTTTC
 | TC14697_R | TAACACGTTCGAATGGACGA
 | TC16843_F | GCTGCACAAATTGATCATCG
 | TC16843_R | ACCCCAACCAACAGCATAAC
 | [NAME] | CAGGCAATTCAATTCATCCA
 | TC18051_R | CCCCCGGAAAAACAGATTTA
 | TC6892_F | CATACCCAACCCTCCTCCTT
 | TC6892_R | TCTCTCTCCCTCACTCTCCAA
 | [NAME] | ACATTCCACCACTGGGAATC
 | TC7378_R | GGAGCTCACAAATCCCAACA
 | TC7516_F | TGATTCCAGCGATTTCATTG
 | TC7516_R | ATGGCCAAAAACCATTTTCA
 | [NAME] | TGTCAATGGAGAAGGCAGTG
 | TC7600_R | TTGACCAAGTCCACTTCCAA
 | TC7982_F | ACGATGTGATCGTGAGTTCG
 | TC7982_R | CAGGTCTGTCTTCGTCGTCA
 | TC9924_F | TACAGGCAGTCCGAGCTCTT
 | TC9924_R | GGAATGAAGGGCAGTTGAAG
Control Gene
 | TC15682_F | TGGTGAGGAAACTCGGAGAC
 | TC15682_R | CTTCCAAAATGGCCGTGA
Spreadsheet: 853001d1702969908-getting-an-overall-status-based-on-two-columns-excelhelp2-aligw
Sheet: Sheet1

Project Number | Project Type | Project Name | Overall Status | Milestones / Activities | Milesotnes Status
 |  | Migration: Project A |  | CP | NS
 |  | Migration: Project A |  | T | O
 |  | Migration: Project A |  | R | C
 |  | Migration: Project A |  | L | NS
 |  | Migration: Project B |  | CP | NS
 |  | Migration: Project B |  | T | O
 |  | Resolution: Project 1 |  | CP | NS
 |  | Resolution: Project 1 |  | T | NS
Spreadsheet: 811126d1672300822-if-name-change-then-change-the-number-sample
Sheet: Sheet1

 | NAME | SERIES
 | ABDUL | 1
 | AFAAQ | 2
 | DEVID | 1
 | SMITH | 2
 | SMITH | 2
 | SMITH | 2
 | CHAND | 1
 | CHAND | 1
 | YUSUF | 2
 | YUSUF | 2
 | YUSUF | 2
 | YUSUF | 2
 | BARNER | 1
 | BARNER | 1
 | EXTRA | 2
 | EXTRA | 2
 | EXTRA | 2
 | EXTRA | 2
 | EXTRA | 2
 | FAIZ | 1
Spreadsheet: 852234d1702322057-calculating-the-number-of-ot-hours-between-two-times-from-times-that-cross-midnight-time-sheet-calculator
Sheet: Stat Holidays

Years | New Year | Good Friday | Easter | Easter Monday | [NAME] | Canada Day | Labor Day | Truth and Reconciliation Day | Thanksgiving | Remembrance Day | Christmas Day | Boxing Day
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
2044
2045
2046
2047
2048
2049
2050
Spreadsheet: 162029d1339696661-finding-the-max-based-on-records-from-another-field-tigeravatar-example-for-koochandkai
Sheet: Sheet1

Event | Name | Count |  | Event Name | [NAME]
Event A | [NAME] | 1
Event A | Sue | 2
Event A | [NAME] | 3
Event B | [NAME] | 1
Event C | [NAME] | 1
Event C | [NAME] | 2
Spreadsheet: 767768d1644610154-create-a-summary-sheet-to-include-data-their-from-multiple-sheets-dummy-workbook
Sheet: Sheet6

 | Date | Time | Item | PO Number | Quantity  Ordered | Quantity  Delivered | Booking  Reference Number | STATUS
JANUARY | 2022-01-05 00:00:00 | 08:00:00 | Harvest Gold | 448128 | 800 | 800 | 21241 | DELIVERED
 | 2022-01-14 00:00:00 | 11:00:00 | Harvest Gold | 448133 | 8400 | 8800 | 21368 | DELIVERED
 | 2022-01-20 00:00:00 | 08:00 | Harvest Gold | 448133 | 3200 | 3200 | 21424 | DELIVERED
 | 2022-01-25 00:00:00 | 08:00 | Harvest Gold | 448132 | 2400 | 2400 | 21532 | DELIVERED
FEBRUARY | 2022-02-01 00:00:00 | 08:00 | Harvest Gold | 447952 | 4000 | 4000 | 21621 | DELIVERED
 | 2022-02-07 00:00:00 | 12:00 | Harvest Gold | 448134 | 1600 | 1600 | 21737 | DELIVERED
 | 2022-02-11 00:00:00 | 06:00 | Harvest Gold | 449767 | 4800 | 4800 | 21862 | DELIVERED
 | 2022-02-14 00:00:00 | 08:00 | Harvest Gold | 448015 | 24 |  | 21337 | NOT DELIVERED
 | 2022-02-28 00:00:00 | 08:00 | Harvest Gold | 448890 | 52 |  | 21616 | NOT DELIVERED
 | 2022-02-03 00:00:00 | 09:00 | Harvest Gold | 449237 | 52 |  | 21664 | NOT DELIVERED