tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 880147d1727773436-detect-employee-actual-entry-data-and-exit-date-detect-employee-actual-entry-data-and-exit-date-1-
Sheet: Sheet1

Employee Name | Entry Date | Exit Date | Role | Team | Actual Entry Date | Actualy Exit Date | Check if Entry Date is promotion or transfer date | Check if Exit Date is promotion or transfer date |  | Actual Entry Date | Actualy Exit Date | Check | Check
A | 2021-10-01 00:00:00 | 2021-11-30 00:00:00 | Engineer | Data Science |  |  |  |  |  | 2021-06-01 00:00:00 | 2021-11-30 00:00:00
A | 2021-06-01 00:00:00 | 2021-09-30 00:00:00 | Engineer | Engineering 1 |  |  |  |  |  | 2021-06-01 00:00:00 | 2021-11-30 00:00:00
B | 2022-10-01 00:00:00 |  | Manager | Engineering 1 |  |  |  |  |  | 2021-03-01 00:00:00
B | 2021-10-15 00:00:00 | 2022-09-30 00:00:00 | Technical Architect | Engineering 1 |  |  |  |  |  | 2021-03-01 00:00:00
B | 2021-03-01 00:00:00 | 2021-10-14 00:00:00 | Engineer | Engineering 1 |  |  |  |  |  | 2021-03-01 00:00:00
C | 2024-08-01 00:00:00 | 2027-07-31 00:00:00 | Trainee | Apprenticeship |  |  |  |  |  | 2024-08-01 00:00:00 | 2027-07-31 00:00:00
D | 2022-05-23 00:00:00 | 2023-04-30 00:00:00 | Product Manager | Supply Chain |  |  |  |  |  | 2020-12-01 00:00:00 | 2023-04-30 00:00:00
D | 2020-12-01 00:00:00 | 2022-05-22 00:00:00 | Product / Service Owner | Supply Chain |  |  |  |  |  | 2020-12-01 00:00:00 | 2023-04-30 00:00:00
E |  |  | Engineer | Engineering 2 |  |  |  |  |  | 2023-10-01 00:00:00
E | 2023-10-01 00:00:00 | 2023-11-10 00:00:00 | Engineer | Engineering 2 |  |  |  |  |  | 2023-10-01 00:00:00
E | 2020-12-01 00:00:00 | 2022-05-31 00:00:00 | Engineer | Engineering 2 |  |  |  |  |  | 2020-12-01 00:00:00 | 2022-05-31 00:00:00
Spreadsheet: 175629d1345582734-multiple-criteria-to-produce-one-output-match-and-vlookup-example
Sheet: Inputs

 |  |  |  |  |  | Outputs
 |  |  |  |  |  | A | y
 |  |  |  |  |  | B | 41
 |  |  |  |  |  | C | 40
 |  |  |  |  |  | D | 42
 |  |  | Country | China |  | E | 43
 |  |  | Type | y |  | F | 44
 |  |  |  |  |  | G | 45
 |  |  |  |  |  | H | 46
 |  |  |  |  |  | J | 47
 |  |  |  |  |  | K | 48
 |  |  |  |  |  | L | 49
Spreadsheet: 118551d1313755805-re-extracting-data-from-multiple-sheets-rows-opennumbers
Sheet: Data2

Example 2 |  |  |  |  |  |  | key
7 | Closed |  |  |  |  |  | 3
8 | Open |  |  |  |  |  | 4
9 | Closed |  |  |  |  |  | 4
10 | Closed |  |  |  |  |  | 4
11 | Closed |  |  |  |  |  | 4
12 | Open |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
Spreadsheet: 693292d1598901046-really-need-help-with-sum-going-insane-over-this-book1-index-and-frequency-1-
Sheet: Sheet1

 | B | c
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2491
 | 1005 | 2491
 | 1005 | 2491
 | 1005 | 188
 | 1005 | 188
 | 1005 | 190
 | 1005 | 190
 | 1005 | 190
 | 1005 | 190
 | 1016 | 1395
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 796
 | 1017 | 800
 | 1017 | 800
 | 1017 | 800
 | 800 | 650
 | 750 | 600
 | 1005 | 2488
 | 1005 | 2489
Spreadsheet: 329327d1404271629-formula-column-referenced-to-value-in-cell-test-book
Sheet: Data

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
56635 | AAA | 123 | CA | SCE |  | x | 2014-01-28 00:00:00 | 2014-01-29 00:00:00 | 2014-05-05 00:00:00 | 2014-03-11 00:00:00 | 2014-03-28 00:00:00 | 2014-04-07 00:00:00 | 2014-04-26 00:00:00 | 2014-04-28 00:00:00 | 2014-04-28 05:00:00
64249 | BBB | 456 | CA | SCE |  | y | 2014-05-01 00:00:00 | 2014-05-06 00:00:00 | 2014-06-05 00:00:00 | 2014-03-11 00:00:00 | 2014-03-28 00:00:00 | 2014-04-07 00:00:00 | 2014-04-26 00:00:00 | 2014-04-28 00:00:00 | 2014-04-28 05:00:00
64246 | CCC | 789 | CA | SDG&E |  | z | 2014-04-25 00:00:00 | 2014-05-06 00:00:00 | 2014-04-01 00:00:00 | 2014-03-11 00:00:00 | 2014-03-28 00:00:00 | 2014-04-07 00:00:00 | 2014-04-26 00:00:00 | 2014-04-28 00:00:00 | 2014-04-28 05:00:00
Spreadsheet: benjamin_rogers__1054__Consolidated 6 Peaker-062000
Sheet: Gleason

INCOME STATEMENT - GLEASON
('000 $)
Revenue
Fixed Price Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Energy Payment
Start Charge
Amortization of Power Contract
Merchant Period:
Demand Payment | 0 | 0 | 0
Variable Revenue | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major [NAME]
Owner's Expense
Property Taxes Liability | 174.46 | 348.92 | 436.15 | 436.15 | 436.15 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 872.3 | 872.3 | 1308.45 | 743.9310449999999 | 758.8096658999999 | 773.985859218 | 789.4655764023599 | 805.2548879304072
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - GLEASON
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA less Amortization of Power Contract
Plus Property Tax Liability
Less Property Tax Expense | -92.2251014
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & FRANCHISE TAX - GLEASON
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Book Value of Assets
Paid-In-Capital
[NAME] (less Amortization of Power Contract)
Outstanding Debt
Total Capitalization
Greater of Book Value and Capitalization
State Franchise Tax Rate
State Franchise Tax Liability | 608.9882902589542 | 590.1536008695019 | 571.3189114800498 | 552.4842220905977 | 533.6495327011454 | 514.8148433116933 | 495.9801539222411 | 477.1454645327889 | 458.3107751433367 | 439.4760857538845 | 420.6413963644324 | 401.8067069749802 | 382.972017585528 | 364.1373281960758 | 345.3026388066236 | 326.4679494171715 | 307.6332600277193 | 288.7985706382671 | 269.963881248815 | 251.1291918593628
STATE TAXES
Pretax Book Income less Amortization of Power Contract
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Spreadsheet: 681072d1591343288-calculate-overlapping-date-range-and-amount-of-fte-k001_example-dates-fte-table
Sheet: Sheet1

 | name | start | end | amount of fte | contract fte
 | Tess | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | 0.5 | 0.9
 | Mark | 2020-06-01 00:00:00 | 2020-12-31 00:00:00 | 1 | 1
 | Tess | 2020-07-01 00:00:00 | 2020-06-30 00:00:00 | 0.8 | 0.9
 | [NAME] | 2020-08-01 00:00:00 | 2021-01-01 00:00:00 | 0.8 | 1
 | Mark | 2020-05-01 00:00:00 | 2020-10-05 00:00:00 | 1 | 1
Spreadsheet: 674435d1587837527-counting-colored-cells-count-colored-cells-test
Sheet: Tests

Unit # | Test 0 | Test 1 | Test 2 | Test 3
Unit 1 | Step 1 | Step 2 | Step 3 | Step 4
Unit 2 | Step 1 | Step 2 | Step 3 | Step4
Unit 3 | Step 1 | Step 3 | Step 4 | Step 5
Unit 4 | Step 1 | Step 3 | Step 4 | Step 5
Unit 5 | Step 1 | Step 3 | Step 4 | Step 5
Spreadsheet: 0d1a4d66-5ae4-4071-bdb8-6ae68929e571
Sheet: Sheet1

Ohio Physical Education Evaluation | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Standard 1 Individual Data (K-2) Benchmark A
Note: Advanced = 3 pts, Proficient = 2 pts, Limited = 1 pt, Non-Paticipatory = 0 pts
 | Student Name | Running | Skipping | Hopping | Gallop/Slide | Rolling | Balance | [NAME] | Average Score | Level
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
Spreadsheet: 44947d1243696581-how-can-i-tell-excel-to-recognise-0-5-as-30-minutes-hours-worked-messed-up-
Sheet: Sheet1

Week | Date | Day | Start Time | End Time | Total Hours | Break | Paid Hours | £ per hour | Money Earned
34 | 2009-04-19 00:00:00 | Sunday |  |  |  |  |  | 4.77
 | 2009-04-20 00:00:00 | Monday | 10:30:00 | 15:30:00 |  | 00:00:00 |  | 4.77
 | 2009-04-21 00:00:00 | Tuesday | 12:40:00 | 19:10:00 |  | 00:30:00 |  | 4.77
 | 2009-04-22 00:00:00 | Wednesday | 09:30:00 | 21:30:00 |  | 02:00:00 |  | 4.77
 | 2009-04-23 00:00:00 | Thursday | 12:00:00 | 21:30:00 |  | 01:30:00 |  | 4.77
 | 2009-04-24 00:00:00 | Friday | 09:30:00 | 16:00:00 |  | 00:30:00 |  | 4.77
 | 2009-04-25 00:00:00 | Saturday |  |  |  |  |  | 4.77
Total:
Spreadsheet: 877893d1724831766-splitting-out-data-from-1-cell-into-multiple-book2
Sheet: Sample

Date
2024-08-19 13:02:13 | _x0001_QU ANPOCVS .DDLMMXA 260254 _x0002_DFD FI XX25/AN X-XRNB DT DDL JFK 260253 U05A -  A350,000774,1,1,TB000000/ REP514,53,01;H01,514,53,01,4000,00192,.G-VRNB,5,0,26,06,24,02,53,09,130/ H02,---------,----------,S0285,S0585,CDA300823A/ H03,Automatic/ L1,102,097,178,189/ L2,087,083,191,195/ [NAME] : _x0003_
AX | LH GR 1 | LH GR 2 | RH GR 1 | RH GR 2 | RG | FN | Date
L1 | 102 | 97 | 178 | 189 | X-XRNB | XX25 | 2024-08-19 00:00:00
L2 | 87 | 83 | 191 | 195
L3 | 88 | 93 | 196 | 194
Spreadsheet: 857730d1706660563-i-need-to-identify-that-all-the-diags-listed-to-the-left-are-captured-in-the-new-diags-identifyduplicateswithcdeandhghlght-1-
Sheet: Sheet9

[NAME] | Diag2 | Diag3 | Diag4 | Diag5 | Diag6 | Diag7 | Diag8 | Diag9 | Diag10 | Diag11 | Diag12 | Is this possible? | Duplicate Yes or No
M9901 | M5412 | M9902 | M62838 | M9903 | M545 | M9904 | M5417 |  |  |  |  | False
I129 | N182 | E559 | D509 | D509 |  |  |  |  |  |  |  | D509
M9901 | M5412 | M9902 | M62838 | M9903 | M545 | M9904 | M5417 |  |  |  |  | False |  |  |  |  | N182
J45909 | J449 | I10 | M160 | R05 | R062 |  |  |  |  |  |  | False |  |  |  |  | J45909
E039 | D7589 | E870 | E809 | E559 |  |  |  |  |  |  |  | False |  |  |  |  | J449
C679 | Z5111 | E860 | Z5111 |  |  |  |  |  |  |  |  | Z5111 |  |  |  |  | I10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M160
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R062
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E039
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D7589
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E870
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E809
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C679
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E860
Spreadsheet: 804117d1667904048-check-if-entire-row-meets-specific-text-then-insert-photo-if-row-meets-condition
Sheet: Sheet1

 | [NAME] | Training Subject |  | From | To | Score | Trainer
 | LICENSE | DRIVING |  | 2022-01-01 00:00:00 | 2022-01-12 00:00:00 | PASS | K
 | INTRO | DRIVING |  | 2022-03-01 00:00:00 | 2022-05-01 00:00:00 | 1 | A
 | EXPECTED OUTPUT
 | To insert this Photo (Certified) if the trainee has passed the Driving License
Spreadsheet: 780281d1652371451-return-value-from-1-of-2-columns-depending-on-the-header-based-on-2-criteria-front-cover-test
Sheet: Exchange Rates

Date | Wk No. | USD | EUR
2022-01-03 00:00:00 | 1 | 1.3739 | 1.2174
2022-01-10 00:00:00 | 2 | 1.386 | 1.2229
2022-01-17 00:00:00 | 3 | 1.3945 | 1.2218
2022-01-24 00:00:00 | 4 | 1.3811 | 1.2191
2022-01-31 00:00:00 | 5 | 1.3694 | 1.2265
2022-02-07 00:00:00 | 6 | 1.3817 | 1.208
2022-02-14 00:00:00 | 7 | 1.3808 | 1.217
2022-02-21 00:00:00 | 8 | 1.3899 | 1.2222
2022-02-28 00:00:00 | 9 | 1.3636 | 1.2194
2022-03-07 00:00:00 | 10 | 1.3482 | 1.2394
2022-03-14 00:00:00 | 11 | 1.3278 | 1.216
2022-03-21 00:00:00 | 12 | 1.3383 | 1.2206
2022-03-28 00:00:00 | 13 | 1.3399 | 1.2231
2022-04-04 00:00:00 | 14 | 1.3383 | 1.2121
2022-04-11 00:00:00 | 15 | 1.3267 | 1.2184
2022-04-18 00:00:00 | 16 | 1.327 | 1.2304
2022-04-25 00:00:00 | 17 | 1.3 | 1.2116
2022-05-02 00:00:00 | 18 | 1.2759 | 1.2146
2022-05-09 00:00:00 | 19 | 1.252 | 1.1916
2022-05-16 00:00:00 | 20
2022-05-23 00:00:00 | 21
2022-05-30 00:00:00 | 22
2022-06-06 00:00:00 | 23
2022-06-13 00:00:00 | 24
2022-06-20 00:00:00 | 25
2022-06-27 00:00:00 | 26
2022-07-04 00:00:00 | 27
2022-07-11 00:00:00 | 28
2022-07-18 00:00:00 | 29
2022-07-25 00:00:00 | 30
2022-08-01 00:00:00 | 31
2022-08-08 00:00:00 | 32
2022-08-15 00:00:00 | 33
2022-08-22 00:00:00 | 34
2022-08-29 00:00:00 | 35
2022-09-05 00:00:00 | 36
2022-09-12 00:00:00 | 37
2022-09-19 00:00:00 | 38
2022-09-26 00:00:00 | 39
2022-10-03 00:00:00 | 40
2022-10-10 00:00:00 | 41
2022-10-17 00:00:00 | 42
2022-10-24 00:00:00 | 43
2022-10-31 00:00:00 | 44
2022-11-07 00:00:00 | 45
2022-11-14 00:00:00 | 46
2022-11-21 00:00:00 | 47
2022-11-28 00:00:00 | 48
2022-12-05 00:00:00 | 49
2022-12-12 00:00:00 | 50
2022-12-19 00:00:00 | 51
2022-12-26 00:00:00 | 52
Spreadsheet: louise_kitchen__23100__0112MarginRequirements
Sheet: Template

FUTURES MARGIN REQUIREMENTS
2001-12-10 00:00:00
2001-12-07 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$ |  | US $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | TE | Initial Margin | OTE
ABN-Amro Inc |  |  |  | 0
ADM INVESTOR |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
BANK ONE |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
CARR FUTURES (NG) |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
CARR FUTURES INC. |  |  |  | 0
CREDIT SUISSE FIRST BOSTON |  |  |  | 0
EDF MAN
FIMAT |  |  |  | 0 |  |  |  | 1
HSBC - US$ |  |  |  | 0
HSBC - Canadian | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
JP Morgan |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
PARIBAS |  |  |  | 0
PRUDENTIAL SI |  |  |  | 0
REFCO, INC |  |  |  | 0
R J O'BRIEN |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
SAUL STONE & COMPANY |  |  |  | 0
SMITH BARNEY, INC |  |  |  | 0
SMITH BARNEY, INC  (Financial) |  |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: 200161d1355434657-formula-to-calculate-years-of-service-for-next-year-vacation-days-accured
Sheet: VacationTable

Years of Service | Vacation Days |  |  |  |  | New Employee
1 | 10 |  |  |  |  | Calendar Month of Hire | Vacation Days
2 | 10 |  |  |  |  | January | 10
3 | 10 |  |  |  |  | February | 9
4 | 10 |  |  |  |  | March | 8
5 | 10 |  |  |  |  | April | 7
6 | 15 |  |  |  |  | May | 6
7 | 15 |  |  |  |  | June | 5
8 | 15 |  |  |  |  | July | 4
9 | 15 |  |  |  |  | August | 3
10 | 15 |  |  |  |  | September | 2
11 | 15 |  |  |  |  | October | 1
12 | 15 |  |  |  |  | November | 0
13 | 15 |  |  |  |  | December | 0
14 | 20
15 | 20
16 | 20
17 | 20
18 | 20
19 | 20
20 | 20
Spreadsheet: 781369d1653287022-if-a-match-map-information-from-one-sheet-to-another-sample-task
Sheet: Tabelle1

Number | Code | Match | Street | # | Postal Code | City | Code | Match | Street | # | Postal Code | City
1 | 1234 | Yes | TTSS | 12 | 3455 | NNN | 232455 | Yes | wwdd | 45 | 35566 | tzhj
1 | 2345 | No |  |  |  |  | 907654 | empty | empty | empty | empty | empty
1 | 24533 | No |  |  |  |  | 456567 | empty | empty | empty | empty | empty
1 | 232455 | Yes | wwdd | 45 | 35566 | tzhj | 123789 | empty | empty | empty | empty | empty
1 | 232321 | No |  |  |  |  | 12332456 | Yes | ssdd | 49 | 1234 | huer
1 | 12332456 | Yes | ssdd | 49 | 1234 | huer | 21123233 | empty | empty | empty | empty | empty
1 |  |  |  |  |  |  | 1234 | Yes | TTSS | 12 | 3455 | NNN
1
1
1
1
1
Original Source |  |  |  |  |  |  | Should be in new Sheet
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Managed Care

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Referrals
Activity Name | Managed Care
Activity Description / Purpose | Managed Care is a term that is used to describe a health insurance plan or health care system that coordinates the provision, quality and cost of care for its enrolled members
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Assist client/customer in selecting a regular doctor, called a primary care practitioner (PCP)
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 791471d1660376183-sorting-formulated-values-for-ranking-score-chart-ans
Sheet: 2021

Insert shifts in the box to the right |  | BMS 1 | BMS 2 | BMS 3 | BMS 4 | BMS 5 | BMS 6 | BMS 7 | BMS 8 | BMS 9 | BMS 10 | BMS 11 | BMS 12 | BMS 13 | BMS 14 | BMS 15 |  | Date | LD | N | SB |  |  |  |  | Rank | Column1 | Column2 | BMS | Score
Friday | 2021-12-17 00:00:00 |  | LD |  | LD |  | N |  | LD | LD | LD |  | N | LD |  | LD |  |  | 1 | 1 | 0.5 |  | Column1 | Column2
Saturday | 2021-12-18 00:00:00 |  | LD |  |  | LD |  |  |  |  | N |  | N | N | LD | LD |  |  | 1 | 1 | 0.5
Sunday | 2021-12-19 00:00:00 |  |  |  |  | N |  |  |  |  |  |  | N | N | LD | LD |  |  | 1 | 1 | 0.5
Monday | 2021-12-20 00:00:00 |  |  | N |  |  |  | LD |  | N | LD | SB |  |  | LD |  |  |  | 1 | 1 | 0.5
Tuesday | 2021-12-21 00:00:00 |  |  | N |  | LD |  |  | LD |  | LD | N |  |  | LD |  |  |  | 1 | 1 | 0.5
Wednesday | 2021-12-22 00:00:00 | N | LD |  |  | LD |  | LD |  | SB |  |  | LD |  | N |  |  |  | 1 | 1 | 0.5
Thursday | 2021-12-23 00:00:00 | N | LD |  |  | LD |  | LD | SB |  |  |  | LD |  | N |  |  |  | 1 | 1 | 0.5
Friday | 2021-12-24 00:00:00 |  | N |  |  | LD |  |  | LD |  | SB | LD | N | SB |  |  |  |  | 3.5 | 4 | 2
Saturday | 2021-12-25 00:00:00 |  | N |  |  |  |  |  | LD |  | LD | SB | N | SB |  |  |  |  | 4 | 5 | 2
Sunday | 2021-12-26 00:00:00 |  | N |  |  |  |  | N | LD |  | LD |  | N | SB |  |  |  |  | 4 | 5 | 0.5
Monday | 2021-12-27 00:00:00 |  |  | N |  | LD |  | N | LD |  |  |  |  |  |  |  |  |  | 1.5 | 2.5 | 0.5
Tuesday | 2021-12-28 00:00:00 | LD |  |  |  |  | LD | N |  |  |  | N |  |  |  |  |  |  | 2 | 3 | 0.5
Wednesday | 2021-12-29 00:00:00 | N |  |  |  |  |  |  | SB |  | LD | N |  | LD | LD |  |  |  | 2 | 3 | 0.5
Thursday | 2021-12-30 00:00:00 | N |  |  | LD |  |  |  | LD |  | SB | N |  | LD | SB |  |  |  | 1 | 2 | 0.5
Friday | 2021-12-31 00:00:00 |  | LD |  | N | N | SB | SB | LD |  | LD |  |  |  |  |  |  |  | 2.5 | 3.5 | 1
Saturday | 2022-01-01 00:00:00 |  |  |  | N | N |  | LD |  |  | SB |  |  | LD |  |  |  |  | 1 | 2 | 1.5
Sunday | 2022-01-02 00:00:00 |  |  |  | N |  | LD | LD |  |  |  |  |  | N | SB |  |  |  | 1 | 1 | 0.5
Monday | 2022-01-03 00:00:00 | LD | N |  |  | LD |  | LD | N |  |  | LD |  |  |  |  |  |  | 1 | 1 | 0.5
Tuesday | 2022-01-04 00:00:00 | LD | N |  | LD | LD |  | LD | N |  | LD | LD |  | LD |  |  |  |  | 1 | 1 | 0.5
Scoring chart
Score
Rank
Spreadsheet: 877141d1723817032-calculate-age-group-from-date-of-birth-jonmuir-example-for-age-group-365-aligw
Sheet: Sheet1

Name | BoD | Age Group |  |  |  | Age Group | Starts
[NAME] | 2000-01-01 00:00:00 |  |  |  |  | U11
[NAME] | 2011-09-05 00:00:00 |  |  |  |  | U13 | 2011-09-01 00:00:00
[NAME] | 2013-07-31 00:00:00 |  |  |  |  | U15 | 2009-09-01 00:00:00
[NAME] | 2015-01-28 00:00:00 |  |  |  |  | U17 | 2007-09-01 00:00:00
[NAME] | 2011-12-15 00:00:00 |  |  |  |  | U20 | 2005-09-01 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: 08e4f9fa-d052-406c-bb24-fda017605dbc
Sheet: کاربری اراضی

 | [NAME] در ناحیه 7
 | ردیف | نوع کاربری | [NAME] (متر مربع) | سرانه وضع موجود
 | 1 | مسکونی | 2971200 | 20.53
 | 2 | تجاری | 52700 | 0.36
 | 3 | اداری | 15100 | 0.1
 | 4 | آموزشی | 108100 | 0.75
 | 5 | بیمارستانی
 | 6 | بهداشتی و درمانی | 2400 | 0.01
 | 7 | فرهنگی و مذهبی | 41200 | 0.28
 | 8 | نظامی | 9900 | 0.07
 | 9 | ورزشی | 52400 | 0.36
 | 10 | فضای سبز | 1407674 | 9.73
 | 11 | تاسیسات و تجهیزات | 75600 | 0.52
 | 12 | حمل و نقل | 296200 | 2.05
 | 13 | متروکه و بایر | 972000 | 6.72
 | 14 | [NAME] رو | 352856 | 2.44
 | 15 | [NAME] رو | 1464425 | 13.5
 | 16 | سایر
 | مجموع
Spreadsheet: 883304d1731899455-formula-to-find-the-total-of-stock-according-to-date-stock-control
Sheet: Joe

Date | Stock | Quantity | Price | Total
2024-11-15 00:00:00 | Tea bag | 5
2024-11-15 00:00:00 | Pop Me | 2
2024-11-18 00:00:00 | Ramen | 1
2024-11-18 00:00:00 | Bongo (B) | 1
2024-11-18 00:00:00 | Milo | 1
Spreadsheet: 774823d1648670995-making-countif-summarize-part-of-the-cell-summarysample
Sheet: Sheet1

[NAME] | NM1_G2 | [NAME] | [NAME] | NM1_G5 | [NAME] | NM1_G7 | NM1_G8 | INV_L01 | [NAME] | INV_L02 | CNT_L02 | INV_L03 | CNT_L03 | INV_L04 | CNT_L04 | INV_P01 | CNT_P01 | INV_P02 | CNT_P02 | INV_P03 | CNT_P03 | INV_P04 | CNT_P04
L01-2 | L02-1 | L03-1 | L04-1 | P01-2 | P02-1 | P03-1 | P04-1
L01-3 | [NAME] | L03-1 | L04-1 | P01-2 | P02-1 | P03-1 | P04-1
L01-1 | L02-1 | L03-1 | P01-2 | P02-4 | P03-1 | P04-1
L01-5 | L02-1 | L03-1 | P01-2 | P02-1 | P03-1 | P04-1