tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0901c355-d156-4006-a7a8-89311497ff88
Sheet: Cleveland Report

 | State Summary Provided by the Cleveland Scholarship Program
 | Ohio Department of Education
 | January 2013
 | Student Enrollment in Cleveland Scholarship and Proficiency on Ohio Achievement and Graduation Tests for Spring 2012 by Student's Resident District
 | Student Enrollment in EdChoice
 | Students participating for one year: |  |  |  |  |  | 835
 | Students participating between one and three years: |  |  |  |  |  | 729
 | Students participating for more than three years: |  |  |  |  |  | 3569
 | Percent of Students Proficient by Tested Grade
 | Tested Grade |  | Percent Proficient or Above in Reading |  | Percent Proficient or Above in Math |  | Percent Proficient or Above in Science
 | 3 |  | 49.3 |  | 32.8 |  | Science test not given
 | 4 |  | 57.4 |  | 27.1 |  | Science test not given
 | 5 |  | 42.8 |  | 17.9 |  | 24.4
 | 6 |  | 70.8 |  | 38.1 |  | Science test not given
 | 7 |  | 69.5 |  | 38.5 |  | Science test not given
 | 8 |  | 74.2 |  | 52.9 |  | 39.6
 | OGT |  | 96 |  | 76.2 |  | 70.6
 | Percent of Students Proficient by Student Gender
 | Gender |  | Percent Proficient or Above in Reading |  | Percent Proficient or Above in Math |  | Percent Proficient or Above in Science
 | Female |  | 66.5 |  | 37 |  | 15
 | Male |  | 58.5 |  | 37 |  | 12.7
 | Percent of Students Proficient by Student Ethnicity
 | Ethnicity |  | Percent Proficient or Above in Reading |  | Percent Proficient or Above in Math |  | Percent Proficient or Above in Science
 | Asian/Pacific Island. |  | 75 |  | 79.5 |  | 22.7
 | Black |  | 55.1 |  | 24.7 |  | 8.5
 | Hispanic |  | 59.2 |  | 34.2 |  | 10.3
 | Multi-racial |  | 65.5 |  | 41.4 |  | 15.5
 | Native American |  | 75 |  | 50 |  | NC
 | White-Non Hispanic |  | 76.3 |  | 55.9 |  | 24.9
 | Other |  | 60 |  | 20 |  | 20
 | Notes
 | (1) All 2012 report card affiliated data is preliminary pending the Auditor of State's investigation.
 | (2) This data may be amended from time to time as students are manually matched to their test and added to the report.
 | (3) Categories with fewer than 10 test takers are reported with 'NC'
 | (4) This data represents unverified assessment data from Spring 2012
 | (5) OGT Stands for Ohio Graduation Test.  This assessment is given starting in the 10th grade.
 | (6) Student enrollment participation includes all students in program
Spreadsheet: benjamin_rogers__1327__site_visit_schedule_112100
Sheet: Brownsville

 | Brownsville Plant Information
 | Contact is:
 | [NAME] Manager  (901) 772-9003 Office,
 | [NAME] Supervisor (901) 772-9003
 | On Call Pagers  (662) 805-7631 and 805-7630
 | Plant Address
 | 948 Beechgrove Rd,  Brownsville, TN. 38012
 | Driving Instructions:
 | 1 | Please fly into Memphis International Airport.  Once you exit the Airport take Airways Blvd. north to I-240 (towards Nashville).  Continue
 |  |  | on the I-240 Loop for approximately 11 miles and go east on I-40 (towards Nashville).  Continue on I-40 for approximately 48 miles and get
 |  |  | off on I-40 exit #60.  Turn right on [NAME] and proceed approximately 0.8 miles and turn right on Beechgrove Road.  Proceed down
 |  |  | Beechgrove Road for approximately 1.1 miles and turn into the Facility's main driveway.  At the gate ring and announce yourself, as the
 |  |  | Control Room Operator will be expecting you.
 |  | 2.  Hotels;  Off I-40 exit #56
 |  |  | [NAME]Holiday Inn Express |  | [PHONE]
 |  |  | [NAME] |  |  | [PHONE]
 |  |  | [NAME] |  |  | [PHONE]
 |  |  | *At the Holiday Inn state your here on Business with ENRON for a Corporate discount.
Spreadsheet: 727953d1618229184-count-the-numbers-and-x-in-all-calums-book2
Sheet: Sheet1

 | ONS_1 | ONS_3P | ONS_5P | ONS_2P | ONS_4 | ONS_6 | ONS_8 | ONS_10 | ONS_7P | ONS_9 | TEES_1P | TEES_3P
 |  |  |  | ONES |  |  | TEENS |  |  | TWENTYS
Spreadsheet: david_delainey__8182__2001PROFORMA
Sheet: Summary

 |  |  | 2001 Pro Forma
 |  |  |  |  |  | 2001 Plan
 |  |  |  |  | Gross Margin | Direct Expenses | Net
 |  |  | East Power
 |  |  | West Power
 |  |  | Natural Gas
 |  |  | Canada
 |  |  | Mexico
 |  |  | Generation Investments
 |  |  | Principal Investing
 |  |  | Energy Capital
 |  |  | Corporate Development
 |  |  | Restructuring
 |  |  | Office of Chairman
 |  |  | Total Commercial Income
 |  |  | Net Drift/Pre-Pay Expenses
 |  |  | ENA Group Expenses
 |  |  | BA&R
 |  |  | Transaction Support
 |  |  | Energy Ops/EOL Trading
 |  |  | Human Resources
 |  |  | Legal
 |  |  | Public Relations
 |  |  | Tax
 |  |  | Research
 |  |  | e-Source & CABC
 |  |  | Technical Services
 |  |  | Treasury
 |  |  | Sub Total
 |  |  | IT Expenses
 |  |  | Application Development
 |  |  | EOL
 |  |  | Infrastructure
 |  |  | Depreciation et al
 |  |  | Total
 |  |  | Corporate Service Billings
 |  |  | * Insurance
 |  |  | * SAP
 |  |  | * Audit Fee
 |  |  | * Clickathome
 |  |  | * Misc
 |  |  | * Legal
 |  |  | * Tax
 |  |  | * Human Resources
 |  |  | * Public Relations
 |  |  | Total Corp Service Billings
 |  |  | Regulatory Affairs
 |  |  | ECM
 |  |  | RAC
 |  |  | Other
 |  |  | Sub Total
 |  |  | Group Compensation
 |  |  | Bonus
 |  |  | AESOP
 |  |  | Stock Options
 |  |  | Phantom Stock
 |  |  | [NAME]
 |  |  | Sub Total
 |  |  | Legacy Costs
 |  |  | Mexico City |  |  |  | 955000
 |  |  | Coyote |  |  |  | 11318000
 |  |  | CES |  |  |  | 1080000
 |  |  | Citrus |  |  |  | 341000
 |  |  | Sub Total
 |  |  | EBIT
Spreadsheet: 758489d1638897109-data-in-h-m-and-s-text-format-how-to-convert-sample-copy
Sheet: Sheet1

Date | Staff 1 | Staff 2 | Staff 3
2021-09-01 00:00:00 | 45m 39s | 20h 18m | 45m 21s
2021-09-02 00:00:00 | 1h 18m | 4m 36s | 42m 59s
2021-09-03 00:00:00 | 39m 53s | 3d | 1h 12m
2021-09-04 00:00:00 | 36m 36s | 1h 13m | 16h 17m
2021-09-05 00:00:00 | 38m 22s | 6h 13m | -
2021-09-06 00:00:00 | 46m 36s | 4d | 6d 12
2021-09-07 00:00:00 | 38m 22s | - | -
2021-09-08 00:00:00 | 20h 8m | 36m [NAME] | 10h 8m
2021-09-09 00:00:00 | 4m 36s | 44m 52s | 44m 2s
2021-09-10 00:00:00 | 44m 4s | - | 26m 26s
2021-09-11 00:00:00 | 1h 12m | - | 59m 16s
Spreadsheet: 463056d1464282369-conditional-formatting-based-on-column-value-then-row-search-but-with-different-value-book1
Sheet: Sheet1

 | Area 1 |  | Area 2 |  | Area 3 |  | Area 4 |  | Area 5 |  | t24 | a
