tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 221145d1363379378-protect-text-box-from-formatting-but-not-input-excel-tip-example
Sheet: Sheet 1 - Table 27

 | ORDER FORM PROJECT NAME |  |  | COMPANY NAME
 | ORDERED BY |  |  | DATE
 | Item | QTY | Description | Square Foot per 5 GAL/1 GAL on EZ-Fill | Total SF of Material Coverage
 | C-360-05 |  | Cleanse360 | 2000 | 0
 | C-410-05 |  | SureBond | 2000 | 0
 | C-510-01P |  | EZ-Fill | 26 | 0
 | C-510-01W |  | EZ-Fill | 26 | 0
 | C-550-30 |  | Smooth Caulk | N/A | 0
 | C-610-05 |  | PrimaShield | 1000 | 0
 | C-710-05 |  | ThermaShield | 500 | 0
 | C-810-05 |  | SolaShield WB | 750 | 0
 | C-810-05 |  | SolaShield TB | 750 | 0
 | C-810-05 |  | SolaShield DB | 750 | 0
 | C-810-05 |  | SolaShield AB | 750 | 0
 | C-910-01 |  | ExcellPaint PB | 300 | 0
 | C-910-01 |  | ExcellPaint TB | 300 | 0
 | C-910-01 |  | ExcellPaint DB | 300 | 0
 | C-910-01 |  | ExcellPaint AB | 300 | 0
 | C-910-05 |  | ExcellPaint PB | 1500 | 0
 | C-910-05 |  | ExcellPaint TB | 1500 | 0
 | C-910-05 |  | ExcellPaint DB | 1500 | 0
 | C-910-05 |  | ExcellPaint AB | 1500 | 0
 | C-210-01 |  | EAGLE Water-Repellent | 100 | 0
 | C-210-05 |  | EAGLE Water-Repellent | 500 | 0
 | Total Items: | 0 |  |  | 0
Spreadsheet: 491145d1480340012-pivot-cell-centring-transfer-destination-report-nd-template
Sheet: SSCC - GROUPED SUMMARY

FNB Sales and Service Contact Centre
Call Transfer Summary for the Period: <SingleValueFormula>
Sales |  |  | * only displaying values > 3%
Skill Group | Calls Answered | Calls Transferred | % Trf | % Trf to Answer, per Area | % Trf to Total Answer
<CH21_Level>
<Area_Grp_3> | <[NAME] | <Transfers> | <% - Trf /  Volume_2> | <%  - Trf / Answer_1> | <%  - Trf / TOTAL Answer>
</CH21_Level>
Service |  |  | * only displaying values > 3%
Area Group | Calls Answered | Calls Transferred | % Trf | % Trf to Answer, per Area | % Trf to Total Answer
<CH52_Level>
<Area_Grp> | <Calls Answered> | <Transfers_1> | <% - Trf /  Volume_1> | <%  - Trf / Answer_2> | <%  - Trf / TOTAL Answer_1> | <test volume>
</CH52_Level>
Spreadsheet: 105256d1302684845-array-or-pivot-make-a-sum-if-the-value-of-one-cell-falls-within-a-date-range-sumifvaluewithindate-del
Sheet: Sheet2

 |  | Project Name | Value | First Step Complete Date | Second Step Complete Date | Third Step Complete Date |  | Before 2013? 1 = Y | Size At End 2012
 |  | Project 1 | 5 | 2011-03-29 08:00:00 | 2011-07-18 17:00:00 |  |  | 1
 |  | Project 2 | 6 | 2011-04-05 17:00:00 | 2011-07-26 17:00:00 |  |  | 1
 |  | Project 3 | 7 | 2011-04-06 17:00:00 | 2011-07-27 17:00:00 |  |  | 1
 |  | Project 4 | 8 | 2011-04-25 17:00:00 | 2011-11-03 17:00:00 | 2012-02-23 17:00:00 |  | 1
 |  | Project 5 | 9 | 2011-04-25 17:00:00 | 2011-12-14 17:00:00 | 2012-03-27 17:00:00 |  | 1
 |  | Project 6 | 10 | 2011-05-02 17:00:00 | 2011-12-21 17:00:00 | 2012-04-03 17:00:00 |  | 1
 |  | Project 7 | 1 | 2011-05-02 17:00:00 | 2011-12-21 17:00:00 | 2012-04-03 17:00:00 |  | 1
 |  | Project 8 | 2 | 2011-05-16 17:00:00 | 2011-12-21 17:00:00 | 2012-04-11 17:00:00 |  | 1
 |  | Project 9 | 3 | 2011-06-13 17:00:00 | 2013-02-01 17:00:00 | 2014-04-01 00:00:00
 |  | Project 10 | 4 | 2011-06-28 17:00:00 | 2012-02-16 17:00:00 | 2012-05-30 17:00:00 |  | 1
 |  | Project 11 | 5 | 2011-06-28 17:00:00 | 2012-02-16 17:00:00 | 2012-05-30 17:00:00 |  | 1
 |  | Project 12 | 6 | 2011-06-28 17:00:00 | 2012-02-16 17:00:00 | 2012-05-30 17:00:00 |  | 1
 |  | Project 13 | 7 | 2011-07-04 17:00:00 | 2012-02-22 17:00:00 | 2013-06-05 17:00:00
 |  | Project 14 | 8 | 2011-07-12 17:00:00 | 2012-03-01 17:00:00 | 2013-06-13 17:00:00
 |  | Project 15 | 11 | 2011-07-12 17:00:00 | 2012-03-01 17:00:00 | 2013-06-13 17:00:00
 |  | Project 16 | 12 | 2011-07-12 17:00:00 | 2012-03-01 17:00:00 | 2013-06-13 17:00:00
 |  | Project 17 | 13 | 2011-08-29 17:00:00 | 2011-12-19 17:00:00
 |  | Project 18 | 14 | 2011-08-29 17:00:00 | 2011-12-19 17:00:00
 |  | Project 19 | 15 | 2011-08-29 17:00:00 | 2012-04-18 17:00:00 | 2013-07-31 17:00:00
 |  | Project 20 | 15 | 2011-09-12 17:00:00 | 2012-05-02 17:00:00 | 2013-08-14 17:00:00
 |  | Q1 2011 | Q2 2011 | Q3 2011 | Q4 2012 |  |  |  | this array formula doesn't work
 |  | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 |  |  |  | it also needs to be date dependent
 |  | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 |  |  |  | i.e. add to the sum if step 3 before 2013
 |  | Q1 2012 | Q2 2012 | Q3 2012 | Q4 2013
 |  | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2012-07-01 00:00:00
 |  | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2012-09-30 00:00:00
Spreadsheet: 687971d1595511816-return-sheet-name-when-value-is-found-on-that-sheet-students-example
Sheet: Koen Van Halewijck

Maand
[NAME]
To Do
 | June
 | [NAME]
 | Augustus
 | September
 | Oktober
 | November
 | December
Spreadsheet: 03dceed2-8642-4202-9a06-dbed75e855c4
Sheet: Sheet1

Table 7--U.S. feed grain imports by selected sources (1,000 metric tons) 1/, 7/13/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Import and country/region |  | ---------- 2009/10 ---------- |  | ---------- 2010/11 ---------- |  | ---------- 2011/12 ----------
 |  | Mkt year | [NAME] | Mkt year | [NAME] | Mkt year | [NAME]
Oats | Canada | 1563.267482 | 1563.267482 | 1393.292808 | 1393.292808 | 1556.499397 | 1556.499397
 | Finland | 47.538488 | 47.538488 | 73.932572 | 73.932572 | 34.84057 | 34.84057
 | Sweden | 23.5782 | 23.5782 |  |  | 29.020381 | 29.020381
 | All other countries | 1.629466 | 1.629466 | 0.423529 | 0.4235289999999999 | 1.067246 | 1.067246
 | Total 2/ | 1636.013636 | 1636.013636 | 1467.648909 | 1467.648909 | 1621.427594 | 1621.427594
Malting barley | Canada | 316.81619 | 316.81619 | 174.724159 | 174.724159 | 263.660306 | 263.660306
 | All other countries | 0.019691 | 0.019691 | 0.006579999999999999 | 0.006579999999999999 | 0.244638 | 0.244638
 | Total 2/ | 316.835881 | 316.835881 | 174.730739 | 174.730739 | 263.904944 | 263.904944
Other barley 3/ | Canada | 30.581621 | 30.581621 | 30.697571 | 30.697571 | 58.26663499999999 | 58.26663499999999
 | All other countries | 13.911215 | 13.911215 | 1.288141 | 1.288141 | 0.4004149999999999 | 0.4004149999999999
 | Total 2/ | 44.492836 | 44.492836 | 31.985712 | 31.985712 | 58.66705 | 58.66705
1/ Grain only. Market year (June-May) and market year to date. 2/ Totals may not add due to rounding.
3/ Grain for purposes other than malting, such as feed and seed use. Source: U.S. Department of Commerce, Bureau of the Census, Foreign Trade Statistics.
Date run: 7/12/2012
Spreadsheet: 755129d1636671575-can-you-use-vlookup-to-return-value-if-conditions-are-met-timeline-2021_test-copy-tms-v2
Sheet: Sample Sheet

 |  |  | 1
COMMUNICATION |  | 1 |  |  | 1
Spreadsheet: 890367d1741789349-spill-error-master-project-list-test
Sheet: Search

 | Search your job name below
Searcy by Job Name: | BIG WATER | Job Number |  | Status
Delete job name above to search for job number instead
Search by Job Number: |  | Job Number |  | Status
Address:
 | 31500 NW 224TH ST.. OKEECHOBEE, FL 34972 - (OKEECHOBEE)
01 - PROJECT EXECUTIVE
02 - SR. PROJECT MANAGER | [NAME] FRANK | [NAME] FRANK
03 - PROJECT MANAGER
04 - ASST. PROJECT MANAGER | [NAME]
05 - MECH SUPERINTENDENT
06 - ELECTRICAL SUPERINTENDENT
07 - SR PROJECT ENGINEER
08 - PROJECT ENGINEER
11 - SR. PROJECT ACCT | FAYE BOGGS | FAYE BOGGS
12 - PROJECT ACCT | RENEE INGRAM | RENEE INGRAM
13 - ASST PROJECT ACCT | JORDAN CONNELL | JORDAN CONNELL
14 - FPA TEAM LEAD
15 - PROJECT ADMIN | ROSSLYNN HOWARD | ROSSLYNN HOWARD
Spreadsheet: 101084d1299246146-excel-2007-excel-2007-if-function-problem-if-function
Sheet: Sheet1

AMOUNT | [NAME] | APRIL | MAY | [NAME] | JULY
800
400
300
1400
1500
PROBLEM:
IF A2+90 IS MORE THAN 1500 THEN B2=1
IF A2+90+90 IS MORE THAN 1500 THEN C2=1 BUT IF B2=1 THEN C2=0
IF A2+90+90+90 IS MORE THAN 1500 THEN D2=1 BUT IF C2=1 THEN D2=0
IF A2+90+90+90+90 IS MORE THAN 1500 THEN E2=1 BUT IF D2=1 THEN E2=0
IN SHORT I NEED ONLY ONE "1" IN A ROW
Spreadsheet: 25630d1217009626-displaying-a-date-associated-with-a-value-in-another-column-finances-mini-template-2008
Sheet: 2008

date | bill | amount | balance | over/under | deposit balance | difference | over/under accrue | revised online | revised difference | balance as of Jan05 | -50.75 | <- minimum future balance
2008-07-15 00:00:00 | opening balance |  | 1000 |  |  |  |  |  |  |  |  | 2008-07-25 00:00:00
2008-07-15 00:00:00 | rent | -850 | 150
2008-07-18 00:00:00 | 1paycheck deposit | 1050 | 1200
2008-07-18 00:00:00 | 2weekly budgeted | -300 | 900 |  |  |  | 0
2008-07-20 00:00:00 | credit card | -150 | 750
2008-07-20 00:00:00 | power | -125 | 625
2008-07-22 00:00:00 | car loan | -250 | 375
2008-07-24 00:00:00 | student loan | -400 | -25
2008-07-24 00:00:00 | 1part-time job deposit | 125 | 100
2008-07-24 00:00:00 | 2weekly cash/checks adjust | -150.75 | -50.75 | -150.75 |  |  | -150.75
2008-07-25 00:00:00 | 1paycheck deposit | 1000 | 949.25 |  | 949.25 | 0
2008-07-25 00:00:00 | 2weekly budgeted | -300 | 649.25
2008-07-30 00:00:00 | credit card | -175 | 474.25
2008-07-31 00:00:00 | water bill | -50 | 424.25
Spreadsheet: 303e384b-a59b-4797-95c8-01a78f931d1c
Sheet: Mod 37 Increases

Part Number/Product Description Change Spreadsheet
Manufacturer’s Part Number
Offeror must ensure the Original Equipment Manufacturer (OEM), Manufacturer Part Number or Wholesaler Number for each product proposed reflects the actual part number assigned.
If the OEM, [NAME], or Wholesaler Part Number is submitted incorrectly or not submitted, the product offering will not be awarded.
NEW Manufacture Price List Reference:
OLD Manufacture Price List Reference:
SIN | OLD GSA ITEM NUMBER | OLD [NAME] |  | [NAME] ITEM NUMBER | NEW ITEM DESCRIPTION | LIST CHANGES | OLD LIST PRICE | NEW LIST PRICE | % change in LIST PRICE | GSA % DISCOUNT | NEW GSA PRICE | NEW GSA PRICE WITH IFF
627-13 | P1234 | 25Hz  Load test [NAME] with case |  | XP1234 | 25Hz  Load test Cable Analyzer | No Case for Transport | 6995 | 6910 |  | 0.45
Spreadsheet: 04ac40d8-7e78-4352-97ce-9873fa4e62e3
Sheet: 4.2(IP) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(IP): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2010-11
 | Major Group | IP - Individualized Program
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2010 (October 15, 2010)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | na | na | na | na
 |  | Part Time | na | na | na | na
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students graduating with degrees who earned a GPA of 3.0 or above, and the number who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured employment after graduation.
 |  |  |  |  | July 1, 2010- June 30, 2011
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
Diploma |  |  | na | na | na | na
Certificate |  |  | na | na | na | na
Associate Degree |  |  | na | na | na | na
 | Assoc. graduates admitted to four-year program |  | na | na | na | na
 | [NAME]. graduated with a GPA of 3.0 or above |  | na | na | na | na
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
 | [NAME]. graduated with a GPA of 3.0 or above |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Employed after graduation |  |  | na | na | na | na
Notes:
Spreadsheet: 879665d1727230371-dept-and-date-to-auto-calculate-based-on-todays-date-example-9
Sheet: Injury Type - Chart

 | INJURY BY BODY PART
Hand | 2
Wrist | 2
Arm | 3
Thigh | 1
Ankle | 1
Shoulder | 1
Lower Back | 8
 | INJURY TYPE
Laceration | 2
Contusion | 1
Sprain/Strain | 15
Spreadsheet: 195679d1353597895-cell-formating-and-sheet-protection-gilwern-invoice-xlv1
Sheet: Sheet1

 |  | Invoice
 |  | Invoice Number
 |  | Date
 |  | Customer
 |  | Ordr Number
 |  | Invoice Address
 |  | Delivery/Site Address
 |  | Fixed Price Job | [NAME] |  |  |  | Quantity | Unit Price | Amount
 |  | Option 1 | As per our quotation reference:
 |  | Option 2 | As per customer order reference:
 |  | Other
 |  | Parts Supplied | Description
 |  | Labour | Rate Detail
 |  | First 1/2 Hour
 |  | Subsequent 1/2 Hours
 |  | Other
 |  | Comments: |  |  |  |  |  | Sub-total
 |  |  |  |  |  |  |  | Carriage
 |  |  |  |  |  |  |  | VAT
 |  |  | Thank you. We appreciate your business. |  |  |  |  | Grand Total
 |  | Deltapoint Services
 |  | VAT Registration: 922 5317 42
 |  | Bank Details: Santander, Sort 09-01-28, Act 36080651 |  |  |  |  |  | Internal Use Only
 |  | 1 Crossroads, Gilwern,[NAME], [NAME], NP7 0DX |  |  |  |  |  | Amount Paid:
 |  | Phone: [PHONE]                  Fax: [PHONE] |  |  |  |  |  | Date:
 |  | www.deltapointservices.net        email: [EMAIL]
Spreadsheet: 735218d1622764717-repeat-for-annually-quarterly-between-2-dates-differing-due-date-frequencies-camp2-2-
Sheet: Sheet1

