tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 340000d3-5928-44d2-b29c-6143814098e3
Sheet: ELITE

 |  | LA RUTA DE LOS CONQUISTADORES - 20th EDITION
 |  | GENERAL RESULTS
 |  | November 1-3, 2012
POS | ID | Name | Country | Cat | Stage 1 | Stage 2 | Stage 3 | General
1 | 6 | MONTOYA Paolo Cesar | CRC | ELITE | 05:01:19 | 03:44:15 | 01:54:53 | 10:40:27
2 | 5 | GRANT Alex | USA | ELITE | 05:11:20 | 03:47:29 | 01:49:29 | 10:48:18
3 | 120 | PORRAS Dennis Manuel | CRC | ELITE | 05:19:45 | 03:39:26 | 01:50:15 | 10:49:26
4 | 1 | WELLS Todd | USA | ELITE | 05:03:27 | 04:01:12 | 01:47:44 | 10:52:23
5 | 3 | [NAME] | CRC | ELITE | 05:21:12 | 03:43:30 | 01:47:43 | 10:52:26
6 | 12 | ARTAVIA Enrique | CRC | ELITE | 05:28:23 | 03:40:52 | 01:47:42 | 10:56:57
7 | 16 | ESQUIVEL [NAME] | CRC | ELITE | 05:14:50 | 03:48:39 | 01:54:54 | 10:58:23
8 | 4 | RAMOS Milton | ESP | ELITE | 05:17:23 | 03:55:14 | 01:50:21 | 11:02:58
9 | 9 | HERNANDEZ Moises | CRC | ELITE | 05:31:02 | 03:51:31 | 01:52:09 | 11:14:41
10 | 501 | [NAME] | CRC | ELITE | 05:21:39 | 04:08:47 | 01:57:43 | 11:28:09
11 | 8 | SANCHEZ Alexander | CRC | ELITE | 05:28:22 | 04:09:43 | 01:54:07 | 11:32:11
12 | 10 | PERRIN Damian | SUI | ELITE | 05:45:35 | 04:12:35 | 01:54:52 | 11:53:02
13 | 156 | GUTIERREZ [NAME] | MEX | ELITE | 05:49:20 | 04:14:00 | 01:54:54 | 11:58:13
14 | 159 | [NAME] | CRC | ELITE | 06:02:01 | 04:20:36 | 01:54:53 | 12:17:30
15 | 7 | [NAME] | ESP | ELITE | 05:30:54 | 04:48:35 | 02:00:18 | 12:19:47
16 | 86 | HERRERA Jefry | CRC | ELITE | 05:52:21 | 04:16:52 | 02:28:44 | 12:37:57
17 | 407 | [NAME] | MEX | ELITE | 06:22:35 | 04:32:18 | 01:54:49 | 12:49:43
18 | 158 | OCAÑA [NAME] | MEX | ELITE | 06:26:39 | 04:56:14 | 02:00:18 | 13:23:11
19 | 513 | CONEJO Sebastian | CRC | ELITE | 06:49:07 | 04:57:02 | 02:00:18 | 13:46:27
20 | 99 | CAMPOS Erick | CRC | ELITE | 07:01:06 | 04:48:37 | 02:21:14 | 14:10:56
21 | 96 | GARCIA Daniel | CRC | ELITE | 07:20:42 | 05:18:07 | 02:00:18 | 14:39:07
22 | 141 | SANABRIA [NAME] | CRC | ELITE | 08:02:12 | 05:15:54 | 02:09:29 | 15:27:35
23 | 130 | NIELSEN Richard | USA | ELITE | 08:01:11 | 05:33:54 | 02:09:07 | 15:44:12
24 | 494 | BRUNA Andres | CRC | ELITE | 07:50:55 | 05:47:15 | 02:08:14 | 15:46:25
25 | 169 | MANCILLA Ahned | MEX | ELITE | 08:19:44 | 06:25:37 | 02:21:15 | 17:06:36
26 | 60 | PINCHEVSKY Dor | ISR | ELITE | 08:43:07 | 06:28:35 | 02:31:57 | 17:43:38
27 | 131 | [NAME] | CRC | ELITE | 09:00:54 | 06:36:00 | 02:26:20 | 18:03:14
28 | 45 | SEGURA [NAME] | CRC | ELITE | 08:55:30 | 06:11:39 | 03:05:04 | 18:12:12
29 | 177 | BOLAÑOS Andres | CRC | ELITE | 09:30:22 | 06:58:36 | 02:49:09 | 19:18:08
30 | 106 | VARGAS Esteban | CRC | ELITE | 10:06:51 | 06:54:19 | 02:31:55 | 19:33:05
31 | 97 | ITURRIAGA Ibrahim | CRC | ELITE | 11:19:57 | 06:58:10 | 02:33:51 | 20:51:58
32 | 134 | MOLINA Andres | CRC | ELITE | 10:24:59 | 07:58:48 | 03:12:40 | 21:36:27
33 | 2 | [NAME] | CRC | ELITE | DSQ | DSQ | DSQ
34 | 104 | MOLINA Felipe | CRC | ELITE | DNF | DNS | DNS
35 | 199 | MONGE [NAME] | CRC | ELITE | DNF | 09:08:47 | 03:23:00
Spreadsheet: 78886d1279186554-excel-2007-formula-problem-task
Sheet: Sheet2

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 | Amt | 3 mon -5 | 0-35 | 35-40 | 40-45 | 45-50 | 50-55 | 55-60 | 60-65 | 65-70
 | 100000 | 1350 | 1270 | 1515 | 1895 | 2770 | 3120 | 3620 | 4050 | 4560
 | 125000 | 1735 | 1655 | 1905 | 2335 | 3320 | 3920 | 4450 | 5010 | 5620
 | 150000 | 2065 | 1970 | 2265 | 2780 | 4080 | 4710 | 5370 | 6050 | 6730
