tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 132713d1323888666-if-statement-and-vlookup-help-bandsaw-blade-summary-analysis-report-2012-blank-modified-by-tigeravatar-
Sheet: IDs & Blade Sizes

ID | [NAME]
A | 11 FT 6 IN X 1-1/4 IN X 3/4
B | 15 FT 0 IN X 1-1/2 IN X 2/3
C | 15 FT 0 IN X 1-1/2 IN X 1.1/1.5
D | 15 FT 4 IN X 1-1/2 IN X 3/4
E | 15 FT 6 IN X 1-1/2 IN X 2/3    BI-METAL
F | 17 FT 3 IN X 1-1/2 IN X 3/4
G | 21 FT 1 IN X 2 IN X 2/3
H | 21 FT 1 IN X 2 IN X 3/4
J | 21 FT 1 IN X 2 IN X 1.1/1.5
K | 21 FT 8 IN X 2 IN X 1.4/2.5
L | 21 FT 8 IN X 2 IN X 2/3
M | 28 FT 10 IN X 2-5/8 IN X 1.1/1.5
N | 27 FT 3 IN X 2-5/8 IN X 1.1/1.5    BI-METAL
P | 27 FT 3 IN X 2-5/8 IN X 1.0  1TPI    CARBIDE
Q | 19 FT 6 IN X 1-1/2 IN X 2/3    BI-METAL
R | 19 FT 6 IN X 1-1/2 IN X 2/3    CHROME
S | 19 FT 6 IN X 1-1/2 IN X 2/3    STAINLESS
Spreadsheet: 165826d1341351630-using-index-match-or-vlookup-giving-unexpected-results-on-imported-data-import-enigma
Sheet: Sheet1

30002 |  |  | 30002 |  |  |  |  |  |  |  |  |  |  | 30002 | PM 148
30003 |  |  | 30003 |  |  |  |  |  |  |  |  |  |  | 30003 | PM 149
30004 |  |  | 30004 |  |  |  |  |  |  |  |  |  |  | 30004 | PM 150
30005 |  |  | 30005 |  |  |  |  |  |  |  |  |  |  | 30005 | PM 166
30006 |  |  | 30006 |  |  |  |  |  |  |  |  |  |  | 30006 | PM 167
30007 |  |  | 30007 |  |  |  |  |  |  |  |  |  |  | 30007 | PM 168
30008 |  |  | 30008 |  |  |  |  |  |  |  |  |  |  | 30008 | PM 169
30009 |  |  | 30009 |  |  |  |  |  |  |  |  |  |  | 30009 | PM 170
30010 |  |  | 30010 |  |  |  |  |  |  |  |  |  |  | 30010 | PM 171
30011 |  |  | 30011 |  |  |  |  |  |  |  |  |  |  | 30011 | PM 172
41102 |  |  | 41102 |  |  |  |  |  |  |  |  |  |  | 41102 | PM 1109
631001 |  |  | 631001 |  |  |  |  |  |  |  |  |  |  | 631001 | PM 900
631005 |  |  | 631005 |  |  |  |  |  |  |  |  |  |  | 631005 | PM 901
631009 |  |  | 631009 |  |  |  |  |  |  |  |  |  |  | 631009 | LJ 0001
631011 |  |  | 631011 |  |  |  |  |  |  |  |  |  |  | 631011 | PM 896
631015 |  |  | 631015 |  |  |  |  |  |  |  |  |  |  | 631015 | PM 897
631016 |  |  | 631016 |  |  |  |  |  |  |  |  |  |  | 631016 | PM 899
631017 |  |  | 631017 |  |  |  |  |  |  |  |  |  |  | 631017 | PM 898
631021 |  |  | 631021 |  |  |  |  |  |  |  |  |  |  | 631021 | PM 963
631022 |  |  | 631022 |  |  |  |  |  |  |  |  |  |  | 631022 | PM 990
Spreadsheet: 83075d1283136264-excel-2007-lottery-numbers-lotto
Sheet: WINNINGS

