tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5743__Equistar Activity 2001
Sheet: March 01

 | EQUISTAR  ACTIVITY for March 2001 |  |  |  |  |  |  | file name: Equistar Activity 2001.xls
 | Effective 3/1/01
 |  |  |  |  | from | to
 | Meter # |  | Deal # | Price ($) | Volume |  | Matrix
 | 1062 |  | 378904 | Greater of $3.22 or Index - $.10 | 3000 |  | ENA |  | x
 | 1334
 | 1373 |  | 157572 | Greater of $2.23 or Index - $.05 | 10000 |  |  |  | x
 | 1373 |  | 378904 | Greater of $3.22 or Index - $.10 | 2000 |  | ENA |  | x
 | 1373 |  | 165373 | Greater of $2.15 | 10000 |  | HPLC |  | x
 | 1373 |  | 128806 | Greater of $2.05 or Index - $.055 | 0 |  | HPLC |  | x
 | 1373 |  | 202387 | $2.21 or Index -$.07 | 0 |  | HPLC |  | x
 | 1373 |  | 487588 | $2.68 or Index-$.10 | 0 |  | HPLC |  | x
 | 1373 |  | 394489 | Greater of $4.07 or Index - $.20 | 10000 |  | ENA | Sitara shows 5.000 | x
 | 1384 |  | 128806 | Greater of $2.05 or Index - $.055 | 0 |  |  |  | x
 | 1384 |  | 240061 | $2.20 or Index -$.05 | 5000 |  | ENA |  | x
 | 1384 |  | 378904 | Greater of $3.22 or Index - $.10 | 0 |  |  |  | x
 | 1384 |  | 394489 | Greater of $4.08 or Index - $.20 | 5000 |  | ENA | [NAME] shows 0
 | 1399 |  | 165372 | $2.11or Index -$.07 | 5000 |  | HPLC |  | x
 | 1552 |  | 202387 | $2.21 or Index -$.07 | 5000 |  | ENA |  | x
 | 1552 |  | 487588 | $2.68 or Index-$.10 | 5000 |  | ENA |  | x
 | 1552 |  | 394489 | $4.08 or Index-$.20 | 5000 |  | ENA | matches [NAME] | x
 | 1553 |  | 378904 | $3.22 or Index-$.10 | 0 |  | ENA |  | x
 | 8024 |  | 240061 | $2.20 or Index -$.05 | 5000 |  | ENA |  | x
 | 1266/1165 |  |  |  |  |  | HPLC
 |  |  |  |  | Less: Phillips {4.0/d}, [NAME] {0.0/d}, Texaco {10.0/d}
 |  |  |  |  | Third Party ( Sempra; 10.0/d )
 | NOTE:  Highlighted rows mean changes. |  |  |  | Note:   Channel / Syngas :    = 15.0/d
 | ***** | new deal per Janice @ Equistar eff. 2/1/01.
Spreadsheet: 98ae11be-624f-4bbf-8bcd-9f6a965f7604
Sheet: Loan Repayment Output

Table 7.2.  Year 1 Interest and Repayment
 | Funding Source | Total Funding Amount | Year 1 Principal Payment | Year 1 Interest Payment - Current Interest Rate | Year 1 Interest Payment - Worst-Case Interest Rate | Year 1 Total Payment - Current Interest Rate | Year 1 Total Payment - Worst Case Interest Rate
Main IFS Funding @ Current Interest Rate:
Funding 1:
Funding 2:
Funding 3:
Funding 4:
Funding 5:
 |  |  |  |  | Total Payment @ Current Interest Rate:
 |  |  |  |  | Total Payment @ Worst-Case Interest Rate:
aWorst case is an interest rate of 4%.  Applies to CWSRF, SRL, and SEL only.
Spreadsheet: 686844d1594832190-condtional-formatting-from-last-non-blank-cell-cf-client-hub_engagement_eh-1-aligw
Sheet: Client Data

 | Products |  |  |  |  |  |  | Display
