tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 164520d1340803133-excel-2007-trying-to-build-a-time-sheet-work-book-and-am-stuck-on-seperating-the-day-and-night-shift-new-project-pay-roll-and-time-sheet-beta-day-night-test
Sheet: Monday Night Timesheeet

 |  |  | TRI TOOL INC.
 | Customer: |  |  |  |  |  |  |  |  | CUSTOMER CONTACT: |  |  |  |  |  | JOB NO: |  |  |  |  |  | Home Page
 | Work Location: |  |  |  |  |  |  |  |  | CUST. P.O. NO. |  |  |  |  |  | DATE:
 | Employee: |  |  |  |  | TOTAL HRS: |  | WORK [NAME]/WORK ORDER NO. |  |  |  |  |  |  |  |  | CONSUMABLES: |  |  |  |  | Payroll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUAN: | PART NO:
 |  |  |  |  | Verify the following SAFTY ITEM CHECKLIST as required on this site. |  |  |  |  |  |  |  |  | Equipment Usage: |  |  |  |  | Tech Initial
 |  | NO | YES
 |  |  |  | 1 | If required, has the site specific training been completed?
 |  |  |  | 2 | If permits are required, do you have the proper papers?
 |  |  |  | 3 | Is Scaffolding correct and safe?
 |  |  |  | 4 | If lockout is required, has the proper procedure been followed?
 |  |  |  | 5 | Do you know the emergency signals?
 |  |  |  | 6 | Do you know the escape routes and assembley points?
 |  |  |  | 7 | Are safety glasses required?
 |  |  |  | 8 | Is a face sheild required?
 |  |  |  | 9 | Is a hard hat required?
 |  |  |  | 10 | Are flame resistant clothes required?
 |  |  |  | 11 | Is hearing protection required?
 |  |  |  | 12 | Are safety toed shoes required?
 |  |  |  | 13 | Are respirators required? |  |  |  |  |  |  |  |  | SIGNATURES:
 |  |  |  | 14 | Is fall protection equipment required?
 |  |  |  | 15 | Other: |  |  |  |  |  |  |  | CUSTOMER:
 |  |  |  |  |  |  |  |  |  |  |  |  | TRI TOOL:
Spreadsheet: 116880d1312257147-calculate-by-specific-font-color-sumbyfontcolor
Sheet: Sheet1

 | Data Column | Custom Function
 | 7.072633350042445 | 360.8225402406813 | Red cells total
 | 60.04722314707047 | 784.988501005667 | Black cells total
 | 74.8992863592906
 | 47.60509059216815
 | 62.84347448093914
 | 13.30390377465447
 | 50.56267916337207
 | 23.80745799471062
 | 1.633460132774567
 | 37.48491919864634
 | 23.54918673308632
 | 76.62420402353787
 | 88.72980046787471
 | 12.94734600094092
 | 5.033252205957428
 | 99.63303512654396
 | 1.721519274665795
 | 39.71580088847473
 | 18.30865062084532
 | 77.40440431824655
 | 78.6991327438676
 | 42.16034179770294
 | 8.854985644565971
 | 44.49886066566609
 | 88.17525248428623
 | 2.152300001428475
 | 31.41474678525151
 | 26.92809326973702
Spreadsheet: 820473d1678118473-stuck-with-an-easy-formula-many-variants-of-one-formula-for-one-cell-please-help-report-price-calculator
Sheet: Feuil1

WEIGHT | ROUNDED WEIGHT | FORMULA | PRICE in USD | VALUES WEIGHT RANGE 1 | VALUES WEIGHT RANGE 2 | VALUES PRICE
0.16 |  |  |  | 0.15 | 0.22 | 48
0.17 |  |  |  | 0.23 | 0.46 | 59
0.7 |  |  |  | 0.47 | 0.69 | 64
0.5 |  |  |  | 0.7 | 0.99 | 78
 |  |  |  | 1 | 1.19 | 113
 |  |  |  | 1.2 | 1.49 | 118
 |  |  |  | 1.5 | 1.99 | 135 |  |  | [NAME] | [NAME]
 |  |  |  | 2 | 2.99 | 189
 |  |  |  | 3 | 3.99 | 278
 |  |  |  | 4 | 4.99 | 373
 |  |  |  | 5 | 5.99 | 535
 |  |  |  | 6 | 7.99 | 631
 |  |  |  | 8 | 9.99 | 747
 |  |  |  | 10 | 11.99 | 1034
 |  |  |  | 12 | 14.99 | 1219
 |  |  |  | 15 | 19.99 | 1484
 |  |  |  | 20 | 24.99 | 1935
 |  |  |  | 25 | 29.99 | 2253
 |  |  |  | 30 | 39.99 | 2730
 |  |  |  | 40 | 49.99 | 3233
 |  |  |  | 50.00 and above | upon written request
Spreadsheet: 862553d1710251313-progress-bar-based-upon-hours-calculate-partial-and-full-day-hours-hwc-contractor-attendance-record
Sheet: 2024 Calendar View

 | HWC CONTRACTOR ATTENDANCE RECORD
 | Employee: |  |  |  |  |  |  |  |  |  | Base Year Period 09/15/2023 to 09/14/2024
 | Contract Base Year:
 | Weekday/Month | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU  2 | FRI | SAT
 | January
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 | KEY STATISTICS
 |  | Days on leave |  |  |  |  | Working days |  |  |  |  |  | Sick days |  |  |  |  | Personal days |  |  |  |  | Bereavement |  |  |  |  | Other
Spreadsheet: 889300d1740065890-90-percentile-formula-for-multiple-values-and-multiple-dates-that-vary-in-count-distance-percentiles
Sheet: Percentile by date

Date | 90 percentile
2022/01/01
2022/01/02 | 2267.974720516686
2022/01/03 | 2806.201038661276
2022/01/04 | 2672.88382308755
2022/01/05 | 2419.65578079733
2022/01/06 | 1732.94575795089
2022/01/07 | 2922.897030177127
2022/01/08 | 2513.014220515789
2022/01/09 | 2751.60269452873
2022/01/10 | 1637.745596527942
2022/01/11 | 2523.03666243675
2022/01/12 | 2087.576632362096
2022/01/13 | 2045.7744254927
2022/01/14 | 2229.856894073542
2022/01/15 | 2509.154306300356
2022/01/16 | 2597.01155176484
2022/01/17 | 2597.01155176484
2022/01/18 | 2940.9335252603
2022/01/19 | 2841.306064571967
2022/01/20 | 2477.709790847417
2022/01/21 | 2768.29947801895
2022/01/22 | 2805.4128701391
2022/01/23 | 1939.76830810079
2022/01/24 | 4419.561220073053
2022/01/25 | 4023.104399105639
2022/01/26 | 6696.615553036381
2022/01/27 | 1906.249030488436
2022/01/28 | 4649.034669011786
2022/01/29 | 2483.13921109861
2022/01/30 | 6883.794198105338
2022/01/31 | 1541.81775836186
Spreadsheet: 165292d1341146424-repeat-a-combination-of-rows-and-columns-example-2
Sheet: Sheet1

Row 1 | Row 2 |  |  |  |  |  |  |  |  |  | Expected Result
A | 1000 |  |  |  |  |  |  |  |  |  | A | 1000
B | ABCD |  |  |  |  |  |  |  |  |  | A | ABCD
C | X |  |  |  |  |  |  |  |  |  | A | X
DF |  |  |  |  |  |  |  |  |  |  | B | 1000
 |  |  |  |  |  |  |  |  |  |  | B | ABCD
 |  |  |  |  |  |  |  |  |  |  | B | X
 |  |  |  |  |  |  |  |  |  |  | C | 1000
 |  |  |  |  |  |  |  |  |  |  | C | ABCD
 |  |  |  |  |  |  |  |  |  |  | C | X
 |  |  |  |  |  |  |  |  |  |  | DF | 1000
 |  |  |  |  |  |  |  |  |  |  | DF | ABCD
 |  |  |  |  |  |  |  |  |  |  | DF | X
Spreadsheet: 163759d1340445709-excel-2007-different-rate-drop-from-same-drop-down-menu-book1_dj_seagal
Sheet: Sheet1

 |  |  | Amount |  |  |  |  |  |  |  |  | january | february | march | april | may
 |  | january | 250000 |  |  |  |  |  |  |  | Company A | 0.001 | 0.00055 | 0.00055 | 0.001 | 0.0013
 |  |  | 50000 |  |  |  |  |  |  |  | Company B | 0.00075 | 0.00075 | 0.00075 | 0.00075 | 0.00075
 |  |  |  |  |  |  |  |  |  |  | Company C | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002
 |  |  |  |  |  |  |  |  |  |  | Company D | 5e-05 | 5e-05 | 5e-05 | 5e-05 | 5e-05
Company Name | Y/N |  |  |  |  |  |  |  |  |  | Company E | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002
 |  |  | RATE % |  |  |  |  |  |  |  | Company F | 5e-05 | 5e-05 | 5e-05 | 5e-05 | 5e-05
Company A | Y |  |  |  |  |  |  |  |  |  | Company G | 0.0015 | 0.0015 | 0.0015 | 0.0015 | 0.002
Company B | Y |  |  |  |  |  |  |  |  |  | Company H | 0.0015 | 0.0015 | 0.0015 | 0.0015 | 0.002
Company C | Y |  |  |  |  |  |  |  |  |  | Company I | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 0.0001
Company D | Y |  |  |  |  |  |  |  |  |  | Company J | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 0.0001
Company E | Y |  |  |  |  |  |  |  |  |  | Company K | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 0.0001
Company F | Y |  |  |  |  |  |  |  |  |  | Company L | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 0.0001
Company G | Y |  |  |  |  |  |  |  |  |  | Company M | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002
Company H | Y |  |  |  |  |  |  |  |  |  | Company N | 0.05 | 0.04 | 0.04 | 0.05 | 0.06
Company I | Y |  |  |  |  |  |  |  |  |  | Company O | 0.002 | 0.002 | 0.002 | 0.002 | 0.002
Company J | Y |  |  |  |  |  |  |  |  |  | Company P | 0.0005 | 0.0005 | 0.0005 | 0.0005 | 0.0005
Company K | Y |  |  |  |  |  |  |  |  |  | Company Q | 0.00625 | 0.00625 | 0.00625 | 0.00625 | 0.00625
Company L | Y |  |  |  |  |  |  |  |  |  | Company R | 0.00375 | 0.00375 | 0.00375 | 0.00375 | 0.00375
Company M | Y |  |  |  |  |  |  |  |  |  | Company S | 0.05 | 0.03 | 0.03 | 0.05 | 0.05
Company N | Y |  |  |  |  |  |  |  |  |  | Company T | 0.01 | 0.01 | 0.01 | 0.01 | 0.01
Company O | Y |  |  |  |  |  |  |  |  |  | Company U | 0.01 | 0.01 | 0.01 | 0.01 | 0.01
Company P | Y
Company Q | Y |  |  |  |  |  |  |  |  |  |  | 101 | 106 | 101 | 102 | 109
Company R | Y |  |  |  |  |  |  |  |  |  |  | 102 | 107 | 102 | 106 | 110
Company S | Y |  |  |  |  |  |  |  |  |  |  | 103 | 110 | 103 | 109 | 111
Company T | Y |  |  |  |  |  |  |  |  |  |  | 104 | 113 | 112 | 113 | 112
Company U | Y |  |  |  |  |  |  |  |  |  |  |  |  |  | 115 | 113
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 114
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115
 |  |  |  |  |  |  |  |  |  |  |  | Y
 |  |  |  |  |  |  |  |  |  |  |  | N
Spreadsheet: 169145d1342710942-excel-2007-entering-number-will-lookup-and-change-value-testing_sheet
Sheet: Sheet1

Sellus id | Company Name | Phone | [NAME] | Company Website | Contact | FT | FT Date | Follow Up / Call Back | Scored | Comments | project
600049198 | AvenaBeheer | [PHONE] | [EMAIL] | Test | me | no | 2012-07-19 00:00:00 | 2012-07-28 00:00:00 | no | test | 222
600189998 | Beekmans Installaties B.V. | [PHONE] | [EMAIL]
1000092563 | Geerts Installaties | 0492-361773 | [EMAIL]
600307672 | [NAME] | 0524-558280 | [EMAIL]
600307672 | [NAME] | 0524-558280 | [EMAIL]
 | ASN Installaties | 0519-820000 | [EMAIL]
1000336198 | Atama Solar Energy BV | [PHONE] | [EMAIL]
600049127 | Besseling Installatie groep | [PHONE] | [EMAIL]
1000338512 | BNSolar | 614558151 | [EMAIL]
1000338509 | Duurzaam DakBalans | 013 522 08 86 | [EMAIL]
1000338495 | Zonnebod.nl / Séclusive BV | [PHONE] | [EMAIL]
600297005 | ESTEC-HOLLAND B.V. | [PHONE] | [EMAIL]
600190215 | Dutch Solar Systems BV | [PHONE] | [EMAIL]
1000338523 | Eco-Dome | 0412-474666 | [EMAIL]
600307770 | First Energy | First Energy | [EMAIL]
 | G2 Energy | [NAME] (0) 341 264353 | [EMAIL]
 | Installatie Techniek Masseling | [PHONE] | [EMAIL]
Spreadsheet: 141747d1329420368-summarize-accounts-vs-months-budget-with-pivot-table-inefficient-speradsheet
Sheet: General Inputs

Estimated Expense Increase | 0.04
SpendingPattern | 10/1/2011 | 11/1/2011 | 12/1/2011 | 1/1/2012 | 2/1/2012 | 3/1/2012 | 4/1/2012 | 5/1/2012 | 6/1/2012 | 7/1/2012 | 8/1/2012 | 9/1/2012 | SUM
Flat | 0.0833333333333333 | 0.0833333333333333 | 0.0833333333333333 | 0.0833333333333333 | 0.0833333333333333 | 0.0833333333333333 | 0.0833333333333333 | 0.0833333333333333 | 0.0833333333333333 | 0.0833333333333333 | 0.0833333333333333 | 0.0833333333333333
Normal Distribution | 0.006 | 0.017 | 0.044 | 0.092 | 0.15 | 0.191 | 0.191 | 0.15 | 0.092 | 0.044 | 0.017 | 0.006
Unique | 0.5 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Summer Variable | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.15 | 0.35 | 0.35 | 0.15 | 0
Retreats Variable | 0.15 | 0.1 | 0 | 0.05 | 0.1 | 0.2 | 0.25 | 0 | 0 | 0 | 0.05 | 0.1
Recruiting Variable | 0 | 0 | 0 | 0.3 | 0.3 | 0.3 | 0.1 | 0 | 0 | 0 | 0 | 0
Summer Marketing Variable | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.06 | 0 | 0 | 0.06 | 0.11
Heavy Pre Summer | 0 | 0 | 0 | 0 | 0 | 0 | 0.25 | 0.75 | 0 | 0 | 0 | 0
Spreadsheet: 787645d1657902731-calculating-time-differences-that-pass-over-midnight-times
Sheet: Sheet1

 | Start | Finish | Within 20 Mins | Within 1 Hour | 1 hour +
 | 23:58:00 | 00:12:00
 | 22:46:00 | 00:25:00
 | 22:42 | 01:02:00
 | 21:27 | 01:05:00
 | 21:22 | 00:58:00
 | 21:19 | 22:18:00
 | 21:18 | 00:31:00
 | 21:18 | 21:22:00
 | 21:14 | 23:05:00
 | 21:12 | 00:10:00
 | 21:10 | 00:14:00
 | 21:06 | 00:02:00
 | 20:59 | 00:02:00
Spreadsheet: 142192d1329721830-cell-reference-in-advanced-filtering-sample
Sheet: Sheet1

Dept. | Name | Hours
1 | [NAME] | 8
2 | [NAME] | 7.26
3 | Sue | 7.4
2 | [NAME] | 6
1 | George | 9.3
3 | [NAME] | 7.8
2 | Anne | 4.7
1 | [NAME] | 7.2
Spreadsheet: john_griffith__15903__11_13_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG Z1 | 275 | 36 | 38 | 84 | 88.6 | 14.92 | 2001-11-13 11:33:00
 | NG F2 | 295 | 64 | 66.5 | 79.8 | 83 | 15.1 | 2001-11-13 11:33:00
 | NG G2 | 300 | 79 | 81 | 73.3 | 75.1 | 13.99 | 2001-11-13 11:33:00
 | NG H2 | 295 | 80.5 | 81.5 | 65.1 | 65.9 | 12.15 | 2001-11-13 11:33:00
 | NG J2 | 295 | 75 | 77 | 54 | 55.4 | 10.14 | 2001-11-13 11:33:00
 | NG K2 | 300 | 77 | 80 | 49.2 | 51.2 | 9.47 | 2001-11-13 11:33:00
 | NG M2 | 305 | 84 | 87 | 48.4 | 50.2 | 9.45 | 2001-11-13 11:33:00
 | NG N2 | 305 | 90 | 94 | 48.7 | 50.9 | 9.55 | 2001-11-13 11:33:00
 | NG Q2 | 310 | 98 | 102 | 49.1 | 51.2 | 9.77 | 2001-11-13 11:33:00
 | NG U2 | 310 | 101 | 106 | 48 | 50.4 | 9.59 | 2001-11-13 11:33:00
 | NG V2 | 315 | 108 | 114 | 48.4 | 51.1 | 9.85 | 2001-11-13 11:33:00
 | NG X2 | 335 | 120 | 127 | 48.3 | 51.2 | 10.48 | 2001-11-13 11:33:00
 | [NAME] |  |  |  |  |  |  | 2001-11-12 14:47:00
 | NG H3 |  |  |  |  |  |  | 2001-11-12 14:47:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 45353d1244104637-totalling-up-values-that-meet-two-criteria-muni-masters
Sheet: Monday 

Municipal Cage Collections
Date | 2009-05-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Validation Info
Contract | Site | District | Vehicle Reg | Driver | Mate | Completed | Goods | Total Cages | Left on site | [NAME] | Fridge breakdown | Sites | Districts | Vehicle | Driver | Mate | Completed | Goods | Goods | Goods
 | [NAME] |  |  |  |  |  | [NAME] | 2 |  |  |  | [NAME] | Calderdale | DX08 EVP | Crowther. I | Codd. R | Yes | [NAME] | [NAME] CRTs | Fridges
 | [NAME] |  |  |  |  |  | [NAME] CRTs | 5 |  |  |  | Elland | Calderdale | EU06 EZE | Dugdale. A | Hector. D | No
 | [NAME] |  |  |  |  |  | Fridges | 3 |  |  |  | [NAME] | Calderdale | EU06 EZG | Goto. C | [NAME]. S
 | [NAME] |  |  |  |  |  | [NAME] CRTs | 4 |  |  |  | Milner Royd | Calderdale | EU06 EZH | Harrigan. D | spare
 | [NAME] |  |  |  |  |  | Fridges | 1 |  |  |  | Todmorden | Calderdale | EU06 EZJ | Karolia. C | spare
 | [NAME] |  |  |  |  |  | [NAME] | 3 |  |  |  | Calverley Bridge | Leeds | EU08 VWO | [NAME]. J
 | [NAME] |  |  |  |  |  | [NAME] | 5 |  |  |  | East Leeds | Leeds | EU08 VWR | Olsen. J
 | [NAME] |  |  |  |  |  | [NAME] | 5 |  |  |  | [NAME] | Leeds | NA05 DZJ | Storer. M
 | [NAME] |  |  |  |  |  | [NAME] | 4 |  |  |  | Holmewell Road | Leeds | NK55 EKH | [NAME]. R
 | [NAME] |  |  |  |  |  | [NAME] | 3 |  |  |  | [NAME] | Leeds | T760 YBL | spare
 | Stanley Road |  |  |  |  |  | [NAME] CRTs | 6 |  |  |  | [NAME] | Leeds | spare | spare
 | Stanley Road |  |  |  |  |  | [NAME] CRTs | 5 |  |  |  | Meanwood Road | Leeds
 | [NAME] |  |  |  |  |  | [NAME] CRTs | 5 |  |  |  | Milners Road | Leeds
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Leeds
 |  |  |  |  |  |  |  |  |  |  |  | St Judes | Leeds
 |  |  |  |  |  |  |  |  |  |  |  | Stanley Road | Leeds
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Leeds
 |  |  |  |  |  |  | Grand Total Cages
Spreadsheet: 863266d1710831410-pull-only-jan-data-jan-data
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column62 | Column7 | year |  |  |  | jan value | last value for year
2023-11-07 00:00:00 | p | 542 | 11.29 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-01-31 00:00:00 | 2023
2023-12-04 00:00:00 | d | 5.049 | 12.06 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-01-31 00:00:00 | 2024
2024-01-04 00:00:00 | d | 4.905 | 12.2691
2024-02-05 00:00:00 | d | 4.877 | 12.4482 |  |  |  |  |  |  |  | Correct data
2024-03-06 00:00:00 | d | 4.9 | 12.5 |  |  |  |  |  |  |  |  | Jan Value | Last value for year
2024-03-15 00:00:00 | d |  |  |  |  | 15.3 |  |  |  |  | 2023 | NA | 60.891 |  | NA - No Jan 2023 entry. Need first entry for Jan, there may be 2 or more for Jan of any given year.
 |  |  |  |  |  |  |  |  |  |  | 2024 | 60.18 | 15.3 |  | Jan 2024 value is 60.18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last entry for 2024 is 15.30
 | Sub-Total
 |  |  |  | Total F & G
Spreadsheet: 01328aaa-f315-41c2-b761-986626d58049
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: |  |  | 2013-08-21 09:24:50.770000
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.875 | 101.588 | 101.463 | 101.338 | 100.963 |  | and are added to price quote
4.75 | 101.108 | 100.983 | 100.858 | 100.483
4.625 | 100.391 | 100.266 | 100.141 | 99.766 |  | Note: | Refer To Price [NAME]
4.5 | 99.499 | 99.374 | 99.249 | 98.874 |  |  | For all Price Adjs
4.375 | 98.568 | 98.443 | 98.318 | 97.693
4.25 | 97.787 | 97.662 | 97.537 | 96.912
4.125 | 96.997 | 96.872 | 96.747 | 96.122
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 101.954 | 101.829 | 101.704 | 101.329
3.875 | 101.239 | 101.114 | 100.989 | 100.614
3.75 | 100.643 | 100.518 | 100.393 | 100.018
3.625 | 100.266 | 100.141 | 100.016 | 99.641
3.5 | 99.72 | 99.595 | 99.47 | 98.845
3.375 | 98.999 | 98.874 | 98.749 | 98.124
3.25 | 98.226 | 98.101 | 97.976 | 97.351 |  | Minimum loan amount:
3.125 | 97.153 | 97.028 | 96.903 | 96.278 |  | 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 | 2013-09-04 09:24:50.770000
30 DAY | 2013-09-19 09:24:50.770000
45 DAY | 2013-10-04 09:24:50.770000
60 DAY | 2013-10-19 09:24:50.770000
90 DAY | 2013-11-18 09:24:50.770000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 761212d1640723251-need-formula-to-output-multiple-data-in-one-cell-from-workbook-copy-of-2022-reston-team-vacation-calendar
Sheet: December

 |  | 2022-11-28 00:00:00 | 2022-11-29 00:00:00 | 2022-11-30 00:00:00 | 2022-12-01 00:00:00 | 2022-12-02 00:00:00 | 2022-12-03 00:00:00
 |  | 2022-12-05 00:00:00 | 2022-12-06 00:00:00 | 2022-12-07 00:00:00 | 2022-12-08 00:00:00 | 2022-12-09 00:00:00 | 2022-12-10 00:00:00
 |  | 2022-12-12 00:00:00 | 2022-12-13 00:00:00 | 2022-12-14 00:00:00 | 2022-12-15 00:00:00 | 2022-12-16 00:00:00 | 2022-12-17 00:00:00
 |  | 2022-12-19 00:00:00 | 2022-12-20 00:00:00 | 2022-12-21 00:00:00 | 2022-12-22 00:00:00 | 2022-12-23 00:00:00 | 2022-12-24 00:00:00
 |  | 2022-12-26 00:00:00 | 2022-12-27 00:00:00 | 2022-12-28 00:00:00 | 2022-12-29 00:00:00 | 2022-12-30 00:00:00 | 2022-12-31 00:00:00
 | Christmas Day | Christmas Day Observed        Office closed
 |  | 2023-01-02 00:00:00 | Notes
