Ceil / Manipulation Layer

Compute the ceiling (smallest integer greater than or equal to x) of floating-point values. Similar to numpy's ceil() or R's ceiling().

Mathematical form: $⌈ x ⌉ = min {n \in Z : n \geq x}$

Examples:

3.1 → 4.0
3.9 → 4.0
-3.1 → -3.0
-3.9 → -3.0

Common applications:

Shipping container calculations (2.3 containers → 3 containers needed)
Storage space allocation (15.5 GB → 16 GB required)
Staffing requirements (4.2 people → 5 people needed)
Time slot scheduling (2.4 hours → 3 hours to allocate)
Inventory restocking (85.2 units → 86 units to order)
Service capacity planning (142.7 seats → 143 seats needed)
Billing cycles (11.2 months → 12 months to charge)
Risk coverage calculations (98.6% → 99% coverage required)

Table

Transforms

[, ...]

Select

column

Floating-point column to ceiling. Common scenarios:

Payment rounding (45.50 → 46.00 for minimum charges)
Resource provisioning (3.2 units → 4 units)
Coverage requirements (0.95 → 1.00 for full compliance)
Batch size calculations (98.3 → 99 items per batch)
Duration planning (5.1 hours → 6 hours needed)

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.