tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 123846d1317899810-sum-values-based-on-operational-timetable-example
Sheet: Sheet2

 | 1900-01-01 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
Monday | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tuesday | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Wednesday | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Thursday | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Friday | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Saturday | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sunday | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 147705d1332938591-maintaining-a-cell-value-by-date-test-file
Sheet: Site

Accident Numbers | Month | YTD* |  | Training | Month | YTD*
Lost Time Injuries (LTI) |  |  |  | General [NAME] Training Hours
Restricted Work Cases (RWC) |  |  |  | Mandatory H&S Training
Medical Treatment Cases (MTC)
First Aid Cases (FAC)
Lost Days
Hazards/Near Miss Reported
Performance Ratios | Month | YTD* |  | Risk Assessment | Month | YTD*
Lost Time Injury Frequency Rate (LTIFR) |  |  |  | Risk Assessments Completed
Total Frequency Rate (TFR) |  |  |  | Risk Assessments Reviewed
Working Days Lost Per 100 Employees
Incident Severity Rate (ISR)
Average Incident Severity Rate (AISR)
Days | Month | Total |  | Behavioural Safety Observations | Month | YTD*
Days Since Last LTI |  |  |  | Managers
Date of Last LTI |  |  |  | Supervisors
 |  |  |  | Peer-to-Peer
Days Since Last RWC
Date of Last RWC
Framework Standards Audit | Month | YTD*
Last Full Audit Score
% Improvement
* Calendar year
Spreadsheet: 120103d1314979298-sorting-daily-ot-data-otcalculate
Sheet: Sheet1

Weekend | Client | SSN | Name | Hour Type | Rate | MONST | [NAME] | TUEST | TUEOT | WEDST | WEDOT | THUST | THUOT | FRIST | FRIOT | SATST | SATOT | SUNST | SUNOT | [NAME] | Trans1 | Csupport | EqpCloth | Others | Tot Hrs | [NAME] | Oth Hrs
 |  |  | emp1 |  |  | 0 |  | 0 |  | 0 |  | 9.83 |  | 10.33 |  | 0 |  | 0 |  |  |  |  |  |  | 20.16 | 20.16 | 0
2011-08-28 00:00:00 |  |  | emp2 |  |  | 3.11611 |  | 12.103333 |  | 21.106944 |  | 2.606944 |  | 12.685556 |  | 12.539721 |  | 0 |  |  |  |  |  |  | 64.158608 | 40 | 24.158608
 |  |  | emp3 |  |  | 0 |  | 0 |  | 0 |  | 10.5 |  | 10.15 |  | 4.213333 |  | 0 |  |  |  |  |  |  | 24.863333 | 24.863333 | 0
 |  |  | emp4 |  |  | 11 |  | 11.039721 |  | 11.003054 |  | 13.154722 |  | 9.887499 |  | 0 |  | 0 |  |  |  |  |  |  | 56.084996 | 40 | 16.084996
 |  |  | emp5 |  |  | 0 |  | 11.324166 |  | 9.236388 |  | 10.402498 |  | 8.52 |  | 0 |  | 0 |  |  |  |  |  |  | 39.483052 | 39.483052 | 0
 |  |  | emp6 |  |  | 11.6 |  | 10.803609 |  | 11.098333 |  | 12.405832 |  | 10.1 |  | 4.120555 |  | 10.542499 |  |  |  |  |  |  | 70.670828 | 40 | 30.670828
 |  |  | emp7 |  |  | 11.030277 |  | 11.005832 |  | 6.11 |  | 15.531388 |  | 10.192776 |  | 0 |  | 0 |  |  |  |  |  |  | 53.870273 | 40 | 13.870273
 |  |  | [NAME] |  |  | 3.120277 |  | 12.064445 |  | 12.262778 |  | 6.0975 |  | 11.855555 |  | 8.55 |  | 0 |  |  |  |  |  |  | 53.950555 | 40 | 13.950555
 |  |  | emp9 |  |  | 10.88 |  | 8.405554 |  | 11.993887 |  | 0 |  | 10.08722 |  | 0 |  | 0 |  |  |  |  |  |  | 41.366661 | 40 | 1.366661
 |  |  | emp10 |  |  | 11 | 0 | 11.230554 | 0 | 11.959443 | 0 | 5.81 | 5.86 | 0 | 10.1 | 0 | 0 | 0 | 0 |  |  |  |  |  | 55.954437 | 40 | 15.954437
 |  |  | emp11 |  |  | 0 |  | 8.193054 |  | 8.226109000000001 |  | 8.284999000000001 |  | 8.233332 |  | 5.234999 |  | 8.140276 |  |  |  |  |  |  | 46.312769 | 40 | 6.312768999999999
 |  |  | emp12 |  |  | 0 |  | 3.074444 |  | 12.009722 |  | 7.7975 |  | 10.740278 |  | 6.055277999999999 |  | 0 |  |  |  |  |  |  | 39.677222 | 39.677222 | 0
 |  |  | emp13 |  |  | 3.198888 |  | 12.000277 |  | 12.057222 |  | 11.934166 |  | 12.7975 |  | 11.894445 |  | 0 |  |  |  |  |  |  | 63.882498 | 40 | 23.882498
 |  |  | emp14 |  |  | 8.009722 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  | 8.009722 | 8.009722 | 0
 |  |  | emp15 |  |  | 0 |  | 0 |  | 0 |  | 11 |  | 10.1 |  | 4.106943999999999 |  | 10.221944 |  |  |  |  |  |  | 35.428888 | 35.428888 | 0
 |  |  | emp16 |  |  | 10.65 |  | 11.448333 |  | 12.840833 |  | 8.660555 |  | 10.244999 |  | 4.062777 |  | 0 |  |  |  |  |  |  | 57.90749700000001 | 40 | 17.907497
 |  |  | emp17 |  |  | 11.133055 |  | 11.344998 |  | 11.292498 |  | 11.227499 |  | 11.15111 |  | 0 |  | 0 |  |  |  |  |  |  | 56.14916 | 40 | 16.14916
