tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 75927d1276533053-need-to-sum-only-certain-numbers-with-a-date-restriction-detailedexample
Sheet: detail-2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | size % by week
 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45
 | 2010-04-19 00:00:00 | 2010-04-26 00:00:00 | 2010-05-03 00:00:00 | 2010-05-10 00:00:00 | 2010-05-17 00:00:00 | 2010-05-24 00:00:00 | 2010-05-31 00:00:00 | 2010-06-07 00:00:00 | 2010-06-14 00:00:00 | 2010-06-21 00:00:00 | 2010-06-28 00:00:00 | 2010-07-05 00:00:00 | 2010-07-12 00:00:00 | 2010-07-19 00:00:00 | 2010-07-26 00:00:00 | 2010-08-02 00:00:00 | 2010-08-09 00:00:00 | 2010-08-16 00:00:00 | 2010-08-23 00:00:00 | 2010-08-30 00:00:00 | 2010-09-06 00:00:00 | 2010-09-13 00:00:00 | 2010-09-20 00:00:00 | 2010-09-27 00:00:00 | 2010-10-04 00:00:00 | 2010-10-11 00:00:00 | 2010-10-18 00:00:00 | 2010-10-25 00:00:00 | 2010-11-01 00:00:00 | 2010-11-08 00:00:00
Yel Pch
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11334.01612478781 | 14191.1628129413 | 29817.69093855041 | 39848.11996361544 | 39898.33127198304 | 34658.02821010334 | 6144.665311740092 | 5.11373813685505 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60254.98710300359 | 34479.8004173228 | 47226.24586966545 | 45736.60217928088 | 26687.0881861315 | 17100.35520391497 | 2984.551722845187 | 2.483815666472453 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 42196.23127819561 | 47348.19574689127 | 86864.17998473588 | 93563.26807255154 | 72591.39854094267 | 56863.6449496151 | 10033.48089259478 | 8.35010391661811 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2318.768066344938 | 13426.21861038782 | 29266.84596371442 | 31436.0990532603 | 24339.0063389732 | 19055.02091347135 | 3362.129982705537 | 2.798045368032626 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 51.32402616974631 | 3317.746405318576 | 8247.85680995699 | 10856.52209375643 | 10255.60883031821 | 8652.011664156398 | 1531.957653063968 | 1.274931973846054 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 76049.770808 | 209711.87398 | 342372.7788778053 | 216778.0099442141 | 234139.6018908293 | 116155.3265985017 | 112763.1239928618 | 201422.8195666231 | 221440.6113624646 | 173771.4331683486 | 136329.0609412612 | 24056.78556294956 | 20.02063506182429 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 67941d1268428525-text-formula-working-with-dates
Sheet: Sheet1

First Name | Surname | Date of Birth |  |  |  |  |  |  |  |  |  |  | 2010-12-31 00:00:00
[NAME] | White | 1956-09-11 00:00:00
Caroline | Green | 1958-07-03 00:00:00
[NAME] | Black | 1989-10-17 00:00:00
Imogen | [NAME] | 1988-09-22 00:00:00
[NAME] | [NAME] | 1987-01-08 00:00:00
[NAME] | Gray | 1958-04-11 00:00:00
Spreadsheet: john_griffith__15965__11_16_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | EXP |  |  | 61.2 | 72.3 | 0.9 | 2001-11-13 14:31:00
 | CL F2 | 18.5 | 260 | 270 | 63.8 | 66.3 | 0.76 | 2001-11-16 14:37:00
 | CL G2 | 18.5 | 365 | 380 | 61 | 63.5 | 0.72 | 2001-11-16 14:37:00
 | CL H2 | 19 | 410 | 430 | 55.2 | 57.9 | 0.68 | 2001-11-16 14:37:00
 | CL J2 | 19 | 460 | 480 | 54 | 56.4 | 0.66 | 2001-11-16 14:37:00
 | CL K2 | 19 | 495 | 515 | 51.7 | 53.8 | 0.63 | 2001-11-16 14:37:00
 | CL M2 | 19.5 | 520 | 540 | 48.7 | 50.6 | 0.61 | 2001-11-16 14:37:00
 | CL N2 | 19.5 | 540 | 560 | 46.8 | 48.6 | 0.58 | 2001-11-16 14:37:00
 | CL Q2 | 19.5 | 555 | 575 | 45.2 | 46.8 | 0.56 | 2001-11-16 14:37:00
 | CL U2 | 19.5 | 560 | 585 | 43.3 | 45.3 | 0.54 | 2001-11-16 14:37:00
 | [NAME] | 19.5 | 560 | 585 | 41.1 | 42.9 | 0.51 | 2001-11-16 14:37:00
 | CL X2 | 20 | 560 | 585 | 38.3 | 40.1 | 0.49 | 2001-11-16 14:37:00
 | [NAME] | 20 | 555 | 575 | 36.7 | 38 | 0.47 | 2001-11-16 14:37:00
 | CL M3 | 20 | 550 | 585 | 30.5 | 32.5 | 0.4 | 2001-11-16 14:37:00
 | CL Z3 | 20 | 550 | 590 | 27 | 29 | 0.35 | 2001-11-16 14:37:00
