tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 305abcbf-e0c2-4b2a-9a96-aea88939b6ae
Sheet: SRP Goverment

 |  | FHA  /  VA  /  RD
Correspondent Banks - Effective April 1, 2011
Tier 1 (AL, AR, FL, GA, IN, KS, KY, LA, MO, MS, ND, NE, OH, OK, PA, TX, WI)
 |  |  |  |  | Fixed Rate Fully Amortizing
FHA / VA / RD Loan Amount |  |  |  |  | 30/20 |  | 15
Less than $50,000 |  |  |  |  | 2.05 |  | 1.29
$50,000 to $99,999 |  |  |  |  | 2.65 |  | 1.89
$100,000 to $149,999 |  |  |  |  | 2.95 |  | 2.19
$150,000 to 417,000 |  |  |  |  | 3.05 |  | 2.29
[NAME] (AK, CT, DE, IA, MA, ME, MI, NC, NH, NY, RI, SC, SD, TN, UT, VT, WY)
Less than $50,000 |  |  |  |  | 1.95 |  | 1.19
$50,000 to $99,999 |  |  |  |  | 2.55 |  | 1.79
$100,000 to $149,999 |  |  |  |  | 2.85 |  | 2.09
$150,000 to 417,000 |  |  |  |  | 2.95 |  | 2.19
Tier 3 (AZ, CA, CO, DC, HI, ID, IL, MD, MN, MT, NJ, NM, NV, OR, VA, WA, WV)
Less than $50,000 |  |  |  |  | 1.85 |  | 1.09
$50,000 to $99,999 |  |  |  |  | 2.45 |  | 1.69
$100,000 to $149,999 |  |  |  |  | 2.75 |  | 1.99
$150,000 to 417,000 |  |  |  |  | 2.85 |  | 2.09
FHA Loans Underwritten by TIB
$450 Underwriting Fee
$100 Insuring Fee
FHA Loans Underwritten by Correspondent's DE
$150  Administrative Fee
$105 Tax Certification Fee all States
$40 Fraud Prevention Fee - Correspondent Banks
Spreadsheet: 11a177d5-5f98-45f2-bfe1-b64228f60bec
Sheet: Block 10

Block 10
Sub-mainline Sizing and Pressure
 | 150 | C-value for PVC ID > 5"
 | 145 | C-value for PVC 1.5" < = ID < =  5"
 | 140 | C-value  for PVC < 1.5"
 | 5 | feet, Total Elevation Drop
 |  | feet, Length of Sub-mainline
 |  | ft/ft, Change in Elevation
 | 0.5 | GPH/emitter
 |  | GPM/emitter
 |  | ft, emitter spacing
 | Chg. Elev = Length * ft/ft (elevation change worst case)
 | Chg. P = Chg. Elev + Hf
Section A Uphill
Row | Row Length ft | GPM per Row | Pressure PSI | Length ft | GPM | Pipe ID, in | Velocity, ft/sec | C-Value | Hf (psi) | Chg. Elev (psi) | Chg. P (psi)
Inlet | 0 | 0 | 25 | 0 | 42.7 | 2.193
1 | 144.7 |  |  | 249.6 |  | 2.193
 | 135.1 |  |  | 7.7 |  | 2.193
 | 125.4 |  |  | 7.7 |  | 2.193
 | 115.8 |  |  | 7.7 |  | 2.193
 | 106.1 |  |  | 7.7 |  | 2.193
 | 96.5 |  |  | 7.7 |  | 2.193
 | 86.8 |  |  | 7.7 |  | 2.193
 | 77.2 |  |  | 7.7 |  | 2.193
 | 67.5 |  |  | 7.7 |  | 2.193
 | 57.9 |  |  | 7.7 |  | 2.193
 | 48.2 |  |  | 7.7 |  | 2.193
 | 38.6 |  |  | 2.3 |  | 2.193
 | 28.9 |  |  | 7.7 |  | 2.193
 | 19.3 |  |  | 7.7 |  | 2.193
 | 9.7 |  |  | 7.7 |  | 2.193
Section A Downhill
 | 756.1 |  |  | 249.6 | 42.7 | 2.193
 | 736.6 |  |  | 7.7 |  | 2.193
 | 717.1 |  |  | 7.7 |  | 2.193
 | 697.6 |  |  | 7.7 |  | 2.193
 | 678.1 |  |  | 7.7 |  | 2.193
 | 658.6 |  |  | 7.7 |  | 2.193
 | 639 |  |  | 7.7 |  | 2.193
 | 619.5 |  |  | 7.7 |  | 2.193
 | 600 |  |  | 7.7 |  | 2.193
 | 580.5 |  |  | 7.7 |  | 2.193
 | 561 |  |  | 7.7 |  | 2.193
 | 548.9 |  |  | 7.7 |  | 2.193
 | 541.8 |  |  | 7.7 |  | 2.193
 | 534.7 |  |  | 7.7 |  | 2.193
 | 527.2 |  |  | 7.7 |  | 2.193
 | 520.6 |  |  | 7.7 |  | 2.193
Section B
 | 503.8 |  |  | 12.4 |  | 1.72
 | 487.1 |  |  | 12.5 |  | 1.72
 | 470.4 |  |  | 12.5 |  | 1.72
 | 453.6 |  |  | 12.5 |  | 1.72
 | 436.9 |  |  | 12.5 |  | 1.72
 | 420.2 |  |  | 12.5 |  | 1.72
 | 403.4 |  |  | 12.5 |  | 1.72
 | 380.4 |  |  | 12.5 |  | 1.72
Section C
 | 325.3 |  |  |  |  | 1.72
 | 260.5 |  |  | 30 |  | 1.72
 | 193.7 |  |  | 30 |  | 1.72
 | 126.3 |  |  | 30 |  | 1.72
 | 58.9 |  |  | 30 |  | 1.72
 |  | Min P |  | PSI
 |  | [NAME] |  | PSI
 |  | Avg. P, PSI |  | PSI
 | Total GPM
 | Sub-Main Length, ft
Spreadsheet: 783895d1655282959-combine-multiple-lists-in-an-overview-activities-list
Sheet: Group A

 | Task-list
 | Group A |  |  |  |  |  |  |  |  | Klart
 |  |  |  |  |  |  |  |  |  | Pågår
 | Place | Activity | Comments | Responsible | Status | Date
 | [NAME] | Correct lights | The lights do not work making the place dark and unsafe | [NAME] | Pågår | 2022-June
 | Sollentuna | Tunnel damage | Damaged wall, needs to be reapired | Gustav | Klart | 2022-June
Spreadsheet: bc228119-c133-4ede-bda9-645cd4cc9ad9
Sheet: EPR Adj ICO new

Reconciliations of GAAP to Non-GAAP Measures (In millions, except EPS)
 |  | Quarters Ended |  |  |  | Six Months Ended
 |  | March 31, |  |  |  | March 31,
 |  | 2012 |  | 2011 |  | 2012 |  | 2011
Adjusted Income from Continuing Operations
GAAP income from continuing operations |  | 62.4 |  | 67.7 |  | 112.7 |  | 140.5
Acquisition related charges (primarily related to [NAME])
Contingent retention & earn-out | Contingent acquisition related costs | 11.7 |  | 0 |  | 11.7 |  | 0
Amortization of intangibles | Cost of gaming operations | 2.3 |  | 0 |  | 2.3 |  | 0
Amortization of intangibles | Depreciation & amortization | 3.9 |  | 0 |  | 3.9 |  | 0
Professional fees | Selling, general & administrative | 4.5 |  | 0 |  | 5.7 |  | 0
Severance | Selling, general & administrative | 1.2 |  | 0 |  | 1.2 |  | 0
Distributor settlement | Selling, general & administrative | 3.1 |  | 0 |  | 3.1 |  | 0
Investment gain (no tax benefit) | Other income (expense), net | 0 |  | 0 |  | 0 |  | -4.3
Total adjustments before tax |  | 26.7 |  | 0 |  | 27.9 |  | -4.3
Tax effect at 36% | Income tax provision | -9.598099999999999 |  | 0 |  | -10.0355 |  | 0
Certain discrete tax items (benefits) | Income tax provision | 0 |  | 0 |  | 0 |  | -7
Total adjustments after tax |  | 17.1019 |  | 0 |  | 17.8645 |  | -11.3
Adjusted income from continuing operations |  | 79.5019 |  | 67.7 |  | 130.5645 |  | 129.2
Adjusted EPS from Continuing Operations
GAAP EPS from continuing operations |  | 0.21 |  | 0.22 |  | 0.3801 |  | 0.47
Acquisition related charges:
Contingent retention & earn-out |  | 0.03 |  | 0 |  | 0.03 |  | 0
Amortization of intangibles |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles |  | 0.01 |  | 0 |  | 0.01 |  | 0
Professional fees |  | 0.01 |  | 0 |  | 0.01 |  | 0
Severance |  | 0 |  | 0 |  | 0 |  | 0
Distributor settlement |  | 0.01 |  | 0 |  | 0.01 |  | 0
Investment gain |  | 0 |  | 0 |  | 0 |  | -0.01
Certain discrete tax items (benefits) |  | 0 |  | 0 |  | 0 |  | -0.03
Total adjustments |  | 0.06 |  | 0 |  | 0.06 |  | -0.04
Adjusted EPS from continuing operations |  | 0.27 |  | 0.22 |  | 0.4401 |  | 0.43
Adjusted income from continuing operations and adjusted EPS from continuing operations are supplemental non-GAAP financial measures commonly used by management and industry analysts to evaluate our financial performance.  Adjusted income from continuing operations should not be construed as an alternative to income from continuing operations, and Adjusted EPS from continuing operations should not be construed as an alternative to EPS from continuing operations, as indicators of our operating performance determined in accordance with GAAP (generally accepted accounting principles).  All companies do not calculate Adjusted income from continuing operations or Adjusted EPS from continuing operations in the same manner, and IGT's presentation may not be comparable to that of other companies.
Spreadsheet: 874697d1721232856-if-function-to-compare-multiple-tabs-rswlaw67-bills-by-pay-cycle
Sheet: Due

