tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 676486d1588831590-index-match-formula-manager-and-employee-for-work-contact-tree-book4
Sheet: Contact Tree

[NAME]. 1 |  |  |  | [NAME]. 2 |  |  |  | [NAME]. 3 |  |  |  | <------ I need the name of the employee to populate in the heading of the contact information.
Work [NAME] |  |  |  | Work [NAME] |  |  |  | Work [NAME]
Work Mob. |  |  |  | Work Mob. |  |  |  | Work Mob.
[NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Personal Mob. |  |  |  | Personal Mob. |  |  |  | Personal Mob.
Employee A |  |  |  | Employee B |  |  |  | Employee C |  |  |  | <------ I need the name of the employee to populate in the heading of the contact information.
ID |  |  |  | ID |  |  |  | ID |  |  |  | I need the same here but I want the formula to be based upon who the manger is for each employee
Position |  |  |  | Position |  |  |  | Position |  |  |  | so that their information is below the person that is there manager.
Mobile |  |  |  | Mobile |  |  |  | Mobile
[NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Employee D |  |  |  | Employee E |  |  |  | Employee F |  |  |  | <------ I need the name of the employee to populate in the heading of the contact information.
ID |  |  |  | ID |  |  |  | ID |  |  |  | I need the same here but I want the formula to be based upon who the manger is for each employee
Position |  |  |  | Position |  |  |  | Position |  |  |  | so that their information is below the person that is there manager.
Mobile |  |  |  | Mobile |  |  |  | Mobile
[NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Employee G |  |  |  | Employee H |  |  |  | Employee I |  |  |  | <------ I need the name of the employee to populate in the heading of the contact information.
ID |  |  |  | ID |  |  |  | ID |  |  |  | I need the same here but I want the formula to be based upon who the manger is for each employee
Position |  |  |  | Position |  |  |  | Position |  |  |  | so that their information is below the person that is there manager.
Mobile |  |  |  | Mobile |  |  |  | Mobile
[NAME] |  |  |  | [NAME] |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | <------ I need the name of the employee to populate in the heading of the contact information.
Empty |  |  |  | Empty |  |  |  | Empty |  |  |  | I need the same here but I want the formula to be based upon who the manger is for each employee
ID |  |  |  | ID |  |  |  | ID |  |  |  | so that their information is below the person that is there manager.
Position |  |  |  | Position |  |  |  | Position
Mobile |  |  |  | Mobile |  |  |  | Mobile
[NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Spreadsheet: 714725d1611336934-calcuating-absolute-numbers-from-percentage-temp1
Sheet: Department

 |  |  | Overall (450)
 |  |  | I am |  | Work more than 50%
Index | Question | Total ZFS (450) | AMG (99) | Union (351) | Onsite (57) | Remote (393)
I am interested in continuing to work remotely even once it’s safe to return to site: | Yes | 0.867 | 0.8979591836734694 | 0.8584070796460177
I am interested in continuing to work remotely even once it’s safe to return to site: | No | 0.133 | 0.1020408163265306 | 0.1415929203539823
 | Yes | 379 | 78 | 301
 | No | 58 | 8 | 50
 |  | How did we come up with above absolute numbers
Spreadsheet: 847570d1698423520-formula-to-fetch-data-but-also-check-for-duplicate-keys-and-act-based-on-outcome-second-dummy-data-sheet-full-
Sheet: Example of 11 duplicates

MeldingKey | MeldingMachineKey | InterneMemo | WerkVerricht | Opdrachtomschrijving | Invoerdatum
330830 | 151498 | Installatie voltooid | No show | Contact gelegd met Meldbank | 2017-09-05 15:15:52.913000
233457 | 151498 | Retourdoos geregeld en in behandeling | Contact gelegd met Meldbank | Retourdoos geregeld en in behandeling | 2016-04-28 10:43:35.443000
518097 | 151498 | Dient extra follow up te krijgen | Retourdoos geregeld en in behandeling | Contact gelegd met Meldbank | 2020-02-25 16:31:03.233000
279008 | 151498 | Retourdoos geregeld en in behandeling | Retourdoos geregeld en in behandeling | Dient extra follow up te krijgen | 2016-12-23 08:50:53.627000
530112 | 151498 | Getest maar geen bijzonderheden | Dient extra follow up te krijgen | Dient extra follow up te krijgen | 2020-05-04 09:14:40.180000
530109 | 151498 | Getest maar geen bijzonderheden | Dient extra follow up te krijgen | Melding getest | 2020-05-04 09:09:46.413000
278819 | 151498 | Uitbreiding toegepast | Dient extra follow up te krijgen | No show | 2016-12-22 12:50:43.313000
300784 | 151498 | Installatie voltooid | Contact gelegd met Meldbank | No show | 2017-03-31 14:25:14.947000
644222 | 151498 | Getest maar geen bijzonderheden | Contact gelegd met Meldbank | Contact gelegd met Meldbank | 2022-01-18 11:34:26.693000
292161 | 151498 | Melding getest | Dient extra follow up te krijgen | No show | 2017-02-17 13:20:00.190000
292318 | 151498 | Installatie voltooid | Melding getest | Uitbreiding toegepast | 2017-02-20 08:17:13.030000
Spreadsheet: 3ddcdb7b-cead-4639-8067-f21e82c6f073
Sheet: Fields S-U

Permit No.: |  |  | WQ0029233 |  |  | Facility Name: |  | Bear Lake Reserve |  |  |  |  |  | County: | [NAME] |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | S |  | Field Name: |  | T |  | Field Name: |  | U |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 0.92 |  | Area (acres): |  | 0.61 |  | Area (acres): |  | 0.58 |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.05 |  | [NAME] (in): |  | 0.05 |  | [NAME] (in): |  | 0.05 |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 67.4 / 6.7 |  | Annual Rate (in): |  | 73.5 / 7.3 |  | Annual Rate (in): |  | 95.4 / 9.5 |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 285515d1387673565-i-need-to-sum-multiple-text-items-within-a-cell-that-have-different-values-job-tracker-test
Sheet: Weekly Job Pay

Date | Account # | Cust Name | Job Type |  | Line Items Closed | Start Time | Stop Time | Hours | Paid | Hourly rate |  | INSTALL BASE | 16.71
 |  |  | Upgrade |  | Swap Replace | 07:59:00 | 10:36:00 |  |  |  |  | HD/DVR | 17.58
 |  |  |  |  | Swap Replace |  |  |  |  |  |  | IRD | 13.71
 |  |  |  |  | Swap Replace |  |  |  |  |  |  | SWM/KAKU ODU | 12.5
 |  |  |  |  | IRD |  |  |  |  |  |  | ODU UPGRADE | 18.42
 |  |  |  |  | ODU Upgrade |  |  |  |  |  |  | ADDITIONAL LABOR | 13.71
 |  |  |  |  | Additional Labor |  |  |  |  |  |  | BB DECA | 13.71
 |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] | 6.86
 |  |  |  |  |  |  |  |  |  |  |  | UPGRADE BASE | 12.29
 |  |  | Install |  | [NAME], client, swm odu, internal deca, aditional labor. | 08:17:00 | 11:48:00 |  | 77.2 |  |  | SWAP REPLACE | 10
 |  |  | Upgrade |  | ug, swap replace,odu ug, deca, adtl labor. | 12:42:00 | 15:05:00 |  |  |  |  | COMMERCIAL INSTALL BASE | 61.29
 |  |  |  |  |  |  |  |  |  |  |  | DPP | 4
 |  |  |  |  |  |  |  |  |  |  |  | PPP | 7
 |  |  |  |  |  |  |  |  |  |  |  | SERVICE CALL | 34
 |  |  |  |  |  |  |  |  |  |  |  | UPGRADE ADD OUTLET | 13.71
 |  |  |  |  |  |  |  |  |  |  |  | COMMERCIAL MOUNT | 20
 |  |  |  |  |  |  |  |  |  |  |  | COMMERCIAL SERVICE CALL | 50
Spreadsheet: 544478d1508920681-product-order-optimisation-test-data
Sheet: Sheet1

out
Click Volume | 1000
Click Share | 0.3548378527106776 | 0.1523786030095448 | 0.1165221351448794 | 0.09807776238638304 | 0.07228220649348184 | 0.05565950018026906 | 0.04468395984743543 | 0.04434619252737243 | 0.03253951687887816 | 0.0286722708210782
Position | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Product 1 | 0.3282941266046283 | 0.09792389780758952 | 0.06483348677771936 | 0.05378324086673049 | 0.03763947970155039 | 0.03036300845007509 | 0.02137119708174898 | 0.03450876306238158 | 0.01733371640252636 | 0.01532648469577928
Product 2 | 0.08700738061810606 | 0.06463510544631154 | 0.03627873859242786 | 0.0395753668591419 | 0.02900432654585517 | 0.02189797914469669 | 0.01549266128712024 | 0.01648782617151959 | 0.009759292748204381 | 0.005805225716246459
Product 3 | 0.2843654950093158 | 0.08471985026224621 | 0.102075555872776 | 0.06154839294974783 | 0.04715752206855917 | 0.02852091795769125 | 0.03254373777410162 | 0.04086927563746933 | 0.03686533024040269 | 0.03209850255541037
Product 4 | 0.2842553353173245 | 0.1199836665968859 | 0.08815741288790484 | 0.0704125815922389 | 0.055276759977794 | 0.04274665323827942 | 0.03470316148036767 | 0.0345332065133095 | 0.01845165693603265 | 0.0168710934980634
Product 5 | 0.606829296271252 | 0.3162520097348221 | 0.2232098742281882 | 0.1894391873452315 | 0.08301711483834276 | 0.09531200736933504 | 0.03693204321518898 | 0.006517822835243997 | 0.007553676304066644 | 0.01660484128845366
Product 6 | 0.2589003865309124 | 0.1176125790366832 | 0.07200545567018327 | 0.05138356005361941 | 0.06001848640730691 | 0.04431453129861346 | 0.02845937588790138 | 0.02989183564229071 | 0.02678991453555069 | 0.02278300915641998
Product 7 | 0.1489057450711082 | 0.1022096101762042 | 0.04644842408926559 | 0.03453670168187895 | 0.02496563951007856 | 0.01856999922183582 | 0.01617262818676799 | 0.01400709814072935 | 0.012442206945224 | 0.01058768477565872
Product 8 | 0.1673338400461997 | 0.07725202756386063 | 0.05882698682049252 | 0.05993433813244309 | 0.03634295499316902 | 0.03561249549612755 | 0.02116678568184961 | 0.02005746679375989 | 0.01567050015634361 | 0.01358079750915243
Product 9 | 0.1134664237761594 | 0.02502892406056801 | 0.01929057412593202 | 0.05653964387842805 | 0.03596307778690108 | 0.009978418328676731 | 0.00743460909915914 | 0.007590741930556055 | 0.006337081894725034 | 0.01051170093766665
Product 10 | 0.245863495611291 | 0.09290595373462901 | 0.08067755988402986 | 0.08054153880710392 | 0.04664782925384512 | 0.03590075473368393 | 0.04410152072406733 | 0.05671192271827587 | 0.0344666570481923 | 0.03033275574768161
Desired Solution would be a table as below which shows what order is optimal and a calculation of what the total income would be
Position | Product
1
2
3
4
5
6
7
8
9
10
Total Income | £
Spreadsheet: 0a7e4838-61b0-43fb-b54f-a0e6a4ff38b5
Sheet: Sheet1

Name: |  | Campus ID:
Charges - See Worksheet Instructions | Fall | Spring | Full Year Total
1. Tuition | 13491 | 13491
2. Student Fee | 470 | 470
3. Room & Board | 4350 | 4350
4. [NAME] | 285 | 0
5. Health Insurance | 0
6. Other Charges | 0 | 0
7. Prior Balance Owed | 0 | 0
Subtotal A – Total Charges
Financial Aid - See Award Letter | Fall | Spring | Full Year Total
8. ENC Scholarships and Grants | 0 | 0
9. Nazarene Church Scholarship and Match | 0 | 0
10. Outside [NAME] | 0 | 0
11. Subsidized [NAME] | 0 | 0
12. [NAME] | 0 | 0
13. [NAME] | 0 | 0
14. SEOG Grant | 0 | 0
15. State Grant | 0 | 0
16. Other State or Government Aid | 0 | 0
Subtotal B – Total Financial Aid
Payments | Fall | Spring | Full Year Total
17. Admission Dep./Credit Balance from prior term | 0 | 0
18. TMS Monthly Payment Plan |  | 0
19. Other Loan -Name___________________ | 0 | 0
20. Parent PLUS Loan | 0 | 0
21. Payroll Deductions | 0 | 0
22. Cash, [NAME] or Credit Card Payments | 0 | 0
Subtotal C- Total Payments
Balance [A - B (Award) - C]
Please make sure that your balance at the bottom of this sheet comes to $0
Please contact the Offices of Student Accounts or Financial Aid with any questions.
[EMAIL] [PHONE], [EMAIL] [PHONE]
Spreadsheet: 86269d1286290155-moving-data-when-a-match-is-found-on-a-different-tab-example
Sheet: Tracker

Number | Description | Authorization Status | Shipment Amount | Quantity Billed | PREVIOUS BILLED O/S | May | June | July | AUG | SEPT |  | Buyer | BILLING COMPLETE AFTER INVOICE | [NAME] | Mail Date | Notes
PWLE\2 | #N/A | Rels | 5500 |  |  |  |  |  |  | 0 | 5500
PWLE\3 |  | Rels | 110095.47 |  |  |  |  |  |  | 0
PWLE\4 |  | Rels |  |  |  |  |  |  | 0 | 0 | 0
PWLE\5
PWLE\6
PWLE\8
PWLE\9
PWLE\10
PWLE\11
PWLE\11
PWLE\11
PWLE\11
PWLE\12 | FIND THESE IN REPORT TAB
PWLE\13
PWLE\14
PWLE\15
PWLE\16
PWLE\16
PWLE\17
PWLE\17
PWLE\17
PWLE\17
PWLE\17
PWLE\18
PWLE\19
PWLE\20
PWLE\21
PWLE\21
PWLE\22
PWLE\23
PWLE\24
PWLE\24
PWLE\25
PWLE\25
PWLE\26
PWLE\26
PWLE\27
PWLE\27
PWLE\28
PWLE\28
PWLE\29
PWLE\29
PWLE\30
PWLE\31
PWLE\31
PWLE\31
PWLE\32
PWLE\33
PWLE\34
PWLE\34
PWLE\35
PWLE\36
PWLE\36
PWLE\37
PWLE\37
PWLE\38
PWLE\39
PWLE\39
PWLE\39
PWLE\40
PWLE\41
PWLE\42
PWLE\43
PWLE\44
PWLE\45
PWLE\45
PWLE\45
Spreadsheet: 698163d1601820965-get-date-from-range-based-on-min-and-max-values-sample
Sheet: Sheet1

 |  |  |  | EQUIPMEN_CODE | PERIOD | PERIODUOM_DISPLAY |  |  | NEXT_DUE_DATE | WORKORDER | DATE_OF_LAST_COMPETION_WO
 |  |  |  | STD1 | 1 | Years | 365 |  | 2020-02-01 00:00:00 | 6894403 | 2019-02-20 00:00:00 | [NAME] : Next due date
 |  |  |  | STD1 | 1 | Months | 30 |  | 2020-10-01 00:00:00 | 7607714 | 2020-09-02 00:00:00 | min: Date of last completion
 |  |  |  | STD2 | 1 | Years | 365 |  | 2020-02-01 00:00:00 | 6990962 | 2019-04-17 00:00:00
 |  |  |  | STD2 | 1 | Months | 30 |  | 2020-10-01 00:00:00 | 7608818 | 2020-09-03 00:00:00
 |  |  |  |  |  |  |  |  | Next Due Date | Date of last completion
 |  |  |  | STD1 | 1 | Months | 30 |  | 2020-10-01 00:00:00
 |  |  |  | STD2 | 1 | Years | 365 |  |  | 2019-04-17 00:00:00
Spreadsheet: 199199d1355142565-vlookup-help-uk_dial_plan_01092012-met-lookup
Sheet: 03 UK Wide

Number Range | [NAME] | Day | Evening | Weekend
300 | g21
302 | g21
303 | g21
306 | g21
330 | g21
331 | g21
332 | g21
333 | g21
343 | g21
344 | g21
345 | g21
370 | g21
371 | g21
372 | g21
Spreadsheet: 198969d1354985994-matching-with-other-columns-file1
Sheet: Sheet1

mail code |  |  |  |  |  |  |  |  |  | mail code | cusip | [NAME]
233 |  |  |  |  |  |  |  |  |  | 436 | 123123123 | AB-KDGADD
231 |  |  |  |  |  |  |  |  |  | 754 | 454564A99 | CD-KDGADD
123 |  |  |  |  |  |  |  |  |  | 333 | 365125B99 | EF-KDGADD
654 |  |  |  |  |  |  |  |  |  | 625 | 111111K99 | GH-KDGADD
421 |  |  |  |  |  |  |  |  |  | 555 | 999777P99 | IJ-KDGADD
621 |  |  |  |  |  |  |  |  |  | 963 | 120120D99 | KL-KDGADD
754 |  |  |  |  |  |  |  |  |  | 521 | 789789789 | MN-KDGADD
361 |  |  |  |  |  |  |  |  |  | 654 | 456456456 | OP-KDGADD
111 |  |  |  |  |  |  |  |  |  | 781 | 321321321 | QR-KDGADD
436 |  |  |  |  |  |  |  |  |  | 444 | 545454544 | ST-KDGADD
521
781
860
147
963
555
145
333
444
625
Spreadsheet: 266469d1379620825-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-county-fips-codes
Sheet: GEORGIA-10

 | COUNTY | CODE
 | Appling | 1
 | Atkinson | 3
 | Bacon | 5
 | [NAME] | 7
 | Baldwin | 9
 | Banks | 11
 | Barrow | 13
 | Bartow | 15
 | [NAME] | 17
 | [NAME] | 19
 | Bibb | 21
 | Bleckley | 23
 | Brantley | 25
 | Brooks | 27
 | [NAME] | 29
 | [NAME] | 31
 | Burke | 33
 | Butts | 35
 | [NAME] | 37
 | Camden | 39
 | Candler | 43
 | Carroll | 45
 | Catoosa | 47
 | Charlton | 49
 | Chatham | 51
 | Chattahoochee | 53
 | Chattooga | 55
 | Cherokee | 57
 | Clarke | 59
 | Clay | 61
 | [NAME] | 63
 | Clinch | 65
 | Cobb | 67
 | Coffee | 69
 | Colquitt | 71
 | Columbia | 73
 | [NAME] | 75
 | Coweta | 77
 | Crawford | 79
 | Crisp | 81
 | Dade | 83
 | Dawson | 85
 | Decatur | 87
 | DeKalb | 89
 | Dodge | 91
 | Dooly | 93
 | [NAME] | 95
 | [NAME] | 97
 | Early | 99
 | [NAME] | 101
 | [NAME] | 103
 | Elbert | 105
 | Emanuel | 107
 | Evans | 109
 | Fannin | 111
 | Fayette | 113
 | [NAME] | 115
 | [NAME] | 117
 | Franklin | 119
 | Fulton | 121
 | Gilmer | 123
 | Glascock | 125
 | Glynn | 127
 | [NAME] | 129
 | Grady | 131
 | Greene | 133
 | [NAME] | 135
 | [NAME] | 137
 | Hall | 139
 | Hancock | 141
 | Haralson | 143
 | [NAME] | 145
 | Hart | 147
 | Heard | 149
 | [NAME] | 151
 | Houston | 153
 | Irwin | 155
 | [NAME] | 157
 | Jasper | 159
 | [NAME] | 161
 | [NAME] | 163
 | Jenkins | 165
 | [NAME] | 167
 | Jones | 169
 | Lamar | 171
 | Lanier | 173
 | [NAME] | 175
 | [NAME] | 177
 | Liberty | 179
 | Lincoln | 181
 | Long | 183
 | Lowndes | 185
 | Lumpkin | 187
 | [NAME] | 189
 | Mclntosh | 191
 | Macon | 193
 | [NAME] | 195
 | Marion | 197
 | Meriwether | 199
 | [NAME] | 201
 | Mitchell | 205
 | Monroe | 207
 | Montgomery | 209
 | Morgan | 211
 | [NAME] | 213
 | Muscogee | 215
 | Newton | 217
 | Oconee | 219
 | Oglethorpe | 221
 | Paulding | 223
 | Peach | 225
 | Pickens | 227
 | Pierce | 229
 | Pike | 231
 | Polk | 233
 | Pulaski | 235
 | Putnam | 237
 | Quitman | 239
 | Rabun | 241
 | Randolph | 243
 | Richmond | 245
 | Rockdale | 247
 | Schley | 249
 | Screven | 251
 | Seminole | 253
 | Spalding | 255
 | [NAME] | 257
 | [NAME] | 259
 | Sumter | 261
 | Talbot | 263
 | Taliaferro | 265
 | [NAME] | 267
 | [NAME] | 269
 | Telfair | 271
 | Terrell | 273
 | [NAME] | 275
 | Tift | 277
 | Toombs | 279
 | Towns | 281
 | Treutlen | 283
 | Troup | 285
 | Turner | 287
 | Twiggs | 289
 | Union | 291
 | Upson | 293
 | Walker | 295
 | [NAME] | 297
 | Ware | 299
 | [NAME] | 301
 | Washington | 303
 | Wayne | 305
 | [NAME] | 307
 | Wheeler | 309
 | White | 311
 | [NAME] | 313
 | Wilcox | 315
 | Wilkes | 317
 | Wilkinson | 319
 | Worth | 321
Spreadsheet: 779802d1652110051-sum-two-or-more-columns-based-on-single-or-more-criteria-working-sum
Sheet: Data

 |  | Vessel | S/O Company | Bank balances as of 31.03.2021
 |  |  |  |  | Amount X | Amount Y
98 | 1 | Tasman | Tasman Marine LLC |  | 4871.25 | 9742.5
A6 | 2 | Dimitris Y | Hudson Marine LLC |  | 5097.745000000054 | 10195.49000000011
A7 | 3 | [NAME] | Drake Marine LLC |  | 11839.02999999999 | 23678.05999999998
T148 | 4 | MSC Qingdao | Global Ship Lease 52 LLC |  | 329399.23 | 658798.46
T149 | 5 | GSL Matisse (Sold Vessel) | Global Ship Lease 37 LLC |  | 4504.580000000001 | 9009.160000000002
T150 | 6 | GSL Ningbo | Global Ship Lease 43 LLC |  | 383399.6000000001 | 766799.2000000002
T151 | 7 | CMA CGM Utrillo (Sold Vessel) | Global Ship Lease 39 LLC |  | 369.2449999999999 | 738.4899999999998
T152 | 8 | CMA CGM Jamaica | Global Ship Lease 50 LLC |  | 489697.38 | 979394.76
T153 | 9 | CMA CGM America | Global Ship Lease 51 LLC |  | 445506.5450000002 | 891013.0900000003
T154 | 10 | CMA CGM Berlioz | Global Ship Lease 48 LLC |  | 440715.6850000002 | 881431.3700000003
T155 | 11 | CMA CGM Alcazar | GSL Alcazar Inc. |  | 210185.435 | 420370.87
T156 | 12 | CMA CGM Thalassa | Global Ship Lease 54 LLC |  | 452619.0749999998 | 905238.1499999997
T157 | 13 | [NAME] | Global Ship Lease 44 LLC |  | 4334.025000000009 | 8668.050000000017
T158 | 14 | CMA CGM Chateau d' If | Global Ship Lease 47 LLC |  | 132700.8200000001 | 265401.6400000001
T159 | 15 | CMA CGM Sambhar | Global Ship Lease 49 LLC |  | 427905.57 | 855811.14
T160 | 16 | [NAME] | Global Ship Lease 40 LLC |  | 58629.48000000001 | 117258.96
T161 | 17 | Kumasi | Global Ship Lease 45 LLC |  | 63841.99999999997 | 127683.9999999999
T162 | 18 | [NAME] | Global Ship Lease 41 LLC |  | 169577.705 | 339155.41
T163 | 19 | [NAME] | Global Ship Lease 38 LLC |  | 259136.75 | 518273.5
T165 | 20 | MSC Tianjin | Global Ship Lease 53 LLC |  | 180595.22 | 361190.44
T166 | 21 | GSL La Tour | Global Ship Lease 46 LLC |  | 4432.075000000041 | 8864.150000000081
T184 | 22 | GSL Christen (ex NYK Lynx) | Global Ship Lease 36 LLC |  | 4677.00999999998 | 9354.01999999996
T185 | 23 | GSL Nicoletta (ex NYK Libra) | Global Ship Lease 35 LLC |  | 3237.36500000002 | 6474.73000000004
Spreadsheet: 788453d1658485593-how-to-use-multiple-vlookup-multiple-vlookup
Sheet: full_data

person | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00
10 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1
11 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0
12 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0
13 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0
14 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1
15 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 1
Spreadsheet: 132341d1323707922-need-a-count-of-how-many-rows-have-value-x-value-y-and-value-z-in-a-column-a-dierollcounts
Sheet: Sheet1

Die Roll |  |  | Counts
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
Spreadsheet: 824988d1681007736-what-s-is-a-simple-formula-to-add-12-24-from-another-worksheet-copy-of-ak-sample
Sheet: COVER-24

 | AK |  |  |  |  |  | unlock 1111 |  |  |  |  |  |  | combo | Cover
Well No. | 12H | 13H | 14H | 15H | Total |  |  |  |  |  |  |  |  | combo
Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Online/Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Choke |  |  |  |  |  |  |  |  |  |  |  |  |  | lt f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | lt p
Casing PSI |  |  |  |  |  |  | Copy and paste table into email body |  |  |  |  |  |  | fork
Surface Csg |  |  |  |  |  |  |  |  |  |  |  |  |  | lift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | trash
Water / Day |  | 1200 |  |  |  | Clear | enter water totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | ft
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ft
Oil / Day |  | 1200 |  |  |  |  | enter oil totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
[NAME] to sales |  |  |  |  |  |  |  |  |  |  |  |  |  | plug C
Gas / Day |  | 1200 |  |  |  |  | enter gas totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
Inj / Day | off | off | off |  |  |  |  |  |  |  |  |  |  | st
 |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Yesterday Lact |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Comments |  |  |  |  |  |  | gfhghcghghgvhvgvgvhgvhvghvgvgh
 | PM
 | 12H | 13H | 14H | 15H
GAS
WATER
OIL
 | AM |  |  |  |  |  | lact total
 | 12H | 13H | 14H | 15H |  |  | 0430 | 24 b4 |  |  |  |  | IF(g28-h28<0,0,g28-h28)
GAS |  |  |  |  |  | 750 |  | 118029
WATER |  |  |  |  |  | 760
OIL |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 790758d1659978608-calculate-number-of-occurences-based-on-range-of-days-entered-example-attendance-tracker
Sheet: Calendar View

 | EMPLOYEE ATTENDANCE RECORD
 | Select an Employee: | Agent 1
 | Enter Year: | 2022
 | Weekday/Month | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU  2 | FRI | SAT
 | January
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 | KEY STATISTICS
 |  | # of Unscheduled Absences |  |  |  |  | Early Departure |  |  |  |  | Lates |  |  |  |  | Total occurances in the last 90 days |  |  |  |  |  | Total occurances in the last 60 days |  |  |  |  |  | Total occurances in the last 30 days |  |  |  |  |  | Total Occurances
 |  | Late Return - Lunch |  |  |  |  | Late Return - Break |  |  |  |  | No Call/No Show