Learn one useful thing today.
IEEE C37.102 Generator Synchrocheck Out-of-Phase Shock
Calculate Phasor Difference Voltage Across Open Breaker dV (pu), Subtransient Synchronizing Surge Current (pu), Synchroscope Beat Period (s), and +/-10-deg Window Dwell Time (s).
Read the guide →Power System Relaying & Substation Protection, IEEE C37.110 Transient CT SaturationIEEE C37.110 CT Knee Voltage & X/R Saturation Formula
Calculate Secondary Symmetrical Fault Current (A), Symmetrical Burden Voltage Vs (V), Transient DC-Offset Excitation Demand Vs*(1 + X/R) (V), and % of Knee Voltage Vk.
Read the guide →Architectural Illumination & MEP Electrical Design, IESNA Zonal Cavity Lumen MethodIES Zonal Cavity Lumen Method, RCR & Fixture Count Formula
Calculate IES Room Cavity Ratio RCR, Exact Fractional Luminaire Count, Rounded-Up Integer Luminaire Count, and Maintained Workplane Illuminance (Lux).
Read the guide →Logical decisionsIF in Excel: flag low stock and keep missing counts visible
Compare a stock count with a minimum level. Decide what happens exactly at the threshold, then distinguish a missing count from a real zero.
Read the guide →Logical & ValidationIF NOT This or That: Avoid the Always-True OR(<>X, <>Y) Trap
Apply surcharges or workflow rules whenever a cell equals neither X nor Y using NOT(OR(cell=X, cell=Y)) or AND(cell<>X, cell<>Y).
Read the guide →Logical & ConditionalIF with Wildcards: Pattern Matching via COUNTIF & ISNUMBER(SEARCH)
Perform wildcard pattern tests (* and ?) inside IF statements—where direct =IF(A2="*PRO*", ...) fails—by pairing IF with COUNTIF(A2, pattern) > 0 or ISNUMBER(SEARCH()).
Read the guide →Logical checks and errorsIFNA vs IFERROR: handle missing lookups without hiding broken data
A missing lookup key produces #N/A, whereas a zero pack size or broken reference produces a different error. Use IFNA so genuinely missing codes show a friendly label while real arithmetic mistakes stay visible.
Read the guide →Logical checks and errorsIFS function: assign ordered score bands without nested IFs
Evaluate checklist scores from highest to lowest threshold because IFS stops at the first TRUE condition. Guard blank cells first and finish with a TRUE catch-all.
Read the guide →Healthcare & ClinicalIIEF-5 / SHIM: Adding Five Component Scores
Add five already-scored SHIM items while accounting for zero responses, questionnaire version and the limits of interpreting the total.
Read the guide →FinancialIllustrate a simplified US self-employment tax cash reserve
Practice a below-wage-cap US self-employment tax illustration and a rough equal-period cash reserve, not a filing calculation.
Read the guide →StatisticalIllustrative logistic Elo expected score and one-game rating update
Calculate Arpad Elo's logistic expected match score E_A = 1 / (1 + 10^((R_B - R_A) / 400)) and post-game rating update R'_A = R_A + K * (S_A - E_A) for chess, esports, and LLM arenas.
Read the guide →FinancialIllustrative mortgage payment caps and loan principal with PV
Combine assumed housing and debt-payment caps, subtract housing costs, and model loan principal.
Read the guide →FinancialIllustrative progressive bracket calculation: base amount plus marginal rate
Learn progressive bracket arithmetic using a fictional four-bracket schedule and compare effective and marginal rates.
Read the guide →EngineeringIllustrative tidal distance scales and planetary synodic periods
Compare a simple nonrotating tidal-balance estimate with a fluid Roche approximation, and calculate the beat period of two prograde mean orbital motions.
Read the guide →Maritime Decarbonization & ESG OperationsIMO Shipping CII Rating, AER & EEOI Carbon Formula
Calculate IMO MARPOL Annex VI Attained Annual Efficiency Ratio AER (g CO2 / DWT-nm), Voluntary Operational EEOI (g CO2 / cargo-ton-nm), CII Compliance Ratio, and A-to-E Rating Band.
Read the guide →Spreadsheet Governance & Collaborative AI WorkflowsIn-App 2 MB Attachment vs MCP 200-Cell Read Audit
Choose the right inspection path in Arte Sheets: metered in-app Pro Assistant file excerpts (.xlsx/.csv/.tsv/.txt <= 2 MB, safe non-executing) versus external MCP read_range (<= 200 cells raw values/formulas + revision, 0 Arte AI credits).
Read the guide →AI Assistant & Workbook SafetyIn-App AI Plan Validator, Suggest Style Guard & Undo Audit
Audit the client-side validatePlan and applyPlan safety rules in Arte Sheets: <=100 cell changes, <=2,000-char strings, <=10,000-cell range/SEQUENCE caps, suggest-mode style rejection, and local Undo stack recording.
Read the guide →AI Assistant & Collaboration GovernanceIn-App Voice 3-Min Cap & Owner Share Preview Audit
Audit bounded WebRTC voice sessions (<=180s expiry, 15s heartbeat, barge-in turn guards) and verify why share_document requires verified-owner UI confirmation and cannot run inside execute_steps.
Read the guide →Electrical Power Safety & Switchgear Protection, IEEE 1584 & NFPA 70E Arc FlashIncident Energy Units and Arc-Flash Assessment
Convert energy per area between joules and thermochemical calories, and understand why conversion alone cannot establish an arc-flash boundary or PPE category.
Read the guide →LogicalInclude and exclude text substrings with SEARCH
Flag and filter transactions that match target keywords ("Cloud" OR "SaaS") while disqualifying rows containing exclusion terms ("Refund" OR "Test").
Read the guide →FinancialIncome tax bracket formula: calculate progressive marginal and effective tax
Compute progressive multi-bracket tax in a single SUMPRODUCT formula using differential bracket rates without nested IF ladders.
Read the guide →MathIncrement a Calculation Automatically with ROW or COLUMN Step Ladders
Create arithmetic scenario ladders down rows or across columns from a base and a step. Keep full precision in rates and round only displayed cost results.
Read the guide →Lookup & ReferenceIncrement a Cell Reference Every Nth Row When Copying Down (Non-Volatile INDEX)
Extract every 3rd (or k-th) row from repeating stacked export blocks—such as stacked Vendor / Invoice / Amount triplets—using non-volatile INDEX + ROW math instead of OFFSET or INDIRECT.
Read the guide →TextIncrement a zero-padded ID number inside a text string (INV-0099 -> INV-0100)
Isolate the trailing numeric segment of a structured code, add N, and preserve leading-zero width automatically across 99-to-100 rollovers.
Read the guide →TextIncrement letters (Rev A -> Rev B) and wrap A–Z shifts with CODE & CHAR
Step engineering revision letters forward ("A" -> "B"), wrap "Z" cleanly back to "A" with MOD(..., 26), and apply symmetric ROT13 character shifts.
Read the guide →Lookup & ReferenceINDEX and MATCH with multiple criteria: boolean array lookup without XLOOKUP
Match two or more columns simultaneously with INDEX(return_range, MATCH(1, (col1=x)*(col2=y), 0)) for universal workbook compatibility.
Read the guide →LookupsINDEX and MATCH: look up a column to the left of the search key
VLOOKUP can only search the leftmost column of a range. Combine INDEX and exact MATCH when the identifier you have sits to the right of the value you need to retrieve.
Read the guide →Lookup & ReferenceINDIRECT function: turn text cell and range strings into live references
Evaluate cell or range addresses stored as text with INDIRECT so summary formulas can switch target columns dynamically.
Read the guide →StatisticalIndividuals control chart: moving-range three-sigma limits
Estimate individual-observation control limits using average adjacent moving range, then compare a new reading with the fixed baseline.
Read the guide →Geotechnical Engineering, Landslide Hazard & Hillslope HydrologyInfinite-Slope Model: Illustrative Dry and Seepage Cases
Explore a simplified infinite-slope equation using hypothetical dry and surface-parallel seepage cases, with assumptions and limits made explicit.
Read the guide →FinancialInformation Ratio, Tracking Error, and Treynor Ratio formulas
Evaluate active portfolio managers against a benchmark index using Active Return, Tracking Error (STDEV.S of active diffs), Information Ratio, and Beta-adjusted Treynor Ratio.
Read the guide →Behavioral Finance & Information EconomicsInformational Cascade & Bayesian Herding Formula
Calculate Bikhchandani, Hirshleifer & Welch’s (1992) Bayesian herding posterior after two sequential actions, early cascade probability 1 - 2*q*(1 - q), and false-cascade risk (1 - q)^2.
Read the guide →Plastics Manufacturing, Injection Molding Tooling & Press SizingInjection Molding Clamping Tonnage & Shot Weight Formula
Calculate Total Part+Runner Projected Area (cm²), Required Mold Clamping Force (kN), Press Clamping Rating (Metric Tons-Force at g = 9.81), and Polymer Shot Weight (g).
Read the guide →Data Cleaning & TextInspect Character Code Sequences & Split a String into Characters (CODE & MID)
Audit 4-character SKU prefixes, currency codes, or short tokens by extracting each character with MID and inspecting its numeric code point with CODE.
Read the guide →FinancialInsurance Loss Ratio, Expense Ratio & Combined Ratio formulas
Calculate loss, expense and combined ratios with an explicit earned/written premium convention, then subtract investment income relative to earned premium.
Read the guide →Engineering & ScienceInteger Quantum Hall Resistance (RK / nu) & Landau Level Cyclotron Gap Formula
Calculate quantized Hall plateau resistance R_xy = R_K / nu (where von Klitzing's constant R_K = h / e^2 = 25,812.80745 Ohms) and Landau level cyclotron spacing Delta_E = hbar * e * B / m_eff (in meV).
Read the guide →StatisticalINTERCEPT function: estimate fixed overhead cost where X equals zero
Separate fixed baseline overhead from variable unit cost with INTERCEPT, and pair it with SLOPE for transparent forecasts.
Read the guide →FinancialInterest Coverage Ratio (TIE) and Net Debt / EBITDA covenant formulas
Monitor corporate credit agreements with Times Interest Earned (EBIT / Interest), Net Leverage ((TotalDebt - Cash) / EBITDA), and automated covenant flags.
Read the guide →Financial & AccountingInterest-at-Maturity Note Clean Price & Yield (PRICEMAT & YIELDMAT Formulas)
Calculate the clean secondary-market price (PRICEMAT), dirty invoice price, and annualized yield to maturity (YIELDMAT) for certificates of deposit and notes paying interest in a single lump sum at maturity.
Read the guide →Automotive & Industrial Machine Design, Internal Expanding Drum Brakes & Shoe TorqueInternal Expanding Drum Brake Leading vs Trailing Torque
Calculate Self-Energizing Leading-Shoe Braking Torque (N·m), De-Energizing Trailing-Shoe Braking Torque (N·m), Total Simplex Drum Torque (N·m), and Shoe Wear Asymmetry Ratio.
Read the guide →Gear & Spline Production Machining, Internal Pull-Broaching Pitch, RPT & TonnageInternal Pull-Broaching Engaged Teeth & Tonnage Formula
Calculate Simultaneous Engaged Broach Teeth Ze, Total Instantaneous Uncut Chip Cross-Section (mm²), Peak Hydraulic Pull Force (kN), and Machine Pull Tonnage (metric tf).
Read the guide →Statistical & AggregationInterpolated Percentile Rank: PERCENTRANK.INC vs PERCENTRANK.EXC Formulas
Compute exact inclusive [0, 1] and exclusive (0, 1) percentile ranks with linear interpolation between bracketing observations using COUNTIF, MAXIFS, and MINIFS.
Read the guide →StatisticalInterquartile Range (IQR) formula and 1.5×IQR outlier detection fences
Measure middle-50% spread with QUARTILE.INC(r, 3) - QUARTILE.INC(r, 1) and flag potential outliers outside Tukey's Q1 - 1.5*IQR and Q3 + 1.5*IQR fences.
Read the guide →Statistical AnalysisIntraclass Correlation Shrout-Fleiss ICC(2,1) Agreement vs ICC(3,1) Consistency
Calculate single-measure and k-rater Intraclass Correlation Coefficients ICC(2,1), ICC(3,1), and ICC(2,k) from two-way ANOVA Mean Squares (MS_R, MS_C, MS_E) to isolate systematic rater bias.
Read the guide →FinancialInventory EOQ and Reorder Point formulas: Economic Order Quantity
Balance fixed ordering costs against annual holding costs with SQRT(2 * D * S / H), and set lead-time Reorder Points.
Read the guide →FinancialInventory Turnover, Days Sales of Inventory (DSI), and Cash Conversion Cycle
Measure working-capital velocity with Inventory Turnover (COGS / AvgInventory), DSI (365 / Turnover), and Cash Conversion Cycle (DSI + DSO - DPO).
Read the guide →Date & TimeInvoice Age, Days Past Due & Collection Status Escalation Formula
Calculate open days past due against an as-of reporting date while short-circuiting settled invoices first, then classify each receivable into PAID, CURRENT, PAST_DUE_1_30, PAST_DUE_31_60, or ESCALATE_60_PLUS.
Read the guide →FinancialInvoice calculation formulas: line discounts, SUMIFS subtotal, and tax-exempt flag
Build two-decimal invoice templates with per-line ROUND(Qty * Price * (1 - Disc%), 2), multi-invoice SUMIFS rollups, and Tax-Exempt customer overrides.
Read the guide →Working Capital & Commercial Trade FinanceInvoice Factoring Advance, Reserve & True APR Formula
Calculate Funded Receivable Factoring Cash Advance, Net Reserve Holdback Rebate, True Effective Annualized Cost (APR on Funded Cash), and Naive Face-Value APR Understatement.
Read the guide →Water Treatment Engineering, Ion-Exchange Softening & Boiler MakeupIon-Exchange Water Softener Hardness & Brine Salt Formula
Calculate Ion-Exchange Softener Hardness in Grains per Gallon (gpg), Total Bed Kilograin Capacity (kgr), Service Gallon Run Before Regeneration (gal), and Salt Brining Efficiency (grains/lb NaCl).
Read the guide →