tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_dorland__1636__Aeco_Forecast_08_20_2000
Sheet: Dorland Aeco Forecast

 |  | Alberta Supply & Demand Forecast
 |  | Empress | McNeill | Alliance | ABC | [NAME]. | Other Borders | Intra- Alberta | Total Demand | Field Receipts | Net Storage | Storage Inventory* | Days
 |  |  |  |  |  |  |  |  |  |  |  | 159000
2000-08-01 00:00:00 |  | 6400 | 2150 | 0 |  | -70 | 50 | 1475 |  | 12400
2000-09-01 00:00:00 |  | 6350 | 2150 | 0 | 2150 | -70 | 50 | 1500 |  | 12300
2000-10-01 00:00:00 |  | 6050 | 2150 | 1150 |  | 0 | 20 | 1575 |  | 12275
2000-11-01 00:00:00
Aug-Oct 00
2000-11-01 00:00:00 |  | 5700 | 2160 | 1150 | 2450 | 0 | 30 | 1750 |  | 12584
2000-12-01 00:00:00 |  | 5700 | 2160 | 1150 | 2630 | 0 | 30 | 1875 |  | 12655
2001-01-01 00:00:00 |  | 5700 | 2160 | 1150 | 2650 | 0 | 30 | 1925 |  | 12637
2001-02-01 00:00:00 |  | 5700 | 2160 | 1150 | 2610 | 0 | 30 | 1825 |  | 12637
2001-03-01 00:00:00 |  | 5700 | 2160 | 1150 | 2370 | 0 | 30 | 1720 |  | 12800
2001-04-01 00:00:00
Nov00 - Mar00
Spreadsheet: 695668d1600337181-my-what-if-analysis-data-table-is-giving-me-the-same-answer-assessment-1
Sheet: GSBI41

 | GSBI41
 | Input
 | Day Conversion | Actual/Actual
 | Annual Coupon Rate | 0.0275
 | Face Value | 100
 | YTM | 0.01635
 | Coupon Payment
 | Settlement Date | 2020-07-20 00:00:00
 | Maturity Date | 2041-05-21 00:00:00
 | Number of Payments | 2
 | Output
 | Bond Value Calculation
 | Periods | 0 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42
 | Settlement/Payment Date | 2020-07-20 00:00:00 | 2020-11-23 00:00:00 | 2021-05-23 00:00:00 | 2021-11-23 00:00:00 | 2022-05-23 00:00:00 | 2022-11-23 00:00:00 | 2023-05-23 00:00:00 | 2023-11-23 00:00:00 | 2024-05-23 00:00:00 | 2024-11-23 00:00:00 | 2025-05-23 00:00:00 | 2025-11-23 00:00:00 | 2026-05-23 00:00:00 | 2026-11-23 00:00:00 | 2027-05-23 00:00:00 | 2027-11-23 00:00:00 | 2028-05-23 00:00:00 | 2028-11-23 00:00:00 | 2029-05-23 00:00:00 | 2029-11-23 00:00:00 | 2030-05-23 00:00:00 | 2030-11-23 00:00:00 | 2031-05-23 00:00:00 | 2031-11-23 00:00:00 | 2032-05-23 00:00:00 | 2032-11-23 00:00:00 | 2033-05-23 00:00:00 | 2033-11-23 00:00:00 | 2034-05-23 00:00:00 | 2034-11-23 00:00:00 | 2035-05-23 00:00:00 | 2035-11-23 00:00:00 | 2036-05-23 00:00:00 | 2036-11-23 00:00:00 | 2037-05-23 00:00:00 | 2037-11-23 00:00:00 | 2038-05-23 00:00:00 | 2038-11-23 00:00:00 | 2039-05-23 00:00:00 | 2039-11-23 00:00:00 | 2040-05-23 00:00:00 | 2040-11-23 00:00:00 | 2041-03-21 00:00:00
 | Time
 | [NAME]
 | Cash Flows |  | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 1.375 | 100.375
 | Present Value of Cash Flows
 | The Price of the Bond
 | Duration:
 | PV(CF) * t
 | Duration
 | YTM |  | 0 | 0.005 | 0.01 | 0.015 | 0.02 | 0.025 | 0.3 | 0.035 | 0.04 | 0.045 | 0.05 | 0.055 | 0.06 | 0.065 | 0.07 | 0.075 | 0.08
 | Duration |  |  | 16.77594050187865 | 16.5778215305185 | 16.37154719657656 | 16.15711657258483 | 15.93457302270266 | 3.774516652040586 | 15.46556191304244 | 15.21943089666259 | 14.96586447712417 | 14.7051689323903 | 14.43770731203939 | 14.1638990173084 | 13.88421845343828 | 13.59919271476628 | 13.30939828922116 | 13.01545679792731
 | YTM |  | 0 | 0.005 | 0.01 | 0.015 | 0.02 | 0.025 | 0.3 | 0.035 | 0.04 | 0.045 | 0.05 | 0.055 | 0.06 | 0.065 | 0.07 | 0.075 | 0.08
 | Quote Price |  |  | 144.0692514710532 | 132.5428911079073 | 122.0620444094153 | 112.5282637960056 | 103.8525219591855 | 9.085468391714482 | 88.76078086953282 | 82.20607949453401 | 76.23060191983711 | 70.78042641265185 | 65.80676026715706 | 61.26544660568651 | 57.11651890031191 | 53.32379857965485 | 49.85453153713804 | 46.67905976423325
