tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 814614d1674507581-summing-results-from-dice-roll-chances-dice-roll-result-chances-updated
Sheet: Sheet1

Dice Roll | Result | 20-Sider | Alternate
2 | Green | 20 |  |  | Roll two six-sided die. Results will correspond to certain colors. For example, 2=Green.
3 | Blue | 18 | Red |  | In some cases, the results will be split, and require you to roll a 20-sided die to resolve. For example, an initial roll of 3 means that it's Blue from 1-18, otherwise Red.
4 | Red | 6 | Green
5 |  |  |  |  | Seeking to calculate the total number of chances of each color result. |  |  |  |  |  | Dice Roll | Chances
6 | Green | 14 | Blue |  |  |  |  |  |  |  | 2 | 1
7 | Blue | 12 | Green |  | For example, let's find the chances for Green. |  |  |  |  |  | 3 | 2
8 |  |  |  |  | Roll | Chances |  |  |  |  | 4 | 3
9 | Red | 9 | Blue |  | "2" Roll | 1 |  |  |  |  | 5 | 4
10 |  |  |  |  | "4" Roll | 2.1 | 14/20, or 0.7 from the 20 sider, multiplied by 3 chances from the "4" roll |  |  |  | 6 | 5
11 | Blue | 7 | Orange |  | "6" Roll | 3.5 | 5 chances from the "6" roll, multiplies by 0.7 |  |  |  | 7 | 6
12 |  |  |  |  | "7" Roll | 2.4 | 8/20, or 0.4 from the 20-sider, multiplied by 6 chances from the "7" roll |  |  |  | 8 | 5
 |  |  |  |  |  |  |  |  |  |  | 9 | 4
Chances |  |  |  |  |  |  |  |  |  |  | 10 | 3
Green | Blue | Red | Orange |  |  |  |  |  |  |  | 11 | 2
 |  |  |  |  |  |  |  |  |  |  | 12 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 36
Spreadsheet: 807086d1669734094-looking-for-a-better-option-than-sumproduct-due-to-near-15-000-formulas-of-it-sample-sheet
Sheet: Main Log

Type | Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
Type 1 | Name 1 | Test 1 | Test 2 | Test 3 | Test 4 | Test 5
Type 2 | Name 2 | Test 8
Type 1 | Name 3 | Test 1 | Test 7
Type 4 | Name 4
Type 1 | Name 5
Type 6 | Name 6 | Test 7 | Test 4 | Test 6
Type 8 | Name 7 | Test 8
Type 1 | Name 1 | Test 1 | Test 4
Type 1 | Name 1 | Test 3
Spreadsheet: 151351d1334867311-sumif-with-three-intersecting-values-test
Sheet: Extracted Data

I.D. | Condition | User Defined Field 4
Spreadsheet: 101318d1299485359-formula-time-time-formula-timesheet
Sheet: March 2010

[NAME] [NAME]
Date: | Project | From | To | Hours
2010-03-09 00:00:00 | XYZ | 01:45:00 | 03:30:00
 | ABC | 07:30:00 | 07:40:00
2010-03-10 00:00:00 | XYZ | 08:15:00 | 03:00:00
 | ABC | 04:30:00 | 06:10:00
2010-03-11 00:00:00 | ABC | 09:30:00 | 04:10:00
 | XYZ | 05:50:00 | 06:10:00
2010-03-12 00:00:00
2010-03-13 00:00:00
2010-03-15 00:00:00
2010-03-16 00:00:00
2010-03-19 00:00:00
2010-03-22 00:00:00
2010-03-24 00:00:00
Spreadsheet: 808404d1670440328-formula-to-look-in-a-number-column-and-find-a-certain-type-of-number-op-sample-9-
Sheet: Sheet2

