*{margin:0;padding:0;box-sizing:border-box}:root{font-family:system-ui,-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,sans-serif;line-height:1.5;font-weight:400;color-scheme:light;color:#213547;background-color:#f5f5f5;font-synthesis:none;text-rendering:optimizeLegibility;-webkit-font-smoothing:antialiased;-moz-osx-font-smoothing:grayscale}body{margin:0;min-height:100vh;background:linear-gradient(135deg,#667eea,#764ba2)}#app{width:100%;min-height:100vh;padding:2rem}.container{max-width:1400px;margin:0 auto}header{text-align:center;margin-bottom:2rem;position:relative}h1{color:#fff;font-size:2.5rem;font-weight:600;text-shadow:2px 2px 4px rgba(0,0,0,.1)}.docs-btn{position:absolute;top:50%;right:0;transform:translateY(-50%);padding:.5rem 1rem;background:#fff3;color:#fff;border:2px solid white;border-radius:8px;font-size:1rem;font-weight:500;cursor:pointer;transition:all .3s}.docs-btn:hover{background:#fff;color:#667eea}.drop-zone{background:#fff;border:3px dashed #ccc;border-radius:12px;padding:4rem 2rem;text-align:center;cursor:pointer;transition:all .3s ease;margin:0 auto;max-width:600px}.drop-zone:hover,.drop-zone.dragover{border-color:#667eea;background:#f8f9ff;transform:scale(1.02)}.drop-zone p{font-size:1.2rem;color:#666;margin-bottom:1rem}.drop-zone input[type=file]{display:none}.main-content{display:grid;grid-template-columns:350px 1fr;gap:2rem;height:calc(100vh - 200px)}.main-content.hidden,.drop-zone.hidden{display:none}.sidebar{background:#fff;border-radius:12px;padding:1.5rem;overflow-y:auto;box-shadow:0 10px 30px #0000001a}.sidebar h2{font-size:1.5rem;margin-bottom:1rem;color:#333;border-bottom:2px solid #667eea;padding-bottom:.5rem}.sidebar h3{color:#444;font-size:1.1rem;margin-top:1.5rem;margin-bottom:1rem}.template-section{background:#f3f4f6;padding:1rem;border-radius:8px;margin-bottom:1.5rem}.template-section label{display:block;font-weight:600;color:#374151;margin-bottom:.5rem}.template-select{width:100%;padding:.5rem;border:2px solid #d1d5db;border-radius:6px;font-size:.95rem;background:#fff;cursor:pointer;transition:border-color .2s}.template-select:focus{outline:none;border-color:#667eea}.column-item{background:#f8f9fa;border-radius:8px;padding:1rem;margin-bottom:1rem;border:1px solid #e0e0e0}.column-info h3{font-size:1rem;color:#333;margin-bottom:.5rem;font-weight:600}.sample-data{font-size:.85rem;color:#666;margin-bottom:1rem;font-style:italic;overflow:hidden;text-overflow:ellipsis;white-space:nowrap}.mapping-control{display:flex;gap:.5rem;align-items:center;margin-bottom:.5rem}.mapping-control label{font-size:.9rem;color:#555;min-width:50px}.mapping-control select{flex:1;padding:.4rem;border:1px solid #ddd;border-radius:4px;font-size:.9rem;background:#fff}.formula-input{margin-top:.5rem}.formula-input.hidden{display:none}.formula-label-container{display:flex;align-items:center;gap:.5rem;margin-bottom:.25rem}.formula-input label{display:block;font-size:.85rem;color:#555}.formula-help-icon{display:inline-flex;align-items:center;justify-content:center;width:18px;height:18px;background:#667eea;color:#fff;border-radius:50%;font-size:.75rem;font-weight:700;cursor:pointer;transition:all .2s}.formula-help-icon:hover{background:#5568d3;transform:scale(1.1)}.formula-input input{width:100%;padding:.4rem;border:1px solid #ddd;border-radius:4px;font-size:.85rem;font-family:Courier New,monospace}.add-transform-btn{margin-left:auto;padding:.25rem .5rem;background:#10b981;color:#fff;border:none;border-radius:4px;font-size:.8rem;cursor:pointer;transition:background-color .2s}.add-transform-btn:hover{background:#059669}.transforms-list{margin-top:.5rem}.no-transforms{padding:.5rem;background:#f9f9f9;border:1px dashed #ddd;border-radius:4px;color:#999;font-size:.85rem;text-align:center}.transform-item{display:flex;align-items:flex-start;gap:.5rem;margin-bottom:.5rem;padding:.5rem;background:#f9f9f9;border:1px solid #e0e0e0;border-radius:4px;flex-wrap:wrap}.transform-number{color:#666;font-weight:600;font-size:.9rem;min-width:20px}.transform-select{flex:1;padding:.4rem;border:1px solid #ddd;border-radius:4px;font-size:.85rem;background:#fff;cursor:pointer}.transform-input{flex:1;padding:.4rem;border:1px solid #ddd;border-radius:4px;font-size:.85rem;font-family:Courier New,monospace;margin-top:.25rem;background:#fff}.transform-input:focus{outline:none;border-color:#667eea;box-shadow:0 0 0 2px #667eea1a}.remove-transform-btn{width:24px;height:24px;padding:0;background:#ef4444;color:#fff;border:none;border-radius:4px;font-size:1.2rem;line-height:1;cursor:pointer;transition:background-color .2s;display:flex;align-items:center;justify-content:center}.remove-transform-btn:hover{background:#dc2626}.mapping-controls{display:flex;gap:.5rem;margin-bottom:1.5rem}.auto-map-btn,.ai-suggest-btn{flex:1;padding:.5rem;border:none;border-radius:6px;font-size:.9rem;font-weight:500;cursor:pointer;transition:all .2s}.auto-map-btn{background:linear-gradient(135deg,#60a5fa,#3b82f6);color:#fff}.auto-map-btn:hover{transform:translateY(-1px);box-shadow:0 3px 10px #3b82f64d}.ai-suggest-btn{background:linear-gradient(135deg,#c084fc,#a855f7);color:#fff}.ai-suggest-btn:hover{transform:translateY(-1px);box-shadow:0 3px 10px #a855f74d}.macros-section{margin-top:2rem;padding-top:1.5rem;border-top:2px solid #e5e7eb}.macros-section h3{color:#333;font-size:1.1rem;margin-bottom:1rem}.macro-controls{display:flex;gap:.5rem;margin-bottom:1rem}.macro-select{flex:1;padding:.5rem;border:1px solid #d1d5db;border-radius:6px;font-size:.9rem;background:#fff}.add-macro-btn{padding:.5rem 1rem;background:linear-gradient(135deg,#10b981,#059669);color:#fff;border:none;border-radius:6px;font-size:.9rem;font-weight:500;cursor:pointer;transition:all .2s}.add-macro-btn:hover{transform:translateY(-1px);box-shadow:0 3px 10px #10b9814d}.macros-list{max-height:200px;overflow-y:auto;border:1px solid #e5e7eb;border-radius:8px;background:#f9fafb}.macro-item{padding:.75rem;border-bottom:1px solid #e5e7eb;background:#fff;margin-bottom:.5rem;border-radius:6px;position:relative}.macro-item:last-child{border-bottom:none;margin-bottom:0}.macro-header{display:flex;justify-content:space-between;align-items:center;margin-bottom:.5rem}.macro-type{font-weight:600;color:#4b5563;font-size:.9rem}.macro-remove{background:#ef4444;color:#fff;border:none;border-radius:4px;padding:.25rem .5rem;font-size:.8rem;cursor:pointer;transition:background .2s}.macro-remove:hover{background:#dc2626}.macro-config{display:flex;flex-direction:column;gap:.5rem}.macro-field{display:flex;align-items:center;gap:.5rem}.macro-field label{font-size:.85rem;color:#6b7280;min-width:80px}.macro-field select,.macro-field input{flex:1;padding:.25rem .5rem;border:1px solid #d1d5db;border-radius:4px;font-size:.85rem}.button-group{display:flex;flex-direction:column;gap:1rem;margin-top:2rem}.import-btn,.export-btn,.apply-btn{width:100%;padding:.75rem;color:#fff;border:none;border-radius:8px;font-size:1rem;font-weight:500;cursor:pointer;transition:transform .2s,box-shadow .2s}.import-btn{background:linear-gradient(135deg,#4facfe,#00f2fe)}.export-btn{background:linear-gradient(135deg,#f093fb,#f5576c)}.apply-btn{background:linear-gradient(135deg,#4ade80,#22c55e)}.import-btn:hover,.export-btn:hover,.apply-btn:hover{transform:translateY(-2px);box-shadow:0 5px 15px #667eea66}.excel-display{background:#fff;border-radius:12px;padding:1.5rem;overflow:auto;box-shadow:0 10px 30px #0000001a}#excelContent table{width:100%;border-collapse:collapse;font-size:.9rem}#excelContent th{background:linear-gradient(135deg,#667eea,#764ba2);color:#fff;padding:.75rem;text-align:left;position:sticky;top:0;z-index:10;font-weight:500}#excelContent td{padding:.5rem .75rem;border-bottom:1px solid #e0e0e0;color:#333}#excelContent tr:hover td{background:#f8f9ff}#excelContent tr:nth-child(2n) td{background:#fafafa}button:focus,select:focus,input:focus{outline:2px solid #667eea;outline-offset:2px}.tabs-container{height:100%;display:flex;flex-direction:column}.tabs{display:flex;gap:.5rem;border-bottom:2px solid #e5e7eb;padding-bottom:0;margin-bottom:1rem}.tab-button{padding:.75rem 1.5rem;background:transparent;border:none;border-bottom:3px solid transparent;color:#666;font-size:1rem;font-weight:500;cursor:pointer;transition:all .2s;border-radius:8px 8px 0 0}.tab-button:hover:not(:disabled){background:#f3f4f6}.tab-button.active{color:#667eea;border-bottom-color:#667eea;background:#f0f4ff}.tab-button:disabled{opacity:.5;cursor:not-allowed}.tab-panel{display:none;flex:1;overflow:auto}.tab-panel.active{display:block}.output-header{display:flex;justify-content:space-between;align-items:center;margin-bottom:1.5rem;padding-bottom:1rem;border-bottom:1px solid #e5e7eb}.output-header h3{color:#333;margin:0;font-size:1.25rem}.download-buttons{display:flex;gap:1rem}.download-btn{padding:.5rem 1rem;background:linear-gradient(135deg,#3b82f6,#2563eb);color:#fff;border:none;border-radius:6px;font-size:.9rem;font-weight:500;cursor:pointer;transition:transform .2s,box-shadow .2s}.download-btn:hover{transform:translateY(-1px);box-shadow:0 3px 10px #3b82f64d}#transformedTable{max-height:400px;overflow:auto;border:1px solid #e5e7eb;border-radius:8px}#transformedTable table{width:100%;border-collapse:collapse}#transformedTable th{background:#f3f4f6;padding:.75rem;text-align:left;font-weight:600;border-bottom:2px solid #e5e7eb;position:sticky;top:0}#transformedTable td{padding:.75rem;border-bottom:1px solid #e5e7eb}#transformedTable tr:hover{background:#f9fafb}.modal{position:fixed;top:0;left:0;width:100%;height:100%;background:#00000080;display:flex;justify-content:center;align-items:center;z-index:1000}.modal.hidden{display:none}.modal-content{background:#fff;width:90%;max-width:1200px;height:90vh;border-radius:12px;display:flex;flex-direction:column;box-shadow:0 20px 60px #0000004d}.modal-header{display:flex;justify-content:space-between;align-items:center;padding:1.5rem;border-bottom:2px solid #e5e7eb;background:linear-gradient(135deg,#667eea,#764ba2);border-radius:12px 12px 0 0}.modal-header h2{color:#fff;margin:0;font-size:1.5rem}.close-btn{background:none;border:none;color:#fff;font-size:2rem;cursor:pointer;padding:0;width:40px;height:40px;display:flex;align-items:center;justify-content:center;border-radius:50%;transition:background .3s}.close-btn:hover{background:#fff3}.docs-content{flex:1;overflow-y:auto;padding:2rem;line-height:1.6}.docs-content h1{color:#333;font-size:2rem;margin-top:2rem;margin-bottom:1rem;padding-bottom:.5rem;border-bottom:2px solid #667eea}.docs-content h2{color:#444;font-size:1.5rem;margin-top:1.5rem;margin-bottom:.75rem}.docs-content h3{color:#555;font-size:1.25rem;margin-top:1.25rem;margin-bottom:.5rem}.docs-content h4{color:#666;font-size:1.1rem;margin-top:1rem;margin-bottom:.5rem}.docs-content p{margin-bottom:1rem;color:#333}.docs-content ul,.docs-content ol{margin-bottom:1rem;padding-left:2rem}.docs-content li{margin-bottom:.5rem}.docs-content pre{background:#f6f8fa;border:1px solid #e1e4e8;border-radius:6px;padding:1rem;overflow-x:auto;margin-bottom:1rem}.docs-content code{background:#f6f8fa;padding:.2rem .4rem;border-radius:3px;font-family:Courier New,monospace;font-size:.9em}.docs-content pre code{background:none;padding:0}.docs-content table{width:100%;border-collapse:collapse;margin-bottom:1rem}.docs-content th,.docs-content td{border:1px solid #e1e4e8;padding:.5rem;text-align:left}.docs-content th{background:#f6f8fa;font-weight:600}.docs-content blockquote{border-left:4px solid #667eea;padding-left:1rem;margin:1rem 0;color:#555;font-style:italic}.docs-content a{color:#667eea;text-decoration:none}.docs-content a:hover{text-decoration:underline}.docs-content strong{font-weight:600;color:#222}.docs-content em{font-style:italic;color:#444}.formula-help-modal{max-width:900px;height:80vh}.formula-help-content{flex:1;overflow-y:auto;padding:1.5rem;line-height:1.6}.formula-category{margin-bottom:2rem}.formula-category h3{color:#667eea;font-size:1.25rem;margin-bottom:1rem;padding-bottom:.5rem;border-bottom:2px solid #e5e7eb}.formula-examples{display:grid;gap:1rem}.formula-example{background:#f9fafb;border:1px solid #e5e7eb;border-radius:8px;padding:1rem}.formula-example h4{color:#374151;font-size:1rem;margin-bottom:.5rem}.formula-code{background:#1f2937;color:#10b981;padding:.5rem .75rem;border-radius:4px;font-family:Courier New,monospace;font-size:.9rem;margin:.5rem 0;overflow-x:auto}.formula-description{color:#6b7280;font-size:.9rem;margin-top:.5rem}.formula-result{color:#059669;font-weight:500;margin-top:.5rem;font-size:.9rem}.formula-tip{background:#fef3c7;border-left:4px solid #f59e0b;padding:.75rem;margin:1rem 0;border-radius:4px}.formula-tip strong{color:#d97706}