tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 295d5bd1-1305-43e6-b21f-aec0020b0b97
Sheet: Sheet1

Record Type | [NAME] | Element ID | Element | Format | Vendor Default | Min Len | [NAME] | [NAME] | Dict  Page
TH | 1 | [NAME] | Record Type | Alpha | No Default | 2 | 2 | Will be the literal string "TH" | 121
TH | 2 | [NAME] | Date Stamp | Date | No Default | 10 | 10 |  | 117
TH | 3 | H0020 | Time Stamp | Time | No Default | 8 | 8 |  | 125
TH | 4 | H0030 | Transmission ID | Alpha | No Default | 1 | 10 |  | 126
TH | 5 | H0050 | File Version | Alpha | No Default | 3 | 4 | Will be the literal string "1.0" for State ID file. | 119
TH | 6 | H0060 | Delimiter | Alpha | No Default | 14 | 14 | Will be the literal string "delimiter=0x09" | 118
ID | 1 | [NAME] | Record Type | Alpha | No Default | 2 | 2 | Will be the literal string "ID" | 121
ID | 2 | [NAME] | School Number | Alpha | No Default | 4 | 4 |  | 20
ID | 3 | D0200 | Resident District | Alpha | No Default | 4 | 4 |  | 30
ID | 4 | D0080 | Student Last Name | Alpha | No Default | 1 | 60 |  | 1
ID | 5 | D0060 | Student First Name | Alpha | No Default | 1 | 60 |  | 2
ID | 6 | D0070 | Student Middle Name | Alpha | No Default | 1 | 60 |  | 3
ID | 7 | D0090 | Student Suffix | Alpha | No Default | 1 | 10 |  | 4
ID | 8 | D0050 | Gender | Alpha | No Default | 1 | 1 |  | 6
ID | 9 | D0020 | Birth Date | Date | No Default | 10 | 10 |  | 5
ID | 10 | [NAME] | Grade Level | Alpha | No Default | 2 | 2 |  | 17
ID | 11 | D0010 | Local Student ID | Alpha | No Default | 1 | 20 |  | 15
ID | 12 | D0160 | Social Security Number | Numeric | No Default | 9 | 9 |  | 14
ID | 13 | D0035 | Race/Ethnicity_StateID | Alpha | No Default | 1 | 1 |  | 129
ID | 14 | K0020 | State Student ID | Numeric | No Default | 10 | 10 | For file inbound to the state, this field may be null.  For outbound file from the state, this field will be the State Student ID. | 16
ID | 15 | D0203 | Attending District | Alpha | No Default | 4 | 4 |  | 128
ID | 16 | [NAME] | Current School Year | Numeric | No Default | 4 | 4 |  | 116
TT | 1 | [NAME] | Record Type | Alpha | No Default | 2 | 2 | Will be the literal string "TT" | 121
TT | 2 | H0030 | Transmission ID | Alpha | No Default | 1 | 10 | Must match H0030 in the Transmission Header | 126
TT | 3 | H0040 | Number of Records | Numeric | No Default | 1 | 10 | The total count of records in the transmission, including the Transmission Header and Trailer records. | 120
Spreadsheet: 268687d1380735193-expanding-formula-sample-file-1
Sheet: Oct CC

 |  | Todo/Holiday/Event List |  |  | January |  |  | February |  | March |  | April |  | May |  | June
 |  |  |  |  | July |  |  | August |  | September |  | October |  | November |  | December
 |  | SUNDAY |  |  | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10
Spreadsheet: 127638d1320438115-excel-2007-count-unique-records-forum
Sheet: Sheet1

Name | Received
[NAME] | Q1
[NAME] | Q1
[NAME] | Q3
[NAME] | Q1
[NAME] | Q1
[NAME] | Q2 |  |  |  |  | Received | Unique People
[NAME] | Q2 |  |  |  |  | Q1 | 3
[NAME] | Q1 |  |  |  |  | Q2 | 2
[NAME] | Q2 |  |  |  |  | Q3 | 2
[NAME] | Q3 |  |  |  |  | Q4 | 1
[NAME] | Q4
[NAME] | Q4
[NAME] | Q4
[NAME] | Q4 |  |  |  |  | Etykiety wierszy | [NAME]
[NAME] | Q4 |  |  |  |  | Q1 | 3
 |  |  |  |  |  | Q2 | 2
Name | Received |  |  |  |  | Q3 | 2
[NAME] | Q1 |  |  |  |  | Q4 | 1
[NAME] | Q3 |  |  |  |  | Suma końcowa | 8
[NAME] | Q1
[NAME] | Q2
[NAME] | Q1
[NAME] | Q2
[NAME] | Q3
[NAME] | Q4
Spreadsheet: 790017d1659507225-find-the-numbes-using-countif-countifs-aligw
Sheet: Sheet1

Units | Sch. Print Start time | 2022-07-01 00:00:00 | 2022-07-02 00:00:00 | 2022-07-03 00:00:00 | 2022-07-04 00:00:00 | 2022-07-05 00:00:00 | 2022-07-06 00:00:00 | 2022-07-07 00:00:00 | 2022-07-08 00:00:00 | 2022-07-09 00:00:00 | 2022-07-10 00:00:00 | 2022-07-11 00:00:00 | 2022-07-12 00:00:00 | 2022-07-13 00:00:00 | 2022-07-14 00:00:00 | 2022-07-15 00:00:00 | 2022-07-16 00:00:00 | 2022-07-17 00:00:00 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | 2022-07-20 00:00:00 | 2022-07-21 00:00:00 | 2022-07-22 00:00:00 | 2022-07-23 00:00:00 | 2022-07-24 00:00:00 | 2022-07-25 00:00:00 | 2022-07-26 00:00:00 | 2022-07-27 00:00:00 | 2022-07-28 00:00:00 | 2022-07-29 00:00:00 | 2022-07-30 00:00:00 | 2022-07-31 00:00:00
SKLM | 1
VSP | 1
RJY | 1
TPG | 1
VJA | 1
GNT | 1
ONG | 1
TPT | 1
NLR | 1
CDP | 1
ATP | 1
KNL | 1
Spreadsheet: 784435d1655734579-dynamic-array-formula-to-count-same-date-customer-for-specific-part-numbers-arrayformulamultiplepartnosamedaycustomer
Sheet: Data

Date | Customer Number | Customer Name | Order Number | Part Number | CLF-Amt Paid To Prov | [NAME] | Codes
2021-01-01 00:00:00 | 1111111A | Smith, [NAME] | 987635672 | G2023 | 99
2021-01-01 00:00:00 | 1111111A | Smith, [NAME] | 987635672 | 99213 | 88
2021-01-01 00:00:00 | 1111111A | Smith, [NAME] | 987635672 | 99203 | 67
2021-02-01 00:00:00 | 2222222A | Doe, [NAME] | 344545665 | 99213 | 88
2021-02-01 00:00:00 | 2222222A | Doe, [NAME] | 344545665 | 98745 | 88
2021-03-01 00:00:00 | 3333333A | Jones, [NAME] | 124907567 | G2023 | 98
2021-03-01 00:00:00 | 3333333A | Jones, [NAME] | 124907567 | 99213 | 88
2021-03-01 00:00:00 | 3333333A | Jones, [NAME] | 124907567 | 99203 | 0
2021-04-01 00:00:00 | 1111111A | Smith, [NAME] | 567894346 | 99213 | 78
2021-05-01 00:00:00 | 3333333A | Jones, [NAME] | 124907567 | 99214 | 110
 |  |  |  |  |  | *Cell [NAME] should be 0, not 1, since it does not contain any of the three part numbers
Spreadsheet: 831111d1685431188-identifying-most-common-occurrences-text-with-criteria-preppy_prince_example_30052023_v2
Sheet: Sheet1

DATA | NAME | HOURS | CONTRACT | TRAINING | SUMMARY | NAME | HOURS | CONTRACT
 | [NAME] | 4 | Full-time | trainer
 | [NAME] | 4 | Full-time | trainee
 | Emma | 3 | Full-time | Trainee
 | Sophie | 4 | Full-time | Trainer
 | [NAME] | 2.75 | Casual | N/A
 | Julie | 4 | Casual | Trainer
 | Mark | 5 | Casual | Trainee
 | [NAME] | 3 | Casual | Trainee
 | [NAME] | 4 | Full-time | N/A
 | Mark | 3 | Casual | Trainee
 | [NAME] | 5 | Full-time | N/A
 | [NAME] | 4 | Casual | N/A
 | Sophie | 5 | Full-time | Trainer
 | Sophie | 5 | Full-time | Trainer
 | [NAME] | 3 | Casual | Trainee
 | [NAME] | 2.75 | Full-time | N/A
 | [NAME] | 2 | Part-time | trainee
 | [NAME] | 3 | Part-time | N/A
 | Sophie | 3 | Casual | Trainer
 | Mark | 4 | Casual | Trainee
 | [NAME] | 4 | Full-time | N/A
 | Sophie | 3 | Casual | Trainer
 | Emma | 5 | Full-time | Trainee
 | [NAME] | 3 | Full-time | N/A
 | Julie | 3.5 | Casual | Trainer
 | Sophie | 4 | Casual | Trainer
 | Julie | 4 | Casual | Trainer
 | Mark | 4 | Casual | Trainee
 | Emma | 3 | Full-time | Trainee
 | Sophie | 3 | Casual | Trainer
Spreadsheet: 0524392f-2dc0-4e4e-86c5-6860b035526a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | 1. sz. [NAME] | Unnamed: 5
[NAME] Jogú [NAME]
bevételeinek 2008. III. [NAME]
Cím | Al-cím | [NAME] | Eredeti előirányzat | Módosított előirányzat | Teljesítés
 |  | [NAME]
I. | 1. | Állami hozzájárulás
 |  | - Normatív állami támogatás és normatív
 |  | alapon elosztott SZJA | 4523965 | 4334906 | 3387871
 |  | - Tűzoltóság támogatása | 455021 | 455021 | 349911
 |  | - Címzett és céltámogatás | 341600 | 354067 | 345678
 |  | - [NAME] előirányzat és egyéb
 |  | állami támogatás | 2220 | 792171 | 666464
II. | 2. | [NAME] bevétel | 188000 | 188000 | 150504
 |  | [NAME] | 188000 | 188000 | 150504
 |  | [NAME]
III. | 3. | Átengedett bevételek
 |  | - SZJA helyben maradó része | 947533 | 947533 | 728653
IV. | 4. | Gépjárműadó | 450000 | 450000 | 430444
V. |  | Saját bevételek
 | 5. | [NAME] adók | 4915000 | 4915000 | 4126367
 |  | - iparűzési adó | 3830000 | 3830000 | 3056059
 |  | - építményadó | 910000 | 910000 | 902470
 |  | - idegenforgalmi adó | 21000 | 21000 | 16826
 |  | - kommunális adó | 126000 | 126000 | 128439
 |  | - egyéb | 28000 | 28000 | 22573
 | 6. | Illetékek | 450000 | 450000 | 368963
 | 7. | Átvett pénzeszközök | 890255 | 375130 | 106614
 | 8. | Telek-, ingatlanértékesítés | 900000 | 900000 | 839056
 | 9. | Egyéb saját bevétel
 |  | - közterülethasznosítás | 19800 | 19800 | 18971
 |  | - nem lakás c. helyiségek bérleti díja | 60500 | 60500 | 51001
 |  | - szakfeladatok bevételei | 312000 | 312448 | 253029
 |  | - egyéb saját bevétel | 20000 | 20000 | 9081
 |  | - lakbér bevétel | 31700 | 31700 | 19882
 |  | - Bábszínház bevétele | 11950
 | 11. | ÁFA befizetés és visszaigénylés | 266200 | 266200 | 229335
 | 12. | Pénzmaradvány
 |  | - Kisebbségi Önkormányzat | 0 | 1200 | 1200
 |  | - intézményi | 647655 | 670069 | 629706
 |  | - Polgármesteri Hivatal | 0 | 304980 | 161115
 | 13. | Intézményi bevételek | 792079 | 848456 | 798645
 | 14. | Veszprém és Térsége Szennyvízelvezetési
 |  | és Kezelési [NAME] | 3345669 | 3351646 | 972408
 |  | - bevétel | 3345669 | 3278636 | 899398
 |  | - pénzmaradvány | 0 | 5918 | 5918
 |  | - állami támogatás - központosított ei. | 0 | 67092 | 67092
 | 15. | Észak-Balatoni Térség Regionális Települési
 |  | [NAME] | 2655174 | 2885959 | 399263
 |  | - bevétel | 2655174 | 2655174 | 168478
 |  | - pénzmaradvány | 0 | 230745 | 230745
 |  | - központosított állami támogatás | 0 | 40 | 40
 |  | [NAME]: | 22226321 | 22934786 | 15044161
VI. |  | Lakásalap | 6404 | 197098 | 136638
 |  | - bevétel | 6404 | 166668 | 136638
 |  | - pénzmaradvány | 0 | 30430 | 0
 |  | Költségvetési bevételek összesen: | 22232725 | 23131884 | 15180799
 |  | [NAME], függő, átfutó bevételek
 |  | - Polgármesteri Hivatal |  |  | -358919
 |  | - intézmények |  |  | -598988
 |  | [NAME]: | 22232725 | 23131884 | 14222892
 |  | Hitelfelvétel
 |  | - rövid lejáratú [NAME] | 1200000 | 1200000 | 0
 |  | - beruházási | 1100000 | 1100000 | 34254
 |  | - előző évi hitelszerződésen alapuló | 717741 | 717741 | 160870
 |  | [NAME]: | 25250466 | 26149625 | 14418016
Spreadsheet: 329103d1404205361-excel-cell-color-background-shading-using-if-statements-school-form-2
Sheet: Calendar Days

Number of days during School Year |  |  |  |  | Total |  |  | Dates of Months
 |  |  |  |  |  |  |  | June
June |  | 20 | November |  |  | 20 |  | July
July |  | 22 | December |  |  | 15 |  | August
August |  | 19 | January |  |  | 20 |  | September
September |  | 22 | February |  |  | 20 |  | October
October |  | 23 | March |  |  | 20 |  | November
 |  |  |  |  |  |  |  | December
Important Dates to Remember |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  | February
June | 12 |  | Independence Day |  |  |  |  | March
July | 28 |  | Eid'l Fitr (Tentative Date) |  |  |  |  | April
August | 8 |  | [NAME] |  |  |  |  | May
 | 25 |  | National Heroes Day
October | 5 |  | Eid'l Adha (Tentative Date)
 | 20 |  | Semestral Break (Students)
 | 21
 | 22
 | 23
 | 24
November | 1 |  | All Saints Day
 | 30 |  | [NAME]
December | 20 |  | Start of Christmas Break
 | 30 |  | Rizal Day
January | 1 |  | New Year
February | 25 |  | EDSA People Power Revolution
March | 16 |  | [NAME]
 | 27 |  | Last Day of Classes
Spreadsheet: stephanie_panus__39294__AltaGas Services ISDA CW
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY: | [NAME]
DATE: | 2001-11-19 00:00:00 | DEAL MAKER: | Derek Davies
COUNTERPARTY: | AltaGas Services Inc. | CONTACT:
ADDRESS: | Suite 1700 | TITLE:
 | 355-4th Avenue S.W. | PHONE:
 | Calgary, Alberta T2P0J1 | FAX:
Incorporation State | Alberta | S&P Rating | BBB-
STRUCTURE | COUNTERPARTY | ECC
GUARANTOR (RATING) |  | Enron Corp (BBB-)                  (see notes below)
LIMIT $ MILLIONS |  | 15000000 | USD
Incorporation State |  | Oregon
COLLATERAL  THRESHOLD ($ USD)
 | See Grid Below | See Grid Below
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000 | USD
Return Amount | 250000 | 250000 | USD
HOLDING and USE OF COLLATERAL
Permitted
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor
Debt Ratings Change
-Below = S&P/Moody's | NA - due to collateral matrix | NA - due to collateral matrix
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-Cash Flow/CMLTD
Ownership Change
-Less than 50% owned by:
Westcoast Energy, Inc.
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | CAD $7.5 MM
-Guarantor ($[NAME]) |  | US $150 MM
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO: X
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES:    X | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES:    X | NO:
OTHER COMMENTS: Thresholds based on S&P Sr. Unsecured Debt Ratings of CP and Enron Corp, respectively.
 | COUNTERPARTY |  | ECC
BBB+ and higher | 15000000 | BBB+ and higher | 25000000
BBB | 10000000 | BBB | 20000000
BBB- | 5000000 | BBB- | 15000000
BB+ | 2500000 | BB+ | 7500000
BB and below | 0 | BB and below | 0
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x3-0699
Spreadsheet: 133534d1324466108-my-index-match-command-formula-reports-to-many-arguments-helptest-211211-
Sheet: Machine_Number

Machine Number
AM01 |  |  |  |  | Tool No: | BRT Number | Cavities | Part Variant | Material | Machine No | Manufacturer | Model | Serial no: | Plant No: | Year of Manufacture | [NAME] | Inject Unit | [NAME] | Screw type | Display Units
AM02 |  |  |  | 0
AM03 |  |  |  | 1 | 621E00A | 810 | 4 | 620 | M-BP100GA03N-V | AM01 | [NAME] | Victory | 161730 | 5320 | 2007 | 220 | 1350 | 60 | Barrier | ISO & Relative
AM04 |  |  |  | 2 | 621E00B | 833 | 16 | 621 | M-PPC5660N-V | AM02 | [NAME] | E-motion | 163290 | 5321 | 2007 | 180 | 940 | 55 | Barrier | ISO & Relative
AM05 |  |  |  | 3 | 621E00C | 1019 | 16 | 625 |  | AM03 | [NAME] | Victory | 164948 | 5491 | 2007 | 220 | 1350 | 60 | Barrier | ISO & Relative
 |  |  |  | 4 | 621E00D | 1097 | 16 | 629 |  | AM04 | [NAME] | Victory | 161054 | 5230 | 2006 | 220 | 1350 | 60 | Barrier | ISO & Relative
 |  |  |  | 5 | 621E00E | 1152 | 16 | 667 |  | AM05 | Demag | NC4 | 878-0586 | 1157 | 2000 | 250 | 840 | 60 | Mixer | mm/s & P_Spec
 |  |  |  | 6 | 621E00F | 1222 | 16
 |  |  |  | 7 | 635M00B | 1066 | 48
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
 |  |  |  | 11
 |  |  |  | 12
 |  |  |  | 13
 |  |  |  | 14
 |  |  |  | 15
 |  |  |  | 16
 |  |  |  | 17
 |  |  |  | 18
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
 |  |  |  | 25
 |  |  |  | 26
 |  |  |  | 27
 |  |  |  | 28
 |  |  |  | 29
 |  |  |  | 30 | Test Tool | Test BRT | Test Cav | Test Variant | Test Material | Test Machine No | Test Manufacturer | Test Model | Test Serial No | Test Plant | Test Year of | Test [NAME] | Test Inject Unit | Test [NAME] | Test [NAME] | Test Display Units
 |  |  |  | Revision | Notes
 |  |  |  | 1 | 1st Edition with PPC 625 actuator variants for 621E00B tool in AM01, 621E00D tool in AM03, 621E00C tool in AM04 and 621E00E tool in AM05. Also 620 variant for 635M00B in BP100 in AM02.
 |  |  |  | 2 | 2nd Edition with BP100 for 621E00D - 667 variant in AM03 and [NAME] for 621E00F - 667 variant aswell.
Spreadsheet: 376280d1423545569-summary-tables-for-workbook-containing-multiple-worksheets-project-plan-in-progress
Sheet: Segments

General
Specific task | Staff involved | Due date | Link to document | Notes | Status
Discuss project with Helen | Lisa, Helen | 2014-10-16 00:00:00 |  |  | Completed
Receive quote from Helen for Toolkit project and have it approved | [NAME] | 2014-11-10 00:00:00 |  |  | Completed
Create spreadsheet with legal entity, ABN, AFSL, business unit and address information | [NAME] | 2014-12-16 00:00:00 |  | Finalising business units that need to be available in the Toolkit | In progress
Technical
Specific task | Staff involved | Due date | Link to document | Notes | Status
Discuss Toolkit project with [NAME] | [NAME], [NAME] | 2014-11-11 00:00:00 |  | Discussed project and the need to have a few of their staff as 'testers' | Completed
Establish testing team | [NAME], [NAME], [NAME] | 2014-11-30 00:00:00 |  |  | Completed
Meet with testing team and provide them with instructions for Toolkit version 4 installation | [NAME] | 2014-12-04 00:00:00 |  |  | Completed
Commercial
Specific task | Staff involved | Due date | Link to document | Notes | Status
Meet with [NAME] regarding 1st policy wording for library | [NAME], [NAME] | 2014-10-02 00:00:00 |  |  | Completed
Demo policy in Toolkit version 4 | [NAME], [NAME] | 2014-12-04 00:00:00 |  |  | Completed
Provide KLP with security decision | [NAME], [NAME] |  |  | As soon as IT finalise the home, we can work out security/permissions | In progress
KLP to revert back with changed and agreed process | [NAME], [NAME] |  |  |  | In progress
Spreadsheet: 273127d1382621841-rota-help-vlookup-book1_reply_2
Sheet: Partner Rota

Partner Name | Team | Rota Pattern | Data | Shift | Day/Night | Dept. | Sun | Sun Index | Mon | Tue | Wed | Thu | Fri | Fri Index | Sat
Name 1 | Blue | Blue 4/4 | #N/A | 18-06 | N | Amb | 12 | AmbN1 | 0 | 0 | 0 | 0 | 12 | AmbN1 | 12
Name 2 | Blue | Blue 4/4 | #N/A | 18-06 | N | Chill | 12 | ChillN1 | 0 | 0 | 0 | 0 | 12 | ChillN1 | 12
Name 3 | Blue | Blue 4/4 | #N/A | 18-06 | N | Load | 12 | [NAME] | 0 | 0 | 0 | 0 | 12 | [NAME] | 12
Name 4 | Blue | Blue 4/4 | #N/A | 10-18 | D | FRV | 12 | FRVD1 | 0 | 0 | 0 | 0 | 12 | FRVD1 | 12
Name 5 | Blue | Blue 4/4 | #N/A | 18-06 | N | Amb | 12 | AmbN1 | 0 | 0 | 0 | 0 | 12 | AmbN1 | 12
Name 6 | Blue | Blue 4/4 | #N/A | 18-06 | N | Chill | 12 | ChillN1 | 0 | 0 | 0 | 0 | 12 | ChillN1 | 12
Name 7 | Blue | Blue 4/4 | #N/A | 18-06 | N | Load | 12 | [NAME] | 0 | 0 | 0 | 0 | 12 | [NAME] | 12
Name 8 | Blue | Fresh/Load Nights 1 | #N/A | 18-02 | N | FRV | 8 | FRVN1 | 8 | 0 | 8 | 8 | 8 | FRVN1 | 0
Name 9 | Blue | Blue 4/4 | #N/A | 18-06 | N | Amb | 12 | AmbN1 | 0 | 0 | 0 | 0 | 12 | AmbN1 | 12
Name 10 | Blue | Blue 4/4 | #N/A | 18-06 | N | Chill | 12 | ChillN1 | 0 | 0 | 0 | 0 | 12 | ChillN1 | 12
Name 11 | Blue | Blue 4/4 | #N/A | 18-06 | N | Load | 12 | [NAME] | 0 | 0 | 0 | 0 | 12 | [NAME] | 12
Name 12 | Blue | Blue 4/4 | #N/A | 18-06 | N | FRV | 12 | FRVN1 | 0 | 0 | 0 | 0 | 12 | FRVN1 | 12
Name 13 | Blue | Fresh/Load Nights 2 | #N/A | 06-18 | D | Amb | 0 | AmbD0 | 0 | 8 | 8 | 8 | 8 | AmbD1 | 8
Name 14 | Blue | Blue 4/4 | #N/A | 18-06 | N | Chill | 12 | ChillN1 | 0 | 0 | 0 | 0 | 12 | ChillN1 | 12
Name 15 | Blue | Blue 4/4 | #N/A | 18-06 | N | Load | 12 | [NAME] | 0 | 0 | 0 | 0 | 12 | [NAME] | 12
Name 16 | Blue | Blue 4/4 | #N/A | 18-06 | N | FRV | 12 | FRVN1 | 0 | 0 | 0 | 0 | 12 | FRVN1 | 12
Name 17 | Blue | Blue 4/4 | #N/A | 18-06 | N | Amb | 12 | AmbN1 | 0 | 0 | 0 | 0 | 12 | AmbN1 | 12
Name 18 | Blue | Blue 4/4 | #N/A | 18-06 | N | Chill | 12 | ChillN1 | 0 | 0 | 0 | 0 | 12 | ChillN1 | 12
Name 19 | Blue | Blue 4/4 | #N/A | 18-06 | N | Load | 12 | [NAME] | 0 | 0 | 0 | 0 | 12 | [NAME] | 12
Name 20 | Blue | Blue 4/4 | #N/A | 18-06 | N | FRV | 12 | FRVN1 | 0 | 0 | 0 | 0 | 12 | FRVN1 | 12
TOTAL HOURS |  |  |  |  |  |  | 224 |  | 8 | 8 | 16 | 16 | 232 |  | 224
Spreadsheet: 52468d1252221063-a-way-to-get-the-cell-references-in-a-formula-change-book1
Sheet: Sheet1

Item | Value 1 | Value 2 | Value 3 |  | Item | Sum | Month | January
A | 20 |  | 17 |  | A | 76
B | 15 | 10 |  |  | B | 73 | ["January" is manually changed to: February, March, april,…Dec ]
 |  |  |  |  | C | 102
A | 8 | 6 |  |  | D | 75 | Is there a way of making this change [in Cell I7] lead
 |  |  |  |  |  |  | to a change in the cell references (of the start of each range) in the formula
C | 13 | 11 | 24 |  |  |  | from $A$8 & $B$8 to, say, $A$10 & $B$10 or $A$13 &$B$13 and so on ??
B | 9
D | 5 |  | 16
D | 23 | 19
A |  | 25
C |  |  | 14
B | 16
D |  | 12
C | 27 |  | 13
B |  | 5 | 18
Spreadsheet: 0d6320e5-896f-4daa-9cc4-e4384cafe068
Sheet: Sheet1

West Virginia State University
COLLEGE WORK STUDY STUDENTS ONLY
 | PAYROLL MONTHLY TIME AND ATTENDANCE SHEET
DEPARTMENT NAME: |  |  |  |  |  |  |  |  |  | [NAME] NAME:
STUDENT'S NAME: |  |  |  |  |  |  |  |  |  | SOCIAL SECURITY NUMBER:    ________ -________ - ________
WORK PERIOD: |  |  |  |  |  |  |  |  |  | EMPLOYEE NUMBER:
PLEASE REPORT TIME TO THE NEAREST QUARTER HOUR |  |  |  |  |  |  |  |  |  |  |  | THIS FORM MUST BE COMPLETED IN INK
 | START | TIME | TIME | TIME | TIME | TIME | TOTAL |  |  |  | START | TIME | TIME | TIME | TIME | TIME | TOTAL
DAY | TIME | OUT | IN | OUT | IN | QUIT | HOURS | COMMENTS |  | DAY | TIME | OUT | IN | OUT | IN | QUIT | HOURS
25 |  |  |  |  |  |  |  |  |  | 9
26 |  |  |  |  |  |  |  |  |  | 10
27 |  |  |  |  |  |  |  |  |  | 11
28 |  |  |  |  |  |  |  |  |  | 12
29 |  |  |  |  |  |  |  |  |  | 13
30 |  |  |  |  |  |  |  |  |  | 14
31 |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 16
1 |  |  |  |  |  |  |  |  |  | 17
2 |  |  |  |  |  |  |  |  |  | 18
3 |  |  |  |  |  |  |  |  |  | 19
4 |  |  |  |  |  |  |  |  |  | 20
5 |  |  |  |  |  |  |  |  |  | 21
6 |  |  |  |  |  |  |  |  |  | 22
7 |  |  |  |  |  |  |  |  |  | 23
8 |  |  |  |  |  |  |  |  |  | 24
EMPLOYEE SIGNATURE: |  |  |  |  |  |  | DATE: |  |  | OTHER APPROVAL:
SUPERVISOR SIGNATURE: |  |  |  |  |  |  | DATE:
TOTAL HOURS WORKED THIS PERIOD: _______________ @ _____________ /HR  =  __________________
TOTAL HOURS AWARDED THIS SEMESTER  =  __________________ |  |  |  |  |  |  |  |  |  | TOTAL HOURS REMAINING THIS SEMESTER  =  _________________
TOTAL AWARD THIS SEMESTER  =  $________________ |  |  |  |  |  |  |  |  |  | TOTAL AWARD REMAINING THIS SEMESTER  =  $________________
NOTE:  This time sheet must be signed by the supervisor and employee and HAND DELIVERED to the Payroll Office (A-130) by the 28th of each month.  All new employees must complete and submit all necessary
 | payroll forms to  the Payroll Office prior to submission of this time sheet.  The employee and supervisor signature certifies that information is correct .
PADDING OF TIME SHEETS IS A FEDERAL OFFENSE PUNISHABLE BY LAW.
Spreadsheet: mike_grigsby__27925__HS_WESTminusPA
Sheet: Run Query

Daily Hedge Strip
User ID:
Password:
Included Deals | ALL
Today
Days in Month | 30
Day of Month |  | 2001-10-23 00:00:00 | Update this cell daily
PromptMonth | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
StartRange | D4
Enter EASTMEX Date:
[NAME] | NXB2 | NX1
2001-10-25 00:00:00 | 2001-10-26 00:00:00 | 2001-10-29 00:00:00
Please Note:  Once the 'RUN ' button has been pressed, please do not disturb Excel.  Doing so will make you a bad person.
Book Type | Book
Type
D | ENA-FT-WC-CAL-BAS
D | ENA-FT-WT-CAL-BAS
D | ENA-FT-WC-ROX-BAS
D | ENA-FT-WT-SJ-BAS
D | ENA-FT-WC-SJ-BAS
D | ENA-FT-WT-ROX-BAS
D | FT-DENVER-BAS
D | FT-REGS-BAS
D | ENA-FT-WT-SOCAL-BAS
D | FT-WEST-OPT-BAS
DO | FT-NW-XL-OPT-BAS
DO | FT-WE-XL-OPT-BAS
DO | GD-NEW-XL-OPT-BAS
D | TRANS-WEST-BAS
M | ENA-FT-WC-CAL-GDL
M | ENA-FT-WT-CAL-GDL
M | ENA-FT-WC-ROX-GDL
M | ENA-FT-WT-SJ-GDL
M | ENA-FT-WC-SJ-GDL
M | ENA-FT-WT-ROX-GDL
M | FT-DENVER-GDL
M | FT-REGS-GDL
M | ENA-FT-WT-SOCAL-GDL
M | ENA-FT-WT-SCAN-GDL
PHY | ENA-IM-WC-CAL-PHY
PHY | ENA-IM-WT-CAL-PHY
PHY | ENA-IM-WC-ROX-PHY
PHY | ENA-IM-WT-SJ-PHY
PHY | ENA-IM-WC-SJ-PHY
PHY | ENA-IM-WT-ROX-PHY
PHY | INTRA-DENVER-PHY
PHY | ENA-FT-WT-SOCAL-PHY