tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 059ad0ff-b051-4d57-b070-824157fb81cd
Sheet: State_Averages

Public Report Summary - Full Time Only
State Level
School Year: 2012 - 2013
Snapshot Date: Oct 22, 2012
Totals are provided for each category. The first column contains the category total, the second is the [NAME] (F) subtotal; the third is the Male (M) subtotal. | All Professional  Personnel |  |  | Administrators |  |  | Classroom  Teachers |  |  | Coordinators |  |  | Other |  |  | Full-Time Average Salaries  by Category |  |  |  |  | Average Total Years  of Service |  |  |  |  | Average Years of Service  in LEA |  |  |  |  | Average Level  of Education
 | PP | PP-F | PP-M | Ad | Ad-F | Ad-M | CT | CT-F | CT-M | Co | Co-F | Co-M | Ot | Ot-F | Ot-M | Sal-PP | Sal-Ad | Sal-CT | Sal-Co | Sal-Ot | Svc-PP | Svc-Ad | Svc-CT | Svc-Co | Svc-Ot | LEA-PP | [NAME] | LEA-CT | LEA-Co | [NAME] | Ed-PP | [NAME] | Ed-CT | Ed-Co | [NAME]
 | 146076 | 105836 | 40250 | 7100 | 3477 | 3623 | 120367 | 87694 | 32680 | 15400 | 12730 | 2672 | 7725 | 5081 | 2646 | 65367.709196 | 99704.296869 | 63218.00735 | 67886.905828 | 67272.310568 | 13.524481132579 | 18.379677754677 | 13.207384142294 | 14.097554562187 | 13.524078624078 | 11.721271158349 | 11.442827442827 | 11.712670263024 | 11.946147778069 | 11.620024570024 | 4.535232728478 | 5.016632016632 | 4.494569324073 | 4.746936628977 | 4.345823095823
May 30, 20132:56:29 PM |  |  |  |  |  |  |  |  |  |  |  | - 3 - |  |  |  |  |  |  |  |  |  |  |  |  | www.pimsreports.state.pa.us
Spreadsheet: 158446d1338246708-is-this-possible-reading-data-exception-tracking-2012
Sheet: July by Shift

AUDIT DESCREPANCIES BY SHIFT JULY
 | JULY
AUDIT DESCREPANCIES / EXCEPTIONS | DAY | SWING | GRAVE
Illegible or missing signature/ badge number
Any void not completed properly
Improper Error Corrections
Inconsistent Key Return
Incorrect/ Missing Information/ Totals
Missing Time Stamp/ Manual Date
Paperwork not received in Audit
Compliance Exceptions
Totals
Total Audit Exceptions
Total Compliance Exceptions
THESE ARE THE AUDIT DISCREPANCIES RECEIVED IN JULY!
THE GOAL FOR AUGUST IS A 10% REDUCTION. |  |  |  | AUGUST GOAL
Spreadsheet: 233312d1367741776-data-validation-can-i-show-additional-comments-training-matrix
Sheet: Sheet1