Column1 | Column2
360 Appraisal Group | 14
AAA-AMC | 18
AMC Settlement Services | 236
American Valuation Corp | 996
AMSA | 285
[NAME] Services | 82
Appraisal House USA | 667
[NAME] | 6
Appraisal Management Solutions | 169
Appraisal MC | 34
Appraisal Unlimited Management Group | 972
AppraisalTek | 493
[NAME] | 721
[NAME] | 9
AssetVal Valuation Solutions | 112
Spreadsheet: 472478d1469616136-calculate-one-value-based-two-values-from-the-excel-table-table-1
Sheet: table

---- | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Budapest |  | 23 | 45 | 65 | 5 | 45 | 89 | 95 | 95 | 108
Berlin | 45 |  | 12 | 58 | 2 | 15 | 90 | 99 | 99 | 110
Paris | 48 | 48 |  | 78 | 8 | 48 | 91 | 99 | 99 | 115
Londra | 102 | 102 | 102 |  | 10 | 78 | 92 | 102 | 102 | 117
Roma | 150 | 150 | 150 | 150 |  | 35 | 93 | 105 | 105 | 119
Bucharest | 148 | 148 | 148 | 148 | 148 |  | 98 | 110 | 110 | 120
Madrid | 305 | 305 | 305 | 305 | 305 | 305 |  | 101 | 101 | 122
Lisabona | 458 | 458 | 458 | 458 | 458 | 458 | 458 |  | 125 | 125
Athena | 258 | 258 | 258 | 258 | 258 | 258 | 258 | 258 |  | 130
Moscow | 505 | 505 | 505 | 505 | 505 | 505 | 505 | 505 | 505
select lists (two values)
Paris
4
Result =
Spreadsheet: 767009d1644236858-convert-the-contents-of-a-cell-to-a-column-dataset
Sheet: Sheet2

Column1 |  | Value
Name6-Name7-Name8-last name first-first name-Name11 |  | Name6
Name61-Name71-Name81-last name first1-first name1-Name12 |  | Name7
Name62-Name72-Name82-last name first2-first name2-Name13 |  | Name8
 |  | last name first
 |  | first name
 |  | Name11
 |  | Name61
 |  | Name71
 |  | Name81
 |  | last name first1
 |  | first name1
 |  | Name12
 |  | Name62
 |  | Name72
 |  | Name82
 |  | last name first2
 |  | first [NAME]
 |  | Name13
Spreadsheet: 717275d1612549241-how-to-count-just-numbers-in-the-second-column-which-are-not-the-same-mysheet
Sheet: Hárok1

 | Val
 | Dátum | nákladové | Prod. | [NAME] |  | 2020-12-04 00:00:00
 | 2020-12-01 00:00:00 | 5034 | 2.5 | x
 | 2020-12-02 00:00:00 | 5019 | 2 | x
 | 2020-12-04 00:00:00 | 5021 | 2 | x
 | 2020-12-04 00:00:00 | 5034 | 2 | x
 | 2020-12-08 00:00:00 | 4338 | 4 | x
 | 2020-12-11 00:00:00 | 5028 | 1 | x
 | 2020-12-04 00:00:00 | 5021 | 1 | x
 | 2020-12-04 00:00:00 | 5029 | 3 | x
 | 2020-12-04 00:00:00 | 5090 | 1 | x
 | 2020-12-14 00:00:00 | 4339 | 2 | x
 | 2020-12-14 00:00:00 | 5034 | 1.5 | x
 | 2020-12-16 00:00:00 | 4329 | 3 | x
 | 2020-12-21 00:00:00 | 4332 | 2.5 | x
 | 2020-12-21 00:00:00 | 5101 | 1 | x
 | 2020-12-22 00:00:00 | 4346 | 1.5 | x
 | 2020-12-22 00:00:00 | 5090 | 1 | x
 | 2020-12-22 00:00:00 | 4319 | 1 | x
 | 2020-12-23 00:00:00 | 5020 | 4 | x
 | 2020-12-28 00:00:00 | 4326 | 7.5 | x
 | 2020-12-29 00:00:00 | 5301 | 1.5 | x
 | 2020-12-29 00:00:00 | 5102 | 2 | x
 | 2020-12-29 00:00:00 | 4326 | 3 | x
 | 2020-12-30 00:00:00 | 5019 | 1 | x
 | 2020-12-01 00:00:00 | 5034 | 2 | x
 | 2020-12-01 00:00:00 | 4011 | 3.5 | x
 | 2020-12-03 00:00:00 | 4340 | 0.5 | x
 | 2020-12-04 00:00:00 | 5021 | 2 | x
 | 2020-12-04 00:00:00 | 4314 | 1 | x
 | 2020-12-30 00:00:00 | 4106 | 1 | x
 | 2020-12-30 00:00:00 | 4346 | 1.5 | x
 | 2020-12-01 00:00:00 | 5029 | 1.5 | x
 | 2020-12-02 00:00:00 | 5090 | 1 | x
 | 2020-12-02 00:00:00 | 4103 | 0.5 | x
 | 2020-12-04 00:00:00 | 40 | 1 | x
 | 2020-12-07 00:00:00 | 4338 | 2 | x
 | 2020-12-09 00:00:00 | 5009 | 1 | x
 | 2020-12-10 00:00:00 | 4345 | 1 | x
 | 2020-12-10 00:00:00 | 4339 | 4 | x
 | 2020-12-10 00:00:00 | 5009 | 2 | x
 | 2020-12-11 00:00:00 | 4339 | 1 | x
 | 2020-12-16 00:00:00 | 4315 | 2 | x
 | 2020-12-16 00:00:00 | 4314 | 0.5 | x
 | 2020-12-16 00:00:00 | 4329 | 1 | x
 | 2020-12-18 00:00:00 | 4315 | 1 | x
 | 2020-12-18 00:00:00 | 40 | 0.5 | x
 | 2020-12-21 00:00:00 | 4339 | 5 | x
 | 2020-12-22 00:00:00 | 4339 | 4 | x
 | 2020-12-22 00:00:00 | 5020 | 1 | x
Spreadsheet: darrell_schoolcraft__7796__imbalsumm0107
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 27686 | 27476
2 | 27971 | 27476
3 | 81478 | 81305
4 | 92416 | 92044
5 | 104180 | 107044
6 | 85005 | 84253
7 | 102170 | 103816
8 | 101849 | 97816
9 | 101901 | 101981
10 | 80229 | 79575
11 | 91609 | 91496
12 | 91776 | 91496
13 | 98890 | 98105
14 | 95006 | 95675
15 | 98127 | 90791
16 | 95603 | 94316
17 | 67072 | 66798
18 | 100738 | 99995
19 | 55492 | 54364
20 | 93233 | 93294
21 | 96401 | 95424
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | 48879.09
2001-07-21 00:00:00
Spreadsheet: 218804d1362585279-football-league-table-database
Sheet: Sumário - Tabela 2

[NAME]
Arsenal | 0 | 0 | Sunderland
Fulham | 5 | 0 | [NAME]
QPR | 0 | 5 | Swansea
Reading | 1 | 1 | Stoke City
West Brom | 3 | 0 | Liverpool
West Ham | 1 | 0 | [NAME]
Newcastle | 2 | 1 | Tottenham
[NAME] | 0 | 2 | Chelsea
Man City | 3 | 2 | Southampton
Everton | 1 | 0 | Man United
Spreadsheet: 139200d1328125483-sum-values-from-one-collumn-according-to-values-from-another-one-excel-problem-sum-modified-by-tigeravatar-v3-
Sheet: Sheet1

Day | Stake | Sum all stakes from last "day 1" until yesterday
1 | 2
1 | 2
1 | 2
2 | 3
3 | 5
1 | 2
2 | 3
3 | 5
4 | 9
5 | 14
6 | 18
1 | 2
2 | 3
3 | 5
Spreadsheet: 91627d1291304677-report-using-vlook-up-excel-rep-sheet
Sheet: MAIN TAB

TYPE IN STORE NUMBER IN BLUE BOX: |  | 1001
TSM NAME: | BOB |  |  | Product Status Reference:
ADDRESS: | BOWMANVILLE |  |  | A | Active
CITY: | MICHIGAN |  |  | D | Delisted
Store Type | 127 EXAMPLE |  |  | I | Inactive
Item Number | UPC | Item Description | Product Status | Sales  (in Latest 4 Weeks)
1236
Spreadsheet: 691892d1597935665-max-formula-only-working-for-the-first-cell-samplespreadsheet2
Sheet: Sheet3

TeamName | Number of values for this team |  |  |  | [NAME] by [NAME] | What the value should be | Match?
TeamD | 1 |  |  | TeamD |  | 4
TeamD | 2 |  |  | TeamC |  | 1
TeamD | 3 |  |  | TeamB |  | 2
TeamD | 3 |  |  | TeamA |  | 1
TeamD | 4
TeamC | 1
TeamB | 1
TeamB | 2
TeamA | 1
Spreadsheet: 69525dd9-6ba9-437e-b947-7aece247f6dc
Sheet: Sheet1

FairTax.org Tri-Fold Import Template | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
FIRST_NAME | [NAME] | LAST_NAME | PRIMARY_EMAIL | HOME_STREET1 | [NAME] | HOME_CITY | HOME_STATEPROV | HOME_ZIP | Receive More Info | [NAME] | Attend Rally | Speak to Groups | Contribute | Letter Writing Campaign
[NAME] | [NAME] | Smith -Sample | [EMAIL] | 123 Main Street | Apt 1. | Houston | TX | 55555 | True | True | True | False | True | False
Spreadsheet: 093532a8-0569-45ce-b52e-45010cfeeb5c
Sheet: MENU INFO

Drop-Down Menu Item List
 | Table 1.1 |  |  |  |  | Table 3.1 |  |  |  |  | Table 4.1
 | Highest Degree Offered |  |  |  |  | Campus Site |  |  |  |  | Major Group ID/Major [NAME]
 | 4 year & master's |  |  |  |  | [NAME] |  |  |  |  | AC - Accounting
 | 4 year & doctoral |  |  |  |  | Branch Campus |  |  |  |  | AG - Agriculture and Farming
 | 4 year undergraduate |  |  |  |  | Satellite Site |  |  |  |  | AL - American Indian Languages
 | 2 year |  |  |  |  |  |  |  |  |  | AS - American Indian Studies
 |  |  |  |  |  | Table 3.1 |  |  |  |  | AR - Art
 | Table 1.1 |  |  |  |  | Main Function |  |  |  |  | AU - Automotive Technology
 | [NAME] |  |  |  |  | Administration/Office |  |  |  |  | BI - Biology
 | Quarter |  |  |  |  | Auxiliary |  |  |  |  | BT - Building Trades
 | Semester |  |  |  |  | Classroom |  |  |  |  | BU - Business
 | Trimester |  |  |  |  | Cultural Center/Museum |  |  |  |  | CH - Chemistry
 | Other |  |  |  |  | Distance Learning |  |  |  |  | CS - Computer Science
 |  |  |  |  |  | Laboratory |  |  |  |  | CT - Computer Technology
 | Table 1.1 |  |  |  |  | Library |  |  |  |  | CL - Corrections/Law Enforcement
 | Land-Granted |  |  |  |  | Research |  |  |  |  | EA - Education-Paraprofessional
 | Yes |  |  |  |  | Residence |  |  |  |  | EO - Education-Professional
 | No |  |  |  |  | Student Services/Recreation |  |  |  |  | EN - English
 |  |  |  |  |  |  |  |  |  |  | ES - Environmental Science/Natural Resources
 | Table 1.1 |  |  |  |  | Table 3.1 |  |  |  |  | GE - Geography
 | Location |  |  |  |  | Own/Lease |  |  |  |  | HS - Health Careers
 | On Reservation |  |  |  |  | Assigned by Tribe |  |  |  |  | HI - Hospitality Industry
 | Off Reservation |  |  |  |  | Donated |  |  |  |  | HS - Human Services
 |  |  |  |  |  | Lease/Rent |  |  |  |  | IP - Individualized Program
 |  |  |  |  |  | Own |  |  |  |  | LA - Liberal Arts/General Studies
 |  |  |  |  |  |  |  |  |  |  | LS - Life Sciences
 |  |  |  |  |  | Table 3.2 |  |  |  |  | MA - Mathematics
 |  |  |  |  |  | Catalogue On-line Access |  |  |  |  | NS - Natural Science
 |  |  |  |  |  | Inter-Library System |  |  |  |  | NU - Nursing
 |  |  |  |  |  | Computer Lab w/ Internet |  |  |  |  | OA - Office Administration/Technology
 |  |  |  |  |  | Yes |  |  |  |  | PA - Paralegal
 |  |  |  |  |  | No |  |  |  |  | PE - Pre-Engineering
 |  |  |  |  |  |  |  |  |  |  | PV - Pre-Veterinary Science
 |  |  |  |  |  | Table 3.2 |  |  |  |  | SC - Science
 |  |  |  |  |  | Community Library Status |  |  |  |  | SS - Social Science
 |  |  |  |  |  | Community Library |  |  |  |  | VC - Vocational/Career Programs
 |  |  |  |  |  | Institution Use Only |  |  |  |  | UD - Undeclared/Nondeclared
 |  |  |  |  |  |  |  |  |  |  | MS - Master Degree Programs
 |  |  |  |  |  | Table 3.2
 |  |  |  |  |  | Community Learning Center
 |  |  |  |  |  | Yes
 |  |  |  |  |  | No
Spreadsheet: 269812d1381294132-iferror-match-criteria-sample-text
Sheet: data

Name | Remarks | Day
[NAME] | Test 1 | Sunday | Tom1
[NAME] | Test 2 | Sunday | Kim1
[NAME] | Test 3 | Sunday | Tom2
[NAME] | Test 4 | Monday | Kim2
[NAME] | Test 5 | Monday | Tom3
[NAME] | Test 6 | Tuesday | Tom4
[NAME] | Test 7 | Tuesday | KIm3
Spreadsheet: 172515d1344246701-show-next-worksheet-value-on-another-worksheet-timesheet-3
Sheet: Teams

TEAMS
DATE | insert month | day
[NAME]
CLIENT
HOURS
 | TEAM 1 | TEAM 2 | TEAM 3 | TEAM 4 | TEAM 5 | STOOR | OFFICE
SUPERVISOR | Adolf | Delton | Gerhard | Hendry | [NAME]
WORKERS
 |  |  |  |  |  |  |  |  |  | adolf
 |  |  |  |  |  |  |  |  |  | delton
 |  |  |  |  |  |  |  |  |  | gerhard
 |  |  |  |  |  |  |  |  |  | hendry
 |  |  |  |  |  |  |  |  |  | leon
Spreadsheet: 774505d1648514351-pulling-data-from-a-cell-on-another-sheet-based-on-matching-criteria-route-17-leg-report-trial
Sheet: Sheet1

Departure Terminal | [NAME] | Date | Sched Dept Ts | In Dock Time | Chief Officer | Actual Dept Ts | Master | In Transit Time | Actual [NAME] | Total Veh | Total Pass | Total O/L
Spreadsheet: louise_kitchen__22538__Consolidated BCP List
Sheet: POWER

Employees Included in Business Continuity Plan
Department | Individual
Management | [NAME]
Management Count
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading Count
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading Count
Southeast Trading | [NAME]
Southeast Trading | [NAME]
Southeast Trading | [NAME]
Southeast Trading | [NAME]
Southeast Trading | [NAME]
Southeast Trading Count
Ercot Trading | [NAME]
Ercot Trading | [NAME]
Ercot Trading | [NAME]
Ercot Trading | [NAME]
Ercot Trading | [NAME]
Ercot Trading Count
Option Trading | [NAME]
Option Trading | [NAME]
Option Trading | [NAME]
Option Trading | [NAME]
Option Trading | [NAME]
Option Trading Count
Services Trading | [NAME]
Services Trading | [NAME]
Services Trading | [NAME]
Services Trading | [NAME]
Services Trading | [NAME]
Services Trading | [NAME]
Services Trading Count
Schedulers | [NAME]
Schedulers | [NAME]
Schedulers | [NAME]
Schedulers | [NAME]
Schedulers | [NAME]
Schedulers | [NAME]
Schedulers | Smith Day
Schedulers Count
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | Casey Evans
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | Israel Estrada
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | Patricial Rivera
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt Count
Clerical | T.Jae Black
Clerical | [NAME]
Clerical | [NAME]
Clerical | Claudia Guerra
Clerical Count
Grand Count
Spreadsheet: 693964d1599236604-search-cell-for-string-accounting-for-prefixes-count-text-with-wildcard
Sheet: Sheet1

Comments
unprepared
underprepared
 |  | prepared
struggle |  | unprepared
prepared
prepared me
not prepared
very prepared
unprofessional
professional
poor
Prepared
lack
great
flawed
very prepared
unprepared
classroom
late
superion
horrendous
Spreadsheet: 138217d1327574070-formula-with-sheet-name-variable-toys
Sheet: Listing

Item# | App. Date | Item Year | Item Description | Condition | High | Low | Average
1
 |  |  |  |  |  | Total |  |  | Total Avg.
Item# | App. Date | Item Year | Item Description | Condition | High | Low | Average
 |  | <-- Incremental formula would start at b8, incrementing off of [NAME]'s formula
Spreadsheet: 209773d1359214547-sum-of-unique-values-doesnt-match-sum-of-full-list-book1
Sheet: Sheet1

Product description | Cost | Unique Product | Sum |  | Unique Products
[NAME] | 1000 | [NAME] | 2000 |  | [NAME]
Nut | 2000 | Nut | 2000 |  | Nut
Glue | 3000 | Glue | 3000 |  | Glue
Axle | 1000 | Axle | 1000 |  | Axle
Propshaft | 2000 | Propshaft | 4000 |  | Propshaft
Differential | 3000 | Differential | 3000 |  | Differential
[NAME] | 1000 |  |  |  | [NAME]
Propshaft | 2000
[NAME]
Spreadsheet: 762457d1641565795-help-with-formula-power-query-to-measure-the-precision-of-codes-power-query-for-precision-by-code-modified
Sheet: Output

Expected output
agentcode | total number of rows in agentcode | total matching rows of code in predict code | %matching |  | Total | Matches
A202 | 2 | 1 | 50
A203 | 3 | 1 | 33
A415 | 1 | 1 | 100
D123 | 2 | 1 | 50
E124 | 1 | 1 | 100
F341 | 2 | 1 | 50
Spreadsheet: 792607d1661007274-change-to-correct-date-format-change-date-format
Sheet: Sheet1

Original Data |  | Original Data.1
2022-01-05 00:00:00 |  | 2022-01-05 00:00:00
2022-02-05 00:00:00 |  | 2022-02-05 00:00:00
2022-03-05 00:00:00 |  | 2022-03-05 00:00:00
2022-04-05 00:00:00 |  | 2022-04-05 00:00:00
2022-05-05 00:00:00 |  | 2022-05-05 00:00:00
2022-06-05 00:00:00 |  | 2022-06-05 00:00:00
2022-07-05 00:00:00 |  | 2022-07-05 00:00:00
2022-08-05 00:00:00 |  | 2022-08-05 00:00:00
2022-09-05 00:00:00 |  | 2022-09-05 00:00:00
2022-10-05 00:00:00 |  | 2022-10-05 00:00:00
2022-11-05 00:00:00 |  | 2022-11-05 00:00:00
2022-12-05 00:00:00 |  | 2022-12-05 00:00:00
5/13/2022 12:00:00 AM |  | 2022-05-13 00:00:00
5/14/2022 12:00:00 AM |  | 2022-05-14 00:00:00
Spreadsheet: 875254d1721836719-filtering-on-any-text-in-column-test
Sheet: Sheet2

Number | Lead GP | Contributing GP | Opening FY
1 | EDU |  | 2021
 | EDU | HNP | 2021
 | EDU |  | 2021
 | EDU |  | 2023
 | EDU | SPJ | 2023
 | EDU |  | 2023
 | EDU | HNP GOV | 2023
 | EDU |  | 2023
 | EDU |  | 2024
 | EDU | SSI | 2024
 | EDU |  | 2024
 | EDU | AGR | 2024
 | EDU |  | 2025
 | EDU | SPJ AGR | 2025
 | EDU |  | 2025
 | EDU |  | 2025
Spreadsheet: 208713d1358901315-sumif-formula-for-excel-2003-templatetoputonexcel1
Sheet: Sheet1

 |  | 2013-02-02 00:00:00 | 2013-02-03 00:00:00 | 2013-02-04 00:00:00 | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | 2013-02-08 00:00:00 | 2013-02-09 00:00:00 | 2013-02-10 00:00:00 | 2013-02-11 00:00:00 | <--- | Dates
 | Maxine | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | [NAME] | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20
 | [NAME] | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 | Rose | 4 | 4 | 4 | 4 | 4 | 4 | 10 | 10 | 10 | 10
 | Michelle | 5 | 4 | 6 | 8 | 10 | 6 | 7 | 8 | 9 | 10
 | [NAME] | 6 | 2 | 3 | 7 | 7 | 7 | 7 | 7 | 7 | 7
 | Maxine |  | <---- | This is where the sum value should be
 | [NAME] |  |  |  |  |  |  | 21
 | [NAME]
 | Rose
 | Michelle |  |  |  |  |  |  |  | 22
 | [NAME]
 | BeginningDate | 2013-02-02 00:00:00
 | End Date | 2013-02-07 00:00:00
Spreadsheet: 81554d1281695043-extracting-text-into-multiple-columns-dummy-text-extraction
Sheet: Sheet1

Colour | Recipe | Base | Pack size | B | E | F | G | H | K | M | N | O | P | R | S | T | V | W | X | Parts
Red | L:5L [NAME] | L | 5L |  |  |  |  |  | 60 |  |  |  |  |  | 10 | 240
Yellow | [NAME] R:60 T:8 | M | 5L |  |  |  |  |  | 50 |  |  |  |  | 60 |  | 8
Blue | L:5L G:220 M:20 X:160 | L | 5L |  |  |  | 220 |  |  | 20 |  |  |  |  |  |  |  |  | 160
Green | E:2.5L [NAME] O:1700 | E | 2.5L | 45 |  | 650 |  |  |  |  |  | 1700
Orange | M:2.5L E:330 G:80 V:4 W:4000 | M | 2.5L |  | 330 |  | 80 |  |  |  |  |  |  |  |  |  | 4 | 4000
Spreadsheet: 12414c91-876a-4d6c-a16d-80db545fb4cb
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 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
Personal Finance - Used motor cars and station wagons ; |  |  | Original | A2414167V | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
Personal Finance - Motor cycles ; |  |  | Original | A2414168W | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
Personal Finance - Other motor vehicles ; |  |  | Original | A2414169X | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
Personal Finance - Total ; |  |  | Original | A2414170J | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
Commercial Finance ; |  |  | Original | A2414171K | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
Value of Lease Finance Commitments ; |  |  | Original | A2414172L | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414173R | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2009