Spreadsheet: 41390d1239866380-return-multiple-values-in-separate-cells-example2
Sheet: Sheet1

Code | Item | Key |  | Input Code | 92325 | 2 | 24400
92455 | 10105253 | 0 |  |  |  |  | 25000
91745 | 23640 | 0
92325 | 24400 | 1
90710 | 29198 | 1
91765 | 10100420 | 1
91645 | 24401 | 1
92325 | 25000 | 2
 |  |  |  | This column can be hidden if desired, but its function
 |  |  |  | keeps from needing to use array formulas. This approach
 |  |  |  | will scale up to pretty much ANY size, while arrays bog down on
 |  |  |  | large data sets.
 |  |  |  | G1 uses a custom number format, so it really only has the number "2" in it,.
 |  |  |  | the "items" is added by the number format.
Spreadsheet: 162447d1339887256-search-multiple-spreadsheets-d-report-log-2012-3
Sheet: SEARCH

 | [NAME]:
NHSP-W DISCIPLINARY REPORT LOG
D-Report Number | Date | Inmate | Reporting Staff | Violation(s) |  |  |  |  | Date of Disposition | Date of Hearings | Outcome | Sanctions (in days) |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  |  | PG, FWOP, BS, Inc, FG, FNG | P/S | [NAME] | XD | Lost Cant | Lost Rec | Lost Radio | Lost TV | Lost Phone | Lost Radio | Good Time | Lost Visit | Restitution
Spreadsheet: 726770d1617444940-sumifs-function-doesnt-calculate-values-as-expected-accounting-module-1-sumproduct
Sheet: P&L

 | Profit and Loss Statement
 |  |  |  | Month1 | Month2 | Month3 | Month4 | Month5 | Month6 | Month7 | Month8 | Month9 | Month10 | Month11 | Month12 | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD
 | Income
 |  | Total Income
 | Cost of Goods Sold
 |  | Opening Stock
 |  | Closing Stock
 |  | Total Cost of Sales
 |  | Gross Profit
 |  | (Total Income less Cost of Sales)
 | Expenses
 |  | Total Expenses
 |  | Net Profit/(Loss)
 |  | (Gross Profit less Expenses) |  |  |  |  |  |  |  |  |  |  |  |  |  | Total YTD
 |  |  |  | Month1 | Month2 | Month3 | Month4 | Month5 | Month6 | Month7 | Month8 | Month9 | Month10 | Month11 | Month12
Spreadsheet: 105551d1302869543-linear-interpolation-not-working-test12
Sheet: Sheet1

X | Y
0.001 | 0.006 |  |  |  |  |  | Look for
0.002 | 0.006 |  | forecast | 0.04157089548053323 |  |  | 15
0.01 | 0.006 |  | trend | 0.04157089548053323
0.02 | 0.01 |  | linest | 0.001498757035814781
0.1 | 0.016 |  | Graph formula | 0.0416
0.2 | 0.02 |  | linest | 0.001498757035814781
1 | 0.03 |  | linest | 0.001498757035814781
2 | 0.04
10 | 0.06
20 | 0.08
100 | 0.16
200 | 0.33
1000 | 1.5
2000 | 3
10000 | 15
20000 | 30
Spreadsheet: 27795d1221453510-holdings-checking-checking-holdings
Sheet: 250808

Date | FROM | SecCode
2008-08-29 00:00:00 | LON | QQCAAA
2008-08-29 00:00:00 | LON | QQZBBB
2008-08-29 00:00:00 | LON | QQHCCC
2008-08-29 00:00:00 | LON | [NAME]
2008-08-29 00:00:00 | LON | QQREEE
2008-08-29 00:00:00 | LON | QQSFFF
2008-08-29 00:00:00 | LON | QQTGGG
2008-08-29 00:00:00 | LON | QQXHHH
2008-08-29 00:00:00 | LON | QQZPBIII
2008-08-29 00:00:00 | LON | QBBJJJ
2008-08-29 00:00:00 | LON | QBCKKK
2008-08-29 00:00:00 | LON | QBILLL
2008-08-29 00:00:00 | LON | QBJMMM
2008-08-29 00:00:00 | LON | [NAME]
2008-08-29 00:00:00 | LON | QBQOOO
2008-08-29 00:00:00 | LON
2008-08-29 00:00:00 | LON | QBQQQQ
2008-08-29 00:00:00 | LON | QBSSMWRRR
2008-08-29 00:00:00 | LON | QBUSSSS
2008-08-29 00:00:00 | LON | QBVTTTTTT
2008-08-29 00:00:00 | LON | QBWUUUU
2008-08-29 00:00:00 | LON | QBYVVVVVV
2008-08-29 00:00:00 | LON | QCBWWWWW
2008-08-29 00:00:00 | LON | QCKXXXXX
2008-08-29 00:00:00 | LON
2008-08-29 00:00:00 | LON | QCRZZZZZ
Spreadsheet: 2d80641a-ed4d-4b3e-8ef0-3d671e4ae7fb
Sheet: Sheet1

Judgeship Number 6 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 6/19/2013 10:33:52 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
Precinct | [NAME] | TOTALS
Precinct 2003 | 200 | 200
Precinct 2004 | 232 | 232
Precinct 2005 | 48 | 48
Precinct 2301 | 137 | 137
Precinct 2302 | 231 | 231
TOTAL | 848 | 848
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 47496d1246521096-vba-resetting-one-cell-if-another-is-changed-cf
Sheet: Sheet1

Stock level | Days the same | Green | Amber | Red
89 | 1 | 1 | 0 | 0
89 | 60 | 0 | 0 | 1
89 | 32 | 0 | 1 | 0
89 | 12 | 1 | 0 | 0
89 | 7 | 1 | 0 | 0
Spreadsheet: a855e308-a4d5-47e3-af04-bcd6dd489f03
Sheet: Sheet1

Votre recherche :  [NAME] : PHILOTHEVS COCCINVS CPL PTR Œuvre : REFVTATIO ANATHEMATISMORVM HARMENOPVLI | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Ville | [NAME] | Cote | Folios | Siècle | Date | Commentaire | Copiste | Source
ATHENA | [NAME] tês Hellados (EBE) | Metochion tou panagiou Taphou 640 | 187v-89* | 15, 18
ATHENA | [NAME] tês Hellados (EBE) | Metochion tou panagiou Taphou 640 | 187v-89*
[NAME] OROS | [NAME] | 25 | 080-81 | 15 med. |  |  |  | R(III)1122a
[NAME] OROS | [NAME] | 26 | 217-218v | 17 | 1682 |  |  | R(III)1122a
[NAME] OROS | Monê Megistês Lauras | Κ 112 (Eustratiades 1399) | 300v-302v
[NAME] OROS | Monê Megistês Lauras | Ω 098 (Eustratiades 1910) | 293-96* | 14
LEIPZIG | UB | Gr. 47 ([NAME]. 3481) | 234v-36 | 15
MADRID | BN | 4608 | 194-195v | 14-15 |  |  |  | R(III)1608R(III)1609
MUTILENE | Monê tou [NAME] | 7 |  | 15 | 1421
NEW HAVEN | Yale University Beinecke Rare Book & Ms. [NAME] | 301 | 169v-174 | 16 | 1586 | Cf. [NAME], Manuale legum sive Hexabiblos, Leipzig, 1851, p. 822-826 |  | R(III)1797
PARIS | Bibliothèque nationale de France (BnF) | gr. 1361 | 128-29* | 15
PARIS | Bibliothèque nationale de France (BnF) | gr. 1363 | p. 359-61* | 16 | 1544
PARIS | Bibliothèque nationale de France (BnF) | gr. 1363A | 211v-12v* | 17 | 1671
PARIS | Bibliothèque nationale de France (BnF) | gr. 1388 | 243v-45v* | 15
SOFIJA | [NAME] za Slavjano-[NAME] Dujčev » | D. gr. 156 | 103r-v | 15 |  |  | ΓΕΩΡΓΙΟΣ ΒΑΙΟΦΟΡΟΣ (RGK I 55, II 74, III 90) | R(III)2226a
TORINO | Biblioteca Nazionale Universitaria | C. VII. 14 (Pasini 278) |  | 16
TORINO | Biblioteca Nazionale Universitaria | C. VII. 14 (Pasini 278)
VATICANO | [NAME] | [NAME]. gr. 172 | 102v-104*
VATICANO | [NAME] | [NAME]. gr. 172 | 102v-104* | 16
VATICANO | [NAME] | Palat. gr. 256 |  | 15 | 1449 |  | ΝΙΚΟΛΑΟΣ ΜΕΛΛΑΧΡΗΝΟΣ (RGK I 313, II 433, III 504)
VATICANO | [NAME] | Palat. gr. 369 | 083v-84* | 15-16
VATICANO | [NAME] | [NAME]. gr. 0848 | 259-61 | 14-15
VATICANO | [NAME] | [NAME]. gr. 0849 | 280v-82v | 15
VATICANO | [NAME] | [NAME]. gr. 0850 | 196-97v | 15
WIEN | [NAME] | hist. gr. 034 | 310v-11v | 15 | 1430
Spreadsheet: 777745d1650573650-serpentine-numbers-in-a-table-formula-serpentineformula_forum3
Sheet: M365

 | Rows ► | 15
 | Cols ► | 23
 | Start ► | 1001
 |  | 1344 | 1343 | 1342 | 1341 | 1340 | 1339 | 1338 | 1337 | 1336 | 1335 | 1334 | 1333 | 1332 | 1331 | 1330 | 1329 | 1328 | 1327 | 1326 | 1325 | 1324 | 1323
 | 1300 | 1301 | 1302 | 1303 | 1304 | 1305 | 1306 | 1307 | 1308 | 1309 | 1310 | 1311 | 1312 | 1313 | 1314 | 1315 | 1316 | 1317 | 1318 | 1319 | 1320 | 1321 | 1322
 | 1299 | 1298 | 1297 | 1296 | 1295 | 1294 | 1293 | 1292 | 1291 | 1290 | 1289 | 1288 | 1287 | 1286 | 1285 | 1284 | 1283 | 1282 | 1281 | 1280 | 1279 | 1278 | 1277
 | 1254 | 1255 | 1256 | 1257 | 1258 | 1259 | 1260 | 1261 | 1262 | 1263 | 1264 | 1265 | 1266 | 1267 | 1268 | 1269 | 1270 | 1271 | 1272 | 1273 | 1274 | 1275 | 1276
 | 1253 | 1252 | 1251 | 1250 | 1249 | 1248 | 1247 | 1246 | 1245 | 1244 | 1243 | 1242 | 1241 | 1240 | 1239 | 1238 | 1237 | 1236 | 1235 | 1234 | 1233 | 1232 | 1231
 | 1208 | 1209 | 1210 | 1211 | 1212 | 1213 | 1214 | 1215 | 1216 | 1217 | 1218 | 1219 | 1220 | 1221 | 1222 | 1223 | 1224 | 1225 | 1226 | 1227 | 1228 | 1229 | 1230
 | 1207 | 1206 | 1205 | 1204 | 1203 | 1202 | 1201 | 1200 | 1199 | 1198 | 1197 | 1196 | 1195 | 1194 | 1193 | 1192 | 1191 | 1190 | 1189 | 1188 | 1187 | 1186 | 1185
 | 1162 | 1163 | 1164 | 1165 | 1166 | 1167 | 1168 | 1169 | 1170 | 1171 | 1172 | 1173 | 1174 | 1175 | 1176 | 1177 | 1178 | 1179 | 1180 | 1181 | 1182 | 1183 | 1184
 | 1161 | 1160 | 1159 | 1158 | 1157 | 1156 | 1155 | 1154 | 1153 | 1152 | 1151 | 1150 | 1149 | 1148 | 1147 | 1146 | 1145 | 1144 | 1143 | 1142 | 1141 | 1140 | 1139
 | 1116 | 1117 | 1118 | 1119 | 1120 | 1121 | 1122 | 1123 | 1124 | 1125 | 1126 | 1127 | 1128 | 1129 | 1130 | 1131 | 1132 | 1133 | 1134 | 1135 | 1136 | 1137 | 1138
 | 1115 | 1114 | 1113 | 1112 | 1111 | 1110 | 1109 | 1108 | 1107 | 1106 | 1105 | 1104 | 1103 | 1102 | 1101 | 1100 | 1099 | 1098 | 1097 | 1096 | 1095 | 1094 | 1093
 | 1070 | 1071 | 1072 | 1073 | 1074 | 1075 | 1076 | 1077 | 1078 | 1079 | 1080 | 1081 | 1082 | 1083 | 1084 | 1085 | 1086 | 1087 | 1088 | 1089 | 1090 | 1091 | 1092
 | 1069 | 1068 | 1067 | 1066 | 1065 | 1064 | 1063 | 1062 | 1061 | 1060 | 1059 | 1058 | 1057 | 1056 | 1055 | 1054 | 1053 | 1052 | 1051 | 1050 | 1049 | 1048 | 1047
 | 1024 | 1025 | 1026 | 1027 | 1028 | 1029 | 1030 | 1031 | 1032 | 1033 | 1034 | 1035 | 1036 | 1037 | 1038 | 1039 | 1040 | 1041 | 1042 | 1043 | 1044 | 1045 | 1046
 | 1023 | 1022 | 1021 | 1020 | 1019 | 1018 | 1017 | 1016 | 1015 | 1014 | 1013 | 1012 | 1011 | 1010 | 1009 | 1008 | 1007 | 1006 | 1005 | 1004 | 1003 | 1002 | 1001
Spreadsheet: louise_kitchen__22533__3base329c
Sheet: Credit Analysis

Subsequent Credit Analysis
Raptor 3
Date
Rates |  | Full Monetization | Monetize 30MM | No Monetization
$50MM N/R | 0.07
$50MM N/P | 0.075
$259MM N/P | 0.0725
TNPC Screen |  | 15.42372177175631 | 9.81124244931266 | 9.099177499795088
Porcupine Balance Sheet
 | As of
Assets |  |  | Liabilities + Equity
Cash |  |  | Note Payable
[NAME] |  |  | Note Payable
Note from ENE |  |  | Derivative Payable
Derivative Rec. |  |  | Minority Interest
 |  |  | LJM
 |  |  | ENE
Equity Rollforward
ENE Capital @ IPO
LJM Capital @ IPO
MI Capital @ IPO
Total Capital @ IPO
Plus Gain on TNPC Stock
Plus Derivative Gain/Loss
Less Net Interest Expense
Current Capital
Less ENE Capital
LJM Capital
MI Capital
Check
Credit Test
Value of Assets
Less:
Note Payable
Other Note
Minority Interest
Derivative
3% Test
Bal Sheet Foot
Plus:  Fees Paid By Enron
Less: 3rd Party Equity
Net
Req'd Equity %
[NAME]
Actual Equity
Excess Equity
Notional Capacity
Less Notional Hedged
Unused Capacity
Spreadsheet: 133347d1324343478-moving-vertical-data-into-horizontal-data-formatting-example
Sheet: Sheet1

CURRENT FORMATTING
EE SSN | RELATIONSHIP | FIRST NAME | LAST NAME
0 | 0 | [NAME] | SMITH
0 | 1 | LINDSAY | SMITH
0 | 2 | CHELSEA | SMITH
0 | 2 | JORDAN | SMITH
1 | 0 | [NAME] | JONES
2 | 0 | SHARON | TAYLOR
3 | 0 | [NAME] | WATSON
3 | 1 | EMILY | WATSON
DESIRED FORMATTING
FIRST NAME EE | LAST NAME EE |  | SPOUSE FIRST | SPOUSE LAST |  | CHILD FIRST | CHILD LAST |  | CHILD FIRST | CHILD LAST
[NAME] | SMITH |  | LINDSAY | SMITH |  | CHELSEA | SMITH |  | JORDAN | SMITH
[NAME] | JONES
SHARON | JONES
[NAME] | WATSON |  | EMILY | WATSON
Spreadsheet: 791215d1660213443-sum-difference-between-date-intervals-based-on-specific-conditions-excel-forum-11-auagust-ans
Sheet: Sheet1 (2)

 | Name of Worker | Initial date | End date | Sum of difference when initial dates are equal | Sum of difference when initial dates are not equal | Notes for the applied result
 | Walid | 2020-01-30 00:00:00 | 2020-01-30 00:00:00 | 2 |  | Walid has two equal initial date (at row 2 and row 3), the sum of two rows here is 2, because I shall consider when end date equal initial date then value equal one.
 | Walid | 2020-01-30 00:00:00 | 2020-01-30 00:00:00 |  |  | The value is summed in above row, so no need to duplicate it here
 | [NAME] | 2020-01-30 00:00:00 | 2020-01-30 00:00:00 |  | 1 | [NAME] has a single date difference, end date equal initial date then [NAME] sum is 1, I prefer to have this value seperated from the first column
 | Kenan | 2020-02-05 00:00:00 | 2020-02-06 00:00:00 | 4 |  | Kenan has at two equal initial dates (at row 5 and row6), the sum of two rows here is 4, because I shall consider initial date value as equal one when difference is applied
 | Kenan | 2020-02-05 00:00:00 | 2020-02-06 00:00:00 |  |  | The value is summed in above row, so no need to duplicate it here
 | Fadi | 2020-02-05 00:00:00 | 2020-02-06 00:00:00 |  | 2 | Fadi has a single date difference, End date is the next day of the initial date, [NAME] is only 2 (difference is 1 and added 1 for initial), I prefer to have this value seperated from the first column
 | Walid | 2020-02-05 00:00:00 | 2020-02-05 00:00:00 | 1 |  | Walid has a time difference here that is not related to the initial two rows above..The sum is the time difference which is 1
Spreadsheet: 329558d1404334915-comparing-two-columns-in-two-different-sheets-and-get-the-common-in-the-first-sheet-docregister
Sheet: Outgoing

[NAME] | Reply to  incoming
ADG/GOV/001
ADG/DEC/001 | DEC/ADG/002
ADG/TTC/001
ADG/GOV/002 | GOV/ADG/001
ADG/DEC/002
ADG/TTC/002 | TTC/ADG/004
ADG/GOV/003
ADG/DEC/003
ADG/TTC/003
ADG/GOV/004
ADG/DEC/004
ADG/TTC/004 | TTC/ADG/003
ADG/GOV/005
ADG/DEC/005
ADG/TTC/005
ADG/GOV/006 | GOV/ADG/003
ADG/DEC/006
ADG/TTC/006 | DEC/ADG/004
ADG/GOV/007
ADG/DEC/007
ADG/TTC/007
ADG/GOV/002
ADG/DEC/002
ADG/TTC/002
ADG/GOV/003
ADG/DEC/003
Spreadsheet: 49738d1249053602-if-no-data-then-show-empty-cell-emial-invoice
Sheet: Email Invoice

 | INVOICE
 | Invoice Date |  | Invoice Number |  | Terms
 | 2009-05-21 00:00:00 |  | 89231 |  | 7 Days
 | Ref: | [NAME] |  |  |  |  | [NAME] and Sons
 |  |  |  |  |  |  | 32 Caestory Crescent
 |  |  |  |  |  |  | [NAME], [NAME], NP15 2EG
 | Invoice To: | [NAME] |  |  |  |  | Tel: 01291 691062
 |  | [NAME]
 |  | The Hendre |  |  |  |  | VAT Reg No 9292 744 93
 |  | Monmouth
 |  | Monmouthshire
 | Ref | Description |  |  |  |  |  |  |  |  | Cost
 | 1 | a |  |  |  |  |  |  |  |  | 100
 | 2 | b |  |  |  |  |  |  |  |  | 13
 | 3 | c |  |  |  |  |  |  |  |  | 234
 | 4 | Description |  |  |  |  |  |  |  |  | 50
 | 5 |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 | A. A.Price t/a Anthony Price and Sons |  |  |  |  |  |  | Nett Total |  |  | 421
 |  |  |  |  |  |  |  | VAT @ | 15 | % | 63.15
 |  |  |  |  |  |  |  | TOTAL |  |  | 484.15
Spreadsheet: 162047d1339699661-how-to-select-range-for-formula-example3
Sheet: Sheet2

 | DQA1*0101 | DQA1*0102 | DQA1*0103 | DQA1*0104 | DQA1*0105 | DQA1*0203 | DQA1*0204 | DQA1*0205 | DQA1*0206 | DQA1*0301 | DQA1*0302 | DQA1*0401 | DQA1*0801 | DQA1*0802 | DQA1*0803 | DQA1*10011 | DQA1*10012 | DQA1*1101 | DQA1*12011 | DQA1*12012 | DQA1*12021 | DQA1*1203 | DQA1*1204 | DQA1*1301 | DQA1*1302 | DQA1*1401 | DQA1*New06 | DQA1*New07 | DQA1*New08 | DQA1*New09 | DQA1*New10 | [NAME]*2101 | [NAME]*2201-i01 | [NAME]*2201-i05 | [NAME]*2201-i13 | [NAME]*2201 | [NAME]*22021 | [NAME]*22022 | [NAME]*22023 | [NAME]*22031 | [NAME]*2206 | [NAME]*2207 | [NAME]*2401 | [NAME]*2901 | [NAME]*3101 | [NAME] | [NAME]*25012 | [NAME]*3001 | DQB*0101 | DQB*0102 | DQB*0103 | DQB*0201 | DQB*0301 | DQB*0302 | DQB*0303 | DQB*0501 | DQB*0502 | DQB*0601 | DQB*0901 | DQB*1001 | DQB*10021 | DQB*1003 | DQB*1005 | DQB*1201 | DQB*1301 | DQB*1401 | DQB*1402 | DQB*1403 | DQB*1404 | DQB*1501 | DQB*1702 | DQB*1802 | DQB*1803 | DQB*1809 | DQB*1901 | DQB*2701 | DQB*3302 | DQB*3601 | DQB*3602 | DQB*4101 | DQB*New09 | DQB*New11 | DQB*New12 | DQB*New13 | DQB*New14 | DQB*New15 | DQB*New37 | DQB*New38
DQA1*0101
DQA1*0102
DQA1*0103
DQA1*0104
DQA1*0105
DQA1*0203
DQA1*0204
DQA1*0205
DQA1*0206
DQA1*0301
DQA1*0302
DQA1*0401
DQA1*0801
DQA1*0802
DQA1*0803
DQA1*10011
DQA1*10012
DQA1*1101
DQA1*12011
DQA1*12012
DQA1*12021
DQA1*1203
DQA1*1204
DQA1*1301
DQA1*1302
DQA1*1401
DQA1*New06
DQA1*New07
DQA1*New08
DQA1*New09
DQA1*New10
[NAME]*2101
[NAME]*2201-i01
[NAME]*2201-i05
[NAME]*2201-i13
[NAME]*2201
[NAME]*22021
[NAME]*22022
[NAME]*22023
[NAME]*22031
[NAME]*2206
[NAME]*2207
[NAME]*2401
[NAME]*2901
[NAME]*3101
[NAME]
[NAME]*25012
[NAME]*3001
DQB*0101
DQB*0102
DQB*0103
DQB*0201
DQB*0301
DQB*0302
DQB*0303
DQB*0501
DQB*0502
DQB*0601
DQB*0901
DQB*1001
DQB*10021
DQB*1003
DQB*1005
DQB*1201
DQB*1301
DQB*1401
DQB*1402
DQB*1403
DQB*1404
DQB*1501
DQB*1702
DQB*1802
DQB*1803
DQB*1809
DQB*1901
DQB*2701
DQB*3302
DQB*3601
DQB*3602
DQB*4101
DQB*New09
DQB*New11
DQB*New12
DQB*New13
DQB*New14
DQB*New15
DQB*New37
DQB*New38
Spreadsheet: 864313d1711536689-booking-document-need-help-booking-ramadhan-ballroom
Sheet: F&B Summary 

Total booking code | Booking code | Total in IDR
 | 250323
 | 260323
 | 270323
 | 280323
 | 290323
 | 300323
 | 310323
 | 10423
 | 20423
 | 30423
 | 40423
 | 50423
 | 60423
 | 70423
 | 80423
 | 90423
 | 100423
 | 110423
 | 120423
 | 130423
 | 140423
 | 150423
 | 160423
 | 170423
 | 180423
 | 190423
 | 200423
 | 210423
 | 220423
Spreadsheet: 767925d1644742736-eight-extend-to-nine-words-eight-extends
Sheet: Sheet1

AROINTED |  |  | WAREHOUSE |  | Y |  |  |  |  |  | 8
[NAME] |  |  | RODENTIAL
ORDINATE |  |  | DERATIONS
[NAME] |  |  | NOTARISED
ORIENTAL |  |  | ORDINATES
RELATION |  |  | ORIENTALS
TAILERON |  |  | RELATIONS
ANOESTRI |  |  | SEROTINAL
ARSONITE |  |  | TAILERONS
NOTAIRES |  |  | TENSORIAL
WAREHOUS | Y |  | OUTLINEAR
Spreadsheet: 66478d1267119651-solved-trouble-with-conditional-formatting-referencing-an-alternative-cell-book3
Sheet: Sheet1

Symbols
Increase | Decrease | No Change
↑ | ↓ | -
 |  |  |  |  | 19258 | 577 | 8052.1
 |  |  |  |  | 21825 | 2302 | 68248.18
 |  |  |  |  | 35544 | 2499 | 3296.13
 |  |  |  |  | 34626 | 393 | 292095.42
 |  |  |  |  | 20000 | 3500 | 300000
 |  |  |  | Total |  |  |  | 800000
 |  |  |  | Last Week | 119365 | 8843 | 758336 | 800000
 |  |  |  | Change
Spreadsheet: 102205d1300205282-extract-largest-number-in-an-alphanumerical-string-largestnumberinstring
Sheet: Sheet1

32"x12345678" | 12345678 | 8 | 78 | 678 | 5678 | 45678 | 345678 | 2345678 | 12345678 | 0 | 0
16"Wx20"H | 20 | 6 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10"X12" | 12 | 2 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1" Diam | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 288647d1389266927-message-box-when-updating-a-cell-value-book1
Sheet: Completions Reeport

JOB NUMBER | ORIGINALJOBREF | MPRN | OLD METER SERIAL | ADDRESS | CONTACT | TELEPHONE | POST CODE | SCHEDULED DATE | SCHEDULED SLOT | ATTENDED DATE | BOOKED DATE | ENGINEER | SCHEDULINGNOTES | WORKTYPE | [NAME] | RECEIVED TIME (Emergency Only) | START TIME | ATTENDED TIME | FINISH TIME | JOB [NAME]? (YES OR NO) | NATURE OF JOB (EXCHANGE' WIND ON' DECOM/RECOM' RESET' ETC?) | HOUSE DETAILS / ABORT DETAILS | OLD MSN | MANUFACTURER | METER MODEL | YEAR OF MANUFACTURE | CLOSING READ | MAP | SCFH / SCMH | NUMBER OF DIALS | Location | SEMI-CON? | BRACKET USED? | Pulse block | MP KIT USED? | CONEX ECV ADAPTOR? | ADM SERIAL NO. | NEW MODULE NUMBER | NEW MSN | MANUFACTURER | OPENING READ | YEAR OF MANUFACTURE | COMMENTS | Data Issues | [NAME] | Time / User update
Test Job | TSEST | 213 | 4568 | TEST Address | MISS N ONE | 123456789 | Postcode | 2013-05-14 00:00:00 | AD | 2013-05-14 00:00:00 |  | TEST |  | Test |  |  |  |  |  | no
Spreadsheet: 754278d1636051530-highlighting-cells-with-same-last-name-with-different-first-names-excel-demo
Sheet: Sheet1

 | Loan Number | Borrower Name
 | [PHONE] | [NAME], [NAME]
 | 222222222 | Smith, [NAME]
 | 333333333 | Henderson, [NAME]
 | [PHONE] | Tonka, [NAME]
 | [PHONE] | Smith, [NAME]
 | [PHONE] | Kawasaki, T
 | [PHONE] | Smith, J.D.F
 | [PHONE] | Laslow, [NAME]
 | [PHONE]
 | [PHONE]
Spreadsheet: 274723d1383206663-mapping-data-to-different-spreadsheets-amanda_reply-2
Sheet: Clear to Close

Clear to Close
Current Status | Date | Last Name | Lender Name | Type of Loan | [NAME] | Purpose | Prop Type | Title Company | Loan Officer | Loan Amount | Processor | Notes |  | Match (All data Row)