tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 693821d1599166017-excel-formula-for-tax-law-changes-1544-tax-calculations-2
Sheet: EMPLOYEE DATA

Employee data
Employee Code Number | Employee Name | Employee I.D Number | Date of Birth | Age | Disability | Motor Vehicle Benefit
CA1 | OLIVIA | 86000486 | 1974-05-30 00:00:00 |  | Yes | 2700cc
CA2 | BEAUTY | 12468300 | 1960-03-01 00:00:00 |  | No | [NAME]
CA3 | MARGARET | 220002002 | 1965-01-20 00:00:00 |  | Yes | 3001cc
CA4 | ENITA | 44804321 | 1976-04-03 00:00:00 |  | No
CA5 | EVERJOY | 44804333 | 1980-04-03 00:00:00 |  | No
CA6 | [NAME] | 44804333 | 1981-04-03 00:00:00 |  | No | 2500cc
Month | Period |  |  | Month | Period
2020-01-01 00:00:00 | 1 |  |  | 2020-08-01 00:00:00 | 8
Motor Vehicle benefit |  |  |  | Motor Vehicle benefit
Engine Capacity Value (Deemed Benefit per month) |  |  |  | Engine Capacity Value (Deemed Benefit per month)
1500cc or less | 1800 |  |  | 1500cc or less | 2800
1501cc to 2000 | 2400 |  |  | 1501cc to 2000 | 3400
2001cc to 3000cc | 3600 |  |  | 2001cc to 3000cc | 4600
Above 3000cc | 4800 |  |  | Above 3000cc | 5800
Month | Period |  |  | Month | Period
2020-01-01 00:00:00 | 1 |  |  | 2020-08-01 00:00:00 | 8
Other benefits |  |  |  | Other benefits
Disability benefit | 720 |  |  | Disability benefit | 1720
Elderly person benefit | 720 | 55  Years and above |  | Elderly person benefit | 1720 | 55  Years and above
Spreadsheet: 74ddd89a-7bb3-4eee-9f32-5642eeb55227
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
CARN | Test | CARN | Carnitine, Plasma | Carnitine, P | Flow Injection Analysis-Tandem Mass Spectrometry (FIA-MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Green top (sodium heparin) Acceptable: EDTA Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Forms: If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 0.2 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK <3 days-refreeze and note to lab; Cold OK <3 days-refreeze and note to lab Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	Plasma gel tube | Total Carnitine (TC)	Free Carnitine (FC)	Acylcarnitine (AC)	AC/FC Ratio Age Group	Range*	Range*	Range*	Range 1 day	23-68	12-36	7-37	0.4-1.7 2-7 days	17-41	10-21	3-24	0.2-1.4 8-31 days	19-59	12-46	4-15	0.1-0.7 32 days-12 months	38-68	27-49	7-19	0.2-0.5 13 months-6 years	35-84	24-63	4-28	0.1-0.8 7-10 years	28-83	22-66	3-32	0.1-0.9 11-17 years	34-77	22-65	4-29	0.1-0.9 > or =18 years	34-78	25-54	5-30	0.1-0.8 *Values expressed as nmol/mL Schmidt-Sommerfeld E, [NAME] E, [NAME] D: Carnitine plasma concentrations in 353 metabolically healthy children. Eur J Pediatr 1988;147:356-360 Used with permission of European Journal of Pediatrics, Springer-Verlag, New York, Inc., Secaucus, NJ | Monday through Friday; 7:30 a.m. | 2 days (not reported on Saturday or Sunday) | 5 days | 1 | 82379 |  |  |  |  | Rochester
CARN | [NAME] | PLASMA | Plasma |  |  |  | Frozen | 7 days
CARN | Result | 32050 | Total | Total | Numeric |  |  |  |  | nmol/mL |  |  |  |  |  |  |  |  |  | 14288-5
CARN | Result | 32051 | Free (FC) | Free (FC) | Numeric |  |  |  |  | nmol/mL |  |  |  |  |  |  |  |  |  | 14286-9
CARN | Result | 32052 | Acylcarnitine (AC) | Acylcarnitine (AC) | Numeric |  |  |  |  | nmol/mL |  |  |  |  |  |  |  |  |  | 14282-8
CARN | Result | 21032 | AC/FC Ratio | AC/FC Ratio | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30193-7
CARN | Result | 21549 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
Spreadsheet: 220077d1363047957-dates-in-excel-rfp-tracking-sheet
Sheet: Data Sheet

TA's | Plans | Communities
[NAME] | Masters | ALG
[NAME] | Lockport | AB
[NAME] | Alto | AR
[NAME] | Dillon | BM
Nikki Calder | Brooks | BTN
[NAME] | Bayside | BKV
[NAME] | Camden | BTF
[NAME] | Melrose | BC
[NAME] | Glenview | BDF
[NAME] | Glenview II | BF
[NAME] | Blake | BKM
BobbiAnn Helgeson | Dawson | BKS
[NAME] | Montcrest | CRP
[NAME] | Blake II | CT
[NAME] | Harper | CM
[NAME] | Coronado | COP
[NAME] | Coronado II | CS
[NAME] | Dublin | CRV
[NAME] | Hudson | CRL
[NAME] | Hudson II | DRV
Rae MacTaggart | Hudson III | EWC
[NAME] | Reese | EWL
[NAME] | Seville | ELP
[NAME] | [NAME] | EZH
[NAME] | [NAME] | FFP
[NAME] | [NAME] | FRO
[NAME] | Inverness | FBK
[NAME] | London | GHV
Brent Suratt | Jasper | GRV
[NAME] | Jasper II | HS
[NAME] | Jasper III | HPG
[NAME] | Troy | HC
Vanesse Weaver | Cypress | HKR
[NAME] | Lenox | HZL
[NAME] | Steele | HPS
[NAME] | Garrett | HHS
[NAME] | Parker | HP
Showroom | Hawthorne | HTH
 | Monaco | HWP
 | Riley 2900 | IVN
 | Riley 2908 | KL
 | Townsend 3100 | KF
 | Townsend 3108 | KG
 | Stafford | KT
 | [NAME] | LKP
 | Winslow 3500 | LRG
 | Winslow 3508 | LRC
 | Campbell | LRE
 | Flitcroft | LGO
 | Kent | LTC
 | [NAME] | MDR
 | Whittredge | MPE
 | Drake | MR
 | Kensington | MCV
 | Meridian | MV
 | St. James | NPL
 | St. James II | NPC
 | Sawyer | NPB
 | Baxter | OC
 | Riley 2910. | OAM
 | Reese 2 | OL
 | Riley 2901 | OFF
 | Coronado TH | OS
 | Jasper II | PKS
 |  | PWC
 |  | PK
 |  | PSA
 |  | PTG
 |  | PCT
 |  | PRP
 |  | QLR
 |  | RGT
 |  | RGT
 |  | RVR
 |  | ROE
 |  | RP
 |  | SDB
 |  | SAW
 |  | SO
 |  | SWF
 |  | SVR
 |  | SWT
 |  | STM
 |  | STB
 |  | STC
 |  | STG
 |  | SFH
 |  | SP
 |  | SDR
 |  | SMW
 |  | SNF
 |  | TCN
 |  | VB
 |  | VF
 |  | VBC
 |  | WF
 |  | WP
 |  | WLN
 |  | WLF
 |  | WCT
 |  | WTG
 |  | WWR
 |  | WLB
 |  | WDC
 |  | BEA
 |  | ALB
 |  | Global
 |  | FAO
 |  | WFS
 |  | WDE
 |  | WSC
 |  | OYL
Spreadsheet: 453520d1459350625-array-formula-to-return-list-of-values-that-match-multiple-criteria-mowing-schedule
Sheet: Sheet1

2016-04-04 00:00:00
1 |  |  | =IF(ISERROR(INDEX($A$1:$B$8,SMALL(IF($A$1:$A$8=$E$1,ROW($A$1:$A$8)),ROW(2:2)),2)),"",INDEX($A$1:$B$8,SMALL(IF($A$1:$A$8=$E$1,ROW($A$1:$A$8)),ROW(2:2)),2))
2 | #[NAME]?
3 | #[NAME]?
4 | #[NAME]?
5 | #[NAME]?
6 | #[NAME]?
7 | #[NAME]?
8 | #[NAME]?
9 | #[NAME]?
10 | #[NAME]?
11 | #[NAME]?
12 | #[NAME]?
13 | #[NAME]?
14 | #[NAME]?
15 | #[NAME]?
16 | #[NAME]?
17 | #[NAME]?
18 | #[NAME]?
19 | #[NAME]?
20 | #[NAME]?
21 | #[NAME]?
22 | #[NAME]?
23 | #[NAME]?
24 | #[NAME]?
25 | #[NAME]?
26 | #[NAME]?
27 | #[NAME]?
28 | #[NAME]?
29 | #[NAME]?
30 | #[NAME]?
31 | #[NAME]?
32 | #[NAME]?
33 | #[NAME]?
34 | #[NAME]?
Spreadsheet: 676138d1588675587-formula-in-sales-commission-example
Sheet: Sheet1

[NAME] | January | February | March | April | May | June | July | August | September | October | November | December | 2020  Revenue
Target | 26667 | 50000 | 50000 | 50000 | 50000 | 43333 | 50000 | 40000 | 53333 | 73333 | 73334 | 40000
Target 110%
Target 120%
Earned | 49956.4295 | 43559.05716 | 83760.322464 | 151550 |  |  | 0 | 0 | 0 | 0 | 0 | 0
Cummulative
Commission
Salary
Total
Should be |  | 5% up to target
 |  | 10% anything over target
Commission Structure
3% of delivered revenue if under target
5% of delivered revenue if on target
10% of revenue delivered that is over target (so you get 5% for hitting and then 10% for anything delivered above target)
Spreadsheet: 821243d1678548742-formula-if-cell-contains-x-return-the-first-number-following-x-stock
Sheet: Stock

Cadre
Cadre 100
Cadre 120
Cadre 120 x 25
Cadre 125
Cadre 125 x 25
[NAME]
[NAME]
[NAME] 25
[NAME] 50
[NAME] |  | [NAME]
 |  | Milieu
 |  | Fin
[NAME] x 50
Spreadsheet: 37643185-3e47-48c9-a2c1-9fc1dd48fe3e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | If you wish to print out only one set of all table i.e. for only the lead organisation/single applicants, please use CTRL + m to invoke the print macro.
 | The numbers inserted in the various sheets are fictive numbers given as examples. They should be deleted before initialising your own budget
 | Summary Forward Budget for the Operation
 | Expenditure |  | Total Eligible costs | Total Action Costs |  |  |  | Form B/1
 | Summary sheet by beneficiary |  | Total Eligible costs
 | Co-ordinator/Lead organisation - Beneficiary 1 |  | 157901.6781464703 | 1157901.67814647
 | [NAME] |  | 0 | 0
 | Beneficiary 3 |  | 0 | 0
 | [NAME] |  | 0 | 0
 | Beneficiary 5 |  | 0 | 0
 | Beneficiary 6 |  | 0 | 0
 | Beneficiary 7 |  | 0 | 0
 | Beneficiary 8 |  | 0 | 0
 | Beneficiary 9 |  | 0 | 0
 | Beneficiary 10 |  | 0 | 0
 | Beneficiary 11 |  | 0 | 0
 | Beneficiary 12 |  | 0 | 0
 | Beneficiary 13 |  | 0 | 0
 | Beneficiary 14 |  | 0 | 0
 | Beneficiary 15 |  | 0 | 0
 | Beneficiary 16 |  | 0 | 0
 | Beneficiary 17 |  | 0 | 0
 | Beneficiary 18 |  | 0 | 0
 | Beneficiary 19 |  | 0 | 0
 | Beneficiary 20 |  | 0 | 0
 | TOTAL COSTS |  |  | 1157901.67814647
 | TOTAL ELIGIBLE COSTS |  | 0
 |  |  |  |  |  |  |  | Form B/2
 | Financing plan |  |  | Revenues |  |  | Amount EUR | Percentage of eligible costs %
 | Co-financing by the applicant (1)+(2) |  |  |  |  | total | 0
 | Monetary contribution (1)
 | Own resources (2)
 | Other third party co-financers* (please specify below) |  |  |  |  | total | 0
 | Name
 | 1.
 | 2.
 | 3.
 | …
 | Contribution requested from the Commission |  |  |  |  | total | 0
 | DG Enterprise
 | Direct revenues expected from the operation (please specify below) |  |  |  |  | total | 0
 | Participants
 | Estimated bank interest generated by the grant requested over the period of implementation of the action |  |  |  |  | total
 | SUBTOTAL ELIGIBLE REVENUES |  |  |  |  |  | 0
 | Value of contributions in kind |  |  |  |  | total |  | Balance check
 | Contribution allocated to the other non-eligible costs |  |  |  |  | total
 | OVERALL TOTAL |  |  |  |  |  | 0
 | * A co-financing statement form ("C") must be filled in for each contributor.
Spreadsheet: 837084d1689842615-formula-f-to-sum-the-values-from-payment-plan-sheet-by-applying-two-conditions-excel-forum
Sheet: RS

 |  |  | 2026-04-01 00:00:00 | 2026-05-31 00:00:00 | 2026-06-01 00:00:00
 |  |  | In Figures
 | Unit Number | Client Name | During Construction | On Completion | Post Completion
 | 102 | MARAT BIRIMZHANOV
 | 105 | EMMA SHAKESPEARE ARNOLD
 | 106 | YASMINA HAMITOU
 | 201 | NASSER ESSAM SAID ISKEIRJAH
 | 202 | VALENTYNA DZYHANSKA
 | 210 | SAMY SAYOUD
 | 301 | CARLO ACQUAVIVA
 | 302 | ELENA SKIRTA
 | 303 | EKATERINA AKHMETSHINA
 | 304 | [NAME] SAVIO D'MELLO
 | 306 | SALIMA NAIMA KAIB
 | 308 | ARTYOM NARINJANYAN
 | 309 | [NAME]
 | 310 | DAMANPRIT SINGH DALBIR SINGH HANS
 | 402 | LIUDMILA APALKO
 | 404 | GRAEME [NAME]
 | 407 | IVAN KUZMINSKII
 | 408 | ALENA PAVLOVA
 | 409 | ALEKSANDR SMIRNOV
 | 501 | ALEXEY AGAFONOV
 | 502 | SUSA MANUAL
 | 503 | QADEER AHMED
 | 504 | ANKITA DANDPAT
 | 506 | MUSTAFA SHARBAJI
 | 507 | ESSA IBRAHEM MOUSA SWEIDAN
 | 508 | HOSAM AHMEDBAHJAT Y JAMAL
 | 509 | SHAIKHAH MOHAMED HAMDAN ALI ALHINDAASSI
 | 602 | EVGENY RUBANOVSKY
 | 603 | BERIK SHOKAKOV
 | 606 | [NAME]
 | 607 | MOUSSA CAMARA
 | 608 | HOLGER FRANZ ADLER
 | 609 | KONSTANTIN SHIPILOV
 | 610 | MUNIRAH AHMED A [NAME]
 | 701 | MOHAMAD EL ANNAN
 | 702 | NIKOLAY STRUEV
 | 706 | [NAME]
 | 707 | TUGAY KEKLIKOGLU
 | 708 | HAZEM ZIADEH
 | 709 | SOFIENE MALIK SEBAA
 | 710 | [NAME] GOME
 | 801 | MARC FADI KIWAN
 | 804 | MARIIA NESTEROVA
 | 807 | MARIIA NESTEROVA
 | 901 | ABDULQADER ALI JASIM AL AZZAWI
 | 902 | NADEZHDA DAVLETSHINA
 | 904 | MURHAF IBRAHEM
 | 906 | VUGAR TAHIROV
 | 907 | [NAME]
 | 909 | SONIA KIRAN ZAHIR UDDIN BABER
 | 1001 | MOHAMAD EL ANNAN
 | 1002 | CARLOS MANUEL GUANILO ALVARADO
 | 1003 | WOSTENLEY EXANTUS
 | 1004 | [NAME]
 | 1006 | [NAME]
 | 1007 | JORDAN MEYER LANCRI
 | 1009 | IAD HASSAN
 | 1010 | IAD HASSAN
 | 1101 | CARLOS ERNESTO ORTEGA SANTOS
 | 1102 | ALEKSEI ABASHIN
 | 1103 | MUHAMMAD KASHIF KHAN QADEER FALAK [NAME]
 | 1104 | EMAN AL ISSA
 | 1107 | JORDAN MEYER LANCRI
 | 1109 | PAVEL RYBKIN
 | 1110 | ALI ALASAD
 | 1201 | [NAME] CHOUDHURY
 | 1204 | FATHI LUBANI
 | 1205 | [NAME]
 | 1206 | SIRINE TRIGUI
 | 1208 | RAFAELA SILVA FERREIRA
 | 1301 | HAIDAR HUSSEIN BARJAS BARJAS
 | 1302 | RAFAELA SILVA FERREIRA
 | 1303 | STEPHANE ELIE SARFATI
 | 1304 | [NAME]
 | 1307 | AHMED KAREEM MOUSA
 | 1308 | MAHBOOBEH MOHAMMAD NASER AJOODAN GHARAEE
 | 1309 | ISLOMJON ARIPOV
 | 1401 | MEHMET HIKMET GOKHAN
 | 1404 | MEHMET HIKMET GOEKHAN
 | 1405 | [NAME]
 | 1406 | [NAME]
 | 1409 | MEHMET HIKMET GOEKHAN
 | 1410 | MEHMET HIKMET GOEKHAN
 | 1507 | MAURIZIO MALDINI
 | 1511 | ABDULLAH S M O S ALKHAWALED
 | 1701 | RAJA NAVEED ASLAM
 | 1703 | IHAB QUSSINI
 | 1707 | HAFIZ ALI MOHD SABIR
 | 1904 | [NAME]
 | 2302 | HAIDER RAZA
 | RETAIL 03 | SHAMEERA ABDUL MUNAF RASHID
 |  | Total
Spreadsheet: 885649d1735463535-create-multiple-vertical-lines-programmatically-from-single-cell-mcmxd-sample-workbook-spill-365-aligw
Sheet: Export

Subject | Start date | Start time | End Date | End Time |  |  | Start date | Start time | End date | End time
Days (Wed off) | 2025-02-03 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00 |  | Days (Wed off) | 2024-02-03 00:00:00 | 7.30 | 2024-02-04 00:00:00 | 17.30
Days (Wed off) | 2025-02-04 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00 |  | Days (Wed off) | 2024-02-04 00:00:00 | 7.30 | 2024-02-05 00:00:00 | 17.30
Days (Wed off) |  |  |  |  |  | Days (Wed off)
Days (Wed off) | 2025-02-06 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00 |  | Days (Wed off) | 2024-02-06 00:00:00 | 7.30 | 2024-02-07 00:00:00 | 17.30
Days (Wed off) | 2025-02-07 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00 |  | Days (Wed off) | 2024-02-07 00:00:00 | 7.30 | 2024-02-08 00:00:00 | 17.30
Days (Wed off) | 2025-02-08 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00 |  | Days (Wed off)
Days (Wed off) | 2025-02-09 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00 |  | Days (Wed off)
Days (Fri Off) | 2025-02-10 00:00:00 | 08:30:00 | 2023-11-14 00:00:00 | 19:00:00 |  | Days ([NAME] off) | 2024-02-10 00:00:00 | 7.30 | 2024-02-11 00:00:00 | 17.30
Days (Fri Off) | 2025-02-11 00:00:00 | 09:30:00 | 2023-11-15 00:00:00 | 20:00:00 |  | Days ([NAME] off) | 2024-02-11 00:00:00 | 7.30 | 2024-02-12 00:00:00 | 17.30
Days (Fri Off) | 2025-02-12 00:00:00 | 10:30:00 | 2023-11-16 00:00:00 | 21:00:00 |  | Days ([NAME] off) | 2024-02-12 00:00:00 | 7.30 | 2024-02-13 00:00:00 | 17.30
Days (Fri Off) | 2025-02-13 00:00:00 | 11:30:00 | 2023-11-17 00:00:00 | 22:00:00 |  | Days ([NAME] off) | 2024-02-13 00:00:00 | 7.30 | 2024-02-14 00:00:00 | 17.30
Days (Fri Off) |  |  |  |  |  | Days ([NAME] off)
Days (Fri Off) | 2025-02-15 00:00:00 | 13:30:00 | 2023-11-19 00:00:00 | 1900-01-01 00:00:00 |  | Days ([NAME] off)
Days (Fri Off) | 2025-02-16 00:00:00 | 14:30:00 | 2023-11-20 00:00:00 | 1900-01-01 01:00:00 |  | Days ([NAME] off)
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
Spreadsheet: 883183d1731681379-linking-two-sheets-with-data-specific-information-job-book-test-1-jwalden15-
Sheet: Job Regsiter 

Sample No | Sample Identification | Sample Identification2 | Sample Identifcation | Incriments | Mass  Received | Sample Type | Date  Received | Job Number | Client | Order Number | Job Details | Prep | CL | HAC | A/C | MIX | A/S SO3 | W/S SO4 | tS | S2- | MCHW Sulphate Suite | [NAME] | Alkalis | Volhard | Paint | Water | C/S | Other
1 |  |  |  |  |  |  | 2024-11-14 00:00:00 | 22499 | [NAME] | dfbv | dfgb | x | x | x | x
2 |  |  |  |  |  |  |  |  |  |  |  | x | x |  | x
3 |  |  |  |  |  |  |  |  |  |  |  |  | x | x
4 |  |  |  |  |  |  |  |  |  |  |  | x | x |  | x
5 |  |  |  |  |  |  |  |  |  |  |  |  | x | x
6 |  |  |  |  |  |  |  | 22500
7
8
9
10
11
12
13
14
15
Spreadsheet: 123874d1317912539-sumproduct-criteria-problem-capex-and-opex-stock-distribution-spreadsheet-test-amended
Sheet: Sheet1

 | ID No. | opex open stock | opex stock in | opex stock out | Opex Running Stock |  | capex open stock | capex stock in | capex stock out | Capex Running Stock | Total Running Stock
 | 001 | 1 | 2 | 0 | 3 |  | 1 | 2 | 3 | 0 | 3
 |  | Rec No / Order No. | Initials / Del | Stock In / Out | Prod ID No. |  | When the stock item (001) is removed from the store it needs to be taken first from the capex stock out column until that has been exhausted and then the opex stock out column until that stock has been exhausted, no stock can show minus figures.                                                              I have set up the sheet so that when stock is delivered with a C prefix it is automatically put into capex stock, but a delivery number without the C prefix is put into opex stock. The two formulas to look at are in E2 and J2.
 |  | 2221 | KM | 1 | 001
 |  | 2222 | KM | 1 | 001
 |  | 122578 | DEL | 1 | 001
 |  | C1768 | DEL | 1 | 001
 |  | 2223 | km | 1 | 001
 |  | 125579 | DEL | 1 | 001
 |  | C1768 | DEL | 1 | 001
Spreadsheet: 03125522-431b-4e1f-bce4-82a029c44d78
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
FGNRH | Test | FGNRH | [NAME] (Gn-RH) | Gonadotropin Releasing Hormone | Direct Radioimmunoassay (RIA) | EDTA (lavender-top) tube: EDTA OR Plain, Red-Top Tube: Red OR |  |  | 3 | mL | Submit only 1 of the following specimens:   Serum Draw blood in a plain, red-top  or serum-gel tube(s). Separate immediately and send 3 mL of serum frozen in a plastic vial. Note: 1. Indicate serum on request form.               2. Label specimen appropriately (serum).  [NAME] blood in a lavender-top (EDTA) tube(s). Separate immediately and send 3 mL of EDTA plasma frozen in a plastic vial. Note:  1. Indicate plasma on request form.                2. Label specimen appropriately (plasma).  Patient preparation: 	Patient should not be on any Steroid, ACTH, [NAME],           	or Estrogen medications, if possible, for at least 48 hours                	prior to collection. | 1 mL | Specimens other than	Serum, plasma Anticoagulants other than	EDTA  Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | [NAME]):  Males:  4.0-8.0 pg/mL Females:  2.0-10.0 pg/mL   Test Performed by: Inter Science Institute                                        944 West Hype Park                                         Inglewood, CA 90302 | Monday through Friday | 5-7 days | 7-9 days | 1 | 83727 |  |  |  |  | Inter Science Institute
FGNRH | [NAME] | VARIES | Varies |  |  |  | Frozen | 365 days
FGNRH | Result | Z0929 | Gonadotropin Releasing Hormone | Gonadotropin Releasing Hormone | Alphanumeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 13660-6
Spreadsheet: 879328d1726819526-how-to-convert-data-from-columns-to-rows-book1-2-
Sheet: Data

 | TOTAL NUMBER & SALES OF CUSTOMERS PARTICIPATING IN THE PROGRAM
STT | program code | program name | [NAME] |  | Lê Đình Thức |  | Nguyễn Mạnh Cường
 |  |  | Quantity | Revenue | Quantity | Revenue | Quantity | Revenue
1 | SAPA | CHƯƠNG TRÌNH CÙNG DƯỢC ĐI [NAME] | 0 | 0 | 0 | 0 | 2 | 9643000
2 | SINGAPORE_MALAYSIA | CHƯƠNG TRÌNH CÙNG DƯỢC ĐI [NAME] | 2 | 23280500 | 3 | 44039000 | 4 | 22240000
3 | TRUNG HOA CỔ KÍNH | CHƯƠNG TRÌNH CÙNG DƯỢC ĐI [NAME] | 1 | 25600000 | 1 | 8888000 | 5 | 32469000
4 | PHÁT LỘC | CHƯƠNG TRÌNH HỢP ĐỒNG CÙNG DƯỢC QN | 14 | 140510000 | 3 | 41386500 | 7 | 92636000
5 | BỀN VỮNG | CHƯƠNG TRÌNH HỢP ĐỒNG CÙNG DƯỢC QN | 1 | 15768000 | 1 | 49026000 | 3 | 87882000
6 | KIẾN TẠO TƯƠNG LAI | CHƯƠNG TRÌNH HỢP ĐỒNG CÙNG DƯỢC QN | 1 | 25966000 | 1 | 24193000 | 1 | 54484000
TOTAL
Spreadsheet: 715809d1611869073-sum-if-across-multiple-sheets-tabs-excel-donation-testing
Sheet: Annual totals

 |  |  |  |  | Donations by organizations
 |  |  |  |  |  |  |  | Total Quantity | Total Weight | Total Value
 |  |  |  |  | St. Mary's Food Bank |  |  | Annual total "Quantity" Here , where if "St. Mary's Food Bank" is found it adds all the total Quantity. | Annual total "Weight" Here | Annual total "Value" Here