Main [NAME] |  |  |  |  |  |  | Bonus |  | Subscription Numbers |  |  |  |  |  |  |  | Max million Numbers
 |  |  |  |  |  |  |  |  | 1 | 3 | 7 | 8 | 9 | 12 | 18 |  | 1 | 3 | 7 | 8 | 9 | 12 | 18
 |  |  |  |  |  |  |  |  | 2 | 6 | 8 | 12 | 14 | 28 | 35 |  | 2 | 12 | 20 | 23 | 33 | 35 | 49
 |  |  |  |  |  |  |  |  | 10 | 14 | 15 | 26 | 43 | 47 | 49 |  | 2 | 6 | 8 | 12 | 14 | 28 | 35
Spreadsheet: cooper_richey__4022__AB Power Fax
Sheet: Flat load

 |  | GFI Alberta Electricity Desk
 |  | [NAME] [PHONE]
2001-12-20 00:00:00 |  | [EMAIL]
 |  | FLAT | LOAD
 | Maturity | bid $/Mwh | ask $/Mwh
 | Day Ahead | 50 | 56
 | BOM | 33 | 38
 | 2002-01-02 00:00:00 | 39 | 40
 | 2002-02-01 00:00:00 | 39.25 | 40.25
 | 2002-03-01 00:00:00 | 38.75 | 39.75
 | Q1 2002 | 39 | 40
 | Q2 2002 | 36.5 | 37.5
 | Q3 2002 | 40.5 | 41.5
 | Q4 2002 | 42.5 | 43.5
 | Cal 2002 | 39.5 | 40.5
 | Cal 2003 | 39 | 40
Note:
GFI Brokers Limited ("GFI") has provided this information on the basis that its intended use is for indicative price only.
GFI provides no warranties as to the accuracy of this information.
GFI (and its affiliates) accept no liability whatsoever for any loss that may arise as a result of the provision and use of this information.
Spreadsheet: 137555d1327223506-wrap-text-after-x-number-of-characters-test
Sheet: Sheet1

 |  | [NAME] OF QUANTITIES
 |  | Project:
 |  | Date:
 |  | Client:
 |  | TOTAL EXCLUDING GST:
No. | Item | Unit | Qty | Rate | Total
 | SECTIONS
 | CEILINGS - PARTITIONS - EXTERNAL WORKS - CARPENTRY - ADDENDUMS
 | *NOTE - Green star requirements for timber, adhesives and insulation. No
 | requirements for plasterboard.
 | CEILINGS
 | CLG1 - Exposed grid 1200 x 600 [NAME] SE tile with Peakform 24mm
 | exposed Tee grid
 | Levels 1 - 11 height 2.7m | m2 | 1000 | 100
 | GLG2 - Suspended flush set 13mm pb ceiling
 | GF height 8.0m | m2 | 43.1
 | Levels 1 - 11 height 2.7m | m2 | 387.9
Spreadsheet: 885279d1734740618-excel-function-that-can-take-an-array-value-for-rates-for-npv-with-multiple-rates-xnpv
Sheet: Sheet1

Method 1 |  |  |  |  |  |  |  |  |  |  | Method 2
Calculate XNPV of individual cash flows at their respective rates, then sum up
 |  |  |  | 2025-09-14 00:00:00 | 2026-01-07 00:00:00 | 2027-02-28 00:00:00 | 2027-05-28 00:00:00 | 2028-12-18 00:00:00 | 2029-05-09 00:00:00 |  |  |  |  |  | 2025-09-14 00:00:00 | 2026-01-07 00:00:00 | 2027-02-28 00:00:00 | 2027-05-28 00:00:00 | 2028-12-18 00:00:00
Rate | Dates | Values |  | 3670998.19 | 567283.99 | 4226362.05 | 7389020.34 | 10455837.28 | 14375800.65 |  | Rate | Dates | Values |  | 0.07 | 0.06 | 0.09 | 0.15 | 0.17
START> | 2024-12-31 00:00:00 | 1256023.32 |  |  |  |  |  |  |  |  | START> | 2024-12-31 00:00:00 | 1256023.32
0.12 | 2025-09-14 00:00:00 | 3670998.19 |  |  |  |  |  |  |  |  | 0.12 | 2025-09-14 00:00:00 | 3670998.19 | [NAME]
0.07 | 2026-01-07 00:00:00 | 567283.99 |  |  |  |  |  |  |  |  | 0.07 | 2026-01-07 00:00:00 | 567283.99
0.06 | 2027-02-28 00:00:00 | 4226362.05 |  |  |  |  |  |  |  |  | 0.06 | 2027-02-28 00:00:00 | 4226362.05
0.09 | 2027-05-28 00:00:00 | 7389020.34 |  |  |  |  |  |  |  |  | 0.09 | 2027-05-28 00:00:00 | 7389020.34
0.15 | 2028-12-18 00:00:00 | 10455837.28 |  |  |  |  |  |  |  |  | 0.15 | 2028-12-18 00:00:00 | 10455837.28
0.17 | 2029-05-09 00:00:00 | 14375800.65 |  |  |  |  |  |  |  |  | 0.17 | 2029-05-09 00:00:00 | 14375800.65
Total Cash flow |  |  | <- undiscounted |  |  |  |  |  |  |  | Total Cash flow |  |  | <- undiscounted
 |  | Rate |  | 0.12 | 0.07 | 0.06 | 0.09 | 0.15 | 0.17 |  |  |  | XNPV
 |  |  |  |  |  |  |  |  |  |  |  |  | Adjustment
 |  | XNPV |  |  |  |  |  |  |  |  |  |  | Adj. XNPV
 |  | Total XNPV |  |  |  |  |  |  |  |  |  |  | Total XNPV
Spreadsheet: 270673d1381583018-discount-calculation-wideearp_discount
Sheet: Sheet1

Cost | [NAME] | Sale Price | Gross Profit
100 | 0.5
 | Discount | Sale Price | Gross Profit
 | 0.08
 | Qty Sale | Gross Profit
 | 20 |  | no discount
 |  |  | with discount
 | Qty Sale | same profit
Spreadsheet: 456864d1461092015-lookup-data-in-multiple-columns-to-sum-values-in-corresponding-cells-excel-froum-help-example-data-1-
Sheet: Data

Order Number | Line Number | Size | Qty | Price | Total
100123 | SS-123 | S | 20 | 5
100123 | SS-123 | M | 50 | 5
100123 | SS-124 | S | 20 | 10
100123 | SS-124 | M | 50 | 10
100124 | SS-125 | L | 40 | 15
100124 | SS-126 | XL | 10 | 5
100124 | SS-126 | L | 40 | 5
100124 | SS-125 | XL | 10 | 15
Spreadsheet: 724ebb05-8327-4c04-ab94-fdffc33bd006
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HCV | Test | HCV | Hepatitis C Antibody Screen, Serum | HCV Ab Screen, S | Chemiluminescence Immunoassay | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down within 6 hours of draw. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Negative Interpretation depends on clinical setting. See Viral Hepatitis Serologic Profiles in Special Instructions. | Monday through Saturday; 8 a.m.-12:30 a.m. Sunday; 8 a.m.-4:30 p.m. | 1 day | 2 days | 1 | 86803 |  |  |  |  | Rochester
HCV | [NAME] | SST | Serum SST |  |  |  | Frozen
HCV | Result | HCVA | HCV Ab Screen, S | HCV Ab Screen, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16128-1
Spreadsheet: 687226d1595037612-trying-to-sum-values-along-a-tables-hypotenuse-excel-help-5-_gw
Sheet: Sheet1

 | Total invoices |  |  | 0 | 1 | 2 | 3 | 4 | 5
996 |  |  | 2015-01-01 00:00:00 | 996 | 581 | 575 | 575 | 518 | 562
888 |  |  | 2015-02-01 00:00:00 | 307 | 122 | 140 | 89 | 89 | 135
966 |  |  | 2015-03-01 00:00:00 | 269 | 90 | 91 | 80 | 52 | 63
1007 |  |  | 2015-04-01 00:00:00 | 202 | 57 | 41 | 46 | 42 | 48
933 |  |  | 2015-05-01 00:00:00 | 178 | 60 | 27 | 41 | 30 | 44
 | … |  | 2015-06-01 00:00:00 | 163 | 56 | 52 | 39 | 38 | 31
 | … |  | 2015-07-01 00:00:00 | 137 | 50 | 19 | 28 | 26 | 38