Spreadsheet: c8717732-1324-4799-8c7f-b8873719bbea
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Construction Spending
 |  | Annual Rate for Total Construction: U.S. Total
 |  | Seasonally Adjusted Total Construction [Millions of Dollars]
 |  | Period: 2002 to 2013
 |  | Data Extracted on: August 30, 2014 (2:21 pm)
Period | Value
Jan-2002 | 858654
Feb-2002 | 862338
Mar-2002 | 844551
Apr-2002 | 858240
May-2002 | 850935
[NAME] | 846777
Jul-2002 | 847129
Aug-2002 | 839008
Sep-2002 | 832134
Oct-2002 | 839690
Nov-2002 | 844697
Dec-2002 | 855921
[NAME] | 863855
Feb-2003 | 859225
Mar-2003 | 851132
Apr-2003 | 859459
May-2003 | 866814
Jun-2003 | 880865
Jul-2003 | 891264
Aug-2003 | 901839
Sep-2003 | 911589
Oct-2003 | 925732
Nov-2003 | 925985
Dec-2003 | 948491
Jan-2004 | 938826
Feb-2004 | 938656
Mar-2004 | 960946
Apr-2004 | 967761
May-2004 | 974158
Jun-2004 | 983072
Jul-2004 | 1006119
Aug-2004 | 1013724
Sep-2004 | 1012290
Oct-2004 | 1015562
Nov-2004 | 1023210
Dec-2004 | 1037684
Jan-2005 | 1036187
Feb-2005 | 1056492
Mar-2005 | 1065262
Apr-2005 | 1058365
May-2005 | 1078586
Jun-2005 | 1089505
Jul-2005 | 1109691
Aug-2005 | 1119782
Sep-2005 | 1131739
Oct-2005 | 1145663
Nov-2005 | 1156977
Dec-2005 | 1178305
Jan-2006 | 1183861
Feb-2006 | 1199767
Mar-2006 | 1213270
Apr-2006 | 1183485
May-2006 | 1180059
Jun-2006 | 1172932
Jul-2006 | 1165093
Aug-2006 | 1158193
Sep-2006 | 1151104
Oct-2006 | 1139292
Nov-2006 | 1137488
Dec-2006 | 1153491
[NAME] | 1149899
Feb-2007 | 1156008
Mar-2007 | 1167402
Apr-2007 | 1159124
May-2007 | 1168195
Jun-2007 | 1166892
Jul-2007 | 1154018
Aug-2007 | 1160593
Sep-2007 | 1165162
Oct-2007 | 1152511
Nov-2007 | 1127558
Dec-2007 | 1108958
Jan-2008 | 1106498
Feb-2008 | 1092911
Mar-2008 | 1095194
Apr-2008 | 1092939
May-2008 | 1091569
Jun-2008 | 1075482
Jul-2008 | 1067380
Aug-2008 | 1058675
Sep-2008 | 1056892
Oct-2008 | 1051176
Nov-2008 | 1031004
Dec-2008 | 994216
Jan-2009 | 965270
Feb-2009 | 962482
Mar-2009 | 956133
Apr-2009 | 931610
May-2009 | 914093
Jun-2009 | 903987
Jul-2009 | 901735
Aug-2009 | 891278
Sep-2009 | 881340
Oct-2009 | 870697
Nov-2009 | 852896
Dec-2009 | 832484
[NAME] | 818468
[NAME] | 798063
Mar-2010 | 807437
Apr-2010 | 825626
[NAME] | 817745
[NAME] | 817869
[NAME] | 790519
Aug-2010 | 793090
Sep-2010 | 800329
Oct-2010 | 802013
Nov-2010 | 799636
Dec-2010 | 779919
Jan-2011 | 757900
Feb-2011 | 754970
Mar-2011 | 763454
Apr-2011 | 772469
May-2011 | 774148
Jun-2011 | 797272
Jul-2011 | 789632
Aug-2011 | 801183
Sep-2011 | 805565
Oct-2011 | 806849
Nov-2011 | 809833
Dec-2011 | 817198
Jan-2012 | 823583
Feb-2012 | 825774
Mar-2012 | 834810
Apr-2012 | 842898
May-2012 | 861913
Jun-2012 | 873069
Jul-2012 | 864687
Aug-2012 | 868246
Sep-2012 | 876091
Oct-2012 | 883853
Nov-2012 | 879539
Dec-2012 | 882637
[NAME] | 869232
[NAME] | 879609
Mar-2013 | 871888
Apr-2013 | 884966
May-2013 | 896603
Jun-2013 | 900334
[NAME] | 906644
Aug-2013 | 915286
Sep-2013 | 924153
[NAME] | 939933
Nov-2013 | 952531
Dec-2013 | 961158
Spreadsheet: 038f4479-5c7c-4754-843c-791748b2416d
Sheet: Sheet1

