tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f5a60fd8-ecb2-430e-83ad-d84618afe2bd
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
43311461 | 2014-09-25 20:53:52 | AXIS | 1 | 6 | 4 | 1611343 | DDB73 | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
43311752 | 2014-09-25 21:20:37 | ALLIES | 1 | 6 | 2 | 1611343 | DDB73 | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
43361780 | 2014-09-29 07:46:27 | AXIS | 1 | 5 | 3 | 1581268 | Dain Ironfoot | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43361877 | 2014-09-29 07:57:39 | ALLIES | 1 | 5 | 3 | 1581268 | Dain Ironfoot | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43362088 | 2014-09-29 08:34:14 | ALLIES | 1 | 7 | 6 | 979406 | homez | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
43362182 | 2014-09-29 08:54:54 | AXIS | 1 | 7 | 5 | 979406 | homez | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: Conoco

 | Maljamar |  | Zia
Day | Measured | Scheduled | Measured | Scheduled
1 | 40803 | 40714 | 37694 | 35000
2 | 41335 | 40714 | 42690 | 35000
3 | 39966 | 40714 | 41584 | 40000
4 | 41167 | 40714 | 39857 | 40000
5 | 44360 | 43714 | 39563 | 40000
6 | 41924 | 43713 | 36834 | 39999
7 | 41447 | 43714 | 35036 | 38000
8 | 36290 | 40000 | 32619 | 34000
9 | 39937 | 38777 | 32705 | 31047
10 | 39339 | 38777 | 31138 | 31047
11 | 39932 | 43714 | 32600 | 35000
12 | 44225 | 42710 | 22986 | 32997
13 | 48063 | 44000 | 26734 | 23000
14 | 47229 | 50115 | 31012 | 33532
15 | 40048 | 37619 | 25456 | 29065
16 | 40576 | 50051 | 29835 | 35000
17 | 40047 | 41227 | 31203 | 33917
18 | 39329 | 39000 | 30953 | 32000
19 | 42235 | 43714 | 33768 | 32000
20 | 43145 | 43688 | 31869 | 31981
21 | 40601 | 43714 | 31726 | 32000
22 | 46395 | 43714 | 30615 | 32000
23 | 42750 | 44813 | 31000 | 34039
24 | 42833 | 42578 | 29054 | 40826
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  | 2444005.89 |  | -2072427.18
2001-06-24 00:00:00
Spreadsheet: 217887d1362240979-trying-to-combine-data-if-statement-maybe-trial-taly-ver-1
Sheet: Master

 |  |  | 1 |  |  |  | 2
 |  |  | JUNE June |  |  |  | July
ID # | EMPLOYEE NAME | classcode | Hours Reg | OT HRS | DT HRS | AMOUNT3 | Hours Reg2 | OT HRS2 | DT HRS2
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 0daf6cf8-2dc0-4e84-9038-ce83e39a4434
Sheet: Sheet1

Virginia Highlands Community College | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Travel Estimate Worksheet
Traveler's Name |  |  |  |  | Acct #(s) |  | 0
Date of Travel |  |  |  |  |  |  | 0
Destination |  |  |  |  |  |  | 0
Purpose of Travel
List Other Employees Traveling
Travel must be made by the most economical means including carpooling where possible. Justification for separate travel must be
submitted in writing for approval prior to departure. Separate travel without prior approval will not be reimbursed.
Estimated Expenses
Mileage Expense: |  | Round Trip Mileage |  | (Use whole miles only)
 | State Vehicle
State [NAME]? |  |  | Yes |  | No
 |  | Verified By/Date
 | Personal Vehicle: | (Cost Beneficial to College - Select One) | $.555/mile |  |  |  | 0
 | Occasional travel having an average daily mileage of 100 miles or less
 | Routine daily travel within our service area of 100 miles or less per day
 | Travel to/from airport providing commercial air service requiring overnight parking
 | Use of personal vehicle is cost beneficial (complete "Trip Calculator"  to determine) Ent. Car Rental or Reimbursement at $.555/mile
 | Personal Vehicle: | (Personal Convenience) | $.246/mile |  |  |  | 0
Meals and Incidentals Expenses:
(Includes bellhop/taxi tips, personal telephone calls, laundry, travel between lodging and places where meals are taken)
M & IE Rate |  |  | # Days 100% |  | # Days 75%
41 | In-state standard |  |  |  |  |  | 0
46 | Out-of-state standard |  |  |  |  |  | 0
51 |  |  |  |  |  |  | 0
56 |  |  |  |  |  |  | 0
61 |  |  |  |  |  |  | 0
66 |  |  |  |  |  |  | 0
Lodging: (Economy or Government Rate Requested) |  |  | Yes |  | No
** | Request exception to claim 150% lodging rate (must be approved by the President or VP - Financial Services) |  | Yes |  | No
Lodging Rate |  |  | # Days
 | In-state standard |  |  |  |  |  | 0
 | In-state other (specify) |  |  |  |  |  | 0
 | Out-of-state standard |  |  |  |  |  | 0
 | Out-of-state other (specify) |  |  |  |  |  | 0
Air, Rail, Taxi or Bus Fares:
Parking and Tolls:
Car Rental: (Fuel Service Options and Insurance Options are Non-Reimbursable)
Business Telephone Expenses:
Registration Fees:
Miscellaneous:  (Itemize)
Justification:(Required):  This travel is essential toVHCC operations because:
 |  |  |  |  |  | Total | 0
 |  | [NAME]'s Signature                                   Date
Approvals
 |  | Supervisor                                                       Date
 |  | Apropriate Department VP                             Date
 |  | President                                                         Date
 | (President/president's designee approval only needed if amount exceeds $500)
Spreadsheet: 130599d1322482257-find-max-and-min-in-duplicate-find-max-and-min
Sheet: Sheet1

 |  |  | name | [NAME] | min
pramod | 25 |  | pramod | 26 | 25
kumar | 20 |  | kumar | 28 | 20
pramod | 26 |  | raj | 79 | 68
kumar | 28
raj | 68
raj | 79
Spreadsheet: 73c0dc4f-772c-43a5-b55a-e472f7e17135
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (1 Entry):
 | 2 Analysis 2.8 Microscopes and optical image processing 2.8.12 Scanning tunnel microscopes
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Bruker Corporation | USA | Billerica | MA 01821 | A2.331/432
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 |  |  | 25469 | 23994
2 |  |  | 24783 | 22824
3 |  |  | 25183 | 23383
4 |  |  | 24558 | 24000
5 |  |  | 24079 | 24000
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -178519 | -46913
2001-08-31 00:00:00 | Balance | -1023263 |  | -400229
2001-09-05 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 | -58339.66 | Zia |  |  | 22864 | -24566
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia |  |  | 20379 | 2979
 |  |  |  | 26357 | 44144.84 | [NAME] |  |  | 26357 | 26521
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME] |  |  | 21544 | 36108
 |  |  |  | 24532 | -762222.24 | 500211,500212,500219,500230 - Coburn points |  |  | 24532 | 17769
 |  |  |  | Duke
Spreadsheet: gerald_nemec__11356__kernguarantee
Sheet: Sheet1

 |  |  | Schedule "A"
 |  | Enron Corp Limited Guarantee
 |  | Limited Liablility Amount
 |  | Package 1 | Package 2 | Total Liability |  | Use
Company
Hunt Oil Co. of Canada |  | x |  |  |  | 750000
Petro-Canada |  | x |  |  |  | 750000
Patina |  |  |  |  |  | 1135000
JM Huber |  |  |  |  |  | 1135000
Cannon |  |  |  |  |  | 1135000
FM Steel |  |  |  |  |  | 1135000
[NAME] |  |  |  |  |  | 1135000
ENA |  |  |  |  |  | 1135000
Notes to Legal | [NAME], Enron is providing the guarantee to each of these parties seperatly and up to the $ amount as stated above.
 | The $ amount as calculated represents the demand charge, multiplied by the term multiplied by the allocated capacity.
 | In the event that the term, tariff of volume changes so too will our guarantee need to be adjusted.
 | Proper names to be verified.
