tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: gerald_nemec__11447__Project Cost and Projections thru August 31
Sheet: Sheet1

 |  |  | Approved | Work Orders | Work Orders | Work Orders | Work Orders |  | Work Orders
System Name | Account Number | System Number | Capital Cost | Capital Cost | Capital Cost | Capital Cost | Accrual for Materials |  | Estimate at
 |  |  | RAROC | Approved | Thru June 30th | 6-30 to 8-31 | not yet invoiced |  | Completion
House Creek | 11025 | 100 | 11944234 | 5151501 | 2930353 | 3200 | 5000 |  | 11944234
Caballo Lateral | 11026 | 200 | See Note 2 | 2511400 | 2703658 | 65000 | 10000 |  | 2800000
Caballo Compression | 11026 | 200 | 8062497 | 5740000 | 6498109 | 933000 | 40000 |  | 7750000
Clydesdale | 11027 |  | 3254256 | 3370675 | 933169 | 909000 | 750000 |  | 3254256
South Kitty | 11028 |  | 7462998 | 9413156 | 1500547 | 1441000 | 1500000 |  | 7462998
Hoe Creek | 11029 |  | 6735882 | 4661220 | 654157 | 131000 | 350000 |  | 6735882
[NAME] | 11030 | 400 | 6707026 | 7053775 | 7402549 | 218000 | 10000 |  | 7900000
Maverick | 11030 | 300 | 1650000 | See Note 1 | See Note 1 | See Note 1 | See Note 1 |  | See Note 1
Kudzu |  |  | 4729128 | 0 | 0 | 0 | 0 |  | 4729128
Fort Union Receipt Points |  |  | 676713 | 1194000 | 1104406 | 129000 | 10000 |  | 1300000
 |  | Grand Total =
Note 1:  All of Maverick's Capital cost is included in the Box Draw work order.
Note 2:  This cost was included in the Caballo Compression RAROC number.
Spreadsheet: 1bf3f4a9-fefc-4015-a72b-8a45642d74f2
Sheet: Reading

April 2012  BST Raw Score to Scale Score Tables
Reading
Raw Score | Scale Score
0 | 380
1 | 423
2 | 449
3 | 465
4 | 477
5 | 486
6 | 494
7 | 502
8 | 508
9 | 514
10 | 519
11 | 524
12 | 529
13 | 534
14 | 538
15 | 543
16 | 547
17 | 551
18 | 555
19 | 559
20 | 563
21 | 567
22 | 571
23 | 575
24 | 579
25 | 583
26 | 588
27 | 592
28 | 597
29 | 601
30 | 606
31 | 611
32 | 617
33 | 623
34 | 630
35 | 638
36 | 647
37 | 659
38 | 674
39 | 700
40 | 750
Spreadsheet: 101903d1299956582-template-sheets-setting-formulas-cashflow-copia
Sheet: CashFlow11

Cash Flow (2011) ('000)
 | jan | feb | [NAME] | apr | may | jun | jul | aug | sept | oct | nov | dec
Grants | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sales
Total Cash Inflow | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Payments
Wages
Advertising
Rent
Other overhead costs
Total Cash Outflow | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net cash flow | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Opening Balance
Closing Balance
Spreadsheet: 171475d1343748572-if-statement-false-then-look-in-next-cell-pt-names-by-date
Sheet: Detail

Name | Enrollment Month
 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00
 |  |  |  |  |  |  |  | Decoteau, [NAME]
 |  |  |  |  |  |  |  | Dempsey, Lindsey
 |  |  |  |  |  |  |  | Drago, [NAME]
 |  |  |  |  |  |  |  | Ellithorpe, [NAME]
Spreadsheet: 771855d1646880507-mortgage-effective-rate-formula-effective-interest-rate
Sheet: Sheet1

NO ADDITIONAL REPAYMENTS |  |  |  |  |  |  |  |  |  |  | WITH 500 PM ADDITIONAL REPAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BACKSOLVE INTEREST RATE FOR 30 YEAR LOAN ASSUMING SAME MONTHLY REPAYMENT
 | Month | Month of year | Year | Opening balance | Monthly Interest rate | Interest | Monthly repayment | Closing Balance |  |  |  | Month | Month of year | Year | Opening balance | Monthly Interest rate | Interest | Monthly repayment | Closing Balance |  |  | Repayment at mo |  |  |  | years |  |  | Month | Opening balance | Monthly Interest rate | Interest | Monthly repayment | Closing Balance | Cumulative interest repaid |  | Annual interst rate | 2.576921734800364 | % | <SOLVE FOR CELL AM2 = CELL [NAME]
 | 1 |  | 1 | 350000 |  |  | 1670.953534129113 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Interest Paid |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Interest Paid by end of year 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total principal paid
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAGR
Spreadsheet: 58447d1258674935-dates-in-a-pivot-table-707994-dates-in-a-pivot-table
Sheet: Sheet2

 | Sum of Days
 | Date From | Name | Total
 | Jan | [NAME] | 4
 |  | [NAME] | 4
 |  | [NAME] | 2
 |  | [NAME] | 2
 |  | [NAME] | 2
 | Jan Total |  | 14
 | Feb | [NAME] | 10
 |  | [NAME] | 10
 |  | [NAME] | 5
 |  | [NAME] | 5
 |  | [NAME] | 5
 | Feb Total |  | 35
 | Mar | [NAME] | 2
 |  | [NAME] | 2
 |  | [NAME] | 1
 |  | [NAME] | 1
 |  | [NAME] | 1
 | [NAME] |  | 7
 | Apr | [NAME] | 12
 |  | [NAME] | 7
 |  | [NAME] | 6
 |  | [NAME] | 6
 |  | [NAME] | 6
 | Apr Total |  | 37
 | May | [NAME] | 4
 |  | [NAME] | 4
 |  | [NAME] | 2
 |  | [NAME] | 2
 |  | [NAME] | 2
 | May Total |  | 14
 | Jun | [NAME] | 18
 |  | [NAME] | 18
 |  | [NAME] | 9
 |  | [NAME] | 9
 |  | [NAME] | 9
 | Jun Total |  | 63
Spreadsheet: ac33dc94-a47b-4c91-81c2-1da00d968076
Sheet: New  Table 17

Table 17
Weekly Port Region Grain Ocean Vessel Activity (number of vessels)
 |  |  |  | Pacific | Vancouver
 | Gulf |  |  | Northwest | B.C.
 |  | Loaded | Due next
Date | In port | 7-days | 10-days | In port | In port
2012 range | (13..50) | (13..46) | (27..78) | (4..20)
2012 avg. | 28 | 33 | 46 | 11 | n/a
Source:  Transportation & Marketing Programs/AMS/USDA
Spreadsheet: 327934d1403725530-formula-for-different-options-to-return-a-value-based-upon-the-selections-example
Sheet: Torque Calculator

 | Manual Torque Calculator
 | Tubular Size & Connection |  | Outside Diameter | Inside Diameter | [NAME] | Length Of Tongs |  | Single Line Pull (Ft./Lbs.) |  | Double Line Pull (Ft./Lbs.) |  | [NAME] (PSI)
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
Spreadsheet: 881993d1730230611-transform-data-from-one-sheet-to-other-book2-pivot-tables-
Sheet: pivot tables

SalesArea | All
 | Totals per salesman
ProdName | Salesman-01 | Salesman-03 | [NAME] | Salesman-07 | Salesman-08 | Salesman-12 | Salesman-17 | Salesman-20 | Salesman-21 | Salesman-25
Product 1 | 14 | 18 | 18 | 15 | 11 | 9 | 16 | 20 | 10 | 16
Product 2 | 35 | 28 | 28 | 41 | 37 | 35 | 36 | 32 | 23 | 32
Grand Total | 49 | 46 | 46 | 56 | 48 | 44 | 52 | 52 | 33 | 48
Count of SalesArea | where sold
Row Labels | Area 1 | Area 10 | Area 11 | Area 12 | Area 13 | Area 2 | Area 3 | Area 4 | Area 5 | Area 6 | Area 7 | Area 8 | Area 9 | Total Areas
Product 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  | 5
Product 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 13
Total Areas | 2 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 18
Spreadsheet: 127265d1320260312-daverage-with-no-headings-its-killing-my-head-pt-daverage-no-headings
Sheet: Sheet1

 | Tree | Height | Age | Profit |  | Tree | Profit |  | Tree | Age
 | Apple | 18 | 20 | 105 |  | Apple |  |  |  | >=9
 | Pear | 12 | 12 | 96 |  |  |  |  | Tree | Age
 | [NAME] | 13 | 14 | 105 |  | Pear |  |  |  | >=9
 | Apple | 14 | 15 | 75 |  |  |  |  | Tree | Age
 | Pear | 9 | 8 | 76.8 |  | [NAME] |  |  |  | >=9
 | Apple | 8 | 9 | 45 |  | Height | (Multiple Items)
 | Apple | 8 | 14 | 39
 | Pear | 3 | 10 | 47 |  | Row Labels | Average of Height | Average of Age | Average of Profit
 | [NAME] | 8 | 13 | 10 |  | Apple | 14.66666666666667 | 14 | 80
 | Apple | 12 | 7 | 60 |  | [NAME] | 12 | 8 | 75.5
 | Pear | 10 | 6 | 58 |  | Pear | 10.33333333333333 | 8.666666666666666 | 76.93333333333334
 | Apple | 8 | 10 | 23 |  | Grand Total | 12.375 | 10.5 | 77.725
 | Apple | 5 | 4 | 33
 | Pear | 8 | 3 | 26
 | [NAME] | 11 | 2 | 46
Spreadsheet: 719250d1613575656-seach-for-specific-text-and-return-results-search-and-return-forum
Sheet: Sheet1

CPT® Codes | PR Code
PR FRAGMENT KIDNEY STONE/ ESWL [50590] CHG RADIOLOGIC EXAM ABDOMEN 1 VIEW [74018] ASSAY QUANTITATIVE,BLOOD GLUCOSE [82947]
PR INSERT,INFLATABLE PENILE PROSTHESIS [54405] ASSAY QUANTITATIVE,BLOOD GLUCOSE [82947] PR Cath, drainage [C1729] PR Prosthesis, penile, inflatab [C1813]
PR INSERT,INFLATABLE PENILE PROSTHESIS [54405] ASSAY OF CREATININE [82565] CHG ASSAY OF SERUM POTASSIUM [84132] CHG HEMATOCRIT [85014] CHG HEMOGLOBIN [85018] PR ELECTROCARDIOGRAM, TRACING [93005] PR Cath, drainage [C1729] PR Prosthesis, penile, inflatab [C1813]
PR COLLECTION VENOUS BLOOD,VENIPUNCTURE [36415] CHG CT SCAN,ABDOMENT AND PELVIS,W/O CONTRAST [74176] CHG BASIC METABOLIC PANEL CALCIUM TOTAL [80048] CHG METABOLIC PANEL,COMPREHENSIVE [80053] CHG URINALYSIS, AUTO, W/SCOPE [81001] ASSAY OF LIPASE [83690] ASSAY OF MAGNESIUM [83735] CHG COMPLETE CBC & AUTO DIFF WBC [85025] CHG PROTHROMBIN TIME [85610] CHG THROMBOPLAS TIME PARTIAL [85730] CHG URINE CULTURE, COLONY COUNT [87086] PR IV INFUSION, HYDRATION, EA ADD HOUR [96361] PR INJECTION,THERAP/PROPH/DIAGNOST, IV PUSH, INITIAL DRUG [96374] PR INJECTION,THERAP/PROPH/DIAGNOST, IV PUSH, EA ADD, SAME DRUG [96376] PR PHYSICAL THERAPY EVALUATION LOW COMPLEX 20 MINS [97161] PR OCCUPATIONAL THERAPY EVAL MOD COMPLEX 45 MINS [97166] PR EMERGENCY DEPT VISIT HIGH SEVERITY & THREAT TO FUNCTION [99285] PR Stent, non-cor, tem w/o del [C2617]
PR CYSTO/URETERO/PYELOSCOPY, CALCULUS TX [52352] CHG CALCULUS ASSAY,INFRARED SPECTR [82365] PR Guide wire [C1769]
PR TRANSURETHRAL ELEC-SURG PROSTATECTOM [52601] ASSAY OF CREATININE [82565] CHG ASSAY OF SERUM POTASSIUM [84132] CHG HEMATOCRIT [85014] CHG HEMOGLOBIN [85018] CHG RBC ANTIBODY SCREEN [86850] CHG BLOOD TYPING SEROLOGIC ABO [86900] CHG BLOOD TYPING SEROLOGIC RH (D) [86901] CHG SURG PATH,LEVEL IV [88305] PR ELECTROCARDIOGRAM, TRACING [93005]
PR INSERTION PICC W/O IMG GDN 5 YR/> [36569] PR US GUIDE, VASCULAR ACCESS [76937] CHG BASIC METABOLIC PANEL CALCIUM TOTAL [80048] ASSAY OF GENTAMICIN [80170] ASSAY OF LACTIC ACID [83605] CHG COMPLETE CBC & AUTO DIFF WBC [85025] CHG PROTHROMBIN TIME [85610] CHG BLOOD CULTURE FOR BACTERIA [87040] CHG BACTERIA IDENTIFICATION, AEROBIC ISOLATE [87077] CHG ANTIBIOTIC SENS,MIC,EACH [87186] CHG IAAD IA HIV-1 AG W/HIV-1 & HIV-2 ANTBDY SINGLE [87389] CHG SURG PATH,LEVEL IV [88305] CHG IMHISTOCHEM/CYTCHM EA MULTIPLEX ANTIBODY SLIDE [88344] PR CHEST WALL MANIPULATION,INITIAL [94667] PR CHEST WALL MANIPULATION,SUBSEQUENT [94668] PR [NAME], inf, per/cent/midline [C1751]
PR INSTILL ANTICANCER AGENT IN BLADDER [51720] PR CYSTOURETHROSCOPY,FULGUR 2-5CM LESN [52235] ASSAY OF CREATININE [82565] CHG ASSAY OF SERUM POTASSIUM [84132] CHG HEMATOCRIT [85014] CHG SURG PATH,LEVEL V [88307] PR ELECTROCARDIOGRAM, TRACING [93005] PR Cath, drainage [C1729]
HC PROSTHETIC IMPLANT, NOS [27800081]
Spreadsheet: 788290d1658385780-split-data-with-filter-xml-function-xml-filter-different-result
Sheet: Blad1

original | subsstring 1 | subsstring 2 | subsstring 3 | subsstring 4 | subsstring 5 | subsstring 6 | subsstring 7
10,20,30,40,50,60,70
15,20,30,40,50,60,71
10,20,30,40,50,60,72
10,20,30,40,50,60,73
10,20,30,40,50,60,74
16,20,30,40,50,60,75
10,20,30,40,50,60,76
10,20,30,40,50,60,77
10,20,30,40,50,60,78
10,20,30,40,50,60,79
Spreadsheet: 97703d1296815296-sumproduct-generating-value-error-book1
Sheet: SUMPRODUCT

Data Item | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00
CARP | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
TUNA | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
PERCH | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
BASS | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
TROUT | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 201524d1356019631-match-either-of-two-criteria-not-both-standard-deviation-from-an-array-example
Sheet: Sheet1

Criteria column |  | Data column 1 | Data column 2 | Data column 3 | Data column 4 | Data column 5 | Data column 6 | Data column 7 | Data column 8 | Data column 9 | Data column 10 |  | Standard Deviation attemps
5 |  | 17 | 55 | 100 | 95 | 12 | 78 | 70 | 62 | 36 | 9 |  | Desired criteria to match |  |  |  | Standard deviation of rows meeting criteria
6 |  | 38 | 43 | 68 | 41 | 27 | 35 | 5 | 54 | 93 | 98 |  | 3 | 4
6 |  | 8 | 33 | 86 | 42 | 66 | 29 | 20 | 75 | 32 | 98 |  | 5 | 6 | 7
12 |  | 76 | 43 | 41 | 10 | 33 | 9 | 30 | 25 | 76 | 60 |  | 8 | 9 | 10
10 |  | 61 | 63 | 42 | 50 | 11 | 8 | 10 | 15 | 85 | 37
7 |  | 53 | 0 | 29 | 96 | 40 | 55 | 75 | 94 | 66 | 29
11 |  | 39 | 23 | 29 | 69 | 24 | 87 | 1 | 75 | 26 | 24
10 |  | 30 | 65 | 24 | 10 | 32 | 59 | 87 | 88 | 7 | 82
12 |  | 62 | 42 | 19 | 38 | 64 | 85 | 99 | 59 | 61 | 30
5 |  | 18 | 45 | 0 | 61 | 91 | 61 | 23 | 100 | 28 | 19
11 |  | 32 | 79 | 25 | 55 | 33 | 92 | 8 | 44 | 33 | 12
9 |  | 86 | 74 | 12 | 77 | 20 | 92 | 61 | 47 | 35 | 95
3 |  | 73 | 4 | 13 | 93 | 3 | 73 | 78 | 95 | 35 | 5
10 |  | 69 | 32 | 23 | 21 | 38 | 90 | 53 | 50 | 66 | 12
7 |  | 81 | 24 | 93 | 100 | 7 | 20 | 100 | 77 | 4 | 81
5 |  | 10 | 50 | 82 | 100 | 39 | 4 | 49 | 4 | 15 | 5
14 |  | 73 | 82 | 17 | 76 | 93 | 46 | 41 | 38 | 8 | 2
8 |  | 72 | 18 | 41 | 24 | 25 | 83 | 8 | 19 | 55 | 36
2 |  | 17 | 62 | 62 | 19 | 81 | 55 | 23 | 20 | 61 | 71
1 |  | 89 | 66 | 39 | 19 | 99 | 59 | 43 | 60 | 25 | 67
7 |  | 77 | 89 | 77 | 80 | 30 | 78 | 70 | 82 | 100 | 58
11 |  | 36 | 8 | 25 | 55 | 60 | 63 | 19 | 49 | 88 | 76
8 |  | 75 | 45 | 41 | 84 | 78 | 82 | 12 | 19 | 65 | 68
5 |  | 88 | 64 | 89 | 74 | 44 | 94 | 4 | 29 | 14 | 76
13 |  | 45 | 12 | 53 | 61 | 22 | 16 | 79 | 84 | 92 | 50
3 |  | 75 | 14 | 48 | 0 | 83 | 64 | 82 | 98 | 54 | 19
5 |  | 89 | 38 | 14 | 92 | 39 | 90 | 90 | 37 | 3 | 41
12 |  | 90 | 75 | 70 | 56 | 5 | 4 | 12 | 48 | 45 | 29
1 |  | 76 | 73 | 89 | 38 | 23 | 89 | 75 | 63 | 24 | 11
14 |  | 60 | 78 | 53 | 67 | 94 | 7 | 15 | 93 | 44 | 9
Spreadsheet: 56203d1256297230-display-alphabet-before-numeric-sorting
Sheet: Sheet1

Original | Ending Result | Instead of
3 | a | 2
2 | e | 3
9 | f | 3
6 | g | 6
3 | h | 9
a | k | a
g | 2 | e
e | 3 | f
f | 3 | g
h | 6 | h
k | 9 | k
 | How to get Excel sort alpha first then numeric
Spreadsheet: 672954d1587089150-subtractct-lunch-time-time-correction-issues
Sheet: Sheet1

 |  |  |  |  | Correct Result
works perfect | 07:00:00 | 15:30:00 | 0.5 |  | 8
way it currently is | 20:00:00 | 08:00:00 | 0.5 |  | 11.5
My thought to change in column E but still incorrect result | 20:00:00 | 08:00:00 | 0.5
Way it currently is | 18:00:00 | 00:00:00 |  |  | 6
But my corection | 18:00:00 | 00:00:00
Spreadsheet: 741c6b86-8d88-42b9-a8d7-2418bc328e3a
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of Nov. 2 - Nov. 6
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um | 1um | 1.6um | 3um
SVG                         Coater | Date (Coat) | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4
 | Oven Program | 1 | 2 | 3 | 1 | 2 | 3
 | Problems
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 | - | - | -
 | Top (A) | 10060 | 16715 | 73045 | 10246 | 17011 | 30230 | - | - | -
 | Center (A) | 10046 | 16715 | 73014 | 10208 | 16994 | 30166 | - | - | -
 | Flat (A) | 10038 | 16742 | 73390 | 10233 | 17006 | 30206 | - | - | -
 | Left  (A) | 10042 | 16696 | 73128 | 10246 | 16997 | 30164 | - | - | -
 | Right (A) | 10057 | 16722 | 73298 | 10221 | 17013 | 30187 | - | - | -
 | Average (A) | 10048.6 | 16718 | 73175 | 10230.8 | 17004.2 | 30190.6 | - | - | -
 | [NAME]  (A) | 9.528903399500898 | 16.53783540854123 | 163.0828010551695 | 16.45296325902967 | 8.408329203122287 | 27.90698837123627 | - | - | -
 | Comments |  |  | not uniform
Exposure | Date (Exposure) | 2009-11-05 00:00:00 | 2009-11-05 00:00:00 | 2009-11-05 00:00:00 | 2009-11-05 00:00:00 | 2009-11-05 00:00:00 | 2009-11-05 00:00:00
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | EValign | EValign | EValign
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 1.0s | 1.3s | 2.9s x2 | 0.9s | 1.4s | 2.3s
 | Problems
SVG                            Developer | Date (Develop) | 2009-11-05 00:00:00 | 2009-11-05 00:00:00 | 2009-11-05 00:00:00 | 2009-11-05 00:00:00 | 2009-11-05 00:00:00 | 2009-11-05 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7
 | Post-base Program | 1 | 2 | none | 1 | 2 | none
 | Problems
Resolution                         Measurements | Date (Measurement) | 2009-11-05 00:00:00 | 2009-11-05 00:00:00 | 2009-11-05 00:00:00 | 2009-11-05 00:00:00 | 2009-11-05 00:00:00 | 2009-11-05 00:00:00
 | Top (H/V) (um) | 1/1.5 | 1/1.5 | 2/2 | 1/1 | 1.5/1.5 | 1.5/1.5
 | Center (H/V) (um) | 1/1 | 1/1.5 | 2/2.5 | 1/1.5 | 1/1.5 | 1.5/2
 | Flat (H/V) (um) | 1/1 | 1/1.5 | 2/2.5 | 1/1 | 1/1.5 | 1.5/1.5
 | Left (H/V) (um) | 1/1 | 1/1.5 | 2/2.5 | 1/1.5 | 1.5/1.5 | 1.5/2
 | Right (H/V) (um) | 1/1 | 1/1.5 | 2/2.5 | 1/1 | 1/1.5 | 1/1.5
 | Comments | 1s darkfield  0.9s lightfield | 1.3-1.4s darkfiled | 3.3x2 - 3.4x2 dardfield | 0.9 darkfield 0.7-0.6 lightfield | 1.4 darkfield | 2.3 darkfield
Spreadsheet: 805921d1669014419-helper-column-and-vlookup-project-calendar-2-
Sheet: Project

Team | Task No. | Task / Milestone | Dependent On Task No. | End Date of Dep. Task | Task Owner | Start Date | Duration in Days | End Date
L2O | 1 | Identification of team members on Our side |  |  |  | 2022-11-18 00:00:00 | 5
L2O | 2 | Identification of team members on Client side
L2O | 3 | Acknowledgement/acceptance of role and tasks by our team members |  | IFERROR((VLOOKUP(D4,$B$2:B$501,$I$2:$I$501,(…)),0)
L2O | 4 | Acknowledgement/acceptance of role and tasks by our team members
L2O | 5 | Schedule project kick-off call with our and client Members
L2O | 6 | Project Kickoff and Walkthrough of major milestones and upcoming tasks/milestones
L2O | 7 | Send out training invites
L2O | 8 | Tool 1 Introduction and Training to Instructors & Client Team Members
L2O | 9 | Tool 2 Introduction and Training to Instructors & Client Team Members
L2O | 10 | Tool 3 Introduction and Training to Instructors & Client Team Members
L2O | 11 | Discovery session for Tool 1
L2O | 12 | Discovery session for Tool 2
L2O | 13 | Discovery session for Tool 3
L2O | 14 | Walkthrough of Data Templates
L2O | 15 | Confirmation of Understanding of Data Templates by Client Team Members
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
 | 101
 | 102
 | 103
 | 104
 | 105
 | 106
 | 107
 | 108
 | 109
 | 110
 | 111
 | 112
 | 113
 | 114
 | 115
 | 116
 | 117
 | 118
 | 119
 | 120
 | 121
 | 122
 | 123
 | 124
 | 125
 | 126
 | 127
 | 128
 | 129
 | 130
 | 131
 | 132
 | 133
 | 134
 | 135
 | 136
 | 137
 | 138
 | 139
 | 140
 | 141
 | 142
 | 143
 | 144
 | 145
 | 146
 | 147
 | 148
 | 149
 | 150
 | 151
 | 152
 | 153
 | 154
 | 155
 | 156
 | 157
 | 158
 | 159
 | 160
 | 161
 | 162
 | 163
 | 164
 | 165
 | 166
 | 167
 | 168
 | 169
 | 170
 | 171
 | 172
 | 173
 | 174
 | 175
 | 176
 | 177
 | 178
 | 179
 | 180
 | 181
 | 182
 | 183
 | 184
 | 185
 | 186
 | 187
 | 188
 | 189
 | 190
 | 191
 | 192
 | 193
 | 194
 | 195
 | 196
 | 197
 | 198
 | 199
 | 200
 | 201
 | 202
 | 203
 | 204
 | 205
 | 206
 | 207
 | 208
 | 209
 | 210
 | 211
 | 212
 | 213
 | 214
 | 215
 | 216
 | 217
 | 218
 | 219
 | 220
 | 221
 | 222
 | 223
 | 224
 | 225
 | 226
 | 227
 | 228
 | 229
 | 230
 | 231
 | 232
 | 233
 | 234
 | 235
 | 236
 | 237
 | 238
 | 239
 | 240
 | 241
 | 242
 | 243
 | 244
 | 245
 | 246
 | 247
 | 248
 | 249
 | 250
 | 251
 | 252
 | 253
 | 254
 | 255
 | 256
 | 257
 | 258
 | 259
 | 260
 | 261
 | 262
 | 263
 | 264
 | 265
 | 266
 | 267
 | 268
 | 269
 | 270
 | 271
 | 272
 | 273
 | 274
 | 275
 | 276
 | 277
 | 278
 | 279
 | 280
 | 281
 | 282
 | 283
 | 284
 | 285
 | 286
 | 287
 | 288
 | 289
 | 290
 | 291
 | 292
 | 293
 | 294
 | 295
 | 296
 | 297
 | 298
 | 299
 | 300
 | 301
Spreadsheet: 705050d1605866973-sumproduct-and-sumifs-not-working-sumproduct_sumifs_not_working
Sheet: Sheet1

 | COUNTRY | NEPAL |  | MYANMAR |  | VIETNAM |  | PHILIPPINES |  | INDONESIA |  | PAKISTAN |  | SRI LANKA
 |  | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved
 | 2020-01-01 00:00:00 | 694.8960137057611 | 215.6752954439545 | 274.7787248910867 | 637.1433028998392 | 564.6816963053957 | 397.6108687717262 | 246.6640669530347 | 533.5605376334046 | 697.7272512143428 | 923.4205349677248 | 711.8346185913869 | 609.4200310695336 | 84.55024808903877 | 779.285297345873
 | 2020-02-01 00:00:00 | 890.7940231650996 | 302.5228903893307 | 467.5268972632076 | 571.9839237822 | 478.728306545803 | 918.0485165179174 | 631.1037468758819 | 134.2056550996007 | 721.273609111994 | 998.469447686961 | 454.2345763212596 | 631.6066333636641 | 715.0647963782396 | 463.4760761087131
 | 2020-03-01 00:00:00 | 602.8532440417508 | 682.7647905569164 | 512.3181669339357 | 335.3825565220416 | 783.2822441846869 | 698.4874980308531 | 812.1357045632672 | 536.2773202687523 | 77.50165197377967 | 993.8243298348209 | 257.3586879067382 | 523.3896729685492 | 652.4690062031548 | 657.2230539888357
 | TOTAL | 362.0736066115512 | 754.0544969220338 | 26.86446165442802 | 33.68476983224722 | 564.9861309432572 | 549.1906885774893 | 86.13092708378811 | 712.0216991072407 | 745.1516764159229 | 119.7723176814866 | 241.1025550183488 | 723.3170174755123 | 392.0710724613117 | 921.6381525584862
 |  |  | SUMPRODUCT
 |  |  | Achieved | Unachieved
 |  | MYANMAR
 |  | VIETNAM
 |  | PHILIPPINES
 |  | INDONESIA
 |  | PAKISTAN
 |  | SRI LANKA
 |  |  | Sum
 |  |  | Achieved | Unachieved
 |  | MYANMAR
 |  | VIETNAM
 |  | PHILIPPINES
 |  | INDONESIA
 |  | PAKISTAN
 |  | SRI LANKA
 | COUNTRY | NEPAL |  | MYANMAR |  | VIETNAM |  | PHILIPPINES |  | INDONESIA |  | PAKISTAN |  | SRI LANKA
 |  | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved
 |  | Enterprise 1:2 | Enterprise 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2
 | 2020-01-01 00:00:00
 | 2020-02-01 00:00:00
 | 2020-03-01 00:00:00
 | TOTAL