tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 267213d1380014452-company-cost-calculation-sumif-and-isblank-book1-ans
Sheet: Sheet1

 |  |  |  |  |  | Helper columns
 |  |  |  | Cost1 | Cost2 | Cost3 | Cost4 |  |  | Listed companies
 |  | Cat1 | Com A | 50 | 100 |  |  |  |  | Com X |  |  | Com A
 |  |  | Com A | 100 | 300 |  |  |  |  | Com Y |  |  | Com B
 |  |  | Com B | 200 | 400 |  |  |  |  | Com Z |  |  | Com C
 |  |  | Com A | 300 | 500 |  |  |  |  |  |  |  | Com D
 |  |  | Com Z | 400 | 600 |  |  |  |  |  |  |  | Com X
 |  |  |  |  |  |  |  |  |  |  |  |  | Com Y
 |  | Cat2 | Com C | 600 | 800 |  |  |  |  |  |  |  | Com Z
 |  |  | Com C | 700 | 900
 |  |  | Com Y | 800 | 1000
 |  |  | Com X | 900 | 1100
 |  | Cat3 | Com A | 1100 | 1300
 |  |  | Com X | 1200 | 1400
 |  |  | Com C | 1300 | 1500
 |  |  | Com Z | 1400 | 1600
 |  |  | Com B | 1500 | 1700
Spreadsheet: 724453d1616165728-multiple-if-with-and-formula-but-one-of-the-options-is-not-returning-correct-outcome-book2
Sheet: Sheet1

Long/Short? | Trend Directon | Points
Long | Uptrend
Long | Sidetrend
Long | Downtrend
Short | Uptrend
Short | Sidetrend
Short | Downtrend
Spreadsheet: 814819d1674619431-how-to-custom-sort-by-sortby-function-customsortby
Sheet: Sheet1

Source Data (Array) | 6/PT | 6/CT | 6/ET | 6/MT | 2/ET | 2/ENT | 2/MT | 2/EMT
Sort by (Custom sort) | CT | ET | MT | PT | EnT | CST | EmT
I tried but failed |  | 6/CT | 6/ET | 6/MT | 2/ET | 2/ENT | 2/MT | 2/EMT
My requirement | 6/CT | 6/ET | 6/MT | 6/PT | 2/ET | 2/MT | 2/ENT | 2/EMT
Spreadsheet: 64334d1265200904-add-a-new-column-of-data-to-the-results-displayed-when-selecting-from-a-dropdown-box-working-on-v2
Sheet: Sheet2

Category
Sales Process
Service Excellence
Building Relationships
Personal Career Development
Account Control
Account Enquiry |  |  |  | Choose category:
Account Opening |  |  |  | Sales Process
Branch Administration |  |  |  |  | Course Title | Course Overview | Course objectives
Control |  |  |  |  | LJ Course Title 1 | Applying your product knowledge to customer interactions and generating leads?  Test line 2 Test line 3
Cash Admin |  |  |  |  | LJ Course Title 2 | Explaining the crucial things to them when they are considering Savings(SIM) Mortgages and pensions
Cash Control |  |  |  |  | LJ Course Title 46 | Demographics of branch
Complaints |  |  |  |  | LJ Course Title 47 | Customer Preview
Coaching |  |  |  |  | LJ Course Title 48 | Business/Private/Financial Planning lead Referrals
Improvements |  |  |  |  | LJ Course Title 49 | Telephony (Outbound and Inbound Calling)
Assurance |  |  |  |  | LJ Course Title 50 | Use of Prompts
Insurance |  |  |  |  | LJ Course Title 51 | Undertaking Personal/Customer Reviews (PSR/CSR)
IT |  |  |  |  | LJ Course Title 52 | Prospecting
Loan Account Opening |  |  |  |  | LJ Course Title 65 | Locating and understanding Information on our products and services
Managerial
Transactions
Spreadsheet: 778569d1651156465-excel-solver-to-change-net-margin-in-column-c-without-changing-values-in-column-b-excel-solver
Sheet: Sheet1

Revenue
Sales | 10000
Incentives | -200 |  |  | MIN | MAX |  | Using [NAME]
Revenue Contingecy |  |  |  | -478 | -466
Tax Offset | -1200
Total Revenue
Expense
Sales Expense | 959
Marketing Expense | 1500
G&A Expense | 2152
Cost Contingency
Total Expense
 |  |  |  | Objective Net Margin
Net Margin |  |  |  | 0.4
Spreadsheet: 347582d1411632938-salary-bracket-returns-employees-corresponding-contribution-for-philhealth-sss-contribution-calculator
Sheet: Social Security Table

 |  |  |  |  |  | SSS Contribution Schedule
 |  |  |  |  |  | Range of Compensation |  |  | Monthly [NAME] | Employer - Employee |  |  |  |  |  |  | SE / VM / OFW
 |  |  |  |  |  |  |  |  |  | SOCIAL SECURITY |  |  | EC | Total Contribution |  |  | Total Contribution
 | Enter [NAME] Here | 250 |  |  |  |  |  |  |  | ER | EE | TOTAL | ER | ER | EE | Total
 | Membership Status | Employed |  |  |  | 1000 | - | 1249.99 | 1000 | 70.7 | 33.3 |  | 10
 |  |  |  |  |  | 1250 | - | 1749.99 |  | 106 | 50 |  | 10
 | Employer Contribution |  |  |  |  | 1750 | - | 2249.99 |  | 141.3 | 66.7 |  | 10
 | Employee/Members Contribution |  |  |  |  | 2250 | - | 2749.99 |  | 176.7 | 83.3 |  | 10
 | Total Monthly Contribution |  |  |  |  | 2750 | - | 3249.99 |  | 212 | 100 |  | 10
 |  |  |  |  |  | 3250 | - | 3749.99 |  | 247.3 | 116.7 |  | 10
 |  |  |  |  |  | 3750 | - | 4249.99 |  | 282.7 | 133.3 |  | 10
 |  |  |  |  |  | 4250 | - | 4749.99 |  | 318 | 150 |  | 10
 |  |  |  |  |  | 4750 | - | 5249.99 |  | 353.3 | 166.7 |  | 10
 |  |  |  |  |  | 5250 | - | 5749.99 |  | 388.7 | 183.3 |  | 10
 |  |  |  |  |  | 5750 | - | 6249.99 |  | 424 | 200 |  | 10
 |  |  |  |  |  | 6250 | - | 6749.99 |  | 459.3 | 216.7 |  | 10
 |  |  |  |  |  | 6750 | - | 7249.99 |  | 494.7 | 233.3 |  | 10
 |  |  |  |  |  | 7250 | - | 7749.99 |  | 530 | 250 |  | 10
 |  |  |  |  |  | 7750 | - | 8249.99 |  | 565.3 | 266.7 |  | 10
 |  |  |  |  |  | 8250 | - | 8749.99 |  | 600.7 | 283.3 |  | 10
 |  |  |  |  |  | 8750 | - | 9249.99 |  | 636 | 300 |  | 10
 |  |  |  |  |  | 9250 | - | 9749.99 |  | 671.3 | 316.7 |  | 10
 |  |  |  |  |  | 9750 | - | 10249.99 |  | 706.7 | 333.3 |  | 10
 |  |  |  |  |  | 10250 | - | 10749.99 |  | 742 | 350 |  | 10
 |  |  |  |  |  | 10750 | - | 11249.99 |  | 777.3 | 366.7 |  | 10
 |  |  |  |  |  | 11250 | - | 11749.99 |  | 812.7 | 383.3 |  | 10
 |  |  |  |  |  | 11750 | - | 12249.99 |  | 848 | 400 |  | 10
 |  |  |  |  |  | 12250 | - | 12749.99 |  | 883.3 | 416.7 |  | 10
 |  |  |  |  |  | 12750 | - | 13249.99 |  | 918.7 | 433.3 |  | 10
 |  |  |  |  |  | 13250 | - | 13749.99 |  | 954 | 450 |  | 10
 |  |  |  |  |  | 13750 | - | 14249.99 |  | 989.3 | 466.7 |  | 10
 |  |  |  |  |  | 14250 | - | 14749.99 |  | 1024.7 | 483.3 |  | 10
 |  |  |  |  |  | 14750 | - | 30000 |  | 1060 | 500 |  | 30
 |  |  |  |  |  | SSS Contribution Calculator is brought to you by SSSContributionTable.Com
 |  |  |  |  |  |  |  | [NAME] |  |  |  | List
 |  |  |  |  |  |  |  | Secret formula ER |  |  |  | Employed
 |  |  |  |  |  |  |  | Secret Formulat EE |  |  |  | Self Employed
 |  |  |  |  |  |  |  |  |  |  |  | Voluntary Member
 |  |  |  |  |  |  |  |  |  |  |  | OFW
 |  |  |  |  |  |  |  | Total Monthly Contribution
 |  |  |  |  |  |  |  | Secret formula [NAME]
