tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 713293d1610638605-sum-not-working-on-fields-calculated-using-left-formula-book1
Sheet: Sheet2

 |  |  |  |  | PULL
 |  |  |  |  | Support Type | Support Material | Bkwy | Support Type | Support | Total Steel Posts
 |  |  |  |  | S - 2-3 Bkwy | Steel |  | S - 2-3 Bkwy
 |  |  |  |  | Wood Type 4 BKWY | Wood | x | 4
 |  |  |  |  | Wood Type 2 BKWY | Wood | x | 2
 |  |  |  |  | Wood Type 3 Non-BKWY | Wood |  | 3
 |  |  |  |  | Wood Type 4 BKWY | Wood | x | 4
 |  |  |  |  | Wood Type 2 BKWY | Wood | x | 2
 |  |  |  |  | Wood Type 2 BKWY | Wood | x | 2
 |  |  |  |  | Steel Type 2-3 BKWY | Steel | x | 2-3
 |  |  |  |  | Wood Type 2 BKWY | Wood | x | 2
 |  |  |  |  | Wood Type 2 BKWY | Wood | x | 2
 |  |  |  |  | Wood Type 4 BKWY | Wood | x | 4
 |  |  |  |  | Wood Type 2 BKWY | Wood | x | 2
 |  |  |  |  | Wood Type 3 Non-BKWY | Wood |  | 3
 |  |  |  |  | Wood Type 4 BKWY | Wood | x | 4
 |  |  |  |  | Wood Type 2 BKWY | Wood | x | 2
 |  |  |  |  | Wood Type 2 BKWY | Wood | x | 2
 |  |  |  |  | Steel Type 2-3 BKWY | Steel | x | 2-3
 |  |  |  |  | Wood Type 2 BKWY | Wood | x | 2
 |  |  |  |  | Wood Type 2 BKWY | Wood | x | 2
 |  |  |  |  | Wood Type 4 BKWY | Wood | x | 4
 |  |  |  |  | Wood Type 4 BKWY | Wood | x | 4
 |  |  |  |  | Wood Type 4 BKWY | Wood | x | 4
 |  |  |  |  | Steel Type 2-3 BKWY | Steel | x | 2-3
 |  |  |  |  | Steel Type 2-2 BKWY | Steel | x | 2-2
 |  |  |  |  | Steel Type 2-3 BKWY | Steel | x | 2-3
 |  |  |  |  | Steel Type 2-2 BKWY | Steel | x | 2-2
 |  |  |  |  | Steel Type 2-3 BKWY | Steel | x | 2-3
 |  |  |  |  | Steel Type 2-3 BKWY | Steel | x | 2-3
Spreadsheet: 841465d1693640884-find-most-occuring-value-and-sort-the-top-3-book2-amoi-
Sheet: Sheet1

WO Description | Start Date | Finish date | Total Downtime | Work Type
BRAKE SYSTEM FIXED | 2022-04-15 10:00:00 | 2022-04-15 13:00:00 | 3 | BD
SAFETY INSPECTION | 2022-04-18 08:10:00 | 2022-04-18 09:10:00 | 0.9999999999417923 | INS
SAFETY INSPECTION | 2022-05-02 10:30:00 | 2022-05-02 11:30:00 | 0.9999999999417923 | INS
HEAD [NAME] REPLACED | 2022-05-04 15:05:00 | 2022-05-04 15:43:00 | 0.6333333334769122 | BD
REAR BRAKE FIXED | 2022-05-09 13:00:00 | 2022-05-09 16:00:00 | 3 | BD
SAFETY INSPECTION &REAR BRAKE REPAIRED | 2022-05-21 11:00:00 | 2022-05-21 14:00:00 | 3 | INS |  |  | Work Type | WO Description | Total Downtime
INSPECTION+BRAKE SYSTEM REPAIR | 2022-06-13 07:50:14 | 2022-06-13 11:50:14 | 3.999999999941792 | INS
SAFETY INSPECTION | 2022-09-05 09:00:00 | 2022-09-05 10:00:00 | 0.9999999999417923 | INS
SAFETY INSPECTION | 2022-09-19 10:00:00 | 2022-09-19 11:30:00 | 1.5 | INS
Spreadsheet: 87605d1287496089-cross-referencing-formula-to-leave-the-cell-blank-until-its-ready-to-be-populated-dummy
Sheet: Sheet1

