tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Reg Affairs

 | Regulatory Affairs
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Analyst & Assoicate | 0 |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | 1893527
ENAOUTSV | Outside Services | 0 |  |  |  | 3851400
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | [NAME] | 28000 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 36000 | 0
ENARENT | Rent |  |  |  |  |  |  | Coordinator | 48000 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 52500 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 65000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 55000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 81000 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager |  | 1
 |  |  |  |  |  |  |  | Director |  | 3
 | Headcount |  |  | 111 |  |  |  | Sr. Director |  | 4
 |  |  |  |  |  |  |  | VP |  | 2
 | A&A Headcount |  |  |  |  |  |  | MD |  | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development |  |  |  |  |  |  | Other Expense Calculation
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent |  |  |  |  |  |  | Based on Legal Expenses
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 24143776.43 |  | 32191701.90666667
Spreadsheet: 207030d1358350863-compile-non-empty-cells-into-one-column-excel-question-non-linear-example
Sheet: Sheet1

 |  |  |  | 2 | 3 | 3 | 1
 |  |  | Section A | Section B | Section C | Section D | Section E |  | All Sections
 |  | length | 10 | 22 | 3 | 16 | 35 |  | 86
 |  | Increment | 1 | 2 | 1 | 4 | 7
 |  |  | 0 | 6 | 11 | 13 | 56 |  | 0
 |  |  | 1 | 8 | 12 | 17 | 63 |  | 1
 |  |  | 2 | 10 | 13 | 21 | 70 |  | 2
 |  |  | 3 | 12 | 14 | 25 | 77 |  | 3
 |  |  | 4 | 14 | 15 | 29 | 84 |  | 4
 |  |  | 5 | 16 | 16 | 33 |  |  | 5
 |  |  | 6 | 18 | 17 | 37 |  |  | 6
 |  |  | 7 | 20 | 18 | 41 |  |  | 7
 |  |  | 8 | 22 | 19 | 45 |  |  | 8
 |  |  | 9 | 24 | 20 | 49 |  |  | 9
 |  |  | 10 | 26 | 21 |  |  |  | 11
 |  |  |  | 28 | 22 |  |  |  | 13
 |  |  |  | 30 | 23 |  |  |  | 15
 |  |  |  | 32 | 24 |  |  |  | 17
 |  |  |  |  | 25 |  |  |  | 19
 |  |  |  |  | 26 |  |  |  | 21
 |  |  |  |  | 27 |  |  |  | 23
 |  |  |  |  | 28 |  |  |  | 25
 |  |  |  |  | 29 |  |  |  | 27
 |  |  |  |  | 30 |  |  |  | 29
 |  |  |  |  | 31 |  |  |  | 31
 |  |  |  |  | 32 |  |  |  | 32
 |  |  |  |  | 33 |  |  |  | 33
 |  |  |  |  | 34 |  |  |  | 34
 |  |  |  |  | 35 |  |  |  | 38
 |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  |  | 85
Spreadsheet: 2820e8d0-a6ae-439b-b504-cb0677fb40b0
Sheet: Sheet1

THE UNIVERSITY OF TULSA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
COLLEGE OF ARTS AND SCIENCES | Name_____________________________ | ID#______________________
Area of Concentration Requirements | [NAME] with Art History Emphasis
 |  | HR | GR | SM | Minor (12 hours)
1.        You must have a minimum GPA of 2.2 | Core Art History Courses (6 hours) |  |  |  | 6 hours must be at the 3000-4000 Level
in your area of concentration and a minimum of | ArtH 2203  Survey of Art History I | _____ | _____ | _____ | ___________________________________ | _____ | _____ | _____
2.0 TU GPA in order to graduate. | ArtH 2223  Survey of Art History II | _____ | _____ | _____ | ___________________________________ | _____ | _____ | _____
 |  |  |  |  | ___________________________________ | _____ | _____ | _____
2.        No Pass/D/F or CLEP credit may be |  |  |  |  | ___________________________________ | _____ | _____ | _____
applied toward your Area of Concentration. | [NAME] Division Electives (21 hours)
3.    Courses applied to meet Core and General | Choose 2 of the following courses:
Curriculum requirements may not also apply in | ArtH  3053  [NAME] | _____ | _____ | _____
your Area of Concentration. | ArtH  4313 Italian Renaissance Art | _____ | _____ | _____
 | ArtH  4013  Baroque and Rococo Art | _____ | _____ | _____
4.   Two thirds of the course work in your
Major [NAME] must be at the 3000 or 4000 level. | Choose 2 of the following courses:
 | ArtH  4613  19th Century European Art | _____ | _____ | _____
5.     Subjects in your Minor Field must be | ArtH  4223  Post Impressionism through
selected in conjunction with your [NAME] | Abstract Expressionism | _____ | _____ | _____
 | ArtH  4023  Art Since Mid-Century | _____ | _____ | _____
6.  No more than 55 hours may be earned in the
Area of Concentration, and no more than 39 of
these may be earned in the major subject. | Electives (9 hours)
These totals may be exceeded only by the | ___________________________________ | _____ | _____ | _____
number of hours beyond the 124 required for | ___________________________________ | _____ | _____ | _____
graduation. | ________________________________ | _____ | _____ | _____
 | Studio Art Electives  (6 hours)
 | ___________________________________ | _____ | _____ | _____
 | ___________________________________ | _____ | _____ | _____
Updated 9/1/10
Spreadsheet: 22434d1211298236-travel-time-distance-formula-traveltimedistance
Sheet: Sheet1

Travel Time Distance Calculator
Enter choices in the yellow cells
Totals |  | 77 | 90 |  | Data Table
Location 1 | Location 2 | Distance | Time |  | Key | [NAME] | Loc2 | Distance | Time
1 | 4 | 10 | 15 |  | 12 | 1 | 2 | 25 | 20
2 | 4 | 67 | 75 |  | 13 | 1 | 3 | 45 | 34
 |  |  |  |  | 14 | 1 | 4 | 10 | 15
 |  |  |  |  | 15 | 1 | 5 | 56 | 45
 |  |  |  |  | 21 | 2 | 1 | 25 | 20
 |  |  |  |  | 23 | 2 | 3 | 15 | 20
 |  |  |  |  | 24 | 2 | 4 | 67 | 75
 |  |  |  |  | 25 | 2 | 5 | 15 | 22
 |  |  |  |  | 26 | 2 | 6 | 2 | 5
Spreadsheet: 150616d1334620743-changing-date-format-84264abc-979c-43c6-830d-747c95ff936a
Sheet: Pivot Table

Date Time | (All)
Row Labels | Count of  [NAME]
2014 | 4
2029 | 17
2031 | 94
2035 | 104
2039 | 17
2042 | 37
2045 | 111
2048 | 64
2050 | 20
2051 | 20
2052 | 23
2053 | 76
2058 | 4
2061 | 9
2067 | 21
2078 | 21
2080 | 26
2089 | 65
2091 | 130
2094 | 49
2095 | 19
2098 | 48
2099 | 254
2102 | 41
2103 | 42
2105 | 15
2106 | 48
2107 | 41
2108 | 60
2112 | 34
2114 | 35
2116 | 7
2118 | 103
2120 | 87
2121 | 87
2122 | 4
2123 | 93
2126 | 5
2127 | 12
2129 | 8
2131 | 32
2133 | 36
2135 | 8
2139 | 34
2141 | 76
2145 | 1
2146 | 2
2147 | 13
2150 | 2
2151 | 8
2154 | 32
2157 | 315
2158 | 9
2159 | 3
2160 | 25
2161 | 14
2162 | 2
2163 | 59
2164 | 104
2165 | 35
2166 | 31
2167 | 311
2168 | 10
2169 | 60
2170 | 21
2171 | 8
2172 | 20
2173 | 23
2174 | 16
2175 | 68
2176 | 51
2177 | 23
2178 | 5
2179 | 125
2180 | 426
2182 | 8
3001 | 57
3021 | 4
3038 | 5
3048 | 44
3093 | 1
3111 | 10
3122 | 24
3124 | 5
3125 | 31
3126 | 27
3129 | 27
3130 | 20
3131 | 20
3143 | 23
3157 | 39
3162 | 4
3163 | 10
3167 | 11
3168 | 7
3169 | 11
Grand Total | 4351
Spreadsheet: tracy_geaccone__40252__C0366-112458
Sheet: Dept_100159

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
MAIL CENTER - Dept. 100159
April, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-04-23 00:00:00 | MCI2001/04-0366/112458 |  | Work Place | Work Place Count | 2 | 14.34 | /MNTH | 28.68
 |  |  |  |  |  |  | Ticket Total |  | 28.68
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 28.68
 |  |  |  |  |  |  | Total for Dept_100159 |  | 28.68
