tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 132573d1323821321-pdf-text-to-excel-spreadsheet-travelleisure
Sheet: Page_4

 |  |  |  | Media Outlet Results
Outlet Name | Outlet City | Outlet State | Outlet Type  Outlet Website |  |  | Outlet E-mail |  | Outlet Phone Number Outlet Circulation Keyword Outlet Source  AudienceRelevance
Lodging | Yardley | PA | [NAME] |  | http://www.l | editor@lodg |  | (215) 321-9662 | 40,050 | 20 | S
 |  |  | zine, |  | odgingmaga | ingmagazin
 |  |  | trade/ |  | zine.com/ | e.com
 |  |  | indust
 |  |  | ry
Travel Weekly | Secaucus | NJ | [NAME] |  | http://www.tr | TWeditorial |  | (201) 902-2000 | 37,695 | 65 | S
 |  |  | zine, |  | avelweekly. | @ntmllc.co
 |  |  | trade/ |  | com | m
 |  |  | indust
 |  |  | ry
Meetings Focus | San Francisco | CA | [NAME] |  | [NAME]. | tyler.davids |  | (415) 788-2005 | 35,048 | 38 | S
West |  |  | zine, |  | meetingsfoc | on@meetin
 |  |  | trade/ |  | us.com/ | gsfocus.co
 |  |  | indust |  |  | m
 |  |  | ry
California Tour & | Grass Valley | CA | [NAME] |  | http://www.c | editor@calif |  | (530) 273-5600 | 34,098 | 61 | S
Travel |  |  | zine, |  | aliforniatour | orniatouran
 |  |  | consu |  | andtravel.co | dtravel.com
 |  |  | [NAME] |  | m
Hospitality | Roswell | GA | [NAME] |  | http://www.h | info@hospit |  | (678) 802-5300 | 32,680 | 43 | S
Upgrade: The |  |  | zine, |  | ospitalityup | alityupgrade
Technology |  |  | trade/ |  | grade.com/ | .com
Source |  |  | indust
 |  |  | ry
Vacation Agent | Westampton | NJ | [NAME] |  | http://www.v | editorial@p |  | (856) 727-0035 | 31,399 | 52 | S
 |  |  | zine, |  | acationagen | mgemail.co
 |  |  | trade/ |  | tmagazine.c | m
 |  |  | indust |  | om
 |  |  | ry
Hospitality | New York | NY | [NAME] |  | http://www.h | nhd@omed |  | (646) 654-4500 | 30,143 | 30 | S
Design |  |  | zine, |  | dmag.com | a.com
 |  |  | trade/
 |  |  | indust
 |  |  | ry
Page: 4 |  |  |  |  |  |  |  |  |  |  | 12/13/2011
Spreadsheet: eric_saibi__9734__011102R
Sheet: Northport 04

Owner Name |  | KeySpan Energy Co.
Station Name |  | Northport Power Station
Unit Name |  | Northport 04
NERC Region |  | NPCC
State |  | NY
Fuel Type |  | Fuel Oil/ Nat. Gas
Capacity |  | 387 MW
Start Date |  | 2002-01-03 00:00:00
End Date |  | 2002-01-23 00:00:00
Prv. Start Date |  | 2002-10-05 00:00:00
Prv. End Date |  | 2002-10-18 00:00:00
Comments |  | Preventative Maintenance.
SIC |  | 4911
Plant ID |  | 1512112
Unit ID |  | 1004568
Outage ID |  | 16906
Spreadsheet: 1f1b1ce4-f60b-448a-a481-66d9dff26d29
Sheet: Compendex(EI)

Compendex (Engineering Index)
2004-2005
Metric | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | Total | 2004-2005 Price | Price per search
TOTAL
Sessions | 167 | 104 | 128 | 347 | 157 | 102 | 87 | 138 | 163 | 138 | 103 | 78
Searches | 543 | 229 | 309 | 804 | 492 | 332 | 247 | 344 | 415 | 579 | 338 | 273 |  | 12800
[NAME] | 5 | 3 | 30 | 14 | 4 | 6 | N/A | N/A | N/A | N/A | N/A | N/A
Spreadsheet: 792530d1660938331-xirr-calculations-goodboy
Sheet: Blad1

year | balance | interest | payments | cashflows |  | yearly | 0.105
0 | -1000000 |  |  |  |  | 6 months
 |  |  |  |  |  |  | Hi,
 |  |  |  |  |  |  | I have the following data
 |  |  |  |  |  |  | ? Interest Rate: 10.50% (XIRR)
 |  |  |  |  |  |  | ? Maturity tenure: ∼24 months
 |  |  |  |  |  |  | ? Principal repayment: 1/4th of the principal is repaid every 6 months
 |  |  |  |  |  |  | ? Interest payment: Every 6 months.
 |  |  |  |  |  |  | What I want to know is how the calculations will work in excel If I invest Rs. 1,00,000.
 |  |  |  |  |  |  | Any help would be highly appreciated.
 |  |  |  |  |  |  | Thanks in advance
Spreadsheet: 70041d1270702089-pulling-info-out-of-an-old-layout-oct-08-example
Sheet: 10-31-08 1st

Daily Problem Report |  |  |  |  |  | 1st shift |  | Date |  | 2008-10-31 00:00:00
 |  | Daily cases |  | Daily hours |  | Daily Avg Per Month |  | Note
ER |  | 7 |  | 7 |  | 3.9
PR |  | 0 |  |  |  | 2.4
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 4-1 | 51145/6-04010/20-T1 |  | Problem: Mislocated part |  |  | Station:6/6 |  | Ran:426            of      1400 | 0.5
Human Problem |  |  | Last PM: | 2008-06-20 00:00:00 | Machine | Die | Root Cause: | Fingers too low |  |  | 7:15-7:40
CM: |  |  |  |  | Explain: | The part was removed fingers were adjusted and production was good. |  |  |  |  | Darrell
Stamping T/L: Chad R
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
Er |  | 4-1 | 48621-0C010-T1 |  | Problem: [NAME] sticking |  |  | Station:2/6 |  | Ran:400               of       900 | 0.25
Human Problem |  |  | Last PM: | 2008-07-07 00:00:00 | Machine | Die | Root Cause: | There was gaulding |  |  | 9:25-9:45
CM: |  |  |  |  | Explain: | The lifter was removed ,the gauld polished off.This was assembled and production was good. |  |  |  |  | Darrell
Stamping T/L: Chad R
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 4-1 | 42111-02070 |  | Problem: Out of spec |  |  | Station: 5/8 |  | Ran: | 5
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | Die modification ( trial ) |  |  | 1:30-6:30
CM: |  |  |  |  | Explain: | To get the spec's in DM weld area's of the trim sections in 5/8. We had to grind them in
 |  |  |  |  | at the press.
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
Misc.Notes:
Spreadsheet: 130656d1322504956-counting-a-list-of-strings-pv_jpr73
Sheet: Sheet1

Cities |  |  |  | Cities | Nombre de Cities
Atlanta |  |  |  | Atlanta | 4
San Diego |  |  |  | Detorit | 1
Detroit |  |  |  | Detroit | 1
Atlanta |  |  |  | Kansas City | 1
New York |  |  |  | New York | 2
Kansas City |  |  |  | San Diego | 1
New York |  |  |  | Total général | 10
Atlanta
Detorit
Atlanta
Spreadsheet: daren_farmer__6563__egmnom-Feb
Sheet: RHODIA

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-27106-02-011
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-02-01 00:00:00
Fax: | (713)207-0054 | Stop:
 |  | 2000-02-29 00:00:00
RECEIPTS |  |  | FEB
METER # | [NAME] | SUPPLIER | 1
4132 | EXXON KATY | [NAME] (MIDCON 92155) | 500
ZZZZ | IMBALANCE |  | 0
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
8078 | RHODIA-FREEPORT | RHODIA-FREEPORT | 500
ZZZZ | IMBALANCE |  | 0
 |  | DELIVERY TOTAL
 |  | BALANCE
