tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: stacey_white__39185__east and west dpr
Sheet: west all commodities

ENRON POWER TRADING & TRANSMISSION
DAILY POSITION STATEMENT
DATE: | 2001-11-30 00:00:00
 |  |  |  | NET WEST |  | NET WEST |  | TOTAL
FINAL |  |  |  | TRADING |  | TRADING |  | WEST TRADING
 |  |  |  | Power Only |  | Gas Only |  | All commodities
LTD Through: |  | 2001-10-31 00:00:00
 | [NAME] (Mid) |  |  | 778986412 |  | -7407177
 | Prudent Reserve |  |  | 0 |  | 0
 | Liquidated |  |  | 775884262.4 |  | 96716696.4
 | LTD Net Recognized P&L
MTD Through: |  |  | 2001-11-30 00:00:00
 | Originated Transactions /Credit Reserve |  |  | 0 |  | 0
 | Hedge management
 |  | New Deals |  | 3478891 |  | -1121434
 |  | Change in Price |  | 59156473 |  | -1536108
 |  | Change in Basis Price |  | 0 |  | 0
 |  | GenCo Actuals |  | 0 |  | 0
 |  | Gamma |  | -496074 |  | 0
 |  | Vega |  | -23363 |  | 0
 |  | Theta |  | 214351 |  | 0
 |  | Drift |  | 0 |  | 0
 |  | Change in Interest Rates |  | 0 |  | 0
 |  | Broker Fees: |  | -196672 |  | 0
 | Adjustments |  |  | 178496 |  | 0
 | Total Hedge Management
 | Change in Price prudence |  |  | 0 |  | 0
 | Financial Liquid. True up |  |  | -4208.5 |  | 0
 | Reconciliation Book to Actual Liquid. |  |  | 389712 |  | -256
 | Other |  |  | 46512 |  | -1513
MTD Income (Loss)
MTD Liquidations |  | Financial |  | #REF! |  | #REF!
 |  | Book |  | #REF! |  | #REF!
Total MTD Liquidations |  |  |  | #REF! |  | #REF!
LTD Through: |  |  | 2001-11-30 00:00:00
 | [NAME] (Mid) |  |  | 838205392 |  | -8974581.5
 | Prudent Reserve |  |  | 0 |  | 0
 | Liquidated ** |  |  | 779409400 |  | 95624789
 | Net Recognized P&L
YTD Through: |  |  | 2001-11-30 00:00:00
 | Originated Transactions/Credit Reserve |  |  | 63890120 |  | -37230
 | [NAME] (Mid) |  |  | 637815621 |  | -11901577
 | Prudent Reserve |  |  | 0 |  | 0
 | Liquidated |  |  | 229958736 |  | 187992.5
 | Net Recognized P&L
 |  |  |  | 0 |  | \
Daily Change in P&L- Explanations
 | Originated Transactions/Credit Reserve |  |  | 0 |  | 0
 | Hedge management
 |  | New Deals |  | -96645 |  | 0
 |  | Change in Price |  | 9915845 |  | -362403
 |  | Change in Basis Price |  | 0 |  | 0
 |  | GenCo Actuals |  | 0 |  | 0
 |  | Gamma |  | 7460 |  | 0
 |  | Vega |  | -1736 |  | 0
 |  | Theta |  | 15567 |  | 0
 |  | Drift |  | 0 |  | 0
 |  | Change in Interest Rates |  | 0 |  | 0
 |  | Broker Fees: |  | 6876 |  | 0
 | Adjustments |  |  | 178496 |  | 0
 | Total Hedge Management
 | Change in Price prudence |  |  | 0 |  | 0
 | Financial Liquid. True up |  |  | 3125.4 |  | 0
 | Reconciliation Book to Actual Liquid. |  |  | 103952.4 |  | 1
 | Other |  |  | 41127 |  | -73
Daily Change in Income (Loss)
Daily Liquidations
 | Financial |  |  | -1546322.313621033 |  | -3107017.640619876 |  | -5964919.732157576
 | Book |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Daily Liquidations |  |  |  | -49569573.87420149 |  | -111423966.3602661 |  | -222241453.6401055
Spreadsheet: 168870d1342617879-extracting-data-from-dynamic-register-using-sumifs-on-dates-and-categories-sumifs
Sheet: Sheet1

 |  |  |  |  |  |  | cat3
Date | Category | amount |  |  |  |  | 2012-03-01 00:00:00
2012-03-05 00:00:00 | cat1 | 7.5
2012-03-22 00:00:00 | cat1 | 18.95 |  |  |  | =SUMIFS(C8:C20,B8:B20,h6,month(A8:A20),month(H7))
2012-03-28 00:00:00 | cat3 | 27.65 |  |  |  | This is the lates permutation of the SUMIFS I have tried.
2012-04-15 00:00:00 | cat4 | 42.9
2012-04-26 00:00:00 | cat2 | 25
2012-04-30 00:00:00 | cat2 | 129.5
2012-05-10 00:00:00 | cat1 | 93.2
2012-05-11 00:00:00 | cat2 | 41.07
2012-05-11 00:00:00 | cat4 | 6.35
2012-05-25 00:00:00 | cat3 | 7.15
2012-06-18 00:00:00 | cat3 | 16
2012-06-19 00:00:00 | cat1 | 27
2012-06-20 00:00:00 | cat4 | 84
Spreadsheet: 536917d1504747959-extract-the-value-of-about-30-different-cell-references-out-of-420-closed-workbooks-db-example
Sheet: Sheet1

 |  |  |  | <--Is this the way the table is in each file?
 |  |  |  |  | And you want it to look like this? ([NAME] the second lie)
Emp Name: | [NAME] | Qualification: | Bachelor |  | Emp ID: | Emp Name: | Position | Effective from date: | Qualification: | Pay rate: | Monday Start Time | Tuesday Start Time | Wednesday Start Time | Thursday Start Time | Friday Start Time | Monday End Time | Tuesday End Time | Wednesday End Time | Thursday End Time | Friday End Time
Emp ID: | 1000 | Pay rate: | 30 |  | B5 | B4 | B6 | B7 | D4 | D5 | B11 | B12 | B13 | B14 | B15 | C11 | C12 | C13 | C14 | C15
Position: | Example position
Effective from date: | 2017-01-02 00:00:00
 |  |  |  |  | What about Roster time?  Do you want to add it as well?
Session time | Start time | End time
Monday | 10:00:00 | 13:00:00
Tuesday | 09:00:00 | 11:00:00
Wednesday
Thursday | 14:00:00 | 18:00:00
Friday | 09:00:00 | 15:00:00
Roster | Start time | End time
Monday | 09:00:00 | 14:00:00
Tuesday | 08:00:00 | 11:00:00
Wednesday
Thursday | 13:00:00 | 18:00:00
Friday | 07:00:00 | 16:00:00
Spreadsheet: 114828d1310538047-how-can-i-make-a-word-represent-a-time-schedule
Sheet: Sheet1

 |  | Name |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday |  |  | Sunday
 |  | Debb |  | 09:00:00 | 12:00:00 |  | 09:00:00 | 12:00:00 |  | 09:00:00 | CLOSE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:30:00
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: 776143d1649525545-extract-selected-rows-as-per-specific-value-in-adjacent-cell-extract-only-seleted-stocks
Sheet: Extracted

3P | STOCK w.r.t. |  | SECTOR w.r.t. |  | NIFTY w.r.t. |  | Industry | Main Sector | Del BO | Del% BO
 | Weekly | Monthly | Weekly | Monthly | Weekly | Monthly |  |  |  |  |  | In A3:A9 - I want only those stocks from sheet 2 where 3P is mentioned in column H of sheet 2
