tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 274625d1383165126-reference-sheet-in-workbook-to-use-dependent-drop-down-lists-equipment-and-cost-estimate-testing
Sheet: Summary

[NAME] |  | PRICE | UNIT | MATERIAL | MATERIAL | LABOR | LABOR | UNINC. MATL | UNINC. MATL
EQUIPMENT |  |  |  | UNIT COST | TOTAL | UNIT COST | TOTAL | UNIT COST | TOTAL | TOTAL
TOTAL
 | =INDEX('Piping and Fitting'!$B$3:$B$1000,MATCH('Piping and Fitting'!G3,'Piping and Fitting'!$A$3:$A$1000,0)):INDEX('Piping and Fitting'!$B$3:$B$1000,MATCH('Piping and Fitting'!G3,'Piping and Fitting'!$A$3:$A$1000,0)+COUNTIF('Piping and Fitting'!$A$3:$A$1000,'Piping and Fitting'!G3)-1)
 |  | PRICE | UNIT | MATERIAL | MATERIAL | LABOR | LABOR | UNINC. MATL | UNINC. MATL
INTERCONNECT TUBING & VALVES |  |  |  | UNIT COST | TOTAL | UNIT COST | TOTAL | UNIT COST | TOTAL | TOTAL
10'' x | [NAME], SS, Schedule 40
1'' x | [NAME], SS, Schedule 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.5 | 48 | 58 | 28
TOTAL
Spreadsheet: 93137d1292648592-adding-value-from-cell-to-last-value-above-in-a-column-bill-balance
Sheet: Sheet1

date | bill | amount | balance | over/under | deposit balance |  |  |  |  |  |  | savings balance
2010-12-17 00:00:00 | 1deposit | 1000 | 2835.42 |  | 2835.42 | 0
2010-12-17 00:00:00 | 2weekly budgeted | -340 | 2495.42
2010-12-17 00:00:00 | 3savings account | -100 | 2395.42 |  |  |  |  |  |  |  |  | 5465.1
2010-12-20 00:00:00 | credit card | -25 | 2370.42
2010-12-21 00:00:00 | car payment | -200 | 2170.42
2010-12-23 00:00:00 | 1deposit | 275 | 2445.42
2010-12-23 00:00:00 | zweekly adjust | 0 | 2445.42 | 10 |  |  | #N/A
2010-12-24 00:00:00 | 1deposit | 1600 | 4045.42 |  |  | 4045.42
2010-12-24 00:00:00 | 2weekly budgeted | -350 | 3695.42
2010-12-24 00:00:00 | 3savings account | -100 | 3595.42 |  |  |  |  |  |  |  |  | 5565.1
2010-12-24 00:00:00 | cable | -140 | 3455.42
2010-12-24 00:00:00 | rent | -910 | 2545.42
2010-12-27 00:00:00 | credit card 2 | -100 | 2445.42
2010-12-27 00:00:00 | student loan | -500 | 1945.42
2010-12-30 00:00:00 | insurance | -100 | 1845.42
2010-12-30 00:00:00 | 1deposit | 200 | 2045.42
2010-12-30 00:00:00 | credit card 3 | -700 | 1345.42
2010-12-30 00:00:00 | zweekly adjust | 0 | 1345.42 | 0 |  |  | #N/A
2010-12-31 00:00:00 | 1deposit | 1000 | 2345.42 |  |  | 2345.42
2010-12-31 00:00:00 | 2weekly budgeted | -350 | 1995.42
2010-12-31 00:00:00 | 3savings account | -100 | 1895.42 |  |  |  |  |  | 100 |  |  | 5665.1
Spreadsheet: 51305d1250849248-points-formatting-book-2
Sheet: Sheet3

