xl/styles.xml Input: Output: xl/workbook.xml Input: Sheet1!$B$2:$O$90 Output: Sheet1!$B$2:$O$90 xl/_rels/workbook.cml.rels Input: Output: xl/worksheet/sheet1.xml Input: 2477IF(ISBLANK(E3),"<-- Please enter your Name", " ") 723542IF(ISBLANK(E5),"<-- Please enter your AREA", " ") 71078IF(ISBLANK(E7),"<-- Please enter your TDATA Initials", " ") 745843040IF(E9="","<-- Please select the month","")50661516171819202124226725IF(WEEKDAY($E$9)=1,$E$9,"N/A")N/AIF(F13="N/A", IF(WEEKDAY($E$9)=2,$E$9,"N/A"), F13+1)N/AIF(G13="N/A", IF(WEEKDAY($E$9)=3,$E$9,"N/A"), G13+1)N/AIF(H13="N/A", IF(WEEKDAY($E$9)=4,$E$9,"N/A"), H13+1)43040IF(I13="N/A", IF(WEEKDAY($E$9)=5,$E$9,"N/A"), I13+1)43041IF(J13="N/A", IF(WEEKDAY($E$9)=6,$E$9,"N/A"), J13+1)43042IF(K13="N/A", IF(WEEKDAY($E$9)=7,$E$9,"N/A"), K13+1)4304326271567221IF(ISBLANK(D14), "", ".").1790000000IF($F$13="N/A",0,F14)+IF($G$13="N/A",0,G14)+IF($H$13="N/A",0,H14)+IF($I$13="N/A",0,I14)+IF($J$13="N/A",0,J14)+IF($K$13="N/A",0,K14)+L140008075781078.58.57.590IF($F$13="N/A",0,F15)+IF($G$13="N/A",0,G15)+IF($H$13="N/A",0,H15)+IF($I$13="N/A",0,I15)+IF($J$13="N/A",0,J15)+IF($K$13="N/A",0,K15)+L15250082755830000000000847518500000000008475486000000000080757890000.50.51020087755880000000000IF(ISBLANK(D21), "", ".")10000000000000000000051SUM(F14:F22)0SUM(G14:G22)78.598100+SUM(M14:M22)270070661516171819202124226725L13+143044F26+143045430464304743048430494305026271567221IF(ISBLANK(D27), "", ".").1790000000SUM(F27:L27)000807578104.56245.502200827558300000000008475185000000000084754860000000000807578900.518.5410150087755880001010200IF(ISBLANK(D34), "", ".")10000000000000000000052SUM(F27:F35)05711.587.50+SUM(M26:M35)39SUM(N27:N35)0SUM(O27:O35)069661516171819202124226725L26+143051F39+143052430534305443055430564305726271567221IF(ISBLANK(D40), "", ".").1790000000SUM(F40:L40)000807578100000000008275583000000000084751850000000000847548600000000008075789000000000087755880000000000IF(ISBLANK(D47), "", ".")10000000000000000000056SUM(F40:F48)0000000+SUM(M39:M48)0SUM(N40:N48)0SUM(O40:O48)068661516171819202124226725L39+143058F52+143059430604306143062430634306426271567221IF(ISBLANK(D53), "", ".").1790000000SUM(F53:L53)000807578100000000008275583000000000084751850000000000847548600000000008075789000000000087755880000000000IF(ISBLANK(D60), "", ".")10000000000000000000055SUM(F53:F61)0000000+SUM(M52:M61)0SUM(N53:N61)0SUM(O53:O61)053661516171819202124226725IF(DAY($L$52+1)<10,"N/A",$L$52+1)43065IF(DAY($L$52+2)<10,"N/A",$L$52+2)43066IF(DAY($L$52+3)<10,"N/A",$L$52+3)43067IF(DAY($L$52+4)<10,"N/A",$L$52+4)43068IF(DAY($L$52+5)<10,"N/A",$L$52+5)43069IF(DAY($L$52+6)<10,"N/A",$L$52+6)N/AIF(DAY($L$52+7)<10,"N/A",$L$52+7)N/A26271567221IF(ISBLANK(D66), "", ".").1790000000IF($F$65="N/A",0,F66)+IF($G$65="N/A",0,G66)+IF($H$65="N/A",0,H66)+IF($I$65="N/A",0,I66)+IF($J$65="N/A",0,J66)+IF($K$65="N/A",0,K66)+IF($L$65="N/A",0,L66)00080757810000000IF($F$65="N/A",0,F67)+IF($G$65="N/A",0,G67)+IF($H$65="N/A",0,H67)+IF($I$65="N/A",0,I67)+IF($J$65="N/A",0,J67)+IF($K$65="N/A",0,K67)+IF($L$65="N/A",0,L67)0008275583000000000084751850000000000847548600000000008075789000008000087755880000000000IF(ISBLANK(D73), "", ".")10000000000000000000054SUM(F66:F74)0000080+SUM(M65:M74)0IF($F$65="N/A",0,SUM(N66:N74))0IF($F$65="N/A",0,SUM(O66:O74))06366151624226725IF(DAY($L$52+8)<10,"N/A",$L$52+8)N/AIF(DAY($L$52+9)<10,"N/A",$L$52+9)N/A26271567221IF(ISBLANK(D79), "", ".").1790000000IF($F$78="N/A",0,F79)+IF($G$78="N/A",0,G79)000807578105000000008275583060000000084751850100000000847548600000000008075789000000000087755880000000000IF(ISBLANK(D86), "", ".")10000000000000000000064SUM(F79:F87)0SUM(G79:G87)12+SUM(M78:M87)0IF($F$78="N/A",0,SUM(N79:N87))0IF($F$78="N/A",0,SUM(O79:O87))057M23+M36+M49+M62+IF($F65="N/A",0,M75)+IF($F78="N/A",0,M88)66N23+N36+N49+N62+IF($F65="N/A",0,N75)+IF($F78="N/A",0,N88)0O23+O36+O49+O62+IF($F65="N/A",0,O75)+IF($F78="N/A",0,O88)0IF(E5="SUBS",1,0)123327359100028836331101054544211002864062311101437344112093861511302810424361140114160711501239IF(OR(ISBLANK(E3),ISBLANK(E5),ISBLANK(E7),ISBLANK(E9)),"For example:","Please use this fileame:")Please use this fileame:IF(OR(ISBLANK(E5),ISBLANK(E7),ISBLANK(E9)),"CORP_JCP_2008_07.xls",E5&"_"&E7&"_"&I106&"_"&J106&K106&".xls")SUBS_FDP_2017_11.xls481160282946118028316517152813472830YEAR(L13)2017IF(K106<10,"0","")MONTH(L13)11IF(M106<12,"0","")0DAY(L13)4497376427364276742795428264285642887429174294842979430094304043070431014313243160431914322143252432824331343344433744340543435434664349743525435564358643617436471(($N$23+$O$23) > 0)"$E$5=""SUBS"""$B$92"$b$98"(($N$23+$O$23) > 0)$B$920((#REF!+#REF!) > 0)0$F$13="N/A"0$G$13="N/A"0$H$13="N/A"0$I$13="N/A"0$J$13="N/A"0$K$13="N/A"0$I$65="N/A"0$J$65="N/A"0$K$65="N/A"0$L$65="N/A"0$F$65="N/A"0$G$65="N/A"0$H$65="N/A"0$F$78="N/A"0$G$78="N/A"0$F$78="N/A"0$F$78="N/A"0$F$65="N/A"$F$65="N/A"0$P$94:$P$108$F$95:$F$102$E$110:$E$140 Output: 2477IF(ISBLANK(E3),"<-- Please enter your Name", " ") 723542IF(ISBLANK(E5),"<-- Please enter your AREA", " ") 71078IF(ISBLANK(E7),"<-- Please enter your TDATA Initials", " ") 745843040IF(E9="","<-- Please select the month","")50661516171819202124226725IF(WEEKDAY($E$9)=1,$E$9,"N/A")N/AIF(F13="N/A", IF(WEEKDAY($E$9)=2,$E$9,"N/A"), F13+1)N/AIF(G13="N/A", IF(WEEKDAY($E$9)=3,$E$9,"N/A"), G13+1)N/AIF(H13="N/A", IF(WEEKDAY($E$9)=4,$E$9,"N/A"), H13+1)43040IF(I13="N/A", IF(WEEKDAY($E$9)=5,$E$9,"N/A"), I13+1)43041IF(J13="N/A", IF(WEEKDAY($E$9)=6,$E$9,"N/A"), J13+1)43042IF(K13="N/A", IF(WEEKDAY($E$9)=7,$E$9,"N/A"), K13+1)4304326271567221IF(ISBLANK(D14), "", ".").1790000000IF($F$13="N/A",0,F14)+IF($G$13="N/A",0,G14)+IF($H$13="N/A",0,H14)+IF($I$13="N/A",0,I14)+IF($J$13="N/A",0,J14)+IF($K$13="N/A",0,K14)+L140008075781078.51007.590IF($F$13="N/A",0,F15)+IF($G$13="N/A",0,G15)+IF($H$13="N/A",0,H15)+IF($I$13="N/A",0,I15)+IF($J$13="N/A",0,J15)+IF($K$13="N/A",0,K15)+L15250082755830000000000847518500000000008475486000000000080757890000.50.51020087755880000000000IF(ISBLANK(D21), "", ".")10000000000000000000051SUM(F14:F22)0SUM(G14:G22)78.598100+SUM(M14:M22)270070661516171819202124226725L13+143044F26+143045430464304743048430494305026271567221IF(ISBLANK(D27), "", ".").1790000000SUM(F27:L27)000807578104.56245.502200827558300000000008475185000000000084754860000000000807578900.518.5410150087755880001010200IF(ISBLANK(D34), "", ".")10000000000000000000052SUM(F27:F35)05711.587.50+SUM(M26:M35)39SUM(N27:N35)0SUM(O27:O35)069661516171819202124226725L26+143051F39+143052430534305443055430564305726271567221IF(ISBLANK(D40), "", ".").1790000000SUM(F40:L40)000807578100000000008275583000000000084751850000000000847548600000000008075789000000000087755880000000000IF(ISBLANK(D47), "", ".")10000000000000000000056SUM(F40:F48)0000000+SUM(M39:M48)0SUM(N40:N48)0SUM(O40:O48)068661516171819202124226725L39+143058F52+143059430604306143062430634306426271567221IF(ISBLANK(D53), "", ".").1790000000SUM(F53:L53)000807578100000000008275583000000000084751850000000000847548600000000008075789000000000087755880000000000IF(ISBLANK(D60), "", ".")10000000000000000000055SUM(F53:F61)0000000+SUM(M52:M61)0SUM(N53:N61)0SUM(O53:O61)053661516171819202124226725IF(DAY($L$52+1)<10,"N/A",$L$52+1)43065IF(DAY($L$52+2)<10,"N/A",$L$52+2)43066IF(DAY($L$52+3)<10,"N/A",$L$52+3)43067IF(DAY($L$52+4)<10,"N/A",$L$52+4)43068IF(DAY($L$52+5)<10,"N/A",$L$52+5)43069IF(DAY($L$52+6)<10,"N/A",$L$52+6)N/AIF(DAY($L$52+7)<10,"N/A",$L$52+7)N/A26271567221IF(ISBLANK(D66), "", ".").1790000000IF($F$65="N/A",0,F66)+IF($G$65="N/A",0,G66)+IF($H$65="N/A",0,H66)+IF($I$65="N/A",0,I66)+IF($J$65="N/A",0,J66)+IF($K$65="N/A",0,K66)+IF($L$65="N/A",0,L66)00080757810000000IF($F$65="N/A",0,F67)+IF($G$65="N/A",0,G67)+IF($H$65="N/A",0,H67)+IF($I$65="N/A",0,I67)+IF($J$65="N/A",0,J67)+IF($K$65="N/A",0,K67)+IF($L$65="N/A",0,L67)0008275583000000000084751850000000000847548600000000008075789000008000087755880000000000IF(ISBLANK(D73), "", ".")10000000000000000000054SUM(F66:F74)0000080+SUM(M65:M74)0IF($F$65="N/A",0,SUM(N66:N74))0IF($F$65="N/A",0,SUM(O66:O74))06366151624226725IF(DAY($L$52+8)<10,"N/A",$L$52+8)N/AIF(DAY($L$52+9)<10,"N/A",$L$52+9)N/A26271567221IF(ISBLANK(D79), "", ".").1790000000IF($F$78="N/A",0,F79)+IF($G$78="N/A",0,G79)000807578105000000008275583060000000084751850100000000847548600000000008075789000000000087755880000000000IF(ISBLANK(D86), "", ".")10000000000000000000064SUM(F79:F87)0SUM(G79:G87)12+SUM(M78:M87)0IF($F$78="N/A",0,SUM(N79:N87))0IF($F$78="N/A",0,SUM(O79:O87))057M23+M36+M49+M62+IF($F65="N/A",0,M75)+IF($F78="N/A",0,M88)66N23+N36+N49+N62+IF($F65="N/A",0,N75)+IF($F78="N/A",0,N88)0O23+O36+O49+O62+IF($F65="N/A",0,O75)+IF($F78="N/A",0,O88)0IF(E5="SUBS",1,0)123327359100028836331101054544211002864062311101437344112093861511302810424361140114160711501239IF(OR(ISBLANK(E3),ISBLANK(E5),ISBLANK(E7),ISBLANK(E9)),"For example:","Please use this fileame:")Please use this fileame:IF(OR(ISBLANK(E5),ISBLANK(E7),ISBLANK(E9)),"CORP_JCP_2008_07.xls",E5&"_"&E7&"_"&I106&"_"&J106&K106&".xls")SUBS_FDP_2017_11.xls481160282946118028316517152813472830YEAR(L13)2017IF(K106<10,"0","")MONTH(L13)11IF(M106<12,"0","")0DAY(L13)4497376427364276742795428264285642887429174294842979430094304043070431014313243160431914322143252432824331343344433744340543435434664349743525435564358643617436471(($N$23+$O$23) > 0)"$E$5=""SUBS"""$B$92"$b$98"(($N$23+$O$23) > 0)$B$920((#REF!+#REF!) > 0)0$F$13="N/A"0$G$13="N/A"0$H$13="N/A"0$I$13="N/A"0$J$13="N/A"0$K$13="N/A"0$I$65="N/A"0$J$65="N/A"0$K$65="N/A"0$L$65="N/A"0$F$65="N/A"0$G$65="N/A"0$H$65="N/A"0$F$78="N/A"0$G$78="N/A"0$F$78="N/A"0$F$78="N/A"0$F$65="N/A"$F$65="N/A"0$P$94:$P$108$F$95:$F$102$E$110:$E$140 xl/styles.xml Input: Output: