tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 35136d1232649199-conditional-formatting-months-arpspreadsheet-both
Sheet: Sheet1

Direct | ARP Due
[NAME] | 2009-12-01 00:00:00
[NAME] | 2009-09-01 00:00:00
[NAME] | 2010-01-01 00:00:00
[NAME] | 2009-10-01 00:00:00
[NAME] | 2009-05-01 00:00:00
[NAME] | 2009-03-01 00:00:00
[NAME] | 2009-11-01 00:00:00
[NAME] | 2009-05-01 00:00:00
[NAME] | 2009-09-01 00:00:00
[NAME] | 2009-09-01 00:00:00
[NAME] | 2009-09-01 00:00:00
[NAME] | 2008-06-01 00:00:00
[NAME] | 2009-09-01 00:00:00
[NAME] | 2009-08-01 00:00:00
[NAME] | 2009-11-01 00:00:00
[NAME] | 2008-11-01 00:00:00
[NAME] | 2008-09-01 00:00:00
[NAME] | 2009-02-01 00:00:00
[NAME] | 2009-08-01 00:00:00
[NAME] | 2009-05-01 00:00:00
[NAME] | 2009-10-01 00:00:00
Nicola Web | 2008-02-01 00:00:00
[NAME] | 2009-10-01 00:00:00
[NAME] | 2009-09-01 00:00:00
[NAME] | 2009-10-01 00:00:00
[NAME] | 2009-03-01 00:00:00
[NAME] | 2008-06-01 00:00:00
[NAME] | 2009-04-01 00:00:00
 | Overdue by more than 3 months
 | Overdue by between 3 and 1 month
 | Due this month
 | Due next month
 | Due between next month and 3 months time
 | Due in more than 3 months
