tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 741685d1627277145-how-to-countif-formulas-with-time-example
Sheet: LEVEL 2

EVENT ID |  |  |  |  |  |  | 1 day, 0:00:00
EVENT
EVENT DATE
EXTERNAL DOORS
INTERNAL DOORS
SHOW START TIME
APPROX END TIME
EVENT AREA | LEVEL 2
EVENT VENUE | ARENA
 |  |  | Roster |  |  | Actual
NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
 | Supervisor [NAME] | Suites & Entrance E Supervisor - AREA WARDEN
Overall Total
 |  |  | Roster |  |  | Actual
NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
 | Usher - Suites | Outside Premier Club Directional
 | Usher - Warden Suite | Outside VIP Elevator 1 - WARDEN
 | Usher | Concourse outside Suite 201 & Royal Entrance
 | Usher | Entrance E - VIP Scanner 1 /Redeploy Level 3 Lift and Escalator Monitor on egress
 | Usher | Entrance E - VIP Scanner 2 /Redeploy Level 2 Lift and Escalator Monitor On Egress
 | Usher | Entrance E - Lift Operator
Total
Authorized by:
Name: |  |  | Date:               /                /
Position: | Event Manager
Spreadsheet: 161438d1339519655-help-with-filling-in-a-list-from-different-tabs-maybe-index-function-summarysheetexample
Sheet: Kendrick

Advertising Executive: | [NAME]
Designer: | [NAME]
Issue Date:
Advertiser | Slug | Special Placement?* | Size & Inches |  |  | Type of Ad |  |  | Color |  | Proof? | Price |  |  | Notes/Comments
 |  |  | Col. | Inch | Total Inches | CR | M | PU (specify date) | Color | 2nd Color (only for 2 spot color) |  | Already Paid | [NAME] | Trade
test4 |  |  | 3 | 4 |  |  |  |  | Full Color
test5 |  |  | 5 | 2 |  |  |  |  | Spot Yellow
test6 |  |  | 7 | 2 |  |  |  |  | Black & White
*You must fill in this column if your ad is a full page ad |  |  |  |  |  |  |  |  | Color Options |  |  | Summary
 |  |  |  |  |  |  |  |  |  | Black & White |  | Total Inches:
 |  |  |  |  |  |  |  |  |  | Spot Cyan |  | Total Ads:
 |  |  |  |  |  |  |  |  |  | Spot Magenta |  | Total Ad Cost:
 |  |  |  |  |  |  |  |  |  | Spot Yellow |  | Flash:
 |  |  |  |  |  |  |  |  |  | Spot Green |  | Within 10% of flash?
 |  |  |  |  |  |  |  |  |  | Spot Red
 |  |  |  |  |  |  |  |  |  | Full Color
Spreadsheet: 825497d1681365886-vlookup-multiple-dates-test-file-v1
Sheet: Sheet2

Monthly |  |  |  | Weekly
Day of month | Service | Amount |  | Day of week | Service | Amount
1 | Car Insurance | 12 |  | Friday | Food Shopping | 90
1
1
2 | Water | 40
2 | broadband | 20
2
3
3
3
4
4
4
5
5
5
6
6
6
7 | Electric | 60
7 | Insurance
7
8
8
8
9
9
9
10
10
10
11
11 | Mortgage | 489
11
12
12
12
13
13
13
14
14
14
15
15
15
16
16
16
17
17
17
18
18
18
19
19
19
20
20
20
21
21
21
22
22
22
23
23
23
24
24
24
25
25
25
26
26
26
27 | Insurance | 23
27
27
28
28
28
29
29
29
30
30
30
31
31
31
Spreadsheet: 88468d1288276677-totaling-qtys-from-multiple-tabs-materialsummary-array
Sheet: B1 Str

TH-10M01-w C4758-B1 Hughes Truss Assembly
Qty | Part # | Description |  |  |  |  |  |  | Midwest Part Number
 |  | [NAME]
1 | C4758.8AL | [NAME] Assembly--5 1/8" x 7 1/2" x 30' -0" Laminate Arm
1 | [NAME] | 5" x 3" x 1/4" x 15'-6" angle iron
4 | 2025 | Vee Braces
3 | 2817-15 | Deadend End Tee
6 | B89-6 | 7/8" x 9" Bolt with MF80
4 | B83-2 | 7/8" x 3" Bolt with MF80
10 | MF80
2 | S.W. | Plate
2 | GWB51 | 1/2" ground wire Bolt Assembly
 |  | Hughes Truss Assembly mounting Hardware