Product Code Number/Catalogue Number | LabelFormat | AutobagFormat | Has a Request been Raised?                Y/N? | [NAME]?         Y/N? | Has it been Actioned?        Y/N? | Approved?        Y/N? | Vial Label complete? Y/N? | Multi Language Tag sheet [NAME]?    Y/N? | Outer Pack [NAME]?        Y/N? | Verification Complete?      Y/N? | [NAME] to Manufacturing?    Y/N? | Comments
466514346 | MS4529
845645 | MSQ528
64642168 | MS3524 |  |  |  |  |  |  | Y
514657675 | MSR526 | BB023 |  |  |  |  |  | Y
14599988 | MSD530 | BB023
12366558 | MSH530 | BB023
123456
 | Totals |  |  |  |  |  |  |  |  | Want a formula to show here
 |  | Yes "Y" | 0 | 0 | 0 | 0 | 0 | 2
 |  | To [NAME] (blank) | 7 | 7 | 7 | 7 | 7 | 5
 |  | % Complete | 0 | 0 | 0 | 0 | 0 | 0.2857142857142857
Spreadsheet: 05ee7089-0a60-454e-83e2-0c95b7f42c5c
Sheet: WithPerformance

Combined Bidder Activity Summary Report - June 2014  (Projects bid opened from July 2012 to June 2014, as of 07/03/2014)
Bid Month-YR | Engineer's Estimate | [NAME] | Low Bid vs. EE | Avg. Number of Bidders | Number of Projects Bid Opened | No. of  Projects Under 10% of EE | No. of Projects in ±10% of EE | No. of Projects Over 10% of EE | No. of Projects Within 110% of EE | Percent of  Projects Within ±10% of EE
2012-07-15 00:00:00 | 324344704.51 | 282585115.1 |  | 5.571428571428571 | 28 | 15 | 9 | 4
2012-08-11 00:00:00 | 376864727.33 | 330982460.77 |  | 5.8 | 25 | 14 | 7 | 4
2012-09-11 00:00:00 | 510608479.65 | 465296642.82 |  | 5.882352941 | 34 | 16 | 16 | 2
2012-10-11 00:00:00 | 783252992.56 | 703867617.4 |  | 5.581395349 | 44 | 25 | 9 | 9
2012-11-11 00:00:00 | 205996003.5 | 185618567.77 |  | 6.129032258 | 31 | 14 | 13 | 4
2012-12-11 00:00:00 | 94032650.61 | 87155581.72 |  | 7.5 | 20 | 7 | 9 | 4
2013-01-12 00:00:00 | 115138540.42 | 105448173.6 |  | 8.1875 | 32 | 15 | 12 | 5
2013-02-12 00:00:00 | 63553977.69 | 60906336.5 |  | 7.457142857 | 35 | 9 | 23 | 4
Mar-13 | 86258663.98 | 80216996.5 |  | 6.935348837 | 43 | 17 | 21 | 5
2013-04-12 00:00:00 | 125885500.15 | 122939214 |  | 5.407894737 | 76 | 26 | 37 | 13
2013-05-13 00:00:00 | 148547033.87 | 142415485.09 |  | 5.5 | 59 | 20 | 30 | 9
2013-06-13 00:00:00 | 33084358.35 | 32859582.6 |  | 5.13 | 16 | 6 | 8 | 2
Jul 12 to Jun 13
2013-07-13 00:00:00 | 101578652.05 | 102192668.35 |  | 4.857142857 | 14 | 7 | 3 | 4
Aug-13 | 67879300.28 | 61238911.23 |  | 6 | 20 | 9 | 8 | 3
Sept-13 | 204165819.49 | 173258066.06 |  | 6.8846 | 26 | 18 | 5 | 3
Oct-13 | 162182345.53 | 146432319.92 |  | 5.3103 | 29 | 10 | 16 | 3
Nov-13 | 165502932.37 | 144277480.63 |  | 7.467 | 15 | 8 | 6 | 1
2013-12-12 00:00:00 | 124415660.37 | 119060555.57 |  | 6.9231 | 13 | 4 | 6 | 3
Jan-14 | 140813434.82 | 137191609 |  | 7.571428571 | 28 | 13 | 9 | 6
2014-02-14 00:00:00 | 92385807 | 83500057 |  | 6.6 | 27 | 10 | 13 | 4
2014-03-14 00:00:00 | 210853414 | 184251324 |  | 6.4 | 56 | 29 | 23 | 4
* Apr-14 | 231265534 | 205255562 |  | 5.5 | 62 | 31 | 25 | 6
* May-14 | 140508630 | 134448039 |  | 4.8 | 57 | 31 | 18 | 8
2014-06-01 00:00:00 | 231614414 | 221633094 |  | 5 | 20 | 5 | 12 | 3
Jul 13 - Jun 14
Total
Note: 1) "*", numbers may be different from that in the previous report due to bid rank change(s); 2) Rejected projects are not included in calculations.
Spreadsheet: 07466b93-9fee-4cc1-a2c0-5189b737a5f5
Sheet: Labor

Schedule E - Labor Rates
Item # | Item | Year | Engineering | Technician
 | Hourly Labor Rate | 1 | 68.2 | 68.2
 |  | 2 | 68.88 | 68.88
 |  | 3 | 69.58 | 69.58
 |  | 4 | 70.27 | 70.27
 |  | 5 | 70.97 | 70.97
 | Overtime Labor Rate | 1 |  | 98.21
 |  | 2 |  | 99.19
 |  | 3 |  | 100.19
 |  | 4 |  | 101.19
 |  | 5 |  | 102.2
Spreadsheet: 851721d1701879000-need-help-converting-a-google-sheets-formula-to-excel-scheduling-test1
Sheet: HS

HS | 37.63 | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | Light Smoothing | 2024-01-15 00:00:00 |  |  | For production quote- [NAME]
Spreadsheet: 37786d1235795090-convoluted-excel-sum-formula-issues-report_commission-workfilev2
Sheet: SUMMARY

CODE | MONTH | CATEGORY | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00
1010 | 2008-10-01 00:00:00 | Ordered Items, Invoiced in |  | [NAME] here |  | For Cell E2:  If [NAME] was ordered in October, but was invoiced in November, SUM commission $, repeat for applicable columns
1010 | 2008-11-01 00:00:00 | Ordered Items, Invoiced in |  |  |  | Column A on Data sheet is date of order, Column E on Data Sheet is date of invoice
1010 | 2008-12-01 00:00:00 | Ordered Items, Invoiced in
1010 |  | Invoiced Commissions | 805.01075 | 680.3290000000001 | 824.52425 | Total invoiced commission $$ for period shown
9999 |  | Parts, No Commission | 532.2155 | 697.7334999999998 | 733.2290000000002 | Total invoiced commissions on parts that are disregarded.  Parts are non-commissionable.
1010 |  | Items Cancelled After Invoice | #N/A | #N/A | [NAME] Here | Total Commission $ (i.e. column H on data sheet) for items cancelled after invoicing for period shown in column heading
 |  |  |  |  |  | Column A on Data sheet is date of order, Column D is date of cancellation and Column E on Data Sheet is date of invoice
 |  | TOTAL COMMISSION | #N/A | #N/A | #N/A
Spreadsheet: 8e4c2a1f-4e90-4a2b-8d49-b0aa02247b81
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7994 | 55784 | Gabriella | Guidotti | ITA | 107 | 00:30:44 | 00:00:00 | 00:40:46 | 00:00:00 | 00:42:33 | 1 | 01:54:04
Spreadsheet: 624744d1558048733-help-calendar-correction-employee-absence-schedule-current
Sheet: November

 | Absence Type Key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 | November | Dates of Absence
 | Employee Name | 1 | 2 | 3 | 4 | 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 | Total Days
Spreadsheet: 026802bb-b4e6-46d5-87ae-a70c99882a9f
Sheet: Sheet1

Értékpapír | CF Dáum | [NAME] | [NAME] esemény | [NAME] mennyisége | Kamat esemény | Kamat | Kamat mennyisége | Kamat fizetés | Kamat nem fizetés
D121017 | 2011-10-19 00:00:00 | 10000 | Igen | -10000 | Nem | 0 | 0 | 0 | 0
D121017 | 2012-10-17 00:00:00 | 0 | Igen | 10000 | Nem | 0 | 0 | 0 | 0
Spreadsheet: 130041d1322042701-using-a-range-in-formula-distance
Sheet: Locations to be Checked

Latitude (WGS84) | Longitude (WGS84) | Location Name | Checking Distances | Radius (km) |  | Result Checking Distances | Comment
53.1444444444444 | -3.65555555555555 | [NAME] |  | 100 |  | AAA, BBB | Sites AAA and BBB are within 100km
53.2222222222222 | -3.76666666666666 | YYY |  |  |  | - | No sites within 100km
53.1188888888888 | -3.63333333333333 | ZZZ |  |  |  | AAA, CCC | Sites AAA and CCC are within 100km
Goal: To check if each site (XXX) is within radius of reference locations (AAA to FFF)
The distance is calculated using 'Great Circle Distance' method.  I have the formula correct for one case, I just need to tweak it for checking against multiple sites
Spreadsheet: 05e3b454-c9da-459a-909d-3d524ba60485
Sheet: Sheet1

 |  | [NAME]
 |  | Stage One Adaptive Management Program for Existing Development
 |  | Annual Report Aug. 13, 2011—Aug. 13, 2012
SECTION VI SUPPLEMENTAL FORM FOR ANNUAL REPORT:   ADDITIONAL OPPORTUNITIES FOR RETROFITS TO REDUCE NUTRIENT LOADING
Local governments that are required to provide more than one retrofit opportunity  must use this form to provide detailed information for each additional retrofit. Use a separate copy of this form for each additional retrofit.
Local Government:
Contact Name: |  |  |  | Phone number:
Data Collection and Notification Each retrofit opportunity must include data describing the location, type of retrofit proposed, property owner, as well as basic information about the watershed and receiving waters. The table below provides a format for submitting this information.
Retrofit Opportunity Table
Location description, including directions from a major highway
Type and description of retrofit opportunity.
Current property owner
Is the property owner willing to cooperate?
Land area available for retrofit (sq. ft)
Accessibility to retrofit site
Drainage area size (acres)
Land use in drainage area (percent of each type of land use)
Average slope in drainage area (%)
Environmentally sensitive areas in drainage area such as wetlands, riparian buffers, endangered or threatened species.
Approximate annual nitrogen and phosphorus loading from drainage area (lbs/acre/year) *
Potential nitrogen reduction (lbs/ac/yr)*
Potential phosphorus reduction (lbs/ac/yr)*
Estimated cost of retrofit
Receiving water
DWQ classification of receiving water
Use support rating for receiving water
Other retrofit information you may wish to provide
Spreadsheet: 852203d1702306614-need-help-converting-a-google-sheets-formula-to-excel-ks-schedule-12112023
Sheet: Tauro 1

T1
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due_Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 4 Pass | 2024-01-15 00:00:00 |  | T1 | For production quote- [NAME]
 | 231235 | 1 | Fred | 1 | 45 | 58 | PAP-SO-0017 | 1 | 4 Pass | 2024-01-15 00:00:00 |  | T1
 | 232445 | 2 | [NAME] | 4 | 30 | 30 | PAP-SO-1332 | 1 | 4 Pass | 2024-01-15 00:00:00 |  | T1
 | 243556 | 3 | Gregory | 25 | 33 | 20 | ART-4443 | 1 | 4 Pass | 2024-01-15 00:00:00 |  | T1
 | 243557 | 2 | Gregory | 300 | 24 | 36 | ART-3232 | 1 | 4 Pass | 2024-01-15 00:00:00 |  | T1
 |  |  | [NAME] | 15 | 22 | 22 | PAP-SO-2263 - WHITE STATIC CLING 29.5X20.5 | 1 | FU or [NAME]
 |  |  | [NAME] | 128 | 25 | 27 | PAP-SO-0061 - SINTRA 3MM WHITE 48X96 | 1 | 4 Pass
 |  |  | [NAME] | 552 | 9 | 11 | PAP-SO-2191 - CARDSTOCK 18PT CIS 48X96 | 2 | 4 Pass
0.2 | 234433 | 1 | HH | 2 | 22 | 22 | ART-3307 - 63X328 DURAVIEW 5MIL BACKLIT (UV) | 1 | 8 Pass | 2023-01-15 00:00:00 |  | T1
Spreadsheet: 136af7f8-dd46-48c7-b928-5b05e4ff4b9c
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2
Quelle: http://ergebnisse.vimentis.ch/
Frage:
[NAME] müssen gleich behandelt werden wie private [NAME] (sie erhalten keine [NAME] öffentlichen Hand und können [NAME] gehen).
 | [NAME]:
Antwort | männlich | weiblich
[NAME] | 0.28 | 0.23
[NAME] | 0.64 | 0.64
Neutral / Weiss nicht | 0.08 | 0.13
Angaben zu den [NAME]
Erhebungsjahr | 2010
Stichprobengrösse | 29292
Erhebungszeitraum | 02.10.2010 bis: 06.12.2010
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 68913d1269446637-adjust-logarithmic-scale-adjust-chart-test
Sheet: Borrowing Statistics

year | Number of books borrowed from the library
1995 | 2000
 | 1000
 | 500
Spreadsheet: 1e9f1175-8658-4fae-8f64-38c0707bed52
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2
 | Category One | [NAME]
 | Technology Strategy Consultant | 95.71
 | Project Manager | 82.04
 | IT Project Logistics Support | 38
 | Business Analyst | 72
 | Business Architect | 60
 | Category Two | [NAME]
 | Project Manager | 82.04
 | Programmer/System Analyst | 48.31
 | Programmer | 41.02
 | Quality Assurance Inspector/Analyst | 59.25
 | Quality Control Planner | 40
 | Quality Control Testers | 45.58
 | Technical Writer | 41.02
 | IT End-User Trainer | 40
 | Category Four | [NAME]
 | Project Manager | 82.04
 | Web Programmer/System Analyst | 75.2
 | Web Programmer | 65
 | Web Integrator | 62
 | Applications Architect | 95.71
 | Graphics Designers | 33
 | Object-oriented Developer | 54.69
 | Component [NAME] | 30
 | Quality Assurance Inspector/Analyst | 59.25
 | Quality Control Planner | 40
 | Quality Control Testers | 45.58
 | Technical Writer | 41.02
 | IT End-User Trainer | 40
 | Category Five | [NAME]
 | [NAME] | 80
 | Data Analyst/Administrator | 60
 | Data Architect | 95.71
 | Data Warehousing & Busn Intel Developer | 55
 | Category Seven | [NAME]
 | 3rd Party Software Specialists | 90
 | Infrastructure System Specialist | 80
 | Infrastructure Architect | 80
 | Technology Research Analyst | 55
 | Capacity Planning & Performance Specialist | 77.48
 | IT Disaster Recovery Specialist | 75
 | Category Eight | [NAME]
 | Policy & Proc.Devlpm/Maint Cons. | 65
 | IT Project Logistics Support | 38
 | Technical Writers | 41.02
Spreadsheet: 1403910a-b0d6-4f4a-85fe-507ddc1096f4
Sheet: Sheet1

Table 7--U.S. feed grain imports by selected sources (1,000 metric tons) 1/, 3/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Import and country/region |  | ---------- 2010/11 ---------- |  | ---------- 2011/12 ---------- |  | 2012/13
 |  | Mkt year | Jun-Jan | Mkt year | Jun-Jan | Jun-Jan
Oats | Canada | 1393.292808 | 979.8302419999999 | 1556.499397 | 1184.716578 | 1167.301306
 | Finland | 73.932572 | 62.92601 | 34.84057 | 34.84057
 | Jamaica | 0.159212 | 0.007899999999999999 | 0.285218 | 0.285218
 | All other countries | 0.264317 | 0.085312 | 29.802409 | 0.27317 | 1.474674
 | Total 2/ | 1467.648909 | 1042.849464 | 1621.427594 | 1220.115536 | 1168.77598
Malting barley | Canada | 174.724159 | 152.839266 | 263.660306 | 114.959883 | 248.761071
 | All other countries | 0.006579999999999999 | 0.006579999999999999 | 0.244638 | 0.244638 | 0.016775
 | Total 2/ | 174.730739 | 152.845846 | 263.9049439999999 | 115.204521 | 248.777846
Other barley 3/ | Canada | 30.69757099999999 | 11.941481 | 89.27383699999999 | 58.953857 | 99.556042
 | All other countries | 1.288141 | 0.93668 | 0.7575109999999999 | 0.6405689999999999 | 1.6826
 | Total 2/ | 31.985712 | 12.878161 | 90.031348 | 59.59442599999999 | 101.238642
1/ Grain only. Market year (June-May) and market year to date. 2/ Totals may not add due to rounding.
3/ Grain for purposes other than malting, such as feed and seed use. Source: U.S. Department of Commerce, Bureau of the Census, Foreign Trade Statistics.
Date run: 3/10/2013
Spreadsheet: 865445d1712522556-find-a-centile-for-the-nearest-array-value-for-a-specific-age-liver-proforma-in-progress-tays01s-
Sheet: HGS

N | [NAME] across the Life Course: Normative Data from Twelve British Studies
 | [NAME], 1 , * [NAME], 1 [NAME], 2 [NAME], 3 Ian J. Deary, 4 [NAME], 1 [NAME], 5 [NAME], 1 , 4 [NAME], 1 [NAME], 6 [NAME], 6 Debbie A. Lawlor, 7 [NAME], 1 [NAME], 4 [NAME], 8 [NAME], 7 [NAME], 2 [NAME], 1 and [NAME]
 |  | centiles |  |  |  |  |  |  |  |  | centiles
 | Males | 10th | 25th | 50th | 75th | 90th | mean | (sd) |  | Females | 10th | 25th | 50th | 75th | 90th | mean | (sd)
1 | 90 | 16 | 20 | 25 | 29 | 33 | 25 | -6.8 |  | 90 | 9 | 11 | 14 | 17 | 20 | 14.2 | -4.4
2 | 85 | 19 | 24 | 29 | 33 | 38 | 28.5 | -7 |  | 85 | 11 | 14 | 17 | 20 | 23 | 16.6 | -4.7
3 | 80 | 23 | 27 | 32 | 37 | 42 | 32.2 | -7.3 |  | 80 | 13 | 16 | 19 | 23 | 26 | 19.1 | -5.1
4 | 75 | 26 | 31 | 35 | 41 | 45 | 35.6 | -7.6 |  | 75 | 14 | 18 | 21 | 25 | 28 | 21.4 | -5.4
5 | 70 | 29 | 34 | 39 | 44 | 49 | 39.1 | -8.1 |  | 70 | 16 | 20 | 24 | 27 | 31 | 23.5 | -5.7
6 | 65 | 31 | 37 | 43 | 48 | 53 | 42.3 | -8.6 |  | 65 | 17 | 21 | 25 | 29 | 33 | 25.3 | -6
7 | 60 | 33 | 39 | 45 | 51 | 56 | 44.6 | -9.2 |  | 60 | 18 | 22 | 27 | 31 | 34 | 26.5 | -6.2
8 | 55 | 34 | 40 | 47 | 53 | 59 | 46.2 | -9.8 |  | 55 | 19 | 23 | 28 | 32 | 35 | 27.5 | -6.4
9 | 50 | 35 | 41 | 48 | 54 | 60 | 48 | -10.1 |  | 50 | 21 | 25 | 29 | 33 | 37 | 28.7 | -6.4
10 | 45 | 36 | 42 | 49 | 56 | 61 | 48.8 | -10.3 |  | 45 | 22 | 26 | 30 | 34 | 38 | 29.9 | -6.4
11 | 40 | 38 | 44 | 50 | 57 | 63 | 50.3 | -10.3 |  | 40 | 23 | 27 | 31 | 35 | 39 | 30.7 | -6.3
12 | 35 | 39 | 45 | 51 | 58 | 64 | 51.6 | -10.1 |  | 35 | 23 | 27 | 31 | 35 | 39 | 31.3 | -6.2
13 | 30 | 38 | 44 | 51 | 58 | 64 | 51.6 | -9.6 |  | 30 | 24 | 27 | 31 | 35 | 39 | 31.4 | -6
14 | 25 | 36 | 41 | 48 | 55 | 61 | 48.8 | -8.7 |  | 25 | 23 | 26 | 30 | 35 | 38 | 30.6 | -5.6
15 | 20 | 30 | 35 | 40 | 46 | 52 | 41.5 | -7.3 |  | 20 | 21 | 24 | 28 | 32 | 36 | 28.4 | -5.1
16 | 15 | 21 | 25 | 29 | 33 | 38 | 29.6 | -5.6 |  | 15 | 17 | 20 | 24 | 27 | 30 | 23.9 | -4.5
17 | 10 | 12 | 15 | 17 | 20 | 22 | 17.2 | -4.1 |  | 10 | 12 | 14 | 16 | 19 | 21 | 16.7 | -3.8
18 | 5 | 6 | 7 | 8 | 9 | 10 | 7.7 | -2.9 |  | 5 | 6 | 7 | 8 | 9 | 10 | 8 | -3.1
 |  |  |  |  |  |  |  | Age | 42
 |  |  |  |  |  |  |  | GS | 52
 | females |  |  |  |  |  |  | Age row
 |  |  | mean | 5th | 10th |  |  | GS column
 | 20 years and over |  | 32 | 24.5 | 25.9 |  |  | Centile:
 | 20-29 |  | 30.9 | 23.7
 | 30-39 |  | 31.8 | 24.3
 | 40-49 |  | 32.6 | 25.2
 | 50-59 |  | 32.9 | 25.9
 | 60-69 |  | 33.2 | 25.9
 | 70-79 |  | 31.5 | 23.7
 | 80 years and over |  | 29.3 | 22.9
1 | 95 | 5 |  |  |  |  |  |  |  | 95
Spreadsheet: 72314d1273004457-monte-carlo-simulation-montecarlosimulation2010
Sheet: MonteCarlo

Initial account balance | 20000
Margin per contract | 4000
Commissions per round turn | 4.5
Maximum number of contracts | 200
Win % | 0.5
Loss % | 0.4
Breakeven %
Average win per contract | 100
Average loss per contract | 50
Expectancy per contract
Number of trades per day | 3
Account balance per 21.12.2010
Account balance after taxes (28%)
Date | Model account | Trading Account | Trade 1 | Trade 2 | Trade 3 | Number of Contracts Trading Account | Number of Contracts Model account
2010-09-01 00:00:00
2010-09-02 00:00:00
2010-09-03 00:00:00
2010-09-06 00:00:00
2010-09-07 00:00:00
2010-09-08 00:00:00
2010-09-09 00:00:00
2010-09-10 00:00:00
2010-09-13 00:00:00
2010-09-14 00:00:00
2010-09-15 00:00:00
2010-09-16 00:00:00
2010-09-17 00:00:00
2010-09-20 00:00:00
2010-09-21 00:00:00
2010-09-22 00:00:00
2010-09-23 00:00:00
2010-09-24 00:00:00
2010-09-27 00:00:00
2010-09-28 00:00:00
2010-09-29 00:00:00
2010-09-30 00:00:00
2010-10-01 00:00:00
2010-10-04 00:00:00
2010-10-05 00:00:00
2010-10-06 00:00:00
2010-10-07 00:00:00
2010-10-08 00:00:00
2010-10-11 00:00:00
2010-10-12 00:00:00
2010-10-13 00:00:00
2010-10-14 00:00:00
2010-10-15 00:00:00
2010-10-18 00:00:00
2010-10-19 00:00:00
2010-10-20 00:00:00
2010-10-21 00:00:00
2010-10-22 00:00:00
2010-10-25 00:00:00
2010-10-26 00:00:00
2010-10-27 00:00:00
2010-10-28 00:00:00
2010-10-29 00:00:00
2010-11-01 00:00:00
2010-11-02 00:00:00
2010-11-03 00:00:00
2010-11-04 00:00:00
2010-11-05 00:00:00
2010-11-08 00:00:00
2010-11-09 00:00:00
2010-11-10 00:00:00
2010-11-11 00:00:00
2010-11-12 00:00:00
2010-11-15 00:00:00
2010-11-16 00:00:00
2010-11-17 00:00:00
2010-11-18 00:00:00
2010-11-19 00:00:00
2010-11-22 00:00:00
2010-11-23 00:00:00
2010-11-24 00:00:00
2010-11-25 00:00:00
2010-11-26 00:00:00
2010-11-29 00:00:00
2010-11-30 00:00:00
2010-12-01 00:00:00
2010-12-02 00:00:00
2010-12-03 00:00:00
2010-12-06 00:00:00
2010-12-07 00:00:00
2010-12-08 00:00:00
2010-12-09 00:00:00
2010-12-10 00:00:00
2010-12-13 00:00:00
2010-12-14 00:00:00
2010-12-15 00:00:00
2010-12-16 00:00:00
2010-12-17 00:00:00
2010-12-20 00:00:00
2010-12-21 00:00:00
Spreadsheet: 726575d1617299681-sumifs-issue-template
Sheet: DEC

 | Company 1
 | Date | Payment Type | Name | Description | Ref |  | AMOUNT | TOTAL |  | Comment
EX | 2021-12-01 00:00:00 | Cash | Wawa | Auto Gas | Receipt |  | 0
Spreadsheet: 533618d1502892778-calculating-mileage-rates-based-on-different-rates-depending-on-cumulative-miles-travelled-mileage-rates
Sheet: Sheet1

Staff expenses analysis |  |  |  |  |  |  |  |  |  | Mileage Bands | Rate
Employee Name |  |  |  |  |  |  |  |  |  | 0-1,500 | 0.4479
Month | No of Kms | [NAME] | Cost Per Km | Total | Subsistence | Taxi/park | Other | Total |  | 1,501-5,500 | 0.7
 |  |  | Working Out Cummalative Figures at different rates |  |  |  |  |  |  | 5,501-25,000 | 0.3221
 |  |  |  |  |  |  |  |  |  | 25001 | 0.2585
2016-01-01 00:00:00 | 1
2016-02-01 00:00:00 | 1501
2016-03-01 00:00:00 | 3999
2016-04-01 00:00:00
2016-05-01 00:00:00
2016-06-01 00:00:00
2016-07-01 00:00:00
2016-08-01 00:00:00
2016-09-01 00:00:00
2016-10-01 00:00:00
2016-11-01 00:00:00
2016-12-01 00:00:00