Spreadsheet: 2e227dd0-b45c-493e-ba23-624de81c5691
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PBNA | Test | PBNA | Lead, Nails | Lead, Nails | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Varies: Var |  |  | 0.5 | g | Container/Tube: Hair and Nails Collection Kit (Supply T565) [NAME]: 0.5 g Collection Instructions: 1. Prepare and transport specimen per the instructions in the kit or see [NAME] and Nails Instruction Sheet for Metals Testing in Special Instructions. 2. Clippings should be taken from all 10 fingernails or toenails. Additional Information: If known, indicate source of nails (fingernails or toenails). | 0.1 g | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0.0-3.9 mcg/g of nails Reference values apply to all ages. | Tuesday, Friday; 5 p.m. | 2 days | 3 days | 1 | 83655 |  |  |  |  | Rochester
PBNA | [NAME] | NAIL | Nail |  |  |  | Ambient
PBNA | Order Question | PBNSC | [NAME] |  | Answer List
PBNA | Option | PBNSC-1 | Finger
PBNA | Option | PBNSC-2 | Toe
PBNA | Option | PBNSC-3 | Finger and Toe
PBNA | Result | 2506 | Lead, Nails | Lead, Nails | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | 8202-4 | Lead:MCnt:Pt:Nail:Qn:
PBNA | Result | PBNSC | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
Spreadsheet: kate_symes__19064__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-04-10 00:00:00 |  | 189.32 | 1184 | 98.94 | 1440
 | 2001-04-09 00:00:00 |  | 126.46 | 2896 | 105.72 | 1264 | 122.88 | 1015 | 86.46 | 925
 | 2001-04-08 00:00:00 |  | 130 | 0 | 98 | 0 | 97.91 | 2833 | 87.85 | 1659
 | 2001-04-07 00:00:00 |  | 183.6 | 2576 | 92.82 | 1704 | 114.42 | 1980 | 114.75 | 800
 | 2001-04-06 00:00:00 |  | 183.6 | 2576 | 92.93 | 1680 | 147.71 | 1463 | 91.2 | 1429
 | 2001-04-05 00:00:00 |  | 200.55 | 5984 | 102.44 | 2408 | 127.14 | 2549 | 98.45 | 1862
 | 2001-04-04 00:00:00 |  | 199.23 | 4384 | 103.75 | 2232 | 148.64 | 1692 | 81.66 | 1580
 | 2001-04-03 00:00:00 |  | 188.58 | 4064 | 116.57 | 1632 | 117.12 | 1130 | 85.69 | 262
 | 2001-04-02 00:00:00 |  | 238.59 | 1024 | 150.88 | 912 | 137.01 | 2361 | 111.15 | 1000
 | 2001-04-01 00:00:00 |  | 180 | 800 | 107 | 600 | 148.11 | 1110 | 121.38 | 1200
 | 2001-03-31 00:00:00 |  | 154.62 | 624 | 95.02 | 1832 | 208.73 | 2005 | 132.05 | 925
 | 2001-03-30 00:00:00 |  | 154.62 | 624 | 94.91 | 1832 | 157.25 | 2240 | 118.11 | 1415
 | 2001-03-29 00:00:00 |  | 150.35 | 1824 | 96.1 | 1672 | 134.29 | 2045 | 98.07 | 1330
 | 2001-03-28 00:00:00 |  | 133.2 | 3328 | 74.97 | 1544 | 115.44 | 1399 | 82.09 | 1685
 | 2001-03-27 00:00:00 |  | 105.94 | 1104 | 69.87 | 1232 | 119.31 | 1428 | 71.55 | 1817
 | 2001-03-26 00:00:00 |  | 278.99 | 1104 | 158.37 | 712 | 121.58 | 1216 | 59.09 | 901
 | 2001-03-25 00:00:00 |  | 195 | 0 | 150 | 0 | 83.27 | 1706 | 57.7 | 1655
 | 2001-03-24 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 122.71 | 3765 | 146.16 | 2205
 | 2001-03-23 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 212.95 | 3035 | 164.51 | 1676
 | 2001-03-22 00:00:00 |  | 282.93 | 464 | 175.42 | 2032 | 299.77 | 1910 | 211.67 | 1390
 | 2001-03-21 00:00:00 |  | 353.67 | 1024 | 220.45 | 880 | 351.62 | 4153 | 259.99 | 1589
 | 2001-03-20 00:00:00 |  | 323.59 | 624 | 221.88 | 1600 | 281.92 | 1957 | 245.43 | 1616
 | 2001-03-19 00:00:00 |  | 291.72 | 1024 | 197.04 | 1272 | 197.2 | 635 | 225 | 20
 | 2001-03-18 00:00:00 |  | 220 | 0 | 182.5 | 0 | 149.33 | 1225 | 119.19 | 980
 | 2001-03-17 00:00:00 |  | 204.13 | 1008 | 134.76 | 2888 | 180.48 | 2250 | 127.55 | 570
 | 2001-03-16 00:00:00 |  | 204.13 | 1008 | 134.84 | 2864 | 209.71 | 1442 | 126.88 | 1046
 | 2001-03-15 00:00:00 |  | 180.74 | 2160 | 109.85 | 2184 | 189 | 2490 | 123.8 | 1881
 | 2001-03-14 00:00:00 |  | 163.59 | 1024 | 89.3 | 696 | 152.63 | 4365 | 107.38 | 1787
 | 2001-03-13 00:00:00 |  | 166.63 | 2064 | 81.94 | 1392 | 154.62 | 2586 | 118.47 | 1995
 | 2001-03-12 00:00:00 |  | 172.81 | 1424 | 102.15 | 1696 | 159.9 | 3783 | 116.27 | 2115
 | 2001-03-11 00:00:00 |  | 145 | 160 | 95 | 0 | 118.53 | 2962 | 105.52 | 2029
Spreadsheet: 68758d1269316980-lookup-match-multiple-variables-streets-example-v1
Sheet: Voters

LAST NAME | FIRST NAME | STREET NUMBER | STREET NAME |  | PRECINCT
Doe | [NAME] | 123 | [NAME] | O | FAD | <--Should return [NAME]
Smith | [NAME] | 420 | [NAME] | E | CCC | <--Should return Precinct CCC
Washer | [NAME] | 4445 | [NAME] | O | ABC | <--Should return Precinct ABC
Jones | JJ | 1600 | [NAME] | E | ZZM | <--Should return [NAME]
Spreadsheet: 860291d1708442749-count-item-code-in-different-table-example-excel-forum
Sheet: Data Table

Item Code | Quantity
1234 | 10
1234 | 1
1235 | 2
1232 | 4
1235 | 5
1111 | 6
2222 | 7
2222 | 8
2222 | 4
1234 | 3
1234 | 5
1235 | 6
1232 | 2
1235 | 3
1111 | 15
2222 | 3
2222 | 4
2222 | 6
1234 | 12
Spreadsheet: 31398d1227211141-regress-nonlinear-equation-logit_log4-equations
Sheet: Sheet1

