tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: cara_semperger__1448__ENA_PGE_DEC05_2001
Sheet: JD-MAL TRANS

From: | EPMI
To: | PGE System Transactions
Date:
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  | Total In To PGE Trans
0100
0200
0300
0400
0500
0600
0700 | 25 | 25
0800 | 25 | 25
0900 | 25 | 25
1000 | 25 | 25
1100 | 25 | 25
1200 | 25 | 25
1300 | 25 | 25
1400 | 25 | 25
1500 | 25 | 25
1600 | 25 | 25
1700 | 25 | 25
1800 | 25 | 25
1900 | 25 | 25
2000 | 25 | 25
2100 | 25 | 25
2200 | 25 | 25
2300
2400
 | BCH(G, CA, FS) | PPLM(G) COLSTRIP (MPCO CA)
 | BCH(T) BCH/BCUS | PPLM(PSE)
 | PWX(PSE) | PWX(PSE)
 | ENGAGE(T PSE) | MPC(T)COLS/BURKE
 | BPA(T)BCUS/[NAME] | WAPA(T)BURKE/BPA.AVA INT
 | PWX(PSE) | PWX(PSE)
 | TEMU(PSE) | MIRANT(PSE)
 | EPME(PSE) | CRC(PSE)
 | EDISON(PSE) | EPMI(PSE)
 | DYNEGY (PSE) | SNPD(T)BPA(T) BPA.AVA INTC/JD
 | EPMI(PSE) | PGE(T)JD/MAL5
 | PGE(T)JD/MAL5 | EPMI(PSE)
 | EPMI(PSE) | CISO(T)MAL5/NP15
 | CISO(T)MAL5/NP15 | EPMI(PSE)
 | EPMI(PSE) | EPMI (L, FS) CISO(CA)
 | EPMI (L, FS) CISO(CA)
Spreadsheet: 1a298b0d-bb0d-44b4-9ae6-2a1a3aa4d4ee
Sheet: Requirements

B.S. Electrical Engineering - Yearly Curriculum Requirements
Curriculum | Credits | Curriculum | Credits
1st Year 1st Semester |  | 1st Year 2nd Semester
EG 10111 Intro. Engr. Systems I | 3 | EG 10112  Intro. Engr. Systems II | 3
MATH 10550 Calculus I | 4 | MATH 10560 Calculus II | 4
Composition or University Seminar | 3 | University Seminar or Composition | 3
CHEM 10171 Gen Chem- Fund. Princ. | 4 | CHEM 10122 Gen Chem- Bio. Proc. | 3
Arts and Letters | 3 | PHYS 10310 General Physics | 4
Physical Education | 0 | Physical Education | 0
Total |  | Total
2nd Year 1st Semester |  | 2nd Year 2nd Semester
MATH 20550 Calculus III | 3.5 | MATH 20580 [NAME]. Alg. & Diff. Eq. | 3.5
PHYS 10320 General Physics II | 4 | PHYS 20330 General Physics III | 3.5
CSE 20232 C/C++ Programming | 3 | EE 20242 Electronics | 4
EE 20224 Intro.  Electrical Engineering | 4 | EE 20234 Electric Circuits | 3
Arts and Letters Course | 3 | CSE 20221 Logic Design | 4
Total |  | Total
3rd Year 1st Semester |  | 3rd Year 2nd Semester
MATH 30650 Differential Equations | 3 | EE 30363 Random Phenomena in EE | 3
EE 30344 Signals and Systems | 3 | EE Elective | 3
EE 30347 Fund of Semiconductors | 3 | EE Elective | 3
EE 30348 Electromagnetic Fields | 3 | Technical Elective | 3
Arts and Letters Course | 3 | Arts and Letters Course | 3
Total |  | Total
4th Year 2nd Semester |  | 4th Year 2nd Semester
EE 41430 Senior Design I | 3 | EE 41440 Senior Design II | 3
EE Elective | 3 | EE Elective | 3
EE Elective | 3 | EE Elective | 3
Engineering Science Elective | 3 | Technical Elective | 3
Arts and Letters Course | 3 | Arts and Letters Course | 3
Total |  | Total
Spreadsheet: 167218d1341929718-excel-2007-counting-multiple-periods-presenting-results-at-the-end-of-each-one-sample-count
Sheet: SAMPLE

 |  |  |  |  |  | Expected Results
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1 |  | 12
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2 |  | 22
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3 |  | 11
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4 |  | 21
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5 |  | 6
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6 |  | 11
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 7
 |  |  |  | 7
 |  |  |  | 7
 |  |  |  | 7
 |  |  |  | 7 |  | 7
 |  |  |  |  |  | 0
Spreadsheet: 771856d1646881350-how-to-use-equation-from-chart-as-a-formula-to-return-a-value-broken_formula_from_chart
Sheet: Sheet1

 |  |  |  | AHD | Outflow
 |  |  |  | 154.81 | 0
 |  |  |  | 157.47 | 210
 |  |  |  | 157.82 | 260
 |  |  |  | 158.65 | 380
 |  |  |  | 159.07 | 440
 |  |  |  | 160.11 | 610
 |  |  |  | 160.62 | 710
 |  |  |  | 161.64 | 1260
 |  |  |  | 161.99 | 1540
 |  |  |  | 162.79 | 2310
 |  |  |  | 163.12 | 2670
 |  |  |  | 163.88 | 3590
 |  |  |  | AHD | Outflow
 |  | What's the value? |  | 155
 |  | F17 is broken |  | 160
 |  | Modify E17 to see |  | 164
 |  |  |  | -5226.896939934355 | 822304.991069327 | -43123770.25264198
Spreadsheet: 159206d1338551030-removing-duplicates-koochandkai_remove_dupe_min_time_01jun12_01
Sheet: Sheet1

name | time |  |  |  |  | name | time
[NAME] | 10:00:00
[NAME] | 11:00:00
[NAME] | 09:00:00
[NAME] | 04:00:00
[NAME] | 03:00:00
Spreadsheet: 731295d1620282571-need-help-formula-calculating-values-depending-on-value-in-drop-down-list-tytilanne
Sheet: Työtilanne

2021 |  |  |  |  |  | TYÖMAAT JA VUOSIKORJAUSTYÖMAAT PKS
Viikko | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Töissä Yht:
UUSIMAA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lisätarve tulev. |  |  |  |  |  | Penkillä: | Huom
Objects | [NAME] |  |  |  |  |  | [NAME] |  |  | Kaarelan Helmi |  |  | Flöitti |  |  | Tankovainion Solina |  |  | Kuusamantie |  |  |  |  | Penkillä Yht:
 | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ:
Workers | a
 | b
 | c
 | d
Duration | 4
[NAME]
UUSIMAA
Objects | Tuusulan Päävartio |  |  | Uudensillantie |  |  | [NAME] 8 |  |  | [NAME] |  |  | Espoon Tiilimäki |  |  | Ylismäentie 12
 | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  | 0 | TJ:
Workers
[NAME]
[NAME]
UUSIMAA
Objects |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ:
Workers
[NAME]
[NAME]
UUSIMAA
Objects | Majakka |  |  | Ylermitie 3 |  |  | Hyppyhommat- Novart |  |  | Niittaaja |  |  | Kiiskitie 1 |  |  | Tempera/Rotunda |  |  | Sompasaarenlaituri
 | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ:
Workers
[NAME]
[NAME]
UUSIMAA
Objects
 | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ: |  |  | TJ:
Workrs
[NAME]
[NAME]
Spreadsheet: 74853d1275404899-how-to-do-sumif-over-multiple-sheets-blank-sheet-for-june
Sheet: 2 June

Account | Amount | Work done on account | Saved | Charge off
5039469311967609 | 10917.07 | no payment |  | 10917.07
5039469327864808 | 10438.97 | NN |  | 10438.97
5039469011374007 | 9954.81 | no payment |  | 9954.81
5039469313601602 | 9724.39 | NN |  | 9724.39
5039469326587509 | 6995.65 | NN |  | 6995.65
5039469011275105 | 6899.94 | no payment |  | 6899.94
5039469016428303 | 6785.75 | overseas |  | 6785.75
5039469002993005 | 5626.42 | cant pay |  | 5626.42
5039469331722307 | 5504.39 | will pay
5039469302909503 | 5067.99 | cant pay |  | 5067.99
5039469322461006 | 3800.96 | overseas |  | 3800.96
5039469313154701 | 3083.52 | cant pay |  | 3083.52
5039469022912100 | 3031.08 | NN |  | 3031.08
5039469333011105 | 2819.82 | will pay
5039469000566407 | 2782.08 | cant pay
5039469333645902 | 2501.66 | NN |  | 2501.66
5039469334346500 | 1526.67 | NN |  | 1526.67
5039469309282409 | 1008.14 | NN |  | 1008.14
5039469307218900 | 14.92 | NN |  | 14.92
 | 98484.23000000003
 |  |  | Actual | 87377.94000000002
 |  |  | Ce % | 0.1127722682098444
Spreadsheet: 803773d1667674813-conditional-formulae-and-percentages-classeur1
Sheet: OVERVIEW

 |  | Assay | Management | Analyst
 |  | Total Insulin Assay | 1 | 0.4166
 |  | Lactase Assay | 0.5 | 0.25
 |  | Chromagranin Assay | 0.5 | 1
 |  | Blood Sugar Assay | 0.3333 | 0.6666
 |  | Total Cells Assay | 0.1666 | 0.6666
 |  |  | This will update (pull from the Feuil1 tab) according to the value of the combined people of a specific position per assay. For example, Though one analyst is fully trained on the blood sugar aassay, the other analyst is only a third complete. This means that the analysts are 66.66% fully qualified.
 |  |  | Is this possible?
Spreadsheet: tracy_geaccone__40529__ETS - NPNG IC 10-19
Sheet: Enterprise Portal Solutions

E N R O N   N et Works
2 0 0 2   P L A N |  |  |  |  |  |  |  |  |  |  |  |  | Enterprise Portal Solutions
 | SAP PROFIT CENTER: |  | 10737
 | PROFIT CENTER OWNER: |  | [NAME]
 | SAP COST CENTER: |  | 140569 |  |  |  |  |  |  |  | DUE DATE: |  | 2001-09-05 00:00:00
Direct expenses |  |  |  |  |  |  | 9849.19
Indirect expenses |  |  |  |  |  |  | 1170.65
TOTAL EXPENSES |  |  |  |  |  |  | 11019.84
OTHER COMPENSATION EXPENSES |  |  |  |  |  |  | 1285.96
TOTAL EXPENSES |  |  |  |  |  |  | 12305.8
Spreadsheet: 832220d1686189663-search-cell-text-for-specific-values-specific
Sheet: Sheet1

item num | type
serv123
wksta123
tblt123
serv123-456
serv123-457
serv123-458
serv123-459
serv123-460
serv123-461
serv123-462
serv123-463
wksta123-AS23
wksta123-AS24
wksta123-AS25
wksta123-AS26
wksta123-AS27
wksta123-AS28
[NAME]
wksta123-AS30
wksta123-AS31
wksta123-AS32
lptp123-AD32
lptp123-AD33
lptp123-AD34
lptp123-AD35
lptp123-AD36
lptp123-AD37
lptp123-AD38
lptp123-AD39
lptp123-AD40
lptp123-AD41
tblt123-AD67
tblt123-AD68
tblt123-AD69
tblt123-AD70
tblt123-AD71
tblt123-AD72
tblt123-AD73
tblt123-AD74
tblt123-AD75
tblt123-AD76
iph123-325
iph123-326
iph123-327
iph123-328
iph123-329
iph123-330
iph123-331
iph123-332
iph123-333
iph123-334
Sox-020694
Sox-02069H
Spreadsheet: 751051d1633807874-petty-cash-daily-report-working-sheet
Sheet: Report 2 Oct

 | Statement for: | 1 | 2021-10-02 00:00:00 |  | Current Date | Opening Balance
 |  |  |  |  |  | Closing Balance
 |  |  |  |  | Total Todate | Cash In
 |  |  |  |  |  | Cash Out
 | DATE | TYPE | [NAME] | Invoice Ref | CASH IN | CASH OUT | BALANCE
 |  |  | Opening Balance
Spreadsheet: 272385d1382369725-date-based-sumif-criteria-workbook-pensions-calc
Sheet: Staff Costs

 | First Central Insurance Management Ltd
 | Department Code | 112
 | Department Desc. | IT
 |  |  | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 |  | 2014 Total
 | Total Cost
 | Total | FTE
 |  | Headcount
 |  | Salary
 |  | NI
 |  | Pension
 |  | PMI
 |  | DIS
 |  | PHI
 | Employee | FTE
 |  | Salary
 |  | NI
 |  | Pension
 |  | PMI
 |  | DIS
 |  | PHI
 |  | Total Cost
 | Senior Employee | FTE
 |  | Salary
 |  | NI
 |  | Pension
 |  | PMI
 |  | DIS
 |  | PHI
 |  | Total Cost
 | Manager | FTE
 |  | Salary
 |  | NI
 |  | Pension
 |  | PMI
 |  | DIS
 |  | PHI
 |  | Total Cost
 | Senior Manager | FTE
 |  | Salary
 |  | NI
 |  | Pension
 |  | PMI
 |  | DIS
 |  | PHI
 |  | Total Cost
Spreadsheet: 005e27ca-d1ee-44d9-b15b-55861987bab7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | [NAME]/Foglio immissione dati | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 | Schweizer MM Gewehr 50m / Championnat Suisse d‘équipes carabine 50m
5 | 6 |  |  |  |  |  | 7
Schütz. | Vereinsliste/Liste société/ Lista società |  |  |  |  | Scheibe/Cible |  | oder | Elektr.[NAME] |  | [NAME] |  | [NAME]. | Liga/Gruppen Nr. | Runde
Nr. | Name Vorname | Jg. | Lizenz | Resultat |  | von | bis |  | Feuille électr. |  | Société: |  | No Equipe | No ligue/Groupe | Tour
 |  |  |  |  |  |  |  | Ma.  1 |  | 1.1
 |  |  |  |  |  |  |  |  |  | 1.2
 |  |  |  |  |  |  |  |  |  | 1.3
 |  |  |  |  |  |  |  |  |  | 1.4
 |  |  |  |  |  |  |  |  |  | 1.5
 |  |  |  |  |  |  |  |  |  |  | Verantwortlicher Funktionär/ |  | Fuctionaire responsable
 |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | Ma. 2
 |  |  |  |  |  |  |  |  |  |  | Strasse, PLZ, Ortschaft: / rue, NP, localité:
 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | Telefonnummer/Numéro de téléphone:
 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  | 5 | Schützen mit Nr. 1 = 1.Mannschaft
 |  |  |  |  |  |  |  | Ma. 3 |  |  | Schützen mit Nr. 2 = 2.Mannschaft usw.
 |  |  |  |  |  |  |  |  |  |  | Tireurs avec No 1 = 1. Équipe
 |  |  |  |  |  |  |  |  |  |  | Tireurs avec No 2 = 2. Équipe etc.
 |  |  |  |  |  |  |  |  |  | 6 | Vereinliste: Name Vorname, Jg. [NAME]. [NAME]
 |  |  |  |  |  |  |  |  |  |  | Liste société: nom prénom, année, No licence, résultat
 |  |  |  |  |  |  |  |  |  | 7 | Scheibennr. oder  elek. Standblattnr.
 |  |  |  |  |  |  |  | Ma. 4 |  |  | No  Cible ou No feuille electr.
 |  |  |  |  |  |  |  |  |  | 8 | Transfer Daten
 |  |  |  |  |  |  |  |  |  | 9 | Drucken / Imprimer
 |  |  |  |  |  |  |  |  |  |  | Nur die gelben [NAME] ausfüllen!
 |  |  |  |  |  |  |  | Ma. 5 |  |  | Ne remplir que les cellules jaunes!
 |  |  |  |  |  |  |  |  |  |  | Riempire soltanto le celle gialle!
 |  |  |  |  |  |  |  |  |  |  | [NAME]: | Vereinsliste alphabetisch
 |  |  |  |  |  |  |  |  |  |  | Indication: | Liste société alphabétique
 |  |  |  |  |  |  |  |  |  |  | Indicazione: | Lista società alfabetico
Spreadsheet: john_lavorato__16496__OGC Cheques - 2000
Sheet: Libby Curry

Order of [NAME]
Donations for deputy | [NAME]
CompanyName | FirstName | Initial | LastName | As it appears in the Brochure… | Address 1 | Address2 | City | Province | PostalCode | Donation | Category | Tax Receipt to Individual? | notes | Deputy | website address
 | [NAME] |  | [NAME] | ** No Publicity | 1311 Cabot St SW |  | Calgary | AB | T2T 3S2 | 200 | < 1000 | Y | ** No Publicity | [NAME]
 | [NAME] |  | [NAME] | [NAME] | 2624 21 St SW |  | Calgary | AB | T2T 5A8 | 50 | < 1000 | Y |  | [NAME]
Kinetic Resources (LPG) | [NAME] |  | [NAME] | Kinetic Resources (LPG) | 950, 333 5 Ave SW |  | Calgary | AB | T2P 3B6 | 1000 | [NAME] | Company |  | [NAME]
Quadra Energy & Trading | [NAME] |  | Loftus | Quadra Energy & Trading | 1440 Royal Bank Building | 335 8 Ave SW | Calgary | AB | T2P 1C9 | 1000 | [NAME] | Company | cheque will come later | [NAME]
Spreadsheet: 167564d1342025589-add-if-to-addif-to-count-from-certain-date-complex-formula
Sheet: Résumé

 |  |  |  |  |  |  | Tâches |  |  | 2 dernières semaines
 |  |  |  |  |  |  | Tâches | Temps |  | Tâches | Temps
Spreadsheet: c7040477-d739-4678-b303-95a8a6c41ca1
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
40339778 | 2014-03-03 21:24:08 | AXIS | 0 | 4 | 6 | 901544 | manu76 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
40340239 | 2014-03-03 21:44:15 | ALLIES | 0 | 1 | 6 | 901544 | manu76 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
40356358 | 2014-03-04 21:28:11 | AXIS | 0 | 4 | 6 | 757054 | Bulldoz44 | 9596 | western | 1944-06-06 | 1944-06-06 | Gold Beach | Gold Beach
40356758 | 2014-03-04 21:48:52 | ALLIES | 1 | 6 | 5 | 757054 | Bulldoz44 | 9596 | western | 1944-06-06 | 1944-06-06 | Gold Beach | Gold Beach
40372238 | 2014-03-05 21:21:58 | ALLIES | 1 | 5 | 3 | 1239735 | Vaillants | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40372509 | 2014-03-05 21:46:22 | AXIS | 0 | 4 | 5 | 1239735 | Vaillants | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40387602 | 2014-03-06 21:22:08 | AXIS | 0 | 4 | 6 | 1210418 | [NAME] | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
40387891 | 2014-03-06 21:47:37 | ALLIES | 0 | 4 | 6 | 1210418 | [NAME] | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
Spreadsheet: 65094d1265839190-calculate-electoral-results-swing-swing-2010v2005
Sheet: Swing

Constituency | Region | Swing | Con % | Lab % | LDem % | SNP % | PC % | BNP % | UKIP % | Other % |  | Con % | Lab % | LDem % | SNP % | PC % | BNP % | UKIP % | Other % |  | Con | Lab | Ldem | SNP | PC | BNP | UKIP | Other
 |  |  | 2010 |  |  |  |  |  |  |  |  | Percentage Change |  |  |  |  |  |  |  |  | Rank