Pos. | Pts.
1st | 400
2nd | 340
3rd | 310
4th | 290
5th | 270
6th | 250
7th | 230
8th | 210
9th | 190
10th | 170
11th | 150
12th | 130
13th | 110
14th | 90
15th | 80
16th | 70
17th | 60
18th | 50
19th | 40
20th | 30
21st | 20
22nd | 10
0 | 0
Spreadsheet: 868375d1715104044-going-to-kill-myself-over-this-anyone-please-help-help
Sheet: my working

 |  |  |  |  | My data |  |  |  |  |  | data I am comparing too
 |  |  |  |  | 1391499 | 128.57 |  |  |  |  | 1391499 | 169.99
 |  |  |  |  | 1391499 | 1121.92 |  |  |  |  | 1391499 | 101.99
 |  |  |  |  |  |  |  |  |  |  | 1391499 | 849.94
 |  |  |  |  |  |  |  |  |  |  | 1391499 | 128.57
 |  |  |  |  |  | what I want to do is this I am trying to get the GL codes and I have concanted the invoice numbers with customer ID and amount
 |  |  |  |  |  | problem is based on above this is how it looks
 |  |  |  |  |  |  | my table |  |  |  | Raw data I am comparing too
 |  |  |  |  |  |  |  | GL number | expected |  |  |  |  | GL number
 |  |  |  |  | [NAME] |  |  | not found | it doesn’t find it because the number is not in column o but in reality it is but just totalled up |  | CSOL-13914991000772169.99 |  |  | 456
 |  |  |  |  | CSOL-13914991000772-128.57 |  |  | 456 | wrong should be 999 |  | CSOL-13914991000772101.99 |  |  | 456
 |  |  |  |  |  |  |  |  |  |  | CSOL-13914991000772849.94 |  |  | 999
 |  |  |  |  |  |  |  |  |  |  | CSOL-13914991000772128.57 |  |  | 999
 |  |  |  |  |  | I tried [NAME] on the invoice number but it would bring the invoice number that would come first which is wrong
 |  |  |  |  |  | what can I do so that it gives me the correct gl account number?
Spreadsheet: 64259d1265134167-vlookup-over-range-of-dates-716463_excelhelp
Sheet: Sheet1

 |  | Total Price | Sale Price | Tax
 | 1st Qtr | 120 | 240 | 240
 | Date | Total Price | Sale Price | Tax
 | 2010-01-01 00:00:00 | 1 | 2 | 3
 | 2010-01-02 00:00:00 | 2 | 4 | 4
 | 2010-01-03 00:00:00 | 3 | 6 | 5
 | 2010-01-04 00:00:00 | 4 | 8 | 6
 | 2010-01-05 00:00:00 | 5 | 10 | 7
 | 2010-02-01 00:00:00 | 6 | 12 | 8
 | 2010-02-02 00:00:00 | 7 | 14 | 9
 | 2010-02-03 00:00:00 | 8 | 16 | 10
 | 2010-02-04 00:00:00 | 9 | 18 | 11
 | 2010-02-05 00:00:00 | 10 | 20 | 12
 | 2010-03-01 00:00:00 | 11 | 22 | 13
 | 2010-03-02 00:00:00 | 12 | 24 | 14
 | 2010-03-03 00:00:00 | 13 | 26 | 15
 | 2010-03-04 00:00:00 | 14 | 28 | 16
 | 2010-03-05 00:00:00 | 15 | 30 | 17
 | 2010-04-01 00:00:00 | 16 | 32 | 18
 | 2010-04-02 00:00:00 | 17 | 34 | 19
 | 2010-04-03 00:00:00 | 18 | 36 | 20
 | 2010-04-04 00:00:00 | 19 | 38 | 21
 | 2010-04-05 00:00:00 | 20 | 40 | 22
Spreadsheet: 55177d1255345184-filter-by-only-first-4-numbers-copy-of-malchemist-1-
Sheet: 31541

Date of Order | Date of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20090318 | 2009-03-18 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 93.75 | 133896 | 31541
20090318 | 2009-03-18 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.5199999999999 | 133896 | 31541
20090318 | 2009-03-18 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133896 | 31541
20090318 | 2009-03-18 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133896 | 31541
20090324 | 2009-03-24 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133896 | 31541
20090324 | 2009-03-24 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133896 | 31541
20090318 | 2009-03-18 | 303987 | Orbital jig saw WSJ 850-EB 110V | 1 | 183.34 | 133896 | 31541
20090326 | 2009-03-26 | 378441 | Battery charger C 7/24 230V | 1 | 70 | 134080 | 31541
20090324 | 2009-03-24 | 388214 | Laser range meter PD 40 | 1 | 173.25 | 134039 | 31541
20090318 | 2009-03-18 | 402706 | Combihammer [NAME] | 1 | 399 | 133896 | 31541
Spreadsheet: 680255d1590886532-if-function-not-working-properly-book1
Sheet: Sheet2

 |  |  | Sector Names | Number of these sectors |  |  |  | Sector Names | Number of these sectors
 |  |  | Energy |  |  |  |  | Energy
 |  |  | Financials |  |  |  |  | Financials
 |  |  | Healthcare |  |  |  |  | Healthcare
 |  |  | Utilities |  |  |  |  | Utilities
 |  |  | Industrials |  |  |  |  | Industrials
 |  |  | Real Estate |  |  |  |  | Real Estate
 |  |  | Materials |  |  |  |  | Materials
 |  |  | Information Technology |  |  |  |  | Information Technology
 |  |  | Consumer Staples |  |  |  |  | Consumer Staples
 |  |  | Consumer Discretionary |  |  |  |  | Consumer Discretionary
 |  |  | Communication Services |  |  |  |  | Communication Services
 |  |  | [NAME]
