tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 8a2daca1-b70a-4475-9469-cf2d8bf9459c
Sheet: Sheet5

Reason Codes |  |  |  |  |  |  |  |  | Child Person ID |  | Days in home
1 | Travel between the foster home and school, to the extent that school transportation is not provided.
2 | Travel to physical or behavioral health appointments.
3 | Travel for administrative case or judicial review, team meetings, foster parent training or visitations.
4 | Travel for Headstart, summer school, pre-school, summer camp or driver's education class.
5 | Travel for youth sixteen (16) year and older to and from employment or searching for job.
6 | Other: Must be authorized by Department and must have prior Local Office Director approval before
 | the trip, please attach authorization.
Month of Travel
Date | Starting Address (number and street, city, state and ZIP code): |  |  |  | Destination Address (number and street, city, state and ZIP code): |  |  |  |  | Reason Code | [NAME]
Pursuant to the provision and penalties of Indiana Code 5-11-10-1, I hereby certify that the foregoing invoice is just and correct, that the amount claimed is legally due, after allowing all just credits, and that no part of the same has been paid. |  |  |  |  |  |  |  |  | Total Miles Driven Sheet 5
I hereby swear and affirm under the penalties of perjury the attached bill contains the actual travel costs provided for the individual(s) listed on such bill.  The dates, destinations, reasons and mileage for travel are true and accurate.  I understand that in submitting this that I am under oath stating and affirming that this travel was provided and fully understand that this may be independently audited and that any discrepancy may be referred to a local prosecutor for criminal prosecution.
[NAME] |  |  |  |  | Foster Family Address (number and street, city, state and ZIP code)
Foster Family Email Address |  |  |  |  | [NAME] Number |  |  |  | [NAME] Number
[NAME] |  |  |  |  | Foster Family Telephone Number |  |  |  | Date of Signature (month, day, year)
Spreadsheet: 155181d1336698482-data-format-coversion-td_sample
Sheet: Sheet2

TemplateType=Offer | Version=1.4
[NAME] | price | quantity | product-id | product-id-type | condition-type | condition-note | ASIN-hint | title | product-tax-code | operation-type | sale-price | sale-start-date | sale-end-date | leadtime-to-ship | launch-date | is-giftwrap-available | is-gift-message-available
Spreadsheet: 858759d1707324005-count-number-of-different-groups-of-values-in-a-column-count_test
Sheet: Sheet1

 | Site1 | Site2 | Site3 | [NAME] | Site5 |  |  | Stock days | Site 1 | Site 2 | Site 3 | Site 4 | Site 5
