tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 66298d1266985478-merging-worksheets-based-on-conditions-forum-example
Sheet: Sheet2

ID | Name | Num | Size
1 | abc | 5 | 44
2 | def | 9 | 22
3 | ghi | 2 | 11
4 | jkl | 4 | 33
Spreadsheet: 223688d1364297721-auto-populating-cell-values-from-list-based-on-criteria-source-separate-excel-file-customertool
Sheet: Account Planning Tool

Customer tool
Choose City, Product or Indication
 |  | City | Product | Indication
 |  | Aalborg | Product1 | Indication1
Name | Product | Indication | City | stdTimeStampStart |  | 1st qtr activity | 2nd qtr activity | 3rd qtr activity | 4th qtr activity
Adam | Product1 | Indication1 | Aalborg | 2013-02-13 13:08:52 |  | Brev | 0 | 0 | 0
Adam | Product1 | Indication1 | Aalborg | 2013-05-16 16:00:00 |  | 0 | Aftenmøde | 0 | 0
Adam | Product1 | Indication1 | Aalborg | 2013-02-05 14:30:00 |  | Gruppebesøg | 0 | 0 | 0
Adam | Product1 | Indication1 | Aalborg | 2013-06-13 16:00:00 |  | 0 | Afdelingsmøde | 0 | 0
Adam | Product1 | Indication1 | Aalborg | 2013-02-12 14:30:00 |  | Gruppebesøg | 0 | 0 | 0
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
Spreadsheet: c8a1f40e-4afe-449a-9128-54f610217209
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43529758 | 2014-10-11 07:22:22 | AXIS | 0 | 3 | 6 | 1581268 | Dain Ironfoot | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
43529930 | 2014-10-11 07:47:22 | ALLIES | 1 | 6 | 5 | 1581268 | Dain Ironfoot | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
43530106 | 2014-10-11 08:05:38 | AXIS | 0 | 1 | 5 | 1581268 | Dain Ironfoot | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
43530234 | 2014-10-11 08:32:17 | ALLIES | 1 | 5 | 3 | 1581268 | Dain Ironfoot | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
43530455 | 2014-10-11 09:02:08 | AXIS | 0 | 5 | 7 | 384175 | ssegrubnad | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43530673 | 2014-10-11 09:25:36 | ALLIES | 0 | 5 | 7 | 384175 | ssegrubnad | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 0445ec22-c1e4-4c4c-a8fe-07f2ff76870c
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 41. OPERATING LEASE FINANCE COMMITMENTS, By Industry: 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
Agriculture, forestry and fishing ; |  |  | Original | A2413817T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2413818V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2413819W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2413820F | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2413821J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2413823L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2413824R | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2413825T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2413826V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Public Administration ; |  |  | Original | A2413827W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2413828X | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2413829A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413830K | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 768537d1645018017-formula-to-calculate-a-price-based-on-quantity-thresholds-matrix-estimation-matrix-aligw
Sheet: Sheet1

 | INPUT CHOSEN QUANTITY HERE
Choose Option via drop down menu below | 25 | 75 | 750
Option 1
Option 3 |  |  |  |  | *FORMULA NEEDED TO CALCULATE HERE
Option 4
PRICE MATRIX | 0 | 51 | 101 | 251 | 501
Drop Down Menu  (using Data Validation List) | 50 | 100 | 250 | 500 | 501
Option 1 | 10 | 9 | 8 | 7 | 6
Option 2 | 20 | 19 | 18 | 17 | 16
Option 3 | 30 | 29 | 28 | 27 | 26
Option 4 | 40 | 39 | 38 | 37 | 36
Spreadsheet: richard_shapiro__32392__Proposed 2002 b
Sheet: Scenario 3

Cost Center Owner
Cost Center Number
 | Please use this form only for Outside Services
 | Scenario 3:  How would you implement a 40% reduction from Scenario 1?
 | Retainers and Identified Needs
 | [NAME] | Activity/Region | 2002 Est. $
 | Piper Marbury | Legal/Illinois | 54000
 | Roan & Potts | Lobby/Illinois | 36000
 | Vorys Sater | Lobby/Ohio | 24000
 | Karoub | Lobby/Michigan | 30000
 | Varnum Riddering | Legal/Michigan | 12000
 | Bourgois | Lobby/Louisiana | 24000
 | BoseTreacy | Lobby/Indiana | 30000
 | Roy Cable | Lobby/Missouri | 18000
 | Additional Lobbyist | Lobby/Missouri | 18000
 | Corp. Contribution | Contribution/Illinois | 10000
 | Corp. Contribution | Contribution/Ohio | 4000
 | Corp. Contribution | Contribution/Michigan | 5000
 | Corp. Contribution | Contribution/Louisiana | 5000
 | Corp. Contribution | Contribution/Indiana | 5000
 | Corp. Contribution | Contribution/MO | 5000
 | Corp. Contribution | Contribution/Arkansas | 2000
 | Corp. Contribution | Contribution/MS | 0
 |  |  |  | Target
 |  | Total:
 | [NAME]
 | [NAME] | Activity/Region | 2002 Est. $
 | MWIPPS | Legal/Lobby/Regional | 10000
 | IMA, IRMA | Assoc./Illinois | 5000
 | ORM, OPAE | Assoc./Ohio | 3000
 | MRM, Chamber | Assoc./Michigan | 5000
 | LMOGA, LABI | Assoc./Louisiana | 5000
 | IRC, Chamber | [NAME] | 2000
 | Coalit. MRM Chamber | Assoc. Lobbying/MO | 5000
 | IEC, ABI Retail Fed | [NAME]. Lobby/Iowa | 2500
 | Chamber, Coalit. | [NAME]. Lobby/MN | 2500
 | Manuf. [NAME]. | [NAME]. Lobby/Wis. | 1000
 | USO&GA MS MMA | [NAME]. Lobby/LA | 5000
 | USO&GA MS MMA | [NAME]. Lobby/MS | 0
 | USO&GA MS MMA | [NAME]. [NAME] | 1000
 | BILLD, NLIEC | [NAME]. [NAME] | 8000
 | Varnum Riddering | Legal/Michigan | 50000
 | Piper Marbury | Legal/Illinois | 145000
 | Vorys Sater | Legal/Ohio | 126000
 | Assorted - ENA | Legal/Regional | 0
 | [NAME] | Legal/Indiana | 5000
 |  |  |  | Target
 |  | Total:
 | Note
 | Varnum - dereg proceedings, issues and rulemakings
 | Piper Marbury - Com Ed. PPO litigation, complaint against
 | IP; other.
 | Vorys - complaint on physical delivery, OFO case against
 | Columbia, coal plant development
 | Assorted ENA matters - legal support for ENA gas
 | [NAME] legal activity; IURC proceeding on
 | transmission.
Spreadsheet: 122772d1317141458-charting-amounts-between-overlapping-date-ranges-headcount-charting
Sheet: Sheet1

Task 1 | Headcount |  | Task 2 | Headcount |  | Total | Headcount
2011-01-01 00:00:00 | 0 |  | 2011-06-30 00:00:00 |  |  | 2011-01-01 00:00:00 | 0
 | 1 |  |  | 2 |  |  | 1
2011-08-01 00:00:00 |  |  | 2011-12-31 00:00:00 |  |  | 2011-06-30 00:00:00 | 1
 | 0 |  |  | 0 |  |  | 2.5
 |  |  |  |  |  | 2011-08-01 00:00:00 | 2.5
 |  |  |  |  |  |  | 2
 |  |  |  |  |  | 2011-12-31 00:00:00 | 2
 |  |  |  |  |  |  | 0