“logit/log4”
R0 |  | 486.352 | 486.352
[NAME] |  | 839.297 | 839.297
A |  | -4.87399 | -4.87399
B |  | 1.99643 | 1.99643
 |  | R0+Kc/(1+exp(-(a+b*ln(CT))) | exp((a+ln((Kc/(R-R0)-1)/-b)))
std | CTstd (as %) | calc'd R | calc'd C end | ~ converted rate from plot
1 | 1e-05 | 486.3520000006683 | 9.999941614355593e-06 | 0.325
2 | 4.7 | 607.0109574279738 | 4.699999999999999 | 0.42
3 | 7.8 | 751.4138558212962 | 7.800000000000002 | 0.52
4 | 11.1 | 891.5927964543832 | 11.1 | 0.62
5 | 14.5 | 1001.800302415205 | 14.5 | 0.68
std | Cend (% obs'd) | calc'd R | calc'd C end
1 | 1e-05 | 486.3520000006683 | 9.999941614355593e-06
2 | 4.8 | 611.4187150453508 | 4.800000000000001
3 | 7.7 | 746.7644218142866 | 7.7
4 | 11.2 | 895.3463921405223 | 11.2
5 | 14.4 | 999.0481145023377 | 14.4
Spreadsheet: david_delainey__8093__Q400
Sheet: Sheet1

 |  |  | [NAME] |  | Q4
 |  |  | East | [NAME]
 |  |  | [NAME] |  |  | 20000000 | split 50/50 with Mexico
 |  |  | Chicago Hub |  |  | 8000000
 |  |  | Alamac |  |  | 6000000 | split 50/50 with EIM
 |  |  | AES/Calvert City |  |  | 2000000
 |  |  | Intergen/Haywood |  |  | 2000000
 |  |  | NYSEG |  |  | 2000000
 |  |  | West | Calger
 |  |  | Pastoria |  |  | 30000000
 |  |  | LV |  |  | 10000000
 |  |  | DWR |  |  | 5000000
 |  |  | WAPA |  |  | 2000000
 |  |  | Calif -LODI |  |  | 1000000
 |  |  | [NAME] | Duran
 |  |  | Brazos/ANP |  |  | 10000000
 |  |  | Dynegy |  |  | 12000000
 |  |  | Canada | Milly
 |  |  | British Energy |  |  | 0 | Keep option open
 |  |  | PML |  |  | 4000000
 |  |  | Sunoco PPA |  |  | 2000000 | Related to British Energy
 |  |  | [NAME] |  |  | 1000000
 |  |  | [NAME] |  |  | 2000000
 |  |  | NUGS |  |  | 2000000
 |  |  | Petro |  |  | 2000000
 |  |  | Various |  |  | 2000000
 |  |  | Mexico | [NAME]
 |  |  | Vitro |  |  | 20000000
 |  |  | [NAME] |  |  | 20000000
 |  |  | PI | Donahue
 |  |  | Dais Analytic |  |  | 6200000
 |  |  | Solo |  |  | 5500000
 |  |  | Utiliquest |  |  | 7500000
 |  |  | Utiliquest
 |  |  | Upstream Orig | Mrha
 |  |  | Blackwater |  |  | 3000000
 |  |  | JM Huber |  |  | 7000000
 |  |  | Napoleon Pad Gas |  |  | 5000000
 |  |  | LIPA |  |  | 2000000
 |  |  | North Central Oil |  |  | 1000000
 |  |  | ECR | Thompson/Josey
 |  |  | Aspect, Preston, Exco |  |  | 8000000
 |  |  | Total
Spreadsheet: 459051d1462390264-timeline-template-timeline
Sheet: Project Timeline

 |  | PROJECT TIMELINE
 |  | ENTER START DATE: | 2016-01-01 00:00:00
 | Id | ACTIVITY | START | END | NOTES
 |  | Project Start | 2016-01-04 00:00:00 | 2016-01-04 00:00:00
 |  | IE11_1 | 2016-02-04 00:00:00 | 2016-02-04 00:00:00
 |  | IE11_2 | 2016-02-05 00:00:00 | 2016-02-05 00:00:00
 |  | IE11_3 | 2016-02-11 00:00:00 | 2016-02-11 00:00:00
 |  | IE11_4 | 2016-02-16 00:00:00 | 2016-02-16 00:00:00
 |  | IE11_5 | 2016-02-18 00:00:00 | 2016-02-18 00:00:00
 |  | IE11_6 | 2016-02-24 00:00:00 | 2016-02-24 00:00:00
 |  | IE11_7 | 2016-03-07 00:00:00 | 2016-03-07 00:00:00
 |  | IE11_8 | 2016-03-08 00:00:00 | 2016-03-08 00:00:00
 |  | [NAME] | 2016-03-09 00:00:00 | 2016-03-09 00:00:00
 |  | IE11_10 | 2016-03-14 00:00:00 | 2016-03-14 00:00:00
 |  | IE11_11 | 2016-03-16 00:00:00 | 2016-03-16 00:00:00
 |  | IE11_12 | 2016-03-21 00:00:00 | 2016-03-21 00:00:00
 |  | IE11_13 | 2016-04-06 00:00:00 | 2016-04-06 00:00:00
 |  | IE11_14 | 2016-04-11 00:00:00 | 2016-04-11 00:00:00
 |  | PILOT - I | 2016-04-11 00:00:00 | 2016-04-11 00:00:00
 |  | ImageNow 7.1.3_1 | 2016-04-12 00:00:00 | 2016-04-12 00:00:00
 |  | ImageNow 7.1.3_2 | 2016-04-12 00:00:00 | 2016-04-12 00:00:00
 |  | IE11_15 | 2016-04-14 00:00:00 | 2016-04-14 00:00:00
 |  | IE11_16 | 2016-04-21 00:00:00 | 2016-04-21 00:00:00
 |  | IE11_17 | 2016-04-25 00:00:00 | 2016-04-25 00:00:00
 |  | IE11_aaa | 2016-05-05 00:00:00 | 2016-05-05 00:00:00
 |  | PILOT - a | 2016-05-05 00:00:00 | 2016-05-05 00:00:00 | TIMELINE STOPS HERE FOR SOME REASON AND I CAN'T SCROLL ANYMORE
 |  | IE11_EBPVD | 2016-05-06 00:00:00 | 2016-05-06 00:00:00
 |  | Test | 2016-06-01 00:00:00 | 2016-06-01 00:00:00
 |  | Test 2 | 2016-07-05 00:00:00 | 2016-07-05 00:00:00
 |  | Test 3 | 2016-08-06 00:00:00 | 2016-08-06 00:00:00
Spreadsheet: 59173d1259644392-excel-2007-vlookup-expenses-2009-4
Sheet: 2009-04

EXPENSES
Date |  | Creditor | Details | Invoice | Amount | [NAME] | Nett
Total
2009-04-07 00:00:00 |  | Compudoc | Stock | CRS61489 | 114.04 | 15.96 | 130
2009-04-07 00:00:00 |  | Imaginet | Services | 0003008-3-0904 | 3472.95 | 486.21 | 3959.16
2009-04-07 00:00:00 |  | [NAME] | Stock | 10 |  |  | 570
2009-04-08 00:00:00 |  | Kenrich Motors | Re-Gas Air Con (MVH Repairs) | 526705 | 360 | 50.4 | 410.4
2009-04-14 00:00:00 |  | Ackermans | Misc Sales | 5456 | 396.27 | 55.48 | 451.75
2009-04-16 00:00:00 |  | D&A Timbers | Mirror | 0024/01985372 | 96.9 | 13.56 | 110.46
2009-04-17 00:00:00 |  | Crazy Store | Misc Sales |  | 26.45 | 2.6 | 29.05
2009-04-17 00:00:00 |  | Game Stores | Stock (X Boxes) | 173/17042009/115/37/0024 | 5682.43 | 795.54 | 6477.97
2009-04-18 00:00:00 |  | clicks | Misc Sales |  | 156.98 | 21.98 | 178.96
2009-04-20 00:00:00 |  | Fedex | Transportation of goods | 741639 | 541.37 | 468.92 | 1010.29
2009-04-21 00:00:00 |  | C N A | Stationary |  | 1238.89 | 173.45 | 1412.34
2009-04-21 00:00:00 |  | [NAME] | Petrol. Oil and [NAME] sales | 19084 |  |  | 587.1
2009-04-24 00:00:00 |  | Expeditors | Transportation of goods | E708482659 | 153.51 | 21.49 | 175
2009-04-28 00:00:00 |  | [NAME] | Repairs | 12 |  |  | 1059
2009-04-29 00:00:00 |  | [NAME] | Stock | 13 |  |  | 1600
2009-04-30 00:00:00 |  | Furmark | Kenward | 2583 | 342.11 | 47.89 | 390
Spreadsheet: 147187d1332578689-creating-a-test-scambling-the-words-exam9numbers
Sheet: Sayfa1

ı | don't | like | playing | tennis |  |  |  |  | playing ı  like don't tennis |  |  | 0.2941578019926965 | 7
 |  |  |  |  |  |  |  |  |  |  |  | 0.1817724760612691 | 8
we | can | not | ride | bicycles |  |  |  |  | ride we  not can bicycles |  |  | 0.00546749201566854 | 9
 |  |  |  |  |  |  |  |  |  |  |  | 0.5572513495144449 | 4
there | are | five | cats | in | the | garden |  |  | garden   cats there the five are in |  |  | 0.9747562801203458 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 0.315772243239735 | 6
does | a | baby | drink | milk | ? |  |  |  | drink does ? baby a milk |  |  | 0.9521499000929907 | 3
 |  |  |  |  |  |  |  |  |  |  |  | 0.9658706644886479 | 2
how | many | books | have | they | got | ? |  |  | ?   have how got books many they |  |  | 0.3713657542139117 | 5
my | sister | doesn't | like | playing | football |  |  |  | like my football doesn't sister playing
the | blue | car | is | behind | the | hospital |  |  | hospital   is  the the car blue behind
Has | [NAME] | got | any | red | pencils | ? |  |  | ?   any Has pencils got Mustafa red
a | parrot | has | got | colourfull | wings | and | a | beak | and a beak got a wings has parrot colourfull
[NAME] | Kemal | has | got | blue | eyes | and | yellow | hair | and yellow hair got Mustafa eyes has Kemal blue
Spreadsheet: 847760d1698641394-how-to-hide-specific-cells-using-conditional-formatting-formula-request-form-3
Sheet: Revision History

Serialisation - Decommissioning Request Form  VQD-FRM-033895
Role and Reason for Approval
Name | Role | Reason for Approval
[NAME] | Author | The Author is signing to confirm that this document has been prepared in alignment with approved document management process, the relevant input from the contributory authors has been included as well as the appropriate review and editing process has been followed.
[NAME] | Serialisation Service Officer | The Serialisation Service Officer is signing as accountable for Global Serialisation Business processes and confirms that this document defines clearly and accurately the business processes.
Sunita Davies | Quality Compliance Authority | The Quality Compliance Authority is signing to confirm compliance with applicable pharmaceutical regulatory agency expectations and company standards.
Revision History
Date | Version | Revised by | Reason For Revision
As per CDMS | 9 | [NAME] | Update to 'Instructions' and 'Decommissioning Request Form' tabs to include a note to state that the Pallet SSCC Decommissioning must be used on Aggregated batches to ensure the highest level of aggregation Hierarchy has been decommissioned.
As per VQD | 10 | [NAME] | Update to 'Instructions' and 'Decommissioning Request Form' to reflect addition of new field that will autopopulate the count of ISU SNR's that are entered into the form. Update/rewording of row 29 of 'Decommissioning Request Form' tab from 34 to 46.
As per VQD | 11 | [NAME] | Update throughout to replace all [NAME]/CDMS references with updated Service Now process. Update to Instructions tab to include correct VQD references Update to Instructions tab to include new instructions on the additional fields added to Decommissioning Request Form tab relating to Types of Decommissioning required. Update to 'Decommissioning Request Form tab to include  new Type of Decommissioning section to allow requestor to differentiate between 2 different types of [NAME] and also to be able to select partial decommissioning. Update to 'Decommissioning Request Form tab to correct previous error where user had to unprotect worksheet to allow extra rows to be added for capturing the Serial Number / SSCC number details. Update to 'Decommissioning Request Form tab to remove references to Retention / Annex 19 samples having to be decommissioned as DESTROYED. Update to Revision History Tab to include Document title and VQD Ref numbers.
As per VQD | 12 | [NAME] | As per DCR CR-0328880  Instruction has been added into step 3 of row 1 of 'Instructions' tab to state that 'any cells which are not applicable must be populated with N/A'.  Update to 'Decommissioning Request Form tab to reflect change in Decommissioning Reason, FREE_SAMPLE changed to FREE SAMPLE (underscore removed) to clarify exact reason to be entered.
Spreadsheet: 154303d1336372310-automation-of-excel-sheet-ves_msps_time_management_9th-20-2013th-20april11-1-
Sheet: TimeSheet- 2nd - 6th April'12

 |  |  |  |  |  |  | NON VATS |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Vacation/ Holiday Day
SAP Id | Resource Name | Team | Newco - Incident Mgmt | Newco - VES TechSupport | VES - Incident Mgmt | VES - Chordiant OR CRM Support | Chordiant_BAU | Online_Programme | Vendor_Integration_Prog | Vodafone_eShop_L3 | Chordiant_BAU | EG_NewCo_eShop | N_Portfolio_Project | MTS_RoamingData_Rfsh | APP_SKYWALKER | LT_UK_MTS_PAS_Capacity_for_USS | Chargeable Hours | Non-Chargeable | Vacation | Public Holiday
10722721 | [NAME] | Incident Mgmt |  |  | 2.5 |  |  |  | 2 |  |  |  |  | 4.5 |  |  |  | 0 | 27 | 0
10731386 | Banpreet Singh | Incident Mgmt | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10391107 | [NAME] | Incident Mgmt |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10628998 | [NAME] | Incident Mgmt |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10628911 | [NAME] | Incident Mgmt |  |  | 0 |  |  | 4.5 |  |  |  |  |  |  | 4.5 |  |  | 0 | 0 | 0
10556485 | Ajay  Ashtikar | Incident Mgmt | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10727324 | Amber [NAME] | Incident Mgmt |  |  | 5.5 |  |  |  |  |  |  |  |  |  |  | 3.5 |  | 0 | 0 | 0
10381737 | [NAME] | Incident Mgmt |  |  |  |  | 4.5 | 4.5 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10614473 | [NAME] | Tech support |  |  |  | 6.5 |  | 2.5 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10556831 | [NAME] | Tech support |  |  |  | 6.5 |  | 2.5 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10716330 | [NAME] | Tech support |  |  |  | 6.5 |  | 2.5 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10724809 | [NAME] | Tech support |  |  |  | 6.5 |  | 2.5 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Daily Total
 | Weekly Total
 | Poject | Hours Weekly
 | Non-VATS - Online_I.40000227 | 157.5 | need to distrubute this hrs to above agents  specialy first 8
 | Roaming Refresh | 22.5 | need to automat this sheet befre this we r doing manually
 | Vendor Integration Program | 11.25
 | Non-VATS - Chordiant_BAU | 22.5
 | Skywalker (D2SD) | 22.5
 | LT_UK_MTS_PAS_Capacity_for_USS | 18 |  |  |  |  |  |  |  | 157.5 | 40
 |  |  | please  help it
Spreadsheet: 268786d1380824415-summing-data-by-week-ending-and-category-sumifs-table
Sheet: Budget

Week Ending | Category | Budgeted | Spent | Difference | Column1
2013-09-06 00:00:00 | A | 2500 |  |  | 2916.73
 | B | 180 |  |  | 209.26
 | C | 100
 | D | 1200
 | A | 2500
 | B | 180
 | C | 100
 | D | 1200
 | A | 2500
 | B | 180
 | C | 100
 | D | 1200
 | A | 2500
 | B | 180
 | C | 100
 | D | 1200
 | A | 2500
 | B | 180
 | C | 100
 | D | 1200
 | A | 2500
 | B | 180
 | C | 100
 | D | 1200
 | A | 2500
 | B | 180
 | C | 100
 | D | 1200
 | A | 2500
 | B | 180
 | C | 100
 | D | 1200
 | A | 2500
 | B | 180
 | C | 100
 | D | 1200
 | A | 2500
 | B | 180
 | C | 100
 | D | 1200
 | Total
Spreadsheet: df97c929-c9d6-4bd9-bad6-22e2e70c7a67
Sheet: TTM Recon Q1FY12

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended June 30, 2011
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Licensed Intellectual Property Commitment (COGS) |  | Gain on Strategic Investments |  | Restructuring and other |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 3773 |  | 0 |  | 40 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3813
Cost of revenue | 1517 |  | -12 |  | 0 |  | 1 |  | 0 |  | 0 |  | -2 |  | 0 |  | 1504
Gross profit | 2256 |  | 12 |  | 40 |  | -1 |  | 0 |  | 0 |  | 2 |  | 0 |  | 2309
Operating expenses:
Marketing and sales | 760 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -22 |  | 0 |  | 738
General and administrative | 301 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -37 |  | 0 |  | 264
Research and development | 1163 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -104 |  | 0 |  | 1059
Acquisition-related contingent consideration | -17 |  | 17 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 55 |  | -55 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -
Restructuring and other | 177 |  | 0 |  | 0 |  | 0 |  | 0 |  | -177 |  | 0 |  | 0 |  | -
Total operating expenses | 2439 |  | -38 |  | 0 |  | 0 |  | 0 |  | -177 |  | -163 |  | 0 |  | 2061
Operating income (loss) | -183 |  | 50 |  | 40 |  | -1 |  | 0 |  | 177 |  | 165 |  | 0 |  | 248
Gain on strategic investments | 28 |  | 0 |  | 0 |  | 0 |  | -28 |  | 0 |  | 0 |  | 0 |  | -
Interest and other income, net | 13 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 13
Income (loss) before provision for income taxes | -142 |  | 50 |  | 40 |  | -1 |  | -28 |  | 177 |  | 165 |  | 0 |  | 261
Provision for income taxes | 9 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 64 |  | 73
Net income (loss) | -151 |  | 50 |  | 40 |  | -1 |  | -28 |  | 177 |  | 165 |  | -64 |  | 188
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Diluted | -0.47 |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.57
Spreadsheet: 722765d1615397723-calculation-based-on-data-provided-till-todays-date-query-etaf
Sheet: Sheet1

Input |  |  |  |  | Output
Date | Target | Achieved |  |  | Date | Target Till Date | Achieved Till Date
2021-03-01 00:00:00 | 100 | 100 |  |  | Today date | Sum of target till date | Sum of achieved till date
2021-03-02 00:00:00 | 110 | 90
2021-03-03 00:00:00 | 120 | 110
2021-03-04 00:00:00 | 130 | 130
2021-03-05 00:00:00 | 140 | 160
2021-03-06 00:00:00 | 150 | 80
2021-03-07 00:00:00 | 160 | 160
2021-03-08 00:00:00 | 170 | 170
2021-03-09 00:00:00 | 180 | 180
2021-03-10 00:00:00 | 190
2021-03-11 00:00:00 | 200
2021-03-12 00:00:00 | 210
2021-03-13 00:00:00 | 220
2021-03-14 00:00:00 | 230
2021-03-15 00:00:00 | 240
2021-03-16 00:00:00 | 250
2021-03-17 00:00:00 | 260
2021-03-18 00:00:00 | 270
2021-03-19 00:00:00 | 280
2021-03-20 00:00:00 | 290
Spreadsheet: 838139d1690776263-sumfs-formula-not-giving-correct-results-sumifs-using-wildard-card-to-sum-data-based-on-first-6-characters-in-col-a
Sheet: Summary

85
BQT
V F
CRTY
WT
WET
BL
WB
Spreadsheet: 696517d1600869348-auto-populating-rolling-month-calendar-using-drop-down-lists-calendar-any-month-start
Sheet: CALENDAR

 | SELECT YEAR |  |  |  | 2020 |  |  |  | SELECT MONTH |  |  |  | September |  |  |  | 1st INSP DATE & FREQ wks |  |  |  | 2020-09-11 00:00:00 |  | 6
 | ENTER MOT DATE |  |  |  | 2020-09-30 00:00:00 |  |  |  | 1st SERVICE DATE |  |  |  |  |  |  |  | SELECT SERVICE FREQ mths |  |  |  | 6
 | SAFETY INSPECTION / SERVICE / MOT SCHEDULE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month 3
 | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun
 |  | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  |  | 1 | 2 | 3 | 4
 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30
 | Month 4 |  |  |  |  |  |  |  | Month 5 |  |  |  |  |  |  |  | Month 6
 | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun
 | Month 7 |  |  |  |  |  |  |  | Month 8 |  |  |  |  |  |  |  | Month 9
 | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun
 | Month 10 |  |  |  |  |  |  |  | Month 11 |  |  |  |  |  |  |  | Month 12
 | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun