tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 733630d1621673076-get-remarks-value-base-on-the-code-no-and-unique-no-for-asking-2021-0522-ans
Sheet: Data

NAME | NO. | CODE NO. | MARKS |  |  | Expected Result
TEST_001 | 1 | 111-221 | o |  |  | CODE NO. | MARKS
TEST_001 | 1 | 111-222 | o |  | 1 | 111-221 | o
TEST_001 | 1 | 111-223 |  |  | 1 | 111-222 | o
TEST_001 | 1 | 111-224 |  |  | 1 | 111-223
TEST_001 | 1 | 111-225 |  |  | 1 | 111-224
TEST_001 | 2 | 111-225 |  |  | 1 | 111-225 | o
TEST_001 | 3 | 111-225 |  |  | 2 | 111-225 | x
TEST_001 | 1 | 111-226 |  |  | 3 | 111-225 | x
TEST_001 | 2 | 111-226 |  |  | 1 | 111-226 | o
TEST_001 | 1 | 111-227 |  |  | 2 | 111-226 | o
TEST_001 | 2 | 111-227 |  |  | 1 | 111-227 | o
TEST_001 | 3 | 111-227 |  |  | 2 | 111-227 | o
TEST_001 | 4 | 111-227 |  |  | 3 | 111-227 | x
TEST_001 | 5 | 111-227 |  |  | 4 | 111-227 | x
TEST_001 | 6 | 111-227 |  |  | 5 | 111-227 | x
TEST_001 | 1 | 111-228 |  |  | 6 | 111-227 | o
TEST_001 | 2 | 111-228 |  |  | 1 | 111-228 | x
TEST_001 | 3 | 111-228 |  |  | 2 | 111-228 | x
TEST_002 | 1 | 111-221 |  |  | 3 | 111-228 | o
TEST_002 | 1 | 111-222
TEST_002 | 1 | 111-223
TEST_002 | 1 | 111-224
TEST_002 | 1 | 111-225 | o
TEST_002 | 2 | 111-225 | x
TEST_002 | 3 | 111-225 | x
TEST_002 | 1 | 111-226 | o
TEST_002 | 2 | 111-226 | o
TEST_002 | 1 | 111-227
TEST_002 | 2 | 111-227
TEST_002 | 3 | 111-227
TEST_002 | 4 | 111-227
TEST_002 | 5 | 111-227
TEST_002 | 6 | 111-227
TEST_002 | 1 | 111-228
TEST_002 | 2 | 111-228
TEST_002 | 3 | 111-228
TEST_003 | 1 | 111-221
TEST_003 | 1 | 111-222
TEST_003 | 1 | 111-223
TEST_003 | 1 | 111-224
TEST_003 | 1 | 111-225
TEST_003 | 2 | 111-225
TEST_003 | 3 | 111-225
TEST_003 | 1 | 111-226
TEST_003 | 2 | 111-226
TEST_003 | 1 | 111-227 | o
TEST_003 | 2 | 111-227 | o
TEST_003 | 3 | 111-227 | x
TEST_003 | 4 | 111-227 | x
TEST_003 | 5 | 111-227 | x
TEST_003 | 6 | 111-227 | o
TEST_003 | 1 | 111-228 | x
TEST_003 | 2 | 111-228 | x
TEST_003 | 3 | 111-228 | o
Spreadsheet: 02b5b271-365d-4695-aa0f-d87180911426
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
HENDERSON COMMUNITY COLLEGE
ACADEMIC PLANS/APPLICATIONS FOR INDUSTRIAL MAINTENANCE TECHNOLOGY CERTIFICATES
Industrial Technician I
EMPL ID |  |  | Major/Program Code |  |  |  |  | Name
([NAME] shaded areas as applicable) |  |  |  |  |  |  |  |  |  |  | (2013-2014)
Academic Success Requirements |  |  |  | Semester | Credit
(May be required) |  |  |  | Taken | Hours
ENC 090 - Foundations of College Writing I |  |  |  |  | 3*
ENC 091 - Foundations of College Writing II |  |  |  |  | 3*
MAT 055 - Pre-Algebra |  |  |  |  | 3*
MAT 065  - Basic Algebra with Measurement |  |  |  |  | 3*
MAT 085  - Intermediate Algebra |  |  |  |  | 3*
RDG 020 - Improved College Reading |  |  |  |  | 3*
RDG 030 - Reading for the College Classroom |  |  |  |  | 3*
* Courses numbered 001-099 and MA 108 do not count toward the
determination of grade point average or as credit toward graduation.
Industrial Electronics Technician I |  |  |  | Semester | Credit
Certificate Requirements |  |  |  | Taken | Hours
ELT 110 - Circuits I |  |  |  |  | 5
ELT 114 - Circuits II |  |  |  |  | 5
ELT 120 - Digital I |  |  |  |  | 3
ELT 250 - Programmable Logic Controllers |  |  |  |  | 4
Total Credit Hours |  |  |  |  | 17
 |  |  |  | Semester | Credit