Spreadsheet: 778576d1651157907-display-14-0-as-14-and-14-1-as-14-1-remove-insignificant-decimals-cf-on-nr-on-decimals-shown
Sheet: Sheet1

 |  |  |  | 0.1384
 |  |  |  | 0.1387
 |  |  |  | 0.139
 |  |  |  | 0.1393
 |  |  |  | 0.1396
 |  |  |  | 0.1399
 |  |  |  | 0.1402
 |  |  |  | 0.1405
 |  |  |  | 0.1408
 |  |  |  | 0.14
Spreadsheet: 3b223eff-56c8-4de6-8350-cf664a1c4ead
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
[NAME] | Test | [NAME] | Zinc/Creatinine Ratio, Random, [NAME] | Zinc/Creat Ratio, Random, U | ZNCR/32497: Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) CDCR/7243: Enzymatic Colorimetric Assay | Plastic urine container with no metal cap or glued insert |  |  | 3 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert [NAME]: 3 mL Collection Instructions:  1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of barium are known to interfere with most metals tests. If barium-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.7 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 300-600 mcg/g Creatinine Reference values apply to all ages. | Monday, Wednesday, Friday, 8 a.m. to 11 a.m. | 1 day | 4 days |  | Profile |  |  |  |  | Rochester
[NAME] | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
[NAME] | Component | ZNCR | Zinc/Creatinine Ratio, [NAME] | Zinc/Creat Ratio, U | Only orderable as part of a profile. For further information see ZNCRU / Zinc/Creatinine Ratio, Random, [NAME]. |  |  |  |  |  | Only orderable as part of a profile. For further information see ZNCRU / Zinc/Creatinine Ratio, Random, [NAME]. |  |  | Only orderable as part of a profile. For further information see ZNCRU / Zinc/Creatinine Ratio, Random, [NAME]. |  |  |  | 1 | 84630 |  |  | Yes | No
ZNCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
ZNCR | Result | 32876 | Zinc/Creat Ratio, U | Zinc/Creat Ratio, U | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | In Process
ZNCR | Result | 32891 | Zn Concentration | Zn Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Component | CDCR | [NAME] | [NAME] | Only orderable as part of a profile. For further information see CTU / Creatinine, [NAME]. |  |  |  | 5 | mL | Only orderable as part of a profile. For further information see CTU / Creatinine, [NAME]. |  |  |  |  |  |  |  |  |  |  | Yes | No
CDCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
CDCR | Result | CDCR | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 35674-1 | Creatinine:MCnc:XXX:[NAME]:Qn:
Spreadsheet: 127590d1320420607-stringing-together-if-statements-sample_workbook_fhtk
Sheet: Art_Track_Venray_Form_View

Order Date | DOW # | Actual Arrive Date | Arrive By Date From PO | Drop Time | Substrate | Qty. Ordered | Qty. Shipped | Date Shipped
2011-10-30 00:00:00 | 1 |  | 2011-10-31 00:00:00 | 10pm | [NAME] | 16 | 16 | 2011-11-01 12:16:57
2011-10-29 00:00:00 | 7 |  | 2011-10-31 00:00:00 | 10pm | [NAME] | 4 | 4 | 2011-11-01 12:17:17
2011-10-28 00:00:00 | 6 |  | 2011-10-31 00:00:00 | 10pm | [NAME] | 6 | 6 | 2011-11-01 12:17:40
2011-10-30 00:00:00 | 1 |  | 2011-10-31 00:00:00 | 6am | [NAME] | 7 | 7 | 2011-11-01 12:17:54
2011-10-29 00:00:00 | 7 |  | 2011-10-31 00:00:00 | 10pm | [NAME] | 3 | 3 | 2011-11-01 12:18:24
2011-10-30 00:00:00 | 1 | 2011-11-01 00:00:00 | 2011-10-31 00:00:00 | 6am | Canvas | 7 | 6 | 2011-11-01 16:46:15
2011-10-29 00:00:00 | 7 | 2011-11-01 00:00:00 | 2011-10-31 00:00:00 | 2pm | Canvas | 27 | 27 | 2011-10-31 17:04:41
2011-10-28 00:00:00 | 6 | 2011-11-01 00:00:00 | 2011-10-31 00:00:00 | 10pm | Canvas | 6 | 6 | 2011-11-01 16:44:40
2011-10-31 00:00:00 | 2 | 2011-11-02 00:00:00 | 2011-10-31 00:00:00 | 10pm | Matte Photo Poster | 71 | 71 | 2011-11-01 16:44:54
2011-10-28 00:00:00 | 6 | 2011-10-31 00:00:00 | 2011-10-31 00:00:00 | 6am | Matte Photo Poster | 51 | 51 | 2011-11-01 12:18:50
2011-10-31 00:00:00 | 2 | 2011-11-01 00:00:00 | 2011-10-31 00:00:00 | 2pm | [NAME] | 6 | 6 | 2011-10-31 17:04:14
2011-10-31 00:00:00 | 2 |  | 2011-10-31 00:00:00 | 2pm | [NAME] | 11 | 11 | 2011-10-31 17:04:25
2011-10-31 00:00:00 | 2 |  | 2011-10-31 00:00:00 | 10pm | [NAME] | 48 | 48 | 2011-11-01 12:19:05
2011-10-31 00:00:00 | 2 |  | 2011-10-31 00:00:00 | 10pm | [NAME] | 20 | 20 | 2011-11-01 12:19:21
2011-10-26 00:00:00 | 4 | 2011-10-31 00:00:00 | 2011-10-31 00:00:00 | 6am | Premium Photo Paper | 27 | 27 | 2011-11-01 12:19:37
2011-10-26 00:00:00 | 4 | 2011-11-01 00:00:00 | 2011-10-31 00:00:00 | 10pm | Premium Photo Paper | 6 | 6 | 2011-11-01 12:20:04
2011-10-29 00:00:00 | 7 | 2011-11-03 00:00:00 | 2011-10-31 00:00:00 | 6am | Mural | 15 | 15 | 2011-11-01 12:19:54
2011-10-30 00:00:00 | 1 | 2011-11-03 00:00:00 | 2011-10-31 00:00:00 | 10pm | Premium Photo Paper | 10 | 10 | 2011-11-02 16:39:10
2011-10-31 00:00:00 | 2 | 2011-11-03 00:00:00 | 2011-10-31 00:00:00 | 2pm | Mural | 26 | 26 | 2011-10-31 17:05:38
2011-10-24 00:00:00 | 2 | 2011-10-28 00:00:00 | 2011-10-31 00:00:00 | 10pm | Mural | 6 | 6 | 2011-10-31 17:05:51
2011-10-31 00:00:00 | 2 |  | 2011-10-31 00:00:00 | 10pm | Mural | 13 | 13 | 2011-11-01 16:43:33
2011-10-31 00:00:00 | 2 |  | 2011-10-31 00:00:00 | 10pm | Mural | 72 | 72 | 2011-11-01 16:43:20
2011-10-31 00:00:00 | 2 |  | 2011-10-31 00:00:00 | 10pm | Mural | 52 | 52 | 2011-11-01 16:42:35
2011-10-31 00:00:00 | 2 |  | 2011-10-31 00:00:00 | 10pm | [NAME] | 29 | 29 | 2011-11-01 16:40:39
2011-10-31 00:00:00 | 2 |  | 2011-10-31 00:00:00 | 10pm | [NAME] | 7 | 7 | 2011-11-01 16:42:25
2011-10-31 00:00:00 | 2 |  | 2011-10-31 00:00:00 | 6am | [NAME] | 12 | 12 | 2011-11-01 16:43:05
2011-10-31 00:00:00 | 2 |  | 2011-10-31 00:00:00 | 6am | [NAME] | 68 | 68 | 2011-11-01 16:42:47
Spreadsheet: 57423d1257541812-count-repeated-hours-countinghours
Sheet: Sheet1

Times |  | Hours | COUNT
01:29:37 |  | 0 | 2
02:13:53 |  | 1 | 2
08:04:52 |  | 2 | 2
17:27:13 |  | 3 | 1
17:08:52 |  | 4 | 4
09:05:33 |  | 5 | 1
04:26:54 |  | 6 | 3
13:42:33 |  | 7 | 1
02:01:32 |  | 8 | 1
19:37:14 |  | 9 | 1
16:23:13 |  | 10 | 2
07:02:31 |  | 11 | 0
06:33:27 |  | 12 | 1
06:26:54 |  | 13 | 1
00:03:24 |  | 14 | 3
01:53:19 |  | 15 | 0
14:13:07 |  | 16 | 1
10:32:08 |  | 17 | 2
14:01:23 |  | 18 | 1
04:19:02 |  | 19 | 1
03:55:07 |  | 20 | 0
12:01:24 |  | 21 | 0
10:01:06 |  | 22 | 0
18:28:56 |  | 23 | 0
04:30:50
00:22:05
04:38:01
05:48:03
14:33:42
06:02:49
Spreadsheet: 787725d1657988301-need-formula-to-filter-student-information-based-on-a-condition-of-getting-subject-mark-le-student-filter-gk
Sheet: Sheet2

Range 1
Semester | First | Stage | Second
Name | Sub.1 | Sub.2 | Sub.3 | Sub.4 | Sub.5 |  |  |  | Second | First | 45 | Sub.1
Student 1 | 45 | 67 | 66 | 51 | 47 |  |  | Student 1 | Second | First | 47 | Sub.5
Student 2 | 75 | 46 | 66 | 77 | 92 |  |  | Student 2 | Second | First | 46 | Sub.2
Student 3 | 35 | 55 | 60 | 51 | 43 |  |  | Student 3 | Second | First | 35 | Sub.1
Student 4 | 60 | 34 | 52 | 59 | 40 |  |  | Student 3 | Second | First | 43 | Sub.5
Student 5 | 55 | 60 | 55 | 59 | 69 |  |  | Student 4 | Second | First | 34 | Sub.2
Student 6 | 39 | 52 | 33 | 40 | 39 |  |  | Student 4 | Second | First | 40 | Sub.5
Student 7 | 71 | 65 | 68 | 77 | 59 |  |  | Student 6 | Second | First | 39 | Sub.1
Student 8 | 47 | 43 | 43 | 47 | 60 |  |  | Student 6 | Second | First | 33 | Sub.3
 |  |  |  |  |  |  |  | Student 6 | Second | First | 40 | Sub.4
 |  |  |  |  |  |  |  | Student 6 | Second | First | 39 | Sub.5
Range 2 |  |  |  |  |  |  |  | Student 8 | Second | First | 47 | Sub.1
 |  |  |  |  |  |  |  | Student 8 | Second | First | 43 | Sub.2
Semester | Second | Stage | Second |  |  |  |  | Student 8 | Second | First | 43 | Sub.3
Name | Sub.6 | Sub.7 | Sub.8 | Sub.9 | Sub.10 |  |  | Student 8 | Second | First | 47 | Sub.4
Student 1 | 34 | 50 | 66 | 45 | 67 |  |  | Student 1 | Second | Second | 34 | Sub.1
Student 2 | 51 | 92 | 66 | 55 | 46 |  |  | Student 1 | Second | Second | 45 | Sub.4
Student 3 | 59 | 43 | 60 | 57 | 55 |  |  | Student 2 | Second | Second | 46 | Sub.5
Student 4 | 34 | 40 | 52 | 40 | 34 |  |  | Student 3 | Second | Second | 43 | Sub.2
Student 5 | 46 | 69 | 55 | 35 | 60 |  |  | Student 4 | Second | Second | 34 | Sub.1
Student 6 | 76 | 39 | 55 | 65 | 52 |  |  | Student 4 | Second | Second | 40 | Sub.2
Student 7 | 61 | 59 | 68 | 55 | 65 |  |  | Student 4 | Second | Second | 40 | Sub.4
Student 8 | 88 | 60 | 43 | 57 | 43 |  |  | Student 4 | Second | Second | 34 | Sub.5
 |  |  |  |  |  |  |  | Student 5 | Second | Second | 46 | Sub.1
 |  |  |  |  |  |  |  | Student 5 | Second | Second | 35 | Sub.4
 |  |  |  |  |  |  |  | Student 6 | Second | Second | 39 | Sub.2
 |  |  |  |  |  |  |  | Student 8 | Second | Second | 43 | Sub.3
 |  |  |  |  |  |  |  | Student 8 | Second | Second | 43 | Sub.5
Spreadsheet: 296978d1392242413-importing-excel-sheet-fields-into-separate-excel-based-invoice-sample_invoice
Sheet: Sheet1

 |  |  | [NAME]
 |  |  |  |  | Invoice # | 163687-M
 |  |  |  |  | Invoice Date | 2013-10-01 00:00:00
 |  |  |  |  | Due Date | Upon Receipt
 |  |  |  |  | Customer Number | 123456 | Added this field
 | Invoice To: |  |  |  | Equipment Location:
 | Accounts Payable |  |  |  | Name
 |  |  |  |  | Business
 |  |  |  |  | Addresss
 |  |  |  |  | City, State, Zip
Billing Period |  | Qty | Product | Serial # | Description | Net Amount
10/1/2013-9/30/2014 |  | 1 | CX-30-MT | 60612327274 | 1 Year Advance Exchange Maintenance | 85
 |  |  |  |  | Subtotal
 |  |  |  |  | Tax
 |  |  |  |  | Grand Total Due
 |  |  |  | TO ENSURE PROPER CREDIT, PLEASE RETURN THIS PORTION WITH YOUR PAYMENT
Mail Payment to: |  |  |  |  | Invoice # | 163687-M
 |  |  |  |  | Invoice Date | 2013-10-01 00:00:00
 |  |  |  |  | Terms | 100% Net Due
 |  |  |  |  | Balance Due
 |  |  | To Pay By Credit Card, PayPal, ACH - Please Call
Spreadsheet: 489494d1479293614-index-match-not-working-ifcc-navic-upload
Sheet: Settings

 | SETTINGS
 | Project
 |  | Name of the Project | Production Schedule
 | Team
 |  | Project Manager | Mr [NAME]
 |  | NAME | E-MAIL | PHONE
 |  | Kelly | [EMAIL] | [PHONE]
 |  | Ray | [EMAIL] | [PHONE]
 |  | [NAME] | [EMAIL] | [PHONE]
 |  | Adam | [EMAIL] | [PHONE]
 |  | [NAME] | [EMAIL] | [PHONE]
 |  | [NAME] |  | [PHONE]
 |  | [NAME] |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  | [NAME] new row above this line
 |  | CNC | 10
 |  | ComnWlth | 12
 |  | Deboer | 10
 |  | Distinctive | 15
 |  | [NAME] | 12
 |  | IFCC | 9
 |  | St.Agapit | 10
Spreadsheet: 36637d1234502356-question-about-pre-requisite-for-tasking-devoir2
Sheet: Sheet1

Tâche | Préd. Imm. | Durée | Début + tôt | Fin + tôt
A | - |  | 0
B | - |  | 0
C | - |  | 0
D | - |  | 0
E | B,C
F | D,E
G | A
H | G
I | G
J | F
K | I,J
L | I,H
Durée d
[NAME] assemblage
Durée ajustement | 5
Tâche H
Cumul | Durée | Prob
0 | 1 | 0.3
0.3 | 2 | 0.5
0.8 | 3 | 0.2
Spreadsheet: 478499d1472825751-need-an-indexmatch-lookup-formula-tweak-i-keep-getting-n-a-s-please-help-lookupwcriteria-2-
Sheet: Display

 |  |  |  |  |  |  |  |  |  |  | [NAME] here
 | Site Code | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00
 | 1165
 | 1178
 | 4050
 |  |  |  |  |  |  |  |  |  |  | Need to look up with data in Column A as a unique identifier
Spreadsheet: 12a01d26-0f8a-4fd0-a4ee-bfe9488dd07f
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
 | 5625.0 Private New Capital Expenditure and Expected Expenditure, Australia
 | TABLE 3A. Actual Expenditure, By Type of Asset - Chain Volume Measures $m
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Actual Expenditure - Constant Price ;  Total (Employment Size) ;  Total (State) ;  Total All Industries ;  [NAME] and [NAME] ; |  |  | Original | A2189048F | 1987-09-01 00:00:00 | 2009-06-01 00:00:00 | 88 | $ Millions | FLOW | Quarter | 3
Actual Expenditure - Constant Price ;  Total (Employment Size) ;  Total (State) ;  Total All Industries ;  [NAME] and [NAME] ; |  |  | Seasonally Adjusted | A2189060W | 1987-09-01 00:00:00 | 2009-06-01 00:00:00 | 88 | $ Millions | FLOW | Quarter | 3
Actual Expenditure - Constant Price ;  Total (Employment Size) ;  Total (State) ;  Total All Industries ;  [NAME] and [NAME] ; |  |  | Trend | A2189072F | 1987-09-01 00:00:00 | 2009-06-01 00:00:00 | 88 | $ Millions | FLOW | Quarter | 3
Actual Expenditure - Constant Price ;  Total (Employment Size) ;  Total (State) ;  Total All Industries ;  Equipment, Plant and Machinery ; |  |  | Original | A2189049J | 1987-09-01 00:00:00 | 2009-06-01 00:00:00 | 88 | $ Millions | FLOW | Quarter | 3
Actual Expenditure - Constant Price ;  Total (Employment Size) ;  Total (State) ;  Total All Industries ;  Equipment, Plant and Machinery ; |  |  | Seasonally Adjusted | A2189061X | 1987-09-01 00:00:00 | 2009-06-01 00:00:00 | 88 | $ Millions | FLOW | Quarter | 3
Actual Expenditure - Constant Price ;  Total (Employment Size) ;  Total (State) ;  Total All Industries ;  Equipment, Plant and Machinery ; |  |  | Trend | A2189073J | 1987-09-01 00:00:00 | 2009-06-01 00:00:00 | 88 | $ Millions | FLOW | Quarter | 3
Actual Expenditure - Constant Price ;  Total (Employment Size) ;  Total (State) ;  Total All Industries ;  Total (Type of Asset - Detailed Level) ; |  |  | Original | A2189050T | 1987-09-01 00:00:00 | 2009-06-01 00:00:00 | 88 | $ Millions | FLOW | Quarter | 3
Actual Expenditure - Constant Price ;  Total (Employment Size) ;  Total (State) ;  Total All Industries ;  Total (Type of Asset - Detailed Level) ; |  |  | Seasonally Adjusted | A2189062A | 1987-09-01 00:00:00 | 2009-06-01 00:00:00 | 88 | $ Millions | FLOW | Quarter | 3
Actual Expenditure - Constant Price ;  Total (Employment Size) ;  Total (State) ;  Total All Industries ;  Total (Type of Asset - Detailed Level) ; |  |  | Trend | A2189074K | 1987-09-01 00:00:00 | 2009-06-01 00:00:00 | 88 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2009
Spreadsheet: 790258d1659614427-filtering-students-based-on-conditions-and-construct-a-table-another-case
Sheet: Second Attempt

No. | Student Name |  |  |  |  |  |  |  |  |  |  | Second |  |  |  |  |  |  |  |  |  | Stage |  |  |  |  |  |  |  |  |  |  |  | P3 |  |  | P2 |  |  | P1
 |  |  |  |  |  |  |  |  |  |  |  | Second Attempt
 |  |  |  |  |  |  |  |  |  |  |  | First |  |  |  |  |  |  | Semester: |  |  |  |  |  |  |  |  | Second |  |  |  |  |  |  | Semester:
 |  |  |  |  |  |  |  |  |  |  |  | Sub.1 | Sub.2 | Sub.3 | Sub.4 | Sub.5 | Sub.6 | Sub.7 | Sub.8 | Sub.9 | Sub.10 | Sub.11 | Sub.12 | Sub.13 | Sub.14 | Result |  | sub.1 | sub.2 | [NAME] | sub.4 | sub.5 | sub.6 | sub.7 | sub.8 | sub.9 | sub.10 | sub.11 | sub.12 | sub.13 | sub.14 | Result
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | Student name 1 |  |  |  |  |  |  |  |  |  |  |  | 55 | 45 |  |  |  |  |  |  |  |  |  |  |  | Failed |  |  |  | 39 | 45 |  | 49 |  |  |  |  |  |  |  |  | Failed
 | student name 2 |  |  |  |  |  |  |  |  |  |  | 68 |  |  |  | 40 |  |  |  |  |  |  | 60 |  | 35 | Failed |  |  | 35 | 59 |  |  |  |  |  |  |  |  |  |  |  | Failed
 | Student name 3 |  |  |  |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  |  |  | Passed |  | 48 |  |  |  | 40 |  |  |  |  |  |  |  |  |  | Failed
 | Student name 4 |  |  |  |  |  |  |  |  |  |  | 45 |  |  | 37 |  | 25 |  |  |  |  |  |  |  |  | Failed |  |  | 77 |  |  |  |  |  |  |  |  |  |  |  |  | Passed
 | Student name 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  | 37 |  | 25 |  |  |  |  |  |  |  |  | Failed
 | Student name 6 |  |  |  |  |  |  |  |  |  |  | 55 |  |  |  |  | 65 |  |  |  |  |  |  |  |  | Passed |  |  |  | 50 | 60 | 45 |  |  |  |  |  |  |  |  |  | Failed
 | Student name 7 |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 70 |  | 49 |  |  |  |  |  |  |  |  | Failed |  | 47 |  |  |  |  | 44 |  |  |  |  |  |  |  |  | Failed
 | Student name 8 |  |  |  |  |  |  |  |  |  |  |  | 55 | 76 |  |  |  |  |  |  |  |  |  |  |  | Passed |  |  |  | 39 | 45 |  | 49 |  |  |  |  |  |  |  |  | Failed
 | Student name 9 |  |  |  |  |  |  |  |  |  |  | 48 |  |  |  | 40 |  |  |  |  |  |  |  |  |  | Failed
 | Student name 10 |  |  |  |  |  |  |  |  |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  | Passed |  | 78 |  |  |  | 55 |  |  |  |  |  |  |  |  |  | Passed
Spreadsheet: 52366d1252061117-vlookup-to-sum-values-in-a-range-takings
Sheet: ShopInvoices

Invoice Date | Invoice # | Payee | Total (inc. VAT) | Total VAT | Date (of payment) | Payment Type
2009-05-14 00:00:00 | 102 | Account 001 | 134.95 | 17.6 | 2009-05-20 00:00:00 | Cheque
2009-05-14 00:00:00 | 203 | Account 002 | 44.46 | 5.58 | 2009-05-14 00:00:00 | Cheque
2009-05-14 00:00:00 | 203 | Account 002 | 166.06 | 20.84 | 2009-06-01 00:00:00 | Cheque
2009-05-14 00:00:00 | 304 | Account 003 | 494.88 | 64.55 | 2009-06-30 00:00:00 | Cheque
2009-05-14 00:00:00 | 403 | Account 004 | 296.79 | 37.67 | 2009-07-04 00:00:00 | Cheque
2009-05-14 00:00:00 | 503 | Account 005 | 17.73 | 2.31 | 2009-06-15 00:00:00 | Cheque
2009-05-14 00:00:00 | 604 | Account 006 | 138.4 | 18.05 | 2009-06-16 00:00:00 | Cheque
2009-05-14 00:00:00 | 703 | Account 007 | 142.89 | 18.64 | 2009-05-22 00:00:00 | Cheque
2009-05-14 00:00:00 | 902 | Account 009 | 89.74 | 11.71 | 2009-05-18 00:00:00 | Cheque
2009-05-14 00:00:00 | 1002 | Account 010 | 58.32 | 7.61 | 2009-05-22 00:00:00 | Cheque
2009-05-14 00:00:00 | 1101 | Account 011 | 76.85 | 10.02 | 2009-06-08 00:00:00 | Cheque
2009-09-02 00:00:00 | 103 | Account 001 | 110.09 | 14.22
2009-09-02 00:00:00 | 204 | Account 002 | 65.85 | 8.59
2009-09-01 00:00:00 | 305 | Account 003 | 152.18 | 19.85
2009-09-01 00:00:00 | 404 | Account 004 | 466.89 | 60.9
2009-09-02 00:00:00 | 504 | Account 005 | 17.29 | 2.26
2009-09-01 00:00:00 | 605 | Account 006 | 65.07 | 8.49
2009-09-01 00:00:00 | 704 | Account 007 | 135.42 | 17.66
2009-09-02 00:00:00 | 803 | Account 008 | 43.45 | 5.67
2009-09-02 00:00:00 | 903 | Account 009 | 115.34 | 15.04 | 2009-09-02 00:00:00 | Cheque
2009-09-02 00:00:00 | 1003 | Account 010 | 44.84 | 4.7