Spreadsheet: 728296d1618403341-look-up-two-references-over-multiple-pages-lookup-multiple-pages
Sheet: Entry sheet

 | ANO | Customer
 | PCABC | Customer Contact |  |  | TO
 | SSANO | Staff |  |  | FROM
 | ANO | Customer
 | SSANO | Customer Contact |  |  | TO
 | PCABC | Staff |  |  | FROM
 | ANO
 | BRU
 | SSANO
 | JBBRU
Spreadsheet: jim_schwieger__14301__Bronco Playoff Schedule
Sheet: Sheet3

Bronco Gray Consolation Playoff Bracket/Schedule
#9 Reds-Labay
#13 Pirates-Hamilton |  | Winner of Round 2
Wednesday 5/16 | Winner of 13 vs. 20
WLY#5 @ 8:00pm
#20 Mariners-Bleyl
 |  |  | Winner Round 3
#14 Padres-Arnold
Tuesday 5/15 | Winner of 14 vs.19
WLY#2 @ 8:00pm
#19 Marlins-Bleyl |  | Winner of Round 2
#12 Dodgers-Truitt
 |  | Monday 5/21
#11 Cubs-Hamilton
#15 Braves-Thorton |  | Winner of Round 2
Tuesday 5/15 | Winner of 15 vs. 18
WLY#2 @ 6:00pm
#18 White Sox-Arnold
 |  |  | Winner Round 3
#17 Tigers-Campbell
Tuesday 5/15 | Winner of 13 vs.16
WLY#5 @ 8:00pm
#16 Twinns-Truitt |  | Winner of Round 2
#10 Cardinals-Cook
Spreadsheet: 863256d1710817250-pull-range-of-values-based-on-upper-and-lower-bound-in-1-or-2-cells-pull-range-of-values
Sheet: Sheet1

Prod Class | [NAME]
0.9 | Prod A
0.9 | Prod B
0.9 | Prod C
1 | Prod D
1 | Prod E
1 | [NAME]
1.1 | [NAME]
1.1 | Prod H
1.2 | Prod I
1.2 | Prod J
1.3 | [NAME]
1.3 | [NAME]
1.4 | [NAME]
1.4 | Prod N
1.4 | Prod O
1.4 | Prod P
1.5 | Prod Q
1.5 | Prod R
1.5 | Prod S
1.5 | Prod T
1.6 | [NAME]
1.6 | Prod V
1.6 | [NAME]
1.6 | [NAME]
1.6 | Prod Y
1.7 | Prod Z
Spreadsheet: joe_parks__14656__dec13pm
Sheet: Sort

Amerex Weather Desk
[PHONE]
[NAME]
[EMAIL]
Spreadsheet: 680106d1590780998-have-data-automatically-build-new-list-based-on-criteria-from-a-specific-column-budget-example
Sheet: Data

Data table
Item | Category | Explanation | January | February | March | April | May | June | July | August | September | October | November | December
Mortgage | Housing |  | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500
Electric | Housing |  | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120
Water | Housing |  | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80
Grocery | Food |  | 300 | 300 | 400 | 300 | 300 | 400 | 300 | 300 | 400 | 300 | 300 | 400
Lawn Care | Housing |  |  |  |  | 50 | 50 | 50 | 50 | 50
Garbage | Housing |  | 45 |  |  | 45 |  |  | 45 |  |  | 45
[NAME] | Gifts |  |  | 150
[NAME] | Gifts |  |  |  |  |  |  | 75
This is a sample of what the data sheet would look like.  There would be many more items in columnA.  The amounts for columnA might fluctuate throughout the year, (IE, Row6-Row10 in this example.)
What I am wanting to do, is have the list automatically build into the corresponding month sheets.  I have January and February 2021 in this sample  This list would need to fill ColumnB Rows 6-50 in each respective month, and exclude items that are $0.00 that month.  Then I am wanting to have it return that months amounts in the following column.  (January would include Garbage, February would include [NAME].)
I have been trying to use an array formula with Index and [NAME], to get the list to build the list for each month.   My plans beyond that was to use one of the lookup formulas to find input the corresponding amount for that month.
Spreadsheet: 700697d1603294621-select-specific-n-of-rows-which-meet-condition-to-send
Sheet: Schedule