1 | Knows how to turn the machine on |  |  |  |  |  |  | 1
2 | Test 2 |  |  |  |  |  |  | 1
3 | Test 3 |  |  |  |  |  |  | 1
4 | Test 4 |  |  |  |  |  |  | 2
5 | Test 5 |  |  |  |  |  |  | 2
6 | Test 6 |  |  |  |  |  |  | 2
7 | Test 7 |  |  |  |  |  |  | 3
8 | Test 8 |  |  |  |  |  |  | 3
9 | Test 9 |  |  |  |  |  |  | 3
10 | Test 10 |  |  |  |  |  |  | 4
11 | Test 11 |  |  |  |  |  |  | 4
12 | Test 12 |  |  |  |  |  |  | 4
13 | Test 13 |  |  |  |  |  |  | 5
14 | Test 14 |  |  |  |  |  |  | 5
15 | Test 15 |  |  |  |  |  |  | 5
16 | Test 16 |  |  |  |  |  |  | 5
17 | Test 17 |  |  |  |  |  |  | 5
18 | Test 18 |  |  |  |  |  |  | 5
19 | Test 19 |  |  |  |  |  |  | 5
20 | Test 20 |  |  |  |  |  |  | 5
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
 | Items with no knowledge |  |  |  |  |  |  |  | 0
 | Items with poor knowledge |  |  |  |  |  |  |  | 1
 | Items with fair knowledge |  |  |  |  |  |  |  | 2
 | Items with good knowledge |  |  |  |  |  |  |  | 3
 | Items with excellent knowledge |  |  |  |  |  |  |  | 4
 | Items with training knowledge |  |  |  |  |  |  |  | 5
 | Number of items used in this sheet |  |  |  |  |  |  |  | 5
 | Knowledge in this machine
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-09-P-0053

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-09-P-0053 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: b5e42089-f63a-4351-8cfc-513c59e89285
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Elbe-Röder-Dreieck - Variante 2
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 3479 | 3600 | 3419 | 3005
20 - 60 | 14612 | 12706 | 10743 | 9119
60 und mehr | 8521 | 8878 | 9401 | 9741
Insgesamt | 26612 | 25184 | 23563 | 21865
%
unter 20 | 13.07304975199158 | 14.29479034307497 | 14.51003692229343 | 13.74342556597302
20 - 60 | 54.907560499023 | 50.45266836086404 | 45.59266646861605 | 41.70592270752344
60 und mehr | 32.01938974898543 | 35.25254129606099 | 39.89729660909052 | 44.55065172650355
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 23.8091979195182 | 28.33307099008342 | 31.82537466257098 | 32.95317469020726
Altenquotient | 58.31508349301944 | 69.87250118054462 | 87.50814483849949 | 106.8209233468582
Gesamtquotient | 82.12428141253764 | 98.20557217062806 | 119.3335195010705 | 139.7740980370655
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: d8ffbbea-f151-49f4-b1dc-3afbfe5769a8
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
42262716 | 2014-07-12 03:06:39 | AXIS | 1 | 6 | 5 | 580599 | Daign | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
42262912 | 2014-07-12 03:25:40 | ALLIES | 1 | 6 | 4 | 580599 | Daign | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
42263144 | 2014-07-12 03:56:18 | ALLIES | 1 | 6 | 4 | 496337 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42263325 | 2014-07-12 04:15:19 | AXIS | 1 | 6 | 3 | 496337 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42269110 | 2014-07-12 15:11:21 | ALLIES | 0 | 2 | 6 | 386133 | jskimming | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
42269297 | 2014-07-12 15:33:31 | AXIS | 1 | 6 | 5 | 386133 | jskimming | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
42371770 | 2014-07-20 00:34:21 | ALLIES | 1 | 6 | 2 | 706396 | Intello | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
42371912 | 2014-07-20 00:54:55 | AXIS | 1 | 6 | 2 | 706396 | Intello | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
Spreadsheet: 173894d1344845949-find-the-earliest-date-in-the-column-match2
Sheet: Sheet1

Reservation No. | CODE | DEPARTURE DATE | MEMBERSHIP NO | LEVEL | RESORT | COUNTRY
1 | BKK | 2010-06-10 00:00:00 | 1234 | BASIC | BKK | Malaysia
2 | MNL | 2011-07-15 00:00:00 | 1234 | BASIC | SGN | Japan
3 | BKK | 2010-07-15 00:00:00 | 4321 | BASIC | SGN | Malaysia
4 | SGN | 2011-04-10 00:00:00 | 34521 | BASIC | SGN | Japan
5 | SIN | 2012-05-29 00:00:00 | 34321 | BASIC | BKK | Japan
6 | SIN | 2012-06-25 00:00:00 | 1234 | BASIC | SIN | Japan
7 | BKK | 2010-06-15 00:00:00 | 1333 | BASIC | BKK | Malaysia
8 | MNL | 2011-07-15 00:00:00 | 1333 | BASIC | SGN | Japan
 | Desired outcome:
 | In the list above, there are multiple membership nos. that have different departure date (Column C). I basically need to determine the earliest departure date (in green) for those members who have multiple entries in column D since the data are in thousands. Thanks
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1
2
3 |  | -2368
4 |  | -2368
5 |  | -2368
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 89506
2001-08-05 00:00:00
CBS Dollars
 |  |  | 377732
Spreadsheet: 106490d1303763576-text-to-columns-rowstocolumns-parsemacros
Sheet: Part 3

Code | Data1 | Data2 | Data3
ZZAA12 | 0.05 | 0.07 | 0.09
[NAME] | 0.03
ZZAA14 | 0.07 | 0.06 | 0.04
[NAME] | 0.02 | 0.03
ZZAA16 | 0.06 | 0.04
ZZAA17 | 0.02 | 0.07
ZZAA18 | 0.04 | 0.03 | 0.06
ZZAA19 | 0.03
[NAME] | 0.07 | 0.06 | 0.04
 |  |  |  | Press Alt-F8 and run the ReOrganizeTable macro
Spreadsheet: 167764d1342098131-excel-2007-index-match-formula-but-i-need-the-data-to-change-depening-on-what-date-i-put-in-sample-t2
Sheet: Master SC

 |  |  |  |  |  |  |  |  |  | Original |  |  |  |  |  |  |  |  |  |  | Regrade
Date | Time | Receiver # | Receiving Station | Grower # | [NAME] | # of Tanks | Block | Weight | Avg. [NAME] | Decay | Soft | Wind Whip | Undersize | Hail | Splits | Other | Comments | Grader | Sample Size | Grade | Grade | Sample size | Grader | Decay | Soft | Wind Whip | Undersize | Hail | Splits | Other | Comments
2012-07-10 00:00:00 |  |  |  | 1 | Grower 1 |  |  |  |  |  |  |  |  |  |  |  |  | sg |  | 93
2012-07-10 00:00:00 |  |  |  | 1 | Grower 1 |  |  |  |  |  |  |  |  |  |  |  |  | sg |  | 96
2012-07-10 00:00:00 |  |  |  | 1 | Grower 1 |  |  |  |  |  |  |  |  |  |  |  |  | sg |  | 89
2012-07-10 00:00:00 |  |  |  | 1 | Grower 1 |  |  |  |  |  |  |  |  |  |  |  |  | sg |  | 90
2012-07-10 00:00:00 |  |  |  | 1 | Grower 1 |  |  |  |  |  |  |  |  |  |  |  |  | sg |  | 87
2012-07-10 00:00:00 |  |  |  | 2 | Grower 2 |  |  |  |  |  |  |  |  |  |  |  |  | tg |  | 90
2012-07-10 00:00:00 |  |  |  | 2 | Grower 2 |  |  |  |  |  |  |  |  |  |  |  |  | tg |  | 91
2012-07-10 00:00:00 |  |  |  | 2 | Grower 2 |  |  |  |  |  |  |  |  |  |  |  |  | tg |  | 89
2012-07-10 00:00:00 |  |  |  | 2 | Grower 2 |  |  |  |  |  |  |  |  |  |  |  |  | sg |  | 93
2012-07-10 00:00:00 |  |  |  | 2 | Grower 2 |  |  |  |  |  |  |  |  |  |  |  |  | tg |  | 94
2012-07-10 00:00:00 |  |  |  | 1 | Grower 1 |  |  |  |  |  |  |  |  |  |  |  |  | sg |  | 86
2012-07-10 00:00:00 |  |  |  | 2 | Grower 2 |  |  |  |  |  |  |  |  |  |  |  |  | sg |  | 99
2012-07-10 00:00:00 |  |  |  | 1 | Grower 1 |  |  |  |  |  |  |  |  |  |  |  |  | tg |  | 93
2012-07-11 00:00:00 |  |  |  | 3 | grower 3 |  |  |  |  |  |  |  |  |  |  |  |  | sg |  | 99
2012-07-11 00:00:00 |  |  |  | 3 | grower 3 |  |  |  |  |  |  |  |  |  |  |  |  | sg |  | 95
2012-07-11 00:00:00 |  |  |  | 3 | grower 3 |  |  |  |  |  |  |  |  |  |  |  |  | sg |  | 93
Spreadsheet: 164845d1340907781-using-solver-with-list-function-for-max-value-solver-with-list
Sheet: Sheet1

 |  |  |  |  |  |  | A-choice
 | A | B |  |  | A-1 | A-2 | 1 |  | Input cell
 | 20 | 30 |  | A | 20 | 30
 | 30 | 10 |  |  |  |  | B-choice
 |  |  |  |  |  |  | 2 |  | Input cell
 | A | 20 |  |  | B-1 | B-2
 | B | 30 |  | B | 30 | 10 |  |  | Target cell
 | solve for min (wt=AxB)
Spreadsheet: 91191d1290950511-finalize-to-my-stock-report-stock-balance-record
Sheet: INDEX

 | Stock summary Report
 | Total Stock Value (Rs) :- |  | 52375
 | Item # | Item Name | Current Balance | Unit Price (Rs) | Item Value (Rs)
 | 01 | Table lamp | 425 | 50 | 21250 |  | 01
 | 02 | Tube lights | 480 | 25 | 12000
 | 03 | CFL bulbs | 425 | 45 | 19125
Spreadsheet: 109774d1306530085-new-order-of-bill-number-as-of-date-date-order
Sheet: Sheet1

bill # | code | date | name
1 | 1 | 2011-07-01 00:00:00 | [NAME]
2 | 1 | 2011-07-03 00:00:00 | [NAME]
3 | 1 | 2011-07-05 00:00:00 | [NAME]
4 | 1 | 2011-07-07 00:00:00 | [NAME]
5 | 1 | 2011-07-09 00:00:00 | [NAME]
6 | 1 | 2011-07-11 00:00:00 | [NAME]
7 | 2 | 2011-07-02 00:00:00 | [NAME]
8 | 2 | 2011-07-09 00:00:00 | [NAME]
9 | 2 | 2011-07-16 00:00:00 | [NAME]
10 | 2 | 2011-07-23 00:00:00 | [NAME]
11 | 2 | 2011-07-30 00:00:00 | [NAME]
12 | 2 | 2011-08-06 00:00:00 | [NAME]
13 | 2 | 2011-08-13 00:00:00 | [NAME]
14 | 3 | 2011-07-03 00:00:00 | [NAME]
15 | 3 | 2011-07-06 00:00:00 | [NAME]
16 | 3 | 2011-07-09 00:00:00 | [NAME]
17 | 3 | 2011-07-12 00:00:00 | [NAME]
18 | 3 | 2011-07-15 00:00:00 | [NAME]
below how i need it.
new bill order | prev bill # | code | date | name
1 | 1 | 1 | 2011-07-01 00:00:00 | [NAME]
2 | 7 | 2 | 2011-07-02 00:00:00 | [NAME]
3 | 2 | 1 | 2011-07-03 00:00:00 | [NAME]
4 | 14 | 3 | 2011-07-03 00:00:00 | [NAME]
5 | 3 | 1 | 2011-07-05 00:00:00 | [NAME]
6 | 15 | 3 | 2011-07-06 00:00:00 | [NAME]
7 | 4 | 1 | 2011-07-07 00:00:00 | [NAME]
8 | 5 | 1 | 2011-07-09 00:00:00 | [NAME]
9 | 8 | 2 | 2011-07-09 00:00:00 | [NAME]
10 | 16 | 3 | 2011-07-09 00:00:00 | [NAME]
11 | 6 | 1 | 2011-07-11 00:00:00 | [NAME]
12 | 17 | 3 | 2011-07-12 00:00:00 | [NAME]
13 | 18 | 3 | 2011-07-15 00:00:00 | [NAME]
14 | 9 | 2 | 2011-07-16 00:00:00 | [NAME]
15 | 10 | 2 | 2011-07-23 00:00:00 | [NAME]
16 | 11 | 2 | 2011-07-30 00:00:00 | [NAME]
17 | 12 | 2 | 2011-08-06 00:00:00 | [NAME]
18 | 13 | 2 | 2011-08-13 00:00:00 | [NAME]
Spreadsheet: daren_farmer__6005__jun00hl&p2
Sheet: Nom

 | Transport |  |  |  |  | Spot Sales
 |  |  |  |  |  | [NAME] | Adonis | CPL
 | 1008 | 1007 | 7269 | Total |  | 7269 | 7269 | 7269
1 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
2 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
3 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 10000
 | 0 | 0 | 0 |  |  | 5000 | 0 | 10000
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
22 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
23 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
24 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
25 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
26 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
27 | 0 | 0 | 0 |  |  | 5000 | 0 | 5000
28 | 0 | 0 | 0 |  |  | 5000 | 0 | 0
29 |  |  |  |  |  | 5000 | 0 | 0
30 |  |  |  |  |  | 5000 | 0 | 0
31 | 0 | 0 | 0 | 0 |  | 5000 | 0 | 0
Spreadsheet: 834467d1687855308-find-column-reference-with-specific-header-value-to-use-in-indirect-function-find-column-ref
Sheet: Sheet2

Sr No | All Param | ValueF | KEY
1 | ABC | A<> | Y
2 | A123 | A1 | N
3 | DEF | 123 | N
4 | JKL | ABCD | Y
5 | F123 | na | N
6 | GHI | 0 | Y
Spreadsheet: darrell_schoolcraft__7779__imbalsumm0106
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 24912 | 30000
2 | 36015 | 30000
3 | 42137 | 30000
4 | 32489 | 40000
5 | 39177 | 38000
6 | 39137 | 38000
7 | 29194 | 38000
8 | 34268 | 38000
9 | 33780 | 37999
10 | 33193 | 37999
11 | 2357 | 23999
12
13
14
15
16
17
18
19
20
21
22
23 | 31271 | 30000
24 | 36296 | 30000
25 | 39015 | 30000
26 | 34862 | 34999
27 | 43713 | 39999
28
29
30
31
2001-05-31 00:00:00 |  |  | -112130.12
2001-06-27 00:00:00
Spreadsheet: 080bec70-b34c-42b7-9ada-aa07906c7155
Sheet: Waldhorn

Priv. | Archiv | Titel der Sammlung | Nr. | Titel der Komposition | Komponist / Arr. | Arrangeur | [NAME] | Besetzung | Anmerkung | Einst.
H/001 |  |  |  | Nachtgesang im [NAME] | [NAME] |  |  | 4 Waldh.+Männerchor
H/002 |  |  |  | Ave [NAME] | [NAME] | M.Vollmer, [NAME] |  | 4 Waldhörner
Spreadsheet: 686002d1594308458-return-row-number-findmatchsample-mike1122-
Sheet: 777

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | 4 | 13 | 14 | 26 |  |  |  | 4 | 13 | 22 | 31 | 29 | 33 | 36
2 |  |  |  |  |  |  |  | 15 | 17 | 19 | 21 | 24 | 32 | 36
3 |  |  |  |  |  |  |  | 13 | 18 | 24 | 27 | 33 | 36 | 41
4 |  |  |  |  |  |  |  | 4 | 7 | 8 | 10 | 14 | 20 | 27
5 |  |  |  |  |  |  |  | 5 | 8 | 10 | 13 | 15 | 17 | 22
6 |  |  |  |  |  |  |  | 4 | 5 | 14 | 20 | 24 | 32 | 33
7 |  |  |  |  |  |  |  | 4 | 13 | 29 | 33 | 26 | 36 | 14
8 |  |  |  |  |  |  |  | 6 | 8 | 11 | 14 | 15 | 16 | 20
9 |  |  |  |  |  |  |  | 7 | 9 | 14 | 23 | 24 | 25 | 31
10 |  |  |  |  |  |  |  | 13 | 20 | 22 | 23 | 25 | 28 | 29
Spreadsheet: dbbceb06-ebdf-4c63-a0f1-641066bd443e
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
35915389 | 2013-05-12 23:16:36 | AXIS | 0 | 2 | 6 | 1326694 | player1326694 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
35915594 | 2013-05-12 23:26:56 | ALLIES | 1 | 6 | 3 | 1326694 | player1326694 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
Spreadsheet: 878130d1725106159-formula-for-intersection-of-rows-and-columns-extend-excel-8-365-wip-aligw
Sheet: Sheet1

Modules(columns) | T/F |  |  |  |  | Modules(columns) | Analytics | Systems Analyst | Business Analyst | Development | Product Manager | Department Manager | Team Leader
d3 | FALSE |  |  |  |  | d3 | 1 | 2 | 3 | 4 | 5 | 6 | 7
Administration | FALSE |  |  |  |  | Administration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Obstetrics | FALSE |  |  |  |  | Obstetrics | 1 | 2 | 3 | 4 | 5 | 6 | 7
Pharmacy | FALSE |  | Systems Analyst |  |  | Pharmacy | 1 | 2 | 3 | 4 | 5 | 6 | 7
BARS - Healthcare Monitoring | TRUE |  |  |  |  | BARS - Healthcare Monitoring | 1 | 2 | 3 | 4 | 5 | 6 | 7
BARS.STAR | TRUE |  |  |  |  | BARS.STAR | 1 | 2 | 3 | 4 | 5 | 6 | 7
Vaccination | TRUE |  |  |  |  | Vaccination | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF AKiNEO | TRUE |  |  |  |  | VIMIS RF AKiNEO | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF Oncology | TRUE |  |  |  |  | VIMIS RF Oncology | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF Prevention | FALSE |  |  |  |  | VIMIS RF Prevention | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF CVD | FALSE |  |  |  |  | VIMIS RF CVD | 1 | 2 | 3 | 4 | 5 | 6 | 7
HMP | FALSE |  |  |  |  | HMP | 1 | 2 | 3 | 4 | 5 | 6 | 7
Outside ARM | FALSE |  |  |  |  | Outside ARM | 1 | 2 | 3 | 4 | 5 | 6 | 7
Military registration | FALSE |  |  | Hard-50% |  | Military registration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Hospital physician | FALSE |  |  |  |  | Hospital physician | 1 | 2 | 3 | 4 | 5 | 6 | 7
Diagnostics | FALSE |  | Positions |  |  | Diagnostics | 1 | 2 | 3 | 4 | 5 | 6 | 7
Dispensary registration | FALSE |  | Analytics | TRUE |  | Dispensary registration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Remote monitoring | FALSE |  | Systems Analyst | TRUE |  | Remote monitoring | 1 | 2 | 3 | 4 | 5 | 6 | 7
Health diary | FALSE |  | Business Analyst | FALSE |  | Health diary | 1 | 2 | 3 | 4 | 5 | 6 | 7
Unified registry | FALSE |  | Development | FALSE |  | Unified registry | 1 | 2 | 3 | 4 | 5 | 6 | 7
User information support | FALSE |  | Product Manager | FALSE |  | User information support | 1 | 2 | 3 | 4 | 5 | 6 | 7
IPRA | FALSE |  | Department Manager | FALSE |  | IPRA | 1 | 2 | 3 | 4 | 5 | 6 | 7
IEMC | FALSE |  | Team Leader | FALSE |  | IEMC | 1 | 2 | 3 | 4 | 5 | 6 | 7
Call center | FALSE |  |  |  |  | Call center | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  |  |  | The formula should not only find numbers at the intersection of rows and columns and write them into the range starting from the green cell, but also multiply them by 3 and add percentages to the result depending on the complexity. There is data validation with the required percentages. The most important condition is that there is must be only one function and it calculates everything automatically.
Spreadsheet: 144177d1330759658-updating-data-from-multiple-worksheet-in-a-master-worksheet-invoice-tracking-example
Sheet: Service Line 2 Invoices

Service line 1
 | Invoiced |  |  |  |  |  |  |  | Paid
Invoice Number | Year | Month | Day | Client | RMB Total | Code | Invoice Total | Current? | Year | Month | Day | Code | Amnt Arrived | Bank | Difference | FX | RMB | Remarks
SL2-20120204-01 | 2012 | Feb | 4 | XYZ | 45000 | RMB | 45000 | Y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Current? | Month | Date | Currency
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | Jan | 1 | RMB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | Feb | 2 | USD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar | 3 | EUR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr | 4 | HKD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May | 5 | GBP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
Spreadsheet: chris_germany__1709__nonThSto
Sheet: 0315 Plan

 | Inj/WD | AGL-IBSS | AGL-LNG Peaking | Tennessee FS-MA | Tennessee FS-PA | AGL-CNG | BGE-CNG | BGE-TCO | Michcon | Nipsco
 | Balance | 278878 | 229862 | 34965 | 98530 | 6 | 549 | 2589 | 0 | 2290
 | 2000-04-01 00:00:00 | -24165 | 17630 | -17190 | -43230 | 0 | -506 | 699 | 21001 | 6382
 | 2000-05-01 00:00:00 | 186787 | 25333 | -17190 | -43230 | 0 | 2198 | 9232 | 73542 | 8239
 | 2000-06-01 00:00:00 | 192450 | 42000 | 0 | -12000 | 0 | 2400 | 13500 | 213145 | 10460
 | 2000-07-01 00:00:00 | 144460 | 0 | 0 | 0 | 0 | 2046 | 13268 | 143119 | 10540
 | Transfers | 0 | 0 | 0 | 0 | 0 |  | -6592 | 0 | 0
 | 8/1 Balance
Spreadsheet: 710211d1608775919-need-to-move-random-data-from-one-worksheet-to-another-my-dmc-thread-inventory-template
Sheet: Diamant

Color | Number | Description | Skeins available | Skeins needed | Project notes | type
 | D140 | Gold & Black | 0 | 0 |  | diamant
 | D168 | Light Silver | 0 | 0 |  | diamant
 | D225 | Old Rose | 0 | 0 |  | diamant
 | D301 | Copper | 0 | 0 |  | diamant
 | D310 | Ebony | 0 | 0 |  | diamant
 | D316 | Pink Amythest | 0 | 0 |  | diamant
 | D317 | [NAME] | 0 | 0 |  | diamant
 | D321 | Red Ruby | 0 | 0 |  | diamant
 | D415 | [NAME] | 0 | 0 |  | diamant
 | D699 | [NAME] | 0 | 0 |  | diamant
 | D898 | Oak | 0 | 0 |  | diamant
 | [NAME] | Light Gold | 0 | 0
 | D3852 | [NAME] | 0 | 0
 | D5200 | White | 0 | 0
Spreadsheet: 799700d1665218979-case-sensitive-with-match-while-using-arrays-excel_help
Sheet: control-2arrays

UNMATCH: |  | (case-unsensitive) |  | =SUMPRODUCT((1*ISNA(MATCH(A4&A5:A1000,E5:E10&F5:F10,0))=1)*(A5:A1000<>"")*1)
 | ? | (case-sensitive)
grade | location |  |  | label | value
A | US |  |  | location | MX
A | DE |  |  | grade | A
B | MX |  |  | grade | B
C | US |  |  | location | US
D | DE |  |  | location | NL
a | MX |  |  | grade | C
F | US
A | DE
A | MX
B | FR
B | DE
D | MX
A | FR
B | US