tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 144e2329-7233-4153-bbfc-2104f13c90a7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | DUBUQUE COUNTY | BUILDING LOG | J A N U A R Y   2012
DATE | NAME | ADDRESS | LEGAL DESCRIPTION | COST | FEE | TYPE | PERMIT # | PARCEL
2012-01-03 00:00:00 | FREIBURGER, TED & RHONDA | 17867 HABERKORN SHERRILL | NE NW SEC. 15 JEFFERSON | 60000 | EXEMPT | 60' X 80' SHED | 5846-11-215 | 05-15-100-002
2012-01-03 00:00:00 | MILE 600 INC. | 2581 S. WAUPETON RD. | WAUPETON RESORT SUB. #2, LOT 15 PRT GOV. LOT 1; | 15000 | 50 | 34' X 50' PAVILLION | 5855-12-001 | 01-30-251-003
 | P.J. & TINA ANGLIN | 3841 NORTHVIEW HAZEL GREEN
2012-01-05 00:00:00 | BARRY, PATRICIA | 8785 HAVENWOOD HGTS DBQ | [NAME] 2 SEC. 22 TABLE MOUND | 180000 | 75 | 29.5' X 40' ADDITION | 5856-12-002 | 15-22-226-002
2012-01-06 00:00:00 | SKROKA, CHUCK & COLLEEN | 2305 PASADENA | LOT 1-1 SE NW SEC. 6 VERNON | 250000 | EXEMPT | SFH | 5852-11-221 | 14-06-100-010
 | SKROKA, [NAME] | 11427 SKROKA LN EPWORTH
2012-01-17 00:00:00 | BERGFELD, DEAN & CHRISTY | 5101 MCCULLOUGH LN, BERNARD | LOT 1 BERGFELD'S SCHMIDT PLACE SEC. 1 PRAIRIE CREEK | 500000 | EXEMPT | MILK HOUSE/BARN | 5840-11-209 | 20-01-377-003
2012-01-17 00:00:00 | THOMPSON FAMILY HOLDINGS | 2710 6TH ST. SW CEDAR RAPIDS | LOT 2 KEY CITY PROPERTIES PLANT #3, SEC. 13 VERNON |  | 2 | OCCUPANCY PERMIT | 5857-12-003 | 14-13-180-001
 | DENNIS THOMPSON | HAWKEYE TRUCK TRAILER PEOSTA
2012-01-27 00:00:00 | BOYLE, JOHN & JUDITH | 22707 20TH AVE. BERNARD | LOT 2 BERINGER HOME PLACE SEC. 32 WHITEWATER | 190000 | EXEMPT | SFH | 5861-12-007 | 19-32-476-004
2012-01-27 00:00:00 | WELLING WALTER P.O.A. RAY VASKE | 32860 PETERSBURG RD. NEW VIENNA | SW SW SEC. 6 NEW WINE | 80000 | EXEMPT | 36' DIAMETER [NAME] | 5863-12-009 | 07-06-300-003
Spreadsheet: 187416d1350453517-help-with-look-up-functions-example17th
Sheet: Sheet10

Number | Box Number
912 | 635
130 | 597
186 | 792
272 | 93
910 | 468
393 | 179
540 | 184
212 | 732
870 | 963
838 | 149
262 | 705
875 | 443
685 | 950
536 | 373
722 | 841
392 | 799
638 | 158
998 | 639
837 | 83
244 | 237
159 | 750
200 | 384
29 | 807
763 | 946
124 | 225
103 | 269
493 | 702
682 | 304
291 | 531
Spreadsheet: 97529d1296674127-matching-information-between-two-list-sample-matching
Sheet: Sheet1

14P001 |  | 14C047
14P002 |  | 14FA1
14P1 |  | 14FA2
14P101 |  | 14FA3
14P160 |  | 14H1
14P161 |  | 14P001
14P163 |  | 14P002
14P178 |  | 14P1
14P195 |  | 14P101
14P1A |  | 14P156
14P1B |  | 14P160
14P2 |  | 14P161
14P205 |  | 14P163
14P206 |  | 14P165
14P211 |  | 14P178
14P227 |  | 14P191
14P229 |  | 14P195
14P241 |  | 14P1A
14P242 |  | 14P1B
14P243 |  | 14P2
14P247 |  | 14P205
14P248 |  | 14P206
14P273 |  | 14P211
14P275 |  | 14P227
14P276 |  | 14P229
14P277 |  | 14P232
14P278 |  | 14P241
14P279 |  | 14P242
14P280 |  | 14P243
14P281 |  | 14P246
14P283 |  | 14P247
14P285 |  | 14P248
14P285B |  | 14P273
14P285C |  | 14P275
14P286 |  | 14P276
14P286B |  | 14P277
14P286C |  | 14P278
14P287 |  | 14P279
14P288 |  | 14P280
14P291 |  | 14P281
14P292 |  | 14P283
14P293 |  | 14P285
14P294 |  | 14P285B
14P295 |  | 14P285C
14P350 |  | 14P286
14P4 |  | 14P286B
14P43 |  | 14P286C
14P44 |  | 14P287
14P46 |  | 14P288
14P472 |  | 14P289
14P473 |  | 14P290
14P474 |  | 14P291
14P48 |  | 14P292
14P485 |  | 14P293
14P51 |  | 14P294
14P52 |  | 14P295
14P53 |  | 14P350
14P557 |  | 14P4
14P558 |  | 14P40
14P564 |  | 14P41
14P582 |  | 14P42
14P5A |  | 14P43
14P601 |  | 14P44
14P694 |  | 14P45
14P695 |  | 14P46
14P697 |  | 14P472
14P717 |  | 14P473
14P718 |  | 14P48
14P82 |  | 14P485
14P823 |  | 14P4A
14P825 |  | 14P4B
14P827A |  | 14P51
14P827B |  | 14P52
14P83 |  | 14P53
14P85 |  | 14P557
14P87 |  | 14P558
14P951 |  | 14P564
 |  | 14P582
 |  | 14P5A
 |  | 14P601
 |  | 14P602
 |  | 14P613
 |  | 14P631
 |  | 14P632
 |  | 14P694
 |  | 14P695
 |  | 14P696
 |  | 14P697
 |  | 14P716
 |  | 14P717
 |  | 14P718
 |  | 14P776
 |  | 14P80
 |  | 14P82
 |  | 14P823
 |  | 14P825
 |  | 14P827A
 |  | 14P827B
 |  | 14P83
 |  | 14P85
 |  | 14P87
 |  | 14P951
 |  | 14MX820A
 |  | 14MX820B
 |  | 14MX851
 |  | 14MX854
 |  | 14MX855
 |  | 14MX860
 |  | 14MX861
 |  | 14MX864
 |  | 14MX867
 |  | 14MX868
 |  | 14MX868W
 |  | 14MX869
 |  | 14MX876W
 |  | 14MX877E
 |  | 14MX878
 |  | 14MX879
 |  | 14MX880
 |  | 14MX881
 |  | 14MX884E
 |  | 14MX885W
 |  | 14MX886W
 |  | 14MX887E
 |  | 14MX888W
 |  | 14MX889S
 |  | 14MX890E
 |  | 14MX891W
 |  | 14MX892
 |  | 14MX893E
Spreadsheet: 682139d1591915139-indexing-entire-tables-from-multiple-sheets-in-one-excel-sheet-file
Sheet: NOVEMBER 

Particulars | AMOUNTS(SHS) | AMOUNTS(SHS)
Revenue | 111111
Revenue from shows | 222222
Gardens | 220000
Total revenue | 293333.333333333
OPERATING EXPENSES | 347777.833333333
Kitchen expenses | 1400500
Coffee bar expenses | 1122185.27777778
Sauna expenses | 1319240.87301588
Accommodation expenses | 1516296.46825397
Water expenses | 1713352.06349207
Cosmetology expenses | 1910407.65873016
Armani Dance troupe expenses | 2107463.25396826
Gardens maintenance | 2304518.84920635
TOTAL OPEERATING EXPENSES | 2501574.44444445
GENERAL EXPENSES | 2698630.03968254
Purchase of OVCs food | 2895685.63492064
Payment to yak a OVCs home | 3092741.23015873
Advance payments | 3289796.82539683
Office equipment(Rota trim and files) | 3486852.42063492
Firewood expenses | 3683908.01587302
Office  equipment maintenance | 3880963.61111111
[NAME] to garden cleaner | 4078019.20634921
Expense on kitchen stock added | 4275074.8015873
Electricity maintenance | 4472130.3968254
Payment to labor services | 4669185.9920635
SUBTOTAL | 4866241.58730159
NET OPERATING EXPENSES | 5063297.18253969
NET PROFITS | 5260352.77777778
Spreadsheet: 770667d1646220464-extracting-and-sorting-rows-based-on-overdue-date-excel-database
Sheet: Sheet1

Client name | data | Amount | To pay |  |  | Date: |  |  | Overdue 1 - 15 |  |  |  | Overdue 16 - 30 |  |  |  | Overdue 31 - 60 |  |  |  | Overdue >61
Google | 2022-01-01 00:00:00 | 2460 | 2460 |  |  |  |  |  | Client | Amount | Days |  | Client | Amount | Days |  | Client | Amount | Day's |  | Client | Amount | Day's
Adobe | 2022-01-02 00:00:00 | 1084.06 | 0
Microsoft | 2022-01-02 00:00:00 | 450 | 450
Microsoft | 2022-01-03 00:00:00 | 135 | 135
Corel Draw | 2022-01-10 00:00:00 | 1023.57 | 0
Apple | 2022-01-12 00:00:00 | 194.6 | 0
Samsung | 2022-01-17 00:00:00 | 20 | 20
Tesla | 2022-01-25 00:00:00 | 5 | 0
KFC | 2022-01-27 00:00:00 | 165 | 165
McDonald's | 2022-01-27 00:00:00 | 60 | 60
Starbucks | 2022-01-27 00:00:00 | 220 | 220
Coca Cola | 2022-02-03 00:00:00 | 2301 | 2301
Adidas | 2022-02-03 00:00:00 | 1978.97 | 1978.97
Ikea | 2022-02-03 00:00:00 | 170 | 170
Pepsi | 2022-02-12 00:00:00 | 178.5 | 178.5
Unilever | 2022-02-12 00:00:00 | 261.19 | 261.19
Facebook | 2022-01-12 00:00:00 | 76.16 | 76.16
Nike | 2022-01-03 00:00:00 | 595 | 595
Xerox | 2022-01-03 00:00:00 | 80 | 80
Microsoft | 2022-02-01 00:00:00 | 450 | 450
Microsoft | 2022-03-01 00:00:00 | 450 | 450
Microsoft | 2022-01-02 00:00:00 | 700 | 700
Spreadsheet: 218209d1362401430-calculate-break-based-on-hours-worked-personal-pay-alpha-
Sheet: Week 34

 | Weekly Time Sheet
 | Week Start: | 2012-09-16 00:00:00
 | Rate Per Hour: | 18
 | Day | Date | Time In | Time Out | Break | Paid Hours | Total Hours | Total Pay |  |  | 00:00:00 | <4:45 | These are the hours I must work for a break
 | Sunday |  | 12:00:00 | 17:00:00 |  |  |  |  |  |  | 00:15:00 | >=4:45
 | Monday |  | 12:00:00 | 18:30:00 |  |  |  |  |  | Break length | 00:30:00 | >=6:00
 | Tuesday |  | 09:30:00 | 15:00:00 |  |  |  |  |  |  | 00:45:00 | >=8:15
 | Wednesday |  | 14:00:00 | 19:00:00
 | Thursday |  | 09:30:00 | 16:00:00
 | Friday |  | 09:30:00 | 13:45:00
 | Saturday |  | 07:00:00 | 13:00:00
 |  |  |  |  | Total:
Spreadsheet: tracy_geaccone__40277__Non recurring Q3 2001-asset sales
Sheet: Lurgi Support

Cash flows
Yr 1 |  | 3.5
Yr 2 |  | 18.5
Lurgi Condensed [NAME]
At July 31, 2001
 |  |  | ($ in millions)
Current Assets |  |  | 27.5 | (a)
PP&E |  |  | 2.5
Goodwill
Deferred Tax Asset |  |  | 2.7
Total Assets
A/P and Accruals |  |  |  | (b)
A/P Azurix Brazil |  |  | 3
Long-term Liabilities |  |  | 9.8 | (b)
Deferred Tax Liabilities |  |  | 0.9 | (b)
Total Liabilities
Pre-CTA Equity |  |  | 21.8
CTA |  |  | -5.8
Total Stockholder's Equity
Total Liabilites and Stockholder's Equity
Fair value of net assets other than A/P - Brazil,
PP&E, goodwill and deferred tax assets
Spreadsheet: 51281d1250807634-data-validation-list-sort-problem-tempodjustments3
Sheet: Data 

AddressDisplay | Beds | DaysOnMarket | ListPrice | LotSize | NumGarages | CarportCap | PoolDesc | SalesPrice | SqFtTotal | YearBuilt | BathsTotal | SpecialConditions | ListStatus | ClosedDate | Fireplace | ViewDesc | BathsQuarter | BathsHalf | BathsThreeQuarter | PropertyAttached | Stories | MLSNUM | BathsFull | OffMarketDate | Style | City | SoldTerms | ListDate | ListPriceOrig | ZipCode
Spreadsheet: 870294d1716829334-inserting-rows-and-keeping-formula-anonymised-history-group-spreadsheet
Sheet: B - I+E

MICKLEHAM & WESTHUMBLE LOCAL HISTORY GROUP
 | Statement of accounts to date
 |  | TOTAL to date
 | Item | Income | Expenditure
 |  | £ | £
 | Subscriptions
 | Donations
 | Meetings
 | Equipment
 | Supplies
 | Bank interest/charges
 | [NAME] iro 2023, 2024
 | Miscellaneous
 | Total
 | Surplus (deficit) on year to date
 | Balance at bank at | (enter date)
 | Cash in hand at | (enter date)
 |  |  | 3636.870000000001
Spreadsheet: 83598d1283550888-table-formulas-test
Sheet: Sheet3

NIL |  | 0
1X2 FLAT |  | 24
1X2 [NAME] |  | 38
1X2 SPLIT/SL |  | 44
1X2 VGRV |  | 51
1x3 FLAT |  | 40
1X3 [NAME] |  | 68.4
1X3 SPLIT/SL |  | 84
1X3 VGRV |  | 94
1x4 FLAT |  | 40
1X4 [NAME] |  | 68.4
1X4 SPLIT/SL |  | 84
1X4 VGRV |  | 94
1x5 FLAT |  | 40
1X5 [NAME] |  | 68.4
1X5 SPLIT/SL |  | 84
1X5 VGRV |  | 94
1X6 FLAT |  | 40
[NAME] |  | 68.4
1X6 SPLIT/SL |  | 84
1X6 VGRV |  | 94
2x2 FLAT |  | 24
2X2 [NAME] |  | 38
2X2 SPLIT/SL |  | 44
2X2 VGRV |  | 51
2x3 FLAT |  | 40
2X3 [NAME] |  | 68.4
2X3 SPLIT/SL |  | 84
2X3 VGRV |  | 94
2x4 FLAT |  | 60
2X4 [NAME] |  | 92
2X4 SPLIT/SL |  | 112
2X4 VGRV |  | 126
2x5 FLAT |  | 76
2X5 [NAME] |  | 115
2X5 SPLIT/SL |  | 157
2X5 VGRV |  | 180
2x6 FLAT |  | 88
2X6 [NAME] |  | 153
2X6 SPLIT/SL |  | 224
2X6 VGRV |  | 270
2x7 FLAT |  | 128
2X7 [NAME] |  | 191
2X7 SPLIT/SL |  | 281
2X8 VGRV |  | 324
3X3 FLAT |  | 60
3X3 [NAME] |  | 92
3X3 SPLIT/SL |  | 112
3X3 VGRV |  | 126
3X4 FLAT |  | 76
3X4 [NAME] |  | 115
3X4 SPLIT/SL |  | 157
3X4 VGRV |  | 180
3X5 FLAT |  | 88
3X5 [NAME] |  | 153
3X5 SPLIT/SL |  | 224
3X5 VGRV |  | 270
3X6 FLAT |  | 128
3X6 CONTR |  | 191
3X6 SPLIT/SL |  | 281
3X6 VGRV |  | 324
4X4 FLAT |  | 88
4X4 [NAME] |  | 153
4X4 SPLIT/SL |  | 224
4X4 VGRV |  | 270
4X5 FLAT |  | 128
4X5 [NAME] |  | 191
4X5 SPLIT/SL |  | 281
4X5 VGRV |  | 324
5X5 FLAT |  | 141
5X5 [NAME] |  | 211
4X5 SPLIT/SL |  | 310
4X5 VGRV |  | 357
BDR FLAT |  | 65
BDR CONTR |  | 95
BDR SPLIT/SL |  | 115
BDR VGRV |  | 135
A FLAT |  | 335
A CONTR |  | 360
A SPLIT |  | 460
A SLIM |  | 251
A VGRV |  | 229
B FLAT |  | 351.75
B [NAME] |  | 378
B SPLIT |  | 483
B SLIM |  | 263.55
B VGRV |  | 240.45
C FLAT |  | 368.5
C CONTR |  | 396
C SPLIT |  | 506
C SLIM |  | 276.1
C VGRV |  | 251.9
D FLAT |  | 402
D CONTR |  | 432
D SPLIT |  | 552
D SLIM |  | 301.2
D VGRV |  | 274.8
Spreadsheet: 7333ce5c-b393-4754-8893-216f3f0f7efd
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
 |  | U.S. Census Bureau
 |  | Source: Construction Spending
 |  | Total Construction: U.S. Total
 |  | Seasonally Adjusted Total Construction [Millions of Dollars]
 |  | Period: 2002 to 2012
 |  | Data Extracted on: April 19, 2014 (11:54 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
Spreadsheet: 192084d1352303402-is-there-such-a-thing-as-auto-filter-or-a-workaround-that-will-do-the-following-deal-log
Sheet: CLEMONS

 | TEAM1
 | SALESMEN |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL FRONT
 | DUKE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL BACK
 | RON |  |  |  |  |  |  |  |  |  |  |  |  |  |  | counts:
 | CLEMONS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PENETRATION
 | CHRIS |  |  |  |  |  |  |  |  |  |  |  |  |  | total gross |  | new gross breakdown |  |  |  |  | used gross breakdown
## | SALESMAN | TEAM # | DATE | CUSTOMER | STOCK# | FRONT $$ | RESERVE | WARR | GAP | A/M | TOTAL $ | [N/U] | NEW UNITS | USED UNITS | NEW GROSS | USED GROSS | fe | reserve | WARR | gap | a/m | front | reserve | warr | gap | a/m
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
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
Spreadsheet: 475810d1471465868-fil-an-excel-sheet-automatically-test
Sheet: FULL PROGRAM

FULL Program | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | total 2016/2019 | VAR 2016/2019 | VAR 2015/2019 | CAGR 2016/2019
Program 1 - Projet AAA | 0 | 0.46 | 5.5 | 7.02 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78
Program 1 - Projet BBB | 0 | 0 | 0 | 0 | 0
Program 1 - Projet CCC | 0 | 0.52 | 1.12 | 1.56 | 1.57
Program 1 - Projet DDD | 0 | 0 | 0 | 2.98 | 8.07
Program 1 - Projet EEE | 0 | 0 | 0 | 3.25 | 4.81
Program 2 - Projet AAA | 0 | 0 | 0.95 | 1.43 | 2.86 | 5.35 | 5.51 | 5.68 | 5.85 | 6.025 | 6.2
Program 2 - Projet CCC | 0 | 0 | 0 | 0.2 | 0.5
Program 2 - Projet DDD | 0 | 0 | 0 | 0.7 | 2
Program 2 - Projet EEE | 0 | 0 | 0 | 0 | 1
Program 3 - Projet AAA | 0 | 0 | 0 | 2.86 | 5.72 | 11.44
Program 3 - Projet BBB | 0 | 0 | 0 | 0 | 0.5 | 1
Program 3 - Projet CCC | 0 | 0 | 0 | 1.1 | 2.2
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
Total New Products
Spreadsheet: 884240d1733323189-resetting-sum-of-values-back-to-zero-when-certain-value-is-reached-book1
Sheet: Sheet1

 | Date | Running Hours | Weekly  Hours | Total  Hours | Sample Needs to be Taken Every 250 Hours that Pass
 |  |  |  |  |  | What I want formula to do
 |  | Hours | Hours | Hours |  | <--
 | 2024-01-01 00:00:00 | 55310
 | 2024-01-08 00:00:00 | 55380.4
 | 2024-01-15 00:00:00 | 55522.2
 | 2024-01-22 00:00:00 | 55682 |  |  |  | SAMPLE TO BE TAKEN
 | 2024-01-29 00:00:00 | 55795.9
 | 2024-02-05 00:00:00 | 55963.9 |  |  |  | SAMPLE TO BE TAKEN
 |  |  |  | 690
 |  |  |  | 740
 |  |  |  | 780 |  | SAMPLE TO BE TAKEN
Spreadsheet: 226950d1365544334-overall-sheet-pulling-in-info-from-multiple-workbooks-sample-sheet-for-help-forum-mar-2013
Sheet: Test Practice

Patient unique reference number | Month | Sex | Age (years) | Age | Age band | Age group | No. of repeats | Repeats | Repeats band | Repeats group | Drug name | Drug strength | Formulation | Number of doses per day | Drug quantity prescribed | No. of days treatment prescribed at one time | No. of repeats ordered up to the last 12 months | Months of treatment within last 12 months | Quantity ordered within the last 12 months | Quantity that should have been ordered if using as per screen dosage | Potential difference in amount ordered to what was expected | % over or under ordered | Total daily dose as described by patient | [NAME] to the recorded daily dose | Information from Computer record and patient call | Patient comments | Who orders patients medicines? | If a Pharmacy which one? | When are the medicines ordered by the patient? | How are the medicines ordered? | To discuss with HC professional | Which HC professional? | HC professional decision | MMF Intervention made | Drug cost | Pack size | Cost of drug based upon amount ordered per repeat | Quantity of excess medicines patient reported | CDHL | Savings made | Comments
1 | Jan 13 | Male | 25 | 1 | 0-10 |  | 7 | 1 | 0-10 |  | Aspirin | 75mg | Tablets | 1 | 28 |  | 25 | 3 |  |  |  |  | 2 |  |  | Thought GP had asked him to double dose | Pharmacy | Boots | Ordered at time of collection | Repeat dropped into Pharmacy | What shall I do next? | GP | GP appt arranged | Drug quantity aligned to 28 days | 62 | 28 |  | 112
1 | Jan 13 | Male | 25 |  |  |  | 7 |  |  |  | [NAME] | 2.5mg | Tablets | 1 | 28 |  | 15 | 12 |  |  |  |  | 1 |  |  |  | Carer |  | 1 week before due | Repeat dropped into Surgery |  | Practice Pharmacist | Pharmacist appt arranged | No intervention needed | 17.3 | 60
2 | Feb 13 | Female | 32 | 2 | 0-10 |  | 25 | 2 | 0-10 |  | Seretide | 250mcg | [NAME] | 4 | 120 |  | 12 | 6 |  |  |  |  | 4 |  |  |  | Patient |  | Ordered at time of collection | Phoned through to Pharmacy |  | Practice Pharmacist | Pharmacist appt arranged | Drug quantity aligned to 56 days | 80 | 56
3 | Feb 13 | Female | 67 | 3 | 0-10 |  | 32 | 3 | 0-10 |  | Lactulose |  | Liquid | 30 | 1500 |  | 14 | 12 |  |  |  |  | 15 |  |  |  | Carer |  | Never | Repeat dropped into Surgery |  |  |  | Drug quantity aligned to other days | 5 | 14
4 | Apr 13 | Female | 70 | 4 | 0-10 |  | 3 | 4 | 0-10 |  | Seretide | 500mcg | [NAME] | 2 | 60 |  | 16 | 12 |  |  |  |  | 3 |  |  | Patient says finding difficult to use | Care Home |  | Other | Surgery website |  |  |  | Drug put into past drugs | 40.92 | 60 |  | 120
 |  |  |  | 5 | 0-10 |  |  | 5 | 0-10
Spreadsheet: john_griffith__16093__1_18_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL G2 | EXP | 1 | 1 | 94.5 | 107.1 | 1.2 | 2002-01-15 14:52:00
 | CL H2 | 19 | 220 | 235 | 53.5 | 57.2 | 0.66 | 2002-01-18 10:09:00
 | CL J2 | 19.5 | 310 | 325 | 51.2 | 53.7 | 0.64 | 2002-01-18 10:09:00
 | CL K2 | 19.5 | 380 | 395 | 50.1 | 52 | 0.63 | 2002-01-18 10:09:00
 | CL M2 | 19.5 | 425 | 440 | 48.8 | 50.5 | 0.61 | 2002-01-18 10:09:00
 | CL N2 | 19.5 | 460 | 475 | 47.1 | 48.6 | 0.59 | 2002-01-18 10:09:00
 | CL Q2 | 20 | 480 | 505 | 43.9 | 46.2 | 0.57 | 2002-01-18 10:09:00
 | CL U2 | 20 | 490 | 515 | 41.7 | 43.9 | 0.54 | 2002-01-18 10:09:00
 | [NAME] | 20 | 500 | 530 | 39.7 | 42.1 | 0.51 | 2002-01-18 10:09:00
 | CL X2 | 20 | 500 | 530 | 37.6 | 39.9 | 0.49 | 2002-01-18 10:09:00
 | [NAME] | 20 | 500 | 530 | 35.9 | 38.1 | 0.47 | 2002-01-18 10:09:00
 | CL F3 | 20 | 505 | 535 | 34.7 | 36.8 | 0.45 | 2002-01-18 10:09:00
 | CL M3 | 20 | 510 | 535 | 29.7 | 31.2 | 0.38 | 2002-01-18 10:09:00
 | CL Z3 | 20.5 | 520 | 550 | 25.8 | 27.3 | 0.34 | 2002-01-18 10:09:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 728056d1618281754-index-match-formula-for-current-liabilities-and-current-assets-current-liabilities-and-current-assets2-1-
Sheet: Financial Position

I'm kindly asking for a formula which if current assets are negative they direct go to the current liabilities in [NAME] and the same to the negative current liabilities go to the Current Assets.
 |  |  |  |  | DESIRED OUTCOME
STATEMENT OF FINANCIAL POSITION:  2021 |  |  |  |  | STATEMENT OF FINANCIAL POSITION:  2021
ZWL |  | ZWL |  |  |  |  | ZWL
ASSETS |  |  |  |  | ASSETS
Property, Plant and Equipment |  |  |  |  | Property, Plant and Equipment
Intangible Assets |  |  |  |  | Intangible Assets
Total Fixed Assets |  |  |  |  | Total Fixed Assets
CURRENT ASSETS |  |  |  |  | CURRENT ASSETS
Inventories |  |  |  |  | Inventories
Trade and Other Receivables |  |  |  |  | Trade and Other Receivables
Cash and Cash Equivalents |  |  |  |  | Cash and Cash Equivalents |  | 5300
Total Current Assets |  |  |  |  | Total Current Assets
TOTAL ASSETS |  |  |  |  | TOTAL ASSETS
EQUITY AND LIABILITIES |  |  |  |  | EQUITY AND LIABILITIES
Share Capital |  |  |  |  | Share Capital
[NAME] |  |  |  |  | [NAME]
 |  |  |  |  | Revaluation Reserves
Total Equity |  |  |  |  | Total Equity
LIABILITIES |  |  |  |  | LIABILITIES
NON - CURRENT LIABILITIES |  |  |  |  | NON - CURRENT LIABILITIES
Loan |  |  |  |  | Loan
CURRENT LIABILITIES |  |  |  |  | CURRENT LIABILITIES
Trade and Other payables |  |  |  |  | Trade and Other payables |  | 165135.46
Current Tax payable |  |  |  |  | Current Tax payable
short term loan |  |  |  |  | short term loan
Total Current Liabilities |  |  |  |  | Total Current Liabilities
TOTAL EQUITY AND LIABILITIES |  |  |  |  | TOTAL EQUITY AND LIABILITIES
Spreadsheet: 767266d1644386658-allocate-amount-into-monthly-columns-formula-fails-for-specific-years-networkdays-issue-allocation6
Sheet: Weekly Hours

Weekly Hours
Click Consulting
Purpose |  | To allocate the amount of each item based on a daily amount and the number of dates in each column.
Week Start |  | 2015-09-06 00:00:00
Allocation
 |  |  |  |  |  | Week beginning:
 | Employee | Hrs per Day | Start | End |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | A | 8 | 2015-09-07 00:00:00 | 2015-10-31 00:00:00
 | B | 6 | 2015-09-06 00:00:00 | 2015-10-03 00:00:00
 | C | 4 | 2015-09-13 00:00:00 | 2015-10-31 00:00:00
 | D | 8 | 2015-10-04 00:00:00 | 2015-11-07 00:00:00
 | Total
Spreadsheet: 740408d1626332826-turn-around-time-calculation-for-sample-tests-sla-calculation-updated
Sheet: Sheet1

INVESTIGATIONS | Deprtment | TAT | Authenticate Date | Distribute Date | SLA Calculation |  |  |  |  | SLA | Count | %
Sample Test1 | Department - A | 0:40:00 | 2021-06-01 16:30:39 | 2021-06-01 09:10:55 |  |  |  |  |  | Beyond SLA
Sample Test11 | Department - B | 4:00:00 | 2021-06-01 11:17:39 | 2021-06-01 09:03:50 |  |  |  |  |  | Within SLA
Sample Test161 | Department - F | 18:00:00 | 2021-06-01 14:20:31 | 2021-06-01 12:41:03
Sample Test178 | Department - F | 3 days, 0:00:00 | 2021-06-01 10:47:59 | 2021-06-05 09:39:42
Sample Test260 | Department - F | 3:00:00 | 2021-06-01 16:49:48 | 2021-06-01 12:49:25
Sample Test289 | Department - G | 2:00:00 | 2021-06-01 16:50:00 | 2021-06-02 17:31:13
Sample Test336 | Department - H | 6 days, 0:00:00 | 2021-06-01 16:51:19 | 2021-06-01 10:14:08
Sample Test350 | Department - H | 6:00:00 | 2021-06-01 16:51:39 | 2021-06-01 10:30:52
Sample Test408 | Department - J | 4 days, 0:00:00 | 2021-06-01 14:03:46 | 2021-06-06 11:07:35
Sample Test41 | Department - B | 1 day, 0:00:00 | 2021-06-01 18:12:52 | 2021-06-01 15:29:12
Sample Test413 | Department - J | 7 days, 0:00:00 | 2021-06-01 14:12:06 | 2021-06-10 11:23:29
Sample Test42 | Department - B | 2 days, 0:00:00 | 2021-06-02 17:31:13 | 2021-06-05 10:39:07
Sample Test58 | Department - D | 12:00:00 | 2021-06-01 18:13:03 | 2021-06-04 15:29:12
Spreadsheet: 827239d1682575340-replace-any-number-from-0-to-9-in-an-alphanumeric-text-with-nothing-test-1-
Sheet: 工作表1

PUNE 1
PUNE 2
PUNE 3
PUNE 4
PUNE 5
PUNE 6
PUNE 7
PUNE1
PUNE2
PUNE3
[NAME]
[NAME]
PUNE-2
[NAME]
PUNE-4
MUMBAI (1)
MUMBAI-1
MUMBAI-[1]
MUMBAI-{2}
MUMBAI [1]
MUMBAI {2}