2020-12-31 00:00:00 |  |  |  |  |  |  |  | 1
2023-01-01 00:00:00 | 8 | 0 | 15 | 0 | 0 |  |  | 2
2023-01-02 00:00:00 | 8 | 0 | 15 | 0 | 0 |  |  | 3
2023-01-03 00:00:00 | 8 | 0 | 15 | 0 | 0 |  |  | 4
2023-01-04 00:00:00 | 8 | 0 | 15 | 0 | 0 |  |  | 5
2023-01-05 00:00:00 | 7 | 0 | 15 | 0 | 0 |  |  | 6
2023-01-06 00:00:00 | 7 | 0 | 15 | 0 | 0 |  |  | 7
2023-01-07 00:00:00 | 7 | 0 | 15 | 0 | 0 |  |  | 8
2023-01-08 00:00:00 | 7 | 0 | 15 | 0 | 0 |  |  | 9
2023-01-09 00:00:00 | 7 | 0 | 15 | 0 | 0 |  |  | 10
2023-01-10 00:00:00 | 7 | 0 | 15 | 0 | 0 |  |  | 11
2023-01-11 00:00:00 | 7 | 0 | 15 | 0 | 0 |  |  | 12
2023-01-12 00:00:00 | 7 | 0 | 10 | 0 | 0 |  |  | 13
2023-01-13 00:00:00 | 7 | 0 | 10 | 0 | 0 |  |  | 14
2023-01-14 00:00:00 | 7 | 0 | 10 | 0 | 0 |  |  | 15
2023-01-15 00:00:00 | 7 | 0 | 10 | 0 | 0 |  |  | 16
2023-01-16 00:00:00 | 7 | 0 | 10 | 0 | 0 |  |  | 17
2023-01-17 00:00:00 | 7 | 0 | 12 | 0 | 0 |  |  | 18
2023-01-18 00:00:00 | 7 | 0 | 12 | 0 | 0
2023-01-19 00:00:00 | 7 | 0 | 12 | 0 | 0
Spreadsheet: 870251d1716799075-add-a-row-before-a-group-of-values-book1-gk-v2-1-
Sheet: Sheet2

 |  |  |  |  | 6 | This is the output of customized formula provided by @GK |  |  |  |  |  |  |  |  | Add Empty Row before |  | x | y | If this output is achieved, then row will be added as required
 | Region | Employee | Product |  |  | EMP Sub Total (Region-1) | 6 | 0.3333333333333333 | 0.5 | 0 | 0.1666666666666667 | 0 | 0 |  |  | Region-1 | 0 |  | 0.8
 | Region-1 | EMP-1 | PRO-1 |  | 10.5 | EMP Sub Total (Region-2) | 4 | 0 | 0.5 | 0.5 | 0 | 0 | 0 |  | 7 | [NAME] |  |  | 6.8
 | Region-1 | EMP-2 | PRO-2 |  | 14.5 | EMP Sub Total (Region-3) | 4 | 0 | 0.5 | 0.5 | 0 | 0 | 0 |  | 11 | Region-3 |  |  | 10.8
 | Region-1 | EMP-3 | PRO-4 |  | 18.5 | EMP Sub Total (Region-4) | 4 | 0.25 | 0.25 | 0.5 | 0 | 0 | 0 |  | 15 | Region-4 |  |  | 14.8
 | Region-1 | EMP-4 | PRO-2 |  | 21.5 | EMP Sub Total (Region-5) | 3 | 0.3333333333333333 | 0 | 0.6666666666666666 | 0 | 0 | 0 |  | 19 | Region-5 |  |  | 18.8
 | Region-1 | EMP-5 | PRO-1 |  | 29.5 | EMP Sub Total (Region-6) | 8 | 0.375 | 0 | 0.625 | 0 | 0 | 0 |  | 22 | Region-6 |  |  | 21.8
 | Region-1 | [NAME] | PRO-2 |  | 30.5 | EMP Sub Total (Region-7) | 1 | 1 | 0 | 0 | 0 | 0 | 0 |  | 30 | [NAME] |  |  | 29.8
 | [NAME] | EMP-1 | PRO-3
 | [NAME] | EMP-2 | PRO-2 |  |  |  |  |  |  |  |  |  |  |  |  | Following formula is used to add row after each group.
 | [NAME] | EMP-3 | PRO-3 |  |  |  |  |  |  |  |  |  |  |  |  | SCAN(0,G,LAMBDA(x,y,x+y))+0.5,
 | [NAME] | EMP-4 | PRO-2
 | Region-3 | EMP-1 | PRO-3
 | Region-3 | EMP-2 | PRO-2
 | Region-3 | EMP-3 | PRO-3
 | Region-3 | EMP-4 | PRO-2
 | Region-4 | EMP-1 | PRO-3 |  |  | Regions | Title
 | Region-4 | EMP-2 | PRO-1 |  |  | Region-1 | Middle East - 1
 | Region-4 | EMP-3 | PRO-3 |  |  | [NAME] | Euopue
 | Region-4 | EMP-4 | PRO-2 |  |  | Region-3 | South Asia
 | Region-5 | EMP-1 | PRO-1 |  |  | Region-4 | Middle East - 2
 | Region-5 | EMP-2 | PRO-3 |  |  | Region-5 | North America
 | Region-5 | EMP-3 | PRO-3 |  |  | Region-6 | China
 | Region-6 | EMP-1 | PRO-1 |  |  | [NAME] | ABC
 | Region-6 | EMP-2 | PRO-3
 | Region-6 | EMP-3 | PRO-3
 | Region-6 | EMP-4 | PRO-1
 | Region-6 | EMP-5 | PRO-3
 | Region-6 | [NAME] | PRO-1
 | Region-6 | EMP-7 | PRO-3
 | Region-6 | EMP-8 | PRO-3
 | [NAME] | EMP-1 | PRO-1
Spreadsheet: 867032d1713943757-populate-sheet-with-specific-data-from-a-different-sheet-test-report
Sheet: Data