Spreadsheet: 138663d1327799702-memory-issues-cumulative-count-abbreviated-example
Sheet: Sheet1

a |  | 1
a |  | 1
b |  | 2
b |  | 2
 |  | 2
 |  | 2
c |  | 3
a |  | 3
a |  | 3
 |  | 3
b |  | 3
a |  | 3
g |  | 4
 |  | 4
 |  | 4
 |  | 4
h |  | 5
 |  | 5
i |  | 6
j |  | 7
k |  | 8
f |  | 9
f |  | 9
 |  | 9
a |  | 9
a |  | 9
a |  | 9
b |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
c |  | 9
d |  | 10
Spreadsheet: 866052d1712992674-adding-year-to-date-data-based-on-selected-month-test-file-15-aligw
Sheet: Sheet1

Performance dashboard - Actual vs. Budget |  |  |  |  |  |  |  |  |  |  |  |  | March
 | January |  |  | February |  |  | 2024-03-01 00:00:00 |  |  | 2024-04-01 00:00:00 |  |  | 2024-05-01 00:00:00 |  |  | 2024-06-01 00:00:00
 | Actual | Budget | % | Actual | Budget | % | Actual | Budget | % | Actual | Budget | % | Actual | Budget |  | Actual | Budget | % | Actual | Budget | %
Sales
A | 3 | 5 |  | 8 | 6 |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  | 19 | -0.1916666666666668
B | 4 | 6 |  | 6 | 8 |  | 6 |  |  |  |  |  |  |  |  |  |  |  | 16 | 18 | -0.08333333333333337
C | 7 | 3 |  | 7 | 5 |  | 13 |  |  |  |  |  |  |  |  |  |  |  | 27 | 24 | 1.545833333333333
D | 4 | 4 |  | 6 | 6 |  | 12 |  |  |  |  |  |  |  |  |  |  |  | 22 | 18 | 0.5
E | 2 | 7 |  | 3 | 4 |  | 17 |  |  |  |  |  |  |  |  |  |  |  | 22 | 27 | -0.9017857142857143
Total
Spreadsheet: 57468d1257635743-excel-2007-excel-2007-chart-horizontal-axis-dates-vanessa-tucker-work-sample2
Sheet: 1st table

Product | (All)
Country | (All)
 | Values
Row Labels | Sum of Var | Sum of Revenue | Sum of Budget
January | -4297 | 87534 | 91831
February | 2843 | 90377 | 87534
March | -1389 | 88988 | 90377
April | -2774 | 84982 | 87756
May | -423 | 84559 | 84982
June | -548 | 84011 | 84559
July | 2366 | 86377 | 84011
August | -2843 | 83534 | 86377
September | 1389 | 84923 | 83534
October | -4318 | 80605 | 84923
November | 3406 | 84011 | 80605
December | 2366 | 86377 | 84011
Grand Total | -4222 | 1026278 | 1030500
Spreadsheet: 3e3b25b5-701b-45dc-97b7-0bf54fe07578
Sheet: Sheet1

Architecture and Construction | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Pathway: Construction
Code | Topic | Course | Knowledge and Skill | Performance Element | Measurement Criteria
ACPB01.01 | Communications | #2: The Language of Architecture and Construction | Recognize universal signs and symbols such as colors, flags, stakes and hand signals to function safely in the workplace. | Identify universal signs and symbols to apply to given workplace situations. | Explain functions of signs and symbols.
 |  |  |  |  | Work safely using signs and symbols.
 |  |  |  |  | Inspect all signs and symbols for safe and proper use.
 |  |  |  |  | Use proper signs and signals for the work area.
 |  |  |  |  | [NAME] appropriately to signs and signals.
ACPB02.01 | Technical Skills | #9: Technical Applications in the Construction Industry | Examine building systems and components to evaluate their usefulness to a project. | Identify building systems needed to complete a construction project. | List all building systems involved in a project.
 |  |  |  |  | Describe the purpose of each system.
 |  |  |  | Identify components of building systems needed to complete a construction project. | List all components of the involved building system.
 |  |  |  |  | Describe the function of each component.
 |  |  |  | Incorporate appropriate building systems into a construction project. | Use appropriate components for the building systems required.
Spreadsheet: 781989d1653669246-formulas-to-setup-28-28-work-rotation-sample_patternsheet
Sheet: Pattern_Generator

[NAME] |  | 28 |  | 12 | <--Set Hours Per Shift
Employee Name | Date | ON/OFF | Days | Hours
FIRST LAST | 2022-01-01 00:00:00
Spreadsheet: 802341d1666795102-rank-with-multiple-criteria-for-equal-values-league-data-anon-1-
Sheet: Template

 |  | 2022-10-25 00:00:00
No. | Name | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W1P | W2P | W3P | W4P | W5P | W6P | W7P | W8P | W9P | W10P | W11P | W12P | W13P | Games | Points | [NAME]. | Helper | Position
 | [NAME] | 1
 | [NAME] | 2
 | Lagwn Tmkt | 3
 | [NAME] | 4
 | [NAME] | 5
 | Hwxok Vfcpydxsm | 6
 | [NAME] | 7
 | [NAME] | 8
 | Umptc Fmeaits | 9
 | Pes Nhye | 10
 | Hkvg Gvakplm | 11
 | [NAME] | 12
 | Wmcdcc Woyjp | 13
 | [NAME] | 14
Spreadsheet: 90734d1290500047-lookup-from-separate-sheet-ops-cards
Sheet: Metal Melting

 |  |  |  |  | Master Information Record
 | Part No. | 3462.01 |  |  |  | Tooling Ref. |  |  | Casting Weight |  | Kgs
 | Customer. |  |  |  |  | Drg/lss.No. |  |  | Gross Wt./Mld |  | Kgs
 | Material. |  |  |  |  |  |  |  | Yield |  | %
q | Cust. Spec |  |  |  |  |  |  |  | Castings/Mould
METAL MELTING
p | CEL Range |  |  |  |  | ACEL                -
p | CEL Measurement |  |  |  |  | WI 10.20
p | Minimum Pouring Temperature
p | Maximum Pouring Temperature
p | Late-Stream Innoculation |  |  |  |  | TDS 20 &     (      %)
 |  |  |  |  |  | (Increasing this rate if required)
p | Chill Wedge Test
 | Chill Wedge Testing |  |  |  |  | WI 10.21
p | [NAME] and Ladle Additions |  |  |  |  | WI 9.20
p | Metal Testing Frequency - Melters |  |  |  |  | WI 9.19
 | Non-conforming product |  |  |  |  | WI 13.2
p | Leco Carbon Operation |  |  |  |  | WI 9.56
 | Leco Routine Maintenance |  |  |  |  | WI 11.13 & 11.16
qDenotes Customer Significant Characteristic
(WHEN PRINTED) THIS IS AN UNCONTROLLED DOCUMENT
Spreadsheet: 434edf06-d24e-4594-95f9-4fe55eb6970d
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
43995472 | 2014-11-12 21:42:47 | AXIS | 0 | 5 | 6 | 1663206 | Guillaume le batard III | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43995795 | 2014-11-12 22:13:51 | ALLIES | 1 | 6 | 3 | 1663206 | Guillaume le batard III | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43996690 | 2014-11-12 22:59:22 | ALLIES | 0 | 3 | 5 | 506159 | Hurletout | 12507 | western | 1945-01-11 | 1945-01-11 | Strasbourg | Strasbourg
44047671 | 2014-11-16 13:38:51 | AXIS | 1 | 6 | 2 | 1204546 | [NAME] | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
44047864 | 2014-11-16 14:00:42 | ALLIES | 1 | 6 | 3 | 1204546 | [NAME] | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
44053590 | 2014-11-16 20:41:14 | AXIS | 1 | 6 | 5 | 1670292 | Unrealik280 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44053896 | 2014-11-16 20:57:48 | ALLIES | 1 | 6 | 3 | 1670292 | Unrealik280 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44070302 | 2014-11-17 22:52:16 | ALLIES | 0 | 5 | 6 | 506159 | Hurletout | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
44070575 | 2014-11-17 23:09:18 | AXIS | 0 | 3 | 6 | 506159 | Hurletout | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
44081492 | 2014-11-18 19:33:54 | AXIS | 0 | 4 | 5 | 1331277 | Arjen81 | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
44145860 | 2014-11-23 12:23:32 | ALLIES | 0 | 1 | 7 | 1472328 | [NAME] | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44147411 | 2014-11-23 15:16:55 | AXIS | 1 | 10 | 4 | 1088314 | bino_zoet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44147782 | 2014-11-23 15:39:10 | ALLIES | 0 | 5 | 10 | 1088314 | bino_zoet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 113636d1309464527-need-help-with-if-then-formula-dummy-data
Sheet: Dummy Data

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 | 2011-06-20 00:00:00 | 2011-06-21 00:00:00 | 2011-06-22 00:00:00 | 2011-06-23 00:00:00 | 2011-06-24 00:00:00 | 2011-06-25 00:00:00 | 2011-06-26 00:00:00
Custom HBC PEG Employees | Mon | TUE | WED | THU | FRI | SAT | SUN | Hours | Rate | Total
Person A | 8 | 8 | 8 | 8 | 8 | 0 | 2 | 42 | 11.88 | 510.84
Person B | 8 | 8 | 8 | 8 | 8 | 4 | 0 | 44 | 11.88 | 546.48
Person C | 8 | 8 | 8 | 8 | 8 | 0 | 0 | 40 | 11.88 | 475.2
Person D | 8 | 8 | 8 | 8 | 8 | 7 | 0 | 47 | 11.88 | 599.94
 |  |  |  |  |  |  |  |  | 11.88
 |  |  |  |  |  |  |  |  | 11.88
Daily Hours | 32 | 32 | 32 | 32 | 32 | 11 | 2 | 173 | TOTAL
Daily Dollars | 380.16 | 380.16 | 380.16 | 380.16 | 380.16 | 326.7 | 59.40000000000001 | 2286.9 |  | 2132.46
Person A | 0 | 0 | 0 | 0 | 0 | 0 | 2
Person B | 0 | 0 | 0 | 0 | 0 | 4 | 0
Person C | 0 | 0 | 0 | 0 | 0 | 0 | 0
Person D | 0 | 0 | 0 | 0 | 0 | 7 | 0
Spreadsheet: 6f1132e5-f018-4889-a6a4-1c7436a63e61
Sheet: Sheet1

Table S7: association analysis of fat phenotypes using raw estimates for the significant loci | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Locus | SNP (Effect/Non-Effect) | Analysis group | Phenotype | N Subjects | N Studies | P-value (fixed effects) | ß | SE | I² | P-value (heterogeneity)
TFAP2B (6p12) | rs987237 (G/A) | both | BIA %total fat | 29315.93 | 19 | 0.0183569806 | 0.15347043 | 0.06507568 | 0 | 0.6823662916
 |  |  | DXA %total fat | 13039 | 14 | 0.0198071344 | 0.24881422 | 0.10678807 | 0 | 0.8704771335
 |  |  | % central fat | 7346 | 9 | 0.9856661695 | -0.00027137309 | 0.01510502 | 0 | 0.8067434836
MSRA (8p23.1) | rs7826222 (G/C) | both | BIA %total fat | 24178.78 | 15 | 0.0191724386 | 0.17908386 | 0.07646095 | 0 | 0.8793613767
 |  |  | DXA %total fat | 5786 | 5 | 0.5220575336 | 0.11630836 | 0.18168157 | 44.276838675 | 0.1267584162
 |  |  | % central fat | 256 | 1 | 1 | 0 | 0.1 | 0
LYPLAL1 (1q41) | rs2605100 (G/A) | women | BIA %total fat | 9238 | 7 | 0.07843 | -0.205 | 0.117 | 56.8934 | 0.03055
 |  |  | DXA %total fat | 5455 | 3 | 0.01358 | -0.354 | 0.143 | 29.296 | 0.24308
 |  |  | % central fat | 2182 | 2 | 0.2732 | -0.033 | 0.03 | 53.9382 | 0.14064
Alleles:  the first allele listed in the parenthesis is the effect allele
Effect size (b), standard error (SE)
the "N studies" is currently a count of the number of study-gender combinations analyzed (the number of separate analysis result files combined), rather than the number of independent cohorts.
Spreadsheet: 0aa1acd9-7b9f-4197-ba96-70b12b002528
Sheet: January 2013

Spend over £25,000 - Publication template
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | SMG | 2013-01-10 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 169283 | 28974.85
DCMS | SMG | 2013-01-10 00:00:00 | Build Construction | York Major project | MDMPROPS Limited | 169335 | 28455.47
DCMS | SMG | 2013-01-10 00:00:00 | Professional Fees | ScM Major projects | Constantine Limited | 169432 | 73438.2
DCMS | SMG | 2013-01-10 00:00:00 | Professional Fees | ScM Major projects | Universal Design Studio Limited | 169458 | 50250
DCMS | SMG | 2013-01-10 00:00:00 | Equipment/Materials | ScM Major projects | Link 51(Storage Products) | 169796 | 47901
DCMS | SMG | 2013-01-25 00:00:00 | Group Business Advertising | SMG Advertising | Total Media Limited | 170159 | 53643.55
DCMS | SMG | 2013-01-16 00:00:00 | Gas | Science Museum Estates | Gazprom Marketing & Trading Limited | 170160 | 25054.68
DCMS | SMG | 2013-01-16 00:00:00 | Gas | Science Museum Estates | Gazprom Marketing & Trading Limited | 170169 | 25054.68
DCMS | SMG | 2013-01-25 00:00:00 | Security | NRM Security | [NAME] | 170293 | 32771
DCMS | SMG | 2013-01-25 00:00:00 | Security | NMeM Security | [NAME] | 170294 | 32309.75
DCMS | SMG | 2013-01-25 00:00:00 | Security | ScM Security | [NAME] | 170322 | 149267.33
DCMS | SCMGE | 2013-01-10 00:00:00 | Contract Cleaning | Visitor Experience | Servest (Sherwood) Ltd | 119884 | 85381.8
Spreadsheet: df97c929-c9d6-4bd9-bad6-22e2e70c7a67
Sheet: QTD Recon Q3FY10

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended December 31, 2009
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Strategic Investments |  | Restructuring and other |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 1243 |  | 0 |  | 103 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1346
Cost of revenue | 654 |  | -2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 652
Gross profit | 589 |  | 2 |  | 103 |  | 0 |  | 0 |  | 0 |  | 0 |  | 694
Operating expenses:
Marketing and sales | 208 |  | 0 |  | 0 |  | 0 |  | 0 |  | -4 |  | 0 |  | 204
General and administrative | 84 |  | 0 |  | 0 |  | 0 |  | 0 |  | -9 |  | 0 |  | 75
Research and development | 290 |  | 0 |  | 0 |  | 0 |  | 0 |  | -29 |  | 0 |  | 261
Amortization of intangibles | 14 |  | -14 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 100 |  | 0 |  | 0 |  | 0 |  | -100 |  | 0 |  | 0 |  | 0
Total operating expenses | 696 |  | -14 |  | 0 |  | 0 |  | -100 |  | -42 |  | 0 |  | 540
Operating income (loss) | -107 |  | 16 |  | 103 |  | 0 |  | 100 |  | 42 |  | 0 |  | 154
Loss on strategic investments | -1 |  | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income (expense), net | -2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -2
Income (loss) before provision for (benefit from) income taxes | -110 |  | 16 |  | 103 |  | 1 |  | 100 |  | 42 |  | 0 |  | 152
Provision for (benefit from) income taxes | -28 |  |  |  |  |  |  |  |  |  |  |  | 71 |  | 43
Net income (loss) | -82 |  | 16 |  | 103 |  | 1 |  | 100 |  | 42 |  | -71 |  | 109
Loss per share |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -0.25 |  |  |  |  |  |  |  |  |  | Basic | 0.09 |  |  | 0.34
 |  |  |  |  |  |  |  |  |  |  | Diluted | 0.09 |  |  | 0.33
Number of shares used in computation
Basic and diluted | 325 |  |  |  |  |  |  |  |  |  | Number of shares used in computation
 |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 325
 |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 327
Spreadsheet: 858902d1707400707-help-sumif-multiple-tabs-example2
Sheet: March

Name | NHS | 1st | 2nd | 3rd | Seen | Comments |  |  | Month Summary
Name 27
Name 28
Name 29 |  |  |  |  |  |  |  |  | Done Totals
Name 30 |  |  |  |  |  |  |  |  | Outstanding Totals
Name 31
Name 32
Name 33
Name 34 |  |  |  |  | s
Name 35
Name 36
Name 37
Name 38
Spreadsheet: 676381d1588779866-detecting-schedule-conflicts-minimal-sample-shoefits-
Sheet: 2-Bob

 | Schedule for employee #: | 2
 |  |  |  |  |  |  |  |  | Conflict detection |  |  |  |  |  | contains the lowest Employee # besides me who is also scheduled
Customer # | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Day with first conflict
1 | 0 | 0 | 1 | 0 | 1 | 0 | 1
3 | 0 | 0 | 0 | 0 | 0 | 1 | 1
4 | 1 | 0 | 0 | 1 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  |  |  | 3 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 781515d1653390580-array-formula-which-isnt-populating-further-down-the-sheet-stock-control
Sheet: Summary

Stock Summary
General Products in Stock | General Products Low in Stock | Total Projects | Completed Projects | Projects Awaiting Stock
Product Category | Total Products Low in Stock | Product been reordered | Expected Delivery Date
 |  | Yes
 |  | N/A
 |  | N/A
 |  | N/A
 |  | N/A
 |  | N/A
 |  | N/A
 |  | 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: 870701d1717166549-create-summary-page-using-formula-from-multiple-sheets-data-are-in-different-columns-on-ea-sample-file
Sheet: Sheet3

Name | Price-A | Price-B | Price-C
Brand1 | 5 | 10 | 15
Brand2 | 20 | 30 | 40
Brand3 | 35 | 50 | 65
Brand4 | 50 | 70 | 90
Spreadsheet: 835749d1688784519-identify-max-trip-number-per-month-found-max-number-based-on-date-month-and-years
Sheet: Sheet1

 |  |  | this is the data
Received Date | Trip |  |  | RESULT I WANT | [NAME]
2022-01-03 00:00:00 | 1 |  |  | 2022-01-31 00:00:00 | 2 |  |  |  | SUMPRODUCT(--1/COUNTIF(A3:A24;A3:A24))
2022-01-03 00:00:00 | 2 |  |  |  | 2 |  |  |  | EOMONTH
2022-01-05 00:00:00 | 1 |  |  |  | 3
2022-01-05 00:00:00 | 2 |  |  |  | 1
2022-01-20 00:00:00 | 1 |  |  |  | 4
2022-01-20 00:00:00 | 2 |  |  | 2023-01-31 00:00:00 | 3
2022-02-01 00:00:00 | 1 |  |  |  | 2
2022-02-01 00:00:00 | 2 |  |  |  | 3
2022-02-15 00:00:00 | 1 |  |  |  | 3
2022-02-20 00:00:00 | 1 |  |  |  | 2
2022-03-04 00:00:00 | 1
2022-03-04 00:00:00 | 2
2022-03-04 00:00:00 | 3
2022-04-05 00:00:00 | 1
2022-04-06 00:00:00 | 1
2022-04-07 00:00:00 | 1
2022-05-05 00:00:00 | 1
2022-05-05 00:00:00 | 2
2022-05-05 00:00:00 | 3
2022-05-05 00:00:00 | 4
2023-01-03 00:00:00 | 1
2023-01-03 00:00:00 | 2
2023-01-05 00:00:00 | 1
2023-01-05 00:00:00 | 2
2023-01-05 00:00:00 | 3
2023-01-20 00:00:00 | 1
2023-02-01 00:00:00 | 1
2023-02-01 00:00:00 | 2
2023-02-15 00:00:00 | 1
2023-02-20 00:00:00 | 1
2023-03-05 00:00:00 | 1
2023-03-05 00:00:00 | 2
2023-03-05 00:00:00 | 3
2023-04-05 00:00:00 | 1
2023-04-05 00:00:00 | 2
2023-04-05 00:00:00 | 3
2023-05-05 00:00:00 | 1
2023-05-06 00:00:00 | 1
2023-05-07 00:00:00 | 1
2023-05-07 00:00:00 | 2