tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 689580d1596529705-is-countif-the-correct-function-to-match-a-substring-in-a-range-to-a-selected-value-excelforum-1-
Sheet: Offer Details

 | [NAME] | CID | Offer # | ItemCode | Model | Motor | Description | Qty | Unit Price | Total | OC # | TI #
 |  | 685 - N004 - Novellic Inds | 0685-2021-CF-034-A | TEST ITEM CODE | 311 R4A | 2.2 kW/2P, 90L | Direct Driven Centrifugal 930 RPM | 1 | 58810 |  | 0685-2021-CF-014-A, 0685-2021-CF-033-A, 0685-2021-CF-034-A | FIE/20-21/033
 |  | 685 - N004 - Novellic Inds | 0685-2021-CF-034-A | TEST ITEM CODE2 | 311 R4A | 2.2 kW/2P, 90L | Alongwith Flame Proof Motor | 1 | 20751 |  | 0685-2021-CF-014-A, 0685-2021-CF-033-A, 0685-2021-CF-034-A | FIE/20-21/033
 |  | 685 - N004 - Novellic Inds | 0685-2021-CF-034-A | Accessories Included | 311 R4A | 2.2 kW/2P, 90L | Base frame, [NAME] arrangement | 1 | 0 |  | 0685-2021-CF-014-A, 0685-2021-CF-033-A, 0685-2021-CF-034-A | FIE/20-21/033
 |  | 685 - N004 - Novellic Inds | 0685-2021-SP-075-A | 45.00.7A | 561 N4A |  | Spares | 1 | 51100 |  | 0685-2021-CF-034-A | FIE/20-21/045
 |  | 685 - N004 - Novellic Inds | 0685-2021-SP-075-A | 45.00.7A | 561 N4A |  | Inlet  Damper | 1 | 11845 |  | 0685-2021-CF-034-A | FIE/20-21/045
 |  | 685 - N004 - Novellic Inds | 0685-2021-SP-075-A | 45.00.7A | 561 N4A |  | Flexible Connection | 1 | 6989 |  | 0685-2021-CF-034-A | FIE/20-21/045
Spreadsheet: 777117d1650179685-count-no-of-cases-based-on-a-given-date-range-excelforum_countnocase-2
Sheet: Defect

 | S/No | Car | Defect | WO/JR No. | Since | Status | Clear | >3 | No of Case | >7
 | 1 | 28 |  | NA | 2021-12-01 00:00:00 | Pending Investigation | 2021-12-10 00:00:00
 | 2 | 16 |  | NA | 2021-12-08 00:00:00 | Pending Investigation
 |  | 5 |  |  | 06-12-21
Spreadsheet: 868512d1715238388-very-complicated-sum-function-testing-1-
Sheet: Sheet1

EVENT 1 |  | Total of | AR | APC |  | STATE 1 |  | STATE 2 |  | STATE 3 |  | STATE 4 |  | STATE 5 |  | STATE 6 |  | AP1 |  | AP2 |  | AP3 |  | AP4 |  | AR1 |  | AR2 |  | AR3 |  | AR4 |  | AR5 |  | AR6 |  | AR7 |  | AR8 |  | AR9 |  | AR10 |  | AR11 |  | AR12 |  | AR13 |  | AR14
 |  | best six | current |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | River City Classic |  | Mooloolabah
 |  | AR points | RANK | Oct |  | April |  | March |  | March |  | April |  | May |  | June |  | Oct |  | May |  | Sept |  | Nov |  | June |  | July |  | June |  |  |  | Sept |  | Sept |  | April |  | May
 | Weighting                  No of players/teams |  |  | 1 |  | 0.5 | NO | 0.5 | 8 | 0.5 | 5 | 0.5 |  | 0.5 |  | 0.5 |  | 0.75 |  | 0.75 |  | 0.75 |  | 0.75 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25
Last Name | Full Name |  |  | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts
 |  |  |  |  |  | NO EVENT |  |  |  | SmallEvent |  | SmallEvent
