tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 100888d1299100680-different-from-pivot-table-book1
Sheet: Pivot

Sum of Total Charge | Column Labels
 | 2011 | 2010 |  |  | Grand Total
Row Labels | Jan | Dec | Nov | Oct
Facility A |  |  | -0.4444444444444444 | -0.8
Facility B |  |  | -0.4 | -0.6666666666666666
Facility C |  |  | -0.4166666666666667 | -0.5714285714285714
Facility D |  |  | -0.4285714285714285 | -0.5
Grand Total |  |  | -0.4222222222222222 | -0.6153846153846154
Spreadsheet: 674620d1587955078-how-to-copy-a-row-based-an-input-into-a-specific-cell-and-paste-to-another-sheet-test-log-book
Sheet: Sept 2019

Date | NUMBER | NAME | Age | DOB | sex | Diag | Side | Procedure | MBS | Complication | HOSPITAL | Column1 | Column2 | Column3 | Column4 | Column5
43533 |  |  | 72 |  | F | OA Knee | L | [NAME] |  |  |  | F5 | T4 | I9 | P35
43533 |  |  | 66 |  | M | OA Hip | R | THR |  |  |  | 64 cup | 50 N1 | [NAME] | no sb
43594 |  |  | 58 |  | M | Carpal tunnel syndrome | R | Release
43594 |  |  | 76 |  | F | [NAME] finger | L | Release
43594 |  |  | 73 |  | F | OA CMC joint | L | Trapeziectomy
43594 |  |  | 34 |  | F | Meniscus tear | R | Arthroscopy
43594 |  |  | 75 |  | M | Carpal tunnel syndrome | L | Release
43625 |  |  | 63 |  | M | Cuff tear | L | Cuff repair
43625 |  |  | 68 |  | M | OA Hip | L | THR |  |  |  | 56 cup | N7 127 | -5 | no sb
43625 |  |  | 48 |  | M | OA Hip | L | THR |  |  |  | 54 cup | N8 132 | std cer hd | no sb
10/9/2019 |  |  | 50 |  | M | Cuff tear | L | Cuff repair
10/9/2019 |  |  | 51 |  | F | Olecranon bursa | R | Excision
10/9/2019 |  |  | 70 |  | M | OA Knee | R | [NAME] |  |  |  | F6 | T5 | I9 | P38
43778 |  |  | 56 |  | M | Dupuytrens contracture | R | Fasciectomy
43778 |  |  | 70 |  | M | OA Shoulder | R | TSR Reverse |  |  |  | small [NAME] | 40 GS | 17 stem | short liner
43778 |  |  | 98 |  | F | Fr femur | R | Nail
43778 |  |  | 73 |  | M | OA Shoulder | L | TSR Reverse |  |  |  | small [NAME] | 40 GS | 18  stem | short liner
43808 |  |  | 70 |  | F | [NAME] | L | Arthroscopy
43808 |  |  | 61 |  | M | OA Knee | R | [NAME] |  |  |  | F5 | T5 | I9 | P32
43808 |  |  | 71 |  | F | OA Knee | R | [NAME] |  |  |  | F2 | T1 | I9 | P29
13/9/2019 |  |  | 19 |  | M | Bankart lesion | R | Bankart repair
13/9/2019 |  |  | 71 |  | F | OA Knee | R | [NAME] |  |  |  | F5 | T5 | I9 | P32
13/9/2019 |  |  | 90 |  | M | OA Knee | R | [NAME] |  |  |  | F3 | T3 | I11 | P29
17/9/2019 |  |  | 45 |  | M | Cuff tear | L | Cuff repair
17/9/2019 |  |  | 59 |  | F | OA Knee | R | [NAME] |  |  |  | F4 | T4 | I9 | P32
17/9/2019 |  |  | 64 |  | M | OA Knee | L | [NAME] |  |  |  | F6 | T7 | I9 | P35
20/9/2019 |  |  | 56 |  | M | Dupuytrens contracture | R | Fasciectomy
20/9/2019 |  |  | 74 |  | F | OA Knee | L | [NAME] |  |  |  | F4 | T4 | I9 | P29
20/9/2019 |  |  | 57 |  | M | Meniscus tear | R | Arthroscopy |  |  |  | [NAME]
20/9/2019 |  |  | 31 |  | M | Meniscus tear | R | Arthroscopy |  |  |  | [NAME] MM
20/9/2019 |  |  | 44 |  | F | AC jt OA | R | SAD, Acjt resection
23/9/2019 |  |  | 65 |  | M | Cuff tear | L | Cuff repair
23/9/2019 |  |  | 69 |  | M | Dupuytrens contracture | L | Fasciectomy
23/9/2019 |  |  | 61 |  | M | Carpal tunnel syndrome | R | Release
23/9/2019 |  |  | 53 |  | F | Carpal tunnel syndrome | R | Release
26/9/2019 |  |  | 64 |  | F | OA Hip | L | THR |  |  |  | 50 cup | N3 127 | -5 cer | no sb
26/9/2019 |  |  | 79 |  | F | OA Shoulder | L | TSR Reverse |  |  |  | small [NAME] | 40 GS | 17 stem | medliner
30/9/2019 |  |  | 67 |  | M | Cuff tear | L | Graft |  |  |  | augment
30/9/2019 |  |  | 59 |  | M | OA Knee | L | [NAME] |  |  |  | F8 | T8 | I9 | P38 | PRESSFIT
Spreadsheet: 122139d1316627751-using-vlookup-of-gm-to-calculate-a-price-pricing
Sheet: update

NONE | CIM-16.5X21.5 |  |  | 30.47169811320754 | 0.47 | 16.15
 | CIM-16.5X21.5X1 |  |  | 165.8196721311475 |  | 101.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 165.8196721311475 |  | 101.15
 | CIM-[PHONE] |  |  | 165.8196721311475 |  | 101.15
 | CIM-[PHONE] |  |  | 165.8196721311475 |  | 101.15
 | CIM-[PHONE] |  |  | 165.8196721311475 |  | 101.15
 | CIM-[PHONE] |  |  | 165.8196721311475 |  | 101.15
 | [NAME] |  |  | 165.8196721311475 |  | 101.15
 | 0 | 0.7 | K | Below $.50 then use 70% GP
 | 0.5 | 0.65 | L | if the cost is > 0.50 then use 65%
 | 1 | 0.6 | M | if the cost is > 1.00 then use 60%
 | 5 | 0.55 | N | if the cost is > 5.00 then use 55%
 | 10 | 0.5 | O | if the cost is > 10.00 then use 50%
 | 25 | 0.47 | P | if the cost is > 25.00 then use 47%
 | 50 | 0.45 | Q | if the cost is > 50.00 THEN USE 45% GP
 | 100 | 0.35 | R | if the cost is > 100.00 then use 35% GP
 | 200 | 0.3 | S | if cost is > 200.00 then use 30% GP
 | 500 | 0.27 | T | if the cost is > 500.00 then use 27% GP
Spreadsheet: 145111d1331309400-remove-blocks-of-data-with-conditions-block-test
Sheet: Sheet1

1999-01-01 00:00:00 | data | name | course | time
2000-03-02 00:00:00 | 3 | [NAME] | NEW | 220
2000-03-02 00:00:00 | 5 | Beware | NEW | 220
2000-03-02 00:00:00 | 2 | Days Of Grace | NEW | 220
2000-03-02 00:00:00 | 6 | [NAME] | NEW | 220
2000-03-02 00:00:00 | 10 | Baptismal Rock | NEW | 220
2000-03-02 00:00:00 | 2 | Rain Rain Go Away | NEW | 250
2000-03-02 00:00:00 | 6 | Prideway | NEW | 250
2000-03-02 00:00:00 | 7 | Risky Reef | NEW | 250
2000-03-02 00:00:00 | 5 | [NAME] | NEW | 250
2000-03-02 00:00:00 | 8 | [NAME] | NEW | 250
2000-03-02 00:00:00 | 5 | [NAME] | NEW | 320
2000-03-02 00:00:00 | 7 | Tropical King | NEW | 320
2000-03-02 00:00:00 | 4 | [NAME] | NEW | 320
2000-03-02 00:00:00 | 2 | Found At Last | NEW | 320
2000-03-02 00:00:00 | 7 | Church Farm Flyer | NEW | 350
2000-03-02 00:00:00 | 1 | Bluebell Wood | NEW | 350
2000-03-02 00:00:00 | 2 | Service Star | NEW | 350
2000-03-02 00:00:00 | 3 | [NAME] | NEW | 350
2000-03-02 00:00:00 | 6 | Hill Farm Dancer | NEW | 420
2000-03-02 00:00:00 | 4 | Approachable | NEW | 420
2000-03-02 00:00:00 | 5 | [NAME] | NEW | 450
2000-03-02 00:00:00 | 2 | Alhesn | NEW | 450
2000-03-02 00:00:00 | 4 | Royal Expression | NEW | 450
2000-03-02 00:00:00 | 7 | Maknaas | NEW | 450
2000-03-04 00:00:00 | 6 | Baritone | WOL | 140
2000-03-04 00:00:00 | 1 | College Blue | WOL | 140
2000-03-04 00:00:00 | 3 | Aubrieta | WOL | 140
2000-03-04 00:00:00 | 11 | You Da Man | WOL | 210
2000-03-04 00:00:00 | 9 | Finery | WOL | 210
2000-03-04 00:00:00 | 5 | [NAME] | WOL | 245
2000-03-04 00:00:00 | 2 | [NAME] | WOL | 245
2000-03-04 00:00:00 | 4 | Frilly Front | WOL | 315
2000-03-04 00:00:00 | 7 | Ready To Rock | WOL | 315
2000-03-04 00:00:00 | 6 | Bramble Bear | WOL | 315
2000-03-04 00:00:00 | 3 | Aa-Youknownothing | WOL | 315
2000-03-04 00:00:00 | 4 | [NAME] | WOL | 350
2000-03-04 00:00:00 | 9 | Fusul | WOL | 350
2000-03-04 00:00:00 | 5 | Anemos | WOL | 350
Spreadsheet: lisa_gang__22395__Hanson Scheduling Model_4_17
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-04-17 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 26.76 | 26.628 | 26.736 | 26.832 | 26.508 | 26.304 | 26.676 | 26.772 | 26.916 | 26.892 | 27.132 | 26.7 | 23.232 | 22.176 | 21.816 | 22.152 | 21.912 | 21.408 | 20.76 | 23.124 | 24.288 | 24.156 | 26.076 | 26.136 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 27.51023590669259 | 27.51023590669259 | 27.51023590669259 | 27.51023590669259 | 28.26023590669259 | 28.26023590669259 | 28.46023590669258 | 28.46023590669258 | 28.46023590669258 | 28.46023590669258 | 28.46023590669258 | 28.46023590669258 | 26.93523590669259 | 26.93523590669259 | 27.68523590669259 | 26.80523590669258 | 26.80523590669258 | 26.80523590669258 | 31.48023590669258 | 31.48023590669258 | 32.36023590669259 | 32.36023590669259 | 31.61023590669259 | 31.61023590669259
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
Spreadsheet: 147385d1332776829-daily-simple-interest-daily-simple-interest
Sheet: Simple

Loan Amount |  | 10000 |  |  |  |  | Statement
Annual interest rate % |  | 73 |  | (wow) |  |  | Loan Amount |  |  |  | Current balance
Daily interest rate % |  |  |  |  |  |  | Annual interest rate %
Start date |  | 2012-03-01 00:00:00 |  |  |  |  | Daily interest rate %
Current date |  |  |  |  |  |  | Start date |  |  |  | Total payments made
Days since loan started |  |  |  |  |  |  | Current date
 |  |  |  |  |  |  | Days since loan started
 |  |  |  |  |  |  |  |  |  |  | Additional withdrawals
Date | Beginning Daily Balance | Daily interest |  | Withdrawn | Payment | Current bal
2012-03-01 00:00:00 |  |  |  | 3000 | 1000 |  |  |  |  |  | Total interest charged
2012-03-02 00:00:00 |  |  |  |  | 1000
2012-03-03 00:00:00
2012-03-04 00:00:00 |  |  |  |  |  |  |  | Loan
2012-03-05 00:00:00 |  |  |  |  |  |  |  | Withdrawn
2012-03-06 00:00:00 |  |  |  |  |  |  |  | Interest
2012-03-07 00:00:00 |  |  |  |  |  |  |  | Total
2012-03-08 00:00:00 |  |  |  |  |  |  |  | Less paid
2012-03-09 00:00:00 |  |  |  |  |  |  |  | Current balance
2012-03-10 00:00:00
2012-03-11 00:00:00
2012-03-12 00:00:00
2012-03-13 00:00:00
2012-03-14 00:00:00
2012-03-15 00:00:00
2012-03-16 00:00:00
2012-03-17 00:00:00
2012-03-18 00:00:00
2012-03-19 00:00:00
2012-03-20 00:00:00
2012-03-21 00:00:00
2012-03-22 00:00:00
2012-03-23 00:00:00
2012-03-24 00:00:00
2012-03-25 00:00:00
2012-03-26 00:00:00
Spreadsheet: 120066d1314963533-adding-values-based-on-both-month-and-text-criteria-example
Sheet: April

Category | Date | Description | Credit | Debit | Running Balance
Holiday 2011 | 2011-04-29 00:00:00 | OVERSEAS TRANSACTION FEE |  | -1.25 | 4433.96
Holiday 2011 | 2011-04-29 00:00:00 | CARD PAYMENT TO USCUSTOMS ESTA APPL PMT,14.00 USD, RATE 0.60/Â£ ON 27-04-2011 (INTERNATIONA |  | -8.72 | 4435.21
Salary | 2011-04-28 00:00:00 | BANK GIRO CREDIT REF ICEGRADE LTD, ICEGRADE LTD | 1935.24 |  | 4443.93
Social | 2011-04-26 00:00:00 | CARD PAYMENT TO THE RED LION,50.00 GBP ON 23-04-2011 |  | -50 | 2508.69
Misc | 2011-04-26 00:00:00 | CARD PAYMENT TO BOOTS,WOKING,4.00 GBP ON 23-04-2011 |  | -4 | 2558.69
Misc | 2011-04-26 00:00:00 | CARD PAYMENT TO WAITROSE 181 ON 2011-04-23 |  | -22 | 2562.69
Social | 2011-04-25 00:00:00 | CASH WITHDRAWAL AT BARCLAYS BANK PLC ATM REIGATE, REIGATE, 60.00 GBP, ON 24-04-2011 |  | -60 | 2584.69
Social | 2011-04-23 00:00:00 | CASH WITHDRAWAL AT SANTANDER ATM WOKING, WOKING, 50.00 GBP, ON 23-04-2011 |  | -50 | 2644.69
Income | 2011-04-23 00:00:00 | CHEQUE PAID IN AT WOKING 6 PC | 150 |  | 2694.69
Misc | 2011-04-13 00:00:00 | CARD PAYMENT TO SERENATA FLOWERS L,39.99 GBP ON 11-04-2011 |  | -39.99 | 2544.69
Food | 2011-04-13 00:00:00 | CARD PAYMENT TO W M MORRISONS,10.28 GBP ON 11-04-2011 |  | -10.28 | 2584.68
Food | 2011-04-12 00:00:00 | CARD PAYMENT TO SACAT SAINSBURYS,35.38 GBP ON 09-04-2011 |  | -35.38 | 2594.96
Income | 2011-04-07 00:00:00 | INTEREST PAID AFTER TAX 0.19 DEDUCTED | 0.78 |  | 2630.34
Phone | 2011-04-07 00:00:00 | DIRECT DEBIT PAYMENT TO ORANGE REF 55498282/630564652, MANDATE NO 0002 |  | -24.5 | 2629.56
Clothes | 2011-04-06 00:00:00 | CARD PAYMENT TO HOUSE OF FRASER,175.00 GBP ON 04-04-2011 |  | -175 | 2654.06
Clothes | 2011-04-06 00:00:00 | CARD PAYMENT TO RIVER ISLAND 129,14.99 GBP ON 04-04-2011 |  | -14.99 | 2829.06
Misc | 2011-04-06 00:00:00 | CARD PAYMENT TO CARPARK MACHINE,9.00 GBP ON 04-04-2011 |  | -9 | 2844.05
Petrol | 2011-04-05 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,51.95 GBP ON 02-04-2011 |  | -51.95 | 2853.05
Misc | 2011-04-05 00:00:00 | CARD PAYMENT TO HOMEBASE LTD 050,9.99 GBP ON 02-04-2011 |  | -9.99 | 2905
Social | 2011-04-04 00:00:00 | CASH WITHDRAWAL AT CO-OPERATIVE BANK PLC ATM COOP HIGH ST, H, WOKING, 100.00 GBP, ON 04-04 |  | -100 | 2914.99
Gym | 2011-04-04 00:00:00 | DIRECT DEBIT PAYMENT TO WOKING BC REF 510353, MANDATE NO 0003 |  | -38 | 3014.99
 | 2011-04-04 00:00:00 | CASH WITHDRAWAL AT CO-OPERATIVE BANK PLC ATM COOP HIGH ST, H, WOKING, 200.00 GBP, ON 03-04 |  |  | 3052.99 | 200
Social | 2011-04-02 00:00:00 | CASH WITHDRAWAL AT TESCO PERSONAL FINANCE ATM TESCO GUILDFORD, GUILDFORD, 30.00 GBP, ON 02 |  | -30 | 3252.99
Food | 2011-04-02 00:00:00 | CARD PAYMENT TO SAINSBURY'S S/MKT,7.14 GBP ON 31-03-2011 |  | -7.14 | 3282.99
Rent | 2011-04-01 00:00:00 | REGULAR TRANSFER PAYMENT TO ACCOUNT 090133 29153404, MANDATE NO 1 |  | -100 | 3290.13
Food | 2011-04-01 00:00:00 | CARD PAYMENT TO TESCO STORES SACAT,2.00 GBP ON 30-03-2011 |  | -2 | 3390.13
 |  |  | 2086.02 | -844.19
Spreadsheet: 472439d1469600792-how-to-search-filter-data-by-various-basis-from-other-sheets-syllabus-book
Sheet: CE DEPT

Department | CE | Course Content
Level | 1
Term | 1
Subject | Physics
Subject Code | Phy 101
[NAME] | Structure of Matter
Credit Hour | 3
Contact Hour | 3
Department | CE | Course Content
Level | 1
Term | 1
Subject | Chemistry
Subject Code | Chem 103
[NAME] | Inorganic Quantitative Analysis
Credit Hour | 2
Contact Hour | 2 |  |  |  | Waves and oscillations: differential equation of a simple harmonic oscillator, total energy and average energy, combination of simple harmonic oscillations, Lissajous figures, spring-mass system, calculation of time period of torsional pendulum, damped oscillation, determination of damping co-efficient; forced oscillation, resonance, two-body oscillations, reduced mass, differential equation of a progressive wave, power and intensity of wave motion, stationary wave, group velocity and phase velocity, architectural acoustics, reverberation and Sabine's formula.
Department | CE | Course Content
Level | 1
Term | 2
Subject | Accounting
Subject Code | Acc 105
[NAME] | Principles of Accounting
Credit Hour | 3
Contact Hour | 3
Department | CE | Course Content
Level | 1
Term | 2
Subject | Economics
Subject Code | Eco 107
[NAME] | Engineering Economics
Credit Hour | 2
Contact Hour | 2
Spreadsheet: 842293d1694423187-vlookup-handling-multiple-matches-vlookup-handling-correction
Sheet: Packing List Excel (24)

Order number | Barcode | Quantity |  | Order name | Barcode | Quantity | Price | Helper
41523 | 96433 | 1 |  | 41523 | 96433 | 2 | 15
42431/41523 | 96407 | 1 |  | 41523 | 96433 | 1 | 30
41523 | 96433 | 2 |  | 41523 | 96407 | 1 | 40
41526 | 96433 | 1 |  | 41526 | 96407 | 3 | 20
41526/41655 | 96433 | 1 |  | 41526 | 96433 | 1 | 5
 |  |  |  | 41526 | 96433 | 1 | 10
Spreadsheet: 195129d1353428056-how-to-multiple-vlookup-from-input-sheet-to-output-sheet-vlookup
Sheet: input

Roll-1 | Roll-2 | Roll-3 | Name | Father's Name | Mother's Nmae | Contact |  | Note: | Student "Nur "contains 3 roll number such as (2010-6-1,2011-7-2,2012-8-3)
2010-6-1 | 2011-7-2 | 2012-8-3 | Nur | Razzak | [NAME] | [PHONE] |  |  | if I put 2010-6-1 in Output!A2
2010-6-2 | 2011-7-3 | 2012-8-4 | Sadek | Mojibor | shefa | [PHONE] |  |  | or if I put 2011-7-2 in Output!A2
2010-6-3 | 2011-7-4 | 2012-8-5 | Masum | Altaf | Rabea | [PHONE] |  |  | or if I put 2012-8-3 in Output!A2
 |  |  |  |  |  |  |  |  | so among three roll number what ever I put in output sheet in A2 field
 |  |  |  |  |  |  |  |  | all time I will be getting same output like bellow
 |  |  |  |  |  |  |  |  | output sheet results any of three roll number :
 |  |  |  |  |  |  |  |  | Name | Father's Name | Mother's Nmae | Contact
 |  |  |  |  |  |  |  |  | Nur | Razzak | [NAME] | [PHONE]
Spreadsheet: 132f810e-9e06-4aea-8d48-3ac4b24002fd
Sheet: 1996-97

Table D2
Intercalating Medical Students
Department | Full Time
Anatomy and Developmental Biology | 81
Anthropology | 10
Biochemistry and Molecular Biology | 3
Biology | 6
Human Communication Science | 1
Immunology | 14
Medical Physics | 6
Orthopaedics | 9
Pharmacology | 22
Physiology | 36
Psychology | 30
Surgery | 12
Intercollegiate Course | 2
Total
Spreadsheet: 172271d1344087587-sumif-function-vehicle-overpayment-reclass-arampmeyer-oeldere-
Sheet: August

Date | Payee | Amount | Reclass To: |  | [NAME]
2012-08-01 00:00:00 |  | 4562 | 00708.[PHONE].000.000.00000.0000 |  | Reclass To: | Totaal
2012-08-03 00:00:00 |  | 8500 | 00708.[PHONE].000.160.00000.0000 |  | 00708.[PHONE].000.160.00000.0000 | 8500
2012-08-04 00:00:00 |  | 1000 | 00708.[PHONE].000.000.00000.0000 |  | 00708.[PHONE].000.177.00000.0000 | 2500
2001-08-05 00:00:00 |  | 2500 | 00708.[PHONE].000.177.00000.0000 |  | 00708.[PHONE].000.000.00000.0000 | 5562
 |  |  |  |  | Endtotaal | 16562
Journal Entry:
 |  | -16562 | 00708.[PHONE].000.000.00000.0000
Spreadsheet: hunter_shively__12692__Daily Prices
Sheet: Sheet1

Summary of Central Deals
All Central Deals: 11/20/2001 11:53:34 AM
Product ID | [NAME] | Weighted Average ($/MMBtu) | High Trade ($/MMBtu) | Low Trade ($/MMBtu) | [NAME] (MMBtu/day)
27760 | Consumers Pwr | 2.742357866634306 | 2.8 | 2.73 | 16481
27764 | [NAME] | 2.858992526900059 | 2.92 | 2.81 | 64498
27812 | ANR | 2.659365716470074 | 2.7125 | 2.445 | 36624
27813 | ANR OK | 2.458116098702741 | 2.655 | 2.24 | 100828
27814 | [NAME] | 2.703867544404152 | 2.84 | 2.41 | 91827
27817 | NGPL LA Pool | 2.653614348405497 | 2.7675 | 2.58 | 117811
27818 | NGPL Midcont | 2.393718586848125 | 2.615 | 1.88 | 340940
27822 | NGPL TxOkGCPool | 2.514896067326858 | 2.66 | 2.37 | 63214
27824 | NNG Demarc | 2.547093622757013 | 2.7 | 2.24 | 356110
27826 | PEPL Pool | 2.409310793422187 | 2.655 | 1.96 | 423545
29602 | Dawn | 2.897789032773118 | 2.95 | 2.8 | 192902
29606 | [NAME], TCPL | 2.945 | 2.945 | 2.945 | 4087
32775 | Trunkline ELA | 2.704753166192815 | 2.825 | 2.57 | 46428
32779 | Trunkline WLA | 2.74 | 2.74 | 2.74 | 11341
33427 | Trunkline STX | 2.79 | 2.79 | 2.79 | 6264
35041 | NGPL AmarilloML | 2.606020408163265 | 2.64 | 2.405 | 24500
47095 | NNG Ventura | 2.598874079622897 | 2.71 | 2.415 | 273665
47186 | Harper | 2.645353835855863 | 2.7 | 2.51 | 53782
47636 | NBPL/Ventura | 2.541266631239175 | 2.68 | 2.46 | 50808
Chicago | Chicago City Gates | 2.623658524112342 | 2.84 | 2.12 | 2180315
Chicago City Gates composed of Peoples, NBPL Nicor, NGPL Nicor, and NIPSCO.
Spreadsheet: 60897d1261478645-range-reference-rangereference
Sheet: Sheet1

Stock ticker | Data to sum
 |  |  | 52 | formula using named range, scope of named range is based on position of  "reference" string
 |  |  |  | A30 is the fixed lower limit of the named range in this example, replace by A65536 or other as needed
[NAME] | 1
[NAME] | 2
[NAME] | 3
[NAME] | 4
Co A5 | 5
Co A6 | 6
Co A7 | 7
[NAME] | 8
reference
[NAME] | 3
[NAME] | 4
[NAME] | 5
[NAME] | 6
Co A5 | 7
Co A6 | 8
Co A7 | 9
[NAME] | 10
Spreadsheet: 764407d1642715331-find-start-date-and-end-date-find-start-date-and-end-date
Sheet: Sheet1

Emp Id | Emp Name | Month
1001 | A | 2021-01-01 00:00:00
1001 | A | 2021-02-01 00:00:00
1001 | A | 2021-03-01 00:00:00 |  |  | Output
1001 | A | 2021-04-01 00:00:00 |  |  | Emp Id | Start Month | End Month
1001 | A | 2021-05-01 00:00:00 |  |  | 1001
1001 | A | 2021-06-01 00:00:00 |  |  | 1002
1001 | A | 2021-07-01 00:00:00 |  |  | 1003
1001 | A | 2021-08-01 00:00:00 |  |  | 1004
1002 | B | 2021-01-01 00:00:00
1002 | B | 2021-03-01 00:00:00
1002 | B | 2021-08-01 00:00:00
1002 | B | 2021-09-01 00:00:00
1002 | B | 2021-10-01 00:00:00
1002 | B | 2021-11-01 00:00:00
1003 | C | 2021-09-01 00:00:00
1004 | D | 2021-10-01 00:00:00
1004 | D | 2021-10-01 00:00:00
1004 | D | 2021-11-01 00:00:00
1004 | D | 2021-12-01 00:00:00
Spreadsheet: 221448d1363555362-inventory-problem-inventory2
Sheet: MONTHS

Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Cumulative
Spreadsheet: joe_parks__14752__ITM 02 Positions
Sheet: R10

R10!$A$4:$A$15 | R10!$D$4:$D$15 | Sum =
 | Ref |  | Net
[NAME] | Period | Curve Code | Qty
 | 2001-07-01 00:00:00 | IF-ELPO/PERMIAN
 | 2001-07-01 00:00:00 | IF-ELPO/SJ
 | 2001-07-01 00:00:00 | IF-HEHUB
 | 2001-07-01 00:00:00 | IF-NWPL_ROCKY_M
 | 2001-07-01 00:00:00 | IF-WAHA-TX
 | 2001-07-01 00:00:00 | NGI-MALIN
 | 2001-07-01 00:00:00 | NGI-SOCAL
 | 2001-08-01 00:00:00 | IF-ELPO/PERMAN
 | 2001-08-01 00:00:00 | IF-ELPO/PERMIAN
 | 2001-08-01 00:00:00 | IF-ELPO/SANJUAN
 | 2001-08-01 00:00:00 | IF-ELPO/SJ
 | 2001-08-01 00:00:00 | IF-NWPL_ROCKY_M
Spreadsheet: 748458d1632151763-irr-function-comming-out-as-number-irr-quadratic
Sheet: Sheet1

 |  |  |  |  |  |  |  | NPV "curves"
example 1 | example 2 |  | orig example |  |  |  |  | rate | NPV |  | rate | NPV
-429 | 429 | a | 429 |  |  |  |  | -0.9999 |  |  | 0.191
-1005 | -1005 | b | -1005 |  |  |  |  | -0.99 |  |  | 0.1911
599 | -599 | c | 599 |  |  |  |  | -0.9 |  |  | 0.1912
 |  |  |  |  |  |  |  | -0.8 |  |  | 0.1913
 |  | Excel IRR |  |  |  |  |  | -0.7 |  |  | 0.1914
 |  |  |  |  |  |  |  | -0.6 |  |  | 0.1915
 |  |  |  |  |  |  |  | -0.5 |  |  | 0.1916
Quadratic Solutions |  |  |  |  |  |  |  | -0.4 |  |  | 0.1917
 |  | b^2-4ac |  | so SQRT cannot be computed |  |  |  | -0.2999999999999999 |  |  | 0.1918
 |  | r=(-b+SQRT)/2a-1 |  |  |  |  |  | -0.2 |  |  | 0.1919
 |  | r=(-b-SQRT)/2a-1 |  |  |  |  |  | -0.09999999999999998 |  |  | 0.192
 |  | NPV |  |  |  |  |  | 0 |  |  | 0.1921
 |  |  |  |  |  |  |  | 0.09999999999999998 |  |  | 0.1922
 |  |  |  |  |  |  |  | 0.2000000000000001 |  |  | 0.1923
 |  |  |  |  |  |  |  | 0.3000000000000002 |  |  | 0.1924
 |  |  |  |  |  |  |  | 0.4 |  |  | 0.1925
 |  |  |  |  |  |  |  | 0.5000000000000001 |  |  | 0.1926
 |  |  |  |  |  |  |  | 0.6 |  |  | 0.1927
 |  |  |  |  |  |  |  | 0.7000000000000001 |  |  | 0.1928
 |  |  |  |  |  |  |  | 0.8000000000000002 |  |  | 0.1929
 |  |  |  |  |  |  |  | 0.9 |  |  | 0.193
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1.5
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 2.5
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 3.5
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 4.5
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | 5.5
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6.5
 |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  | 7.5
 |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  | 8.5
 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | 9.5
 |  |  |  |  |  |  |  | 10