INDUSINDBK | W-H | M-H | W-H | M-H | W-H | M-H | FINANCIAL SERVICES | NIFTY PRIVATE BANK | 0.8792574426862183 | 1.15622161671208
 |  |  |  |  |  |  |  |  |  |  |  | In A13:A20 - I want only those stocks from sheet 2 where VDP is mentioned in column I of sheet 2
 |  |  |  |  |  |  |  |  |  |  |  | In A24:A31 - I want only those stocks from sheet 2 where XTRA is mentioned in column J of sheet 2
 |  |  |  |  |  |  |  |  |  |  |  | Once these stocks will get extracted, I also want their adjucent cells data from sheet2 as per headers mentioned in Sheet Extracted, Like example given for INDUSINDBK in Cell A3 in this sheet
VDP
XTRA
Spreadsheet: d29307d2-763d-42f8-bbb2-9e5565fa3638
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
JAK2B | Test | JAK2B | JAK2 V617F Mutation Detection, Blood | JAK2 V617F Mutation Detection, B | Point Mutation Detection in DNA Using Quantitative Polymerase Chain Reaction (PCR) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Lavendar-top (EDTA) Tube: EDTA (<1 month old infant) |  |  | 4 | mL | [NAME] must arrive within 96 hours of draw.   Container/Tube: Preferred: Lavender top (EDTA) Acceptable: ACD [NAME]: 4 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms:  1. Hematopathology Patient Information Sheet (Supply T676) in Special Instructions 2. If not ordering electronically, please submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday; 12 p.m. | 2 days | 5 days | 1 | 81270 |  |  |  |  | Rochester
JAK2B | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient | 4 days
JAK2B | Result | 29590 | JAK2 V617F Mutation Detection, B | JAK2 V617F Mutation Detection, B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43399-5 | JAK2 gene.p.V617F:Arb:Pt:Bld/Tiss:[NAME]:Molgen
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Robert Wagner

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
I'd like to explain my position
Explain your fair share position, if you choose.
The ends do not justify the means.  It is unconstitutional, for the State to use compulsion, even in a just cause.  We have to find a better
way. We can start by downsizing Vermont's huge educational bureaucracy that adds no value and foces teachers to waste their time on
"standards" rather than teaching in the classroom. My tax reform plan at http://ProsperVermont.com would result in more funding available
to pay teachers the good salary that they have earned, rather than whittle away at their benefits.  That in turn would lower the union's cost
and make it more affordable to teachers who can barely scrape by, to join the union voluntarily.  Honey, rather than vinegar.
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | [NAME], Ripton VT 05766 | Senator, Addison | No
Spreadsheet: 844430d1696217001-how-to-group-date-in-slicer-slicer_groupdate
Sheet: Sheet1

Received | Status
2023-05-18 00:00:00 | Cancelled
2023-05-17 00:00:00 | Quoted
2023-05-17 00:00:00 | Confirm
2023-05-16 00:00:00 | Confirm
2023-05-22 00:00:00 | Cancelled
2023-05-29 00:00:00 | Confirm
2023-05-29 00:00:00 | Confirm
2023-06-06 00:00:00 | Cancelled
2023-06-09 00:00:00 | Cancelled
2023-06-09 00:00:00 | Cancelled
2023-06-09 00:00:00 | Cancelled
2023-06-14 00:00:00 | Quoted
2023-06-16 00:00:00 | Confirm
2023-06-16 00:00:00 | Quoted
2023-06-21 00:00:00 | Cancelled
2023-06-21 00:00:00 | Cancelled
2023-06-27 00:00:00 | Cancelled
2023-06-27 00:00:00 | Cancelled
2023-06-30 00:00:00 | Cancelled
2023-07-03 00:00:00 | Confirm
2023-07-03 00:00:00 | Cancelled
2023-07-04 00:00:00 | Cancelled
2023-07-07 00:00:00 | Quoted
2023-07-11 00:00:00 | Cancelled
2023-05-18 00:00:00 | Cancelled
2023-05-17 00:00:00 | Quoted
2023-07-22 00:00:00 | Cancelled
2023-07-25 00:00:00 | Confirm
2023-07-26 00:00:00 | Quoted
2023-08-02 00:00:00 | Cancelled
2023-08-07 00:00:00 | Cancelled
2023-08-10 00:00:00 | Confirm
2023-08-12 00:00:00 | Quoted
2023-08-31 00:00:00 | Confirm
2023-08-23 00:00:00 | Quoted
2023-08-23 00:00:00 | Quoted
2023-08-25 00:00:00 | Cancelled
2023-08-28 00:00:00 | Quoted
2023-08-30 00:00:00 | Quoted
2023-09-04 00:00:00 | Quoted
2023-09-04 00:00:00 | Quoted
2023-09-11 00:00:00 | Confirm
2023-09-12 00:00:00 | Confirm
2023-09-13 00:00:00 | Quoted
2023-09-21 00:00:00 | Quoted
2023-09-22 00:00:00 | Quoted
2023-09-26 00:00:00 | Quoted
2023-09-26 00:00:00 | Quoted
Spreadsheet: 768184d1644871463-creating-a-dynamic-list-that-pulls-from-one-tab-to-another-based-on-a-criteria-cohort-tracking-consolidated
Sheet: Master Class list

Full Name | Level | UEN | Country | District | First Name | Last Name | Position | [NAME] | Status | Withdrawal Reson | Withdrawal Module
[NAME] | 100 | 1234 | CAN | Atlantic Canada | [NAME] | Test | Test 1 | [EMAIL] | Withdrawn | No longer PCL | Mod 1
Emily Tester | 100 | 2345 | CAN | Regina | Emily | Tester | Test 2 | [EMAIL] | Active
[NAME] Testing | 200 | 3456 | CAN | Seattle | [NAME] | Testing | Test 3 | [EMAIL] | Hold
[NAME] | 200 | 4567 | CAN | Calgary | Erin | Tested | Test 4 | [EMAIL] | Extension
Spreadsheet: 73680d1274291658-excel-2007-automated-copying-from-worksheet-to-worksheet-based-off-text-example-for-macro-help2
Sheet: Ralph

City | Travel date | Person going | Cost | Paid/Not Paid
Grand Island | 2009-05-08 00:00:00 | [NAME] | 110.32 | PAID
Kearney | 2009-05-30 00:00:00 | [NAME] | 200.99 | PAID
Kearney | 2009-06-06 00:00:00 | [NAME] | 230.25 | PAID
Lincoln | 2009-11-05 00:00:00 | [NAME] | 265 | PAID
North Platte | 2009-10-09 00:00:00 | [NAME] | 265.32 | PAID
Omaha | 2009-07-01 00:00:00 | [NAME] | 110.1 | PAID
Spreadsheet: 145746d1331728362-how-can-i-solve-conditional-formatting-problem-0800
Sheet: Sheet1

SN | Name | Gender | Father's Name | [NAME] | Address
1 | [NAME] | M | [NAME] |  | Kathmandu
2 | Binita Shrestha | F | [NAME] | Hari Shrestha | Kathmandu
3 | Nina Panta | M | [NAME] | Kishor Panta | Pokhara
I want to mark error in Husband Name in red color because in gender column mistakely filled Male (M).
Spreadsheet: 267563d1380112389-rank-function-tie-break-rankalpabetontie
Sheet: Sheet3

Barton | 1
[NAME] | 1
[NAME] | 10
Diego | 2
Lucas | 2
Alvin | 9
Hipolito | 9
Renato | 3
[NAME] | 9
Tanner | 1
[NAME] | 3
[NAME] | 6
Brain | 3
Dino | 6
[NAME] | 9
Darell | 1
Roosevelt | 1
[NAME] | 1
[NAME] | 7
[NAME] | 6
Spreadsheet: 42638d1241177218-grabbing-data-from-a-cell-on-another-worksheet-if-my_workbook
Sheet: Day 1

Holding | Sort | Security | Price
10000 | 1 | UNITED KINGDOM(GOVERNMENT OF) 4% STK 07/03/2009 GBP100 | 200
2000 | 2 | ELECTRIC & GENERAL INV TST PLC ORD GBP0.05 | 150
350 | 3 | MONKS INVESTMENT TRUST ORD GBP0.05 | 90
4000 | 6 | Pearson PLC | 500
Spreadsheet: 153130d1335782518-rounding-up-book2
Sheet: Sheet1

 |  |  | with 0.05 |  | with 0.005
0.71
0.72
0.73
0.74
0.75
0.76
0.77
Spreadsheet: 855087d1704790761-added-week-numbers-into-cell-but-get-the-value-error-contract-register
Sheet: Job Count Ref Sheet

Count of Job No. | Customer
Job No. | BALMORAL TANKS LTD | N/A | PERMASTORE LTD | (blank) | Grand Total
J90518 |  |  | 1 |  | 1
J90581 |  |  | 1 |  | 1
[NAME] | 1 |  |  |  | 1
J90678 | 1 |  |  |  | 1
[NAME] | 2 |  |  |  | 2
J90732 |  |  | 2 |  | 2
J90735 |  |  | 1 |  | 1
J90742 | 1 |  |  |  | 1
[NAME] |  |  | 3 |  | 3
[NAME] | 1 |  |  |  | 1
J90758 |  |  | 1 |  | 1
J90759 |  |  | 1 |  | 1
[NAME] |  |  | 6 |  | 6
J90762 | 1 |  |  |  | 1
J90763 | 2 |  |  |  | 2
J90769 |  |  | 1 |  | 1
J90775 |  |  | 1 |  | 1
J90780 | 1 |  |  |  | 1
J90784 | 1 |  |  |  | 1
J90793 | 3 |  |  |  | 3
J90800 | 1 |  |  |  | 1
J90801 |  |  | 1 |  | 1
J90805 |  |  | 1 |  | 1
J90806 |  |  | 1 |  | 1
J90808 | 1 |  |  |  | 1
J90809 | 1 |  |  |  | 1
J90810 | 1 |  |  |  | 1
J90811 | 1 |  |  |  | 1
J90812 |  |  | 1 |  | 1
J90822 | 1 |  |  |  | 1
J90824 | 1 |  |  |  | 1
J90828 | 3 |  |  |  | 3
J90837 |  |  | 3 |  | 3
J90838 | 2 |  |  |  | 2
J90840 |  |  | 1 |  | 1
[NAME] |  |  | 1 |  | 1
J90855 | 1 |  |  |  | 1
J90857 | 2 |  |  |  | 2
J90859 | 1 |  |  |  | 1
J90861 |  |  | 2 |  | 2
J90868 |  |  | 3 |  | 3
[NAME] |  |  | 1 |  | 1
[NAME] |  |  | 1 |  | 1
J90881 |  |  | 1 |  | 1
J90883 |  |  | 3 |  | 3
J90888 |  |  | 1 |  | 1
J90889 |  |  | 1 |  | 1
[NAME] | 1 |  |  |  | 1
N/A |  | 1 |  |  | 1
(blank)
J90893 |  |  | 1 |  | 1
J90894 |  |  | 1 |  | 1
J90897 |  |  | 1 |  | 1
[NAME] |  |  | 2 |  | 2
J90899 |  |  | 1 |  | 1
J90905 | 1 |  |  |  | 1
J90907 | 1 |  |  |  | 1
J90918 |  |  | 4 |  | 4
J90942 |  |  | 1 |  | 1
J90943 |  |  | 1 |  | 1
J90957 |  |  | 2 |  | 2
J90958 |  |  | 1 |  | 1
J90960 | 1 |  |  |  | 1
J90971 | 1 |  |  |  | 1
[NAME] | 4 |  |  |  | 4
[NAME] |  |  | 1 |  | 1
J90980 | 1 |  |  |  | 1
J91000 |  |  | 2 |  | 2
[NAME] |  |  | 1 |  | 1
J91012 |  |  | 1 |  | 1
[NAME] |  |  | 1 |  | 1
J91055 | 1 |  |  |  | 1
J91062 |  |  | 1 |  | 1
J91075 |  |  | 1 |  | 1
J91081 |  |  | 1 |  | 1
[NAME] |  |  | 1 |  | 1
[NAME] |  |  | 1 |  | 1
J91110 |  |  | 1 |  | 1
J91116 |  |  | 1 |  | 1
J91119 |  |  | 1 |  | 1
J91117 |  |  | 1 |  | 1
J91125 |  |  | 1 |  | 1
[NAME] |  |  | 1 |  | 1
J91160 |  |  | 1 |  | 1
J91164 |  |  | 1 |  | 1
J91165 |  |  | 1 |  | 1
J91166 |  |  | 1 |  | 1
[NAME] |  |  | 1 |  | 1
[NAME] |  |  | 1 |  | 1
J91202 |  |  | 1 |  | 1
J91208 |  |  | 1 |  | 1
J91212 |  |  | 1 |  | 1
J91213 |  |  | 1 |  | 1
J91218 |  |  | 1 |  | 1
[NAME] | 1 |  |  |  | 1
[NAME] | 1 |  |  |  | 1
[NAME] |  |  | 1 |  | 1
J91323 |  |  | 1 |  | 1
[NAME] |  |  | 1 |  | 1
[NAME] | 4 |  |  |  | 4
[NAME] |  |  | 1 |  | 1
[NAME] |  |  | 1 |  | 1
[NAME] |  |  | 1 |  | 1
Grand Total | 47 | 1 | 89 |  | 137
Spreadsheet: jeff_dasovich__14108__Appdx B 3rd Qtr 2000 Report win 95
Sheet: Quarterly Report Data

A | B | C | D | E | F | G | H | I |  | GGMC Imbalance Calculation |  |  |  |  | Pipeline Imbalance Detail
OFO Date | Flow Date | Beg  Inventory Mdth | End  Inventory Mdth | Inventory Change Mdth      (D-C) | Pipeline Storage Balancing Mdth | Total System Imbalance (E-F) | Total Customer Imbalance | Pipeline Imbalance Mdth (G-H) |  | GGMC Scheduled Net Pack Draft | GGMC Net Pack Allocated Mdth | GGMC Net Draft Allocated Mdth | GGMC Imbalance Mdth |  | Total Pipeline Imbalance Mdth (I) | Due To Core Forecast Differences | All Other Causes
2000-07-05 00:00:00
2000-07-05 00:00:00
2000-07-05 00:00:00
2000-07-05 00:00:00
2000-07-06 00:00:00
2000-07-06 00:00:00
2000-07-06 00:00:00
2000-07-06 00:00:00
2000-07-07 00:00:00
2000-07-07 00:00:00
2000-07-07 00:00:00
2000-07-07 00:00:00
2000-07-08 00:00:00
2000-07-08 00:00:00
2000-07-08 00:00:00
2000-07-08 00:00:00
2000-07-21 00:00:00
2000-07-21 00:00:00
2000-07-21 00:00:00
2000-07-21 00:00:00
2000-07-25 00:00:00
2000-07-25 00:00:00
2000-07-25 00:00:00
2000-07-25 00:00:00
2000-08-29 00:00:00
2000-08-29 00:00:00
2000-08-29 00:00:00
2000-08-29 00:00:00
2000-08-30 00:00:00
2000-08-30 00:00:00
2000-08-30 00:00:00
2000-08-30 00:00:00
2000-09-10 00:00:00
2000-09-10 00:00:00
2000-09-10 00:00:00
2000-09-10 00:00:00
2000-09-22 00:00:00
2000-09-22 00:00:00
2000-09-22 00:00:00
2000-09-22 00:00:00
2000-09-23 00:00:00
2000-09-23 00:00:00
2000-09-23 00:00:00
2000-09-23 00:00:00
2000-09-29 00:00:00
2000-09-29 00:00:00
2000-09-29 00:00:00
2000-09-29 00:00:00
Spreadsheet: 483403d1475645264-need-help-in-formatting-excel-data-properly-rndedit
Sheet: Actual

