{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Disclaimer","Methodology Builder","Validation Lists"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":78,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"LGC Methodology Builder\n"]
[null,"Important notice:"]
[null,"Embedded Macros\nThis Large-scale Renewable Energy Target (LRET) LGC Methodology Builder (the Builder) uses embedded macros script to verify and validate answers and manipulate the spreadsheets within this workbook only. You must select to enable macros when prompted to be able to use the Builder. If your system is unable to run macros, then you will be unable to use the Builder."]
[]
[null,"Terms of Use\nThe Builder is intended to assist nominated persons to formulate a large-scale generation certificate (LGC) methodology – that is, to assist in working out the amount of electricity generated by an accredited power station for the purposes of creating LGCs in accordance with s 18 of the Renewable Energy (Electricity) Act 2000, and s 14 of the Renewable Energy (Electricity) Regulations 2001 (the Regulations). The outputs produced by the Builder should be considered as a guide only. The Builder is based on the Regulations and other relevant laws current at the date of publication. These laws and their interpretation are subject to change which may affect the suitability of the LGC methodology produced by the Builder. The Regulations are updated periodically and users should note that some requirements may change in future years.\nThe Clean Energy Regulator and the Commonwealth of Australia are not responsible for the data input into the Builder by users, and will in no event be liable for any direct, incidental or consequential loss or damage resulting from incorrect LGC methodology formulations calculated as a result of inaccurate, incomplete or out-of-date information input into the Builder. While reasonable efforts have been made to ensure that the Builder operates as intended, the Clean Energy Regulator and the Commonwealth of Australia do not warrant that LGC methodologies generated by the Builder will be suitable, correct or up-to-date.\n\nThe Clean Energy Regulator and the Commonwealth of Australia will not be liable for any loss or damage from any cause (including negligence) whether arising directly, incidentally or as consequential loss, out of or in connection with, any use of the Builder, reliance on its output, or reliance on other information or advice on this website, for any purpose. \nThe information on this website is no substitute for independent advice. Users should seek independent advice before taking any action or decision on the basis of the methodologies formulated by the Builder. The Clean Energy Regulator and the Commonwealth of Australia do not guarantee uninterrupted access to the Builder or that the associated website and files obtained from or through this website are free from viruses.\nBy using the Builder, you agree to be bound by the above Terms of Use. The Clean Energy Regulator and the Commonwealth of Australia may, at their discretion, vary or modify these Terms of Use without notice, and any subsequent use by you of the Builder will constitute an acceptance of the Terms of Use as modified. \n\n© Commonwealth of Australia 2019"]

{"sheet":"Methodology Builder","index":1,"n_rows":156,"n_cols":8,"rows_kept":156,"cut":false,"hidden":true,"merged":[[79,0,79,6],[117,0,117,6],[119,0,119,6],[132,0,132,6],[94,0,94,6],[97,0,97,6],[0,0,0,6],[23,0,23,6],[5,0,5,6],[1,0,1,6],[45,0,45,6],[35,0,35,6],[9,0,9,6],[8,0,8,6],[36,0,36,6],[47,0,47,6],[67,0,67,6],[6,0,6,6],[7,0,7,6],[18,0,18,6],[64,0,64,6],[46,0,46,6],[55,0,55,6],[11,0,11,6],[12,0,12,6],[66,0,66,6],[17,0,17,6],[52,0,52,5],[54,0,54,6],[33,0,33,6],[48,0,48,6],[135,0,135,6],[27,0,27,5],[31,0,31,6],[19,0,19,6],[43,0,43,6],[89,0,89,6],[90,0,90,6],[121,0,121,6],[134,0,134,6],[34,0,34,6],[85,0,85,5],[112,0,112,6],[81,0,81,6],[68,0,68,6],[69,0,69,6],[70,0,70,6],[155,1,155,6],[95,0,95,6],[101,0,101,6],[111,0,111,6],[120,0,120,6],[133,0,133,6],[96,0,96,6],[109,0,109,6],[127,0,127,6],[130,0,130,6],[116,0,116,5],[122,0,122,6],[123,0,123,6],[137,0,137,4],[142,0,142,6],[154,0,154,6],[149,1,149,6],[150,1,150,6],[151,1,151,6],[152,1,152,6],[153,1,153,6]]}
[]
["LGC Methodology Builder v1.0"]
[]
[null,null,"Use the reset button to clear all fields"]
[]
["This tool is designed to assist nominated persons to establish an appropriate large-scale generation certificate (LGC) calculation methodology for power stations participating in the Renewable Energy Target, in accordance with the requirements under the Renewable Energy (Electricity) Act 2000 and the general formula set out in Regulation 14 of the Renewable Energy (Electricity) Regulations 2001. It is not a substitute for the guidance provided on the Clean Energy Regulator website."]
["Please note, this tool does not support all methods for calculating LGC eligibility under the general formula. Its use will be limited to non-complex power stations using a single eligible fuel source. Additional measurements and calculations may be required to establish your LGC methodology that may not be provided for in the use of this tool.   "]
["Nominated persons should refer to the guidance provided on the Clean Energy Regulator website with respect to power station eligibility criteria, requirements for metering electricity generation and calculating LGC eligibility using the general formula. The requirements for metering installations and application of relevant National Electricity Market (NEM) standards are dependent on factors such as the point of measurement, volumes of electricity flow, power station configuration and operating characteristics. Please note, greater flexibility in meeting metering requirements is permitted for temporary changes to LGC methodologies where meter data is unavailable (e.g. due to meter outages or disruptions to data access), and may not be suitable for power station accreditation. "]
["For more information about the LGC general formula, please refer to the information provided on the LGC general formula page."]
["For more information about metering requirements, please refer to the metering guidance page."]
[]
["Power station details"]
["The requirements for metering electricity generation and the application of relevant NEM standards are dependent on factors such as the point of measurement, volumes of electricity flow, power station configuration and operating characteristics. Some details of the power station are required to ensure the LGC methodology is appropriate for the power station."]
[]
["Fuel source"]
["Capacity",null,"MW"]
[]
[]
["Permanent or temporary methodology"]
["The Clean Energy Regulator may accept temporary variations to the method of calculating electricity generation where data from meters is not available due to unforeseen issues such as meter failures or disruptions to data access. In these cases, metering systems not meeting these standards (such as data from inverters in solar photovoltaic systems) may be used to support LGC eligibility. The variation to the LGC methodology may take into account any reductions in accuracy in measurement from these devices. The use of such devices will only be permitted on a temporary basi​s and efforts to rectify metering must be undertaken within a reasonable timeframe."]
[]
["Is this a permanent or temporary methodology?"]
[]
["Please note that only one LGC methododology can be used over a single reporting period (i.e. in a single month), unless otherwise agreed to by the Clean Energy Regulator"]
[]
["What is the power station name for which you require a temporary change in LGC methodology?"]
["Why is this change to your LGC methodology required? (type your response in the cell below):"]
[]
[]
["When will this temporary methodology change apply from?"]
["When will this temporary methodology change apply to?"]
["Please send this spreadsheet with your application to temporarily vary the LGC methodology"]
[]
[]
["TLEG"]
["TLEG is the total amount of electricity, in MWh, generated by the power station in the year, as measured at all generator terminals of the power station in the year."]
["For more information regarding metering of TLEG, please refer to the metering guidance page"]
[]
["How many metering devices (meters or inverters) will be used to measure TLEG?"]
["If serial number is not yet available, enter \"TBA\""]
[null,null,"Manufacturer","Model","Serial Number","Accuracy (%)","Confidence factor","TLEG"]
[null,null,null,null,null,null,{"$f":"IF(TLEGMeterTable[[#This Row],[Accuracy (%)]]>=98.5,0,98.5 - TLEGMeterTable[[#This Row],[Accuracy (%)]])","v":98.5},{"$f":"CONCATENATE(\"Reading from \",TLEGMeterTable[[#This Row],[Manufacturer]],\" \",TLEGMeterTable[[#This Row],[Model]],\" (Serial number: \",IF(TLEGMeterTable[[#This Row],[Serial Number]]=\"\",\"TBA\",TLEGMeterTable[[#This Row],[Serial Number]]),\")\")","v":"Reading from   (Serial number: TBA)"}]
[null,null,null,null,"Final confidence factor:",{"$f":"MIN(100,IFERROR(ROUND(100-0.5*(98.5-AVERAGE(TLEGMeterTable[Accuracy (%)])),2),100))","v":100},"%"]
["Please note: The confidence factor is used to provide a correction in the LGC calculation methodology for meters that do not meet CER standards for accuracy and is only applicable to temporary LGC methodologies. The final metered electricity generated or consumed will be multplied by the confidence factor to account for this lack in accuracy. Meters that do not conform to CER standards may not be acceptable for measuring TLEG unless otherwise agreed by the Clean Energy Regulator. "]
[]
[{"$f":"IF(ISBLANK(E46),\"\",IF(E46>=98.5,100,98.5-E46))","v":""}]
["AUX"]
["AUX is the auxiliary loss, in MWh, for the power station for the reporting period. This is any electricity consumed by all components considered to be part of the power station. It includes any electricity imported to the power station even when the power station is not generating electricity. See regulation 16 in relation to working out the auxiliary loss if some of the electricity generated by the power station in the year was generated using energy sources that are not eligible energy sources."]
["For more information regarding metering of AUX, please refer to the metering guidance page"]
[]
["Are there auxiliary losses associated with the power station?"]
["Please provide an explanation for why there are no auxiliary losses (type your response in the cell below):"]
[]
[]
["Metered AUX"]
["If this LGC methodology is to be used permanently, and your power station is over 1MW, auxiliary losses must be metered, unless otherwise agreed by the Clean Energy Regulator."]
[]
["Are meters/metering devices being used to measure auxiliary loss?"]
["Will auxiliary loss be measured using the same metering device(s) that is measuring TLEG?"]
["How many metering devices (meters or inverters) will be used to measure AUX?"]
["If serial number is not known then leave this field blank"]
[null,null,"Manufacturer","Model","Serial Number","Accuracy (%)","Confidence factor","AUX"]
[null,null,null,null,null,null,{"$f":"98.5 - AUXMeterTable[[#This Row],[Accuracy (%)]]","v":98.5},{"$f":"CONCATENATE(\"Reading from \",AUXMeterTable[[#This Row],[Manufacturer]],\" \",AUXMeterTable[[#This Row],[Model]],\" (Serial number: \",IF(AUXMeterTable[[#This Row],[Serial Number]]=\"\",\"TBA\",AUXMeterTable[[#This Row],[Serial Number]]),\")\")","v":"Reading from   (Serial number: TBA)"}]
[null,null,null,null,"Final confidence factor:",{"$f":"MIN(100,IFERROR(ROUND(100-0.5*(98.5-AVERAGE(AUXMeterTable[Accuracy (%)])),2),100))","v":100},"%"]
["Please note: The confidence factor is used to provide a correction in the LGC calculation methodology for meters that do not meet CER standards for accuracy. The final metered electricity generated or consumed will be multplied by the confidence factor to account for this lack in accuracy. Meters that do not conform may not be acceptable for measuring AUX unless otherwise agreed by the Clean Energy Regulator. "]
[]
["Calculated AUX"]
["Please note, the metering of auxiliary loss by a meter meeting the requirements set out by the Clean Energy Regulator is considered the most accurate method of measuring the amount of auxiliary loss."]
["If this LGC methodology is to be used permanently, and your power station is over 1MW, auxiliary lossess must be metered."]
["It is at the Clean Energy Regulator's discretion as to whether a calculated AUX is deemed suitable."]
["You must provide supporting documentation for your components' calculated stand-by power (eg. data sheets for components)"]
[]
["Is a calculation being used to estimate auxilliary loss?"]
["How many different types of power station components are consuming electricity?"]
["(Each make and model device counts as one type)"]
["Include make and model in component name (e.g. Invertra Premier 3.0-1)"]
[null,null,null,"Component Name","Power (W)","Quantity","Monthly consumption"]
[null,null,null,null,null,null,{"$f":"E78*16*F78*365/12/1000000","v":0}]
[null,null,null,null,"Calculated auxiliary:",{"$f":"SUM(CalculatedAUXTable[Monthly consumption])","v":0},"MWh/month"]
["Please provide a data sheet for each component listed in the table above with your application"]
[]
["Other AUX"]
[]
["Are there other auxiliary losses associated with the operation of the power station not accounted for?"]
["How will other auxiliaries be measured/estimated? (type your response in the cell below):"]
[]
[]
["What will be the estimated 'other' auxiliary consumption?",null,null,null,null,null,"MWh/month"]
[]
["AUX for Ineligible Sources"]
["For electricity generated by the power station from an energy source that is not an eligible energy source, auxiliary losses from the system that are attributable to that source are to be deducted from the total auxiliary loss proportionately to the proportion of electricity generated from that source."]
[]
["Is there auxiliary losses associated with electricity generated from ineligible fuel sources?"]
[]
[]
["FSL"]
["FSL is the amount (if any) of electricity, in MWh, generated by the power station in the year using energy sources that are not eligible energy sources, worked out under regulation 15."]
["For more information regarding metering of FSL, please refer to the metering guidance page"]
[]
["Is there fossil fuel-based generation associated with the power station?"]
[]
["Metered FSL"]
[]
["Are meters being used to measure generation from fossil fuels?"]
["How many metering devices will be used to measure FSL?"]
["If serial number is not known then leave this field blank"]
[null,null,"Manufacturer","Model","Serial Number","Accuracy (%)","Confidence factor","FSL"]
[null,null,null,null,null,null,{"$f":"IF(FSLMeterTable[[#This Row],[Accuracy (%)]]>=98.5,0,98.5 - FSLMeterTable[[#This Row],[Accuracy (%)]])","v":98.5},{"$f":"CONCATENATE(\"Reading from \",FSLMeterTable[[#This Row],[Manufacturer]],\" \",FSLMeterTable[[#This Row],[Model]],\" (Serial number: \",IF(FSLMeterTable[[#This Row],[Serial Number]]=\"\",\"TBA\",FSLMeterTable[[#This Row],[Serial Number]]),\")\")","v":"Reading from   (Serial number: TBA)"}]
[null,null,null,null,"Final confidence factor:",{"$f":"MIN(100,IFERROR(ROUND(100-0.5*(98.5-AVERAGE(FSLMeterTable[Accuracy (%)])),2),100))","v":100},"%"]
["Please note: The confidence factor is used to provide a correction in the LGC calculation methodology for meters that do not meet CER standards for accuracy. The final metered electricity generated or consumed will be multplied by the confidence factor to account for this lack in accuracy. Meters that do not conform may not be acceptable for measuring FSL unless otherwise agreed by the Clean Energy Regulator. "]
[]
["Other/calculated FSL"]
["If meters are not being used to measure FSL, you must answer yes to the following question."]
[]
["Are there other methods being used to measure generation from fossil fuels?"]
["Provide details of how other FSL will be measured (type your response in the cell below):"]
[]
["Some common methods to measure FSL without a meter include:\n- Amount of diesel (or other fossil fuel) used to generate electricity x energy density of the fuel x FSL generator efficiency\n- Hours of FSL generation x power rating of the FSL generator"]
[]
[]
["MLF"]
["MLF is the marginal loss factor, to allow for the amount of electricity losses in transmission networks, as determined by:\n (a) if the power station is part of the national electricity market—Australian Energy Market Operator (AEMO); or\n (b) in any other case—an authority of the State or Territory where the power station is."]
["If all the electricity generated by the accredited power station is used ​in the power station, or in the local distribution network, or in both the power station and the local distribution network, the MLF is taken to be one (1)."]
["The Clean Energy Regulator applies generator MLFs calculated and published by AEMO, and equivalents calculated by other market operators, to electricity dispatched by market generators operated by accredited power stations."]
[]
["Has a MLF been provided by AEMO or other State/Territory authority for the power station?"]
["What is the Transmission Node Identity (TNI) of the power station?"]
["The TNI is a unique number given to the transmission node to which the power station is connected. A list of TNIs can be found on the AEMO website."]
[]
["What is the Dispatchable Unit ID (DUID) of the power station?"]
["The DUID is the unique identifer for the power station submitted to AEMO."]
[]
[]
["DLEG"]
["DLEG is the amount of electricity, in MWh, transmitted or distributed by the power station in the year, measured:\n (a) if the power station is part of the national electricity market—at the point determined under the National Electricity Rules; or\n (b) in any other case—at the point determined by an authority of the State or Territory where the power station is."]
["An 'editable DLEG' may be required if the power station has an MLF other than 1 applied, and is consuming electricity generated by the power station onsite for a purpose other than the operation of the power station (e.g. manufacturing, processing).  "]
[]
["Is electricity generated by the power station being used on site for a purpose other than the operation of the power station (e.g. manufacturing, processing)?"]
["If yes, DLEG must be metered seperately to TLEG. Please provide meter details for the export meter below:"]
[null,null,"Manufacturer","Model","Serial Number","Accuracy (%)","Confidence factor","DLEG"]
[null,null,null,null,null,null,{"$f":"IF(DLEGMeterTable[[#This Row],[Accuracy (%)]]>=98.5,0,98.5 - DLEGMeterTable[[#This Row],[Accuracy (%)]])","v":98.5},{"$f":"CONCATENATE(\"Reading from \",DLEGMeterTable[[#This Row],[Manufacturer]],\" \",DLEGMeterTable[[#This Row],[Model]],\" (Serial number: \",IF(DLEGMeterTable[[#This Row],[Serial Number]]=\"\",\"TBA\",DLEGMeterTable[[#This Row],[Serial Number]]),\")\")","v":"Reading from   (Serial number: TBA)"}]
[null,null,null,null,"Final confidence factor:",{"$f":"MIN(100,IFERROR(ROUND(100-0.5*(98.5-AVERAGE(DLEGMeterTable[Accuracy (%)])),2),100))","v":100},"%"]
["Please note: The confidence factor is used to provide a correction in the LGC calculation methodology for meters that do not meet CER standards for accuracy. The final metered electricity generated or consumed will be multplied by the confidence factor to account for this lack in accuracy. Meters they do not conform may not be acceptable for measuring DLEG unless otherwise agreed by the Clean Energy Regulator. "]
[]
[]
[null,null,"Click the 'Formulate' button to build your LGC methodology below"]
[]
[null,null,"Click the 'Clear Formulation' button to clear the LGC methodology below"]
[]
["TLEG:"]
["AUX:"]
["FSL:"]
["DLEG:"]
["MLF:"]
["Copy and paste the content in the below cell directly into the application.\nIf applying for a temporary change to LGC methodology, please also attach this spreadsheet with any supporting documentation (e.g. data sheets) to your application email."]
["LGC Methodology"]

{"sheet":"Validation Lists","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Yes","Permanent","Solar"]
["No","Temporary","Wind"]
[null,null,"Hydro"]
[null,null,"Bioenergy"]
[null,null,"Co-firing"]
[null,null,"Fuel cell"]
[null,null,"Geothermal"]
[null,null,"Ocean, wave or tidal"]
[null,null,"Waste coal mine gas"]