This auditor | can audit | in these countries
Nick | 5 | US | GB
Raiden | 5 | US | GB
Ian | 5 | CN | JP | IRL
[NAME] | 8 | JP | CZ
Auditor | country | QS Login | Status | [NAME] | associate_task | associate_queue | associate | metric_wk_no | associate_action | correct associate action
Spreadsheet: benjamin_rogers__1221__UAE latest O&M costs from Scott
Sheet: Table of Contents

Operations & Maintenance Cost Estimate
Table of Contents
Table of Contents
Scope
Major [NAME]
 | GT Scheduled Major Maint. Program (year by year)
Spreadsheet: 735182d1622740472-formula-to-extract-data-where-length-differs-extract-data-varying-length
Sheet: Sheet1

BR1 SVC Cash Sales.xlsm
BR1 Parts Cash Sales.xlsm
Southern SVC Cash Sales.xlsm
Southern Parts Cash Sales.xlsm
KTM SVC Cash Sales.xlsm
[NAME] Sales.xlsm
Spreadsheet: 35783d1233436788-advanced-subtraction-problem-debt-payment-calculator
Sheet: Simple

 |  | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
 | Extra Payments
 | Debt 01 | 500
 | Debt 02 | 800
 | Debt 03 | 1500
 | Debt 04 | 350
 | Debt 05 | 1200
 |  | This worksheet is simplified to excluded any interest and confusion in my main worksheet .
 |  | Say I want the debts paid off in this order: Debt 05 -> Debt 04 -> Debt 03 -> Debt 02 -> Debt 01. If I put $500 into cell [NAME] then cell C8 will subtract itself to $900. But lets say I put in $1300 into cell [NAME] then cell C8 will be $(100). Rather than going negative, I want cell C8 (Debt 05) to reach (and stay at) $0 and the extra $100 left over to automatically subtract from Debt 04 in cell C7.
Spreadsheet: 131089d1322735117-or-nested-in-countifs-workbook1
Sheet: Sheet1

 | Location Codes
Cell Type | Strata A | [NAME] | Strata C | Strata D | Possible Locations: | d | f | g | h | j | k
Erythrocyte | d | f | g | h
Erythrocyte | d | f | g | h
Erythrocyte | d | f | g
Megakaryocyte | g | h | j
Megakaryocyte | h | j | k
Monocyte | f | g | h | j
Monocyte | f | g
Connective tissue macrophage | f
Connective tissue macrophage | f | g | h
Connective tissue macrophage | g | h
Epidermal Langerhans | h | j | k
Epidermal Langerhans | h | j | k
Epidermal Langerhans | j | k
Epidermal Langerhans | g | h | j | k
Osteoclast | f
Dendritic | h
Microglial | g | h
Spreadsheet: 113898d1309788199-excel-2007-move-and-concatenate-mergevalues
Sheet: Data

 | Department
1 | STEEL CHECKER PLATES HOT  ROLLED THICKNESS
 | 3.2MM |  |  | Click the MERGE button to try it out.
 | (SEE DRAWING POS. 1)
 | ***OFFER 2.4MTR PER LGH***
 | ***REQUIRES 5 WORKING DAYS***
 | FABRICATE ITEM, NON-RETURNABLE
2 | STEEL CHECKER PLATES HOT  ROLLED THICKNESS
 | 3.2MM
 | (SEE DRAWING POS. 2)
 | ***OFFER 2.4MTR PER LGH***
 | ***REQUIRES 5 WORKING DAYS***
 | FABRICATE ITEM, NON-RETURNABLE