Spreadsheet: 728282d1618399838-cell-value-based-on-first-instance-of-text-found-in-column-a1-text-finder
Sheet: Sheet1

Title
Origin
Destination 1
Destination 2
Destination 3
Destination 4
Destination 5
Destination 6
THIS TEXT | Find the first instance of THIS TEXT in column A and enter the row number - in this case 10 in cell A1
Title
Origin
Destination 1
Destination 2
Destination 3
Destination 4
Destination 5
Destination 6
THIS TEXT
Title
Origin
Destination 1
Destination 2
Destination 3
Destination 4
Destination 5
Destination 6
Destination 7
Destination 8
Destination 9
Destination 10
THIS TEXT
Spreadsheet: 55486d1255604413-standard-deviation-and-nested-if-statement-sample-1-
Sheet: Sheet2

AM/BA | Achievement rate ([NAME])
A | -0.03418803418803419 | low
B | 0.2 | low
C | -1.454545454545455 | very low
D | 5.913298747763864 | high
E | 2.078165680473373 | high
F | 1.662967142857143 | high
G | 1.322288874288217 | high
H | 2.181692482915718 | high
I | 2.510054844606947 | high
J | 1.134596957403651 | midium
K | 2.408926417370326 | high
L | 1.280821917808219 | high
M | 0.9927234927234927 | midium
N | 4.503560364464692 | high
O | 0.9310344827586207 | midium
P | 2.25282722513089 | high
Q | 1.009708737864078 | midium
R | 2.968716289104639 | high
S | 1.966618769185791 | high
T | 2.825037707390649 | high
U | 2.272506082725061 | high
V | 2.752896665878458 | high
W | 1.157601115760112 | midium
X | 2.666881147540983 | high
Y | 1.515672358355285 | high
Z | 1.286964888996139 | high
AA | -0.9 | very low
AB | 1.573924774010061 | high
AC | 1.700892857142857 | high
AD | 0.8565759637188208 | midium
AE | 1.815443592552026 | high
AF | 1.83733929569592 | high
AG | 0.9304029304029304 | midium
AH | 0.9322033898305084 | midium
AI | 1.489347462353597 | high
AJ | 1.587097693879537 | high
AK | 2.259388148327678 | high
Spreadsheet: 139155d1328107739-excel-2007-getting-data-from-other-worksheets-data-val-list-vlookup-2011-stats
Sheet: Drivers Standings

Pos | Driver | Team | Nation | Wins | Total | MAL | CHN | TUR | ESP | MON | CAN | EUR | GBR | GER | HUN | BEL | ITA | SIN | JPN | KOR | IND | ABU | BRA
1 | [NAME]
2 | [NAME]
3 | [NAME]
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | [NAME]
9 | [NAME]
10 | [NAME]
11 | [NAME]
12 | [NAME]
13 | [NAME]
14 | [NAME]
15 | Sebastien Buemi
16 | [NAME]
17 | [NAME]
18 | [NAME]
19 | Pastor Maldonado
20 | [NAME]
21 | Jarno [NAME]
22 | [NAME]
23 | [NAME]
24 | [NAME]
25 | [NAME]
26 | Narain Karthikeyan
27 | [NAME]
28 | Karun Chandhok
Spreadsheet: 43815d1242407939-searching-for-data-from-two-sources-upload-test1
Sheet: upload 2

vendor | unique? | ref | doc number | amount
[PHONE] | 1 | PMA2519-A004 | 31502682 | 150
[PHONE] | 1 | PMA2522-V008 | 31502863 | 50
[PHONE] | 1 | PMA2521-A050 | 31502795 | 200
[PHONE] | 1 | PMA2516-A126 | 31501149 | 250
[PHONE] | 1 | PMA2542-A051 | 31506177 | 600
[PHONE] | 1 | PMA2508-R021 | 31500885 | 50
[PHONE] | 1 | PMA2514-R017 | 31501077 | 50
[PHONE] | 1 | PMA2523-A039 | 31502999 | 50
[PHONE] | 1 | PMA2537-A035 | 31504632 | 150
[PHONE] | 1 | PMA2541A062 | 31506094 | 900
[PHONE] | 1 | PMA2542-A059 | 31506181 | 50
[PHONE] | 1 | PMA2523-A038 | 31503001 | 150
[PHONE] | 1 | PMA2524-V003 | 31503086 | 150
[PHONE] | 1 | PMA2533-A014 | 31504430 | 150
[PHONE] | 1 | PMA2539-V004 | 31504808 | 150
[PHONE] | 1 | PMA2543-A005 | 31506285 | 200
[PHONE] | 1 | PMA2508-A045 | 31500887 | 250
[PHONE] | 0 | PMA2520-R035 | 31502762 | 600
[PHONE] | 0 | PMA2518-R050 | 31501240 | 1400
[PHONE] | 1 | PMA2518-R003 | 31501238 | 50
[PHONE] | 1 | PMA2538-V031 | 31504729 | 50
[PHONE] | 1 | PMA2531-A010 | 31503429 | 100
[PHONE] | 1 | PMA2528-A026 | 31503232 | 150
[PHONE] | 1 | PMA2522-V005 | 31502871 | 200
[PHONE] | 1 | PMA2518-V001 | 31501255 | 150
[PHONE] | 1 | PMA2520-R002 | 31502764 | 2700
[PHONE] | 1 | PMA2517-V027 | 31501206 | 500
[PHONE] | 0 | PMA2522-V005 | 31502864 | 50
[PHONE] | 0 | pma test1 | a31502846 | 100
[PHONE] | 0 | pma test1 | b31502846 | 200
[PHONE] | 0 | pma test1 | c31502846 | 300
[PHONE] | 1 | PMA2543-A035 | 31506253 | 450
[PHONE] | 1 | PMA2522-A019 | 31502859 | 850
[PHONE] | 1 | PMA2522-A016 | 31502861 | 50
[PHONE] | 1 | PMA2543-A012 | 31506261 | 100
[PHONE] | 1 | PMA2517-R004 | 31501211 | 350
[PHONE] | 1 | PMA2524-R146 | 31503082 | 200
[PHONE] | 1 | PMA2539-V152 | 31504803 | 200
Spreadsheet: 834951d1688183102-trying-to-create-a-project-schedule-of-technicians-based-on-location-tasksbytechandlocation-mcbroon-
Sheet: ProjectSchedule

 | Master [NAME] 2023 |  |  |  |  |  | AL | AZ | N CA | S CA | CO | FL | GA | LA | KS MO | MD
 |  |  |  |  |  |  | NC | NM | NV | OK | PA | TN | TX | UT | VA | WA |  | Off / Holiday
 |  |  | 2023-06-26 00:00:00
 |  |  | 1
 |  | [NAME] | START | END |  | DAYS
 | Technician 1 (Office in Texas)
 | Task in Texas | TX | 2023-06-30 00:00:00 | 2023-07-02 00:00:00
 | Task in Georgia | GA | 2023-06-28 00:00:00 | 2023-06-29 00:00:00
 | Task in PA | PA | 2023-07-10 00:00:00 | 2023-07-16 00:00:00
 | Vacation | X | 2023-07-04 00:00:00 | 2023-07-06 00:00:00
 | Task in Oklahoma | OK | 2023-07-08 00:00:00 | 2023-07-09 00:00:00
 | Task in NC | NC | 2023-07-17 00:00:00 | 2023-07-19 00:00:00
 | [NAME] (Office in Texas)
 | Task in Georgia | GA | 2023-05-23 00:00:00 | 2023-05-23 00:00:00
 | Task in Georgia | GA | 2023-05-24 00:00:00 | 2023-05-24 00:00:00
 | Task in Georgia | GA | 2023-05-25 00:00:00 | 2023-05-25 00:00:00
 | Task in Georgia | GA | 2023-05-26 00:00:00 | 2023-05-26 00:00:00
 | Vacation | X | 2023-05-27 00:00:00 | 2023-05-31 00:00:00
 | Task in Texas | TX | 2023-06-19 00:00:00 | 2023-06-22 00:00:00
 | Task in Texas | TX | 2023-06-23 00:00:00 | 2023-06-25 00:00:00
 | Task in Florida | FL | 2023-06-26 00:00:00
 | Task in Florida | FL | 2023-06-27 00:00:00 | 2023-06-30 00:00:00
 | Vacation | X | 2023-07-03 00:00:00 | 2023-07-07 00:00:00
 | Technician 3 (Office in Arizona)
 | Task in AZ | AZ | 2023-06-26 00:00:00 | 2023-06-30 00:00:00
 | Vacation | X | 2023-07-03 00:00:00 | 2023-07-06 00:00:00
 | Task in Florida | FL | 2023-07-07 00:00:00 | 2023-07-12 00:00:00
 | Task in AZ | AZ | 2023-07-01 00:00:00 | 2023-07-02 00:00:00
Spreadsheet: dan_hyvl__4696__Tucson Electric Master Physical 03262001
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-03-26 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | Tucson Electric Power Company | CONTACT: | Mr. [NAME]
ADDRESS: | One South Church Street | TITLE:
 | Tucson, AZ 85701 | PHONE: | (520) 623-7711
 |  | FAX:
INCORPORATION STATE: |  | S&P RATING:
STRUCTURE | COUNTERPARTY | ENA ENTITY
COLLATERAL
THRESHOLD  in $ | 3000000 | 25000000
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | N/A | Enron Corp. (BBB+)
LIMIT in $[NAME] |  | 30000000
Incorporation State: |  | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change | X | X
-Below = | [NAME] (see Note 1 below) | BBB- (See Note 1 below)
Financial Covenants | X
-Funded Debt/Net Worth
-Minimum Net worth
-EBITDA/Interest | < 1.5:1
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty | 10000000
-Guarantor ($[NAME]) |  | 100000000
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES:    X | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES:    X | NO:
OTHER COMMENTS | 1.  Debt ratings are Standard & Poor's underlying credit ratings for both counterparties.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Ext. 53923
Spreadsheet: cfce2cb3-1d69-422f-9ecf-9aa63432b815
Sheet: Geographic

Johnson & Johnson and Subsidiaries
Supplementary Sales Data
([NAME]; Dollars in Millions) |  |  |  |  | THIRD QUARTER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NINE MONTHS
 |  |  |  |  |  |  |  |  |  | 0 | Percent Change |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percent Change
 |  |  | Pulls fm Rpt | Adj | 2010 |  | 2009 |  | Change $ |  | Total |  | Operations $ |  | Operations |  | Currency $ |  | Currency |  | Prior Q YTD | Pulls fm Rpt | Adj | 2010 |  | 2009 |  | Change $ |  | Total |  | Operations $ |  | Operations |  | Currency $ |  | Currency
Sales to customers by
geographic area
U.S. |  | Great | 7131 |  | 7131 |  | 7314 |  | -183 |  | -2.5 | % | -183 |  | -2.5 |  | 0 |  | 0 |  | 15090 |  |  | 22221 |  | 23022 |  | -801 |  | -3.5 | % | -801 |  | -3.5 |  | 0 |  | 0
Europe |  | Great | 3717 | -1 | 3629 |  | 3879 |  | -250 |  | -6.4 |  | 68 |  | 1.799999999999999 |  | -318 |  | -8.2 |  | 7934 | 11651 | -1 | 11563 |  | 11522 |  | 41 |  | 0.4 |  | 289 |  | 2.6 |  | -248 |  | -2.2
Western Hemisphere excluding U.S. |  | Great | 1337 |  | 1424 |  | 1338 |  | 86 |  | 6.4 |  | 24 |  | 1.7 |  | 62 |  | 4.7 |  | 2655 | 3992 |  | 4079 |  | 3615 |  | 464 |  | 12.8 |  | 93 |  | 2.5 |  | 371 |  | 10.3
Asia-Pacific, Africa |  | Great | 2798 |  | 2798 |  | 2550 |  | 248 |  | 9.7 |  | 106 |  | 4.1 |  | 142 |  | 5.6 |  | 5282 | 8080 |  | 8080 |  | 7187 |  | 893 |  | 12.4 |  | 427 |  | 5.9 |  | 466 |  | 6.5
International |  | Great |  |  | 7851 |  | 7767 |  | 84 |  | 1.1 |  | 198 |  | 2.6 |  | -114 |  | -1.5 |  | 15871 |  |  | 23722 |  | 22324 |  | 1398 |  | 6.3 |  | 809 |  | 3.7 |  | 589 |  | 2.6
 |  |  |  |  |  |  |  |  |  | 0
Worldwide |  | Great |  |  | 14982 |  | 15081 |  | -99 |  | -0.7 | % | 15 |  | 0.1000000000000001 |  | -114 |  | -0.8 |  | 30961 |  |  | 45943 |  | 45346 |  | 597 |  | 1.3 | % | 8 |  | 0.001278752009721051 |  | 589 |  | 1.298721247990279
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 29

कार्यक्रम PROGRAM |  |  | कृ तष पररर्ोजनाओिं का तर्त्तीर् प्रतिरूपण FINANCIAL MODELLING OF AGRI PROJECTS | PROG CODE
 |  |  |  | IT 1665
तर्षर् समूह/JOB FAMILY |  |  | CREDIT
उद्देश्य/OBJECTIVE |  |  | ENHANCING     JOB     KNOWLEDGE,     ENABLING     PROJECT PREPERATION AND EFFECTIVE PROJECT APPRAISAL
लतक्षि समूह/TARGET GROUP |  |  | AEO  (SC  I  &  II  )  OF  POTENTIAL    AGRICULTURE  FINANCE BRANCH
अर्तध/DURATION |  |  | 5 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Welcome  or  Inaugural  address,  Discussion  on  program  objectives, Entry test
 | II | Guidelines on Agricultural Lending and Project Financing, Regulatory dimension & Business perspective, Overview on LAPS
 | III | Practical  Aspects  of  [NAME]  and  Term  Loan  Financing, Techno-economic-commercial appraisal
 | IV | Financial  appraisal  –  Balance  Sheet  Analysis  with  case  studies  on Ratio analysis Study of Farmer’s Income & expenditure statement [NAME]  formalities:  KYC  &  Due-diligence,  Leads  Conversion, Retail Credit Marketing/I-LEAD, Having eye on Advocate/ Valuer, HL & Vehicle loan Products, [NAME], Tie-ups arrangement, Project approvals, [NAME]
Day 2 | I | Financing  Dairy  farm  &  Poultry-  Scope  and  significance  (Practical aspects  related  to  Bank  finance),  Brief  knowledge  about  Piggery, Sheep/Goat rearing & breeding of [NAME]
 | II | Agri Value Chain Financing (AVCF)- Financing storage structures like [NAME] /Cold storage, [NAME] of Produce loan (Financing against   [NAME]   receipt)   &  collateral   management   aspects. Discussion on Area specific schemes & concessional ROI
 | III | Financing Farmer Producer Organizations (FPOs) & SHG/JLG
 | IV | Financial Inclusion , Financial Literacy Centres, BC, Aadhaar Enabled Payment Systems (AEPS)
Day 3 | I | Financing Horticulture (Orchard establishment & Estate management loans) / Scope and significance and of various Government Schemes
 | II | Hi-tech   and   High   Value   Agriculture-   Sectors   and   sub-sectors, [NAME] and Scope
 | III  & IV | Group presentation by participants on various projects
