tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 675270d1588227777-pull-multiple-values-for-a-single-cell-with-vlookup-and-with-wildcard-excel-sample-1-
Sheet: Sheet1

SEARCH VALUE |  |  |  |  |  | Vlookup table
123 |  |  |  |  |  | Search value
345 |  |  |  |  |  |  | ABC123 | AAA
456 |  |  |  |  |  |  | 123XYZ | BBB
789 |  |  |  |  |  |  | A123 | CCC
 |  |  |  |  |  |  | 345 | CCC
 |  |  |  |  |  |  | 456 | GGG
 |  |  |  |  |  |  | 456Z | BBB
 |  | NEED | RESULT |  |  | OR
 |  |  |  |  |  | 123
 |  |  |  |  |  | 345
 |  |  |  |  |  | 456
 |  |  |  |  |  | 789
Spreadsheet: 99070e94-c2b3-4b64-b84a-05c53ca57b8b
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (3 Entries):
 | 6 Reagents, chemicals 6.8 Chemicals 6.8.1 Chemicals for electrophoresis
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Biozym Scientific GmbH | Germany | Hessisch Oldendorf | 31840 | A3.321
2 | [NAME] [NAME] und Laborbedarf | Germany | Karlsruhe | 76185 | B1.303/406
3 | SERVA Electrophoresis GmbH | Germany | Heidelberg | 69115 | A3.360
Spreadsheet: 80438d1280658852-adding-range-of-data-top10
Sheet: Sheet1

Week | Product | Qty | Value |  |  |  | Values |  |  | Dynamic Named Range Pivot_Range for Pivot Table Data Source =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),4)
Week 1 | Product 1 | 88 | 233 |  |  | Row Labels | Sum of Qty | Sum of Value |  | Subtotal Product
Week 1 | Product 2 | 66 | 133 |  |  | Product 6 | 240 | 3044 |  | Data Sort on Sum Of Value for Product Subtotal Largest to Smallest
Week 1 | Product 3 | 66 | 413 |  |  | Week 1 | 71 | 733 |  | Filter Product Top 10 By Sum Of Value
Week 1 | Product 4 | 100 | 854 |  |  | Week 2 | 73 | 635 |  | Refresh the Pivot Table if the Data Source is added to or if any values change
Week 1 | Product 5 | 42 | 572 |  |  | Week 3 | 48 | 838
Week 1 | Product 6 | 71 | 733 |  |  | Week 4 | 48 | 838
Week 1 | Product 7 | 65 | 148 |  |  | Product 9 | 102 | 2690
Week 1 | Product 8 | 13 | 437 |  |  | Product 5 | 143 | 2453
Week 1 | Product 9 | 44 | 638 |  |  | Product 10 | 149 | 2359
Week 1 | Product 10 | 84 | 330 |  |  | Product 8 | 147 | 2329
Week 2 | Product 1 | 79 | 924 |  |  | Product 7 | 195 | 2128
Week 2 | Product 2 | 28 | 507 |  |  | Product 1 | 226 | 2017
Week 2 | Product 3 | 93 | 734 |  |  | Week 1 | 88 | 233
Week 2 | Product 4 | 57 | 526 |  |  | Week 2 | 79 | 924
Week 2 | Product 5 | 24 | 951 |  |  | Week 3 | 59 | 860
Week 2 | Product 6 | 73 | 635 |  |  | Product 11 | 74 | 1686
Week 2 | Product 7 | 48 | 484 |  |  | Product 2 | 143 | 1640
Week 2 | Product 8 | 40 | 764 |  |  | Product 12 | 96 | 1564
Week 2 | Product 9 | 28 | 122 |  |  | Grand Total | 1515 | 21910
Week 2 | Product 10 | 13 | 221
Week 3 | Product 1 | 59 | 860
Week 3 | Product 2 | 49 | 1000
Week 3 | Product 5 | 77 | 930
Week 3 | Product 6 | 48 | 838
Week 3 | Product 7 | 41 | 748
Week 3 | Product 8 | 47 | 564
Week 3 | Product 9 | 15 | 965
Week 3 | Product 10 | 26 | 904
Week 3 | Product 11 | 37 | 843
Week 3 | Product 12 | 48 | 782
Week 3 | Product 13 | 59 | 721
Week 3 | Product 14 | 70 | 660
Week 3 | Product 15 | 81 | 599
Week 3 | Product 16 | 92 | 538
Week 3 | Product 17 | 103 | 477
Week 3 | Product 18 | 114 | 416
Week 3 | Product 19 | 125 | 355
Week 3 | Product 20 | 136 | 294
Week 4 | Product 6 | 48 | 838
Week 4 | Product 7 | 41 | 748
Week 4 | Product 8 | 47 | 564
Week 4 | Product 9 | 15 | 965
Week 4 | Product 10 | 26 | 904
Week 4 | Product 11 | 37 | 843
Week 4 | Product 12 | 48 | 782
Week 4 | Product 13 | 59 | 721
Week 4 | Product 14 | 70 | 660
Week 4 | Product 15 | 81 | 599
Week 4 | Product 16 | 92 | 538
Week 4 | Product 17 | 103 | 477
Week 4 | Product 18 | 114 | 416
Week 4 | Product 19 | 125 | 355
Week 4 | Product 20 | 136 | 294
Spreadsheet: 86409d1286389491-drop-down-list-starting-from-middle-example
Sheet: Example

 |  |  |  |  |  |  |  | Category | Fruits | Vegetables | Office.supplies
 | Category | Type |  |  |  |  |  | Fruits | Apples | Onions | Paper
 | Fruits |  |  |  |  |  |  | Vegetables | Bananas | Potatoes | Pens
 | Vegetables |  |  |  |  |  |  | Office.supplies | Oranges | Lettuce | Pencils
 | Office.supplies | Pens |  |  |  |  |  |  | Pears | Spinace | Notebooks
