Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Healthcare & Clinical

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 →
Engineering

Darcy-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 →
Engineering

Darcy'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 & Science

Darken'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 VAWT

Darrieus & 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 Calculations

DAS28-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 & Trig

Dashboard 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 Analytics

Data 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 & Auditing

Data 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 & Hygiene

Data 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 & Hygiene

Data 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 & Hygiene

Data 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 & Hygiene

Data 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 reporting

DATE 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 reporting

DATEDIF 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 & Time

DATEVALUE 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 Mechanics

Davies 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 Lockup

Dawson-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 & Engineering

Daylight 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 reporting

DAYS 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 & Time

Days 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 & Time

Days 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 & Time

Days 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 & Time

DAYS360 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 Sizing

DC-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 →
Financial

DCF 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 Dilution

De-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 Oxidation

Deal-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 & Science

Dean 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 Analysis

Debt 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 Macroeconomics

Debt-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 & Science

Debye 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 & Science

Debye-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 & Physiology

DECAF COPD Exacerbation Research: Adding Five Component Points

Practice the published DECAF point arithmetic with fictional inputs and complete-data checks.

Read the guide →
Engineering

Decibel (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 Limits

Deep-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 Gate

Deep-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-Hudson

Deere 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 Arrays

Define 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 →
Financial

Degree 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 →
Math

DEGREES 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 Decimation

Delta-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 & Psychometrics

Deming & 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 Design

Dennard 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 & Hygiene

Dependent 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 →
Financial

Depreciation 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 Calculations

Dermatology 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 & Psychometrics

DerSimonian-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 Workflows

Design 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 & Time

Detect 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 →