2 | 1260-AB | Grid Gain
2 | 1262-AB | Grid Gain
4 | 2727.8 | 7/8" Bonding Clip
2 | A783.1W-15 | 1W-15 Gain Fitting
2 | B812-6 | 7/8"x12" Bolt with MR80
2 | B824-6 | 7/8" x 24" Bolt with MF80
4 | MF80
4 | CW80 | 3/8" Curved Washer
4 | N80 | 7/8" Nut
4 | SLW2-80 | 7/8" Spring Washer
 |  | Hughes X-Brace and X-Brace Mounting Hardware
1 | 2094-14-6 | 14'-6" X-Brace
2 | 2840.1C | Center Clamp Rod
2 | 2840.2G | Center Clamp Strap
2 | B818-6 | 7/8" x 18" Bolt with CW80 & MF80
2 | B816-8 | 7/8' x 16" Bolt with CW80 & MF80
4 | 2727.8 | 7/8" Bonding Clip
4 | N80 | 7/8" Nut
4 | 2702.8 | 7/8" Spring Washer
4 | YC4C4 | Connector Crimpit #4 CU to #4 CU ([NAME])
4 | CW80 | Curved Washer
4 | MF80
 |  | Shield Wire Support-TM4/6M1-2 per tangent structure
6' | 8669-000250 | Wire-Flexible CU Braid (Belden)
4 | 989.1 | Damper-Spiral for 3/8" (PLP 5050104)
2 | 904 | Clamp-Parallel Grove 3/8" HS-#4 CU ([NAME])
10 ft | 833 | Conductor-Grd Wire #4 CU [NAME]
4 | YC4C4 | Connector-Crimpit #4 CU to #4CU ([NAME])
2 | 689.1 | Clamp-AGSusp w/Armor Rod (PLP AGS-7104)
2 | 1690.14 | 1501.6-14-B1CL 14" Shield wire Support (Hughes Brothers)
 |  | Ground Assembly-TM-9M1--2 per tangent structure
200 ft | #4 | Ground wire #4 Bare
2 | 632 | Cadweld-Type GT or Erico HammerLock EH58C1K (0632)
2 | 1445 | Coupling-Ground Rod 5/8"
4 | YC4C4 | Connector -Crimpit #4 to #4 Cu (BurndY YC4C4)
2 | 2501.1 | Molding-Wood 1" x 10' (Hughes 2501.1)
10 | 250174 | Staples-Galv. For Wood Molding (Hughes 250174)
30 | [NAME] | Staples-CU Coated Grd. Wire 2 x 1/2" x .162 ([NAME] or Chance 9169)
60 | 16D | Nails-Hot Dipped Galv.-for the Clips (16d)
60 | K5730-1 | Clips-Grd Wire Non-Static (Kearney 5730-1)
2 | 5/8" x 8' CW | [NAME]
 |  | Insulators  Assembly  [NAME]--three per tangent str
3 | SA-11 | Socket Eye
3 | AGS-5130 | Clamp-AGS   susp w/[NAME] for 795 ACSR "Drake"
3 | 1165.2 | Insulator-Susp 115 kV y [NAME] (OB S025036S2010)
3 | 2824 | Eye Bolt & Saddle 3/4" (Hughes 2824)
Spreadsheet: 73824d1274382097-goal-seek-as-a-formula-sample-break-even-calculations-for-profit
Sheet: Sheet1

 | Old | New
Price | 5 | 5.2
Unit Sales | 400 | 400
Revenue | 2000 | 2080
Expenses | 3 | 3.2
Cost of Goods | 1200 | 1280
Profit | 800 | 800
Old Profit is Constant
Can Change
Solve For to Make Profit Change Zero
Spreadsheet: 95245d1294873966-sum-product-if-three-fields-are-true-count-if
Sheet: Errors

Date | Line | SKU | Description | Name of Person Accountable | Position of Person Accountable | T or F | Location | Zone | Product Description
2011-01-03 00:00:00 | A |  |  |  |  |  |  | 1
2011-01-03 00:00:00 | C |  |  |  |  |  |  | 2
2011-01-03 00:00:00 | B |  |  |  |  |  |  | 2
2011-01-03 00:00:00 | A |  |  |  |  |  |  | 1
2011-01-03 00:00:00 | C |  |  |  |  |  |  | 5
2011-01-03 00:00:00 | C |  |  |  |  |  |  | 2
2011-01-03 00:00:00 | C |  |  |  |  |  |  | 2
2011-01-03 00:00:00 | E |  |  |  |  |  |  | 1
2011-01-04 00:00:00 | A |  |  |  |  |  |  | 3
2011-01-03 00:00:00 | B |  |  |  |  |  |  | 1
2011-01-04 00:00:00 | A |  |  |  |  |  |  | 1
Spreadsheet: 12fec4dd-e919-4f80-913c-54598e071180
Sheet: Content

Country Statistical Tables for North Africa
This contents sheet provides an explanation of each worksheet in the file.
Users are encouraged to read International Food Security Assessment, 2011-21 (FSA), which discusses global food
security issues and estimates food gaps for 77 lower income countries. The report was published in
July 2011 and is available at http://www.ers.usda.gov/Publications/GFA22/ .
The report estimates the number of hungry people in 2011 and 2021 as well as food gaps arising
from shortages in food availability as well as lack of access due to insufficient purchasing power.
A special article explores urbanization trends and issues in developing countries.
The tables and charts provided in this file are not found in the report.
This file contains:
- 4 country statistical tables and charts
The tab for each country table is identified by its two-letter country code (the country code key is listed
below.) The table contains 9 years of historical data and estimates/projections for 2011, 2016, and 2021.
Grain production data through 2010 are from United Nations, Food and Agriculture Organization (FAO).
Root production data are from FAOSTAT, available through 2009, then converted into grain equivalent.
Commercial grain imports are also from FAOSTAT and food aid data are from World Food Program,
converted into grain equivalent based on calorie content. Aggregate availability of all food is a calculated
amount of all food available, converted into grain equivalent. For information on the definitions and method
of calculation of food gaps please see [NAME] in the FSA report.
Each country sheet also contains two charts. The top chart graphs grain production and commercial
imports between 2002 and 2010. The second chart graphs grain production and commercial import
estimates/projections for 2011, 2016, and 2021.
Country code key:
DZ = Algeria
EG = Egypt
MA = Morcocco
TN = Tunisia
Spreadsheet: 158846d1338406940-best-way-of-setting-up-exam-database-exam-data
Sheet: Sheet1

Series Year | Series Code | Candidate name | Entry Code | Result UMS/Points
2011 | 1A | student a | exam1 | 44
2011 | 1A | student b | exam1 | 56
2011 | 1A | student c | exam1 | 65
2011 | 1A | student d | exam1 | 45
2011 | 6A | student a | exam2 | 78
2011 | 6A | student b | exam2 | 45
2011 | 6A | student c | exam2 | 67
2012 | 1A | student a | exam1 | 78
2012 | 1A | student a | exam3 | 46
2012 | 1A | student b | exam2 | 78
2012 | 1A | student c | exam1 | 54
2012 | 6A | student a | exam4 | 35
2012 | 6A | student b | exam3 | 56
2012 | 6A | student c | exam2 | 54
2012 | 6A | student c | exam3 | 34
Filter
Sum - Result UMS/Points |  | Series Year | Series Code |  |  | Maximum Module Mark
 |  | 2011 |  | 2012
Candidate name | Entry Code | 1A | 6A | 1A | 6A
student a | exam1 | 44 |  | 78 |  | 78
 | exam2 |  | 78 |  |  | 78
 | exam3 |  |  | 46 |  | 46
 | exam4 |  |  |  | 35 | 35
student b | exam1 | 56 |  |  |  | 56
 | exam2 |  | 45 | 78 |  | 78
 | exam3 |  |  |  | 56 | 56
student c | exam1 | 65 |  | 54 |  | 65
 | exam2 |  | 67 |  | 54 | 67
 | exam3 |  |  |  | 34 | 34
student d | exam1 | 45 |  |  |  | 45
Total Result |  | 210 | 190 | 256 | 179
Spreadsheet: 328675d1404012289-column-number-of-3-cell-containing-text-in-a-row-sample2
Sheet: Sheet1

is text
length
nth occurance
1
is text
length
nth occurance
1
Spreadsheet: 0152e851-70b9-4427-b60a-8620d3ca2bc3
Sheet: Dev Program Opt 1

 | HR&A Advisors, Inc.
 | Inner Loop East Reconstruction Project
 | Real Estate Development Scenario 1 Summary
 |  |  |  |  |  |  |  |  |  |  |  |  |  | rental unit mix
 | Site |  | Program | Total Land Area | Buildable Land Area | Unbuildable Land | Land use adjustment Factor | [NAME] | Total Building Area | Density | Parking SF | Parking Spaces Required | Parking Spaces Accomodated | Studio | 1 bed | 2bed | 3bed
 | 1 | a | Resi For Sale |  |  |  |  | 3 |  |  | included in unit |  |  |  |  |  | 13
 | 2 | a | Retail |  | 5600 |  |  | 1
 | 3 | a | Retail |  | 7400 |  |  | 1
 | 4 | a | Retail |  | 4850 |  |  | 1
 | 5 | a | [NAME] |  |  |  | 0.597 | 4
 | 6 | total
 | 6 | a | [NAME] |  |  |  | 0.535 | 4
 | 6 | b | Retail |  | 0 |  |  | 1
 | 7 | total
 | 7 | a | [NAME] |  | 0 |  |  | 4 |  |  |  |  |  | 0 | 0 | 0 | 0
 | 7 | b | Retail |  | 6000 | 0 |  | 1 |  |  |  | 18
 | 7 | c | Office |  |  |  |  | 3
 | 8 | total
 | 8 | a | [NAME] |  |  |  |  | 4
 | 8 | b | Retail |  |  |  |  | 1 |  |  |  | 17
 | 8 | c | Office |  |  |  |  | 3
 | 9 | total
 | 9 | a | [NAME] |  |  |  |  | 3
 | 9 | b | Retail |  |  |  |  | 1
 | 9 | c | Office |  |  |  |  | 3
 |  | Program | SF | Units | parking spaces
 |  | Resi For Sale
 |  | [NAME]
 |  | Retail |  | 0
 |  | Office |  | 0
 |  | Total
 |  | Parcel |  | Program | Program [NAME] | Parking Spaces
 |  | 1 |  | For Sale Residental | 13 Townhomes | 26
 |  | 2 |  | Retail
 |  | 3
 |  | 4
 |  | 5 |  | [NAME]
 |  | 6 |  | [NAME]
 |  | 7 | a | Retail |  | 18
 |  |  | b | Office |  | 54
 |  | 8 | a | [NAME]
 |  |  | b | Retail
 |  |  | c | Office
 |  | 9 | a | [NAME]
 |  |  | b
 |  |  | c
 |  | Total
Spreadsheet: 138812d1327923170-lookup-excel-forum-issue
Sheet: Newspapers

Newspaper quick selection | Code | Brochure Link | Costing Sheet | Web Link | Flying from
Doncaster Free Press | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
South Yorkshire Times | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
Bells (Epworth) | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
Gainsborough Standard | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
Selby Times | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
[NAME] | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
[NAME] | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
Goole & Thorne Courier | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
[NAME] | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
Doncaster Advertiser | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
The News | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
[NAME] | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
Newsletter titles | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
Worksop Trader | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
[NAME] and Guardian | SYN | Brochure Link | 0.135 | www.modernhotels.com/syn | Doncaster
Spreadsheet: 124378d1318357286-calculate-hi-points-points-2-
Sheet: BackNumberDatabase

Back Number | Horse | Owner | Exhibitor
154 | [NAME] | Suzy Bennet | [NAME]
120 | [NAME] | [NAME] | [NAME]
33 | Izzy | [NAME] | [NAME] Happy
99 | [NAME] | [NAME] | Zee
 | Sometimes horses also have multiple exhibitors
Spreadsheet: vkaminski__40853__ModelingProject
Sheet: Black Sholes

 | INPUT PARAMETERS |  |  | COMPUTATIONS
 | S | 100 |  |  | d | N(d) | N(-d)
 | X | 95 |  | d1
 | r | 0.05 |  | d2
 | b | 0.05
 | T | 0.75 |  | OPTION VALUES
 | s | 0.5 |  |  | Call | Put
 |  |  |  | Value
 |  |  |  | Delta
 |  |  |  | Function Calculated
Spreadsheet: kate_symes__18179__Cob 2-26
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-26 00:00:00 |  | 248.21 | 5600 | 195 | 240
 | 2001-02-25 00:00:00 |  |  |  |  |  |  |  | 181.6 | 2500 |  | 200 | 360
 | 2001-02-24 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 214.05 | 4252 | 232.89 | 760
 | 2001-02-23 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 296.91 | 1345 | 300 | 400
 | 2001-02-22 00:00:00 |  | 261 | 4000 | 200 | 200 | 233.22 | 2500 | 222.69 | 1730
 | 2001-02-21 00:00:00 |  | 283.75 | 4800 | 240 | 200 | 425 | 1050 | 372 | 750
 | 2001-02-20 00:00:00 |  | 326.82 | 4400 | 300 | 600 | 324.71 | 8650 | 350.06 | 1975
 | 2001-02-19 00:00:00 |  | 326.15 | 5200 | 300 | 600 | 382.2 | 4390 | 356.1 | 1540
 | 2001-02-18 00:00:00 |  |  |  |  |  |  |  | 399.12 | 4290 |  | 320 | 600
 | 2001-02-17 00:00:00 |  | 346.07 | 3360 | 320 | 200 | 397.33 | 8623 | 394.97 | 2510
 | 2001-02-16 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 444.06 | 5450 | 419.61 | 1985
 | 2001-02-15 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 436.92 | 5630 | 480.72 | 1815
 | 2001-02-14 00:00:00 |  | 323 | 2000 | 300 | 0 | 601.45 | 2755 | 404.44 | 1970
 | 2001-02-13 00:00:00 |  | 307.5 | 2400 | 315 | 0 | 400.85 | 9115 | 379.49 | 2005
 | 2001-02-12 00:00:00 |  | 287.5 | 2400 | 277.5 | 0 | 380.82 | 9260 | 330.18 | 1690
 | 2001-02-11 00:00:00 |  |  |  |  |  |  |  | 398.34 | 5105 |  | 250 | 0
 | 2001-02-10 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.49 | 9007 | 373.04 | 3310
 | 2001-02-09 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.64 | 9525 | 391.75 | 2705
 | 2001-02-08 00:00:00 |  | 360.63 | 3200 | 300 | 48 | 407.79 | 7436 | 402.59 | 2830
 | 2001-02-07 00:00:00 |  | 301.25 | 4800 | 231.43 | 1400 | 415.92 | 7768 | 431.28 | 1750
 | 2001-02-06 00:00:00 |  | 211.67 | 3600 | 200 | 600 | 458.43 | 2225 | 373.4 | 1560
 | 2001-02-05 00:00:00 |  | 200 | 4400 | 200 | 200 | 346.5 | 4395 | 308.59 | 2105
 | 2001-02-04 00:00:00 |  |  |  |  |  |  |  | 339.43 | 4946 |  | 206.67 | 1800
 | 2001-02-03 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 390.12 | 4411 | 362.33 | 1500
 | 2001-02-02 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 489.58 | 1945 | 388.1 | 1470
 | 2001-02-01 00:00:00 |  | 368.81 | 8400 | 319.17 | 1200 | 507.77 | 2990 | 399.65 | 1410
 | 2001-01-31 00:00:00 |  | 410.67 | 6000 | 330 | 240 | 558.06 | 2700 | 457.58 | 825
 | 2001-01-30 00:00:00 |  | 475 | 3600 | 330 | 200 | 570.15 | 1790 | 441.67 | 900
 | 2001-01-29 00:00:00 |  | 409.94 | 6640 | 387.5 | 0 | 508.72 | 2665 | 432.7 | 925
 | 2001-01-28 00:00:00 |  |  |  |  |  |  |  | 573.46 | 3080 |  | 350 | 600
 | 2001-01-27 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 575 | 1900 | 453.79 | 896
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 118275d1313586217-help-with-formula-for-league-table-league-table
Sheet: Sheet1

Name | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6
Person 1 | W | W | W | W | W | W
Person 2 | W | L | L | W | L | L
Person 3 | W | W | W | W | W | W
Person 4 | L | L | L | L | L | W
Person 5 | L | W | L | L | L | W
Person 6 | L | L | W | L | W | L
Highest pair
Spreadsheet: andy_zipper__173__DYNEGY-ICE VOL Apr19
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 1 | 1825000 |  | Carson , M | Firm-LD Peak | MWhs | 10 | 41600
[NAME], G | NG Fin BS, LD1 for IF | MMBtus | 1 | 920000 |  | Dorland , C | Firm-LD Peak | MWhs | 21 | 126400
Grand Total |  |  | 2 | 2745000 |  | [NAME], R | Firm-LD Peak | MWhs | 3 | 50400
 |  |  |  |  |  | Motley, M | Firm-LD Peak | MWhs | 1 | 10400
 |  |  |  |  |  | Grand Total |  |  | 35 | 228800
Spreadsheet: a0a69abf-dd3a-40c2-8717-a5851d8db536
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance  Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  |  | Approval Deadline |  | Reason
Taxicab Code Revision
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor
 |  |  |  |  | Applicants/ |  | Applicant
 |  |  |  |  | Proponents |  | [NAME]
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | Neighborhood and Community Services
 |  |  |  |  |  |  | Other
 |  |  |  |  |  |  | Taxicab Review Committee
Discussion (explain all aspects of the proposed |  |  |  |  | Opponents |  | Groups or Individuals
legislation, including future implications, any direct/
indirect costs, specific account numbers, ordinance
references, and budget page numbers.) |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or
 |  |  |  |  | Program |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Change
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
 |  |  |  |  | Is It Good |  | X |  | Yes
 |  |  |  |  | For The
 |  |  |  |  | Children? |  |  |  | No
Applicable Dates:
Reviewed by:
Reference Numbers
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 42

कार्यक्रम PROGRAM |  |  | REFRESHER PROGRAMME ON FINANCE & ACCOUNT | PROG CODE
 |  |  |  | IT 1901
तर्षर् समूह/JOB FAMILY |  |  | FINANCE & ACCOUNTS
उद्देश्य/OBJECTIVE |  |  | REFRESHER PROGRAMME ON FINANCE & ACCOUNT
लतक्षि समूह/TARGET GROUP |  |  | SCALE 1 TO 3
अर्तध/DURATION |  |  | 5 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Inauguration/Importance of Finance & Account in Banking
 | II | Accounting principles & Process: Scope, Accounting standard, IFRS, GAAP, etc
 | III | Accounting Process, Maintenance of cash/ book/ledger, Bank reconciliation statement
 | IV | Trial Balance, Depreciation, Operational aspects of accounting entries, Bill of Exchange, Capital & Revenue Expenditure, Case Study
Day 2 | I | Bank Audit & Inspection - Discussion on critical tools for protecting bank & customer
 | II | Financial statements; Balance sheet & its components
 | III | Balance sheet Ratio analysis -Advantages, uses, limitation
 | IV | Cash flow and Fund Flow analysis, Preparation of final accounts, Company accounts
Day 3 | I | Working capital Management, Assessment of working capital/Financing of FB/NFB Credit
 | II | Term loan appraisal/case study
 | III | Financial Management Accounting, MIS, FIMS etc.
 | IV | Financial analytical calculation of interest & annuities, YTM
Day 4 | I | Capital investment decision, Equipment leasing & Lease finance
 | II | Implementation of Accounting in LAPS/CBS
 | III | Capital structure & cost of capital in Financial Management
 | IV | Technology Impact on Accounting & Finance, Utilization of AI, ML, DL, Block chain Technology etc.
Day 5 | I | Taxation in banking sector, Income tax, TDS/TCS/deferred tax, GST
 | II | Overview of cost & Management Accounting, [NAME] methods; Budgetary control
 | III | Managing tax compliance, tax planning strategies in banking account & finance
 | IV | Ethics & value system in banking aspects, Implementation of OL, Feedback & Valediction
Spreadsheet: 187821d1350588416-multiple-look-up-testcase
Sheet: Desired Output

[NAME] | Contracts |  |  | [NAME] | CONTRACTS
123_ABCD | 127650~[NAME] |  |  | 123_ABCD
 | 1244360-ZZRO~8792x3 |  |  | 456_DEFG
 | 1895436-LLGT~90422vT |  |  | 789_GHIJ
 | 1244360-ZZRO~872x3 |  |  | 000_JKLM
456_DEFG | 127650~[NAME] |  |  | 111_PPPP
 | 1244360-ZZRO~8792x3 |  |  | 999_CCCC
 | 1895436-LLGT~90422vT |  |  | 999_DDDD
 | 1244360-ZZRO~872x3
789_GHIJ | 127650~[NAME]
 | 1244360-ZZRO~8792x3
 | 1895436-LLGT~90422vT
 | 1244360-ZZRO~872x3
000_JKLM | 127650~[NAME]
 | 1244360-ZZRO~8792x3
 | 1895436-LLGT~90422vT
 | 1244360-ZZRO~872x3
111_PPPP | 17960-bbCD-123
999_CCCC | 123960-KbLM-12x3
 | 196780-nuLM-2Yx3
 | 123960-KbLM-12x3
999_DDDD | 123960-KbLM-12x3
 | 196780-nuLM-2Yx3
 | 123960-KbLM-12x3