Spreadsheet: 722417d1615242447-search-last-value-in-several-worksheets-test
Sheet: Anthony pias

A | B | C | D | E
2021-01-01 00:00:00 | 1
2021-01-02 00:00:00 |  | 2
2021-01-03 00:00:00 |  | 3
2021-01-04 00:00:00 |  |  | 5
2021-01-05 00:00:00 | 1
2021-01-06 00:00:00 |  | 1
2021-01-07 00:00:00 |  |  | 1
Spreadsheet: 2704715e-8bdc-45c9-81b5-1f84e532882f
Sheet: Sheet1

Contract Number | [NAME] | Project Name | Term Start Date | Exp. Date | Project Amount / Annual Amount
14-PW-46 | Franklins Earthmoving, Inc. | Los Milagros Channel Repair Phase 1 | 2014-02-10 00:00:00 | 2014-05-11 00:00:00 | 266918.25
14-PR-50 | BCL Enterprises, Inc. | A Park Above | 2014-03-10 00:00:00 | 2014-08-22 00:00:00 | 611524
14-PW-51 | Geographic Technologies Group, Inc. | GIS Strategic Plan Implementation Stage 2A | 2014-02-06 00:00:00 | 2015-02-06 00:00:00 | 172500
14-PW-52 | TLC Plumbing & Utility | Water Service Line Replacement | 2014-03-03 00:00:00 | 2014-09-29 00:00:00 | 1280460
14-FR-59 | Huitt-Zollars, Inc. | Fire Station #1 Improvements Design | 2014-02-26 00:00:00 | 2015-02-26 00:00:00 | 63320
Spreadsheet: jeff_dasovich__14205__E204_HaasvilleA_sim
Sheet: Q1(c)

 |  |  |  |  | Crystal Ball Report
 |  |  |  |  | Simulation started on 11/7/99 at 11:12:51
 |  |  |  |  | Simulation stopped on 11/7/99 at 11:19:54
Forecast:   NPV for Tech. A |  |  |  |  |  |  |  |  | Cell:  I25
 | Summary:
 |  | Certainty Level is 87.12%
 |  | Certainty Range is from -Infinity to $10.500  $
 |  | Display Range is from $9.000 to $11.250 $
 |  | Entire Range is from $8.823 to $11.603 $
 |  | After 10,000 Trials, the [NAME]. Error of the [NAME] is $0.004
 | Statistics: |  |  |  |  |  | Value
 |  | Trials |  |  |  |  | 10000
 |  | Mean |  |  |  |  | 10.06929847570697
 |  | Median |  |  |  |  | 10.06715106296306
 |  | Mode |  |  |  |  | ---
 |  | Standard Deviation |  |  |  |  | 0.3800507397655717
 |  | [NAME] |  |  |  |  | 0.1444385647963583
 |  | Skewness |  |  |  |  | 0.09246099761544625
 |  | Kurtosis |  |  |  |  | 2.967644979967213
 |  | [NAME]. of Variability |  |  |  |  | 0.03774351715588493
 |  | Range Minimum |  |  |  |  | 8.822680559120215
 |  | Range Maximum |  |  |  |  | 11.60332310097077
 |  | Range Width |  |  |  |  | 2.780642541850558
 |  | [NAME]. Error |  |  |  |  | 0.003800507397655718
Spreadsheet: 726575d1617299681-sumifs-issue-template
Sheet: TOTAL SUMMARY

Expense Category
Auto Gas |  | =JAN!(SUMIFS,I11:I51,E11:E51,"Auto Gas")
Groceries
Meals/Entertainment
[NAME]
Ofc Expense
Personal
Product/Supplies/Sales Tax
Spreadsheet: 745747d1630160640-pulling-data-validation-dropdown-options-from-another-sheet-not-dependent-dropdown-data-validation
Sheet: Sheet2

Cars | Shoes | Movies | Movie Studios | Fruits | Minerals | Animals
Ford | Dockers | Frozen | Fox | Orange | Silver | Dog
Chevy | Nike |  | Marvel | [NAME] |  | Horse
Kia | Dockers |  | Disney
BMW
Honda
Spreadsheet: 812435d1673148259-dynamic-reference-to-worksheet-with-index-and-aggregate-functions-dynamic-worksheet-reference-question
Sheet: JANUARY

 | JANUARY SALES
 | Potter | [NAME] | Date Sold
 | [NAME] | [NAME] | 2022-01-02 00:00:00 | 20
 | [NAME] | [NAME] | 2022-01-07 00:00:00 | 15
 | [NAME] | ornament | 2022-01-08 00:00:00 | 10
 | [NAME] | ornament | 2022-01-12 00:00:00 | 15
 | [NAME] | vase | 2022-01-13 00:00:00 | 60
 | [NAME] | bowl | 2022-01-13 00:00:00 | 50
 | [NAME] | bowl | 2022-01-13 00:00:00 | 65
 | [NAME] | [NAME] | 2022-01-14 00:00:00 | 15
 | [NAME] | vase | 2022-01-20 00:00:00 | 14
 | [NAME] | [NAME] | 2022-01-21 00:00:00 | 20
Spreadsheet: 733100d1621392666-getting-the-total-orders-of-each-hour-from-many-days-order-by-hours-of-the-day-bvj-
Sheet: option (2)

2020-01-05 00:00:00 | 210 |  |  |  | Hour | per day hourly total
 |  |  |  |  | 12AM
12AM | 4 |  |  |  | 1AM
 |  |  |  |  | 2AM
1AM | 3 |  |  |  | 3AM
 |  |  |  |  | 4AM
2AM | 3 |  |  |  | 5AM
 |  |  |  |  | 6AM
3AM | 2 |  |  |  | 7AM
 |  |  |  |  | 8AM
4AM | 4 |  |  |  | 9AM
 |  |  |  |  | 10AM
5AM | 4 |  |  |  | 11AM
 |  |  |  |  | 12PM
6AM | 6 |  |  |  | 1PM
 |  |  |  |  | 2PM
7AM | 2 |  |  |  | 3PM
 |  |  |  |  | 4PM
8AM | 3 |  |  |  | 5PM
 |  |  |  |  | 6PM
9AM | 7 |  |  |  | 7PM
 |  |  |  |  | 8PM
10AM | 12 |  |  |  | 9PM
 |  |  |  |  | 10PM
11AM | 10 |  |  |  | 11PM
12PM | 19
1PM | 28
2PM | 18
3PM | 19
4PM | 9
5PM | 22
6PM | 7
7PM | 8
8PM | 11
9PM | 3
10PM | 5
11PM | 1
2020-01-06 00:00:00 | 255
12AM | 4
1AM | 2
2AM | 3
3AM | 5
4AM | 6
6AM | 2
7AM | 5
8AM | 1
9AM | 8
10AM | 8
11AM | 7
12PM | 20
1PM | 17
2PM | 15
3PM | 17
4PM | 20
5PM | 23
6PM | 32
7PM | 18
8PM | 12
9PM | 8
10PM | 13
11PM | 9
2020-01-07 00:00:00 | 286
12AM | 2
1AM | 3
2AM | 1
3AM | 1
4AM | 2
5AM | 2
6AM | 2
7AM | 2
8AM | 1
9AM | 9
10AM | 13
11AM | 16
12PM | 22
1PM | 20
2PM | 21
3PM | 28
4PM | 29
5PM | 25
6PM | 32
7PM | 13
8PM | 16
9PM | 10
10PM | 7
11PM | 9