tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 820894d1678332841-need-help-fixing-formula-or-coming-up-with-new-one-re-adding-numbers-to-a-date-book1-2-
Sheet: Sheet1

 |  |  |  | Quarter Start |  | Length ([NAME]) |  | End Quarter
 |  |  |  | 2Q23 |  | 3
 |  |  |  | 2Q23 |  | 2
 |  |  |  | 2Q23 |  | 2
 |  |  |  | 2Q23 |  | 2
 |  |  |  | 3Q23 |  | 3
 |  |  |  | 3Q23 |  | 3
 |  |  |  | 4Q23 |  | 3
 |  |  |  | 1Q24 |  | 6
 |  |  |  | 3Q24 |  | 6
 |  |  |  | 2Q24 |  | 6
 |  |  |  | 4Q24 |  | 6
 |  |  |  | 1Q24 |  | 8
 |  |  |  | 2Q24 |  | 3
 |  |  |  | 3Q24 |  | 3
 |  |  |  | 4Q24 |  | 3
 |  |  |  | 1Q24 |  | 3
 |  |  |  | 2Q24 |  | 3
 |  |  |  | 3Q24 |  | 3
 |  |  |  | 1Q25 |  | 6
 |  |  |  | 3Q25 |  | 6
 |  |  |  | 2Q25 |  | 6
 |  |  |  | 4Q25 |  | 6
 |  |  |  | 1Q25 |  | 3
 |  |  |  | 2Q25 |  | 3
 |  |  |  | 3Q25 |  | 3
 |  |  |  | 4Q25 |  | 3
 |  |  |  | 1Q25 |  | 3
 |  |  |  | 2Q25 |  | 3
 |  |  |  | 3Q25 |  | 3
 |  |  |  | 1Q26 |  | 6
 |  |  |  | 3Q26 |  | 6
 |  |  |  | 2Q26 |  | 6
 |  |  |  | 4Q26 |  | 6
 |  |  |  | 1Q26 |  | 3
 |  |  |  | 2Q26 |  | 3
 |  |  |  | 3Q26 |  | 3
 |  |  |  | 4Q26 |  | 3
 |  |  |  | 1Q26 |  | 3
 |  |  |  | 2Q26 |  | 3
 |  |  |  | 3Q26 |  | 3
Spreadsheet: 3b4f8af4-b06d-4784-8854-b2ebe0ee073f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7373 | 40954 | Faye | Mcclelland | GBR | 21 | 00:13:03 | 00:01:27 | 00:33:45 | 00:00:00 | 00:22:14 | 1 | 01:10:32
7373 | 51205 | Anna | Bychkova | RUS | 23 | 00:14:28 | 00:01:37 | 00:40:16 | 00:00:00 | 00:26:00 | 2 | 01:22:22
7373 | 56506 | Alena | Kaufman | RUS | 22 | 00:15:36 | 00:01:37 | 00:39:39 | 00:00:00 | 00:31:47 | 3 | 01:28:41
Spreadsheet: 709734d1608535346-work-delay-we-have-given-a-task-and-want-to-count-how-much-is-work-delay-or-work-on-time-work-delay
Sheet: Sheet1

S.No. | Date | Day | Office Timing | Work Given to | Work Name | Work Deadline | Work Finish Time |  | Delay / Comp
 |  |  |  |  |  |  | Work Done | Date and Time (MM:DD:YY)
1 | 2020-12-03 00:00:00 | Thursday | 9:00 am to 6:00 pm | Rohit | Work 1 | 2020-12-04 16:00:00 | Rohit Work 1 Done | 2020-12-07 17:00:00 |  | Work Late by 19 Hour
2 | 2020-12-04 00:00:00 | Friday | 9:00 am to 6:00 pm | [NAME] | work 2 | 2020-12-07 11:00:00 | [NAME] Work 2 Done | 2020-12-07 10:30:00 |  | Work done before time
3 | 2020-12-05 00:00:00 | Saturday | 9:00 am to 6:00 pm | Rohit | Work 3 | 2020-12-05 14:00:00 | Rohit Work 3 Done | 2020-12-05 17:00:00 |  | Work Late by 3 Hour
4 | 2020-12-06 00:00:00 | Sunday | 9:00 am to 6:00 pm | Off
5 | 2020-12-07 00:00:00 | Monday | 9:00 am to 6:00 pm | [NAME] | Work4 | 2020-12-09 17:00:00 | [NAME] Work4 Done | 2020-12-10 17:00:00 |  | Work Late by 8 Hour
6 | 2020-12-08 00:00:00 | Tuesday | 9:00 am to 6:00 pm | Holiday
7 | 2020-12-09 00:00:00 | Wednesday | 9:00 am to 6:00 pm
7 | 2020-12-10 00:00:00 | Thursday | 9:00 am to 6:00 pm
 |  |  |  |  |  | 2020-06-17 14:17:00 |  | 2020-09-16 10:31:00 |  | We have done work before, can we get any Minus or Plus sign here
 |  |  |  |  |  | 2020-06-27 17:46:00 |  | 2020-06-19 10:31:00 |  | We have done work before, can we get any Minus or Plus sign here, also calculation is wrong here
 |  |  |  |  |  | 2020-06-27 17:46:00 |  | 2020-06-30 17:46:00 |  | Minutes are wrong here
 |  |  |  |  |  | 2020-06-27 16:19:00 |  | 2020-07-31 00:00:00 |  | wrong delay here
 |  |  |  |  |  | 2020-07-22 10:44:00 |  | 2020-07-31 00:00:00 |  | wrong delay here
 |  |  |  |  |  | 2020-08-10 13:09:00 |  | 2020-08-11 00:00:00 |  | No Value here
Spreadsheet: 329382d1404295150-scanning-barcodes-not-bringing-up-corresponding-data-in-the-table-barcode-table_test
Sheet: Barcodes

BARCODE | CODE | DESCRIPT
88698192009 | HP002 | HP 51649A Original Colour |  | 88698192009
88698191965 | HP003 | HP 51626A Black Original |  | 88698192009
88698687277 | HP006 | HP 23 C1823D Colour Original
884962780701 | HP013 | HP 27 C8727AE Original Cartridge
884962780725 | HP014 | HP 28 C8728AE Original cartridge
884962780626 | HP028 | HP 56 Original Cartridge
884962780664 | HP029 | HP 57 6657A Colour Original
829160180410 | HP031 | HP 130 C8767 Black original
829160180526 | HP032 | HP 134 C9363 Tri colour origonal
886111749041 | HP216 | HP 933XL Yellow Officejet Ink Cartri
4898899101474 | EPSON49 | Epson T0921 black generic
Spreadsheet: 456560d1460948029-dynamic-range-while-eliminating-blank-spaces-testspread1
Sheet: Sheet3

Cabinet | Model | Coffee | White | Honey |  | Cabinet | Model | Coffee | White | Honey |  | Cabinet | Model | Coffee | White | Honey |  | Cabinet | Model | Coffee | White | Honey |  | Cabinet | Model | Coffee | White | Honey |  | Cabinet | Model | Coffee | White | Honey |  | QUANTITY |  | COLOR
Base | B09 | 6 | 1 | 6 |  | Base Sink | SB30 | 16 | 4 | 6 |  | Wall | W09 | 2 | 1 | 7 |  | [NAME] | LAZY1 | 4 | 7 | 15 |  | Pantry | PC18 | 12 | 8 | 14 |  | Crowns | TOP | 6 | 9 | 10 |  | 0 |  | COFFEE
Base | B12 | 8 | 2 | 9 |  | Base Sink | SB33 | 23 | 8 | 15 |  | Wall | W12 | 4 | 2 | 14 |  | [NAME] | LAZY2 | 8 | 14 | 30 |  | Pantry | PC24 | 20 | 16 | 28 |  | Crowns | BOTTOM | 12 | 18 | 20 |  | 1 |  | HONEY
Base | B15 | 12 | 3 | 12 |  | Base Sink | SB36 | 30 | 12 | 24 |  | Wall | W15 | 6 | 3 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  | crwons | middle | 9 | 91 | 92 |  | 2 |  | WHITE
Base | B18 | 15 | 4 | 15 |  | base sink | sb40 | 44 | 88 | 89 |  | Wall | W18 | 8 | 4 | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Base | B24 | 12 | 5 | 18 |  |  |  |  |  |  |  | Wall | W24 | 10 | 5 | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Base | B30 | 1 | 7 | 21 |  |  |  |  |  |  |  | Wall | W30 | 12 | 6 | 41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Base | B33 | 4 | 8 | 26 |  |  |  |  |  |  |  | Wall | W33 | 14 | 7 | 48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
Base | B36 | 15 | 9 | 29 |  |  |  |  |  |  |  | Wall | W36 | 16 | 8 | 54 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
Spreadsheet: 173b3307-149a-4bde-81b9-2da2489ed350
Sheet: Denial Rate Trend By Race

 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
American Indian | 0.2006472491909385 | 0.1810344827586207 | 0.2285714285714286 | 0.1071428571428571 | 0.1764705882352941
Asian | 0.1507439310884887 | 0.1480111008325624 | 0.1818181818181818 | 0.1895306859205776 | 0.083
Black or African American | 0.1812080536912752 | 0.2009646302250804 | 0.1641025641025641 | 0.2613636363636364 | 0.08823529411764706
Native Hawaiian or Pacific Islander
Hispanic | 0.1100961329331419 | 0.103267466135845 | 0.1162715167262098 | 0.118123362705406 | 0.07542529206804673
White | 0.2191838451830038 | 0.2129840546697039 | 0.2150313152400835 | 0.1746987951807229 | 0.1657142857142857
Overall Total | 0.1107637477725326 | 0.1117507619370132 | 0.1149023964450087 | 0.1306039273805113 | 0.07201262372686845
Spreadsheet: 41493d1239966770-indicate-the-presence-of-a-drop-down-list-combo
Sheet: Sheet1

2 |  |  |  |  |  |  |  | validation list
 |  |  |  |  |  |  | Tasks 1
COMBO BOX |  |  |  |  |  |  | Tasks 2
EXAMPLE 1 |  |  |  |  |  |  | Tasks 3
 | NOTE THE LINKED CELL IS A1 JUST TO HIDE |  |  |  |  |  | Tasks 4
 | IT BUT YOU COULD PUT IT ANY WHERE |  |  |  |  |  | Tasks 5
 |  |  |  |  |  |  | Tasks 6
 |  |  |  |  |  |  | Tasks 7
 |  |  |  |  |  |  | Tasks 8
5 |  |  |  |  |  |  | Tasks 9
COMBO BOX | [NAME] IS A10 SO ITS VISIBLE |  |  |  |  |  | Tasks 10
EXAMPLE 2
 | IN EITHER CASE USE WHATS GENERATED
 | IN YOUR FORMULA (TRY SELECTING TASK 4)
 | E.G
 | USER SELECTED  TASK 4 DO    SOMETHING
Spreadsheet: 78897d1279189885-comparing-columns-example
Sheet: Sheet1

Distributor B UPC | Distributor B Weight | Distributor A UPC | Distributor A Weight
1234 | 0 | 1923 | 7 |  | A2 Would need to be changed
1365 | 0 | 9944 | 6 |  | A3 Would need to be changed
1825 | 6 | 1365 | 12 |  | A4 wwould NOT need to be changed because its not 0
5698 | 8 | 5698 | 8.5 |  | A9 would not be changed because Distributor A doesn't have the product
7741 | 9 | 1825 | 5
9452 | 6 | 9745 | 6 |  | IT MUST change in Column B
9745 | 5 | 1234 | 6.2
4659 | 0
Spreadsheet: phillip_m_love__30146__200002_OA
Sheet: WE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 40114955 | 99077880
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 12496421 | 31446645
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 52611376 | 130524525
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -40238851 | -98448147
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -12490224 | -31431478
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 262303 | 640136
 | Total Purchases: |  | -52466772 | -129239489
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | -11664 | -27603
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -9751 | -17021
 | Total Imbalances: |  | -21415 | -44624
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 29363 | 69225
18 |  | W/D (Purchase from Stg) | -470 | -1069
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -470 | -1069
 | Total Storage: |  | 28893 | 68156
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -152082 | -365450.8460497017
 |  |  | 0 | 0
23 | Fuel: |  | -262303 | -640136
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -167389
25 |  | Demand | 0 | -802458.92
 | Total Transport Expense: |  | 0 | -969847.92
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 2516504.28
31 |  | Prior Month Book Balance | 0 | -6953222
 |  | Total MTM Income | 0 | -4436717.72
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 4906529
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -19005
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 1656734.75
 |  | TOTAL INTRA-MTH
FT-West
 |  | Current Month MTM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 374098d1422652828-need-help-combining-table-data-from-a-range-of-worksheets-to-a-separate-worksheet-orientation-roster
Sheet: TOTAL HIRES

 | ARAMARK JOB FAIR NEW HIRE TOTALS
POSITION | JOB CODE | HIRED | PASSED | NEED | O/U
 |  |  |  |  |  |  | POSITION | JOB CODE | HIRED | PASSED | NEED | O/U
RSADMN_8171
POSITION | JOB CODE | HIRED | PASSED | NEED | O/U
 |  |  |  |  |  |  | [NAME]
RSCAT_8177 |  |  |  |  |  |  | POSITION | JOB CODE | HIRED | PASSED | NEED | O/U
POSITION | JOB CODE | HIRED | PASSED | NEED | O/U
RSCON_8173 |  |  |  |  |  |  | RSCLB_8174
POSITION | JOB CODE | HIRED | PASSED | NEED | O/U |  | POSITION | JOB CODE | HIRED | PASSED | NEED | O/U
RSKIT_8177
POSITION | JOB CODE | HIRED | PASSED | NEED | O/U |  | RSFAC_6925
 |  |  |  |  |  |  | POSITION | JOB CODE | HIRED | PASSED | NEED | O/U
RSWHS_8173
POSITION | JOB CODE | HIRED | PASSED | NEED | O/U
[NAME] |  |  |  |  |  |  | RSVND_8173
POSITION | JOB CODE | HIRED | PASSED | NEED | O/U |  | POSITION | JOB CODE | HIRED | PASSED | NEED | O/U
RSRET_8175 |  |  |  |  |  |  | RCKIT_8959
POSITION | JOB CODE | HIRED | PASSED | NEED | O/U |  | POSITION | JOB CODE | HIRED | PASSED | NEED | O/U
Spreadsheet: 71324d1271987264-retrieving-data-from-a-different-sheet-book1
Sheet: Data

 | CLIENT | STATUS
 | Cl1 | gre
 | Cl2 | re
 | Cl3 | amb
 | Cl1 | gre
 | Cl1 | amb
 | Cl1 | re
 | Cl3 | gre
 | Cl3 | gre
 | Cl2 | amb
 | Cl1 | re
 | Cl3 | amb
 | Cl2 | gre
 | Cl2 | gre
 | Cl3 | gre
Spreadsheet: 51932116-45da-457b-a0e9-3ab98e5e534e
Sheet: BP Training Croatia

 |  | TRAINING BUDGET TEMPLATE | 1 Workshop
 |  | Training Title: | Business plan development
 |  | Country | Croatia | NP Sjeverni Velebit
 |  | Regional BP development Lead
 |  | PROJECT STAFF PARTICIPANTS
 | Ref. | ITEM Description |  | number man/days | daily cost | Total cost
 | 1 | Honorare/Personal
 | 1.2 | Training local coordination: x days X Euro
 | 1.3 | External Trainers:  days x Euro
 | 1.4 | Translation fees:  days x  Euro | 2 | 1 | 373
 | 1.5 | Facilitation fees :  days X  Euro
 | Sub-total 1
 | Ref. | ITEM Description |  | number days | daily cost | Total cost
 | 2 | Rent of facilities & insurence
 | 2.1 | Meeting room  and equipment | in-kind
 | 2.2 | Translation cabine (  days x euro) |  | 1 | 68 | 68
 | 2.3 | Translation cabine transport |  | 1 | 119 | 119
 | 2.4 | Technician/operator |  | 1 | 68 | 68
 | Sub-total 2
 | Ref. | ITEM Description |  |  |  | Total cost
 | 3 | Travel costs
 |  | Local travel cost for regional project coordinator |  | 1 | 100 | 100
 |  | Local travel cost for regional BP lead |  | 1 | 100 | 100
 | 3.1 | Local travel costs for participants (30x80) | in-kind | 0 | 0 | 0
 | 3.2 | International travel costs lecturers: (Nº  lectures x [NAME] ) |  | 0 | 0 | 1100
 | 3.3 | Travel costs translater: Nº translater x Euro |  | 0 | 0 | 0
 | 3.4 | Local transport ( part x  Euro public transport) |  | 0 | 0 | 0
 | 3.5 | Local transport (Nº lecture + Nº translater x  Euro public transport) |  | 0 | 0 | 0
 | Sub-total 3
 | Ref. | ITEM Description | number participants |  |  | Total cost
 | 4 | Board and Lodging
 |  | Regional project coordinator | 1 | 1 | 80 | 80
 |  | Regional BP lead | 1 | 1 | 80 | 80
 | 4.1 | External Trainers: Nº person x Nº days x  Euro | 1 | 1 | 80 | 80
 | 4.2 | Participants: Nº participants x  days x  Euro | 30 | 1 | 80
 |  | Participants not sleeping in the hotel |  | 0 | 0 | 0
 | 4.3 | [NAME]:  days x  Euro
 | Sub-total 4
 | Ref. | ITEM Description |  | Number items | cost | Total cost
 | 7 | Printing
 | 7.1 | Documentation: Nº pax x  Euro
 | 7.2 | Certificates: Nº0 x  Euro
 | Sub-total 6
 | GRAND TOTAL
Spreadsheet: 40660d1239052220-index-match-how-to-prevent-n-a-error-index_match-q
Sheet: Sheet1

 |  | cost |  |  |  |  |  | TOTAL |  |  | date | cost |  | date | cost
 |  | apples | bananas | oranges | date |  | Date |  |  |  |  | grapes |  |  | pears
 |  | 2 |  |  | 2009-04-01 00:00:00 |  | 2009-04-01 00:00:00 | 9 |  |  | 2009-04-01 00:00:00 | 5 |  | 2009-04-01 00:00:00 | 2
 |  |  | 2 |  | 2009-04-02 00:00:00 |  | 2009-04-02 00:00:00 | 23
 |  |  |  | 14 | 2009-04-03 00:00:00 |  | 2009-04-03 00:00:00 | 30
 |  | 20 | 10 |  | 2009-04-04 00:00:00 |  | 2009-04-04 00:00:00 | 42 |  |  | 2009-04-02 00:00:00 | 10 |  | 2009-04-02 00:00:00 | 11
 |  |  |  | 11 | 2009-04-05 00:00:00 |  | 2009-04-05 00:00:00 | 21
 |  |  | 10 |  | 2009-04-06 00:00:00 |  | 2009-04-06 00:00:00 | 28
 |  | 15 | 10 | 11 | 2009-04-07 00:00:00 |  | 2009-04-07 00:00:00 | 57 |  |  | 2009-04-03 00:00:00 | 10 |  | 2009-04-03 00:00:00 | 6
 |  |  |  |  | 2009-04-08 00:00:00 |  | 2009-04-08 00:00:00 | 21
 |  |  | 5 | 22 | 2009-04-09 00:00:00 |  | 2009-04-09 00:00:00 | 45
 |  | 22 |  |  | 2009-04-10 00:00:00 |  | 2009-04-10 00:00:00 | 42 |  |  | 2009-04-04 00:00:00 | 5 |  | 2009-04-04 00:00:00 | 7
 |  | 25 |  | 9 | 2009-04-11 00:00:00 |  | 2009-04-11 00:00:00 | 37
 |  |  |  |  |  |  |  |  |  |  | 2009-04-05 00:00:00 | 2 |  | 2009-04-05 00:00:00 | 8
 |  |  |  | Change date in cells L7 or O7 (dd-mmm) to enforce error |  |  |  |  |  |  | 2009-04-06 00:00:00 | 7 |  | 2009-04-06 00:00:00 | 11
 |  |  |  |  |  |  |  |  |  |  | 2009-04-07 00:00:00 | 9 |  | 2009-04-07 00:00:00 | 12
 |  |  |  |  |  |  |  |  |  |  | 2009-04-08 00:00:00 | 12 |  | 2009-04-08 00:00:00 | 9
 |  |  |  |  |  |  |  |  |  |  | 2009-04-09 00:00:00 | 11 |  | 2009-04-09 00:00:00 | 7
 |  |  |  |  |  |  |  |  |  |  | 2009-04-10 00:00:00 | 6 |  | 2009-04-10 00:00:00 | 14
 |  |  |  |  |  |  |  |  |  |  | 2009-04-11 00:00:00 | 2 |  | 2009-04-11 00:00:00 | 1
Spreadsheet: 158881d1338421381-lookup-in-split-ranges-as-in-one-like-this
Sheet: Sheet1

Category 1 |  |  |  | Category 2
ProductA | ProductB | ProductC | TOTAL | ProductD | ProductE | ProductG | ProductH | TOTAL | etc.
10 | 40 | 20 | 70 | 5 | 15 | 25 | 30 | 75
10 | 40 | 20 |  | 5 | 15 | 25 | 30
 |  |  |  |  |  |  |  |  |  | Need to find Top 5 products EXCLUDING the total columns
ProductB |  |  |  |  |  |  |  |  |  | Number of columns before each total varies, meaning for one category it could be a sum of 3 values, for another 4, etc.
ProductH
ProductG
ProductC
ProductE
Spreadsheet: 808469d1670487548-combine-2-sheets-analysis3
Sheet: 5 BEST AND WEK STUDENTS

E. FIVE BEST STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
F. FIVE WEAK STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
Spreadsheet: 562ae94d-62d1-43ff-928d-1d1d3a0c2cb7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-06-20 09:29:46.240000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.495 | 101.37 | 101.245 | 100.87
3.75 | 100.721 | 100.596 | 100.471 | 100.096 |  | Note: | Refer To Price [NAME]
3.625 | 100.31 | 100.185 | 100.06 | 99.685 |  |  | For all Price Adjs
3.5 | 99.711 | 99.586 | 99.461 | 98.836
3.375 | 98.823 | 98.698 | 98.573 | 97.948
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.622 | 101.497 | 101.372 | 100.997
3.25 | 101.095 | 100.97 | 100.845 | 100.47
3.125 | 100.783 | 100.658 | 100.533 | 100.158
3 | 100.445 | 100.32 | 100.195 | 99.82
2.875 | 99.815 | 99.69 | 99.565 | 98.94
2.75 | 99.15 | 99.025 | 98.9 | 98.275
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-07-04 09:29:46.240000
30 DAY | 2012-07-19 09:29:46.240000
45 DAY | 2012-08-03 09:29:46.240000
60 DAY | 2012-08-18 09:29:46.240000
90 DAY | 2012-09-17 09:29:46.240000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 854360d1704274580-foto-vastzetten-op-tijdslijn-voorbeeld-tijdslijn
Sheet: Grafiekgegevens

[NAME] voor het [NAME] grafiek staan in dit werkblad. Verwijder dit [NAME]! Als u dit [NAME], kan dit de dynamische [NAME] werkmap beïnvloeden. | Verwijder dit [NAME]!
De titel voor de tabel staat in cel B2. | [NAME] grafiek
Tabelkoppen staan in de cellen B3 t/m [NAME].  Deze tabel wordt [NAME] bijgewerkt op basis [NAME] inhoud die in het werkblad Mijlpalen wordt ingevoerd. Waarschuwing: Als u inhoud in deze tabel wijzigt of verwijdert, kan dit de dynamische [NAME] in het werkblad [NAME] beïnvloeden. Ga naar cel A15 voor de volgende instructie. | Datum | Gebeurtenissen | Positie
Voer een incrementele waarde in om door de roadmap te scrollen. De titel voor deze functie staat in cel B15. Een tabel met een kop en één waarde staat in cel B16 en B17. Ga naar cel A19 voor de volgende instructie. | [NAME]
 | Rij-increment
 | 0
[NAME] zet de jaren voor de tijdlijn uit. Hiervoor moeten de jaren uit de lijst met mijlpalen worden gehaald.  De titel voor deze sectie is "[NAME]" in cel B19.  De jaarwaarden worden automatisch gegenereerd in de cellen C20 t/m [NAME]. Waarschuwing: Als u deze jaren verwijdert of wijzigt, kan dit de nauwkeurigheid van de Roadmap-grafiek beïnvloeden. Ga naar cel A24 voor de volgende instructie. | [NAME]
 |  | <-- [NAME] [NAME]
 |  | <-- [NAME] [NAME] (NB: dit kan leeg zijn als het hetzelfde [NAME] is als de beginpositie [NAME])
 |  | <-- [NAME] (NB: dit kan leeg zijn als het hetzelfde [NAME] is als de beginpositie [NAME])
Ringmarkeringen in [NAME] bevatten datums uit de tabel [NAME] grafiek in dit werkblad. De datums zijn de Eerste datum in cel C24, de Middelste datum in cel C25 en de Laatste datum in cel C26. Er zijn geen verdere instructies in dit werkblad. | Eerste datum
 | Middelste datum
 | Laatste datum
Spreadsheet: 888083d1738437720-work-out-costings-based-on-a-tab-and-have-drop-downs-work-costs-out-jt-
Sheet: Phones Required

Product | Price | Setup Cost
Yealink 1 | 140 | 0
Yealink 2 | 120 | 0
Yealink 3 | 180 | 20
Yealink 4 | 80 | 0
Yealink 5 | 89 | 10
Yealink 6 | 74 | 50
Yealink 7 | 140 | 100
Yealink 8 | 120 | 20
Yealink 9 | 180 | 0
Yealink Cordless 1 | 80 | 0
Yealink Cordless 2 | 89 | 20
Yealink Cordless 3 | 74 | 10
Yealink Cordless 4 | 80 | 20
Yealink Cordless 5 | 89 | 30
Yealink Cordless 6 | 74 | 40
Yealink Cordless 7 | 89 | 90
Spreadsheet: 114095d1309951275-workday-function-to-excluding-fridays-test
Sheet: Foglio1

2011-07-05 00:00:00 | 2011-06-26 00:00:00 |  | Holidays
2011-07-04 00:00:00 | 1 |  | 2011-06-30 00:00:00
2011-07-03 00:00:00 | 2
2011-07-02 00:00:00 | 3
2011-07-01 00:00:00
2011-06-30 00:00:00
2011-06-29 00:00:00 | 4
2011-06-28 00:00:00 | 5
2011-06-27 00:00:00 | 6
2011-06-26 00:00:00 | 7
2011-06-25 00:00:00 | 9
2011-06-24 00:00:00
2011-06-23 00:00:00
2011-06-22 00:00:00
2011-06-21 00:00:00
2011-06-20 00:00:00
2011-06-19 00:00:00
2011-06-18 00:00:00
2011-06-17 00:00:00
2011-06-16 00:00:00
2011-06-15 00:00:00
2011-06-14 00:00:00
2011-06-13 00:00:00
Spreadsheet: 648340d1572985771-need-my-dashboard-to-change-when-slicer-selected-on-pivot-test-dashboard1
Sheet: Sector View

Date | (All)
Count of Status | Column Labels
Hospital and Ward | Filled | Unfilled | Grand Total | % [NAME]
South Sector | 570 | 142 | 712
HCSW | 290 | 67 | 357
Registered | 279 | 75 | 354
Agency | 1 |  | 1
North Sector | 409 | 72 | 481
HCSW | 237 | 28 | 265
Registered | 172 | 44 | 216
Clyde Sector | 276 | 127 | 403
HCSW | 166 | 60 | 226
Registered | 107 | 67 | 174
Agency | 3 |  | 3
Women & Childrens Services | 212 | 46 | 258
HCSW | 101 | 11 | 112
Registered | 111 | 35 | 146
Regional Services | 136 | 39 | 175
HCSW | 54 | 12 | 66
Registered | 82 | 27 | 109
Diagnostics Directorate | 6 |  | 6
HCSW | 3 |  | 3
Registered | 3 |  | 3
Grand Total | 1609 | 426 | 2035