3 | STEEL CHECKER PLATES HOT  ROLLED THICKNESS 3.2MM
 | (SEE DRAWING POS. 3)
 | ***OFFER 2.4MTR PER LGH***
 | FABRICATE ITEM, NON-RETURNABLE
4 | BOLT WITH NUTS SIZE 13X8X35MM
5 | PLAIN WASHERS FOR [NAME] 13X8X35MM
6 | DRILL H.S.S. STRAIGHT SHANK LONG TWIST
 | 8.5X250MM
Spreadsheet: 460463d1463085636-minifs-for-older-versions-of-excel-help-minifs-function-for-older-versions-help
Sheet: Sheet1

Group | Team | Score | Min of Group and team
1 | Ault | 7 | 4 | << Need a formula to find Min of Same group and Team
1 | Church | 6 | 6 | <Same group and team as row 5
1 | Ault | 4 | 4 | << Same group and team as row 2
1 | Church | 7 | 6
2 | Ault | 6 | 6
2 | Church | 5 | 5
2 | Ault | 7 | 6
2 | Church | 6 | 5
3 | Ault | 7 | 5
3 | Church | 6 | 3
3 | Ault | 5 | 5
3 | Church | 3 | 3
4 | Ault | 3 | etc
4 | Church | 4
4 | Ault | 5
4 | Church | 3
5 | Ault | 7
5 | Church | 5
5 | Ault | 4
5 | Church | 6
6 | Ault | 5
6 | Church | 7
6 | Ault | 6
6 | Church | 7
7 | Ault | 4
7 | Church | 7
7 | Ault | 5
7 | Church | 3
8 | Ault | 5
8 | Church | 3
8 | Ault | 6
8 | Church | 5
9 | Ault | 4
9 | Church | 5
9 | Ault | 5
9 | Church | 5
10 | Ault | 5
10 | Church | 3
10 | Ault | 6
10 | Church | 3
11 | Ault | 7
11 | Church | 5
11 | Ault | 3
11 | Church | 6
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: 773436d1647865501-countif-based-on-two-conditions-over-non-continuous-cells-test_new-1-
Sheet: Sheet1

Count | A | B | C | A | B | C | A | B | C
3 | 1 |  |  | 1 |  |  | 1
2 | 1 |  |  | 1 |  |  | 1 | z
3 | 1 |  |  | 1 | y |  | 1 | y
0 | 0 |  |  | 0 |  |  | 0
1 | 1 | z |  | 1 | z |  | 1
COUNTIF | Column: A > 0 AND column B is either blank OR equal to 'y'
 | The green cells are the ones COUNTED in each row.
Spreadsheet: 748190d1631950874-how-to-do-a-vlookup-in-a-conditional-situation-example-1-
Sheet: Sheet1

[NAME] | With Helper Columns | Direct Formula |  |  | Product barcode | Warehouse name | Warehouse inventory stocks | HC1 | HC2
APPLE |  |  |  |  | COCONUT | ISTANBUL | 4
BANANA |  |  |  |  | ORANGE | BERLIN | 3
ORANGE |  |  |  |  | BANANA | PARIS | 2
APPLE |  |  |  |  | APPLE | PARIS | 2
COCONUT |  |  |  |  | PEACH | MOSCOW | 2
PEACH |  |  |  |  | APPLE | MOSCOW | 1
APPLE |  |  |  |  | APPLE | LONDON | 1
AVOCADO |  |  |  |  | APPLE | BERLIN | 1
APPLE |  |  |  |  | AVOCADO | ISTANBUL | 1
APPLE
APPLE
APPLE
 | So I want to use vlookup on the blue colored column. My purpose is draw values(warehouse names from 2nd table) with vlookup. But vlookup only take first values when the product barcode is duplicate. So as it in the example APPLE product only takes PARIS warehouse but PARIS inventory has only 2 APPLE product. If paris gives 2 of their stock there wont be any stock for the 3rd apple. So what I want is vlookup(or other formula) bring stocks considering the available inventory stocks.                                                                                  It should be 3rd APPLE takes stock from MOSCOW. 4th one from LONDON and the 5th one take from BERLIN.
Spreadsheet: 1e1ed8d3-8841-44a0-b0ac-0cb0460a5284
Sheet: Sheet1

GIM India Itinerary
 | Su, 17th | M, 18th | T, 19th | W, 20th | R, 21st | F, 22nd | Sa, 23rd
City | N/A | Chicago | Mumbai | Mumbai | Mumbai | Mumbai | Mumbai/Goa
Flights | N/A | D: ORD, 14:30 | A: BOM, 19:00 |  |  |  | D: BOM, 12:00; A: GOI, 13:00
 | Su, 24th | M, 25th | T, 26th | W, 27th | R, 28th | F, 29th | Sa, 30th
City | Goa | Goa/Bangalore | Bangalore | Bangalore/Delhi | Delhi | Delhi | Delhi
Flights |  | D: GOI, 15:10; A: BLR, 16:10 |  | D: BLR, 16:30; A: DEL, 19:10
 | Su, 31st
City | Delhi
Flights | D: DEL, 2:00; A: ORD, 7:30
Spreadsheet: 328348d1403876654-formula-to-add-up-totals-from-lots-of-worksheets-testings
Sheet: sheet7

 |  |  | Item | Date of PAT Test | [NAME] |  | [NAME] key
 |  |  | 1 | TBA |  |  | Test Due
 |  |  | 1 | 2013-10-03 00:00:00 | 2017-10-03 00:00:00 |  | Test in 30 days
 |  |  | 1 | TBA
 |  |  | 1 | TBA
 |  |  | 1 | TBA
 |  |  | 1 | 2013-10-03 00:00:00 | 2014-10-03 00:00:00
 |  |  | 1 | TBA
 |  |  | 1 | TBA
 |  |  | 1 |  | 2013-06-18 00:00:00
 |  |  | In need of first test:
 |  |  | Overdue for PAT test:
 |  |  | Total
Spreadsheet: 877146d1723818710-calculate-age-group-from-date-of-birth-example-for-age-group
Sheet: Sheet1

Name | BoD | Age Group |  |  |  | Age Group | From | To | 2024-09-01 00:00:00
[NAME] | 2000-01-01 00:00:00 |  |  |  |  | U11 |  | 2013-09-01 00:00:00
[NAME] | 2011-09-05 00:00:00 |  |  |  |  | U13 | 2011-09-01 00:00:00 | 2013-08-31 00:00:00
[NAME] | 2013-07-31 00:00:00 |  |  |  |  | U15 | 2009-09-01 00:00:00 | 2011-08-31 00:00:00
[NAME] | 2015-01-28 00:00:00 |  |  |  |  | U17 | 2007-09-01 00:00:00 | 2009-08-31 00:00:00
[NAME] | 2011-12-15 00:00:00 |  |  |  |  | U20 | 2005-09-01 00:00:00 | 2007-08-31 00:00:00
[NAME] | 2013-09-08 00:00:00 |  |  |  |  | Senior | 2004-12-31 00:00:00
Michelle | 2007-12-15 00:00:00
 |  |  |  |  |  | Age Group | Number of
 |  |  |  |  |  | U11
 |  |  |  |  |  | U13
 |  |  |  |  |  | U15
 |  |  |  |  |  | U17
 |  |  |  |  |  | U20
 |  |  |  |  |  | Senior
