tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 34938d1232395915-formula-help-to-calculate-only-the-first-90-days-cashier-work-history-test-4-
Sheet: Rolling 90 Day

Employee: | [NAME] | Start Date: | 2009-01-01 00:00:00 | First 90 Days: |  | < I want F1 to only calculate the first 90 days based on D1. Any dates/amounts after that will not total here.
Cashier Variances |  |  | Rolling 90 Day Variances: |  | -10 | < Currently F3 is for the rolling 90 days below. I don't want this one to start until 90 Days after "D1"
DATE | Comments |  |  |  | Abstract Amount
2008-11-05 00:00:00 |  |  |  |  | 3
2009-01-10 00:00:00 |  |  |  |  | -2
2009-01-11 00:00:00 |  |  |  |  | -3
2009-01-12 00:00:00 |  |  |  |  | -8
Spreadsheet: 743763d1628703398-dynamic-return-shortage-date-and-time-shortage-date-and-time
Sheet: Sheet1

Item Number | Total Inventory | Date | Shortage Shipment | Shortage Date | Shortage Time |  | Shipment Number | Item Number | Secondary Qty | Scheduled Ship Date | Scheduled Ship Time
6036412 | 150 | 2021-08-10 00:00:00 |  |  |  |  | 6804860 | 6023837 | 25 | 2021-08-10 00:00:00 | 80000
6023837 | 50 | 2021-08-10 00:00:00 |  |  |  |  | 6805055 | 6023837 | 25 | 2021-08-10 00:00:00 | 80000
6035329 | 0 | 2021-08-10 00:00:00 |  |  |  |  | 6808958 | 6036412 | 22 | 2021-08-10 00:00:00 | 173000
 |  |  |  |  |  |  | 6808956 | 6036412 | 22 | 2021-08-10 00:00:00 | 180000
 |  |  |  |  |  |  | 6808954 | 6036412 | 22 | 2021-08-10 00:00:00 | 183000
 |  |  |  |  |  |  | 6808951 | 6036412 | 22 | 2021-08-10 00:00:00 | 190000
 |  |  |  |  |  |  | 6814467 | 6022741 | 11 | 2021-08-11 00:00:00 | 50000
 |  |  |  |  |  |  | 6814467 | 6026033 | 11 | 2021-08-11 00:00:00 | 50000
 |  |  |  |  |  |  | 6814468 | 6032283 | 1 | 2021-08-11 00:00:00 | 60000
 |  |  |  |  |  |  | 6814468 | 6035329 | 7 | 2021-08-11 00:00:00 | 60000
 |  |  |  |  |  |  | 6814468 | 6035330 | 14 | 2021-08-11 00:00:00 | 60000
 |  |  |  |  |  |  | 6805057 | 6023837 | 25 | 2021-08-11 00:00:00 | 60000
 |  |  |  |  |  |  | 6814469 | 6032285 | 4 | 2021-08-11 00:00:00 | 70000
 |  |  |  |  |  |  | 6814469 | 6035329 | 6 | 2021-08-11 00:00:00 | 70000
 |  |  |  |  |  |  | 6814469 | 6033729 | 12 | 2021-08-11 00:00:00 | 70000
 |  |  |  |  |  |  | 6805058 | 6023837 | 25 | 2021-08-11 00:00:00 | 70000
 |  |  |  |  |  |  | 6814470 | 6033729 | 11 | 2021-08-11 00:00:00 | 80000
 |  |  |  |  |  |  | 6814470 | 6033809 | 11 | 2021-08-11 00:00:00 | 80000
 |  |  |  |  |  |  | 6805059 | 6023837 | 25 | 2021-08-11 00:00:00 | 80000
 |  |  |  |  |  |  | 6805160 | 6035323 | 22 | 2021-08-11 00:00:00 | 90000
 |  |  |  |  |  |  | 6805060 | 6023837 | 25 | 2021-08-11 00:00:00 | 90000
 |  |  |  |  |  |  | 6805162 | 6035323 | 22 | 2021-08-11 00:00:00 | 110000
 |  |  |  |  |  |  | 6805218 | 6036775 | 22 | 2021-08-11 00:00:00 | 110000
 |  |  |  |  |  |  | 6805163 | 6031797 | 9 | 2021-08-11 00:00:00 | 130000
 |  |  |  |  |  |  | 6805163 | 6035323 | 13 | 2021-08-11 00:00:00 | 130000
 |  |  |  |  |  |  | 6805220 | 6036775 | 22 | 2021-08-11 00:00:00 | 130000
 |  |  |  |  |  |  | 6805223 | 6036775 | 22 | 2021-08-11 00:00:00 | 150000
 |  |  |  |  |  |  | 6808948 | 6036412 | 22 | 2021-08-11 00:00:00 | 150000
 |  |  |  |  |  |  | 6808946 | 6036412 | 22 | 2021-08-11 00:00:00 | 153000
 |  |  |  |  |  |  | 6808942 | 6036412 | 22 | 2021-08-11 00:00:00 | 160000
 |  |  |  |  |  |  | 6808939 | 6036412 | 22 | 2021-08-11 00:00:00 | 163000
 |  |  |  |  |  |  | 6808932 | 6036412 | 22 | 2021-08-11 00:00:00 | 170000
 |  |  |  |  |  |  | 6808937 | 6036412 | 22 | 2021-08-11 00:00:00 | 173000
 |  |  |  |  |  |  | 6808936 | 6036412 | 22 | 2021-08-11 00:00:00 | 180000
 |  |  |  |  |  |  | 6808935 | 6036412 | 22 | 2021-08-11 00:00:00 | 183000
 |  |  |  |  |  |  | 6808934 | 6017693 | 22 | 2021-08-11 00:00:00 | 190000
 |  |  |  |  |  |  | 6808924 | 6017693 | 22 | 2021-08-11 00:00:00 | 193000
