tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lisa_gang__22230__EPE_MARCH_2002
Sheet: MARCH(11)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-03-11 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS | PALO VERDE | FOUR CORNERS |  | PALO VERDE | PALO VERDE | PALO VERDE
Pacific | Mountain | SALE | SALE | SALE |  | PURCHASE | PURCHASE | PURCHASE
Standard | Standard | EPMI | PSCO | EPMI |  | EPMI | EPMI | MIRANT
Time | Time | 22.25 | 31.5 | 22.25 |  | 121 | 121 | 141.5
 |  | CARRY OVER FROM 3/10 | FOR THE DAY | ON GOING DAILY |  | ON GOING DAILY | ON GOING DAILY | ONGOING DAILY
 |  | 3/1/02-3/31/02 | 3/11/02-3/11/02 | 3/1/02-3/31/02 |  | 3/1/02-3/31/02 | 3/1/02-3/31/02 | 3/1/02-3/31/02
 |  | EPMI TAG#41386 | WESCO TAG#56162 | EPMI TAG#41387 |  | EPMI TAG#41388 | EPMI TAG#41407 | EPE TAG#EPE1192 |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL | DIRECT BILL | DIRECT BILL |  | DIRECT BILL | DIRECT BILL | DIRECT BILL
2400 | 0100 | 25 | 0 | 0 |  | 0 | 0 | 0
0100 | 0200 | 0 | 0 | 25 |  | 0 | 0 | 0
0200 | 0300 | 0 | 0 | 25 |  | 0 | 0 | 0
0300 | 0400 | 0 | 0 | 25 |  | 0 | 0 | 0
0400 | 0500 | 0 | 0 | 25 |  | 0 | 0 | 0
0500 | 0600 | 0 | 0 | 25 |  | 0 | 0 | 0
0600 | 0700 | 0 | 0 | 25 |  | 0 | 0 | 0
0700 | 0800 | 0 | 25 | 0 |  | -25 | -25 | -25
0800 | 0900 | 0 | 25 | 0 |  | -25 | -25 | -25
0900 | 1000 | 0 | 25 | 0 |  | -25 | -25 | -25
1000 | 1100 | 0 | 25 | 0 |  | -25 | -25 | -25
1100 | 1200 | 0 | 25 | 0 |  | -25 | -25 | -25
1200 | 1300 | 0 | 25 | 0 |  | -25 | -25 | -25
1300 | 1400 | 0 | 25 | 0 |  | -25 | -25 | -25
1400 | 1500 | 0 | 25 | 0 |  | -25 | -25 | -25
1500 | 1600 | 0 | 25 | 0 |  | -25 | -25 | -25
1600 | 1700 | 0 | 25 | 0 |  | -25 | -25 | -25
1700 | 1800 | 0 | 25 | 0 |  | -25 | -25 | -25
1800 | 1900 | 0 | 25 | 0 |  | -25 | -25 | -25
1900 | 2000 | 0 | 25 | 0 |  | -25 | -25 | -25
2000 | 2100 | 0 | 25 | 0 |  | -25 | -25 | -25
2100 | 2200 | 0 | 25 | 0 |  | -25 | -25 | -25
2200 | 2300 | 0 | 25 | 0 |  | -25 | -25 | -25
2300 | 2400 | 0 | 0 | 25 |  | 0 | 0 | 0
2400 | 0100 | 0 | 0 | 25 |  | 0 | 0 | 0
 | MST Total |  |  |  |  |  |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  |  |  | TOTAL SALES |  |  |  | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C | EPE(G)PV | EPE(G)4C |  | PINWEST(G)PV | PINWEST(G)PV | PNM(G)PV
 |  | EPMI | PSCO | EPMI |  | AEP | MAEM | MIRANT
 |  | AZPS(T)FC3/PPD2 | AEP | AZPS(T)FC3/PPD2 |  | EPMI | AEP | EPE
 |  | WALC(T)PPD2/COOLIDGE | WESCO | WALC(T)PPD2/COOLIDGE |  | EPE | EPMI | EPMI
 |  | CRSP(L)COOLIDGE | LDWP | CRSP(L)COOLIDGE |  | EPE(T)PV/WW | EPE | EPE
 |  |  | LDWP(T)PVD/SYLMAR/SYS |  |  | TEP(T)WW/SP3 | EPE(T)PV/W | EPE(T)PV/WW
 |  |  | [NAME] |  |  | EPE(T)SP3/LUNA | TEP(T)WW/SP3 | TEP(T)WW/SP3
 |  |  |  |  |  |  | EPE(T)SP3/LUNA | EPE(T)SP3/LUNA
Spreadsheet: 746698d1630953639-how-many-names-are-common-between-lists-and-how-many-are-not-in-any-list-sales-sample
Sheet: In Sales not in Webinar

Column1
[NAME]
Leanne
[NAME]
Imogen
Rochelle
[NAME]
Riley
Victoria
Lily
[NAME]
Stella
Everly
Isla
Leah
Lillian
Addison
Willow
[NAME]
Paisley
[NAME]
Naomi
Eliana
Brooklyn
Elena
[NAME]
Spreadsheet: 56667d1256813678-conditional-sums-help-project-date-example
Sheet: Project C

 |  | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00
Supplier 1
Supplier 2
Supplier 3
Supplier 4
Supplier 5
Supplier 6
Supplier 7
Supplier 8
Supplier 9
Supplier 10
Spreadsheet: 164155d1340662396-excel-2007-compare-column-and-rearrange-row-data-accordingly-copy-of-row_matching123c
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  | put sample data on sheet1
Col A | Name1 | Amt2 | [NAME]
a22 | Aman | 1234 | Aman
a1 | [NAME] | 100 | [NAME]
a4 | Fabio | 755 | Fabio
a3 | Karim | 121 | Karim
a6 | Phantom
aa6 | Rafael | 123 | Rafael
aa2 | Ramos | 123 | Ramos
a5 | [NAME] | 5555 | [NAME]
 |  | 500 | Eshan
Spreadsheet: 862890d1710461964-calculate-deadlines-and-costs-ticket-calculator-eba
Sheet: Tickets (new)

Severity 1 | Severity 2 | Severity 3 | Severity 4 | Severity 5
£2,500 for the first Fix Time Failure for an individual Incident Severity Level 1 Incident and then £500 for each subsequent Fix Time Failure for the same Incident Severity Level 1 Incident. | £1,500 for each Fix Time Failure for Incident Severity Level 2 Incidents. | £1,000 for each Fix Time Failure for Incident Severity Level 3 Incidents. | £500 for each Fix Time Failure for Incident Severity Level 4 Incidents. | £250 for each Fix Time Failure for Incident Severity Level 5 Incidents.
< 4 hours | < 24 hours | < 5 Business Days | <  20 Business Days | As agreed with the Customer
Issue key | Issue Type | Summary | Status | Resolution | Assignee | Reporter | Severity | Created | Resolved | Elapsed | Due date | On Time (YES/NO) | Direct Service Credits |  | Severity | Limit | Direct Service Credits | [NAME] | Fix Time Failures | Calculation
 |  |  |  |  |  |  |  | 2024-01-30 07:26:00 | 2024-01-30 08:16:00 |  |  |  |  |  | 1 | 0.0001 | 2500 | 500
 |  |  |  |  |  |  |  | 2024-01-26 06:25:00 | 2024-01-27 08:31:00 |  |  |  |  |  | 2 | 0.1667 | 1500
 |  |  |  |  |  |  |  | 2024-01-25 06:22:00 | 2024-02-02 09:26:00 |  |  |  |  |  | 3 | 1.0001 | 1000
 |  |  |  |  |  |  |  | 2024-01-24 14:01:00 | 2024-01-24 16:43:00 |  |  |  |  |  | 4 | 5.0001 | 500
 |  |  |  |  |  |  |  | 2024-01-24 06:29:00 | 2024-01-24 09:20:00 |  |  |  |  |  | 5 | 20.0001 | 250
 |  |  |  |  |  |  |  | 2024-01-23 14:34:00 | 2024-01-23 17:12:00 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  | 2024-01-23 12:31:00
 |  |  |  |  |  |  |  | 2024-01-23 06:37:00
 |  |  |  |  |  |  |  | 2024-01-24 06:36:59.995000
 |  |  |  |  |  |  |  | 2024-01-25 06:36:59.995000 | Ongoing
Spreadsheet: 767013d1644238778-return-a-qty-and-ref-code-as-per-lookup-criteria-in-column-a-return-a-qty-and-ref-code-as-per-lookup-criteria-in-column-a-1-
Sheet: Sheet1

Item Code | Item Description | Expected Results |  |  |  |  |  | Item Code | Item Description |  |  | HDR-2011/2313 | HDR-2011/2333 | HDR-2012/2337 | HDR-2011/2312 | HDR-2011/2334 | HDR-2012/2359 | HDR-2101/2422 | HDR-2101/2437+2438 | HDR-2102/2454 | HDR-2101/2426 |  | HDR-2102/2447
 |  | Qty | Ref# Code
9366 | Shore Brace Frame (H) | 14 | HDR-2011/2333 |  |  |  |  | 9366 | Shore Brace Frame (H) |  |  |  | 14 | 82 |  |  |  |  |  |  |  |  | 39
25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) | 50 | HDR-2011/2333 |  |  |  |  | 25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) |  |  |  | 50 | 65 |  |  | 6
25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) | 65 | HDR-2012/2359 |  |  |  |  | 13141 | Post head [NAME] (2.0'') (L) ([NAME].) |  |  |  | 115 | 38 |  | 74 | 7 | 137 |  | 178 |  |  | 421
9366 | Shore Brace Frame (H) | 82 | HDR-2102/2447 |  |  |  |  | 141516 | Cross Brace 0.90m |  |  |  |  |  | 62 |  |  |  | 15
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 115 | HDR-2011/2333 |  |  |  |  | 141523 | Cross Brace 1.20m |  |  | 55
25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) | 6 | HDR-2012/2337
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 38 | HDR-2012/2337
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 74 | HDR-2011/2334
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 7 | HDR-2012/2359
141516 | Cross Brace 0.90m | 62 | HDR-2011/2312
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 137 | HDR-2101/2422
141516 | Cross Brace 0.90m | 15 | HDR-2101/2437+2438
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 178 | HDR-2102/2454
9366 | Shore Brace Frame (H) | 39 | HDR-2012/2337
141523 | Cross Brace 1.20m | 55 | HDR-2011/2313
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 421 | HDR-2102/2447
Spreadsheet: 736615d1623766642-index-and-match-not-working-test-file-1-
Sheet: Sheet2

BUILD PLAN | Product | Part Number | 2021-05-01 00:00:00
 |  | 123 |  |  |  |  |  |  | =INDEX('Sheet 1'!R10:DE40,MATCH(Sheet2!D$1,'Sheet 1'!$R$2:$DE$2,0),MATCH(Sheet2!$C9,'Sheet 1'!O10:O39,0),MATCH(Sheet2!A1,'Sheet 1'!$R$9:$DE$9,0))
 |  | 456
 |  | 789
 |  | 101112 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00
 |  | 131415 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2402 | 1795 | 1967 | 2139 | 1949 | 2080
 |  | 144069 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150 | 130 | 316 | 362 | 357 | 332
 |  | 156723 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240 | 480 | 352 | 348 | 319 | 290
 |  | 169377 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150 | 0 | 0 | 0 | 0 | 0
 |  | 182031 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 | 6 | 4 | 4 | 6
 |  | 194685
 |  | 207339
 |  | 219993
 |  | 232647
 |  | 245301
 |  | 257955
 |  | 270609
 |  | 283263
 |  | 295917
 |  | 308571
 |  | 321225
 |  | 333879
 |  | 346533
 |  | 359187
 |  | 371841
 |  | 384495
 |  | 397149
 |  | 409803
 |  | 422457
 |  | 435111
Spreadsheet: 785080d1656134594-survey-responses-in-multiple-columns-should-aligned-in-single-column-against-username-horizontal-column-entries-to-convert-in-vertical
Sheet: Sheet1

Username | Certification 1 | year | Certification 2 | Year
[NAME] | powerbi | 2012 | hadoop | 2016 |  |  |  | I want the output should be
[NAME] | word | 2021 | ccna | 2021
[NAME] | aws | 2017 | ppt | 2011 |  |  |  |  | Username | Certification completed
[NAME] | sap | 2012 | ppt | 2012 |  |  |  |  | [NAME] | hadoop
[NAME] | excel | 1999 | msoffice | 2014 |  |  |  |  |  | powerbi
[NAME] | ppt | 2011 | powerbi | 2012 |  |  |  |  | [NAME] | ccna
[NAME] | msoffice | 2016 | aws | 2022 |  |  |  |  |  | word
[NAME] | ccnp | 2014 | excel | 2017 |  |  |  |  | [NAME] | aws
[NAME] | hadoop | 2022 | word | 1999 |  |  |  |  |  | ppt
sorup | ccna | 2019 | ccnp | 2019 |  |  |  |  | [NAME] | ppt
sruti | ppt | 2011 | sap | 2011 |  |  |  |  |  | sap
 |  |  |  |  |  |  |  |  | [NAME] | excel
 |  |  |  |  |  |  |  |  |  | msoffice
 |  |  |  |  |  |  |  |  |  | powerbi
 |  |  |  |  |  |  |  |  |  | ppt
 |  |  |  |  |  |  |  |  | [NAME] | aws
 |  |  |  |  |  |  |  |  |  | ccnp
 |  |  |  |  |  |  |  |  |  | excel
 |  |  |  |  |  |  |  |  |  | msoffice
 |  |  |  |  |  |  |  |  | [NAME] | hadoop
 |  |  |  |  |  |  |  |  |  | word
 |  |  |  |  |  |  |  |  | sorup | ccna
 |  |  |  |  |  |  |  |  |  | ccnp
 |  |  |  |  |  |  |  |  | sruti | ppt
 |  |  |  |  |  |  |  |  |  | sap
Spreadsheet: 133279d1324313717-excel-2007-changing-the-month-daily-schedule
Sheet: Sheet2

(blank) | Approaching target
 | Biweekly Call
 | Chasing
 | [NAME]
 | Pru weekly cust report
 | Prudential Call
 | Quality Closure
 | Weekly Inputs
 | Weekly Trackers
(blank) Count
Mon                                         09:00 - 09:30 | Approaching target
 | Biweekly Call
 | Chasing
 | [NAME]
 | Pru weekly cust report
 | Prudential Call
 | Quality Closure
 | Weekly Inputs
 | Weekly Trackers
Mon                                         09:00 - 09:30 Count
Tue | Approaching target
 | Biweekly Call
 | Chasing
 | [NAME]
 | Pru weekly cust report
 | Prudential Call
 | Quality Closure
 | Weekly Inputs
 | Weekly Trackers
Tue Count
Fri | Approaching target
 | Biweekly Call
 | Chasing
 | [NAME]
 | Pru weekly cust report
 | Prudential Call
 | Quality Closure
 | Weekly Inputs
 | Weekly Trackers
Fri Count
Thu | Approaching target
 | Biweekly Call
 | Chasing
 | [NAME]
 | Pru weekly cust report
 | Prudential Call
 | Quality Closure
 | Weekly Inputs
 | Weekly Trackers
Thu Count
Wed | Approaching target
 | Biweekly Call
 | Chasing
 | [NAME]
 | Pru weekly cust report
 | Prudential Call
 | Quality Closure
 | Weekly Inputs
 | Weekly Trackers
Wed Count
Grand Total
Spreadsheet: 847778d1698656319-conditional-formatting-with-percentages-conditionalformattingtest
Sheet: Sheet1

Supplier | Item Number | Item Name | Description | Units Ordered | Items per Unit | Number Units on B/O | Item Quantity In Stock | Unit Price | Per | Date Last  Ordered | Total
ABC Supplier | ABC 123 | DiaryJoe | [NAME] | 1 | 30 | 0 | 1 | 600 | Each | 2023-09-08 00:00:00
ABC Supplier | ZXY456 | [NAME] | Blue ink Pens | 1 | 17 | 0 | 15 | 80 | Each | 2023-09-08 00:00:00
Spreadsheet: 455526d1460385393-sumproduct-with-sum-if-dual-formula-oeldere-pt-455522d1460383863-sumproduct-with-sum-if-dual-formula-delete-test
Sheet: pivottable

Aantal van location | Kolomlabels
Rijlabels | Multi | Single | Eindtotaal
10504 | 0.5789473684210527 | 0.4210526315789473 | 1
26096 | 0.6428571428571429 | 0.3571428571428572 | 1
27866 | 0.5301204819277109 | 0.4698795180722892 | 1
30176 | 0.68 | 0.32 | 1
33579 | 0.4666666666666667 | 0.5333333333333333 | 1
33982 | 0.7040816326530612 | 0.2959183673469388 | 1
34533 | 0.3815789473684211 | 0.618421052631579 | 1
34888 | 0.5942857142857143 | 0.4057142857142857 | 1
35383 | 0.5757575757575758 | 0.4242424242424243 | 1
36898 | 0.6376811594202898 | 0.3623188405797101 | 1
39235 | 0.6041666666666666 | 0.3958333333333333 | 1
Eindtotaal | 0.5889328063241107 | 0.4110671936758893 | 1
Spreadsheet: 62607d1263508894-conditional-sum-doubt
Sheet: data

Date | year | month | term | country | amount | 0= observation to sum latest row with a "1"
2009-06-01 00:00:00 | 2009 | 6 | 2 | Ukraine | 2516139 | 1 | 2516139
2009-06-01 00:00:00 | 2009 | 6 | 2 | South Korea | 111439681 | 1 | 111439681
2009-05-29 00:00:00 | 2009 | 5 | 2 | South Korea | 105012675 | 1 | 105012675
2009-05-28 00:00:00 | 2009 | 5 | 2 | Malaysia | 168274624 | 1 | 1421746599
2009-05-28 00:00:00 | 2009 | 5 | 2 | Malaysia | 170927997 | 0
2009-05-28 00:00:00 | 2009 | 5 | 2 | Malaysia | 170927997 | 0
2009-05-28 00:00:00 | 2009 | 5 | 2 | Malaysia | 170927997 | 0
2009-05-28 00:00:00 | 2009 | 5 | 2 | Malaysia | 185171996 | 0
2009-05-28 00:00:00 | 2009 | 5 | 2 | Malaysia | 185171996 | 0
2009-05-28 00:00:00 | 2009 | 5 | 2 | Malaysia | 185171996 | 0
2009-05-28 00:00:00 | 2009 | 5 | 2 | Malaysia | 185171996 | 0
2009-05-28 00:00:00 | 2009 | 5 | 2 | South Korea | 63399731 | 1 | 63399731
2008-10-13 00:00:00 | 2008 | 10 | 4 | South Korea | 53441438 | 1 | 53441438
2008-10-10 00:00:00 | 2008 | 10 | 4 | China | 3427624779 | 1 | 3427624779
2008-10-10 00:00:00 | 2008 | 10 | 4 | Malaysia | 38580798 | 1 | 84306188
2008-10-10 00:00:00 | 2008 | 10 | 4 | Malaysia | 45725390 | 0
2008-10-10 00:00:00 | 2008 | 10 | 4 | South Korea | 72265039 | 1 | 72265039
2008-10-09 00:00:00 | 2008 | 10 | 4 | Hungary | 134401067 | 1 | 134401067
2008-10-09 00:00:00 | 2008 | 10 | 4 | South Korea | 108164237 | 1 | 108164237
2008-10-08 00:00:00 | 2008 | 10 | 4 | China | 2639296188 | 1 | 2639296188
Spreadsheet: tracy_geaccone__40405__2001_NNG-Reserves
Sheet: Reserves

NORTHERN NATURAL GAS COMPANY
Reserve Activity By Month, 2001
Transport Revenue Reserve  SAP acct. 30700000
 |  |  | Reserved
Shipper | Description |  | @  12/31/00 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
Utilicorp | Reserve of settlement payment due in October |  | -200000 |  | -100000 | -100000 | -100000 | -100000 | -100000 | -100000 | -100000 | -100000 | -100000 | -100000
Utilicorp | In April '01, Reverse Reserves for the amount of the Utilicorp |  | -548211 |  | -46669.34 | 0
 | Write off in April.  The Bal of $98,496 is related to the CCI
 | LTV bankruptcy
Utilicorp | October DDVC |  | -82748 |  | 0
UCU-CCI 22585 | Seasonal rate issue (paid) |  | -144542 |  | 0 |  |  | 144542
Wisconsin Gas | PPA reserve-outstanding receivables related to out-of-balance, |  | -133450 |  | 0 | 133450
 | DDVC's, finance charges.                                                                               Remaining balance paid-reverse in April |  |  |  |  | -65000 |  | 65000
Reliant | November production month DDVC's |  | -183538 |  | 122810
 | January - Reverse for Transcanada $48k & UCU $75k (paid)
NSP-M 107081 | Northfield/Fairbault facility sale (paid) |  | -420000 |  | 0 |  |  | 420000
Mobil 6324/78739 | Reservation invoiced at max rates for deliveries made to alternate pts. (PPA for ($235,000) issued in March, reverse reserve when remainder paid) |  | 0 |  | -493038 |  |  |  |  | 493038
Transco 74038 | May-Dec PPA  (paid) |  |  |  |  | -231000 |  | 231000
BP Amoco 80457 | Jan & Feb TI commodity (booked in Feb & Mar)  invoiced at max rate as discount was not requested,                                                                                        paid - reverse in April |  |  |  |  | -135485 | -98000
Terra 104684 | Dec 00 and Feb 01 reservation-invoiced [NAME] rate for deliveries made to alternate pts. |  |  |  |  | -176000 | -171218 |  |  |  | 347218
Reliant/MGO 107027 | Feb reservation-invoiced [NAME] rate for deliveries made to alternate pts., paid |  |  |  |  | -59000 |  | 59000
Reliant Energy Retail 103104 | Dec 00, $134,000 and Jan 01 ($47,000) DDVC's (Nov DDVC's included above),                                                                                                    PPA issued for Jan $47,000-reverse in April |  |  |  |  | -181378 |  | 47000
Nicor | In April '01 Market Services billed a PPA for [NAME] rates on alternate points.  The full invoice amount was reserved. |  |  |  |  |  |  | -836473
Mid American | In April '01 Market Services billed a PPA for [NAME] rates on alternate points.  The full invoice amount was reserved. |  |  |  |  |  |  | -583444
Mid American | In August '01 Market Services billed a PPA for [NAME] rates on alternate points.  The full invoice amount was reserved.
SLA Refund Reserve SAP Acct #30600000 |  |  | 0 |  |  | -138925.27 | -144294.52 | -85615 | -64944.67 | -295504.5 | -246890.57 | -245052 | -255853 | -226676.58
Spreadsheet: b5059b7c-0b6a-42df-b41a-b851a650e79b
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Distance Education | 1 | Identify district and campus level infrastructure needs | None | -- Pick One --
Distance Education | 2 | Integrate online student services into DE and traditional courses | None | -- Pick One --
Distance Education | 1 | Develop Staffing Matrix | None | -- Pick One -- | 2.1.r1 | Recruit & hiring of DE staff | OnGoing | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Distance Education | 1 | Identify potential services that can meet the DE constituents' needs | None | -- Pick One --
Distance Education | 2 | Integrate technology that support DE strategic vision | None | -- Pick One --
Distance Education | 1 | Identify training opportunities for DE Faculty and Staff | None | -- Pick One --
Distance Education | 1 | Professional development plan for DE faculty & staff | None | -- Pick One --
Distance Education | 1 | Develop web-based training modules | None | -- Pick One -- | 4.3.r1 | Software | OneTime | 3600 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Distance Education | 1 | Develop web-based training modules | None | -- Pick One -- | 4.3.r2 | Hardware | OneTime | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Distance Education | 2 | Identify training areas related to DE | None | -- Pick One --
Distance Education | 3 | Create training plan for DE staff | None | -- Pick One -- | 5.2.r1 | Training funds | OnGoing | 7000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 22707d1211859324-doubt-in-macro-try-to-group-rows-music
Sheet: indi pop

artists | albums | song 1 | song 2 | song 3 | song 4 | song 5 | song 6 | song 7 | song 8 | song 9 | song 10 | song 11 | song 12 | song 13 | song 14
 |  | download fomr net -> @
 |  | buy -> $
[NAME]
[NAME]
 | boondein ($)
Spreadsheet: 830595d1685000402-combining-subtotal-lookup-and-if-or-alternative-to-lookup-that-can-be-out-of-order-staff-work-allocations
Sheet: Sheet1

 |  |  |  | Job Allocations
 |  |  |  |  | Technician
 |  |  |  | Task | HIDDEN | AM | HIDDEN | PM | HIDDEN | N
 |  |  | 1 | Autoclaves
 |  |  |  | Wrapping
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | [NAME]
 |  |  |  | Booking On |  |  |  |  |  |  |  |  |  |  | 45000 | [NAME]
 |  |  | 2 | [NAME] |  |  |  |  |  |  |  |  |  |  | 45046 | [NAME]
 |  |  |  | Supps |  |  |  |  |  |  |  |  |  |  | 45046 | [NAME]
 |  |  |  | Clean |  |  |  |  |  |  |  |  |  |  | 45058 | peppa SHARP
 |  |  |  | Clean |  |  |  |  |  |  |  |  |  |  | 45062 | [NAME]
 |  |  |  | Clean |  |  |  |  |  |  |  |  |  |  | 45069 | Prince SHAJI
 |  |  |  | Clean
 |  |  |  | Clean
 |  |  |  | Clean
 |  |  |  | Clean
 |  |  |  | Clean
 |  |  |  | Clean
 |  |  |  | Clean
 |  | Training - Porter
 |  | Training - Autoclaves
Spreadsheet: 171472d1343747431-sum-column-look-up-weekly-sales
Sheet: Sheet1

 |  |  | lw | pw |  |  |  | lw | pw
 |  | 5 | 8 | 10 | 55 | 60
 |  | 9 | 50 | 12 | 33 | 40
 |  | 6 | 6 | 85 | 21 | 12
 |  | 3 | 3 | 10 | 10 | 10
Spreadsheet: 677464d1589369599-need-help-with-an-roi-calculator-roi_calculator_excel_forum
Sheet: Annual ROI

[NAME] ROI ANNUAL CALCULATOR | Month 1 | Month 2 | Month 3
Machining Value | 78000 | 156000 | 234000
Verification Costs | 5000 | 10000 | 15000
Tooling Costs | 25000 | 50000 | 75000
Total Manufacturing Costs (TODAY) | 108000 | 216000 | 324000
CGTech Savings
Verification Costs | 5000 | 10000 | 15000
Prove-Out Reduction | 7800 | 15600 | 23400
Machining Time Reduction | 7800 | 15600 | 23400
Tooling Savings | 7500 | 15000 | 22500
Total Savings | 28100 | 56200 | 84300
NEW VERICUT MFG COSTS | 79900 | 159800 | 239700
CGTech Investment | 250000 | 0 | 0
ROI | -221900 | -193800 | -165700
 | So if ('VERICUT ROI Calculator'!C18) = 2 then the CGTech Savings (all rows from b7 to b12 move to [NAME] to D12 i.e. begin in Month 3 rather than 1 as it does now)
Spreadsheet: 757071d1637991809-what-formula-should-be-used-to-solve-the-questions-assignment-1-
Sheet: Sheet1

 | Order Date | Customer | Order Value |  | Please build the logic & calcuate the following :
 | 2019-12-01 00:00:00 | Customer1 | 100 |  | 1. Number of new users/ repeat users in each month
 | 2019-12-01 00:00:00 | Customer5 | 150 |  | 2. Number of new users/ repeat users in lifetime
 | 2020-01-01 00:00:00 | Customer2 | 80 |  | 3. Number of heavy customers
 | 2020-03-01 00:00:00 | Customer1 | 150 |  | 4. Number of active customers
 | 2020-03-01 00:00:00 | Customer2 | 150 |  | 6. Number Dormant customers
 | 2020-03-01 00:00:00 | Customer1 | 100
 | 2020-03-01 00:00:00 | Customer3 | 200 |  | Definitions :
 | 2020-01-25 00:00:00 | Customer4 | 200 |  | 1. New user in the month : Customer who has ordered at least once in that month
 | 2020-02-25 00:00:00 | Customer6 | 200 |  | 2. Repeat user in the month : Customer who has ordered more than once in that month
 | 2020-01-01 00:00:00 | Customer4 | 200 |  | 3. New user in lifetime : Unique customer in overall database
 | 2020-04-01 00:00:00 | Customer3 | 150 |  | 4. Repeat user in lifetime : Customer who has ordered more than once in lifetime
 | 2020-04-01 00:00:00 | Customer3 | 200 |  | 5. Heavy customer : Customer who has ordered more than once in last 90 days
 | 2020-04-01 00:00:00 | Customer4 | 200 |  | 6. Active customer : Customer who has ordered at least once in last 90 days
 |  |  |  |  | 7. Dormant customer : Customer who has not ordered in last 90 days
 | [NAME] for submission of answers
 | Month | # New customers in the month | # [NAME] customers in the month | # New customers lifetime | # [NAME] customers lifetime | # heavy customers in the month | # active customers in the month | # dormant customers in the month
 | Dec'19
 | Jan'20
 | Feb'20
 | Mar'20
 | Apr'20
Spreadsheet: 68158d1268713458-reports-in-excel-tracking_data
Sheet: FEEDBACK

Report
Name: | [NAME] 7
during this lesson I have done:
For my next lesson I need to do:
Spreadsheet: 67697d1268252638-multiple-validation-lists-forum
Sheet: Validation Info

Type |  | Type_1234567 | Type_1234568 | Type_1234569 | Type_1234570 | [NAME] | Type_1234572 | Type_1234573 | Type_1234574 | Type_1234575
Type_1234567 | 1234567 | abcde | [NAME] | klmno | abcde | klmno | abcde | [NAME] | abcde | [NAME]
Type_1234568 | 1234568
Type_1234569 | 1234569
Type_1234570 | 1234570
[NAME] | 1234571
Type_1234572 | 1234572
Type_1234573 | 1234573
Type_1234574 | 1234574