Aberavon | Wales |  | 0.16 | 0.5036330210977852 | 0.1538299921211591 | n/a | 0.112982579007266 | 0.01323645277072573 | 0.02160553269718988 | 0.03732819749627943 |  | 0.05 | -0.09 | 0.01 | n/a | -0.01 | 0.01 | 0.02 | 0.01 |  | 2 | 1 | 3 | n/a | 4 | 7 | 6 | 5
Aberconwy | Wales |  | 0.1 | 0.4900266825891441 | 0 | n/a | 0.3978504655458736 | 0.01035583005243222 | 0 | 0 |  | -0.11 | 0.15 | -0.12 | n/a | 0.1 | 0.01 | -0.01 | -0.02 |  | 3 | 1 | 5 | n/a | 2 | 4 | 5 | 5
Aberdeen North | Scotland |  | 0.5210645615132093 | 0.3460606534312959 | 0 | 0.1328747850554948 | n/a | 0 | 0 | 0 |  | 0.16 | -0.08 | -0.06 | -0.02 | n/a | 0 | 0 | -0.02 |  | 1 | 2 | 4 | 3 | n/a | 4 | 4 | 4
Aberdeen South | Scotland |  | 0.1566850348027842 | 0.117169373549884 | 0.3547346287703016 | 0.126885150812065 | n/a | 0.2445258120649652 | 0 | 0 |  | 0.04 | -0.25 | 0.01 | -0.03 | n/a | 0.24 | 0 | -0.01 |  | 3 | 5 | 1 | 4 | n/a | 2 | 6 | 6
Aberdeenshire West and Kincardine | Scotland |  | 0.443223660767312 | 0.3429742249673358 | 0 | 0.2138021142653522 | n/a | 0 | 0 | 0 |  | -0.04 | 0.21 | -0.26 | 0.1 | n/a | 0 | 0 | -0.01 |  | 1 | 2 | 4 | 3 | n/a | 4 | 4 | 4
Airdrie and Shotts | Scotland |  | 0.2015534666137076 | 0.5491857540050311 | 8.826514850611236e-05 | 0.2491725142327552 | n/a | 0 | 0 | 0 |  | 0.1 | -0.04 | -0.11 | 0.08 | n/a | 0 | 0 | -0.03 |  | 3 | 1 | 4 | 2 | n/a | 5 | 5 | 5
Aldershot | South East |  | 0.3452584428596688 | 0.136912830789179 | 0 | n/a | n/a | 0.5178287263511523 | 0 | 0 |  | -0.1 | -0.08 | -0.29 | n/a | n/a | 0.52 | -0.02 | -0.03 |  | 2 | 3 | 4 | n/a | n/a | 1 | 4 | 4
Aldridge-Brownhills | West Midlands |  | 0.08249183249183249 | 0.4312444312444312 | 0.1810588060588061 | n/a | n/a | 0.09916097416097416 | 0.1443607068607069 | 0.06168324918324918 |  | -0.2 | -0.1 | 0.06 | n/a | n/a | 0.1 | 0.12 | 0.02 |  | 5 | 1 | 2 | n/a | n/a | 4 | 3 | 6
Spreadsheet: 102199d1300202497-excel-2007-how-to-filter-rows-that-are-subset-of-values-defined-in-column-example
Sheet: Sheet1

 | PART NUMBER | [NAME] |  |  |  | MPNs
 | 1 | asd |  |  |  | 1
 | 4 | sad |  |  |  | 2
 | 3 | sad |  |  |  | 3
 | 357 | asd |  |  |  | 4
 | 5 | dsa |  |  |  | 5
 | 21 | da |  |  |  | 6
 | 8 | sd |  |  |  | 7
 | 9 | asd |  |  |  | 8
 | 10 | asd |  |  |  | 9
 | 654 | fg |  |  |  | 10
 | 45 | hdf
 | 4 | gsd
 | 4 | gsd
 | 99 | fg
 | 74 | e
 | 85 | fg
 | 5 | fs
 | 57 | fdf
 | 57 | s
Spreadsheet: 121815d1316437439-list-compare-lowest-prices-example
Sheet: Sheet5

 |  | Country | Company | Price |  |  |  | Country | Company | Price
 |  | Country 1 | Company 1 | 54 |  |  |  | Country 1 | Company 1 | 22
 |  | Country 1 | Company 2 | 58 |  |  |  | Country 2 | Company 2 | 58
 |  | Country 1 | Company 3 | 69
 |  | Country 2 | Company 1 | 95
 |  | Country 2 | Company 2 | 58
 |  | Country 2 | Company 3 | 98
 |  | Country 1 | Company 1 | 22
Spreadsheet: 172316d1344125138-concatenate-the-information-under-same-name-and-delete-the-duplicate-again-test-data
Sheet: Sheet1

DATE | NAME | INFO | TEST
2012-07-01 00:00:00 | A | 1 | Q!
2012-07-02 00:00:00 | A | 1 | R$
2012-07-03 00:00:00 | B | 2 | Q!
2012-07-04 00:00:00 | B | 2 | R$
2012-07-05 00:00:00 | B | 2 | T%
2012-07-06 00:00:00 | C | 3 | F$
2012-07-07 00:00:00 | D | 4 | R$
2012-07-08 00:00:00 | E | 5 | T%
Spreadsheet: e89b5e06-5e42-4650-88b7-0b9c4fc3005a
Sheet: AngioTool Comparison

 | N=30 |  | N=30 |  | N=30 |  | N=1 | N=1 | N=1
Metric | [NAME] | [NAME] | 5HPP33_LD Avg | [NAME] | 5HPP33_HD Avg | [NAME] | Exp_ctrl | Exp_LC | Exp_HC
Explant area | 1.38939555 | 0.0507318418462164 | 1.283596112903226 | 0.05922626326044061 | 1.606479882352941 | 0.1098391368788432 | 3.8786265 | 5.483169 | 5.456826
Vessels area | 0.7992342 | 0.03170514976053454 | 0.7997460967741937 | 0.03503218652168756 | 0.4598415 | 0.02703485071246903 | 1.261656 | 1.648368 | 1.107315
Vessels percentage area | 57.54456403830103 | 1.816290994058257 | 62.32495200509407 | 1.354507116778139 | 28.71725708257917 | 2.14505558859384 | 32.52842211024959 | 30.06232344835623 | 20.29229079321935
Total Number of Junctions | 51.36666666666667 | 8.206319404027564 | 64.38709677419355 | 6.463628595739087 | 65.79411764705883 | 11.07489492874353 | 128 | 163 | 45
Junctions density | 36.99156769331548 | 5.829060769041511 | 50.20901862839609 | 4.958790116068778 | 41.14059269347219 | 7.582063756878963 | 33.00137303759462 | 29.72733468547112 | 8.246552116560066
Total Vessels Length | 12.7695984474218 | 0.7933742609634258 | 13.38136271268363 | 0.6714484090479236 | 14.30903968968221 | 0.8504341192690694 | 33.01968850670995 | 41.29628460467607 | 25.57862768884261
Average Vessels Length | 6.196147702170402 | 3.660828079148279 | 8.3699143080368 | 4.002957300325 | 0.2525866391763799 | 0.05236566705730979 | 0.2464155858709698 | 0.305898404479082 | 0.08172085523591888
Total Number of End Points | 21.66666666666667 | 5.261003793910455 | 13.96774193548387 | 2.857549894201231 | 160.0294117647059 | 16.62689550664671 | 352 | 386 | 650
Average Lacunarity | 0.08782824455145245 | 0.009476302441163424 | 0.0657483928630935 | 0.007377594540436803 | 0.2505724133892347 | 0.04045894063817984 | 0.1570941603286896 | 0.1716329324412545 | 0.2692693407544283
Students ttest (pvalue)
 | Control/5HPP33_LC | 5HPP33_LC/5HPP33_HC | Control/5HPP33_HC
Explant area
Vessels area
Vessels percentage area
Total Number of Junctions
Junctions density
Total Vessels Length
Average Vessels Length
Total Number of End Points
Average Lacunarity
Spreadsheet: 837772d1690404319-sum-up-order-total-if-id-matches-and-if-shipping-date-matches-order-date-or-5-days-excel_sumifjuly23
Sheet: Sheet1

ID | order sdate | cost |  |  |  |  |  |  |  |  | ID | shipping date | Total cost
1 | 2022-10-10 00:00:00 | 199 |  |  |  |  |  |  |  |  | 2 | 2022-10-14 00:00:00 | SUMIFS(A2:A6,L2,C2:C6,XLOOKUP(L2,A2:A6,B2:[NAME])
2 | 2022-10-18 00:00:00 | 200 |  |  |  |  |  |  |  |  | 1 | 2023-08-20 00:00:00
3 | 2021-03-19 00:00:00 | 84 |  |  |  |  |  |  |  |  | 5 | 2021-03-23 00:00:00
4 | 2020-02-04 00:00:00 | 43 |  |  |  |  |  |  |  |  | 4 | 2020-02-14 00:00:00
1 | 2020-11-24 00:00:00 | 100 |  |  |  |  |  |  |  |  | 3 | 2020-11-28 00:00:00
5 | 2021-03-29 00:00:00 | 200
 |  |  |  |  |  |  |  |  |  |  |  | Note:   Do sum If ID matches lookup date in column B and minus by  date in column M. If result is less than 5
Spreadsheet: 97765d1296849220-ranking-help-challenge-scoresheet
Sheet: Sheet1

 | Week 1
Team Name | % | Points | % | Points | Score
A | 0.99 | 4 | 0.12 | 4 | 8
B | 0.987 | 3 | 0.085 | 5 | 8
C | 0.995 | 5 | 0.152 | 2 | 7
D | 0.975 | 2 | 0.152 | 2 | 4
E | 0.975 | 2 | 0.185 | 1 | 3
F | 0.998 | 6 | 0.023 | 6 | 12