tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 38103d1236208925-data-print-eleg-fee-collection
Sheet: Data Base

Fee Collection Software 2009 |  |  |  |  |  |  |  |  |  |  | Class |  | Prep Green
S/No | Admission No | N    a    m    e | Fathere Name | Admission fee | Annual fee | Monthly fee | Discount | Science Lab Fee | Security fee | Books | Arrears | Other | Total Amount | % age Obtained | Grade | Print
 |  | Min Marks
 |  | [NAME] |  | 3000 | 300 | 510 |  | 450 | 500 | 0 | 0
1 | 700 | [NAME] | M.Ayaz | 0 | 300 | 510 | 0 |  | 500 | 500 |  |  | 1810 |  |  |  | If click here go on print page.I want cahnge value
2 | 22 | [NAME] | M.Saleem | 0 | 444 | 444 | 55 |  | 444 | 444 |  |  | 1831 |  |  |  | WANT IF CLICK ON 2ND NAME IT SHOW THIS ROW DATA
3 | 33 | [NAME] | M.Ali | 0 | 300 | 510 | 0 |  | 500 | 500 |  |  | 1810
4 | 44 |  |  | 0 | 300 | 510 | 0 |  | 500 | 500 |  |  | 1810
5 | 77 |  |  | 0 | 300 | 510 | 0 |  | 500 | 500 |  |  | 1810
6 | 99 |  |  | 0 | 300 | 510 | 0 |  | 500 | 500 |  |  | 1810
7 |  |  |  | 0 | 300 | 510 | 0 |  | 500 | 500 |  |  | 1810
8 |  |  |  | 0 | 300 | 510 | 0 |  | 500 | 500 |  |  | 1810
9 |  |  |  | 0 | 300 | 510 | 0 |  | 500 | 500 |  |  | 1810
10 |  |  |  |  |  |  |  |  |  |  |  |  | 0
11 |  |  |  |  |  |  |  |  |  |  |  |  | 0
12 |  |  |  |  |  |  |  |  |  |  |  |  | 0
13 |  |  |  |  |  |  |  |  |  |  |  |  | 0
14 |  |  |  |  |  |  |  |  |  |  |  |  | 0
15 |  |  |  |  |  |  |  |  |  |  |  |  | 0
16 |  |  |  |  |  |  |  |  |  |  |  |  | 0
17 |  |  |  |  |  |  |  |  |  |  |  |  | 0
18 |  |  |  |  |  |  |  |  |  |  |  |  | 0
19 |  |  |  |  |  |  |  |  |  |  |  |  | 0
20 |  |  |  |  |  |  |  |  |  |  |  |  | 0
21 |  |  |  |  |  |  |  |  |  |  |  |  | 0
22 |  |  |  |  |  |  |  |  |  |  |  |  | 0
23 |  |  |  |  |  |  |  |  |  |  |  |  | 0
24 |  |  |  |  |  |  |  |  |  |  |  |  | 0
25 |  |  |  |  |  |  |  |  |  |  |  |  | 0
26 |  |  |  |  |  |  |  |  |  |  |  |  | 0
27 |  |  |  |  |  |  |  |  |  |  |  |  | 0
28 |  |  |  |  |  |  |  |  |  |  |  |  | 0
29 |  |  |  |  |  |  |  |  |  |  |  |  | 0
30 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 696861d1601016163-fomula-to-display-average-of-last-12-months-data-metric-excel
Sheet: Other Contractors Graph

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Contractors- 12MM, 6MM TRIFR & Reportable Injuries
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | 12MM TRIFR | 6MM TRIFR | LTI- Actual | RWI- Actual | MTI - Actual | TRIFR Target | Employee | Contractor | TRI Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 96ef6867-37e2-477f-a5ef-6aaeb6a8cd0c
Sheet: Interborough Fleet

Car Numbers | Type | Builder | Year Built | Notes
Prototype Cars
3340 | August Belmont | Wason | 1902
3341 | [NAME] | Wason | 1902
Composite Cars
2000-2059 | Hi-V Composite Trailers | [NAME] | 1903
2060-2119 | Hi-V Composite Trailers | St. Louis | 1903
2120-2159 | Hi-V Composite Trailers | Wason | 1903
3000-3039 | Hi-V Composite Motors | [NAME] | 1904
3040-3139 | Hi-V Composite Motors | [NAME] | 1903-1904
3140-3279 | Hi-V Composite Motors | St. Louis | 1903-1904
3280-3339 | Hi-V Composite Motors | Wason | 1903-1904
Hi-V Cars
3342 | Hi-V "Gibbs Altoona" Motor | PRR-Altoona Shops | 1903
3344 | Mineola | Wason | 1904
3350-3649 | Hi-V "Gibbs" Motors | ACF | 1904-1905
3650-3699 | Hi-V "Deck Roof" Motors | ACF | 1907-1908
3700-3809 | Hi-V Standard Motors | ACF | 1910-1911
3810-3849 | Hi-V Standard Motors | Standard Steel | 1910-1911
3850-4024 | Hi-V Standard Motors | Pressed Steel | 1910-1911
4223-4514 | Hi-V Standard Trailers | Pullman | 1915
Low-V Cars
4025-4036 | [NAME] | Pullman | 1915
4037-4160 | [NAME] | Pullman | 1915
4161-4222 | [NAME] | Pullman | 1915
4215-4222 | [NAME] | IRT | 1929 | Note 1
4515-4576 | [NAME] | Pullman | 1916
4555-4576 | [NAME] | IRT | 1929 | Note 2
4577-4699 | [NAME] | Pullman | 1916
4700-4770 | [NAME] | Pullman | 1916
4771-4810 | [NAME] | Pullman | 1916
4811-4965 | [NAME] | Pullman | 1916-1917
4966-5302 | [NAME] | Pullman | 1917
5303-5377 | [NAME]) | Pullman | 1922
5378-5402 | [NAME] | Pullman | 1922
5403-5502 | [NAME] | Pullman | 1922
5503-5627 | [NAME] | ACF | 1925
5628-5652 | [NAME] | ACF | 192x
5653-5702 | [NAME] Fair Steinway" Motors | St. Louis | 1938
4719 | [NAME] | IRT | 1942 | Note 3
4771 | [NAME] | IRT | 1942 | Note 4
Notes
Note 1-Converted from Flivver Trailers by IRT in 1929
Note 2-Converted from [NAME] by IRT in 1929
Note 3-[NAME] converted to [NAME] by IRT in 1942
Note 4-Standard Lo-V motor converted to [NAME] by IRT in 1942
Spreadsheet: 880601d1728409193-automated-calendar-with-changing-holidays-vakantie-template-mbv-cadix
Sheet: augustus

 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opgenomen vakantie | Resterende vakantie
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Maxime
VPK | [NAME]
 | Cédric
 | Elke
 | Ellen
 | Els
 | Gert
 | Ief
 | [NAME]
 | Joeri
 | [NAME]
 | Kelly
 | [NAME]
 | [NAME]
 | Michel
 | Mirthe
 | Nadia
 | Neslihan
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
ZK | Annelies
 | Herly
 | Nadia
 | Nele
 | Ranka
 | Sid
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
[NAME] | [NAME]
 | [NAME]
 | Hilde
 | Samira
 | Vicky
 | Tyra
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
Spreadsheet: 107502d1304648212-excel-2007-nested-counting-duplicates-example
Sheet: Current Result

Items | Parts to Make | Tools for current Step | Tools to complete up to this step
Item A | N/A | Hammer, Screwdriver
Item B | N/A | Hammer, Saw
Item C |  | Hammer
Item D |  | Hammer
Spreadsheet: 94232d1294092990-auto-fill-consecutive-row-after-processing-from-different-sheet-__inputoutput-snb
Sheet: Cash Balance

Date | Input | Output | [NAME] | Balance
2010-03-29 00:00:00 | 75600000 | 74652500 |  | 947500
2010-03-29 00:00:00 | 43470000 | 45200000 |  | -1730000
2011-03-29 00:00:00 | 36120000 | 25080000 |  | 11040000
 | 0 | 40440000 |  | -40440000
 | 0 | 29841800 |  | -29841800
 | 0 | 36815600 |  | -36815600
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
2011-03-30 00:00:00 | 41862500 | 0 |  | 41862500
 | 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
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
2010-02-20 00:00:00 | 5515 | 74652500 |  | -74646985
2010-03-26 00:00:00 | 3616 | 45200000 |  | -45196384
2010-03-26 00:00:00 | 2280 | 25080000 |  | -25077720
 | 0 | 0 |  | 0
2010-03-27 00:00:00 | 5055 | 40440000 |  | -40434945
2010-03-28 00:00:00 | 2227 | 29841800 |  | -29839573
2011-03-28 00:00:00 | 2969 | 36815600 |  | -36812631
 | 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
 | 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
 |  |  | Total | -252008238
Spreadsheet: 127615d1320427042-working-out-a-tariff-from-a-date-and-time-peak-time
Sheet: Counts

Month | Peak |  | [NAME]
2011-01-01 00:00:00
Spreadsheet: 7864031c-edd0-4d68-aa83-87c04c295f40
Sheet: KCMBU Rev

 |  | REQUEST FOR SUPPLEMENTAL REVENUE
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Police
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  |  |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | REVENUE
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 2390 |  | 210000 |  | 4xxxxx |  |  |  | 299730 |  | Inc
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
[NAME]:
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 872452d1718827478-formula-help-roundup-etaf
Sheet: Sheet1

1.1 |  |  |  |  |  |  |  | 2 | 3.188 | 4.65
1.15
1.2
1.25
1.3
1.35
1.4
1.45
1.5
1.55
1.6
1.65
1.7
1.75
1.8
1.85
1.9
1.95
2
2.05
2.1
2.15
2.2
2.25
2.3
2.35
Spreadsheet: 690907d1597351434-vlookup-that-would-return-the-row-that-has-data-only-excel-question
Sheet: Vlookup Data

Job # | Contract | Not Contract
XZY100 | 1000 | 2000 |  |  | How do I input a formula into B2:C4 so that it would return the data like I have on the right?
AAA200 | 3000 | 4000
XXX300 | 5000 | 6000
Job Number | Contract | Not Contract
XZY100 | 1000 | 2000
AAA200 | 3000 | 4000
XXX300 | 5000 | 6000
Spreadsheet: 54635d1254682235-displaying-names-across-different-spreadsheets-and-sorting-freshmen-205-1-
Sheet: Teachers

Ms. [NAME] | Tutors |  | Ms. [NAME]/Ms. [NAME] | Tutors |  | Ms. [NAME] | Tutors
Berry, [NAME] |  |  | Bisbee, [NAME] |  |  | Frigo, Mary
Boothe, [NAME] |  |  | Brown, Jaylon |  |  | Jennings, [NAME]
Brown, Martez |  |  | Cortes, [NAME] |  |  | Jordan, Cheyenne
Dennis, [NAME] |  |  | Cox, [NAME] |  |  | Lamothe, Nathasa
[NAME], [NAME] |  |  | [NAME] |  |  | [NAME], [NAME]
Fitzsimmonds, Will |  |  | Derrick, [NAME] |  |  | McClure, Justin
[NAME], [NAME] |  |  | Frazier, Kelsea |  |  | [NAME]
[NAME], [NAME] |  |  | Gonzalez, Rolando |  |  | Okpala, [NAME]
[NAME], Ester |  |  | Harris, Dayona |  |  | Omoghibo, Eseh
[NAME], [NAME] |  |  | Haymer, Elijah |  |  | Penn, Amanda
Jones, Lakesha |  |  | Herrera, [NAME] |  |  | [NAME], [NAME]
[NAME], Ulysses |  |  | [NAME], [NAME] |  |  | [NAME], [NAME]
Lemieux- Jordan, [NAME] |  |  | Jordine, Giovanni |  |  | Rojo, Enya
[NAME], Alexis |  |  | Nezic, [NAME] |  |  | Tennant, [NAME]
Payne, [NAME] |  |  | Pigozzi, [NAME] |  |  | [NAME], [NAME]
[NAME], Kareen |  |  | [NAME], [NAME] |  |  | Walsh, [NAME]
Shoaf, [NAME] |  |  | [NAME], [NAME] |  |  | Watkins, [NAME]
Shumaker, [NAME] |  |  | Rosenheck, Alec |  |  | Zayed, [NAME]
[NAME], Jovan |  |  | Smith, Jemone
[NAME], Courvosior |  |  | Yarbrough, [NAME]
Spreadsheet: benjamin_rogers__1014__tasking letter deliverables 121799
Sheet: deliverables

 |  | Delmarva Power Project Due Diligence
Section number |  | Section Description | Example/Basis | Responsible to execute
 | TABLE OF CONTENTS
Section | Section Title
1 | Executive Summary
 | 1.1 | Facility Design
 | 1.2 | Station Performance
 | 1.3 | Project Cost and Schedule
 | 1.4 | Environmental, Permits and [NAME]
 | 1.5 | Contracts and Agreements
 | 1.6 | Risk and Insurance Assessment
 | 1.7 | Economic Analysis
 | 1.8 | Conclusions
2 | Introduction
 | 2.1 | Scope of Work
 | 2.2 | Project Description
 | 2.3 | Principal Project Participants
3 | Facility Design
 | 3.1 | Approach
 | 3.2 | General Facility Design
 | 3.3 | Mechanical Systems
 | 3.4 | Civil, Structural and Geotechnical
 | 3.5 | Electrical Systems
 | 3.6 | Instrumentation and Controls
 | 3.7 | Water Treatment
 | 3.8 | Off-Sites
4 | Station Performance
 | 4.1 | Availability
 | 4.2 | Performance Guarantees
 | 4.3 | Power Production
 | 4.4 | Fuel Consumption
 | 4.5 | Performance Testing
5 | Project Costs
 | 5.1 | EPC Cost
 | 5.2 | Owner Soft Costs
 | 5.3 | Annual Operating and [NAME]
6 | Project Schedule
 | 6.1 | Schedule Overview
 | 6.2 | Engineering and Procurement
 | 6.3 | Construction Schedule
7 | Environmental and Permitting
 | 7.1 | Review of Available Permits and [NAME]
 | 7.2 | Un-issued Permits and [NAME]
8 | Contracts and Agreements
 | 8.1 | Engineering, Procurement and Construction Contract
 | 8.2 | Power Purchase Agreement
 | 8.3 | Operations and [NAME]
 | 8.4 | Major Equipment Purchase Orders
 | 8.5 | Fuel Agreement
9 | Risk and Insurance Assessment
 | 9.1 | Engineering, Procurement and Construction Agreement
 | 9.2 | Power Purchase Agreement
 | 9.3 | Operations and [NAME]
 | 9.4 | Major Equipment Purchase Orders
10 | Economic Analysis
 | 10.1 | Engineering, Procurement and Construction Agreement
 | 10.2 | Power Purchase Agreement
 | 10.3 | Operations and [NAME]
 | 10.4 | Major Equipment Purchase Orders
11 | Default Considerations
 |  | Likely overhaul scope, schedule and cost
 |  | O&M planning
Spreadsheet: 725057d1616513688-autosum-drag-down-column-at-fixed-intervals-in-data-example-2-
Sheet: SUMMARY

S.NO. | TOWER/SHOP/FLAT | MONTHLY RENT | TOTAL RENT RECEIVABLE | RENT PAID | LAST MONTH |  | MONTH DUE | AMOUNT
1 | Tenant 1 | 40000
2 | [NAME] | 35000
3 | Tenant 3
4 | [NAME]
5 | Tenant 5
6 | Tenant 6
Spreadsheet: phillip_m_love__30062__CentralFRED0800
Sheet: AVar