Monthly Totals
 | Total Quantity | Total Weight | Total Value
January
February
March
April
May
June
July
August
September
October
November
December
Annual Totals
Spreadsheet: 32a678d4-3854-449e-945d-56d46b7c2c15
Sheet: Balance Sheet

Lockheed [NAME]
Consolidated Balance Sheets
(unaudited; in millions, except par value)
 |  | March 31, 2013 |  | Dec. 31, 2012
Assets
Current assets
Cash and cash equivalents |  | 3065 |  | 1898
Receivables, net |  | 6968 |  | 6563
Inventories, net |  | 2895 |  | 2937
Deferred income taxes |  | 1261 |  | 1269
Other current assets |  |  |  | 1188
Total current assets |  | 14872 |  | 13855
Property, plant, and equipment, net |  | 4617 |  | 4675
Goodwill |  | 10356 |  | 10370
Deferred income taxes |  | 4750 |  | 4809
Other noncurrent assets |  |  |  | 4948
Total assets |  | 39580 |  | 38657
Liabilities and stockholders' equity
Current liabilities
Accounts payable |  | 2123 |  | 2038
Customer advances and amounts in excess of costs incurred |  | 6406 |  | 6503
Salaries, benefits, and payroll taxes |  | 1710 |  | 1649
Current portion of long-term debt |  | 150 |  | 150
Other current liabilities |  |  |  | 1815
Total current liabilities |  | 12625 |  | 12155
Accrued pension liabilities |  | 15397 |  | 15278
Other postretirement benefit liabilities |  | 1220 |  | 1220
Long-term debt, net |  | 6154 |  | 6158
Other noncurrent liabilities |  | 3880 |  | 3807
Total liabilities |  | 39276 |  | 38618
Stockholders' equity
Common stock, $1 par value per share |  | 318 |  | 321
Additional paid-in capital |  | 0 |  | 0
Retained earnings |  | 13268 |  | 13211
Accumulated other comprehensive loss |  | -13282 |  | -13493
Total stockholders' equity |  | 304 |  | 39
Total liabilities and stockholders' equity |  | 39580 |  | 38657
Spreadsheet: 220988d1363344006-generate-part-list-assembly-list
Sheet: Main

 | Assembly: | Assembly D |  | Sub Assembly:
 | Part Number | Qty |  | Part Number | Qty
 | Part 1 |  |  | Part 1
 | Part 2 |  |  | Part 2
 | Part 3 |  |  | Part 3
 | Part 4 |  |  | Part 4
 | Part 5 |  |  | Part 5
 | Part 6 |  |  | Part 6
 | Part 7 |  |  | Part 7
 | Part 8 |  |  | Part 8
 | Part 9 |  |  | Part 9
Spreadsheet: 112742d1308761382-issue-similar-to-transpose-with-a-twist-new-microsoft-excel-worksheet-2-
Sheet: Sheet1

 | WK_END_DATE | COUNT | PLAN
 | 2010-11-12 00:00:00 | 175 | 1
 | 2010-11-19 00:00:00 | 350 | 1
 | 2010-11-12 00:00:00 | 175 | 2
CURRENT---> | 2010-11-19 00:00:00 | 350 | 2
 | 2010-11-26 00:00:00 | 500 | 2
 | 2010-11-12 00:00:00 | 175 | 3
 | 2010-11-19 00:00:00 | 350 | 3
 | WK_END_DATE | PLAN 1 | PLAN 2 | PLAN 3
 | 2010-11-12 00:00:00 | 175 | 175 | 175
NEW ---> | 2010-11-19 00:00:00 | 350 | 350 | 350
 | 2010-11-26 00:00:00 |  | 500
Spreadsheet: 125663d1319146636-pulling-the-top-3-values-and-other-columns-associated-with-those-values-from-a-list-sample-worksheet
Sheet: Sheet1

Customer | Year | Sales | Region
1 | 2010 | 100 | US |  |  | Based on this table, with the criteria of the Year = 2011 and the Region = US, the top 3 Customers in sales (in order of highest value) would be:
1 | 2011 | 200 | US
2 | 2010 | 100 | US |  |  |  | 3 | 400 |  | Now I need the formulas to automatically generate these! Thanks for the help!
2 | 2011 | 250 | US |  |  |  | 4 | 300
3 | 2010 | 200 | US |  |  |  | 2 | 250
3 | 2011 | 400 | US
4 | 2010 | 50 | US
4 | 2011 | 300 | US