EDIG@S Excel Report Generator

Job ID: 40181846

Budget: $250 – $750 USD

Looking for an experienced freelancer to build a formula-based Excel (.xlsx) tool that generates EDIG@S EDIFACT NOMINT messages for gas nominations.

Requirements
• Generate NOMINT messages (single & multi-point)
• Correct EDIG@S segments: UNH, BGM, DTM, NAD, SEQ, LOC, QTY, RFF (opt), UNT
• Automatic and correct UNT segment count
• Excel formulas only for all EDIG@S logic (no VBA for message generation)
• Optional VBA only to export the generated text to a .edi file
• Clean input/output separation, ops-friendly

Nice to have
• Read-only viewing of CONTRL / APERAK
• Simple ALLOC generation (daily only)

Deliverables
• Excel file + brief instructions
• Sample NOMINT output

MUST HAVE SKILLS
• Hands-on EDIFACT / EDIG@S experience (gas market)
• Strong Excel design skills
• High attention to syntax and validation rules