Spreadsheet: 53947d1253869650-if-statements-and-drop-down-box-help-drinkseg
Sheet: Drinks

 | 1 |  |  |  | Quantity
 |  |  | Total cost for Drinks
 |  |  |  |  |  |  | [NAME] (1)
 |  |  |  |  |  |  | White Wine (1)
 |  |  |  |  |  |  | Red Wine (1)
 |  |  |  |  |  |  | Hot Drinks (1)
 | Soft drinks
 |  | 0 |  | White Wine
 | Robinsons Fruit Shoot (Orange flavour) | 1.09 |  |  | 0
 | J2O (Orange & Passionfruit) | 1.6 |  | Jacob's Creek Semillion Chardonnay | 7.99
 | Pepsi | 1.29 |  | Pinot Grigio | 7.99 |  | SOFT DRINKS
 | Diet Pepsi | 1.29 |  | [NAME] | 7.99 |  | Robinsons Fruit Shoot (Orange flavour) |  | 1
 | Tango | 1.29 |  |  |  |  | J2O (Orange & Passionfruit)
 |  |  |  |  |  |  | Pepsi
 | Hot Drinks |  |  |  |  |  | Diet Pepsi
 |  | 0 |  | Red Wine |  |  | Tango
 | Coffee | 1.5 |  |  | 0 |  | WHITE WINE
 | Tea | 1.5 |  | [NAME]'s Creek [NAME] | 7.99 |  | Jacob's Creek Semillion Chardonnay
 | Hot Chocolate | 2 |  |  |  |  | Pinot Grigio
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | RED WINE
 |  |  |  |  |  |  | [NAME]'s Creek [NAME]
 |  |  |  |  |  |  | HOT DRINKS
 |  |  |  |  |  |  | Coffee
 |  |  |  |  |  |  | Tea
 |  |  |  |  |  |  | Hot Chocolate
Spreadsheet: 0428582d-3dad-4484-9fd1-fba788589790
Sheet: Sheet1

CONTRACT NO. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
ITEM NO.
PLAN QUANTITY =
DATE | AEB # | DAILY | ACCUM | AEB # | ACCUM | PAYMENT
 | TOTAL | TOTAL | TOTAL | PAY TOTAL | PAY TOTAL | NO.
FINAL TOTAL
Spreadsheet: michelle_lokay__26743__invoicesFeb02
Sheet: summary

[NAME]
February invoices
Total invoiced |  | 11684141.04 | including PGE prepayment
Collections |  | 11370690.38
% Collected
Still Outstanding
Customer Name |  | Total Amt
Citizens Communications
CMS MKTG, SERVICES & TRADING CO |  | 164.76
Eastern New Mexico |  | 1425
ENRON NORTH AMERICA CORP. (FKA ECT) |  | -3500 | to be wired to ENA
ENSERCO ENERGY, INC. |  | 592.17
One Ok |  | 17500
MIRANT AMERICAS ENERGY MARKETING,LP |  |  | short pay
SEMPRA ENERGY SOLUTIONS, LLC |  | 1545.32
North Star Steele |  | 28103.96
SID RICHARDSON GASOLINE CO. |  | 416.16
SOUTHERN CALIFORNIA GAS COMPANY |  |  | rate dispute
STATE OF TEXAS |  | 649.32
TEXACO NATURAL GAS, INC. |  |  | short pay
WASATCH ENERGY LLC |  | 2035.25
WTG GAS MARKETING, INC. |  | 6698.92
Spreadsheet: 43642d1242288251-how-to-key-a-formula-to-compute-the-due-date-jn8-19-2
Sheet: PastDue

[NAME], Inc.
Past Due Accounts
Invoice No. | Amount Due | Invoice Date | Due Date | Days Late | 2nd Notice
KK101 | 1000 | 2009-01-01 00:00:00 | 2009-01-31 00:00:00
KK120 | 2000 | 2009-02-01 00:00:00 | 2009-03-03 00:00:00
[NAME] | 23500 | 2009-03-01 00:00:00 | 2009-03-31 00:00:00
KK154 | 4500 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00
KK201 | 20000 | 2009-05-01 00:00:00 | 2009-05-31 00:00:00
[NAME] | 45000 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00
KK307 | 39000 | 2009-07-01 00:00:00 | 2009-07-31 00:00:00
KK338 | 535 | 2009-08-01 00:00:00 | 2009-08-31 00:00:00
[NAME] | 7745 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00
[NAME] | 2545 | 2009-10-01 00:00:00 | 2009-10-31 00:00:00
[NAME] | 8450 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00
KK490 | 15575 | 2009-12-01 00:00:00 | 2009-12-31 00:00:00
Spreadsheet: 861905d1709737499-transforming-horizontal-tables-into-rows-xlookup-and-indirect-indirect-copy-down
Sheet: Solution

Index>> | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | etc… | 5000
Table | X1 | X2 | X3 | X4 | X5 | X6 | X7 | X8 | X9 | X10 | X11 | X12 | X13 | X14 | X15 | X16 | X17 | X18 | X19 | X20 | X21 | etc… | X5000
Y1 | 567 | 363 | 523 | 184 | 179 | 597 | 420 | 783 | 874 | 674 | 410 | 443 | 577 | 806 | 497 | 395 | 749 | 751 | 866 | 865 | 188 | etc… | 694
Y2 | 895 | 313 | 469 | 671 | 547 | 841 | 288 | 315 | 911 | 828 | 405 | 926 | 288 | 908 | 382 | 295 | 660 | 766 | 351 | 514 | 649 | etc… | 271
Y3 | 669 | 460 | 519 | 769 | 517 | 611 | 694 | 737 | 657 | 399 | 838 | 785 | 901 | 821 | 625 | 842 | 784 | 415 | 317 | 396 | 229 | etc… | 668
Y4 | 574 | 592 | 391 | 193 | 194 | 790 | 636 | 687 | 694 | 306 | 646 | 588 | 692 | 303 | 605 | 881 | 675 | 873 | 718 | 807 | 883 | etc… | 370
Y5 | 831 | 914 | 350 | 873 | 862 | 203 | 309 | 321 | 943 | 821 | 391 | 182 | 922 | 382 | 645 | 774 | 599 | 175 | 732 | 242 | 453 | etc… | 584
Y6 | 543 | 312 | 613 | 651 | 191 | 743 | 569 | 327 | 684 | 319 | 838 | 230 | 580 | 513 | 467 | 779 | 782 | 808 | 750 | 391 | 841 | etc… | 456
Y7 | 885 | 176 | 597 | 274 | 489 | 158 | 361 | 798 | 452 | 781 | 285 | 474 | 304 | 657 | 183 | 890 | 310 | 505 | 353 | 161 | 524 | etc… | 846
[NAME] | 243 | 587 | 234 | 339 | 776 | 513 | 726 | 167 | 306 | 471 | 715 | 708 | 185 | 544 | 279 | 564 | 367 | 179 | 297 | 518 | 939 | etc… | 330
Y9 | 795 | 246 | 723 | 700 | 584 | 748 | 897 | 573 | 549 | 803 | 574 | 552 | 473 | 744 | 711 | 823 | 606 | 371 | 930 | 395 | 796 | etc… | 661
Index | Lable1 | Lable2 | Value |  |  |  |  |  | Problem: How can one transform a horizontal table into a table of rows one can copy-down?
1 | _[NAME] |  |  | return Y1 value corresponding to X1
1 | _Y2 |  |  | return Y1 value corresponding to X1
1 | _Y3 |  |  | etc
1 | _Y4
1 | _Y5
1 | _Y6
1 | _Y7
1 | _[NAME]
1 | _Y9
 |  |  |  | return Y1 value corresponding to X2
 |  |  |  | return Y1 value corresponding to X2
 |  |  |  | etc
 |  |  |  | return Y1 value corresponding to X3
 |  |  |  | return Y1 value corresponding to X3
 |  |  |  | etc
