tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: drew_fossum__8993__sharris1000wk5
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  |  |  |  |  | 2000-11-01 13:02:57.960000
 |  | October, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
 |  | .
West Demand Revenues |  | 9.8464 | 10.15766454 | 0.311264539999998 |  | Prices in excess of $0.12/mmbtu on 63/day.
West Commodity Revenues |  | 0.7731999999999999 | 0.8400669536 | 0.06686695360000017 |  | Higher volumes than in plan.
East Demand Revenues |  | 1.1254 | 1.0849816046 | -0.04041839540000014 |  | Burlington 24216--($53k)
East Commodity Revenues |  | 0.1709 | 0.142436897352 | -0.02846310264799998 |  | Lower East IT Rates
[NAME] |  | 0.6644000000000001 | 0.65624675 | -0.008153250000000112
[NAME] Revenues |  | 0.05890000000000001 | 0.1450369508 | 0.0861369508 |  | higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance |  | 12.6382 | 13.026433696352 | 0.3882336963519961
[NAME] due to Price |  |  |  | 0.820900430165379 |  | Current index price of $4.77
[NAME] due to net fuel retention. |  |  |  | -0.2606385249959967
Hedging Adjustment |  |  |  | -0.1767000000000005 |  | First of the month Index Price $5.15
Unaccounted for Variance |  |  |  | -0.021
 |  |  |  | -------------
Fuel Variance |  |  |  | 0.3625619051693817
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE |  |  |  | 0.7507956015213778
 |  |  |  | ========
Resolution of El Paso Measurement Dispute |  |  |  | 3.0074
 |  |  |  | -------------
Adjusted Month-to-Date Variance |  |  |  | 3.758195601521378
 |  |  |  | ========
[NAME]
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (through September) |  | 122.2891 | 17.1504 | 139.4395
Actuals through August with Sept. Wkly. |  | 123.604033696352 | 22.04847095605238 | 145.6525046524044
 |  | ------------- | ------------- | -------------
Variance from Plan |  | 1.314933696351986 | 4.898070956052376 | 6.213004652404361
 |  | ------------- | ------------- | -------------
Resolution of El Paso Fuel Dispute |  |  |  | 3
 |  |  |  | -------------
Adjusted Variance from Plan |  |  |  | 9.213004652404361
 |  |  |  | ========
Spreadsheet: 687992d1595516884-extract-records-assigned-to-contact-name-and-count-number-of-days-in-current-status-tracker
Sheet: Tracker

Record | Contact | Stauts | Date Assigned | Completeness Review | Review Meeting | [NAME] | Team Lead Review | Supervisor Review | CFO Review | CEO Review
Montgomery | Green | Under Review | 2020-04-07 00:00:00 | 2020-04-14 00:00:00 | 2020-04-17 00:00:00 | 2020-04-30 00:00:00 | 2020-05-10 00:00:00 | 2020-05-26 00:00:00 | 2020-06-15 00:00:00 | 2020-06-29 00:00:00
[NAME] | [NAME] | Denied | 2020-04-08 00:00:00 | 2020-04-15 00:00:00 | 2020-04-18 00:00:00 | 2020-05-01 00:00:00 | 2020-05-11 00:00:00 | 2020-05-27 00:00:00
[NAME] | Philips | Partial Approved | 2020-04-09 00:00:00 | 2020-04-16 00:00:00 | 2020-04-19 00:00:00 | 2020-05-02 00:00:00 | 2020-05-12 00:00:00
[NAME] | Green | Under Review | 2020-04-10 00:00:00 | 2020-04-17 00:00:00 | 2020-04-20 00:00:00 | 2020-05-03 00:00:00 | 2020-05-13 00:00:00 | 2020-05-29 00:00:00 | 2020-06-18 00:00:00
St. Charles | Toney | Partial Approved | 2020-04-11 00:00:00 | 2020-04-18 00:00:00 | 2020-04-21 00:00:00 | 2020-05-04 00:00:00 | 2020-05-14 00:00:00 | 2020-05-30 00:00:00 | 2020-06-19 00:00:00 | 2020-07-03 00:00:00
[NAME] | [NAME] | Denied | 2020-04-12 00:00:00 | 2020-04-19 00:00:00 | 2020-04-22 00:00:00 | 2020-05-05 00:00:00
Baltimore | Philips | Under Review | 2020-04-13 00:00:00 | 2020-04-20 00:00:00 | 2020-04-23 00:00:00 | 2020-05-06 00:00:00 | 2020-05-16 00:00:00 | 2020-06-01 00:00:00 | 2020-06-21 00:00:00 | 2020-07-05 00:00:00
Washington | Toney | Partial Approved | 2020-04-14 00:00:00 | 2020-04-21 00:00:00 | 2020-04-24 00:00:00 | 2020-05-07 00:00:00 | 2020-05-17 00:00:00 | 2020-06-02 00:00:00
Fairfax | Green | Under Review | 2020-04-15 00:00:00 | 2020-04-22 00:00:00 | 2020-04-25 00:00:00 | 2020-05-08 00:00:00 | 2020-05-18 00:00:00 | 2020-06-03 00:00:00 | 2020-06-23 00:00:00 | 2020-07-07 00:00:00
Arlington | [NAME] | Denied | 2020-04-16 00:00:00 | 2020-04-23 00:00:00 | 2020-04-26 00:00:00 | 2020-05-09 00:00:00 | 2020-05-19 00:00:00
Spreadsheet: 46837d1245770307-automatically-getting-data-from-one-sheet-to-another-brigadeschedules
Sheet: Battle Cross Bands

Bands for Battle Cross Services
Name | POC | Address | Phone Number | Date
Delta Cross (Bethesda Ministries) | [NAME] and [NAME] | 2738 Ring Road Elizabethtown, KY 42701 | [PHONE] | 2009-06-07 00:00:00
Even Me | [NAME] | Living Stones Fellowship 6775 HWY 22 West Falmouth, KY 41040 | [PHONE] | 2009-07-12 00:00:00
Stoner Memorial A.M.E. Zion Church | [NAME] | 12th and Oak Street, Louisville, KY | [PHONE] | 2009-08-02 00:00:00
Wayside Christian Church | ??? |  | [PHONE] | 2009-09-06 00:00:00
[NAME] and [NAME] | [NAME] | 4410 Sportsmans Lake Rd, Elizabethtown, KY 42701 | [PHONE] | 2009-10-04 00:00:00
Spreadsheet: 677392d1589332435-remove-all-except-a-z-korean-characters-and-spaces-sample
Sheet: Sheet1

BEFORE | AFTER
🐽1. tidy | tidy
🐽2temperature | temperature
🐽3to grow | to grow
🐽4to forget | to forget
🐽/ 5to startled | to startled
🐽6temperature goes down | temperature goes down
🐽7temperature is high | temperature is high
🐽8to refresh oneself | to refresh oneself
🐽,  9neat and clean | neat and clean
🐽10temperature goes up | temperature goes up
🦔11기온이 낮다 | 기온이 낮다
🦔12깎다 | 깎다
🦔13. [NAME] | 까다롭다
[NAME] 재해 | 기타 재해
🦔15:   기억하다 | 기억하다
[NAME] | 기출문제
[NAME] | 꼼꼼히
🦔18,    꽂다 | 꽂다
🦔19기본급 | 기본급
..[NAME] | 끊다
Spreadsheet: 876400d1723084879-how-to-search-for-values-across-multiple-sheets-vi-du
Sheet: T5-2024

1~2 years |  | > 2 years
KG | Amount | KG | Amount
29625.53 | 1428157316 | 44681.14 | 2929826744
51A-004.65 | INNOVA
52U-4032 | INNOVA
56S-3927 | INNOVA
86A-002.48 | INNOVA
51A-004.62 | INNOVA
52U-2298 | INNOVA
52U-2296 | INNOVA
51F-009.94 | VIOS
51F-011.24 | VIOS
56M-1275 | VIOS
56M-1009 | VIOS
51A-757.80 | VIOS
51A-627.92 | VIOS
56M-2000 | VIOS
51F-091.90 | VIOS
51A-497.10 | VIOS
51A-240.63 | VIOS
51F-156.46 | VIOS
51F-113.16 | VIOS
56M-2153 | INNOVA
56M-2405 | INNOVA
52U-0258 | INNOVA
52U-2364 | INNOVA
52F-1814 | INNOVA
51A-702.54 | INNOVA
51A-728.36 | INNOVA
51F-019.83 | INNOVA
50Z-9802 | INNOVA
51A-333.06 | INNOVA
56K-8881 | INNOVA
52U-0266 | INNOVA
51F-010.86 | INNOVA
52U-2221 | INNOVA
51A-815.18 | INNOVA
51A-481.31 | INNOVA
52U-1333 | INNOVA
52Z-7333 | INNOVA
56N-8904 | INNOVA
52F-1817 | INNOVA
52P-0190 | INNOVA
52F-1816 | INNOVA
51A-759.21 | INNOVA
52U-0210 | INNOVA
52F-1835 | INNOVA
51A-841.56 | INNOVA
52U-2367 | INNOVA
51A-838.26 | INNOVA
52F-1821 | INNOVA
52P-9794 | INNOVA
52P-9684 | INNOVA
52U-1373 | INNOVA
52U-3280 | INNOVA
51A-708.26 | INNOVA
51A-722.10 | INNOVA
51A-727.44 | INNOVA
52F-1812 | INNOVA
51A-701.02 | INNOVA
50Z-3206 | INNOVA
51A-842.31 | INNOVA
52F-4916 | INNOVA
50Z-7371 | INNOVA
50Z-7344 | INNOVA
52F-4890 | INNOVA
30A-010.99 | INNOVA
52F-1828 | INNOVA
51A-685.59 | INNOVA
51F-090.48 | SUNNY
51F-068.83 | i10
51F-212.15 | i10
51F-188.33 | i10
51F-188.32 | i10
51F-201.98 | SUNNY
56M-2189 | VIOS
51A-989.07 | VIOS
51F-069.18 | VIOS
51A-496.88 | VIOS
51A-919.65 | VIOS
51F-085.80 | VIOS
51A-849.10 | VIOS
51A-835.18 | VIOS
51F-048.26 | VIOS
56K-7467 | VIOS
56M-1840 | VIOS
79A-062.23 | VIOS
51A-944.52 | VIOS
51A-918.05 | VIOS
51F-011.19 | VIOS
51F-017.74 | VIOS
51F-091.97 | VIOS
51F-145.67 | VIOS
51F-184.14 | i10
Spreadsheet: 804987d1668459634-moving-a-row-into-another-sheet-automated-please-help-test-book
Sheet: South America

 | Brazil | Chile | Argentina | Uruguay | Paraguay | Bolivia | Peru | Ecuador | Colombia | Venezuela | Guyana
 |  | x |  |  | x |  |  |  | x | x
 | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  | x |  |  |  | x
 | x | x | x | x | x | x | x | x | x | x | x
Spreadsheet: ca7cba36-3ea2-49ef-91e6-239f9b2285fb
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8356 | 21847 | Sophie | Corbidge | NZL | 2 | 00:10:18 | 00:00:21 | 00:33:50 | 00:00:34 | 00:17:33 | 1 | 01:02:39
8356 | 39490 | Mikayla | Nielsen | NZL | 1 | 00:10:23 | 00:00:17 | 00:33:49 | 00:00:34 | 00:17:56 | 2 | 01:03:01
8356 | 39171 | [NAME] | Wood | NZL | 3 | 00:10:16 | 00:00:19 | 00:33:57 | [NAME] | 00:19:26 | 3 | 01:04:28
8356 | 40200 | Lauren | Parker | AUS | 4 | 00:10:16 | 00:00:21 | 00:33:54 | 00:00:34 | 00:21:45 | 4 | 01:06:51
8356 | 39485 | Elise | Salt | NZL | 5 | 00:10:33 | 00:00:10 | 00:36:30 | [NAME] | 00:20:33 | 5 | 01:08:27
Spreadsheet: andy_zipper__293__NYMEX Straddles
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | H | 215 | 32 | 33 | 0.7151499999999951 | 0.006599999999999273
 | J | 220 | 39 | 40 | 0.5914999999999933 | 0.01784999999999803
 | K | 225 | 44.5 | 45.5 | 0.5271999999999959 | 0.01469999999999838
 | M | 230 | 49.5 | 51 | 0.4918999999999976 | 0.01889999999999792
 | N | 240 | 56.5 | 57.5 | 0.4850999999999813 | 0.007199999999999207
 | Q | 245 | 64 | 69 | 0.5043499999999798 | 0.01979999999999782
 | U | 245 | 68 | 70 | 0.4863499999999817 | 0.003599999999999604
 | V | 250 | 74.5 | 75 | 0.4863499999999817 | 0.002249999999999752
 | X | 270 | 85 | 86.5 | 0.4857499999999818 | -0.001499999999999835
 | Z | 290 | 95 | 97.5 | 0.4831999999999821 | -0.002399999999999736
 | F | 300 | 105 | 108 | 0.4983000000000046 | -0.004499999999999504
 | G | 300 | 105 | 110 | 0.4884000000000057 | -0.004499999999999504
 | H03 | 290 | 99 | 102 | 0.4534999999999985 | -0.006599999999999273
 | M03 | 285 | 90 | 94 | 0.3860499999999999 | -0.0045
 |  |  | 2002-01-31 14:33:58.500000
 |  |  | Crude Oil Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | H | 1950 | 145 | 155 | 0.4763999999999993 | -0.02549999999999719
 | J | 2000 | 248 | 258 | 0.4608999999999984 | -0.03779999999999584
 | K | 2000 | 320 | 330 | 0.4477499999999983 | -0.03659999999999597
 | M | 2000 | 376 | 380 | 0.444849999999996 | -0.02459999999999729
 | N | 2000 | 410 | 425 | 0.4302999999999955 | -0.02459999999999729
 | Q | 2000 | 440 | 455 | 0.4204499999999954 | -0.01949999999999785
 | U | 2000 | 455 | 475 | 0.4068500000000003 | -0.02279999999999749
 | V | 2000 | 475 | 490 | 0.3922000000000017 | -0.01529999999999831
 | X | 2050 | 480 | 500 | 0.3706499999999874 | -0.01769999999999805
 | Z | 2050 | 480 | 500 | 0.3526499999999894 | -0.01529999999999831
 | M03 | 2050
 | Z03 | 2100
 |  |  | 2002-01-31 14:37:38.010000
Spreadsheet: 851768d1701900002-help-with-a-filter-formula-and-date-sample
Sheet: What's Happening

 | Worksheet Name |  | What is the worksheet doing? | User Intervention
 | Step 0 | Paste FULL Report Here | Pulling in raw data from SF report | Copy / Paste FULL report trhat is output from SalesForce, headers and all
 | Step 1 | "All Data" | Makes previous data useable | None
 | Step 2 | "Old Closures" | filters out closures prior to reporting month; also renaming headers | Cell A1 - enter first date of reporting month
 | Step 3 | "Future First Contacts" | filters out clients with a start date AFTER end of report month | Cell A1 - enter last date of reporting month
 | Step 4-LSC | "LSC Only" | Filters in LSC clients only | None
 | Step 5 | "Remove Text" | removes "LSC", "CM, "FLY" from Column N, Col. T, U, V rename text to be report specific | None
Spreadsheet: 78837d1279133088-how-to-convert-numeric-values-from-english-to-french-english-to-french-sample
Sheet: Sheet1

Amount 1 | Amount 2 | Amount 3 |  |  | Results should look like this
24.32 | 5000 | 5462 |  |  | 24 32 | 5 000,00 | 5 462,00 $
52.32 | 10000 | 795.63 |  |  | 52 32 | 10 000,00 | 795,63 $
60.45 | 1523.56 | 4545.45 |  |  | 60 45 | 1 523,56 | 4 545,45 $
Spreadsheet: 870057d1716562448-a-way-to-make-a-cell-with-a-formula-retrieve-hyperlink-as-well-as-the-cell-text-hyperlink-example
Sheet: Sheet2

Date In | by | Date out | by | Code | ID | Name | alternate method using =[NAME]()
2024-05-23 00:00:00 | JK | 2024-05-24 00:00:00 | JK | ABC123 | 333
2024-05-24 00:00:00 | JK | 2024-05-25 00:00:00 | JK | QDS112 | 222
Spreadsheet: 268479d1380651290-finding-total-for-individuals-by-monthly-tab-and-unit-counts-bsr-teams-2013
Sheet: Feb

Daily Locked & Funded Loans AS 01/31/2013
 | Wholesale |  |  |  | Correspondent