Client | ACV | Renwal Date | Product Reviews | Brand Reviews | Dealership Reviews | AAO | Experiences | URL | Displaying Product Reviews | Displaying Brand Reviews | Displaying Dealership Reviews | Displaying AAO | Displaying Experiences | Stakeholders | Campaigns
Argyll Holidays | 24000 | 2020-12-30 00:00:00 | Yes | Yes | N/A | Yes | No | https://www.argyllholidays.com/ | TBC | TBC | TBC | TBC | TBC | TBC | TBC
[NAME] | 6000 | 2020-11-09 00:00:00 | Yes | Yes | N/A | TBC | TBC | https://www.box.co.uk/ | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Browne White Limited t/a ScotlandShop.com | 11642 | TBC | Yes | Yes | N/A | Yes | Yes | https://www.scotlandshop.com/ | TBC | TBC | TBC | TBC | TBC | TBC | TBC
CJ Wildlife | 12978 | TBC | Yes | Yes | N/A | TBC | TBC | https://www.birdfood.co.uk/ | TBC | TBC | TBC | TBC | TBC | TBC | TBC
[NAME] | 3969 | 2020-10-25 00:00:00 | Yes | Yes | N/A | TBC | TBC | https://www.cliftoncameras.co.uk/ | TBC | TBC | TBC | TBC | TBC | TBC | TBC
H. Garlick Ltd t/a ElectricaldiscountUK | 5985 | 2021-01-08 00:00:00 | Yes | Yes | N/A | No | TBC | https://www.electricaldiscountuk.co.uk/offers/ | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Holiday At Home Limited | 5040 | TBC | Yes | Yes | N/A | N/A | TBC | https://www.holidayathome.co.uk/ | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Hughes Electrical Direct | 8280 | TBC | Yes | No | N/A | No | TBC | https://www.hughes.co.uk/ | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Ingresso Group Limited | 3893 | 2020-10-19 00:00:00 | No | Yes | N/A | No | TBC | https://www.ingresso.co.uk/ | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Mattress Online.co.uk Limited | 10207 | 2020-11-19 00:00:00 | Yes | No | N/A | No | TBC | https://www.mattressonline.co.uk/ | TBC | TBC | TBC | TBC | TBC | TBC | TBC
[NAME] | 5019.29 | 2020-12-14 00:00:00 | Yes | Yes | N/A | TBC | TBC | https://www.you.gr/ | TBC | TBC | TBC | TBC | TBC | TBC | TBC
[NAME]'s Cottages | 15060 | TBC | Yes | Yes | N/A | N/A | No | https://www.sallyscottages.co.uk/ | TBC | TBC | TBC | TBC | TBC | TBC | TBC
 |  | NO GOOGLE SHOPPING ADDED
 |  | NO GOOGLE MY BUSINESS ADDED
 |  | aao not applicable for travel owners?
 |  | Dealership reviews same as branch reviews? (only applicable for auto?)
Spreadsheet: 833298d1686890212-find-two-columns-at-the-same-time-and-get-the-result-help
Sheet: Sheet1

Code1 | Code2 | Value | Country |  |  | Code1 | Code2
 | V044987 | A | USA |  |  |  | V044987 | A | USA |  |  | USA
 | V057144 | B | EURO |  |  |  | V057144 | B | EURO |  | B | EURO
 | V033696 | C | UK |  |  | A041135 | V005848 | A | Taiwan |  | A | Taiwan
 | V044792 | C | JAPAN |  |  | [NAME] |  | B | KOREA |  | B | KOREA
A041135 | V005848 | A | Taiwan |  |  |  | V062635 | B | Thailand |  | A | Thailand
[NAME] |  | B | KOREA
A083053 |  | Z | Finland
A105781 |  | B | Australia
A106458 |  | J | RUSIA
A106857 |  | H | India
A151831 | V062635 | A | Thailand
A110511 |  | B | Singapore
A118131 |  | K | CHINA
Spreadsheet: 93776d1293554130-match-function-sample
Sheet: Prov 1

Provider | 2009 Members | 2010 Members | Members Lost
Provider 1 | Adams, [NAME] | Afonin, Nadia | Adams, [NAME]
 | Afonin, Nadia | Agredano, [NAME] | Afonin, Nadia
 | Agredano, [NAME] | Aguilera, Lorraine D | Agredano, [NAME]
 | Aguilar, Nimrod A | Alacar, Jorge T | Aguilar, Nimrod A
 | Aguilera, [NAME] | Alacar, [NAME] | Aguilera, [NAME]
 | Aguirre, [NAME] | Aldrete, [NAME] | Aguirre, [NAME]
 | Aldrete, [NAME] | [NAME], [NAME] | Aldrete, [NAME]
 | [NAME], [NAME] | [NAME], [NAME] T | [NAME], [NAME]
 | [NAME], [NAME] | [NAME], [NAME] | [NAME], [NAME]
 | [NAME], [NAME] | [NAME], [NAME] | [NAME], [NAME]
 | [NAME], [NAME] | [NAME], Kimbrily | [NAME], [NAME]
 | Andalon, Christian O | Arballo, [NAME] T | Andalon, Christian O
 | [NAME], [NAME] | Arcinue, [NAME] | [NAME], [NAME]
 | Anguiano, [NAME] | Arismendez, Marcus | Anguiano, [NAME]
 | [NAME], Kimbrily | Armendariz, Julia | [NAME], Kimbrily
 | Aquino, [NAME] | [NAME], [NAME] R | Aquino, [NAME]
 | Arballo Ii, [NAME] T | [NAME], [NAME] | Arballo Ii, [NAME] T
 | Arellano, [NAME] | Arroyo, Victoria | Arellano, [NAME]
 | Arismendez, Marcus | Aviles, [NAME] | Arismendez, Marcus
 | Armendariz, Julia | Aviles, [NAME] | Armendariz, Julia
 | [NAME], [NAME] R | [NAME], Hope D | [NAME], [NAME] R
 | [NAME], [NAME] R | Ayala, [NAME] | [NAME], [NAME] R
 | [NAME], [NAME] | Ayala, Christine | [NAME], [NAME]
 | Arroyo, Victoria | Ayala, [NAME] | Arroyo, Victoria
 | [NAME], Lauren | [NAME], [NAME] | [NAME], Lauren
 | [NAME], [NAME] | Ballestero, Joselito S | [NAME], [NAME]
Spreadsheet: chris_stokley__3919__0301 EES Final
Sheet: Top

 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 4
 | Date Range | Use | Current |  |  |  |  |  |  |  |  | 51
 | Start Date: | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 |  |  |  |  |  |  |  |  | 54
 | End Date: | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 |  |  |  |  |  |  |  |  | 101
 | [NAME]: | False | False |  |  |  |  |  |  |  |  | 102
 |  |  |  |  |  |  |  |  |  |  |  | 103
 | Parameters | Pull1 | Pull2 | Pull3 |  |  |  |  |  |  |  | 111
 | Trans Type: | M |  |  |  |  |  |  |  |  |  | 112
 | Ledger Date: | 2001-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | 114
 | Multiplier: |  |  |  |  |  |  |  |  |  |  | 115
 |  |  |  |  |  |  |  |  |  |  |  | 116
 | Settlement Entity: | ISO |  |  |  |  |  |  |  |  |  | 151
 | Customer: | EES |  |  |  |  |  |  |  |  |  | 152
 | Auto Clear: | True |  |  |  |  |  |  |  |  |  | 153
 | Oracle DB: | ODBC;DSN=pwrprodn_ded;DBQ=pwrprodn_ded;UID[NAME]=mbennet_pc |  |  |  |  |  |  |  |  |  | 202
 | Database: | r:\enpowercaps\settle\isoandpx\settle.mdb |  |  |  |  |  |  |  |  |  | 203
 | Charge | False |  |  |  |  |  |  |  |  |  | 203
 | [NAME] | False |  |  |  |  |  |  |  |  |  | 252
 |  |  |  |  |  |  |  |  |  |  |  | 253
 |  |  |  |  |  |  |  |  |  |  |  | 256
 |  |  |  |  |  |  |  |  |  |  |  | 301
 |  |  |  |  |  |  |  |  |  |  |  | 303
 |  |  |  |  |  |  |  |  |  |  |  | 304
 |  |  |  |  |  |  |  |  |  |  |  | 351
 |  |  |  |  |  |  |  |  |  |  |  | 352
 |  |  |  |  |  |  |  |  |  |  |  | 401
 |  |  |  |  |  |  |  |  |  |  |  | 402
 |  |  |  |  |  |  |  |  |  |  |  | 403
 |  |  |  |  |  |  |  |  |  |  |  | 404
 |  |  |  |  |  |  |  |  |  |  |  | 405
 |  |  |  |  |  |  |  |  |  |  |  | 406
 |  |  |  |  |  |  |  |  |  |  |  | 487
 |  |  |  |  |  |  |  |  |  |  |  | 452
 |  |  |  |  |  |  |  |  |  |  |  | 521
 |  |  |  |  |  |  |  |  |  |  |  | 522
 |  |  |  |  |  |  |  |  |  |  |  | 523
 |  |  |  |  |  |  |  |  |  |  |  | 999
 |  |  |  |  |  |  |  |  |  |  |  | 1010
 |  |  |  |  |  |  |  |  |  |  |  | 1101
 |  |  |  |  |  |  |  |  |  |  |  | 1302
 |  |  |  |  |  |  |  |  |  |  |  | 1303
 |  |  |  |  |  |  |  |  |  |  |  | 1353
 |  |  |  |  |  |  |  |  |  |  |  | False
Spreadsheet: 628884e5-cb80-4f41-a5b1-1d5ff8d2322e
Sheet: Sheet1

CARROLL COUNTY OFFICES - Republican | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
2010-09-14 00:00:00 | Sheriff |  |  |  | Attorney
 | Conley, r | [NAME] | Lord, w-in | Others | Dewhurst, r | Gordon, d | Other
Albany | 26 | 27 | 17 | 0 | 53 | 5 | 1
[NAME] | 252 | 66 | 31 | 3 | 323 | 7 | 1
[NAME] | 117 | 2 | 2 | 0 | 107 | 0 | 0
Chatham | 21 | 1 | 2 | 0 | 27 | 0 | 0
Conway | 404 | 262 | 128 | 4 | 674 | 37 | 9
Eaton | 33 | 31 | 11 | 2 | 50 | 1 | 0
[NAME] | 88 | 18 | 15 | 0 | 109 | 0 | 1
Freedom | 170 | 44 | 28 | 3 | 213 | 9 | 0
Hale's Location | 39 | 12 | 8 | 0 | 56 | 1 | 0
Hart's Location | 2 | 0 | 0 | 1 | 3 | 0 | 0
[NAME] | 105 | 22 | 8 | 0 | 126 | 2 | 0
[NAME] | 161 | 83 | 50 | 1 | 239 | 13 | 4
Moultonborough | 704 | 8 | 71 | 3 | 763 | 3 | 0
Ossipee | 344 | 79 | 121 | 2 | 440 | 23 | 3
Sandwich | 195 | 10 | 8 | 0 | 202 | 2 | 0
Tamworth | 159 | 73 | 49 | 1 | 191 | 35 | 0
Tuftonboro | 422 | 15 | 9 | 1 | 404 | 5 | 1
Wakefield | 538 | 18 | 1 | 1 | 527 | 1 | 1
Wolfeboro | 1051 | 14 | 18 | 3 | 961 | 13 | 0
TOTALS | 4831 | 785 | 577 | 25 | 5468 | 157 | 21
 | Treasurer |  |  | Reg. of Deeds |  | Register of Probate
 | Widmer, r | [NAME], d | Others | Aiton, r | Others | [NAME], r | Hall, d | Others
Albany | 55 | 0 | 0 | 58 | 0 | 63 | 0 | 0
[NAME] | 305 | 0 | 0 | 313 | 0 | 320 | 3 | 0
[NAME] | 110 | 0 | 0 | 110 | 0 | 109 | 0 | 0
Chatham | 21 | 0 | 0 | 22 | 0 | 23 | 0 | 0
Conway | 637 | 0 | 1 | 688 | 1 | 699 | 1 | 0
Eaton | 58 | 0 | 0 | 59 | 0 | 61 | 0 | 0
[NAME] | 121 | 0 | 0 | 128 | 0 | 128 | 0 | 0
Freedom | 214 | 0 | 0 | 214 | 1 | 222 | 1 | 0
Hale's Location | 53 | 0 | 0 | 53 | 0 | 53 | 0 | 0
Hart's Location | 3 | 0 | 0 | 3 | 0 | 3 | 0 | 0
[NAME] | 132 | 0 | 0 | 138 | 0 | 130 | 0 | 0
[NAME] | 224 | 0 | 0 | 234 | 1 | 265 | 1 | 1
Moultonborough | 757 | 0 | 1 | 765 | 0 | 764 | 0 | 0
Ossipee | 454 | 1 | 0 | 493 | 1 | 499 | 20 | 1
Sandwich | 190 | 0 | 0 | 193 | 0 | 199 | 0 | 0
Tamworth | 221 | 0 | 1 | 234 | 0 | 235 | 0 | 0
Tuftonboro | 434 | 0 | 3 | 416 | 1 | 409 | 0 | 1
Wakefield | 522 | 0 | 1 | 531 | 0 | 526 | 1 | 3
Wolfeboro | 1001 | 0 | 1 | 994 | 1 | 995 | 0 | 1
TOTALS | 5512 | 1 | 8 | 5646 | 6 | 5703 | 27 | 7
CARROLL COUNTY OFFICES - Republican
2010-09-14 00:00:00 | County Commissioners
 | District No. 1 |  | District No. 2 | District No. 3
 | Sorensen, r | Others | NO ELECTION | Kenney, r | Albee, d | Others
Albany | 61 | 1 |  | 54 | 1 | 0
[NAME] | 319 | 0 |  | 298 | 2 | 1
[NAME] | 110 | 0 |  | 107 | 0 | 2
Chatham | 25 | 0 |  | 20 | 0 | 0
Conway | 706 | 4 |  | 632 | 2 | 3
Eaton | 64 | 0 |  | 51 | 0 | 0
[NAME] | 112 | 2 |  | 126 | 0 | 1
Freedom | 220 | 1 |  | 199 | 2 | 0
Hale's Location | 50 | 0 |  | 47 | 0 | 0
Hart's Location | 3 | 0 |  | 3 | 0 | 0
[NAME] | 128 | 1 |  | 117 | 0 | 0
[NAME] | 248 | 2 |  | 216 | 2 | 1
Moultonborough | 755 | 1 |  | 721 | 2 | 1
Ossipee | 461 | 2 |  | 436 | 2 | 2
Sandwich | 195 | 0 |  | 185 | 0 | 0
Tamworth | 237 | 1 |  | 216 | 1 | 1
Tuftonboro | 402 | 5 |  | 384 | 9 | 1
Wakefield | 517 | 2 |  | 489 | 1 | 10
Wolfeboro | 960 | 3 |  | 925 | 8 | 1
TOTALS | 5573 | 25 |  | 5226 | 32 | 24
Spreadsheet: darrell_schoolcraft__7300__imball0112
Sheet: WTGmktg

 | /------------------------------------------  contract 22100  --------------------------------------------------------\
 | 10811 |  | 13234 |  | 16540 |  | 500648
 | Follet |  | Oasis Dairy Farms |  | WTG/TW Winker |  | Sum WTG New Mex
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -107 | -150 |  |  | -778 | -1001 |  | -2
2 | -84 | -150 |  |  | -696 | -1001 |  | -2
3 | -57 | -150 |  |  | -532 | -1001 |  | -2
4 | -51 | -150 |  |  | -477 | -1001 |  | -2
5 | -79 | -150 |  |  | -615 | -1001 |  | -2
6 | -85 | -150 |  |  | -674 | -1001 |  | -2
7 | -106 | -150 |  |  | -853 | -1001 |  | -2
8 | -131 | -150 |  |  | -1037 | -1001 |  | -2
9 | -128 | -150 |  |  | -1118 | -1001 |  | -2
10 | -116 | -150 |  |  | -1121 | -1001 |  | -2
11 | -106 | -150 |  |  | -923 | -1001 |  | -2
12 | -126 | -150 |  |  | -1057 | -1001 |  | -2
13 | -147 | -150 |  |  | -1237 | -1001 |  | -2
14 | -125 | -91 |  |  | -1049 | -1001 |  | -2
15 | -108 | -91 |  |  | -939 | -1001 |  | -2
16 | -138 | -91 |  |  | -1275 | -1001 |  | -2
17 | -105 | -91 |  |  | -1083 | -1001 |  | -2
18 | -122 | -91 |  |  | -1008 | -1001 |  | -2
19 | -141 | -91 |  |  | -1118 | -1001 |  | -2
20 | -136 | -7 |  |  | -957 | -671 |  | 0
21 | -107 | -91 |  |  | -862 | -1001 |  | -2
22 | -135 | -91 |  |  | -1010 | -1001 |  | -2
23 | -166 | -91 |  |  | -1144 | -1001 |  | -2
24 | -161 | -91 |  |  | -1332 | -1001 |  | -2
25 | -178 | -91 |  |  | -1233 | -1001 |  | -2
26 | -141 | -91 |  |  | -1275 | -1001
27 | -144 | -91 |  |  | -1406 | -1001
28 | -160 | -91 |  |  | -1105 | -1001
29 | -193 | -91 |  |  | -1279 | -1001
30 | -190 | -91 |  |  | -1541 | -1001
31 | -175 | -91 |  |  | -1547 | -1001
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  | -40029.08
2001-12-31 00:00:00
CBS Volume
 |  |  | -5429
Spreadsheet: 121714d1316325649-dget-formula-returns-num-error-i-verified-no-duplicates-dget-error-3
Sheet: DGET

 | THIS RESULT WORKS
ProdType | StudGrade | NutGrade | measuresystem | baseunit | [NAME] | length | partnum | lastlaborcost | lastburdencost | lastmaterialcost | lastsubcontcost | lastmtlburcost
BAR-NOMINAL | 660B |  | IMP | IN | 0.375 |  | BNI0B660000003700GRB | 0 | 0 | 0 | 0 | 0
 | THIS RESULT DOES NOT WORK. WHY? ONLY ONE RECORD ON THE NAMED RANGE MATCHES THESE CRITERIA.
ProdType | StudGrade | NutGrade | measuresystem | baseunit | [NAME] | length | partnum | lastlaborcost | lastburdencost | lastmaterialcost | lastsubcontcost | lastmtlburcost
BAR-NOMINAL | 660B |  | IMP | IN | 1.375 |  | BNI0B660000013700GRB | 0 | 0 | 59.49945 | 0 | 0
Spreadsheet: 90d2f6e9-de52-47c2-bb18-278ae343e8a0
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3707 | 17122 | Isai | [NAME] | VEN
3707 | 17123 | [NAME] | Fischer | VEN
3707 | 22165 | [NAME] | Villalta | VEN
Spreadsheet: 742221d1627592326-get-calculations-to-spill-along-with-the-filtered-or-uniqued-data-samplez-tms-v2
Sheet: Main Sheet (TMS)

 | SIT. |  | Check | CURRENT | Balance |  |  |  |  |  | FLEET | Code | LOC
AAB111 |  |  |  |  |  |  |  |  |  |  | BHF321 | 21
ADB153 |  |  | SOLD | CLD589 | 0 |  |  |  |  |  | CLD589 | 84
ACF458 |  |  | SOLD | CFY414 | 0 |  |  |  |  |  | CFY414 | 95
BND225 |  |  | KEEP | EFS309 | 10 |  |  |  |  |  | EFS309 | 11
BHF321 |  |  | - | TMS | 0
BGH854
CLD589
CFY414
DDE220
EFS309
TMS
Spreadsheet: 132573d1323821321-pdf-text-to-excel-spreadsheet-travelleisure
Sheet: Page_1

 |  |  |  | Media Outlet Results
Outlet Name | Outlet City | Outlet State | Outlet Type  Outlet Website |  |  | Outlet E-mail |  | Outlet Phone Number Outlet Circulation Keyword Outlet Source  AudienceRelevance
[NAME] | Honolulu | HI | [NAME] |  | http://www.h |  |  | (808) 524-7400 | 870,000 | 58 | S
Guide |  |  | zine, |  | onolulupubli
 |  |  | consu |  | shing.com/
 |  |  | [NAME]
National | Washington | DC | [NAME] |  | http://www.n | traveler@ng |  |  | 725,106 | 49 | S
Geographic |  |  | zine, |  | ationalgeogr | s.org
Traveler |  |  | consu |  | aphic.com/tr
 |  |  | [NAME] |  | aveler/
Southwest | Dallas | TX | [NAME] |  | http://www.s |  |  | (214) 580-8070 | 462,788 | 43 | S
Airlines Spirit |  |  | zine, |  | piritmag.co
 |  |  | consu |  | m
 |  |  | [NAME]
