tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kimberly_watson__20597__NNG_TWO& M
Sheet: NNG

DIRECT  O & M COSTS
2001 - 2003 PLAN
NORTHERN NATURAL GAS COMPANY
( $ In Millions)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001 Plan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project
 |  |  |  | 1999 Actuals |  |  |  |  |  | 2000 Plan |  |  |  |  |  |  |  | Specific |  | Overhead |  |  |  | Gross O&M
 |  |  |  | Gross |  | Capital |  | Net |  | Gross |  | Capital |  | Net |  | Gross |  | Capital |  | Capital |  | Net |  | % O(U)
Department |  |  |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | 2000 Plan
Marketing |  |  |  |  |  | 0.5 |  |  |  |  | /1 |  | /1 |  |  |  | /5 |  |  | 0.7
Revenue Management - Ph. I Amortization |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0.914 |  | 0 |  | 0 |  |  | /6 | 1
Business Services |  |  |  |  |  | 0.2
Regulatory Affairs |  |  |  | 1.6 |  | 0.3 |  |  |  |  | /2 |  | /2 |  |  |  |  | 0.205 |  | 0.371
Subtotal Commercial
Market Services |  |  |  | 5.7 |  | 0.3 |  |  |  | 5.7 |  | 0.5 |  |  |  | 5.48 |  | 0.5
Finance & Accounting |  |  |  | 1.8 |  | 0.3 |  |  |  | 2 |  | 0.4 |  |  |  | 1.9 |  |  |  | 0.4
Executive |  |  |  | 0.4 |  | 0.1 |  |  |  | 0.4 |  | 0.1 |  |  |  | 0.1
Operations |  |  |  | 106.1 |  | 13 |  |  |  |  | /3 |  | /3 |  |  | 99.043 |  | 5.511 |  | 5.064
Information Technology |  |  |  | 5.4 |  |  |  |  |  | 12.8 | /4 | 1.282 | /4 |  |  | 13 |  | 0.35
Rent - Omaha (Business Services) |  |  |  |  |  | 0.5 |  |  |  |  |  | 0.553 |  |  |  |  |  |  |  | 0.553
Total Direct
G & A Expense
OI Amortization (F&A) |  |  |  | 0.6 |  |  |  |  |  | 0.6 |  |  |  |  |  | 0.3
KN Reimbursement (OPS)
Beck Settlement (F&A) |  |  |  | 0.8
[NAME] (MKT) |  |  |  | 0.3
Remediation Costs (OPS) |  |  |  | 0.2 |  |  |  |  |  |  |  |  |  |  |  | 0.4
Variable Pay, Annual Incentive (F&A) |  |  |  |  |  | 0.5 |  |  |  | 4.9 |  | 1 |  |  |  | 5.3 |  |  |  | 1
Other (F&A) |  |  |  | 0.3 |  |  |  |  |  | 0.1 |  |  |  |  |  | 0.2
Total G&A Expense
/1 restated to reflect capitalized revenue management expense $.265MM
/2  restated to reflect capitalized regulatory commission expense of $.240MM and removal of Washington DC Office $.086MM
/3 restated to reflect $1MM to IT Systems and added $1.4MM overhaul overhead dollars
/4  restated to reflect reorganization $6.7MM
/5 Does not include [NAME] o&m
/6  Non-Cash (Cash included in Capital budget)
Spreadsheet: 03247c4d-0952-4520-a6ed-3d9b3d752ade
Sheet: Docket

JURIS | TICKET | VIOL | OCCUR | NAME | VIOLATION | FINE AMT | COST AMT | REST AMT | TOTAL AMT | TIME SERVED | PAID AMT | BALANCE | OFFENSE DT | ATTORNEY | BOND POSTED | COMPLAINANT
DPD | 1019913 | 2244 | 0 | AMADI,EMMANUEL O | SPEEDING | 81 | 102.1 | 0 | 183.1 | 0 | 0 | 183.1 | 2013-01-31 00:00:00 |  | 0 | C VINSON
DPD | 1016488 | 2220 | 0 | BARNETT,ELZIE W | SPEEDING (SCHOOL ZONE) | 56 | 127.1 | 0 | 183.1 | 0 | 0 | 183.1 | 2012-09-17 00:00:00 |  | 0 | C VINSON
DPD | 1019161 | 1231 | 0 | BELLAMY,LONNIE DEAN | DL-DWLI - FIRST OFFENSE - SUSPENDED | 252 | 102.1 | 0 | 354.1 | 0 | 0 | 354.1 | 2012-10-12 00:00:00 |  | 0 | K JORDAN
DPD | 191983 | 3016 | 0 | CRAWFORD,DRAYLON EMIL | ASSAULT-CONTACT | 223 | 69 | 0 | 292 | 0 | 0 | 292 | 2013-01-09 00:00:00 | COLBY MAY | 0 | [NAME]
DPD | 191983 | 3017 | 0 | CRAWFORD,DRAYLON EMIL | THEFT UNDER $50 | 248 | 69 | 0 | 317 | 0 | 0 | 317 | 2013-01-09 00:00:00 | COLBY MAY | 0 | [NAME]
CFC | 4469 | 5740 | 0 | HODO,CAROLYN ANDERSON | [NAME] | 223 | 64 | 0 | 287 | 0 | 0 | 287 | 2012-09-08 00:00:00 |  | 0 | [NAME]
DPD | 1019113 | 2220 | 0 | HOWELL,AMOS FITZGERALD | SPEEDING (SCHOOL ZONE) | 61 | 127.1 | 0 | 188.1 | 0 | 0 | 188.1 | 2012-09-24 00:00:00 |  | 0 | K JORDAN
DPD | 192957 | 5740 | 0 | [NAME],LYNISHIA NICOLE | [NAME] | 281 | 69 | 0 | 350 | 0 | 0 | 350 | 2013-02-20 00:00:00 | [NAME] | 0 | JEFFERY KYLE PRICE
DPD | 1016369 | 1334 | 0 | REECE,TAYLOR ROSS | SEAT BELTS-PASSENGER | 45 | 102.1 | 0 | 147.1 | 0 | 0 | 147.1 | 2012-08-20 00:00:00 |  | 0 | C VINSON
DPD | 1016369 | 3005 | 0 | REECE,TAYLOR ROSS | ALCOHOL-OPEN CONTAINER | 198 | 69 | 0 | 267 | 0 | 0 | 267 | 2012-08-20 00:00:00 |  | 0 | C VINSON
DPD | 1017566 | 5740 | 0 | RODRIGUEZ,RICARDO | [NAME] | 281 | 69 | 0 | 350 | 0 | 0 | 350 | 2013-03-09 00:00:00 | RUDY VRBA | 0 | OLYMPIA BAHENA
Spreadsheet: 858161d1706897262-dynamic-formula-to-calculate-value-based-on-multiple-criteria-book4-1-
Sheet: Before Data

 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
Product Code |  |  |  | Total  Town Qty | TOWN 1 | TOWN 2 | TOWN 3 | TOWN 4 |  |  |  | TOTAL
A1010 |  |  |  | 33
A1010 |  |  |  | 98
A1010 |  |  |  | 41
A1010 |  |  |  | 570
A1010 |  |  |  | 0
A1010 |  |  |  | 214
A1010 |  |  |  | 36
A1010 |  |  |  |  | 400 | 262 | 180 | 150
A1030 |  |  |  | 25
A1030 |  |  |  | 75
A1030 |  |  |  |  | 40 | 20 | 10 | 30
A1035 |  |  |  | 15
A1035 |  |  |  | 0
A1035 |  |  |  | 30
A1035 |  |  |  |  | 20 | 10 | 5 | 10
B1150 |  |  |  | 30
B1150 |  |  |  | 20
B1150 |  |  |  | 0
B1150 |  |  |  | 45
B1150 |  |  |  | 65
B1150 |  |  |  |  | 50 | 60 | 20 | 30
Spreadsheet: 216644d1361831595-help-to-calculate-pay-outs-for-golf-outing-2013-golf-trip-1-
Sheet: Afternoon 1

 | The Loon
Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Total
Par | 4 | 3 | 5 | 3 | 5 | 4 | 4 | 5 | 3 | 36 |  |  | Front | Score
[NAME] |  |  |  |  |  |  |  |  |  | 0.0001 |  | 1 | [NAME] | 0.0001
SCOTT FRED UNCLE [NAME] |  |  |  |  |  |  |  |  |  | 0.0005 |  | 2 | SCOTT FRED UNCLE [NAME] | 0.0005
[NAME] |  |  |  |  |  |  |  |  |  | 0.0009 |  | 3 | [NAME] | 0.0009
HATCH MIKE B. GREG    JOE |  |  |  |  |  |  |  |  |  | 0.0013 |  | 4 | HATCH MIKE B. GREG    JOE | 0.0013
[NAME]       KIP |  |  |  |  |  |  |  |  |  | 0.0017 |  | 5 | [NAME]       KIP | 0.0017
[NAME] |  |  |  |  |  |  |  |  |  | 0.0021 |  | 6 | [NAME] | 0.0021
Spreadsheet: e4677552-5edf-44d7-8516-6e22fd1c65a9
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
40867705 | 2014-04-06 12:41:27 | ALLIES | 0 | 2 | 5 | 1542223 | guy.warmoes | 7334 | mediterranean | 1941-11-22 | 1941-11-22 | [NAME] | [NAME]
40867827 | 2014-04-06 13:04:33 | AXIS | 0 | 2 | 10 | 1509492 | Spernatz25 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40868065 | 2014-04-06 13:44:49 | ALLIES | 1 | 10 | 6 | 1509492 | Spernatz25 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40953994 | 2014-04-12 12:19:18 | AXIS | 1 | 6 | 2 | 797050 | Schicklgruber | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
40954099 | 2014-04-12 12:33:37 | ALLIES | 0 | 0 | 6 | 797050 | Schicklgruber | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
40954292 | 2014-04-12 13:15:34 | ALLIES | 0 | 7 | 10 | 120834 | foirallail | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40968945 | 2014-04-13 12:15:30 | ALLIES | 0 | 1 | 4 | 1007284 | Temple58 | 6151 | western | 1944-07-21 | 1944-07-21 | [NAME] | [NAME]
40969051 | 2014-04-13 12:26:45 | AXIS | 1 | 4 | 2 | 1007284 | Temple58 | 6151 | western | 1944-07-21 | 1944-07-21 | [NAME] | [NAME]
40969180 | 2014-04-13 12:40:10 | AXIS | 0 | 3 | 6 | 29441 | w a r r i o r | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
40969325 | 2014-04-13 12:56:06 | ALLIES | 0 | 2 | 6 | 29441 | w a r r i o r | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
40976467 | 2014-04-13 21:21:15 | ALLIES | 0 | 3 | 6 | 1537751 | lerocher | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
40976747 | 2014-04-13 21:40:27 | AXIS | 0 | 3 | 6 | 1515794 | Bodega28 | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
40977171 | 2014-04-13 22:01:06 | AXIS | 1 | 6 | 3 | 1549380 | Cheroon | 12506 | eastern | 1941-07-21 | 1941-07-31 | [NAME] | Percée russe
40977359 | 2014-04-13 22:14:05 | ALLIES | 1 | 6 | 5 | 1549380 | Cheroon | 12506 | eastern | 1941-07-21 | 1941-07-31 | [NAME] | Percée russe
Spreadsheet: 5175a773-7a8e-49a4-84cb-199ef84d4a1c
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
42244143 | 2014-07-10 19:30:22 | AXIS | 0 | 3 | 6 | 400481 | Invictus - Team du Sud | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42244533 | 2014-07-10 20:03:47 | ALLIES | 1 | 6 | 3 | 400481 | Invictus - Team du Sud | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 162227d1339770875-subscript-out-of-range-error-9-test-vnhgc
Sheet: Maeve Doyle

[NAME]
Order Number | Account Code | Customer Name | Reason for Quotation | Date Received | Review Date | Date Last Edited | Quote Value | Customer Order Ref | Responsible Person | Quote Status | Created By | Notes | Todays Date | 6 Months AGO | Older than 6 months | past review | 5 days + | over 5 days no.
105250 | NATIOBAL | National Ele Wholesale (Irl) | Enquiry on 30/05/2012 at  16:06 | 30/05/2012 | 31/05/2012 | 30/05/2012 | 90.22 |  | MD | Active Quotation Still Ongoing | [NAME]
Spreadsheet: 28717d1223151209-automate-goal-seek-time
Sheet: Sheet1

Variables |  | Calculations |  | Changing cell |  | Target cell
FAV | Av access
sex | Male | ideal stdkt/v | 2
real sex | 1 | urea volume distribution | 45.50208
height | 182 | Kt/v rénal | 0 | time | 592.5620574927993 | Real KTv | 1.999156633955962
age | 37 | stdkt/v | 1.999156633955962
weight | 80 | Real eKT/V | 0.972747565177441
clairance rénale d'urée | 0
NT | 3
spKt/V | 1
Spreadsheet: 797441d1663877961-how-to-categorize-dates-to-months-book1
Sheet: New Worksheet

Next Review | Attempt | Expected Result
2022-07-31 00:00:00 |  | 2022-07-22 00:00:00
2022-07-31 00:00:00 |  | 2022-07-22 00:00:00
 |  | No Date
2022-03-18 00:00:00 |  | 2022-06-22 00:00:00
2022-03-18 00:00:00 |  | 2022-06-22 00:00:00
2023-01-31 00:00:00
2022-06-19 00:00:00
2022-06-19 00:00:00
2022-06-19 00:00:00
2022-07-24 00:00:00
2023-01-31 00:00:00
2022-02-26 00:00:00
2022-02-17 00:00:00
2022-10-31 00:00:00
2022-10-31 00:00:00
2022-09-11 00:00:00
2021-02-25 00:00:00
2022-04-01 00:00:00
2022-04-17 00:00:00
2022-07-31 00:00:00
2022-08-27 00:00:00
2022-01-09 00:00:00
2022-10-31 00:00:00
2022-12-31 00:00:00
2022-12-31 00:00:00
2023-02-28 00:00:00
2022-01-12 00:00:00
2022-02-19 00:00:00
2022-06-18 00:00:00
2022-09-30 00:00:00
2022-06-05 00:00:00
2021-11-04 00:00:00
2022-01-26 00:00:00
2022-09-22 00:00:00
2022-11-13 00:00:00
2021-11-05 00:00:00
2022-02-19 00:00:00
2021-02-25 00:00:00
2022-04-30 00:00:00
2023-04-30 00:00:00
2022-05-06 00:00:00
2021-07-22 00:00:00
2022-08-04 00:00:00
2022-08-28 00:00:00
2022-10-02 00:00:00
2021-10-18 00:00:00
2022-02-06 00:00:00
2022-10-17 00:00:00
2023-01-31 00:00:00
2023-02-28 00:00:00
2023-03-12 00:00:00
2023-03-31 00:00:00
2023-03-31 00:00:00
2023-04-30 00:00:00
2023-04-02 00:00:00
2023-04-09 00:00:00
2022-10-19 00:00:00
2023-06-30 00:00:00
2022-09-29 00:00:00
2023-05-28 00:00:00
2022-09-26 00:00:00
2022-12-13 00:00:00
2022-11-02 00:00:00
2022-10-31 00:00:00
2022-10-20 00:00:00
2022-10-20 00:00:00
2022-10-26 00:00:00
2022-12-08 00:00:00
2022-11-29 00:00:00
2022-09-15 00:00:00
2022-09-15 00:00:00
2023-08-10 00:00:00
2022-09-15 00:00:00
2022-04-16 00:00:00
2022-03-28 00:00:00
2022-03-25 00:00:00
2022-05-22 00:00:00
2022-10-31 00:00:00
2022-11-30 00:00:00
2022-11-10 00:00:00
2022-12-12 00:00:00
2022-05-08 00:00:00
2022-12-31 00:00:00
2022-08-31 00:00:00
2022-05-06 00:00:00
2022-09-04 00:00:00
2022-02-25 00:00:00
2022-07-10 00:00:00
2022-08-18 00:00:00
2022-07-27 00:00:00
2022-12-30 00:00:00
2022-09-30 00:00:00
2022-03-10 00:00:00
2022-03-08 00:00:00
2023-04-30 00:00:00
2022-03-31 00:00:00
2022-06-18 00:00:00
2022-12-08 00:00:00
2022-06-12 00:00:00
2022-12-31 00:00:00
2022-07-09 00:00:00
2023-01-31 00:00:00
2022-11-01 00:00:00
2022-07-09 00:00:00
2022-09-18 00:00:00
2022-04-07 00:00:00
2022-11-21 00:00:00
2022-09-11 00:00:00
2021-12-29 00:00:00
2022-04-28 00:00:00
2022-04-03 00:00:00
2023-02-28 00:00:00
2021-10-29 00:00:00
2022-08-21 00:00:00
2022-04-17 00:00:00
2022-03-03 00:00:00
2022-10-15 00:00:00
2022-11-15 00:00:00
2022-12-13 00:00:00
2022-07-31 00:00:00
2022-02-25 00:00:00
2023-07-02 00:00:00
Spreadsheet: 241a0f99-a768-41bd-80c5-593e1366b938
Sheet: Sheet1

Nuove Sedi di Direttivo
BGIC896007
BGIC897003
BGIC89800V
BGIC89900P
BGIC8AA007
BSIC89000R
[NAME]
BSIC89200C
BSIC893008
BSIC894004
BSIC89500X
BSIC89600Q
BSIC89700G
[NAME]
BSIC899007
BSIC8AA00Q
BSIC8AB00G
BSIC8AC00B
BSIC8AD007
BSIC8AE003
BSIC8AF00V
BSIC8AG00P
BSIS036008
BSIS037004
COIC853004
COIC85400X
COIC85500Q
COIS009006
CRIC816008
CRIC817004
CRIC81800X
CRIC81900Q
CRRI04000X
LCIC829001
LCIC830005
MIIC8E000C
MIIC8EB004
MIIC8EC00X
MIIC8ED00Q
MIIC8EE00G
MIIC8EF00B
MIIC8EG007
MIIC8EH003
MIIC8EJ008
MIIC8EK004
MIIC8EL00X
MIIC8EM00Q
MIIC8EN00G
MIIC8EP007
MIIC8EQ003
MIIC8ER00V
MIIC8ES004
MIIC8ET00X
MIIC8EU00Q
MIIC8EV00G
MIIC8EW00B
MIIC8EX007
MIIC8EY003
MIIC8EZ00V
MIIS08900V
MIIS09100V
MIIS09200P
MIIS09300E
MIIS09400A
MITF390005
PVIC81700E
PVIC81800A
PVIC819006
PVIC82000A
PVIC821006
PVIC822002
PVIC82300T
PVIC82400N
SOIC81700Q
SOIC81800G
SOIC81900B
SOIC82000G
SOIC82100B
VAIC879002
VAIC880006
Spreadsheet: 881762d1729921864-combining-multiple-rows-into-one-row-based-on-criteria-excel-example-1-
Sheet: Sheet1

 | I have data in this format. Thousands of rows. Each company has several products associated with their company. Want to combine each company into one row.
 | Group # | Group Name | Products | Column1 |  | Group # | Group Name | Product1 | Product2 | Product3 | Product4 | Product5
 | 103567 | ABC Company | Product1 | x |  | 103567 | ABC Company | x | x |  | x | x
 | 103567 | ABC Company | Product2 | x
 | 103567 | ABC Company | Product4 | x
 | 103567 | ABC Company | Product5 | x
 | 103567 | ABC Company | Product3
 | And want to make it look like this.
 |  |  |  | Product1 | Product2 | Product3 | Product4 | Product5
 | 103567 | ABC Company |  | x | x |  | x | x
 | Lookup Group # and Group Name and return the products associated to those two things in columns versus rows. Want it to show as "x" if that company has that product and blank if it doesn't.
Spreadsheet: 888818d1739399564-sorting-dates-1900-datesort2
Sheet: Sheet1

 |  | 11 Nov 1800 | 1800-11-18 |  | 18 Nov 1800 |  |  |  |  | Column1 | Column2
 |  |  |  |  | Nov 1800 |  |  |  |  | Jan | 01
 |  |  |  |  | 1800 |  |  |  |  | Feb | 02
 |  |  |  |  |  |  |  |  |  | Mar | 03
 |  |  |  |  |  |  |  |  |  | Apr | 04
 |  |  |  |  |  |  |  |  |  | May | 05
 |  |  |  |  |  |  |  |  |  | Jun | 06
 |  |  |  |  |  |  |  |  |  | Jul | 07
 |  |  |  |  |  |  |  |  |  | Aug | 08
 |  |  |  |  |  |  |  |  |  | Sep | 09
 |  |  |  |  |  |  |  |  |  | Oct | 10
 |  |  |  |  |  |  |  |  |  | Nov | 11
 |  |  |  |  |  |  |  |  |  | Dec | 12
Spreadsheet: 9de8becd-e83e-424d-9053-bcb2a3d884b8
Sheet: Sheet1

2199 Gödöllő–Budapest | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
(Érvényes: 2011. december 11-től)
Km | Km | Km | Km | VOLÁNBUSZ Zrt. | 4 | 2 | 6 | 8 | 12 | 10 | 14 | 16 | 20 | 18 | 24 | 22 | 28 | 26 | 30 | 32
 |  |  |  |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
0 | 0 | .. | .. | Gödöllő, aut. áll. | 07:30:00 | 07:30:00 | 08:00:00 | 08:00:00 | 08:15:00 | 08:15:00 | 08:30:00 | 08:30:00 | 09:00:00 | 09:00:00 | 09:30:00 | 09:30:00 | 13:30:00 | 13:30:00 | 16:30:00 | 16:30:00
21.2 | 21.2 | .. | .. | Budapest, Szerencs u.
25.3 | 25.3 | .. | .. | Budapest, [NAME] út | 07:56:00 | 07:56:00 | 08:26:00 | 08:26:00 | 08:41:00 | 08:41:00 | 08:56:00 | 08:56:00 | 09:26:00 | 09:26:00 | 09:56:00 | 09:56:00 | 13:56:00 | 13:56:00 | 16:56:00 | 16:56:00
S | 29.3 | .. | .. | Budapest, Árpád híd aut. áll. | S | 08:10:00 | 08:40:00 | S | S | 08:55:00 | 09:10:00 | S | S | 09:40:00 | S | 10:10:00 | S | [NAME] | 17:10:00 | S
28.2 | .. | .. | .. | Budapest, Stadion aut. pu. | 08:05:00 | o | o | 08:35:00 | 08:50:00 | o | o | [NAME] | 09:35:00 | o | 10:05:00 | o | 14:05:00 | o | o | 17:05:00
31.6 | .. | .. | .. | Budapest, Népliget | 08:20:00 |  |  | 08:50:00 | [NAME] |  |  | 09:20:00 | 09:50:00 |  | 10:20:00 |  | 14:20:00 |  |  | 17:20:00
40.6 | .. | .. | .. | Budapest, [NAME] pu. | 08:40:00 |  |  | 09:10:00 | 09:25:00 |  |  | 09:40:00 | 10:10:00 |  | 10:40:00 |  | 14:40:00 |  |  | 17:40:00
[NAME]:
8 külön rendeletre
 | a járat érinti a megállóhelyet, de nem áll meg
S | a járat nem érinti a megállóhelyet, [NAME]
o | az időadat érkezési időpontot jelöl
Spreadsheet: 678644d1589992007-product-sum-with-itemcodes-productsum
Sheet: Blad1

 |  |  |  |  |  |  | RESULT | RESULT
 |  | List of variables |  |  |  |  | CODE | CODE | CODE
 |  | Value | Code |  |  |  | 3000 | 4000 | 5000
 |  | 100 | 3000 |  |  |  | 600 | 900 | 200
 |  | 400 | 4000
 |  | 500 | 4000 |  |  |  | Summarize item values with certain code!
 |  | 500 | 3000
 |  | 200 | 5000
Spreadsheet: 272312d1382353791-ranking-with-criteria-ranking_21-10-13
Sheet: Over Due

Central | Over [NAME] (column C)
Rank | Customer ID
1
2
3
4
5
6
7
8
9
10
East | [NAME] (column C)
Rank | Customer ID
1
2
3
4
5
6
7
8
9
10
South | [NAME] (column C)
Rank | Customer ID
1
2
3
4
5
6
7
8
9
10
North | [NAME] (column C)
Rank | Customer ID
1 | "I want to a formula to rank (Top 10, rank only amnt. In North region), and show ID in this cell".
2
3
4
5
6
7
8
9
10
Spreadsheet: 89593d1289383588-how-to-make-repeated-value-from-database-to-fill-in-another-column-of-the-same-row-amount
Sheet: Sheet1

 | Database |  |  |  |  |  |  | Present Table
ID | Name | Class | Amount
 |  |  |  |  |  |  | Class | O'Level
2 | Anggra Junia | O'Level | 100 |  | B 2 C |  | ID | Name | Class | Amount | First Pay | Second Pay | [NAME] | Fourth Pay
2 | Anggra Junia | O'Level | 200 |  | B 4 C
2 | Anggra Junia | O'Level | 300 |  | Itm
2 | Anggra Junia | O'Level | 400 |  | Itm 1
3 | Gio Fitra | Itm | 100 |  | O'Level
4 | [NAME] | Itm | 100
5 | [NAME] | Itm | 100
6 | [NAME] Ginting | B 4 C | 100
7 | [NAME] | Itm 1 | 100
8 | [NAME] | B 2 C | 100
1 | [NAME] | B 2 C | 100
 |  |  |  |  |  |  |  | I want to have a drop down to chose class and bellow table will show those name of the class
 |  |  |  | Required Table |  |  |  | but will not repeat, if it is, the repeated amount will fill in second, third or fourth
 |  |  |  | Class | O'Level
 |  |  |  | ID | Name | Class | Amount | First Pay | Second Pay | [NAME] | Fourth Pay
 |  |  |  | 2 | Anggra Junia | O'Level |  | 100 | 200 | 300 | 400
Spreadsheet: 721906d1614946655-conditional-format-combined-with-lookup-resource-schedule
Sheet: Detailed Breakdown

Work Scheduled: | 2021-04-01 00:00:00
 | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
Project 1
Atkins | 1 | 1 |  |  | 1 | 1 | 1 | 0.25 | 0.5
[NAME]
[NAME] | 1
[NAME]
Ericcsen
Fisher |  | 1
Graffham | 1 |  |  |  | 1
Hill
Project 2
Atkins |  |  |  |  |  |  |  | 0.75
[NAME] | 1 |  |  |  | 1
[NAME]
[NAME] | 1
Ericcsen |  |  |  |  | 1
Fisher |  |  |  |  | 1
Graffham
Hill | 1 |  |  |  | 1
Project 3
Atkins
[NAME] |  |  |  |  |  |  |  |  | 0.5
[NAME] | 1 |  |  |  | 1
[NAME] |  |  |  |  | 1
Ericcsen | 1
Fisher | 1
Graffham
Hill
Spreadsheet: 0efd22be-ce76-4cc9-beb1-e83cf4ef4d14
Sheet: Sheet1

Product: | Unnamed: 1 | Microsoft SharePoint Foundation 2010 | Unnamed: 3
Worksheet title: |  | Content type and workflow planning worksheet
Related content: |  | Content type and workflow planning (SharePoint Foundation 2010)
Prepared by:
Date:
Instructions: |  | After you review your list of content types to determine which ones can use core content types, plan new content types by following these steps.
 |  | 1. For each content type in your solution, create a new tab, and then copy the "Content type data sheet" to the new tab.
 |  | 2. Record the details of each content type on its individual "Content type data sheet" tab.
 |  | Note: Some of the columns might not be relevant, depending on the content type that you use.
 |  | Column name | Description
 |  | Content type | Record the name of the content type (for example, list or document).
 |  | Scope | Record the scope of the content type (that is, does  it apply to the enterprise, site collection, or site level).
 |  | Site URL | Record the URL of the site in which the new content type will be defined. Keep in mind that content types are available in the site in which they are defined and in all sites below that site.
 |  | Parent content type | Record the parent content type name. This will be either a core content type or a custom content type that you have already planned.
 | Columns | Column name | Record the name of a predefined column or a column that you will create. The name of a column is important, because it can communicate the column's purpose. Therefore, even if a column of a type that you need is already defined in the Site Collection Column gallery, you might decide to define a similar column by using a more relevant name for your application. Note that you can have several columns per content type.
 |  | Type | Record the column type.
 |  | Purpose | Record the purpose of the column.
 |  | New? | Record whether the column is new.
 | Template | Template name | Record a unique name for the template.
 |  | Template description | If the content type does not inherit its template from its parent content type, type a brief description of the template. Note that you can only have one template per content type.
 |  | Type | Record the template type.
 |  | New? | Record whether the template is inherited from the parent content type.
 | Workflows | Workflow name | Record a unique name for the workflow. Note that you can have several workflows per content type.
 |  | Workflow template | Record the name of the workflow template to associate with the content type.
 |  | New? | Record whether the workflow is inherited from the parent content type.
Spreadsheet: 2c28f484-f700-4926-ad92-d5e20729c0bf
Sheet: Subject TOTALS

[NAME] = % receiving grade other than W | Retention Rates
 | MSJC Dual Enrollment Total by Subject
[To view course data click on Subject Name below] | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Subject | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12
Accounting
Alcohol/Drug Studies
Allied Health
Administration of Justice
Anatomy & Physiology
Anthropology
Art
American Sign Language
Astronomy
Audio Technology
Automotive/Transportation
Business Administration
Biology
Computer Applications
Childhood Development & Education
Chemistry
Communication
Corrections
Computer Science/Informations Systems
Dance
Diagnostic Medical Sonography
Economics
Education/Teacher Preparation
English
Engineering
Environment Science
Earth Science
English as a Second Language
Fire Technology
French
Geography
Geology
Gerontology
Guidance
Honors Enrichment Program
History
Horticulture
Health Science
Humanities
LEAD
Legal Assistant
[NAME]
[NAME]
Mathematics
Management/Supervision
Multimedia
Music
Networking
Nursing
Nutrition
Occupational Internship
Office Technology
Physical Education
PEIC
Philosophy
Photography
Physics
Portuguese
Political Science
Psychology
Real Estate
Reading
Sustainable Energy Management
Sociology
Spanish
Teaching Assistant
Theater Arts
Viticulture and Enology
Water Technology
Term Dual Enrollment Average Retention Rate
AY Dual Enrollment Average Retention Rate
Retention rate = # of “A, B, C, CR, P, D, F, NC, NP and I ” grades divided by (the # of all grades) “A, B, C, CR, P, D, F, NC, NP, I and W”