Account Executive | Daily Locked | Active Locked | Daily Funded | MTD Funded | Daily Locked | Active Locked | Daily Purchased | MTD Purchased
[NAME] | $388,000 (2) | $11,063,500 (37) | $843,800 (3) | $6,564,900 (24)
[NAME] | $315,000 (1) | $13,484,424 (44) | $931,000 (3) | $11,376,920 (37)
[NAME] | - | $11,881,475 (34) | $1,062,000 (3) | $8,006,200 (27)
[NAME] | $128,800 (1) | $9,038,438 (28) | $878,500 (2) | $5,939,700 (15)
[NAME] | $250,000 (1) | $17,471,148 (55) | $1,847,950 (6) | $18,682,587 (54)
[NAME] | $315,000 (1) | $13,186,350 (38) | $135,000 (1) | $8,977,250 (27)
[NAME] | $406,800 (2) | $25,347,948 (84) | - | $15,860,900 (54)
[NAME] | $1,593,000 (4) | $14,961,590 (44) | $2,049,250 (5) | $13,242,750 (38)
[NAME] | $2,808,750 (6) | $59,421,400 (172) | $2,414,450 (7) | $30,085,750 (92)
[NAME] | - | $12,053,450 (33) | $627,000 (2) | $9,109,900 (27)
Kathi Yelland | - | $860,000 (5) | - | $665,000 (2)
Kris Varia | $132,000 (1) | $8,177,100 (25) | - | $9,510,200 (29)
[NAME] | $2,507,000 (8) | $14,224,400 (50) | $660,000 (3) | $15,156,410 (45)
[NAME] | $530,000 (1) | $18,581,250 (47) | $454,000 (2) | $18,463,600 (51)
[NAME] | $264,000 (1) | $18,378,050 (56) | $265,000 (1) | $11,299,200 (35)
[NAME] | $417,000 (1) | $9,049,600 (24) | $243,750 (1) | $6,042,920 (18)
Subtotal | $10,055,350 (30) | $257,180,123 (776) | $12,411,700 (39) | $188,984,187 (575)
Daily HomeLending / Alan Locked & Funded Loans AS 01/31/2013
 | Retail
Account Executive | Daily Locked | Active Locked | Daily Funded | MTD Funded | Daily Locked | Active Locked | Daily Purchased | MTD Purchased
[NAME] | - | $2,447,000 (6) | - | $948,000 (4) | - | - | - | -
Subtotal | - | $2,447,000 (6) | - | $948,000 (4) | - | - | - | -
Daily Locked & Funded Loans AS 01/31/2013
 | Wholesale / Retail |  |  |  | Correspondent
 | Daily Locked | Active Locked | Daily Funded | MTD Funded | Daily Locked | Active Locked | Daily Purchased | MTD Purchased
Total | $10,055,350 (30) | $259,627,123 (782) | $12,411,700 (39) | $189,932,187 (579)
Spreadsheet: 438100d1451752300-employee-timesheet-calculating-hours-worked-arbeitszeit-mitarbeiter-seepf-rdli
Sheet: May

January
Date | Start Time | Break Start | Break End | End Time | Total Hours Worked | Comments
2016-01-01 00:00:00 | 08:00:00 | 12:30:00 | 13:00:00 | 17:00:00
2016-01-02 00:00:00
2016-01-03 00:00:00
2016-01-04 00:00:00 | 08:00:00 | 12:00:00 | 12:30:00 | 17:00:00
2016-01-05 00:00:00
2016-01-06 00:00:00
2016-01-07 00:00:00
2016-01-08 00:00:00
2016-01-09 00:00:00
2016-01-10 00:00:00
2016-01-11 00:00:00
2016-01-12 00:00:00
2016-01-13 00:00:00
2016-01-14 00:00:00
2016-01-15 00:00:00
2016-01-16 00:00:00
2016-01-17 00:00:00
2016-01-18 00:00:00
2016-01-19 00:00:00
2016-01-20 00:00:00
2016-01-21 00:00:00
2016-01-22 00:00:00
2016-01-23 00:00:00
2016-01-24 00:00:00
2016-01-25 00:00:00
2016-01-26 00:00:00
2016-01-27 00:00:00
2016-01-28 00:00:00
2016-01-29 00:00:00
2016-01-30 00:00:00
2016-01-31 00:00:00
Total
Spreadsheet: 153384d1335888888-automatically-move-to-a-specific-worksheet-after-typing-in-a-specific-cell-compliance-rates
Sheet: Summary

2012
 | [NAME] |  | Gas Station |  | Other |  | Restaurant |  | Supermarket |  | Total
 | Round 1 | Round 2 | Round 1 | Round 2 | Round 1 | Round 2 | Round 1 | Round 2 | Round 1 | Round 2 | Round 1 | Round 2
[NAME]
Tested
Sales
No Sales
Compliance Rate
[NAME]
Tested
Sales
No Sales
Compliance Rate
Overall Total Year to Date
 | Round 1 | Round 2 | Total
Tested
Sales
No Sales
Compliance Rate
Spreadsheet: 95438d1295024736-return-multiple-results-for-hlookup-copy-of-client-example
Sheet: Sheet1

Distro Center | ID # |  | Client #s | 340 | 341 | 344 | 345 | 346 | 347 | 348 | 349 | 350 | 351
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Count | Clients
1 | 123 |  |  | X | X | 1 | 1 | 1 | 1 | X | X | X | X |  | 4 | 344 | 345 | 346 | 347
2 | 223 |  |  | X | X | 1 | X | 1 | 1 | 1 | X | X | X |  | 4 | 344 | 346 | 347 | 348
3 | 323 |  |  | X | 1 | X | X | 1 | X | X | X | X | X |  | 2 | 341 | 346
4 | 423 |  |  | X | X | X | X | 1 | 1 | 1 | X | X | X |  | 3 | 346 | 347 | 348
5 | 523 |  |  | X | X | 1 | 1 | 1 | 1 | 1 | X | X | X |  | 5 | 344 | 345 | 346 | 347 | 348
6 | 623 |  |  | X | X | X | X | 1 | 1 | 1 | X | X | X |  | 3 | 346 | 347 | 348
7 | 723 |  |  | X | 1 | X | X | X | X | X | X | X | X |  | 1 | 341
8 | 823 |  |  | X | X | X | X | 1 | X | 1 | X | X | X |  | 2 | 346 | 348
9 | 923 |  |  | X | 1 | X | X | X | X | X | X | X | X |  | 1 | 341
10 | 124 |  |  | X | X | X | X | 1 | 1 | 1 | X | X | X |  | 3 | 346 | 347 | 348
Spreadsheet: 789654d1659274148-to-find-sum-of-continuous-ive-or-ive-numbers-as-long-as-opposite-sign-value-comes-sample-file-13
Sheet: Sheet1

 |  |  |  |  | Values |  | Expected Results |  |  |  | I used Numbers in Column E and I just to make it more clear to understand. Otherwise these number did not have any impact on my final Result
 |  |  |  | 1 | 2 |  |  | 1
 |  |  |  |  | 4 | -2 |  | 2
 |  |  |  | 2 | -2 | 16 |  | 3
 |  |  |  | 3 | 1 | -21 |  | 4
 |  |  |  |  | 5 | 1 |  | 5
 |  |  |  |  | 6 | -58 |  | 6
 |  |  |  |  | 4 | 4 |  | 7
 |  |  |  | 4 | -5 | -10 |  | 8
 |  |  |  |  | -4 | 12 |  | 9
 |  |  |  |  | -12 | -20 |  | 10
 |  |  |  | 5 | 1 | 101 |  | 11
 |  |  |  | 6 | -12
 |  |  |  |  | -45
 |  |  |  |  | -1
 |  |  |  | 7 | 1
 |  |  |  |  | 2
 |  |  |  |  | 1
 |  |  |  | 8 | -10
 |  |  |  | 9 | 12
 |  |  |  | 10 | -20
 |  |  |  | 11 | 1
 |  |  |  |  | 50
 |  |  |  |  | 50
Spreadsheet: 858834d1707363312-help-calculate-sla-for-between-two-time-difference-sample-sla-result
Sheet: Sheet1

Service Type | Created Time | Resolved | SLA Calculation |  |  | Weekday
Issue | 2024-11-02 08:12:00 | 2024-12-02 14:56:00
Service Request | 2024-01-01 14:47:00 | 2024-01-02 08:58:00
 | 2024-02-12 08:12:00 | 2024-02-13 14:56:00
 |  |  |  |  |  | 1st day
Spreadsheet: 127166d1320191908-inventory-and-distribution-sheet-book1-version-1-
Sheet: Sheet2

Item | Quantity in stock | Initial count |  | member | Issuers |  |  |  |  |  |  |  |  |  |  | Control #'s
Item 5 | 4 | 4 |  | member 1 | Control 1 |  |  |  |  |  |  |  |  |  |  | 1
Item 2 | 10 | 10 |  | member 2 | Control 2 |  |  |  |  |  |  |  |  |  |  | 2
Item 4 | 15 | 15 |  | member 3 |  |  |  |  |  |  |  |  |  |  |  | 3
Item 1 | 50 | 50 |  | member 4 |  |  |  |  |  |  |  |  |  |  |  | 4
Item 3 | 123 | 123 |  | member 5
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: Conoco

 | Maljamar |  | Zia
Day | Measured | Scheduled | Measured | Scheduled
1 | 40803 | 40714 | 37694 | 35000
2 | 41335 | 40714 | 42690 | 35000
3 | 39966 | 40714 | 41584 | 40000
4 | 41167 | 40714 | 39857 | 40000
5 | 44360 | 43714 | 39563 | 40000
6 | 41924 | 43713 | 36834 | 39999
7 | 41447 | 43714 | 35036 | 38000
8 | 36290 | 40000 | 32619 | 34000
9 | 39937 | 38777 | 32705 | 31047
10 | 39339 | 38777 | 31138 | 31047
11 | 39932 | 43714 | 32600 | 35000
12 | 44225 | 42710 | 22986 | 32997
13 | 48063 | 44000 | 26734 | 23000
14 | 47229 | 50115 | 31012 | 33532
15 | 40048 | 37619 | 25456 | 29065
16 | 40576 | 50051 | 29835 | 35000
17 | 40047 | 41227 | 31203 | 33917
18 | 39329 | 39000 | 30953 | 32000
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  | 2444005.89 |  | -2072427.18
2001-06-18 00:00:00
Spreadsheet: 767304d1644401956-list-of-people-that-i-want-to-calculate-how-many-days-they-have-left-until-end-date-enddate-aligw
Sheet: English

September |  |  |  |  | Calculation date
 |  | Start date | End date |  | 2021-09-30 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00 |  |  |  |  |  |  | The maximum is 30 days
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 |  |  |  |  |  | If the end date has arrived then it should be calculated and if it is> but Calculation day then max 30
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00 |  |  |  |  |  | Sometimes there is a End date that is more than a month in advance, but the maximum in that case will be 30, exept if it is less then month in atvansed
 | Sigrid | 2020-03-18 00:00:00 |  |  |  |  |  |  | The formula must be such that it works on all parties and also that if the names / dates are changed, the formula works on them
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00
 |  |  |  |  |  |  |  |  | Red is wrong and is not working
Oktobere
 |  | Upphafsdagur | Lokadagur |  | 2021-10-31 00:00:00 | The correct answer would be |  |  | If the End date has passed, an error occurs
 | Anne | 2021-01-01 00:00:00
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00
 | Sigrid | 2020-03-18 00:00:00
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00
November
 |  | Upphafsdagur | Lokadagur |  | 2021-11-30 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00
 | Sigrid | 2020-03-18 00:00:00
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00
Spreadsheet: 705317d1606021498-find-duplicate-rows-across-several-columns-with-conditions-and-high-light-them-testfile-1-
Sheet: Sheet1

date_received | Facility_Name | Address1 | CMS | FMID | Group | State | Staff | enrolled
2020-11-02 00:00:00 | Sunrise | 4352 regan rd | 12 | 3425 | ALF | IL | 20 | 1
2020-10-29 00:00:00 | Sunrise | 4352 regan road | 12 | 3425 | Assisted Living Facility | IL | 23 | 1
2020-11-05 00:00:00 | Packed living | 2342 Mayo rd |  |  | ALF | CA | 25 | 1
2020-11-02 00:00:00 | Packed living | 2342 Mayo rd |  |  | Other | CA | 25 | 1
2020-11-02 00:00:00 | Freedom living | 54 Jordon court | 156 | 123 | SNF | OH | 12 | 1
2020-11-02 00:00:00 | Freedom living | 54 Jordon court | 212 | 123 | SNF | OH | 12 | 1