Sprint | Issue Number | Summary | Points |  |  | Sprint 1 | Sprint 1 | Sprint 1 | Sprint 2 | Sprint 2 | Sprint 2 | Sprint 3 | Sprint 3 | Sprint 3 | Sprint 4 | Sprint 4 | Sprint 4
Sprint 1 | 1 | Work Summary 1 | 1
Sprint 1 | 2 | Work Summary 2 | 1
Sprint 1 | 3 | Work Summary 3 | 2
Sprint 2 | 4 | Work Summary 4 | 2
Sprint 2 | 5 | Work Summary 5 | 3
Sprint 3 | 6 | Work Summary 6 | 1
Sprint 3 | 7 | Work Summary 7 | 3
Sprint 3 | 8 | Work Summary 8 | 2
Sprint 4 | 9 | Work Summary 9 | 1
Sprint 4 | 10 | Work Summary 10 | 2
Spreadsheet: 847195d1698239384-how-to-visualize-two-separate-tables-pq-book1-222-aligw
Sheet: Dashboard

Preferably 1 slicer. Example from the right, I would have selected [NAME], [NAME] and [NAME] from the slicer.
 |  |  |  |  |  |  | Name | Fruit | Quantity | Age | Car
 |  |  |  |  |  |  | [NAME] | [NAME] | 4 | 21 | Ford
 |  |  |  |  |  |  | Mark | Orange | 1 | 34 | Vauxhall
 |  |  |  |  |  |  | [NAME] | Apple | 2 | 52 | Citron
 |  |  |  |  |  |  | [NAME] | Pear | 3 | 63 | Toyota
 |  |  |  |  |  |  | [NAME] |  |  | 12 | Toy
 |  |  |  |  |  |  | [NAME] | Pear | 2
Spreadsheet: 694911d1599890029-how-to-add-the-maximum-number-of-different-products-in-merged-cells-sample0912
Sheet: Sheet3

DATE | product | Inbound quantity
 | rearview mirror | 154 |  |  | 1302 | The sum of the maximum number of products in a single storage
 |  | 276 |  |  |  | F2 =MAX(C2:C3)+MAX(C4:C6)+MAX(C7:C12)+MAX(C13)+MAX(C14:C16)+MAX(C17:C18)
 | Tires | 103
 |  | 120
 |  | 134
 | steering wheel | 168
 |  | 179
 |  | 212
 |  | 221
 |  | 270
 |  | 103
 | Seat | 92
 | RADIATOR | 176
 |  | 244
 |  | 262
 | GEAR BOX | 78
 |  | 268
Spreadsheet: darrell_schoolcraft__7585__imball0112
Sheet: WTG inc

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -316 | -260
2 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -544 | -260
3 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -307 | -260
4 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -634 | -260
5 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -440 | -260
6 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -143 | -260
7 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -372 | -260
8 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -1467 | -260
9 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -54 | -260
10 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -671 | -260
11 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -1814 | -260
12 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -1 | -260
13 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -300 | -260
14 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -490 | -319
15 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -328 | -319
16 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -608 | -319
17 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -927 | -319
18 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -456 | -319
19 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -586 | -319
20 | -9 | -9 | -1 | -1 | -19 | -19 | 0 | 0 | -3 | -3 | -691 | -23
21 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -717 | -1109
22 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -664 | -1109
23 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -663 | -1109
24 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -692 | -1109
25 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -541 | -1109
26 |  |  |  |  |  |  |  |  |  |  | -887 | -1109
27 |  |  |  |  |  |  |  |  |  |  | -729 | -1109
28 |  |  |  |  |  |  |  |  |  |  | -687 | -1109
29 |  |  |  |  |  |  |  |  |  |  | -1639 | -1109
30
31
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 28367.49
2001-12-29 00:00:00
CBS Volume
 |  |  | 10205
Spreadsheet: 121405d1316030740-multiple-vlookups-sample
Sheet: Sheet2

Example 1 |  |  |  |  |  |  | Example 2
AAA | 01 | 500 | 1 | 22 |  |  | AAA | 01 | 500 | 1 | 22
AAA | 02 | 600 | 2 | 23 |  |  | AAA | 02 | 600 | 2 | 23
AAB | 55 | 9001 | 3 | 24 |  |  | AAB | 55 | 9001 | 3 | 24
AAB | 57 | 66 | 4 | 25 |  |  | AAB | 57 | 66 | 4 | 25
AAC | 22 | 3331 | 5 | 26 |  |  | AAC | 22 | 3331 | 5 | 26
AAC | 66 | 55 | 6 | 27 |  |  | AAC | 66 | 55 | 6 | 27
ABA | 22 | 168 | 7 | 28 |  |  | ABA | 22 | 168 | 7 | 28
ABB | 22 | 564 | 8 | 29 |  |  | ABB | 22 | 564 | 8 | 29
ABC | 66 | 156 | 9 | 30 |  |  | ABC | 66 | 156 | 9 | 30
ABC | 01 | 666 | 10 | 31 |  |  | ABC | 01 | 0 | 10 | 31
ABC | 02 | 999 | 12 | 32 |  |  | ABC | 02 | 999 | 12 | 32
ACA | 99 | 6012 | 13 | 33 |  |  | ACA | 99 | 6012 | 13 | 33
ACA | 44 | 65468 | 14 | 34 |  |  | ACA | 44 | 65468 | 14 | 34
ACB | 55 | 36584 | 15 | 35 |  |  | ACB | 55 | 36584 | 15 | 35
ACC | 33 | 3521 | 16 | 36 |  |  | ACC | 33 | 3521 | 16 | 36
Spreadsheet: 484022d1476081055-returning-multiple-instances-with-hyperlinks-that-work-stringsearchtool2
Sheet: Topics

INDEX | Hyperlink | Key
MY CATS AGE | #Data!catsage
MY CATS NAME | #Data!catsname
MY DOGS NAME | #Data!dogsname
MY DOGS AGE | #Data!dogsage
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 41

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
41 | 2007-02-16 00:00:00 | 7.4 | 3.66 | 16.2 | 6.3 | 15.8 | 4 |  |  |  | 30 |  | 6.661864937421386 | 6.2 | 0 | 18 |  |  |  |  | 0.6
Well 41 | 2012-09-18 00:00:00 | 8 | 2.94 | 9.76 | 3.94 | 12.6 | 5.3 |  |  | 3.3 | 20.5 |  | 4.8 | 12.4 | 0.05 | 8.8 |  | <0.10 | <0.02 |  | 1.2
Well 41 | 2015-03-24 00:00:00 | 7.7 | 2.74 | 9.33 | 3.78 | 13.3 | 5.7 |  |  | 3.5 | 19.2 |  | 5.2 | 13.5 | 0.05 | 6.4 |  | <0.10 | <0.02 |  | 0.9
Well 41 | 2016-04-01 00:00:00 | 7.9 | 2.837 | 9.799999999999999 | 3.99 | 14.3 | 5.491167772360323 | 5.491167772360323 | 0 | 3.46 | 18.2 | 1817.6 | 5.45 | 13.36 | 0.027 | 9.4451 | 0.021 | 0.16 | 0.009 | 0.242
W41 | 2018-05-30 00:00:00 | 7.69 | 3.484 | 13.6 | 5.58 | 16.1 |  | 5.4951642554552 | 0 | 3.62 | 22.982 | 2229 |  |  | 0.054 | 11.15 | 0.066 | 0 | 0 | 0.015
Spreadsheet: 150631d1334629268-if-cell-text-add-next-cell-if-not-do-not-add-dota-2-log
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average
Date | Hero | Primary | End LvL | Kill | Death | Assist | CS | Deny | W/L |  | Hero | Primary | Games | W | L | Kills | Deaths | Assists | CS | Deny |  | Kill | Death | Assists | CS | Deny | End LvL
2012-04-16 00:00:00 | Bloodseeker | Agi | 18 | 4 | 1 | 7 | 150 | 13 | L |  | Bloodseeker | Agi
2012-04-16 00:00:00 | Dragon Knight | Str | 15 | 2 | 6 | 10 | 81 | 16 | L |  | Dragon Knight | Str
Spreadsheet: 32941d1229101619-excel-2007-trouble-with-max-on-pivot-tables-badmax
Sheet: Data

 |  | Scope.Name | Initiative | Children.Scope.BeginDate.@MaxDate
 |  | Top Label 1 | Verticals | 2008-08-30 00:00:00
 |  | Top Label 1 | Global | 2008-06-09 00:00:00
 |  | Top Label 1 | Global | 2008-06-16 00:00:00
 |  | Top Label 1 | Global | 2008-10-31 00:00:00
 |  | Top Label 1 | Global | 2008-08-30 00:00:00
 |  | Top Label 1 | On-going | 2008-06-09 00:00:00
 |  | Top Label 1 | Hosting | 2008-06-09 00:00:00
 |  | Top Label 1 | Serviceability | 2008-06-09 00:00:00
 |  | Top Label 1 | Productivity | 2008-06-09 00:00:00
 |  | Top Label 1 | Verticals | 2008-06-09 00:00:00
 |  | Top Label 1 | Verticals
 |  | Top Label 1 | Hosting
 |  | Top Label 1 | Productivity
 |  | Top Label 1 | Global
 |  | Top Label 1 | Global | 2008-10-23 00:00:00
 |  | Top Label 1 | On-going
 |  | Top Label 1 | Serviceability | 2008-08-19 00:00:00
 |  | Top Label 2 | Serviceability
 |  | Top Label 2 | Verticals | 2008-06-30 00:00:00
 |  | Top Label 2 | [NAME]. work | 2008-11-01 00:00:00
 |  | Top Label 2 | Global | 2008-08-19 00:00:00
Spreadsheet: 149385d1333908998-counting-how-many-times-names-appear-in-a-worksheet-sample-client-log-for-excel-forum
Sheet: Sheet 1

 | Client/Relationship | Date | Type of contact | Location | Purpose | [NAME] | Departure Time | Hours Worked
16 | [NAME] | 2012-03-02 00:00:00 | Face to face | 53 |  | 15:30:00 | 17:30:00 | 1.999999999999998
17 | [NAME] | 2012-03-05 00:00:00 | Face to face | 53 |  | 12:45:00 | 15:45:00 | 3
5 | [NAME] | 2012-03-05 00:00:00 | Face to face | 51 |  | 21:00:00 | 1900-01-01 00:00:00 | 3
13 | [NAME] | 2012-03-05 00:00:00 | Face to face | 53 |  | 14:30:00 | 17:30:00 | 3
12 | [NAME] | 2012-03-05 00:00:00 | Face to face | 51 |  | 18:00:00 | 21:00:00 | 3
8 | [NAME] | 2012-03-07 00:00:00 | Face to face | 53 |  | 15:30:00 | 17:30:00 | 1.999999999999998
20 | [NAME] | 2012-03-07 00:00:00 | Face to face | 53 |  | 11:00:00 | 14:00:00 | 3.000000000000001
9 | Vincenzo [NAME] | 2012-03-07 00:00:00 | Face to face | 53 |  | 15:00:00 | 15:30:00 | 0.5000000000000009
18 | [NAME] | 2012-03-12 00:00:00 | Face to face | 53 |  | 11:00:00 | 12:00:00 | 1
3 | [NAME] | 2012-03-12 00:00:00 | Face to face | 53 |  | 15:00:00 | 16:00:00 | 0.9999999999999991
6 | [NAME] | 2012-03-14 00:00:00 | Face to face | 53 |  | 15:00:00 | 16:30:00 | 1.5
7 | [NAME] | 2012-03-14 00:00:00 | Face to face | 53 |  | 16:30:00 | 18:00:00 | 1.5
10 | [NAME] | 2012-03-14 00:00:00 | Face to face | 51 |  | 10:45:00 | 12:45:00 | 2
11 | [NAME] | 2012-03-14 00:00:00 | Face to face | 53 |  | 13:00:00 | 14:00:00 | 1.000000000000002
4 | [NAME] | 2012-03-15 00:00:00 | Face to face | 53 |  | 13:30:00 | 16:30:00 | 3
1 | [NAME] | 2012-03-15 00:00:00 | Face to face | 53 |  | 10:45:00 | 11:45:00 | 0.9999999999999991
2 | [NAME] | 2012-03-15 00:00:00 | Face to face | 53 |  | 11:45:00 | 13:45:00 | 2
14 | [NAME] | 2012-03-19 00:00:00 | Face to face | 51 |  | 13:45:00 | 15:45:00 | 2.000000000000001
15 | [NAME] | 2012-03-19 00:00:00 | Face to face | 53 |  | 17:45:00 | 18:45:00 | 0.9999999999999991
19 | [NAME] | 2012-03-19 00:00:00 | Face to face | 53 |  | 12:30:00 | 14:00:00 | 1.5
21 |  |  |  |  |  |  |  | 0
22 |  |  |  |  |  |  |  | 0
23 |  |  |  |  |  |  |  | 0
24 |  |  |  |  |  |  |  | 0
25 |  |  |  |  |  |  |  | 0
26 |  |  |  |  |  |  |  | 0
27 |  |  |  |  |  |  |  | 0
28 |  |  |  |  |  |  |  | 0
29 |  |  |  |  |  |  |  | 0
30 |  |  |  |  |  |  |  | 0
31 |  |  |  |  |  |  |  | 0
32 |  |  |  |  |  |  |  | 0
33 |  |  |  |  |  |  |  | 0
34 |  |  |  |  |  |  |  | 0
35 |  |  |  |  |  |  |  | 0
36 |  |  |  |  |  |  |  | 0
37 |  |  |  |  |  |  |  | 0
38 |  |  |  |  |  |  |  | 0
39 |  |  |  |  |  |  |  | 0
40 |  |  |  |  |  |  |  | 0
41 |  |  |  |  |  |  |  | 0
42 |  |  |  |  |  |  |  | 0
43 |  |  |  |  |  |  |  | 0
44 |  |  |  |  |  |  |  | 0
45 |  |  |  |  |  |  |  | 0
46 |  |  |  |  |  |  |  | 0
47 |  |  |  |  |  |  |  | 0
48 |  |  |  |  |  |  |  | 0
49 |  |  |  |  |  |  |  | 0
50 |  |  |  |  |  |  |  | 0
51 |  |  |  |  |  |  |  | 0
52 |  |  |  |  |  |  |  | 0
53 |  |  |  |  |  |  |  | 0
54 |  |  |  |  |  |  |  | 0
55 |  |  |  |  |  |  |  | 0
56 |  |  |  |  |  |  |  | 0
57 |  |  |  |  |  |  |  | 0
58 |  |  |  |  |  |  |  | 0
59 |  |  |  |  |  |  |  | 0
60 |  |  |  |  |  |  |  | 0
Spreadsheet: 1bc791d2-4957-44e7-a0c7-2207f49e7218
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
 | 8501.0 Retail Trade, Australia
 | TABLE 16. Retail Turnover, Completely Enumerated sector: Australia
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
Turnover ;  Total CE and [NAME] ; |  |  | Original | [NAME] | 1994-04-01 00:00:00 | 2012-02-01 00:00:00 | 215 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350334L | 1994-04-01 00:00:00 | 2012-02-01 00:00:00 | 215 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Trend | A3350340J | 1994-04-01 00:00:00 | 2012-02-01 00:00:00 | 215 | $ Millions | FLOW | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Original | A3350329V | 1994-04-01 00:00:00 | 2012-02-01 00:00:00 | 215 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350335R | 1994-04-01 00:00:00 | 2012-02-01 00:00:00 | 215 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Trend | A3350341K | 1994-04-01 00:00:00 | 2012-02-01 00:00:00 | 215 | Percent | PERCENT | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 36f53d54-c447-4dd4-bb3c-24c915386740
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
40204297 | 2014-02-23 22:14:25 | AXIS | 0 | 7 | 10 | 509176 | arsenal94 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40205931 | 2014-02-23 23:27:06 | ALLIES | 0 | 7 | 10 | 509176 | arsenal94 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 800631d1665763922-special-issue-if-functions-and-display-splits-book1
Sheet: Sheet1

class | type | cell type | stimuli | concentration | value | … |  | manual | formular |  |  | display cell x if y and z = TRUE
a | 1 | M1 | B | 0.5 | 50 |  |  | =D2/D26 |  |  | 1 |  |  | here I want to have type 1 in conc 0.5 of cell type M1 with stimuli B
a | 1 | M1 | B | 5 | 23 |  |  | =D3/D26 |  |  | 1 |  |  | here I want to havethe next value of  type 1 in conc 0.5 of cell type M1 with stimuli B
a | 2 | M1 | B | 0.5 | 98 |  |  |  |  |  | 1 |  |  | here I want to havethe next value of  type 1 in conc 0.5 of cell type M1 with stimuli B
a | 2 | M1 | B | 5 | 43 |  |  |  |  |  | 1 |  |  | and so on, until all types of type, cell type, stimuli, concentration is listed
b | 3 | M1 | X | 0.5 | 54 |  |  | =D6/D27 |  |  | 2
b | 3 | M1 | X | 5 | 23 |  |  |  | 0.7105263157894737 |  | 2
b | 4 | M1 | X | 0.5 | 65 |  |  |  | #[NAME]! |  | 2
c | 1 | M2 | C | 0.5 | 54 |  |  |  | #[NAME]! |  | 2
c | 1 | M2 | C | 5 | 76 |  |  |  | #[NAME]!
c | 2 | M2 | C | 0.5 | 54
c | 2 | M2 | C | 5 | 34
d | 1 | M1 | B | 0.5 | 87
d | 1 | M1 | B | 5 | 34
d | 2 | M1 | A | 0.5 | 65
e | 1 | M1 | C | 0.5 | 23
e | 1 | M1 | C | 5 | 56
e | 2 | M2 | A | 0.5 | 34 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
a | base |  |  |  | 54 |  |  |  |  |  |  | 0
b | base |  |  |  | 76 |  |  |  |  |  |  | 0
c | base |  |  |  | 89 |  |  |  |  |  |  | 0
d | base |  |  |  | 23 |  |  |  |  |  |  | 0
e | base |  |  |  | 65 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 827565d1682838954-confused-using-countif-s-across-multiple-worksheets-with-drop-down-menus-fy-23-icass-count-2023-2024-1-
Sheet: FY23 Workload

ICASS WORKLOAD COUNTS |  |  |  |  |  |  |  | Sheets
 |  |  |  |  |  |  |  | May 23
FISCAL YEAR:   2023
POST CODE:     240 GERMANY
 |  |  | Prepared by (please provide section, name and date)
[NAME] (see below & tab 2 & 3 for further guidance*): |  |  | (Please enter location here)
COST CENTER: |  |  | (Please enter cost center here)
AGENCY CODE | AGENCY NAME | WORKLOAD | AGENCY CODE | AGENCY NAME | WORKLOAD
1150 |  |  | 2117
1156 |  |  | 2121.1
1205 |  |  | 2122.5
1235 |  |  | 2144.9
1302 |  |  | 2150
1330 |  |  | 2800
1510 |  |  | 3100
1525 |  |  | 3600
1712 |  |  | 4700
1754.1 |  |  | 5705
1900 |  |  | 5713
1901 |  |  | 5718
1904.1 |  |  | 5725
1904.2 |  |  | 5741
1904.8 |  |  | 7004
1905.1 |  |  | 7005.1
1920 |  |  | 7020
1920.2 |  |  | 7023
1927.1 |  |  | 7024
1929.1 |  |  | 7025
1931 |  |  | 7203.1
1932.9 |  |  | 7203.2
1939 |  |  | 7210
1939.1 |  |  | 8900
1939.2 |  |  | 9568.2
1939.5 |  |  | 9568.3
1942 |  |  | 9700.3
1947.2 |  |  | 9705
1954 |  |  | 9705.1
1967 |  |  | 9705.2
1981 |  |  | 9715
1984 |  |  | 9733
2025 |  |  | 9782
2105.2 |  |  | 9993.2
2111.1 |  |  | 9993.3
2112.1
SUBTOTAL |  | 0 | SUBTOTAL |  | 0
 |  |  |  | GRAND TOTAL COUNT | 0
Agencies
1150 DSCA - Defense Security Cooperation Agency
1150.0 DSCA - Defense Security Cooperation Agency
1235  AG - FAS (Foreign Agricultural Service)
1235.0 AG - FAS (Foreign Agricultural Service)
1330  DOC - ITA - Global Markets
1330.0 DOC - ITA - Global Markets
1525  DOJ - FBI - LEGATT, [NAME]
1525.0 DOJ - FBI - LEGATT, [NAME]
1900  STATE - DP (DIPLOMATIC PROGRAMS)
1900.0 STATE - DP (DIPLOMATIC PROGRAMS)
1901   STATE - ICASS
1901.0 STATE - ICASS
1920   STATE - OBO - CONSTRUCTION PROJECTS
1920.0 STATE - OBO - CONSTRUCTION PROJECTS
Spreadsheet: 270354d1381444385-return-value-based-on-2-dependent-drop-down-lists-equipment-and-cost-estimate
Sheet: Reference

Size | Description | Price | Price | Price | Price | Price |  | cost | =OFFSET('Piping and Fitting'!$C$3,0,0,COUNTA('Piping and Fitting'!$C$3:$C$1000))
 |  |  |  |  |  |  |  | description
 |  |  |  |  |  |  |  | material_description | =OFFSET('Piping and Fitting'!$B$3,0,0,COUNTA('Piping and Fitting'!$B$3:$B$3:'Piping and Fitting'!$B$1000))
 |  |  |  |  |  |  |  | size
 |  |  |  |  |  |  |  | unique_description | =OFFSET(Reference!$B$2, 0, 0, COUNT(IF(Reference!$B$2:$B$1000="", "", 1)), 1)