Spreadsheet: 769985d1645764700-sums-of-dynamic-unique-values-with-multiple-criteria-sample-tests
Sheet: Calculation

 | Selected Information (Form Controls) |  |  |  |  |  |  |  |  |  |  | Calculation for scrolling table
 |  | Selected Type | 1
 |  | Selected Year | 1
 |  | Selected Bug | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | Year
 | For Drop_down selections |  |  |  |  | Types data |  |  |  |  |  |  |  |  |  |  | difference from  previous year
 | Year | Type | Values |  |  |  | gram_positive |  |  |  |  | Nr. | Type | isolates_tested | isolates_susceptible | %susceptibility | Δ% susceptibility
 | 2018 | gram_negative | isolates_tested |  |  | Amikacin-Citrobacter freundii | Ampicillin-Enterococcus spp.
 | 2019 | gram_positive | isolates_susceptible |  |  | Amikacin-Klebsiella pneumoniae | Group A Strep-Penicillin
 | 2020 |  | %susceptibility |  |  | Amikacin-Proteus mirabilis | Group B Strep-Penicillin
 |  |  |  |  |  | [NAME] cloacae complex | Linezolid-MRSA
 |  |  |  |  |  | [NAME] morganii | Penicillin-Staphylococcus aureus
 |  |  |  |  |  | [NAME] coli | Linezolid-MSSA
 |  |  |  |  |  | Ertapenem-Acinetobacter baumannii | Penicillin-MRSA
 |  |  |  |  |  | Ertapenem-E. coli | Penicillin-MSSA
 |  |  |  |  |  | Tobramycin-Klebsiella aerogenes
 |  |  |  |  |  | Imipenem-Citrobacter freundii
 |  |  |  |  |  | Meripenem-Citrobacter freundii
 |  |  |  |  |  | Amikacin-E. coli
 |  |  |  |  |  |  |  |  |  |  |  |  | Calculations for headers
 |  |  |  |  |  |  |  |  |  |  |  |  | Hospital Numbers
 |  |  |  |  |  |  |  |  |  |  |  |  | isolate_hospital_n | `=sum of unique values  for each "type",  "year" and "bug" | *** one result from the data is that the isolates_hospital_n  sum for Citrobacter Freundii bug is 13 and not 39. and for MSSA is 66 and not 132.
Spreadsheet: 60478d1260997036-excel-2007-highest-expense-sample-books
Sheet: Income

Date | Company | Customer | Description | Paid |  | Total
2009-06-10 00:00:00 |  |  |  | 1000 |  | 1000
2009-12-10 00:00:00 |  |  |  | 400 |  | 400
15/10/2009 |  |  |  | 2525 |  | 2525
17/10/2009 |  |  |  | 2000 |  | 2000
19/10/09 |  |  |  | 600 |  | 600
21/10/09 |  |  |  | 374 |  | 374
28/10/09 |  |  |  | 1597
2009-01-11 00:00:00 |  |  |  | 5300 |  | 5300
2009-11-11 00:00:00 |  |  |  | 300 |  | 300
2009-11-11 00:00:00 |  |  |  | 400 |  | 400
2009-11-11 00:00:00 |  |  |  | 360 |  | 360
2009-12-11 00:00:00 |  |  |  | 1623 |  | 1623
2009-12-11 00:00:00 |  |  |  | 150 |  | 150
18/11/2009 |  |  |  | 225 |  | 225
25/11/09 |  |  |  | 750 |  | 750
26/11/09 |  |  |  | 250 |  | 250
2009-01-12 00:00:00 |  |  |  | 575 |  | 575
2009-04-12 00:00:00 |  |  |  | 1200 |  | 1200
Spreadsheet: tracy_geaccone__40401__GPM 101021  101073 Recalculation
Sheet: Apr 2000

KN Processing |  | GPM Agency Agreement |  |  | Prepared by [NAME]
Bushton Plant |  | TFDV Volume & Dollar Calculation
 |  | For
 |  | 2000-04-01 00:00:00
Contract #101021 |  |  | NNG Numbers |  |  | Oneok Numbers |  |  | Difference
 | Total Deliveries |  |  | 3015339 |  |  | 3015339
 |  | Deliveries to Inlet | 2891820 |  |  | 2891820
 |  | Deliveries to PVR
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 3016689 |  |  | 3016689
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
Contract #101073
 | Total Deliveries |  |  | 1375708 |  |  | 1357069
 |  | Deliveries to Inlet | 0
 |  | Deliveries to PVR | 1316614 |  |  | 1298524
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 1530706 |  |  | 1357069
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
 |  | Total Both Contracts
 |  | Index |  | 2.898 |  |  | 2.901
 |  | Total Revenue Due
Total Revenue Billed |  | 101021 |  | 29410.01
 |  | 101073
 |  |  |  |  |  |  | 36464.38
 |  | Amount Due NNG (GPM)
Charge given by NNG on prior reconciliation
 |  | Amount Due NNG (GPM)
Spreadsheet: 59800d1260355102-if-formula-in-sumproduct-test
Sheet: Sheet1

Date | Item | Sales |  | List of items |  | Current item: | A
2009-01-01 00:00:00 | A | 10 |  | ALL |  | Total sales:
2009-01-01 00:00:00 | B | 20 |  | A
2009-01-01 00:00:00 | C | 30 |  | B
2009-02-01 00:00:00 | A | 10 |  | C
2009-02-01 00:00:00 | B | 20
2009-02-01 00:00:00 | C | 30
2009-03-01 00:00:00 | A | 10
2009-03-01 00:00:00 | B | 20
2009-03-01 00:00:00 | C | 30
Spreadsheet: 844036d1695832381-help-to-calculate-trend-book2-10-
Sheet: Sheet1

 |  | Type | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 |  |  |  |  | Rate of chagne
 |  | Bananas | 233 | 206 | 191 | 182 | 170 | 156 | 151 | 134 | 129 | 113 | 107 | 0 | 0
 |  | Bananas | 310 | 249 | 205 | 192 | 176 | 162 | 158 | 138 | 136 | 118 | 112 | 0 | 0
 |  | Bananas | 188 | 156 | 130 | 119 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Bananas | 157 | 128 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Bananas | 278 | 280 | 275 | 272 | 268 | 260 | 255 | 242 | 230 | 221 | 206 | 199 | 192
 |  | Bananas | 2000 | 1987 | 1975 | 1966 | 1950 | 1928 | 1893 | 1845 | 1765 | 1685 | 1597 | 1493 | 1391
 |  | Bananas | 564 | 558 | 555 | 551 | 547 | 541 | 536 | 531 | 509 | 484 | 458 | 430 | 396
 |  | Bananas | 624 | 619 | 618 | 615 | 610 | 602 | 594 | 582 | 557 | 539 | 511 | 475 | 448
 |  | Bananas | 1522 | 1523 | 1521 | 1496 | 1457 | 1424 | 1397 | 1347 | 1298 | 1240 | 1198 | 1149 | 1103
 |  | Bananas | 237 | 236 | 235 | 235 | 233 | 232 | 230 | 224 | 218 | 211 | 203 | 191 | 174
 |  | Bananas | 358 | 354 | 347 | 344 | 334 | 331 | 327 | 316 | 309 | 296 | 289 | 283 | 272
 |  | Bananas | 291 | 288 | 285 | 282 | 280 | 278 | 275 | 273 | 268 | 266 | 258 | 248 | 243
 |  | Bananas | 196 | 201 | 199 | 198 | 194 | 191 | 191 | 189 | 186 | 185 | 183 | 181 | 179
 |  | Bananas | 855 | 853 | 852 | 850 | 845 | 839 | 835 | 830 | 822 | 815 | 810 | 802 | 787
 |  | Bananas | 936 | 988 | 1019 | 1032 | 1025 | 1015 | 1006 | 992 | 982 | 971 | 966 | 961 | 955
 |  | Bananas | 933 | 985 | 1036 | 1041 | 1034 | 1026 | 1021 | 1016 | 1002 | 990 | 981 | 974 | 964
 |  | Bananas | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 105 | 143
 |  | Bananas | 207 | 264 | 315 | 367 | 421 | 479 | 514 | 595 | 614 | 635 | 648 | 656 | 662
 |  | Bananas | 136 | 179 | 228 | 268 | 311 | 377 | 410 | 447 | 480 | 491 | 488 | 484 | 484
 |  | Bananas | 0 | 0 | 0 | 0 | 176 | 233 | 297 | 386 | 459 | 511 | 573 | 637 | 711
 |  | Bananas | 0 | 0 | 0 | 0 | 157 | 253 | 326 | 443 | 526 | 584 | 640 | 685 | 768
 |  | Bananas | 0 | 0 | 0 | 109 | 223 | 280 | 320 | 428 | 488 | 585 | 663 | 733 | 799
Spreadsheet: 771937d1646924815-returning-a-2nd-value-from-vlookup-overtime
Sheet: Sheet1

Overtime Report
Employee Name | Date | [NAME] | Approved by | Amount |  |  | Employee name
[NAME], [NAME] | 2012-03-10 00:00:00 |  |  | 10 | [NAME] -->
[NAME], [NAME] |  |  |  | 5 |  |  | [NAME], [NAME]
Artis, [NAME] |  |  |  | 25 |  |  | [NAME], [NAME]
[NAME], [NAME] |  |  |  | 10 |  |  | Artis, [NAME]
 |  |  |  |  |  |  | [NAME], [NAME]
 |  |  |  |  |  |  | Clemons, Tanahsa
 |  |  |  |  |  |  | Ashley, Zenadia
 |  |  | Total Hours
Highest Earners
Spreadsheet: darron_c_giron__7978__AGAVE
Sheet: April

Note: Insert the #'s in red to calculate the customer price
 | Crude Merc | IF-Elpaso Perm | IF-HH | IF-Elpaso/SJ | IF-TW-Permian
 | 19.727 | 1.63 | 1.85 | 1.59 | 1.61
 |  |  | Spot price |  | Index Price
CPR# | TAGG # | PanEnergy | Facility | Term | Calculated Price
72678 | E21728 | 2,500/day | 813780 | 7/95-12/2001
CPR# | TAGG # | Union Pacific | Facility | Term | Calculated Price
48853 | E11400 | 2,500/day | 813367 | 1/92-12/2003
CPR# | TAGG # | Union Pacific | Facility | Term | Calculated Price
3217 | E22656 | 7,000/day | 813367 | 1/95-12/2001
CPR# | TAGG # | Vastar | Facility | Term | Calculated Price
3231 | E21977 | 10,000/day | 501079 | 6/96-4/2002
CPR# | TAGG # | Agave/Yates | Facility | Term | Calculated Price
3585 | E20337 | 10,000/day | 58649 | 1/93-12/2002
Spreadsheet: 5250e326-b6cb-4384-bf3f-34cc1481cdde
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
IGAS | Test | IGAS | IgA Subclasses, Serum | IgA Subclasses, S | Nephelometry for Total IgA, IgA1, and IgA2 |  |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | IgA 0-<5 months: 7-37 mg/dL 5-<9 months: 16-50 mg/dL 9-<15 months: 27-66 mg/dL 15-<24 months: 36-79 mg/dL 2-<4 years: 27-246 mg/dL 4-<7 years: 29-256 mg/dL 7-<10 years: 34-274 mg/dL 10-<13 years: 42-295 mg/dL 13-<16 years: 52-319 mg/dL 16-<18 years: 60-337 mg/dL > or =18 years: 61-356 mg/dL  IgA1 0-<5 months: 10-34 mg/dL 5-<9 months: 14-41 mg/dL 9-<15 months: 20-50 mg/dL 15-<24 months: 24-58 mg/dL 2-<4 years: 16-162 mg/dL 4-<7 years: 17-187 mg/dL 7-<10 years: 21-221 mg/dL 10-<13 years: 27-250 mg/dL 13-<16 years: 36-275 mg/dL 16-<18 years: 44-289 mg/dL > or =18 years: 50-314 mg/dL  IgA2 0-<5 months: 0.4-5.5 mg/dL 5-<9 months: 1.5-6.2 mg/dL 9-<15 months: 2.8-7.0 mg/dL 15-<24 months: 3.9-7.7 mg/dL 2-<4 years: 1.3-31.1 mg/dL 4-<7 years: 1.1-39.1 mg/dL 7-<10 years: 1.4-48.0 mg/dL 10-<13 years: 2.6-53.4 mg/dL 13-<16 years:  4.7-55.1 mg/dL 16-<18 years: 6.6-54.3 mg/dL > or =18 years: 9.7-156.0 mg/dL | Monday through Saturday; Continuously | 1 day | 2 days |  | Profile |  |  |  |  | Rochester
IGAS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
IGAS | Result | IGA_ | IgA | IgA | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2458-8
IGAS | Result | IGA1_ | IgA1 | IgA1 | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 6886-6
IGAS | Result | IGA2_ | IgA2 | IgA2 | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 6939-3
IGAS | Billing Component | IGAS |  | IGG 1 2 3 OR 4 EACH |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 82787
IGAS | Billing Component | IGAS |  | Gammaglobulin; IgA,IgD,IgG,IgM,each |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 82784
Spreadsheet: 00a7561e-b9c0-4af9-bb29-b3ff16b9f812
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Invoice No. | Unnamed: 6 | Unnamed: 7
INVOICE FOR TRANSCRIPT PREPARATION
BY STATE-EMPLOYED COURT REPORTER
►Please type or print information.
County |  |  |  | Case Number
Case Caption |  |  |  | Type and Date of Proceeding
Quantity of pages | Description | Rate per page | Amount |  | This transcript is for:
 | §814.69(1)(a) Originals | 1.5 | 0
 | §814.69(1)(a) Duplicates | 0.5 | 0
 | §814.69(1)(b) Originals | 2.25 | 0
 | §814.69(1)(b) Duplicates | 0.5 | 0 |  | This transcript was requested by:
 | §814.69(1)(bm) Originals | 3 | 0
 | §814.69(1)(bm) Duplicates | 0.75 | 0
 | §814.69(1)(c) Originals |  | 0
 | §814.69(1)(c) Duplicates |  | 0
Postage paid or charges for electronic copies (CDs, disks)
Subtotal |  |  | 0
Less credit for prepayment, county copying costs or other credit as applicable
Net Total Due |  |  | 0
I certify that the total amount shown was computed in accordance with §814.69, Wis. Stats., and that I have not previously applied for or received payment for this amount.
Court Reporter's Signature |  |  | Date | County |  |  | Branch No.
Social Security Number |  |  |  | Telephone Number
[NAME] to: |  |  | Make check payable to and send to: |  |  | Send copy of invoice to:
 |  |  |  |  |  | Director of State Courts
 |  |  |  |  |  | Management Services
 |  |  |  |  |  | 110 E. Main Street, Ste 430
 |  |  |  |  |  | [NAME], WI  53703
Spreadsheet: 287774d1388987850-require-help-to-pull-figure-base-on-character-test-99-
Sheet: Sheet4

Sr. | Material No. | Description of material | Unit | Material received at site as per SAP | [NAME] | Mat Out | Net Qty of receipt of material | Qty as per Theoretical Consumption | Qty as per Actual Consumption | Physical Balance Stock at Site | Actual Difference in Actual consumption and total theorotical consumption = I - H
A |  | B | C | D | E | F | G=D+E-F | H | I | J | K
 |  | TILLING WORK
1 | 1100016 | PART E | Sft | 68960.59 | 0 | 2559.39 | 66401.2 | 65479.7 | 66250.49 | 150.7099999999919 | 770.7900000000081
2 | 1100017 | PART F | Sft | 8816.53 | 938.787 |  | 9755.317000000001 | 8682.05 | 9736.872 | 18.44500000000153 | 1054.822
3 | 1100018 | PART G | Sft | 7252.2 |  | 468.05 | 6784.15 |  | 7030 | -245.8500000000004 | 7030
4 | 1100019 | PART H | Sft | 2750 |  | 350 | 2400 |  | 2400 | 0 | 2400
5 | 1100020 | PART I | Sft | 0 |  |  | 0 |  |  | 0 | 0
6 | 1100047 | PART J | Sft | 3600 | 1435 |  | 5035 |  | 4785 | 250 | 4785
7 | 1100048 | PART K | Sft | 4393.069 |  | 209.309 | 4183.759999999999 |  | 3579.26 | 604.4999999999991 | 3579.26
8 | 1100050 | PART L | Sft | 10985.661 |  | 1124.544 | 9861.117 |  | 9594.4 | 266.7170000000006 | 9594.4
9 | 1100053 | PART M | Sft | 0 |  |  | 0 |  | 0 | 0 | 0
10 | 1100056 | PART N | Sft | 0 |  |  | 0 |  | 0 | 0 | 0
11 | 1100057 | PART O | Sft | 12169.497 |  | 1163.67 | 11005.827 |  | 10679 | 326.8269999999993 | 10679
12 | 1100094 | PART P | Sft | 2046.862 |  | 377.63 | 1669.232 |  | 1669.232 | 0 | 1669.232
13 | 1100103 | PART Q | Sft | 5465.16 |  | 754.28 | 4710.88 |  | 4086.27 | 624.6100000000001 | 4086.27
14 | 1100116 | PART R | Sft |  |  |  | 0 |  |  | 0 | 0
15 | 1100121 | PART S | Sft | 8684.645 |  | 1077.829 | 7606.816000000001 |  | 6416 | 1190.816000000001 | 6416
16 | 1100144 | PART T | Sft | 8351.752 |  | 2590.752 | 5761 |  | 5961 | -200 | 5961
17 | 1100156 | PART U | Sft | 0 |  |  | 0 |  | 0 | 0 | 0
18 | 1100171 | PART V | Sft | 3581.91 |  | 531.91 | 3050 |  | 3050 | 0 | 3050
19 | 1100175 | PART W | Sft | 0 |  |  | 0 |  |  | 0 | 0
20 | 1100198 | PART X | Sft | 0 | 1832.83 |  | 1832.83 |  | 1404 | 428.8299999999999 | 1404
Spreadsheet: 121495d1316098150-strange-error-message-example3
Sheet: Sheet1

 | [NAME] | [NAME] | [NAME] | 0 | 1 | 1
 | [NAME] | [NAME] | [NAME] | 0 | 0 | 0
 | [NAME] | [NAME] | [NAME] | 0 | 0 | 0
 | [NAME] | [NAME] | [NAME] | 0 | 0 | 0
 | 0 | 1 | 1 | 0 | 0 | 0
 | 0 | 1 | 1 | 0 | 0 | 0
 | 0 | 1 | 1 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 703117d1604762803-how-to-count-the-quantity-per-piece-and-box-inventory-quantity-ans
Sheet: Sheet1

 |  |  |  | warehouse |  | sales |  | answer |  |  | answer
 | P name | Pieces/box | Purchase | box | pieces | box | pieces | box | pieces |  | box | pieces
 | P1 | 12 | 13 | 0 | 8 | 1 | 8 |  |  |  | 12 | 4 | ?
 | P2 | 4 | 5 | 2 | 2 | 0 | 1 |  |  |  | 7 | 1
 | P3 | 40 | 1 | 3 | 20 | 0 | 50 |  |  |  | 3 | 10
 | P4 | 32 | 2 | 6 | 0 | 1 | 16 |  |  |  | 3 | 16
Spreadsheet: 069e12e4-0092-4916-8fa7-0b38049d0ce9
Sheet: Sheet1

Instructions | Please fill in the yellow cells | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Optional additional labels
 | Pasteur to fill in
Investigator Name | Your Name Here
Project Name | Project Name Here
Experiment Name | Experiment Name Here
Date | (YYYY-MM-DD)
Manifest
Reception Date | (YYYY-MM-DD)
Plate Barcode
Plate Name
Plate Description
Sample_Well | Sample_ID | Individual ID | Volume (ul) | Concentration (ng/ul) | Site of Origin | Tissue Source | Gender | Pedigree | Mother ID | Father ID | Comment
A01 | 1
A02 | 2
A03 | 3
A04 | 4
A05 | 5
A06 | 6
A07 | 7
A08 | 8
A09 | 9
A10 | 10
A11 | 11
A12 | 12
B01 | 13
B02 | 14
B03 | 15
B04 | 16
B05 | 17
B06 | 18
B07 | 19
B08 | 20
B09 | 21
B10 | 22
B11 | 23
B12 | 24
C01 | 25
C02 | 26
C03 | 27
C04 | 28
C05 | 29
C06 | 30
C07 | 31
C08 | 32
C09 | 33
C10 | 34
C11 | 35
C12 | 36
D01 | 37
D02 | 38
D03 | 39
D04 | 40
D05 | 41
D06 | 42
D07 | 43
D08 | 44
D09 | 45
D10 | 46
D11 | 47
D12 | 48
E01 | 49
E02 | 50
E03 | 51
E04 | 52
E05 | 53
E06 | 54
[NAME] | 55
E08 | 56
E09 | 57
E10 | 58
E11 | 59
E12 | 60
F01 | 61
F02 | 62
F03 | 63
F04 | 64
F05 | 65
F06 | 66
F07 | 67
F08 | 68
F09 | 69
[NAME] | 70
F11 | 71
F12 | 72
G01 | 73
G02 | 74
G03 | 75
G04 | 76
G05 | 77
[NAME] | 78
G07 | 79
G08 | 80
[NAME] | 81
G10 | 82
G11 | 83
G12 | 84
H01 | 85
H02 | 86
H03 | 87
H04 | 88
H05 | 89
H06 | 90
H07 | 91
H08 | 92
H09 | 93
H10 | 94
H11 | 95
H12 | 96
Spreadsheet: 90152d1289919940-repeating-cell-move-until-next-cell-is-empty-examplefile
Sheet: Sheet1

Before |  | After
a |  | a | b | c
b
c
d |  | d | e | f
e
f
g |  | g | h | i
h
i
Spreadsheet: 02ee9135-7d6c-4bdf-8630-68daa6aca0e9
Sheet: Sheet1

FY: | [NAME]: | Amendment #, if Applicable: | Unnamed: 3 | Unnamed: 4 | If Federal Funds, CFDA #:
PURCHASE OF SERVICE
ATTACHMENT 4: RATE CALCULATION/MAXIMUM OBLIGATION CALCULATION PAGE
Program Name: | Document ID#: | MMARS | Program Type: | UFR Prog. #:
 |  | Act. Code:
AMENDMENT #, IF APPLICABLE:
UNIT RATE CALCULATION
1. Program Total Costs |  |  |  |  | 0
2a.    Program Offsets: |  | Source |  | Amount
 |  | _______________ |  | 0
 |  | _______________ |  | 0
 |  | _______________ |  | 0
 |  | _______________ |  | 0
2b.   Offsets for Non-Reimbursable Costs: |  | _______________ |  | 0
Note: Total non-reimbursable costs listed in line 2b must be detailed on Attachment 5.
2.  Subtotal Offsets (Line 2a + Line 2b) |  |  |  |  | 0
3.   Net Adjusted Program Costs (LINE 1 minus LINE 2) |  |  |  |  | 0
4.   Total Program Capacity |  | 0 | (# of units) | ______  (Type of unit)
5.   Share of Total Capacity Purchased by Contract |  | 0 | (# of units) |  | (% of line 4)
6.   Negotiated Utilization Factor, if any |  | 0
7.   Adjusted Capacity Used to Establish Price (LINE 4 x LINE 6) |  | 0 | (# of units)
8.   Unit Rate (LINE 3 DIVIDED BY LINE 7)
9.   Maximum # of Billable Units (LINE 5 x LINE 6) |  |  |  | 0
_______________________________________________________________________________________________________
_______________________________________________________________________________________________________
OTHER PRICE CALCULATION METHOD
10.   Enter relevant information:______________________________________________________________________________
_______________________________________________________________________________________________________
MAXIMUM OBLIGATION CALCULATION
11.  For Unit Rate: Line 8  X  Line 9
For Other Price Calculation Method, Enter Obligation From Line 10
For Cost Reimbursement: Enter Reimbursable Cost Total From Program Budget
12.   Invoice Offset | SOURCE |  | AMOUNT
 | ____________ |  | 0
 | ____________ |  | 0
 | ____________ |  | 0
12. Subtotal |  |  |  |  | 0
13. Maximum Obligation for the Program (LINE 11 minus LINE 12)
14.  Capital Budget (from Capital Budget Form), if applicable |  |  |  |  | 0
15.  Total  Maximum Obligation for Program    (LINE 13 + LINE 14)
FOR INFORMATION ONLY: | Other Revenue Sources (Only if % in LINE 5 is less than 100%)
SOURCE | AMOUNT
______________________________ | 0
______________________________ | 0
Updated 11/1/05