tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 150397d1334505128-excel-2007-solver-how-do-constraints-work-nu-pharma-financial-handout_mod
Sheet: new

 | PRODUCTS: |  | MAN. COST | PROD. COST | GROSS MARGIN
 |  | KADIEN | 85 | 110
 |  | GENERIC | 38 | 43
 |  | TOTAL
 |  |  |  | TERRITORY | CONTRIBUTION | CONTRIBUTION
 |  | COMP. | BEP | VOLUME | DOLLARS | MARGIN
 | TRANESHIA | 65000 |  | 400000
 | COURTNEY | 85000 |  | 1
 | KATHY | 65000 |  | 375000
 | SUE | 65000 |  | 350000
 | WARREN | 55000 |  | 2
 | SHAWN | 54000 |  | 185000
 | ANDREW | 38000 |  | 3
 | AVERAGE
 | TOTAL
 |  |  | Constr. [NAME] | 3355000
Spreadsheet: a9067747-e2e7-43a4-82c6-c7e04b8bf2e5
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
CTRE | Test | CTRE | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CTRE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CTRE | Result | CTRE | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6069-9
Spreadsheet: 290202a0-e434-401b-8aac-f085e6e5f72d
Sheet: Sheet1

FY 2012 AEA STATE AID PAYMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | ORIGINAL | SEPT-OCT | PAID THROUGH | AMOUNT
 |  | BUDGET | PAYMENT | OCT | REMAINING
1 | [NAME] 1 | 12173702 | 1217373 | 2434746 | 9738956
5 | PRAIRIE LAKES AEA 8 | 11932421 | 1193242 | 2386484 | 9545937
7 | AEA 267 | 25953086 | 2595314 | 5190628 | 20762458
9 | MISSISSIPPI BEND AEA 9 | 17943809 | 1794383 | 3588766 | 14355043
10 | GRANT WOOD AEA 10 | 25140991 | 2514103 | 5028206 | 20112785
11 | HEARTLAND AEA 11 | 45695987 | 4569599 | 9139198 | 36556789
12 | NORTHWEST AEA | 14971662 | 1497170 | 2994340 | 11977322
13 | GREEN HILLS AEA 13 | 14813279 | 1481329 | 2962658 | 11850621
15 | GREAT PRAIRIE AEA 15 | 13537748 | 1353777 | 2707554 | 10830194
 |  | 182162685 | 18216290 | 36432580 | 145730105
Spreadsheet: 790105d1659537733-10-day-rolling-values-on-chart-book1-12-ans
Sheet: Sheet1

2022-01-01 00:00:00 | 45 |  | Enter date | 2022-01-14 00:00:00
 | 66
 | 36
 | 27
 | 11
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 44
 | 34
 | 62
 | 21
 | 43
 | 28
 | 46
 | 23
Spreadsheet: 63338d1264249416-excel-2007-reg-check-the-trend-trend
Sheet: Sheet1

item | code | apr | may | jun | july | aug | sep | oct
100 |  | -3.174210338208869 | 17.49812410765298 | -2.91821598452546 | -5.226207837358793 | -14.0684192977249 | 14.15166918968837 | 7.890921797075009 | 1 | 1
100 |  | -13.61771163591459 | 1.307350059371931 | 14.24061850611385 | -0.4056620248980956 | 17.49632128234222 | 16.53275083224361 | 9.43126745733258 | -1 | 1
100 |  | -7.042852889672719 | 15.43090994814569 | -12.62926013465081 | 4.730549053036512 | 5.347756221505943 | 6.593207110383087 | -0.7049687222524206 | -1 | 1
Spreadsheet: 154358d1336399107-find-amount-under-budget-sample-mtd_ytd
Sheet: Sheet1

Budget totals and year to date remaining.
 | Total MTD |  | Remaining | Last updated
Jan | 2305.07 |  |  | 2012-04-03 00:00:00
Feb | 3843.35 |  |  | 2012-03-19 00:00:00
Mar | 4523.53 |  |  | 2012-04-03 00:00:00
April | 2259.01 |  |  | 2012-05-07 00:00:00
May | 499.28 |  |  | 2012-05-07 00:00:00
June
July
Aug
Sept
Oct
Nov
Dec
YTD Total/remaining
 | Under budget by