Spreadsheet: 235150d1368378681-filtering-an-excel-calendar-multiple-entires-per-cell-calendar_solution2
Sheet: Schedule

 | Start | End | Region | Name
 | 2011-07-25 00:00:00 | 2011-07-29 00:00:00 | W | Event 1
 | 2011-07-29 00:00:00 | 2011-08-03 00:00:00 | W | Event 2
 | 2011-07-30 00:00:00 | 2011-08-02 00:00:00 | W | Event 3
 | 2011-07-26 00:00:00 | 2011-07-28 00:00:00 | E | Event Summer
 | 2011-07-27 00:00:00 | 2011-07-30 00:00:00 | C | Event A
Spreadsheet: 0db3ef07-ebb1-4517-a4da-09e013e53f25
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 7. LEASE AND COMMERCIAL FINANCE COMMITMENTS, Stocks and Flows: 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
Lease Finance - Total commitments ; |  |  | Original | A2413496R | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Lease Finance - Commitments not drawn at end of month ; |  |  | Original | A2413497T | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Revolving Credit - New and increased credit limits ; |  |  | Original | A2413498V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Revolving Credit - Cancellations and reductions ; |  |  | Original | A2413499W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Revolving Credit - Total credit limits at end of month ; |  |  | Original | A2413500V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Revolving Credit - Credit used at end of month ; |  |  | Original | A2413501W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 800919d1665996370-formala-for-pulling-values-from-another-sheet-where-multiple-vlookup-search-results-exist-booking-sample-4
Sheet: Bookings

 |  |  |  | not to be pulled in to job sheets |  |  | not to be pulled in to job sheets
 | Date | Name | Address | City | Booking | Time | Price | Booking order 1 | Booking order 2 | Booking order 3
 | 2022-10-01 00:00:00 | George | 1 street, parkway | Sydney | 45 | 2:00pm - 3:00pm | 10 | Table
 | 2022-10-01 00:00:00 | [NAME] | 5 big road, city | London | 56 | 10:00am - 4:00pm | 40 | Drum | Knife
 | 2022-10-01 00:00:00 | Adam | 6 rideway close, sydney | Amsterdam | 44 | 4:00pm - 4:00am | 500 | Chair | Table | Stand
 | 2022-10-08 00:00:00 | Wilfred | 33 Hay Street, Melbourne | Melbourne | 34 | 3:00am - 9:00pm | 555 | Wire | Chair | Mic
 | 2022-10-08 00:00:00 | [NAME] | 2 Queens close, Reading | Reading | 56 | 12:00pm - 4:00pm | 24 | Remote | Fork | Spoon
Spreadsheet: 728253d1618393140-rotation-shift-rotation-schedule-multiple-employees
Sheet: DaysOff

Days Off: Vacation, Sick Leave, Personal Leave
Date | Employee | Type | Lookup Value |  | V = Vacation
2018-01-15 00:00:00 | Employee 1 | V |  |  | S = Sick Leave
2018-10-26 00:00:00 | Employee 2 | V |  |  | P = Personal Leave
2018-01-16 00:00:00 | Employee 1 | S
2018-01-17 00:00:00 | Employee 1 | P
 |  |  |  | ◄ Insert more rows ABOVE this one
Spreadsheet: 699912d1602824362-google-sheets-issue-with-vlookup-error-copy-of-template-for-clients
Sheet: Client Results

CLIENT NUMBER
 |  |  | Hours of Sleep | Sleep Quality |  | Calories Consumed | Serves of Protein | Serves of Vegetables | Water Consumption | Supplements | Type | Train Today | Type of Training | Level of Performance |  | Step Count | Level of Stress
Spreadsheet: 220534dd-e8ef-4483-9bbe-0c038687242e
Sheet: Data-Kelompok

 | KELOMPOK KERJA (KKG/MGMP)
 | [NAME] |  | :
 | Alamat [NAME] |  | :
 | [NAME] |  | :
 | [NAME] |  | :
 | Provinsi |  | :
 | No | Nama | NIP |  | [NAME] | [NAME] | NUPTK | Agama | email | Pendidikan | [NAME] | Bidang Studi | [NAME] | Alamat
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50