tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5823ac4f-d53b-4121-a01c-1a1a85fb7257
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: |  |  | 2011-10-25 09:58:52.870000
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.5 | 101.634 | 101.509 | 101.384 | 101.009 |  | and are added to price quote
4.375 | 101.151 | 101.026 | 100.901 | 100.526
4.25 | 100.424 | 100.299 | 100.174 | 99.799 |  | Note: | Refer To Price [NAME]
4.125 | 99.925 | 99.8 | 99.675 | 99.3 |  |  | For all Price Adjs
4 | 99.458 | 99.333 | 99.208 | 98.583
3.875 | 98.907 | 98.782 | 98.657 | 98.032
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.403 | 101.278 | 101.153 | 100.778
3.75 | 100.909 | 100.784 | 100.659 | 100.284
3.625 | 100.344 | 100.219 | 100.094 | 99.719
3.5 | 100.009 | 99.884 | 99.759 | 99.384
3.375 | 99.56 | 99.435 | 99.31 | 98.685
3.25 | 99.056 | 98.931 | 98.806 | 98.181
 |  |  |  |  |  | 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 | 2011-11-08 09:58:52.870000
30 DAY | 2011-11-23 09:58:52.870000
45 DAY | 2011-12-08 09:58:52.870000
60 DAY | 2011-12-23 09:58:52.870000
90 DAY | 2012-01-22 09:58:52.870000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 2097f021-9820-4028-8c98-3d697611b658
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42314259 | 2014-07-15 17:34:39 | ALLIES | 0 | 5 | 6 | 1567650 | Gotthard Heinrici | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42330671 | 2014-07-16 20:48:10 | ALLIES | 1 | 6 | 2 | 1053403 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42330825 | 2014-07-16 21:02:58 | AXIS | 1 | 6 | 3 | 1053403 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42434809 | 2014-07-24 13:37:53 | ALLIES | 0 | 3 | 5 | 1606351 | player1606351 | 7430 | mediterranean | 1942-05-27 | 1942-05-27 | 1st Armoured to the rescue | Engagement blindé
42435018 | 2014-07-24 14:12:27 | AXIS | 1 | 6 | 4 | 1542223 | guy.warmoes | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42435236 | 2014-07-24 14:35:09 | ALLIES | 0 | 2 | 6 | 1542223 | guy.warmoes | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
Spreadsheet: 741349d1626981809-need-to-find-corresponding-ids-but-vlookup-doesnt-work-what-formula-do-i-use-example-file
Sheet: Sheet1

ID | NAME | EXTENSION |  | BID | ID | Name | I have BID values separately and need to find corresponding names and IDs based off BIDs are in the extension
1234567 | Example | (45986712B) or (452837456B) |  |  | ? | ?
2456778 | Sample | (45872312B) and (21435465B) |  | 5648493048B | ? | ?
4567890 | Name | (87432317B) and (42873452B) |  | 985746324B | ? | ?
345321 | Excel | random words (34512985B) and random (25467832B) |  | 452837456B | ? | ?
9876543 | Word | random words <=30 (43564898B) |  | 43564898B | ? | ?
9873456 | Outlook | 5648493048B |  | 87432317B | ? | ?
2345678 | Test | 985746324B |  | 34512985B | ? | ?
Spreadsheet: 813435d1673754793-help-with-countif-and-today-function-copy-of-blank-worksheet
Sheet: Blank Worksheet

 | Blank Worksheet |  |  |  |  | Items Due |  |  | Items Past Due
 |  |  |  |  |  | Items Not Due |  |  | Items Not Past Due
 |  |  |  |  |  | Items Due Within 0-30 Days |  |  | Items 0-30 Days Overdue
 |  |  |  |  |  | Items Due Within 31-60 Days |  |  | Items 31-60 Days Overdue
 |  |  |  |  |  | Items Due Within 61-90 Days |  |  | Items 61-90 Days Overdue
 |  |  |  |  |  | Items Due Above 90 Days |  |  | Items Above 90 Days Overdue
 | Date | Last Name | First Name | Name | Passcode | Office | Due Date | Reminder Date | Completion  Date | Status | Days Overdue | Aging Group
 |  |  |  |  |  |  | 2023-01-01 00:00:00
 |  |  |  |  |  |  | 2022-12-15 00:00:00
 |  |  |  |  |  |  | 2023-02-01 00:00:00
 |  |  |  |  |  |  | 2023-03-01 00:00:00
 |  |  |  |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  |  |  | 2023-05-01 00:00:00
 |  |  |  |  |  |  | 2022-11-16 00:00:00
 |  |  |  |  |  |  | 2022-11-10 00:00:00
 |  |  |  |  |  |  | 2022-10-16 00:00:00
 |  |  |  |  |  |  | 2022-10-14 00:00:00
Spreadsheet: 791417d1660328551-vlookup-across-multiple-sheets-and-add-results-sample-finance
Sheet: Apr

Monthly Financial Report
Deposits | Source |  | Expense | Vendor |  | Allocated Funds | Reason |  | Previous Month Bal | Current Bal | Allocated Bal | Available Bal |  | Deposits
5000 | Income |  | 125 | Fuel |  |  |  |  |  |  |  |  |  | Payments
 |  |  | 300 | Cell |  |  |  |  |  |  |  |  |  | Previous Allocated
 |  |  | 200 | Cable |  |  |  |  |  |  |  |  |  | Newly Allocated
Spreadsheet: 298318d1392757413-need-total-sum-of-hours-for-each-shift-assigned-to-each-day-with-no-breaks-help
Sheet: -3

 |  | Weekly Department Schedule |  |  |  | Weekly Allocated Hrs: |  |  |  |  | Pd / Wk:
 |  | Week Commencing Date: |  | 2013-05-05 00:00:00 |  |  | Department: | Fresh Foods |  | Week:
 | Dinners \/
 |  | Name | [NAME] | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Total
 | 3:00:00 |  | 24 |  |  |  |  | 10:30:00 | 10:30:00 | 10:30:00
 |  |  |  |  |  |  |  | 19:30:00 | 19:30:00 | 19:30:00
 |  |  | 16 | 12:00:00 |  |  |  | 09:30:00 | 09:30:00 | 09:30:00
 |  |  |  | 16:00:00 |  |  |  | 13:30:00 | 13:30:00 | 13:30:00
 | 1:00:00 |  | 39 |  |  | 09:00:00
 |  |  |  |  |  | 17:00:00
 | 1:00:00 |  | 20 |  | 09:30:00
 |  |  |  |  | 18:30:00
 | 2:00:00 |  | 16 |  | 10:00:00 |  |  |  | 10:00:00
 |  |  |  |  | 19:00:00 |  |  |  | 19:00:00
 |  |  | 12
 |  |  | 12 | 13:30:00
 |  |  |  | 17:30:00
 |  |  | 16 | 11:00:00 | 17:30:00 | 17:30:00 |  |  |  | 12:00:00
 |  |  |  | 15:00:00 | 21:30:00 | 21:30:00 |  |  |  | 16:00:00
 |  |  | 16 | 13:00:00 |  |  |  |  |  | 16:00:00
 |  |  |  | 17:00:00 |  |  |  |  |  | 20:00:00
 |  |  | 15 |  | 16:30:00 | 16:30:00 |  |  | 16:30:00
 |  |  |  |  | 21:30:00 | 21:30:00 |  |  | 21:30:00
 |  |  |  | 13:30:00
 |  |  |  | 17:30:00
 |  |  |  |  |  |  | 17:30:00 | 17:30:00
 |  |  |  |  |  |  | 21:30:00 | 21:30:00
 |  |  |  |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  |  |  |  | 21:00:00
 |  |  | 39 |  | 13:30:00 | 13:30:00 | 13:00:00 | 13:00:00 | 13:00:00
 |  |  |  |  | 21:00:00 | 21:00:00 | 21:00:00 | 21:00:00 | 21:00:00
 | 0:30:00 |  |  | 10:00:00
 |  |  |  | 16:30:00
 |  |  |  |  |  |  |  |  |  | 13:30:00
 |  |  |  |  |  |  |  |  |  | 21:30:00
 |  | Total
 | Dinners>> |  |  | 00:30:00 | 02:00:00 | 01:00:00 | 01:00:00 | 02:00:00 | 02:00:00 | 03:00:00
Spreadsheet: andrew_lewis__96__CrackSpreadOptions
Sheet: Crack Spread Option

 |  | Exotica Crack Spread Option:  HEAT
 |  | (ERCOT Example from Megawatt Daily in Case Study #2)
 | EffDt | 2000-11-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | OUTPUTS
 | INPUTS |  |  |  |  |  |  |  |  |  | RetType | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Fwd Price 1 | Fwd Price 2 | (Heat Rate)/1000 | Ann.IntRt | [NAME] | Vol.2 | Correlation | ExpDt | Days | OptType |  | Price | Delta 1 | Delta 2 | Gamma 1 | Gamma 2 | Vega 1 | [NAME] | Eta | Rho | Theta | Charm 1 | Charm 2 | CrossGamma
 | 54.58 | 5.83 | 7 | 0.0525 | 5.45 | 5.45 | 0.5 | 2000-12-29 00:00:00 |  | 1
 | 54.58 | 5.83 | 8 | 0.0525 | 5.45 | 5.45 | 0.5 | 2000-12-29 00:00:00 |  | 1
 | 54.58 | 5.83 | 9 | 0.0525 | 5.45 | 5.45 | 0.5 | 2000-12-29 00:00:00 |  | 1
 | 54.58 | 5.83 | 10 | 0.0525 | 5.45 | 5.45 | 0.5 | 2000-12-29 00:00:00 |  | 1
 | 54.58 | 5.83 | 12 | 0.0525 | 5.45 | 5.45 | 0.5 | 2000-12-29 00:00:00 |  | 1
 | 54.58 | 5.83 | 20 | 0.0525 | 5.45 | 5.45 | 0.5 | 2000-12-29 00:00:00 |  | 1
 |  |  |  |  |  | Had to scale column M by the gas price!!!
Spreadsheet: andy_zipper__182__DYNEGY-ICE VOL May14
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  May-12-01 thru May-14-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: gogo master

Ambient on/off
eRepublik – Online Strategy Game
Sep20 Day 1,400 of the New World
Home
My Land
Wars
Market
Marketplace
Job market
Monetary market
Companies for sale
Community
World Map
News
My Party
Elections
Military Unit
Country administration
Invite friends
Badges
Get Gold & Extras
[NAME]
[NAME]
27
60
Eat food
Gold2.24 Gold
BAM411 BAM
HRK1625 HRK
Missions
X
You don't have enough Gold to complete the task Get Gold
Completed!
2011-10-03 00:00:00
2011-10-03 00:00:00
2011-10-03 00:00:00
Reward
Ok
Congratulations, your rank is now
Rank Bonus on attack +5%
Energy bar
Ok
Strength
Experience points
Health
Rank points
Gold
Energy bar
[NAME]
Free Lands
Scope
Bazooka
Weapons
Weapons
Weapons
Food units
Food units
Food units
Grain Farms
0 0
Logout
Experience level: 27
Experience points: 10027
Next level at: 15000
• Working, training and fighting decreases health
[NAME], health boxes, food, hospitals restore health.
This action restores as much health as possible by eating Food from your Storage.
You can recover up to: 450 / 450 Health
100 more recoverable Health in: 00:59:59
Food limit reached
You have reached your food consumption limit.
You can recover 100 health every hour.
100 more recoverable Health in: [NAME]
Buy health kit Close
gogo master
[NAME]
Add as a friend Send message Donate
Experience level 27
13,028 / 15,000
Location: FranceFrance, Auvergne Citizenship: CroatiaCroatia
eRepublik birthday
Dec 02, 2010
National rank: 1115
Party Member
[NAME] eHrvatskeSavez Komunista eHrvatske Far-left Wing
Member
HV 1.GB Tigrovi HV 1.GB Tigrovi
Press director
Macedonian News IIIII
Friends(1758)
dimzaaa
mal pariz
[NAME]
Makedonec 95
Strafciger
MakTom
[NAME]
PanchoVillaMKD
Karan.SS
view all
Land of gogo master: 12 buildings
Visit
About me
Wiki page
Add me for friend and Subscribe my newspaper :)
Achievements
hard worker
5
Hard Worker
Worked 30 days in a row
congressman
Congress Member
Win the Congress elections
president
Country President
Win the Presidential elections
media mogul
1
Media Mogul
Reached 1000 subscribers to your newspaper
battle hero
1
Battle Hero
Reach the highest war influence in a battle
campaign hero
Campaign hero
Reach the highest war influence in a campaign
resistance hero
3
Resistance Hero
Started a resistance war and liberated 3 regions.
super soldier
12
Super Soldier
Advance 250 strength points
society builder
1
Society Builder
Invited 10 people to eRepublik and helped them reach level 10
mercenary
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
3,241.50
Super soldier:3,241 / 3,250
Rank
General *General *
Rank points:
871,677 / 950,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 887698d1738004914-looking-for-help-analyzing-patch-date-data-while-including-two-additional-columns-of-info-patchdata
Sheet: Sheet1

Device | Patch Date | Country |  | Expected Results
Model A | 2024-03 | MEX |  | Device | Latest patch common to all countries
Model A | 2025-01 | USA |  | Model A | 2024-12
Model A | 2024-12 | CAN |  | Model B | 2024-10
Model A | 2024-12 | MEX
Model A | 2024-05 | MEX |  | Patching is cumulative, means new patch contains all previous patches.
Model B | 2024-12 | USA
Model B | 2024-03 | USA
Model B | 2024-10 | FRA
Model B | 2024-05 | FRA
Model B | 2024-11 | UK
Model B | 2024-11 | GER
Spreadsheet: 002445ff-7eb0-40d5-ac69-e1617fb182bf
Sheet: Sheet1

Master [NAME] Seminar 13-14.09.2014    LA NUCIA (SPAIN) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Name school/club : |  |  |  | Contact person :
Association : |  |  |  | E-mail :
 |  |  |  | Phone :
 | Name | Surname | Age | SATURDAY | SUNDAY | BELT | CLUB | ARRIVAL | DEPARTURE
example | Vicente | Ibáñez | 49 | yes | yes | IV | [NAME] (Spain) | 2014-09-12 00:00:00 | 2014-09-14 00:00:00 | 45
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 |  |  |  |  |  |  |  |  |  |  | total
 |  | CONTACT: | v.ibañez@taekwondo-itf-spain.com |  |  | [EMAIL]
 |  |  |  |  |  | https://www.youtube.com/watch?v=XuYxdqw_PaU
Spreadsheet: 876691d1723430958-conditional-formatting-based-on-different-days-and-time-on-multiple-applications-appl_test
Sheet: Daily Online Report

 | Systems | Time (hrs) | Status | Note | Systems (SLA) Targets |  | Mon to Thursday |  | Friday
 | Application 1 | 19:31:00 | Red |  |  |  | 08:00:00 | 19:30:00 | 08:00:00 | 19:30:00 | before 8:00am or equal to 8:00am = Green 8:00am until 19:30 is yellow after 19:30 is Red
 | Application 2 | 21:00:00 | yellow |  |  |  | 08:00:00 | 21:00:00 | 08:00:00 | 21:00:00
 | Application 3 | 08:45:00 | green |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00
 | Application 4 | 08:46:00 | yellow |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00
 | Application 5 | 08:40:00 | green |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 17:45:00
 | Application 6 | 18:45:00 | Red |  |  |  | 08:45:00 | 18:00:00 | 08:45:00 | 18:00:00
 | Application 7 | 19:00:00 | Red |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00
 | Application 8 | 08:00:00 | green |  |  |  | 08:45:00 | 18:00:00 | 08:45:00 | 18:00:00
 | Application 9 | 08:45:00 | green |  |  |  | 08:45:00 | 18:00:00 | 08:45:00 | 18:00:00
 | Application 10 | 08:45:00 | green |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00
 | Application 11 | 08:45:00 | green |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 17:45:00
 | Application 12 | 24 | green |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 17:45:00
 | Application 13 | 24 | green
 | Application 14 | 24 | green
Spreadsheet: 159606d1338772702-excel-2007-top-ten-and-adjacent-cell-sum-book2-1-
Sheet: Sheet1

 | total points | 45 | 50 | 50 | 45 | 25 | 45 | 45 | 50 | 60 | 45 | 35 | 55
student |  | 25 | 35 | 45 | 45 | 20 | 35 | 45 | 20 | 35 | 40 | 30 | 25
mark
Spreadsheet: stacey_white__38830__20001 05 flash Report 62601 
Sheet: reconciliation

 |  |  |  | RECONCILIATION
 | ****  All in "Flash" signs, where negative=expense  and positive=revenue
 | UNIFY versus GL (SAP)
 |  |  |  | total Inter. Manuals in Unify don't need to be taken from GL manuals/WILLAMET. Manual
 |  |  | ALL Data |  |  | see [NAME] | see intercompany analysis - needs to be plugged | (Unify vs GL - difference)
 |  |  | SYSTEM | MANUALS | Reconciled by Others accounts- manual | HARBORCOG - reversal is not picked up in [NAME]'s file | to tie Intercompany(what's in Unify vs. what booked) | TOTALS
 |  | [NAME]'s file | 67683056.98 |  | -8617214.43 | 1240922.34
 |  |  |  |  |  | Added in to Summary Region Table
 |  |  |  |  |  | [NAME]'s file does not pick up Unify gas Tr. 364- so we have to plug it in
 |  | SAP | 26686217.73 | 28818610.64 |  | in order for [NAME]'s entry to offset
 |  | Difference b/w Russ & GL Batch
 |  |  |  |  |  |  | Difference
Spreadsheet: 84416d1284474271-days-to-months-and-sum-for-period-sum-for-the-period
Sheet: Sheet1

 |  | Upside Potential |  |  |  |  |  |  | Month
 | [NAME] | 0.0115 |  |  | Start date |  | 2007-06-24 00:00:00
 | February-05 | 0.0618 |  |  | End date |  | 2010-08-15 00:00:00
 | 2005-03-01 00:00:00
 | April-05
 | May-05
 | June-05 | 0.0269
 | [NAME] | 0.0241
 | [NAME] | 0.0435
 | [NAME] | 0.06870000000000001
 | October-05 | 0.0046
 | [NAME] | 0.05469999999999999
 | December-05
 | January-06 | 0.07050000000000001
 | February-06 | 0.0761
 | March-06
 | April-06 | 0.092
 | May-06
 | June-06 | 0.0146
 | July-06
 | August-06 | 0.009300000000000001
 | September-06
 | October-06 | 0.013
 | November-06 | 0.08310000000000001
 | December-06 | 0.0321
 | January-07
 | February-07
 | March-07 | 0.0313
 | April-07
 | May-07
 | June-07 | 0.0138
 | July-07
 | August-07
 | September-07 | 0.0367
 | October-07 | 0.0457
 | November-07
 | December-07 | 0.0132
 | January-08
 | February-08 | 0.0475
 | March-08
 | April-08
 | May-08 | 0.1396
 | June-08
 | July-08
 | August-08
 | September-08
 | October-08 | 0.0482
 | November-08 | 0.0275
 | December-08 | 0.001200000000000001
 | January-09
 | February-09 | 0.01370527158198477
 | March-09 | 0.1332911107370214
 | April-09
 | May-09
 | June-09
 | July-09 | 0.01061419026351063
 | August-09
 | September-09 | 0.03342255439028997
 | October-09 | 0.07181570554466911
 | November-09
 | December-09 | 0.01275339201408477
 | 2010-01-31 00:00:00
 | 2010-02-28 00:00:00
 | 2010-03-31 00:00:00
 | 2010-04-30 00:00:00
 | 2010-05-31 00:00:00
 | 2010-06-30 00:00:00
 | 2010-07-31 00:00:00
 | 2010-08-31 00:00:00
Spreadsheet: 772078d1646998251-need-help-on-formula-to-get-score-for-help-calculation
Sheet: Sheet1

 |  |  |  | 2 | 2.5 | 3.5 | 4.5
 |  | Transaction Per Hr | Weight | Range |  |  |  | Out of 5
 |  | 21 | 5 | 16 | 21 | 24 | 27
 |  |  | I need formula in I4
 |  |  | Where on the basis of C4 Value
 |  |  | I should get Out of 5
 |  |  | For e.g
 |  |  | if C4  value falls in between 16 - 21  then out of would be in between 2 to 2.5.. And so on
 |  |  | if C4  value falls in between 21 - 24  then out of would be in between 2.5 to 3.5.. And so on
Spreadsheet: 823055d1679669592-conditional-formatting-using-the-right-function-staffing-workbook-eba
Sheet: AA

 |  |  | Project Name | Strategy | Workload Rating for Week | Workload Notes | Personal / Other Notes | Team Member | Team Member2 | Team Member3 | Team Member4 | Team Member5 | Team Member6 | Team Member7 | Team Member8 | Team Member9
 |  |  | Project FBI | K | 1 | XYZ | ABC
 |  |  | Project ABC |  | 2
 |  |  | Project DEF |  | 3
Spreadsheet: 98908d1297720670-excel-2007-averaging-averages-whilst-ignoring-zeros-production-2011
Sheet: Per Day Chart

 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00
 | Holiday | Holiday |  | Holiday | Holiday |  | Holiday | Holiday | Holiday | Holiday | Holiday | Holiday | Holiday | Holiday
 |  |  |  |  |  |  |  | 385
 |  |  |  |  |  |  |  | 305
 | 277 | 600 |  | 549 | 0 |  | 481
 | 341 |  |  | 752 | 0 |  | 593
 | 283 | 372 |  | 800 | 0 |  | 525
 |  | 257 |  | 571 | 0 |  | 313
 |  | 326 |  | 952 | 0 |  | 217
 | 406 | 318
 | 323 | 424 |  | 959 | 0 |  | 444 | 285 | 328 | 124 | 116 | 457 | 1512 | 700
 |  | 586 |  | 1014 | 0 |  | 578 | 306 | 203 | 120 | 134 | 1000 | 1705 | 300
 |  | 600 |  | 898 | 0 |  | 471 | 237 | 160 | 122 | 118 | 500 | 773 | 250
 |  | 636 |  | 917 | 0 |  | 497 | 191 | 186 | 149 | 98 | 600 | 1286 | 70
 | 271 | 459 |  | 540 | 0 |  | 442 | 264 | 141 | 191 |  | 407 | 545 | 492
 |  |  |  |  |  |  |  | 128 | 163 |  |  |  |  | 450
Spreadsheet: 751663d1634230869-forecast-formula-score-forecast
Sheet: Sheet2

Trainees | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Trainee 1 | 7 | 10 | -1 | 3 | 4 | 25
Trainee 2
Trainee 3
Trainee 4
[NAME] | 40
min | -10
difference from linear trend
Spreadsheet: 859379d1707780369-formula-for-a-unique-group-invoice-number-based-on-multiple-invoices-in-table-book1
Sheet: Sheet1

 | Vendor | Invoice # | Group Invoice # |  | QB Pre-Fix
 | AAA | 100 | 020824 - 1 |  | 20824 | *this is set for each weekly tracker based on date
 | AAA | 101 | 020824 - 1
 | AAA | 102 | 020824 - 1
 | BBB | 54 | 020824 - 2
 | CCC | 205 | 020824 - 3
 | CCC | 206 | 020824 - 3
 |  |  | *Looking to create a formula in column D
Spreadsheet: 707917d1607535450-identify-duplicate-pairs-and-display-number-forum_xls-unique
Sheet: Sheet1

UK General 1 | 202001 |  |  |  | 202001
UK General 2 | 202003 |  |  | UK General 2 | 202003
UK General 2 | 202003 |  |  | UK General 5 | 202003
UK General 2 | 202003 |  |  | UK General 7 | 202003
UK General 5 | 202003 |  |  | UK General 8 | 202003
UK General 5 | 202003 |  |  | UK General 10 | 202003
UK General 7 | 202003 |  |  | UK General 11 | 202003
UK General 8 | 202003 |  |  | UK General 12 | 202003
UK General 8 | 202003 |  |  | UK General 13 | 202002
UK General 10 | 202003 |  |  | UK General 14 | 202002
UK General 11 | 202003 |  |  | UK General 15 | 202002
UK General 12 | 202003 |  |  | UK General 16 | 202002
UK General 13 | 202002
UK General 14 | 202002
UK General 15 | 202002
UK General 16 | 202002
Spreadsheet: 12eb0f2f-a0cb-4342-8e21-04cafb37e120
Sheet: Sheet1

1910 - 5th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: Forest Park, St Louis, USA |  |  |  | October 17, 1010
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | USA | Hawley | [NAME] | Post | Augustus | America II | Peribonka/Lake Tschotogama/Quebec | 1887.6 | 1900-01-01 20:25:00
2 | GER | [NAME] | Hans | Perkins | [NAME] | [NAME] | [NAME] | 1814.5 | 1900-01-01 18:30:00
3 | GER | Abercron | Capt. [NAME] | Blanckertz | August | Germania | Coocoocahe/Quebec | 1720 | 1900-01-01 15:07:00
4 | SUI | Schaeck | Col. Theodor | [NAME] | [NAME] | Helvetia | Lake (?)Temiskaming | 1330.1 | 1900-01-01 12:28:00
5 | GER | Vogt | Ltn. L. | Assmann | W.F. | [NAME] | Gull Insland/Ontario | 1220.5 | 1900-01-01 08:16:00
6 | SUI | Messner | Capt. Emil | Givaudan | [NAME] | Azurea | Biscotasing/Ontario | 1203.6 | 1900-01-01 14:53:00
7 | FRA | Leblanc | Alfred | Mumm | [NAME] | Ile de France | Pogamasing | 1156.6 | 1900-01-01 11:00:00
8 | USA | Honeywell | [NAME] | Jolland | J.W. | St.Louis IV | Hillmann/Michigan | 887.3 | 1900-01-01 04:00:00
9 | FRA | Faure | [NAME] | Schmolck | E.G. | Condor | Two Rivers/Wisconsin | 657 | 22:20:00
10 | USA | Phul | [NAME] | O'Reilly | [NAME] | Million Population Cl. | Racine
Spreadsheet: 708765d1608018777-combine-data-feom-2-rows-in-2-comlumns-into-one-row-and-column-d-and-p-ans
Sheet: Mar

name | bol date | am/pm | d/p |  |  | total
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7
kate | 2020-03-02 00:00:00 | am | d
kitty | 2020-03-06 00:00:00 | pm | d
mary | 2020-03-15 00:00:00 | am | p
 |  |  |  |  | Total