Spreadsheet: 97592a97-cf48-4729-a5a5-a2b85dc9cc53
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
3A4B | Test | 3A4B | Cytochrome P450 3A4 Genotype, Blood | CYP3A4 Genotype, B | Polymerase Chain Reaction (PCR) 5'-Nuclease End-Point Allelic Discrimination Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Lavendar-top (EDTA) Tube: EDTA |  |  | 3 | mL | Multiple genotype tests can be performed on a single specimen after a single extraction. See Multiple Whole Blood EDTA Genotype Tests in Special Instructions for a list of tests that can be ordered together.   Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions: Send specimen in original tube. Additional Information: Patients who had a heterologous blood transfusion within the preceding 45 days (6 weeks), or who have received an allogeneic bone marrow transplant, can have false genetic test results as human DNA present in the blood may be a mixture of patient and donor DNA. For these patients, saliva specimen (rather than blood) should be submitted, order 3A4O/61242 Cytochrome P450 3A4 Genotype, [NAME]. Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 0.3 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday | 1 day | 8 days | 1 | 81401 |  |  |  |  | Rochester
3A4B | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
3A4B | Result | 34689 | CYP3A4 Genotype Result | CYP3A4 Genotype Result | Alphanumeric
3A4B | Result | 34690 | CYP3A4 Interpretation | CYP3A4 Interpretation | Alphanumeric
3A4B | Result | 34691 | Reviewed by | Reviewed by | Numeric
Spreadsheet: 89429d1289231565-select-data-based-on-time-and-date-schedule-2010-2011
Sheet: Sept 27

 |  |  | COMPUTER LABORATORY SCHEDULE
 |  | SEPTEMBER | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY
 |  | Date: | 27 |  | 28 |  | 29 |  | 30 |  | 1
 |  | Color: | MAROON |  | GOLD |  | MAROON |  | GOLD |  | MAROON
 |  | Room Number: | CL1 | CL2 | CL1 | CL2 | CL1 | CL2 | CL1 | CL2 | CL1 | CL2
 |  | Start Time (Period): |  |  | Flex 2/8 |  |  |  | Flex 3/1
 |  | 9:00 (1 or 5) |  |  | McGinley |  |  |  | Diehl | May | Diehl | Costello(32)
 |  | 9:45 |  | Robbins(21)* | McGinley | Robbins(20)* |  |  | Tyson | Costello(33) | Diehl
 |  | 10:40 (2 or 6) |  | Usiskin(11) |  |  |  | Usiskin(11) |  |  | Usiskin(11) | May
 |  | 11:25:00 |  | Usiskin(11) |  |  |  | Usiskin(11) |  |  | Usiskin(11) | Costello
 | WEEK ENDING: : | 12:15 (3 or 7 ) A |  |  |  | Habibi |  |  | Tyson(36) | Costello(37) | Costello(34) | May
 |  | 12:44                B |  |  |  | Habibi |  |  | Tyson(36) | Costello(37) | Costello(34) | May
 |  | 1:13                C |  | Robbins(21)* | Totaro | Habibi |  |  |  | [NAME] |  | Tyson
 |  | 1:44                D |  | Robbins(21)* | Totaro | Habibi |  |  |  | [NAME] |  | Tyson
 |  | 2:19  (4 or 8) |  | McGinley | McGinley |  | McGinley |  | Diehl | May(35) | Robbins | May(39)
 |  | 03:04:00 |  | McGinley | McGinley | Robbins(25)* | McGinley |  | Diehl | Waterman | Robbins | Tyson(35)
 |  |  |  |  |  |  |  |  |  | [NAME] meeting AM |  | [NAME]
Spreadsheet: 218750d1362567603-ctrl-shift-enter-0search
Sheet: Sheet1

 | Order: | A001-2004 | <- This one is filled in by me!
 | Order: | File: | Sum:
 | A001-2004 | 010 | 130 |  | <- These rows are supposed to be filled in automatically.
 |  | 020 | 45
 |  | 030 | 318
 |  | 040 | 254
 |  | 050 | 658
 |  | 060 | 4
 |  | 070 | 548
 |  | 080 | 25
 |  | 090 | 54
 |  | 100 | 87
 |  | 110 | 835
 |  | 120 | 224
 |  | 130 | 654
 |  | 140 | 543
 |  | 150 | 2533
 |  | 160 | 1
 |  | 170 | 564
 |  | 171 | 359
 |  | 180 | 349
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
Spreadsheet: mary_fischer__25621__77N
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 077N |  | (Please print)  PREPARED BY: | Sonya City
COMPANY NAME    Marlin Electrical, Inc
E-SCHEDULES CHECK LIST
For the period ending: 06/30/2001 |  | REVIEWED BY: | [NAME]
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | N/A
E-2 * | 195 | Other Current Assets | Completed
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | N/A
E-5 | 344 | Goodwill | N/A
E-6 * | TOT_PPE | Property, Plant & Equipment | Completed
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | Completed
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | Completed
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | Completed
E-21 |  | Lease Expense & Future Lease Commitments | Completed
E-31 | VARIOUS ACCOUNTS | Equity/Invmt Sub | Completed
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: 267560d1380111369-countifs-row-wise-belfagor
Sheet: Sheet1

Gender | mat_score | lang_score
1 | 20 | 25
2 | 22 | 23
1 | 19 | 27
 |  |  | mat_score | lang_score
 | Type1 | 2
 | Type2
Spreadsheet: 122454d1316806610-creating-a-sorted-spreadsheet-using-data-from-2-separate-sheets-test-data
Sheet: Sheet2

DISPLAY_ORDER | INDENT_LEVEL | DISPLAY_TEXT | DISPLAY_NUMBER
0 | 0 | Store | [PHONE]
1 | 1 | Deli | [PHONE]
2 | 2 | Bakery | [PHONE]
3 | 3 | Pharmacy | [PHONE]
Spreadsheet: 43976d1242655522-sharehouse-splitting-the-bill-sharehouse-expenses
Sheet: Ant

Smith Expenses |  |  |  | Cost Breakdown
Description | Cost | X Split | Individual share | Himself | [NAME] | Nate | Cuz | total check
? | 2.98 | 4 |  | 0.75 | 0.75 | 0.75 | 0.75
? | 5.47 | 4 |  | 1.37 | 1.37 | 1.37 | 1.37
? | 7 | 4 |  | 1.75 | 1.75 | 1.75 | 1.75
? | 6 | 1 |  | 0 | 0 | 6 | 0
? | 18 | 1 |  | 0 | 0 | 18 | 0
? | 2.57 | 3 |  | 0.86 | 1.72 | 0 | 0
? | 3.5 | 4 |  | 0.88 | 0.88 | 0.88 | 0.88
? | 1.54 | 3 |  | 0.51 | 1.02 | 0 | 0
 |  |  | Total
Spreadsheet: 4cc147cc-0037-43ff-8f4b-571ae2b11532
Sheet: Engel Curve

a = |  | b = |  | Px = |  | Py =
increment | 5
Income (I)
0
Spreadsheet: 815445d1674951960-put-structured-data-into-an-array-data-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Desired outcome
 |  |  |  |  |  |  |  |  | Data
 |  |  |  |  |  |  |  |  | Adam | Name of persons
 |  |  |  |  |  |  |  |  | Adam | Favourite food
 |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  | Pizza
 |  |  |  |  |  |  |  |  | Cookie
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  | Pie
 |  |  |  |  |  |  |  |  | Soup
 |  |  |  |  |  |  |  |  | QQQ
 |  |  |  |  |  |  |  |  | QQQ
 |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  | WWW
 |  |  |  |  |  |  |  |  | WWW
 |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  | Y
 |  |  |  |  |  |  |  |  | EEE
 |  |  |  |  |  |  |  |  | EEE
 |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  | RRR
 |  |  |  |  |  |  |  |  | RRR
 |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | HGFD
Spreadsheet: jeff_dasovich__14083__ENRON2
Sheet: Utility

SCE
RESOURCE TYPE | ELECTRICITY GENERATION (GWH) | REVENUE REQUIREMENT ($ MILLIONS) | AVERAGE COST ($/MWH)
QF | 25494 |  | 80
Coal
Hydro | 3166 | 117770
San Onofre Nuclear | 11777
Palo Verde Nuclear | 4545 | 157460
SUBTOTAL UTILITY GENERATION
CDWR Purchases |  |  | 80
TOTAL GENERATION
Ancillary Services Uplift |  |  | 10
Fully Loaded Procurement Costs at Generation
Fully Loaded Procurement Costs at Meter
Generation Component in Retail Rates |  |  | 75
Necessary Rate Increase (Decrease)
NET SHORT CALCULATION
Retail Sales at Meter | 84000
Retail Sales at Generation
Utility Generation
Net Short
Footnote:
PG&E did not provide any detail to develop a similar comparison.
Spreadsheet: 232536d1367444039-ms-excel-2010-shifting-cells-permanently-example
Sheet: Sheet1

Last Name | First Name | Access Card | Normal Rights | Access Codes | [NAME] | Readers
Doe | [NAME] | 42158 |  | General
Darling | [NAME] | 96547 |  | File Room
[NAME] | Emma | 25412 |  | General
 |  |  |  | General
Able | Zion | 12547 |  | General
 |  |  | Armin
 |  |  | Alise
 |  |  | 45879
 |  |  |  | NormalRights
 |  |  |  |  | AccessCodes
 |  |  |  |  | Construction
 |  |  |  |  | General
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | 51247
 |  |  |  | NormalRights
 |  |  |  |  | AccessCodes
 |  |  |  |  | General
Spreadsheet: 750290d1633369115-simple-index-match-with-three-conditions-returens-ref-when-only-one-cell-schanged-error
Sheet: flt_pln_fuel_figs

 | Schedule | Sector | [NAME] | Contingency | Alternative | Reserve | Taxi | Allocated Cargo | Additional Payload
 | A330-200 - CCC | Sector 1 | 60303 | 3015 | 2974 | 2649 | 408 | 2500 | 29.556
 | A330-200 - CCC | Sector 2 | 64460 | 3223 | 3602 | 2778 | 136 | 2200 | 19.12
Spreadsheet: 483539d1475702385-sumproduct-formula-with-sumif-sumif-and-sumproduct-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | remove this column
 |  |  |  |  |  | Groups | Types | Amount | M1 |  | M2 | M3 | M4 | M5 | M6 | M7 | M8 |  | Total
 |  |  |  |  |  | 55555 | 100B | 3000 | 0.05 |  | 0.02 | 0.2 |  | 0.03 | 0.7
 |  |  |  |  |  | 55555 | 2200B | 4000 |  |  |  | 0.12 |  | 0.08 | 0.75 | 0.05
 |  |  |  |  |  | 55555 | 3000B | 6000 | 0.05 |  | 0.05 |  | 0.02 |  | 0.93
 |  |  |  |  |  | 22222 | 1000A | 2000 |  |  |  | 0.05 |  |  | 0.85 |  | 0.1
 |  |  |  |  |  | 22222 | 2000A | 100 |  |  | 1
 |  |  |  |  |  | 1000 | 4000A | 1400 |  |  |  | 0.45 | 0.05 |  |  | 0.35 | 0.15
 |  |  |  |  |  | 1000 | 4000B | 900 |  |  |  |  |  |  | 0.05 |  | 0.9
 |  |  |  |  |  | 1000 | 4000C | 1200 | 0.2 |  |  |  | 0.4 |  |  | 0.4
 |  |  |  |  |  | 1000 | 4000D | 500 |  |  | 0.05 |  | 0.5 | 0.05 | 0.1 | 0.3 | 0.05
 |  |  |  |  |  |  | Totals
 |  |  |  |  |  |  | 55555
 |  |  |  |  |  |  | 22222
 |  |  |  |  |  |  | 1000
Spreadsheet: 862382d1710146443-date-change-in-a-cell-change-date
Sheet: Foglio1

8 | 8
4 | 6 | 1
7 | 7 | 2
90 | 8 | 3
54 | 88 | 4
9 | 5
3 | 6
Spreadsheet: 691492d1597725241-golf-stableford-countback-formula-stableford-scores
Sheet: Sheet1

 |  |  |  |  |  |  | [NAME]
# | Name | HCP | Hole 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total
1 | Scott |  | 2 | 1 | 1 | 1 | 2 | 1 | 2 | 2 | 0 | 1 | 0 | 2 | 2 | 3 | 2 | 1 | 2 | 3
2 | [NAME] |  | 2 | 4 | 0 | 3 | 1 | 2 | 2 | 2 | 2 | 1 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2
3 | [NAME] |  | 0 | 3 | 0 | 1 | 2 | 4 | 1 | 3 | 2 | 1 | 1 | 2 | 1 | 2 | 2 | 0 | 1 | 2
4 | [NAME] |  | 2 | 3 | 2 | 2 | 1 | 2 | 1 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Spreadsheet: 811561d1672653164-lookup-function-from-column-base-to-row-base-sample-case
Sheet: WORKING FILE

 | SKU | CITY | W1 | [NAME] | W3 | W4 | TOTAL
 | ZCR-D190(S) | ABC |  |  |  |  |  |  |  | EXPECTED RESULT
 | ZCR-D190(LK) | ABC
 | ZCR-D190(LB) | ABC
 | ZCR-D225(MDS) | ABC
 | ZCR-D225(MLS) | ABC
 | ZCR-D225(MSG) | ABC
 | ZCR-D225(MSB) | ABC
 | AQR-D190(LK) | ABC
 | ZCR-D191(LS) | ABC
 | ZCR-D191(LK) | ABC
 | ZCR-D191(LB) | ABC
 | ZCR-D205(MDS) | ABC
 | ZCR-D205(MLS) | ABC
 | ZCR-D205(MSG) | ABC
 | ZCR-D205(MSB) | ABC
 | ZCR-D251(DS) | ABC
 | ZCR-D251(LS) | ABC
 | ZCR-D190(S) | DEF
 | ZCR-D190(LK) | DEF
 | ZCR-D190(LB) | DEF
 | ZCR-D225(MDS) | DEF
 | ZCR-D225(MLS) | DEF
 | ZCR-D225(MSG) | DEF
 | ZCR-D225(MSB) | DEF
 | ZCR-D191(DS) | DEF
 | ZCR-D191(LS) | DEF
 | ZCR-D191(LK) | DEF
 | ZCR-D191(LB) | DEF
 | ZCR-D205(MDS) | DEF
 | ZCR-D205(MLS) | DEF
 | ZCR-D205(MSG) | DEF
 | ZCR-D205(MSB) | DEF
 | ZCR-D251(DS) | DEF
 | ZCR-D251(LS) | DEF
 | ZCR-D190(S) | GHI
 | ZCR-D190(LK) | GHI
 | ZCR-D190(LB) | GHI
 | ZCR-D225(MDS) | GHI
 | ZCR-D225(MLS) | GHI
 | ZCR-D225(MSG) | GHI
 | ZCR-D225(MSB) | GHI
 | ZCR-D191(DS) | GHI
 | ZCR-D191(LS) | GHI
 | ZCR-D191(LK) | GHI
 | ZCR-D191(LB) | GHI
 | ZCR-D205(MDS) | GHI
 | ZCR-D205(MLS) | GHI
 | ZCR-D205(MSG) | GHI
 | ZCR-D205(MSB) | GHI
 | ZCR-D251(DS) | GHI
 | ZCR-D251(LS) | GHI
Spreadsheet: 861056d1709048999-if-function-that-either-counts-between-two-dates-or-between-one-date-and-todays-date-log-formula-query-copy
Sheet: PO Receipt Log