Spreadsheet: 689852d1596706421-how-to-count-sum-average-first-x-active-cells-in-y-columns-excel-expert-query
Sheet: Sheet1

 | [NAME] | Avg | Jan | Feb | Mar | Apr | May | Jun | July | Aug | Sep | Oct | Nov | Dec
Jon Rahm | 92 |  | 32 |  | 26 |  | 11 |  |  | 23 | 14 | 45 | 21 | 16
[NAME] | 77 |  |  | 27 | 11 | 3 |  |  |  |  |  | 36 | 11 | 65
 | Cells in Column B must equal the sum of the first four columns with a value across the months (Jan, Mar, May, Aug)
 | Cells in Column C must equal the average of the first four month columns with a value
Spreadsheet: 104519d1302104871-if-statement-needed-mock-spreadsheet
Sheet: Product A

product | month | id number | subtotal
A
Spreadsheet: 02d0b933-aff4-44e9-be0a-5866eac1fe3a
Sheet: 2012 MINING SI

Attachment
2012 EC Special Inquiries and Type of Operation for the Mining Sector
[NAME] | SUB_TITLE | NAICS Coverage | SI | TYPE OF OPERATION
[NAME] | Crude Petroleum and Natural Gas Extraction | 211111 | SI MI 21101
MI-21102 | Natural Gas Liquid Extraction | 211112
MI-21171 | Crude Petroleum and Natural Gas Extraction | 211111
MI-21201 | Coal Mining | 212111, 212112, 212113 | SI MI 21201 | TO MI 21201
MI-21202 | Iron Ore Mining | 212210 |  | TO MI 21202 Pt 1 and Pt2
MI-21203 | Copper, Lead, Zinc, Gold, and Silver Ore Mining | 212221, 212222, 212231, 212234 | SI MI 21203 with Metal | TO MI 21203 Pt 1 and Pt2
MI-21204 | Uranium-Radium-Vanadium Ore Mining | 212291 |  | TO MI 21204
MI-21205 | Miscellaneous Metal Ore Mining | 212299 |  | TO MI 21205
MI-21206 | Stone, Sand, and Gravel Mining or Quarrying | 212311, 212312, 212313, 212319, 212321, 212322 |  | TO MI 21206
MI-21207 | Clay, Ceramic, and Refractory Mineral Mining | 212324, 212325 |  | TO MI 21207 Pt 1 and Pt2
MI-21208 | Potash, Soda, and Borate Mineral Mining | 212391 |  | TO MI 21208
MI-21209 | Phosphate Rock Mining | 212392 |  | TO MI 21208
MI-21210 | [NAME] and Fertilizer Mineral Mining | 212393 |  | TO MI 21208
MI-21211 | [NAME] | 212399 |  | TO MI 21208
MI-21271 | Stone Mining and Quarrying, and Sand and Gravel Mining | 212312, 212319, 212321
MI-21301 | Oil and Gas Field Services | 213111, 213112 | SI MI 21301 for Leases Operated
MI-21302 | Mineral Contract Services | 213113, 213114, 213115 |  | TO MI 21302
MI-21351 | Oil and Gas Field Services - Consolidated | 213111, 213112 | SI MI 21301 for Leases Operated
MI-21352 | Mineral Contract Services - Consolidated | 213113, 213114, 213115 |  | TO MI 21302
Spreadsheet: 747019d1631184596-how-many-names-are-common-between-lists-and-how-many-are-not-in-any-list-compare-3-lists-for-all-and-neither-match
Sheet: Sales

