tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Mar10-Mar16p

Pavilion
 | 2013-03-10 00:00:00 |  |  | Thru | 2013-03-16 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-03-10 00:00:00 | 2013-03-11 00:00:00 | 2013-03-12 00:00:00 | 2013-03-13 00:00:00 | 2013-03-14 00:00:00 | 2013-03-15 00:00:00 | 2013-03-16 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  |  |  |  | 12:15PM
1:15PM |  |  |  |  |  |  |  | 1:15PM
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 32438d1228581899-lookup-loop-to-find-values-from-a-list-inside-a-string-of-values-lookup-loop-example
Sheet: Sheet1

Sample Raw Data |  |  |  |  |  |  |  |  | Desired Result 1 |  | Desired Result 2 |  |  | List 1 |  | List 2
2 XP6-45-R UP 65.50 45 200 10 2 69.1 New 221w Tx2A/Rx2A 2Rd+1Pu Fiber New 1 |  |  |  |  |  |  |  |  | XP6-45-R |  | 221 |  |  | XP6-45-R |  | 811
222w Rx2B 2Bl+1Pu Fiber New |  |  |  |  |  |  |  |  |  |  | 222 |  |  | LBX-9919DS-TOM |  | 812
3 XP6-45-R UP 65.50 45 320 10 2 69.1 New 231w Tx3A/[NAME] 3Rd+1Pu Fiber New 1 |  |  |  |  |  |  |  |  | XP6-45-R |  | 231 |  |  | LBX-3319DS-TOM |  | 813
232w Rx3B 3Bl+1Pu Fiber New |  |  |  |  |  |  |  |  |  |  | 232 |  |  | LBO 999 3H |  | 814
4 LBX-3319DS-T0M UP 61.90 34 80 15 1 101.5 New 811w Tx1A/Rx1A 1Rd+1Pk Fiber New 1 |  |  |  |  |  |  |  |  | LBX-3319DS-TOM |  | 811 |  |  | 4N2H |  | 821
[NAME] 1Bl+1Pk Fiber New |  |  |  |  |  |  |  |  |  |  | 812 |  |  | [NAME] |  | 822
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 823
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 824
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 831
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 832
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 833
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 834
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 211
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 212
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 213
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 214
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 221
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 222
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 223
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 224
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 231
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 232
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 233
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 234
Spreadsheet: 05b751c9-bdd7-4c02-aabc-118c2190a1a0
Sheet: Based on Orig + Changes

Request for Rebudgeting Approval
UI reference #:
Sponsor reference #:
Title:
 | Original | Budget After Any | Current Balance | Proposed for
 | Approved Budget | Approved Revisions | Available | [NAME]. | Change
Salaries
Fringe Benefits
Irregular Help
Travel
Operating Expenses
Equipment >$5K
Small Equip <$5K
Tuition Remission
Participant Support
Overhead
Total |  |  |  |  |  | (Net total change must equal zero)
Spreadsheet: 03be5698-0f8d-4375-9934-16b4ea47d28c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | RECORDS CENTER USER:
 | It is very important that you assign the correct Schedule Number to your records prior to transferring them from your office.  If you are unsure which schedule should be assigned to your records, please contact the Records Analyst, [NAME], at x 5-4107 or the City Archivist, [NAME], at x 5-4110.
 | Please take a moment to read through the questions and answers below.  If you have a question that is not covered by those listed, please email it to:
 | [EMAIL]
 | What is [NAME]?
 | A Retention Schedule describes the records created by an agency, organization, or administrative unit and establishes a timetable for their life cycle, as well as providing authorization for their disposition.
 | Where do I find my bureau's Schedules?
 | They are found, alphabetically, online (on the Internet and [NAME]).  The link provided below will take you to the Schedules on the Internet site; therefore, you will not be prompted to Login to the City's Intranet.
 | http://www.portlandonline.com/auditor/index.cfm?c=51813
 | I searched through all of the record types listed within my bureau/division and did not find [NAME] that accurately describes my records.  What should I do?
 | You should then refer to the City's GENERAL Schedules which can be used by all City employees.  These schedules should only be used if the appropriate bureau-specific schedule is not found.  If you are still not finding the schedule that describes your records, contact [NAME] or [NAME] (see gray box above).
 | The records I need to send to archives appear to be a mixture of many different record types.  May I pack them all in one box and assign [NAME] that represents the majority of the records?
 | Definitely not.  In order to properly manage the records, and track them while they reside here at PARC, you'll need to be sure that the data assigned to each box accurately represents the records inside.  In such a case, you will need to sort the records before you file them in the boxes.  If you need assistance sorting and scheduling your records, please don't hesitate to contact us.
 | I need to make room in my filing cabinet.  Should I assign [NAME] to the records before I dispose of them?
 | Yes;  there is no other way to know when or how to dispose of your records except by locating the records' State-approved [NAME]. There are many record types that have a "permanent" retention and will never be destroyed; others may require a confidential disposition.  The only way to know how to handle your records is by referring to the Retention Schedule that has been created for your record.
Spreadsheet: 745301d1629838655-using-countif-to-count-partial-matches-book2
Sheet: Sheet1

[NAME]
Column1 | Visitors | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Individual | Column10 | Column11 | Column12
 |  | Dined In |  |  |  |  |  | [NAME] | No | No | Something Written
 |  | Outside Dine |  |  |  |  |  | [NAME] | No | Yes | Something Written
 |  | Dine with others |  |  |  |  |  | [NAME] | Yes | No
 |  | Does not want to eat |  |  |  |  |  | [NAME] | Yes | Yes
 |  | Takeout pre-order |  |  |  |  |  | [NAME] | No | No | Something Written
 |  |  |  |  |  |  |  | [NAME] | No | Yes | Something Written
 |  |  |  |  |  |  |  | [NAME] | Yes | No
 |  |  |  |  |  |  |  | [NAME] | Yes | Yes
 |  |  |  |  |  |  |  | [NAME] | No | No | Something Written
 |  |  |  |  |  |  |  | [NAME] | No | Yes | Something Written
 |  |  |  |  |  |  |  | [NAME] | Yes | No
 |  |  |  |  |  |  |  | [NAME] | Yes | Yes
Individual | # of visitors |  |  |  | Follow Up
[NAME] |  | =IF(A84="","",COUNTIFS(Table1[Column3],"*Dine*",Table1[Column3],"*Takeout*"))
[NAME]
Spreadsheet: 709543d1608381810-google-sheets-i-need-help-in-highlighting-cells-and-getting-sum-of-highlighted-cells-sample-file
Sheet: Jan 2018

Date 1 | Date 2 | Provider |  |  |  | Total
2020-12-21 00:00:00 | 2020-12-21 00:00:00 | AMAZON |  |  |  | 20.99 |  | Date | 2018-08-01 00:00:00
2020-12-21 00:00:00 | 2020-12-21 00:00:00 | AMAZON |  |  |  | 45.98 |  | Total Normal | 1 282.91
2020-12-21 00:00:00 | 2020-12-21 00:00:00 | AMAZON |  |  |  | 92.91 |  | Total Effective
2020-12-25 00:00:00 | 2020-12-25 00:00:00 | CHATFUEL SAN FRANCISCO |  | 30.00 Dollar américain |  | 26.08 |  | Total to Refund
2020-12-26 00:00:00 | 2020-12-27 00:00:00 | ITUNES.COM/BILL |  |  |  | 10.99
2020-12-28 00:00:00 | 2020-12-28 00:00:00 | [NAME] |  |  |  | 9.95
2020-01-01 00:00:00 | 2020-01-01 00:00:00 | HIVEAGE.COM |  | 19.00 Dollar américain |  | 16.34
2020-01-01 00:00:00 | 2020-01-04 00:00:00 | CARDWISECOM |  |  |  | 5
2020-01-04 00:00:00 | 2020-01-05 00:00:00 | ITUNES.COM/BILL |  |  |  | 58.48
2020-01-07 00:00:00 | 2020-01-07 00:00:00 | GITHUB |  | 25.00 Dollar américain |  | 21.38
2020-12-18 00:00:00 | 2020-12-19 00:00:00 | GEANT CASINO | LE GOSIER |  |  | 47.04
2020-12-20 00:00:00 | 2020-12-21 00:00:00 | ENVATO MKPL - PAYPAL |  | 20.00 Dollar américain |  | 17.38
2020-12-27 00:00:00 | 2020-12-27 00:00:00 | AMAZON |  |  |  | 21.49
2020-12-27 00:00:00 | 2020-12-27 00:00:00 | AMAZON |  |  |  | 11.82
2020-01-01 00:00:00 | 2020-01-02 00:00:00 | PHARMACIE | DE L'AEROPORT |  |  | 89.9
2020-01-03 00:00:00 | 2020-01-03 00:00:00 | BB9 | BAIE MAHAULT |  |  | 20.4
2020-01-03 00:00:00 | 2020-01-04 00:00:00 | CARREFOUR | PLIANE |  |  | 53.8
2020-01-05 00:00:00 | 2020-01-05 00:00:00 | L ESCALE FRAICHEUR |  |  |  | 63.65
2020-12-11 00:00:00 | 2020-12-11 00:00:00 | pi-8800073 16269 | BAIE MAHAULT |  |  | 12.4
2020-12-11 00:00:00 | 2020-12-12 00:00:00 | LA PALETTE | BAIE MAHAULT |  |  | 16.8
Spreadsheet: 820234d1677946267-combine-ranges-from-2-worksheets-s666-pq-myr-accounts-and-cc
Sheet: Cost Centers

CC
C00644
C00648
C00651
C02304
C02551
C00821
C02310
C02426
C02420
C02423
[NAME]
C02571
C02002
C02433
C02437
[NAME]
C02466
C02003
C02574
C02311
C02302
C02319
C02429
C02431
[NAME]
C02438
C02440
C02467
C02469
C02470
C02545
C02573
C02588
C02590
C02458
C02577
C02419
C02572
C02436
C02614
C02308
C02673
C02602
C00643
C00649
C02004
C02005
C02066
C02069
C02313
C02316
C02317
C02320
C02321
C02324
C02325
C02407
C02418
C02427
C02432
C02434
C02441
C02443
C02445
C02447
C02449
C02451
C02452
C02453
C02454
C02455
C02456
C02457
C02462
C02465
C02527
C02544
C02546
C02565
C02566
C02575
[NAME]
C02578
C02579
C02580
C02582
C02583
C02595
C02600
C02604
C02606
C02642
C02648
C02663
C02669
C02670
C02494
C02549
C02550
C02591
Spreadsheet: 839396d1691928231-neatest-value-demo-6-
Sheet: Sheet1

Salary Structure:  [NAME]
Month/Year:  Aug/2023
SLNO | EMP ID. | Name | DA | HRA | CONVEYANCE | LUNCH | OTHERS | UNIFORM | BASIC. | RES CH PAY | Remarks
1 | AV00001 | Muruganandam D |  |  |  |  |  |  |  |  |  | SUBTRACTED 2837
 |  |  |  |  |  |  |  |  |  |  | 15100 | SUBTRACTED 2837 WITHIN FORMULA
Spreadsheet: sally_beck__35151__MgmtSum-Q3-0914_Global
Sheet: Expenses

PLAN2000
TOT_OPS_EXPENSES | ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
2000-09-01 00:00:00 | 3RD QUARTER 2000 EXPENSES
M.QTD | Results based on activity through September 14, 2000
ENA |  |  | Direct Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 | Liquids |  | 8800 | 8800 | 0
COAL | Coal |  | 3491.292 | 2456.8 | -1034.492 |  | London compensation, unplanned Australian office expense
SO2 | Emissions |  | 178.61 | 104.1 | -74.51 |  | 3 FTE added
WEATHER | Weather |  | 882.6 | 882.6 | 0
INSURANCE | Global Risk Markets |  | 1582.2 | 1582.2 | 0
ECT_INV_IRFX | Financial Trading |  | 1768.513 | 1554.7 | -213.8129999999999 |  | Compensation
 | Agricultural Trading |  | 101.936 | 0 | -101.936 |  | Agricultural trading expenses not planned
 | Office of the Chairman |  | 350 | 0 | -350
 | Subtotal Commercial Expenses |  | 17155.151 | 15380.4 | -1774.751
 | Group |  | 0 | 0 | 0
 | Other Interest Related Charges |  | 0 | 0 | 0
 | Total Expenses |  | 17155.151 | 15380.4 | -1774.751
 |  |  | Operating Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
Spreadsheet: 801075d1666069896-how-to-use-averageifs-and-offset-to-get-rolling-average-sampleaverage-1-
Sheet: Sheet1

1 | 0.25 | 2022-03-16 00:00:00 | 7 | 66 | 7 | 0.25 | AVERAGEIFS(OFFSET(E1;COUNT(E:E);0;-3);E:E;D:D;F1;B:[NAME]) |  |  | Option 1: |  |  | Option 2:
2 | 0.5 | 2022-03-17 00:00:00 | 14 | 100 | 14 | 0.5 | AVERAGEIFS(OFFSET(E1;COUNT(E:E);0;-3);E:E;D:D;F2;B:B;G2)
3 | 0.5 | 2022-03-17 00:00:00 | 14 | 12 | 24 | 1 | AVERAGEIFS(OFFSET(E1;COUNT(E:E);0;-3);E:E;D:D;F3;B:B;G3)
4 | 1 | 2022-03-19 00:00:00 | 24 | 55
5 | 1 | 2022-03-19 00:00:00 | 24 | 15
6 | 0.5 | 2022-03-19 00:00:00 | 14 | 22
7 | 0.5 | 2022-03-23 00:00:00 | 14 | 44
8 | 1 | 2022-03-23 00:00:00 | 24 | 66
9 | 0.5 | 2022-03-24 00:00:00 | 14 | 76
10 | 1 | 2022-03-24 00:00:00 | 24 | 87
11 | 0.5 | 2022-03-24 00:00:00 | 14 | 33
12 | 1 | 2022-03-24 00:00:00 | 24 | 36
13 | 0.5 | 2022-03-25 00:00:00 | 14 | 33
14 | 1 | 2022-03-25 00:00:00 | 24 | 28
15 | 1 | 2022-03-26 00:00:00 | 24 | 29
16 | 1 | 2022-03-28 00:00:00 | 24 | 20
Spreadsheet: eric_saibi__9758__012102R
Sheet: Roseville CT 02

Owner Name |  | Northern California Power Agency
Station Name |  | Roseville CT Project 01
Unit Name |  | Roseville CT 02
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Natural Gas / Fuel Oil
Capacity |  | 25 MW
Start Date |  | 2001-12-10 00:00:00
End Date |  | 2002-01-22 00:00:00
Prv. Start Date |  | 2001-12-10 00:00:00
Prv. End Date |  | 2002-01-20 00:00:00
Comments |  | Generator Work
SIC |  | 4911
Plant ID |  | 1054166
Unit ID |  | 1017466
Outage ID |  | 19172
Spreadsheet: 40896d1239289074-using-if-statement-to-carry-over-grand-totals-based-on-base-number-sample-hours-report
Sheet: Sheet2

211.3798 | 120.3048 | 70.0099 | 110.7343 | 75.0418 | 28.1292 | 100 | 56 | 77 | 85 | 125 | 75 | 90 | 99 | 160 | 65 | 70.0099 | 110.7343 | 75.0418 | 28.1292 | 100 | 40
95
116.3798 | 141.6846 | 116.6945 | 132.4288 | 112.4706 | 45.59980000000002 | 50.59980000000002 | 11.59980000000002 | -6.400199999999984 | -16.40019999999998 | 13.59980000000002 | -6.400199999999984 | -11.40019999999998 | -7.400199999999984 | 57.59980000000002 | 27.59980000000002 | 2.609700000000018 | 18.34400000000002 | -1.614199999999983 | -68.48499999999999 | -63.48499999999999 | -118.485
So what I Need this to do is the following.
A3 needs to Show as 95
That’s shows me the Hours I have for the day. The Balance of 211-95 needs then be shifted to next day. So in affect the next Days hours become 236
So once again I then will need B3 to now show as 95 and the balance once again now shifts to [NAME] and so on. Until it gets to a point where I have less then 95 hours showing. This tells me what day
I will have capacity.
Does that help more ?
A2 (95) is a figure I need to be able to adjust sometimes.
Thanks
[NAME]
Spreadsheet: 725082d1616520691-formula-needed-for-several-scenerios-summary-report
Sheet: Aug-20

 | Month: | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | New Credits
 | SC | SC Name | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 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 | Total |  |  | Pre-Invoice Amounts | ECR Applied | Invoice Amts
Prior/Current | 1234 | Example Name | 0 | 0 | 9893.05 | 2015.04 | 11294.35 | 2364.01 | 1271.04 | 340.55 | 173.86 | 1001.09 | 1265.51 | 182.52 |  |  |  |  | 2376.92
Prior/Current | 2345 | Example Name | 0 | 0 | 0 |  | 2954.9 | 2002.86 | 65.53 | 62.55 | 124.65 | 77.4 | 34.86 | 33.56 |  |  |  |  | 1161.21
Prior/Current | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 87983.13 | 15395.92 | 639.64 | 158.82 |  |  |  |  | 7933.19
Prior/Current | 4567 | Example Name | 0 | 0 | 0 | 0 | 1619.58 | 868.01 | 325.14 | 221.6 | 305.99 | 30.8 | 482.43 | 180.97 |  |  |  |  | 817.18
Prior/Current | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1386.76 |  |  |  |  | 16435.99
Prior/Current | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 623.02 |  |  |  |  | 8093.64
Prior/Current | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16325 | 463.06 | 373.47 | 651.22 |  |  |  |  | 2213.59
Prior/Current | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 683.71 |  |  |  |  | 4216.44
Prior/Current | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82618.52 | 76.31 | 67.07 | 48.32 |  |  |  |  | 1224.82
Prior/Current | 9013 | Example Name | 0 | 0 | 0 | 0 |  | 262.17 | 2214.81 | 245.23 | 262.39 | 563.85 | 2676.81 | 560.99 |  |  |  |  | 2516.74
Used | 1234 | Example Name | 0 | 0 | -2376.92 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 2345 | Example Name | 0 | 0 | 0 | 0 | -1161.21 | 0 | 0 | 0 | 0 | 0 | 0
Used | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7933.19 | 0 | 0
Used | 4567 | Example Name | 0 | 0 | 0 | 0 | 817.18 | 0 | 0 | 0 | 0 | 0 | 0
Used | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -2213.59 | 0 | 0
Used | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1224.82 | 0 | 0
Used | 9013 | Example Name | 0 | 0 | 0 | 0 | -262.17 | -2214.81 | -39.76 | 0 | 0 | 0 | 0
Remaining/Carried Forward | 1234 | Example Name | 0 | 0
Remaining/Carried Forward | 2345 | Example Name | 0 | 0
Remaining/Carried Forward | 3456 | Example Name | 0 | 0
Remaining/Carried Forward | 4567 | Example Name | 0 | 0
Remaining/Carried Forward | 5678 | Example Name | 0 | 0
Remaining/Carried Forward | 6789 | Example Name | 0 | 0
Remaining/Carried Forward | 7890 | Example Name | 0 | 0
Remaining/Carried Forward | 8901 | Example Name | 0 | 0
Remaining/Carried Forward | 9012 | Example Name | 0 | 0
Remaining/Carried Forward | 9013 | Example Name | 0 | 0
Spreadsheet: 60770d1261333898-excel-2007-columns-into-rows-for-a-register-pagenos
Sheet: Sheet1

 | Words |  | Page | [NAME]
 | boat |  | 7
 | boat |  | 11
 | boat |  | 20
 | boat |  | 25
 | bus |  | 1
 | bus |  | 12
 | car |  | 10
 | car |  | 13
 | car |  | 16
 | car |  | 21
 | taxi |  | 5
 | taxi |  | 20
 | train |  | 8
 | train |  | 23
Spreadsheet: 149232d1333753683-need-help-autofilling-hyperlink-serial-log
Sheet: MID TOUR AWARDS

MID TOUR/MISC
[NAME] | 2010-09-30 00:00:00 | NAM
LCDR MOORE | 2010-09-28 00:00:00 | NAM
MM1 WORTH | 2010-10-27 00:00:00 | NAM
[NAME] | 2010-06-30 00:00:00 | NAM
ETCS HUNDLEY | 2011-08-05 00:00:00 | NAM
STS1 GALLAGHER | 2011-04-26 00:00:00 | NAM
YN1 HALL | 2011-02-17 00:00:00 | NAM
[NAME] | 2011-05-25 00:00:00 | NAM
MM2 RAMOS | 2011-04-26 00:00:00 | NAM
JSOQ/SOQ/JSOY/SOY
LS2 TYNER | 2011-01-26 00:00:00 | NAM | JSOY 2010
MM1 MURL | 2011-02-25 00:00:00 | NCM | SOY 2010
[NAME] | JSOQ | CSP LOC | 4TH QRTR 2010
LNI MAHONE | SOQ | CSP LOC | 4TH QRTR 2010
ET2 AUWAERTER | JSOQ | CSP LOC | IST QRTR 2011
[NAME] | SOQ | CSP LOC | IST QRTR 2011
RP2 MADINA | JSOQ | CSP LOC | 2ND QRTR 2011
[NAME] | SOQ | CSP LOC | 2ND QRTR 2011
[NAME] | JSOQ | CSP LOC | 3RD QRTR 2011
EM1 SCHWALBACH | SOQ | CSP LOC | 3RD QRTR 2011
YN2 RIVERA | 2012-01-20 00:00:00 | NAM | JSOY 2011
[NAME] | 2012-01-20 00:00:00 | NAM | SOY 2011
LS2 TRACZYNSKI | JSOQ | CSP LOC | 1ST QRTR 2012
EM1 WALDSCHMIDT | SOQ | CSP LOC | 1ST QRTR 2012
Spreadsheet: 270332d1381439081-sum-adjacent-cell-to-a-reference-throughout-workbook-sample-orders
Sheet: COSTINGS

 | Costing | YTD 2014 | WE 05.01.14 | WE 12.01.14 | WE 19.01.14 | WE 26.01.14 | WE 05.01.14 | WE 12.01.14 | WE 19.01.14 | WE 26.01.14
 | [NAME] (below)
1A | Grease / oils / paints / lubricants / turps / etc | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
1B | Elec. stock /Switchroom R&M/ contractors /etc. | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
1C | General R&M stock (inc's steel) + contractors. | #N/A | #N/A | 654.3 | #N/A | #N/A | #N/A | 654.3 |  | #N/A
1D | [NAME]. | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
1E | Welding: Cons/services/repairs ([NAME]. Gases) | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
1F | Abrasives: Cut/Grind/Flap/Buff discs, ETC. | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
1G | Tools/Repairs/Parts (Ex. Capital & Weld.) | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
1H | Strapper spare parts (ALL areas) & maint. | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
 | Weekly Totals - (YTD) calendar year | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 654.3 | 0 | #N/A
Spreadsheet: 886885d1736978069-prorated-salary-incomplete-month-prorated-salary-incomplete-month-v2
Sheet: Sheet1

Change dates | Monthly increases | Days in whole month | Daily ammounts | Amount to date | End of year prorated
2024-01-01 00:00:00 | 30000
2024-01-02 00:00:00 | 35000
2024-04-15 00:00:00 | 40000
Spreadsheet: 1314dffb-59d6-4fc3-99c1-36aa7cc5ee56
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-02-08 09:13:49.640000
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.375 | 101.679 | 101.679 | 101.554 | 101.054 |  | and are added to price quote
5.25 | 100.784 | 100.784 | 100.659 | 100.159
5.125 | 99.85199999999999 | 99.85199999999999 | 99.72699999999999 | 99.22699999999999 |  | Note: | Refer To Price [NAME]
5 | 99.06299999999999 | 99.06299999999999 | 98.93799999999999 | 98.43799999999999 |  |  | For all Price Adjs
4.875 | 98.919 | 98.919 | 98.794
4.75 | 97.92399999999999 | 97.92399999999999 | 97.79899999999999
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.625 | 100.51 | 100.51 | 100.385 | 99.885
4.5 | 100.299 | 100.299 | 100.174 | 99.67399999999999
4.375 | 99.993 | 99.993 | 99.868 | 99.368
4.25 | 99.487 | 99.487 | 99.362 | 98.862
4.125 | 97.99 | 97.99 | 97.865
 |  |  |  |  |  | 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-02-08 09:13:49.640000
 |  |  |  |  |  | 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-02-22 09:13:49.640000
30 DAY | 2011-03-09 09:13:49.640000
45 DAY | 2011-03-24 09:13:49.640000
60 DAY | 2011-04-08 09:13:49.640000
90 DAY | 2011-05-08 09:13:49.640000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 828448d1683500027-conditional-formatting-based-on-cell-content-and-date-sample-conditional-formatting
Sheet: Sheet1

2023-01-31 00:00:00
2023-02-28 00:00:00 | 20
2023-03-31 00:00:00 | 2
2023-04-30 00:00:00 |  | 5 | 4 |  | 10
2023-05-31 00:00:00
2023-06-30 00:00:00
2023-07-31 00:00:00
2023-08-31 00:00:00
2023-09-30 00:00:00
2023-10-31 00:00:00
2023-11-30 00:00:00
2023-12-31 00:00:00
2024-01-31 00:00:00
2024-02-29 00:00:00
2024-03-31 00:00:00
2024-04-30 00:00:00
2024-05-31 00:00:00