If Queried Date | Details of query sent out | Date re-sent after query resolved | Time Spent in Query | Aging (Query)
2023-11-29 00:00:00 |  | 2024-01-09 00:00:00
2023-11-21 00:00:00 |  | 2023-11-24 00:00:00
2023-11-13 00:00:00
2023-11-15 00:00:00 |  | 2024-02-26 00:00:00
2023-11-15 00:00:00
2023-11-15 00:00:00
2023-11-15 00:00:00 |  | 2023-11-15 00:00:00
Spreadsheet: 836990d1689774367-custome-week-numbers-example-week-number-help-hd
Sheet: Sheet1

 |  |  |  |  | Date | Week Number | Day
 |  |  |  |  | 2022-06-01 00:00:00
 |  |  |  |  | 2022-06-02 00:00:00
 |  |  |  |  | 2022-06-03 00:00:00
 |  |  |  |  | 2022-06-04 00:00:00
 |  |  |  |  | 2022-06-05 00:00:00
 |  |  |  |  | 2022-06-06 00:00:00
 |  |  |  |  | 2022-06-07 00:00:00
 |  |  |  |  | 2022-06-08 00:00:00
 |  |  |  |  | 2022-06-09 00:00:00
 |  |  |  |  | 2022-06-10 00:00:00
 |  |  |  |  | 2022-06-11 00:00:00 |  |  | Up to this row is formula for week number
 |  |  |  |  | 2023-06-01 00:00:00
 |  |  |  |  | 2023-06-02 00:00:00
 |  |  |  |  | 2023-06-03 00:00:00
 |  |  |  |  | 2023-06-04 00:00:00
 |  |  |  |  | 2024-06-01 00:00:00
 |  |  |  |  | 2024-06-02 00:00:00
 |  |  |  |  | 2024-06-03 00:00:00
 |  |  |  |  | 2024-06-04 00:00:00
 |  |  |  |  | 2024-06-05 00:00:00
 |  |  |  |  | 2024-06-06 00:00:00
 |  |  |  |  | 2024-06-07 00:00:00
 |  |  |  |  | 2024-06-08 00:00:00
 |  |  |  |  | 2022-12-01 00:00:00
 |  |  |  |  | 2023-04-01 00:00:00
Spreadsheet: 268382d1380612033-seperate-a-info-in-a-cell-with-formula-or-script-seperate-value
Sheet: Sheet1

This is a collumn given by the export i run from a system. So hard data and also the first "code" of the link in cell [NAME] with an additional space | This is a collumn given by the export i run from a system. So hard data and i want to remove the letters from it (if it contains any) and have the output in cell C7 | This is what the formula for me should do. So remove the letters (if it contains any) | This is an easy one and i allready fixed it | This should be easy if i know which formula to put in C7…….
[NAME] | Link | Without letters | Part 1 of link | Part 2 of link
5348 A | 5348A-5360E | 5348-5360 |  | 5360
4360 A | 4360A-9067C | 4360-9067 |  | 9067
10477 G | 5698-854 | 5698-854 |  | 854
Spreadsheet: 43561d1242209483-viewing-multiple-worksheets-on-one-main-worksheet-2009-10-calendar
Sheet: Mar Child

CYPD TRAINING MARCH 2010
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  | 2010-03-01 00:00:00 |  | 2010-03-02 00:00:00 |  | 2010-03-03 00:00:00 |  | 2010-03-04 00:00:00 |  | 2010-03-05 00:00:00 |  | 2010-03-06 00:00:00
2010-03-07 00:00:00 |  | 2010-03-08 00:00:00 |  | 2010-03-09 00:00:00 |  | 2010-03-10 00:00:00 |  | 2010-03-11 00:00:00 |  | 2010-03-12 00:00:00 |  | 2010-03-13 00:00:00
2010-03-14 00:00:00 |  | 2010-03-15 00:00:00 |  | 2010-03-16 00:00:00 |  | 2010-03-17 00:00:00 |  | 2010-03-18 00:00:00 |  | 2010-03-19 00:00:00 |  | 2010-03-20 00:00:00
2010-03-21 00:00:00 |  | 2010-03-22 00:00:00 |  | 2010-03-23 00:00:00 |  | 2010-03-24 00:00:00 |  | 2010-03-25 00:00:00 |  | 2010-03-26 00:00:00 |  | 2010-03-27 00:00:00
2010-03-28 00:00:00 |  | 2010-03-29 00:00:00 |  | 2010-03-30 00:00:00 |  | 2010-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  | Notes: