tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 595705d1540647381-copy-paste-to-automatically-generate-columns-of-data-based-on-rows-horizontal-to-vertical-how-it-should-look-like-after
Sheet: Sheet1

 |  |  |  |  | I want when pasting the content of Row 8 in Row9, It automatically generate the content of Columns FG into IJ
 |  | 1. Copy this row |  |  | "3" | "1" |  | "2" | "5" |  | "6" | "4" |  |  | "7" | "9" |  | "11" | "8" |  | "12" | "10" |  |  | "15" | "13" |  | "17" | "14" |  | "18" | "16" |  |  |  | "24" | "19" |  | "20" | "21" |  | "23" | "22" |  |  | "30" | "25" |  | "27" | "26" |  | "29" | "28" |  |  | "36" | "31" |  | "33" | "32" |  | "35" | "34"
 |  | 2. Paste the row Here |  |  | "3" | "1" |  | "2" | "5" |  | "6" | "4" |  |  | "7" | "9" |  | "11" | "8" |  | "12" | "10" |  |  | "15" | "13" |  | "17" | "14" |  | "18" | "16" |  |  |  | "24" | "19" |  | "20" | "21" |  | "23" | "22" |  |  | "30" | "25" |  | "27" | "26" |  | "29" | "28" |  |  | "36" | "31" |  | "33" | "32" |  | "35" | "34"
 |  |  |  |  |  |  |  | 3. Generate these 2 columns
 |  |  |  |  |  |  |  | "3" | "1"
 |  |  |  |  |  |  |  | "2" | "5"
 |  |  |  |  |  |  |  | "6" | "4"
 |  |  |  |  |  |  |  | "7" | "9"
 |  |  |  |  |  |  |  | "11" | "8"
 |  |  |  |  |  |  |  | "12" | "10"
 |  |  |  |  |  |  |  | "15" | "13"
 |  |  |  |  |  |  |  | "17" | "14"
 |  |  |  |  |  |  |  | "18" | "16"
 |  |  |  |  |  |  |  | "24" | "19"
 |  |  |  |  |  |  |  | "20" | "21"
 |  |  |  |  |  |  |  | "23" | "22"
 |  |  |  |  |  |  |  | "30" | "25"
 |  |  |  |  |  |  |  | "27" | "26"
 |  |  |  |  |  |  |  | "29" | "28"
 |  |  |  |  |  |  |  | "36" | "31"
 |  |  |  |  |  |  |  | "33" | "32"
 |  |  |  |  |  |  |  | "35" | "34"
Spreadsheet: 4367864f-4db9-403b-883c-9b4e89bc3705
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
4078 | 17361 | Marina | Saucedo | MEX | 53 | 00:09:13 | 00:00:28 | 00:14:34 | 00:00:31 | 00:10:33 | 1 | 00:35:19
4078 | 25162 | [NAME] | [NAME] | MEX | 51 | 00:09:39 | 00:00:32 | 00:13:33 | 00:00:36 | 00:11:06 | 2 | 00:35:26
4078 | 22341 | Claudia | Ruiz | MEX | 55 | 00:09:24 | 00:00:27 | 00:14:26 | 00:00:34 | [NAME] | 3 | 00:35:54
4078 | 25176 | Cecilia | [NAME] | MEX | 54 | 00:09:30 | 00:00:31 | 00:14:24 | 00:00:33 | [NAME] | 4 | 00:36:12
4078 | 25161 | Paola | [NAME] | MEX | 52 | 00:09:15 | 00:00:29 | 00:16:55 | 00:00:36 | 00:11:57 | 5 | [NAME]
Spreadsheet: 856264d1705578555-selection-process-by-neaurals-selection-process3
Sheet: Sheet1

 | MERIT | SPEED | ABILITY | WEIGHT | 115 | BARRIER | CLASS |  |  |  |  |  |  |  |  |  | NO'S | MERIT | SPEED | ABILITY | WEIGHT | 115 | BARRIER | CLASS |  |  |  | ODDS
 | 6 | 7 | 8 | 7 | 7 | 3 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | 7 | 3 | 7 | 6 | 6 | 7 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 | 5 | 5 | 6 | 3 | 5 | 11 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 | 1ST | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1ST | 2ND | 3RD | 4TH | 5TH
 | 7 | 6 | 3 | 8 | 5 | 11 | 1 | 2 |  |  |  |  |  |  |  |  | FINISHING POSITION | 8 | 5 | 3 | 1