[NAME] |  |  | In both | In Neither
Leanne
[NAME]
Imogen
Rochelle
[NAME]
Riley
Victoria
Lily
[NAME]
Violet
Nova
[NAME]
[NAME]
Zoe
Stella
Everly
Isla
Leah
Lillian
Addison
Willow
[NAME]
Paisley
[NAME]
Naomi
Eliana
Brooklyn
Elena
[NAME]
Sales Only
With Webinar
With Lead
All 3
Spreadsheet: 357053d1415290895-how-to-combine-multilple-workbooks-tabs-into-one-2011-spend
Sheet: 2011

Month | Invoice Ref | Supplier | Total Invoiced
2011-01-01 00:00:00 | 231 | Dell | 42342
2011-02-01 00:00:00 | 423423 | Apple | 3524
2011-03-01 00:00:00 | 2131 | Samsung | 24
2011-04-01 00:00:00 | 2313 | Sony | 53454
2011-05-01 00:00:00 | 3453 | HP | 523
2011-06-01 00:00:00 | 45 | [NAME] | 234234
2011-07-01 00:00:00 | 4782 | Fifa | 23423
2011-08-01 00:00:00 | 3231 | Arsenal | 4235
2011-09-01 00:00:00 | 782 | Windows | 3453
2011-10-01 00:00:00 | 2347812 | Intel | 423
2011-11-01 00:00:00 | 123 | Holly Wood | 34543
2011-12-01 00:00:00 | 3425 | Real Madrid | 523512
Spreadsheet: 36477d1234361412-moving-rows-to-anoter-worksheet-based-on-certain-criteria-kpi-1-
Sheet: Thor

