tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 59363d1259855090-auto-fill-cells-based-on-value-entered-in-first-cell-schoolquestions
Sheet: GR 7 RDG

FCAT 7th Gr. Rdg | DIS 09 | FY09 | FY08 | FY07 | ANALYZE PERFORMANCE; STRATEGIZE  SCHOOL IMPROVEMENT  ANALYZE Prior SCHOOL/TEACHER Scores  Declines = Prof. [NAME]., Teaming, Support  ANALYZE CURRENT AYP GOALS/SubGroups,  CURRENT Students' Prior Scores, TEST CONTENT  = Target Students, Instructional Focus,  [NAME], RtI
% ≥ Level 3 | 66 | 75 | 76 | 74
WORDS (18%) | 67 | 73 | 76 | 75
M. IDEA (44%) | 70 | 76 | 68 | 73
C & C (24%) | 66 | 71 | 75 | 80
REF (13%) | 67 | 72 | 68 | 71
INFO (51%) | 69 | 76 | 73 | 75
LIT (49%) | 66 | 71 | 68 | 73
 | Population | PP | PNP | AYP/SH | AYP/SH # | PT | PNT | AT RISK | AYP RISK | SH RISK
TOTAL | 375 | 254 | 89
WHITE | 229 | 170 | 40
BLACK
HISPANIC | 100 | 51 | 41
ASIAN
AM IND
ECON DIS | 141 | 80 | 44
ELL
ESE | 39 | 11 | 18
ENTER  DATA  IN  BLUE CELLS  (only) | ENTER  CURRENT #  of students  in  grade level in each subgroup | ENTER  # of current students in grade level who tested previously  &  showed proficiency | ENTER  #  of current students in grade level who tested  previously  &  DID NOT  show proficiency | %  current students  to show proficiency to  make  AYP | #  current students  to show proficiency to  make  AYP | # students who were previously tested in this grade level in each subgroup appears auto-matically | # students who were not previously tested  in this grade level  in each subgroup appears auto-matically | AT RISK  # of current students who DID NOT previously  test or  DID NOT show proficiency | AYP RISK  # of current  AT RISK students to show proficiency to make  AYP | SAFE HARBOR RISK       # of current  AT RISK  students  to show proficiency to  make  SAFE  HARBOR
QUESTIONS 1. IDENTIFY Who are these students?  Who are their teaching teams? 2. [NAME] Which of these students show the most potential for achievement and readiness  for development? (diagnostic tests, formative assessments, gain scores, anecdotal records)  3. STRATEGIZE Which of them affect the most AYP subgroup categories? 4. FOCUS With which (sub)content areas do the students struggle? Can instruction be focused  to help them overcome those challenges? With which (sub)content areas do the students show the most progress? Can cooperative groups, study buddies, and peer tutoring be implemented  to benefit learning?  5. MONITOR What are their progress monitoring activities? What are their baseline scores?  What data chats are scheduled throughout the year?  What progress charts will the students develop and monitor?
Spreadsheet: e21e0455-3b36-478f-a7af-b27c8b6c9a48
Sheet: Gene List profile

miR-17/miR-20a common Targets | miR-19a/miR-19b common Targets | miR-451 targets
2310002B06RIK | 2600010E01RIK | 5730446C15RIK
ACSL4 | ACSL1 | CDCA7
BC038286 | ACSL4 | CLOCK
DNAJA4 | ADAM12 | FLI1
[NAME] | ALDH3A2 | HERPUD1
E2F5 | BTG1 | MLF1IP
[NAME] | CCL11 | MYC
EIF5A2 | CNOT4 | TNFSF11
ELK3 | CSMD1 | YTHDF2
ENPP5 | ELK3
EZH1 | [NAME]
FBXO25 | MAPRE2
HBP1 | MELK
IKBKB | [NAME]
MKNK2 | PDCD10
P2RX4 | PSAP
RASL11B | PTPRG
RPS6KA5 | RAB33B
SMAD7 | [NAME]
SMOC2 | RNF38
SYAP1 | SH3D19
TUSC2 | SLC9A1
TXNIP | SPIRE1
XRCC4 | SPTLC2
 | TAF4A
 | TRIM33
 | USP32
Spreadsheet: 111687d1308025953-creating-list-of-unique-values-from-data-creating-list-of-unique-values
Sheet: Sheet1

No | Type | Value |  |  | Result through formula |  |  | Result through formula |  |  | Result through formula
22 | High | 1200 |  |  | 22 |  |  | 23 |  |  | 24
22 | Low | 1400 |  |  | High |  |  | High |  |  | High
22 | High | 1600
24 | High | 1200
22 | High | 1400
24 | Low | 1600
22 | Low | 1200
22 | High | 1200
22 | High | 1600
23 | High | 1600 |  |  | Desired result |  |  | Desired result |  |  | Desired result
24 | High | 1200 |  |  | 22 | 1200 |  | 23 | 1600 |  | 24 | 1200
22 | High | 1400 |  |  |  | 1400 |  |  |  |  |  | 1600
22 | Low | 1400 |  |  |  | 1600
24 | High | 1600
Spreadsheet: 42176d1240754019-determin-x-value-from-a-y-lactate-chart-11set
Sheet: Infomation Sheet

Means |  | Sum | Increase Point
100 | 0.5 | 130 | 0.9 |  |  |  |  |  | 1st Inflection | 150 | 160
130 | 1 | 133 | 1.1 |  |  |  |  |  |  | 2 | 160
160 | 2 | 142 | 1.2
190 | 3 | 153 | 2.4
220 | 4 | 160 | 4.3
250 | 5.5 | 168 | 7.2 |  |  |  |  |  | [NAME] | 150 | 182
280 | 7.5 | 173 | 9.1 |  |  |  |  |  |  | 2 | 182
 |  |  |  |  | 1 | 0
 |  |  |  |  | 1 |  |  |  | Need the values for L3
 |  |  | Manually input Vertical Lines as example. Data was not calculated.
 |  |  |  |  |  |  |  |  |  |  |  |  | Means 1st Inflection 1.2 |  | 160
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 142
 |  |  |  |  |  |  |  |  |  | Would like this chart to |  |  | L2 2.0 |  | 182
 |  |  |  |  |  |  |  |  |  | get the numbers |  |  | [NAME] |  | 150
 |  |  |  |  |  |  |  |  |  | from graph Automatically |  |  | L3 3.0 |  | 200
 |  |  |  |  |  |  |  |  |  |  |  |  | Sum l3 |  | 156
 |  |  |  |  |  |  |  |  |  |  |  |  | L4 4.0 |  | 216
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 159
 |  |  |  |  |  |  |  |  |  |  |  |  | P OBLA 4.4 |  | 222
 |  |  |  |  |  |  |  |  |  |  |  |  | OBLA |  | 161
Spreadsheet: 457065d1461183198-vacation-tracking-and-accruals-vacation-tracker-sample
Sheet: VACATION 

Maintenance | 4 | 1=Full Day Vacation-Taken |  |  |  |  |  |  |  |  |  |  |  |  |  | Out of office: training or jury duty |  |  |  |  |  |  |  |  |  |  | Military Leave
Sanitation / Tray Up | 6 | .5=Half Day Vacation-Taken |  |  |  |  |  |  |  |  |  |  |  | 8 |  | Company Holiday |  |  |  |  |  |  |  |  |  |  | 2016 Holiday
Production | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bereavement |  |  |  |  |  |  |  |  |  |  |  | 3 missed days |  |  |  |  |  | 4 missed days |  |  |  |  |  | 5 missed days |  |  |  |  |  | 6 missed days |  |  |  |  |  |  | 2 no call no show
Quality | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Missed time from work |  |  |  |  |  |  |  |  |  |  |  |  | Verbal Warning |  |  |  |  | Written warning |  |  |  |  |  | Final written |  |  |  |  |  | Terminated |  |  |  |  |  |  | Terminated
Operators | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | Employee floater holiday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 days suspension
Warehouse | 5 |  | 2015 Carry-Over |  |  |  |  |  |  |  |  |  |  |  |  | Vacation
Administration | 5
Total  Employees |  | DAY | JAN |  |  |  |  | FEB |  |  |  |  | MAR |  |  |  | APR |  |  |  | MAY |  |  |  |  | [NAME] |  |  |  | JULY |  |  |  | AUG |  |  |  |  | SEP |  |  |  | OCT |  |  |  |  | NOV |  |  |  | DEC
NAME |  |  | 28 | 4 | 11 | 18 | 25 | 1 | 8 | 15 | 22 | 29 | 7 | 14 | 21 | 28 | 4 | 11 | 18 | 25 | 2 | 9 | 16 | 23 | 30 | 6 | 13 | 20 | 27 | 4 | 11 | 18 | 25 | 1 | 8 | 15 | 22 | 29 | 5 | 12 | 19 | 26 | 3 | 10 | 17 | 24 | 31 | 7 | 14 | 21 | 28 | 5 | 12 | 19 | 26
EXAMPLE | 0 | M
Current Year Days Available | 15 | T
Total Days Available |  | W
Days Taken / Planned |  | T
Days Remaining |  | F |  |  |  |  |  |  |  |  | 1
 |  | S |  |  |  |  |  |  |  |  | 1
 |  | S
Spreadsheet: 707282d1607154142-index-match-formula-not-working-properly-from-data-in-pivot-tables-help-november-mileage-and-fuel
Sheet: SUMMARY

Truck | 01 |  |  | 1022 |  |  | 2907 |  |  | 667896 |  |  | 7006 |  |  | 73 |  |  | 88
State | [NAME] | GALLONS | REEFER | [NAME] | GALLONS | REEFER | [NAME] | GALLONS | REEFER | [NAME] | GALLONS | REEFER | [NAME] | GALLONS | REEFER | [NAME] | GALLONS | REEFER | [NAME] | GALLONS | REEFER
AL
AR
AZ
CA
CO
CT
DE
FL
GA
IA
ID
IL
IN
KS
KY
LA
MA
MD
ME
MI
MN
MO
MS
MT
NC
ND
NE
NH
NJ
NM
NV
NY
OH
OK
OR
PA
RI
SC
SD
TN
TX
UT
VA
VT
WA
WI
WV
WY
Spreadsheet: 712883d1610465202-finding-out-the-name-of-the-most-expensive-item-in-the-product-group-fruits-you-probably-have-never-seen
Sheet: Lapas1

Article group | Article discription | Price | Name of most expensive article in group
1 | Blue Apples | 266.38
6 | Red Cucumber | 128.94
8 | [NAME] | 102.88
4 | Green Cherry | 301
3 | Red Cucumber | 299.5
5 | Black Carrot | 287.55
5 | Black Carrot | 212.2
5 | Blue Apples | 82.78
8 | [NAME] | 810
9 | Red Cucumber | 324.51
6 | Orange Banana | 137.94
3 | Orange Banana | 274.8
1 | Blue Apples | 139.5
7 | Red Cucumber | 182.3
4 | Red Cucumber | 697
5 | Blue Apples | 563.52
2 | Orange Banana | 141.75
8 | Green Cherry | 418.3200000000001
8 | Black Carrot | 245
4 | Blue Apples | 80.07000000000001
7 | Green Cherry | 68.22
5 | [NAME] | 206.2
6 | Green Cherry | 67.05000000000001
1 | Orange Banana | 85.36
1 | Orange Banana | 298.88
3 | Red Cucumber | 299
1 | Black Carrot | 123.25
1 | Red Cucumber | 181.3
2 | Blue Apples | 855.6
Spreadsheet: 850170d1700561141-how-can-i-filter-exract-data-based-on-condition-test_file-h
Sheet: Sheet 1

Material | SSP | Name | Pos
500853 | 2 | [NAME] | 20
500853 | 3 | [NAME] | 30
501311 | 4 | Aged Suede | 10
501311 | 5 | Aged Suede | 10
501587 | 5 | Bubblesteel | 10
501591 | 4 | Lost Weave | 10
501591 | 4 | Lost Weave | 20
501595 | 3 | [NAME] | 10
501595 | 6 | [NAME] | 10
501682 | 4 | Trueskin | 10
501682 | 4 | Trueskin | 20
501682 | 6 | Trueskin | 10
501682 | 7 | Trueskin | 10
501682 | 7 | Trueskin | 20
501682 | 8 | Trueskin | 10
501763 | 4 | Halflog | 10
501763 | 5 | Halflog | 10
501763 | 6 | Halflog | 10
501763 | 7 | Halflog | 10
501763 | 7 | Halflog | 20
501763 | 8 | Halflog | 10
501879 | 4 | Aerosteel | 10
501879 | 4 | Aerosteel | 20
501879 | 4 | Aerosteel | 30
501879 | 7 | Aerosteel | 10
501879 | 7 | Aerosteel | 20
501879 | 8 | Aerosteel | 10
502090 | 4 | Breathcobalt | 10
502090 | 5 | Breathcobalt | 10
Spreadsheet: 37962d1236075878-random-selections-student
Sheet: Sheet8

name
student 801
student 802
student 803
student 804
student 805
student 806
student 807
student 808
student 809
student 810
student 811
student 812
student 813
student 814
student 815
student 816
student 817
student 818
student 819
student 820
student 821
student 822
student 823
student 824
student 825
Spreadsheet: 89233d1288978316-making-a-specific-randbetween-function-counterbalance-scheme
Sheet: Sheet1

Counterbalance Scheme | Scenario Condition
 | Manual | Semi-Auto | Semi-Auto /w Vis | Full-Auto
Target Route 1 | Manual + Route 1 | Semi-Auto + Route 1 | Semi-Auto /w Vis + Route 1 | Full-Auto + Route 1
Target Route 2 | Manual + Route 2 | Semi-Auto + Route 2 | Semi-Auto /w Vis + Route 2 | Full-Auto + Route 2
Target Route 3 | Manual + Route 3 | Semi-Auto + Route 3 | Semi-Auto /w Vis + Route 3 | Full-Auto + Route 3
Target Route 4 | Manual + Route 4 | Semi-Auto + Route 4 | Semi-Auto /w Vis + Route 4 | Full-Auto + Route 4
Target Route
 |  |  |  |  | <-------- | Participant Combo Selection
 |  |  |  |  |  | Hit F9 to recalculate randomized
 |  |  |  |  |  | selections for each participant
Spreadsheet: 37023d1234967583-how-do-i-perform-an-array-multiplication-if-a-cell-contains-a-specific-text-string-sample2
Sheet: Sheet2

 | MANUAL |  |  | FORMULA |  |  | Difference
 | [NAME] | 7246.666666666666 |  | [NAME] | 7246.666666666666 |  | 0
 | BARC | 3941.873833333333 |  | BARC | 3941.873833333333 |  | 0
 | BNP | 0 |  | BNP | 0 |  | 0
 | CAL | 0 |  | CAL | 0 |  | 0
 | CITI | 7254.165499999999 |  | CITI | 7254.165499999999 |  | 0
 | CBA | 0 |  | CBA | 0 |  | 0
 | CS | 500 |  | CS | 500 |  | 0
 | DB | 3380 |  | DB | 3380 |  | 0
 | GS | 5666.666666666666 |  | GS | 5666.666666666666 |  | 0
 | HSBC | 0 |  | HSBC | 0 |  | 0
 | JPM | 11481.04166666667 |  | JPM | 11481.04166666667 |  | 0
 | KEY | 0 |  | KEY | 0 |  | 0
 | LLYD | 0 |  | LLYD | 0 |  | 0
 | MER | 0 |  | MER | 0 |  | 0
 | MITSU | 0 |  | MITSU | 0 |  | 0
 | MIZ | 0 |  | MIZ | 0 |  | 0
 | MK | 0 |  | MK | 0 |  | 0
 | MS | 13275.9805 |  | MS | 17210.3555 |  | 3934.374999999998
 | RBC | 0 |  | RBC | 0 |  | 0
 | RBS | 2734.375 |  | RBS | 2734.375 |  | 0
 | SAN | 0 |  | SAN | 0 |  | 0
 | SCO | 0 |  | SCO | 0 |  | 0
 | STRH | 0 |  | STRH | 0 |  | 0
 | TD | 0 |  | TD | 0 |  | 0
 | UBS | 0 |  | UBS | 0 |  | 0
 | WB | 6901.041666666666 |  | WB | 6901.041666666666 |  | 0
 | WFC | 700 |  | WFS | 700 |  | 0
Spreadsheet: 31096d1226853737-formulas-for-referencing-data-from-another-sheet-sales_call_report
Sheet: Dec-08

 |  | Weekly Sales Schedule & Results
 | Date | Call Type | GIS Account# | Account Name | Contact | Channel | Category | Objective | Results | Next Step | Meeting
 | m/dd |  |  |  |  |  |  |  |  |  | Hours
Mon | 2008-12-01 00:00:00 | Appointed | 1234 | ABC Printing | [NAME] |  |  |  |  |  | 0.5 |  | Appointed
 |  | Scheduled | 1235 | Flex Form | [NAME] |  |  |  |  |  | 1.5 |  | Scheduled
 |  | Scheduled | 1235 | Flex Form | [NAME] |  |  |  |  |  | 1
 |  | Scheduled | 1212 | Cold Works | [NAME] |  |  |  |  |  | 2
 |  | Appointed | 1367 | GG Industries | [NAME] |  |  |  |  |  | 0.75
Tue | 2008-12-02 00:00:00
Wed | 2008-12-03 00:00:00 | Scheduled | 1234 | ABC Printing | [NAME] |  |  |  |  |  | 0.5
Thu | 2008-12-04 00:00:00
 |  | Scheduled | 1235 | Flex Form | [NAME] |  |  |  |  |  | 1
Fri | 2008-12-05 00:00:00
 |  | Scheduled | 1367 | GG Industries | [NAME] |  |  |  |  |  | 1
Mon | 2008-12-08 00:00:00
Tue | 2008-12-09 00:00:00
Wed | 2008-12-10 00:00:00
Thu | 2008-12-11 00:00:00
Fri | 2008-12-12 00:00:00
Mon | 2008-12-15 00:00:00
Tue | 2008-12-16 00:00:00
Wed | 2008-12-17 00:00:00
Thu | 2008-12-18 00:00:00
Fri | 2008-12-19 00:00:00
Mon | 2008-12-22 00:00:00
Tue | 2008-12-23 00:00:00
Wed | 2008-12-24 00:00:00
Thu | 2008-12-25 00:00:00
Fri | 2008-12-26 00:00:00
Mon | 2008-12-29 00:00:00
Tue | 2008-12-30 00:00:00
Wed | 2008-12-31 00:00:00
Spreadsheet: 158085d1337973745-multiple-criteria-multiple-columns-exmpl
Sheet: emp connections

Employee | Grand Total | 2012-03-23 00:00:00 | 2012-03-30 00:00:00 | 2012-04-06 00:00:00 | 2012-04-13 00:00:00 | 2012-04-20 00:00:00 | 2012-04-27 00:00:00 | 2012-05-04 00:00:00 | 2012-05-11 00:00:00
Contreras, [NAME] (Chris)-621299 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Karl-619364 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Brown, Kenchon-168405 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contreras, [NAME] (Chris)-621299 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flores, Ramon-49399 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gonzales, Guadalupe-185254 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Jesus-615827 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Ventura-187526 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dixon, [NAME] (Ossy)-677008 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Galindo, Efren S-136813 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Guzman, Christopher-614708 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hannen, Jonathon S-649969 Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ignacio, William Cruz-612775 Total
Spreadsheet: 814167d1674201221-if-b5-b128-contain-words-sum-left-hand-side-value-of-those-ask
Sheet: 安全防護

DEBIT NOTE (分判商扣款通知)
地 盤 名 稱  : |  | 青衣青康路北一期及二期 |  |  |  | Our Outgoing Reference 信件編號  : | CSHK/BJH/G57/2022/10538
To 致 | : | [NAME] |  |  |  | Debit Note Reference 扣款書編號  : | 420
Attn. 啟 | : | 陳先生 |  |  |  | Date  日 期  : | 2022-12-02 00:00:00
 |  |  |  |  |  | Reference Correspondence 參考文件  : | 簽收紀錄
 |  |  |  |  |  | By Fax To 傳真到 :
 |  |  |  |  |  | By Hand / By Mail 親遞 /  郵寄 : | By Hand
Subcontract : |  | #N/A
分判工程合約
In accordance with the Subcontract Clauses, we hereby inform you that an net amount |  |  |  |  |  | 182.505
which will be deducted in your forthcoming payment account.
現發此分判商扣款通知書給貴公司, 根據分判合約細則將會向貴號來月之中期/尾期糧款內扣除金額 港幣 |  |  |  |  |  |  | 182.505
Item(項目) |  | Description | (工作描述) | Unit (單位) | Quantity(數量) | Unit Rate(單價) | Amount | (金額HK$)
 |  | 安全防護用品及工具(2021年12月至2022年5月 )
1 |  | 安全帽 |  | no. | 3.45 | 46 |  | 158.7
2 |  | 行政費15% |  | 單 | 1 | 23.805 |  | 23.805
 |  |  |  |  |  | Total (HK$) = |  | 182.505
The deduction or set off will not relieve you any liability of the Subcontract.
有關是次代做所引起之損失, 我公司將按合約細則, 會於貴號來月之糧款內扣除。 但貴號仍需履行所有合約內之
工作及責任。
For and on behalf of CSHK |  |  |  |  |  | For and on behalf of CSHK
Deputy Site Manager / Project Quantity Surveyor |  |  |  |  |  | Site Manager / Project Manager
Encl. as stated (抄送)
1) |  | Q.S.
Remark: | Objection raises after 3 working days of this debit note issued in any reason will not be entertained (Unwritten objection is not accepted)
 | 此扣款書若發出後 3 個工作天仍未收到書面反對則當同意扣款論
Spreadsheet: 797454d1663893827-how-to-categorize-dates-to-months-book1-hd
Sheet: New Worksheet

Next Review | HD | Expected Result | Month behind (a negative value means ahead)
2022-07-31 00:00:00 |  | 2022-07-22 00:00:00
2022-07-31 00:00:00 |  | 2022-07-22 00:00:00
 |  | No Date
2022-03-18 00:00:00 |  | 2022-06-22 00:00:00
2022-03-18 00:00:00 |  | 2022-06-22 00:00:00
2023-01-31 00:00:00
2022-06-19 00:00:00
2022-06-19 00:00:00
2022-06-19 00:00:00
2022-07-24 00:00:00
2023-01-31 00:00:00
2022-02-26 00:00:00
2022-02-17 00:00:00
2022-10-31 00:00:00
2022-10-31 00:00:00
2022-09-11 00:00:00
2021-02-25 00:00:00
2022-04-01 00:00:00
2022-04-17 00:00:00
2022-07-31 00:00:00
2022-08-27 00:00:00
2022-01-09 00:00:00
2022-10-31 00:00:00
2022-12-31 00:00:00
2022-12-31 00:00:00
2023-02-28 00:00:00
2022-01-12 00:00:00
2022-02-19 00:00:00
2022-06-18 00:00:00
2022-09-30 00:00:00
2022-06-05 00:00:00
2021-11-04 00:00:00
2022-01-26 00:00:00
2022-09-22 00:00:00
2022-11-13 00:00:00
2021-11-05 00:00:00
2022-02-19 00:00:00
2021-02-25 00:00:00
2022-04-30 00:00:00
2023-04-30 00:00:00
2022-05-06 00:00:00
2021-07-22 00:00:00
2022-08-04 00:00:00
2022-08-28 00:00:00
2022-10-02 00:00:00
2021-10-18 00:00:00
2022-02-06 00:00:00
2022-10-17 00:00:00
2023-01-31 00:00:00
2023-02-28 00:00:00
2023-03-12 00:00:00
2023-03-31 00:00:00
2023-03-31 00:00:00
2023-04-30 00:00:00
2023-04-02 00:00:00
2023-04-09 00:00:00
2022-10-19 00:00:00
2023-06-30 00:00:00
2022-09-29 00:00:00
2023-05-28 00:00:00
2022-09-26 00:00:00
2022-12-13 00:00:00
2022-11-02 00:00:00
2022-10-31 00:00:00
2022-10-20 00:00:00
2022-10-20 00:00:00
2022-10-26 00:00:00
2022-12-08 00:00:00
2022-11-29 00:00:00
2022-09-15 00:00:00
2022-09-15 00:00:00
2023-08-10 00:00:00
2022-09-15 00:00:00
2022-04-16 00:00:00
2022-03-28 00:00:00
2022-03-25 00:00:00
2022-05-22 00:00:00
2022-10-31 00:00:00
2022-11-30 00:00:00
2022-11-10 00:00:00
2022-12-12 00:00:00
2022-05-08 00:00:00
2022-12-31 00:00:00
2022-08-31 00:00:00
2022-05-06 00:00:00
2022-09-04 00:00:00
2022-02-25 00:00:00
2022-07-10 00:00:00
2022-08-18 00:00:00
2022-07-27 00:00:00
2022-12-30 00:00:00
2022-09-30 00:00:00
2022-03-10 00:00:00
2022-03-08 00:00:00
2023-04-30 00:00:00
2022-03-31 00:00:00
2022-06-18 00:00:00
2022-12-08 00:00:00
2022-06-12 00:00:00
2022-12-31 00:00:00
2022-07-09 00:00:00
2023-01-31 00:00:00
2022-11-01 00:00:00
2022-07-09 00:00:00
2022-09-18 00:00:00
2022-04-07 00:00:00
2022-11-21 00:00:00
2022-09-11 00:00:00
2021-12-29 00:00:00
2022-04-28 00:00:00
2022-04-03 00:00:00
2023-02-28 00:00:00
2021-10-29 00:00:00
2022-08-21 00:00:00
2022-04-17 00:00:00
2022-03-03 00:00:00
2022-10-15 00:00:00
2022-11-15 00:00:00
2022-12-13 00:00:00
2022-07-31 00:00:00
2022-02-25 00:00:00
2023-07-02 00:00:00
Spreadsheet: 824244d1680419070-countifs-criteria-over-multiple-columns-value-error-excel-sample
Sheet: Data

[NAME] | Departure | Item 1 | Item 2 | Item 3 | Item 4 | Item 5
2023-01-01 00:00:00 | 2023-01-15 00:00:00 | Bananas | Bananas | Grapes | Strawberries
2023-01-02 00:00:00 | 2023-01-17 00:00:00 | Melon | Apples | Bananas | Grapefruit
2023-02-15 00:00:00 | 2023-02-18 00:00:00 | Cherries | Melon | Apples
2023-03-18 00:00:00 | 2023-03-21 00:00:00 | Apples | Strawberries | Pineapple
2023-04-01 00:00:00 | 2023-04-04 00:00:00 | Pineapple | Orange | Bananas | Apples
Spreadsheet: 764787d1642993078-determining-work-time-based-on-criteria-splitshiftef-dexter2-
Sheet: Data

Base | 00:10:00 |  |  | Span of Shift
Location A | 00:00:00 |  | Base | Report for Roll Call | 05:51:00
Location B | 00:10:00 |  |  | Start 1st Shift of Work | 06:01:00
Location C | 00:15:00 |  |  | End Shift | 10:19:00
Location D | 00:30:00
Combination | 00:15:00 |  |  | Break
 |  |  | Base | Report for 2nd Roll Call
 |  |  |  | Pull out | 14:10:00
 |  |  |  | 11th hr
 |  |  |  | End of 2nd Shift and Work Day | 17:32:00
 |  |  |  | Job Time
 |  |  |  | Report Time
 |  |  |  | Commute Time
 |  |  |  | Work Time
 |  |  |  | Straight Time
 |  |  |  | Over Time
Spreadsheet: 330054d1404498079-vlookup-if-formulas-and-linking-two-spreadsheets-together-absence-raw-data
Sheet: Absence Sheet

Name | [NAME] | Absence End | BP | Absence Days | Reason
Username 1 | 2014-09-01 00:00:00 |  | 5 | 20 | Debility
Username 2 | 2014-09-02 00:00:00 |  | 6 | 20 | Debility
Username 3 | 2014-09-03 00:00:00 |  | 6 | 20 | Debility
Username 4 | 2014-09-04 00:00:00 |  | 6 | 20 | Debility
Username 5 | 2014-09-05 00:00:00 | 2014-09-05 00:00:00 | 7 | 0 | Debility
Username 6 | 2014-09-06 00:00:00 |  | 7 | 20 | Debility
Username 7 | 2014-09-07 00:00:00 | 2014-09-05 00:00:00 | 1 | 0 | Debility
Username 8 | 2014-09-08 00:00:00 | 2014-09-05 00:00:00 | 1 | 0 | Debility
Username 9 | 2014-09-09 00:00:00 |  | 1 | 20 | Debility
Username 10 | 2014-09-10 00:00:00 |  | 0 | 20 | Debility
Username 11 | 2014-09-11 00:00:00 |  | 0 | 20 | Debility
Username 12 | 2014-09-12 00:00:00 |  | 0 | 20 | Debility
Spreadsheet: 1f600f65-4d21-464c-988e-01a1c7c2bcaf
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 40. OPERATING LEASE FINANCE COMMITMENTS: By Lender: 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
Banks ; |  |  | Original | A2413831L | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Finance Companies ; |  |  | Original | A2413832R | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
General Financiers ; |  |  | Original | A2413833T | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Other Lessors ; |  |  | Original | A2413834V | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413835W | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012