tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 25ad0698-73b1-4cd3-b666-563017ad8423
Sheet: Sheet1

THE INSTITUTE OF INTERNAL AUDITORS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
FINANCIAL REPORT SUMMARY
INSTITUTE NAME: |  | For the Period:
 |  | (fiscal year end) | (Month/Year)
 |  | US$ [NAME] (use average exchange rate) | Local currency
REVENUE
Operating | Membership dues/Corporate fees
 | Events (Seminars/Conferences, etc.)
 | Publications
 | Certification
 | Sponsorship/Donations
 | Other (explain if significant)
Sub-Total |  | 0 | 0
Extraordinary | One time event (e.g. International or ECIIA, UFAI, FLAI, ACIIA conferences or sell of capital asset)
TOTAL REVENUE |  | 0 | 0
EXPENSES
Operating | Administration/Facilities
 | Events (Seminars/Conferences, etc.)
 | Publications
 | Certification
 | Travel
 | Affiliation fees (int'l and regional)
 | Income taxes (where applicable)
 | Other (explain if significant)
Sub-Total |  | 0 | 0
Extraordinary | One time event (e.g. International or ECIIA, UFAI, FLAI, ACIIA conferences or sell of capital asset)
TOTAL EXPENSES |  | 0 | 0
NET INCOME |  | 0 | 0
Statement of Financial Position
ASSETS
Cash assets | Cash balance
 | Investments
 | Accounts receivable
Sub-total |  | 0 | 0
 | Non-cash assets
TOTAL ASSETS |  | 0 | 0
LIABILITIES
 | Short Term liabilities
 | Long Term liabilities
TOTAL LIABILITIES |  | 0 | 0
NET ASSETS |  | 0 | 0
Indicate Currency Average Rate Used for the Period: |  | Today's Date:
Note: The total amounts reflected on this form must be equal to those on the organization's financial records.
Please convert your country's currency to US dollars using average exchange rate for the period and indicate the rate used.
http://www.oanda.com/currency/historical-rates/
E-mail your report to [EMAIL]
Spreadsheet: 761275d1640791648-see-the-duties-that-a-particular-person-is-doing-on-every-day-of-the-week-for-each-hour-sales-rota-aligw
Sheet: Tuesday

 | Staff Key
 | [NAME] |  | A |  | [NAME] |  | C
 | Jamaal Grant |  | G |  | Jade |  | D
 | Elke Buss |  | E |  | Georgia |  | R
 | Jasmine |  | J |  | [NAME] |  | S
TASK | 08:00 | 09:00 | 10:00 | 11:00 | 12:00 | 13:00 | 14:00 | 15:00 | 16:00 | 17:00 | 18:00 | Hours p/Task
Admin (Glenkrag, Orders, Emails (1hr)
Axolotl - Cleaning
Axolotl - Feeding
Bearded Dragons |  | G |  |  |  | E | E | E | E
[NAME], feed tortoises, baby beardies, spray chameleons
Crested gecko breeding room.  Waters and check eggs. 30 mins
Department Cleaning | R | R | R | R |  | R | R | R | R
Greenhouse | AC | AC | AC | AC |  | AC | AC | AC | AC
[NAME] | G
Inverts - General |  |  | G | G
Inverts - Mantids
Inverts - Spiders
[NAME] |  |  |  |  |  | D | D | D | D
Packing | J | J | J | J |  | J | J | J | J
Picking
Sales | D | D | D | D |  | G | G | G | G
Snakes - Cleaning
Snakes - Feeding
Snakes - Non feeders
[NAME]/admin
Team Leader Duties | E | E | E | E
Count of People per Hour
Spreadsheet: 132768d1323914630-formula-to-calculate-single-cell-based-on-many-variables-copy-of-point-formula
Sheet: Sheet1

Example 1 |  |  |  |  | Cells below show race results
 | Result Cell | Points |  |  | If Selection |  | 1st | 2nd | 3rd | 4th | 5th
 |  |  |  |  | 1 |  | Horse A | Horse B | HORSE C | HORSE D | HORSE C
 |  |  |  |  | Horse A |  |  |  |  |  |  |  | Note DH = Dead Heat
 |  |  |  |  |  | Dividend | 12 | 3.7 | 10 | 5.2 | 2.35
 |  |  |  |  |  | POINTS |  |  |  |  |  |  | [NAME] To a Race
 |  |  |  |  |  |  |  |  |  |  |  |  | Result | 1st | 2nd | 3rd | 4th | 5th
 |  | Notes |  |  | O$10+  IF(H$6>6,O11)+IF(H$6>11,O12,0) |  |  |  |  |  |  |  | if 1s<$6 | 3 | 2 | 1
 |  | In this example 1st is horse 5 (cell H4) therefore it would get 3 points (Table Cell O10) for coming |  |  |  |  |  |  |  |  |  |  | if 1st>$6 but <$11 | 1
 |  | 1st plus 1 point because it's dividend is >$6 (Table Cell 011) + 1 point because its dividend |  |  |  |  |  |  |  |  |  |  | if st > $11 | 1
 |  | is >$11 (Table Cell O12) which = 5 points allocated in Cell C5 etc. |  |  |  |  |  |  |  |  |  |  | if DH 1st & 2nd | 2.5 | 2.5 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | if 1st>$6 but <$11 | 0.5 | 0.5 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | if 1st > $11 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | if DH 1st, 2nd & 3rd
 |  |  |  |  |  |  |  |  |  |  |  |  | under $6 | 2 | 2 | 2
Example 2 DH 1st & 2nd |  |  |  |  | Cells below show race results |  |  |  |  |  |  |  | $6.01 - $11.00 | 2.33 | 2.33 | 2.33
 | Result Cell | Points |  |  | If selection |  | 1st | 2nd | 3rd | 4th | 5th |  | $11+ | 2.66 | 2.66 | 2.66
 |  | 4 |  |  | 5 |  | 5 | 4 | 8 | 2 | 6 |  | if DH 2nd & 3rd | 0 | 1.5 | 1.5
 |  | 2.5 |  |  | 4 |  |  |  |  |  |  |  | if DH 2nd,3rd & 4th | 0 | 1 | 1 | 1
 |  | 1 |  |  | 8 | Dividend | 12 | 3.7 | 10 | 5.2 | 2.35 |  | if DH 3rd & 4th | 0 | 0 | 0.5 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  | if DH 3rd, 4th & 5th | 0 | 0 | 0.33 | 0.33 | 0.33
 |  | Notes
 |  | In this example it is [NAME] for 1st & 2nd, therefore 1st is horse 5 (cell H20) get 2.5 points
 |  | per (Table Cell O13) + 0.5 pts per (Table Cell O14) + 1 pts per (Table Cell O15) = Total 4pts
 |  | 2nd horse pays <$6 therefore gets 2.5 pts per (Table Cell P13) & 3rd horse 1 pt per (Table Cell Q13)
 |  | …. And so on for the rest of the table
Spreadsheet: 272493d1382403721-i-need-to-create-a-conditional-paragraph-based-on-the-value-of-a-cell-homeostatic-laboratory-interpretation
Sheet: Sheet1

Homeostatic Laboratory Reference Interpretation
Test Description | Homeostatic Range | Patient Results | High or Low
Cholesterol | 150-200
HDL Cholesterol | 55-120
[NAME] | 50-110
Homocysteine | <7.20
Triglyceride | 80-115
Glucose | 85-100
Sodium | 140-144
Potassium | 4.0-4.6
Chloride | 100-106
Bicarbonate CO2 | 26-28
Blood Urea Nitrogen (BUN) | 13-18
Creatinine | 0.6-1.0
BUN/Creatinine Ratio | 13-17
Uric Acid | 4.0-6.0
Calcium | 9.7-10.1
Phosphorous | 3.4-4.0
[NAME] | 60-100
Total Protein | 7.1-7.6
Albumin | 4.0-4.5
Globulin | 2.8-3.5
A/G Ratio | 1.2-1.6
Calcium/Albumin Ratio | 2.2-2.5
GGT | 1.0-36.0
SGOT (AST) | 18-26
LDH | 400-531
Total Bilirubin | 0.5-0.7
Serum Iron | 85-120
[NAME] (ALT) | 18-26
White Blood Count | 5.0-8.0
Red Blood Count | 4.5-5.5
Hemoglobin | 14-15
Hematocrit | 40-47
MCV | 85-97
MCH | 27-31
MCHC | 32-34
POLYS (SEGS-PMNS) | 55-65
Lymphocytes | 25-40
Monocytes | 3.0-7.0
Eosinophils | 0.0-4.0
Basophils | 0.0-0.0
Platelets | 175-250
Erythrocyte Sedimentation Rate ESR | 4.0-12.0
Magnesium (serum) | 2.2-2.6
Usable Calcium | 7.9-10.1
Calcium-Phosphorous Index | 30-40
[NAME] | 4.3-6.4
T4 | 7.0-9.0
T3 | 36-40
FTI | 2.6-3.6
TSH | .04-4.0
Bands 1 STAB | 0.0-0.0
Spreadsheet: 153329d1335875474-sum-data-based-on-selection-on-dropdown-menu-copy-of-excel-forum-monthly-dropdown-data
Sheet: Summary

 |  |  |  |  |  |  |  |  | Fiscal period is Jul-Jun
 |  |  | MTD |  |  |  |  |  | YTD | (Jul-Mar)
 | Dropdown -->> |  | 2012-03-01 00:00:00 |  |  |  |  |  | 2012-06-01 00:00:00
 |  |  | Actual | Budget | Forecast |  |  |  |  |  | Actual | Budget | Forecast
 | Revenue |  |  |  |  |  |  |  | Revenue
 | Cost 1 |  |  |  |  |  |  |  | Cost 1
 | Cost 2 |  |  |  |  |  |  |  | Cost 2
 | Cost 3 |  |  |  |  |  |  |  | Cost 3
Spreadsheet: 675805d1588503785-help-calculating-tiered-commissions-comms-calculations
Sheet: Sheet1

 |  |  | Q1
 |  |  | Jan | Feb | Mar | Qtr Total
 |  | Revenue | 100000 | 100000
 |  | Cost | 90000 | 69000 |  |  |  |  | Tier | Range | Payout %
 |  | Profit |  |  |  |  |  |  | 1 | <79% | 0
 |  | Sales Target | 32000 | 32000 |  |  |  |  | 2 | 80% to 99% | 0.8
 |  | Target Achieved% |  |  |  |  |  |  | 3 | 1 | 1
 |  | Commission Payout | 10000 | 10000 |  |  |  |  | 4 | 101% to 110% | 1.1
 |  | <79% |  |  |  |  |  |  | 5 | 111% to 120% | 1.2
 |  | 80% to 99%
 |  | 1
 |  | 101% to 110%
 |  | 111% >
 |  | [NAME]
Spreadsheet: 32334d1228434299-help-making-excel-calculate-price-list
Sheet: Sheet1

Product: | My Product Name Goes Here |  |  |  |  |  | Prices Last Updated: |  | Enter Date Prices Were Last Updated
Product Length |  |  | Cost Price |  |  | Delivery |  | VAT @ 15% |  | [NAME] % |  | Retail Price
2 foot |  |  | 25 |  |  | 10 |  | 7.125 |  | 0.5 |  | 54.62499999999999
3 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
4 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
5 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
6 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
7 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
8 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
9 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
10 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
11 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
12 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
13 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
14 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
15 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
16 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
17 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
18 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
19 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
20 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
21 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
22 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
23 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
24 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
25 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
26 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
27 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
28 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
29 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
30 foot |  |  |  |  |  | 10 |  | 1.5 |  |  |  | 11.5
Spreadsheet: 15d1146e-5613-4d50-9a38-a9ca57c50002
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Table 10--Acreage, yield, and production estimates, 2012
State/region | Planted |  | Harvested |  | Yield |  | Production
 |  |  |  |  | Pounds/
 | -- 1,000 acres -- |  |  |  | [NAME] |  | 1,000 bales
Upland:
Alabama | 380 |  | 377 |  | 764 |  | 600
Florida | 108 |  | 105 |  | 1051 |  | 230
Georgia | 1290 |  | 1285 |  | 934 |  | 2500
North Carolina | 585 |  | 580 |  | 869 |  | 1050
South Carolina | 298 |  | 296 |  | 859 |  | 530
Virginia | 86 |  | 85 |  | 988 |  | 175
Southeast | 2747 |  | 2728 |  | 895 |  | 5085
Arkansas | 590 |  | 580 |  | 993 |  | 1200
Louisiana | 230 |  | 220 |  | 895 |  | 410
Mississippi | 470 |  | 460 |  | 991 |  | 950
Missouri | 350 |  | 330 |  | 945 |  | 650
Tennessee | 380 |  | 375 |  | 755 |  | 590
Delta | 2020 |  | 1965 |  | 928 |  | 3800
Kansas | 57 |  | 52 |  | 434 |  | 47
Oklahoma | 305 |  | 175 |  | 466 |  | 170
Texas | 6600 |  | 4900 |  | 598 |  | 6100
Southwest | 6962 |  | 5127 |  | 591 |  | 6317
Arizona | 200 |  | 198 |  | 1576 |  | 650
California | 142 |  | 141 |  | 1685 |  | 495
New Mexico | 50 |  | 47 |  | 1072 |  | 105
West | 392 |  | 386 |  | 1554 |  | 1250
Total Upland | 12121 |  | 10206 |  | 774 |  | 16452
Pima:
Arizona | 3 |  | 3 |  | 1120 |  | 7
California | 225 |  | 224 |  | 1350 |  | 630
New Mexico | 3 |  | 3 |  | 828 |  | 5
Texas | 8 |  | 8 |  | 960 |  | 15
Total Pima | 239 |  | 237 |  | 1328 |  | 657
Total all | 12360 |  | 10443 |  | 786 |  | 17109
Last update: 09/13/12.
Source:  USDA, September 2012 Crop Production report.
Spreadsheet: 828263d1683345617-running-total-in-the-last-cell-of-range-running-balance
Sheet: Sheet1

 |  |  | Items | QTY | Running Balance | Josephteh Result | My Attempt :)
 |  |  | Apples | 5
 |  |  | AAA | -1
 |  |  | Apples | -2
 |  |  | AAA | -1
 |  |  | Apples | 1
 |  |  | Apples | -4
 |  |  | AAA | 1
 |  |  | Apples | 5
Need the running Balance to Total only with the last matching entry of column C (In this Case "AAA" C11), Then have all previous "AAA" QTY cells go to Zero
And The Result on the Last entry of AAA should be Negative 1 And for Apple +5
Spreadsheet: 732445d1620964963-matching-ids-with-rank-in-a-specific-order-sample
Sheet: Sheet1

ID | RANK | Expected Output
2019-05-04GCO1 | 1 |  | <--- Rank 2 does not exist with these two ID's, so I need Rank 1
2019-05-04GCO1 | 3
2019-05-04FLE1 | 1
2019-05-04FLE1 | 2 |  | <--- Rank 2 does exist here, so flag it as a Yes
2019-05-04KEN2 | 1 |  | <-- There is only one Rank for this ID, so flag it as a Yes
2019-05-04FLE2 | 2 |  | <--- Rank 2 does exist here, so flag it as a Yes
2019-05-04FLE2 | 3
2019-05-04MOP1 | 3 |  | <--- Rank 2 does not exist with these three ID's, so I need Rank 3 as it is the lowest number
2019-05-04MOP1 | 4
2019-05-04MOP1 | 5
2019-05-04KEN3 | 1 |  | <--- Rank 2 does not exist with these two ID's, so I need Rank 1 as it is the lowest number
2019-05-04KEN3 | 5
Spreadsheet: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: Re-Determination-Renewal-Recert

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Management (Undercare)
Activity Name | Re-Determination-Renewal-Recert
Activity Description / Purpose | Process of re-establishing eligibility of customer.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Create redetermination packet
Send redetermination packet
Decision: Did redetermination packet get returned?
Spreadsheet: 537285d1504913586-this-operation-has-been-canceled-new-excel-error-budget
Sheet: Expenses C

Someone's Budget
 |  |  |  |  |  |  |  |  |  | Summary
 | Medical |  |  |  |  |  |  |  |  | Show results
 |  | Frequency | Amount | Annually amount
 | TBA |  | 170 | 2040 |  |  |  |  |  | Income |  |  |  |  |  |  |  |  | 3
 | TBA |  | 1200 | 1200 |  |  |  |  |  | Income | 33276 |  |  |  |  |  |  |  | 5
 | TBA |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | TBA |  | 100 | 1200 |  |  |  |  | Total Income |  | 33276 |  |  |  |  |  |  |  | 3
 | TBA |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | TBA |  | 0 | 0 |  |  |  |  |  | Outgoings |  |  |  |  |  | Select | # in a year | Amount | 5
 | TBA |  | 0 | 0 |  |  |  |  |  | Overheads | 7520 |  |  |  | 1 | Weekly | 52 | Weekly | 3
 |  |  | Total | 4440 |  |  |  |  |  | Vehicle | 7887 |  |  |  | 2 | Fortnightly | 26 | Fortnightly
 | Accounting, Insurance |  |  |  |  |  |  |  |  | Living | 3824 |  |  |  | 3 | Monthly | 12 | Monthly
 |  |  |  |  |  |  |  |  |  | Medical | 4440 |  |  |  | 4 | Quarterly | 4 | Quarterly
 | Accountant |  | 234 | 234 |  |  |  |  |  | Accounting, Insurance | 777 |  |  |  | 5 | Annually | 1 | Annually | 5
 | House Insurance |  | 432 | 432 |  |  |  |  |  | Recreation | 1768 |  |  |  |  |  |  |  | 5
 | - |  | 0 | 0 |  |  |  |  |  | Travel | 333 |  |  |  |  |  |  |  | 4
 | - |  | 0 | 0 |  |  |  |  |  | Business Overheads | 25 |  |  |  |  |  |  |  | 5
 | - |  | 0 | 0 |  |  |  |  |  | Development | 3996 |  |  |  |  |  |  |  | 4
 | TBA |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | TBA |  | 0 | 0 |  |  |  |  | Total outgoings: |  | 30570 |  |  |  |  |  |  |  | 5
 | Taxes |  | 111 | 111 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  | Total | 777
 |  |  |  |  |  |  |  |  | What's left: |  | 2706
 |  |  |  |  |  |  |  |  |  |  | per year
 | Medical / Accounting, Insurance
Spreadsheet: 743935d1628823445-generate-range-of-dates-from-a-given-period-test-sc
Sheet: test

Date Range |  |  |  |  |  | Step | From | To |  | Step | From | To |  |  | From | To
1981-03-01 00:00:00 | 1981-06-30 00:00:00 |  |  |  |  | 1 | 2002-11-03 00:00:00 |  |  | 2 | 2002-11-03 00:00:00 |  |  |  | 2015-03-26 00:00:00 | 2019-07-14 00:00:00
1981-07-01 00:00:00 | 1981-12-31 00:00:00 |  |  |  |  | STEP | test 1 |  |  | STEP | test 2 |  |  | STEP | test 3
1982-01-01 00:00:00 | 1984-04-30 00:00:00 |  |  |  |  |  | From | to |  |  | From | to |  |  | From | to
1984-05-01 00:00:00 | 1984-06-30 00:00:00 |  |  |  |  |  |  |  |  | 2
1984-07-01 00:00:00 | 1984-12-31 00:00:00 |  |  |  |  |  |  |  |  | 3
1985-01-01 00:00:00 | 1985-12-31 00:00:00 |  |  |  |  |  |  |  |  | 3
1986-01-01 00:00:00 | 1986-06-30 00:00:00 |  |  |  |  |  |  |  |  | 3
1986-07-01 00:00:00 | 1987-02-28 00:00:00 |  |  |  |  |  |  |  |  | 4
1987-03-01 00:00:00 | 1987-12-31 00:00:00 |  |  |  |  |  |  |  |  | 4
1988-01-01 00:00:00 | 1989-06-30 00:00:00 |  |  |  |  |  |  |  |  | 4
1989-07-01 00:00:00 | 1993-12-31 00:00:00 |  |  |  |  |  |  |  |  | 4
1994-01-01 00:00:00 | 1994-12-31 00:00:00 |  |  |  |  |  |  |  |  | 5
1995-01-01 00:00:00 | 1995-12-31 00:00:00 |  |  |  |  |  |  |  |  | 5
1996-01-01 00:00:00 | 1996-12-31 00:00:00 |  |  |  |  |  |  |  |  | 6
1997-01-01 00:00:00 | 1997-10-31 00:00:00 |  |  |  |  |  |  |  |  | 6
1997-11-01 00:00:00 | 1999-12-31 00:00:00 |  |  |  |  |  |  |  |  | 6
2000-01-01 00:00:00 | 2001-06-30 00:00:00 |  |  |  |  |  |  |  |  | 7
2001-07-01 00:00:00 | 2007-06-30 00:00:00 |  |  |  |  |  |  |  |  | 7
2007-07-01 00:00:00 | 2008-06-30 00:00:00 |  |  |  |  |  |  |  |  | 7
2008-07-01 00:00:00 | 2009-06-30 00:00:00 |  |  |  |  |  |  |  |  | 7
2009-07-01 00:00:00 | 2010-06-23 00:00:00 |  |  |  |  |  |  |  |  | 8
2010-06-24 00:00:00 | 2011-05-31 00:00:00 |  |  |  |  |  |  |  |  | 8
2011-06-01 00:00:00 | 2012-05-31 00:00:00
2012-06-01 00:00:00 | 2015-12-31 00:00:00
2016-01-01 00:00:00 | 2016-12-31 00:00:00
2017-01-01 00:00:00 | 2017-12-31 00:00:00
2018-01-01 00:00:00 | 2018-12-31 00:00:00
2019-01-01 00:00:00 | 2019-12-31 00:00:00
2020-01-01 00:00:00 | 2020-12-31 00:00:00
2021-01-01 00:00:00 | 2021-12-31 00:00:00
2022-01-01 00:00:00 | 2022-12-31 00:00:00
2023-01-01 00:00:00 | 2023-12-31 00:00:00
Spreadsheet: 4bb2f867-6ce1-404d-9bb9-892730406f2b
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: |  |  | 2011-03-23 09:23:03.170000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.125 | 101.625 | 101.375 | 101.25 | 100.75 |  | and are added to price quote
5 | 101.199 | 100.949 | 100.824 | 100.324
4.875 | 100.695 | 100.445 | 100.32 | 99.82 |  | Note: | Refer To Price [NAME]
4.75 | 99.736 | 99.486 | 99.361 | 98.861 |  |  | For all Price Adjs
4.625 | 98.878 | 98.628 | 98.503
4.5 | 98.391 | 98.141 | 98.016
 |  |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  |  | Please note availability of
 |  |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  |  | Will apply.
 |  |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.375 | 101.861 | 101.611 | 101.486 | 100.986
4.25 | 101.299 | 101.049 | 100.924 | 100.424
4.125 | 100.286 | 100.036 | 99.911 | 99.411
4 | 99.956 | 99.706 | 99.581 | 99.081
3.875 | 99.517 | 99.267 | 99.142
 |  |  |  |  |  | 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: |  |  | 2011-03-23 09:23:03.170000
 |  |  |  |  |  | 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 | 2011-04-06 09:23:03.170000
30 DAY | 2011-04-21 09:23:03.170000
45 DAY | 2011-05-06 09:23:03.170000
60 DAY | 2011-05-21 09:23:03.170000
90 DAY | 2011-06-20 09:23:03.170000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 719913d1613906892-countifs-unique-values-for-one-criteria-countifs-ques
Sheet: Sheet1

 |  |  | Name | Region | Product
 |  |  | [NAME] | South | Widget
 |  |  | [NAME] | North | Straw |  |  |  | Total Widget Sold/South |  |  | =COUNTIFS(F4:F27,"Widget",E4:E27,"South")
 |  |  | Louis | North | Pencil |  |  |  | Unique Names that sold widget/South |  |  | ???
 |  |  | [NAME] | South | Tape
 |  |  | Sue | East | Widget
 |  |  | [NAME] | South | Widget
 |  |  | [NAME] | South | Bottle
 |  |  | Sue | South | Widget
 |  |  | [NAME] | West | Tape
 |  |  | Sue | North | Pencil
 |  |  | [NAME] | South | Widget
 |  |  | Louis | East | Jar
 |  |  | [NAME] | West | Bottle
 |  |  | [NAME] | South | Widget
 |  |  | [NAME] | North | Pencil
 |  |  | [NAME] | South | Widget
 |  |  | [NAME] | East | Jar
 |  |  | [NAME] | West | Widget
 |  |  | [NAME] | West | Pencil
 |  |  | Sue | South | Widget
 |  |  | [NAME] | South | Straw
 |  |  | Louis | East | Tape
 |  |  | [NAME] | West | Straw
 |  |  | [NAME] | South | Widget
Spreadsheet: 713043d1610539396-random-allocation-require-to-be-based-on-few-criteria-sample
Sheet: Allocation

Position |  | Position
 | Packing - station 1L
1
 |  |  | Putting - station 1
 |  | 5
2
 | Packing - station 1R
 | Packing - station 2L
3
 |  |  | Putting - station 2
 |  | 6
4
 | Packing - station 2R
Spreadsheet: 874335d1720911354-help-with-formulas-to-calculate-mark-up-x-of-action-sold-from-1-column-p2stake-sample-files
Sheet: table to file

Apr 12. 23:45 -Apr 13. 01:11
 | Daily Hyper $100
Prize Pool Players Guaranteed $1,750 ([NAME]in $92 + $8 [NAME],ion 01:26:33
® | Info £> Players (V Staking | ^ Prop Bet
Rank | Player | Flag | Result
1 | [NAME] | 1 | S1.133.44
2 | betman 95 | - | 842.72
3 | samjin | H | 626.57
4 | [NAME] | — | 465.87
5 | coolme | — | 346.38
Spreadsheet: 155136d1336678408-how-to-calculate-night-shift-hours-sample
Sheet: Time Sheet

 |  |  | TIME REPORT
Employee Name: |  |  |  | Role: |  | Period Ending (Month/Day/Year):
Date | Start Time | End Time | Hours worked | Overtime  (> 8 hours) | Night Shift Differential  (# of hours worked between 10pm & 6am) |  | Notes |  | Regular Hours
2012-04-01 00:00:00 | 13:00:00 | 1900-01-01 00:00:00 | 10 | 2 |  |  |  |  | 8
2012-04-02 00:00:00 | 13:00:00 | 22:00:00 | 8 | 0
2012-04-03 00:00:00 | 13:00:00 | 04:00:00 | 14 | 6
2012-04-04 00:00:00 | 13:00:00 | 22:00:00 | 8 | 0
2012-04-05 00:00:00 | 13:00:00 | 22:00:00 | 8 | 0
2012-04-06 00:00:00 | 13:00:00 | 22:00:00 | 8 | 0
2012-04-07 00:00:00 | 13:00:00 | 07:00:00 | 17 | 9
2012-04-08 00:00:00 | 13:00:00 | 22:00:00 | 8 | 0
2012-04-09 00:00:00 | 13:00:00 | 22:00:00 | 8 | 0
2012-04-10 00:00:00 | 13:00:00 | 22:00:00 | 8 | 0
2012-04-11 00:00:00 | 13:00:00 | 22:00:00 | 8 | 0
2012-04-12 00:00:00 | 13:00:00 | 22:00:00 | 8 | 0
2012-04-13 00:00:00 | 13:00:00 | 06:00:00 | 16 | 8
2012-04-14 00:00:00 | 13:00:00 | 22:00:00 | 8 | 0
2012-04-15 00:00:00 | 13:00:00 | 22:00:00 | 8 | 0
Totals |  |  | 145 | 25
Employee Signature: |  |  | Date: |  |  | Approved by: