tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Canada Trading

 | Canada Trading
 | 2002 Plan
 |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2002 |  | 2002 |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  |  |  | 0
 | Analysts & Associates | 0 |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  | Manager | 120000 | 3
 |  |  |  |  |  |  | Director | 156000 | 2
 | Headcount |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  | VP | 216000 | 1
 | Analyst & Associate Headcount |  |  |  |  |  | CEO | 240000 | 1
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | *  Analysts and Associates are billed through normal payroll for Canada. |  |  |  |  | Other Expense Calculation
ENAOUTTX
ENAINSUR |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
ENASYSDV
ENACORIT
ENACORRN
ENAOTHAL
ENADEPR
Spreadsheet: 863109d1710672251-formula-to-realign-data-example1
Sheet: Sheet1

From this:
Asset | Asset |  | Design | Design | [NAME] | [NAME]
[NAME] | Prop |  | [NAME] | Prop | [NAME] | Prop
[NAME] | [NAME] |  | 2 | 2 | 5 | 5
[NAME] | [NAME] |  | 1 | 2 | 3 | 0
Jeremy |  |  | 3 |  | 6
To This:
Asset | Type | Design | [NAME]
[NAME] | [NAME] | 2 | 5
[NAME] | [NAME] | 1 | 3
Jeremy | [NAME] | 3 | 6
[NAME] | Prop | 2 | 5
[NAME] | Prop | 2 | 0
Spreadsheet: 033d4855-ec7b-4602-8b8c-aaab9c75b6fc
Sheet: 12d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, February 1 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket 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: 176603d1345965199-how-to-categorized-accounts-using-excel-formula-book1
Sheet: Sheet1

 |  | BOOKING | MATURITY | TERM | %RATE P.A.
TD # | BALANCE | DATE | DATE
399.2792087492489 | 409551.2668654919 | 2007-06-16 00:00:00 | 2007-08-17 00:00:00 | 60 | 2.125
488.7794054366168 | 150045.0116418506 | 2007-06-16 00:00:00 | 2007-08-17 00:00:00 | 60 | 2.125
974.4850988026883 | 310580.5929990311 | 2007-06-16 00:00:00 | 2007-08-17 00:00:00 | 60 | 2.125
907.6778492035373 | 701406.0616847929 | 2007-06-16 00:00:00 | 2007-08-17 00:00:00 | 60 | 2.25
877.3702145008428 | 54354.35528761445 | 2007-06-19 00:00:00 | 2007-08-21 00:00:00 | 60 | 2
54.02134766700328 | 275511.7797887578 | 2007-06-19 00:00:00 | 2007-08-21 00:00:00 | 60 | 2.125
473.7531007922371 | 307645.7518172901 | 2007-06-19 00:00:00 | 2007-08-21 00:00:00 | 60 | 2.125
606.2782008448266 | 450284.9631990102 | 2007-06-19 00:00:00 | 2007-08-21 00:00:00 | 60 | 2.125
343.9021295871498 | 856971.1005129648 | 2007-06-19 00:00:00 | 2007-08-21 00:00:00 | 60 | 2.25
262.1386614955554 | 889661.2442295009 | 2007-06-19 00:00:00 | 2007-08-21 00:00:00 | 60 | 2.25
849.0543276693643 | 591358.5387288549 | 2007-06-19 00:00:00 | 2007-08-21 00:00:00 | 60 | 2.25
916.0048431349423 | 922301.4009112376 | 2007-06-19 00:00:00 | 2007-08-21 00:00:00 | 60 | 2.375
804.6307626436828 | 41808.6380659588 | 2007-06-26 00:00:00 | 2007-08-28 00:00:00 | 60 | 1.75
327.6042522729767 | 660297.1596548741 | 2007-06-26 00:00:00 | 2007-08-28 00:00:00 | 60 | 2.25
954.1681513646836 | 943147.7183698007 | 2007-06-26 00:00:00 | 2007-08-28 00:00:00 | 60 | 2.25
646.1940800627417 | 646677.5162671183 | 2007-06-26 00:00:00 | 2007-08-28 00:00:00 | 60 | 2.5
912.2143236036209 | 472516.2328059014 | 2007-06-26 00:00:00 | 2007-08-28 00:00:00 | 60 | 2.5
32.48971441826143 | 136290.3659955919 | 2007-06-13 00:00:00 | 2007-09-14 00:00:00 | 90 | 1.75
197.7388416526082 | 837320.1937783961 | 2007-06-13 00:00:00 | 2007-09-14 00:00:00 | 90 | 2.25
563.304997753221 | 874433.1964371668 | 2007-06-13 00:00:00 | 2007-09-14 00:00:00 | 90 | 2.25
20.68468493234832 | 668113.1296427338 | 2007-06-13 00:00:00 | 2007-09-14 00:00:00 | 90 | 2.25
747.4370637046377 | 222005.7731137786 | 2007-06-16 00:00:00 | 2007-09-18 00:00:00 | 90 | 2.125
Spreadsheet: 6146d89b-bca2-4a4b-b23e-f064d731fcbb
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
CRU | Test | CRU | Chromium, 24 Hour, [NAME] | Chromium, 24 Hr, U | Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine container with no metal cap or glued insert Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. Collect in a clean, plastic urine container with no metal cap or glued insert. 4. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 5. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections. 3. High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours.   Urine Preservative Collection Options Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	No 50% Acetic Acid	No Na2CO3	No Toluene	No 6N HNO3	No Boric Acid	No Thymol	No | 0.4 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-15 years: not established > or =16 years: 0.0-7.9 mcg/specimen | Tuesday through Friday; 8 a.m.-11 a.m. | 1 days | 4 days | 1 | 82495 |  |  |  |  | Rochester
CRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
CRU | Order Question | TM44 | Collection Duration |  | Plain Text
CRU | Order Question | VL42 | [NAME] |  | Plain Text
CRU | Result | 8593 | Chromium, 24 Hr, U | Chromium, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 5624-2 | Chromium:MRat:24H:[NAME]:Qn:
CRU | Result | TM44 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
CRU | Result | VL42 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3167-4 | [NAME] volume:Vol:24H:[NAME]:Qn:
CRU | Result | 45492 | [NAME] | [NAME] | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 21201-9 | Chromium:MCnc:24H:[NAME]:Qn:
Spreadsheet: 59998d1260527182-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-poss-new-budget-planner
Sheet: EDF Energy

EDF Energy | (Gas & Electric)
Month | Year | Paymet
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008
January | 2009
February | 2009
March | 2009 | 130
April | 2009 | 108
May | 2009 | 108
June | 2009 | 108
July | 2009 | 108
August | 2009 | 108
September | 2009 | 108
October | 2009
November | 2009
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 330116d1404551741-place-two-staff-on-each-day-in-order-skipping-blanks-on-call
Sheet: Sheet1

2014-01-12 00:00:00 |  |  | ~
 |  |  | ~
 |  |  | ~
 |  |  | ~
 |  |  | ~
 |  |  | ~
 |  |  | ~
 |  |  | ~
 |  |  | ~
 |  |  | ~
 |  |  | ~
 |  |  | ~
 |  |  | ~
Spreadsheet: 22381d1211208244-while-loop-help-matching
Sheet: Sheet1

john1 | 1 | a | 7 |  |  |  | chris1
chris1 | s | b | 7 |  |  |  | mary
[NAME] | t | f | 7 |  |  |  | john9
[NAME] | f | 4 | 7
mary | 2 | 8 | 7
[NAME] | 3 | 9 | 77
jose | 6 | 1 | 7
john9 | 8 | 6 | 7
[NAME] | q | tt | 7
I need a macro the will read data in columnH (row1 to whenver the data end).  If the data in columnH match with columnA, then write the word Match in column E
For the above data, I should have:
chris1 | s | b | 7 | Match
mary | 2 | 8 | 7 | Match
john9 | 8 | 6 | 7 | Match
Spreadsheet: 220742d1363256373-count-unique-values-in-list-but-not-using-array-formula-0helper
Sheet: Φύλλο2

[NAME] | 0 | 1 | [NAME] | 1
[NAME] | 0 | 2 | [NAME] | 1
[NAME] | 0 | 3 | [NAME] | 1
[NAME] | 0 | 4 | [NAME] | 3
[NAME] | 2 | 7 | Greg | 1
[NAME] | 1 | 8 | [NAME] | 2
Greg | 0 | 10 | [NAME] | 2
[NAME] | 0 | 12
[NAME] | 1 | 13
[NAME] | 0 | 14
[NAME] | 1 | 15
Spreadsheet: 04a75ab4-f092-430b-abce-7499552393aa
Sheet: Sheet1

PRE-REQ. | CERT | BAR | COURSE TITLE | NO | SECT | CREDS | PROFESSOR | DAY/TIME | ROOM | EXAM | TIME
 |  |  | Textbook information (e.g., price, title, ISBN number, etc.) will be available on the internet course schedule located in CampusCruiser under WebAdvisor > Student Services > Search for Sections or Search and Register, etc. > Section Selection Results > Section Information.
Bus Org |  |  | ADVANCED CONCEPTS IN CORP LAW A/K/A SEM: ADV CORPORATIONS | 873 | O | 2 | [NAME] | JULY 7 - 24 / M-TH 9:30-12:00 PM | 126 | 2014-07-24 00:00:00 | 9:30-12:00 PM
 | CR | BAR | EVIDENCE | 836 | O | 4 | NIVALA, PROF. EMERITUS | M W TH 6:10-7:50 PM / T 8:00-9:40 PM | P104 | 2014-07-17 00:00:00 | 6:30-10:30 PM
 |  | DE & PA BAR | FAMILY LAW | 636 | O | 3 | DAILEY-LEWIS | M T 8:00-9:40 PM / TH 6:10-7:50 PM | P302 | 2014-07-23 00:00:00 | 6:30-9:30 PM
 |  | BAR | FEDERAL INCOME TAX | 610 | O | 3 | O'NEILL | M TH 6:10-7:50 PM / T 8:00-9:40 PM | P303 | 2014-07-21 00:00:00 | 6:30-9:30 PM
 |  |  | HEALTH CARE ADMINISTRATION (ON-LINE COURSE) | 6067X | O | 2 | GRENA | MANDATORY ORIENTATION 5/19, 5:30-6:30 PM / ADOBE CHAT SESSIONS: M 5:30-6:30 |  | NO | EXAM
Evidence | TA |  | I.T.A.P. # | 779 | O | 3 | EPSTEIN | MAY 16-23 (ALL DAY) |  | NO | EXAM
Prof. [NAME]., Evid. 2.5  GPA |  |  | JUDICIAL EXTERNSHIP # | 809 | O | 3 | CATANIA | T 4:10-6:00 PM | 273 | NO | EXAM
2.0 req at end of Fall 2013 |  |  | LEGAL METHODS II | 510 | O | 2 | TBA | M 8:00-9:40 PM / W 6:10-7:50 PM | P303 | NO | EXAM
 |  |  | LEGAL METHODS III | 512 | O1 | 2 | TBA | T 6:10-7:50 PM / TH 8:00-9:40 PM | P302 | NO | EXAM
 |  |  | NEGOTIATIONS # | 889 | O | 2 | JOHNSTON | JUNE 7-8, JUNE 21-22, 9:00 AM - 5:00 PM | 247/248 | Group Project | Due 7/22
 |  | BAR | PROFESSIONAL RESPONSIBILITY | 702 | O | 3 | BROWN | M T 6:10-7:50 PM / TH 8:00-9:40 PM | 122 | 2014-07-17 00:00:00 | 6:30-9:30 PM
Prof. [NAME]., Evid. 2.3  GPA |  |  | PUBLIC INTEREST EXTERNSHIPS # | 6005 | O | 3 | HOWE-BARKSDALE | SCHEDULE WITH PROFESSOR |  | NO | EXAM
 |  |  | SEM: BIOETHICS AND THE LAW@ | 839 | O | 1 | GOLDBERG, S. | T 4:20-6:10 PM | MD | NO | EXAM
 | H |  | SEM: PHARMACEUTICAL REGULATIONS @ (ON-LINE COURSE) | 6037X | O | 2 | TERMINI | MANDATORY MEETINGS: JUNE 11 & JULY 16, 2:30-4:00 PM |  | NO | EXAM
 |  |  | WILLS & TRUSTS | 834 | O | 4 | [NAME] | M W TH 6:10-7:50 PM / T 8:00-9:40 PM | P203 | 2014-07-21 00:00:00 | 6:30-10:30 PM
 |  |  | Textbook information (e.g., price, title, ISBN number, etc.) will be available on the internet course schedule located in CampusCruiser under WebAdvisor > Student Services > Search for Sections or Search and Register, etc. > Section Selection Results > Section Information.
Spreadsheet: benjamin_rogers__1230__Florida model with 6 LM6000
Sheet: Cost Details

 |  |  | Combined Cycle
 | Turbines |  | 6
 | MW's |  | 345
 |  |  | (000's)
 | Project Management:
 | Home Office |  | 840.938
 | Salaried Staff |  | 1105.873
 | [NAME] Staff |  | 255.216
 | Indirect Costs:
 | Equipment Costs |  | 741.602
 | Small Tools |  | 296.922
 | Temp Facilities |  | 293.856
 | GC Other |  | 926.821
 | Per Diems |  | 630
 | Tax/Bond |  | 9.45
 | Engineering:
 | Engr. Labor |  | 1717.066
 | Procurement:
 | Major Equipment
 | CTG's |  | 86040
 | CTG Freight |  | 600
 | Inlet air heating |  | 0
 | Duel Fuel |  | 1680
 | [NAME]'s |  | 16800
 | STG - 75 MW |  | 8000
 | Engineered Equipment
 | Buildings |  | 787.5
 | Valves and specials |  | 854.296
 | Bus Duct |  | 460
 | Dry Transformers |  | 24.88
 | Step-up transformers |  | 2872
 | Power Dist. Xformers |  | 1160.044
 | 600V MCC |  | 140.506
 | 600V [NAME] |  | 139.506
 | 5kV swgr |  | 222.761
 | 15kV swgr |  | 1512.058
 | Control Panel |  | 466.6
 | HV Device |  | 66.064
 | DCS |  | 662.025
 | UPS |  | 62.337
 | [NAME]. Mntd [NAME]. |  | 201.556
 | CEMS |  | 0
 | Control Valves |  | 427.5
 | Pumps |  | 1509.248
 | [NAME] |  | 2060.5
 | Fin Fan Coolers |  | 0
 | APC equipment |  | 0
 | Gas Compression |  | 2120
 | Fuel Gas Filter |  | 168
 | Chillers |  | 5571
 | Water Treatment |  | 626.4
 | Oil/Water Seperator |  | 82.35
 | Vender Reps |  | 547.125
 | Tank Farm/Oil Filter |  | 2250
 | FLD/shop vessels |  | 532.5
 | Other |  | 566.544
 | Bulk Material |  | 9107.66
 | Construction
 | site |  | 1113.327
 | u/g electrical |  | 939.472
 | u/g piping |  | 1271.476
 | concrete |  | 2447.188
 | grout |  | 103.705
 | steel |  | 268.83
 | architectual |  | 16.344
 | buildings |  | 315.099
 | a/g piping |  | 3979.895
 | a/g eletrical |  | 2414.858
 | instrumentation |  | 620.356
 | insulation |  | 986.442
 | painting |  | 65.679
 | mech. Equipment |  | 3362.755
 | Startup
 | startup |  | 1107.645
 | oper training |  | 17.5
 | initial fill/spares |  | 191.25
 | manuels |  | 49
 | startup support |  | 165.952
 | Warranty |  | 100
 | Owner Adds
 | sales and Used Tax |  | 0
 | SCR air attemperation |  | 0
 | Remote control |  | 0
 | ENA Remote Monitoring |  | 188.4
 | [NAME] |  | 7500
 | Transmission lines |  | 1500
 | Gas Line |  | 1400
 | [NAME] |  | 600
 | Builders Risk |  | 0
 | Subtotal Costs
 | Fixed G&A |  | 3717.077
 | Total Costs
 | Contingency |  | 3791.419
 | Margin |  | 5687.128
 | Total EPC
Spreadsheet: 49914d1249338508-how-to-average-dynamic-data-for-specific-categoris-from-a-different-worksheet-average-8-3-09
Sheet: Snapshot results I want

Average Days to Process by Category
Category | Jan | Feb |  | IF SOLUTION
Paychecks | 3.666666666666667 | 3.333333333333333 |  | 3.666666666666667 | 3.333333333333333
401K | 5.5 | 3.5 |  | 5.5 | 3.5
COBRA | 5 | 3.5 |  | 5 | 3.5
Average Days to Process by Agent
[NAME] | 5.5 | 4 |  | 5.5 | 4
[NAME] | 5 | 3.333333333333333 |  | 4 | 2.333333333333333
Yolanda | 4.333333333333333 | 3.5 |  | 4.333333333333333 | 4.5
Spreadsheet: 122114d1316618456-sumifs-with-multiple-criterias-row-colums-test-excel-simple-jvs
Sheet: Acc rec

 |  |  |  |  | 1 ste (ok) |  | TEST conso |  | Test SUMIF | Test SUMIF
 |  |  |  |  | ex : CIE_2 |  | CIE_1 + CIE_2 |  | CIE_2 | CIE_1 + CIE_2
 |  |  |  |  |  |  | AND 4110000+48612000 |  |  | AND 4110000+48612000
 |  | Interest |  |  | 0
 |  | Profit share |  |  | -51633 |  | #N/A |  | -51633 | #N/A
 |  | Prepayments
 |  | Others |  |  | 0
 |  | Total accounts receivable |  |  | -51633
 |  | Total prepaid expenses |  |  | 0
Spreadsheet: bill_williams_iii__1399__xxxdealenterySeptember
Sheet: 9-7

Friday
Deal #s | 764820 |  | 764825 | 764828 | 764830 | 764832 | 764833
2001-09-07 00:00:00 |  |  | NP | SP | SP | Palo Verde | 4 Corners
Delivery Pt. | EPMI CA Pool |  | Sale | EES | EES | STSW | STCA
Counterparty | NP | SP | EES | Sale | Buy | CISO_EPMI_5000 | EPMI_CISO_7001
Totals | -6072 | 6072 | -4096 | -1000 | 4448 | -800 | 400
1 | -111 | 111 | -262 | -125 |  |  | 50
2 | -111 | 111 | -262 | -125 |  |  | 50
3 | -111 | 111 | -262 | -125 |  |  | 50
4 | -111 | 111 | -262 | -125 |  |  | 50
5 | -111 | 111 | -262 | -125 |  |  | 50
6 | -111 | 111 | -262 | -125 |  |  | 50
7 | -324 | 324 | -125 |  | 278 | -50
8 | -324 | 324 | -125 |  | 278 | -50
9 | -324 | 324 | -125 |  | 278 | -50
10 | -324 | 324 | -125 |  | 278 | -50
11 | -324 | 324 | -125 |  | 278 | -50
12 | -324 | 324 | -125 |  | 278 | -50
13 | -324 | 324 | -125 |  | 278 | -50
14 | -324 | 324 | -125 |  | 278 | -50
15 | -324 | 324 | -125 |  | 278 | -50
16 | -324 | 324 | -125 |  | 278 | -50
17 | -324 | 324 | -125 |  | 278 | -50
18 | -324 | 324 | -125 |  | 278 | -50
19 | -324 | 324 | -125 |  | 278 | -50
20 | -324 | 324 | -125 |  | 278 | -50
21 | -324 | 324 | -125 |  | 278 | -50
22 | -324 | 324 | -125 |  | 278 | -50
23 | -111 | 111 | -262 | -125 |  |  | 50
24 | -111 | 111 | -262 | -125 |  |  | 50
TIE POINTS
Spreadsheet: 702585d1604421565-index-match-multiple-criteria-sorting-issue-wip1
Sheet: Customers

Input Data |  |  |  | Resulting Data
Service | Term | Carrier | Column1 | Units Returned
A | 1 | 1
B | 6 | 3
B | 6 | 5
C | 1 | 2
C | 3 | 2
C | 3 | 2
C | 3 | 5
C | 3 | 5
C | 3 | 5
C | 3 | 2
C | 3 | 5
C | 3 | 2
C | 3 | 5
C | 3 | 2
C | 3 | 2
C | 12 | 5
C | 12 | 2
Spreadsheet: 684376d1593337055-separating-total-business-hours-from-one-period-into-multiple-days-ef-workbook-sample
Sheet: Sheet1

 | Table 1 | Duration in [h]:mm
 | Vehicle | 2020-01-01 00:00:00 | 2020-01-02 00:00:00 | 2020-01-03 00:00:00
 | ABC123 | 02:34:00 | 04:31:00 | 03:52:00
 | DEC567 | 04:31:00 | 02:34:00 | 03:52:00
 | Table 2
 | Vehicle | Arrival Date/Time | Departure Date/Time | Business Hour Duration
 | ABC123 | 2020-01-17 08:33:00 | 2020-01-20 17:24:00
 | DEC567 | 2020-01-17 11:33:00 | 2020-01-18 13:33:00
 | Table 3
 | Vehicle | Date | Business Hour Duration
 | ABC123 | 2020-01-17 00:00:00
 | ABC123 | 2020-01-18 00:00:00
 | ABC123 | 2020-01-19 00:00:00
 | ABC123 | 2020-01-20 00:00:00
Spreadsheet: 96326d1295726085-averaging-calculation-for-excel-2003-can-i-combine-sick-days-to-worksheet-2011-tech-attendance
Sheet: TOTAL 

Last Name | First Name | Tech ID | Unpaid | Vacation | Personal | Bereavement | Sick
Ashcraft | [NAME]
Badreddine | Yabi | 897884
Ciran | [NAME] | 897124
Cory | [NAME] | 574517
Ditore | [NAME] | 823088
Garvey | [NAME] | 3897
Guzman | Saul | 918615
Heineman | Russ | 737502
Holland | Scott | 801597
Mendez | Hector | 10538
Pula | Elvis | 684779
[NAME] | [NAME]
[NAME] | [NAME] | 449397
Simmons | Gene
Valle | [NAME] | 706481
[NAME] | [NAME] | 506097
Waitekus | [NAME] | 613091
Spreadsheet: 769251d1645436956-look-up-matrix-lookup-matrix-example-etaf-p1-p10
Sheet: Sheet1

 |  |  |  |  |  |  |  | X | x | x | x | x
STORE ID | POSTER SPACES | POSTER NUMBER | NUMBER TO RECEIVE |  |  |  | POSTER NUMBER | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | P13 | P14
A | 20 | P1 |  |  |  |  | FOR HLOOKUP | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
A | 20 | P2 |  |  |  |  | 1
A | 20 | P3 |  |  |  |  | 2
A | 20 | P4 |  |  |  |  | 3
A | 20 | P5 |  |  |  |  | 4
A | 20 | P6 |  |  |  |  | 5
A | 20 | P7 |  |  |  |  | 6
A | 20 | P8 |  |  |  |  | 7
A | 20 | P9 |  |  |  |  | 8
A | 20 | P10 |  |  |  |  | 9
B | 5 | P1 |  |  |  |  | 10
B | 5 | P2 |  |  |  |  | 11
B | 5 | P3 |  |  |  |  | 12
B | 5 | P4 |  |  |  |  | 13
B | 5 | P5 |  |  |  |  | 14
B | 5 | P6 |  |  |  |  | 15
B | 5 | P7 |  |  |  |  | 16
B | 5 | P8 |  |  |  |  | 17
B | 5 | P9 |  |  |  |  | 18
B | 5 | P10 |  |  |  |  | 19
C | 7 | P1 |  |  |  |  | 20
C | 7 | P2 |  |  |  |  | 21
C | 7 | P3 |  |  |  |  | 22
C | 7 | P4 |  |  |  |  | 23
C | 7 | P5 |  |  |  |  | 24
C | 7 | P6 |  |  |  |  | 25
C | 7 | P7 |  |  |  |  | 26
C | 7 | P8 |  |  |  |  | 27
C | 7 | P9 |  |  |  |  | 28
C | 7 | P10 |  |  |  |  | 29
D | 12 | P1 |  |  |  |  | 30
D | 12 | P2 |  |  |  |  | 31
D | 12 | P3 |  |  |  |  | 32
D | 12 | P4 |  |  |  |  | 33
D | 12 | P5 |  |  |  |  | 34
D | 12 | P6 |  |  |  |  | 35
D | 12 | P7 |  |  |  |  | 36
D | 12 | P8 |  |  |  |  | 37
D | 12 | P9 |  |  |  |  | 38
D | 12 | P10 |  |  |  |  | 39
 |  |  |  |  |  |  | 40
 |  |  |  |  |  |  | 41
 |  |  |  |  |  |  | 42
 |  |  |  |  |  |  | 43
 |  |  |  |  |  |  | 44
 |  |  |  |  |  |  | 45
 |  |  |  |  |  |  | 46
 |  |  |  |  |  |  | 47
 |  |  |  |  |  |  | 48
 |  |  |  |  |  |  | 49
 |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100
Spreadsheet: 745775d1630187041-how-to-calculate-date-of-birth-by-total-number-of-years-months-days-calculate-date-of-birth-by-total-number-of-years-months-days
Sheet: Sheet1

Date of birth | age in | 2020-10-01 00:00:00
 | Days | Months | Years
2011-09-05 00:00:00
2011-07-25 00:00:00
2011-09-04 00:00:00
2011-03-01 00:00:00
2011-07-05 00:00:00
2011-02-08 00:00:00
2011-01-01 00:00:00
2011-08-21 00:00:00
2010-11-20 00:00:00
2011-01-01 00:00:00
2011-02-27 00:00:00
2011-08-16 00:00:00
2011-03-10 00:00:00
2011-09-01 00:00:00
2011-09-01 00:00:00
2011-03-12 00:00:00
2011-01-01 00:00:00
2011-01-01 00:00:00
2010-10-02 00:00:00
2011-01-20 00:00:00
2011-01-20 00:00:00
2011-07-07 00:00:00
2011-01-01 00:00:00
2010-11-01 00:00:00
2011-06-20 00:00:00
2011-01-01 00:00:00
2010-10-10 00:00:00
2010-11-10 00:00:00
2011-04-02 00:00:00
2010-10-20 00:00:00
2011-05-25 00:00:00
2011-09-20 00:00:00
Spreadsheet: 763134d1642005401-start-array-based-on-matching-criteria-example
Sheet: SKU Fortcast

 | SKU Number | Fcst-Mth 1 ($) | Fcst-Mth 2 ($) | Fcst-Mth 3 ($) | Fcst-Mth 4 ($) | Fcst-Mth 5 ($) | Fcst-Mth 6 ($) | Fcst-Mth 7 ($) | Fcst-Mth 8 ($) | Fcst-Mth 9 ($0 | Fcst-Mth 10 ($) | Fcst-Mth 11 ($) | Fcst-Mth 12 ($)
 | 120 | 1900 | 1900 | 1900 | 1900 | 3800 | 3800 | 3800 | 3800 | 3800 | 3800 | 3800 | 3800
 | 121 | 2125 | 2125 | 2550 | 2550 | 2550 | 2550 | 2550 | 2550 | 2550 | 2550 | 2550 | 2550
 | 122 | 2000 | 2000 | 3000 | 3000 | 3000 | 3000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000
 | 123 | 2000 | 2000 | 4000 | 4000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000
 | 124 | 2000 | 2000 | 2000 | 2000 | 2000 | 5000 | 5000 | 6000 | 6000 | 6000 | 6000 | 6000
 | 125 | 1100 | 1100 | 1100 | 3300 | 3300 | 3300 | 3300 | 4400 | 4400 | 4400 | 4400 | 4400
 | 126 | 1400 | 1400 | 1400 | 2800 | 2800 | 2800 | 2800 | 2800 | 4200 | 4200 | 4200 | 4200