Spreadsheet: 734333d1622114885-coloring-cells-by-conditional-formating-with-fis-testkleur-rijen2
Sheet: Hours

Project | Datum | Firma | Nummer | Vertrek | Tijd | Aankomst | Naam | Telefoon | Tropco's | Aantal | [NAME] | Wie D | Inkoop NL | Inkoop D | [NAME] | Verkoop D
5235 |  |  |  |  |  |  |  |  | 2 | 1 |  | nl |  |  |  |  |  | Uren inkoop |  |  | Km inkoop
5258 |  |  |  |  |  |  |  |  | 1 | 2 | [NAME] | nl |  |  |  |  |  | Uren verkoop |  |  | Km verkoop
5259 |  |  |  |  |  |  |  |  | 2 | 2 | [NAME] | nl |  |  |  |  |  | Verschil uren |  |  | [NAME] km
5259 |  |  |  |  |  |  |  |  | 2 | 2 |  | nl |  |  |  |  |  | Inkoop NL | 42.5 |  | Inkoop D | 1.15
5259 |  |  |  |  |  |  |  |  | 2 | 2 |  | nl |  |  |  |  |  | Inkoop NL |  |  | Inkoop D
5259 |  |  |  |  |  |  |  |  | 1 | 2 |  | nl |  |  |  |  |  | [NAME] |  |  | Verkoop D
5260 |  |  |  |  |  |  |  |  | 2 | 2 | [NAME] | nl |  |  |  |  |  | [NAME] |  |  | Verschil D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 45 |  | Verkoop D | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj NL ink |  |  | Totaal inkoop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ver |  |  | Totaal verkoop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj KM ink |  |  | Totaal verschil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ver
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project verschil NL |  |  |  | Project verschil D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal uren NL |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal Verkoop NL |  |  | Totaal verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per begeleider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zoek project | Aantal beg | Inkoop NL | Inkoop D | [NAME] | Verkoop D
 |  |  |  | =OF(EN($d2="";AANTALARG($g2:$h2)<>1);EN($d2=<>"";L2=""))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Klant | aantal beg
Spreadsheet: 108112d1305210989-begin-cell-input-when-column-header-matches-cell-value-phasingexample
Sheet: Projects

Budget Capture 2011/12
 |  | Cashflow | Depreciation | Depreciation | VAT
 | Name | Date | Date | Months | applicable | VAT (20%) |  | Units |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Expenditure
 | Telecoms Project | August 2011 | January 2012 | 36 | Yes |  |  |  |  | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
Depreciation
Flags
 |  |  |  |  |  |  |  |  |  | July 2011 | August 2011 | September 2011 | October 2011 | November 2011 | December 2011 | January 2012 | February 2012 | March 2012 | April 2012 | May 2012 | June 2012