Unnamed: 0 | Dipartimento | [NAME] | Indirizzo referenti | [NAME] | Indirizzo referenti [NAME]
DAUIN | Dipartimento di Automatica e Informatica | [NAME] | [EMAIL]
 |  | [NAME] | [EMAIL]
DET | Dipartimento di Elettronica  e Telecomunicazioni | [NAME] | [EMAIL]
 |  | [NAME] | [EMAIL]
 |  | [NAME] | [EMAIL]
DIGEP | Dipartimento di Ingegneria Gestionale e della Produzione | [NAME] | [EMAIL]
DISMA | Dipartimento di Scienze Matematiche | [NAME] | [EMAIL]
 |  | [NAME] | [EMAIL]
 |  | [NAME] | [EMAIL]
DISAT | Dipartimento di [NAME] e Tecnologia | [NAME] | [EMAIL]
 |  | Davide Fissore | [EMAIL]
 |  | [NAME] | [EMAIL]
DIMEAS | Dipartimento di Ingegneria Meccanica e Aerospaziale | Alessandro Fasana | [EMAIL]
 |  | [NAME] | [EMAIL]
 |  | [NAME] | [EMAIL]
DENERG | Dipartimento Energia | [NAME] | [EMAIL]
 |  | [NAME] | [EMAIL]
 |  | [NAME] | [EMAIL]
DISEG | Dipartimento di [NAME], Edile e Geotecnica | [NAME] | [EMAIL]
 |  | Teresa Di Benedetto | [EMAIL]
DIATI | Dipartimento di Ingegneria dell'Ambiente, del Territorio e delle Infrastrutture | Paola Procacci | [EMAIL]
 |  | [NAME] | [EMAIL]
DAD | Dipartimento di Architettura e Design | [NAME] | [EMAIL] | [NAME] | [EMAIL]
 |  | [NAME] | [EMAIL]
DIST | Dipartimento di Interateneo di Scienze, Progetto e Politiche del Territorio |  |  | [NAME] | [EMAIL]
 |  |  |  | Luciano Fiandanese | [EMAIL]
 | [EMAIL]
Spreadsheet: 478959d1473162494-select-cells-from-row-in-a-sequence-omit-some-then-display-consecutively-in-output-row-needs-a-sequential-selection-formula
Sheet: Sheet1

 | 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
 | Sequence    >>>>> |  |  |  | 1st | - | 3rd | 4th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start cell |  |  |  | Output
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | 5 | 7 | 8
 | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sequence    >>>>> |  |  |  | 1st | - | 3rd | 4th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start cell |  |  |  | Output
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  | 22 | 24 | 25
 | 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
 |  |  |  |  |  | Sequence    >>>>> |  |  |  | 1st | - | 3rd | 4th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start cell |  |  |  | Output
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  | 10 | 12 | 13
Spreadsheet: 747479d1631532707-data-extraction-from-other-sheets-based-on-the-value-from-the-dropdown-list-book1
Sheet: Summary of Report

Category | ALL | DEPT | M
ID | BASIC SALARY | OVERTIME | BONUS | COMMISSION | TOTAL NET AMOUNT
A00001
A00004
A00012
A00013
A00019
A00027
A00028 | 485 | 96.6666666666667 | 48.5 | 24.25
A00031
A00042
A00063 | 450 | 70 | 45 | 22.5
A00067
A00083
A00087 | 520 | 119.166666666667 | 52 | 26
B00015
LOOKUP CONDITION: $B$1 & $D$2
IF "INACTIVE" IS CHOSEN,
The IDs that are NOT included in "Details of Salary" will be shown based on $[NAME].
IF "ACTIVE" IS CHOSEN,
The IDs that are included in "Details of Salary" will be shown including all the details of their salary based on $[NAME].
IF "ALL" IS CHOSEN,
All IDs that are included in "Staff Data" will be shown based on $[NAME].
But for those who are active, the details of the payment from the sheet "Details of Salary" should be shown.
For example:
I've chosen "All" and "M" Dept.
So all the staff IDs under M dept are shown. (Lookup Sheet: Staff Data)
The details of the payment of 3 active IDs are shown too. (Lookup Sheet: Details of Salary)
Spreadsheet: 92836d1292364264-second-question-urgent-please-question-two
Sheet: Sheet1

Use if and AND functions to solve this question |  |  | Name | Age | Income per year
Income/ per year |  |  | [NAME] | 39
30000 |  |  | de Boer | 42
40000 |  |  | de Vries | 51
50000 |  |  | [NAME] Vaart | 65
40000 |  |  | [NAME] | 78
Spreadsheet: 871059d1717505835-can-not-get-my-if-stamement-write-statement
Sheet: Sheet1

Claimant ID | Date Referred | PET Start |  | answer shuld be | my formula
068fb6df-2aed-4601-b46f-208fdfe3dba2 | 2024-04-02 00:00:00 | 2024-05-06 00:00:00 |  | yes
[NAME] | 2024-04-06 00:00:00 |  |  | no
068fb6df-2aed-4601-b46f-208fdfe3dba2 | 2024-04-02 00:00:00 | 2024-05-10 00:00:00 |  | yes
[NAME] | 2024-04-06 00:00:00 | 2024-04-05 00:00:00 |  | no
Spreadsheet: 718378d1613128634-required-formula-to-generate-leave-register-additional-requirement-sample_leavebook2
Sheet: Result

 |  | Leaves
 | [NAME]
 | Micheal
 | [NAME]
 | Ahmed
 | [NAME]
 | Greg
 | Micky
 | Trace
 | Lisy
 | Saraham
 | Leave - Monthwise
 | Name | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00
 | [NAME]
 | Micheal
 | [NAME]
 | Ahmed
 | [NAME]
 | Greg
 | Micky
 | Trace
 | Lisy
 | Saraham
 | Total
Spreadsheet: 63182d1264111911-payroll-taxes-tax-problems
Sheet: Pension11.3

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1017
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
Pay# | Name | Eligible? | Elig Date | 2010-01-09 00:00:00 | 2010-02-09 00:00:00 | 2010-03-09 00:00:00 | 2010-04-09 00:00:00 | 2010-05-09 00:00:00 | 2010-06-09 00:00:00 | 2010-07-09 00:00:00 | 2010-08-09 00:00:00 | 2010-09-09 00:00:00 | 2010-10-09 00:00:00 | 2010-11-09 00:00:00 | 2010-12-09 00:00:00 | YTD TOTAL |  | Left to [NAME]
8 | SMITH | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 1017
13 | JONES | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 1017
Spreadsheet: 05e57fd4-6573-4b8d-9307-a17530386714
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 34. LEASE FINANCE COMMITMENTS, By Purpose: State (SA), 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 | A2413927F | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413929K | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413930V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413931W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413932X | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413933A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413934C | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413935F | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413936J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413938L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413939R | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413940X | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413941A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413942C | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 0558c356-c45a-42bf-9653-efe9b353e88a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | IIC JAPAN 2013 Countries information
Countries :
Association name :
President name :
Representative of this trip:
Contect email :
phone (with area code) :
Participants
Name | sex | ITF degree No | Arrive NARITA date/time | Flight number | Departure NARITA  date/time | Flight number | Accommodation | Meal | Transportation Service
 |  |  |  | I tell you, after determining. |  | I tell you,  after determining. | Single or Twin  or Five or Ten-person  common room | Yes or No | Yes or No
Spreadsheet: 473736d1470359436-index-match-on-two-worksheets-with-duplicate-names-domy-index-match
Sheet: Sheet1

[NAME] | GNY
[NAME] | CRI
[NAME] | BRB
[NAME] | US
[NAME] | RD
[NAME] | PR
[NAME] | US
[NAME] | JP
[NAME] | PR
Michel | PR
[NAME] | BRB
[NAME] | US
Sylka | VNZ
Vivian | PR
Spreadsheet: 53287d1253187822-display-an-array-of-data-based-on-other-data-lookup
Sheet: Sheet1

1Wright | [NAME] | A-1 | Beltran | A-21 | 0 | 0 |  | A-21
1Pujols | Pujols | B-3 | Jeter | C-22 | 0 | 0 |  | C-22
1Jeter | Jeter | C-22 | Pujols | B-3 | J-22 | 0 |  | B-3,J-22
2Wright | [NAME] | F-38 | [NAME] | A-1 | F-38 | mmmm |  | A-1,F-38,mmmm
1Beltran | Beltran | A-21
2Pujols | Pujols | J-22
3Wright | [NAME] | mmmm
Spreadsheet: 778557d1651154156-conditional-formatting-based-on-date-range-cf-date-within-range-aligw
Sheet: Sheet1

Period of Performance Start Date | Period of Performance End Date | Date
2021-10-01 00:00:00 | 2022-09-30 00:00:00
2021-09-22 00:00:00 | 2022-06-21 00:00:00
2021-10-01 00:00:00 | 2022-09-30 00:00:00
2021-10-01 00:00:00 | 2022-09-30 00:00:00
2022-03-18 00:00:00 | 2022-09-30 00:00:00
2022-03-14 00:00:00 | 2022-09-30 00:00:00
2022-03-14 00:00:00 | 2022-09-30 00:00:00
2022-06-22 00:00:00 | 2023-06-21 00:00:00
Spreadsheet: 850853d1701182150-shading-weekend-cloumns-meeting-rooms
Sheet: March 2024

 | 2024-03-01 00:00:00 | 2024-03-02 00:00:00 | 2024-03-03 00:00:00 | 2024-03-04 00:00:00 | 2024-03-05 00:00:00 | 2024-03-06 00:00:00 | 2024-03-07 00:00:00 | 2024-03-08 00:00:00 | 2024-03-09 00:00:00 | 2024-03-10 00:00:00 | 2024-03-11 00:00:00 | 2024-03-12 00:00:00 | 2024-03-13 00:00:00 | 2024-03-14 00:00:00 | 2024-03-15 00:00:00 | 2024-03-16 00:00:00 | 2024-03-17 00:00:00 | 2024-03-18 00:00:00 | 2024-03-19 00:00:00 | 2024-03-20 00:00:00 | 2024-03-21 00:00:00 | 2024-03-22 00:00:00 | 2024-03-23 00:00:00 | 2024-03-24 00:00:00 | 2024-03-25 00:00:00 | 2024-03-26 00:00:00 | 2024-03-27 00:00:00 | 2024-03-28 00:00:00 | 2024-03-29 00:00:00 | 2024-03-30 00:00:00 | 2024-03-31 00:00:00
 | 2024-03-01 00:00:00 | 2024-03-02 00:00:00 | 2024-03-03 00:00:00 | 2024-03-04 00:00:00 | 2024-03-05 00:00:00 | 2024-03-06 00:00:00 | 2024-03-07 00:00:00 | 2024-03-08 00:00:00 | 2024-03-09 00:00:00 | 2024-03-10 00:00:00 | 2024-03-11 00:00:00 | 2024-03-12 00:00:00 | 2024-03-13 00:00:00 | 2024-03-14 00:00:00 | 2024-03-15 00:00:00 | 2024-03-16 00:00:00 | 2024-03-17 00:00:00 | 2024-03-18 00:00:00 | 2024-03-19 00:00:00 | 2024-03-20 00:00:00 | 2024-03-21 00:00:00 | 2024-03-22 00:00:00 | 2024-03-23 00:00:00 | 2024-03-24 00:00:00 | 2024-03-25 00:00:00 | 2024-03-26 00:00:00 | 2024-03-27 00:00:00 | 2024-03-28 00:00:00 | 2024-03-29 00:00:00 | 2024-03-30 00:00:00 | 2024-03-31 00:00:00
BIG BOARDROOM: 0800-0900
BIG BOARDROOM: 0900-1000
BIG BOARDROOM: 1000-1100
BIG BOARDROOM: 1100-1200
BIG BOARDROOM: 1200-1300
BIG BOARDROOM: 1300-1400
BIG BOARDROOM: 1400-1500
BIG BOARDROOM: 1500-1600
BIG BOARDROOM: 1600-1700
SMALL BOARDROOM: 0800-0900
SMALL BOARDROOM: 0900-1000
SMALL BOARDROOM: 1000-1100
SMALL BOARDROOM: 1100-1200
SMALL BOARDROOM: 1200-1300
SMALL BOARDROOM: 1300-1400
SMALL BOARDROOM: 1400-1500
SMALL BOARDROOM: 1500-1600
SMALL BOARDROOM: 1600-1700
Spreadsheet: 852298d1702387884-use-let-function-to-create-2-sorted-tables-based-on-multiple-criteria-creating-sorted-lists-using-let-function-based-on-criteria-hd
Sheet: SETTINGS

 | Station Order | Abbreviated Station Name
 | 1 | ROD
 | 2 | RIN
 | 3 | QAW
 | 4 | BOH
 | 5 | IMB
 | 6 | SUD
 | 7 | KIT
 | 8 | SAF
 | 9 | MAS
 | 10 | NAS
 | 11 | ATA
 | 12 | BAB
 | 13 | GES
 | 14 | ABP
 | 15 | ABA
 | 16 | CFR
 | 17 | STD
 | 18 | KEB
 | 19 | AHR
 | 20 | HAR
 | 21 | HEL
 | 22 | ALF
 | 23 | SHA
 | 24 | NOZ
 | 25 | HIB
 | 26 | QEB
 | 27 | OMR
 | 28 | HYK
 | 29 | ADM
Spreadsheet: 9d901c17-c4cb-4541-90b2-6ae06f99d950
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 | Unnamed: 12 | Unnamed: 13
 | Please [NAME] This Form To:      [EMAIL]
 | Your Name |  | E-mail
 | Group Name           (please do NOT abbreviate, specify club or conference) |  | Account Name (KSA or SOFO) (required) |  |  |  | Is this a Company Sponsored Event? | YES | NO
 | Order Date |  | Account Number (required) |  |  |  | Sponsor Name:
 | Delivery Time |  | Delivery Date |  | Delivery Room |  | Want A Table? | YES | NO
 | Circle Vendor | Boston Market | *Buffalo Wild Wings | *Chipotle(Need 4 day notice) |  | Corner Bakery
 | Cosi | *[NAME] | [NAME] | [NAME] | *[NAME] | Koi
 | *[NAME] (Delivery after 4pm Only) |  | *Noodles & Co. | Panera | [NAME] | [NAME] (Skokie)
 |  | Potbelly | *Rollin' To Go | Sarpino's | [NAME] | *[NAME]
 |  | Asterisk * = WED Vendor (Below Charges Apply) Order Using This Form |  |  | Specify Unlisted Vendor Below:
 |  | Orders under $300 will have a $29.99 service fee
 |  | Orders over $300 will have a 10% service fee
 |  | No orders under $150 accepted
 |  | 2 days advance notice required
 | Place Order
 | Information or
 | Comments
 | in the box to
 | the right.
 | Student Affairs Use: | Order Placer ___________________________           Date Placed ____________________                             Logged _______
 |  | [NAME] ____________________________  Name on Card Used _______________________       Ordered ______
 |  | [NAME]  ______________ | Tip _________ | Notes ______________________________________________