Financial Liquidation Variances
GL Perspective: Economics to Review
TAGG | GL Amount | [NAME] | [NAME] |  | Desk Adjustment | GL Adjustment/Reclass | Comments
EW4976.4 | -1869999.85 | -1869999.85
N90091.5 | -1757799.863 | -1757799.859
[NAME] | -744999.95 | 0
NB4325.4 | -364653 | 0
NV8650.4 | -305437.5 | 0
NB4011.1 | -223818.45 | 0
NA7585.4 | -161240 | 0
E28811.I | -158689 | 0
EXOTIC-T | -130735 | 0
E28811.5 | -127505 | 0
NB4304.1 | -74606.15 | 0
E85005.K | -50556.26 | 0
NW0661.3 | -29822.5 | 0
E22563.8 | -23929.54 | 0
NA7585.C | -150 | 0
NM5846.2 | -0.1085 | 0
NM5846.1 | 0.0775 | 0
NA7585.D | 150 | 0
NS7895.1 | 6566.73 | 0
24918/24 | 7096.32284235991 | 0
NX3715.1 | 10000 | 0
24554/24 | 10049.1921650316 | 0
NS7894.1 | 19121.9625 | 0
NW0661.2 | 29822.5 | 0
E28811.E | 127505 | 0
N02838.1 | 161200 | 0
NA7585.5 | 161240 | 0
NV8650.5 | 305437.5 | 0
E49515.2 | 352125.9 | 0
NB4325.5 | 364653 | 0
EW4539.3 | 744999.95 | 744999.95
N70012.R | 1751337.3629 | 1751337.3589
N90091.7 | 1757799.863 | 1757799.859
Spreadsheet: 843080d1695047720-using-string-length-in-vlookup-match-etc-book1
Sheet: Sheet1

C-FL-22-28051A |  | R-ZD-23-45013 A
C-FL-23-13733 |  | R-ZD-23-43997 A
C-FL-23-15176B |  | R-ZD-23-43023 A A
C-FL-23-29042 A |  | R-ZD-23-40418
C-FL-23-37678 |  | R-ZD-23-29649 A B
C-FL-23-43848 |  | R-ZC-23-42567 A
C-FM-23-32786 A |  | R-ZB-23-44530 A
C-FM-23-33083 |  | R-VB-23-43818 A A
C-FM-23-35159 |  | R-VB-23-43666 A A
C-FM-23-35747 |  | R-VB-22-38423 A B
C-FM-23-36202 A |  | R-VA-23-43608 A A
C-FM-23-36280 |  | R-VA-23-31939 A A
C-FM-23-37174 |  | R-ME-23-42125 A
C-FM-23-38643 |  | R-ME-23-41876 A
C-FM-23-40810 |  | R-ME-23-41581 B
C-VP-23-36664 |  | R-ME-22-20605 A C
N-HD-23-00548 B |  | R-MD-23-41266 A
N-HD-23-00846 D |  | R-MB-23-44306 A
N-HD-23-01158 A |  | R-KE-23-44589 A
N-HD-23-01159 |  | R-KE-23-42341 A
N-HD-23-01204 |  | R-KE-23-41864 A
N-HD-23-01323 |  | R-KB-23-43446 A
N-HD-23-01324 |  | R-KB-23-37165 A A
N-HD-23-01328 |  | R-JJ-23-44044 A
N-HD-23-01331 |  | R-JG-23-41995 A
N-HD-23-01332 |  | R-CB-23-41976 A
N-HD-23-01357 A |  | R-BH-23-42363 A
N-HD-23-01371 A |  | R-AC-23-16956 A C
N-HD-23-01376 |  | R-AA-23-42485 A
P-FC-23-34796 A |  | R-21-23-36051 A B
P-FC-23-40292 |  | P-SS-23-38742 B A
P-SS-23-40215 |  | P-SS-23-36154 A A
R-AB-23-37882 |  | P-FC-23-44758 A
R-AC-23-16956 C |  | P-FC-23-44523 A
R-HC-23-38796 |  | P-FC-23-44121 B
R-JJ-23-44044 |  | P-FC-23-37087 A
R-KB-23-38076 |  | P-FC-23-36768 A
R-KE-23-40724 |  | P-FC-23-35811 A
R-ME-23-41849 |  | P-FC-23-33282 A
R-ZB-23-23518A |  | P-FC-23-30782 A A
R-ZD-23-42720 |  | P-FC-23-16846 A A
 |  | P-FC-22-10626 A B
 |  | N-HD-23-01376
 |  | N-HD-23-01374
 |  | N-HD-23-01373
 |  | N-HD-23-01371
 |  | N-HD-23-01364
 |  | N-HD-23-01361
 |  | N-HD-23-01360
 |  | N-HD-23-01359
 |  | N-HD-23-01357
 |  | N-HD-23-01355
 |  | N-HD-23-01354
 |  | N-HD-23-01352
 |  | N-HD-23-01351
 |  | N-HD-23-01345
 |  | N-HD-23-01342
 |  | N-HD-23-01036
 |  | N-HD-23-00958A
 |  | N-HD-23-00854
 |  | N-HD-23-00846D
 |  | N-HD-23-00846
 |  | N-HD-23-00624
 |  | N-HD-23-00548
 |  | c-VP-23-40886 A
 |  | C-FM-23-44696 A
 |  | C-FM-23-44553 A
 |  | C-FM-23-44509 A
 |  | C-FM-23-44315 A
 |  | C-FM-23-44257 A
 |  | C-FM-23-44144 A
 |  | C-FM-23-44011 A
 |  | C-FM-23-43600 A
 |  | C-FM-23-43283 A N
 |  | C-FM-23-43283
 |  | C-FM-23-43063 A
 |  | C-FM-23-42711 A A
 |  | C-FM-23-40918 A A
 |  | C-FM-23-40491 A A
 |  | C-FM-23-40014 A
 |  | C-FM-23-38940 A B
 |  | C-FM-23-38038 A
 |  | C-FM-23-37801 A
 |  | C-FM-23-37616 A
 |  | C-FM-23-37425 A
 |  | C-FM-23-37388
 |  | C-FM-23-32786 A A
 |  | C-FM-23-32196 A
 |  | C-FM-23-32055 A A
 |  | C-FM-23-31220 A A
 |  | C-FM-23-28362 A A
 |  | C-FM-23-23697 A
 |  | C-FM-22-39264 A A
 |  | C-FM-21-34795 A C
 |  | C-FM-21-31282 A B
 |  | C-FL-23-44932 A
 |  | C-FL-23-43941
 |  | C-FL-23-43848 A
 |  | C-FL-23-43672 A
 |  | C-FL-23-43460 B
 |  | C-FL-23-43020 A
 |  | C-FL-23-38737
 |  | C-FL-23-38019
 |  | C-FL-23-36580 A
 |  | C-FL-23-26640 A C
 |  | C-FL-23-24070 A A
 |  | C-FM-23-42330
Spreadsheet: 836543d1689481516-formula-to-create-similar-function-to-a-pivot-table-example-127-aligw
Sheet: Sheet1

 | Current data |  |  |  | Result
 | apple | 2001 table one|2004 room two|2464 black three|2487 red five |  |  |  | 2001 table one | 2002 chair six | 2003 green seven | 2004 room two
 | banana | 2002 chair six | 2001 table one |  |  | apple
 | apple | 2003 green seven |  |  | banana
 | orange | 2004 room two | 2010 hello ten |  |  | orange
 | banana | 2002 chair six
 | apple | 2078 gray five | 2088 brown two | 2090 water one | 2001 table one
Spreadsheet: 117602d1312906260-excel-sorting-issue-book1
Sheet: Sheet1

1.1.1 | 1.1.1
1.2.1 | 1.2.1
1.2.2.4 | 1.2.2.4
1.2.2.5 | 1.2.2.5
1.3.1.1.1 | 1.3.1.1.1
1.3.1.1.2 | 1.3.1.1.2
1.3.1.1.3 | 1.3.1.1.3
1.3.1.1.4 | 1.3.1.1.4
1.3.1.1.5 | 1.3.1.1.5
1.3.1.1.6 | 1.3.1.1.6
1.3.1.1.7 | 1.3.1.1.7
1.3.1.3.1 | 1.3.1.3.1
1.3.1.3.10 | 1.3.1.3.10
1.3.1.3.11 | 1.3.1.3.11
1.3.1.3.12 | 1.3.1.3.12
1.3.1.3.13 | 1.3.1.3.13
1.3.1.3.14 | 1.3.1.3.14
1.3.1.3.15 | 1.3.1.3.15
1.3.1.3.16 | 1.3.1.3.16
1.3.1.3.17 | 1.3.1.3.17
1.3.1.3.18 | 1.3.1.3.18
1.3.1.3.19 | 1.3.1.3.19
1.3.1.3.2 | 1.3.1.3.2
1.3.1.3.20 | 1.3.1.3.20
1.3.1.3.21 | 1.3.1.3.21
1.3.1.3.22 | 1.3.1.3.22
1.3.1.3.23 | 1.3.1.3.23
1.3.1.3.24 | 1.3.1.3.24
1.3.1.3.25 | 1.3.1.3.25
1.3.1.3.26 | 1.3.1.3.26
1.3.1.3.27 | 1.3.1.3.27
1.3.1.3.28 | 1.3.1.3.28
1.3.1.3.29 | 1.3.1.3.29
1.3.1.3.3 | 1.3.1.3.3
1.3.1.3.30 | 1.3.1.3.30
1.3.1.3.31 | 1.3.1.3.31
1.3.1.3.32 | 1.3.1.3.32
1.3.1.3.33 | 1.3.1.3.33
1.3.1.3.34 | 1.3.1.3.34
1.3.1.3.35 | 1.3.1.3.35
1.3.1.3.36
1.3.1.3.37
1.3.1.3.38
1.3.1.3.39
1.3.1.3.4
1.3.1.3.40
1.3.1.3.41
1.3.1.3.42
1.3.1.3.43
1.3.1.3.44
1.3.1.3.45
[NAME]
1.3.1.3.47
1.3.1.3.48
1.3.1.3.5
1.3.1.3.6
1.3.1.3.7
1.3.1.3.8
1.3.1.3.9
1.3.1.4.1
1.3.1.4.10
1.3.1.4.11
1.3.1.4.12
1.3.1.4.13
1.3.1.4.14
1.3.1.4.15
1.3.1.4.16
1.3.1.4.17
1.3.1.4.18
1.3.1.4.19
1.3.1.4.2
1.3.1.4.20
1.3.1.4.21
1.3.1.4.22
1.3.1.4.23
1.3.1.4.24
1.3.1.4.25
1.3.1.4.26
1.3.1.4.27
1.3.1.4.28
1.3.1.4.29
1.3.1.4.3
1.3.1.4.30
1.3.1.4.31
1.3.1.4.4
1.3.1.4.5
1.3.1.4.6
1.3.1.4.7
1.3.1.4.8
1.3.1.4.9
1.3.1.8.2
1.4.2
1.5.1
Spreadsheet: 886964d1737048043-formula-for-sorting-data-example-1
Sheet: Sheet1

Catalog Item |  | Output from formula you gave me.
B2581 |  | 00146 | EA | 11.5 | 10
B2582 |  | 00148 | EA | 6.48 | 5.34
B2583 |  | 00159 | 0 | 95 | 79
B2584 |  | 00169 | EA | 62 | 53
B2585 |  | 00181 | EA | 1.91 | 1.57
B3580 |  | 00182 | EA | 9.11 | 7.51
B3581 |  | 00183 | EA | 129 | 109
B3582 |  | 00184 | PK | 12.4 | 10.22
B2570 |  | 00192 | CD | 12.71 | 11.44
B2571 |  | 00192 | EA | 1.79 | 1.43
B2572 |  | 00198 | EA | 5.34 | 4.4
B2573 |  | 00231 | EA | 9.53 | 7.86
B2578 |  | 00236 | EA | 4.99 | 4.11
B3600KIT |  | 00237 | CAN100 | 11.49 | 9.48
B4620 |  | 00242 | EA | 2.81 | 2.32
B2565 |  | 00243 | EA | 2.81 | 2.32
B4600 |  | 00244 | EA | 2.89 | 2.39
B2574 |  | 00246 | EA | 3.67 | 3.03
[NAME] |  | 00250 | EA | 6.07 | 5.01
B2576 |  | 00254 | EA | 3.8 | 3.13
B2577 |  | 00256 | EA | 5.86 | 4.83
B2578 |  | 00320 | EA | 6.46 | 5.33
B6603 |  | 00321 | EA | 4.19 | 3.45
B6605 |  | 00322 | EA | 5.47 | 4.51
B6602 |  | 00323 | EA | 5.47 | 4.51
B4621 |  | 00324 | EA | 1.07 | 0.88
B6604 |  | 00325 | EA | 1.46 | 1.2
P700511 |  | 00335 | CD10 | 27.78 | 25
P700521 |  | 00335 | EA | 3.13 | 2.5
P700522 |  | 00336 | CD10 | 11.78 | 10.6
[NAME] |  | 00336 | EA | 1.33 | 1.06
Spreadsheet: 717898d1612891590-if-vlookup-if-vlookup-is-blank-run-if-formula-if-still-blank-return-a-blank-sample-data
Sheet: Tab 2

Order # | Provider | Service | Zone
85594-089 | APC | DDP
85594-088 | APC | DDU
27331 | UPS | Ground
10286 | Stamps.com | FCM
10285 | Stamps.com | PM
Spreadsheet: 119258d1314289638-cell-chooses-a-set-value-or-becomes-a-list-tigeravatar-example-for-alexwgordon
Sheet: Sheet1

Choice | Standard Set | Custom Options |  |  |  |  | Cst Op 1s | Cst Op 2s | Cst Op 3s | Cst Op 4s | Cst Op 5s | Cst Op 6s | Cst Op 7s | Cst Op 8s | Cst Op 9s | Cst Op 10s
Custom |  |  |  |  |  |  | Cst Op 1A | Cst Op 2A | Cst Op 3A | [NAME] | Cst Op 5A | Cst Op 6A | Cst Op 7A | Cst Op 8A | Cst Op 9A | Cst Op 10A
 |  |  |  |  |  |  | Cst Op 1B | Cst Op 2B | Cst Op 3B | Cst Op 4B | Cst Op 5B | Cst Op 6B | Cst Op 7B | Cst Op 8B | [NAME] | Cst Op 10B
 |  |  |  |  |  |  | Cst Op 1C | [NAME] | Cst Op 3C | Cst Op 4C | Cst Op 5C | Cst Op 6C | Cst Op 7C | Cst Op 8C | [NAME] 9C | Cst Op 10C
Spreadsheet: 78571d1278950841-excel-2007-multiple-if-vlookup-filling-data-on-multiple-criterias-staffonduty
Sheet: Calendar

 |  | Month |  |  | Year
 |  | June |  |  | 2010
 |  | Sunday |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday
 |  |  |  |  |  |  |  | 2010-06-01 00:00:00 |  |  | 2010-06-02 00:00:00 |  |  | 2010-06-03 00:00:00 |  |  | 2010-06-04 00:00:00 |  |  | 2010-06-05 00:00:00
Spreadsheet: 154090d1336197206-apply-conditional-formatting-to-date-differences-without-weekends-or-holidays-testcf
Sheet: Calendar

Observed | Public Holiday name | Stat Date | Year | Month
2012-01-02 00:00:00 | New Year's Day | 2012-01-01 00:00:00 | 2012 | 2012-04-01 00:00:00
2012-01-26 00:00:00 | Australia Day | 2012-01-26 00:00:00 |  | 2012-05-05 00:00:00
2012-04-06 00:00:00 | Easter Friday
2012-04-09 00:00:00 | Easter Monday
2012-04-25 00:00:00 | Anzac Day | 2012-04-25 00:00:00
2012-06-11 00:00:00 | Queen's Birthday | 2012-06-11 00:00:00 | 2012-06-01 00:00:00
2011-12-26 00:00:00 | Christmas Day | 2011-12-25 00:00:00
2011-12-27 00:00:00 | Boxing Day | 2011-12-26 00:00:00
2011-12-28 00:00:00 | Corp Holiday
Spreadsheet: 267148d1379969365-can-you-get-two-or-more-results-from-an-if-statement-copy-of-excel-help
Sheet: Sheet1

 | 2013-08-26 00:00:00 | 2013-10-13 00:00:00
 | Date |  |  | So the date in B3:B6 is populated from another sheet
BA |  |  |  | I want the date to come across only when between the dates in b1 and c1
CR1 |  |  |  | This I can do but when we move down to the dates in b8 and c8 when more training happens the date would go into b10 but then would loose the date in b3
Triage |  |  |  | So I do training on the 01/09/13 in BA this would come across into b3.  Then if I do training on the 15/10/13  it would come up in B10 but I would loose the date in B3
GTS |  |  |  | This is what I want to stop
 |  |  |  | So what I want is for the cells b3:b6 only to update during the dates in b1 c1
 | 2013-10-14 00:00:00 | 2013-12-01 00:00:00
 | Date
BA
CR1
Triage
GTS