Spreadsheet: 69238d1269787789-auto-subtract-2-values-in-current-row-book1-chemoul-2
Sheet: Sheet1

Value 1 | Value 2 | Col"C" | Col"D" | Col"E"
 |  |  |  |  |  |  |  |  |  | Value 1 | Value 2 | Col"M" | Col"N" | Col"O"
 |  |  |  |  |  |  | Value 1 | Value 2 | Col"J" | Col"K" | Col"L"
 |  |  | Value 1 | Value 2 | Col"F" | Col"G" | Col"H"
No Need for the headers - Just makes the demo ranges easier to find.
Spreadsheet: 812122d1672966954-due-upcoming-overdue-123perwinkle-123
Sheet: R4

Project Phase | Deliverable | Responsible Party | Date Assigned | Date Due | Date Completed | Color | Current Issue? | Issues Resolved? | Due/Overdue | NOTES
Planning & Scope | Meet with HR to discuss collaboration | Jeromy
Planning & Scope | Set meeting to create swimlane to define roles, responsibilities, checks and balances | Jeromy | 2022-12-05 00:00:00 | 2022-12-20 00:00:00
Planning & Scope | Create a TEAM to house documentation | Jeromy | 2022-12-13 00:00:00 | 2022-12-14 00:00:00 | 2022-12-20 00:00:00 |  |  | Yes |  | Upload current checklists to TEAM.  Check CAP Onboarding Documents TEAM first.    Created an 'Onboarding is Awesome' folder in PAT team channel and uploaded SSC Checklist, DHS Welcome letter, and other useful information.
Planning & Scope | Set up a meeting to discuss HR recruitment of GALT staff | Jeromy | 2022-12-20 00:00:00 | 2022-12-31 00:00:00
Spreadsheet: 874697d1721232856-if-function-to-compare-multiple-tabs-rswlaw67-bills-by-pay-cycle
Sheet: Due Enhanced Array Solution

Pay Cycle | Amount Due
2 | 88.49
3 | 269.33
4 | 88.49
5 | 117.48
6 | 198.43
7 | 119.44
8 | 219.4
9 | 132.43
10 | 214.98
11 | 71.3
12 | 286.52
13 | 71.3
14 | 117.48
Spreadsheet: 57211d1257349364-summing-total-per-customer-for-each-month-example
Sheet: Sheet1

Amount | Customer | Ship Date |  |  |  | A | B | C
18.343 | A | 2009-09-30 00:00:00 |  |  | 2009-09-01 00:00:00
18.198 | A | 2009-09-30 00:00:00 |  |  | 2009-10-01 00:00:00
17.708 | A | 2009-09-30 00:00:00 |  |  | 2009-11-01 00:00:00
19.623 | B | 2009-10-16 00:00:00
17.717 | A | 2009-10-08 00:00:00
15.004 | A | 2009-10-08 00:00:00
10.623 | A | 2009-10-08 00:00:00
10.913 | A | 2009-10-14 00:00:00
10.004 | A | 2009-10-14 00:00:00
10.958 | A | 2009-10-14 00:00:00
11.094 | A | 2009-10-14 00:00:00
15.837 | A | 2009-10-21 00:00:00
17.545 | A | 2009-10-21 00:00:00
11.004 | A | 2009-10-21 00:00:00
19.646 | B | 2009-10-30 00:00:00
15.8 | A | 2009-10-28 00:00:00
15.8 | A | 2009-10-28 00:00:00
18.125 | A | 2009-10-28 00:00:00
16.066 | C | 2009-10-30 00:00:00
18.107 | A | 2009-11-04 00:00:00
15.023 | A | 2009-11-04 00:00:00
16.429284 | A | 2009-11-11 00:00:00
Spreadsheet: 55825983-100f-47e7-8691-287c69fd1661
Sheet: SpecialQuestion

Special Question v1: | Projecting ahead over the next 12 months, please assign a percent likelihood to the following changes to unit sales levels.
N | Mean | Median | Mode | Std. [NAME]. (mean of indiv.)
105 | 5.551190476190476 | 5 | 0 | 4.00495626172739
Special Question v2: | Projecting ahead over the next 12 months, please provide the best case, the  middle case, and the worst case percentage change in your firm's unit sales levels.   (Note: "Best case" should correspond to about the top 10 percent likelihood outcome and "worst case" the bottom 10 percent likelihood outcome.)
N | Mean | Median | Mode | Std. [NAME]. (mean of indiv.)
102 | 5.329411764705884 | 3.9 | 10 | 3.501555668328544
Spreadsheet: 57fc1478-223e-4ed1-97e5-3751d703627b
Sheet: Keyword-Pivot

Row Labels
ACCESS CONTROL
AIR COMPRESSOR
AIR CONDITIONING UNIT
AIR DRYER
AIR HANDLING UNIT
AUTOCLAVE
BACKFLOW PREVENTER
BATTERY
BLEACHERS
BLINDS
BOILER
BURNER
CASCADE SYSTEM
CHILLED BEAM
CHILLER
CHIMNEY
CLOCKS, BELLS AND TIMERS
COIL
CONTROLS
CONVEYANCE
[NAME]
DAMPER
DEFIBRILLATOR
DEHUMIDIFIER
DOCK EQUIPMENT
DOOR
DRAIN
DUST COLLECTOR WOOD, WELDING
ELECTRICAL SYSTEM
ELECTRICAL, CARBON MONOXIDE SYSTEM
EMERGENCY GENERATOR
EMERGENCY PHONE
EMERGENCY WASH STATION
ENERGY RECOVERY UNIT
ENVIRONMENTAL BOX
FAN
FIELD
FILTRATION
FIRE ALARM
FIRE EXTINGUISHER
FIRE HYDRANT PRIVATE
FIRE SUPPRESSION SYSTEM
FIREESCAPE
FIREPLACE
FUME HOOD
FURNACE
GAS SYSTEM, MEDICAL, LAB, ETC.
[NAME]
HEAT EXCHANGER
HEAT RECOVERY UNIT
HEAT RECOVERY WHEEL
HEATER
HEPA UNIT
HOT WATER HEATER
HUMIDIFIER
[NAME]
ICEMAKER
IRRIGATION
KEY CONTROL BOX
LIGHTING
LOUVERS
MANHOLE
MASONRY SYSTEMS
METER
MONITORING SYSTEM
MOTORS
OIL SEPARATOR
OIL STRAINER
PH NEUTRALIZATION SYSTEM
PRESSURE VESSEL
PUMP
REFRIGERATION
REVERSE OSMOSIS DISTILLED WATER
ROOF
SCREEN
SOLAR SYSTEM
SOOT BLOWER
STEAM GENERATOR
STEAM TRAP
TANK
TERMINAL UNITS
TRANSFORMER
TREE
VALVE
VARIABLE FREQUENCY DRIVE
VEHICLE
WASHER
WATER SAMPLE COOLER
WATER SOFTNER
WATER SOURCE HEAT PUMP
WATER TREATMENT
(blank)
Spreadsheet: 328787d1404081885-need-cells-with-a-value-other-then-what-is-displayed-cut-list-1-
Sheet: Cabinet Drawers

Opening and Material Specs |  |  |  |  |  |  | Cut List
Drawer Depth | Opening Width | Opening Height | SideThickness | Bottom Thickness | [NAME] |  | [NAME] | Drawer Height Back | Drawer Front and Back | Sides | [NAME] | [NAME] |  |  | [NAME] -42 mm | Height - | [NAME]
21 | 12 | 5 | 0.5 | 0.25 |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.625 | 0.875
Spreadsheet: ce60f970-60df-4dc0-b1e2-15782109f785
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Merch | 80688770716 | Meredith Andrews | Lemon  You'Re Not Alone Ladies Medium | 2008-03-21 | T-Shirt | Na | 15 | N | To Be Retired
Spreadsheet: 81735d1281907662-formulas-previously-working-now-resulting-in-0-trimmean-average-formulas-used-excel-help-forum-rev1
Sheet: Friday Prep

Friday |  |  | Need | Have | Make | Initial
Dough | Pans (44 = 1 Batch)
 | Mids (68 = 1 Batch)
 | Thins (72 = 1 Batch)
 | Personals