Student Name | test1 | Roll | 11 | Marks1
34 | Marks2
54 | Marks3
53 | Comment1
test1
test2
test3 | Comment2
test1
test2
test3 | Comment3
test1
test2
test3
Student Name | test2 | Roll | 12 | Marks1
23 | Marks2
46 | Marks3
86 | Comment1
test1
test2
test3 | Comment2
test1
test2
test3 | Comment3
test1
test2
test3
Student Name | test3 | Roll | 13 | Marks1
32 | Marks2
23 | Marks3
57 | Comment1
test1
test2
test3 | Comment2
test1
test2
test3 | Comment3
test1
test2
test3
Spreadsheet: john_arnold__15179__SSDSTF Datatables 97 June 00
Sheet: Table 9

TABLE 9
USE A SEPARATE SHEET FOR METRO & COUNTY
VOCATIONAL/TECHNICAL CENTER RESOURCES
EXCLUDING COMMUNITY COLLEGES
Name of Institution | Location |  | Enrollment |  |  | Annual Certificates Conferred by Selected Programs
 | City | County | Total | Full-Time | Part-Time | Program Name | Length of Course | Annual Certificates Conferred
 |  |  |  |  |  | Administrative/Office Science
 |  |  |  |  |  | Computer Science / MIS
 |  |  |  |  |  | Customer Service Management
 |  |  |  |  |  | Electronics Technician
 |  |  |  |  |  | Engineering
 |  |  |  |  |  | Food Science
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Lab/Medical Technician
 |  |  |  |  |  | Machine Trades
 |  |  |  |  |  | NC Machine Programming
 |  |  |  |  |  | Network Administrator
 |  |  |  |  |  | Plastics Trades
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Radiologist
 |  |  |  |  |  | Webmaster / Website Design
 |  |  |  |  |  | Other :
Spreadsheet: 210406d1359460777-assign-fixed-list-of-names-to-different-groups-macro-or-formula-coach-assignment
Sheet: Sheet1

Team | Team Member | Coach |  |  | Coach
1 | [NAME] |  |  |  | [NAME]
1 | [NAME] |  |  |  | Marvin
1 | Rahul |  |  |  | [NAME]
1 | [NAME]
1 | Smith
2 | [NAME]
2 | Antony
2 | [NAME]
2 | [NAME]
2 | [NAME]
3 | [NAME]
3 | [NAME]
3 | [NAME]
3 | [NAME]
3 | Rahul
4 | [NAME]
4 | Smith
4 | [NAME]
4 | Antony
4 | [NAME]
5 | [NAME]
5 | [NAME]
5 | [NAME]
5 | [NAME]
5 | [NAME]
6 | [NAME]
6 | Rahul
6 | [NAME]
6 | Smith
6 | [NAME]
7 | Antony
7 | [NAME]
7 | [NAME]
7 | [NAME]
7 | [NAME]
8 | [NAME]
8 | [NAME]
8 | [NAME]
8 | Rahul
8 | [NAME]
9 | Smith
9 | [NAME]
9 | Antony
9 | [NAME]
9 | [NAME]
10 | [NAME]
10 | [NAME]
10 | [NAME]
10 | [NAME]
10 | [NAME]
Spreadsheet: 147482d1332816427-is-averageifs-the-correct-function-to-use-copy_averageifs
Sheet: Sheet1

 |  |  |  | Dbase Criteria
 |  | Average Score For Lessons 2,3,4 & 5 Combined
 | [NAME]
 | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] No.
 | [NAME] |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | [NAME] |  |  |  |  |  | [NAME] | 5 | 4 | 4.5 | 6 | 7 | 2.5 | 3 | 5 | 6 | 7
 |  |  |  |  |  |  | [NAME] | 1 | 2 | 4 | 5.5 | 3 | 2.5 | 1 | 2 | 4 | 6
 |  |  |  |  |  |  | [NAME] | 2 | 3 | 3.5 | 5 | 5 | 4 | 6 | 3 | 4 | 2.5
 |  |  |  |  |  |  | [NAME] | 6 | 4 | 3 | 4.5 | 3 | 5 | 6 | 3 | 6 | 4.5
 |  |  |  |  |  |  | [NAME] | 3 | 5 | 4 | 6.5 | 5.5 | 4 | 3 | 5 | 4.5 | 5
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 |  | -1512
500046 | -5365 |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 | -9876 | -20544
500528
500529
500619
INDEX
2002-02-28 00:00:00 |  |  | -577834.69
2002-03-12 00:00:00
CBS Volume
 |  |  | -55913
Spreadsheet: 181424d1348040882-compare-tables-in-excel-0a1_f_discounts-3-
Sheet: Example_result

Phone Number | Discount ID |  |  | Number | Discount
[PHONE] | 53457 |  |  | [PHONE] | 56027
[PHONE] | 56006 |  |  | [PHONE] | 53457
[PHONE] | 56013 |  |  | [PHONE] | 56014
[PHONE] | 56026 |  |  | [PHONE] | 3686
[PHONE] | 8728 |  |  | [PHONE] | 56003
[PHONE] | 8729 |  |  | [PHONE] | 56009
Real Discount |  |  |  | New Discount
 | Result
 | Number | Discount
 | [PHONE] | 56027 | No
 | [PHONE] | 53457 | Yes
 | [PHONE] | 56014 | No
 | [PHONE] | 3686 | No
 | [PHONE] | 56003 | No
 | [PHONE] | 56009 | No
Spreadsheet: rick_buy__32812__NP Daily Marks
Sheet: Daily Change Graph

 | COB 08/27/01 | COB 08/28/01 | COB 08/29/01 | COB 09/04/01 | COB 09/06/01 | COB 09/10/01 | COB 09/12/01 | COB 09/17/01 | COB 09/18/01 | COB 09/19/01 | COB 09/20/01 | COB 09/21/01 | COB 09/24/01 | COB 09/25/01 | COB 09/26/01
FMTM
PMTM
Net Del.
Net Exp.
Collateral | -87.3 | -109.3
Treashold | -15 | -15
Exposure
Spreadsheet: 137490d1327157024-tranpose-indexmatchtransposewithhelpers
Sheet: Sheet1

a | b | Helper1 | Helper2
Akin | 79 |  |  |  | Akin
Akin | 106 |  |  |  | [NAME]
Akin | 134
Akin | 121
[NAME] | 477
[NAME] | 423
[NAME] | 186
[NAME] | 129
[NAME] | 562
Spreadsheet: 798267d1664388163-max-value-formula-calculating-pay-range-maxvalueformula
Sheet: Calculator

 |  |  |  |  |  |  |  | [NAME] in this column
Employee ID | Provider | Specialty | APP Licensure Date | Hire Date | Specialty | Years of Experience | Current Rate | Calculated Rate
11111 | Name |  | 2001-01-01 00:00:00 | 00:00:00 | Medical Based Includes Inpatient Work | 2.5 | 57.2 |  | Answer should be $57.20 because the lookup table came bck with $51.51
2222 | [NAME] |  | 2001-01-02 00:00:00 | 00:00:00 | Surgical Salary Based Includes Inpatient Work | 21.5 | 52.63 |  | Answer should be $68.41 because the maximum pay range of this specialty is $68.41.
Looking for a formula that looks up the specialty and the years of experiences and then compares the value that it gates from the lookup table and compares to current rate and gives me the [NAME] value, or the higher of the 2
Spreadsheet: 804356d1668014285-sumif-and-vlookup-together-vlookup-and-sumif-help
Sheet: GL

Ck# | [NAME] | Amt | Src Code
12345 | ABC | -373 | 963
12345 | ABC | 1017.56 | 963
456 | CDF | 5470.84 | 123
456 | CDF | 9228.3 | 123
456 | CDF | 5765.43 | 123
456 | CDF | 7427.19 | 123
456 | CDF | 8.88 | 123
789 | QTP | 19.29 | 963
789 | QTP | 16.32 | 963
789 | QTP | 259.87 | 963
789 | QTP | 350 | 963
789 | QTP | 350 | 963
789 | QTP | 288.46 | 963
789 | QTP | 116.04 | 963