tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7888__011023Am
Sheet: LetterSizeRegionLoc 

ETS Planned And Unplanned Outages - May 1, 2001 Through May 31, 2002
Amarillo Region Only - Sorted By Region/Location
The information provided is tentative and may be changed without further notice.  Northern Natural Gas, [NAME] and Florida Gas Transmission are not responsible for any reliance on this information.
Data Extracted October 23, 2001 |  |  |  |  |  |  |  |  |  |  | Est. Flow | Est. Vol. |  |  | Act. | Act. | Act. | Act.
No. | ID# | Location | Units | Title | EstStart | EstComp | Duration | Line | Proj. Mgr | W.O. # | Affected | Affected | DescOfWork | DescOfWork2 | Start | Compl. | [NAME]. | Throughput | P/U | Pub | Ver
 |  |  |  |  |  |  |  |  |  |  | (Mmcfd) |  |  |  |  |  | mmcf/d | Affect
1 | 17588 | [NAME] 2 | 3 | PISTON & HEAD | 2001-09-22 09:00:00 | 2001-11-09 16:00:00 | 48.3 |  | OPS |  | 0 | 0 | Change 2 pistons and 1 head. (Waiting on [NAME] and oil rings). |  | 2001-09-22 09:00:00 |  | 0 |  | U | N | N
2 | 17740 | BEAVER 5 | 4 | ELMWOOD PLANT | 2001-10-17 11:00:00 | 2001-10-18 16:00:00 | 1.2 |  | OPS |  | 0 | 0 | Unit down due to Elmwood Plant commoned southeast 24" and 8". Unit will not be able to buck high discharge pressure. |  | 2001-10-18 11:00:00 |  | 0 |  | U | N | N
3 | 17449 | ELLIS 1 | 3 | 1500 HR INSP | 2001-10-12 13:00:00 | 2001-10-20 16:00:00 | 8.1 |  | OPS |  | 2 | 16.3 | Install new Opto control Panel  1500 Hr. Inspection. Update 10/12 - taking unit down to get a jump on Monday's panel board installation. Will adjust other units to accommodate volume. |  |  |  | 0 |  | P | N | N
4 | 17450 | ELLIS 1 | 4 | 1500 HR INSP | 2001-10-30 09:00:00 | 2001-10-30 11:00:00 | 0.1 |  | OPS |  | 5 | 0.4 | 1500 Hr. Inspection.  1035 HP |  |  |  | 0 |  | P | N | N
5 | 17723 | PAMPA | A LINE | A LINE LEAKS | 2001-11-05 08:00:00 | 2001-11-09 16:00:00 | 4.3 | TXG89001 | OPS |  | 0 | 0 | Repair three leaks on A line.  This will necessitate shutting in OneOK's [NAME] plant (2.2 m 2/d) as well as Skellytown TBS (50 mcf/d) and Crawford Plant Fuel which is used only as an emergency back up. |  |  |  | 0 |  | P | N | N
6 | 17016 | [NAME] | 5 | MECHNICAL FAILURE | 2001-06-19 16:00:00 | 2001-11-30 16:00:00 | 164 |  | OPS |  | 0 | 0 | They had a mechnical failure on unit #5. Not sure of the exact completion. |  | 2001-06-19 16:00:00 |  | 0 |  | U | N | N
7 | 15944 | SPEARMAN | 2 | OVERHAUL | 2001-10-29 08:00:00 | 2001-11-16 12:00:00 | 18.2 | TM103-02 | OPS |  | 0 | 0 | Minor overhaul.  The date may change  depending on #3 CB control project.  2250 HP (Will not start on this outage until unit 3 is back to normal operation). Start date moved back to coordinate with customer outages  per their request. |  |  |  | 0 |  | P | N | N
Spreadsheet: 870073d1716577092-do-i-use-a-lookup-index-or-match-new-crop-logs-template
Sheet: Crop Logs

