tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2af1821b-6dc6-402b-b619-4c56f007c848
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-07-05 09:17:05.900000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.657 | 101.532 | 101.407 | 101.032
3.75 | 100.721 | 100.596 | 100.471 | 100.096 |  | Note: | Refer To Price [NAME]
3.625 | 100.473 | 100.348 | 100.223 | 99.848 |  |  | For all Price Adjs
3.5 | 99.873 | 99.748 | 99.623 | 98.998
3.375 | 98.986 | 98.861 | 98.736 | 98.111
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.73 | 101.605 | 101.48 | 101.105
3.25 | 101.199 | 101.074 | 100.949 | 100.574
3.125 | 100.865 | 100.74 | 100.615 | 100.24
3 | 100.538 | 100.413 | 100.288 | 99.913
2.875 | 99.955 | 99.83 | 99.705 | 99.08
2.75 | 99.277 | 99.152 | 99.027 | 98.402
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-07-19 09:17:05.900000
30 DAY | 2012-08-03 09:17:05.900000
45 DAY | 2012-08-18 09:17:05.900000
60 DAY | 2012-09-02 09:17:05.900000
90 DAY | 2012-10-02 09:17:05.900000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 108495d1305563958-ranking-data-with-multiple-criteria-example
Sheet: Sheet1

PROBLEM 1
grouping |  | [NAME] to min | [NAME] to min | min to [NAME]
 |  |  |  |  | my formula to rank by A | my formula to rank by B | my forumula to rank by C (Doesn't work)
Category | Item | Rating A | Rating B | Rating C
1 | Item 1 | 1 | 1 | 72.5
1 | Item 2 | 1 | 1 | 75
1 | Item 3 | 2 | 1 | 66
1 | Item 4 | 2 | 2 | 198
2 | Item 1 | 1 | 2 | 85.66666666666667
4 | Item 1 | 3 | 2 | 112.8
4 | Item 2 | 6 | 3 | 250.7777777777778
6 | Item 1 | 6 | 3 | 94.55555555555556
6 | Item 2 | 8 | 4 | 283.8333333333333
10 | Item 1 | 5 | 4 | 457.5555555555555
10 | Item 2 | 8 | 5 | 1267.230769230769
12 | Item 1 | 9 | 7 | 1077.875
16 | Item 1 | 9 | 6 | 353.2
18 | Item 1 | 11 | 7 | 303.8888888888889
20 | Item 1 | 13 | 9 | 338.0909090909091
20 | Item 2 | 15 | 15 | 991.7666666666667
23 | Item 1 | 9 | 10 | 458.1578947368421
23 | Item 2 | 17 | 13 | 1160.733333333333
25 | Item 1 | 8 | 11 | 469.2631578947368
PROBLEM 2
grouping |  | [NAME] to min | min to [NAME]
Category | Item | Rating A | Rating C
1 | Item 1 | 1 | 72.5
1 | Item 2 | 1 | 75
1 | Item 3 | 2 | 66
1 | Item 4 | 2 | 198
2 | Item 1 | 1 | 85.66666666666667
4 | Item 1 | 3 | 112.8
4 | Item 2 | 6 | 250.7777777777778
6 | Item 1 | 6 | 94.55555555555556
6 | Item 2 | 8 | 283.8333333333333
10 | Item 1 | 5 | 457.5555555555555
10 | Item 2 | 8 | 1267.230769230769
12 | Item 1 | 9 | 1077.875
16 | Item 1 | 9 | 353.2
18 | Item 1 | 11 | 303.8888888888889
20 | Item 1 | 13 | 338.0909090909091
20 | Item 2 | 15 | 991.7666666666667
23 | Item 1 | 9 | 458.1578947368421
23 | Item 2 | 17 | 1160.733333333333
25 | Item 1 | 8 | 469.2631578947368
Spreadsheet: 59111d1259580626-collect-and-sort-data-examplespreadsheet
Sheet: Sheet1

Results are sent like this…
Sales Representative | Score | Date Completed | Collection Point | Product Type | Product Category
Staff 1 | 100 | 2009-11-29 11:02:00
Staff 2 | 70 | 2009-11-27 16:01:00
Staff 2 | 80 | 2009-11-27 16:01:00
Staff 4 | 93.33 | 2009-11-27 12:30:00
Staff 4 | 100 | 2009-11-27 10:39:00
Staff 3 | 45 | 2009-11-26 10:50:00
Staff 2 | 80 | 2009-11-25 13:50:00
Staff 3 | 90 | 2009-11-24 09:41:00
Staff 4 | 100 | 2009-11-23 16:50:00
I would like it so a staff member can pick their name from a drop down list which I can do
Like this…
Staff 2 picks their name…
Staff 2 | 70 | 2009-11-27 16:01:00
Staff 2 | 80 | 2009-11-27 16:01:00
Staff 2 | 80 | 2009-11-25 13:50:00
Thanks
Spreadsheet: 799205d1664982581-normalize-space-in-filterxml-gk
Sheet: Sheet2

Address /contact details | Address /contact details | Expected Answer | Expected Answer | Expected Answer
POST BOX # 119311 -TEL: +971 04 8842242 | TEL: +971 04 8942240 ,PH: 971 11 2939763 , FAX: 971 04 2959763 |  | 971 04 8942240 | 971 11 2939763
POST BOX # 118887 | PH: 971 04 8329811 , FAX: 971 04 8329211
BILL TO:EMAAR BUSINESS PARK-SHK ZAYED RD | TEL: +971 04 4430035 - FAX: +971 04 4432421
POST BOX # 45200 | PH: 971 02 6979444 , PH: 971 02 6443989,FAX: 971 02 6979085 |  | 971 02 6443989
TEL: +971 04 8142322 | FAX: +971 04 -PH: 971 02 6979444 |  | 971 02 6979444
Spreadsheet: 186420d1350036886-search-beers
Sheet: O

Brewery |  | Beer
Oak |  | [NAME]
 |  | Best Bitter
 |  | Porter
 |  | Old Oak Ale
 |  | Wobbly Bob
Oakham |  | Cold Turkey
 |  | [NAME]
 |  | [NAME]
 |  | White Dwarf
 |  | Mompessons Gold
Oakhill |  | Black Magic Stout
 |  | Yeoman Strong Ale
Okells |  | Bitter
 |  | Mild
 |  | 45
 |  | [NAME]
 |  | [NAME]
 |  | Summer Storm
Old Bear |  | Estivator
Old Chimneys |  | Military Mild
Old Cottage |  | Cottage Pride
Oldershaw |  | Old Boy
Old Forge |  | Pett Progress
Old Laxey |  | [NAME]
Old Mill |  | Traditional Mild
 |  | Traditional Bitter
 |  | Bullion
Old School Brewery
[NAME] |  | Raven ale
 |  | Dark Island
 |  | Dragon Head Stout
 |  | Red McGregor
Ossett |  | Silver King
 |  | Mistral
 |  | [NAME]
 |  | Excalibur
Otter |  | Ale
 |  | Bitter
Outlaw |  | Zulu ( [NAME] )
 |  | Mayflower
 |  | Amarillo
 |  | [NAME]
Spreadsheet: theresa_staab__39601__MTG email
Sheet: Summary

 |  | [NAME] To: |  |  | Remit To:
 |  |  |  |  |  | Copy to: | Verification Date:
 |  | Enron North America Corp. |  |  | MTG Operating Company |  | 2001-12-14 00:00:00
 |  |  |  |  | Bank: Deposit Guaranty National
 |  |  |  |  | ABA:  065305436 |  | Due Date:
 |  |  |  |  | Acct: [PHONE] |  | 2001-10-31 00:00:00
 |  | Contact:  [NAME] |  |  | Contact:  [NAME] | Contact:  [NAME]
 |  | Tel:  (303) 575-6485 |  |  | Tel:  (307) 684-0964 | Tel:  (601) 956-9851 | Payment Method:
Enron North America Corp. |  | Fax: (303) 534-0552 |  |  | Fax:  (307) 684-0966 | Fax: (601) 956-9580 | Wire - Last Day of Month
2001-12-14 11:00:29.810000
Delivery Period: | Contract # | Meter # / Meter Name
2001-11-01 00:00:00 | 96028270 | 0814041 - MTG Compressor 48N 72W SEC32
 | Index | Discount / Premium | Price/MMBtu | Mcf Quantity | MMBtu Quantity |  | Amount Due
11/01/01 - 11/30/01 | CIG GD | -0.4805 | 0 | 5259.772486772487 | 4881 |  | 5762.749500000001
11/01/01 - 11/30/01 | IF CIG - Rockies | -0.4805 |  | 7545.36507936508 | 7002 |  | 14420.619
11/01/01 - 11/30/01 |  | Fuel Loss | $             0.00 | 25.86243386243386 | 24 |  | $                                        0.00
11/01/01 - 11/30/01 |  |  |  | 12831 | 11907 |  | 20183.3685
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 | Hannover Compression Charges not recovered in netback purchase
 | Prior Month Adjustments
 |  |  |  |  |  | Adjustment | 0
 |  |  | TOTAL PAYMENT |  |  |  | 20183.3685
Spreadsheet: 145148d1331316778-combine-formulas-book-2
Sheet: working

[NAME] | $ | Code | Description 1 | Description 2
NT | 16.93 | PLA
NT | 24.82 | PLA
NT | 19.38 | PLA
NT | 25.33 | PLA
T | 80 | PNC
T | 26.15 | PNC
T | 679.14 | UNC
NT | 85 | EMD |  | OCCUPATIONAL CLOTHS
NT | 85 | EMD |  | Training for junior
NT | 4.88 | TMD |  | for dse purpose
 | -111.03 | EMD | [NAME] | [NAME]
NT | 5.7 | TFG | small gift | small gift
NT | 36.68 | TFG | small gift | flowers
NT | 36.72 | TFG | small gift | flowers
 | 40 | TMD |  | flowers for staff
T | 55.5 | TFG | award | flowers
T | 55.5 | TFG | award | flowers
T | 505.58 | TFG | award | flowers
T | 100 | TFG |  | leaving soon
NT | 505.58 | TFG |  | Long service award
NT | 505.58 | TFG |  | 25 year service
T | 958 | TFG | xmas | xmas
 | 140 | [NAME] | ball | for spot
T | 260 | [NAME] | chair | for home use
 | 105.88 | [NAME] | award | Safety
NT | 45.85 | [NAME] | small gift | Thank you present
T | 150 | SEM |  | spot bonus
 | 32 | SEM |  | meeting lunch with friend
T | 41.78 | SEM |  | late working
 | 10.8 | SEM |  | award
 | 133.89 | SEM |  | complementary meal
NT | 6.49 | SEM |  | Conference:  meal
NT | 13.2 | SEM |  | EXAM fees paid
T | 79.25 | SEM |  | cost incurred for Entertaining Visitor
NT | 62.06 | OSM | cpa subscription
 | 69.38 | OSM | bank fees
NT | 9.81 | OSM | Online 'drop box' service
T | 11.25 | XTO | CAKE FOR CHILDREN | CAKE
NT | 104.8 | XTO | purchase stationary
T | 31 | XTO | Childcare
 | 74.4 | XTO | BUY flowers to visit [NAME]
NT | 122.4 | XTO | parking fees
 | 30 | XTO | buy chocolate
NT | 3.19 | XTO | conference meeting room
NT | 102.24 | LHP |  | Business Phone calls and e-mails
 | 12.16 | LHP |  | Telecoms
NT | 123 | [NAME] | BOX FOR STORAGE PURPOSE
 | 453 | [NAME] | [NAME] and manicure
NT | 200 | RAU | lunch | lunch
T | 750 | RAU | lunch | lunch
Spreadsheet: 88703d1288562686-if-the-import-test
Sheet: Door Styles

Ancestral Rope
[NAME]
[NAME]
Chocolate Maple
Chocolate Shaker
[NAME]
Crystal Maple
Elite Cinnamon Glaze
Elite Merlot Glaze
Espresso
French Antique
[NAME]
[NAME]
[NAME]
[NAME] Glaze
Heritage Birch
Heritage Toffee
Heritage white
Hickory Cathedral
[NAME]
Landmark Birch Brandy
Landmark Birch Natural
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
New Yorker
[NAME]
Premier [NAME]
Provicial Autumn
Raised Panel Coffee
Rope - Dark Glaze
SandStone Rope
Santa Fe
Savannah
[NAME]
[NAME]
[NAME]
[NAME]
Shaker Spice
Shakertown
[NAME]
[NAME]
[NAME]
[NAME]
Wavehill
[NAME]
Wellington Ivory Glaze
Wellington Spice Glaze
Spreadsheet: shelley_corman__38749__Cashinoutmajorityminority
Sheet: Dec 2000

December 2000 Production Month
Cash In\Out After Bookout | 21 | Majority is Due Shippers
 | 19 | Minority is Due FGT
le_nm | [NAME] | inv_amt | sum_mmbtu_qty
ALABAMA POWER COMPANY | CIO | -4974.58 | -689
ALUMINUM COMPANY OF AMERICA | CIO | -18893.3 | -3271
ASHLAND CHEMICAL COMPANY | CIO | -2837.46 | -393
BP ENERGY COMPANY | CIO | -86.64 | -12
CITRUS TRADING CORPORATION | CIO | -17104.18 | -2369
CLARKE-MOBILE COUNTIES GAS DISTRICT | CIO | -302780.81 | -46596
DUKE ENERGY TRADING AND MARKETING,L.L.C. | CIO | -9505.76 | -1450
EL PASO MERCHANT ENERGY, L.P. | CIO | -20237.66 | -2803
ENRON NORTH AMERICA CORP. | CIO | -114808.19 | -15780
FLORIDA GAS UTILITY | CIO | -143844.06 | -19923
FLORIDA POWER AND LIGHT COMPANY | CIO | -806538.98 | -111709
HOUSTON PIPE LINE COMPANY | CIO | -127887.86 | -17713
LAFARGE GYPSUM | CIO | -7.22 | -1
LAKELAND, CITY OF | CIO | -432480.89 | -66556
NATIONAL GYPSUM COMPANY | CIO | -65623.3 | -10099
NUI CORPORATION | CIO | -1205.74 | -167
ORLANDO COGEN FUEL, INC | CIO | -103469.82 | -14331
ORLANDO UTILITIES COMMISSION | CIO | -7068.38 | -979
PEOPLES GAS SYSTEM, A DIVISION OF TAMPA | CIO | -618501.3 | -85665
RELIANT ENERGY SERVICES, INC. | CIO | -14967.06 | -2073
SOUTH FLORIDA NATURAL GAS, INC. | CIO | -9623.54 | -1481
Total Due 21 Shippers
ADAMS RESOURCES MARKETING, LTD. | CIO | 8600.16 | 1104
ANHEUSER BUSCH COMPANIES, INC | CIO | 1815.07 | 233
AUBURNDALE POWER PARTNERS, L.P. | CIO | 3466.55 | 445
CARGILL FERTILIZER,  INC | CIO | 7.79 | 1
CF INDUSTRIES,  INC | CIO | 82.1 | 10
CHESAPEAKE UTILITIES CORPORATION | CIO | 83610.07 | 10733
CINERGY MARKETING & TRADING, LLC | CIO | 32325.18 | 3429
COASTAL MERCHANT ENERGY, L.P. | CIO | 37032.16 | 4467
CORAL ENERGY RESOURCES, L.P. | CIO | 38.95 | 5
DYNEGY GAS TRANSPORTATION, INC. | CIO | 12822.71 | 1642
[NAME], L.P. | CIO | 180.69 | 22
FLORIDA POWER CORPORATION | CIO | 38.95 | 5
FLORIDA PUBLIC UTILITIES COMPANY | CIO | 7.79 | 1
INFINITE ENERGY, INC. | CIO | 270067.25 | 34639
NOBLE GAS MARKETING, INC. | CIO | 15.58 | 2
ONYX GAS MARKETING COMPANY, L.C. | CIO | 241.49 | 31
PRIOR INTRASTATE CORPORATION | CIO | 333913.56 | 42528
SOUTHEAST ALABAMA GAS DISTRICT | CIO | 164392.14 | 21087
TALLAHASSEE, CITY OF | CIO | 7.79 | 1
Total Due FGT  19 shippers
Spreadsheet: 702150d1604113248-minimum-route-using-solver-route-example
Sheet: Planilha1

 |  | 1 | 2 | 3 | 4
 |  | A | B | C | D
1 | A | 0 | 2 | 1 | 4
2 | B | 2 | 0 | 5 | 3
3 | C | 1 | 5 | 0 | 9
4 | D | 4 | 3 | 9 | 0
 |  | 1 | 2 | 3 | 4 | 1
 | Route
 | Total route
Spreadsheet: 83785d1283842747-want-to-calculate-8-hours-as-one-working-day-off-set
Sheet: Sheet1

 |  |  | OFF SET BALANCE SHEET
 | Effective |  | March 17 - July 19 , 2010
 | Sr. No. | Names | Previous Balance | Public Holidays | Cancelled Off | Extra Hours | Under Time | Off Sets | Total Balance
 | 1 | xxx | 28 Days and 4 Hrs | 1 day |  | 4 hours |  |  | sum of blue cells and minus yellow cells
 | 2 | yyy | 20 days and 2 hrs | 1 day |  | 1 hr | 5 hrs | 1 day | 19 days 6hrs
 | 3 | zzz | 4 days and 5.5 hours | 1 day |  | 6.5 hrs | 21.5 hrs
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
Spreadsheet: kate_symes__18456__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-01-12 00:00:00 |  | 167.65 | 544 | 116 | 2136
 | 2001-01-11 00:00:00 |  | 159.09 | 704 | 116 | 2136 | 147.18 | 1708 | 100.51 | 774
 | 2001-01-10 00:00:00 |  | 150 | 960 | 94.32 | 2280 | 140.57 | 584 | 101.31 | 555
 | 2001-01-09 00:00:00 |  | 127.81 | 1024 | 77.19 | 912 | 156.86 | 390 | 88.91 | 1464
 | 2001-01-08 00:00:00 |  | 132.55 | 1024 | 76.1 | 912 | 127.42 | 1330 | 71.95 | 583
 | 2001-01-07 00:00:00 |  | 115 | 0 | 62.5 | 0 | 63.78 | 2249 | 57.2 | 1278
 | 2001-01-06 00:00:00 |  | 124.17 | 384 | 93.8 | 432 | 102.76 | 521 | 66.24 | 647
 | 2001-01-05 00:00:00 |  | 136.45 | 1216 | 93.11 | 528 | 129.45 | 1527 | 123.46 | 455
 | 2001-01-04 00:00:00 |  | 146.87 | 2016 | 88.03 | 912 | 125.05 | 1851 | 107.45 | 778
 | 2001-01-03 00:00:00 |  | 145.65 | 544 | 75.2 | 32 | 125.71 | 1965 | 99.79 | 652
 | 2001-01-02 00:00:00 |  | 151.43 | 224 | 80 | 32 | 120.29 | 1597 | 76.99 | 944
 | 2001-01-01 00:00:00 |  |  |  |  |  | 102.04 | 432 | 64.43 | 628
 | 2000-12-31 00:00:00 |  |  |  |  |  | 73.65 | 2126 | 66.14 | 1101
 | 2000-12-30 00:00:00 |  | 118.57 | 224 | 75 | 32 | 103.71 | 1824 | 100.69 | 360
 | 2000-12-29 00:00:00 |  | 140 | 64 | 103.1 | 232 | 139.65 | 2163 | 106.37 | 925
 | 2000-12-28 00:00:00 |  | 140 | 64 | 103.1 | 232 | 130.72 | 830 | 120.35 | 1115
 | 2000-12-27 00:00:00 |  | 200 | 64 | 160 | 200 | 121.92 | 1931 | 94.63 | 1065
 | 2000-12-26 00:00:00 |  | 275 | 64 | 203.1 | 232 | 124.96 | 2250 | 71.81 | 666
 | 2000-12-25 00:00:00 |  | 265 | 0 | 210 | 200 | 99.62 | 1532 | 62.74 | 155
 | 2000-12-24 00:00:00 |  | 265 | 0 | 210 | 200 | 131.21 | 1155 | 50.53 | 582
 | 2000-12-23 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 285 | 0 | 215 | 0
 | 2000-12-22 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 299 | 25 | 215 | 0
 | 2000-12-21 00:00:00 |  | 291.55 | 464 | 216.99 | 512 | 189.32 | 2060 | 171.06 | 292
 | 2000-12-20 00:00:00 |  | 275 | 0 | 212.86 | 280 | 214.57 | 1110 | 161.24 | 218
 | 2000-12-19 00:00:00 |  | 265.68 | 1180 | 201.43 | 280 | 194.39 | 1310 | 178.74 | 855
 | 2000-12-18 00:00:00 |  | 236.9 | 1680 | 190.62 | 960 | 223.03 | 852 | 172.62 | 525
 | 2000-12-17 00:00:00 |  | 215 | 800 | 200 | 200 | 173.03 | 1450 | 148.06 | 1255
 | 2000-12-16 00:00:00 |  | 275 | 480 | 210 | 400 | 183.11 | 2287 | 181.95 | 535
 | 2000-12-15 00:00:00 |  | 275 | 480 | 210 | 400 | 187.75 | 2655 | 153.05 | 1714
 | 2000-12-14 00:00:00 |  | 327.14 | 560 | 226 | 600 | 186.36 | 2035 | 170.6 | 1669
 | 2000-12-13 00:00:00 |  | 497.86 | 448 | 237.79 | 704 | 287.91 | 1278 | 165.71 | 1791
Spreadsheet: 78479d1278867098-formatting-cells-based-on-other-cell-values-finance-spreadsheet-v2
Sheet: All History

 | Transaction
Date (dd/mm/yy) | In (£) | Out (£) | Details/Description | Previous Balance (£) | Current Cleared Balance(£)
2010-06-01 00:00:00 | 20
2010-06-07 00:00:00 | 62
2010-06-11 00:00:00 |  | 59.6
2010-06-14 00:00:00 |  | 1.07
2010-06-14 00:00:00 |  | 7.49
2010-06-15 00:00:00 | 25
2010-06-16 00:00:00 |  | 1
2010-06-21 00:00:00 |  | 10
2010-06-21 00:00:00 |  | 7.47
2010-06-25 00:00:00 | 15 | 0
Spreadsheet: 833463d1686986190-retrieve-all-info-from-source-data-for-all-matches-from-list-find-all-matches
Sheet: Names

[NAME]
[NAME]
Spreadsheet: 139cd688-6454-4d10-b58d-2305339d489c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | Inschrijfformulier deelname Best practice award FMN 2012
 | 1 | Naam deelnemende organisatie
 |  | Adres
 |  | Postcode; vestigingsplaats
 | 2 | Naam vertegenwoordiger
 |  | Functie vertegenwoordiger
 |  | Telefoonnummer
 |  | E-mailadres
 | 3 | Naam/namen van eventuele andere organisatie(s)
 |  | waarmee is samengewerkt.
 | 4 | [NAME] ([NAME]. 10 woorden)
 | 5 | Korte beschrijving ([NAME]. 3 A4-tjes)
 | 6 | Waarom denkt u in aanmerking te komen voor de
 |  | Best Practice Award?
 | 7 | [NAME] is het vernieuwende element?
 | 8 | Hoe vernieuwend is dit ten opzichte [NAME] bestaande situatie?
 | 9 | [NAME] is de effectieve verbetering van uw bijdrage aan
 |  | het primaire proces van uw organisatie met deze case?
 | 10 | Waaruit blijkt dit?
 | 11 | Hoe duurzaam is deze verbetering?
 | 12 | Hoe lang geleden is de Best Practice geïmplementeerd?
 | 13 | Welke lessen kunnen hieruit, naar uw mening, door
 |  | andere facility managers worden geleerd?
 | 14 | [NAME] u ter onderbouwing [NAME]
 |  | eventueel hebt bijgevoegd.
Spreadsheet: 762250d1641471985-how-to-link-a-template-sheet-to-update-other-sheets-snack-time-spends-1-
Sheet: Year 7 spend

Date | Budget (0.75 per child per week)
 | Accumulating | Spent | Difference
2021-08-30 00:00:00
2021-09-06 00:00:00 |  | 14.44
2021-09-13 00:00:00 |  | 14.44
2021-09-20 00:00:00 |  | 14.44
2021-09-27 00:00:00 |  | 16.9
2021-10-04 00:00:00
2021-10-11 00:00:00
2021-10-18 00:00:00 |  | 18.53
2021-11-01 00:00:00 |  | 19.08
2021-11-08 00:00:00 |  | 16.63
2021-11-15 00:00:00 |  | 13.87
2021-11-22 00:00:00 |  | 20.22
2021-11-29 00:00:00 |  | 19.08
2021-12-06 00:00:00 |  | 16.71
2021-12-13 00:00:00 |  | 19.82
2022-01-03 00:00:00 |  | 15.39
2022-01-10 00:00:00
2022-01-17 00:00:00
2022-01-24 00:00:00
2022-01-31 00:00:00
2022-02-07 00:00:00
2022-02-14 00:00:00
2022-02-21 00:00:00
2022-02-28 00:00:00
2022-03-07 00:00:00
2022-03-14 00:00:00
2022-03-21 00:00:00
2022-03-28 00:00:00
2022-04-04 00:00:00
2022-04-11 00:00:00
2022-04-18 00:00:00
2022-04-25 00:00:00
2022-05-02 00:00:00
2022-05-09 00:00:00
2022-05-16 00:00:00
2022-05-23 00:00:00
2022-05-30 00:00:00
2022-06-06 00:00:00
2022-06-13 00:00:00
2022-06-20 00:00:00
2022-06-27 00:00:00
2022-07-04 00:00:00
2022-07-11 00:00:00
2022-07-18 00:00:00
Spreadsheet: jeff_dasovich__14219__Problem _2_Final
Sheet: Sheet1

Sales | November | December | January | February | March | April | May | June | July
Mean |  |  | 1900000 | 1800000 | 2000000 | 2250000 | 2000000 | 2500000 | 2700000
Standard Deviation |  |  | 80000 | 80000 | 100000 | 125000 | 120000 | 90000 | 70000
[NAME] | 1500000 | 1600000 | 1900000 | 1800000 | 2000000 | 2250000 | 2000000 | 2500000 | 2700000
Assumptions | Percentage
Material & Labor Factor | 0.75
Interest on Cash Flow | 0.005
Interest on Loan | 0.01
Ending Cash Balance Required | 250000
 | November | December | January | February | March | April | May | June | July
Beginning Balance
Receipts
Fixed Costs |  |  | -250000 | -250000 | -250000 | -250000 | -250000 | -250000
Materials & Labor
Taxes |  |  | 0 | 0 | -150000 | 0 | 0 | -50000
Dividends |  |  | 0 | 0 | 0 | 0 | 0 | -50000
[NAME]
Interest on Loan
Interest on Cash Flow
Cash Flow (Pre-Loan Decision)
Loan
Ending Cash Balance (Post Loan Decision)
Maximum Loan
 |  |  | January | February | March | April | May | June
Loan Needed for Month? (1=Yes, 0=No)
Number of Months Loan Needed
Answers to Questions
(1) What is the mean and standard deviation of March's ending cash balance?
 | Mean = $264,982, Standard Deviation = $41,626
(2) What is the probability that June's ending cash balance will be greater than or equal to $300,000?
 | 0.205
(3) What is the mean and standard deviation of the number of months in which McGan will take out a one month loan?
 | Mean = 2.12, Standard Deviation = 1.20
(4) What is the probability that the number of months in which McGan will take out a one-month loan at the end of the month is greater than or equal to
3 months?
 | 0.318
(5) What is the probability that, at the end of April, McGan will take out a one-month loan?
 | 0.166
(6) What dollar amount will the loan taken out at the end of June be less than or equal to 88% of the time?
 | 188677
(7) What is the mean and standard deviation of the dollar value of the maximum one-month loan McGan will need to take out during the six-month period?
 | Mean = $157,467, Standard Deviation = $103,837
(8)  What is the probability that the dollar value of the maximum one-month loan McGan will need to take out during the six-month period is greater than
or equal to $250,000?
 | 0.187
Spreadsheet: sally_beck__33906__GlobalMgmtSum-Q101-0111
Sheet: YTD Mgmt Summary

ENRON GLOBAL MARKETS
2001 EARNINGS ESTIMATE
1st QUARTER YTD
 |  | Plan |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Margin | Expenses(1) | EBT |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
Liquids
Coal
Emissions
Weather
Global Risk Markets
Financial Trading
Transportation
Overview
Office of the Chairman
Subtotal Commercial
LNG
Middle East
Puerto Rico
Subtotal LNG / ME / PR
Total Commercial
Group Support Cost
Support Cost Allocated to Teams
Other Interest Related Charges
Capital Charge Offset
Global Markets EBIT
 |  |  |  |  |  | Other Expenses:
Interest Expense/(Income)
Global Markets Pre-tax Income
 |  |  |  | MPR Change:
(1) Includes capital charge, direct, and allocated expenses