Pay Cycle | Amount Due
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Spreadsheet: 167114d1341907591-vlookup-all-repeated-text-under-same-name-vlookup-repeated-text
Sheet: Sheet3

Name | Color
[NAME] | blue
[NAME] | yellow
[NAME] | red
[NAME] | green
[NAME] | yellow
Christine | white
Christine | black
Darcy | black
Darcy | purple
Darcy | pink
Darcy | orange
Spreadsheet: 800294d1665583832-formula-to-count-if-one-or-more-criteria-are-met-test-fop
Sheet: SAMPLE

 |  |  |  |  | Test Date: |  | 2019-03-28 00:00:00
 | Contractor: |  |  |  | Operator Name:
 | Instrument Mfg. |  |  |  | CEI:
 | Model: | 3640 |  |  | CEI Name:
 | Serial # | 188778QEDV |  |  | Station: |  | 236494 |  |  | Direction: |  |  | NB
 | Calibration Date: | 2018-10-31 00:00:00 |  |  | Device: |  | CCTV
 | Test Conditions
 |  |  |  |  |  |  |  |  |  | 68
 |  | Soil Condition: |  |  | Moist |  | Dry |  | Temperature |  | F
 |  |  |  |  | Clay |  | Limestone |  | Sand & Gravel
 |  | Soil Type: |  |  | Granite |  | Shale |  | Sandstone
 |  | (choose one) |  |  | [NAME] |  | Slate |  | Other | SOD/Dirt
 |  |  |  |  | Single Rod |  | [NAME] | 20
 |  | Grounding System: |  |  | [NAME] (Grid)
 |  |  |  |  | Longest Diagonal Distance |  |  | 40
 | Z Electrode
 | Minimum Distance: |  | 300
 | Y Electrode Distance |  | Measured Resistance | Percentage Difference
 | % | Feet | Ohms
 | 10 |  | 0
 | 20
 | 30
 | 40
 | 52 |  | 5.86
 | 62 |  | 5.96
 | 72 |  | 6.1
 | 80
 | 90 |  | 15
 |  |  |  |  | Effective Grounding Electrode Resistance: |  |  | Ohms
Spreadsheet: 35624d1233209092-dynamic-spreadsheet-applesbananas
Sheet: Apple

Apple | B | C | D | E | F | G
H | 4300840 |  |  | 4
I | 1075896 |  |  | 4
J | 271172 |  |  | 24
K | 67405 |  |  | 55
L | 16816 |  |  | 80
M | 3952 |  |  | 1900
N | 1835 |  |  | 2500
x | 20
x | 50
x | 0
 |  |  |  |  | x
 |  |  |  |  | x
 |  |  |  |  | x
Spreadsheet: 162931d1340120854-help-with-index-match-book1_jakezp
Sheet: Sheet1