Spreadsheet: 8555ae7a-accd-48d1-bfef-c3de424d2a1b
Sheet: Sheet1

PI Info | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Proj ID No: | Unnamed: 8 | Unnamed: 9
PI Name: |  |  |  |  | Co-PI:
School: |  |  |  |  | Co-PI:
Proposal/Sponsor Information
Proposal Title:
Sponsor: |  |  |  |  |  | Proposal Deadline:
Start Date: |  |  |  |  | Solicitation:
End Date: |  |  |  |  |  | (Program Name/Number)
Key words: | (up to 5 keywords)
Compliance (check all that apply)
Office of Research Compliance (x2792) |  |  |  | Environmental Health and Safety (x4111)
 | Human subjects |  |  |  | Biohazards |  |  | Select agents
 | Animal subjects |  |  |  | Recombinant DNA |  |  | Controlled subst.
 |  |  |  |  | Lasers/Radiation |  |  | Toxins/Haz. chem.
Effort/Cost Share/Funding Share
How much effort have the PI and/or Co-PI(s) committed to this program?*
 | PI/Co-PI  Name
 |  | Commitment (person months)
 |  | Is any effort cost shared**? (Y or N)
 |  | If "Yes", how much? ($)
 |  | Is there additional cost share? |  |  | If "Yes", how much?
Signature of [NAME] or [NAME]'s designee to acknowledge cost share commitment -->
If you are funded, what percentage of the project will be shared between PI and Co-PI(s)?
 |  | PI/co-PI  Name
 |  | % Recognition Distribution
Budget Summary
 |  |  | First Year |  |  | Total Project
 | Salary/Wages |  | 0 |  |  | 0
 | Fringe Benefits |  | 0 |  |  | 0
 | Travel |  | 0 |  |  | 0
 | Supplies/M&O |  | 0 |  |  | 0
 | Subcontract < $25,000
 | Subcontract > $25,000
 | Tuition/Scholarships/PT Costs |  | 0 |  |  | 0
 | Capital Equipment
 | Total Direct Costs |  | 0 |  |  | 0 |  | IDC Rate
 | Indirect Costs |  | 0 |  |  | 0 |  | 0.53
 | TOT PROJ COSTS |  | 0 |  |  | 0
Principal Investigator |  |  | Date |  | [NAME] |  |  |  | Date
Co-PI |  |  | Date |  | Co-PI |  |  |  | Date
Co-PI |  |  | Date |  | Office of Sponsored Projects |  |  |  | Date
Program Head/Center Director |  |  | Date |  | Office of the Vice President for Research |  |  |  | Date
Spreadsheet: 850249d1700621828-change-pivot-chart-axis-values-to-text-excel-mac-version-compatible-assessment-labeling_example-keebo-
Sheet: Assment Table

A person would use this table to do a self assessment where they would choose the level they think they are at for each subject. The level is then converted to a numeric value using the table in the "Assessment Levels" sheet.
 |  |  | This column they would use the drodown list to assess themselves
Order | Category | Subject | Self-Assement Level | Value
1 | Overall View | Sciences
2 | Sciences | Chemistry | Building Competency
3 | Sciences | Physics | Newbie
4 | Sciences | Math | Proficient
5 | Sciences | Biology | Expert
6 | Overall View | Arts
7 | Arts | Music | Newbie
8 | Arts | Photography | Not applicable
9 | Arts | Painting | Newbie
10 | Arts | Literature | Expert
11 | Overall View | Athletics
12 | Athletics | Archery | Top Guru
13 | Athletics | Track | Newbie
Spreadsheet: 180937d1347881117-formula-required-to-calculate-points-based-on-football-scores-in-champions-league-champions-league-chart
Sheet: Sheet1

Home Team | Predicted Score | Actual Score | Away Team | Predicted Score | Actual Score | Points
Barcelona | 3 |  | Celtic | 1
[NAME] | 2 |  | PSG | 2
Chelsea | 2 |  | Juventus | 3
 | predict exact score |  | 3 points
 | Team wins or draws |  | 1 point
 | wrong prediction |  | 0 points
Spreadsheet: 887416d1737651691-get-data-from-one-sheet-and-make-a-weekly-timesheet-test-1-
Sheet: SHEET1

Date/time | Name | Action
2025-01-23 10:21:00 | PERSON 1 | IN
2025-01-23 08:45:32 | PERSON 2 | IN
2025-01-23 11:14:13 | PERSON 3 | IN
2025-01-23 16:55:22 | PERSON 1 | OUT
2025-01-23 16:55:22 | PERSON 2 | OUT
2025-01-23 16:55:22 | PERSON 3 | OUT
Spreadsheet: 129117d1321456864-commission-worksheet-need-assistance-commission-worksheet
Sheet: Sheet1

New Business
Sales Range | Total Sales | Total Commission | Salary | Total Cancellations & Penalties | Total Paycheck
$0-999 |  | 0
$1000-2500
$2501-3500
$3501-5500
$5501-6500
$6501-UP
Residual Business
$0-3500 |  | 0
$3501-5500
$5500-7500
$7501-9500
$9501 and UP
Spreadsheet: 6072d366-433a-4e2d-9a1f-13e8acbd50e0
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
2443 | 8149 | [NAME] | Fossum | USA | 202 | 00:01:04 | 00:00:00 | 01:41:26 | 00:00:00 | 00:36:53 | 1 | 03:22:50
Spreadsheet: 678907d1590112314-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example-sammyghr-
Sheet: 10 Feb 20 - 15 Feb 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-02-10 00:00:00 | 2020-02-11 00:00:00 | 2020-02-12 00:00:00 | 2020-02-13 00:00:00 | 2020-02-14 00:00:00 | 2020-02-15 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 10/02/2020 - 15/02/2020
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Dameon | ✓
[NAME] | ✓ | ✓ | ✓ | [NAME] | ✓ |  | 0.2 | 0.8 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Nathan | ✓
[NAME] | AWAY | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | N/A
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Tyson | ✓
Will | ✓ | ✓ | ✓ | ✓ | N/A |  |  | 1 |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  |  | ❌
 | ✓ | ✓ | ✓ | AWAY | ✓ |  |  | 1 |  |  | ❌
 | [NAME] | ✓ | ✓ | [NAME] | ✓ |  | 0.4 | 0.6 |  |  | ❌
Edge Protection [NAME] |  |  | 10/02/2020 - 15/02/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 10/02/2020 - 15/02/2020
Blum |  |  | ✓ |  |  |  |  |  |  | Dameon | ✓
Komatsu |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
Bascik |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
Canterbury Linen |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
47 Link Drive |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | N/A
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
Spreadsheet: john_griffith__16017__2_4_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 20 | 144 | 154 | 54.5 | 58.3 | 0.71 | 2002-02-04 10:59:00
 | CL J2 | 20.5 | 258 | 262 | 48.5 | 49.2 | 0.63 | 2002-02-04 10:59:00
 | CL K2 | 20.5 | 338 | 345 | 47 | 47.9 | 0.61 | 2002-02-04 10:59:00
 | CL M2 | 21 | 380 | 395 | 43.7 | 45.4 | 0.59 | 2002-02-04 10:59:00
 | CL N2 | 21 | 420 | 440 | 42.2 | 44.3 | 0.57 | 2002-02-04 10:59:00
 | CL Q2 | 21 | 450 | 465 | 41 | 42.4 | 0.55 | 2002-02-04 10:59:00
 | CL U2 | 21 | 465 | 485 | 39.3 | 41 | 0.53 | 2002-02-04 10:59:00
 | [NAME] | 21 | 485 | 505 | 38 | 39.5 | 0.51 | 2002-02-04 10:59:00
 | CL X2 | 21 | 490 | 515 | 36.1 | 38 | 0.49 | 2002-02-04 10:59:00
 | [NAME] | 21 | 495 | 520 | 34.8 | 36.5 | 0.47 | 2002-02-04 10:59:00
 | CL F3 | 21 | 495 | 525 | 33.1 | 35.2 | 0.45 | 2002-02-04 10:59:00
 | CL G3 | 21 | 500 | 530 | 32.1 | 34.1 | 0.44 | 2002-02-04 10:59:00
 | CL M3 | 21 | 535 | 570 | 30.1 | 32.1 | 0.41 | 2002-02-04 10:59:00
 | CL Z3 | 21 | 535 | 575 | 26.2 | 28.2 | 0.36 | 2002-02-04 10:59:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 1e5e05f1-06b6-46a9-92d5-556d3321d4a5
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 46. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (WA), 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 | A2413759F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413760R | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413761T | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413762V | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413763W | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413764X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413765A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413766C | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413767F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413768J | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 0415a110-2632-4d68-bab3-81654af3669f
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 9. FINANCE COMMITMENTS, For Motor Vehicles: Australia, Original ($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
Personal Finance - New motor cars and station wagons ; |  |  | Original | A2414166T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Personal Finance - Used motor cars and station wagons ; |  |  | Original | A2414167V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Personal Finance - Motor cycles ; |  |  | Original | A2414168W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Personal Finance - Other motor vehicles ; |  |  | Original | A2414169X | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Personal Finance - Total ; |  |  | Original | A2414170J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Commercial Finance ; |  |  | Original | A2414171K | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Value of Lease Finance Commitments ; |  |  | Original | A2414172L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414173R | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: benjamin_rogers__1034__Shortlist2
Sheet: Orion-Projects

Summary of Projects:
Operation (North America, East)
 | Plants | Location | MW | Fuel | Technology/Type | Grid | Ownership | Power Purchaser | Net
1 | Astoria Generating | Queens, NY | 1090 | Gas, oil | Steam turbine/peaking | NYPP, NYC | 1 | 2 years [NAME]/merchant
2 | [NAME] | [NAME], Ohio | 739 | Coal, fuel oil | Pulverized coal/baseload, CT/peaking | ECAR | 1 | Duquesne thru 2001
3 | 72 New York hydro plants | Upstate New York | 655 | Hydro | Hydroelectric/baseload | NYPP | 1 | PPA 2 yrs [NAME]/merchant
4 | Cheswick | Springdale, Pa | 570 | Coal | Pulverized coal/baseload | ECAR | 1 | Duquesne thru 2001
5 | 32 Gowanus Gas Combustion Turbines | Brooklyn, NY | 494 | No. 2 oil | Gas CT/peaking (movable) | NYPP, NYC | 1
6 | Elrama | Elrama, Pa | 487 | Coal | Pulverized coal/baseload | ECAR | 1 | Duquesne thru 2001
7 | New Castle | [NAME], Pa | 338 | Coal, no. 2 oil | Pulverized/cycling, diesel/peaking | ECAR | 1 | Duquesne thru 2001
8 | 16 Narrow Gas Combustion Turbines | Brooklyn, NY | 271 | Oil | Gas turbine/peaking (movable) | NYPP, NYC | 1
9 | Niles | Niles, Ohio | 246 | Coal, fuel oil | Cyclone/baseload, CT/peaking | ECAR | 1 | Duquesne thru 2001
10 | Brunot Island | Pittsburg, Pa | 234 | Oil | CT/peaking | ECAR | 1 | Duquesne thru 2001
11 | Carr Street Generating Station | East Syracuse, NY | 105 | Gas | Combined cycle/baseload | NYPP | 1 | Tolling with Constellation Power
12 | Phillips Site | Crescent Township, Pa | 308 in reserve | Coal | Coal reserve/baseload (Inoperable) | ECAR | 0 |  | 0
Spreadsheet: 118380d1313641131-matching-two-column-in-different-workbook-having-multiple-occurance-of-same-value-example
Sheet: Sheet1

CS |  |  |  |  | BS |  | helper
2010-01-10 00:00:00 | 210 | 210 |  |  | 2010-01-10 00:00:00 | 210 | 1
2010-02-10 00:00:00 | 125 | 125 |  |  | 2010-02-10 00:00:00 | 310 | 1
2010-03-10 00:00:00 | 210 | #N/A |  |  | 2010-03-10 00:00:00 | 125 | 1
2010-03-10 00:00:00 | 150 | #N/A |  |  | 2010-03-10 00:00:00 | 125 | 2
Spreadsheet: 837877d1690473098-summarize-data-from-source-table-with-some-conditions-examples
Sheet: Sheet1

 |  |  | Source Data |  |  |  |  |  |  |  |  | Expected Result
 |  | NO | DATE | GAS TYPE | VHCL | ST.NUMBER | PRICE |  |  | NO | DATE | GAS TYPE | VHCL | ST.NUMBER | PRICE
 |  | 1 | 2023-06-02 00:00:00 | Bio Solar | TRUCK | 44.51308 | 130000 |  |  | 1 | 2023-06-02 00:00:00 | Bio Solar | TRUCK | 44.51308 | 390000
 |  | 2 | 2023-06-02 00:00:00 | Bio Solar | TRUCK | 44.51308 | 260000 |  |  | 2 | 2023-06-02 00:00:00 | Pertalite | PERSONAL | 44.51309 | 130000
 |  | 3 | 2023-06-02 00:00:00 | Pertalite | PERSONAL | 44.51309 | 130000 |  |  | 3 | 2023-06-03 00:00:00 | Bio Solar | TRUCK | 44.51301 | 130000
 |  | 4 | 2023-06-03 00:00:00 | Bio Solar | TRUCK | 44.51301 | 130000 |  |  | 4 | 2023-06-03 00:00:00 | Bio Solar | TRUCK | 44.51309 | 130000
 |  | 5 | 2023-06-03 00:00:00 | Bio Solar | TRUCK | 44.51309 | 130000 |  |  | 5 | 2023-06-05 00:00:00 | Bio Solar | TRUCK | 44.51308 | 130000
 |  | 6 | 2023-06-05 00:00:00 | Bio Solar | TRUCK | 44.51308 | 130000 |  |  | 6 | 2023-06-05 00:00:00 | Bio Solar | TRUCK | 44.51318 | 130000
 |  | 7 | 2023-06-05 00:00:00 | Bio Solar | TRUCK | 44.51318 | 130000 |  |  | 7 | 2023-06-06 00:00:00 | Bio Solar | TRUCK | 44.51303 | 130000
 |  | 8 | 2023-06-06 00:00:00 | Bio Solar | TRUCK | 44.51303 | 130000 |  |  | 8 | 2023-06-06 00:00:00 | Pertamax | TRUCK | 44.51308 | 130000
 |  | 9 | 2023-06-06 00:00:00 | Pertamax | TRUCK | 44.51308 | 130000 |  |  | 9 | 2023-06-06 00:00:00 | Pertamax | PERSONAL | 44.51301 | 250000
 |  | 10 | 2023-06-06 00:00:00 | Pertamax | PERSONAL | 44.51301 | 250000 |  |  | 10 | 2023-06-07 00:00:00 | Bio Solar | Truk | 44.51317 | 130000
 |  | 11 | 2023-06-07 00:00:00 | Bio Solar | Truk | 44.51317 | 130000
Spreadsheet: 882240d1730510360-copying-rows-with-retaining-data-recruiting-spreadsheet-challenge-sample-recruiting-sheet
Sheet: Compliance

Date Entered | [NAME] | ID# | First Name | Last Name | Phone Number | [NAME] | Computer Assessment | Criminial BG | Date Updated | Education Verification | Adobe Pre-Hire Forms | Paperwork | Everify
2024-10-30 00:00:00 | 85827 JA | 20336713 | Semaiyah | [NAME] |  |  | N/A | SC Cleared | 2024-10-31 00:00:00 | Complete |  | Complete | Finalize
2024-10-30 00:00:00 | 85058 JS | 20344262 | [NAME] | [NAME] |  |  | N/A | SC Cleared | 2024-10-31 00:00:00 | Complete | sent 10/14 | Complete | Complete
2024-10-22 00:00:00 | 85058 KS | 16119223 | STACY | Smith |  |  | 0.91 | SC In Process | 2024-10-22 00:00:00 |  | Complete | OB 10/30
2024-10-28 00:00:00 | 85058 JS | 19308064 | [NAME] | [NAME] |  |  | N/A | SC Cleared | 2024-10-31 00:00:00 |  | sent 10/20 | [NAME] | 10/31 - reinvite
2024-10-30 00:00:00 | 85058 JS | 20344884 | Kasheka | [NAME] |  |  | N/A | SC Cleared | 2024-10-31 00:00:00 | requested 10/25 |  | 10/31 - pending app
2024-10-30 00:00:00 | 85058 KS | 12336 | [NAME] | Doe |  |  |  |  |  |  |  | OB 10/30
2024-11-01 00:00:00 | 85058 DO | 20333030 | [NAME] | Padilla |  |  |  |  |  |  |  | OB 10/30
2024-11-01 00:00:00 | 85058 DO | 20349118 | Yuvannia | [NAME]
2024-10-24 00:00:00 | 85058 JS | 20344884 | Kasheka | [NAME]
2024-10-31 00:00:00 | 85058 DO | 11349092 | Mariceli | Nuez
2024-11-01 00:00:00 | 85058 JS | 18710555 | Kalil | Tanco