Start Date |  |  | End Date | 2025-05-01 00:00:00
 |  |  |  |  |  | Show like this:   (its repeating between the Start Date and End Date
Description | Frequency | Days | Due Date |  |  | Description | Frequency | Days | Due Date
Financials Annual | Annually | 90 |  |  |  | Financials Annual | Annually | 90 | 2022-03-31 00:00:00 | First "hit" after the start date
Financials Qtr | Quarterly | 60 |  |  |  | Financials Annual | Annually | 90 | 2023-03-31 00:00:00 | next hit
 |  |  |  |  |  | Financials Annual | Annually | 90 | 2024-04-01 00:00:00 | next hit
 |  |  |  |  |  | Financials Annual | Annually | 90 | 2025-03-31 00:00:00 | End Date
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2021-09-30 00:00:00 | First "hit" after the start date
Note:  my data set is much larger than this.  It’s a simplified example |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2021-12-31 00:00:00 | next hit
Description | Frequency | Days | Due Date |  |  | Financials Qtr | Quarterly | 60 | 2022-03-31 00:00:00 | next hit
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2022-06-30 00:00:00 | next hit
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2022-09-30 00:00:00 | "
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2022-12-31 00:00:00 | "
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2023-03-31 00:00:00 | "
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2023-06-30 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2023-09-30 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2023-12-31 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2024-03-31 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2024-06-30 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2024-09-30 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2024-12-31 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2025-03-31 00:00:00 | End Date
Spreadsheet: 118640d1313819012-cell-compare-between-two-files-sample-new
Sheet: Sheet1

Particulars |  | 2011-09-01 00:00:00
CHANGE OVERS AND ISOLATORS
016A CHANGE OVER
HAVELLS CH/OV OFF/LF/P 0016 A CFFE0016
032A CHANGE OVER
HAVELLS CH/OV OFF/LF/P 0032 A CFFE0032
063A CHANGE OVER
HAVELLS CH/OV OFF/LF/P 0063 A CFFE0063
HAVELLS CH/OV ON/LF/P 040 A CFFE0040
HAVELLS CH/OV ON/LF/P 063 A CFFE0063
KATKO CH/OVER 40A
100-1000 CHANGE OVER
HAVELLS CH/OV OFF/LF/P 0100 A CFFE0100
HAVELLS CH/OV OFF/LF/P 0200 A CFFE0200
HAVELLS CH/OV OFF/LF/P 0400 A CFFE0400
HAVELLS CH/OV OFF/LF/P 0630 A CFFE0630
HAVELLS CH/OV/OFF/LF/P 0800A CFFE0800
HAVELLS CH/OV/OFF/ LF/ P 1000A CFFE 1000
HAVELLS CH/OV ON/LF/P 100 A CFFE0100
HAVELLS CH/OV ON/LF/P 200 A COFO 0200
ISOLATOR
ALTECH ISOLATOR 100DP
ALTECH ISOLATOR 100TP
CRABTREE D/BOARD  TPN ISOLATOR 100A
CRABTREE SWITCH 125A
HAVELLS ISOLATER D/P MCB 063 A MIODPO63
HAVELLS ISOLATER F/P MCB 100 A MIGFP100MIOD
HAVELLS ISOLATER F/P MCB 125 A MIGFP100MI25
HAVELLS ISOLATOR DP MCB 100A
KATKO ISOLATER TPN KATKO 100A
KATKO ISOLATER TPN KATKO 125A
Spreadsheet: 784089d1655421689-excel-elapsed-time-calculation-with-a-result-that-can-be-used-to-calculate-wages-book2
Sheet: Sheet1

[NAME]
2021-2022
Total (AUD) | Total (USD) |  |  |  |  |  |  | Average FX Rate
28.92 | = [NAME]
0.325 | = Nominal Tax Rate
Current Date :
 |  |  |  |  |  |  |  | A$
 |  |  |  |  |  |  |  | Weekly
Date |  | School Code | Distance (Km) | Distance (Miles) | Start Time | Finish Time | Hours | Wages
2021-07-01 00:00:00 |  |  |  |  | 15:00:00 | 17:00:00
Spreadsheet: 118574d1313767432-football-prediction-point-system-football-prediction-1-
Sheet: Sheet1

 |  |  |  |  |  | Points Scored (formula goes here)
 | Predictions
 |  | GOALS |  | GOALS |  |  | Correct pointing | How it works
 | [NAME] | 1 | v | 1 | Wolves |  | -3 | Not precited winner, goal diffirence 1 so I socre -3
 | Fulham | 2 | v | 1 | [NAME] |  | -9 | Not predicted the draw, 3 goals pridicted wrong so I score -9
 | Liverpool | 2 | v | 1 | Sunderland |  | -3 | Not predicted the draw, I put wxtra goal for liverpool so I get -3
 | Man City | 2 | v | 0 | Swansea |  | 14 | I predicted the winner but not spot on so I get 20 points for CLOSE score and I minuse 3 per goal diffirence from the points earnerd. 20-6=14 points
 | Newcastle | 1 | v | 2 | Arsenal |  | -9 | Not predicted the draw, 3 goals pridicted wrong so I score -9
 | QPR | 1 | v | 2 | [NAME] |  | 21 | I predicted the AWAY winner but not spot on so I get 30 points for Away CLOSE score and I minuse 3 per goal diffirence from the points earnerd. Wrong goals for QPR is 1 and for [NAME] so 3 wron goals = -9. Points should be 30-9 =21
 | Stoke | 1 | v | 2 | Chelsea |  | -9 | Not predicted the draw, 3 goals pridicted wrong so I score -9
 | Tottenham | 1 | v | 1 | Everton |  | 50 | Game not played but as if I precicted Spot on draw, it equals 50 points
 | West Brom | 1 | v | 3 | Man Utd |  | 27 | Away winer predicted so 30 pints but I was wrong [NAME]. So 30-3 =27
 | [NAME] | 2 | v | 0 | [NAME] |  | -6 | Not predicted the draw, 2 goals pridicted wrong so I score -6
 |  |  |  |  |  |  |  | HOW PTS ARE SCORED
 | [NAME] |  |  |  |  |  |  | HOME WIN PREDICTED
 |  | GOALS |  | GOALS |  |  |  | SPOT ON = 40 pts
 | [NAME] | 1 | v | 2 | Wolves |  |  | CLOSE = 20 [NAME] (-3 PER GOAL OUT)
 | Fulham | 0 | v | 0 | [NAME] |  |  | WRONG = 0 [NAME] (-3 PER GOAL OUT)
 | Liverpool | 1 | v | 1 | Sunderland
 | Man City | 4 | v | 0 | Swansea |  |  | DRAW PREDICTED
 | Newcastle | 0 | v | 0 | Arsenal |  |  | SPOT ON = 50 pts
 | QPR | 0 | v | 4 | [NAME] |  |  | CLOSE = 30 [NAME] (-3 PER GOAL OUT)
 | Stoke | 0 | v | 0 | Chelsea |  |  | WRONG = 0 [NAME] (-3 PER GOAL OUT)
 | Tottenham | 1 | v | 1 | Everton
 | West Brom | 1 | v | 2 | Man Utd |  |  | AWAY WIN PREDICTED
 | [NAME] | 1 | v | 1 | [NAME] |  |  | SPOT ON = 50 pts
 |  |  |  |  |  |  |  | CLOSE = 30 [NAME] (-3 PER GOAL OUT)
 |  |  |  |  |  |  |  | WRONG = 0 [NAME] (-3 PER GOAL OUT)
 | [NAME] | 1 | v | 2 | Wolves
 | Fulham | 0 | v | 0 | [NAME]
 | Liverpool | 1 | v | 1 | Sunderland
 | Man City | 4 | v | 0 | Swansea
 | Newcastle | 0 | v | 0 | Arsenal
 | QPR | 0 | v | 4 | [NAME]
 | Stoke | 0 | v | 0 | Chelsea
 | Tottenham | 1 | v | 1 | Everton
 | West Brom | 1 | v | 2 | Man Utd
 | [NAME] | 1 | v | 1 | [NAME]
Spreadsheet: 853531d1703378130-excell-cell-data-to-the-column-dtm-croped-johnmal-
Sheet: Φύλλο1

P,X,Y,Z,D
,517488.383597,3932211.205125,106.341313,Q-Point
,517488.762067,3932208.819965,106.519121,Q-Point
,517488.794977,3932208.612560,109.247588,Q-Point
,517488.849828,3932208.266884,109.520146,Q-Point
,517488.915648,3932207.852074,109.195174,Q-Point
,517488.932103,3932207.748372,107.190469,Q-Point
,517489.041805,3932207.057021,106.527425,Q-Point
,517489.348968,3932205.121239,106.709337,Q-Point
,517489.568370,3932203.738538,107.815979,Q-Point
,517489.831653,3932202.079297,108.220262,Q-Point
,517490.177212,3932199.901542,108.206149,Q-Point
,517490.506316,3932197.827490,107.234521,Q-Point
,517490.824449,3932195.822574,107.579055,Q-Point
,517491.219374,3932193.333712,107.053411,Q-Point
,517491.340045,3932192.573226,108.012176,Q-Point
,517491.515567,3932191.467065,108.665748,Q-Point
Spreadsheet: gerald_nemec__11488__Gallup
Sheet: Rate 21

Transwestern Pipeline Company
Gallup Electric Compressor
Coincidental Peak Demand Rebate Calculation
RATE 21 |  |  |  |  | 3rd Quarter |  |  |  |  | 4th Quarter
Service Month |  |  |  |  | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 3rd Quarter |  | 2000-10-01 00:00:00
Calendar Month |  |  |  | Rates | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | Total |  | 2000-12-01 00:00:00
HP
Kw - Generation |  |  |  |  | 4876.8 | 8890 | 8918 |  |  | 6854
Kw - Transmission |  |  |  |  | 7372.8 | 9427.2 | 8621 |  |  | 7574
Demand Charges/10,000 Kw |  |  |  |  | 130721 | 130721 | 130721 |  |  | 130721
per Month
Generation Rate |  |  |  | 8.86
Distribution Rate |  |  |  | 3.35
 | [NAME]
PUC Surcharge |  |  |  | 0.005
 | Subtotal before Gross Receipts Tax
[NAME] |  |  |  | 0.05875
 | Total Demand Charge
Total Rebate
Cumulative Total
Spreadsheet: 696135d1600657194-find-intersection-values-class_pair
Sheet: Sheet1

Input |  |  |  |  | Output
Student | Class_Code |  |  |  |  | C101 | C102 | C103
A | C101 |  |  |  | C101 | 3 | 2 | 1
A | C102 |  |  |  | C102 | 2 | 2 | 0
B | C101 |  |  |  | C103 | 1 | 0 | 1
B | C102
B | C103
C | C101
Spreadsheet: 797105d1663707342-pull-information-via-data-validation-and-return-value-in-a-2nd-column-based-on-adjacency-adjacent-formula-for-invoice-tracking-v2
Sheet: Invoice tracking

Month of event/invoice | date on invoice | vendor name & # | [NAME] | vendor # | amount
 |  |  |  | formula below that pull in corresponding vendor # without having to use formula to CONCATENATE as in F4 pulling from "reminders tab column C
August | 8.31.22 | ACE 22918 | ACE |  | 143.29
August | 8.29.22 | American 18454 | American |  | 370
August | 9.1.22 | ASDER 14400 | ASDER |  | 7100
Sept | 9.7.22 | Adobe 5564 | Adobe |  | 527.5
Sept | 9.6.22 | American 18454 | American |  | 2550
July | 7.12.22 | ASSOCIATES 22888 | ASSOCIATES, INC. |  | 32.1
June | 6.30.22 | Arcon 27759 | Arcon |  | 8.7
June | 8.3.22 | ACE 22918 | ACE |  | 8.7
 |  | DELETE COLUMN C
Spreadsheet: 688190d1595609597-using-index-to-find-matches-across-multiple-worksheets-with-multiple-matches-test1
Sheet: Sheet2

Name | var3 |  |  |  |  |  | Var4
[NAME] | one |  |  |  |  |  | Private
[NAME] | two |  |  |  |  |  | Corporal
[NAME] | three |  |  |  |  |  | Sergeant
[NAME] | four |  |  |  |  |  | Sssergeant
[NAME] | Five |  |  |  |  |  | PLT SGT
[NAME] | six |  |  |  |  |  | MSGT
[NAME] | Seven |  |  |  |  |  | 1SGT
[NAME] | Eight |  |  |  |  |  | SGT MAJ
Spreadsheet: 768697d1645087135-get-a-certain-data-across-a-row-but-within-the-range-of-a-merged-cell-merge-cell-ans
Sheet: Sheet1

Team A | a | 12
 | b | 34
 | c | 67
 | d | 23
 | Total
Team B | a | 12
 | b | 766
 | c | 3
 | d | 90
 | Total
 | Team A