Cost Center | Employee nr | Surname | First name
ELPX1 | A002 | [NAME] | [NAME]
ELPX1 | A002 | [NAME] | [NAME]
NPSX3 | A003 | [NAME] | Dina
NPSX3 | A004 | [NAME] | [NAME]
ELPX1 | A006 | [NAME] | [NAME]
GRPH8 | A005 | [NAME] | Lewis
ELPX1 | A002 | [NAME] | [NAME]
NPSX3 | A003 | [NAME] | Dina
GRPH8 | A005 | [NAME] | Lewis
Spreadsheet: 709589d1608417969-compare-to-cells-bouwcenter-poule-f1-2021-v1
Sheet: Stand

Stand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Toaal
# | Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  |  |  | Punten
1 |  | 25
2 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pole Position | 50
3 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Snelste ronden | 18
4 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eeste uitvaller | 10
5 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Snelste Pitstop | 10
6 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Best of the rest | 25
7 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 25
8 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 18
9 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 15
10 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wereldkampioen | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contstructers | 100
Spreadsheet: 690689d1597238705-change-sender-address-with-basic-formula-to-send-email-via-excel-book1
Sheet: Sheet1

[NAME] |  | From account |  | to | cc | Bcc |  | subject |  | body text
 |  | [EMAIL] |  | [EMAIL] | [EMAIL] | [EMAIL] |  | VCxcvX |  | sdfcgvh
 |  | [EMAIL] |  | [EMAIL] | [EMAIL] | [EMAIL] |  | [NAME] |  | nhdgrse
Spreadsheet: 219218d1362686422-if-else-if-or-easier-recommendation-samplebook
Sheet: Comish Calc

Commission Report
Sub Pro | 518
Month | 3
Row Labels | Sum of Points | Total Items | Premium
Name | 10 | 1 | 606.03
111111111 | 10 | 1 | 606.03
[NAME] | 100 | 1 | 750.65
222222222 | 100 | 1 | 750.65
Grand Total | 110 | 2 | 1356.68
Potential Commission =
Bonus Payout =
Total Payout =
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: Canada

CANADA | ok
[NAME] |  |  |  | 7000
Kitagawa |  |  |  | 200000
Wilson |  |  |  | 50000
[NAME] |  |  |  | 35000
Sangermano |  |  |  | 6000
Dunsmore |  |  |  | 5000
Laporte |  |  |  | 5000
Torres |  |  |  | 5000
Messenger |  |  |  | 3000
Cooke |  | 11 |  | 5000
Power Orig
Biever, [NAME] | Analyst |  |  | 50000
Lalani | Analyst |  |  | 7500
Savidant | Analyst | 3 |  | 15000
Milnthorp | Pres, CEO | 1
Davies | Vice Pres | 1
 | TOTAL | 5
Gas Orig
Burnham | Manager |  |  | 18750
[NAME] | Manager |  |  | 50000
Hrap | Manager |  |  | 21250
Le Dain | Manager
Oh | Manager |  |  | 75000
Sangwine | Manager | 6 |  | 100000
Trading
Brodeur | Analyst
[NAME] | Analyst
Draper | Analyst
[NAME] | Analyst |  |  | 5000
Watt | Analyst | 5
Richey | Associate | 1
Cowan | Director
[NAME] | Director | 2
Dorland | Manager | 1
Tripp (Toronto) | Spec | 1 |  | 40000
Zufferli | Vice Pres | 1
 | TOTAL | 11
Toronto
Dorland | Analyst | 1 |  | 25000
Borg | Director | 1 |  | 150000
Ellis | Manager | 1 |  | 50000
DeVries | Vice Pres | 1
 | TOTAL | 4
 | GRAND TOTAL | 37
Spreadsheet: 725801d1616870076-if-formula-if-formula-1
Sheet: Sheet1

I want a formula that if Column B= "Amount Paid" then Column H = Column G. If column B= "Amount Due" then Column H = 0
Desired Outcome
Date | Txs | Customer Code | Customer Name | Receipt | Invoice | Amount | Paid
2021-01-11 00:00:00 | Amount Paid |  | RUVARASHE TARUVINGA | 30 | 680 | 11500 | 11500
2021-01-13 00:00:00 | Amount Due |  | [NAME] |  | 95 | 20000 | 0
2021-01-15 00:00:00 | Amount Paid |  | RUVARASHE TARUVINGA | 31 | 683 | 2000 | 2000
Spreadsheet: 75381d1275959688-how-to-make-hide-0-with-blanks-but-still-keeping-its-value-in-the-cell-testing
Sheet: Balance