NAME | FULL NAME |  |  |  | 100 |  | 300 |  | 400 |  | 200 | 1 | 250 |  | 300 |  | 100 | 1 | 750 |  | 500 |  | 400 |  |  |  | 250 |  | 100 |  | 300
NAME | FULL NAME |  |  |  | 300 |  | 100 |  | 200 |  | 100 | 1 | 300 |  |  |  |  | 2 | 300 |  | 300 |  | 300 |  |  |  | 100 |  | 100 |  | 100
NAME | FULL NAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 750
NAME | FULL NAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 600
NAME | FULL NAME |  |  |  |  |  |  | 1 | 500
NAME | FULL NAME |  |  |  |  |  |  | 1 | 500
Spreadsheet: eafff6a2-f835-4e63-9646-7d998fccba33
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FUNB | Test | FUNB | Fungal Ident Panel B ([NAME] Only) | Fungal Ident Panel B |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87107 |  |  |  |  | Rochester
FUNB | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 809909d1671432098-summarise-multiple-excel-worksheets-into-one-sheet-book1
Sheet: Data Simplifed

ID | Surname | First Name | q 1 | q 2 | q 3 | q 4
2931 | Wick | [NAME] | 130 | 91 | 295 | 288
1591 | [NAME] | [NAME] | 220 | 55 | 165 | 87
1289 | [NAME] | [NAME] | 229 | 271 | 140 | 205
2147 | Wo | [NAME] | 114 | 225 | 79 | 82
Spreadsheet: 54971d1255013445-email-filtered-data-from-lotus-notes-ci-card-database-2009-new
Sheet: Data

People | 135 Product | Support_Groups | MET | Business_Team | Implementation | Facilities | Human_Resources | Line_Team | Logistics | Maintenance | Quality | Supervision | Supplier_Development | Health_and_Safety
Quality | 160 Product | MET | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Velocity | 190 Product | Business_Team | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Cost | Building 1 - Office | Implementation | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Building 1 - Shop Floor | Facilities
 | Building 2 - Office | Health_and_Safety
 | Building 2 - Shop Floor | Human_Resources
 | Logistics | Line_Team
 | PowerPact Assembly | Logistics
 | PowerPact Manufacturing | Maintenance
 | SWL | Quality
 |  | Supervision
 |  | Supplier_Development
 |  | Facilities | 5 S Audit | Black Belt Project | Project Title:
 |  | Human Resources | Accident | Card rejected | No data required
 |  | Line Team | BBS Audit | Long-term Project | Project Title:
 |  | Logistics | Black Belt Project | [NAME] | Form Number:
 |  | Maintenance | Green Belt Project | Process Change Request Form | PCR No
 |  | Manufacturing Engineering | Near Miss | Purchase Order Number | PO Number:
 |  | Quality | Observation | Work Completed | No data required
 |  | Supervision | Other
 |  | Supplier Development | PCCP
 |  |  | PFMEA
 |  |  | PID
 |  |  | Process Change Request
 |  |  | RIW
 |  |  | Routing Change
 |  |  | Safety Walk
 |  |  | [NAME]
 |  |  | Stop to Fix
 |  |  | VST
 |  |  | Waste Walk
Spreadsheet: 20a9bd10-2793-4d99-b97a-0832e0a322e4
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | State Senate District 3 - Republican
2012-09-11 00:00:00 | Bradley, r | Ballard, d | [NAME]
Albany | 66
[NAME] | 298 |  | 2
[NAME] | 103 | 1
Chatham | 39
Conway | 688 |  | 2
Eaton | 70
[NAME] | 155
Freedom | 240 |  | 2
Hale's Location | 81
Hart's Location | 3
[NAME] | 122
[NAME] | 260 |  | 3
[NAME] | 143 |  | 1
Milton | 287 | 3 | 3
Moultonborough | 714 |  | 6
Ossipee | 475 | 1 | 2
Sandwich | 184 |  | 1
Tamworth | 254 |  | 1
Tuftonboro | 396 |  | 3
Wakefield | 478 | 6 | 4
Waterville Valley | 38
Wolfeboro | 930
Totals | 6024 | 11 | 30
 | State Senate District 4 - Republican
 | Woods, r | [NAME], d | [NAME]
[NAME] | 595 |  | 12
[NAME] | 157 | 1 | 2
[NAME] | 163
[NAME] | 334 | 2 | 1
[NAME] | 275 | 3 | 3
[NAME] | 212 | 1
[NAME] 6 | 233 | 1 | 2
[NAME] | 162 | 3
[NAME] | 115 |  | 1
[NAME] | 80 |  | 2
[NAME] 3 | 96
[NAME] | 89 |  | 3
[NAME] 5 | 40 |  | 2
Totals | 2551 | 11 | 28
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 6

 | February 21 | February 28 | March 7 | March 14 | March 21
Total Interest Rate* | 6965767 | 8427463 | 5650977 | 7697122 | 6825255
SDs and MSPs** | 3600162 | 4646668 | 3481619 | 4934563 | 3975011
Other | 3365605 | 3780795 | 2169358 | 2762558 | 2850244
Total Cross-Currency | 149250 | 173230 | 111790 | 159346 | 227346
SDs and MSPs | 101,881 | 115,122 | 82,186 | 119,729 | 183,638
Other | 47369 | 58109 | 29604 | 39617 | 43708
Total Credit | 467688 | 423255 | 487086 | 525202 | 1102439
SDs and MSPs | 264859 | 204606 | 260594 | 288759 | 627412
Other | 202829 | 218649 | 226492 | 236444 | 475027
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 7582705 | 9023948 | 6249853 | 8381670 | 8155040
Weekly total, swap dollar volumes by asset class and participant type (value of all trades in millions of USD), all products and tenors, cleared and uncleared. For cleared swaps, the notional value for each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, the notional value of the swap is attributed to both swap counterparties. The notional values of all price-forming trade events, including new trades, terminations, amendments, and novations, are included in dollar volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Dollar Volume by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 877810d1724745980-after-sorting-with-two-yes-conditions-find-difference-writingformulas-greater-than-to-forum-365-aligw
Sheet: greaterthan

 |  |  |  | Date | High | Low |  |  | H>PDH | L>PDL |  | Pts>PDH | Pts >PDL
 |  |  |  | 2022-08-25 00:00:00 | 4202.75 | 4143
 |  |  |  | 2022-08-26 00:00:00 | 4217.25 | 4042.75
 |  |  |  | 2022-08-29 00:00:00 | 4064 | 4006.75
 |  |  |  | 2022-08-30 00:00:00 | 4072.75 | 3964.5
 |  |  |  | 2022-08-31 00:00:00 | 4018.25 | 3953
 |  |  |  | 2022-09-01 00:00:00 | 3971.25 | 3903.5
 |  |  |  | 2022-09-02 00:00:00 | 4019.25 | 3906 |  |  |  |  |  |  | 2.5
 |  |  |  | 2022-09-06 00:00:00 | 3963.25 | 3886.75
 |  |  |  | 2022-09-07 00:00:00 | 3988.75 | 3883.5
 |  |  |  | 2022-09-08 00:00:00 | 4028 | 3959.5 |  |  |  |  |  |  | 76
 |  |  |  | 2022-09-09 00:00:00 | 4095 | 4022.5 |  |  |  |  |  |  | 63
 |  |  |  | 2022-09-12 00:00:00 | 4137.75 | 4080.25 |  |  |  |  |  |  | 57.75
 |  |  |  | 2022-09-13 00:00:00 | 4175 | 3938.5
 |  |  |  | 2022-09-14 00:00:00 | 3981.25 | 3929
 |  |  |  | 2022-09-15 00:00:00 | 3977.5 | 3905
 |  |  |  | 2022-09-16 00:00:00 | 3905 | 3853
 |  |  |  | 2022-09-19 00:00:00 | 3927 | 3846.25
 |  |  |  | 2022-09-20 00:00:00 | 3936.25 | 3843.25
 |  |  |  | 2022-09-21 00:00:00 | 3925.25 | 3792
 |  |  |  | 2022-09-22 00:00:00 | 3833 | 3763.5
 |  |  |  | 2022-09-23 00:00:00 | 3783.25 | 3660.25
 |  |  |  | 2022-09-26 00:00:00 | 3730.5 | 3657.5
 |  |  |  | 2022-09-27 00:00:00 | 3733 | 3635.25
 |  |  |  | 2022-09-28 00:00:00 | 3751.25 | 3613
 |  |  |  | 2022-09-29 00:00:00 | 3736 | 3622
 |  |  |  | 2022-09-30 00:00:00 | 3693.75 | 3595.25
 |  |  |  | 2022-10-03 00:00:00 | 3711.75 | 3571.75
 |  |  |  | 2022-10-04 00:00:00 | 3808.75 | 3686.25 |  |  |  |  |  |  | 114.5
 |  |  |  | 2022-10-05 00:00:00 | 3820 | 3734 |  |  |  |  |  |  | 47.75
 |  |  |  | 2022-10-06 00:00:00 | 3819.5 | 3750
 |  |  |  | 2022-10-07 00:00:00 | 3770.5 | 3632.5
 |  |  |  | 2022-10-10 00:00:00 | 3667.5 | 3600
 |  |  |  | 2022-10-11 00:00:00 | 3653.25 | 3579
Spreadsheet: 850723d1701110225-alternative-to-groupby-alternative-to-groupby
Sheet: Sheet1

 | Dynamic Array Output |  |  |  | Desired Result
 |  | A | 10 |  | North | A | 24
 | South | A | 11 |  | South | A | 26
 | East | A | 12 |  | East | A | 28
 | West | A | 13 |  | West | A | 33
 | North | A | 14 |  | North | B | 52
 | South | A | 15 |  | South | B | 64
 | East | A | 16 |  | East | B | 71
 | West | A | 20 |  | West | B | 78
 | North | B | 22
 | South | B | 24
 | East | B | 26
 | West | B | 28
 | North | B | 30
 | South | B | 40
 | East | B | 45
 | West | B | 50
Spreadsheet: 686198d1594413485-how-do-i-apply-index-match-function-with-multiple-criteria-that-needs-to-be-summed-book3
Sheet: Sheet1

Account | Description | January | February | March | April | May | June
8510 | Local Transport
8520 | Air Travel
8530 | Hotel & Lodging
8540 | Meals & Incidentals
9080 | Office Supplies
9120 | Meetings & Trainings
Month | Date | Account | US$
 | 2020-01-31 00:00:00 | 8540 | 21.68
 | 2020-01-31 00:00:00 | 8510 | 17.25
 | 2020-01-31 00:00:00 | 8510 | 14.27
 | 2020-01-31 00:00:00 | 8510 | 12.81
 | 2020-01-31 00:00:00 | 8540 | 7.42
 | 1930-02-01 00:00:00 | 8510 | 20.66
 | 1930-02-01 00:00:00 | 8540 | 12.59
 | 2020-02-14 00:00:00 | 8510 | 4.13
 | 2020-02-15 00:00:00 | 8540 | 2.88
 | 2020-02-27 00:00:00 | 8530 | 1507.44
 | 2020-03-05 00:00:00 | 9080 | 113.97
 | 2020-03-06 00:00:00 | 9080 | -96.09
 | 2020-03-07 00:00:00 | 9080 | 77.16
 | 2020-03-08 00:00:00 | 9120 | 1560
 | 2020-03-05 00:00:00 | 8520 | 1366.95
 | 2020-04-04 00:00:00 | 8520 | 473.8
 | 2020-04-05 00:00:00 | 8520 | 205
 | 2020-04-11 00:00:00 | 8520 | 203
 | 2020-04-25 00:00:00 | 8520 | 171
 | 2020-05-25 00:00:00 | 8520 | 132
 | 2020-05-25 00:00:00 | 9080 | 944.64
 | 2020-05-25 00:00:00 | 9080 | 92.99
 | 2020-06-02 00:00:00 | 9080 | 61.86
 | 2020-06-03 00:00:00 | 9080 | 22.67
 | 2020-06-03 00:00:00 | 9080 | 5.33
Spreadsheet: 853054d1703005642-sumifs-with-date-and-1-other-criteria-scheduling-kansas-press-calc
Sheet: Job Estimate GGPM 20748

T1 |  | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 | 20748 |  | GGPM | 44 | 37 | 27 | PAP-SO-0016 - 48X96 COROPLAST | 1 | 4 Pass
 | 20748 |  | GGPM | 53 | 26 | 36 | ART-4392 - ULTRA CLING WHITE 54X300 | 1 | 4 Pass
 | 20748 |  | GGPM | 1 | 22 | 20 | ART-4392 - ULTRA CLING WHITE 54X300 | 1 | 4 Pass
 | 20748 |  | GGPM | 72 | 5 | 10 | PAP-SO-0056 - 48X96 40PT STYRENE | 1 | 4 Pass
Spreadsheet: 124953d1318767417-extract-data-to-tab-based-on-value-advanced-filter-with-event-macro
Sheet: Countsheet

Name | Size | Type | Supplier | Cases |  | Name | Size | Type | Supplier | Cases | << [NAME] |  |  | Supplier
Boylan Root Beer | 355ml | [NAME] | American Soda Company | 1 |  |  |  |  | American Soda Company
Boylan Creme | 355ml | [NAME] | JMJ | 2
Boylan Orange Creme | 355ml | [NAME] | Fucor | 12 |  | Name | Size | Type | Supplier | Cases | <<Result |  |  | Supplier
[NAME] | 355ml | [NAME] | AJMD | 3 |  | Boylan Root Beer | 355ml | [NAME] | American Soda Company | 1 |  |  |  | American Soda Company | <<List of all Suppliers Unique Filter
Boylan Cane Cola | 355ml | [NAME] | AJMD | 4 |  | Boylan Grape | 355ml | [NAME] | American Soda Company | 5 |  |  |  | JMJ
Boylan Grape | 355ml | [NAME] | American Soda Company | 5 |  | Tizer | 330ml | Can | American Soda Company | 5 |  |  |  | Fucor
Boylan Ginger Ale | 355ml | [NAME] | Fucor | 4 |  | Fresh-up Crisp Apple | 355ml | Can | American Soda Company | 1 |  |  |  | AJMD
Boylan Black Cherry | 355ml | [NAME] | JMJ | 5 |  | L&P | 1.5L | Bottle | American Soda Company | 15
Boylan Diet Creme | 355ml | [NAME] | AJMD | 6 |  | Hanks Vanilla Cream | 355ml | Bottle | American Soda Company | 11.6
Boylan Diet Cane Cola | 355ml | [NAME] | JMJ | 7 |  | Cafe Earth Blood Orange | 330ml | Bottle | American Soda Company | 21
[NAME] | 330ml | Can | Fucor | 8 |  | Appletiser | 750ml | Bottle | American Soda Company | 3.4 |  |  | Change the Dropdown in J2 and it triggers a macro to
Orangina | 330ml | Can | Fucor | 3 |  |  |  |  |  |  |  |  | [NAME] your data.
Tizer | 330ml | Can | American Soda Company | 5 |  |  |  |  |  |  |  |  | I don't believe you need separate worksheets for each [NAME].
Fresh-up Apple Mango | 355ml | Can | AJMD | 43
Fresh-up Apple Orange | 355ml | Can | JMJ | 5
Fresh-up Original Apple | 355ml | Can | JMJ | 54
Fresh-up Crisp Apple | 355ml | Can | American Soda Company | 1
Fresh-up [NAME] | 355ml | Can | Fucor | 12
L&P | 1.5L | Bottle | American Soda Company | 15
Hanks Root Beer | 355ml | Bottle | JMJ | 32
Hanks Diet Root Beer | 355ml | Bottle | AJMD | 21
Hanks Orange Cream | 355ml | Bottle | Fucor | 32
Hanks Vanilla Cream | 355ml | Bottle | American Soda Company | 11.6
Hanks Birch Beer | 355ml | Bottle | JMJ | 3.4
Hanks [NAME] Cherry | 355ml | Bottle | JMJ | 2
Cafe Earth Pink Grapefruit | 330ml | Bottle | JMJ | 1
Cafe Earth Cranberry | 330ml | Bottle | Fucor | 2.4
Cafe Earth Natural Mineral Water | 330ml | Bottle | Fucor | 4.5
Cafe Earth Blood Orange | 330ml | Bottle | American Soda Company | 21
Cafe Earth Jamaican Lime | 330ml | Bottle | JMJ | 32
Cafe Earth Wild Lemon | 330ml | Bottle | Fucor | 11.6
Appletiser | 750ml | Bottle | American Soda Company | 3.4
Grapetiser | 750ml | Bottle | Fucor | 2
White Grapetiser | 750ml | Bottle | AJMD | 1
[NAME] | 330ml | [NAME] | Fucor | 2.4
[NAME] | 330ml | [NAME] | AJMD | 4.5
Spreadsheet: 51270d1250798873-excel-2007-if-and-true-false-and-two-criteria-ifandhelp
Sheet: Data1

[NAME] | 2000s | True
[NAME] | 1990s | False
[NAME] | 1980s | False
[NAME] | 1970s | False |  |  |  | Looking at the "TRUE" conditions, I'd like to highlight the appropriate data on the second sheet.
[NAME] | 1960s | False
[NAME] | 2000s | False
[NAME] | 1990s | False
[NAME] | 1980s | False
[NAME] | 1970s | False
[NAME] | 1960s | False
[NAME] | 2000s | False
[NAME] | 1990s | False
[NAME] | 1980s | False
[NAME] | 1970s | False
[NAME] | 1960s | False
[NAME] | 2000s | False
[NAME] | 1990s | False
[NAME] | 1980s | True
[NAME] | 1970s | True
[NAME] | 1960s | False
Spreadsheet: 739104d1625511368-macro-to-compare-references-and-values-and-extract-items-not-matching-to-a-seperate-sheet-macro-to-compare-ref-numbers-and-extract-items-that-do-not-match
Sheet: Statement

[NAME]  From | Date Processed | Reference | Column1 | Type | Reference  Type | Balance
9837 | 03-MAY-2021 | 9285 |  | IN | Invoice | 411.21
9837 | 03-MAY-2021 | 9290 |  | IN | Invoice | 198.09
9837 | 03-MAY-2021 | 9305 |  | IN | Invoice | 38.89
9837 | 04-MAY-2021 | 9320 |  | IN | Invoice | 365.44
9837 | 05-MAY-2021 | 9321 |  | IN | Invoice | 1046.95
9837 | 05-MAY-2021 | 9327 |  | IN | Invoice | 910.47
9837 | 06-MAY-2021 | 9334 |  | IN | Invoice | 150.53
9837 | 06-MAY-2021 | 9338 |  | IN | Invoice | 1225.6
Spreadsheet: 89768d1289504832-create-wind-rose-from-the-data-in-excel-compass_rose
Sheet: Sheet1

 | N | NE | E | SE | S | SW | W | NW
0-5 | 2 | 5 | 7 | 9 | 3 | 12 | 5 | 6
6-10 | 3 | 9 | 6 | 5 | 8 | 11 | 10 | 4
11-15 | 2 | 5 | 7 | 9 | 3 | 12 | 5 | 6
16-20 | 3 | 9 | 6 | 5 | 8 | 11 | 10 | 4
Cumulative
 | N | NE | E | SE | S | SW | W | NW
0-5 | 10 | 28 | 26 | 28 | 22 | 46 | 30 | 20
6-10 | 7 | 19 | 20 | 23 | 14 | 35 | 20 | 16
11-15 | 5 | 14 | 13 | 14 | 11 | 23 | 15 | 10
16-20 | 2 | 5 | 7 | 9 | 3 | 12 | 5 | 6
Spreadsheet: 538908d1505876134-adding-row-content-from-sheet-to-sheet-example-didierkassas-
Sheet: Final

 |  |  |  |  | OPERATION MEETING AGENDA
 |  |  |  |  | 2017-09-19 00:00:00
 | Meeting Information |  |  |  |  |  |  |  |  |  | [NAME]
 | Date | Location |  | Session # | Start |  | End |  | Duration | Organizer
 | 2017-09-06 00:00:00 | Speech Room |  | 8 | 07:30:00 |  | 20:00:00 |  | 12:30:00
 | 1 | Operation Department |  |  |  |  |  | Date from | Date Due | Status | Notes
 | 1 | Testing of AV |  |  |  |  |  | 0 | 0 | Pending Approval
 | 2 | Creation of layout |  |  |  |  |  | 0 | 0 | In Progres
 | 2 | Accreditation |  |  |  |  |  | Date from | Date Due | Status | Notes
 | 1 | Creation of System |  |  |  |  |  | 0 | 0 | Pending Approval
 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0
 | 3 | Broadcast |  |  |  |  |  | Date from | Date Due | Status | Notes
 | 4 | CAD Design |  |  |  |  |  | Date from | Date Due | Status | Notes
 | 1 | Creation of floorplan |  |  |  |  |  |  |  | Pending Approval
 | 2 | sending files |  |  |  |  |  |  |  | Cancelled
 | 3 | receiving of files |  |  |  |  |  |  |  | Declined
 | 5 | IT |  |  |  |  |  | Date from | Date Due | Status | Notes
 | 6 | Media Operations |  |  |  |  |  | Date from | Date Due | Status | Notes
 | 7 | Security |  |  |  |  |  | Date from | Date Due | Status | Notes
 | 8 | Technical |  |  |  |  |  | Date from | Date Due | Status | Notes
 | 9 | Transportation |  |  |  |  |  | Date from | Date Due | Status | Notes
 | 10 | Voulnteers |  |  |  |  |  | Date from | Date Due | Status | Notes
 | 11 | HSE |  |  |  |  |  | Date from | Date Due | Status | Notes
Spreadsheet: 463105d1464294644-pulling-matching-data-from-different-sheets-vlookup-test-volume-report
Sheet: Jan15

Customer Name | Item | 01/15
AAA SERVICES | Wrench 2 | 72
BBB COMPANY | Wrench 2 | 105
CCC CORP. | Wrench 2 | 792
DEEZ LLC | Wrench 2 | 144
EARLY CO | Wrench 2 | 36
FITZ INC | Wrench 2 | 72
MIGGY LTD | Wrench 2 | 360
OPUS INC | Wrench 2 | 36
QUARTZ LLC | Wrench 2 | 90
RYTZO CO | Wrench 2 | 108
SALS LTD | Wrench 2 | 72
ZENITH CO | Wrench 2 | 108
Spreadsheet: 801325d1666173469-formula-to-show-categories-with-highest-ratings-formula-needed_rev-1
Sheet: Sheet1

Category | [NAME] |  |  |  |  | Sunset |  |  |  |  | Moonlight |  |  |  |  | Dawn |  |  |  |  | Night |  |  |  |  | Day |  |  |  |  | Category with highest rating
Subject | Other data | Other data | Other data | Other data | Rating | Other data | Other data | Other data | Other data | Rating | Other data | Other data | Other data | Other data | Rating | Other data | Other data | Other data | Other data | Rating | Other data | Other data | Other data | Other data | Rating | Other data | Other data | Other data | Other data | Rating
Data | xxx | xxx | xxx | xxx | 5 | xxx | xxx | xxx | xxx | 5 | xxx | xxx | xxx | xxx | 4 | xxx | xxx | xxx | xxx | 3 | xxx | xxx | xxx | xxx | 4 | xxx | xxx | xxx | xxx | 5 | Dusk, Sunset, Day |  | Please insert formula in cell H2
 | Moonlight | Dawn | Night | Day
 | 4 | 3 | 4 | 5
Spreadsheet: 858834d1707363312-help-calculate-sla-for-between-two-time-difference-sample-sla-result
Sheet: joseph

Service Type | Created Time | Resolved | SLA Calculation
Issue
Service Request
Service Request
Service Request
Service Request
Service Request
Service Request
Service Request
Service Request
Service Request
Service Request
Service Request
Service Request
Service Request
Service Request
 |  |  |  |  | Excl 1st & last days |  |  | 1st day |  |  |  |  |  |  | Last day |  |  |  |  |  |  | All Days |  | Final Formula
 |  |  |  |  | # days | Total time |  | Sat or Sun | Holiday | Sat, Sun or Holiday | Time to lunch | Time to end work | Total time |  | Sat or Sun | Holiday | Sat, Sun or Holiday | Time work to lunch break | Time work to end work | Total time |  | Total time |  | Combined formula | Using LET
 | Working hours: 08:00 AM to 17:00 PM
 | - Exclude for Lunch time: 12.00PM to 13.00PM
 | - Exclude Weekends.
 | - Exclude Public holiday (Holiday list)
 | Help - Calculate SLA For Between Two Time Difference
 | https://www.msn.com/en-my/news/national/sarawak-report-editor-embarrassed-for-malaysia-after-jail-sentence/ar-BB1hV00m?ocid=msedgdhp&pc=U531&cvid=415901438957437785eecc729ab7f61d&ei=10