Electives |  |  |  | Taken | Hours
Certificates in Industrial Maintenance Technology are awarded to students who complete the specified requirements with a cumulative grade point average of 2.0 or higher.
HENDERSON COMMUNITY COLLEGE
SEMESTER-BY-SEMESTER ACADEMIC PLANS FOR INDUSTRIAL MAINTENANCE TECHNOLOGY CERTIFICATES
Industrial Technician I
Semester |  |  | Year |  |  |  | Semester |  |  | Year
Course |  |  |  | Grade | Credit |  | Course |  |  |  | Grade | Credit
 |  |  |  |  | Hours |  |  |  |  |  |  | Hours
Sem. GPA |  | Cum. GPA |  | Total |  |  | Sem. GPA |  | Cum. GPA |  | Total
Semester |  |  | Year |  |  |  | Semester |  |  | Year
Course |  |  |  | Grade | Credit |  | Course |  |  |  | Grade | Credit
 |  |  |  |  | Hours |  |  |  |  |  |  | Hours
Sem. GPA |  | Cum. GPA |  | Total |  |  | Sem. GPA |  | Cum. GPA |  | Total
Semester |  |  | Year |  |  |  | Semester |  |  | Year
Course |  |  |  | Grade | Credit |  | Course |  |  |  | Grade | Credit
 |  |  |  |  | Hours |  |  |  |  |  |  | Hours
Sem. GPA |  | Cum. GPA |  | Total |  |  | Sem. GPA |  | Cum. GPA |  | Total
Semester |  |  | Year |  |  |  | Semester |  |  | Year
Course |  |  |  | Grade | Credit |  | Course |  |  |  | Grade | Credit
 |  |  |  |  | Hours |  |  |  |  |  |  | Hours
Sem. GPA |  | Cum. GPA |  | Total |  |  | Sem. GPA |  | Cum. GPA |  | Total
Spreadsheet: 84740d1284738490-selecting-cells-for-sum-book1_sumhours
Sheet: Sheet1

Mon | Name1 |  |  |  |  | 1 |  | Name1 | 6
 | [NAME] |  |  |  |  | 1 |  | [NAME] | 7
 | Name3 |  |  |  |  | 1 |  | Name3 | 8
 | Name4 |  |  |  |  | 1 |  | Name4 | 9
 | Name5 |  |  |  |  | 1 |  | Name5 | 11
 | Name6 |  |  |  |  | 1 |  | Name6 | 13
Tue | Name1 |  |  |  |  | 1
 | [NAME] |  |  |  |  | 1
 | Name3 |  |  |  |  | 1
 | Name4 |  |  |  |  | 1
 | Name5 |  |  |  |  | 1
 | Name6 |  |  |  |  | 1
Wed | Name1 |  |  |  |  | 1
 | [NAME] |  |  |  |  | 2
 | Name3 |  |  |  |  | 3
 | Name4 |  |  |  |  | 4
 | Name5 |  |  |  |  | 5
 | Name6 |  |  |  |  | 6