Spreadsheet: 7b6f1b87-6a97-4ae4-bf9d-fc3d060e6672
Sheet: Sheet1

AU Code | Organization Code | SpedAssign | Edid | First Name | Last Name | Gender Code | Birth Date | School Code | Sped staff Program | [NAME] | Beginning Date | End Date | Emp Status Code | Contract Days | Hours Per Day | [NAME] | Base Salary | Subject Area Code | Program Area Code | Grant Project Code | [NAME] | Grade Level Infant | Grade Level Prek | Grade Level K | Grade Level 1st | Grade Level 2nd | Grade Level 3rd | Grade Level 4th | Grade Level 5th | Grade Level 6th | Grade Level 7th | Grade Level 8th | Grade Level 9th | [NAME] 10th | Grade Level 11th | [NAME] 12th | Semester Hours 24 | Classes Taught In Subject
Spreadsheet: 827408d1682675945-get-position-value-returns-a-spilling-range-get_rank-aligw
Sheet: Feuil1

ref | price |  |  |  | ref | price | position (expected_result)
A | 50 |  |  |  |  |  | 1
A | 300 |  |  |  | A | 300 | 3
A | 250 |  |  |  | A | 250 | 2
A | 500 |  |  |  | A | 500 | 4
A | 1000 |  |  |  | A | 1000 | 5
B | 250 |  |  |  | B | 250 | 3
B | 100 |  |  |  | B | 100 | 2
B | 25 |  |  |  | B | 25 | 1
Spreadsheet: 288644d1389266643-formula-correction-statement-of-account-dummy-data
Sheet: Statement

1 Holgate Court,
Western Road,
Romford, Essex
RM1 3JS
Tel: 01708 736 999
[EMAIL]
Client 1 |  |  |  |  |  | STATEMENT OF ACCOUNT
 |  |  |  |  | Date:
 |  |  |  |  | Customer Code:
Invoice Number |  | Date |  |  | Total |  | Credit
Current |  | Period 1 | Period 2 | Period 3 |  |  | Older
0 |  | 0 | 0 | 0 |  |  | 0
Terms: 30 days from date of invoice.
Payable to: Inner London Cleaning Ltd |  |  |  |  | Amount Due:
Account Number: 00602100 Sort code: 30-97-13 |  |  |  |  | VAT:
 |  |  |  |  | Total:
Registered Office: 2nd Floor, 57-59 High Street, Hoddesdon, [NAME], EN11 8TQ, Company Registration No: 6804018, Registered in England and Wales
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-07-31 00:00:00 |  | 1133350.6
2001-08-04 00:00:00
60874 | 678
500235
500248
500251
500254
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-07-31 00:00:00 |  | 275313.72
2001-08-04 00:00:00
9164
9167
Duke Energy Trading and Marketing
Contract  24361 |  |  |  | CBS Volume | 24268 | 24693 | 24361
 |  |  |  |  | 217918 | 117857 | 137824
2001-07-31 00:00:00 |  | 728230.37
2001-08-04 00:00:00 |  |  |  |  |  |  | 21665 | 36403
500241 |  |  |  |  |  |  | 22664 | 18932
500391 |  |  |  |  |  |  | 20248 | 43064
500392 |  |  |  |  |  |  | 25873 | -17
 |  |  |  |  |  |  | 26758 | -149
 |  |  |  |  |  |  | 26372 | 1467
 |  |  |  |  |  |  | 26700 | 1970
 |  |  |  |  |  |  | 26422 | 3940
 |  |  |  |  |  |  | 26661 | 28550
 |  |  |  |  |  |  | 27291 | -3361
Duke Energy Trading and Marketing |  |  |  |  |  |  | 27137 | -8
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant |  |  |  | 27123 | -1347
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant
20248 | trans | 141061.91
25873 |  | -259
26758 |  | -596
26372 |  | 2997.09
26700 |  | 4077.9
26422 |  | 8155.8
26661 |  | 146862.35
27291 |  | -17965
27137 |  | -67.28
27123 |  | -6425.19
Spreadsheet: 86410d1286389586-trendlines-in-two-separate-intervals-twotrendlines
Sheet: Sheet1

 |  |  | temp | elong | elong2
 |  |  | 33 | 0.01
 |  |  | 34 | 0.02
 |  |  | 35 | 0.03
 |  |  | 36 | 0.03
 |  |  | 37 | 0.05
 |  |  | 38 | 0.04
 |  |  | 39 |  | 0.07
 |  |  | 40 |  | 0.08
 |  |  | 41 |  | 0.08
 |  |  | 42 |  | 0.1
 |  |  | 43 |  | 0.1
 |  |  | 44 |  | 0.12
 |  |  | 45 |  | 0.15