Legend |  |  |  |  |  | Today's Date |  | Room |  | Cycle |  | Plug Date | 2024-06-01 00:00:00 | # of Tables | 32
Target Event |  | Hours | Instructions |  |  | Cultivar | APPLE |  | BPR |  |  | Harvest Date
A | Pinch |  | 1 | Pinch to 3 branches. |  | Day of Cycle | Date | Target | Actual | Event | Instructions | Instructions | Instructions | Notes |  | # of | # of | Target | Actual
B | 1st Touch | 1.375 | 2 | Pinch to 4 branches. |  | 0 |  | Event | Event | Code |  |  |  |  |  | People | Tables | Hours | Hours
C | 2nd Touch | 1.688 | 3 | Pinch to 5 branches. |  | 1
D | 3rd Touch | 1.855 | 4 | Pinch to 6 branches. |  | 2
E | 4th Touch | 1.855 | 5 | Pinch to 7 branches. |  | 3
F | 5th Touch | 1.855 | 6 | Pinch to 8 branches. |  | 4
G | 6th Touch | 1.855 | 7 | Pinch to 9 branches. |  | 5
 |  |  | 8 | Pinch to 10 branches. |  | 6
 |  |  | 9 | Pruning |  | 7
 |  |  | 10 | Defoliation |  | 8
 |  |  | 11 | [NAME] |  | 9
 |  |  | 12 | [NAME] |  | 10
 |  |  | 13 | [NAME] |  | 11
 |  |  | 14 | Main Cola Defol (Haircut) |  | 12
 |  |  |  |  |  | 13
 |  |  |  |  |  | 14
 | Total |  |  |  |  | 15
 | People |  |  |  |  | 16
 | (Actual) |  |  |  |  | 17
 | Total Target |  |  |  |  | 18
 | Hours |  |  |  |  | 19
 | (Projected) |  |  |  |  | 20
 | Total Actual |  |  |  |  | 21
 | Hours |  |  |  |  | 22
 | (Currently) |  |  |  |  | 23
 | Total Nets |  |  |  |  | 24
 | Needed |  |  |  |  | 25
 |  |  |  |  |  | 26
 | Total Bags of |  |  |  |  | 27
 | Zips Used |  |  |  |  | 28
 | Needed |  |  |  |  | 29
 | Total Table |  |  |  |  | 30
 | Covers Used |  |  |  |  | 31
 | Needed |  |  |  |  | 32
 |  |  |  |  |  | 33
 |  |  |  |  |  | 34
 |  |  |  |  |  | 35
 |  |  |  |  |  | 36
 |  |  |  |  |  | 37
 |  |  |  |  |  | 38
 |  |  |  |  |  | 39
 |  |  |  |  |  | 40
 |  |  |  |  |  | 41
 |  |  |  |  |  | 42
 |  |  |  |  |  | 43
 |  |  |  |  |  | 44
 |  |  |  |  |  | 45
 |  |  |  |  |  | 46
 |  |  |  |  |  | 47
 |  |  |  |  |  | 48
 |  |  |  |  |  | 49
 |  |  |  |  |  | 50
 |  |  |  |  |  | 51
 |  |  |  |  |  | 52
 |  |  |  |  |  | 53
 |  |  |  |  |  | 54
 |  |  |  |  |  | 55
 |  |  |  |  |  | 56
 |  |  |  |  |  | 57
 |  |  |  |  |  | 58
 |  |  |  |  |  | 59
 |  |  |  |  |  | 60
 |  |  |  |  |  | 61
 |  |  |  |  |  | 62
 |  |  |  |  |  | 63
 |  |  |  |  |  | 64
 |  |  |  |  |  | 65
 |  |  |  |  |  | 66
 |  |  |  |  |  | 67
 |  |  |  |  |  | 68
 |  |  |  |  |  | 69
 |  |  |  |  |  | 70
 |  |  |  |  |  | 71
 |  |  |  |  |  | 72
 |  |  |  |  |  | 73
 |  |  |  |  |  | 74
 |  |  |  |  |  | 75
 |  |  |  |  |  | 76
 |  |  |  |  |  | 77
 |  |  |  |  |  | 78
 |  |  |  |  |  | 79
 |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total People/Hours
Spreadsheet: 690571d1597168850-need-vlookup-to-return-the-value-to-the-right-test
Sheet: Int'l

Vin NUMBER | Est. Delivery
326702 | 2020-09-12 00:00:00
327093 | 2020-09-12 00:00:00
657871 | 2020-09-12 00:00:00
589659 | 2020-09-12 00:00:00
603101 | 2020-09-12 00:00:00
603151 | 2020-09-12 00:00:00
621012 | 2020-09-12 00:00:00
629045 | 2020-09-12 00:00:00
651702 | 2020-09-12 00:00:00
844025 | 2020-10-17 00:00:00
868300 | 2020-10-10 00:00:00
615621 | 2020-10-10 00:00:00
420690 | 2020-10-31 00:00:00
Spreadsheet: 117090d1312442533-one-way-data-table-pmt
Sheet: Sheet3

Loan Amount | 5000
Loan Period | 60
Rates | 0.05 | 0.055 | 0.06 | 0.065 | 0.07 | 0.075 | 0.08 | 0.085 | 0.09
Monthly Payment
Total Payments
Total Interest
Spreadsheet: 1733604b-0d7f-46d4-8f93-293141ab80b3
Sheet: Sheet1

Form ID | Source of form | Subject | Completion Date | "File by" Date | Significance | Required Signatures
T-1 | web-based  (worksheet available) | Daily Ridership, Mileage, Vehicle inventory | First full week of October  May be amended prior to January 31 | Nov 1  Amendments due by Jan 31 | Data from this report is used to calculate district transportation reimbursement. This data is also used for calculation of public bus purchase subsidy. Includes all student riders, regular and special ed. | Superintendent and Treasurer required  Transp Adm optional
T-1s | web-based  (worksheet available) | Extra service days for nonpublic, community, and/or vocational schools | End of school year | 2004-07-01 00:00:00 | Used to report additional miles run by districts to provide service for approved nonpublic, community, or vocational schools on days public schools are not in session.  This data is used to generate a per mile reimbursement paid to the district. | Superintendent and Treasurer required  Transp Adm optional
T-2 contractor | web-based  (worksheet available) | Transportation cost reporting/certification | End of fiscal year | 2004-07-15 00:00:00 | Data on this report is used for certification of rider/mileage claims filed on T-1, and as backup support for district reported Type II costs on the T-2. Contractors must submit T-2C to districts by July 15 | Contractor
T-2 | web-based  (worksheet available) | Cost reporting/certification | End of fiscal year | 2004-08-01 00:00:00 | Data from this report is used for certification of rider/mileage claims filed on T-1.  This data is also aggregated  to determine the constant factors of the regression analysis which drives reimbursement costs. | Superintendent and Treasurer required  Transp Adm optional
T-8 | web-based (paper form required) | School Bus Driver Physical | After May 1st for returning drivers, and before operating a school bus in the next school year | Before operating  a  school bus, or within 30 days of physical date | All school bus drivers are required to have a current physical on file with the Department of Education. The T8 must be filed electronically by September 1. | Superintendent or  Transportation Adm.
T-8V | downloadable form | [NAME] | After May 1st for returning drivers, and before operating a van transporting pupils in the next school year | Report on line | All certified drivers are required to have a current physical on file with the employer.  These forms are not submitted to ODE-evidence of completion is kept locally.  The T8V must be filed electronically by September 1. | Superintendent or  Transportation Adm.
T-10 | web-based  (worksheet available) | Accident report | Within 15 days of crash |  | Must be submitted for any bus crash resulting in injury or damage in excess of $500 | Superintendent or Transportation Adm.
T-9 | web-based  (Paper form for OBI required) | Driver certification | upon completion of driver training |  | Used to report completion of training for new drivers, and for 6 year recertification of veteran drivers | Superintendent or Transportation Adm.
Spreadsheet: 126173d1319555661-excel-2008-show-multiple-values-with-index-function-the-league-owner-info
Sheet: Owner Info

 | Name | [NAME] | Cell | Bank Account Number | Social Security Number | Home Address