Mids | Meatlovers
 | Hawaiian
 | Supreme
 | Pepperoni
Pans | Meatlovers
 | Hawaiian
 | Supreme
 | Pepperoni
Thins | Pepperoni
TO BE COMPLETED AFTER DOUGH AND PRE-MAKES WITH MAKE-BENCH FULL
Cheese | Containers (Coolroom) |  | 3
 | X.Large Bains ([NAME]) |  | 4
Pineapple | [NAME] ([NAME]) |  | 4
Capsicum | Buckets (Coolroom) |  | 1
Onion | Buckets (Coolroom) |  | 1
Mushrooms | Cartons (Coolroom) |  | 1.5
Olives | Small Bains ([NAME] fridge) |  | 1
Sauces | [NAME] ([NAME] fridge) |  | 2
 | Tomato Sauce Buckets (Cool Room) |  | 3
 | [NAME] ([NAME] fridge) |  | 2
Wings | Packets (Makebench fridge) |  | 6
Ribs | Packets (Makebench fridge) |  | 9
Steak | Small Bains ([NAME] fridge) |  | 1
Pork | Small Bains ([NAME] fridge) |  | 1
Meat Mix | Buckets (Cool Room) |  | 1
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-10-P-0013

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-10-P-0013 |  |  | 1P
W912LP-10-P-0013 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 146346d1332129695-indexing-values-using-vlookup-indexing
Sheet: Sheet1

 | a | 1 |  | a | b
 | a | 2
 | a | 3
 | b | 4
 | b | 5
 | a | 6
 | a | 7
 | a | 8
 | a | 9
 | b | 10
 | b | 11
 | a | 12
 | a | 13
 | a | 14
 | a | 15
 | a | 16
 | a | 17
Spreadsheet: 493178d1481560757-lookup-cell-and-report-back-the-best-matching-result-help-sheet
Sheet: Sheet2

Make | Model | Year | Engine Size | Part Number | OEM | Quantity Required | Item Type | New Column
Honda | C 50 | 1970 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 | 1971 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 | 1972 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 | 1973 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 | 1974 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 | 1975 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 | 1976 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 | 1977 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 | 1978 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 | 1979 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 | 1980 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 C Cub | 1982 | 50 | 123457 | None | 0 | Oil Filter
Honda | C 50 C Cub | 1983 | 50 | 123457 | None | 0 | Oil Filter
Honda | C 50 C Cub | 1984 | 50 | 123457 | None | 0 | Oil Filter
Honda | C 50 E Super Cub | 1984 | 50 | 123458 | None | 0 | Oil Filter
Honda | C 50 E Super Cub | 1985 | 50 | 123458 | None | 0 | Oil Filter
Honda | C 50 L (Single Seat) | 1980 | 50 | 123459 | None | 0 | Oil Filter
Honda | C 50 L (Single Seat) | 1981 | 50 | 123459 | None | 0 | Oil Filter
Honda | C 50 L (Single Seat) | 1982 | 50 | 123459 | None | 0 | Oil Filter
Honda | C 50 L (Single Seat) | 1983 | 50 | 123459 | None | 0 | Oil Filter
Honda | C 50 L (Single Seat) | 1984 | 50 | 123459 | None | 0 | Oil Filter
Honda | C 50 L (Single Seat) | 1985 | 50 | 123459 | None | 0 | Oil Filter
Honda | C 50 LAC | 1982 | 50 | 123459 | None | 0 | Oil Filter
Honda | C 50 LAC | 1983 | 50 | 123460 | None | 0 | Oil Filter
Honda | C 50 LAC | 1984 | 50 | 123460 | None | 0 | Oil Filter
Honda | C 50 LAE | 1984 | 50 | 123460 | None | 0 | Oil Filter
Honda | C 50 LAE | 1985 | 50 | 123460 | None | 0 | Oil Filter
Honda | C 50 LAG | 1986 | 50 | 123460 | None | 0 | Oil Filter
Honda | C 50 LAG | 1987 | 50 | 123460 | None | 0 | Oil Filter
Honda | C 50 LAG | 1988 | 50 | 123460 | None | 0 | Oil Filter
Honda | C 50 LAG | 1989 | 50 | 123460 | None | 0 | Oil Filter
Honda | C 50 N (Single Seat Model) | 1992 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 P (Single Seat Model) | 1993 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 S (Single Seat Model) | 1995 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 V (Single Seat Model) | 1997 | 50 | 123456 | None | 0 | Oil Filter
Honda | C 50 X (Single Seat Model) | 1999 | 50 | None | None | 0 | Oil Filter
Honda | C 50 Y (Single Seat Model) | 2000 | 50 | None | None | 0 | Oil Filter
Honda | C 50 ZZ | 1979 | 50 | None | None | 0 | Oil Filter
Honda | C 50 ZZ | 1980 | 50 | None | None | 0 | Oil Filter
Honda | C 50 ZZ | 1981 | 50 | None | None | 0 | Oil Filter
Honda | C 50 ZZ | 1982 | 50 | None | None | 0 | Oil Filter
Honda | C 50 ZZ | 1983 | 50 | None | None | 0 | Oil Filter
Honda | C 50-1 (Single Seat Model) | 2001 | 50 | None | None | 0 | Oil Filter
Honda | C 50-2 (Single Seat Model) | 2002 | 50 | None | None | 0 | Oil Filter
Spreadsheet: 182234d1348377917-pivot-dates-not-sorting-september-2012-week-3
Sheet: Jul - 2012

Actual Production vs Production Capacity
Months | Jul
Row Labels | Sum of Quantity | Sum of Capacity | Sum of Percentage
10-Jul | 29507 | 20000 | 1.47535
11-Jul | 30385 | 20000 | 1.51925
12-Jul | 38572 | 20000 | 1.9286
15-Jul | 28296 | 20000 | 1.4148
16-Jul | 51648 | 20000 | 2.5824
17-Jul | 13728 | 20000 | 0.6864
18-Jul | 28296 | 20000 | 1.4148
19-Jul | 41018 | 20000 | 2.0509
1-Jul | 25226 | 20000 | 1.2613
22-Jul | 34270 | 20000 | 1.7135
23-Jul | 13420 | 20000 | 0.671
24-Jul | 16011 | 20000 | 0.80055
25-Jul | 16594 | 20000 | 0.8297
26-Jul | 46464 | 20000 | 2.3232
29-Jul | 28022 | 20000 | 1.4011
2-Jul | 28058 | 20000 | 1.4029
30-Jul | 36242 | 20000 | 1.8121
31-Jul | 32952 | 20000 | 1.6476
3-Jul | 26406 | 20000 | 1.3203
4-Jul | 20596 | 20000 | 1.0298
5-Jul | 33896 | 20000 | 1.6948
8-Jul | 27452 | 20000 | 1.3726
9-Jul | 29632 | 20000 | 1.4816
Grand Total | 676691 | 460000 | 1.471067391304348
Average per day:
Spreadsheet: 27328d1220492101-phonetic-help-test
Sheet: Sheet1

A | Alpha
B | Beta
C | [NAME]
D | Delta
E | [NAME]
F | [NAME]
G | George
H | Hawaii
I | Indian
J | [NAME]
K | Kangaroo
L | Legend
M | Mayday
N | November
O | Octopus
P | Pencil
Q | Quack
R | Rufus
S | Sylvester
T | Tango
U | [NAME]
V | Volcano
W | Winter
X | Xylaphone
Y | Yankee
Z | Zebra
0 | [NAME]
1 | Uno
2 | Zwei
3 | Tres
4 | Vier
5 | Cinco
6 | Sixer
7 | Sieben
8 | Ocho
9 | Niner
Spreadsheet: 2082b0d9-6ea7-4ae2-8790-fbf5c387ebba
Sheet: Sheet1

Supplementary Table 5 :  [NAME] domain enriched in genes differentially expressed upon germline ablation. Prtoeasome / Ubiquitin system related domains are highlighted in orange. [NAME] involved in RNA metabolism are highlighted in blue. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Pfam domain | Description | Total | Observed | Expected | Enrichmnet | p-value
Helicase_C | Helicase | 68 | 42 | 28.3 | 1.5 | 4.42e-07
Motile_Sperm | sperm motility | 49 | 31 | 20.4 | 1.5 | 9.19e-06
DEAD | RNA metabolism, Ribosome biogenesis | 56 | 31 | 23.3 | 1.3 | 0.000237
Proteasome | Protein homesotasis | 14 | 11 | 5.8 | 1.9 | 0.000693
RRM_1 | RNA binding | 138 | 49 | 57.4 | 0.9 | 0.000829
GTP_EFTU_D2 | Translational elongation | 11 | 9 | 4.6 | 2 | 0.00138
Cpn60_TCP1 | [NAME] family | 12 | 9 | 5 | 1.8 | 0.00138
Exonuc_X-T | RNAse activity | 6 | 6 | 2.5 | 2.4 | 0.00138
AAA | ATPases Associated with diverse cellular Activities. | 31 | 18 | 12.9 | 1.4 | 0.00143
ubiquitin | Protein recycling via proteasome | 17 | 11 | 7.1 | 1.6 | 0.00181
G-patch | RNA binding | 12 | 9 | 5 | 1.8 | 0.00387
PCI | Proteasome, Int-6, Nip-1 and TRIP-15 domain | 12 | 9 | 5 | 1.8 | 0.00387
SAC3_GANP | Multifnctional protein complexes | 5 | 5 | 2.1 | 2.4 | 0.00413
Mov34 | Ubiquitin protease | 10 | 7 | 4.2 | 1.7 | 0.00832
Spreadsheet: 764364d1642700273-find-start-date-and-end-date-startdateandenddate
Sheet: Sheet1

Emp Id | Emp Name | Month
1001 | A | 2021-01-01 00:00:00
1001 | A | 2021-02-01 00:00:00
1001 | A | 2021-03-01 00:00:00 |  |  | Output
1001 | A | 2021-04-01 00:00:00 |  |  | Emp Id | Start Month | End Month
1001 | A | 2021-05-01 00:00:00 |  |  | 1001 | 2021-01-01 00:00:00 | 2021-08-01 00:00:00
1001 | A | 2021-06-01 00:00:00 |  |  | 1002 | 2021-01-01 00:00:00 | 2021-11-01 00:00:00
1001 | A | 2021-07-01 00:00:00 |  |  | 1003 | 2021-09-01 00:00:00 | 2021-09-01 00:00:00
1001 | A | 2021-08-01 00:00:00 |  |  | 1004 | 2021-10-01 00:00:00 | 2021-12-01 00:00:00
1002 | B | 2021-01-01 00:00:00
1002 | B | 2021-03-01 00:00:00
1002 | B | 2021-08-01 00:00:00
1002 | B | 2021-09-01 00:00:00
1002 | B | 2021-10-01 00:00:00
1002 | B | 2021-11-01 00:00:00
1003 | C | 2021-09-01 00:00:00
1004 | D | 2021-10-01 00:00:00
1004 | D | 2021-10-01 00:00:00
1004 | D | 2021-11-01 00:00:00
1004 | D | 2021-12-01 00:00:00
Spreadsheet: 167481d1342010969-vlookup-from-a-list-excel-forum-example1
Sheet: Sheet1

Shopping List
 | Apples | Pears | Pineapples | Total Fruits
[NAME] | 2 | 1 | 0
Jenniffer | 1 | 1 | 0
[NAME] | 0 | 1 | 1
Spreadsheet: 213344d1360450000-help-need-to-fill-depreciation-table-based-on-dropdown-date-selection-excelexample2
Sheet: Sheet2

January 2013
February 2013
March 2013
April 2013
May 2013
June 2013
July 2013
August 2013
September 2013
October 2013
November 2013
December 2013
January 2014
February 2014
March 2014
April 2014
May 2014
June 2014
July 2014
August 2014
September 2014
October 2014
November 2014
December 2014
January 2015
February 2015
March 2015
April 2015
May 2015
June 2015
July 2015
August 2015
September 2015
October 2015
November 2015
December 2015
January 2016
February 2016
March 2016
April 2016
May 2016
June 2016
July 2016
August 2016
September 2016
October 2016
November 2016
December 2016