tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 141777d1329436575-sumproduct-spend-analysis
Sheet: Sheet1

[NAME] | Net Spend
Seven Heaven Ltd | 85254.48
Seven Heaven Ltd | 134731.483333333
Solutions Limited | 1199418.1
Solutions Limited | 1139999.8
Angus Supply | 93464.49
Angus Supply | 47175.7166666667
Azad Solutions | 25652.87
Azad Solutions | 32302
Comet Academy | 45879.48
Comet Academy | 45879.48
Loafers Ltd | 26423.68333333333
Accoustic Services | 412556.01
[NAME] | 376683.7
Modern Family Solution | 120521.08
Indication IT Ltd | 94319.17
Indication IT Ltd | 71785.28
Level Star Lighting | 108894.95
Level Star Lighting | 58454.25
Adhoc Tech Solution | 31179.1
Spreadsheet: b97546f7-9d45-4546-b521-dd4c85777620
Sheet: Sheet1

Rozpočet Pardubického kraje   ( v tis Kč )- výdajová stránka | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | [NAME] | Schválený rozpočet | Upravený rozpočet - 1 | Upravený rozpočet - 2 | Upravený rozpočet - 3 | celkem
 | Mzdové výdaje
 | Mzdové prostředky | 6015.1 |  |  |  | 6015.1
 | Pojištění sociální a zdravotní | 1993.4 |  |  |  | 1993.4
Celkem |  | 8008.5 |  |  |  | 8008.5
podseskupení položek | Věcné výdaje
513 | nákup materiálu | 1209 |  | -300 |  | 909
515 | nákup vody,paliv a energie | 589.5 |  |  |  | 589.5
516 | nákup služeb | 550 |  |  |  | 550
517 | ostatní nákupy | 700 |  | 240 |  | 940
519 | dary | 60 |  | 60 |  | 120
534 | převody vl. fondům | 31 |  |  |  | 31
Celkem |  | 3139.5 |  |  |  | 3139.5
 | Neinvestiční účelová dotace celkem | 11148 |  | 0 |  | 11148
 | Krajský úřad
 | Mzdové výdaje
 | Mzdové prostředky | 19303 | 2046 | -148 | 887 | 22088
 | Pojištění sociální a zdravotní | 6756 | 716 | -52 | 311 | 7731
Celkem |  | 26059 | 2762 | -200 | 1198 | 29819
podseskupení položek | Věcné výdaje
513 | nákup materiálu | 8700 | 588 | 3707 | 207 | 13202
515 | nákup vody,paliv a energie | 1760 |  |  |  | 1760
516 | nákup služeb | 7200 |  |  | 265 | 7465
516 | 1x 50,- člen přísp.+100,-člen.podíl +100,- bal. show+ 750,- rezerva kraje |  |  | 1000 |  | 1000
517 | ostatní nákupy | 958 |  | 700 |  | 1658
519 | dary | 50 |  |  |  | 50
534 | převody vl. fondům | 490 | 41 |  | 18 | 549
Celkem |  | 19158 | 629 | 5407 | 490 | 25684
 | Školství |  |  |  |  | 0
533 | neinv. trans. přísp. org. |  | 125712 | 47388 | 105569.2 | 278669.2
Celkem |  |  | 125712 | 47388 | 105569.2 | 278669.2
 | Územní plánování
611 | poř. [NAME]. inv. majetku |  |  | 1806 |  | 1806
516 | nákup služeb |  |  | 100 |  | 100
Celkem |  |  |  | 1906 |  | 1906
 | Kultura
533 | neinv. trans. přísp. org. |  |  |  | 936 | 936
Celkem |  |  |  |  | 936 | 936
 | Neinvest. účelová dotace [NAME] kraje celkem | 45217 | 129103 | 54501 | 108193.2 | 337014.2
 | Kapitálové výdaje | 5211 | 1692 |  |  | 6903
 | CELKEM | 61576 | 130795 | 54501 | 108193.2 | 355065.2
Spreadsheet: 469288d1467853993-deleting-duplicates-to-only-get-the-highest-value-highest-rate-for-codes
Sheet: Sheet1

Code |  |  | rate
a |  |  | 1
b |  |  | 2
a |  |  | 3
c |  |  | 7
a |  |  | 1
C |  |  | 4
a |  |  | 1
a |  |  | 3
Spreadsheet: 08fb534c-89c2-41ef-9f5c-a8409abe492b
Sheet: Monthly Timesheet

[NAME] University Monthly Timesheet
 | SURNAME |  |  |  |  |  |  |  | PERSONNEL NO  (SEE PAYSLIP)
 | FORENAME |  |  |  |  |  |  |  | MONTH
 | DEPARTMENT |  |  |  |  |  |  |  | WEEKLY CONTRACTED HOURS
 |  | 24 Hour Clock
DATE OF THE MONTH | DAY | START TIME |  | FINISHING TIME |  | TIME TAKEN FOR LUNCH |  | TOTAL HOURS | ADDITIONAL INFORMATION  (for those with multiple contracts please confirm hourly rate)
 |  | hrs | mins | hrs | mins | hrs | mins | **Decimals
Example 10.01.07 | MONDAY | 9 | 30 | 17 | 30 | 1 | 20
 |  |  |  | TOTAL HOURS WORKED
CLAIMANTS SIGNATURE |  |  |  |  |  | DATE
 |  |  |  |  |  |  |  |  | THIS CLAIM FORM HAS BEEN RETURNED BECAUSE:-
AUTHORISATION:- |  |  |  |  |  | DATE |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 1. NO CLAIMANTS SIGNATURE
I CONFIRM THAT I HAVE CHECKED THE TOTAL HOURS WORKED AND I AUTHORISE THAT PAYMENT BE MADE IN RESPECT OF THE TOTAL HOURS STATED |  |  |  |  |  |  |  |  | 2. NO AUTHORITY
COST CENTRE |  | DETAIL CODE |  | PROJECT |  |  | TOTAL HOURS |  | 3. NO COST CENTRE PROVIDED
(4 digits) |  | (4 digits) |  |  |  |  |  |  | 4. OTHER
Finance Use
E&D |  | Hrs |  | E&D |  |  | Hrs
Input by |  | Date |  | Checked by |  |  | Date |  | PLEASE ENSURE YOUR TIME SHEET IS RETURNED TO THE FINANCE DEPARTMENT FOR PROCESSING BEFORE THE PAYROLL DEADLINE
Spreadsheet: 174026d1344888660-array-formula-not-working-sample-attached-indirect-sample-22
Sheet: Data

2011-11-01 00:00:00 | 2011-12-01 00:00:00 | Can not remove | Can not remove | 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
10 | 20 |  |  | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140
Spreadsheet: 166885d1341840146-transposing-date-values-transpose100
Sheet: Sheet1

Card number | Date | helper |  | unique list extracted with advanced filter | Card number
Card A | 2012-06-27 17:29:46 | 1-Card A |  |  | Card A | 2012-06-27 17:29:46 | 2012-06-29 19:36:43 | 2012-06-29 19:59:55
Card A | 2012-06-29 19:36:43 | 2-Card A |  |  | Card B | 2012-06-23 05:47:36 | 2012-06-28 02:15:07
Card A | 2012-06-29 19:59:55 | 3-Card A |  |  | Card C | 2012-06-23 12:41:59 | 2012-06-23 12:51:13
Card B | 2012-06-23 05:47:36 | 1-Card B |  |  | Card D | 2012-06-21 20:11:05 | 2012-06-21 20:16:01
Card B | 2012-06-28 02:15:07 | 2-Card B |  |  | Card E | 2012-06-24 22:46:50 | 2012-06-25 16:01:40
Card C | 2012-06-23 12:41:59 | 1-Card C |  |  | Card F | 2012-06-18 16:53:20 | 2012-06-18 18:21:45 | 2012-06-18 18:54:53 | 2012-06-30 19:41:26
Card C | 2012-06-23 12:51:13 | 2-Card C |  |  | Card G | 2012-06-09 01:30:59 | 2012-06-09 14:32:02 | 2012-06-09 22:53:18 | 2012-06-23 17:06:20 | 2012-06-25 23:51:54
Card D | 2012-06-21 20:11:05 | 1-Card D |  |  | Card H | 2012-06-23 17:59:42 | 2012-06-26 21:35:10
Card D | 2012-06-21 20:16:01 | 2-Card D |  |  | Card I | 2012-06-22 14:12:49 | 2012-06-22 14:19:16
Card E | 2012-06-24 22:46:50 | 1-Card E |  |  | Card J | 2012-06-26 05:07:02
Card E | 2012-06-25 16:01:40 | 2-Card E |  |  | Card K | 2012-06-26 05:11:05
Card F | 2012-06-18 16:53:20 | 1-Card F |  |  | Card L | 2012-06-21 02:26:23 | 2012-06-26 19:47:38 | 2012-06-30 18:24:02
Card F | 2012-06-18 18:21:45 | 2-Card F
Card F | 2012-06-18 18:54:53 | 3-Card F
Card F | 2012-06-30 19:41:26 | 4-Card F
Card G | 2012-06-09 01:30:59 | 1-Card G
Card G | 2012-06-09 14:32:02 | 2-Card G
Card G | 2012-06-09 22:53:18 | 3-Card G
Card G | 2012-06-23 17:06:20 | 4-Card G
Card G | 2012-06-25 23:51:54 | 5-Card G
Card H | 2012-06-23 17:59:42 | 1-Card H
Card H | 2012-06-26 21:35:10 | 2-Card H
Card I | 2012-06-22 14:12:49 | 1-Card I
Card I | 2012-06-22 14:19:16 | 2-Card I
Card J | 2012-06-26 05:07:02 | 1-Card J
Card K | 2012-06-26 05:11:05 | 1-Card K
Card L | 2012-06-21 02:26:23 | 1-Card L
Card L | 2012-06-26 19:47:38 | 2-Card L
Card L | 2012-06-30 18:24:02 | 3-Card L
Spreadsheet: 766217d1643806343-help-needed-with-kpis-in-power-pivot-madrid-kpis-scorecard
Sheet: Compliance training

Percentage of compliance training  completion
Platform / Period | Q1 Total trainings | Q1 Total Complete | Q1 Complete % | Q2 Total trainings | Q2 Total Complete | [NAME] | Q3 Total trainings | Q3 Total Complete | [NAME] % | Q4 Total trainings | Q4 Total Complete | [NAME] %
PolicyTech | 500 | 400 |  | 550 | 481 |  | 550 | 490 |  | 525 | 500
SAI | 500 | 350 |  | 550 | 360 |  | 550 | 370 |  | 525 | 490
[NAME] | 500 | 250 |  | 550 | 265 |  | 550 | 280 |  | 525 | 510
Platform / Period | Sum of Q1 Complete % | Sum of Q2 Complete % | Sum of Q3 Total Complete | Sum of Q4 Complete %
[NAME] | 0.5 | 0.4818181818181818 | 280 | 0.9714285714285714
PolicyTech | 0.8 | 0.8745454545454545 | 490 | 0.9523809523809523
SAI | 0.7 | 0.6545454545454545 | 370 | 0.9333333333333333
Spreadsheet: fc6ca5f0-e516-4120-be80-a88f0166ad6e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3002 | 13382 | [NAME] | Huhn | GER | 728 | 00:43:35 | 00:02:15 | 01:04:33 | 00:02:12 | 00:24:18 | 1 | [NAME]
3002 | 14124 | [NAME] | D'Erbee | BEL | 727 | 00:44:59 | 00:02:04 | 01:21:56 | 00:01:43 | 00:28:10 | 2 | 02:38:52
3002 | 12389 | Geoff | [NAME] | CAN | 730 | [NAME] | 00:03:58 | [NAME] | 00:03:05 | 00:34:31 | 3 | 02:53:04
3002 | 13463 | Piotr | Pytka | POL | 731 | 00:58:00 | 00:02:19 | 01:16:58 | 00:02:50 | 00:35:09 | 4 | 02:55:17
3002 | 16310 | [NAME] | Kadlec | CZE | 726 | 00:55:42 | 00:02:46 | 01:22:09 | 00:03:04 | 00:37:08 | 5 | [NAME]
3002 | 16745 | [NAME] | Maruna | USA | 729 | [NAME] | 00:03:58 | 01:24:17 | [NAME] | 00:36:14 | 6 | 03:03:51
Spreadsheet: 138876d1327979398-countif-formula-usage-test-1-
Sheet: Sheet1

Engineer | Company | Date | Helper column
[NAME] | XYZ Pte Ltd | 2011-01-04 00:00:00 | JohnXYZ Pte Ltd40547
[NAME] | XYZ Pte Ltd | 2011-01-04 00:00:00 | JohnXYZ Pte Ltd40547
[NAME] | ABC Pte Ltd | 2011-01-04 00:00:00 | JohnABC Pte Ltd40547
[NAME] | QWE Pte Ltd | 2011-01-05 00:00:00 | [NAME] Ltd40548
[NAME] | QWE Pte Ltd | 2011-01-05 00:00:00 | [NAME] Ltd40548
[NAME] | ASD Pte Ltd | 2011-01-06 00:00:00 | WilliamASD Pte Ltd40549
[NAME] | ASD Pte Ltd | 2011-01-06 00:00:00 | WilliamASD Pte Ltd40549
[NAME] | ASD Pte Ltd | 2011-01-06 00:00:00 | JohnASD Pte Ltd40549
[NAME] | ASD Pte Ltd | 2011-01-06 00:00:00 | JohnASD Pte Ltd40549
Spreadsheet: 104623d1302161380-searching-data-through-out-the-worksheet-stock-statement-on-7-4-2011
Sheet: SCREENS

l | [NAME] | SICREEN SIZE | SERIAL NO | QTY | INWORD | OUTWORD | STOCK
 | DA-LITE
1 | DA-LITE COSMO-TNST Fixed frame screen (84450EC) |  |  | 1
2 | DA-LITE DR-SNAP Fixed frame screen (78698V) | 65 X 113(133D), 5x9 |  | 1
3 | DA-LITE DR-SNAP Fixed frame screen (87678V) | 65 X 116(133D3AC),5x9 |  | 1
4 | COSMO ,120 D   69X92NPA MW 220 (40789E) | (92 x 69"),   7x5 |  | 1
5 | COSMO ,96 D  57X77NPA MW 220 (74662E) | 6.5' x 4.9'(78"x58) |  | 1
6 | DA-LITE Contour TNSD 106D CHCP 220 Electric Motorised screen | 8 x 6(96x72) | 91483EC | 0
7 | DA-LITE CENIMA COUNTER FIXED FRAME SCREEN | 54X96(8X4 1/2) | 94313V | 1
 | LIBERTY
1 | Liberty matt white wall screen | 5 X 7 (64 X 84") |  | 1
2 | Liberty matt white wall screen | 6 X 6 (70 X 70" ) |  | 1
3 | Liberty wall instalock screen | 6 X 8 (72x96) |  | 17
4 | Wall screen | 5 X 7( 60 X 87" ) |  | 1
 | Indian Type
1 | Wall Screen Boxtype economy | 6 x 4 (72x48) |  | 3
2 | Wall Screen Boxtype economy | 6 x 8 (72x96) |  | 6
3 | [NAME] gain screen | 6 x 4 (72x48) |  | 2
4 | Map type screen front projection high gain | 6 x 4 (72x48) |  | 4
5 | Map type screen front projection economy | 6 x 4 (72x48) |  | 2
6 | Map type screen front projection high gain | 6 x 8 (72x96) |  | 1
7 | Map type screen rear projection economy | 6 x 4 (72x48) |  | 3
8 | Map type screen  high gain | 5 X 5(60x60) |  | 1
9 | Map type screen rear projection economy | 8 x 10 (96x120) |  | 3
10 | Map type screen front projection high gain | 8 x 10(96x120) |  | 3
 | BRAUN
1 | [NAME] white | 6 x 6 (72x72) |  | 1
2 | [NAME] white | 6 x 4(72x48)(171x128) | 881814(lock fail), 1808 | 2
3 | Instalock screen [NAME] | 5 x 7(60x84)(153X203cm) | 794904 | 3
4 | Motorised screen mattwhite | 6 x 8 (72x96) | YM 700731, 700740 | 2
5 | Wall instalock MW | 6x8(72x96)(183x244cm) |  | 1
6 | Wall instalock MW | 6x4(72x48)(171x128) | 882654, 2818, 2732, 2922 | 4
7 | Tripod MW | (183x244cm) | 13707-881834/881853 | 2
8 | Tripod MW | 171 x 128 | 13807-877654/877 | 2
 | GALA
1 | Fixed frame screen | 6 X 4 (72x48) |  | 2
2 | Fixed frame screen | 4 x 2( 61x 108cm) |  | 1
3 | Fixed frame screen | 8 x 4(93 x 52) |  | 1
4 | Fixed frame screen | 9 x 5(1549 x 2890mm) |  | 1
5 | Fixed frame screen | 5 x7 (60x84) |  | 2
 | Not useful
 | Fixed frame screen | 10 x 6 (122 x 71) | only frame without cloth | 1
 | Different brands
 | Local type wall instalock | 5 x 7(60x84) |  | 1
1 | Projection screen wall instalock | 4 x 4 (48x48) |  | 1
2 | Projection screen wall instalock | 9 x 6 (96x72) |  | 1
4 | Screen stands | 6 x8 (72x96) |  | 10
5 | dnP Optical Front Screen ( Supernova) frmae flock | 110" 16:9 | 11-06460 | 1
 | BACK
Spreadsheet: 201606d1356037383-search-a-column-to-return-values-just-above-and-below-the-search-criteria-multreturn
Sheet: Sheet1

769.7522245988471 | 225 | 35 | 20 | Alpha
770.4468423379947 | 235 | 55 | 16 | Bravo
771.0266488117591 | 215 | 60 | 16 | [NAME]
771.7235695548851 | 145 | 80 | 17 | Delta
771.8398455183557 | 295 | 35 | 18 | Echo
772.5382377779109 | 205 | 75 | 14 | Foxtrot
773.1211975106139 | 225 | 40 | 19 | Golf
774.6410184039509 | 255 | 45 | 17 | Hotel
774.7581752427899 | 255 | 40 | 18 | Indigo
774.8753675246298 | 255 | 35 | 19 | [NAME]
774.9925952655561 | 255 | 30 | 20 | Kilo
775.5792664201857 | 215 | 65 | 15 | Lima
775.5792664201857 | 305 | 25 | 20 | [NAME]
775.9316956536393 | 145 | 70 | 18 | November
776.5197900114184 | 225 | 45 | 18 | [NAME]
776.6375158740642 | 295 | 30 | 19 | Papa
778.2894340178253 | 335 | 30 | 18 | Quebec
778.9995521145572 | 125 | 70 | 19 | Romeo
779.35509732319 | 205 | 55 | 17 | Sierra
779.9483944435639 | 225 | 50 | 17 | Tango
780.0671622819136 | 285 | 35 | 18 | Umbrella
780.185966296882 | 215 | 70 | 14 | Victor
Spreadsheet: 823654d1680079955-group-4-data-sets-into-one-boooook
Sheet: Sheet2

ID | Surname | First Name | CODE | Value 1 | ID | Surname | First Name | CODE | Value 2 | ID | Surname | First Name | CODE | Value 3 | ID | Surname | First Name | CODE | Value 4 |  | ID | Surname | First Name | CODE | Value 1 | Value 2 | Value 3 | Value 4
111 | aaa | aaa | xxx | 70 | 111 | aaa | aaa | xxx | 1 | 555 | eee | eee | xxx | 5 | 555 | eee | eee | yyy | 5 |  | 111 | aaa | aaa | xxx | 70 | 1 | 0 | 70
222 | bbb | bbb | ooo | 48 | 222 | bbb | bbb | xxx | 2 |  |  |  |  |  | 111 | aaa | aaa | xxx | 70 |  | 222 | bbb | bbb | ooo | 48 | 0 | 0 | 0
333 | [NAME] | [NAME] | yyy | 59 | 333 | [NAME] | [NAME] | yyy | 3 |  |  |  |  |  |  |  |  |  |  |  | 222 | bbb | bbb | xxx | 0 | 2 | 0 | 0
444 | ddd | ddd | ggg | 84 | 444 | ddd | ddd | yyy | 4 |  |  |  |  |  |  |  |  |  |  |  | 333 | [NAME] | [NAME] | yyy | 59 | 3 | 0 | 0
555 | eee | eee | hhh | 86 | 555 | eee | eee | abc | 5 |  |  |  |  |  |  |  |  |  |  |  | 444 | ddd | ddd | ggg | 84 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 444 | ddd | ddd | yyy | 0 | 4 | 0 | 0
RAW DATA 1 |  |  |  |  | RAW DATA 2 |  |  |  |  | RAW DATA 3 |  |  |  |  | RAW DATA 4 |  |  |  |  |  | 555 | eee | eee | hhh | 86 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | abc | 0 | 5 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | xxx | 0 | 0 | 5 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | yyy | 0 | 0 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Desired Results
Spreadsheet: 50753d1250228734-help-with-conditional-formatting-nrcm-tracker
Sheet: Aco

NAME | [NAME] | BIRTH MONTH | CEF | BAMBI | APU QUAl | GUNNERY | [NAME] | UT
 |  |  | NO | YES
Burger, Brandon | RL1 D/N/NG |  | YES | NO
STINSMAN, CHRISTINA | RL 3 D/N/NG |  | NO | NO
CATES,JASON | [NAME] 3 NVG | 2009-10-01 00:00:00 | YES | YES
BULSON, JUSTIN | [NAME] |  | NO | NO
FAITH, CASEY A. | RL1 D/N/NG | 2009-10-01 00:00:00 | YES | YES
FRYER,GLENN | RL1 D/N/NG | 2009-04-01 00:00:00 | YES | YES
GALLAHER,STEVEN | RL1 D/N/NG | 2009-08-01 00:00:00 | YES | YES
 |  |  | NO | NO
 |  |  | NO | NO
Fenner, [NAME] | RL1 D/N/NG | 2009-08-01 00:00:00 | YES | NO
[NAME], [NAME] | RL1 D/N/NG | 2009-09-01 00:00:00 | YES | NO
MILLER,WILLIAM | RL1 D/N/NG | 2009-02-01 00:00:00 | YES | YES |  |  |  | SI
[NAME], [NAME] | RL 3 D/N/NG |  | NO | NO
KENNEDY, CHRISTOPHER | RL1 D/N/NG | 2009-08-01 00:00:00 | NO | NO
Weaver, Justin | RL1 D/N/NG | 2009-01-01 00:00:00 | YES | YES
WOOLHEATER,RICHARD | RL1 D/N/NG | 2009-11-01 00:00:00 | YES | YES
ZASIMOVICH,VLADIMIR | RL1 D/N/NG | 2009-07-01 00:00:00 | YES | YES
KILPATRICK,JEFFERY | RL1 D/N/NG | 2009-07-01 00:00:00 | YES | YES |  |  |  | SI
MOORE, JUSTIN D. | RL1 D/N/NG | 2009-01-01 00:00:00 | YES | YES
SANTANA, GEINER | RL1 D/N/NG | 2009-09-01 00:00:00 | YES | NO
Spreadsheet: 274185d1383045509-drop-down-to-select-the-method-of-calculating-of-freight-of-different-types-freight-calculator_shared
Sheet: Volumetric 

 | # | Length (Meters) | [NAME] (Meters) | Height | Total Tonnage
 | 1st Shipment | 3.5 | 1.85 | 5
 | 2nd Shipment
 | 3rd Shipment
 | 4th Shipment
 | 5th Shipment
 | 6th Shipment
 | # | Volume\tn | Origin | Destination | Distance/Km | COST | RATE | Total
 | 1st Shipment |  | [NAME] | Bor Port |  | 50
 | 2nd Shipment |  | Mangala Port | ADOK Port |  | 50
 | 3rd Shipment |  | [NAME] | Malakal |  | 50
 | 4th Shipment |  | Mangala Port | [NAME] |  | 50
 | 5th Shipment |  | ADOK Port | Kilo 50 |  | 50
 | 6th Shipment |  | [NAME] | Meluit Port |  | 50
 | Service Offering
 | Date |  | Valid Until |  |  | Quotation#
 | Customer |  |  | Service | Transportation
 | [NAME]:
 | Attention
 | 1.Description of Cargo:
 | Packaging contains shaft drive. #012654852 made in netherland
 |  |  | 2.Service Price:
 | Route |  | Commodity | Quantity/ton | Total
 | From | To
 | Total
 | 4. Terms:
Spreadsheet: 47357d1246388464-put-a-false-cell-into-another-cell-example
Sheet: Sheet3

1LSE | 1LSW | 1LON | 2EA | 3EM | 4NE | 4NW | 5NI |  | Which Area
#N/A | 1LSW | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | I need J2 to pick out the 1LSW from the left
#N/A | #N/A | 1LON | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | I need J3 to pick out the 1LON from the left
#N/A | #N/A | 1LON | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | I need J4 to pick out the 1LON from the left
#N/A | #N/A | #N/A | 2EA | #N/A | #N/A | #N/A | #N/A |  |  | ETC
#N/A | #N/A | #N/A | #N/A | 3EM | #N/A | #N/A | #N/A |  |  | ETC
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 4NW | #N/A |  |  | ETC
1LSE | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | ETC
#N/A | #N/A | #N/A | 2EA | #N/A | #N/A | #N/A | #N/A |  |  | ETC
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 5NI |  |  | ETC
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 5NI |  |  | ETC
#N/A | #N/A | #N/A | #N/A | #N/A | 4NE | #N/A | #N/A |  |  | ETC
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | ETC
#N/A | #N/A | #N/A | #N/A | #N/A | 4NE | #N/A | #N/A |  |  | ETC
Spreadsheet: 216570d1361813780-still-sumif-question-book2-hb-start-over-14-daily-reconciliation-6
Sheet: 2

Page 2 |  |  |  |  |  |  |  |  | CASH OUT #
 |  |  | CAMPSITE SALES CONTINUATION SHEET
Prepared By: |  | [NAME] |  |  |  |  | DEPT: |  |  |  |  |  |  | Work Sheet Page 2
Opening Date: |  |  |  |  |  |  | Closing Date:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number
 | Permit #/ |  | NRRS | GA |  |  |  |  |  |  |  |  |  |  | Permit #/ |  | Site |  |  | Camping | Utility | Number |  | Actual $ | CK |  |  |  | Extra |  | Actual | CK |  |  |  | Total | Total | Total
 | Envelopes |  |  |  | Cash | Check | Credit | Cash | Check | Credit | TOTALS |  |  |  | Envelopes | Date | Number | NRRS | GA | Fee/Day | Fee/Day | Of Days | $$$$$$$$ | Paid | C | Ccash | Ccheck | Ccredit | Vehicles | $$$$$$$$ | Paid | C | EVCash | EVCheck | EVCredit | Cash | Check | Credit | TOTALS
11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 2013-02-17 00:00:00 | 1 |  |  | 19 |  | 1 |  |  | C
12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 2013-02-17 00:00:00 | 36 |  |  | 19 |  | 3 |  | 72 | C |  |  |  | 1 |  |  | C
13 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  | 2013-02-23 00:00:00 | 2 |  |  | 19 |  | 2 |  |  | C |  |  |  | 2 |  |  | C
29 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
32 |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
33 |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
Totals This Page
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cash | Cash
Spreadsheet: 63759d1264624895-lookup-multi-columns-w-multi-answers-masterex
Sheet: DATABASE

MAP | LOT | BLOCK | STREET # | STREET NAME | REVAL | REVAL | YEAR | APPRA | DATE | REVAL | PICKUP | PICKUP | YEAR | APPRA | DATE | PICKUP | OTHER | OTHER | YEAR | APPRA | DATE | OTHER | TODAYS | DONE
 |  |  |  |  | M+L | M |  | ISER | LISTED | DE | M+L | M |  | ISER | LISTED | DE | M+L | M |  | ISER | LISTED | DE | DATE
1 | 1 | 0 |  | BEACH POND ROAD
1 | 2 | 0 | 1055 | BEACH POND ROAD
2 | 1 | 0 |  | PORK HILL ROAD
2 | 2 | 0 |  | PORK HILL ROAD
3 | 1 | 0 |  | PORK HILL ROAD (BACK
5 | 1 | 0 | 1017 | BEACH POND ROAD
5 | 2 | 0 | 999 | BEACH POND ROAD
5 | 3 | 0 | 975 | BEACH POND ROAD
5 | 4 | 0 |  | BEACH POND ROAD
5 | 5 | 0 | 960 | BEACH POND ROAD |  |  |  |  |  |  |  |  | 2010 |  | TD
6 | 1 | 0 | 100 | PORK HILL ROAD
6 | 2 | 0 | 72 | PORK HILL ROAD
6 | 3 | 0 | 92 | PORK HILL ROAD
8 | 1 | 0 | 231 | PORK HILL ROAD |  |  |  |  |  |  |  | 1 | 2010 | KS | 2009-12-28 00:00:00 | AS
8 | 2 | 0 |  | PORK HILL ROAD (BACK
9 | 1 | 0 | 1642 | CENTER STREET |  |  |  |  |  |  |  | 1 | 2010 | KS | 2009-12-28 00:00:00 | AS
9 | 2 | 0 |  | PORK HILL ROAD
9 | 3 | 0 | OFF | [NAME] ROAD
11 | 1 | 0 | 6 | ALBERG ROAD
11 | 2 | 0 | 5 | ALBERG ROAD
11 | 3 | 0 | 7 | ALBERG ROAD
11 | 4 | 0 | 9 | HERITAGE ROAD
11 | 5 | 0 | 15 | BISHOPS GATE ROAD | 1 |  | 2009 | KM | 2010-01-16 00:00:00 | KM
11 | 6 | 0 | 13 | BISHOPS GATE ROAD
11 | 7 | 0 |  | BISHOPS GATE ROAD
11 | 8 | 0 |  | BISHOPS GATE ROAD
11 | 9 | 0 | 7 | BISHOPS GATE ROAD
11 | 10 | 0 |  | BISHOPS GATE ROAD
11 | 11 | 0 | 16 | BISHOPS GATE ROAD
11 | 12 | 0 | 18 | BISHOPS GATE ROAD |  |  |  |  |  |  |  | 1 | 2010 | KS | 2009-12-28 00:00:00 | AS
111 | 2 | 0 | 72 | [NAME] ROAD |  |  |  |  |  |  |  |  | 2010
111 | 7 | 0 | 49 | [NAME] ROAD |  |  |  |  |  |  |  | 1 | 2010 | DJW | 2009-12-30 00:00:00
Spreadsheet: 861569d1709458473-need-to-count-number-of-tiimes-same-employee-with-same-certification-in-an-excel-sheet-formula-to-calculate-no-of-times-each-employee-attended-same-training
Sheet: Sheet1

EMP ID | Name | Course Attended | Certified | No of times attended
510931 | Vijay | AZ-500 | 2023-03-12 00:00:00 | 2 |  | In cell E2 to E10 need formula. Cell E2 should look for employee id in column A from A2:10 , against course from C2 : C10 and it should get the number of times the employee has certified the same course in different dates from column " D"   For example : Employee 510931 has certified AZ-500 but it has two dates ( 12-Mar-2023 ) so what i need in E2 & E3 it should show me 2 , if an employee has certified only once
510931 | Vijay | AZ-500 | 2023-03-12 00:00:00 | 2
510931 | Vijay | SC-200 | 2023-09-15 00:00:00 | 1
542484 | Madhu | AZ-900 | 2024-01-01 00:00:00 | 2
542484 | Madhu | AZ-900 | 2016-06-15 00:00:00 | 2
542484 | Madhu | AZ-500 | 2016-09-15 00:00:00 | 1
517047 | Sruthi | MS-900 | 2016-03-05 00:00:00 | 1
435583 | Priya | MS-500 | 2016-11-02 00:00:00 | 1
505899 | Narayan | AZ-900 | 2016-06-12 00:00:00 | 1