Day 4 | I, II, III & IV | FIELD VISIT (At least any two amongst the following)- To a local Dairy or Poultry farm financed by the bank, To a cold storage unit or warehouse/Rural Godown, To a poly-house or green house unit, To an agri-processing unit. Visit to Agri- Finance branch /AF-Hi-tech branch.
Day 5 | I | Customer Relationship Management
 | II | Motivation & effective Communication Skills
 | III | Implementation of OL, Prevention of Sexual Harassment, practicing Ethics at Work place
 | IV | Group  Discussion  on  Asset  and  Liability  Products  of  the  Bank  & Valediction
Spreadsheet: 135320d1325928786-can-you-lock-cells-so-they-can-never-be-changed-again-test-lock-areas070112
Sheet: Sheet1

ID NO. | APPLIANCE DESCRIPTION | APPLIANCE LOCATION | Order No. | CLASS | VISUAL INSPECTION | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  | Functional | DATE OF NEXT TEST | PASS OR FAIL | COMMENTS |  |  | SIGNATURE
 |  |  |  |  |  | Ohms |  |  |  |  | INSULATION
 |  |  |  |  |  | N | E | L1 | L2 | L3 | L1-N | L1-E | L2-N | L2-E | L3-N | L3-E | L1-L2 | [NAME] | [NAME]
 |  |  |  |  |  |  | K
Spreadsheet: 44847aaf-3c72-4654-81a4-c9262a7a4d10
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261662 | 17485 | Alberto | Ceriani | ITA | 9 | 00:14:43 | 00:02:46 | 00:33:18 | 00:00:00 | 00:26:21 | 1 | 01:17:07
Spreadsheet: 108212d1305260856-selecting-stars-with-mouse-click-and-totaling-700643
Sheet: Sheet1

 |  |  |  |  |  |  | « | « | « | « | «
 |  |  |  |  |  |  | « | « | « | « | «
 |  |  |  |  |  |  | « | « | « | « | «
 |  |  |  |  |  |  | « | « | « | « | «
 |  |  |  |  |  |  | « | « | « | « | «
 |  |  |  |  |  |  | « | « | « | « | «
 |  |  |  |  |  |  | « | « | « | « | «
Spreadsheet: 50476d1249928422-conditional-concatenation-conditional_concatenate
Sheet: Sheet1

 | INPUT DATA
 | Person | Date | Activity | Transferred by | Received by
 | Able | 1987-01-01 00:00:00 | Transfer from | Able Co
 |  |  | Transfer to |  | Bain Co
 | Able | 1992-01-03 00:00:00 | Transfer from | Able Co
 |  |  | Transfer to |  | [NAME]
 | [NAME] | 1987-01-03 00:00:00 | Transfer from | [NAME]
 |  |  | Transfer to |  | Smith Co
 | [NAME] | 1987-10-03 00:00:00 | Transfer from | [NAME]
 |  |  | Transfer to |  | [NAME]
DESIRED OUTPUT
From | Transfer Date | To
Able | 01/01/87,03/01/92 | Bain Co, [NAME] |  |  |  |  | 1987-01-01 00:00:00 | 1992-01-03 00:00:00
 |  |  |  |  |  |  | Bain Co | [NAME]
[NAME] | 03/01/87,03/10/87 | Smith Co, [NAME] |  |  |  |  | 1987-01-03 00:00:00 | 1987-10-03 00:00:00
 |  |  |  |  |  |  | Smith Co | [NAME]
Spreadsheet: 93723d1293484020-sumif-formula-book1-2-
Sheet: Sheet1

In sheet A
Record | Number
2010-01-15 00:00:00 | 4
1934-02-01 00:00:00 | 5
2010-01-30 00:00:00 | 5
2010-10-20 00:00:00 | 3
2010-02-12 00:00:00 | 2
2010-12-21 00:00:00 | 8
In Sheet B
Record | Total from Sheet A |  |  | Row Labels | Sum of Number
Jan |  |  |  | sij | 9
Feb |  |  |  | vlj | 7
Oct |  |  |  | lis | 3
Dec |  |  |  | pro | 8
 |  |  |  | Grand Total | 27
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 7-028,089

 |  |  |  |  |  |  |  | 7-028   7-089
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY