Design Microgrid (Solar) 20180603-0800 Defaults

Run this computational tool to place the following components of a solar microgrid:

  • Service Drop Poles
  • Service Drop Lines
  • Distribution Poles
  • Distribution Lines
  • Battery
  • Solar Panels
  • Street Lamps
  • Power Meters
  • Wifi Routers
  • Wide Poles

The algorithm makes the following optimizations:

  • Place distribution poles near roads when it is more cost effective to do so.
  • Avoid pole obstacles when placing service drop poles and distribution poles.
  • Avoid line obstacles when placing service drop line and distribution line.

Relevant Industries

  • Energy > Microgrid > Renewable

Target Applications

  • Microgrid Site Design

Pricing Notes

  • Pricing is on a per-site basis.
  • Please contact billing@crosscompute.com for special rates.

Usage Notes

  • Choose a sufficient amount of memory and time to run the algorithm.
  • You can influence the algorithm to put more distribution poles near roads by increasing Off Road Cost Multiplier.
  • The algorithm is also available as an API for easier automation and integration into your workflow.

Acknowledgments

Thank you to the following groups that made this work possible:

Geography

The algorithm expects an attribute called demand or demand_in_kwh_per_day for each customer (see Electricity).

Upload
iddemand_in_kwh_per_day
customer81.0
customer72.0
customer3
customer5
customer63.0
customer90.0
customer09.0
customer4
customer27.0
customer18.0
Upload
id
road3
road2
road1
road0
Upload
id
pole-obstacle0
Upload
id
line-obstacle1
line-obstacle0
line-obstacle2

Electricity

Layout

Cost

Anyone with the link

Pay Tool Creator: Roy Hyunjin Han1250000
Set Visibility: Hidden0
Total0
Description
Distribution Line
Service Drop Line
Obstacles where Poles Cannot be Placed
Obstacles where Lines Cannot be Placed
Battery
  • Obstacles where Poles cannot be Placed (Orange)
  • Obstacles where Lines cannot be Placed (Red)
  • Battery (Brown)
  • Distribution Lines (Dark Green)
  • Service Drop Lines (Yellow Green)
10
33
49.304975299203285
3756.1537748738306
DescriptionNameValue
Cost of one service drop poledrop_pole_cost_per_pole100
Number of service drop polesdrop_pole_count10
Number of service drop poles that are off roaddrop_pole_off_road_count9
Percent of service drop poles that are off roaddrop_pole_off_road_percent90
Penalty for service drop poles located off roaddrop_pole_off_road_penalty900
Cost of service drop poles excluding off road penaltydrop_pole_raw_cost1000
Cost of service drop poles including off road penaltydrop_pole_cost1900
Cost per meter of service drop linedrop_line_cost_per_meter10
Length of service drop line in metersdrop_line_length50
Cost of service drop linesdrop_line_cost494
Cost of one distribution poledistribution_pole_cost_per_pole200
Number of distribution polesdistribution_pole_count33
Number of distribution poles that are off roaddistribution_pole_off_road_count32
Percent of distribution poles that are off roaddistribution_pole_off_road_percent97
Penalty for distribution poles located off roaddistribution_pole_off_road_penalty6400
Cost of distribution poles excluding off road penaltydistribution_pole_raw_cost6600
Cost of distribution poles including off road penaltydistribution_pole_cost13000
Cost per meter of distribution linedistribution_line_cost_per_meter20
Length of distribution line in metersdistribution_line_length3757
Cost of distribution linesdistribution_line_cost75124
Cost of service drop poles and lines excluding off road penaltydrop_pole_and_line_raw_cost1494
Cost of service drop poles and lines including off road penaltydrop_pole_and_line_cost2394
Cost of distribution poles and lines excluding off road penaltydistribution_pole_and_line_raw_cost81724
Cost of distribution poles and lines including off road penaltydistribution_pole_and_line_cost88124
Cost of poles and lines excluding off road penaltypole_and_line_raw_cost83217
Cost of poles and lines including off road penaltypole_and_line_cost90517

Service Drop Lines

idpole_idcustomer_idlength_in_meters
8.08.08.05.270206431615062
7.07.07.09.992110953454628
3.03.03.08.225227564135855
5.05.05.01.0770898374242477
6.06.06.04.63677460885565
9.09.09.04.081667542614648
0.00.00.09.988200532456204
4.04.04.02.0112326089565147
2.02.02.02.0112326089565147
1.01.01.02.011232610733957
10
10
1.0770898374242477
9.992110953454626
49.304975299203285
idpole_idcustomer_idlength_in_meterswkt
0009.988200532456204LINESTRING (120.117119031685 -10.17296179718251, 120.1172007307673 -10.17300166693765)
1112.011232610733957LINESTRING (120.1230193371014 -10.17036454227049, 120.1230150048235 -10.17034688832581)
2222.0112326089565147LINESTRING (120.1183672432775 -10.17124636046203, 120.1183629112747 -10.17122870652354)
3338.225227564135855LINESTRING (120.1122753535964 -10.17651632582005, 120.1122157465268 -10.17656141927779)
4442.0112326089565147LINESTRING (120.117712132921 -10.1714596065392, 120.1177078009571 -10.17144195260134)
5551.0770898374242477LINESTRING (120.1140322024868 -10.17448137265035, 120.1140369072708 -10.17447283208723)
6664.63677460885565LINESTRING (120.1147066454011 -10.17107166287888, 120.114674554972 -10.17109893247244)
7779.992110953454628LINESTRING (120.1072706570837 -10.16489826366139, 120.1072467637078 -10.16481116186146)
8885.270206431615062LINESTRING (120.1036136159847 -10.17212775943849, 120.1036269497066 -10.17217349692373)
9994.081667542614648LINESTRING (120.1167324657906 -10.17308982965915, 120.1167367649391 -10.17312645382021)

Distribution Lines

idcustomer_countdemand_in_kwh_per_daybattery_distance_in_metershas_panelhas_lamphas_meterhas_routerhas_endhas_cornertype_id
81.01.0827.6209330316483FalseTrueTrueTrueFalseTruewide
10927.0877772950453FalseFalseFalseFalseFalseFalsetall
11727.8469551536293TrueFalseFalseFalseFalseFalsewide
121026.5546215601148FalseFalseFalseFalseFalseFalsetall
131126.0214658235118FalseFalseFalseTrueFalseFalsetall
14628.0729772767983TrueFalseFalseFalseFalseFalsewide
151225.4883100885813FalseFalseFalseFalseFalseFalsetall
161324.9551543519651FalseFalseFalseFalseFalseFalsetall
17528.2989993999673TrueFalseFalseTrueFalseFalsewide
181424.421998617035FalseFalseFalseTrueFalseFalsetall
20428.52502152194825TrueFalseFalseFalseFalseFalsewide
191523.888842880432FalseFalseFalseFalseFalseFalsetall
211623.3556871455014FalseFalseFalseFalseFalseFalsetall
22328.75104364392917TrueFalseFalseFalseFalseFalsewide
71.02.01722.8225314088986FalseTrueTrueFalseTrueFalsewide
23228.97706576709817TrueFalseFalseTrueFalseFalsewide
24144.12615308461864TrueFalseFalseFalseFalseFalsewide
2560.243202516951904TrueFalseFalseFalseFalseFalsewide
2623.63974805077301TrueFalseFalseFalseFalseFalsewide
27107.52269861818598TrueFalseFalseTrueFalseFalsewide
28191.40564918585272TrueFalseFalseFalseFalseFalsewide
31.01.0275.2885997535194TrueFalseTrueFalseFalseTruewide
29374.09942893323995TrueFalseFalseTrueFalseFalsewide
30472.9102581144055TrueFalseFalseFalseFalseFalsewide
51.01.0571.7210872941259TrueFalseTrueFalseFalseFalsewide
61.03.01048.0695114898972FalseTrueTrueFalseTrueFalsewide
31655.1744463587194TrueFalseFalseTrueFalseFalsewide
32970.7090849734835FalseFalseFalseFalseFalseFalsetall
33893.3486584570702FalseFalseFalseFalseFalseFalsetall
34815.9882319388521FalseFalseFalseTrueFalseFalsetall
35738.6278054224385TrueFalseFalseFalseFalseTruewide
36822.0811644861577FalseFalseFalseFalseFalseFalsetall
91.00.0905.5345235507511FalseFalseTrueTrueFalseFalsetall
01.09.0950.2365564734406FalseTrueTrueFalseFalseTruewide
371039.5183219493897FalseFalseFalseFalseFalseFalsetall
41.01.01128.8000874253385FalseFalseTrueFalseFalseTruewide
21.07.01204.4266816042289FalseFalseTrueTrueFalseFalsetall
381291.0038242365588FalseFalseFalseFalseFalseFalsetall
391377.5809668685508FalseFalseFalseFalseFalseFalsetall
401464.1581095008805FalseFalseFalseTrueFalseFalsetall
411550.7352521332102FalseFalseFalseFalseFalseFalsetall
421637.3123947652027FalseFalseFalseFalseFalseFalsetall
11.08.01723.889537397532FalseFalseTrueFalseTrueFalsewide
33
idcustomer_countdemand_in_kwh_per_daybattery_distance_in_metershas_panelhas_lamphas_meterhas_routerhas_endhas_cornertype_idgeometry_layerwkt
01.09.0950.2365564734406FalseTrueTrueFalseFalseTruewideservice drop polePOINT (120.117119031685 -10.17296179718251)
11.08.01723.889537397532FalseFalseTrueFalseTrueFalsewideservice drop polePOINT (120.1230193371014 -10.17036454227049)
21.07.01204.4266816042289FalseFalseTrueTrueFalseFalsetallservice drop polePOINT (120.1183672432775 -10.17124636046203)
31.01.0275.2885997535194TrueFalseTrueFalseFalseTruewideservice drop polePOINT (120.1122753535964 -10.17651632582005)
41.01.01128.8000874253385FalseFalseTrueFalseFalseTruewideservice drop polePOINT (120.117712132921 -10.1714596065392)
51.01.0571.7210872941259TrueFalseTrueFalseFalseFalsewideservice drop polePOINT (120.1140322024868 -10.17448137265035)
61.03.01048.0695114898972FalseTrueTrueFalseTrueFalsewideservice drop polePOINT (120.1147066454011 -10.17107166287888)
71.02.01722.8225314088986FalseTrueTrueFalseTrueFalsewideservice drop polePOINT (120.1072706570837 -10.16489826366139)
81.01.0827.6209330316483FalseTrueTrueTrueFalseTruewideservice drop polePOINT (120.1036136159847 -10.17212775943849)
91.00.0905.5345235507511FalseFalseTrueTrueFalseFalsetallservice drop polePOINT (120.1167324657906 -10.17308982965915)
10927.0877772950453FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1040199637219 -10.17132448653565)
11727.8469551536293TrueFalseFalseFalseFalseFalsewidedistribution polePOINT (120.1043090480699 -10.17270881560322)
121026.5546215601148FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1044263089992 -10.17052121253107)
131126.0214658235118FalseFalseFalseTrueFalseFalsetalldistribution polePOINT (120.1048326518169 -10.16971793742492)
14628.0729772767983TrueFalseFalseFalseFalseFalsewidedistribution polePOINT (120.1050044827962 -10.17328987096502)
151225.4883100885813FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1052389921752 -10.16891466121727)
161324.9551543519651FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1056453300743 -10.1681113839083)
17528.2989993999673TrueFalseFalseTrueFalseFalsewidedistribution polePOINT (120.1056999201638 -10.17387092552366)
181424.421998617035FalseFalseFalseTrueFalseFalsetalldistribution polePOINT (120.1060516655145 -10.16730810549808)
191523.888842880432FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.106457998496 -10.16650482598678)
20428.52502152194825TrueFalseFalseFalseFalseFalsewidedistribution polePOINT (120.1063953601728 -10.17445197927889)
211623.3556871455014FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.106864329019 -10.1657015453745)
22328.75104364392917TrueFalseFalseFalseFalseFalsewidedistribution polePOINT (120.1070908028233 -10.17503303223042)
23228.97706576709817TrueFalseFalseTrueFalseFalsewidedistribution polePOINT (120.1077862481154 -10.17561408437799)
24144.12615308461864TrueFalseFalseFalseFalseFalsewidedistribution polePOINT (120.1085006539276 -10.17590830677726)
2560.243202516951904TrueFalseFalseFalseFalseFalsewidedistribution polePOINT (120.1092555917622 -10.17602991376283)
2623.63974805077301TrueFalseFalseFalseFalseFalsewidedistribution polePOINT (120.1100105306464 -10.17615151915996)
27107.52269861818598TrueFalseFalseTrueFalseFalsewidedistribution polePOINT (120.1107654705803 -10.17627312296857)
28191.40564918585272TrueFalseFalseFalseFalseFalsewidedistribution polePOINT (120.1115204115637 -10.17639472518863)
29374.09942893323995TrueFalseFalseTrueFalseFalsewidedistribution polePOINT (120.1128609724801 -10.17583800985332)
30472.9102581144055TrueFalseFalseFalseFalseFalsewidedistribution polePOINT (120.1134465887768 -10.17515969213)
31655.1744463587194TrueFalseFalseTrueFalseFalsewidedistribution polePOINT (120.114707270083 -10.1741334896094)
32970.7090849734835FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1148755676698 -10.17175014822295)
33893.3486584570702FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1150444902757 -10.1724286336518)
34815.9882319388521FalseFalseFalseTrueFalseFalsetalldistribution polePOINT (120.1152134132187 -10.17310711916544)
35738.6278054224385TrueFalseFalseFalseFalseTruewidedistribution polePOINT (120.1153823364991 -10.17378560476381)
36822.0811644861577FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.116057401735 -10.17343771811368)
371039.5183219493897FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1174155832064 -10.17221070220133)
381291.0038242365588FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1191425927855 -10.1710993958545)
391377.5809668685508FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1199179420787 -10.17095242921045)
401464.1581095008805FalseFalseFalseTrueFalseFalsetalldistribution polePOINT (120.120693291157 -10.17080546052994)
411550.7352521332102FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1214686400204 -10.17065848981304)
421637.3123947652027FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1222439886685 -10.17051151705988)
idpole1_idpole2_idlength_in_meters
9.08.011.099.77397787801905
8.010.08.099.46684426339694
10.011.014.099.77397787683098
7.012.010.099.46684426506954
6.013.012.099.46684426339694
11.014.017.099.77397787683098
5.015.013.099.46684426506954
4.016.015.099.46684426338409
12.017.020.099.77397787801905
3.018.016.099.46684426506954
13.020.022.099.77397787801905
2.019.018.099.46684426339694
1.021.019.099.46684426506954
14.022.023.099.77397787683098
0.07.021.099.46684426339694
15.023.024.084.85091268247952
16.024.025.083.88295056766673
17.025.026.083.88295056766673
18.026.027.083.88295056741299
19.027.028.083.88295056766673
20.028.03.083.88295056766673
21.03.029.098.81082917972051
22.029.030.098.81082918116549
23.030.05.098.81082917972051
24.05.031.083.45335906459341
25.031.035.083.45335906371916
30.032.06.077.36042651641357
29.033.032.077.36042651641357
28.034.033.077.36042651821798
26.035.034.077.36042651641357
27.036.035.083.45335906371916
41.09.036.083.45335906459341
40.00.09.044.702032922689455
39.037.00.089.28176547594894
38.04.037.089.28176547594894
37.02.04.075.62659417889068
36.038.02.086.57714263232971
35.039.038.086.57714263199198
34.040.039.086.57714263232971
33.041.040.086.57714263232971
32.042.041.086.57714263199198
31.01.042.086.57714263232971
44.70203292268945
99.77397787801905
3756.1537748738306
idpole1_idpole2_idlength_in_meterswkt
072199.46684426339694LINESTRING (120.1072706570837 -10.16489826366139, 120.106864329019 -10.1657015453745)
1211999.46684426506954LINESTRING (120.106864329019 -10.1657015453745, 120.106457998496 -10.16650482598678)
2191899.46684426339694LINESTRING (120.106457998496 -10.16650482598678, 120.1060516655145 -10.16730810549808)
3181699.46684426506954LINESTRING (120.1060516655145 -10.16730810549808, 120.1056453300743 -10.1681113839083)
4161599.46684426338409LINESTRING (120.1056453300743 -10.1681113839083, 120.1052389921752 -10.16891466121727)
5151399.46684426506954LINESTRING (120.1052389921752 -10.16891466121727, 120.1048326518169 -10.16971793742492)
6131299.46684426339694LINESTRING (120.1048326518169 -10.16971793742492, 120.1044263089992 -10.17052121253107)
7121099.46684426506954LINESTRING (120.1044263089992 -10.17052121253107, 120.1040199637219 -10.17132448653565)
810899.46684426339694LINESTRING (120.1040199637219 -10.17132448653565, 120.1036136159847 -10.17212775943849)
981199.77397787801905LINESTRING (120.1036136159847 -10.17212775943849, 120.1043090480699 -10.17270881560322)
10111499.77397787683098LINESTRING (120.1043090480699 -10.17270881560322, 120.1050044827962 -10.17328987096502)
11141799.77397787683098LINESTRING (120.1050044827962 -10.17328987096502, 120.1056999201638 -10.17387092552366)
12172099.77397787801905LINESTRING (120.1056999201638 -10.17387092552366, 120.1063953601728 -10.17445197927889)
13202299.77397787801905LINESTRING (120.1063953601728 -10.17445197927889, 120.1070908028233 -10.17503303223042)
14222399.77397787683098LINESTRING (120.1070908028233 -10.17503303223042, 120.1077862481154 -10.17561408437799)
15232484.85091268247952LINESTRING (120.1077862481154 -10.17561408437799, 120.1085006539276 -10.17590830677726)
16242583.88295056766673LINESTRING (120.1085006539276 -10.17590830677726, 120.1092555917622 -10.17602991376283)
17252683.88295056766673LINESTRING (120.1092555917622 -10.17602991376283, 120.1100105306464 -10.17615151915996)
18262783.88295056741299LINESTRING (120.1100105306464 -10.17615151915996, 120.1107654705803 -10.17627312296857)
19272883.88295056766673LINESTRING (120.1107654705803 -10.17627312296857, 120.1115204115637 -10.17639472518863)
2028383.88295056766673LINESTRING (120.1115204115637 -10.17639472518863, 120.1122753535964 -10.17651632582005)
2132998.81082917972051LINESTRING (120.1122753535964 -10.17651632582005, 120.1128609724801 -10.17583800985332)
22293098.81082918116549LINESTRING (120.1128609724801 -10.17583800985332, 120.1134465887768 -10.17515969213)
2330598.81082917972051LINESTRING (120.1134465887768 -10.17515969213, 120.1140322024868 -10.17448137265035)
2453183.45335906459341LINESTRING (120.1140322024868 -10.17448137265035, 120.114707270083 -10.1741334896094)
25313583.45335906371916LINESTRING (120.114707270083 -10.1741334896094, 120.1153823364991 -10.17378560476381)
26353477.36042651641357LINESTRING (120.1153823364991 -10.17378560476381, 120.1152134132187 -10.17310711916544)
27363583.45335906371916LINESTRING (120.116057401735 -10.17343771811368, 120.1153823364991 -10.17378560476381)
28343377.36042651821798LINESTRING (120.1152134132187 -10.17310711916544, 120.1150444902757 -10.1724286336518)
29333277.36042651641357LINESTRING (120.1150444902757 -10.1724286336518, 120.1148755676698 -10.17175014822295)
3032677.36042651641357LINESTRING (120.1148755676698 -10.17175014822295, 120.1147066454011 -10.17107166287888)
3114286.57714263232971LINESTRING (120.1230193371014 -10.17036454227049, 120.1222439886685 -10.17051151705988)
32424186.57714263199198LINESTRING (120.1222439886685 -10.17051151705988, 120.1214686400204 -10.17065848981304)
33414086.57714263232971LINESTRING (120.1214686400204 -10.17065848981304, 120.120693291157 -10.17080546052994)
34403986.57714263232971LINESTRING (120.120693291157 -10.17080546052994, 120.1199179420787 -10.17095242921045)
35393886.57714263199198LINESTRING (120.1199179420787 -10.17095242921045, 120.1191425927855 -10.1710993958545)
3638286.57714263232971LINESTRING (120.1191425927855 -10.1710993958545, 120.1183672432775 -10.17124636046203)
372475.62659417889068LINESTRING (120.1183672432775 -10.17124636046203, 120.117712132921 -10.1714596065392)
3843789.28176547594894LINESTRING (120.117712132921 -10.1714596065392, 120.1174155832064 -10.17221070220133)
3937089.28176547594894LINESTRING (120.1174155832064 -10.17221070220133, 120.117119031685 -10.17296179718251)
400944.702032922689455LINESTRING (120.117119031685 -10.17296179718251, 120.1167324657906 -10.17308982965915)
4193683.45335906459341LINESTRING (120.1167324657906 -10.17308982965915, 120.116057401735 -10.17343771811368)
6366.158145413532
1
3

Equipment

33.0
idcustomer_countdemand_in_kwh_per_daybattery_distance_in_metershas_panelhas_lamphas_meterhas_routerhas_endhas_cornertype_id
11727.8469551536293TrueFalseFalseFalseFalseFalsewide
14628.0729772767983TrueFalseFalseFalseFalseFalsewide
17528.2989993999673TrueFalseFalseTrueFalseFalsewide
20428.52502152194825TrueFalseFalseFalseFalseFalsewide
22328.75104364392917TrueFalseFalseFalseFalseFalsewide
23228.97706576709817TrueFalseFalseTrueFalseFalsewide
24144.12615308461864TrueFalseFalseFalseFalseFalsewide
2560.243202516951904TrueFalseFalseFalseFalseFalsewide
2623.63974805077301TrueFalseFalseFalseFalseFalsewide
27107.52269861818598TrueFalseFalseTrueFalseFalsewide
28191.40564918585272TrueFalseFalseFalseFalseFalsewide
31.01.0275.2885997535194TrueFalseTrueFalseFalseTruewide
29374.09942893323995TrueFalseFalseTrueFalseFalsewide
30472.9102581144055TrueFalseFalseFalseFalseFalsewide
51.01.0571.7210872941259TrueFalseTrueFalseFalseFalsewide
31655.1744463587194TrueFalseFalseTrueFalseFalsewide
35738.6278054224385TrueFalseFalseFalseFalseTruewide

{ panel_pole_count : Solar Panel Pole Count }

idcustomer_countdemand_in_kwh_per_daybattery_distance_in_metershas_panelhas_lamphas_meterhas_routerhas_endhas_cornertype_id
81.01.0827.6209330316483FalseTrueTrueTrueFalseTruewide
71.02.01722.8225314088986FalseTrueTrueFalseTrueFalsewide
61.03.01048.0695114898972FalseTrueTrueFalseTrueFalsewide
01.09.0950.2365564734406FalseTrueTrueFalseFalseTruewide

{ lamp_pole_count : Street Lamp Pole Count }

idcustomer_countdemand_in_kwh_per_daybattery_distance_in_metershas_panelhas_lamphas_meterhas_routerhas_endhas_cornertype_id
81.01.0827.6209330316483FalseTrueTrueTrueFalseTruewide
71.02.01722.8225314088986FalseTrueTrueFalseTrueFalsewide
31.01.0275.2885997535194TrueFalseTrueFalseFalseTruewide
51.01.0571.7210872941259TrueFalseTrueFalseFalseFalsewide
61.03.01048.0695114898972FalseTrueTrueFalseTrueFalsewide
91.00.0905.5345235507511FalseFalseTrueTrueFalseFalsetall
01.09.0950.2365564734406FalseTrueTrueFalseFalseTruewide
41.01.01128.8000874253385FalseFalseTrueFalseFalseTruewide
21.07.01204.4266816042289FalseFalseTrueTrueFalseFalsetall
11.08.01723.889537397532FalseFalseTrueFalseTrueFalsewide

{ meter_pole_count : Power Meter Pole Count }

idcustomer_countdemand_in_kwh_per_daybattery_distance_in_metershas_panelhas_lamphas_meterhas_routerhas_endhas_cornertype_id
81.01.0827.6209330316483FalseTrueTrueTrueFalseTruewide
131126.0214658235118FalseFalseFalseTrueFalseFalsetall
17528.2989993999673TrueFalseFalseTrueFalseFalsewide
181424.421998617035FalseFalseFalseTrueFalseFalsetall
23228.97706576709817TrueFalseFalseTrueFalseFalsewide
27107.52269861818598TrueFalseFalseTrueFalseFalsewide
29374.09942893323995TrueFalseFalseTrueFalseFalsewide
31655.1744463587194TrueFalseFalseTrueFalseFalsewide
34815.9882319388521FalseFalseFalseTrueFalseFalsetall
91.00.0905.5345235507511FalseFalseTrueTrueFalseFalsetall
21.07.01204.4266816042289FalseFalseTrueTrueFalseFalsetall
401464.1581095008805FalseFalseFalseTrueFalseFalsetall

{ router_pole_count : Wifi Router Pole Count }

idcustomer_countdemand_in_kwh_per_daybattery_distance_in_metershas_panelhas_lamphas_meterhas_routerhas_endhas_cornertype_id
81.01.0827.6209330316483FalseTrueTrueTrueFalseTruewide
11727.8469551536293TrueFalseFalseFalseFalseFalsewide
14628.0729772767983TrueFalseFalseFalseFalseFalsewide
17528.2989993999673TrueFalseFalseTrueFalseFalsewide
20428.52502152194825TrueFalseFalseFalseFalseFalsewide
22328.75104364392917TrueFalseFalseFalseFalseFalsewide
71.02.01722.8225314088986FalseTrueTrueFalseTrueFalsewide
23228.97706576709817TrueFalseFalseTrueFalseFalsewide
24144.12615308461864TrueFalseFalseFalseFalseFalsewide
2560.243202516951904TrueFalseFalseFalseFalseFalsewide
2623.63974805077301TrueFalseFalseFalseFalseFalsewide
27107.52269861818598TrueFalseFalseTrueFalseFalsewide
28191.40564918585272TrueFalseFalseFalseFalseFalsewide
31.01.0275.2885997535194TrueFalseTrueFalseFalseTruewide
29374.09942893323995TrueFalseFalseTrueFalseFalsewide
30472.9102581144055TrueFalseFalseFalseFalseFalsewide
51.01.0571.7210872941259TrueFalseTrueFalseFalseFalsewide
61.03.01048.0695114898972FalseTrueTrueFalseTrueFalsewide
31655.1744463587194TrueFalseFalseTrueFalseFalsewide
35738.6278054224385TrueFalseFalseFalseFalseTruewide
01.09.0950.2365564734406FalseTrueTrueFalseFalseTruewide
41.01.01128.8000874253385FalseFalseTrueFalseFalseTruewide
11.08.01723.889537397532FalseFalseTrueFalseTrueFalsewide
23

Algorithm

1.2044665813446045
111.5803656578064
11.096135139465332
0.13470053672790527
0.5889592170715332
6.885966777801514
17
4
10
12
Download
139.61966609954834