Travel + | New York | NY | [NAME] |  | http://www.tr | editorial@tr |  | (212) 382-5684 | 400,000 | 58 | S
Romance |  |  | zine, |  | avel- | avel-
 |  |  | consu |  | romance.co | romance.co
 |  |  | [NAME] |  | m | m
M: The Lifestyle | San Diego | CA | [NAME] |  | [NAME]. | pgotfred@c |  | (858) 642-2820 | 356,000 | 16 | S
Magazine of |  |  | zine, |  | mlifestyle.co | ustompublis
MGM Mirage |  |  | consu |  | m/ | [NAME]
 |  |  | [NAME] |  |  | om
Official Guide to | Houston | TX | [NAME] |  | http://www.h | houstongde |  | (713) 942-2222 | 330,000 | 20 | S
Houston, The |  |  | zine, |  | ouston- | @aol.com
 |  |  | trade/ |  | guide.com
 |  |  | indust
 |  |  | ry
enRoute | Montréal | QC | [NAME] |  | [NAME] |  |  |  | 190,000 | 23 | S
Magazine |  |  | zine, |  | e.aircanada.
 |  |  | consu |  | com/
 |  |  | [NAME]
Las Vegas | Las Vegas | NV | News |  | http://www.l | letters@revi |  | (702) 383-0211 | 175,000 | 1 | S
Review-Journal |  |  | paper |  | [NAME] | ewjournal.c
 |  |  |  |  |  | om
Page: 1 |  |  |  |  |  |  |  |  |  |  | 12/13/2011
Spreadsheet: 850551d1700916096-help-to-identify-needed-formula-and-functions-and-how-to-copy-specified-column-cells-test-sheet-3
Sheet: Search Tab

 | Warehouse: | WH#1 | Search For: |  | Inventory
 |  |  |  |  |  |  |  |  |  |  | Cell: C1 is manual input to define which Warehouse the search is valid for. (column that contains  the name of Warehouse is column  L & M
 | Part no: | Shelf no: | Application: | Length: | ODD : | Shape: | Owner: | Amount/WH#: | Comments:
 |  |  |  |  |  |  |  |  |  |  | Cell: F1 is manual input to define what i want to look for, corresponding to the specified warehouse
 |  |  |  |  |  |  |  |  |  |  | If cell C1 = "WH#1" and cell F1 = "Inventory", then it should find the rows in column L containing WH#1 with numbers before the "/" (example: 23/WH#1-OK) copy/paste  values from "Master" sheet column: B(B),C(C),F(D),G(E),H(F),I(G),J(H),L(I) & P(J), and arrange in decending order. (destination cells are the red in brackets)
 |  |  |  |  |  |  |  |  |  |  | If cell C1 = "WH#1" and cell F1 = "Orders", then it should find the rows in column M containing WH#1 with numbers before the "/" (example: 28/WH#1) copy  values from "Master" sheet column: F(D),G(E),H(F),I(G),J(H),M(I) & P(J),and arrange in acending order.
Spreadsheet: 118bad71-2512-4a8d-bdd5-669aa986ca4e
Sheet: Sheet1

2013 NPNSG Schedule
2012-03-29 00:00:00 |  |  |  | Contract Due
2012-03-07 00:00:00 |  |  |  | Contracts Written (March 1 through December 31)
2012-03-04 00:00:00 |  |  |  | Grant description to [NAME] to Start Council Approval Process
2012-03-01 00:00:00 |  |  |  | [NAME]
 | 2012-02-28 00:00:00 |  |  | Committee 2nd Mtg (if necessary)
 | 2012-02-18 00:00:00 |  |  | Committee 1st Mtg
 | 2012-02-01 00:00:00 |  |  | Grants Emailed to Committee (two weeks to score grants)
2012-01-31 00:00:00 |  |  |  | Applications Due (2 pm)
2012-01-24 00:00:00 |  |  |  | Due Date Reminder
2012-01-10 00:00:00 |  |  |  | Due Date Reminder
 |  | 2012-12-10 00:00:00 |  | Announce New Committee Members & set up individual orientation
2012-12-03 00:00:00 |  |  |  | 3rd Announcement Reminder
 |  | 2012-11-26 00:00:00 |  | Committee Applications Due/Applications out to readers
 |  | 2012-11-01 00:00:00 |  | Select readers
 |  | 2012-10-23 00:00:00 |  | Announce Committee Openings/Recruit Members
2012-10-23 00:00:00 |  |  |  | Workshop
2012-10-09 00:00:00 |  |  |  | 2nd Announcement/Reminder
2012-09-13 00:00:00 |  |  |  | [NAME] (emails, letters, and posters, metro list?)/sign -up for Workshop
Spreadsheet: 198373d1354750551-automatic-vertical-alignment-of-multiple-cells-into-a-single-cell-forum-upload
Sheet: Plotting

 | Record # | [NAME] (ft) | Depth (ft) | X Coor (ft) | Y Coor (ft) | X Coor (ft) | Y Coor (ft) | X Coor (ft) | Y Coor (ft) | X Coor (ft) | Y Coor (ft) | X Coor (ft) | Y Coor (ft) | C1 | C2 | [NAME] | C4 | C5 |  | Desired Output
 | 1 | 13.5 | 10 | 44.5 | 20 | 58 | 20 | 58 | 30 | 44.5 | 30 | 44.5 | 20 | 44.5 20 | 58 20 | 58 30 | 44.5 30 | 44.5 20 |  | 44.5 20  58 20  58 30  44.5 30  44.5 20
 | 2 | 8 | 3 | 125 | 2 | 133 | 2 | 133 | 5 | 125 | 5 | 125 | 2 | 125 2 | 133 2 | 133 5 | 125 5 | 125 2 |  | 125 2  133 2  133 5  125 5  125 2
 | 3 | 6 | 5 | 119 | 2 | 125 | 2 | 125 | 7 | 119 | 7 | 119 | 2 | 119 2 | 125 2 | 125 7 | 119 7 | 119 2 |  | 119 2  125 2  125 7  119 7  119 2
Spreadsheet: 719472d1613674236-sumifs-formula-not-valid-value-hh_job_-template_2021-1-
Sheet: Bonus WK 3

 | Week 3 - Bonus Hours
 | Begin Date:
 | End Date:
 | Employee | Bonus Hours
Spreadsheet: 116023d1311506325-selective-columns-marcol
Sheet: si

Sweeney. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 329048d1404179573-locating-compensating-negatives-comp-negs
Sheet: Sheet1

REF | [NAME] | B1 | B2 | B3
 |  | 25 | -19 | 3.13 | FALSE
 |  | 0 | 0 | 0 | FALSE
 |  | 0 | 0 | 1 | TRUE | wrong 1
 |  | 0 | 3 | 0 | TRUE | wrong 2
 |  | 0 | 0 | 0 | FALSE
 |  | 0 | 0 | 0 | FALSE
 |  | 43 | 5 | -43 | TRUE
 | Notes :
 | .. =IF(SUMPRODUCT(--(D2:E2=-C2))=1,"TRUE","FALSE")
 | Works perfect except its picking true on 0 and 0 , see wrong 2
Spreadsheet: 98751d1297618257-calculating-random-numbers-random-lottery
Sheet: Sheet1

Cum Sum of Chances | Frequency (Given) | Amount (Given) | The random ticket | The Winnings
0 | 1 | 2500000
2.390903091915879e-06 | 1 | 1000000
4.781806183831757e-06 | 5 | 250000
1.673632164341115e-05 | 1 | 200000
1.912722473532703e-05 | 2 | 100000
2.390903091915878e-05 | 2 | 20000
2.869083710299054e-05 | 40 | 10000
0.0001243269607796257 | 140 | 2000
0.0004590533936478486 | 210 | 1000
0.0009611430429501831 | 150 | 750
0.001319778506737565 | 200 | 500
0.001797959125120741 | 500 | 250
0.00299341067107868 | 450 | 200
0.004069317062440825 | 1250 | 150
0.007057945927335673 | 9400 | 100
0.02953243499134493 | 29800 | 75
0.1007813471304381 | 209100 | 50
0.6007191836500483 | 167000 | 25
1
 |  |  | Sum of the winnings:
Assumptions:
1. you always win something
2. random number is generated, between 0 and 1 (infinite possibilities). The frequency of getting $25 is 167000/418252 which is ~40%. So, all numbers between .6 and 1 would yield $25