BT
Spreadsheet: 177242ea-f314-42c9-aac5-d8e10624affc
Sheet: Sheet1

Australian Bureau of Statistics | Unnamed: 1 | Unnamed: 2
Building  Approvals Data Items Available by Australian Statistical Geography Standard (ASGS)
Released at 11.30am (Canberra time) [NAME] 31 May 2011
 | Contents
 | Tables
 | 1 | ASGS Data Items, by Statistical Area 2 (SA2)
 | 2 | ASGS Data Items, by Local Government Area (LGA)
 | 3 | ASGS Data Items, by Greater Capital City Statistical Area (GCCSA), State and Australia
 | Explanatory Notes
 | More information available from the ABS website
 | Building Approvals, Australia, April 2011
 | Summary
 | Explanatory Notes
 | Inquiries
 | Further information about these and related statistics is available from the ABS website www.abs.gov.au, or contact the National Information and Referral Service on 1300 135 070.
 | © Commonwealth of Australia 2011
Spreadsheet: 1db2965f-1131-4846-822b-038f7f319518
Sheet: Instructions

Drexel University Club Sports
END OF YEAR REPORT - FY 2014
 |  |  | Application Guidelines
DEADLINE | March 7, 2014  |  11:59PM
Financial Timeline | February 12, 2014  |  9:00 PM  -  Budget/Allocation Workshop
 | February 12, 2014  |  9:00 PM  -  EOY Reports available on Club Sports Website
 | March 7, 2014  |  11:59 PM  -  EOY Reports due to [EMAIL]
 | March 9, 2014 - March 16, 2014 Budget Hearings (signups at Budget/Allocation Workshop)
 | June 6, 2014  |  5:00 PM  -  Last day to spend account funds
 | June 30, 2014   |   4:00 PM   -   Close of FY14
SUBMISSION INSTRUCTIONS | Fill out parts I - IV per the instructions below.  After completing the application, create a .zip file containing the application and any photos, supporting documentation, and attachments you wish to include.  Name the .zip file using the template CLUB NAME_EOY14.zipand email your submission to [EMAIL].
Part I | Fill this form with all past and planned SAFAC account expenses from FY14 (July 1, 2013 - June 30, 2014).  In the next column, do the same for proposed expenses for FY15 (July 1, 2014 - June 30, 2015). Be sure to include any supporting documentation (invoices, receipts, flyers, etc.) which may justify your expenditures or requests.
SAFAC (17)
Part II | Fill this form with all past and planned team account income/expenses from FY14 (July 1, 2013 - June 30, 2014).  In the next column, do the same for proposed expenses for FY15 (July 1, 2014 - June 30, 2015).  Be sure to include any supporting documentation (invoices, receipts, flyers, etc.) which may justify your expenditures or requests.
Team (71)
Part III | Fill this form with all capital items the team has purchased using SAFAC or team funds.  This may include, but is not limited to: goals, uniforms, helmets, and other equipment capable of being used for several years. Items such as balls, whistles, and other consumable items do not count towards this requirement.  For capital items where purchase date is unknown, try to estimate the year or season during which the item was purchased.
Capital Items
Part IV | Answer all questions on this form, including all details where necessary- NO QUESTIONS ARE OPTIONAL.  Be sure to include the required pictures and sign the form.  Remember, the answers from this section are used for the purpose of promoting and reviewing the Club Sports program with the Drexel Community and its Administration, so the quality of your submission has bearing on the future of Club Sports at Drexel.
Annual Report
Spreadsheet: 109953d1306763926-lookup-compare-and-copy-in-2-woorkbooks-match-and-copy-reply
Sheet: Result

 | 2 | 3 | 4 | 5 | 6
Barcode | Description | Att-1 | Att-2 | Att-3 | att-4
N/A | N/A | N/A | N/A | N/A | N/A |  | For [NAME] 'IF(AND(Data!B3=Master!B3,Data!C3=Master!C3,Data!D3=Master!D3,Data!E3=Master!E3,Data!F3=Master!F3),INDEX(Master!$A$3:$A$18,ROW(A1),1),"N/A")
N/A | N/A | N/A | N/A | N/A | N/A |  | For Description =IF(ISERROR(VLOOKUP($A3,Master!$A$3:$F$16,C$1,FALSE)),"N/A",VLOOKUP($A3,Master!$A$3:$F$16,C$1,FALSE))
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
733905615559 | J&J | 1 Day Define Vivid | 14.2 | 8.5 | -4.5
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
Spreadsheet: 849203d1699724814-ecell-formula-to-copy-the-last-invoice-last-invoice
Sheet: Fiscal Tax Invoice

 | Kindly asking for excel formula that can copy the last invoice on sales sheet and paste it on cell E14.
 | The idea is to produce an invoice from the last transaction on sales sheet as shown below.
 | Fiscal Tax Invoice
 |  | Invoice Number
 | Received From:
 | VAT Number | 4000578
 | BP Number | 100245
 | Description | Quantity | Price  Per Unit | Amount | VAT | Net Amount
 |  | Total Net Amount
 |  | Total VAT
 |  | Invoice Total
Spreadsheet: mark_haedicke__24590__2002 Plan Budget Pack - Legal Group 021001(HCODE)
Sheet: Adaytum  Detail 2002

 | ( Refresh view for your relevant CC or Region ) |  |  | Do not select subtotal if you have more than one CC
 | Adaytum
 | Value USD | Total Cost | Total | Budget 2002
 |  | Legal |  | Total Region
 | Headcount
 | SALARY AND WAGES
 | Salaries and Wages
 | Employee Pension & Benefits
 | Payroll Tax - FICA
 | Employee Expenses Other
 | Temp costs
 | Exgratia payments
 | Completion bonus
 | Stock options
 | Expat costs
 | Total Salaries & Wages
 | TRAVEL & ENTERTAINMENT
 | Flights
 | Hotel Costs
 | Other Business Travel
 | Entertainment and Meals | 59460
 | Client Entertainment
 | Total Travel and Entertainment
 | OFFICE EXPENSES
 | Building Maintenance
 | Building Security
 | Catering | 1068
 | Cleaning
 | Gym-Management Fees
 | Health & Safety
 | Mail Room | 10704
 | Moves and Changes
 | Leased Office Eqpt
 | Storage
 | Other Office Costs | 47448
 | Total Office Costs
 | CONSULTANCY
 | Directors Fees
 | Outside services - engineering
 | Outside services - IT
 | Recruitment Fees | 49992
 | Other Operational costs
 | Professional
 | Professional - Regulatory Affairs | 9060
 | Professional - Advertising
 | Professional - Marketing
 | Professional - Accounting
 | Professional - Translation | 5652
 | Professional - Other | 4356
 | Total Consultancy Costs
 | OCCUPANCY EXPENSES
 | Lease Rent Value
 | Sub Let Income Value
 | Rates/Local Tax
 | Utilities
 | Service Charge
 | Other
 | Total Occupancy
 | LEGAL & AUDIT
 | Statutory Reporting
 | Enron Assurance Services
 | Regulatory | 13135980
 | Company Secretariate
 | Compliance
 | Total Legal & Audit
 | OTHER G&A
 | Annual Subscriptions | 380016
 | Publications
 | Training | 51840
 | Insurance
 | Recruitment Advertising
 | Other Advertising
 | Other Business Expenditure
 | Total Other GA
 | COMMUNICATIONS COSTS
 | Communications Costs
 | TAXES OTHER THAN INCOME
 | Taxes Other Than Income
 | TOTAL G&A
Spreadsheet: 579055d1529665404-populate-list-from-the-master-list-no-vlookup-where-you-already-provide-the-1st-column-_generate-a-list-from-master-list_v1
Sheet: MasterList

Product | Region | Sales |  | <<< Master/Full list
1 | East | 202
2 | North | 202 |  |  |  |  |  |  |  |  |  |  |  | for dropdown:
3 | South | 238 |  |  |  |  |  |  |  |  |  |  |  | Region
4 | West | 250 |  |  |  |  |  |  |  |  |  |  |  | East
5 | East | 220 |  |  |  |  |  |  |  |  |  |  |  | North
6 | North | 203 |  |  |  |  |  |  |  |  |  |  |  | South
7 | South | 243 |  |  |  |  |  |  |  |  |  |  |  | West
8 | West | 206
9 | East | 216
10 | North | 248
11 | South | 250
12 | West | 238
13 | East | 226
14 | North | 238
15 | South | 243
16 | West | 225
17 | East | 225
18 | West | 235
19 | West | 223
20 | West | 242
21 | West | 215
22 | North | 235
23 | South | 244
24 | West | 245
25 | East | 217
26 | North | 216
27 | South | 225
28 | West | 236
29 | East | 219
30 | North | 223
31 | South | 227
32 | West | 207
33 | East | 238
34 | North | 233
35 | North | 243
Spreadsheet: 59660d1260244105-league-spreadsheet-709588-league-spreadsheet-v2
Sheet: Sheet1

This sheet can be deleted
it contains some dummy scores for quick score cut and paste during setup and testing
2 | Blue | [NAME] | 285 | 45
2 | Blue | bill | 300 | 54
2 | Blue | bob | 298 | 51
2 | green | gary | 275 | 25
2 | green | greg | 247 | 28
2 | green | grendel | 268 | 26
2 | red | [NAME] | 284 | 36
2 | red | ray | 300 | 52
2 | red | ron | 255 | 30
2 | yellow | elwood | 247 | 25
2 | yellow | [NAME] | 245 | 22
2 | yellow | erin | 278 | 25
3 | Blue | [NAME] | 289 | 44
3 | Blue | bill | 300 | 50
3 | Blue | bob | 296 | 50
3 | green | gary | 280 | 36
3 | green | greg | 254 | 52
3 | green | grendel | 278 | 40
3 | red | [NAME] | 271 | 39
3 | red | ray | 300 | 55
3 | red | ron | 260 | 35
3 | yellow | elwood | 265 | 30
3 | yellow | [NAME] | 214 | 10
3 | yellow | erin | 254 | 20
4 | Blue | [NAME] | 284 | 50
4 | Blue | bill | 300 | 49
4 | Blue | bob | 299 | 55
4 | green | gary | 245 | 41
4 | green | greg | 245 | 14
4 | green | grendel | 269 | 24
4 | red | [NAME] | 265 | 40
4 | red | ray | 300 | 60
4 | red | ron | 270 | 40
4 | yellow | elwood | 247 | 23
4 | yellow | [NAME] | 265 | 6
4 | yellow | erin | 245 | 21
Spreadsheet: 46941d1245858888-vlookup-exampel
Sheet: Sheet1

Name | Year |  |  | Income | Cost
Firm 1 | 2000 |  |  | 100 | 50
Firm 1 | 2001 |  |  | 150 | 50
Firm 1 | 2002 |  |  | 100 | 40
Firm 1 | 2003 |  |  | 160 | 30
Firm 2 | 2000 |  |  | 200 | 80
Firm 2 | 2001 |  |  | 100 | 90
Firm 2 | 2002 |  |  | 50 | 10
Firm 2 | 2003 |  |  | 40 | 20
By just varying the firm name in A17 I want income and cost changing
For firm 1 we will therefore get:
Firm:
Firm 1:
 | 2000 | 2001 | 2002 | 2003
Income | 100 | 150 | 100 | 160
Cost | 50 | 50 | 40 | 30
Spreadsheet: 861339d1709223867-irr-true-ups-for-minimum-return-thresholds-irr-true-ups
Sheet: Sheet1

 |  |  |  |  | The investor needs to make 12%, no matter the cash flows or timing. We need to tell the customer at any given point in time how much the payoff amount would be to make the IRR 12% based on a set of projections
 |  |  |  |  | How do I automatically find the payoff in each period to make the IRR equal to a target value instead of goal seeking every value highlighted in yellow?
 |  |  |  |  | Target IRR |  | 0.06
 |  |  |  |  | Example 1
Period | Date | Cash Flow | Spot IRR |  | Period | Date | Cash Flow | Payoff | Net Cash Flow | Target IRR
0 |  | -100 |  |  | 0 |  | -100 | 0
1 |  | 5 |  |  | 1 |  | 5 | 95.50080222052756
2 |  | 5 |  |  | 2 |  | 5 | -5.004449973776786
3 |  | 5 |  |  | 3 |  | 5 | -4.999740049354831
4 |  | 5 |  |  | 4 |  | 5 | -5
5 |  | 5 |  |  | 5 |  | 5 | -5
6 |  | 5 |  |  | 6 |  | 5 | -5
7 |  | 5 |  |  | 7 |  | 5 | -5
8 |  | 5 |  |  | 8 |  | 5 | -5
9 |  | 5 |  |  | 9 |  | 5 | -5
10 |  | 5 |  |  | 10 |  | 5 | -5
11 |  | 5 |  |  | 11 |  | 5 | -5
Spreadsheet: 221645d1363630721-what-formula-used-to-scale-the-same-code-a-value-on-different-days-scalare-valore
Sheet: Foglio2

Code | color | order | Hours | remaining hours | data
112233 | yellow | 120 | 15 |  | 11:03:13 |  | E2 <--155-15
100360 | red | 250 | 10 |  | 11:03:13 |  | E3<--100-10
23444 | green | 132 | 25 |  | 11:03:13 |  | E4<--200-25
112233 | yellow | 120 | 30 | 110 | 12:03:13 |  | E6<---140-30=110
100360 | red | 250 | 8 | 82 | 12:03:13 |  | E7<--90-8=82
23444 | green | 132 | 15 | 160 | 12:03:13 |  | E8<--175-15=160
100360 | red | 250 | 12 | 70 | 12:03:13 |  | E10<--82-12=70
Spreadsheet: 856588d1705781363-find-daily-employee-spend-amounts-employee-reimbursement-example
Sheet: solving

Row Labels | Sum of Approved Amount |  | [NAME] days |  | Solving real daily average
[NAME], [NAME] | 506.55
Jul | 60.8
2023-07-30 00:00:00 | 60.8
Aug | 20
2023-08-22 00:00:00 | 20
Oct | 40.25
2023-10-04 00:00:00 | 25.25
2023-10-20 00:00:00 | 15
Nov | 295.5
2023-11-19 00:00:00 | 235.5
2023-11-29 00:00:00 | 60
Dec | 90
2023-12-11 00:00:00 | 40
2023-12-28 00:00:00 | 50
[NAME], [NAME] | 54.75
Aug | 46.5
2023-08-28 00:00:00 | 46.5
Oct | 8.25
2023-10-08 00:00:00 | 8.25
[NAME], [NAME] | 501.25
Jul | 65.5
2023-07-08 00:00:00 | 45.5
2023-07-09 00:00:00 | 20
Sep | 135.75
2023-09-05 00:00:00 | 135.75
Nov | 300 |  | 1
Spreadsheet: 65046d1265814336-how-to-make-a-booking-planning-report-testbookings2010
Sheet: BookingList

Aprt | [NAME] | [NAME] | Nights
C1A | 2010-04-29 00:00:00 | 2010-05-11 00:00:00 | 12
C1A | 2010-05-15 00:00:00 | 2010-05-19 00:00:00 | 4
C1A | 2010-05-21 00:00:00 | 2010-05-29 00:00:00 | 8
C1C | 2010-05-13 00:00:00 | 2010-05-20 00:00:00 | 7
C1C | 2010-05-22 00:00:00 | 2010-05-26 00:00:00 | 4
C1D | 2010-05-01 00:00:00 | 2010-05-16 00:00:00 | 15
C1E | 2010-05-05 00:00:00 | 2010-05-16 00:00:00 | 11
C1G | 2010-05-01 00:00:00 | 2010-05-16 00:00:00 | 15
Spreadsheet: 50316d1249677299-adding-a-row-after-every-existing-row-that-includes-vlookup-testing
Sheet: Test 1

Number
1 |  | I would like to duplicate the rows to the left without removing the = data formula
2 |  | When I try to copy, paste then sort I get this:
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | #N/A
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
Spreadsheet: 114487d1310194859-using-advanced-filter-to-calculate-a-3-year-and-5-year-history-book1-1-
Sheet: Sheet1

 | [NAME] | YEAR | TOTAL |  |  |  |  |  |  | Hide These Columns
 | 3 | 2011 | 31358.88 |  |  |  |  |  |  | 1 | 2007 | 41204.22
 |  |  |  |  |  |  |  |  |  | 2 | 2008 | 203407.76
 |  |  |  |  |  |  |  |  |  | 3 | 2009 | 124496.04
 |  |  |  |  |  |  |  |  |  | 4 | 2010 | 145865.2
 | [NAME] | TOTAL |  |  |  |  |  |  |  | 0 | 2011 | 159704.79
 | 4 | 674678.01 | Location |  |  |  |  |  |  |  | 0
 |  | 674678.01 | Location & Latest Five Years
 |  | 369108.02 | Location &Lates Three Years
Spreadsheet: 776980d1650034137-2-criteria-lookup-formula-across-tabs-book1
Sheet: Sheet1

1001
HON | 0 | 59.98 | 0 | 59.98 | 14.5 | 45.48 | 75.8252750916972 | 0 | 2
OEM | 0 | 55.98 | 0 | 55.98 | 16.46 | 39.52 | 70.5966416577349 | 0 | 2
Other | 0 | 1203.69 | 14594.61 | 15798.3 | 494.17 | 15304.13 | 96.872005215751 | 0 | 266.2
Pkg | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 168
VLV | 0 | 11207.83 | 0 | 11207.83 | 3672.49 | 7535.34 | 67.2328184849342 | 0 | 697
1001 Totals: | 0 | 12527.48 | 14594.61 | 27122.09 | 4197.62 | 22924.47 | 84.5232428621836 | 0 | 1135.2
1002
Other | 0 | 609.48 | 25117.27 | 25726.75 | 315.04 | 25411.71 | 98.7754380168502 | 0 | 375
Pkg | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 319
VLV | 0 | 15962.53 | 38.97 | 16001.5 | 4694.73 | 11306.77 | 70.6606880604943 | 0 | 594
1002 Totals: | 0 | 16572.01 | 25156.24 | 41728.25 | 5009.77 | 36718.48 | 87.9942964298767 | 0 | 1288
1003
Other | 0 | 1325.31 | 28096 | 29421.31 | 528.14 | 28893.17 | 98.2049065796187 | 0 | 394
Pkg | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 327
VLV | 0 | 18175.94 | 0 | 18175.94 | 6053.38 | 12122.56 | 66.6956427012853 | 0 | 1007
1003 Totals: | 0 | 19501.25 | 28096 | 47597.25 | 6581.52 | 41015.73 | 86.1724784520114 | 0 | 1728