Column B is the total spent in that month
Column D is the amout of the budget minus the total spent for that month
Cell D 18 is the Remaining YTD total. In this example we have 48645.76 remaining in the budget this year.
Cell B 18 is the Total spent YTD. In this example we have spent 13430.24 on this years budget.
Cell d20 should be the amount that we are under budget as of the last update.
Spreadsheet: 2de60e57-8014-40e8-bfa5-5eb6ae9f2b4a
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
 | SUPPLIER EVALUATION FORM
1. | Please provide your company name and address, applicable DUNNS number, and CAGE CODE:
2. | Please type the requested contact information for your company's a) Top Executive, b) Quality Manager, c) Production/Manufacturing Manager, and d) Contracts Manager:
 | Name                                                             Phone                                   Fax                                       Email
a)
b)
c)
d)
3. | Please describe the products and/or services you can provide, list your WEBSITE, or mail us a brochure.
 | For questions 4-12, please click the appropriate checkbox.  If your Quality Control System is registered to ISO-9000 or AS-9100 YOU MAY SKIP QUESTIONS 4-12, but complete items #13 and send/email us a copy of your registration certificate.
 |  |  |  | Yes | No
 |  |  |  |  |  | YES  NO   N/A
4. | Is your Quality System documented in a Quality Manual?
5. | Do you fully review customer purchase orders or contracts to ensure
 | that you have the capability to meet customer requirements?
6. | Does your top quality function report directly to your top executive?
7. | Do you inspect the materials you order against the requirements of
 | your purchase orders to your suppliers ?
8. | Do you inspect parts at planned points in the manufacturing process?
9. | Do you have a formal system for controlling nonconforming product?
10. | Do you have a formal corrective action system?
11. | Is the calibration status of inspection, measuring, and test equipment
 | known and controlled?
12. | Are the standards used to check the calibration of inpection, measuring,
 | and test equipment traceable to appropriate NIST standards?
13. | As of the date indciated below, the information above is correct:
 | Typed name:
 | Title:
 | Date:
 | Upon completion, fax, email, or post to:
 |  | Technical Ordnance                                                     Rick Kolbeck, Purchasing Manager 47600 180th Street Clear Lake, SD 57226-5469 [EMAIL]                                                                        FAX [PHONE] Phone [PHONE] X512
Spreadsheet: 867688d1714492073-need-attendace-sheet-for-saleman-visited-diffrent-regions-with-different-items-mega-matrix-aligw
Sheet: Sheet1

 |  | Salesman | Items | Region | Region
 |  | Salesman101 | Item-1
 |  | Salesman101 | Item-2 | REG-3 | C
 |  | Salesman101 | Item-3 | REG-3 | C
 |  | Salesman111 | Item-1 | [NAME] | F
 |  | Salesman111 | Item-2 | REG-3 | C
 |  | Salesman111 | Item-3 | REG-1 | A
 |  | Salesman111 | Item-4 | REG-3 | C
 |  | Salesman111 | Item-5
 |  | Salesman111 | Item-6 | [NAME] | F
 |  | Salesman111 | Item-7 | REG-3 | C
 |  | Salesman111 | Item-8 | REG-5 | E
 |  | Salesman111 | Item-9 | [NAME] | F
 |  | Salesman121 | Item-1 | REG-7 | G
 |  | Salesman121 | Item-2 | REG-7 | G
 |  | Salesman131 | Item-1 | REG-9 | I
 |  | Salesamn141 | Item-1 | REG-10 | J
 |  | Salesman141 | Item-2
 | Items | REG-1 | [NAME] | REG-3 | REG-4 | REG-5 | [NAME] | REG-7 | REG-8 | REG-9 | REG-10 |  |  | Items | A | C | E | F | G | I | J