My Couch Pulls Out, I Don't | [NAME] |  |  | 5555-5555-5555 | 555-55-5555 | 5555 [NAME]
Level 55 [NAME] | [NAME]
Illegal Use of the Hands | [NAME]
Fire@Will | Bret M. & Rahman
VICK walks my dog | [NAME]
ROMOsexual Tendencies | Kazim Khalil
Farve Dollar Footlong | Bhuvneesh Singh
[NAME] [NAME]? | [NAME]
The Genitle Giants | [NAME]
Team Haque | [NAME]
99 Problems But A FITZ Aint One | Ryan "Undefeated" Shaughnessy
Shrimp Flied Lice | [NAME]
Somewhere Over [NAME] | Charles & Phuong
Pelaez Lawncare Services | [NAME] |  |  | i have no money :(
Spreadsheet: 105708d1302976715-excel-2007-how-to-sort-text-in-column-when-the-targeted-words-are-not-in-order-book1_emil9216-
Sheet: Sheet1

 |  |  | classic | music |  | real rock music |  | Is classic in string G1? | 0 |  | Is music in string G1? | 1 |  | Combine the two formulae with AND() > | Are botth in G1? | 0
 |  |  |  |  |  | real rap music |  | Is classic in string G2? | 0 |  | Is music in string G2? | 1 |  | To get C/F formula | Are botth in G2? | 0
 |  |  |  |  |  | real classic music |  | Is classic in string G3? | 1 |  | Is music in string G3? | 1 |  |  | Are botth in G3? | 1
 |  |  |  |  |  | clasic music |  | Is classic in string G4? | 0 |  | Is music in string G4? | 1 |  |  | Are botth in G4? | 0
 |  |  |  |  |  | real classic music |  | Is classic in string G5? | 1 |  | Is music in string G5? | 1 |  |  | Are botth in G5? | 1
 |  |  |  |  |  | real clasic |  | Is classic in string G6? | 0 |  | Is music in string G6? | 0 |  |  | Are botth in G6? | 0
 |  |  |  |  |  | real classic music |  | Is classic in string G7? | 1 |  | Is music in string G7? | 1 |  |  | Are botth in G7? | 1
 |  |  |  |  |  | real classic music |  | Is classic in string G8? | 1 |  | Is music in string G8? | 1 |  |  | Are botth in G8? | 1
 |  |  |  |  |  | real music |  | Is classic in string G9? | 0 |  | Is music in string G9? | 1 |  |  | Are botth in G9? | 0
 |  |  |  |  |  | rap music |  | Is classic in string G10? | 0 |  | Is music in string G10? | 1 |  |  | Are botth in G10? | 0
 |  |  |  |  |  | real classic music |  | Is classic in string [NAME]? | 1 |  | Is music in string [NAME]? | 1 |  |  | Are botth in G11? | 1
 |  |  |  |  |  | classic music real |  | Is classic in string G12? | 1 |  | Is music in string G12? | 1 |  |  | Are botth in G12? | 1
 |  |  |  |  |  | classic rock |  | Is classic in string G13? | 1 |  | Is music in string G13? | 0 |  |  | Are botth in G13? | 0
 |  |  |  |  |  |  |  | NOTES
 |  |  |  |  |  |  |  | SEARCH($D$1,G1,1) will return #[NAME] if the word is not in the string and a number if it is.
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | So we use
 |  |  |  |  |  |  |  | ISNUMBER(SEARCH($D$1,G1,1)) to return TRUE/FALSE
 |  |  |  |  |  |  |  | 0
Spreadsheet: 32935d1229098073-how-do-i-give-columns-a-value-and-calculate-the-total-of-the-highlighted-cells-calchrsworked
Sheet: Sheet2

 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 18:00:00 | 20:30:00 | HrsWkd
Monday | Sé
 |  | [NAME] | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  | Elenor | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  | Carly | x | x | x | x | x | x | x | x | x | x | x | x
 |  | Kardina | x | x | x | x | x | x | x | x
 |  |  | [NAME] | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Petra
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Rebecca
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Damiet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Tuesday | Sé
 |  | Elenor
 |  | Petra
 | Roisin
 |  | Kardina
 |  |  |  | [NAME]
 |  |  |  | Madeline
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Ra…
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rebecca
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Julien
Spreadsheet: 32817-drop-down-list-help-example
Sheet: Sheet1

Subcontractor
Builder 1
Builder 2
Builder 3
Builder 4
Builder 5
Builder 6
Builder 7
Builder 8
Builder 9
Builder 10
Builder 11
Builder 12
Builder 13
Builder 14
Builder 15
Builder 16
Builder 17
Builder 18
Builder 19
Builder 20
Builder 21
Builder 22
Builder 23
Builder 24
Builder 25
 | Total for |  |  | <--- this is where I want the filtered trade name to be put.
Spreadsheet: 690406d1597083073-using-sum-and-count-function-in-a-pivot-table-summary-consolidated-sheet
Sheet: 07082020

 |  | [NAME] | [NAME] | JO/20/096 HRS | JO/20/096 OT | JO/20/144 HRS | JO/20/144 OT | CPC HRS | CPC OT | Maintainance / Other works  HRS | Maintainance / Other works  OT
1 | MATHEW
2 | KESHVAN
3 | SIVADAS |  |  |  |  |  |  |  | 8
4 | ANSARI
5 | RAGESH
6 | MUKUNDA
7 | ABBASI
8 | UPENDRA
9 | MARTIN
22 | SAMUEL
10 | FELIX |  | 8
11 | DIPAK
12 | SATHYA
13 | RAJEEV
16 | [NAME] |  | 8
 | [NAME] |  |  |  | 5
17 | FLORENCIO
14 | VINOTH
15 | RAJA
19 | [NAME]
24 | SON
 | MANSA
25 | SIMHA
18 | MALIK |  |  |  | 5
20 | SIVA
 | GEORGE
21 | SUDHI |  |  |  | 4 |  | 4
23 | RAVI |  |  |  | 5
 | HEMA |  |  |  | 4 |  | 4
35
COMMENTS :
Spreadsheet: 695080d1600036665-spin-box-with-date-week_cal-bvj-
Sheet: SEE THIS SHEET

257 | 2020
 |  |  | 1. DERS | 2. DERS | 3. DERS
 |  | TIME |  |  |  | 0
 |  | CLASS
 |  | PLATFORM
 |  | SUBJECT
 |  | PARTICIPANTS
 |  | TIME
 |  | CLASS
 |  | PLATFORM
 |  | SUBJECT
 |  | PARTICIPANTS
 |  | TIME
 |  | CLASS
 |  | PLATFORM
 |  | SUBJECT
 |  | PARTICIPANTS
 |  | TIME
 |  | CLASS
 |  | PLATFORM
 |  | SUBJECT
 |  | PARTICIPANTS
 |  | TIME
 |  | CLASS
 |  | PLATFORM
 |  | SUBJECT
 |  | PARTICIPANTS
 |  | TIME
 |  | CLASS
 |  | PLATFORM
 |  | SUBJECT
 |  | PARTICIPANTS
 |  | TIME
 |  | CLASS
 |  | PLATFORM
 |  | SUBJECT
 |  | PARTICIPANTS
 |  |  |  | Ders Öğretmeni: | Mehmet DEMİRBAŞ
 |  |  |  | Branşı: | [NAME]
Spreadsheet: 865046d1712141830-sum-merged-non-merged-cells-test2
Sheet: Sheet1

Primary | Secondary | Qty |  |  |  | Primary | Secondary | Qty
A | 1 | 1 |  |  |  | A | 1 | 1
 | 2 | 6 |  |  |  | D | 7 | 5
 | 3 | 5 |  |  |  | A | 2 | 6
 | 4 | 7 |  |  |  | C | 7 | 7
B | 5 | 4 |  |  |  | B | 5 | 4
 | 6 | 2 |  |  |  | D | 5 | 1
 | 2 | 4 |  |  |  | C | 3 | 3
 | 1 | 0 |  |  |  | A | 3 | 5
C | 7 | 7 |  |  |  | B | 6 | 2
 | 3 | 3 |  |  |  | D | 9 | 1
 | 5 | 0 |  |  |  | A | 4 | 7
 | 4 | 0 |  |  |  | B | 2 | 4
D | 7 | 5
 | 5 | 1
 | 9 | 1
 | 8 | 0
 |  | Manual
Spreadsheet: 774707d1648630514-match-index-troubles-example
Sheet: Sheet1

Country | MP | L | B | H | Size | From | To | Weight | Costs |  | L (mm) | B (mm) | H ([NAME]) | KG | Result | Should be
 |  | 20 | 15 | 1 |  | 0 | 80 |  | 1.8 |  | 340 | 240 | 80 | 0.8 |  | 3.55
 |  | 33 | 23 | 2.5 |  | 0 | 60 |  | 1.98
 |  | 33 | 23 | 2.5 |  | 0 | 210 |  | 2.12
 |  | 33 | 23 | 2.5 |  | 0 | 460 |  | 2.27
 |  | 33 | 23 | 4 |  | 0 | 960 |  | 2.6
 |  | 33 | 23 | 6 |  | 0 | 960 |  | 2.96
 |  | 35 | 25 | 12 |  | 0 | 150 |  | 2.87
 |  | 35 | 25 | 12 |  | 151 | 400 |  | 3.18
 |  | 35 | 25 | 12 |  | 401 | 900 |  | 3.55
 |  | 35 | 25 | 12 |  | 901 | 1400 |  | 4.19
 |  | 35 | 25 | 12 |  | 1401 | 1900 |  | 4.56
 |  | 35 | 25 | 12 |  | 1901 | 3900 |  | 5.72
 |  | 45 | 34 | 26 |  | 0 | 150 |  | 3.09
 |  | 45 | 34 | 26 |  | 151 | 400 |  | 3.48
 |  | 45 | 34 | 26 |  | 401 | 900 |  | 3.94
 |  | 45 | 34 | 26 |  | 901 | 1400 |  | 4.64
 |  | 45 | 34 | 26 |  | 1401 | 1900 |  | 5.1
 |  | 45 | 34 | 26 |  | 1901 | 2900 |  | 5.7
 |  | 45 | 34 | 26 |  | 2901 | 3900 |  | 6.28
 |  | 45 | 34 | 26 |  | 3901 | 5900 |  | 6.61
 |  | 45 | 34 | 26 |  | 5901 | 8900 |  | 7.13
 |  | 61 | 46 | 46 |  | 0 | 760 |  | 5.89
 |  | 61 | 46 | 46 |  | 761 | 1126 |  | 5.91
 |  | 61 | 46 | 46 |  | 1127 | 1760 |  | 5.93
Spreadsheet: 746496d1630769072-converting-the-structure-of-raw-data-into-a-usable-format-parent-child-arrangement-vj-raj-
Sheet: Sheet1

Level | Part |  |  | Parent Part | Material |  | 0 | 1 | 2 |  |  | Parent Part | Material |  |  |  |  |  |  |  |  |  |  | Converting the structure of raw data into a usable format (excelforum.com)
0 | ABC |  |  | ABC | BC
1 | BC |  |  | BC | B
2 | B |  |  | BC | C
2 | C |  |  | DEF | DF
0 | DEF |  |  | DF | D
1 | DF |  |  | DF | F
2 | D
2 | F
Spreadsheet: 727998d1618243521-when-using-isnumber-i-cant-change-the-cell-format-goal-and-trend-formulas-
Sheet: Sheet1

Start Date | 2021-04-01 00:00:00 | Hours Goal | Sales | Gross
End Date | 2021-04-30 00:00:00 | 3000 | 265000 | 165000
Days in Month |  | Advisor Count | Advisor Count
Days Worked |  | 3 | 3
Remaining Days |  | Advisor Hours | Advisor Sales
 |  | 1000
Emp # | 7 | 8 | 16 | 24 | Grand Total
Sold Hours | 254 | 6.85 | 1263.570000000002 | 6.57 | 19253.44999999986
Trend
Goal
[NAME]
Emp # | 7 | 8 | 16 | 24 | Grand Total
Total Sales | 3167899.650000073 | 1270.6 | 337892.9400000022 | 1456.89 | 5436027.630000074
Trend
Goal
[NAME]
Spreadsheet: 97711d1296823515-excel-2007-how-to-add-next-column-value-for-consecutive-patterns-test
Sheet: Sheet1

 | code | value
 | 1 | 2 |  |  | value  of [NAME] of code 0 | =7
 | 0 | 3
 | 1 | 3 |  |  | Value of [NAME] of code 1 | =11 | (not 9)
 | 1 | 1
 | 1 | 2
 | 1 | 3
 | 0 | 4
 | 0 | 4
 | 1 | 2
 | 0 | 3
 | 0 | 2
 | 0 | 2
 | 1 | 2
 | 1 | 4
 | 1 | 4
 | 1 | 1
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Woodford

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 881323d1729373456-how-many-vehicles-can-be-held-on-o-license-o-license
Sheet: Vehicles Permitted

[NAME] | Cost | Cash Reserve Required
1 | 8500
2 | 4500
3 | 4500
4 | 4500
5 | 4500
6 | 4500
7 | 4500
8 | 4500
9 | 4500
10 | 4500
11 | 4500
12 | 4500
13 | 4500
14 | 4500
15 | 4500
16 | 4500
17 | 4500
18 | 4500
19 | 4500
20 | 4500
21 | 4500
22 | 4500
23 | 4500
24 | 4500
25 | 4500
26 | 4500
27 | 4500
28 | 4500
29 | 4500
30 | 4500
31 | 4500
32 | 4500
33 | 4500
34 | 4500
35 | 4500
36 | 4500
37 | 4500
38 | 4500
39 | 4500
40 | 4500
41 | 4500
42 | 4500
43 | 4500
44 | 4500
45 | 4500
46 | 4500
47 | 4500
48 | 4500
49 | 4500
50 | 4500
51 | 4500
52 | 4500
53 | 4500
54 | 4500
55 | 4500
56 | 4500
57 | 4500
58 | 4500
59 | 4500
60 | 4500
61 | 4500
62 | 4500
63 | 4500
64 | 4500
65 | 4500
66 | 4500
67 | 4500
68 | 4500
69 | 4500
70 | 4500
71 | 4500
72 | 4500
73 | 4500
74 | 4500
75 | 4500
Spreadsheet: 79252ca4-57e5-4238-add2-2ee24f5eb618
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
43511671 | 2014-10-10 00:33:38 | AXIS | 1 | 12 | 7 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43597023 | 2014-10-15 22:27:30 | AXIS | 1 | 5 | 3 | 805202 | canonman | 7430 | mediterranean | 1942-05-27 | 1942-05-27 | 1st Armoured to the rescue | Engagement blindé
43597244 | 2014-10-15 22:35:40 | ALLIES | 0 | 1 | 5 | 805202 | canonman | 7430 | mediterranean | 1942-05-27 | 1942-05-27 | 1st Armoured to the rescue | Engagement blindé
43626071 | 2014-10-18 02:02:56 | ALLIES | 0 | 2 | 7 | 1503014 | Agent Avacado | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43646619 | 2014-10-19 14:13:32 | AXIS | 1 | 4 | 3 | 1657989 | rafael-r.94 | 6162 | western | 1944-06-06 | 1944-06-06 | Pointe-du-Hoc | Pointe-du-Hoc
43646734 | 2014-10-19 14:30:04 | ALLIES | 0 | 3 | 4 | 1657989 | rafael-r.94 | 6162 | western | 1944-06-06 | 1944-06-06 | Pointe-du-Hoc | Pointe-du-Hoc
43664656 | 2014-10-20 19:28:28 | AXIS | 1 | 6 | 5 | 1362585 | NEMAUS | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
43665062 | 2014-10-20 19:44:33 | ALLIES | 0 | 2 | 6 | 1362585 | NEMAUS | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
Spreadsheet: 97618d1296747081-looking-for-formula-that-will-catch-special-rule-abuse-for-the-same-id-2011_02_03_reply
Sheet: Sheet1 (3)

ID | date | SLED |  | check
22 | 2010-01-27 00:00:00 | 2012-01-12 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-14 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-17 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-12 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-20 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-18 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-18 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-20 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-19 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-19 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-31 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-28 00:00:00 | 2012-02-20 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-21 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-29 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-29 00:00:00 | 2012-02-29 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
Spreadsheet: 792507d1660928213-scoring-and-ranking-values-book-1
Sheet: Sheet1

values | Scoring between two numbers(-5,+5) | ranking
13
25 |  |  |  |  |  | note
12 |  |  |  |  |  | The bigest number is 41, so it should take the score of +5
4 |  |  |  |  |  | The smallest number is -18, so it should take the score of -5
-9 |  |  |  |  |  | A value of 0 should get 0 points
2 |  |  |  |  | How do other values get their points according to the ratio of 41 and -18 and finally be ranked
9
41 | 5
0 | 0
-14
-18 | -5
22
9
34
10