Spreadsheet: michelle_lokay__26612__sharris0101wk5
Sheet: Estimate Vs. Plan

Transwestern Pipeline Company
($[NAME])
Jan Week 5  01-31-01
 |  | January, 2001
 |  | Plan | Estimate | [NAME] |  | Comments
West Demand Revenues |  |  |  |  |  | Tenaska K @ Max Rates
West Commodity Revenues |  |  |  |  |  | Higher [NAME]
East Demand Revenues |  |  |  |  |  | [NAME] for 10/day @ $0.50
East Commodity Revenues |  |  |  |  |  | Higher Rates
[NAME] |  |  |  |  |  | Higher Rates
[NAME] Revenues |  |  |  |  |  | Higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance
[NAME] due to Price |  |  |  |  |  | MTD index price of $8.21 vs. Plan index price of $3.90 for unhedged vols.
[NAME] due to net fuel retention. |  |  |  |  |  | Higher  volumes than Plan
Hedging Adjustment |  |  |  |  |  | Add'l price on physical sales
 |  |  |  |  |  | ($.005 on 10,000/day, $.02 on 10,000/day)
Unaccounted for Variance
 |  |  |  | -------------
Fuel Variance
 |  |  |  | -------------
MONTH-TO-DATE VARIANCE
 |  |  |  | ========
2001 Stretch |  | 0.85 | 0
 |  |  |  | -------------
ADJUSTED MONTH-TO-DATE VARIANCE
 |  |  |  | ========
[NAME]
 | Year-to-Date
 | Margin | Fuel & UAF | Stretch | Total
Plan (through January) | 13.2401 |  | 0.85
Estimate
 | ------------- | ------------- | ------------- | -------------
Variance from Plan
 | ------------- | ------------- | ------------- | -------------
Spreadsheet: 188657d1350946304-excel-removes-all-data-validation-lists-at-the-opening-of-the-workbook-quotation_parkregis_hotel-master
Sheet: Product Specs

Item | Tips
Phillips 10W MR16 | - Hallogen Replacement - Good in general - Flash on an electronic transformer
Ecobulb | - Hallogen Replacement - Fall off the roof: the fitting mechanism doesn't hold the lamp properly. If shock, the lamp may fall on the ground (Clients have been complaining in NSW). - Good lighting but long to warm up: It takes more than 30 seconds for the lamp to warm up --> you wouldn't put it in hotels, or in place where you expect instant lighting. - Don't use it on censor control mechanism - Some have blown up.
LED4LIfe (6/9W) GU10 | - GU10 fitting - not bright at all - Reliable - Not a big dimming range
Centaurus | - Hallogen Replacement - Better output than LED4Life - Better dimming range - No spotting effect --> Use centaurus in place of Led4Life EXCEPT when GU10 fitting.
Emerauld Planet GU10 | - Hallogen Replacement - No dimmers - GU10 fitting - bright enough (brighter than LED4Life)
Alpha 12W | - Hallogen Replacement - It comes with a driver: You don't need any transformer. You would pull the existing transformer out because you don't need it. - The [NAME] doesn’t fit on 70mm fittings (diameter hole) --> can only get in 90mm hole. - Alpha more spread out tham Carinda (less spotty) - Very bright lighting --> Would use it in places where very bright light is required, such as offices, etc.
[NAME] | - Hallogen Replacement - It comes with a driver: You don't need any transformer. You would pull the existing transformer out because you don't need it. - Very bright lighting --> Use where LUX requirements are high - Best spotting effect --> don't put in restaurants or offices  - Good dimming range - Carinda's degree specifications is 45, but more like 35 - Don't pay supplier for flexi, i.e. powercord, because most of the time, there is no need to use it.when it is necessary to use it, just pay electrician for it. (Otherwise, you end up with powercords everywhere in stock)
[NAME] | - T8 Replacement - Can face sideways when inserted in fitting - Turn the edge plastic fitting on lamp (both sides) and rotate the plastic fitting to rotate the lamp so that it is positioned downward
LED Tubes (14/20W) | - T8 Replacement - 2 types of 14W: One budget, one standard. Budget for car parks (general area in car parks without special LUX requirements (entry/exit for example) - On magnetic transformer / ballast, remove the starter before putting the T5 in. - On electronic transformer, bypass the transformer - More energy savings with LED Tubes --> better payback period.
[NAME] | - big energy savings - Very simple to install - Usually need a scissor lift - Feedback's been very positive
Spreadsheet: darrell_schoolcraft__7321__imball0202
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 4835 | 5511 | 5 | 6 | 825 | 581 | 1458 | 895
2 | 5871 | 5511 | 20 | 6 | 860 | 581 | 1510 | 895
3 | 5772 | 5511 | 9 | 6 | 927 | 581 | 1471 | 895
4 | 5788 | 5511 | 29 | 6 | 944 | 581 | 1445 | 895
5 | 5337 | 5511 | 3 | 6 | 925 | 581 | 1425 | 895
6 | 5250 | 6011 | 142 | 6 | 913 | 581 | 1797 | 895
7 | 5202 | 6011 | 41 | 6 | 915 | 581 | 1586 | 895
8 | 5313 | 6011 | 1 | 6 | 912 | 581 | 1516 | 895
9 | 5045 | 6011 | 1 | 6 | 911 | 581 | 1472 | 895
10 | 5435 | 6011 | 1 | 6 | 861 | 581 | 1437 | 895
11 | 5574 | 6011 |  | 6 | 929 | 581 | 1452 | 895
12 | 5232 | 6011 |  | 6 | 942 | 581 | 1480 | 895
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  | 341278
2002-02-12 00:00:00
CBS Volume
 |  |  | 135419
Spreadsheet: 693511d1598998062-calculation-by-looking-up-the-right-month-book2
Sheet: Sheet1

[NAME] | Amount | Probability | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00
2020-06-01 00:00:00 | 667 | 1 | 0 | 0
2020-06-01 00:00:00 | 559 | 1 | 0 | 0
2020-06-01 00:00:00 | 3897 | 1 | 0 | 0
2020-06-01 00:00:00 | 350 | 1 | 0 | 0
2020-07-01 00:00:00 | 482 | 1 | 0 | 0 | 0
2020-07-01 00:00:00 | 559 | 1 | 0 | 0 | 0
2020-07-01 00:00:00 | 252 | 1 | 0 | 0 | 0
2020-09-01 00:00:00 | 324 | 0.75 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | How to improve the formula so it matches the month and does the calculation going forward?
2020-09-01 00:00:00 | 1409 | 0.75 | 0 | 0 | 0 | 0 | 0
2020-09-01 00:00:00 | 700 | 0.5 | 0 | 0 | 0 | 0 | 0
2020-09-01 00:00:00 | TBD | 0.4
2020-09-01 00:00:00 | 1409 | 1 | 0 | 0 | 0 | 0 | 0
2020-09-01 00:00:00 | 559 | 1 | 0 | 0 | 0 | 0 | 0
2020-10-01 00:00:00 | 559 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0
2020-10-01 00:00:00 | 35342 | 0.4 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | These cells above shows zero  because it's not the right month
 |  |  |  |  |  |  | Current formula | '=IFERROR(IF(OR($B9<>"TBD"),$B9*$C9," "),0)
 |  |  |  |  |  |  | add another criteria so it matches the month column | =[NAME]))
Spreadsheet: 270173d1381409494-what-lookup-function-should-i-use-tracker-example
Sheet: What I would like

 | Reference | 6080
 | Title | Example 2
 | Notes
 | Funding received
 | Name | Amount Received | Date Received
 | [NAME] | 75000 | 2013-02-01 00:00:00
 | Marcus | 280 | 2013-02-05 00:00:00
 | Superman | 25 | 2013-02-12 00:00:00
 | Batman Appeal | 2.5 | 2013-03-05 00:00:00
 | [NAME] | 600 | 2013-03-15 00:00:00
 | [NAME] | 10 | 2013-03-26 00:00:00
 | [NAME] | 10 | 2013-03-26 00:00:00
 | [NAME] | 10 | 2013-05-08 00:00:00
 | [NAME] | 20 | 2013-05-08 00:00:00
 | [NAME] | 20 | 2013-05-14 00:00:00
 | [NAME] | 20 | 2013-05-14 00:00:00
 | [NAME] | 5 | 2013-05-21 00:00:00
 | Marcus | 5 | 2013-05-21 00:00:00
 | Superman | 10 | 2013-05-29 00:00:00
 | Batman Appeal | 10 | 2013-05-29 00:00:00
 | [NAME] | 10 | 2013-05-29 00:00:00
 | [NAME] | 25 | 2013-05-29 00:00:00
 | [NAME] | 10 | 2013-05-29 00:00:00
 | [NAME] | 10 | 2013-05-29 00:00:00
 | [NAME] | 40 | 2013-05-29 00:00:00
 | [NAME] | 10 | 2013-05-29 00:00:00
 | [NAME] | 20 | 2013-05-29 00:00:00
 | Total amount received
Spreadsheet: 220079d1363048454-finding-golf-handicaps-using-best-2-out-of-3-last-rounds-played-golf2012
Sheet: CARDNAMES

A1 | [NAME]
A2 | [NAME]
B1 | [NAME]
B2 | [NAME]
C1 | [NAME]
C2 | Amber Lucas
D1 | [NAME]
D2 | [NAME]
E1 | [NAME]
E2 | [NAME]
F1 | [NAME]
F2 | [NAME]
[NAME] | [NAME]
G2 | Pam Morris
H1 | [NAME]
H2 | Jan Keen
I1 | [NAME]
I2 | Heather Weberling
J1 | [NAME]
J2 | [NAME]
K1 | [NAME]
K2 | [NAME]
L1 | [NAME]
L2 | Dixie Easterday
M1 | Crystal Elliott
M2 | [NAME]
N1 | [NAME]
N2 | [NAME]
O1 | [NAME]
O2 | [NAME]
P1 | [NAME]
P2 | [NAME]
Q1 | [NAME]
Q2 | [NAME]
R1 | [NAME]
R2 | [NAME]
S1 | [NAME]
S2 | [NAME]
T1 | [NAME]
T2 | Pam MacQuaig
Spreadsheet: 123803d1317859539-dates-and-leap-years-book1
Sheet: Sheet1

 |  |  | Sentence Length |  |  |  | Fractional Year Breakdown(Months)
SENTENCE DATE | 2011-10-03 00:00:00
 |  |  | YEARS |  | MONTHS |  | 1 | 0.08
 |  |  | 1 |  | 4 |  | 2 | 0.17
YEARS TO DAYS | 365.25 |  |  |  |  |  | 3 | 0.25
 |  |  |  |  |  |  | 4 | 0.33
MONTHS TO DAYS | 121.75 |  |  |  |  |  | 5 | 0.42
 |  |  |  |  |  |  | 6 | 0.5
TOTAL SENTENCE IN DAYS | 487 |  |  |  |  |  | 7 | 0.58
 |  |  |  |  |  |  | 8 | 0.67
 |  |  |  |  |  |  | 9 | 0.75
SENTENCE LENGTH | 1.333333333333333 |  |  |  |  |  | 10 | 0.83
 |  |  |  |  |  |  | 11 | 0.92
RELEASE DATE | 2013-02-01 00:00:00 |  |  |  |  |  | 12 | 1
Enter the sentence date and sentence length.  All calculations will be performed automatically.
The Fractional Breakdown Chart is for informational purposes only.  When looking at Sentence
Length on the left side of the form, (months) a fractional date will populate corresponding to the chart above
Spreadsheet: 864215d1711470445-random-nonrepeating-questions-and-answers-for-quiz-show-example
Sheet: Test Bank

1 | NJROTC Instructors are local educators working under the | principal of the school
2 | What are [NAME] Values | Honor, Courage, Commitment
3 | True or False: Hazing is something that can occur in many different environments | True
4 | Military time uses a ___ hour clock. | 24
5 | Which NJROTC activity is requires the ability to read a map and determine direction? | Orienteering
6 | In what NJROTC activity would you expect to compete in climbing, jumping, running and an obstacle course? | Physical Fitness Competition
7 | NJROTC Units participate in activities to support their communities such as food drives,_____________ , and projects to assist the elderly | recycling projects
8 | NJROTC orientation trips typically involve visits to which of the following places? | Military bases
9 | Financial and career advancement incentives are possible for cadets who choose military careers and complete at least __ year(s) of NJROTC. | 3
10 | Those who participate in college level NROTC receive which of the following? | full tuition