tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0aac4d98-0fe1-4fb6-8f67-a470d59ef25a
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
FIGA | Test | FIGA | Anti-IgA | Anti-IgA | Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s) or serum gel tube(s). Spin down and send 1 mL of serum refrigerate in a plastic vial. | 1 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | <99 U/mL   Patients with IgG antibodies against IgA may suffer from anaphylactoid reactions when given IVIG that contains small quantities of IgA. In one study (Clinical Immunology 2007; 122:156) five out of eight patients with IgG anti-IgA antibodies developed anaphylactoid reactions when IVIG was administered.   Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr                              Lee's Summit, MO 64086 | Thursday | 5 - 8 days | 7 - 16 days | 1 | 83520 |  |  |  |  | Viracor-IBT Laboratories
FIGA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
FIGA | Result | FIGA | Anti-IgA | Anti-IgA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -20818 | -20000
2 | -19999 | -20000
3 | -21734 | -20609
4 | -20009 | -20000
5 | -20393 | -20000
6 | -20508 | -20000
7 | -20768 | -20000
8 | -21004 | -19966
9 | -20992 | -20000
10 | -21007 | -20702
11 | -20996 | -19967
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 135803
2001-08-11 00:00:00
CBS Dollars
 |  |  | 82140
Spreadsheet: 92744d1292307101-iteration-continuously-increases-before
Sheet: Week10

Week | Day | Date | Winner/tie | PtsW |  | [NAME]/tie | PtsL
10 | Thu | 2010-11-11 00:00:00 | Atlanta Falcons | 26 |  | Baltimore Ravens | 21
10 | Sun | 2010-11-14 00:00:00 | Indianapolis Colts | 23 |  | Cincinnati Bengals | 17
10 | Sun | 2010-11-14 00:00:00 | San Francisco 49ers | 23 |  | St. Louis Rams | 20
10 | Sun | 2010-11-14 00:00:00 | [NAME] | 29 |  | Tennessee Titans | 17
10 | Sun | 2010-11-14 00:00:00 | New York Jets | 26 | @ | [NAME] | 20
10 | Sun | 2010-11-14 00:00:00 | [NAME] | 31 |  | Houston Texans | 24
10 | Sun | 2010-11-14 00:00:00 | Buffalo Bills | 14 |  | Detroit Lions | 12
10 | Sun | 2010-11-14 00:00:00 | Tampa Bay Buccaneers | 31 |  | Carolina Panthers | 16
10 | Sun | 2010-11-14 00:00:00 | Denver Broncos | 49 |  | Kansas City Chiefs | 29
10 | Sun | 2010-11-14 00:00:00 | New England Patriots | 39 | @ | Pittsburgh Steelers | 26
10 | Sun | 2010-11-14 00:00:00 | [NAME] | 36 | @ | Arizona Cardinals | 18
10 | Sun | 2010-11-14 00:00:00 | Dallas Cowboys | 33 | @ | New York Giants | 20
10 | Sun | 2010-11-14 00:00:00 | Chicago Bears | 27 |  | Minnesota Vikings | 13
10 | Mon | 2010-11-15 00:00:00 | Philadelphia Eagles | 59 | @ | Washington Redskins | 28
Spreadsheet: 860314d1708452592-whats-is-wrong-with-my-formula-copy-of-dec23-design
Sheet: Pay & Workday

Staff | Pay
[NAME] | 20000
[NAME] | 10000
[NAME] | 23000
[NAME] | 9000
Adam | 10100
[NAME] | 92919
Start | End | Workday | PH | Net Working day | Hour/Day | Total Working Hour
2023-08-01 00:00:00 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
Spreadsheet: 223915d1364378665-2-cell-values-to-be-linked-together-20130327-test-v1
Sheet: Sheet1