Address Book Entry | Close Date | Number of Analyzers required | Total Capital | Annual Number of Cartridges | Annual Cartridge Revenue | Status | Confidence Rating | Revenue
Royal Adelaide Hospital | 2009-11-30 00:00:00 | 1 | 6750 | 10000 | 25000 | New | 2 Doubtful | 31750
Women's and Children's Hospital | 2009-11-30 00:00:00 | 1 | 5000 | 500 | 3000 | Updated | 3 Uncertain | 8000
 |  | 2 | 11750 |  | 28000 |  | 0 | 39750
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 0 | 1
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Spreadsheet: 876152d1722846252-need-formula-for-tier-incentive-calculation-calculation-doing-formula
Sheet: Dr. Saud Al Slash 1

 |  |  | Total Revenue
 |  |  | Consumables
 |  |  | The Clinics OR Fees
 |  |  | Hospital Fees
 |  |  | Total
 |  |  | Dr. [NAME]
 |  |  | Lab Revenue | 1820
 |  |  | Lab Share (35%)
 |  |  | Lab 10%
 |  |  | Net Payment
 |  |  | Service | Amount | OHE | % | Comm. % | Comm.
 |  |  | Consultation | 4200 | 0.05 |  | 0.5
 |  |  | Procedure | 0 | 0.05 |  | 0.5
 |  |  | OR In the Clinics | 16180 | 0.05 |  | 0.3
 |  |  | OR Outside the Clinics | 45000 | 0.05 | 0 | 0.65
 |  |  | Other Exp.
 |  |  | Marketing (50-50) | 0
 |  |  |  | % | Target
 |  |  |  | 0.3 | 0 |  | 500000
 |  |  |  | 0.32 | 500001 |  | 600000
 |  |  |  | 0.35 | 600001 |  | 700000
 |  |  |  | 0.37 | 700001 |  | 800000
 |  |  |  | 0.4 | 800001 |  | 1000000
 |  |  |  |  | Doctor [NAME] ……………
 |  |  |  |  |  |  |  |  |  |  |  | Operations Report on MAY- 2019
 |  |  |  |  |  |  |  |  |  |  |  | # | Day/Date | Time | Patient Name and file number |  | [NAME] | Price | Surgeon | Anesthesia |  | OR
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 2019-05-25 00:00:00 | At 3:43 pm he tooks           1 hr & 2 mins | [NAME] 10051458 |  | Tip [NAME] | 16180 | Dr Saud | GA | 3000 | 3000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Less 33% Discount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net
Spreadsheet: mary_fischer__25740__E-20R
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #
COMPANY NAME
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 12 MONTHS ENDED 12-31-2000
PREPARED BY: [NAME]
EXTENSION: x36876
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: gstorey__12026__Feb01
Sheet: Table10

NATURAL GAS EXPORTS BY TERM, REGION, AND CUSTOMER TYPE |  |  |  |  |  |  |  |  |  |  |  | TABLE 10
EXPORTATIONS DE GAZ NATUREL PAR TERME, RÉGION, ET CLIENT
CALENDAR YEAR TO DATE
 |  |  |  | AVERAGE PRICE |  |  |  |  |  | AVERAGE PRICE
 | VOLUME |  |  | PRIX MOYEN |  |  | VOLUME |  |  | PRIX MOYEN
 | (MILLIONS M3) |  |  | ($CDN/GJ) |  |  | (BCF) |  |  | ($US/MMBTU)
 |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE
 | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | VARIATION | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | VARIATION | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | VARIATION | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | VARIATION
 | 2000-02-01 00:00:00 | 2001-02-01 00:00:00 |  | 2000-02-01 00:00:00 | 2001-02-01 00:00:00 |  | 2000-02-01 00:00:00 | 2001-02-01 00:00:00 |  | 2000-02-01 00:00:00 | 2001-02-01 00:00:00
TERM/TERME
LONG-TERM (FIRM)/LONG TERME (GARANTI) | 4616.5 | 3523 | -23.7 | 3.51 | 9.39 | 167.5 | 163 | 124.4 | -23.7 | 2.6 | 6.67 | 156.8
SHORT-TERM (FIRM)/COURT TERME (GARANTI) | 8073.2 | 9136.3 | 13.2 | 3.22 | 11.12 | 245.7 | 285 | 322.5 | 13.2 | 2.38 | 7.9 | 232
SHORT-TERM/COURT TERME (INTERRUPTIBLE) | 4256.1 | 6428.6 | 51 | 3.29 | 12.27 | 272.8 | 150.2 | 226.9 | 51 | 2.44 | 8.72 | 258.1
TOTAL - TERM/TERME | 16945.8 | 19088 | 12.6 | 3.31 | 11.19 | 237.5 | 598.2 | 673.8 | 12.6 | 2.45 | 7.95 | 224.2
REGION/RÉGION
CALIFORNIA/CALIFORNIE | 3426.6 | 2919.2 | -14.8 | 3.02 | 12.09 | 300.7 | 121 | 103 | -14.8 | 2.23 | 8.59 | 284.6
MIDWEST/MIDWEST | 6207.2 | 7061.2 | 13.8 | 3.12 | 11.04 | 253.6 | 219.1 | 249.3 | 13.8 | 2.31 | 7.85 | 239.7
MOUNTAIN/ROCHEUSES | 188.2 | 64.1 | -65.9 | 3.01 | 7.61 | 152.5 | 6.6 | 2.3 | -65.9 | 2.23 | 5.42 | 142.8
NORTHEAST/NORD-EST | 4666.8 | 6262.1 | 34.2 | 3.9 | 10.77 | 176.4 | 164.7 | 221.1 | 34.2 | 2.88 | 7.65 | 165.4
PACIFIC NORTHWEST/NORD-OUEST PACIFIQUE | 2457.1 | 2781.4 | 13.2 | 3.14 | 11.65 | 270.6 | 86.7 | 98.2 | 13.2 | 2.33 | 8.28 | 255.9
TOTAL - REGION/RÉGION | 16945.8 | 19088 | 12.6 | 11.19 | 3.31 | 237.5 | 598.2 | 673.8 | 12.6 | 2.45 | 7.95 | 224.2
CUSTOMER TYPE/CLIENT
END-USER/UTILISATEURS ULTIMES | 1350.1 | 1268.2 | -6.1 | 3.72 | 7.56 | 103.2 | 47.7 | 44.8 | -6.1 | 2.75 | 5.37 | 94.9
LDC/SDL | 4507.9 | 4001.9 | -11.2 | 3.39 | 10.36 | 205.4 | 159.1 | 141.3 | -11.2 | 2.51 | 7.36 | 193.2
MARKETING CO./DISTRIBUTEURS | 10473.2 | 13405 | 28 | 3.26 | 11.85 | 263 | 369.7 | 473.2 | 28 | 2.41 | 8.42 | 248.7
PIPELINE/PIPELINES | 614.7 | 412.9 | -32.8 | 2.74 | 8.98 | 227.5 | 21.7 | 14.6 | -32.8 | 2.03 | 6.36 | 213.6
TOTAL - CUSTOMER TYPE/CLIENT | 16945.8 | 19088 | 12.6 | 3.31 | 11.19 | 237.5 | 598.2 | 673.8 | 12.6 | 2.45 | 7.95 | 224.2
NOTE: | THE AVERAGE PRICE IS THE WEIGHTED |  |  |  |  |  |  | NOTA: | LE PRIX MOYEN EST LE PRIX MOYEN PONDÉRÉ
 | AVERAGE PRICE AT THE INTERNATIONAL BORDER |  |  |  |  |  |  |  | À LA FRONTIÈRE INTERNATIONALE
Spreadsheet: chris_germany__2129__FebCohCHOICE-ENA
Sheet: Feb 7

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-02-07 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | Upstream K# | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 745 |  | 745 |  | 67694 |  |  |  |  |  |  | 35 | 1 | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 2 | 33
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 7278 |  | 7278 |  | 67694 |  |  |  |  |  |  | 36 | 3 | 36
 |  |  |  |  |  |  |  |  | 3000 |  | 3000 |  | 68918 | 103722 | 0 |  |  |  |  | 33 | 4 | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 5 | 37
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 1938 |  | 2060 |  | 67694 |  |  |  |  |  |  | 40 | 6 | 38
 |  |  |  |  |  |  |  |  | 2000 |  | 2000 |  | 68915 | 103722 | 0 |  |  |  |  | 34 | 7 | 33
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 |  | 0 |  |  |  |  | 39 | 8 | 38
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0 |  |  |  |  | 39 | 9 | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 | 15 | 42
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 12175 |  | 12175 |  | 67694 |  |  |  |  |  |  | 37 | 35 | 35
 |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 68917 | 103722 | 0 |  |  |  |  | 33 | 39 | 32
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 771 |  | 771 |  | 67694 |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1571 |  | 1647 |  | 67694 |  |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 68916 | 103722 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 8412 |  | 9602 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 1967 |  | 2178 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 2409 |  | 2523 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 2882 |  | 3163 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 845 |  | 998 |  | 67694
 |  |  |  |  |  |  |  |  | 257 |  | 257 |  | 69708 | 53858 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 53858 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 35 |  | 36 |  | 67694 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20606 | FOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20500 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 46701b0c-f8de-4f76-bc51-32eab6e932e1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
262460 | 74582 | Paige | [NAME] | USA | 718 | 00:20:15 | [NAME] | [NAME] | 00:00:43 | 00:10:10 | 1 | 01:15:26
Spreadsheet: 883626d1732262904-numbering-repetitive-lines-mapping-operation-example-data
Sheet: Sheet1

 |  |  |  |  | Order ID | Order ID | Product | Product+Order | Mapping | Revenue
 |  |  |  |  | Example 1 | 1001 | X |  | 1 | 1000
 |  |  |  |  |  | 1001 | Y |  | 1 | 2000
 |  |  |  |  |  | 1001 | Z |  | 1 | 5000
 |  |  |  |  |  | 1001 | X |  | 2 | 1000
 |  |  |  |  |  | 1001 | Y |  | 2 | 2000
 |  |  |  |  |  | 1001 | Z |  | 2 | 5000
 |  |  |  |  |  | 1001 | X |  | 3 | 1000
 |  |  |  |  |  | 1001 | Y |  | 3 | 2000
 |  |  |  |  |  | 1001 | Z |  | 3 | 5000
 |  |  |  |  | Example 2 | 1002 | A |  | 1 | 40000
 |  |  |  |  |  | 1002 | B |  | 1 | 100000
 |  |  |  |  |  | 1002 | A |  | 2 | 40000
 |  |  |  |  |  | 1002 | B |  | 2 | 100000
Spreadsheet: 686113d1594371319-finding-data-across-multiple-sheets-excelforum__help_file
Sheet: AH_Jan

X
 |  | 1
 |  | 2 | white
 |  | 3 | purple
 |  | 4
 |  | 5 | white
 |  | 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
Spreadsheet: 136883d1326866807-needing-to-find-ways-of-automating-simple-processes-mrc-attendance-sample
Sheet: VisitRecords

VISIT RECORDS
 | Starts: | End: |  | ID | Full Name |  |  |  |  |  | Total ID
Year: | 2010 | 2010 |  | ID0131 |  |  |  |  |  |  | Total hour:
Month: | 4 | 4
Day: | 1 | 26
No | Date | WeekDay | ID | Full name | Time In | Time Out | Time In | Time Out | Time
1
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: B8

Local 8
Nom: | Prestige Nautique
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-03-10 00:00:00
[NAME]: | 80
Réservé:
Prix: | 200
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 138675d1327819728-time-calculation-without-lunch-hour-ciao
Sheet: FoglIo1

 | in | out | working hours | difference | note
 | 07:30:00 | 17:00:00 | 08:30:00 | 09:30:00 | 1 hour lunch time off
 | 08:00:00 | 12:15:00 | 04:00:00 | 04:15:00 | 15 minutes lunch time off
 | 12:15:00 | 17:30:00 | 04:30:00 | 05:15:00 | 45 minutes lunch time off
 | 12:00:00 | 13:00:00 | 1900-01-01 00:00:00 | 01:00:00
 | 12:00:00 | 20:00:00 | 07:00:00 | 08:00:00
 | 13:00:00 | 20:00:00 | 07:00:00 | 07:00:00
 | 12:00:00 | 13:00:00 | 1900-01-01 00:00:00 | 01:00:00
 | 11:45:00 | 13:15:00 | 00:30:00 | 01:30:00 | 1 hour lunch time off
 | 10:00:00 | 12:00:00 | 02:00:00 | 02:00:00
 | 10:00:00 | 12:15:00 | 02:00:00 | 02:15:00
 | 10:00:00 | 13:15:00 | 02:15:00 | 03:15:00
 | 10:00:00 | 12:00:00 | 02:00:00 | 02:00:00
 | 10:00:00 | 12:00:00 | 02:00:00 | 02:00:00
 | 10:00:00 | 12:00:00 | 02:00:00 | 02:00:00
Spreadsheet: 36114d1233866871-vlookup-help-169-8-07-tag
Sheet: DATA ENTRY

Total number of cases: |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  | Paste W/O (E-Mail) info below:
Start Case Numbering at: |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Customer: 65          ABC
[NAME] |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Job No: 86009
[NAME] |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | Job Description: Rental: Various
[NAME] |  | 3 | 3 |  |  |  |  |  |  |  |  |  |  |  |  | Work Order: 196262-1
[NAME] |  | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | Work Order Description: Rental: Panasonic Varicam package
[NAME] |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | Begin: 01/16/2009 3:00 pm : 01/26/2009 10:00 am
[NAME] |  | 6 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | Phase: Updated
[NAME] |  | 7 | 7
[NAME] |  | 8 | 8
[NAME] |  | 9 | 9
[NAME] |  | 10 | 10
[NAME] |  | 11 | 11
[NAME] |  | 12 | 12
[NAME] |  | 13 | 13
[NAME] |  | 14 | 14
[NAME] |  | 15 | 15
[NAME] |  | 16 | 16
[NAME] |  | 17 | 17
[NAME] |  | 18 | 18
[NAME] |  | 19 | 19
[NAME] |  | 20 | 20
[NAME] |  | 21 | 21
[NAME] |  | 22 | 22
[NAME] |  | 23 | 23
[NAME] |  | 24 | 24
[NAME] |  | 25 | 25
[NAME] |  | 26 | 26
[NAME] |  | 27 | 27
[NAME] |  | 28 | 28
[NAME] |  | 29 | 29
[NAME] |  | 30 | 30
[NAME] |  | 31 | 31
[NAME] |  | 32 | 32
[NAME] |  | 33 | 33
[NAME] |  | 34 | 34
[NAME] |  | 35 | 35
[NAME] |  | 36 | 36
[NAME] |  | 37 | 37
Spreadsheet: eric_saibi__9964__110901R
Sheet: Pasadena 2A HRSG

Owner Name |  | Calpine Corporation
Station Name |  | Pasadena 1&2 Power Station
Unit Name |  | Pasadena 2A HRSG
NERC Region |  | ERCOT
State |  | TX
Fuel Type |  | Natural Gas
Capacity |  | 166 MW
Start Date |  | 2002-03-04 00:00:00
End Date |  | 2002-03-17 00:00:00
Prv. Start Date |  | 2001-11-09 00:00:00
Prv. End Date |  | 2001-11-22 00:00:00
Comments |  | Need to Run unit, so work was rescheduled
SIC |  | 4931
Plant ID |  | 1025139
Unit ID |  | 1012768
Outage ID |  | 17649
Spreadsheet: 162976d1340130964-excel-2007-compare-column-and-rearrange-row-data-accordingly-row_matching
Sheet: Sheet1

Col A | Name1 | Amt1 | Amt2 | [NAME]
a1 | [NAME] | 200 | 700 | Karim
aa2 | Ramos | 100 | 500 | [NAME]
a3 | Karim | 700 | 200 | [NAME]
a4 | Fabio | 250 | 150 | Rafael
a5 | [NAME] | 500 | 100 | Ramos
aa6 | Rafael | 20 | 250 | Fabio
Expected o/p
Col A | Name1 | Amt1 | Amt2 | [NAME]
a1 | [NAME] | 200 | 200 | [NAME]
aa2 | Ramos | 100 | 100 | Ramos
a3 | Karim | 700 | 700 | Karim
a4 | Fabio | 250 | 250 | Fabio
a5 | [NAME] | 500 | 500 | [NAME]
aa6 | Rafael | 20 | 250 | Rafael