tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 684558d1593442734-showing-organizational-reporting-relationships-in-a-table-sample-indented-report
Sheet: Sheet1

Level 1 | Level 2 | Level 3 | Level 4 | Level 5 | Level 6 | Level 7 | Level 8 | Level 9 | Level 10 | Position Title | Posision# | Supervisor Posision
92858 |  |  |  |  |  |  |  |  |  | VP, REGIONAL OPERATIONS | 92858
 | 96267 |  |  |  |  |  |  |  |  | REG EXEC OFFICER | 96267 | 92858
 |  | 96269 |  |  |  |  |  |  |  | REGIONAL DENTAL OFFICER | 96269 | 96267
 |  | 96277 |  |  |  |  |  |  |  | Director of Professional Pract | 96277 | 96267
 |  |  | 96319 |  |  |  |  |  |  | ADMIN ASSIST | 96319 | 96277
 |  |  | 96325 |  |  |  |  |  |  | MGR, AREA NURSING PROG | 96325 | 96277
 |  |  |  | 96296 |  |  |  |  |  | COMMUNITY HEALTH NURSE | 96296 | 96325
 |  |  |  | 96404 |  |  |  |  |  | COMMUNITY HEALTH NURSE | 96404 | 96325
 |  |  | 96329 |  |  |  |  |  |  | CLINICAL NURSE SPECIALIST-HLD | 96329 | 96277
 |  |  | 96330 |  |  |  |  |  |  | CLINICAL NURSE SPECIALIST-AMH | 96330 | 96277
 |  |  | 96343 |  |  |  |  |  |  | CLINICAL NURSE SPECIALIST-CYMH | 96343 | 96277
 |  |  | 143555 |  |  |  |  |  |  | SR EPID/BIO-STAT | 143555 | 96277
 |  | 96291 |  |  |  |  |  |  |  | MEDICAL OFFICER, REGIONAL | 96291 | 96267
 |  | 96323 |  |  |  |  |  |  |  | (M)MGR,PLCY DVLPMNT/SR.POL.ADV | 96323 | 96267
 |  |  | 96336 |  |  |  |  |  |  | POLICY ANALYST | 96336 | 96323
 |  |  | 96352 |  |  |  |  |  |  | ADMIN ASSIST | 96352 | 96323
 |  |  | 96357 |  |  |  |  |  |  | POLICY ANALYST | 96357 | 96323
Spreadsheet: 031c684c-0551-4a15-9b63-dcf91b773da3
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2497 | 13031 | Marijke | Zeekant | NED | 274 | 00:58:13 | 00:00:00 | [NAME] | 00:03:38 | 02:22:21 | 1 | 06:50:39
2497 | 13030 | Karin | Schulz | GER | 273 | 01:20:15 | 00:00:00 | [NAME] | 00:05:55 | 02:51:06 | 2 | 08:18:33
2497 | 13029 | Heidemarie | Michaelis-Steck | GER | 272 | 01:28:58 | 00:00:00 | 04:05:07 | 00:04:29 | 02:44:36 | 3 | 08:23:07
2497 | 13028 | Montserrat | Clavero | ESP | 271 | 01:19:39 | 00:00:00 | 04:15:01 | 00:04:02 | [NAME] | 4 | 08:26:42
Spreadsheet: 0021d934-70bc-4f56-808f-b8bda2f64a4b
Sheet: Sheet1

 | Credit  Headcount At Census
 | MSJC I-15 Corridor / TEM Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12
Male
Female
Undeclared
Term Total
Academic Year
% of Total | Credit Headcount % of Total
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12
Male
Female
Undeclared
Success Rate | Success Rate
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12
Male
Female
Undeclared
Term Average
Success rate = # of “A, B, C, CR & P” grades divided by (the # of all grades) “A, B, C, CR, P, D, F, NC, NP, I and W”
Note: district totals exclude dual enrollment data
Spreadsheet: 29fdaa6c-1558-4088-9c75-9c7c7267c59c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Risk Parity II HV Fund
 | [NAME]
 | Inception Date | 2012-11-05 00:00:00
 |  |  |  | 60/40
 |  |  |  | Blended
 |  | Class I | Class N | S&P / Barc
 | Date | QRHIX | QRHNX | Custom Index
** | 2012-11-30 00:00:00 | 0.02200000000000002 | 0.02200000000000002 | 0.001828994995952371
 | 2012-12-31 00:00:00 | 0.002349964183449904 | 0.001806903365910939 | 0.005037693446102942
 | 2013-01-31 00:00:00 | 0.03232125367286964 | 0.032258064516129 | 0.02801006894224467
 | 2013-02-28 00:00:00 | -0.00189753320683117 | -0.001893939393939448 | 0.01032291530777552
 | 2013-03-31 00:00:00 | 0.03136882129277585 | 0.03130929791271342 | 0.02273670456072008
 | 2013-04-30 00:00:00 | 0 | 0 | 0.01583695293272869
 | 2013-05-31 00:00:00 | -0.053456221 | -0.054277829 | 0.00685636198123496
 | 2013-06-30 00:00:00 | -0.1012658227848101 | -0.1011673151750972 | -0.01402606676892149
 | 2013-07-31 00:00:00 | 0.03033586132177679 | 0.03138528138528129 | 0.0308725677342685
 | 2013-08-31 00:00:00 | -0.01261829652996838 | -0.01364113326337868 | -0.0193464938695751
 | 2013-09-30 00:00:00 | 0.0319488818 | 0.0319148936 | 0.02262840795755561
 | 2013-10-31 00:00:00 | 0.0392156863 | 0.0391752577 | 0.03081525070913016
 | 2013-11-30 00:00:00 | -0.0009930486593843213 | -0.002976190476190466 | 0.01674754374759413
 | 2013-12-31 00:00:00 | -0.013800461 | -0.012819168 | 0.01291297287858573
 | 2014-01-31 00:00:00 | -0.001013171225937248 | -0.002026342451874386 | -0.01493082791052591
 | 2014-02-28 00:00:00 | 0.05679513184584 | 0.05685279187817 | 0.02956716534582782
 | 2014-03-31 00:00:00 | -0.008637236084 | -0.008645533141 | 0.004494505097759838
 | * annualized for periods 1 year or greater
 | ** partial month return, inception date 11/5/2012
 | Risk Parity II HV Fund
 | [NAME]
 |  |  |  | 60/40
 |  |  |  | Blended
 | Month-end Returns as of | Class I | Class N | S&P / Barc
 | March 31, 2014 | QRHIX | QRHNX | Custom Index
 | 1 Year | -0.04299059312008591 | -0.04567615287005877 | 0.1275361062399001
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.04181469216239853 | 0.03820855343499341 | 0.2059458826859579
 | Since Inception Annualized Return | 0.02969234505292406 | 0.02714524257074991 | 0.143118621115121
* | Since Inception Annualized Monthly Volatility | 0.130197584242301 | 0.1306480869098777 | 0.05581173792570589
 | Since Inception [NAME] | 0.2280560367208186 | 0.2077737471156004
 |  |  |  | 60/40
 |  |  |  | Blended
 | Quarter-end Returns as of | Class I | Class N | S&P / Barc
 | March 31, 2014 | QRHIX | QRHNX | Custom Index
 | 1 Year | -0.04299059312008591 | -0.04567615287005877 | 0.1275361062399001
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.04181469216239853 | 0.03820855343499341 | 0.2059458826859579
 | Since Inception Annualized Return | 0.02969234505292406 | 0.02714524257074991 | 0.143118621115121
Spreadsheet: jim_schwieger__14297__Bronco Division Rescheduled Games _3
Sheet: Sheet2

School | Team | Win | Loss | Tie | Standing
Bronco-Gray
[NAME] | Angels | 7 | 2 | 0
[NAME] | White Sox | 1 | 8 | 0
[NAME] | Padres | 3 | 4 | 0
Bleyl | Astros | 5 | 2 | 1
Bleyl | [NAME] | 0 | 5 | 2
Bleyl | Mariners | 0 | 8 | 0
Campbell | Tigers | 1 | 7 | 0
[NAME] | Cardinals | 4 | 3 | 0
[NAME] | Rockies | 9 | 0 | 0
[NAME] | Rangers | 8 | 2 | 0
[NAME] | Cubs | 2 | 5 | 0
[NAME] | Pirates | 2 | 4 | 2
Labay | Yankees | 8 | 1 | 0
Labay | Reds | 2 | 6 | 1
Labay | Mets | 7 | 0 | 0
[NAME] | Red Sox | 6 | 1 | 0
[NAME] | D'Backs | 4 | 4 | 0
[NAME] | Braves | 3 | 4 | 1
Truitt | Dodgers | 5 | 3 | 1
Truitt | Twins | 1 | 8 | 0
School | Team | Win | Loss | Tie | Standing
Bronco-Maroon
[NAME] | Angels | 5 | 5 | 0
Bleyl | [NAME] | 0 | 6 | 2
Campbell | Astros | 0 | 6 | 1
[NAME] | Reds | 7 | 2 | 1
[NAME] | Cardinals | 3 | 3 | 0
[NAME] | A's | 4 | 3 | 3
Labay | Braves | 7 | 2 | 0
Truitt | Dodgers | 5 | 5 | 1
Spreadsheet: 157135d1337627045-merging-2-pivot-tables-to-calculate-fail-rate-pivot-example
Sheet: Sheet1

Trucks Built |  |  | Warranty
Complete Date | Serial # |  | Claim # | Complete Date | Serial #
2012-01-05 00:00:00 | 12345 |  | C1 | 2012-01-05 00:00:00 | 12345
2012-01-09 00:00:00 | 12346 |  | C2 | 2012-01-09 00:00:00 | 12346
2012-01-13 00:00:00 | 12347 |  | C5 | 2012-01-21 00:00:00 | 12349
2012-01-17 00:00:00 | 12348 |  | C6 | 2012-01-25 00:00:00 | 12350
2012-01-21 00:00:00 | 12349 |  | C7 | 2012-01-29 00:00:00 | 12351
2012-01-25 00:00:00 | 12350 |  | C8 | 2012-02-02 00:00:00 | 12352
2012-01-29 00:00:00 | 12351 |  | C9 | 2012-02-06 00:00:00 | 12353
2012-02-02 00:00:00 | 12352 |  | C10 | 2012-02-10 00:00:00 | 12354
2012-02-06 00:00:00 | 12353 |  | C15 | 2012-03-01 00:00:00 | 12359
2012-02-10 00:00:00 | 12354 |  | C16 | 2012-03-05 00:00:00 | 12360
2012-02-14 00:00:00 | 12355 |  | C17 | 2012-03-09 00:00:00 | 12361
2012-02-18 00:00:00 | 12356 |  | C18 | 2012-03-13 00:00:00 | 12362
2012-02-22 00:00:00 | 12357 |  | C19 | 2012-03-17 00:00:00 | 12363
2012-02-26 00:00:00 | 12358
2012-03-01 00:00:00 | 12359
2012-03-05 00:00:00 | 12360
2012-03-09 00:00:00 | 12361
2012-03-13 00:00:00 | 12362
2012-03-21 00:00:00 | 12364 |  |  |  |  |  | This what I want calculated in a pivot table
2012-03-25 00:00:00 | 12365
# of Trucks Built |  |  | # of Claims |  |  |  | [NAME]
Row Labels | Count of Serial # |  | Row Labels | Count of Serial #
2012 |  |  | 2012 |  |  |  | 2012
Jan | 7 |  | Jan | 5 |  |  | Jan
Feb | 7 |  | Feb | 3 |  |  | Feb
Mar | 6 |  | Mar | 5 |  |  | Mar
Grand Total | 20 |  | Grand Total | 13 |  |  | Grand Total
Spreadsheet: 291722d1390387812-copying-code-down-a-column-without-all-cell-references-updating-corrected-messy-formula-rj-tms-v2
Sheet: Price Table

Product Code: | Description | Per | PG0 | PG1 | PG4 | PG7 | PG9 | PG12 | PG15 | PG18 | PG20 | PG22 | PG25 | PG28 | PG31 | PG34 | PG37 | PGC | PGD | PGE | PGF
[NAME] | 600[NAME] drawer pack, 1 deep 2 shallow | pce | 567 | 662 | 698 | 764 | 788 | 812 | 846 | 875 | 898 | 931 | 973 | 1026 | 1105 | 1173 | 1239 | 1339 | 1439 | 1539 | 1639
B6DP1D2SH | 600[NAME] drawer pack, 1 deep 2 shallow | pce | 696 | 791 | 827 | 893 | 917 | 941 | 975 | 1004 | 1027 | 1060 | 1102 | 1155 | 1234 | 1302 | 1368 | 1468 | 1568 | 1768 | 1868
B6DP1D3S | 600[NAME] drawer pack, 1 deep 3 shallow | pce | 679 | 789 | 829 | 915 | 926 | 964 | 1006 | 1036 | 1068 | 1096 | 1128 | 1209 | 1322 | 1401 | 1482 | 1582 | 1682 | 1782 | 1882
B6DP1DH | 600[NAME] drawer pack, 375 high, 1 deep | pce | 407 | 455 | 481 | 506 | 526 | 533 | 555 | 579 | 595 | 619 | 660 | 692 | 735 | 775 | 817 | 917 | 1017 | 1117 | 1217
B6DP1DWH | 600[NAME] drawer pack, 375 high, 1 deep (to fit under worktop) | pce | 407 | 455 | 481 | 506 | 526 | 533 | 555 | 579 | 595 | 619 | 660 | 692 | 735 | 775 | 817 | 917 | 1017 | 1117 | 1217
B6DP1S1NH | 600[NAME] drawer pack, 375 high, 1 shallow 1 shallow internal | pce | 474 | 522 | 548 | 572 | 592 | 600 | 621 | 645 | 662 | 686 | 726 | 759 | 801 | 842 | 883 | 983 | 1083 | 1183 | 1283
B6DP1S1NWH | 600[NAME] drawer pack, 375 high, 1 shallow 1 shallow internal | pce | 474 | 522 | 548 | 572 | 592 | 600 | 621 | 645 | 662 | 686 | 726 | 759 | 801 | 842 | 883 | 983 | 1083 | 1183 | 1283
B6DP2D | 600[NAME] drawer pack, 2 deep | pce | 497 | 570 | 611 | 649 | 680 | 691 | 724 | 762 | 787 | 823 | 887 | 935 | 1001 | 1063 | 1127 | 1227 | 1337 | 1457 | 1567
Spreadsheet: 09308d73-c4b4-4382-8a08-ccddc7208d2b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Verbal Translation Services
 | Quarterly Translation Report
Name
Department
Quarter Reported (check one)
____ | 1 October,November, December
____ | 2 January, February, March
____ | 3 April, May, June
____ | 4 July, August, September
Date | Depart./Cust. | Description of Need | Time spent
 |  | Total time for quarter
Please forward to Human Resources by the fifth business day of the following quarter
Spreadsheet: fee4cc19-512f-4c57-88e0-8e31af76e048
Sheet: Sheet1

2004 official [NAME] | Unnamed: 1 | Unnamed: 2
State of North Dakota Results
Precincts Reporting: 604/604 - Total Ballots Cast: 92213
Downloaded at 5/21/2013 2:00:48 AM
 | Yes - | No -
C 1: Allows a corporation to adopt bylaws similar to those of cooperative associations dealing with electing directors and issuing stock. - | 31461 | 44038
TOTAL | 31461 | 44038
 | Yes - | No -
C 2: Allows the legislative assembly to provide a procedure for determining the fiscal impact of initiated measures & for making that infor. available. - | 54047 | 23811
TOTAL | 54047 | 23811
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: lynn_blair__24330__WPLAcctsRec122801
Sheet: Sheet1

Accounts Receivable Over 90 Days Past Due
SHIPPER | INVOICE NO. | CHG TYPE | ACCT MONTH | TOTAL | COMMENTS
Wisconsin Power & Light | T17996031036 | COM | 199603 | 3560.39 | D. Neubauer approved to waive (12/10/01 [NAME])
Wisconsin Power & Light | T17996098545 | COM | 199609 | 567 | D. Neubauer approved to waive (12/10/01 [NAME])
Wisconsin Power & Light | T17997024344 | COM | 199702 | 396.25 | D. Neubauer approved to waive (12/10/01 [NAME])
Wisconsin Power & Light | TPPA97061428 | PEN | 199706 | 21.74 | D. Neubauer approved to waive (12/10/01 [NAME])
Wisconsin Power & Light | TPPA97083327 | COM | 199708 | -50.63 | D. Neubauer approved to waive (12/10/01 [NAME])
Wisconsin Power & Light | TPPA97084385 | PEN | 199708 | 110.11 | D. Neubauer approved to waive (12/10/01 [NAME])
Wisconsin Power & Light | TPPA97083328 | COM | 199708 | 321.26 | D. Neubauer approved to waive (12/10/01 [NAME])
Wisconsin Power & Light | TPPA97095917 | PEN | 199709 | -46.76 | D. Neubauer approved to waive (12/10/01 [NAME])
Wisconsin Power & Light | TPPA98012311 | PEN | 199801 | -75.69 | D. Neubauer approved to waive (12/10/01 [NAME])
Wisconsin Power & Light | TPPA98073271 | PEN | 199807 | 19897.14 | D. Neubauer approved to waive (12/10/01 [NAME])
Wisconsin Power & Light | T17995126969 | RES | 199512 | 2180 | D. Neubauer approved to waive (12/10/01 [NAME])
Wisconsin Power & Light | T17998012310 | PEN | 199801 | 414.35 | [NAME] authorized to waive on 12/19/01
Wisconsin Power & Light | TPPA99014398 | PEN | 199901 | 56.89 | [NAME] authorized to waive on 12/19/01
Wisconsin Power & Light | IPPA99013033 | IMB | 199901 | 1829.25 | [NAME] authorized to waive on 12/19/01
Total
Wisconsin Gas Company | IPPA01036654 | IMB | 200103 | -16141.32 | [NAME] indicated this credit was held out of invoice packet as WGC applied credit to payment.
 |  |  |  |  | The system did not reverse out credit.
TOTAL
Spreadsheet: 220082d1363049282-indexing-return-value-from-a-certain-row-and-column-testdataset
Sheet: test1

 | Blended AHT Dish |  |  |  | CET/QA Dish |  |  |  | CSAT Dish |  |  |  | Reliability |  |  |  | Sales Conversion % Dish |  |  |  | Sched Adherence % |  |  |  | Tech Portal Dish
NAME | Metric Value | Percent to Target | [NAME] | Metric Score | Metric Value | Percent to Target | [NAME] | Metric Score | Metric Value | Percent to Target | [NAME] | Metric Score | Metric Value | Percent to Target | [NAME] | Metric Score | Metric Value | Percent to Target | [NAME] | Metric Score | Metric Value | Percent to Target | [NAME] | Metric Score | Metric Value | Percent to Target | [NAME] | Metric Score
[NAME], Alejandro | 0.8864 | 77.28 | 25 | 0.1932 | 0 | 0 | 0 | 0.2252 | 0 | 0 | 0 | 0.2143 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2522 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Campos, Efrain | 0.9789 | 95.78 | 25 | 0.2395 | 0 | 0 | 0 | 0.2391 | 0 | 0 | 0 | 0.2543 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2822 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME], [NAME] | 0.9827 | 96.54 | 25 | 0.2414 | 0 | 0 | 0 | 0.2333 | 0 | 0 | 0 | 0.1964 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1739 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME], [NAME] | 0.9728 | 94.56 | 25 | 0.2364 | 0 | 0 | 0 | 0.2229 | 0 | 0 | 0 | 0.1875 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2189 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Galarza, [NAME] | 0.9677 | 93.54 | 25 | 0.2339 | 0 | 0 | 0 | 0.2284 | 0 | 0 | 0 | 0.2143 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3886 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME], [NAME] | 0.9707 | 94.14 | 25 | 0.2354 | 0 | 0 | 0 | 0.2306 | 0 | 0 | 0 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3657 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Gutierrez, [NAME] | 0.9461 | 89.22 | 25 | 0.2231 | 0 | 0 | 0 | 0.2322 | 0 | 0 | 0 | 0.2857 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1643 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Gutierrez, [NAME] | 0.9732 | 94.64 | 25 | 0.2366 | 0 | 0 | 0 | 0.2039 | 0 | 0 | 0 | 0.2245 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2268 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Viurquiz, [NAME] | 1.0787 | 115.74 | 25 | 0.2894 | 0 | 0 | 0 | 0.2408 | 0 | 0 | 0 | 0.2143 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2689 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Test
Spreadsheet: 464645d1465236653-dynamic-weighted-average-problem-excelforumexample
Sheet: Dashboard

 |  |  |  |  |  | Trying to replace Orange
 | [NAME]? | N
 | Unweighted |  |  |  |  | Total Weights |  | (Currently trying to create) |  | 9
 | Weighted |  |  |  | Absolute Value | Weights | Weighted Value | Importance Weight
 | Evenly Weighted |  |  |  |  | 0.2
 | Importance Weight |  | Importance? |  |  | 0.1
 | A | Low | High |  |  | 0.2
 | B | Large | High |  |  | 0.15
 | C | Introduction | High |  |  | 0.1
 | D | Introduction | High |  |  | 0.05
 | E | High | High |  |  | 0.05
 | F | High | High |  |  | 0.05
 | G | High | High |  |  | 0.05
 | H | High | High |  |  | 0.05
 |  |  |  | Total
 | User has to manually input weights on the [NAME],  I want to have the user choose importance on individual values (to make things more simple for the user) and then relate those importance variables to the relationships and create a weighted value from it.
Spreadsheet: 714065d1611077557-sum-with-multiple-criteria-sumifs-query-v3
Sheet: Sheet1

 |  | TABLE A
 |  |  |  |  |  |  |  | 2020/21 | 2020/21 | 2020/21
 |  | CostCtre | DeptCode | Job Number | Project Number i.e. this is the NOC, NPFC or AT number | Project Header | Activity | Period Number | Period Number | Period Number
 |  |  |  |  |  |  |  | 10 | 11 | 12
 |  | ABC | DEP | 123 |  | Labour_Solutions | Start Up | 1644.522530953505 | 1644.522530953505 | 1644.522530953505
 |  | DEF | DEP | 123 |  | Labour_Solutions | Feasibility | 27359.39386884803 | 27359.39386884803 | 27359.39386884803
 |  | GHI | DEP | 123 |  | Labour_Solutions | Closure | 48410.2402067556 |  | 48410.2402067556
 |  | JKL | DEP | 123 |  | Labour_Solutions | Invoicing | 3979.475667812074 | 3979.475667812074 | 3979.475667812074
 |  | MNO | DEP | 123 |  | Labour_Quality | Implementation | 16018.07660019648 | 16018.07660019648
 |  | PQR | DEP | 123 |  | Labour_Quality | Documentation | 8009.038300098238 | 8009.038300098238
 |  | TABLE B
 |  | Project | Project Header | Phase | Stage | Activity | Period Number | Period Number | Period Budget
 |  | 123 | Labour_Solutions |  |  | Start Up | 10 | 2020 | 1644.522530953505
 |  | 123 | Labour_Solutions |  |  | Feasibility | 10 | 2020 | 27359.39386884803
 |  | 123 | Labour_Solutions |  |  | Closure | 10 | 2020 | 48410.2402067556
 |  | 123 | Labour_Solutions |  |  | Invoicing | 10 | 2020 | 3979.475667812074
 |  | 123 | Labour_Quality |  |  | Implementation | 10 | 2020 | 16018.07660019648
 |  | 123 | Labour_Quality |  |  | Documentation | 10 | 2020 | 8009.038300098238
 |  | 123 | Labour_Solutions |  |  | Start Up | 11 | 2020 | 1644.522530953505
 |  | 123 | Labour_Solutions |  |  | Feasibility | 11 | 2020 | 27359.39386884803
 |  | 123 | Labour_Solutions |  |  | Closure | 11 | 2020
 |  | 123 | Labour_Solutions |  |  | Invoicing | 11 | 2020 | 3979.475667812074
 |  | 123 | Labour_Quality |  |  | Implementation | 11 | 2020 | 16018.07660019648
 |  | 123 | Labour_Quality |  |  | Documentation | 11 | 2020 | 8009.038300098238
 |  | 123 | Labour_Solutions |  |  | Start Up | 12 | 2020 | 1644.522530953505
 |  | 123 | Labour_Solutions |  |  | Feasibility | 12 | 2020 | 27359.39386884803
 |  | 123 | Labour_Solutions |  |  | Closure | 12 | 2020 | 48410.2402067556
 |  | 123 | Labour_Solutions |  |  | Invoicing | 12 | 2020 | 3979.475667812074
 |  | 123 | Labour_Quality |  |  | Implementation | 12 | 2020
 |  | 123 | Labour_Quality |  |  | Documentation | 12 | 2020
 |  |  |  |  | Hi, How do I get the values in col H, I & J from table A into the table below by Project header, Project Activity code and Period Number please?  I think it is some form of sumifs statement, but nothing I do is working.  Hoping someone can advise please.  Thank you so much in advance!  [NAME]
Spreadsheet: 002d0a45-2785-4297-9f37-03f253ea2074
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Direct Pay / General Encumbrance
This payment form is designed to facilitate and expedite departmental requests for payment.
Complete the form, scan the original paperwork and e-mail to [EMAIL] for processing.
Keep a copy for department records.
Banner Vendor Number
(if known)
Vendor/Payee’s ID Number:
 |  |  | Check the appropriate box:
 |  |  | FIN – Federal Tax Identification Number, or         SSN – Social Security Number
Vendor/Payee’s Name:
Vendor/Payee’s Address:
Business Purpose/Justification:
Total Amount: |  |  | QAR |  |  | USD
Banner Account Distribution: |  |  | Index |  | Account |  | Amount
 |  |  |  |  |  |  | QAR |  | USD
 |  |  |  |  |  |  | QAR |  | USD
 |  |  |  |  |  |  | QAR |  | USD
 |  |  |  |  |  |  | QAR |  | USD
 |  |  |  |  |  |  | QAR |  | USD
Direct Pay: |  |  | Research/Survey Participant |  |  | Petty Cash Custodian
General Encumbrance: |  |  | Sub Award
Department Contact:
 |  |  | Signature                                Printed Name                              Date
Requestor Signature:
 |  |  | Signature                                Printed Name                              Date
Approver Signature:
 |  |  | Signature                               Printed Name                               Date
I have a bank account in Qatar for my deposit. |  |  |  |  |  | AP USE ONLY
I do not have a bank account in Qatar. Please |  |  |  |  | Document Number:
deposit to my U.S. account.
 |  |  |  |  | Signature:
 |  |  |  |  | Date:
Revised July 2012
Spreadsheet: 707885d1607525196-how-to-assign-a-country-to-a-specific-area-dashboard
Sheet: MORROCO

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: daren_farmer__5512__tufco
Sheet: Sheet1

2000 |  | IFERC |  |  |  | WAGNER BROWN |  |  |  | GAS DAILY |  |  | DECEMBER MAKE UP GAS IFHSC + .13
 | TUFCO | US | PAID | DIFF | TUFCO | US | PAID | DIFF | TUFCO | US | PAID | DIFF | TUFCO | US | PAID | DIFF
Jan | 775000 | 775000 |  |  | 930000 | 930000 | 930000 |  | 917457 | 917457 |  |  | 30000 | 30000
Feb | 725000 | 725000 |  |  | 870000 | 870000 | 870000 |  | 421918 | 421918
Mar | 775000 | 775000 |  |  | 930000 | 930000 | 930000 |  | 327081 | 347081 | 327081
Apr | 600000 | 600000 |  |  | 900000 | 900000 |  |  | 495582 | 495582
May | 1240000 | 1240000 |  |  | 930000 | 930000 |  |  | 1033416 | 1033416
Jun | 1950000 | 1950000 |  |  | 1200000 | 1200000 |  |  | 475417 | 475417
Jul | 2015000 | 2015000 |  |  | 1240000 | 1240000 |  |  | 328750 | 328750
Aug | 2015000 | 2015000 |  |  | 1240000 | 1240000 |  |  | 910127 | 910127
Sep
Oct
Nov
Dec