Salesman101 | Item-1 |  |  |  |  |  |  |  |  |  |  |  | Salesman101 | Item-1
Salesman101 | Item-2 |  |  | 0.3333333333333333 |  |  |  |  |  |  |  |  | Salesman101 | Item-2 |  | 0.3333333333333333
Salesman101 | Item-3 |  |  | 0.3333333333333333 |  |  |  |  |  |  |  |  | Salesman101 | Item-3 |  | 0.3333333333333333
Salesman111 | Item-1 |  |  |  |  |  | 0.1111111111111111 |  |  |  |  |  | Salesman111 | Item-1 |  |  |  | 0.1111111111111111
Salesman111 | Item-2 |  |  | 0.1111111111111111 |  |  |  |  |  |  |  |  | Salesman111 | Item-2 |  | 0.1111111111111111
Salesman111 | Item-3 | 0.1111111111111111 |  |  |  |  |  |  |  |  |  |  | Salesman111 | Item-3 | 0.1111111111111111
Salesman111 | Item-4 |  |  | 0.1111111111111111 |  |  |  |  |  |  |  |  | Salesman111 | Item-4 |  | 0.1111111111111111
Salesman111 | Item-5 |  |  |  |  |  |  |  |  |  |  |  | Salesman111 | Item-5
Salesman111 | Item-6 |  |  |  |  |  | 0.1111111111111111 |  |  |  |  |  | Salesman111 | Item-6 |  |  |  | 0.1111111111111111
Salesman111 | Item-7 |  |  | 0.1111111111111111 |  |  |  |  |  |  |  |  | Salesman111 | Item-7 |  | 0.1111111111111111
Salesman111 | Item-8 |  |  |  |  | 0.1111111111111111 |  |  |  |  |  |  | Salesman111 | Item-8 |  |  | 0.1111111111111111
Salesman111 | Item-9 |  |  |  |  |  | 0.1111111111111111 |  |  |  |  |  | Salesman111 | Item-9 |  |  |  | 0.1111111111111111
Salesman121 | Item-1 |  |  |  |  |  |  | 0.5 |  |  |  |  | Salesman121 | Item-1 |  |  |  |  | 0.5
Salesman121 | Item-2 |  |  |  |  |  |  | 0.5 |  |  |  |  | Salesman121 | Item-2 |  |  |  |  | 0.5
Salesman131 | Item-1 |  |  |  |  |  |  |  |  | 1 |  |  | Salesman131 | Item-1 |  |  |  |  |  | 1
Salesamn141 | Item-1 |  |  |  |  |  |  |  |  |  | 1 |  | Salesamn141 | Item-1 |  |  |  |  |  |  | 1
Salesman141 | Item-2 |  |  |  |  |  |  |  |  |  |  |  | Salesman141 | Item-2
Spreadsheet: 82054d1282114309-count-rows-with-same-name-and-condition-countiftimar_v1
Sheet: Sheet1

 | Names | Yes
 | [NAME] | Y
 | [NAME] |  |  | Names | Total | No. of Y
 | [NAME] |  |  | [NAME] | #N/A
 | [NAME] | Y |  | [NAME]
 | [NAME] | Y |  | [NAME]
 | [NAME] |  |  | Fred
 | [NAME]
 | [NAME] | Y
 | [NAME]
 | [NAME] | Y
 | [NAME]
 | [NAME]
 | [NAME] | Y
 | Fred
 | Fred
 | [NAME] | Y
 | [NAME] | Y
 | [NAME] | Y
 | [NAME]
 | [NAME]
Spreadsheet: 814913d1674658370-changeable-gross-margin-s666-f-changeable-gross-margin-
Sheet: Sheet1

Purchase Cost | Original Price | List Price | Profit | GM %
100 | 140
50 | 65 |  |  |  |  |  |  |  |  | GM % | 0.5
45 | 52
125 | 165
Spreadsheet: 78273d1278661878-excel-2007-sumif-and-countif-book2
Sheet: Sheet1

10 | Approved | Verified | Cleared
12 | Approved | Verified | Pending
14 | Rejected | Verified | Cleared
16 | Rejected | Verified | Cleared
18 | Rejected | Verified | Cleared
20 | Approved | Verified | Pending
22 | Rejected | Verified | Pending
24 | Approved | Verified | Cleared
26 | Approved | Verified | Cleared
28 | Approved | Verified | Cleared
Spreadsheet: 125055d1318855489-dynamic-chart-offset-function-bank
Sheet: CashIn

 | Starting from | 3
 | Number to show | 3
 | 1 | 3000
 | 2 | 2500
 | 3 | 2900
 | 4 | 2700
 | 5 | 2650
 | 6 | 2600
 | 7 | 2550
 | 8 | 2500
 | 9 | 2450
 | 10 | 2400
 | 11 | 2350
 | 12 | 2300 |  | XValues | #N/A
 | 13 | 2250 |  | YValues | #N/A
 | 14 | 2200
 | 15 | 2150
 | 16 | 2100
 | 17 | 2050
 | 18 | 2000
 | 19 | 2500
 | 20 | 2400
 | 21 | 2750
 | 22 | 1900
 | 23 | 1750
 | 24 | 1800
 | 25 | 1850
 | 26 | 1900
 | 27 | 2100
 | 28 | 2200
 | 29 | 2253.33333333333
 | 30 | 2344.7619047619
 | 31 | 2436.19047619048
 | 32 | 2527.61904761905
 | 33 | 2619.04761904762
 | 34 | 2400
 | 35 | 2350
 | 36 | 2200
 | 37 | 2150
 | 38 | 2200
 | 39 | 2300
 | 40 | 2500
Spreadsheet: 877074d1723749979-determine-sequence-of-dates-and-then-assign-an-increasing-value-to-that-sequence-datesequence-1-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  | Result:
 |  |  |  |  |  |  |  | Name | Date | Sequence
 |  |  |  |  |  |  |  | [NAME] | 2024-02-12 00:00:00 | 0
 |  |  |  |  |  |  |  | [NAME] | 2024-02-16 00:00:00 | 0
 |  |  |  |  |  |  |  | [NAME] | 2024-02-20 00:00:00 | 1
 |  |  |  |  |  |  |  | [NAME] | 2024-02-21 00:00:00 | 1
 |  |  |  |  |  |  |  | [NAME] | 2024-02-27 00:00:00 | 0
 |  |  |  |  |  |  |  | [NAME] | 2024-03-05 00:00:00 | 0
 |  |  |  |  |  |  |  | [NAME] | 2024-05-20 00:00:00 | 2
 |  |  |  |  |  |  |  | [NAME] | 2024-05-21 00:00:00 | 2
 |  |  |  |  |  |  |  | [NAME] | 2024-05-25 00:00:00 | 0
 |  |  |  |  |  |  |  | [NAME] | 2024-06-04 00:00:00 | 3
 |  |  |  |  |  |  |  | [NAME] | 2024-06-05 00:00:00 | 3
 |  |  |  |  |  |  |  | [NAME] | 2024-06-14 00:00:00 | 0
 |  |  |  |  |  |  |  | [NAME] | 2024-06-27 00:00:00 | 0
 |  |  |  |  |  |  |  | [NAME] | 2024-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  | [NAME] | 2024-07-08 00:00:00 | 4
 |  |  |  |  |  |  |  | [NAME] | 2024-07-09 00:00:00 | 4
 |  |  |  |  |  |  |  | [NAME] | 2024-07-10 00:00:00 | 4
 |  |  |  |  |  |  |  | [NAME] | 2024-01-01 00:00:00 | 1
 |  |  |  |  |  |  |  | [NAME] | 2024-01-02 00:00:00 | 1
 |  |  |  |  |  |  |  | [NAME] | 2024-01-03 00:00:00 | 1
 |  |  |  |  |  |  |  | [NAME] | 2024-02-03 00:00:00 | 0
 |  |  |  |  |  |  |  | [NAME] | 2024-05-06 00:00:00 | 0
 |  |  |  |  |  |  |  | [NAME] | 2024-07-01 00:00:00 | 2
 |  |  |  |  |  |  |  | [NAME] | 2024-07-02 00:00:00 | 2
 |  |  |  |  |  |  |  | [NAME] | 2024-07-03 00:00:00 | 1
 |  |  |  |  |  |  |  | [NAME] | 2024-08-05 00:00:00 | 0
 |  |  |  |  |  |  |  | [NAME] | 2024-08-09 00:00:00 | 3
 |  |  |  |  |  |  |  | [NAME] | 2024-08-10 00:00:00 | 3
Spreadsheet: 852817d1702775245-formula-to-pick-character-based-on-name-and-date-my-requiremetns_lgs
Sheet: Sheet2

DATE |  |  |  |  |  |  |  |  | MY REQUIREMENTS
NAME | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 |  | NAME | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | ABSENT | LEAVE | MEDICAL
A | ABSENT |  |  |  |  | LEAVE | LEAVE |  | C
B |  |  | ABSENT | MEDICAL |  |  |  |  | B
C | MEDICAL |  | MEDICAL |  |  | ABSENT |  |  | D
D | ABSENT |  |  | MEDICAL |  |  | LEAVE
Spreadsheet: 150834d1334689447-using-if-formula-when-a-cell-contains-a-formula-ks3-level-calculator
Sheet: Sheet1

Name | Listening | Reading | Writing | Speaking | overall |  |  |  |  | L number | R number | W number | S number | total | average
TEST | 5b | 6b | 4c | 3b
TEST2 | 1a | 1c | 1b | 2c
Spreadsheet: 79292d1279567010-transpose-range-into-table-book13
Sheet: Sheet1

AA
B |  |  | [NAME]. 1
C |  |  | AA | D | G | JJ | MM |  | 1 | 4 | 7 | 10 | 13
D |  |  | B | EE | H | KK | N |  | 2 | 5 | 8 | 11 | 14
EE |  |  | C | F | I | L | O |  | 3 | 6 | 9 | 12 | 15
F
G
H
I |  |  | [NAME]. 2
JJ |  |  | AA | B | C | D | EE |  | 1 | 2 | 3 | 4 | 5
KK |  |  | F | G | H | I | JJ |  | 6 | 7 | 8 | 9 | 10
L |  |  | KK | L | MM | N | O |  | 11 | 12 | 13 | 14 | 15
MM
N
O |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  | 11 | 12 | 13 | 14 | 15
 |  |  | 1 | 4 | 7 | 10 | 13
 |  |  | 2 | 5 | 8 | 11 | 14
 |  |  | 3 | 6 | 9 | 12 | 15
Spreadsheet: 792115d1660744465-formula-for-counting-dates-as-one-with-multiple-entries-within-a-week-number-sameplebook
Sheet: Sheet2

Week number | Date | Hours worked
1 | 2022-08-16 00:00:00 | 4 |  | Week | No. |  |  |  |  |  |  |  |  |  |  |  | Column A represents the week number. Column B is a list of daily entries, to be counted as 1 day though it might contain 3-20 entries. Column C to represent hours worked. Cell H1 is my existing formula that will count the number of days, but I need it to include the week number as a condition to check (cell M1).
1 | 2022-08-16 00:00:00 | 5 |  | 2
2 | 2022-08-16 00:00:00 | 6
2 | 2022-08-16 00:00:00 | 7
2 | 2022-08-19 00:00:00 | 0
3 | 2022-08-17 00:00:00 | 9
3 | 2022-08-18 00:00:00 | 8
3 | 2022-08-17 00:00:00 | 7
3 | 2022-08-20 00:00:00 | 6
4 | 2022-08-16 00:00:00 | 5
4 | 2022-08-17 00:00:00 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example: By checking how many day-entries in week 2, the desired value should be 2 since there are 2 different dates within week 2. If we were to check for week 1, then the desired value would be 1 since the work hours recorded were on the same day.
Spreadsheet: 136174d1326460145-retrieve-row-of-data-only-when-a-certain-word-is-in-a-particular-cell-in-that-row-example
Sheet: Sheet1

Date | Source | Supplier | Material Type | Assay No | [NAME] | [NAME] | Heavies | [NAME] | [NAME] | Stones | Fines | % [NAME] | % Hvy
2009-01-04 00:00:00 | Internal | R | GRANULATED ALI |  | 25.93 |  |  |  |  |  |  | 0 | 0
2009-01-05 00:00:00 | Group | A | ASR PLANT |  | 116.79 |  |  |  |  |  |  | 0 | 0
2009-01-06 00:00:00 | Group | N | +15M RESIDUE | 4695 | 25.42 | 7.81 | 5.42 | 0.32 | 0.53 | 3.55 | 0 | 0.3072383949645948 | 0.2132179386309992
2009-01-07 00:00:00 | Group | Not | 55% NF | 4691 | 47.38 | 11.89 | 5.88 | 0.82 | 1.22 | 4.3 | 3.94 | 0.2509497678345293 | 0.1241029970451667
2009-01-08 00:00:00 | Group | Not | 55% NF | 4690 | 48.4 | 14.95 | 5.1 | 0.95 | 2.37 | 4.6 | 4.19 | 0.3088842975206612 | 0.1053719008264463
2009-01-09 00:00:00 | Group | A | RESIDUE | 4692 | 25.32 | 7.01 | 4.4 | 1.35 | 3.43 | 3.29 | 4.65 | 0.2768562401263823 | 0.1737756714060032
2009-01-10 00:00:00 | Group | A | FLUFFY | 4693 | 17.16 | 3.67 | 0.3 | 0 | 0 | 0 | 0 | 0.2138694638694639 | 0.01748251748251748
2009-01-11 00:00:00 | Internal | R | GRANULATED ALI |  | 26.24 |  |  |  |  |  |  | 0 | 0
2009-01-12 00:00:00 | Group | LM | ASR PLANT |  | 20 |  |  |  |  |  |  | 0 | 0
2009-01-13 00:00:00 | NonGroup | MW | RESIDUE | 4698 | 145.84 | 2.23 | 13.25 | 4.31 | 1.73 | 11.25 | 0 | 0.01529072956664838 | 0.09085298957761931
2009-01-14 00:00:00 | NonGroup | S | RESIDUE | 4700 | 125.2 | 5.54 | 11.33 | 3.22 | 2.14 | 7.96 | 12.25 | 0.04424920127795527 | 0.09049520766773163
2009-01-15 00:00:00 | NonGroup | LB | RESIDUE | 4699 | 85.56 | 1.53 | 3.2 | 0.98 | 1.6 | 2.43 | 2.82 | 0.01788218793828892 | 0.03740065451145395
2009-01-16 00:00:00 | Group | LM | ASR PLANT |  | 20.56 |  |  |  |  |  |  | 0 | 0
2009-01-17 00:00:00 | Internal | R | GRANULATED ALI |  | 80.57 |  |  |  |  |  |  | 0 | 0
2009-01-18 00:00:00 | Internal | R | [NAME] |  | 14.65 |  |  |  |  |  |  | 0 | 0
2009-01-19 00:00:00 | Group | LM | ASR PLANT |  | 122.39 |  |  |  |  |  |  | 0 | 0
2009-01-20 00:00:00 | Group | A | RESIDUE | 4708 | 49.98 | 11.43 | 6.81 | 2.82 | 0.87 | 4.39 | 2.32 | 0.2286914765906363 | 0.1362545018007203
2009-01-21 00:00:00 | Group | N | 55% NF | 4704 | 48.48 | 12.35 | 7.88 | 0.7 | 1.29 | 4.55 | 4.73 | 0.2547442244224423 | 0.1625412541254125
Spreadsheet: 106410d1303663632-project-sales-based-on-known-awards-amount-over-time-pyojext-sales
Sheet: Sheet1

 | Total Salse | 2000000
 | Periods (Months | 12
 | Distributer | 13.84615384615385
 | Adjustment | 8.235740977460733 | By [NAME]
 | Calculated total | 2000000
 | Jan | 58116.36 | 1
 | Feb | 112855.22 | 2
 | Mar | 161035.34 | 3
 | Apr | 199856.67 | 4
 | May | 227063.05 | 5
 | Jun | 241073.36 | 6
 | Jul | 241073.36 | 7
 | Aug | 227063.05 | 8
 | Sep | 199856.67 | 9 |  |  |  |  | 15
 | Oct | 161035.34 | 10
 | Nov | 112855.22 | 11
 | Dec | 58116.36 | 12
 | Jan | 0 | 13
 | Feb | -58116.36 | 14
Spreadsheet: 759488d1639574804-need-multiple-values-from-lookup-value-sum-100
Sheet: Main Data

Emp Number | Emp Name | Cost center | STAFFING PERCENTAGE |  |  |  |  |  |  |  |  |  | Emp Number | Emp Name | Cost center | STAFFING PERCENTAGE
128745 | [NAME] | T85755 | 100
128756 | [NAME] bhailalbhai Kothiya | T85755 | 100
128759 | [NAME] | T85755 | 100
128799 | [NAME] | T85755 | 100
128754 | VENU GOPAL MANGENA | T85755 | 100
128750 | [NAME] | T85755 | 100
128751 | [NAME] | T85755 | 100
128752 | [NAME] | T85755 | 100
128753 | [NAME] | T85755 | 100
128778 | [NAME] | T85755 | 100
128755 | MUKESH KUMAR | T85755 | 100
128791 | [NAME] | T82301 | 50
128791 | [NAME] | T82302 | 50
128792 | Deepak Dalal | T82289 | 99
128792 | Deepak Dalal | T82290 | 1
128793 | [NAME] | T82289 | 50
128793 | [NAME] | T82290 | 50
128794 | [NAME] | T82295 | 50
128794 | [NAME] | T82296 | 50
128795 | ASHISH BHARTI | T27666 | 50
128795 | ASHISH BHARTI | T27667 | 50
128796 | BVBR RAJESH | T89765 | 15
128796 | BVBR RAJESH | T89766 | 35
128796 | BVBR RAJESH | T89767 | 30
128797 | [NAME] | T14567 | 80
128797 | [NAME] | T14568 | 15
128797 | [NAME] | T14569 | 5
Spreadsheet: 37487d1235525872-vlookup-data-and-return-results-on-multiple-entries-attended-list-trial
Sheet: LIST

Name | Account # | Event Attended | Date Attended
[NAME] | 123 | Raptors
[NAME] | 112 | Leafs
[NAME] | 225 | AC/DC
[NAME] | 1121 | Leafs
[NAME] | 123 | AC/DC
[NAME] | 112 | Raptors
Spreadsheet: 722493d1615299410-would-like-help-with-combining-prices-on-multiple-catagories-test-doc
Sheet: Sheet1

 | Product | Cost |  | Addon | Cost |  | Size | Cost
 | Test 1 | 10 |  | Dew | 1.99 |  | Small | 30
 | Test 2 | 11 |  | Rib | 1.99 |  | Medium | 40
 | Test 3 | 12 |  | Choc | 8.99 |  | Large | 50
 | Test 4 | 13
 | Test 5 | 14
Spreadsheet: 121962d1316528172-ongoing-database-auto-cut-paste-dub-list-template
Sheet: Pretty Dub List Appears Here

OnAir # | Title | Length | Commercial Code | Advertiser | Format | SourceTypeId | Comment | Ingest (printed) | Viewed (printed) | Review (printed) | FINISHED
Spreadsheet: 63993d1264847549-excel-2007-calculating-number-of-units-without-vlookup-comp-sci-good
Sheet: Sheet6

Course | Units | % Grade | [NAME]
CS 1TA3 | 3 | 0.027 | 0(F)
Psych 1X03 | 3 | 0.6929166666666666 | 6(C+)
Math 1f03 | 3 | 0.8833333333333333 | 11(A)
Econ 1b03 | 3 | 0.75 | 8(B)
Sociology 1A06 | 6 | 1 | 12(A+)
Semester Average | 0.725541666666667(B-)
Max% | [NAME] | Alpha | GPA
0 | 0 | (F) | 0
0.5 | 1 | (D-) | 0.7
0.53 | 2 | (D) | 1
0.57 | 3 | ([NAME]) | 1.3
0.6 | 4 | (C-) | 1.7
0.63 | 5 | (C) | 2
0.67 | 6 | (C+) | 2.3
0.7 | 7 | (B-) | 2.7
0.73 | 8 | (B) | 3
0.77 | 9 | ([NAME]) | 3.3
0.8 | 10 | (A-) | 3.7
0.85 | 11 | (A) | 3.9
0.9 | 12 | (A+) | 4
Course | Units
Cs 1TA3 | 3
Psych 1X03 | 6
Math 1f03 | 3
Econ 1b03 | 3
Sociology 1A06 | 6
Spreadsheet: 3762bb3e-ff30-4c52-af6f-89699272ea5d
Sheet: Sheet1

CERTIFICATION TEST PASS RATES*  ([NAME] and Updated 11/7/11)
 | COMPLETION YEAR 2005 |  |  |  |  |  | COMPLETION YEAR 2006 |  |  |  |  |  | COMPLETION YEAR 2007 |  |  |  |  |  | COMPLETION YEAR 2008 |  |  |  |  |  | COMPLETION YEAR 2009 |  |  |  |  |  | COMPLETION YEAR 2010 |  |  | COMPLETION YEAR 2011
 | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | FINAL |  |  | FINAL
Name of Test | Tests Taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate
Art (All-Level) *Last 2006* | 1 | 1 |  | 1 | 1 |  | 2 | 2 |  | 2 | 2 |  | 2 | 2 |  | 2 | 2 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Art (Secondary) *Last 2005* | 4 | 3 |  | 4 | 3 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Art (EC-12) *New 2006* | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 2 | 2 |  | 2 | 2 | 1 | 3 | 3 | 1 | 3 | 3 | 1 | - | - | - | 7 | 7 | 1
*Data obtained from Texas Education Agency's Accountability System for Educator Preparation (ASEP) report on pass rates sorted by Test.
*2010 Texas Education Agency starting using one yearly pass rate.