tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: be5a907b-ba47-4ff4-b4b1-3ed99dd490a7
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
TLDLP | Test | TLDLP | LDL Particle Concentration NMR, Plasma | LDL Particles NMR, P | Nuclear Magnetic Resonance (NMR) | Lavendar-top (EDTA) Tube: EDTA (<1 month old infant) |  |  | 1 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Plasma/serum gel tube | TOTAL LDL PARTICLE CONCENTRATION < or =15 years: not established Adults (> or =16 years): <1,000 nmol/L (optimal) 1,000-1,299 nmol/L (near or above optimal) 1,300-1,599 nmol/L (borderline high) 1,600-2,000 nmol/L (high) >2,000 nmol/L (very high) Interpretation of LDL lipoprotein concentration should be conducted within the context of standard lipid profile results (total cholesterol, triglycerides, HDL cholesterol, calculated LDL cholesterol and non-HDL cholesterol). | Monday through Friday; [NAME] | Same day/5 days | 3 days | 1 | 83704 |  |  |  |  | Rochester
TLDLP | [NAME] | PLEDTA | [NAME] |  |  |  | Refrigerated | 6 days
TLDLP | Result | LDLPV | Total LDL Particle Concentration | Total LDL Particle Concentration | Numeric |  |  |  |  | nmol/L |  |  |  |  |  |  |  |  |  | 14815-5 | Lipoprotein.beta:SCnc:Pt:Ser/Plas:Qn:Calculated
TLDLP | Result | NMRIT | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2 | Clinical biochemist review:Imp:Pt:XXX:Nar:
Spreadsheet: 69997d1270655499-using-data-validation-want-to-only-allow-values-from-list-cashbook-2010-2011
Sheet: Lists

Transaction Type | Allocation
CHQ | ADV1011
S/O | AWF0809
D/D | AB0910
BACS | BE1011
CC | BS0910
 | BL0910
 | CP0910
 | [NAME]
 | DBF09
 | DBF10
 | DCCC0910
 | EP0910
 | EBW0910
 | FORD0910
 | FOX1011
 | [NAME] | Book sales
 | MEN0910
 | NELH0910
 | NWA09
 | NWA10
 | OM0910
 | QB0910
 | RR09
 | RR10 | Recruitment | Programme Manager | NWN Expenses | Farmers Markets | Readers Days | Read Regional Books | Author Tour | Civic Literature | Beach Reading | Airport Launch | Metro Launch | Reading Groups | Literary Salons | Reading Salons | Student Film/ Book project | Journal Supplement | Point of sale materials | NWN Management fee | Evaluation | Contingency
 | RG0910
 | RHA0910
 | RUTH0910
 | SD1011
 | SE1011
 | TV0910
 | FORGE0910
 | TC1011
 | [NAME]
 | [NAME]
 | WM1011
 | YWP0910
 | OH1PC | Petty Cash
 | OH2SU | Volunteer expenses | Office expenses | Adjustments | Miscellaneous | Staff expenses
 | OH3TR | Director | Deputy Director | Finance & Administration Manager | Projects & Marketing Officer | IT Training | Disability Training
 | OH4IR | Director | Deputy Director | Finance & Administration Manager | Projects & Marketing Office
 | OH5RE | Rent | Storage | Parking
 | OH6PO | Parcels | Franking machine credit | Franking machine rental | Licences/fees | Freepost | General | Franking machine misc
 | OH7HO | Director hospitality | Author hospitality | Deputy director hospitality | Refreshments
 | OH8AA | Audit and accounts | Payroll
 | OH9RR | Repairs & Renewals | Heath and Safety
 | OH10ST | General stationary | Consumables
 | OH11IT | Hardware | Software | Support & maintenance | Security
 | OH12TF | Broadband & call forwarding | Staff mobile expenses | Telephone & fax
 | OH13BC | Service charge | Credit card annual fee | Audit letter fee
 | [NAME] | Print | General marketing | Distribution | Database clean-up
 | OH15SAL | Director | Deputy Diector | Finance & Administration Manager | Projects & Marketing Office | Temporary staff
 | OH16TRS | Travel | Food | Director expenses | Per diem
 | OH17DC | Website hosting | Newsletters/e-flyers | Website updates
 | OH18PD | Project development | Research and development
 | OH19BOA | Trustee travel expenses | Room hire | Hospitalities | Miscellaneous
 | OH20INS | General office insurance | Professional indemnity insurance
Spreadsheet: 24915d1215814683-dynamically-transpose-data-transpose-2-cols-with-variable-count-to-rows
Sheet: Solution

Megacorp | [NAME] | Megacorp | 1 | 5 | [NAME] | [NAME] | Emma | [NAME]
Megacorp | [NAME] | Tiny PLC | 5 | 6 | [NAME]
Megacorp | Emma | TFP PLC | 6 | 8 | [NAME] | [NAME]
Megacorp | [NAME]
Tiny PLC | [NAME]
TFP PLC | [NAME]
TFP PLC | [NAME]
 |  |  |  |  | To allocate names to companies
 |  |  |  |  | Put names on right of companies (not essential but fits with existing formulae)
 |  |  |  |  | Prepare list of unique values in Column C (use Data, Filter, Advanced)
 |  |  |  |  | Enter formula in col D and E and copy down
 |  |  |  |  | Replace last cell in column E with next blank row number in B
 |  |  |  |  | Enter formula in F1, copy right to the maximum needed
 |  |  |  |  | Copy this range down as required.
Spreadsheet: 144547d1331036493-date-calculation-date-calculation
Sheet: Sheet1

Start date | End date | 2011 | 2012
2011-01-25 00:00:00 | 2011-02-20 00:00:00
2011-05-28 00:00:00 | 2011-02-20 00:00:00
2011-02-25 00:00:00 | 2011-02-20 00:00:00
2011-07-05 00:00:00 | 2011-02-20 00:00:00
2011-04-03 00:00:00 | 2011-02-20 00:00:00
2011-03-16 00:00:00 | 2011-02-20 00:00:00
2011-01-11 00:00:00 | 2011-02-20 00:00:00
2011-02-18 00:00:00 | 2011-02-20 00:00:00
2011-09-17 00:00:00 | 2011-02-20 00:00:00
Spreadsheet: 805774d1668906164-how-to-enter-in-an-if-function-to-capture-cell-data-pay-calculator_rev-08a
Sheet: Penalty Rate Calculator

CALCULATOR # 1. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FINISH OFF !!! |  | CALCULATOR # 2. |  |  | MAYBE CHANGE MAX TO MIN AND MIN TO MAX FOR THIS CALCULATOR
EARLY/LATE PENALTY CALCULATOR FOR SHIFT WORK TIMES PRO-RATA ON AN HOURLY BASIS STARTING BEFORE 6.59AM AND FINISHING AFTER 7:00AM AND ALL HOURS BETWEEN 8.00PM and 6.59AM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EARLY/LATE PENALTY CALCULATOR FOR SHIFT WORK TIMES THAT START BEFORE 7:59PM AND FINISH AFTER 8:00PM
 |  | LATE/EARLY PENALTY RATE HOURS |  |  |  |  |  |  | FINISHING AFTER 8:00PM |  |  | LATE/EARLY PENALTY RATE HOURS |  |  |  |  |  |  | FINISHING AFTER 8:00PM |  |  |  |  |  | LATE/EARLY PENALTY RATE HOURS |  |  |  |  |  |  | LATE/EARLY PENALTY RATE HOURS
 |  | 1st. HALF |  |  |  |  |  |  |  | ROUNDED |  | 2nd. HALF |  |  |  |  |  |  |  | ROUNDED |  |  |  |  | 1st. HALF |  |  |  |  |  |  | 2nd. HALF
 |  | Start | End | Total | Normal | Penalty | ROUNDED |  |  |  |  | Start | End | Total | Normal | Penalty | ROUNDED |  |  |  |  |  |  |  | Start | End | Total | Normal | Penalty | ROUNDED |  | Start | End | Total | Normal | Penalty | ROUNDED
WEEK 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  | Week 1 - 1st. Half Total : |  |  |  |  |  |  |  |  |  | Week 1 - 2nd. Half Total : |  |  |  |  |  |  |  |  |  |  |  |  | Week 1 - 1st. Half Total : |  |  |  |  |  |  | Week 1 - 2nd. Half Total :
WEEK 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | Week 2 - 1st. Half Total : |  |  |  |  |  |  |  |  |  | Week 2 - 2nd. Half Total : |  |  |  |  |  |  |  |  |  |  |  |  | Week 2 - 1st. Half Total : |  |  |  |  |  |  | Week 2 - 2nd. Half Total :
CALCULATOR # 2.
EARLY/LATE PENALTY CALCULATOR FOR SHIFT WORK TIMES THAT START BEFORE 7:59PM AND FINISH AFTER 8:00PM
 |  | LATE/EARLY PENALTY RATE HOURS |  |  |  |  |  |  |  |  |  | LATE/EARLY PENALTY RATE HOURS
 |  | 1st. HALF |  |  |  |  |  |  |  |  |  | 2nd. HALF
 |  | Start | End | Total | Normal | Penalty | ROUNDED |  |  |  |  | Start | End | Total | Normal | Penalty | ROUNDED
WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FINISH OFF !!!
 |  |  |  |  | Week 1 - 1st. Half Total : |  |  |  |  |  |  |  |  |  | Week 1 - 2nd. Half Total :
WEEK 2
 |  |  |  |  | Week 2 - 1st. Half Total : |  |  |  |  |  |  |  |  |  | Week 2 - 2nd. Half Total :
Spreadsheet: 749094d1632499389-indexmatch-with-multiple-criteria-and-columns-indexmatch-with-multiple-criteria
Sheet: Sheet1

How to return a value from more than one criteria
Status | IT Customer # | Casino Client | # Reps | Rep(s) | Rep 1 | Helper | % | Rep 2 | Helper | % | Rep 3 | Helper | % | Rep 4 | Helper | % | Rep 5 | Helper | %
Active | 13057 | ABC Company | 5 | Peggy Jones/Autumn Kennedy/Brett Marker/[NAME][NAME] | [NAME] | 1 | 0.05 | Autumn [NAME] | 1 | 0.03 | [NAME] | 1 | 0.1 | [NAME] Son | 1 | 0.06 | [NAME] | 1 | 0.07
Inactive | 18841 | DEF Company | 5 | [NAME]/[NAME]/[NAME]Suzy Rutledge | [NAME] | 1 | 0.02 | [NAME] | 1 | 0.08 | [NAME] | 1 | 0.05 | [NAME] | 1 | 0.04 | [NAME] | 1 | 0.08
Inactive | 10202 | GHI Company | 5 | Peggy Jones/Autumn Kennedy/Brett Marker/[NAME][NAME] | [NAME] | 1 | 0.03 | Autumn [NAME] | 1 | 0.01 | [NAME] | 1 | 0.03 | [NAME] Son | 1 | 0.02 | [NAME] | 1 | 0.06
Inactive | 10756 | KLM Company | 5 | [NAME]/[NAME]/[NAME]Suzy Rutledge | [NAME] | 1 | 0.06 | [NAME] | 1 | 0.02 | [NAME] | 1 | 0.01 | [NAME] | 1 | 0.09 | [NAME] | 1 | 0.03
Inactive | 11420 | NOP Company | 5 | Peggy Jones/Autumn Kennedy/Brett Marker/[NAME][NAME] | [NAME] | 1 | 0.05 | Autumn [NAME] | 1 | 0.03 | [NAME] | 1 | 0.1 | [NAME] Son | 1 | 0.06 | [NAME] | 1 | 0.07
Inactive | 11195 | QRS Company | 5 | [NAME]/[NAME]/[NAME]Suzy Rutledge | [NAME] | 1 | 0.02 | [NAME] | 1 | 0.08 | [NAME] | 1 | 0.05 | [NAME] | 1 | 0.04 | [NAME] | 1 | 0.08
Inactive | 56324 | TUV Company | 5 | Peggy Jones/Autumn Kennedy/Brett Marker/[NAME][NAME] | [NAME] | 1 | 0.03 | Autumn [NAME] | 1 | 0.01 | [NAME] | 1 | 0.03 | [NAME] Son | 1 | 0.02 | [NAME] | 1 | 0.09
Inactive | 96478 | WXYZ Company | 5 | [NAME]/[NAME]/[NAME]Suzy Rutledge | [NAME] | 1 | 0.06 | [NAME] | 1 | 0.02 | [NAME] | 1 | 0.01 | [NAME] | 1 | 0.09 | [NAME] | 1 | 0.03
 | Lookup % using indexmatch from the list above based on Rep Name and Client, then and insert the reps corresponding % in column D below highlighted in yellow
 | Rep | Client | % | Comments
 | [NAME] | KLM Company |  | Should be 6%
 | [NAME] | NOP Company |  | Should be 10%
 | [NAME] | TUV Company |  | Should be 9%
Spreadsheet: 86882d1286841999-sorting-merged-tabs-mergetabsdata
Sheet: Sheet1

 |  |  |  |  |  |  | ATM | Transaction Amt | Customer count | Deposit | Withdrawl | Misc
 |  |  |  |  |  |  | India | 53453345 | 454565 | 6456354 | 546456 | 7856545
 |  |  |  |  |  |  | Other | 11323242 | 252344 | 453455 | 4535345 | 57668
 |  |  |  |  |  |  | US | 543534 | 54544 | 43443 | 454355 | 453443
 |  |  |  |  |  |  | China | 67546 | 554565 | 6565 | 656565 | 5655
 |  |  | Report |  | Measure
 |  |  | ATM | KPIs
 |  |  | All | Transaction Amt | 11323242
 |  |  |  | Customer count | 252344
 |  |  |  | Deposit | 453455
 |  |  |  | Withdrawl | 4535345
 |  |  |  | Misc | 57668
 |  |  | US | Transaction Amt | 543534
 |  |  |  | Customer count | 54544
 |  |  |  | Deposit | 43443
 |  |  |  | Withdrawl | 454355
 |  |  |  | Misc | 453443
 |  |  | INDIA | Transaction Amt | 53453345
 |  |  |  | Customer count | 454565
 |  |  |  | Deposit | 6456354
 |  |  |  | Withdrawl | 546456
 |  |  |  | Misc | 7856545
 |  |  | CHINA | Transaction Amt | 67546
 |  |  |  | Customer count | 554565
 |  |  |  | Deposit | 6565
 |  |  |  | Withdrawl | 656565
 |  |  |  | Misc | 5655
Spreadsheet: 218157d1362375784-how-to-fill-row-based-on-multiple-criteria-with-the-most-recent-of-multiple-matches-dummysample-1
Sheet: Sample Duplicate List

Box | Position | Expression Vector | Concentration (ng/ul) | LOT # | Original Amount (ug) | Deducted (ug) | Amount Remaining | [NAME] (ul) | Requestor | Aliquot # | Date Aliquotted | Aliquotter
D1 | 1
D1 | 2
D1 | 3
D1 | 4
D1 | 5
D1 | 6
D1 | 7
D1 | 8
D1 | 9
D1 | 10
D1 | 11
D1 | 12
D1 | 13
D1 | 14
D2 | 1
D2 | 2 | Sample 2 | 1000 | 543253 | 250
D2 | 3 | Sample 10 | 3000 | 654321 | 500
D2 | 4
D2 | 5
D2 | 6
D2 | 7
D2 | 8
D2 | 9
D2 | 10
D2 | 11
D2 | 12
D2 | 13
D2 | 14
Spreadsheet: 109727d1306502031-monitor-worksheet-and-record-data-to-external-sheet-777712-monitor-worksheet
Sheet: Test Worksheet

Sheet Number | Description | Issue Number | Release Date | Approved By | File Location | Last Release Date | Amended By | Approved By | EDM Number
1 | collect items | 1 | 2011-05-01 00:00:00 | XL | Click Here
2 | check items | 1 | 2011-05-02 00:00:00 | XL | Click Here
3 | assemble items | 1 | 2011-05-03 00:00:00 | XL | Click Here
4 | inspect items | 1 | 2011-05-04 00:00:00 | XL | Click Here
5 | clean & ship items | 1 | 2011-05-05 00:00:00 | XL | Click Here
Spreadsheet: 531dabcc-565e-4dac-bffc-a1610dac4b69
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
FDILT | Test | FDILT | Diltiazem (Cardizem, Dilacor) | Diltiazem (Cardizem,Dilacor) | High Performance Liquid Chromatography with Ultraviolet Detection (HPLC-UV) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 3 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s). ([NAME] is not acceptable.) Spin down and send 3 mL of  sodium heparin plasma refrigerated. Note:	1. Trough levels are most reproducible. 	  2. Indicate plasma on request form. 	3. Label specimen appropriately (plasma).   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not  acceptable.) Spin down and send 3 mL of serum refrigerated. Note:	1. Trough levels are most reproducible. 	  2. Indicate serum on request form. 	3. Label specimen appropriately (serum). | 0.6 mL Note: Submission of the m | Specimens other than	Plasma, serum Anticoagulants other than	Sodium heparin, EDTA, plain red-top Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | [NAME]: 50-200 ng/mL   Test Performed By: Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN  55112 | Monday through Sunday | 3 days | 5-7 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc
FDILT | [NAME] | VARIES | Varies |  |  |  | Refrigerated
FDILT | Result | [NAME] | Diltiazem | Diltiazem | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 823306d1679891424-formula-countif-with-multiple-criteria-occurence-by-criteria-name-vs-number
Sheet: Sample

 |  |  |  |  |  |  |  | Result should be
AA No | Step | Designation | Name | PFNo | BeginDate | EndDate | Occurrence | Occurrence with number per column "A" & "Column D"
LOC1/64230/2023/4906 | STPEA5 | Regional Retail Approving Manager | [NAME] | 980080 | 2023-03-02 15:36:24 | 2023-03-03 15:36:25 |  | 1st AA
LO10/60036/2023/2215 | STPEA5 | Regional Retail Approving Manager | [NAME] | 15651 | 2023-03-06 12:14:06 | 2023-03-06 19:50:48 |  | 1st AA
LOC1/64342/2023/5667 | STPEA5 | Regional Retail Approving Manager | [NAME] | 15698 | 2023-03-09 15:37:31 | 2023-03-09 16:30:09 |  | 1st AA
LO10/60036/2023/2215 | STPEA5 | Regional Retail Approving Manager | [NAME] | 980193 | 2023-03-09 12:18:01 | 2023-03-09 19:33:16 |  | 1st AA
LO10/60036/2023/2215 | STPEA5 | Regional Retail Approving Manager | [NAME] | 980193 | 2023-03-10 15:19:52 | 2023-03-12 13:08:32 |  | 2nd AA
LOC1/64342/2023/5667 | STPEA5 | Regional Retail Approving Manager | [NAME] | 15698 | 2023-03-15 10:46:31 | 2023-03-15 10:48:17 |  | 2nd AA
LOC1/64230/2023/4906 | STPEA5 | Regional Retail Approving Manager | [NAME] | 980080 | 2023-03-16 16:18:36 | 2023-03-16 16:44:10 |  | 2nd AA
LOC1/64342/2023/5667 | STPEA5 | Regional Retail Approving Manager | [NAME] | 15698 | 2023-03-15 18:50:09 | 2023-03-16 19:42:16 |  | 3rd AA
LOC1/64230/2023/4906 | STPEA5 | Regional Retail Approving Manager | [NAME] | 980080 | 2023-03-16 18:27:15 | 2023-03-19 16:53:23 |  | 3rd AA
LOC1/64342/2023/5667 | STPEA5 | Regional Retail Approving Manager | Thurga Thevi A/P Palanisamy | 80881 | 2023-03-20 09:59:19 | 2023-03-20 10:09:01 |  | 1st AA
LOC1/64230/2023/4906 | STPEA5 | Regional Retail Approving Manager | [NAME] | 95064 | 2023-03-20 15:05:46 | 2023-03-20 15:49:54 |  | 1st AA
LOC1/64342/2023/5667 | STPEA5 | Regional Retail Approving Manager | Thurga Thevi A/P Palanisamy | 80881 | 2023-03-20 19:01:41 | 2023-03-21 07:24:33 |  | 5th AA
LOC1/64230/2023/4906 | STPEA5 | Regional Retail Approving Manager | [NAME] | 95064 | 2023-03-21 08:00:55 | 2023-03-21 08:33:42 |  | 2nd AA
LOC1/64230/2023/4906 | STPEA5 | Regional Retail Approving Manager | [NAME] | 95064 | 2023-03-21 15:48:53 | 2023-03-21 16:35:38 |  | 3rd AA
LOC1/64342/2023/5667 | STPEA5 | Regional Retail Approving Manager | Thurga Thevi A/P Palanisamy | 80881 | 2023-03-21 18:19:37 | 2023-03-21 19:30:33 |  | 6th AA
Spreadsheet: 130543d1322429690-count-formula-example
Sheet: Sheet1

 |  |  |  |  |  |  | 03:30:00 | should be | >> | 1900-01-01 00:00:00
2 | 13 | 13 | 34 | 45 | 45 |  | 03:30:00 | should be | >> | 03:00:00
3 | 13 | x | 34 | 56 | x |  | 00:30:00 | should be | >> | 1900-01-01 00:00:00
4 | x | 34 | 5 | vvv | 76 | 78 | 01:00:00
5 |  |  |  |  |  |  | 03:30:00 | should be | >> | 00:30:00
Spreadsheet: 231689d1367186798-need-help-with-selectable-auto-populate-test-run-online
Sheet: sheet2

Nom:test quotation |  |  |  | Date:
Adresse: Ottawa, Ontario |  |  |  | Tél.:
Projet: Pilot |  |  |  | Fax:
Adresse: |  |  |  | Att:
Nous avons le plaisir de vous soumettre nos prix comme suit:
Description |  |  |  | Qty | Sku | Price | Total
Item Number: | Description
[NAME]: 45,00$/livraison dans la région immédiate d'Ottawa/Outaouais
Systeme de clée non inclus
Installation non inclue
3 a 4 semaines pour quincaillerie
2 a 3 semaines pour cadres et portes
 |  |  |  | SOUS-TOTAL
 |  |  |  | TAXES NON INCLUSE
Spreadsheet: 0178650e-665d-4781-b641-3aed0947b287
Sheet: Sheet1

Parts - Tools - Recovery | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Spare Parts
 | 80 series | Who can/will bring?
 | birfields | Romer - see list | Romer | [NAME]
 | Axles | [NAME] - see list | [NAME], seals and one spare birf
 | driveshafts | [NAME] | Rear axles and seals
 | knuckle parts | [NAME] | Fusible Links | Long and short front axles with [NAME]
 | belts | nakman | Spare EFI | coolant hoses
 | hoses | Romer | Spare (old) Fuel Pump Relay | belts
 | wheel bearings | nakman | Spare Fuel Pumo | fluids
 | fuses | nakman | Spare clamps and fuel line | [NAME] brake kleen
 | water pump? |  | Assoreted spare coolent lines | mics electrical stuff
 | PS pump? |  | Spare (Old) distributor cap and wires
 |  |  | Spare (old) brake lines
 |  |  | Spare Fuses
 | Truck/Runner |  | [NAME] | [NAME]
 | [NAME] | [NAME] list | My parts are for a mini but may fit others? | 2 x upper ball joints
 | Short/long axles | [NAME] list | Short and long axles with birfs | 2 x lower ball joints
 |  |  | Rear drive shaft | 1 x complete left side tie rod
 |  |  | Front axle seals | 1 x complete right side tie rod
 |  |  | Power steering hose(s)? | 1 x steering center link
 |  |  | Belts | 2 x u-joints
 |  |  | Other miscellaneous parts. | 1 x prop shaft yoke
 |  |  |  | 2 x CV axles (my front axles)
 |  |  |  | 2 x IFS locking hubs
 |  |  |  | 1 x water pump
 |  |  |  | 1 x oil pump
 |  |  |  | 2 x set of front wheel bearings
 |  |  |  | 1 x set of hoses and belts
 | 40 Stuff
Tools |  | Who can/will bring?
 | 54[NAME] hub socket | Romer, nakman
 | [NAME] | nakman
 | drill
 | cordless impact | nakman
 | OBA impact
 | [NAME] | nakman
 | drill bits
 | Rear axle SST (80) | Romer
Fluids |  | Who can/will bring?
 | Toyota red antifreeze | nakman - 1 gal.
 | water-for truck
 | gear oil
 | grease
 | motor oil
 | ATF/Dextron
Recovery Gear
 | Hi [NAME] |  | everyone must have
 | strap |  | everyone must have
 | D-ring, shackles |  | everyone must have
 | First aid kit - basic |  | everyone must have
 | [NAME] |  | everyone must have
 | [NAME] tool
 | Hi [NAME] accessories (please specify)
Spreadsheet: 274858d1383237850-need-help-with-a-formula-to-populate-a-summary-table-forum
Sheet: pivot table

 | pettyCashTable - must refresh whenever out of pocket expenses table gets new or changed entries (Pivot Table Tools / Options / Refresh )
 | Sum of amount | Column Labels
 | Row Labels | 2013-10-14 00:00:00 | 2013-10-21 00:00:00 | 2013-10-28 00:00:00 | 2013-11-04 00:00:00 | Grand Total
 | en | 49 |  |  |  | 49
 | ff | 70.36 | 70.75 |  |  | 141.11
 | ga | 20.06 | 105 | 30.21 |  | 155.27
 | [NAME] |  |  |  | 35 | 35
 | me
 | mi | 95.72999999999999 | 100 | 124.58 |  | 320.31
 | pc |  | 32.94 | 13.46 |  | 46.4
 | ss | 183.55 | 302.68 | 71.98 |  | 558.21
 | Grand Total | 418.7 | 611.37 | 240.23 | 35 | 1305.3
Spreadsheet: 154123d1336226192-excel-2007-index-match-and-a-lot-of-ifs-and-duplicates-rtest2
Sheet: Sheet2

Actor1 | 1
Actor2 | 10
Actor3 | 11
Actor4 | 12
Actor5 | 13
Actor6 | 14
Actor7 | 15
Actor8 | 16
Actor9 | 17
Actor10 | 18
Actor11 | 19
Actor12 | 20
Actor13 | 21
Actor14 | 22
Actor15 | 23
Actor16 | 24
Actor17 | 25
Actor18 | 26
Actor19 | 27
Actor20 | 28
Actor21 | 29
Actor22 | 30
Actor23 | 31
Actor24 | 32
Actor25 | 33
Actor26 | 34
Actor27 | 35
Actor28 | 36
Actor29 | 38
Actor30 | 39
Actor31 | 40
Actor32 | 41
Actor33 | 42
Actor34 | 43
Actor35 | 45
Actor36 | 48
Actor37 | 51
Actor38 | 53
Actor39 | 56
Actor40 | 73
Actor41 | 74
Actor42 | 77
Actor43 | 78
Actor44 | 80
Actor45 | 81
Actor46 | 88
Actor47 | 89
Actor48 | 90
Actor49 | 99
Actor50
Actor51
Actor52
Actor53
Actor54
Actor55
Actor56
Actor57
Actor58
Actor59
Actor60
Actor61
Actor62
Actor63
Actor64
Spreadsheet: 99121d1297866690-count-formula-with-conditions-excel-formula-question
Sheet: Monthly

No. | Date | Status | Customer Name | ID No. | Address | City | Mobile No. | Brand | Serial No | Package | Type | Ins |  |  | P.Type | **** | Slaesman |  |  | Entered | Meeting | Telemeeting | Telemeeting 2
1 | 2011-02-01 00:00:00 |  |  |  |  |  |  |  |  | Special | New | Paper |  |  |  |  | [NAME] |  |  | 2011-02-07 00:00:00
2 | 2011-02-06 00:00:00 |  |  |  |  |  |  |  |  |  | Transfer |  |  |  |  |  | [NAME] |  |  | 2011-02-07 00:00:00 | 93 | Tal
3 | 2011-02-06 00:00:00 |  |  |  |  |  |  |  |  |  | Trade In |  |  |  |  |  | [NAME] |  |  | 2011-02-07 00:00:00 | 8 | [NAME]
4 | 2011-02-03 00:00:00 |  |  |  |  |  |  |  |  |  | Transfer |  |  |  |  |  | [NAME] |  |  | 2011-02-07 00:00:00 |  |  | Cellmarket
5 | 2011-02-03 00:00:00 |  |  |  |  |  |  |  |  | Special | Transfer |  |  |  |  |  | [NAME] |  |  | 2011-02-07 00:00:00 |  |  | Cellmarket
6 | 2011-02-08 00:00:00 |  |  |  |  |  |  |  |  | Special | Transfer |  |  |  |  |  | [NAME] |  |  | 2011-02-14 00:00:00 | 6 | [NAME]
7 | 2011-02-08 00:00:00 |  |  |  |  |  |  |  |  |  | Transfer | Paper |  |  |  |  | [NAME] |  |  | 2011-02-14 00:00:00
8 | 2011-02-08 00:00:00 |  |  |  |  |  |  |  |  |  | Transfer | Paper |  |  |  |  | [NAME] |  |  | 2011-02-14 00:00:00
9 | 2011-02-07 00:00:00 |  |  |  |  |  |  |  |  |  | Transfer |  |  |  |  |  | [NAME] |  |  | 2011-02-14 00:00:00 | 12 | [NAME]
10 | 2011-02-07 00:00:00 |  |  |  |  |  |  |  |  | Net |  |  |  |  |  |  | [NAME] |  |  | 2011-02-14 00:00:00
11 | 2011-02-06 00:00:00 |  |  |  |  |  |  |  |  |  | Trade In |  |  |  |  |  | [NAME] |  |  | 2011-02-14 00:00:00
12 | 2011-02-09 00:00:00 |  |  |  |  |  |  |  |  |  | New |  |  |  |  |  | [NAME] |  |  | 2011-02-14 00:00:00 | 39 | [NAME]
 |  |  | Transfer |  | If [NAME]" and column W or X are empty then count
 |  |  | Transfer Meeting |  | If [NAME]" and column W not emty then count
 |  |  | Transfer Meeting 2 |  | If [NAME]" and column X not emty then count
 |  |  | New |  | If Column L="New" and column W or X are empty then count
 |  |  | New Meeting |  | If Column L="New" and column W not emty then count
 |  |  | New Meeting 2 |  | If Column L="New" and column X not emty then count
 |  |  | Car |  | If [NAME]" then count
 |  |  | Insurance |  | If Column M not empty then count
 |  |  | Special |  | If Column K="Special" then count
 |  |  | Net |  | If Column K="Net' Then Count