I will create automated excel tools for solar epc costing, billing , project reporting

India

I speak English, Hindi

Solar EPC Consultant

I specialize in Excel-based solutions for Solar EPC projects, including project costing, cash flow monitoring, billing and collection, contractor payments, solar generation reports, PR calculations, D...
About this Gig

Solar EPC Excel Solutions | Automated Trackers & Reports


I create customized, formula-linked Excel workbooks for Solar EPC projects.


SERVICES:

1. Costing & Cash Flow: Budget tracking, Budget vs. Actual, ETC.

2. Billing & Commercial: Client invoicing, BBU-wise billing, collections, contractor payments.

3. Solar Reporting: DGR, PR Calculator, Final PR Test Sheet.

4. Planning & Progress: DPR, L4 Schedule, progress tracking, planned vs. actual dates.

5. Material & Documents: Inventory, supply tracker, MDL, document approvals.

6. O&M: Operational, maintenance, and breakdown reports.


PACKAGES:


BASIC: 1 selected Excel sheet, basic formulas, formatting, 1 revision.


STANDARD: 2 selected sheets, linked formulas, automated calculations, structured reporting, 2 revisions.


PREMIUM: 5 selected sheets, linked calculations, consolidated reporting as agreed, formula testing, 2 revisions.


DELIVERABLES:

Editable Excel (.xlsx), relevant formulas, organized worksheets, and testing of agreed calculations.


I can customize existing workbooks or create new solutions for your requirements.


Please contact me before ordering complex projects to confirm scope, price, and delivery time.

Technology:

Excel

•

Google Analytics

•

Google Sheets

•

VBA

Analysis type:

Quantitative analysis

•

Impact analysis

Expertise:

Business Insights

•

Trends

•

Prediction

•

Forecasting

Programming language:

Python

•

SQL