m23 | f | h | i | j | d | k | e | a | g | b |  | b
t24 | k | g | b | i | j | d | f | a | e | h |  | c
w25 | d | k | c | f | g | e | h | a | i | j |  | d
t26 | g | e | f | k | h | i | j | a | d | c |  | e
f27 | e | j | b | d | i | h | g | a | k | f |  | f
 |  |  |  |  |  |  |  |  |  |  |  | g
 |  |  |  |  |  |  |  |  |  |  |  | h
 |  |  |  |  |  |  |  |  |  |  |  | i
 |  |  |  |  |  |  |  |  |  |  |  | j
 |  |  |  |  |  |  |  |  |  |  |  | k
 |  |  |  |  |  |  |  |  |  |  |  | l
 |  |  |  |  |  |  |  |  |  |  |  | m
Spreadsheet: 18cac5fa-3901-407a-adc8-079e7d607e86
Sheet: A MAIL 

[NAME],
En atención a su solicitud, [NAME] cordial me permito remitir en archivo anexo  la evaluación financiera de las propuestas del Proceso Contractual ICFES-CP-006-2013.
Agradezco la atención prestada y quedo atenta a resolver cualquier inquietud sobre el tema.
NOHORA TRIANA ROA
[NAME] y Contable
[NAME] para la Evaluación de la  Educación -ICFES
De: [NAME]
[NAME] martes, 14 de mayo de 2013 02:20 p.m.
Para: [NAME] triana Roa
Asunto: RV:
Importancia: Alta
Dra. [NAME] buenas tardes:
Favor apoyarnos con la verificación y elaboración del informe de evaluación financiera del proceso ICFES CP 006 de 2013.
Gracias.
[NAME]
De: [NAME]
[NAME] martes, 14 de mayo de 2013 11:21 a.m.
Para: [NAME]
Asunto:
Importancia: Alta
Apreciados [NAME]:
De manera atenta les informo que mediante comunicación [NAME] Dirección General, han sido designados como integrantes del Comité Evaluador para acompañar las diferentes etapas del Proceso contractual ICFES-CP-006-2013.
[NAME] adjunto [NAME] desarrollo del mencionado proceso.
Quedo atento a sus comentarios.
[NAME]
Subdirección de Abastecimiento y Servicios Generales
[NAME] para la Evaluación de la Educación-ICFES
[NAME]: (571)3387338-Ext 1078
Celular:  [PHONE]
Calle 17 No. 3-40 Bogotá D.C. Colombia
www.icfes.gov.co
Spreadsheet: 164100d1340649932-help-combine-if-and-vlookup-forumlas-or-another-way-of-getting-the-solution-test-formulas
Sheet: WKSHT#1

 |  |  |  | Exhibit B
 |  |  |  | worksheet #1
 | Merchant Name:
 | NAICS Code: |  |  |  |  |  | 444210 |  |  | #N/A
 | NAICS Description: |  | Outdoor Power Equipment Stores
 | Annual Bankcard Sales: |  |  |  |  |  | 0 |  |  | #N/A
 | Minimum annual growth (10% or higher per HUB's projections) |  |  |  |  |  | 0.1 |  |  | #N/A
 | Total Projected sales |  |  |  |  |  | 0
 | % of deferred delivery sales |  |  |  |  |  | 0
 | Average number of days of non-delivery risk: |  |  |  |  |  | 0
 | [NAME]. Non-Delivery Risk if merchant goes out-of-business: |  |  |  |  |  | 0
 | Normal chargeback and credit return annual risk per NAICS: |  |  |  |  |  | 0 |  |  | 0
 | Discount risk based on an average discount of 2.0%: |  |  |  |  |  | 0
 | Gross Merchant Risk |  |  |  |  |  | 0
 | less Reserve Amount
 | less Collateral Amount
 | Net Merchant Risk |  |  |  |  |  | 0
 | Guaranty (s) required: Yes/No |  |  |  | Conforming Business: Yes/No
 |  |  |  |  | Conforming sales method: Yes/No
 | Collateral required: Yes/No
 | Reserve required: Yes/No
 | ACH Settlement delay:
 | Additional Conditions:
Spreadsheet: 871624d1718047747-how-to-copy-paste-all-rows-and-columns-of-data-from-one-sheet-to-another-sheet-2024_commissions_dale-inc-commission-report
Sheet: Artisan

ARTISAN
# | CHECK # | CHECK AMOUNT INCLUDING TAX | % PAID BY CUSTOMER | CUSTOMER | JOB NAME | PRODUCT SOLD | INVOICE / SALES ORDER / ESTIMATE # | SUB-TOTAL | COST | GROSS PROFIT $$$ | GROSS PROFIT % | COMMISION RATE | COMMISSION AMOUNT | ORDERED | RECEIVED
1 | ???? | 211019.63 | 1 | ARTISAN | GILLESPY | WINDOWS & DOORS | EST #99448 | 211019.63 | 137162.76 |  |  | 0.3
 |  |  |  | 01/24/24 - P2 said owner waiting on interest rates to go down...     11/17/23 - P2 said owner was still trying to obtain financing...     09/20/23 - P2 emailed saying ready for up to date bid...     07/11/23 - texted P2 & he said owner getting his money together…     05/18/23 - P2 said job is nearing permitting and needs revising…     05/18/23 - emailed [NAME] for update…     11/13/22 - emailed ballpark budget to [NAME]…
2 | ???? | 0 | 1 | ARTISAN | SEXTON | WINDOWS & DOORS | QQ | 172558.23 | 136321 |  |  | 0.2
 |  |  |  | 02/16/24 - emailed quote to [NAME]…     01/24/24 - P2 to send me the plans soon…
3 | ???? | 142144.62 | 1 | ARTISAN | STANTON | WINDOWS & DOORS | QQ | 142144.62 | 107319.19 |  |  | 0.25
 |  |  |  | 01/24/24 - P2 said this one coming soon…      11/14/2023 - emailed revised estimate…     11/11/2023 - emailed estimate…
4 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.25
5 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
6 | ???? | 0 | 1 | DEMAN | MORGAN | WINDOWS & DOORS | QQ #11094 | 0 | 0 |  |  | 0.3
 |  |  |  | 03/20/24 - Lou to email plans…
7 | ???? | 125965.68 | 1 | DEMAN | SHEA (ADDITION) | WINDOWS & DOORS | QQ #11094 | 125965.68 | 95419 |  |  | 0.25
 |  |  |  | 04/03/24 - emailed estimate…     03/20/24 - Lou to email plans…
8 | ???? | 0 | 1 | DEMAN | SHEA (RENO) | WINDOWS & DOORS | QQ #11094 | 0 | 0 |  |  | 0.3
 |  |  |  | 04/03/24 - emailed estimate…     03/20/24 - Lou to email plans…
9 | ???? | 107114.49 | 1 | DEMAN | TWEEDY | WINDOWS & DOORS | QQ #11094 | 107114.49 | 73909 |  |  | 0.3
 |  |  |  | 02/05/24 - VE meeting with [NAME]…     01/16/24 - emailed quote to [NAME]…
10 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
11 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
12 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
13 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
14 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
# | CHECK # | CHECK AMOUNT INCLUDING TAX | % PAID BY CUSTOMER | CUSTOMER | JOB NAME | PRODUCT SOLD | INVOICE / SALES ORDER / ESTIMATE # | SUB-TOTAL | COST | GROSS PROFIT $$$ | GROSS PROFIT % | COMMISION RATE | COMMISSION AMOUNT | ORDERED | RECEIVED
Spreadsheet: 212646d1360181791-excel-help-excel_question
Sheet: Reference

Products | Platform | Servers
ABC | [NAME] | Server1
ABC | [NAME] | Server2 |  | Click on a single cell, e.g. B3
ABC | [NAME] | Server3 |  | Go to the [NAME] tab on the ribbon above and click on Table
ABC | .NET | Server1 |  | Excel will ask you about your range -- in this case it will select your whole reference table (A1:[NAME]); [NAME]
ABC | .NET | Server2 |  | Your table will change color and will also have filters on your headings
DEF | [NAME] | Server1 |  | With these filters you can sort according to the data you require
DEF | [NAME] | Server2 |  | Hope it helps
DEF | [NAME] | Server3
DEF | .NET | Server1
DEF | .NET | Server2
JKL | [NAME] | Server1
JKL | [NAME] | Server2
JKL | [NAME] | Server3
JKL | .NET | Server1
JKL | .NET | Server2
Spreadsheet: 60787d1261371783-adding-todays-date-to-template-automatically-djl
Sheet: Feedstation

DAILY FEEDSTATION REPORT
Date: | 2009-12-14 00:00:00
Operator AM:
Operator PM:
FEED NAME | STARTED / STOPPED OK | VIDEO QUALITY | AUDIO QUALITY | PROBEL WORKING | NOTES
ap00301221 | Correct Duration | Good | Good | Yes - 1
ap01301221 | Correct Duration | Good | Good | Yes - 2
sn01001221 | Correct Duration | Good | Good | Yes - 3
ap02301221 | Correct Duration | Good | Good | Yes - 4
ap03301221 | Correct Duration | Good | Good | Yes - 1
ap04301221 | Correct Duration | Good | Good | Yes - 2
sn05001221 | Correct Duration | Good | Good | Yes - 3
ap05301221 |  |  |  | Yes - 4
ap06001221 |  |  |  | Yes - 1
bc06201221 | [NAME] | Good | Good | Yes - 6
ap063012 |  |  |  | Yes - 2
ap073012
sn080012
[NAME]
ap093012
ap113012
lx113012
sn120012
ap133012
op142512
ap143012
ap153012
ap163012
[NAME]
ap183012
ap193012
sn200012
ap203012
ap213012
sn220012
[NAME]
Correct Duration
[NAME]
Incorrect Duration
Good
OK
Bad
Web
Yes - 1
Yes - 2
Yes - 3
Yes - 4
Yes - 5
Yes - 6
Yes - 7
Yes - 8
Yes - 9
Yes - 10
Yes - 11
Yes - 12
N/A
Yes
No
N / A
Passed
Not Done
Failed
K Evans
M Thompson
P Duhig
D Livett
Spreadsheet: 44905d1243628320-breaking-a-tie-sampletiebreak
Sheet: Sheet1

Rank | School | Score | 5th | 6th | Ties | Tie Rank
3 | Brooksville | 312 | 79 | 83 | 312.7983 | 309.7881
6 | [NAME] | 319 | 81 | 87 | 319.8187 | 309.7983
2 | Groman | 309 | 79 | 83 | 309.7983 | 312.7983
5 | Fisher | 317 | 77 | 88 | 317.7788 | 312.8184
7 | Crossville | 325 | 81 | 85 | 325.8185 | 317.7788
1 | Dorland | 309 | 78 | 81 | 309.7881 | 319.8187
4 | [NAME] | 312 | 81 | 84 | 312.8184 | 325.8185
Spreadsheet: 761509d1640965885-convert-greek-text-to-latin-old-excel-2002-greek2latin
Sheet: Codes

Α | 913 | A |  |  |  |  |  | 913 | Α
Β | 914 | V |  |  |  |  |  | 914 | Β
Γ | 915 | G |  |  |  |  |  | 915 | Γ
Δ | 916 | D |  |  |  |  |  | 916 | Δ
Ε | 917 | E |  |  |  |  |  | 917 | Ε
Ζ | 918 | Z |  |  |  |  |  | 918 | Ζ
Η | 919 | H |  |  |  |  |  | 919 | Η
Θ | 920 | TH |  |  |  |  |  | 920 | Θ
Ι | 921 | I |  |  |  |  |  | 921 | Ι
Κ | 922 | K |  |  |  |  |  | 922 | Κ
Λ | 923 | L |  |  |  |  |  | 923 | Λ
Μ | 924 | M |  |  |  |  |  | 924 | Μ
Ν | 925 | N |  |  |  |  |  | 925 | Ν
Ξ | 926 | X |  |  |  |  |  | 926 | Ξ
Ο | 927 | O |  |  |  |  |  | 927 | Ο
Π | 928 | P |  |  |  |  |  | 928 | Π
Ρ | 929 | R |  |  |  |  |  | 929 | Ρ
΢ | 930 | # |  |  |  |  |  | 930 | ΢
Σ | 931 | S |  |  |  |  |  | 931 | Σ
Τ | 932 | T |  |  |  |  |  | 932 | Τ
Υ | 933 | Y |  |  |  |  |  | 933 | Υ
Φ | 934 | F |  |  |  |  |  | 934 | Φ
Χ | 935 | H |  |  |  |  |  | 935 | Χ
Ψ | 936 | PS |  |  |  |  |  | 936 | Ψ
Ω | 937 | O |  |  |  |  |  | 937 | Ω
Ϊ | 938 | I |  |  |  |  |  | 938 | Ϊ
Ϋ | 939 | # |  |  |  |  |  | 939 | Ϋ
ά | 940 | D |  |  |  |  |  | 940 | ά
έ | 941 | E |  |  |  |  |  | 941 | έ
ή | 942 | H |  |  |  |  |  | 942 | ή
ί | 943 | I |  |  |  |  |  | 943 | ί
ΰ | 944 | # |  |  |  |  |  | 944 | ΰ
α | 945 | A |  |  |  |  |  | 945 | α
β | 946 | V |  |  |  |  |  | 946 | β
γ | 947 | G |  |  |  |  |  | 947 | γ
δ | 948 | D |  |  |  |  |  | 948 | δ
ε | 949 | E |  |  |  |  |  | 949 | ε
ζ | 950 | S |  |  |  |  |  | 950 | ζ
η | 951 | H |  |  |  |  |  | 951 | η
θ | 952 | ? |  |  |  |  |  | 952 | θ
ι | 953 | I |  |  |  |  |  | 953 | ι
κ | 954 | K |  |  |  |  |  | 954 | κ
λ | 955 | L |  |  |  |  |  | 955 | λ
μ | 956 | M |  |  |  |  |  | 956 | μ
ν | 957 | N |  |  |  |  |  | 957 | ν
ξ | 958 | X |  |  |  |  |  | 958 | ξ
ο | 959 | O |  |  |  |  |  | 959 | ο
π | 960 | # |  |  |  |  |  | 960 | π
ρ | 961 | R |  |  |  |  |  | 961 | ρ
ς | 962 | S |  |  |  |  |  | 962 | ς
σ | 963 | S |  |  |  |  |  | 963 | σ
τ | 964 | T |  |  |  |  |  | 964 | τ
υ | 965 | Y |  |  |  |  |  | 965 | υ
φ | 966 | F |  |  |  |  |  | 966 | φ
χ | 967 | H |  |  |  |  |  | 967 | χ
ψ | 968 | PS |  |  |  |  |  | 968 | ψ
ό | 972 | O |  |  |  |  |  | 969 | ω
Spreadsheet: 85372d1285398447-eliminate-small-array-2-if-it-is-the-same-with-small-array-1-autofill
Sheet: Sheet1

NAME |  |  |  |  | ID Number :
 |  |  |  |  | 1111
PROGRAM |  |  |  | LEVEL :
MONTH | COURSE (Rp) | COMP    (Rp) | BOOKS (Rp) | TOTAL   (Rp) | INVOICE | SIGNATURE
JUN |  |  |  |  |  |  |  | I have worked out this formula to work perfectly to show fees based on program
JUL |  |  |  |  |  |  |  | Problem is I need to show 2 invoice if there are 2 invoice in single program (there will be no more than 2 invoice number in single program)
AUG
SEP
 |  |  |  |  |  |  |  | Currently the formula to show invoice is correct
 |  |  |  |  |  |  |  | BUT, the INDEX for SMALL(array,2) still shown so the result is repeated
PROGRAM |  |  |  | LEVEL :
MONTH | COURSE (Rp) | COMP (Rp) | BOOKS (Rp) | TOTAL (Rp) | INVOICE | SIGNATURE
 |  |  |  |  |  |  |  | Question is how to eliminate [NAME]) to jump to SMALL(array,3) IF the SMALL(array,2) is also the same with SMALL(array,1)
OCT
NOV
DEC
JAN
PROGRAM |  |  |  | LEVEL :
MONTH | COURSE (Rp) | COMP (Rp) | BOOKS (Rp) | TOTAL (Rp) | INVOICE | SIGNATURE
FEB
MAR
APR |  |  |  |  |  |  |  |  | This table should be in second table, because first and second table is the same
MAY
Spreadsheet: 526000d1499075866-copy-paste-diagonal-to-row-in-excel-excel
Sheet: Sheet2

Diff Level | (2) | (3) | (4) | (5) | (6) | (7) | (8)
VARIABLES | [NAME] | acc | aeavol | age | agr | baspread | beta
[NAME]
[NAME]
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -149502 | -150326
2 | -186416 | -184781
3 | -210011 | -208808
4 | -245094 | -241726
5 | -231789 | -235157
6 | -172231 | -181280
7 | -117605 | -116400
8 | -109940 | -109486
9 | -138076 | -137436
10 | -158047 | -156889
11 | -221811 | -219321
12 | -161285 | -160322
13 | -180446 | -185322
14 | -179929 | -178986
15 | -198888 | -198260
16 | -201390 | -202819
17 | -221368 | -219862
18 | -246242 | -245186
19 | -212136 | -211394
20 | -189598 | -188009
21 | -122945 | -120841
22 | -180542 | -179917
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 24900
2001-08-22 00:00:00
CBS Dollars
 |  |  | -156083.38
Spreadsheet: 22327d1211022636-drawing-grid-624391
Sheet: Sheet1

 |  | Outside | Inside
 | Height | 31 | 10
 | [NAME] | 43 | 14
24.5x17.75 |  | 25 | 24.5
 |  | 35.5 | 17.75
10X14 |  | 31 | 10
 |  | 43 | 14
15.5 x 21.5 |  | 31 | 15.5
 |  | 43 | 21.5
Spreadsheet: 743997d1628862379-double-match-and-total-sample-56-ans
Sheet: Sheet1

Company | Product | Domain | QTY |  | Verify
Company X | Product D | ABC.COM | 1 |  |  |  |  |  | Company | Products | FORMULA
Company Y | Product B | DEF.COM | 2 |  | 2 |  |  |  | Company Z | Product A
Company Z | Product A | GHI.COM | 3 |  | 3 |  |  |  | Company Y | Product B
Company X | Product B | ABC.COM | 4 |  |  |  |  |  |  | Product D
Company Y | Product A | DEF.COM | 5 |  | 5
Company Z | Product D | GHI.COM | 6 |  | 6
Company Y | Product C | ABC.COM | 7
Company Y | Product B | DEF.COM | 8 |  | 8
Company Z | Product A | GHI.COM | 9 |  | 9
Spreadsheet: 329563d1404336627-complex-look-up-and-sum-example-data
Sheet: Sheet4

Results Page
 | Date
Unique Reference | 2014-01-01 00:00:00 | 2014-01-02 00:00:00 | 2014-01-03 00:00:00 | 2014-01-04 00:00:00 | 2014-01-05 00:00:00 | 2014-01-06 00:00:00 | 2014-01-07 00:00:00 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00 |  |  | 2014-01-01 00:00:00 | 2014-01-02 00:00:00 | 2014-01-03 00:00:00 | 2014-01-04 00:00:00 | 2014-01-05 00:00:00 | 2014-01-06 00:00:00 | 2014-01-07 00:00:00 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00
12345
98821
12134
11445
1244B
1242T
Example: | Sum values in Quantity Columns in "Data Page" if Unique Reference and Date matches those of B3 and A4
Data Page (separate sheet)
Date | [NAME] Number | [NAME] (1) | Quantity | [NAME] (2) | Quantity | [NAME] (3) | Quantity | [NAME] (4) | Quantity | [NAME] (5) | Quantity
2014-01-01 00:00:00 | 1 | 12345 | 25 | 12134 | 12 | 1242T | 10 | 1242T | 8 | 98821 | 450
2014-01-01 00:00:00 | 2 | 11445 | 700 | 11445 | 20
2014-01-01 00:00:00 | 3 | 1242T | 589 | 1242T | 124 | 98821 | 7000 | 11445 | 89 | 11445 | 123
2014-01-02 00:00:00 | 4 | 12345 | 50 | 11445 | 100 | 11445 | 100
2014-01-03 00:00:00 | 5 | 1244B | 50 | 12345 | 1000 | 1244B | 100 |  |  | 12134 | 2000
2014-01-03 00:00:00 | 6 | 11445 |  | 11445 |  |  |  | 12345 | 10000
2014-01-07 00:00:00 | 7 | 12345 | 3000 | 11445 | 10000 | 98821 | 3000 |  |  | 12134 | 5000
2014-01-08 00:00:00 | 8 | 11445 | 1000 | 1244B | 1000
2014-01-07 00:00:00 | 9 | 98821 | 1000 | 11445 | 10000 | 98821 | 2000 |  |  | 12345 | 20000
Spreadsheet: 791408d1660324581-formula-not-pulling-through-data-for-text-with-a-space-eh-template-1-
Sheet: 2nd. round OLD

⚽Updated scores⚽ |  |  | ⚽Updated scores⚽
[NAME] |  |  | England 🏴󠁧󠁢󠁥󠁮󠁧󠁿 🆚  Croatia 🇭🇷
⚽8pm kick-off⚽ |  |  | ⚽8pm kick-off⚽
〰〰〰〰〰〰〰〰〰 |  |  | 〰〰〰〰〰〰〰〰〰
⚽ Amin A: |  |  | ⚽ Amin A:
[NAME] J: |  |  | [NAME] J:
👺 Din: |  |  | 👺 Din:
⚽ Hanif E: |  |  | ⚽ Hanif E:
[NAME]: |  |  | [NAME]:
👺 Mehboob: |  |  | 👺 Mehboob:
👺 [NAME]: |  |  | 👺 [NAME]:
[NAME]: |  |  | [NAME]:
⚽ [NAME]: |  |  | ⚽ [NAME]:
⚽ Rahim V: |  |  | ⚽ Rahim V:
⚽ Rayyan: |  |  | ⚽ Rayyan:
[NAME]: |  |  | [NAME]:
👺 [NAME]: |  |  | 👺 [NAME]:
[NAME]: |  |  | [NAME]:
[NAME]: |  |  | [NAME]:
[NAME]: |  |  | [NAME]:
[NAME]: |  |  | [NAME]:
Spreadsheet: 212186d1360063443-splitting-known-range-based-on-cell-values-rangesplit_01
Sheet: Sheet1

 |  |  |  |  | Green | Blue
 | B | C | D
 | 1 | OUT
 | 33 | A
 | 12 | D
 | 7 | C |  |  | Automatically split into this:
 | 24 | B |  |  |  |  |  | Each range is delimited by the "OUT" & "IN" values
 | 22 | E
 | 13 | IN
 | 44 | OUT
 | 15 | B
 | 19 | A |  |  | Both green and blue ranges could be of any size but each will have an "OUT" & "IN" at the start and end.
 | 6 | E
 | 64 | C |  |  | So rather than have the whole data range displayed in full as "F3" I want to split into two displayed ranges as "F7" & "G7" and also output the minimum value for each range separately.
 | 37 | D
 | 72 | IN
Spreadsheet: 816662d1675768872-cut-pattern-formula-from-calculated-matrix-data-cut-pattern
Sheet: List1

 |  | query
 |  | bar length | 12 |  | PCS and rest
 |  | Position | length | KOM | 0.09999999999999964 | 0.1 | 0 | 1.4 | 8.9
 |  | 3 | 5.8 | 4 | 2 | 2 | 0 | 0 | 0
 |  | 2 | 4.5 | 3 | 0 | 0 | 2 | 1 | 0
 |  | 4 | 3 | 2 | 0 | 0 | 1 | 1 | 0
 |  | 5 | 3.1 | 2 | 0 | 0 | 0 | 1 | 1
 |  | 1 | 0.3 | 1 | 1 | 1 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  | Desired Result
 |  | No. | CUT PATTERN POSITIONS
 |  | Cut pattern 1 | Pos 3 | Pos 1
 |  | Cut pattern 2 | Pos 2 | Pos 4
 |  | Cut pattern 3 | Pos 2 | Pos 4 | Pos 5
Spreadsheet: 794951d1662431155-find-a-date-using-a-formula-find-a-date-using-formula-number-bigger-than-0-
Sheet: Sheet1

 |  | NO | DATE | Feed |  |  |  |  |  |  | RESULT
 |  |  |  | Morning | Night | TOTAL
 |  | 1 | 2022-09-01 00:00:00 | 0 | 0 |  |  |  |  |  |  |  | THIS IS THE RESULT THAT I WANT
 |  | 2 | 2022-09-02 00:00:00 | 30 | 0
 |  | 3 | 2022-09-03 00:00:00 | 30 | 30 |  |  |  |  |  |  |  | I USE THIS FORMULA; BUT IT SHOWS ERROR
 |  | 4 | 2022-09-04 00:00:00 | 150 | 120
 |  | 5 | 2022-09-05 00:00:00 | 90 | 70 |  |  |  |  |  |  |  | IT ALSO ERROR
 |  | 6 | 2022-09-06 00:00:00 | 120 | 100
 |  | 7 | 2022-09-07 00:00:00 | 120 | 120
 |  | 8 | 2022-09-08 00:00:00 | 150 | 30
 |  | 9 | 2022-09-09 00:00:00 | 0 | 0
 |  | 10 | 2022-09-10 00:00:00 | 0 | 0
 |  | 11 | 2022-09-11 00:00:00 | 0 | 0