tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 130989d1322680001-date-format-example-2-
Sheet: Sheet3

Time | [NAME] diff2(count) |  |  |  |  |  | Should Be
2011-11-08 19:44:52 | 5000 |  |  |  |  |  | 2011-08-11 19:44:52
2011-11-09 19:45:52 | 3638
2011-11-10 19:46:52 | 4468
2011-11-11 19:47:52 | 4637
2011-11-12 19:48:51 | 4105
2011-11-08 19:49:51 | 4485
2011-11-08 19:50:51 | 4409
2011-11-08 19:51:51 | 3911
2011-11-08 19:52:51 | 4477
2011-11-08 19:53:51 | 4636
2011-11-08 19:54:50 | 4701
2011-11-08 19:55:50 | 4138
2011-11-08 19:56:50 | 4296
2011-11-08 19:57:50 | 3398
2011-11-08 19:58:50 | 3619
2011-11-08 19:59:50 | 3845
2011-11-08 20:00:50 | 3870
2011-11-08 20:01:50 | 3801
2011-11-08 20:02:50 | 3563
2011-11-08 20:03:50 | 3897
2011-11-08 20:04:50 | 4111
2011-11-08 20:05:50 | 3805
Spreadsheet: 818106d1676589958-if-and-or-q-and-d-feb-with-summary-end
Sheet: 11th

1 | Defect ID | Unit ID | Unit Date | Prod Date | Act Date | Shift | Year | Serial | z | ID #1 | ID #2 | ID #3 | Product | Color #1 | Color #2 | Part | Location | Concern | [NAME] | Rank | Grid Label | Responsible Area | Responsible Cell | Recording User | Recording Area | Recording Cell | Recording Station | Defect Status | Root Cause | Root Cause User | Comments | sequence no | 1st | 2nd | 3rd | Date
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 108684d1305699711-countif-formulas-not-working-in-such-case-query-sheet
Sheet: Sheet1

Manager | Executive's Name |  |  |  |  |  |  | pramod
Rajesh(12455) | a |  |  |  |  |  |  | sham
Kumar(754845) | b |  |  |  |  |  |  | 5646
John(85987567) | c |  |  |  |  |  |  | kumar
Mickle(01547) | d |  |  |  |  |  |  | 84364
Kumar(754845) | e |  |  |  |  |  |  |  | How to find out the count of both alpha and numeric using single formula
John(85987567) | f
Rajesh(12455) | g
Kumar(754845) | h
John(85987567) | i
Mickle(01547) | j
how to find the number of executives working under Rajesh(12455),Kumar(754845) and [NAME])
Managers | count of Executive
Rajesh(12455)
Kumar(754845)
John(85987567)
How to separate [NAME] name in one coloumn and their code with bracket in another coloumn
Manager
Rajesh(12455)
Kumar(754845)
John(85987567)
Mickle(01547)
Kumar(754845)
John(85987567)
Rajesh(12455)
Kumar(754845)
John(85987567)
Mickle(01547)
Spreadsheet: 215404d1361371017-return-a-year-for-all-data-over-a-threshold-in-a-row-without-macros-sample-yearresultssummary
Sheet: sample

2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028
0 | 0.277 | 0.232 | 0.32 | 0.291 | 0.399 | 0.366 | 0.4 | 0.349 | 0.364 | 0.345 | 0.383 | 0.304 | 0.281 | 0.257 | 0.231
Threshold: | 0.35
5 years over : 2018, 2019, 2020, 2022, 2024
 | 2018 | 2019 | 2020 | 2022 | 2024
 | 2018 | 2018 2019 | 2018 2019 2020 | 2018 2019 2020 2022 | 2018 2019 2020 2022 2024
Spreadsheet: daren_farmer__5013__Texas_Desk_Wellhead_Supply_April_2001_04_05
Sheet: Supply Analysis

Texas Desk
[NAME]
April, 2001
As of 04/05/01
 |  |  | 2001-04-01 00:00:00 | 2001-04-02 00:00:00 | 2001-04-03 00:00:00 | 2001-04-04 00:00:00 |  | Avg | [NAME] |  | Change
CCGM, L.P. | 441 | 636662 | 0 | 0 | 0 | 0 |  |  | 863
CICO Oil & Gas | 9828 | 252799 | 2547 | 2967 | 2867 | 2808 |  |  | 4000
Cobra Operating | 9748 | 137205 | 7162 | 6847 | 8007 | 5463 |  |  | 556
Cody Energy LLC | 9864 | 508842 | 19948 | 20308 | 20368 | 20303 |  |  | 21550
Cody Energy LLC | 6722 | 135865 | 6516 | 7539 | 7787 | 7748 |  |  | 8228
Cokinos Natural Gas | 9842 | 377169 | 9467 | 12161 | 13418 | 14570 |  |  | 6487
Cokinos Natural Gas | 9840 | 417850 | 0 | 0 | 0 | 0 |  |  | 860
Comstock Oil & Gas | 6884 | 125899 | 43249 | 44870 | 45646 | 46957 |  |  | 48276
Conoco Inc. | 6154 | 133304 | 8265 | 8901 | 8945 | 8498 |  |  | 7286
Dallas Production | 6789 | 108151 | 5785 | 6353 | 11928 | 11345 |  |  | 11526
EEX Operating, L.P. | 5999 | 380570 | 6329 | 6079 | 6486 | 6817 |  |  | 7043
El Paso Production | 6226 | 132978 | 5105 | 5536 | 3065 | 3065 |  |  | 3065
EOG Resources | 3082 | 126268 | 6501 | 6428 | 6862 | 6657 |  |  | 6759
EOG Resources | 9674 | 126280 | 3953 | 3511 | 3947 | 4139 |  |  | 4630
Kerr-McGee Oil & Gas | 6884 | 132975 | 28668 | 29741 | 30257 | 31125 |  |  | 32000
Louis Dreyfus Natural | 9687 | 407025 | 9271 | 9327 | 9127 | 9475 |  |  | 10400
Louis Dreyfus Natural | 9723 | 408453 | 1160 | 4156 | 4156 | 4156 |  |  | 4156
Louis Dreyfus Natural | 9734 | 408594 | 21902 | 22273 | 22158 | 22007 |  |  | 24602
Marquee Corp | 9837 | 310851 | 3352 | 2296 | 3296 | 3379 |  |  | 4117
McBee Operating | 6210 | 138785 | 4930 | 5600 | 4831 | 6379 |  |  | 7374
North Central Oil | 6633 | 128839 | 21617 | 20650 | 20706 | 20130 |  |  | 16080
O'Connor & Hewitt | 4136 | 125809 | 1343 | 863 | 1589 | 2118 |  |  | 2323
Phillips Petroleum | 6673 | 670192 | 0 | 0 | 0 | 0 |  |  | 893
Sanchez Oil & Gas | 9760 | 538516 | 14083 | 14632 | 14891 | 14878 |  |  | 13256
Suemaur Exploration | 9856 | 452566 | 14965 | 14676 | 11764 | 11764 |  |  | 11764
Upstream Energy | 5155 | 138628 | 8692 | 10272 | 11329 | 11625 |  |  | 12249
Walter Oil & Gas | 9747 | 138619 | 1579 | 1554 | 1583 | 1584 |  |  | 747
 |  |  |  |  |  |  |  | Total | Change
Goldston | 9603 | 687257 | 38621 | 38123 | 37748 | 38253 |  |  | 39132
 |  |  |  |  |  |  |  | Total | Change
Spreadsheet: 1a3e0a78-998b-4450-8999-09390a011372
Sheet: Sheet1

Service Offerings | Unnamed: 1 | Unnamed: 2
Cost Analysis
Instructions:
1.  Review the analysis checklist document.
2.  If the checkbox is not checked, identify if your credit union needs to incorporate the item.
3.  If your credit union needs to incorporate the item, include the item below in the corresponding
category column and identify the associated costs.
4.  If your credit union does not need to incorporate the item, do nothing.
Service name | Items needed | Estimated cost
Service name 1
 | 1
 | 2
 | 3
 | 4
 | 5
Subtotal |  | 0
Service name 2
 | 1
 | 2
 | 3
 | 4
 | 5
Subtotal |  | 0
Service name 3
 | 1
 | 2
 | 3
 | 4
 | 5
Subtotal |  | 0
Service name 4
 | 1
 | 2
 | 3
 | 4
 | 5
Subtotal |  | 0
Service name 5
 | 1
 | 2
 | 3
 | 4
 | 5
Subtotal |  | 0
Total |  | 0
Spreadsheet: 786970d1657565479-multiple-complex-duplication-solution-required-untitled-spreadsheet
Sheet: Sheet1

Code | AP Status | CB Status | Start Date | [NAME]
123 | Active | active | 10.05.2021 | 10.05.2023
123 | Active | active | 10.03.2022 | 10.03.2024
123 | [NAME] | active
123 | Inactive | active | 03.02.2018 | 03.02.2020
123 | New | active
123 | In Progress | active
345 | new | active
345 | In progress | active
345 | active | active | 03.03.2020 | 03.03.2022
345 | inactive | active | 02.02.2018 | 02.02.2022
567 | active | active | 04.04.2020 | 04.04.2022
789 | inactive | active | 09.07.2019 | 09.07.2021
899 | in progress | active
987 | new | active
999 | [NAME] | active
Spreadsheet: 152121d1335269016-unconsolodating-data-expanding-discounts
Sheet: My Work

 | Pgroup | Disc |  |  |  |  |  | Customers | Pgroup | Discount
1 | AA1 | -10 |  |  |  |  |  | ABC001
2 | AA2 | -23 |  |  |  |  |  | ABC002
3 | AA3 | -33 |  |  |  |  |  | ABC003
3 | AA4 | -45 |  |  |  |  |  | ABC004
4 | AA5 | -56 |  |  |  |  |  | ABC005
5 | AA6 | -68 |  |  |  |  |  | ABC006
6 | AA7 | -50 |  |  |  |  |  | ABC007
7 | AA8 | -40 |  |  |  |  |  | ABC008
8 | AA9 | -30 |  |  |  |  |  | ABC001
9 | AA10 | -20 |  |  |  |  |  | ABC002
10 | AA11 | -10 |  |  |  |  |  | ABC003
 |  |  |  |  |  |  |  | ABC004
 |  |  |  |  |  |  |  | ABC005
 |  |  |  |  |  |  |  | ABC006
 |  |  |  |  |  |  |  | ABC007
 |  |  |  |  |  |  |  | ABC008
 |  |  |  |  |  |  |  | ABC001
 |  |  |  |  |  |  |  | ABC002
 |  |  |  |  |  |  |  | ABC003
 |  |  |  |  |  |  |  | ABC004
 |  |  |  |  |  |  |  | ABC005
 |  |  |  |  |  |  |  | ABC006
 |  |  |  |  |  |  |  | ABC007
 |  |  |  |  |  |  |  | ABC008
 |  |  |  |  |  |  |  | ABC001
 |  |  |  |  |  |  |  | ABC002
 |  |  |  |  |  |  |  | ABC003
 |  |  |  |  |  |  |  | ABC004
 |  |  |  |  |  |  |  | ABC005
 |  |  |  |  |  |  |  | ABC006
 |  |  |  |  |  |  |  | ABC007
 |  |  |  |  |  |  |  | ABC008
 |  |  |  |  |  |  |  | ABC001
 |  |  |  |  |  |  |  | ABC002
 |  |  |  |  |  |  |  | ABC003
 |  |  |  |  |  |  |  | ABC004
 |  |  |  |  |  |  |  | ABC005
 |  |  |  |  |  |  |  | ABC006
 |  |  |  |  |  |  |  | ABC007
 |  |  |  |  |  |  |  | ABC008
 |  |  |  |  |  |  |  | ABC001
 |  |  |  |  |  |  |  | ABC002
 |  |  |  |  |  |  |  | ABC003
 |  |  |  |  |  |  |  | ABC004
 |  |  |  |  |  |  |  | ABC005
 |  |  |  |  |  |  |  | ABC006
 |  |  |  |  |  |  |  | ABC007
 |  |  |  |  |  |  |  | ABC008
 |  |  |  |  |  |  |  | ABC001
 |  |  |  |  |  |  |  | ABC002
 |  |  |  |  |  |  |  | ABC003
 |  |  |  |  |  |  |  | ABC004
 |  |  |  |  |  |  |  | ABC005
 |  |  |  |  |  |  |  | ABC006
 |  |  |  |  |  |  |  | ABC007
 |  |  |  |  |  |  |  | ABC008
 |  |  |  |  |  |  |  | ABC001
 |  |  |  |  |  |  |  | ABC002
 |  |  |  |  |  |  |  | ABC003
 |  |  |  |  |  |  |  | ABC004
 |  |  |  |  |  |  |  | ABC005
 |  |  |  |  |  |  |  | ABC006
 |  |  |  |  |  |  |  | ABC007
 |  |  |  |  |  |  |  | ABC008
 |  |  |  |  |  |  |  | ABC001
 |  |  |  |  |  |  |  | ABC002
 |  |  |  |  |  |  |  | ABC003
 |  |  |  |  |  |  |  | ABC004
 |  |  |  |  |  |  |  | ABC005
 |  |  |  |  |  |  |  | ABC006
 |  |  |  |  |  |  |  | ABC007
 |  |  |  |  |  |  |  | ABC008
 |  |  |  |  |  |  |  | ABC001
 |  |  |  |  |  |  |  | ABC002
 |  |  |  |  |  |  |  | ABC003
 |  |  |  |  |  |  |  | ABC004
 |  |  |  |  |  |  |  | ABC005
 |  |  |  |  |  |  |  | ABC006
 |  |  |  |  |  |  |  | ABC007
 |  |  |  |  |  |  |  | ABC008
Spreadsheet: ca94f22e-5e46-4065-9a26-5ef6afc5c1e2
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
BPG2 | Test | BPG2 | 11 Beta-Prostaglandin F2 Alpha, [NAME] | 11 Beta-Prostaglandin F2 Alpha, U | Enzyme Immunoassay (EIA) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. Refrigerate specimen during collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	No Refrigerated	Yes Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Preferred Na2CO3	No Toluene	Yes 6N HNO3	Yes Boric Acid	Yes Thymol         	Yes | 0.5 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | >1,000 ng/24 hours is considered elevated. | Monday, Thursday; 10:00 a.m. | 2 days | 9 days | 1 | 84150 |  |  |  |  | Rochester
BPG2 | [NAME] | URINE | [NAME] |  |  |  | Frozen | 14 days
BPG2 | Order Question | TM72 | Collection Duration |  | Plain Text
BPG2 | Order Question | [NAME] | [NAME] |  | Plain Text
BPG2 | Result | 21035 | BPG2 concentration | BPG2 concentration | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | In Process
BPG2 | Result | TM72 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
BPG2 | Result | [NAME] | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3167-4 | [NAME] volume:Vol:24H:[NAME]:Qn:
BPG2 | Result | 81425 | 11 Beta-Prostaglandin F2 Alpha, U | 11 Beta-Prostaglandin F2 Alpha, U | Numeric |  |  |  |  | ng/24 h |  |  |  |  |  |  |  |  |  | 14007-9 | Prostaglandin F2 alpha:MRat:24H:[NAME]:Qn:
Spreadsheet: 120987d1315726933-conditional-lookup-problem-conditional-lookup
Sheet: Sheet1

Experience
0.6931506849315069 |  |  | Category |  | Table
0.6931506849315069 |  | 0 | A |  | 0.1<
0.6931506849315069 |  | 0.1 | B |  | 0.1 - 1 |  |  | problem
0.4246575342465753 |  | 1.1 | C |  | 1.1 - 2 |  |  | I want a formula so that if experience is less than 1 then cell will show 'A' which means "0.1<"
0.3726027397260274 |  | 2.1 | D |  | 2.1 - 3
0.3726027397260274 |  | 3.1 | F |  | 3.1 - 4
0.5260273972602739 |  | 4.1 | G |  | 4.1 - 5
0.3726027397260274 |  | 5.1 | H |  | 5.1 - 6
0.5260273972602739 |  | 6.1 | I |  | 6.1 - 7
0.3698630136986301 |  | 7.1 | J |  | 7.1 - 8
0.3424657534246575 |  | 8.1 | K |  | 8.1 - 9
0.3698630136986301 |  | 9.1 | L |  | 9.1 - 10
0.3561643835616438 |  | 10.1 | M |  | 10.1 >
0.3698630136986301
0.4273972602739726
0.4246575342465753
0.3726027397260274
0.3698630136986301
0.3726027397260274
0.5260273972602739
0.4246575342465753
0.3726027397260274
0.6931506849315069
0.6684931506849315
0.6931506849315069
0.6931506849315069
0.6931506849315069
0.6931506849315069
0.5260273972602739
0.6931506849315069
0.5260273972602739
0.5260273972602739
0.6931506849315069
0.5260273972602739
0.5260273972602739
0.6931506849315069
0.5260273972602739
0.6931506849315069
0.3726027397260274
0.4164383561643836
0.4082191780821918
0.3726027397260274
0.4164383561643836
0.4164383561643836
0.6931506849315069
0.3589041095890411
0.3534246575342466
0.3726027397260274
0.3726027397260274
0.5260273972602739
0.4273972602739726
0.4164383561643836
0.7808219178082192
0.5260273972602739
0.7616438356164383
0.7013698630136986
0.7808219178082192
0.4273972602739726
0.7808219178082192
0.5260273972602739
0.5260273972602739
0.7041095890410959
0.7013698630136986
0.7780821917808219
0.7013698630136986
0.7808219178082192
0.7808219178082192
0.5616438356164384
0.7534246575342466
0.5260273972602739
0.4273972602739726
0.7780821917808219
0.7808219178082192
0.3698630136986301
0.3589041095890411
0.3479452054794521
1.021917808219178
0.7808219178082192
0.7643835616438356
1.679452054794521
1.679452054794521
0.936986301369863
0.8849315068493151
1.679452054794521
1.608219178082192
0.8794520547945206
0.8849315068493151
1.679452054794521
1.679452054794521
0.8849315068493151
0.8794520547945206
1.679452054794521
1.619178082191781
1.679452054794521
3.279452054794521
4.534246575342466
0.08767123287671233
7.534246575342466
4.673972602739726
1.676712328767123
1.679452054794521
4.534246575342466
0.3726027397260274
7.282191780821917
8.164383561643836
7.534246575342466
7.282191780821917
11.52054794520548
0.3863013698630137
0.5260273972602739
0.5150684931506849
8.164383561643836
0.7616438356164383
11.53698630136986
11.53698630136986
12.83561643835616
12.83561643835616
11.09315068493151
11.53698630136986
0.1972602739726027
10.57534246575342
0.1643835616438356
Spreadsheet: 788957d1658822847-tools-book-out-and-returned-summary-sheet-for-stores-tools-controll-sheet-etaf
Sheet: Tools Control Sheet

 | Tools Stock Control Sheet |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] Out
 | Product Code | Product Description | Category | Status | Product Type | Unit of Measure | Unit Price | Availible | Return | Out | Stock Value | Stock in Value | Stock Out Value |  | Date | Product Code | Product Description | [NAME] | Supplier | DN/Inv # | Unit of Measure | Qty | Unit Price | Value |  | Date | Product Code | Product Description | Unit Price | Issue To | Client | QN Number | Unit of Measure | Qty | Value
 |  |  | Tools | new | Electrical | unit | 300 |  |  |  |  |  |  |  |  | ID 001 |  |  |  |  |  | 1 |  |  |  |  | ID 001 |  |  | [NAME] | Bassadone |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ID 001 |  |  |  |  |  | 1 |  |  |  |  | ID 001 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | jh 001
Spreadsheet: 83861d1283889695-formula-help-please-example-sheet
Sheet: Sheet1

Item | code | code | code
aaaa | 1 | 2 | 3
bbbb | 2 | 1 | 4
bbbb | 2 | 3 | 1
cccc | 1 | 2 | 3
aaaa | 2 | 1 | 4
cccc | 2 | 3 | 1
aaaa | 1 | 2 | 3
aaaa | 2 | 1 | 4
bbbb | 2 | 3 | 1
Total code occurences |  |  | aaaa count |  | bbbb count |  | cccc count
1 |  |  | 1 |  | 1 |  | 1
2 |  |  | 2 |  | 2 |  | 2
3 |  |  | 3 |  | 3 |  | 3
4 |  |  | 4 |  | 4 |  | 4
Spreadsheet: 28568d1222884112-automatic-decimal-format-control-dynamic
Sheet: Sheet1

 | Sample | Test | Data | Date | Tech | Results
 | Petrodiesel1 | CP | -15 | 2008-09-23 00:00:00 | 2 | -15 |  |  | Distillation | 282C-338C | DI | 2
 | Petrodiesel1 | CP | -15.1 | 2008-09-23 00:00:00 | 4 | -15.1 |  |  | [NAME] | 52C Min | FP | 0
 | Petrodiesel1 | CP | -15.3 | 2008-09-23 00:00:00 | 3 | -15.3 |  |  | Cu Strip | #3 Max | CS | 2
 | Petrodiesel1 | CP | -15.3 | 2008-09-23 00:00:00 | 1 | -15.3 |  |  | Viscosity | 1.9-4.1 mm2/s | KV | 2
 | Petrodiesel1 | FP | 53 | 2008-09-23 00:00:00 | 2 | 53 |  |  | Ash | .01%W | AS | 2
 | Petrodiesel1 | FP | 58 | 2008-09-23 00:00:00 | 4 | 58 |  |  | Centane | 40 Min | CE | 2
 | Petrodiesel1 | FP | 57 | 2008-09-23 00:00:00 | 3 | 57 |  |  | [NAME] |  | CP | 1
 | Petrodiesel1 | FP | 57 | 2008-09-23 00:00:00 | 1 | 57 |  |  | Centrifuge | .05%V [NAME] | CF | 2
 | Petrodiesel1 | FP | 57 | 2008-09-23 00:00:00 | 3 | 57 |  |  | Density |  | DE | 2
 | Petrodiesel1 | FP | 58 | 2008-09-23 00:00:00 | 2 | 58 |  |  | C Residue | .35%W | CR | 2
 | Petrodiesel1 | FP | 58 | 2008-09-23 00:00:00 | 4 | 58 |  |  | Sulfur | 15ppm [NAME] | SU | 2
 | Petrodiesel2 | FP | 68 | 2008-09-26 00:00:00 | 3 | 68 |  |  |  |  | V3715 | 2 | 0.0042
 | Petrodiesel2 | FP | 71 | 2008-09-26 00:00:00 | 4 | 71 |  |  |  |  | V3716 | 2 | 0.004
 | Petrodiesel2 | CP | -7.9 | 2008-09-26 00:00:00 | 1 | -7.9 |  |  |  |  | V3720 | 2 | 0.0075
 | Petrodiesel2 | CP | -7.3 | 2008-09-26 00:00:00 | 3 | -7.3 |  |  |  |  | V3721 | 2 | 0.0074
 | Petrodiesel2 | FP | 72 | 2008-09-26 00:00:00 | 1 | 72
 | Petrodiesel2 | FP | 70 | 2008-09-26 00:00:00 | 2 | 70
 | Petrodiesel2 | FP | 71 | 2008-09-26 00:00:00 | 4 | 71
 | Petrodiesel2 | FP | 70 | 2008-09-29 00:00:00 | 3 | 70
 | Petrodiesel2 | CP | -7 | 2008-09-29 00:00:00 | 3 | -7
 | Petrodiesel2 | FP | 66 | 2008-09-29 00:00:00 | 3 | 66
 | Petrodiesel2 | FP | 71 | 2008-09-30 00:00:00 | 3 | 71
 | Petrodiesel2 | FP | 74 | 2008-09-30 00:00:00 | 3 | 74
 | Petrodiesel2 | CP | -7.1 | 2008-09-30 00:00:00 | 3 | -7.1 |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Petrodiesel2 | FP | 72 | 2008-09-30 00:00:00 | 4 | 72 |  |  |  |  |  |  |  |  |  |  | 1
 | Petrodiesel2 | FP | 74 | 2008-09-30 00:00:00 | 4 | 74 |  |  |  |  |  |  |  |  |  |  | 2
 | Petrodiesel2 | CP | -7.2 | 2008-09-30 00:00:00 | 4 | -7.2 |  | Viscosity tube constants |  |  |  |  |  |  |  |  | 3
 | Petrodiesel2 | V3721 | 423.2 | 2008-10-01 00:00:00 | 3 |  |  | V3715 | 0.0042 |  |  |  |  |  |  |  | 4
 | Petrodiesel2 | V3715 | 712 | 2008-10-01 00:00:00 | 3 |  |  | V3716 | 0.004
 | Petrodiesel2 | V3721 | 426.4 | 2008-10-01 00:00:00 | 4 |  |  | V3720 | 0.0075
 | Petrodiesel2 | V3715 | 715.3 | 2008-10-01 00:00:00 | 4 |  |  | V3721 | 0.0074
 |  |  |  |  |  |  |  | For V3721 and V3721 I need to take the seconds entered into column D and multiply by the associated constant to equal the viscosity in column G
Spreadsheet: 0204ba43-45ad-4e5d-a5d1-c54c66e8271b
Sheet: Sheet1

Spend over £25,000 - Publication template | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Payment
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | NMSI | 2011-07-07 00:00:00 | Professional Fees | ScM Major projects | Casson Mann Ltd | 142196 | 67980
DCMS | NMSI | 2011-07-05 00:00:00 | Build Construction | Shop & Foyer | [NAME] | 142549 | 70213.46
DCMS | NMSI | 2011-07-21 00:00:00 | Professional Fees | ScM Major projects | Universal Design Studio Limited | 142566 | 55250
DCMS | NMSI | 2011-07-07 00:00:00 | Photocopier Rental & Materials | ICT | CF Asset Finance Limited | 142576 | 28305.75
DCMS | NMSI | 2011-07-07 00:00:00 | Equipment/Materials | NMeM Brand | Arts Alliance Media Ltd | 142748 | 63234.9
DCMS | NMSI | 2011-07-21 00:00:00 | Equipment/Materials | ScM Brand | Saville Group Limited | 142819 | 34978.23
DCMS | NMSI | 2011-07-21 00:00:00 | Consultancy | National Estates | Natural History Museum | 142831 | 27562.5
DCMS | NMSI | 2011-07-21 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 142852 | 28744.89
DCMS | NMSI | 2011-07-21 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 142853 | 28744.89
DCMS | NMSI | 2011-07-21 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 142854 | 28744.89
DCMS | NMSI | 2011-07-21 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 142876 | 30806.81
DCMS | NMSI | 2011-07-21 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 142877 | 30806.81
DCMS | NMSI | 2011-07-21 00:00:00 | Security | Museum Security | [NAME] | 143108 | 183665.75
DCMS | NMSI | 2011-07-21 00:00:00 | Security | Museum Security | [NAME] | 143109 | 155065.75
DCMS | NMSI | 2011-07-21 00:00:00 | Security | Museum Security | [NAME] | 143238 | 31676.25
DCMS | NMSI | 2011-07-21 00:00:00 | Security | Museum Security | [NAME] | 143239 | 34847.33
DCMS | NMSI | 2011-07-21 00:00:00 | Security | Museum Security | [NAME] | 143240 | 41997.37
DCMS | NMSI | 2011-07-21 00:00:00 | Security | Museum Security | [NAME] | 143241 | 38276.25
DCMS | NMSI | 2011-07-21 00:00:00 | Build Construction | [NAME] | [NAME] Flooring Limited | 143270 | 37050.36
DCMS | NMSI | 2011-07-12 00:00:00 | Stock Purchases | NMEM Visitor Experience | Unit Communications | 102493 | 30000
Spreadsheet: 22db2ef3-ea31-4a18-8a64-018fc05a3db6
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 33. LEASE FINANCE COMMITMENTS, By Purpose: State (QLD), 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 | A2413943F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413944J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413945K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413946L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413947R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413948T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413949V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413950C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413951F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413952J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413953K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413954L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413955R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413956T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413957V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413958W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010