tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1541fa94-c7af-4604-be3f-7a9888bf2675
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Applicant/Provider:
RFP No.: |  | Period: |  | to |  |  | Date Prepared:
Contract No.
(As Applicable)
 |  |  |  | NO. | PER DIEM OR SUBSISTENCE | AIR FARE | TRANSPORTATION | TOTAL
NAME OF EMPLOYEE & TITLE |  | DESTINATION |  | DAYS | A | B | C | A+B+C
TOTAL:
[NAME]/COMMENTS:
Spreadsheet: 806089d1669104110-helper-column-and-vlookup-project-calendar-2-ans
Sheet: Project

Team | Task No. | Task / Milestone | Dependent On Task No. | End Date of Dep. Task | Task Owner | Start Date | Duration in Days | End Date
L2O | 1 | Identification of team members on Our side |  |  |  | 2022-11-18 00:00:00 | 6
L2O | 2 | Identification of team members on Client side
L2O | 3 | Acknowledgement/acceptance of role and tasks by our team members |  |  |  |  | 2
L2O | 4 | Acknowledgement/acceptance of role and tasks by our team members
L2O | 5 | Schedule project kick-off call with our and client Members
L2O | 6 | Project Kickoff and Walkthrough of major milestones and upcoming tasks/milestones
L2O | 7 | Send out training invites
L2O | 8 | Tool 1 Introduction and Training to Instructors & Client Team Members
L2O | 9 | Tool 2 Introduction and Training to Instructors & Client Team Members
L2O | 10 | Tool 3 Introduction and Training to Instructors & Client Team Members
L2O | 11 | Discovery session for Tool 1
L2O | 12 | Discovery session for Tool 2
L2O | 13 | Discovery session for Tool 3
L2O | 14 | Walkthrough of Data Templates
L2O | 15 | Confirmation of Understanding of Data Templates by Client Team Members
 | 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
Spreadsheet: 167893d1342142313-calculating-regular-hours-over-time-regular-over-time-night-differential-night-differen-hours-computation
Sheet: Sheet1

Date | Time In | Time Out | Per Test
 |  |  | Regular Hours | OT | ROND | ND
2012-03-16 00:00:00 | 21:35:00 | 10:00:00 |  | 4 |  | 8
2012-03-17 00:00:00 | 22:00:00 | 06:00:00 |  |  |  | 8
2012-03-18 00:00:00 | 22:00:00 | 06:00:00 |  |  |  | 8
2012-03-19 00:00:00 | 22:00:00 | 06:00:00 |  |  |  | 8
2012-03-20 00:00:00 | R.D. | R.D.
2012-03-21 00:00:00 | 18:00:00 | 06:00:00 |  | 4 |  | 8
2012-03-22 00:00:00 | 06:00:00 | 14:00:00 | 8
2012-03-23 00:00:00 | 22:00:00 | 06:00:00 |  |  |  | 8
2012-03-24 00:00:00 | 22:00:00 | 06:00:00 |  |  |  | 8
2012-03-25 00:00:00 | 22:00:00 | 10:00:00 |  | 4 |  | 8
2012-03-26 00:00:00 | 22:00:00 | 06:00:00 |  |  |  | 8
2012-03-27 00:00:00 | Rest day | Rest day
2012-03-28 00:00:00 | 18:00:00 | 06:00:00 |  | 4 |  | 8
2012-03-29 00:00:00 | 14:00:00 | 22:00:00 | 8
2012-03-30 00:00:00 | 14:00:00 | 04:00:00 | 8 |  | 6
2012-03-31 00:00:00 | 14:00:00 | 04:00:00 | 8 |  | 6
 |  | TOTAL PER TEST | 32 | 16 | 12 | 80
 | 68.19
1.25 | 1.375
Spreadsheet: 787218d1657696103-arrange-the-rows-values-into-columns-service-utilization
Sheet: Sheet1

Name | Appointment 1 | Appointment 2 | Appointment 3 | Appointment 4 | Appointment 5 | Appointment 6 | Appointment 7 | Appointment 8 | Appointment 9 | Appointment 10 | Appointment 11 | Appointment 12
[NAME] | ND | Physical Medicine | Supplements
[NAME] ([NAME]) McIntee | ND | Physical Medicine | [NAME]
[NAME] | IV
[NAME] | ND | Regen | Supplements
Adam Field | Regen
[NAME] | IV | [NAME]
[NAME] | IV
[NAME] | IV
[NAME] | IV | ND | Supplements
[NAME] | IV | ND
[NAME] | ND | Physical Medicine | Supplements
Akmal Sabaridin | IV
[NAME] | IV
[NAME] | ND
[NAME] | Regen
[NAME] | IV
Spreadsheet: 678215d1589785019-indirect-function-for-dependent-drop-down-on-separate-sheet-xisaabaadka-al-barakacopy-repaired-
Sheet: Saamilayda

Shirkadda ALBARAK
Capital Details
Name | [NAME] | Investment | % | loss (1851.95) Distribution | Equit After Loss | [NAME]  per investor | OE Balance on Jan 1, 2020 | Owners' Drawings | Working Capital | %2
Abdinasir Moallim Abdikadir |  | 25000 |  |  |  |  |  | 14230.78
Ilyas Abdullahi Ibrahim | 252907762331 | 12000
[NAME] | 252907790486 | 10000
[NAME] |  | 10000
[NAME] | 252907797483 | 8000
[NAME] | 252907796269 | 7000
[NAME] | 251906810886
Abdirahman [NAME] | 251936415506 | 5000
Sa'diyo [NAME] |  | 2000 |  |  |  |  |  | 1985.13
[NAME] | 252615661010 | 30000
Maxamed Sh. [NAME] |  | 10000
Cabdifitaax Sheekh Maxamed |  | 2000
Additional Investments
[NAME] |  |  |  |  |  |  |  |  | 11000
Cabdullaahi Cabdi Mursal |  |  |  |  |  |  |  |  | 5000
Loss charged to old Board |  | -7530.59
ALBARAKA |  |  |  |  |  | -2963.13
OPEC |  | 114784.35 |  |  |  | -2846.92
Total
[NAME]
[NAME]
December 18/26 2019
[NAME] ee hadda |  |  | 232401.82
Zakada 2.5% |  |  | 5810.05
Saamiga ZAKO ee OPEC ay maamulayso 70% (49% x Zakada) |  | 1992.85
Saaamiga ZAKO ee AL-BARAKA ay maamulayso |  | 3817.2 | 5810.05
Spreadsheet: 737013d1624024084-formula-help-negative-uplift-and-blank-cell-possible-macro-test-help
Sheet: Day Time Working

quotation information for Ground Investigation
Day time working
 | [NAME]
 | Lot Number Quotation Information Applies to: | NATIONAL
 | Items to be priced in the Price List only (and not in this quotation information) are denoted in Rate Column: | WO |  | Uplift
 |  |  |  | -0.0053 | -1.53
Item No. | Description | Unit | Rate | rate change | -0.0053
 |  |  | £
A | General items, provisional services and additional items
A1a | Activity A | sum | 995
A2.5 | Activity B | sum | WO
Spreadsheet: 219729d1362922026-counting-occurrences-233-count_occurances
Sheet: Nov2004

Month | Day | paper | Cost | cumul | total Rs | weekly amt
Nov | Mon | ET | 200 | 200 | 2
2 |  | IE | 300 | 500 | 5
3 |  | IE | 300 | 800 | 8
4 |  | IE | 300 | 1100 | 11
5 |  | IE | 300 | 1400 | 14 | 14
6 |  | IE | 300 | 1700 | 17
7 | [NAME] | IES | 200 | 1900 | 19
8 |  | IE | 300 | 2200 | 22
9 |  | IE | 300 | 2500 | 25
10 |  | IE | 300 | 2800 | 28
11 |  | IE | 300 | 3100 | 31
12 |  | IE | 300 | 3400 | 34 | 17
13 |  | xx | 0 | 3400 | 34
14 | [NAME] | IES | 200 | 3600 | 36
15 |  | IE | 300 | 3900 | 39
16 |  | hindu | 250 | 4150 | 41.5
17 |  | hindu | 250 | 4400 | 44
18 |  | hindu | 250 | 4650 | 46.5
19 |  | IE | 300 | 4950 | 49.5 | 15.5
20 |  | IE | 300 | 5250 | 52.5
21 | [NAME] | IES | 200 | 5450 | 54.5
22 |  | IE | 300 | 5750 | 57.5
23 |  | IE | 300 | 6050 | 60.5
24 |  | hindu | 250 | 6300 | 63
25 |  | hindu | 250 | 6550 | 65.5
26 |  | IE | 300 | 6850 | 68.5 | 16
27 |  | IE | 300 | 7150 | 71.5
28 | [NAME] | IES | 200 | 7350 | 73.5
29 |  | IE | 300 | 7650 | 76.5
30 |  | IE | 300 | 7950 | 79.5
 |  |  |  |  |  | PAID
IE/S | hindu/S | TI/S | HT/S | ET/S
300_200 | 250_350 | 150_300 | 150_450 | 200_000
Spreadsheet: 377816d1424176622-sumproduct-more-than-one-condition-sample-1-
Sheet: Edu Plan (3)

King Fahad Medical City
Nursing Education Department
Educational Plan 2015 - Unit - Hospital
Educational Plan / 2015 |  |  |  |  |  |  | Educational Activities / Record
No. | Identified Need | Needs Assessment Source | Topic / Other Related Topics | Number of Sessions / Year | Number of Staff / Session | Target Month(s) for Completion | Actual Completion Date(s) | Number of Staff Attended | Presenter Type | Type of Education Given | Status | Reason Why Not Completely Met | Total  Attended plan | Total Attended Record | Plan Achievement
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
 | Lecture | Needs Assessment Form | Completely Met | Staff Were Busy
 | Skills Lab/Skills Review | Staff | Partially Met | No Venue Available
 | Bedside Teaching | Head Nurse | Moved to The Next Quarter | No Equipments Available
 | Group Discussion | Clinical Instructor | Cancelled | Learning Material  Not Ready
 | Equipment Demonstration | Nursing Director |  | Other Commitments
 | Hands on | NQM or PI Project |  | Others
 | Case Study | ORS/Datix | Unit's CI
 | Simulation | Physicians | Unit's Staff
 | Role Play | Others | NED Staff
 | Course |  | KFMC Staff
 | Workshop |  | OutSide KFMC Staff
 | Video
 | Mind Map/ Decision Tree
 | Journal Article
 | Staff Meeting
 | Poster Board
 | Self Study Module
Spreadsheet: 710331d1608847257-help-pulling-data-from-a-range-copy-of-attendance-template-w-formula
Sheet: July

Employee Absence Schedule
July | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 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 | CI | T | NCNS | Total Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 129189d1321481552-insert-a-row-automatically-test-report1
Sheet: Product List

Product | Part | Vendor | Cost | Quantity | Total Cost
Product1
 | Part1 |  |  | 5
 | Part3 |  |  | 3
 | Part4 |  |  | 2
 | Part6 |  |  | 1
Product2
 | Part3 |  |  | 1
 | Part4 |  |  | 2
 | Part1 |  |  | 3
 | Part6 |  |  | 4
 | Part5 |  |  | 5
 | Part7 |  |  | 6
Product3
 | Part1 |  |  | 8
 | Part3 |  |  | 5
 | Part6 |  |  | 2
 | Part10 |  |  | 5
Spreadsheet: andy_zipper__745__10_29_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] |  | 0 | 0 | 48.6 | 82.3 | 2.63 | 2001-10-25 14:55:00
 | HO Z1 | 63 | 680 | 730 | 48.1 | 51.7 | 1.98 | 2001-10-29 14:32:00
 | HO F2 | 64 | 1010 | 1050 | 50 | 52 | 2.05 | 2001-10-29 14:32:00
 | HO G2 | 64 | 1275 | 1350 | 50.6 | 53.6 | 2.1 | 2001-10-29 14:32:00
 | [NAME] | 63 | 1300 | 1400 | 46 | 49.6 | 1.89 | 2001-10-29 14:32:00
 | HO J2 | 62 | 1300 | 1400 | 42.2 | 45.5 | 1.71 | 2001-10-29 14:32:00
 | HO K2 | 61 | 1275 | 1400 | 38.4 | 42.2 | 1.55 | 2001-10-29 14:32:00
 | HO M2 | 60 | 1275 | 1400 | 36 | 39.6 | 1.43 | 2001-10-29 14:32:00
 | HO N2 | 61 | 1300 | 1450 | 34 | 38 | 1.38 | 2001-10-29 14:32:00
 | HO Q2 |  |  |  | 31.2 | 36.8 | 1.3 | 2001-10-23 14:44:00
 | HO U2 |  |  |  | 30.2 | 34.9 | 1.25 | 2001-10-23 14:44:00
 | [NAME] |  |  |  | 28.5 | 33 | 1.2 | 2001-10-23 14:44:00
 | HO X2
 | [NAME]
 | HO F3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 167545d1342021978-create-a-table-ltmo
Sheet: Sheet2

2012-01-01 00:00:00 | 1:47:00 | 10
 | 0:21:00 | 1
2012-03-01 00:00:00 | 1:00:00 | 6
 | 1:05:00 | 4
 | 0:42:00 | 2
 | 0:45:00 | 2
 | 1:12:00 | 4
 | 0:48:00 | 2
 | 0:50:00 | 3
 | 0:52:00 | 2
 | 0:53:00 | 2
 | 0:46:00 | 2
 | 0:30:00 | 1
2012-04-01 00:00:00 | 2:13:00 | 10
 | 0:44:00 | 5
 | 1:18:00 | 4
 | 1:32:00 | 6
 | 1:00:00 | 8
Spreadsheet: 675015d1588105774-power-query-unpivot-data-that-has-multiple-headings-sample-1-
Sheet: Sheet2

Date | Attribute.1 | Attribute.2 | Value
2020-04-24 00:00:00 | Employee 5 | Leave type | Annual
2020-04-24 00:00:00 | Employee 5 | Hours | 8
2020-04-27 00:00:00 | Employee 5 | Leave type | Annual
2020-04-27 00:00:00 | Employee 5 | Hours | 8
2020-04-28 00:00:00 | Employee 5 | Leave type | Annual
2020-04-28 00:00:00 | Employee 5 | Hours | 8
2020-04-29 00:00:00 | Employee 2 | Leave type | Annual
2020-04-29 00:00:00 | Employee 2 | Hours | 8
2020-04-29 00:00:00 | Employee 5 | Leave type | Annual
2020-04-29 00:00:00 | Employee 5 | Hours | 8
2020-04-30 00:00:00 | Employee 2 | Leave type | Annual
2020-04-30 00:00:00 | Employee 2 | Hours | 8
2020-04-30 00:00:00 | Employee 5 | Leave type | Annual
2020-04-30 00:00:00 | Employee 5 | Hours | 8
2020-05-01 00:00:00 | Employee 2 | Leave type | Annual
2020-05-01 00:00:00 | Employee 2 | Hours | 8
2020-05-01 00:00:00 | Employee 5 | Leave type | Annual
2020-05-01 00:00:00 | Employee 5 | Hours | 8
2020-05-04 00:00:00 | Employee 2 | Leave type | Annual
2020-05-04 00:00:00 | Employee 2 | Hours | 8
2020-05-05 00:00:00 | Employee 2 | Leave type | Annual
2020-05-05 00:00:00 | Employee 2 | Hours | 8
2020-05-06 00:00:00 | Employee 2 | Leave type | Annual
2020-05-06 00:00:00 | Employee 2 | Hours | 8
Spreadsheet: 45486d1244215624-calculate-number-of-days-using-2-sets-of-dates-overlappingdateranges
Sheet: Sheet1

 |  | 2005-06-30 00:00:00 | 2006-06-30 00:00:00 | 2007-06-30 00:00:00 | 2008-06-30 00:00:00 | 2009-06-30 00:00:00 | 2010-06-30 00:00:00 | 2011-06-30 00:00:00
 |  | 2006-06-30 00:00:00 | 2007-06-30 00:00:00 | 2008-06-30 00:00:00 | 2009-06-30 00:00:00 | 2010-06-30 00:00:00 | 2011-06-30 00:00:00 | 2012-06-30 00:00:00
2006-01-01 00:00:00 | 2007-01-01 00:00:00 | 180 | 185 | 0 | 0 | 0 | 0 | 0
2007-01-01 00:00:00 | 2008-01-01 00:00:00 | 0 | 180 | 185 | 0 | 0 | 0 | 0
2008-01-01 00:00:00 | 2009-01-01 00:00:00 | 0 | 0 | 181 | 185 | 0 | 0 | 0
2009-01-01 00:00:00 | 2010-01-01 00:00:00 | 0 | 0 | 0 | 180 | 185 | 0 | 0
2010-01-01 00:00:00 | 2011-01-01 00:00:00 | 0 | 0 | 0 | 0 | 180 | 185 | 0
2011-01-01 00:00:00 | 2012-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 180 | 185
2012-01-01 00:00:00 | 2013-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 181
Spreadsheet: 803985d1667832635-extracting-data-from-excel-tables-sales-control
Sheet: Sales Ledger

 | I'm kindly asking for excel formula to produce sales ledger using data from bank 1, bank 2, bank 3, Cash, Sales journal and Opening balance sheets
 | Sales Ledger
 | Name | I.D Number | Date | Bank | Invoice | Reference | Debit | Credit | Balance
 | Abi | A002 | 2022-01-01 00:00:00 |  | 198 |  |  |  | -500
 |  |  | 2022-11-01 00:00:00 |  | 1 |  | 3500
 |  |  | 2022-11-05 00:00:00 | Bank 1 |  | 23 |  | 3000
 |  |  | 2022-11-05 00:00:00 |  | 4 |  | 5000
 |  |  | 2022-11-05 00:00:00 | Cash |  | 70 |  | 250
 |  |  | 2022-11-06 00:00:00 | Bank 2 |  | 25 |  | 3500
 |  |  | 2022-11-07 00:00:00 | Bank 3 |  | 40 |  | 1000
 |  |  | 2022-11-07 00:00:00 | Cash |  | 80 |  | 250
 | Bigboy | A003 | 2022-01-01 00:00:00 |  | 220 |  |  |  | 130
 |  |  | 2022-11-01 00:00:00 |  | 3 |  | 3500
 |  |  | 2022-11-05 00:00:00 | Bank 1 |  | 24 |  | 2000
 |  |  | 2022-11-05 00:00:00 | Bank 3 |  | 37 |  | 4000
 |  |  | 2022-11-05 00:00:00 |  | 5 |  | 5000
 |  |  | 2022-11-06 00:00:00 | Cash |  | 71 |  | 2000
 | Rose | A001 | 2022-11-01 00:00:00 |  | 2 |  | 3500
 |  |  | 2022-11-06 00:00:00 | Cash |  | 72 |  | 3500
 |  |  | 2022-11-05 00:00:00 |  | 5 |  | 5000
 |  |  | 2022-11-07 00:00:00 | Cash |  | 30 |  | 5000
Spreadsheet: 17008c37-45a1-413c-9611-d78211a9b2d7
Sheet: Sheet1

PROG ID | ATHLETE ID | TEAM FIRST | TEAM LAST | NATIONALITY | START NUMBER | LEG 1 | LEG 2 | LEG 3 | LEG 4 | POSITION | TOTAL TIME
6251 | 11435 | Team I | Spain | ESP | 0 | 00:25:56 | 00:23:11 | 00:26:51 | 00:23:22 | 1 | 01:39:20
6251 | 11428 | Team I | France | FRA | 0 | 00:25:56 | 00:23:25 | 00:25:24 | 00:24:54 | 2 | [NAME]
6251 | 11437 | Team I | Italy | ITA | 0 | 00:25:56 | 00:23:15 | 00:27:01 | 00:24:55 | 3 | 01:41:05
6251 | 11434 | Team I | Hungary | HUN | 0 | 00:25:55 | 00:24:37 | 00:28:23 | 00:24:26 | 4 | 01:43:20
Spreadsheet: 871890d1718286295-how-to-countif-dynamically-based-on-slicer-selection-report-14-juni-me5a-capex-c11-c12-c13-
Sheet: Report me5a

 |  |  |  |  |  |  |  |  | AULIA
 |  |  |  |  |  |  |  |  | CHANDRA
 |  |  |  |  |  |  |  |  | DIRA
 |  |  |  |  |  |  |  |  | DITA
Purchase Requisition | Items | Quantity Requested | Unit of Measure | Total Line | Plant | Plant Group | Purchasing Group | Requisitioner | Changed On | Year | PR Age in Days | PR Age in Months | Buyer | Buyer Fix | Progress | Remarks | Last Week Progress
1400002555
1400002748
1400002806
1400002832
1400002873
1400003072
1400003122
1400003115
1400003141
1900000098
1400003205
1400002916
1400003240
1400003140
1400003283
1400003292
1400003293
1400003261
1400003256
1400003248
1400003233
1400003234
1400003254
1400003313
1400003298
1400003301
1400003311
1400003358
1400003329
1400003302
1400003366
1400003201
1900000108
1400003406
1400003388
1400003379
1400003380
1400003369
1400003419
1400002956
1400003378
1400003430
1400003412
1400003425
1400003414
1400003434
1400003458
1400003444
1400003454
1400003451
1400003452
1400003446
1400003448
1400003449
1400003441
1400003442
1400003408
1400003409
1400003410
1400003416
1400003320
1400003455
1400003453
1400003411
1400003479
1400003480
1400003481
1400003482
1400003483
1400003485
1400003488
1400003489
1400003490
1400003467
1400003468
1400003466
1400003433
1400003423
1400003424
1900000125
1400003472
1400003462
1400003464
1400003344
1400003498
1400003491
1400003492
1400003493
1400003461
1400003403
1400003476
1400003469
1400003473
1400003516
1400003502
1400003459
1400003217
1400003218
1400003484
1400003532
1400003535
1900000140
1400003517
1400003518
1400003519
1400003520
1400003522
1400003524
1900000128
1400003506
1400003475
1400003457
1400003542
1400003533
1400003534
1400003536
1400003537
1400003538
1400003523
1400003505
1400003507
1400003508
1400003509
1400003510
1400003511
1400003512
1400003513
1400003514
1400003515
1400003499
1400003391
Spreadsheet: 798376d1664454682-sumif-values-based-on-lookup-date-example-data-copy
Sheet: Sheet1

 | Start Date | 2022-04-01 00:00:00 | 2023-04-01 00:00:00 | 2024-04-01 00:00:00 |  |  | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | … | 2024-04-01 00:00:00
Employee A | 2022-12-01 00:00:00 | 50000
Employee B | 2022-11-01 00:00:00 | 75000 |  |  |  | Target Answer
Employee C | 2023-05-01 00:00:00 | 60000
Spreadsheet: 705617d1606229229-data-comparison-and-aggregation-looking-for-help-copy-template
Sheet: Individuals

ID | Name | Address 1 | Address 2 | Address 3 | Post Code
111 | Name 1 | 999 jhjgsdxcvhggh |  |  | CV2 3SQ
222 | Name 2 |  |  |  | LE91 2RU
333 | Name 3 |  |  |  | CV2 3SQ
444 | Name 4 |  |  |  | PO12 4RT
555 | Name 5 |  |  |  | PO12 4RT
666 | Name 6 |  |  |  | BS2 3KL
777 | Name 7 |  |  |  | DE24 7BY
888 | Name 8 |  |  |  | NG11 2JG
999 | Name 9 |  |  |  | CV11 0AA
1000 | Name 10 |  |  |  | PO12 4RT
Spreadsheet: 18fb3e1f-0612-491f-b2d0-7b8dd5fbfdb9
Sheet: Sheet1

Table 6--Cottonseed oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | Million pounds
2010/11 | 92.539 | 835 | 0.202 | 927.741 |  | 598.913 | 163.828 | 762.741 | 165
2011/121 | 165 | 755 | 10.347 | 930.347 |  | 571.486 | 258.861 | 830.347 | 100
2012/132 | 100 | 800 | 0.3 | 900.3 |  | 670.3 | 130 | 800.3 | 100
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2013-01-15 11:18:03.180000
Spreadsheet: 31064d1226783777-calculating-formula-not-working-properly-dif-formula-book-1
Sheet: recipe 1

RECIPE CALCULATOR
ingredient | servings in recipe | base serving size | cal / serving | total calories | fat | total fat | sat fat | total sat fat | carbs | total carbs | sugar | total sugar | fiber | total fiber | protein | total protein |  | sodium | total sodium | calcium | total calcium | chol | total cholesterol
broth, beef (college inn) 1 cup | 1.75 | 1 | 25 | 43.75 | 1 | 1.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 7 |  | 900 | 1575 | 20 | 35 | 0 | 0
broth, beef (college inn) 8 oz | 14 | 8 | 25 | 43.75 | 1 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 56 |  | 900 | 12600 | 20 | 280 | 0 | 0
broth, beef (college inn) 1 cup | 1 | 1 | 25 | 25 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 |  | 900 | 900 | 20 | 20 | 0 | 0
[NAME], Raw - 4 oz patty (edible portion 114 grams) USDA SR21 | 1.5 | 4 | 170 | 255 | 9.42 | 14.13 | 2.256 | 3.383999999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 19.9 | 29.85 |  | 107 | 160.5 | 15 | 22.5 | 90 | 135
[NAME], Raw - 4 oz patty (edible portion 114 grams) USDA SR21 | 6 | 4 | 170 | 1020 | 9.42 | 56.52 | 2.256 | 13.536 | 0 | 0 | 0 | 0 | 0 | 0 | 19.9 | 119.4 |  | 107 | 642 | 15 | 90 | 90 | 540
[NAME] all purpose enriched, unbleached (grams) | 1 | 100 | 364 | 364 | 0.98 | 0.98 | 0.155 | 0.155 | 76.31 | 76.31 | 0.27 | 0.27 | 2.7 | 2.7 | 10.33 | 10.33 |  | 0 | 0 | 0 | 0 | 0 | 0
[NAME] all purpose enriched, unbleached (grams) | 100 | 100 | 364 | 36400 | 0.98 | 98 | 0.155 | 15.5 | 76.31 | 7631 | 0.27 | 27 | 2.7 | 270 | 10.33 | 1033 |  | 0 | 0 | 0 | 0 | 0 | 0
[NAME] all purpose enriched, unbleached (grams) | 1.5 | 100 | 364 | 546 | 0.98 | 1.47 | 0.155 | 0.2325 | 76.31 | 114.465 | 0.27 | 0.405 | 2.7 | 4.050000000000001 | 10.33 | 15.495 |  | 0 | 0 | 0 | 0 | 0 | 0
total calories per recipe ===> | 38697.5 |  |  | the formula =IF(ISBLANK(A4),"",B4/C4*D4) fixed the problem with the servings in recipe and total calories.   However, the totals for fat, sat fat, carbs, etc (see ground turkey --- row 8) are incorrect - the calculation is now wrong if I enter the 6 ounces of ground turkey are in recipe and the base serving size is 4 ounces.  It works if I put in 1.5 --- but I need to be able to enter 6 ounces not 1.5.        In other words I need the information that is now in row 8 to have the same results as if I entered 1.5 in column b (as in row 7)     (row 7 & 8 are showing that 6 ounces of ground turkey are being added to the recipe)
servings per recipe ===>
calories per serving ===>
fat per recipe === > | 187.85
fat per serving ===>
sat fat per recipe ===> | 32.8075
sat fat per serving ===>
carbs per recipe ===> | 7821.775000000001
carb per serving ===>
sugar | 27.675
sugar
fiber | 276.75
fiber
protein | 1275.075
protein