Spreadsheet: drew_fossum__8936__sharris1100wk2
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  |  |  |  |  | 2000-11-17 11:05:25.060000
 |  | November, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
 |  | .
West Demand Revenues |  | 9.5298 | 9.869539799999998 | 0.3397397999999985 |  | Prices in excess of $0.12/mmbtu on 63/day.
West Commodity Revenues |  | 0.7487 | 0.8277136166999999 | 0.07901361669999984
East Demand Revenues |  | 1.0892 | 1.037357775 | -0.05184222499999969 |  | Burlington 24216--($53k)
East Commodity Revenues |  | 0.1654 | 0.198953884536 | 0.03355388453599997 |  | Higher volumes because of mainline west outage
[NAME] |  | 0.6430999999999999 | 0.637062 | -0.006037999999999877
[NAME] Revenues |  | 0.0583 | 0.1430417877 | 0.08474178769999997 |  | Higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance |  | 12.2335 | 12.713668863936 | 0.4801688639359991
[NAME] due to Price |  |  |  | 0.7949503102374448 |  | Current index price of $4.91
[NAME] due to net fuel retention. |  |  |  | -0.2744779333008318 |  | Lower retainage volumes -west
Hedging Adjustment |  |  |  | 0.1755000000000004 |  | First of the month Index Price $4.52
Unaccounted for Variance |  |  |  | -0.184
 |  |  |  | -------------
Fuel Variance |  |  |  | 0.5119723769366133 |  | Lower than 4Q Forecast because of Index Price Difference
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE |  |  |  | 0.9921412408726125
 |  |  |  | ========
Resolution of El Paso Measurement Dispute |  |  |  | 0
 |  |  |  | -------------
Adjusted Month-to-Date Variance |  |  |  | 0.9921412408726125
 |  |  |  | ========
[NAME]
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (through November) |  | 134.5236 | 18.9468 | 153.4704
Actuals through October w/ Nov. Wkly. |  | 136.798268863936 | 24.48752339647817 | 161.2857922604142
 |  | ------------- | ------------- | -------------
Variance from Plan |  | 2.274668863936 | 5.540723396478164 | 7.815392260414164
 |  | ------------- | ------------- | -------------
Resolution of El Paso Fuel Dispute |  |  |  | 3
 |  |  |  | -------------
Adjusted Variance from Plan |  |  |  | 10.81539226041416
 |  |  |  | ========
Spreadsheet: 87307d1287131776-sum-duplicates-parts
Sheet: Sheet1

R/S 61342 | 20
R/S 61203 | 55
R/S 61000 | 3
R/S 62319 | 11
R/S 61002 | 84
R/S 19201 | 152
R/S 44412 | 96
R/S 62131 | 5
R/S 31426 | 45
R/S 38812 | 250
R/S 51231 | 650
R/S 61213 | 42
R/S 23100 | 55
Spreadsheet: 96800d1296075197-a-formula-to-populate-one-cell-based-on-the-cell-range-on-another-worksheet-fte-calculations
Sheet: Available Working Hours

Discipline A |  |  | Discipline B |  |  | Discipline C
Full time hours available = 52 weeks * 35 hours = 1,820 hours |  |  | Full time hours available = 52 weeks * 35 hours = 1,820 hours |  |  | Full time hours available = 52 weeks * 35 hours = 1,820 hours
Less: | Hours |  | Less: | Hours |  | Less:
Vacation |  |  | Vacation |  |  | Vacation
Stat/Region Holidays |  |  | Stat/Region Holidays |  |  | Stat/Region Holidays
Estimated illness/down time |  |  | Estimated illness/down time |  |  | Estimated illness/down time
Mentoring time |  |  | Mentoring time |  |  | Mentoring time
Team meetings |  |  | Team meetings |  |  | Team meetings
Supervisory meetings |  |  | Supervisory meetings |  |  | Supervisory meetings
Training |  |  | Training |  |  | Training
Other (breaks, etc.) |  |  | Other (breaks, etc.) |  |  | Other (breaks, etc.)
Subtotal |  |  | Subtotal |  |  | Subtotal
Total Direct Service Hours/FTE |  |  | Total Direct Service Hours/FTE |  |  | Total Direct Service Hours/FTE
Available Working Hours by [NAME]
Spreadsheet: 38403d1236589042-conditional-formatting-range-of-cells-copy-of-values
Sheet: Sheet1

Values |  | To compare
value 4 |  | value 1 |  |  | if value in Column B is between equal to value 1 or value 2 or value 3 or value 4 - apply format 1, and so on
value 3 |  | value 2
value 1 |  | value 3
value 2 |  | value 4
value 4 |  | value 5
value 1 |  | value 6
value 5 |  | value 7
value 1 |  | value 8
value 6 |  | value 9
value 3 |  | value 10
value 1 |  | value 11
value 7 |  | value 12
value 2
value 8
value 1
value 2
value 4
value 9
value 5
value 1
value 2
value 6
value 8
value 7
value 3
value 2
value 1
value 2
value 10
value 3
value 9
value 4
value 1
value 6
value 2
value 12
value 11
value 5
value 3
value 12
value 2
value 7
value 6
value 8
value 1
value 10
value 3
value 9
value 1
value 5
value 3
value 7
value 4
value 3
value 8
value 2
value 9
value 11
Spreadsheet: 00ac884d-605f-4305-8851-9e2cb8ff8300
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | Blast Injection Request Form
 |  |  |  |  |  |  | University of Maryland, Baltimore    School of Medicine Transgenic Core Laboratory   Howard Hall 581    706-0453
 |  |  |  |  |  | Request Date
 |  |  |  |  |  | PI Name |  |  |  |  | Campus Address
 |  |  |  |  |  | Greenebaum Cancer Center Member? |  |  |  |  | (Office)
 |  |  |  |  |  |  | YES | NO |  |  | (Lab)
 |  |  |  |  |  | Department
 |  |  |  |  |  | Phone |  |  |  |  | email
 |  |  |  |  |  | Lab Contact |  |  |  |  | email
 |  |  |  |  |  | Chartstring to be charged
 |  |  |  |  |  | Animal Space Location: |  |  |  |  |  | ARF# |  | Exp. Date
 |  |  |  |  |  | (where chimeras will be housed) |  |  |  |  |  | Please include a copy of your protocol approval letter
 |  |  |  |  |  | [NAME] strain for injections (indicate): |  |  | C57BL/6NCr |  | C57BL/6NCr cBrd/cBrd |  | Other
 |  |  |  |  |  | Name of targeted gene:
 |  |  |  |  |  | Name of Construct |  |  |  |  |  | Source of ES Cell line:
 |  |  |  |  |  | Name of ES Line (for injection): |  |  |  |  |  | ES Cell passage number:
 |  |  |  |  |  | Clones for Injection: |  |  |  |  | Chromosome count: |  |  | Myco Test:
 |  |  |  |  |  | Please provide details for analysis of chimeric pups, germline transmission, breeding plans, etc.
 |  |  |  |  |  | Please provide a project description as it pertains to the use of transgenic animals:
 |  |  |  |  |  | Has this construct been used to generate transgenic animals previously? |  |  |  |  |  |  | YES | NO
 |  |  |  |  |  | Are phenotypic problems expected (i.e. [NAME])? |  |  |  |  |  |  | YES | NO
 |  |  |  |  |  |  |  |  |  |  |  | if yes, explain
 |  |  |  |  |  | PI Signature: |  |  |  |  |  |  |  | Date
 |  |  |  |  |  | Transgenic Lab Approval: |  |  |  |  |  |  |  | Date
 |  |  |  |  |  | Return this completed form to: Transgenic Core Facility, [NAME] (FAX [PHONE])
 |  |  |  |  |  | This form and all requested information and supporting data must be received prior to project initiation
Spreadsheet: 544993d1509132817-data-validation_list-chartofaccounts-2-
Sheet: coa

 |  |  |  |  |  | Account List |  | DV List
 |  |  |  |  |  | 111100  Cash - Operating
 |  |  |  |  |  | 111200  Cash - Fields Accounts
 |  |  |  |  |  | 111300  Cash - Payroll
 |  |  |  |  |  | 111400  Petty Cash
 |  |  |  |  |  | 111500  Marketable Securities
I am looking for a way for User to click on Validation List in Column A. |  |  |  |  |  | 112100  Trade Receivables
User would see both the Account and Account Description. |  |  |  |  |  | 112150  Intercompany Receivable
Excel would bring in only the Account Number in Cell A1 |  |  |  |  |  | 112150_Stat  Intercompany Receivable - (Stat Account)
ALSO!  I cannot use a helper column - if I could this would be a piece of cake!
Thank you for any idea or suggestions!
Spreadsheet: 599353d1542984576-distribute-values-between-two-different-dates-copy-of-loan-calculation-work-sheet-version01-
Sheet: Daily Coll.Cust.Wise Sum.

Collection Updates (Customer Wise) |  |  |  |  |  | Customer Name | [NAME]
 | Branch Information -► |  |  |  |  | Customer Information -► |  |  |  |  | Loan Information -►
Date | Loan Code | Branch Name | Branch Code | Officer Name | Officer Code | Customer Name | NIC Number | Nearest Town | Contact No | Distance to Center(Km) | Date of Loan | Loan Amount (Rs.) | Payment Method | Period (Days) | Effective Interest Rate | Total Interest | Total with Interest | Number of Installments | Loan Instalment | Paid Today
Total
Spreadsheet: 171201d1343658266-route-planning-route_example_v3
Sheet: Ark1

 | MONDAY |  |  |  |  |  |  |  |  |  |  | ROUTES (these are the constant order of the route)
 | INPUT THE ACTUAL SHOPS GETTING DELIVERIES |  |  |  |  | NORTH | WEST | EAST | SOUTH | SOUTH #2 |  | NORTH | WEST | EAST | SOUTH | SOUTH #2
 | Shop 1 |  |  |  |  |  | Shop 1 | Shop 3 | Shop 8 | n/a |  | Shop 5 | Shop 1 | Shop 3 | Shop 8 | Shop 13
 | Shop 2 |  |  |  |  | Shop 4 | Shop 9 | Shop 7 | Shop 10 |  |  | Shop 4 | Shop 9 | Shop 7 | Shop 10 | Shop 11
 | Shop 3 |  |  |  |  | Shop 6 | Shop 2 |  |  |  |  | Shop 6 | Shop 2 | Shop 15
 | Shop 4 |  |  |  |  |  |  |  |  |  |  | Shop 12 | Shop 16
 | Shop 5
 | Shop 6
 | Shop 7
 | Shop 8
 | Shop 9
 | Shop 10
 | TUESDAY
 | INPUT THE ACTUAL SHOPS GETTING DELIVERIES |  |  |  |  | NORTH | WEST | EAST | SOUTH | SOUTH #2
 | Shop 3 |  |  |  |  | Shop 5 | n/a | Shop 3 | Shop 8 | Shop 13
 | Shop 5 |  |  |  |  | Shop 6 |  | Shop 7 | Shop 10 | Shop 11
 | Shop 6 |  |  |  |  | Shop 12 |  | Shop 15
 | Shop 7
 | Shop 8
 | Shop 10
 | Shop 11
 | Shop 12
 | Shop 13
 | Shop 15
Spreadsheet: 101451d1299580243-conditional-formatting-when-text-changes-book1_jobindaniel
Sheet: Sheet1

title | original choice | 2015-02-01 00:00:00 | 2025-02-01 00:00:00 | 2005-03-01 00:00:00
Leader | [NAME] | [NAME] | [NAME] | [NAME] |  | 1
Leader | [NAME] | [NAME] | [NAME] | [NAME] |  | 0
Leader | [NAME] | [NAME] | [NAME] | [NAME] |  | 1
Leader | [NAME] | [NAME] | [NAME] | [NAME] |  | 1
Leader | [NAME] | [NAME] | [NAME] | [NAME] |  | 1
Leader | [NAME] | [NAME] | [NAME] | [NAME] |  | 1
title | original choice | 2015-02-01 00:00:00 | 2025-02-01 00:00:00 | 2005-03-01 00:00:00
Leader | [NAME] | [NAME] | [NAME] | [NAME] |  | 1
Leader | [NAME] | [NAME] | [NAME] | [NAME] |  | 0
Leader | [NAME] | [NAME] | [NAME] | [NAME] |  | 1
Leader | [NAME] | [NAME] | [NAME] | [NAME] |  | 1
Leader | [NAME] | [NAME] | [NAME] | [NAME] |  | 1
Leader | [NAME] | [NAME] | [NAME] | [NAME] |  | 1
title | original choice | 2015-02-01 00:00:00 | 2025-02-01 00:00:00 | 2005-03-01 00:00:00
Leader | [NAME] | [NAME] | [NAME] | [NAME]
Leader | [NAME] | [NAME] | [NAME] | [NAME]
Leader | [NAME] | [NAME] | [NAME] | [NAME]
Leader | [NAME] | [NAME] | [NAME] | [NAME]
Leader | [NAME] | [NAME] | [NAME] | [NAME]
Leader | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: 136362d1326571481-combine-multiple-data-sets-into-one-master-spreadsheet-invoice_example_mod
Sheet: Summary

Category | Sub-category | Invoice 1 | Invoice 2 | Invoice 3 | Invoice 4 | Total
Books | Bilbo |  |  | 10 |  | 10
Books | [NAME] |  | 7 |  |  | 7
Books | Tarzan |  |  | 7 | 12 | 19
Books | The Hobbit | 12 | 10 |  |  | 22
Food | Apples |  |  | 5 |  | 5
Food | Grapes | 6.75 | 5 |  |  | 11.75
Food | Orange |  |  |  | 6.75 | 6.75
Toys | Dinosaur |  |  | 1 |  | 1
Toys | Dragon Fly |  |  |  | 5.5 | 5.5
Toys | He-Man | 5.5 | 1 |  |  | 6.5
Toys | Transformers | 10 |  |  | 10 | 20
 | Total | 34.25 | 23 | 23 | 34.25 | 114.5
Spreadsheet: 751593d1634203797-need-a-formula-for-the-column-letter-to-use-in-indirect-ytd-formula-v3-tms
Sheet: Sheet1

 | 5
 |  | 2020-07-31 00:00:00 | 0.01
 |  | 2020-08-31 00:00:00 | 0.01
 |  | 2020-09-30 00:00:00 | 0.01
 |  | 2020-10-31 00:00:00 | 0.01
 |  | 2020-11-30 00:00:00 | 0.01
 |  | 2020-12-31 00:00:00 | 0.01
 |  | 2021-01-31 00:00:00 | 0.01 |  | 0.01
 |  | 2021-02-28 00:00:00 | 0.01 |  | 0.01
 |  | 2021-03-31 00:00:00 | 0.01 |  | 0.01
 |  | 2021-04-30 00:00:00
 |  | 2021-05-31 00:00:00
 |  | 2021-06-30 00:00:00
 |  | 2021-07-31 00:00:00
 |  | 2021-08-31 00:00:00
 |  | 2021-09-30 00:00:00
 |  | 2021-10-31 00:00:00
 |  | 2021-11-30 00:00:00
 |  | 2021-12-31 00:00:00
 |  | 2022-01-31 00:00:00
 |  | 2022-02-28 00:00:00
 |  | 2022-03-31 00:00:00
 |  |  |  |  |  | replaces match row
 |  |  |  |  |  | replaces range number for product formula
 |  |  |  |  |  | replaces the column letter (to count how many months)
 |  |  | beg of year date | 2021-01-31 00:00:00 |  | range needs to start at A1
 |  |  |  |  | =cell("address",row(),column))
 |  |  |  |  |  | =PRODUCT(1+(INDIRECT(SUBSTITUTE(TRIM(LEFT(SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$",REPT(" ","50"),2),4)),"$","")&MATCH($E$34,$C$1:$C$25,0)&":"&SUBSTITUTE(TRIM(LEFT(SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$",REPT(" ","50"),2),4)),"$","")&MATCH($E$34,$C$1:$C$25,0)+MONTH(EOMONTH(TODAY(),-1)))))-1
 |  |  |  |  |  | =PRODUCT(1+(INDIRECT(F54&MATCH($E$34,$C$1:$C$25,0)&":"&F54&MATCH($E$34,$C$1:$C$25,0)+MONTH(EOMONTH(TODAY(),-1)))))-1
 |  |  |  |  |  | =PRODUCT(1+(INDIRECT(F55&MATCH($E$34,$C$1:$C$25,0)&":"&F55&MATCH($E$34,$C$1:$C$25,0)+MONTH(EOMONTH(TODAY(),-1)))))-1
 |  |  |  |  |  | =PRODUCT(1+(INDIRECT(vAddr&MATCH($E$34,$C$1:$C$25,0)&":"&vAddr&MATCH($E$34,$C$1:$C$25,0)+MONTH(EOMONTH(TODAY(),-1)))))-1
 |  |  |  |  |  | =SUBSTITUTE(TRIM(LEFT(SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$",REPT(" ","50"),2),4)),"$","")
 |  |  |  |  |  | =vAddr
Spreadsheet: 217751d1362168426-spreadsheet-improvement-competency-matrix-test
Sheet: Training Req.

Job Title | General Safety | Operator Training | [NAME] | CMS Training | Steel Defects | IS0 14001 Awareness | [NAME] | First Aid /CPR | Lock Out Tag Out | [NAME] | Outside Education
Supervisor | X | X | O | X | O | X | X | X | O | X | O
[NAME] | X | X | O | X | O | X | O | X | X | X | O
Operator | X | X | O | X | O | X | X | O | O | X | O
Material Handler | X | nr | X | nr | nr | X | nr | O | O | X | O
Quality Tech | X | O | O | X | O | X | X | O | O | X | O
[NAME] | X | nr | O | O | nr | X | O | X | X | X | O
Forklift Repair | X | nr | X | O | nr | X | nr | O | nr | X | O
Production Manager | X | O | O | X | O | X | X | O | nr | X | O
Quality Auditor | X | O | O | X | O | X | X | O | nr | X | O
Die Repair | X | nr | O | nr | nr | X | nr | O | X | X | O
Die Setter | X | nr | X | nr | nr | X | O | O | X | X | O
X=Required  O=Optional nr=Not Required
FRM-62-01-04 | [NAME]
FRM-62-02 | Material Handler checklist
FRM-62-03 | Operator Training Check List
In House Training | Steel Defects (optional)
FRM-62-01-05 | CMS Training
Testing | [NAME]
 | General Safety Training
G=Grandfathered
X = Trained
C =  Competent
Spreadsheet: mike_grigsby__27889__Phillip_Email_New2
Sheet: Sheet1

West Desk P&L Summary
 | Today is: |  | Today | Yesterday | MTD | YTD
 | MGMT-WEST | [NAME] |  | 574857.3459000001
 | FT-PGE |  |  | -895444.2309000012
 | WC-CAL | [NAME] |  | -3920811.827547966
 | WC-PERM | Sanchez |  | 0
 | WT-SOCAL | Holst |  | 260404.9464000028
 | WT-CAL | Ermis |  | -556167.3399999705
 | Denver | Reitmeyer |  | -825122.5472499985
 | FT-REGS | Tholt |  | -461296.4875000003
 | WC-ROX | South |  | -137279.6765000001
 | WT-ROX | Lenhart |  | -1437597.259600001
 | WC-SJ | Gay |  | -266709.3895000168
 | WT-SJ | Kuykendahl |  | -475404.0176
 | WC-SOCAL | [NAME] |  | -43895.24249999999
 | WC-NOCAL | Wolfe |  | -193957
 |  | Total: |  | -8378422.726597952
Spreadsheet: 61b20ff1-dd8e-45f4-8580-15014886f7f5
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43163383 | 2014-09-15 00:46:50 | AXIS | 1 | 6 | 5 | 1479663 | [NAME] Pede | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
43163658 | 2014-09-15 01:11:13 | ALLIES | 1 | 6 | 2 | 1479663 | [NAME] Pede | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
43203647 | 2014-09-18 00:14:44 | AXIS | 0 | 2 | 5 | 414482 | [NAME] | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
43203908 | 2014-09-18 00:37:32 | ALLIES | 1 | 5 | 4 | 414482 | [NAME] | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
43217423 | 2014-09-19 01:28:28 | AXIS | 1 | 6 | 1 | 1062369 | a.patchett | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
43217527 | 2014-09-19 01:37:34 | ALLIES | 1 | 6 | 1 | 1062369 | a.patchett | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
43286827 | 2014-09-24 00:17:43 | ALLIES | 1 | 7 | 4 | 1422784 | flarchi | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43287281 | 2014-09-24 00:28:40 | AXIS | 1 | 4 | 0 | 1637830 | paolomazzeoinbox1 | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet