tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 770795d1646253591-working-time-directive-calculations-timesheet2
Sheet: 29-11-21

 | HMP BARLINNIE ESTATES |  |  |  |  | Week No. |  |  |  |  | Week Commencing |  |  |  |  |  |  | On Call Engineer |  |  | G McDade / S Barcaly
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On Call Manager |  |  | [NAME]
Toil | Name | Leave | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  | SUNDAY |  | Signature | leave |  | toil
 |  |  | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | O/T | TOIL | O/T | TOIL |  | Total | Balance | Total | Balance | total from last week | total leave taken
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 0 |  |  | AL | 0 |  |  | AL | 0 |  |  | AL |  |  |  |  | Leave
 | [NAME] |  | 0 |  |  | AL | 7.5 |  |  |  | 7.5 |  |  | TR | 7.5 |  |  |  | 7
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7 |  | 4 |  | 8 |  | 12 |  | Leave
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7 |  |  |  |  | 2.5 |  | 3
 | [NAME] |  | 7.5 |  |  |  | 4 |  |  | 3hrs | 7.5 |  |  |  | 7.5 |  |  |  | 7 | 2
 | [NAME] |  | 7.5 |  |  | TR | 0 |  |  | AL | 0 |  |  | AL | 0 |  |  | AL | 7 |  |  | TR
 | [NAME] |  | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK |  |  |  |  | Sick
 | [NAME] |  | 0 |  |  | AL | 0 |  |  | AL | 0 |  |  | AL | 0 |  |  | AL | 0 |  |  | AL
 | [NAME] |  | 0 |  |  | AL | 0 |  |  |  | 0 |  |  | 1/2 AL | 0 |  |  | SK | 0 |  |  | SK |  |  |  |  | Sick | 1.5
 | SUNDAY | O/T |  | G McDade - Overtime - hosereels - 889200 & Call out to SRU Drains ……………………
 |  | TOIL |  | S Robson - Escorting trident to paint walls - 891545
Spreadsheet: 390386d1429619847-please-help-me-formula-for-sum-for-text-and-number-in-same-cells-new-microsoft-excel-worksheet
Sheet: Sheet3

 |  | [NAME]
 | apple | 1 FULL CD
 | salads | 1/2CD 2
 | rice | 5 BOWLS
 | pineapple | 5 BOWLS +1 3500HP
 | ICEREAM | 1/4CD 2  +5 BOWLS
 | CURRY | 5 BOWLS
 | PASTRY | 1/4CD 2
 | MUTTON CHOP | 1 5000HP
 | TOTAL NUMBER | ?
 |  |  | C10=29
 | FULL CD, 1/2CD, 1/4CD,3500HP,5000HP ARE TEXT,I HAVE FURTHER MORE VALUE LIKE 17000HP,8000KUBBA,7500HP ,2500HP TEXT .
Spreadsheet: 598989d1542813648-if-formula-help-amortization-formulas-50
Sheet: Amortization

Excel Amortization [NAME]
HELP |  |  |  |  |  |  |  |  | © 2005-2018 Vertex42 LLC
 | Inputs
 |  |  |  |  |  | 30
 |  | Loan Amount | 125000
 |  | Annual Interest Rate | 0.07
 |  | Term of Loan in Years | 1
 | Summary
 |  | Monthly Payment
 |  | # of Payments
 |  | Total Payment
 |  | Total Interest |  |  |  |  |  |  | [42]
Month | Payment | Interest | Principal | Balance
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
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
Spreadsheet: 218167d1362379812-index-or-vlookup-sample1
Sheet: Sheet1

[NAME] | WEEK 1
Name |  |  |  |  |  |  | AVERAGE
 | 2013-03-01 00:00:00 | 2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00 | 2013-03-07 00:00:00 | 2013-03-08 00:00:00
Sample 1
Sample 2
Sample 3
Sample 4
Sample 5
Sample 6
Sample 7
Sample 8
Sample 9
Sample 10
Sample 11
Sample 12
Sample 13
Sample 14
Sample 15
Spreadsheet: 0dd70c0b-0342-4e9d-a413-a307dfc46740
Sheet: Example

 |  | EXAMPLE AUDIT |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | This audit is only an example to give you an idea of what an audit should look like. |  |  |  |  |  |  |  |  |  |  |  |  | Main Menu
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Return To AA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Return To AS
 |  | Associate In Science
 |  | 2012 - 2013
 |  | NAME: | [NAME] |  |  |  | DATE: |  | 2012-02-09 00:00:00
 |  | ID: | 000000000 |  |  |  | FOCUS: |  | None
 |  | CATEGORY I:  General Education Core |  |  |  |  |  |  | Hours: |  | /33
 |  |  |  |  | Course | Credit | Grade |  | Course | Credit | Grade
 |  | Communication - Written (6) |  |  | ENG 101 | 3 | B
 |  | Communication - Oral (3) |  |  |  |  |  |  | COM 252 | 3 | IPS
 |  | Arts & Humanities - Heritage (3) |  |  |  |  |  |  | HIS 104 | 3 | A
 |  | Arts & Humanities - Humanities (3) |  |  |  |  |  |  | ART 105 | 3 | B
 |  | Social & Behavioral Sciences (6) |  |  | ANT 220 | 3 | A
 |  | Natural Sciences (6) |  |  | AST 192 | 3 | B
 |  | Quantitative Reasoning (6) |  |  | MAT 150 | 3 | B |  | MA 113 | 3 | A
 |  | CATEGORY II:  Associate In Science Requirements |  |  |  |  |  |  | Hours: |  | /12
 |  |  |  |  |  |  |  |  | Course | Credit | Grade
 |  | Quantitative Reasoning/Natural Sciences (6) |  |  |  |  |  |  | AST 191 | 3 | IPS
 |  |  |  |  |  |  |  |  | GER 101 | 3 | TRN
 |  | General Education Core/Foreign Languages (6) |  |  |  |  |  |  | SPA 101 | 3 | IPS
 |  |  |  |  |  |  |  |  | HIS 105 | 3 | A
 |  | CATEGORY III:  Electives |  |  |  |  |  |  | Hours: |  | /15
 |  |  |  |  | Course | Credit | Grade |  | Course | Credit | Grade
 |  | Electives (15) |  |  | AHS 115 | 3 | A
 |  | Credits Summary |  |  | Total Credits: |  |  |  | Earned Credits:
 |  |  |  |  | Additional Credits: |  |  |  | Credits IPS:
 |  | Additional Graduation Requirements
 |  | 1.  Student must take one approved Cultural Studies course. |  |  |  |  |  |  |  | ANT 160
 |  | 2.  Student must take Social & Behavioral Science courses from at least two disciplines. |  |  |  |  |  |  |  | Incomplete
 |  | 3.  Student must take at least one Science Lab.
 |  | 4.  Student must demonstrate Computer Literacy.
 |  | 5.  Student must earn a minimum of sixty (60) credit hours for a degree. |  |  |  |  |  |  |  |  | /60
 |  | 6.  Student must earn at least fifteen (15) credit hours at BCTC. |  |  |  |  |  |  |  |  | /15
 |  | 7.  Student must have a cumulative GPA of 2.0 to earn a degree. |  |  |  |  |  |  |  |  | /4.0
 |  | Notes
 |  | Auditor: | [NAME] |  |  |  | E-mail: | [EMAIL] |  |  |  |  | Return To Main Menu
 |  | Still have questions?
 |  | Contact Nate Smith
 |  | [EMAIL]
Spreadsheet: 798850d1664785290-first-instance-of-number-less-than-or-equal-to-number-w-other-conditions-example-oct-2
Sheet: Sheet1

 |  |  | Number | Desired Result
2022-09-01 00:00:00 | 1 |  | 2.7
2022-09-02 00:00:00 | 2
2022-09-03 00:00:00 | 2
2022-09-04 00:00:00 | 3
2022-09-05 00:00:00 | 4
2022-09-06 00:00:00 | 3
2022-09-07 00:00:00 | 2
2022-09-08 00:00:00 | 2
2022-09-09 00:00:00 | 3
2022-09-10 00:00:00 | 4
2022-09-11 00:00:00 | 4
2022-09-12 00:00:00 | 2
2022-09-13 00:00:00 | 2
2022-09-14 00:00:00 | 3
2022-09-15 00:00:00 | 4
Spreadsheet: 599058d1542839147-copying-data-but-removing-ignoring-cells-which-contain-specific-text-excel-example
Sheet: Sample D

 |  |  |  |  |  |  |  | Checked?
Make
Model
Variant |  |  |  |  |  | TOTAL PRICE |  |  | (Retail inc VAT) |  |  |  |  |  |  | Front suspension setup (1)
Year (cat, guide only) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Front suspension setup (1)
Engine |  |  |  |  |  | NO OF ITEMS |  |  |  |  |  |  |  |  |  | Rear Suspension Setup (1)
Wheelbase |  | (SWB/MWB/LWB/Blank) |  |  |  |  |  |  |  |  |  |  |  |  |  | Rear Suspension Setup (2)
Drive Side |  | (LHD/RHD/Both/Blank) |  |  |  |  | ALL PRICES IN GBP
Weight
[NAME] (mm) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (static text for formulas) | *******DELETE THIS ROW*******
 | FRONT |  |  |  | REAR
(add description for mandatory parts below) | FRONT | Type (C/L/T) | FRONT QTY | FRONT UNIT PRICE | REAR | Type (C/L/T) | REAR QTY | REAR UNIT PRICE | ROW  TOTAL |  |  |  |  |  |  |  | Copy the data below when listing
Springs/Torsion Bars | CS123FA | L | 2 | 150.2 | 2964 | C | 1 | 99.78 |  |  |  |  | 1 | Front | Spring 1
Springs/Torsion Bars |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Front | Spring 2
Nitrocharger Shocks/Struts | 60123 |  | 2 | 99.55 | 60548 |  | 2 | 105.65 |  |  |  |  | 3 | Rear | Spring 1
U Bolts | OMEU123 |  | 4 | 6.59 |  |  |  |  |  |  |  |  | 4 | Rear | Spring 2
Spring Bush Kits | OMESB12 |  | 2 | 23.65 |  |  |  |  |  |  |  |  | 5 | Front | Shocks
Greasable Shackle Kit | OMEGS34 |  | 1 | 123.78 |  |  |  |  |  |  |  |  | 6 | Rear | Shocks
ACC 1 | AA |  | 1 | 5.55 |  |  |  |  |  |  |  |  | 7 | Front | U bolts
ACC 2 | BB |  | 1 | 6.66 |  |  |  |  |  |  |  |  | 8 | Rear | U bolts
ACC 3 | CC |  | 2 | 7 |  |  |  |  |  |  |  |  | 9 | Front | [NAME]
ACC 4 | DD |  | 1 | 6.88 |  |  |  |  |  |  |  |  | 10 | Rear | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | Front | Shackles
NOTES |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Rear | Shackles
 |  |  |  |  |  |  |  |  |  |  |  |  | 13 | Front | ACC1
Cells Q13 to Q32 are populated by formulas.  The objective is to copy/paste this data into entries R13 to R32, but to remove all cells which contain DELETE THIS ROW. |  |  |  |  |  |  |  |  |  |  |  |  | 14 | Rear | ACC1
 |  |  |  |  |  |  |  |  |  |  |  |  | 15 | Front | [NAME]
In addition to the above, I want to remove all empty cells so that the final data is contiguous and ready for copy/pasting into another application. |  |  |  |  |  |  |  |  |  |  |  |  | 16 | Rear | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 17 | Front | ACC3
Please note that not all DELETE THIS ROW entries are the same, some have other characters at the beginning. |  |  |  |  |  |  |  |  |  |  |  |  | 18 | Rear | ACC3
 |  |  |  |  |  |  |  |  |  |  |  |  | 19 | Front | ACC4
 |  |  |  |  |  |  |  |  |  |  |  |  | 20 | Rear | ACC4
Spreadsheet: 774159d1648248413-count-first-instance-in-series-above-a-condition-count-accelerations-only-once
Sheet: Sheet1

Acceleration | Helper1 | Helper2
0.831396818 |  |  |  | Answer
1.749603987
2.432745457
2.874011517
3.082041025
3.082629681
2.915354013
2.620022297
2.236617327
1.8116467
0.831396818
1.749603987
2.432745457
2.874011517
3.082041025
3.082629681
2.915354013
2.620022297
2.236617327
1.8116467
0.831396818
1.749603987
2.432745457
2.874011517
3.082041025
3.082629681
2.915354013
2.620022297
2.236617327
1.8116467
Spreadsheet: 39cf4fb4-6e63-402f-b7a3-31f60caf01ff
Sheet: Sheet1

Brock University | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Financial and Administrative Services
WIRE PAYMENT DOCUMENTATION
This banking information is mandatory for all wire transfers. This document would
accompany the Purchase Order, Invoice, Cheque Requisition or other applicable
payment form.
Please Note: The beneficiary name MUST match the name on the bank account or the bank will not process payment
PAYMENT INFORMATION
Amount of Wire:* |  |  | Date Req'd
Currency* |  |  |  | [NAME]/dd/yyy
[NAME] (PAYEE) INFORMATION
Name:*
Address 1:*
Address 2:
City* |  |  | PC/ZIP*
Country*
BENEFICIARY'S BANK INFORMATION
Beneficiary's Account Number: *
Name:*
Address 1:*
Address 2:
City* |  |  | PC/ZIP*
Country*
Bank Transit Number** |  |  | * Required information
Bank Institution Code**
Swift Code** |  |  | **Minimum information is (1) Transit Number AND Institution Code OR (2) Swift Code
IBAN No.:**
BIC No.**
Any Other Bank Information available (please provide as many details as possible)
INFORMATION TO PAYEE
Invoice No.*
Purchase Order No.
Additional Information
Spreadsheet: 823917d1680194764-populating-a-value-based-on-a-series-of-data-budget
Sheet: Sheet1

The following are the TYPES of selections I would have the option of choosing per employee.  Note for this first set of data, the options are by column
Insurance Selection | Employee Type | Coverage Selected | Healthcare Selection
Healthcare | Hourly | Employee Only | Standard
Dental | Salary | Employee & Spouse | Buy Up Plan
Vision |  | Employee and Children
 |  | Employee & Family
 |  | Waived
This next set of data would be the amounts that I am looking to populate based on the data chosen from above
Healthcare | Standard | Type | Employee Only | Employee & Spouse | Employee and Children | Employee & Family | Waived
healthcare | Hourly Employee | Standard | 84.42 | 226.41 | 135.91 | 257.75 | 0
healthcare | [NAME] | Standard | 91.45 | 245.28 | 147.23 | 279.24 | 0
healthcare | Hourly Employee | Buy Up | 123.6 | 260.49 | 250.17 | 372.03 | 0
healthcare | [NAME] | Buy Up | 133.61 | 282.2 | 271.03 | 403.03 | 0
dental | Hourly Employee | NA | 4.19 | 8.56 | 15.81 | 15.81 | 0
dental | [NAME] | NA | 4.55 | 9.28 | 17.13 | 17.13 | 0
vision | Hourly Employee | NA | 4.54 | 7.47 | 7.41 | 11.95 | 0
vision | [NAME] | NA | 4.92 | 8.1 | 8.03 | 12.95 | 0
Sample of data I would like to populate - I highlighted different colors from the above table to show my expected value
Employee Name | Employee Type | Healthcare | Type | Expected Value | Dental | Type | Expected | Vision | Type | Expected
[NAME] | [NAME] | Employee Only | Standard |  | Employee & Spouse | NA |  | Employee & Family | NA
[NAME] | Hourly Employee | Employee & Family | Buy Up |  | Employee Only | NA |  | Waived | NA
Spreadsheet: 35fa48fa-dd93-41cc-80d2-2e791be81d1a
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
 | 8731.0 Building Approvals, Australia
 | TABLE 20. Number of Dwelling Units Approved in New Residential Buildings, Original - Australia
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
Number of Dwelling Units ;  New ;  Total houses ; |  |  | Original | A418403T | 1956-01-01 00:00:00 | 2011-06-01 00:00:00 | 666 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Semi-detached, row or terrace house, townhouse with one storey and similar ; |  |  | Original | A415785F | 1991-07-01 00:00:00 | 2011-06-01 00:00:00 | 240 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Semi-detached, row or terrace house, townhouse with two or more storeys ; |  |  | Original | A422926F | 1991-07-01 00:00:00 | 2011-06-01 00:00:00 | 240 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total semi-detached, row or terrace houses, townhouses and similar ; |  |  | Original | A416421K | 1991-07-01 00:00:00 | 2011-06-01 00:00:00 | 240 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Flat, unit or apartment in a building of one or two storeys ; |  |  | Original | A423529V | 1991-07-01 00:00:00 | 2011-06-01 00:00:00 | 240 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Flat, unit or apartment in a building of three storeys ; |  |  | Original | A424174L | 1991-07-01 00:00:00 | 2011-06-01 00:00:00 | 240 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Flat, unit or apartment in a building of four or more storeys ; |  |  | Original | A424726X | 1991-07-01 00:00:00 | 2011-06-01 00:00:00 | 240 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total flats, units or apartments, excl. [NAME] flats and other/unknown ; |  |  | Original | A417063R | 1991-07-01 00:00:00 | 2011-06-01 00:00:00 | 240 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total other residential building ; |  |  | Original | A419138J | 1970-07-01 00:00:00 | 2011-06-01 00:00:00 | 492 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total residential building ; |  |  | Original | A419824J | 1956-01-01 00:00:00 | 2011-06-01 00:00:00 | 666 | Number | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 214434d1360912366-vlookup-with-multiple-conditions-sample
Sheet: SampleData

Name | School | Grade | Class | Gender | Unit Name | Skill | Outcome | Date | Score | Comments | % Score |  |  |  |  | Skill | Emerging | Developing | Achieved |  |  | 1 |  | Emerging | 0.1 | 1
AAAA | XXXX | 2 | Section 2A | Male | fjdfl;;fvf | Cognitive Development | Outcome 1 | July 2012 | 1 | Emerging |  |  |  |  |  | Cognitive Development | 0.1 | 0.4 | 0.5 |  |  | 2 |  | Developing | 0.2 | 2
AAAA | XXXX | 2 | Section 2A | Male | fjdfl;;fvf | Cognitive Development | Outcome 2 | July 2012 | 1 | Emerging |  |  |  |  |  | Motor Development | 0.2 | 0.35 | 0.45 |  |  | 3 |  | Achieved | 0.3 | 3
AAAA | XXXX | 2 | Section 2A | Male | fjdfl;;fvf | Cognitive Development | Outcome 3 | July 2012 | 1 | Emerging |  |  |  |  |  | Personal Development | 0.2 | 0.35 | 0.45 |  |  |  |  | Mastery | 0.4 | 4
AAAA | XXXX | 2 | Section 2A | Male | fjdfl;;fvf | Motor Development | Outcome 1 | July 2012 | 2 | Developing |  |  |  |  |  | Social Development | 0.1 | 0.4 | 0.5
AAAA | XXXX | 2 | Section 2A | Male | fjdfl;;fvf | Motor Development | Outcome 2 | July 2012 | 2 | Developing
AAAA | XXXX | 2 | Section 2A | Male | fjdfl;;fvf | Motor Development | Outcome 3 | July 2012 | 2 | Developing
Spreadsheet: 815300d1674854707-sick-time-accrual-with-previous-year-carry-over-sick-time-calculator
Sheet: Richard Longo

Sick Time Calculated
Employee Name |  |  | Date of Hire | 2023 Used Sick Time | Previous Year Carry Over
[NAME] |  |  |  |  | 0
Payroll Week | Sunday-Saturday | Hours Worked | Yearly Total | [NAME] | Total Accrued Sick | Sick Used | Sick Available
Week Ending | 2023-01-07 00:00:00
Week Ending | 2023-01-14 00:00:00
Week Ending | 2023-01-21 00:00:00
Week Ending | 2023-01-28 00:00:00
Week Ending | 2023-02-04 00:00:00
Week Ending | 2023-02-11 00:00:00
Week Ending | 2023-02-18 00:00:00
Week Ending | 2023-02-25 00:00:00
Week Ending | 2023-03-04 00:00:00
Week Ending | 2023-03-11 00:00:00
Week Ending | 2023-03-18 00:00:00
Week Ending | 2023-03-25 00:00:00
Week Ending | 2023-04-01 00:00:00
Week Ending | 2023-04-08 00:00:00
Week Ending | 2023-04-15 00:00:00
Week Ending | 2023-04-22 00:00:00
Week Ending | 2023-04-29 00:00:00
Week Ending | 2023-05-06 00:00:00
Week Ending | 2023-05-13 00:00:00
Week Ending | 2023-05-20 00:00:00
Week Ending | 2023-05-27 00:00:00
Week Ending | 2023-06-03 00:00:00
Week Ending | 2023-06-10 00:00:00
Week Ending | 2023-06-17 00:00:00
Week Ending | 2023-06-24 00:00:00
Week Ending | 2023-07-01 00:00:00
Week Ending | 2023-07-08 00:00:00
Week Ending | 2023-07-15 00:00:00
Week Ending | 2023-07-22 00:00:00
Week Ending | 2023-07-29 00:00:00
Week Ending | 2023-08-05 00:00:00
Week Ending | 2023-08-12 00:00:00
Week Ending | 2023-08-19 00:00:00
Week Ending | 2023-08-26 00:00:00
Week Ending | 2023-09-02 00:00:00
Week Ending | 2023-09-09 00:00:00
Week Ending | 2023-09-16 00:00:00
Week Ending | 2023-09-23 00:00:00
Week Ending | 2023-09-30 00:00:00
Week Ending | 2023-10-07 00:00:00
Week Ending | 2023-10-14 00:00:00
Week Ending | 2023-10-21 00:00:00
Week Ending | 2023-10-28 00:00:00
Week Ending | 2023-11-04 00:00:00
Week Ending | 2023-11-11 00:00:00
Week Ending | 2023-11-18 00:00:00
Week Ending | 2023-11-25 00:00:00
Week Ending | 2023-12-02 00:00:00
Week Ending | 2023-12-09 00:00:00
Week Ending | 2023-12-16 00:00:00
Week Ending | 2023-12-23 00:00:00
Week Ending | 2023-12-30 00:00:00
Spreadsheet: 117378d1312747255-excel-chart-help-vi-need-help-in-making-chart-chart-should-take-the-last-12-value-chart-solution
Sheet: Sheet2

Data Range |  | Chart Select Range
251 | 1
378 | 2
261 | 3
283 | 4
472 | 5
347 | 6
420 | 7
271 | 8
408 | 9
380 | 10
448 | 11
341 | 12
366
452
414
403
250
100
Spreadsheet: 100545d1298904726-time-between-status-time-between-status
Sheet: Sheet1

Job # | Date #1 | Date #2 | Status 1 | Status 2
158716 | 2011-02-14 18:56:26 | 2011-02-14 21:03:43 | New | Waiting for Partner Quote
158716 | 2011-02-14 18:56:26 | 2011-02-16 20:50:33 | Waiting for Partner Quote | Partner [NAME] in SN
158716 | 2011-02-14 18:56:26 | 2011-02-17 20:22:16 | Partner [NAME] in SN | Partner Quote OK to Send
158716 | 2011-02-14 18:56:26 | 2011-02-21 20:46:51 | Partner Quote OK to Send | Quote at Customer
164752 | 2011-02-15 21:11:11 | 2011-02-16 14:29:20 | Partner Quote OK to Send | Partner [NAME] in SN
164752 | 2011-02-15 21:11:11 | 2011-02-16 14:41:24 | Partner [NAME] in SN | Quote at Customer
175544 | 2011-02-16 18:56:26 | 2011-02-16 21:02:43 | New | Waiting for Partner Quote
Spreadsheet: 869939d1716471294-formula-filter-test
Sheet: Analysis

Number | Early Learning | Workforce | Parents and Caregivers | Infrastructure | Public-Private Partnerships | Measurement | Quality assurance | Targeting vulnerable groups | Childcare | Healthcare | Nutrition | Social Services
1 | No | Yes | No | Yes | No | No | No | Yes | No | No | No | Yes
 | No | No | No | Yes | No | No | Yes | Yes | No | No | Yes | No
 | Yes | Yes | No | No | No | No | No | Yes | No | No | No | No
 | Yes | Yes | No | Yes | No | Yes | No | No | Yes | No | No | No
 | No | No | No | Yes | No | No | No | No | No | No | No | No
 | Yes | No | No | No | No | No | No | No | No | No | No | No
 | Yes | Yes | Yes | No | No | Yes | No | Yes | Yes | No | No | No
 | No | Yes | No | Yes | No | No | No | Yes | No | No | Yes | Yes
 | No | Yes | No | No | No | No | No | Yes | Yes | No | No | No
 | No | Yes | No | Yes | No | Yes | No | Yes | No | No | No | No
 | No | Yes | Yes | No | No | No | No | Yes | Yes | No | Yes | No
 | No | No | No | No | No | No | No | No | No | No | No | No
 | No | No | Yes | Yes | No | No | No | No | Yes | No | Yes | No
 | Yes | Yes | Yes | No | No | Yes | Yes | No | No | No | Yes | No
 | Yes | Yes | No | No | No | Yes | No | Yes | No | No | Yes | Yes
 | No | Yes | No | No | No | No | No | Yes | No | No | No | No
 | Yes | No | No | Yes | No | Yes | No | Yes | Yes | No | No | No
 | No | Yes | No | Yes | No | No | No | No | No | No | No | No
 | No | No | No | Yes | No | No | No | Yes | No | No | No | No
Spreadsheet: 757768d1638450813-filter-formula-over-multiple-sheets-permit-register-example-2-12-2021
Sheet: Job Register 2022

ABC Job Number | Address | Job Description | Client | Job Received | Quote Sent | Date of Confirmation  to Proceed | Permit Number | BUILDING PERMIT | OCCUPANCY PERMIT | Inspection Status | Job Notes | BP INVOICE | [NAME]
ABC-22001 | Address 1 | Description 1 | Client 1 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 001/001/2201 | READY
ABC-22002 | Address 2 | Description 2 | Client 2 | 2022-01-02 00:00:00 | 2022-01-02 00:00:00 | 2022-01-02 00:00:00 | 001/001/2202 | APPROVE
ABC-22003 | Address 3 | Description 3 | Client 3 | 2022-01-03 00:00:00 | 2022-01-03 00:00:00 | 2022-01-03 00:00:00 | 001/001/2203 | 2022-01-03 00:00:00 | OP
ABC-22004 | Address 4 | Description 4 | Client 4 | 2022-01-04 00:00:00 | QUOTE
ABC-22005 | Address 5 | Description 5 | Client 5 | 2022-01-05 00:00:00 | QUOTE
ABC-22006
ABC-22007
ABC-22008
ABC-22009
ABC-22010
ABC-22011
ABC-22012
[NAME]
ABC-22014
ABC-22015
ABC-22016
ABC-22017
ABC-22018
ABC-22019
ABC-22020