Date | Ver | [NAME] | Total On Hand |  |  |  |  |  |  |  | Remarks
 |  |  | A | B | C | D | E | F | G | H
 |  | Item 1
 |  | Item 2
 |  | Item 3
 |  | Item 4
 |  | Item 5
 |  | Item 6 | 16
Spreadsheet: 127a02cf-3b49-45db-b3ba-8eab8638b8a7
Sheet: Sheet1

74680 | WGS | 200 | 19Z1 | Intro to Wmen's Gnd Std Soc Sc | BLC |  | BW | 2014-01-13 00:00:00 | 2014-05-10 00:00:00 | WWW | TBA
74681 | WGS | 200 | 19Z2 | Intro to Wmen's Gnd Std Soc Sc | BLC |  | BW | 2014-01-13 00:00:00 | 2014-05-10 00:00:00 | WWW | TBA
74682 | WGS | 200 | 19Z3 | Intro to Wmen's Gnd Std Soc Sc | BLC |  | BW | 2014-01-13 00:00:00 | 2014-05-10 00:00:00 | WWW | TBA
74683 | WGS | 200 | J001 | Intro to Wmen's Gnd Std Soc Sc | BLC | TR | BP | 2014-01-13 00:00:00 | 2014-05-10 00:00:00 | J0ATB116 | 09:30 AM | 10:45 AM
74684 | WGS | 201 | 1501 | [NAME] [NAME] | BLCLEESTWN | MW | BP | 2014-01-13 00:00:00 | 2014-05-10 00:00:00 | 15BLDM122C | 11:00 AM | 12:15 PM
74685 | WGS | 201 | 19Z1 | [NAME] [NAME] | BLC |  | BW | 2014-01-13 00:00:00 | 2014-05-10 00:00:00 | WWW | TBA
74686 | WGS | 201 | 19Z2 | [NAME] [NAME] | BLC |  | BW | 2014-01-13 00:00:00 | 2014-05-10 00:00:00 | WWW | TBA
74687 | WGS | 201 | 19Z3 | [NAME] [NAME] | BLC |  | BW | 2014-01-13 00:00:00 | 2014-05-01 00:00:00 | WWW | TBA
74688 | WGS | 201 | 19Z4 | [NAME] [NAME] | BLC |  | BW | 2014-01-13 00:00:00 | 2014-05-10 00:00:00 | WWW | TBA
74689 | WGS | 201 | J001 | [NAME] [NAME] | BLC | MW | BP | 2014-01-13 00:00:00 | 2014-05-10 00:00:00 | J0ATB116 | 02:00 PM | 03:15 PM
74690 | WGS | 201 | J002 | [NAME] [NAME] | BLC | TR | BP | 2014-01-13 00:00:00 | 2014-05-10 00:00:00 | J0ATB116 | 11:00 AM | 12:15 PM
74691 | WGS | 201 | J101 | [NAME] [NAME] | BLCNEWTOWN | MW | BP | 2014-01-13 00:00:00 | 2014-05-10 00:00:00 | J1NCB002 | 09:30 AM | 10:45 AM
74692 | WGS | 201 | J281 | [NAME] [NAME] | BLCWNCHTR | MW | BP | 2014-01-13 00:00:00 | 2014-05-10 00:00:00 | J2WIN114 | 03:30 PM | 04:45 PM
Spreadsheet: 183583d1348869256-n-blank-cells-between-cella-and-cellb-or-another-way-to-deterimine-if-soil-has-time-todry-rainfallsoilsheet
Sheet: Sheet1

Date |  | 2005
 | Day # | Rain | Days to Dry |  | Work Day?
 |  |  | Added | Left
2012-01-01 00:00:00 | 1 | 0 | 0 | cbd | cbd
2012-01-02 00:00:00 | 2 | 1.11 | 14.90113636363636
2012-01-03 00:00:00 | 3 | 0 | 0
2012-01-04 00:00:00 | 4 | 0 | 0
2012-01-05 00:00:00 | 5 | 0.29 | 3.34659090909091
2012-01-06 00:00:00 | 6 | 0.01 | 0
2012-01-07 00:00:00 | 7 | 0.11 | 0.8102272727272729
2012-01-08 00:00:00 | 8 | 0 | 0
2012-01-09 00:00:00 | 9 | 0 | 0
2012-01-10 00:00:00 | 10 | 0 | 0
2012-01-11 00:00:00 | 11 | 0.01 | 0
2012-01-12 00:00:00 | 12 | 0.9500000000000001 | 12.64659090909091
2012-01-13 00:00:00 | 13 | 0.01 | 0
Spreadsheet: 864525d1711653229-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-2024-03-22-mattg-
Sheet: Game 8

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1)
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  |  | C (2)
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  |  | 1B (3)
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  |  | 2B (4)
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  |  | 3B (5)
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  |  | SS (6)
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  |  | LF (7)
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  |  | CF (8)
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  |  | RF (9)
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  |  | SF (10)
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  |  | EH ()
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 262016d1377895030-choosing-one-of-the-duplicate-customer-info-testworkbook
Sheet: Sales

Salesman | CUSTOMER | CHANGE DATE | SOLD DATE | CONTRACT | STATUS | NET VOLUME
[NAME] | 2012 A J And Carol Manker Family Trust Dated 06/22/2012,  9-180038527 | 2013-03-09 00:00:00 | 2013-03-09 00:00:00 | 16684645 | GOOD | 10196
VIOLETTA | Abalos, Heather Oro 9-178537891 | 2013-03-20 00:00:00 | 2013-03-20 00:00:00 | 16687558 | GOOD | 13760
VIOLETTA | Abalos, Heather Oro 9-178537891 | 2013-05-08 00:00:00 | 2013-03-20 00:00:00 | 16687558 | CANCEL | -13760
SHARON | Abantao, [NAME] 9-178524376 | 2013-03-30 00:00:00 | 2013-03-30 00:00:00 | 16690348 | GOOD | 20499
MARILYN | Abshire, Kimberly D 9-175949879 | 2012-11-18 00:00:00 | 2012-11-18 00:00:00 | 16659635 | GOOD | 9770
STEVE | Academia, [NAME] | 2013-08-04 00:00:00 | 2013-08-04 00:00:00 | 16870401 | GOOD | 14420
STEVE | Academia, [NAME] | 2013-08-10 00:00:00 | 2013-08-04 00:00:00 | 16870401 | CANCEL | -14420
RUBEN | Acosta, Josafath 9-177958678 | 2013-01-19 00:00:00 | 2013-01-19 00:00:00 | 16673452 | PENDING | 7000
RUBEN | Acosta, Josafath 9-177958678 | 2013-01-28 00:00:00 | 2013-01-19 00:00:00 | 16673452 | CANCEL | -7000
WILLIAM | Adams, Jr, [NAME] 9-178588989 | 2013-03-17 00:00:00 | 2013-03-17 00:00:00 | 16686589 | GOOD | 14420
VERONICA | Adams, Lannia Alvanie 9-178968403 | 2013-05-04 00:00:00 | 2013-05-04 00:00:00 | 16701220 | PENDING | 2420
VERONICA | Adams, Lannia Alvanie 9-178968403 | 2013-05-14 00:00:00 | 2013-05-04 00:00:00 | 16701220 | CANCEL | -2420
Spreadsheet: 760662d1640369250-find-last-non-0-cell-in-table-and-do-some-calculations-how
Sheet: Blad1

 |  | datum | wissel | [NAME]
 |  | 2021-12-24 00:00:00 | 0 | 5
 |  | 2021-12-24 01:00:00 | 0 | 6
 |  | 2021-12-24 01:59:59.990000 | 0 | 3
 |  | 2021-12-24 02:59:59.985000 | 0 | 6
 |  | 2021-12-24 03:59:59.980000 | 0 | 3
 |  | 2021-12-24 04:59:59.975000 | 0 | 5
 |  | 2021-12-24 05:59:59.970000 | 0 | 9 |  |  | List is growing
 |  | 2021-12-24 06:59:59.965000 | 0 | 8 |  |  | Date of wissel from button up
 |  | 2021-12-24 07:59:59.960000 | 0 | 5 |  |  | kg from wissel til last cell
 |  | 2021-12-24 08:59:59.955000 | wissel | 6
 |  | 2021-12-24 09:59:59.950000 | 0 | 9
 |  | 2021-12-24 10:59:59.945000 | 0 | 3
 |  | 2021-12-24 11:59:59.940000 | 0 | 6
 |  | 2021-12-24 12:59:59.935000 | 0 | 9
 |  | 2021-12-24 13:59:59.930000 | 0 | 4
 |  | 2021-12-24 14:59:59.925000 | 0 | 1
 |  | 2021-12-24 15:59:59.920000 | 0 | 4
 |  | 2021-12-24 16:59:59.915000 | 0 | 5
 |  | 2021-12-24 17:59:59.910000 | 0 | 6
 |  | 2021-12-24 18:59:59.905000 | 0 | 5
 |  | 2021-12-24 19:59:59.900000 | 0 | 4
 |  | 2021-12-24 20:59:59.895000 | 0 | 8
 |  | 2021-12-24 21:59:59.890000 | 0 | 7
Spreadsheet: 33175d1229457849-nested-if-functions-roman-3c
Sheet: Sheet1

 |  |  |  | Hardware |  | 2320
Customer
Client Name
Reference No.
Finished drop of blind |  |  |  | 1860 | 45 | 1815 | [NAME]
 |  |  |  | 1815
Divided by number of pockets |  |  |  | 6.5
 |  | 6 | x | 279.2307692307692 | 279.2307692307692 |  | [NAME]
 |  | 1 | x | 139.6153846153846 |  |  | [NAME]
turnings of 50mm for top of blind
Start first pocket measurment ! [NAME] down from start point on blind
Turnings of 100mm for bottom of blind
Spreadsheet: 777172d1650229782-warehouse-movements-proposal-combine-two-tables-and-fullfill-sample-warehouse-movements-proposal-tkon1982-
Sheet: Sheet1

 |  |  |  | Product | A | A | A | B | B | C
 |  |  |  | QtyAllowedToTake | 50 | 5 | 11 | 16 | 3 | 10
 |  |  |  | WarehouseIdTaker | 200 | 203 | 202 | 202 | 202 | 300
 |  |  |  | Rank | 1 | 2 | 3 | 4 | 5 | 6 |  | Cumul. Ct
Product | QtyAllowedToGive | WarehouseIdGiver | Rank
A | 30 | 100 | 1
A | 30 | 101 | 2
A | 10 | 102 | 3
B | 10 | 200 | 4
B | 20 | 201 | 5
D | 2 | 30 | 6
Product | QtyAllowedToTake | WarehouseIdTaker | Rank | Cumul. Ct
A | 50 | 200 | 1
A | 5 | 203 | 2
A | 11 | 202 | 3
B | 16 | 202 | 4
B | 3 | 202 | 5
C | 10 | 300 | 6
Result Needed
Product | QtyToMove | WarehouseIdGiver | WarehouseIdTaker |  | Product | QtyToMove | WarehouseIdGiver | WarehouseIdTaker
A | 30 | 100 | 200
A | 20 | 101 | 200
A | 5 | 101 | 203
A | 5 | 101 | 202
A | 6 | 102 | 202
B | 10 | 200 | 202
B | 9 | 201 | 202
Spreadsheet: 0128f149-dedd-4101-81c0-77ff673bfae2
Sheet: Non-Traditional

IRN (if applicable): |  |  |  |  |  |  |  | APPLICANT:
APPLICANT:
 |  | FY14 | FY16 | FY17 | FY18 | FY19 | FY20 | EXPLAINATION
Do not alter any of the shaded cells. |  | Financial Baseline from the Current Fiscal Year | Since FY15 is the grant year, its expenditures are not required in this table.  In the FY16-FY20 columns, ADD only the SUSTAINING COSTS  to the appropriate line items (refer to Question 15), and SUBTRACT only the SUSTAINING COST REDUCTIONS to the appropriate line items (refer to Questions 16 & 17). |  |  |  |  | Explaination  Provide detailed notes regarding the financial impact on each line affected by the grant funds.  These notes are critical to the evaluation of the financial sustainability.
EXPENDITURES |  | FY14 | FY16 | FY17 | FY18 | FY19 | FY20
100 | Salaries and Wages
200 | Employee Retirement and Insurance Benefits
400 | Purchased Services
500 | Supplies and Materials
600 | Capital Outlay - New
700 | Capital Outlay - Replacement
800 | Other Operating Disbursements
SUSTAINABILITY |  | FY14 | FY16 | FY17 | FY18 | FY19 | FY20
 | TOTAL EXPENDITURES  For FY16-20, total expenditures must be cost neutral (e.g. $0 or less) to prove sustainability.