Learn one useful thing today.
DAPT Score Research: An Example of Signed and Weighted Points
Explore the point arithmetic from the DAPT study using fictional inputs, with complete-data and age-boundary checks.
Read the guide →EngineeringDarcy-Weisbach pipe friction head loss (hf) and pressure drop (kPa) formula
Calculate major pipe friction head loss in meters (hf = f*(L/D)*(v^2/2g)) and pressure drop in kilopascals (kPa) across water, HVAC, and process piping.
Read the guide →EngineeringDarcy's Law Groundwater Flow, Hydraulic Gradient & Pore Seepage Velocity
Compute signed Darcy discharge, hydraulic gradient, specific discharge and average pore-water velocity under a one-dimensional saturated-flow model.
Read the guide →Engineering & ScienceDarken's Equations: Alloy Interdiffusion Coefficient & Kirkendall Marker Velocity
Calculate the chemical interdiffusion coefficient D_tilde = (1 - X_A) * D_A + X_A * D_B and Kirkendall inert-marker velocity v_K = (D_A - D_B) * (dX_A / dx) in solid-state diffusion couples and solder joints.
Read the guide →Renewable Wind Energy & Distributed Aerodynamics, Darrieus Lift vs Savonius Drag VAWTDarrieus & Savonius VAWT Solidity, TSR & Torque Formula
Calculate Vertical-Axis Wind Turbine Blade Chord Solidity (N*c/R), Tip-Speed Ratio lambda, Rectangular Swept-Area Shaft Power (kW), and Aerodynamic Rotor Torque (N·m).
Read the guide →Healthcare & Clinical CalculationsDAS28-ESR & DAS28-CRP Rheumatoid Arthritis Activity Calculator
Calculate four-variable DAS28-ESR or DAS28-CRP from 28-joint counts, patient global health and the corresponding laboratory result, with units and interpretation explained.
Read the guide →Math & TrigDashboard SUMIFS with an "All" dropdown option
Switch cleanly between total revenue when a filter cell equals "All" and filtered SUMIFS when a specific category is chosen.
Read the guide →Cloud Infrastructure & Sustainability AnalyticsData Center PUE, DCiE, CUE & WUE Efficiency Formula
Audit ISO/IEC 30134-2 Power Usage Effectiveness PUE = Total_Facility_Energy / IT_Energy, DCiE = 1 / PUE, Carbon Usage Effectiveness CUE, and Water Usage Effectiveness WUE.
Read the guide →Data Validation & AuditingData Validation Formula: Enforce Unique IDs & Approved Master-List Membership
Prevent duplicate badge/PO numbers AND rogue unapproved codes simultaneously using AND(COUNTIF($B$2:$B$6, B2) = 1, COUNTIF($E$2:$E$5, B2) > 0).
Read the guide →Data Validation & HygieneData Validation Restricting Dates to a Specific Year (ISNUMBER, INT & YEAR)
Enforce that entered journal dates are genuine numeric whole dates falling inside an authorized calendar or fiscal year, rejecting text strings, fractional timestamps, and out-of-period dates.
Read the guide →Data Validation & HygieneData Validation: Allow Letters and Numbers Only Without Punctuation or Spaces
Enforce strict ASCII alphanumeric input (A–Z, a–z, 0–9) with zero hyphens, spaces, or punctuation marks using an auditable CODE and MID character-range check.
Read the guide →Data Validation & HygieneData Validation: Reject Forbidden Substrings, Placeholders, or Disposable Domains
Block cell entries containing prohibited tokens such as "TBD", "test@", or disposable email domains case-insensitively using ISERROR(SEARCH(...)) rules.
Read the guide →Data Validation & HygieneData Validation: Require Cells to Contain a Specific Substring (SEARCH vs. FIND)
Enforce mandatory ticket prefixes, domain tags, or currency codes inside text inputs using ISNUMBER(SEARCH(...)) for case-insensitive rules or ISNUMBER(FIND(...)) for exact-case tokens.
Read the guide →Dates and reportingDATE function: build calendar dates from year, month, and day numbers
Construct unambiguous numeric dates from separate year, month, and day columns—and understand why DATE rolls invalid days like February 29, 2026 forward instead of raising an error.
Read the guide →Dates and reportingDATEDIF function: calculate completed years and remaining months
Measure service tenure in completed years ("Y") and leftover months ("YM") without double-counting total months ("M"), and catch reversed start/end dates (#NUM).
Read the guide →Date & TimeDATEVALUE function: convert text dates to serial numbers safely
Turn imported ISO date strings into real spreadsheet serial dates with DATEVALUE, and guard mixed columns where some cells are already numeric dates.
Read the guide →Engineering & Fluid MechanicsDavies Equation Formula: Aqueous Ion Activity Coefficient Up to I = 0.5 mol/L
Extend Debye-Hückel electrolyte thermodynamics up to moderate ionic strength (I <= 0.5 M) without ion-size parameters using Cecil W. Davies’s 1962 equation log10(gamma_i) = -A * z_i² * (SQRT(I)/(1 + SQRT(I)) - 0.3 * I).
Read the guide →Horizontal Drilling & Coiled-Tubing Mechanics, Dawson-Paslay (1984) & Helical LockupDawson-Paslay Sinusoidal & Helical Pipe Buckling Formula
Calculate Lateral Gravity Wall Support (N/m), Dawson-Paslay Sinusoidal Buckling Load Fsin (kN), Chen-Lin-Cheatham Helical Lockup Load Fhel (kN), and Helical Lockup Ratio (%).
Read the guide →Operations, Logistics & EngineeringDaylight Hours (Photoperiod) Formula: Solar Declination & Sunrise-to-Sunset Duration
Calculate astronomical daylight duration N = (24 / PI()) * ACOS(-TAN(phi) * TAN(delta)) for any latitude phi and day-of-year J (1..365) using Cooper’s (1969) / FAO-56 solar declination equation, including 24-hour polar day and 0-hour polar night bounds.
Read the guide →Dates and reportingDAYS function: count elapsed calendar days between two dates
Calculate exact calendar days between an issue date and settlement date, remember that end_date comes first, and interpret negative results for early settlements.
Read the guide →Date & TimeDays Until Next Anniversary or Renewal Ignoring Year (DATE Rollover)
Calculate exact calendar days remaining from a reference date until the next annual birthday, contract renewal, or calibration month/day—rolling cleanly into YEAR(ref) + 1 when this year’s date has passed.
Read the guide →Dates & TimeDays Until Next Annual Birthday or Contract Renewal (Ignoring Original Year)
Calculate exact calendar days from a reference date until the next annual birthday, SaaS renewal, or calibration date—wrapping cleanly across December 31 into next calendar year.
Read the guide →Date & TimeDays until next birthday: rollover-safe annual countdown
Project a birthdate into the current calendar year with EDATE, advance 12 months if it already passed, and subtract AsOfDate.
Read the guide →Date & TimeDAYS360 function: count days under 30/360 US and European bond conventions
Calculate 30-day-month interest accrual periods using DAYS360 and understand how US (NASD) and European month-end rules differ.
Read the guide →Server Power Architecture & Energy Storage SizingDC-Link Hold-Up Capacitor Line-Dropout Sizing Formula
Calculate Server PSU Dropout Energy Demand (Joules), Usable Capacitor Discharge Fraction 1 - (V_min / V_nom)^2, Required Bulk Hold-Up Capacitance C_uF = (2000 * P_out * t_ms) / (eta * (V_nom^2 - V_min^2)), and Nominal Stored Joules.
Read the guide →FinancialDCF valuation formula: NPV of cash flows plus Gordon Growth Terminal Value
Calculate Enterprise Value by combining NPV of explicit forecast Free Cash Flows with discounted perpetuity Terminal Value.
Read the guide →Equity Capital Markets, De-SPAC Mergers & Corporate DilutionDe-SPAC Redemption Dilution & Net Cash Per Share Formula
Calculate Post-Redemption De-SPAC Net Cash Delivered to Target Balance Sheet, Total Public + PIPE + Sponsor Promote Shares Issued, Effective Net Cash Per Share vs $10.00 Nominal Merger Price, and Total Dilution Cost % of Net Cash.
Read the guide →Semiconductor Fabrication, CMOS Front-End & Furnace OxidationDeal-Grove Silicon Thermal Oxidation Thickness & Tau Formula
Calculate Pre-Existing Oxide Time Shift tau (hr), Final SiO2 Gate/Field Oxide Thickness x_o (nm), Net Oxide Grown (nm), and Consumed Silicon Substrate Depth (0.46 * dx nm).
Read the guide →Engineering & ScienceDean Number (De) Curved-Pipe Vortices & Ito Critical Reynolds Formula
Calculate W. R. Dean’s secondary-vortex number De = Re * SQRT(D / (2 * R_c)) in helical coils and pipe bends alongside Hidesato Ito’s curved-pipe laminar-to-turbulent stabilization threshold Re_crit = 2100 * (1 + 12 * SQRT(D / (2 * R_c))).
Read the guide →Macroeconomics & Sovereign Fiscal AnalysisDebt Sustainability (r - g) & Stabilizing Primary Balance
Project public debt-to-GDP d_t = ((1 + r)/(1 + g)) * dt-1 - pb_t and calculate the exact debt-stabilizing primary balance pb* = ((r - g)/(1 + g)) * dt-1.
Read the guide →Sovereign Debt & Public MacroeconomicsDebt-Stabilizing Primary Balance & (r - g) Formula
Project public debt-to-GDP dynamics d_t = ((1 + r)/(1 + g))*dt-1 - pb_t and calculate Olivier Blanchard’s (2019) debt-stabilizing primary balance pb* = ((r - g)/(1 + g))*dt-1.
Read the guide →Engineering & ScienceDebye T³ Law: Low-Temperature Phonon Molar Heat Capacity Formula
Calculate cryogenic lattice molar heat capacity C_V = (12/5) * π^4 * R * (T / Θ_D)^3 (J/(mol·K)) from crystal Debye temperature Θ_D vs. the classical 3R Dulong-Petit ceiling.
Read the guide →Engineering & ScienceDebye-Scherrer XRD Crystallite Size & Peak FWHM Broadening Formula
Calculate mean nanocrystalline domain size D = (K * lambda) / (RADIANS(SQRT(FWHM_obs^2 - FWHM_inst^2)) * COS(RADIANS(2*theta / 2))) in nanometers from powder X-ray diffraction peaks.
Read the guide →Clinical Medicine & PhysiologyDECAF COPD Exacerbation Research: Adding Five Component Points
Practice the published DECAF point arithmetic with fictional inputs and complete-data checks.
Read the guide →EngineeringDecibel (dB) Power Gain, Voltage Gain & Logarithmic Sound Addition
Calculate 10*LOG10(P2/P1) power gain vs 20*LOG10(V2/V1) amplitude gain and add independent decibel sound levels accurately via 10*LOG10(10^(L1/10) + 10^(L2/10)).
Read the guide →Sheet-Metal Deep Drawing, Battery Cans, Beverage Shells & Stamping Forming LimitsDeep-Drawing Cup Blank Diameter, Draw Ratio & Force Formula
Calculate Surface-Area-Conserved Circular Blank Diameter D_b (mm), Actual Draw Ratio beta = D_b / d_p, Siebel Punch Drawing Force (kN), and First-Draw LDR Tear Check.
Read the guide →Sheet-Metal Stamping & Press-Shop Die Cushions, Siebel Blank-Holder Pressure & LDR GateDeep-Drawing LDR & Siebel Blank-Holder Cushion Formula
Calculate First-Draw Ratio Beta (D0 / dp), Siebel Anti-Wrinkling Blank-Holder Pressure pbh (MPa), Required Nitrogen/Pneumatic Die-Cushion Force (kN), and LDR Single-Stage Gate.
Read the guide →Geotechnical Core Logging & Rock Mass Characterization, ASTM D6032 Deere RQD & Priest-HudsonDeere Rock Quality Designation (RQD) & Joint Frequency
Calculate Total Core Recovery TCR (%), ASTM D6032 Measured Deere RQD (%), Priest & Hudson Theoretical RQD* (%) from Scanline Frequency lambda, and Palmstrom Volumetric Joint Count Jv.
Read the guide →Dynamic ArraysDefine a Dynamic Range Sized by a Cell Value (TAKE & OFFSET)
Choose the first N rows of a fixed revenue range with TAKE or OFFSET, enforcing an integer count and complete numeric data before computing totals and averages.
Read the guide →FinancialDegree of Operating (DOL), Financial (DFL), and Combined Leverage (DCL) formulas
Measure how fixed operating costs and debt interest magnify revenue swings into EBIT and EPS volatility via DOL, DFL, and DCL = DOL * DFL.
Read the guide →MathDEGREES function: convert radian outputs from ATAN, ASIN, and ACOS into degrees
Turn radian arc values and inverse-trigonometric results into readable degree angles using DEGREES.
Read the guide →Mixed-Signal IC Design, Delta-Sigma Data Converters & DSP DecimationDelta-Sigma ADC Oversampling Ratio (OSR) & ENOB Gain Formula
Calculate Mixed-Signal ADC Oversampling Ratio OSR = f_s / (2*BW), Plain Nyquist Oversampling Extra Bits (+0.5 bit/octave), First-Order Delta-Sigma Noise-Shaping SNR Improvement (dB), and Total Effective Resolution Bits (+1.5 bits/octave).
Read the guide →Statistical & PsychometricsDeming & Orthogonal Regression Slope Formula (Errors-in-Variables CLSI EP09)
Eliminate regression dilution bias when both X and Y contain measurement noise using W. Edwards Deming’s exact variance-ratio slope b_1 = (s_yy - δ*s_xx + SQRT((s_yy - δ*s_xx)^2 + 4*δ*s_xy^2)) / (2*s_xy).
Read the guide →Computer Architecture & Thermal Chip DesignDennard Scaling Breakdown & Dark Silicon Formula
Calculate Full-Chip Unthrottled Dynamic Power alpha * C_nF * V_DD^2 * f_GHz, Total Unthrottled Die Power, Thermal Design Power (TDP) Active Lit-Silicon Fraction, and Power-Gated Dark Silicon Share.
Read the guide →Data Validation & HygieneDependent Dropdown Conditional List Formula (FILTER & Parent-Child Audit)
Generate a dynamic cascading list of valid child options for a selected parent category using FILTER and UNIQUE, and audit existing rows to catch mismatched parent-child pairs.
Read the guide →FinancialDepreciation methods compared: Straight-Line (SLN), SYD, and Double-Declining
Calculate Year-1..N asset depreciation under Straight-Line, Sum-of-Years'-Digits, and salvage-capped Double-Declining Balance.
Read the guide →Healthcare & Clinical CalculationsDermatology Life Quality Index: Ten-Item Score Arithmetic
Explore the arithmetic of ten fictional DLQI item scores, the official missing-response guidance, and the limitations of using a score alone.
Read the guide →Statistical & PsychometricsDerSimonian-Laird Random-Effects Variance (τ²) & Higgins I² Meta-Analysis
Calculate between-study random-effects heterogeneity variance τ^2 = MAX(0, (Q - (k - 1)) / (Σw - Σw^2 / Σw)) and Higgins I^2 (%) from Cochran’s Q and fixed-effect weights.
Read the guide →Collaboration & Sharing WorkflowsDesign a 20x10 Public View Summary Block vs Named Workbook Invitations
Structure top-left KPI summary blocks for anonymous 20-row by 10-column public view pages, cross-foot totals against detail rows, and separate public links from named role invitations.
Read the guide →Dates & TimeDetect Schedule & Room Double-Booking Conflicts (COUNTIFS Overlap)
Flag overlapping conference-room, vehicle, or shift reservations on the same resource using De Morgan's interval overlap rule COUNTIFS(Resource, A2, Start, "<" & C2, End, ">" & B2) - 1 > 0.
Read the guide →