tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94507d1294309702-excel-2007-excel-experts-plz-i-need-help-project-data-4
Sheet: Sheet1

 |  |  |  | ID | 900012394 |  | Major | Economics
 |  |  |  |  |  |  |  |  |  | Bachelor of Arts in Economics
 |  |  |  |  | Course | Grade |  | Course | Grade |  |  |  | Course | Grade |  | Course | Grade
 |  |  |  |  | BIS101 |  |  | ECO302 |  |  |  |  | ECO305 |  |  | ECO495
 |  |  |  | 1st semester | ECO201 |  | 3rd semester | ECO310 |  |  |  | 5th semester | MJEXXX |  | 7th semester | MJEXXX
 |  |  |  |  | WRI101 |  |  | ARAXXX |  |  |  |  | MJEXXX |  |  | MJEXXX
 |  |  |  |  | MTH101 |  |  | ENGXXX |  |  |  |  | HSSXXX |  |  | MJEXXX
 |  |  |  |  | SCIXXX |  |  | HSSXXX |  |  |  |  | HSSXXX |  |  | FREEXXX
 |  |  |  |  | Course | Grade |  | Course | Grade |  |  |  | Course | Grade |  | Course | Grade
 |  |  |  |  | WRI102 |  |  | ECO301 |  |  |  |  | MJEXXX |  |  | MJEXXX
 |  |  |  | 2nd semester | ECO202 |  | 4th semester | ECO330 |  |  |  | 6th semester | MJEXXX |  | 8th semester | MJEXXX
 |  |  |  |  | STA 202 OR QBA 201 |  |  | MJEXXX |  |  |  |  | MJEXXX |  |  | MJEXXX
 |  |  |  |  | SCIXXX |  |  | ENGXXX |  |  |  |  | HSSXXX |  |  | FREEXXX
 |  |  |  |  | MJEXXX |  |  | HSSXXX |  |  |  |  | FREEXXX |  |  | FREEXXX
 |  |  |  |  |  |  |  |  |  |  |  | Accounting
 |  |  |  |  |  |  |  |  |  |  |  | Arts in Economics
 |  |  |  |  |  |  |  |  |  |  |  | Economics
 |  |  |  |  |  |  |  |  |  |  |  | Finance
 |  |  |  |  |  |  |  |  |  |  |  | Management
 |  |  |  |  |  |  |  |  |  |  |  | Marketing
 |  |  |  |  |  |  |  |  |  |  |  | MIS
 |  |  |  |  |  |  |  |  |  |  |  | Public Adminstration
Spreadsheet: 047a9b45-597d-401e-ab35-47843fc072a6
Sheet: Board Member Sign In

Timestamp | Board Member Name
2011-09-06 08:22:41 | [NAME] | Non-Competitive Info Booth (West End) 9:30-11:30, Non-Competitive Info Booth (West End) 11:30-1:30, Non-Competitive Info Booth (West End) 1:30-3:30
2011-09-06 08:32:09 | [NAME] | Non-Competitive Info Booth (West End) 11:30-1:30
2011-09-06 08:57:53 | [NAME] | Non-Competitive Info Booth (West End) 7:30-9:30
2011-09-06 20:19:24 | [NAME] | [NAME] (East End) 7:30-9:30
2011-09-07 08:15:16 | [NAME] | [NAME] (East End) 7:30-9:30
Board Member SignIn
Date:
Non Comp | Saturday | Print Name |  | Print Name
[NAME] | 7:30-9:30
 | 9:30-11:30
 | 11:30-1:30
 | 1:30-3:30
 | 3:30-5:30
 |  | Print Name |  | Print Name
Comp | 7:30-9:30
[NAME] | 9:30-11:30
 | 11:30-1:30
 | 1:30-3:30
 | 3:30-5:30
Spreadsheet: 134361d1325250375-solved-reconcile-two-sets-of-data-test1301211
Sheet: company deduction report

EMP. NO. | SURNAME | FIRST NAMES | (=N=) LOAN DEDUCTION | (=N=) LOAN BALANCE | REMARK
04157 | ADEDO, | ABIODUN MOSES | 30000 | 24666.7 | not reconciled
02558 | ADEEGBE, | EMMANUEL SUNDAY | 8633.33 | 86333.34 | reconciled
13923 | ADENMOSUN, | [NAME] | 17143.33 | 120003.35 | reconciled
02664 | AJALA, | SALIU | 6348.49 | 19045.47 | reconciled
20634 | AJIBODU, | ABOSEDE OLUWATOBI | 4316.67 | 8633.3 | not reconciled
20628 | AKINSOLA, | SUNDAY OLASUNKANMI | 4316.67 | 8633.3 | reconciled
07639 | ALIMI, | NAJEEM | 3700 | 40700 | reconciled
20625 | AYINLA, | ALIU | 5180 | 10360 | reconciled
09797 | AYODEJI, | FATA ADESINA | 7893.33 | 15786.7 | not reconciled
30238 | AZEEZ, | NURENI AKANBI | 4316.67 | 8633.3 | reconciled
30234 | BABATUNDE, | [NAME] | 5180 | 10360 | reconciled
30234 | BABATUNDE, | [NAME] | 5180 | 10360 | not reconciled
20617 | BAKARE, | MUSILIU | 3946.67 | 11839.97 | not reconciled
07473 | BANKOLE, | OLATUNDE | 6166.67 | 36999.98 | not reconciled
20621 | BUSARI, | MOTUNRAYO OLUFUNKE | 4316.67 | 10000 | not reconciled
20627 | FATUNMBI, | BABATUNDE MICHAEL | 4810 | 9620 | not reconciled
30235 | IGOR, | LINUS | 5920 | 65120 | not reconciled
10831 | JAYEOLA, | SUNDAY OLUWASEGUN | 11100 | 44400 | not reconciled
Spreadsheet: 674154d1587677383-assistance-with-vlookup-function-2020-04-23-oeldere-fluff13
Sheet: Sheet1

 | Fluff13
 | Table 1 |  |  |  | Table 2 |  |  |  | Oeldere
Employee | 2020-04-03 00:00:00 | 2020-04-10 00:00:00 | 2020-04-17 00:00:00 |  | Employee | Date | Hours |  | Som van Hours | Kolomlabels
Number 1 |  |  |  |  | Number 1 | 2020-04-03 00:00:00 | 4.5 |  | Rijlabels | 2020-04-03 00:00:00 | 2020-04-10 00:00:00 | 2020-04-17 00:00:00 | Eindtotaal
Number 2 |  |  |  |  | Number 2 | 2020-04-17 00:00:00 | 0.5 |  | Number 1 | 4.5 |  |  | 4.5
Number 3 |  |  |  |  | Number 2 | 2020-04-10 00:00:00 | 1.5 |  | Number 10 | 0.5 |  | 0.25 | 0.75
Number 4 |  |  |  |  | Number 2 | 2020-04-03 00:00:00 | 1.25 |  | Number 2 | 1.25 | 1.5 | 0.5 | 3.25
Number 5 |  |  |  |  | Number 3 | 2020-04-03 00:00:00 | 2 |  | Number 3 | 27 |  |  | 27
Number 6 |  |  |  |  | Number 3 | 2020-04-03 00:00:00 | 25 |  | Number 4 | 2 | 4 |  | 6
Number 7 |  |  |  |  | Number 4 | 2020-04-03 00:00:00 | 2 |  | Number 5 | 8 | 5 |  | 13
Number 8 |  |  |  |  | Number 4 | 2020-04-10 00:00:00 | 4 |  | Number 6 |  |  | 5.5 | 5.5
Number 9 |  |  |  |  | Number 5 | 2020-04-03 00:00:00 | 8 |  | Number 7 | 8 | 4 |  | 12
Number 10 |  |  |  |  | Number 5 | 2020-04-10 00:00:00 | 5 |  | Number 8 | 1 |  |  | 1
 |  |  |  |  | Number 6 | 2020-04-17 00:00:00 | 5.5 |  | Number 9 | 2 |  | 2 | 4
 |  |  |  |  | Number 7 | 2020-04-03 00:00:00 | 8 |  | Eindtotaal | 54.25 | 14.5 | 8.25 | 77
 |  |  |  |  | Number 7 | 2020-04-10 00:00:00 | 4
 |  |  |  |  | Number 8 | 2020-04-03 00:00:00 | 1
 |  |  |  |  | Number 9 | 2020-04-03 00:00:00 | 2
 |  |  |  |  | Number 9 | 2020-04-17 00:00:00 | 2
 |  |  |  |  | Number 10 | 2020-04-03 00:00:00 | 0.5
 |  |  |  |  | Number 10 | 2020-04-17 00:00:00 | 0.25
Fluff13, may I ask how this formula you suggested should be written when table 2 is in another sheet on the same workbook?
Hello
I hope all is safe and sound.
I am facing a problem with VLOOKUP function and I would like your help on this.
In the attached excel sheet I have two tables, table 2 is the raw data I receive and table 1 is the dataset I want to make.
My purpose is whenever table 2 is being updated, then table 1 will be updated accordingly and automatically.
The problem lays with the contents of table 2:
Problem 1: Number 2 has 3 entries, each on different date. But when I use VLOOKUP in cell [NAME] I receive the data from the first entry of number 2 in table 2. I would like [NAME] in table 1 to show the hours of employee number 2 on 03/04/2020. Is this possible without adding a helper column?
Problem 2: Number 3 has 2 entries, both on same date. Is it possible that cell [NAME] in table 1 to show the sum hours of employee number 3 on 03/04/2020?
Any help and advice will be much appreciated!
Spreadsheet: joe_parks__14620__POSTIONTRAX_NOV
Sheet: WAHA_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  | 11 | 1.84 |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 3 DAY ROLL
 |  |  | ROLL VALUE
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 680999d1591293286-summing-array-rows-by-first-column-sample-data
Sheet: Sheet1

 |  | Game 1 Points | Game 2 Points | Game 3 Points | Game 4 Points
Week 1 | East | 59 | 33 | 62 | 36
 | West | 46 | 51
 | South | 44 | 47 | 65 | 36
Week 2 | East | 37
 | West | 60 | 65 | 59
 | South | 67 | 73 | 76 | 76
Week 3 | East | 64 | 32 | 57 | 54
 | West | 43
 | South
Week 4 | East | 64 | 32 | 57 | 54
 | West | 43 | 59 | 52
 | South | 59 | 42
 | East Total Points:
 | West Total Points:
 | South Total Points:
Spreadsheet: 41242d1239734024-replacing-values-between-xls-files-b
Sheet: Sheet1

[NAME] |  | 4 | 4 | 1
[NAME] |  | 4 | 3 | 0.75
[NAME] |  | 4 | 5 | 1.25
[NAME] |  | 5 | 4 | 0.8
[NAME] |  | 2 | 2 | 1
[NAME] |  | 3 | 3 | 1
[NAME] |  | 6 | 7 | 1.17
Spreadsheet: 98872d1297705465-help-with-vlookup-example-quote-page
Sheet: Quote Sheet

Request For Quotation
Customer: |  |  |  |  |  | Start Date: | 2011-02-14 00:00:00
 |  |  |  |  |  | [NAME]: | 2011-08-14 00:00:00
Account #: |  |  |  |  |  | Territory #:
 |  |  |  |  |  | Sales Rep:
 |  |  |  |  |  |  |  | [NAME] |  | Pail
Product |  |  | Product |  |  |  |  | Quote Price |  | Quote Price
Code |  |  | Description |  |  |  |  | Price | PC | Price | PC
1111101 | Example 1 3.78L |  |  |  |  |  |  | 51 | a
2222205 | Example 2 18.9L |  |  |  |  |  |  | 37.65 | a
 | above is how it works currently, enter product code and then |  |  |  |  |  |  | #N/A
 | PC code and description and price are filled in |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
1111101 | Example 1 |  |  |  |  |  |  | 51 | a | 37.65 | a
2222205 | Example 2 |  |  |  |  |  |  | 181.25 | a | 37.65 | a
 | would prefer to be able to enter a price code and description |  |  |  |  |  |  | #N/A
 | be filled in but remove size from description. |  |  |  |  |  |  | #N/A
 | also depending on what size you fill in the PC column, it would look |  |  |  |  |  |  | #N/A
 | for the appropriate price with out changing the size code on the |  |  |  |  |  |  | #N/A
 | last 2 digits of the product code |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
 | #N/A |  |  |  |  |  |  | #N/A
Spreadsheet: 52265d1251974158-multiple-formulae-in-a-cell-an-algorithm-example-spreadsheet-2-
Sheet: Sheet1

Ta | 24.4 | This is the other parameter and will vary in the Y axis (I.e. Columns)
RH | 49.6 | This is one parameter and will vary in the X axis (I.e. Rows)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example sheet would look like:
Stage 1 = "Formula1" |  |  |  |  | see "Insert" >> "Name" >> "Define" |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RH
Stage 2 = "Formula2" |  |  |  |  | " |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10 | -5 | …
Stage 3 = "Formula3" |  |  |  |  | " |  |  |  |  |  |  |  |  |  |  |  |  | Ta | 1 | FinalVal | FinalVal | FinalVal
Stage 4 = "Formula4" |  |  |  |  | " |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | FinalVal | FinalVal | FinalVal
Final Value |  |  |  |  | " |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | FinalVal | FinalVal | FinalVal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | … | FinalVal | FinalVal | FinalVal
 |  |  |  |  | RH
 |  | 5 | 10 | 20 | 25 | 30 | 35
TA | 1 | 0.2353337630806118 | 0.5356468733957737 | 1.209555764910689 | 1.569636448803583 | 1.940980183713097 | 2.321797675091008
 | 2 | 0.2548181418901007 | 0.5795453404726415 | 1.307706993035771 | 1.696614936430425 | 2.097612757301043 | 2.508780138190854
 | 3 | 0.1019101953494446 | 0.2338804242972068 | 0.5323711358696349 | 0.6925859985377253 | 0.8581591896813826 | 1.028243576403379
 | 4 | 0.1019101953494446 | 0.2338804242972068 | 0.5323711358696349 | 0.6925859985377253 | 0.8581591896813826 | 1.028243576403379
 | 5 | 0.1019101953494446 | 0.2338804242972068 | 0.5323711358696349 | 0.6925859985377253 | 0.8581591896813826 | 1.028243576403379
 | 6 | 0.1019101953494446 | 0.2338804242972068 | 0.5323711358696349 | 0.6925859985377253 | 0.8581591896813826 | 1.028243576403379
 | 7 | 0.1019101953494446 | 0.2338804242972068 | 0.5323711358696349 | 0.6925859985377253 | 0.8581591896813826 | 1.028243576403379
 | 8 | 0.1019101953494446 | 0.2338804242972068 | 0.5323711358696349 | 0.6925859985377253 | 0.8581591896813826 | 1.028243576403379
 | 9 | 0.1019101953494446 | 0.2338804242972068 | 0.5323711358696349 | 0.6925859985377253 | 0.8581591896813826 | 1.028243576403379
 | 10 | 0.1019101953494446 | 0.2338804242972068 | 0.5323711358696349 | 0.6925859985377253 | 0.8581591896813826 | 1.028243576403379
 | 11 | 0.1019101953494446 | 0.2338804242972068 | 0.5323711358696349 | 0.6925859985377253 | 0.8581591896813826 | 1.028243576403379
Spreadsheet: 538579d1505728223-merging-rows-patient-database-goal
Sheet: Blad1

ID | Ålder | Kön (1 = kvinnor, 2 = män) | Provdatum | MALDI | Påvisat (från prov) (1/0) | Påvisat (från framvuxna bakterier (1/0) | GRÄNSVÄRDE (från prov) | GRÄNSVÄRDE (från framvuxna bakterier)
1 | 99 | 1 | 2016-07-24 00:00:00 | 10 | 1 | 0 | 0 | 0
2 | 99 | 2 | 2016-02-29 00:00:00 | 11 | 0 | 1 | 0 | 0
3 | 99 | 1 | 2016-12-19 00:00:00 | 14 | 1 | 0 | 0 | 0
5 | 99 | 1 | 2016-07-18 00:00:00 | 5 | 1 | 0 | 0 | 0
Spreadsheet: 678748d1590049026-formula-not-calculating-charts
Sheet: Chart 1

 | Daily
2020-05-01 00:00:00 | 1375.62889 | 800
2020-05-02 00:00:00 | 1380.88179 | 800
2020-05-03 00:00:00 | 1413.977789999999 | 800
2020-05-04 00:00:00 | 1462.43379 | 800
2020-05-05 00:00:00 | 1462.621789999999 | 800
2020-05-06 00:00:00 | 1375.19179 | 800
2020-05-07 00:00:00 | 1338.87797 | 800
2020-05-08 00:00:00 | 1290.87065 | 800
2020-05-09 00:00:00 | 1321.49901 | 800
2020-05-10 00:00:00 | 1358.83101 | 800
2020-05-11 00:00:00 | 1410.30697 | 800
2020-05-12 00:00:00 | 1403.29097 | 800
2020-05-13 00:00:00 | 1389.67097 | 800
2020-05-14 00:00:00 | 1397.89097 | 800
2020-05-15 00:00:00 | 1367.62597 | 800
2020-05-16 00:00:00 | 1332.89497 | 800
2020-05-17 00:00:00 | 1332.89497 | 800
2020-05-18 00:00:00 | 1346.92161 | 800
2020-05-19 00:00:00 | 1360.91797 | 800
2020-05-20 00:00:00 |  | 800
2020-05-21 00:00:00 |  | 800
2020-05-22 00:00:00 |  | 800
2020-05-23 00:00:00 |  | 800
2020-05-24 00:00:00 |  | 800
2020-05-25 00:00:00 |  | 800
2020-05-26 00:00:00 |  | 800
2020-05-27 00:00:00 |  | 800
2020-05-28 00:00:00 |  | 800
2020-05-29 00:00:00 |  | 800
2020-05-30 00:00:00 |  | 800
2020-05-31 00:00:00 |  | 800
Total
Spreadsheet: 64059d1264916348-excel-2007-formula-for-multiple-criteria-mandy1010
Sheet: Data

A | H | G | F | E |  | 1
B | A | H | G | F |  | 2
C | B | A | H | G |  | 3
D | C | B | A | H |  | 4
E | D | C | B | A |  | 5
F | E | D | C | B |  | 6
G | F | E | D | C |  | 7
H | G | F | E | D |  | 8
 | I am getting a Value error
New Data
933 | W Out | Full | 551 | SN | 20 | 2000
933 | WO Out | Full | 551 | SN | 200 | 4500
933 | WO Out | Full | 571 | PT | 150 | 4500
933 | WO Out | Full | 561 | OT | 200 | 4500
933 | WO Out | LUP | 551 | SN | 50 | 2000
933 | WO Out | PEP | 551 | SN | 50 | 2000
939 | W Out | Full | 551 | SN | 20 | 1500
939 | WO Out | Full | 551 | SN | 20 | 1500
939 | WO Out | Full | 581 | Aide | 100 | 7500
939 | WO Out | Full | 571 | PT | 100 | 7500
939 | WO Out | LUP | 571 | PT | 100 | 7500
939 | WO Out | PEP | 561 | OT | 100 | 7500
939 | WO Out | SCI | 571 | PT | 12 | 1325
999 | W Out | Full | 551 | SN | 10 | 1500
999 | WO Out | Full | 551 | SN | 50 | 7500
999 | WO Out | LUP | 551 | SN | 50 | 7500
999 | WO Out | PEP | 551 | SN | 50 | 7500
Spreadsheet: 72487d1273169093-tertiary-vertical-axis-3d_rotate
Sheet: Step By Step

Original | Xcoord | Ycoord | Zcoord |  | Dervied | Xcoord | Ycoord |  |  | Calculated Angles
One | -8.24695661087139 | -6.538171663187891 | -7.157364168273177 |  |  |  |  |  |  |  |  |  | Sin values
Two | -4.404065580658321 | -8.101527645367156 | -0.8764651508486143 |  |  |  |  |  |  |  |  |  | Cos values
Three | -3.537706484241205 | 0.4111582671220271 | 2.211881405427913
Four | 7.113822707537985 | 9.079350730545901 | -7.469935308707107 |  |  |  |  |  |  | Rotation Matrix
Five | 1.991873187497988 | 6.413114417738246 | 7.423236607313726
Six | 7.833260428100086 | -5.322795629053836 | 9.050667062278087
Seven | -9.17224136689521 | 3.644075722135267 | -7.305792909541893
Eight | -5.965624610928741 | -4.172763931169401 | 3.511971985313571
Nine | -4.696592235417913 | -1.005804039328342 | 6.225069756354813 |  |  |  |  |  |  | Angle of rotation for chart
Ten | 0.6366171606181403 | -3.556325569243803 | -2.446875543393054
 |  |  |  |  |  |  |  |  |  | X Angle | 12
 |  |  |  |  |  |  |  |  |  | Y Angle | 12
 |  |  |  |  |  |  |  |  |  | Z Angle | 18
 |  |  |  |  |  |  |  |  |  | Axes | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  | -10 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 10 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | -10 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 10 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | -10
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 10
 |  |  |  |  |  |  |  |  |  | Cage | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  | -10 | -10 | -10
 |  |  |  |  |  |  |  |  |  |  | 10 | -10 | -10
 |  |  |  |  |  |  |  |  |  |  | 10 | 10 | -10
 |  |  |  |  |  |  |  |  |  |  | -10 | 10 | -10
 |  |  |  |  |  |  |  |  |  |  | -10 | -10 | -10
 |  |  |  |  |  |  |  |  |  |  | -10 | -10 | 10
 |  |  |  |  |  |  |  |  |  |  | 10 | -10 | 10
 |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  | -10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  | -10 | -10 | 10
 |  |  |  |  |  |  |  |  |  |  | -10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  | -10 | 10 | -10
 |  |  |  |  |  |  |  |  |  |  | 10 | 10 | -10
 |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  | 10 | -10 | 10
 |  |  |  |  |  |  |  |  |  |  | 10 | -10 | -10
Spreadsheet: 51829d1251431568-countif-and-index-formula-movement-bill
Sheet: TopSheet

MOVEMENT AREA: | [NAME], Cox'S Bazar, Konabari, Rangpur, Dinajpur, Chittagong, Pabna, Tangail, Kushtia & M. Bazar
SUMMARY OF LOCATION-WISE BILL :
MOVEMENT AREA | RATE | AMOUNT |  |  | ALTERNATIVE WAY
JESSORE TO BOGRA | 3600*2+3700 | 10900 |  | BOGRA | 10900
JESSORE TO COX'S BAZAR | 9200+2 | 18400 |  | COX'S BAZAR | 18400
JESSORE TO KONABARI | 3200+4200*7+4600*4+4800*7+5200*2 | 56800 |  | KONABARI | 56800
JESSORE TO RANGPUR | 1300*2+1600 | 4200 |  | RANGPUR | 4200
JESSORE TO DINAJPUR | 7200*1 | 14000 |  | DINAJPUR | 14000
JESSORE TO CHITTAGONG | 3600*1 | 9600 |  | CHITTAGONG | 9600
JESSORE TO PABNA | 4600*1 | 8800 |  | PABNA | 8800
JESSORE TO TANGAIL |  | 9800 |  | TANGAIL | 9800
JESSORE TO KUSHTIA |  | 4200 |  | KUSHTIA | 4200
JESSORE TO M. BAZAR |  | 7200 |  | M. BAZAR | 7200
TOTAL CARRYING BILL |  | 122700
AREA
BOGRA
COX'S BAZAR
KONABARI
RANGPUR
DINAJPUR
CHITTAGONG
PABNA
TANGAIL
KUSHTIA
M. BAZAR
LKJ;F
Spreadsheet: 72931d1273615690-pull-date-from-log-to-summary-sheet-find-date
Sheet: Sheet1

 | SAMPLE FROM EXPENSE LOG |  |  |  |  |  |  |  |  |  |  |  |  |  | Key 1 | Key 2
Acct# |  | Billed |  | Due | Amount |  |  | Amt Pd | Bal | Date Pd |  |  |  |  | "A" & "C" | "A" & "K"
109 | Heat | 2010-04-15 00:00:00 |  | 2010-04-29 00:00:00 | 204.71 | Gas | Heat | 190 | 14.71000000000001 | 2010-04-22 00:00:00 |  |  |  |  | 109Apr-10 | Apr-10
106 | Bank | 2010-04-25 00:00:00 |  | 2010-04-28 00:00:00 | 390.46 | Bank | Equity Line |  | 390.46 | 2010-04-26 00:00:00 |  |  |  |  | 106Apr-10 | Apr-10
106 | Bank | 2010-04-25 00:00:00 |  |  | 75 | Bank | Fee |  | 75 |  |  |  |  |  | 106Apr-10
108 | Insurance | 2010-04-27 00:00:00 |  | 2010-04-28 00:00:00 | 190.33 | Ins Co | Ins | 190.33 |  |  |  |  |  |  | 108Apr-10
101 | Food | 2010-04-27 00:00:00 |  |  | 5.33 | Food | Dinner | 10 | 4.67 | 2010-04-27 00:00:00 |  |  |  |  | 101Apr-10 | Apr-10
102 | Groceries | 2010-04-28 00:00:00 |  |  | 39.71 | Store | Groceries | 39.71 |  | 2010-04-28 00:00:00 |  |  |  |  | 102Apr-10 | Apr-10
103 | Electric | 2010-04-14 00:00:00 |  | 2010-04-30 00:00:00 | 35 | Food | Electric | 35 |  | 2010-04-28 00:00:00 |  |  |  |  | 103Apr-10 | Apr-10
 | SAMPLE FROM ACCOUNT SUMMARY |  |  |  | Located on a different sheet, one sheet for each account
Acct#
103 | Billed | Paid | [NAME] |  | Date Due | Date Paid
2010-01-01 00:00:00 | 0 | 0 | 0
2010-02-01 00:00:00 | 0 | 0 | 0
2010-03-01 00:00:00 | 0 | 0 | 0
2010-04-01 00:00:00 | 35 | 35 | 0
2010-05-01 00:00:00 | 0 | 0 | 0
2010-06-01 00:00:00 | 0 | 0 | 0
2010-07-01 00:00:00 | 0 | 0 | 0
2010-08-01 00:00:00 | 0 | 0 | 0
2010-09-01 00:00:00 | 0 | 0 | 0
2010-10-01 00:00:00 | 0 | 0 | 0
2010-11-01 00:00:00 | 0 | 0 | 0
2010-12-01 00:00:00 | 0 | 0 | 0
Spreadsheet: 42cd56c3-b650-40c9-9738-1f254cea38c0
Sheet: FSTA

FSTA Direct (IFIS)
2008-2009
 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 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 | Total | 2008-2009 Price | Price per unit
FSTA Direct
Abstracts viewed | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
COUNTER-Compliant?: | No
Spreadsheet: 195331d1353491163-find-duplicate-events-and-select-de-last-find
Sheet: Sheet1

DATE | SERIAL NUMBER | TASKS | KMS
2012-01-01 00:00:00 | AAA | CHANGE AIR FILTER | 10
2012-01-15 00:00:00 | BBB | CHANGE AIR FILTER | 15
2012-02-10 00:00:00 | AAA | CHANGE TYRES | 20
2012-02-29 00:00:00 | BBB | CHANGE AIR FILTER | 25
2012-03-20 00:00:00 | AAA | CHANGE AIR FILTER | 35
2012-04-01 00:00:00 | BBB | CHANGE OIL | 46
LAST TASKS
 | SERIAL NUMBER | TASKS | KMS
 | AAA | CHANGE AIR FILTER
 | BBB | CHANGE AIR FILTER
Spreadsheet: 767950d1644753922-sumif-and-drop-result-multiplied-per-number-of-times-is-repeated-in-matched-cell-test_rev03
Sheet: SAMPLE

 |  |  |  |  | Match | SUM |  |  |  | SumIf(range) * LEN(Split(range)) (excelforum.com)
 |  |  |  |  | string1
 |  | STRINGS TO MATCH | RESULT range | COUNT range | RESULT*COUNT
 |  | [NAME]; | 10
 |  | string1,STRING2;string0,STRING3;string0,STRING4;string0,STRING5;string0,STRING5; | 20
 |  | string1,STRING2;string1,STRING3;string0,STRING4;string0,STRING5;STRING3;string0,STRING4;string0,STRING5; | 30
 |  | string1,STRING2;string1,STRING3;string1,STRING4;string0,STRING5;string0,STRING5; | 40
 |  | string1,STRING2;string1,STRING3;string1,STRING4;string1,STRING5; | 50
Spreadsheet: 8cc546a6-de54-4571-8b2b-622e249da1ff
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
43317104 | 2014-09-26 05:12:31 | AXIS | 1 | 6 | 3 | 603439 | MickeyScott01 | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
43317326 | 2014-09-26 05:33:53 | ALLIES | 1 | 6 | 4 | 603439 | MickeyScott01 | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
43389026 | 2014-10-01 05:46:58 | ALLIES | 0 | 4 | 6 | 465599 | Timor | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
43389248 | 2014-10-01 06:07:37 | AXIS | 0 | 2 | 6 | 465599 | Timor | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]