Thu | Name1 |  |  |  |  | 1
 | [NAME] |  |  |  |  | 1
 | Name3 |  |  |  |  | 1
 | Name4 |  |  |  |  | 1
 | Name5 |  |  |  |  | 1
 | Name6 |  |  |  |  | 1
Fri | Name1 |  |  |  |  | 1
 | [NAME] |  |  |  |  | 1
 | Name3 |  |  |  |  | 1
 | Name4 |  |  |  |  | 1
 | Name5 |  |  |  |  | 1
 | Name6 |  |  |  |  | 1
Sat | Name1 |  |  |  |  | 1
 | [NAME] |  |  |  |  | 1
 | Name3 |  |  |  |  | 1
 | Name4 |  |  |  |  | 1
 | Name5 |  |  |  |  | 1
 | Name6 |  |  |  |  | 1
Sun | Name1 |  |  |  |  | 0
 | [NAME] |  |  |  |  | 0
 | Name3 |  |  |  |  | 0
 | Name4 |  |  |  |  | 0
 | Name5 |  |  |  |  | 1
 | Name6 |  |  |  |  | 2
Spreadsheet: 38796d1236942317-summarizing-data-over-several-sheets-bolts-list-13-03-09
Sheet: BoltsP2

 | BOLTS LIST | BOLTS LIST
CLIENT |  | 0 |  |  |  | JOB No. |  | 0
PLANT |  | 0 |  |  |  |  | LIST No.  2   of  3
 |  | ALL BOLTS GRADE 8.8 ZINC PLATED |  | BOLTS |  | NUTS |  | WASHERS
ITEM | GRIP | [NAME] OF JOINT | QTY | DIA | LGTH | NYLCK | HEX | FORM C | SPRING
20 |  |  |  |  | #N/A
21 |  |  |  |  | #N/A
22 |  |  |  |  | #N/A
23 |  |  |  |  | #N/A
24 |  |  |  |  | #N/A
25 |  |  |  |  | #N/A
26 |  |  |  |  | #N/A
27 |  |  |  |  | #N/A
28 |  |  |  |  | #N/A
29 |  |  |  |  | #N/A
30 |  |  |  |  | #N/A
31 |  |  |  |  | #N/A
32 |  |  |  |  | #N/A
33 |  |  |  |  | #N/A
34 |  |  |  |  | #N/A
35 |  |  |  |  | #N/A
36 |  |  |  |  | #N/A
37 |  |  |  |  | #N/A
38 |  |  |  |  | #N/A
Spreadsheet: 726993d1617641454-data-entered-a-sheet-need-to-appear-automatically-on-another-sheet-as-per-headings-etc-accounting-module-caracalla-sol-01-
Sheet: P&L

 | Profit and Loss Statement
 |  |  |  | Month1 | Month2 | Month3 | Month4 | Month5 | Month6 | Month7 | Month8 | Month9 | Month10 | Month11 | Month12 | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD
 | Income
 |  | Total Income
 | Cost of Goods Sold
 |  | Opening Stock
 |  | Closing Stock
 |  | Total Cost of Sales
 |  | Gross Profit
 |  | (Total Income less Cost of Sales)
 | Expenses
 |  | Total Expenses
 |  | Net Profit/(Loss)
 |  | (Gross Profit less Expenses) |  |  |  |  |  |  |  |  |  |  |  |  |  | Total YTD
 |  |  |  | Month1 | Month2 | Month3 | Month4 | Month5 | Month6 | Month7 | Month8 | Month9 | Month10 | Month11 | Month12
Spreadsheet: 155989d1337125926-a-fun-one-matching-rows-to-columns-book1
Sheet: Sheet1

Column A | Column B | Helper
[NAME] | Bulls | 1
[NAME] | Suns | 1
[NAME] | Yankees | 1
[NAME] | Knicks | 1
Scottie Pippen | Bulls | 2
[NAME] | Spurs | 1
[NAME] | Suns | 2
[NAME] | Yankees | 2
Spreadsheet: daren_farmer__6672__egmnom-May
Sheet: EGM 201

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-27106-02-001
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 5/1/000
Fax: | (713)646-5799 | Stop:
 |  | 2000-05-31 00:00:00
RECEIPTS |  |  | May | May | May | May | May | May
METER # | [NAME] | SUPPLIER | 1
35 | MOSS BLUFF |  | 0 | 0 | 0 | 0 | 0 | 0
71 | TEXOMA |  | 0 | 0 | 0 | 0 | 0 | 0
584 | VALERO - AGUA DULCE |  | 0 | 0 | 0 | 0 | 0 | 0
644 | LONE STAR KATY |  | 0 | 0 | 0 | 0 | 0 | 0
701 | WESTERN HEADER |  | 0 | 0 | 0 | 0 | 0 | 0
4045 | EXXON CLEAR LAKE | SUPERIOR
4132 | EXXON KATY  (VAN) | MITCHELL | 0 | 0 | 0 | 0 | 0 | 0
4132 | EXXON KATY | ECT | 0 | 0 | 0 | 0 | 0 | 0
4132 | EXXON KATY | KN Mktg (92155) | 0 | 0 | 0 | 0 | 0 | 0
4132 | EXXON KATY  MC 92155 | AQUILLA
4132 | EXXON KATY |  | 0 | 0 | 0 | 0 | 0 | 0
4531 | NEEDVILLE |  | 0 | 0 | 0 | 0 | 0 | 0
6269 | PG&E THOMPSONVILLE |  | 0 | 0 | 0 | 0 | 0 | 0
6351 | TEJAS THOMPSONVILLE |  | 0 | 0 | 0 | 0 | 0 | 0
6721 | PAWNEE PLANT |  | 0 | 0 | 0 | 0 | 0 | 0
6780 | [NAME] | Encina | 0 | 0 | 0 | 0 | 0 | 0
6780 | [NAME] | Quadalope | 0 | 0 | 0 | 0 | 0 | 0
7038 | TRANS TX AUGA DULCE |  | 0 | 0 | 0 | 0 | 0 | 0
7285 | MOSS BLUFF |  | 0 | 0 | 0 | 0 | 0 | 0
8740 | MID TX KATY |  | 0 | 0 | 0 | 0 | 0 | 0
6040 | VALERO RIVERSIDE |  | 0 | 0 | 0 | 0 | 0 | 0
7038 | [NAME] | CONOCO | 0 | 0 | 0 | 0 | 0 | 0
9643 | EXXON KING RANCH |  | 0 | 0 | 0 | 0 | 0 | 0
98675710 | CROW OCONNER | [NAME] | 150 | 150 | 150 | 150 | 150 | 150
989658-10 | LANGHAM CREEK | TEXACO | 1600 | 1600 | 1600 | 1600 | 1600 | 1600
ZZZZ | FORCED PAYBACK | ENTEX/HPL | 0 | 0 | 0 | 0 | 0 | 0
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
35 | MOSS BLUFF
522 | HARDY
1000 | FORMOSA PLANT | FORMOSA
1060 | SHELL DEER PARK
1063 | LYONDELL/CITGO
1168 | [NAME]
1233 | TX CITY
1244 | KOCH REFINERY
1264 | WINNIE PIPELINE
1319 | ENERCORP
1326 | ENTERPRISE | ENTERPRISE
1388 | [NAME] | AIR LIQUIDE | 0 | 0 | 0 | 0 | 0 | 0
1427 | GSU SABINE | ENTERGY
4132 | EXXON KATY HPL | AMOCO
7340 | LUFKIN CHAMPION | DONAHOE
1373 | LYONDELL
1394 | HILL PETRTO | DYNEGY
1412 | HL&P PH ROBINSON
1427 | GSU SABINE | RES
1428 | DUPONT BEAUMONT | DUPONT
1431 | MARATHON TX CITY
1485 | OXY BATTLE GROUND | OXY
1507 | SABINE PIPELINE
1508 | IGS DODGE STREET
1563 | DESTECH
3069 | BAMMEL STORAGE | MIDCON/ENTEX
4132 | EXXON KATY HPL | RES
4531 | NEEDVILLE
3537 | [NAME] | KET
8020 | BAYPORT PLANT
8100 | [NAME] | AIR LIQUIDE | 0 | 0 | 0 | 0 | 0 | 0
 | HUNTSMAN | ENTEX
ZZZZ | IMBALANCE |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | DELIVERY TOTAL
 |  | BALANCE
Spreadsheet: 36349ff4-f781-4580-9d6b-68ffc0ca9e05
Sheet: Sheet1

Step | From Where | Action
0 | Recommendations | Create a new directory on your computer for weekly crime reports called "Weekly Crime Report"
 |  | Save this file and the exported excel spreadsheet from LEAP each week in this same directory
1 | LEAP System | Go to "REPORT" Tab in LEAP Application
 |  | Select "New Report" in light blue tool bar under TABs
 |  | Select "Oakland PD" in Agency drop down list
 |  | Select "Weekly Crime Report" in Name drop down list
 |  | From the date selection boxes,  select the last day you want in your Weekly Crime Report
 |  | Select "Include Primary Offenses Only" radio button
 |  | Select "Blank all the zero values" radio button
 |  | Select "Show all rows with blank/zero values" radio button
 |  | Select the "GO" button on the light blue tool bar to the left and in the middle of your screen
 |  | Select the "Export" tool on the light blue tool bar at the top of the screen just under the TAB bar
 |  | Click on the top area of the daughter security popup window when it appears
 |  | Select  "Download File" from the options presented in the small popup window
 |  | Select "OPEN"  from the choices on the new popup window
 |  | When security question about file formats appears, respond that YES, YOU WANT TO OPEN THE FILE NOW
 |  | This will load the LEAP weekly crime report into an excel spreadsheet with a very long and non-english file name
 |  | VERY IMPORTANT:  Double-click on the worksheet TAB and change the name of the TAB from the long LEAP tab name to simply wcr
 |  | Select SAVE FILE AS from the excel tool menu
 |  | Save the file in THE SAME directory where you store this file (2011 MASTER [NAME]) - probably the "Weekly Crime Report" directory you created in Step 0
 |  | VERY IMPORTANT:  Save the downloaded file from LEAP  with the name wcr source.xls
 |  | Respond to the security question that you want to replace file if this is not the first time you have used this report
 |  | NOW CLOSE THIS FILE THAT YOU RENAMED "WCR SOURCE.XLS"
2 | MASTER [NAME] | Now open this 2011 MASTER [NAME] file if not already OPEN
3 | Adjustments for Homicides TAB
 | MASTER [NAME]
4 | Adjustments for UCR
5 | Pending Re-coding
6 | Manual Adjustments | Make any homicide modifications for non-UCR, justified homicides etc in the "Manual Adjustments" Tab.
 |  | This allows you to modify the homicide counts for each year manually with a + or - number
7 | SAVE MASTER [NAME]
 |  | Once all the changes have been made in items 3-5 above, save the 2011 MASTER [NAME] file
8 | Assemble
 |  | Hold the CTRL key and W key down simultaneous
 |  | The macro will open up the wcr source.xls file and copy it to the 2011 MASTER WCR.xls file and thereport on the Final Report TAB will be ready for printing
Date | 07/21/2013)
2010 | 07/21/2013 | 2013-07-21 00:00:00
2009 |  | 2012-07-21 00:00:00
2008 |  | 2011-07-22 00:00:00
2007 |  | 2010-07-21 00:00:00
 |  | 2009-07-21 00:00:00
Spreadsheet: 810396d1671732921-averaging-table-data-ranges-according-to-groups-test-3
Sheet: Analysis

 |  |  |  |  |  |  |  |  |  |  |  |  | Year | Group
 |  |  |  |  |  |  |  |  |  |  |  |  | 2017-2018 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2018-2019 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2019-2020 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 2020-2021 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 2021-2022 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-2023
 |  |  |  |  |  |  |  | Average Results
 |  |  |  |  |  | Year | Group | Score 1 | Score 2 | Score 3 | Score 4
 |  |  |  |  |  | 2017-2018 | 5
 |  |  |  |  |  | 2018-2019 | 2
 |  |  |  |  |  | 2019-2020 | 3
 |  |  |  |  |  | 2020-2021 | 3
 |  |  |  |  |  | 2021-2022 | 5
 |  |  |  |  |  | 2022-2023 | 1
Spreadsheet: 59928d1260454906-macro-to-re-arrange-auto-report-from-pivot-table-general-ledger
Sheet: My Requirement

DATE | A/C NAME | A/C NO | [NAME] | PARTICULARS | Debit | Credit | Balance
2009-11-01 00:00:00 | BANK | 1001 | D | CASH RECEIVED FROM DEVID |  | 500 | -500
2009-11-01 00:00:00 | BANK | 1001 | C | [NAME] |  | 500 | -500
2009-11-01 00:00:00 | BANK | 1001 | D | CASH RECEIVED FROM DEVID |  | 500 | -500
2009-11-01 00:00:00 | BANK | 1001 | C | CASH RECEIVED FROM DEVID | 500 |  | 500
2009-11-03 00:00:00 | BANK | 1001 | D | PAID TO MICHLE |  | 50 | -50
2009-11-03 00:00:00 | BANK | 1001 | D | PAID TO MICHLE |  | 50 | -50
2009-11-03 00:00:00 | BANK | 1001 | D | PAID TO MICHLE |  | 50 | -50
2009-11-03 00:00:00 | BANK | 1001 | C | PAID TO MICHLE | 50 |  | 50
2009-11-05 00:00:00 | BANK | 1001 | D | WDRL PETTY CASH |  | 100 | -100
2009-11-05 00:00:00 | BANK | 1001 | C | WDRL PETTY CASH |  | 100 | -100
2009-11-05 00:00:00 | BANK | 1001 | D | WDRL PETTY CASH | 100 |  | 100
2009-11-06 00:00:00 | BANK | 1001 | D | PETTY CASH FROM BANK |  | 100 | -100
2009-11-06 00:00:00 | BANK | 1001 | C | PETTY CASH FROM BANK |  | 100 | -100
2009-11-06 00:00:00 | BANK | 1001 | D | PETTY CASH FROM BANK | 100 |  | 100
2009-11-07 00:00:00 | BANK | 1001 | D | CASH PAID |  | 85 | -85
2009-11-07 00:00:00 | BANK | 1001 | C | CASH PAID |  | 85 | -85
2009-11-07 00:00:00 | BANK | 1001 | D | CASH PAID | 85 |  | 85
2009-11-08 00:00:00 | BANK | 1001 | D | [NAME] |  | 20 | -20
2009-11-08 00:00:00 | BANK | 1001 | D | [NAME] |  | 20 | -20
2009-11-08 00:00:00 | BANK | 1001 | D | [NAME] | 20 |  | 20
2009-11-09 00:00:00 | BANK | 1001 | D | PETROL | 15 |  | 15
2009-11-09 00:00:00 | BANK | 1001 | C | PETROL | 15 |  | 15
2009-11-12 00:00:00 | BANK | 1001 | C | CHQ # 405 | 500 |  | 500
2009-11-12 00:00:00 | BANK | 1001 | C | CHQ # 405 |  | 500 | -500
2009-11-12 00:00:00 | BANK | 1001 | C | CHQ # 405 |  | 500 | -500
2009-11-12 00:00:00 | BANK | 1001 | D | CHQ # 405 | 500 |  | 500
TOTAL |  |  |  |  | 1885 | 3260 | -1375
Spreadsheet: 846067d1697364900-trying-to-consolidate-data-for-upload-example-problem
Sheet: Sheet2

Name | Postcode
Star | Ub3 2pz
[NAME] | Ub3 3eu
Planet | Ub3 2pp
Space | Ub3 2ph
Sun | Ub3 2al
Luna | Ub3 2po
Earth | Ub3 2pk
Uranus | Ub3 2qy
Pluto | Ub3 3wx
Rock | Ub4 7qu
Spreadsheet: 1b00c92b-3fc3-4429-9f86-8d86c5a048b1
Sheet: Sheet1

Table S4 | Unnamed: 1 | Unnamed: 2
Genes Selected in both Prediction and Co-Variation Correlation Assay
Synaptic incoming connectivity signatures |  | Synaptic outgoing connectivity signatures
che-2 |  | ceh-23
mgl-2 |  | che-3
mps-1 |  | gpa-3
pef-1 |  | kin-29
unc-5 |  | kvs-1
 |  | lin-11
 |  | osm-3
 |  | osm-9
 |  | tax-2
 |  | tax-4
 |  | unc-5
Spreadsheet: 02d1dae1-973a-43a7-8632-adf467bd0460
Sheet: HT

Table | Haiti |  | Latin America and the Caribbean
 | Grain | Root | Commercial | Food aid |  | Aggregate
Year | production | production | imports | receipts |  | availability
 |  | (grain equiv.) | (grains) | (grain equiv.) |  | of all food
 |  |  | ---1,000 tons ---
2002 | 340.369 | 195.0259969687947 | 377.548589 | 235.053265 |  | 1848.447503765524
2003 | 345.37 | 194.4048973820074 | 585.929315 | 62.84151799999999 |  | 1835.623064758942
2004 | 363.035 | 197.6981966421178 | 486.614837 | 120.429401 |  | 1861.730654216621
2005 | 370.535 | 223.0693561104633 | 519.4284910000001 | 136.524674 |  | 1865.970336291588
2006 | 378.37 | 222.213822071471 | 631.029068 | 111.807148 |  | 1913.725293450433
2007 | 476.71 | 243.836418423127 | 497.5577509999999 | 107.183492 |  | 1975.82699317276
2008 | 383.37 | 252.2148311655955 | 421.771219 | 203.5076 |  | 2020.47023256936
2009 | 510.5428 | 252.2148311655955 | 510.243145 | 143.017927 |  | 2140.875670936451
2010(e) | 458.5109 | 234.498293523961 | 504.948705 | 151.2363396666667 |  | 2115.160732627407
Projections |  |  |  | Food gaps*
 |  |  |  | NG | DG
2011 | 500.5582048903691 | 237.6152859597386 | 480.8395400093821 | 250.4869885538827 | 393.0109268173787 | 2122.492725731831
2016 | 556.359888872595 | 253.4963110238208 | 544.0613074078349 | 227.0290042900468 | 387.6620018151217 | 2322.15185285281
2021 | 607.8773275882835 | 269.8753258706178 | 582.0338812963753 | 236.1046636948816 | 408.9523424614001 | 2488.359622019404
Source: Economic Research Service, using data from FAOSTAT (grain and root and tuber production and imports), and the World Food Program (food aid).
*NR stands for nutritional requirements and describes the amount of grain equivalent needed to support nutritional standards on
*NG stands for nutritional gap and describes the amount of grain equivalent needed to support nutritional standards on
income quintile to reach the nutrional requirement.
Spreadsheet: 71513d1272292214-excel-2007-sorting-rows-of-data-into-one-column-example
Sheet: Sheet1

How My Data is now
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Billy | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | [NAME] | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
Need My Data Like This
Billy | Jan | 1
Billy | Feb | 2
Billy | Mar | 3
Billy | Apr | 4
Billy | May | 5
Billy | Jun | 6
Billy | Jul | 7
Billy | Aug | 8
Billy | Sep | 9
Billy | Oct | 10
Billy | Nov | 11
Billy | Dec | 12
[NAME] | Jan | 12
[NAME] | Feb | 11
[NAME] | Mar | 10
[NAME] | Apr | 9
[NAME] | May | 8
[NAME] | Jun | 7
[NAME] | Jul | 6
[NAME] | Aug | 5
[NAME] | Sep | 4
[NAME] | Oct | 3
[NAME] | Nov | 2
[NAME] | Dec | 1
Spreadsheet: 159633d1338791967-need-help-with-calculations-derived-from-pivot-data-zenricobook2_solution-1-
Sheet: Sheet1

Phase of the Project | 1 | 2 | Project No | Project ID | For Period Ending | For Period Starting |  | Project ID | For Period Ending | For Period Starting | Difference
4. Execute |  |  | 237152 | ES10159 | 2012-02-02 00:00:00 | 2012-01-26 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-02-09 00:00:00 | 2012-02-03 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-02-16 00:00:00 | 2012-02-10 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-02-23 00:00:00 | 2012-02-17 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-03-01 00:00:00 | 2012-02-24 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-03-15 00:00:00 | 2012-03-02 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-03-22 00:00:00 | 2012-03-16 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-03-29 00:00:00 | 2012-03-23 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-04-05 00:00:00 | 2012-03-30 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-04-19 00:00:00 | 2012-04-06 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-04-26 00:00:00 | 2012-04-20 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-05-03 00:00:00 | 2012-04-27 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-05-03 00:00:00 | 2012-04-27 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-04-19 00:00:00 | 2012-04-13 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-02-16 00:00:00 | 2012-02-10 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-02-23 00:00:00 | 2012-02-17 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-04-05 00:00:00 | 2012-03-29 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-03-01 00:00:00 | 2012-02-24 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-02-02 00:00:00 | 2012-01-26 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-03-01 00:00:00 | 2012-02-24 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-05-03 00:00:00 | 2012-04-27 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-05-03 00:00:00 | 2012-04-27 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-03-22 00:00:00 | 2012-03-15 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-02-09 00:00:00 | 2012-02-03 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-02-09 00:00:00 | 2012-02-03 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-04-26 00:00:00 | 2012-04-20 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-03-29 00:00:00 | 2012-03-22 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-03-15 00:00:00 | 2012-03-08 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-04-12 00:00:00 | 2012-04-06 00:00:00
Spreadsheet: 672692d1586963707-building-summary-report-find-multiple-matches-in-a-table-04-15-20-cattle-close-out-report-excel-forum
Sheet: Closeout Rpt

Lot: | [NAME]
Head Days
 |  |  | Qty | [NAME] | %%
 | Total Head Purchased
 | Total Deaths
 | Total Realizers
 | Total Sold
 |  |  | Total | P/H | P/Lb
 | Total Puchase Cost
 | Total Realizer Income
 | Total Sales
Total Dry Matter Intake |  |  |  | Total Wt Gain (Dead's In)
Avg Per Head DMI |  |  |  | Total Wt Gain (Dead's Out)
DM Conv Rate - Deads In |  |  |  | Cost of Gain (Dead's In)
DM Conv Rate - Deads Out |  |  |  | Cost of Gain (Dead's Out)
 |  | ADG (Dead's In)
 |  | ADG (Dead's Out)
 | Total Sales
 | Total cattle Purchase Cost
 | Total Feed Cost
 | Total Med & Vet & Rendering
 | Total Supplemental Feed
 | Total Expense
 | Total Profit / (Loss)
 | Total Profit / (Loss) P/H
Purchase
 | Date | CMS | Qty | [NAME] | Per Per Lb | Amount | Note
 |  |  |  |  |  |  | Tranfer lot To [NAME] |  | <=Looking for this note from the Dataset