Name | Class
[NAME] | IV
[NAME] | V
[NAME] | V
[NAME] | XI
Rock | IX
Zane | VII
Now what I want here is as follows
Jim/IV
[NAME]/V
[NAME]/V
Andy/XI
Rock/IX
Zane/VII
Spreadsheet: 121894d1316496990-averaging-values-while-excluding-cells-with-text-excluding-text-from-the-average-of-cells
Sheet: Sheet1

 | AVG Success Rate | 2010 Success Rate | 2010 Permits Available | 2010 Draw Rate | 2009  Success Rate | 2008 Success Rate | 2007 Success Rate
 |  | 0 | 8 | 0.02 | 0.17 | 0 | 0.2
 |  | 0.33 | 3 | 0.01 | 0.5 | 0 | 0
 |  | 0 | 3 | 0.01 | 0 | 0 | 0
 |  | 0.33 | 3 | 0.01 | 0 | 0 | 0
 |  | 0.5 | 13 | 0.03 | 0.27 | 0.4 | 0
 |  | 0.6 | 8 | 0.03 | 0.71 | 0.83 | 1
 |  | 0.83 | 7 | 0.03 | 0.71 | 1 | 0.8
 |  | 0 | 25 | 0.18 | 0 | #N/A | #N/A
 |  | 0.5 | 3 | 0.01 | 0 | 0 | 0
 |  | 0.64 | 27 | 1 | 0.71 | 0.8 | 0.53
 |  | 0.86 | 12 | 1 | 0.64 | 0.63 | 1
 |  | 0.71 | 8 | 0.5 | 0.33 | 0.75 | #N/A
 |  | 0.5 | 8 | 1 | 0.33 | 0.4 | #N/A
 |  | No records available | 4 | 0.29 | 1 | 0 | #N/A
 |  | 0.67 | 8 | 0.67 | 0.67 | 0.67 | #N/A
 |  | 0.33 | 12 | 1 | 0.5 | 0.5 | 0.8
 |  | 0 | 20 | 0.08 | 0.13 | 0.1 | 0
 |  | 0.22 | 250 | 0.08 | 0.16 | 0.19 | 0.19
 |  | #N/A | 0 |  |  |  | #N/A
 |  | #N/A | 0 |  |  |  | #N/A
 |  | #N/A | 0 |  |  |  | #N/A
 |  | #N/A | 0 |  |  |  | #N/A
 |  | 0.64 | 100 | 0.07 | 0.63 | 0.47 | 0.61
 |  | 0.33 | 25 | 0.04 | 0.5 | 0.25 | 0.33
Spreadsheet: 705714d1606269837-2-part-complex-formula-for-matching-multiple-results-test-example-of-cis-_-cjis-_-nist
Sheet: Helper Data

CJIS | Helper | Count | NIST Control Number | TextJoin
 |  |  | SI-4
Spreadsheet: 8820afbd-2cbb-4880-ad4f-6fd345c88ab1
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
FFTAS | Test | FFTAS | FLT3 ITD and TKD Mutation Assay | FLT3 (ITD) and TKD Mutation Assay | [NAME] and Capillary Electrophoresis |  |  |  |  |  | Submit only 1 of the following specimens:  Note: 1. If also ordering a Mayo test, send separate specimens          2. Clinical reason for referral (AML or CML) is required          3. Specimen source is required.          4. Date of collection is required  Blood Draw blood in a lavender-top (EDTA), yellow-top (ACD), or green-top (sodium heparin) tube(s). Send 5 mL EDTA, ACD, or heparinized whole blood refrigerate.  Bone Marrow Collect bone marrow in a lavender-top (EDTA), yellow-top (ACD), or green-top (sodium heparin) tube(s). Send 3 mL EDTA, ACD, or heparinized bone marrow refrigerate.  DNA 1 ug previously isolated DNA shipped refrigerate. | Blood 5 mL; Bone Marrow 3 mL | Hemolysis:	NA Thawing:	NA Lipemia:	NA Icterus:	NA Other:	NA | Not Detected  *FLT3 Mutation Testing is performed pursuant to patents licensed from [NAME] of Otsu, Japan.   Test Performed by: Laboratory for Personalized Molecular Medicine                              6330 [NAME], Suite 106                              San Diego, CA 92121 | Varies | 3 - 7 days | 5 - 9 days |  | Profile |  |  |  |  | Laboratory for Personalized Molecular Medicine
FFTAS | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FFTAS | Order Question | Z3005 | Reason for Referral |  | Plain Text
FFTAS | Order Question | Z1003 | [NAME] |  | Plain Text
FFTAS | Result | Z1003 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTAS | Result | Z3562 | FLT3 Internal [NAME] (ITD) | FLT3 Internal [NAME] (ITD) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTAS | Result | Z3277 | FLT3 TKD Mutation | FLT3 TKD Mutation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTAS | Result | Z1006 | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTAS | Result | [NAME] | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTAS | Billing Component | FFTAS |  | Unlisted Molecular Pathology |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81479
FFTAS | Billing Component | FFTAS |  | FLT3 GENE |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81245
Spreadsheet: 0cbefd04-d14a-4015-90ac-052c21557758
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5609.0 Housing Finance, Australia
 | TABLE 9a. HOUSING FINANCE COMMITMENTS (Owner Occupation), By Type of Buyer and Loan: Australia, Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
First home buyers - Dwellings financed (no.) ; |  |  | Original | A2412824W | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | Number | FLOW | Month | 1
First home buyers - % of all dwellings financed ; |  |  | Original | A2412836F | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | Percent | DERIVED | Month | 1
First home buyers - Average loan size ($000) ; |  |  | Original | A2412825X | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | $'000 | DERIVED | Month | 1
Non-first home buyers - Dwellings financed (no.) ; |  |  | Original | A2412827C | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | Number | FLOW | Month | 1
Non-first home buyers - % of all dwellings financed ; |  |  | Original | A2416246C | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | Percent | DERIVED | Month | 1
Non-first home buyers - Average loan size ($000) ; |  |  | Original | A2412826A | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | $'000 | DERIVED | Month | 1
Fixed rate - Dwellings financed (no.) ; |  |  | Original | A2412828F | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | Number | FLOW | Month | 1
Fixed loans - % of all dwellings financed ; |  |  | Original | A2412837J | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | Percent | DERIVED | Month | 1
Fixed rate - Average loan size ($000) ; |  |  | Original | A2412829J | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | $'000 | DERIVED | Month | 1
Secured revolving loans - Dwellings financed (no.) ; |  |  | Original | A2412830T | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | Number | FLOW | Month | 1
Secured revolving loans - % of all dwellings financed ; |  |  | Original | A2412838K | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | Percent | DERIVED | Month | 1
Secured revolving loans - Average loan size ($000) ; |  |  | Original | A2412831V | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | $'000 | DERIVED | Month | 1
Other loans -  Dwellings financed (no.) ; |  |  | Original | A2412832W | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | Number | FLOW | Month | 1
Other loans - % of all dwellings financed ; |  |  | Original | A2412839L | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | Percent | DERIVED | Month | 1
Other loans - Average loan size ($000) ; |  |  | Original | A2412833X | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | $'000 | DERIVED | Month | 1
ALL FINANCE - Average loan size ($000) ; |  |  | Original | A2412834A | 1975-10-01 00:00:00 | 2012-09-01 00:00:00 | 444 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 107944d1305066124-filtering-text-using-a-formula-copy-of-testing
Sheet: 2011 Distributor Order Form

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Next Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 750
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2%, 10, Net 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C.O.D.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prepaid
Salesman | Shipping Method | Shipping Terms | Delivery Date | Payment Terms |  |  | Payment Due Date |  | New Customer | Credit Application |  |  |  |  | Samples
 |  |  |  |  |  |  |  |  | No | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
QTY | Item # | Color Code | UPC Code | Item Description |  |  |  |  | Price Per Unit | Quantity Price Total |  |  |  |  | No
 | EG-005 | 021 | 884000001652 |  |  |  |  |  |  | 0 |  | EG-005 021
 | EG-005 | 021 | 884000001652 |  |  |  |  |  |  | 0 |  | EG-005 021
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
Customer Purchasing Information |  |  | Date: |  |  |  |  |  | Subtotal | 0
Credit Card Number: |  |  |  |  |  |  | Discount (If Applicable)
Expiration: |  |  | Security Code: |  | Notes |  |  |  | Total | 0
[NAME] By:
Spreadsheet: 5868de93-dec5-495d-ac9b-3acfcb75aa80
Sheet: Sheet1

REP 4 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
PERFORMANCE CASTING |  |  | SUBJECT TO CHANGE
2013-03-05 00:00:00
 |  | WEEK ONE
 | Fri | Sat Mat | [NAME]
 | 2013-03-15 00:00:00 | 2013-03-16 00:00:00 | 2013-03-16 00:00:00
 | 19:30:00 | 14:00:00 | 19:30:00
CONCERTO BAROCCO
1st Violin | KORBES | CHAPMAN | GILBREATH
2nd Violin | IMLER | RAUSCH | DEC
Man | [NAME] | LIN-YEE | CRUZ
Corps
1 | MACY | [NAME] | MACY
2 | CLARK | CLARK | CLARK
3 | O'CONNOR | GENEROSA | O'CONNOR
4 | LOVE | NELSON | LOVE
5 | MURPHY | BIASUCCI | MURPHY
6 | MULLIN | MULLIN | PASCH
7 | ANSPACH | SAMUELSON | ANSPACH
8 | [NAME] | NEUVILLE | [NAME]
Pause
MOZART PIECES
Couple | DEC | DEC | KORBES
 | CRUZ | CRUZ | ORZA
Trio | NAKAMURA | NAKAMURA | SAMUELSON
 | GRIFFITHS | GRIFFITHS | [NAME]
 | MOORE | MOORE | BARTEE
Corps
1 | CARDEA | CARDEA | CARDEA
2 | DAVIS | DAVIS | DAVIS
3 | HIPOLITO | HIPOLITO | HIPOLITO
4 | THOMSON | THOMSON | THOMSON
Intermission
DANCING ON THE FRONT PORCH OF HEAVEN
Women
1 | CHAPMAN | DEC | CHAPMAN
2 | RAUSCH | GILBREATH | RAUSCH
3 | FOSTER | MURPHY | FOSTER
Men
1 | ORZA | CRUZ | ORZA
2 | [NAME] | [NAME] | [NAME]
3 | BARTEE | LIN-YEE | BARTEE
Intermission
IN THE UPPER ROOM
Stompers
Women
1 | DEC | DEC | DEC
2 | CHAPMAN | CHAPMAN | CHAPMAN
3 | IMLER | IMLER | IMLER
X-Over Woman | MULLIN | MULLIN | MULLIN
Men
1 | ORZA | ORZA | ORZA
2 | GAINES | GAINES | GAINES
3 | [NAME] | [NAME] | [NAME]
Ballet Couples
1 | [NAME] | [NAME] | [NAME]
 | MOORE | MOORE | MOORE
2 | MURPHY | MURPHY | MURPHY
 | GRIFFITHS | GRIFFITHS | GRIFFITHS
[NAME] Couple
 | NAKAMURA | NAKAMURA | NAKAMURA
 | PORRETTA | PORRETTA | PORRETTA
Spreadsheet: 753945d1635854983-cell-entries-validation-test-cf-tms
Sheet: Sheet1

Category | [NAME] | DD No | Tech Id | HP No | Po Id | Documents OK
D |  |  |  | 1234A | [NAME]
E |  |  |  | 67GBD | GFRE2
NA |  |  |  | 123 | acd67
IS | 123Bg | 678DRT | YS123 | hRE4
Spreadsheet: 838965d1691568530-modify-formulas-to-calculate-overtime-when-40hrs-are-not-worked-time-card-test-new-code-sample1
Sheet: Sheet1

 | Day | Holiday | Stat | Start | End | Total Hrs Wrkd | REG | TAH | DT
 | Sun |  |  | 08:00:00 | 20:00:00
 | Mon |  |  | 08:00:00 | 18:00:00
 | Tue |  |  | 08:00:00 | 12:00:00
 | Wed |  |  | sick
 | Thu |  |  | 08:00:00 | 16:00:00
 | Fri |  |  | 08:00:00 | 16:00:00
 | Sat |  |  | 08:00:00 | 16:00:00
 | Total
Spreadsheet: mary_fischer__25628__1473-2001
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF OTHER DEFERRED CHARGES
FOR THE 6 MONTHS ENDED 6-30-01
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Work in Progress:
 |  | 0
Total  (Hyperion Line 0343)
Asset/Expense Accts:  DR/(CR)
Other Deferred Charges:
Payroll Taxes |  |  |  |  |  |  |  | 61037.35 |  | From company 15 A
Employee Benefits |  |  |  |  |  |  |  | 550 |  | From company 15 A
[NAME] |  |  |  |  |  |  |  | 259491.02 |  | From company 15 A
Holiday Pay |  |  |  |  |  |  |  | 213539.14 |  | From company 15 A
Sick Pay |  |  |  |  |  |  |  | 153008.2 |  | From company 15 A
Other Empl Benefits |  |  |  |  |  |  |  | 36981.95 |  | From company 15 A
General Liability |  |  |  |  |  |  |  | 33000 |  | From company 15 A
PTO & Holiday Burden |  |  |  |  |  |  |  | 246988.49 |  | From company 15 A
Allocated Burden |  |  |  |  |  |  |  | -1787830.33 |  | From company 15 A
Job Cost Transfer Clearing |  |  |  |  |  |  |  | 277.8 |  | From company 15 A
[NAME] adjustment to be re-classed in the third quarter |  |  |  |  |  |  |  | 675181.89 |  | From company 15 A
AR adjustment from EES to EA to be re-classes in Q3 |  |  |  |  |  |  |  | -1264057.17 |  | From company 15 A
Balance transfer from 015A to 1473 |  |  |  |  |  |  |  | -1204878.89 |  | From company 15 A
Total (Hyperion line 360)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 724331d1616107294-formula-for-average-with-criteria-in-multiple-columns-spreadsheet-average
Sheet: Sheet1

Day 1 | [NAME] | HBS | [NAME] | active | Yes | No | 09:42:00 | complete | 0.61
Day 2 | [NAME] | HBS | [NAME] | active | Yes | No | 13:48:00 | complete | 0.55
Day 3 | [NAME] | HBS | [NAME] | active | Yes | No | 15:52:00 | complete | 0.88
 |  |  | Averages
 |  |  | [NAME]
Spreadsheet: 692659d1598484269-need-to-extract-data-and-skip-blanks-machine-shop-schedules_excel-forum
Sheet: Plating Cost Calculator

 |  |  |  |  | PURCHASE ORDER ENTRY (Do not populate gray cells) |  |  |  |  |  |  | (Eastern!T2="X",Eastern!C2,0) | IFERROR(INDEX(Eastern!$T$2:$T$100,SMALL(IF(ISTEXT(Eastern!$T$2:$T$100),ROW(Eastern!$T$1:$T$100),""),ROW(Eastern!C2))),"") |  |  |  |  |  | 200
CNC / LASER ENTRY (Do not populate gray cells) |  |  |  |  | PO SUBTOTAL |  |  | Expedite: SAME DAY
 |  |  |  |  | PO WASTE FEE (5% of SUBTTL) |  |  | Expedite: NEXT DAY
P/N | L | W | REV | QTY | Total Dimensions | Cost per Part | Total QTY Cost
 | 8.423 | 6.762 | A1 | 4
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
www.atlaspm.xxx/toms-tutorials-for-excel/toms-tutorials-for-excel-listing-noncontiguous-data-without-blanks/
Spreadsheet: 0277aff4-b7e6-433f-8573-a55f907cbeaf
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
LI NING BWF SUDIRMAN CUP CHAMPIONSHIPS 2013
PRACTICE REQUEST FORM
TO　[EMAIL] / [EMAIL]
to be returned, no later than Friday 10th May 2013
Country: |  |  |  |  | Date :
[NAME]: | 5 courts, 9:00 - 20:00 on  17 and 18
Practice Hall: | 6 courts, 9:00 - 19:00
Date | Time |  | No. of Courts |  | No. of Players |  | Remarks
 |  |  | Main | Practice
17 May (FRI)
18 May (SAT)
19 May (SUN)
20 May (MON)
21 May (TUE)
22 May (WED)
23 May (THU)
24 May (FRI)
25 May (SAT)
26 May (SUN)
Note:
1. Please confirm your training times at the Secretariat at the official hotel/venue.
2. Subject to approval from referee
 |  | Not available
 |  | Request for practice sessions in the Practice Hall can be made at the liaison Centre in
 |  | the official hotel upon arrival
Spreadsheet: 791028d1660125557-i-need-to-calculate-the-average-days-the-tickets-have-been-open-in-the-past-30-days-maintanace-tickets
Sheet: Issue Tracker Chart

 | Open vs Closed Issues
 | Number of outstanding issues |  |  |  |  |  |  |  |  |  |  |  |  |  | Avarage open ticket time in past 30 days |  |  |  |  | Total Avarage open ticket time
 | 2022-04-21 00:00:00 | <----- Start date
 | Tickets open and closed in past 30 days
 | Date | Total Open | Total Closed
Spreadsheet: 27531d1220855951-converting-a-histogram-data-into-scatter-plot-data-hist_to_scatterplot-sglife
Sheet: Histogram

Value | Frequency |  |  | Value
10 | 2
8 | 2
5 | 1
4 | 10
3 | 8
2 | 7
1 | 68
0 | 2
Total Observations |  | 100
Spreadsheet: joe_parks__15026__bridgeline 6-5
Sheet: Sheet1

b/s | contract | price | volume | time | cm | account | cti | order # | trader | reference | trade #
B | NGN2 | 3290 | 9 | 08:19:18 | 905 | 97563 | 4C | 6591 | amk | EO-6591 | 4090 | 0 | N
S | NGN2 | 3290 | 7 | 17:21:10 | 905 | 97563 | 4C | 3044 | amk | EO-3044 | 1678 | 0 | Y
S | NGN2 | 3290 | 23 | 17:21:10 | 905 | 97563 | 4C | 3044 | amk | EO-3044 | 1679 | 0 | Y
S | NGN2 | 3293 | 15 | 17:20:20 | 905 | 97563 | 4C | 3029 | amk | EO-3029 | 1669 | 0 | Y
B | NGN2 | 3295 | 12 | 08:19:41 | 905 | 97563 | 4C | 6595 | amk | EO-6595 | 4091 | 0 | N
S | NGN2 | 3295 | 10 | 17:16:27 | 905 | 97563 | 4C | 2929 | amk | EO-2929 | 1587 | 0 | Y
S | NGN2 | 3295 | 25 | 17:16:27 | 905 | 97563 | 4C | 2929 | amk | EO-2929 | 1588 | 0 | Y
S | NGN2 | 3330 | 15 | 16:30:57 | 905 | 97563 | 4C | 2022 | amk | EO-2022 | 886 | 0 | Y
Spreadsheet: 115923d1311361044-using-lookup-with-two-variables-and-less-than-greater-than-constraints-lookup-using-two-variables-help
Sheet: Sheet1

 | Capacity: |  |  | 1
 | Resolution: |  |  | 0.001
 | Displacement Per Revolution: |  |  | 0.1
 | Calibration Standard | Verification Reading #1 | Verification Reading #2 | Verification Reading #3 | Tolerance ± | Revolutions
 | 0 | 0 | 0 | 0 | 0 | 0
 | 0.225 |  |  |  | 1 | 2.25
 | 0.45 |  |  |  | 2 | 4.5
 | 0.675 |  |  |  | 2 | 6.75
 | 0.8 |  |  |  | 2 | 8
 | 1 |  |  |  | 2 | 10
 | 0.8
 | 0.675
 | 0.45
 | 0.225
 | 0
 | Tolerance Table
 | Resolution Inches |  | Hysteresis |  | One Revolution | First 2.5 Revolutions | > 2.5 Revolutions | > 10 thru 20 Revolutions
 | 5e-05 |  | 1 |  | 1 | 1 | 4
 | 0.0001 |  | 1 |  | 1 | 1 | 3 | 4
 | 0.0005 |  | 0.33 |  | 1 | 1 | 3 | 4
 | 0.001 |  | 0.33 |  | 1 | 1 | 2 | 4
Spreadsheet: 113746d1309558076-hlookup-vlookup-help-needed-sample_data-modified
Sheet: summary

SAMPLE TEST DATA:
 |  | 5 |  | 1
 | Total Count ► | 7 |  | 2
 |  |  |  | 3
 | 1111 | asdf |  | 4
 | 1113 | asdg |  | 5
 | 1115 | gasd
 | 1116 | asd
 | 1117 | gasd
 | 1118 | sdaf
 | 1119 | asdf
Spreadsheet: 34656d1231967382-lookup-or-index-dealer-selection
Sheet: Presentation

 |  | STYLE | BOX COUNT | DOLLARS
DEALER
TOP SHELF CABINETS INC |  | PORTRAIT MAPLE | 1 | 296.81
 |  | NORTHPORT | 3 | 358.52
 |  | SILHOUETTE MAPLE | 1 | 416.81
84 LUMBER STORE#0806 |  | SOMERTON HILL CHERRY | 2 | 352.64
 |  | PORTRAIT MAPLE | 2 | 370.78
 |  | SILHOUETTE CHERRY | 1 | 423.24
ANDERSONVILLE KITCHEN & BATH |  | MOUNTAIN MIST | 2 | 318.99
 |  | SPRING VALLEY OAK | 2 | 345.59
 |  | SUTTON CLIFF CHERRY | 2 | 353.3
 |  | ARBOR FALLS II WHITE or BISQUE | 4 | 392.29
 |  | SILHOUETTE MAPLE | 2 | 412.12
GALACTIC TECH INC |  | NORTHPORT | 4 | 323.62
Spreadsheet: 772070d1646996076-need-help-on-formula-to-get-score-for-help-calculation
Sheet: Sheet1 (2)

 |  |  |  | 2 | 2.5 | 3.5 | 4.5 |  |  |  |  | 2 | 2.5 | 3.5 | 4.5
 |  | Transaction Per Hr | Weight | Range |  |  |  | Out of 5 |  | Transaction Per Hr | Weight | Range |  |  |  | Out of 5
 |  | 27 | 5 | 16 | 21 | 24 | 27 |  |  | 2.5 | 5 | 2 | 4 | 6 | 8
 |  |  | I need formula in I4
 |  |  | Where on the basis of C4 Value
 |  |  | I should get Out of 5
 |  |  | For e.g
 |  |  | if C4  value falls in between 16 - 21  then out of would be in between 2 to 2.5.. And so on
 |  |  | if C4  value falls in between 21 - 24  then out of would be in between 2.5 to 3.5.. And so on